How to use:
Pagerquery query = new Pagerquery ();
Query.pageindex = 1;
Query.pagesize = 20;
QUERY.PK = "id";
Query.selectclause = "*";
Query.fromclause = "TestTable";
Query.sortclause = "id desc";
if (!string.isnullorempty (code))
{
Query.whereclause.append ("and id= @id");
}
A the statement generated by the Generatecountsql () method is:
Select COUNT (0) from TestTable where 1=1 and id= @id
b) The statement generated by the GenerateSQL () method is:
With T as (select Row_number ()-ecid desc) as Row_number, * from TestTable where 1=1 and id= @id) SELECT * FR Om t where row_number between 1 and 20
c) The statement generated by the Generatesqlincludettotalrecords () method is:
With T as (select Row_number ()-e.ecid desc) as row_number,* from TestTable where 1=1 and id= @id) SELECT * F Rom t where row_number between 1 and 20;select count (0) from Ecbasicinfo where 1=1 and id= @id;