存储过程.doc

文档介绍：存储过程setANSI_NULLSONsetQUOTED_IDENTIFIERONgoALTERPROCEDURE[dbo].[Change_Page]***@iPageSizeint--每页数,***@iIndexPageint--第几页,***@iRowCountintoutput--总记录数******@iRowCount=0;SETNOCOUNTON;******@iRowCount=count(*)fromMessage_Lt;withPageTableas(SELECT*,ROW_NUMBER()OVER(ORDERBYLtIDDESC)ASnumFROMMessage_Lt)SELECT*FROMPageTableWHEREnumBETWEEN((***@iIndexPage-1)****@iPageSize+1)******@iPageSize****@iIndexPageSETNOCOUNTOFF;esspublicDataTableGetTable1(stringstrSql,Hashtableht){using(dadPartyMis=newSqlDataAdapter()){cmdPartyMis=mand(n);GetParams(cmdPartyMis,ht);["***@iRowCount"].Direction=;DataTabledt=newDataTable();=cmdPartyMis;(dt);stringv=["***@iRowCount"].();ht["***@iRowCount"]=v;=v;returndt;}}Dal层publicDa