/// <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>());
}
/// <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));
}