/// <summary> /// 获取客户银行列表 /// </summary> /// <param name="customerID"></param> /// <returns></returns> private string GetCustomerBankList(int customerID) { DataTable dtBankList = CusBankManager.getList(customerID); StringBuilder htmlBuilder = new StringBuilder(); EtNet_Models.Customer customer = CustomerManager.getCustomerById(customerID); if (customer != null && customer.Bank.Trim() != string.Empty) { htmlBuilder.AppendFormat("<option value=\"{0}\">", customer.CardId + "$" + customer.CardName + "$" + customer.Remark); //htmlBuilder.Append("<option value=\"0\">"); htmlBuilder.Append(customer.Bank); htmlBuilder.Append("</option>"); } if (dtBankList.Rows.Count > 0) { int rowCount = dtBankList.Rows.Count; for (int i = 0; i < rowCount; i++) { DataRow currentRow = dtBankList.Rows[i]; htmlBuilder.AppendFormat("<option value=\"{0}\">", currentRow["id"]); htmlBuilder.Append(currentRow["bank"]); htmlBuilder.Append("</option>"); } } return(htmlBuilder.ToString()); }
/// <summary> /// 保存 /// </summary> private void SaveCus() { if (this.ddlcus.SelectedIndex != 0) { int id = int.Parse(this.ddlcus.SelectedValue); EtNet_Models.Customer cus = EtNet_BLL.CustomerManager.getCustomerById(id); if (cus == null) { this.imgbtnsave.Enabled = false; } else { cus.Viewidlist = this.hidlist.Value; cus.Viewidtxt = this.hidtxtlist.Value; cus.Authidlist = this.hidulist.Value; cus.Authidtxt = this.hidtxtulist.Value; if (EtNet_BLL.CustomerManager.updateCustomer(cus) >= 1) { LoadCusData(); Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "save", "<script>alert('保存成功!')</script>", false); } } } else { Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "save", "<script>alert('未选中任何客户!')</script>", false); } }
/// <summary> /// 加载客户 /// </summary> private void LoadCusData() { if (this.ddlcus.SelectedIndex != 0) { int id = int.Parse(this.ddlcus.SelectedValue); EtNet_Models.Customer cus = EtNet_BLL.CustomerManager.getCustomerById(id); if (cus == null) { this.imgbtnsave.Enabled = false; } else { LoadViewCus(cus.Viewidlist, cus.Viewidtxt); LoadAuthCus(cus.Authidlist, cus.Authidtxt); } } else { this.hidlist.Value = ""; this.hidtxtlist.Value = ""; this.hidulist.Value = ""; this.hidtxtulist.Value = ""; this.listleft.Items.Clear(); this.listright.Items.Clear(); this.listuleft.Items.Clear(); this.listuright.Items.Clear(); Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "save", "<script>alert('未选中任何客户!')</script>", false); } }
private void ModifyCus(int cid, string idlist) { int id = int.Parse(Request.QueryString["id"]); EtNet_Models.Customer cus = null; string viewlist = ""; string viewtxt = ""; string login = ""; string logincame = ""; EtNet_Models.LoginInfo model = EtNet_BLL.LoginInfoManager.getLoginInfoById(id); string list = "," + idlist + ","; string cusid = "," + cid + ","; if (list.IndexOf(cusid) != -1) { cus = EtNet_BLL.CustomerManager.getCustomerById(cid); viewlist = "," + cus.Viewidlist + ","; login = "******" + id.ToString() + ","; if (viewlist.IndexOf(login) == -1) { if (cus.Viewidlist != "") { cus.Viewidlist += "," + model.Id.ToString(); cus.Viewidtxt += "," + model.Cname; } else { cus.Viewidlist = model.Id.ToString(); cus.Viewidtxt = model.Cname; } EtNet_BLL.CustomerManager.updateCustomer(cus); } } else { cus = EtNet_BLL.CustomerManager.getCustomerById(cid); viewlist = "," + cus.Viewidlist + ","; viewtxt = "," + cus.Viewidtxt + ","; login = "******" + id.ToString() + ","; logincame = "," + model.Cname + ","; if (viewlist.IndexOf(login) != -1) { cus.Viewidlist = viewlist.Replace(login, "").Trim(','); cus.Viewidtxt = viewtxt.Replace(logincame, "").Trim(','); EtNet_BLL.CustomerManager.updateCustomer(cus); } } }
/// <summary> /// 加载客户 /// </summary> private void LoadCusData() { int id = int.Parse(Request.QueryString["id"]); EtNet_Models.Customer cus = EtNet_BLL.CustomerManager.getCustomerById(id); if (cus == null) { this.imgbtnsave.Enabled = false; } else { LoadViewCus(cus.Viewidlist, cus.Viewidtxt); LoadAuthCus(cus.Authidlist, cus.Authidtxt); } }
//保存 protected void imgbtnsave_Click(object sender, ImageClickEventArgs e) { int id = int.Parse(Request.QueryString["id"]); EtNet_Models.Customer cus = EtNet_BLL.CustomerManager.getCustomerById(id); if (cus == null) { this.imgbtnsave.Enabled = false; } else { cus.Viewidlist = this.hidlist.Value; cus.Viewidtxt = this.hidtxtlist.Value; cus.Authidlist = this.hidulist.Value; cus.Authidtxt = this.hidtxtulist.Value; if (EtNet_BLL.CustomerManager.updateCustomer(cus) >= 1) { LoadCusData(); Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "save", "<script>closecus()</script>", false); } } }
/// <summary> /// 绑定客户银行列表 /// </summary> private void FillCustomerBank(DataTable dtBankList, int customerID) { EtNet_Models.Customer customer = CustomerManager.getCustomerById(customerID); if (customer != null && customer.Bank.Trim() != string.Empty) { DataRow newRow = dtBankList.NewRow(); newRow["bankId"] = 0; newRow["bankName"] = customer.Bank;// string.Format("{0}(主银行)", customer.Bank); newRow["bankAccount"] = customer.CardId; newRow["bankUser"] = customer.CardName; newRow["bankMark"] = customer.Remark; dtBankList.Rows.Add(newRow); } DataTable dtCustomerBankList = CusBankManager.getList(customerID); if (dtCustomerBankList.Rows.Count > 0) { int rowCount = dtCustomerBankList.Rows.Count; for (int i = 0; i < rowCount; i++) { DataRow currentRow = dtCustomerBankList.Rows[i]; DataRow newRow = dtBankList.NewRow(); newRow["bankId"] = currentRow["id"]; newRow["bankName"] = currentRow["bank"]; newRow["bankAccount"] = currentRow["cardId"]; newRow["bankUser"] = currentRow["cardName"]; newRow["bankMark"] = currentRow["remark"]; dtBankList.Rows.Add(newRow); } } }
/// <summary> /// 拒绝方法 /// </summary> private void Refuse() { int jobflowid = int.Parse(Request.QueryString["jobflowid"].ToString()); //工作流的id EtNet_Models.LoginInfo login = (EtNet_Models.LoginInfo)Session["login"]; string comparedata = " reviewerid=" + login.Id + " AND jobflowid=" + jobflowid.ToString(); if (EtNet_BLL.AuditJobFlowManager.GetList(comparedata).Rows.Count == 0) { //该工作流被收回或删除导致审批提交失败 Response.Redirect("../Job/AuditError.aspx?error=0"); } else if (EtNet_BLL.JobFlowManager.GetModel(jobflowid).auditstatus == "03" || EtNet_BLL.JobFlowManager.GetModel(jobflowid).auditstatus == "04") { //该工作流是审核方式是选审或会签所以在提交审核时,工作流已由他人审核通过 Response.Redirect("../Job/AuditError.aspx?error=1"); } else { string ruletxt = ""; //审核的分类 string strsql = " jobflowcode=" + jobflowid.ToString(); DataTable tbl = EtNet_BLL.ViewBLL.ViewCustomerManager.getList("", strsql); if (tbl.Rows.Count == 1) { int ruleid = int.Parse(tbl.Rows[0]["ruleid"].ToString()); EtNet_Models.ApprovalRule rule = EtNet_BLL.ApprovalRuleManager.GetModel(ruleid); ruletxt = rule.sort; //修改当前审核人的记录 EtNet_Models.AuditJobFlow auditmodel = null; string auditstr = " jobflowid=" + jobflowid.ToString() + " AND reviewerid=" + login.Id; DataTable audittbl = EtNet_BLL.AuditJobFlowManager.GetList(auditstr); // 查找到当前审核人员的记录 int num = int.Parse(audittbl.Rows[0]["numbers"].ToString()); //当前审核人员编号 string mainreviewer = audittbl.Rows[0]["mainreviewer"].ToString(); //当前审核人是不是最终审核人 auditmodel = new EtNet_Models.AuditJobFlow(); auditmodel.auditoperat = "拒绝"; auditmodel.audittime = DateTime.Now; auditmodel.id = int.Parse(audittbl.Rows[0]["id"].ToString()); auditmodel.jobflowid = int.Parse(audittbl.Rows[0]["jobflowid"].ToString()); auditmodel.mainreviewer = audittbl.Rows[0]["mainreviewer"].ToString(); auditmodel.nowreviewer = "P"; //能查找到工作流记录,但不能进行审核操作 auditmodel.numbers = int.Parse(audittbl.Rows[0]["numbers"].ToString()); auditmodel.operatstatus = "已审批"; auditmodel.reviewerid = int.Parse(audittbl.Rows[0]["reviewerid"].ToString()); auditmodel.opiniontxt = Server.UrlDecode(this.iptcomment.Value.Trim()); EtNet_BLL.AuditJobFlowManager.Update(auditmodel); EtNet_Models.JobFlow jobflowmodel = new EtNet_Models.JobFlow(); jobflowmodel = EtNet_BLL.JobFlowManager.GetModel(jobflowid); //依据不同的审核类型进行操作 switch (ruletxt) { case "单审": case "会审": jobflowmodel.endtime = DateTime.Now; jobflowmodel.auditstatus = "03"; //工作流的审核状态为“被拒绝” EtNet_BLL.JobFlowManager.Update(jobflowmodel); break; case "选审": string st = " jobflowid=" + jobflowid.ToString(); DataTable tbla = EtNet_BLL.AuditJobFlowManager.GetList(st); bool refuse = true; for (int j = 0; j < tbla.Rows.Count; j++) { if (tbla.Rows[j]["auditoperat"].ToString() != "拒绝") { refuse = false; //还有其他审核人员未审 break; } } if (refuse) { jobflowmodel.endtime = DateTime.Now; jobflowmodel.auditstatus = "03"; // 工作流的审核状态为被拒绝 EtNet_BLL.JobFlowManager.Update(jobflowmodel); } else { jobflowmodel.auditstatus = "02"; // 工作流的审核状态为进行中 EtNet_BLL.JobFlowManager.Update(jobflowmodel); } break; } string strad = "编号为" + jobflowmodel.cname + "的客户,【" + login.Cname + "】拒绝审批!"; SendInfo(strad, jobflowmodel.id); //修改客户的审核意见 int cusid = int.Parse(tbl.Rows[0]["id"].ToString()); EtNet_Models.Customer cus = EtNet_BLL.CustomerManager.getCustomerById(cusid); cus.Txt = cus.Txt + login.Cname + "的审批意见:" + Server.UrlDecode(this.iptcomment.Value.Trim()) + "|"; EtNet_BLL.CustomerManager.updateCustomer(cus); if (HttpContext.Current.Request.QueryString["pageindex"] != null) { int page = int.Parse(HttpContext.Current.Request.QueryString["pageindex"]); Response.Redirect("../Job/AuditJobFlow.aspx?page=" + page + ""); } else { Response.Redirect("../Job/AuditJobFlow.aspx"); } } else { Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "audit", "<script> alert('审批出错!')</script>", false); } } }
private void loadCus() { string jfid = Request.QueryString["jobflowid"].ToString(); string strsql = " jobflowid=" + jfid; DataTable tbl = EtNet_BLL.CustomerManager.GetList(strsql); if (tbl.Rows.Count == 0) { Page.ClientScript.RegisterStartupScript(this.GetType(), "audit", "alert('数据出错,客户可能已删除!');location.href='../Job/AuditJobFlow.aspx'", true); return; } int id = int.Parse(tbl.Rows[0]["id"].ToString()); EtNet_Models.Customer customer = EtNet_BLL.CustomerManager.getCustomerById(Convert.ToInt32(id)); //基本信息 this.lblcuscode.Text = customer.CusCode.ToString() + " "; this.lblshortname.Text = customer.CusshortName.ToString() + " "; this.lbladdress.Text = customer.Province.ToString() + " " + customer.City.ToString() + " "; this.lblcname.Text = customer.CusCName.ToString() + " "; this.lblcompanyurl.Text = customer.CompanyURL.ToString() + " "; if (customer.CusType == 0) { this.lblcustype.Text = "暂未选择类别"; } else { this.lblcustype.Text = EtNet_BLL.CusTypeManager.getCusTypeById(customer.CusType).TypeName.ToString(); } if (customer.Used == 0) { this.lblused.Text = "暂未启用"; } else { this.lblused.Text = "已启用"; } if (customer.CusPro == 0) { this.lblcuspro.Text = "潜在客户"; } else { this.lblcuspro.Text = "正式客户"; } this.lblcaddress.Text = customer.CusCAddress.ToString() + " "; //主要联系人 this.lbllinkname.Text = customer.LinkName.ToString() + " "; this.lbllinkpost.Text = customer.Post.ToString() + " "; this.lbllinkfax.Text = customer.Fax.ToString() + " "; this.lbllinkemail.Text = customer.Email.ToString() + " "; this.lbllinkmobile.Text = customer.Mobile.ToString() + " "; this.lbllinktel.Text = customer.Telephone.ToString() + " "; this.lbllinkskype.Text = customer.Skype.ToString() + " "; this.lbllinkmsn.Text = customer.Msn.ToString() + " "; //主要银行信息 this.lblbank.Text = customer.Bank.ToString() + " "; this.lblbankcard.Text = customer.CardId.ToString() + " "; this.lblbankman.Text = customer.CardName.ToString() + " "; this.lblremark.Text = customer.Remark.ToString() + " "; this.lblMadeFrom.Text = EtNet_BLL.LoginInfoManager.getLoginInfoById(customer.Madefrom).Cname; this.lblMadeTime.Text = customer.MadeTime.ToString("yyyy-MM-dd"); loadOtherLink(id); loadOtherBank(id); }
protected void rptauditjobflow_ItemCommand(object source, RepeaterCommandEventArgs e) { switch (e.CommandName) { case "audit": string[] str = e.CommandArgument.ToString().Split('-'); string rs = ReviewerStatus(str[0], ((EtNet_Models.LoginInfo)Session["login"]).Id); if (rs == "") { //工作流已删除或审核人员已更改 LoadRptjobflowData(); Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "faudit", "<script>alert('不能进入审批界面,原因可能是该申请已修改或删除!')</script>", false); return; } else if (rs == "F") { LoadRptjobflowData(); Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "faudit", "<script>alert('不能进入审批界面,原因可能是审批受限制!')</script>", false); } else if (rs == "T") { string strstatus = JobFlowAuditStatus(int.Parse(str[0])); if (strstatus == "03" || strstatus == "04") { Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "auditR", "<script>alert('该工作流已由他人审批,无需再审!')</script>", false); } else { if (str[1] == "01") { if (HttpContext.Current.Request.QueryString["page"] != null) { int page = int.Parse(HttpContext.Current.Request.QueryString["page"]); Response.Redirect("ReimbursedForm/AuditReimbursedForm.aspx?pageindex=" + page + "&jobflowid=" + str[0]); } else { Response.Redirect("ReimbursedForm/AuditReimbursedForm.aspx?jobflowid=" + str[0]); } } else if (str[1] == "02") { if (HttpContext.Current.Request.QueryString["page"] != null) { int page = int.Parse(HttpContext.Current.Request.QueryString["page"]); Response.Redirect("../Order/AuditOrder.aspx?pageindex=" + page + "&jobflowid=" + str[0]); } else { Response.Redirect("../Order/AuditOrder.aspx?jobflowid=" + str[0]); } } else if (str[1] == "03") { if (HttpContext.Current.Request.QueryString["page"] != null) { int page = int.Parse(HttpContext.Current.Request.QueryString["page"]); Response.Redirect("../CusInfo/AuditCus.aspx?pageindex=" + page + "&jobflowid=" + str[0]); } else { Response.Redirect("../CusInfo/AuditCus.aspx?jobflowid=" + str[0]); } } else if (str[1] == "04") { if (HttpContext.Current.Request.QueryString["page"] != null) { int page = int.Parse(HttpContext.Current.Request.QueryString["page"]); Response.Redirect("../Announcement/AnnouncementAuditFirm.aspx?pageindex=" + page + "&jobflowid=" + str[0]); } else { Response.Redirect("../Announcement/AnnouncementAuditFirm.aspx?jobflowid=" + str[0]); } } else if (str[1] == "05") { if (HttpContext.Current.Request.QueryString["page"] != null) { int page = int.Parse(HttpContext.Current.Request.QueryString["page"]); Response.Redirect("../Financial/AuditPayment.aspx?pageindex=" + page + "&jobflowid=" + str[0]); } else { Response.Redirect("../Financial/AuditPayment.aspx?jobflowid=" + str[0]); } } else { } } } else if (rs == "P") { Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "auditP", "<script>alert('不能重复审批!')</script>", false); } else { } break; case "search": string[] str2 = e.CommandArgument.ToString().Split('-'); int jfid2 = int.Parse(str2[0]); if (str2[1] == "01") //报销审核的查看 { SearchReimbursement(jfid2); } else if (str2[1] == "02") //定审核的查看 { SearchOrder(jfid2); } else if (str2[1] == "03") //客户审批查看 { SearchCus(jfid2); } else if (str2[1] == "04") //公告审核查看 { SearchAnnoun(jfid2); } else if (str2[1] == "05") //付款申请单查看 { SearchPayment(jfid2); } break; case "refresh": string[] str3 = e.CommandArgument.ToString().Split('-'); int jfid3 = int.Parse(str3[0]); //工作流id EtNet_Models.JobFlow model = EtNet_BLL.JobFlowManager.GetModel(jfid3); //得到工作流实例 string strfresh = " jobflowid = " + jfid3; EtNet_BLL.AuditJobFlowManager.Delete(strfresh); //删除审核数据,将审核状态改为初始状态 model.savestatus = "草稿"; model.auditstatus = "01"; //审核状态改为未开始状态 model.txt = ""; //审核意见置空 if (model.sort == "01") //报销审核 { string id = EtNet_BLL.AusRottenInfoManager.GetList(strfresh).Rows[0]["id"].ToString(); //根据工作流id得到报销单的id值 EtNet_Models.AusRottenInfo rotten = EtNet_BLL.AusRottenInfoManager.GetModel(int.Parse(id)); if (rotten != null) { rotten.txt = ""; //清空审批人员的审批意见 EtNet_BLL.AusRottenInfoManager.Update(rotten); } } else if (model.sort == "02") //订单审核 { } else if (model.sort == "03") //客户审核 { string sqlcus = " jobflowid = " + jfid3; DataTable tblcus = EtNet_BLL.CustomerManager.GetList(1, sqlcus, "id"); EtNet_Models.Customer cus = EtNet_BLL.CustomerManager.getCustomerById(int.Parse(tblcus.Rows[0]["id"].ToString())); if (cus != null) { cus.Txt = ""; EtNet_BLL.CustomerManager.updateCustomer(cus); } } else if (model.sort == "04") //公告审批 { string sqlano = " jobflowid = " + jfid3; DataTable tblano = EtNet_BLL.AnnouncementInfoManager.GetList(1, sqlano, "id"); EtNet_Models.AnnouncementInfo ano = EtNet_BLL.AnnouncementInfoManager.GetModel(int.Parse(tblano.Rows[0]["id"].ToString())); if (ano != null) { ano.txt = ""; EtNet_BLL.AnnouncementInfoManager.Update(ano); } } else if (model.sort == "05") //付款审核 { } if (EtNet_BLL.JobFlowManager.Update(model)) { Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "success", "<script>alert('撤销成功')</script>", false); } break; } }