| 网站首页 | 业界新闻 | 小组 | 威客 | 人才 | 下载频道 | 博客 | 代码贴 | 在线编程 | 编程论坛
欢迎加入我们,一同切磋技术
用户名:   
 
密 码:  
共有 507 人关注过本帖
标题:各位大哥帮帮忙
只看楼主 加入收藏
abc449185124
Rank: 1
等 级:新手上路
帖 子:2
专家分:0
注 册:2008-2-29
收藏
 问题点数:0 回复次数:0 
各位大哥帮帮忙
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="../../Connections/conn.asp" -->

<%
dim rs
set rs=Server.CreateObject("adodb.recordset")
rs.ActiveConnection = MM_conn_STRING
rs.open "select * from bbxzxx_khxx where bbxz_bbzxx='"&Request.Form("bbxz_bbxzxx_yw")&"' and bbxzsfdm_bbzxx='"&Request.Form("bbxzsfdm_bbzxx_yw")&"'",MM_conn_STRING,1,3
If Not rs.Bof And Not rs.Eof Then
rs.addnew
if(Request.Form("bbxz_bbxzxx_yw") <> "") then rs("bbxz_bbzxx")=Trim(Request.Form("bbxz_bbxzxx_yw"))
if(Request.Form("bbxzdz_bbxzxx_yw") <> "") then rs("bbxzdz_bbxzxx")=Trim(Request.Form("bbxzdz_bbxzxx_yw"))
if(Request.Form("bbxzlxdh_bbxzxx_yw") <> "") then rs("bbxzlxdh_bbxzxx")=Trim(Request.Form("bbxzlxdh_bbxzxx_yw"))
if(Request.Form("bbxzsfdm_bbxzxx_yw") <> "") then rs("bbxzsfdm_bbzxx")=Trim(Request.Form("bbxzsfdm_bbxzxx_yw"))
if(Request.Form("bbxzzjlx_bbxzxx_yw") <> "") then rs("bbxzzjlx_bbxzxx")=Trim(Request.Form("bbxzzjlx_bbxzxx_yw"))
if(Request.Form("bbxzyddh_bbxzxx_yw") <> "") then rs("bbxzyddh_bbxzxx")=Trim(Request.Form("bbxzyddh_bbxzxx_yw"))
if(Request.Form("bbxzczdh_bbxzxx_yw") <> "") then rs("bbxzczdh_bbxzxx")=Trim(Request.Form("bbxzczdh_bbxzxx_yw"))
if(Request.Form("lxr_bbxzxx_yw") <> "") then rs("lxr_bbxzxx")=Trim(Request.Form("lxr_bbxzxx_yw"))
if(Request.Form("lxrdz_bbxzxx_yw") <> "") then rs("lxrdz_bbxzxx")=Trim(Request.Form("lxrdz_bbxzxx_yw"))
if(Request.Form("lxrdh_bbxzxx_yw") <> "") then rs("lxrdh_bbxzxx")=Trim(Request.Form("lxrdh_bbxzxx_yw"))
if(Request.Form("lxryddh_bbxzxx_yw") <> "") then rs("lxryddh_bbxzxx")=Trim(Request.Form("lxr_bbxzxx_yw"))
if(Request.Form("lxrczdh_bbxzxx_yw") <> "") then rs("lxrczdh_bbxzxx")=Trim(Request.Form("lxrczdh_bbxzxx_yw"))
if(Request.Form("bz_bbxzxx_yw") <> "") then rs("bz_bbxzxx")=Trim(Request.Form("bz_bbxzxx_yw"))
rs.update
bbxz_ID=rs("bbxz_ID")
rs.close
Response.Write("bbxz_ID")
else
bbxz_ID=rs("bbxz_ID")
response.write("bbxz_ID")
end if

