index.asp

oa办公系统asp程序

<!--#include file="../title.asp" -->
<meta http-equiv="Content-Language" content="en-us">
<%
sql="select * from cloth_info where knit_paiqi = 1"
rs.open sql,conn,1,3
do while not rs.eof
%>
<p>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111"  height="33" width="650">
    <tr><td><P align="center">威 康 纺 织 工 业 有 限 公 司<br><br>未排期订单列表</td></tr>
  <tr>
  <td width="651">
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111"  height="33" width="660" >
  <tr align=center>
    <td width="75">REF NO</td>
    <td width="75">BUYER</td>
    <td width="76">PATTERN</td>
    <td width="75">ORDER QTY</td>
    <td width="122">MERCHANDISER</td>
    <td width="100">BUYER P/O</td>
    <td width="100">FABRIC P/O</td>
    <td width="60">THREAD P/O</td>
  </tr>
  <tr>
    <td width="75"><INPUT size="10" name="ref_no" value="<%=rs("ref_no")%>"></td>
    <td width="75"><INPUT size="10" name="buyer" value="<%=rs("buyer")%>"></td>
    <td width="76"><INPUT size="10" name="pattern" value="<%=rs("pattern")%>"></td>
    <td width="75"><INPUT size="10" name="order_qty" value="<%=rs("order_qty")%>"></td>
    <td width="122"><INPUT size="10" name="merchandiser" value="<%=rs("merchandiser")%>"></td>
    <td width="100"><INPUT size="10" name="buyer_po" value="<%=rs("buyer_po")%>"></td>
    <td width="100"><INPUT size="10" name="fabric_po" value="<%=rs("fabric_po")%>"></td>
    <td width="60"><INPUT size="10" name="thread_po" value="<%=rs("thread_po")%>"></td>
  </tr>
    <tr align=center>
    <td width="301" colspan="4">FABRIC</td>
    <td width="122">COLOR</td>
    <td width="100">ORDER QTU</td>
    <td width="100">D/O QTY</td>
    <td width="60">ETD DATE</td>
  </tr>
  <%
  sql2="select * from cloth_fabric where ref_no = '"&rs("ref_no")&"' "
  rs2.open sql2,conn,1,3
  do while not rs2.eof
  %>
  <tr>
    <td width="301" colspan="4"><INPUT size="45" name="fabric" value="<%=rs2("fabrication")%>"></td>
    <td width="122">
    <%
    sql3="select * from fabric_color where id = "&rs2("color")&" "
    rs3.open sql3,conn,1,3
    if not rs3.eof then
    %><INPUT size="10" name="color" value="<%=rs3("en_name")%>">
    <%
    end if
    rs3.close
    %></td>
    <td><INPUT size="5" name="order_kgs" value="<%=rs2("order_kg")%>"><INPUT size="5" name="order_yds" value="<%=rs2("order_yd")%>"></td>
    <td><INPUT size="5" name="d_o_kgs" value="<%=rs2("shanghai_kg")%>"><INPUT size="5" name="d_o_kgs" value="<%=rs2("shanghai_yd")%>"></td>
    <td width="60"><INPUT size="10" name="Etd_date" value="<%=rs2("etd_date")%>" ></td>
  </tr>
  <%
  rs2.movenext
  loop
  rs2.close
  %>
  </table>
  <tr><td><P align="center"><span lang="zh-cn"><br>
    进入排期</span></td></tr>
  </td>

</tr>
</table>
<%
rs.movenext
loop
rs.close
%>