From 5782e6fb084441dcf26db0b1aaf33e39204142b8 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期二, 15 四月 2025 08:52:33 +0800
Subject: [PATCH] 20250220设计订单菜单 会员菜单下 设计管理 12 会员菜单下 设计管理 01 会员菜单下 设计管理下 设计记件 /Pages/business/ShejijijianList.aspx 05 会员菜单下 设计管理下 新增订单 /Pages/business/ShejiOrderEdit.aspx 01 会员菜单下 设计管理下 订单管理 /Pages/business/ShejiOrderList.aspx 02
---
CY_ECommercePlatform/CY.SQLDAL/OA/OA_KipiaoshenqingDAL.cs | 21 +++++++++++++++++++++
1 files changed, 21 insertions(+), 0 deletions(-)
diff --git a/CY_ECommercePlatform/CY.SQLDAL/OA/OA_KipiaoshenqingDAL.cs b/CY_ECommercePlatform/CY.SQLDAL/OA/OA_KipiaoshenqingDAL.cs
index 74f87f3..ffb57ce 100644
--- a/CY_ECommercePlatform/CY.SQLDAL/OA/OA_KipiaoshenqingDAL.cs
+++ b/CY_ECommercePlatform/CY.SQLDAL/OA/OA_KipiaoshenqingDAL.cs
@@ -274,6 +274,27 @@
resultOrderBy = query.Criteria[maxParamIndex].Value.ToString();//= 1 == orderbys.Length ? resultOrderBy : orderbys[1];
}
string fromSouce = string.Format("{0}{1}{2}", FROMSOUCEBEFORE, query.Criteria[0].Value, FROMSOUCEEND);//鎷艰鏉′欢
+
+
+ /// <summary>
+ /// 鏌ヨ鏉ユ簮
+ /// </summary>
+ string fromss = " [OA_Kaipiaoshenqing] ok inner join [OA_CorporateClients] oe on oe.Keyid = ok.[BuyerId] " +
+
+
+
+
+
+ " where 0=0 "+ query.Criteria[0].Value;
+ var ssss = _dataBase.SelectModel<Model.OA_Kaipiaoshenqing>(" sum(ok.kpmoney) as kpmoney,sum(ok.Huikuanmoney) as Huikuanmoney,sum(ok.Zengjianmoney) as Zengjianmoney ", fromss);
+ if (ssss.Count>0)
+ {
+ var aaaaa = ssss.First();
+ pagination.heji1 = aaaaa.kpmoney;
+ pagination.heji2 = aaaaa.Zengjianmoney;
+ pagination.heji3 = aaaaa.Huikuanmoney;
+ }
+
return _dataBase.SelectModelPage<Model.OA_Kaipiaoshenqing>(pagination, SELECTTARGET, fromSouce, orderbys[0], resultOrderBy);
}
--
Gitblit v1.9.1