From 7bcbbbd0459f00ebc3aa7d4f249cb9231a6b5d40 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期五, 31 十月 2025 12:25:17 +0800
Subject: [PATCH] 这个销售绩效查询这个列表中的,你把这个到期类型和到期时间合并,现在到期类型就不要了, 到期时间里面,日期的就显示。时间,他是和金额执行完毕的,就在到期时间里头, 就填上金额执行完毕那个合同金额也是就有金额的显示。金额没得金额的,就先据实结算。好,合同类型这个就不要了。
---
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