<!-- #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
%>