ask.asp

oa办公系统asp程序

<!--#include file="../title.asp" -->
        <form method="POST" action="--WEBBOT-SELF--">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
  <tr>
    <td width="100%" align="center">
    <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="350" id="AutoNumber2">
      <tr>
        <td width="37"><span lang="zh-cn">型号</span></td>
        <td width="263" colspan="3"><input type="text" name="xinhao" size="40"></td>
      </tr>
            <tr>
        <td width="37"><span lang="zh-cn">单位</span></td>

        <td width="263" colspan="3">
          <select size="1" name="provider">
        <%
        sql="select * from provider"
        rs.open sql,conn,1,3
        do while not rs.eof
        %>
          <option value="<%=rs("provider_id")%>"><%=rs("provider_name")%></option>
        <%
        rs.movenext
        loop
        rs.close
        %>
        </select>
　</td>
      </tr>
      <tr>
        <td width="37"><span lang="zh-cn">类别</span></td>
        <td width="113">
          <select size="1" name="accessories">
        <%
        sql="select * from accessories"
        rs.open sql,conn,1,3
        do while not rs.eof
        %>
          <option value="<%=rs("id")%>"><%=rs("name")%></option>
        <%
        rs.movenext
        loop
        rs.close
        %>
        </select></td>
        <td width="38"><span lang="zh-cn">规格</span></td>
        <td width="112"><input type="text" name="xinhao" size="18"></td>
      </tr>
      <tr>
        <td width="37"><span lang="zh-cn">尺寸</span></td>
        <td width="113"><input type="text" name="xinhao" size="18"></td>
        <td width="38"><span lang="zh-cn">尺寸</span></td>
        <td width="112"><input type="text" name="xinhao" size="18"></td>
      </tr>
      <tr>
        <td width="37"><span lang="zh-cn">单价</span></td>
        <td width="113"><input type="text" name="xinhao" size="18"></td>
        <td width="38">总价</td>
        <td width="112"><input type="text" name="xinhao" size="18"></td>
      </tr>
	  <tr><td colspan="4">
        <p align="center"><input type="submit" value="提交" name="B1"><input type="reset" value="重置" name="B2"></td></tr>
    </table>
    </td>
  </tr>
</table>
        </form>
<!--#include file="../copyright.asp" -->