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

📄 update_chuku_certain.asp

📁 oracle9i程序事例集
💻 ASP
字号:
<%@LANGUAGE="VBSCRIPT" %>
<!--#include file="../common/status.html"-->
<!--#include file="../common/conn.asp"-->
<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/updateBG.gif">
<%
  dim rs,sql
  set rs=server.CreateObject("adodb.recordset")
  sql="select * from scott.stock_management where sm_id='"&request.QueryString("id")&"'"
  rs.open sql,connstr,3,3
%>
<div align="center">
<center>
<form action="update_chuku_sav.asp?id=<%=request.querystring("id")%>" method="post">
<table width="700"  border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td height="30" colspan="2">请输入出库清单修改信息:</td>
    <td width="20%" align="right">&nbsp;</td>
    <td width="40%">&nbsp;</td>
  </tr>
  <tr>
    <td width="20%" height="30" align="right">出库产品型号:</td>
    <td width="20%" height="30">
	<select name="outPID" id="outPID">
        <%  
        sql="select distinct product_num from scott.product_info"
        set rs1=server.CreateObject("adodb.recordset")
		rs1.open sql,connstr,1,1
		do while not rs1.eof
	  %>
        <option value="<%=rs1("product_num")%>"><%=rs1("product_num")%></option>
        <%
	    rs1.movenext
		loop
		rs1.close
	  %>
      </select></td>
    <td align="right">销售项号:</td>
    <td><input name="salenum" type="text" id="salenum" maxlength="10" value="<%=rs("sm_salenum")%>">    </td>
  </tr>
  <tr>
    <td height="30"><div align="right"> 出库地点:</div></td>
    <td height="30"><input name="Place" type="text" id="Place" maxlength="20" value="<%=rs("sm_outplace")%>">    </td>
    <td><div align="right">出库日期:</div></td>
    <td><input name="Date" type="text" id="Date" value="<%=rs("sm_outdate")%>" maxlength="20">    </td>
  </tr>
  <tr>
    <td height="30"><div align="right"> 出库数量:</div></td>
    <td height="30"><input name="Num" type="text" id="Num" maxlength="5" value="<%=rs("sm_outnum")%>"></td>
    <td><div align="right"> 出库单价:</div></td>
    <td><input name="Price" type="text" id="Price" maxlength="8" value="<%=rs("sm_outprice")%>">    </td>
  </tr>
  <tr>
    <td height="30"><div align="right"> 经手人:</div></td>
    <td height="30"><input name="Handle" type="text" id="Handle" maxlength="10" value="<%=rs("sm_handle")%>">    </td>
    <td><div align="right">是否欠款: </div></td>
    <td><%=rs("sm_arrearage")%>
	<% if rs("sm_arrearage")="是" then %>
	 <a href="qiankuan_certain.asp?id=<%=rs("sm_id")%>">欠款核销</a>
	<% end if %>
	</td>
  </tr>
  <tr>
    <td height="30" align="right">欠款数量:</td>
    <td height="30"><input name="owenum" type="text" id="owenum" value="<%=rs("sm_num")%>" maxlength="13"></td>
    <td align="right">信用时间:</td>
    <td><input name="ctime" type="text" id="ctime" value="<%=rs("sm_credittime")%>" size="5" maxlength="10">
      天</td>
  </tr>
  <tr>
    <td><div align="right">备注(可不填):</div></td>
    <td colspan="3"><textarea name="Remark" cols="60" rows="10" id="Remark"><%=rs("sm_remark")%></textarea></td>
  </tr>
  <tr align="center">
    <td height="30" colspan="4"><input type="submit" name="Submit" value="确定">
      &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
      <input name="Reset" type="reset" id="Reset2" value="重置"></td>
  </tr>
  <tr align="right">
    <td height="20" colspan="4"><a href="javascript:history.go(-1)">返回上一页</a></td>
    </tr>
</table>
</form>
</center>
</div>
</body>
<% end if %>
</html>

⌨️ 快捷键说明

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