<%@ 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)&"
"&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 %>