private bool UpdateSecyurity() { sys_security_level sys = new sys_security_level(); if (!string.IsNullOrEmpty(this.sys_security_level_name.Text.Trim().ToString())) { sys.name = this.sys_security_level_name.Text.Trim().ToString(); } //激活 if (this.active.Checked) { sys.is_active = 1; } else { sys.is_active = 0; } sys.id = id; //更新sys_security_level表 var res = sys_security.UpdateSecurityLevel(sys, GetLoginUserId()); if (res == ERROR_CODE.ERROR) { Response.Write("<script>alert(\"权限等级名称修改失败\");</script>"); return(false); } if (res == ERROR_CODE.USER_NOT_FIND) // 用户丢失 { Response.Write("<script>alert('查询不到用户,请重新登陆');</script>"); Response.Redirect("Login.aspx"); } return(true); }
public ERROR_CODE UpdateSecurityLevel(sys_security_level seclev, long user_id) { var user = UserInfoBLL.GetUserInfo(user_id); if (user == null) { // 查询不到用户,用户丢失 return(ERROR_CODE.USER_NOT_FIND); } var older = GetSecurityLevel(seclev.id); var old = GetSecurityLevel(seclev.id); old.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now); old.update_user_id = user_id; old.name = seclev.name; old.is_active = seclev.is_active; bool k = new sys_security_level_dal().Update(old); if (k == false) { return(ERROR_CODE.ERROR); } var add_account_log = new sys_oper_log() { user_cate = "用户", user_id = user.id, name = user.name, phone = user.mobile == null ? "" : user.mobile, oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now), oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.SECURITY_LEVEL, oper_object_id = seclev.id,// 操作对象id oper_type_id = (int)OPER_LOG_TYPE.UPDATE, oper_description = new sys_security_level_dal().CompareValue(old, older), remark = "修改权限点关联模板" }; // 创建日志 new sys_oper_log_dal().Insert(add_account_log); // 插入日志 return(ERROR_CODE.SUCCESS); }
/// <summary> /// 复制安全等级 /// </summary> /// <param name="user_id"></param> /// <param name="id"></param> /// <param name="copy_id"></param> /// <returns></returns> public bool CopySecurityLevel(long user_id, int id, out int copy_id) { var s1 = new sys_security_level_dal().FindById(id); copy_id = -1; if (s1 == null) { return(false); } sys_security_level s = new sys_security_level(); s.id = copy_id = (int)(_dal.GetNextIdCom()); s.name = "(copy of)" + s1.name; s.is_active = 1; s.is_active = 0; s.license_type_id = s1.license_type_id; s.create_time = s.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now); s.create_user_id = s.update_user_id = user_id; ss_dal.Insert(s); //更新复制插入语句 //insert into sys_security_level_limit(id,security_level_id,limit_id,limit_type_value_id) select (select f_nextval('seq_com')),3,limit_id,limit_type_value_id from sys_security_level_limit where security_level_id=2 try { if (ssl_dal.ExecuteSQL($"insert into sys_security_level_limit(id,security_level_id,limit_id,limit_type_value_id) select (select f_nextval('seq_com')),{copy_id},limit_id,limit_type_value_id from sys_security_level_limit where security_level_id={id}") != 130) { return(false); } } catch { return(false); } sys_security_level_module_dal ssm_dal = new sys_security_level_module_dal(); try { if (ssm_dal.ExecuteSQL($"insert into `sys_security_level_module` (`id`, `security_level_id`, `module_id`, `module_limit_id`, `module_limit_value`, `module_value`) select (select f_nextval('seq_com')),{copy_id}, `module_id`, `module_limit_id`, `module_limit_value`, `module_value` from sys_security_level_module where security_level_id={id}") <= 0) { return(false); } } catch { return(false); } var user = UserInfoBLL.GetUserInfo(user_id); if (user == null) { // 查询不到用户,用户丢失 return(false); } try { var add_account_log = new sys_oper_log() { user_cate = "用户", user_id = user.id, name = user.name, phone = user.mobile == null ? "" : user.mobile, oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now), oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.SECURITY_LEVEL, oper_object_id = s.id,// 操作对象id oper_type_id = (int)OPER_LOG_TYPE.ADD, oper_description = ss_dal.AddValue(s), remark = "新增权限点关联模板" }; // 创建日志 new sys_oper_log_dal().Insert(add_account_log); // 插入日志 } catch { } return(true); }