%@ Language=VBScript %>
<%
option explicit
response.buffer = true
'**********************************************************************************************
'*版权所有 所有权利保留 不发放未经授权的许可
'*功能:查看一组已存在的记录
'*编码:陶天林编写的自动程序
'*日期:2002-6-27
'*更新记录
'* 创建此代码 2002-06-27 陶天林编写的自动程序
'* 代码精简与优化 2004-05-01 陈泽军整理,联众科技专用代码
'* 1.过滤产品页面
'* 2.采用相对路径,在修改一级目录后无需修改代码
'* 修改代码支持MsSQL 2010-08-11 陈泽军
'*用途:显示一组页面目录
'**********************************************************************************************
%>
<%
' on error resume next
const MaxPerPage=10 '每页显示记录数
Dim vInfoName,vView,strQuery,strQuery_like,intPage,vPkValue,vProTitle
vInfoName=trim(request.QueryString("InfoName"))
vView=trim(request.QueryString("View"))
intPage=trim(request.QueryString("Page"))
vPkValue=trim(Request.QueryString("PkValue"))
vProTitle=trim(Request.QueryString("ProTitle"))
If vView<>"" and IsNumeric(vView) Then
If int(vView)>3 Then
vView=1
End If
Else
vView=1
End If
If vProTitle<>"" Then
strQuery_like=" and ProductType like '%"&vProTitle&"%'"
Else
strQuery_like=""
End If
If vView=3 Then
If IsSqlDataBase = 1 Then
strQuery=strQuery_like&" and UserName='" & vSiteName & "' and cast(Comment as varchar)='###"&mDownloadCenterCaption&"###' and PageName='" & vInfoName & "' and Enabled > 0 order by Enabled desc"
Else
strQuery=strQuery_like&" and UserName='" & vSiteName & "' and Comment='###"&mDownloadCenterCaption&"###' and PageName='" & vInfoName & "' and Enabled > 0 order by Enabled desc"
End If
Else
if ucase(vInfoName)="ALL" or vInfoName="" then
strQuery=strQuery_like&" and UserName='" & vSiteName & "' and Enabled > 0 order by Enabled desc"
else
strQuery=strQuery_like&" and UserName='" & vSiteName & "' and PageName='" & vInfoName & "' and Enabled > 0 order by Enabled desc"
end if
End If
if intPage="" then
If vPkValue<>"" Then
intPage=Check_PkValue_Order '判断当前记录所在的页
Else
intPage=1
End If
end if
response.write ShowInfo
if err then
response.write "Show Data Error0"
response.end
end if
function ShowInfo
on error resume next
LoadTemplate server.mappath(vTemplatePath) & "/Default.htm", "All"
mShowHeader vSiteName
mShowNavigationBottom vSiteName,"no" '由于是翻页页面,所以放在ShowInfoResult函数前
ShowInfoResult
mShowFooter vSiteName
Parse "All",false
ShowInfo=PrintVar("All")
UnloadTemplate
if err then
response.write "Show Data Error1"
response.end
end if
End Function
function ShowInfoResult
' on error resume next
LoadTemplate server.mappath(vTemplatePath) & "/Info.htm", "Main"
LoadTemplate server.mappath(vTemplatePath) & "/PageTurn.htm","PageTurn"
SetVar "SiteName",vSiteName
SetVar "TemplatePath",vTemplatePath
dim TotalPut,TotalPages '总记录数,最大页数
dim NextPage,PrevPage
dim j,k
dim objPage_Permit_View
set objPage_Permit_View=new clsPage_Permit_View
objPage_Permit_View.GetAllByQuery strQuery
if objPage_Permit_View.eof then
SetVar "PageTurnBody",""
SetVar "InfoList",""
else
TotalPut=objPage_Permit_View.recordcount
TotalPages=TotalPut\MaxPerPage
if TotalPut mod MaxPerPage>0 then TotalPages=TotalPages+1
'根据 CurrentPage 和 TotalPages 算出 NextPage 和 PrevPage
Dim NavigationTemp
if intPage=1 or intPage=0 then
PrevPage=1
NavigationTemp="第一页 "
NavigationTemp=NavigationTemp&"上一页 "
else
PrevPage=intPage-1
NavigationTemp="第一页 "
NavigationTemp=NavigationTemp&"上一页 "
end if
NextPage=intPage+1
if NextPage>TotalPages then
NavigationTemp=NavigationTemp&"下一页 "
NavigationTemp=NavigationTemp&"最末页"
Else
NavigationTemp=NavigationTemp&"下一页 "
NavigationTemp=NavigationTemp&"最末页"
end if
SetVar "TotalPut",TotalPut
SetVar "TotalPages",TotalPages
SetVar "CurrentPage",intPage
SetVar "NavigationTemp",NavigationTemp
Parse "NaviTop",false
Parse "Navigator",false
if (intPage-1)*MaxPerPage1 then
objPage_Permit_View.move (intPage-1)*MaxPerPage
end if
'++++++++++++++++++判断显示的页面类型+++++++++++++++
If vPkValue="" or isNull(vPkValue) Then
vPkValue=objPage_Permit_View.PermitID
End If
'++++++++++++++++++++++++++++++++++++++++++++++++++++
j=0
dim vClass
do while not objPage_Permit_View.eof
if int(gCheckNullStr(objPage_Permit_View.Enabled))>1999 and session("sitedj")<2 or int(gCheckNullStr(objPage_Permit_View.Enabled))>999 and session("sitedj")<1 then
vClass=" class='limit'"
else
vClass=" class='left'"
end if
if vPkValue=objPage_Permit_View.PermitID then
if vInfoName<>"" and ucase(vInfoName)<>"ALL" then
SetVar "PageName",vInfoName & " - " & objPage_Permit_View.Title
else
SetVar "PageName"," - " & objPage_Permit_View.Title
end if
SetVar "InfoItemTitle",GbLimitTitle(objPage_Permit_View.Title,14)
else
If instr(GbLimitTitle(objPage_Permit_View.Title,14),"...")>0 Then
SetVar "InfoItemTitle",""&GbLimitTitle(objPage_Permit_View.Title,14)&""
'response.Write vPkValue&"aaa "
Else
'response.Write vPkValue&"aaa "
SetVar "InfoItemTitle",""&GbLimitTitle(objPage_Permit_View.Title,14)&""
End If
end if
SetVar "InfoItemCreateDate",Take8BitDate(objPage_Permit_View.CreateTime)
Parse "SubItemList1",false
SetVar "SubItemList2",""
Parse "ItemList",true
j=j+1
if j>=MaxPerPage then exit do
objPage_Permit_View.movenext
loop
If vProTitle<>"" Then
SetVar "SubItemList1",""
SetVar "MoreInfo","更多>> "
Parse "SubItemList2",false
Parse "ItemList",true
SetVar "MoreInfo",""
End If
if j
"&gCheckNullStr(.Title)&"
"&gTextToHtml(.Body,.BodyType)&"
"
end if
end with
set objPage_Permit_View=nothing
if err then
UnloadTemplate
response.write "Show the content by pkvalue error"
response.end
end if
end Function
Function ShowView2ByPkValue
Dim ObjPage_Permit_View
set ObjPage_Permit_View=New ClsPage_Permit_View
With ObjPage_Permit_View
.GetOneByPkValue vPkValue
'response.Write(.recordcount&" ") '测试用
IF Not .Eof Then
'response.Write(vProductsTrade&" ") '测试用
SetVar "Body","
"&gCheckNullStr(.Title)&"
"
Else
SetVar "Body","参数非法!"
End If
End With
Set ObjPage_Permit_View=Nothing
if err then
UnloadTemplate
response.write "Show the curve by pkvalue error"
response.end
end if
End Function
Function ShowView3ByPkValue
on error resume next
LoadTemplate server.mappath(vTemplatePath) & "/Services.htm", "Body"
dim objPage_Permit_View
set objPage_Permit_View=new clsPage_Permit_View
with objPage_Permit_View
.GetOneByPkValue vPkValue
if .eof then
SetVar "FormDownloadBody",""
else
SetVar "Title",gCheckNullStr(.Title)
SetVar "CreateDate",gCheckNullStr(.CreateTime)
'-----------------------------------------------------------------
ShowUploadLinkInfo gCheckNullStr(.StrPk)
'-----------------------------------------------------------------
SetVar "DownloadBody",gTextToHtml(.Body,.BodyType)
if err then
set objPage_Permit_View=nothing
UnloadTemplate
response.write "Show the News Error"
response.end
end if
end if
end with
set objPage_Permit_View=nothing
Parse "Body",false
if err then
UnloadTemplate
response.write "Show the service by pkvalue Error"
response.end
end if
End Function
Function ShowUploadLinkInfo(vStrPk)
on error resume next
dim objUpload_LinkInfo
set objUpload_LinkInfo=new clsUpload_LinkInfo
with objUpload_LinkInfo
.GetAllByAdvQuery "Select FileId From GB_Upload_LinkInfo Where StrPk='"&vStrPk&"'"
if .eof then
SetVar "DownloadFileInfo",""
else
'-----------------------------------------------------------------
ShowUploadFileInfo gCheckNullStr(.FileId)
'-----------------------------------------------------------------
end if
end with
set objUpload_LinkInfo=nothing
end Function
Function ShowUploadFileInfo(vFileId)
on error resume next
dim objUpload_FileInfo,vFileSize
set objUpload_FileInfo=new clsUpload_FileInfo
with objUpload_FileInfo
.GetOneByPkValue vFileId
if Not .eof then
vFileSize=int(gCheckNullStr(.FileSize))
if vFileSize=0 then
SetVar "FileSize","0 字节"
else
if vFileSize<1000 then
SetVar "FileSize",vFileSize&" 字节 ("&vFileSize&" 字节)"
else
if vFileSize<1024 then
SetVar "FileSize",vFileSize&" 字节 ("&int(vFileSize/1000)&","&right(vFileSize,3)&" 字节)"
else
if vFileSize<102400 then
SetVar "FileSize",left((int(vFileSize*100/1024)*10+1)/1000,4)&" KB ("&int(vFileSize/1000)&","&right(vFileSize,3)&" 字节)"
else
if vFileSize<1000000 then
SetVar "FileSize",int(vFileSize/1024)&" KB ("&int(vFileSize/1000)&","&right(vFileSize,3)&" 字节)"
else
if vFileSize<1024000 then
SetVar "FileSize",int(vFileSize/1024)&" KB ("&int(vFileSize/1000000)&","&right(int(vFileSize/1000),3)&","&right(vFileSize,3)&" 字节)"
else
if vFileSize<1048576 then
SetVar "FileSize","0"&left((int(vFileSize*100/1024/1024)*10+1)/1000,3)&" MB ("&int(vFileSize/1000000)&","&right(int(vFileSize/1000),3)&","&right(vFileSize,3)&" 字节)"
else
if vFileSize<104857600 then
SetVar "FileSize",left((int(vFileSize*100/1024/1024)*10+1)/1000,4)&" MB ("&int(vFileSize/1000000)&","&right(int(vFileSize/1000),3)&","&right(vFileSize,3)&" 字节)"
else
if vFileSize<1000000000 then
SetVar "FileSize",int(vFileSize/1024/1024)&" MB ("&int(vFileSize/1000000)&","&right(int(vFileSize/1000),3)&","&right(vFileSize,3)&" 字节)"
else
SetVar "FileSize",vFileSize&" 字节"
end if
end if
end if
end if
end if
end if
end if
end if
end if
SetVar "UpdateTime",FormatDateTime(.UploadTime,2)
SetVar "FilePath","../../Base/AdvUpload/DownloadFile.asp?FID="&vFileId&"&PkValue="&vPkValue
SetVar "DownloadAddress",gCheckNullStr(.FileName)
'-----------------------------------------------------------------
ShowUploadDownInfo gCheckNullStr(.FileName)
'-----------------------------------------------------------------
end if
end with
set objUpload_FileInfo=nothing
end Function
Function ShowUploadDownInfo(vFileTitle)
on error resume next
dim objUpload_DownInfo
set objUpload_DownInfo=new clsUpload_DownInfo
with objUpload_DownInfo
.GetAllByAdvQuery "Select DownTime From GB_Upload_DownInfo Where Comment='"&vFileTitle&"' Order by DownTime Desc"
if .eof then
SetVar "DownloadCount",0
SetVar "LastDownloadTime","None Download"
else
SetVar "DownloadCount",.RecordCount
SetVar "LastDownloadTime",gCheckNullStr(.DownTime)
end if
end with
set objUpload_DownInfo=nothing
end Function
Function Check_PkValue_Order
dim objPage_Permit_View
set objPage_Permit_View=new clsPage_Permit_View
objPage_Permit_View.GetAllByQuery strQuery
Dim k
K=1
Do While Not objPage_Permit_View.eof
If objPage_Permit_View.PermitID=vPkValue Then
If (K mod MaxPerPage)=0 Then
Check_PkValue_Order=K\MaxPerPage
Else
Check_PkValue_Order=(K\MaxPerPage)+1
End If
Exit Do'当找到对应的PermitID时退出循环并返回页值
Else
K=K+1
End IF
objPage_Permit_View.MoveNext
Loop
set objPage_Permit_View=nothing
End Function
'=========================================
'对页面权限进行检测结束并显示相关提示
'=========================================
Function CheckPermitByPkValue
dim objPage_Permit_View
set objPage_Permit_View=new clsPage_Permit_View
with objPage_Permit_View
.GetOneByPkValue vPkValue
If .eof Then
SetVar "Body","
对不起!
没有找到相关内容
"
Else
If int(gCheckNullStr(.Enabled))>1999 and session("sitedj")<2 Then
CheckPermitByPkValue=false
SetVar "Body","
对不起!您的权限不够。
至少要高级用户登录后,才能浏览本页面。
"
ElseIf int(gCheckNullStr(.Enabled))>999 and session("sitedj")<1 Then
SetVar "Body","
对不起!您的权限不够。
至少要普通用户登录后,才能浏览本页面。
"
CheckPermitByPkValue=false
Else
CheckPermitByPkValue=true
End If
End If
end with
set objPage_Permit_View=nothing
end Function
%>