Android调用Aspnet的WebService实例分析和总结.docxVIP

ANDROID 调用 ASP.NET 的 WEBSERVICE 实例 ASP.Net WebService 程序代码：VS2008 using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Services; using System.Data; using System.Data.SqlClient; namespace RepairWebService { /// summary /// WebService 的摘要说明 /// /summary [WebService(Namespace = /)] [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] [System.ComponentModel.ToolboxItem(false)] // 若要允许使用 ASP.NET AJAX 从脚本中调用此 Web 服务，请取消对下行的注释。 [System.Web.Script.Services.ScriptService] public class WebService : System.Web.Services.WebService { /// summary /// 数据库连接字符串 /// /summary public string connstr = SqlHelper.ConnectionStringLocalTransaction; [WebMethod] public string HelloWorld() { return Hello World; } [WebMethod] public UsersModel GetPwdByName(string name) { UsersModel model = null; string strsql = select * from users where name=+name+; SqlDataReader dr=SqlHelper.ExecuteReader(connstr, CommandType.Text, strsql, null); if (dr.Read()) { model = new UsersModel(); model.Id = dr.GetInt32(0); model.Name = dr.GetString(1); model.Pwd = dr.GetString(2); } return model; } [WebMethod] public ListRepairsModel GetRepairsList() { ListRepairsModel list = new ListRepairsModel(); string str = select * from repairs; SqlDataReader dr = SqlHelper.ExecuteReader(connstr, CommandType.Text, str, null); while (dr.Read()) { RepairsModel model = new RepairsModel(); model.Id = dr.GetInt32(0); model.RepairId = dr.GetString(1); model.RepairName = dr.GetString(2); model.RepairDate = dr.GetDateTime(3); model.RepairStateId = dr.GetInt32(4); model.UserId = dr.GetInt32(5); list.Add(model); } return list; } } } Users 实体类 using System; using System.Collections.Generic; using System.Linq; using System.Web; namespace RepairWebService { public class UsersModel { private int id; public int Id { get { return id; } set { id = value; } } private string name; public string Name { get { return name; } set { name = value; } } private string pwd; public string Pwd { ge