/// <summary> /// 获取公开列表 /// </summary> /// <param name="userInfo">用户</param> /// <returns>数据表</returns> public DataTable GetPublicDT(BaseUserInfo userInfo) { // 写入调试信息 #if (DEBUG) int milliStart = BaseBusinessLogic.StartDebug(userInfo, MethodBase.GetCurrentMethod()); #endif DataTable dataTable = new DataTable(BaseBusinessCardTable.TableName); // 使用工厂模式 传入 数据库类型 IDbHelper dbHelper = null; if (DbHelper.DbType == CurrentDbType.Access) { dbHelper = DbHelperFactory.GetHelper(DbHelper.DbType); } else { dbHelper = DbHelperFactory.GetHelper(); } // 使用工厂模式 传入 数据库类型 try { dbHelper.Open(UserCenterDbConnection); BaseBusinessCardManager businessCardManager = new BaseBusinessCardManager(dbHelper, userInfo); dataTable = businessCardManager.GetDataTable(new KeyValuePair <string, object>(BaseBusinessCardTable.FieldPersonal, 0), BaseBusinessCardTable.FieldSortCode); dataTable.TableName = BaseBusinessCardTable.TableName; /* * // 这里按权限进行过滤字段(表字段权限用例,把没权限的字段都进行排除) * BaseTableColumnsManager tableColumnsManager = new BaseTableColumnsManager(dbHelper, userInfo); * // 这里是当前用户能访问的列名 * string[] columns = tableColumnsManager.GetColumns(userInfo.Id, BaseBusinessCardTable.TableName, "Column.Access"); * // 这是按能访问的列进行过滤的函数 * BaseBusinessLogic.SetColumnsFilter(dataTable, columns); */ // 添加日志 BaseLogManager.Instance.Add(dbHelper, userInfo, 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> /// <returns>数据表</returns> public DataTable GetDataTableByUser(BaseUserInfo userInfo) { // 写入调试信息 #if (DEBUG) int milliStart = BaseBusinessLogic.StartDebug(userInfo, MethodBase.GetCurrentMethod()); #endif DataTable dataTable = new DataTable(BaseBusinessCardTable.TableName); // IDbHelper dbHelper = DbHelperFactory.GetHelper(); // 使用工厂模式 传入 数据库类型 IDbHelper dbHelper = null; if (DbHelper.DbType == CurrentDbType.Access) { dbHelper = DbHelperFactory.GetHelper(DbHelper.DbType); } else { dbHelper = DbHelperFactory.GetHelper(); } try { dbHelper.Open(UserCenterDbConnection); BaseBusinessCardManager businessCardManager = new BaseBusinessCardManager(dbHelper, userInfo); //dataTable = businessCardManager.GetDataTable(BaseBusinessCardTable.FieldCreateUserId, userInfo.Id); dataTable = businessCardManager.GetDataTable(new KeyValuePair <string, object>(BaseBusinessCardTable.FieldPersonal, 1), BaseBusinessCardTable.FieldSortCode); dataTable.TableName = BaseBusinessCardTable.TableName; // 添加日志 BaseLogManager.Instance.Add(dbHelper, userInfo, 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); }