From 5ac4af42e585258731fcf68166c988c72d29130f Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期五, 15 八月 2025 12:37:04 +0800
Subject: [PATCH] xiugai

---
 CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderBasicDAL.cs                            |    2 
 CY_ECommercePlatform/CY.WebForm/Pages/business/xiaoshouyejiList.aspx.cs          |   17 +++++
 CY_ECommercePlatform/CY.WebForm/Pages/business/xiaoshouyejiList.aspx.designer.cs |   99 +++++++++++++++++++++++++++++++++
 CY_ECommercePlatform/CY.WebForm/Pages/business/xiaoshouyejiList.aspx             |   47 ++++++++++++++-
 4 files changed, 158 insertions(+), 7 deletions(-)

diff --git a/CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderBasicDAL.cs b/CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderBasicDAL.cs
index b959b35..790fca5 100644
--- a/CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderBasicDAL.cs
+++ b/CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderBasicDAL.cs
@@ -653,7 +653,7 @@
 
                 if (string.IsNullOrEmpty(ssss.ToString()))
                 {
-                    ssss.Append("'4354654657568345429890'");
+                    ssss.Append("'11111111-1111-1111-1111-111111111111'");
                 }
 
                
diff --git a/CY_ECommercePlatform/CY.WebForm/Pages/business/xiaoshouyejiList.aspx b/CY_ECommercePlatform/CY.WebForm/Pages/business/xiaoshouyejiList.aspx
index ea891c9..52e58d5 100644
--- a/CY_ECommercePlatform/CY.WebForm/Pages/business/xiaoshouyejiList.aspx
+++ b/CY_ECommercePlatform/CY.WebForm/Pages/business/xiaoshouyejiList.aspx
@@ -86,9 +86,10 @@
         </div>
        
         <div>
+             <table class="tableStyle" useclick="false" usecheckbox="true" sortmode="true" style="text-align: center;">
             <asp:Repeater ID="RepClientList" runat="server">
                 <HeaderTemplate>
-                    <table class="tableStyle" useclick="false" usecheckbox="true" sortmode="true" style="text-align: center;">
+                   
                         <tr>
                            
                             <th style="text-align: center;">
@@ -191,10 +192,48 @@
                         </td>
                     </tr>
                 </ItemTemplate>
-                <FooterTemplate>
-                    </table>
-                </FooterTemplate>
+                
             </asp:Repeater>
+             <tr class="StatisticsMoney">
+                    <td colspan="2" class="ali03">
+                        鍚堣锛�
+                    </td>
+                   
+                      <td   >
+                        <span id="Span1" runat="server"></span>
+                    </td>
+                      <td   >
+                        <span id="Span2" runat="server"></span>
+                    </td>
+                      <td   >
+                        <span id="Span3" runat="server"></span>
+                    </td>
+                      <td   >
+                        <span id="Span4" runat="server"></span>
+                    </td>
+                      <td   >
+                        <span id="Span5" runat="server"></span>
+                    </td>
+                      <td   >
+                        <span id="Span6" runat="server"></span>
+                    </td>
+                      <td   >
+                        <span id="Span7" runat="server"></span>
+                    </td>
+                      <td   >
+                        <span id="Span8" runat="server"></span>
+                    </td>
+                      <td   >
+                        <span id="Span9" runat="server"></span>
+                    </td>
+                         <td   >
+                        <span id="Span10" runat="server"></span>
+                    </td>
+                  <td   >
+                        <span id="Span11" runat="server"></span>
+                    </td>
+                </tr>
+                    </table>
             <div id="page">
                 <uc:UCPager ID="UCPager1" runat="server" />
             </div>
diff --git a/CY_ECommercePlatform/CY.WebForm/Pages/business/xiaoshouyejiList.aspx.cs b/CY_ECommercePlatform/CY.WebForm/Pages/business/xiaoshouyejiList.aspx.cs
index 7591fbb..6867acb 100644
--- a/CY_ECommercePlatform/CY.WebForm/Pages/business/xiaoshouyejiList.aspx.cs
+++ b/CY_ECommercePlatform/CY.WebForm/Pages/business/xiaoshouyejiList.aspx.cs
@@ -78,15 +78,28 @@
                 Pagination pa = new Pagination();
             pa.PageSize = UCPager1.AspNetPager.PageSize;
             pa.PageIndex = UCPager1.AspNetPager.CurrentPageIndex;
