using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using CY.BLL; using CY.BLL.Sys; using CY.Model; using CY.Infrastructure.Query; using CY.Infrastructure.Common; using CY.BLL.EC; using CY.Model.Inquiry; namespace CY.WebForm.Pages.business { //吴辉 //行政管理 public partial class DeliverWorkBookDetail : BasePage { CoreCmsPlanOrderBLL bll_CoreCmsPlanOrderBLL = null; CoreCmsPlanOrderItemBLL bll_CoreCmsPlanOrderItemBLL = null; EC_OrderPrintParameterBLL _eC_OrderPrintParameterBLL = null; public string biaotou = ""; public string biaowei = ""; //初始化 public DeliverWorkBookDetail() { bll_CoreCmsPlanOrderBLL = new CoreCmsPlanOrderBLL(); bll_CoreCmsPlanOrderItemBLL = new CoreCmsPlanOrderItemBLL(); _eC_OrderPrintParameterBLL = new EC_OrderPrintParameterBLL(); } //页面加载 protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { BindList(); } } //绑定数据 private void BindList() { string orderIdStr = Request["orderId"]; this.hideOrderId.Value = orderIdStr; var coreCmsPlanOrders = bll_CoreCmsPlanOrderBLL.GetModelByorderid(orderIdStr.ToInt32().Value); var pianqu = this.txtpianqu.Value.Trim(); if (!string.IsNullOrEmpty(pianqu)) { coreCmsPlanOrders = coreCmsPlanOrders.Where(x => x.pianqu.Contains(pianqu)); } var xuexiao = this.txtxuexiao.Value.Trim(); if (!string.IsNullOrEmpty(xuexiao)) { coreCmsPlanOrders = coreCmsPlanOrders.Where(x => x.shipAddress.Contains(xuexiao)); } var ids = coreCmsPlanOrders.Select(x => x.id).ToArray(); var cmsPlanOrderItems = bll_CoreCmsPlanOrderItemBLL.GetModelsByZongOrderid(orderIdStr.ToInt32().Value).Where(x=> ids.Contains( x.orderId)); EC_OrderPrintParameter _eC_OrderPrintParameter = _eC_OrderPrintParameterBLL.GetModel(orderIdStr.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.WorkBookNameTxt).ThenBy(x=>x.WorkBookSizeTxt); if (string.IsNullOrEmpty(biaotou)) { foreach (var inquiryWorkBookModel in inquiryWorkBookModels) { biaotou += " " + inquiryWorkBookModel.WorkBookSizeTxt + inquiryWorkBookModel.WorkBookNameTxt + " "; } } biaowei = " 合计 "; foreach (var inquiryWorkBookModel in inquiryWorkBookModels) { var nums = cmsPlanOrderItems.Where(x => x.name == inquiryWorkBookModel.WorkBookNameTxt && x.specification == inquiryWorkBookModel.WorkBookSizeTxt).Sum(x=>x.nums); biaowei += " " + nums + " "; } foreach(var coreCmsPlanOrder in coreCmsPlanOrders) { var cmsPlanOrderItems1 = cmsPlanOrderItems.Where(x => x.orderId == coreCmsPlanOrder.id); foreach (var inquiryWorkBookModel in inquiryWorkBookModels) { var cmsPlanOrderItem = cmsPlanOrderItems1.Where(x => x.name == inquiryWorkBookModel.WorkBookNameTxt && x.specification == inquiryWorkBookModel.WorkBookSizeTxt).FirstOrDefault(); if (cmsPlanOrderItem != null) { coreCmsPlanOrder.biaoge += " " + cmsPlanOrderItem.nums + " "; } else { coreCmsPlanOrder.biaoge += " 0 "; } } } this.RepClientList.DataSource = coreCmsPlanOrders; this.RepClientList.DataBind(); } //查询事件 protected void btn_Search_Click(object src, EventArgs e) { BindList(); } } }