<% ' ' %> <% main() Sub main() If Not(SessionCheck()) Then Exit Sub End If Dim Cnt Dim Total Total = 0 Dim PageType PageType = Request("PageType") Dim Label If PageType = "Uriage" Then Label = "売上帳" Else Label = "仕入帳" End If Dim RouteType RouteType = Request("RouteType") Dim ii, jj Dim Query, Content Dim AutoZandakaNyuryoku AutoZandakaNyuryoku = GetEnshuParam(EnshuCD, "残高自動計算") '取引先市場配列作成（081111小野） Dim TorihikisakiMeishoAry ReDim TorihikisakiMeishoAry(0) Dim TorihikisakiShijoAry ReDim TorihikisakiShijoAry(0) Query = "exec SPM会社全部一覧 '" & GB_SystemCD & "','" & EnshuCD & "', '" & GakuseiNo & "'" Set Content = OpenQuery(Query) Do While Not(Content.BOF Or Content.EOF) If Content.Fields("会社CD") <> KaisyaCD And Content.Fields("業種CD") <> "B" Then '（081111小野） ReDim PreServe TorihikisakiMeishoAry(UBound(TorihikisakiMeishoAry) + 1) ReDim PreServe TorihikisakiShijoAry(UBound(TorihikisakiShijoAry) + 1) TorihikisakiMeishoAry(UBound(TorihikisakiMeishoAry)) = "" & Content.Fields("会社略名称") TorihikisakiShijoAry(UBound(TorihikisakiShijoAry)) = "" & Content.Fields("市場CD") End If Content.MoveNext Loop '小売販売 If KourihanbaiRiyo() > 0 And PageType = "Uriage" Then '売上帳のみ ReDim PreServe TorihikisakiMeishoAry(UBound(TorihikisakiMeishoAry) + 1) ReDim PreServe TorihikisakiShijoAry(UBound(TorihikisakiShijoAry) + 1) TorihikisakiMeishoAry(UBound(TorihikisakiMeishoAry)) = "" & ConvKaisyaMeisyo("SJ4KOURIHANBAI") TorihikisakiShijoAry(UBound(TorihikisakiShijoAry)) = "" End If '商品市場配列作成（081111小野） Dim ShohinMeishoAry ReDim ShohinMeishoAry(0) Dim ShohinShijoAry ReDim ShohinShijoAry(0) Query = "exec SPM商品一覧 '" & GB_SystemCD & "','" & EnshuCD & "', '" & GB_GakuseiNo & "'" Set Content = OpenQuery(Query) Do While Not(Content.BOF Or Content.EOF) ReDim PreServe ShohinMeishoAry(UBound(ShohinMeishoAry) + 1) ReDim PreServe ShohinShijoAry(UBound(ShohinShijoAry) + 1) ShohinMeishoAry(UBound(ShohinMeishoAry)) = "" & Content.Fields("商品名称") If "" & Content.Fields("市場CD") <> "" Then ShohinShijoAry(UBound(ShohinShijoAry)) = "" & Content.Fields("市場CD") Else ShohinShijoAry(UBound(ShohinShijoAry)) = "higenteietnegih" End If Content.MoveNext Loop '仕訳日選択モード Dim Shiwakebi Shiwakebi = "0" If ShiwakebiSelect = 1 Then Shiwakebi = GetEnshuParam(EnshuCD, "日付仕訳日指定") End If ' Shiwakebi = "0" ' Shiwakebi = "1" Dim TmpShiwakebiAry Dim ShiwakebiAry '自前フォーム用配列 ReDim ShiwakebiAry(0) If Shiwakebi = "1" Then Query = "" Query = Query & " " Query = Query & " " Query = Query & " SELECT 取引日 " Query = Query & " FROM TSK伝票F " Query = Query & " WHERE 削除フラグ = 0 " Query = Query & " AND システムCD = '" & GB_SystemCD & "' " Query = Query & " AND 演習CD = '" & EnshuCD & "' " Query = Query & " AND 会社CD = '" & KaisyaCD & "' " Query = Query & " GROUP BY 取引日 " Query = Query & " ORDER BY 取引日 DESC " Set Content = OpenQuery(Query) Do While Not(Content.BOF Or Content.EOF) TmpShiwakebiAry = TmpShiwakebiAry & "\t" & SetTimeYYYYMMDD(Content.Fields("取引日")) ReDim PreServe ShiwakebiAry(UBound(ShiwakebiAry) + 1) '配列+1 ShiwakebiAry(UBound(ShiwakebiAry)) = "" & SetTimeYYYYMMDD(Content.Fields("取引日")) Content.MoveNext Loop End If %> <% = HtmlHeader("sj3tyobored11") %>
<% If InStr(RouteType, "HojyoboOnly") > 0 Then Response.Write(HtmlDesign(2)) Else Response.Write(HtmlDesign(1)) End If Response.Write(HttpL1(3)) If InStr(RouteType, "HojyoboOnly") > 0 Then Response.Write(HttpL2("補助簿ウィンドウ" ,"tblbtn( '/" & HomeAlias & "/user/bk/menu_s12.asp?RouteType=" & RouteType & "')", Label, "", "", "", "", "","", "", "", "")) ElseIf PackageMode = 1 Then Response.Write(HttpL2("メインメニュー" ,"tblbtn('/" & HomeAlias & "/user/bk/menu_cyac.asp')", "手入力帳簿", "tblbtn( '/" & HomeAlias & "/user/bk/menu_cyac3.asp')", Label, "", "", "", "", "", "", "")) Else 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')", Label, "tblbtn( '/" & HomeAlias & "/user/bk/hojyobo/fk_shiireuriagetyo.asp?PageType=" & PageType & "')", "", "")) End If Response.Write(HttpL3("", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "")) If GB_IEmode = "1" Then '※HttpL3_1にボタンを追加する事前処理（210107小野） Call HttpL3_1_AddBtn("行↑", "SpreadShiftRowSub(document.vaSpread1, 'Up');", "行↓", "SpreadShiftRowSub(document.vaSpread1, 'Dn');", "", "", "", "", "", "") Response.Write(HttpL3_1("保存", "SubmitCheck()", "行追加", "SpreadAddItem2(document.vaSpread1);", "行挿入", "SpreadInsertItem(document.vaSpread1);", "行削除", "SpreadDelItem(document.vaSpread1);", "", "")) Else '※HttpL3_1にボタンを追加する事前処理（210107小野） Call HttpL3_1_AddBtn( "", "", "", "", "", "", "", "", "", "") Response.Write(HttpL3_1("保存", "SubmitCheck()", "行挿入", "SpRowInsertSub();", "行削除", "SpRowDeleteSub();", "行↑", "SpRowShiftSub('Up');", "行↓", "SpRowShiftSub('Dn');")) End If 'Response.Write(HttpL3_2("照会", "tblbtn( 'fk_shiireuriagetyo_view.asp?RouteType=" & RouteType & "&PageType=" & PageType & "')", "", "", "", "", "", "", "", "")) Response.Write(HttpL3_2("照会", "tblbtn( 'fk_shiireuriagetyo_view.asp?RouteType=" & RouteType & "&PageType=" & PageType & "')", "印刷", "tblbtn( 'fk_shiireuriagetyo_view.asp?RouteType=" & RouteType & "&PageType=" & PageType & "&AutoPrint=1')", "", "", "", "", "", "")) Response.Write(HttpL4(Label, "")) %>
<% If GB_IEmode <> "1" Then %> <% Else 'IEモード %> <% End If %> <% = HtmlFooter %> <% End Sub %>