/// <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); }