📄 car_dj.asp

📁 网络办公系统源码
💻 ASP
📖 第 1 页 / 共 2 页
字号:
12 下一页
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="../../config.asp"-->
<!--#include file="../checklogin.asp"-->
<%
	if  ChkAdmin("oa_car")=False then
  		call message("您没有管理车辆的权限","back")
   		call endexit()
	end if
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<link href="../img/css1.css" type=text/css rel=stylesheet>
<SCRIPT language=JavaScript src="../../inc/meizzDate.js"></SCRIPT>
<style type="text/css">
<!--
body {
	margin-left: 0px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
}
.style1 {
	color: #FFFFFF;
	font-weight: bold;
}
.style2 {color: #CC0000}
-->
</style>
</head>
<%
act=request.QueryString("act")
id=replace(request.QueryString("id"),"'","")

companyid=Session("companyid")'公司id
car_num=replace(trim(request.Form("car_num")),"'","")
car_type=replace(trim(request.Form("car_type")),"'","")
car_color=replace(trim(request.Form("car_color")),"'","")
car_buytime=replace(trim(request.Form("car_buytime")),"'","")
car_price=replace(trim(request.Form("car_price")),"'","")

car_gys=replace(trim(request.Form("car_gys")),"'","")
car_glxr=replace(trim(request.Form("car_glxr")),"'","")
car_gtel=replace(trim(request.Form("car_gtel")),"'","")

car_station=replace(trim(request.Form("car_station")),"'","")
car_wlxr=replace(trim(request.Form("car_wlxr")),"'","")
car_wtel=replace(trim(request.Form("car_wtel")),"'","")

car_driver=replace(trim(request.Form("car_driver")),"'","")
car_flag=replace(trim(request.Form("car_flag")),"'","")
car_txt=trim(request.Form("car_txt"))
car_txt=HTMLEncode(car_txt)'sql过滤

insql="insert into oa_car(car_num,car_type,car_color,car_buytime,car_price,car_gys,car_glxr,car_gtel,car_station,car_wlxr,car_wtel,car_driver,car_flag,car_txt,companyid) "& _
"values('"&car_num&"','"&car_type&"','"&car_color&"','"&car_buytime&"','"&car_price&"','"&car_gys&"','"&car_glxr&"','"&car_gtel&"'" & _
",'"&car_station&"','"&car_wlxr&"','"&car_wtel&"','"&car_driver&"','"&car_flag&"','"&car_txt&"',"&companyid&")"

upsql="update oa_car set car_num='"&car_num&"',car_type='"&car_type&"'" & _
",car_color='"&car_color&"',car_buytime='"&car_buytime&"'" & _
",car_price='"&car_price&"',car_gys='"&car_gys&"'" & _
",car_glxr='"&car_glxr&"',car_gtel='"&car_gtel&"'" & _
",car_station='"&car_station&"',car_wlxr='"&car_wlxr&"'" & _
",car_wtel='"&car_wtel&"',car_driver='"&car_driver&"'" & _
",car_flag='"&car_flag&"',car_txt='"&car_txt&"'" & _
" where id="&request.Form("ids")

	if act="add" then
		conn.execute(insql)
		call Message("发布成功","car_list.asp")
	elseif act="edit" then
		conn.execute(upsql)
		call Message("修改成功","car_list.asp")
	end if
%>
<body>
<%
 if act="" then
%>

<form name="myform" method="post" onSubmit="return CheckForm();">
<table width="99%"  border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#F2F2F2" class="tabel1">
  <tr align="center">
    <td height="25" colspan="4" bgcolor="#CC0000"><span class="style1"> 车辆登记 </span></td>
  </tr>
  <tr bgcolor="#F9F9F9">
    <td height="25" align="center"><img src="../img/item_point.gif" width="4" height="7">      <strong>车辆信息</strong></td>
    <td height="25" colspan="3" align="left">&nbsp;</td>
  </tr>
  <tr bgcolor="#F9F9F9">
    <td height="25" align="center"> 车牌号</td>
    <td width="27%" height="25" align="left"><input name="car_num" type="text" class="tabel1" id="car_num">
      <span class="style2">*</span></td>
    <td width="12%" align="center">品牌型号</td>
    <td width="48%" align="left"><input name="car_type" type="text" class="tabel1" id="car_type" size="50">
      <span class="style2">*</span></td>
  </tr>
  <tr bgcolor="#F9F9F9">
    <td height="25" align="center">颜色 </td>
    <td height="25" align="left"><input name="car_color" type="text" class="tabel1" id="car_color">
      <span class="style2">*</span></td>
    <td height="25" align="center"> 购买日期</td>
    <td height="25" align="left"><input name="car_buytime" type="text" class="tabel1" id="car_buytime" onFocus="setday(this)">
      <span class="style2">*</span></td>
  </tr>
  <tr bgcolor="#F9F9F9">
    <td height="25" align="center"> 购买价格 </td>
    <td height="25" align="left"><input name="car_price" type="text" class="tabel1" id="car_price">
      <span class="style2">*</span></td>
    <td height="25" align="center">&nbsp;</td>
    <td height="25" align="left">&nbsp;</td>
  </tr>
  <tr bgcolor="#F9F9F9">
    <td width="13%" height="25" align="center"> <img src="../img/item_point.gif" width="4" height="7"> <strong>供应商信息</strong></td>
    <td height="25" colspan="3" align="left">&nbsp;      </td>
    </tr>
  
  <tr bgcolor="#F9F9F9">
    <td height="25" align="center"> 供应商</td>
    <td height="25" colspan="3" align="left"><input name="car_gys" type="text" class="tabel1" id="car_gys" size="50">
      <span class="style2">*</span></td>
    </tr>
  
  <tr bgcolor="#F9F9F9">
    <td height="25" align="center"> 联系人</td>
    <td height="25" align="left"><input name="car_glxr" type="text" class="tabel1" id="car_glxr">
      <span class="style2">*</span></td>
    <td height="25" align="center"> 联系电话</td>
    <td height="25" align="left"><input name="car_gtel" type="text" class="tabel1" id="car_gtel">
      <span class="style2">*</span></td>
  </tr>
  <tr bgcolor="#F9F9F9">
    <td height="25" align="center"><img src="../img/item_point.gif" width="4" height="7"> <strong>维护站信息</strong></td>
    <td height="25" align="left">&nbsp;</td>
    <td height="25" align="left">&nbsp;</td>
    <td height="25" align="left">&nbsp;</td>
  </tr>
  <tr bgcolor="#F9F9F9">
    <td height="25" align="center"> 维修站</td>
    <td height="25" colspan="3" align="left"><input name="car_station" type="text" class="tabel1" id="car_station" size="50">
      <span class="style2">*</span></td>
    </tr>
  <tr bgcolor="#F9F9F9">
    <td height="25" align="center"> 联系人</td>
    <td height="25" align="left"><input name="car_wlxr" type="text" class="tabel1" id="car_wlxr">
      <span class="style2">*</span></td>
    <td height="25" align="center"> 联系电话</td>
    <td height="25" align="left"><input name="car_wtel" type="text" class="tabel1" id="car_wtel">
      <span class="style2">*</span></td>
  </tr>
  <tr bgcolor="#F9F9F9">
    <td height="25" align="center"><img src="../img/item_point.gif" width="4" height="7">      <strong>其它信息</strong></td>
    <td height="25" align="left">&nbsp;</td>
    <td height="25" align="center">&nbsp;</td>
    <td height="25" align="left">&nbsp;</td>
  </tr>
  <tr bgcolor="#F9F9F9">
    <td height="25" align="center"> 驾驶员</td>
    <td height="25" align="left"><input name="car_driver" type="text" class="tabel1" id="car_driver">
      <span class="style2">*</span></td>
    <td height="25" align="center">状态</td>
    <td height="25" align="left"><input name="car_flag" type="radio" value="正常" checked>
      正常      <input type="radio" name="car_flag" value="报废">
      报废</td>
  </tr>
  <tr bgcolor="#F9F9F9">
    <td height="25" align="center"> 备注</td>
    <td height="25" colspan="3" align="left"><input name="car_txt" type="text" class="tabel1" id="car_txt" size="70"></td>
    </tr>
  <tr bgcolor="#F9F9F9">
    <td height="25" colspan="4" align="center"><input name="Submit2" type="submit" class="bon" value="提交">
      　
      <input name="Submit3" type="reset" class="bon" value="重置">
      　
      <input name="Submit4" type="button" class="bon" id="Submit" value="返回" onClick="window.history.go(-1)"></td>
    </tr>
</table>
</form>
<%
elseif act="edits" then
 sql="select * from oa_car where id="&id
 set rs=conn.execute(sql)
  if not rs.eof then
%>
<form name="myform" method="post" action="car_dj.asp?act=edit" onSubmit="return CheckForm();">
<table width="99%"  border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#F2F2F2" class="tabel1">
  <tr align="center">
    <td height="25" colspan="4" bgcolor="#CC0000"><span class="style1"> 修改车辆信息 </span></td>
  </tr>
  <tr bgcolor="#F9F9F9">
    <td height="25" align="center"><img src="../img/item_point.gif" width="4" height="7">      <strong>车辆信息</strong></td>
    <td height="25" colspan="3" align="left">&nbsp;</td>
  </tr>
  <tr bgcolor="#F9F9F9">
    <td height="25" align="center"> 车牌号</td>
    <td width="27%" height="25" align="left"><input name="car_num" type="text" class="tabel1" id="car_num" value="<%=trim(rs("car_num"))%>">
      <span class="style2">*</span></td>
    <td width="12%" align="center">品牌型号</td>
    <td width="48%" align="left"><input name="car_type" type="text" class="tabel1" id="car_type" size="50" value="<%=trim(rs("car_type"))%>">
      <span class="style2">*</span></td>
  </tr>
  <tr bgcolor="#F9F9F9">
    <td height="25" align="center">颜色 </td>
    <td height="25" align="left"><input name="car_color" type="text" class="tabel1" id="car_color" value="<%=trim(rs("car_color"))%>">
      <span class="style2">*</span></td>
    <td height="25" align="center"> 购买日期</td>
    <td height="25" align="left"><input name="car_buytime" type="text" class="tabel1" id="car_buytime" onFocus="setday(this)" value="<%=trim(rs("car_buytime"))%>">
      <span class="style2">*</span></td>
  </tr>
  <tr bgcolor="#F9F9F9">
    <td height="25" align="center"> 购买价格 </td>
    <td height="25" align="left"><input name="car_price" type="text" class="tabel1" id="car_price" value="<%=trim(rs("car_price"))%>">
      <span class="style2">*</span></td>
    <td height="25" align="center">&nbsp;</td>
    <td height="25" align="left">&nbsp;</td>
  </tr>
  <tr bgcolor="#F9F9F9">
    <td width="13%" height="25" align="center"> <img src="../img/item_point.gif" width="4" height="7"> <strong>供应商信息</strong></td>
    <td height="25" colspan="3" align="left">&nbsp;      </td>
    </tr>
  
  <tr bgcolor="#F9F9F9">
    <td height="25" align="center"> 供应商</td>
    <td height="25" colspan="3" align="left"><input name="car_gys" type="text" class="tabel1" id="car_gys" size="50" value="<%=trim(rs("car_gys"))%>">
      <span class="style2">*</span></td>
    </tr>
  
  <tr bgcolor="#F9F9F9">
    <td height="25" align="center"> 联系人</td>
    <td height="25" align="left"><input name="car_glxr" type="text" class="tabel1" id="car_glxr" value="<%=trim(rs("car_glxr"))%>">
      <span class="style2">*</span></td>
    <td height="25" align="center"> 联系电话</td>
    <td height="25" align="left"><input name="car_gtel" type="text" class="tabel1" id="car_gtel" value="<%=trim(rs("car_gtel"))%>">
      <span class="style2">*</span></td>
  </tr>
12 下一页
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -