<% ' ' %> <% 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("") %>
<% If SenpoFlg = "1" Then %> <% Else %> <% If BunsyoNaiyoCD <> "" Then %> <% End If %> <% End If %> <% 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 & "')", Title, "", "", "", "", "","", "", "", "")) 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')", Title & "管理", "", "", "", "", "")) 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')", Title & "管理", "", "", "", "", "")) End If Response.Write(HttpL3("", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "")) If SenpoFlg = "1" Then Response.Write(HttpL3_1("保存", "SubmitCheck()", "戻る", "tblbtn('fk_tegata_view.asp?SenpoFlg=1&SakuseiKaisyaCD=" & SakuseiKaisyaCD & "&BunsyoSyuruiCD=" & BunsyoSyuruiCD & "&BunsyoNaiyoCD=" & BunsyoNaiyoCD & "')", "", "", "", "", "", "")) Else Response.Write(HttpL3_1("保存", "SubmitCheck()", "", "", "", "", "", "", "", "")) End If If BunsyoSyuruiCD = "TK" Then Response.Write(HttpL3_2("作成一覧", "tblbtn( 'fk_tegata_ichiran.asp?SakuseiKaisyaCD=" & KaisyaCD & "&BunsyoSyuruiCD=" & BunsyoSyuruiCD & "&TegataJyotaiKubun=TF&HakkoFlg=0')", "振出一覧", "tblbtn( 'fk_tegata_ichiran.asp?SakuseiKaisyaCD=" & KaisyaCD & "&BunsyoSyuruiCD=" & BunsyoSyuruiCD & "&TegataJyotaiKubun=TF')", "受取一覧", "tblbtn( 'fk_tegata_ichiran.asp?BunsyoSyuruiCD=" & BunsyoSyuruiCD & "&TegataJyotaiKubun=TU')", "引受一覧", "tblbtn( 'fk_tegata_ichiran.asp?BunsyoSyuruiCD=" & BunsyoSyuruiCD & "&TegataJyotaiKubun=TH')", "", "")) Else Response.Write(HttpL3_2("作成一覧", "tblbtn( 'fk_tegata_ichiran.asp?SakuseiKaisyaCD=" & KaisyaCD & "&BunsyoSyuruiCD=" & BunsyoSyuruiCD & "&TegataJyotaiKubun=TF&HakkoFlg=0')", "振出一覧", "tblbtn( 'fk_tegata_ichiran.asp?SakuseiKaisyaCD=" & KaisyaCD & "&BunsyoSyuruiCD=" & BunsyoSyuruiCD & "&TegataJyotaiKubun=TF')", "受取一覧", "tblbtn( 'fk_tegata_ichiran.asp?BunsyoSyuruiCD=" & BunsyoSyuruiCD & "&TegataJyotaiKubun=TU')", "", "", "", "")) End If If SenpoFlg = "1" Then Response.Write(HttpL4(Title & "管理", "顛末")) Else Response.Write(HttpL4(Title & "管理", "")) End If %>
<% = HtmlFooter %> <% End Sub %>