/// <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); }