From c020f31a67fc5aa5644511bddff075f7ecc85234 Mon Sep 17 00:00:00 2001
From: qinchulong <qinchulong@hnkhzn.com>
Date: 星期二, 27 五月 2025 15:35:27 +0800
Subject: [PATCH] Merge branch 'master' of http://115.159.85.185:8098/r/HuaYiZhongHeng/ZhongHeLiTiKu
---
代码管理/WMS/WIDESEA_WMSServer/WIDESEA_SystemRepository/Sys_DictionaryRepository.cs | 85 ++++++++++++++++++++++++++++++++++++++++++
1 files changed, 85 insertions(+), 0 deletions(-)
diff --git "a/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WIDESEA_WMSServer/WIDESEA_SystemRepository/Sys_DictionaryRepository.cs" "b/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WIDESEA_WMSServer/WIDESEA_SystemRepository/Sys_DictionaryRepository.cs"
new file mode 100644
index 0000000..a235134
--- /dev/null
+++ "b/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WIDESEA_WMSServer/WIDESEA_SystemRepository/Sys_DictionaryRepository.cs"
@@ -0,0 +1,85 @@
+锘縰sing Microsoft.AspNetCore.DataProtection.KeyManagement;
+using SqlSugar;
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+using WIDESEA_Core.BaseRepository;
+using WIDESEA_ISystemRepository;
+using WIDESEA_Model.Models;
+
+namespace WIDESEA_SystemRepository
+{
+ public class Sys_DictionaryRepository : RepositoryBase<Sys_Dictionary>, ISys_DictionaryRepository
+ {
+
+
+ public Sys_DictionaryRepository(IUnitOfWorkManage unitOfWorkManage) : base(unitOfWorkManage)
+ {
+
+ }
+
+ /// <summary>
+ ///
+ /// </summary>
+ /// <param name="dicNos"></param>
+ /// <param name="executeSql">鏄惁鎵ц鑷畾涔塻ql</param>
+ /// <returns></returns>
+ public IEnumerable<Sys_Dictionary> GetDictionaries(IEnumerable<string> dicNos, bool executeSql = true)
+ {
+ List<Sys_Dictionary> Dictionaries = GetDictionaries(dicNos.ToList());
+
+ foreach (var item in Dictionaries)
+ {
+ if (executeSql)
+ {
+ // 2020.05.01澧炲姞鏍规嵁鐢ㄦ埛淇℃伅鍔犺浇瀛楀吀鏁版嵁婧恠ql
+ string sql = item.Sql;
+ if (!string.IsNullOrEmpty(sql))
+ {
+ item.DicList = Query(sql);
+ }
+ }
+ }
+
+ return Dictionaries;
+ }
+
+ List<Sys_DictionaryList> Query(string sql)
+ {
+ try
+ {
+ return base.QueryDynamicDataBySql(sql, null).Select(s => new Sys_DictionaryList()
+ {
+ DicName = s.value,
+ DicValue = s.key.ToString()
+ }).ToList();
+ }
+ catch (Exception ex)
+ {
+ throw ex;
+ }
+ }
+
+ private List<Sys_Dictionary> GetDictionaries(List<string> dicNos)
+ {
+ //base.QueryData().ToList();
+ List<Sys_Dictionary> _dictionaries = Db.Queryable<Sys_Dictionary>().Where(x => x.Enable == 1 && dicNos.Contains(x.DicNo)).Includes(x => x.DicList).ToList();
+ return _dictionaries;
+ }
+
+ private List<Sys_Dictionary> GetAllDictionary()
+ {
+ //base.QueryData().ToList();
+ List<Sys_Dictionary> _dictionaries = Db.Queryable<Sys_Dictionary>().Includes(x => x.DicList).Where(x => x.Enable == 1).ToList();
+ return _dictionaries;
+ }
+ }
+
+ public class SourceKeyVaule
+ {
+ public object Key { get; set; }
+ public string Value { get; set; }
+ }
+}
--
Gitblit v1.9.3