媳妇单位搬家,太远,得车接车送,而且都是小车,派车是个问题,并且车辆不固定,人员不固定
前台部分
<!-- #include file="conn_me.asp" -->
<%
set cn=server.createobject("adodb.connection")
cn.open connstr
set rs=server.createobject("adodb.recordset")
rs.open "select * from car order by car_zt asc,id asc",cn,1,1
set rsr=server.createobject("adodb.recordset")
rsr.open "select * from people where car_id=0 order by id asc",cn,1,1
set rsp=server.createobject("adodb.recordset")
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>人员派车</title>
<style>
body{font-size:12px}
.clearb{clear:both}
.car_info{width:100%;height:200px;border:0px #ccc solid}
.car_item{width:210px;height:170px;border:1px #ccc dashed;float:left;margin-right:10px;background:#FFFFFF}
.car_total{width:100%;height:24px;line-height:24px;font-size:14px;margin-top:4px;}
.car_title{width:100%;height:22px;line-height:22px;}
.car_people{width:100%;margin-top:5px;padding-left:5px;}
.car_people_item{width:60px;height:25px;border:1px #ccc dashed;float:left;margin-right:4px;line-height:25px;text-align:center;margin-bottom:5px;overflow:hidden;background:#EFF8FC}
.people_info{width:100%;height:200px;border:1px #ccc solid;padding-top:5px;padding-left:5px;background:#EFF8FC}
.people_item{width:80px;height:25px;border:1px #ccc dashed;float:left;margin-right:10px;line-height:25px;background:#FFFFFF}
</style>
<script language="javascript" src="ajaxobject.js"></script>
<script language="javascript">
function ajax(orders,a,b) { //orders功能,a车id,b人id
url="ajax_car.asp?orders="+orders+"&a="+a+"&b="+b+"&r="+new Date().getTime()
xmlhttp_request=new getXMLRequester();
xmlhttp_request.onreadystatechange = function()
{
if (xmlhttp_request.readyState == 4) {
if (xmlhttp_request.status == 200) {
//document.getElementById("cylb").innerHTML=xmlhttp_request.responseText;
var returnstr=xmlhttp_request.responseText;
//--
switch(orders)
{
case 1: //全部下车
<%
while not rs.eof
%>
document.getElementById("car_people_<%=rs("id")%>").innerHTML=""
<%
rs.movenext
wend
%>
document.getElementById("people_info").innerHTML =returnstr
//alert("ok")
break;
case 2: //单人上车
if(returnstr=="0")
{
alert("该车人数已满,请换车!")
}
else
{
//alert(returnstr)
var temp1=returnstr.split("||")
//alert(temp1[1])
document.getElementById("people_info").innerHTML =temp1[0]
document.getElementById("car_people_"+a).innerHTML=temp1[1]
}
break;
case 3: //单车下车
document.getElementById("car_people_"+a).innerHTML=""
document.getElementById("people_info").innerHTML =returnstr
break;
case 4: //单人下车
var temp1=returnstr.split("||")
//alert(temp1[1])
document.getElementById("people_info").innerHTML =temp1[0]
document.getElementById("car_people_"+a).innerHTML=temp1[1]
break;
}
//--
} else {
alert(xmlhttp_request.status);
//alert("发生错误,请与赵水运联系!")
}
}
};
xmlhttp_request.open('GET', url, true);
xmlhttp_request.send(null);
}
function addcar(c1) //上车
{
var t=false;
if(document.all("peopleid").length==null)
{
if(document.getElementById("peopleid").checked==true)
{
ajax(2,c1,document.getElementById("peopleid").value)
}
else
{
alert("请选择人员后点击该按钮!")
}
}
else
{
for(var i=0;i<document.all("peopleid").length;i++)
{
if(document.all("peopleid")[i].checked==true)
{
t=true
ajax(2,c1,document.all("peopleid")[i].value)
}
}
if(t==false)
{
alert("请选择人员后点击该按钮!")
}
}
}
</script>
</head>
<body>
<!-- 车辆信息 begin-->
<div id="car_info" class="car_info">
<%
rs.movefirst
while not rs.eof
%>
<div id="car_<%=rs("id")%>" class="car_item">
<div class="car_title"> <%=rs("car_name")%> 可载<%=rs("car_count")%>人 <%if rs("car_zt")=0 then%>可用<%else%><font color=red>不可用</font><%end if%></span> [<a href="#" οnclick="ajax(3,<%=rs("id")%>,0)"><font color="green">下车</font></a>]</div>
<div class="car_people" id="car_people_<%=rs("id")%>">
<%
rsp.open "select * from people where car_id="&rs("id")&" order by id asc",cn,1,1
while not rsp.eof
%>
<div id="car_people_item" class="car_people_item"><a href="#" οnclick="ajax(4,<%=rs("id")%>,<%=rsp("id")%>)"><font color="red">X</font></a> <%=rsp("people_name")%></div>
<%
rsp.movenext
wend
rsp.close
%>
</div>
</div>
<%
rs.movenext
wend
%>
<div class="car_total clearb">共有:<%=rs.recordcount%>辆车</div>
</div>
<!-- 车辆信息 end -->
<br>
<!-- 人员信息 begin -->
<div id="people_info" class="people_info">
<%
while not rsr.eof
%>
<div class="people_item"> <input type="radio" value="<%=rsr("id")%>" name="peopleid"><%=rsr("people_name")%></div>
<%
rsr.movenext
wend
%>
</div>
<!-- 人员信息 end-->
<!-- 车辆按钮 begin-->
<div class="car_button" id="car_button">
<br>
<%
rs.movefirst
while not rs.eof
%>
<input type="button" value="上‘<%=rs("car_name")%>’的车" οnclick="addcar(<%=rs("id")%>)" <%if rs("car_zt")=0 then%><%else%>disabled<%end if%> id="button_<%=rs("id")%>">
<%
rs.movenext
wend
%>
</div>
<!-- 车辆按钮 end -->
<!--功能区 -->
<br><br>
<div>
<input type="button" value="全部下车" οnclick="ajax(1,0,0)">
</div>
</body>
</html>
后台部分
<%Response.CharSet="gb2312" %>
<!-- #include file="conn_me.asp" -->
<%
a=request.querystring("a") '''车辆id
b=request.querystring("b") '''人员id
if a="" then a=0
if b="" then b=0
a=cint(a)
b=cint(b)
set cn=server.createobject("adodb.connection")
cn.open connstr
orders=request.querystring("orders")
orders=cint(orders)
select case orders
case 1
call clearall
case 2
call addcar
case 3
call clearone
case 4
call clearonepeople
end select
%>
<%
sub clearall '''全清
sql="update people set car_id=0"
cn.execute sql
call refushpeople
%>
<%
end sub
%>
<% sub addcar '''上车
set rs1=server.createobject("adodb.recordset")
rs1.open "select * from car where id="&a,cn,1,1 ''车载人数
if not rs1.eof then
czrs=rs1("car_count")
else
czrs=0
end if
rs1.close
set rs1=nothing
'response.write czrs
set rs2=server.createobject("adodb.recordset")
rs2.open "select count(*) from people where car_id="&a,cn,1,1 '''实际载人数
if not rs2.eof then
sjrs=rs2(0)
else
sjrs=0
end if
rs2.close
set rs2=nothing
if sjrs>=czrs then
response.write "0"
else
sql="update people set car_id="&a&" where id="&b
cn.execute sql
call refushpeople
response.write "||"
call refushcar(a)
end if
end sub
%>
<%
sub clearone ''下车
sql="update people set car_id=0 where car_id="&a
cn.execute sql
call refushpeople
end sub
%>
<%
sub clearonepeople ''单人下车
sql="update people set car_id=0 where id="&b
cn.execute sql
call refushpeople
response.write "||"
call refushcar(a)
end sub
%>
<% sub refushpeople ''刷新人员函数
set rsr=server.createobject("adodb.recordset")
rsr.open "select * from people where car_id=0 order by id asc",cn,1,1
while not rsr.eof
%>
<div class="people_item"> <input type="radio" value="<%=rsr("id")%>" name="peopleid"><%=rsr("people_name")%></div>
<%
rsr.movenext
wend
rsr.close
set rsr=nothing
%>
<%end sub%>
<%
sub refushcar(c1) ''刷新车
set rsp=server.createobject("adodb.recordset")
rsp.open "select * from people where car_id="&c1&" order by id asc",cn,1,1
while not rsp.eof
%>
<div id="car_people_item" class="car_people_item"><a href="#" οnclick="ajax(4,<%=c1%>,<%=rsp("id")%>)"><font color="red">X</font></a> <%=rsp("people_name")%></div>
<%
rsp.movenext
wend
rsp.close
set rsp=nothing
end sub
%>