DS_Public.asp
资源名称:eat.rar [点击查看]
上传用户:jisenq
上传日期:2014-06-29
资源大小:7216k
文件大小:64k
源码类别:
数据库编程
开发平台:
ASP/ASPX
- <%
- Class cls_DS
- Private m_Rs,m_FSO,m_Dict
- Private m_PathDir,m_Path_UserDir,m_Path_User,m_Path_adminDir,m_Path_UserPageDir,m_Path_Templet
- Private m_Err_Info,m_Err_NO
- Public Property Get Err_Info()
- Err_Info = m_Err_Info
- End Property
- Public Property Get Err_NO()
- Err_NO = m_Err_NO
- End Property
- Private Sub Class_initialize()
- Set m_Rs = Server.CreateObject(G_FS_RS)
- Set m_FSO = Server.CreateObject(G_FS_FSO)
- Set m_Dict = Server.CreateObject(G_FS_DICT)
- m_PathDir = replace("/"&G_VIRTUAL_ROOT_DIR&"/","//","/")
- m_Path_UserDir = replace("/"&G_VIRTUAL_ROOT_DIR&"/"&G_USER_DIR&"/","//","/")
- m_Path_UserPageDir = replace("/"&G_VIRTUAL_ROOT_DIR&"/"&G_USERFILES_DIR&"/","//","/")
- End Sub
- Private Sub Class_Terminate()
- Set m_Rs = Nothing
- Set m_FSO = Nothing
- Set m_Dict = Nothing
- End Sub
- Public Function get_LableChar(f_Lablechar,f_Id)
- Dim f_array
- f_array= split(f_Lablechar,"┆")
- if ubound(f_array)=0 and not isarray(f_array) then
- get_LableChar=""
- exit Function
- else
- select case LCase(f_array(0))
- case "classnews","lastnews","recnews","hotnews","downhotnews"
- ''get_LableChar = ubound(f_array) : exit function ''测试用
- if ubound(f_array)<>17 and ubound(f_array)<>23 then:get_LableChar="标签错误,by Foosun.cn":else:get_LableChar=ClassNews(f_Lablechar,LCase(f_array(0)),f_Id):end if
- case "classlist"
- if ubound(f_array)<>17 and ubound(f_array)<>23 then:get_LableChar="标签错误":else:get_LableChar=classlist(f_Lablechar,"classlist",f_Id):end if
- '常规标签类
- case "readnews"
- if ubound(f_array)<>2 then:get_LableChar="标签错误,by Foosun.cn":else:get_LableChar=ReadNews(f_Lablechar,"readnews",f_Id):end if
- case "sitemap"
- if ubound(f_array)<>2 then:get_LableChar="标签错误,by Foosun.cn":else:get_LableChar=SiteMap(f_Lablechar,"sitemap",f_Id):end if
- case "search"
- if ubound(f_array)<>2 then:get_LableChar="标签错误,by Foosun.cn":else:get_LableChar=Search(f_Lablechar,"search"):end if
- case "infostat"
- if ubound(f_array)<>1 then:get_LableChar="标签错误,by Foosun.cn":else:get_LableChar=infoStat(f_Lablechar,"infostat"):end if
- case "classnavi"
- if ubound(f_array)<>11 then:get_LableChar="标签错误,by Foosun.cn":else:get_LableChar=ClassNavi(f_Lablechar,"classnavi",f_Id):end if
- case "subclasslist"
- if ubound(f_array)<>20 and ubound(f_array)<>26 then:get_LableChar="标签错误,by Foosun.cn":else:get_LableChar=subClassList(f_Lablechar,"subclasslist",f_Id):end if
- end select
- end if
- End Function
- '得到div,table_________________________________________________________________________________
- Public Function table_str_list_head(f_tf,f_divid,f_divclass,f_ulid,f_ulclass)
- Dim table_,tr_
- Dim f_divid_1,f_divclass_1,f_ulid_1,f_ulclass_1
- if f_tf=1 then
- if f_divid<>"" then:f_divid_1 = " id="""& f_divid &"""":else:f_divid_1 = "":end if
- if f_divclass<>"" then:f_divclass_1 = " class="""& f_divclass &"""":else:f_divclass_1 = "":end if
- if f_ulid<>"" then:f_ulid_1 = " id="""& f_ulid &"""":else:f_ulid_1 = "":end if
- if f_ulclass<>"" then:f_ulclass_1 = " class="""& f_ulclass &"""":else:f_ulclass_1 = "":end if
- table_="<div"& f_divid_1 & f_divclass_1 &">"
- tr_="<ul"& f_ulid_1 & f_ulclass_1 &">"
- table_str_list_head = table_&chr(10)
- table_str_list_head = table_str_list_head &" "& tr_&chr(10)
- else
- table_="<table border=""0"" cellspacing=""0"" cellpadding=""0"" width=""100%"">"
- table_str_list_head = table_&chr(10)
- end if
- End Function
- '得到div,table_________________________________________________________________________________
- public Function table_str_list_middle_1(f_tf,f_liid,f_liclass)
- Dim f_liid_1,f_liclass_1,td_
- if f_tf=1 then
- if f_liid<>"" then:f_liid_1 = " id="""& f_liid &"""":else:f_liid_1 = "":end if
- if f_liclass<>"" then:f_liclass_1 = " class="""& f_liclass &"""":else:f_liclass_1 = "":end if
- td_="<li"&f_liid_1&f_liclass_1&">"
- table_str_list_middle_1 =" "&td_
- end if
- End Function
- '得到div,table_________________________________________________________________________________
- public Function table_str_list_middle_2(f_tf)
- Dim td__,tr__
- if f_tf=1 then
- td__="</li>"
- else
- td__="</td>"
- end if
- table_str_list_middle_2 = td__&chr(10)
- End Function
- '得到div,table_________________________________________________________________________________
- Public Function table_str_list_middle_3(f_tf)
- if f_tf=1 then
- table_str_list_middle_3 = ""
- else
- table_str_list_middle_3 = "</tr>"
- end if
- End Function
- '得到div,table_________________________________________________________________________________
- Public Function table_str_list_bottom(f_tf)
- Dim table__,tr__
- if f_tf=1 then
- table__="</div>"
- tr__="</ul>"
- table_str_list_bottom = " "&tr__&chr(10)
- else
- table__="</table>"
- table_str_list_bottom = ""
- end if
- table_str_list_bottom = table_str_list_bottom &table__&chr(10)
- End Function
- 'DIV格式输出结束_____________________________________________________________________
- '开始读取标签____综合类标签__________________________________________________
- Public Function ClassNews(f_Lablechar,f_LableType,f_Id)
- Dim table_array,classNews_head,classNews_bottom,classNews_middle1,classNews_middle2,div_tf,style_id,style_Content,Content_List,f_rs_s_obj,Content_more,c_i_k
- Dim newnumber,classid,orderby,orderdesc,colnumber,contentnumber,navinumber,datenumber,titlenumber,picshowtf,datenumber_tmp,morechar,datestyle,openstyle,open_target,containSubClass,childClass
- Dim f_sql,f_rs_obj,f_rs_configobj,f_configSql,CharIndexStr
- Dim MF_Domain,marqueedirec,marqueespeed,marqueestyle
- Dim search_str,order_in_str_awen
- Dim ClassName,ClassEName,c_Domain,ClassNaviContent,ClassNaviPic,c_SavePath,c_FileSaveType,search_inSQL
- table_array=split(f_Lablechar,"┆")
- if instr(f_Lablechar,"out_DIV")>0 then
- div_tf=1
- search_str = split(split(f_Lablechar,"┆")(2),"$")(1)
- newnumber =split(split(f_Lablechar,"┆")(3),"$")(1)
- datenumber= split(split(f_Lablechar,"┆")(11),"$")(1)
- titlenumber= split(split(f_Lablechar,"┆")(12),"$")(1)
- picshowtf=split(split(f_Lablechar,"┆")(13),"$")(1)
- openstyle=split(split(f_Lablechar,"┆")(14),"$")(1)
- containSubClass=split(split(f_Lablechar,"┆")(15),"$")(1)
- orderby = split(split(f_Lablechar,"┆")(16),"$")(1)
- orderdesc = split(split(f_Lablechar,"┆")(17),"$")(1)
- morechar = split(split(f_Lablechar,"┆")(18),"$")(1)
- datestyle = split(split(f_Lablechar,"┆")(20),"$")(1)
- style_id = split(split(f_Lablechar,"┆")(21),"$")(1)
- colnumber= split(split(f_Lablechar,"┆")(22),"$")(1)
- contentnumber= split(split(f_Lablechar,"┆")(23),"$")(1)
- else
- div_tf=0
- search_str = split(split(f_Lablechar,"┆")(2),"$")(1)
- newnumber = split(split(f_Lablechar,"┆")(3),"$")(1)
- datenumber= split(split(f_Lablechar,"┆")(5),"$")(1)
- titlenumber= split(split(f_Lablechar,"┆")(6),"$")(1)
- picshowtf=split(split(f_Lablechar,"┆")(7),"$")(1)
- openstyle=split(split(f_Lablechar,"┆")(8),"$")(1)
- containSubClass=split(split(f_Lablechar,"┆")(9),"$")(1)
- orderby = split(split(f_Lablechar,"┆")(10),"$")(1)
- orderdesc = split(split(f_Lablechar,"┆")(11),"$")(1)
- morechar = split(split(f_Lablechar,"┆")(12),"$")(1)
- datestyle = split(split(f_Lablechar,"┆")(14),"$")(1)
- style_id = split(split(f_Lablechar,"┆")(15),"$")(1)
- colnumber= split(split(f_Lablechar,"┆")(16),"$")(1)
- contentnumber= split(split(f_Lablechar,"┆")(17),"$")(1)
- end if
- 'if isnumeric(newnumber)=false then
- ' newnumber = 10
- 'else
- ' newnumber=newnumber
- 'end if
- if not isnumeric(titlenumber) then
- titlenumber = 30
- else
- titlenumber = titlenumber
- end if
- if isnumeric(colnumber)=false then
- colnumber = 30
- else
- colnumber = colnumber
- end if
- if isnumeric(contentnumber)=false then
- contentnumber = 100
- else
- contentnumber = contentnumber
- end if
- 'if div_tf=1 then
- classNews_head = table_str_list_head(div_tf,split(table_array(5),"$")(1),split(table_array(6),"$")(1),split(table_array(7),"$")(1),split(table_array(8),"$")(1))
- classNews_middle1 = table_str_list_middle_1(div_tf,split(table_array(9),"$")(1),split(table_array(10),"$")(1))
- 'end if
- classNews_bottom = table_str_list_bottom(div_tf)
- classNews_middle2 = table_str_list_middle_2(div_tf)
- ''永不过期和尚未到期的
- datenumber_tmp=" and (OverDue=0 or (OverDue>0 and datediff('d',AddTime,'"&date()&"')<= OverDue))"
- if datenumber ="0" then:datenumber_tmp = "":else:datenumber_tmp = " and datevalue(AddTime)+"&datenumber&">=datevalue(now)":end if
- ''已经在外部定义好了。
- order_in_str_awen = ""&orderby&" "&orderdesc&""
- if ucase(orderby)<>"ID" then order_in_str_awen = order_in_str_awen & ",ID Desc"
- If containSubClass=1 Then
- childClass=" or classid in ("&DelHeadAndEndDot(getNewsSubClass(search_str))&")"
- Else
- childClass=""
- End if
- select case f_LableType
- case "classnews"
- If childClass<>"" Then
- search_inSQL = " and (ClassId='"& search_str &"'"&childClass&")"
- Else
- search_inSQL = " and ClassId='"& search_str &"'"
- End if
- case "lastnews","hotnews","downhotnews"
- if trim(search_str)<>"" Then
- If childClass<>"" Then
- search_inSQL = " and (ClassId='"& search_str &"'"&childClass&")"
- Else
- search_inSQL = " and ClassId='"& search_str &"'"
- End if
- else
- if trim(f_id)<>"" Then
- If childClass<>"" then
- search_inSQL = " and (ClassId='"& f_id &"'"&childClass&")"
- Else
- search_inSQL = " and ClassId='"& f_id &"'"
- End if
- else
- search_inSQL = ""
- end if
- end if
- f_LableType = "classnews" ''处理后还原
- case "recnews"
- if trim(search_str)<>"" Then
- If childClass<>"" then
- search_inSQL = " and RecTF=1 and (ClassId='"& search_str &"'"&childClass&")"
- Else
- search_inSQL = " and RecTF=1 and ClassId='"& search_str &"'"
- End if
- else
- if trim(f_id)<>"" Then
- If childClass<>"" then
- search_inSQL = " and RecTF=1 and (ClassId='"& f_id &"'"&childClass&")"
- Else
- search_inSQL = " and RecTF=1 and ClassId='"& f_id &"'"
- End if
- else
- search_inSQL = " and RecTF=1"
- end if
- end if
- f_LableType = "classnews" ''处理后还原
- end select
- f_sql="select top "& cint(newnumber) &" ID,DownLoadID,ClassID,Description,Accredit,AddTime,Appraise,AuditTF,BrowPop," _
- &"ClickNum,EditTime,EMail,SavePath,FileExtName,FileName,FileSize,Language,Name,NewsTemplet,PassWord,Pic," _
- &"Property,Provider,ProviderUrl,RecTF,ReviewTF,ShowReviewTF,SystemType,Types,Version,OverDue,ConsumeNum,Hits"
- f_sql = f_sql &" From FS_DS_List where AuditTF=1 "&search_inSQL & datenumber_tmp &" order by "&order_in_str_awen
- MF_Domain = Request.Cookies("FoosunMFCookies")("FoosunMFDomain")
- Content_List=""
- set f_rs_obj = Conn.execute(f_sql)
- if f_rs_obj.eof then
- Content_List=""
- f_rs_obj.close:set f_rs_obj=nothing
- else
- if f_LableType="marnews" then
- Content_List = Content_List & "<marquee onmouseover=""this.stop();"" scrollamount="""& marqueespeed &""" direction="""& marqueedirec &""" onmouseout=""this.start();"">"
- do while not f_rs_obj.eof
- Content_List= Content_List &getlist_news(f_rs_obj,style_id,titlenumber,contentnumber,navinumber,picshowtf,datestyle,openstyle,MF_Domain,f_LableType)&" "
- f_rs_obj.movenext
- loop
- Content_List = Content_List & "</marquee>"
- else
- if div_tf = 0 then
- c_i_k = 0
- if cint(colnumber)<>1 then
- Content_List = Content_List & " <tr>"
- end if
- end if
- do while not f_rs_obj.eof
- if div_tf=1 then
- Content_List= Content_List & classNews_middle1 & getlist_news(f_rs_obj,style_id,titlenumber,contentnumber,navinumber,picshowtf,datestyle,openstyle,MF_Domain,f_LableType) & classNews_middle2
- else
- if cint(colnumber) =1 then
- Content_List= Content_List & chr(10)&" <tr><td>" & getlist_news(f_rs_obj,style_id,titlenumber,contentnumber,navinumber,picshowtf,datestyle,openstyle,MF_Domain,f_LableType) & "</td></tr>"
- else
- Content_List= Content_List & "<td width="""& cint(100/cint(colnumber))&"%"">" & getlist_news(f_rs_obj,style_id,titlenumber,contentnumber,navinumber,picshowtf,datestyle,openstyle,MF_Domain,f_LableType) & "</td>"
- end if
- end if
- f_rs_obj.movenext
- if div_tf = 0 then
- if cint(colnumber)<>1 then
- c_i_k = c_i_k+1
- if c_i_k mod cint(colnumber) = 0 then
- Content_List = Content_List & "</tr>"&chr(10)&" <tr>"
- end if
- end if
- end if
- loop
- if div_tf=0 then
- if cint(colnumber)<>1 then
- Content_List = Content_List & "</tr>"&chr(10)
- end if
- end if
- end if
- '得到栏目路径
- if f_LableType="classnews" then
- dim Query_rs,newsclass_SavePath,FileSaveType,UrlDomain,all_savepath
- set Query_rs=Conn.execute("select ClassEName,SavePath,FileExtName,[Domain],FileSaveType,IsURL,UrlAddress From FS_DS_Class where ClassId='"& search_str &"'")
- if Query_rs.eof then
- Query_rs.close:set Query_rs=nothing
- else
- all_savepath = get_ClassLink(search_str)
- Query_rs.close:set Query_rs=nothing
- end if
- if openstyle=0 then
- open_target=" "
- else
- open_target=" target=""_blank"""
- end if
- if div_tf=1 then
- Content_more = " <li><a href="""& all_savepath &""" "& open_target &" title=""更多..."">"&morechar&"</a></li>"&chr(10)
- else
- Content_more = " <tr><td colspan="""& cint(colnumber) &"""><div align=""right""><a href="""& all_savepath &""" "& open_target &" title=""更多..."">"&morechar&"</a></div></td></tr>"&chr(10)
- end if
- end if
- f_rs_obj.close:set f_rs_obj=nothing
- if f_LableType="marnews" then
- Content_List= Content_List
- else
- Content_List=classNews_head & Content_List & Content_more & classNews_bottom
- end if
- end if
- ClassNews = Content_List
- End Function
- ''正则查找
- Public Function Test_KeyWord(f_Str,Patt)
- Dim f_regEx
- Set f_regEx = New RegExp
- f_regEx.Pattern = Patt
- f_regEx.IgnoreCase = True
- f_regEx.Global = True
- Test_KeyWord = f_regEx.test(Cstr(f_Str))
- End Function
- Public Function replace_KeyWord(f_obj,f_MF_Domain,f_Str,Patstr)
- Dim regEx,Match, Matches,f_oldStr
- f_oldStr = f_Str
- Set regEx = New RegExp
- regEx.Pattern = Patstr
- regEx.IgnoreCase = True
- regEx.Global = True
- Set Matches = regEx.Execute(Cstr(f_Str)) ' 执行搜索。
- 'Show_Html = Matches(Matches.Count-1).value 'Matches.Count-1 才是最后一个数值
- For Each Match in Matches ' 遍历 Matches 集合。
- if Match.Value<>"" then replace_KeyWord = replace_KeyWord & doregExValue(f_obj,f_MF_Domain,f_oldStr,Match.Value)
- Next
- End Function
- Public Function doregExValue(f_obj,f_MF_Domain,f_oldStr,ExValue)
- dim s_m_Rs1,k_tmp_Chararray,k_tmp_Chararray1,k_tmp_uchar,tmp_list,k_tmp_uchar1,k_tmp_uchar2,k_tmp_i
- k_tmp_Chararray = split(ExValue,"$")
- k_tmp_uchar="":tmp_list="":k_tmp_uchar1="":k_tmp_uchar2=""
- if ubound(k_tmp_Chararray)=1 then
- k_tmp_uchar = replace(k_tmp_Chararray(1),"}","")
- k_tmp_uchar=Replace(k_tmp_uchar,"&","&")
- k_tmp_uchar=Replace(k_tmp_uchar,"<","<")
- k_tmp_uchar=Replace(k_tmp_uchar,">",">")
- select case k_tmp_uchar
- case "1"
- k_tmp_uchar = "<br />"
- case "2"
- k_tmp_uchar = " "
- case "3"
- k_tmp_uchar = "</tr><tr>"
- case else
- '' $<br />:10 表示 <br />循环10次
- if instr(k_tmp_uchar,":") then
- k_tmp_Chararray1 = split(k_tmp_uchar,":")
- if ubound(k_tmp_Chararray1) = 1 then
- if k_tmp_Chararray1(1)<>"" then
- if isnumeric(k_tmp_Chararray1(1)) then
- k_tmp_uchar = ""
- for k_tmp_i=1 to cint(k_tmp_Chararray1(1))
- select case k_tmp_Chararray1(0)
- case "1"
- k_tmp_uchar2 = "<br />"
- case "2"
- k_tmp_uchar2 = " "
- case "3"
- k_tmp_uchar2 = "</tr><tr>"
- case else
- k_tmp_uchar2 = k_tmp_Chararray1(0)
- end select
- k_tmp_uchar = k_tmp_uchar & k_tmp_uchar2
- next
- end if
- end if
- end if
- end if
- end select
- end if
- set s_m_Rs1 = Conn.execute("select ID,AddressName from FS_DS_Address where DownLoadID='"&f_obj("DownLoadID")&"' order by Number desc")
- do while not s_m_Rs1.eof
- tmp_list = tmp_list & "<a href=""http://"&f_MF_Domain&"/Down.asp?DownLoadID="&f_obj("DownLoadID")&"&ID="&s_m_Rs1("ID")&""" target=""_blank"">"& s_m_Rs1("AddressName") &"</a>"
- tmp_list = tmp_list & k_tmp_uchar
- s_m_Rs1.movenext
- loop
- s_m_Rs1.close
- set s_m_Rs1=nothing
- doregExValue = replace(f_oldStr,ExValue,tmp_list)
- End Function
- '替换样式列表________________________________________________________________
- Public Function getlist_news(f_obj,style_id,f_titlenumber,f_contentnumber,f_navinumber,f_picshowtf,f_datestyle,f_openstyle,f_MF_Domain,f_subsys_ListType)
- Dim f_target,get_SpecialEName,ListSql,Rs_ListObj,s_Content,s_NewsPathUrl,Rs_Authorobj,k_i,k_tmp_Char,k_tmp_uchar,k_tmp_Chararray,FormReview
- Dim s_m_Rs,s_m_Rs1,s_array,s_t_i,tmp_list,s_f_classSql,m_Rs_class,class_path,str_newstitle
- if f_openstyle=0 then
- f_target=" "
- else
- f_target=" target=""_blank"""
- end if
- if style_id<>"" then
- ListSql = "Select Content from FS_MF_Labestyle where ID=" & style_id & ""
- Set Rs_ListObj = Conn.Execute(ListSql)
- if Not Rs_ListObj.Eof then
- s_Content = Rs_ListObj("Content")
- '_________________________________________________________________________________________________
- if instr(s_Content,"{DS:FS_ID}")>0 then
- s_Content = replace(s_Content,"{DS:FS_ID}",f_obj("Id"))
- end if
- '_________________________________________________________________________________________________
- if instr(s_Content,"{DS:FS_DownLoadID}")>0 then
- s_Content = replace(s_Content,"{DS:FS_DownLoadID}",f_obj("DownLoadID"))
- end if
- '_________________________________________________________________________________________________
- if instr(s_Content,"{DS:FS_Name}")>0 then
- if f_subsys_ListType="readnews" then
- str_newstitle = f_obj("Name")
- else
- str_newstitle =GotTopic(f_obj("Name"),f_titlenumber)
- if f_picshowtf=1 then
- if f_obj("Pic")<>"" then
- str_newstitle = ""&str_newstitle&"<img src="""&m_PathDir&"sys_images/img.gif"" alt=""有图片"" border=""0"">"
- end if
- end if
- end if
- s_Content = replace(s_Content,"{DS:FS_Name}",str_newstitle)
- end if
- dim news_SavePath,s_Query_rs,news_Domain,news_UrlDomain,news_ClassEname,s_all_savepath
- '_________________________________________________________________________________________________
- if instr(s_Content,"{DS:FS_Description}")>0 then
- if f_subsys_ListType="readnews" then
- if instr(f_obj("Description"),"[FS:PAGE]")>0 then
- s_Content = replace(s_Content,"{DS:FS_Description}","[FS:CONTENT_START]"&f_obj("Description")&"[FS:CONTENT_END]")
- else
- s_Content = replace(s_Content,"{DS:FS_Description}",""&f_obj("Description"))
- end if
- else
- s_all_savepath = get_DownLink(f_obj("DownLoadID"))
- s_NewsPathUrl = s_all_savepath
- s_Content = replace(s_Content,"{DS:FS_Description}",replace(replace(GetCStrLen(""&replace(""&f_obj("Description"),"[FS:PAGE]","")&"",f_contentnumber)," ",""),vbCrLf,"")&"... <a class=""more"" href="""& s_NewsPathUrl &""">详细内容 >> </a>")
- end if
- end if
- '_________________________________________________________________________________________________
- if instr(s_Content,"{DS:FS_DownURL}")>0 or instr(s_Content,"{DS:FS_Description}")>0 then
- s_all_savepath = get_DownLink(f_obj("DownLoadID"))
- s_NewsPathUrl = s_all_savepath
- s_Content = replace(s_Content,"{DS:FS_DownURL}",s_NewsPathUrl)
- end if
- '''下载地址列表
- '_________________________________________________________________________________________________
- if Test_KeyWord(s_Content,"{DS:FS_Address($[^{]+)?}") then
- s_Content = replace_KeyWord(f_obj,f_MF_Domain,s_Content,"{DS:FS_Address($[^{]+)?}")
- end if
- '_________________________________________________________________________________________________
- dim tmp_f_datestyle
- tmp_f_datestyle = f_datestyle
- if instr(s_Content,"{DS:FS_AddTime}")>0 then
- if instr(f_datestyle,"YY02")>0 then
- tmp_f_datestyle= replace(tmp_f_datestyle,"YY02",right(year(f_obj("AddTime")),2))
- end if
- if instr(f_datestyle,"YY04")>0 then
- tmp_f_datestyle= replace(tmp_f_datestyle,"YY04",year(f_obj("AddTime")))
- end if
- if instr(f_datestyle,"MM")>0 then
- if month(f_obj("AddTime"))<10 then
- tmp_f_datestyle= replace(tmp_f_datestyle,"MM","0"&month(f_obj("AddTime")))
- else
- tmp_f_datestyle= replace(tmp_f_datestyle,"MM",month(f_obj("AddTime")))
- end if
- end if
- if instr(f_datestyle,"DD")>0 then
- if day(f_obj("AddTime"))<10 then
- tmp_f_datestyle= replace(tmp_f_datestyle,"DD","0"&day(f_obj("AddTime")))
- else
- tmp_f_datestyle= replace(tmp_f_datestyle,"DD",day(f_obj("AddTime")))
- end if
- end if
- if instr(f_datestyle,"HH")>0 then
- if hour(f_obj("AddTime"))<10 then
- tmp_f_datestyle= replace(tmp_f_datestyle,"HH","0"&hour(f_obj("AddTime")))
- else
- tmp_f_datestyle= replace(tmp_f_datestyle,"HH",hour(f_obj("AddTime")))
- end if
- end if
- if instr(f_datestyle,"MI")>0 then
- if minute(f_obj("AddTime"))<10 then
- tmp_f_datestyle= replace(tmp_f_datestyle,"MI","0"&minute(f_obj("AddTime")))
- else
- tmp_f_datestyle= replace(tmp_f_datestyle,"MI",minute(f_obj("AddTime")))
- end if
- end if
- if instr(f_datestyle,"SS")>0 then
- if second(f_obj("AddTime"))<10 then
- tmp_f_datestyle= replace(tmp_f_datestyle,"SS","0"&second(f_obj("AddTime")))
- else
- tmp_f_datestyle= replace(tmp_f_datestyle,"SS",second(f_obj("AddTime")))
- end if
- end if
- s_Content = replace(s_Content,"{DS:FS_AddTime}",""&tmp_f_datestyle&"")
- end if
- '_________________________________________________________________________________________________
- if instr(s_Content,"{DS:FS_EditTime}")>0 then
- if instr(f_datestyle,"YY02")>0 then
- tmp_f_datestyle= replace(tmp_f_datestyle,"YY02",right(year(f_obj("EditTime")),2))
- end if
- if instr(f_datestyle,"YY04")>0 then
- tmp_f_datestyle= replace(tmp_f_datestyle,"YY04",year(f_obj("EditTime")))
- end if
- if instr(f_datestyle,"MM")>0 then
- if month(f_obj("EditTime"))<10 then
- tmp_f_datestyle= replace(tmp_f_datestyle,"MM","0"&month(f_obj("EditTime")))
- else
- tmp_f_datestyle= replace(tmp_f_datestyle,"MM",month(f_obj("EditTime")))
- end if
- end if
- if instr(f_datestyle,"DD")>0 then
- if day(f_obj("EditTime"))<10 then
- tmp_f_datestyle= replace(tmp_f_datestyle,"DD","0"&day(f_obj("EditTime")))
- else
- tmp_f_datestyle= replace(tmp_f_datestyle,"DD",day(f_obj("EditTime")))
- end if
- end if
- if instr(f_datestyle,"HH")>0 then
- if hour(f_obj("EditTime"))<10 then
- tmp_f_datestyle= replace(tmp_f_datestyle,"HH","0"&hour(f_obj("EditTime")))
- else
- tmp_f_datestyle= replace(tmp_f_datestyle,"HH",hour(f_obj("EditTime")))
- end if
- end if
- if instr(f_datestyle,"MI")>0 then
- if minute(f_obj("EditTime"))<10 then
- tmp_f_datestyle= replace(tmp_f_datestyle,"MI","0"&minute(f_obj("EditTime")))
- else
- tmp_f_datestyle= replace(tmp_f_datestyle,"MI",minute(f_obj("EditTime")))
- end if
- end if
- if instr(f_datestyle,"SS")>0 then
- if second(f_obj("EditTime"))<10 then
- tmp_f_datestyle= replace(tmp_f_datestyle,"SS","0"&second(f_obj("EditTime")))
- else
- tmp_f_datestyle= replace(tmp_f_datestyle,"SS",second(f_obj("EditTime")))
- end if
- end if
- s_Content = replace(s_Content,"{DS:FS_EditTime}",""&tmp_f_datestyle&"")
- end if
- dim ajax_str,hits_str
- '_________________________________________________________________________________________________
- if instr(s_Content,"{DS:FS_Hits}")>0 then
- hits_str = "<script language=""JavaScript"" src=""http://"&request.Cookies("FoosunMFCookies")("FoosunMFDomain")&"/Click.asp?type=ajax&SubSys=DS&spanid=DS_id_click_"&f_obj("ID")&"""></script>"&chr(10)
- s_Content = replace(s_Content,"{DS:FS_Hits}",""& hits_str & "<span id=""DS_id_click_"&f_obj("ID")&"""></span>")
- end if
- '_________________________________________________________________________________________________
- if instr(s_Content,"{DS:FS_ClickNum}")>0 then
- hits_str = "<script language=""JavaScript"" src=""http://"&request.Cookies("FoosunMFCookies")("FoosunMFDomain")&"/Click.asp?type=ajax&SubSys=DS&Get=ClickNum&spanid=DS_id_click_"&f_obj("ID")&"""></script>"&chr(10)
- s_Content = replace(s_Content,"{DS:FS_ClickNum}",""& hits_str & "<span id=""DS_id_click_"&f_obj("ID")&"""></span>")
- end if
- '_________________________________________________________________________________________________
- if instr(s_Content,"{DS:FS_SystemType}")>0 then
- s_Content = replace(s_Content,"{DS:FS_SystemType}",""&f_obj("SystemType")&"")
- end if
- '_________________________________________________________________________________________________
- if instr(s_Content,"{DS:FS_Accredit}")>0 then
- s_Content = replace(s_Content,"{DS:FS_Accredit}",""&Replacestr(f_obj("Accredit"),"1:免费,2:共享,3:试用,4:演示,5:注册,6:破解,7:零售,8:其它")&"")
- end if
- '_________________________________________________________________________________________________
- if instr(s_Content,"{DS:FS_Version}")>0 then
- s_Content = replace(s_Content,"{DS:FS_Version}",""&f_obj("Version")&"")
- end if
- '_________________________________________________________________________________________________
- if instr(s_Content,"{DS:FS_Appraise}")>0 then
- dim db_ii,Str_Tmp,ii_
- db_ii = f_obj("Appraise")
- if db_ii = "" or isnull(db_ii) then db_ii = 0
- if db_ii>6 then db_ii=6
- Str_Tmp = ""
- for ii_ = 1 to db_ii
- Str_Tmp = Str_Tmp & "<img border=0 src=""/sys_images/icon_star_2.gif"" title="""&f_obj("Appraise")&"星"">"
- next
- for ii_ = 1 to 6 - db_ii
- Str_Tmp = Str_Tmp & "<img border=0 src=""/sys_images/icon_star_1.gif"" title="""&f_obj("Appraise")&"星"">"
- next
- s_Content = replace(s_Content,"{DS:FS_Appraise}",""&Str_Tmp&"")
- end if
- '_________________________________________________________________________________________________
- if instr(s_Content,"{DS:FS_FileSize}")>0 then
- s_Content = replace(s_Content,"{DS:FS_FileSize}",""&f_obj("FileSize")&"")
- end if
- '_________________________________________________________________________________________________
- if instr(s_Content,"{DS:FS_Language}")>0 then
- s_Content = replace(s_Content,"{DS:FS_Language}",""&f_obj("Language")&"")
- end if
- '_________________________________________________________________________________________________
- if instr(s_Content,"{DS:FS_PassWord}")>0 then
- s_Content = replace(s_Content,"{DS:FS_PassWord}",""&f_obj("PassWord")&"")
- end if
- '_________________________________________________________________________________________________
- if instr(s_Content,"{DS:FS_Provider}")>0 then
- s_Content = replace(s_Content,"{DS:FS_Provider}",""&f_obj("Provider")&"")
- end if
- '_________________________________________________________________________________________________
- if instr(s_Content,"{DS:FS_ProviderUrl}")>0 then
- s_Content = replace(s_Content,"{DS:FS_ProviderUrl}",""&f_obj("ProviderUrl")&"")
- end if
- '_________________________________________________________________________________________________
- if instr(s_Content,"{DS:FS_EMail}")>0 then
- s_Content = replace(s_Content,"{DS:FS_EMail}","<a href=""mailto:"&f_obj("EMail")&""">"&f_obj("EMail")&"</a>")
- end if
- '_________________________________________________________________________________________________
- if instr(s_Content,"{DS:FS_Types}")>0 then
- s_Content = replace(s_Content,"{DS:FS_Types}",""&f_obj("Types")&"")
- end if
- '_________________________________________________________________________________________________
- if instr(s_Content,"{DS:FS_OverDue}")>0 then
- if f_obj("OverDue")=0 then
- s_Content = replace(s_Content,"{DS:FS_OverDue}","永不过期")
- else
- s_Content = replace(s_Content,"{DS:FS_OverDue}",""&f_obj("OverDue")&"天")
- end if
- end if
- '_________________________________________________________________________________________________
- if instr(s_Content,"{DS:FS_ConsumeNum}")>0 then
- s_Content = replace(s_Content,"{DS:FS_ConsumeNum}",""&f_obj("ConsumeNum")&"")
- end if
- '_________________________________________________________________________________________________
- if instr(s_Content,"{DS:FS_Pic}")>0 then
- if trim(f_obj("Pic"))<>"" then
- s_Content = replace(s_Content,"{DS:FS_Pic}",f_obj("Pic"))
- else
- s_Content = replace(s_Content,"{DS:FS_Pic}","/sys_images/NoPic.jpg")
- end if
- end if
- '_________________________________________________________________________________________________
- if instr(s_Content,"{DS:FS_FormReview}")>0 then
- s_Content = replace(s_Content,"{DS:FS_FormReview}","<span id=""Review_TF_"& f_obj("ID") &""">loading...</span><script language=""JavaScript"" type=""text/javascript"" src=""http://"&Request.Cookies("FoosunMFCookies")("FoosunMFDomain")&"/ReviewTF.asp?Id="& f_obj("ID") &"&Type=DS""></script>")
- end if
- '_________________________________________________________________________________________________
- If instr(s_Content,"{DS:FS_ShowComment}")>0 Then
- s_Content = replace(s_Content,"{DS:FS_ShowComment}","<span id=""DS_show_review_"& f_obj("ID") &""">评论加载中...</span><script language=""JavaScript"" type=""text/javascript"" src=""http://"&Request.Cookies("FoosunMFCookies")("FoosunMFDomain")&"/ShowReview.asp?Id="&f_obj("ID")&"&Type=DS&SpanId=DS_show_review_"& f_obj("ID") &"""></script>")
- End If
- '_________________________________________________________________________________________________
- if instr(s_Content,"{DS:FS_AddFavorite}")>0 then
- s_Content = replace(s_Content,"{DS:FS_AddFavorite}","<a href=""http://"& Request.Cookies("FoosunMFCookies")("FoosunMFDomain")&"/User/AddFavor.asp?Id="&f_obj("id")&"&Type=ds""><img src="""& m_PathDir &"sys_images/Favorite.gif"" border=""0"" alt=""加入收藏夹""></a>")
- end if
- '_________________________________________________________________________________________________
- if instr(s_Content,"{DS:FS_SendFriend}")>0 then
- s_Content = replace(s_Content,"{DS:FS_SendFriend}","<a href=""http://"& Request.Cookies("FoosunMFCookies")("FoosunMFDomain") &"/Sendmail.asp?Id="&f_obj("id")&"&Type=ds""><img src="""& m_PathDir &"sys_images/sendmail.gif"" border=""0"" alt=""发送给好友""></a>")
- end if
- '获得栏目地址_______________________________________________________________________________________________
- s_f_classSql = "select ClassID,ClassName,ClassEName,[Domain],ClassNaviContent,ClassNaviPic,SavePath,FileSaveType,ClassKeywords,Classdescription,FileExtName from FS_DS_Class where ClassId='"&f_obj("ClassId")&"' and ReycleTF=0 order by OrderID desc,id desc"
- if instr(s_Content,"{DS:FS_ClassURL}")>0 then
- class_path=get_ClassLink(f_obj("ClassId"))
- s_Content = replace(s_Content,"{DS:FS_ClassURL}",class_path)
- end if
- if instr(s_Content,"{DS:FS_ClassName}")>0 then
- set m_Rs_class = Conn.execute(s_f_classSql)
- s_Content = replace(s_Content,"{DS:FS_ClassName}",""&m_Rs_class("ClassName")&"")
- m_Rs_class.close:set m_Rs_class=nothing
- end if
- if instr(s_Content,"{DS:FS_ClassNaviPicURL}")>0 then
- set m_Rs_class = Conn.execute(s_f_classSql)
- if trim(m_Rs_class("ClassNaviPic"))<>"" then
- s_Content = replace(s_Content,"{DS:FS_ClassNaviPicURL}",""& m_Rs_class("ClassNaviPic") &"")
- else
- s_Content = replace(s_Content,"{DS:FS_ClassNaviPicURL}","")
- end if
- m_Rs_class.close:set m_Rs_class=nothing
- end if
- if instr(s_Content,"{DS:FS_ClassNaviDescript}")>0 then
- set m_Rs_class = Conn.execute(s_f_classSql)
- if trim(m_Rs_class("ClassNaviContent"))<>"" then
- s_Content = replace(s_Content,"{DS:FS_ClassNaviDescript}",""& m_Rs_class("ClassNaviContent") &"")
- else
- s_Content = replace(s_Content,"{DS:FS_ClassNaviDescript}","")
- end if
- m_Rs_class.close:set m_Rs_class=nothing
- end if
- if instr(s_Content,"{DS:FS_ClassNaviContent}")>0 then
- set m_Rs_class = Conn.execute(s_f_classSql)
- s_Content = replace(s_Content,"{DS:FS_ClassNaviContent}",""&m_Rs_class("ClassNaviContent"))
- m_Rs_class.close:set m_Rs_class=nothing
- end if
- if instr(s_Content,"{DS:FS_ClassKeywords}")>0 then
- set m_Rs_class = Conn.execute(s_f_classSql)
- s_Content = replace(s_Content,"{DS:FS_ClassKeywords}",""&m_Rs_class("ClassKeywords"))
- m_Rs_class.close:set m_Rs_class=nothing
- end if
- if instr(s_Content,"{DS:FS_Classdescription}")>0 then
- set m_Rs_class = Conn.execute(s_f_classSql)
- s_Content = replace(s_Content,"{DS:FS_Classdescription}",""&m_Rs_class("Classdescription"))
- m_Rs_class.close:set m_Rs_class=nothing
- end if
- '这里暂时用*代替
- '释放对象
- Rs_ListObj.close:set Rs_ListObj=nothing
- else
- m_Err_Info = "DS警告:此下载找不到样式,没生成"
- m_Err_No="DS:nostyle"
- s_Content=""
- Rs_ListObj.close:set Rs_ListObj=nothing
- end if
- else
- m_Err_Info = "DS警告:找不到此下载"
- m_Err_No="DS:nodata"
- s_Content=""
- end if
- getlist_news = s_Content
- End Function
- '开始读取标签____下载终极类标签_____________________________________________________________________
- Public Function ClassList(f_Lablechar,f_type,f_Id)
- if f_Id<>"" then
- dim table_array,div_tf,newnumber,datenumber,titlenumber,picshowtf,openstyle,orderby,orderdesc,pageTF,pagestyle,pagenumber,pagecss,datestyle,style_id,colnumber,contentnumber,navinumber
- dim classNews_head,classNews_bottom,classNews_middle1,classNews_middle2,search_inSQL,order_in_str_awen
- dim datenumber_tmp,f_sql,f_configsql,f_rs_obj,f_rs_configobj,MF_Domain
- dim TPageNum,perPageNum,PageNum,sPageCount,cl_i,c_i_k
- dim rs_c,RefreshNumber,Page_flag_TF
- table_array=split(f_Lablechar,"┆")
- m_Err_Info = ""
- if instr(f_Lablechar,"out_DIV")>0 then
- div_tf=1
- datenumber= split(split(f_Lablechar,"┆")(9),"$")(1)
- titlenumber= split(split(f_Lablechar,"┆")(10),"$")(1)
- picshowtf=split(split(f_Lablechar,"┆")(11),"$")(1)
- openstyle=split(split(f_Lablechar,"┆")(12),"$")(1)
- orderby = split(split(f_Lablechar,"┆")(14),"$")(1)
- orderdesc = split(split(f_Lablechar,"┆")(15),"$")(1)
- pageTF = split(split(f_Lablechar,"┆")(16),"$")(1)
- pagestyle = split(split(f_Lablechar,"┆")(17),"$")(1)
- pagenumber = split(split(f_Lablechar,"┆")(18),"$")(1)
- pagecss = split(split(f_Lablechar,"┆")(19),"$")(1)
- datestyle = split(split(f_Lablechar,"┆")(20),"$")(1)
- style_id = split(split(f_Lablechar,"┆")(21),"$")(1)
- colnumber= split(split(f_Lablechar,"┆")(22),"$")(1)
- contentnumber= split(split(f_Lablechar,"┆")(23),"$")(1)
- else
- div_tf=0
- datenumber= split(split(f_Lablechar,"┆")(3),"$")(1)
- titlenumber= split(split(f_Lablechar,"┆")(4),"$")(1)
- picshowtf=split(split(f_Lablechar,"┆")(5),"$")(1)
- openstyle=split(split(f_Lablechar,"┆")(6),"$")(1)
- orderby = split(split(f_Lablechar,"┆")(8),"$")(1)
- orderdesc = split(split(f_Lablechar,"┆")(9),"$")(1)
- pageTF = split(split(f_Lablechar,"┆")(10),"$")(1)
- pagestyle = split(split(f_Lablechar,"┆")(11),"$")(1)
- pagenumber = split(split(f_Lablechar,"┆")(12),"$")(1)
- pagecss = split(split(f_Lablechar,"┆")(13),"$")(1)
- datestyle = split(split(f_Lablechar,"┆")(14),"$")(1)
- style_id = split(split(f_Lablechar,"┆")(15),"$")(1)
- colnumber= split(split(f_Lablechar,"┆")(16),"$")(1)
- contentnumber= split(split(f_Lablechar,"┆")(17),"$")(1)
- end if
- 'if div_tf=1 then
- classNews_head = table_str_list_head(div_tf,split(table_array(3),"$")(1),split(table_array(4),"$")(1),split(table_array(5),"$")(1),split(table_array(6),"$")(1))
- classNews_middle1 = table_str_list_middle_1(div_tf,split(table_array(7),"$")(1),split(table_array(8),"$")(1))
- 'end if
- classNews_bottom = table_str_list_bottom(div_tf)
- classNews_middle2 = table_str_list_middle_2(div_tf)
- Page_flag_TF = "{Foosun_Page_news}"& pagestyle &"|"& pagecss&"{/Foosun_Page_news}"
- ''永不过期和尚未到期的
- datenumber_tmp=" and (OverDue=0 or (OverDue>0 and datediff('d',AddTime,'"&date()&"')<= OverDue))"
- if datenumber ="0" then:datenumber_tmp = "":else:datenumber_tmp = " and datevalue(AddTime)+"&datenumber&">=datevalue(now)":end if
- ''已经在外部定义好了。
- order_in_str_awen = ""&orderby&" "&orderdesc&""
- if ucase(orderby)<>"ID" then order_in_str_awen = order_in_str_awen & ",ID Desc"
- ''top多少条
- set rs_c=conn.execute("select RefreshNumber from FS_DS_Class where ClassId='"& f_Id &"'")
- if rs_c.eof then
- RefreshNumber = ""
- rs_c.close:set rs_c = nothing
- else
- if rs_c(0)=0 then
- RefreshNumber = ""
- else
- RefreshNumber = "top "&rs_c(0)&""
- end if
- rs_c.close:Set rs_c=nothing
- end if
- search_inSQL=" and ClassId='"& f_Id &"'"
- f_sql="select "& RefreshNumber &" ID,DownLoadID,ClassID,Description,Accredit,AddTime,Appraise,AuditTF,BrowPop," _
- &"ClickNum,EditTime,EMail,SavePath,FileExtName,FileName,FileSize,Language,Name,NewsTemplet,PassWord,Pic," _
- &"Property,Provider,ProviderUrl,RecTF,ReviewTF,ShowReviewTF,SystemType,Types,Version,OverDue,ConsumeNum,Hits"
- f_sql = f_sql &" From FS_DS_List where AuditTF=1 "&search_inSQL & datenumber_tmp &" order by "&order_in_str_awen
- Set f_rs_obj = Server.CreateObject(G_FS_RS)
- f_rs_obj.open f_sql,Conn,1,3
- MF_Domain = Request.Cookies("FoosunMFCookies")("FoosunMFDomain")
- ClassList = ""
- if f_rs_obj.eof then
- ClassList = ""
- f_rs_obj.close:set f_rs_obj=nothing
- else
- perPageNum =pagenumber
- TPageNum = f_rs_obj.recordcount
- f_rs_obj.PageSize = perPageNum
- sPageCount = f_rs_obj.PageCount
- if div_tf = 0 then
- c_i_k = 0
- if cint(colnumber)<>1 then
- ClassList = ClassList & " <tr>"
- end if
- end if
- for cl_i=1 to f_rs_obj.recordcount
- if f_rs_obj.eof Then exit For
- if div_tf=1 then
- ClassList= ClassList & classNews_middle1 & getlist_news(f_rs_obj,style_id,titlenumber,contentnumber,navinumber,picshowtf,datestyle,openstyle,MF_Domain,"ClassList") & classNews_middle2
- else
- if cint(colnumber) =1 then
- ClassList= ClassList &" <tr><td>" & getlist_news(f_rs_obj,style_id,titlenumber,contentnumber,navinumber,picshowtf,datestyle,openstyle,MF_Domain,"ClassList") & "</td></tr>"
- else
- ClassList= ClassList & "<td width="""& cint(100/cint(colnumber))&"%"">" & getlist_news(f_rs_obj,style_id,titlenumber,contentnumber,navinumber,picshowtf,datestyle,openstyle,MF_Domain,"ClassList") & "</td>"
- end if
- end if
- f_rs_obj.movenext
- if div_tf = 0 then
- if cint(colnumber)<>1 then
- c_i_k = c_i_k+1
- if c_i_k mod cint(colnumber) = 0 then
- ClassList = ClassList & "</tr>"&chr(10)&" <tr>"
- end if
- end if
- dim tmp_1
- if pageTF="1" then
- 'if cint(colnumber) =1 then
- ' tmp_1 = ""
- 'else
- ' tmp_1 = "</tr>"&chr(10)
- 'end if
- if split(formatnumber(cl_i/f_rs_obj.pagesize,2,-1),".")(1)="00" and cl_i <> f_rs_obj.recordcount then
- ClassList = ClassList &"</table>"& Page_flag_TF & chr(10) & classNews_head
- end if
- if cl_i = f_rs_obj.recordcount then
- ClassList = ClassList &"</table>"& Page_flag_TF
- end if
- end if
- else
- if pageTF="1" then
- if split(formatnumber(cl_i/f_rs_obj.pagesize,2,-1),".")(1)="00" and cl_i <> f_rs_obj.recordcount then
- ClassList = ClassList & classNews_bottom & Page_flag_TF & chr(10) & classNews_head
- end if
- if cl_i = f_rs_obj.recordcount then
- ClassList = ClassList & classNews_bottom & Page_flag_TF &chr(10)
- end if
- end if
- end if
- next
- if div_tf=0 then
- if cint(colnumber)<>1 then
- ClassList = ClassList & "</tr>"&chr(10)
- end if
- end if
- f_rs_obj.close:set f_rs_obj=nothing
- ClassList=classNews_head & ClassList
- end if
- else
- ClassList = ""
- end if
- ' if ClassList<>"" then
- ' if Not f_type="marnews" then
- ' ClassList=classNews_head & ClassList & classNews_middle1 & classNews_middle2 & classNews_bottom
- ' end if
- ' end if
- End Function
- '得到子类新闻列表
- 'subClassList┆图片新闻$0┆Loop$10┆输出格式$out_Table┆多少天$0┆标题数$30┆图文标志$1┆打开窗口$0┆包含子类$0┆排列字段$PopId┆排列方式$DESC┆分页$1┆分页样式$3,CC0066┆每页数量$30┆PageCSS$┆日期格式$YY02年MM月DD日┆引用样式$40┆背景底纹$┆栏目排列数$1┆新闻排列数$1┆内容字数$200┆导航字数$200
- 'subClassList┆图片新闻$0┆Loop$10┆输出格式$out_DIV┆DivID$┆DivClass$┆ulid$┆ulclass$┆liid$┆liclass$┆多少天$0┆标题数$30┆图文标志$1┆打开窗口$0┆包含子类$0┆排列字段$PopId┆排列方式$DESC┆分页$1┆分页样式$3,CC0066┆每页数量$30┆PageCSS$┆日期格式$YY02年MM月DD日┆引用样式$40┆背景底纹$┆栏目排列数$1┆新闻排列数$1┆内容字数$200┆导航字数$200
- 'picnewstf = split(split(f_Lablechar,"┆")(1),"$")(1)
- Public Function subClassList(f_Lablechar,f_type,f_Id)
- dim rs,f_sql,rs_n,rs_f_sql
- dim div_tf,c_s_i,bg_ground,c_cols,c_cols_1,datenumber,datenumber_tmp,orderby,orderdesc,style_id,Inc_SubClass,SQL_Inc_SubClass
- dim titlenumber,contentnumber,navinumber,picshowtf,datestyle,openstyle,MF_Domain,loopnumber
- dim classNews_head,classNews_middle1,classNews_bottom,classNews_middle2,c_s_i_1,table_array
- if instr(f_Lablechar,"out_DIV")>0 then
- div_tf=1
- c_cols = split(split(f_Lablechar,"┆")(24),"$")(1)
- c_cols_1 = split(split(f_Lablechar,"┆")(25),"$")(1)
- bg_ground = split(split(f_Lablechar,"┆")(23),"$")(1)
- datenumber = split(split(f_Lablechar,"┆")(10),"$")(1)
- orderby = split(split(f_Lablechar,"┆")(15),"$")(1)
- orderdesc = split(split(f_Lablechar,"┆")(16),"$")(1)
- style_id = split(split(f_Lablechar,"┆")(22),"$")(1)
- loopnumber = split(split(f_Lablechar,"┆")(2),"$")(1)
- titlenumber = split(split(f_Lablechar,"┆")(11),"$")(1)
- contentnumber = split(split(f_Lablechar,"┆")(26),"$")(1)
- picshowtf = split(split(f_Lablechar,"┆")(12),"$")(1)
- datestyle = split(split(f_Lablechar,"┆")(21),"$")(1)
- openstyle = split(split(f_Lablechar,"┆")(13),"$")(1)
- Inc_SubClass = split(split(f_Lablechar,"┆")(8),"$")(1)
- else
- div_tf=0
- c_cols = split(split(f_Lablechar,"┆")(18),"$")(1) ''栏目排列数
- c_cols_1 = split(split(f_Lablechar,"┆")(19),"$")(1) ''新闻排列数
- bg_ground = split(split(f_Lablechar,"┆")(17),"$")(1) ''背景底纹
- datenumber = split(split(f_Lablechar,"┆")(4),"$")(1) ''多少天
- orderby = split(split(f_Lablechar,"┆")(9),"$")(1) ''排列字段
- orderdesc = split(split(f_Lablechar,"┆")(10),"$")(1) ''排列方式
- style_id = split(split(f_Lablechar,"┆")(16),"$")(1) ''日期引用样式
- loopnumber = split(split(f_Lablechar,"┆")(2),"$")(1) ''Loop
- titlenumber = split(split(f_Lablechar,"┆")(5),"$")(1) ''标题数
- contentnumber = split(split(f_Lablechar,"┆")(20),"$")(1) ''内容字数
- picshowtf = split(split(f_Lablechar,"┆")(6),"$")(1) ''图文标志
- datestyle = split(split(f_Lablechar,"┆")(15),"$")(1) ''日期格式
- openstyle = split(split(f_Lablechar,"┆")(7),"$")(1) ''打开窗口方式
- Inc_SubClass = split(split(f_Lablechar,"┆")(8),"$")(1) ''是否包含子类
- end if
- if not isnumeric(titlenumber) then:titlenumber = 30:else:titlenumber = cint(titlenumber):end if
- if not isnumeric(loopnumber) then:loopnumber = 10:else:loopnumber = cint(loopnumber):end if
- MF_Domain = Request.Cookies("FoosunMFCookies")("FoosunMFDomain")
- table_array=split(f_Lablechar,"┆")
- classNews_head = table_str_list_head(div_tf,split(table_array(4),"$")(1),split(table_array(5),"$")(1),split(table_array(6),"$")(1),split(table_array(7),"$")(1))
- classNews_middle1 = table_str_list_middle_1(div_tf,split(table_array(8),"$")(1),split(table_array(9),"$")(1))
- classNews_bottom = table_str_list_bottom(div_tf)
- classNews_middle2 = table_str_list_middle_2(div_tf)
- if len(bg_ground)>5 then
- bg_ground = " background="""& bg_ground &""""
- else
- bg_ground = ""
- end If
- if datenumber <>"0" then:datenumber_tmp = " and datevalue(addtime)+"&datenumber&">=datevalue(now)":else:datenumber_tmp = "":end if
- if f_Id="" then f_id="0"
- f_sql = "select ClassId,ClassName,ClassEName,ParentID From FS_DS_Class Where ParentID='"& f_Id &"' and IsURL=0 and ReycleTF=0 order by OrderID desc,id desc"
- set rs = Conn.execute(f_sql)
- if not rs.eof then
- subClassList = "<table border=""0"" cellspacing=""3"" cellpadding=""0"" width=""100%"">"&vbNewLine&" <tr>"
- c_s_i = 0
- do while not rs.eof
- If (c_s_i mod c_cols =0) And c_s_i>0 Then
- subClassList = subClassList & "</tr>"&vbNewLine&"<tr>"&vbNewLine
- End If
- subClassList = subClassList & "<td width="""&cint(100/c_cols)&"%"" valign=""top"" style=""BORDER-RIGHT: #D18989 1px solid; BORDER-TOP: #D18989 1px solid; BORDER-LEFT: #D18989 1px solid; BORDER-BOTTOM: #D18989 1px solid""><table border=""0"" cellspacing=""0"" cellpadding=""0"" width=""100%"""& bg_ground &"><tr><td height=""26"" width=""80%"" class=""dldh""> >> <a class=""dldh"" href="""& get_ClassLink(rs("ClassId"))&""">"&rs("ClassName")&"</a></td><td align=""center"" width=""20%""><a href="""& get_ClassLink(rs("ClassId"))&"""><img src=""http://"& Request.Cookies("FoosunMFCookies")("FoosunMFDomain") &"/sys_images/news_more.gif"" border=""0"" alt="""& rs("ClassName") &"..更多""></a></td></tr></table>"
- If Inc_SubClass="1" Then
- If getNewsSubClass(rs("ClassId"))<>"" Then
- SQL_Inc_SubClass=" and (ClassID='"&rs("ClassId")&"' OR ClassID IN ("&getNewsSubClass(rs("ClassId"))&"))"
- Else
- SQL_Inc_SubClass=" AND ClassID='"&rs("ClassId")&"'"
- End If
- Else
- SQL_Inc_SubClass=" AND ClassID='"&rs("ClassId")&"'"
- End If
- rs_f_sql = "select top "& loopnumber &" * From FS_DS_List where AuditTF=1 "& datenumber_tmp & SQL_Inc_SubClass &" order by "&orderby&" "&orderdesc
- if ucase(orderby)<>"ID" then rs_f_sql = rs_f_sql&",id "&orderdesc&""
- set rs_n = Conn.execute(rs_f_sql)
- If Not rs_n.eof then
- if div_tf=1 then
- subClassList = subClassList & vbNewLine & classNews_head
- end if
- do while not rs_n.eof
- If div_tf = 1 Then
- subClassList = subClassList & classNews_middle1 &getlist_news(rs_n,style_id,titlenumber,contentnumber,navinumber,picshowtf,datestyle,openstyle,MF_Domain,"subClassList")&classNews_middle2
- Else
- subClassList = subClassList & "<div>" & getlist_news(rs_n,style_id,titlenumber,contentnumber,navinumber,picshowtf,datestyle,openstyle,MF_Domain,"subClassList")&"<div>"&vbNewLine
- End If
- rs_n.movenext
- loop
- if div_tf=1 then
- subClassList = subClassList & classNews_bottom
- end if
- end If
- subClassList = subClassList & "</td>"&vbNewLine
- rs.movenext
- c_s_i = c_s_i + 1
- Loop
- If c_s_i Mod 2 <>0 Then
- subClassList = subClassList & "<td width="""&cint(100/c_cols)&"%"" valign=""top""></td>"&vbNewLine
- End If
- rs.close:set rs = Nothing
- rs_n.close:set rs_n = nothing
- subClassList = subClassList & "</tr>"&vbNewLine&"</table>"&vbNewLine
- else
- subClassList = ""
- end If
- End Function
- '得到下载浏览________________________________________________________________
- Public Function ReadNews(f_Lablechar,f_type,f_Id)
- Dim styleId,ReadSql,RsReadObj
- Dim MF_Domain,datestyle
- styleId = split(split(f_Lablechar,"┆")(1),"$")(1)
- datestyle = split(split(f_Lablechar,"┆")(2),"$")(1)
- ReadNews = ""
- if trim(f_Id)="" then
- ReadNews = ""
- else
- ReadSql="select ID,DownLoadID,ClassID,Description,Accredit,AddTime,Appraise,AuditTF,BrowPop," _
- &"ClickNum,EditTime,EMail,SavePath,FileExtName,FileName,FileSize,Language,Name,NewsTemplet,PassWord,Pic," _
- &"Property,Provider,ProviderUrl,RecTF,ReviewTF,ShowReviewTF,SystemType,Types,Version,OverDue,ConsumeNum,Hits"
- ReadSql = ReadSql &" From FS_DS_List where AuditTF=1 and DownLoadID='"& f_Id &"' and (OverDue=0 or (OverDue>0 and datediff('d',AddTime,'"&date()&"')<= OverDue)) "
- Set RsReadObj = Server.CreateObject(G_FS_RS)
- RsReadObj.open ReadSql,Conn,1,1
- MF_Domain = Request.Cookies("FoosunMFCookies")("FoosunMFDomain")
- if not RsReadObj.eof then
- ReadNews = ReadNews&getlist_news(RsReadObj,styleId,0,0,0,0,datestyle,0,MF_Domain,"readnews")
- else
- ReadNews =""
- end if
- end if
- ReadNews=ReadNews
- End Function
- '站点地图____________________________________________________________________
- Public Function SiteMap(f_Lablechar,f_type,f_Id)
- dim classId,cssstyle,SiteMapstr,RsClassObj,i,br_str
- classId = split(split(f_Lablechar,"┆")(1),"$")(1)
- cssstyle = split(split(f_Lablechar,"┆")(2),"$")(1)
- SiteMapstr = ""
- set RsClassObj = Conn.execute("select ClassId,ClassName,ClassEName,IsURL,ParentID From FS_DS_Class where ReycleTF=0 and ParentID='0' order by OrderID desc,id desc")
- if Not RsClassObj.eof then
- i=0
- do while Not RsClassObj.eof
- if RsClassObj("ParentID")<>"0" then
- if i=0 then
- br_str=""
- else
- br_str="<br />"
- end if
- else
- if i=0 then
- br_str=""
- else
- br_str="<br />"
- end if
- end if
- if cssstyle<>"" then
- SiteMapstr = SiteMapstr & br_str & "<img src="""&m_PathDir&"sys_images/+.gif"" border=""0"" /><a href="""&get_ClassLink(RsClassObj("ClassId"))&""" class="""& cssstyle &""">"&RsClassObj("ClassName")&"</a>"&chr(10)
- else
- SiteMapstr = SiteMapstr & br_str & "<img src="""&m_PathDir&"sys_images/+.gif"" border=""0"" /><a href="""&get_ClassLink(RsClassObj("ClassId"))&""">"&RsClassObj("ClassName")&"</a>"&chr(10)
- end if
- SiteMapstr = SiteMapstr & get_ClassList(RsClassObj("ClassId")," ",cssstyle)
- RsClassObj.movenext
- i=i+1
- loop
- RsClassObj.close:set RsClassObj=nothing
- else
- SiteMapstr = ""
- RsClassObj.close:set RsClassObj=nothing
- end if
- SiteMap = SiteMapstr
- End Function
- '得到搜索表单________________________________________________________________
- Public Function Search(f_Lablechar,f_type)
- dim Searchstr,showdate,showClass,rs,select_str,datestr,classstr,MF_Domain
- showdate = split(split(f_Lablechar,"┆")(1),"$")(1)
- showClass = split(split(f_Lablechar,"┆")(2),"$")(1)
- MF_Domain = Request.Cookies("FoosunMFCookies")("FoosunMFDomain")
- Searchstr = ""
- if showdate = "1" then
- datestr = "开始日期:<input name=""s_date"" type=""text"" value="""" size=""10"" /> 结束日期:<input name=""e_date"" type=""text"" value="""" size=""10"" />"
- else
- datestr = ""
- end if
- if showClass = "1" then
- classstr = " <select name=""ClassId"" id=""ClassId"">"
- classstr = classstr&"<option value="""">--所有--</option>"&chr(10)
- set rs = Conn.execute("select ClassId,id,classname,classEname,ParentId From FS_DS_Class where ReycleTF=0 and isURL=0 and ParentId='0' order by OrderId desc,id desc")
- do while not rs.eof
- classstr = classstr & "<option value="""&rs("ClassId")&""">┝"&rs("classname")&"</option>"&chr(10)
- classstr = classstr & get_optionNewsList(rs("ClassId"),"┝")&chr(10)
- rs.movenext
- loop
- rs.close:set rs=nothing
- classstr = classstr&"</select>"
- else
- classstr = ""
- end if
- select_str =" <select name=""s_type"" id=""s_type"">"&chr(10)
- select_str=select_str&"<option value=""title"" selected=""selected"">标题</option>"&chr(10)
- select_str=select_str&"<option value=""content"">全文</option>"&chr(10)
- select_str=select_str&"</select>"&chr(10)
- Searchstr = Searchstr & "<table width=""100%""><form action=""http://"& MF_Domain & "/Search.html"" id=""SearchForm"" name=""SearchForm"" method=""get"">" _
- &"<tr><td><input name=""SubSys"" type=""hidden"" id=""SubSys"" value=""DS"" /><input name=""Keyword"" type=""text"" id=""Keyword"" size=""15"" /> " _
- &select_str&datestr&classstr&" <input type=""submit"" value=""搜索"" /></td></tr></form></table>"
- Search = Searchstr
- End Function
- '得到统计信息_______________________________________________________________
- Public Function infoStat(f_Lablechar,f_type)
- dim cols,br_str,infoStatstr
- cols = split(split(f_Lablechar,"┆")(1),"$")(1)
- if cols="0" then
- br_str = " "
- else
- br_str = "<br />"
- end if
- dim rs,c_rs1,c_rs2,c_rs3,c_rs4,c_rs5
- set rs = Conn.execute("select count(id) From FS_DS_List where AuditTF=1 and (OverDue=0 or (OverDue>0 and datediff('d',AddTime,'"&date()&"')<= OverDue))")
- c_rs1=rs(0)
- rs.close:set rs=nothing
- set rs = Conn.execute("select count(id) From FS_DS_Class where ReycleTF=0")
- c_rs2=rs(0)
- rs.close:set rs=nothing
- set rs = User_Conn.execute("select count(Userid) From FS_ME_Users")
- c_rs4=rs(0)
- rs.close:set rs=nothing
- if G_IS_SQL_User_DB=0 then
- set rs = User_Conn.execute("select count(Userid) From FS_ME_Users where datevalue(RegTime)=#"&datevalue(date)&"#")
- else
- set rs = User_Conn.execute("select count(Userid) From FS_ME_Users where datevalue(RegTime)='"&datevalue(date)&"'")
- end if
- c_rs5=rs(0)
- rs.close:set rs=nothing
- infoStatstr = "总下载:"&"<strong>"&c_rs1&"</strong>"&br_str
- infoStatstr = infoStatstr &"总栏目:"&"<strong>"&c_rs2&"</strong>"&br_str
- infoStatstr = infoStatstr &"会员数:"&"<strong>"&c_rs4&"</strong>"&br_str
- infoStatstr = infoStatstr &"今日注册:"&"<strong>"&c_rs5&"</strong>"&br_str
- infoStat = infoStatstr
- End Function
- '栏目导航____________________________________________________________________
- Public Function ClassNavi(f_Lablechar,f_type,f_Id)
- 'ClassNavi┆输出方式$out_Table┆栏目$┆方向$0┆DivID$┆Divclass$┆ulid$┆ulclass$┆liid$┆liclass$┆标题CSS$┆标题导航$·
- dim ClassId,cols,titlecss,rs,ClassNavistr,ParentIDstr,cols_str,div_tf,table_array
- dim classNews_head,classNews_bottom,classNews_middle1,classNews_middle2,cssstyle,titleNavi
- table_array=split(f_Lablechar,"┆")
- ClassId = split(split(f_Lablechar,"┆")(2),"$")(1)
- cols = split(split(f_Lablechar,"┆")(3),"$")(1)
- titlecss = split(split(f_Lablechar,"┆")(10),"$")(1)
- if instr(f_Lablechar,"out_DIV")>0 then
- div_tf = 1
- cssstyle = ""
- else
- div_tf=0
- if titlecss<>"" then
- cssstyle = " Class="""& titlecss &""""
- else
- cssstyle = ""
- end if
- titleNavi = split(split(f_Lablechar,"┆")(11),"$")(1)
- end if
- if div_tf=1 then
- classNews_head = table_str_list_head(div_tf,split(table_array(4),"$")(1),split(table_array(5),"$")(1),split(table_array(6),"$")(1),split(table_array(7),"$")(1))
- classNews_middle1 = table_str_list_middle_1(div_tf,split(table_array(8),"$")(1),split(table_array(9),"$")(1))
- end if
- classNews_bottom = table_str_list_bottom(div_tf)
- classNews_middle2 = table_str_list_middle_2(div_tf)
- if trim(ClassId)<>"" then
- ParentIDstr = " and ParentId = '"& ClassId&"'"
- else
- if f_id<>"" then
- ParentIDstr = " and ParentId = '"& f_Id&"'"
- else
- ParentIDstr = " and ParentId = '0'"
- end if
- end if
- set rs = Conn.execute("select ClassID,OrderID,ClassName,isShow,ParentID,ReycleTF From FS_DS_Class where isShow=1 and ReycleTF=0 "& ParentIDstr &" Order by OrderId desc,id desc")
- ClassNavistr = ""
- if rs.eof then
- ClassNavistr = ""
- rs.close:set rs=nothing
- else
- do while not rs.eof
- if div_tf=1 then
- ClassNavistr = ClassNavistr &classNews_middle1 & "<a href="""&get_ClassLink(rs("ClassId"))&""">"&rs("ClassName")&"</a>" & classNews_middle2
- else
- if cols="0" then
- cols_str = " "
- else
- cols_str = "<br />"
- end if
- ClassNavistr = ClassNavistr & titleNavi & "<a href="""&get_ClassLink(rs("ClassId"))&""""& cssstyle&">"&rs("ClassName")&"</a>"& cols_str &""
- end if
- rs.movenext
- loop
- rs.close:set rs=nothing
- if div_tf=1 then
- ClassNavistr=classNews_head & ClassNavistr & classNews_bottom
- end if
- end if
- ClassNavi = ClassNavistr
- End Function
- '得到下载单个地址____________________________________________________________
- Public Function get_DownLink(f_id)
- get_DownLink = ""
- dim rs,config_rs,config_mf_rs,class_rs
- dim SaveNewsPath,FileName,FileExtName,ClassId,LinkType,MF_Domain,Url_Domain,ClassEName,c_Domain,c_SavePath,IsDomain
- set rs = Conn.execute("select ID,ClassId,DownLoadID,SavePath,FileName,FileExtName From FS_DS_List where DownLoadID='"&f_id&"'")
- SaveNewsPath = rs("SavePath")
- if right(SaveNewsPath,1)="/" then SaveNewsPath = left(SaveNewsPath,len(SaveNewsPath)-1)
- FileName = rs("FileName")
- FileExtName = rs("FileExtName")
- ClassId = rs("ClassId")
- LinkType = Request.Cookies("FoosunDSCookies")("FoosunDSLinkType")
- IsDomain = Request.Cookies("FoosunDSCookies")("FoosunDSDomain")
- MF_Domain = Request.Cookies("FoosunMFCookies")("FoosunMFDomain")
- set class_rs = Conn.execute("select ClassEName,IsURL,URLAddress,[Domain],SavePath From FS_DS_Class where ClassId='"&ClassId&"'")
- if not class_rs.eof then
- ClassEName = class_rs("ClassEName")
- c_Domain = class_rs("Domain")
- c_SavePath = class_rs("SavePath")
- class_rs.close:set class_rs=nothing
- else
- ClassEName = ""
- class_rs.close:set class_rs=nothing
- end if
- if not rs.eof then
- if LinkType = 1 then
- if trim(c_Domain)<>"" then
- Url_Domain = "http://"&c_Domain
- else
- if trim(IsDomain)<>"" then
- Url_Domain = "http://"&IsDomain
- else
- Url_Domain = "http://"&MF_Domain
- end if
- end if
- else
- if trim(c_Domain)<>"" then
- Url_Domain = "http://"&c_Domain
- else
- if trim(IsDomain)<>"" then
- Url_Domain = "http://"&IsDomain
- else
- Url_Domain = ""
- end if
- end if
- end if
- if trim(c_Domain)<>"" then
- get_DownLink = Url_Domain & SaveNewsPath &"/"&FileName&"."&FileExtName
- else
- get_DownLink = Url_Domain & c_SavePath& "/" & ClassEName &SaveNewsPath &"/"& FileName&"."&FileExtName
- end if
- rs.close:set rs=nothing
- else
- get_DownLink = ""
- rs.close:set rs=nothing
- end if
- get_DownLink = get_DownLink
- End Function
- '得到栏目地址________________________________________________________________
- Public function get_ClassLink(f_id)
- dim IsDomain,LinkType,MF_Domain,c_rs,ClassEName,c_Domain,Url_Domain,ClassSaveType,class_savepath,FileExtName,c_SavePath
- LinkType = Request.Cookies("FoosunDSCookies")("FoosunDSLinkType")
- IsDomain = Request.Cookies("FoosunDSCookies")("FoosunDSDomain")
- MF_Domain = Request.Cookies("FoosunMFCookies")("FoosunMFDomain")
- set c_rs=conn.execute("select id,IsURL,UrlAddress,ClassId,ClassEName,[Domain],FileSaveType,FileExtName,SavePath From FS_DS_Class where ClassId='"&f_id&"'")
- if not c_rs.eof then
- if c_rs("IsURL")=0 then
- ClassEName = c_rs("ClassEName")
- c_Domain = c_rs("Domain")
- FileExtName = c_rs("FileExtName")
- ClassSaveType = c_rs("FileSaveType")
- c_SavePath= c_rs("SavePath")
- if ClassSaveType=0 then
- class_savepath = ClassEName&"/Index."&FileExtName
- elseif ClassSaveType=1 then
- class_savepath = ClassEName&"/"& ClassEName &"."&FileExtName
- else
- class_savepath = ClassEName &"."&FileExtName
- end if
- if LinkType = 1 then
- if trim(c_Domain)<>"" then
- Url_Domain = "http://"&c_Domain
- else
- if trim(IsDomain)<>"" then
- Url_Domain = "http://"&IsDomain
- else
- Url_Domain = "http://"&MF_Domain
- end if
- end if
- else
- if trim(c_Domain)<>"" then
- Url_Domain = "http://"&c_Domain
- else
- if trim(IsDomain)<>"" then
- Url_Domain = "http://"&IsDomain
- else
- Url_Domain = ""
- end if
- end if
- end if
- get_ClassLink = Url_Domain&c_SavePath&"/"&class_savepath
- else
- get_ClassLink = c_rs("UrlAddress")
- end if
- c_rs.close:set c_rs=nothing
- else
- c_rs.close:set c_rs=nothing
- get_ClassLink = ""
- end if
- get_ClassLink = get_ClassLink
- End function
- '得到子类____________________________________________________________________
- Public Function get_ClassList(TypeID,CompatStr,f_css)
- Dim ChildTypeListRs,ChildTypeListStr,TempStr,i,Sql
- Set ChildTypeListRs = Server.CreateObject(G_FS_RS)
- Sql = "Select ParentID,ClassID,ClassName from FS_DS_Class where ParentID='" & TypeID & "' and ReycleTF=0 order by OrderID desc,id desc"
- ChildTypeListRs.open sql,conn,1,1
- TempStr = CompatStr
- do while Not ChildTypeListRs.Eof
- get_ClassList = get_ClassList & TempStr
- get_ClassList = get_ClassList & "<img src="""&m_PathDir&"sys_images/-.gif"" border=""0""><a href="""&get_ClassLink(ChildTypeListRs("ClassId"))&""" class="""& f_css &""">"&ChildTypeListRs("ClassName")&"</a>"&chr(10)
- get_ClassList = get_ClassList & get_ClassList(ChildTypeListRs("ClassID"),TempStr,f_css)
- ChildTypeListRs.MoveNext
- loop
- ChildTypeListRs.Close:Set ChildTypeListRs = Nothing
- End Function
- '得到option子类______________________________________________________________
- Public Function get_optionNewsList(TypeID,CompatStr)
- Dim ChildTypeListRs,ChildTypeListStr,TempStr
- Set ChildTypeListRs = Conn.execute("Select ParentID,ClassID,ClassName from FS_DS_Class where ParentID='" & TypeID & "' and ReycleTF=0 order by OrderID desc,id desc")
- TempStr = CompatStr & "┉"
- do while Not ChildTypeListRs.Eof
- get_optionNewsList = get_optionNewsList &"<option value="""&ChildTypeListRs("ClassId")&""">"& TempStr
- get_optionNewsList = get_optionNewsList & "┉"&ChildTypeListRs("ClassName")&"</option>"&chr(10)
- get_optionNewsList = get_optionNewsList & get_optionNewsList(ChildTypeListRs("ClassID"),TempStr)
- ChildTypeListRs.MoveNext
- loop
- ChildTypeListRs.Close:Set ChildTypeListRs = Nothing
- End Function
- Public Function getNewsSubClass(typeID)
- Dim childClassRs,result,Str_SubClassID
- result=""
- Set childClassRs=Conn.execute("Select ParentID,ClassID from FS_DS_Class where ParentID='" & TypeID & "' and ReycleTF=0 order by OrderID desc,id desc")
- While Not childClassRs.eof
- If result="" Then
- result="'"&childClassRs("classID")&"'"
- Else
- result=result&",'"&childClassRs("classID")&"'"
- End If
- Str_SubClassID=getNewsSubClass(childClassRs("classID"))
- If Str_SubClassID<>"" Then
- result=result&","&Str_SubClassID
- End If
- childClassRs.movenext
- Wend
- childClassRs.close:Set childClassRs=nothing
- getNewsSubClass=result
- End Function
- End Class
- %>