/// <summary>
/// 删除用户
/// </summary>
/// <param name="privilegeMasterUserId">用户Id</param>
/// <param name="privilegeMaster">归属人员类型:组织机构、角色</param>
/// <returns></returns>
public Task <bool> DeletePrivilegeMasterUser(string privilegeMasterUserId, EnumPrivilegeMaster privilegeMaster)
{
const string sql = "DELETE FROM System_PermissionUser WHERE PrivilegeMaster=@privilegeMaster AND PrivilegeMasterUserId=@privilegeMasterUserId";
return(SqlMapperUtil.InsertUpdateOrDeleteSqlBool(sql,
new { privilegeMaster = (byte)privilegeMaster, privilegeMasterUserId }));
}
/// <summary>
/// 保存用户权限类型
/// </summary>
/// <param name="privilegeMaster">类型</param>
/// <param name="privilegeMasterUserId">业务表Id：如组织机构Id、组Id、岗位Id、人员Id等</param>
/// <param name="privilegeMasterValue">权限类型:角色Id</param>
/// <returns></returns>
public async Task <OperateStatus> SavePermissionMasterValueBeforeDelete(EnumPrivilegeMaster privilegeMaster,
Guid privilegeMasterUserId,
IList <Guid> privilegeMasterValue)
{
var operateStatus = new OperateStatus();
//删除
await _permissionUsernRepository.DeletePermissionMaster(privilegeMaster, privilegeMasterUserId);
IList <SystemPermissionUser> systemPermissionUsers =
privilegeMasterValue.Select(roleId => new SystemPermissionUser
{
PrivilegeMaster = (byte)privilegeMaster,
PrivilegeMasterUserId = privilegeMasterUserId,
PrivilegeMasterValue = roleId
}).ToList();
if (systemPermissionUsers.Any())
{
//批量保存
operateStatus = await InsertMultipleAsync(systemPermissionUsers);
}
else
{
operateStatus.ResultSign = ResultSign.Successful;
operateStatus.Message = Chs.Successful;
}
return(operateStatus);
}
public async Task <JsonResult> DeletePrivilegeMasterUser(Guid privilegeMasterUserId,
Guid privilegeMasterValue,
EnumPrivilegeMaster privilegeMaster)
{
return
(Json(await _permissionUserLogic.DeletePrivilegeMasterUser(privilegeMasterUserId, privilegeMasterValue,
privilegeMaster)));
}
/// <summary>
/// 根据用户Id删除用户归属类型
/// </summary>
/// <param name="privilegeMaster">归属人员类型:组织机构、角色、岗位、组</param>
/// <param name="privilegeMasterUserId">用户Id</param>
/// <returns></returns>
public Task <int> DeletePermissionMaster(EnumPrivilegeMaster privilegeMaster,
Guid privilegeMasterUserId)
{
const string sql = "DELETE FROM System_PermissionUser WHERE PrivilegeMaster=@privilegeMaster AND PrivilegeMasterUserId=@privilegeMasterUserId";
return(SqlMapperUtil.InsertUpdateOrDeleteSql <SystemPermissionUser>(sql,
new { privilegeMaster = (byte)privilegeMaster, privilegeMasterUserId }));
}
/// <summary>
/// 根据特权类型及特权id获取特权用户信息
/// </summary>
/// <param name="privilegeMaster">特权类型</param>
/// <param name="privilegeMasterValue">特权id</param>
/// <returns></returns>
public async Task <IEnumerable <SystemPermissionUser> > GetPermissionUsersByPrivilegeMasterAdnPrivilegeMasterValue(
EnumPrivilegeMaster privilegeMaster,
Guid?privilegeMasterValue = null)
{
return
(await
_permissionUsernRepository.GetPermissionUsersByPrivilegeMasterAdnPrivilegeMasterValue(
privilegeMaster, privilegeMasterValue));
}
public ViewResultBase PrivilegeMasterUser(EnumPrivilegeMaster privilegeMaster,
Guid privilegeMasterValue)
{
return(View(new SystemPermissionUserModel
{
PrivilegeMasterValue = privilegeMasterValue,
PrivilegeMaster = (byte)privilegeMaster
}));
}
public async Task <JsonResult> SavePrivilegeMasterUser(string privilegeMasterUser,
Guid privilegeMasterValue,
EnumPrivilegeMaster privilegeMaster)
{
var models = JsonConvert.DeserializeObject <IList <SystemPermissionSaveUserInput> >(privilegeMasterUser);
IList <Guid> users = models.Select(m => m.U).ToList();
return(Json(await _permissionUserLogic.SavePermissionUserBeforeDelete(privilegeMaster, privilegeMasterValue, users)));
}
/// <summary>
/// 获取该用户已经具有的角色信息
/// </summary>
/// <param name="privilegeMaster"></param>
/// <param name="userId">需要查询的用户id</param>
/// <returns></returns>
public Task <IEnumerable <SystemRoleOutput> > GetHaveUserRole(EnumPrivilegeMaster privilegeMaster,
Guid userId)
{
var sql = new StringBuilder(@"SELECT * FROM System_Role ro
LEFT JOIN System_PermissionUser per ON per.PrivilegeMasterValue=ro.RoleId
WHERE per.PrivilegeMasterUserId=@userId AND PrivilegeMaster=@privilegeMaster");
return(SqlMapperUtil.SqlWithParams <SystemRoleOutput>(sql.ToString(),
new { privilegeMaster = (byte)privilegeMaster, userId }));
}
/// <summary>
/// 根据特性id删除权限用户信息
/// </summary>
/// <param name="privilegeMaster">特性类型：组织机构、角色等</param>
/// <param name="privilegeMasterValue">特性类型：组织机构、角色等</param>
/// <returns></returns>
public Task <bool> DeletePermissionUser(EnumPrivilegeMaster privilegeMaster, Guid privilegeMasterValue)
{
const string sql = "DELETE FROM Columns WHERE PrivilegeMaster=@privilegeMaster AND PrivilegeMasterValue=@privilegeMasterValue";
return(SqlMapperUtil.InsertUpdateOrDeleteSqlBool(sql,
new
{
privilegeMaster = (byte)privilegeMaster,
privilegeMasterValue
}));
}
/// <summary>
/// 根据特性id删除权限用户信息
/// </summary>
/// <param name="privilegeMaster">特性类型：组织机构、角色等</param>
/// <param name="privilegeMasterValue">特性类型：组织机构、角色等</param>
/// <returns></returns>
public async Task <bool> DeletePermissionUser(EnumPrivilegeMaster privilegeMaster, Guid privilegeMasterValue)
{
const string sql = "DELETE FROM Columns WHERE PrivilegeMaster=@privilegeMaster AND PrivilegeMasterValue=@privilegeMasterValue";
return((await this.DbConnection.ExecuteAsync(sql,
new
{
privilegeMaster = (byte)privilegeMaster,
privilegeMasterValue
})) > 0);
}
public async Task <JsonResult> SavePrivilegeMasterUser(string privilegeMasterUser,
Guid privilegeMasterValue,
EnumPrivilegeMaster privilegeMaster)
{
IList <SystemPermissionUserModel> models = privilegeMasterUser.JsonStringToList <SystemPermissionUserModel>();
IList <Guid> users = models.Select(m => m.U).ToList();
return
(Json(
await
_permissionUserLogic.SavePermissionUserBeforeDelete(privilegeMaster, privilegeMasterValue, users)));
}
/// <summary>
/// 保存各种用户:组织机构、岗位、组、人员
/// </summary>
/// <param name="master">类型</param>
/// <param name="value">业务表Id：如组织机构Id、组Id、岗位Id、人员Id等</param>
/// <param name="userIds">权限类型:组织机构、组、岗位、人员Id</param>
/// <returns></returns>
public async Task <OperateStatus> SavePermissionUser(EnumPrivilegeMaster master,
Guid value,
IList <Guid> userIds)
{
IList <SystemPermissionUser> systemPermissionUsers = userIds.Select(userId => new SystemPermissionUser
{
PrivilegeMaster = (byte)master,
PrivilegeMasterUserId = userId,
PrivilegeMasterValue = value
}).ToList();
//批量保存
return(await InsertMultipleAsync(systemPermissionUsers));
}
/// <summary>
/// 根据特权类型及特权id获取特权用户信息
/// </summary>
/// <param name="privilegeMaster">特权类型</param>
/// <param name="privilegeMasterValue">特权id</param>
/// <returns></returns>
public Task <IEnumerable <SystemPermissionUser> > GetPermissionUsersByPrivilegeMasterAdnPrivilegeMasterValue(
EnumPrivilegeMaster privilegeMaster,
Guid?privilegeMasterValue = null)
{
var sql =
new StringBuilder("SELECT * FROM System_PermissionUser WHERE PrivilegeMaster=@privilegeMaster");
if (privilegeMasterValue != null)
{
sql.Append(" AND PrivilegeMasterValue=@privilegeMasterValue");
}
return(SqlMapperUtil.SqlWithParams <SystemPermissionUser>(sql.ToString(),
new { privilegeMaster, privilegeMasterValue }));
}
/// <summary>
/// 删除用户
/// </summary>
/// <param name="privilegeMasterUserId">用户Id</param>
/// <param name="privilegeMasterValue">归属类型Id:组织机构、角色、岗位、组</param>
/// <param name="privilegeMaster">归属人员类型:组织机构、角色、岗位、组</param>
/// <returns></returns>
public async Task <OperateStatus> DeletePrivilegeMasterUser(Guid privilegeMasterUserId,
Guid privilegeMasterValue,
EnumPrivilegeMaster privilegeMaster)
{
var operateStatus = new OperateStatus();
if (
await _permissionUsernRepository.DeletePrivilegeMasterUser(privilegeMasterUserId, privilegeMasterValue,
privilegeMaster) > 0)
{
operateStatus.ResultSign = ResultSign.Successful;
operateStatus.Message = Chs.Successful;
}
return(operateStatus);
}
/// <summary>
/// 保存各种用户:组织机构、人员
/// </summary>
/// <param name="master">类型</param>
/// <param name="value">业务表Id：如组织机构Id、人员Id等</param>
/// <param name="userids">权限类型:组织机构、人员Id</param>
/// <returns></returns>
public async Task <OperateStatus> SavePermissionUser(EnumPrivilegeMaster master, string value, IList <string> userids)
{
OperateStatus operateStatus = new OperateStatus();
IList <SystemPermissionUser> systemPermissionUsers = userids.Select(userId => new SystemPermissionUser
{
PrivilegeMaster = (byte)master,
PrivilegeMasterUserId = userId,
PrivilegeMasterValue = value
}).ToList();
//批量保存
foreach (var item in systemPermissionUsers)
{
operateStatus = await InsertAsync(item);
}
return(operateStatus);
}
public async Task <ViewResultBase> ChosenPrivilegeMasterUser(EnumPrivilegeMaster privilegeMaster,
Guid privilegeMasterValue)
{
//获取所有人员信息
IList <SystemChosenUserOutput> chosenUserDtos = (await _userInfoLogic.GetChosenUser()).ToList();
//获取所有的用户
var permissions =
await
_permissionUserLogic.GetPermissionUsersByPrivilegeMasterAdnPrivilegeMasterValue(privilegeMaster,
privilegeMasterValue);
foreach (var dto in chosenUserDtos)
{
var permission = permissions.Where(w => w.PrivilegeMasterUserId == dto.UserId).FirstOrDefault();
dto.Exist = permission != null;
}
return(View(chosenUserDtos.OrderByDescending(w => w.Exist).ToList()));
}
/// <summary>
/// 查询对应拥有的功能项菜单信息
/// </summary>
/// <param name="privilegeMasterValue">信息</param>
/// <param name="privilegeMaster"></param>
/// <returns></returns>
public async Task <IEnumerable <SystemData> > GetDataByPrivilegeMaster(Guid privilegeMasterValue,
EnumPrivilegeMaster privilegeMaster)
{
IList <SystemData> datas = new List <SystemData>();
//获取拥有的菜单信息
var menus = await GetMenuHavePermissionByPrivilegeMasterValue(new GetMenuHavePermissionByPrivilegeMasterValueInput
{
PrivilegeMasterValue = privilegeMasterValue,
PrivilegeMaster = privilegeMaster,
PrivilegeAccess = EnumPrivilegeAccess.数据权限
});
//获取拥有的功能项信息
IList <SystemPermission> haveDatas = (await
GetPermissionByPrivilegeMasterValue(
new GetPermissionByPrivilegeMasterValueInput()
{
PrivilegeAccess = EnumPrivilegeAccess.数据权限,
PrivilegeMasterValue = privilegeMasterValue,
PrivilegeMaster = privilegeMaster
})).ToList();
//获取所有功能项
IList <SystemDataDoubleWayDto> functionDtos = (await _dataRepository.GetDataByMenuId()).ToList();
foreach (var menu in menus)
{
var function = functionDtos.Where(w => w.MenuId == (Guid)menu.id).OrderBy(o => o.OrderNo);
foreach (var f in function)
{
var selectFunction = haveDatas.Where(w => w.PrivilegeAccessValue == f.DataId);
f.Remark = selectFunction.Any() ? "selected" : "";
datas.Add(f);
}
}
return(datas);
}
public async Task <ViewResultBase> Data(Guid privilegeMasterValue,
EnumPrivilegeMaster privilegeMaster)
{
return(View((await _permissionLogic.GetDataByPrivilegeMaster(privilegeMasterValue, privilegeMaster)).ToList()));
}
public async Task <ViewResultBase> Function(Guid privilegeMasterValue,
EnumPrivilegeMaster privilegeMaster)
{
//获取所有模块按钮
return(View((await _permissionLogic.GetFunctionByPrivilegeMaster(privilegeMasterValue, privilegeMaster)).ToList()));
}
public async Task <JsonResult> GetDataByPrivilegeMaster(Guid privilegeMasterValue,
EnumPrivilegeMaster privilegeMaster)
{
//获取所有模块按钮
return(Json((await _permissionLogic.GetDataByPrivilegeMaster(privilegeMasterValue, privilegeMaster)).ToList()));
}
/// <summary>
/// 获取该用户已经具有的角色信息
/// </summary>
/// <param name="privilegeMaster"></param>
/// <param name="userId">需要查询的用户id</param>
/// <returns></returns>
public async Task <IEnumerable <SystemRole> > GetHaveUserRole(EnumPrivilegeMaster privilegeMaster,
Guid userId)
{
return(await _roleRepository.GetHaveUserRole(privilegeMaster, userId));
}
/// <summary>
/// 查询对应拥有的功能项菜单信息
/// </summary>
/// <param name="privilegeMasterValue">信息</param>
/// <param name="privilegeMaster"></param>
/// <returns></returns>
public async Task <IEnumerable <SystemMenuButton> > GetFunctionByPrivilegeMaster(Guid privilegeMasterValue,
EnumPrivilegeMaster privilegeMaster)
{
IList <SystemMenuButton> functions = new List <SystemMenuButton>();
//获取拥有的菜单信息
var menus = await GetMenuHavePermissionByPrivilegeMasterValue(new GetMenuHavePermissionByPrivilegeMasterValueInput
{
PrivilegeMasterValue = privilegeMasterValue,
PrivilegeMaster = privilegeMaster,
PrivilegeAccess = EnumPrivilegeAccess.菜单按钮
});
//获取拥有的功能项信息
IList <SystemPermission> haveFunctions =
(await GetPermissionByPrivilegeMasterValue(
new GetPermissionByPrivilegeMasterValueInput()
{
PrivilegeAccess = EnumPrivilegeAccess.菜单按钮,
PrivilegeMasterValue = privilegeMasterValue,
PrivilegeMaster = privilegeMaster
})).ToList();
//获取所有功能项
IList <SystemMenuButtonOutput> functionDtos = (await _menuButtonRepository.GetMenuButtonByMenuId()).ToList();
foreach (var menu in menus)
{
var function = functionDtos.Where(w => w.MenuId == (Guid)menu.id).OrderBy(o => o.OrderNo);
foreach (var f in function)
{
var selectFunction = haveFunctions.Where(w => w.PrivilegeAccessValue == f.MenuButtonId);
f.Remark = selectFunction.Any() ? "selected" : "";
functions.Add(f);
}
}
return(functions);
}
/// <summary>
/// 删除用户
/// </summary>
/// <param name="privilegeMasterUserId">用户Id</param>
/// <param name="privilegeMaster">归属人员类型:组织机构、角色</param>
/// <returns></returns>
public async Task <bool> DeletePrivilegeMasterUser(string privilegeMasterUserId, EnumPrivilegeMaster privilegeMaster)
{
const string sql = "DELETE FROM System_PermissionUser WHERE PrivilegeMaster=@privilegeMaster AND PrivilegeMasterUserId=@privilegeMasterUserId";
return(await this.DbConnection.ExecuteAsync(sql, new { privilegeMaster = (byte)privilegeMaster, privilegeMasterUserId }) > 0);
}
/// <summary>
/// 获取角色，组等具有的权限
/// </summary>
/// <param name="privilegeMaster">类型:角色，人员，组等</param>
/// <param name="privilegeMasterValue">对应值</param>
/// <returns></returns>
public async Task <IEnumerable <SystemPermission> > GetSystemPermissionsByPrivilegeMasterValueAndValue(EnumPrivilegeMaster privilegeMaster,
Guid?privilegeMasterValue = null)
{
return((await _permissionRepository.GetSystemPermissionsByPrivilegeMasterValueAndValue(privilegeMaster, privilegeMasterValue)).ToList());
}
