public DataSet GetListByPage(string strWhere, string orderby, int startIndex, int endIndex)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("SELECT * FROM ( ");
strSql.Append(" SELECT ROW_NUMBER() OVER (");
if (!string.IsNullOrEmpty(orderby.Trim()))
{
strSql.Append("order by T." + orderby );
}
else
{
strSql.Append("order by T.tmId desc");
}
strSql.Append(")AS Row, T.* from sjtm T ");
if (!string.IsNullOrEmpty(strWhere.Trim()))
{
strSql.Append(" WHERE " + strWhere);
}
strSql.Append(" ) TT");
strSql.AppendFormat(" WHERE TT.Row between {0} and {1}", startIndex, endIndex);
return DbHelperMySQL.Query(strSql.ToString());
}
你好,
你这个代码是创一个sql 语句,根据 orderby或tmId, 以及strWhere 的排列顺序,给他们一个序列号,从1 开始. 这个方法返回的类型是DataSet类型. 所以你在调用的时候也应该是DataSet 类型.就像这样:
DataSet dt = GetListByPage("A","B",1,3);