?? orderdal.cs
字號:
using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections.Generic;
/// <summary>
/// Data access layer
/// Webdiyer(www.webdiyer.com) 2006-11-27
/// </summary>
public sealed class OrderData
{
private OrderData(){}
/// <summary>
/// 獲取要分頁的記錄總數(shù)
/// </summary>
/// <returns></returns>
public static int GetOrderCount()
{
return (int)SqlHelper.ExecuteScalar(CommandType.StoredProcedure, "P_GetOrderNumber");
}
/// <summary>
/// 獲取要分頁的當前頁的記錄
/// </summary>
/// <param name="startIndex">當前頁要顯示的記錄的起始索引</param>
/// <param name="endIndex">當前頁要顯示的記錄的結束索引</param>
/// <returns>當前頁要顯示的記錄集合</returns>
public static List<Order> GetPagedOrders(int startIndex, int endIndex)
{
SqlDataReader reader = SqlHelper.ExecuteReader(CommandType.StoredProcedure, System.Configuration.ConfigurationManager.AppSettings["pagedSPName"],
new SqlParameter("@startIndex", startIndex),
new SqlParameter("@endIndex", endIndex));
List<Order> orders = new List<Order>();
while (reader.Read())
{
orders.Add(new Order(reader.GetInt32(0),reader.GetDateTime(1),reader.GetString(2),reader.GetString(3),reader.GetString(4)));
}
reader.Close();
return orders;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -