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

📄 update_corder_certain.asp

📁 oracle9i程序事例集
💻 ASP
字号:
<%@LANGUAGE="VBSCRIPT" %>
<html>
<%
  dim conn
  dim connstr
  Set conn=Server.CreateObject("ADODB.Recordset")
  connstr="Driver={Microsoft ODBC for Oracle};server=mylink;uid=system;pwd=system;"
%>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>修改公司订单表</title>
<style type="text/css">
<!--
.style1 {
	font-size: 24px;
	font-family: "黑体";
	font-weight: bold;
}
-->
</style>
<link href="../../MYDZSW/Css/bd_font_size.css" rel="stylesheet" type="text/css">
</head>

<body background="../img/updateBG.gif">
<%
  dim rs,sql
  set rs=server.CreateObject("adodb.recordset")
  sql="select * from GSCOTT.company_orderform_table where cof_id='"&request.QueryString("id")&"'"
  rs.open sql,connstr,3,3
%>
<div align="center">
<center>
<form action="update_corder_sav.asp?id=<%=request.querystring("id")%>" method="post">
<table width="528" height="550" border="0" cellpadding="0" cellspacing="0">
  <!--DWLayoutTable-->
  <tr>
    <td height="77" colspan="2" align="center" valign="middle"><span class="style1">请输入订单的修改信息</span></td>
    </tr>
  <tr>
    <td width="218" height="27" align="right" valign="middle" class="bd_font_size">订单ID:</td>
    <td width="310" align="center" valign="middle">
      <%=rs("cof_id")%>    </td>
    </tr>
  <tr>
    <td height="27" align="right" valign="middle" class="bd_font_size">订单公司名称:</td>
    <td valign="middle">&nbsp;<input name="companyname" type="text" id="companyname" maxlength="50" value="<%=rs("cof_companyname")%>">    </td>
  </tr>
  <tr>
    <td rowspan="2" valign="middle" class="bd_font_size"><div align="right"> 产品型号:</div></td>
    <td height="27" valign="middle">&nbsp;<input name="pid" type="text" id="pid" maxlength="5" value="<%=rs("cof_pid")%>">    </td>
    </tr>
  <tr>
    <td height="1"></td>
    </tr>
  <tr>
    <td height="27" valign="middle" class="bd_font_size"><div align="right">产品数量:</div></td>
    <td valign="middle">&nbsp;<input name="pnumber" type="text" id="pnumber" value="<%=rs("cof_number")%>" maxlength="4">    </td>
  </tr>
  <tr>
    <td height="27" valign="middle" class="bd_font_size"><div align="right"> 产品总价:</div></td>
    <td valign="middle">&nbsp;<input name="totalprice" type="text" id="totalprice" maxlength="13" value="<%=rs("cof_totalprice")%>"></td>
    </tr>
  <tr>
    <td height="27" valign="middle" class="bd_font_size"><div align="right">订单生成时间: </div></td>
    <td align="center" valign="middle"><%=rs("cof_datetime")%> </td>
  </tr>
  <tr>
    <td height="27" align="right" valign="middle" class="bd_font_size">付款方式:</td>
    <td valign="middle">&nbsp;<input name="paymethod" type="text" id="paymethod" maxlength="20" value="<%=rs("cof_paymethod")%>"></td>
    </tr>
  <tr>
    <td height="27" align="right" valign="middle" class="bd_font_size">收款方式:</td>
    <td valign="middle">&nbsp;<input name="sentmethod" type="text" id="sentmethod" maxlength="20" value="<%=rs("cof_sentmethod")%>"></td>
  </tr>
  <tr>
    <td height="27" valign="middle" class="bd_font_size"><div align="right">是否发货:  </div></td>
    <td valign="middle">&nbsp;<input name="consignment" type="text" id="consignment2" maxlength="5" value="<%=rs("cof_consignment")%>"></td>
    </tr>
  <tr>
    <td height="27" valign="middle" class="bd_font_size"><div align="right">是否会谈:</div></td>
    <td valign="middle">&nbsp;<input name="conversation" type="text" id="conversation" maxlength="5" value="<%=rs("cof_conversation")%>"></td>
  </tr>
  <tr>
    <td height="146" valign="top" class="bd_font_size"><div align="right">备注(可不填):</div></td>
    <td valign="top">&nbsp;<textarea name="Remark" cols="40" rows="10" id="Remark"><%=rs("cof_remark")%></textarea></td>
  </tr>
  <tr>
    <td height="27" 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 class="bd_font_size">
    <td height="29" colspan="2" align="right" valign="middle"><a href="javascript:history.go(-1)">返回上一页</a></td>
    </tr>
</table>
</form>
</center>
</div>
</body>
</html>

⌨️ 快捷键说明

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