change.asp

基于C#语言的一个物流信息网数据库系统开发案例的源代码 ,很实用

<!-- #include file="../check/check.asp" -->
<!-- #include file="../Conn/conn.asp" -->
<% 
   	id=request.Form("id")
	ming=request.Form("name")
   	types=request.Form("type")
   	shuliang=request.Form("number")
   	danwei=request.Form("units")
   	start1=request.Form("startomit")
   	start2=request.Form("startcity")
   	end1=request.Form("endomit")
   	end2=request.Form("endcity")
	if request.Form("time")="" then
		times="没有时间上的要求"
	else	
  		time1=request.Form("time")
	end if
  	type2=request.Form("style")
	if request.Form("car")="" then
		car="对车辆没有特殊要求"
	else	
    	car=request.Form("car")
	end if	
	if request.Form("meg")="" then
		meg="没有货物的备注信息"
	else	
    	meg=request.Form("meg")
	end if	
    names=request.Form("linkman")
    phone=request.Form("phone")
   	yonghu=session("name")
   	sql="select * from tb_GoodsMeg where GoodsName='"&ming&"' and GoodsStyle='"&types&"' and GoodsNumber='"&shuliang&"' and GoodUnit='"&danwei&"' and StartOmit='"&start1&"' and StartCity='"&start2&"' and EndOmit='"&end1&"' and EndCity='"&end2&"' and TranSportTime='"&time1&"' and Style='"&type2&"' and Request='"&car&"' and Remark='"&meg&"' and Link='"&names&"' and Phone='"&phone&"' and UserName='"&yonghu&"'" 
   	rs.open sql,conn
   	if not rs.eof or not rs.bof then 
%>
		<script language="javascript">
			alert("您还没有对货物信息作任何的修改，请修改后重新保存或者终止您当前的修改操作！");
			history.back();
		</script>
<%
   	else 
   		set rs=nothing
   		conn.close
   		set conn=nothing
%>
<!-- #include file="../Conn/conn.asp" -->
<%
   		sql="update tb_GoodsMeg set GoodsName='"&ming&"',GoodsStyle='"&types&"',GoodsNumber='"&shuliang&"',GoodUnit='"&danwei&"',StartOmit='"&start1&"',StartCity='"&start2&"',EndOmit='"&end1&"',EndCity='"&end2&"',TranSportTime='"&time1&"',Style='"&type2&"',Request='"&car&"',Remark='"&meg&"',Link='"&names&"',Phone='"&phone&"',UserName='"&yonghu&"',IssueDate='"&date()&"' where ID="&id
   		rs.open sql,conn
   		set rs=nothing
   		conn.close
   		set conn=nothing
%>
<!-- #include file="../Conn/conn.asp" -->
<% 
   		sql="select * from tb_GoodsMeg where GoodsName='"&ming&"' and GoodsStyle='"&types&"' and GoodsNumber='"&shuliang&"' and GoodUnit='"&danwei&"' and StartOmit='"&start1&"' and StartCity='"&start2&"' and EndOmit='"&end1&"' and EndCity='"&end2&"' and TranSportTime='"&time1&"' and Style='"&type2&"' and Request='"&car&"' and Remark='"&meg&"' and Link='"&names&"' and Phone='"&phone&"' and UserName='"&yonghu&"'"  
   		rs.open sql,conn
   		if not rs.eof or not rs.bof then 
%> 
			<script language="javascript">
				alert("货物信息成功修改");
				window.close();
				opener.location.reload();
			</script>
<%
   		end if 
   	end if 
%>