《asp.net实现向上向下排序的例子__2》由会员分享，可在线阅读，更多相关《asp.net实现向上向下排序的例子__2（15页珍藏版）》请在金锄头文库上搜索。
1、实现向上向下排序的例子_ 工作中一些常用到的代码记录下来，便利自己查找也便利其他需要人士参考。 废话不多说，这是一个向上向下排序的功能，首先用法存储过程 整好 如下： sql: - = - author: - create date: - description: - = alter procedure dbo.sp_bannerorder - add the parameters for the stored procedure here ( tablename nvarchar(50), -表名 colname nvarchar(50), -排序字段 keyid nvarchar(50),
2、 -表主键字段 keyidvalue int, -表主键字段值1 order nvarchar(20), - 列表默认的排序方式，asc或desc orderdirection nvarchar(20), -排序方向，up或down where nvarchar(2021) -查询条件 ) as begin declare ordertmp1 int; -临时排序值id1 declare ordertmp2 int; -临时排序值id2 declare tmpkeyidvaule nvarchar(50); declare sql nvarchar(2021); declare parmdef
3、inition nvarchar(500); declare parmdefinition2 nvarchar(500); if order=asc begin set sql = nselect ordertmp1out=+colname+ from +tablename+ where +keyid+=+cast(keyidvalue as nvarchar(50); set parmdefinition = nordertmp1out nvarchar(20) output; execute sp_executesql sql, parmdefinition, ordertmp1out=o
4、rdertmp1 output; if orderdirection=up begin set sql = nselect top 1 ordertmp2out=+colname+,tmpkeyidvauleout=+keyid+ from +tablename+ where +colname+cast(ordertmp1 as nvarchar(50)+ and +where+ order by +colname+ desc; end else begin set sql = nselect top 1 ordertmp2out=+colname+,tmpkeyidvauleout=+key
5、id+ from +tablename+ where +colname+cast(ordertmp1 as nvarchar(50)+ and +where+ order by +colname+ asc; end set parmdefinition = nordertmp2out nvarchar(20) output, tmpkeyidvauleout nvarchar(20) output; execute sp_executesql sql, parmdefinition, ordertmp2out=ordertmp2 output, tmpkeyidvauleout=tmpkeyi
6、dvaule output; end else begin set sql = nselect ordertmp1out=+colname+ from +tablename+ where +keyid+=+cast(keyidvalue as nvarchar(50); set parmdefinition = nordertmp1out nvarchar(20) output; execute sp_executesql sql, parmdefinition, ordertmp1out=ordertmp1 output; if orderdirection=up begin set sql
7、 = nselect top 1 ordertmp2out=+colname+,tmpkeyidvauleout=+keyid+ from +tablename+ where +colname+cast(ordertmp1 as nvarchar(50)+ and +where+ order by +colname+ asc; end else begin set sql = nselect top 1 ordertmp2out=+colname+,tmpkeyidvauleout=+keyid+ from +tablename+ where +colname+cast(ordertmp1 a
8、s nvarchar(50)+ and +where+ order by +colname+ desc; end set parmdefinition = nordertmp2out nvarchar(20) output, tmpkeyidvauleout nvarchar(20) output; execute sp_executesql sql, parmdefinition, ordertmp2out=ordertmp2 output, tmpkeyidvauleout=tmpkeyidvaule output; end set sql = update +tablename+ set
9、 +colname+=+cast(ordertmp2 as nvarchar(50)+ where +keyid+=+cast(keyidvalue as nvarchar(50); set sql = sql + update +tablename+ set +colname+=+cast(ordertmp1 as nvarchar(50)+ where +keyid+=+cast(tmpkeyidvaule as nvarchar(50); -select ordertmp1,ordertmp2,tmpkeyidvaule,sql exec(sql); end model： public
10、class banner public banner() private int _id; private string _smallpic; private string _bigpic; private int _orderid; private string _url; private string _title; private string _descript; /字增量id public int id get return this._id; set this._id = value; /banner小图 public string smallpic get return this
11、._smallpic; set this._smallpic = value; / / banner大图 / public string bigpic get return this._bigpic; set this._bigpic = value; / / 排序id / public int orderid get return this._orderid; set this._orderid = value; / / url地址 / public string url get return this._url; set this._url = value; / / 标题 / public
12、 string title get return this._title; set this._title = value; / / 描述 / public string descript get return this._descript; set this._descript = value; idal代码: / 排序 / / 表名 / 排序字段 / 表主键字段 / 表主键字段值 / 列表默认的排序方式，asc或desc / 排序方向，up或down / 条件 / int order(string table,string colname,string keyid,int keyidvalue,string order,string orderdirection,string whe); sqldal代码： public int order(string table,string colname,string keyid,int keyidvalue,string order,string orderdirection,string whe) sqlparameter paras = new sqlparameter(tablename, table), new sqlparameter(colname,colname), new sqlparameter(keyid
