/// <summary>
/// 删除订单
/// </summary>
/// <param name="id">订单的id值</param>
private void Del(int id)
{
To_OrderInfo orderinfo = To_OrderInfoManager.getTo_OrderInfoById(id);
if (orderinfo != null)
{
int jobflowid = orderinfo.JobflowID;
JobFlow model = JobFlowManager.GetModel(jobflowid);
if (model == null || model.auditstatus != "01")
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "del", "<script>alert('订单已删除或审核员已审核')</script>");
}
else if (!To_OrderInfoManager.CanDelete(id))
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "del", "<script>alert('该订单关联过收款或付款或退款或报销，无法删除')</script>");
}
else
{
string strdel = " jobflowid=" + jobflowid;
AuditJobFlowManager.Delete(strdel);
JobFlowManager.Delete(jobflowid);
To_OrderInfoManager.deleteTo_OrderInfo(Convert.ToInt32(id));
To_OrderCollectDetialManager.deleteTo_OrderCollectDetialByOrderID(Convert.ToInt32(id));
To_OrderPayDetialManager.deleteTo_OrderPayDetialByOrderID(Convert.ToInt32(id));
To_OrderRefunDetialManager.deleteTo_OrderRefunDetialByOrderID(Convert.ToInt32(id));
}
}
}
/// <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>
/// <param name="id">报销单id</param>
private void Del(int id)
{
AusRottenInfo info = AusRottenInfoManager.GetModel(id);
if (info != null)
{
int jobflowid = info.jobflowid;
string strdel = " jobflowid=" + jobflowid;
AuditJobFlowManager.Delete(strdel);
JobFlowManager.Delete(jobflowid);
JobFlowFileManager.Delete(jobflowid);
AusDetialInfoManager.Del(jobflowid);
//RegReimbursementManager.Delete(id.ToString());
//ReimbursementInvoiceManager;
AusRottenInfoManager.Delete(id);
}
}
/// <summary>
/// 删除订单
/// </summary>
/// <param name="id">订单的id值</param>
private void Del(int id)
{
To_OrderInfo orderinfo = To_OrderInfoManager.getTo_OrderInfoById(id);
if (orderinfo != null)
{
int jobflowid = orderinfo.JobflowID;
JobFlow model = JobFlowManager.GetModel(jobflowid);
string strdel = " jobflowid=" + jobflowid;
AuditJobFlowManager.Delete(strdel);
JobFlowManager.Delete(jobflowid);
To_OrderInfoManager.deleteTo_OrderInfo(Convert.ToInt32(id));
To_OrderCollectDetialManager.deleteTo_OrderCollectDetialByOrderID(Convert.ToInt32(id));
To_OrderPayDetialManager.deleteTo_OrderPayDetialByOrderID(Convert.ToInt32(id));
To_OrderRefunDetialManager.deleteTo_OrderRefunDetialByOrderID(Convert.ToInt32(id));
}
}
protected void ibtnDeleteAll_Click(object sender, ImageClickEventArgs e)
{
string delId = "";
//先遍历取得选中项
for (int i = 0; i < this.rpPoliy.Items.Count; i++)
{
CheckBox cbx = (CheckBox)(rpPoliy.Items[i].FindControl("cbx"));
Label lbl = (Label)rpPoliy.Items[i].FindControl("lbl");
if (cbx != null || cbx.Text != "")
{
if (cbx.Checked)
{
delId += lbl.Text + ",";
}
}
}
//去掉最后一个,
delId = (delId + ")").Replace(",)", "");
IList check = delId.Split(',');
for (int i = 0; i < check.Count; i++)
{
To_OrderInfo orderinfo = To_OrderInfoManager.getTo_OrderInfoById(Convert.ToInt32(check[i]));
if (orderinfo != null)
{
int jobflowid = orderinfo.JobflowID;
JobFlow model = JobFlowManager.GetModel(jobflowid);
string strdel = " jobflowid=" + jobflowid;
AuditJobFlowManager.Delete(strdel);
JobFlowManager.Delete(jobflowid);
To_OrderInfoManager.deleteTo_OrderInfo(Convert.ToInt32(check[i]));
To_OrderCollectDetialManager.deleteTo_OrderCollectDetialByOrderID(Convert.ToInt32(check[i]));
To_OrderPayDetialManager.deleteTo_OrderPayDetialByOrderID(Convert.ToInt32(check[i]));
To_OrderRefunDetialManager.deleteTo_OrderRefunDetialByOrderID(Convert.ToInt32(check[i]));
}
}
BindData();
}
/// <summary>
/// 删除保单
/// </summary>
/// <param name="id">保单的id值</param>
private void Del(int id)
{
To_Policy policy = To_PolicyManager.getTo_PolicyById(id);
if (policy != null)
{
int jobflowid = policy.IsVerify;
JobFlow model = JobFlowManager.GetModel(jobflowid);
if (model == null || model.auditstatus != "01")
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "del", "<script>alert('保单已删除或审核员已审核')</script>");
}
else
{
string strdel = " jobflowid=" + jobflowid;
AuditJobFlowManager.Delete(strdel);
JobFlowManager.Delete(jobflowid);
To_PolicyManager.deleteTo_Policy(id);
To_PolicyDetailManager.DeleteByPolicy(id);
}
}
}
//通过审核
protected void imgbtnpass_Click(object sender, ImageClickEventArgs e)
{
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 (AuditJobFlowManager.GetList(comparedata).Rows.Count == 0)
{
//该工作流被收回或删除导致审批提交失败
Response.Redirect("../Job/AuditJobFlow.aspx");
}
else if (JobFlowManager.GetModel(jobflowid).auditstatus == "03" || JobFlowManager.GetModel(jobflowid).auditstatus == "04")
{
//该工作流是审核方式是选审或会签所以在提交审核时，工作流已由他人审核通过
Response.Redirect("../Job/AuditJobFlow.aspx");
}
else
{
JobFlow jobflow = JobFlowManager.GetModel(jobflowid);
ApprovalRule rule = ApprovalRuleManager.GetModel(jobflow.ruleid);
string ruletxt = rule.sort; //审核的分类
//修改当前审核人的记录
AuditJobFlow auditmodel = null;
string auditstr = " jobflowid=" + jobflowid.ToString() + " AND reviewerid=" + ((LoginInfo)Session["login"]).Id;
DataTable audittbl = AuditJobFlowManager.GetList(auditstr); // 查找到当前审核人员的记录
int num = int.Parse(audittbl.Rows[0]["numbers"].ToString()); //当前审核人员编号
string mainreviewer = audittbl.Rows[0]["mainreviewer"].ToString(); //当前审核人是不是最终审核人
auditmodel = new 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.treatxt.Value.Trim());
AuditJobFlowManager.Update(auditmodel);
//依据不同的审核类型进行操作
switch (ruletxt)
{
case "单审":
if (mainreviewer != "T")
{
auditmodel = new AuditJobFlow(); //设置下一个审核人的数据记录
string nextauditstr = " jobflowid=" + jobflowid.ToString() + " AND numbers=" + (num + 1).ToString();
DataTable nextaudittbl = 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();
AuditJobFlowManager.Update(auditmodel);
jobflow.auditstatus = "02"; //工作流的审核状态为“进行中”
JobFlowManager.Update(jobflow);
}
else
{
jobflow.endtime = DateTime.Now;
jobflow.auditstatus = "04"; //工作流的审核状态为“已通过”
JobFlowManager.Update(jobflow);
}
break;
case "选审":
jobflow.endtime = DateTime.Now;
jobflow.auditstatus = "04"; //工作流的审核状态为“已通过”
JobFlowManager.Update(jobflow);
break;
case "会审":
bool pass = true;
string strsql = " jobflowid=" + jobflowid.ToString();
DataTable auditjobtbl = AuditJobFlowManager.GetList(strsql);
for (int i = 0; i < auditjobtbl.Rows.Count; i++)
{
if (auditjobtbl.Rows[i]["auditoperat"].ToString() != "通过")
{
pass = false; //说明还有其他审核人员未开始审核
break;
}
}
if (pass)
{
jobflow.endtime = DateTime.Now;
jobflow.auditstatus = "04"; //工作流的状审核状态为“已通过”
JobFlowManager.Update(jobflow);
}
else
{
jobflow.auditstatus = "02"; //工作流的状审核状态为“进行中”
JobFlowManager.Update(jobflow);
}
break;
}
string sqlpolicy = " isVerify =" + jobflowid.ToString();
DataTable tblpolicy = EtNet_BLL.To_PolicyManager.GetList(1, sqlpolicy, "id");
EtNet_Models.To_Policy policy = EtNet_BLL.To_PolicyManager.getTo_PolicyById(int.Parse(tblpolicy.Rows[0]["id"].ToString()));
if (policy.Txt == "")
{
policy.Txt = login.Cname + "的审批意见：" + Server.UrlDecode(this.treatxt.Value.Trim());
}
else
{
policy.Txt = policy.Txt + "|" + login.Cname + "的审批意见：" + Server.UrlDecode(this.treatxt.Value.Trim());
}
EtNet_BLL.To_PolicyManager.updateTo_Policy(policy);
SendMessage("【" + login.Cname + "】通过审批");
SendNextAudit(jobflowid);
Response.Redirect("../Job/AuditJobFlow.aspx");
}
}
private void OrderPass()
{
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 = " jobflowID=" + jobflowid.ToString();
DataTable tbl = EtNet_BLL.To_OrderInfoManager.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());
if (this.iptcomment.Value != "")
{
auditmodel.opiniontxt = Server.UrlDecode(this.iptcomment.Value.Trim());
}
else
{
auditmodel.opiniontxt = " ";
}
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);
EtNet_BLL.To_OrderInfoManager.updateOrdersjGross(jobflowid.ToString(), this.lblsjml.Text);
}
break;
case "选审":
jobflowmodel.endtime = DateTime.Now;
jobflowmodel.auditstatus = "04"; //工作流的审核状态为“已通过”
EtNet_BLL.JobFlowManager.Update(jobflowmodel);
EtNet_BLL.To_OrderInfoManager.updateOrdersjGross(jobflowid.ToString(), this.lblsjml.Text);
//审核通过后，删除其他审核人员的审核流数据
AuditJobFlowManager.UpdateOther(" reviewerid != " + login.Id + " and jobflowid=" + jobflowid.ToString());
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);
EtNet_BLL.To_OrderInfoManager.updateOrdersjGross(jobflowid.ToString(), this.lblsjml.Text);
}
else
{
jobflowmodel.auditstatus = "02"; //工作流的状审核状态为“进行中”
EtNet_BLL.JobFlowManager.Update(jobflowmodel);
}
break;
}
string strad = "编号为" + jobflowmodel.cname + "的订单，【" + login.Cname + "】通过审批!";
SendInfo(strad, jobflowmodel.id);
SendNextAudit(jobflowmodel.id);
//修改客户的审核意见与启用状态
//int cusid = int.Parse(tbl.Rows[0]["id"].ToString());
EtNet_Models.AuditJobFlow cus = EtNet_BLL.AuditJobFlowManager.GetModelByJFID(jobflowid);
cus.opiniontxt = cus.opiniontxt + login.Cname + "的审批意见：" + Server.UrlDecode(this.iptcomment.Value.Trim()) + "|";
//if (jobflowmodel.auditstatus == "04")
//{
// cus.Used = 1;
//}
EtNet_BLL.AuditJobFlowManager.Update(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);
}
}
}
