% ' ' %> <% main() Sub main() 'マスタの標準消費税率を取得 Dim StdTaxRate Dim StdTaxRateUnso StdTaxRate = GB_Shohizei StdTaxRateUnso = GB_Shohizei If GB_ShohizeiMode = 1 Then Query = " SELECT * FROM TDA消費税率M WHERE システムCD = '" & GB_SystemCD & "' AND 演習CD = '" & EnshuCD & "' AND (標準 = '1' OR 運送費標準 = '1') " Set Content = OpenQuery(Query) Do While Not(Content.BOF Or Content.EOF) If "" & Content.Fields("標準") = "1" Then StdTaxRate = Content.Fields("消費税率") End If If "" & Content.Fields("運送費標準") = "1" Then StdTaxRateUnso = Content.Fields("消費税率") End If Content.MoveNext Loop End If Dim TmpCnt Dim BunsyoNaiyoCD, BunsyoSyuruiCD, Syoribi, TorihikisakiCD, NonyuBasyoKubun, NonyuKijitsu Dim UntinSyogakariKubun, UnsoGaisyaCD, Unsohi, UnsohiSeikyuFlg, Tekiyo, ShiharaiHoho, HasshinFlg Dim SenpoBunsyoNaiyoCD, SenpoBunsyoSyuruiCD, SenpoSyoribi Dim GakuseiBango,UnsoCD Dim SyohinCD(5) '商品コード Dim ShijyoCD(5) Dim SyohinName(5) '商品名称 Dim Kakaku(5) '標準価格 Dim Suryo(5) '数量 Dim Tanka(5) '単価 Dim Kingaku(5) '金額 Dim GokeiKingaku '合計 Dim SyohizeiKingaku '消費税 Dim ZeikomiKingaku '税込み金額 Dim Checked_N,Checked_R Dim GakuseiShimei '学生氏名(係印) Dim SyoruiMei Dim Query Dim Content Dim Genkin, Toza Dim Shimei Dim ResendFlg Dim SakuseiKaisyaCD SakuseiKaisyaCD = Request("SakuseiKaisyaCD") ResendFlg = Request("ResendFlg") BunsyoNaiyoCD = Request("BunsyoNaiyoCD") BunsyoSyuruiCD = Request("BunsyoSyuruiCD") SenpoBunsyoNaiyoCD = Request("SenpoBunsyoNaiyoCD") SenpoBunsyoSyuruiCD = Request("SenpoBunsyoSyuruiCD") TorihikisakiCD = Request("TorihikisakiCD") UnsoCD = Request("UnsoCD") 'Response.Write("SakuseiKaisyaCD:" & SakuseiKaisyaCD) Dim SenpoFlg SenpoFlg = 0 If SenpoBunsyoNaiyoCD <> "" Then SenpoFlg = 1 End If Dim SenpoTmpBunsyoSyuruiCD Select Case BunsyoSyuruiCD Case "CC" SyoruiMei = "運送費見積書" SenpoTmpBunsyoSyuruiCD = "CC" Case "CB" SyoruiMei = "運送費見積依頼書" SenpoTmpBunsyoSyuruiCD = "CB" Case Else End Select If BunsyoNaiyoCD <> "" Or SenpoBunsyoNaiyoCD <> "" Then If SenpoFlg = 1 Then Query = "exec SPC運送書類開封 '" & GB_SystemCD & "','" & EnshuCD & "','" & KaisyaCD &"', '" & SakuseiKaisyaCD & "', '" & BunsyoSyuruiCD & "', '" & BunsyoNaiyoCD & "'" Set Content = OpenQuery(Query) Query = "exec SPC運送書類取得 '" & GB_SystemCD & "','" & EnshuCD & "','" & KaisyaCD &"', '" & SakuseiKaisyaCD & "', '" & SenpoBunsyoSyuruiCD & "', '" & SenpoBunsyoNaiyoCD & "'" Else Query = "exec SPC運送書類取得 '" & GB_SystemCD & "','" & EnshuCD & "','" & KaisyaCD & "', '" & KaisyaCD & "', '" & BunsyoSyuruiCD & "', '" & BunsyoNaiyoCD & "'" End If Set Content = OpenQuery(Query) If Not(Content.BOF Or Content.EOF) Then ' BunsyoNaiyoCD = Content.Fields("文書内容CD") If SenpoBunsyoSyuruiCD = "CB" Then SenpoSyoribi = SetTimeYYYYMMDD(Content.Fields("処理日")) UnsoCD = Content.Fields("運送先CD") HasshinFlg = Content.Fields("発行フラグ") TorihikisakiCD = Content.Fields("作成会社CD") ElseIf SenpoFlg = 1 Then TorihikisakiCD = Content.Fields("会社CD") SenpoSyoribi = SetTimeYYYYMMDD(Content.Fields("処理日")) Else SenpoBunsyoNaiyoCD = Content.Fields("先方文書内容CD") SenpoBunsyoSyuruiCD = Content.Fields("先方文書種類CD") SenpoSyoribi = SetTimeYYYYMMDD(Content.Fields("処理日")) TorihikisakiCD = Content.Fields("取引先CD") UnsoCD = Content.Fields("運送先CD") HasshinFlg = Content.Fields("発行フラグ") Syoribi = SetTimeYYYYMMDD(Content.Fields("処理日")) End If NonyuBasyoKubun = Content.Fields("納入場所区分") NonyuKijitsu = SetTimeYYYYMMDD(Content.Fields("納入期日")) UntinSyogakariKubun = Content.Fields("運賃諸掛区分") UnsoGaisyaCD = Content.Fields("運送会社CD") Unsohi = Content.Fields("運送費") UnsohiSeikyuFlg = Content.Fields("運送費請求フラグ") Tekiyo = Content.Fields("摘要") ShiharaiHoho = Content.Fields("支払方法") GakuseiBango = Content.Fields("学生番号") Do While Not(Content.BOF Or Content.EOF) Dim DenpyoSEQ DenpyoSEQ = Content.Fields("文書内容SEQ") SyohinCD(DenpyoSEQ) = Content.Fields("商品CD") ShijyoCD(DenpyoSEQ) = Content.Fields("市場CD") SyohinName(DenpyoSEQ) = ConvSyohinMeisyo(Content.Fields("商品CD")) Kakaku(DenpyoSEQ) = ConvSyohinHanbaiTanka(Content.Fields("商品CD")) Suryo(DenpyoSEQ) = Content.Fields("数量") Tanka(DenpyoSEQ) = Content.Fields("単価") Kingaku(DenpyoSEQ) = Content.Fields("単価") * Content.Fields("数量") If JukaFlg = 1 Then Kingaku(DenpyoSEQ) = Tanka(DenpyoSEQ) '重量指定では単価フィールドを金額として利用 End If GokeiKingaku = GokeiKingaku + Kingaku(DenpyoSEQ) 'SyohizeiKingaku = Int(GokeiKingaku * GB_Shohizei / 100) SyohizeiKingaku = Int(GokeiKingaku * StdTaxRateUnso / 100) ZeikomiKingaku = SyohizeiKingaku + GokeiKingaku Content.MoveNext Loop End If End If If ResendFlg = "1" Then BunsyoNaiyoCD = "" End If Dim jj,tmps '会社配列作成 Dim KaishaCDA Dim KaishaNameA Dim KaishaGyoshuA Dim KaishaShijoA ReDim KaishaCDA(0) ReDim KaishaNameA(0) ReDim KaishaShijoA(0) If BunsyoSyuruiCD = "KX" OR BunsyoSyuruiCD = "KO" OR BunsyoSyuruiCD = "KY" OR BunsyoSyuruiCD = "KV" OR BunsyoSyuruiCD = "KW" OR BunsyoSyuruiCD = "KP" 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 ((BunsyoSyuruiCD = "KX" OR BunsyoSyuruiCD = "KY") AND Content.Fields("業種CD") = "K") OR ((BunsyoSyuruiCD <> "KX" AND BunsyoSyuruiCD <> "KY") AND Content.Fields("業種CD") = "S") Or (BunsyoSyuruiCD = "CC" And (Content.Fields("業種CD") = "S" Or Content.Fields("業種CD") = "K")) Then Dim TmpuuKaisyaCD TmpuuKaisyaCD = Content.Fields("会社CD") If TmpuukaisyaCD <> KaisyaCD 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 Dim HyojunTankaHyoji Query = "exec SPM演習取得 '" & GB_SystemCD & "','" & EnshuCD & "'" Set Content = OpenQuery(Query) If Not(Content.BOF Or Content.EOF) Then HyojunTankaHyoji = "" & Content.Fields("標準販売単価表示") End If '↓商品表示幅の指定及び商品名称・商品略名称の指定(修正061031小野) Dim SyohinMeisyo, SyohinMeisyoListWidth, ShijyoListWidth SyohinMeisyo = "商品名称" SyohinMeisyoListWidth = "" If BunsyoSyuruiCD <> "KI" AND BunsyoSyuruiCD <> "KX" AND BunsyoSyuruiCD <> "KO" AND BunsyoSyuruiCD <> "KY" Then SyohinMeisyo = "商品名称" SyohinMeisyoListWidth = "width:220;" ElseIf BunsyoSyuruiCD = "KX" Then SyohinMeisyo = "商品名称" SyohinMeisyoListWidth = "width:300;" Else SyohinMeisyo = "商品名称" End If '↑商品表示幅の指定及び商品名称・商品略名称の指定(修正061031小野) %> <% = HtmlHeader("") %>
<% = HtmlFooter %> <% End Sub %>