注文受付日 |
取引先 |
納入場所 |
納入期日 |
摘要 |
<% If BunsyoSyuruiCD = "KS" Then %>
発信 |
<% Else %>
依頼 |
<% End If %>
|
<%
Dim Query
Dim Query2
Dim Content
Dim Content2
Dim SakuseiKaisyaCD '作成会社CD
Dim TorihikisakiCD '取引先CD
Dim KitakuGaisyaCD '寄託会社CD
Dim SenpoKitakuGaisyaCD '先方寄託会社CD(納入場所)
Dim UnsoGaisyaCD '運送会社CD
Dim ii, jj
Dim bShow 'bShow=1 表示 bShow=0 非表示
Dim HakoFlag
Dim HakoFlagHyoji
ii = 0
Query = "exec SPD仕入売上書類一覧4 '" & GB_SystemCD & "','" & EnshuCD & "','" & KaisyaCD & "', '" & KaisyaCD & "', '" & BunsyoSyuruiCD & "'"
Set Content = OpenQuery(Query)
Do While Not(Content.BOF Or Content.EOF)
bShow = 0
If "" & Content.Fields("削除フラグ") <> "1" Then
bShow=1
End If
'文書種類CD=KSの同データをチェック
Query2 = "exec SPD仕入売上書類取得4 '" & GB_SystemCD & "','" & EnshuCD & "','" & KaisyaCD & "', '" & KaisyaCD & "', 'KS' , '" & Content.Fields("文書内容CD") & "' "
Set Content2 = OpenQuery(Query2)
If Not(Content2.BOF Or Content2.EOF) Then
HakoFlag = Content2.Fields("発行フラグ")
Else
HakoFlag = 0
End If
If HakoFlag = 1 Then
HakoFlagHyoji="済"
Else
HakoFlagHyoji="未"
End If
TorihikisakiCD = Content.Fields("取引先CD")
If BunsyoSyuruiCD <> "KS" And HakoFlag = 1 Then
ElseIf bShow = 1 Then
Response.Write("" & vbCrLf)
Response.Write("" & Content.Fields("先方処理日") & " | " & vbCrLf)
Response.Write("" & ConvKaisyaMeisyo(Content.Fields("取引先CD")) & " | " & vbCrLf)
Response.Write("" & ConvKaisyaMeisyo(Content.Fields("先方寄託会社CD")) & " | " & vbCrLf)
Response.Write("" & Content.Fields("納入期日") & " | " & vbCrLf)
Response.Write("" & Content.Fields("摘要") & " | " & vbCrLf)
Response.Write("" & HakoFlagHyoji & " | " & vbCrLf)
ii = ii + 1
Response.Write(" ")
End If
Content.MoveNext
Loop
For jj = ii To 19
Response.Write(" | " & vbCrLf)
Response.Write(" | " & vbCrLf)
Response.Write(" | " & vbCrLf)
Response.Write(" | " & vbCrLf)
Response.Write(" | " & vbCrLf)
Response.Write(" | " & vbCrLf)
Response.Write("")
Next
%>
|
|
|