| '================================================ '函數(shù)名：LoadStatistic '作 用：裝載頻道統(tǒng)計(jì) '參 數(shù)：moduleid ----所屬模塊 ' ChannelID ----頻道ID ' strClass ----所調(diào)用的分類(lèi)ID或者軟件類(lèi)型 ' stype ----統(tǒng)計(jì)類(lèi)型，0=全部統(tǒng)計(jì)，1=今日更新統(tǒng)計(jì)，2=點(diǎn)擊數(shù)統(tǒng)計(jì)，3=軟件容量統(tǒng)計(jì) '================================================ |
| ElseIf stype = 9 Then SQL = "SELECT * FROM NC_Article WHERE isAccept=0 " & foundsql |
| Case 1 If stype = 1 Then If isSqlDataBase = 1 Then SQL = "SELECT COUNT(ArticleID) FROM NC_Article WHERE isAccept>0 " & foundsql & " And Datediff(d,WriteTime,GetDate())=0" Else SQL = "SELECT COUNT(ArticleID) FROM NC_Article WHERE isAccept>0 " & foundsql & " And WriteTime>=Date()" End If ElseIf stype = 2 Then SQL = "SELECT SUM(AllHits) FROM NC_Article WHERE isAccept>0 " & foundsql ElseIf stype = 4 Then SQL = "SELECT SUM(DayHits) FROM NC_Article WHERE isAccept>0 " & foundsql ElseIf stype = 9 Then SQL = "SELECT * FROM NC_Article WHERE isAccept=0 " & foundsql Else SQL = "SELECT COUNT(ArticleID) FROM NC_Article WHERE isAccept>0 " & foundsql End If |
新聞熱點(diǎn)
疑難解答
