/// <summary>
/// 获取所有用户
/// </summary>
/// <param name="input">是否冻结</param>
/// <returns></returns>
public Task <IEnumerable <SystemUserInfo> > GetUser(FreezeInput input = null)
{
var sql = new StringBuilder(@"SELECT u.UserId,u.Code,u.Name FROM System_UserInfo u WHERE u.IsAdmin='False'");
if (input != null)
{
sql.Append(string.Format(" AND u.IsFreeze='{0}'", input.IsFreeze));
}
return(SqlMapperUtil.SqlWithParams <SystemUserInfo>(sql.ToString()));
}
/// <summary>
/// 获取所有用户
/// </summary>
/// <param name="input">是否冻结</param>
/// <returns></returns>
public Task <IEnumerable <SystemChosenUserOutput> > GetChosenUser(FreezeInput input = null)
{
var sql = new StringBuilder(
string.Format(
@"SELECT u.UserId,u.Code,u.Name,perUser.PrivilegeMasterValue OrganizationId FROM System_UserInfo u
INNER JOIN System_PermissionUser perUser ON perUser.PrivilegeMasterUserId=u.UserId AND perUser.PrivilegeMaster={0} AND u.IsAdmin='False'",
(int)EnumPrivilegeMaster.组织机构));
if (input != null)
{
sql.Append(string.Format(" u.IsFreeze='{0}'", input.IsFreeze));
}
return(SqlMapperUtil.SqlWithParams <SystemChosenUserOutput>(sql.ToString()));
}
/// <summary>
/// 获取用户
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
public async Task <IEnumerable <SystemUserInfo> > GetUser(FreezeInput input = null)
{
return(await _userInfoRepository.GetUser(input));
}
