<!-- #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 %>
//** ２．運送会社のチェック
if(typeof(form1.UnsoGaisyaCD) == "object")
{
if(form1.UnsoGaisyaCD.value == "")
{
alert("運送会社を入力して下さい");
form1.UnsoGaisyaCD.focus();
return false;
}
}
//** ３．明細部のチェック
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
}
}
//** ３．明細部に入力が有るかどうかのチェック
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
%>