public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; HttpRequest request = context.Request; BLL.CRM_Contact contact = new BLL.CRM_Contact(); Model.CRM_Contact model = new Model.CRM_Contact(); 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"] == "save") { string customerid = request["T_company_val"]; model.C_customerid = int.Parse(customerid); model.C_customername = PageValidate.InputText(request["T_company"], 250); model.C_name = PageValidate.InputText(request["T_contact"], 250); model.C_sex = PageValidate.InputText(request["T_sex"], 250); model.C_birthday = PageValidate.InputText(request["T_birthday"], 250); model.C_department = PageValidate.InputText(request["T_dep"], 250); model.C_position = PageValidate.InputText(request["T_position"], 250); model.C_tel = PageValidate.InputText(request["T_tel"], 250); model.C_mob = PageValidate.InputText(request["T_mobil"], 250); model.C_fax = PageValidate.InputText(request["T_fax"], 250); model.C_email = PageValidate.InputText(request["T_email"], 250); model.C_QQ = PageValidate.InputText(request["T_qq"], 250); model.C_add = PageValidate.InputText(request["T_add"], 250); model.C_hobby = PageValidate.InputText(request["T_hobby"], 250); model.C_remarks = PageValidate.InputText(request["T_remarks"], 250); string contact_id = PageValidate.InputText(request["contact_id"], 50); if (!string.IsNullOrEmpty(contact_id) && contact_id != "null") { DataSet ds = contact.GetList("id=" + int.Parse(contact_id)); DataRow dr = ds.Tables[0].Rows[0]; model.id = int.Parse(contact_id); contact.Update(model); //日志 C_Sys_log log = new C_Sys_log(); int UserID = emp_id; string UserName = empname; string IPStreet = request.UserHostAddress; string EventTitle = model.C_name;; string EventType = "联系人修改"; int EventID = model.id; if (dr["C_customername"].ToString() != request["T_company"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "公司名称", dr["C_customer_name"].ToString(), request["T_company"]); } if (dr["C_name"].ToString() != request["T_contact"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "联系人", dr["C_name"].ToString(), request["T_contact"]); } if (dr["C_sex"].ToString() != request["T_sex"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "联系人性别", dr["C_sex"].ToString(), request["T_sex"]); } if (dr["C_birthday"].ToString() != request["T_birthday"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "联系人生日", dr["C_birthday"].ToString(), request["T_birthday"]); } if (dr["C_department"].ToString() != request["T_dep"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "联系人部门", dr["C_department"].ToString(), request["T_dep"]); } if (dr["C_position"].ToString() != request["T_position"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "联系人职位", dr["C_position"].ToString(), request["T_position"]); } if (dr["C_tel"].ToString() != request["T_tel"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "联系人电话", dr["C_tel"].ToString(), request["T_tel"]); } if (dr["C_mob"].ToString() != request["T_mobil"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "联系人手机", dr["C_mob"].ToString(), request["T_mobil"]); } if (dr["C_fax"].ToString() != request["T_fax"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "联系人传真", dr["C_fax"].ToString(), request["T_fax"]); } if (dr["C_email"].ToString() != request["T_email"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "联系人邮箱", dr["C_email"].ToString(), request["T_email"]); } if (dr["C_QQ"].ToString() != request["T_qq"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "联系人QQ", dr["C_QQ"].ToString(), request["T_qq"]); } if (dr["C_add"].ToString() != request["T_add"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "联系人地址", dr["C_add"].ToString(), request["T_add"]); } if (dr["C_hobby"].ToString() != request["T_hobby"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "联系人爱好", dr["C_hobby"].ToString(), request["T_hobby"]); } if (dr["C_remarks"].ToString() != request["T_remarks"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "备注", dr["C_remarks"].ToString(), request["T_remarks"]); } } else { model.isDelete = 0; model.C_createId = emp_id; model.C_createDate = DateTime.Now; contact.Add(model); } } if (request["Action"] == "grid") { 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; string serchtxt = "1=1"; if (!string.IsNullOrEmpty(request["customerid"])) { serchtxt += " and C_customerid=" + int.Parse(request["customerid"]); } if (!string.IsNullOrEmpty(request["company"])) { serchtxt += " and C_customername like N'%" + PageValidate.InputText(request["company"], 255) + "%'"; } if (!string.IsNullOrEmpty(request["contact"])) { serchtxt += " and C_name like N'%" + PageValidate.InputText(request["contact"], 255) + "%'"; } if (!string.IsNullOrEmpty(request["tel"])) { serchtxt += " and C_mob like N'%" + PageValidate.InputText(request["tel"], 255) + "%'"; } if (!string.IsNullOrEmpty(request["qq"])) { serchtxt += " and C_QQ like N'%" + PageValidate.InputText(request["qq"], 255) + "%'"; } if (!string.IsNullOrEmpty(request["startdate"])) { serchtxt += " and C_createDate >= '" + PageValidate.InputText(request["startdate"], 255) + "'"; } if (!string.IsNullOrEmpty(request["enddate"])) { DateTime enddate = DateTime.Parse(request["enddate"]).AddHours(23).AddMinutes(59).AddSeconds(59); serchtxt += " and C_createDate <= '" + enddate + "'"; } if (!string.IsNullOrEmpty(request["startdate_del"])) { serchtxt += " and Delete_time >= '" + PageValidate.InputText(request["startdate_del"], 255) + "'"; } if (!string.IsNullOrEmpty(request["enddate_del"])) { DateTime enddate1 = DateTime.Parse(request["enddate_del"]).AddHours(23).AddMinutes(59).AddSeconds(59); serchtxt += " and Delete_time <= '" + enddate1 + "'"; } //权限 serchtxt += " and C_customerid in (select id from CRM_Customer where " + DataAuth(emp_id.ToString()) + ")"; //context.Response.Write(serchtxt); DataSet ds = contact.GetList(PageSize, PageIndex, serchtxt, sorttext, out Total); string dt = Common.GetGridJSON.DataTableToJSON1(ds.Tables[0], Total); context.Response.Write(dt); } if (request["Action"] == "form") { string contact_id = PageValidate.InputText(request["contact_id"], 50); DataSet ds = contact.GetList("id=" + int.Parse(contact_id)); string dt = Common.DataToJson.DataToJSON(ds); context.Response.Write(dt); } //del if (request["Action"] == "del") { //参数安全过滤 string c_id = PageValidate.InputText(request["id"], 50); DataSet ds = contact.GetList("id=" + int.Parse(c_id)); string EventType = "联系人删除"; bool isdel = contact.Delete(int.Parse(c_id)); if (isdel) { //日志 int UserID = emp_id; string UserName = empname; string IPStreet = request.UserHostAddress; int EventID = int.Parse(c_id); string EventTitle = ds.Tables[0].Rows[0]["C_name"].ToString(); string Original_txt = ds.Tables[0].Rows[0]["C_tel"].ToString(); string Current_txt = null; C_Sys_log log = new C_Sys_log(); log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "电话", Original_txt, Current_txt); context.Response.Write("true"); } else { context.Response.Write("false"); } } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; HttpRequest request = context.Request; BLL.public_notice notice = new BLL.public_notice(); Model.public_notice model = new Model.public_notice(); 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"] == "save") { DataRow dremp = dsemp.Tables[0].Rows[0]; model.notice_time = DateTime.Now; model.notice_title = PageValidate.InputText(request["T_title"], 255); model.notice_content = PageValidate.InputText(request["T_content"], int.MaxValue); string nid = PageValidate.InputText(request["nid"], 50); if (!string.IsNullOrEmpty(nid) && nid != "null") { if (!Common.PageValidate.IsNumber(nid)) { nid = "-1"; } DataSet ds = notice.GetList("id=" + int.Parse(nid)); DataRow dr = ds.Tables[0].Rows[0]; model.dep_id = int.Parse(dr["dep_id"].ToString()); model.dep_name = dr["dep_name"].ToString(); model.create_id = int.Parse(dr["create_id"].ToString()); model.create_name = dr["create_name"].ToString(); model.id = int.Parse(nid); notice.Update(model); C_Sys_log log = new C_Sys_log(); int UserID = emp_id; string UserName = empname; string IPStreet = request.UserHostAddress; string EventTitle = model.notice_title; string EventType = "公告修改"; int EventID = model.id; if (dr["notice_title"].ToString() != request["T_title"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "公告标题", dr["notice_title"].ToString(), request["T_title"]); } if (dr["notice_content"].ToString() != request["T_content"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "公告内容", "原内容被修改", "原内容被修改"); } } else { int depid = int.Parse(dremp["d_id"].ToString()); string depname = dremp["dname"].ToString(); model.dep_id = depid; model.dep_name = depname; model.create_id = emp_id; model.create_name = empname; notice.Add(model); } } if (request["Action"] == "grid") { 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 = " notice_time"; } if (string.IsNullOrEmpty(sortorder)) { sortorder = "desc"; } string sorttext = " " + sortname + " " + sortorder; string Total; string serchtxt = " 1=1 "; if (!string.IsNullOrEmpty(request["sstart"])) { serchtxt += " and notice_time >= '" + PageValidate.InputText(request["sstart"], 50) + "'"; } if (!string.IsNullOrEmpty(request["sdend"])) { DateTime enddate = DateTime.Parse(request["sdend"]).AddHours(23).AddMinutes(59).AddSeconds(59); serchtxt += " and notice_time <= '" + enddate + "'"; } if (!string.IsNullOrEmpty(request["stext"])) { if (request["stext"] != "输入关键词搜索") { serchtxt += " and notice_title like N'%" + PageValidate.InputText(request["stext"], 500) + "%'"; } } DataSet ds = notice.GetList(PageSize, PageIndex, serchtxt, sorttext, out Total); context.Response.Write(Common.GetGridJSON.DataTableToJSON1(ds.Tables[0], Total)); } if (request["Action"] == "form") { string nid = PageValidate.InputText(request["nid"], 50); DataSet ds = notice.GetList("id=" + int.Parse(nid)); string dt = Common.DataToJson.DataToJSON(ds); context.Response.Write(dt); } //del 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(emp_id.ToString(), "13"); if (delauth == "false") { canDel = false; } else { canDel = true; } } } if (canDel) { int id = int.Parse(request["id"]); DataSet ds = notice.GetList("id=" + id); string EventType = "彻底删除公告"; bool isdel = notice.Delete(id); 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 = id; string EventTitle = ds.Tables[0].Rows[i]["notice_title"].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"); } } else { context.Response.Write("auth"); } } if (request["Action"] == "noticeremind") { DataSet ds = notice.GetList(7, "", " notice_time desc"); string dt = Common.GetGridJSON.DataTableToJSON(ds.Tables[0]); context.Response.Write(dt); } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; HttpRequest request = context.Request; BLL.hr_department dep = new BLL.hr_department(); Model.hr_department model = new Model.hr_department(); 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"] == "department") { string did = PageValidate.InputText(request["did"], 50); if (!string.IsNullOrEmpty(did)) { DataSet ds; if (did == "-2") { //ds = dep.GetList(" ISNULL(isDelete,0)=0 and parentid=0 ");//sqlserver专用 ds = dep.GetList(" IfNULL(isDelete,0)=0 and parentid=0 "); } else { ds = dep.GetList(" id=" + int.Parse(did)); } string outstring = did + ","; outstring += ds.Tables[0].Rows[0]["d_name"].ToString() + ","; outstring += ds.Tables[0].Rows[0]["d_fuzeren"].ToString() + ","; outstring += ds.Tables[0].Rows[0]["d_tel"].ToString() + ","; outstring += ds.Tables[0].Rows[0]["d_fax"].ToString() + ","; outstring += ds.Tables[0].Rows[0]["d_add"].ToString() + ","; outstring += ds.Tables[0].Rows[0]["d_email"].ToString() + ","; outstring += ds.Tables[0].Rows[0]["d_miaoshu"].ToString() + ","; outstring += ds.Tables[0].Rows[0]["d_order"].ToString(); context.Response.Write(outstring); } } if (request["Action"] == "deptree") { DataSet ds = dep.GetAllList(); StringBuilder str = new StringBuilder(); str.Append("["); str.Append("{id:0,text:'无',d_icon:''},"); str.Append(GetTreeString(0, ds.Tables[0], null)); str.Replace(",", "", str.Length - 1, 1); str.Append("]"); context.Response.Write(str); } if (request["Action"] == "treegrid") { DataSet ds = dep.GetAllList(); string dt = "{Rows:[" + GetTasksString(0, ds.Tables[0]) + "]}"; context.Response.Write(dt); } if (request["Action"] == "tree") { string serchtxt = " 1=1 "; string authtxt = PageValidate.InputText(request["auth"], 50); if (!string.IsNullOrEmpty(authtxt)) { Data.GetDataAuth dataauth = new Data.GetDataAuth(); string txt = dataauth.GetDataAuthByid(authtxt, "Sys_add", emp_id.ToString()); string[] arr = txt.Split(':'); switch (arr[0]) { case "my": case "dep": string did = dsemp.Tables[0].Rows[0]["d_id"].ToString(); if (string.IsNullOrEmpty(did)) { did = "0"; } authtxt = did; break; case "all": authtxt = "0"; break; case "depall": DataSet dsdep = dep.GetAllList(); string deptask = GetDepTask(int.Parse(arr[1]), dsdep.Tables[0]); string intext = arr[1] + "," + deptask; authtxt = intext.TrimEnd(','); break; } } //context.Response.Write(authtxt); DataSet ds = dep.GetList(0, serchtxt, " d_order"); StringBuilder str = new StringBuilder(); str.Append("["); str.Append(GetTreeString(0, ds.Tables[0], authtxt)); str.Replace(",", "", str.Length - 1, 1); str.Append("]"); context.Response.Write(str); } //Form JSON if (request["Action"] == "form") { int depid = int.Parse(request["id"]); DataSet ds = dep.GetList("id=" + depid); string dt = Common.DataToJson.DataToJSON(ds); context.Response.Write(dt); } //save if (request["Action"] == "save") { string parentid;//= string.IsNullOrEmpty(request["T_parent"]) ? "0" : request["T_parentid"]; if (string.IsNullOrEmpty(request["T_parent_val"]) || request["T_parent_val"] == "null") { parentid = "0"; } else { parentid = request["T_parent_val"]; } model.d_name = PageValidate.InputText(request["T_depname"], 255); model.parentid = int.Parse(parentid); model.parentname = PageValidate.InputText(request["T_parent"], 250); model.d_type = PageValidate.InputText(request["T_deptype"], 250); model.d_order = int.Parse(request["T_sort"]); model.d_fuzeren = PageValidate.InputText(request["T_leader"], 255); model.d_tel = PageValidate.InputText(request["T_tel"], 255); model.d_email = PageValidate.InputText(request["T_email"], 255); model.d_fax = PageValidate.InputText(request["T_fax"], 255); model.d_add = PageValidate.InputText(request["T_add"], 255); model.d_miaoshu = PageValidate.InputText(request["T_descript"], 255); if (model.d_type == "部门") { model.d_icon = "images/icon/88.png"; } else { model.d_icon = "images/icon/61.png"; } string id = request["id"]; if (!string.IsNullOrEmpty(id) && id != "null") { model.id = int.Parse(id); DataSet ds = dep.GetList("id=" + int.Parse(id)); DataRow dr = ds.Tables[0].Rows[0]; dep.Update(model); //日志 C_Sys_log log = new C_Sys_log(); int UserID = emp_id; string UserName = empname; string IPStreet = request.UserHostAddress; string EventTitle = model.d_name; string EventType = "组织架构修改"; int EventID = model.id; if (dr["d_name"].ToString() != request["T_depname"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "机构名称", dr["d_name"].ToString(), request["T_depname"]); } if (dr["parentname"].ToString() != request["T_parent"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "上级机构", dr["parentname"].ToString(), request["T_parent"]); } if (dr["d_type"].ToString() != request["T_deptype"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "机构类型", dr["d_type"].ToString(), request["T_deptype"]); } if (dr["d_order"].ToString() != request["T_sort"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "部门排序", dr["d_order"].ToString(), request["T_sort"]); } if (dr["d_fuzeren"].ToString() != request["T_leader"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "负责人", dr["d_fuzeren"].ToString(), request["T_leader"]); } if (dr["d_tel"].ToString() != request["T_tel"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "电话", dr["d_tel"].ToString(), request["T_tel"]); } if (dr["d_email"].ToString() != request["T_email"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "邮箱", dr["d_email"].ToString(), request["T_email"]); } if (dr["d_fax"].ToString() != request["T_fax"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "传真", dr["d_fax"].ToString(), request["T_fax"]); } if (dr["d_add"].ToString() != request["T_add"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "地址", dr["d_add"].ToString(), request["T_add"]); } if (dr["d_miaoshu"].ToString() != request["T_descript"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "描述", dr["d_miaoshu"].ToString(), request["T_descript"]); } } else { model.isDelete = 0; dep.Add(model); } } //del if (request.Params["Action"] == "del") { int d_id = int.Parse(request["id"]); string EventType = "组织架构删除"; DataSet ds = emp.GetList("d_id = " + d_id); BLL.hr_post post = new BLL.hr_post(); if (d_id == 1) { //根目录不能删除 context.Response.Write("false:first"); } else if (post.GetList("dep_id=" + d_id).Tables[0].Rows.Count > 0) { //含有岗位信息不能删除 context.Response.Write("false:post"); } else if (emp.GetList("d_id=" + d_id).Tables[0].Rows.Count > 0) { //含有员工信息不能删除 context.Response.Write("false:emp"); } else { bool isdel = dep.Delete(d_id); 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 = d_id; string EventTitle = ds.Tables[0].Rows[i]["d_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"); } } } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; HttpRequest request = context.Request; BLL.hr_position zw = new BLL.hr_position(); Model.hr_position model = new Model.hr_position(); 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"] == "grid") { string serchtxt = "1=1"; DataSet ds = zw.GetList(0, serchtxt, "convert(int,[position_order])"); string dt = Common.GetGridJSON.DataTableToJSON(ds.Tables[0]); context.Response.Write(dt); } //save if (request["Action"] == "save") { model.position_name = PageValidate.InputText(request["T_position"], 255); model.position_order = int.Parse(request["T_order"]); model.position_level = PageValidate.InputText(request["T_level"], 50); string id = PageValidate.InputText(request["id"], 250); if (!string.IsNullOrEmpty(id) && id != "null") { model.id = int.Parse(id); DataSet ds = zw.GetList(" id=" + int.Parse(id)); DataRow dr = ds.Tables[0].Rows[0]; zw.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.id; 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["position_level"].ToString() != request["T_level"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "职务级别", dr["position_level"].ToString(), request["T_level"]); } if (dr["position_order"].ToString() != request["T_order"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "行号", dr["position_order"].ToString(), request["T_order"]); } } else { model.isDelete = 0; model.create_id = emp_id; model.create_date = DateTime.Now; zw.Add(model); } } //Form JSON if (request["Action"] == "form") { string id = PageValidate.InputText(request["id"], 50); DataSet ds = zw.GetList("id=" + int.Parse(id)); string dt = Common.DataToJson.DataToJSON(ds); context.Response.Write(dt); } if (request["Action"] == "del") { string id = PageValidate.InputText(request["id"], 50); string EventType = "职务删除"; DataSet ds = zw.GetList(" id=" + int.Parse(id)); if (emp.GetList("zhiwuid=" + int.Parse(id)).Tables[0].Rows.Count > 0) { //含有员工信息不能删除 context.Response.Write("false:emp"); } else { bool isdel = zw.Delete(int.Parse(request["id"])); 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(id); string EventTitle = ds.Tables[0].Rows[i]["position_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"] == "combo") { DataSet ds = zw.GetList(0, "", "position_level"); 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]["id"].ToString() + ",text:'" + ds.Tables[0].Rows[i]["position_name"] + "'},"); } str.Replace(",", "", str.Length - 1, 1); str.Append("]"); context.Response.Write(str); } if (request["Action"] == "getlevel") { int position_id = int.Parse(request["position_id"]); BLL.hr_position hz = new BLL.hr_position(); DataSet ds = hz.GetList("id=" + position_id); if (ds.Tables[0].Rows.Count > 0) { context.Response.Write(ds.Tables[0].Rows[0]["position_level"]); } else { context.Response.Write("-1"); } } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; HttpRequest request = context.Request; Model.hr_employee model = new Model.hr_employee(); 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"] == "grid") { 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; string serchtxt = "uid!='admin'"; string did = request["did"]; if (!string.IsNullOrEmpty(did) && did != null && did != "null") { serchtxt += " and d_id=" + int.Parse(did); } string authtxt = request["auth"]; if (authtxt == "1") { Data.GetDataAuth dataauth = new Data.GetDataAuth(); string txt = dataauth.GetDataAuthByid("1", "Sys_add", emp_id.ToString()); string[] arr = txt.Split(':'); switch (arr[0]) { case "my": serchtxt += " and ID=" + emp_id; break; } } if (!string.IsNullOrEmpty(request["stext"])) { if (request["stext"] != "输入姓名搜索") { serchtxt += " and name like N'%" + PageValidate.InputText(request["stext"], 255) + "%'"; } } //权限 DataSet ds = emp.GetList(PageSize, PageIndex, serchtxt, sorttext, out Total); string dt = Common.GetGridJSON.DataTableToJSON1(ds.Tables[0], Total); context.Response.Write(dt); } //表格json if (request["Action"] == "getRole") { int r_empid = int.Parse(request["empid"]); DataSet ds = emp.GetRole(r_empid); string dt = Common.GetGridJSON.DataTableToJSON(ds.Tables[0]); context.Response.Write(dt); } //validate if (request["Action"] == "Exist") { string user_id = request["T_uid"]; string T_emp_id = request["emp_id"]; if (string.IsNullOrEmpty(T_emp_id) || T_emp_id == "null") { T_emp_id = "0"; } DataSet ds1 = emp.GetList(" uid='" + PageValidate.InputText(user_id, 250) + "' and ID!=" + int.Parse(T_emp_id)); context.Response.Write(ds1.Tables[0].Rows.Count > 0 ? "false" : "true"); } //Form JSON if (request["Action"] == "form") { string eid = PageValidate.InputText(request["id"], 50); if (eid == "epu") { eid = emp_id.ToString(); } DataSet ds = emp.GetList("id=" + int.Parse(eid)); string dt = Common.DataToJson.DataToJSON(ds); context.Response.Write(dt); } //save if (request["Action"] == "save") { model.uid = PageValidate.InputText(request["T_uid"], 255); model.email = PageValidate.InputText(request["T_email"], 255); model.name = PageValidate.InputText(request["T_name"], 255); model.birthday = PageValidate.InputText(request["T_birthday"], 255); model.sex = PageValidate.InputText(request["T_sex"], 255); model.idcard = PageValidate.InputText(request["T_idcard"], 255); model.tel = PageValidate.InputText(request["T_tel"], 255); model.status = PageValidate.InputText(request["T_status"], 255); model.EntryDate = PageValidate.InputText(request["T_entryDate"], 255); model.address = PageValidate.InputText(request["T_Adress"], 255); model.schools = PageValidate.InputText(request["T_school"], 255); model.education = PageValidate.InputText(request["T_edu"], 255); model.professional = PageValidate.InputText(request["T_professional"], 255); model.remarks = PageValidate.InputText(request["T_remarks"], 255); model.title = PageValidate.InputText(request["headurl"], 255); model.canlogin = int.Parse(request["canlogin"]); int empid; string id = PageValidate.InputText(request["id"], 50); if (!string.IsNullOrEmpty(id) && id != "null") { DataSet ds = emp.GetList(" ID=" + int.Parse(id)); DataRow dr = ds.Tables[0].Rows[0]; model.ID = int.Parse(id); empid = model.ID; emp.Update(model); C_Sys_log log = new C_Sys_log(); int UserID = emp_id; string UserName = empname; string IPStreet = request.UserHostAddress; string EventTitle = model.name; string EventType = "员工修改"; int EventID = model.ID; if (dr["email"].ToString() != request["T_email"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "邮箱", dr["email"].ToString(), request["T_email"]); } if (dr["name"].ToString() != request["T_name"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "员工姓名", dr["name"].ToString(), request["T_name"]); } if (dr["birthday"].ToString() != request["T_birthday"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "员工生日", dr["birthday"].ToString(), request["T_birthday"]); } if (dr["sex"].ToString() != request["T_sex"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "员工性别", dr["sex"].ToString(), request["T_sex"]); } if (dr["status"].ToString() != request["T_status"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "状态", dr["status"].ToString(), request["T_status"]); } if (dr["idcard"].ToString() != request["T_idcard"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "身份证", dr["idcard"].ToString(), request["T_idcard"]); } if (dr["tel"].ToString() != request["T_tel"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "手机", dr["tel"].ToString(), request["T_tel"]); } if (dr["EntryDate"].ToString() != request["T_entryDate"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "入职日期", dr["EntryDate"].ToString(), request["T_entryDate"]); } if (dr["address"].ToString() != request["T_Adress"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "地址", dr["address"].ToString(), request["T_Adress"]); } if (dr["schools"].ToString() != request["T_school"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "毕业学校", dr["schools"].ToString(), request["T_school"]); } if (dr["education"].ToString() != request["T_edu"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "学历", dr["education"].ToString(), request["T_edu"]); } if (dr["professional"].ToString() != request["T_professional"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "专业", dr["professional"].ToString(), request["T_professional"]); } if (dr["remarks"].ToString() != request["T_remarks"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "备注", dr["remarks"].ToString(), request["T_remarks"]); } if (dr["canlogin"].ToString() != request["canlogin"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "能否登录", dr["canlogin"].ToString(), request["canlogin"]); } context.Response.Write(id + "|" + model.name); } else { model.isDelete = 0; model.pwd = FormsAuthentication.HashPasswordForStoringInConfigFile("123456", "MD5"); empid = emp.Add(model); context.Response.Write("{success:success}"); } //post string json = request["PostData"].ToLower(); JavaScriptSerializer js = new JavaScriptSerializer(); PostData[] postdata; postdata = js.Deserialize <PostData[]>(json); BLL.hr_post hp = new BLL.hr_post(); Model.hr_post modelpost = new Model.hr_post(); modelpost.emp_id = empid; model.ID = empid; modelpost.emp_name = PageValidate.InputText(request["T_name"], 255); for (int i = 0; i < postdata.Length; i++) { modelpost.post_id = postdata[i].Post_id; modelpost.default_post = postdata[i].Default_post; if (postdata[i].Default_post == 1) { model.d_id = postdata[i].dep_id; model.dname = postdata[i].Depname; model.zhiwuid = postdata[i].Position_id; model.zhiwu = postdata[i].Position_name; model.postid = postdata[i].Post_id; model.post = postdata[i].Post_name; //context.Response.Write(postdata[i].Depname + "@"); //更新默认岗位 emp.UpdatePost(model); // 更新客户,订单,合同,收款,开票 人员 emp.UpdateCOCRI(model); //清除员工 hp.UpdatePostEmpbyEid(empid); } //设置员工 hp.UpdatePostEmp(modelpost); //context.Response.Write("{success:success}"); } } if (request["Action"] == "PersonalUpdate") { model.email = PageValidate.InputText(request["T_email"], 255); model.name = PageValidate.InputText(request["T_name"], 255); model.birthday = PageValidate.InputText(request["T_birthday"], 255); model.sex = PageValidate.InputText(request["T_sex"], 255); model.idcard = PageValidate.InputText(request["T_idcard"], 255); model.tel = PageValidate.InputText(request["T_tel"], 255); model.address = PageValidate.InputText(request["T_Adress"], 255); model.schools = PageValidate.InputText(request["T_school"], 255); model.education = PageValidate.InputText(request["T_edu"], 255); model.professional = PageValidate.InputText(request["T_professional"], 255); model.remarks = PageValidate.InputText(request["T_remarks"], 255); model.title = PageValidate.InputText(request["headurl"], 255); DataRow dr = dsemp.Tables[0].Rows[0]; model.ID = emp_id; bool isup = emp.PersonalUpdate(model); if (isup) { context.Response.Write("true"); } else { context.Response.Write("false"); } C_Sys_log log = new C_Sys_log(); int UserID = emp_id; string UserName = empname; string IPStreet = request.UserHostAddress; string EventTitle = model.name; string EventType = "个人信息修改"; int EventID = emp_id; if (dr["email"].ToString() != request["T_email"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "邮箱", dr["email"].ToString(), request["T_email"]); } if (dr["name"].ToString() != request["T_name"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "员工姓名", dr["name"].ToString(), request["T_name"]); } if (dr["birthday"].ToString() != request["T_birthday"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "员工生日", dr["birthday"].ToString(), request["T_birthday"]); } if (dr["sex"].ToString() != request["T_sex"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "员工性别", dr["sex"].ToString(), request["T_sex"]); } if (dr["idcard"].ToString() != request["T_idcard"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "身份证", dr["idcard"].ToString(), request["T_idcard"]); } if (dr["tel"].ToString() != request["T_tel"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "手机", dr["tel"].ToString(), request["T_tel"]); } if (dr["address"].ToString() != request["T_Adress"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "地址", dr["address"].ToString(), request["T_Adress"]); } if (dr["schools"].ToString() != request["T_school"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "毕业学校", dr["schools"].ToString(), request["T_school"]); } if (dr["education"].ToString() != request["T_edu"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "学历", dr["education"].ToString(), request["T_edu"]); } if (dr["professional"].ToString() != request["T_professional"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "专业", dr["professional"].ToString(), request["T_professional"]); } } //combo if (request["Action"] == "combo") { string serchtxt = " 1=1 "; string did = request["did"]; if (!string.IsNullOrEmpty(did) && did != null && did != "null") { serchtxt += " and d_id=" + int.Parse(did); } string authtxt = request["auth"]; if (authtxt == "1") { Data.GetDataAuth dataauth = new Data.GetDataAuth(); string txt = dataauth.GetDataAuthByid("1", "Sys_add", emp_id.ToString()); string[] arr = txt.Split(':'); switch (arr[0]) { case "my": serchtxt += " and ID=" + emp_id; break; } } DataSet ds = emp.GetList(serchtxt); 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]["id"].ToString() + ",text:'" + ds.Tables[0].Rows[i]["name"] + "'},"); } str.Replace(",", "", str.Length - 1, 1); str.Append("]"); context.Response.Write(str); } //init if (request["Action"] == "init") { DataSet ds = emp.GetList("and ID=" + emp_id); StringBuilder str = new StringBuilder(); if (ds.Tables[0].Rows.Count > 0) { str.Append(ds.Tables[0].Rows[0]["ID"].ToString() + "|" + ds.Tables[0].Rows[0]["d_id"]); } context.Response.Write(str); } //changepwd if (request["Action"] == "changepwd") { DataSet ds = emp.GetPWD(emp_id); string oldpwd = FormsAuthentication.HashPasswordForStoringInConfigFile(request["T_oldpwd"], "MD5"); string newpwd = FormsAuthentication.HashPasswordForStoringInConfigFile(request["T_newpwd"], "MD5"); if (ds.Tables[0].Rows[0]["pwd"].ToString() == oldpwd) { model.pwd = newpwd; model.ID = (emp_id); emp.changepwd(model); context.Response.Write("true"); } else { context.Response.Write("false"); } } //allchangepwd if (request["Action"] == "allchangepwd") { string empid = request["empid"]; string newpwd = FormsAuthentication.HashPasswordForStoringInConfigFile(request["T_newpwd"], "MD5"); model.pwd = newpwd; model.ID = int.Parse(empid); emp.changepwd(model); } //del if (request["Action"] == "del") { BLL.hr_post hp = new BLL.hr_post(); string empid = PageValidate.InputText(request["id"], 50); string EventType = "员工删除"; DataSet ds = emp.GetList(" id=" + int.Parse(empid)); BLL.CRM_Customer customer = new BLL.CRM_Customer(); int cc = customer.GetList("Employee_id=" + int.Parse(empid)).Tables[0].Rows.Count; if (cc > 0) { context.Response.Write("false:customer"); } else { bool isdel = false; isdel = emp.Delete(int.Parse(request["id"])); //update post hp.UpdatePostEmpbyEid(int.Parse(empid)); if (isdel) { int UserID = emp_id; string UserName = empname; string IPStreet = request.UserHostAddress; int EventID = int.Parse(empid); string EventTitle = ds.Tables[0].Rows[0]["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"); } } } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; HttpRequest request = context.Request; BLL.CRM_product_category ccpc = new BLL.CRM_product_category(); Model.CRM_product_category model = new Model.CRM_product_category(); 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"] == "save") { string parentid = PageValidate.InputText(request["T_category_parent_val"], 50); model.parentid = int.Parse(parentid); model.product_category = Common.PageValidate.InputText(request["T_category_name"], 250); model.product_icon = Common.PageValidate.InputText(request["T_category_icon"], 250); string id = PageValidate.InputText(request["id"], 50); string pid = PageValidate.InputText(request["T_category_parent_val"], 50); if (!string.IsNullOrEmpty(id) && id != "null") { model.id = int.Parse(id); DataSet ds = ccpc.GetList(" id=" + int.Parse(id)); DataRow dr = ds.Tables[0].Rows[0]; if (int.Parse(id) == int.Parse(pid)) { context.Response.Write("false:type"); } else { ccpc.Update(model); //日志 C_Sys_log log = new C_Sys_log(); int UserID = emp_id; string UserName = empname; string IPStreet = request.UserHostAddress; string EventTitle = model.product_category; string EventType = "产品类别修改"; int EventID = model.id; if (dr["product_category"].ToString() != request["T_category_name"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "产品类别", dr["product_category"].ToString(), request["T_category_name"]); } if (dr["product_icon"].ToString() != request["T_category_icon"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "类别图标", dr["product_icon"].ToString(), request["T_category_icon"]); } if (dr["parentid"].ToString() != request["T_category_parent_val"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "上级类别", dr["parentid"].ToString(), request["T_category_parent_val"]); } } } else { model.isDelete = 0; ccpc.Add(model); } } if (request["Action"] == "grid") { 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; string serchtxt = "1=1"; if (!string.IsNullOrEmpty(request["company"])) { serchtxt += " and product_category like N'%" + PageValidate.InputText(request["company"], 50) + "%'"; } if (!string.IsNullOrEmpty(request["startdate_del"])) { serchtxt += " and Delete_time >= '" + PageValidate.InputText(request["startdate_del"], 50) + "'"; } if (!string.IsNullOrEmpty(request["enddate_del"])) { DateTime enddate = DateTime.Parse(request["enddate_del"]); serchtxt += " and Delete_time <= '" + enddate.AddHours(23).AddMinutes(59).AddSeconds(59) + "'"; } //权限 string dt = ""; if (request["grid"] == "tree") { DataSet ds = ccpc.GetList(0, serchtxt, sorttext); dt = "{Rows:[" + GetTasksString(0, ds.Tables[0]) + "]}"; } else { DataSet ds = ccpc.GetList(PageSize, PageIndex, serchtxt, sorttext, out Total); dt = Common.GetGridJSON.DataTableToJSON1(ds.Tables[0], Total); } context.Response.Write(dt); } if (request["Action"] == "tree") { DataSet ds = ccpc.GetAllList(); StringBuilder str = new StringBuilder(); str.Append("["); str.Append(GetTreeString(0, ds.Tables[0])); str.Replace(",", "", str.Length - 1, 1); str.Append("]"); context.Response.Write(str); } if (request["Action"] == "combo") { DataSet ds = ccpc.GetAllList(); StringBuilder str = new StringBuilder(); str.Append("["); str.Append("{id:0,text:'无',d_icon:''},"); str.Append(GetTreeString(0, ds.Tables[0])); str.Replace(",", "", str.Length - 1, 1); str.Append("]"); context.Response.Write(str); } if (request["Action"] == "form") { int cid = int.Parse(request["id"]); DataSet ds = ccpc.GetList("id=" + cid); string dt = Common.DataToJson.DataToJSON(ds); context.Response.Write(dt); } //del if (request["Action"] == "del") { //参数安全过滤 string c_id = PageValidate.InputText(request["id"], 50); DataSet ds = ccpc.GetList(" id=" + int.Parse(c_id)); BLL.CRM_product product = new BLL.CRM_product(); if (product.GetList(" category_id=" + int.Parse(c_id)).Tables[0].Rows.Count > 0) { context.Response.Write("false:product"); } else if (ccpc.GetList("parentid=" + int.Parse(c_id)).Tables[0].Rows.Count > 0) { context.Response.Write("false:parent"); } else { bool isdel = ccpc.Delete(int.Parse(c_id)); if (isdel) { //日志 string EventType = "产品类别删除"; int UserID = emp_id; string UserName = empname; string IPStreet = request.UserHostAddress; int EventID = int.Parse(c_id); string EventTitle = ds.Tables[0].Rows[0]["product_category"].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"); } } } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; HttpRequest request = context.Request; BLL.CRM_invoice cci = new BLL.CRM_invoice(); Model.CRM_invoice model = new Model.CRM_invoice(); 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"] == "save") { DataRow dremp = dsemp.Tables[0].Rows[0]; model.invoice_num = PageValidate.InputText(request["T_invoice_num"], 255); string orderid = PageValidate.InputText(request["orderid"], 50); BLL.CRM_order order = new BLL.CRM_order(); DataSet dsorder = order.GetList("id=" + int.Parse(orderid)); model.order_id = int.Parse(orderid); if (dsorder.Tables[0].Rows.Count > 0) { model.Customer_id = int.Parse(dsorder.Tables[0].Rows[0]["Customer_id"].ToString()); model.Customer_name = PageValidate.InputText(dsorder.Tables[0].Rows[0]["Customer_name"].ToString(), 255); } model.C_depid = int.Parse(request["T_dep_val"].ToString()); model.C_depname = PageValidate.InputText(request["T_dep"].ToString(), 255); model.C_empid = int.Parse(request["T_employee_val"].ToString()); model.C_empname = PageValidate.InputText(request["T_employee1"].ToString(), 255); model.invoice_amount = decimal.Parse(request["T_invoice_amount"]); model.invoice_date = DateTime.Parse(request["T_invoice_date"].ToString()); model.invoice_type_id = int.Parse(request["T_invoice_type_val"].ToString()); model.invoice_type = PageValidate.InputText(request["T_invoice_type"].ToString(), 255); model.invoice_content = PageValidate.InputText(request["T_content"].ToString(), int.MaxValue); string cid = PageValidate.InputText(request["invoiceid"], 50); if (!string.IsNullOrEmpty(cid) && cid != "null") { model.id = int.Parse(cid); DataSet ds = cci.GetList(" id=" + model.id); DataRow dr = ds.Tables[0].Rows[0]; cci.Update(model); //日志 C_Sys_log log = new C_Sys_log(); int UserID = emp_id; string UserName = empname; string IPStreet = request.UserHostAddress; string EventTitle = model.invoice_num; string EventType = "开票修改"; int EventID = model.id; if (dr["invoice_amount"].ToString() != request["T_invoice_amount"].Replace(",", "").Replace(".00", "")) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "发票总额", dr["invoice_amount"].ToString(), request["T_invoice_amount"].Replace(",", "").Replace(".00", "")); } if (dr["invoice_type"].ToString() != request["T_invoice_type"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "发票类型", dr["invoice_type"].ToString(), request["T_invoice_type"]); } if (dr["invoice_num"].ToString() != request["T_invoice_num"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "发票号码", dr["invoice_num"].ToString(), request["T_invoice_num"]); } if (dr["invoice_date"].ToString() != request["T_invoice_date"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "开票时间", dr["invoice_date"].ToString(), request["T_invoice_date"]); } if (dr["invoice_content"].ToString() != request["T_content"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "开票内容", "原内容被修改", "原内容被修改"); } if (dr["C_depname"].ToString() != request["T_dep"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "开票人部门", dr["C_depname"].ToString(), request["T_dep"]); } if (dr["C_empname"].ToString() != request["T_employee1"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "开票人姓名", dr["C_empname"].ToString(), request["T_employee1"]); } } else { model.isDelete = 0; model.create_id = emp_id; model.create_name = dremp["name"].ToString(); model.create_date = DateTime.Now; cci.Add(model); } //更新订单发票金额 order.UpdateInvoice(orderid); } if (request["Action"] == "grid") { 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; string serchtxt = "1=1"; string order_id = request["orderid"]; if (!string.IsNullOrEmpty(order_id) && order_id != "null") { serchtxt += " and order_id=" + int.Parse(order_id); } if (!string.IsNullOrEmpty(request["company"])) { serchtxt += " and Customer_name like N'%" + PageValidate.InputText(request["company"], 255) + "%'"; } if (!string.IsNullOrEmpty(request["receive_num"])) { serchtxt += " and invoice_num like N'%" + PageValidate.InputText(request["receive_num"], 255) + "%'"; } if (!string.IsNullOrEmpty(request["pay_type"])) { serchtxt += " and invoice_type_id =" + int.Parse(request["pay_type_val"]); } if (!string.IsNullOrEmpty(request["department"])) { serchtxt += " and C_depid =" + int.Parse(request["department_val"]); } if (!string.IsNullOrEmpty(request["employee"])) { serchtxt += " and C_empid =" + int.Parse(request["employee_val"]); } if (!string.IsNullOrEmpty(request["startdate"])) { serchtxt += " and invoice_date >= '" + PageValidate.InputText(request["startdate"], 255) + "'"; } if (!string.IsNullOrEmpty(request["enddate"])) { DateTime enddate = DateTime.Parse(request["enddate"]); serchtxt += " and invoice_date <= '" + DateTime.Parse(request["enddate"]).AddHours(23).AddMinutes(59).AddSeconds(59) + "'"; } if (!string.IsNullOrEmpty(request["startdate_del"])) { serchtxt += " and Delete_time >= '" + PageValidate.InputText(request["startdate_del"], 255) + "'"; } if (!string.IsNullOrEmpty(request["enddate_del"])) { DateTime enddate = DateTime.Parse(request["enddate_del"]).AddHours(23).AddMinutes(59).AddSeconds(59); serchtxt += " and Delete_time <= '" + enddate + "'"; } //权限 DataSet ds = cci.GetList(PageSize, PageIndex, serchtxt, sorttext, out Total); string dt = Common.GetGridJSON.DataTableToJSON1(ds.Tables[0], Total); context.Response.Write(dt); } if (request["Action"] == "form") { int invoiceid = int.Parse(request["invoiceid"]); DataSet ds = cci.GetList("id=" + invoiceid); string dt = Common.DataToJson.DataToJSON(ds); context.Response.Write(dt); } //del if (request["Action"] == "del") { //参数安全过滤 string c_id = PageValidate.InputText(request["id"], 50); DataSet ds = cci.GetList("id=" + int.Parse(c_id)); bool isdel = cci.Delete(int.Parse(c_id)); //更新订单发票金额 BLL.CRM_order order = new BLL.CRM_order(); string orderid = ds.Tables[0].Rows[0]["order_id"].ToString(); order.UpdateInvoice(orderid); if (isdel) { //日志 string EventType = "开票删除"; int UserID = emp_id; string UserName = empname; string IPStreet = request.UserHostAddress; int EventID = int.Parse(c_id); string EventTitle = ds.Tables[0].Rows[0]["Customer_name"].ToString(); string Original_txt = ds.Tables[0].Rows[0]["invoice_amount"].ToString(); 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"); } } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; HttpRequest request = context.Request; BLL.CRM_Follow follow = new BLL.CRM_Follow(); Model.CRM_Follow model = new Model.CRM_Follow(); 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"] == "save") { model.Customer_id = int.Parse(request["cid"]); BLL.CRM_Customer ccc = new BLL.CRM_Customer(); string cname = ccc.GetList("id=" + model.Customer_id).Tables[0].Rows[0]["Customer"].ToString(); model.Customer_name = PageValidate.InputText(cname, 250); model.Follow = PageValidate.InputText(request["T_follow"], 4000); model.Follow_Type_id = int.Parse(request["T_followtype_val"]); model.Follow_Type = PageValidate.InputText(request["T_followtype"], 255); string fid = PageValidate.InputText(request["fid"], 50); if (!string.IsNullOrEmpty(fid) && fid != "null") { DataSet ds = follow.GetList("id=" + int.Parse(fid)); DataRow dr = ds.Tables[0].Rows[0]; model.id = int.Parse(fid); follow.Update(model); //最后跟进 ccc.UpdateLastFollow(model.Customer_id.ToString()); //日志 C_Sys_log log = new C_Sys_log(); int UserID = emp_id; string UserName = empname; string IPStreet = request.UserHostAddress; string EventTitle = model.Customer_name; string EventType = "客户跟进修改"; int EventID = model.id; if (dr["Follow"].ToString() != request["T_follow"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "跟进内容", "跟进内容被修改", "跟进内容被修改"); } if (dr["Follow_Type"].ToString() != request["T_followtype"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "跟进类型", dr["Follow_Type"].ToString(), request["T_followtype"]); } } else { model.isDelete = 0; DataRow dr1 = dsemp.Tables[0].Rows[0]; model.employee_id = int.Parse(dr1["ID"].ToString()); model.employee_name = dr1["name"].ToString(); string depid = dr1["d_id"].ToString(); if (string.IsNullOrEmpty(depid)) { depid = "0"; } model.department_id = int.Parse(depid); model.department_name = dr1["dname"].ToString(); model.Follow_date = DateTime.Now; int customerid = follow.Add(model); //最后跟进 ccc.UpdateLastFollow(model.Customer_id.ToString()); } if (!string.IsNullOrEmpty(request["T_content"])) { BLL.Personal_Calendar calendar = new BLL.Personal_Calendar(); Model.Personal_Calendar modelcalendar = new Model.Personal_Calendar(); int clientzone = 8; int serverzone = GetTimeZone(); var zonediff = serverzone - clientzone; modelcalendar.StartTime = DateTime.Parse(request["T_starttime"]).AddHours(zonediff); modelcalendar.EndTime = DateTime.Parse(request["T_endtime"]).AddHours(zonediff); modelcalendar.Subject = PageValidate.InputText("【" + cname + "】" + request["T_content"], 4000); modelcalendar.emp_id = emp_id; modelcalendar.UPAccount = emp_id.ToString(); modelcalendar.UPTime = DateTime.Now; modelcalendar.MasterId = clientzone; modelcalendar.CalendarType = 1; modelcalendar.Category = "4";//跟进提醒 modelcalendar.companyid = model.Customer_id; modelcalendar.InstanceType = 0; modelcalendar.IsAllDayEvent = PageValidate.InputText(request["allday"], 255) == "True" ? true : false; calendar.Add(modelcalendar); } } if (request["Action"] == "form") { DataSet ds = follow.GetList("id=" + int.Parse(request["fid"]) + DataAuth(emp_id.ToString())); string dt = Common.DataToJson.DataToJSON(ds); context.Response.Write(dt); } //del if (request["Action"] == "del") { string id = request["id"]; DataSet ds = follow.GetList("id=" + int.Parse(id)); bool canedel = true; if (uid != "admin") { Data.GetDataAuth dataauth = new Data.GetDataAuth(); string txt = dataauth.GetDataAuthByid("2", "Sys_del", emp_id.ToString()); string[] arr = txt.Split(':'); switch (arr[0]) { case "none": canedel = false; break; case "my": for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { if (ds.Tables[0].Rows[i]["employee_id"].ToString() == arr[1]) { canedel = true; } else { canedel = false; } } break; case "dep": for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { if (ds.Tables[0].Rows[i]["dep_id"].ToString() == arr[1]) { canedel = true; } else { canedel = false; } } break; case "all": canedel = true; break; } } if (canedel) { bool isdel = follow.Delete(int.Parse(request["id"])); //context.Response.Write("{success:success}"); if (isdel) { //日志 string EventType = "跟进删除"; int UserID = emp_id; string UserName = empname; string IPStreet = request.UserHostAddress; int EventID = int.Parse(id); string EventTitle = ds.Tables[0].Rows[0]["Customer_name"].ToString(); string Original_txt = ds.Tables[0].Rows[0]["Follow"].ToString(); string Current_txt = null; C_Sys_log log = new C_Sys_log(); log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "跟进", Original_txt, Current_txt); context.Response.Write("true"); } else { context.Response.Write("false"); } } else { context.Response.Write("delfalse"); } } //serch if (request["Action"] == "grid") { 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; string serchtxt = "1=1"; if (!string.IsNullOrEmpty(request["customer_id"])) { serchtxt += " and Customer_id=" + int.Parse(request["customer_id"]); } if (!string.IsNullOrEmpty(request["company"])) { serchtxt += " and Customer_name like N'%" + PageValidate.InputText(request["company"], 255) + "%'"; } if (!string.IsNullOrEmpty(request["department"])) { serchtxt += " and department_id = " + int.Parse(request["department_val"]); } if (!string.IsNullOrEmpty(request["employee"])) { serchtxt += " and employee_id = " + int.Parse(request["employee_val"]); } if (!string.IsNullOrEmpty(request["followtype"])) { serchtxt += " and Follow_Type_id = " + int.Parse(request["followtype_val"]); } if (!string.IsNullOrEmpty(request["startdate"])) { serchtxt += " and Follow_date >= '" + PageValidate.InputText(request["startdate"], 255) + "'"; } if (!string.IsNullOrEmpty(request["enddate"])) { DateTime enddate = DateTime.Parse(request["enddate"]).AddHours(23).AddMinutes(59).AddSeconds(59); serchtxt += " and Follow_date <= '" + enddate + "'"; } if (!string.IsNullOrEmpty(request["startdate_del"])) { serchtxt += " and Delete_time >= '" + PageValidate.InputText(request["startdate_del"], 255) + "'"; } if (!string.IsNullOrEmpty(request["enddate_del"])) { DateTime enddate = DateTime.Parse(request["enddate_del"]).AddHours(23).AddMinutes(59).AddSeconds(59); serchtxt += " and Delete_time <= '" + enddate + "'"; } if (!string.IsNullOrEmpty(request["T_smart"])) { if (request["T_smart"] != "输入关键词智能搜索跟进内容") { serchtxt += " and Follow like N'%" + PageValidate.InputText(request["T_smart"], 255) + "%'"; } } //权限 serchtxt += DataAuth(emp_id.ToString()); DataSet ds = follow.GetList(PageSize, PageIndex, serchtxt, sorttext, out Total); string dt = Common.GetGridJSON.DataTableToJSON1(ds.Tables[0], Total); context.Response.Write(dt); } if (request["Action"] == "Compared_follow") { string dt1 = request["date1"]; string dt2 = request["date2"]; DataSet ds = follow.Compared_follow(DateTime.Parse(dt1), DateTime.Parse(dt2)); string dt = GetGridJSON.DataTableToJSON(ds.Tables[0]); context.Response.Write(dt); } if (request["Action"] == "Compared_empcusfollow") { var idlist = PageValidate.InputText(request["idlist"].Replace(";", ",").Replace("-", ""), int.MaxValue); string dt1 = request["date1"]; string dt2 = request["date2"]; BLL.hr_post post = new BLL.hr_post(); DataSet dspost = post.GetList("post_id in(" + idlist + ")"); string emplist = "("; for (int i = 0; i < dspost.Tables[0].Rows.Count - 1; i++) { emplist += dspost.Tables[0].Rows[i]["emp_id"] + ","; } emplist += dspost.Tables[0].Rows[dspost.Tables[0].Rows.Count - 1]["emp_id"] + ")"; //context.Response.Write(emplist); DataSet ds = follow.Compared_empcusfollow(DateTime.Parse(dt1), DateTime.Parse(dt2), emplist); string dt = Common.GetGridJSON.DataTableToJSON(ds.Tables[0]); context.Response.Write(dt); } if (request["Action"] == "emp_cusfollow") { var idlist = PageValidate.InputText(request["idlist"].Replace(";", ",").Replace("-", ""), int.MaxValue); var syear = request["syear"]; BLL.hr_post post = new BLL.hr_post(); DataSet dspost = post.GetList("post_id in(" + idlist + ")"); string emplist = "("; for (int i = 0; i < dspost.Tables[0].Rows.Count - 1; i++) { emplist += dspost.Tables[0].Rows[i]["emp_id"] + ","; } emplist += dspost.Tables[0].Rows[dspost.Tables[0].Rows.Count - 1]["emp_id"] + ")"; //context.Response.Write(emplist); DataSet ds = follow.report_empfollow(int.Parse(syear), emplist); string dt = Common.GetGridJSON.DataTableToJSON(ds.Tables[0]); context.Response.Write(dt); } }
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(); 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"] == "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); } DataSet ds = post.GetList(0, serchtxt, " 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 = PageValidate.InputText(request["T_depname"], 250); //name model.post_name = PageValidate.InputText(request["T_postname"], 250); //position model.position_id = int.Parse(request["T_position_val"]); model.position_name = PageValidate.InputText(request["T_position"], 250); model.position_order = int.Parse(request["T_position_leavel"]); //emp int empid = Common.PageValidate.IsNumber(request["T_emp_val"]) ? int.Parse(request["T_emp_val"]) : -1; model.emp_id = empid; model.emp_name = PageValidate.InputText(request["T_emp"], 250); //note model.note = PageValidate.InputText(request["T_descript"], 4000); Model.hr_employee modelemp = new Model.hr_employee(); //更新员工岗位 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 = PageValidate.InputText(request["postid"], 50); 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"] == "del") { 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.Delete(int.Parse(postid)); 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"); } } } //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(" 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 = 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.hr_employee modelemp = new Model.hr_employee(); model.emp_id = Eid; modelemp.ID = Eid; model.emp_name = 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(" 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.CRM_product ccp = new BLL.CRM_product(); Model.CRM_product model = new Model.CRM_product(); 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"] == "save") { model.category_id = int.Parse(request["T_product_category_val"]); model.category_name = PageValidate.InputText(request["T_product_category"], 255); model.product_name = PageValidate.InputText(request["T_product_name"], 255); model.specifications = PageValidate.InputText(request["T_specifications"], 255); model.unit = PageValidate.InputText(request["T_product_unit"], 255); model.remarks = PageValidate.InputText(request["T_remarks"], 255); model.price = decimal.Parse(request["T_price"].ToString()); string pid = PageValidate.InputText(request["pid"], 50); if (!string.IsNullOrEmpty(pid) && pid != "null") { model.product_id = int.Parse(PageValidate.IsNumber(pid) ? pid : "-1"); DataSet ds = ccp.GetList(" product_id=" + int.Parse(pid)); DataRow dr = ds.Tables[0].Rows[0]; ccp.Update(model); //日志 C_Sys_log log = new C_Sys_log(); int UserID = emp_id; string UserName = empname; string IPStreet = request.UserHostAddress; string EventTitle = model.product_name; string EventType = "产品修改"; int EventID = model.product_id; if (dr["category_name"].ToString() != request["T_product_category"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "产品类别", dr["category_name"].ToString(), request["T_product_category"]); } if (dr["product_name"].ToString() != request["T_product_name"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "产品名字", dr["product_name"].ToString(), request["T_product_name"]); } if (dr["specifications"].ToString() != request["T_specifications"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "产品规格", dr["specifications"].ToString(), request["T_specifications"]); } if (dr["unit"].ToString() != request["T_product_unit"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "单位", dr["unit"].ToString(), request["T_product_unit"]); } if (dr["remarks"].ToString() != request["T_remarks"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "备注", dr["remarks"].ToString(), request["T_remarks"]); } if (dr["price"].ToString() != request["T_price"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "价格", dr["price"].ToString(), request["T_price"]); } } else { model.isDelete = 0; ccp.Add(model); } } if (request["Action"] == "grid") { 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 = " category_id"; } if (string.IsNullOrEmpty(sortorder)) { sortorder = "desc"; } string sorttext = " " + sortname + " " + sortorder; string Total; string serchtxt = "1=1"; if (!string.IsNullOrEmpty(request["categoryid"])) { serchtxt += string.Format(" and category_id={0}", int.Parse(request["categoryid"])); } if (!string.IsNullOrEmpty(request["stext"])) { serchtxt += " and product_name like N'%" + PageValidate.InputText(request["stext"], 255) + "%'"; } //权限 DataSet ds = ccp.GetList(PageSize, PageIndex, serchtxt, sorttext, out Total); string dt = Common.GetGridJSON.DataTableToJSON1(ds.Tables[0], Total); context.Response.Write(dt); } if (request["Action"] == "form") { int pid = int.Parse(request["pid"]); DataSet ds = ccp.GetList(" product_id=" + pid); string dt = Common.DataToJson.DataToJSON(ds); context.Response.Write(dt); } //del if (request["Action"] == "del") { //参数安全过滤 string c_id = PageValidate.InputText(request["id"], 50); DataSet ds = ccp.GetList(" product_id=" + int.Parse(c_id)); BLL.CRM_order_details ccod = new BLL.CRM_order_details(); if (ccod.GetList("product_id=" + int.Parse(c_id)).Tables[0].Rows.Count > 0) { //order context.Response.Write("false:order"); } else { bool isdel = ccp.Delete(int.Parse(c_id)); if (isdel) { //日志 string EventType = "产品删除"; int UserID = emp_id; string UserName = empname; string IPStreet = request.UserHostAddress; int EventID = int.Parse(c_id); string EventTitle = ds.Tables[0].Rows[0]["product_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"); } } } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; HttpRequest request = context.Request; BLL.CRM_order order = new BLL.CRM_order(); Model.CRM_order model = new Model.CRM_order(); 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"] == "save") { DataRow dremp = dsemp.Tables[0].Rows[0]; model.Customer_id = int.Parse(request["T_Customer_val"]); model.Customer_name = PageValidate.InputText(request["T_Customer"], 255); model.Order_date = DateTime.Parse(request["T_date"]); model.pay_type_id = int.Parse(request["T_paytype_val"]); model.pay_type = PageValidate.InputText(request["T_paytype"], 255); model.Order_details = PageValidate.InputText(request["T_details"].ToString(), 4000); model.Order_status_id = int.Parse(request["T_status_val"]); model.Order_status = PageValidate.InputText(request["T_status"], 255); model.Order_amount = decimal.Parse(request["T_amount"]); model.create_id = emp_id; model.create_date = DateTime.Now; model.C_dep_id = int.Parse(request["c_dep_val"]); model.C_dep_name = PageValidate.InputText(request["c_dep"], 255); model.C_emp_id = int.Parse(request["c_emp_val"]); model.C_emp_name = PageValidate.InputText(request["c_emp"], 255); model.F_dep_id = int.Parse(request["f_dep_val"]); model.F_dep_name = PageValidate.InputText(request["f_dep"], 255); model.F_emp_id = int.Parse(request["f_emp_val"]); model.F_emp_name = PageValidate.InputText(request["f_emp"], 255); int orderid; string pid = PageValidate.InputText(request["orderid"], 50); if (!string.IsNullOrEmpty(pid) && pid != "null") { model.id = int.Parse(PageValidate.IsNumber(pid) ? pid : "-1"); DataSet ds = order.GetList("id=" + model.id); DataRow dr = ds.Tables[0].Rows[0]; orderid = model.id; order.Update(model); //context.Response.Write(model.id ); context.Response.Write("{success:success}"); C_Sys_log log = new C_Sys_log(); int UserID = emp_id; string UserName = empname; string IPStreet = request.UserHostAddress; string EventTitle = model.Customer_name; string EventType = "订单修改"; int EventID = model.id; if (dr["Customer_name"].ToString() != request["T_Customer"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "客户", dr["Customer_name"].ToString(), request["T_Customer"]); } if (dr["Order_details"].ToString() != request["T_details"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "订单详情", "原内容被修改", "原内容被修改"); } if (dr["Order_date"].ToString() != request["T_date"].ToString() + " 0:00:00") { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "成交时间", dr["Order_date"].ToString(), request["T_date"].ToString() + " 0:00:00"); } if (dr["Order_amount"].ToString() != request["T_amount"].Replace(",", "").Replace(".00", "")) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "订单总额", dr["Order_amount"].ToString(), request["T_amount"].Replace(",", "").Replace(".00", "")); } if (dr["Order_status"].ToString() != request["T_status"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "订单状态", dr["Order_status"].ToString(), request["T_status"]); } if (dr["F_dep_name"].ToString() != request["f_dep"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "促成人员部门", dr["F_dep_name"].ToString(), request["f_dep"]); } if (dr["F_emp_name"].ToString() != request["f_emp"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "促成人员", dr["F_emp_name"].ToString(), request["f_emp"]); } if (dr["pay_type"].ToString() != request["T_paytype"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "支付方式", dr["pay_type"].ToString(), request["T_paytype"]); } } else { model.isDelete = 0; model.Serialnumber = DateTime.Now.AddMilliseconds(3).ToString("yyyyMMddHHmmssfff").Trim(); //model.arrears_invoice = decimal.Parse(request["T_amount"]); orderid = order.Add(model); context.Response.Write("{success:success}"); } //更新订单收款金额 order.UpdateReceive(orderid.ToString()); //更新订单发票金额 order.UpdateInvoice(orderid.ToString()); string json = request["PostData"].ToLower(); JavaScriptSerializer js = new JavaScriptSerializer(); PostData[] postdata; postdata = js.Deserialize <PostData[]>(json); BLL.CRM_order_details cod = new BLL.CRM_order_details(); Model.CRM_order_details modeldel = new Model.CRM_order_details(); modeldel.order_id = orderid; cod.Delete(" order_id=" + modeldel.order_id); for (int i = 0; i < postdata.Length; i++) { modeldel.product_id = postdata[i].Product_id; modeldel.product_name = postdata[i].Product_name; modeldel.quantity = postdata[i].Quantity; modeldel.unit = postdata[i].Unit; modeldel.price = postdata[i].Price; modeldel.amount = postdata[i].Amount; cod.Add(modeldel); } } if (request["Action"] == "grid") { 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; string serchtxt = "1=1"; string issar = request["issarr"]; if (issar == "1") { serchtxt += " and isnull( arrears_money,0)>0"; } if (!string.IsNullOrEmpty(request["company"])) { serchtxt += " and Customer_name like N'%" + PageValidate.InputText(request["company"], 100) + "%'"; } if (!string.IsNullOrEmpty(request["contact"])) { serchtxt += " and Order_status_id = " + int.Parse(request["contact_val"]); } if (!string.IsNullOrEmpty(request["department"])) { serchtxt += " and F_dep_id = " + int.Parse(request["department_val"]); } if (!string.IsNullOrEmpty(request["employee"])) { serchtxt += " and F_emp_id = " + int.Parse(request["employee_val"]); } if (!string.IsNullOrEmpty(request["startdate"])) { serchtxt += " and Order_date >= '" + PageValidate.InputText(request["startdate"], 255) + "'"; } if (!string.IsNullOrEmpty(request["enddate"])) { DateTime enddate = DateTime.Parse(request["enddate"]); serchtxt += " and Order_date <= '" + DateTime.Parse(request["enddate"]).AddHours(23).AddMinutes(59).AddSeconds(59) + "'"; } if (!string.IsNullOrEmpty(request["startdate_del"])) { serchtxt += " and Delete_time >= '" + PageValidate.InputText(request["startdate_del"], 255) + "'"; } if (!string.IsNullOrEmpty(request["enddate_del"])) { DateTime enddate = DateTime.Parse(request["enddate_del"]).AddHours(23).AddMinutes(59).AddSeconds(59); serchtxt += " and Delete_time <= '" + enddate + "'"; } //权限 serchtxt += DataAuth(emp_id.ToString()); DataSet ds = order.GetList(PageSize, PageIndex, serchtxt, sorttext, out Total); string dt = Common.GetGridJSON.DataTableToJSON1(ds.Tables[0], Total); context.Response.Write(dt); } if (request["Action"] == "gridbycustomerid") { string customerid = PageValidate.InputText(request["customerid"], 50); DataSet ds = order.GetList(0, " Customer_id =" + int.Parse(customerid), " Order_date desc"); context.Response.Write(Common.GetGridJSON.DataTableToJSON(ds.Tables[0])); } if (request["Action"] == "form") { int pid = int.Parse(request["orderid"]); DataSet ds = order.GetList("id=" + pid); string dt = Common.DataToJson.DataToJSON(ds); context.Response.Write(dt); } if (request["Action"] == "del") { //参数安全过滤 string c_id = PageValidate.InputText(request["id"], 50); DataSet ds = order.GetList("id=" + int.Parse(c_id)); BLL.CRM_contract contract = new BLL.CRM_contract(); BLL.CRM_invoice invoice = new BLL.CRM_invoice(); BLL.CRM_receive receive = new BLL.CRM_receive(); if (invoice.GetList("order_id=" + int.Parse(c_id)).Tables[0].Rows.Count > 0) { //invoice context.Response.Write("false:invoice"); } else if (receive.GetList("order_id=" + int.Parse(c_id)).Tables[0].Rows.Count > 0) { //receive context.Response.Write("false:receive"); } else { bool canedel = true; if (uid != "admin") { Data.GetDataAuth dataauth = new Data.GetDataAuth(); string txt = dataauth.GetDataAuthByid("3", "Sys_del", emp_id.ToString()); string[] arr = txt.Split(':'); switch (arr[0]) { case "none": canedel = false; break; case "my": for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { if (ds.Tables[0].Rows[i]["C_emp_id"].ToString() == arr[1]) { canedel = true; } else { canedel = false; } } break; case "dep": for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { if (ds.Tables[0].Rows[i]["C_dep_id"].ToString() == arr[1]) { canedel = true; } else { canedel = false; } } break; case "all": canedel = true; break; } } if (canedel) { bool isdel = order.Delete(int.Parse(c_id)); BLL.CRM_order_details cod = new BLL.CRM_order_details(); cod.Delete("order_id=" + int.Parse(c_id)); if (isdel) { //日志 string EventType = "订单删除"; int UserID = emp_id; string UserName = empname; string IPStreet = request.UserHostAddress; int EventID = int.Parse(c_id); string EventTitle = ds.Tables[0].Rows[0]["Customer_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"); } } else { context.Response.Write("delfalse"); } } } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; HttpRequest request = context.Request; BLL.CRM_contract cc = new BLL.CRM_contract(); Model.CRM_contract model = new Model.CRM_contract(); 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"] == "save") { DataRow dremp = dsemp.Tables[0].Rows[0]; model.Serialnumber = PageValidate.InputText(request["T_contract_num"], 255); model.Contract_name = PageValidate.InputText(request["T_contract_name"], 255); model.Customer_id = int.Parse(request["T_Customer_val"]); model.Customer_name = PageValidate.InputText(request["T_Customer"], 255); model.C_depid = int.Parse(request["c_dep_val"].ToString()); model.C_depname = PageValidate.InputText(request["c_dep"].ToString(), 255); model.C_empid = int.Parse(request["c_emp_val"].ToString()); model.C_empname = PageValidate.InputText(request["c_emp"].ToString(), 255); model.Contract_amount = decimal.Parse(request["T_contract_amount"]); model.Pay_cycle = int.Parse(request["T_pay_cycle"]); model.Start_date = PageValidate.InputText(request["T_start_date"].ToString(), 255); model.End_date = PageValidate.InputText(request["T_end_date"].ToString(), 255); model.Sign_date = PageValidate.InputText(request["T_contract_date"].ToString(), 255); model.Customer_Contractor = PageValidate.InputText(request["T_contractor"].ToString(), 255); model.Our_Contractor_depid = int.Parse(request["f_dep_val"].ToString()); model.Our_Contractor_depname = PageValidate.InputText(request["f_dep"], 255); model.Our_Contractor_id = int.Parse(request["f_emp_val"].ToString()); model.Our_Contractor_name = PageValidate.InputText(request["f_emp"].ToString(), 255); model.Main_Content = PageValidate.InputText(request["T_content"].ToString(), int.MaxValue); model.Remarks = PageValidate.InputText(request["T_remarks"].ToString(), int.MaxValue); string cid = PageValidate.InputText(request["cid"], 50); int contract_id = -1; if (!string.IsNullOrEmpty(cid) && cid != "null") { contract_id = int.Parse(cid); model.id = contract_id; DataSet ds = cc.GetList(" id=" + model.id); DataRow dr = ds.Tables[0].Rows[0]; cc.Update(model); C_Sys_log log = new C_Sys_log(); int UserID = emp_id; string UserName = empname; string IPStreet = request.UserHostAddress; string EventTitle = model.Contract_name; string EventType = "合同修改"; int EventID = model.id; if (dr["Customer_name"].ToString() != request["T_Customer"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "客户", dr["Customer_name"].ToString(), request["T_Customer"]); } if (dr["Contract_name"].ToString() != request["T_contract_name"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "合同名称", dr["Contract_name"].ToString(), request["T_contract_name"]); } if (dr["Serialnumber"].ToString() != request["T_contract_num"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "合同编号", dr["Serialnumber"].ToString(), request["T_contract_num"]); } if (dr["Contract_amount"].ToString() != request["T_contract_amount"].Replace(",", "").Replace(".00", "")) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "合同金额", dr["Contract_amount"].ToString(), request["T_contract_amount"].Replace(",", "").Replace(".00", "")); } if (dr["Customer_Contractor"].ToString() != request["T_contractor"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "对方签约人", dr["Customer_Contractor"].ToString(), request["T_contractor"]); } if (dr["Our_Contractor_depname"].ToString() != request["f_dep"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "我方签约人部门", dr["Our_Contractor_depname"].ToString(), request["f_dep"]); } if (dr["Our_Contractor_name"].ToString() != request["f_emp"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "我方签约人名字", dr["Our_Contractor_name"].ToString(), request["f_emp"]); } if (dr["Main_Content"].ToString() != request["T_content"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "主要条款", "原内容被修改", "原内容被修改"); } if (dr["Remarks"].ToString() != request["T_remarks"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "备注", "原内容被修改", "原内容被修改"); } if (dr["Start_date"].ToString() != request["T_start_date"].ToString()) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "开始时间", dr["Start_date"].ToString(), request["T_start_date"].ToString()); } if (dr["End_date"].ToString() != request["T_end_date"].ToString()) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "结束时间", dr["End_date"].ToString(), request["T_end_date"].ToString()); } if (dr["Sign_date"].ToString() != request["T_contract_date"].ToString()) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "签约时间", dr["Sign_date"].ToString(), request["T_contract_date"].ToString()); } } else { model.isDelete = 0; model.Creater_id = emp_id; model.Creater_name = dremp["name"].ToString(); model.Create_time = DateTime.Now; contract_id = cc.Add(model); } //attachment BLL.CRM_contract_attachment cca = new BLL.CRM_contract_attachment(); string page_id = PageValidate.InputText(request["page_id"], 255); cca.UpdateMailid(contract_id, page_id); } if (request["Action"] == "grid") { 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; string serchtxt = "1=1"; string customer_id = request["cid"]; if (!string.IsNullOrEmpty(customer_id) && customer_id != "null") { serchtxt += " and Customer_id=" + int.Parse(customer_id); } if (!string.IsNullOrEmpty(request["company"])) { serchtxt += " and Customer_name like N'%" + PageValidate.InputText(request["company"], 255) + "%'"; } if (!string.IsNullOrEmpty(request["contact"])) { serchtxt += " and Contract_name like N'%" + PageValidate.InputText(request["contact"], 255) + "%'"; } if (!string.IsNullOrEmpty(request["department"])) { serchtxt += " and C_depid =" + int.Parse(request["department_val"]); } if (!string.IsNullOrEmpty(request["employee"])) { serchtxt += " and C_empid =" + int.Parse(request["employee_val"]); } if (!string.IsNullOrEmpty(request["startdate"])) { serchtxt += " and Create_time >= '" + PageValidate.InputText(request["startdate"], 255) + "'"; } if (!string.IsNullOrEmpty(request["enddate"])) { DateTime enddate = DateTime.Parse(request["enddate"]).AddHours(23).AddMinutes(59).AddSeconds(59); serchtxt += " and Create_time <= '" + enddate + "'"; } if (!string.IsNullOrEmpty(request["startdate_del"])) { serchtxt += " and Delete_time >= '" + PageValidate.InputText(request["startdate_del"], 255) + "'"; } if (!string.IsNullOrEmpty(request["enddate_del"])) { DateTime enddate = DateTime.Parse(request["enddate_del"]).AddHours(23).AddMinutes(59).AddSeconds(59); serchtxt += " and Delete_time <= '" + enddate + "'"; } //权限 serchtxt += DataAuth(emp_id.ToString()); DataSet ds = cc.GetList(PageSize, PageIndex, serchtxt, sorttext, out Total); context.Response.Write(Common.GetGridJSON.DataTableToJSON1(ds.Tables[0], Total)); } if (request["Action"] == "form") { string contract_id = request["cid"]; DataSet ds = cc.GetList("id=" + int.Parse(contract_id) + DataAuth(emp_id.ToString())); string dt = Common.DataToJson.DataToJSON(ds); context.Response.Write(dt); } //del if (request["Action"] == "del") { string c_id = PageValidate.InputText(request["id"], 50); DataSet ds = cc.GetList("id=" + int.Parse(c_id)); bool canedel = true; if (uid != "admin") { Data.GetDataAuth dataauth = new Data.GetDataAuth(); string txt = dataauth.GetDataAuthByid("4", "Sys_del", emp_id.ToString()); string[] arr = txt.Split(':'); switch (arr[0]) { case "none": canedel = false; break; case "my": for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { if (ds.Tables[0].Rows[i]["C_empid"].ToString() == arr[1]) { canedel = true; } else { canedel = false; } } break; case "dep": for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { if (ds.Tables[0].Rows[i]["C_depid"].ToString() == arr[1]) { canedel = true; } else { canedel = false; } } break; case "all": canedel = true; break; } } if (canedel) { bool isdel = cc.Delete(int.Parse(c_id)); BLL.CRM_contract_attachment atta = new BLL.CRM_contract_attachment(); atta.Delete("contract_id=" + int.Parse(c_id)); if (isdel) { //日志 string EventType = "合同删除"; int UserID = emp_id; string UserName = empname; string IPStreet = request.UserHostAddress; int EventID = int.Parse(c_id); string EventTitle = ds.Tables[0].Rows[0]["Contract_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"] == "Compared_empcuscontract") { var idlist = PageValidate.InputText(request["idlist"].Replace(";", ",").Replace("-", ""), int.MaxValue); string dt1 = request["date1"]; string dt2 = request["date2"]; BLL.hr_post post = new BLL.hr_post(); DataSet dspost = post.GetList("post_id in(" + idlist + ")"); string emplist = "("; for (int i = 0; i < dspost.Tables[0].Rows.Count - 1; i++) { emplist += dspost.Tables[0].Rows[i]["emp_id"] + ","; } emplist += dspost.Tables[0].Rows[dspost.Tables[0].Rows.Count - 1]["emp_id"] + ")"; //context.Response.Write(emplist); DataSet ds = cc.Compared_empcuscontract(DateTime.Parse(dt1), DateTime.Parse(dt2), emplist); string dt = Common.GetGridJSON.DataTableToJSON(ds.Tables[0]); context.Response.Write(dt); } if (request["Action"] == "emp_cuscontract") { var idlist = PageValidate.InputText(request["idlist"].Replace(";", ",").Replace("-", ""), int.MaxValue); var syear = request["syear"]; BLL.hr_post post = new BLL.hr_post(); DataSet dspost = post.GetList("post_id in(" + idlist + ")"); string emplist = "("; for (int i = 0; i < dspost.Tables[0].Rows.Count - 1; i++) { emplist += dspost.Tables[0].Rows[i]["emp_id"] + ","; } emplist += dspost.Tables[0].Rows[dspost.Tables[0].Rows.Count - 1]["emp_id"] + ")"; //context.Response.Write(emplist); DataSet ds = cc.report_empcontract(int.Parse(syear), emplist); string dt = Common.GetGridJSON.DataTableToJSON(ds.Tables[0]); context.Response.Write(dt); } }