/// <summary>
/// 加载付款信息
/// </summary>
/// <param name="paymentID"></param>
private void LoadPaymentData(string paymentID)
{
To_PaymentManager bPayment = new To_PaymentManager();
DataTable dtPayment = bPayment.GetViewPaymentList(string.Format("and id='{0}'", paymentID));
if (dtPayment.Rows.Count > 0)
{
DataRow row = dtPayment.Rows[0];
lblSerialNumber.Text = row["serialNum"].ToString(); //申请单号
lblRequestDate.Text = DateTime.Parse(row["requestDate"].ToString()).ToString("yyyy-MM-dd"); //申请日期
lblMaker.Text = row["makerName"].ToString(); //制单员
lblpayType.Text = row["payType"].ToString(); //支付方式
lblPayerName.Text = row["payerName"].ToString(); //收款单位名称
lblPayFor.Text = row["paymentType"].ToString(); //付款类别
lblSumAmount.Text = decimal.Parse(row["totalAmount"].ToString()).ToString("N2"); //支付金额合计
lblPayBank.Text = row["bankName"].ToString(); //付款银行
lblPayAccount.Text = row["bankAccount"].ToString(); //付款帐号
lblPayAccountName.Text = row["bankAccountName"].ToString(); //付款账户人
lblBank.Text = row["getBank"].ToString(); //收款银行
lblBankAccount.Text = row["getAccount"].ToString(); //收款帐号
lblBankAccountName.Text = row["getAccountName"].ToString(); //收款账户人
sumBox.InnerText = lblSumAmount.Text; //金额合计
LoadPaymentDetail(paymentID);
LoadReturnDetail(paymentID);
}
else
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "load", "alert('数据不存在或没有权限查看');location.href='PaymentList.aspx';", true);
}
}
/// <summary>
/// 加载信息
/// </summary>
/// <param name="paymentID"></param>
private void LoadPaymentData(string paymentID)
{
To_PaymentManager bPayment = new To_PaymentManager();
DataTable dtPayment = bPayment.GetViewPaymentList(string.Format("and id='{0}'", paymentID));
if (dtPayment.Rows.Count > 0)
{
DataRow row = dtPayment.Rows[0];
lblMaker.Text = row["makerName"].ToString();
lblPayerName.Text = row["payerName"].ToString();
lblRequestDate.Text = DateTime.Parse(row["requestDate"].ToString()).ToShortDateString();
lblSerialNumber.Text = row["serialNum"].ToString();
lblSumAmount.Text = row["totalAmount"].ToString();
lblPaymentType.Text = row["paymentType"].ToString(); //付款类别
LoadPaymentDetail(paymentID);
LoadPaymentReturn(paymentID);
LoadAuditImg(int.Parse(row["ruleid"].ToString()));
LoadNowAudit(row["jobFlowID"].ToString());
}
else
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "load", "alert('数据不存在或没有权限查看');location.href='PaymentList.aspx';", true);
}
}
/// <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>
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>
/// <param name="cuscode">输入的客户代码</param>
/// <param name="cname">客户代码全称</param>
/// <param name="attachment">>客户代码不包含流水号</param>
/// <param name="txt">流水号</param>
private bool StrNumbers(string strcuscode, out string serialNum, out string codeformat, out string ordernum)
{
bool result = true;
serialNum = ""; //客户代码全称
codeformat = ""; //名称，不包含流水号
ordernum = ""; //流水号
DataTable tbl = GetModuleCoding(); //自动编码
string txtformat = tbl.Rows[0]["txtformat"].ToString(); //名称的格式
string usecode = tbl.Rows[0]["usecode"].ToString(); //流水号
int len = int.Parse(tbl.Rows[0]["orderlen"].ToString()); //流水号长度
DataTable custbl = null;
string strsql = ""; //查询字符窜
if (usecode == "0")
{
if (strcuscode.Trim() != "")
{
serialNum = strcuscode; //客户代码全称
}
else
{
result = false;
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "test", "<script>alert('保存失败,业务编号不能为空!')</script>");
}
}
else
{
int num = 1; //默认流水号
codeformat = Numbers(txtformat); //名称
strsql = " codeFormat= '" + codeformat + "' AND LEN(orderNum) =" + len.ToString();
To_PaymentManager bPayment = new To_PaymentManager();
custbl = bPayment.GetList(1, strsql, " makeTime desc ");
if (custbl.Rows.Count >= 1)
{
if (custbl.Rows[0]["orderNum"].ToString() != "")
{
num = int.Parse(custbl.Rows[0]["orderNum"].ToString()) + 1; //流水号
if (num.ToString().Length > len)
{
result = false;
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "test", "<script>alert('保存失败,业务编号长度不够!')</script>");
}
}
}
ordernum = num.ToString().PadLeft(len, '0'); //流水号
serialNum = codeformat + ordernum; //客户代码全称
}
return(result);
}
/// <summary>
/// 加载付款信息
/// </summary>
private void LoadPayInfo()
{
string id = Request.QueryString["id"];
id = "(" + id + ")";
string sql = "jobFlowID in " + id;
To_PaymentManager paymanager = new To_PaymentManager();
DataTable dt = paymanager.GetList(sql);
payRepeater.DataSource = dt;
payRepeater.DataBind();
}
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>
/// <param name="payer">付款单位ID</param>
/// <param name="payerType">付款单位类别，0：客户；1：公司</param>
/// <param name="payFor">付款单位名称</param>
private void LoadPolicyList(string payer, string payerType, string payFor)
{
To_PaymentManager b_payment = new To_PaymentManager();
StringBuilder whereBuilder = new StringBuilder();
string payerField = payerType == "0" ? "customer" : "company";
whereBuilder.AppendFormat("AND {0}={1} AND ( payerType = {2} or payerType is null or payFor is null ) ", payerField, payer, payerType);
//if (withInvoice == "1")
//{
// whereBuilder.Append("AND invoiceID IS NOT NULL ");
//}
RpPolicyList.DataSource = b_payment.GetPaymentInvoice(whereBuilder.ToString(), payFor);
RpPolicyList.DataBind();
}
/// <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);
}
private void LoadPaymentData(string paymentID)
{
To_PaymentManager bPayment = new To_PaymentManager();
DataTable dtPayment = bPayment.GetViewPaymentList(string.Format("and id='{0}'", paymentID));
if (dtPayment.Rows.Count > 0)
{
DataRow row = dtPayment.Rows[0];
lblBank.Text = row["bankName"].ToString();
lblBankAccount.Text = row["bankAccount"].ToString();
lblBankAccountName.Text = row["bankAccountName"].ToString();
lblExpectedDate.Text = DateTime.Parse(row["expectedDate"].ToString()).ToShortDateString();
lblMaker.Text = row["makerName"].ToString();
lblPayerCode.Text = row["payerCode"].ToString();
lblPayerName.Text = row["payerName"].ToString();
lblPayFor.Text = GetPayForName(row["payFor"]);
//lblPaymentType.Text = row["paymentType"].ToString() == "0" ? "无票付款" : "邮票付款";
lblRegType.Text = row["regType"].ToString() == "0" ? "转账" : "现金";
lblRequestDate.Text = DateTime.Parse(row["requestDate"].ToString()).ToShortDateString();
lblSerialNumber.Text = row["serialNum"].ToString();
lblSumAmount.Text = row["totalAmount"].ToString();
lblSum.Text = row["totalAmount"].ToString();
lblRMB.Text = MoneyToChinese(row["totalAmount"].ToString());
//sumBox.InnerText = lblSumAmount.Text;
ltrBankMark.Text = row["bankMark"].ToString();
hidPaymentType.Value = row["paymentType"].ToString();
LoadPaymentDetail(paymentID, row["payFor"].ToString());
if (row["jobFlowID"] != DBNull.Value)
{
ltrOptinion.Text = ShowOpiniontxt(Convert.ToInt32(row["jobFlowID"]));
}
}
else
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "load", "alert('数据不存在或没有权限查看');location.href='PaymentList.aspx';", true);
}
}
/// <summary>
/// 初始化页面信息
/// </summary>
private void LoadPaymentData(string paymentID)
{
To_PaymentManager bPayment = new To_PaymentManager();
DataTable dtPayment = bPayment.GetViewPaymentList(string.Format("and id='{0}'", paymentID));
if (dtPayment.Rows.Count > 0)
{
DataRow row = dtPayment.Rows[0];
if (dtPayment.Rows[0]["savestatus"].ToString().Trim() == "已提交")
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "load", "<script>alert('已提交的申请不能修改');window.location='PaymentList.aspx'</script>");
return;
}
txtMaker.Text = row["makerName"].ToString(); //制单员
txtPayerName.Text = row["payerName"].ToString(); //收款单位名称
txtRequestDate.Text = DateTime.Parse(row["requestDate"].ToString()).ToString("yyyy-MM-dd"); //申请日期
txtSerialNumber.Text = row["serialNum"].ToString(); //申请单号
txtSumAmount.Text = row["totalAmount"].ToString(); //支付金额合计
hidPayerID.Value = row["payerID"].ToString().Trim(); //收款单位id
txtPayType.Text = row["paymentType"].ToString(); //付款类别
LoadAuditImg(int.Parse(row["ruleid"].ToString()));
ddlApproval.SelectedValue = row["ruleid"].ToString();
LoadPamentDetial(paymentID);
LoadPaymentReturn(paymentID);
}
else
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "load", "alert('数据不存在或没有权限查看');location.href='PaymentList.aspx';", true);
}
}
/// <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>
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);
}
}
}
/// <summary>
/// 保存数据
/// </summary>
/// <param name="nodes"></param>
/// <returns></returns>
protected void btnSave_Click(object sender, ImageClickEventArgs e)
{
RegPaymentManager bRegP = new RegPaymentManager();
RegPaymentInvoiceManager regPaymentInvoiceManager = new RegPaymentInvoiceManager();
To_PaymentManager to_PaymentManager = new To_PaymentManager();
//更新财务支付
to_PaymentManager.UpdateReg(Request.QueryString["payid"], chkIsPay.Checked ? "1" : "0");
//财务登记页面数据赋值
LoginInfo currentUser = Session["login"] as LoginInfo;
#region 发票信息的更新。目前不需要。
////删除数据
//int num = regPaymentInvoiceManager.GetCount(Request.QueryString["payid"]);
//if (num != 0)
//{
// regPaymentInvoiceManager.DeleteByRegID(Request.QueryString["payid"]);
//}
////添加数据
//string jsonString = hidInvoice.Value;
//List<InvoiceData> invoiceList = ReadJson(jsonString);
//RegPaymentInvoice regPaymentInvoice = new RegPaymentInvoice();
//for (int i = 0, len = invoiceList.Count(); i < len; i++)
//{
// InvoiceData invoiceData = invoiceList[i];
// if (invoiceData.Num != "" || invoiceData.Remark != "")
// {
// regPaymentInvoice.id = Request.QueryString["payid"];
// regPaymentInvoice.invoiceNum = invoiceData.Num;
// regPaymentInvoice.remark = invoiceData.Remark;
// regPaymentInvoiceManager.Add(regPaymentInvoice);
// }
//}
#endregion
if (!string.IsNullOrEmpty(Request.QueryString["payid"]))
{
string paymentID = Request.QueryString["payid"].ToString().Trim();
EtNet_Models.RegPayment regpay = bRegP.GetModel(paymentID);
bool isAdd = true;
if (regpay != null)
{
isAdd = false;
}
else
{
regpay = new EtNet_Models.RegPayment();
regpay.id = Guid.NewGuid().ToString();
}
regpay.hasInvoice = int.Parse(ddlHasInvoiceNum.SelectedValue.Trim());
regpay.hasInvoiceDate = txtHasInvoceDate.Text.Trim() != "" ? DateTime.Parse(txtHasInvoceDate.Text.Trim()) : DateTime.Parse("1900-01-01");
regpay.makerID = LoginInfoManager.getLoginIDByname(lblMaker.Text.Trim()); //制单人员的关联id
regpay.makerName = lblMaker.Text; //该付款申请单的制单人员
regpay.makeTime = DateTime.Parse(lblRequestDate.Text.Trim()); //制单日期
regpay.payerID = currentUser.Id; //支付人员管理id
regpay.payerName = currentUser.Cname; //支付人员
regpay.paymentDate = DateTime.Parse(txtPaymentDate.Text.Trim()); //支付日期
regpay.payRemark = txtpz.Value; //支付凭证
regpay.paymentID = paymentID;
regpay.payStatus = chkIsPay.Checked ? 1 : 0;
if (isAdd)
{
bRegP.Add(regpay);
}
else
{
bRegP.Update(regpay);
}
}
ClientScript.RegisterStartupScript(Page.GetType(), "a", "alert('保存成功');self.location.href='RegPaymentList.aspx';", true);
}
