📄 frm_ydgzlbb_add_confirm.asp
字号:
<tr height="20">
<td class="title" align=center width=10%>酸化</td>
<td align=left width=70%>  <%=text5%></td>
</tr>
<tr height="20">
<td class="title" align=center width=10%>补孔改层</td>
<td align=left width=70%>  <%=text6%></td>
</tr>
<tr height="20">
<td class="title" align=center width=10%>其他</td>
<td align=left width=70%>  <%=text7%></td>
</tr>
<tr height="20">
<td class="title" align=center width=10%>堵水</td>
<td align=left width=70%>  <%=text8%></td>
</tr>
<tr height="20">
<td class="title" align=center width=20% colspan=2>大修(口)</td>
<td align=left width=70%>  <%=text9%></td>
</tr>
<tr height="20">
<td class="title" align=center width=10% rowspan=5>维护作业</td>
<td class="title" align=center width=10%>小计</td>
<td align=left width=70%>  <%=text10%></td>
</tr>
<tr height="20">
<td class="title" align=center width=10%>合注</td>
<td align=left width=70%>  <%=text11%></td>
</tr>
<tr height="20">
<td class="title" align=center width=10%>分注</td>
<td align=left width=70%>  <%=text12%></td>
</tr>
<tr height="20">
<td class="title" align=center width=10%>检串</td>
<td align=left width=70%>  <%=text13%></td>
</tr>
<tr height="20">
<td class="title" align=center width=10%>其他</td>
<td align=left width=70%>  <%=text14%></td>
</tr>
<tr height="20">
<td class="title" align=center width=20% colspan=2>投转注井(口)</td>
<td align=left width=70%>  <%=text15%></td>
</tr>
<tr height="20">
<td class="title" align=center width=20% colspan=2>其他</td>
<td align=left width=70%>  <%=text16%></td>
</tr>
<%end if%>
</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>
<%
if welltype=0 then
%>
<input type=hidden name=sdate value="<%=sdate%>">
<input type=hidden name=welltype value="0">
<input type=hidden name=text1 value="<%=text1%>">
<input type=hidden name=text2 value="<%=text2%>">
<input type=hidden name=text3 value="<%=text3%>">
<input type=hidden name=text4 value="<%=text4%>">
<input type=hidden name=text5 value="<%=text5%>">
<input type=hidden name=text6 value="<%=text6%>">
<input type=hidden name=text7 value="<%=text7%>">
<input type=hidden name=text8 value="<%=text8%>">
<input type=hidden name=text9 value="<%=text9%>">
<input type=hidden name=text10 value="<%=text10%>">
<input type=hidden name=text11 value="<%=text11%>">
<input type=hidden name=text12 value="<%=text12%>">
<input type=hidden name=text13 value="<%=text13%>">
<input type=hidden name=text14 value="<%=text14%>">
<input type=hidden name=text15 value="<%=text15%>">
<input type=hidden name=text16 value="<%=text16%>">
<input type=hidden name=text17 value="<%=text17%>">
<input type=hidden name=text18 value="<%=text18%>">
<input type=hidden name=text19 value="<%=text19%>">
<input type=hidden name=text20 value="<%=text20%>">
<input type=hidden name=text21 value="<%=text21%>">
<%
else
%>
<input type=hidden name=sdate value="<%=sdate%>">
<input type=hidden name=welltype value="1">
<input type=hidden name=text1 value="<%=text1%>">
<input type=hidden name=text2 value="<%=text2%>">
<input type=hidden name=text3 value="<%=text3%>">
<input type=hidden name=text4 value="<%=text4%>">
<input type=hidden name=text5 value="<%=text5%>">
<input type=hidden name=text6 value="<%=text6%>">
<input type=hidden name=text7 value="<%=text7%>">
<input type=hidden name=text8 value="<%=text8%>">
<input type=hidden name=text9 value="<%=text9%>">
<input type=hidden name=text10 value="<%=text10%>">
<input type=hidden name=text11 value="<%=text11%>">
<input type=hidden name=text12 value="<%=text12%>">
<input type=hidden name=text13 value="<%=text13%>">
<input type=hidden name=text14 value="<%=text14%>">
<input type=hidden name=text15 value="<%=text15%>">
<input type=hidden name=text16 value="<%=text16%>">
<%
end if
%>
<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
dim maxId
SQL="select * from oil.oil_jxzygzl"
rs.open SQL,conn,1,1
if rs.eof and rs.bof then
maxId=0
rs.close
else
rs.close
SQL="select MAX(jxzygzl_id) as maxId from oil.oil_jxzygzl"
rs.open SQL,conn,1,1
maxId=rs("maxId")
rs.close
end if
SQL="select * from oil.oil_jxzygzl where jxzygzl_field='" &text1& "' and jxzygzl_date='" &sdate& "'"
rs.open SQL,conn
symbol=0
if not rs.eof then
symbol=1
if rs("jxzygzl_yqj_heji")<>"" and welltype=0 then
response.redirect "/profile/errorpage.asp?title=添加数据&msg=数据库已经有本月" &text1& "的油气井工作量统计数据!"
elseif rs("jxzygzl_zsj_total")<>"" and welltype=1 then
response.redirect "/profile/errorpage.asp?title=添加数据&msg=数据库已经有本月" &text1& "的注水井工作量统计数据!"
elseif welltype=0 then
rs.close
SQL="update oil.oil_jxzygzl set jxzygzl_total='" &text2& "',jxzygzl_yqj_heji='" &text3& "',jxzygzl_yqj_csxj='" &text4& "',jxzygzl_yqj_yl='" &text5& "',jxzygzl_yqj_sh='" &text6& "',jxzygzl_yqj_bkgc='" &text7& "',jxzygzl_yqj_hz='" &text8& "',jxzygzl_yqj_hdb='" &text9& "',jxzygzl_yqj_xdb='" &text10& "',jxzygzl_yqj_xslb='" &text11& "',jxzygzl_yqj_sy='" &text12& "',jxzygzl_yqj_kds='" &text13& "',jxzygzl_yqj_zsjjd='" &text14& "',jxzygzl_yqj_pmxj='" &text15& "',jxzygzl_yqj_bryl='" &text16& "',jxzygzl_yqj_other='" &text17& "',jxzygzl_yqj_daxiu='" &text18& "',jxzygzl_yqj_wh_xj='" &text19& "',jxzygzl_yqj_wh_jbcs='" &text20& "',jxzygzl_yqj_xjtc='" &text21& "' where jxzygzl_field='" &text1& "'"
rs.open SQL,conn,1,3
elseif welltype=1 then
rs.close
SQL="update oil.oil_jxzygzl set jxzygzl_zsj_total='" &text2& "',jxzygzl_zsj_xj='" &text3& "',jxzygzl_zsj_yl='" &text4& "',jxzygzl_zsj_sh='" &text5& "',jxzygzl_zsj_bkgc='" &text6& "',jxzygzl_zsj_zzother='" &text7& "',jxzygzl_zsj_ds='" &text8& "',jxzygzl_zsj_dx='" &text9& "',jxzygzl_zsj_wh_xj='" &text10& "',jxzygzl_zsj_hz='" &text11& "',jxzygzl_zsj_fz='" &text12& "',jxzygzl_zsj_jc='" &text13& "',jxzygzl_zsj_whother='" &text14& "',jxzygzl_zsj_tzjk='" &text15& "',jxzygzl_zsj_other='" &text16& "' where jxzygzl_field='" &text1& "'"
rs.open SQL,conn,1,3
end if
else
if welltype=0 then
rs.close
SQL="insert into oil.oil_jxzygzl values('" &cint(maxId)+1& "','" &sdate& "','" &text1& "','" &text2& "','" &text3& "','" &text4& "','" &text5& "','" &text6& "','" &text7& "','" &text8& "','" &text9& "','" &text10& "','" &text11& "','" &text12& "','" &text13& "','" &text14& "','" &text15& "','" &text16& "','" &text17& "','" &text18& "','" &text19& "','" &text20& "','" &text21& "','','','','','','','','','','','','','','','')"
rs.open SQL,conn,1,3
else
rs.close
SQL="insert into oil.oil_jxzygzl values('" &cint(maxId)+1& "','" &sdate& "','" &text1& "','','','','','','','','','','','','','','','','','','','','','" &text2& "','" &text3& "','" &text4& "','" &text5& "','" &text6& "','" &text7& "','" &text9& "','" &text10& "','" &text11& "','" &text12& "','" &text13& "','" &text14& "','" &text15& "','" &text16& "','" &text8& "')"
rs.open SQL,conn,1,3
end if
end if
%>
<table width=80% border=0 cellspacing="0" cellpadding="0">
<tr>
<td align=left height=40>
新数据已经成功添加到数据库。
</td>
</tr>
</table>
<Br>
<%if symbol=0 then%>
<table width="98%" border="0" cellspacing="0" cellpadding="2" align="center">
<tr>
<td align=center>
<%if welltype=0 then%>
<input type="button" name="bt1" value="继续添加水井数据" class=button LANGUAGE=javascript onclick='javascript:location.replace("frm_ydgzlbb_add.asp?sdate=<%=sdate%>&welltype=1&field=<%=text1%>");'>
<%else%>
<input type="button" name="bt1" value="继续添加油井井数据" class=button LANGUAGE=javascript onclick='javascript:location.replace("frm_ydgzlbb_add.asp?sdate=<%=sdate%>&welltype=0&field=<%=text1%>");'>
<%end if%>
</td>
</tr>
</table>
<%end if%>
<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=goCh(<%=syear%>,<%=smonth%>,<%=welltype%>,<%=symbol%>)>
</td>
</tr>
</table>
<%
end if
%>
</form>
</body>
</html>
<!--#include virtual="/include/DBClose.inc"-->⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -