<%
'**************************************************************
' Software name: PowerEasy SiteWeaver
' Web: http://www.powereasy.net
' Copyright (C) 2005－2009 佛山市动易网络科技有限公司 版权所有
'**************************************************************

Dim SupplyID, rsSupply, SearchStyleFlag

Class Supply

Private OpenType

Public Sub Init()

    'ClassID = SQ_CLng(Trim(Request("ClassID")))
    'SpecialID = SQ_CLng(Trim(Request("SpecialID")))
    SupplyID = SQ_CLng(Trim(Request("SupplyId")))
    
    If IsValidID(SupplyID) = False Then
        SupplyID = ""
    End If
    PrevChannelID = ChannelID
        
    If XmlDoc.Load(Server.MapPath(InstallDir & "Language/Gb2312_Channel_" & ChannelID & ".xml")) = False Then XmlDoc.Load (Server.MapPath(InstallDir & "Language/Gb2312.xml"))
     
    ChannelShortName = "供求信息"
    
    strNavPath = XmlText("BaseText", "Nav", "您现在的位置：") & "&nbsp;<a class='LinkPath' href='" & SiteUrl & "'>" & SiteName & "</a>"
    strPageTitle = SiteTitle
    
    Call GetChannel(ChannelID)
    
    If Trim(ChannelName) <> "" And ShowNameOnPath <> False Then
        strNavPath = strNavPath & "&nbsp;" & strNavLink & "&nbsp;<a class='LinkPath' href='" & ChannelUrl & "/Index.asp"
        strNavPath = strNavPath & "'>" & ChannelName & "</a>"
        strPageTitle = strPageTitle & " >> " & ChannelName
    End If
End Sub

'标签解析接口
Private Function getInfoListLable()
    regEx.Pattern = "\{\$SupplyInfoList\((.*?)\)\}"
    Set Matches = regEx.Execute(strHtml)
    For Each Match In Matches
        strHtml = Replace(strHtml, Match.value, ReplaceInfoListLabel(Match.SubMatches(0)))
    Next

    regEx.Pattern = "\{\$SupplyInfoType\((.*?)\)\}"
    Set Matches = regEx.Execute(strHtml)
    For Each Match In Matches
        strHtml = Replace(strHtml, Match.value, ReplaceSupplyInfoType(Match.SubMatches(0)))
    Next

    regEx.Pattern = "\{\$Navigation\((.*?)\)\}"
    Set Matches = regEx.Execute(strHtml)
    For Each Match In Matches
        strHtml = Replace(strHtml, Match.value, ReplaceNavigationLabel(Match.SubMatches(0)))
    Next

End Function

Private Function ReplaceSupplyInfoType(ByVal strTemp)
    Dim arrTemp
    arrTemp = Split(strTemp, ",")
    
    If SQ_CLng(arrTemp(0)) > 4 Or SQ_CLng(arrTemp(0)) < 0 Then
        arrTemp(0) = 0
    End If
    If UBound(arrTemp) <> 6 Then
        FoundErr = True
        ErrMsg = ErrMsg & "<li>页面标签{$SupplyInfoType(...)}错误</li>"
        Exit Function
    End If
    If SQ_CLng(arrTemp(1)) = 0 Then
        arrTemp(1) = 10
    End If
    Select Case SQ_CLng(arrTemp(0))
        Case 0  ' 最新
            ReplaceSupplyInfoType = getLasterSupplyInfo(SQ_CLng(arrTemp(2)), SQ_CLng(arrTemp(3)), SQ_CLng(arrTemp(4)))
        Case 1  '热门
            ReplaceSupplyInfoType = getHotSupplyInfo(SQ_CLng(arrTemp(2)), SQ_CLng(arrTemp(3)), SQ_CLng(arrTemp(4)))
        Case 2  '推荐
            ReplaceSupplyInfoType = getCommandSupplyInfo(SQ_CLng(arrTemp(1)), SQ_CLng(arrTemp(2)), SQ_CLng(arrTemp(3)), SQ_CLng(arrTemp(4)))
        Case 3  '带图片的最新信息
            ReplaceSupplyInfoType = getPicLasterInfo(SQ_CLng(arrTemp(2)), SQ_CLng(arrTemp(3)), SQ_CLng(arrTemp(4)), SQ_CLng(arrTemp(5)), SQ_CLng(arrTemp(6)))
    End Select
End Function

'根据标签参数，来替换不同的函数
Private Function ReplaceInfoListLabel(ByVal strTemp)    '0,0,1,100,0,True
    Dim arrTemp
    arrTemp = Split(strTemp, ",")
    If UBound(arrTemp) = 10 Then
        strTemp = strTemp & ",0,True"
    End If
    If CheckSupplyLabel(strTemp) Then
        Exit Function
    End If
    arrTemp = Split(strTemp, ",")
    If SQ_CLng(arrTemp(5)) > 3 Or SQ_CLng(arrTemp(5)) < 0 Then
        arrTemp(5) = 0
    End If
    If ClassID > 0 Then
        arrTemp(1) = ClassID
    End If
    Select Case SQ_CLng(arrTemp(5))
        Case 0
            ReplaceInfoListLabel = getInfoList(SQ_CLng(arrTemp(0)), SQ_CLng(arrTemp(1)), SQ_CLng(arrTemp(2)), SQ_CLng(arrTemp(3)), SQ_CLng(arrTemp(4)), SQ_CBool(arrTemp(6)), SQ_CBool(arrTemp(7)), SQ_CLng(arrTemp(8)), SQ_CLng(arrTemp(9)), SQ_CLng(arrTemp(10)), SQ_CLng(arrTemp(11)), SQ_CBool(arrTemp(12))) '一行多列
        Case 1
            ReplaceInfoListLabel = getDetailInfoList(SQ_CLng(arrTemp(0)), SQ_CLng(arrTemp(1)), SQ_CLng(arrTemp(2)), SQ_CLng(arrTemp(3)), SQ_CLng(arrTemp(4)), SQ_CBool(arrTemp(6)), SQ_CBool(arrTemp(7)), SQ_CLng(arrTemp(8)), SQ_CLng(arrTemp(9)), SQ_CLng(arrTemp(10)), SQ_CLng(arrTemp(11)), SQ_CBool(arrTemp(12))) '一行
        Case 2
            ReplaceInfoListLabel = getListPicInfoList(SQ_CLng(arrTemp(0)), SQ_CLng(arrTemp(1)), SQ_CLng(arrTemp(2)), SQ_CLng(arrTemp(3)), SQ_CLng(arrTemp(4)), SQ_CBool(arrTemp(6)), SQ_CBool(arrTemp(7)), SQ_CLng(arrTemp(8)), SQ_CLng(arrTemp(9)), SQ_CLng(arrTemp(10)), SQ_CLng(arrTemp(11)), SQ_CBool(arrTemp(12))) '图片样式一
        Case 3
            ReplaceInfoListLabel = getPicInfoList(SQ_CLng(arrTemp(0)), SQ_CLng(arrTemp(1)), SQ_CLng(arrTemp(2)), SQ_CLng(arrTemp(3)), SQ_CLng(arrTemp(4)), SQ_CBool(arrTemp(6)), SQ_CBool(arrTemp(7)), SQ_CLng(arrTemp(8)), SQ_CLng(arrTemp(9)), SQ_CLng(arrTemp(10)), SQ_CLng(arrTemp(11)), SQ_CBool(arrTemp(12))) '图片样式二
    End Select
End Function

Private Function CheckSupplyLabel(ByVal strTemp)
    Dim arrTemp
    arrTemp = Split(strTemp, ",")
    CheckSupplyLabel = False
    
    If UBound(arrTemp) <> 12 Then
        FoundErr = True
        ErrMsg = ErrMsg & "<li>页面标签{$SupplyInfoList(...)}参数太多或者太少错误</li>"
        CheckSupplyLabel = True
    Else
        If SQ_CLng(arrTemp(11)) > SQ_CLng(getSupplyTypeNum("//SupplyType/Type")) Then
            FoundErr = True
            ErrMsg = ErrMsg & "<li>页面标签{$SupplyInfoList(...)}的第12个参数错误</li>"
            CheckSupplyLabel = True
        End If
    End If
End Function

Private Function getSupplyTypeNum(ByVal NodeName)
    Dim LangRoot, strTemp, XmlDoc, ShowLength
    Set XmlDoc = CreateObject("Microsoft.XMLDOM")
    XmlDoc.async = False
    XmlDoc.Load (Server.MapPath(InstallDir & "Language/Gb2312.xml"))
    Set LangRoot = XmlDoc.selectNodes(NodeName)
    getSupplyTypeNum = LangRoot.Length
End Function

