/// <summary> /// 获取内部通讯录 /// </summary> /// <param name="userInfo">用户</param> /// <param name="organizeId">组织机构主键</param> /// <param name="search">查询内容</param> /// <param name="pageSize">分页的条数</param> /// <param name="pageIndex">当前页数</param> /// <returns>数据表</returns> public DataTable GetAddressDataTableByPage(BaseUserInfo userInfo, string organizeId, string searchValue, out int recordCount, int pageIndex = 0, int pageSize = 100, string sort = null) { var dt = new DataTable(BaseStaffEntity.TableName); int myrecordCount = 0; var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterReadDb(userInfo, parameter, (dbHelper) => { // 这里是不获取所有的列,只获取自己需要的列的标准方法 var manager = new BaseStaffManager(dbHelper, userInfo); manager.SelectFields = "Id, Code, RealName, DepartmentName, DutyName, OfficePhone, Extension, Mobile, ShortNumber, Email, QQ, Description"; dt = manager.GetAddressDataTableByPage(organizeId, searchValue, out myrecordCount, pageSize, pageIndex, sort); dt.TableName = BaseStaffEntity.TableName; }); recordCount = myrecordCount; return(dt); }
/// <summary> /// 获取内部通讯录 /// </summary> /// <param name="userInfo">用户</param> /// <param name="organizeId">组织机构主键</param> /// <param name="search">查询内容</param> /// <param name="pageSize">分页的条数</param> /// <param name="pageIndex">当前页数</param> /// <returns>数据表</returns> public DataTable GetAddressDataTableByPage(BaseUserInfo userInfo, string organizeId, string searchValue, int pageSize, int pageIndex, out int recordCount) { // 写入调试信息 #if (DEBUG) int milliStart = BaseBusinessLogic.StartDebug(userInfo, MethodBase.GetCurrentMethod()); #endif // 加强安全验证防止未授权匿名调用 #if (!DEBUG) LogOnService.UserIsLogOn(userInfo); #endif DataTable dataTable = new DataTable(BaseStaffEntity.TableName); using (IDbHelper dbHelper = DbHelperFactory.GetHelper(BaseSystemInfo.UserCenterDbType)) { try { dbHelper.Open(UserCenterDbConnection); BaseStaffManager staffManager = new BaseStaffManager(dbHelper, userInfo); dataTable = staffManager.GetAddressDataTableByPage(out recordCount, pageSize, pageIndex, organizeId, searchValue); dataTable.TableName = BaseStaffEntity.TableName; BaseLogManager.Instance.Add(dbHelper, userInfo, this.serviceName, AppMessage.StaffService_GetAddressPageDT, 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); }