/// <summary>
/// 修改菜单
/// </summary>
/// <param name="request"></param>
/// <param name="loginInfo"></param>
/// <returns></returns>
public ServiceResult <bool> EditMenu(EditMenuRequest request, TRightsUser loginInfo)
{
var result = new ServiceResult <bool>
{
ReturnCode = ReturnCodeType.Error
};
var menu = _menuDao.GetById(request.Id);
if (menu != null)
{
menu.Name = request.Name;
menu.Url = request.Url;
menu.Icon = request.Icon;
menu.Sort = request.Sort;
menu.LastUpdatedBy = loginInfo.Id;
menu.LastUpdatedTime = DateTime.Now;
var rs = _menuDao.Update(menu);
if (rs == true)
{
result.ReturnCode = ReturnCodeType.Success;
result.Content = true;
}
}
return(result);
}
/// <summary>
/// 首次登录初始化密码
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public bool InitUserPwd(FirstLoginRequest request, TRightsUser loginInfo)
{
using (var conn = DapperHelper.CreateConnection())
{
//查询
var user = conn.Query <TRightsUser>(@"SELECT u.user_id AS UserId, u.user_name AS UserName, u.is_change_pwd AS IsChangePwd, u.enable_flag AS EnableFlag, u.created_by AS CreatedBy,
u.created_time AS CreatedTime, u.last_updated_by AS LastUpdatedBy, u.last_updated_time AS LastUpdatedTime,*
FROM dbo.t_rights_user AS u
WHERE u.id= @Id;", new { @Id = request.Id }).FirstOrDefault();
if (user != null)
{
//更新
var effectRows = conn.Execute(@"UPDATE dbo.t_rights_user SET is_change_pwd= 1, password= @Password, last_updated_by= @LastUpdatedBy, last_updated_time= @LastUpdatedTime WHERE id= @Id;",
new
{
@Password = request.NewPwd,
@Id = request.Id,
@LastUpdatedBy = loginInfo.Id,
@LastUpdatedTime = DateTime.Now
});
if (effectRows > 0)
{
return(true);
}
}
}
return(false);
}
/// <summary>
/// 插入
/// </summary>
/// <param name="request"></param>
/// <param name="loginInfo"></param>
/// <returns></returns>
public ServiceResult <bool> Insert(InsertDebugLogBlackListRequest request, TRightsUser loginInfo)
{
var result = new ServiceResult <bool>
{
ReturnCode = ReturnCodeType.Error
};
var currentTime = DateTime.Now;
var item = new TLogsDebugLogBlackList
{
SystemCode = request.SystemCode,
Source = request.Source,
MachineName = request.MachineName,
IpAddress = request.IpAddress,
ClientIp = request.ClientIp,
AppdomainName = request.AppdomainName,
Message = request.Message,
IsRegex = request.IsRegex,
CreatedBy = loginInfo.Id,
CreatedTime = currentTime,
LastUpdatedBy = loginInfo.Id,
LastUpdatedTime = currentTime
};
var rs = _debugLogBlackListDao.Insert(item);
if (rs == true)
{
result.ReturnCode = ReturnCodeType.Success;
result.Content = true;
}
return(result);
}
/// <summary>
/// 新增机构
/// </summary>
/// <param name="request">request</param>
/// <returns></returns>
public ServiceResult <bool> AddOrganization(AddOrganizationRequest request, TRightsUser loginInfo)
{
var result = new ServiceResult <bool>
{
ReturnCode = ReturnCodeType.Error
};
var currentTime = DateTime.Now;
var item = new TRightsOrganization
{
Name = request.Name,
ParentId = request.ParentId,
Code = request.Code,
Sort = request.Sort,
EnableFlag = true,
CreatedBy = loginInfo.Id,
CreatedTime = currentTime,
LastUpdatedBy = loginInfo.Id,
LastUpdatedTime = currentTime
};
var rs = orgDao.Insert(item);
if (rs == true)
{
result.ReturnCode = ReturnCodeType.Success;
result.Content = true;
}
return(result);
}
/// <summary>
/// 修改按钮
/// </summary>
/// <param name="request"></param>
/// <param name="loginInfo"></param>
/// <returns></returns>
public ServiceResult <bool> EditButton(EditButtonRequest request, TRightsUser loginInfo)
{
//校验按钮名称
var result = new ServiceResult <bool>
{
ReturnCode = ReturnCodeType.Error
};
var button = _btnDao.GetButtonByName(request.Name);
if (request.Name != request.OriginalName && button != null)
{
result.Message = "已存在相同名称的按钮!";
return(result);
}
var btn = _btnDao.GetById(request.Id);
if (btn != null)
{
btn.Name = request.Name;
btn.Icon = request.Icon;
btn.Sort = request.Sort;
btn.LastUpdatedBy = loginInfo.Id;
btn.LastUpdatedTime = DateTime.Now;
var rs = _btnDao.Update(btn);
if (rs == true)
{
result.ReturnCode = ReturnCodeType.Success;
result.Content = true;
}
}
return(result);
}
/// <summary>
/// 添加菜单
/// </summary>
/// <param name="request"></param>
/// <param name="loginInfo"></param>
/// <returns></returns>
public ServiceResult <bool> AddMenu(AddMenuRequest request, TRightsUser loginInfo)
{
var result = new ServiceResult <bool>
{
ReturnCode = ReturnCodeType.Error
};
var currentTime = DateTime.Now;
var menu = new TRightsMenu
{
Name = request.Name,
ParentId = request.ParentId,
Code = request.Code,
Url = request.Url,
Icon = request.Icon,
Sort = request.Sort,
CreatedBy = loginInfo.Id,
CreatedTime = currentTime,
LastUpdatedBy = loginInfo.Id,
LastUpdatedTime = currentTime
};
var rs = _menuDao.Insert(menu);
if (rs == true)
{
result.ReturnCode = ReturnCodeType.Success;
result.Content = true;
}
return(result);
}
/// <summary>
/// 依据userId获取用户
/// </summary>
/// <param name="userId"></param>
/// <returns>存在则返回实体对象，不存在则返回null</returns>
public TRightsUser GetByUserId(string userId)
{
TRightsUser result = null;
using (var conn = DapperHelper.CreateConnection())
{
var query = conn.Query <TRightsUser>(@"SELECT TOP 1 * FROM dbo.t_rights_user AS u WHERE u.user_id= @UserId;", new { @UserId = userId }).ToList();
result = query.FirstOrDefault();
}
return(result);
}
/// <summary>
/// Action执行前调用
/// </summary>
/// <param name="filterContext"></param>
protected override void OnActionExecuting(ActionExecutingContext filterContext)
{
base.OnActionExecuting(filterContext);
if (filterContext.HttpContext.Request.IsAuthenticated)
{
FormsIdentity id = (FormsIdentity)filterContext.HttpContext.User.Identity;
FormsAuthenticationTicket tickets = id.Ticket;
loginInfo = tickets.UserData.FromJson <TRightsUser>();
}
}
/// <summary>
/// 依id查询
/// </summary>
/// <param name="id">id</param>
/// <returns></returns>
public TRightsUser GetById(int id)
{
TRightsUser result = null;
using (var conn = DapperHelper.CreateConnection())
{
result = conn.Query <TRightsUser>(@"SELECT u.user_id AS UserId, u.user_name AS UserName, u.is_change_pwd AS IsChangePwd, u.enable_flag AS EnableFlag,
u.created_by AS CreatedBy, u.created_time AS CreatedTime, u.last_updated_by AS LastUpdatedBy, u.last_updated_time AS LastUpdatedTime,*
FROM dbo.t_rights_user AS u WHERE u.id= @Id;", new { @Id = id }).FirstOrDefault();
}
return(result);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="item">待更新的记录</param>
/// <returns></returns>
public bool Update(TRightsUser item)
{
using (var conn = DapperHelper.CreateConnection())
{
var effectRows = conn.Execute(@"UPDATE dbo.t_rights_user SET user_id= @UserId, user_name= @UserName, enable_flag= @EnableFlag, is_change_pwd= @IsChangePwd, last_updated_by= @LastUpdatedBy, last_updated_time= @LastUpdatedTime WHERE id= @Id;", item);
if (effectRows > 0)
{
return(true);
}
}
return(false);
}
/// <summary>
/// 插入
/// </summary>
/// <param name="item">待插入的记录</param>
public bool Insert(TRightsUser item)
{
using (var conn = DapperHelper.CreateConnection())
{
var effectRows = conn.Execute(@"INSERT INTO dbo.t_rights_user VALUES ( @UserId ,@Password ,@UserName ,@IsChangePwd ,@EnableFlag ,@CreatedBy ,@CreatedTime ,@LastUpdatedBy ,@LastUpdatedTime);", item);
if (effectRows > 0)
{
return(true);
}
}
return(false);
}
/// <summary>
/// 检查登录
/// </summary>
/// <param name="request"></param>
/// <returns>成功返回实体对象，失败返回null</returns>
public TRightsUser CheckLogin(CheckLoginRequest request)
{
TRightsUser user = null;
using (var conn = DapperHelper.CreateConnection())
{
user = conn.Query <TRightsUser>(@"SELECT u.id, u.user_id AS UserId, u.password, u.user_name AS UserName, u.is_change_pwd AS IsChangePwd, u.enable_flag AS EnableFlag,
u.created_by AS CreatedBy, u.created_time AS CreatedTime, u.last_updated_by AS LastUpdatedBy, u.last_updated_time AS LastUpdatedTime
FROM dbo.t_rights_user AS u
WHERE u.user_id= @UserId AND u.password= @Password;", new { @UserId = request.loginId, @Password = request.loginPwd }).FirstOrDefault();
}
return(user);
}
/// <summary>
/// 首次登录初始化密码
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public ServiceResult <bool> InitUserPwd(FirstLoginRequest request, TRightsUser loginInfo)
{
var result = new ServiceResult <bool>
{
ReturnCode = ReturnCodeType.Error
};
if (accountDao.InitUserPwd(request, loginInfo))
{
result.ReturnCode = ReturnCodeType.Success;
result.Content = true;
}
return(result);
}
/// <summary>
/// 修改密码
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public ServiceResult <bool> ChangePwd(ChangePwdRequest request, TRightsUser loginInfo)
{
var result = new ServiceResult <bool>
{
ReturnCode = ReturnCodeType.Error
};
if (_accountDao.ChangePwd(request, loginInfo))
{
result.ReturnCode = ReturnCodeType.Success;
result.Content = true;
}
return(result);
}
/// <summary>
/// 新增按钮
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public ServiceResult <bool> AddButton(AddButtonRequest request, TRightsUser loginInfo)
{
//校验按钮名称和标识码
var result = new ServiceResult <bool>
{
ReturnCode = ReturnCodeType.Error
};
var buttonByName = _btnDao.GetButtonByName(request.Name);
if (buttonByName != null)
{
result.Message = "已存在相同名称的按钮!";
return(result);
}
var buttonByCode = _btnDao.GetButtonByCode(request.Code);
if (buttonByCode != null)
{
result.Message = "已存在相同标识码的按钮!";
return(result);
}
var currentTime = DateTime.Now;
var btn = new TRightsButton
{
Name = request.Name,
Code = request.Code,
Icon = request.Icon,
Sort = request.Sort,
CreatedBy = loginInfo.Id,
CreatedTime = currentTime,
LastUpdatedBy = loginInfo.Id,
LastUpdatedTime = currentTime
};
var rs = _btnDao.Insert(btn);
if (rs == true)
{
result.ReturnCode = ReturnCodeType.Success;
result.Content = true;
}
return(result);
}
/// <summary>
/// 新增用户
/// </summary>
/// <param name="request"></param>
/// <param name="loginInfo"></param>
/// <returns></returns>
public ServiceResult <bool> AddUser(AddUserRequest request, TRightsUser loginInfo)
{
//新增用户前需要检查userId是否存在
var result = new ServiceResult <bool>
{
ReturnCode = ReturnCodeType.Error
};
var existUser = userDao.GetByUserId(request.UserId);
if (existUser != null)
{
result.Message = "已存在该用户,请更换其它用户id!";
return(result);
}
var currentTime = DateTime.Now;
var item = new TRightsUser
{
UserId = request.UserId,
Password = EncryptHelper.MD5With32bit("123456"),//默认密码为123456
UserName = request.UserName,
IsChangePwd = request.IsChangePwd,
EnableFlag = request.EnableFlag,
CreatedBy = loginInfo.Id,
CreatedTime = currentTime,
LastUpdatedBy = loginInfo.Id,
LastUpdatedTime = currentTime
};
var rs = userDao.Insert(item);
if (rs == true)
{
result.ReturnCode = ReturnCodeType.Success;
result.Content = true;
}
return(result);
}
/// <summary>
/// 新增角色
/// </summary>
/// <param name="request"></param>
/// <param name="loginInfo"></param>
/// <returns></returns>
public ServiceResult <bool> AddRole(AddRoleRequest request, TRightsUser loginInfo)
{
//需要检查是否已存在相同名称的角色
var result = new ServiceResult <bool>
{
ReturnCode = ReturnCodeType.Error
};
var role = _roleDao.GetRoleByName(request.Name);
if (role != null)
{
result.Message = "已存在相同名称的角色!";
return(result);
}
var currentTime = DateTime.Now;
var item = new TRightsRole
{
Name = request.Name,
Description = request.Description,
OrganizationId = request.OrgId,
CreatedBy = loginInfo.Id,
CreatedTime = currentTime,
LastUpdatedBy = loginInfo.Id,
LastUpdatedTime = currentTime
};
var rs = _roleDao.Insert(item);
if (rs == true)
{
result.ReturnCode = ReturnCodeType.Success;
result.Content = true;
}
return(result);
}
/// <summary>
/// 修改用户
/// </summary>
/// <param name="request"></param>
/// <param name="loginInfo"></param>
/// <returns></returns>
public ServiceResult <bool> EditUser(EditUserRequest request, TRightsUser loginInfo)
{
//先要检查新的userId是否已经存在，不存在才能继续修改
var result = new ServiceResult <bool>
{
ReturnCode = ReturnCodeType.Error
};
var user = userDao.GetByUserId(request.NewUserId);
if (request.NewUserId != request.OriginalUserId && user != null)
{
result.Message = "已存在该用户,请更换其它用户id!";
return(result);
}
var item = userDao.GetById(request.Id);
if (item != null)
{
item.UserId = request.NewUserId;
item.UserName = request.NewUserName;
item.EnableFlag = request.EnableFlag;
item.IsChangePwd = request.IsChangePwd;
item.LastUpdatedBy = loginInfo.Id;
item.LastUpdatedTime = DateTime.Now;
var rs = userDao.Update(item);
if (rs == true)
{
result.ReturnCode = ReturnCodeType.Success;
result.Content = true;
}
}
return(result);
}
/// <summary>
/// 修改角色
/// </summary>
/// <param name="request"></param>
/// <param name="loginInfo"></param>
/// <returns></returns>
public ServiceResult <bool> EditRole(EditRoleRequest request, TRightsUser loginInfo)
{
//需要检查是否已存在相同名称的角色
var result = new ServiceResult <bool>
{
ReturnCode = ReturnCodeType.Error
};
var role = _roleDao.GetRoleByName(request.NewName);
if (request.NewName != request.OriginalName && role != null)
{
result.Message = "已存在相同名称的角色!";
return(result);
}
var item = _roleDao.GetById(request.Id);
if (item != null)
{
item.Name = request.NewName;
item.Description = request.Description;
item.OrganizationId = request.OrgId;
item.LastUpdatedBy = loginInfo.Id;
item.LastUpdatedTime = DateTime.Now;
var rs = _roleDao.Update(item);
if (rs == true)
{
result.ReturnCode = ReturnCodeType.Success;
result.Content = true;
}
}
return(result);
}
/// <summary>
/// 修改机构
/// </summary>
/// <param name="request"></param>
/// <param name="loginInfo"></param>
/// <returns></returns>
public ServiceResult <bool> EditOrganization(EditOrganizationRequest request, TRightsUser loginInfo)
{
//先查询出来再修改
var result = new ServiceResult <bool>
{
ReturnCode = ReturnCodeType.Error
};
var org = orgDao.GetById(request.Id);
if (org != null)
{
org.Id = request.Id;
org.Name = request.Name;
org.Sort = request.Sort;
org.ParentId = request.ParentId;
org.LastUpdatedBy = loginInfo.Id;
org.LastUpdatedTime = DateTime.Now;
var rs = orgDao.Update(org);
if (rs == true)
{
result.ReturnCode = ReturnCodeType.Success;
result.Content = true;
}
}
return(result);
}
