private string getAreaList(HttpContext context) { StringBuilder sb = new StringBuilder(); DataSet ds = new DataSet(); StringBuilder strWhere = new StringBuilder(); strWhere.Append(" is_delete != 1"); WK.BLL.bus_area bll = new WK.BLL.bus_area(); ds = bll.GetList(strWhere.ToString()); DataTable dt = new DataTable(); dt.Columns.Add("data", typeof(System.Int32)); dt.Columns.Add("value", typeof(System.String)); if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { int l = ds.Tables[0].Rows.Count; for (int i = 0; i < l; i++) { DataRow row = dt.NewRow(); row["data"] = ds.Tables[0].Rows[i]["id"]; row["value"] = ds.Tables[0].Rows[i]["name"]; dt.Rows.Add(row); } } return(Newtonsoft.Json.JsonConvert.SerializeObject(dt)); }
private string getListCount(HttpContext context) { StringBuilder strWhere = new StringBuilder(); strWhere.Append(" is_delete != 1"); WK.BLL.bus_area bll = new WK.BLL.bus_area(); Record r = new Record(); r.RecordCount = bll.GetListCount(strWhere.ToString()); return(Newtonsoft.Json.JsonConvert.SerializeObject(r)); }
private string getDataList0(HttpContext context) { StringBuilder strWhere = new StringBuilder(); strWhere.Append(" is_delete != 1"); strWhere.AppendFormat(" and parent_id = 0"); WK.BLL.bus_area bll = new WK.BLL.bus_area(); DataSet ds = new DataSet(); ds = bll.GetListByPageInfo(strWhere.ToString(), "", 0, 100); return(Newtonsoft.Json.JsonConvert.SerializeObject(ds.Tables[0])); }
private string getDataDetail(HttpContext context) { string id = ""; if (context.Request.Params["id"] != null) { id = context.Request.Params["id"]; } WK.BLL.bus_area bll = new WK.BLL.bus_area(); WK.Model.bus_area model = bll.GetModel(int.Parse(id)); return(Newtonsoft.Json.JsonConvert.SerializeObject(model)); }
private string deleteData(HttpContext context) { ReturnInfo returnInfo = new ReturnInfo(); returnInfo.isSuccess = false; WK.BLL.bus_area bll = new WK.BLL.bus_area(); int id = int.Parse(context.Request.Params["id"]); if (id > 0) { WK.Model.bus_area model = bll.GetModel(id); model.is_delete = 1; returnInfo.isSuccess = bll.Update(model); } return(Newtonsoft.Json.JsonConvert.SerializeObject(returnInfo)); }
private string editData(HttpContext context) { WK.Model.bus_area model = new Model.bus_area(); model.id = 0; if (context.Request.Params["id"].ToString() != "") { model.id = int.Parse(context.Request.Params["id"]); } model.area_type = 1;// int.Parse(context.Request.Params["area_type"]); model.lat = decimal.Parse(context.Request.Params["lat"]); model.lon = decimal.Parse(context.Request.Params["lon"]); model.name = context.Request.Params["name"]; model.parent_id = int.Parse(context.Request.Params["parent_id"]); //model.remark = context.Request.Params["remark"]; WK.BLL.bus_area bll = new WK.BLL.bus_area(); ReturnInfo returnInfo = new ReturnInfo(); returnInfo.isSuccess = model.id > 0 ? bll.Update(model) : bll.Add(model); return(Newtonsoft.Json.JsonConvert.SerializeObject(returnInfo)); }
private string getDataList(HttpContext context) { StringBuilder strWhere = new StringBuilder(); strWhere.Append(" is_delete != 1"); StringBuilder orderby = new StringBuilder(); orderby.Append("parent_id,id"); int pageIndex = int.Parse(context.Request.Params["pageIndex"]); int pageSize = int.Parse(context.Request.Params["pageSize"]); int startIndex = 0; if (pageIndex >= 0) { startIndex = pageSize * pageIndex; } WK.BLL.bus_area bll = new WK.BLL.bus_area(); DataSet ds = new DataSet(); ds = bll.GetListByPageInfo(strWhere.ToString(), orderby.ToString(), startIndex, pageSize); return(Newtonsoft.Json.JsonConvert.SerializeObject(ds.Tables[0])); }