public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; HttpRequest request = context.Request; BLL.hr_post post = new BLL.hr_post(); Model.hr_post model = new Model.hr_post(); BLL.hr_employee emp = new BLL.hr_employee(); Model.hr_employee modelemp = new Model.hr_employee(); int emp_id = int.Parse(request.Cookies["UserID"].Value.ToString()); DataSet dsemp = emp.GetList("id=" + emp_id); string empname = dsemp.Tables[0].Rows[0]["name"].ToString(); string uid = dsemp.Tables[0].Rows[0]["uid"].ToString(); if (request["Action"] == "grid") { int depid = Common.PageValidate.IsNumber(request["depid"]) ? int.Parse(request["depid"]) : 0; string emps = request["empstatus"]; int empstuats = 0; if (!string.IsNullOrEmpty(emps)) { empstuats = Common.PageValidate.IsNumber(request["empstatus"]) ? int.Parse(request["empstatus"]) : 0; } string wherestr = " and "; switch (empstuats) { case 0: wherestr += "1=1"; break; case 1: wherestr += "emp_id=-1"; break; case 2: wherestr += "emp_id!=-1"; break; } DataSet ds = post.GetList(0, " ISNULL(isDelete,0)=0 and dep_id=" + depid + wherestr, " convert(int,isnull(0,[position_order]))"); string dt = Common.GetGridJSON.DataTableToJSON(ds.Tables[0]); context.Response.Write(dt); } if (request["Action"] == "delgrid") { DataSet ds = post.GetList(0, " ISNULL(isDelete,0)=1 ", " convert(int,isnull(0,[position_order]))"); string dt = Common.GetGridJSON.DataTableToJSON(ds.Tables[0]); context.Response.Write(dt); } if (request["Action"] == "save") { //dep model.dep_id = int.Parse(request["T_depname_val"]); model.depname = Common.PageValidate.InputText(request["T_depname"], 250); //name model.post_name = Common.PageValidate.InputText(request["T_postname"], 250); //position model.position_id = int.Parse(request["T_position_val"]); model.position_name = Common.PageValidate.InputText(request["T_position"], 250); model.position_order = Common.PageValidate.InputText(request["T_position_leavel"], 50); //emp int empid = Common.PageValidate.IsNumber(request["T_emp_val"]) ? int.Parse(request["T_emp_val"]) : -1; model.emp_id = empid; model.emp_name = Common.PageValidate.InputText(request["T_emp"], 250); //note model.note = Common.PageValidate.InputText(request["T_descript"], 4000); string postid = request["postid"]; if (!string.IsNullOrEmpty(postid) && postid != "null") { model.post_id = int.Parse(postid); DataSet ds = post.GetList(" post_id=" + int.Parse(postid)); DataRow dr = ds.Tables[0].Rows[0]; post.Update(model); //日志 C_Sys_log log = new C_Sys_log(); int UserID = emp_id; string UserName = empname; string IPStreet = request.UserHostAddress; string EventTitle = model.position_name; string EventType = "岗位修改"; int EventID = model.post_id; if (dr["post_name"].ToString() != request["T_postname"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "岗位名称", dr["post_name"].ToString(), request["T_postname"]); } if (dr["position_name"].ToString() != request["T_position"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "岗位级别", dr["position_name"].ToString(), request["T_position"]); } if (dr["emp_name"].ToString() != request["T_emp"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "岗位员工", dr["emp_name"].ToString(), request["T_emp"]); } if (dr["note"].ToString() != request["T_descript"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "描述", dr["note"].ToString(), request["T_descript"]); } } else { post.Add(model); } } //Form JSON if (request["Action"] == "form") { int postid = int.Parse(request["postid"]); BLL.hr_post hp = new BLL.hr_post(); DataSet ds = hp.GetList("post_id=" + postid); string dt = Common.DataToJson.DataToJSON(ds); context.Response.Write(dt); } //del if (request["Action"] == "AdvanceDelete") { string postid = request["id"]; string EventType = "岗位预删除"; DataSet ds = post.GetList(" post_id=" + int.Parse(postid)); if (emp.GetList(" postid=" + int.Parse(postid)).Tables[0].Rows.Count > 0) { //含有员工信息不能删除 context.Response.Write("false:emp"); } else { bool isdel = post.AdvanceDelete(int.Parse(postid), 1, DateTime.Now.ToString(StaticStr.yyyy_MM_dd_HH_mm_ss)); if (isdel) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { int UserID = emp_id; string UserName = empname; string IPStreet = request.UserHostAddress; int EventID = int.Parse(postid); string EventTitle = ds.Tables[0].Rows[i]["post_name"].ToString(); string Original_txt = null; string Current_txt = null; C_Sys_log log = new C_Sys_log(); log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, null, Original_txt, Current_txt); } context.Response.Write("true"); } else { context.Response.Write("false"); } } } if (request["Action"] == "regain") { string idlist = Common.PageValidate.InputText(request["idlist"], 100000); string[] arr = idlist.Split(','); DataSet ds = post.GetList("post_id in (" + idlist.Trim() + ")"); for (int i = 0; i < arr.Length; i++) { post.AdvanceDelete(int.Parse(arr[i]), 0, DateTime.Now.ToString(StaticStr.yyyy_MM_dd_HH_mm_ss)); } if (true) { //日志 string EventType = "恢复删除岗位"; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { int UserID = emp_id; string UserName = empname; int EventID = idlist[i]; string IPStreet = request.UserHostAddress; string EventTitle = ds.Tables[0].Rows[i]["post_name"].ToString(); string Original_txt = null; string Current_txt = null; C_Sys_log log = new C_Sys_log(); log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, null, Original_txt, Current_txt); } context.Response.Write("true"); } } if (request["Action"] == "del") { bool canDel = false; if (dsemp.Tables[0].Rows.Count > 0) { if (dsemp.Tables[0].Rows[0]["uid"].ToString() == "admin") { canDel = true; } else { Data.GetAuthorityByUid getauth = new Data.GetAuthorityByUid(); string delauth = getauth.GetBtnAuthority(request.Cookies["UserID"].Value, "82"); if (delauth == "false") { canDel = false; } else { canDel = true; } } } if (canDel) { string idlist = Common.PageValidate.InputText(request["idlist"], 1000000); string[] arr = idlist.Split(','); string EventType = "彻底删除岗位"; DataSet ds = post.GetList("post_id in (" + idlist.Trim() + ")"); for (int i = 0; i < arr.Length; i++) { post.Delete(int.Parse(arr[i])); } if (true) { //日志 for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { int UserID = emp_id; string UserName = empname; string IPStreet = request.UserHostAddress; int EventID = idlist[i]; string EventTitle = ds.Tables[0].Rows[0]["post_name"].ToString(); string Original_txt = null; string Current_txt = null; C_Sys_log log = new C_Sys_log(); log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, null, Original_txt, Current_txt); } context.Response.Write("true"); } } else { context.Response.Write("auth"); } } //get post by empid if (request["Action"] == "getpostbyempid") { BLL.hr_post hp = new BLL.hr_post(); int empid = int.Parse(request["empid"]); DataSet ds = hp.GetList(" ISNULL(isDelete,0)=0 and emp_id=" + empid); if (ds.Tables[0].Rows.Count > 0) { string dt = Common.GetGridJSON.DataTableToJSON(ds.Tables[0]); context.Response.Write(dt); } } //serch if (request["Action"] == "serch") { BLL.hr_post hp = new BLL.hr_post(); string serchtxt = Common.PageValidate.InputText(request["Serchtext"], 255); DataSet ds = hp.GetList(" ISNULL(isDelete,0)=0 and post_name like N'%" + serchtxt + "%'"); if (ds.Tables[0].Rows.Count > 0) { string dt = Common.GetGridJSON.DataTableToJSON(ds.Tables[0]); context.Response.Write(dt); } else { context.Response.Write("post_name like N'%" + serchtxt + "%'"); } } //post_emp if (request["Action"] == "postemp") { string json = request["PostData"].ToLower(); JavaScriptSerializer js = new JavaScriptSerializer(); PostData[] postdata; postdata = js.Deserialize <PostData[]>(json); BLL.hr_post hp = new BLL.hr_post(); string empid = request["empid"]; int Eid = -1; if (!string.IsNullOrEmpty(empid)) { Eid = Common.PageValidate.IsNumber(empid) ? int.Parse(empid) : -1; } model.emp_id = Eid; modelemp.ID = Eid; model.emp_name = Common.PageValidate.InputText(request["emp_name"], 255); for (int i = 0; i < postdata.Length; i++) { model.post_id = postdata[i].Post_id; model.default_post = postdata[i].Default_post; if (postdata[i].Default_post == 1) { modelemp.d_id = postdata[i].Dep_id; modelemp.dname = postdata[i].Depname; modelemp.zhiwuid = postdata[i].Position_id; modelemp.zhiwu = postdata[i].Position_name; modelemp.postid = postdata[i].Post_id; modelemp.post = postdata[i].Post_name; //context.Response.Write(postdata[i].Depname + "@"); emp.UpdatePost(modelemp); } hp.UpdatePostEmp(model); } } //combo if (request["Action"] == "combo") { int postid = int.Parse(request["postid"]); DataSet ds = post.GetList(" ISNULL(isDelete,0)=0 and dep_id=" + postid); 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]["post_id"].ToString() + ",text:'" + ds.Tables[0].Rows[i]["post_name"] + "'},"); } 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.hr_post post = new BLL.hr_post(); Model.hr_post model = new Model.hr_post(); BLL.hr_employee emp = new BLL.hr_employee(); Model.hr_employee modelemp = new Model.hr_employee(); int emp_id = int.Parse(request.Cookies["UserID"].Value.ToString()); DataSet dsemp = emp.GetList("id=" + emp_id); string empname = dsemp.Tables[0].Rows[0]["name"].ToString(); string uid = dsemp.Tables[0].Rows[0]["uid"].ToString(); if (request["Action"] == "grid") { string depid = request["depid"]; string emps = request["empstatus"]; int empstuats = 0; if (!string.IsNullOrEmpty(emps)) { empstuats = Common.PageValidate.IsNumber(request["empstatus"]) ? int.Parse(request["empstatus"]) : 0; } string serchtxt = ""; switch (empstuats) { case 0: serchtxt += "1=1 "; break; case 1: serchtxt += "emp_id=-1 "; break; case 2: serchtxt += "emp_id!=-1 "; break; } if (!string.IsNullOrEmpty(depid) && depid != "null") serchtxt += " and dep_id=" + int.Parse(depid); string serchtype = request["isdel"]; if (serchtype == "1") serchtxt += " and isDelete=1"; else serchtxt += " and isDelete=0 "; DataSet ds = post.GetList(0, serchtxt, " convert(int,[position_order])"); string dt = Common.GetGridJSON.DataTableToJSON(ds.Tables[0]); context.Response.Write(dt); } if (request["Action"] == "save") { //dep model.dep_id = int.Parse(request["T_depname_val"]); model.depname = Common.PageValidate.InputText(request["T_depname"], 250); //name model.post_name = Common.PageValidate.InputText(request["T_postname"], 250); //position model.position_id = int.Parse(request["T_position_val"]); model.position_name = Common.PageValidate.InputText(request["T_position"], 250); model.position_order = Common.PageValidate.InputText(request["T_position_leavel"], 50); //emp int empid = Common.PageValidate.IsNumber(request["T_emp_val"]) ? int.Parse(request["T_emp_val"]) : -1; model.emp_id = empid; model.emp_name = Common.PageValidate.InputText(request["T_emp"], 250); //note model.note = Common.PageValidate.InputText(request["T_descript"], 4000); //更新员工岗位 modelemp.d_id = model.dep_id; modelemp.dname = model.depname; modelemp.post = model.post_name; modelemp.zhiwuid = model.position_id; modelemp.zhiwu = model.position_name; modelemp.ID = empid; string postid = request["postid"]; if (!string.IsNullOrEmpty(postid) && postid != "null") { model.post_id = int.Parse(postid); DataSet ds = post.GetList(" post_id=" + int.Parse(postid)); DataRow dr = null; if (ds.Tables[0].Rows.Count > 0) { dr = ds.Tables[0].Rows[0]; //判断默认岗位 if (model.emp_id == -1) { model.default_post = 0; } else { DataSet ds1 = post.GetList(string.Format("default_post=1 and emp_id={0} and post_id!={1}", model.emp_id, int.Parse(postid))); if (ds1.Tables[0].Rows.Count > 0) model.default_post = 0; //此员工有默认岗位 else { model.default_post = 1; //设置此岗位为此员工默认岗位 //更新员工岗位 modelemp.postid = model.post_id; emp.UpdatePost(modelemp); } } } post.Update(model); //日志 C_Sys_log log = new C_Sys_log(); int UserID = emp_id; string UserName = empname; string IPStreet = request.UserHostAddress; string EventTitle = model.position_name; string EventType = "岗位修改"; int EventID = model.post_id; if (dr["post_name"].ToString() != request["T_postname"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "岗位名称", dr["post_name"].ToString(), request["T_postname"]); } if (dr["position_name"].ToString() != request["T_position"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "岗位级别", dr["position_name"].ToString(), request["T_position"]); } if (dr["emp_name"].ToString() != request["T_emp"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "岗位员工", dr["emp_name"].ToString(), request["T_emp"]); } if (dr["note"].ToString() != request["T_descript"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "描述", dr["note"].ToString(), request["T_descript"]); } } else { model.isDelete = 0; postid= post.Add(model).ToString(); //判断默认岗位 if (model.emp_id == -1) { model.default_post = 0; } else { DataSet ds1 = post.GetList(string.Format("default_post=1 and emp_id={0} and post_id!={1}", model.emp_id, int.Parse(postid))); if (ds1.Tables[0].Rows.Count > 0) model.default_post = 0; //此员工有默认岗位 else { model.default_post = 1; //设置此岗位为此员工默认岗位 //更新员工岗位 modelemp.postid = int.Parse(postid); emp.UpdatePost(modelemp); } } post.UpdatePostEmp(model); } } //Form JSON if (request["Action"] == "form") { int postid = int.Parse(request["postid"]); BLL.hr_post hp = new BLL.hr_post(); DataSet ds = hp.GetList("post_id=" + postid); string dt = Common.DataToJson.DataToJSON(ds); context.Response.Write(dt); } //del if (request["Action"] == "AdvanceDelete") { string postid = request["id"]; string EventType = "岗位预删除"; DataSet ds = post.GetList(" post_id=" + int.Parse(postid)); if (ds.Tables[0].Rows[0]["emp_id"].ToString()!="-1") { //含有员工信息不能删除 context.Response.Write("false:emp"); } else { bool isdel = post.AdvanceDelete(int.Parse(postid), 1, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); if (isdel) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { int UserID = emp_id; string UserName = empname; string IPStreet = request.UserHostAddress; int EventID = int.Parse(postid); string EventTitle = ds.Tables[0].Rows[i]["post_name"].ToString(); string Original_txt = null; string Current_txt = null; C_Sys_log log = new C_Sys_log(); log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, null, Original_txt, Current_txt); } context.Response.Write("true"); } else { context.Response.Write("false"); } } } if (request["Action"] == "regain") { string idlist = Common.PageValidate.InputText(request["idlist"], 100000); string[] arr = idlist.Split(','); DataSet ds = post.GetList("post_id in (" + idlist.Trim() + ")"); for (int i = 0; i < arr.Length; i++) { post.AdvanceDelete(int.Parse(arr[i]), 0, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); } if (true) { //日志 string EventType = "恢复删除岗位"; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { int UserID = emp_id; string UserName = empname; int EventID = idlist[i]; string IPStreet = request.UserHostAddress; string EventTitle = ds.Tables[0].Rows[i]["post_name"].ToString(); string Original_txt = null; string Current_txt = null; C_Sys_log log = new C_Sys_log(); log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, null, Original_txt, Current_txt); } context.Response.Write("true"); } } if (request["Action"] == "del") { bool canDel = false; if (dsemp.Tables[0].Rows.Count > 0) { if (dsemp.Tables[0].Rows[0]["uid"].ToString() == "admin") { canDel = true; } else { Data.GetAuthorityByUid getauth = new Data.GetAuthorityByUid(); string delauth = getauth.GetBtnAuthority(request.Cookies["UserID"].Value, "82"); if (delauth == "false") canDel = false; else canDel = true; } } if (canDel) { string idlist = Common.PageValidate.InputText(request["idlist"], 1000000); string[] arr = idlist.Split(','); string EventType = "彻底删除岗位"; DataSet ds = post.GetList("post_id in (" + idlist.Trim() + ")"); for (int i = 0; i < arr.Length; i++) { post.Delete(int.Parse(arr[i])); } if (true) { //日志 for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { int UserID = emp_id; string UserName = empname; string IPStreet = request.UserHostAddress; int EventID = idlist[i]; string EventTitle = ds.Tables[0].Rows[0]["post_name"].ToString(); string Original_txt = null; string Current_txt = null; C_Sys_log log = new C_Sys_log(); log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, null, Original_txt, Current_txt); } context.Response.Write("true"); } } else { context.Response.Write("auth"); } } //get post by empid if (request["Action"] == "getpostbyempid") { BLL.hr_post hp = new BLL.hr_post(); int empid = int.Parse(request["empid"]); DataSet ds = hp.GetList(" isDelete=0 and emp_id=" + empid); if (ds.Tables[0].Rows.Count > 0) { string dt = Common.GetGridJSON.DataTableToJSON(ds.Tables[0]); context.Response.Write(dt); } } //serch if (request["Action"] == "serch") { BLL.hr_post hp = new BLL.hr_post(); string serchtxt = Common.PageValidate.InputText(request["Serchtext"], 255); DataSet ds = hp.GetList(" isDelete=0 and post_name like N'%" + serchtxt + "%'"); if (ds.Tables[0].Rows.Count > 0) { string dt = Common.GetGridJSON.DataTableToJSON(ds.Tables[0]); context.Response.Write(dt); } else { context.Response.Write("post_name like N'%" + serchtxt + "%'"); } } //post_emp if (request["Action"] == "postemp") { string json = request["PostData"].ToLower(); JavaScriptSerializer js = new JavaScriptSerializer(); PostData[] postdata; postdata = js.Deserialize<PostData[]>(json); BLL.hr_post hp = new BLL.hr_post(); string empid = request["empid"]; int Eid = -1; if (!string.IsNullOrEmpty(empid)) { Eid = Common.PageValidate.IsNumber(empid) ? int.Parse(empid) : -1; } model.emp_id = Eid; modelemp.ID = Eid; model.emp_name = Common.PageValidate.InputText(request["emp_name"], 255); for (int i = 0; i < postdata.Length; i++) { model.post_id = postdata[i].Post_id; model.default_post = postdata[i].Default_post; if (postdata[i].Default_post == 1) { modelemp.d_id = postdata[i].Dep_id; modelemp.dname = postdata[i].Depname; modelemp.zhiwuid = postdata[i].Position_id; modelemp.zhiwu = postdata[i].Position_name; modelemp.postid = postdata[i].Post_id; modelemp.post = postdata[i].Post_name; //context.Response.Write(postdata[i].Depname + "@"); emp.UpdatePost(modelemp); } hp.UpdatePostEmp(model); } } //combo if (request["Action"] == "combo") { int postid = int.Parse(request["postid"]); DataSet ds = post.GetList(" isDelete=0 and dep_id=" + postid); 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]["post_id"].ToString() + ",text:'" + ds.Tables[0].Rows[i]["post_name"] + "'},"); } str.Replace(",", "", str.Length - 1, 1); str.Append("]"); context.Response.Write(str); } }