public void GetRuleAjaxJson(string userId, string projectId) { SystemUserAndRule rule = _userAndRuleService.GetRule(userId, projectId); Context.Response.Write(JsonConvert.SerializeObject(rule)); Context.Response.End(); }
/// <summary> /// 新增用户权限 /// </summary> /// <param name="rules">rules</param> /// Author : Napoleon /// Created : 2015-01-23 10:04:00 public int InsertUserRule(SystemUserAndRule rules) { int count; try { string sql = "SELECT * FROM dbo.System_UserAndRule WHERE UserId=@UserId AND RuleParentId=@RuleParentId AND ProjectId=@ProjectId"; SqlParameter[] parameters = { new SqlParameter("@UserId", rules.UserId), new SqlParameter("@RuleParentId", rules.RuleParentId), new SqlParameter("@ProjectId", rules.ProjectId) }; DataTable dt = DbHelper.GetDataTable(sql, parameters); if (dt.Rows.Count > 0) { count = -1; } else { sql = "INSERT INTO dbo.System_UserAndRule( Id, UserId, RuleId, RuleParentId,ProjectId ) VALUES (@Id,@UserId,@RuleId,@RuleParentId,@ProjectId)"; count = DbHelper.ExecuteSql(sql, rules); } } catch (Exception exception) { count = 0; Log4Dao.InsertLog4(exception.Message); } return(count); }
/// <summary> /// 用户校验 /// </summary> /// <param name="userName">用户账号</param> /// <param name="passWord">用户密码</param> /// Author : Napoleon /// Created : 2015-01-07 10:04:36 public ActionResult CheckUser(string userName, string passWord) { SystemUser user = _userService.CheckUser(userName, passWord, PublicFields.ProjectId); string status = "failue", msg = "登录失败!", json; if (user != null) { if (user.IsUse.Equals(PublicFields.IsDefaultUse)) { //用户信息 user.WriteCookie(PublicFields.UserCookie); //用户权限 SystemUserAndRule rule = _userAndRuleService.GetRule(user.Id, PublicFields.ProjectId); if (rule == null) { msg = "登录失败,该账号不能登录本系统!"; } else { rule.RuleId.WriteCookie(PublicFields.RuleIdCookies); status = "success"; msg = "登录成功!"; } } else { msg = "登录失败,该账号已禁用,请联系管理员!"; } } json = PublicFunc.ModelToJson(status, msg); return(Content(json)); }
/// <summary> /// 新增用户权限 /// </summary> /// <param name="projectId">projectId</param> /// <param name="userId">The user identifier.</param> /// <param name="company">The company.</param> /// <param name="rule">The rule.</param> /// Author : Napoleon /// Created : 2015-01-23 09:48:45 public ActionResult SavePermitAdd(string projectId, string userId, string company, string rule) { SystemUserAndRule rules = new SystemUserAndRule(); rules.ProjectId = projectId; rules.Id = CustomId.GetCustomId(); rules.UserId = userId; rules.RuleParentId = company; rules.RuleId = rule; int count = _userAndRuleService.InsertUserRule(rules); string status = "failue", msg, json; switch (count) { case -1: msg = "添加失败,该用户已经拥有类似权限,不能重复添加!"; break; case 1: status = "success"; msg = "添加成功!"; break; default: msg = "添加失败!"; break; } json = PublicFunc.ModelToJson(status, msg); return(Content(json)); }
/// <summary> /// 获取权限ID /// </summary> /// <param name="userId">用户ID</param> /// <param name="projectId">系统代码</param> /// Author : Napoleon /// Created : 2015-01-20 13:24:49 public SystemUserAndRule GetRule(string userId, string projectId) { SystemUserAndRule userAndRule = new SystemUserAndRule(); try { string sql = "SELECT Id,ProjectId,UserId,RuleId,RuleParentId FROM dbo.System_UserAndRule WHERE UserId=@UserId AND ProjectId=@ProjectId"; userAndRule = DbHelper.GetEnumerable<SystemUserAndRule>(sql, new { @UserId = userId, @ProjectId = projectId }); } catch (Exception exception) { Log4Dao.InsertLog4(exception.Message); } return userAndRule; }
/// <summary> /// 获取权限ID /// </summary> /// <param name="userId">用户ID</param> /// <param name="projectId">系统代码</param> /// Author : Napoleon /// Created : 2015-01-20 13:24:49 public SystemUserAndRule GetRule(string userId, string projectId) { SystemUserAndRule userAndRule = new SystemUserAndRule(); try { string sql = "SELECT Id,ProjectId,UserId,RuleId,RuleParentId FROM dbo.System_UserAndRule WHERE UserId=@UserId AND ProjectId=@ProjectId"; userAndRule = DbHelper.GetEnumerable <SystemUserAndRule>(sql, new { @UserId = userId, @ProjectId = projectId }); } catch (Exception exception) { Log4Dao.InsertLog4(exception.Message); } return(userAndRule); }
/// <summary> /// 验证用户信息 /// </summary> /// Author : Napoleon /// Created : 2015-06-06 16:29:44 public ActionResult CheckUser(string userName, string passWord) { string status = "failue", msg, json; try { SystemUser user = _service.CheckUserXml(userName, passWord, PublicFields.ProjectId); if (user != null) { user.WriteCookie(PublicFields.UserCookies); //用户权限 SystemUserAndRule rule = _service.GetRuleXml(user.Id, PublicFields.ProjectId); if (rule == null) { msg = "登录失败,该账号不能登录本系统!"; } else { rule.RuleId.WriteCookie(PublicFields.RuleIdCookies); status = "success"; msg = "登录成功!"; } } else { msg = "登录失败,账号或密码错误!"; } } catch (Exception exception) { msg = "登录出错!"; Log4Dao.InsertLog4(exception.Message); } json = PublicFunc.ModelToJson(status, msg); return(Content(json)); }
public string GetRuleJson(string userId, string projectId) { SystemUserAndRule rule = _userAndRuleService.GetRule(userId, projectId); return(JsonConvert.SerializeObject(rule)); }
public SystemUserAndRule GetRuleXml(string userId, string projectId) { SystemUserAndRule rule = _userAndRuleService.GetRule(userId, projectId); return(rule); }
/// <summary> /// 新增用户权限 /// </summary> /// <param name="rules">rules</param> /// Author : Napoleon /// Created : 2015-01-23 10:04:00 public int InsertUserRule(SystemUserAndRule rules) { return(_userAndRuleDao.InsertUserRule(rules)); }
/// <summary> /// 新增用户权限 /// </summary> /// <param name="rules">rules</param> /// Author : Napoleon /// Created : 2015-01-23 10:04:00 public int InsertUserRule(SystemUserAndRule rules) { int count; try { string sql = "SELECT * FROM dbo.System_UserAndRule WHERE UserId=@UserId AND RuleParentId=@RuleParentId AND ProjectId=@ProjectId"; SqlParameter[] parameters = { new SqlParameter("@UserId",rules.UserId), new SqlParameter("@RuleParentId",rules.RuleParentId), new SqlParameter("@ProjectId",rules.ProjectId) }; DataTable dt = DbHelper.GetDataTable(sql, parameters); if (dt.Rows.Count > 0) { count = -1; } else { sql = "INSERT INTO dbo.System_UserAndRule( Id, UserId, RuleId, RuleParentId,ProjectId ) VALUES (@Id,@UserId,@RuleId,@RuleParentId,@ProjectId)"; count = DbHelper.ExecuteSql(sql, rules); } } catch (Exception exception) { count = 0; Log4Dao.InsertLog4(exception.Message); } return count; }
/// <summary> /// 新增用户权限 /// </summary> /// <param name="projectId">projectId</param> /// <param name="userId">The user identifier.</param> /// <param name="company">The company.</param> /// <param name="rule">The rule.</param> /// Author : Napoleon /// Created : 2015-01-23 09:48:45 public ActionResult SavePermitAdd(string projectId, string userId, string company, string rule) { SystemUserAndRule rules = new SystemUserAndRule(); rules.ProjectId = projectId; rules.Id = CustomId.GetCustomId(); rules.UserId = userId; rules.RuleParentId = company; rules.RuleId = rule; int count = _userAndRuleService.InsertUserRule(rules); string status = "failue", msg, json; switch (count) { case -1: msg = "添加失败,该用户已经拥有类似权限,不能重复添加!"; break; case 1: status = "success"; msg = "添加成功!"; break; default: msg = "添加失败!"; break; } json = PublicFunc.ModelToJson(status, msg); return Content(json); }