Private Function ReplaceNavigationLabel(ByVal strTemp)
    Dim arrTemp
    arrTemp = Split(strTemp, ",")
    ReplaceNavigationLabel = GetClass_Navigation(2, SQ_CLng(arrTemp(0)), SQ_CLng(arrTemp(1)))
End Function

Public Function ReplaceSearchCondition(ByVal strTemp)
    Dim arrTemp
    arrTemp = Split(strTemp, ",")
    ReplaceSearchCondition = ShowSearchCondition(SQ_CLng(arrTemp(0)), SQ_CLng(arrTemp(1)))
End Function

Private Function getClassInfoNum(ByVal ClassID)
    Dim strSql
    strSql = "Select Count(*) From SQ_Supply Where ClassId IN (" & ClassID & ")"
    getClassInfoNum = SQ_CLng(Conn.Execute(strSql)(0))
End Function


Public Sub GetHtml_Supply()
    If PrevChannelID <> ChannelID Then
        Call GetChannel(ChannelID)
    End If
    strHtml = SQ_Replace(strHtml, "{$SupplyID}", SupplyID)
    Call ReplaceCommon
    strHtml = SQ_Replace(strHtml, "{$ClassUrl}", GetClassUrl(ClassID))
    strHtml = Replace(strHtml, "{$SupplyAction}", GetSupplyAction())
    strPageTitle = rsSupply("SupplyTitle")
    strHtml = Replace(strHtml, "{$SupplyInfoType}", GetSupplyInfoType(rsSupply("SupplyType"), "//SupplyType/Type"))
    strHtml = Replace(strHtml, "{$SupplyInfoTitle}", rsSupply("SupplyTitle"))
    strHtml = Replace(strHtml, "{$TradeType}", GetSupplyInfoType(rsSupply("TradeType"), "//TradeType/Type"))
    strHtml = SQ_Replace(strHtml, "{$SupplyName}", rsSupply("SupplyName"))
    strHtml = SQ_Replace(strHtml, "{$PriceIntro}", rsSupply("PriceIntro"))
    strHtml = SQ_Replace(strHtml, "{$UpdateTime}", rsSupply("UpdateTime"))
    If rsSupply("SupplyPeriod") <> -1 Then
        strHtml = SQ_Replace(strHtml, "{$EndTime}", DateAdd("d", rsSupply("SupplyPeriod"), rsSupply("UpdateTime")))
    Else
        strHtml = SQ_Replace(strHtml, "{$EndTime}", "长期有效")
    End If
    strHtml = Replace(strHtml, "{$SupplyIntro}", Replace(Replace(rsSupply("SupplyIntro"), "[InstallDir_ChannelDir]", ChannelUrl & "/"), "{$UploadDir}", UploadDir))
    strHtml = SQ_Replace(strHtml, "{$UserName}", rsSupply("UserName"))
    strHtml = SQ_Replace(strHtml, "{$Province}", rsSupply("Province"))
    strHtml = SQ_Replace(strHtml, "{$City}", rsSupply("City"))
    strHtml = SQ_Replace(strHtml, "{$Address}", rsSupply("Address"))
    strHtml = SQ_Replace(strHtml, "{$ZipCode}", rsSupply("ZipCode"))
    strHtml = SQ_Replace(strHtml, "{$Email}", rsSupply("Email"))
    strHtml = SQ_Replace(strHtml, "{$CompanyName}", rsSupply("Company"))
    strHtml = SQ_Replace(strHtml, "{$Department}", rsSupply("Department"))
    strHtml = SQ_Replace(strHtml, "{$CompanyAddress}", rsSupply("CompanyAddress")) '公司地址
    strHtml = SQ_Replace(strHtml, "{$RealName}", rsSupply("TrueName")) '真实姓名
    strHtml = SQ_Replace(strHtml, "{$Sex}", getUserSex(rsSupply("Sex"))) '性别
    strHtml = SQ_Replace(strHtml, "{$Position}", rsSupply("Position")) '职务
    strHtml = SQ_Replace(strHtml, "{$Operation}", rsSupply("Operation")) '负责的业务
    strHtml = SQ_Replace(strHtml, "{$OfficePhone}", rsSupply("OfficePhone")) '办公室电话
    strHtml = SQ_Replace(strHtml, "{$Fax}", rsSupply("Fax"))  '传真
    strHtml = SQ_Replace(strHtml, "{$Mobile}", rsSupply("Mobile")) '移动电话
    strHtml = SQ_Replace(strHtml, "{$QQ}", rsSupply("QQ")) 'qq
    strHtml = SQ_Replace(strHtml, "{$Msn}", rsSupply("Msn")) 'msn
    strHtml = SQ_Replace(strHtml, "{$Homepage}", rsSupply("Homepage")) '网址A.LoginTimes,A.LastLoginTime
    strHtml = SQ_Replace(strHtml, "{$LoginTimes}", rsSupply("LoginTimes")) '登录测试
    strHtml = SQ_Replace(strHtml, "{$LastLoginTime}", rsSupply("LastLoginTime")) '最近登录时间
    strHtml = SQ_Replace(strHtml, "{$UserType}", getUserType(rsSupply("UserType"))) '会员类型
End Sub


Public Sub GetHtml_Special()
    strHtml = SQ_Replace(strHtml, "{$SpecialID}", SpecialID)
    Call ReplaceCommon
    strHtml = SQ_Replace(strHtml, "{$Readme}", ReadMe)
    strHtml = SQ_Replace(strHtml, "{$SpecialName}", SpecialName)
    strHtml = SQ_Replace(strHtml, "{$SpecialPicUrl}", SpecialPicUrl)

    Dim strPath
    strPath = ChannelUrl & "/Special/" & SpecialDir
    Call getInfoListLable
    If InStr(strHtml, "{$ShowPage}") > 0 Then strHtml = Replace(strHtml, "{$ShowPage}", ShowPage(strFileName, totalPut, MaxPerPage, CurrentPage, True, True, ChannelItemUnit & ChannelShortName, False))
    If InStr(strHtml, "{$ShowPage_en}") > 0 Then strHtml = Replace(strHtml, "{$ShowPage_en}", ShowPage_en(strFileName, totalPut, MaxPerPage, CurrentPage, True, True, ChannelItemUnit & ChannelShortName, False))
End Sub