rs.open "select * from clxx_bdxx_ywxx where cphm_clxx_bdxx='"& Request.Form("cphm_clxx_yw") &"' and VIN_clxx_bdxx='"Request.Form("VIN_clxx_yw")"'",MM_conn_STRING,1,3
If Not rs.Bof And Not rs.Eof Then
rs.addnew
if(Request.Form("cdzq_clxx_yw") <> "") then rs("cdzq_clxx_bdxx")=Trim(Request.Form("cdzq_clxx_yw"))
if(Request.Form("clzl_clxx_yw") <> "") then rs("clzl_clxx_bdxx")=Trim(Request.Form("clzl_clxx_yw"))
if(Request.Form("cphm_clxx_yw") <> "") then rs("cphm_clxx_bdxx")=Trim(Request.Form("cphm_clxx_yw"))
if(Request.Form("cpxh_clxx_yw") <> "") then rs("cpxh_clxx_bdxx")=Trim(Request.Form("cpxh_clxx_yw"))
if(Request.Form("cz_clxx_yw") <> "") then rs("cz_clxx_bdxx")=Trim(Request.Form("cz_clxx_yw"))
if(Request.Form("edzk_clxx_yw") <> "") then rs("edzk_clxx_bdxx")=Trim(Request.Form("edzk_clxx_yw"))
if(Request.Form("edzzl_clxx_yw") <> "") then rs("edzzl_clxx_bdxx")=Trim(Request.Form("edzzl_clxx_yw"))
if(Request.Form("fdjh_clxx_yw") <> "") then rs("fdjh_clxx_bdxx")=Trim(Request.Form("fdjh_clxx_yw"))
if(Request.Form("hpds_clxx_yw") <> "") then rs("hpds_clxx_bdxx")=Trim(Request.Form("hpds_clxx_yw"))
if(Request.Form("pl_clxx_yw") <> "") then rs("pl_clxx_bdxx")=Trim(Request.Form("pl_clxx_yw"))
if(Request.Form("ssqy_clxx_yw") <> "") then rs("ssqy_clxx_bdxx")=Trim(Request.Form("ssqy_clxx_yw"))
if(Request.Form("syxz_clxx_yw") <> "") then rs("syxz_clxx_bdxx")=Trim(Request.Form("syxz_clxx_yw"))
if(Request.Form("xcgzj_clxx_yw") <> "") then rs("xcgzj_clxx_bdxx")=Trim(Request.Form("xcgzj_clxx_yw"))
if(Request.Form("gl_clxx_yw") <> "") then rs("gl_clxx_bdxx")=Trim(Request.Form("gl_clxx_yw"))
if(Request.Form("VIN_clxx_yw") <> "") then rs("VIN_clxx_bdxx")=Trim(Request.Form("VIN_clxx_yw"))
if(Request.Form("ysylx_clxx_yw") <> "") then rs("ysylx_clxx_bdxx")=Trim(Request.Form("ysylx_clxx_yw"))
if(Request.Form("zbzl_clxx_yw") <> "") then rs("zbzl_clxx_bdxx")=Trim(Request.Form("zbzl_clxx_yw"))
rs.update
clxxID_bdxx_ywxx=rs("clxxID_bdxx_ywxx")
rs.close
response.write("clxxID_bdxx_ywxx")
else
clxxID_bdxx_ywxx=rs("clxxID_bdxx_ywxx")
response.write("clxxID_bdxx_ywxx")
end if

rs.open "select * from bzxx_ywxx where bxdh_dzxx_yw='"Request.Form("bxdh_syx_yw")"'",MM_conn_STRING,1,3

If Not rs.Bof And Not rs.Eof Then
rs.addnew
rs("bbxzID_bbxzxx_yw")=bbxz_ID
rs("bdID_bzxx_yw")=clxxID_bdxx_ywxx
if(Request.Form("bbxz_bbxzxx_yw") <> "") then rs("bbxz_bbxzxx_yw")=Trim(Request.Form("bbxz_bbxzxx_yw"))

