public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
Model.BaseUser bu = (Model.BaseUser)context.Session["login"];
if (bu == null)
{
context.Response.Write("登录超时，请重新登录。");
return;
}
string type = context.Request["type"];
DataTable dt = new DataTable();
StringBuilder sb = new StringBuilder();
DBUtility.JsonHelper jsHelper = new DBUtility.JsonHelper();
switch (type)
{
case "dept_comb":
dt = new BLL.BaseDepartment().GetList("1=1").Tables[0];
sb.Append(DBUtility.JsonHelper.DataTable2Json_Combo(dt));
break;
case "role_comb":
dt = new BLL.BaseRole().GetList("1=1").Tables[0];
sb.Append(DBUtility.JsonHelper.DataTable2Json_Combo(dt));
break;
case "dept_tree":
dt = new BLL.BaseDepartment().GetList("1=1 order by ParentDeptID").Tables[0];
sb.Append(jsHelper.DataTable2Json_Tree(dt, "DeptID", "DeptName", "ParentDeptID", 0, "closed", ""));
break;
case "dept_tree_open":
dt = new BLL.BaseDepartment().GetList("1=1 order by ParentDeptID").Tables[0];
sb.Append(jsHelper.DataTable2Json_Tree(dt, "DeptID", "DeptName", "ParentDeptID", 0, "open", ""));
break;
case "rft_comb":
dt = new BLL.request_form_type().GetList("1=1").Tables[0];
sb.Append(DBUtility.JsonHelper.DataTable2Json_Combo(dt));
break;
case "nodeType_comb":
dt = new BLL.node_type().GetList("1=1").Tables[0];
sb.Append(DBUtility.JsonHelper.DataTable2Json_Combo(dt));
break;
case "banding_comb":
dt = new BLL.approve_role().GetList("1=1 order by role_level asc").Tables[0];
sb.Append(DBUtility.JsonHelper.DataTable2Json_Combo(dt));
break;
case "form_comb":
dt = new BLL.request_form().GetList("1=1").Tables[0];
sb.Append(DBUtility.JsonHelper.DataTable2Json_Combo(dt));
break;
case "role_tree":
dt = new BLL.BaseMenu().GetList("1=1").Tables[0];
sb.Append(jsHelper.DataTable2Json_Tree(dt, "MenuID", "MenuName", "ParentMenuID", "0", "", ""));
break;
case "dept_users":
dt = new BLL.Common().GetList("select UserName,Name from baseuser where deptid in (select * from dbo.getTable(dbo.getdeptids_zxf('" + context.Request["deptid"] + "'),','))").Tables[0];
sb.Append(DBUtility.JsonHelper.DataTable2Json_Combo(dt));
break;
case "get_users":
dt = new BLL.Common().GetList("select UserName,Name from baseuser where Permissions=1 order by name ").Tables[0];
sb.Append(DBUtility.JsonHelper.DataTable2Json_Combo(dt));
break;
case "get_stage":
dt = new BLL.Common().GetList("select sid,stage_name from stage").Tables[0];
sb.Append(DBUtility.JsonHelper.DataTable2Json_Combo(dt));
break;
case "product_Series":
dt = new BLL.Common().GetList("select ID,Name from ProductSeries ").Tables[0];
sb.Append(DBUtility.JsonHelper.DataTable2Josn(dt));
break;
case "product_ValuationMethods":
dt = new BLL.Common().GetList("select ID,Name from ProductPriceMethods ").Tables[0];
sb.Append(DBUtility.JsonHelper.DataTable2Josn(dt));
break;
case "product_Unit":
dt = new BLL.Common().GetList("select ID as ID,UnitName as Name from dbo.ProductUnit ").Tables[0];
sb.Append(DBUtility.JsonHelper.DataTable2Josn(dt));
break;
case "product_Manufacturer":
dt = new BLL.Common().GetList("select ID,FullName as Name from Supplier order by FullName ").Tables[0];
sb.Append(DBUtility.JsonHelper.DataTable2Josn(dt));
break;
case "productType":
dt = new BLL.ProductType().GetList("1=1").Tables[0];
sb.Append("[{\"id\":\"28\",\"text\":\"地毯\",\"state\":\"\",\"children\":[{\"id\":\"29\",\"text\":\"羊毛地毯\",\"state\":\"\",\"children\":[{\"id\":\"43\",\"text\":\"1\",\"state\":\"\"}]},{\"id\":\"30\",\"text\":\"麻质地毯\",\"state\":\"\"},{\"id\":\"31\",\"text\":\"棉地毯\",\"state\":\"\"},{\"id\":\"32\",\"text\":\"丝质地毯\",\"state\":\"\"}]},{\"id\":\"33\",\"text\":\"布艺成品\",\"state\":\"\",\"children\":[{\"id\":\"34\",\"text\":\"布帘\",\"state\":\"\"},{\"id\":\"35\",\"text\":\"香格里拉帘\",\"state\":\"\",\"children\":[{\"id\":\"36\",\"text\":\"透光香格里拉帘\",\"state\":\"\"},{\"id\":\"37\",\"text\":\"半透光香格里拉帘\",\"state\":\"\"},{\"id\":\"38\",\"text\":\"全遮光香格里拉帘\",\"state\":\"\"}]},{\"id\":\"39\",\"text\":\"风琴帘\",\"state\":\"\",\"children\":[{\"id\":\"40\",\"text\":\"透光风琴帘\",\"state\":\"\"},{\"id\":\"41\",\"text\":\"半透光风琴帘\",\"state\":\"\"},{\"id\":\"42\",\"text\":\"全遮光风琴帘\",\"state\":\"\"}]}]}]");
break;
case "work_users":
dt = new BLL.Common().GetList("select UserName,Name from baseuser where UserName in (select implementer_sid from project_work_implement where psi_sid in (select sid from project_specific_item where s_sid =" + context.Request["pssid"] + "))").Tables[0];
sb.Append(DBUtility.JsonHelper.DataTable2Json_Combo(dt));
break;
case "getProject":
dt = new BLL.Common().GetList("select sid,project_name name from project").Tables[0];
DataRow dr = dt.NewRow();
dr[0] = "0";
dr[1] = "所有";
dt.Rows.InsertAt(dr, 0);
sb.Append(DBUtility.JsonHelper.DataTable2Json_Combo(dt));
break;
case "getSpace":
string psid = context.Request["pid"] == null ? "" : context.Request["pid"].Trim();
psid = psid == "" ? "0" : psid;
dt = new BLL.Common().GetList("select sid, name from project_Space where p_sid='" + psid + "' and ischild=0").Tables[0];
dr = dt.NewRow();
dr[0] = "0";
dr[1] = "所有";
dt.Rows.InsertAt(dr, 0);
sb.Append(DBUtility.JsonHelper.DataTable2Json_Combo(dt));
break;
case "getPlace":
psid = context.Request["pid"] == null ? "" : context.Request["pid"].Trim();
psid = psid == "undefined" ? "0" : psid;
dt = new BLL.Common().GetList("select sid, name from project_Space where parentID='" + psid + "' and ischild=1").Tables[0];
dr = dt.NewRow();
dr[0] = "0";
dr[1] = "所有";
dt.Rows.InsertAt(dr, 0);
sb.Append(DBUtility.JsonHelper.DataTable2Json_Combo(dt));
break;
case "getDic":
dt = new BLL.Common().GetList("select Value,Caption Text from BaseDictionaryDetail where CatgID='" + context.Request["catg"] + "'").Tables[0];
sb.Append(DBUtility.JsonHelper.DataTable2Json_Combo(dt));
break;
default:
break;
}
context.Response.Write(sb.ToString());
}
private string GetApprove_roleComboBox()
{
DataTable dt = new BLL.approve_role().GetList(" 1=1 ").Tables[0];
return(DBUtility.JsonHelper.DataTable2Json_ValueText(dt, "sid", "role_name"));
}
