From d3205f4627ceb7af1344ce77715def28fee5545b Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期三, 17 十二月 2025 08:56:19 +0800
Subject: [PATCH] 在“编号”和“片区”直接增加一列“送货时间”，该送货时间显示进行了“送货安排”操作的学校的时间，没有安排送货的学校就是空白 完成
---
CY_ECommercePlatform/CY.WebForm/Pages/business/DeliverWorkBookAnPaiList.aspx.cs | 172 ++++++++++++++++++++++++++++++++++++++++++++++++++++----
1 files changed, 158 insertions(+), 14 deletions(-)
diff --git a/CY_ECommercePlatform/CY.WebForm/Pages/business/DeliverWorkBookAnPaiList.aspx.cs b/CY_ECommercePlatform/CY.WebForm/Pages/business/DeliverWorkBookAnPaiList.aspx.cs
index f1d734c..2f067be 100644
--- a/CY_ECommercePlatform/CY.WebForm/Pages/business/DeliverWorkBookAnPaiList.aspx.cs
+++ b/CY_ECommercePlatform/CY.WebForm/Pages/business/DeliverWorkBookAnPaiList.aspx.cs
@@ -11,6 +11,7 @@
using CY.Infrastructure.Common;
using CY.BLL.EC;
using CY.Model.Inquiry;
+using CY.Infrastructure.Cache;
namespace CY.WebForm.Pages.business
{
@@ -22,6 +23,14 @@
OA_StaffBLL bll_OA_StaffBLL = null;
EC_OrderBasicBLL bll_EC_OrderBasicBLL = null;
public string xiala = "";
+ private static ICacheStrategy CACHE = null;//缂撳瓨鎺ュ彛瀵硅薄
+ public string biaotou = "";
+ public string biaowei = "";
+
+
+ CoreCmsPlanOrderBLL bll_CoreCmsPlanOrderBLL = null;
+ CoreCmsPlanOrderItemBLL bll_CoreCmsPlanOrderItemBLL = null;
+ EC_OrderPrintParameterBLL _eC_OrderPrintParameterBLL = null;
//鍒濆鍖�
public DeliverWorkBookAnPaiList()
@@ -30,12 +39,18 @@
bll_OA_StaffBLL = new OA_StaffBLL();
_CoreDeliverOrderBLL = new CoreDeliverOrderBLL();
bll_EC_OrderBasicBLL = new EC_OrderBasicBLL();
+ bll_CoreCmsPlanOrderBLL = new CoreCmsPlanOrderBLL();
+ bll_CoreCmsPlanOrderItemBLL = new CoreCmsPlanOrderItemBLL();
+ _eC_OrderPrintParameterBLL = new EC_OrderPrintParameterBLL();
+ CacheFactory.InitializeCacheFactory(new DefaultCacheStrategy());//鍒濆鍖栫紦瀛樺伐鍘�
+ CACHE = CacheFactory.GetCacher();//鍒涘缓缂撳瓨
+ CACHE.TimeOut = 6000;
}
//椤甸潰鍔犺浇
protected void Page_Load(object sender, EventArgs e)
{
- UCPager1.AspNetPager.PageChanged += AspNetPager1_PageChanged;
+ //UCPager1.AspNetPager.PageChanged += AspNetPager1_PageChanged;
if (!IsPostBack)
{
this.selDriver.DataSource = bll_OA_StaffBLL.SelectListByFirmId(CurrentUser.MemberId, false, false).Where(x => x.SM_Post == "鍙告満"); ;
@@ -45,9 +60,17 @@
this.selDriver.Items.Insert(0, new ListItem("鍏ㄩ儴", ""));
-
-
-
+ this.selBuyerName.DataSource = bll_EC_OrderBasicBLL.GetOrderByPrintTypeId(37).Where(x => x.OrderState == 4 || x.OrderState == 2 || x.OrderState == 3).OrderByDescending(x => x.CreateTime); ;
+ this.selBuyerName.DataTextField = "BuyerName";
+ this.selBuyerName.DataValueField = "Keyid";
+ this.selBuyerName.DataBind();
+ //this.selBuyerName.Items.Insert(0, new ListItem("鍏ㄩ儴", ""));
+ this.txtBeginDate.Value = DateTime.Now.AddDays(1).ToString("yyyy-MM-dd");
+ var stringBuyerName = CACHE.RetrieveObject(CurrentUser.TrueMemberId + "BuyerName") as string;//浠庣紦瀛樹腑鑾峰彇鏁版嵁璁块棶瀹炵幇灞傜▼搴忛泦
+ if (null != stringBuyerName)
+ {
+ this.selBuyerName.Value = stringBuyerName;
+ }
BindList();
}
@@ -56,18 +79,51 @@
//缁戝畾鏁版嵁
private void BindList()
{
- var eC_OrderBasics = bll_EC_OrderBasicBLL.GetOrderByPrintTypeId(37).Where(x => x.OrderState == 4);
- foreach (var eC_OrderBasic in eC_OrderBasics)
- {
- xiala += "<option value=\"" + eC_OrderBasic.BuyerName + "\">";
+ //var eC_OrderBasics = bll_EC_OrderBasicBLL.GetOrderByPrintTypeId(37).Where(x => x.OrderState == 4);
+ //foreach (var eC_OrderBasic in eC_OrderBasics)
+ //{
+ // xiala += "<option value=\"" + eC_OrderBasic.BuyerName + "\">";
+
+ //}
+ CACHE.AddObject(CurrentUser.TrueMemberId + "BuyerName", this.selBuyerName.Value.Trim());//灏嗙▼搴忛泦鍐欏叆缂撳瓨
+ Pagination pa = new Pagination();
+ pa.PageSize = 500;
+ pa.PageIndex = 1;
+
+ var coreDeliverOrders = _CoreDeliverOrderBLL.SelectModelPage(pa, CurrentUser.MemberId, this.selDriver.Value.ToInt32(),this.txtXuexiao.Value.Trim(),this.selBuyerName.Value.Trim(), this.txtBeginDate.Value.Trim(), this.txtEndDate.Value.Trim()); ;
+ EC_OrderPrintParameter _eC_OrderPrintParameter = _eC_OrderPrintParameterBLL.GetModel(this.selBuyerName.Value.Trim().ToInt32().Value);
+ InquiryCommonModel _inquiryCommonModel = null;
+ if (null == _eC_OrderPrintParameter)
+ {
+ _inquiryCommonModel = new InquiryCommonModel();
+ }
+ else
+ {
+ _inquiryCommonModel = SerializationHelper.DeSerialize(typeof(InquiryCommonModel), _eC_OrderPrintParameter.PrintParameter) as InquiryCommonModel;
}
- Pagination pa = new Pagination();
- pa.PageSize = UCPager1.AspNetPager.PageSize;
- pa.PageIndex = UCPager1.AspNetPager.CurrentPageIndex;
+ var inquiryWorkBookModels = _inquiryCommonModel.InquiryWorkBookList.OrderBy(x => x.WorkBookSizeTxt).ThenBy(x => x.WorkBookNameTxt);
- var coreDeliverOrders = _CoreDeliverOrderBLL.SelectModelPage(pa, CurrentUser.MemberId, this.selDriver.Value.ToInt32(),this.txtXuexiao.Value.Trim(),this.txtBuyerName.Value.Trim(), this.txtBeginDate.Value.Trim(), this.txtEndDate.Value.Trim()); ;
+ if (string.IsNullOrEmpty(biaotou))
+ {
+ string biaotou2 = "<th style=\"text-align:center\" > </th> <th style=\"text-align:center\" > </th><th style=\"text-align:center\" > </th> <th style=\"text-align:center\" > </th> <th style=\"text-align:center\" > </th>";
+ foreach (var inquiryWorkBookModel in inquiryWorkBookModels)
+ {
+ biaotou += " <th style=\"text-align:center\" > " + inquiryWorkBookModel.WorkBookSizeTxt + inquiryWorkBookModel.WorkBookNameTxt + " </th> ";
+ biaotou2 += " <th style=\"text-align:center\" > 鏈�� </th> ";
+
+
+ }
+ biaotou += "<th style=\"text-align:center\" > 鎿嶄綔</th></tr><tr>" + biaotou2+ "<th style=\"text-align:center\" > </th>";
+ }
+ var ids = coreDeliverOrders.Select(x => x.OrderId).ToArray();
+
+ var coreCmsPlanOrders = bll_CoreCmsPlanOrderBLL.GetModelByorderid(this.selBuyerName.Value.Trim().ToInt32().Value).Where(x=> ids.Contains(x.id));
+ var cmsPlanOrderItems = bll_CoreCmsPlanOrderItemBLL.GetModelsByZongOrderid(this.selBuyerName.Value.Trim().ToInt32().Value).Where(x => ids.Contains(x.orderId));
+ var coreDeliverOrderItems = bll_CoreCmsPlanOrderItemBLL.GetDeliverModelsByZongOrderid(this.selBuyerName.Value.Trim().ToInt32().Value).Where(x => ids.Contains(x.PlanOrderId));
+
+
foreach (var coreDeliverOrder in coreDeliverOrders)
{
if (coreDeliverOrder.DriverId.HasValue)
@@ -90,12 +146,100 @@
coreDeliverOrder.DriverName = coreDeliverOrder.DeliveryMoble;
}
}
-
+
+
+ var cmsPlanOrderItems1 = cmsPlanOrderItems.Where(x => x.orderId == coreDeliverOrder.OrderId);
+ foreach (var inquiryWorkBookModel in inquiryWorkBookModels)
+ {
+ string biaoge = "";
+ var cmsPlanOrderItem = cmsPlanOrderItems1.Where(x => x.name == inquiryWorkBookModel.WorkBookNameTxt && x.specification == inquiryWorkBookModel.WorkBookSizeTxt).FirstOrDefault();
+ if (cmsPlanOrderItem != null)
+ {
+ var coreDeliverOrderItems1 = coreDeliverOrderItems.Where(x => x.PlanOrderId == coreDeliverOrder.OrderId && x.ZYBName == inquiryWorkBookModel.WorkBookNameTxt && x.ZYBSpecification == inquiryWorkBookModel.WorkBookSizeTxt);
+
+ var Number = coreDeliverOrderItems1.Sum(x => x.Number);
+ var LessNumber = coreDeliverOrderItems1.Sum(x => x.LessNumber);
+
+ if (cmsPlanOrderItem.nums > 0)
+ {
+ if (cmsPlanOrderItem.nums - LessNumber - Number > 0)
+ {
+ if (LessNumber + Number > 0)
+ {
+ biaoge += " <td style=\"text-align:center\"> <span style=\"color:#ff69b4;\" >" + (cmsPlanOrderItem.nums - LessNumber - Number) + " </span></td>";
+ }
+ else
+ {
+ biaoge += " <td style=\"text-align:center\"> <span style=\"color:red;\" >" + (cmsPlanOrderItem.nums - LessNumber - Number) + " </span></td>";
+ }
+
+ }
+ else
+ {
+ biaoge += " <td style=\"text-align:center\"> <span style=\"color:green;\" >" + (cmsPlanOrderItem.nums - LessNumber - Number) + " </span></td>";
+ }
+ }
+ else
+ {
+ biaoge += " <td style=\"text-align:center\"> <span style=\"color:green;\" ></span></td> ";
+ }
+
+
+
+ }
+ else
+ {
+ biaoge += " <td style=\"text-align:center\"> </td> <td style=\"text-align:center\"> <span style=\"color:green;\" ></span></td> ";
+ }
+
+
+
+ coreDeliverOrder.biaoge += biaoge;
+
+
+
+
+ }
+
+
+
}
+
+
+ biaowei = " <td></td> <td></td> <td style=\"text-align:center\"> </td> <td style=\"color: grey;text-align: center;\" > " + coreDeliverOrders.Count() + " </td><td style=\"text-align:center\"> </td> ";
+ foreach (var inquiryWorkBookModel in inquiryWorkBookModels)
+ {
+ var nums = cmsPlanOrderItems.Where(x => x.name == inquiryWorkBookModel.WorkBookNameTxt && x.specification == inquiryWorkBookModel.WorkBookSizeTxt && ids.Contains(x.orderId)).Sum(x => x.nums);
+
+ var coreDeliverOrderItems1 = coreDeliverOrderItems.Where(x => x.ZYBName == inquiryWorkBookModel.WorkBookNameTxt && x.ZYBSpecification == inquiryWorkBookModel.WorkBookSizeTxt && ids.Contains(x.PlanOrderId));
+
+ var Number = coreDeliverOrderItems1.Sum(x => x.Number);
+ var LessNumber = coreDeliverOrderItems1.Sum(x => x.LessNumber);
+ if ((nums - LessNumber - Number) > 0)
+ {
+ if (LessNumber + Number > 0)
+ {
+ biaowei += " <td style=\"text-align:center\"> <span style=\"color:#ff69b4;\" >" + (nums - LessNumber - Number) + " </span></td>";
+ }
+ else
+ {
+ biaowei += " <td style=\"text-align:center\"> <span style=\"color:red;\" >" + (nums - LessNumber - Number) + " </span></td>";
+ }
+
+ }
+ else
+ {
+ biaowei += " <td style=\"text-align:center\"> <span style=\"color:green;\" >" + (nums - LessNumber - Number) + " </span></td>";
+ }
+
+
+
+ }
+ biaowei += " <td></td>";
this.RepClientList.DataSource = coreDeliverOrders;
this.RepClientList.DataBind();
- UCPager1.AspNetPager.RecordCount = pa.RecordCount;
+ //UCPager1.AspNetPager.RecordCount = pa.RecordCount;
}
//鍒嗛〉浜嬩欢
--
Gitblit v1.9.1