From 618f76fd41527d4fec0eefd1d492a8c52da79032 Mon Sep 17 00:00:00 2001
From: ningshuxia <ningshuxia0927@outlook.com>
Date: 星期三, 30 十一月 2022 17:09:30 +0800
Subject: [PATCH] Merge branch 'master' of http://47.103.154.90:83/r/IStation/Service.V4.1

---
 DAL/IStation.DAL.Basic/property/SpecialProperty.cs |   26 ++++++++++++++++++++++++++
 1 files changed, 26 insertions(+), 0 deletions(-)

diff --git a/DAL/IStation.DAL.Basic/property/SpecialProperty.cs b/DAL/IStation.DAL.Basic/property/SpecialProperty.cs
index 5a1c153..99a9b1c 100644
--- a/DAL/IStation.DAL.Basic/property/SpecialProperty.cs
+++ b/DAL/IStation.DAL.Basic/property/SpecialProperty.cs
@@ -20,8 +20,34 @@
 
         }
 
+        /// <summary>
+        /// 閫氳繃 GroupID 鑾峰彇
+        /// </summary>
+        public List<Entity.SpecialProperty> GetByGroupID(long CorpID, long GroupID)
+        {
+            using (var db = new SqlSugarClient(ConnectionConfig))
+            {
+                return db.Queryable<Entity.SpecialProperty>().Where(x => x.CorpID == CorpID && x.GroupID == GroupID).ToList();
+            }
+        }
 
 
+        /// <summary>
+        /// 鏇存柊 GroupID
+        /// </summary>
+        public bool UpdateGroupID(long CorpID, long ID, long GroupID, long UpdateUserID, DateTime UpdateTime)
+        {
+            using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
+            {
+                return db.Updateable<Entity.SpecialProperty>()
+                    .SetColumns(x => x.GroupID == GroupID)
+                    .SetColumns(x => x.UpdateUserID == UpdateUserID)
+                    .SetColumns(x => x.UpdateTime == UpdateTime)
+                    .Where(x => x.CorpID == CorpID && x.ID == ID)
+                    .ExecuteCommand() > 0;
+            }
+        }
+
 
     }
 }
\ No newline at end of file

--
Gitblit v1.9.3