<% ' ' %> <% main() Sub main() If Not(SessionCheck()) Then Exit Sub End If Dim HikiukeninCD, FuridashininCD, UketorininCD Dim ShiharaiBasyo Dim BunsyoNaiyoCD, OldBunsyoNaiyoCD, ShiharaiKijitsu, Furidashibi Dim FuridashibiY, FuridashibiM, FuridashibiD Dim Kingaku Dim Tekiyo Dim Query, Content '############################################### 1.データの引継ぎ HikiukeninCD = Request("HikiukeninCD") FuridashininCD = Request("FuridashininCD") UketorininCD = Request("UketorininCD") ShiharaiBasyo = Request("ShiharaiBasyo") BunsyoNaiyoCD = Request("BunsyoNaiyoCD") OldBunsyoNaiyoCD = Request("OldBunsyoNaiyoCD") ShiharaiKijitsu = Request("ShiharaiKijitsu") Furidashibi = Request("Furidashibi") FuridashibiY = Request("FuridashibiY") FuridashibiM = Request("FuridashibiM") FuridashibiD = Request("FuridashibiD") Tekiyo = Request("Tekiyo") Kingaku = ConvMoneyToInt(Request("Kingaku")) Dim BunsyoSyuruiCD BunsyoSyuruiCD = Request("BunsyoSyuruiCD") BunsyoSyuruiCD = "RA" Dim ryosyusyoSyuruiKubun ryosyusyoSyuruiKubun = BunsyoSyuruiCD Dim BinType BinType = Request("BinType") Dim Tenmatsubi, TenmatsuKubun, HiuragakininCD Tenmatsubi = Request("Tenmatsubi") TenmatsuKubun = Request("TenmatsuKubun") HiuragakininCD = Request("HiuragakininCD") Dim SakuseiKaisyaCD SakuseiKaisyaCD = Request("SakuseiKaisyaCD") If SakuseiKaisyaCD = "" Then SakuseiKaisyaCD = KaisyaCD End If If BinType = "Tenmatsu" Then Query = "exec SPK領収書発信" Query = Query & " '" & GB_SystemCD & "','" & EnshuCD & "'" '演習CD Query = Query & ",'" & KaisyaCD & "'" '会社CD Query = Query & ",'" & SakuseiKaisyaCD & "'" '作成会社CD Query = Query & ",'" & ryosyusyoSyuruiKubun & "'" '文書種類CD Query = Query & ",'" & BunsyoNaiyoCD & "'" If HiuragakininCD = "" Then Query = Query & ",null" Else Query = Query & ",'" & HiuragakininCD & "'" End If If TenmatsuKubun <> "TU" Then Query = Query & ",'0'" Else Query = Query & ",'1'" End If Query = Query & ",'" & Tenmatsubi & "'" Query = Query & ",'" & TenmatsuKubun & "'" DebugQuery(Query) Set Content = OpenQuery(Query) Response.Redirect("fk_ryosyusyo_view.asp?SakuseiKaisyaCD=" & SakuseiKaisyaCD & "&BunsyoSyuruiCD=" & BunsyoSyuruiCD & "&BunsyoNaiyoCD=" & BunsyoNaiyoCD) ElseIf BinType = "Hasshin" Then Query = "exec SPK領収書発信" Query = Query & " '" & GB_SystemCD & "','" & EnshuCD & "'" '演習CD Query = Query & ",'" & KaisyaCD & "'" '会社CD Query = Query & ",'" & SakuseiKaisyaCD & "'" '作成会社CD Query = Query & ",'" & ryosyusyoSyuruiKubun & "'" '文書種類CD Query = Query & ",'" & BunsyoNaiyoCD & "'" Query = Query & ",'" & UketorininCD & "'" Query = Query & ",1" Query = Query & ",NULL" Query = Query & ",''" DebugQuery(Query) Set Content = OpenQuery(Query) ' Response.Redirect("fk_ryosyusyo_view.asp?SakuseiKaisyaCD=" & SakuseiKaisyaCD & "&BunsyoSyuruiCD=" & BunsyoSyuruiCD & "&BunsyoNaiyoCD=" & BunsyoNaiyoCD) Call WaitRedirect("fk_ryosyusyo_view.asp?SakuseiKaisyaCD=" & SakuseiKaisyaCD & "&BunsyoSyuruiCD=" & BunsyoSyuruiCD & "&BunsyoNaiyoCD=" & BunsyoNaiyoCD, 200) Exit Sub ElseIf BinType = "Sakujyo" Then Query = "exec SPK領収書削除" Query = Query & " '" & GB_SystemCD & "','" & EnshuCD & "'" '演習CD Query = Query & ",'" & KaisyaCD & "'" '会社CD Query = Query & ",'" & SakuseiKaisyaCD & "'" '文書種類CD Query = Query & ",'" & ryosyusyoSyuruiKubun & "'" '文書種類CD Query = Query & ",'" & BunsyoNaiyoCD & "'" DebugQuery(Query) Set Content = OpenQuery(Query) Response.Redirect("fk_ryosyusyo_ichiran.asp?SakuseiKaisyaCD=" & KaisyaCD & "&BunsyoSyuruiCD=" & BunsyoSyuruiCD & "&ShowDel=1") Else If BunsyoNaiyoCD <> OldBunsyoNaiyoCD Then Query = "exec SPK領収書取得" Query = Query & " '" & GB_SystemCD & "','" & EnshuCD & "'" '演習CD Query = Query & ",'" & KaisyaCD & "'" '会社CD Query = Query & ",'" & KaisyaCD & "'" '会社CD Query = Query & ",'" & ryosyusyoSyuruiKubun & "'" '文書種類CD Query = Query & ",'" & BunsyoNaiyoCD & "'" DebugQuery(Query) Set Content = OpenQuery(Query) If Not(Content.BOF Or Content.EOF ) Then Dim Title Title = "領収書" Response.Write("この" & Title & "No.は既に存在します
") %> 戻る <% Exit Sub End If End If If BinType = "Syusei" Then Query = "exec SPK領収書更新" Else Query = "exec SPK領収書挿入" End If Query = Query & " '" & GB_SystemCD & "','" & EnshuCD & "'" '演習CD Query = Query & ",'" & KaisyaCD & "'" '会社CD Query = Query & ",'" & KaisyaCD & "'" '作成会社CD Query = Query & ",'" & ryosyusyoSyuruiKubun & "'" '文書種類CD Query = Query & ",'" & BunsyoNaiyoCD & "'" ' If BinType = "Syusei" Then ' Query = Query & ",'" & OldBunsyoNaiyoCD & "'" ' End If Query = Query & ",'S'" Query = Query & ",'" & FuridashininCD & "'" Query = Query & ",'" & UketorininCD & "'" Query = Query & ",'" & Furidashibi & "'" Query = Query & "," & Kingaku Query = Query & ",'" & Tekiyo & "'" Query = Query & ",'" & GakuseiNo & "'" End If DebugQuery(Query) Set Content = OpenQuery(Query) While Not Content Is Nothing If Content.Fields.Count > 0 Then BunsyoNaiyoCD = Content.Fields(0) End If Set Content = Content.NextRecordset Wend Response.Redirect("fk_ryosyusyo_view.asp?BunsyoNaiyoCD=" & BunsyoNaiyoCD & "&BunsyoSyuruiCD=" & BunsyoSyuruiCD) End Sub %>