/// <summary> /// 实现日志记录的分页查询 /// </summary> /// <param name="pageSize">每页显示的记录条数</param> /// <param name="currentPage">当前需要显示的页码(第几页)</param> /// <param name="recordCount">记录的总数</param> /// <param name="beginTime">开始时间</param> /// <param name="endTime">结束时间</param> /// <returns>符合条件的记录</returns> public DataTable QueryLog(int pageSize, int currentPage, out int recordCount, string beginTime, string endTime) { SqlParameter[] param = new SqlParameter[] { new SqlParameter("@PageSize", pageSize), new SqlParameter("@CurrentPage", currentPage), new SqlParameter("@BeginTime", Convert.ToDateTime(beginTime)), new SqlParameter("@EndTime", Convert.ToDateTime(endTime)) }; DataSet ds = SQLHelper.GetDataSetByProcedure( "usp_LogDataPager", param); recordCount = Convert.ToInt32(ds.Tables[1].Rows[0][0]); return(ds.Tables[0]); }