| CY_ECommercePlatform/CY.WebForm/CY.WebForm.csproj | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| CY_ECommercePlatform/CY.WebForm/Pages/business/DeliverWorkBookAnPaiDetailsongdao.aspx | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| CY_ECommercePlatform/CY.WebForm/Pages/business/DeliverWorkBookAnPaiDetailsongdao.aspx.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| CY_ECommercePlatform/CY.WebForm/Pages/business/DeliverWorkBookAnPaiDetailsongdao.aspx.designer.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| CY_ECommercePlatform/CY.WebForm/Pages/business/DeliverWorkBookLiShiAnPaiList.aspx | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
CY_ECommercePlatform/CY.WebForm/CY.WebForm.csproj
@@ -1889,6 +1889,7 @@ <Content Include="Pages\business\Baozhengjinfukuan.aspx" /> <Content Include="Pages\business\BaozhengjinCuishou.aspx" /> <Content Include="Pages\business\DeliverPlanDakaList.aspx" /> <Content Include="Pages\business\DeliverWorkBookAnPaiDetailsongdao.aspx" /> <Content Include="Pages\business\DeliverWorkBookAnPaiEdit.aspx" /> <Content Include="Pages\business\DeliverWorkBookAnPai.aspx" /> <Content Include="Pages\business\DeliverPlanWentiOrder.aspx" /> @@ -3414,6 +3415,13 @@ <Compile Include="Pages\business\DeliverPlanDakaList.aspx.designer.cs"> <DependentUpon>DeliverPlanDakaList.aspx</DependentUpon> </Compile> <Compile Include="Pages\business\DeliverWorkBookAnPaiDetailsongdao.aspx.cs"> <DependentUpon>DeliverWorkBookAnPaiDetailsongdao.aspx</DependentUpon> <SubType>ASPXCodeBehind</SubType> </Compile> <Compile Include="Pages\business\DeliverWorkBookAnPaiDetailsongdao.aspx.designer.cs"> <DependentUpon>DeliverWorkBookAnPaiDetailsongdao.aspx</DependentUpon> </Compile> <Compile Include="Pages\business\DeliverWorkBookAnPaiEdit.aspx.cs"> <DependentUpon>DeliverWorkBookAnPaiEdit.aspx</DependentUpon> <SubType>ASPXCodeBehind</SubType> CY_ECommercePlatform/CY.WebForm/Pages/business/DeliverWorkBookAnPaiDetailsongdao.aspx
New file @@ -0,0 +1,231 @@ <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="DeliverWorkBookAnPaiDetailsongdao.aspx.cs" Inherits="CY.WebForm.Pages.business.DeliverWorkBookAnPaiDetailsongdao" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head id="Head1" runat="server"> <title>车辆管理</title> <uc:CMSHead ID="CMSHead1" runat="server" /> <script type="text/javascript"> //违章 function onViewCarViolation(keyid) { top.Dialog.open({ URL: "/Pages/business/CarViolationList.aspx?carid=" + keyid, Title: "违章管理", Width: 1000, Height: 660 }); } //保养 function onViewCarMaintenance(keyid) { top.Dialog.open({ URL: "/Pages/business/CarMaintenanceList.aspx?carid=" + keyid, Title: "保养管理", Width: 1000, Height: 660 }); } //维修 function onViewCarrepair(keyid) { top.Dialog.open({ URL: "/Pages/business/CarrepairList.aspx?carid=" + keyid, Title: "维修管理", Width: 1000, Height: 660 }); } //年检 function onViewCarExamined(keyid) { top.Dialog.open({ URL: "/Pages/business/CarExaminedList.aspx?carid=" + keyid, Title: "年检管理", Width: 1000, Height: 660 }); } //保险 function onViewCarInsurance(keyid) { top.Dialog.open({ URL: "/Pages/business/CarInsuranceList.aspx?carid=" + keyid, Title: "保险管理", Width: 1000, Height: 660 }); } //修改 function onEdit(keyid) { top.Dialog.open({ URL: "/Pages/business/CarManageAdd.aspx?keyid=" + keyid, Title: "车辆信息", Width: 1000, Height: 660 }); } //添加 function addModel() { top.Dialog.open({ URL: "/Pages/business/CarManageAdd.aspx", Title: "新增车辆", Width: 1000, Height: 660}); } //删除 function onDele(keyid) { top.Dialog.confirm("确定要删除该记录吗？", function () { window.location = "/Pages/business/DeliverWorkBookAnPaiDetailsongdao.aspx?delete=" + keyid; }); } //批量删除 function onAllDelete() { var deleteKeyIds = ""; $(":checkbox").each( function () { if ($(this).is(":checked")) { deleteKeyIds += $(this).val() + ","; } } ) if (deleteKeyIds == "") { top.Dialog.alert("请选择要删除的记录", function () { }); return; } else { deleteKeyIds = deleteKeyIds.substring(0, deleteKeyIds.length - 1); top.Dialog.confirm("确定要删除所选记录吗？", function () { window.location = "/Pages/business/DeliverWorkBookAnPaiDetailsongdao.aspx?deleteKeyIds=" + deleteKeyIds; }); } } $(function () { $(".AlreadyReply").remove(); }); </script> <style type="text/css"> .AlreadyReply { display: none; } </style> </head> <body> <form id="form1" runat="server"> <div id="scrollContent"> <div class="box1" paneltitle="功能面板" roller="false"> <table class="TableNewStyle"> <tr> <td class="ali03"> 片区： </td> <td> <span id="spanpianqu" runat="server" ></span> </td> <td class="ali03"> 学校： </td> <td> <span id="spanxuexiao" runat="server" ></span> </td> </tr> <tr> <td class="ali03"> 收货地址： </td> <td> <span id="spanDizhi" runat="server" ></span> </td> <td class="ali03"> 联系人： </td> <td> <span id="spanLianxiren" runat="server" ></span> </td> </tr> <tr> <td class="ali03"> 联系电话： </td> <td> <span id="spanDianhua" runat="server" ></span> </td> <td class="ali03"> 送货时间： </td> <td> <span id="spanShijian" runat="server" ></span> </td> </tr> <tr> <td class="ali03"> 状态： </td> <td> <span id="spanZhuangtai" runat="server" ></span> </td> <td class="ali03"> </td> <td> </td> </tr> </table> </div> <div> <table class="tableStyle"> <tr> <th style="text-align: center"> 品种 </th> <th style="text-align: center"> 征订数量 </th> <th style="text-align: center"> 未送数量 </th> <%=biaotou %> <%-- <th style="text-align: center"> 本次送货数量 </th> <th style="text-align: center"> 本次节约数量 </th>--%> </tr> <tr> <%=biaowei %> <%-- <td style="text-align: center" > <%#Eval("ZYBSpecification")%> <%#Eval("ZYBName")%> </td> <td style="text-align: center" > <%#Eval("DingdanNumber")%> </td> <td style="text-align: center" > <%#Eval("WeisongNumber")%> </td> <td style="text-align: center" > <%#Eval("Number")%> </td> <td style="text-align: center" > <%#Eval("LessNumber")%> </td>--%> </tr> </table> </div> </div> </form> </body> </html> CY_ECommercePlatform/CY.WebForm/Pages/business/DeliverWorkBookAnPaiDetailsongdao.aspx.cs
New file @@ -0,0 +1,197 @@ 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 DeliverWorkBookAnPaiDetailsongdao : BasePage { CoreCmsPlanOrderBLL _CoreCmsPlanOrderBLL = null; CoreCmsPlanOrderItemBLL _CoreCmsPlanOrderItemBLL = null; OA_StaffBLL bll_OA_StaffBLL = null; OA_CarManageBll _OA_CarManageBll = null; CoreDeliverOrderBLL _CoreDeliverOrderBLL = null; CoreDeliverOrderItemBLL _CoreDeliverOrderItemBLL = null; public string biaotou = ""; public string biaowei = ""; //初始化 public DeliverWorkBookAnPaiDetailsongdao() { _CoreCmsPlanOrderBLL = new CoreCmsPlanOrderBLL(); bll_OA_StaffBLL = new OA_StaffBLL(); _OA_CarManageBll = new OA_CarManageBll(); _CoreDeliverOrderBLL = new CoreDeliverOrderBLL(); _CoreDeliverOrderItemBLL = new CoreDeliverOrderItemBLL(); _CoreCmsPlanOrderItemBLL = new CoreCmsPlanOrderItemBLL(); } //页面加载 protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { BindList(); } } //绑定数据 private void BindList() { string orderIdStr = Request["orderId"]; var coreDeliverOrder = _CoreDeliverOrderBLL.GetModelByKeyid(orderIdStr); var coreCmsPlanOrder = _CoreCmsPlanOrderBLL.GetModelByKeyid(coreDeliverOrder.OrderId.Value); var cmsPlanOrderItems = _CoreCmsPlanOrderItemBLL.GetModelsByOrderid(coreDeliverOrder.OrderId.Value); var coreDeliverOrderItems = _CoreDeliverOrderItemBLL.GetModelsByOrderid(orderIdStr); //已经送货数量 var coreDeliverOrderItemssssss = _CoreCmsPlanOrderItemBLL.GetDeliverModelsByplanOrderids(coreCmsPlanOrder.orderkeyid.Value).Where(x=>x.PlanOrderId == coreCmsPlanOrder.id ).Where(x => x.OrderState == 2).OrderByDescending(x=>x.MakeTime); var coreDeliverOrderItemssonghuo = coreDeliverOrderItemssssss.Where(x => x.OrderState == 2); //送货数量统计 var coreDeliverOrderItemsgroup = coreDeliverOrderItemssonghuo.GroupBy(p => new { p.ZYBName, p.ZYBSpecification }) // 多个字段作为匿名类型分组键 .Select(g => new CoreDeliverOrderItem { // 分组字段 ZYBName = g.Key.ZYBName, ZYBSpecification = g.Key.ZYBSpecification, // 统计结果 //Count = g.Count(), // 每组人数 //AverageSalary = g.Average(p => p.Salary), // 平均工资 Number = g.Sum(p => p.Number), // 工资总和 LessNumber = g.Sum(p => p.LessNumber) }).ToList(); this.spanpianqu.InnerText = coreCmsPlanOrder.pianqu; this.spanxuexiao.InnerText = coreCmsPlanOrder.shipAddress; this.spanDizhi.InnerText = coreCmsPlanOrder.shouhuoAddress; this.spanLianxiren.InnerText = coreCmsPlanOrder.shipName; this.spanDianhua.InnerText = coreCmsPlanOrder.shipMobile; this.spanShijian.InnerText = coreDeliverOrder.MakeTime.Value.ToString("yyyy-MM-dd HH:mm:ss"); this.spanZhuangtai.InnerText = coreDeliverOrder.OrderStateName; //送货数量统计 var coreDeliverOrderItemssssssgroup = coreDeliverOrderItemssssss.GroupBy(p => new {p.MakeTime }) // 多个字段作为匿名类型分组键 .Select(g => new CoreDeliverOrderItem { // 分组字段 MakeTime = g.Key.MakeTime }).OrderByDescending(x=>x.MakeTime).ToList(); string biaotou2 = ""; foreach (var coreDeliverOrderItem1 in coreDeliverOrderItemssssssgroup) { biaotou += "<th style=\"text-align:center\" > "+ coreDeliverOrderItem1.MakeTime.Value.ToString("yyyy-MM-dd") + " </th>"; biaotou2 += "<th style=\"text-align:center\" > 节约（" + coreDeliverOrderItem1.MakeTime.Value.ToString("MM月dd日") + " ）</th>"; } biaotou += biaotou2; //送货数量统计 var coreDeliverOrderItemssssssgroupxiangxi = coreDeliverOrderItemssssss.GroupBy(p => new { p.MakeTime, p.ZYBName, p.ZYBSpecification }) // 多个字段作为匿名类型分组键 .Select(g => new CoreDeliverOrderItem { // 分组字段 MakeTime = g.Key.MakeTime, // 分组字段 ZYBName = g.Key.ZYBName, ZYBSpecification = g.Key.ZYBSpecification, // 统计结果 //Count = g.Count(), // 每组人数 //AverageSalary = g.Average(p => p.Salary), // 平均工资 Number = g.Sum(p => p.Number), // 工资总和 LessNumber = g.Sum(p => p.LessNumber) }).OrderByDescending(x => x.MakeTime).ToList(); foreach (var coreDeliverOrderItem in coreDeliverOrderItems) { var deliverOrderItem = coreDeliverOrderItemsgroup.Where(x => x.ZYBName == coreDeliverOrderItem.ZYBName && x.ZYBSpecification == coreDeliverOrderItem.ZYBSpecification).FirstOrDefault(); var cmsPlanOrderItem = cmsPlanOrderItems.Where(x => x.name == coreDeliverOrderItem.ZYBName && x.specification == coreDeliverOrderItem.ZYBSpecification).FirstOrDefault(); if (cmsPlanOrderItem != null) { coreDeliverOrderItem.DingdanNumber = cmsPlanOrderItem.nums; if (deliverOrderItem != null) { var weisong = cmsPlanOrderItem.nums - (deliverOrderItem.Number + deliverOrderItem.LessNumber); coreDeliverOrderItem.WeisongNumber = (weisong > 0 ? weisong : 0); } else { coreDeliverOrderItem.WeisongNumber = cmsPlanOrderItem.nums ; } } biaowei += "<tr>"; biaowei += " <td style=\"text-align: center;\" > " + coreDeliverOrderItem.ZYBSpecification + coreDeliverOrderItem.ZYBName + " </td> "; biaowei += " <td style=\"text-align: center;\" > " + coreDeliverOrderItem.DingdanNumber + " </td> "; biaowei += " <td style=\"text-align: center;\" > " + coreDeliverOrderItem.WeisongNumber + " </td> "; string biaowei2 = ""; foreach (var coreDeliverOrderItem1 in coreDeliverOrderItemssssssgroup) { var deliverOrderItemaaaaaaaa = coreDeliverOrderItemssssssgroupxiangxi.Where(x => x.ZYBName == coreDeliverOrderItem.ZYBName && x.ZYBSpecification == coreDeliverOrderItem.ZYBSpecification && x.MakeTime == coreDeliverOrderItem1.MakeTime).FirstOrDefault(); biaowei += " <td style=\"text-align: center;\" > " + deliverOrderItemaaaaaaaa.Number + " </td> "; biaowei2 += " <td style=\"text-align: center;\" > " + deliverOrderItemaaaaaaaa.LessNumber + " </td> "; } biaowei += biaowei2; biaowei += "</tr>"; } } } } CY_ECommercePlatform/CY.WebForm/Pages/business/DeliverWorkBookAnPaiDetailsongdao.aspx.designer.cs
New file @@ -0,0 +1,107 @@ //------------------------------------------------------------------------------ // <自动生成> // 此代码由工具生成。 // // 对此文件的更改可能导致不正确的行为，如果 // 重新生成代码，则所做更改将丢失。 // </自动生成> //------------------------------------------------------------------------------ namespace CY.WebForm.Pages.business { public partial class DeliverWorkBookAnPaiDetailsongdao { /// <summary> /// Head1 控件。 /// </summary> /// <remarks> /// 自动生成的字段。 /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。 /// </remarks> protected global::System.Web.UI.HtmlControls.HtmlHead Head1; /// <summary> /// CMSHead1 控件。 /// </summary> /// <remarks> /// 自动生成的字段。 /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。 /// </remarks> protected global::CY.WebForm.Pages.common.CMSHead CMSHead1; /// <summary> /// form1 控件。 /// </summary> /// <remarks> /// 自动生成的字段。 /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。 /// </remarks> protected global::System.Web.UI.HtmlControls.HtmlForm form1; /// <summary> /// spanpianqu 控件。 /// </summary> /// <remarks> /// 自动生成的字段。 /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。 /// </remarks> protected global::System.Web.UI.HtmlControls.HtmlGenericControl spanpianqu; /// <summary> /// spanxuexiao 控件。 /// </summary> /// <remarks> /// 自动生成的字段。 /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。 /// </remarks> protected global::System.Web.UI.HtmlControls.HtmlGenericControl spanxuexiao; /// <summary> /// spanDizhi 控件。 /// </summary> /// <remarks> /// 自动生成的字段。 /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。 /// </remarks> protected global::System.Web.UI.HtmlControls.HtmlGenericControl spanDizhi; /// <summary> /// spanLianxiren 控件。 /// </summary> /// <remarks> /// 自动生成的字段。 /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。 /// </remarks> protected global::System.Web.UI.HtmlControls.HtmlGenericControl spanLianxiren; /// <summary> /// spanDianhua 控件。 /// </summary> /// <remarks> /// 自动生成的字段。 /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。 /// </remarks> protected global::System.Web.UI.HtmlControls.HtmlGenericControl spanDianhua; /// <summary> /// spanShijian 控件。 /// </summary> /// <remarks> /// 自动生成的字段。 /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。 /// </remarks> protected global::System.Web.UI.HtmlControls.HtmlGenericControl spanShijian; /// <summary> /// spanZhuangtai 控件。 /// </summary> /// <remarks> /// 自动生成的字段。 /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。 /// </remarks> protected global::System.Web.UI.HtmlControls.HtmlGenericControl spanZhuangtai; } } CY_ECommercePlatform/CY.WebForm/Pages/business/DeliverWorkBookLiShiAnPaiList.aspx
@@ -30,7 +30,7 @@ //查看明细 function onViewCarInsurance(keyid) { top.Dialog.open({ URL: "/Pages/business/DeliverWorkBookAnPaiDetail.aspx?orderId=" + keyid, Title: "查看明细", Width: 1500, Height: 900 }); top.Dialog.open({ URL: "/Pages/business/DeliverWorkBookAnPaiDetailsongdao.aspx?orderId=" + keyid, Title: "查看明细", Width: 1500, Height: 900 }); } //保险 function onViewfahuo(keyid) {
