/// <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);
}
}
}
