/// <summary> /// 获取列表 /// </summary> /// <param name="userInfo">用户</param> /// <returns>数据表</returns> public DataTable GetDataTable(BaseUserInfo userInfo) { var dt = new DataTable(BaseDictionaryEntity.CurrentTableName); var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterReadDb(userInfo, parameter, (dbHelper) => { var tableName = BaseDictionaryEntity.CurrentTableName; if (userInfo != null && !string.IsNullOrEmpty(userInfo.SystemCode)) { tableName = userInfo.SystemCode + "Items"; } var itemsManager = new BaseDictionaryManager(dbHelper, userInfo, tableName); // 若是系统管理员,那就返回全部数据 if (BaseUserManager.IsAdministrator(userInfo.Id)) { var parameters = new List <KeyValuePair <string, object> > { new KeyValuePair <string, object>(BaseDictionaryItemEntity.FieldDeleted, 0) }; dt = itemsManager.GetDataTable(parameters, BaseDictionaryItemEntity.FieldSortCode); } else { // 按数据权限来过滤数据 var permissionScopeManager = new BasePermissionScopeManager(dbHelper, userInfo); var ids = permissionScopeManager.GetResourceScopeIds(userInfo.SystemCode, userInfo.Id, tableName, "Resource.ManagePermission"); dt = itemsManager.GetDataTable(ids); BaseUtil.SetFilter(dt, BaseDictionaryItemEntity.FieldDeleted, "0"); } dt.TableName = tableName; }); return(dt); }
/// <summary> /// GetListByCode /// </summary> /// <param name="dbHelper"></param> /// <param name="userInfo"></param> /// <param name="code"></param> /// <returns></returns> public List <BaseDictionaryItemEntity> GetListByCode(IDbHelper dbHelper, BaseUserInfo userInfo, string code) { List <BaseDictionaryItemEntity> result = null; // 检查有其他目标数据库表存储了数据 var itemsManager = new BaseDictionaryManager(dbHelper, userInfo); var itemsEntity = BaseEntity.Create <BaseDictionaryEntity>(itemsManager.GetDataTable(new KeyValuePair <string, object>(BaseDictionaryEntity.FieldCode, code))); if (itemsEntity != null) { var itemDetailsManager = new BaseDictionaryItemManager(dbHelper, userInfo); // 这里只要有效的,没被删除的 var parameters = new List <KeyValuePair <string, object> > { // 管理的时候无效的也需要被管理 new KeyValuePair <string, object>(BaseDictionaryItemEntity.FieldDictionaryId, itemsEntity.Id), new KeyValuePair <string, object>(BaseDictionaryItemEntity.FieldEnabled, 1), new KeyValuePair <string, object>(BaseDictionaryItemEntity.FieldDeleted, 0) }; result = itemDetailsManager.GetList <BaseDictionaryItemEntity>(parameters, BaseDictionaryItemEntity.FieldSortCode); } return(result); }