%
'
%>
<%
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
%>
<% = Spacer(1,10) %> |
|
|
|
<% = Spacer(1,10) %> |
|
|
|
|
|
|
|
<% If KyuyoDaichoHyoji = "1" Then %>
<% End If %>
|
<% If KogitteHyoji = "1" Then %>
<% End If %>
|
<% If YTegataHyoji = "1" Then %>
<% End If %>
|
<% If KTegataHyoji = "1" Then %>
<% End If %>
|
<% If RyosyusyoHyoji = "1" Then %>
<% End If %>
|
<% 'AutoUketoriTegataIchiran = "0" %>
<% If AutoUketoriTegataIchiran = "1" Then %>
<% End If %>
|
<% If AutoShiaraiTegataIchiran = "1" Then %>
<% End If %>
|
|
|
|
|
|
|
|
|
|
|
|
|
_view<% End If %>.asp')" BACKGROUND="/<% = HomeAlias %>/images/mnbtn03_rssc.gif?<% = GB_STU %>">
| 勘定残高設定 |
|
|
_view<% End If %>.asp')" BACKGROUND="/<% = HomeAlias %>/images/mnbtn03_rssc.gif?<% = GB_STU %>">
| 繰越残高設定 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
<% If GetEnshuParam(EnshuCD, "整理記入精算表利用") = "1" Then %>
<% Else %>
<% If GetEnshuParam(EnshuCD, "整理記入精算表利用") = "1" Then %>
|
|
|
|
|
|
|
|
|
|
<% If KinkoHyoji = "1" Then %>
|
【 金庫 】 |
残高:<%
Query = "exec SPK現金入出金残高 '" & GB_SystemCD & "','" & EnshuCD & "', '" & KaisyaCD & "', '" & GB_KaikeiSyuryobi & "'"
Set Content = OpenQuery(Query)
Dim GenkinNyuSyukinZandaka
GenkinNyuSyukinZandaka = 0
If Not(Content.EOF Or Content.BOF) Then
GenkinNyuSyukinZandaka = Content.Fields("残高")
End If
Response.Write(ConvIntToMoney(GenkinNyuSyukinZandaka, false, false) & " ")
%> |
|
|
|
|
|
<% 'AutoGenkinNyuSyukinRireki = "0" %>
<% If AutoGenkinNyuSyukinRireki = "1" Then %>
<% If bGenkinMinusCheck = 1 Then %>
入出金 履歴
<% Else %>
入出金 履歴
<% End If %>
|
<% End If %>
|
|
|
|
|
|
|
|
|
<% End If %>
|
【 銀行オンライン窓口 】 |
<%
'利用可能な銀行が存在するか判定&銀行数をカウント
GinkoNothing = 1
If GinkoShijokanRiyo <> "1" Then
'同一市場限定の場合
Query = "exec SPM会社市場一覧 '" & GB_SystemCD & "', '" & EnshuCD & "', '" & GakuseiNo & "', '" & GB_ShijyoCD & "'"
Else
Query = "exec SPM会社全部一覧 '" & GB_SystemCD & "', '" & EnshuCD & "', '" & GakuseiNo & "'"
End If
Set Content = OpenQuery(Query)
Do While Not(Content.BOF Or Content.EOF)
If Content.Fields("業種CD") = "B" Then
GinkoNothing = 0
GinkoCnt = GinkoCnt + 1
End If
Content.MoveNext
Loop
Dim TmpGinkoCD
TmpGinkoCD = ""
Query = "exec SPB銀行口座一覧 '" & GB_SystemCD & "','" & EnshuCD & "', '" & KaisyaCD & "', '', ''"
Set Content = OpenQuery(Query)
Do While Not(Content.EOF Or Content.BOF)
'口座を持っている銀行数をカウント
If TmpGinkoCD <> Content.Fields("銀行CD") Then
TmpGinkoCD = Content.Fields("銀行CD")
ActGinkoCnt = ActGinkoCnt + 1
End If
GinkoZandaka = GinkoZandaka + Content.Fields("残高")
Content.MoveNext
Loop
'口座を持っている銀行が1つ且つ既選択銀行CDが無ければ代入
If GinkoCD = "" And ActGinkoCnt = 1 Then
GinkoCD = TmpGinkoCD
End If
%>
|
|
|
|
<%
Dim Takasa
If GinkoMadoguchiHyoji = "1" Then
Takasa = 205
Else
Takasa = 80
End If
%>
<% If GinkoNothing = 0 Then %>
銀行選択: |
|
総預金残高:<% = ConvIntToMoney(GinkoZandaka, false, false) %> |
|
<% If GinkoMadoguchiHyoji = "1" Then %>
|
|
|
|
<% If KogitteHyoji = "1" Then %>
|
<% End If %>
<% If MajorVersion >= 5 Then %>
|
<% End If %>
<% End If %>
<% If GinkoMadoguchiHyoji = "1" And (YTegataHyoji = "1" Or KTegataHyoji = "1") Then %>
|
|
<% Else %>
|
<% End If %>
<% If bGinkoMinusCheck = 1 Then %>
預金通帳
<% Else %>
預金通帳
<% End If %>
|
|
<% If GinkoMadoguchiHyoji = "1" And (YTegataHyoji = "1" Or KTegataHyoji = "1") Then %>
<% Else %>
|
<% End If %>
<% Else %>
同一市場に銀行が存在しません |
<% End If %>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
<% = HtmlFooter %>
<%
End Sub
%> | |