% ' ' ' %> <% main() Sub main() If Not(SessionCheck()) Then Exit Sub End If Dim Query Dim Content Dim PageType PageType = "総勘定元帳" Dim RouteType RouteType = Request("RouteType") Dim KanjyoCD KanjyoCD = Request("KanjyoCD") Dim Url Url = Request.ServerVariables("URL") Dim AutoPrint AutoPrint = Request("AutoPrint") '記帳の有無を確認するフラグ(照会集計画面用) Dim KichoFlg Set KichoFlg = Server.CreateObject("Scripting.Dictionary") Query = "" Query = Query & " " Query = Query & " SELECT 勘定CD, COUNT(総勘定元帳CD) AS 記帳数 " Query = Query & " FROM TSK帳簿_総勘定元帳F " Query = Query & " WHERE システムCD = '" & GB_SystemCD & "' AND 演習CD = '" & EnshuCD & "' AND 会社CD = '" & GB_KaisyaCD & "' " Query = Query & " GROUP BY 勘定CD " Query = Query & " " Set Content = OpenQuery(Query) Do While Not(Content.BOF Or Content.EOF) ' 引数は確実に文字列指定しないとダメ KichoFlg("" & Content.Fields("勘定CD")) = "" & Content.Fields("記帳数") 'Response.Write(KichoFlg(Content.Fields("勘定CD"))) Content.MoveNext Loop 'Response.Write(KichoFlg("1111")) %> <% = HtmlHeader("sj3tyobored11") %>
onLoad="PrintoutReal();"<% End If %> bgcolor="#5C70B6" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0"> <% = HtmlFooter %> <% End Sub %>