Public Sub GetHtml_Class()
    Dim strTemp, iCols, iClassID
    If Child > 0 And ClassShowType <> 2 Then
        strHtml = arrTemplate(0)
    Else
        strHtml = arrTemplate(1)
    End If
    strHtml = SQ_Replace(strHtml, "{$ClassID}", ClassID)
    Call ReplaceCommon
    strHtml = SQ_Replace(strHtml, "{$ClassPicUrl}", ClassPicUrl)
    strHtml = SQ_Replace(strHtml, "{$Meta_Keywords_Class}", Meta_Keywords_Class)
    strHtml = SQ_Replace(strHtml, "{$Meta_Description_Class}", Meta_Description_Class)
    strHtml = Replace(strHtml, "{$ClassUrl}", GetClassUrl(ClassID))
    strHtml = Replace(strHtml, "{$ClassListUrl}", GetClass_1Url(ClassID))
    
    Dim ArticleList_CurrentClass, ArticleList_CurrentClass2, ArticleList_ChildClass, ArticleList_ChildClass2
    If Child > 0 And ClassShowType <> 2 Then    '如果当前栏目有子栏目
        If InStr(strHtml, "{$ShowChildClass}") > 0 Then strHtml = Replace(strHtml, "{$ShowChildClass}", GetChildClass(0, 0, 3, 3, 0, True))
        
        Dim strChildClass, arrTemp
        regEx.Pattern = "\{\$ShowChildClass\((.*?)\)\}"
        Set Matches = regEx.Execute(strHtml)
        For Each Match In Matches
            arrTemp = Split(Match.SubMatches(0), ",")
            strChildClass = GetChildClass(SQ_CLng(arrTemp(0)), SQ_CLng(arrTemp(1)))
            strHtml = Replace(strHtml, Match.value, strChildClass)
        Next
        
        ItemCount = SQ_CLng(Conn.Execute("select Count(*) from SQ_Supply where ClassID=" & ClassID & "")(0))
        If ItemCount <= 0 Then     '如果当前栏目没有内容
            strHtml = regEx.Replace(strHtml, "") '再去掉显示当前栏目的只属于本栏目的内容列表
        Else      '如果当前栏目有子栏目并且当前栏目有内容，则需要显示出来。
            strTemp = ArticleList_CurrentClass
            strTemp = Replace(strTemp, "{$rsClass_ClassUrl}", GetClassUrl(ClassID))
            strTemp = SQ_Replace(strTemp, "{$rsClass_Readme}", ReadMe)
            strTemp = SQ_Replace(strTemp, "{$rsClass_ClassName}", ClassName)
            strTemp = SQ_Replace(strTemp, "{$rsClass_ClassID}", ClassID)
        End If
     
        '得到每行显示的列数
        iCols = 1
        regEx.Pattern = "【Cols=(\d{1,2})】"
        Set Matches = regEx.Execute(ArticleList_ChildClass)
        ArticleList_ChildClass = regEx.Replace(ArticleList_ChildClass, "")
        For Each Match In Matches
            If Match.SubMatches(0) > 1 Then iCols = Match.SubMatches(0)
        Next
        '开始循环，得到所有子栏目列表的HTML代码
        iClassID = 0
        Dim rsClass
        Set rsClass = Conn.Execute("select * from SQ_Class where ChannelID=" & ChannelID & " and ClassType=1 and ParentID=" & ClassID & " and IsElite=" & SQ_True & " and ClassType=1 order by RootID,OrderID")
        Do While Not rsClass.EOF
            strTemp = ArticleList_ChildClass
            strTemp = Replace(strTemp, "{$rsClass_ClassUrl}", GetClassUrl(rsClass("ClassID")))
            strTemp = SQ_Replace(strTemp, "{$rsClass_Readme}", rsClass("Readme"))
            strTemp = SQ_Replace(strTemp, "{$rsClass_ClassName}", rsClass("ClassName"))
            strTemp = Replace(strTemp, "{$ShowClassAD}", "")
        
            rsClass.MoveNext
            iClassID = iClassID + 1
            If iClassID Mod iCols = 0 And Not rsClass.EOF Then
                ArticleList_ChildClass2 = ArticleList_ChildClass2 & strTemp
                If iCols > 1 Then ArticleList_ChildClass2 = ArticleList_ChildClass2 & "</tr><tr>"
            Else
                ArticleList_ChildClass2 = ArticleList_ChildClass2 & strTemp
                If iCols > 1 Then ArticleList_ChildClass2 = ArticleList_ChildClass2 & "<td width='1'></td>"
            End If
        Loop
        rsClass.Close
        Set rsClass = Nothing
    End If
    Dim strPath
    strPath = ChannelUrl
    Call getInfoListLable
    If InStr(strHtml, "{$ShowPage}") > 0 Then strHtml = Replace(strHtml, "{$ShowPage}", ShowPage(strFileName, totalPut, MaxPerPage, CurrentPage, True, True, ChannelItemUnit & ChannelShortName, False))
    If InStr(strHtml, "{$ShowPage_en}") > 0 Then strHtml = Replace(strHtml, "{$ShowPage_en}", ShowPage_en(strFileName, totalPut, MaxPerPage, CurrentPage, True, True, ChannelItemUnit & ChannelShortName, False))
    
End Sub


Public Sub GetHtml_List()
    Call ReplaceCommon
    strHtml = SQ_Replace(strHtml, "{$SpecialName}", SpecialName)
    Call getInfoListLable
    If InStr(strHtml, "{$ShowPage}") > 0 Then strHtml = Replace(strHtml, "{$ShowPage}", ShowPage(strFileName, totalPut, MaxPerPage, CurrentPage, True, True, ChannelItemUnit & ChannelShortName, False))
    If InStr(strHtml, "{$ShowPage_en}") > 0 Then strHtml = Replace(strHtml, "{$ShowPage_en}", ShowPage_en(strFileName, totalPut, MaxPerPage, CurrentPage, True, True, ChannelItemUnit & ChannelShortName, False))
End Sub


Public Sub GetHTML_Index()
    strHtml = GetTemplate(ChannelID, 1, Template_Index)
    ClassID = 0
    Call ReplaceCommon
    strHtml = Replace(strHtml, "{$ShowChannelCount}", GetChannelCount())
    Call getInfoListLable
End Sub

Public Sub GetHTML_Search()
    Dim SearchChannelID
    SearchChannelID = ChannelID
    If ChannelID > 0 Then
        strHtml = GetTemplate(ChannelID, 5, 0)
    Else
        ChannelID = SQ_CLng(Conn.Execute("select min(ChannelID) from SQ_Channel where ModuleType=1 and Disabled=" & SQ_False & "")(0))
        strHtml = GetTemplate(ChannelID, 3, 0)
        CurrentChannelID = ChannelID
        Call GetChannel(ChannelID)
    End If
    ClassID = SQ_CLng(Trim(Request("SelClass")))
    Call ReplaceCommon
    strHtml = Replace(strHtml, "{$Keyword}", Keyword)
    strHtml = Replace(strHtml, "{$PageTitle}", strPageTitle)
    strHtml = Replace(strHtml, "{$ShowPath}", ShowPath())
    Call GetClass
    strHtml = SQ_Replace(strHtml, "{$ClassID}", ClassID)
    strHtml = SQ_Replace(strHtml, "{$ClassName}", ClassName)
    strHtml = SQ_Replace(strHtml, "{$ParentDir}", ParentDir)
    strHtml = SQ_Replace(strHtml, "{$ClassDir}", ClassDir)
    strHtml = SQ_Replace(strHtml, "{$Readme}", ReadMe)
    strHtml = SQ_Replace(strHtml, "{$SpecialName}", SpecialName)

    strHtml = Replace(strHtml, "{$SearchResul}", SearchResult())
    If InStr(strHtml, "{$ShowPage}") > 0 Then strHtml = Replace(strHtml, "{$ShowPage}", ShowPage(strFileName, totalPut, MaxPerPage_SearchResult, CurrentPage, True, True, ChannelItemUnit & ChannelShortName, False))
    If InStr(strHtml, "{$ShowPage_en}") > 0 Then strHtml = Replace(strHtml, "{$ShowPage_en}", ShowPage_en(strFileName, totalPut, MaxPerPage_SearchResult, CurrentPage, True, True, ChannelItemUnit & ChannelShortName, False))
    Call getInfoListLable
End Sub

Private Sub ReplaceCommon()

    Call ReplaceCommonLabel
    
    strHtml = SQ_Replace(strHtml, "{$MenuJS}", GetMenuJS(ChannelDir, ShowClassTreeGuide))
    strHtml = SQ_Replace(strHtml, "{$Skin_CSS}", GetSkin_CSS(SkinID))

    strHtml = SQ_Replace(strHtml, "{$PageTitle}", strPageTitle)
    strHtml = SQ_Replace(strHtml, "{$ShowPath}", ShowPath())

    strHtml = SQ_Replace(strHtml, "{$ClassID}", ClassID)
    strHtml = SQ_Replace(strHtml, "{$ClassName}", ClassName)
    strHtml = SQ_Replace(strHtml, "{$ParentDir}", ParentDir)
    strHtml = SQ_Replace(strHtml, "{$ClassDir}", ClassDir)
    strHtml = SQ_Replace(strHtml, "{$Readme}", ReadMe)
End Sub

Private Function getUserType(ByVal UserType)
    If SQ_CLng(UserType) = 0 Then
        getUserType = "个人会员"
    Else
        getUserType = "企业会员"
    End If
End Function

Private Function getUserSex(ByVal UserSex)
    Select Case SQ_CLng(UserSex)
        Case 0
            getUserSex = "女"
        Case 1
            getUserSex = "男"
        Case Else
            getUserSex = "保密"
    End Select
    
End Function


