frm_zsz_device_add_confirm.asp

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

	   <td align=left width=70%>&nbsp&nbsp
		   <%=text20%>
	   </td>
	  </tr> 
	  <tr height="20">
	   <td class="title" align=center width=20%>运行状况</td>
	   <td align=left width=70%>&nbsp&nbsp
		   <textarea cols=30 rows=3 class=text><%=text21%></textarea>
	   </td>
	  </tr> 
	  <tr height="20">
	   <td class="title" align=center width=20%>备注</td>
	   <td align=left width=70%>&nbsp&nbsp
		   <textarea cols=30 rows=3 class=text><%=text22%></textarea>
	   </td>
	  </tr> 
	  <%elseif dvType=2 then '----------------------------------------%>
	  <tr height="20">
	   <td class="title" align=center rowspan=5 width=10%>储水罐</td>
	   <td class="title" align=center width=20%>投运时间</td>
	   <td align=left width=70%>&nbsp&nbsp
		   <%=text1%>
	   </td>
	  </tr> 
	  <tr height="20">
	   <td class="title" align=center width=20%>规格</td>
	   <td align=left width=70%>&nbsp&nbsp
		   <%=text2%>
	   </td>
	  </tr> 
	  <tr height="20">
	   <td class="title" align=center width=20%>数量</td>
	   <td align=left width=70%>&nbsp&nbsp
		   <%=text3%>
	   </td>
	  </tr> 
	  <tr height="20">
	   <td class="title" align=center width=20%>大罐防腐</td>
	   <td align=left width=70%>&nbsp&nbsp
		   <%=text4%>
	   </td>
	  </tr> 
	  <tr height="20">
	   <td class="title" align=center width=20%>大罐运行状况</td>
	   <td align=left width=70%>&nbsp&nbsp
		   <%=text5%>
	   </td>
	  </tr> 
	  <tr height="20">
	   <td class="title" align=center rowspan=3 width=10%>隔氧密闭</td>
	   <td class="title" align=center width=20%>密闭方式</td>
	   <td align=left width=70%>&nbsp&nbsp
		   <%=text6%>
	   </td>
	  </tr> 
	  <tr height="20">
	   <td class="title" align=center width=20%>投运时间</td>
	   <td align=left width=70%>&nbsp&nbsp
		   <%=text7%>
	   </td>
	  </tr> 
	  <tr height="20">
	   <td class="title" align=center width=20%>目前存在问题及整改方案</td>
	   <td align=left width=70%>&nbsp&nbsp
			<textarea cols=30 rows=3 class=text><%=text8%></textarea>
	   </td>
	  </tr> 
	  <tr height="20">
	   <td class="title" align=center colspan=2>备注</td>
	   <td align=left width=70%>&nbsp&nbsp
			<textarea cols=30 rows=3 class=text><%=text9%></textarea>
	   </td>
	  </tr> 
	  <%elseif dvType=3 then '-------------------------------------------%>
	  <tr height="20">
	   <td class="title" align=center colspan=2>设备名称</td>
	   <td align=left width=70%>&nbsp&nbsp
		   <%=text1%>
	   </td>
	  </tr> 
	  <tr height="20">
	   <td class="title" align=center colspan=2>设备编号</td>
	   <td align=left width=70%>&nbsp&nbsp
		   <%=text2%>
	   </td>
	  </tr> 
	  <tr height="20">
	   <td class="title" align=center colspan=2>设备型号</td>
	   <td align=left width=70%>&nbsp&nbsp
		   <%=text3%>
	   </td>
	  </tr> 
	  <tr height="20">
	   <td class="title" align=center colspan=2>数量</td>
	   <td align=left width=70%>&nbsp&nbsp
		   <%=text4%>
	   </td>
	  </tr> 
	  <tr height="20">
	   <td class="title" align=center rowspan=2 width=10%>基本参数</td>
	   <td class="title" align=center width=20%>额定压力</td>
	   <td align=left width=70%>&nbsp&nbsp
		   <%=text5%>
	   </td>
	  </tr> 
	  <tr height="20">
	   <td class="title" align=center width=20%>额定排量</td>
	   <td align=left width=70%>&nbsp&nbsp
		   <%=text6%>
	   </td>
	  </tr> 
	  <tr height="20">
	   <td class="title" align=center colspan=2>投运时间</td>
	   <td align=left width=70%>&nbsp&nbsp
		   <%=text7%>
	   </td>
	  </tr> 
	  <tr height="20">
	   <td class="title" align=center colspan=2>加药名称</td>
	   <td align=left width=70%>&nbsp&nbsp
		   <%=text8%>
	   </td>
	  </tr> 
	  <tr height="20">
	   <td class="title" align=center colspan=2>加药浓度</td>
	   <td align=left width=70%>&nbsp&nbsp
		   <%=text9%>
	   </td>
	  </tr> 
	  <tr height="20">
	   <td class="title" align=center colspan=2>实际徘量</td>
	   <td align=left width=70%>&nbsp&nbsp
		   <%=text10%>
	   </td>
	  </tr> 
	  <tr height="20">
	   <td class="title" align=center colspan=2>目前运行状况及问题</td>
	   <td align=left width=70%>&nbsp&nbsp
			<textarea cols=30 rows=3 class=text><%=text11%></textarea>
	   </td>
	  </tr> 
	  <tr height="20">
	   <td class="title" align=center colspan=2>备注</td>
	   <td align=left width=70%>&nbsp&nbsp
			<textarea cols=30 rows=3 class=text><%=text12%></textarea>
	   </td>
	  </tr> 
	  <%end if%>
