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

📄 input_chuku.asp

📁 oracle9i程序事例集
💻 ASP
字号:
<%@LANGUAGE="VBSCRIPT" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>输入出库清单</title>
<% 
  dim conn
  dim connstr
  Set conn=Server.CreateObject("ADODB.Recordset")
  connstr="Driver={Microsoft ODBC for Oracle};server=mylink;uid=system;pwd=system;"



 %>
<style type="text/css">
<!--
.style1 {
	font-size: 24px;
	font-weight: bold;
	font-family: "黑体";
}
-->
</style>
<link href="../../Css/bd_font_size.css" rel="stylesheet" type="text/css">
</head>

<body background="../img/inputBG.gif">

<div align="center">
<center>
<form action="input_chuku_sav.asp" method="post">
<table width="544" height="650" border="0" cellpadding="0" cellspacing="0" >
  <!--DWLayoutTable-->
  <tr bgcolor="#FFFF00">
    <td height="77" colspan="2" align="center" valign="middle"><span class="style1">请输入出库清单信息</span></td>
    </tr>
  <tr>
    <td width="205" height="27" align="right" valign="middle" bgcolor="#FFFFC1" class="bd_font_size">出库产品型号:</td>
    <td width="339" align="left" valign="middle" bgcolor="#FFFFC1">
	   &nbsp;
	   <select name="outPID" id="outPID">
              <%  
        sql="select distinct product_kindnum from GSCOTT.product_info_table"
        set rs=server.CreateObject("adodb.recordset")
		rs.open sql,connstr,1,1
		do while not rs.eof
	  %>
              <option value="<%=rs("product_kindnum")%>"><%=rs("product_kindnum")%></option>
              <%
	    rs.movenext
		loop
		rs.close
	  %>
    </select></td>
    </tr>
  <tr>
    <td height="27" align="right" valign="middle" bgcolor="#FFFF66" class="bd_font_size"><div align="right"> 出库地点:</div></td>
    <td align="left" valign="middle" bgcolor="#FFFF66">
&nbsp;	<input name="Place" type="text" id="Place" maxlength="20">    </td>
    </tr>
  <tr>
    <td height="27" align="right" valign="middle" bgcolor="#FFFFC1" class="bd_font_size"><div align="right">出库日期:</div></td>
    <td valign="top" bgcolor="#FFFFC1">
	&nbsp;
	<input name="Date" type="text" id="Date" value="<%=date()%>" maxlength="20">    </td>
  </tr>
  <tr>
    <td height="27" align="right" valign="middle" bgcolor="#FFFF66" class="bd_font_size"><div align="right"> 出库数量:</div></td>
    <td align="left" valign="middle" bgcolor="#FFFF66">
&nbsp;	<input name="Num" type="text" id="Num" maxlength="5"></td>
    </tr>
  <tr>
    <td height="27" align="right" valign="middle" bgcolor="#FFFFC1" class="bd_font_size"><div align="right"> 出库单价:</div></td>
    <td align="left" valign="middle" bgcolor="#FFFFC1">
&nbsp;	<input name="Price" type="text" id="Price" maxlength="8">    </td>
  </tr>
  <tr>
    <td height="27" align="right" valign="middle" bgcolor="#FFFF66" class="bd_font_size"><div align="right"> 销售项号:</div></td>
    <td align="left" valign="middle" bgcolor="#FFFF66">
&nbsp;	<input name="SaleNum" type="text" id="SaleNum" maxlength="10">    </td>
    </tr>
  <tr>
    <td height="27" align="right" valign="middle" bgcolor="#FFFFC1" class="bd_font_size"><div align="right">经手人:</div></td>
    <td align="left" valign="middle" bgcolor="#FFFFC1">
	&nbsp;
	<input name="Handle" type="text" id="Handle" maxlength="10"></td>
  </tr>
  <tr>
    <td height="27" align="right" valign="middle" bgcolor="#FFFF66" class="bd_font_size"><div align="right">是否欠款:</div></td>
    <td align="left" valign="middle" bgcolor="#FFFF66" class="bd_font_size">
	&nbsp;
	<input name="Arrearage" type="radio" id="Arrearage" value="no" checked>
  否&nbsp;&nbsp;  <input name="Arrearage" type="radio" id="Arrearage" value="yes">
      是</td>
    </tr>
  <tr>
    <td height="27" align="right" valign="middle" bgcolor="#FFFFC1" class="bd_font_size"><div align="right">欠款数量:</div></td>
    <td align="left" valign="middle" bgcolor="#FFFFC1">
&nbsp;	<input name="oweNum" type="text" id="oweNum" maxlength="13"></td>
    </tr>
  <tr>
    <td height="27" align="right" valign="middle" bgcolor="#FFFF66" class="bd_font_size"><div align="right">信用时间:</div></td>
    <td align="left" valign="middle" bgcolor="#FFFF66" class="bd_font_size">
&nbsp;&nbsp;
<input name="CreditTime" type="text" id="CreditTime" maxlength="10">
    (单位:天)</td>
  </tr>
  <tr>
    <td height="146" valign="top" bgcolor="#FFFFC1" class="bd_font_size"><div align="right">备注:</div></td>
    <td valign="top" bgcolor="#FFFFC1">
	&nbsp;
	<textarea name="Remark" cols="43" rows="10" id="Remark"></textarea></td>
  </tr>
  <tr bgcolor="#FFFF66">
    <td height="57" colspan="2" align="center" valign="middle"><input type="submit" name="Submit" value="确定">
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
      <input name="Reset" type="reset" id="Reset2" value="重置"></td>
  </tr>
  <tr bgcolor="#FFFFC1" class="bd_font_size">
    <td height="57" colspan="2" align="right" valign="middle"><a href="javascript:history.go(-1)">返回上一页</a></td>
    </tr>
  <tr>
    <td height="134">&nbsp;</td>
    <td>&nbsp;</td>
    </tr>
</table>
</form>
</center>
</div>
</body>
</html>

⌨️ 快捷键说明

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