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

using AutoMapper;
using OASystem.Domain;

using OASystem.Domain.ViewModels.System;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace OASystem.Infrastructure.Repositories.System
{
    public class UsersRepository : BaseRepository<UserInfoView, JsonView>
    {
        private readonly IMapper _mapper;
        public UsersRepository(SqlSugarClient sqlSugar) : base(sqlSugar)
        {

        }

        /// <summary>
        /// 用户查询列表
        /// </summary>
        /// <param name="_userRep"></param>
        /// <returns></returns>
        public async Task<Result> GetUserList(string sqlWhere)
        {
            Result result = new Result();
            string userSqlWhere = string.Format(@"Select sjp.JobName,sd.DepName,sc.CompanyName,su.* From Sys_Users su 
                                                  Inner Join Sys_Company sc On su.CompanyId = sc.Id
                                                  Inner Join Sys_Department sd On su.DepId = sd.Id
                                                  Inner Join Sys_JobPost sjp On su.JobPostId = sjp.Id {0}", sqlWhere);
            var _userList = await GetListBySqlWithNolockAsync(userSqlWhere);
            List<UserIView> _userDataList = _mapper.Map<List<UserIView>>(_userList);
            if (_userDataList.Count != 0) 
            {
                result.Code = 0;
                result.Msg = "成功!";
                result.Data = _userDataList;
            }
            else
            {
                result.Code = -1;
                result.Msg = "暂无数据!";
                result.Data = _userDataList;
            }
            
            return result;

        }
    }
}