示例#1
0
 /// <summary>
 /// 分页查询商品数据
 /// </summary>
 /// <param name="pageSize">页大小</param>
 /// <param name="pageindex">页索引</param>
 /// <param name="where">查询条件</param>
 /// <param name="recordCount">返回的总记录数</param>
 /// <returns></returns>
 public static List <ST_Shops> SelectByPagesShops(int pageSize, int pageindex, string where, out int recordCount)
 {
     return(PageHelper.SelectByPage("ST_Shops", "*", "S_Name", true, pageSize, pageindex, where, "", "", out recordCount).ToList <ST_Shops>());
 }
示例#2
0
 /// <summary>
 /// 分页查询
 /// </summary>
 /// <param name="tableName">查询的表,多标用,隔开</param>
 /// <param name="field">查询的字段</param>
 /// <param name="orderfield">排序字段</param>
 /// <param name="orderType">排序类型,非 0 值则降序</param>
 /// <param name="pageSize">页大小</param>
 /// <param name="pageindex">页索引</param>
 /// <param name="where">查询条件</param>
 /// <param name="innerFields">关联字段</param>
 /// <param name="recordCount">返回的总记录数</param>
 /// <param name="innwhere">关联附加条件</param>
 /// <returns></returns>
 public static DataTable SelectByPages(string tableName, string field, string orderfield, bool orderType, int pageSize, int pageindex, string where, string innerFields, string innwhere, out int recordCount)
 {
     return(PageHelper.SelectByPage(tableName, field, orderfield, orderType, pageSize, pageindex, where, innerFields, innwhere, out recordCount));
 }