From 099c199d96f2d92dfcda50e763528a3d161fd5cf Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期一, 15 九月 2025 08:45:34 +0800
Subject: [PATCH] 设计人员查询的时候，也过滤设计提成里边的设计人员 增加结算状态。 批量结算按钮完成
---
CY_ECommercePlatform/CY.WebForm/Pages/business/ShejiOrderList.aspx.cs | 58 ++++++++++++++++++++++++++++++++++++++++++++++++++++++----
1 files changed, 54 insertions(+), 4 deletions(-)
diff --git a/CY_ECommercePlatform/CY.WebForm/Pages/business/ShejiOrderList.aspx.cs b/CY_ECommercePlatform/CY.WebForm/Pages/business/ShejiOrderList.aspx.cs
index d35cd0f..160e960 100644
--- a/CY_ECommercePlatform/CY.WebForm/Pages/business/ShejiOrderList.aspx.cs
+++ b/CY_ECommercePlatform/CY.WebForm/Pages/business/ShejiOrderList.aspx.cs
@@ -541,8 +541,25 @@
PageIndex = UCPager1.AspNetPager.CurrentPageIndex
};
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);
+ ,this.selPrintTypes.Value,this.selBusinessManager.Value,this.selShejirenyuan.Value,this.txtBuyerName.Value,this.txtDocumentName.Value,this.selShejiStatus.SelectedValue,this.selshifoujiesuan.SelectedValue);
+ decimal PageAllMoney = 0;
+ var ssss = result.Sum(x => x.ShejiSumPrice);
+ var ssssaa = result.Sum(x => x.ShejiSumPriceneiye);
+ var ssssaaa = result.Sum(x => x.ShejiSumPriceneiye1);
+ var ssssaaaa = result.Sum(x => x.ShejiSumPriceneiye2);
+ if(!string.IsNullOrEmpty(this.selShejirenyuan.Value))
+ {
+ ssss = result.Where(x=>x.Shejirenyuan == this.selShejirenyuan.Value.ToInt32()).Sum(x => x.ShejiSumPrice);
+ ssssaa = result.Where(x => x.Shejirenyuanneiye == this.selShejirenyuan.Value.ToInt32()).Sum(x => x.ShejiSumPriceneiye);
+ ssssaaa = result.Where(x => x.Shejirenyuanneiye1 == this.selShejirenyuan.Value.ToInt32()).Sum(x => x.ShejiSumPriceneiye1);
+ ssssaaaa = result.Where(x => x.Shejirenyuanneiye2 == this.selShejirenyuan.Value.ToInt32()).Sum(x => x.ShejiSumPriceneiye2);
+ }
+ var sssssssss = ssss.HasValue ? ssss.Value : 0;
+ var sssssssssaa = ssssaa.HasValue ? ssssaa.Value : 0;
+ var sssssssssaaa = ssssaaa.HasValue ? ssssaaa.Value : 0;
+ var sssssssssaaaaa = ssssaaaa.HasValue ? ssssaaaa.Value : 0;
+ PageAllMoney = sssssssss + sssssssssaa + sssssssssaaa + sssssssssaaaaa;
foreach (var eC_OrderBasic in result)
{
if(eC_OrderBasic.BusinessManagerId.HasValue && eC_OrderBasic.BusinessManagerId.Value > 0)
@@ -553,14 +570,47 @@
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)
+ if ( eC_OrderBasic.PrintTypeId == 15 || eC_OrderBasic.PrintTypeId == 38)
{
eC_OrderBasic.Shejiticheng += "<br/> " + eC_OrderBasic.ShejirenyuanNameneiye + eC_OrderBasic.Shejicountneiye + "*" + (eC_OrderBasic.ShejiUnitPriceneiye.HasValue ? eC_OrderBasic.ShejiUnitPriceneiye.Value.ToString("G29") : "0") + "=" + (eC_OrderBasic.ShejiSumPriceneiye.HasValue ? eC_OrderBasic.ShejiSumPriceneiye.Value.ToString("G29") : "0");
}
eC_OrderBasic.Shejicountneiyename = (eC_OrderBasic.Shejicountneiye.HasValue && eC_OrderBasic.Shejicountneiye.Value > 0) ? eC_OrderBasic.Shejicountneiye.Value.ToString() : "";
+ if (eC_OrderBasic.PrintTypeId == 6)
+ {
+ eC_OrderBasic.Shejiticheng += "<br/> " + eC_OrderBasic.ShejirenyuanNameneiye + eC_OrderBasic.Shejicountneiye + "*" + (eC_OrderBasic.ShejiUnitPriceneiye.HasValue ? eC_OrderBasic.ShejiUnitPriceneiye.Value.ToString("G29") : "0") + "=" + (eC_OrderBasic.ShejiSumPriceneiye.HasValue ? eC_OrderBasic.ShejiSumPriceneiye.Value.ToString("G29") : "0");
+ if (!string.IsNullOrEmpty(eC_OrderBasic.ShejileixingNameneiye1))
+ {
+ eC_OrderBasic.Shejiticheng += "<br/> " + eC_OrderBasic.ShejirenyuanNameneiye1 + eC_OrderBasic.Shejicountneiye1 + "*" + (eC_OrderBasic.ShejiUnitPriceneiye1.HasValue ? eC_OrderBasic.ShejiUnitPriceneiye1.Value.ToString("G29") : "0") + "=" + (eC_OrderBasic.ShejiSumPriceneiye1.HasValue ? eC_OrderBasic.ShejiSumPriceneiye1.Value.ToString("G29") : "0");
+ }
+ if (!string.IsNullOrEmpty(eC_OrderBasic.ShejileixingNameneiye2))
+ {
+ eC_OrderBasic.Shejiticheng += "<br/> " + eC_OrderBasic.ShejirenyuanNameneiye2 + eC_OrderBasic.Shejicountneiye2 + "*" + (eC_OrderBasic.ShejiUnitPriceneiye2.HasValue ? eC_OrderBasic.ShejiUnitPriceneiye2.Value.ToString("G29") : "0") + "=" + (eC_OrderBasic.ShejiSumPriceneiye2.HasValue ? eC_OrderBasic.ShejiSumPriceneiye2.Value.ToString("G29") : "0");
+ }
+
+
+ int Shejicountneiyecount = 0;
+ if (eC_OrderBasic.Shejicountneiye.HasValue )
+ {
+ Shejicountneiyecount += eC_OrderBasic.Shejicountneiye.Value;
+ }
+ if (eC_OrderBasic.Shejicountneiye1.HasValue)
+ {
+ Shejicountneiyecount += eC_OrderBasic.Shejicountneiye1.Value;
+ }
+ if (eC_OrderBasic.Shejicountneiye2.HasValue)
+ {
+ Shejicountneiyecount += eC_OrderBasic.Shejicountneiye2.Value;
+ }
+
+ eC_OrderBasic.Shejicountneiyename = Shejicountneiyecount.ToString();
+ }
+
}
+ this.NowPageAllMoney.InnerText = PageAllMoney.ToString("0.00");
+ this.AllMoney.InnerText = pagination.heji1.Value.ToString("0.00");
+
rptData.DataSource = result;
rptData.DataBind();
@@ -603,7 +653,7 @@
var result = _eC_OrderBasicBLL.SelectModelPageSheji(pa, 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);
+ , this.selPrintTypes.Value, this.selBusinessManager.Value, this.selShejirenyuan.Value, this.txtBuyerName.Value, this.txtDocumentName.Value, this.selShejiStatus.SelectedValue, this.selshifoujiesuan.SelectedValue);
foreach (var eC_OrderBasic in result)
{
--
Gitblit v1.9.1