| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034 |
- <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
- <!-- saved from url=(0053)http://blog.csdn.net/zdw_wym/article/details/30974033 -->
- <html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
- <script type="text/javascript" async="" src="./asp.net SQL Server 存储过程分页及代码调用 _files/ga.js"></script><script id="allmobilize" charset="utf-8" src="./asp.net SQL Server 存储过程分页及代码调用 _files/allmobilize.min.js"></script><style type="text/css"></style>
- <meta http-equiv="Cache-Control" content="no-siteapp"><link rel="alternate" media="handheld" href="http://blog.csdn.net/zdw_wym/article/details/30974033#">
- <title>asp.net SQL Server 存储过程分页及代码调用 - 少壮不努力，老大做IT
- - 博客频道 - CSDN.NET</title>
-
- <meta name="description" content="1、创建存储过程，如CREATE PROC P_viewPage @TableName VARCHAR(200), --表名 @FieldList VARCHAR(2000), --显示列名，如果是全部字段则为* @PrimaryKey VARCHAR(100), --单一主键或唯一值键 @Where VARCHAR(2000), --查询">
- <script src="./asp.net SQL Server 存储过程分页及代码调用 _files/jquery.js" type="text/javascript"></script>
- <script type="text/javascript" src="./asp.net SQL Server 存储过程分页及代码调用 _files/ad.js"></script>
- <!--new top-->
-
- <link rel="stylesheet" href="http://static.csdn.net/public/common/toolbar/css/index.css">
- <!--new top-->
- <link rel="Stylesheet" type="text/css" href="./asp.net SQL Server 存储过程分页及代码调用 _files/style.css">
- <link id="RSSLink" title="RSS" type="application/rss+xml" rel="alternate" href="http://blog.csdn.net/taomanman/rss/list">
- <link rel="shortcut icon" href="http://csdnimg.cn/public/favicon.ico">
- <link type="text/css" rel="stylesheet" href="./asp.net SQL Server 存储过程分页及代码调用 _files/default.css">
-
- <script src="./asp.net SQL Server 存储过程分页及代码调用 _files/share.js"></script><script type="text/javascript" charset="utf-8" src="./asp.net SQL Server 存储过程分页及代码调用 _files/tracking.js"></script><script type="text/javascript" charset="utf-8" src="./asp.net SQL Server 存储过程分页及代码调用 _files/main.js"></script><link rel="stylesheet" type="text/css" href="./asp.net SQL Server 存储过程分页及代码调用 _files/style(1).css"><link type="text/css" rel="stylesheet" href="./asp.net SQL Server 存储过程分页及代码调用 _files/style(2).css"><script src="./asp.net SQL Server 存储过程分页及代码调用 _files/logger.js"></script><link href="./asp.net SQL Server 存储过程分页及代码调用 _files/bdsstyle.css" rel="stylesheet" type="text/css"><link rel="stylesheet" href="http://bdimg.share.baidu.com/static/api/css/share_style0_16.css?v=89a7173d.css"></head>
- <body><iframe frameborder="0" style="display: none;"></iframe>
-
-
- <!--new top-->
- <script id="toolbar-tpl-scriptId" fixed="true" prod="blog" skin="black" src="./asp.net SQL Server 存储过程分页及代码调用 _files/html.js" type="text/javascript"></script><div class="csdn-toolbar csdn-toolbar-skin-black "> <div class="container row center-block "> <div class="col-md-3 pull-left logo clearfix"><a href="http://www.csdn.net/?ref=toolbar" title="CSDN首页" target="_blank" class="icon"></a><a title="频道首页" href="http://blog.csdn.net/?ref=toolbar_logo" target="_blank" class="img blog-icon"></a></div> <div class="pull-right login-wrap unlogin"> <ul class="btns"> <li class="loginlink"><a href="https://passport.csdn.net/account/login?ref=toolbar" target="_top">登录 </a>|<a target="_top" href="https://passport.csdn.net/account/register?ref=toolbar"> 注册</a></li> <li class="search"> <div class="icon on-search-icon"> <div class="wrap"> <div class="curr-icon-wrap"> <div class="curr-icon"></div> </div> <form action="http://so.csdn.net/search" method="get" target="_blank"> <input type="hidden" value="toolbar" name="ref" accesskey="2"> <div class="border"> <input placeholder="搜索" type="text" value="" name="q" accesskey="2"><span class="icon-enter-sm"></span> </div> </form> </div> </div> </li> <li class="favor"> <div class="icon on-favor-icon"> <div class="wrap"> <div class="curr-icon-wrap"> <div class="curr-icon"></div> </div> <div style="display:none;" class="favor-success"><span class="msg">收藏成功</span> <div class="btns"><span class="btn btn-primary ok">确定</span></div> </div> <div style="display:none;" class="favor-failed"><span class="icon-danger-lg"></span><span class="msg">收藏失败，请重新收藏</span> <div class="btns"><span class="btn btn-primary ok">确定</span></div> </div> <form role="form" class="form-horizontal favor-form"> <div class="form-group"> <div class="clearfix"> <label for="input-title" class="col-sm-2 control-label">标题</label> <div class="col-sm-10"> <input id="inputTitle" type="text" placeholder="" class="title form-control"> </div> </div> <div class="alert alert-danger"><strong></strong>标题不能为空</div> </div> <div class="form-group"> <label for="input-url" class="col-sm-2 control-label">网址</label> <div class="col-sm-10"> <input id="input-url" type="text" placeholder="" class="url form-control"> </div> </div> <div class="form-group"> <label for="input-tag" class="col-sm-2 tag control-label">标签</label> <div class="col-sm-10"> <input id="input-tag" type="text" class="form-control tag"> </div> </div> <div class="form-group"> <label for="input-description" class="description col-sm-2 control-label">摘要</label> <div class="col-sm-10"> <textarea id="input-description" class="form-control description"></textarea> </div> </div> <div class="form-group"> <div class="col-sm-offset-2 col-sm-10 ft"> <div class="col-sm-4 pull-left"> <div class="checkbox"> <label> <input type="checkbox" name="share" checked="checked" class="share">公开 </label> </div> </div> <div class="col-sm-8 pull-right favor-btns"> <button type="button" class="cancel btn btn-default">取消</button> <button type="submit" class="submit btn btn-primary">收藏</button> </div> </div> </div> </form> </div> </div> </li> <li class="notify"> <div style="display:none" class="number"></div> <div style="display:none" class="icon-hasnotes-sm"></div> <div id="header_notice_num"></div> <div class="icon on-notify-icon"> <div class="wrap"> <div class="curr-icon-wrap"> <div class="curr-icon"></div> </div> <div id="note1" class="csdn_note"> <div class="box"></div> <iframe src="about:block" frameborder="0" allowtransparency="true" style="z-index:-1;position:absolute;top:0;left:0;width:100%;height:100%;background:transparent"></iframe></div> </div> </div> </li> <li class="ugc"> <div class="icon on-ugc-icon"> <div class="wrap clearfix"> <div class="curr-icon-wrap"> <div class="curr-icon"></div> </div> <dl> <dt><a href="http://geek.csdn.net/news/expert?ref=toolbar" target="_blank" class="p-news clearfix"><em class="icon"></em><span>分享资讯</span></a></dt> <dt><a href="http://share.csdn.net/slides/new?ref=toolbar" target="_blank" class="p-doc clearfix"><em class="icon"></em><span>传PPT/文档</span></a></dt> <dt><a href="http://bbs.csdn.net/topics/new?ref=toolbar" target="_blank" class="p-ask clearfix"><em class="icon"></em><span>提问题</span></a></dt> <dt><a href="http://write.blog.csdn.net/postedit?ref=toolbar" target="_blank" class="p-blog clearfix"><em class="icon"></em><span>写博客</span></a></dt> <dt><a href="http://u.download.csdn.net/upload?ref=toolbar" target="_blank" class="p-src clearfix"><em class="icon"></em><span>传资源</span></a></dt> <dt><a href="https://code.csdn.net/projects/new?ref=toolbar" target="_blank" class="c-obj clearfix"><em class="icon"></em><span>创建项目</span></a></dt> <dt><a href="https://code.csdn.net/snippets/new?ref=toolbar" target="_blank" class="c-code clearfix"><em class="icon"></em><span>创建代码片</span></a></dt> </dl> </div> </div> </li> <li class="profile"> <div class="icon on-profile-icon"><img src="./asp.net SQL Server 存储过程分页及代码调用 _files/100x100.jpg" class="curr-icon-img"> <div class="wrap clearfix"> <div class="curr-icon-wrap"> <div class="curr-icon"></div> </div> <div class="bd"> <dl class="clearfix"> <dt class="pull-left img"><a target="_blank" href="http://my.csdn.net/?ref=toolbar" class="avatar"><img src="./asp.net SQL Server 存储过程分页及代码调用 _files/100x100.jpg"></a></dt> <dd class="info"><a target="_blank" href="http://my.csdn.net/?ref=toolbar" class="nickname"></a><a class="set-nick" href="https://passport.csdn.net/account/profile">设置昵称<span class="write-icon"></span></a><span class="dec"><a class="fill-dec" href="http://my.csdn.net/" target="_blank">编辑自我介绍，让更多人了解你<span class="write-icon"></span></a></span></dd> </dl> </div> <div class="ft clearfix"><a target="_blank" href="http://my.csdn.net/my/account/changepwd?ref=toolbar" class="pull-left"><span class="icon-cog"></span>帐号设置</a><a href="https://passport.csdn.net/account/logout?ref=toolbar" target="_top" class="pull-right "><span class="icon-signout"></span><span class="out">退出</span></a></div> </div> </div> </li> <li class="apps"> <div class="icon on-apps-icon"> <div class="wrap clearfix"> <div class="curr-icon-wrap"> <div class="curr-icon"></div> </div> <div class="detail"> <dl> <dt> <h5>社区</h5> </dt> <dd> <a href="http://blog.csdn.net/?ref=toolbar" target="_blank">博客</a></dd> <dd> <a href="http://bbs.csdn.net/?ref=toolbar" target="_blank">论坛</a></dd> <dd> <a href="http://download.csdn.net/?ref=toolbar" target="_blank">下载</a></dd> <dd><a href="http://share.csdn.net/?ref=toolbar" target="_blank">Share</a></dd> <dd><a href="http://geek.csdn.net/?ref=toolbar" target="_blank">极客头条</a></dd> </dl> </div> <div class="detail"> <dl> <dt> <h5>服务</h5> </dt> <dd> <a href="https://code.csdn.net/?ref=toolbar" target="_blank">CODE</a></dd> <dd> <a href="http://hero.csdn.net/?ref=toolbar" target="_blank">英雄会</a></dd> <dd> <a href="http://huiyi.csdn.net/?ref=toolbar" target="_blank">活动</a></dd> <dd> <a href="http://www.csto.com/?ref=toolbar" target="_blank">CSTO</a></dd> </dl> </div> <div class="detail last"> <dl> <dt> <h5>俱乐部</h5> </dt> <dd> <a href="http://cto.csdn.net/?ref=toolbar" target="_blank">CTO俱乐部</a></dd> <dd> <a href="http://student.csdn.net/?ref=toolbar" target="_blank">高校俱乐部</a></dd> </dl> </div> </div> </div> </li> </ul> </div> </div> </div>
- <!--new top-->
- <div id="container">
- <div id="header">
- <div class="header">
- <div id="blog_title">
- <h2>
- <a href="http://blog.csdn.net/zdw_wym">少壮不努力，老大做IT</a></h2>
- <h3>专注.NET开发，涉及Silverlight、WPF、ArcGIS、Android、Windows Phone等技术开发！</h3>
- <div class="clear">
- </div>
- </div>
- <div class="clear">
- </div>
- </div>
- </div>
- <div id="navigator">
- <div class="navigator_bg">
- </div>
- <div class="navigator">
- <ul>
- <li id="btnContents"><a href="http://blog.csdn.net/zdw_wym?viewmode=contents"><span onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_mulu'])">
- <img src="./asp.net SQL Server 存储过程分页及代码调用 _files/ico_list.gif">目录视图</span></a></li>
- <li id="btnView"><a href="http://blog.csdn.net/zdw_wym?viewmode=list"><span onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_zhaiyao'])">
- <img src="./asp.net SQL Server 存储过程分页及代码调用 _files/ico_summary.gif">摘要视图</span></a></li>
- <li id="btnRss"><a href="http://blog.csdn.net/zdw_wym/rss/list"><span onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_RSS'])">
- <img src="./asp.net SQL Server 存储过程分页及代码调用 _files/ico_rss.gif">订阅</span></a></li>
- </ul>
- </div>
- </div>
- <script type="text/javascript">
- var username = "taomanman";
- var _blogger = username;
- var blog_address = "http://blog.csdn.net/zdw_wym";
- var static_host = "http://static.blog.csdn.net";
- var currentUserName = "";
- </script>
- <div id="body">
- <div id="main">
- <div class="main">
- <div class="ad_class">
- <div class="notice tracking-ad" data-mod="popu_3">
- <a href="http://bbs.csdn.net/topics/390812950?page=2#post-398116601" target="_blank">
- <font color="blue">博客专家福利
- </font></a>
-
- <a href="http://bbs.csdn.net/topics/390863850" target="_blank">
- <font color="red">【限时活动】建专辑得大奖</font></a>
-
- <a href="http://www.csdn.net/article/2014-09-10/2821606" target="_blank">
- <font color="blue">专访荣浩：流程的永恒之道
- </font></a>
-
- <a href="http://blog.csdn.net/blogdevteam/article/details/38657235" target="_blank"><font color="red">当青春遇上互联网，能否点燃你的创业梦
- </font></a>
-
- <a href="http://blog.csdn.net/blogdevteam/article/details/38418263" target="_blank">
- <font color="blue">推荐有礼--找出您心中的技术大牛
- </font></a>
- </div> </div>
-
-
- <link href="./asp.net SQL Server 存储过程分页及代码调用 _files/comment1.css" type="text/css" rel="stylesheet">
- <link href="./asp.net SQL Server 存储过程分页及代码调用 _files/style1.css" type="text/css" rel="stylesheet">
- <script language="JavaScript" type="text/javascript" src="./asp.net SQL Server 存储过程分页及代码调用 _files/jquery.cookie.js"></script>
- <script type="text/javascript" src="./asp.net SQL Server 存储过程分页及代码调用 _files/main(1).js"></script>
- <div id="article_details" class="details">
- <div class="article_title">
- <span class="ico ico_type_Original"></span>
- <h1>
- <span class="link_title"><a href="./asp.net SQL Server 存储过程分页及代码调用 _files/asp.net SQL Server 存储过程分页及代码调用 .htm">
- asp.net SQL Server 存储过程分页及代码调用
- </a></span>
- </h1>
- </div>
- <div class="article_manage">
- <span class="link_categories">
- 分类：
- <a href="http://blog.csdn.net/taomanman/article/category/571993" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_fenlei']);">C#.NET编程</a>
- </span>
- <span class="link_postdate">2014-06-15 10:53</span>
- <span class="link_view" title="阅读次数">103人阅读</span>
- <span class="link_comments" title="评论次数"><a href="http://blog.csdn.net/zdw_wym/article/details/30974033#comments" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_pinglun'])">评论</a>(0)</span>
- <span class="link_collect"><a href="javascript:void(0);" onclick="javascript:_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_shoucang']);collectArticle('asp.net SQL Server 存储过程分页及代码调用','30974033');return false;" title="收藏">收藏</a></span>
- <span class="link_report"><a href="http://blog.csdn.net/zdw_wym/article/details/30974033#report" onclick="javascript:_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_jubao']);report(30974033,2);return false;" title="举报">举报</a></span>
-
- </div>
-
-
- <div id="article_content" class="article_content">
- <span style="font-size:14px;">1、创建存储过程，语句如下：<br><br></span><div class="dp-highlighter bg_sql"><div class="bar"><div class="tools"><b>[sql]</b> <a href="http://blog.csdn.net/zdw_wym/article/details/30974033#" class="ViewSource" title="view plain" onclick="dp.sh.Toolbar.Command('ViewSource',this);return false;">view plain</a><a href="http://blog.csdn.net/zdw_wym/article/details/30974033#" class="CopyToClipboard" title="copy" onclick="dp.sh.Toolbar.Command('CopyToClipboard',this);return false;">copy</a><a href="http://blog.csdn.net/zdw_wym/article/details/30974033#" class="PrintSource" title="print" onclick="dp.sh.Toolbar.Command('PrintSource',this);return false;">print</a><a href="http://blog.csdn.net/zdw_wym/article/details/30974033#" class="About" title="?" onclick="dp.sh.Toolbar.Command('About',this);return false;">?</a><a href="https://code.csdn.net/snippets/393176" target="_blank" title="在CODE上查看代码片" style="text-indent:0;"><img src="./asp.net SQL Server 存储过程分页及代码调用 _files/CODE_ico.png" width="12" height="12" alt="在CODE上查看代码片" style="position:relative;top:1px;left:2px;"></a><a href="https://code.csdn.net/snippets/393176/fork" target="_blank" title="派生到我的代码片" style="text-indent:0;"><img src="./asp.net SQL Server 存储过程分页及代码调用 _files/ico_fork.svg" width="12" height="12" alt="派生到我的代码片" style="position:relative;top:2px;left:2px;"></a><div style="position: absolute; left: 428px; top: 488px; width: 18px; height: 18px; z-index: 99;"><embed id="ZeroClipboardMovie_1" src="http://static.blog.csdn.net/scripts/ZeroClipboard/ZeroClipboard.swf" loop="false" menu="false" quality="best" bgcolor="#ffffff" width="18" height="18" name="ZeroClipboardMovie_1" align="middle" allowscriptaccess="always" allowfullscreen="false" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" flashvars="id=1&width=18&height=18" wmode="transparent"></div></div></div><ol start="1" class="dp-sql"><li class="alt"><span><span class="keyword">CREATE</span><span> PROC P_viewPage </span></span></li><li class=""><span> @TableName <span class="keyword">VARCHAR</span><span>(200), </span><span class="comment">--表名</span><span> </span></span></li><li class="alt"><span> @FieldList <span class="keyword">VARCHAR</span><span>(2000), </span><span class="comment">--显示列名，如果是全部字段则为*</span><span> </span></span></li><li class=""><span> @PrimaryKey <span class="keyword">VARCHAR</span><span>(100), </span><span class="comment">--单一主键或唯一值键</span><span> </span></span></li><li class="alt"><span> @<span class="keyword">Where</span><span> </span><span class="keyword">VARCHAR</span><span>(2000), </span><span class="comment">--查询条件 不含'where'字符，如id>10 and len(userid)>9</span><span> </span></span></li><li class=""><span> @<span class="keyword">Order</span><span> </span><span class="keyword">VARCHAR</span><span>(1000), </span><span class="comment">--排序 不含'order by'字符，如id asc,userid desc，必须指定asc或desc </span><span> </span></span></li><li class="alt"><span> <span class="comment">--注意当@SortType=3时生效，记住一定要在最后加上主键，否则会让你比较郁闷</span><span> </span></span></li><li class=""><span> @SortType <span class="keyword">INT</span><span>, </span><span class="comment">--排序规则 1:正序asc 2:倒序desc 3:多列排序方法</span><span> </span></span></li><li class="alt"><span> @RecorderCount <span class="keyword">INT</span><span>, </span><span class="comment">--记录总数 0:会返回总记录</span><span> </span></span></li><li class=""><span> @PageSize <span class="keyword">INT</span><span>, </span><span class="comment">--每页输出的记录数</span><span> </span></span></li><li class="alt"><span> @PageIndex <span class="keyword">INT</span><span>, </span><span class="comment">--当前页数</span><span> </span></span></li><li class=""><span> @TotalCount <span class="keyword">INT</span><span> </span><span class="keyword">OUTPUT</span><span>, </span><span class="comment">--记返回总记录</span><span> </span></span></li><li class="alt"><span> @TotalPageCount <span class="keyword">INT</span><span> </span><span class="keyword">OUTPUT</span><span> </span><span class="comment">--返回总页数</span><span> </span></span></li><li class=""><span><span class="keyword">AS</span><span> </span></span></li><li class="alt"><span> <span class="keyword">SET</span><span> NOCOUNT </span><span class="keyword">ON</span><span> </span></span></li><li class=""><span> </span></li><li class="alt"><span> </span></li><li class=""><span> IF <span class="func">ISNULL</span><span>(@TotalCount,</span><span class="string">''</span><span>) = </span><span class="string">''</span><span> </span><span class="keyword">SET</span><span> @TotalCount = 0 </span></span></li><li class="alt"><span> <span class="keyword">SET</span><span> @</span><span class="keyword">Order</span><span> = RTRIM(LTRIM(@</span><span class="keyword">Order</span><span>)) </span></span></li><li class=""><span> <span class="keyword">SET</span><span> @PrimaryKey = RTRIM(LTRIM(@PrimaryKey)) </span></span></li><li class="alt"><span> <span class="keyword">SET</span><span> @FieldList = </span><span class="func">REPLACE</span><span>(RTRIM(LTRIM(@FieldList)),</span><span class="string">' '</span><span>,</span><span class="string">''</span><span>) </span></span></li><li class=""><span> </span></li><li class="alt"><span> </span></li><li class=""><span> WHILE CHARINDEX(<span class="string">', '</span><span>,@</span><span class="keyword">Order</span><span>) > 0 </span><span class="op">OR</span><span> CHARINDEX(</span><span class="string">' ,'</span><span>,@</span><span class="keyword">Order</span><span>) > 0 </span></span></li><li class="alt"><span> <span class="keyword">BEGIN</span><span> </span></span></li><li class=""><span> <span class="keyword">SET</span><span> @</span><span class="keyword">Order</span><span> = </span><span class="func">REPLACE</span><span>(@</span><span class="keyword">Order</span><span>,</span><span class="string">', '</span><span>,</span><span class="string">','</span><span>) </span></span></li><li class="alt"><span> <span class="keyword">SET</span><span> @</span><span class="keyword">Order</span><span> = </span><span class="func">REPLACE</span><span>(@</span><span class="keyword">Order</span><span>,</span><span class="string">' ,'</span><span>,</span><span class="string">','</span><span>) </span></span></li><li class=""><span> <span class="keyword">END</span><span> </span></span></li><li class="alt"><span> </span></li><li class=""><span> </span></li><li class="alt"><span> IF <span class="func">ISNULL</span><span>(@TableName,</span><span class="string">''</span><span>) = </span><span class="string">''</span><span> </span><span class="op">OR</span><span> </span><span class="func">ISNULL</span><span>(@FieldList,</span><span class="string">''</span><span>) = </span><span class="string">''</span><span> </span></span></li><li class=""><span> <span class="op">OR</span><span> </span><span class="func">ISNULL</span><span>(@PrimaryKey,</span><span class="string">''</span><span>) = </span><span class="string">''</span><span> </span></span></li><li class="alt"><span> <span class="op">OR</span><span> @SortType < 1 </span><span class="op">OR</span><span> @SortType >3 </span></span></li><li class=""><span> <span class="op">OR</span><span> @RecorderCount < 0 </span><span class="op">OR</span><span> @PageSize < 0 </span><span class="op">OR</span><span> @PageIndex < 0 </span></span></li><li class="alt"><span> <span class="keyword">BEGIN</span><span> </span></span></li><li class=""><span> PRINT(<span class="string">'ERR_00'</span><span>) </span></span></li><li class="alt"><span> <span class="keyword">RETURN</span><span> </span></span></li><li class=""><span> <span class="keyword">END</span><span> </span></span></li><li class="alt"><span> </span></li><li class=""><span> </span></li><li class="alt"><span> IF @SortType = 3 </span></li><li class=""><span> <span class="keyword">BEGIN</span><span> </span></span></li><li class="alt"><span> IF (<span class="func">UPPER</span><span>(</span><span class="func">RIGHT</span><span>(@</span><span class="keyword">Order</span><span>,4))!=</span><span class="string">' ASC'</span><span> </span><span class="op">AND</span><span> </span><span class="func">UPPER</span><span>(</span><span class="func">RIGHT</span><span>(@</span><span class="keyword">Order</span><span>,5))!=</span><span class="string">' DESC'</span><span>) </span></span></li><li class=""><span> <span class="keyword">BEGIN</span><span> PRINT(</span><span class="string">'ERR_02'</span><span>) </span><span class="keyword">RETURN</span><span> </span><span class="keyword">END</span><span> </span></span></li><li class="alt"><span> <span class="keyword">END</span><span> </span></span></li><li class=""><span> </span></li><li class="alt"><span> </span></li><li class=""><span> <span class="keyword">DECLARE</span><span> @new_where1 </span><span class="keyword">VARCHAR</span><span>(1000) </span></span></li><li class="alt"><span> <span class="keyword">DECLARE</span><span> @new_where2 </span><span class="keyword">VARCHAR</span><span>(1000) </span></span></li><li class=""><span> <span class="keyword">DECLARE</span><span> @new_order1 </span><span class="keyword">VARCHAR</span><span>(1000) </span></span></li><li class="alt"><span> <span class="keyword">DECLARE</span><span> @new_order2 </span><span class="keyword">VARCHAR</span><span>(1000) </span></span></li><li class=""><span> <span class="keyword">DECLARE</span><span> @new_order3 </span><span class="keyword">VARCHAR</span><span>(1000) </span></span></li><li class="alt"><span> <span class="keyword">DECLARE</span><span> @Sql </span><span class="keyword">VARCHAR</span><span>(8000) </span></span></li><li class=""><span> <span class="keyword">DECLARE</span><span> @SqlCount NVARCHAR(4000) </span></span></li><li class="alt"><span> </span></li><li class=""><span> </span></li><li class="alt"><span> IF <span class="func">ISNULL</span><span>(@</span><span class="keyword">where</span><span>,</span><span class="string">''</span><span>) = </span><span class="string">''</span><span> </span></span></li><li class=""><span> <span class="keyword">BEGIN</span><span> </span></span></li><li class="alt"><span> <span class="keyword">SET</span><span> @new_where1 = </span><span class="string">' '</span><span> </span></span></li><li class=""><span> <span class="keyword">SET</span><span> @new_where2 = </span><span class="string">' WHERE '</span><span> </span></span></li><li class="alt"><span> <span class="keyword">END</span><span> </span></span></li><li class=""><span> <span class="keyword">ELSE</span><span> </span></span></li><li class="alt"><span> <span class="keyword">BEGIN</span><span> </span></span></li><li class=""><span> <span class="keyword">SET</span><span> @new_where1 = </span><span class="string">' WHERE '</span><span> + @</span><span class="keyword">where</span><span> </span></span></li><li class="alt"><span> <span class="keyword">SET</span><span> @new_where2 = </span><span class="string">' WHERE '</span><span> + @</span><span class="keyword">where</span><span> + </span><span class="string">' AND '</span><span> </span></span></li><li class=""><span> <span class="keyword">END</span><span> </span></span></li><li class="alt"><span> </span></li><li class=""><span> </span></li><li class="alt"><span> IF <span class="func">ISNULL</span><span>(@</span><span class="keyword">order</span><span>,</span><span class="string">''</span><span>) = </span><span class="string">''</span><span> </span><span class="op">OR</span><span> @SortType = 1 </span><span class="op">OR</span><span> @SortType = 2 </span></span></li><li class=""><span> <span class="keyword">BEGIN</span><span> </span></span></li><li class="alt"><span> IF @SortType = 1 </span></li><li class=""><span> <span class="keyword">BEGIN</span><span> </span></span></li><li class="alt"><span> <span class="keyword">SET</span><span> @new_order1 = </span><span class="string">' ORDER BY '</span><span> + @PrimaryKey + </span><span class="string">' ASC'</span><span> </span></span></li><li class=""><span> <span class="keyword">SET</span><span> @new_order2 = </span><span class="string">' ORDER BY '</span><span> + @PrimaryKey + </span><span class="string">' DESC'</span><span> </span></span></li><li class="alt"><span> <span class="keyword">END</span><span> </span></span></li><li class=""><span> IF @SortType = 2 </span></li><li class="alt"><span> <span class="keyword">BEGIN</span><span> </span></span></li><li class=""><span> <span class="keyword">SET</span><span> @new_order1 = </span><span class="string">' ORDER BY '</span><span> + @PrimaryKey + </span><span class="string">' DESC'</span><span> </span></span></li><li class="alt"><span> <span class="keyword">SET</span><span> @new_order2 = </span><span class="string">' ORDER BY '</span><span> + @PrimaryKey + </span><span class="string">' ASC'</span><span> </span></span></li><li class=""><span> <span class="keyword">END</span><span> </span></span></li><li class="alt"><span> <span class="keyword">END</span><span> </span></span></li><li class=""><span> <span class="keyword">ELSE</span><span> </span></span></li><li class="alt"><span> <span class="keyword">BEGIN</span><span> </span></span></li><li class=""><span> <span class="keyword">SET</span><span> @new_order1 = </span><span class="string">' ORDER BY '</span><span> + @</span><span class="keyword">Order</span><span> </span></span></li><li class="alt"><span> <span class="keyword">END</span><span> </span></span></li><li class=""><span> </span></li><li class="alt"><span> </span></li><li class=""><span> IF @SortType = 3 <span class="op">AND</span><span> CHARINDEX(</span><span class="string">','</span><span>+@PrimaryKey+</span><span class="string">' '</span><span>,</span><span class="string">','</span><span>+@</span><span class="keyword">Order</span><span>)>0 </span></span></li><li class="alt"><span> <span class="keyword">BEGIN</span><span> </span></span></li><li class=""><span> <span class="keyword">SET</span><span> @new_order1 = </span><span class="string">' ORDER BY '</span><span> + @</span><span class="keyword">Order</span><span> </span></span></li><li class="alt"><span> <span class="keyword">SET</span><span> @new_order2 = @</span><span class="keyword">Order</span><span> + </span><span class="string">','</span><span> </span></span></li><li class=""><span> <span class="keyword">SET</span><span> @new_order2 = </span><span class="func">REPLACE</span><span>(</span><span class="func">REPLACE</span><span>(@new_order2,</span><span class="string">'ASC,'</span><span>,</span><span class="string">'{ASC},'</span><span>),</span><span class="string">'DESC,'</span><span>,</span><span class="string">'{DESC},'</span><span>) </span></span></li><li class="alt"><span> <span class="keyword">SET</span><span> @new_order2 = </span><span class="func">REPLACE</span><span>(</span><span class="func">REPLACE</span><span>(@new_order2,</span><span class="string">'{ASC},'</span><span>,</span><span class="string">'DESC,'</span><span>),</span><span class="string">'{DESC},'</span><span>,</span><span class="string">'ASC,'</span><span>) </span></span></li><li class=""><span> <span class="keyword">SET</span><span> @new_order2 = </span><span class="string">' ORDER BY '</span><span> + </span><span class="func">SUBSTRING</span><span>(@new_order2,1,LEN(@new_order2)-1) </span></span></li><li class="alt"><span> IF @FieldList <> <span class="string">'*'</span><span> </span></span></li><li class=""><span> <span class="keyword">BEGIN</span><span> </span></span></li><li class="alt"><span> <span class="keyword">SET</span><span> @new_order3 = </span><span class="func">REPLACE</span><span>(</span><span class="func">REPLACE</span><span>(@</span><span class="keyword">Order</span><span> + </span><span class="string">','</span><span>,</span><span class="string">'ASC,'</span><span>,</span><span class="string">','</span><span>),</span><span class="string">'DESC,'</span><span>,</span><span class="string">','</span><span>) </span></span></li><li class=""><span> <span class="keyword">SET</span><span> @FieldList = </span><span class="string">','</span><span> + @FieldList </span></span></li><li class="alt"><span> WHILE CHARINDEX(<span class="string">','</span><span>,@new_order3)>0 </span></span></li><li class=""><span> <span class="keyword">BEGIN</span><span> </span></span></li><li class="alt"><span> IF CHARINDEX(<span class="func">SUBSTRING</span><span>(</span><span class="string">','</span><span>+@new_order3,1,CHARINDEX(</span><span class="string">','</span><span>,@new_order3)),</span><span class="string">','</span><span>+@FieldList+</span><span class="string">','</span><span>)>0 </span></span></li><li class=""><span> <span class="keyword">BEGIN</span><span> </span></span></li><li class="alt"><span> <span class="keyword">SET</span><span> @FieldList = </span></span></li><li class=""><span> @FieldList + <span class="string">','</span><span> + </span><span class="func">SUBSTRING</span><span>(@new_order3,1,CHARINDEX(</span><span class="string">','</span><span>,@new_order3)) </span></span></li><li class="alt"><span> <span class="keyword">END</span><span> </span></span></li><li class=""><span> <span class="keyword">SET</span><span> @new_order3 = </span></span></li><li class="alt"><span> <span class="func">SUBSTRING</span><span>(@new_order3,CHARINDEX(</span><span class="string">','</span><span>,@new_order3)+1,LEN(@new_order3)) </span></span></li><li class=""><span> <span class="keyword">END</span><span> </span></span></li><li class="alt"><span> <span class="keyword">SET</span><span> @FieldList = </span><span class="func">SUBSTRING</span><span>(@FieldList,2,LEN(@FieldList)) </span></span></li><li class=""><span> <span class="keyword">END</span><span> </span></span></li><li class="alt"><span> <span class="keyword">END</span><span> </span></span></li><li class=""><span> </span></li><li class="alt"><span> </span></li><li class=""><span> <span class="keyword">SET</span><span> @SqlCount = </span><span class="string">'SELECT @TotalCount=COUNT(*),@TotalPageCount=CEILING((COUNT(*)+0.0)/'</span><span> </span></span></li><li class="alt"><span> + <span class="func">CAST</span><span>(@PageSize </span><span class="keyword">AS</span><span> </span><span class="keyword">VARCHAR</span><span>)+</span><span class="string">') FROM '</span><span> + @TableName + @new_where1 </span></span></li><li class=""><span> </span></li><li class="alt"><span> IF @RecorderCount = 0 </span></li><li class=""><span> <span class="keyword">BEGIN</span><span> </span></span></li><li class="alt"><span> <span class="keyword">EXEC</span><span> SP_EXECUTESQL @SqlCount,N</span><span class="string">'@TotalCount INT OUTPUT,@TotalPageCount INT OUTPUT'</span><span>, </span></span></li><li class=""><span> @TotalCount <span class="keyword">OUTPUT</span><span>,@TotalPageCount </span><span class="keyword">OUTPUT</span><span> </span></span></li><li class="alt"><span> <span class="keyword">END</span><span> </span></span></li><li class=""><span> <span class="keyword">ELSE</span><span> </span></span></li><li class="alt"><span> <span class="keyword">BEGIN</span><span> </span></span></li><li class=""><span> <span class="keyword">SELECT</span><span> @TotalCount = @RecorderCount </span></span></li><li class="alt"><span> <span class="keyword">END</span><span> </span></span></li><li class=""><span> </span></li><li class="alt"><span> </span></li><li class=""><span> IF @PageIndex > CEILING((@TotalCount+0.0)/@PageSize) </span></li><li class="alt"><span> <span class="keyword">BEGIN</span><span> </span></span></li><li class=""><span> <span class="keyword">SET</span><span> @PageIndex = CEILING((@TotalCount+0.0)/@PageSize) </span></span></li><li class="alt"><span> <span class="keyword">END</span><span> </span></span></li><li class=""><span> </span></li><li class="alt"><span> </span></li><li class=""><span> IF @PageIndex = 1 <span class="op">OR</span><span> @PageIndex >= CEILING((@TotalCount+0.0)/@PageSize) </span></span></li><li class="alt"><span> <span class="keyword">BEGIN</span><span> </span></span></li><li class=""><span> IF @PageIndex = 1 <span class="comment">--返回第一页数据</span><span> </span></span></li><li class="alt"><span> <span class="keyword">BEGIN</span><span> </span></span></li><li class=""><span> <span class="keyword">SET</span><span> @Sql = </span><span class="string">'SELECT TOP '</span><span> + STR(@PageSize) + </span><span class="string">' '</span><span> + @FieldList + </span><span class="string">' FROM '</span><span> </span></span></li><li class="alt"><span> + @TableName + @new_where1 + @new_order1 </span></li><li class=""><span> <span class="keyword">END</span><span> </span></span></li><li class="alt"><span> IF @PageIndex >= CEILING((@TotalCount+0.0)/@PageSize) <span class="comment">--返回最后一页数据</span><span> </span></span></li><li class=""><span> <span class="keyword">BEGIN</span><span> </span></span></li><li class="alt"><span> <span class="keyword">SET</span><span> @Sql = </span><span class="string">'SELECT TOP '</span><span> + STR(@PageSize) + </span><span class="string">' '</span><span> + @FieldList + </span><span class="string">' FROM ('</span><span> </span></span></li><li class=""><span> + <span class="string">'SELECT TOP '</span><span> + STR(</span><span class="func">ABS</span><span>(@PageSize*@PageIndex-@TotalCount-@PageSize)) </span></span></li><li class="alt"><span> + <span class="string">' '</span><span> + @FieldList + </span><span class="string">' FROM '</span><span> </span></span></li><li class=""><span> + @TableName + @new_where1 + @new_order2 + <span class="string">' ) AS TMP '</span><span> </span></span></li><li class="alt"><span> + @new_order1 </span></li><li class=""><span> <span class="keyword">END</span><span> </span></span></li><li class="alt"><span> <span class="keyword">END</span><span> </span></span></li><li class=""><span> <span class="keyword">ELSE</span><span> </span></span></li><li class="alt"><span> <span class="keyword">BEGIN</span><span> </span></span></li><li class=""><span> IF @SortType = 1 <span class="comment">--仅主键正序排序</span><span> </span></span></li><li class="alt"><span> <span class="keyword">BEGIN</span><span> </span></span></li><li class=""><span> IF @PageIndex <= CEILING((@TotalCount+0.0)/@PageSize)/2 <span class="comment">--正向检索</span><span> </span></span></li><li class="alt"><span> <span class="keyword">BEGIN</span><span> </span></span></li><li class=""><span> <span class="keyword">SET</span><span> @Sql = </span><span class="string">'SELECT TOP '</span><span> + STR(@PageSize) + </span><span class="string">' '</span><span> + @FieldList + </span><span class="string">' FROM '</span><span> </span></span></li><li class="alt"><span> + @TableName + @new_where2 + @PrimaryKey + <span class="string">' > '</span><span> </span></span></li><li class=""><span> + <span class="string">'(SELECT MAX('</span><span> + @PrimaryKey + </span><span class="string">') FROM (SELECT TOP '</span><span> </span></span></li><li class="alt"><span> + STR(@PageSize*(@PageIndex-1)) + <span class="string">' '</span><span> + @PrimaryKey </span></span></li><li class=""><span> + <span class="string">' FROM '</span><span> + @TableName </span></span></li><li class="alt"><span> + @new_where1 + @new_order1 +<span class="string">' ) AS TMP) '</span><span>+ @new_order1 </span></span></li><li class=""><span> <span class="keyword">END</span><span> </span></span></li><li class="alt"><span> <span class="keyword">ELSE</span><span> </span><span class="comment">--反向检索</span><span> </span></span></li><li class=""><span> <span class="keyword">BEGIN</span><span> </span></span></li><li class="alt"><span> <span class="keyword">SET</span><span> @Sql = </span><span class="string">'SELECT TOP '</span><span> + STR(@PageSize) + </span><span class="string">' '</span><span> + @FieldList + </span><span class="string">' FROM ('</span><span> </span></span></li><li class=""><span> + <span class="string">'SELECT TOP '</span><span> + STR(@PageSize) + </span><span class="string">' '</span><span> </span></span></li><li class="alt"><span> + @FieldList + <span class="string">' FROM '</span><span> </span></span></li><li class=""><span> + @TableName + @new_where2 + @PrimaryKey + <span class="string">' < '</span><span> </span></span></li><li class="alt"><span> + <span class="string">'(SELECT MIN('</span><span> + @PrimaryKey + </span><span class="string">') FROM (SELECT TOP '</span><span> </span></span></li><li class=""><span> + STR(@TotalCount-@PageSize*@PageIndex) + <span class="string">' '</span><span> + @PrimaryKey </span></span></li><li class="alt"><span> + <span class="string">' FROM '</span><span> + @TableName </span></span></li><li class=""><span> + @new_where1 + @new_order2 +<span class="string">' ) AS TMP) '</span><span>+ @new_order2 </span></span></li><li class="alt"><span> + <span class="string">' ) AS TMP '</span><span> + @new_order1 </span></span></li><li class=""><span> <span class="keyword">END</span><span> </span></span></li><li class="alt"><span> <span class="keyword">END</span><span> </span></span></li><li class=""><span> IF @SortType = 2 <span class="comment">--仅主键反序排序</span><span> </span></span></li><li class="alt"><span> <span class="keyword">BEGIN</span><span> </span></span></li><li class=""><span> IF @PageIndex <= CEILING((@TotalCount+0.0)/@PageSize)/2 <span class="comment">--正向检索</span><span> </span></span></li><li class="alt"><span> <span class="keyword">BEGIN</span><span> </span></span></li><li class=""><span> <span class="keyword">SET</span><span> @Sql = </span><span class="string">'SELECT TOP '</span><span> + STR(@PageSize) + </span><span class="string">' '</span><span> + @FieldList + </span><span class="string">' FROM '</span><span> </span></span></li><li class="alt"><span> + @TableName + @new_where2 + @PrimaryKey + <span class="string">' < '</span><span> </span></span></li><li class=""><span> + <span class="string">'(SELECT MIN('</span><span> + @PrimaryKey + </span><span class="string">') FROM (SELECT TOP '</span><span> </span></span></li><li class="alt"><span> + STR(@PageSize*(@PageIndex-1)) + <span class="string">' '</span><span> + @PrimaryKey </span></span></li><li class=""><span> +<span class="string">' FROM '</span><span>+ @TableName </span></span></li><li class="alt"><span> + @new_where1 + @new_order1 + <span class="string">') AS TMP) '</span><span>+ @new_order1 </span></span></li><li class=""><span> <span class="keyword">END</span><span> </span></span></li><li class="alt"><span> <span class="keyword">ELSE</span><span> </span><span class="comment">--反向检索</span><span> </span></span></li><li class=""><span> <span class="keyword">BEGIN</span><span> </span></span></li><li class="alt"><span> <span class="keyword">SET</span><span> @Sql = </span><span class="string">'SELECT TOP '</span><span> + STR(@PageSize) + </span><span class="string">' '</span><span> + @FieldList + </span><span class="string">' FROM ('</span><span> </span></span></li><li class=""><span> + <span class="string">'SELECT TOP '</span><span> + STR(@PageSize) + </span><span class="string">' '</span><span> </span></span></li><li class="alt"><span> + @FieldList + <span class="string">' FROM '</span><span> </span></span></li><li class=""><span> + @TableName + @new_where2 + @PrimaryKey + <span class="string">' > '</span><span> </span></span></li><li class="alt"><span> + <span class="string">'(SELECT MAX('</span><span> + @PrimaryKey + </span><span class="string">') FROM (SELECT TOP '</span><span> </span></span></li><li class=""><span> + STR(@TotalCount-@PageSize*@PageIndex) + <span class="string">' '</span><span> + @PrimaryKey </span></span></li><li class="alt"><span> + <span class="string">' FROM '</span><span> + @TableName </span></span></li><li class=""><span> + @new_where1 + @new_order2 +<span class="string">' ) AS TMP) '</span><span>+ @new_order2 </span></span></li><li class="alt"><span> + <span class="string">' ) AS TMP '</span><span> + @new_order1 </span></span></li><li class=""><span> <span class="keyword">END</span><span> </span></span></li><li class="alt"><span> <span class="keyword">END</span><span> </span></span></li><li class=""><span> IF @SortType = 3 <span class="comment">--多列排序，必须包含主键，且放置最后，否则不处理</span><span> </span></span></li><li class="alt"><span> <span class="keyword">BEGIN</span><span> </span></span></li><li class=""><span> IF CHARINDEX(<span class="string">','</span><span> + @PrimaryKey + </span><span class="string">' '</span><span>,</span><span class="string">','</span><span> + @</span><span class="keyword">Order</span><span>) = 0 </span></span></li><li class="alt"><span> <span class="keyword">BEGIN</span><span> PRINT(</span><span class="string">'ERR_02'</span><span>) </span><span class="keyword">RETURN</span><span> </span><span class="keyword">END</span><span> </span></span></li><li class=""><span> IF @PageIndex <= CEILING((@TotalCount+0.0)/@PageSize)/2 <span class="comment">--正向检索</span><span> </span></span></li><li class="alt"><span> <span class="keyword">BEGIN</span><span> </span></span></li><li class=""><span> <span class="keyword">SET</span><span> @Sql = </span><span class="string">'SELECT TOP '</span><span> + STR(@PageSize) + </span><span class="string">' '</span><span> + @FieldList + </span><span class="string">' FROM ( '</span><span> </span></span></li><li class="alt"><span> + <span class="string">'SELECT TOP '</span><span> + STR(@PageSize) + </span><span class="string">' '</span><span> + @FieldList + </span><span class="string">' FROM ( '</span><span> </span></span></li><li class=""><span> + <span class="string">' SELECT TOP '</span><span> + STR(@PageSize*@PageIndex) + </span><span class="string">' '</span><span> + @FieldList </span></span></li><li class="alt"><span> + <span class="string">' FROM '</span><span> + @TableName + @new_where1 + @new_order1 + </span><span class="string">' ) AS TMP '</span><span> </span></span></li><li class=""><span> + @new_order2 + <span class="string">' ) AS TMP '</span><span> + @new_order1 </span></span></li><li class="alt"><span> <span class="keyword">END</span><span> </span></span></li><li class=""><span> <span class="keyword">ELSE</span><span> </span><span class="comment">--反向检索</span><span> </span></span></li><li class="alt"><span> <span class="keyword">BEGIN</span><span> </span></span></li><li class=""><span> <span class="keyword">SET</span><span> @Sql = </span><span class="string">'SELECT TOP '</span><span> + STR(@PageSize) + </span><span class="string">' '</span><span> + @FieldList + </span><span class="string">' FROM ( '</span><span> </span></span></li><li class="alt"><span> + <span class="string">'SELECT TOP '</span><span> + STR(@PageSize) + </span><span class="string">' '</span><span> + @FieldList + </span><span class="string">' FROM ( '</span><span> </span></span></li><li class=""><span> + <span class="string">' SELECT TOP '</span><span> + STR(@TotalCount-@PageSize*@PageIndex+@PageSize) + </span><span class="string">' '</span><span> + @FieldList </span></span></li><li class="alt"><span> + <span class="string">' FROM '</span><span> + @TableName + @new_where1 + @new_order2 + </span><span class="string">' ) AS TMP '</span><span> </span></span></li><li class=""><span> + @new_order1 + <span class="string">' ) AS TMP '</span><span> + @new_order1 </span></span></li><li class="alt"><span> <span class="keyword">END</span><span> </span></span></li><li class=""><span> <span class="keyword">END</span><span> </span></span></li><li class="alt"><span> <span class="keyword">END</span><span> </span></span></li><li class=""><span> PRINT(@Sql) </span></li><li class="alt"><span> <span class="keyword">EXEC</span><span>(@Sql) </span></span></li><li class=""><span>GO </span></li></ol></div><pre code_snippet_id="393176" snippet_file_name="blog_20140615_1_8327674" name="code" class="sql" style="display: none;">CREATE PROC P_viewPage
- @TableName VARCHAR(200), --表名
- @FieldList VARCHAR(2000), --显示列名，如果是全部字段则为*
- @PrimaryKey VARCHAR(100), --单一主键或唯一值键
- @Where VARCHAR(2000), --查询条件 不含'where'字符，如id>10 and len(userid)>9
- @Order VARCHAR(1000), --排序 不含'order by'字符，如id asc,userid desc，必须指定asc或desc
- --注意当@SortType=3时生效，记住一定要在最后加上主键，否则会让你比较郁闷
- @SortType INT, --排序规则 1:正序asc 2:倒序desc 3:多列排序方法
- @RecorderCount INT, --记录总数 0:会返回总记录
- @PageSize INT, --每页输出的记录数
- @PageIndex INT, --当前页数
- @TotalCount INT OUTPUT, --记返回总记录
- @TotalPageCount INT OUTPUT --返回总页数
- AS
- SET NOCOUNT ON
- IF ISNULL(@TotalCount,'') = '' SET @TotalCount = 0
- SET @Order = RTRIM(LTRIM(@Order))
- SET @PrimaryKey = RTRIM(LTRIM(@PrimaryKey))
- SET @FieldList = REPLACE(RTRIM(LTRIM(@FieldList)),' ','')
- WHILE CHARINDEX(', ',@Order) > 0 OR CHARINDEX(' ,',@Order) > 0
- BEGIN
- SET @Order = REPLACE(@Order,', ',',')
- SET @Order = REPLACE(@Order,' ,',',')
- END
- IF ISNULL(@TableName,'') = '' OR ISNULL(@FieldList,'') = ''
- OR ISNULL(@PrimaryKey,'') = ''
- OR @SortType < 1 OR @SortType >3
- OR @RecorderCount < 0 OR @PageSize < 0 OR @PageIndex < 0
- BEGIN
- PRINT('ERR_00')
- RETURN
- END
- IF @SortType = 3
- BEGIN
- IF (UPPER(RIGHT(@Order,4))!=' ASC' AND UPPER(RIGHT(@Order,5))!=' DESC')
- BEGIN PRINT('ERR_02') RETURN END
- END
- DECLARE @new_where1 VARCHAR(1000)
- DECLARE @new_where2 VARCHAR(1000)
- DECLARE @new_order1 VARCHAR(1000)
- DECLARE @new_order2 VARCHAR(1000)
- DECLARE @new_order3 VARCHAR(1000)
- DECLARE @Sql VARCHAR(8000)
- DECLARE @SqlCount NVARCHAR(4000)
- IF ISNULL(@where,'') = ''
- BEGIN
- SET @new_where1 = ' '
- SET @new_where2 = ' WHERE '
- END
- ELSE
- BEGIN
- SET @new_where1 = ' WHERE ' + @where
- SET @new_where2 = ' WHERE ' + @where + ' AND '
- END
- IF ISNULL(@order,'') = '' OR @SortType = 1 OR @SortType = 2
- BEGIN
- IF @SortType = 1
- BEGIN
- SET @new_order1 = ' ORDER BY ' + @PrimaryKey + ' ASC'
- SET @new_order2 = ' ORDER BY ' + @PrimaryKey + ' DESC'
- END
- IF @SortType = 2
- BEGIN
- SET @new_order1 = ' ORDER BY ' + @PrimaryKey + ' DESC'
- SET @new_order2 = ' ORDER BY ' + @PrimaryKey + ' ASC'
- END
- END
- ELSE
- BEGIN
- SET @new_order1 = ' ORDER BY ' + @Order
- END
- IF @SortType = 3 AND CHARINDEX(','+@PrimaryKey+' ',','+@Order)>0
- BEGIN
- SET @new_order1 = ' ORDER BY ' + @Order
- SET @new_order2 = @Order + ','
- SET @new_order2 = REPLACE(REPLACE(@new_order2,'ASC,','{ASC},'),'DESC,','{DESC},')
- SET @new_order2 = REPLACE(REPLACE(@new_order2,'{ASC},','DESC,'),'{DESC},','ASC,')
- SET @new_order2 = ' ORDER BY ' + SUBSTRING(@new_order2,1,LEN(@new_order2)-1)
- IF @FieldList <> '*'
- BEGIN
- SET @new_order3 = REPLACE(REPLACE(@Order + ',','ASC,',','),'DESC,',',')
- SET @FieldList = ',' + @FieldList
- WHILE CHARINDEX(',',@new_order3)>0
- BEGIN
- IF CHARINDEX(SUBSTRING(','+@new_order3,1,CHARINDEX(',',@new_order3)),','+@FieldList+',')>0
- BEGIN
- SET @FieldList =
- @FieldList + ',' + SUBSTRING(@new_order3,1,CHARINDEX(',',@new_order3))
- END
- SET @new_order3 =
- SUBSTRING(@new_order3,CHARINDEX(',',@new_order3)+1,LEN(@new_order3))
- END
- SET @FieldList = SUBSTRING(@FieldList,2,LEN(@FieldList))
- END
- END
- SET @SqlCount = 'SELECT @TotalCount=COUNT(*),@TotalPageCount=CEILING((COUNT(*)+0.0)/'
- + CAST(@PageSize AS VARCHAR)+') FROM ' + @TableName + @new_where1
-
- IF @RecorderCount = 0
- BEGIN
- EXEC SP_EXECUTESQL @SqlCount,N'@TotalCount INT OUTPUT,@TotalPageCount INT OUTPUT',
- @TotalCount OUTPUT,@TotalPageCount OUTPUT
- END
- ELSE
- BEGIN
- SELECT @TotalCount = @RecorderCount
- END
- IF @PageIndex > CEILING((@TotalCount+0.0)/@PageSize)
- BEGIN
- SET @PageIndex = CEILING((@TotalCount+0.0)/@PageSize)
- END
- IF @PageIndex = 1 OR @PageIndex >= CEILING((@TotalCount+0.0)/@PageSize)
- BEGIN
- IF @PageIndex = 1 --返回第一页数据
- BEGIN
- SET @Sql = 'SELECT TOP ' + STR(@PageSize) + ' ' + @FieldList + ' FROM '
- + @TableName + @new_where1 + @new_order1
- END
- IF @PageIndex >= CEILING((@TotalCount+0.0)/@PageSize) --返回最后一页数据
- BEGIN
- SET @Sql = 'SELECT TOP ' + STR(@PageSize) + ' ' + @FieldList + ' FROM ('
- + 'SELECT TOP ' + STR(ABS(@PageSize*@PageIndex-@TotalCount-@PageSize))
- + ' ' + @FieldList + ' FROM '
- + @TableName + @new_where1 + @new_order2 + ' ) AS TMP '
- + @new_order1
- END
- END
- ELSE
- BEGIN
- IF @SortType = 1 --仅主键正序排序
- BEGIN
- IF @PageIndex <= CEILING((@TotalCount+0.0)/@PageSize)/2 --正向检索
- BEGIN
- SET @Sql = 'SELECT TOP ' + STR(@PageSize) + ' ' + @FieldList + ' FROM '
- + @TableName + @new_where2 + @PrimaryKey + ' > '
- + '(SELECT MAX(' + @PrimaryKey + ') FROM (SELECT TOP '
- + STR(@PageSize*(@PageIndex-1)) + ' ' + @PrimaryKey
- + ' FROM ' + @TableName
- + @new_where1 + @new_order1 +' ) AS TMP) '+ @new_order1
- END
- ELSE --反向检索
- BEGIN
- SET @Sql = 'SELECT TOP ' + STR(@PageSize) + ' ' + @FieldList + ' FROM ('
- + 'SELECT TOP ' + STR(@PageSize) + ' '
- + @FieldList + ' FROM '
- + @TableName + @new_where2 + @PrimaryKey + ' < '
- + '(SELECT MIN(' + @PrimaryKey + ') FROM (SELECT TOP '
- + STR(@TotalCount-@PageSize*@PageIndex) + ' ' + @PrimaryKey
- + ' FROM ' + @TableName
- + @new_where1 + @new_order2 +' ) AS TMP) '+ @new_order2
- + ' ) AS TMP ' + @new_order1
- END
- END
- IF @SortType = 2 --仅主键反序排序
- BEGIN
- IF @PageIndex <= CEILING((@TotalCount+0.0)/@PageSize)/2 --正向检索
- BEGIN
- SET @Sql = 'SELECT TOP ' + STR(@PageSize) + ' ' + @FieldList + ' FROM '
- + @TableName + @new_where2 + @PrimaryKey + ' < '
- + '(SELECT MIN(' + @PrimaryKey + ') FROM (SELECT TOP '
- + STR(@PageSize*(@PageIndex-1)) + ' ' + @PrimaryKey
- +' FROM '+ @TableName
- + @new_where1 + @new_order1 + ') AS TMP) '+ @new_order1
- END
- ELSE --反向检索
- BEGIN
- SET @Sql = 'SELECT TOP ' + STR(@PageSize) + ' ' + @FieldList + ' FROM ('
- + 'SELECT TOP ' + STR(@PageSize) + ' '
- + @FieldList + ' FROM '
- + @TableName + @new_where2 + @PrimaryKey + ' > '
- + '(SELECT MAX(' + @PrimaryKey + ') FROM (SELECT TOP '
- + STR(@TotalCount-@PageSize*@PageIndex) + ' ' + @PrimaryKey
- + ' FROM ' + @TableName
- + @new_where1 + @new_order2 +' ) AS TMP) '+ @new_order2
- + ' ) AS TMP ' + @new_order1
- END
- END
- IF @SortType = 3 --多列排序，必须包含主键，且放置最后，否则不处理
- BEGIN
- IF CHARINDEX(',' + @PrimaryKey + ' ',',' + @Order) = 0
- BEGIN PRINT('ERR_02') RETURN END
- IF @PageIndex <= CEILING((@TotalCount+0.0)/@PageSize)/2 --正向检索
- BEGIN
- SET @Sql = 'SELECT TOP ' + STR(@PageSize) + ' ' + @FieldList + ' FROM ( '
- + 'SELECT TOP ' + STR(@PageSize) + ' ' + @FieldList + ' FROM ( '
- + ' SELECT TOP ' + STR(@PageSize*@PageIndex) + ' ' + @FieldList
- + ' FROM ' + @TableName + @new_where1 + @new_order1 + ' ) AS TMP '
- + @new_order2 + ' ) AS TMP ' + @new_order1
- END
- ELSE --反向检索
- BEGIN
- SET @Sql = 'SELECT TOP ' + STR(@PageSize) + ' ' + @FieldList + ' FROM ( '
- + 'SELECT TOP ' + STR(@PageSize) + ' ' + @FieldList + ' FROM ( '
- + ' SELECT TOP ' + STR(@TotalCount-@PageSize*@PageIndex+@PageSize) + ' ' + @FieldList
- + ' FROM ' + @TableName + @new_where1 + @new_order2 + ' ) AS TMP '
- + @new_order1 + ' ) AS TMP ' + @new_order1
- END
- END
- END
- PRINT(@Sql)
- EXEC(@Sql)
- GO</pre><br><br><br><p><span style="font-size:14px;">2、SQL Server 中调用测试代码</span></p><p><span style="font-size:14px;"></span></p><div class="dp-highlighter bg_sql"><div class="bar"><div class="tools"><b>[sql]</b> <a href="http://blog.csdn.net/zdw_wym/article/details/30974033#" class="ViewSource" title="view plain" onclick="dp.sh.Toolbar.Command('ViewSource',this);return false;">view plain</a><a href="http://blog.csdn.net/zdw_wym/article/details/30974033#" class="CopyToClipboard" title="copy" onclick="dp.sh.Toolbar.Command('CopyToClipboard',this);return false;">copy</a><a href="http://blog.csdn.net/zdw_wym/article/details/30974033#" class="PrintSource" title="print" onclick="dp.sh.Toolbar.Command('PrintSource',this);return false;">print</a><a href="http://blog.csdn.net/zdw_wym/article/details/30974033#" class="About" title="?" onclick="dp.sh.Toolbar.Command('About',this);return false;">?</a><a href="https://code.csdn.net/snippets/393176" target="_blank" title="在CODE上查看代码片" style="text-indent:0;"><img src="./asp.net SQL Server 存储过程分页及代码调用 _files/CODE_ico.png" width="12" height="12" alt="在CODE上查看代码片" style="position:relative;top:1px;left:2px;"></a><a href="https://code.csdn.net/snippets/393176/fork" target="_blank" title="派生到我的代码片" style="text-indent:0;"><img src="./asp.net SQL Server 存储过程分页及代码调用 _files/ico_fork.svg" width="12" height="12" alt="派生到我的代码片" style="position:relative;top:2px;left:2px;"></a><div style="position: absolute; left: 428px; top: 4746px; width: 18px; height: 18px; z-index: 99;"><embed id="ZeroClipboardMovie_2" src="http://static.blog.csdn.net/scripts/ZeroClipboard/ZeroClipboard.swf" loop="false" menu="false" quality="best" bgcolor="#ffffff" width="18" height="18" name="ZeroClipboardMovie_2" align="middle" allowscriptaccess="always" allowfullscreen="false" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" flashvars="id=2&width=18&height=18" wmode="transparent"></div></div></div><ol start="1" class="dp-sql"><li class="alt"><span><span class="comment">--执行存储过程</span><span> </span></span></li><li class=""><span><span class="keyword">declare</span><span> @TotalCount </span><span class="keyword">int</span><span>, </span></span></li><li class="alt"><span> @TotalPageCount <span class="keyword">int</span><span> </span></span></li><li class=""><span><span class="keyword">exec</span><span> P_viewPage </span><span class="string">'T_Module'</span><span>,</span><span class="string">'*'</span><span>,</span><span class="string">'ModuleID'</span><span>,</span><span class="string">''</span><span>,</span><span class="string">''</span><span>,1,0,10,1,@TotalCount </span><span class="keyword">output</span><span>,@TotalPageCount </span><span class="keyword">output</span><span> </span></span></li><li class="alt"><span><span class="keyword">Select</span><span> @TotalCount,@TotalPageCount; </span></span></li></ol></div><pre code_snippet_id="393176" snippet_file_name="blog_20140615_2_5928886" name="code" class="sql" style="display: none;">--执行存储过程
- declare @TotalCount int,
- @TotalPageCount int
- exec P_viewPage 'T_Module','*','ModuleID','','',1,0,10,1,@TotalCount output,@TotalPageCount output
- Select @TotalCount,@TotalPageCount;</pre><br><p></p><p><span style="font-size:14px;">asp.net 代码实现：</span></p><p><span style="font-size:14px;"> </span></p><div class="dp-highlighter bg_csharp"><div class="bar"><div class="tools"><b>[csharp]</b> <a href="http://blog.csdn.net/zdw_wym/article/details/30974033#" class="ViewSource" title="view plain" onclick="dp.sh.Toolbar.Command('ViewSource',this);return false;">view plain</a><a href="http://blog.csdn.net/zdw_wym/article/details/30974033#" class="CopyToClipboard" title="copy" onclick="dp.sh.Toolbar.Command('CopyToClipboard',this);return false;">copy</a><a href="http://blog.csdn.net/zdw_wym/article/details/30974033#" class="PrintSource" title="print" onclick="dp.sh.Toolbar.Command('PrintSource',this);return false;">print</a><a href="http://blog.csdn.net/zdw_wym/article/details/30974033#" class="About" title="?" onclick="dp.sh.Toolbar.Command('About',this);return false;">?</a><a href="https://code.csdn.net/snippets/393176" target="_blank" title="在CODE上查看代码片" style="text-indent:0;"><img src="./asp.net SQL Server 存储过程分页及代码调用 _files/CODE_ico.png" width="12" height="12" alt="在CODE上查看代码片" style="position:relative;top:1px;left:2px;"></a><a href="https://code.csdn.net/snippets/393176/fork" target="_blank" title="派生到我的代码片" style="text-indent:0;"><img src="./asp.net SQL Server 存储过程分页及代码调用 _files/ico_fork.svg" width="12" height="12" alt="派生到我的代码片" style="position:relative;top:2px;left:2px;"></a><div style="position: absolute; left: 453px; top: 4983px; width: 18px; height: 18px; z-index: 99;"><embed id="ZeroClipboardMovie_3" src="http://static.blog.csdn.net/scripts/ZeroClipboard/ZeroClipboard.swf" loop="false" menu="false" quality="best" bgcolor="#ffffff" width="18" height="18" name="ZeroClipboardMovie_3" align="middle" allowscriptaccess="always" allowfullscreen="false" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" flashvars="id=3&width=18&height=18" wmode="transparent"></div></div></div><ol start="1" class="dp-c"><li class="alt"><span><span class="preprocessor">#region ===========通用分页存储过程===========</span><span> </span></span></li><li class=""><span> <span class="keyword">public</span><span> </span><span class="keyword">static</span><span> DataSet RunProcedureDS(</span><span class="keyword">string</span><span> connectionString, </span><span class="keyword">string</span><span> storedProcName, IDataParameter[] parameters, </span><span class="keyword">string</span><span> tableName) </span></span></li><li class="alt"><span> { </span></li><li class=""><span> <span class="keyword">using</span><span> (SqlConnection connection = </span><span class="keyword">new</span><span> SqlConnection(connectionString)) </span></span></li><li class="alt"><span> { </span></li><li class=""><span> DataSet dataSet = <span class="keyword">new</span><span> DataSet(); </span></span></li><li class="alt"><span> connection.Open(); </span></li><li class=""><span> SqlDataAdapter sqlDA = <span class="keyword">new</span><span> SqlDataAdapter(); </span></span></li><li class="alt"><span> sqlDA.SelectCommand = BuildQueryCommand(connection, storedProcName, parameters); </span></li><li class=""><span> sqlDA.Fill(dataSet, tableName); </span></li><li class="alt"><span> connection.Close(); </span></li><li class=""><span> <span class="keyword">return</span><span> dataSet; </span></span></li><li class="alt"><span> } </span></li><li class=""><span> } </span></li><li class="alt"><span> </span></li><li class=""><span> <span class="comment">/// <summary></span><span> </span></span></li><li class="alt"><span> <span class="comment">/// 通用分页存储过程</span><span> </span></span></li><li class=""><span> <span class="comment">/// </summary></span><span> </span></span></li><li class="alt"><span> <span class="comment">/// <param name="connectionString"></param></span><span> </span></span></li><li class=""><span> <span class="comment">/// <param name="tblName"></param></span><span> </span></span></li><li class="alt"><span> <span class="comment">/// <param name="strGetFields"></param></span><span> </span></span></li><li class=""><span> <span class="comment">/// <param name="primaryKey"></param></span><span> </span></span></li><li class="alt"><span> <span class="comment">/// <param name="strWhere"></param></span><span> </span></span></li><li class=""><span> <span class="comment">/// <param name="strOrder"></param></span><span> </span></span></li><li class="alt"><span> <span class="comment">/// <param name="sortType"></param></span><span> </span></span></li><li class=""><span> <span class="comment">/// <param name="recordCount"></param></span><span> </span></span></li><li class="alt"><span> <span class="comment">/// <param name="PageSize"></param></span><span> </span></span></li><li class=""><span> <span class="comment">/// <param name="PageIndex"></param></span><span> </span></span></li><li class="alt"><span> <span class="comment">/// <param name="totalCount"></param></span><span> </span></span></li><li class=""><span> <span class="comment">/// <param name="totalPageCount"></param></span><span> </span></span></li><li class="alt"><span> <span class="comment">/// <returns></returns></span><span> </span></span></li><li class=""><span> <span class="keyword">public</span><span> </span><span class="keyword">static</span><span> DataSet PageList(</span><span class="keyword">string</span><span> connectionString, </span><span class="keyword">string</span><span> tblName, </span><span class="keyword">string</span><span> strGetFields, </span><span class="keyword">string</span><span> primaryKey, </span><span class="keyword">string</span><span> strWhere, </span><span class="keyword">string</span><span> strOrder, </span><span class="keyword">int</span><span> sortType, </span><span class="keyword">int</span><span> recordCount, </span></span></li><li class="alt"><span> <span class="keyword">int</span><span> PageSize, </span><span class="keyword">int</span><span> PageIndex,</span><span class="keyword">ref</span><span> </span><span class="keyword">int</span><span> totalCount,</span><span class="keyword">ref</span><span> </span><span class="keyword">int</span><span> totalPageCount) </span></span></li><li class=""><span> { </span></li><li class="alt"><span> SqlParameter[] parameters ={ <span class="keyword">new</span><span> SqlParameter(</span><span class="string">"@TableName "</span><span>,SqlDbType.VarChar,200), </span></span></li><li class=""><span> <span class="keyword">new</span><span> SqlParameter(</span><span class="string">"@FieldList"</span><span>,SqlDbType.VarChar,2000), </span></span></li><li class="alt"><span> <span class="keyword">new</span><span> SqlParameter(</span><span class="string">"@PrimaryKey"</span><span>,SqlDbType.VarChar,100), </span></span></li><li class=""><span> <span class="keyword">new</span><span> SqlParameter(</span><span class="string">"@Where"</span><span>,SqlDbType.VarChar,2000), </span></span></li><li class="alt"><span> <span class="keyword">new</span><span> SqlParameter(</span><span class="string">"@Order"</span><span>,SqlDbType.VarChar,1000), </span></span></li><li class=""><span> <span class="keyword">new</span><span> SqlParameter(</span><span class="string">"@SortType"</span><span>,SqlDbType.Int), </span></span></li><li class="alt"><span> <span class="keyword">new</span><span> SqlParameter(</span><span class="string">"@RecorderCount"</span><span>,SqlDbType.Int), </span></span></li><li class=""><span> <span class="keyword">new</span><span> SqlParameter(</span><span class="string">"@PageSize"</span><span>,SqlDbType.Int), </span></span></li><li class="alt"><span> <span class="keyword">new</span><span> SqlParameter(</span><span class="string">"@PageIndex"</span><span>,SqlDbType.Int), </span></span></li><li class=""><span> <span class="keyword">new</span><span> SqlParameter(</span><span class="string">"@TotalCount"</span><span>,SqlDbType.Int), </span></span></li><li class="alt"><span> <span class="keyword">new</span><span> SqlParameter(</span><span class="string">"@TotalPageCount"</span><span>,SqlDbType.Int)}; </span></span></li><li class=""><span> </span></li><li class="alt"><span> </span></li><li class=""><span> parameters[0].Value = tblName; </span></li><li class="alt"><span> parameters[1].Value = strGetFields; </span></li><li class=""><span> parameters[2].Value = primaryKey; </span></li><li class="alt"><span> parameters[3].Value = strWhere; </span></li><li class=""><span> parameters[4].Value = strOrder; </span></li><li class="alt"><span> parameters[5].Value = sortType; </span></li><li class=""><span> parameters[6].Value = recordCount; </span></li><li class="alt"><span> parameters[7].Value = PageSize; </span></li><li class=""><span> parameters[8].Value = PageIndex; </span></li><li class="alt"><span> parameters[9].Value = totalCount; </span></li><li class=""><span> parameters[9].Direction = ParameterDirection.Output; </span></li><li class="alt"><span> parameters[10].Value = totalPageCount; </span></li><li class=""><span> parameters[10].Direction = ParameterDirection.Output; </span></li><li class="alt"><span> </span></li><li class=""><span> </span></li><li class="alt"><span> DataSet ds = RunProcedureDS(connectionString, <span class="string">"P_viewPage"</span><span>, parameters, </span><span class="string">"PageListTable"</span><span>); </span></span></li><li class=""><span> totalCount = <span class="keyword">int</span><span>.Parse(parameters[9].Value.ToString()); </span></span></li><li class="alt"><span> totalPageCount = <span class="keyword">int</span><span>.Parse(parameters[10].Value.ToString()); </span></span></li><li class=""><span> <span class="keyword">return</span><span> ds; </span></span></li><li class="alt"><span> } </span></li><li class=""><span><span class="preprocessor"> #endregion</span><span> </span></span></li><li class="alt"><span> </span></li><li class=""><span>DataSet ds = SqlHelper.PageList(SqlHelper.LocalSqlServer, <span class="string">"T_User"</span><span>, </span><span class="string">"*"</span><span>, </span><span class="string">"UserID"</span><span>, </span><span class="string">""</span><span>, </span><span class="string">""</span><span>, 1, 0, pageSize, 1, </span><span class="keyword">ref</span><span> totalCount, </span><span class="keyword">ref</span><span> totalPageCount); </span></span></li><li class="alt"><span><span class="keyword">this</span><span>.RptData.DataSource = ds; </span></span></li><li class=""><span><span class="keyword">this</span><span>.RptData.DataBind(); </span></span></li></ol></div><pre code_snippet_id="393176" snippet_file_name="blog_20140615_3_4293466" name="code" class="csharp" style="display: none;">#region ===========通用分页存储过程===========
- public static DataSet RunProcedureDS(string connectionString, string storedProcName, IDataParameter[] parameters, string tableName)
- {
- using (SqlConnection connection = new SqlConnection(connectionString))
- {
- DataSet dataSet = new DataSet();
- connection.Open();
- SqlDataAdapter sqlDA = new SqlDataAdapter();
- sqlDA.SelectCommand = BuildQueryCommand(connection, storedProcName, parameters);
- sqlDA.Fill(dataSet, tableName);
- connection.Close();
- return dataSet;
- }
- }
- /// <summary>
- /// 通用分页存储过程
- /// </summary>
- /// <param name="connectionString"></param>
- /// <param name="tblName"></param>
- /// <param name="strGetFields"></param>
- /// <param name="primaryKey"></param>
- /// <param name="strWhere"></param>
- /// <param name="strOrder"></param>
- /// <param name="sortType"></param>
- /// <param name="recordCount"></param>
- /// <param name="PageSize"></param>
- /// <param name="PageIndex"></param>
- /// <param name="totalCount"></param>
- /// <param name="totalPageCount"></param>
- /// <returns></returns>
- public static DataSet PageList(string connectionString, string tblName, string strGetFields, string primaryKey, string strWhere, string strOrder, int sortType, int recordCount,
- int PageSize, int PageIndex,ref int totalCount,ref int totalPageCount)
- {
- SqlParameter[] parameters ={ new SqlParameter("@TableName ",SqlDbType.VarChar,200),
- new SqlParameter("@FieldList",SqlDbType.VarChar,2000),
- new SqlParameter("@PrimaryKey",SqlDbType.VarChar,100),
- new SqlParameter("@Where",SqlDbType.VarChar,2000),
- new SqlParameter("@Order",SqlDbType.VarChar,1000),
- new SqlParameter("@SortType",SqlDbType.Int),
- new SqlParameter("@RecorderCount",SqlDbType.Int),
- new SqlParameter("@PageSize",SqlDbType.Int),
- new SqlParameter("@PageIndex",SqlDbType.Int),
- new SqlParameter("@TotalCount",SqlDbType.Int),
- new SqlParameter("@TotalPageCount",SqlDbType.Int)};
- parameters[0].Value = tblName;
- parameters[1].Value = strGetFields;
- parameters[2].Value = primaryKey;
- parameters[3].Value = strWhere;
- parameters[4].Value = strOrder;
- parameters[5].Value = sortType;
- parameters[6].Value = recordCount;
- parameters[7].Value = PageSize;
- parameters[8].Value = PageIndex;
- parameters[9].Value = totalCount;
- parameters[9].Direction = ParameterDirection.Output;
- parameters[10].Value = totalPageCount;
- parameters[10].Direction = ParameterDirection.Output;
- DataSet ds = RunProcedureDS(connectionString, "P_viewPage", parameters, "PageListTable");
- totalCount = int.Parse(parameters[9].Value.ToString());
- totalPageCount = int.Parse(parameters[10].Value.ToString());
- return ds;
- }
- #endregion
- DataSet ds = SqlHelper.PageList(SqlHelper.LocalSqlServer, "T_User", "*", "UserID", "", "", 1, 0, pageSize, 1, ref totalCount, ref totalPageCount);
- this.RptData.DataSource = ds;
- this.RptData.DataBind();</pre><br><p></p>
- </div>
- <!-- Baidu Button BEGIN -->
- <div class="bdsharebuttonbox bdshare-button-style0-16" style="float: right;" data-bd-bind="1411284913253">
- <a href="http://blog.csdn.net/zdw_wym/article/details/30974033#" class="bds_more" data-cmd="more" style="background-position:0 0 !important; background-image: url(http://bdimg.share.baidu.com/static/api/img/share/icons_0_16.png?v=d754dcc0.png) !important"></a>
- <a href="http://blog.csdn.net/zdw_wym/article/details/30974033#" class="bds_qzone" data-cmd="qzone" title="分享到QQ空间" style="background-position:0 -52px !important"></a>
- <a href="http://blog.csdn.net/zdw_wym/article/details/30974033#" class="bds_tsina" data-cmd="tsina" title="分享到新浪微博" style="background-position:0 -104px !important"></a>
- <a href="http://blog.csdn.net/zdw_wym/article/details/30974033#" class="bds_tqq" data-cmd="tqq" title="分享到腾讯微博" style="background-position:0 -260px !important"></a>
- <a href="http://blog.csdn.net/zdw_wym/article/details/30974033#" class="bds_renren" data-cmd="renren" title="分享到人人网" style="background-position:0 -208px !important"></a>
- <a href="http://blog.csdn.net/zdw_wym/article/details/30974033#" class="bds_weixin" data-cmd="weixin" title="分享到微信" style="background-position:0 -1612px !important"></a>
- </div>
- <script>window._bd_share_config = { "common": { "bdSnsKey": {}, "bdText": "", "bdMini": "1", "bdMiniList": false, "bdPic": "", "bdStyle": "0", "bdSize": "16" }, "share": {} }; with (document) 0[(getElementsByTagName('head')[0] || body).appendChild(createElement('script')).src = 'http://bdimg.share.baidu.com/static/api/js/share.js?v=89860593.js?cdnversion=' + ~(-new Date() / 36e5)];</script>
- <!-- Baidu Button END -->
- <!--192.168.100.35-->
- <ul class="article_next_prev">
- <li class="prev_article"><span onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_shangyipian']);location.href='/zdw_wym/article/details/30457927';">上一篇</span><a href="http://blog.csdn.net/zdw_wym/article/details/30457927" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_shangyipian'])">一个jquery的小例子</a></li>
- <li class="next_article"><span onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_xiayipian']);location.href='/zdw_wym/article/details/38066745';">下一篇</span><a href="http://blog.csdn.net/zdw_wym/article/details/38066745" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_xiayipian'])">ORA-28001: the password has expired解决办法</a></li>
- </ul>
- <!-- Baidu Button BEGIN -->
- <script type="text/javascript" id="bdshare_js" data="type=tools&uid=1536434" src="./asp.net SQL Server 存储过程分页及代码调用 _files/bds_s_v2.js"></script>
- <script type="text/javascript">
- document.getElementById("bdshell_js").src = "http://bdimg.share.baidu.com/static/js/shell_v2.js?cdnversion=" + Math.ceil(new Date()/3600000)
- </script>
- <!-- Baidu Button END -->
- </div>
- <dl class="blog-associat-tag">
- <dt>主题推荐</dt>
- <dd>
- <a href="http://www.csdn.net/tag/sql%20server" target="_blank" class="blog-tage-red">sql server</a>
- <a href="http://www.csdn.net/tag/%E5%AD%98%E5%82%A8" target="_blank" class="blog-tage-red">存储</a>
- <a href="http://www.csdn.net/tag/%E5%88%86%E9%A1%B5" target="_blank" class="blog-tage-red">分页</a>
- <a href="http://www.csdn.net/tag/asp.net" target="_blank" class="blog-tage-red">asp.net</a>
- <a href="http://www.csdn.net/tag/%E6%95%B0%E6%8D%AE" target="_blank" class="blog-tage-red">数据</a>
- </dd>
- </dl>
- <dl class="blog-ass-articl tracking-ad" data-mod="popu_36" id="res-relatived">
- <dt><span>猜你在找</span></dt>
- <dd style="background:url(http://static.blog.csdn.net/skin/default/images/blog-dot-red3.gif) no-repeat 0 10px;"><a href="http://blog.csdn.net/huangtao2011/article/details/7209392" title="asp.net 常用功能" strategy="SearchAlgorithm" target="_blank">asp.net 常用功能</a></dd><dd style="background:url(http://static.blog.csdn.net/skin/default/images/blog-dot-red3.gif) no-repeat 0 10px;"><a href="http://blog.csdn.net/li_ser/article/details/24306677" title="ASP.NET优化" strategy="SearchAlgorithm" target="_blank">ASP.NET优化</a></dd><dd style="background:url(http://static.blog.csdn.net/skin/default/images/blog-dot-red3.gif) no-repeat 0 10px;"><a href="http://blog.csdn.net/jingxuewang110/article/details/6835280" title="sql server面试题" strategy="SearchAlgorithm" target="_blank">sql server面试题</a></dd><dd style="background:url(http://static.blog.csdn.net/skin/default/images/blog-dot-red3.gif) no-repeat 0 10px;"><a href="http://blog.csdn.net/passvcword/article/details/9133829" title="[知识库分享系列] 二、.NET（ASP.NET）" strategy="SearchAlgorithm" target="_blank">[知识库分享系列] 二、.NET（ASP.NET）</a></dd><dd style="background:url(http://static.blog.csdn.net/skin/default/images/blog-dot-red3.gif) no-repeat 0 10px;"><a href="http://blog.csdn.net/zhanglan478950/article/details/8914529" title="C#+SQL Server" strategy="SearchAlgorithm" target="_blank">C#+SQL Server</a></dd><dd style="background:url(http://static.blog.csdn.net/skin/default/images/blog-dot-red3.gif) no-repeat 0 10px;"><a href="http://blog.csdn.net/z123500/article/details/8454219" title="Asp.net性能的技巧" strategy="SearchAlgorithm" target="_blank">Asp.net性能的技巧</a></dd><dd style="background:url(http://static.blog.csdn.net/skin/default/images/blog-dot-red3.gif) no-repeat 0 10px;"><a href="http://blog.csdn.net/sbwgdc/article/details/19341705" title="ASP.NET面试资料" strategy="SearchAlgorithm" target="_blank">ASP.NET面试资料</a></dd><dd style="background:url(http://static.blog.csdn.net/skin/default/images/blog-dot-red3.gif) no-repeat 0 10px;"><a href="http://blog.csdn.net/bhn_candy/article/details/16987435" title="何种情况适用存储过程以及常用的分页、查询案例" strategy="SearchAlgorithm" target="_blank">何种情况适用存储过程以及常用的分页、查询案例</a></dd><dd style="background:url(http://static.blog.csdn.net/skin/default/images/blog-dot-red3.gif) no-repeat 0 10px;"><a href="http://blog.csdn.net/chengyingmingcheng/article/details/39030821" title="什么时候用存储过程" strategy="SearchAlgorithm" target="_blank">什么时候用存储过程</a></dd><dd style="background:url(http://static.blog.csdn.net/skin/default/images/blog-dot-red3.gif) no-repeat 0 10px;"><a href="http://blog.csdn.net/gulijiang2008/article/details/7303413" title="asp.net网站的性能优化" strategy="SearchAlgorithm" target="_blank">asp.net网站的性能优化</a></dd></dl>
- <script type="text/javascript">
- var searchtitletags = 'asp.net SQL Server 存储过程分页及代码调用' + ',' + 'sql server,存储,分页,asp.net,数据';
- searchService({
- index: 'blog',
- query: searchtitletags,
- from: 10,
- size: 10,
- appendTo: '#res-relatived',
- url: 'recommend',
- his: 2,
- client: "blog_cf_enhance",
- tmpl: '<dd style="background:url(http://static.blog.csdn.net/skin/default/images/blog-dot-red3.gif) no-repeat 0 10px;"><a href="#{ url }" title="#{ title }" strategy="#{ strategy }">#{ title }</a></dd>'
- });
- </script>
- <div id="ad_cen">
-
- <script type="text/javascript">
- new Ad(4, 'ad_cen');
- </script>
- <iframe id="ad_frm_0" frameborder="0" scrolling="no" src="./asp.net SQL Server 存储过程分页及代码调用 _files/ad(1).htm" style="border-width: 0px; overflow: hidden; width: 984px; height: 90px;"></iframe></div>
- <div class="comment_class">
- <div id="comment_title" class="panel_head">
- <span class="see_comment">查看评论</span><a name="comments"></a></div>
- <div id="comment_list"><br> 暂无评论<br><br><div class="clear"></div></div>
- <div id="comment_bar">
- </div>
- <div id="comment_form"><div class="guest_link">您还没有登录,请<a href="javascript:void(0);" onclick="javascript:csdn.showLogin(function (dat) {js_logined(dat.data.userName);});">[登录]</a>或<a href="http://passport.csdn.net/account/register?from=http%3A%2F%2Fblog.csdn.net%2Fzdw_wym%2Farticle%2Fdetails%2F30974033">[注册]</a></div></div>
- <div class="announce">
- * 以上用户言论只代表其个人观点，不代表CSDN网站的观点或立场<a name="reply"></a><a name="quote"></a></div>
- </div>
- <script type="text/javascript">
- var fileName = '30974033';
- var commentscount = 0;
- var islock = false
- </script>
- <script type="text/javascript" src="./asp.net SQL Server 存储过程分页及代码调用 _files/comment.js"></script>
- <div id="ad_bot">
- <iframe id="ad_frm_1" frameborder="0" scrolling="no" src="./asp.net SQL Server 存储过程分页及代码调用 _files/ad(2).htm" style="border-width: 0px; overflow: hidden; width: 984px; height: 0px;"></iframe></div>
- <script type="text/javascript">
- new Ad(5, 'ad_bot');
- </script>
- <div id="report_dialog">
- </div>
- <div id="d-top" style="bottom:60px;">
-
- <a id="quick-reply" class="btn btn-top q-reply" title="快速回复" style="display:none;">
- <img src="./asp.net SQL Server 存储过程分页及代码调用 _files/blog-icon-reply.png" alt="快速回复">
- </a>
- <a id="d-top-a" class="btn btn-top backtop" style="display: none;" title="返回顶部" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_huidaodingbu'])">
- <img src="./asp.net SQL Server 存储过程分页及代码调用 _files/top.png" alt="TOP">
- </a>
- </div>
- <script type="text/javascript">
- $(function ()
- {
- $("#ad_frm_0").height("90px");
-
- setTimeout(function(){
- $("#ad_frm_2").height("200px");
- },1000);
-
- if($("#comment_content").length>0)
- {
- $("#quick-reply").show();
- $("#quick-reply").click(function(){
- setEditorFocus();
- });
- }
-
- var d_top = $('#d-top-a');
- document.onscroll = function ()
- {
- var scrTop = (document.body.scrollTop || document.documentElement.scrollTop);
- if (scrTop > 500)
- {
- d_top.show();
- } else
- {
- d_top.hide();
- }
- }
- $('#d-top-a').click(function ()
- {
- scrollTo(0, 0);
- this.blur();
- return false;
- });
- });
-
- </script>
- <style type="text/css">
- .tag_list
- {
- background: none repeat scroll 0 0 #FFFFFF;
- border: 1px solid #D7CBC1;
- color: #000000;
- font-size: 12px;
- line-height: 20px;
- list-style: none outside none;
- margin: 10px 2% 0 1%;
- padding: 1px;
- }
- .tag_list h5
- {
- background: none repeat scroll 0 0 #E0DBD3;
- color: #47381C;
- font-size: 12px;
- height: 24px;
- line-height: 24px;
- padding: 0 5px;
- margin: 0;
- }
- .tag_list h5 a
- {
- color: #47381C;
- }
- .classify
- {
- margin: 10px 0;
- padding: 4px 12px 8px;
- }
- .classify a
- {
- margin-right: 20px;
- white-space: nowrap;
- }
- </style>
- <div class="tag_list">
- <h5>
- <a href="http://www.csdn.net/tag/" target="_blank">核心技术类目</a></h5>
- <div class="classify">
- <a title="全部主题" href="http://www.csdn.net/tag" target="_blank" onclick="LogClickCount(this,336);">全部主题</a>
- <a title="Hadoop" href="http://g.csdn.net/5272865" target="_blank" onclick="LogClickCount(this,336);">Hadoop</a>
- <a title="AWS" href="http://g.csdn.net/5272866" target="_blank" onclick="LogClickCount(this,336);">AWS</a>
- <a title="移动游戏" href="http://g.csdn.net/5272870" target="_blank" onclick="LogClickCount(this,336);">移动游戏</a>
- <a title="Java" href="http://g.csdn.net/5272871" target="_blank" onclick="LogClickCount(this,336);">Java</a>
- <a title="Android" href="http://g.csdn.net/5272872" target="_blank" onclick="LogClickCount(this,336);">Android</a>
- <a title="iOS" href="http://g.csdn.net/5272873" target="_blank" onclick="LogClickCount(this,336);">iOS</a>
- <a title="Swift" href="http://g.csdn.net/5272868" target="_blank" onclick="LogClickCount(this,336);">Swift</a>
- <a title="智能硬件" href="http://g.csdn.net/5272869" target="_blank" onclick="LogClickCount(this,336);">智能硬件</a>
- <a title="Docker" href="http://g.csdn.net/5272867" target="_blank" onclick="LogClickCount(this,336);">Docker</a>
- <a title="OpenStack" href="http://g.csdn.net/5272925" target="_blank" onclick="LogClickCount(this,336);">OpenStack</a>
- <a title="VPN" href="http://www.csdn.net/tag/vpn" target="_blank" onclick="LogClickCount(this,336);">VPN</a>
- <a title="Spark" href="http://g.csdn.net/5272924" target="_blank" onclick="LogClickCount(this,336);">Spark</a>
- <a title="ERP" href="http://www.csdn.net/tag/erp" target="_blank" onclick="LogClickCount(this,336);">ERP</a>
- <a title="IE10" href="http://www.csdn.net/tag/ie10" target="_blank" onclick="LogClickCount(this,336);">IE10</a>
- <a title="Eclipse" href="http://www.csdn.net/tag/eclipse" target="_blank" onclick="LogClickCount(this,336);">Eclipse</a>
- <a title="CRM" href="http://www.csdn.net/tag/crm" target="_blank" onclick="LogClickCount(this,336);">CRM</a>
- <a title="JavaScript" href="http://www.csdn.net/tag/javascript" target="_blank" onclick="LogClickCount(this,336);">JavaScript</a>
- <a title="数据库" href="http://www.csdn.net/tag/%E6%95%B0%E6%8D%AE%E5%BA%93" target="_blank" onclick="LogClickCount(this,336);">数据库</a>
- <a title="Ubuntu" href="http://www.csdn.net/tag/ubuntu" target="_blank" onclick="LogClickCount(this,336);">Ubuntu</a>
- <a title="NFC" href="http://www.csdn.net/tag/nfc" target="_blank" onclick="LogClickCount(this,336);">NFC</a>
- <a title="WAP" href="http://www.csdn.net/tag/wap" target="_blank" onclick="LogClickCount(this,336);">WAP</a>
- <a title="jQuery" href="http://www.csdn.net/tag/jquery" target="_blank" onclick="LogClickCount(this,336);">jQuery</a>
- <a title="BI" href="http://www.csdn.net/tag/bi" target="_blank" onclick="LogClickCount(this,336);">BI</a>
- <a title="HTML5" href="http://www.csdn.net/tag/html5" target="_blank" onclick="LogClickCount(this,336);">HTML5</a>
- <a title="Spring" href="http://www.csdn.net/tag/spring" target="_blank" onclick="LogClickCount(this,336);">Spring</a>
- <a title="Apache" href="http://www.csdn.net/tag/apache" target="_blank" onclick="LogClickCount(this,336);">Apache</a>
- <a title=".NET" href="http://www.csdn.net/tag/.net" target="_blank" onclick="LogClickCount(this,336);">.NET</a>
- <a title="API" href="http://www.csdn.net/tag/api" target="_blank" onclick="LogClickCount(this,336);">API</a>
- <a title="HTML" href="http://www.csdn.net/tag/html" target="_blank" onclick="LogClickCount(this,336);">HTML</a>
- <a title="SDK" href="http://www.csdn.net/tag/sdk" target="_blank" onclick="LogClickCount(this,336);">SDK</a>
- <a title="IIS" href="http://www.csdn.net/tag/iis" target="_blank" onclick="LogClickCount(this,336);">IIS</a>
- <a title="Fedora" href="http://www.csdn.net/tag/fedora" target="_blank" onclick="LogClickCount(this,336);">Fedora</a>
- <a title="XML" href="http://www.csdn.net/tag/xml" target="_blank" onclick="LogClickCount(this,336);">XML</a>
- <a title="LBS" href="http://www.csdn.net/tag/lbs" target="_blank" onclick="LogClickCount(this,336);">LBS</a>
- <a title="Unity" href="http://www.csdn.net/tag/unity" target="_blank" onclick="LogClickCount(this,336);">Unity</a>
- <a title="Splashtop" href="http://www.csdn.net/tag/splashtop" target="_blank" onclick="LogClickCount(this,336);">Splashtop</a>
- <a title="UML" href="http://www.csdn.net/tag/uml" target="_blank" onclick="LogClickCount(this,336);">UML</a>
- <a title="components" href="http://www.csdn.net/tag/components" target="_blank" onclick="LogClickCount(this,336);">components</a>
- <a title="Windows Mobile" href="http://www.csdn.net/tag/windowsmobile" target="_blank" onclick="LogClickCount(this,336);">Windows Mobile</a>
- <a title="Rails" href="http://www.csdn.net/tag/rails" target="_blank" onclick="LogClickCount(this,336);">Rails</a>
- <a title="QEMU" href="http://www.csdn.net/tag/qemu" target="_blank" onclick="LogClickCount(this,336);">QEMU</a>
- <a title="KDE" href="http://www.csdn.net/tag/kde" target="_blank" onclick="LogClickCount(this,336);">KDE</a>
- <a title="Cassandra" href="http://www.csdn.net/tag/cassandra" target="_blank" onclick="LogClickCount(this,336);">Cassandra</a>
- <a title="CloudStack" href="http://www.csdn.net/tag/cloudstack" target="_blank" onclick="LogClickCount(this,336);">CloudStack</a>
- <a title="FTC" href="http://www.csdn.net/tag/ftc" target="_blank" onclick="LogClickCount(this,336);">FTC</a>
- <a title="coremail" href="http://www.csdn.net/tag/coremail" target="_blank" onclick="LogClickCount(this,336);">coremail</a>
- <a title="OPhone " href="http://www.csdn.net/tag/ophone" target="_blank" onclick="LogClickCount(this,336);">OPhone </a>
- <a title="CouchBase" href="http://www.csdn.net/tag/couchbase" target="_blank" onclick="LogClickCount(this,336);">CouchBase</a>
- <a title="云计算" href="http://www.csdn.net/tag/%E4%BA%91%E8%AE%A1%E7%AE%97" target="_blank" onclick="LogClickCount(this,336);">云计算</a>
- <a title="iOS6" href="http://www.csdn.net/tag/iOS6" target="_blank" onclick="LogClickCount(this,336);">iOS6</a>
- <a title="Rackspace " href="http://www.csdn.net/tag/rackspace" target="_blank" onclick="LogClickCount(this,336);">Rackspace </a>
- <a title="Web App" href="http://www.csdn.net/tag/webapp" target="_blank" onclick="LogClickCount(this,336);">Web App</a>
- <a title="SpringSide" href="http://www.csdn.net/tag/springside" target="_blank" onclick="LogClickCount(this,336);">SpringSide</a>
- <a title="Maemo" href="http://www.csdn.net/tag/maemo" target="_blank" onclick="LogClickCount(this,336);">Maemo</a>
- <a title="Compuware" href="http://www.csdn.net/tag/compuware" target="_blank" onclick="LogClickCount(this,336);">Compuware</a>
- <a title="大数据" href="http://www.csdn.net/tag/%E5%A4%A7%E6%95%B0%E6%8D%AE" target="_blank" onclick="LogClickCount(this,336);">大数据</a>
- <a title="aptech" href="http://www.csdn.net/tag/aptech" target="_blank" onclick="LogClickCount(this,336);">aptech</a>
- <a title="Perl" href="http://www.csdn.net/tag/perl" target="_blank" onclick="LogClickCount(this,336);">Perl</a>
- <a title="Tornado" href="http://www.csdn.net/tag/tornado" target="_blank" onclick="LogClickCount(this,336);">Tornado</a>
- <a title="Ruby" href="http://www.csdn.net/tag/ruby" target="_blank" onclick="LogClickCount(this,336);">Ruby</a>
- <a title="Hibernate" href="http://www.csdn.net/hibernate" target="_blank" onclick="LogClickCount(this,336);">Hibernate</a>
- <a title="ThinkPHP" href="http://www.csdn.net/tag/thinkphp" target="_blank" onclick="LogClickCount(this,336);">ThinkPHP</a>
- <a title="HBase" href="http://www.csdn.net/tag/hbase" target="_blank" onclick="LogClickCount(this,336);">HBase</a>
- <a title="Pure" href="http://www.csdn.net/tag/pure" target="_blank" onclick="LogClickCount(this,336);">Pure</a>
- <a title="Solr" href="http://www.csdn.net/tag/solr" target="_blank" onclick="LogClickCount(this,336);">Solr</a>
- <a title="Angular" href="http://www.csdn.net/tag/angular" target="_blank" onclick="LogClickCount(this,336);">Angular</a>
- <a title="Cloud Foundry" href="http://www.csdn.net/tag/cloudfoundry" target="_blank" onclick="LogClickCount(this,336);">Cloud Foundry</a>
- <a title="Redis" href="http://www.csdn.net/tag/redis" target="_blank" onclick="LogClickCount(this,336);">Redis</a>
- <a title="Scala" href="http://www.csdn.net/tag/scala" target="_blank" onclick="LogClickCount(this,336);">Scala</a>
- <a title="Django" href="http://www.csdn.net/tag/django" target="_blank" onclick="LogClickCount(this,336);">Django</a>
- <a title="Bootstrap" href="http://www.csdn.net/tag/bootstrap" target="_blank" onclick="LogClickCount(this,336);">Bootstrap</a>
- </div>
- </div>
- <div class="clear">
- </div>
- </div>
-
- </div>
- <div id="side">
- <div class="side">
- <div id="panel_Category" class="panel">
- <ul class="panel_head"><span>博客专栏</span></ul>
- <ul class="panel_body" id="sp_column">
- <table cellpadding="0" cellspacing="0"><tbody><tr>
- <td style="padding:10px 10px 0 0;">
- <a href="http://blog.csdn.net/column/details/webgis.html" target="_blank"><img src="./asp.net SQL Server 存储过程分页及代码调用 _files/20120906093633278.jpg" style="width:75px;height:75px;"></a>
- </td>
- <td style="padding:10px 0; vertical-align:top;">
- <a href="http://blog.csdn.net/column/details/webgis.html" target="_blank">ArcGIS API for Silverlight开发</a>
- <p>文章：34篇</p>
- <span>阅读：48309</span>
- </td>
- </tr></tbody></table>
- </ul>
- </div><div id="custom_column_22258520" class="panel">
- <ul class="panel_head"><span>.NET SL GIS开发群</span></ul>
- <ul class="panel_body">
- 欢迎大家加入群，交流分享GIS开发的点点滴滴，
- 共同进步！
- 群号：106887513
- </ul>
- </div><div id="panel_Profile" class="panel">
- <ul class="panel_head"><span>个人资料</span></ul>
- <ul class="panel_body profile">
- <div id="blog_userface">
- <a href="http://my.csdn.net/taomanman" target="_blank">
- <img src="./asp.net SQL Server 存储过程分页及代码调用 _files/1_taomanman.jpg" title="访问我的空间" style="max-width:90%">
- </a>
- <br>
- <span><a href="http://my.csdn.net/taomanman" class="user_name" target="_blank">暖枫无敌</a></span>
- </div>
- <div class="interact">
- <a href="javascript:void(0);" class="attent" id="span_add_follow" title="[加关注]" onclick="_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_guanzhu'])"></a>
- <a href="javascript:void(0);" class="letter" title="[发私信]" onclick="window.open('http://msg.csdn.net/letters/model?receiver=taomanman','_blank','height=350,width=700');_gaq.push(['_trackEvent','function', 'onclick', 'blog_articles_sixin'])"></a>
- </div>
- <div id="blog_medal">
- <div class="ico_expert" title="CSDN认证专家"></div>
- <div id="bms_box"><a href="http://medal.blog.csdn.net/allmedal.aspx" target="_blank"><img src="./asp.net SQL Server 存储过程分页及代码调用 _files/columnstar_s.gif" onmouseover="m_over_m(this,0)" onmouseout="m_out_m()" alt=""></a><a href="http://medal.blog.csdn.net/allmedal.aspx" target="_blank"><img src="./asp.net SQL Server 存储过程分页及代码调用 _files/holdon_s2.gif" onmouseover="m_over_m(this,1)" onmouseout="m_out_m()" alt=""></a></div></div>
- <ul id="blog_rank">
- <li>访问：<span>389768次</span></li>
- <li>积分：<span>8111分</span></li>
- <li>排名：<span>第645名</span></li>
- </ul>
- <ul id="blog_statistics">
- <li>原创：<span>414篇</span></li>
- <li>转载：<span>55篇</span></li>
- <li>译文：<span>2篇</span></li>
- <li>评论：<span>253条</span></li>
- </ul>
- </ul>
- </div>
- <div id="custom_column_25772635" class="panel">
- <ul class="panel_head"><span>链接分享</span></ul>
- <ul class="panel_body">
- <a href="http://un.zhubajie.com/r/?u=5611932&l=https://login.zhubajie.com/register/">点击查看</a>
- </ul>
- </div><div class="panel" id="panel_Search">
- <ul class="panel_head"><span>文章搜索</span></ul>
- <ul class="panel_body">
- <form id="frmSearch" action="http://so.csdn.net/search" class="form_search" target="_blank">
- <span><input id="inputSearch" type="text" class="blogsearch" title="请输入关键字"></span>
- <input id="btnSubmit" type="button" value="搜索" title="search in blog">
- <input type="hidden" name="q" id="inputQ">
- <input type="hidden" name="t" value="blog">
- <a id="btnSearchBlog" target="_blank"></a>
- </form>
- </ul>
- </div>
- <script type="text/javascript">
- $(function () {
- $("#btnSubmit").click(function () {
- search();
- });
- $("#frmSearch").submit(function () {
- search();
- return false;
- });
- function search()
- {
- var url = "http://so.csdn.net/so/search/s.do?q=" + encodeURIComponent($("#inputSearch").val()) + "&u=" + username + "&t=blog";
- window.location.href = url;
- }
- });
- </script><div id="panel_Archive" class="panel">
- <ul class="panel_head"><span>文章存档</span></ul>
- <ul class="panel_body">
- <div id="archive_list"><li><a href="http://blog.csdn.net/zdw_wym/article/month/2014/09">2014年09月</a><span>(2)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2014/08">2014年08月</a><span>(4)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2014/07">2014年07月</a><span>(2)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2014/06">2014年06月</a><span>(5)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2014/05">2014年05月</a><span>(3)</span></li><span class="hidelist" style="display:none;"><li><a href="http://blog.csdn.net/zdw_wym/article/month/2014/04">2014年04月</a><span>(6)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2014/03">2014年03月</a><span>(5)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2014/02">2014年02月</a><span>(2)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2014/01">2014年01月</a><span>(5)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2013/12">2013年12月</a><span>(3)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2013/11">2013年11月</a><span>(1)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2013/10">2013年10月</a><span>(4)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2013/09">2013年09月</a><span>(6)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2013/08">2013年08月</a><span>(1)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2013/07">2013年07月</a><span>(4)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2013/05">2013年05月</a><span>(7)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2013/04">2013年04月</a><span>(5)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2013/03">2013年03月</a><span>(7)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2013/02">2013年02月</a><span>(10)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2013/01">2013年01月</a><span>(9)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2012/12">2012年12月</a><span>(3)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2012/11">2012年11月</a><span>(9)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2012/10">2012年10月</a><span>(9)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2012/09">2012年09月</a><span>(8)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2012/08">2012年08月</a><span>(8)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2012/07">2012年07月</a><span>(17)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2012/06">2012年06月</a><span>(7)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2012/05">2012年05月</a><span>(16)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2012/04">2012年04月</a><span>(12)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2012/03">2012年03月</a><span>(16)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2012/02">2012年02月</a><span>(3)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2012/01">2012年01月</a><span>(9)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2011/12">2011年12月</a><span>(27)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2011/11">2011年11月</a><span>(15)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2011/10">2011年10月</a><span>(14)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2011/09">2011年09月</a><span>(17)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2011/08">2011年08月</a><span>(17)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2011/07">2011年07月</a><span>(9)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2011/06">2011年06月</a><span>(10)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2011/05">2011年05月</a><span>(7)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2011/04">2011年04月</a><span>(9)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2011/03">2011年03月</a><span>(5)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2011/02">2011年02月</a><span>(3)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2011/01">2011年01月</a><span>(1)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2010/12">2010年12月</a><span>(3)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2010/11">2010年11月</a><span>(8)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2010/10">2010年10月</a><span>(6)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2010/09">2010年09月</a><span>(23)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2010/08">2010年08月</a><span>(9)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2010/07">2010年07月</a><span>(24)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2010/06">2010年06月</a><span>(4)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2010/05">2010年05月</a><span>(7)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2010/04">2010年04月</a><span>(11)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2010/03">2010年03月</a><span>(5)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2010/02">2010年02月</a><span>(2)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2010/01">2010年01月</a><span>(4)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2009/12">2009年12月</a><span>(7)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2009/11">2009年11月</a><span>(3)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2009/10">2009年10月</a><span>(6)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2009/09">2009年09月</a><span>(1)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2009/08">2009年08月</a><span>(4)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2009/07">2009年07月</a><span>(1)</span></li><li><a href="http://blog.csdn.net/zdw_wym/article/month/2008/12">2008年12月</a><span>(1)</span></li></span><div id="archive_list_button" class="list_closed">展开</div></div>
- </ul>
- </div>
- <div id="hotarticls" class="panel">
- <ul class="panel_head">
- <span>
- 阅读排行 </span>
- </ul>
- <ul class="panel_body itemlist">
- <li>
- <a href="http://blog.csdn.net/zdw_wym/article/details/6325853" title="(三)、使用HighCharts创建第一个图表实例">(三)、使用HighCharts创建第一个图表实例</a><span>(15620)</span>
- </li>
- <li>
- <a href="http://blog.csdn.net/zdw_wym/article/details/6325942" title="(四)、读取数据库数据并在HighCharts上显示">(四)、读取数据库数据并在HighCharts上显示</a><span>(11988)</span>
- </li>
- <li>
- <a href="http://blog.csdn.net/zdw_wym/article/details/6233930" title="asp.net页面显示word文档内容">asp.net页面显示word文档内容</a><span>(7560)</span>
- </li>
- <li>
- <a href="http://blog.csdn.net/zdw_wym/article/details/6942186" title="（五）、利用HighCharts 显示饼图">（五）、利用HighCharts 显示饼图</a><span>(6965)</span>
- </li>
- <li>
- <a href="http://blog.csdn.net/zdw_wym/article/details/7937391" title="ArcGIS API for Silverlight 调用GP服务准备---GP模型建立、发布、测试">ArcGIS API for Silverlight 调用GP服务准备---GP模型建立、发布、测试</a><span>(5286)</span>
- </li>
- <li>
- <a href="http://blog.csdn.net/zdw_wym/article/details/8025509" title="ArcGIS中利用ArcMap将地理坐标系转换成投影坐标系（从WKID=4326到WKID=102100）">ArcGIS中利用ArcMap将地理坐标系转换成投影坐标系（从WKID=4326到WKID=102100）</a><span>(5171)</span>
- </li>
- <li>
- <a href="http://blog.csdn.net/zdw_wym/article/details/6325684" title="(二)、HighCharts图表js库结构介绍及下载">(二)、HighCharts图表js库结构介绍及下载</a><span>(3896)</span>
- </li>
- <li>
- <a href="http://blog.csdn.net/zdw_wym/article/details/5910199" title="Repeater控件用法----一列数据在Repeater中每行显示固定记录方法">Repeater控件用法----一列数据在Repeater中每行显示固定记录方法</a><span>(3479)</span>
- </li>
- <li>
- <a href="http://blog.csdn.net/zdw_wym/article/details/5994943" title="图片锁定，防止连接">图片锁定，防止连接</a><span>(3383)</span>
- </li>
- <li>
- <a href="http://blog.csdn.net/zdw_wym/article/details/8019687" title="ArcGIS API for Silverlight中加载Google地形图（瓦片图）">ArcGIS API for Silverlight中加载Google地形图（瓦片图）</a><span>(3352)</span>
- </li>
- </ul>
- </div>
- <div id="hotarticls2" class="panel">
- <ul class="panel_head"><span>评论排行</span></ul>
- <ul class="panel_body itemlist">
- <li>
- <a href="http://blog.csdn.net/zdw_wym/article/details/6233930" title="asp.net页面显示word文档内容">asp.net页面显示word文档内容</a><span>(28)</span>
- </li>
- <li>
- <a href="http://blog.csdn.net/zdw_wym/article/details/7937391" title="ArcGIS API for Silverlight 调用GP服务准备---GP模型建立、发布、测试">ArcGIS API for Silverlight 调用GP服务准备---GP模型建立、发布、测试</a><span>(17)</span>
- </li>
- <li>
- <a href="http://blog.csdn.net/zdw_wym/article/details/6325853" title="(三)、使用HighCharts创建第一个图表实例">(三)、使用HighCharts创建第一个图表实例</a><span>(17)</span>
- </li>
- <li>
- <a href="http://blog.csdn.net/zdw_wym/article/details/6325942" title="(四)、读取数据库数据并在HighCharts上显示">(四)、读取数据库数据并在HighCharts上显示</a><span>(14)</span>
- </li>
- <li>
- <a href="http://blog.csdn.net/zdw_wym/article/details/6989076" title="asp.net 操作Excel表数据导入到SQL Server数据库">asp.net 操作Excel表数据导入到SQL Server数据库</a><span>(12)</span>
- </li>
- <li>
- <a href="http://blog.csdn.net/zdw_wym/article/details/7937879" title="ArcGIS API for Silverlight 调用GP服务加载等值线图层">ArcGIS API for Silverlight 调用GP服务加载等值线图层</a><span>(11)</span>
- </li>
- <li>
- <a href="http://blog.csdn.net/zdw_wym/article/details/7354103" title="ArcGIS API for Silverlight 中根据坐标点在地图上打标记">ArcGIS API for Silverlight 中根据坐标点在地图上打标记</a><span>(11)</span>
- </li>
- <li>
- <a href="http://blog.csdn.net/zdw_wym/article/details/5591433" title="利用Lucene.net实现检索并对检索关键字高亮显示">利用Lucene.net实现检索并对检索关键字高亮显示</a><span>(9)</span>
- </li>
- <li>
- <a href="http://blog.csdn.net/zdw_wym/article/details/8482975" title="WPF库存管理系统界面（仿360UI风格）">WPF库存管理系统界面（仿360UI风格）</a><span>(9)</span>
- </li>
- <li>
- <a href="http://blog.csdn.net/zdw_wym/article/details/6415520" title="利用WebService自定义显示天气情况">利用WebService自定义显示天气情况</a><span>(6)</span>
- </li>
- </ul>
- </div>
- <div id="homepageArticles" class="panel tracking-ad" data-mod="popu_4">
- <ul class="panel_head"><span>推荐文章</span></ul>
- <ul class="panel_body" id="ad_commend"><iframe id="ad_frm_2" frameborder="0" scrolling="no" src="./asp.net SQL Server 存储过程分页及代码调用 _files/ad.htm" style="border-width: 0px; overflow: hidden; width: 194px; height: 200px;"></iframe></ul>
- </div>
- <script type="text/javascript">
- new Ad(12, 'ad_commend');
- </script><div id="newcomments" class="panel">
- <ul class="panel_head"><span>最新评论</span></ul>
- <ul class="panel_body itemlist">
- <li>
-
- <a href="http://blog.csdn.net/zdw_wym/article/details/7012754#comments">jquery ajax数据操作 DropDownList级联</a>
- <p style="margin:0px;"><a href="http://blog.csdn.net/ironxue" class="user_name">ironxue</a>:
- 很有用的东西，向楼主学习。
- </p>
- </li>
- <li>
-
- <a href="http://blog.csdn.net/zdw_wym/article/details/7013466#comments">Session容易丢失的一些常见解决办法</a>
- <p style="margin:0px;"><a href="http://blog.csdn.net/ironxue" class="user_name">ironxue</a>:
- 不太懂，不过感觉很实用的东西。顶楼主。
- </p>
- </li>
- <li>
-
- <a href="http://blog.csdn.net/zdw_wym/article/details/7616605#comments">ArcGIS API for Silverlight 鼠标移动显示地理坐标</a>
- <p style="margin:0px;"><a href="http://blog.csdn.net/yundeyi" class="user_name">yundeyi</a>:
- 搞定了。谢谢您。
- </p>
- </li>
- <li>
-
- <a href="http://blog.csdn.net/zdw_wym/article/details/6325853#comments">(三)、使用HighCharts创建第一个图表实例</a>
- <p style="margin:0px;"><a href="http://blog.csdn.net/zjj972326230" class="user_name">zjj972326230</a>:
- 请问一下，我想把第一个柱状图最下面那个 人数 那个方块去掉怎么改代码呢，谢谢啊
- </p>
- </li>
- <li>
-
- <a href="http://blog.csdn.net/zdw_wym/article/details/6325853#comments">ArcGIS API for Silverlight 鼠标移动显示地理坐标</a>
- <p style="margin:0px;"><a href="http://blog.csdn.net/taomanman" class="user_name">暖枫无敌</a>:
- @yundeyi:这个就是xaml页面中的一个TextBlock控件的x:Name值
- </p>
- </li>
- <li>
-
- <a href="http://blog.csdn.net/zdw_wym/article/details/6325853#comments">ArcGIS API for Silverlight 鼠标移动显示地理坐标</a>
- <p style="margin:0px;"><a href="http://blog.csdn.net/yundeyi" class="user_name">yundeyi</a>:
- 请问下，MapCoordsTextBlock是在哪里声明的？
- </p>
- </li>
- <li>
-
- <a href="http://blog.csdn.net/zdw_wym/article/details/5758067#comments">Silverlight调用自定义的Web Service从数据库获取数据进行页面绑定</a>
- <p style="margin:0px;"><a href="http://blog.csdn.net/sdkj10" class="user_name">sdkj10</a>:
- 能发一下源码吗？739000230@qq.com
- </p>
- </li>
- <li>
-
- <a href="http://blog.csdn.net/zdw_wym/article/details/7469594#comments">ArcGIS API for Silverlight 点击地图弹出自定义窗体</a>
- <p style="margin:0px;"><a href="http://blog.csdn.net/taolinyan092" class="user_name">taolinyan092</a>:
- 大神getData1SoapClient在哪
- </p>
- </li>
- <li>
-
- <a href="http://blog.csdn.net/zdw_wym/article/details/7469594#comments">ArcGIS API for Silverlight 点击地图弹出自定义窗体</a>
- <p style="margin:0px;"><a href="http://blog.csdn.net/taolinyan092" class="user_name">taolinyan092</a>:
- 大神你那个小旗子是自己添得吗
- </p>
- </li>
- <li>
-
- <a href="http://blog.csdn.net/zdw_wym/article/details/7469594#comments">ArcGIS API for Silverlight 点击地图弹出自定义窗体</a>
- <p style="margin:0px;"><a href="http://blog.csdn.net/taolinyan092" class="user_name">taolinyan092</a>:
- 大神你using MapClient.ServiceReference1; 是添加了那个引用啊
- </p>
- </li>
- </ul>
- </div>
- <div id="custom_column_5674097" class="panel">
- <ul class="panel_head"><span>友情链接</span></ul>
- <ul class="panel_body">
- <br>
- 1、<a href="http://xpi8.com/" title="郭新" target="_blank">雪海流浪</a> <br>
- 2、<a href="http://www.asp.net/cn" title="微软ASP.NET官网" target="_blank">微软ASP.NET官网</a>
- <br>
- 3、<a href="http://sourceforge.net/projects/pdfbox/" title="处理PDF文档组件" target="_blank">处理PDF文档组件</a>
- <br>
- 4、<a href="http://www.slfans.com/Silverlight/" title="Silverlight Fans" target="_blank">Silverlight Fans</a>
- <br>
- 5、<a href="http://blogs.msdn.com/b/silverlight/archive/2009/11/09/announcing-the-new-microsoft-sdk-for-facebook-platform.aspx" title="Silverlight Team Blog" target="_blank">Silverlight Team Blog</a>
- <br>
- 6、<a href="http://www.jfree.org/" title="jfree 图表" target="_blank">jfree 图表</a> <br>
- 7、<a href="http://www.cnblogs.com/chenkai/" title="博客园" target="_blank">博客园 chenkai</a>
- <br>
- 8、<a href="http://www.effiproz.com/SL4QTDemo.aspx" title="Effiproz Embeded C# DataBase" target="_blank">Effiproz Embeded C# DataBase</a>
- <br>
- </ul>
- </div> </div>
- <div class="clear">
- </div>
- </div>
- <div class="clear">
- </div>
- </div>
-
- <script type="text/javascript" src="./asp.net SQL Server 存储过程分页及代码调用 _files/cnick.js"></script>
- <script type="text/javascript" src="./asp.net SQL Server 存储过程分页及代码调用 _files/newblog.min.js"></script>
- <script type="text/javascript" src="./asp.net SQL Server 存储过程分页及代码调用 _files/showblogmedal.ashx"></script>
- <script type="text/javascript">
- document.write('<script type="text/javascript" src="http://csdnimg.cn/pubfooter/js/publib_footer.js?' + Math.floor(new Date() / 120000).toString(36) + '="></' + 'script>');
- </script><script type="text/javascript" src="./asp.net SQL Server 存储过程分页及代码调用 _files/publib_footer.js"></script><link rel="stylesheet" type="text/css" href="./asp.net SQL Server 存储过程分页及代码调用 _files/pub_footer_2012.css"><div id="pub_footerall" class="pub_footerall"><dl><dt></dt> <dd><a href="http://www.csdn.net/company/about.html" target="_blank">公司简介</a>|<a href="http://www.csdn.net/company/recruit.html" target="_blank">招贤纳士</a>|<a href="http://www.csdn.net/company/marketing.html" target="_blank">广告服务</a>|<a href="http://www.csdn.net/company/account.html" target="_blank">银行汇款帐号</a>|<a href="http://www.csdn.net/company/contact.html" target="_blank">联系方式</a>|<a href="http://www.csdn.net/company/statement.html" target="_blank">版权声明</a>|<a href="http://www.csdn.net/company/layer.html" target="_blank">法律顾问</a>|<a href="mailto:webmaster@csdn.net">问题报告</a>|<a target="_blank" href="http://www.csdn.net/friendlink.html">合作伙伴</a>|<a href="http://bbs.csdn.net/forums/Service" target="_blank">论坛反馈</a></dd><dd><a href="http://wpa.qq.com/msgrd?v=3&uin=2355263776&site=qq&menu=yes" target="_blank" class="qq">网站客服</a> <a href="http://wpa.qq.com/msgrd?v=3&uin=2251809102&site=qq&menu=yes" target="_blank" class="qq">杂志客服</a> <a href="http://e.weibo.com/csdnsupport/profile" target="_blank" class="weibo">微博客服</a> <a href="mailto:webmaster@csdn.net" class="email" title="联系邮箱">webmaster@csdn.net</a> <span class="phone" title="服务热线">400-600-2320</span></dd><dd>京 ICP 证 070598 号</dd><dd>北京创新乐知信息技术有限公司 版权所有</dd><dd>江苏乐知网络技术有限公司 提供商务支持</dd><dd>Copyright © 1999-2014, CSDN.NET, All Rights Reserved <a href="http://www.hd315.gov.cn/beian/view.asp?bianhao=010202001032100010" target="_blank"><img src="./asp.net SQL Server 存储过程分页及代码调用 _files/gongshang_logos.gif" alt="GongshangLogo" title=""></a></dd></dl></div><div id="note1" class="csdn_note" style="display:none; position:absolute; z-index:9999; width:440px"> <span class="notice_top_arrow"><span class="inner"></span></span> <div class="box"></div></div><div class="csdn_notice_tip" style="display: none; position: absolute; z-index: 9990; width: 170px;"> <iframe src="about:blank" frameborder="0" scrolling="no" style="z-index:-1;position:absolute;top:0;left:0;width:100%;height:100%;background:transparent"></iframe> <div class="tip_text">您有<strong>0</strong>条新通知</div> <a href="javascript:void 0" class="close2"></a></div><script id="noticeScript" type="text/javascript" btnid="header_notice_num" wrapid="note1" count="5" subcount="5" src="./asp.net SQL Server 存储过程分页及代码调用 _files/notify.js"></script>
- <script type="text/javascript" src="./asp.net SQL Server 存储过程分页及代码调用 _files/login.js"></script>
- <script type="text/javascript">document.write("<img src=http://counter.csdn.net/pv.aspx?id=24 border=0 width=0 height=0>");</script><img src="./asp.net SQL Server 存储过程分页及代码调用 _files/pv.aspx" border="0" width="0" height="0">
- <script type="text/javascript" src="./asp.net SQL Server 存储过程分页及代码调用 _files/counter.js"></script><script type="text/javascript" charset="UTF-8" src="./asp.net SQL Server 存储过程分页及代码调用 _files/msg.popup.js"></script>
- <script type="text/javascript" src="./asp.net SQL Server 存储过程分页及代码调用 _files/ad-blog.js"></script>
- <script type="text/javascript" src="./asp.net SQL Server 存储过程分页及代码调用 _files/count.js"></script><iframe src="./asp.net SQL Server 存储过程分页及代码调用 _files/logs.htm" frameborder="0" width="0" height="0"></iframe>
- <script type="text/javascript">
- $(function () {
- function __get_code_toolbar(snippet_id) {
- return $("<a href='https://code.csdn.net/snippets/"
- + snippet_id
- + "' target='_blank' title='在CODE上查看代码片' style='text-indent:0;'><img src='https://code.csdn.net/assets/CODE_ico.png' width=12 height=12 alt='在CODE上查看代码片' style='position:relative;top:1px;left:2px;'/></a>"
- + "<a href='https://code.csdn.net/snippets/"
- + snippet_id
- + "/fork' target='_blank' title='派生到我的代码片' style='text-indent:0;'><img src='https://code.csdn.net/assets/ico_fork.svg' width=12 height=12 alt='派生到我的代码片' style='position:relative;top:2px;left:2px;'/></a>");
- }
-
- $("[code_snippet_id]").each(function () {
- __s_id = $(this).attr("code_snippet_id");
- if (__s_id != null && __s_id != "" && __s_id != 0 && parseInt(__s_id) > 70020) {
- __code_tool = __get_code_toolbar(__s_id);
- $(this).prev().find(".tools").append(__code_tool);
- }
- });
- });
- </script>
- </div>
- <!--new top-->
-
- <script id="csdn-toolbar-id" btnid="header_notice_num" wrapid="note1" count="5" subcount="5" type="text/javascript" src="./asp.net SQL Server 存储过程分页及代码调用 _files/toolbar.js"></script>
- <!--new top-->
- <div id="tag-suggest-pop">
- <div class="relative">
- <div class="close"></div>
- <div class="content"></div>
- </div>
- </div></body></html>
|
