access_input.asp

oa办公系统asp程序

<!--#include file="../title.asp"-->
<meta http-equiv="Content-Language" content="en-us">
<%
dim id,ref_no,name
access_id=cint(request("access_id"))
ref_no=request("ref_no")

%>
    <form method="POST" action="rs_access.asp?access_id=<%=access_id%>">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
  <tr>
    <td width="100%" align="center"><b><font size="5">PURCHASE ORDER<br>
	</font></b>
	<%
	sql="select * from accessories where id = "&access_id&" "
	rs.open sql,conn,3,1
	response.write rs("name")
	%>
	<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111"  id="AutoNumber2" height="119" width="471">
      <tr>
        <td width=70 height="21">
    <span lang="zh-cn">REF NO：</span></td>
        <td width=163 height="21">
        <input type="text" name="ref_no" size="20" tabindex="1" value="<%=ref_no%>"></td>
        <td width=60 height="21">Etd_Date</td>
        <td width=150 height="21">
        <input type="text" name="etd_date" size="20" tabindex="8"></td>
      </tr>
      <tr>
        <td width=61 height="11">Name：</span></td>
        <td width=163 height="11">
        <input type="text" name="name" size="20" tabindex="2"></td>
        <td width=243 height="70" rowspan="6" colspan="2">
        <textarea rows="10" name="meno" cols="29" tabindex="9">备注</textarea></td>
      </tr>
      <tr>
        <td width=61 height="13">Size：</td>
        <td width=163 height="13">
        <input type="text" name="size" size="20" tabindex="3"></td>
      </tr>
      <tr>
        <td width=61 height="10">Color：</td>
        <td width=163 height="10">
        <select size="1" name="color" tabindex="4">
        <%
         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>
      </tr>
      <tr>
        <td width=61 height="14">Quantity：</td>
        <td width=163 height="14">
        <input type="text" name="quantity" size="20" tabindex="5"></td>
      </tr>
      <tr>
        <td width=61 height="8">Destination：</td>
        <td width=163 height="8">
        <input type="text" name="T6" size="20" tabindex="6"></td>
      </tr>
      <tr>
        <td width=61 height="14">Unit Price：</td>
        <td width=163 height="14">
        <input type="text" name="unit_p" size="20" tabindex="7"></td>
      </tr>
      <tr>
        <td width="469" colspan="4" height="21">
        <p align="center">
        <input type="submit" value="Submit" name="B1" tabindex="10"><input type="reset" value="Reset" name="B2" tabindex="11"></td>
      </tr>
    </table>
</td>
  </tr>
</table>
   </form>