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="model">角色实体</param> public void Add(Sys_Roles model) { using (IDbConnection conn = OpenConnection()) { const string sqlwhere = @" if (@IsDefault=1) begin update Sys_Roles set IsDefault=0 end insert into Sys_Roles(RoleName,RoleDesc,IsDefault,Creater,[Status]) values(@RoleName,@RoleDesc,@IsDefault,@Creater,@Status) SELECT @@Identity as Id"; var param = new { ID = model.RoleId, model.RoleName, model.RoleDesc, model.IsDefault, model.Creater, model.Status }; decimal id = conn.Query <decimal>(sqlwhere, param).FirstOrDefault(); model.RoleId = decimal.ToInt32(id); } }
/// <summary> /// 插入项目角色记录 /// </summary> /// <param name="sys_Roles">项目角色对象</param> /// <returns></returns> public int InsertSys_Roles(Sys_Roles sys_Roles) { string sql = @"INSERT INTO dbo.Sys_Roles(ProjID, RoleName, RoleCode, Status, Remark, CreatedBy) VALUES(@ProjID, @RoleName, @RoleCode, @Status, @Remark, @CreatedBy); SELECT @KeyId = SCOPE_IDENTITY()"; Database db = DatabaseFactory.CreateDatabase(DBLink.SysDBLink.ToString()); DbCommand command = db.GetSqlStringCommand(sql); db.AddOutParameter(command, "KeyId", DbType.Int32, sizeof(int)); db.AddInParameter(command, "ProjID", DbType.Int32, sys_Roles.ProjID); db.AddInParameter(command, "RoleName", DbType.String, sys_Roles.RoleName); db.AddInParameter(command, "RoleCode", DbType.String, sys_Roles.RoleCode); db.AddInParameter(command, "Status", DbType.Boolean, sys_Roles.Status); db.AddInParameter(command, "Remark", DbType.String, string.IsNullOrEmpty(sys_Roles.Remark) ? DBNull.Value : (object)sys_Roles.Remark); db.AddInParameter(command, "CreatedBy", DbType.Int32, sys_Roles.CreatedBy); int affectedRecords = db.ExecuteNonQuery(command); if (affectedRecords < 1) { throw new ApplicationException("插入数据失败, 没有记录被插入"); } else { string strTemp = "select @@identity"; DataTable dt = GetDataTable(strTemp); if (dt != null && dt.Rows.Count > 0) { affectedRecords = int.Parse(dt.Rows[0][0].ToString()); } } return(affectedRecords); }
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); }
/// <summary>编辑 /// /// </summary> private void DoEdit() { string strMsg = CheckSelect("修改"); if (strMsg != string.Empty) { MessageBox.Show(strMsg); return; } DataGridViewRow drRowEdit = grdData.SelectedRows[0]; Sys_Roles model = drRowEdit.Tag as Sys_Roles; if (model == null) { int intKeyID = int.Parse(drRowEdit.Cells[gridmrzKeyId.Name].Value.ToString()); model = m_Sys_RolesDAL.GetModel(intKeyID); } if (model != null) { FrmSys_RolesSimpleDialog frmDialog = new FrmSys_RolesSimpleDialog(model, m_lstSysRoles); if (frmDialog.ShowDialog() == DialogResult.OK) { m_lstSysRoles = frmDialog.ListSys_Roles; grdData.DataSource = m_lstSysRoles; grdData.Refresh(); } } }
/// <summary> ///根据主键值查找项目角色记录 /// </summary> /// <param name="keyId">主键</param> /// <returns>Sys_Roles</returns> public Sys_Roles FindSys_Roles(int keyId) { string sql = @"SELECT KeyId, ProjID, RoleName, RoleCode, Status, Remark, CreatedBy, CreatedOn, ModifiedBy, ModifiedOn FROM dbo.Sys_Roles WHERE KeyId = @KeyId"; Database db = DatabaseFactory.CreateDatabase(DBLink.SysDBLink.ToString()); DbCommand command = db.GetSqlStringCommand(sql); db.AddInParameter(command, "KeyId", DbType.Int32, keyId); Sys_Roles sys_Roles = null; using (IDataReader dr = db.ExecuteReader(command)) { if (dr.Read()) { sys_Roles = new Sys_Roles(); sys_Roles.KeyId = (int)dr["KeyId"]; sys_Roles.ProjID = (int)dr["ProjID"]; sys_Roles.RoleName = (string)dr["RoleName"]; sys_Roles.RoleCode = (string)dr["RoleCode"]; sys_Roles.Status = (bool)dr["Status"]; sys_Roles.Remark = dr["Remark"] == DBNull.Value ? null : (string)dr["Remark"]; sys_Roles.CreatedBy = (int)dr["CreatedBy"]; sys_Roles.CreatedOn = (DateTime)dr["CreatedOn"]; sys_Roles.ModifiedBy = dr["ModifiedBy"] == DBNull.Value ? null : (int?)dr["ModifiedBy"]; sys_Roles.ModifiedOn = dr["ModifiedOn"] == DBNull.Value ? null : (DateTime?)dr["ModifiedOn"]; } } return(sys_Roles); }
public FrmRoleSettingEdit(Sys_Roles sys) { InitializeComponent(); this.DataContext = this; MainRole = sys; MyTitle = sys.Name == null ? "新增角色" : "编辑角色"; }
/// <summary> /// 保存角色、角色功能、角色用户数据 /// </summary> /// <param name="user">用户</param> /// <param name="project">所属系统</param> /// <param name="role">角色</param> /// <param name="roleModules">角色功能</param> /// <param name="roleUsers">角色用户</param> public void SaveRole(int user, int project, Sys_Roles role, Sys_RoleModules[] roleModules, Sys_UserRole[] roleUsers) { using (TransactionScope scope = new TransactionScope()) { if (role.KeyId == 0) { role.ProjID = project; role.RoleCode = AutoRoleCode(project.ToString()); role.CreatedBy = user; role.CreatedOn = DateTime.Now; role.KeyId = _sys_RolesDAO.InsertSys_Roles(role); } else { role.ModifiedBy = user; role.ModifiedOn = DateTime.Now; _sys_RolesDAO.UpdateSys_Roles(role); } var roleModulesDao = new Sys_RoleModulesDAO(); roleModulesDao.SaveRoleModules(roleModules, role.KeyId, user, project); var roleUsersDao = new Sys_UserRoleDAO(); roleUsersDao.SaveRoleUserTable(roleUsers, role.KeyId, user, project); scope.Complete(); } }
public string SaveRole(Sys_Roles data) { RtnMessage rtnMsg = new RtnMessage(); data.UserID = _userId; rtnMsg = BLL.SysRolesBLL.Save(data); return(Newtonsoft.Json.JsonConvert.SerializeObject(rtnMsg)); }
/// <summary> /// 删除角色信息 /// </summary> /// <param name="role"></param> /// <returns></returns> public bool DeleteRoleInfo(Sys_Roles role) { Sys_Roles m = db.Sys_Roles.Where(p => p.ID == role.ID).ToList <Sys_Roles>().FirstOrDefault <Sys_Roles>(); db.Sys_Roles.DeleteObject(m); db.SaveChanges(); return(true); }
private void dataNavigator_PositionChanged(object sender, EventArgs e) { if (dataNavigator.ListInfo == null) { return; } m_Sys_Roles = m_lstSys_Roles[this.dataNavigator.CurrentIndex]; DisplayData(m_Sys_Roles); }
/// <summary> /// 更新角色信息 /// </summary> /// <param name="role"></param> /// <returns></returns> public bool UpdateRoleInfo(Sys_Roles role) { Sys_Roles m = db.Sys_Roles.Where(p => p.ID == role.ID).ToList <Sys_Roles>().FirstOrDefault <Sys_Roles>(); m.Name = role.Name; m.Remark = role.Remark; db.SaveChanges(); return(true); }
public JsonResult UpdateRole(Sys_Roles model) { BaseJsonData json = new BaseJsonData(); if (!User.Identity.IsAuthenticated) { json.msg_text = "没有登陆或登陆失效,请重新登陆后操作。"; json.msg_code = "notLogin"; goto next; } int user = PageValidate.FilterParam(User.Identity.Name); if (!RoleCheck.CheckHasAuthority(user, db, "系统管理")) { json.msg_text = "没有权限。"; json.msg_code = "NoPower"; goto next; } if (model.role_id == 0) { json.msg_text = "获取角色的ID出错。"; json.msg_code = "IDError"; goto next; } if (model.role_id == 1) { json.msg_text = "该角色不允许修改。"; json.msg_code = "CanNotUpdate"; goto next; } var same = db.Sys_Roles.Where(x => x.role_name == model.role_name && x.role_id != model.role_id); if (same.Count() > 0) { json.msg_text = "该名称已存在。"; json.msg_code = "NameExists"; goto next; } db.Entry(model).State = EntityState.Modified; try { db.SaveChanges(); DBCaches <Sys_Roles> .ClearCache("cache_post"); } catch { json.msg_text = "更新,请重新操作。"; json.msg_code = "UpdateErr"; goto next; } json.state = 1; json.msg_code = "success"; json.msg_text = "更新成功!"; SysLog.WriteLog(user, string.Format("更新角色[{0}]名称", model.role_name), IpHelper.GetIP(), "", 5, "", db); next: return(Json(json, JsonRequestBehavior.AllowGet)); }
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 FrmAccountSettingEdit(Sys_Accounts account) { InitializeComponent(); this.DataContext = this; MainAccount = account; MyTitle = account.AccountName == null ? "新增账户" : "编辑账户"; RoleList = new UserInfoBLL().GetRoleInfo(); SelectedRole = account.AccountName != null?RoleList.Find(p => p.ID == account.RoleID) : RoleList[0]; }
public IActionResult Add(int id = 0) { Sys_Roles _model = new Sys_Roles(); if (id != 0) { _model = sys_Roles.List(c => c.Id == id).FirstOrDefault(); } return(View(_model)); }
/// <summary> /// 新增角色信息 /// </summary> /// <param name="role"></param> /// <returns></returns> public bool AddRoleInfo(Sys_Roles role) { if (role != null && role.Name != "") { db.Sys_Roles.AddObject(role); db.SaveChanges(); return(true); } return(false); }
public JsonResult DeleteRole(string rid) { int id = PageValidate.FilterParam(rid); BaseJsonData json = new BaseJsonData(); if (!User.Identity.IsAuthenticated) { json.msg_text = "没有登陆或登陆失效,请重新登陆后操作。"; json.msg_code = "notLogin"; goto next; } int user = PageValidate.FilterParam(User.Identity.Name); if (!RoleCheck.CheckHasAuthority(user, db, "系统管理")) { json.msg_text = "没有权限。"; json.msg_code = "NoPower"; goto next; } if (id == 1) { json.msg_text = "该角色不允许删除。"; json.msg_code = "CanNotDel"; goto next; } Sys_Roles model = db.Sys_Roles.Find(id); if (model == null) { json.msg_text = "没有找到该角色,该角色可能已被删除。"; json.msg_code = "noThis"; goto next; } db.Sys_Roles.Remove(model); try { db.SaveChanges(); DBCaches <Sys_Roles> .ClearCache("cache_role"); } catch { json.msg_text = "删除失败,请重新操作。"; json.msg_code = "recyErr"; goto next; } json.state = 1; json.msg_code = "success"; json.msg_text = "删除成功!"; SysLog.WriteLog(user, string.Format("删除角色[{0}]", model.role_name), IpHelper.GetIP(), "", 5, "", db); next: return(Json(json, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 新增命令 /// </summary> /// <returns></returns> public override void ExecuteAdd() { Sys_Roles role = new Sys_Roles(); role.ID = new UserInfoBLL().GetMaxRoleID() + 1; FrmRoleSettingEdit edit = new FrmRoleSettingEdit(role); edit.SaveEvent += (r) => { RoleList.Add(r); }; edit.ShowDialog(); }
public ActionResult RoleEdit(int id = 0) { var model = new Sys_Roles { RoleId = 0, RoleDesc = "", RoleName = "" }; if (id != 0) { model = roleBL.Get(id); } ViewBag.model = model; return(View()); }
/// <summary> /// 返回满足查询条件的项目角色实体列表 /// </summary> /// <param name="param">查询条件</param> /// <returns>项目角色实体列表</returns> public IList <Sys_Roles> GetSys_Roless(QueryParameter param) { string sql = @"SELECT KeyId, ProjID, RoleName, RoleCode, Status, Remark, CreatedBy, CreatedOn, ModifiedBy, ModifiedOn FROM dbo.Sys_Roles"; if (param != null) { sql = QueryParameter.CompleteSqlString(sql, param); } Database db = DatabaseFactory.CreateDatabase(DBLink.SysDBLink.ToString()); DbCommand command = db.GetSqlStringCommand(sql); if (param != null) { //设置参数 foreach (IExpression exp in param.WhereExpressions) { if (exp is SimpleExpression) { SimpleExpression simple = exp as SimpleExpression; db.AddInParameter(command, simple.ExpName, simple.DbType, simple.Value); } } } IList <Sys_Roles> list = new List <Sys_Roles>(); using (IDataReader dr = db.ExecuteReader(command)) { while (dr.Read()) { Sys_Roles sys_Roles = new Sys_Roles(); sys_Roles.KeyId = (int)dr["KeyId"]; sys_Roles.ProjID = (int)dr["ProjID"]; sys_Roles.RoleName = (string)dr["RoleName"]; sys_Roles.RoleCode = (string)dr["RoleCode"]; sys_Roles.Status = (bool)dr["Status"]; sys_Roles.Remark = dr["Remark"] == DBNull.Value ? null : (string)dr["Remark"]; sys_Roles.CreatedBy = (int)dr["CreatedBy"]; sys_Roles.CreatedOn = (DateTime)dr["CreatedOn"]; sys_Roles.ModifiedBy = dr["ModifiedBy"] == DBNull.Value ? null : (int?)dr["ModifiedBy"]; sys_Roles.ModifiedOn = dr["ModifiedOn"] == DBNull.Value ? null : (DateTime?)dr["ModifiedOn"]; list.Add(sys_Roles); } } return(list); }
/// <summary> /// 设置角色冻结/解冻 /// </summary> /// <param name="roleId"></param> /// <returns></returns> public bool SetStatus(int roleId) { Sys_Roles role = _roleDB.Get(roleId); if (role.Status == 0) { role.Status = 1; } else { role.Status = 0; } return(_roleDB.Update(role)); }
public JsonResult UpdateStatus(int id) { try { Sys_Roles model = roleBL.Get(id); model.Status = (model.Status + 1) % 2; roleBL.Update(model); return(Json(1, JsonRequestBehavior.AllowGet)); } catch { return(Json(0, JsonRequestBehavior.AllowGet)); } }
/// <summary>构造函数 /// /// </summary> /// <param name=model" Sys_Roles">对象</param> /// <param name="lstSys_Roles">对象集合</param> public FrmSys_RolesSimpleDialog(Sys_Roles modelSys_Roles, List <Sys_Roles> lstSys_Roles) { InitializeComponent(); DoInitData(); m_lstSys_Roles = lstSys_Roles; m_Sys_RolesDAL = new Sys_RolesDAL(); this.dataNavigator.Visible = false; if (modelSys_Roles != null) { this.dataNavigator.Visible = true; m_Sys_Roles = modelSys_Roles; this.dataNavigator.ListInfo = lstSys_Roles.Select(t => t.KeyId.ToString()).ToList(); m_strIndex = lstSys_Roles.FindIndex(t => t.KeyId == m_Sys_Roles.KeyId).ToString(); this.dataNavigator.CurrentIndex = int.Parse(m_strIndex); } }
public JsonResult SaveRole(int roleId, int isDefault, string roleName, string roleDesc) { try { if (roleBL.Exists(roleName.Trim(), roleId)) { return(Json(new { result = 0, content = "角色名称重复!" }, JsonRequestBehavior.AllowGet)); } var model = new Sys_Roles { Status = 0, CreateTime = DateTime.Now }; if (roleId != 0) { model = roleBL.Get(roleId); } if (model.Status == 1 && isDefault == 1) { return(Json(new { result = 0, content = "保存失败!已冻结角色不可设为默认角色!" }, JsonRequestBehavior.AllowGet)); } if (roleBL.GetAllRoles().Find(p => p.IsDefault == 1 && p.IsDelete == 0) == null) { isDefault = 1; } model.IsDefault = isDefault; model.RoleName = roleName.Trim(); model.RoleDesc = roleDesc.Trim(); if (model.RoleId == 0) { model.Creater = CurrentUser.UserId; roleBL.Add(model); } else { roleBL.Update(model); } return(Json(new { result = 1, content = "保存成功" }, JsonRequestBehavior.AllowGet)); } catch { return(Json(new { result = 0, content = "保存失败" }, JsonRequestBehavior.AllowGet)); } }
/// <summary> /// 更新项目角色记录 /// </summary> /// <param name="sys_Roles">项目角色对象</param> /// <returns>受影响的记录数</returns> public int UpdateSys_Roles(Sys_Roles sys_Roles) { string sql = @"UPDATE dbo.Sys_Roles SET ProjID = @ProjID, RoleName = @RoleName, RoleCode = @RoleCode, Status = @Status, Remark = @Remark, ModifiedBy = @ModifiedBy, ModifiedOn = @ModifiedOn WHERE KeyId = @KeyId"; Database db = DatabaseFactory.CreateDatabase(DBLink.SysDBLink.ToString()); DbCommand command = db.GetSqlStringCommand(sql); db.AddInParameter(command, "KeyId", DbType.Int32, sys_Roles.KeyId); db.AddInParameter(command, "ProjID", DbType.Int32, sys_Roles.ProjID); db.AddInParameter(command, "RoleName", DbType.String, sys_Roles.RoleName); db.AddInParameter(command, "RoleCode", DbType.String, sys_Roles.RoleCode); db.AddInParameter(command, "Status", DbType.Boolean, sys_Roles.Status); db.AddInParameter(command, "Remark", DbType.String, string.IsNullOrEmpty(sys_Roles.Remark) ? DBNull.Value : (object)sys_Roles.Remark); db.AddInParameter(command, "ModifiedBy", DbType.Int32, sys_Roles.ModifiedBy.HasValue ? (object)sys_Roles.ModifiedBy : DBNull.Value); db.AddInParameter(command, "ModifiedOn", DbType.DateTime, sys_Roles.ModifiedOn.HasValue ? (object)sys_Roles.ModifiedOn : DBNull.Value); return(db.ExecuteNonQuery(command)); }
/// <summary> /// 删除命令 /// </summary> /// <returns></returns> public override void ExecuteDelete() { if (SelectedRole != null) { if (SelectedRole.Name == "管理员" && SelectedRole.Name == "超级管理员") { System.Windows.MessageBox.Show("管理员信息不得删除"); return; } UserInfoBLL bll = new UserInfoBLL(); if (bll.DeleteRoleInfo(SelectedRole)) { RoleList.Remove(SelectedRole); SelectedRole = null; } } }
private void btnSave_Click(object sender, EventArgs e) { string strReturnMsg = CheckInput(); if (strReturnMsg != string.Empty) { MessageBox.Show(strReturnMsg); return; } //新增 if (m_Sys_Roles == null) { Sys_Roles model = EntityOperateManager.AddEntity <Sys_Roles>(this.tabPage); int intReturn = m_Sys_RolesDAL.Add(model); if (intReturn > 0) { MessageBox.Show(@"添加成功"); model.KeyId = intReturn; m_lstSys_Roles.Add(model); ListSys_Roles = m_lstSys_Roles; this.DialogResult = DialogResult.OK; } else { MessageBox.Show(@"添加失败"); } } //修改 else { m_Sys_Roles = EntityOperateManager.EditEntity(this.tabPage, m_Sys_Roles); bool blnReturn = m_Sys_RolesDAL.Update(m_Sys_Roles); if (blnReturn) { MessageBox.Show(@"修改成功"); ListSys_Roles = m_lstSys_Roles; this.DialogResult = DialogResult.OK; } else { MessageBox.Show(@"修改失败"); } } }
/// <summary> /// 修改命令 /// </summary> /// <returns></returns> public override void ExecuteEdit() { if (SelectedRole != null) { Sys_Roles role = new Sys_Roles(); role.ID = SelectedRole.ID; role.Name = SelectedRole.Name; role.Remark = SelectedRole.Remark; FrmRoleSettingEdit edit = new FrmRoleSettingEdit(role); edit.SaveEvent += (s) => { RoleList[RoleList.IndexOf(SelectedRole)] = s; SelectedRole = s; }; edit.ShowDialog(); } }
public IActionResult Add(Sys_Roles model) { if (model.Id == 0) { //添加 sys_Roles.Add(model); } else { //修改 sys_Roles.Update(model); } sys_Roles.Commit(); return(Json(new ResponseModel() { Status = "ok" })); //\ }