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