% ' ' %> <% main() Sub main() Dim SakuseiKaisyaCD '作成会社CD Dim KitakuIraiKaisyaCD '寄託依頼会社CD Dim KitakuNo '寄託受付番号 Dim NyukoDay '入庫年月日 Dim YukoFlg '有効フラグ Dim UnsoGaisyaCD '運送会社CD(とりあえず使用しない) Dim BunsyoSyuruiCD '文書種類CD(使用しない) Dim Kakaku(6) '標準単価 Dim SyohinCD(6) '商品コード Dim SyohinName(6) '商品名称 Dim Suryo(6) '数量 Dim Tanka(6) '仕入単価 Dim MotoTanka(6) '元単価 Dim UnsoTanka(6) '運送単価 Dim Zaiko(6) '在庫数量 Dim GakuseiShimei '学生氏名(係印) Dim SyoruiMei '書類名 Dim Query Dim Content Dim Shimei '氏名 Dim ShijyoCD(5) '市場CD Dim Syoribi '処理日 'ページング処理用 Dim Page If Request("Page") = "" Then Page = 0 Else Page = CInt(Request("Page")) End If SakuseiKaisyaCD = Request("SakuseiKaisyaCD") KitakuIraiKaisyaCD = Request("KitakuIraiKaisyaCD") KitakuNo = Request("KitakuNo") 'SyoruiMei = ConvKubunMeisyo("入出庫区分", BunsyoSyuruiCD) SyoruiMei = "寄託入庫" If KitakuNo <> "" Then Query = "exec SPD寄託入庫取得 '" & GB_SystemCD & "','" & EnshuCD & "','" & KaisyaCD & "', '" & SakuseiKaisyaCD & "', '" & KitakuIraiKaisyaCD & "', '" & KitakuNo & "'" 'Response.Write(Query) Set Content = OpenQuery(Query) If Not(Content.BOF Or Content.EOF) Then NyukoDay = Content.Fields("入庫年月日") YukoFlg = Content.Fields("有効フラグ") Syoribi = Content.Fields("処理日") 'ページング処理 Dim PreDenpyoSEQ PreDenpyoSEQ = 0 Dim DenpyoSEQ Dim PageCnt PageCnt = 0 Dim SkipCnt SkipCnt = Page * 5 Do While Not(Content.BOF Or Content.EOF) If PageCnt = SkipCnt Then Exit Do End If DenpyoSEQ = Content.Fields("寄託受付番号SEQ") If PreDenpyoSEQ <> DenpyoSEQ Then PreDenpyoSEQ = DenpyoSEQ PageCnt = PageCnt + 1 End If Content.MoveNext Loop Dim MeisaiCnt MeisaiCnt = 0 Do While Not(Content.BOF Or Content.EOF) DenpyoSEQ = Content.Fields("寄託受付番号SEQ") 'ページング処理 If PreDenpyoSEQ <> DenpyoSEQ Then PreDenpyoSEQ = DenpyoSEQ MeisaiCnt = MeisaiCnt + 1 If MeisaiCnt > 5 Then Exit Do End If End If SyohinCD(DenpyoSEQ - SkipCnt) = Content.Fields("商品CD") ShijyoCD(DenpyoSEQ - SkipCnt) = Content.Fields("市場CD") SyohinName(DenpyoSEQ - SkipCnt) = ConvSyohinMeisyo(Content.Fields("商品CD")) Kakaku(DenpyoSEQ - SkipCnt) = ConvSyohinHanbaiTanka(Content.Fields("商品CD")) Zaiko(DenpyoSEQ - SkipCnt) = ConvSyohinZaiko(Content.Fields("商品CD")) Suryo(DenpyoSEQ - SkipCnt) = Content.Fields("数量") Tanka(DenpyoSEQ - SkipCnt) = Content.Fields("仕入単価") Content.MoveNext Loop End If End If Dim FordBtn Dim FordUrl Dim BackBtn Dim BackUrl 'ページング処理 If Not(Content.BOF Or Content.EOF) Then FordBtn = "次ページ" FordUrl = "tblbtn( 'fu_kitaku_nyuko.asp?SakuseiKaisyaCD=" & SakuseiKaisyaCD & "&KitakuIraiKaisyaCD=" & KitakuIraiKaisyaCD & "&KitakuNo=" & KitakuNo & "&Page=" & Page + 1 &"')" End If If Page > 0 Then BackBtn = "前ページ" BackUrl = "tblbtn( 'fu_kitaku_nyuko.asp?SakuseiKaisyaCD=" & SakuseiKaisyaCD & "&KitakuIraiKaisyaCD=" & KitakuIraiKaisyaCD & "&KitakuNo=" & KitakuNo & "&Page=" & Page - 1 &"')" End If Dim jj,tmps Dim SyohinMeisyo, SyohinMeisyoListWidth, ShijyoListWidth SyohinMeisyo = "商品略名称" SyohinMeisyoListWidth = "width: 120;" ShijyoListWidth = "width:80" If BunsyoSyuruiCD <> "KI" AND BunsyoSyuruiCD <> "KX" AND BunsyoSyuruiCD <> "KY" Then SyohinMeisyo = "商品略名称" SyohinMeisyoListWidth = "width: 120;" ShijyoListWidth = "width:80" Else SyohinMeisyo = "商品名称" End If Dim Kitakuriyou Dim Jissenbi Query = "exec SPM演習取得 '" & GB_SystemCD & "','" & EnshuCD & "'" Set Content = OpenQuery(Query) If Not(Content.BOF Or Content.EOF) Then Kitakuriyou = Content.Fields("寄託倉庫利用") Jissenbi = Content.Fields("実践日") End If %>