📄 frm_ydcszy_modify.asp
字号:
<!--#include virtual="/include/DBCon.inc"-->
<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" src="/include/calender.js"></SCRIPT>
<SCRIPT LANGUAGE=javascript>
<!--
function subcheck() {
form1.submit();
}
-->
</SCRIPT>
</head>
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0"><br>
<%
sdate=request.form("sdate")
syear=split(sdate,"-")(0)
ydcszyId=request.form("chydcszy")
if ydcszyId="" then
response.redirect "/profile/errorpage.asp?title=修改数据&msg=您没有选择任何数据！"
else
ydcszyId=split(ydcszyId,",")(0)
end if
isSub=request.form("isSub")
Set Rs = Server.CreateObject("ADODB.RecordSet")
if isSub="" then
dim ydcszy(10)
SQL="select * from oil.oil_kncs,oil.oil_well,oil.oil_dict where kncs_id='" &ydcszyId& "' and kncs_well_id=well_id and well_area=dict_code and dict_type='area'"
rs.open SQL,conn,1,1
ydcszy(0)=rs("kncs_id")
ydcszy(1)=rs("kncs_well_id")
ydcszy(2)=rs("dict_value")
ydcszy(3)=rs("kncs_csnr")
ydcszy(4)=rs("kncs_csrq")
ydcszy(5)=rs("kncs_ycyl")
ydcszy(6)=rs("kncs_yzyl")
ydcszy(7)=rs("kncs_dnlz")
ydcszy(8)=rs("kncs_zlz")
ydcszy(9)=rs("kncs_memo")
ydcszy(10)=rs("kncs_year")
rs.close
%>
<span class="subject">
修改<%=syear%>年度<%=smonth%>月的月度措施效果统计(<%if welltype=0 then response.write "油井" else response.write "水井" end if%>)<font color=cc0000><%=ydcszyId%></font>数据
</span>
<hr size="1" class=hr width="98%" align="center">
<br>
<form action="" method=post name=form1>
<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 width=30%> </td>
<td class="title" align=center width=30%>原数据</td>
<td class="title" align=center width=40%>修改后(数据不变化则不填写!)</td>
</tr>
<tr height="20">
<td class="title" align=center width=30%>措施井号</td>
<td align=left width=30% colspan=2>  <%=ydcszy(1)%></td>
</tr>
</tr>
<tr height="20">
<td class="title" align=center width=30%>措施内容</td>
<td align=left width=30%>  <textarea cols=30 rows=3 class=text><%=ydcszy(3)%></textarea></td>
<td align=left width=40%>  <textarea name=text2 cols=30 rows=3 class=text></textarea></td>
</tr>
<tr height="20">
<td class="title" align=center width=30%>措施日期</td>
<td align=left width=30%>  <%=ydcszy(4)%></td>
<td align=left width=40%>  <input type=text name=text3 size=20 class=text> <input type=button value=".." name=datebt class=button onclick="fPopCalendar(text3,text3); return false" alt="按此选时"></td>
</tr>
<tr height="20">
<td class="title" align=center width=30%>月产油量</td>
<td align=left width=30%>  <%=ydcszy(5)%></td>
<td align=left width=40%>  <input type=text name=text4 size=20 class=text></td>
</tr>
<tr height="20">
<td class="title" align=center width=30%>月增油量</td>
<td align=left width=30%>  <%=ydcszy(6)%></td>
<td align=left width=40%>  <input type=text name=text5 size=20 class=text></td>
</tr>
<tr height="20">
<td class="title" align=center width=30%>当年累增</td>
<td align=left width=30%>  <%=ydcszy(7)%></td>
<td align=left width=40%>  <input type=text name=text6 size=20 class=text></td>
</tr>
<tr height="20">
<td class="title" align=center width=30%>累增</td>
<td align=left width=30%>  <%=ydcszy(8)%></td>
<td align=left width=40%>  <input type=text name=text7 size=20 class=text></td>
</tr>
<tr height="20">
<td class="title" align=center width=30%>备注</td>
<td align=left width=30%>  <textarea cols=30 rows=3 class=text><%=ydcszy(9)%></textarea></td>
<td align=left width=40%>  <textarea name=text8 cols=30 rows=3 class=text></textarea></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=chydcszy value=<%=ydcszyId%>>
<input type=hidden name=sdate value=<%=sdate%>>
<input type=hidden name=isSub value=true>
<input type="button" name="Submit32" value=" 更新 " class=button onclick=subcheck()>
<input type="button" name="Submit32" value=" 返回 " class=button LANGUAGE=javascript onclick='javascript:location.replace("frm_ydcszy.asp?year=<%=syear%>");'>
</td>
</tr>
</table>
</form>
<%
else
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")
SQL="select * from oil.oil_kncs where kncs_id='" &ydcszyId& "'"
rs.open SQL,conn,1,3
if text2<>"" then
rs("kncs_csnr")=text2
end if
if text3<>"" then
rs("kncs_csrq")=text3
end if
if text4<>"" then
rs("kncs_ycyl")=text4
end if
if text5<>"" then
rs("kncs_yzyl")=text5
end if
if text6<>"" then
rs("kncs_dnlz")=text6
end if
if text7<>"" then
rs("kncs_zlz")=text7
end if
if text8<>"" then
rs("kncs_memo")=text8
end if
rs.update
rs.close
response.redirect "frm_ydcszy.asp?year=" &syear
end if
%>
</body>
</html>
<!--#include virtual="/include/DBClose.inc"-->⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -