/// <summary> /// 给用户赋予角色 /// </summary> /// <param name="userID"></param> /// <param name="roleIDS"></param> /// <returns></returns> public static RtnMessage SetUserRoles(int userID, int[] roleIDS) { RtnMessage rtnMsg = new RtnMessage(); rtnMsg.Code = 0; using (var db = new Database(new MySqlConnection(ConnString))) { try { using (var scope = db.GetTransaction()) { db.Delete <Sys_User_Role>($"WHERE UserID={userID}"); foreach (var item in roleIDS) { Sys_User_Role entity = new Sys_User_Role() { UserID = userID, RoleID = item }; db.Insert("Sys_User_Role", "ID", entity); } scope.Complete(); } } catch (Exception ex) { rtnMsg.Code = -1; db.AbortTransaction(); rtnMsg.Message = ex.Message; return(rtnMsg); } } return(rtnMsg); }
public static RtnMessage DeleteRoles(List <Sys_Roles> list) { RtnMessage rtnMsg = new RtnMessage(); rtnMsg.Code = 0; using (var db = new Database(new MySqlConnection(ConnString))) { using (var scope = db.GetTransaction()) { try { foreach (var item in list) { db.Update <Sys_Roles>($"SET Status=99 WHERE ID={item.ID}"); } scope.Complete(); } catch (Exception ex) { db.AbortTransaction(); rtnMsg.Code = -1; rtnMsg.Message = ex.Message; return(rtnMsg); } } } return(rtnMsg); }
public string GetModuleListByRole(int roleId) { RtnMessage rtnMsg = new RtnMessage(); rtnMsg = BLL.SysModuleBLL.GetModuleListByRole(roleId); return(Newtonsoft.Json.JsonConvert.SerializeObject(rtnMsg)); }
public string SetRoleMenu(int roleID, int[] menuids) { RtnMessage rtnMsg = new RtnMessage(); rtnMsg = BLL.SysRolesBLL.SetRoleMenu(roleID, menuids); return(Newtonsoft.Json.JsonConvert.SerializeObject(rtnMsg)); }
public static RtnMessage SaveUserAtIndex(Sys_Users users) { RtnMessage rtnMsg = new RtnMessage(); rtnMsg.Code = 0; try { using (var db = new Database(new MySqlConnection(ConnString))) { users.EditTime = DateTime.Now; string sql = $"SET RealName='{users.RealName}',Sex={users.Sex},Phone='{users.Phone}',EditTime='{users.EditTime}' WHERE ID={users.ID}"; if (!(Convert.ToInt32(db.Update <Sys_Users>(sql)) > 0)) { rtnMsg.Code = 1; } } } catch (Exception ex) { rtnMsg.Code = -1; rtnMsg.Message = ex.ToString(); return(rtnMsg); } return(rtnMsg); }
public string GetUserInfo() { RtnMessage rtnMsg = new RtnMessage(); rtnMsg = BLL.SysUsersBLL.GetUserInfo(_userId); return(Newtonsoft.Json.JsonConvert.SerializeObject(rtnMsg)); }
public static RtnMessage SetRoleMenu(int roleID, int[] menuids) { RtnMessage rtnMsg = new RtnMessage(); rtnMsg.Code = 0; using (var db = new Database(new MySqlConnection(ConnString))) { try { using (var scope = db.GetTransaction()) { db.Delete <Sys_Role_Menu>($"WHERE RoleID={roleID}"); foreach (var item in menuids) { Sys_Role_Menu entity = new Sys_Role_Menu() { RoleID = roleID, MenuID = item }; db.Insert("Sys_Role_Menu", "ID", entity); } scope.Complete(); } } catch (Exception ex) { rtnMsg.Code = -1; db.AbortTransaction(); rtnMsg.Message = ex.Message; return(rtnMsg); } } return(rtnMsg); }
public static RtnMessage GetDictList(base_dict info) { RtnMessage rtnMsg = new RtnMessage(); rtnMsg.Code = 0; List <base_dict> list = new List <base_dict>(); try { using (var db = new Database(new MySqlConnection(ConnString))) { Sql sql = Sql.Builder; sql.Append("SELECT a.* FROM base_dict a WHERE a.State <>-1"); if (!string.IsNullOrEmpty(info.Name)) { sql.Append($" AND a.Name like '%{info.Name}%'"); } if (info.typeID != 0) { sql.Append($" AND a.TypeID ={info.typeID}"); } list = db.Fetch <base_dict>(sql); rtnMsg.Data = list; } } catch (Exception ex) { rtnMsg.Code = -1; rtnMsg.Message = ex.ToString(); return(rtnMsg); } return(rtnMsg); }
public static RtnMessage Save(base_dict info) { RtnMessage rtnMsg = new RtnMessage(); rtnMsg.Code = 0; using (var db = new Database(new MySqlConnection(ConnString))) { try { if (info.ID == 0) { if (!(Convert.ToInt32(db.Insert("base_dict", "ID", info)) > 0)) { rtnMsg.Code = 1; } } else { if (!(Convert.ToInt32(db.Save(info)) > 0)) { rtnMsg.Code = 1; } } } catch (Exception ex) { rtnMsg.Code = -1; rtnMsg.Message = ex.ToString(); return(rtnMsg); } } return(rtnMsg); }
public string SaveDict(base_dict data) { RtnMessage rtnMsg = new RtnMessage(); rtnMsg = BLL.BaseDictBLL.Save(data); return(Newtonsoft.Json.JsonConvert.SerializeObject(rtnMsg)); }
public string SaveUserAtIndex(Sys_Users data) { RtnMessage rtnMsg = new RtnMessage(); rtnMsg = BLL.SysUsersBLL.SaveUserAtIndex(data); return(Newtonsoft.Json.JsonConvert.SerializeObject(rtnMsg)); }
public static RtnMessage DeleteModule(SysModule data) { RtnMessage rtnMsg = new RtnMessage(); rtnMsg.Code = 0; //using (var db = new Database(new MySqlConnection(ConnString))) //{ //using (var scope = db.GetTransaction()) //{ // try // { // foreach (var item in list) // { // db.Update<Sys_Module>($"SET Status=99 WHERE ID={item.ID}"); // } // scope.Complete(); // } // catch (Exception ex) // { // db.AbortTransaction(); // rtnMsg.Code = -1; // rtnMsg.Message = ex.Message; // return rtnMsg; // } //} //} return(rtnMsg); }
public static RtnMessage GetRoleList(Sys_Roles roles) { RtnMessage rtnMsg = new RtnMessage(); rtnMsg.Code = 0; List <Sys_Roles> list = new List <Sys_Roles>(); try { using (var db = new Database(new MySqlConnection(ConnString))) { Sql sql = Sql.Builder; sql.Append("SELECT a.*,b.RealName UserRealName FROM Sys_Roles a left join sys_users b on a.UserId=b.ID WHERE a.Status <>99"); if (!string.IsNullOrEmpty(roles.RoleName)) { sql.Append($" AND a.RoleName like '%{roles.RoleName}%'"); } list = db.Fetch <Sys_Roles>(sql); rtnMsg.Data = list; } } catch (Exception ex) { rtnMsg.Code = -1; rtnMsg.Message = ex.ToString(); return(rtnMsg); } return(rtnMsg); }
public static RtnMessage ModifyPassword(int userID, string password, string newpwd) { RtnMessage rtnMsg = new RtnMessage(); rtnMsg.Code = 0; try { using (var db = new Database(new MySqlConnection(ConnString))) { password = StringHelper.Encrypt(password, SysConfig.Key); newpwd = StringHelper.Encrypt(newpwd, SysConfig.Key); if (db.Update <Sys_Users>($"SET PassWord='******' WHERE ID={userID} AND PassWord='******'") <= 0) { rtnMsg.Code = 1; rtnMsg.Message = "原密码错误"; } } } catch (Exception ex) { rtnMsg.Code = -1; rtnMsg.Message = ex.Message; return(rtnMsg); } return(rtnMsg); }
public static RtnMessage GetUserList(Sys_Users users) { RtnMessage rtnMsg = new RtnMessage(); rtnMsg.Code = 0; List <Sys_Users> list = new List <Sys_Users>(); try { using (var db = new Database(new MySqlConnection(ConnString))) { Sql sql = Sql.Builder; sql.Append("SELECT * FROM Sys_Users WHERE Status <>99"); if (!string.IsNullOrEmpty(users.RealName)) { sql.Append($" AND RealName like '%{users.RealName}%'"); } list = db.Fetch <Sys_Users>(sql); rtnMsg.Data = list; } } catch (Exception ex) { rtnMsg.Code = -1; rtnMsg.Message = ex.ToString(); return(rtnMsg); } return(rtnMsg); }
public string CheckUserName(string username) { RtnMessage rtnMsg = new RtnMessage(); rtnMsg = BLL.SysUsersBLL.CheckUserName(username); return(Newtonsoft.Json.JsonConvert.SerializeObject(rtnMsg)); }
public string SetUserRoles(int userID, int[] roleIDS) { RtnMessage rtnMsg = new RtnMessage(); rtnMsg = BLL.SysUsersBLL.SetUserRoles(userID, roleIDS); return(Newtonsoft.Json.JsonConvert.SerializeObject(rtnMsg)); }
public string DeleteUsers(List <Sys_Users> list) { RtnMessage rtnMsg = new RtnMessage(); rtnMsg = BLL.SysUsersBLL.DeleteUsers(list); return(Newtonsoft.Json.JsonConvert.SerializeObject(rtnMsg)); }
public string ResetPwd(int userID) { RtnMessage rtnMsg = new RtnMessage(); rtnMsg = BLL.SysUsersBLL.ResetPassword(userID); return(Newtonsoft.Json.JsonConvert.SerializeObject(rtnMsg)); }
public string ModifyPwd(string pwd, string newpwd) { RtnMessage rtnMsg = new RtnMessage(); rtnMsg = BLL.SysUsersBLL.ModifyPassword(_userId, pwd, newpwd); return(Newtonsoft.Json.JsonConvert.SerializeObject(rtnMsg)); }
public static RtnMessage GetModuleByUser(int userId) { RtnMessage rtnMsg = new RtnMessage(); rtnMsg.Code = 0; try { using (var db = new Database(new MySqlConnection(SysConfig.DefaultConnection))) { StringBuilder sql = new StringBuilder(); sql.Append($"select DISTINCT a.* from sys_module a LEFT JOIN sys_role_menu b on "); sql.Append($"a.ID=b.MenuID left join sys_user_role c on b.RoleID=c.RoleID where c.UserID={userId}"); sql.Append($" UNION select * from sys_module where ID IN"); sql.Append($" (select a.ParentId from sys_module a LEFT JOIN sys_role_menu b on "); sql.Append($" a.ID=b.MenuID left join sys_user_role c on b.RoleID=c.RoleID where c.UserID={userId} ) "); var list = db.Fetch <SysModule>(sql.ToString()); rtnMsg.Data = list; } } catch (Exception ex) { rtnMsg.Code = -1; Common.LoggerHelper.Error(ex.ToString()); return(rtnMsg); } return(rtnMsg); }
public static RtnMessage SaveRoles(Sys_Roles roles) { RtnMessage rtnMsg = new RtnMessage(); rtnMsg.Code = 0; try { using (var db = new Database(new MySqlConnection(ConnString))) { if (roles.ID == 0) { roles.CreateTime = DateTime.Now; if (!(Convert.ToInt32(db.Insert("sys_roles", "ID", roles)) > 0)) { rtnMsg.Code = 1; } } else { if (!(Convert.ToInt32(db.Save(roles)) > 0)) { rtnMsg.Code = 1; } } } } catch (Exception ex) { rtnMsg.Code = -1; rtnMsg.Message = ex.ToString(); return(rtnMsg); } return(rtnMsg); }
/// <summary> /// 保存模块数据 /// </summary> /// <param name="data"></param> /// <returns></returns> public static RtnMessage SaveSysModule(SysModule data) { RtnMessage rtnMsg = new RtnMessage(); rtnMsg.Code = 0; try { using (var db = new Database(new MySqlConnection(SysConfig.DefaultConnection))) { if (data.Id == 0) { data.CreateTime = DateTime.Now; if (!(Convert.ToInt32(db.Insert("Sys_Module", "ID", data)) > 0)) { rtnMsg.Code = 1; } } else { if (!(Convert.ToInt32(db.Save(data)) > 0)) { rtnMsg.Code = 1; } } } } catch (Exception ex) { rtnMsg.Code = -1; Common.LoggerHelper.Error(ex.ToString()); return(rtnMsg); } return(rtnMsg); }
public string CheckRoleName(string rolename) { RtnMessage rtnMsg = new RtnMessage(); rtnMsg = BLL.SysRolesBLL.CheckRoleName(rolename); return(Newtonsoft.Json.JsonConvert.SerializeObject(rtnMsg)); }
public static RtnMessage CheckRoleName(string rolename) { RtnMessage rtnMsg = new RtnMessage() { Code = 0 }; try { using (var db = new Database(new MySqlConnection(ConnString))) { var users = db.FirstOrDefault <Sys_Roles>($"WHERE RoleName='{rolename}' And Status<>99"); if (users != null) { rtnMsg.Code = 1; rtnMsg.Message = "此用户名已存在"; } } } catch (Exception ex) { rtnMsg.Code = -1; rtnMsg.Message = ex.Message; return(rtnMsg); } return(rtnMsg); }
public string DeleteDict(List <base_dict> list) { RtnMessage rtnMsg = new RtnMessage(); rtnMsg = BLL.BaseDictBLL.DeleteDict(list); return(Newtonsoft.Json.JsonConvert.SerializeObject(rtnMsg)); }
public string SaveRole(Sys_Roles data) { RtnMessage rtnMsg = new RtnMessage(); data.UserID = _userId; rtnMsg = BLL.SysRolesBLL.Save(data); return(Newtonsoft.Json.JsonConvert.SerializeObject(rtnMsg)); }
public string GetRoleList(Sys_Roles data) { RtnMessage rtnMsg = new RtnMessage(); rtnMsg = BLL.SysRolesBLL.GetRoleList(data); var list = BLL.SysModuleBLL.GetModuleList(); return(Newtonsoft.Json.JsonConvert.SerializeObject(new { rtnMsg, list })); }
public string GetUserList(Sys_Users data) { RtnMessage rtnMsg = new RtnMessage(); rtnMsg = BLL.SysUsersBLL.GetUserList(data); var roleList = BLL.SysRolesBLL.GetRoleList(new Sys_Roles()); return(Newtonsoft.Json.JsonConvert.SerializeObject(new { rtnMsg, roleList })); }
public static RtnMessage GetModuleList() { RtnMessage rtnMsg = new RtnMessage(); rtnMsg.Code = 0; List <SysModule> menuList = new List <SysModule>(); List <MenusTreeModel> treeList = new List <MenusTreeModel>(); try { using (var db = new Database(new MySqlConnection(SysConfig.DefaultConnection))) { menuList = db.Fetch <SysModule>($"SELECT * FROM sys_module"); #region 构造树形结构 var One_list = menuList.Where(e => e.ParentId == 0).ToList(); foreach (var item in One_list) { MenusTreeModel tree = new MenusTreeModel() { id = item.Id, label = item.ModuleName, children = new List <MenusTreeModel>() }; var two_list = menuList.Where(e => e.ParentId == item.Id).ToList(); foreach (var _item in two_list) { MenusTreeModel _tree = new MenusTreeModel() { id = _item.Id, label = _item.ModuleName, }; tree.children.Add(_tree); } treeList.Add(tree); //} #endregion rtnMsg.Data = treeList; } } } catch (Exception ex) { rtnMsg.Code = -1; Common.LoggerHelper.Error(ex.ToString()); return(rtnMsg); } return(rtnMsg); }