/// <summary> /// 获取菜单模块树型列表 /// </summary> /// <param name="systemCode">子系统</param> /// <param name="isMenu">是否菜单(0/1)</param> public DataTable GetModuleTree(string systemCode, string isMenu = null) { if (string.IsNullOrEmpty(systemCode)) { systemCode = "Base"; } //读取选定子系统的菜单模块 var manager = new BaseModuleManager(UserInfo, systemCode + "Module"); // 获取所有数据 var parameters = new List <KeyValuePair <string, object> >(); if (ValidateUtil.IsInt(isMenu)) { parameters.Add(new KeyValuePair <string, object>(BaseModuleEntity.FieldIsMenu, isMenu)); } parameters.Add(new KeyValuePair <string, object>(BaseModuleEntity.FieldEnabled, 1)); parameters.Add(new KeyValuePair <string, object>(BaseModuleEntity.FieldDeleted, 0)); //2017.12.20增加默认的HttpRuntime.Cache缓存 var cacheKey = "DataTable." + systemCode + ".ModuleTree." + isMenu; //var cacheTime = default(TimeSpan); var cacheTime = TimeSpan.FromMilliseconds(86400000); return(CacheUtil.Cache <DataTable>(cacheKey, () => manager.GetModuleTree(manager.GetDataTable(parameters, BaseModuleEntity.FieldSortCode)), true, false, cacheTime)); //直接读取数据库 //return manager.GetModuleTree(manager.GetModuleTree(manager.GetDataTable(parameters, BaseModuleEntity.FieldSortCode))); }
/// <summary> /// 获取模块列表 /// </summary> /// <param name="userInfo">用户</param> /// <returns>数据表</returns> public DataTable GetDataTable(BaseUserInfo userInfo) { // 写入调试信息 #if (DEBUG) int milliStart = BaseBusinessLogic.StartDebug(userInfo, MethodBase.GetCurrentMethod()); #endif // 加强安全验证防止未授权匿名调用 #if (!DEBUG) LogOnService.UserIsLogOn(userInfo); #endif DataTable dataTable = new DataTable(BaseModuleEntity.TableName); using (IDbHelper dbHelper = DbHelperFactory.GetHelper(BaseSystemInfo.UserCenterDbType)) { try { dbHelper.Open(UserCenterDbConnection); string tableName = BaseModuleEntity.TableName; if (!string.IsNullOrEmpty(BaseSystemInfo.SystemCode)) { tableName = BaseSystemInfo.SystemCode + "Module"; } BaseModuleManager moduleManager = new BaseModuleManager(dbHelper, userInfo, tableName); dataTable = moduleManager.GetDataTable( new KeyValuePair <string, object>(BaseModuleEntity.FieldDeletionStateCode, 0) //, new KeyValuePair<string, object>(BaseModuleEntity.FieldEnabled, 1) , BaseModuleEntity.FieldSortCode); dataTable.DefaultView.Sort = BaseModuleEntity.FieldSortCode; dataTable.TableName = BaseModuleEntity.TableName; BaseLogManager.Instance.Add(dbHelper, userInfo, this.serviceName, AppMessage.ModuleService_GetDataTable, MethodBase.GetCurrentMethod()); } catch (Exception ex) { BaseExceptionManager.LogException(dbHelper, userInfo, ex); throw ex; } finally { dbHelper.Close(); } } // 写入调试信息 #if (DEBUG) BaseBusinessLogic.EndDebug(MethodBase.GetCurrentMethod(), milliStart); #endif return(dataTable); }
/// <summary> /// 按主键数组获取列表 /// </summary> /// <param name="userInfo">用户</param> /// <param name="ids">角色主键</param> /// <returns>数据表</returns> public DataTable GetDataTableByIds(BaseUserInfo userInfo, string[] ids) { var result = new DataTable(BaseRoleEntity.TableName); var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterReadDb(userInfo, parameter, (dbHelper) => { string tableName = userInfo.SystemCode + "Module"; var manager = new BaseModuleManager(dbHelper, userInfo, tableName); result = manager.GetDataTable(BaseModuleEntity.FieldId, ids, BaseModuleEntity.FieldSortCode); result.TableName = BaseModuleEntity.TableName; }); return(result); }
/// <summary> /// 获取模块列表 /// </summary> /// <param name="userInfo">用户</param> /// <returns>数据表</returns> public DataTable GetDataTable(BaseUserInfo userInfo) { var result = new DataTable(BaseModuleEntity.TableName); var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterReadDb(userInfo, parameter, (dbHelper) => { string tableName = userInfo.SystemCode + "Module"; var manager = new BaseModuleManager(dbHelper, userInfo, tableName); result = manager.GetDataTable( new KeyValuePair <string, object>(BaseModuleEntity.FieldDeletionStateCode, 0) //, new KeyValuePair<string, object>(BaseModuleEntity.FieldEnabled, 1) , BaseModuleEntity.FieldSortCode); result.DefaultView.Sort = BaseModuleEntity.FieldSortCode; result.TableName = BaseModuleEntity.TableName; }); return(result); }
/// <summary> /// 按父节点获得列表 /// </summary> /// <param name="userInfo">用户</param> /// <param name="parentId">父结点主键</param> /// <returns>数据表</returns> public DataTable GetDataTableByParent(BaseUserInfo userInfo, string parentId) { var result = new DataTable(BaseModuleEntity.CurrentTableName); var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterReadDb(userInfo, parameter, (dbHelper) => { var tableName = userInfo.SystemCode + "Module"; var manager = new BaseModuleManager(dbHelper, userInfo, tableName); var parameters = new List <KeyValuePair <string, object> > { new KeyValuePair <string, object>(BaseModuleEntity.FieldDeleted, 0), new KeyValuePair <string, object>(BaseModuleEntity.FieldParentId, parentId) }; result = manager.GetDataTable(parameters, 0, BaseModuleEntity.FieldSortCode); // result.DefaultView.Sort = BaseModuleEntity.FieldSortCode; result.TableName = BaseModuleEntity.CurrentTableName; }); return(result); }
/// <summary> /// 获得用户有访问权限的模块 /// </summary> /// <param name="userInfo">用户</param> /// <param name="userId">用户主键</param> /// <returns>数据表</returns> public DataTable GetModuleDTByUser(BaseUserInfo userInfo, string userId) { // 写入调试信息 #if (DEBUG) int milliStart = BaseBusinessLogic.StartDebug(userInfo, MethodBase.GetCurrentMethod()); #endif // 加强安全验证防止未授权匿名调用 #if (!DEBUG) LogOnService.UserIsLogOn(userInfo); #endif DataTable dataTable = new DataTable(BaseModuleEntity.TableName); using (IDbHelper dbHelper = DbHelperFactory.GetHelper(BaseSystemInfo.UserCenterDbType)) { try { dbHelper.Open(UserCenterDbConnection); string tableName = BaseModuleEntity.TableName; if (!string.IsNullOrEmpty(BaseSystemInfo.SystemCode)) { tableName = BaseSystemInfo.SystemCode + "Module"; } BaseModuleManager moduleManager = new BaseModuleManager(dbHelper, userInfo, tableName); if (userInfo.IsAdministrator) { List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(new KeyValuePair <string, object>(BaseModuleEntity.FieldEnabled, 1)); parameters.Add(new KeyValuePair <string, object>(BaseModuleEntity.FieldDeletionStateCode, 0)); // 有效的,未被删除的显示出来 dataTable = moduleManager.GetDataTable(parameters, BaseModuleEntity.FieldSortCode); } else { dataTable = moduleManager.GetDataTableByUser(userId); } // 若不是员工,有些菜单可以去掉的功能,加在这里 if (string.IsNullOrEmpty(userInfo.StaffId)) { BaseBusinessLogic.Delete(dataTable, BaseModuleEntity.FieldCode, "FrmStaffAddressEdit"); dataTable.AcceptChanges(); } dataTable.TableName = BaseModuleEntity.TableName; BaseLogManager.Instance.Add(dbHelper, userInfo, this.serviceName, AppMessage.PermissionService_GetModuleDTByUser, MethodBase.GetCurrentMethod()); } catch (Exception ex) { BaseExceptionManager.LogException(dbHelper, userInfo, ex); throw ex; } finally { dbHelper.Close(); } } // 写入调试信息 #if (DEBUG) BaseBusinessLogic.EndDebug(MethodBase.GetCurrentMethod(), milliStart); #endif return(dataTable); }