<!-- #include file="../../../include.asp" --> <!-- #include file="../../../user/bk/tyobo/fk_sokanjyomototyohyojyun_view_main_in.asp" --> <% '<!-- '################################################ ' 名称 :総勘定元帳照会 ' 作成日:2002/8/30 ' 作成者:山崎 ' 目的 :総勘定元帳の照会画面を表示する。 ' 概要 : ' <<表示>> ' ・総勘定元帳の照会と元帳の入力 '################################################ '--> ' ' %> <% main() Sub main() If Not(SessionCheck()) Then Exit Sub End If Dim Kaishibi Dim Syuryobi Kaishibi = Request("Kaishibi") Syuryobi = Request("Syuryobi") If Kaishibi = "" Then Kaishibi = GB_KaikeiKaishibi End If IF Syuryobi = "" Then Syuryobi = GB_KaikeiSyuryobi End If Dim Query Dim Content Dim ii, jj, iiSyukeihyoSelect, ShiwakeData, iiMototyoSelect, MototyoData Dim SokanjyoMototyoCD Dim DbKanjyoCD, DbShiwakeData, DbDenpyoTekiyo, DbTekiyo1, DbTekiyo2 Dim DbKanjyoMeisyo, DbMototyo Dim DbDenpyoKubun, DbDenpyoNo , DbDenpyoSEQ Dim DbTekiyo, DbTorihikibi, DbShityo, DbZandaka, DbMototyoData Dim DbKarikataKingaku, DbKashikataKingaku Dim DbKarikataKingakuTotal, DbKashikataKingakuTotal Dim DbSokanjyoMototyoCD Dim DbTaisyakuKubun Dim KanjyoCD Dim TekiyoCD Dim ViewTorihikibi Dim DenpyoKubun, DenpyoNo, DenpyoSEQ KanjyoCD = Request("KanjyoCD") TekiyoCD = Request("TekiyoCD") ViewTorihikibi = Request("ViewTorihikibi") DenpyoKubun = Request("DenpyoKubun") DenpyoNo = Request("DenpyoNo") DenpyoSEQ = Request("DenpyoSEQ") Dim RouteType RouteType = Request("RouteType") ' If ViewTorihikibi = "" Then ' ViewTorihikibi = GB_KaikeiKaishibi ' End If Dim PageType PageType = "総勘定元帳" %> <html> <% = HtmlHeader("sj3tyobored11") %> <SCRIPT LANGUAGE="JavaScript"> <!-- HomeAlias = "<% = HomeAlias %>"; HomeAliasSL = "<% = HomeAliasSL %>"; ExitFlg = 1; --> </SCRIPT> <body onkeydown="if(ExitFlg==2)ExitFlg=3;" onBeforeUnload="if(ExitFlg!=0)window.event.returnValue = ExitMsg(ExitFlg)" bgcolor="#5C70B6" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0"> <form OnKeyDown="FormKeyDown(this)" method="GET" action="rm_sokanjyomototyohyojyun.asp" target="_top" name="form1" autocomplete="off"> <input type="hidden" name="RouteType" value="<% = RouteType %>"> <% If InStr(RouteType, "ViewOnly") > 0 Then Response.Write(HtmlDesign(4)) Else Response.Write(HtmlDesign(1)) End If Response.Write(HttpL1(3)) If InStr(RouteType, "ViewOnly") > 0 Then Response.Write(HttpL2("照会・集計ウィンドウ" ,"tblbtn( '/" & HomeAlias & "/user/bk/menu_s_viewonly.asp')", "経理部", "", "自動転記帳簿", "", PageType, "", "", "", "", "")) ElseIf PackageMode = 1 Then Response.Write(HttpL2("メインメニュー" ,"tblbtn('/" & HomeAlias & "/user/bk/menu_cyac.asp')", "自動転記帳簿", "tblbtn( '/" & HomeAlias & "/user/bk/menu_cyac3.asp?MenuType=Jido')", PageType, "", "", "", "", "", "", "")) ElseIf GB_Gyosyu <> "B" Then If InStr(RouteType, "Keiribu") > 0 Then Response.Write(HttpL2("会社選択" ,"tblbtn( '/" & HomeAlias & "/user/bk/')", GB_GyosyuMeisyo, "tblbtn( '/" & HomeAlias & "/user/bk/menu_" & GB_Gyosyu & ".asp')", "経理部", "tblbtn( '/" & HomeAlias & "/user/bk/menu_s1.asp')", "帳簿", "tblbtn( '/" & HomeAlias & "/user/bk/menu_s12.asp')", PageType, "", "", "")) Else Response.Write(HttpL2("会社選択" ,"tblbtn( '/" & HomeAlias & "/user/bk/')", GB_GyosyuMeisyo, "tblbtn( '/" & HomeAlias & "/user/bk/menu_" & GB_Gyosyu & ".asp')", "社長室・総務部", "tblbtn( '/" & HomeAlias & "/user/bk/menu_s4.asp')", "財務諸表", "tblbtn( '/" & HomeAlias & "/user/bk/menu_s41.asp')", "総勘定元帳", "", "", "")) End If ElseIf GB_Gyosyu = "B" Then Response.Write(HttpL2("会社選択" ,"tblbtn( '/" & HomeAlias & "/user/bk/')", GB_GyosyuMeisyo , "tblbtn( '/" & HomeAlias & "/user/bk/menu_" & GB_Gyosyu & ".asp')", "経理業務", "tblbtn( '/" & HomeAlias & "/user/bk/menu_" & GB_Gyosyu & "1.asp')", PageType,"", "", "", "", "")) Else Response.Write(HttpL2("会社選択" ,"tblbtn( '/" & HomeAlias & "/user/bk/')", GB_GyosyuMeisyo , "tblbtn( '/" & HomeAlias & "/user/bk/menu_" & GB_Gyosyu & ".asp')", "経理業務", "tblbtn( '/" & HomeAlias & "/user/bk/menu_" & GB_Gyosyu & "1.asp')", "財務集計", "tblbtn( '/" & HomeAlias & "/user/bk/menu_" & GB_Gyosyu & "11.asp')", PageType,"", "", "")) End If Response.Write(HttpL3("", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "")) Response.Write(HttpL3_1("印刷", "PrintoutReal()", "", "", "", "", "", "", "", "")) Response.Write(HttpL3_2("", "", "", "", "", "", "", "", "", "")) Response.Write(HttpL4("総勘定元帳", "")) %> <div id="L0" style="position: absolute; visibility: hidden; left: 0px; top: -2000px;"> <TABLE BORDER="0" cellpadding="0" cellspacing="0" WIDTH="720" HEIGHT="100%"> <TR> <TD height="30" align="center"> <TABLE BORDER="1" CELLSPACING="5" bgcolor="#ffffff" style="border:1px solid #000000"> <TR> <TD ALIGN="CENTER" BACKGROUND="/<% = HomeAlias %>/images/window_bk.gif?<% = GB_STU %>"> <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" class="tx1416"> <tr> <td> <table height="30" border="0" cellpadding="0" cellspacing="0" class="tx1416"> <tr> <td> <table height="30" border="0" cellpadding="0" cellspacing="0" class="tx1416"> <tr> <td> 勘定科目:</td> <td> <select size="0" name="KanjyoCD" class="tbox4" onChange="SubmitReal(form1);" onKeydown="SelectSearchEnter(this);"> <option value=""><< 選択して下さい >></option> <% Query = "exec SPK自動転記帳簿_仕訳帳勘定科目照会 '" & GB_SystemCD & "','" & EnshuCD & "', '" & KaisyaCD & "','" & Kaishibi & "','" & Syuryobi & "'" Set Content = OpenQuery(Query) Do While Not(Content.BOF Or Content.EOF) Response.Write("<option value=""" & Content.Fields("勘定CD") & """") If Content.Fields("勘定CD") = KanjyoCD Then Response.Write(" selected") End If Response.Write(">" & Content.Fields("勘定名称") & "</option>" & vbCrLf) Content.MoveNext Loop %> </select> </td> </tr> </table> </td> <td width="10"></td> <td> <table height="30" border="0" cellpadding="0" cellspacing="0" class="tx1416"> <tr> <td>摘要:</td> <td> <select size="0" name="TekiyoCD" class="tbox4" STYLE="width:100px" onChange="SubmitReal(form1);" onKeydown="SelectSearchEnter(this);"> <option value=""> </option> <% Query = "exec SPM摘要表示一覧 '" & GB_SystemCD & "','" & EnshuCD & "', '" & KaisyaCD & "'" Set Content = OpenQuery(Query) Do While Not(Content.BOF Or Content.EOF) If Not(Content.Fields("摘要区分") = "K" AND Content.Fields("摘要CD") = KaisyaCD) Then Response.Write("<option value=""" & Content.Fields("摘要CD") & """") If Content.Fields("摘要CD") = TekiyoCD Then Response.Write(" selected") End If Response.Write(">" & Content.Fields("摘要") & "</option>" & vbCrLf) End If Content.MoveNext Loop %> </select> </td> </tr> </table> </td> <td width="10"></td> <td> <table height="30" border="0" cellpadding="0" cellspacing="0" class="tx1416"> <tr> <td>計算期間:</td> <td><input type="text" name="Syuryobi" size="12" value="<% = Syuryobi %>" onBlur="SetDate(this, 1, true)" class="tbox4"></td> <td>まで</td> </tr> </table> </td> <td width="10"></td> <td> <TABLE onClick="SubmitReal(form1);" BORDER="0" CELLSPACING="0" CELLPADDING="0" HEIGHT="30" BGCOLOR="#33CCFF" CLASS="tbtn1" WIDTH="70"> <TR> <TD WIDTH="10" BACKGROUND="/<% = HomeAlias %>/images/dlogbtn_bl.gif?<% = GB_STU %>"></TD> <TD ALIGN="CENTER" VALIGN="MIDDLE" BACKGROUND="/<% = HomeAlias %>/images/dlogbtn_bc.gif?<% = GB_STU %>" WIDTH="50">更新</TD> <TD WIDTH="10" BACKGROUND="/<% = HomeAlias %>/images/dlogbtn_br.gif?<% = GB_STU %>"></TD> </TR> </TABLE> </td> </tr> </table> </td> </tr> </table> </td> </tr> </table> </TD> </TR> <TR> <TD ALIGN="CENTER" > <% Response.Write(TyoboSokanjyoMototyoH(EnshuCD, KaisyaCD, KaisyaCD, "LD", KanjyoCD, 1, 0, TekiyoCD, Syuryobi, "")) %> </TD> </TR> </TABLE> </div> </form> </body> <% = HtmlFooter %> </html> <% End Sub %>