if(Request.Form("bbxzdz_bbxzxx_yw") <> "") then rs("bbxzdz_bbxzxx_yw")=Trim(Request.Form("bbxzdz_bbxzxx_yw")) '
if(Request.Form("bbxzlxdh_bbxzxx_yw") <> "") then rs("bbxzlxdh_bbxzxx_yw")=Trim(Request.Form("bbxzlxdh_bbxzxx_yw"))
if(Request.Form("bbxzsfdm_bbxzxx_yw") <> "") then rs("bbxzsfdm_bbzxx_yw")=Trim(Request.Form("bbxzsfdm_bbxzxx_yw"))
if(Request.Form("bbxzzjlx_bbxzxx_yw") <> "") then rs("bbxzzjlx_bbxzxx_yw")=Trim(Request.Form("bbxzzjlx_bbxzxx_yw"))
if(Request.Form("bdysh_syx_yw") <> "") then rs("bdysh_dzxx_yw")=Trim(Request.Form("bdysh_syx_yw"))
if(Request.Form("bdzt_syx_yw") <> "") then rs("bdzt_bzxx_yw")=Trim(Request.Form("bdzt_syx_yw"))
if(Request.Form("bxdh_syx_yw") <> "") then rs("bxdh_dzxx_yw")=Trim(Request.Form("bxdh_syx_yw"))
if(Request.Form("bxf_syx_yw") <> "") then rs("bxf_bzxx_yw")=Trim(Request.Form("bxf_syx_yw"))
if(Request.Form("bxje_syx_yw") <> "") then rs("bxje_bzxx_yw")=Trim(Request.Form("bxje_syx_yw"))
if(Request.Form("bz_yw") <> "") then rs("bz_bdxx_yw")=Trim(Request.Form("bz_yw"))
if(Request.Form("dllx_yw") <> "") then rs("dllx_yw")=Trim(Request.Form("dllx_yw"))
if(Request.Form("dlr_system_yw") <> "") then rs("dlr_system")=Trim(Request.Form("dlr_system_yw"))
if(Request.Form("dlr_yw") <> "") then rs("dlr_yw")=Trim(Request.Form("dlr_yw"))
if(Request.Form("dqzq_syx_yw") <> "") then rs("dqzq_bzxx_yw")=Trim(Request.Form("dqzq_syx_yw"))
if(Request.Form("gsbm_yw") <> "") then rs("gsbm_yw")=Trim(Request.Form("gsbm_yw"))
if(Request.Form("gsjbz_yw") <> "") then rs("gsjbz_yw")=Trim(Request.Form("gsjbz_yw")) '
if(Request.Form("jbr_yw") <> "") then rs("jbr_yw")=Trim(Request.Form("jbr_yw")) '

if(Request.Form("jqxcbgs_jqx_yw") <> "") then rs("jqxcbgs_bzxx_yw")=Trim(Request.Form("jqxcbgs_jqx_yw"))
if(Request.Form("lzjbz_user_yw") <> "") then rs("jbr_lz_yw")=Trim(Request.Form("lzjbz_user_yw"))
if(Request.Form("lzzq_system_yw") <> "") then rs("zq_lz_yw")=Trim(Request.Form("lzzq_system_yw"))
if(Request.Form("qbzq_syx_yw") <> "") then rs("qbzq_bzxx_yw")=Trim(Request.Form("qbzq_syx_yw"))
if(Request.Form("tbyd_syx_yw") <> "") then rs("tbyd_bzxx_yw")=Trim(Request.Form("tbyd_syx_yw"))
if(Request.Form("xzID_syx_yw") <> "") then rs("xzID_yw")=Trim(Request.Form("xzID_syx_yw"))
if(Request.Form("qdzq_yw") <> "") then rs("qqdzq_bdxx_yw")=Trim(Request.Form("qdzq_yw"))
if(Request.Form("bxdh_jqx_yw") <> "") then rs("jqxbdh_bdxx_yw")=Trim(Request.Form("bxdh_jqx_yw"))'
rs.update
ID_dzxx=rs("ID_dzxx")
bxdh_dzxx_yw=rs("bxdh_dzxx_yw")
rs.close
response.write("bxdh_dzxx_yw"+",ID号:"+"ID_dzxx")
else
ID_dzxx=rs("ID_dzxx")
bxdh_dzxx_yw=rs("bxdh_dzxx_yw")
response.write("bxdh_dzxx_yw"+",在ID号:"+"clxxID_bdxx_ywxx")
end if

