- 博客(2)
- 资源 (2)
- 收藏
- 关注
RSS订阅原创 HttpContext.Current.Request.ServerVariables
Request.ServerVariables("Url")返回服务器地址Value 0: /WebSite1/Default.aspx Request.ServerVariables("Path_Info")客户端提供的路径信息Value 0: /WebSite1/Default.aspx Request.ServerVariables("Appl_Physical_Path"...
2017-01-12 13:37:00
647
原创 Bootstrap实现弹出框和提示框效果代码
一、Bootstrap弹出框使用过JQuery UI应该知道，它里面有一个dialog的弹出框组件，功能也很丰富。与jQuery UI的dialog类似，Bootstrap里面也内置了弹出框组件。打开bootstrap 文档可以看到它的dialog是直接嵌入到bootstrap.js和bootstrap.css里面的，也就是说，只要我们引入了bootstrap的文件，就可以直接使用它的d...
2017-01-11 10:05:00
1015
转载经典AndersLiu,经典登录
转载经典AndersLiu,经典登录
转载经典AndersLiu,经典登录
转载经典AndersLiu,经典登录
转载经典AndersLiu,经典登录
2009-05-08
sql 2000自定义分页存储过程
CREATE PROCEDURE [dbo].[pro_Pager]
@TableName varchar(50),
@Condition nvarchar(500),
@Fields varchar(500),
@CurrentPage int,
@PageSize int,
@OrderField varchar(100),
@OrderType varchar(4)
AS
set nocount on
declare @SQL nvarchar(2000)
if @OrderType = 'Desc'
begin
if @Condition = 'None'
begin
if @CurrentPage = 1
begin
set @SQL = 'select top ' + Cast(@PageSize as varchar) + ' ' + @Fields + ' from ' + @TableName + ' order by ' + @OrderField + ' desc'
end
if @CurrentPage > 1
begin
set @SQL = 'select top ' + Cast(@PageSize as varchar) + ' ' + @Fields + ' from ' + @TableName + ' where ' + @OrderField + '<(select min(' + @OrderField + ') from (select top ' + Cast(@PageSize*(@CurrentPage-1) as varchar) + ' ' + @OrderField + ' from ' + @TableName + ' order by ' + @OrderField + ' desc) temp) order by ' + @OrderField + ' desc'
end
end
else
begin
if @CurrentPage = 1
begin
set @SQL = 'select top ' + Cast(@PageSize as varchar) + ' ' + @Fields + ' from ' + @TableName + ' ' + @Condition + ' order by ' + @OrderField + ' desc'
end
if @CurrentPage > 1
begin
set @SQL = 'select top ' + Cast(@PageSize as varchar) + ' ' + @Fields + ' from ' + @TableName + ' ' + @Condition + ' and ' + @OrderField + '<(select min(' + @OrderField + ') from (select top ' + Cast(@PageSize*(@CurrentPage-1) as varchar) + ' ' + @OrderField + ' from ' + @TableName + ' ' + @Condition + ' order by ' + @OrderField + ' desc) temp) order by ' + @OrderField + ' desc'
end
end
end
else
begin
if @Condition = 'None'
begin
if @CurrentPage = 1
begin
set @SQL = 'select top ' + Cast(@PageSize as varchar) + ' ' + @Fields + ' from ' + @TableName + ' order by ' + @OrderField + ' asc'
end
if @CurrentPage > 1
begin
set @SQL = 'select top ' + Cast(@PageSize as varchar) + ' ' + @Fields + ' from ' + @TableName + ' where ' + @OrderField + ' > (select max(' + @OrderField + ') from (select top ' + Cast(@PageSize*(@CurrentPage-1) as varchar) + ' ' + @OrderField + ' from ' + @TableName + ' order by ' + @OrderField + ' asc) temp) order by ' + @OrderField + ' asc'
end
end
else
begin
if @CurrentPage = 1
begin
set @SQL = 'select top ' + Cast(@PageSize as varchar) + ' ' + @Fields + ' from ' + @TableName + ' ' + @Condition + ' order by ' + @OrderField + ' asc'
end
if @CurrentPage > 1
begin
set @SQL = 'select top ' + Cast(@PageSize as varchar) + ' ' + @Fields + ' from ' + @TableName + ' ' + @Condition + ' and ' + @OrderField + ' > (select max(' + @OrderField + ') from (select top ' + Cast(@PageSize*(@CurrentPage-1) as varchar) + ' ' + @OrderField + ' from ' + @TableName + ' ' + @Condition + ' order by ' + @OrderField + ' asc] temp) order by ' + @OrderField + ' asc'
end
end
end
exec sp_executesql @SQL
2008-12-04
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人