</table>
<%
dim maxId
if dvType=0 then
	Set Rs = Server.CreateObject("ADODB.RecordSet")
	SQL="select zsdv_id from oil.oil_zsdv"
	rs.open SQL,conn,1,1
	if rs.eof and rs.bof then
		maxId=0
		rs.close
	else
		rs.close
		SQL="select MAX(zsdv_id) as maxId from oil.oil_zsdv"
		rs.open SQL,conn,1,1
		maxId=rs("maxId")
		rs.close
	end if
	SQL="select * from oil.oil_zsdv"
	rs.open SQL,conn,1,3
	rs.addnew
	rs("zsdv_id")=cint(maxId)+1
	rs("zsdv_zsz_id")=zszId
	rs("zsdv_dv_name")=text1 
	rs("zsdv_dv_id")=text2 
	rs("zsdv_dv_model")=text3 
	rs("zsdv_count")=text4 
	rs("zsdv_edyl")=text5 
	rs("zsdv_edpl")=text6 
	rs("zsdv_tysj")=text7 
	rs("zsdv_zrsz")=text8 
	rs("zsdv_sjpl")=text9 
	rs("zsdv_zk")=text10 
	rs("zsdv_memo")=text11
	rs.Update 
	rs.close
elseif dvType=1 then
	Set Rs = Server.CreateObject("ADODB.RecordSet")
	SQL="select scldv_id from oil.oil_scldv"
	rs.open SQL,conn,1,1
	if rs.eof and rs.bof then
		maxId=0
		rs.close
	else
		rs.close
		SQL="select MAX(scldv_id) as maxId from oil.oil_scldv"
		rs.open SQL,conn,1,1
		maxId=rs("maxId")
		rs.close
	end if
	SQL="select * from oil.oil_scldv"
	rs.open SQL,conn,1,3
	rs.addnew
	rs("scldv_id")=cint(maxId)+1
	rs("scldv_zsz_id")=zszId 
	rs("scldv_glq_tysj")=text1
	rs("scldv_glq_model")=text2
	rs("scldv_glq_count")=text3
	rs("scldv_glq_rcll")=text4 
	rs("scldv_glq_yxzk")=text5
	rs("scldv_zyb_id")=text6 
	rs("scldv_zyb_model")=text7 
	rs("scldv_zyb_pl")=text8 
	rs("scldv_zyb_yc")=text9 
	rs("scldv_zyb_djgl")=text10 
	rs("scldv_zyb_tysj")=text11 
	rs("scldv_zyb_yxzk")=text12
	rs("scldv_zyb_memo")=text13 
	rs("scldv_ysj_id")=text14 
	rs("scldv_ysj_model")=text15 
	rs("scldv_ysj_pl")=text16 
	rs("scldv_ysj_yc")=text17 
	rs("scldv_ysj_yl")=text18 
	rs("scldv_ysj_djgl")=text19 
	rs("scldv_ysj_tysj")=text20 
	rs("scldv_ysj_yxzk")=text21 
	rs("scldv_ysj_memo")=text22 
	rs.Update 
	rs.close
elseif dvType=2 then
	Set Rs = Server.CreateObject("ADODB.RecordSet")
	SQL="select zszcsdv_id from oil.oil_zszcsdv"
	rs.open SQL,conn,1,1
	if rs.eof and rs.bof then
		maxId=0
		rs.close
	else
		rs.close
		SQL="select MAX(zszcsdv_id) as maxId from oil.oil_zszcsdv"
		rs.open SQL,conn,1,1
		maxId=rs("maxId")
		rs.close
	end if
	SQL="select * from oil.oil_zszcsdv"
	rs.open SQL,conn,1,3
	rs.addnew
	rs("zszcsdv_id")=cint(maxId)+1
	rs("zszcsdv_zsz_id")=zszId
	rs("zszcsdv_csg_tysj")=text1
	rs("zszcsdv_csg_gg")=text2 
	rs("zszcsdv_csg_count")=text3 
	rs("zszcsdv_csg_dgff")=text4 
	rs("zszcsdv_csg_yxzk")=text5 
	rs("zszcsdv_gymb_fs")=text6 
	rs("zszcsdv_gymb_tysj")=text7 
	rs("zszcsdv_gymb_wt")=text8 
	rs("zszcsdv_memo")=text9 
	rs.Update 
	rs.close
elseif dvType=3 then
	Set Rs = Server.CreateObject("ADODB.RecordSet")
	SQL="select jydv_id from oil.oil_jydv"
	rs.open SQL,conn,1,1
	if rs.eof and rs.bof then
		maxId=0
		rs.close
	else
		rs.close
		SQL="select MAX(jydv_id) as maxId from oil.oil_jydv"
		rs.open SQL,conn,1,1
		maxId=rs("maxId")
		rs.close
	end if
	SQL="select * from oil.oil_jydv"
	rs.open SQL,conn,1,3
	rs.addnew
	rs("jydv_id")=cint(maxId)+1
	rs("jydv_zsz_id")=zszId
	rs("jydv_name")=text1 
	rs("jydv_no")=text2 
	rs("jydv_model")=text3  
	rs("jydv_count")=text4 
	rs("jydv_bs_edyl")=text5  
	rs("jydv_bs_edpl")=text6  
	rs("jydv_tysj")=text7  
	rs("jydv_bs_jymc")=text8  
	rs("jydv_bs_jynd")=text9  
	rs("jydv_bs_sjpl")=text10  
	rs("jydv_bs_wt")=text11  
	rs("jydv_memo")=text12  
	rs.Update 
	rs.close
end if
%>
<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_zsz_device.asp?area=<%=tarea%>&zsz=<%=tzsz%>&dvtype=<%=dvType%>");'>
	  </td>
	</tr>
  </table>
  </form>

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