OA2023/OASystem/OASystem.Infrastructure/Repositories/System/SetDataRepository.cs


using OASystem.Domain;
using OASystem.Domain.Dtos.UserDto;
using OASystem.Domain.Entities.System;
using OASystem.Domain.ViewModels.System;

namespace OASystem.Infrastructure.Repositories.System
{
    public class SetDataRepository : BaseRepository<Sys_SetData, SetDataView>
    {
        public SetDataRepository(SqlSugarClient sqlSugar) : base(sqlSugar)
        {

        }

        /// <summary>
        /// 获取所有系统模块
        /// </summary>
        /// <param name="_SetData"></param>
        /// <returns></returns>
        public async Task<Result> GetSySDefultModule(SetDataRepository _SetData)
        {
            Result result = new Result();
            string sql = "select * from Sys_SetData where STid = 5 and isdel = 0";
            var DBdata = await _SetData.GetListBySqlWithNolockAsync(sql);

            if (DBdata == null || DBdata.Count == 0)
            {
                return result;
            }

            result.Data = DBdata.Select(x=> new SetDataView
            {
                 Name = x.Name,
                 STid = x.STid,
                 Id = x.Id,
            });

            result.Code = 0;
            result.Msg = "成功！";

            return result;
        }

        /// <summary>
        /// 获取类型Data By STId
        /// </summary>
        /// <param name="_SetData"></param>
        /// <returns></returns>
        public async Task<Result> GetSetDataBySTId(SetDataRepository _SetData,int stId)
        {
            Result result = new Result();
            string sql = string.Format(@"select * from Sys_SetData where STid = {0} and isdel = 0",stId);
            var DBdata = await _SetData.GetListBySqlWithNolockAsync(sql);

            if (DBdata == null || DBdata.Count == 0)
            {
                return result;
            }

            result.Data = DBdata.Select(x => new SetDataInfoView
            {
                Name = x.Name,
                Id = x.Id,
            });

            result.Code = 0;
            result.Msg = "成功！";

            return result;
        }

    }
}