public List <Book.Model.T_Stock_Report> GetList(int CurrentPage, int PageSize)
{
SqlConnection co = new SqlConnection();
co.ConnectionString = connstring;
co.Open();
SqlCommand cm = new SqlCommand();
cm.Connection = co;
//cm.CommandText = "select * from t_base_book";
cm.CommandText = "select top " + PageSize + " * from [V_Stock_BookItem] where id not in (select top " + PageSize * (CurrentPage - 1) + " id from [V_Stock_BookItem] )";
SqlDataReader dr = cm.ExecuteReader();
List <Book.Model.T_Stock_Report> lst = new List <Model.T_Stock_Report>();
while (dr.Read())
{
Book.Model.T_Stock_Report item = new Model.T_Stock_Report();
item.BookName = Convert.ToString(dr["BookName"]);
item.Count = Convert.ToInt32(dr["Count"]);
lst.Add(item);
}
dr.Close();
co.Close();
return(lst);
}
///分页实现过程
public List <Book.Model.T_Stock_Report> GetList(int pageNumber, int pageSize)
{
List <Book.Model.T_Stock_Report> list = new List <Model.T_Stock_Report>();
SqlConnection co = SQLServerOpen();
SqlCommand cmd = new SqlCommand();
cmd.Connection = co;
cmd.CommandText = "select top " + pageSize + " * from v_report_book where BookId not in(select top " + (pageNumber - 1) * pageSize + " BookId from v_report_book)";
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Book.Model.T_Stock_Report item = new Model.T_Stock_Report();
item.BookId = Convert.ToInt32(reader["BookId"]);
item.BookName = Convert.ToString(reader["BookName"]);
item.Amount = Convert.ToInt32(reader["Amount"]);
item.Img = Convert.ToString(reader["Img"]);
list.Add(item);
}
reader.Close();
co.Close();
int result = GetCount();
return(list);
}
