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 DeliverWorkBookfahuoqingkuang : BasePage
|
{
|
CoreCmsPlanOrderBLL bll_CoreCmsPlanOrderBLL = null;
|
// CoreCmsPlanOrderItemBLL bll_CoreCmsPlanOrderItemBLL = null;
|
EC_OrderPrintParameterBLL _eC_OrderPrintParameterBLL = null;
|
CoreCmsPlanOrderFahuoBLL bll_coreCmsPlanOrderFahuoBLL = null;
|
EC_OrderBasicBLL _eC_OrderBasicBLL = null;
|
public string biaotou = "";
|
public string biaowei = "";
|
|
|
//初始化
|
public DeliverWorkBookfahuoqingkuang()
|
{
|
bll_CoreCmsPlanOrderBLL = new CoreCmsPlanOrderBLL();
|
// bll_CoreCmsPlanOrderItemBLL = new CoreCmsPlanOrderItemBLL();
|
_eC_OrderPrintParameterBLL = new EC_OrderPrintParameterBLL();
|
bll_coreCmsPlanOrderFahuoBLL = new CoreCmsPlanOrderFahuoBLL();
|
_eC_OrderBasicBLL = new EC_OrderBasicBLL();
|
}
|
|
//页面加载
|
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 coreCmsPlanOrderFahuosssssss = bll_coreCmsPlanOrderFahuoBLL.GetModelsByOrderid(orderIdStr.ToInt32().Value);
|
|
|
var coreCmsPlanOrderFahuos = bll_coreCmsPlanOrderFahuoBLL.GetModelsByOrderid(orderIdStr.ToInt32().Value);
|
var BeginDate = this.txtBeginDate.Value.Trim();
|
if (!string.IsNullOrEmpty(BeginDate))
|
{
|
var sss = BeginDate.ToDateTime2().Value;
|
coreCmsPlanOrderFahuos = coreCmsPlanOrderFahuos.Where(x => x.createTime >= sss);
|
}
|
var EndDate = this.txtEndDate.Value.Trim();
|
if (!string.IsNullOrEmpty(EndDate))
|
{
|
var sss = EndDate.ToDateTime2().Value.AddDays(1);
|
coreCmsPlanOrderFahuos = coreCmsPlanOrderFahuos.Where(x => x.createTime <= sss);
|
coreCmsPlanOrderFahuosssssss = coreCmsPlanOrderFahuosssssss.Where(x => x.createTime <= sss );
|
}
|
|
|
var corname = "";
|
|
var eC_OrderBasic = _eC_OrderBasicBLL.SelectModelById(orderIdStr.ToInt32().Value);
|
if (eC_OrderBasic != null)
|
{
|
corname = eC_OrderBasic.BuyerName;
|
}
|
|
|
|
|
|
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.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\" >"+ corname + " </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 +="</tr><tr>"+ biaotou2+ "</tr>";
|
}
|
biaowei = " <td style=\"text-align:center\"> 合计 </td><td style=\"text-align:center\"> </td> <td style=\"text-align:center\"> " + corname + " </td> ";
|
|
foreach (var inquiryWorkBookModel in inquiryWorkBookModels)
|
{
|
var nums = coreCmsPlanOrderFahuos.Where(x => x.name == inquiryWorkBookModel.WorkBookNameTxt && x.specification == inquiryWorkBookModel.WorkBookSizeTxt).Sum(x => x.nums);
|
var numsyifa = coreCmsPlanOrderFahuosssssss.Where(x => x.name == inquiryWorkBookModel.WorkBookNameTxt && x.specification == inquiryWorkBookModel.WorkBookSizeTxt).Sum(x => x.nums);
|
|
var ssss = 0;
|
|
int.TryParse(inquiryWorkBookModel.WorkBookCount, out ssss);
|
|
biaowei += " <td style=\"text-align:center\"> " + nums + " </td> <td style=\"text-align:center\"> <span style=\"color:red;\" >" + (ssss - numsyifa) + " </span></td>";
|
|
}
|
|
|
|
|
var cmsPlanOrderFahuos = coreCmsPlanOrderFahuos.GroupBy(p => new { p.createTime.Value }).Select(g => new CoreCmsPlanOrderFahuo
|
{
|
// 分组字段
|
createTime = g.Key.Value,
|
|
}).OrderByDescending(x=>x.createTime).ToList();
|
|
foreach (var cmsPlanOrderFahuo in cmsPlanOrderFahuos)
|
{
|
|
cmsPlanOrderFahuo.name = corname;
|
|
var cmsPlanOrderFahuos1 = coreCmsPlanOrderFahuos.Where(x => x.createTime.Value == cmsPlanOrderFahuo.createTime);
|
foreach (var inquiryWorkBookModel in inquiryWorkBookModels)
|
{
|
var nums = cmsPlanOrderFahuos1.Where(x => x.name == inquiryWorkBookModel.WorkBookNameTxt && x.specification == inquiryWorkBookModel.WorkBookSizeTxt).Sum(x=>x.nums);
|
var numsyifa = coreCmsPlanOrderFahuosssssss.Where(x => x.name == inquiryWorkBookModel.WorkBookNameTxt && x.specification == inquiryWorkBookModel.WorkBookSizeTxt && x.createTime.Value <= cmsPlanOrderFahuo.createTime).Sum(x => x.nums);
|
var ssss = 0;
|
|
int.TryParse(inquiryWorkBookModel.WorkBookCount, out ssss);
|
cmsPlanOrderFahuo.biaoge += " <td style=\"text-align:center\"> " + nums + " </td> <td style=\"text-align:center\"> <span style=\"color:red;\" >" + (ssss - numsyifa) + " </span></td>";
|
|
//if (cmsPlanOrderItem != null)
|
//{
|
// var coreDeliverOrderItems1 = coreDeliverOrderItems.Where(x =>x.PlanOrderId == coreCmsPlanOrder.id && x.ZYBName == inquiryWorkBookModel.WorkBookNameTxt && x.ZYBSpecification == inquiryWorkBookModel.WorkBookSizeTxt);
|
|
// var Number = coreDeliverOrderItems1.Sum(x => x.Number);
|
// var LessNumber = coreDeliverOrderItems1.Sum(x => x.LessNumber);
|
|
|
//}
|
//else
|
//{
|
// coreCmsPlanOrder.biaoge += " <td style=\"text-align:center\"> 0 </td> <td style=\"text-align:center\"> <span style=\"color:red;\" >0</span></td> ";
|
//}
|
|
}
|
|
}
|
|
|
|
|
this.RepClientList.DataSource = cmsPlanOrderFahuos;
|
this.RepClientList.DataBind();
|
|
}
|
|
|
//查询事件
|
protected void btn_Search_Click(object src, EventArgs e)
|
{
|
BindList();
|
}
|
}
|
}
|
