文章列表类别(95)


                End If
            ElseIf stype = 2 Then
                SQL = "SELECT SUM(AllHits) FROM NC_FlashList WHERE isAccept>0 " & foundsql
            ElseIf stype = 3 Then
                SQL = "SELECT SUM(filesize) FROM NC_FlashList WHERE isAccept>0 " & foundsql
            ElseIf stype = 4 Then
                SQL = "SELECT SUM(DayHits) FROM NC_FlashList WHERE isAccept>0 " & foundsql
            Else
                SQL = "SELECT COUNT(flashid) FROM NC_FlashList WHERE isAccept>0 " & foundsql
            End If
        Case Else
            If stype = 1 Then
                If isSqlDataBase = 1 Then
                    SQL = "SELECT COUNT(userid) FROM NC_User WHERE Datediff(d,JoinTime,GetDate())=0"
                Else
                    SQL = "SELECT COUNT(userid) FROM NC_User WHERE JoinTime>=Date()"
                End If
            Else
                SQL = "SELECT COUNT(userid) FROM NC_User"
            End If
        End Select
        Set Rs = Newasp.Execute(SQL)
        If Rs.BOF And Rs.EOF Then

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:http://www.heiqu.com/3583.html