Private Function ShowSearchCondition(ByVal ShowStyle, ByVal SupplyTypeNum)
    Dim strTemp
    strTemp = "<script language='javascript'>" & vbCrLf
    strTemp = strTemp & "function CheckInput()" & vbCrLf
    strTemp = strTemp & "{" & vbCrLf
    strTemp = strTemp & "   if(document.Searchform.KeyWord.value=='')" & vbCrLf
    strTemp = strTemp & "   {" & vbCrLf
    strTemp = strTemp & "     alert('关键字不可以为空!');" & vbCrLf
    strTemp = strTemp & "     return false;" & vbCrLf
    strTemp = strTemp & "    }" & vbCrLf
    strTemp = strTemp & "}" & vbCrLf
    strTemp = strTemp & "</script>" & vbCrLf
    SearchStyleFlag = ShowStyle
    Select Case ShowStyle
        Case 0
            strTemp = strTemp & "<table cellSpacing=0 cellPadding=2 width='100%' align=center border=0>"
            strTemp = strTemp & "<Form Name='Searchform' action='Search.asp' method=GET onSubmit='return CheckInput();'>"
            strTemp = strTemp & "<tr><td>" & GetSupplyInfo_Radio(0, "SupplyType", "//SupplyType/Type", SupplyTypeNum) & "<INPUT Class='SupplySearchKeyWordStyle' TYPE=""Text"" NAME=""KeyWord"" Id=""KeyWord"" MaxLength='250' >&nbsp;&nbsp;<INPUT TYPE=""submit"" Value=""搜索信息""></td></tr>"
            strTemp = strTemp & "<Input Type='Hidden' value='" & ShowStyle & "' Name='SearchType' id='SearchType'>"
            strTemp = strTemp & "</Form>"
            strTemp = strTemp & "</Table>"
            ShowSearchCondition = strTemp
        Case 1
            strTemp = strTemp & "<table cellSpacing=0 cellPadding=2 width='100%' align=center border=0>"
            strTemp = strTemp & "<tr align=left>"
            strTemp = strTemp & "<Form Name='Searchform' action='Search.asp' method='GET' onSubmit='return CheckInput();'>"
            strTemp = strTemp & "<td>搜索关键字：<Input Class='SupplySearchKeyWordStyle' Name='KeyWord' id='KeyWord' type='text' MaxLength='200' size='20'>"
            strTemp = strTemp & "&nbsp;&nbsp;<Select Name='selClass' id='selClass'><option Value=-1>所有栏目</option>" & GetClass_Option(0) & "</Select></td>"
            strTemp = strTemp & "<td>按地区:<Select Name='mySelectProvince' Id='mySelectProvince' OnChange=""getSelected('Region.asp?Province='+this.value,mySelectCity)""><Option value=-1>所有省份</Option></Select><Select Name='mySelectCity' Id='mySelectCity' ><option value=-1>所有城市</option></Select></td>"
            strTemp = strTemp & "<td><INPUT TYPE=""submit"" Value=""搜索信息""></td>"
            strTemp = strTemp & "<Input Type='Hidden' value='" & ShowStyle & "' Name='SearchType' id='SearchType'>"
            strTemp = strTemp & "</form></tr>"
            strTemp = strTemp & "</Table>"
            ShowSearchCondition = strTemp
   End Select
End Function

Private Function SearchResult()
    Dim Province, City, SelClass, SupplyType, SearchType, QuerySql, strSql, strTemp
    Province = ReplaceBadChar(Trim(Request("mySelectProvince")))
    City = ReplaceBadChar(Trim(Request("mySelectCity")))
    SelClass = SQ_CLng(Trim(Request("SelClass")))
    SearchType = SQ_CLng(Trim(Request("SearchType")))
    SupplyType = SQ_CLng(Trim(Request("SupplyType")))
    
    strSql = "Select Top " & MaxPerPage_SearchResult & " A.SupplyId,A.SupplyTitle,A.SupplyName,A.SupplyType,A.TradeType, "
    strSql = strSql & " A.UpDateTime,B.Country,B.Province,B.City From SQ_Supply A , SQ_Contacter B, SQ_User C"
    QuerySql = " Where  A.UserName=C.UserName and C.ContacterID = B.ContacterID and A.Status=1 And Deleted=" & SQ_False & " "
    Select Case SearchType
        Case 0
            QuerySql = QuerySql & " And A.SupplyType =" & SupplyType
            If CurrentPage > 1 Then
                strSql = strSql & QuerySql & " And A.SupplyId <=(Select Min(SupplyId) From (Select Top " & (CurrentPage - 1) * MaxPerPage_SearchResult + 1 & " SupplyId From SQ_Supply A,SQ_Contacter B,SQ_User C " & QuerySql & " And A.SupplyType =" & SupplyType & " And A.SupplyTitle like '%" & Keyword & "%' Order By SupplyId DESC) As QueryTable) Order by A.SupplyId Desc"
            Else
                strSql = strSql & QuerySql & " And A.SupplyType =" & SupplyType & " And A.SupplyTitle like '%" & Keyword & "%' Order By A.SupplyID Desc"
            End If
            strFileName = ChannelUrl & "/Search.asp?SupplyType=" & SupplyType & "&KeyWord=" & Keyword & "&SearchType=" & SearchType & ""
            totalPut = SQ_CLng(Conn.Execute("Select Count(*) From SQ_Supply A , SQ_Contacter B, SQ_User C Where  A.UserName=C.UserName and C.ContacterID = B.ContacterID and A.Status=1 And A.SupplyType =" & SupplyType & " And A.SupplyTitle like '%" & Keyword & "%' ")(0))
        Case 1
            If Province <> "-1" Then
                QuerySql = QuerySql & "And B.Province='" & Province & "'"
            End If
            If City <> "-1" Then
                QuerySql = QuerySql & " And B.City = '" & City & "'"
            End If
            If SelClass > -1 Then
                 If Child > 0 Then
                    QuerySql = QuerySql & " and A.ClassID in (" & arrChildID & ")"
                Else
                    QuerySql = QuerySql & " and A.ClassID=" & ClassID
                End If
            End If
            If CurrentPage > 1 Then
                strSql = strSql & QuerySql & "And A.SupplyId <=(Select Min(SupplyId) From (Select Top " & (CurrentPage - 1) * MaxPerPage_SearchResult + 1 & " SupplyId From SQ_Supply A,SQ_Contacter B,SQ_User C " & QuerySql & " And A.SupplyTitle like '%" & Keyword & "%' Order by A.SupplyId DESC) As QueryTable) Order By A.SupplyID DESC"
            Else
                strSql = strSql & QuerySql & " And A.SupplyTitle like '%" & Keyword & "%' Order By A.SupplyID DESC "
            End If
            totalPut = SQ_CLng(Conn.Execute("Select Count(*) From SQ_Supply A , SQ_Contacter B, SQ_User C " & QuerySql & " And A.SupplyTitle like '%" & Keyword & "%'")(0))
            strFileName = ChannelUrl & "/Search.asp?KeyWord=" & Keyword & "&selClass=" & SelClass & "&mySelectProvince=" & Province & "&mySelectCity=" & City & "&SearchType=" & SearchType & ""
    End Select
    Dim rsSupply
    
    Set rsSupply = Server.CreateObject("Adodb.RecordSet")
    rsSupply.Open strSql, Conn, 1, 1
    If rsSupply.EOF And rsSupply.BOF Then
        SearchResult = "<li>没有搜索到任何信息</li>"
        rsSupply.Close
        Set rsSupply = Nothing
        Exit Function
    Else
        Do While Not rsSupply.EOF
            strTemp = strTemp & "<tr><td><Img src='" & ChannelUrl & "/Images/article_common.gif' border=0/>"
            strTemp = strTemp & "<font color=red>[" & GetSupplyInfoType(rsSupply("SupplyType"), "//SupplyType/Type") & "]</font>"
            strTemp = strTemp & "<a href='" & ChannelUrl & "/ShowSupply.asp?SupplyId=" & rsSupply("SupplyId") & "'"
            If OpenType = 0 Then
                strTemp = strTemp & " target = '_self' "
            Else
                strTemp = strTemp & " target = '_blank' "
            End If
            strTemp = strTemp & ">" & rsSupply("SupplyTitle") & "</a></td><td align='center'>" & GetSupplyInfoType(rsSupply("TradeType"), "//TradeType/Type") & "</td><td>" & rsSupply("Province") & "/" & rsSupply("City") & "</td><td>" & rsSupply("UpDateTime") & "</td></tr>" & vbCrLf
            rsSupply.MoveNext
        Loop
    End If
    rsSupply.Close
    Set rsSupply = Nothing
    SearchResult = "<Table>" & strTemp & "</Table>"
End Function




'==================================================
'函数名：ShowPath
'作  用：显示“你现在所有位置”导航信息
'参  数：无
'==================================================
Private Function ShowPath()
    If PageTitle <> "" Then
        strNavPath = strNavPath & "&nbsp;" & strNavLink & "&nbsp;" & PageTitle
    End If
    ShowPath = strNavPath
End Function

Private Function GetClassUrl(iClassID)
    GetClassUrl = ChannelUrl & "/ShowClass.asp?ClassID=" & iClassID
End Function

Private Function GetClass_1Url(iClassID)
    GetClass_1Url = ChannelUrl & "/ShowClass.asp?ShowType=2&ClassID=" & iClassID
End Function


