/// <summary>
/// 用户列表
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public static BasePageResponse <Sys_DepartInfoModel> GetDepartList(DepartistRequest request)
{
var response = new BasePageResponse <Sys_DepartInfoModel>();
var whereSql = string.Empty;
if (request.IsValid >= 0)
{
whereSql += $" AND DIIsValid = {request.IsValid}";
}
if (!String.IsNullOrEmpty(request.Name))
{
whereSql += $" AND DIName Like '%{request.Name.Replace("'", string.Empty).Replace(" ", string.Empty).Trim()}%' ";
}
var totalSql = $" SELECT Count(1) FROM Sys_DepartInfo WHERE 1=1 {whereSql}; ";
var total = MysqlHelper.GetScalar <int>(totalSql);
if (total > 0)
{
response.IsSuccess = 1;
response.Total = total;
var sql = $" SELECT * FROM Sys_DepartInfo WHERE 1=1 {whereSql} ";
sql += MysqlHelper.GetPageSql(request.PageIndex, request.PageSize);
response.List = MysqlHelper.GetList <Sys_DepartInfoModel>(sql) ?? new List <Sys_DepartInfoModel>();
}
return(response);
}
/// <summary>
/// 获取部门列表
/// </summary>
/// <returns></returns>
public static BasePageResponse <Sys_DepartInfoModel> GetDepartList(DepartistRequest request)
{
return(Sys_DepartInfoAccess.GetDepartList(request));
}