HuaYiZhongHeng/ZhongHeLiTiKu.git

对比新文件
			@@ -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; }
			}
			}