-            this.RepClientList.DataSource = bll_EC_OrderBLL.GetxiaoshouyejiList(pa,
+            var oA_DeliverPlans = bll_EC_OrderBLL.GetxiaoshouyejiList(pa,
                 CurrentUser.MemberId,
-                 
+
                 this.selBusinessManagerId.Value,
                 this.txtchaxuntime.Value + "-01"
 
                );
+
+            this.RepClientList.DataSource = oA_DeliverPlans;
             this.RepClientList.DataBind();
             UCPager1.AspNetPager.RecordCount = pa.RecordCount;
+            this.Span1.InnerText = (oA_DeliverPlans.Sum(x=>x.gendanshuliang)??0).ToString();
+            this.Span2.InnerText = (oA_DeliverPlans.Sum(x => x.xinzengshuliang) ?? 0).ToString();
+            this.Span3.InnerText = (oA_DeliverPlans.Sum(x => x.wanjieshuliang) ?? 0).ToString();
+            this.Span4.InnerText = (oA_DeliverPlans.Sum(x => x.huifangshuliang) ?? 0).ToString();
+            this.Span5.InnerText = (oA_DeliverPlans.Sum(x => x.xiadanshuliang) ?? 0).ToString();
+            this.Span6.InnerText = (oA_DeliverPlans.Sum(x => x.shuliang) ?? 0).ToString();
+            this.Span7.InnerText = (oA_DeliverPlans.Sum(x => x.SumPrice) ?? 0).ToString("0.00");
+            this.Span8.InnerText = (oA_DeliverPlans.Sum(x => x.kaipiaojine) ?? 0).ToString("0.00");
+            this.Span9.InnerText = (oA_DeliverPlans.Sum(x => x.PayedMoney) ?? 0).ToString("0.00");
+            this.Span10.InnerText = (oA_DeliverPlans.Sum(x => x.fapiaoshuliang) ?? 0).ToString();
+            this.Span11.InnerText = oA_DeliverPlans.Sum(x => x.UnPayedMoney).ToString("0.00");
         }
 
         //鍒嗛〉浜嬩欢
diff --git a/CY_ECommercePlatform/CY.WebForm/Pages/business/xiaoshouyejiList.aspx.designer.cs b/CY_ECommercePlatform/CY.WebForm/Pages/business/xiaoshouyejiList.aspx.designer.cs
index f028089..6f00964 100644
--- a/CY_ECommercePlatform/CY.WebForm/Pages/business/xiaoshouyejiList.aspx.designer.cs
+++ b/CY_ECommercePlatform/CY.WebForm/Pages/business/xiaoshouyejiList.aspx.designer.cs
@@ -69,6 +69,105 @@
         protected global::System.Web.UI.WebControls.Repeater RepClientList;
 
         /// <summary>
