From 58cc59639e3ca32896d6db5d0c261ff63848a30d Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期一, 15 九月 2025 15:04:37 +0800
Subject: [PATCH] 增加一个完结时间，如果下次打开，就按完结时间计算合同金额
---
CY_ECommercePlatform/CY.SQLDAL/OA/OA_CorporateClientsDAL.cs | 58 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 58 insertions(+), 0 deletions(-)
diff --git a/CY_ECommercePlatform/CY.SQLDAL/OA/OA_CorporateClientsDAL.cs b/CY_ECommercePlatform/CY.SQLDAL/OA/OA_CorporateClientsDAL.cs
index cc7171c..cc4b2cf 100644
--- a/CY_ECommercePlatform/CY.SQLDAL/OA/OA_CorporateClientsDAL.cs
+++ b/CY_ECommercePlatform/CY.SQLDAL/OA/OA_CorporateClientsDAL.cs
@@ -265,6 +265,64 @@
return true;
}
+
+
+ /// <summary>
+ /// 淇敼瀹岀粨
+ /// </summary>
+ /// <param name="model"></param>
+ /// <returns></returns>
+ public bool UpdateWanjie(Infrastructure.Domain.IAggregateRoot model)
+ {
+ Model.OA_CorporateClients trueModel = model as Model.OA_CorporateClients;
+ if (trueModel == null)
+ {
+ return false;
+ }
+
+ SqlParameter par = null;
+ if (trueModel.LastOrderTime.HasValue)
+ {
+ par = new SqlParameter("@LastOrderTime", trueModel.LastOrderTime.Value);
+ }
+ else
+ {
+ par = new SqlParameter("@LastOrderTime", DBNull.Value);
+ }
+ SqlParameter par1 = null;
+ if (trueModel.WanjieTime.HasValue)
+ {
+ par1 = new SqlParameter("@WanjieTime", trueModel.WanjieTime.Value);
+ }
+ else
+ {
+ par1 = new SqlParameter("@WanjieTime", DBNull.Value);
+ }
+
+ IList<SqlParameter> sqlParms = new List<SqlParameter>()
+ {
+ new SqlParameter("@Keyid",trueModel.Keyid),
+
+ par,
+
+ par1,
+
+ new SqlParameter("@Shifouwanjie",trueModel.Shifouwanjie??0) ,
+ };
+ string sql = "Update [OA_CorporateClients] Set [Shifouwanjie]=@Shifouwanjie,[WanjieTime]=@WanjieTime,[LastOrderTime]=@LastOrderTime where [Keyid] =@Keyid ";
+
+ try
+ {
+ _dataBase.ExecuteSql(sql, sqlParms.ToArray<SqlParameter>());
+ }
+ catch (Exception ex)
+ {
+ throw ex;
+ }
+ return true;
+ }
+
+
/// <summary>
/// 杞Щ瀹㈡埛
/// </summary>
--
Gitblit v1.9.1