<% ' %> <% main() Sub main() If Not(SessionCheck()) Then Exit Sub End If Dim GinkoCD GinkoCD = Request("GinkoCD") Dim InputHojyobo Dim AutoGenkinNyuSyukinRireki, AutoYokinNyuSyukinRireki, AutoNyukoJisseki, AutoSyukoJisseki Dim AutoSyohinZaiko, AutoUketoriTegataIchiran, AutoShiaraiTegataIchiran Dim GinkoJidou, GinkoMadoguchiHyoji, KinkoHyoji Dim KogitteHyoji, YTegataHyoji, KTegataHyoji, RyosyusyoHyoji, KyuyoDaichoHyoji Dim GinkoShijokanRiyo Dim KishusetteiRiyo Dim KishusetteiRiyoKanjo Dim KishusetteiRiyoKurikoshi Query = "exec SPM演習取得 '" & GB_SystemCD & "','" & EnshuCD & "'" Set Content = OpenQuery(Query) If Not(Content.BOF Or Content.EOF) Then InputHojyobo = Content.Fields("手動補助簿表示") Dim YobiA YobiA = Content.Fields("履歴表示") AutoGenkinNyuSyukinRireki = Mid(YobiA, 1, 1) AutoYokinNyuSyukinRireki = Mid(YobiA, 2, 1) AutoNyukoJisseki = Mid(YobiA, 3, 1) AutoSyukoJisseki = Mid(YobiA, 4, 1) AutoSyohinZaiko = Mid(YobiA, 5, 1) AutoUketoriTegataIchiran = Mid(YobiA, 6, 1) AutoShiaraiTegataIchiran = Mid(YobiA, 7, 1) GinkoJidou = "" & Content.Fields("銀行自動処理") GinkoMadoguchiHyoji = "" & Content.Fields("銀行窓口表示") GinkoShijokanRiyo = "" & Content.Fields("銀行市場間利用") KinkoHyoji = "" & Content.Fields("金庫表示") KogitteHyoji = "" & Content.Fields("小切手表示") YTegataHyoji = "" & Content.Fields("約束手形表示") KTegataHyoji = "" & Content.Fields("為替手形表示") RyosyusyoHyoji = "" & Content.Fields("領収書表示") KyuyoDaichoHyoji = "" & Content.Fields("給与台帳表示") KishusetteiRiyo = "" & Content.Fields("期首設定経理部利用") End If If "" & KishusetteiRiyo = "" Then KishusetteiRiyo = "3" End If KishusetteiRiyoKanjo = "1" KishusetteiRiyoKurikoshi = "1" If KishusetteiRiyo = "2" Or KishusetteiRiyo = "0" Then '勘定残高のみ KishusetteiRiyoKurikoshi = "0" End If If KishusetteiRiyo = "1" Or KishusetteiRiyo = "0" Then '繰越残高のみ KishusetteiRiyoKanjo = "0" End If '銀行自動の場合は銀行窓口を強制表示(窓口を利用しなければ必然的に自動はOFFになるので廃止) ' If GinkoJidou = "1" Then ' GinkoMadoguchiHyoji = "1" ' End If Dim GinkoZandaka GinkoZandaka = 0 Dim ActGinkoCnt ActGinkoCnt = 0 Dim GinkoNothing GinkoNothing = 0 Dim GinkoCnt GinkoCnt = 0 Dim bGenkinMinusCheck, bGinkoMinusCheck bGenkinMinusCheck = 0 bGinkoMinusCheck = 0 Dim Nyukin , Syukin , Zandaka Zandaka = 0 Query = "exec SPK現金入出金履歴一覧 '" & GB_SystemCD & "','" & EnshuCD & "', '" & KaisyaCD & "'" Set Content = OpenQuery(Query) Do While Not(Content.BOF Or Content.EOF) If Content.Fields("現金取引区分") = "GN" Then Nyukin = Content.Fields("金額") Syukin = 0 ElseIf Content.Fields("現金取引区分") = "GS" Then Nyukin = 0 Syukin = Content.Fields("金額") Else Nyukin = Content.Fields("金額") Syukin = Content.Fields("金額") End If Zandaka = Zandaka + Nyukin - Syukin If Zandaka < 0 Then bGenkinMinusCheck = 1 End If Content.MoveNext Loop Dim Query1, Content1 Query = "exec SPB銀行口座一覧 '" & GB_SystemCD & "','" & EnshuCD & "', '" & KaisyaCD & "', '', ''" Set Content = OpenQuery(Query) Do While Not(Content.BOF Or Content.EOF) Query1 = "exec SPB銀行口座入出金一覧 '" & GB_SystemCD & "','" & EnshuCD & "', '', '" & Content.Fields("銀行CD") & "', '" & Content.Fields("口座区分") & "', '" & Content.Fields("口座番号") & "'" Set Content1 = OpenQuery(Query1) Zandaka = 0 Do While Not(Content1.BOF Or Content1.EOF) Dim tmpKingaku tmpKingaku = Content1.Fields("金額") If IsNull(tmpKingaku) Then tmpKingaku = 0 End If If tmpKingaku = "" Then tmpKingaku = 0 End If If Right(Content1.Fields("銀行取引区分"), 1) = "N" Then Zandaka = Zandaka + tmpKingaku Else Zandaka = Zandaka - tmpKingaku End If If Zandaka < 0 Then bGinkoMinusCheck = 1 End If Content1.MoveNext Loop Content.MoveNext Loop %> <% = HtmlHeader("") %> <% Response.Write(HtmlDesign(1)) Response.Write(HttpL1(3)) Response.Write(HttpL2("会社選択" ,"tblbtn( '/" & HomeAlias & "/user/bk/')", GB_GyosyuMeisyo, "tblbtn( '/" & HomeAlias & "/user/bk/menu_" & GB_Gyosyu & ".asp')", "経理部", "", "", "", "", "", "", "")) Response.Write(HttpL3("", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "")) Response.Write(HttpL3_1("", "", "", "", "", "", "", "", "", "")) Response.Write(HttpL3_2("", "", "", "", "", "", "", "", "", "")) Response.Write(HttpL4("経理部", "")) If bGenkinMinusCheck = 1 Then Response.Write(HttpL5("現金がマイナスになっている時点があります")) ElseIf bGinkoMinusCheck = 1 Then Response.Write(HttpL5("預金がマイナスになっている時点があります")) End If %> <% = HtmlFooter %> <% End Sub %>