设计订单增加查询统计项

username@email.com

2025-07-04 2b723d3abc356f9ce40b77156bcdf78b5ea5eb6b

设计订单增加查询统计项

 CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderBasicDAL.cs

@@ -3259,6 +3259,22 @@
                    }
                }

                /// <summary>
                /// 查询来源
                /// </summary>
                string fromss = "  EC_OrderBasic as ob Inner Join [EC_OrderExtend]  as oe On ob.Keyid=oe.Keyid   Left Join SysInquiry_PrintingType as pt On(ob.PrintTypeId=pt.Keyid) " +


                " where  " + condition;
                var ssss = _dataBase.SelectModel<Model.EC_OrderBasic>("  sum(oe.[ShejiSumPrice]) as ShejiSumPrice,sum(oe.ShejiSumPriceneiye) as ShejiSumPriceneiye  ", fromss);
                if (ssss.Count > 0)
                {
                    var aaaaa = ssss.First();
                    pagination.heji1 = (aaaaa.ShejiSumPrice + aaaaa.ShejiSumPriceneiye)??0;
                    
                }


                return _dataBase.SelectModelPage<Model.EC_OrderBasic>(pagination, " ob.*,oe.BusinessManagerId,oe.shifouDelivery,oe.IsPrintfengqian,oe.DeliveryOrderId,oe.KaipiaoshenqingCreater,oe.KaipiaoshenqingTime,oe.KaipiaoquerenCreater,oe.KaipiaoquerenTime,oe.Kehuqianshou,oe.KehuqianshouCreater,oe.KehuqianshouTime  ,oe.Quchudingdan,oe.QuchudingdanCreater,oe.QuchudingdanTime,oe.PrintPackDeliveryRequir,oe.PrintNum,oe.ExigencyCaseId,oe.Duiyinghetongbianhao,oe.[Shejirenyuan],oe.[Shejileixing] ,oe.[Danshuangmian],oe.[Shejirenyuanneiye],oe.[Shejileixingneiye],oe.[Danshuangmianneiye],oe.[Shejiyaoqiu],oe.[Shejiyaoqiuneiye],oe.[ShejirenyuanName],oe.[ShejirenyuanNameneiye],oe.[ShejiStatus],oe.[ShejileixingName],oe.[ShejileixingNameneiye],oe.[ShejiUnitPrice] ,oe.[ShejiSumPrice],oe.[ShejiUnitPriceneiye],oe.[ShejiSumPriceneiye] ,oe.[Shejicount],oe.[Shejicountneiye] ,pt.PrintName as PrintTypeName ", "  EC_OrderBasic as ob Inner Join [EC_OrderExtend]  as oe On ob.Keyid=oe.Keyid   Left Join SysInquiry_PrintingType as pt On(ob.PrintTypeId=pt.Keyid) ", " ob.CreateTime desc", " CreateTime desc ", condition);
            }
            catch (Exception ex)

 CY_ECommercePlatform/CY.WebForm/Pages/business/ShejiOrderList.aspx

@@ -553,6 +553,28 @@
                            </tr>
                        </itemtemplate>
                    </asp:repeater>
                     <tr class="StatisticsMoney">
                    <td colspan="11" class="ali03">
                        当前页统计：
                    </td>
                    <td   class="ali01">
                        <span id="NowPageAllMoney" runat="server"></span>
                    </td>
                     
                          <td   class="ali01" colspan="4"> 
                    </td>
                </tr>
                <tr class="StatisticsMoney">
                    <td colspan="11" class="ali03">
                        查询项统计：
                    </td>
                    <td   class="ali01">
                        <span id="AllMoney" runat="server"></span>
                    </td>
                     
                          <td   class="ali01" colspan="4"> 
                    </td>
                </tr>
                </tbody>
            </table>
            <uc:ucpager id="UCPager1" runat="server" />

 CY_ECommercePlatform/CY.WebForm/Pages/business/ShejiOrderList.aspx.cs

@@ -542,7 +542,12 @@
            };
            IEnumerable<EC_OrderBasic> result = _eC_OrderBasicBLL.SelectModelPageSheji(pagination, CurrentUser.MemberId,this.txtBeginData.Value,this.txtEndDate.Value,this.txtOrderId.Value
                ,this.selPrintTypes.Value,this.selBusinessManager.Value,this.selShejirenyuan.Value,this.txtBuyerName.Value,this.txtDocumentName.Value,this.selShejiStatus.SelectedValue);

            decimal PageAllMoney = 0;
            var ssss = result.Sum(x => x.ShejiSumPrice);
            var ssssaa = result.Sum(x => x.ShejiSumPriceneiye);
            var sssssssss = ssss.HasValue ? ssss.Value : 0;
            var sssssssssaa = ssssaa.HasValue ? ssssaa.Value : 0;
            PageAllMoney = sssssssss + sssssssssaa;
            foreach (var eC_OrderBasic in result)
            {
                if(eC_OrderBasic.BusinessManagerId.HasValue && eC_OrderBasic.BusinessManagerId.Value > 0)
@@ -553,7 +558,7 @@
                        eC_OrderBasic.BusinessManager = oA_Staff.Name;
                    }
                }

               // PageAllMoney +=( eC_OrderBasic.ShejiSumPrice.Value + eC_OrderBasic.ShejiSumPriceneiye.Value);
                eC_OrderBasic.Shejiticheng = eC_OrderBasic.ShejirenyuanName + eC_OrderBasic.Shejicount + "*" + (eC_OrderBasic.ShejiUnitPrice.HasValue? eC_OrderBasic.ShejiUnitPrice.Value.ToString("G29"):"0") + "=" + (eC_OrderBasic.ShejiSumPrice.HasValue ? eC_OrderBasic.ShejiSumPrice.Value.ToString("G29") : "0");
                if (eC_OrderBasic.PrintTypeId == 6 || eC_OrderBasic.PrintTypeId == 15 || eC_OrderBasic.PrintTypeId == 38)
                {
@@ -561,6 +566,9 @@
                }
                eC_OrderBasic.Shejicountneiyename = (eC_OrderBasic.Shejicountneiye.HasValue && eC_OrderBasic.Shejicountneiye.Value > 0) ? eC_OrderBasic.Shejicountneiye.Value.ToString() : "";
            }
            this.NowPageAllMoney.InnerText = PageAllMoney.ToString("0.00");
            this.AllMoney.InnerText = pagination.heji1.Value.ToString("0.00");

            rptData.DataSource = result;
            rptData.DataBind();


 CY_ECommercePlatform/CY.WebForm/Pages/business/ShejiOrderList.aspx.designer.cs

@@ -159,6 +159,24 @@
        protected global::System.Web.UI.WebControls.Repeater rptData;

        /// <summary>
        /// NowPageAllMoney 控件。
        /// </summary>
        /// <remarks>
        /// 自动生成的字段。
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlGenericControl NowPageAllMoney;

        /// <summary>
        /// AllMoney 控件。
        /// </summary>
        /// <remarks>
        /// 自动生成的字段。
        /// 若要进行修改，请将字段声明从设计器文件移到代码隐藏文件。
        /// </remarks>
        protected global::System.Web.UI.HtmlControls.HtmlGenericControl AllMoney;

        /// <summary>
        /// UCPager1 控件。
        /// </summary>
        /// <remarks>