<!-- #include file="../../../include.asp" --> <% '<!-- '################################################ ' 名称 :寄託出庫依頼処理 ' 作成日:2006/12/11 ' 作成者:鈴木 ' 目的 :寄託出庫依頼を表示する。 ' 概要 : '################################################ '--> ' %> <% main() Sub main() Dim SakuseiKaisyaCD '作成会社CD Dim TorihikisakiCD '取引先CD Dim KitakuGaisyaCD '寄託会社CD Dim SenpoKitakuGaisyaCD '先方寄託会社CD Dim UnsoGaisyaCD '運送会社CD Dim UnsoGaisyaMei '運送会社名 Dim BunsyoSyuruiCD '文書種類CD Dim BunsyoNaiyoCD '文書内容CD Dim SenpoBunsyoSyuruiCD '先方文書種類CD Dim SenpoBunsyoNaiyoCD '先方文書内容CD Dim Syoribi '処理日 Dim SenpoSyoribi '先方処理日 Dim NonyuKijitsu '納入期日 Dim UntinSyogakariKubun '運賃諸掛区分 Dim Unsohi '運送費 Dim UnsohiSeikyuFlg '運送請求フラグ Dim Tekiyo '摘要 Dim ShiharaiHoho '支払方法 Dim HasshinFlg '発信フラグ Dim YukoFlg '有効フラグ 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 PageType Dim ZaikoTemp Dim ShijyoCD(5) '市場CD Dim SyohinNyusyukkoSeikousei Dim KitakuFrom '寄託期間始 Dim KitakuTo '寄託期間終 SakuseiKaisyaCD = Request("SakuseiKaisyaCD") BunsyoSyuruiCD = Request("BunsyoSyuruiCD") BunsyoNaiyoCD = Request("BunsyoNaiyoCD") SenpoBunsyoNaiyoCD = Request("SenpoBunsyoNaiyoCD") SenpoBunsyoSyuruiCD = Request("SenpoBunsyoSyuruiCD") Dim Kitakuriyou Dim Jissenbi Query = "exec SPM演習取得 '" & GB_SystemCD & "','" & EnshuCD & "'" Set Content = OpenQuery(Query) If Not(Content.BOF Or Content.EOF) Then SyohinNyusyukkoSeikousei = Content.Fields("商品入出庫整合性利用") Kitakuriyou = Content.Fields("寄託倉庫利用") Jissenbi = Content.Fields("実践日") End If PageType = Request("PageType") Dim SenpoFlg SenpoFlg = 0 If SenpoBunsyoNaiyoCD <> "" Then SenpoFlg = 1 End If 'SyoruiMei = ConvKubunMeisyo("入出庫区分", BunsyoSyuruiCD) SyoruiMei = "寄託入庫確認書" If BunsyoNaiyoCD <> "" Or SenpoBunsyoNaiyoCD <> "" Then If SenpoFlg = 1 Then Query = "exec SPD入出庫取得4 '" & GB_SystemCD & "','" & EnshuCD & "','" & KaisyaCD & "', '" & SakuseiKaisyaCD & "', '" & SenpoBunsyoSyuruiCD & "', '" & SenpoBunsyoNaiyoCD & "'" Else Query = "exec SPD入出庫取得4 '" & GB_SystemCD & "','" & EnshuCD & "','" & KaisyaCD & "', '" & SakuseiKaisyaCD & "', '" & BunsyoSyuruiCD & "', '" & BunsyoNaiyoCD & "'" End If 'Response.Write(Query) Set Content = OpenQuery(Query) If Not(Content.BOF Or Content.EOF) Then If SenpoFlg = 1 Then Syoribi = Content.Fields("先方処理日") SenpoSyoribi = Content.Fields("処理日") Else Syoribi = Content.Fields("処理日") SenpoSyoribi = Content.Fields("先方処理日") End If SakuseiKaisyaCD = Content.Fields("作成会社CD") TorihikisakiCD = Content.Fields("取引先CD") UnsoGaisyaCD = Content.Fields("運送会社CD") KitakuGaisyaCD = Content.Fields("寄託会社CD") SenpoKitakuGaisyaCD = Content.Fields("先方寄託会社CD") YukoFlg = Content.Fields("有効フラグ") UntinSyogakariKubun = Content.Fields("運賃諸掛区分") Do While Not(Content.BOF Or Content.EOF) Dim DenpyoSEQ,PreDenpyoSEQ DenpyoSEQ = Content.Fields("入出庫SEQ") SyohinCD(DenpyoSEQ) = Content.Fields("商品CD") ShijyoCD(DenpyoSEQ) = Content.Fields("市場CD") SyohinName(DenpyoSEQ) = ConvSyohinMeisyo(Content.Fields("商品CD")) Kakaku(DenpyoSEQ) = ConvSyohinHanbaiTanka(Content.Fields("商品CD")) Suryo(DenpyoSEQ) = Content.Fields("数量") MotoTanka(DenpyoSEQ) = Content.Fields("単価") UnsoTanka(DenpyoSEQ) = Content.Fields("運送単価") If "" & UnsoTanka(DenpyoSEQ) <> "" And UntinSyogakariKubun = "K" Then MotoTanka(DenpyoSEQ) = MotoTanka(DenpyoSEQ) + UnsoTanka(DenpyoSEQ) End If Content.MoveNext Loop Query = "SELECT TGC寄託在庫F.* FROM TGC寄託在庫F " Query = Query & " WHERE " Query = Query & " システムCD = '" & GB_SystemCD & "' AND " Query = Query & " 演習CD = '" & EnshuCD & "' AND " Query = Query & " 会社CD = '" & KitakuGaisyaCD & "' AND " Query = Query & " 作成会社CD = '" & SakuseiKaisyaCD & "' AND " Query = Query & " 寄託依頼会社CD = '" & KaisyaCD & "' AND " ' Query = Query & " 寄託受付番号 = '" & BunsyoNaiyoCD & "'" Query = Query & " 先方文書種類CD = 'SU' AND" Query = Query & " 先方文書内容CD = '" & BunsyoNaiyoCD & "'" Set Content = db.Execute(Query) If Not(Content.BOF Or Content.EOF) Then KitakuFrom = Content.Fields("寄託開始年月日") KitakuTo = Content.Fields("寄託保管期日") End If End If 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 %> <html> <% = HtmlHeader("") %> <SCRIPT LANGUAGE="JavaScript"> <!-- HomeAlias = "<% = HomeAlias %>"; HomeAliasSL = "<% = HomeAliasSL %>"; ExitFlg = 2; ///////////////////////////////////////// //function CngShohin //市場を選択し商品を変更する //060803suzuki //配列をASPでJavaScript内で作成しResponse.Write。 ///////////////////////////////////////// function CngShohin(selindex,selname){ //商品CD及び商品名の配列を作成 Val = new Array(); Tex = new Array(); //debug //alert(selindex); //alert(selname); <% Dim Query2,Content2,i,j i=0 j=0 'TDA市場Mから市場(市場CD)を取得 Query = "exec SPM市場一覧 '" & GB_SystemCD & "','" & EnshuCD & "'" Set Content = OpenQuery(Query) If Not(Content.BOF Or Content.EOF) Then Do While Not(Content.BOF Or Content.EOF) Response.Write("Val[" & i & "] = new Array()" & vbCrLf) Response.Write("Tex[" & i & "] = new Array()" & vbCrLf) 'TDA商品Mから商品CDと商品名を取得し、JavaScript用の配列として書き出す if i = 0 then Query2 = "exec SPM商品市場一覧 '" & GB_SystemCD & "','" & EnshuCD & "','', '" & GB_GakuseiNo & "'" else Query2 = "exec SPM商品市場一覧2 '" & GB_SystemCD & "','" & EnshuCD & "','" & Content.Fields("市場CD") & "', '" & GB_GakuseiNo & "'" end if Set Content2 = OpenQuery(Query2) If Not(Content2.BOF Or Content2.EOF) Then j = 0 Response.Write("Val[" & i & "][" & j & "] = ''" & vbCrLf ) Response.Write("Tex[" & i & "][" & j & "] = ' '" & vbCrLf ) j = j + 1 Do While Not(Content2.BOF Or Content2.EOF) Response.Write("Val[" & i & "][" & j & "] = '" & Content2.Fields("商品CD") & "'" & vbCrLf ) Response.Write("Tex[" & i & "][" & j & "] = '" & Content2.Fields(SyohinMeisyo) & "'" & vbCrLf ) Content2.MoveNext j = j + 1 Loop End If if i <> 0 then Content.MoveNext end if i = i + 1 Loop End If %> switch (selname) { case 'S1': document.form1.SyohinCD1.options.length = Val[selindex].length //配列長を変更 for(i=0;i<Val[selindex].length;i++){ document.form1.SyohinCD1.options[i].value = Val[selindex][i] document.form1.SyohinCD1.options[i].text = Tex[selindex][i] } document.form1.SyohinCD1.selectedIndex = 0 break; case 'S2': document.form1.SyohinCD2.options.length = Val[selindex].length //配列長を変更 for(i=0;i<Val[selindex].length;i++){ document.form1.SyohinCD2.options[i].value = Val[selindex][i] document.form1.SyohinCD2.options[i].text = Tex[selindex][i] } document.form1.SyohinCD2.selectedIndex = 0 break; case 'S3': document.form1.SyohinCD3.options.length = Val[selindex].length //配列長を変更 for(i=0;i<Val[selindex].length;i++){ document.form1.SyohinCD3.options[i].value = Val[selindex][i] document.form1.SyohinCD3.options[i].text = Tex[selindex][i] } document.form1.SyohinCD3.selectedIndex = 0 break; case 'S4': document.form1.SyohinCD4.options.length = Val[selindex].length //配列長を変更 for(i=0;i<Val[selindex].length;i++){ document.form1.SyohinCD4.options[i].value = Val[selindex][i] document.form1.SyohinCD4.options[i].text = Tex[selindex][i] } document.form1.SyohinCD4.selectedIndex = 0 break; case 'S5': document.form1.SyohinCD5.options.length = Val[selindex].length //配列長を変更 for(i=0;i<Val[selindex].length;i++){ document.form1.SyohinCD5.options[i].value = Val[selindex][i] document.form1.SyohinCD5.options[i].text = Tex[selindex][i] } document.form1.SyohinCD5.selectedIndex = 0 break; default: break; } } --> </SCRIPT> <body onkeydown="if(ExitFlg==2)ExitFlg=3;" onBeforeUnload="if(ExitFlg!=0)window.event.returnValue = ExitMsg(ExitFlg)" bgcolor="#5C70B6" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0"> <form OnKeyDown="FormKeyDown(this)" method="POST" action="fd_kitaku_nyuko_bin.asp" name="form1" autocomplete="off"> <input type="hidden" name="Action" value=""> <input type="hidden" name="BunsyoSyuruiCD" value="<% = BunsyoSyuruiCD %>"> <input type="hidden" name="UntinSyogakariKubun" value="<% = UntinSyogakariKubun %>"> <input type="hidden" name="ShinTanka1" value="<% = MotoTanka(1) %>"> <input type="hidden" name="ShinTanka2" value="<% = MotoTanka(2) %>"> <input type="hidden" name="ShinTanka3" value="<% = MotoTanka(3) %>"> <input type="hidden" name="ShinTanka4" value="<% = MotoTanka(4) %>"> <input type="hidden" name="ShinTanka5" value="<% = MotoTanka(5) %>"> <% Response.Write(HtmlDesign(1)) Response.Write(HttpL1(3)) If BunsyoSyuruiCD = "SC" Then Response.Write(HttpL2("会社選択" ,"tblbtn( '/" & HomeAlias & "/user/bk/')", GB_GyosyuMeisyo, "tblbtn( '/" & HomeAlias & "/user/bk/menu_" & GB_Gyosyu & ".asp')", "商品企画室", "tblbtn( '/" & HomeAlias & "/user/bk/menu_s5.asp')", SyoruiMei, "", "", "", "", "")) ElseIf BunsyoSyuruiCD = "SS" OR BunsyoSyuruiCD = "SX" Then Response.Write(HttpL2("会社選択" ,"tblbtn( '/" & HomeAlias & "/user/bk/')", GB_GyosyuMeisyo, "tblbtn( '/" & HomeAlias & "/user/bk/menu_" & GB_Gyosyu & ".asp')", "仕入部", "tblbtn( '/" & HomeAlias & "/user/bk/menu_s3.asp')", SyoruiMei, "", "", "", "", "")) Else Response.Write(HttpL2("会社選択" ,"tblbtn( '/" & HomeAlias & "/user/bk/')", GB_GyosyuMeisyo, "tblbtn( '/" & HomeAlias & "/user/bk/menu_" & GB_Gyosyu & ".asp')", "販売部", "tblbtn( '/" & HomeAlias & "/user/bk/menu_s2.asp')",SyoruiMei, "", "", "", "", "")) End If Response.Write(HttpL3("", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "")) If SyohinNyusyukkoSeikousei = "1" And SenpoBunsyoNaiyoCD <> "" Then Response.Write(HttpL3_1("受け付ける", "SubmitCheck()", "受け付けない", "form1.Action.value='Deny';SubmitReal(form1);", "", "", "", "", "", "")) Else If YukoFlg <> 1 Then Response.Write(HttpL3_1("受け付ける", "SubmitCheck()", "", "", "", "", "", "", "", "")) Else Response.Write(HttpL3_1("印刷", "PrintoutReal()", "", "", "", "", "", "", "", "")) End If End If 'Response.Write(HttpL3_2("先方書類一覧", "tblbtn( 'fd_kitaku_syuko_ichiran.asp?BunsyoSyuruiCD=" & BunsyoSyuruiCD & "')", "一覧表示", "tblbtn( 'fd_kitaku_syuko_ichiran.asp?BunsyoSyuruiCD=" & BunsyoSyuruiCD & "')", "", "", "", "", "", "")) 'Response.Write(HttpL3_2("先方書類一覧", "tblbtn( 'fd_kitaku_nyuko_ichiran.asp?BunsyoSyuruiCD=" & BunsyoSyuruiCD & "')", "", "", "", "", "", "", "", "")) Response.Write(HttpL3_2("一覧表示", "tblbtn( 'fd_kitaku_nyuko_ichiran.asp?BunsyoSyuruiCD=" & BunsyoSyuruiCD & "')", "", "", "", "", "", "", "", "")) Response.Write(HttpL4(SyoruiMei,"")) %> <div id="L0" style="position: absolute; visibility: hidden; left: 0px; top: -2000px;"> <table width="100%" height="100%" border="0" cellpadding="0" cellspacing="5"> <tr> <td align="CENTER" valign="middle"> <table width="600" height="355" border="0" cellpadding="10" cellspacing="0" style="border:solid 1px #000000" bgcolor="#FFFFFF"> <tr> <td height="355" align="CENTER" valign="middle"> <table width="600" border="0" cellspacing="0" cellpadding="0" height="355"> <tr> <td height="40" align="CENTER" valign="middle"> <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" height="30" width="580" class="tx1416"> <tr> <td width="25%"> <table border="0" cellpadding="0" cellspacing="0"> <tr class="tx1214"> <td align="left"> <table class="tx2224b" border="0" cellpadding="0" cellspacing="0" > <tr> <td align="center" nowrap><% If Len(SyoruiMei) < 8 Then Response.Write(SetStringInsertSpace(SyoruiMei)) Else Response.Write(SyoruiMei) End If %></td> </tr> </table> </td> </tr> </table> </td> <td> </td> </tr> </table> </td> </tr> <tr> <td height="45" align="CENTER" valign="middle"> <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" height="140" width="580" class="tx1618"> <tr> <td width="13%" height="20">入庫番号</td> <td width="41%" height="20"> <input type="hidden" name="BunsyoNaiyoCD" size="12" readonly class="tbox4_ro" value="<% = BunsyoNaiyoCD %>"><% = BunsyoNaiyoCD %> </td> <td width="12%" height="20">処 理 日</td> <td width="34%" height="20"> <% If YukoFlg = 1 Then %> <input type="hidden" name="Syoribi" size="12" readonly class="tbox4_ro" value="<% = Syoribi %>"><% = Syoribi %> <% ElseIf Jissenbi <> "" Then %> <input type="text" name="Syoribi" size="12" readonly class="tbox4_ro" value="<% = Jissenbi %>"> <% Else %> <input type="text" name="Syoribi" size="12" value="" onBlur="SetDate(this, 1, true)" class="tbox4"> <% End If %> </td> </tr> <tr> <td height="20">取 引 先</td> <td height="20"> <% If BunsyoNaiyoCD <> "" Then %> <input type="hidden" name="SakuseiKaisyaMei" size="20" readonly class="tbox4_ro" value="<% =ConvKaisyaMeisyoDX(EnshuCD, SakuseiKaisyaCD) %>"><% =ConvKaisyaMeisyoDX(EnshuCD, SakuseiKaisyaCD) %> <input type="hidden" name="SakuseiKaisyaCD" size="20" value="<% = SakuseiKaisyaCD %>"> <% Else %> <select size="1" name="TorihikisakiCD" class="tbox4" style="width:105" OnChange="SetSenpoKitakuGaisya();"> <option value=""> </option> <% Query = "exec SPM会社全部一覧 '" & GB_SystemCD & "','" & EnshuCD & "', '" & GakuseiNo & "'" Set Content = OpenQuery(Query) Do While Not(Content.BOF Or Content.EOF) 'If ((BunsyoKubun = "X" OR BunsyoKubun = "1") AND Content.Fields("業種CD") = "K") OR ((BunsyoKubun <> "X" AND BunsyoKubun <> "1") AND Content.Fields("業種CD") = "S") Then If (Content.Fields("業種CD") = "S") Then Dim TmpKaisyaCD TmpKaisyaCD = Content.Fields("会社CD") If TmpkaisyaCD <> KaisyaCD Then Response.Write("<option value=""" & Content.Fields("会社CD") & """") If Content.Fields("会社CD") = TorihikisakiCD Then Response.Write(" selected") End If Response.Write(">" & Content.Fields("会社名称") & "</option>" & vbCrLf) End If End If Content.MoveNext Loop %> </select> <% End If %> </td> <td height="20">納 入 日</td> <td height="20"> <% If BunsyoNaiyoCD <> "" Then %> <input type="hidden" name="SenpoSyoribi" size="12" readonly class="tbox4_ro" value="<% = SenpoSyoribi %>"><% = SenpoSyoribi %> <% Else %> <input type="text" name="SenpoSyoribi" size="12" value="" onBlur="SetDate(this, 1, true)" class="tbox4"> <% End If %> </td> </tr> <tr> <td height="20">出荷倉庫</td> <td height="20"> <input type="hidden" name="SenpoKitakuGaisyaMei" size="12" readonly class="tbox4_ro" value="<% =ConvKaisyaMeisyoDX(EnshuCD, SenpoKitakuGaisyaCD) %>"><% =ConvKaisyaMeisyoDX(EnshuCD, SenpoKitakuGaisyaCD) %> <input type="hidden" name="SenpoKitakuGaisyaCD" value="<% =SenpoKitakuGaisyaCD %>"> </td> <td height="20">寄託期間</td> <td height="20"> <% If YukoFlg = 1 Then %> <input type="hidden" name="KitakuFrom" size="12" readonly class="tbox4_ro" value="<% = KitakuFrom %>"><% = KitakuFrom %> <% Else %> <input type="hidden" name="KitakuFrom" size="12" readonly class="tbox4_ro" value="<% = SenpoSyoribi %>"><% = SenpoSyoribi %> <!-- <INPUT size="12" type="text" name="KitakuFrom" value="<% = SenpoSyoribi %>" onBlur="SetDate(this, 1, true)" class="tbox4"> --> <% End If %> ~ <% If YukoFlg = 1 Then %> <input type="hidden" name="KitakuTo" size="12" readonly class="tbox4_ro" value="<% = KitakuTo %>"><% = KitakuTo %> <% Else %> <INPUT size="12" type="text" name="KitakuTo" value="<% = KitakuTo %>" onBlur="SetDate(this, 1, true)" class="tbox4" > <% End If %> </td> </tr> <tr> <td height="20">納入場所</td> <td height="20"> <% If BunsyoNaiyoCD <> "" Then %> <input type="hidden" name="KitakuGaisyaMei" size="20" readonly class="tbox4_ro" value="<% =ConvKaisyaMeisyoDX(EnshuCD, KitakuGaisyaCD) %>"><% =ConvKaisyaMeisyoDX(EnshuCD, KitakuGaisyaCD) %> <input type="hidden" name="KitakuGaisyaCD" size="20" value="<% = KitakuGaisyaCD %>"> <% Else %> <input type="hidden" name="KitakuGaisyaMei" size="20" value="<% =ConvKaisyaMeisyo(KitakuGaisyaCD) %>" readonly class="tbox4_ro"><% =ConvKaisyaMeisyo(KitakuGaisyaCD) %> <input type="hidden" name="KitakuGaisyaCD" value="<% =KitakuGaisyaCD %>"> <% End If %> </td> <td height="20" align="center"></td> <td height="20"></td> </tr> <tr> <td height="20">運送会社</td> <td height="20"> <% If BunsyoNaiyoCD <> "" Then %> <input type="hidden" name="UnsoGaisyaCD" size="20" readonly class="tbox4_ro" value="<% =ConvKaisyaMeisyoDX(EnshuCD, UnsoGaisyaCD) %>"><% =ConvKaisyaMeisyoDX(EnshuCD, UnsoGaisyaCD) %> <% Else %> <select size="1" name="UnsoGaisyaCD" class="tbox4" style="width:105"> <option value=""> </option> <% Query = "exec SPM会社全部一覧 '" & GB_SystemCD & "','" & EnshuCD & "', '" & GakuseiNo & "'" Set Content = OpenQuery(Query) Do While Not(Content.BOF Or Content.EOF) If Content.Fields("業種CD") = "U" Then Response.Write("<option value=""" & Content.Fields("会社CD") & """") If Content.Fields("会社CD") = UnsoGaisyaCD Then Response.Write(" selected") End If Response.Write(">" & Content.Fields("会社名称") & "</option>" & vbCrLf) End If Content.MoveNext Loop %> </select> <% End If %> </td> <td height="20" align="center"></td> <td height="20"></td> </tr> </table> </td> </tr> <tr> <td align="CENTER"> <table width="580" height="180" border="0" cellpadding="4" cellspacing="0" style="border-collapse: collapse; border:solid 2px #FFFFFF"> <tr> <td width="100%" align="RIGHT"> <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width="580" bordercolor="#000000"> <tr> <td height="30" valign="TOP"> <table width="100%" height="30" border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#000000" class="tx1618" bgcolor="#CCCCCC"> <tr> <td align="center">商品名称</td> <td align="center" width="18%">標準単価</td> <% If BunsyoNaiyoCD = "" Then %> <td align="center" width="17%">在庫数</td> <% End If %> <td align="center" width="17%">数 量</td> <td align="center" width="18%">単 価</td> </tr> </table> </td> </tr> <tr> <td> <!-- ■市場選択機能追加060803suzuki //--> <table width="100%" height="180" border="1" cellpadding="3" cellspacing="0" style="border-collapse: collapse" bordercolor="#000000" class="tx1618"> <% dim ii For ii = 1 to 5 Response.Write("<tr>") If BunsyoNaiyoCD <> "" Then Response.Write("<td align='left'>" & ConvSyohinRyakuMeisyo(SyohinCD(ii)) & "<br></td>" & vbCrLf) Response.Write("<td align='right' width='18%'>" & SetMoney(Kakaku(ii), false, true) & "<br></td>" & vbCrLf) Response.Write("<td align='right' width='17%'>" & SetMoney(Suryo(ii), false, true) & "<br></td>" & vbCrLf) Response.Write("<td align='right' width='18%'>" & SetMoney(MotoTanka(ii), false, true) & "<br></td>" & vbCrLf) Else Response.Write("<td align='center'>") %> <select name="S<% =ii %>" size="1" style="<% = ShijyoListWidth %>" onChange="CngShohin(this.selectedIndex,this.name)" class="tbox4"> <option value=""> </option> <% Query = "exec SPM市場一覧 '" & GB_SystemCD & "','" & EnshuCD & "'" Set Content = OpenQuery(Query) Do While Not(Content.BOF Or Content.EOF) Response.Write("<option value=""" & Content.Fields("市場CD") & """") If Content.Fields("市場CD") = ShijyoCD(ii) Then Response.Write(" selected") End If Response.Write(">" & Content.Fields("市場名称") & "</option>" & vbCrLf) Content.MoveNext Loop %> </select> <% Response.Write("<select name='SyohinCD" & ii & "' size='1' class='tbox4' style='" & SyohinMeisyoListWidth & "' onChange='SetSyohinHanbaiTanka(" & ii & ");SetSyohinZaiko(" & ii & ");'>") Response.Write("<option value=''> </option>") Query = "exec SPM商品市場一覧 '" & GB_SystemCD & "','" & EnshuCD & "','" & ShijyoCD(ii) & "', '" & GB_GakuseiNo & "'" Set Content = OpenQuery(Query) Do While Not(Content.BOF Or Content.EOF) If BunsyoSyuruiCD <> "SC" Or (BunsyoSyuruiCD = "SC" And Content.Fields("所有会社CD") = KaisyaCD ) Then Response.Write("<option value='" & Content.Fields("商品CD") & "'") If Content.Fields("商品CD") = SyohinCD(ii) Then Response.Write(" selected") End If Response.Write(">" & Content.Fields("商品略名称") & "</option>" & vbCrLf) End If Content.MoveNext Loop Response.Write("</select></td>") Response.Write("<td align='center' width='18%'><input type='text' name='Kakaku" & ii & "' size='12' value='" & SetMoney(Kakaku(ii), false, true) & "' class='tbox5_ro' readonly></td>" & vbCrLf) Response.Write("<td align='center' width='17%'><input type='text' name='Zaiko" & ii & "' size='12' value='" & SetMoney(Zaiko(ii) + Suryo(ii), false, true) & "' class='tbox5_ro' readonly></td>" & vbCrLf) Response.Write("<td align='center' width='17%'><input type='text' name='Suryo" & ii & "' size='12' value='" & SetMoney(Suryo(ii), false, true) & "' onBlur='SetNumber(this, false, 9);SetUntin();' onkeyup='ChangeMoney(this);' class='tbox5' ></td>" & vbCrLf) Response.Write("<td align='center' width='18%'><input type='text' name='MotoTanka" & ii & "' size='12' value='" & SetMoney(MotoTanka(ii), false, true) & "' onBlur='SetNumber(this, false, 9);SetUntin();' onkeyup='ChangeMoney(this);' class='tbox5' ></td>" & vbCrLf) End If Response.Write("</tr>" & vbCrLf) Next %> </table> </td> </tr> </table> </td> </tr> </table> </td> </tr> </table> </td> </tr> <% If UntinSyogakariKubun = "K" Then %> <tr> <td height="25" align="center" class="tx1618"> ※ 運送費買主負担につき運送単価を組み入れています。 </td> </tr> <% End If %> </table> </td> </tr> </table> </div> </form> </body> <SCRIPT FOR="window" EVENT="onload" LANGUAGE="JavaScript"> SetUntin(); </SCRIPT> <SCRIPT LANGUAGE="JavaScript"> //################################################ // 名称:SetSyohinHanbaiTanka // 目的:商品標準販売価格をセットする。 // 作成:2002/11/1 山崎 //################################################ function SetSyohinHanbaiTanka(iiflag) { form1["Kakaku" + iiflag].value = ConvIntToMoney(ConvSyohinHanbaiTanka(document.form1["SyohinCD" + iiflag].value)); } //################################################ // 名称:SetSyohinZaiko // 目的:商品在庫数をセットする。 // 作成:2002/11/1 山崎 //################################################ function SetSyohinZaiko(iiflag) { if(typeof(form1["Zaiko" + iiflag]) == "object") { form1["Zaiko" + iiflag].value = ConvIntToMoney(ConvSyohinZaiko(document.form1["SyohinCD" + iiflag].value)); } } //################################################ // 名称:SetUntin // 目的:運賃請求額を更新する // 概要:運賃諸掛をチェックし、UnsohiSeikyuFlgを更新し、運賃とUnsohiSeikyuFlgを掛け運賃請求額を求める //################################################ function SetUntin() { <% If 1 = 0 Then %> var GokeiSuryo, UnsoTanka; GokeiSuryo = 0; for(ii = 1; ii<= 5; ii++) { if(form1["SyohinCD" + ii].value != "") { GokeiSuryo = GokeiSuryo + ConvMoneyToInt(form1["Suryo" + ii].value); form1["UnsoTanka" + ii].value = 0; } else { form1["UnsoTanka" + ii].value = ""; } } if(form1.UntinSyogakariKubun.value == "K") { if(GokeiSuryo != 0) { UnsoTanka = Math.floor(ConvMoneyToInt(form1.Unsohi.value) / GokeiSuryo); for(ii = 1; ii<= 5; ii++) { if(form1["SyohinCD" + ii].value != "") { form1["UnsoTanka" + ii].value = UnsoTanka ; } } } } <% End If %> } //################################################ // 名称:SubmitCheck // 目的:更新前に入力値をチェックする。 //################################################ function SubmitCheck() { if(form1.Syoribi.value == "") { alert("処理日を入力して下さい"); form1.Syoribi.focus(); return false; } //日付の前後チェック if(Date.parse(form1.Syoribi.value) < Date.parse(form1.SenpoSyoribi.value)) { alert("処理日が納入日より古い日付になっています。\r\n\r\n正しい日付を入力して下さい。"); return false; } if(typeof(form1.KitakuFrom) == "object") { if(form1.KitakuFrom.value == "") { alert("寄託期間を入力して下さい"); form1.KitakuFrom.focus(); return false; } } if(typeof(form1.KitakuTo) == "object") { if(form1.KitakuTo.value == "") { alert("寄託期間を入力して下さい"); form1.KitakuTo.focus(); return false; } } //日付の前後チェック if(Date.parse(form1.KitakuTo.value) < Date.parse(form1.KitakuFrom.value)) { alert("寄託期間の終了日が納入日より古い日付になっています。\r\n\r\n正しい日付を入力して下さい。"); return false; } <% If BunsyoNaiyoCD = "" Then %> if(typeof(form1.TorihikisakiCD) == "object") { if(form1.TorihikisakiCD.value == "") { alert("取引先を入力して下さい"); form1.TorihikisakiCD.focus(); return false; } } if(typeof(form1.SenpoSyoribi) == "object") { if(form1.SenpoSyoribi.value == "") { alert("納入日を入力して下さい"); form1.SenpoSyoribi.focus(); return false; } } //寄託会社CDのチェック <% If Kitakuriyou = 1 Then %> if(typeof(form1.KitakuGaisyaCD) == "object") { if(form1.KitakuGaisyaCD.value == "") { alert("寄託倉庫が設定されていません。"); //readonlyなのでフォーカスは特にあてない //form1.SenpoKitakuGaisyaCD.focus(); return false; } } if(typeof(form1.SenpoKitakuGaisyaCD) == "object") { if(form1.SenpoKitakuGaisyaCD.value == "") { alert("取引先の寄託倉庫が設定されていません。"); //readonlyなのでフォーカスは特にあてない //form1.SenpoKitakuGaisyaCD.focus(); return false; } } <% End If %> //** 2.運送会社のチェック if(typeof(form1.UnsoGaisyaCD) == "object") { if(form1.UnsoGaisyaCD.value == "") { alert("運送会社を入力して下さい"); form1.UnsoGaisyaCD.focus(); return false; } } //** 3.明細部のチェック var ii; var cnt; cnt=0; for(ii = 1;ii <= 5; ii++) { var SyohinCD; var Suryo; var Tanka; var Zaiko; var Kubun; SyohinCD = document.form1["SyohinCD" + ii].value; if(SyohinCD != "") { if(SyohinCD == "") { alert("商品を正しく選択して下さい"); form1["SyohinCD" + ii].focus(); return false; } Suryo = Math.floor(ConvMoneyToInt(document.form1["Suryo" + ii].value)); if ((isNaN(Suryo)) || (Suryo == 0)) { alert("数量を入力して下さい"); form1["Suryo" + ii].focus(); return false; } <% If GB_Gyosyu <> "K" AND BunsyoNaiyoCD = "" AND SyohinNyusyukkoSeikousei = "1" AND (BunsyoSyuruiCD = "SU" Or BunsyoSyuruiCD = "SX") Then %> Zaiko = Math.floor(ConvMoneyToInt(document.form1["Zaiko" + ii].value, false, false)); if (isNaN(Zaiko)) { Zaiko = 0; } if (Suryo > Zaiko) { alert("在庫数量が不足しています。数量を正しく入力して下さい"); return false; } <% End If %> <% If 1 = 0 Then %> Zaiko = Math.floor(ConvMoneyToInt(document.form1["Zaiko" + ii].value, false, false)); if (isNaN(Zaiko)) { Zaiko = 0; } if (Suryo > Zaiko) { if(!confirm("在庫数量が不足している可能性がありますが、出庫してもよろしいですか?")) { return false; } } <% End If %> <% If BunsyoSyuruiCD = "SC" Or BunsyoSyuruiCD = "SS" Or BunsyoSyuruiCD = "SX" Then %> MotoTanka = document.form1["MotoTanka" + ii].value; if(MotoTanka == "") { alert("仕入単価を入力して下さい"); form1["MotoTanka" + ii].focus(); return false; } <% End If %> cnt = 1 } } //** 3.明細部に入力が有るかどうかのチェック if (cnt == 0) { alert("商品明細を入力して下さい"); form1["SyohinCD1"].focus(); return false; } <% End If %> SubmitReal(form1); return true; } //################################################ // 名称:ConvSyohinHanbaiTanka // 目的:商品リストの表示 // 作成:2002/8/26 川崎 // 概要:TS商品Mの標準販売単価を返す。 //################################################ function ConvSyohinHanbaiTanka(SyohinCD) { <% Query = "exec SPM商品一覧 '" & GB_SystemCD & "','" & EnshuCD & "', '" & GB_GakuseiNo & "'" Set Content = OpenQuery(Query) Do While Not(Content.BOF Or Content.EOF) Response.Write("if(SyohinCD == """ & Content.Fields("商品CD") & """)return """ & Content.Fields("標準販売単価") & """;" & vbCrLf) Content.MoveNext Loop %> return ""; } //################################################ // 名称:ConvSyohinZaiko // 目的:商品在庫数リストの表示 // 作成:2002/8/26 川崎 // 概要:指定日時の商品在庫数を返す。 //################################################ function ConvSyohinZaiko(SyohinCD) { <% Query = "exec SPR入出庫在庫 '" & GB_SystemCD & "','" & EnshuCD & "','" & KaisyaCD & "','" & GB_KaikeiSyuryobi & "'" Set Content = OpenQuery(Query) Do While Not(Content.BOF Or Content.EOF) Response.Write("if(SyohinCD == """ & Content.Fields("商品CD") & """)return """ & Content.Fields("在庫数") & """;" & vbCrLf) Content.MoveNext Loop %> if(SyohinCD != "")return "0"; return ""; } //寄託倉庫を利用する設定で使用するスクリプトを作成 <% If Kitakuriyou = 1 Then %> //################################################ // 名称:SetSenpoKitakuGaisya // 目的:先方寄託倉庫会社をセットする。 // 作成:2006/12/10 鈴木 //################################################ function SetSenpoKitakuGaisya() { form1.SenpoKitakuGaisyaCD.value = ConvKitakuGaisya(document.form1.TorihikisakiCD.value); form1.SenpoKitakuGaisyaMei.value = ConvKaisyaMei(ConvKitakuGaisya(document.form1.TorihikisakiCD.value)); } //################################################ // 名称:ConvKitakuGaisya // 目的:寄託倉庫会社表示 // 作成:2006/12/10 鈴木 // 概要:TDA会社Mの寄託会社CDを返す //################################################ function ConvKitakuGaisya(KaisyaCD) { <% Query = "exec SPM会社一覧 '" & GB_SystemCD & "','" & EnshuCD & "', '1'" Set Content = OpenQuery(Query) Do While Not(Content.BOF Or Content.EOF) Response.Write("if(KaisyaCD == """ & Content.Fields("会社CD") & """)return """ & Content.Fields("寄託会社CD") & """;" & vbCrLf) Content.MoveNext Loop %> return ""; } //################################################ // 名称:ConvKaisyaMei // 目的:会社名表示 // 作成:2006/12/10 鈴木 // 概要:TDA会社Mの会社名称を返す //################################################ function ConvKaisyaMei(KaisyaCD) { <% Query = "exec SPM会社一覧 '" & GB_SystemCD & "','" & EnshuCD & "', '1'" Set Content = OpenQuery(Query) Do While Not(Content.BOF Or Content.EOF) Response.Write("if(KaisyaCD == """ & Content.Fields("会社CD") & """)return """ & Content.Fields("会社名称") & """;" & vbCrLf) Content.MoveNext Loop %> return ""; } <% End If %> //寄託利用スクリプトここまで </SCRIPT> <% = HtmlFooter %> <SCRIPT FOR="window" EVENT="onload" LANGUAGE="JavaScript"> <% If YukoFlg <> 1 Then %> form1.Syoribi.select; form1.Syoribi.focus(); form1.Syoribi.select(); event.returnValue = false; return; <% End If %> </SCRIPT> </html> <% End Sub %>