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