public DataSet GetComboCity()
{
CityTableAdapter a = new CityTableAdapter();
DataSet ds = new DataSet();
ds.Tables.Add(a.GetData());
return(ds);
}
public bool GetArrivalCitiesByDeparture(string departure, out DataTable table)
{
table = null;
if (_paymentClient.isPayed(_serviceId, _company))
{
table = new CityTableAdapter().GetArrivalCitiesByDeparture(departure);
return(true);
}
return(false);
}
public bool GetFlightsCities(out DataTable table)
{
table = null;
if (_paymentClient.isPayed(_serviceId, _company))
{
var adater = new CityTableAdapter();
table = adater.GetFlightCities();
return(true);
}
return(false);
}
public bool InsertCity(string Name, int CountryID, string usr, string pass)
{
if (authenticate(usr, pass, 22) == false)
{
return(false);
}
try
{
CityTableAdapter u = new CityTableAdapter();
u.Insert(Name, CountryID);
}
catch (Exception e) { return(false); }
return(true);
}
public bool UpdateCity(string Name, int CountryID, int Original_ID, string usr, string pass)
{
if (authenticate(usr, pass, 23) == false)
{
return(false);
}
try
{
CityTableAdapter u = new CityTableAdapter();
u.UpdateQuery(Name, CountryID, Original_ID);
}
catch (Exception e) { return(false); }
return(true);
}
public bool DeleteCity(int Original_ID, string usr, string pass)
{
if (authenticate(usr, pass, 21) == false)
{
return(false);
}
try
{
CityTableAdapter u = new CityTableAdapter();
u.DeleteQuery(Original_ID);
}
catch (Exception e) { return(false); }
return(true);
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
int proId = int.Parse(context.Request["Proid"] ?? "0");
CityTableAdapter adapter = new CityTableAdapter();
Demo.省市联动Demo.ProvinceDataSet.CityDataTable table = adapter.GetCityByProID(proId);
#region 拼接字符构造JSON字符串
//StringBuilder sb = new StringBuilder();
//sb.Append("[");
//foreach (var item in table)
//{
// sb.Append("{");
// sb.Append("\"CityID\":\""+item.CityID+"\",");
// sb.Append("\"CityName\":\"" + item.CityName + "\"");
// sb.Append("},");
//}
//string resultStr = sb.ToString().TrimEnd(',');
//resultStr += "]";
//前端要求JSON对象,那么在这里序列化成JSON
//System.Web.Script.Serialization.JavaScriptSerializer jss = new System.Web.Script.Serialization.JavaScriptSerializer();
//context.Response.Write(jss.Serialize(resultStr));
#endregion
#region 用对象集合序列化出JSON字符串
List<City> citylist = new List<City>();
foreach (var item in table)
{
citylist.Add(new City
{
CityID = item.CityID,
CityName = item.CityName
});
}
System.Web.Script.Serialization.JavaScriptSerializer jsSer = new System.Web.Script.Serialization.JavaScriptSerializer();
context.Response.Write(jsSer.Serialize(citylist));
#endregion
}
