————————————————————————————————————————————————————————————————————————————————————————————————————
Android端代码:
/**
* 获取学院信息
* @return
*/
public String getMenuFaculties(){
METHOD="getFacultyName";
SoapObject rpc = new SoapObject(NAMESPACE, METHOD);
SoapSerializationEnvelope envelope = new SoapSerializationEnvelope(SoapEnvelope.VER12);
envelope.bodyOut=rpc;
envelope.dotNet=true;
HttpTransportSE httpTransportSE = new HttpTransportSE(URL);
httpTransportSE.debug=true;
SOAPACTION="http://tempuri.org/getFacultyName";
try {
httpTransportSE.call(SOAPACTION, envelope);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (XmlPullParserException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
resultObject=envelope.getResponse();
} catch (SoapFault e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
back_data=String.valueOf(resultObject);
return back_data;
}
——————————————————————————————————————————————————————————————————————————————————————————————————————————
C#端代码:
namespace TESTSERVER
{
/// <summary>
/// TESTSERVER 的摘要说明
/// </summary>
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[System.ComponentModel.ToolboxItem(false)]
// 若要允许使用 ASP.NET AJAX 从脚本中调用此 Web 服务,请取消对下行的注释。
// [System.Web.Script.Services.ScriptService]
public class TESTSERVER : System.Web.Services.WebService
{
DataBase db = new DataBase();
String backResult = "";
[WebMethod(Description = "点评")]
public String dianPing(String faculty)
{
String dataChart = "";
String SQLSelect = "select distinct a.COR_NAME,a.COR_STATUS,count(b.MEMBERS_ID) as TOTAL_PERSON"+
" from COR_INFO a"+
" inner join COR_MEMBERS_INFO b"+
" on a.COR_ID=b.COR_ID"+
" where a.FACULTY_CLASS='"+faculty+"'"+
" group by a.COR_NAME,a.COR_STATUS"+
" order by total_person desc";
DataSet dataSet = db.SelectData(SQLSelect);
Json json = new Json();
json.AddItem(dataSet);
dataChart = json.readData();
return dataChart;
Android端代码:
/**
* 获取学院信息
* @return
*/
public String getMenuFaculties(){
METHOD="getFacultyName";
SoapObject rpc = new SoapObject(NAMESPACE, METHOD);
SoapSerializationEnvelope envelope = new SoapSerializationEnvelope(SoapEnvelope.VER12);
envelope.bodyOut=rpc;
envelope.dotNet=true;
HttpTransportSE httpTransportSE = new HttpTransportSE(URL);
httpTransportSE.debug=true;
SOAPACTION="http://tempuri.org/getFacultyName";
try {
httpTransportSE.call(SOAPACTION, envelope);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (XmlPullParserException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
resultObject=envelope.getResponse();
} catch (SoapFault e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
back_data=String.valueOf(resultObject);
return back_data;
}
——————————————————————————————————————————————————————————————————————————————————————————————————————————
C#端代码:
namespace TESTSERVER
{
/// <summary>
/// TESTSERVER 的摘要说明
/// </summary>
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[System.ComponentModel.ToolboxItem(false)]
// 若要允许使用 ASP.NET AJAX 从脚本中调用此 Web 服务,请取消对下行的注释。
// [System.Web.Script.Services.ScriptService]
public class TESTSERVER : System.Web.Services.WebService
{
DataBase db = new DataBase();
String backResult = "";
[WebMethod(Description = "点评")]
public String dianPing(String faculty)
{
String dataChart = "";
String SQLSelect = "select distinct a.COR_NAME,a.COR_STATUS,count(b.MEMBERS_ID) as TOTAL_PERSON"+
" from COR_INFO a"+
" inner join COR_MEMBERS_INFO b"+
" on a.COR_ID=b.COR_ID"+
" where a.FACULTY_CLASS='"+faculty+"'"+
" group by a.COR_NAME,a.COR_STATUS"+
" order by total_person desc";
DataSet dataSet = db.SelectData(SQLSelect);
Json json = new Json();
json.AddItem(dataSet);
dataChart = json.readData();
return dataChart;
}
——————————————————————————————————————————————————————————————
jar包下载:http://download.youkuaiyun.com/detail/tangzhide/9614977
——————————————————————————————————————————————————————————————