<!-- #include file="../../../include.asp" --> <% '<!-- '################################################ ' 名称 :振替伝票一覧 ' 作成日:2002/8/2 ' 作成者:山崎 ' 目的 :振替伝票の一覧画面を表示する。 ' 概要 : ' 変更履歴 ' ・振替伝票の一覧画面 ' 修正変更:(2006/11/29) 一覧表示に戻った時、選択場所にいるようにする ' :(080317小野)製造部振替伝票モードを新設 '################################################ '--> ' %> <% main() Sub main() If Not(SessionCheck()) Then Exit Sub End If Dim RouteType Dim PageType Dim DenpyoNo RouteType = Request("RouteType") PageType = Request("PageType") DenpyoNo = Request("DenpyoNo") Dim ShowDel ShowDel = Request("ShowDel") Dim Mode Mode = Request("Mode") Dim Title If Mode = "Seizo" Then Title = "製造部" End If '連続印刷用追加(070606小野) Dim DataCnt DataCnt = 0 Dim SonzaiFlg SonzaiFlg = 0 Dim Query Dim Content Query = "exec SPK伝票_振替伝票一覧 '" & GB_SystemCD & "','" & EnshuCD & "', '" & KaisyaCD & "'" Set Content = OpenQuery(Query) Do While Not(Content.BOF Or Content.EOF) If Content.Fields("伝票処理区分") <> 9 And Content.Fields("伝票処理区分") <> 10 Then If ShowDel = "1" Or (ShowDel <> "1" And Content.Fields("削除フラグ") <> 1) Then SonzaiFlg = 1 Exit Do End If End If Content.MoveNext Loop %> <html> <% = HtmlHeader("") %> <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)" name="form1" method="POST" action="fk_denpyo_contprint.asp" autocomplete="off"> <input type="hidden" name="SendValue" value=""> <input type="hidden" name="Mode" value="<% = Mode %>"> <% If InStr(RouteType, "ViewOnly") > 0 Then Response.Write(HtmlDesign(4)) Else Response.Write(HtmlDesign(1)) End If Response.Write(HttpL1(2)) If InStr(RouteType, "ViewOnly") > 0 And InStr(RouteType, "RMail") > 0 Then Response.Write(HttpL2("照会・集計ウィンドウ" ,"tblbtn( '/" & HomeAlias & "/user/bk/menu_s_viewonly.asp')", "受発信文書", "", "受信文書", "", "", "", "", "", "", "")) ElseIf InStr(RouteType, "ViewOnly") > 0 And InStr(RouteType, "SMail") > 0 Then Response.Write(HttpL2("照会・集計ウィンドウ" ,"tblbtn( '/" & HomeAlias & "/user/bk/menu_s_viewonly.asp')", "受発信文書", "", "発信文書", "", "", "", "", "", "", "")) ElseIf InStr(RouteType, "ViewOnly") > 0 Then Response.Write(HttpL2("照会・集計ウィンドウ" ,"tblbtn( '/" & HomeAlias & "/user/bk/menu_s_viewonly.asp')", "経理部", "", "伝票", "", "振替伝票", "", "", "", "", "")) ElseIf PackageMode = 1 Then Response.Write(HttpL2("メインメニュー" ,"tblbtn('/" & HomeAlias & "/user/bk/menu_cyac.asp')", "伝票", "tblbtn( '/" & HomeAlias & "/user/bk/menu_s11.asp')", Title & "振替伝票", "", "", "", "", "", "", "")) ElseIf Mode = "Seizo" Then Response.Write(HttpL2("会社選択" ,"tblbtn( '/" & HomeAlias & "/user/bk/')", GB_GyosyuMeisyo, "tblbtn( '/" & HomeAlias & "/user/bk/menu_" & GB_Gyosyu & ".asp')", "製造部", "tblbtn( '/" & HomeAlias & "/user/bk/menu_s6.asp')", Title & "振替伝票", "tblbtn( '/" & HomeAlias & "/user/bk/denpyo/fk_furikae.asp?DenpyoNo=" & DenpyoNo & "&Mode=" & Mode & "&ShowDel=" & ShowDel & "')", "", "", "", "")) 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_s1.asp')", "伝票", "tblbtn( '/" & HomeAlias & "/user/bk/menu_s11.asp')", "振替伝票", "tblbtn( '/" & HomeAlias & "/user/bk/denpyo/fk_furikae.asp?DenpyoNo=" & DenpyoNo & "&ShowDel=" & ShowDel & "')", "", "")) 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_s11.asp')", "振替伝票", "tblbtn( '/" & HomeAlias & "/user/bk/denpyo/fk_furikae.asp?DenpyoNo=" & DenpyoNo & "&ShowDel=" & ShowDel & "')", "", "")) End If Response.Write(HttpL3("", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "")) If SonzaiFlg = 0 Then Response.Write(HttpL3_1("照会", "syokaibtn()", "", "", "", "", "", "", "", "")) Else Response.Write(HttpL3_1("照会", "syokaibtn()", "印刷", "ContPrint()", "すべて印刷", "ContPrintAll()", "", "", "", "")) End If If InStr(RouteType, "ViewOnly") > 0 Then Response.Write(HttpL3_2("", "", "", "", "", "", "", "", "", "")) ElseIf ShowDel = "1" Then Response.Write(HttpL3_2("追加", "tblbtn( 'fk_furikae.asp?Mode=" & Mode & "')", "削除済みを非表示", "tblbtn( 'fk_furikae_ichiran.asp?Mode=" & Mode & "')", "", "", "", "", "", "")) Else Response.Write(HttpL3_2("追加", "tblbtn( 'fk_furikae.asp?Mode=" & Mode & "')", "削除済みを表示", "tblbtn( 'fk_furikae_ichiran.asp?ShowDel=1&Mode=" & Mode & "')", "", "", "", "", "", "")) End If Response.Write(HttpL4(Title & "振替伝票", "一覧表示")) %> <div id="L0" style="position: absolute; visibility: hidden; left: 0px; top: -2000px;"> <TABLE BORDER="0" CELLSPACING="5" CELLPADDING="0" WIDTH="100%" HEIGHT="100%"> <TR> <TD ALIGN="CENTER"> <TABLE BORDER="0" CELLSPACING="5" CELLPADDING="20" BGCOLOR="#FFFFFF" STYLE="BORDER:1px solid #000000" WIDTH="1" HEIGHT="100%"> <TR> <TD ALIGN="CENTER" BACKGROUND="/<% = HomeAlias %>/images/window_bk.gif"> <TABLE WIDTH="600" BORDER="0" CELLSPACING="0" CELLPADDING="0" HEIGHT="100%"> <TR> <TD HEIGHT="20" VALIGN="BOTTOM" WIDTH="600"> <TABLE WIDTH="660" HEIGHT="20" BORDER="1" CELLPADDING="0" CELLSPACING="0" BORDERCOLOR="#000000" BGCOLOR="#FFFFCC" CLASS="tx1416" STYLE="border-collapse: collapse"> <TR ALIGN="CENTER"> <TD WIDTH="20" HEIGHT="22"><br></TD> <TD WIDTH="135" HEIGHT="20">伝票番号</TD> <TD WIDTH="100" HEIGHT="20">取引日</TD> <TD HEIGHT="20">摘 要</TD> <TD WIDTH="125" HEIGHT="20">借方金額の合計</TD> <TD WIDTH="26" HEIGHT="20" class="tx1214">印刷</TD> </TR> </TABLE> </TD> </TR> <TR> <TD VALIGN="TOP"> <DIV ID="Layer1" STYLE="position:relative; left:0px; top:0px; width:680px; height:100%; z-index:1; border: 1px none #000000; overflow: auto; cursor: hand;"> <TABLE ID="List" WIDTH="660" BORDER="1" CELLSPACING="0" CELLPADDING="0" BGCOLOR="#FFFFFF" STYLE="border-collapse: collapse" BORDERCOLOR="#000000"> <% ' 2006.11.28 [iiDef]を追加して、伝票番号を保存する(iiDefのあるLINEは追加または変更したLINE) Dim ii, jj, iiDef ii = 0 iiDef = -1 Query = "exec SPK伝票_" & Title & "振替伝票一覧 '" & GB_SystemCD & "','" & EnshuCD & "', '" & KaisyaCD & "'" Set Content = OpenQuery(Query) Do While Not(Content.BOF Or Content.EOF) ' 2006.11.28 APPEND 3LINES If DenpyoNo = Content.Fields("伝票番号") Then iiDef = ii End If If Content.Fields("伝票処理区分") <> 9 And Content.Fields("伝票処理区分") <> 10 Then If ShowDel = "1" Or (ShowDel <> "1" And Content.Fields("削除フラグ") <> 1) Then Response.Write("<TR ALIGN=""CENTER"" onClick=""celsel(" & ii & ",'fk_furikae_view.asp?DenpyoNo=" & Content.Fields("伝票番号") & "&Mode=" & Mode & "&ShowDel=" & ShowDel & "')"" CLASS=""tx1618"" onDblClick=""syokaibtn()"">" & vbCrLf) Response.Write("<TD WIDTH=""20"" HEIGHT=""22"">") If Content.Fields("削除フラグ") = 1 Then Response.Write("x") End If Response.Write("</TD>" & vbCrLf) Response.Write("<TD WIDTH=""135"" HEIGHT=""20"">" & Content.Fields("伝票番号") & "</TD>" & vbCrLf) Response.Write("<TD WIDTH=""100"" HEIGHT=""20"">" & SetTimeYYYYMMDD(Content.Fields("取引日の先頭")) & "</TD>" & vbCrLf) Response.Write("<TD HEIGHT=""20"" ALIGN=""LEFT"" CLASS=""tx1416"">" & Spacer(3,1) & Content.Fields("伝票摘要の先頭") & "</TD>" & vbCrLf) Response.Write("<TD WIDTH=""125"" HEIGHT=""20"" ALIGN=""RIGHT"">" & ConvIntToMoney(Content.Fields("借方金額の合計"), false, false) & Spacer(3,1) & "</TD>" & vbCrLf) '連続印刷用追加(070606小野) Response.Write("<TD WIDTH='26' HEIGHT='20'>") Response.Write("<input type='checkbox' name='PrintoutFlg' value='" & Content.Fields("伝票番号") & "' onClick='event.cancelBubble = true;' >") Response.Write("</TD>" & vbCrLf) ii = ii + 1 Response.Write("</TR>") End If End If Content.MoveNext Loop '連続印刷用追加(070606小野) DataCnt = ii For jj = ii To 35 Response.Write("<TR ALIGN=""CENTER"">" & vbCrLf) Response.Write("<TD WIDTH=""20"" HEIGHT=""22""></TD>" & vbCrLf) Response.Write("<TD WIDTH=""135"" HEIGHT=""20""></TD>" & vbCrLf) Response.Write("<TD WIDTH=""100"" HEIGHT=""20""></TD>" & vbCrLf) Response.Write("<TD HEIGHT=""20""></TD>" & vbCrLf) Response.Write("<TD WIDTH=""125"" HEIGHT=""20""></TD>" & vbCrLf) Response.Write("<TD WIDTH=""26""></TD>" & vbCrLf) Response.Write("</TR>") Next %> </TABLE> </DIV> </TD> </TR> </TABLE> </TD> </TR> </TABLE> </TD> </TR> </TABLE> </div> <input type="hidden" name="DataCnt" value=<%= DataCnt %> > </form> <IFRAME name="PrintoutInline" SRC="" WIDTH="0" HEIGHT="0" FRAMEBORDER=0 MARGINHEIGHT=0 MARGINWIDTH=0 NORESIZE SCROLLING=no tabindex="-1"></IFRAME> </body> <SCRIPT LANGUAGE="JavaScript"> var lsURL lsURL = "#" function syokaibtn() { if(lsURL == "#") { alert("選択されていません"); } else { tblbtn(lsURL + "&RouteType=<% = RouteType %>"); } } function celsel(rw,lsParam) { for (k = 0; k < document.getElementById("List").rows.length; k++) { document.getElementById("List").rows[k].style.backgroundColor = ""; } //セル色クリア document.getElementById("List").rows[rw].style.backgroundColor = "#ffcdde"; //選択行色変更 lsURL = lsParam; } //連続印刷用追加(070606小野) function ContPrintAll() { if (form1.DataCnt.value == 1) { form1.PrintoutFlg.checked = true; } else { for (k=0; k<form1.PrintoutFlg.length; k++) { form1.PrintoutFlg[k].checked = true; } } ContPrint(); } function ContPrint() { var dcnt; var flag; dcnt=0; form1.SendValue.value = ""; if (form1.DataCnt.value == 1) { if (form1.PrintoutFlg.checked) { dcnt++; form1.SendValue.value = form1.SendValue.value + form1.PrintoutFlg.value + ","; } } else { for (k=0; k<form1.PrintoutFlg.length; k++) { if (form1.PrintoutFlg[k].checked) { dcnt++; form1.SendValue.value = form1.SendValue.value + form1.PrintoutFlg[k].value + ","; } } } if (dcnt > 0) { //印刷中フラグが降りている場合のみ実行する(ダイアログを出さないようにするため此処で判定) if (window.top.printingReadyState != 1) { flag = confirm("チェックボックスで指定された伝票を連続印刷します。\r\n伝票はA4縦の用紙に2伝票ずつ印刷されます。\r\n\r\nよろしいですか?"); if (flag) { var TargetURL = "fk_denpyo_contprint.asp?SendValue=" + form1.SendValue.value + "&PageType=<% = PageType %>"; if (typeof(form1.Mode) == "object") { TargetURL = TargetURL + "&Mode=" + form1.Mode.value; } PrintoutRealInline(TargetURL) } } return true; } else { alert("印刷対象伝票が指定されていません。\r\n「印刷」チェックボックスで指定してください。"); return false; } } </SCRIPT> <SCRIPT FOR="window" EVENT="onload" LANGUAGE="JavaScript"> <% ' 2006.11.28 演習一覧表示の機能を追加&モディファイ(伝票番号を引数に追加) %> <% If iiDef <> -1 Then %> celsel(<% = iiDef %>, "fk_furikae_view.asp?PageType=<% = PageType %>&DenpyoNo=<% = DenpyoNo %>&Mode=<% = Mode %>&ShowDel=<% = ShowDel %>") // celsel(<% = iiDef %>, "fm_enshu_ichiran_main_bin.asp?EnshuCD=<% = EnshuCD %>") Layer1.scrollTop = <% = (iiDef - 5) * 20 %>; <% End If %> </script> <% = HtmlFooter %> </html> <% End Sub %>