Private Function GetExecuteSql(ByVal PageType, ByVal ClassID, ByVal CommandType, ByVal IsNew, ByVal IsHot, ByVal ShowNum, ByVal SupplyType, ByVal Flage)
    Dim strSql, QuerySql, MaxShowInfo
    QuerySql = QuerySql & "From SQ_Supply A,SQ_Contacter B,SQ_User C "
    QuerySql = QuerySql & "Where A.UserName=C.UserName and C.ContacterID = B.ContacterID and A.Status=1 And Deleted=" & SQ_False & " "
    If Flage Then
        QuerySql = QuerySql & " And A.SupplyPicUrl<>'' "
    End If
    Select Case PageType
        Case 0
            MaxShowInfo = ShowNum
        Case 1 '栏目页
            MaxShowInfo = MaxPerPage
            If Child > 0 Then
                totalPut = getInfoCounts(arrChildID, 0, SupplyType)
            Else
                totalPut = getInfoCounts(ClassID, 0, SupplyType)
            End If
        Case 2  '推荐页
            MaxShowInfo = MaxPerPage_Elite
            CommandType = 3
            If Flage Then
                totalPut = getInfoCounts(0, 5, SupplyType) '调用又图片的推荐信息
            Else
                totalPut = getInfoCounts(0, 2, SupplyType) '无图片的推荐信息
            End If
        Case 3 '热点页
            MaxShowInfo = MaxPerPage_Hot
            totalPut = getInfoCounts(0, 3, SupplyType)
        Case 4 '专题页
            MaxShowInfo = MaxPerPage_Special
            totalPut = getInfoCounts(0, 4, SupplyType)
        Case 5 '最新页
            MaxShowInfo = MaxPerPage_New
            totalPut = getInfoCounts(0, 1, SupplyType) '最新的信息
        Case Else
            MaxShowInfo = MaxPerPage_Index
    End Select
    If ClassID > 0 Then
        If Child > 0 Then
            QuerySql = QuerySql & " and A.ClassID in (" & arrChildID & ")"
        Else
            QuerySql = QuerySql & " and A.ClassID=" & ClassID
        End If
    ElseIf SpecialID > 0 Then
        QuerySql = QuerySql & "And A.SpecialId=" & SpecialID
    End If
   
    Select Case CommandType
        Case 1
            QuerySql = QuerySql & "And A.CommandType=" & CommandType & " And DateDiff(" & SQ_DatePart_D & ",A.UpdateTime," & SQ_Now & ") < A.CommandChannelDays "
        Case 2
            QuerySql = QuerySql & "And A.CommandType=" & CommandType & " And DateDiff(" & SQ_DatePart_D & ",A.UpdateTime," & SQ_Now & ") < A.CommandClassDays "
        Case 3
            QuerySql = QuerySql & "And A.CommandType<>0"
    End Select
    If IsNew Then
        QuerySql = QuerySql & " And DateDiff(" & SQ_DatePart_D & "," & SQ_Now & ",A.UpdateTime)< " & DaysOfNew & ""
    End If

    If IsHot Then
        QuerySql = QuerySql & " And Hits >= " & HitsOfHot & ""
    End If
    If SupplyType >= 0 Then
        QuerySql = QuerySql & " And  SupplyType = " & SupplyType & ""
    End If

    If CurrentPage > 1 Then
        QuerySql = QuerySql & " and A.SupplyID < (select min(SupplyId) from (select top " & ((CurrentPage - 1) * MaxShowInfo) & " A.SupplyId " & QuerySql & " order by A.SupplyId desc) as QueryArticle) "
    End If
    strSql = "Select Top " & MaxShowInfo & " A.SupplyId,A.ClassId,A.SupplyTitle,A.SupplyName,A.SupplyType,"
    strSql = strSql & "A.TradeType,A.SupplyPicUrl,A.UpDateTime,B.Country,B.Province,B.City "
    
    strSql = strSql & QuerySql & " order by A.SupplyId desc "
    GetExecuteSql = strSql
End Function

'*****************************
'获得多列式信息列表
'ClassId --- 分类
'CommandType --- 推荐类型
'iCols--每行显示几条
'iLength--每条信息显示多长
'IsNew  ---- 是否显示最新信息
'刘永涛
'2005-12-21
'****************************************
Private Function getInfoList(PageType, ClassID, CommandType, iCols, iLength, IsNew, IsHot, iWeight, iHeight, ShowNum, SupplyType, ShowInfoType)
    Dim strTable, strTemp, Rows, rsSupply, strSql
    Set rsSupply = Server.CreateObject("ADODB.RecordSet")
    strSql = GetExecuteSql(PageType, ClassID, CommandType, IsNew, IsHot, ShowNum, SupplyType, False)
    rsSupply.Open strSql, Conn, 1, 1
    Rows = 0
    If rsSupply.EOF And rsSupply.BOF Then
        getInfoList = "<li>没有任何信息!</li>"
        rsSupply.Close
        Set rsSupply = Nothing
        Exit Function
    Else
        Do While Not rsSupply.EOF
            Rows = Rows + 1
            strTemp = strTemp & "<td><Img src='" & ChannelUrl & "/Images/article_common.gif' border=0/>"
            If ShowInfoType Then
                strTemp = strTemp & "<a href='" & ChannelUrl & "/Search.asp?SupplyType=" & rsSupply("SupplyType") & "&SearchType=0'><font color=red>[" & GetSupplyInfoType(rsSupply("SupplyType"), "//SupplyType/Type") & "]</font></a>"
            End If
            strTemp = strTemp & "<a href='" & ChannelUrl & "/ShowSupply.asp?SupplyId=" & rsSupply("SupplyId") & "'"
            If OpenType = 0 Then
                strTemp = strTemp & " target ='_self' "
            Else
                strTemp = strTemp & " target = '_blank' "
            End If
            strTemp = strTemp & ">"
            strTemp = strTemp & Left(rsSupply("SupplyTitle"), iLength) & "</a></td>" & vbCrLf
            If (Rows Mod iCols) = 0 Then
                strTable = strTable & "<tr>" & strTemp & "</tr>" & vbCrLf
                strTemp = ""
            End If
            rsSupply.MoveNext
        Loop
    End If
    rsSupply.Close
    Set rsSupply = Nothing
    strTable = strTable & "<tr>" & strTemp & "</tr>" & vbCrLf
    getInfoList = "<Table Width='100%'>" & strTable & "</Table>"
End Function

Private Function getHotSupplyInfo(ByVal iCols, ByVal iLength, ByVal ShowNum)
    Dim strSql, strTable, strTemp, Rows, rsSupply
    strSql = "Select Top " & ShowNum & " SupplyID,SupplyTitle From SQ_Supply Where Hits >= " & HitsOfHot & " And Deleted=" & SQ_False & " And Status=1 Order By SupplyID DESC"
    Set rsSupply = Server.CreateObject("ADODB.RecordSet")
    rsSupply.Open strSql, Conn, 1, 1
    Rows = 0
    If rsSupply.EOF And rsSupply.BOF Then
        getHotSupplyInfo = "<li>没有热点信息!</li>"
        rsSupply.Close
        Set rsSupply = Nothing
        Exit Function
    Else
        Do While Not rsSupply.EOF
            Rows = Rows + 1
            strTemp = strTemp & "<td><a href='" & ChannelUrl & "/ShowSupply.asp?SupplyId=" & rsSupply("SupplyId") & "'"
            If OpenType = 0 Then
                strTemp = strTemp & " target = '_self' "
            Else
                strTemp = strTemp & " target = '_blank' "
            End If

            strTemp = strTemp & ">"
            strTemp = strTemp & Left(rsSupply("SupplyTitle"), iLength) & "</a></td>" & vbCrLf
            If (Rows Mod iCols) = 0 Then
                strTable = strTable & "<tr>" & strTemp & "</tr>" & vbCrLf
                strTemp = ""
            End If
            rsSupply.MoveNext
        Loop
    End If
    rsSupply.Close
    Set rsSupply = Nothing
    strTable = strTable & "<tr>" & strTemp & "</tr>" & vbCrLf
    getHotSupplyInfo = "<Table Width='100%'>" & strTable & "</Table>"
End Function

Private Function getCommandSupplyInfo(ByVal CommandType, ByVal iCols, ByVal iLength, ByVal ShowNum)
    Dim strSql, strTable, strTemp, Rows, rsSupply, QuerySql
    Select Case CommandType
        Case 1
            QuerySql = "CommandType=" & CommandType & " And DateDiff(" & SQ_DatePart_D & ",UpdateTime," & SQ_Now & ") < CommandChannelDays "
        Case 2
            QuerySql = "CommandType=" & CommandType & " And DateDiff(" & SQ_DatePart_D & ",UpdateTime," & SQ_Now & ") < CommandClassDays "
        Case Else
            QuerySql = "CommandType<>0"
    End Select
    strSql = "Select Top " & ShowNum & " SupplyId,SupplyTitle From SQ_Supply Where " & QuerySql & " And Deleted=" & SQ_False & " And Status=1 Order By SupplyId DESC"
    Set rsSupply = Server.CreateObject("ADODB.RecordSet")
    rsSupply.Open strSql, Conn, 1, 1
    Rows = 0
    If rsSupply.EOF And rsSupply.BOF Then
        getCommandSupplyInfo = "<li>没有推荐信息!</li>"
        rsSupply.Close
        Set rsSupply = Nothing
        Exit Function
    Else
        Do While Not rsSupply.EOF
            Rows = Rows + 1
            strTemp = strTemp & "<td><a href='" & ChannelUrl & "/ShowSupply.asp?SupplyId=" & rsSupply("SupplyId") & "'"
            If OpenType = 0 Then
                strTemp = strTemp & " target = '_self' "
            Else
                strTemp = strTemp & " target ='_blank' "
            End If
            strTemp = strTemp & ">"
            strTemp = strTemp & Left(rsSupply("SupplyTitle"), iLength) & "</a></td>" & vbCrLf
            If (Rows Mod iCols) = 0 Then
                strTable = strTable & "<tr>" & strTemp & "</tr>" & vbCrLf
                strTemp = ""
            End If
            rsSupply.MoveNext
        Loop
    End If
    rsSupply.Close
    Set rsSupply = Nothing
    strTable = strTable & "<tr>" & strTemp & "</tr>" & vbCrLf
    getCommandSupplyInfo = "<Table Width='100%'>" & strTable & "</Table>"
