BasDictionaryService.cs 2.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869
  1. using DapperORMCore.Context.DataContext;
  2. using DapperORMCore.Model.CoreModel;
  3. using DapperORMCore.Repository.IRepositorys;
  4. using Microsoft.Extensions.Configuration;
  5. using NXWMS.IService.NXWMS.Common;
  6. using NXWMS.Model.AppModels.Result.Common;
  7. using NXWMS.Model.Common;
  8. using System;
  9. using System.Collections.Generic;
  10. using System.Linq;
  11. using System.Text;
  12. using System.Threading.Tasks;
  13. using WestDistance.DapperORM.Repository.Repositorys;
  14. namespace NXWMS.Service.NXWMS.Common
  15. {
  16. [AutoInject(typeof(IBasDictionaryService), InjectType.Scope)]
  17. public class BasDictionaryService : ServiceBase, IBasDictionaryService
  18. {
  19. #region 全局变量、构造注入
  20. /// <summary>
  21. /// 系统操作仓储中转
  22. /// </summary>
  23. private IDataRepositoryContext _dataContext;
  24. /// <summary>
  25. /// SQL节点仓储
  26. /// </summary>
  27. private ISQLNodeRepository _iSQLNodeRepository;
  28. /// <summary>
  29. /// 配置
  30. /// </summary>
  31. private IConfiguration _configuration;
  32. /// <summary>
  33. /// 构造注入
  34. /// </summary>
  35. /// <param name="dataRepositoryContext"></param>
  36. /// <param name="configuration"></param>
  37. /// <param name="iSQLNodeRepository"></param>
  38. public BasDictionaryService(IDataRepositoryContext dataRepositoryContext, IConfiguration configuration, ISQLNodeRepository iSQLNodeRepository)
  39. {
  40. this._dataContext = dataRepositoryContext;
  41. this._configuration = configuration;
  42. this._iSQLNodeRepository = iSQLNodeRepository;
  43. }
  44. #endregion
  45. public OperateResultInfo<List<BasDictionaryResult>> GetBasDictionaryData()
  46. {
  47. try
  48. {
  49. string sql = $@"
  50. SELECT
  51. *
  52. FROM
  53. VW_BAS_DICTIONARY
  54. ";
  55. List<BasDictionaryResult> resultList = new DataRepository<BasDictionaryResult>(_dataContext).Query(sql).ToList();
  56. OperateResultInfo<List<BasDictionaryResult>> retDataMsg = SuccessStatus(resultList);
  57. return retDataMsg;
  58. }
  59. catch (Exception ex)
  60. {
  61. return FailMessageStatus<List<BasDictionaryResult>>($"查询基础字典项信息发生异常!,【{ex.Message}】", null);
  62. }
  63. }
  64. }
  65. }