public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; if (context.Request.Params["Action"] == "save") { BLL.Sys_role_emp rm = new BLL.Sys_role_emp(); Model.Sys_role_emp model = new Model.Sys_role_emp(); string rid = context.Request.Params["rid"]; string savestring = context.Request.Params["savestring"]; model.RoleID = int.Parse(rid); rm.Delete("RoleID=" + rid); JavaScriptSerializer json = new JavaScriptSerializer(); List<RoleEmp> _list = json.Deserialize<List<RoleEmp>>(savestring); foreach (RoleEmp emp1 in _list) { model.empID = emp1.ID; rm.Add(model); } //日志 BLL.Sys_log log = new BLL.Sys_log(); Model.Sys_log modellog = new Model.Sys_log(); BLL.hr_employee emp = new BLL.hr_employee(); DataSet dsemp = emp.GetList("id=" + context.Request.Cookies["UserID"].Value); modellog.EventDate = DateTime.Now; modellog.UserID = int.Parse(context.Request.Cookies["UserID"].Value); modellog.UserName = dsemp.Tables[0].Rows[0]["name"].ToString(); modellog.IPStreet = context.Request.UserHostAddress; modellog.EventType = "权限人员调整"; modellog.EventID = model.RoleID.ToString(); log.Add(modellog); context.Response.Write("true"); } if (context.Request.Params["Action"] == "get") { string rid = context.Request["rid"]; if (!string.IsNullOrEmpty(rid)) { BLL.Sys_role_emp re = new BLL.Sys_role_emp(); DataSet ds = re.GetList("RoleID=" + int.Parse( rid)); if (ds.Tables[0].Rows.Count > 0) { string sql = ""; sql += "ID in ("; foreach (DataRow row in ds.Tables[0].Rows) { sql += row["empID"] + ","; } sql = sql.Substring(0, sql.Length - 1); sql += ")"; BLL.hr_employee emp = new BLL.hr_employee(); string dt = Common.GetGridJSON.DataTableToJSON(emp.GetList(sql).Tables[0]); context.Response.Write(dt); } else { context.Response.Write("{ Rows: [] }"); } } else { context.Response.Write("test" + rid); } } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; if (context.Request.Params["Action"] == "save") { BLL.Sys_role_emp rm = new BLL.Sys_role_emp(); Model.Sys_role_emp model = new Model.Sys_role_emp(); string rid = context.Request.Params["rid"]; string savestring = context.Request.Params["savestring"]; model.RoleID = int.Parse(rid); rm.Delete("RoleID=" + rid); JavaScriptSerializer json = new JavaScriptSerializer(); List <RoleEmp> _list = json.Deserialize <List <RoleEmp> >(savestring); foreach (RoleEmp emp1 in _list) { model.empID = emp1.ID; rm.Add(model); } //日志 BLL.Sys_log log = new BLL.Sys_log(); Model.Sys_log modellog = new Model.Sys_log(); BLL.hr_employee emp = new BLL.hr_employee(); DataSet dsemp = emp.GetList("id=" + context.Request.Cookies["UserID"].Value); modellog.EventDate = DateTime.Now; modellog.UserID = int.Parse(context.Request.Cookies["UserID"].Value); modellog.UserName = dsemp.Tables[0].Rows[0]["name"].ToString(); modellog.IPStreet = context.Request.UserHostAddress; modellog.EventType = "权限人员调整"; modellog.EventID = model.RoleID.ToString(); log.Add(modellog); context.Response.Write("true"); } if (context.Request.Params["Action"] == "get") { string rid = context.Request["rid"]; if (!string.IsNullOrEmpty(rid)) { BLL.Sys_role_emp re = new BLL.Sys_role_emp(); DataSet ds = re.GetList("RoleID=" + int.Parse(rid)); if (ds.Tables[0].Rows.Count > 0) { string sql = ""; sql += "ID in ("; foreach (DataRow row in ds.Tables[0].Rows) { sql += row["empID"] + ","; } sql = sql.Substring(0, sql.Length - 1); sql += ")"; BLL.hr_employee emp = new BLL.hr_employee(); string dt = Common.GetGridJSON.DataTableToJSON(emp.GetList(sql).Tables[0]); context.Response.Write(dt); } else { context.Response.Write("{ Rows: [] }"); } } else { context.Response.Write("test" + rid); } } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; HttpRequest request = context.Request; BLL.Sys_role_emp rm = new BLL.Sys_role_emp(); Model.Sys_role_emp model = new Model.Sys_role_emp(); var cookie = context.Request.Cookies[FormsAuthentication.FormsCookieName]; var ticket = FormsAuthentication.Decrypt(cookie.Value); string CoockiesID = ticket.UserData; BLL.hr_employee emp = new BLL.hr_employee(); int emp_id = int.Parse(CoockiesID); 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"] == "add") { string rid = PageValidate.InputText(request["role_id"], 50); string empids = Common.PageValidate.InputText(request["empids"], int.MaxValue); //rm.Delete(string.Format("RoleID={0} and empID in ({1})", int.Parse(rid), empids)); string[] emplist = empids.Split(','); model.RoleID = int.Parse(rid); for (int i = 0; i < emplist.Length; i++) { model.empID = int.Parse(emplist[i].ToString()); rm.Add(model); } BLL.Sys_log log = new BLL.Sys_log(); Model.Sys_log modellog = new Model.Sys_log(); modellog.EventDate = DateTime.Now; modellog.UserID = emp_id; modellog.UserName = PageValidate.InputText(empname, 255); modellog.IPStreet = context.Request.UserHostAddress; modellog.EventType = "权限人员调整"; modellog.EventID = rid.ToString(); log.Add(modellog); } if (request["Action"] == "remove") { string rid = PageValidate.InputText(request["role_id"], 50); string empids = Common.PageValidate.InputText(request["empids"], int.MaxValue); rm.Delete(string.Format("RoleID={0} and empID in ({1})", int.Parse(rid), empids)); BLL.Sys_log log = new BLL.Sys_log(); Model.Sys_log modellog = new Model.Sys_log(); modellog.EventDate = DateTime.Now; modellog.UserID = emp_id; modellog.UserName = PageValidate.InputText(empname, 255); modellog.IPStreet = context.Request.UserHostAddress; modellog.EventType = "权限人员调整"; modellog.EventID = rid.ToString(); log.Add(modellog); } if (request["Action"] == "emplist") { string rid = PageValidate.InputText(request["role_id"], 50); string sql = (string.Format("ID not in (select empID from Sys_role_emp where RoleID={0}) and ID !=1 ", rid)); if (!string.IsNullOrEmpty(request["stext"])) { sql += " and name like N'%" + PageValidate.InputText(request["stext"], 255) + "%'"; } int PageIndex = int.Parse(request["page"] == null ? "1" : request["page"]); int PageSize = int.Parse(request["pagesize"] == null ? "30" : request["pagesize"]); string sortname = request["sortname"]; string sortorder = request["sortorder"]; if (string.IsNullOrEmpty(sortname)) { sortname = " ID"; } if (string.IsNullOrEmpty(sortorder)) { sortorder = " desc"; } string sorttext = " " + sortname + " " + sortorder; string Total; dsemp = emp.GetList(PageSize, PageIndex, sql, sorttext, out Total); string dt = Common.GetGridJSON.DataTableToJSON1(dsemp.Tables[0], Total); context.Response.Write(dt); } if (request["Action"] == "get") { string rid = PageValidate.InputText(request["role_id"], 50); if (!string.IsNullOrEmpty(rid)) { string sql = (string.Format("ID in (select empID from Sys_role_emp where RoleID={0})", int.Parse(rid))); if (!string.IsNullOrEmpty(request["stext"])) { sql += " and name like N'%" + PageValidate.InputText(request["stext"], 255) + "%'"; } int PageIndex = int.Parse(request["page"] == null ? "1" : request["page"]); int PageSize = int.Parse(request["pagesize"] == null ? "30" : request["pagesize"]); string sortname = request["sortname"]; string sortorder = request["sortorder"]; if (string.IsNullOrEmpty(sortname)) { sortname = " ID"; } if (string.IsNullOrEmpty(sortorder)) { sortorder = " desc"; } string sorttext = " " + sortname + " " + sortorder; string Total; dsemp = emp.GetList(PageSize, PageIndex, sql, sorttext, out Total); string dt = Common.GetGridJSON.DataTableToJSON1(dsemp.Tables[0], Total); context.Response.Write(dt); } else { context.Response.Write("test" + rid); } } }