protected void Page_Load(object sender, EventArgs e) { try { if (!Page.IsPostBack) { string rfsid = Request.Params["rfsid"].Trim(); type = Request.Params["action"].Trim(); hrfsid.Value = rfsid; haction.Value = type; //type1.Value = type; Model.BaseUser bu = (Model.BaseUser)Session["login"]; DataTable dt = new BLL.flow_master().GetList(" rf_sid=" + rfsid + " and dept_sid like '%," + bu.DeptID + ",%' and post_sid like '%," + bu.ApprRole + ",%'").Tables[0]; flow_ddl.DataSource = dt; flow_ddl.DataValueField = "sid"; flow_ddl.DataTextField = "flow_name"; flow_ddl.DataBind(); Model.request_form model = new BLL.request_form().GetModel(int.Parse(rfsid)); switch (type) { case "add": show.Visible = false; split.Visible = false; GetFormContent(model == null ? "" : model.content_str); flow_name.Text = DBUtility.DbHelperSQL.GetSingle("select dbo.getDeptName('" + bu.DeptID + "')").ToString().Trim() + " " + bu.Name.Trim() + "<" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + ">" + model.form_name.Trim(); break; case "copy": show.Visible = false; split.Visible = false; SetValue(); flow_name.Text = DBUtility.DbHelperSQL.GetSingle("select dbo.getDeptName('" + bu.DeptID + "')").ToString().Trim() + " " + bu.Name.Trim() + "<" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + ">" + model.form_name.Trim(); isVal.Checked = false; break; case "update": show.Visible = false; split.Visible = false; SetValue(); break; case "view": split.Visible = false; submit.Visible = false; SetValue(); break; default: break; } GetNode(); } } catch { } }
public string Update(HttpContext context) { string sid = context.Request.Params["sid"].Trim(); Model.request_form model = new BLL.request_form().GetModel(int.Parse(sid)); string formName = context.Request.Params["form_name"].Trim(); string formType = context.Request.Params["form_type"].Trim(); string isVal = context.Request.Params["hval"].Trim(); string remark = context.Request.Params["remark"].Trim(); string content = context.Server.HtmlEncode(context.Request.Params["content1"].Trim()); model.form_name = formName; model.rft_sid = int.Parse(formType); model.rf_status = int.Parse(isVal); model.remark = remark; model.content_str = content; return(new BLL.request_form().Update(model)); }
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()); }