/// <summary> /// 应用于单表 /// </summary> /// <typeparam name="dynamic"></typeparam> /// <param name="gridpage"></param> /// <param name="sql"></param> /// <returns></returns> public List <dynamic> PageingGrid <dynamic>(GridPage gridpage, string sql) { string sql1 = ""; if (gridpage.ispaging) { sql1 = @"select * from (select temp.*,rownum rowindex from ( " + sql + " ) temp )" + " where rowindex>" + gridpage.BeginIndex + " and rowindex<" + gridpage.EndIndex; } else { sql1 = sql; } return(Database.SqlQuery <dynamic>(sql1).ToList()); }
public List <dynamic> PageingGrid <dynamic>(GridPage gridpage, string tablename, string whereStr) { string sql1 = ""; if (gridpage.ispaging) { sql1 = string.Format(@"SELECT * FROM (SELECT T.*, ROWNUM AS rno FROM {0} T WHERE ROWNUM<{1} {3} ) WHERE rno>{2}", tablename, gridpage.EndIndex, gridpage.BeginIndex, whereStr); } else { sql1 = string.Format("SELECT * FROM {0} T WHERE 1=1 {1}", tablename, whereStr); } return(Database.SqlQuery <dynamic>(sql1).ToList()); }