+        /// Span1 鎺т欢銆�
+        /// </summary>
+        /// <remarks>
+        /// 鑷姩鐢熸垚鐨勫瓧娈点��
+        /// 鑻ヨ杩涜淇敼锛岃灏嗗瓧娈靛0鏄庝粠璁捐鍣ㄦ枃浠剁Щ鍒颁唬鐮侀殣钘忔枃浠躲��
+        /// </remarks>
+        protected global::System.Web.UI.HtmlControls.HtmlGenericControl Span1;
+
+        /// <summary>
+        /// Span2 鎺т欢銆�
+        /// </summary>
+        /// <remarks>
+        /// 鑷姩鐢熸垚鐨勫瓧娈点��
+        /// 鑻ヨ杩涜淇敼锛岃灏嗗瓧娈靛0鏄庝粠璁捐鍣ㄦ枃浠剁Щ鍒颁唬鐮侀殣钘忔枃浠躲��
+        /// </remarks>
+        protected global::System.Web.UI.HtmlControls.HtmlGenericControl Span2;
+
+        /// <summary>
+        /// Span3 鎺т欢銆�
+        /// </summary>
+        /// <remarks>
+        /// 鑷姩鐢熸垚鐨勫瓧娈点��
+        /// 鑻ヨ杩涜淇敼锛岃灏嗗瓧娈靛0鏄庝粠璁捐鍣ㄦ枃浠剁Щ鍒颁唬鐮侀殣钘忔枃浠躲��
+        /// </remarks>
+        protected global::System.Web.UI.HtmlControls.HtmlGenericControl Span3;
+
+        /// <summary>
+        /// Span4 鎺т欢銆�
+        /// </summary>
+        /// <remarks>
+        /// 鑷姩鐢熸垚鐨勫瓧娈点��
+        /// 鑻ヨ杩涜淇敼锛岃灏嗗瓧娈靛0鏄庝粠璁捐鍣ㄦ枃浠剁Щ鍒颁唬鐮侀殣钘忔枃浠躲��
+        /// </remarks>
+        protected global::System.Web.UI.HtmlControls.HtmlGenericControl Span4;
+
+        /// <summary>
+        /// Span5 鎺т欢銆�
+        /// </summary>
+        /// <remarks>
+        /// 鑷姩鐢熸垚鐨勫瓧娈点��
+        /// 鑻ヨ杩涜淇敼锛岃灏嗗瓧娈靛0鏄庝粠璁捐鍣ㄦ枃浠剁Щ鍒颁唬鐮侀殣钘忔枃浠躲��
+        /// </remarks>
+        protected global::System.Web.UI.HtmlControls.HtmlGenericControl Span5;
+
+        /// <summary>
+        /// Span6 鎺т欢銆�
+        /// </summary>
+        /// <remarks>
+        /// 鑷姩鐢熸垚鐨勫瓧娈点��
+        /// 鑻ヨ杩涜淇敼锛岃灏嗗瓧娈靛0鏄庝粠璁捐鍣ㄦ枃浠剁Щ鍒颁唬鐮侀殣钘忔枃浠躲��
+        /// </remarks>
+        protected global::System.Web.UI.HtmlControls.HtmlGenericControl Span6;
+
+        /// <summary>
+        /// Span7 鎺т欢銆�
+        /// </summary>
+        /// <remarks>
+        /// 鑷姩鐢熸垚鐨勫瓧娈点��
+        /// 鑻ヨ杩涜淇敼锛岃灏嗗瓧娈靛0鏄庝粠璁捐鍣ㄦ枃浠剁Щ鍒颁唬鐮侀殣钘忔枃浠躲��
+        /// </remarks>
+        protected global::System.Web.UI.HtmlControls.HtmlGenericControl Span7;
+
+        /// <summary>
+        /// Span8 鎺т欢銆�
+        /// </summary>
+        /// <remarks>
+        /// 鑷姩鐢熸垚鐨勫瓧娈点��
+        /// 鑻ヨ杩涜淇敼锛岃灏嗗瓧娈靛0鏄庝粠璁捐鍣ㄦ枃浠剁Щ鍒颁唬鐮侀殣钘忔枃浠躲��
+        /// </remarks>
+        protected global::System.Web.UI.HtmlControls.HtmlGenericControl Span8;
+
+        /// <summary>
+        /// Span9 鎺т欢銆�
+        /// </summary>
+        /// <remarks>
+        /// 鑷姩鐢熸垚鐨勫瓧娈点��
+        /// 鑻ヨ杩涜淇敼锛岃灏嗗瓧娈靛0鏄庝粠璁捐鍣ㄦ枃浠剁Щ鍒颁唬鐮侀殣钘忔枃浠躲��
+        /// </remarks>
+        protected global::System.Web.UI.HtmlControls.HtmlGenericControl Span9;
+
+        /// <summary>
+        /// Span10 鎺т欢銆�
+        /// </summary>
+        /// <remarks>
+        /// 鑷姩鐢熸垚鐨勫瓧娈点��
+        /// 鑻ヨ杩涜淇敼锛岃灏嗗瓧娈靛0鏄庝粠璁捐鍣ㄦ枃浠剁Щ鍒颁唬鐮侀殣钘忔枃浠躲��
+        /// </remarks>
+        protected global::System.Web.UI.HtmlControls.HtmlGenericControl Span10;
+
+        /// <summary>
+        /// Span11 鎺т欢銆�
+        /// </summary>
+        /// <remarks>
+        /// 鑷姩鐢熸垚鐨勫瓧娈点��
+        /// 鑻ヨ杩涜淇敼锛岃灏嗗瓧娈靛0鏄庝粠璁捐鍣ㄦ枃浠剁Щ鍒颁唬鐮侀殣钘忔枃浠躲��
+        /// </remarks>
+        protected global::System.Web.UI.HtmlControls.HtmlGenericControl Span11;
+
+        /// <summary>
         /// UCPager1 鎺т欢銆�
         /// </summary>
         /// <remarks>

--
Gitblit v1.9.1