/// 获得总记录总数
/// </summary>
/// <returns>时间条件范围内记录总数intCount</returns>
protected int CountRecord()
{
int intCount = 0;
SqlConnection SqlCon = new SqlConnection(Common._DBConnStr);
SqlCon.Open ();
//找到条件范围内的记录总数
string strCount = "select count(*) from UnionInfo";
//找到符合条件的第一个记录
//string strNum = "select top 1 Id from UnionInfo";
SqlCommand MyComm = new SqlCommand(strCount,SqlCon);
SqlDataReader dr = MyComm.ExecuteReader();//读取数据流
if(dr.Read())
{
intCount = Int32.Parse(dr[0].ToString());
}
else
{
intCount = 0;
}
dr.Close();
SqlCon.Close();
return intCount;
}
/// <summary>
/// 总分页数
/// </summary>
/// <returns>分页总数</returns>
protected int Page_Count()
{
int pageSum = 0;//分页总数
pageSum = this.CountRecord() / page_count; ///记录总数/分页的页数
if ((this.CountRecord() % page_count) > 0) pageSum++;
return pageSum;
}
/// <summary>
/// 取得SQL语句
/// </summary>
/// <param name="vCmd">返回命令行</param>
/// <returns></returns>
private string GetSQLCommond(string vCommond,string startID,string endID)
{
this.NotShownRecords();//执行未显示的行
vCommond = "SELECT TOP "+page_count+" {0},{1},{2},{3} FROM [UnionInfo]";
上一篇:小偷程序（ASP.NET+c#）
下一篇:Asp.net如何连接SQL Server2000数据库
|
精品推荐