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());
}
