%
'
'
%>
<%
main()
Sub main()
Dim BunsyoNaiyoCD, Syoribi, TorihikisakiCD, NonyuKijitsu
Dim UnsoGaisyaCD, UntinSyogakariKubun, Unsohi, UnsohiSeikyuFlg, Tekiyo, ShiharaiHoho, HasshinFlg
Dim SenpoBunsyoNaiyoCD , SenpoBunsyoSyuruiCD, SenpoSyoribi
Dim BunsyoSyuruiCD
Dim Kakaku(6) '標準単価
Dim SyohinCD(6) '商品コード
Dim SyohinName(6) '商品名称
Dim Suryo(6) '数量
Dim Tanka(6) '単価
Dim UnsoTanka(6) '運送単価
Dim Zaiko(6) '在庫数量
Dim GakuseiShimei '学生氏名(係印)
Dim SyoruiMei
Dim Query
Dim Content
Dim Shimei
Dim PageType
Dim ZaikoTemp
Dim SakuseiKaisyaCD
Dim NyusyukoKubun
Dim HenpinMotoCD
Dim ShijyoCD(5)
PageType = Request("PageType")
BunsyoNaiyoCD = Request("BunsyoNaiyoCD")
BunsyoSyuruiCD = Request("BunsyoSyuruiCD")
SenpoBunsyoNaiyoCD = Request("SenpoBunsyoNaiyoCD")
SenpoBunsyoSyuruiCD = Request("SenpoBunsyoSyuruiCD")
TorihikisakiCD = Request("TorihikisakiCD")
SakuseiKaisyaCD = Request("SakuseiKaisyaCD")
NyusyukoKubun = Request("NyusyukoKubun")
Dim SyohinNyusyukkoSeikousei
Dim Jissenbi
Dim Kitakuriyou
Dim SenpoKitakuGaisyaCD
Query = "exec SPM演習取得 '" & GB_SystemCD & "','" & EnshuCD & "'"
Set Content = OpenQuery(Query)
If Not(Content.BOF Or Content.EOF) Then
SyohinNyusyukkoSeikousei = Content.Fields("商品入出庫整合性利用")
Jissenbi = Content.Fields("実践日")
Kitakuriyou = Content.Fields("寄託倉庫利用")
Query = "exec SPM会社取得 '" & GB_SystemCD & "','" & EnshuCD & "','" & TorihikisakiCD & "'"
Set Content = OpenQuery(Query)
If Not(Content.BOF Or Content.EOF) Then
SenpoKitakuGaisyaCD = Content.Fields("寄託会社CD")
End If
End If
'###Debug
'Response.Write("GB_SystemCD:" & GB_SystemCD & "
")
'Response.Write("EnshuCD:" & EnshuCD & "
")
'Response.Write("KaisyaCD:" & KaisyaCD & "
")
'Response.Write("BunsyoNaiyoCD:" & BunsyoNaiyoCD & "
")
'Response.Write("BunsyoSyuruiCD:" & BunsyoSyuruiCD & "
")
'Response.Write("SakuseiKaisyaCD:" & SakuseiKaisyaCD & "
")
'Response.Write("SenpoBunsyoSyuruiCD:" & SenpoBunsyoSyuruiCD & "
")
'Response.Write("SenpoBunsyoNaiyoCD:" & SenpoBunsyoNaiyoCD & "
")
Dim SenpoFlg
SenpoFlg = 0
If SenpoBunsyoNaiyoCD <> "" Then
SenpoFlg = 1
End If
Dim SenpoTmpBunsyoSyuruiCD
If BunsyoSyuruiCD = "SS" Then
SenpoTmpBunsyoSyuruiCD = "SU"
End if
' SyoruiMei = ConvKubunMeisyo("入出庫区分", BunsyoSyuruiCD)
SyoruiMei = "仕入返品"
If BunsyoNaiyoCD <> "" Or SenpoBunsyoNaiyoCD <> "" Then
If SenpoFlg = 1 Then
Query = "exec SPD入出庫取得2 '" & GB_SystemCD & "','" & EnshuCD & "','" & KaisyaCD & "', '" & SakuseiKaisyaCD & "', '" & SenpoBunsyoSyuruiCD & "', '" & SenpoBunsyoNaiyoCD & "'"
Else
Query = "exec SPD入出庫取得2 '" & GB_SystemCD & "','" & EnshuCD & "','" & KaisyaCD & "', '" & KaisyaCD & "', '" & BunsyoSyuruiCD & "', '" & BunsyoNaiyoCD & "'"
End If
'Response.Write("Query:" & Query & "
")
'Response.Write("SenpoFlg:" & SenpoFlg & "
")
Set Content = OpenQuery(Query)
If Not(Content.BOF Or Content.EOF) Then
If SenpoFlg = 1 Then
TorihikisakiCD = Content.Fields("作成会社CD")
SenpoSyoribi = Content.Fields("処理日")
Syoribi = Content.Fields("処理日")
Else
TorihikisakiCD = Content.Fields("取引先CD")
SenpoSyoribi = Content.Fields("先方処理日")
Syoribi = Content.Fields("処理日")
End If
' If 1 = 0 Then
UntinSyogakariKubun = Content.Fields("運賃諸掛区分")
Unsohi = Content.Fields("運送費")
' End If
' GakuseiShimei = Content.Fields("氏名")
Do While Not(Content.BOF Or Content.EOF)
Dim NyusyukoSEQ
NyusyukoSEQ = Content.Fields("入出庫SEQ")
SyohinCD(NyusyukoSEQ) = Content.Fields("商品CD")
ShijyoCD(NyusyukoSEQ) = Content.Fields("市場CD")
Suryo(NyusyukoSEQ) = Content.Fields("数量")
Kakaku(NyusyukoSEQ) = ConvSyohinHanbaiTanka(Content.Fields("商品CD"))
Zaiko(NyusyukoSEQ) = ConvSyohinZaiko(Content.Fields("商品CD"))
'If SenpoFlg <> 1 Then
Tanka(NyusyukoSEQ) = Content.Fields("単価")
'End If
' If BunsyoSyuruiCD = "SX" Or BunsyoSyuruiCD = "SY" Then
' If Suryo(NyusyukoSEQ) <> "" Then
' Suryo(NyusyukoSEQ) = -1 * Suryo(NyusyukoSEQ)
' End If
' End If
If 1 = 0 Then
If SenpoFlg = 1 Then
UnsoTanka(NyusyukoSEQ) = ""
Else
UnsoTanka(NyusyukoSEQ) = Content.Fields("運送単価")
End If
End If
UnsoTanka(NyusyukoSEQ) = Content.Fields("運送単価")
If UntinSyogakariKubun = "K" Then
Tanka(NyusyukoSEQ) = Tanka(NyusyukoSEQ) + UnsoTanka(NyusyukoSEQ)
End If
If "" & Tanka(NyusyukoSEQ) = "" Then
Tanka(NyusyukoSEQ) = 0
End If
Content.MoveNext
'Response.Write("NyusyukoSEQ:" & NyusyukoSEQ & "
")
'Response.Write("Tanka(" & NyusyukoSEQ & "):" & Tanka(NyusyukoSEQ) & "
")
Loop
End If
End If
Dim jj,tmps
Dim SyohinMeisyo, SyohinMeisyoListWidth, ShijyoListWidth
'↓市場・商品表示幅の指定及び商品名称・商品略名称の指定(修正061031小野)
SyohinMeisyo = "商品名称"
SyohinMeisyoListWidth = "width: 200;"
ShijyoListWidth = "width:80"
If BunsyoSyuruiCD <> "SC" Then
SyohinMeisyo = "商品名称"
SyohinMeisyoListWidth = "width: 120;"
ShijyoListWidth = "width:80"
ElseIf BunsyoSyuruiCD <> "KI" AND BunsyoSyuruiCD <> "KX" AND BunsyoSyuruiCD <> "KY" AND BunsyoSyuruiCD <> "SC" Then
SyohinMeisyo = "商品名称"
SyohinMeisyoListWidth = "width: 120;"
ShijyoListWidth = "width:80"
Else
SyohinMeisyo = "商品名称"
End If
'↑市場・商品表示幅の指定及び商品名称・商品略名称の指定(修正061031小野)
%>