/// <summary>
/// 修改
/// </summary>
/// <param name="model">系统权限大类别实体类</param>
/// <returns></returns>
public bool Update(EyouSoft.Model.SystemStructure.SysPermissionCategory 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.SysPermissionCategory model)
{
DbCommand dc = this._database.GetSqlStringCommand(SQL_SysPermissionCategory_ADD);
this._database.AddInParameter(dc, "typeid", DbType.Int32, model.TypeId);
this._database.AddInParameter(dc, "CategroyName", DbType.String, model.CategoryName);
return(DbHelper.ExecuteSql(dc, this._database) > 0 ? true : false);
}
/// <summary>
/// 修改
/// </summary>
/// <param name="model">系统权限大类别实体类</param>
/// <returns></returns>
public virtual bool Update(EyouSoft.Model.SystemStructure.SysPermissionCategory model)
{
DbCommand dc = this._database.GetSqlStringCommand(SQL_SysPermissionCategory_UPDATE);
this._database.AddInParameter(dc, "TypeId", DbType.Int32, model.TypeId);
this._database.AddInParameter(dc, "CategroyName", DbType.String, model.CategoryName);
this._database.AddInParameter(dc, "SortId", DbType.Int32, model.SortId);
this._database.AddInParameter(dc, "IsEnable", DbType.String, model.IsEnable ? "1" : "0");
return(DbHelper.ExecuteSql(dc, this._database) > 0 ? true : false);
}
protected void us_rpt_PCateList_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemIndex != -1)
{
CustomRepeater rpt = e.Item.FindControl("us_rpt_PClassList") as CustomRepeater;
if (rpt != null)
{
EyouSoft.Model.SystemStructure.SysPermissionCategory categoryModel = e.Item.DataItem as EyouSoft.Model.SystemStructure.SysPermissionCategory;
rpt.DataSource = categoryModel.SysPermissionClass;
rpt.DataBind();
}
}
}
protected void BindPermit()
{
EyouSoft.Model.SystemStructure.SysPermissionCategory permissionCategory =
EyouSoft.BLL.SystemStructure.SysPermission.CreateInstance().GetAllPermissionByUser(
SiteUserInfo.CompanyRole.RoleItems);
if (permissionCategory == null)
{
return;
}
ltrCategoryName.Text = permissionCategory.CategoryName;
rs_PermitList.DataSource = permissionCategory.SysPermissionClass;
rs_PermitList.DataBind();
}
/// <summary>
/// 获取实体
/// </summary>
/// <param name="ID">主键编号</param>
/// <returns></returns>
public virtual EyouSoft.Model.SystemStructure.SysPermissionCategory GetModel(int ID)
{
EyouSoft.Model.SystemStructure.SysPermissionCategory model = null;
DbCommand dc = this._database.GetSqlStringCommand(SQL_SysPermissionCategroy_GetModel);
this._database.AddInParameter(dc, "ID", DbType.Int32, ID);
using (IDataReader dr = DbHelper.ExecuteReader(dc, this._database))
{
if (dr.Read())
{
model = new EyouSoft.Model.SystemStructure.SysPermissionCategory();
model.Id = dr.GetInt32(0);
model.TypeId = dr.GetInt32(1);
model.CategoryName = dr.GetString(2);
model.SortId = dr.GetInt32(3);
model.IsEnable = dr.GetString(4) == "1" ? true : false;
}
}
return(model);
}
/// <summary>
/// 分页获取权限大类别列表
/// </summary>
/// <param name="pageSize">每页显示条数</param>
/// <param name="pageIndex">当前页码</param>
/// <param name="recordCount">总记录数</param>
/// <param name="PermissionType">权限类别数组（如组团，地接等等）</param>
/// <returns></returns>
public virtual IList <EyouSoft.Model.SystemStructure.SysPermissionCategory> GetList(int pageSize, int pageIndex, ref int recordCount, int[] PermissionType)
{
SysPermissionClass permissionClass = new SysPermissionClass();
IList <EyouSoft.Model.SystemStructure.SysPermissionCategory> list = new List <EyouSoft.Model.SystemStructure.SysPermissionCategory>();
string tableName = "tbl_SysPermissionCategory";
string fields = "ID,TypeId,CatagroyName,IsEnable,SortId";
string primaryKey = "ID";
string OrderbyString = "SortId asc,ID desc";
#region 生成查询条件
StringBuilder strWhere = new StringBuilder();
if (PermissionType != null && PermissionType.Length > 0)
{
strWhere.Append("TypeId in(");
for (int i = 0; i < PermissionType.Length; i++)
{
strWhere.AppendFormat("{0}{1}", i > 0 ? "," : "", PermissionType[i].ToString());
}
strWhere.Append(")");
}
#endregion
using (IDataReader dr = DbHelper.ExecuteReader(this._database, pageSize, pageIndex, ref recordCount, tableName, primaryKey, fields, strWhere.ToString(), OrderbyString))
{
while (dr.Read())
{
EyouSoft.Model.SystemStructure.SysPermissionCategory model = new EyouSoft.Model.SystemStructure.SysPermissionCategory();
model.Id = dr.GetInt32(0);
model.TypeId = dr.GetInt32(1);
model.CategoryName = dr.GetString(2);
model.IsEnable = dr.GetString(3) == "1" ? true : false;
model.SortId = dr.GetInt32(4);
model.SysPermissionClass = permissionClass.GetList(string.Empty, model.Id, true);
list.Add(model);
model = null;
}
}
permissionClass = null;
return(list);
}
/// <summary>
/// 获取指定权限类别的权限详细列表
/// </summary>
/// <param name="PermissionType">权限类别数组（如组团，地接等等）</param>
/// <param name="LoadPermission">是否立即读取明细权限</param>
/// <returns></returns>
public virtual IList <EyouSoft.Model.SystemStructure.SysPermissionCategory> GetList(int[] PermissionType, bool LoadPermission)
{
IList <EyouSoft.Model.SystemStructure.SysPermissionCategory> list = new List <EyouSoft.Model.SystemStructure.SysPermissionCategory>();
SysPermissionClass permissionClass = new SysPermissionClass();
#region 生成查询语句
StringBuilder strSql = new StringBuilder();
strSql.Append(SQL_SysPermissionCategroy_SELECT);
if (PermissionType != null && PermissionType.Length > 0)
{
strSql.Append(" where typeId in(");
for (int i = 0; i < PermissionType.Length; i++)
{
strSql.AppendFormat("{0}{1}", i > 0 ? "," : "", PermissionType[i].ToString());
}
strSql.Append(")");
}
#endregion
DbCommand dc = this._database.GetSqlStringCommand(strSql.ToString());
using (IDataReader dr = DbHelper.ExecuteReader(dc, this._database))
{
while (dr.Read())
{
EyouSoft.Model.SystemStructure.SysPermissionCategory model = new EyouSoft.Model.SystemStructure.SysPermissionCategory();
model.Id = dr.GetInt32(0);
model.TypeId = dr.GetInt32(1);
model.CategoryName = dr.GetString(2);
model.IsEnable = dr.GetString(3) == "1" ? true : false;
model.SortId = dr.GetInt32(4);
model.SysPermissionClass = permissionClass.GetList(string.Empty, model.Id, LoadPermission);
list.Add(model);
model = null;
}
}
permissionClass = null;
return(list);
}
