?? seach_info.asp
字號:
<!--#include file="../title.asp" -->
<p align=left>
<a href=#list>Fabric & Accessories List<a><br>
<a href=#cost1>成本分析表</a><br>
<a href=#cost2>實際成本表</a><br>
<a name="List">
<p align="center"><font face="Arial Black" color="#ffffff" size="5"><b>FABRIC & ACCESSORIES LIST</b></font></p>
<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="159" height="524">
<TR>
<TD WIDTH="104" height="25"><b>REF NO:</b></td>
<TD WIDTH="82" height="25"><%=rs("ref_no")%> </TD>
</TR>
<TR>
<TD WIDTH="104" height="19">BUYER:</td>
<TD WIDTH="82" height="19">
<input type="text" name="buyer" size="8" value="<%=rs("buyer")%>"></TD>
</TR>
<TR>
<TD WIDTH="104" height="19">STYLE NO:</td>
<TD WIDTH="82" height="19">
<input type="text" name="style_no" size="8" value="<%=rs("style_no")%>"></TD>
</TR>
<TR>
<TD WIDTH="104" height="19">PATTERN:</td>
<TD WIDTH="82" height="19">
<input type="text" name="pattern" size="8" value="<%=rs("pattern")%>"></TD>
</TR>
<TR>
<TD WIDTH="104" height="19">ORDER QTY:</td>
<TD WIDTH="82" height="19">
<input type="text" name="order_qty" size="8" value="<%=rs("order_qty")%>"></TD>
</TR>
<TR>
<TD WIDTH="104" height="19">MERCHANDISER:</td>
<TD WIDTH="82" height="19">
<input type="text" name="merchand" size="8" value="<%=rs("merchandiser")%>"></TD>
</TR>
<TR>
<TD WIDTH="104" height="21">SKETCH:</td>
<TD WIDTH="82" height="21"> </TD>
</TR>
<TR>
<TD colspan="2" height="169" WIDTH="187"></td>
</TR>
<TR>
<TD WIDTH="104" height="26"><b>DOCUMENT:</b></td>
<TD WIDTH="82" height="26">DATE</TD>
</TR>
<TR>
<TD WIDTH="104" height="19">1>M/O</td>
<TD WIDTH="82" height="19">
<input type="text" name="mo" size="8" value="<%=rs("mo")%>"></TD>
</TR>
<TR>
<TD WIDTH="104" height="19">2>BUYER P/O</td>
<TD WIDTH="82" height="19">
<input type="text" name="buyer_po" size="8" value="<%=rs("buyer_po")%>"></TD>
</TR>
<TR>
<TD WIDTH="104" height="19">3>FABRIC P/O</td>
<TD WIDTH="82" height="19">
<input type="text" name="fabric_po" size="8" value="<%=rs("fabric_po")%>"></TD>
</TR>
<TR>
<TD WIDTH="104" height="19">4>THREAD P/O</td>
<TD WIDTH="82" height="19">
<input type="text" name="thread_po" size="8" value="<%=rs("thread_po")%>"></TD>
</TR>
<TR>
<TD WIDTH="104" height="19">5>L/C</td>
<TD WIDTH="82" height="19">
<input type="text" name="lc" size="8" value="<%=rs("lc")%>"></TD>
</TR>
<TR>
<TD WIDTH="104" height="19">6>CLR SWATCH</td>
<TD WIDTH="82" height="19">
<input type="text" name="clr_swatch" size="8" value="<%=rs("clr_swatch")%>"></TD>
</TR>
<TR>
<TD WIDTH="104" height="19">7>PATTN PAPER</td>
<TD WIDTH="82" height="19">
<input type="text" name="pattn_paper" size="8" value="<%=rs("pattn_paper")%>"></TD>
</TR>
<TR>
<TD WIDTH="104" height="19">8>APPV SAMPLE</td>
<TD WIDTH="82" height="19">
<input type="text" name="appv_sample" size="8" value="<%=rs("appv_sample")%>"></TD>
</TR>
<TR>
<TD WIDTH="104" height="19">9>SHPT SAMPLE</td>
<TD WIDTH="82" 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">
<TR align="center"><TD colspan="6" height="16"><b>FABRIC COLOR BREAKDOWN</b></TD></TD>
<TR align="center">
<TD height="16">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">(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="fabric1" size="52" value="<%=rs2("fabrication")%>">
<%end if%>
</TD>
</TR>
<%
x=0
do while not rs2.eof
%>
<TR>
<TD height="19">
<%
sql6="select * from fabric_color where id = "&rs2("color")&" "
rs6.open sql6,conn,3,1
%>
<input type="text" name="color_1" size="6" value="<%=rs6("en_name")%>"></td>
<%rs6.close%>
<td height="19"><input type="text" name="order_kg_1" size="4" value="<%=rs2("order_kg")%>"><input type="text" name="order_yd_1" size="4" value="<%=rs2("order_yd")%>"></td>
<td height="19"><input type="text" name="malaysia_kg_1" size="4" value="<%=rs2("malaysia_kg")%>"><input type="text" name="malaysia_yd_1" size="4" value="<%=rs2("malaysia_yd")%>"></td>
<td height="19"><input type="text" name="shanghai_kg_1" size="4" value="<%=rs2("shanghai_kg")%>"><input type="text" name="shanghai_yd_1" size="4" value="<%=rs2("shanghai_yd")%>"></td>
<td height="19"><input type="text" name="etd_date_1" size="6" value="<%=rs2("etd_date")%>"></td>
<td height="19"><input type="text" name="thread_1" size="6" value="<%=rs2("thread")%>"></td>
</TR>
<%
rs2.movenext
x=x+1
loop
rs2.close
y=10-x
do while y>0
%>
<TR>
<TD height="19"><input type="text" name="color_1" size="6"></td>
<td height="19"><input type="text" name="order_kg_1" size="4"><input type="text" name="order_yd_1" size="4"></td>
<td height="19"><input type="text" name="malaysia_kg_1" size="4"><input type="text" name="malaysia_yd_1" size="4"></td>
<td height="19"><input type="text" name="shanghai_kg_1" size="4"><input type="text" name="shanghai_yd_1" size="4"></td>
<td height="19"><input type="text" name="etd_date_1" size="6"></td>
<td height="19"><input type="text" name="thread_1" size="6"></td>
</TR>
<%
y=y-1
loop
%>
<TR>
<TD colspan="6" height="19">
<input type="text" name="fabric1" size="52" <%if not rs5.eof then%> value="<%=rs5("fabrication")%>" <%end if%>>
</TD>
</tr>
<%
x=0
do while not rs5.eof
%>
<TR>
<TD height="20"><input type="text" name="color" size="6"></td>
<td height="20"><input type="text" name="order" size="4"><input type="text" name="order_yd_2" size="4"></td>
<td height="20"><input type="text" name="malaysia_kg" size="4"><input type="text" name="malaysia_yd" size="4"></td>
<td height="20"><input type="text" name="shanghai_kg" size="4"><input type="text" name="shanghai_yd" size="4"></td>
<td height="20"><input type="text" name="etd_date" size="6"></td>
<td height="20"><input type="text" name="thread" size="6"></td>
</TR>
<%
rs5.movenext
x=x+1
loop
rs5.close
y=10-x
do while y>0
%>
<TR>
<TD height="20"><input type="text" name="color" size="6"></td>
<td height="20"><input type="text" name="order" size="4"><input type="text" name="order_yd_2" size="4"></td>
<td height="20"><input type="text" name="malaysia_kg" size="4"><input type="text" name="malaysia_yd" size="4"></td>
<td height="20"><input type="text" name="shanghai_kg" size="4"><input type="text" name="shanghai_yd" size="4"></td>
<td height="20"><input type="text" name="etd_date" size="6"></td>
<td height="20"><input type="text" name="thread" size="6"></td>
</TR>
<%
y=y-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" height="56">
<TR>
<TD height="56">
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111"
<tr height="56">
<td colspan="3" 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
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="23"><a href="show_access.asp?ref=<%=rs6("ref_no")%>&access_id=<%=rs6("access_id")%>">
<%=rs4("name")%></a> </td>
<td height="23"><input type="checkbox" name="yes" checked value="ON"></td>
<%
rs6.close
else
%>
<td height="23">
<%=rs4("name")%> </td>
<td height="23"><input type="checkbox" name="yes" value="ON"></td>
<%
rs6.close
end if
%>
</tr>
<%
rs4.movenext
loop
rs4.close
%>
</table>
</td>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</td>
</tr>
</table>
<p align=right>
<a href=#top>Back</a>
<a name="cost1">
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -