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

📄 frm_block_add_confirm.asp

📁 一套石油公司内部的运营管理系统
💻 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

blockName=request.form("textBlock")
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"><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>
			您确认要添加新区块"<%=blockName%>"到<%=areaName%>中吗?
		</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=textBlock value="<%=blockName%>">
		<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_block where block_name='" &blockName& "' and area_id='" &areaId& "'"
	rs.open SQL,conn
	if not rs.eof then
		response.redirect "/profile/errorpage.asp?title=添加新区块&msg=数据库已经有此区块信息" 
	else
		rs.close
		SQL="select * from oil.oil_block order by block_id"
		rs.open SQL,conn,1,1
		dim maxid
		if rs.eof and rs.bof then
			maxId=0
			rs.close
		else
			rs.close
			SQL="select MAX(block_id) as maxId from oil.oil_block"
			rs.open SQL,conn,1,1
			maxId=rs("maxId")
			rs.close
		end if
		SQL="insert into oil.oil_block(block_id,block_name,area_id) values('" &cint(maxId)+1& "','" &blockName& "','" &areaId& "')"
		rs.open SQL,conn,1,3
	end if
%>
<table width=80% border=0  cellspacing="0" cellpadding="0">
	<tr>
		<td align=left height=40>
		新区块<%=blockName%>已被添加到<%=areaName%>中
		</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("frm_area_detail.asp?id=<%=areaId%>");'>
	  </td>
	</tr>
  </table>
  <%
  end if
  %>
  </form>

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

⌨️ 快捷键说明

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