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);
}
