<!-- #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>&nbsp;勘定科目:</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
%>