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();
        }
    }
}