public static List<PickupInfo> GetPickupList(int start,int count)
{
string strSQL= "SELECT TOP " + count + " * FROM Pickup WHERE State = '1' AND ID NOT IN(SELECT TOP " + start + " ID FROM Pickup WHERE State = '1' ORDER BY UploadTime DESC) ORDER BY UploadTime DESC";
SqlDataReader PickupDataReader = DAL.SQLHelper.GetReader(strSQL);
List<PickupInfo> PickupList = new List<PickupInfo>();
while (PickupDataReader.Read())
{
PickupInfo info = new PickupInfo();
info.PickupID = PickupDataReader["ID"].ToString();
info.PickupCommendItem = PickupDataReader["CommendItem"].ToString();
info.PickupCommendItemIcon = PickupDataReader["CommendItemIcon"].ToString().Replace(",","");
info.PickupCommendContent = PickupDataReader["CommendContent"].ToString();
info.PickupUploadTime = Convert.ToDateTime(PickupDataReader["UploadTime"].ToString()).ToString("MM/dd/yyyy");
PickupList.Add(info);
}
return PickupList;
}
}