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