order_info.asp

oa办公系统asp程序

<!--#include file="../title.asp" -->
<p align="center"><font face="Arial Black" 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="141" height="524">
        <TR>
             <TD WIDTH="104" height="25"><b>REF NO:</b></td>
        <TD WIDTH="64" height="25"><%=rs("ref_no")%>　</TD>
        </TR>
            <TR>
             <TD WIDTH="104" height="19">BUYER:</td>
        <TD WIDTH="64" 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="64" 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="64" 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="64" 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="64" height="19">
        <input type="text" name="merchand" size="8" value="<%=rs("merchandiser")%>"></TD>
        </TR>
            <TR>
             <TD WIDTH="104" height="21">SKETCH:</td>
        <TD WIDTH="64" height="21">　</TD>
        </TR>
            <TR>
             <TD  colspan="2" height="169" WIDTH="169"></td>
        </TR>
            <TR>
             <TD WIDTH="104" height="26"><b>DOCUMENT:</b></td>
        <TD WIDTH="64" height="26">DATE</TD>
        </TR>
            <TR>
             <TD WIDTH="104" height="19">1>M/O</td>
        <TD WIDTH="64" 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="64" 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="64" 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="64" 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="64" 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="64" 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="64" 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="64" 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="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">
        <TR align="center"><TD colspan="7" 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" ></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>
	 <td height="16"></td>
    </TR>
    <TR>
      <TD colspan="7" 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"><input type="text" name="color_1" size="6" value="<%=rs2("color")%>"></td>
	 <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="checkbox" name="finish_1" <%if rs2("finish")=true then %>checked<%end if%> value="ON"></td>
	 <td height="19"><input type="text" name="thread_1" size="6" value="<%=rs2("thread")%>"></td>
    </TR>
    <%
    rs2.movenext
    x=x+1
    loop
    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="checkbox" name="finish_1" value="ON"></td>
	 <td height="19"><input type="text" name="thread_1" size="6"></td>
    </TR>
	<%
	y=y-1
	loop
	%>
    <TR>
      <TD colspan="7" 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="checkbox" name="finish" value="ON"></td>
	 <td height="20"><input type="text" name="thread" size="6"></td>
    </TR>
    <%
    rs5.movenext
    x=x+1
    loop
    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="checkbox" name="finish" value="ON"></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">
        <TR>
         <TD>
	  <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111"
           <tr>
	    <td colspan="3"><b>ACCESSORIES</B></td>
	    </tr>
	   <tr>
	    <td>ITEM</td>
            <td>YES</td>
            <td>ETD DATE</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 where ref_no = '"&rs("ref_no")&"' and access_id = "&rs4("id")&" "
rs6.open sql6,conn,3,1
if not rs6.eof then
%>
<td>
<%=rs4("name")%>　</td>
<td><input type="checkbox" name="yes" checked value="ON"></td>
<td><input type="text" name="thetd_date" size="6" value="<%=rs6("etd_date")%>"> </td>
<%
rs6.close
else
%>
<td>
<%=rs4("name")%>　</td>
<td><input type="checkbox" name="yes" value="ON"></td>
<td><input type="text" name="thetd_date" size="6"> </td>
<%
rs6.close
end if
%>
</tr>
<%
rs4.movenext
loop
rs4.close
%>
	  </table>
	</td>
        </TR>
       </TABLE>
      </TD>
     </TR>
    </TABLE>
    </td>
  </tr>
</table>
</center>

<!--#include file="../copyright.asp" -->