public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; HttpRequest request = context.Request; BLL.CRM_contract_attachment cca = new BLL.CRM_contract_attachment(); Model.CRM_contract_attachment model = new Model.CRM_contract_attachment(); 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"] == "insert_attachment") { string fileName = PageValidate.InputText(request["filename"], 250); //文件路径 fileName = fileName.Substring(fileName.LastIndexOf('\\') + 1); string sExt = fileName.Substring(fileName.LastIndexOf(".")).ToLower(); DateTime now = DateTime.Now; string nowfileName = now.ToString("yyyyMMddHHmmss") + GetRandom(6) + sExt; HttpPostedFile uploadFile = request.Files[0]; uploadFile.SaveAs(context.Server.MapPath(@"~/file/contract/" + nowfileName)); context.Response.Write(nowfileName); string contract_id = PageValidate.InputText(request["contract_id"], 50); if (PageValidate.IsNumber(contract_id)) { model.contract_id = int.Parse(contract_id); } model.file_id = Guid.NewGuid().ToString(); model.file_name = fileName; model.real_name = nowfileName; model.page_id = PageValidate.InputText(request["page_id"], 255); model.file_size = uploadFile.ContentLength; model.create_id = emp_id; model.create_name = PageValidate.InputText(empname, 255); model.create_date = DateTime.Now; cca.Add(model); } if (request["Action"] == "flush_attachment") { string page_id = PageValidate.InputText(request["page_id"], 255); DataSet attachment = cca.GetList("page_id='" + page_id + "'"); cca.Delete("page_id='" + page_id + "'"); for (int i = 0; i < attachment.Tables[0].Rows.Count; i++) { try { string filename = attachment.Tables[0].Rows[i]["real_name"].ToString(); string sExt = filename.Substring(filename.LastIndexOf('.')); string html = filename.Substring(0, filename.Length - sExt.Length) + ".html"; string files = filename.Substring(0, filename.Length - sExt.Length) + ".files"; File.Delete(HttpContext.Current.Server.MapPath("../file/contract/" + filename)); File.Delete(HttpContext.Current.Server.MapPath("../file/contract/" + html)); DirectoryInfo dir = new DirectoryInfo(HttpContext.Current.Server.MapPath("../file/contract/" + files)); dir.Delete(true); } catch { } } } if (request["Action"] == "del_attachment") { string file_id = PageValidate.InputText(request["file_id"], 255); string page_id = PageValidate.InputText(request["page_id"], 255); DataSet attachment = cca.GetList("file_id='" + file_id + "' and page_id='" + page_id + "'"); cca.Delete("file_id='" + file_id + "' and page_id='" + page_id + "'"); for (int i = 0; i < attachment.Tables[0].Rows.Count; i++) { try { File.Delete(HttpContext.Current.Server.MapPath("../file/contract/" + attachment.Tables[0].Rows[i]["real_name"].ToString())); } catch { } } } if (request["Action"] == "get_attachment") { string whereStr = ""; string contract_id = PageValidate.InputText(request["contract_id"], 50); string page_id = PageValidate.InputText(request["page_id"], 50); if (!string.IsNullOrEmpty(contract_id) && contract_id != "null") { whereStr = string.Format(" contract_id={0}", contract_id); } else if (!string.IsNullOrEmpty(page_id) && page_id != "null") { whereStr = string.Format(" page_id={0}", page_id); } else { whereStr = " 1=2 "; } DataSet ds = cca.GetList(whereStr); string dt = Common.GetGridJSON.DataTableToJSON(ds.Tables[0]); context.Response.Write(dt); } if (request["Action"] == "get_realname") { string page_id = PageValidate.InputText(request["page_id"], 255); string file_name = PageValidate.InputText(request["filename"], 255); DataSet ds = cca.GetList(string.Format("page_id='{0}' and file_name='{1}'", page_id, file_name)); if (ds.Tables[0].Rows.Count > 0) { context.Response.Write(ds.Tables[0].Rows[0]["real_name"].ToString()); } else { context.Response.Write("sucess:false"); } } if (request["Action"] == "get_office") { string real_name = PageValidate.InputText(request["realname"], 255); string page_id = PageValidate.InputText(request["page_id"], 255); string file_name = PageValidate.InputText(request["filename"], 255); if (string.IsNullOrEmpty(real_name) || real_name == "undefined") { DataSet ds = cca.GetList(string.Format("page_id='{0}' and file_name='{1}'", page_id, file_name)); if (ds.Tables[0].Rows.Count > 0) { real_name = ds.Tables[0].Rows[0]["real_name"].ToString(); } else { real_name = null; } } if (!string.IsNullOrEmpty(real_name)) { string filename = context.Server.MapPath(@"../file/contract/" + real_name); string readname = WordToHtml(filename); //StreamReader fread = new StreamReader(readname, System.Text.Encoding.GetEncoding("gb2312")); //string ss = fread.ReadToEnd(); string sExt = readname.Substring(readname.LastIndexOf("\\")).ToLower(); real_name = real_name.Replace(sExt, ""); context.Response.Write(sExt); //fread.Close(); //fread.Dispose(); try { // File.Delete(readname); } catch { } } } }
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); } }