From 711fc30d62069784f461426d8c00a30dfd54e1a9 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期三, 17 十二月 2025 12:14:11 +0800
Subject: [PATCH] 20251217 逾期款项列表的“未收款金额”下面加个合计
---
CY_ECommercePlatform/CY.SQLDAL/OA/OA_CuikuanjiluDAL.cs | 27 +++++++++++++++++++++++++++
1 files changed, 27 insertions(+), 0 deletions(-)
diff --git a/CY_ECommercePlatform/CY.SQLDAL/OA/OA_CuikuanjiluDAL.cs b/CY_ECommercePlatform/CY.SQLDAL/OA/OA_CuikuanjiluDAL.cs
index 202ec6b..562341e 100644
--- a/CY_ECommercePlatform/CY.SQLDAL/OA/OA_CuikuanjiluDAL.cs
+++ b/CY_ECommercePlatform/CY.SQLDAL/OA/OA_CuikuanjiluDAL.cs
@@ -130,6 +130,33 @@
/// <summary>
+ /// 鏍规嵁缂栧彿鑾峰緱淇℃伅
+ /// </summary>
+ /// <param name="Keyid">缂栧彿</param>
+ /// <returns></returns>
+ public int GetCountByKeyid(Guid? BuyerId, string shoukuanshijian = "")
+ {
+ try
+ {
+ string condition = " ";
+
+ condition = " BuyerId='" + BuyerId + "' and shoukuanshijian='" + shoukuanshijian + "'";
+
+
+ // return null;//閿欒鏁版嵁杩斾細绌�
+
+ IList<OA_Cuikuanjilu> result = _dataBase.SelectModel<OA_Cuikuanjilu>(" count(*) as Count ", "OA_Cuikuanjilu", condition) as IList<OA_Cuikuanjilu>;//鎵ц鏌ヨ
+
+ return (null == result || result.Count == 0) ? 0 : result[0].Count.Value;//杩斿洖缁撴灉
+ }
+ catch (Exception ex)
+ {
+ throw ex;
+ }
+ }
+
+
+ /// <summary>
/// 鍏ㄩ儴鏌ヨ
/// </summary>
/// <param name="query"></param>
--
Gitblit v1.9.1