| | |
| | | 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(); |
| | |
| | | { |
| | | var sss = EndDate.ToDateTime2().Value.AddDays(1); |
| | | coreCmsPlanOrderFahuos = coreCmsPlanOrderFahuos.Where(x => x.createTime <= sss); |
| | | coreCmsPlanOrderFahuosssssss = coreCmsPlanOrderFahuosssssss.Where(x => x.createTime <= sss ); |
| | | } |
| | | |
| | | |
| | |
| | | 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 - nums) + " </span></td>"; |
| | | 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.Date }).Select(g => new CoreCmsPlanOrderFahuo |
| | | var cmsPlanOrderFahuos = coreCmsPlanOrderFahuos.GroupBy(p => new { p.createTime.Value }).Select(g => new CoreCmsPlanOrderFahuo |
| | | { |
| | | // 分组字段 |
| | | createTime = g.Key.Date, |
| | | createTime = g.Key.Value, |
| | | |
| | | }).OrderByDescending(x=>x.createTime).ToList(); |
| | | |
| | |
| | | |
| | | cmsPlanOrderFahuo.name = corname; |
| | | |
| | | var cmsPlanOrderFahuos1 = coreCmsPlanOrderFahuos.Where(x => x.createTime.Value.Date == cmsPlanOrderFahuo.createTime); |
| | | 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 - nums) + " </span></td>"; |
| | | 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) |
| | | //{ |