欧美国产另类久热|951超碰伊人久久|伊人影视久久久久|色婷婷亚洲小电影|色东京热69XX|婷婷玖玖深爱网|加勒比东京热网站|无码A级毛片在线观看|一级a毛一级a看|中文字幕人妻欧美

具體代碼如下：

string sql = select count(id) as rcount from tbproduct where classid in( + ids + ) and productname like;

oledbparameter[] sps = new oledbparameter[1];

sps[0] = accessdb.createparameter(@productname, oledbtype.varchar, productname, 50, parameterdirection.input);

int resultcount = (int)accessdb.executescalar(sql, sps);

recordcount = resultcount;

if (resultcount >= 0)

{

if ((resultcount % pagesize) == 0)

{

pagecount = resultcount / pagesize;

}

else

{

pagecount = (resultcount / pagesize) + 1;

}

if (pageindex == 1)

{

sql = select top + pagesize.tostring() + * from tbproduct where classid in( + ids + ) and productname like order by id desc;

}

else

{

int minrecord = (pageindex - 1) * pagesize;

sql = select top + pagesize.tostring() + * from tbproduct where id not in(select id from (select top + minrecord.tostring() + id from tbproduct where classid in( + ids + ) and productname like order by id desc )tema) and classid in( + ids + ) and productname like order by id desc;

}

}

else

{

pagecount = 0;

}

return accessdb.executedataset(sql, sps).tables[0];

更多信息請(qǐng)查看IT技術(shù)專(zhuān)欄