/// <summary> /// 修改 /// </summary> /// <param name="model">系统权限子类别实体类</param> /// <returns></returns> public bool Update(EyouSoft.Model.SystemStructure.SysPermissionClass model) { if (model == null) { return(false); } return(dal.Update(model)); }
/// <summary> /// 添加 /// </summary> /// <param name="model">系统权限子类别实体类</param> /// <returns></returns> public virtual bool Add(EyouSoft.Model.SystemStructure.SysPermissionClass model) { DbCommand dc = this._database.GetSqlStringCommand(SQL_SysPermissionClass_ADD); this._database.AddInParameter(dc, "CategoryId", DbType.Int32, model.CategoryId); this._database.AddInParameter(dc, "ClassName", DbType.String, model.ClassName); return(DbHelper.ExecuteSql(dc, this._database) > 0 ? true : false); }
/// <summary> /// 获取详细信息 /// </summary> /// <param name="ID">主键编号</param> /// <returns></returns> public virtual EyouSoft.Model.SystemStructure.SysPermissionClass GetModel(int ID) { DbCommand dc = this._database.GetSqlStringCommand(SQL_SysPermissionClass_SELECT + string.Format(" WHERE ID={0}", ID)); EyouSoft.Model.SystemStructure.SysPermissionClass model = null; using (IDataReader dr = DbHelper.ExecuteReader(dc, this._database)) { if (dr.Read()) { model = new EyouSoft.Model.SystemStructure.SysPermissionClass(); model.Id = dr.GetInt32(0); model.CategoryId = dr.GetInt32(1); model.ClassName = dr.GetString(2); model.SortId = dr.GetInt32(3); model.IsEnable = dr.GetString(4) == "1" ? true : false; } } return(model); }
/// <summary> /// 根据权限类别,权限大类别获取数据 /// </summary> /// <param name="PermissionTypes">权限类别集合</param> /// <param name="CategroyType">权限大类别 >0返回指定大类别的数据,否则返回全部</param> /// <param name="LoadPermission">是否立即读取明细权限</param> /// <returns></returns> public virtual IList <EyouSoft.Model.SystemStructure.SysPermissionClass> GetList(string PermissionTypes, int CategroyType, bool LoadPermission) { #region 生成SQL StringBuilder strSql = new StringBuilder(SQL_SysPermissionClass_SELECT); if (!string.IsNullOrEmpty(PermissionTypes)) { strSql.AppendFormat(" WHERE CategoryId in(select id from tbl_SysPermissionCategory where TypeId in({0}))", PermissionTypes); } if (CategroyType > 0) { strSql.AppendFormat(" WHERE CategoryId={0} ", CategroyType); } #endregion SysPermission Permission = new SysPermission(); IList <EyouSoft.Model.SystemStructure.SysPermissionClass> list = new List <EyouSoft.Model.SystemStructure.SysPermissionClass>(); DbCommand dc = this._database.GetSqlStringCommand(strSql.ToString()); using (IDataReader dr = DbHelper.ExecuteReader(dc, this._database)) { while (dr.Read()) { EyouSoft.Model.SystemStructure.SysPermissionClass model = new EyouSoft.Model.SystemStructure.SysPermissionClass(); model.Id = dr.GetInt32(0); model.CategoryId = dr.GetInt32(1); model.ClassName = dr.GetString(2); model.SortId = dr.GetInt32(3); model.IsEnable = dr.GetString(4) == "1" ? true : false; if (!LoadPermission) { model.SysPermission = new List <EyouSoft.Model.SystemStructure.SysPermission>(); } else { model.SysPermission = Permission.GetSysPermissionList(0, model.Id); } list.Add(model); model = null; } } Permission = null; return(list); }