/// <summary>
/// 获取管理员集合
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public List <AdminViewDto> GetAdminList(AdminModel model)
{
using (IDbConnection conn = DapperHelper.MySqlCon())
{
int PageStart = (model.PageIndex - 1) * model.PageSize;
DynamicParameters dy = new DynamicParameters();
dy.Add("PageStart", PageStart);
dy.Add("PageSize", model.PageSize);
if (!string.IsNullOrEmpty(model.UserName))
{
dy.Add("UserName", model.UserName);
}
if (!string.IsNullOrEmpty(model.UserState))
{
dy.Add("UserState", Convert.ToInt32(model.UserState));
}
string sql = "select * from administrator {0} limit @PageStart ,@PageSize";
StringBuilder where = new StringBuilder();
if (!string.IsNullOrEmpty(model.UserName))
{
where.Append(" where UserName = @UserName ");
}
if (!string.IsNullOrEmpty(model.UserState))
{
if (where.Length > 0)
{
where.Append(" AND UserState = @UserState ");
}
else
{
where.Append(" where UserState = @UserState ");
}
}
sql = string.Format(sql, where);
var result = conn.Query <Administrator>(sql, dy).ToList();
List <AdminViewDto> list = new List <AdminViewDto>();
foreach (var item in result)
{
AdminViewDto adminViewDto = new AdminViewDto()
{
UserName = item.UserName,
RealName = item.RealName,
RoleName = item.RoleId == 0 ? "管理员" : "冒泡",
UserState = item.UserState == 1 ? "在线" : "退出",
Mobile = item.Mobile,
CreateTime = item.CreateTime
};
list.Add(adminViewDto);
}
return(list);
}
}
/// <summary>
/// 获取单个
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public AdminViewDto GetAdmin(int userId)
{
using (IDbConnection conn = DapperHelper.MySqlCon())
{
string sql = "select * from administrator where UserId=@userId";
var result = conn.Query <Administrator>(sql, new { UserId = userId }).FirstOrDefault();
if (result == null)
{
throw new Exception("参数错误!");
}
AdminViewDto adminViewDto = new AdminViewDto()
{
UserName = result.UserName,
RealName = result.RealName,
RoleName = result.RoleId == 0 ? "管理员" : "冒泡",
UserState = result.UserState == 1 ? "在线" : "退出",
Mobile = result.Mobile,
CreateTime = result.CreateTime
};
return(adminViewDto);
}
}
