/// <summary> /// 获取参数列表 /// </summary> /// <param name="userInfo">用户</param> /// <param name="categoryId">分类主键</param> /// <param name="parameterId">参数主键</param> /// <returns>数据表</returns> public DataTable GetDataTableByParameter(BaseUserInfo userInfo, string categoryId, string parameterId) { // 写入调试信息 #if (DEBUG) int milliStart = BaseBusinessLogic.StartDebug(userInfo, MethodBase.GetCurrentMethod()); #endif // 加强安全验证防止未授权匿名调用 #if (!DEBUG) LogOnService.UserIsLogOn(userInfo); #endif DataTable dataTable = new DataTable(BaseParameterEntity.TableName); using (IDbHelper dbHelper = DbHelperFactory.GetHelper(BaseSystemInfo.UserCenterDbType)) { try { dbHelper.Open(UserCenterDbConnection); BaseParameterManager parameterManager = new BaseParameterManager(dbHelper, userInfo); dataTable = parameterManager.GetDataTableByParameter(categoryId, parameterId); dataTable.TableName = BaseParameterEntity.TableName; BaseLogManager.Instance.Add(dbHelper, userInfo, AppMessage.ParameterService_GetDataTableByParameter, this.serviceName, 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="categoryCode">分类编号</param> /// <param name="parameterId">参数主键</param> /// <returns>数据表</returns> public DataTable GetDataTableByParameter(BaseUserInfo userInfo, string categoryCode, string parameterId) { var result = new DataTable(BaseParameterEntity.CurrentTableName); var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterReadDb(userInfo, parameter, (dbHelper) => { var manager = new BaseParameterManager(dbHelper, userInfo); result = manager.GetDataTableByParameter(categoryCode, parameterId); result.TableName = BaseParameterEntity.CurrentTableName; // 2015-12-21 吉日嘎拉,这里重新设置mac缓存,删除掉缓存。 if (categoryCode.Equals("MacAddress")) { BaseUserManager.ResetMacAddressByCache(parameterId); } }); return(result); }