%
Function HokenRyo(EnshuCD, KaisyaCD, MousikomiNum, AutoFlg, PrintFlg)
Dim EnshuName
Dim TekiyoCD , Tekiyo '“E—vƒR[ƒhA“E—v
' Dim MousikomiNum '\ž”Ô†
Dim KanrenKaisyaCD '‰ïŽÐƒR[ƒhAŠÖ˜A‰ïŽÐƒR[ƒh
Dim TorihikisakiCD,HokenkikanFrom,HokenkikanTo
Dim SyohinCD '¤•iƒR[ƒh
Dim SyohinName '¤•i–¼Ì
Dim Tanka '’P‰¿
Dim Suryo '”—Ê
Dim Kakaku '•W€‰¿Ši
Dim Kingaku '•ÛŒ¯‘ÎÛ‹àŠz
Dim Ryoritsu '—¿—¦
Dim HokenRyokin '•ÛŒ¯—¿‹à
Dim HSyubetsuCode '•ÛŒ¯Ží•ÊCD
Dim Biko '”õl
Dim Mosikomibi
Dim KaisyaRyakuMeisyo
Dim HokenName
Dim HokenKubun
Dim Query
Dim Content
MousikomiNum = Request("MousikomiNum")
'‘ÎÛƒf[ƒ^‚f‚d‚s•ÛŒ¯î•ñŽæ“¾
Query = "exec SPC•ÛŒ¯Žæ“¾ '" & GB_SystemCD & "','" & EnshuCD & "','" & KaisyaCD & "', "& MousikomiNum & ""
Set Content = OpenQuery(Query)
If Not(Content.BOF Or Content.EOF) Then
KaisyaCD = Content.Fields("‰ïŽÐCD")
MousikomiNum = Content.Fields("\ž”Ô†")
if IsNull(Content.Fields("ŽæˆøæCD")) then
TorihikisakiCD = ""
else
TorihikisakiCD=Content.Fields("ŽæˆøæCD")
'KaisyaRyakuMeisyo=ConvKaisyaRyakuMeisyoDx(EnshuCD, TorihikisakiCD)
KaisyaRyakuMeisyo=ConvKaisyaMeisyoDx(EnshuCD, TorihikisakiCD)
end if
if IsNull(Content.Fields("•ÛŒ¯Ží•Ê")) then
HSyubetsuCode=""
else
HSyubetsuCode = Content.Fields("•ÛŒ¯Ží•Ê")
Dim Query1,Content1
Query1 = "exec SPC•ÛŒ¯ˆê—— '" & GB_SystemCD & "','" & EnshuCD & "','" & KaisyaCD & "'"
Set Content1 = OpenQuery(Query1)
Do While Not(Content1.BOF Or Content1.EOF)
If Content1.Fields("‹æ•ªCD") = HSyubetsuCode Then
HokenName = Content1.Fields("‹æ•ª–¼Ì")
End If
Content1.MoveNext
Loop
end if
HokenKubun = "" & Content.Fields("•ÛŒ¯‹æ•ª")
If HokenKubun = "" Then
HokenKubun = "0"
End If
if IsNull(Content.Fields("\ž”NŒŽ“ú")) then
Mosikomibi=""
else
Mosikomibi = SetTimeYYYYMMDD(Content.Fields("\ž”NŒŽ“ú"))
end if
if IsNull(Content.Fields("•ÛŒ¯ŠJŽn”NŒŽ“ú")) then
HokenkikanFrom=""
else
HokenkikanFrom = SetTimeYYYYMMDD(Content.Fields("•ÛŒ¯ŠJŽn”NŒŽ“ú"))
end if
if IsNull(Content.Fields("•ÛŒ¯I—¹”NŒŽ“ú")) then
HokenkikanTo=""
else
HokenkikanTo = SetTimeYYYYMMDD(Content.Fields("•ÛŒ¯I—¹”NŒŽ“ú"))
end if
if IsNull(Content.Fields("¤•iCD")) then
SyohinCD=""
else
SyohinCD = Content.Fields("¤•iCD")
SyohinName=ConvSyohinMeisyo(SyohinCD)
end if
'•W€”Ì”„’P‰¿‚Å‚Í‚È‚’P‰¿‚ðŽw’è‚·‚é•ûŽ®‚É•ÏX
If IsNull(Content.Fields("’P‰¿")) Then
If SyohinCD <> "" then
'‹Œƒo[ƒWƒ‡ƒ“Žd—l
Tanka = ConvSyohinHanbaiTanka(SyohinCD)
Else
Tanka = ""
End If
Else
Tanka = Content.Fields("’P‰¿")
End If
if IsNull(Content.Fields("”—Ê")) then
Suryo=""
else
Suryo = Content.Fields("”—Ê")
end if
Kingaku = Content.Fields("•ÛŒ¯‘ÎÛ‹àŠz")
If "" & Kingaku = "" And "" & Tanka <> "" And "" & Suryo <> "" Then
On Error Resume Next
Err.Clear()
Kingaku = Tanka * Suryo
If Err.Description <> "" Then
Kingaku = 0
End If
On Error Goto 0
End If
if IsNull(Content.Fields("—¿—¦")) then
Ryoritsu=""
else
Ryoritsu = Content.Fields("—¿—¦")
end if
if IsNull(Content.Fields("¿‹‹àŠz")) then
HokenRyokin=""
else
HokenRyokin = Content.Fields("¿‹‹àŠz")
end if
'if IsNull(Content.Fields("”õl")) then
if Content.Fields("”õl")="" then
Biko=""
else
Biko = Content.Fields("”õl")
end if
End If
%>
<% If PrintFlg = 1 Then %>
<% Else %>
<% End If %>
\ž”Ô† |
<% = MousikomiNum %> |
Žæˆøæ |
<% = KaisyaRyakuMeisyo %> |
•ÛŒ¯Ží•Ê |
<% = HokenName %> |
\ž”NŒŽ“ú |
<% = Mosikomibi %> |
•ÛŒ¯ŠúŠÔ |
<% = HokenkikanFrom %> |
@` |
@<% = HokenkikanTo %> |
|
<% If HSyubetsuCode = "H1" Then %>
•ÛŒ¯‹æ•ª |
<% If HokenKubun = "2" Then %>”õ•i<% ElseIf HokenKubun = "1" Then %>Œš•¨<% Else %>¤•i<% End If %> |
<% End If %>
<% If HokenKubun = "0" Then %>
¤•i |
<% = SyohinName %> |
’P‰¿ |
<% = SetMoney(Tanka, false, false) %> |
¤•i”—Ê |
<% = SetNumber(Suryo, false) %> |
<% End If %>
•ÛŒ¯‘ÎÛ‹àŠz |
<% = SetMoney(Kingaku, false, false) %> |
—¿—¦ |
<% = SetNumber(Ryoritsu, false) %> |
•ÛŒ¯—¿‹à |
<% = SetMoney(HokenRyokin, false, false) %> |
”õl |
<% = Biko %> |
|
<%
End Function
%>