%
'
'################################################
' 名称 :お買上票の表示
' 作成日 :2007/2/4
' 作成者 :Masayoshi Wada
' 目的 :お買上票を表示する
' 概要 :
' <<表示>>
'################################################
'
%>
<%
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 Syoribi, TorihikisakiCD, NonyuKijitsu
Dim UnsoGaisyaCD, UntinSyogakariKubun, Unsohi, UnsohiSeikyuFlg, ShiharaiHoho, HasshinFlg
'商品Mテーブル
Dim GokeiKingaku '合計金額
Dim ShohizeiKingaku '消費税
Dim ZeikomiKingaku '税込合計金額
Dim ShoruiMei
Dim Query
Dim Content
Dim Shimei
Dim ShohinGazoStr
Dim KaisyaCD1
Dim AdminMailFlag
Dim ShohinNyusyukkoSeigosei
AdminMailFlag = 0
ShohinNyusyukkoSeigosei = GetEnshuParam(EnshuCD, "商品入出庫整合性利用")
Dim Action
Action = Request("Actin")
Dim RouteType
RouteType = Request("RouteType")
Dim PageType
PageType = Request("PageType")
Dim BunsyoSyuruiCD
BunsyoSyuruiCD = Request("BunsyoSyuruiCD")
Dim BunsyoNaiyoCD
BunsyoNaiyoCD = Request("BunsyoNaiyoCD")
Dim SakuseiKaisyaCD
SakuseiKaisyaCD = Request("SakuseiKaisyaCD")
Dim Kaisyamei
Dim KaisyaRyakumei
Dim kaisyaKanamei
Dim ZipCode
Dim Adr1
Dim Adr2
Dim Tel
Dim Fax
Dim GyosyuCD
Dim Set_ShijyoCD
Dim jj,tmps
Dim SyohinMeisyo, SyohinMeisyoListWidth, ShijyoListWidth
'↓市場・商品表示幅の指定及び商品名称・商品略名称の指定(修正061031小野)
SyohinMeisyo = "商品名称"
SyohinMeisyoListWidth = "width: 155;"
ShijyoListWidth = "width:85"
'↑市場・商品表示幅の指定及び商品名称・商品略名称の指定(修正061031小野)
Query = "exec SPM会社取得 '" & GB_SystemCD & "','" & EnshuCD & "','" & KaisyaCD & "'"
Set Content = OpenQuery(Query)
If Not(Content.BOF Or Content.EOF) Then
Kaisyamei = Content.Fields("会社名称")
KaisyaRyakumei = Content.Fields("会社略名称")
kaisyaKanamei = Content.Fields("会社カナ名称")
ZipCode = Content.Fields("郵便番号")
Adr1 = Content.Fields("住所1")
Adr2 = Content.Fields("住所2")
Tel = Content.Fields("TEL")
Fax = Content.Fields("FAX")
GyosyuCD = Content.Fields("業種CD")
Set_ShijyoCD = Content.Fields("市場CD")
End If
'寄託利用フラグ取得
Dim Kitakuriyou
Query = "exec SPM演習取得 '" & GB_SystemCD & "','" & EnshuCD & "'"
Set Content = OpenQuery(Query)
If Not(Content.BOF Or Content.EOF) Then
Kitakuriyou = Content.Fields("寄託倉庫利用")
End If
' 小売販売データ読み込み
Dim Query2
Dim Content2
Dim Query3
Dim Content3
' 小売販売テーブルヘッダ部
Dim KyakuName '客氏名
Dim Kaiagebi '買上日
Dim Tekiyo '摘要
Dim GakuseiBango '学生番号
Dim GakuseiShimei '学生氏名
Dim KaiageTensu '買上点数
Dim KaiageKingaku '買上金額
Dim ShohiZei '消費税
Dim Soryo '送料
Dim GokeiUriage '合計売上
Dim KaimonohyoPrintF '買物票印刷フラグ
Dim ShukkaF '出荷フラグ
Dim RyoshushoF '領収書印刷フラグ
Dim KoshinF '入出庫更新フラグ
Dim SakujyoF '削除フラグ
Dim KitakuSokoriyo '寄託倉庫利用
Dim KoushinDate '更新日時
' 小売販売テーブル明細部
Dim ShohinCD(6) '商品CD
Dim ShohinMei(6) '商品名
Dim ShohinRyakumei(6) '商品略称
Dim HyojyunTanka(6) '標準単価
Dim JitubaiTanka(6) '実販売単価
Dim ShiireTanka(6) '仕入単価
Dim Suryo(6) '数量
Dim Henpin(6) '返品数量
Dim Kingaku(6) '金額
Dim TaxRate(5) '消費税率
Dim SyohinGazo(6) '商品画像
Dim SyohinGazoStr '商品画像ストリング
ShoruiMei = "お買い上げ票"
'For Debug
'Response.Write("
")
'Response.Write("GB_SystemCD:" & GB_SystemCD & "
")
'Response.Write("EnshuCD:" & EnshuCD & "
")
'Response.Write("KaisyaCD:" & KaisyaCD & "
")
'Response.Write("SakuseiKaisyaCD:" & SakuseiKaisyaCD & "
")
'Response.Write("BunsyoSyuruiCD:" & BunsyoSyuruiCD & "
")
'Response.Write("BunsyoNaiyoCD:" & BunsyoNaiyoCD & "
")
'Response.Write("KyakuName:" & KyakuName & "
")
'小売販売ヘッダ部読み込み
Query2 = "exec SPK小売販売取得_合計 '" & GB_SystemCD & "','" & EnshuCD & "','" & KaisyaCD & "', '" & SakuseiKaisyaCD & "', '" & BunsyoSyuruiCD & "','" & BunsyoNaiyoCD & "'"
Set Content2 = OpenQuery(Query2)
Dim kk, GokeiSuryo, GokeiGaku, GokeiShohizei, ZeikomiGaku, GokeiSoryo
Do While Not(Content2.BOF Or Content2.EOF)
KyakuName = Content2.Fields("客氏名") '客氏名
Kaiagebi = Content2.Fields("買上日") '買上日
Tekiyo = Content2.Fields("摘要") '摘要
GakuseiBango = Content2.Fields("学生番号") '学生番号
GakuseiShimei = Content2.Fields("学生氏名") '学生氏名(係印)
KaiageTensu = Content2.Fields("買上点数") '買上点数
KaiageKingaku = Content2.Fields("買上金額") '買上金額
ShohiZei = Content2.Fields("消費税") '消費税
Soryo = Content2.Fields("送料") '送料
GokeiUriage = Content2.Fields("合計金額") '合計金額
KaimonohyoPrintF = Content2.Fields("買上票印刷フラグ") '買い物票印刷フラグ
ShukkaF = Content2.Fields("出荷フラグ") '出荷フラグ
RyoshushoF = Content2.Fields("領収書印刷フラグ") '領収書印刷フラグ
KoshinF = Content2.Fields("入出庫更新フラグ") '入出庫更新フラグ
SakujyoF = Content2.Fields("削除フラグ") '削除フラグ
KitakuSokoriyo = Content2.Fields("寄託倉庫利用") '寄託倉庫利用
KoushinDate = Content2.Fields("更新日時") '更新日時
Content2.MoveNext
Loop
'小売販売明細部読み込み
Query3 = "exec SPK小売販売取得_明細 '" & GB_SystemCD & "','" & EnshuCD & "','" & KaisyaCD & "', '" & SakuseiKaisyaCD & "', '" & BunsyoSyuruiCD & "', '" & BunsyoNaiyoCD & "'"
kk = 0 '行シーケンス
Set Content3 = OpenQuery(Query3)
Do While Not(Content3.BOF Or Content3.EOF)
ShohinCD(kk) = Content3.Fields("商品CD") '商品CD
ShohinMei(kk) = Content3.Fields("商品名") '商品名
ShohinRyakumei(kk) = Content3.Fields("商品略称") '商品略称
HyojyunTanka(kk) = Content3.Fields("標準売価") '標準売価
JitubaiTanka(kk) = Content3.Fields("実販売単価") '実販売単価
ShiireTanka(kk) = Content3.Fields("仕入単価") '仕入単価
Suryo(kk) = Content3.Fields("数量") '数量
Henpin(kk) = Content3.Fields("返品数量") '返品数量
Suryo(kk) = Suryo(kk) - Henpin(kk) '現在数量
Kingaku(kk) = Content3.Fields("金額") '金額
TaxRate(kk) = Content3.Fields("消費税率") '消費税率
If "" & TaxRate(kk) = "" Or GB_ShohizeiMode <> 1 Then
TaxRate(kk) = StdTaxRate
End If
SyohinGazo(kk) = ConvSyohinGazo(EnshuCD, Content3.Fields("商品CD"))
If SyohinGazoStr <> "" Then
SyohinGazoStr = SyohinGazoStr & ","
End If
If SyohinGazo(kk) <> "" Then
SyohinGazoStr = SyohinGazoStr & """" & Fgoods & "/" & EnshuCD & "/" &SyohinGazo(kk) & """"
Else
SyohinGazoStr = SyohinGazoStr & """/" & HomeAlias & "/images/truck_box.gif"""
End If
kk = kk + 1
ShohinCD(kk) = ""
Content3.MoveNext
Loop
'For Debug
'Response.Write("ShohiMei:" & ShohinMei(0) & "
")
%>