20251217 逾期款项列表的“未收款金额”下面加个合计

username@email.com

2 小时以前 711fc30d62069784f461426d8c00a30dfd54e1a9

 CY_ECommercePlatform/CY.WebForm/Pages/business/DeliverWorkBookLiShiAnPaiList.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
{
@@ -20,6 +21,16 @@
    {
        CoreDeliverOrderBLL _CoreDeliverOrderBLL = null;
        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 DeliverWorkBookLiShiAnPaiList()
@@ -27,12 +38,19 @@
            
            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 == "司机"); ;
@@ -41,23 +59,74 @@
                this.selDriver.DataBind();
                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.txtEndDate.Value = DateTime.Now.ToString("yyyy-MM-dd");
                var stringBuyerName = CACHE.RetrieveObject(CurrentUser.TrueMemberId+ "BuyerName") as string;//从缓存中获取数据访问实现层程序集
                if (null != stringBuyerName)
                {
                    this.selBuyerName.Value = stringBuyerName;
                }
                BindList();
            }
             
        }

        //绑定数据
        private void BindList()
        private void BindList(string shifou="")
        {
            Pagination pa = new Pagination();
            pa.PageSize = UCPager1.AspNetPager.PageSize;
            pa.PageIndex = UCPager1.AspNetPager.CurrentPageIndex;

            var coreDeliverOrders = _CoreDeliverOrderBLL.SelectModelPageLishi(pa, CurrentUser.MemberId, this.selDriver.Value.ToInt32(),this.txtXuexiao.Value.Trim(),this.txtBuyerName.Value.Trim(), this.txtBeginDate.Value.Trim(), this.txtEndDate.Value.Trim(),this.selOrderState.Value); 
            //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.SelectModelPageLishi(pa, CurrentUser.MemberId, this.selDriver.Value.ToInt32(),this.txtXuexiao.Value.Trim(),this.selBuyerName.Value.Trim(), this.txtBeginDate.Value.Trim(), this.txtEndDate.Value.Trim(),this.selOrderState.Value, shifou);

            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;

            }
            var inquiryWorkBookModels = _inquiryCommonModel.InquiryWorkBookList.OrderBy(x => x.WorkBookSizeTxt).ThenBy(x => x.WorkBookNameTxt);

            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> <th style=\"text-align:center\" >  </th>";
                foreach (var inquiryWorkBookModel in inquiryWorkBookModels)
                {
                    biaotou += " <th style=\"text-align:center\" colspan=\"2\"> " + inquiryWorkBookModel.WorkBookSizeTxt + inquiryWorkBookModel.WorkBookNameTxt + " </th> ";
                    biaotou2 += " <th style=\"text-align:center\" > 已送 </th> <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)
@@ -75,13 +144,104 @@
                    {
                        coreDeliverOrder.DriverName = oA_Staff1.Name;
                    }
                    else
                    {
                        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=\"color: grey;text-align: center;\" > " + Number + " </td>  <td style=\"text-align:center\">  <span style=\"color:#ff69b4;\" >" + (cmsPlanOrderItem.nums - LessNumber - Number) + " </span></td>";
                                }
                                else
                                {
                                    biaoge += " <td style=\"color: grey;text-align: center;\" > " + Number + " </td> <td style=\"text-align:center\"> <span style=\"color:red;\" >" + (cmsPlanOrderItem.nums - LessNumber - Number) + " </span></td>";
                                }

                            }
                            else
                            {
                                biaoge += " <td style=\"color: grey;text-align: center;\" > " + Number + " </td> <td style=\"text-align:center\"> <span style=\"color:green;\" >" + (cmsPlanOrderItem.nums - LessNumber - Number) + " </span></td>";
                            }
                        }
                        else
                        {
                            biaoge += " <td style=\"text-align:center\">  </td> <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></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=\"color: grey;text-align: center;\" > " + Number + " </td>  <td style=\"text-align:center\">  <span style=\"color:#ff69b4;\" >" + (nums - LessNumber - Number) + " </span></td>";
                    }
                    else
                    {
                        biaowei += " <td style=\"color: grey;text-align: center;\" > " + Number + " </td>  <td style=\"text-align:center\">  <span style=\"color:red;\" >" + (nums - LessNumber - Number) + " </span></td>";
                    }

                }
                else
                {
                    biaowei += " <td style=\"color: grey;text-align: center;\" > " + Number + " </td>  <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;
        }

        //分页事件