/// <summary>
/// 获取分页数据
/// </summary>
/// <param name="start"></param>
/// <param name="end"></param>
/// <returns></returns>
public List <BookMsg> GetPageList(int start, int end)
{
string sql = "select * from (select row_number() over (order by id)as num,* from BookMsg)as t where t.num<=@end and t.num>=@start";
SqlParameter[] pars =
{
new SqlParameter("@start", start),
new SqlParameter("@end", end),
};
DataTable da = SqlHelp.GetTable(sql, CommandType.Text, pars);
List <BookMsg> list = null;
if (da.Rows.Count > 0)
{
list = new List <BookMsg>();
BookMsg bookMsg = null;
foreach (DataRow row in da.Rows)
{
bookMsg = new BookMsg();
LoadEntity(row, bookMsg);
list.Add(bookMsg);
}
}
return(list);
}
/// <summary>
/// 将每行的数据给model对象
/// </summary>
/// <param name="row"></param>
/// <param name="bookMsg"></param>
private void LoadEntity(DataRow row, BookMsg bookMsg)
{
bookMsg.Id = Convert.ToInt32(row["Id"]);
bookMsg.RoomNum = Convert.ToInt32(row["RoomNum"]);
bookMsg.TableNum = Convert.ToInt32(row["TableNum"]);
bookMsg.UserName = row["UserName"] != DBNull.Value ? row["UserName"].ToString() : string.Empty;
bookMsg.BookTime = Convert.ToDateTime(row["BookTime"]);
bookMsg.StartTime = Convert.ToDateTime(row["StartTime"]);
bookMsg.EndTime = Convert.ToDateTime(row["EndTime"]);
}
