<% '*********************** '��������ҳ�ļ�ʹ�ú��� '���ߣ�STEVEN '���ڣ�2008-3-20 '*********************** %> <% public UPDATE_TIME,counter UPDATE_TIME=date() & " " & time() function NulltoZero(var1) if isNull(var1) or var1="" then NulltoZero=0 else NulltoZero=Clng(var1) end if end function ' ============================================ ' ���в����жϣ��Ƿ��һ������ ' strAlert ��ʾ���� Num ȷ�Ϸ��صĵ�ַ ' ============================================ Function OKToWhere(strAlert,Num) Response.Write("") Response.End End Function ' ============================================ ' ���в����жϣ��Ƿ��һ������ 'ʹ�÷��� ��call OKToWhere2("���óɹ�","set_function.asp") ' strAlert ��ʾ���ԣ� Where ת��ĵ�ַ ' ============================================ Function OKToWhere2(strAlert,where) Response.Write("") Response.End End Function Function GetSafeStr(str) ' GetSafeStr = Replace(Replace(Replace(Trim(str), "'", ""), Chr(34), ""), ";", "") GetSafeStr = Replace(Replace(Replace(Replace(Replace(str,"'","��"),"""","��"),"&",""),"<","<"),">",">") End Function Function GetSafeStr1(str) ' GetSafeStr = Replace(Replace(Replace(Trim(str), "'", ""), Chr(34), ""), ";", "") GetSafeStr1 = Replace(Replace(Replace(str,"'","��"),"""","��"),"&","") End Function Function GetSafeInt(iCheck,iDefault) If Trim(iCheck)="" Then GetSafeInt = iDefault Exit Function End If If IsNumeric(iCheck)=false Then GetSafeInt = iDefault Exit Function End If GetSafeInt = iCheck GetSafeInt=clng(GetSafeInt) End Function function SpacetoNull(var1) if isNull(var1) or var1="" then NulltoZero="Null" else NulltoZero=clng(var1) end if end function function NullToSpace(var1) if isNull(var1) or var1="" then NullToSpace=" " else NullToSpace=trim(var1) end if end function Function HTMLEncode(fString) If Not IsNull(fString) Then Dim bwords,ii 'fString = replace(fString, ">", ">") 'fString = replace(fString, "<", "<") fString = Replace(fString, CHR(32), " ") fString = Replace(fString, CHR(9), " ") fString = Replace(fString, CHR(34), """) fString = Replace(fString, CHR(39), "'") fString = Replace(fString, CHR(13), "") fString = Replace(fString, CHR(10) & CHR(10), "

") fString = Replace(fString, CHR(10), "
") HTMLEncode = fString End If End Function Function unHTMLEncode(fString) If Not IsNull(fString) Then Dim bwords,ii 'fString = replace(fString, ">", ">") 'fString = replace(fString, "<", "<") fString = Replace(fString, " ", CHR(32)) fString = Replace(fString, " ", CHR(9)) fString = Replace(fString, """, CHR(34)) fString = Replace(fString, "'", CHR(39)) fString = Replace(fString, "", CHR(13)) fString = Replace(fString, "

", CHR(10) & CHR(10)) fString = Replace(fString, "
", CHR(10)) unHTMLEncode = fString End If End Function '****************************************************************************************************************** function funPage(haveOrder,fstClass,secClass,strSqlPar,TitCount,TitNameArr,fileNameArr,PageSize,tabWidth,PreviousMark,NextMart,FirstMart,LastMart,borderWidth,hrefDelFilName,idName,hrefUpdFilName,haveDel,openFileName,haveOpen,LineLength,OpenLinkLogo,haveDateAndClass,haveTarget,ActionUrl) '�����ں�̨ ��ҳ��ʾ �����޸ģ�ɾ���ij��� 'haveOrder 1�Ƿ������� 'fstClass 2һ������ 'secClass 3�������� 'strSqlPar 4Ҫ��������SQl��� 'TitCount 5���б�ͷ�ĸ��� 'TitNameArr 6��ͷ���� ����֮����ȫ�ǡ������ָ� 'fileNameArr 7Ҫ��ʾ���ֶ��� ���ֶ���֮ǰ��ȫ�ǡ������ָ� 'PageSize 8ÿҳ��ʾ���ݵ���Ŀ 'tabWidth 9����Ŀ��� 'PreviousMark 10ǰһҳ�ı�� ����ǰһҳ��ʲô��ʾ 'NextMart 11��һҳ�ı�� ���Ǻ�һҳ��ʲô��ʾ 'FirstMart 12��һҳ�ı�� ����ǰһҳ��ʲô��ʾ 'LastMart 13βһҳ�ı�� ����ǰһҳ��ʲô��ʾ 'borderWidth 14����߿�Ŀ��� 'hrefDelFilName 15ɾ��ʱ���ύ��ҳ eg:FL_login_action.asp?ID 'idName 16������ʱҪ����ID����Ӧ�����ݿ��е��ֶ��� 'hrefUpdFilName 17�����ӵĵ�ַ��Ҫ���IJ����� eg: shopping_News.asp?ID= 'openFileName 18�������һ����ҳ--��ҳ�ļ������� 'haveOpen 19�Ƿ���Open һ����ҳ�Ĺ��� 'LineLength 20ÿһ����ʾ������ 'OpenLinkLogo 21��ʾ�����б�ǰ���С��ʶ 'haveDateAndClass 22������Ƿ���ʾ���� ���������ﴫclass������ ����˲���Ϊ������ʾ���� 'haveTarget 23�ڵ���޸�ʱ�Ƿ���TARGET 'ActionUrl 24���ܵIJ����� %> <% dim strSql,rs,i,j dim Arr_TitHeadName,Arr_TitBodyName dim CurrPage dim inDateSpaceLeng,titLength,titleCon dim UrlP_Name,UrlPval 'Response.Write "

" Response.Write "" if instr(ActionUrl,"=")>0 and instr(ActionUrl,"&")>0 then ActionUrlArr=split(ActionUrl,"&") for i=0 to ubound(ActionUrlArr) if instr(ActionUrlArr(i),"=")>0then UrlP_Name=left(ActionUrlArr(i),instr(ActionUrlArr(i),"=")-1) UrlPval=mid(ActionUrlArr(i),instr(ActionUrlArr(i),"=")+1) Response.Write "" end if next 'add at 2004-11-27 because �ڵ�Ver01����Ȼ���Ա���ԭ����ʧ�IJ�������ֻ����һ������ο��Ա���N������ else if instr(ActionUrl,"=")>0then UrlP_Name=left(ActionUrl,instr(ActionUrl,"=")-1) UrlPval=mid(ActionUrl,instr(ActionUrl,"=")+1) Response.Write "" 'Response.Write "" 'Response.Write "" end if end if 'add at 2004-04-14 because ���һ�κ��ã��������ҳʱ����ʧԭ������������������ʾ Ver01 CurrPage=trim(request("hid_CurPage")) if isnumeric(CurrPage)=false and CurrPage<>"" then Response.Write "" exit function end if if CurrPage="" then CurrPage=1 Arr_TitHeadName=Split(TitNameArr,"��") Arr_TitBodyName=Split(fileNameArr,"��") set rs=server.CreateObject ("adodb.recordset") strSql=strSqlPar rs.Open strSql,conn1,3,1'access ��3 Sql2000,��1 if rs.eof or rs.bof then response.write "" exit function end if rs.PageSize=PageSize rs.AbsolutePage=CurrPage Response.Write" " Response.Write" " for i=0 to TitCount-1 Response.Write" " next Response.Write" " while not rs.EOF and j< rs.PageSize j=j+1 Response.Write" " if OpenLinkLogo<>"" then Response.Write"" end if for i=0 to ubound(Arr_TitBodyName) Response.Write"" '****************************** 'for list News last Date if haveDateAndClass<>"" then inDateSpaceLeng=instr(trim(rs("UPDATE_TIME"))," ") 'titleCon=titleCon & left(trim(rs("UPDATE_TIME")),inDateSpaceLeng-1) Response.Write "" end if '****************************** next if haveOrder="yes" then Response.Write"" end if if hrefUpdFilName<>"" then Response.Write" " end if if haveDel="yes" then Response.Write "" 'Response.Write" " end if Response.Write" " rs.MoveNext wend Response.Write "
" Response.Write Arr_TitHeadName(i) Response.Write"
" Response.Write OpenLinkLogo Response.Write"  " if isdate(NullToSpace(rs(Arr_TitBodyName(i)))) then inDateSpaceLeng=instr(rs(Arr_TitBodyName(i))," ") 'for list date ,not date() & " " time () inDateSpaceLeng=inDateSpaceLeng-1 if inDateSpaceLeng=-1 then 'edit at 2004-04-14 because date is 2004-01-01 not 2004-01-01 11:11:11 inDateSpaceLeng=len(trim(rs(Arr_TitBodyName(i)))) end if Response.Write left(rs(Arr_TitBodyName(i)),inDateSpaceLeng) else titleCon=NullToSpace(rs(Arr_TitBodyName(i))) 'if title too long then left(string,15) & "..." titLength=len(titleCon) if titLength > LineLength then titleCon=left (titleCon,LineLength) & "..." end if if haveOpen="yes" then 'Response.Write "" & titleCon & "" Response.Write "" & titleCon & "" else Response.Write "" & titleCon & "" end if end if Response.Write"" Response.Write "" & left(trim(rs("UPDATE_TIME")),inDateSpaceLeng-1) & "" 'Response.Write "" & rs("UPDATE_TIME") & "" Response.Write "" Response.Write"" Response.Write"" Response.Write"" Response.Write"" Response.Write"" Response.Write "�ޡ���" Response.Write" " Response.Write "ɾ������Ϣ�������ɾ������" 'Response.Write"
" Response.Write "" Response.Write "" Response.Write "
" Response.Write "�� "& rs.RecordCount & " �� " Response.Write CurrPage & "/" & rs.PageCount & " ҳ  " Response.Write PageSize & " ��/ҳ   " Response.Write " " & FirstMart & " " Response.Write " " & PreviousMark & " " 'Response.Write " " & NextMart & " " Response.Write " " & NextMart & " " Response.Write " " & LastMart & " " Response.Write "     ȫ��ѡ��    " Response.Write "" Response.Write "

 

" end function '****************************************************************************************************************** Public Function PBFCounter() if session("first")="" then strS="insert into counterNo (C_IP) values ('"&Request.ServerVariables("REMOTE_ADDR")&"')" conn1.execute strS session("first")="yes" end if set rs=server.createobject("adodb.recordset") strSql="select count(MID) from counterNo" rs.open strSql,conn1,1,1,1 counter=rs(0)+6180 PBFCounter=counter End Function Public Function pbFunParentMenu(Byval PAdmOrFront) ' List Master Menu Dim Id,Menu Set rs=server.CreateObject("ADODB.RecordSet") Select Case ucase(PAdmOrFront) Case "ADMIN" strSql="SELECT WMM_ID, WMM_MENU FROM WMM_MENU WHERE WMM_MENUID IS NULL " Id="WMM_ID" Menu="WMM_MENU" Case "FRONT" strSql="SELECT HPM_ID, HPM_MENU FROM HomePageMenu WHERE HPM_MENUID IS NULL " Id="HPM_ID" Menu="HPM_MENU" Case Else Response.Write "within confun pbFunParentMenu case else! " Response.End End Select rs.open strSql,conn1,3,3 Response.Write "" & chr(10) Response.Write ""& trim(rs(MenuId)) &"" & chr(10) Response.Write " ɾ �� " & chr(10) Response.Write "" rs.movenext Wend End Function Function chkIsnumeric(ByVal Pval) chkIsnumeric=True If trim(Pval)="" Then chkIsnumeric=False End If If not isnumeric(Pval) Then chkIsnumeric=False End If If chkIsnumeric=False Then Response.Write "
Sorry the parametter ware wrong. You can't modification it
" Response.End End IF End Function %>