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 }