/// <summary> /// 根据ID查询 /// </summary> /// <param name="id">id</param> /// Author : Napoleon /// Created : 2015-01-27 16:24:30 public SystemRule GetRule(string id) { SystemRule rule = new SystemRule(); try { string sql = "SELECT ProjectId ,Id ,Name ,ParentId,Person,Address,TelPhone ,Sort ,Remark ,Operator FROM dbo.System_Rule WHERE Id=@Id"; rule = DbHelper.GetEnumerable<SystemRule>(sql, new { @Id = id }); } catch (Exception exception) { Log4Dao.InsertLog4(exception.Message); } return rule; }
/// <summary> /// 更新 /// </summary> /// <param name="rule">The rule.</param> /// Author : Napoleon /// Created : 2015-01-27 16:28:34 public int UpdateRule(SystemRule rule) { return _ruleDao.UpdateRule(rule); }
/// <summary> /// 新增角色 /// </summary> /// <param name="rule">The rule.</param> /// Author : Napoleon /// Created : 2015-01-27 15:29:05 public int InsertRule(SystemRule rule) { return _ruleDao.InsertRule(rule); }
/// <summary> /// 更新角色 /// </summary> /// <param name="projectId">The project identifier.</param> /// <param name="id">The identifier.</param> /// <param name="parentId">The parent identifier.</param> /// <param name="name">The name.</param> /// <param name="sort">The sort.</param> /// <param name="remark">The remark.</param> /// Author : Napoleon /// Created : 2015-01-27 16:27:19 public ActionResult UpdateRule(string projectId, string id, string parentId, string name, decimal sort, string remark) { SystemRule rule = new SystemRule(); rule.ProjectId = projectId; rule.Id = id; rule.ParentId = string.IsNullOrWhiteSpace(parentId) ? "0" : parentId; rule.Name = name; rule.Sort = sort; rule.Remark = remark; rule.Operator = PublicFields.UserCookie.ReadCookie<SystemUser>().UserName; int count = _ruleService.UpdateRule(rule); 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> /// 更新 /// </summary> /// <param name="rule">The rule.</param> /// Author : Napoleon /// Created : 2015-01-27 16:28:34 public int UpdateRule(SystemRule rule) { int count; try { string sql = "SELECT Id FROM dbo.System_Rule WHERE ProjectId=@ProjectId AND Name=@Name"; SqlParameter[] parameters = { new SqlParameter("@ProjectId",rule.ProjectId), new SqlParameter("@Name",rule.Name) }; DataTable dt = DbHelper.GetDataTable(sql, parameters); if (dt.Rows.Count == 0 || dt.Rows[0][0].ToString().Equals(rule.Id)) { sql = "UPDATE dbo.System_Rule SET Name=@Name,ParentId=@ParentId,Sort=@Sort,Remark=@Remark,Operator=@Operator WHERE Id=@Id"; count = DbHelper.ExecuteSql(sql, rule); } else { count = -1; } } catch (Exception exception) { count = 0; Log4Dao.InsertLog4(exception.Message); } return count; }
/// <summary> /// 新增角色 /// </summary> /// <param name="rule">rule</param> /// Author : Napoleon /// Created : 2015-01-27 15:29:05 public int InsertRule(SystemRule rule) { int count; try { string sql = "SELECT Id FROM dbo.System_Rule WHERE ProjectId=@ProjectId AND Name=@Name"; SqlParameter[] parameters = { new SqlParameter("@ProjectId",rule.ProjectId), new SqlParameter("@Name", rule.Name) }; DataTable dt = DbHelper.GetDataTable(sql, parameters); if (dt.Rows.Count > 0) { count = -1; } else { sql = "INSERT INTO dbo.System_Rule (ProjectId,Id,Name,ParentId,Sort,Remark,Operator) VALUES (@ProjectId,@Id,@Name,@ParentId,@Sort,@Remark,@Operator)"; count = DbHelper.ExecuteSql(sql, rule); } } catch (Exception exception) { count = 0; Log4Dao.InsertLog4(exception.Message); } return count; }