updatetodb.asp

客户管理crm xitong ,希望能给你带来帮助

<!--#include file="connect.asp"-->
<%
	on error resume next
	dim StrGetFormName,StrGetFormvalue,StrsqlInsert,InsertTable,RedirectUrl,StrInsertName,StrInsertValue,StrInsert
	InsertTable=Request.QueryString("InsertTable") '要修改的表名
	RedirectUrl=Request.QueryString("RedirectUrl") '要返回到的页面路径
	ModifyID=Request.QueryString("ModifyID")	'要修改的记录的ID值
	ModifyIDName=Request.QueryString("ModifyIDName")'要修改的记录的ID名称
	if ModifyID<>"" and ModifyIDName<>"" then
		if InsertTable<>"" then
			if CheckIt<>"" then
				strsqlcheck="select * from "&InsertTable&" where "&CheckIt&"='"&request(CheckIt)&"'" 
				Set objRscheck = Server.CreateObject("adodb.recordset")
		    		objRscheck.Open strsqlcheck,objConn,1,1
		    		'response.write strsqlcheck
		    		'response.end
		    		if not objRscheck.eof then
		    			if objRscheck.fields(ModifyIDName)<>ModifyID then
			    			response.write "<script language='javascript'>alert('此项目已经存在！');</script>"
			    			response.write "<p align='center'>请<a href='javascript:history.back();'>返回</a></p>"
			    			response.end
		    			end if
		    		end if
		    		objRscheck.close
		    		set objRscheck=nothing
			end if
			StrsqlInsert="update "&InsertTable&" set "
			for i=1 to Request.Form.Count
				StrGetFormName=Request.Form.Key(i)
				StrGetFormvalue=Request.Form(i)
				StrInsert=StrInsert&StrGetFormName&"='"&StrGetFormvalue&"',"
			next
				StrInsert=left(StrInsert,len(StrInsert)-1)
			StrsqlInsert=StrsqlInsert&StrInsert&" where "&ModifyIDName&"="&ModifyID
			'response.write StrsqlInsert
			'response.end
			objConn.execute StrsqlInsert
			
			if RedirectUrl<>"" and RedirectUrl<>"close" then
				Response.Redirect RedirectUrl
			elseif RedirectUrl="close" then
				response.write "<script language='javascript'>window.opener.location.reload();window.close();</script>"
				'Response.Write "<p align=center>数据插入成功，请<a href='#' onclick='window.opener.location.reload();window.close()'>返回</a></p>"
				response.end
			else
				Response.Write "<p align=center>数据插入成功，请<a href='#' onclick='history.go(-1)'>返回</a></p>"
				Response.End
			end if
		else
			Response.Write "<p align=center>请传入数据库名称！方式：QueryString</p>"
			Response.End
		end if
	else
		Response.Write "<p align=center>请传入要修改记录的参数！方式：QueryString</p>"
		Response.End
	end if
	if err then
		Response.Write "<p align=center>数据修改失败，请重试或者检查你的submit按钮的名称是否为空！</p>"
		Response.End
	end if
	
%>