public async Task <JsonResult> DoEdit([FromBody] SysOrganization entity)
{
var jm = new AdminUiCallBack();
var oldModel = await _sysOrganizationServices.QueryByIdAsync(entity.id);
if (oldModel == null)
{
jm.msg = "不存在此信息";
return(new JsonResult(jm));
}
//事物处理过程开始
//oldModel.id = entity.id;
oldModel.parentId = entity.parentId;
oldModel.organizationName = entity.organizationName;
oldModel.organizationFullName = entity.organizationFullName;
oldModel.organizationType = entity.organizationType;
//oldModel.leaderId = entity.leaderId;
oldModel.sortNumber = entity.sortNumber;
oldModel.comments = entity.comments;
oldModel.deleted = entity.deleted;
//oldModel.createTime = entity.createTime;
oldModel.updateTime = DateTime.Now;
//事物处理过程结束
var bl = await _sysOrganizationServices.UpdateAsync(oldModel);
jm.code = bl ? 0 : 1;
jm.msg = bl ? GlobalConstVars.EditSuccess : GlobalConstVars.EditFailure;
return(new JsonResult(jm));
}
public async Task <JsonResult> GetEdit([FromBody] FMIntId entity)
{
var jm = new AdminUiCallBack();
var model = await _sysOrganizationServices.QueryByIdAsync(entity.id);
if (model == null)
{
jm.msg = "不存在此信息";
return(new JsonResult(jm));
}
var dict = await _sysDictionaryServices.QueryByClauseAsync(p => p.dictCode == "organization_type");
var dictData = new List <SysDictionaryData>();
if (dict != null)
{
dictData = await _sysDictionaryDataServices.QueryListByClauseAsync(p => p.dictId == dict.id);
}
jm.code = 0;
jm.data = new
{
model,
dictData
};
return(new JsonResult(jm));
}
public override void OnResultExecuting(ResultExecutingContext actionContext)
{
//base.OnResultExecuting(actionContext);
var modelState = actionContext.ModelState;
List <ErrorViewModel> errors = new List <ErrorViewModel>();
if (!modelState.IsValid)
{
var baseResult = new AdminUiCallBack()
{
code = 1,
msg = "请提交必要的参数",
};
foreach (var key in modelState.Keys)
{
var state = modelState[key];
if (state.Errors.Any())
{
ErrorViewModel errorView = new ErrorViewModel();
errorView.ErrorName = key;
errorView.Error = state.Errors.First().ErrorMessage;
errors.Add(errorView);
//baseResult.msg += errorView.ErrorName + "-" + errorView.Error;
}
}
baseResult.data = errors;
actionContext.Result = new ContentResult
{
Content = JsonConvert.SerializeObject(baseResult),
ContentType = "application/json"
};
}
}
/// <summary>
/// 重写删除指定ID的数据
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public async Task <AdminUiCallBack> DeleteByIdAsync(int id)
{
var jm = new AdminUiCallBack();
var all = await GetCaChe();
var model = all.Find(p => p.id == id);
if (model == null)
{
jm.msg = GlobalConstVars.DataisNo;
return(jm);
}
var ids = new List <int>()
{
id
};
GetIds(all, id, ids);
var bl = await dbClient.Deleteable <SysMenu>().In(ids).ExecuteCommandHasChangeAsync();
jm.code = bl ? 0 : 1;
jm.msg = bl ? GlobalConstVars.DeleteSuccess : GlobalConstVars.DeleteFailure;
if (bl)
{
await UpdateCaChe();
}
return(jm);
}
public async Task <JsonResult> DoDelete([FromBody] FMIntId entity)
{
var jm = new AdminUiCallBack();
var model = await _sysUserServices.QueryByIdAsync(entity.id);
if (model == null)
{
jm.msg = GlobalConstVars.DataisNo;
return(new JsonResult(jm));
}
if (model.id == 1)
{
jm.msg = "初始管理员账户禁止删除";
return(new JsonResult(jm));
}
var bl = await _sysUserServices.DeleteByIdAsync(entity.id);
if (bl)
{
await _sysUserRoleServices.DeleteAsync(p => p.userId == model.id);
}
jm.code = bl ? 0 : 1;
jm.msg = bl ? GlobalConstVars.DeleteSuccess : GlobalConstVars.DeleteFailure;
return(new JsonResult(jm));
}
public async Task <JsonResult> GetEdit([FromBody] FMIntId entity)
{
var jm = new AdminUiCallBack();
var model = await _sysUserServices.QueryByIdAsync(entity.id);
if (model == null)
{
jm.msg = "不存在此信息";
return(new JsonResult(jm));
}
var userSexTypes = EnumHelper.EnumToList <GlobalEnumVars.UserSexTypes>();
var userRoles = await _sysUserRoleServices.QueryListByClauseAsync(p => p.userId == model.id);
var roleIds = userRoles.Select(p => p.roleId).ToList();
var roles = await _sysRoleServices.QueryListByClauseAsync(p => p.deleted == false);
jm.code = 0;
jm.data = new
{
model,
userSexTypes,
roles,
roleIds
};
return(new JsonResult(jm));
}
public async Task <JsonResult> DoEdit([FromBody] SysUserRole entity)
{
var jm = new AdminUiCallBack();
var oldModel = await _sysUserRoleServices.QueryByIdAsync(entity.id);
if (oldModel == null)
{
jm.msg = "不存在此信息";
return(new JsonResult(jm));
}
//事物处理过程开始
oldModel.id = entity.id;
oldModel.userId = entity.userId;
oldModel.roleId = entity.roleId;
oldModel.createTime = entity.createTime;
oldModel.updateTime = entity.updateTime;
//事物处理过程结束
var bl = await _sysUserRoleServices.UpdateAsync(oldModel);
jm.code = bl ? 0 : 1;
jm.msg = bl ? GlobalConstVars.EditSuccess : GlobalConstVars.EditFailure;
return(new JsonResult(jm));
}
public async Task <JsonResult> DoEdit([FromBody] SysDictionaryData entity)
{
var jm = new AdminUiCallBack();
var oldModel = await _sysDictionaryDataServices.QueryByIdAsync(entity.id);
if (oldModel == null)
{
jm.msg = "不存在此信息";
return(new JsonResult(jm));
}
//事物处理过程开始
oldModel.dictId = entity.dictId;
oldModel.dictDataCode = entity.dictDataCode;
oldModel.dictDataName = entity.dictDataName;
oldModel.comments = entity.comments;
oldModel.sortNumber = entity.sortNumber;
oldModel.updateTime = DateTime.Now;
//事物处理过程结束
var bl = await _sysDictionaryDataServices.UpdateAsync(oldModel);
jm.code = bl ? 0 : 1;
jm.msg = bl ? GlobalConstVars.EditSuccess : GlobalConstVars.EditFailure;
return(new JsonResult(jm));
}
public async Task <JsonResult> DoSetSysMenu([FromBody] FMIntIdByListIntData entity)
{
var jm = new AdminUiCallBack();
var oldModel = await _sysRoleServices.QueryByIdAsync(entity.id);
if (oldModel == null)
{
jm.msg = "不存在此信息";
return(new JsonResult(jm));
}
await _sysRoleMenuServices.DeleteAsync(p => p.roleId == oldModel.id);
if (entity.data.Any())
{
var list = new List <SysRoleMenu>();
entity.data.ForEach(p =>
{
list.Add(new SysRoleMenu
{
createTime = DateTime.Now,
menuId = p,
roleId = oldModel.id
});
});
await _sysRoleMenuServices.InsertAsync(list);
}
jm.code = 0;
jm.msg = "权限设置成功";
return(new JsonResult(jm));
}
public async Task <JsonResult> GetEditUserInfo()
{
var jm = new AdminUiCallBack();
var userModel = await _sysUserServices.QueryByIdAsync(_user.ID);
if (userModel != null)
{
var roles = await _sysUserRoleServices.QueryListByClauseAsync(p => p.userId == userModel.id);
if (roles.Any())
{
var roleIds = roles.Select(p => p.roleId).ToList();
userModel.roles = await _sysRoleServices.QueryListByClauseAsync(p => roleIds.Contains(p.id));
}
if (userModel.organizationId != null && userModel.organizationId > 0)
{
var organization = await _sysOrganizationServices.QueryByIdAsync(userModel.organizationId);
if (organization != null)
{
userModel.organizationName = organization.organizationName;
}
}
}
jm.code = 0;
jm.msg = "数据获取正常";
jm.data = userModel;
return(new JsonResult(jm));
}
public async Task <JsonResult> GetNavs()
{
var jm = new AdminUiCallBack();
//先获取用户关联角色
var roles = await _sysUserRoleServices.QueryListByClauseAsync(p => p.userId == _user.ID);
if (roles.Any())
{
var roleIds = roles.Select(p => p.roleId).ToList();
var sysRoleMenu = await _sysRoleMenuServices.QueryListByClauseAsync(p => roleIds.Contains(p.roleId));
var menuIds = sysRoleMenu.Select(p => p.menuId).ToList();
var where = PredicateBuilder.True <SysMenu>();
where = where.And(p => p.deleted == false && p.hide == false && p.menuType == 0);
where = where.And(p => menuIds.Contains(p.id));
var navs = await _sysMenuServices.QueryListByClauseAsync(where, p => p.sortNumber, OrderByType.Asc);
var menus = GetMenus(navs, 0);
jm.data = menus;
}
jm.msg = "数据获取正常";
jm.code = 0;
return(new JsonResult(jm));
}
public async Task <JsonResult> DoDelete([FromBody] FMIntId entity)
{
var jm = new AdminUiCallBack();
jm = await _sysMenuServices.DeleteByIdAsync(entity.id);
return(new JsonResult(jm));
}
public async Task <JsonResult> DoCreate([FromBody] SysMenu entity)
{
var jm = new AdminUiCallBack();
entity.createTime = DateTime.Now;;
jm = await _sysMenuServices.InsertAsync(entity);
return(new JsonResult(jm));
}
public JsonResult GetCreate()
{
//返回数据
var jm = new AdminUiCallBack {
code = 0
};
return(new JsonResult(jm));
}
public async Task <JsonResult> SelectExportExcel([FromBody] FMArrayIntIds entity)
{
var jm = new AdminUiCallBack();
//创建Excel文件的对象
var book = new HSSFWorkbook();
//添加一个sheet
var sheet1 = book.CreateSheet("Sheet1");
//获取list数据
var listmodel =
await _sysUserRoleServices.QueryListByClauseAsync(p => entity.id.Contains(p.id), p => p.id,
OrderByType.Asc);
//给sheet1添加第一行的头部标题
var row1 = sheet1.CreateRow(0);
row1.CreateCell(0).SetCellValue("主键");
row1.CreateCell(1).SetCellValue("用户id");
row1.CreateCell(2).SetCellValue("角色id");
row1.CreateCell(3).SetCellValue("创建时间");
row1.CreateCell(4).SetCellValue("修改时间");
//将数据逐步写入sheet1各个行
for (var i = 0; i < listmodel.Count; i++)
{
var rowtemp = sheet1.CreateRow(i + 1);
rowtemp.CreateCell(0).SetCellValue(listmodel[i].id.ToString());
rowtemp.CreateCell(1).SetCellValue(listmodel[i].userId.ToString());
rowtemp.CreateCell(2).SetCellValue(listmodel[i].roleId.ToString());
rowtemp.CreateCell(3).SetCellValue(listmodel[i].createTime.ToString());
rowtemp.CreateCell(4).SetCellValue(listmodel[i].updateTime.ToString());
}
// 导出excel
var webRootPath = _webHostEnvironment.WebRootPath;
var tpath = "/files/" + DateTime.Now.ToString("yyyy-MM-dd") + "/";
var fileName = DateTime.Now.ToString("yyyyMMddHHmmssfff") + "-SysUserRole导出(选择结果).xls";
var filePath = webRootPath + tpath;
var di = new DirectoryInfo(filePath);
if (!di.Exists)
{
di.Create();
}
var fileHssf = new FileStream(filePath + fileName, FileMode.Create);
book.Write(fileHssf);
fileHssf.Close();
jm.code = 0;
jm.msg = GlobalConstVars.ExcelExportSuccess;
jm.data = tpath + fileName;
return(new JsonResult(jm));
}
public JsonResult GetAllControllerAndActionByAssembly()
{
var jm = new AdminUiCallBack();
var data = AdminsControllerPermission.GetAllControllerAndActionByAssembly();
jm.data = data.OrderBy(u => u.name).ToList();
jm.code = 0;
jm.msg = "获取成功";
return(new JsonResult(jm));
}
public async Task <JsonResult> GetManagerRoles()
{
var jm = new AdminUiCallBack();
var roles = await _sysRoleServices.QueryAsync();
jm.code = 0;
jm.msg = "数据获取正常";
jm.data = roles.Select(p => new { title = p.roleName, value = p.id });
return(new JsonResult(jm));
}
public async Task <JsonResult> GetSysMenu([FromBody] FMIntId entity)
{
var jm = new AdminUiCallBack();
var model = await _sysMenuServices.QueryListByClauseAsync(p => p.deleted == false && p.hide == false,
p => p.sortNumber, OrderByType.Asc);
if (model == null)
{
jm.msg = "不存在此信息";
return(new JsonResult(jm));
}
var roleMenus = await _sysRoleMenuServices.QueryListByClauseAsync(p => p.roleId == entity.id);
var list = new List <SysMenuTreeDto>();
if (model.Any())
{
model.ForEach(p =>
{
list.Add(new SysMenuTreeDto
{
authority = p.authority,
@checked = roleMenus.Exists(m => m.menuId == p.id),
children = null,
component = p.component,
createTime = p.createTime,
deleted = p.deleted,
hide = p.hide,
iconColor = p.iconColor,
menuName = p.menuName,
menuIcon = p.menuIcon,
menuType = p.menuType,
id = p.id,
open = true,
parentId = p.parentId,
parentName = "",
path = p.path,
sortNumber = p.sortNumber,
target = p.target,
updateTime = p.updateTime
});
});
}
jm.code = 0;
jm.data = list;
jm.otherData = new
{
entity,
roleMenus
};
return(new JsonResult(jm));
}
public async Task <object> RefreshToken(string token = "")
{
var jm = new AdminUiCallBack();
if (string.IsNullOrEmpty(token))
{
jm.code = 1001;
jm.msg = "token无效，请重新登录！";
return(new JsonResult(jm));
}
var tokenModel = JwtHelper.SerializeJwt(token);
if (tokenModel != null && tokenModel.Uid > 0)
{
var user = await _sysUserServices.QueryByIdAsync(tokenModel.Uid);
if (user != null)
{
var userRoles = await _sysUserServices.GetUserRoleNameStr(user.userName, user.passWord);
//如果是基于用户的授权策略，这里要添加用户;如果是基于角色的授权策略，这里要添加角色
var claims = new List <Claim> {
new Claim(ClaimTypes.Name, user.userName),
new Claim(JwtRegisteredClaimNames.Jti, tokenModel.Uid.ObjectToString()),
new Claim(ClaimTypes.Expiration, DateTime.Now.AddSeconds(_permissionRequirement.Expiration.TotalSeconds).ToString())
};
claims.AddRange(userRoles.Split(',').Select(s => new Claim(ClaimTypes.Role, s)));
//用户标识
var identity = new ClaimsIdentity(JwtBearerDefaults.AuthenticationScheme);
identity.AddClaims(claims);
var refreshToken = JwtToken.BuildJwtToken(claims.ToArray(), _permissionRequirement);
jm.code = 0;
jm.msg = "认证成功";
jm.data = refreshToken;
//插入登录日志
var log = new SysLoginRecord();
log.username = user.userName;
log.ip = _httpContextAccessor.HttpContext.Connection.RemoteIpAddress.MapToIPv4().ToString();
log.os = RuntimeInformation.OSDescription;
log.browser = _httpContextAccessor.HttpContext.Request.Headers[HeaderNames.UserAgent];
log.operType = (int)GlobalEnumVars.LoginRecordType.刷新Token;
log.createTime = DateTime.Now;
await _sysLoginRecordRepository.InsertAsync(log);
return(new JsonResult(jm));
}
}
jm.code = 1001;
jm.msg = "token无效，请重新登录！";
return(new JsonResult(jm));
}
public async Task <JsonResult> DoCreate([FromBody] SysUserRole entity)
{
var jm = new AdminUiCallBack();
var bl = await _sysUserRoleServices.InsertAsync(entity) > 0;
jm.code = bl ? 0 : 1;
jm.msg = bl ? GlobalConstVars.CreateSuccess : GlobalConstVars.CreateFailure;
return(new JsonResult(jm));
}
public async Task <JsonResult> DoBatchDelete([FromBody] FMArrayIntIds entity)
{
var jm = new AdminUiCallBack();
var bl = await _sysUserRoleServices.DeleteByIdsAsync(entity.id);
jm.code = bl ? 0 : 1;
jm.msg = bl ? GlobalConstVars.DeleteSuccess : GlobalConstVars.DeleteFailure;
return(new JsonResult(jm));
}
protected override async Task HandleForbiddenAsync(AuthenticationProperties properties)
{
Response.ContentType = "application/json";
//Response.StatusCode = StatusCodes.Status403Forbidden;
//await Response.WriteAsync(JsonConvert.SerializeObject(new ApiResponse(StatusCode.CODE403)));
var jm = new AdminUiCallBack();
jm.code = 403;
jm.msg = "很抱歉，您的访问权限等级不够，联系管理员!!";
await Response.WriteAsync(JsonConvert.SerializeObject(jm));
}
public async Task <JsonResult> DoCreate([FromBody] SysDictionaryData entity)
{
var jm = new AdminUiCallBack();
entity.createTime = DateTime.Now;
var bl = await _sysDictionaryDataServices.InsertAsync(entity) > 0;
jm.code = bl ? 0 : 1;
jm.msg = bl ? GlobalConstVars.CreateSuccess : GlobalConstVars.CreateFailure;
return(new JsonResult(jm));
}
protected override async Task HandleChallengeAsync(AuthenticationProperties properties)
{
Response.ContentType = "application/json";
//Response.StatusCode = StatusCodes.Status401Unauthorized;
//await Response.WriteAsync(JsonConvert.SerializeObject(new ApiResponse(StatusCode.CODE401)));
var jm = new AdminUiCallBack();
jm.code = 401;
jm.data = 401;
jm.msg = "很抱歉，您无权访问该接口，请确保已经登录!";
await Response.WriteAsync(JsonConvert.SerializeObject(jm));
}
public async Task <JsonResult> GetSysNLogRecords()
{
var jm = new AdminUiCallBack();
//获取数据
var list = await _sysNLogRecordsServices.QueryPageAsync(p => p.id > 0, p => p.id, OrderByType.Desc, 1, 10);
//返回数据
jm.data = list;
jm.code = 0;
jm.count = list.TotalCount;
jm.msg = "数据调用成功!";
return(new JsonResult(jm));
}
public async Task <JsonResult> EditLoginUserInfo([FromBody] EditLoginUserInfo entity)
{
var jm = new AdminUiCallBack();
var userModel = await _sysUserServices.QueryByIdAsync(_user.ID);
if (!string.IsNullOrEmpty(entity.nickName))
{
userModel.nickName = entity.nickName;
}
if (!string.IsNullOrEmpty(entity.avatar))
{
userModel.avatar = entity.avatar;
}
if (entity.sex > 0)
{
userModel.sex = entity.sex;
}
if (!string.IsNullOrEmpty(entity.phone))
{
userModel.phone = entity.phone;
}
if (!string.IsNullOrEmpty(entity.email))
{
userModel.email = entity.email;
}
if (!string.IsNullOrEmpty(entity.introduction))
{
userModel.introduction = entity.introduction;
}
if (!string.IsNullOrEmpty(entity.trueName))
{
userModel.trueName = entity.trueName;
}
if (!string.IsNullOrEmpty(entity.idCard))
{
userModel.idCard = entity.idCard;
}
if (entity.birthday != null)
{
userModel.birthday = entity.birthday;
}
userModel.updateTime = DateTime.Now;
var bl = await _sysUserServices.UpdateAsync(userModel);
jm.code = bl ? 0 : 1;
jm.msg = bl ? "修改成功" : "修改失败";
return(new JsonResult(jm));
}
public async Task <JsonResult> GetPageList()
{
var jm = new AdminUiCallBack();
//获取数据
var list = await _sysOrganizationServices.QueryAsync();
//返回数据
jm.data = list;
jm.code = 0;
jm.count = list.Count;
jm.msg = "数据调用成功!";
return(new JsonResult(jm));
}
public async Task <JsonResult> EditLoginUserPassWord([FromBody] FMEditLoginUserPassWord entity)
{
var jm = new AdminUiCallBack();
if (string.IsNullOrEmpty(entity.oldPassword))
{
jm.msg = "请键入旧密码";
return(new JsonResult(jm));
}
if (string.IsNullOrEmpty(entity.password))
{
jm.msg = "请键入新密码";
return(new JsonResult(jm));
}
if (string.IsNullOrEmpty(entity.repassword))
{
jm.msg = "请键入新密码确认密码";
return(new JsonResult(jm));
}
if (entity.password != entity.repassword)
{
jm.msg = "新密码与确认密码不相符";
return(new JsonResult(jm));
}
if (CommonHelper.Md5For32(entity.oldPassword) == CommonHelper.Md5For32(entity.password))
{
jm.msg = "新密码与旧密码相同,无需修改";
return(new JsonResult(jm));
}
var userModel = await _sysUserServices.QueryByIdAsync(_user.ID);
if (userModel.passWord != CommonHelper.Md5For32(entity.oldPassword))
{
jm.msg = "旧密码输入错误";
return(new JsonResult(jm));
}
userModel.passWord = CommonHelper.Md5For32(entity.password);
var bl = await _sysUserServices.UpdateAsync(userModel);
jm.code = bl ? 0 : 1;
jm.msg = bl ? "修改成功" : "修改失败";
return(new JsonResult(jm));
}
public async Task <JsonResult> GetUserInfo()
{
var jm = new AdminUiCallBack();
var userModel = await _sysUserServices.QueryByIdAsync(_user.ID);
jm.code = 0;
jm.msg = "数据获取正常";
jm.data = new
{
userModel.userName,
userModel.nickName,
userModel.createTime
};
return(new JsonResult(jm));
}
public async Task <JsonResult> GetCreate()
{
//返回数据
var userSexTypes = EnumHelper.EnumToList <GlobalEnumVars.UserSexTypes>();
var roles = await _sysRoleServices.QueryListByClauseAsync(p => p.deleted == false);
var jm = new AdminUiCallBack {
code = 0
};
jm.data = new { userSexTypes, roles };
return(new JsonResult(jm));
}
