edit_access.asp

oa办公系统asp程序

<!--#include file="../title.asp"-->
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111"  id="AutoNumber1">
  <tr><td>
    <p align="center">威康纺织成衣辅料订单</td></tr>
  <tr>
    <td height="88" valign="top">
<%
ref=request("ref")
sql="select * from cloth_access_2 where ref_no = '"&ref&"' "
rs.open sql,conn,1,3
%>
    <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" id="AutoNumber2">
      <tr>
        <td align="center">Ref NO</td>
        <td align="center">Item</td>
        <td align="center">Name</td>
        <td align="center">Size</td>
        <td align="center">Color</td>
        <td align="center">Quantity</td>
        <td align="center">Destination</td>
        <td align="center">Unit Price</td>
        <td align="center">Etd_date</td>
        <td align="center">Meno</td>
        <td align="center"><a href="access.asp?ref=<%=ref%>">添加</a></td>
      </tr>
<%
do while not rs.eof
%>
      <tr>
        <td><input type="text" name="T1" size="8" value="<%=rs("ref_no")%>"></td>
   		<td>
   		<%
   		sql2="select * from accessories where id = "&rs("access_id")&" "
   		rs2.open sql2,conn,1,3
   		if not rs2.eof then
   		%>
        <input type="text" name="T1" size="8" value="<%=rs2("name")%>">
        <%
        end if
        rs2.close
        %>
        </td>
        <td><input type="text" name="T1" size="8" value="<%=rs("name")%>"></td>
        <td><input type="text" name="T1" size="8" value="<%=rs("size")%>"></td>
        <td><input type="text" name="T1" size="8" value="<%=rs("color")%>"></td>
        <td><input type="text" name="T1" size="8" value="<%=rs("quantity")%>"></td>
        <td>
        <input type="text" name="T1" size="8" value="<%=rs("destination")%>"></td>
        <td><input type="text" name="T1" size="6" value="<%=rs("unit_p")%>"></td>
        <td><input type="text" name="T1" size="8" value="<%=rs("Etd_date")%>"></td>
        <td><input type="text" name="T2" size="8" value="<%=rs("meno")%>"></td>
        <td>&nbsp;<a href="access_edit.asp?id=<%=rs("id")%>&types=edit" >修改</a>
        <a href="access_edit.asp?id=<%=rs("id")%>&types=del">删除</a> </td>
      </tr>
<%
rs.movenext
loop
%>
   
    </table>
 </td>
  </tr>
</table>