From 2b723d3abc356f9ce40b77156bcdf78b5ea5eb6b Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期五, 04 七月 2025 16:43:32 +0800
Subject: [PATCH] 设计订单增加查询统计项
---
CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderBasicDAL.cs | 16 ++++++++
CY_ECommercePlatform/CY.WebForm/Pages/business/ShejiOrderList.aspx.cs | 12 +++++-
CY_ECommercePlatform/CY.WebForm/Pages/business/ShejiOrderList.aspx.designer.cs | 18 +++++++++
CY_ECommercePlatform/CY.WebForm/Pages/business/ShejiOrderList.aspx | 22 +++++++++++
4 files changed, 66 insertions(+), 2 deletions(-)
diff --git a/CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderBasicDAL.cs b/CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderBasicDAL.cs
index 690d966..ad4b9c5 100644
--- a/CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderBasicDAL.cs
+++ b/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)
diff --git a/CY_ECommercePlatform/CY.WebForm/Pages/business/ShejiOrderList.aspx b/CY_ECommercePlatform/CY.WebForm/Pages/business/ShejiOrderList.aspx
index 174166c..8fe707c 100644
--- a/CY_ECommercePlatform/CY.WebForm/Pages/business/ShejiOrderList.aspx
+++ b/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" />
diff --git a/CY_ECommercePlatform/CY.WebForm/Pages/business/ShejiOrderList.aspx.cs b/CY_ECommercePlatform/CY.WebForm/Pages/business/ShejiOrderList.aspx.cs
index d35cd0f..46ba6f2 100644
--- a/CY_ECommercePlatform/CY.WebForm/Pages/business/ShejiOrderList.aspx.cs
+++ b/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();
diff --git a/CY_ECommercePlatform/CY.WebForm/Pages/business/ShejiOrderList.aspx.designer.cs b/CY_ECommercePlatform/CY.WebForm/Pages/business/ShejiOrderList.aspx.designer.cs
index aafcc9e..5e81d94 100644
--- a/CY_ECommercePlatform/CY.WebForm/Pages/business/ShejiOrderList.aspx.designer.cs
+++ b/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>
--
Gitblit v1.9.1