End Function

Private Function getLasterSupplyInfo(ByVal iCols, ByVal iLength, ByVal ShowNum)
    Dim strSql, strTable, strTemp, Rows, rsSupply
    strSql = "Select Top " & ShowNum & " SupplyId,SupplyTitle From SQ_Supply Where DateDiff(" & SQ_DatePart_D & "," & SQ_Now & ",UpdateTime)< " & DaysOfNew & " And Deleted=" & SQ_False & " And Status=1 Order by SupplyId DESC"
    Set rsSupply = Server.CreateObject("ADODB.RecordSet")
    rsSupply.Open strSql, Conn, 1, 1
    Rows = 0
    If rsSupply.EOF And rsSupply.BOF Then
        getLasterSupplyInfo = "<li>没有最新信息!</li>"
        rsSupply.Close
        Set rsSupply = Nothing
        Exit Function
    Else
        Do While Not rsSupply.EOF
            Rows = Rows + 1
            strTemp = strTemp & "<td Class='LasterStyle'><a href='" & ChannelUrl & "/ShowSupply.asp?SupplyId=" & rsSupply("SupplyId") & "'"
            If OpenType = 0 Then
                strTemp = strTemp & " target = '_self' "
            Else
                strTemp = strTemp & " target = '_blank' "
            End If
            strTemp = strTemp & ">"
            strTemp = strTemp & Left(rsSupply("SupplyTitle"), iLength) & "</a></td>" & vbCrLf
            If (Rows Mod iCols) = 0 Then
                strTable = strTable & "<tr>" & strTemp & "</tr>" & vbCrLf
                strTemp = ""
            End If
            rsSupply.MoveNext
        Loop
    End If
    rsSupply.Close
    Set rsSupply = Nothing
    strTable = strTable & "<tr>" & strTemp & "</tr>" & vbCrLf
    getLasterSupplyInfo = "<Table Width='100%'>" & strTable & "</Table>"
End Function
Private Function getPicLasterInfo(ByVal iCols, ByVal iLength, ByVal ShowNum, ByVal iWidth, ByVal iHeight)
    Dim strSql, rsSupply, Rows, strTemp, strTable, QuerySql
    If ClassID > 0 Then
        If Child > 0 Then
            QuerySql = " And ClassID in (" & arrChildID & ")"
        Else
            QuerySql = " And ClassID=" & ClassID
        End If
    ElseIf SpecialID > 0 Then
        QuerySql = "And SpecialId=" & SpecialID
    End If

    strSql = "Select Top " & ShowNum & " SupplyID,SupplyTitle,SupplyPicUrl From SQ_Supply Where SupplyPicUrl<>'' And Deleted=" & SQ_False & " And Status=1 And DateDiff(" & SQ_DatePart_D & "," & SQ_Now & ",UpdateTime)< " & DaysOfNew & " " & QuerySql & " Order By SupplyID"
   
    Set rsSupply = Server.CreateObject("ADODB.RecordSet")
    rsSupply.Open strSql, Conn, 1, 1
    Rows = 0
    If rsSupply.EOF And rsSupply.BOF Then
        getPicLasterInfo = "<li>没有最新图片信息!</li>"
        rsSupply.Close
        Set rsSupply = Nothing
        Exit Function
    Else
        Do While Not rsSupply.EOF
            Rows = Rows + 1
            strTemp = strTemp & "<Td><Table><tr><td><a href='" & ChannelUrl & "/ShowSupply.asp?SupplyId=" & rsSupply("SupplyId") & "'"
            If OpenType = 0 Then
                strTemp = strTemp & " target = '_self' "
            Else
                strTemp = strTemp & " target = '_blank' "
            End If
            strTemp = strTemp & ">"
            strTemp = strTemp & "<Img src=" & UploadDir & "/" & getDefaultPicUrl(rsSupply("SupplyPicUrl")) & " border='0 'width ='" & iWidth & "' height='" & iHeight & "' alt=" & rsSupply("SupplyTitle") & " /></a></td></tr><tr><td><a href='" & ChannelUrl & "/ShowSupply.asp?SupplyId=" & rsSupply("SupplyId") & "'>" & Left(rsSupply("SupplyTitle"), iLength) & "</a></td></tr></Table></td>"
            If (Rows Mod iCols) = 0 Then
                strTable = strTable & "<tr>" & strTemp & "</tr>" & vbCrLf
                strTemp = ""
            End If
            rsSupply.MoveNext
        Loop
    End If
    rsSupply.Close
    Set rsSupply = Nothing
    strTable = strTable & "<tr>" & strTemp & "</tr>" & vbCrLf
    getPicLasterInfo = "<Table Width='100%'>" & strTable & "</Table>"
End Function
'*******************************************
'获得图片信息列表样式
'ShowNum -----------每页显示的信息数
'CurrentPage -------当前页数
'KeyWords ----------关键字
'Flag --------------是否有分页
'iLength -----------标题长度
'iWidth  -----------图片的宽度
'iHeight -----------图片的高度
'******************************************
Private Function getListPicInfoList(ByVal PageType, ByVal ClassID, ByVal CommandType, ByVal iCols, ByVal iLength, ByVal IsNew, ByVal IsHot, ByVal iWidth, ByVal iHeight, ByVal ShowNum, ByVal SupplyType, ByVal ShowInfoType)
    Dim strSql, rsSupply, Rows, strTemp
    
    strSql = GetExecuteSql(PageType, ClassID, CommandType, IsNew, IsHot, ShowNum, SupplyType, True)
    Set rsSupply = Server.CreateObject("ADODB.RecordSet")
    rsSupply.Open strSql, Conn, 1, 1
    If rsSupply.EOF And rsSupply.BOF Then
        getListPicInfoList = "<li>没有图片信息!</li>"
        rsSupply.Close
        Set rsSupply = Nothing
        Exit Function
    Else
        Do While Not rsSupply.EOF
            strTemp = strTemp & "<tr><td><a href='" & ChannelUrl & "/ShowSupply.asp?SupplyId=" & rsSupply("SupplyId") & "'"
            If OpenType = 0 Then
                strTemp = strTemp & " target = '_self' "
            Else
                strTemp = strTemp & " target = '_blank' "
            End If
            strTemp = strTemp & "><img width =" & iWidth & " height=" & iHeight & " src=" & UploadDir & "/" & getDefaultPicUrl(rsSupply("SupplyPicUrl")) & " border=0 /></a></td><td>"
            If ShowInfoType Then
                strTemp = strTemp & "<a href='" & ChannelUrl & "/Search.asp?SupplyType=" & rsSupply("SupplyType") & "&SearchType=0'><font color=red>[" & GetSupplyInfoType(rsSupply("SupplyType"), "//SupplyType/Type") & "]</font></a>"
            End If
            strTemp = strTemp & "<a href='" & ChannelUrl & "/ShowSupply.asp?SupplyId=" & rsSupply("SupplyId") & "'>" & Left(rsSupply("SupplyTitle"), iLength) & "</a></td><td>" & rsSupply("Province") & "/" & rsSupply("City") & "</td><td>" & GetSupplyInfoType(rsSupply("TradeType"), "//TradeType/Type") & "</td></tr>"
            rsSupply.MoveNext
        Loop
    End If
    rsSupply.Close
    Set rsSupply = Nothing
   
    getListPicInfoList = "<Table Width='100%'>" & strTemp & "</Table>"
End Function
Private Function getDefaultPicUrl(ByVal PicUrl)
    Dim arrPicUrl
    If Not (IsNull(PicUrl)) Or PicUrl <> "" Then
        arrPicUrl = Split(PicUrl, "|")
        getDefaultPicUrl = arrPicUrl(0)
    End If
