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