/// <summary>
/// 单个或多个删除
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnDel_Click(object sender, EventArgs e)
{
if (dgvRoles.SelectedRows.Count > 0)
{
string titleMsg = "删除角色";
if (MsgBoxHelper.MsgBoxConfirm(titleMsg, "您确定要删除选择的角色吗？会连同与角色相关的数据一并删除？") == DialogResult.Yes)
{
List <int> roleIds = new List <int>();
foreach (DataGridViewRow row in dgvRoles.SelectedRows)
{
RoleInfoModel roleInfo = row.DataBoundItem as RoleInfoModel;
roleIds.Add(roleInfo.RoleId);
}
bool bl = RequestStar.DeleteRoles(roleIds, 0);
if (bl)
{
MsgBoxHelper.MsgBoxShow(titleMsg, $"选择角色信息删除成功！");
LoadAllRoles();
}
else
{
MsgBoxHelper.MsgErrorShow($"选择角色信息删除失败！");
return;
}
}
}
else
{
MsgBoxHelper.MsgErrorShow("请选择要删除的角色信息！");
return;
}
}
public IHttpActionResult RoleInfo(RoleInfoModel model)
{
try
{
var SysRole = dbContext.AC_SysRoles.FirstOrDefault(p => p.Id == model.Id);
if (SysRole != null)
{
var SysRoleCode = dbContext.AC_SysRoles.Where(p => p.Code == model.Code).ToList();
if (SysRoleCode.Count() > 0)
{
return(JsonResultHelper.JsonResult(1000, "角色编码已存在，请重新输入！"));
}
SysRole.Name = model.RoleName;
}
else
{
AC_SysRoles Role = new AC_SysRoles();
Role.Code = model.Code;
Role.Name = model.RoleName;
dbContext.AC_SysRoles.Add(Role);
}
dbContext.Configuration.ValidateOnSaveEnabled = false;
dbContext.SaveChanges();
dbContext.Configuration.ValidateOnSaveEnabled = true;
return(JsonResultHelper.JsonResult(0, "操作成功"));
}
catch (Exception ex)
{
return(JsonResultHelper.JsonResult(1000, ex.Message));
}
}
private void dgvRoles_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
Action act = () =>
{
if (e.RowIndex >= 0)
{
var curCell = dgvRoles.Rows[e.RowIndex].Cells[e.ColumnIndex];
string cellVal = curCell.FormattedValue.ToString();
RoleInfoModel roleInfo = dgvRoles.Rows[e.RowIndex].DataBoundItem as RoleInfoModel;
switch (cellVal)
{
case "修改":
ShowRoleInfoPage(2, roleInfo.RoleId);
break;
case "分配权限":
ShowRightPage(roleInfo.RoleId);
break;
case "删除":
DeleteRole(roleInfo);
break;
}
}
};
act.TryCatch("行操作异常！");
}
public RoleRelationWindow(RoleInfoModel entity, OperationAction operationAction, IUserOperationDAL userOperationDAL)
: this(userOperationDAL)
{
UserAction = operationAction;
InitData(entity);
InitControl();
}
public JsonResult DoUpdateRole()
{
string roleId = GetFormData("roleId");
string roleName = GetFormData("roleName");
string roleDesc = GetFormData("roleDesc");
List <string> actionIdList = Request.Form.GetValues("chkPmBox").ToList();
RoleInfoModel model = new RoleInfoModel();
model.RoleId = roleId;
model.RoleName = roleName;
model.CnName = roleName;
model.Description = roleDesc;
model.RoleStatus = 0;
string message = "";
if (RoleInfoService.Instance.UpdateRoleAndPremission(model, actionIdList, out message))
{
return(SuccessedJson(message, "UserMgr_Premission", "UserMgr_Premission", "closeCurrent", "/usermgr/premission?rid=" + model.RoleId));
}
else
{
return(FailedJson(message));
}
}
/// <summary>
/// 添加角色记录
/// </summary>
/// <returns>DataTable</returns>
public static bool InsertRoleInfo(RoleInfoModel model, string loginUserID, out string ID)
{
//SQL拼写
StringBuilder sql = new StringBuilder();
sql.AppendLine("INSERT INTO officedba.RoleInfo");
sql.AppendLine(" (CompanyCD ");
sql.AppendLine(" ,RoleName ");
sql.AppendLine(" ,remark ");
sql.AppendLine(" ,ModifiedUserID) ");
sql.AppendLine("VALUES ");
sql.AppendLine(" (@CompanyCD ");
sql.AppendLine(" ,@RoleName ");
sql.AppendLine(" ,@remark ");
sql.AppendLine(" ,'"+ loginUserID + "') ");
sql.AppendLine("set @ID= @@IDENTITY");
//设置参数
SqlParameter[] param = new SqlParameter[4];
param[0] = SqlHelper.GetParameter("@CompanyCD", model.CompanyCD);
param[1] = SqlHelper.GetParameter("@remark", model.Remark);
param[2] = SqlHelper.GetParameter("@RoleName", model.RoleName);
param[3] = SqlHelper.GetOutputParameter("@ID", SqlDbType.Int);
SqlHelper.ExecuteTransSql(sql.ToString(), param);
ID = param[3].Value.ToString();
return(SqlHelper.Result.OprateCount > 0 ? true : false);
}
/// <summary>
/// 角色信息插入
/// </summary>
/// <param name="model">角色信息</param>
/// <returns>插入成功与否</returns>
public static bool InsertRoleInfo(RoleInfoModel model, out string ID)
{
ID = "0";
//获取登陆用户ID
string loginUserID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).UserID;// 待修改
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//登陆日志
try
{
bool succ = false;
LogInfoModel logModel = InitLogInfo(model.RoleName);
logModel.Element = ConstUtil.LOG_PROCESS_INSERT;
succ = RoleInfoDBHelper.InsertRoleInfo(model, loginUserID, out ID);
if (!succ)
{
logModel.Remark = ConstUtil.LOG_PROCESS_FAILED;
}
else
{
logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
LogDBHelper.InsertLog(logModel);
return(succ);
}
catch (Exception ex)
{
WriteSystemLog(userInfo, ex);
return(false);
}
}
public override void OnAuthorization(HttpActionContext actionContext)
{
bool authorize = false;
SessionConfiguration oConfig = new SessionConfiguration();
AccountModel oSession = oConfig.GetSessionInfo();
RoleInfoModel oRole = (from obj in oSession.UserRoles where obj.Sequence == 1 select obj).FirstOrDefault();
foreach (var role in allowedroles)
{
if (oRole.RoleName.Equals(role, StringComparison.OrdinalIgnoreCase))
{
authorize = true;
break;
}
else
{
authorize = false;
}
}
if (!authorize)
{
actionContext.Response = new HttpResponseMessage
{
StatusCode = HttpStatusCode.Forbidden,
Content = new StringContent("You are unauthorized to access this page.")
};
}
}
/// <summary>
/// 角色信息修改
/// </summary>
/// <param name="model">角色信息</param>
/// <returns>更新成功与否</returns>
public static bool UpdateRoleInfo(RoleInfoModel model, int RoleID)
{
//获取登陆用户ID
string loginUserID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).UserID; //带修改
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//登陆日志
try
{
bool succ = false;
LogInfoModel logModel = InitLogInfo(model.RoleName);
logModel.Element = ConstUtil.LOG_PROCESS_UPDATE;
succ = RoleInfoDBHelper.UpdateRoleInfo(model, loginUserID, RoleID);
if (!succ)
{
logModel.Remark = ConstUtil.LOG_PROCESS_FAILED;
}
else
{
logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
LogDBHelper.InsertLog(logModel);
return(succ);
}
catch (Exception)
{
return(false);
throw;
}
}
/// <summary>
/// 创建角色信息。
/// </summary>
/// <param name="roleInfo"></param>
/// <param name="message"></param>
/// <returns></returns>
public bool CreateNewRole(RoleInfoModel roleInfo, out string message)
{
bool result = false;
message = "成功创建角色信息";
string sql = @"
SELECT
COUNT(1)
FROM
role_info
WHERE
role_name = $role_name$
";
ParameterCollection pc = new ParameterCollection();
pc.Add("role_name", roleInfo.RoleName);
if (Convert.ToInt32(ExecuteScalar(sql, pc)) > 0)
{
message = string.Format("操作失败，系统中存在名为【{0}】的角色信息", roleInfo.RoleName);
return(false);
}
if (Create(roleInfo) > 0)
{
result = true;
GetRoleDomainList(true);
}
return(result);
}
private void InitRoleInfo()
{
string addText = "——";
if (fModel.FId == 0)
{
txtRName.Clear();
txtRemark.Clear();
btnText = "新增";
}
else
{
RoleInfoModel roleInfo = RequestStar.GetRole(fModel.FId);
if (roleInfo != null)
{
txtRName.Text = roleInfo.RoleName;
txtRemark.Text = roleInfo.Remark;
oldName = roleInfo.RoleName;
}
btnText = "修改";
}
addText += btnText;
this.Text += addText;
btnSubmit.Text = btnText;
}
private void DgRoleListSelectionChanged(object sender, SelectionChangedEventArgs e)
{
foreach (RoleInfoModel item in DgRoleList.SelectedItems)
{
DgRoleSelectEnity = item;
break;
}
}
public ActionResult AddRole(RoleInfoModel model)
{
if (ModelState.IsValid)
{
// 尝试注册用户
RoleService.Create(model.RoleName, model.Description);
return(RedirectToAction("Roles", "Account"));
}
return(View(model));
}
/// <summary>
/// 删除
/// </summary>
/// <param name="pc">pc</param>
/// <returns>影响的记录行数</returns>
public int DeleteMultiple(ParameterCollection pc)
{
int ret = 0;
RoleInfoModel roleinfo = new RoleInfoModel();
ret = DbUtil.Current.DeleteMultiple(roleinfo, pc);
return(ret);
}
/// <summary>
/// 提交响应
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSubmit_Click(object sender, EventArgs e)
{
//接收页面信息输入
string roleName = txtRName.Text.Trim();
string remark = txtRemark.Text.Trim();
//判空处理 ---角色名称
if (string.IsNullOrEmpty(roleName))
{
MsgBoxHelper.MsgErrorShow("角色名称不能为空！");
txtRName.Focus();
return;
}
//角色名称存在性---add 不能是已存在 update 没有修改名称（不用判断存在性） 名称已修改的情况（要判断）
if (fModel.FId == 0 || (!string.IsNullOrEmpty(oldName) && oldName != roleName))
{
if (RequestStar.ExistRoleName(roleName))
{
MsgBoxHelper.MsgErrorShow("角色名称已经存在！");
txtRName.Focus();
return;
}
}
//封装
RoleInfoModel roleInfo = new RoleInfoModel()
{
RoleName = roleName,
Remark = remark,
Creator = fModel.UName
};
//调用方法（add） （update）
bool bl = false;
if (fModel.FId == 0)
{
bl = RequestStar.AddRoleInfo(roleInfo);
}
else if (fModel.FId > 0)
{
roleInfo.RoleId = fModel.FId;
bl = RequestStar.UpdateRoleInfo(roleInfo);
}
//判断结果给出提示
if (bl)
{
MsgBoxHelper.MsgBoxShow($"{btnText}角色", $"角色：{roleName} 信息{btnText}成功！");
//刷新列表页面数据
fModel.ReLoad?.Invoke();
}
else
{
MsgBoxHelper.MsgErrorShow($"角色：{roleName} 信息{btnText}失败！");
return;
}
}
/// <summary>
/// 更新
/// </summary>
/// <param name="roleinfo">实体</param>
/// <returns>影响的记录行数</returns>
public int Update(RoleInfoModel roleinfo)
{
int ret = 0;
roleinfo.ModifiedBy = SessionUtil.Current.UserId;
roleinfo.ModifiedOn = DateTime.Now;
ret = DbUtil.Current.Update(roleinfo);
return(ret);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="roleinfo">实体</param>
/// <param name="pc">pc</param>
/// <returns>影响的记录行数</returns>
public int UpdateMultiple(RoleInfoModel roleinfo, ParameterCollection pc)
{
int ret = 0;
roleinfo.ModifiedBy = SessionUtil.Current.UserId;
roleinfo.ModifiedOn = DateTime.Now;
ret = DbUtil.Current.UpdateMultiple(roleinfo, pc);
return(ret);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="roleid"></param>
/// <returns>影响的记录行数</returns>
public int Delete(string roleid)
{
int ret = 0;
RoleInfoModel roleinfo = new RoleInfoModel();
roleinfo.RoleId = roleid;
ret = DbUtil.Current.Delete(roleinfo);
return(ret);
}
public MessageResult UpdateRoleInfo(RoleInfoModel roleInfo)
{
try
{
var result = roleBLL.UpdateRoleInfo(roleInfo);
return(MessageResult.Success(result));
}
catch (Exception ex)
{
return(MessageResult.Fail(ex.Message));
}
}
/// <summary>
/// 检查一个角色是否是超级管理员角色
/// </summary>
/// <param name="rId"></param>
private void CheckIsAdmin(int rId)
{
isAdmin = false;
RoleInfoModel roleInfo = RequestStar.GetRole(rId);
if (roleInfo != null)
{
if (roleInfo.IsAdmin == 1)
{
isAdmin = true;
}
}
}
// 在此添加你的代码...
public bool UpdateRoleAndPremission(RoleInfoModel roleInfo, List <string> roleActionList, out string message)
{
bool result = false;
message = "操作失败，更新角色信息异常，请与管理员联系";
try
{
BeginTransaction();
if (Update(roleInfo) > 0)
{
if (RemoveRoleAction(roleInfo.RoleId, null))
{
if (CreateRolePremissions(roleInfo.RoleId, roleActionList))
{
CommitTransaction();
GetRoleDomainList(true);
result = true;
message = "成功更新角色信息";
}
else
{
RollbackTransaction();
result = false;
message = "操作失败，更新角色权限信息异常，请与管理员联系";
}
}
else
{
RollbackTransaction();
result = false;
message = "操作失败，移除角色权限信息异常，请与管理员联系";
}
}
else
{
RollbackTransaction();
result = false;
message = "操作失败，更新角色信息异常，请与管理员联系";
}
}
catch (Exception ex)
{
RollbackTransaction();
LogUtil.Error("更新角色信息异常", ex);
throw ex;
}
return(result);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(RoleInfoModel model, string rights)
{
int i = role_dal.Add(model); //添加角色
if (i > 0) //当角色添加成功时，插入俞雨以前做的权限，防止影响其他地方
{
int rid = role_dal.GetMaxId();
List <string> cmdlist = new List <string>();
cmdlist.Add(string.Format("delete from rolerightrelative where roleID={0}", rid));
cmdlist.AddRange(rights.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries).Select(s => string.Format("insert into rolerightrelative(roleID,rightID) values ({0},{1})", rid, s)));
role_dal.Update(cmdlist);
}
return(i);
}
/// <summary>
/// 数据初始化
/// </summary>
private void InitData()
{
propertyList = new PropertyInfoBLL().GetAllPropertyinfo();
rolelist = role_bll.GetRoles(string.Empty);
RoleInfoModel allinfo = new RoleInfoModel();
allinfo.rid = 0;
allinfo.roleName = "全部";
rolelist.Insert(0, allinfo);
this.roleselect.DataTextField = "roleName";
this.roleselect.DataValueField = "rid";
this.roleselect.DataSource = rolelist;
this.roleselect.DataBind();
}
public ActionResult Edit(long id)
{
SetPrivileges();
var model = _iPrivilegesService.GetPlatformRole(id);
RoleInfoModel result = new RoleInfoModel()
{
ID = model.Id, RoleName = model.RoleName
};
var s = new Newtonsoft.Json.JsonSerializerSettings();
s.ReferenceLoopHandling = ReferenceLoopHandling.Ignore;
ViewBag.RolePrivilegeInfo = Newtonsoft.Json.JsonConvert.SerializeObject(model.RolePrivilegeInfo.Select(item => new { Privilege = item.Privilege }), s);
return(View(result));
}
public void TestRoleInfoModelCreateTable()
{
var entity = new RoleInfoModel {
RoleName = "RoleName", RoleDisplayName = "RoleDisplayName", CreateDateTime = DateTime.Now, Id = Guid.NewGuid().ToString(), LastUpdateDateTime = DateTime.Now
};
RoleInfoModel result;
using (var session = sessions.OpenSession())
{
session.Save(entity);
session.Flush();
result = session.Get <RoleInfoModel>(entity.Id);
}
Assert.AreEqual(entity.RoleName, result.RoleName);
}
//private const string RegisterEmail = "ODS.Email";
//private const string QueryStringKey = "ODS.QueryString";
public Configurations()
{
Exception = new ExceptionModel();
PageTitle = "Merachel";
HasHeader = true;
HasFooter = true;
HasMenuBar = true;
IsDashBoard = false;
ModuleName = "New Form";
MenuName = "New Form";
// Get current logon user without domain.
string userName = string.Empty;
if (HttpContext.Current.User.Identity.Name.IndexOf('@') > 0)
{
userName = HttpContext.Current.User.Identity.Name.Split('@')[0];
}
else
{
if (HttpContext.Current.User.Identity.Name.IndexOf('\\') > 0)
{
userName = HttpContext.Current.User.Identity.Name.Split('\\')[1];
}
}
SessionUserName = userName;
// Get all default settings.
this.MerachelUrl = GetServiceUrl(); //GetScheme() + HttpContext.Current.Request.Url.Authority + HttpContext.Current.Request.ApplicationPath.TrimEnd('/');
this.MerachelWebUrl = GetWebUrl();
JavaScriptAndCssVersion = ConfigurationManager.AppSettings["JavaScriptAndCssVersion"];
string cookieVersion = ConfigurationManager.AppSettings["CookieVersion"];
// Get configuration settings.
CookieNameConfiguration = "merachel-configuration-" + cookieVersion;
CookieValue = "{}";
AccountModel session = GetSessionInfo();
if (session != null)
{
RoleInfoModel role = (from obj in session.UserRoles where obj.Sequence == 1 select obj).FirstOrDefault();
RoleName = role.RoleName;
}
}
/// <summary>
/// 根据条件获取实体集合
/// </summary>
/// <param name="pc">pc</param>
/// <param name="obc">obc</param>
/// <returns>实体</returns>
public List <RoleInfoModel> RetrieveMultiple(ParameterCollection pc, OrderByCollection obc)
{
List <RoleInfoModel> roleinfos = new List <RoleInfoModel>();
RoleInfoModel roleinfo = new RoleInfoModel();
DataTable dt = DbUtil.Current.RetrieveMultiple(roleinfo, pc, obc);
for (int i = 0; i < dt.Rows.Count; i++)
{
roleinfo = new RoleInfoModel();
roleinfo.ConvertFrom(dt, i);
roleinfos.Add(roleinfo);
}
return(roleinfos);
}
private void InitData(RoleInfoModel entity)
{
InitProperty(entity);
TxtRoleName.Text = entity.RoleName;
TxtRoleDisplayName.Text = entity.RoleDisplayName;
TxtWorkflowName.Text = entity.WorkflowName;
TxtWorkflowDisplayName.Text = entity.WorkflowDisplayName;
ExistUserGroupList = UserOperationDAL.QueryAllUserGroupByRoleId(entity.Id);
ExistUserInfoList = UserOperationDAL.QueryAllUserInfoByRoleId(entity.Id);
ExistActionInfoList = UserOperationDAL.QueryAllActionInfoByRoleId(entity.Id);
ClearBindData();
LvUserGroupName.ItemsSource = ExistUserGroupList.DeepCopy();
LvUserName.ItemsSource = ExistUserInfoList.DeepCopy();
LvActionName.ItemsSource = ExistActionInfoList.DeepCopy();
LvWorkflowState.ItemsSource = UserOperationDAL.QueryAllWorkflowStateByRoleId(entity.Id);
}
public ActionResult Edit(long id)
{
SetPrivileges();
var model = _iPrivilegesService.GetPlatformRole(id);
RoleInfoModel result = new RoleInfoModel()
{
ID = model.Id, RoleName = model.RoleName
};
var settings = new JsonSerializerSettings();
settings.ReferenceLoopHandling = ReferenceLoopHandling.Ignore;
var privilege = RoleApplication.GetPrivileges(model.Id);
ViewBag.RolePrivilegeInfo = JsonConvert.SerializeObject(privilege.Select(item => new { Privilege = item }), settings);
return(View(result));
}
public void TestRoleInfoModelQueryAll()
{
var insertEntity = new RoleInfoModel {
RoleName = "RoleName", RoleDisplayName = "RoleDisplayName", CreateDateTime = DateTime.Now, Id = Guid.NewGuid().ToString(), LastUpdateDateTime = DateTime.Now
};
using (var session = sessions.OpenSession())
{
session.Save(insertEntity);
session.Flush();
ICriteria crit = session.CreateCriteria(typeof(RoleInfoModel));
var entityList = crit.List();
var resultList = session.CreateQuery("from RoleInfoModel ").List <RoleInfoModel>();
Assert.AreEqual(entityList.Count, resultList.Count);
}
}
public void AddStateRoleByCondition(string workflowName, string stateNodeName, PartnerLinkModel partnerLink)
{
var workflowStateEntity = GetWorkflowStateInfoByCondition(workflowName, stateNodeName);
var roleInfoEntity = UserOperationDAL.QueryRoleInfoByWorkflowStateId(workflowStateEntity.Id);
if (roleInfoEntity == null)
{
roleInfoEntity = UserOperationDAL.QueryRoleInfoByCondition(workflowName, partnerLink.MyRole);
if (roleInfoEntity == null)
{
roleInfoEntity = new RoleInfoModel
{
CreateDateTime = DateTime.Now,
LastUpdateDateTime = DateTime.Now,
RoleDisplayName = partnerLink.MyRole,
RoleName = partnerLink.MyRole,
WorkflowName = workflowName,
WorkflowDisplayName = workflowName,
};
DataOperationBLL.Current.Insert(roleInfoEntity);
}
else
{
roleInfoEntity.RoleDisplayName = partnerLink.MyRole;
roleInfoEntity.WorkflowDisplayName = workflowName;
roleInfoEntity.LastUpdateDateTime = DateTime.Now;
DataOperationBLL.Current.Modify(roleInfoEntity);
}
UserOperationDAL.AddWorkflowStateInRole(workflowStateEntity.Id, roleInfoEntity.Id);
}
else
{
roleInfoEntity.RoleName = partnerLink.MyRole;
roleInfoEntity.WorkflowName = workflowName;
roleInfoEntity.RoleDisplayName = partnerLink.MyRole;
roleInfoEntity.WorkflowDisplayName = workflowName;
roleInfoEntity.LastUpdateDateTime = DateTime.Now;
DataOperationBLL.Current.Modify(roleInfoEntity);
}
}
