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;
|
using CY.Infrastructure.Cache;
|
|
namespace CY.WebForm.Pages.business
|
{
|
//吴辉
|
//行政管理
|
public partial class DeliverWorkBookLiShiAnPaiList : BasePage
|
{
|
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()
|
{
|
|
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;
|
if (!IsPostBack)
|
{
|
this.selDriver.DataSource = bll_OA_StaffBLL.SelectListByFirmId(CurrentUser.MemberId, false, false).Where(x => x.SM_Post == "司机"); ;
|
this.selDriver.DataTextField = "Name";
|
this.selDriver.DataValueField = "Keyid";
|
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(string shifou="")
|
{
|
|
//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)
|
{
|
var oA_Staff = bll_OA_StaffBLL.GetModelByKeyid(coreDeliverOrder.DriverId);
|
if (oA_Staff != null)
|
{
|
coreDeliverOrder.DriverName = oA_Staff.Name;
|
}
|
}
|
else
|
{
|
var oA_Staff1 = bll_OA_StaffBLL.SelectListByFirmId(CurrentUser.MemberId, false, false).Where(x => x.MobieNum == coreDeliverOrder.DeliveryMoble).FirstOrDefault();
|
if (oA_Staff1 != null)
|
{
|
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;
|
}
|
|
//分页事件
|
protected void AspNetPager1_PageChanged(object src, EventArgs e)
|
{
|
BindList();
|
}
|
|
//查询事件
|
protected void btn_Search_Click(object src, EventArgs e)
|
{
|
BindList();
|
}
|
}
|
}
|
