![]() | |||||||||
| |||||||||
![]() |
温馨提示:本站已开通WAP服务,若您的手机支持WAP功能,可以使用手机访问:http://www.chinaonco.net/wap/index.asp
<% Else Response.ContentType = "text/vnd.wap.wml; charset=utf-8" Call main End If Set XmlDoc = Nothing Call CloseConn '类私有变量 Private PhoneNumber, PhoneType, WapDomain, strHTML, Source, SiteLogo Sub main() strHTML = "" & vbCrLf strHTML = strHTML & "" & vbCrLf strHTML = strHTML & "" & XmlText("Wap", "CloseEd", "本站已关闭WAP功能!") & "
" & vbCrLf strHTML = strHTML & "" & XmlText("BaseText", "ChannelErr", "找不到频道!") Else strHTML = strHTML & "
" & SiteLogo & vbCrLf
Do While Not rsChannel.EOF
If rsChannel("ModuleType") = 1 Or rsChannel("ModuleType") = 2 Or rsChannel("ModuleType") = 3 Or rsChannel("ModuleType") = 5 Then
If rsChannel("ModuleType") = 5 Then
strHTML = strHTML & "
" & rsChannel("ChannelName") & "" & vbCrLf
Else
strHTML = strHTML & "
" & rsChannel("ChannelName") & "" & vbCrLf
End If
End If
rsChannel.MoveNext
Loop
If ShowWapManage = True Then strHTML = strHTML & "
-----
" & XmlText("Wap", "ManageLogin", "-管理登录-") & "" & vbCrLf
End If
strHTML = strHTML & "
" & XmlText("Wap", "News", "-最新更新-") & vbCrLf
Set rsChannel = Conn.Execute("select ChannelName,ChannelDir,ModuleType,HitsOfHot,UploadDir from PE_Channel where ChannelID=" & iChannelID & " and Disabled = " & PE_False & " and ChannelType<2 order by OrderID")
ChannelName = rsChannel("ChannelName")
ChannelDir = rsChannel("ChannelDir")
ModuleType = rsChannel("ModuleType")
HitsOfHot = rsChannel("HitsOfHot")
UploadDir = rsChannel("UploadDir")
rsChannel.Close
Set rsChannel = Nothing
Select Case ModuleType
Case 1
sqlArticle = "select top 12 A.ArticleID,A.ChannelID,A.ClassID,A.Title,A.Hits,A.UpdateTime,A.Elite,A.Status,A.IncludePic,A.LinkUrl,A.Deleted,C.ClassPurview from PE_Article A inner join PE_Class C on A.ClassID=C.ClassID Where A.ChannelID=" & iChannelID & " and C.ClassPurview<2"
If iClassID <> 0 Then sqlArticle = sqlArticle & " and A.ClassID=" & iClassID
sqlArticle = sqlArticle & " and A.Status=3 and A.Deleted=" & PE_False
If iHot = 1 Then
sqlArticle = sqlArticle & " order by A.Hits Desc"
ElseIf iElite = 1 Then
sqlArticle = sqlArticle & " order by A.Elite " & PE_OrderType & ",A.UpdateTime Desc"
Else
sqlArticle = sqlArticle & " order by A.UpdateTime Desc"
End If
Set rsArticle = Conn.Execute(sqlArticle)
If Not (rsArticle.BOF And rsArticle.EOF) Then
Do While Not rsArticle.EOF
If rsArticle(9) = "" Then
strHTML = strHTML & "
" & ReplaceText(GetSubStr(xml_nohtml(rsArticle(3)), 20, False), 2) & ""
If rsArticle(8) > 0 Then strHTML = strHTML & "-图" & vbCrLf
If rsArticle(4) > HitsOfHot Then strHTML = strHTML & "-热" & vbCrLf
If rsArticle(6) = True Then strHTML = strHTML & "-荐" & vbCrLf
End If
rsArticle.MoveNext
Loop
Else
strHTML = strHTML & "无文章" & vbCrLf
End If
rsArticle.Close
Case 2
sqlArticle = "select top 12 A.SoftID,A.ChannelID,A.ClassID,A.SoftName,A.Hits,A.UpdateTime,A.Elite,A.Status,A.Deleted,C.ClassPurview from PE_Soft A inner join PE_Class C on A.ClassID=C.ClassID Where A.ChannelID=" & iChannelID & " and C.ClassPurview<2"
If iClassID <> 0 Then sqlArticle = sqlArticle & " and A.ClassID=" & iClassID
sqlArticle = sqlArticle & " and A.Status=3 and A.Deleted=" & PE_False
If iHot = 1 Then
sqlArticle = sqlArticle & " order by A.Hits Desc"
ElseIf iElite = 1 Then
sqlArticle = sqlArticle & " order by A.Elite " & PE_OrderType & ",A.UpdateTime Desc"
Else
sqlArticle = sqlArticle & " order by A.UpdateTime Desc"
End If
Set rsArticle = Conn.Execute(sqlArticle)
If Not (rsArticle.BOF And rsArticle.EOF) Then
Do While Not rsArticle.EOF
strHTML = strHTML & "
" & GetSubStr(xml_nohtml(rsArticle(3)), 20, False) & ""
If rsArticle(6) = True Then strHTML = strHTML & "-荐" & vbCrLf
If rsArticle(4) > HitsOfHot Then strHTML = strHTML & "-热" & vbCrLf
rsArticle.MoveNext
Loop
Else
strHTML = strHTML & "无下载" & vbCrLf
End If
rsArticle.Close
Case 3
sqlArticle = "select top 12 A.PhotoID,A.ChannelID,A.ClassID,A.PhotoName,A.Hits,A.UpdateTime,A.Elite,A.Status,A.Deleted,C.ClassPurview from PE_Photo A inner join PE_Class C on A.ClassID=C.ClassID Where A.ChannelID=" & iChannelID & " and C.ClassPurview<2"
If iClassID <> 0 Then sqlArticle = sqlArticle & " and A.ClassID=" & iClassID
sqlArticle = sqlArticle & " and A.Status=3 and A.Deleted=" & PE_False
If iHot = 1 Then
sqlArticle = sqlArticle & " order by A.Hits Desc"
ElseIf iElite = 1 Then
sqlArticle = sqlArticle & " order by A.Elite " & PE_OrderType & ",A.UpdateTime Desc"
Else
sqlArticle = sqlArticle & " order by A.UpdateTime Desc"
End If
Set rsArticle = Conn.Execute(sqlArticle)
If Not (rsArticle.BOF And rsArticle.EOF) Then
Do While Not rsArticle.EOF
strHTML = strHTML & "
" & GetSubStr(xml_nohtml(rsArticle(3)), 20, False) & ""
If rsArticle(6) = True Then strHTML = strHTML & "-荐" & vbCrLf
If rsArticle(4) > HitsOfHot Then strHTML = strHTML & "-热" & vbCrLf
rsArticle.MoveNext
Loop
Else
strHTML = strHTML & "无图片" & vbCrLf
End If
rsArticle.Close
Case 5
sqlArticle = "select top 12 ProductID,ChannelID,ClassID,ProductName,IsHot,IsElite,UpdateTime,Hits,Deleted from PE_Product Where ChannelID=" & iChannelID
If iClassID <> 0 Then sqlArticle = sqlArticle & " and ClassID=" & iClassID
sqlArticle = sqlArticle & " and Deleted=" & PE_False
If iHot = 1 Then
sqlArticle = sqlArticle & " order by Hits Desc"
ElseIf iElite = 1 Then
sqlArticle = sqlArticle & " order by IsElite " & PE_OrderType & ",UpdateTime Desc"
Else
sqlArticle = sqlArticle & " order by UpdateTime Desc"
End If
Set rsArticle = Conn.Execute(sqlArticle)
If Not (rsArticle.BOF And rsArticle.EOF) Then
Do While Not rsArticle.EOF
strHTML = strHTML & "
" & GetSubStr(xml_nohtml(rsArticle(3)), 20, False) & ""
If rsArticle(4) = True Then strHTML = strHTML & "-热" & vbCrLf
If rsArticle(5) = True Then strHTML = strHTML & "-荐" & vbCrLf
rsArticle.MoveNext
Loop
Else
strHTML = strHTML & "无商品" & vbCrLf
End If
rsArticle.Close
End Select
Set rsArticle = Nothing
strHTML = strHTML & "
-子栏目-" & vbCrLf
If iClassID = 0 Then
Set rsClass = Conn.Execute("select ClassID,ClassName,Child from PE_Class where ChannelID=" & iChannelID & " and ClassType=1 and ParentID =0")
If Not (rsClass.BOF And rsClass.EOF) Then
Do While Not rsClass.EOF
strtmp = strtmp & "
[" & rsClass("ClassName") & "]" & vbCrLf
rsClass.MoveNext
Loop
End If
strtmp = strtmp & "
[首页]" & vbCrLf
Else
Set rsClass = Conn.Execute("select ClassID,ClassName,Child from PE_Class where ParentID=" & iClassID & " and ClassType=1 order by OrderID")
If rsClass.BOF And rsClass.EOF Then
strtmp = strtmp & "
[首页]" & vbCrLf
Else
Do While Not rsClass.EOF
strtmp = strtmp & "
[" & rsClass("ClassName") & "]" & vbCrLf
rsClass.MoveNext
Loop
strtmp = strtmp & "
[首页]" & vbCrLf
End If
End If
rsClass.Close
Set rsClass = Nothing
GetChildClass = strtmp & "
无此文章!
" & vbCrLf Else sqlArticle = "select * from PE_Article Where ArticleID=" & iArticleID & " and Status=3 and Deleted=" & PE_False & " and InfoPoint=0" Set rsArticle = Conn.Execute(sqlArticle) If rsArticle.BOF And rsArticle.EOF Then strHTML = strHTML & "收费文章,请登录网站浏览!" & vbCrLf
strHTML = strHTML & "
返回
" & getpage(iChannelID, iArticleID, ReplaceText(Replace(xml_nohtml(rsArticle("Content")), "[NextPage]", ""), 1), iPage) & vbCrLf
If EnableWapPl = True Then strHTML = strHTML & "
评论" & vbCrLf
If ShowWapAppendix = True Then
If rsArticle("IncludePic") > 0 Then strHTML = strHTML & "
图片" & vbCrLf
End If
strHTML = strHTML & "
返回
无此下载!
" & vbCrLf Else sqlSoft = "select * from PE_Soft Where SoftID=" & iSoftID & " and Status=3 and Deleted=" & PE_False & " and InfoPoint=0" Set rsSoft = Conn.Execute(sqlSoft) If rsSoft.BOF And rsSoft.EOF Then strHTML = strHTML & "收费软件,请登录网站下载!
" & vbCrLf Else strHTML = strHTML & "名称:" & GetSubStr2(xml_nohtml(rsSoft("SoftName")), iSize) & "
" & vbCrLf
If Not IsNull(rsSoft("SoftVersion")) Then strHTML = strHTML & "版本:" & GetSubStr2(xml_nohtml(rsSoft("SoftVersion")), iSize) & "
" & vbCrLf
If Not IsNull(rsSoft("SoftIntro")) Then strHTML = strHTML & "简介:" & GetSubStr2(xml_nohtml(rsSoft("SoftIntro")), 80) & "
" & vbCrLf
strHTML = strHTML & GetDownloadUrlList(rsSoft("DownloadUrl"))
If EnableWapPl = True Then strHTML = strHTML & "评论" & vbCrLf
strHTML = strHTML & "
返回
无此图片!
" & vbCrLf Else sqlPhoto = "select * from PE_Photo Where PhotoID=" & iPhotoID & " and Status=3 and Deleted=" & PE_False & " and InfoPoint=0" Set rsPhoto = Conn.Execute(sqlPhoto) If rsPhoto.BOF And rsPhoto.EOF Then strHTML = strHTML & "收费图片,请登录网站浏览!
" & vbCrLf Else strHTML = strHTML & "" & GetSubStr2(xml_nohtml(rsPhoto("PhotoName")), iSize) & "
" & vbCrLf
If ShowWapAppendix = True Then
If rsPhoto("PhotoThumb") > "" Then
If Left(rsPhoto("PhotoThumb"), 4) = "http" Then
strHTML = strHTML & "
" & vbCrLf
Else
strHTML = strHTML & "
" & vbCrLf
End If
End If
End If
If EnableWapPl = True Then strHTML = strHTML & "评论" & vbCrLf
strHTML = strHTML & "
返回
无此商品!
" & vbCrLf Else sqlProduct = "select * from PE_Product Where ProductID=" & iProductID & " and EnableSale=" & PE_True & " and Deleted=" & PE_False & " and Stocks>0" Set rsProduct = Conn.Execute(sqlProduct) If rsProduct.BOF And rsProduct.EOF Then strHTML = strHTML & "无此商品!
" & vbCrLf Else strHTML = strHTML & "名称:" & GetSubStr2(xml_nohtml(rsProduct("ProductName")), iSize) & "
" & vbCrLf
strHTML = strHTML & "厂商:" & GetSubStr2(xml_nohtml(rsProduct("ProducerName")), iSize) & "
" & vbCrLf
strHTML = strHTML & "品牌:" & GetSubStr2(xml_nohtml(rsProduct("TrademarkName")), iSize) & "
" & vbCrLf
strHTML = strHTML & "原价:" & rsProduct("Price_Original") & "
" & vbCrLf
strHTML = strHTML & "现价:" & rsProduct("Price") & "
" & vbCrLf
If Not IsNull(rsProduct("ProductIntro")) Then strHTML = strHTML & "简介:" & GetSubStr2(xml_nohtml(rsProduct("ProductIntro")), 160) & "
" & vbCrLf
If ShowWapAppendix = True Then
If rsProduct("ProductThumb") > "" Then
If Left(rsProduct("ProductThumb"), 4) = "http" Then
strHTML = strHTML & "
" & vbCrLf
Else
strHTML = strHTML & "
" & vbCrLf
End If
End If
End If
If EnableWapPl = True Then strHTML = strHTML & "评论" & vbCrLf
If ShowWapShop = True Then strHTML = strHTML & "
订购" & vbCrLf
strHTML = strHTML & "
返回
无此对象!
" & vbCrLf Else If iType = 0 Then sqlComment = "select top 10 * from PE_Comment where InfoID=" & iID & " and Passed=" & PE_True & " order by WriteTime desc" Set rsComment = Conn.Execute(sqlComment) If rsComment.BOF And rsComment.EOF Then strHTML = strHTML & "没有评论!
" & vbCrLf
strHTML = strHTML & "发表
"
Do While Not rsComment.EOF
strHTML = strHTML & xml_nohtml(rsComment("UserName")) & "的评论:
" & vbCrLf
strHTML = strHTML & GetSubStr2(xml_nohtml(rsComment("Content")), 40) & "
" & vbCrLf
strHTML = strHTML & FormatDateTime(rsComment("WriteTime"), 2) & "
" & vbCrLf
rsComment.MoveNext
Loop
strHTML = strHTML & "发表
本栏禁止评论!
" & vbCrLf Else If rsClass("EnableComment") = True Then strHTML = strHTML & "您的姓名:
" & vbCrLf
strHTML = strHTML & "
" & vbCrLf
strHTML = strHTML & "评论:
" & vbCrLf
strHTML = strHTML & "" & vbCrLf
If rsClass("CheckComment") = True Then
strHTML = strHTML & "提交
本栏禁止评论
" & vbCrLf End If End If rsClass.Close Set rsClass = Nothing End If End If strHTML = strHTML & "请填写内容!" & vbCrLf Else sqlComment = "Select * from PE_Comment" Set rsComment = Server.CreateObject("Adodb.RecordSet") rsComment.Open sqlComment, Conn, 1, 3 rsComment.addnew rsComment("ModuleType") = iModuleType rsComment("InfoID") = iID rsComment("UserType") = 0 rsComment("UserName") = UTF2GB(iName) rsComment("Sex") = 0 rsComment("WriteTime") = Now() rsComment("Score") = 3 rsComment("Content") = UTF2GB(iComcont) If iCheck = 1 Then rsComment("Passed") = True Else rsComment("Passed") = False End If rsComment.Update rsComment.Close Set rsComment = Nothing strHTML = strHTML & "
评论发表成功!" & vbCrLf
End If
strHTML = strHTML & "
返回
无图片!" & vbCrLf
strHTML = strHTML & "
返回
" & vbCrLf
Set rsFJ = Conn.Execute("select DefaultPicUrl from PE_Article Where ArticleID=" & iID)
If Left(LCase(rsFJ("DefaultPicUrl")), 4) = "http" Then
strHTML = strHTML & "" & vbCrLf
Else
strHTML = strHTML & "
" & vbCrLf
End If
rsFJ.Close
Set rsFJ = Nothing
strHTML = strHTML & "
返回
用户名:
" & vbCrLf
strHTML = strHTML & "
" & vbCrLf
strHTML = strHTML & "密码:
" & vbCrLf
strHTML = strHTML & "
" & vbCrLf
strHTML = strHTML & "提交
用户名或密码错!
" & iUser & MD5(iPass, 16) & vbCrLf Else strHTML = strHTML & "" & rsUser("UserName") & "您好,您在本站的交易码是:
" & rsUser("CheckNum") & "
继续
参数错!
" & vbCrLf
Else
strHTML = strHTML & "
订购数量:
" & vbCrLf
strHTML = strHTML & "
" & vbCrLf
strHTML = strHTML & "您的交易码:
" & vbCrLf
strHTML = strHTML & "
" & vbCrLf
strHTML = strHTML & "提交
" & vbCrLf
strHTML = strHTML & "-----
" & vbCrLf
strHTML = strHTML & "忘记交易码
参数错!
" & vbCrLf
Else
If iNumber = 0 Or ishuliang = "" Then
strHTML = strHTML & "
请填写内容!" & vbCrLf Else Set rsUser = Conn.Execute("select U.UserID,U.UserName,U.IsLocked,U.CheckNum,C.Address,C.Email,C.ZipCode,C.Mobile,C.OfficePhone,C.HomePhone,U.ClientID from PE_User U inner join PE_Contacter C on U.ContacterID=C.ContacterID Where U.CheckNum=" & iNumber) If rsUser.BOF And rsUser.EOF Then strHTML = strHTML & "
交易号码错!" & vbCrLf Else If rsUser(2) = True Then strHTML = strHTML & "
您已被锁定无法完成交易!" & vbCrLf ElseIf IsNull(rsUser(4)) Or IsNull(rsUser(5)) Or IsNull(rsUser(6)) Then strHTML = strHTML & "
收货地址:" & vbCrLf
strHTML = strHTML & "
" & vbCrLf
strHTML = strHTML & "
邮政编码:" & vbCrLf
strHTML = strHTML & "
" & vbCrLf
strHTML = strHTML & "
电子邮件:" & vbCrLf
strHTML = strHTML & "
" & vbCrLf
strHTML = strHTML & "
提交
暂时无货!" & vbCrLf Else sqlOrder = "Select * from PE_OrderForm" Set rsOrder = Server.CreateObject("Adodb.RecordSet") rsOrder.Open sqlOrder, Conn, 1, 3 rsOrder.addnew rsOrder("OrderFormID") = OrderFormID rsOrder("OrderFormNum") = OrderFormNum rsOrder("UserName") = rsUser(1) rsOrder("ClientID") = rsUser(10) If iaddress = "none" Then rsOrder("Address") = rsUser(4) Else rsOrder("Address") = ConvChinese(iaddress) End If If izipcode = "none" Then rsOrder("ZipCode") = rsUser(6) Else rsOrder("ZipCode") = izipcode End If If PhoneNumber = "" Then rsOrder("Mobile") = rsUser(7) Else rsOrder("Mobile") = PhoneNumber End If If rsUser(8) = "" Then rsOrder("Phone") = rsUser(9) Else rsOrder("Phone") = rsUser(8) End If If iemail = "none" Then rsOrder("Email") = rsUser(5) Else rsOrder("Email") = ConvChinese(iemail) End If rsOrder("PaymentType") = 1 rsOrder("DeliverType") = 3 rsOrder("NeedInvoice") = False rsOrder("InvoiceContent") = "发票抬头:" rsOrder("Invoiced") = False rsOrder("Remark") = "本订单通过手机订购,请尽快联系客户" rsOrder("MoneyTotal") = rsProduct("Price") * ishuliang rsOrder("MoneyGoods") = 0 rsOrder("PresentMoney") = 0 rsOrder("PresentExp") = 0 rsOrder("MoneyReceipt") = 0 rsOrder("BeginDate") = FormatDateTime(Date, 2) rsOrder("InputTime") = Now() rsOrder("Status") = 1 rsOrder("DeliverStatus") = 1 rsOrder("EnableDownload") = False rsOrder("Discount_Payment") = rsProduct("Discount") rsOrder("Charge_Deliver") = 1 rsOrder.Update rsOrder.Close rsOrder.Open "select top 1 * from PE_OrderFormItem", Conn, 1, 3 '添加进订单详细表中 rsOrder.addnew rsOrder("ItemID") = GetItemID() rsOrder("OrderFormID") = OrderFormID rsOrder("ProductID") = rsProduct("ProductID") rsOrder("SaleType") = 1 rsOrder("Price_Original") = rsProduct("Price_Original") rsOrder("Price") = rsProduct("Price") rsOrder("TruePrice") = rsProduct("Price") rsOrder("Amount") = ishuliang rsOrder("Subtotal") = rsProduct("Price") * ishuliang rsOrder("Remark") = "手机订购" rsOrder("BeginDate") = FormatDateTime(Date, 2) rsOrder("ServiceTerm") = rsProduct("ServiceTerm") rsOrder("PresentExp") = rsProduct("PresentExp") rsOrder.Update rsOrder.Close Set rsOrder = Nothing strHTML = strHTML & "
成功!订单编号:
" & vbCrLf
strHTML = strHTML & OrderFormNum & vbCrLf
End If
rsProduct.Close
Set rsProduct = Nothing
End If
End If
rsUser.Close
Set rsUser = Nothing
End If
strHTML = strHTML & "
返回
用户名:
" & vbCrLf
strHTML = strHTML & "
" & vbCrLf
strHTML = strHTML & "密码:
" & vbCrLf
strHTML = strHTML & "
" & vbCrLf
strHTML = strHTML & "提交
权限不足,请登录网站管理!" & vbCrLf Else strHTML = strHTML & "
" & UTF2GB(iUsername) & "您好:" & vbCrLf
sqlChannel = "select ChannelID,OrderID,ChannelName,ChannelShortName,ChannelDir,ModuleType,Disabled from PE_Channel where Disabled = " & PE_False & " order by OrderID"
Set rsChannel = Conn.Execute(sqlChannel)
Do While Not rsChannel.EOF
If rsChannel("ModuleType") > 0 And rsChannel("ModuleType") < 6 Then
strHTML = strHTML & "
" & rsChannel("ChannelShortName") & "管理" & vbCrLf
End If
rsChannel.MoveNext
Loop
rsChannel.Close
Set rsChannel = Nothing
End If
strHTML = strHTML & "
-----
退出管理
权限不足,请登录网站管理!" & vbCrLf Else sqlChannel = "select ChannelID,OrderID,ModuleType,Disabled from PE_Channel where ChannelID=" & iChannelID & " and Disabled = " & PE_False & " order by OrderID" Set rsChannel = Conn.Execute(sqlChannel) If rsChannel.BOF And rsChannel.EOF Then strHTML = strHTML & "
找不到频道!" Else ModuleType = rsChannel("ModuleType") strHTML = strHTML & "
待审列表:"
Select Case ModuleType
Case 1
sqlArticle = "select ArticleID,ChannelID,Title,Status from PE_Article Where ChannelID=" & iChannelID & " and Status=0 order by UpdateTime desc"
Set rsArticle = Conn.Execute(sqlArticle)
If Not (rsArticle.BOF And rsArticle.EOF) Then
Do While Not rsArticle.EOF
strHTML = strHTML & "
" & xml_nohtml(rsArticle("Title")) & ""
rsArticle.MoveNext
Loop
Else
strHTML = strHTML & "
无未审核文章" & vbCrLf
End If
Case 2
sqlArticle = "select SoftID,ChannelID,SoftName,Status from PE_Soft Where ChannelID=" & iChannelID & " and Status=0 order by UpdateTime desc"
Set rsArticle = Conn.Execute(sqlArticle)
If Not (rsArticle.BOF And rsArticle.EOF) Then
Do While Not rsArticle.EOF
strHTML = strHTML & "
" & xml_nohtml(rsArticle("SoftName")) & ""
rsArticle.MoveNext
Loop
Else
strHTML = strHTML & "
无未审核软件" & vbCrLf
End If
Case 3
sqlArticle = "select PhotoID,ChannelID,PhotoName,Status from PE_Photo Where ChannelID=" & iChannelID & " and Status=0 order by UpdateTime desc"
Set rsArticle = Conn.Execute(sqlArticle)
If Not (rsArticle.BOF And rsArticle.EOF) Then
Do While Not rsArticle.EOF
strHTML = strHTML & "
" & xml_nohtml(rsArticle("PhotoName")) & ""
rsArticle.MoveNext
Loop
Else
strHTML = strHTML & "
无未审核图片" & vbCrLf
End If
Case 4
sqlArticle = "select top 20 * from PE_GuestBook Where GuestIsPassed=" & PE_False & " order by GuestDatetime desc"
Set rsArticle = Conn.Execute(sqlArticle)
If Not (rsArticle.BOF And rsArticle.EOF) Then
Do While Not rsArticle.EOF
strHTML = strHTML & "
" & xml_nohtml(rsArticle("GuestTitle")) & ""
rsArticle.MoveNext
Loop
Else
strHTML = strHTML & "
无未审核留言" & vbCrLf
End If
Case 5
sqlArticle = "select ProductID,ChannelID,ProductName,EnableSale from PE_Product Where ChannelID=" & iChannelID & " and EnableSale=" & PE_False & " order by UpdateTime desc"
Set rsArticle = Conn.Execute(sqlArticle)
If Not (rsArticle.BOF And rsArticle.EOF) Then
Do While Not rsArticle.EOF
strHTML = strHTML & "
" & xml_nohtml(rsArticle("ProductName")) & ""
rsArticle.MoveNext
Loop
Else
strHTML = strHTML & "
无停止销售商品" & vbCrLf
End If
End Select
rsArticle.Close
Set rsArticle = Nothing
End If
rsChannel.Close
Set rsChannel = Nothing
End If
strHTML = strHTML & "
-----
退出管理
您不是本站超管,请登录网站管理!" & vbCrLf
strHTML = strHTML & "
-----
退出管理
您不是本站超管,请登录网站管理!" & vbCrLf
strHTML = strHTML & "
-----
退出管理
您不是本站超管,请登录网站管理!" & vbCrLf
strHTML = strHTML & "
-----
退出管理
您不是本站超管,请登录网站管理!" & vbCrLf
strHTML = strHTML & "
-----
退出管理
您不是本站超管,请登录网站管理!" & vbCrLf
strHTML = strHTML & "
-----
退出管理
(" & i + 1 & "/" & PageAll & ")" If CInt(i) < CInt(PageAll) - 1 Then textmp = textmp & "
下页" End If If CInt(i) > 0 Then textmp = textmp & "
上页" End If textmp = textmp & "
返回列表" & vbCrLf End If getpage = textmp End Function '************************************************** '函数名:UTF2GB '作 用:将UTF-8转换为GB2312码 '************************************************** Function UTF2GB(ByVal UTFStr) Dim Dig, GBStr For Dig = 1 To Len(UTFStr) If Mid(UTFStr, Dig, 1) = "%" Then If Len(UTFStr) >= Dig + 8 Then GBStr = GBStr & ConvChinese(Mid(UTFStr, Dig, 9)) Dig = Dig + 8 Else GBStr = GBStr & Mid(UTFStr, Dig, 1) End If Else GBStr = GBStr & Mid(UTFStr, Dig, 1) End If Next UTF2GB = GBStr End Function Function ConvChinese(ByVal x) Dim a, i, j, DigS, unicode a = Split(Mid(x, 2), "%") i = 0 j = 0 For i = 0 To UBound(a) a(i) = c16to2(a(i)) Next For i = 0 To UBound(a) - 1 DigS = InStr(a(i), "0") unicode = "" For j = 1 To DigS - 1 If j = 1 Then a(i) = Right(a(i), Len(a(i)) - DigS) unicode = unicode & a(i) Else i = i + 1 a(i) = Right(a(i), Len(a(i)) - 2) unicode = unicode & a(i) End If Next If Len(c2to16(unicode)) = 4 Then ConvChinese = ConvChinese & ChrW(Int("&H" & c2to16(unicode))) Else ConvChinese = ConvChinese & Chr(Int("&H" & c2to16(unicode))) End If Next End Function Function c2to16(ByVal x) Dim i i = 1 For i = 1 To Len(x) Step 4 c2to16 = c2to16 & Hex(c2to10(Mid(x, i, 4))) Next End Function Function c2to10(ByVal x) Dim i c2to10 = 0 If x = "0" Then Exit Function i = 0 For i = 0 To Len(x) - 1 If Mid(x, Len(x) - i, 1) = "1" Then c2to10 = c2to10 + 2 ^ (i) Next End Function Function c16to2(ByVal x) Dim i, tempstr i = 0 For i = 1 To Len(Trim(x)) tempstr = c10to2(CInt(Int("&h" & Mid(x, i, 1)))) Do While Len(tempstr) < 4 tempstr = "0" & tempstr Loop c16to2 = c16to2 & tempstr Next End Function Function c10to2(ByVal x) Dim mysign, DigS, tempnum, i mysign = Sgn(x) x = Abs(x) DigS = 1 Do If x < 2 ^ DigS Then Exit Do Else DigS = DigS + 1 End If Loop tempnum = x i = 0 For i = DigS To 1 Step -1 If tempnum >= 2 ^ (i - 1) Then tempnum = tempnum - 2 ^ (i - 1) c10to2 = c10to2 & "1" Else c10to2 = c10to2 & "0" End If Next If mysign = -1 Then c10to2 = "-" & c10to2 End Function '************************************************** '函数名:CheckAdmin '作 用:验证管理员身份 '************************************************** Function CheckAdmin(ByVal iName, ByVal iWord) Dim rsUser, sqlUser CheckAdmin = False sqlUser = "select * from PE_Admin Where UserName='" & UTF2GB(iName) & "' and Password='" & MD5(iWord, 16) & "' and Purview=1" Set rsUser = Conn.Execute(sqlUser) If rsUser.BOF And rsUser.EOF Then CheckAdmin = False Else CheckAdmin = True End If rsUser.Close Set rsUser = Nothing End Function '************************************************** '函数名:ReplaceText '作 用:过滤非法字符串 '参 数:iText-----输入字符串 '返回值:替换后字符串 '************************************************** Function ReplaceText(iText, iType) Dim rText, rsKey, sqlKey, i, Keyrow, Keycol If PE_Cache.GetValue("Site_ReplaceText") = "" Then Set rsKey = Server.CreateObject("Adodb.RecordSet") sqlKey = "Select Source,ReplaceText,OpenType,ReplaceType,Priority from PE_KeyLink where isUse=1 and LinkType=1 order by Priority" rsKey.Open sqlKey, Conn, 1, 1 If Not (rsKey.BOF And rsKey.EOF) Then PE_Cache.SetValue "Site_ReplaceText", rsKey.GetString(, , "|||", "@@@", "") rsKey.Close Set rsKey = Nothing Else rsKey.Close Set rsKey = Nothing ReplaceText = iText Exit Function End If End If rText = iText Keyrow = Split(PE_Cache.GetValue("Site_ReplaceText"), "@@@") For i = 0 To UBound(Keyrow) - 1 Keycol = Split(Keyrow(i), "|||") If Int(Keycol(3)) = 0 Or Int(Keycol(3)) = iType Then rText = PE_Replace(rText, Keycol(0), Keycol(1)) Next ReplaceText = rText End Function Function GetDownloadUrlList(DownloadUrls) Dim arrDownloadUrls, arrUrls, iTemp, strUrls Dim rsDownServer, sqlDownServer, ShowServerName, iShowModule If DownloadUrls = "" Then GetDownloadUrlList = "" Exit Function End If strUrls = "" If InStr(DownloadUrls, "@@@") > 0 Then '构建镜像服务器下载地址列表 arrDownloadUrls = Trim(Replace(DownloadUrls, "@@@", "")) '得PE_Soft中的Url地址 sqlDownServer = "select * from PE_DownServer" Set rsDownServer = Server.CreateObject("adodb.recordset") rsDownServer.Open sqlDownServer, Conn, 1, 3 If rsDownServer.BOF Or rsDownServer.EOF Then strUrls = "对不起,未找到任何镜像服务器信息!" End If Do While Not rsDownServer.EOF If rsDownServer("ShowType") = 0 Then ShowServerName = rsDownServer("ServerName") Else ShowServerName = "
" End If rsDownServer.MoveNext Loop GetDownloadUrlList = strUrls rsDownServer.Close Set rsDownServer = Nothing Else arrDownloadUrls = Split(DownloadUrls, "$$$") For iTemp = 0 To UBound(arrDownloadUrls) arrUrls = Split(arrDownloadUrls(iTemp), "|") If UBound(arrUrls) >= 1 Then If arrUrls(1) <> "" And arrUrls(1) <> "http://" Then If Left(arrUrls(1), 1) <> "/" And InStr(arrUrls(1), "://") <= 0 Then strUrls = strUrls & "" & arrUrls(0) & "
" Else strUrls = strUrls & "" & arrUrls(0) & "
" End If End If End If Next GetDownloadUrlList = strUrls End If End Function %>