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