📄 well_add_confirm.asp
字号:
<!--#include virtual="/include/DBCon.inc"-->
<%
areaId=request.form("areaId")
'以下从数据库取出作业区
Set Rs = Server.CreateObject("ADODB.RecordSet")
SQL="select dict_value from oil.oil_dict where dict_type='area' and dict_code='" &areaId& "'"
rs.open SQL,conn,1,1
dim areaName
if rs.eof and rs.bof then
response.redirect "/profile/errorpage.asp?title=查询作业区信息&msg=数据库里没有此作业区信息"
else
areaName=rs("dict_value")
end if
rs.close
blockId=request.form("block")
blockName=request.form("blockName")
wellId=request.form("wellId")
welltype=request.form("welltype")
wellFinishDate=request.form("textFinishDate")
textFinishMet=request.form("textFinishMet")
well_slope_depth=request.form("text1")
well_distance=request.form("text2")
well_depth=request.form("text3")
well_maxslope_depth=request.form("text4")
well_maxslope_slope=request.form("text5")
well_maxslope_fw=request.form("text6")
well_layer=request.form("text7")
well_hori_distance=request.form("text8")
well_tube_outer=request.form("text9")
well_tube_inner=request.form("text10")
well_tube_depth=request.form("text11")
well_gj_snfs=request.form("text12")
well_gj_sbjy=request.form("text13")
well_gj_time=request.form("text14")
well_gj_sbjya=request.form("text15")
isSub=request.form("isSub")
%>
<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" onload="hideAll()">
<!-- #BeginEditable "body" -->
<!--#include virtual="/include/menu_head.asp"-->
<table width="785" border="0" cellspacing="0" cellpadding="0" height="100%">
<tr>
<td valign="top">
<table width="785" border="0" cellspacing="0" cellpadding="0" height="100%">
<tr>
<td width="20%" valign="top">
<!--#include virtual="/include/menu.asp"-->
</td>
<td width="1" valign="top"></td>
<td width="2" background="/images/line01.gif" valign="top"></td>
<td width="10" valign="top"> </td>
<td width="78%" valign="top" align="center">
<!-- contents goes here --><br>
<form method=post name=form1>
<span class="subject">添加新井</span>
<hr size="1" class=hr width="98%" align="center">
<%
if isSub="" then
%>
<table width=80% border=0 cellspacing="0" cellpadding="0">
<tr>
<td align=left height=40>
您确认要添加新井"<%=wellId%>"到<%=areaName%>的<%=blockName%>内吗?
</td>
</tr>
</table>
<table border="1" cellpadding="1" cellspacing="0" align="center" class="table2"
bordercolor="#000000" bordercolordark="#F8EDEB" width="90%">
<tr height="18">
<td class="title" align=center>井代号</td>
<td align="center" colspan=2><%=wellId%></td>
</tr>
<tr height="18">
<td class="title" align=center>井所属作业区</td>
<td align="center" colspan=2><%=areaName%></td>
</tr>
<tr height="18">
<td class="title" align=center>井所属区块</td>
<td align="center" colspan=2><%=blockName%></td>
</tr>
<tr height="18">
<td class="title" align=center>井类型</td>
<td align="center" colspan=2>
<%if welltype=0 then response.write "油井" else response.write "水井" end if%>
</td>
</tr>
<tr height="18">
<td class="title" align=center>完井日期</td>
<td align="center" colspan=2> <%=wellFinishDate%></td>
</tr>
<tr height="18">
<td class="title" align=center>完成方法</td>
<td align="center" colspan=2> <%=textFinishMet%></td>
</tr>
<tr height="18">
<td class="title" width=20% align=center>造斜点</td>
<td align="center" width=20% class=title2>深度</td>
<td align="center" width=60%> <%=well_slope_depth%>米</td>
</tr>
<tr height="18">
<td class="title" align=center>套补距</td>
<td align="center" colspan=2> <%=well_distance%>米</td>
</tr>
<tr height="18">
<td class="title" align=center>完钻井深</td>
<td align="center" colspan=2> <%=well_depth%>米</td>
</tr>
<tr height="18">
<td class="title" rowspan=3 align=center>最大井斜</td>
<td align="center" class=title2>深度</td>
<td align="center"> <%=well_maxslope_depth%>米</td>
</tr>
<tr height="18">
<td align="center" class=title2>斜度</td>
<td align="center"> <%=well_maxslope_slope%>度</td>
</tr>
<tr height="18">
<td align="center" class=title2>方位</td>
<td align="center"> <%=well_maxslope_fw%>度</td>
</tr>
<tr height="18">
<td class="title" align=center>完钻层位</td>
<td align="center" colspan=2> <%=well_layer%></td>
</tr>
<tr height="18">
<td class="title" align=center>总水平位移</td>
<td align="center" colspan=2> <%=well_hori_distance%>米</td>
</tr>
<tr height="18">
<td class="title" rowspan=3 align=center>套管规范</td>
<td align="center" class=title2>外径</td>
<td align="center"> <%=well_tube_outer%>米</td>
</tr>
<tr height="18">
<td align="center" class=title2>内径</td>
<td align="center"> <%=well_tube_inner%>米</td>
</tr>
<tr height="18">
<td align="center" class=title2>下入深度</td>
<td align="center"> <%=well_tube_depth%>米</td>
</tr>
<tr height="18">
<td class="title" rowspan=4 align=center>固井质量</td>
<td align="center" class=title2>水泥返深</td>
<td align="center"> <%=well_gj_snfs%>米</td>
</tr>
<tr height="18">
<td align="center" class=title2>试泵加压</td>
<td align="center"> <%=well_gj_sbjy%>帕斯卡</td>
</tr>
<tr height="18">
<td align="center" class=title2>时间</td>
<td align="center"> <%=well_gj_time%>分</td>
</tr>
<tr height="18">
<td align="center" class=title2>降压</td>
<td align="center"> <%=well_gj_sbjya%>帕斯卡</td>
</tr>
</table>
<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=hidden name=areaId value="<%=areaId%>">
<input type=hidden name=block value="<%=blockId%>">
<input type=hidden name=blockName value="<%=blockName%>">
<input type=hidden name=welltype value="<%=welltype%>">
<input type=hidden name=wellId value="<%=wellId%>">
<input type=hidden name=textFinishDate value="<%=wellFinishDate%>">
<input type=hidden name=textFinishMet value="<%=textFinishMet%>">
<input type=hidden name=text1 value="<%=well_slope_depth%>">
<input type=hidden name=text2 value="<%=well_distance%>">
<input type=hidden name=text3 value="<%=well_depth%>">
<input type=hidden name=text4 value="<%=well_maxslope_depth%>">
<input type=hidden name=text5 value="<%=well_maxslope_slope%>">
<input type=hidden name=text6 value="<%=well_maxslope_fw%>">
<input type=hidden name=text7 value="<%=well_layer%>">
<input type=hidden name=text8 value="<%=well_hori_distance%>">
<input type=hidden name=text9 value="<%=well_tube_outer%>">
<input type=hidden name=text10 value="<%=well_tube_inner%>">
<input type=hidden name=text11 value="<%=well_tube_depth%>">
<input type=hidden name=text12 value="<%=well_gj_snfs%>">
<input type=hidden name=text13 value="<%=well_gj_sbjy%>">
<input type=hidden name=text14 value="<%=well_gj_time%>">
<input type=hidden name=text15 value="<%=well_gj_sbjya%>">
<input type=hidden name=isSub value="yes">
<input type=submit name=submit1 value=" 确定 " class=button>
<input type="button" name="Submit32" value=" 返回 " class=button LANGUAGE=javascript onclick='history.go(-1);'>
</td>
</tr>
</table>
<%
else
SQL="select * from oil.oil_well where well_id='" &wellId& "'"
rs.open SQL,conn
if not rs.eof then
response.redirect "/profile/errorpage.asp?title=添加新井&msg=数据库已经有此井信息"
else
rs.close
SQL="insert into oil.oil_well values('" &wellId& "','" &wellFinishDate& "','" &areaId& "','" &blockId& "','" &welltype& "','" &textFinishMet& "','" &well_distance& "','" &well_depth& "','" &well_layer& "','" &well_slope_depth& "','" &well_maxslope_depth& "','" &well_maxslope_slope& "','" &well_maxslope_fw& "','" &well_hori_distance& "','" &well_tube_outer& "','" &well_tube_inner& "','" &well_tube_depth& "','" &well_gj_snfs& "','" &well_gj_sbjy& "','" &well_gj_time& "','" &well_gj_sbjya& "')"
rs.open SQL,conn,1,3
end if
%>
<table width=80% border=0 cellspacing="0" cellpadding="0">
<tr>
<td align=left height=40>
新井<%=wellId%>已被添加到<%=areaName%>的<%=blockName%>中
</td>
</tr>
</table>
<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("area_detail.asp?id=<%=areaId%>");'>
</td>
</tr>
</table>
<%
end if
%>
</form>
<!-- contents end here -->
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
<!--#include virtual="/include/DBClose.inc"-->⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -