/// <summary> /// 分页获取集合 /// </summary> /// <param name="textWhere">string 条件语句,无须where</param> /// <param name="textOrder">string 排序语句,无须order by</param> /// <param name="pageIndex">int 页码,从1开始</param> /// <param name="pageRow">int 每页行数</param> /// <param name="dataCount">out int 数据行数</param> /// <returns>List<InventoryOrderPartInfo></returns> public List <InventoryOrderPartInfo> GetListByPage(string textWhere, string textOrder, int pageIndex, int pageRow, out int dataCount) { dataCount = dal.GetCounts(textWhere); return(dal.GetListByPage(textWhere, textOrder, pageIndex, pageRow)); }
/// <summary> /// 分页获取集合 /// </summary> /// <param name="textWhere">string 条件语句,无须where</param> /// <param name="textOrder">string 排序语句,无须order by</param> /// <param name="pageIndex">int 页码,从1开始</param> /// <param name="pageRow">int 每页行数</param> /// <param name="dataCount">out int 数据行数</param> /// <returns>List<InventoryOrderPartInfo></returns> public List <InventoryOrderPartInfo> GetListByPage(string textWhere, string textOrder, int pageIndex, int pageRow, out int dataCount) { textWhere += "and [ORDER_FID] in (select [FID] from [LES].[TT_WMM_INVENTORY_NOTICE_ORDER] where STATUS = " + (int)InventoryOrderStatusConstants.COMPLETED + ")"; dataCount = dal.GetCounts(textWhere); return(dal.GetListByPage(textWhere, textOrder, pageIndex, pageRow)); }