123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869 |
- using DapperORMCore.Context.DataContext;
- using DapperORMCore.Model.CoreModel;
- using DapperORMCore.Repository.IRepositorys;
- using Microsoft.Extensions.Configuration;
- using NXWMS.IService.NXWMS.Common;
- using NXWMS.Model.AppModels.Result.Common;
- using NXWMS.Model.Common;
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Text;
- using System.Threading.Tasks;
- using WestDistance.DapperORM.Repository.Repositorys;
- namespace NXWMS.Service.NXWMS.Common
- {
- [AutoInject(typeof(IBasDictionaryService), InjectType.Scope)]
- public class BasDictionaryService : ServiceBase, IBasDictionaryService
- {
- #region 全局变量、构造注入
- /// <summary>
- /// 系统操作仓储中转
- /// </summary>
- private IDataRepositoryContext _dataContext;
- /// <summary>
- /// SQL节点仓储
- /// </summary>
- private ISQLNodeRepository _iSQLNodeRepository;
- /// <summary>
- /// 配置
- /// </summary>
- private IConfiguration _configuration;
- /// <summary>
- /// 构造注入
- /// </summary>
- /// <param name="dataRepositoryContext"></param>
- /// <param name="configuration"></param>
- /// <param name="iSQLNodeRepository"></param>
- public BasDictionaryService(IDataRepositoryContext dataRepositoryContext, IConfiguration configuration, ISQLNodeRepository iSQLNodeRepository)
- {
- this._dataContext = dataRepositoryContext;
- this._configuration = configuration;
- this._iSQLNodeRepository = iSQLNodeRepository;
- }
- #endregion
- public OperateResultInfo<List<BasDictionaryResult>> GetBasDictionaryData()
- {
- try
- {
- string sql = $@"
- SELECT
- *
- FROM
- VW_BAS_DICTIONARY
- ";
- List<BasDictionaryResult> resultList = new DataRepository<BasDictionaryResult>(_dataContext).Query(sql).ToList();
- OperateResultInfo<List<BasDictionaryResult>> retDataMsg = SuccessStatus(resultList);
- return retDataMsg;
- }
- catch (Exception ex)
- {
- return FailMessageStatus<List<BasDictionaryResult>>($"查询基础字典项信息发生异常!,【{ex.Message}】", null);
- }
- }
- }
- }
|