From 69a1b7107ca42ef46a42e98f7aadd3ea70fb35ed Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期四, 20 十一月 2025 09:19:32 +0800
Subject: [PATCH] 不用再增加一个专门的序号，就按照这个编号，不是列表都有个编号嘛，好，那个送货单就显示就显示那个编号，比如说雷波中学，你在左送货单的左上角2是1或者。或者有三果十一都可以。
---
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