End Function
'获得图片列表样式一
Private Function getPicInfoList(ByVal PageType, ByVal ClassID, ByVal CommandType, ByVal iCols, ByVal iLength, ByVal IsNew, ByVal IsHot, ByVal iWidth, ByVal iHeight, ByVal ShowNum, ByVal SupplyType, ByVal ShowInfoType)
    Dim strSql, rsSupply, Rows, strTemp, strTable
    
   strSql = GetExecuteSql(PageType, ClassID, CommandType, IsNew, IsHot, ShowNum, SupplyType, True)

    Set rsSupply = Server.CreateObject("ADODB.RecordSet")
    rsSupply.Open strSql, Conn, 1, 1
    Rows = 0
    If rsSupply.EOF And rsSupply.BOF Then
        getPicInfoList = "<li>没有图片信息!<li>"
        rsSupply.Close
        Set rsSupply = Nothing
        Exit Function
    Else
        Do While Not rsSupply.EOF
            Rows = Rows + 1
            strTemp = strTemp & "<Td><Table><tr><td><a href='" & ChannelUrl & "/ShowSupply.asp?SupplyId=" & rsSupply("SupplyId") & "'"
            If OpenType = 0 Then
                strTemp = strTemp & " target = '_self' "
            Else
                strTemp = strTemp & " target = '_blank' "
            End If
            strTemp = strTemp & "><Img src=" & UploadDir & "/" & getDefaultPicUrl(rsSupply("SupplyPicUrl")) & " border='0 'width ='" & iWidth & "' height='" & iHeight & "' alt=" & rsSupply("SupplyTitle") & " /></a></td></tr><tr><td>"
            If ShowInfoType Then
                strTemp = strTemp & "<a href='" & ChannelUrl & "/Search.asp?SupplyType=" & rsSupply("SupplyType") & "&SearchType=0'><font color=red>[" & GetSupplyInfoType(rsSupply("SupplyType"), "//SupplyType/Type") & "]</font></a>"
            End If
            strTemp = strTemp & "<a href='" & ChannelUrl & "/ShowSupply.asp?SupplyId=" & rsSupply("SupplyId") & "'>" & Left(rsSupply("SupplyTitle"), iLength) & "</a></td></tr></Table></td>"
            If (Rows Mod iCols) = 0 Then
                strTable = strTable & "<tr>" & strTemp & "</tr>" & vbCrLf
                strTemp = ""
            End If
            rsSupply.MoveNext
        Loop
    End If
    rsSupply.Close
    Set rsSupply = Nothing
    strTable = strTable & "<tr>" & strTemp & "</tr>" & vbCrLf
    getPicInfoList = "<Table Width='100%'>" & strTable & "</Table>"
End Function


'获得信息列表
'2005-11-21
'刘永涛
Private Function getDetailInfoList(PageType, ClassID, CommandType, iCols, iLength, IsNew, IsHot, iWeight, iHeight, ShowNum, SupplyType, ShowInfoType)
    Dim strSql, strTable, strTemp, Rows, rsSupply
 
    strSql = GetExecuteSql(PageType, ClassID, CommandType, IsNew, IsHot, ShowNum, SupplyType, False)
    
    Set rsSupply = Server.CreateObject("ADODB.RecordSet")
    rsSupply.Open strSql, Conn, 1, 1
    If rsSupply.EOF And rsSupply.BOF Then
        getDetailInfoList = "<li>没有信息!<li>"
        rsSupply.Close
        Set rsSupply = Nothing
        Exit Function
    Else
        Do While Not rsSupply.EOF
            
            strTemp = strTemp & "<tr><td><Img src='" & ChannelUrl & "/Images/article_common.gif' border=0/>"
            If ShowInfoType Then
                strTemp = strTemp & "<a href='" & ChannelUrl & "/Search.asp?SupplyType=" & rsSupply("SupplyType") & "&SearchType=0'><font color=red>[" & GetSupplyInfoType(rsSupply("SupplyType"), "//SupplyType/Type") & "]</font></a>"
            End If
            strTemp = strTemp & "<a href=" & ChannelUrl & "/ShowSupply.asp?SupplyId=" & rsSupply("SupplyId") & ""
            If OpenType = 0 Then
                strTemp = strTemp & " target = '_self' "
            Else
                strTemp = strTemp & " target = '_blank' "
            End If
            strTemp = strTemp & ">" & Left(rsSupply("SupplyTitle"), iLength) & "</a></td><td align='center'>" & GetSupplyInfoType(rsSupply("TradeType"), "//TradeType/Type") & "</td><td>" & rsSupply("Province") & "/" & rsSupply("City") & "</td><td>" & rsSupply("UpDateTime") & "</td></tr>" & vbCrLf
            rsSupply.MoveNext
        Loop
    End If
    rsSupply.Close
    Set rsSupply = Nothing
    getDetailInfoList = "<Table Width='100%'>" & strTemp & "</Table>"
End Function

'获得某一类别下的所有信息数
'2005-11-18
'刘永涛
Private Function getInfoCounts(ByVal ClassID, ByVal iType, ByVal SupplyType)
    'Call OpenConn()
    Dim strSql, QuerySql
    If SupplyType >= 0 Then
        QuerySql = " And SupplyType=" & SupplyType & " "
    End If
    Select Case iType
        Case 0
            strSql = "Select Count(*) From SQ_Supply Where Status=1 And Deleted=" & SQ_False & " And ClassId in (" & ClassID & ")"
        Case 1 '最新页的数量统计
            strSql = "Select Count(*) From SQ_Supply Where Status=1 And Deleted=" & SQ_False & " And DateDiff(" & SQ_DatePart_D & "," & SQ_Now & ",UpdateTime)<" & DaysOfNew & ""
        Case 2 '推荐页的数量统计
            strSql = "Select Count(*) From SQ_Supply Where Status=1 And Deleted=" & SQ_False & " And CommandType<>0"
        Case 3
            strSql = "Select Count(*) From SQ_Supply Where Status=1 And Deleted=" & SQ_False & " And Hits>=" & HitsOfHot & ""
        Case 4
            strSql = "Select Count(*) From SQ_Supply Where Status=1 And Deleted=" & SQ_False & " And SpecialId=" & SpecialID & ""
        Case 5
            strSql = "Select Count(*) From SQ_Supply Where Status=1 And Deleted=" & SQ_False & " And CommandType<>0 And SupplyPicUrl<>''"
    End Select
    getInfoCounts = SQ_CLng(Conn.Execute(strSql & QuerySql)(0))
End Function

'=================================================
'函数名：ShowChannelCount
'作  用：显示频道统计信息
'参  数：无
'=================================================
Private Function GetChannelCount()
    Dim HitsCount_Channel, rs
    Set rs = Conn.Execute("select sum(Hits) from SQ_Supply where ChannelID=" & ChannelID)
    If IsNull(rs(0)) Then
        HitsCount_Channel = 0
    Else
        HitsCount_Channel = rs(0)
    End If
    rs.Close
    Set rs = Nothing
    GetChannelCount = Replace(Replace(Replace(Replace(Replace(Replace(R_XmlText_Class("ChannelCount", "{$ChannelShortName}总数： {$ItemChecked_Channel} {$ChannelItemUnit}<br>待审{$ChannelShortName}： {$UnItemChecked} {$ChannelItemUnit}<br>评论总数： {$CommentCount_Channel} 条<br>专题总数： {$SpecialCount_Channel} 个<br>{$ChannelShortName}阅读： {$HitsCount_Channel} 人次<br>"), "{$ItemChecked_Channel}", ItemChecked_Channel), "{$ChannelItemUnit}", ChannelItemUnit), "{$UnItemChecked}", ItemCount_Channel - ItemChecked_Channel), "{$CommentCount_Channel}", CommentCount_Channel), "{$SpecialCount_Channel}", SpecialCount_Channel), "{$HitsCount_Channel}", HitsCount_Channel)
End Function


Private Function GetSupplyAction()
    GetSupplyAction = Replace(Replace(Replace(Replace(R_XmlText_Class("SupplyAction", "【<a href='{$ChannelUrl}/Comment.asp?SupplyID={$SupplyID}' target='_blank'>发表评论</a>】【<a href='{$InstallDir}User/User_Favorite.asp?Action=Add&ChannelID={$ChannelID}&InfoID={$SupplyID}' target='_blank'>加入收藏</a>】【<a href='javascript:window.close();'>关闭窗口</a>】"), "{$ChannelUrl}", ChannelUrl), "{$SupplyID}", SupplyID), "{$InstallDir}", strInstallDir), "{$ChannelID}", ChannelID)
End Function


Private Function GetSupplyUrl(ByVal SupplyID)
    GetSupplyUrl = strInstallDir & ChannelDir & "/ShowSupply.asp?SupplyID=" & SupplyID
End Function


