From 7281004dc3854ed59e9164dcd27a59c8c2cf6667 Mon Sep 17 00:00:00 2001
From: qinchulong <qinchulong@hnkhzn.com>
Date: 星期六, 12 十月 2024 15:16:55 +0800
Subject: [PATCH] 初始化
---
项目代码/WMS/WIDESEA_WMSServer/WIDESEA_Repository/Sys_DictionaryRepository.cs | 75 +++++++++++++++++++++++++++++++++++++
1 files changed, 75 insertions(+), 0 deletions(-)
diff --git "a/\351\241\271\347\233\256\344\273\243\347\240\201/WMS/WIDESEA_WMSServer/WIDESEA_Repository/Sys_DictionaryRepository.cs" "b/\351\241\271\347\233\256\344\273\243\347\240\201/WMS/WIDESEA_WMSServer/WIDESEA_Repository/Sys_DictionaryRepository.cs"
new file mode 100644
index 0000000..d60dbd6
--- /dev/null
+++ "b/\351\241\271\347\233\256\344\273\243\347\240\201/WMS/WIDESEA_WMSServer/WIDESEA_Repository/Sys_DictionaryRepository.cs"
@@ -0,0 +1,75 @@
+锘縰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_IRepository;
+using WIDESEA_Model.Models;
+
+namespace WIDESEA_Repository
+{
+ 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 = GetAllDictionary();
+
+ foreach (var item in Dictionaries.Where(x => dicNos.Contains(x.DicNo)))
+ {
+ if (executeSql)
+ {
+ // 2020.05.01澧炲姞鏍规嵁鐢ㄦ埛淇℃伅鍔犺浇瀛楀吀鏁版嵁婧恠ql
+ string sql = item.DBSql;
+ 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> 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