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

📄 frm_psj_device_add_confirm.asp

📁 一套石油公司内部的运营管理系统
💻 ASP
字号:
<!--#include virtual="/include/DBCon.inc"-->
<%
tarea=request.form("tarea")
tzsz=request.form("tzsz")
psjId=request.form("psj")
text1=request.form("text1")
text2=request.form("text2")
text3=request.form("text3")
text4=request.form("text4")
text5=request.form("text5")
text6=request.form("text6")
text7=request.form("text7")
text8=request.form("text8")
text9=request.form("text9")
text10=request.form("text10")

'以下从数据库取出注水站
dim psj(1)
Set Rs = Server.CreateObject("ADODB.RecordSet")
SQL="select * from oil.oil_psj where psj_id='" &psjId& "'"
rs.open SQL,conn,1,1
if rs.eof and rs.bof then
	response.redirect "/profile/errorpage.asp?title=配水间&msg=数据库里没有配水间信息" 
else
	psj(0)=rs("psj_name") & "-" & rs("psj_id")
end if
%>
<html>
<head>
 
<title>油田采油工艺综合管理系统</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="/css/oil.css" type="text/css">
<SCRIPT LANGUAGE=javascript>
<!--
-->
</SCRIPT>

</head>

<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0"><br>
<form method=post name=form1>
<span class="subject">		
	配水间设备
</span> 
<hr size="1" class=hr width="98%" align="center">
<table width=80% border=0  cellspacing="0" cellpadding="0">
	<tr>
		<td align=left height=40>
		新数据成功添加
		</td>
	</tr>
</table>
<table border="1" cellpadding="1" cellspacing="0" align="center" class="table2" 
  bordercolor="#000000" bordercolordark="#F8EDEB" width="90%">
	  <tr height="20">
	   <td class="title" align=center colspan=2>配水间</td>
	   <td align=left width=70%>&nbsp&nbsp<%=split(psj(0),"-")(0)%></td>
	  </tr> 
	  <tr height="20">
	   <td class="title" align=center colspan=2>设备名称</td>
	   <td align=left width=70%>&nbsp&nbsp
		   <%=text1%>
	   </td>
	  </tr> 
	  <tr height="20">
	   <td class="title" align=center colspan=2>设备编号</td>
	   <td align=left width=70%>&nbsp&nbsp
		   <%=text2%>
	   </td>
	  </tr> 
	  <tr height="20">
	   <td class="title" align=center colspan=2>设备型号</td>
	   <td align=left width=70%>&nbsp&nbsp
		   <%=text3%>
	   </td>
	  </tr> 
	  <tr height="20">
	   <td class="title" align=center colspan=2>数量</td>
	   <td align=left width=70%>&nbsp&nbsp
		   <%=text4%>
	   </td>
	  </tr> 
	  <tr height="20">
	   <td class="title" align=center rowspan=2 width=10%>基本参数</td>
	   <td class="title" align=center width=20%>额定压力</td>
	   <td align=left width=70%>&nbsp&nbsp
		   <%=text5%>
	   </td>
	  </tr> 
	  <tr height="20">
	   <td class="title" align=center width=20%>额定排量</td>
	   <td align=left width=70%>&nbsp&nbsp
		   <%=text6%>
	   </td>
	  </tr> 
	  <tr height="20">
	   <td class="title" align=center colspan=2>投运时间</td>
	   <td align=left width=70%>&nbsp&nbsp
		   <%=text7%>
	   </td>
	  </tr> 
	  <tr height="20">
	   <td class="title" align=center colspan=2>实际徘量</td>
	   <td align=left width=70%>&nbsp&nbsp
		   <%=text8%>
	   </td>
	  </tr> 
	  <tr height="20">
	   <td class="title" align=center colspan=2>目前运行状况及问题</td>
	   <td align=left width=70%>&nbsp&nbsp
			<textarea cols=30 rows=3 class=text><%=text9%></textarea>
	   </td>
	  </tr> 
	  <tr height="20">
	   <td class="title" align=center colspan=2>备注</td>
	   <td align=left width=70%>&nbsp&nbsp
			<textarea cols=30 rows=3 class=text><%=text10%></textarea>
	   </td>
	  </tr> 
</table>
<%
dim maxId
Set Rs = Server.CreateObject("ADODB.RecordSet")
SQL="select psjdv_id from oil.oil_psjdv"
rs.open SQL,conn,1,1
if rs.eof and rs.bof then
	maxId=0
	rs.close
else
	rs.close
	SQL="select MAX(psjdv_id) as maxId from oil.oil_psjdv"
	rs.open SQL,conn,1,1
	maxId=rs("maxId")
	rs.close
end if
SQL="select * from oil.oil_psjdv"
rs.open SQL,conn,1,3
rs.addnew
rs("psjdv_id")=cint(maxId)+1
rs("psjdv_psj_id")=psjId
rs("psjdv_name")=text1
rs("psjdv_dvid")=text2
rs("psjdv_model")=text3
rs("psjdv_count")=text4
rs("psjdv_bs_edyl")=text5
rs("psjdv_edpl")=text6
rs("psjdv_tysj")=text7
rs("psjdv_sjpl")=text8
rs("psjdv_zk")=text9
rs("psjdv_memo")=text10
rs.Update 
rs.close
%>
<Br>
<hr size="1" class=hr width="98%" align="center">
  <br>
  <table width="98%" border="0" cellspacing="0" cellpadding="2" align="center">
	<tr align="center"> 
	  <td> 
		<input type="button" name="Submit32" value=" 返回 " class=button LANGUAGE=javascript onclick='javascript:location.replace("frm_psj_device.asp?area=<%=tarea%>&zsz=<%=tzsz%>");'>
	  </td>
	</tr>
  </table>
  </form>

</body>
</html>
<!--#include virtual="/include/DBClose.inc"-->

⌨️ 快捷键说明

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