public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; HttpRequest request = context.Request; BLL.Param_City pc = new BLL.Param_City(); Model.Param_City model = new Model.Param_City(); if (request["Action"] == "treegrid") { DataSet ds = pc.GetAllList(); string dt = "{Rows:[" + GetTasksString(0, ds.Tables[0]) + "]}"; context.Response.Write(dt); } if (request["Action"] == "tree") { DataSet ds = pc.GetAllList(); StringBuilder str = new StringBuilder(); str.Append("["); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { str.Append("{id:" + ds.Tables[0].Rows[i]["id"].ToString() + ",pid:" + ds.Tables[0].Rows[i]["parentid"].ToString() + ",text:'" + ds.Tables[0].Rows[i]["City"] + "'},"); } str.Replace(",", "", str.Length - 1, 1); str.Append("]"); context.Response.Write(str); } //save if (request["Action"] == "save") { model.City = Common.PageValidate.InputText(request["T_City"], 255); string pid = request["T_Parent_val"]; if (string.IsNullOrEmpty(pid)) { pid = "0"; } model.parentid = int.Parse(pid); string id = PageValidate.InputText(request["id"], 50); if (!string.IsNullOrEmpty(id) && id != "null") { model.id = int.Parse(id); pc.Update(model); } else { pc.Add(model); } } //Form JSON if (request["Action"] == "form") { DataSet ds = pc.GetList("id=" + int.Parse(request["id"])); string dt = Common.DataToJson.DataToJSON(ds); context.Response.Write(dt); } //del if (request["Action"] == "del") { string c_id = PageValidate.InputText(request["id"], 50); DataSet ds = pc.GetList(" parentid=" + int.Parse(c_id)); BLL.CRM_Customer cus = new BLL.CRM_Customer(); DataSet ds1 = cus.GetList(string.Format("Provinces_id={0} or City_id={0}", int.Parse(c_id))); if (ds.Tables[0].Rows.Count > 0) { context.Response.Write("false:parent"); } else if (ds1.Tables[0].Rows.Count > 0) { context.Response.Write("false:customer"); } else { bool isdel = pc.Delete(int.Parse(c_id)); if (isdel) { context.Response.Write("true"); } else { context.Response.Write("false"); } } } if (request["Action"] == "combo") { DataSet ds = pc.GetList("parentid=0"); StringBuilder str = new StringBuilder(); str.Append("["); str.Append("{id:0,text:'无'},"); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { str.Append("{id:" + ds.Tables[0].Rows[i]["id"].ToString() + ",text:'" + ds.Tables[0].Rows[i]["City"] + "'},"); } str.Replace(",", "", str.Length - 1, 1); str.Append("]"); context.Response.Write(str); } if (request["Action"] == "combo1") { DataSet ds = pc.GetList("parentid=0"); StringBuilder str = new StringBuilder(); str.Append("["); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { str.Append("{id:" + ds.Tables[0].Rows[i]["id"].ToString() + ",text:'" + ds.Tables[0].Rows[i]["City"] + "'},"); } str.Replace(",", "", str.Length - 1, 1); str.Append("]"); context.Response.Write(str); } if (request["Action"] == "combo2") { DataSet ds = pc.GetList("parentid=" + int.Parse(request["pid"])); StringBuilder str = new StringBuilder(); str.Append("["); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { str.Append("{id:" + ds.Tables[0].Rows[i]["id"].ToString() + ",text:'" + ds.Tables[0].Rows[i]["City"] + "'},"); } str.Replace(",", "", str.Length - 1, 1); str.Append("]"); context.Response.Write(str); } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; HttpRequest request = context.Request; BLL.Param_City pc = new BLL.Param_City(); Model.Param_City model = new Model.Param_City(); if (request["Action"] == "treegrid") { DataSet ds = pc.GetAllList(); string dt = "{Rows:[" + GetTasksString(0, ds.Tables[0]) + "]}"; context.Response.Write(dt); } if (request["Action"] == "tree") { DataSet ds = pc.GetAllList(); StringBuilder str = new StringBuilder(); str.Append("["); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { str.Append("{id:" + ds.Tables[0].Rows[i]["id"].ToString() + ",pid:" + ds.Tables[0].Rows[i]["parentid"].ToString() + ",text:'" + ds.Tables[0].Rows[i]["City"] + "'},"); } str.Replace(",", "", str.Length - 1, 1); str.Append("]"); context.Response.Write(str); } //save if (request["Action"] == "save") { model.City = Common.PageValidate.InputText(request["T_City"], 255); string pid = request["T_Parent_val"]; if (string.IsNullOrEmpty(pid)) { pid = "0"; } model.parentid = int.Parse(pid); string id = request["id"]; if (!string.IsNullOrEmpty(id) && id != "null") { model.id = int.Parse(id); pc.Update(model); } else { pc.Add(model); } } //Form JSON if (request["Action"] == "form") { DataSet ds = pc.GetList("id=" + int.Parse( request["id"])); string dt = Common.DataToJson.DataToJSON(ds); context.Response.Write(dt); } //del if (request["Action"] == "del") { string c_id = request["id"]; DataSet ds = pc.GetList(" parentid=" + int.Parse(c_id)); if (ds.Tables[0].Rows.Count > 0) { context.Response.Write("false:parent"); } else { bool isdel = pc.Delete(int.Parse(c_id)); if (isdel) { context.Response.Write("true"); } else { context.Response.Write("false"); } } } if (request["Action"] == "combo") { DataSet ds = pc.GetList("parentid=0"); StringBuilder str = new StringBuilder(); str.Append("["); str.Append("{id:0,text:'无'},"); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { str.Append("{id:" + ds.Tables[0].Rows[i]["id"].ToString() + ",text:'" + ds.Tables[0].Rows[i]["City"] + "'},"); } str.Replace(",", "", str.Length - 1, 1); str.Append("]"); context.Response.Write(str); } if (request["Action"] == "combo1") { DataSet ds = pc.GetList("parentid=0"); StringBuilder str = new StringBuilder(); str.Append("["); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { str.Append("{id:" + ds.Tables[0].Rows[i]["id"].ToString() + ",text:'" + ds.Tables[0].Rows[i]["City"] + "'},"); } str.Replace(",", "", str.Length - 1, 1); str.Append("]"); context.Response.Write(str); } if (request["Action"] == "combo2") { DataSet ds = pc.GetList("parentid=" + int.Parse( request["pid"])); StringBuilder str = new StringBuilder(); str.Append("["); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { str.Append("{id:" + ds.Tables[0].Rows[i]["id"].ToString() + ",text:'" + ds.Tables[0].Rows[i]["City"] + "'},"); } str.Replace(",", "", str.Length - 1, 1); str.Append("]"); context.Response.Write(str); } }