%
'
'
%>
<%
main()
Sub main()
If Not(SessionCheck()) Then
Exit Sub
End If
Dim RouteType
RouteType = Request("RouteType")
Dim BunsyoSyuruiCD
BunsyoSyuruiCD = Request("BunsyoSyuruiCD")
UketorininCD = Request("UketorininCD")
Dim Title
Title = ConvKubunMeisyo("手形種類区分", BunsyoSyuruiCD)
Dim Query, Content
Dim TmpKaisyaCD
Dim Tenmatsubi, TenmatsuKubun, HiuragakininCD
Dim HikiukeninCD, FuridashininCD, UketorininCD
Dim ShiharaiBasyo
Dim BunsyoNaiyoCD, ShiharaiKijitsu, ShiharaiKijitsuY, ShiharaiKijitsuM, ShiharaiKijitsuD, Furidashibi, FuridashibiY, FuridashibiM, FuridashibiD
Dim Furidashibi2,ShiharaiKijitsu2
Dim Kingaku
Dim Tekiyo , SakuseiKaisyaCD , SenpoFlg
Dim TegataNo
Dim SaisyuHizuke
Dim tk
BunsyoNaiyoCD = Request("BunsyoNaiyoCD")
SakuseiKaisyaCD = Request("SakuseiKaisyaCD")
If SakuseiKaisyaCD = "" Then
SenpoFlg = "0"
Else
SenpoFlg = "1"
End If
'会計開始日の元号
Dim KaikeiKaishibiG
Dim KaikeiKaishibiGYear
KaikeiKaishibiG = SetGengo(GB_KaikeiKaishibi)
KaikeiKaishibiGYear = Year(GB_KaikeiKaishibi)
'Response.Write(KaikeiKaishibiGYear)
'Exit Sub
'元号
Dim FuridashibiG
Dim ShiharaiKijitsuG
Dim JissenbiG
Dim TmpGengo '初期値が存在しない場合はKaikeiKaishibiGを初期値にするため
If BunsyoNaiyoCD <> "" Then
If SenpoFlg = "0" Then
Query = "exec SPK手形取得 '" & GB_SystemCD & "'"
Query = Query & ",'" & EnshuCD & "'" '演習CD
Query = Query & ",'" & KaisyaCD & "'" '会社CD
Query = Query & ",'" & KaisyaCD & "'" '作成会社CD
Query = Query & ",'" & BunsyoSyuruiCD & "'"
Query = Query & ",'" & BunsyoNaiyoCD & "'"
Else
Query = "exec SPK手形取得 '" & GB_SystemCD & "'"
Query = Query & ",'" & EnshuCD & "'" '演習CD
Query = Query & ",'" & KaisyaCD & "'" '会社CD
Query = Query & ",'" & SakuseiKaisyaCD & "'" '作成会社CD
Query = Query & ",'" & BunsyoSyuruiCD & "'"
Query = Query & ",'" & BunsyoNaiyoCD & "'"
End If
Set Content = OpenQuery(Query)
If Not(Content.BOF Or Content.EOF) Then
TegataNo = Content.Fields("手形番号")
HikiukeninCD = Content.Fields("引受人CD")
FuridashininCD = Content.Fields("振出人CD")
UketorininCD = Content.Fields("受取人CD")
ShiharaiBasyo = Content.Fields("支払場所CD")
BunsyoNaiyoCD = Content.Fields("文書内容CD")
ShiharaiKijitsu = Content.Fields("支払期日")
Furidashibi = Content.Fields("取引日")
Tekiyo = Content.Fields("摘要")
Kingaku = Content.Fields("金額")
Tenmatsubi = Content.Fields("顛末日")
TenmatsuKubun = Content.Fields("顛末区分")
HiuragakininCD = Content.Fields("被裏書人CD")
End If
End If
Dim Jissenbi
Jissenbi = ""
Dim JissenbiGY
'実践日取得
Query = "exec SPM演習取得 '" & GB_SystemCD & "','" & EnshuCD & "'"
Set Content = OpenQuery(Query)
If Not(Content.BOF Or Content.EOF) Then
Jissenbi = "" & SetTimeYYYYMMDD(Content.Fields("実践日"))
JissenbiG = "" & SetGengo(Content.Fields("実践日"))
Query = " SELECT * FROM TC9元号M WHERE システムCD = '" & GB_SystemCD & "' ORDER BY 開始日 DESC "
Set Content = OpenQuery(Query)
Do While Not(Content.BOF Or Content.EOF)
If "" & Content.Fields("元号") = JissenbiG Then
JissenbiGY = Year(Content.Fields("開始日")) '元号フォームの選択値は開始年
Exit Do
End If
Content.MoveNext
Loop
End If
If Furidashibi = "" Then
Furidashibi = Jissenbi
End If
SaisyuHizuke = Furidashibi
'和暦に変換してしまうので、西暦を別変数に代入しておく
Furidashibi2 = Furidashibi
ShiharaiKijitsu2 = ShiharaiKijitsu
If TenmatsuKubun = "" Or IsNull(TenmatsuKubun) Then
TenmatsuKubun = Request("TenmatsuKubun")
End If
'DEBUG
'Response.Write("デバッグ中だす(^^)/
")
'Response.Write("EnshuCD:"&EnshuCD&"
")
'Response.Write("KaisyaCD:"&KaisyaCD&"
")
'Response.Write("SakuseiKaisyaCD:"&SakuseiKaisyaCD&"
")
'Response.Write("BunsyoSyuruiCD:"&BunsyoSyuruiCD&"
")
'Response.Write("BunsyoNaiyoCD:"&BunsyoNaiyoCD&"
")
'Response.Write("AutoFlg:"&AutoFlg&"
")
'Response.Write("PrintFlg:"&PrintFlg&"
")
'Response.Write("RouteType:"&RouteType&"
")
'Response.Write("TegataNo:"&TegataNo&"
")
'Response.Write("SojyushinKubun:"&SojyushinKubun&"
")
'Response.Write("Furidashibi:"&Furidashibi&"
")
'Response.Write("ShiharaiKijitsu:"&ShiharaiKijitsu&"
")
'Response.Write("Tenmatsubi:"&Tenmatsubi&"
")
'Response.Write("TenmatsuKubun:"&TenmatsuKubun&"
")
'TT 取立 TW 割引 TU 裏書 TG 小切手 TY 約束手形 TK 為替手形
Select Case TenmatsuKubun
Case "TT"
tk = "手形取立入金"
Case "TW"
tk = "割引"
Case "TU"
tk = "裏書譲渡"
Case Else
tk = "発行"
End Select
If Furidashibi <> "" Then
FuridashibiG = SetGengo(Furidashibi)
FuridashibiY = Year(Furidashibi) - SetYearGengo(FuridashibiG) + 1
FuridashibiM = Month(Furidashibi)
FuridashibiD = Day(Furidashibi)
End If
If ShiharaiKijitsu <> "" Then
ShiharaiKijitsuG = SetGengo(ShiharaiKijitsu)
ShiharaiKijitsuY = Year(ShiharaiKijitsu) - SetYearGengo(ShiharaiKijitsuG) + 1
ShiharaiKijitsuM = Month(ShiharaiKijitsu)
ShiharaiKijitsuD = Day(ShiharaiKijitsu)
End If
Dim UketorininRyaku, Uketorinin, HikiukeninRyaku, Hikiukenin
If HikiukeninCD = "etc" Then
HikiukeninRyaku = "その他"
Hikiukenin = "その他"
Else
HikiukeninRyaku = ConvKaisyaRyakuMeisyo(HikiukeninCD)
Hikiukenin = ConvKaisyaMeisyoDx(EnshuCD, HikiukeninCD)
End If
If UketorininCD = "etc" Then
UketorininRyaku = "その他"
Uketorinin = "その他"
Else
UketorininRyaku = ConvKaisyaRyakuMeisyo(UketorininCD)
Uketorinin = ConvKaisyaMeisyoDx(EnshuCD, UketorininCD)
End If
Dim JidoBangoTegata
JidoBangoTegata = GetEnshuParam(EnshuCD, "自動番号手形")
Query = "exec SPK手形取得裏書"
Query = Query & " '" & GB_SystemCD & "', '" & EnshuCD & "'" '演習CD
Query = Query & ",'" & KaisyaCD & "'" '会社CD
Query = Query & ",'" & SakuseiKaisyaCD & "'" '会社CD
Query = Query & ",'" & BunsyoSyuruiCD & "'"
Query = Query & ",'" & BunsyoNaiyoCD & "'"
Set Content = OpenQuery(Query)
Do While Not(Content.BOF Or Content.EOF)
SaisyuHizuke = Content.Fields("取引日")
Content.MoveNext
Loop
Dim TouzaFlg, KozaKubun
Query = "exec SPB銀行口座一覧 '" & GB_SystemCD & "','" & EnshuCD & "', '" & KaisyaCD & "', '', ''"
Set Content = OpenQuery(Query)
Do While Not(Content.BOF Or Content.EOF)
KozaKubun= Content.Fields("口座区分")
If KozaKubun = "T" Then
TouzaFlg = "1"
End If
Content.MoveNext
Loop
'会社配列作成
Dim KaishaCDA
Dim KaishaNameA
Dim KaishaShijoA
ReDim KaishaCDA(0)
ReDim KaishaNameA(0)
ReDim KaishaShijoA(0)
Query = "exec SPM会社全部一覧 '" & GB_SystemCD & "','" & EnshuCD & "', '" & GakuseiNo & "'"
Set Content = OpenQuery(Query)
Do While Not(Content.BOF Or Content.EOF)
TmpKaisyaCD = Content.Fields("会社CD")
If TmpkaisyaCD <> KaisyaCD Then
'If Content.Fields("業種CD") <> "B" Then
ReDim PreServe KaishaCDA(UBound(KaishaCDA) + 1) '配列数+1
ReDim PreServe KaishaNameA(UBound(KaishaCDA))
ReDim PreServe KaishaShijoA(UBound(KaishaCDA))
KaishaCDA(UBound(KaishaCDA)) = "" & Content.Fields("会社CD")
KaishaNameA(UBound(KaishaCDA)) = "" & Content.Fields("会社名称")
KaishaShijoA(UBound(KaishaCDA)) = "" & Content.Fields("市場CD")
'End If
End If
Content.MoveNext
Loop
ReDim PreServe KaishaCDA(UBound(KaishaCDA) + 1) '配列数+1
ReDim PreServe KaishaNameA(UBound(KaishaCDA))
ReDim PreServe KaishaShijoA(UBound(KaishaCDA))
KaishaCDA(UBound(KaishaCDA)) = "etc"
KaishaNameA(UBound(KaishaCDA)) = "その他"
KaishaShijoA(UBound(KaishaCDA)) = ""
Dim ii
'顛末変更時の顛末入れ替え処理(110823小野)
If Request("TenmatsuShusei") = "1" Then
If Request("NewTenmatsu") <> "" Then
TenmatsuKubun = Request("NewTenmatsu")
End If
End If
'被裏書人の存在チェック
Dim HiuragakininExist
HiuragakininExist = 0
If SenpoFlg = "1" Then
Query = "exec SPM会社手形裏書譲渡可能一覧 '" & GB_SystemCD & "'"
Query = Query & ",'" & EnshuCD & "'" '演習CD
Query = Query & ",'" & KaisyaCD & "'" '会社CD
Query = Query & ",'" & SakuseiKaisyaCD & "'" '作成会社CD
Query = Query & ",'" & BunsyoSyuruiCD & "'"
Query = Query & ",'" & BunsyoNaiyoCD & "'"
Query = Query & ", '" & GakuseiNo & "'"
Set Content = OpenQuery(Query)
Do While Not(Content.BOF Or Content.EOF)
If (TenmatsuKubun <> "TU" And Content.Fields("業種CD") = "B") Or (TenmatsuKubun = "TU" And Content.Fields("業種CD") <> "B") Then
If Content.Fields("会社CD") <> KaisyaCD Then
HiuragakininExist = 1
Exit Do
End If
End If
Content.MoveNext
Loop
End If
Dim JitsuinRiyo
Dim SouhuzumiTegataHyoji
Query = "exec SPM演習取得 '" & GB_SystemCD & "','" & EnshuCD & "'"
Set Content = OpenQuery(Query)
If Not(Content.BOF Or Content.EOF) Then
SouhuzumiTegataHyoji = "" & Content.Fields("送付済み手形表示様式")
JitsuinRiyo = "" & Content.Fields("実印利用")
End If
Dim BackColor
Dim BackColor2
Dim BackColor3
BackColor = "FFF8DB"
BackColor2 = "FFFFF1"
BackColor3 = "FFF0C0"
If BunsyoSyuruiCD = "TG" Then
BackColor = "FBFFE0"
BackColor2 = "FCFFFC"
BackColor3 = "F7FFC8"
End If
%>
<% = HtmlHeader("") %>