public bool BathStartOrLimitAdminUser(AdminUserRequest request)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from [dbo].[tblAdminUser] where Id in @ids ");
using (IDbConnection connection = new SqlConnection(DbConnectionStringConfig.Default.MyShopConnectionString))
{
return(connection.Execute(strSql.ToString(), new { ids = request.IdList.ToArray(), IsDelete = request.IsDelete }) > 0);
}
}
/// <summary>
/// 用户列表
/// </summary>
/// <returns></returns>
public IActionResult GetUserManageList(string userName, string roleId, int limit, int page)
{
var paramRequest = new AdminUserRequest
{
UserName = userName,
RoleId = roleId,
PageIndex = page,
PageSize = limit
};
var result = _isAdminUserService.QueryUserListPage(paramRequest);
//_logger.LogInformation($"用户数据:{JsonConvert.SerializeObject(result)}");
return(Json(result));
}
public AdminUserEntity QueryAdminUserOne(AdminUserRequest request)
{
DynamicParameters dp = new DynamicParameters();
StringBuilder strSQL = new StringBuilder();
strSQL.Append(" select [Id],[UserName],[PassWord],[IsDelete],[CreateUser],[CreateTime],[UpdateUser],[UpdateTime],[RealName],[MobilePhone],[Remark] from tblAdminUser with(nolock) where 1=1 ");
if (!string.IsNullOrEmpty(request.UserName))
{
strSQL.Append(" and UserName=@UserName ");
dp.Add("UserName", request.UserName, DbType.String, ParameterDirection.Input, 50);
}
if (!string.IsNullOrEmpty(request.PassWord))
{
strSQL.Append(" and PassWord=@PassWord ");
dp.Add("PassWord", request.UserName, DbType.String, ParameterDirection.Input, 50);
}
using (DbConnection conn = new SqlConnection(DbConnectionStringConfig.Default.MyShopConnectionString))
{
return(conn.Query <AdminUserEntity>(strSQL.ToString(), request).FirstOrDefault());
}
}
public AdminUserResponse QueryUserListPage(AdminUserRequest request)
{
int total = 0;
var pageList = adminUser.QueryUserMangeList(request, out total);
AdminUserResponse page = new AdminUserResponse();
if (pageList != null && pageList.Count > 0)
{
page.code = 0;
page.msg = "success";
page.count = total;
page.data = pageList.Where(p => p.UserName != AppSettingConfig.SuperAdminAccount).ToList();
//NLogHelper.Default.Info($"service=>查询后台管理用户:{JsonConvert.SerializeObject(page)}");
}
else
{
page.msg = "无数据";
page.code = -1;
}
return(page);
}
public List <AdminUserEntity> QueryUserMangeList(AdminUserRequest request, out int total)
{
total = 0;
List <AdminUserEntity> list = new List <AdminUserEntity>();
StringBuilder sq = new StringBuilder();
sq.Append(" select * from ( ");
sq.Append(" select {2} ");
sq.Append(" from dbo.tblAdminUser a with(nolock) ");
sq.Append(" where {0} ");
sq.Append(" ) c where {1} ");
DynamicParameters dp = new DynamicParameters();
string where_1 = " 1=1 ";
if (!string.IsNullOrWhiteSpace(request.UserName))
{
where_1 += " and a.UserName=@UserName";
dp.Add("UserName", request.UserName, DbType.String, ParameterDirection.Input, 50);
}
if (!string.IsNullOrWhiteSpace(request.RoleId))
{
where_1 += " and a.Id not in (select [UserMasterId] from [tblRoleAndUserRelation] with(nolock) where [RoleId]=@RoleId) ";
dp.Add("RoleId", request.RoleId, DbType.String, ParameterDirection.Input, 50);
}
dp.Add("PageIndex", request.PageIndex, DbType.Int32, ParameterDirection.Input);
dp.Add("PageSize", request.PageSize, DbType.Int32, ParameterDirection.Input);
string sql_list = string.Format(sq.ToString(), where_1, " c.Num > (@PageIndex - 1) * @PageSize and c.Num <= @PageIndex * @PageSize", "ROW_NUMBER() over(order by a.CreateTime desc) as Num,* ");
string sql_count = string.Format(sq.ToString(), where_1, "1=1", "count(0) as nums");
using (IDbConnection conn = new SqlConnection(DbConnectionStringConfig.Default.MyShopConnectionString))
{
total = conn.Query <int>(sql_count, dp).FirstOrDefault();
list = conn.Query <AdminUserEntity>(sql_list, dp).ToList();
}
return(list);
}
public bool BathStartOrLimitAdminUser(AdminUserRequest request)
{
return(adminUser.BathStartOrLimitAdminUser(request));
}
public AdminUserEntity QueryAdminUserEntity(AdminUserRequest request)
{
var userEntity = adminUser.QueryAdminUserOne(request);
return(userEntity);
}
public virtual void OnAdminUserError(AdminUserRequest request, AdminUserResponse response, Exception exception)
{
throw exception;
}
public virtual void OnAdminUserComplete(AdminUserRequest request, AdminUserResponse response)
{
}
public virtual void OnAdminUserInitialization(AdminUserRequest request, AdminUserResponse response)
{
}
