/// <summary> /// 删除付费申请 /// </summary> /// <param name="paymentID"></param> /// <returns></returns> private string DeletePayment(string paymentID) { To_PaymentManager bPayment = new To_PaymentManager(); //To_PaymentDetailManager bPaymentDetail = new To_PaymentDetailManager(); string resultMsg = "删除成功"; To_Payment mPayment = bPayment.GetModel(paymentID); if (!bPayment.Delete(paymentID)) { resultMsg = "删除失败"; } else { // bPaymentDetail.DeleteByPayment(paymentID); string delWhere = " jobflowid=" + mPayment.jobFlowID; AuditJobFlowManager.Delete(delWhere); JobFlowManager.Delete(mPayment.jobFlowID); } return(resultMsg); }
/// <summary> /// 获得数据列表 /// </summary> public List <To_Payment> DataTableToList(DataTable dt) { List <To_Payment> modelList = new List <To_Payment>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { To_Payment model; for (int n = 0; n < rowsCount; n++) { model = new To_Payment(); model.id = dt.Rows[n]["id"].ToString(); if (dt.Rows[n]["payerID"].ToString() != "") { model.payerID = int.Parse(dt.Rows[n]["payerID"].ToString()); } if (dt.Rows[n]["totalAmount"].ToString() != "") { model.totalAmount = decimal.Parse(dt.Rows[n]["totalAmount"].ToString()); } if (dt.Rows[n]["expectedDate"].ToString() != "") { model.expectedDate = DateTime.Parse(dt.Rows[n]["expectedDate"].ToString()); } model.bankName = dt.Rows[n]["bankName"].ToString(); if (dt.Rows[n]["bankID"].ToString() != "") { model.bankID = int.Parse(dt.Rows[n]["bankID"].ToString()); } model.bankAccount = dt.Rows[n]["bankAccount"].ToString(); model.bankAccountName = dt.Rows[n]["bankAccountName"].ToString(); model.bankMark = dt.Rows[n]["bankMark"].ToString(); model.orderNum = dt.Rows[n]["orderNum"].ToString(); model.codeFormat = dt.Rows[n]["codeFormat"].ToString(); model.serialNum = dt.Rows[n]["serialNum"].ToString(); if (dt.Rows[n]["jobFlowID"].ToString() != "") { model.jobFlowID = int.Parse(dt.Rows[n]["jobFlowID"].ToString()); } model.approvalOpinion = dt.Rows[n]["approvalOpinion"].ToString(); if (dt.Rows[n]["requestDate"].ToString() != "") { model.requestDate = DateTime.Parse(dt.Rows[n]["requestDate"].ToString()); } model.makerName = dt.Rows[n]["makerName"].ToString(); if (dt.Rows[n]["makerID"].ToString() != "") { model.makerID = int.Parse(dt.Rows[n]["makerID"].ToString()); } model.payFor = dt.Rows[n]["payFor"].ToString(); model.paymentType = dt.Rows[n]["paymentType"].ToString(); model.payerName = dt.Rows[n]["payerName"].ToString(); model.payerCode = dt.Rows[n]["payerCode"].ToString(); modelList.Add(model); } } return(modelList); }
/// <summary> /// 更新帐号方法 /// </summary> private void UpdatePayment() { string jfid = Request.QueryString["id"].ToString(); string[] jfids = jfid.Split(','); bool result = true; string[] payAccounts = payAccount.SelectedValue.Split(','); //支付帐号信息(0、银行名;1、帐号;2、开户名) string[] getAccounts = getAccount.SelectedValue.Split(','); //收款帐号信息 To_PaymentManager paymentManager = new To_PaymentManager(); To_Payment payment = null; for (int i = 0; i < jfids.Length; i++) { payment = paymentManager.GetModelByjfid(jfids[i]); if (this.payAccount.SelectedIndex != 0) { payment.bankName = payAccounts[0]; payment.bankAccount = payAccounts[1]; payment.bankAccountName = payAccounts[2]; payment.bankID = int.Parse(payAccounts[3]); } else { payment.bankName = payment.bankAccount = payment.bankAccountName = ""; payment.bankID = 0; } if (this.getAccount.SelectedIndex != 0) { payment.getBank = getAccounts[0]; payment.getAccount = getAccounts[1]; payment.getAccountName = getAccounts[2]; } else { payment.getBank = payment.getAccount = payment.getAccountName = ""; } payment.payType = "转账"; /*this.payType.SelectedValue; //支付方式*/ payment.isConfirm = "1"; //确认状态 LoginInfo login = ((LoginInfo)Session["login"]); payment.confirmMan = login.Cname; //确认人 payment.confirmDate = DateTime.Now; //确认日期 result = paymentManager.UpdateAccount(payment); if (!result) { break; } } if (result) { Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "false", "alert('保存成功!');location.href='payConfirmList.aspx'", true); } else { Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "false", "alert('保存失败!');", true); } }
/// <summary> /// 更新付款申请的帐号信息 /// </summary> /// <returns></returns> public bool UpdateAccount(To_Payment Model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update To_Payment set "); strSql.Append(" bankName = @bankName ,"); strSql.Append(" bankAccount = @bankAccount ,"); strSql.Append(" bankAccountName = @bankAccountName ,"); strSql.Append(" getBank = @getBank ,"); strSql.Append(" getAccount = @getAccount ,"); strSql.Append(" getAccountName = @getAccountName ,"); strSql.Append(" payType = @payType ,"); strSql.Append(" isConfirm = @isConfirm , "); strSql.Append(" confirmMan = @confirmMan , "); strSql.Append(" confirmDate = @confirmDate, "); strSql.Append(" bankId = @bankId "); strSql.Append(" where id=@id "); SqlParameter[] sp = { new SqlParameter("@id", SqlDbType.VarChar, 50), new SqlParameter("@bankName", SqlDbType.VarChar, 50), new SqlParameter("@bankAccount", SqlDbType.VarChar, 50), new SqlParameter("@bankAccountName", SqlDbType.VarChar, 50), new SqlParameter("@getBank", SqlDbType.VarChar, 50), new SqlParameter("@getAccount", SqlDbType.VarChar, 50), new SqlParameter("@getAccountName", SqlDbType.VarChar, 50), new SqlParameter("@payType", SqlDbType.VarChar, 50), new SqlParameter("@isConfirm", SqlDbType.VarChar, 50), new SqlParameter("@confirmMan", SqlDbType.VarChar, 50), new SqlParameter("@confirmDate", SqlDbType.DateTime), new SqlParameter("@bankId", SqlDbType.Int, 4) }; sp[0].Value = Model.id; sp[1].Value = Model.bankName; sp[2].Value = Model.bankAccount; sp[3].Value = Model.bankAccountName; sp[4].Value = Model.getBank; sp[5].Value = Model.getAccount; sp[6].Value = Model.getAccountName; sp[7].Value = Model.payType; sp[8].Value = Model.isConfirm; sp[9].Value = Model.confirmMan; sp[10].Value = Model.confirmDate; sp[11].Value = Model.bankID; int result = DBHelper.ExecuteCommand(strSql.ToString(), sp); if (result > 0) { return(true); } else { return(false); } }
private void LoadAccountInfo() { string jfid = Request.QueryString["jfid"]; To_PaymentManager paymentManager = new To_PaymentManager(); To_Payment paymentModel = paymentManager.GetModelByjfid(jfid); if (paymentModel != null) { payType.Value = paymentModel.payType; collectInfo.Value = "开户银行:" + paymentModel.getBank + ", 银行帐号:" + paymentModel.getAccount + ", 开户名称:" + paymentModel.getAccountName; payInfo.Value = "开户银行:" + paymentModel.bankName + ", 银行帐号:" + paymentModel.bankAccount + ", 开户名称:" + paymentModel.bankAccountName; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(To_Payment model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update To_Payment set "); strSql.Append(" payerID = @payerID , "); strSql.Append(" payerName = @payerName , "); strSql.Append(" totalAmount = @totalAmount , "); strSql.Append(" jobFlowID = @jobFlowID , "); strSql.Append(" approvalOpinion = @approvalOpinion , "); strSql.Append(" requestDate = @requestDate , "); strSql.Append(" paymentType = @paymentType "); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.VarChar, 50), new SqlParameter("@payerID", SqlDbType.Int, 4), new SqlParameter("@payerName", SqlDbType.VarChar, 50), new SqlParameter("@totalAmount", SqlDbType.Decimal, 9), new SqlParameter("@jobFlowID", SqlDbType.Int, 4), new SqlParameter("@approvalOpinion", SqlDbType.NVarChar, 500), new SqlParameter("@requestDate", SqlDbType.DateTime), new SqlParameter("@paymentType", SqlDbType.VarChar, 50) }; parameters[0].Value = model.id; parameters[1].Value = model.payerID; parameters[2].Value = model.payerName; parameters[3].Value = model.totalAmount; parameters[4].Value = model.jobFlowID; parameters[5].Value = model.approvalOpinion; parameters[6].Value = model.requestDate; parameters[7].Value = model.paymentType; int rows = DBHelper.ExecuteCommand(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public void Add(To_Payment model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into To_Payment("); strSql.Append("id,payerID,totalAmount,orderNum,codeFormat,serialNum,jobFlowID,approvalOpinion,requestDate,makerName,makerID,payFor,paymentType,payerName,makeTime"); strSql.Append(") values ("); strSql.Append("@id,@payerID,@totalAmount,@orderNum,@codeFormat,@serialNum,@jobFlowID,@approvalOpinion,@requestDate,@makerName,@makerID,@payFor,@paymentType,@payerName,@makeTime"); strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.VarChar, 50), new SqlParameter("@payerID", SqlDbType.Int, 4), new SqlParameter("@totalAmount", SqlDbType.Decimal, 9), new SqlParameter("@orderNum", SqlDbType.VarChar, 10), new SqlParameter("@codeFormat", SqlDbType.VarChar, 40), new SqlParameter("@serialNum", SqlDbType.VarChar, 50), new SqlParameter("@jobFlowID", SqlDbType.Int, 4), new SqlParameter("@approvalOpinion", SqlDbType.NVarChar, 500), new SqlParameter("@requestDate", SqlDbType.DateTime), new SqlParameter("@makerName", SqlDbType.VarChar, 20), new SqlParameter("@makerID", SqlDbType.Int, 4), new SqlParameter("@payFor", SqlDbType.VarChar, 20), new SqlParameter("@paymentType", SqlDbType.VarChar, 50), new SqlParameter("@payerName", SqlDbType.VarChar, 50), new SqlParameter("@makeTime", SqlDbType.DateTime) }; parameters[0].Value = model.id; parameters[1].Value = model.payerID; parameters[2].Value = model.totalAmount; parameters[3].Value = model.orderNum; parameters[4].Value = model.codeFormat; parameters[5].Value = model.serialNum; parameters[6].Value = model.jobFlowID; parameters[7].Value = model.approvalOpinion; parameters[8].Value = model.requestDate; parameters[9].Value = model.makerName; parameters[10].Value = model.makerID; parameters[11].Value = model.payFor; parameters[12].Value = model.paymentType; parameters[13].Value = model.payerName; parameters[14].Value = model.makeTime; DBHelper.ExecuteCommand(strSql.ToString(), parameters); }
/// <summary> /// 添加付费信息 /// </summary> /// <returns>GUID主键</returns> private string SavePayment(string serialNumber, string codeFormat, string orderNum, int workflowID) { To_PaymentManager bPayment = new To_PaymentManager(); To_Payment mPayment = new To_Payment(); #region To_Payment实体 mPayment.approvalOpinion = ""; mPayment.codeFormat = codeFormat; mPayment.orderNum = orderNum; mPayment.serialNum = serialNumber; mPayment.jobFlowID = workflowID; LoginInfo currentUser = Session["login"] as LoginInfo; mPayment.makerID = currentUser.Id; mPayment.makerName = currentUser.Cname; mPayment.payerID = int.Parse(hidPayerID.Value.Trim()); mPayment.payerName = txtPayerName.Text.Trim(); mPayment.paymentType = txtPayType.Text.Trim(); //付款类别 mPayment.requestDate = DateTime.Parse(txtRequestDate.Text.Trim()); mPayment.totalAmount = decimal.Parse(txtSumAmount.Text.Trim()); mPayment.makeTime = DateTime.Now; mPayment.id = Guid.NewGuid().ToString(); #endregion mPayment.payFor = "payAmount"; bPayment.Add(mPayment); //SavePaymentDetail(mPayment.id); return(mPayment.id); }
/// <summary> /// 添加付费信息 /// </summary> /// <returns>GUID主键</returns> private string UpdatePayment(int workflowID) { To_PaymentManager bPayment = new To_PaymentManager(); string paymentID = Request.QueryString["payid"].ToString(); To_Payment mPayment = bPayment.GetModel(paymentID); if (mPayment == null) { return(""); } #region To_Payment实体 mPayment.approvalOpinion = ""; mPayment.jobFlowID = workflowID; mPayment.payerID = int.Parse(hidPayerID.Value.Trim()); mPayment.payerName = txtPayerName.Text.Trim(); mPayment.paymentType = txtPayType.Text.Trim(); //付款类别 mPayment.requestDate = DateTime.Parse(txtRequestDate.Text.Trim()); mPayment.totalAmount = decimal.Parse(txtSumAmount.Text.Trim()); #endregion bPayment.Update(mPayment); To_PaymentDetailManager bPaymentDetail = new To_PaymentDetailManager(); bPaymentDetail.DeleteByPayment(mPayment.id); To_PaymentReturnManager.DeleteByPayment(mPayment.id); SavePaymentDetail(mPayment.id); SavePaymentReturn(mPayment.id); return(mPayment.id); }
/// <summary> /// 更新付款申请的帐号信息 /// </summary> /// <returns></returns> public bool UpdateAccount(To_Payment Model) { return(dal.UpdateAccount(Model)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(To_Payment model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public void Add(To_Payment model) { dal.Add(model); }
/// <summary> /// 通过工作流id得到对象实体 /// </summary> /// <param name="jfid"></param> /// <returns></returns> public To_Payment getModelByjfid(string jfid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * "); strSql.Append(" from To_Payment "); strSql.Append(" where jobFlowID=@jobFlowID "); SqlParameter[] parameters = { new SqlParameter("@jobFlowID", SqlDbType.VarChar, 50) }; parameters[0].Value = jfid; To_Payment model = new To_Payment(); DataTable dt = DBHelper.GetDataSet(strSql.ToString(), parameters); if (dt.Rows.Count > 0) { model.id = dt.Rows[0]["id"].ToString(); if (dt.Rows[0]["payerID"].ToString() != "") { model.payerID = int.Parse(dt.Rows[0]["payerID"].ToString()); } if (dt.Rows[0]["totalAmount"].ToString() != "") { model.totalAmount = decimal.Parse(dt.Rows[0]["totalAmount"].ToString()); } if (dt.Rows[0]["expectedDate"].ToString() != "") { model.expectedDate = DateTime.Parse(dt.Rows[0]["expectedDate"].ToString()); } model.bankName = dt.Rows[0]["bankName"].ToString(); if (dt.Rows[0]["bankID"].ToString() != "") { model.bankID = int.Parse(dt.Rows[0]["bankID"].ToString()); } model.bankAccount = dt.Rows[0]["bankAccount"].ToString(); model.bankAccountName = dt.Rows[0]["bankAccountName"].ToString(); model.bankMark = dt.Rows[0]["bankMark"].ToString(); model.orderNum = dt.Rows[0]["orderNum"].ToString(); model.codeFormat = dt.Rows[0]["codeFormat"].ToString(); model.serialNum = dt.Rows[0]["serialNum"].ToString(); if (dt.Rows[0]["jobFlowID"].ToString() != "") { model.jobFlowID = int.Parse(dt.Rows[0]["jobFlowID"].ToString()); } model.approvalOpinion = dt.Rows[0]["approvalOpinion"].ToString(); if (dt.Rows[0]["requestDate"].ToString() != "") { model.requestDate = DateTime.Parse(dt.Rows[0]["requestDate"].ToString()); } model.makerName = dt.Rows[0]["makerName"].ToString(); if (dt.Rows[0]["makerID"].ToString() != "") { model.makerID = int.Parse(dt.Rows[0]["makerID"].ToString()); } model.payFor = dt.Rows[0]["payFor"].ToString(); model.paymentType = dt.Rows[0]["paymentType"].ToString(); model.payerName = dt.Rows[0]["payerName"].ToString(); model.payerCode = dt.Rows[0]["payerCode"].ToString(); if (dt.Rows[0]["payerType"].ToString() != "") { model.payerType = int.Parse(dt.Rows[0]["payerType"].ToString()); } model.makeTime = DateTime.Parse(dt.Rows[0]["makeTime"].ToString()); if (dt.Rows[0]["regType"].ToString() != "") { model.regtype = int.Parse(dt.Rows[0]["regType"].ToString()); } model.payType = dt.Rows[0]["payType"].ToString(); model.isConfirm = dt.Rows[0]["isConfirm"].ToString(); model.getBank = dt.Rows[0]["getBank"].ToString(); model.getAccount = dt.Rows[0]["getAccount"].ToString(); model.getAccountName = dt.Rows[0]["getAccountName"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 拒绝方法 /// </summary> private void Refuse() { int jobflowid = int.Parse(Request.QueryString["jobflowid"].ToString()); //工作流的id string comparedata = " reviewerid=" + ((EtNet_Models.LoginInfo)Session["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 = " AND jobflowID=" + jobflowid.ToString(); To_PaymentManager bPayment = new To_PaymentManager(); DataTable tbl = bPayment.GetViewPaymentList(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=" + ((EtNet_Models.LoginInfo)Session["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(txtApprovalOpinion.Value); 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 + "的单据已被审批人拒绝!"; SendInfo(strad, jobflowmodel.id); string paymentID = tbl.Rows[0]["id"].ToString(); To_Payment mPayment = bPayment.GetModel(paymentID); //EtNet_Models.Customer cus = EtNet_BLL.CustomerManager.getCustomerById(cusid); mPayment.approvalOpinion = mPayment.approvalOpinion + ((EtNet_Models.LoginInfo)Session["login"]).Cname + "的审核意见:" + Server.UrlDecode(txtApprovalOpinion.Value) + "|"; bPayment.Update(mPayment); 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); } } }
/// <summary> /// 通过审核方法 /// </summary> private void Approve() { int jobflowid = int.Parse(Request.QueryString["jobflowid"].ToString()); //工作流的id string comparedata = " reviewerid=" + ((EtNet_Models.LoginInfo)Session["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 = " and jobflowID=" + jobflowid.ToString(); To_PaymentManager bPayment = new To_PaymentManager(); DataTable tbl = bPayment.GetViewPaymentList(strsql);// 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=" + ((EtNet_Models.LoginInfo)Session["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(txtApprovalOpinion.Value); EtNet_BLL.AuditJobFlowManager.Update(auditmodel); EtNet_Models.JobFlow jobflowmodel = new EtNet_Models.JobFlow(); jobflowmodel = EtNet_BLL.JobFlowManager.GetModel(jobflowid); //依据不同的审核类型进行操作 switch (ruletxt) { case "单审": if (mainreviewer != "T") { auditmodel = new EtNet_Models.AuditJobFlow(); //设置下一个审核人的数据记录 string nextauditstr = " jobflowid=" + jobflowid.ToString() + " AND numbers=" + (num + 1).ToString(); DataTable nextaudittbl = EtNet_BLL.AuditJobFlowManager.GetList(nextauditstr); auditmodel.auditoperat = nextaudittbl.Rows[0]["auditoperat"].ToString(); auditmodel.audittime = DateTime.Parse(nextaudittbl.Rows[0]["audittime"].ToString()); auditmodel.id = int.Parse(nextaudittbl.Rows[0]["id"].ToString()); auditmodel.jobflowid = int.Parse(nextaudittbl.Rows[0]["jobflowid"].ToString()); auditmodel.mainreviewer = nextaudittbl.Rows[0]["mainreviewer"].ToString(); auditmodel.nowreviewer = "T"; //设置其为审核人员 auditmodel.numbers = int.Parse(nextaudittbl.Rows[0]["numbers"].ToString()); auditmodel.operatstatus = nextaudittbl.Rows[0]["operatstatus"].ToString(); auditmodel.reviewerid = int.Parse(nextaudittbl.Rows[0]["reviewerid"].ToString()); auditmodel.opiniontxt = nextaudittbl.Rows[0]["opiniontxt"].ToString(); EtNet_BLL.AuditJobFlowManager.Update(auditmodel); jobflowmodel.auditstatus = "02"; //工作流的审核状态为“进行中” EtNet_BLL.JobFlowManager.Update(jobflowmodel); } else { jobflowmodel.endtime = DateTime.Now; jobflowmodel.auditstatus = "04"; //工作流的审核状态为“已通过” EtNet_BLL.JobFlowManager.Update(jobflowmodel); updateOrderPayDetail(jobflowid); updateOrderRetDetail(jobflowid); } break; case "选审": jobflowmodel.endtime = DateTime.Now; jobflowmodel.auditstatus = "04"; //工作流的审核状态为“已通过” EtNet_BLL.JobFlowManager.Update(jobflowmodel); EtNet_BLL.AuditJobFlowManager.UpdateOther(" reviewerid != " + ((EtNet_Models.LoginInfo)Session["login"]).Id + " and jobflowid=" + jobflowid.ToString()); updateOrderPayDetail(jobflowid); updateOrderRetDetail(jobflowid); break; case "会审": bool pass = true; string straudit = " jobflowid=" + jobflowid.ToString(); DataTable auditjobtbl = EtNet_BLL.AuditJobFlowManager.GetList(straudit); for (int i = 0; i < auditjobtbl.Rows.Count; i++) { if (auditjobtbl.Rows[i]["auditoperat"].ToString() != "通过") { pass = false; //说明还有其他审核人员未开始审核 break; } } if (pass) { jobflowmodel.endtime = DateTime.Now; jobflowmodel.auditstatus = "04"; //工作流的状审核状态为“已通过” EtNet_BLL.JobFlowManager.Update(jobflowmodel); updateOrderPayDetail(jobflowid); updateOrderRetDetail(jobflowid); } else { jobflowmodel.auditstatus = "02"; //工作流的状审核状态为“进行中” EtNet_BLL.JobFlowManager.Update(jobflowmodel); } break; } string strad = "编号为" + jobflowmodel.cname + "的单据已通过审批!"; SendInfo(strad, jobflowmodel.id); SendNextAudit(jobflowmodel.id); //修改客户的审核意见与启用状态 string paymentID = tbl.Rows[0]["id"].ToString(); To_Payment mPayment = bPayment.GetModel(paymentID); //EtNet_Models.Customer cus = EtNet_BLL.CustomerManager.getCustomerById(cusid); mPayment.approvalOpinion = mPayment.approvalOpinion + ((EtNet_Models.LoginInfo)Session["login"]).Cname + "的审核意见:" + Server.UrlDecode(txtApprovalOpinion.Value) + "|"; bPayment.Update(mPayment); 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); } } }