/*
* /// <summary>
* /// 分页获取数据列表
* /// </summary>
* public DataSet GetList(int PageSize,int PageIndex,string strWhere)
* {
* SqlParameter[] parameters = {
* new SqlParameter("@tblName", SqlDbType.VarChar, 255),
* new SqlParameter("@fldName", SqlDbType.VarChar, 255),
* new SqlParameter("@PageSize", SqlDbType.Int),
* new SqlParameter("@PageIndex", SqlDbType.Int),
* new SqlParameter("@IsReCount", SqlDbType.Bit),
* new SqlParameter("@OrderType", SqlDbType.Bit),
* new SqlParameter("@strWhere", SqlDbType.VarChar,1000),
* };
* parameters[0].Value = "KeyWords";
* parameters[1].Value = "KID";
* parameters[2].Value = PageSize;
* parameters[3].Value = PageIndex;
* parameters[4].Value = 0;
* parameters[5].Value = 0;
* parameters[6].Value = strWhere;
* return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds");
* }*/
#endregion BasicMethod
#region ExtensionMethod
/// <summary>
/// 获得分页的数据
/// </summary>
/// <param name="pageSize">每页的条数</param>
/// <param name="pageIndex">显示的第几页</param>
/// <param name="strWhere">where条件</param>
/// <param name="fieldOrder">排序字段【不可为空】</param>
/// <param name="recordCount">返回记录的总条数</param>
/// <returns></returns>
public DataTable GetListByPage(int pageSize, int pageIndex, string strWhere, string fieldOrder, out int recordCount)
{
StringBuilder sbr = new StringBuilder();
sbr.Append("select KID as 关键字ID,KeyWordsName 关键字 ,KeyWordsStatus 状态 FROM KeyWords");
if (strWhere.Trim() != "")
{
sbr.Append(" where " + strWhere);
}
//统计记录的SQL语句
string strCountSQL = PagingHelper.CreateCountingSQL(sbr.ToString());
//统计的记录数
recordCount = Convert.ToInt32(DbHelperSQL.GetSingle(strCountSQL));
//分页的SQL语句
string strPageSQL = PagingHelper.CreatePagingSql(recordCount, pageSize, pageIndex, sbr.ToString(), fieldOrder);
return(DbHelperSQL.Query(strPageSQL).Tables[0]);
}
