?!--#include file="function/conn.asp"--> ?% public function isint(str) if str="" then isint="" elseif isnumeric(str)=False then response.redirect "http://china.21cpp.com" Else isint=Cint(str) End if end function public function gl(str) gl=replace(str,"'","") end function public function check_Enter_en(str) check_Enter_en=false EN_Enter_str="ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz1234567890`=~!@#$%^&*()_+[]{}\\|?/.>,<;:'\-?<>/~!·#¥%…;‘’:“”—*( )—+|-=、/。,?《》↑↓⊙●★☆■♀ 『』◆◥◤?Ψ ?→№←㊣∑⌒ 〖?@ξζω□ ∮〓?▓∏卐?】▲△√ ∩¤?♀♂∞ ?≡↘?&◎Ю┼┏ ┓田 ┃▎○╪┗┛ ?①②③④⑤⑥⑦⑧ \" for i=1 to len(str) if instr(EN_Enter_str,mid(str,i,1))=0 then check_Enter_en=true Next end function public function Rndstr(num) Randomize RndStr=Rnd() divStr="" For div=1 to num RndStr=Rnd() If Int(62*RndStr)<11 Then divStr=divStr & Chr(Int(10*RndStr)+48) ElseIf Int(62*RndStr)<37 Then divStr=divStr & Chr(Int(26*RndStr)+65) Else divStr=divStr & Chr(Int(26*RndStr)+97) End if Next RndStr=divStr end function public function OutStr(str, mode) if mode="" or mode=1 then color="#000000" elseif mode=2 then color="#FF0000" end if outstr="
" & str & " |
")
guest = Replace(guest, CHR(39), "'")
guest=Replace(Guest," "," ")
guest=Replace(Guest," ","`nbsp;")
guest=replace(guest,"\x3c","<")
guest=replace(guest,"\x3e",">")
Guest=Server.HTMLEncode(Guest)
guest=Replace(Guest,"`nbsp;"," ")
guest=Replace(Guest,vbcrlf,"
")
guest=Replace(Guest,"#","")
HtmlOut=guest
end function
public function checkstr(submitvalue)
dim strvalue
if isnull(submitvalue) or submitvalue="" then
checkstr=submitvalue
exit function
end if
strvalue=submitvalue
strvalue = replace(replace(server.HTMLEncode(trim(strvalue)),"%",""),"'","")
checkstr=strvalue
end function
public function OutOption(conn,tabel,style,value)
'从数据库中提取内容生成下拉菜?
'conn 为数据库联接 table为表? style下接菜单样式
dim re,sql,selected
set re=server.CreateObject("ADODB.RECORDSET")
sql = "SELECT * FROM " & tabel & " ORDER BY value"
re.Open sql,conn
Response.Write ("" & vbCrlf)
set re=nothing
end function
Public Function CheckValue(Str, Low, Up, Mode, Lable)
'Mode = 1 检测是否为? 2是否是数? 4是否整数
'8是否是为数字、字母和_.-
'16 自定义字符检?
'32 长度检?
'64 数字大小检?
Dim Temp
Dim Length, i, Base
If Mode Mod 2 >= 1 Then
If Str = "" Then
Temp = Temp & "? & Lable & "? & " must be not empty? & vbCrLf
End If
End If
If Mode Mod 4 >= 2 Then
If Not IsNumeric(Str) And Str <> "" Then
Temp = Temp & "? & Lable & "? & "must be a number.? & vbCrLf
End If
End If
If Mode Mod 8 >= 2 Then
If Not IsNumeric(Str) And Str <> "" And InStr(Str, ".") = 0 Then
Temp = Temp & "? & Lable & "? & "必需是整数!" & vbCrLf
End If
End If
If Mode Mod 16 >= 8 Then
Length = Len(Str)
Base = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789_-."
For i = 1 To Length
If InStr(Base, Mid(Str, i, 1)) = 0 Then
Temp = Temp & """ & Lable & """ & "includes wrong letters. It must be letters, numbers and""- _ .""? & vbCrLf
Exit For
End If
Next
End If
If Mode Mod 32 >= 16 Then
Length = Len(Str)
Base = Replace(Low, "[A-Z]", "ABCDEFGHIJKLMNOPQRSTUVWXYZ")
Base = Replace(Base, "[a-z]", "abcdefghijklmnopqrstuvwxyz")
Base = Replace(Base, "[0-9]", "0123456789")
For i = 1 To Length
If InStr(Base, Mid(Str, i, 1)) = 0 Then
Temp = Temp & """ & Lable & """ & "includes wrong letters. It must be" & Up & "." & vbCrLf
Exit For
End If
Next
End If
If Mode Mod 64 >= 32 Then
Length = Len(Str)
If Not (Length >= Low And Length <= Up) Then
Temp = Temp & "Length of " & Lable & " must be between " & Low & " and " & Up & "" & vbCrLf
End If
End If
If Mode Mod 128 >= 64 Then
If IsNumeric(Str) Then
If Not (CInt(Str) >= CInt(Low) And CInt(Str) <= CInt(Up)) Then
Temp = Temp & """ & Lable & """ & " must be between" & Low & " and " & Up & "" & vbCrLf
End If
End If
End If
CheckValue = Temp
End Function
Public Function sqlpage(PageSize_a,flies,Table,sql_where,key_index,page,modetype)
CurrentPage=page
if CurrentPage="" then
CurrentPage=1
elseif isnumeric(CurrentPage)=False then
CurrentPage=1
Else
CurrentPage=Cint(CurrentPage)
End if
StartId = (CurrentPage-1)*PageSize_a
EndId = StartId+PageSize_a
if modetype="" then
sqlpage="Select " & flies & " from ["&Table&"] where id in(Select top "&Endid&" id from ["&Table&"] where "&sql_where&key_index&") and id not in(Select top "&Startid&" id from ["&Table&"] where "&sql_where&key_index&")"&key_index
else
sqlpage="Select " & flies & " from "&Table&" where a.id in(Select top "&Endid&" a.id from "&modetype&" where "&sql_where&key_index&") and a.id not in(Select top "&Startid&" a.id from "&modetype&" where "&sql_where&key_index&")"&key_index
end if
end Function
Sub pageCode_a(PageSize_a,page,table,sql_where)
'生成PreviousNext链接2
set count_num=conn.execute("select count(id) from " & table & " where " & sql_where)
TotalNumber=count_num(0)
count_num.close
Dim query, a, x, temp
action = "http://" & Request.ServerVariables("HTTP_HOST") & Request.ServerVariables("SCRIPT_NAME")
query = Split(Request.ServerVariables("QUERY_STRING"), "&")
For Each x In query
a = Split(x, "=")
If a(0)<>"page" Then
temp = temp & a(0) & "=" & a(1) & "&"
End If
Next
if TotalNumber mod PageSize_a=0 then
n= TotalNumber \ PageSize_a
else
n= TotalNumber \ PageSize_a+1
end if
if TotalNumber Mod PageSize_a = 0 then
TotalPage = TotalNumber \ PageSize_a
Else
TotalPage = TotalNumber \ PageSize_a + 1
End if
CurrentPage=page
if CurrentPage="" then
CurrentPage=1
elseif isnumeric(CurrentPage)=False then
CurrentPage=1
Else
CurrentPage=Cint(CurrentPage)
End if
if CurrentPage-1 mod 10=0 then
p=(CurrentPage-1) \ 10
else
p=(CurrentPage-1) \ 10
end if
Response.Write "
" & Msg & "
" Response.Write "" elseif mode=3 then Response.Write "" Response.Write "" & Msg & "
" Response.Write "" end if End Function Public Function CutStr(str, number) Dim length, llen, i, value length = Len(str) For i = 1 To length value = Asc(Mid(str, i, 1)) If value >= -127 And value <= 127 Then llen = llen + 1 Else llen = llen + 2 End If If llen >= number Then CutStr = Left(str, i-3) & "..." Exit Function End If Next CutStr = str End Function sub alertback(text,url) response.write "" end sub sub msgbox_asp(text,url) response.write "" end sub sub msgbox_history(text,num) response.write "" end sub sub msgbox_null(text) response.write "" end sub Function TranslateDateTime(dt) TranslateDateTime = ""&Year(dt)&"-"&Month(dt)&"-"&Day(dt)&" "&FormatDateTime(dt,vbShortTime)&"" End Function Function httpurl(str) '处理显示URL httpurl_action = "http://" & Request.ServerVariables("HTTP_HOST") & Request.ServerVariables("SCRIPT_NAME") httpurl_query = Split(Request.ServerVariables("QUERY_STRING"), "&") For Each x In httpurl_query httpurl_a = Split(x, "=") If StrComp(LCase(httpurl_a(0)), str, vbTextCompare) <> 0 Then httpurl_temp = httpurl_temp & httpurl_a(0) & "=" & httpurl_a(1) & "&" End If Next httpurl=httpurl_action & "?" & httpurl_temp End Function %>Microsoft VBScript ʱ
'800a01a8'ȱٶ: ''
/Company/include/Web_Class.asp 14