frm_csjdtb_modify_confirm.asp

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

<!--#include virtual="/include/DBCon.inc"-->
<%
syear=request.form("year")
text2=request.form("text2")
text3=request.form("text3")
text4=request.form("text4")
text5=request.form("text5")
csjdtId=request.form("chcsjdt")
Set Rs = Server.CreateObject("ADODB.RecordSet")
SQL="select * from oil.oil_csjdt where csjdt_id='" &csjdtId& "'"
rs.open SQL,conn,1,3
if text2<>"" then 
	rs("csjdt_csnr")=text2
end if
if text3<>"" then 
	rs("csjdt_csrq")=text3
end if
if text4<>"" then 
	rs("csjdt_mqjd")=text4
end if
if text5<>"" then 
	rs("csjdt_yxsl")=text5
end if
rs.update
rs.close
response.redirect "frm_csjdtb.asp?year=" &syear
%>
<!--#include virtual="/include/DBClose.inc"-->