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 |  130 +++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 130 insertions(+), 0 deletions(-)

diff --git a/CY_ECommercePlatform/CY.SQLDAL/OA/OA_CorporateClientsDAL.cs b/CY_ECommercePlatform/CY.SQLDAL/OA/OA_CorporateClientsDAL.cs
index 50d5f9f..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>
@@ -1505,5 +1563,77 @@
             }
         }
 
+
+        /// <summary>
+        /// 鏂板
+        /// </summary>
+        /// <param name="model"></param>
+        /// <returns></returns>
+        public bool Insertattachment(OA_attachment model)
+        {
+            Model.OA_attachment trueModel = model as Model.OA_attachment;
+            if (trueModel == null)
+            {
+                return false;
+            }
+
+
+            IList<SqlParameter> sqlParms = new List<SqlParameter>()
+            {
+                   new SqlParameter("@OA_Id",trueModel.OA_Id),
+                   new SqlParameter("@CreateTime",trueModel.CreateTime),
+                   new SqlParameter("@PlanAttachment",trueModel.PlanAttachment),
+                   new SqlParameter("@AttachmentType",trueModel.AttachmentType),
+                   new SqlParameter("@Operator",string.IsNullOrWhiteSpace(trueModel.Operator)?"":trueModel.Operator),
+                    new SqlParameter("@AttachmentHouzhui",string.IsNullOrWhiteSpace(trueModel.AttachmentHouzhui)?"":trueModel.AttachmentHouzhui),
+                     new SqlParameter("@AttachmentName",string.IsNullOrWhiteSpace(trueModel.AttachmentName)?"":trueModel.AttachmentName ),
+
+
+            };
+            string sql = "Insert Into OA_attachment ( [OA_Id] , [PlanAttachment],[AttachmentType],[CreateTime],[Operator],[AttachmentHouzhui],[AttachmentName] )"
+                                             + " Values (  @OA_Id,  @PlanAttachment,@AttachmentType,@CreateTime,@Operator,@AttachmentHouzhui,@AttachmentName  )";
+            try
+            {
+                _dataBase.ExecuteSql(sql, sqlParms.ToArray<SqlParameter>());
+            }
+            catch (Exception ex)
+            {
+                throw ex;
+            }
+            return true;
+        }
+
+
+        /// <summary>
+        /// 鏍规嵁鍘傚晢缂栧彿鏌ヨ鍏ㄩ儴澶栧崗鍘傚晢
+        /// </summary>
+        /// <param name="MemberId">缂栧彿</param>
+        /// <returns></returns>
+        public IEnumerable<OA_attachment> GetattachmentlList(string OA_Id)
+        {
+            if (OA_Id == null)
+                return null;//閿欒鏁版嵁杩斾細绌� 
+
+            IList<OA_attachment> result = _dataBase.SelectModel<OA_attachment>("*", "OA_attachment", string.Format(" OA_Id='{0}'   ORDER BY CreateTime DESC", OA_Id)) as IList<OA_attachment>;//鎵ц鏌ヨ
+
+            return result;//杩斿洖缁撴灉
+        }
+
+
+        /// <summary>
+        /// 鍗曚釜鏌ヨ璁块棶
+        /// </summary>
+        /// <param name="Keyid">缂栧彿</param>
+        /// <returns></returns>
+        public OA_CorporateClientsVisit SelectVisitByKeyid(Guid Keyid)
+        {
+            if (Keyid == null)
+                return null;//閿欒鏁版嵁杩斾細绌� 
+
+            IList<OA_CorporateClientsVisit> result = _dataBase.SelectModel<OA_CorporateClientsVisit>(" a.* ", " OA_CorporateClientsVisit a ", string.Format(" a.Keyid='{0}'", Keyid)) as IList<OA_CorporateClientsVisit>;//鎵ц鏌ヨ
+
+            return (null == result || result.Count == 0) ? null : result[0];//杩斿洖缁撴灉
+        }
+
     }
 }

--
Gitblit v1.9.1