/// <summary>
/// 增加订单明细信息
/// </summary>
/// <param name="maxid"></param>
private void AddOrderDetail(int maxid, double totalmoney)
{
if (this.hidorderdetail.Value.Trim() != "")
{
string[] list = this.hidorderdetail.Value.Trim().TrimEnd(',').Split(',');
string[] txt = null;
EtNet_Models.AusOrderInfo model = null;
for (int i = 0; i < list.Length; i++)
{
txt = list[i].Split('|');
model = new EtNet_Models.AusOrderInfo();
model.orderId = txt[0] != "" ? int.Parse(txt[0]) : 0; //订单id
model.jobflowId = maxid; //工作流id
model.orderNum = txt[1]; //订单序号
model.orderType = txt[2]; //订单类型
model.outTime = txt[3] != "" ? DateTime.Parse(txt[3]) : DateTime.Parse("1900-1-1"); //出团日期
model.natrue = txt[4]; //性质
model.tour = txt[5]; //路线
EtNet_BLL.AusOrderInfoManager.Add(model);
EtNet_Models.To_OrderInfo orderInfo = To_OrderInfoManager.getTo_OrderInfoById(model.orderId);
if (orderInfo != null)
{
orderInfo.Gross = orderInfo.Gross - totalmoney;
To_OrderInfoManager.updateOrderGross(orderInfo);
}
}
}
}
/// <summary>
/// 加载订单数据
/// </summary>
private void LoadOrderList()
{
if (Session["login"] == null)
{
Response.Redirect("~/Login.aspx", true);
}
else
{
LoginInfo login = Session["login"] as LoginInfo;
if (Session["cutPay"].ToString() != "")
{
string sql = " collectStatus='完成收款' ";
sql += Session["cutPay"].ToString();
EtNet_BLL.DataPage.Data data = new EtNet_BLL.DataPage.Data();
SearchPageSet sps = SearchPageSetManager.getSearchPageSetByLoginId(login.Id, 033);
if (sps != null)
{
this.j_pagesize.Value = sps.Pageitem.ToString();
this.j_pagecount.Value = sps.Pagecount.ToString();
}
this.payRepeater.DataSource = To_OrderInfoManager.GetViewOrderAndCollect("*", sql);
this.payRepeater.DataBind();
}
}
}
/// <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>
private void LoadInputerList()
{
if (Session["inputercutPay"].ToString() != "")
{
string sql = " 1=1 ";
sql += Session["inputercutPay"];
this.inputerTc.DataSource = To_OrderInfoManager.GetList(0, sql, "outTime");
this.inputerTc.DataBind();
}
}
/// <summary>
/// 更新的方法
/// </summary>
private string AuditUpdate(string args, string auditstatus, int id)
{
To_OrderInfo orderModle = To_OrderInfoManager.getTo_OrderInfoById(id);
JobFlow jobModel = JobFlowManager.GetModel(orderModle.JobflowID);
jobModel.savestatus = args;
jobModel.auditstatus = auditstatus;
JobFlowManager.Update(jobModel);
return(orderModle.OrderNum);
}
/// <summary>
/// 操作
/// </summary>
/// <param name="source"></param>
/// <param name="e"></param>
protected void cuslist_ItemCommand(object source, RepeaterCommandEventArgs e)
{
switch (e.CommandName)
{
case "File":
To_OrderInfoManager.updateFileStatus(0, Convert.ToInt32(e.CommandArgument));
break;
}
OrderListBind();
}
/// <summary>
/// 加载订单数据
/// </summary>
private void LoadOrderCollect()
{
if (Session["MyOrderQuery"].ToString() != "")
{
string sqlstr = " and iscancel='N'";//0510 修改作废的订单不显示
sqlstr += Session["MyOrderQuery"].ToString();
if (Session["login"] == null)
{
Response.Redirect("~/Login.aspx", true);
}
else
{
LoginInfo login = (LoginInfo)Session["login"];
//string ids = LoginDataLimitManager.GetLimit(login.Id);
//if (string.IsNullOrEmpty(ids))
// sqlstr += " and salemanid = " + login.Id;
//else
// sqlstr += " and salemanid in (" + ids + ")";
SearchPageSet sps = SearchPageSetManager.getSearchPageSetByLoginId(login.Id, 034);
Data data = new Data();
AspNetPager1.RecordCount = data.GetCount("View_OrderAndClollect", sqlstr);
if (sps == null)
{
AspNetPager1.NumericButtonCount = 10;
AspNetPager1.PageSize = 10;
}
else
{
AspNetPager1.NumericButtonCount = sps.Pagecount;
AspNetPager1.PageSize = sps.Pageitem;
}
DataTable dt = data.GetList("View_OrderAndClollect", "outTime", "desc", AspNetPager1.PageSize, AspNetPager1.CurrentPageIndex, sqlstr);
orderRepeater.DataSource = dt;
orderRepeater.DataBind();
//计算合计
DataTable dtsum = To_OrderInfoManager.GetViewOrderAndCollect(" sum(adultNum) as adult_sum,sum(childNum) as child_sum,sum(withNum) as with_sum,sum(pNum) as pnum_sum,sum(lirun) as lirun_sum,sum(money) as money_sum ", " 1=1 " + sqlstr);
if (dtsum.Rows.Count > 0)
{
this.adult_sum.InnerHtml = dtsum.Rows[0]["adult_sum"].ToString();
this.child_sum.InnerHtml = dtsum.Rows[0]["child_sum"].ToString();
this.with_sum.InnerHtml = dtsum.Rows[0]["with_sum"].ToString();
this.pnum_sum.InnerHtml = dtsum.Rows[0]["pnum_sum"].ToString();
this.lirun_sum.InnerHtml = dtsum.Rows[0]["lirun_sum"].ToString();
this.money_sum.InnerHtml = dtsum.Rows[0]["money_sum"].ToString();
}
}
}
else
{
orderRepeater.DataSource = null;
orderRepeater.DataBind();
this.adult_sum.InnerHtml = this.child_sum.InnerHtml = this.with_sum.InnerHtml = this.pnum_sum.InnerHtml = this.lirun_sum.InnerHtml = this.money_sum.InnerHtml = "";
}
}
/// <summary>
/// 绑定订单信息中的退款信息
/// </summary>
/// <param name="payer"></param>
private void LoadOrderReturnDetail()
{
string payer = Request.QueryString["payer"];
string sql = " cusid= " + payer + " and iscancel='N' ";
sql += this.cbxshowfile.Checked ? "" : " and fileStatus=0 ";
sql += " order by outTime desc";
sql += strsql;
RpPolicyList.DataSource = To_OrderInfoManager.GetViewOrderReturn("", sql);
RpPolicyList.DataBind();
}
/// <summary>
/// 更新订单的方法
/// </summary>
private void UpdateOrder()
{
string orderid = Request.QueryString["id"];
string[] orderids = orderid.Split(',');
for (int i = 0; i < orderids.Length; i++)
{
To_OrderInfoManager.updateOrderInvoice(orderids[i], this.invoicStatus.SelectedValue);
}
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "success", "alert('更新成功');", true);
}
/// <summary>
/// 得到订单信息
/// </summary>
/// <param name="payer"></param>
/// <param name="paytype"></param>
private void To_OrderCollectDetial()
{
string payer = Request.QueryString["payer"];
string paytype = Request.QueryString["type"];
string sql = " factid = " + payer + " and payType='" + paytype + "' and iscancel='N' ";
sql += this.cbxshowfile.Checked ? "" : " and fileStatus=0 ";
sql += strsql;
sql += " order by outTime desc";
RpPolicyList.DataSource = To_OrderInfoManager.GetViewOrder("", sql.ToString());
RpPolicyList.DataBind();
}
/// <summary>
/// 加载订单信息（如果是从订单跳转过来的）
/// </summary>
/// <param name="orderid"></param>
private void LoadOrder(string orderid)
{
DataTable dt = To_OrderInfoManager.GetLists("id = " + orderid);
StringBuilder strHtml = new StringBuilder();
strHtml.Append("<tr><td class='del'><a href='javascript:void(0);' onclick='delRow(this);'><img src='../../../images/public/filedelete.gif' /></a></td>");
strHtml.Append("<td class='orderNum'>" + dt.Rows[0]["orderNum"].ToString() + "</td>");
strHtml.Append("<td class='orderType'>" + dt.Rows[0]["orderType"].ToString() + "</td>");
strHtml.Append("<td class='outTime'>" + Convert.ToDateTime(dt.Rows[0]["outTime"]).ToString("yyyy-MM-dd") + "</td>");
strHtml.Append("<td class='natrue'>" + dt.Rows[0]["natrue"].ToString() + "</td>");
strHtml.Append("<td class='tour'>" + dt.Rows[0]["line"].ToString() + "</td>");
strHtml.Append("<td class='orderId' style='display:none' >" + dt.Rows[0]["id"].ToString() + "</td></tr>");
orderList.InnerHtml = strHtml.ToString();
}
/// <summary>
/// 绑定数据
/// </summary>
private void OrderLoad()
{
//string jfId = Request.QueryString["jobflowid"].ToString();
//string sqlstring = " jobflowID=" + jfId;
//DataTable dtOrder = To_OrderInfoManager.GetLists(sqlstring);
//if (dtOrder.Rows.Count == 0)
//{
// Page.ClientScript.RegisterStartupScript(this.GetType(), "audit", "alert('数据出错，订单可能已删除！');location.href='../Job/AuditJobFlow.aspx'", true);
// return;
//}
int id = Convert.ToInt32(Request.QueryString["id"]);
//int id = Convert.ToInt32(dtOrder.Rows[0]["id"]);
To_OrderInfo order = To_OrderInfoManager.getTo_OrderInfoById(id);
DataTable dt = To_OrderInfoManager.GetLists(" id = " + id);
if (dt.Rows.Count > 0)
{
this.lblOrderCode.Text = order.OrderNum.ToString();
this.lblOrderType.Text = Convert.ToInt32(order.OrderType) == 1 ? "常规订单" : "非常规订单";
this.lblOutDate.Text = order.OutTime.ToShortDateString(); //出团日期
this.lblTotal.Text = order.TeamNum.ToString(); //团队总数
this.lblnature.Text = order.Natrue.ToString(); //性质
this.lblyjml.Text = order.Gross.ToString("F2"); //预计毛利
this.lblLine.Text = GetLineName(order.Tour); //线路
this.lblLineremark.Text = order.TourRemark; //线路描述
this.lblMarkTime.Text = order.MakerTime.ToShortDateString(); //制单时间
this.lblMakeID.Text = order.MakerName.ToString(); //制单人
this.lblIsCancel.Text = order.IsCancel == "Y" ? "是" : "否";
this.lblinputer.Text = order.Inputer; //操作人员
//收款
decimal col = LoadCol(id);
//付款
decimal pay = LoadPay(id);
//退款
decimal ret = LoadRet(id);
//报销
decimal reim = LoadRem(id);
this.lblsjml.Text = (col - pay + ret - reim).ToString("F2");
}
LoadAuditImg(int.Parse(dt.Rows[0]["ruleid"].ToString()));
optiniontxt.InnerHtml = ShowOpiniontxt(int.Parse(dt.Rows[0]["jobflowid"].ToString()));//审核人意见
LoadNowAudit(dt.Rows[0]["jobflowid"].ToString());
}
/// <summary>
/// 加载所要选择的认领订单
/// </summary>
private void LoadOrderList()
{
string payerId = Request.QueryString["payer"];
string sql = " iscancel='N'";
sql += this.cbxshowfile.Checked ? "" : " and fileStatus=0 ";
if (payerId != "")
{
sql += " and cusId = " + payerId;
}
sql += " order by outTime desc ";
DataTable dt = new DataTable();
dt = To_OrderInfoManager.GetViewOrderAndCollect("*", sql);
RpPolicyList.DataSource = dt;
RpPolicyList.DataBind();
}
/// <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));
}
}
/// <summary>
/// 编辑订单
/// </summary>
/// <param name="id">订单id</param>
private void Edit(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
{
Response.Redirect("UpdateOrder.aspx?id=" + 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>
private void LoadOrderInfo()
{
//CutPayList cList = (CutPayList)Context.Handler;
string id = Request.QueryString["id"];
id = "(" + id + ")";
string sort = Request.QueryString["sort"];
EtNet_BLL.DataPage.Data data = new EtNet_BLL.DataPage.Data();
switch (sort)
{
case "0":
this.czy.Visible = false;
string sql = " and collectId in " + id;
DataSet ds = data.DataPage("View_OrderAndClollect", "collectId", "*", sql, "orderNum", false, 5, 5, pages);
payRepeater.DataSource = ds;
payRepeater.DataBind();
sql = " 1=1 " + sql;
DataTable dt0 = To_OrderInfoManager.GetViewOrderAndCollect("sum(adultNum)+sum(childNum) as num,sum(lirun) as lirun", sql);
if (dt0.Rows.Count > 0)
{
this.sumNum.InnerText = dt0.Rows[0]["num"].ToString();
this.sumlirun.InnerText = dt0.Rows[0]["lirun"].ToString();
}
break;
case "1":
this.ywy.Visible = false;
string str = " and id in " + id;
DataSet dt = data.DataPage("To_orderInfo", "id", "*", str, "orderNum", false, 5, 5, pages);
czyRepeater.DataSource = dt;
czyRepeater.DataBind();
str = " 1=1 " + str;
DataTable dt1 = To_OrderInfoManager.getList("sum(inputerTc) as inputerTc", str);
if (dt1.Rows.Count > 0)
{
this.suminputerTc.InnerText = dt1.Rows[0]["inputerTc"].ToString();
}
break;
}
}
/// <summary>
/// 更新收款信息的提成发放状态
/// </summary>
private void UpdateOrderCollect()
{
string id = Request.QueryString["id"];
string sort = Request.QueryString["sort"];
id = "(" + id + ")";
string status = this.tc_yes.Checked ? "是" : "否";
string strWhere = " id in " + id;
switch (sort)
{
case "0":
To_OrderCollectDetialManager.updateDetialCutStatus(strWhere, status);
break;
case "1":
To_OrderInfoManager.updateInputerTcStatus(strWhere, status);
break;
}
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "success", "alert('更新成功');", true);
}
/// <summary>
/// 绑定数据
/// </summary>
private void OrderLoad()
{
string jfId = Request.QueryString["jobflowid"].ToString();
string sqlstring = " jobflowID=" + jfId;
DataTable dtOrder = To_OrderInfoManager.GetLists(sqlstring);
if (dtOrder.Rows.Count == 0)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "audit", "alert('数据出错，订单可能已删除！');location.href='../Job/AuditJobFlow.aspx'", true);
return;
}
int id = Convert.ToInt32(dtOrder.Rows[0]["id"]);
To_OrderInfo order = To_OrderInfoManager.getTo_OrderInfoById(id);
this.lblOrderCode.Text = order.OrderNum.ToString();
this.lblOrderType.Text = Convert.ToInt32(order.OrderType) == 1 ? "常规订单" : "非常规订单";
this.lblOutDate.Text = order.OutTime.ToShortDateString();
this.lblTotal.Text = order.TeamNum.ToString();
this.lblnature.Text = order.Natrue.ToString();
this.lblyjml.Text = order.Gross.ToString("F2"); //预计毛利
this.lblLine.Text = GetLineName(order.Tour); //线路
this.lblLineremark.Text = order.TourRemark; //线路描述
this.lblMarkTime.Text = order.MakerTime.ToShortDateString();
this.lblMakeID.Text = order.MakerName.ToString();
this.lblinputer.Text = order.Inputer; //操作人员
//收款
decimal col = LoadCol(id);
//付款
decimal pay = LoadPay(id);
//退款
decimal ret = LoadRet(id);
//报销
decimal reim = LoadRem(id);
this.lblsjml.Text = (col - pay + ret - reim).ToString("F2");
}
/// <summary>
/// 加载数据
/// </summary>
private void LoadData()
{
Stopwatch stpwth = new Stopwatch();
stpwth.Start();
string sqlstr = " and iscancel = 'N' ";
sqlstr += this.cbxFileShow.Checked ? "" : " and fileStatus=0 ";
sqlstr += Session["orderGrossQuery"].ToString();
LoginInfo login = (LoginInfo)Session["login"];
SearchPageSet sps = SearchPageSetManager.getSearchPageSetByLoginId(login.Id, 036);
// 20200226优化毛利表打不开，将直接查询视图数据，改为查询出来数据后程序做统计 ViewOrderGrossList 这张视图不用了
Data data = new Data();
// 配置分页信息 分页用程序分页了，不通过数据库查询
AspNetPager1.RecordCount = data.GetCount("ViewOrder", sqlstr);
if (sps == null)
{
AspNetPager1.NumericButtonCount = 10;
AspNetPager1.PageSize = 10;
}
else
{
AspNetPager1.NumericButtonCount = sps.Pagecount;
AspNetPager1.PageSize = sps.Pageitem;
}
// 获取指定条件的所有订单信息
DataTable orderTbl = To_OrderInfoManager.GetTableInfo("ViewOrder", "orderNum,id,outTime,teamNum,natrue,gross,codenum,auditstutastxt,line,iscancel,inputer,inputerID,departautocode,fileStatus", sqlstr + "order by outTime asc");
// 订单支付信息
DataTable payTbl = To_OrderInfoManager.GetTableInfo("ViewOrderPayMoney", "orderid,money,payAmount,syAmount", "and orderid in (select id from ViewOrder where 1=1 " + sqlstr + ")");
// 订单收款信息
DataTable colTbl = To_OrderInfoManager.GetTableInfo("ViewOrderCollectMoney", "orderid,money,collectAmount,syAmount,collectStatus", "and orderid in (select id from ViewOrder where 1=1 " + sqlstr + ")");
// 订单退款信息
DataTable refuTbl = To_OrderInfoManager.GetTableInfo("ViewOrderRefuMoney", "orderid,money,refundAmount,syAmount", "and orderid in (select id from ViewOrder where 1=1 " + sqlstr + ")");
// 订单报销信息
DataTable reimTbl = To_OrderInfoManager.GetTableInfo("ViewOrderReimMoney", "orderId,totalmoney", "and orderid in (select id from ViewOrder where 1=1 " + sqlstr + ")");
// 付款信息的key-value
Dictionary <string, DataRow> payMap = new Dictionary <string, DataRow>();
for (int i = 0; i < payTbl.Rows.Count; i++)
{
payMap.Add(payTbl.Rows[i]["orderid"].ToString(), payTbl.Rows[i]);
}
// 收款信息的key-value
Dictionary <string, DataRow> colMap = new Dictionary <string, DataRow>();
for (int i = 0; i < colTbl.Rows.Count; i++)
{
colMap.Add(colTbl.Rows[i]["orderid"].ToString(), colTbl.Rows[i]);
}
// 退款信息的key-value
Dictionary <string, DataRow> refuMap = new Dictionary <string, DataRow>();
for (int i = 0; i < refuTbl.Rows.Count; i++)
{
refuMap.Add(refuTbl.Rows[i]["orderid"].ToString(), refuTbl.Rows[i]);
}
// 报销信息的key-value
Dictionary <string, DataRow> reimMap = new Dictionary <string, DataRow>();
for (int i = 0; i < reimTbl.Rows.Count; i++)
{
reimMap.Add(reimTbl.Rows[i]["orderId"].ToString(), reimTbl.Rows[i]);
}
// 合计信息
double collectShouldSum = 0, collectAmountSum = 0, collectSySum = 0, payShouldSum = 0, payAmountSum = 0, paySySum = 0, refuShouldSum = 0, refundAmountSum = 0, refuSySum = 0, reimShouldSum = 0, grossBxSum = 0;
// 生成最终的毛利表信息
orderTbl.Columns.Add("payShould");
orderTbl.Columns.Add("payAmount");
orderTbl.Columns.Add("paySy");
orderTbl.Columns.Add("collectShould");
orderTbl.Columns.Add("collectAmount");
orderTbl.Columns.Add("collectSy");
orderTbl.Columns.Add("collectStatus");
orderTbl.Columns.Add("refuShould");
orderTbl.Columns.Add("refundAmount");
orderTbl.Columns.Add("refuSy");
orderTbl.Columns.Add("reimShould");
orderTbl.Columns.Add("gross_bx");
for (int i = 0; i < orderTbl.Rows.Count; i++)
{
string orderId = orderTbl.Rows[i]["id"].ToString();
double gross_bx = 0;
if (payMap.ContainsKey(orderId))
{
DataRow payRow = payMap[orderId];
orderTbl.Rows[i]["payShould"] = payRow["money"]; // 应付款
orderTbl.Rows[i]["payAmount"] = payRow["payAmount"]; // 付款合计
orderTbl.Rows[i]["paySy"] = payRow["syAmount"]; // 付款剩余
payShouldSum += Convert.IsDBNull(payRow["money"]) ? 0 : Convert.ToDouble(payRow["money"]);
payAmountSum += Convert.IsDBNull(payRow["payAmount"]) ? 0 : Convert.ToDouble(payRow["payAmount"]);
paySySum += Convert.IsDBNull(payRow["syAmount"]) ? 0 : Convert.ToDouble(payRow["syAmount"]);
gross_bx -= Convert.IsDBNull(payRow["money"]) ? 0 : Convert.ToDouble(payRow["money"]);
}
if (colMap.ContainsKey(orderId))
{
DataRow colRow = colMap[orderId];
orderTbl.Rows[i]["collectShould"] = colRow["money"]; // 应收款
orderTbl.Rows[i]["collectAmount"] = colRow["collectAmount"]; // 收款合计
orderTbl.Rows[i]["collectSy"] = colRow["syAmount"]; // 收款剩余
orderTbl.Rows[i]["collectStatus"] = colRow["collectStatus"]; // 收款状态
collectShouldSum += Convert.IsDBNull(colRow["money"]) ? 0 : Convert.ToDouble(colRow["money"]);
collectAmountSum += Convert.IsDBNull(colRow["collectAmount"]) ? 0 : Convert.ToDouble(colRow["collectAmount"]);
collectSySum += Convert.IsDBNull(colRow["syAmount"]) ? 0 : Convert.ToDouble(colRow["syAmount"]);
gross_bx += Convert.IsDBNull(colRow["money"]) ? 0 : Convert.ToDouble(colRow["money"]);
}
if (refuMap.ContainsKey(orderId))
{
DataRow refuRow = refuMap[orderId];
orderTbl.Rows[i]["refuShould"] = refuRow["money"]; // 应退款
orderTbl.Rows[i]["refundAmount"] = refuRow["refundAmount"]; // 退款合计
orderTbl.Rows[i]["refuSy"] = refuRow["syAmount"]; // 退款剩余
refuShouldSum += Convert.IsDBNull(refuRow["money"]) ? 0 : Convert.ToDouble(refuRow["money"]);
refundAmountSum += Convert.IsDBNull(refuRow["refundAmount"]) ? 0 : Convert.ToDouble(refuRow["refundAmount"]);
refuSySum += Convert.IsDBNull(refuRow["syAmount"]) ? 0 : Convert.ToDouble(refuRow["syAmount"]);
gross_bx += Convert.IsDBNull(refuRow["money"]) ? 0 : Convert.ToDouble(refuRow["money"]);
}
if (reimMap.ContainsKey(orderId))
{
DataRow reimRow = reimMap[orderId];
orderTbl.Rows[i]["reimShould"] = reimRow["totalmoney"]; // 应报销款
reimShouldSum += Convert.IsDBNull(reimRow["totalmoney"]) ? 0 : Convert.ToDouble(reimRow["totalmoney"]);
gross_bx -= Convert.IsDBNull(reimRow["totalmoney"]) ? 0 : Convert.ToDouble(reimRow["totalmoney"]);
}
orderTbl.Rows[i]["gross_bx"] = gross_bx;
grossBxSum += gross_bx;
}
orderGrossList = orderTbl;
// 获取排序后的订单信息数据
//DataTable dt = data.GetList("ViewOrderGrossList", "id", "desc", AspNetPager1.PageSize, AspNetPager1.CurrentPageIndex, sqlstr);
//rpgrossdata.DataSource = dt;
//rpgrossdata.DataBind();
//计算金额合计
scshould.InnerText = collectShouldSum.ToString("N2");
scamount.InnerText = collectAmountSum.ToString("N2");
scsy.InnerText = collectSySum.ToString("N2");
spshould.InnerText = payShouldSum.ToString("N2");
spamount.InnerText = payAmountSum.ToString("N2");
spsy.InnerText = paySySum.ToString("N2");
srshould.InnerText = refuShouldSum.ToString("N2");
sramount.InnerText = refundAmountSum.ToString("N2");
srsy.InnerText = refuSySum.ToString("N2");
sbx.InnerText = reimShouldSum.ToString("N2");
sml.InnerText = grossBxSum.ToString("N2");
stpwth.Stop();
TimeSpan ts = stpwth.Elapsed;
bindData();
}
/// <summary>
/// 提示清空
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ibtnDeleteAll_Click(object sender, ImageClickEventArgs e)
{
string str = "";
if (cbAnnouncement.Checked == true)
{
AnnouncementInfoManager.Clear();
ClearAuditAndJobflow("04");
str += "公告管理清空完成;\\n";
}
if (cbCalendar.Checked == true)
{
CalendarsManager.Clear();
str += "日程管理清空完成;\\n";
}
if (cbCompany.Checked == true)
{
FactoryManager.Clear();
str += "付款单位清空完成;\\n";
}
if (cbCustomer.Checked == true)
{
CustomerManager.Clear();
ClearAuditAndJobflow("03");
str += "收款单位清空完成;\\n";
}
if (cbFinancial.Checked == true)
{
To_CollectingManager.Clear();
str += "收款管理清空完成;\\n";
}
if (cbInfomation.Checked == true)
{
InformationManager.Clear();
str += "消息管理清空完成;\\n";
}
if (cbInvocie.Checked == true)
{
To_InvoiceManager.Clear();
str += "发票管理清空完成;\\n";
}
if (cbLinkInfo.Checked == true)
{
AddressListInfoManager.Clear();
str += "通讯录清空完成;\\n";
}
if (cbPicture.Checked == true)
{
PictureInfoManager.Clear();
str += "图片管理清空完成;\\n";
}
if (cbPolicy.Checked == true)
{
To_OrderInfoManager.Clear();
// ClearAuditAndJobflow("02");
str += "保单管理清空完成;\\n";
}
if (cbReimbursed.Checked == true)
{
ClearAuditAndJobflow("01");
AusRottenInfoManager.Clear();
str += "报销管理清空完成;\\n";
}
// ClientScript.RegisterStartupScript(this.GetType(), "", " <script lanuage=javascript> alert('"+ str +"');</script>");
ClientScript.RegisterClientScriptBlock(this.GetType(), "page", string.Format("alert('{0}');", str), true);
}
/// <summary>
/// 添加订单信息
/// </summary>
private void AddBase(string sort)
{
string cuscode = ""; //公司代码全称
string codeformat = ""; //公司代码，不包含流水号
string ordernum = ""; //流水号
if (StrNumbers(this.txtOrderCode.Value, out cuscode, out codeformat, out ordernum))
{
int maxid = 0;
EtNet_Models.JobFlow model = new JobFlow();
model.attachment = codeformat;
model.txt = ordernum;
model.cname = cuscode;
model.sort = "02"; //订单申请
model.auditsort = "";
model.createtime = DateTime.Now; //默认是当前时间
model.endtime = DateTime.Now;
model.founderid = ((EtNet_Models.LoginInfo)Session["login"]).Id; //登录人员的id
model.ruleid = int.Parse(this.DdlIsVirify.SelectedValue);
if (sort == "save")
{
model.savestatus = "草稿";
model.auditstatus = "01";
maxid = EtNet_BLL.JobFlowManager.AddAndGetId(model); //工作流的id值
}
else
{
model.savestatus = "已提交";
model.auditstatus = "02";
maxid = EtNet_BLL.JobFlowManager.AddAndGetId(model); //工作流的id值
CreateApproval(int.Parse(this.DdlIsVirify.SelectedValue), maxid);
SendMessage(maxid.ToString());
}
//基本信息
EtNet_Models.To_OrderInfo order = new EtNet_Models.To_OrderInfo();
order.OrderNum = cuscode;
order.Codeformat = codeformat;
order.Codenum = ordernum;
order.JobflowID = Convert.ToInt32(this.DdlIsVirify.SelectedValue);
order.MakerName = ((LoginInfo)Session["login"]).Cname;
order.MakerTime = DateTime.Now;
order.MarkId = ((LoginInfo)Session["login"]).Id;
order.Natrue = this.ddlnature.SelectedValue; //订单类型
order.OrderType = this.DropDownList1.SelectedValue;
order.OutTime = Convert.ToDateTime(this.txtOutDate.Value);
order.CollectCusID = "";
order.CollectAmount = Convert.ToDouble(lblCollAmount.Value); //收款金额合计
order.PayAmount = Convert.ToDouble(lblPayAmount.Value); //付款金额合计
order.PayCusID = "";
order.RefundAmount = Convert.ToDouble(lblBackAmount.Value); //退款金额合计
order.RefundID = "";
order.ReimAmount = Convert.ToDouble(0);
order.ReimID = "";
order.Gross = Convert.ToDouble(lblCollAmount.Value) - Convert.ToDouble(lblPayAmount.Value) + Convert.ToDouble(lblBackAmount.Value); //预计毛利
order.TeamNum = txtTeamnum.Value;
order.Tour = this.ddlLine.SelectedValue;
order.TourRemark = this.txtRemark.Value;
order.Verify = Convert.ToInt32(this.DdlIsVirify.SelectedValue);
order.JobflowID = maxid;
//操作人员
order.Inputer = ddlInputer.SelectedItem.Text;
order.InputerID = Convert.ToInt32(ddlInputer.SelectedValue);
order.InputerTc = order.Gross * LoginInfoManager.getLoginInfoById(order.InputerID).orderRate; //操作员提成金额
order.Gross = order.Gross - order.InputerTc; //预计毛利还得减掉操作员在该笔订单中所占的提成（毛利*提成系数）
//部门编码标识符
DepartmentInfo depart = DepartmentInfoManager.getDepartmentInfoById(((LoginInfo)Session["login"]).Departid);
if (depart != null)
{
order.DepartAutoCode = depart.AutoCode;
}
else
{
order.DepartAutoCode = "";
}
//订单是否作废
order.IsCancel = "N";
int count = To_OrderInfoManager.addTo_OrderInfo(order);
if (count > 0)
{
addlink(count);
addbank(count);
addback(count);
if (sort == "save")
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('保存成功！');location.href='OrderList.aspx'", true);
}
else
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('送审成功！');location.href='OrderList.aspx'", 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 cuscode, out string codeformat, out string ordernum)
{
bool result = true;
cuscode = ""; //订单代码全称
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 ordertbl = null;
string strsql = ""; //查询字符窜
if (usecode == "0")
{
if (strcuscode.Trim() != "")
{
//strsql = " orderNum ='" + strcuscode + "'";
//ordertbl = To_OrderInfoManager.getList(strsql);
//if (ordertbl.Rows.Count != 0)
//{
// result = false;
// Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "test", "<script>alert('保存失败, 付款单位代码已存在!')</script>");
//}
//else
//{
cuscode = strcuscode; //付款单位代码全称
//}
}
else
{
result = false;
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "test", "<script>alert('保存失败,付款单位代码不能为空!')</script>");
}
}
else
{
int num = 1; //默认流水号
codeformat = Numbers(txtformat); //编码规格
LoginInfo login = Session["login"] as LoginInfo;
string departcode = DepartmentInfoManager.getDepartmentInfoById(login.Departid).AutoCode; //部门自动编码标识符
string year = DateTime.Parse(this.txtOutDate.Value).Year.ToString(); //出团年份
strsql = " YEAR(outTime)= '" + year + "' AND LEN(codenum) =" + len.ToString() + " AND departautocode='" + departcode + "' AND orderType=" + this.DropDownList1.SelectedValue;
ordertbl = To_OrderInfoManager.GetList(1, strsql, " id desc ");
if (ordertbl.Rows.Count >= 1)
{
if (ordertbl.Rows[0]["codenum"].ToString() != "")
{
num = int.Parse(ordertbl.Rows[0]["codenum"].ToString()) + 1; //流水号
if (num.ToString().Length > len)
{
result = false;
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "test", "<script>alert('保存失败,流水号长度不够!')</script>");
}
}
}
ordernum = num.ToString().PadLeft(len, '0'); //流水号
cuscode = codeformat + ordernum; //付款单位代码全称
}
return(result);
}
/// <summary>
/// 操作
/// </summary>
/// <param name="source"></param>
/// <param name="e"></param>
protected void cuslist_ItemCommand(object source, RepeaterCommandEventArgs e)
{
To_OrderInfo orderinfo = To_OrderInfoManager.getTo_OrderInfoById(Convert.ToInt32(e.CommandArgument));
switch (e.CommandName)
{
case "Delete":
Del(Convert.ToInt32(e.CommandArgument));
//To_OrderReimDetialManager.deleteTo_OrderReimDetialByOrderID(Convert.ToInt32(e.CommandArgument));
break;
case "Edit":
if (orderinfo != null)
{
int jobflowid = orderinfo.JobflowID;
JobFlow model = JobFlowManager.GetModel(jobflowid);
if (model.savestatus == "草稿" && model.auditstatus == "01")
{
Edit(Convert.ToInt32(e.CommandArgument));
}
else
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "edit", "alert('该订单已送审，无法修改，欲修改请先回收');", true);
}
}
break;
case "Detial":
Response.Redirect("OrderDetial.aspx?id=" + Convert.ToInt32(e.CommandArgument));
break;
case "Audit":
if (orderinfo != null)
{
int jobflowid = orderinfo.JobflowID;
JobFlow model = JobFlowManager.GetModel(jobflowid);
if (model == null || model.auditstatus != "01" || model.savestatus == "已提交")
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "audit", "<script>alert('订单已删除或订单已经送审或审核员已审核')</script>");
}
else
{
To_OrderInfo orderModle = To_OrderInfoManager.getTo_OrderInfoById(Convert.ToInt32(e.CommandArgument));
JobFlow jobModel = JobFlowManager.GetModel(orderModle.JobflowID);
string ordernum = AuditUpdate("已提交", "01", Convert.ToInt32(e.CommandArgument));
CreateApproval(jobModel.ruleid, orderModle.JobflowID);
SendMessage(ordernum.ToString(), jobModel.ruleid);
}
}
break;
case "Refresh":
orderinfo = To_OrderInfoManager.getTo_OrderInfoById(Convert.ToInt32(e.CommandArgument));
Refresh(orderinfo.JobflowID);
break;
case "File":
To_OrderInfoManager.updateFileStatus(1, Convert.ToInt32(e.CommandArgument));
break;
case "delFile":
To_OrderInfoManager.updateFileStatus(0, Convert.ToInt32(e.CommandArgument));
break;
}
OrderListBind();
}
