frm_zsjjc_add_confirm.asp

一套石油公司内部的运营管理系统

<!--#include virtual="/include/DBCon.inc"-->
<%
syear=request.form("year")
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")
text11=request.form("text11")
text12=request.form("text12")
text13=request.form("text13")
text14=request.form("text14")
text15=request.form("text15")
text16=request.form("text16")
text17=request.form("text17")
text18=request.form("text18")
text19=request.form("text19")
text20=request.form("text20")
text21=request.form("text21")
Set Rs = Server.CreateObject("ADODB.RecordSet")
SQL="select well_id from oil.oil_well where well_id='" &text1& "' and well_type='1'"
rs.open SQL,conn
if rs.eof then
	response.redirect "/profile/errorpage.asp?title=添加新的注水井检串记录&msg=数据库里没有你添加的水井号！请确认井号是否是正确或者添加新井。" 
else
	rs.close
	SQL="select zsjjc_id from oil.oil_zsjjc"
	rs.open SQL,conn,1,1
	if rs.eof and rs.bof then
		maxId=0
		rs.close
	else
		rs.close
		SQL="select MAX(zsjjc_id) as maxId from oil.oil_zsjjc"
		rs.open SQL,conn,1,1
		maxId=rs("maxId")
		rs.close
	end if
	SQL="select * from oil.oil_zsjjc"
	rs.open SQL,conn,1,3
	rs.addnew
	rs("zsjjc_id")=cint(maxId)+1
	rs("zsjjc_well_id")=text1
	rs("zsjjc_date")=text2
	rs("zsjjc_nr")=text3
	rs("zsjjc_yg_gf")=text4
	rs("zsjjc_yg_gs")=text5
	rs("zsjjc_yg_cd")=text6
	rs("zsjjc_dj_gf")=text7
	rs("zsjjc_dj_gs")=text8
	rs("zsjjc_dj_cd")=text9
	rs("zsjjc_fgq_xh")=text10
	rs("zsjjc_fgq_sf")=text11
	rs("zsjjc_fgq_zf")=text12
	rs("zsjjc_fgq_xf")=text13
	rs("zsjjc_psq_xh")=text14
	rs("zsjjc_psq_sp")=text15
	rs("zsjjc_psq_zp1")=text16
	rs("zsjjc_psq_zp2")=text17
	rs("zsjjc_psq_xp")=text18
	rs("zsjjc_zjt")=text19
	rs("zsjjc_qt")=text20
	rs("zsjjc_zdgx")=text21
	rs.update
	rs.close
end if
response.redirect "frm_zsjjc.asp?year=" &syear
%>
<!--#include virtual="/include/DBClose.inc"-->