Private Sub GetRegionValue()
    Response.Write "<script language='javascript'> " & vbCrLf
    Response.Write "getSelected('Region.asp',-1);" & vbCrLf
    Response.Write " var http_request = false; " & vbCrLf
    Response.Write " function InitRequest() {//初始化、指定处理函数、发送请求的函数 " & vbCrLf
    Response.Write "     http_request = false; " & vbCrLf
    Response.Write "     //开始初始化XMLHttpRequest对象 " & vbCrLf
    Response.Write "     if(window.XMLHttpRequest) { //Mozilla 浏览器 " & vbCrLf
    Response.Write "         http_request = new XMLHttpRequest(); " & vbCrLf
    Response.Write "         if (http_request.overrideMimeType) {//设置MiME类别 " & vbCrLf
    Response.Write "             http_request.overrideMimeType('text/xml'); " & vbCrLf
    Response.Write "         } " & vbCrLf
    Response.Write "     } " & vbCrLf
    Response.Write "     else if (window.ActiveXObject) { // IE浏览器 " & vbCrLf
    Response.Write "         try { " & vbCrLf
    Response.Write "             http_request = new ActiveXObject('Msxml2.XMLHTTP'); " & vbCrLf
    Response.Write "         } catch (e) { " & vbCrLf
    Response.Write "             try { " & vbCrLf
    Response.Write "                 http_request = new ActiveXObject('Microsoft.XMLHTTP'); " & vbCrLf
    Response.Write "             } catch (e) {} " & vbCrLf
    Response.Write "         } " & vbCrLf
    Response.Write "     } " & vbCrLf
    Response.Write "     if (!http_request) { // 异常，创建对象实例失败 " & vbCrLf
    Response.Write "         window.alert('不能创建XMLHttpRequest对象实例.'); " & vbCrLf
    Response.Write "         return false; " & vbCrLf
    Response.Write "     } " & vbCrLf
    Response.Write "      " & vbCrLf
    Response.Write " } " & vbCrLf
    Response.Write " //设定初始值 " & vbCrLf
    Response.Write " function getSelectValue(url,SelectName) " & vbCrLf
    Response.Write " { " & vbCrLf
    Response.Write "     InitRequest(); " & vbCrLf
    Response.Write "     http_request.onreadystatechange = function() " & vbCrLf
    Response.Write "     { " & vbCrLf
    Response.Write "         if (http_request.readyState == 4)  " & vbCrLf
    Response.Write "         { // 判断对象状态 " & vbCrLf
    Response.Write "             if (http_request.status == 200)  " & vbCrLf
    Response.Write "             { // 信息已经成功返回，开始处理信息 " & vbCrLf
    Response.Write "                //alert(unescape(http_request.responseText));" & vbCrLf
    Response.Write "                getClass(unescape(http_request.responseText),SelectName); " & vbCrLf
    Response.Write "             } else { //页面不正常 " & vbCrLf
    Response.Write "                 alert('您所请求的页面有异常。'); " & vbCrLf
    Response.Write "             } " & vbCrLf
    Response.Write "         } " & vbCrLf
    Response.Write "     }        " & vbCrLf
    Response.Write "     // 确定发送请求的方式和URL以及是否同步执行下段代码 " & vbCrLf
    Response.Write "     http_request.open('GET',url, false); " & vbCrLf
    Response.Write "     http_request.send(null); " & vbCrLf
    Response.Write " } " & vbCrLf
    Response.Write " function getClass(node,SelectName) " & vbCrLf
    Response.Write " { " & vbCrLf
    Response.Write "     SelectName.options.length =1 ;"
    Response.Write "     var arrstr = new Array(); " & vbCrLf
    Response.Write "     arrstr = node.split(','); " & vbCrLf
    Response.Write "     for(var i=0;i<arrstr.length-1;i++) " & vbCrLf
    Response.Write "     { " & vbCrLf
    Response.Write "         SelectName.options[i+1] =new Option(arrstr[i]); " & vbCrLf
    Response.Write "         SelectName.options[i+1].value = arrstr[i]; " & vbCrLf
    Response.Write "     } " & vbCrLf
    Response.Write " } " & vbCrLf
    Response.Write " function getSelected(url,selValue)" & vbCrLf
    Response.Write " {" & vbCrLf
    Response.Write "    if(selValue==-1)" & vbCrLf
    Response.Write "    {" & vbCrLf
    Response.Write "        getSelectValue(url,document.Searchform.mySelectProvince);" & vbCrLf
    Response.Write "    }else{" & vbCrLf
    Response.Write "        getSelectValue(url,selValue);" & vbCrLf
    Response.Write "    }" & vbCrLf
    Response.Write " }" & vbCrLf
    Response.Write "</script> " & vbCrLf
End Sub

Public Sub ShowFavorite()
    Response.Write "<table width='100%' cellpadding='2' cellspacing='1' border='0' class='border'>"
    Response.Write "  <tr class='title' align='center'><td width='30'>选中</td><td>" & ChannelShortName & "标题</td><td width='100'>发布人</td><td width='80'>更新时间</td><td width='80'>操作</td></tr>"
    
    Dim sqlFavorite, rsFavorite, iCount, strLink
    iCount = 0
    
    sqlFavorite = "select A.ChannelID,A.SupplyID,A.ClassID,C.ClassName,C.ParentDir,C.ClassDir,C.ClassPurview,A.SupplyTitle,A.UserName,A.UpdateTime,A.SupplyPicUrl from SQ_Supply A left join SQ_Class C on A.ClassID=C.ClassID where A.Deleted=" & SQ_False & " and A.Status=1 "
    sqlFavorite = sqlFavorite & " and SupplyID in (select InfoID from SQ_Favorite where ChannelID=" & ChannelID & " and UserID=" & UserID & ")"
    sqlFavorite = sqlFavorite & " order by A.SupplyID desc"
    MaxPerPage = 20
    Set rsFavorite = Server.CreateObject("ADODB.Recordset")
    rsFavorite.Open sqlFavorite, Conn, 1, 1
    If rsFavorite.BOF And rsFavorite.EOF Then
        totalPut = 0
        Response.Write "<tr class='tdbg'><td height='50' colspan='20' align='center'>没有收藏任何" & ChannelShortName & "</td></tr>"
    Else
        totalPut = rsFavorite.RecordCount
        If CurrentPage < 1 Then
            CurrentPage = 1
        End If
        If (CurrentPage - 1) * MaxPerPage > totalPut Then
            If (totalPut Mod MaxPerPage) = 0 Then
                CurrentPage = totalPut \ MaxPerPage
            Else
                CurrentPage = totalPut \ MaxPerPage + 1
            End If
        End If
        If CurrentPage > 1 Then
            If (CurrentPage - 1) * MaxPerPage < totalPut Then
                rsFavorite.Move (CurrentPage - 1) * MaxPerPage
            Else
                CurrentPage = 1
            End If
        End If
        
        Do While Not rsFavorite.EOF
            strLink = "[<a href='" & GetClassUrl(rsFavorite("ClassID")) & "'>" & rsFavorite("ClassName") & "</a>] "
            strLink = strLink & "<a href='" & GetSupplyUrl(rsFavorite("SupplyID")) & "' target='_blank'>" & rsFavorite("SupplyTitle") & "</a>"
            Response.Write "<tr class='tdbg'>"
            Response.Write "<td align='center' width='30'><input type='checkbox' name='InfoID' value='" & rsFavorite("SupplyID") & "'></td>"
            Response.Write "<td align='left'>" & strLink & "</td>"
            Response.Write "<td width='100' align='center'>" & rsFavorite("UserName") & "</td>"
            Response.Write "<td width='80' align='right'>" & Year(rsFavorite("UpdateTime")) & "-" & Right("0" & Month(rsFavorite("UpdateTime")), 2) & "-" & Right("0" & Day(rsFavorite("UpdateTime")), 2) & "</td>"
            Response.Write "<td width='80' align='center'><a href='User_Favorite.asp?Action=Remove&ChannelID=" & ChannelID & "&InfoID=" & rsFavorite("SupplyID") & "' onclick=""return confirm('确实不再收藏此" & ChannelShortName & "吗？');"">取消收藏</a></td>"
            Response.Write "</tr>"
            iCount = iCount + 1
            If iCount >= MaxPerPage Then Exit Do
            rsFavorite.MoveNext
        Loop
    End If
    rsFavorite.Close
    Set rsFavorite = Nothing
    Response.Write "</table>"
    Response.Write ShowPage("User_Favorite.asp?ChannelID=" & ChannelID & "", totalPut, 20, CurrentPage, True, True, ChannelItemUnit & ChannelShortName, False)
End Sub

Function XmlText_Class(ByVal iSmallNode, ByVal DefChar)
    XmlText_Class = XmlText("Supply", iSmallNode, DefChar)
End Function

Function R_XmlText_Class(ByVal iSmallNode, ByVal DefChar)
    R_XmlText_Class = Replace(XmlText("Supply", iSmallNode, DefChar), "{$ChannelShortName}", ChannelShortName)
End Function

End Class
%>
