public ActionResult SetRole(SetRoleRequest request)
{
var flag = false;
var msg = string.Empty;
if (request.RoleIds.IsNullOrEmpty())
{
msg = "请选择角色!";
return(Json(new { success = flag, msg = msg }, JsonRequestBehavior.AllowGet));
}
var rs = _userService.SetRole(request);
if (rs.ReturnCode == ReturnCodeType.Success && rs.Content == true)
{
flag = true;
msg = "设置角色成功!";
}
else
{
msg = rs.Message.IsNullOrEmpty() ? "设置角色失败!" : rs.Message;
}
return(Json(new { success = flag, msg = msg }, JsonRequestBehavior.AllowGet));
}
public ActionResult SetRole(SetRoleRequest request)
{
var flag = false;
var msg = string.Empty;
if (request.RoleIds.IsNullOrEmpty())
{
msg = "请选择角色!";
return(Json(new { success = flag, msg = msg }, JsonRequestBehavior.AllowGet));
}
using (var factory = new ChannelFactory <IRightsUserService>("*"))
{
var client = factory.CreateChannel();
var rs = client.SetRole(request);
if (rs.ReturnCode == ReturnCodeType.Success && rs.Content == true)
{
flag = true;
msg = "设置角色成功!";
}
else
{
msg = rs.Message.IsNullOrEmpty() ? "设置角色失败!" : rs.Message;
}
}
return(Json(new { success = flag, msg = msg }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 为所选用户设置角色(支持批量)
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public bool SetRole(SetRoleRequest request)
{
//先删除所选用户原来的拥有角色
//再新增所选用户选择的新角色
//使用事务
var result = false;
var userIds = request.UserIds.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries).Select(p => p.ToInt()).OrderBy(p => p).ToList();
var roleIds = request.RoleIds.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries).Select(p => p.ToInt()).OrderBy(p => p).ToList();
var addUserRoles = new List <TRightsUserRole>();//待添加的用户角色
foreach (var userId in userIds)
{
foreach (var roleId in roleIds)
{
var addUserRole = new TRightsUserRole()
{
UserId = userId,
RoleId = roleId
};
addUserRoles.Add(addUserRole);
}
}
using (var conn = DapperHelper.CreateConnection())
{
var trans = conn.BeginTransaction();
try
{
//先删除
conn.Execute(@"DELETE FROM dbo.t_rights_user_role WHERE user_id IN @UserIds;", new { @UserIds = userIds }, trans);
//后添加
conn.Execute(@"INSERT INTO dbo.t_rights_user_role VALUES ( @UserId,@RoleId);", addUserRoles, trans);
trans.Commit();
result = true;
}
catch (Exception ex)
{
trans.Rollback();
}
}
return(result);
}
/// <summary>
/// 为所选用户设置角色(支持批量)
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public ServiceResult <bool> SetRole(SetRoleRequest request)
{
//先删除所选用户原来的拥有角色
//再新增所选用户选择的新角色
var result = new ServiceResult <bool>
{
ReturnCode = ReturnCodeType.Error
};
var rs = userDao.SetRole(request);
if (rs == true)
{
result.ReturnCode = ReturnCodeType.Success;
result.Content = true;
}
return(result);
}
