⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 search_ruku.asp

📁 oracle9i程序事例集
💻 ASP
字号:
<%@LANGUAGE="VBSCRIPT"%>
<!-- #include file="../common/conn.asp" -->
<!-- #include file="../common/status.html" -->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>查询入库信息</title>
<% if session("admin_id")="" then %>
  您还没有登录或者您的权限不够,五秒钟后自动返回登录,如果您的浏览器没有自动返回,请<a href="../admin/login.html">点击登录</a>。
  <meta http-equiv="refresh" content="5;url=login.html">
<% else %>
</head>

<body background="../img/searchBG.gif">
<div align="center">
<center>
<%
    dim rs,sql
	
	set rs=server.createobject("adodb.recordset")

%>

<form action="search_ruku_result.asp" method="post" name="myform" id="myform">
<table width="700" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td height="25" colspan="4">请选择查询入库信息的方式:</td>
    </tr>
  <tr>
    <td height="25" width="17%">&nbsp;</td>
    <td width="28%"><input name="type" type="radio" value="inpid" checked>
      按照入库产品型号查询</td>
    <td width="30%" align="center"><select name="inpid" id="inpid">
      <%  
        sql="select distinct sm_inpid from scott.stock_management where sm_inpid<>' ' "
        rs.open sql,connstr,1,1
		do while not rs.eof
	  %>
      <option value="<%=rs("sm_inpid")%>"><%=rs("sm_inpid")%></option>
      <%
	    rs.movenext
		loop
		rs.close
	  %>
    </select></td>
    <td width="25%">&nbsp;</td>
    </tr>
  <tr>
    <td height="25">&nbsp;</td>
    <td><input name="type" type="radio" value="handle">
按照经手人查询 </td>
    <td align="center"><select name="handle" id="handle">
      <%  
        sql="select distinct sm_handle from scott.stock_management where sm_inpid<>' ' "
        rs.open sql,connstr,1,1
		do while not rs.eof
	  %>
      <option value="<%=rs("sm_handle")%>"><%=rs("sm_handle")%></option>
      <%
	    rs.movenext
		loop
		rs.close
	  %>
    </select></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td height="25">&nbsp;</td>
    <td><input name="type" type="radio" value="detail">      按照细节查询</td>
    <td align="left">	<div align="center">
      <select name="city" id="city">
        <option value="1">按照入库日期查询</option>
        <option value="2">按照入库类型查询</option>
      </select>
</div></td>
    <td align="left"><input name="detail1" type="text" id="detail1"></td>
  </tr>
  <tr>
    <td height="25">&nbsp;</td>
    <td>&nbsp;</td>
    <td align="center">&nbsp;</td>
    <td>&nbsp;</td>
    </tr>
  <tr>
    <td height="25">&nbsp;</td>
    <td>&nbsp;</td>
    <td align="center">&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td height="25">&nbsp;</td>
    <td colspan="2" align="center"><input type="submit" name="Submit" value="搜索"></td>
    <td align="right">&nbsp;</td>
    </tr>
  <tr>
    <td height="25">&nbsp;</td>
    <td colspan="2" align="center">&nbsp;</td>
    <td align="right"><a href="javascript:history.go(-1)">返回上一页</a></td>
  </tr>
</table>
</form>
</center>
</div>
<% set rs=nothing %>
</body>
<% end if %>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -