📄 order_edit.asp
字号:
<!--#include file="../title.asp" -->
<p align="center"><font face="Arial Black" size="5"><b>FABRIC & ACCESSORIES LIST</b></font></p>
<form method="POST" action="rs_edit_input.asp">
<table table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" >
<tr>
<td>
<table table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111">
<tr>
<td>
<%
id=request("id")
sql="select * from cloth_info where id="&id&" "
rs.open sql,conn,3,1
sql2="select * from cloth_fabric where ref_no = '"&rs("ref_no")&"' and first = true"
rs2.open sql2,conn,1,1
sql5="select * from cloth_fabric where ref_no = '"&rs("ref_no")&"' and first=false"
rs5.open sql5,conn,3,1
%>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="141" height="524">
<TR>
<TD height="25"><b>REF NO:</b></td>
<TD WIDTH="64" height="25"><input type="text" name="ref" size="8" value="<%=rs("ref_no")%>"></TD>
</TR>
<TR>
<TD height="19">BUYER:</td>
<TD WIDTH="64" height="19">
<input type="text" name="buyer" size="8" value="<%=rs("buyer")%>"></TD>
</TR>
<TR>
<TD height="19">STYLE NO:</td>
<TD WIDTH="64" height="19">
<input type="text" name="style_no" size="8" value="<%=rs("style_no")%>"></TD>
</TR>
<TR>
<TD height="19">PATTERN:</td>
<TD WIDTH="64" height="19">
<input type="text" name="pattern" size="8" value="<%=rs("pattern")%>"></TD>
</TR>
<TR>
<TD height="19">ORDER QTY:</td>
<TD WIDTH="64" height="19">
<input type="text" name="order_qty" size="8" value="<%=rs("order_qty")%>"></TD>
</TR>
<TR>
<TD height="19">MERCHANDISER:</td>
<TD WIDTH="64" height="19">
<input type="text" name="merchand" size="8" value="<%=rs("merchandiser")%>"></TD>
</TR>
<TR>
<TD WIDTH="104" height="21">SKETCH:</td>
<TD height="21"> </TD>
</TR>
<TR>
<TD colspan="2" height="169" WIDTH="169"></td>
</TR>
<TR>
<TD height="26"><b>DOCUMENT:</b></td>
<TD height="26">DATE</TD>
</TR>
<TR>
<TD height="19">1>M/O</td>
<TD height="19">
<input type="text" name="mo" size="8" value="<%=rs("mo")%>"></TD>
</TR>
<TR>
<TD height="19">2>BUYER P/O</td>
<TD WIDTH="64" height="19">
<input type="text" name="buyer_po" size="8" value="<%=rs("buyer_po")%>"></TD>
</TR>
<TR>
<TD height="19">3>FABRIC P/O</td>
<TD height="19">
<input type="text" name="fabric_po" size="8" value="<%=rs("fabric_po")%>"></TD>
</TR>
<TR>
<TD height="19">4>THREAD P/O</td>
<TD WIDTH="64" height="19">
<input type="text" name="thread_po" size="8" value="<%=rs("thread_po")%>"></TD>
</TR>
<TR>
<TD height="19">5>L/C</td>
<TD WIDTH="64" height="19">
<input type="text" name="lc" size="8" value="<%=rs("lc")%>"></TD>
</TR>
<TR>
<TD height="19">6>CLR SWATCH</td>
<TD WIDTH="64" height="19">
<input type="text" name="clr_swatch" size="8" value="<%=rs("clr_swatch")%>"></TD>
</TR>
<TR>
<TD height="19">7>PATTN PAPER</td>
<TD WIDTH="64" height="19">
<input type="text" name="pattn_paper" size="8" value="<%=rs("pattn_paper")%>"></TD>
</TR>
<TR>
<TD height="19">8>APPV SAMPLE</td>
<TD height="19">
<input type="text" name="appv_sample" size="8" value="<%=rs("appv_sample")%>"></TD>
</TR>
<TR>
<TD height="19">9>SHPT SAMPLE</td>
<TD WIDTH="64" height="19">
<input type="text" name="shpt_sample" size="8" value="<%=rs("shpt_sample")%>"></TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</td>
<td>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111">
<tr>
<td>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111">
<TR>
<TD>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" height="131" width="490">
<TR align="center"><TD colspan="6" height="16" width="498"><b>FABRIC COLOR BREAKDOWN</b></TD></TD>
<TR align="center">
<TD height="16" width="128">COLOR</td>
<td height="16">ORDER(KGS)</td>
<td colspan="2" height="16">D/O QTY(KGS)</td>
<td height="16">ETD Date</td>
<td height="16">THREAD</td>
</TR>
<TR align="center">
<TD height="16" width="128">(PRINT #)</TD>
<td height="16">KG/YD</td>
<td height="16">MALAYSIA</td>
<td height="16">SHANGHAI</td>
<td height="16"></td>
<td height="16"></td>
</TR>
<TR>
<TD colspan="6" height="19">
<%if not rs2.eof then%>
<input type="text" name="fabric_1" size="64" value="<%=rs2("fabrication")%>">
<%end if%>
</TD>
</TR>
<%
x=1
do while not rs2.eof
%>
<TR>
<TD height="19" width="128">
<select size="1" name="color_1_<%=x%>" >
<%
sql3="select * from fabric_color"
rs3.open sql3,conn,3,1
do while not rs3.eof
%>
<option value="<%=rs3("id")%>" <%if rs3("id")=rs2("color") then%>Selected<%end if%>><%=rs3("en_name")%></option>
<%
rs3.movenext
loop
rs3.close
%>
</select></td>
<td height="19">
<input type="text" name="order_kg_1_<%=x%>" size="4" value="<%=rs2("order_kg")%>"><input type="text" name="order_yd_1_<%=x%>" size="4" value="<%=rs2("order_yd")%>"></td>
<td height="19">
<input type="text" name="malaysia_kg_1_<%=x%>" size="4" value="<%=rs2("malaysia_kg")%>"><input type="text" name="malaysia_yd_1_<%=x%>" size="4" value="<%=rs2("malaysia_yd")%>"></td>
<td height="19">
<input type="text" name="shanghai_kg_1_<%=x%>" size="4" value="<%=rs2("shanghai_kg")%>"><input type="text" name="shanghai_yd_1_<%=x%>" size="4" value="<%=rs2("shanghai_yd")%>"></td>
<td height="19">
<input type="text" name="etd_date_1_<%=x%>" size="7" value="<%=rs2("etd_date")%>"></td>
<td height="19"><input type="text" name="thread_1_<%=x%>" size="6" value="<%=rs2("thread")%>"></td>
</TR>
<%
rs2.movenext
x=x+1
loop
i=x
y=11-x
do while y>0
%>
<TR>
<TD height="19" width="128">
<select size="1" name="color_1_<%=i%>">
<%
sql3="select * from fabric_color"
rs3.open sql3,conn,3,1
do while not rs3.eof
%>
<option value="<%=rs3("id")%>"><%=rs3("en_name")%></option>
<%
rs3.movenext
loop
rs3.close
%>
</select></td>
<td height="19">
<input type="text" name="order_kg_1_<%=i%>" size="4"><input type="text" name="order_yd_1_<%=i%>" size="4"></td>
<td height="19">
<input type="text" name="malaysia_kg_1_<%=i%>" size="4"><input type="text" name="malaysia_yd_1_<%=i%>" size="4"></td>
<td height="19">
<input type="text" name="shanghai_kg_1_<%=i%>" size="4"><input type="text" name="shanghai_yd_1_<%=i%>" size="4"></td>
<td height="19">
<input type="text" name="etd_date_1_<%=i%>" size="7"></td>
<td height="19"><input type="text" name="thread_1­_<%=i%>" size="6"></td>
</TR>
<%
y=y-1
i=i+1
loop
%>
<TR>
<TD colspan="6" height="19">
<input type="text" name="fabric_2" size="64" <%if not rs5.eof then%> value="<%=rs5("fabrication")%>" <%end if%>>
</TD>
</tr>
<%
x=1
do while not rs5.eof
%>
<TR>
<TD height="20">
<select size="1" name="color_1_<%=x%>">
<%
sql3="select * from fabric_color"
rs3.open sql3,conn,3,1
do while not rs3.eof
%>
<option value="<%=rs3("id")%>"><%=rs3("en_name")%></option>
<%
rs3.movenext
loop
rs3.close
%>
</select></td>
<td height="20">
<input type="text" name="order_2_<%=x%>" size="4"><input type="text" name="order_yd_2_<%=x%>" size="4"></td>
<td height="20">
<input type="text" name="malaysia_kg_2_<%=x%>" size="4"><input type="text" name="malaysia_yd_<%=x%>" size="4"></td>
<td height="20">
<input type="text" name="shanghai_kg_2_<%=x%>" size="4"><input type="text" name="shanghai_yd_<%=x%>" size="4"></td>
<td height="20">
<input type="text" name="etd_date_2_<%=x%>" size="7"></td>
<td height="20"><input type="text" name="thread_2_<%=x%>" size="6"></td>
</TR>
<%
rs5.movenext
x=x+1
loop
i=x
y=11-x
do while y>0
%>
<TR>
<TD height="20" width="128"><select size="1" name="D4">
<%
sql3="select * from fabric_color"
rs3.open sql3,conn,3,1
do while not rs3.eof
%>
<option value="<%=rs3("id")%>"><%=rs3("en_name")%></option>
<%
rs3.movenext
loop
rs3.close
%>
</select></td>
<td height="20">
<input type="text" name="order_2_<%=i%>" size="4"><input type="text" name="order_yd_2_<%=i%>" size="4"></td>
<td height="20">
<input type="text" name="malaysia_kg_2_<%=i%>" size="4"><input type="text" name="malaysia_yd_2_<%=i%>" size="4"></td>
<td height="20">
<input type="text" name="shanghai_kg_2_<%=i%>" size="4"><input type="text" name="shanghai_yd_2_<%=i%>" size="4"></td>
<td height="20">
<input type="text" name="etd_date_2_<%=i%>" size="7"></td>
<td height="20"><input type="text" name="thread_2_<%=i%>" size="6"></td>
</TR>
<%
y=y-1
i=i+1
loop
%>
</TABLE>
</td>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</td>
<td>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111">
<tr>
<td>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111">
<TR>
<TD>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111"
<tr height="57">
<td colspan="2" height="16"><b>ACCESSORIES</B></td>
</tr>
<tr>
<td height="16">ITEM</td>
<td height="16">YES</td>
</tr>
<%
sql4="select * from accessories order by id"
rs4.open sql4,conn,3,1
x=1
do while not rs4.eof
%>
<tr>
<%
sql6="select * from cloth_access_2 where ref_no = '"&rs("ref_no")&"' and access_id = "&rs4("id")&" "
rs6.open sql6,conn,3,1
if not rs6.eof then
%>
<td height="24">
<%=rs4("name")%> </td>
<td height="24"><input type="checkbox" name="yes_<%=x%>" checked value="ON"></td>
<%
rs6.close
else
%>
<td height="24">
<%=rs4("name")%> </td>
<td height="24"><input type="checkbox" name="yes_<%=x%>" value="ON"></td>
<%
rs6.close
end if
%>
</tr>
<%
rs4.movenext
x=x+1
loop
rs4.close
%>
</table>
</td>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</td>
</tr>
</table>
<input type="submit" value="提交" name="B1"><input type="reset" value="重置" name="B2">
</form>
</center>
<!--#include file="../copyright.asp" -->⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -