public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; HttpRequest request = context.Request; if (request["Action"] == "grid") { BLL.CRM_order_details cod = new BLL.CRM_order_details(); string orderid = request["orderid"]; DataSet ds = cod.GetList(" order_id=" + int.Parse( orderid)); context.Response.Write(Common.GetGridJSON.DataTableToJSON(ds.Tables[0])); } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; HttpRequest request = context.Request; if (request["Action"] == "grid") { BLL.CRM_order_details cod = new BLL.CRM_order_details(); string orderid = request["orderid"]; DataSet ds = cod.GetList(" order_id=" + int.Parse(orderid)); context.Response.Write(Common.GetGridJSON.DataTableToJSON(ds.Tables[0])); } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; HttpRequest request = context.Request; 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") { BLL.CRM_order_details cod = new BLL.CRM_order_details(); string orderid = request["orderid"]; DataSet ds = cod.GetList(" order_id=" + int.Parse(orderid)); context.Response.Write(Common.GetGridJSON.DataTableToJSON(ds.Tables[0])); } }
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(); BLL.hr_employee emp = new BLL.hr_employee(); int emp_id = int.Parse(request.Cookies["UserID"].Value); 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.pway_content = PageValidate.InputText(request["T_pway_content"], 255); model.price = decimal.Parse(request["T_price"].ToString()); model.base_price = decimal.Parse(request["T_base_price"].ToString()); string pid = request["pid"]; 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"]); } if (dr["base_price"].ToString() != request["T_base_price"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "底价", dr["base_price"].ToString(), request["T_base_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 = null; string serchtype = request["isdel"]; if (serchtype == "1") { serchtxt += " isDelete=1 "; } else { serchtxt += " isDelete=0 "; } string categoryid = request["categoryid"]; if (!string.IsNullOrEmpty(categoryid) && categoryid != "null") { serchtxt += " and category_id=" + (PageValidate.IsNumber(categoryid) ? categoryid : "-1"); } if (!string.IsNullOrEmpty(request["company"])) serchtxt += " and product_name like N'%" + PageValidate.InputText( request["company"],255) + "%'"; 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 = ccp.GetList(PageSize, PageIndex, serchtxt, sorttext, out Total); string dt = Common.GetGridJSON.DataTableToJSON1(ds.Tables[0], Total); context.Response.Write(dt); } if (request["Action"] == "gridmode") { int pid = int.Parse(request["pid"]); DataSet ds = ccp.GetModeList(" product_id=" + pid); /* //string dt = Common.DataToJson.DataToJSON(ds); string dt = Common.GetGridJSON.DataTableToJSON1(ds.Tables[0], "0"); context.Response.Write(dt); */ string modescript = ""; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { modescript += "{"; modescript += "id: '" + ds.Tables[0].Rows[i]["mode_name"].ToString() + "',"; modescript += "text: '" + ds.Tables[0].Rows[i]["mode_name"].ToString() + "'"; modescript += "},"; } if (modescript != "") modescript = modescript.Substring(0, modescript.Length - 1); modescript = "{Rows:[" + modescript; modescript += "]}"; context.Response.Write(modescript); } 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"] == "AdvanceDelete") { //参数安全过滤 string c_id = request["id"]; 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=" + c_id).Tables[0].Rows.Count > 0) { //order context.Response.Write("false:order"); } else { bool isdel = ccp.AdvanceDelete(int.Parse(c_id), 1, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); 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"); } } } //regain if (request["Action"] == "regain") { string idlist = PageValidate.InputText( request["idlist"],100000); string[] arr = idlist.Split(','); DataSet ds = ccp.GetList("product_id in (" + idlist.Trim() + ")"); for (int i = 0; i < arr.Length; i++) { ccp.AdvanceDelete(int.Parse(arr[i]), 0, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); } if (true) { //日志 string EventType = "恢复删除产品"; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { int UserID = emp_id; string UserName = empname; int EventID = idlist[i]; string IPStreet = request.UserHostAddress; string EventTitle = ds.Tables[0].Rows[i]["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"); } } ////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(request.Cookies["UserID"].Value, "76"); if (delauth == "false") canDel = false; else canDel = true; } } if (canDel) { string idlist = PageValidate.InputText( request["idlist"],100000); string[] arr = idlist.Split(','); string EventType = "彻底删除产品"; DataSet ds = ccp.GetList(" product_id in (" + idlist.Trim() + ")"); for (int i = 0; i < arr.Length; i++) { ccp.Delete(int.Parse(arr[i])); } if (true) { //日志 for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { int UserID = emp_id; string UserName = empname; string IPStreet = request.UserHostAddress; int EventID = idlist[i]; string EventTitle = ds.Tables[0].Rows[i]["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"); } } else { context.Response.Write("auth"); } } //serch }
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(); BLL.hr_employee emp = new BLL.hr_employee(); int emp_id = int.Parse(request.Cookies["UserID"].Value); 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 = request["pid"]; 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 { 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 = " product_name"; } if (string.IsNullOrEmpty(sortorder)) { sortorder = "desc"; } string sorttext = " " + sortname + " " + sortorder; string Total; string serchtxt = null; string serchtype = request["isdel"]; if (serchtype == "1") { serchtxt += " ISNULL(isDelete,0)=1 "; } else { serchtxt += "ISNULL(isDelete,0)=0 "; } string categoryid = request["categoryid"]; if (!string.IsNullOrEmpty(categoryid) && categoryid != "null") { serchtxt += " and category_id=" + (PageValidate.IsNumber(categoryid) ? categoryid : "-1"); } if (!string.IsNullOrEmpty(request["company"])) { serchtxt += " and product_name like N'%" + PageValidate.InputText(request["company"], 255) + "%'"; } 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 = 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"] == "AdvanceDelete") { //参数安全过滤 string c_id = request["id"]; 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=" + c_id).Tables[0].Rows.Count > 0) { //order context.Response.Write("false:order"); } else { bool isdel = ccp.AdvanceDelete(int.Parse(c_id), 1, DateTime.Now.ToString(StaticStr.yyyy_MM_dd_HH_mm_ss)); 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"); } } } //regain if (request["Action"] == "regain") { string idlist = PageValidate.InputText(request["idlist"], 100000); string[] arr = idlist.Split(','); DataSet ds = ccp.GetList("product_id in (" + idlist.Trim() + ")"); for (int i = 0; i < arr.Length; i++) { ccp.AdvanceDelete(int.Parse(arr[i]), 0, DateTime.Now.ToString(StaticStr.yyyy_MM_dd_HH_mm_ss)); } if (true) { //日志 string EventType = "恢复删除产品"; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { int UserID = emp_id; string UserName = empname; int EventID = idlist[i]; string IPStreet = request.UserHostAddress; string EventTitle = ds.Tables[0].Rows[i]["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"); } } ////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(request.Cookies["UserID"].Value, "76"); if (delauth == "false") { canDel = false; } else { canDel = true; } } } if (canDel) { string idlist = PageValidate.InputText(request["idlist"], 100000); string[] arr = idlist.Split(','); string EventType = "彻底删除产品"; DataSet ds = ccp.GetList(" product_id in (" + idlist.Trim() + ")"); for (int i = 0; i < arr.Length; i++) { ccp.Delete(int.Parse(arr[i])); } if (true) { //日志 for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { int UserID = emp_id; string UserName = empname; string IPStreet = request.UserHostAddress; int EventID = idlist[i]; string EventTitle = ds.Tables[0].Rows[i]["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"); } } else { context.Response.Write("auth"); } } //serch }
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(); BLL.hr_employee emp = new BLL.hr_employee(); int emp_id = int.Parse(request.Cookies["UserID"].Value); 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 = int.Parse(dremp["ID"].ToString()); model.create_date = DateTime.Now; model.C_dep_id = int.Parse(request["T_department_val"]); model.C_dep_name = PageValidate.InputText(request["T_department"], 255); model.C_emp_id = int.Parse(request["T_employee_val"]); model.C_emp_name = PageValidate.InputText(request["T_employee"], 255); model.F_dep_id = int.Parse(request["T_department1_val"]); model.F_dep_name = PageValidate.InputText(request["T_department1"], 255); model.F_emp_id = int.Parse(request["T_employee1_val"]); model.F_emp_name = PageValidate.InputText(request["T_employee1"], 255); int orderid; string pid = request["orderid"]; 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["T_department1"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "促成人员部门", dr["F_dep_name"].ToString(), request["T_department1"]); } if (dr["F_emp_name"].ToString() != request["T_employee1"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "促成人员", dr["F_emp_name"].ToString(), request["T_employee1"]); } 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.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 = " Create_date"; } if (string.IsNullOrEmpty(sortorder)) { sortorder = "desc"; } string sorttext = " " + sortname + " " + sortorder; string Total; string serchtxt = null; string serchtype = request["isdel"]; if (serchtype == "1") { serchtxt += " ISNULL(isDelete,0)=1 "; } else { serchtxt += "ISNULL(isDelete,0)=0 "; } 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 + "'"; } //权限 DataSet ds = order.GetList(PageSize, PageIndex, serchtxt, sorttext, out Total); DataSet dsauth = DataAuth(ds, request.Cookies["UserID"].Value); string dt = Common.GetGridJSON.DataTableToJSON1(dsauth.Tables[0], Total); context.Response.Write(dt); } if (request["Action"] == "gridbycustomerid") { string customerid = request["customerid"]; DataSet ds = order.GetList(0, " ISNULL(isDelete,0)=0 and 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"] == "AdvanceDelete") { //参数安全过滤 string c_id = request["id"]; DataSet ds = order.GetList("id=" + 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=" + c_id).Tables[0].Rows.Count > 0) { //invoice context.Response.Write("false:invoice"); } else if (receive.GetList("order_id=" + 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.AdvanceDelete(int.Parse(c_id), 1, DateTime.Now.ToString(StaticStr.yyyy_MM_dd_HH_mm_ss)); 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"); } } } //regain if (request["Action"] == "regain") { string idlist = PageValidate.InputText(request["idlist"], 100000); string[] arr = idlist.Split(','); DataSet ds = order.GetList("id in (" + idlist.Trim() + ")"); for (int i = 0; i < arr.Length; i++) { order.AdvanceDelete(int.Parse(arr[i]), 0, DateTime.Now.ToString(StaticStr.yyyy_MM_dd_HH_mm_ss)); } if (true) { string EventType = "恢复删除订单"; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { int UserID = emp_id; string UserName = empname; int EventID = idlist[i]; string IPStreet = request.UserHostAddress; string EventTitle = ds.Tables[0].Rows[i]["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"); } } if (request["Action"] == "del") { bool canDel = false; if (dsemp.Tables[0].Rows.Count > 0) { if (dsemp.Tables[0].Rows[0]["uid"].ToString() == "admin") { canDel = true; } else { Data.GetAuthorityByUid getauth = new Data.GetAuthorityByUid(); string delauth = getauth.GetBtnAuthority(request.Cookies["UserID"].Value, "66"); if (delauth == "false") { canDel = false; } else { canDel = true; } } } if (canDel) { string idlist = PageValidate.InputText(request["idlist"], 100000); string[] arr = idlist.Split(','); string EventType = "彻底删除订单"; DataSet ds = order.GetList("id in (" + idlist.Trim() + ")"); bool cando = true; for (int i = 0; i < arr.Length; i++) { bool deleted = order.Delete(int.Parse(arr[i])); if (!deleted) { cando = false; } } if (cando) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { //日志 int UserID = emp_id; string UserName = empname; string IPStreet = request.UserHostAddress; int EventID = idlist[i]; string EventTitle = ds.Tables[0].Rows[i]["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("auth"); } } }
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(); BLL.hr_employee emp = new BLL.hr_employee(); int emp_id = int.Parse(request.Cookies["UserID"].Value); 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 = int.Parse(dremp["ID"].ToString()); model.create_date = DateTime.Now; model.C_dep_id = int.Parse(request["T_department_val"]); model.C_dep_name = PageValidate.InputText(request["T_department"], 255); model.C_emp_id = int.Parse(request["T_employee_val"]); model.C_emp_name = PageValidate.InputText(request["T_employee"], 255); model.F_dep_id = int.Parse(request["T_department1_val"]); model.F_dep_name = PageValidate.InputText(request["T_department1"], 255); model.F_emp_id = int.Parse(request["T_employee1_val"]); model.F_emp_name = PageValidate.InputText(request["T_employee1"], 255); int orderid; string pid = request["orderid"]; 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["T_department1"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "促成人员部门", dr["F_dep_name"].ToString(), request["T_department1"]); } if (dr["F_emp_name"].ToString() != request["T_employee1"]) { log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "促成人员", dr["F_emp_name"].ToString(), request["T_employee1"]); } 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 = null; string serchtype = request["isdel"]; if (serchtype == "1") { serchtxt += " isDelete=1 "; } else { serchtxt += " isDelete=0 "; } 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(request.Cookies["UserID"].Value); 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 = request["customerid"]; DataSet ds = order.GetList(0, " isDelete=0 and 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"] == "AdvanceDelete") { //参数安全过滤 string c_id = request["id"]; DataSet ds = order.GetList("id=" + 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=" + c_id).Tables[0].Rows.Count > 0) { //invoice context.Response.Write("false:invoice"); } else if (receive.GetList("order_id=" + 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.AdvanceDelete(int.Parse(c_id), 1, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); 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"); } } } //regain if (request["Action"] == "regain") { string idlist = PageValidate.InputText(request["idlist"], 100000); string[] arr = idlist.Split(','); DataSet ds = order.GetList("id in (" + idlist.Trim() + ")"); for (int i = 0; i < arr.Length; i++) { order.AdvanceDelete(int.Parse(arr[i]), 0, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); } if (true) { string EventType = "恢复删除订单"; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { int UserID = emp_id; string UserName = empname; int EventID = idlist[i]; string IPStreet = request.UserHostAddress; string EventTitle = ds.Tables[0].Rows[i]["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"); } } if (request["Action"] == "del") { bool canDel = false; if (dsemp.Tables[0].Rows.Count > 0) { if (dsemp.Tables[0].Rows[0]["uid"].ToString() == "admin") { canDel = true; } else { Data.GetAuthorityByUid getauth = new Data.GetAuthorityByUid(); string delauth = getauth.GetBtnAuthority(request.Cookies["UserID"].Value, "66"); if (delauth == "false") canDel = false; else canDel = true; } } if (canDel) { string idlist = PageValidate.InputText(request["idlist"], 100000); string[] arr = idlist.Split(','); string EventType = "彻底删除订单"; DataSet ds = order.GetList("id in (" + idlist.Trim() + ")"); bool cando = true; for (int i = 0; i < arr.Length; i++) { bool deleted = order.Delete(int.Parse(arr[i])); if (!deleted) cando = false; } if (cando) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { //日志 int UserID = emp_id; string UserName = empname; string IPStreet = request.UserHostAddress; int EventID = idlist[i]; string EventTitle = ds.Tables[0].Rows[i]["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("auth"); } } }