rs.open "select * from bzxx_ywxx where bxdh_dzxx_yw='"Request.Form("bxdh_jqx_yw")"'",MM_conn_STRING,1,3
If Not rs.Bof And Not rs.Eof Then
rs.addnew
rs("bbxzID_bbxzxx_yw")=bbxz_ID
rs("bdID_bzxx_yw")=clxxID_bdxx_ywxx
if(Request.Form("bbxz_bbxzxx_yw") <> "") then rs("bbxz_bbxzxx_yw")=Trim(Request.Form("bbxz_bbxzxx_yw"))
if(Request.Form("bbxzdz_bbxzxx_yw") <> "") then rs("bbxzdz_bbxzxx_yw")=Trim(Request.Form("bbxzdz_bbxzxx_yw"))
if(Request.Form("bbxzlxdh_bbxzxx_yw") <> "") then rs("bbxzlxdh_bbxzxx_yw")=Trim(Request.Form("bbxzlxdh_bbxzxx_yw"))
if(Request.Form("bbxzsfdm_bbxzxx_yw") <> "") then rs("bbxzsfdm_bbzxx_yw")=Trim(Request.Form("bbxzsfdm_bbxzxx_yw"))
if(Request.Form("bbxzzjlx_bbxzxx_yw") <> "") then rs("bbxzzjlx_bbxzxx_yw")=Trim(Request.Form("bbxzzjlx_bbxzxx_yw"))
if(Request.Form("bdysh_jqx_yw") <> "") then rs("bdysh_dzxx_yw")=Trim(Request.Form("bdysh_jqx_yw"))
if(Request.Form("bdzt_jqx_yw") <> "") then rs("bdzt_bzxx_yw")=Trim(Request.Form("bdzt_jqx_yw"))
if(Request.Form("bxdh_jqx_yw") <> "") then rs("bxdh_yw")=Trim(Request.Form("bxdh_jqx_yw"))
if(Request.Form("bxf_jqx_yw") <> "") then rs("bxf_bzxx_yw")=Trim(Request.Form("bxf_jqx_yw"))
if(Request.Form("bxje_jqx_yw") <> "") then rs("bxje_bzxx_yw")=Trim(Request.Form("bxje_jqx_yw"))
if(Request.Form("bz_yw") <> "") then rs("bz_yw")=Trim(Request.Form("bz_yw"))
if(Request.Form("dllx_yw") <> "") then rs("dllx_yw")=Trim(Request.Form("dllx_yw"))
if(Request.Form("dlr_system_yw") <> "") then rs("dlr_system")=Trim(Request.Form("dlr_system_yw"))
if(Request.Form("dlr_yw") <> "") then rs("dlr_yw")=Trim(Request.Form("dlr_yw"))
if(Request.Form("dqzq_jqx_yw") <> "") then rs("dqzq_bzxx_yw")=Trim(Request.Form("dqzq_jqx_yw"))
if(Request.Form("gsbm_yw") <> "") then rs("gsbm_jwxx_yw")=Trim(Request.Form("gsbm_yw"))
if(Request.Form("gsjbz_yw") <> "") then rs("gsjbz_jwxx_yw")=Trim(Request.Form("gsjbz_yw"))
if(Request.Form("jbr_yw") <> "") then rs("jbr_yw")=Trim(Request.Form("jbr_yw"))
if(Request.Form("lzjbz_user_yw") <> "") then rs("jbr_lz_yw")=Trim(Request.Form("lzjbz_user_yw"))
if(Request.Form("lzzq_system_yw") <> "") then rs("zq_lz_yw")=Trim(Request.Form("lzzq_system_yw"))1
if(Request.Form("qbzq_jqx_yw") <> "") then rs("qbzq_bzxx_yw")=Trim(Request.Form("qbzq_jqx_yw"))
if(Request.Form("tbyd_jqx_yw") <> "") then rs("tbyd_bzxx_yw")=Trim(Request.Form("tbyd_jqx_yw"))
if(Request.Form("xzID_jqx_yw") <> "") then rs("xzID_yw")=Trim(Request.Form("xzID_jqx_yw"))
if(Request.Form("qdzq_yw") <> "") then rs("qqdzq_bdxx_yw")=Trim(Request.Form("qdzq_yw"))
rs.update
ID_dzxx_jqx=rs("ID_dzxx")
bxdh_dzxx_yw_jqx=rs("bxdh_dzxx_yw")
rs.close
response.write("bxdh_dzxx_yw_jqx"+",ID号:"+"ID_dzxx_jqx")
else
ID_dzxx=rs("ID_dzxx")
bxdh_dzxx_yw=rs("bxdh_dzxx_yw")
response.write("bxdh_dzxx_yw_jqx"+",在ID号:"+"ID_dzxx_jqx")
end if

