/// <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));
 }
Example #2
0
 /// <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));
 }