/// <summary>
/// 获得团购数据列表
/// </summary>
/// <param name="currentPage">当前的页数</param>
/// <param name="pageSize">每页记录数</param>
/// <param name="count">总数量</param>
/// <returns>团购数据列表</returns>
public static List <GroupBuyInfo> ReadGroupBuyList(int currentPage, int pageSize, ref int count)
{
List <GroupBuyInfo> groupBuyList = new List <GroupBuyInfo>();
GroupBuyAccessPagerClass pc = new GroupBuyAccessPagerClass();
pc.TableName = GroupBuyAccessHelper.TablePrefix + "GroupBuy";
pc.Fields = "[ID],[Name],[Photo],[Description],[ProductID],[StartDate],[EndDate],[Price],[MinCount],[MaxCount],[EachNumber]";
pc.CurrentPage = currentPage;
pc.PageSize = pageSize;
pc.OrderField = "[ID]";
pc.OrderType = OrderType.Desc;
pc.Count = count;
count = pc.Count;
using (OleDbDataReader dr = pc.ExecuteReader())
{
PrepareGroupBuyModel(dr, groupBuyList);
}
return(groupBuyList);
}
/// <summary>
/// 获得用户团购数据列表
/// </summary>
/// <param name="groupBuyID">分类ID</param>
/// <param name="currentPage">当前的页数</param>
/// <param name="pageSize">每页记录数</param>
/// <param name="count">总数量</param>
/// <returns>用户团购数据列表</returns>
public static List <UserGroupBuyInfo> ReadUserGroupBuyList(int groupBuyID, int currentPage, int pageSize, ref int count)
{
List <UserGroupBuyInfo> userGroupBuyList = new List <UserGroupBuyInfo>();
GroupBuyAccessPagerClass pc = new GroupBuyAccessPagerClass();
pc.TableName = GroupBuyAccessHelper.TablePrefix + "UserGroupBuy";
pc.Fields = "[ID],[GroupBuyID],[Date],[IP],[BuyCount],[OrderID],[UserID],[UserName],[Consignee],[RegionID],[Address],[ZipCode],[Tel],[Email],[Mobile]";
pc.CurrentPage = currentPage;
pc.PageSize = pageSize;
pc.OrderField = "[ID]";
pc.OrderType = OrderType.Desc;
pc.AccessCondition.Add("[GroupBuyID]", groupBuyID, ConditionType.Equal);
pc.Count = count;
count = pc.Count;
using (OleDbDataReader dr = pc.ExecuteReader())
{
PrepareUserGroupBuyModel(dr, userGroupBuyList);
}
return(userGroupBuyList);
}