rs.open "select * from swxx",MM_conn_STRING,1,3
rs.addnew
if(Request.Form("bbxz_bbxzxx_yw") <> "") then rs("bbxz_swxx")=Trim(Request.Form("bbxz_bbxzxx_yw"))
if(Request.Form("bbxzsfdm_bbxzxx_yw") <> "") then rs("bbxzsfdm_swxx")=Trim(Request.Form("bbxzsfdm_bbxzxx_yw"))
if(Request.Form("bbxzzjlx_bbxzxx_yw") <> "") then rs("bbxzzjlx_swxx")=Trim(Request.Form("bbxzzjlx_bbxzxx_yw"))
if(Request.Form("bdysh_jqx_yw") <> "") then rs("bdysh_swxx")=Trim(Request.Form("bdysh_jqx_yw"))
if(Request.Form("bxdh_jqx_yw") <> "") then rs("bdh_swxx")=Trim(Request.Form("bxdh_jqx_yw"))
if(Request.Form("cdzq_clxx_yw") <> "") then rs("cdzq_clxx_swxx")=Trim(Request.Form("cdzq_clxx_yw"))
if(Request.Form("clzl_clxx_yw") <> "") then rs("clzl_clxx_swxx")=Trim(Request.Form("clzl_clxx_yw"))
if(Request.Form("cphm_clxx_yw") <> "") then rs("cphm_swxx")=Trim(Request.Form("cphm_clxx_yw"))
if(Request.Form("cz_clxx_yw") <> "") then rs("cz_clxx_swxx")=Trim(Request.Form("cz_clxx_yw"))
if(Request.Form("dlr_yw") <> "") then rs("dlz_jwxx_swxx")=Trim(Request.Form("dlr_yw"))
if(Request.Form("edzk_clxx_yw") <> "") then rs("edzk_clxx_swxx")=Trim(Request.Form("edzk_clxx_yw"))
if(Request.Form("edzzl_clxx_yw") <> "") then rs("edzzl_clxx_swxx")=Trim(Request.Form("edzzl_clxx_yw"))
if(Request.Form("gsbm_yw") <> "") then rs("gsbm_jwxx_swxx")=Trim(Request.Form("gsbm_yw"))
if(Request.Form("gsjbz_yw") <> "") then rs("gsjbz_jwxx_swxx")=Trim(Request.Form("gsjbz_yw"))
if(Request.Form("hpds_clxx_yw") <> "") then rs("hpds_clxx_swxx")=Trim(Request.Form("hpds_clxx_yw"))
if(Request.Form("jbr_yw") <> "") then rs("jbz_jwxx_swxx")=Trim(Request.Form("jbr_yw"))
if(Request.Form("lzjbz_user_yw") <> "") then rs("lzjbz_user_swxx")=Trim(Request.Form("lzjbz_user_yw"))
if(Request.Form("lzzq_system_yw") <> "") then rs("lzzq_systme_swxx")=Trim(Request.Form("lzzq_system_yw"))
if(Request.Form("pl_clxx_yw") <> "") then rs("pl_clxx_swxx")=Trim(Request.Form("pl_clxx_yw"))
if(Request.Form("gl_clxx_yw") <> "") then rs("gl_clxx_swxx")=Trim(Request.Form("gl_clxx_yw"))
if(Request.Form("syxz_clxx_yw") <> "") then rs("syxz_clxx_swxx")=Trim(Request.Form("syxz_clxx_yw"))
if(Request.Form("lszsbh_swxx_yw") <> "") then rs("lszsbh_ccsxx_swxx")=Trim(Request.Form("lszsbh_swxx_yw"))
if(Request.Form("dlyj_swxx_yw") <> "") then rs("dlyj_ccsxx_swxx")=Trim(Request.Form("dlyj_swxx_yw"))
if(Request.Form("wlbj_swxx_yw") <> "") then rs("wlbj_ccsxx_swxx")=Trim(Request.Form("wlbj_swxx_yw"))
if(Request.Form("zlj_swxx_yw") <> "") then rs("zlj_ccsxx_swxx")=Trim(Request.Form("zlj_swxx_yw"))
if(Request.Form("ccshj_swxx_yw") <> "") then rs("ccshj_ccsxx_swxx")=Trim(Request.Form("ccshj_swxx_yw"))
if(Request.Form("wspzh_swxx_yw") <> "") then rs("wspzh_ccsxx_swxx")=Trim(Request.Form("wspzh_swxx_yw"))
if(Request.Form("kjswjg_swxx_yw") <> "") then rs("kjswjg_ccsxx_swxx")=Trim(Request.Form("kjswjg_swxx_yw"))
rs.update
rs.close

set rs=nothing
response.Write("history.go(-1)")
response.End()

%>
ADODB。field '800a0bcd
BOF或EOF中有一个是真,或者当前记录已被删除,所需要的操作要求一个当前的记录
搜索更多相关主题的帖子: include where 大哥 file 
2008-03-03 13:18
快速回复:各位大哥帮帮忙
数据加载中...
 
   



关于我们 | 广告合作 | 编程中国 | 清除Cookies | TOP | 手机版

编程中国 版权所有,并保留所有权利。
Powered by Discuz, Processed in 0.035216 second(s), 9 queries.
Copyright©2004-2024, BCCN.NET, All Rights Reserved