文章列表类别(93)

            ElseIf stype = 4 Then
                SQL = "SELECT SUM(DayHits) FROM NC_Article WHERE isAccept>0 " & foundsql
            Else
                SQL = "SELECT COUNT(ArticleID) FROM NC_Article WHERE isAccept>0 " & foundsql
            End If
        Case 2
            If Not IsNumeric(strClass) Then
                foundsql = foundsql & " And SoftType='" & Newasp.CheckStr(strClass) & "'"
            End If
            If stype = 1 Then
                If isSqlDataBase = 1 Then
                    SQL = "SELECT COUNT(softid) FROM NC_SoftList WHERE isAccept>0 " & foundsql & " And Datediff(d,SoftTime,GetDate())=0"
                Else
                    SQL = "SELECT COUNT(softid) FROM NC_SoftList WHERE isAccept>0 " & foundsql & " And SoftTime>=Date()"
                End If
            ElseIf stype = 2 Then
                SQL = "SELECT SUM(AllHits) FROM NC_SoftList WHERE isAccept>0 " & foundsql
            ElseIf stype = 3 Then
                SQL = "SELECT SUM(SoftSize) FROM NC_SoftList WHERE isAccept>0 " & foundsql
            ElseIf stype = 4 Then