/// <summary>
/// 获取分页信息
/// </summary>
/// <param name="PageSize"></param>
/// <param name="PageIndex"></param>
/// <param name="TableName"></param>
/// <param name="columns"></param>
/// <param name="fyColumn"></param>
/// <param name="strWhere"></param>
/// <param name="strGroupBy"></param>
/// <param name="strHaving"></param>
/// <param name="strOrder"></param>
/// <returns></returns>
public DataTable GetDatePaging(int PageSize, int PageIndex, string TableName, string columns, string fyColumn, string strWhere, string strGroupBy, string strHaving, string strOrder)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT TOP " + PageSize + " " + columns + " FROM " + TableName + " as temp_tab ");
strSql.Append(" WHERE " + fyColumn + " NOT IN( ");
strSql.Append(" SELECT TOP " + (PageIndex - 1) * PageSize + " " + fyColumn + " ");
strSql.Append(" FROM " + TableName + " as temp_tab ");
if (!string.IsNullOrEmpty(strWhere))
{
strSql.Append(" WHERE " + strWhere);
}
if (!string.IsNullOrEmpty(strGroupBy))
{
strSql.Append(" GROUP BY " + strGroupBy);
}
if (!string.IsNullOrEmpty(strHaving))
{
strSql.Append(" HAVING " + strHaving);
}
if (!string.IsNullOrEmpty(strOrder))
{
strSql.Append(" ORDER BY temp_tab." + strOrder + " ");
}
strSql.Append(" )");
if (!string.IsNullOrEmpty(strWhere))
{
strSql.Append(" AND " + strWhere);
}
if (!string.IsNullOrEmpty(strGroupBy))
{
strSql.Append(" GROUP BY " + strGroupBy);
}
if (!string.IsNullOrEmpty(strHaving))
{
strSql.Append(" HAVING " + strHaving);
}
if (!string.IsNullOrEmpty(strOrder))
{
strSql.Append(" ORDER BY temp_tab." + strOrder + " ");
}
DataTable dt = new DataTable();
dt = new pageControl().doSql(strSql.ToString()).Tables[0];
return(dt);
}
