%
'
'
%>
<%
main()
Sub main()
Dim BunsyoNaiyoCD, BunsyoSyuruiCD, Syoribi, SakuseiKaisyaCD, NonyuBasyoKubun, NonyuKijitsu
Dim UntinSyogakariKubun, UnsoGaisyaCD, Unsohi, UnsohiSeikyuFlg, Tekiyo, ShiharaiHoho, HasshinFlg
Dim SenpoBunsyoNaiyoCD, SenpoBunsyoSyuruiCD, SenpoSyoribi
Dim DbTorihikisakiCD, DbSenpoBunsyoNaiyoCD
Dim SenpoTmpBunsyoSyuruiCD
Dim UnsoCD
Dim ii
Dim SyohinCD(5) '商品コード
Dim SyohinName(5) '商品名称
Dim Kakaku(5) '標準価格
Dim Suryo(5) '数量
Dim Tanka(5) '単価
Dim Kingaku(5) '金額
Dim NonyuBasyoMeisyo, UntinSyogakariMeisyo
Dim GokeiKingaku '合計
Dim SyohizeiKingaku '消費税
Dim ZeikomiKingaku '税込み金額
Dim Checked_N,Checked_R
Dim GakuseiShimei '学生氏名(係印)
Dim GakuseiBango
Dim NextBunsyoNaiyoCD, PrevBunsyoNaiyoCD
Dim SyoruiMei
Dim Query
Dim Content
Dim Genkin, Toza
Dim Shimei
Dim RouteType
Dim SakujyoFlg
Dim PageType
PageType = Request("PageType")
RouteType = Request("RouteType")
SenpoBunsyoNaiyoCD = Request("SenpoBunsyoNaiyoCD")
BunsyoNaiyoCD = Request("BunsyoNaiyoCD")
BunsyoSyuruiCD = Request("BunsyoSyuruiCD")
SenpoBunsyoSyuruiCD = Request("SenpoBunsyoSyuruiCD")
SakuseiKaisyaCD = Request("SakuseiKaisyaCD")
UnsoCD = Request("UnsoCD")
Dim SenpoFlg
SenpoFlg = Request("SenpoFlg")
If SenpoFlg = "" Then
SenpoFlg = "0"
End If
If SakuseiKaisyaCD = "" Then
SakuseiKaisyaCD = KaisyaCD
End If
If SakuseiKaisyaCD <> KaisyaCD Then
SenpoFlg = "1"
End If
Dim Kubun, SenpoSyoruiMei, Title
Select Case BunsyoSyuruiCD
Case "CC"
SyoruiMei = "運送費見積書"
Title = SyoruiMei
SenpoTmpBunsyoSyuruiCD = "CC"
Case "CB"
SyoruiMei = "運送費見積依頼書"
Title = SyoruiMei
SenpoTmpBunsyoSyuruiCD = "CB"
Case Else
End Select
Select Case SenpoBunsyoSyuruiCD
Case "CC"
SenpoSyoruiMei = "先方見積書"
Case "CB"
SenpoSyoruiMei = "先方見積依頼書"
Case Else
End Select
If SyoruiMei = "" Then
SyoruiMei = SenpoSyoruiMei
End If
If BunsyoNaiyoCD <> "" Then
If KaisyaCD <> SakuseiKaisyaCD And GB_JisyaFlag <> "" Then '運用管理・演習管理(自社フラグ無し)では開封フラグを立てない(061213小野)
Query = "exec SPC運送書類開封 '" & GB_SystemCD & "','" & EnshuCD & "','" & KaisyaCD & "', '" & SakuseiKaisyaCD & "', '" & BunsyoSyuruiCD & "', '" & BunsyoNaiyoCD & "'"
Set Content = OpenQuery(Query)
End If
Query = "exec SPC運送書類取得 '" & GB_SystemCD & "','" & EnshuCD & "','" & KaisyaCD & "', '" & SakuseiKaisyaCD & "', '" & BunsyoSyuruiCD & "', '" & BunsyoNaiyoCD & "'"
Set Content = OpenQuery(Query)
If Not(Content.BOF Or Content.EOF) Then
BunsyoNaiyoCD = Content.Fields("文書内容CD")
DbTorihikisakiCD = Content.Fields("取引先CD")
UnsoCD = Content.Fields("運送先CD")
HasshinFlg = Content.Fields("発行フラグ")
Syoribi = SetTimeYYYYMMDD(Content.Fields("処理日"))
DbSenpoBunsyoNaiyoCD = Content.Fields("先方文書内容CD")
SenpoSyoribi = SetTimeYYYYMMDD(Content.Fields("先方処理日"))
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("学生番号")
SakujyoFlg = Content.Fields("削除フラグ")
GokeiKingaku = Unsohi
If 0=1 Then 'この部分は計算間違いがあるけど使わないのでコメントアウト
Do While Not(Content.BOF Or Content.EOF)
Dim DenpyoSEQ
DenpyoSEQ = Content.Fields("文書内容SEQ")
SyohinCD(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("数量")
GokeiKingaku = GokeiKingaku + Kingaku(DenpyoSEQ)
SyohizeiKingaku = Int(GokeiKingaku * GB_Shohizei / 100)
ZeikomiKingaku = SyohizeiKingaku + GokeiKingaku
Content.MoveNext
Loop
End If
End If
End If
Dim jj,tmps
For ii = 1 To 5
If SyohinName(ii) = "" Then
SyohinName(ii) = "以下余白"
Exit For
End If
Next
%>