<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
|
<%Session.CodePage=65001%>
|
<!--#include virtual="/inc/chkadmin.gds"-->
|
<!--#include virtual="/inc/function.gds"-->
|
<%
|
if isDepartment("0505")=0 then
|
Response.Redirect "/"
|
Response.End()
|
end If
|
|
searchTXT=SafeRequest(Request("searchTXT"))
|
|
Set rs = Server.CreateObject("ADODB.Recordset")
|
'默认显示字段
|
If OrdState="" Then OrdState=0
|
If OrdClassList="" Then OrdClassList="0"
|
If OrdClassList="0" Then
|
OrdClassName="未审核"
|
ElseIf OrdClassList="1" Then
|
OrdClassName="已审核"
|
Else
|
OrdClassName="全部"
|
End if
|
|
'各种返回信息
|
SystemMessageType=trim(Request("SystemMessageType"))
|
SMT=trim(Request("SMT"))
|
if SystemMessageType<>"" then
|
if SMT="1" then
|
SystemMessageTXT="请选择需要操作的车辆"
|
elseif SMT="2" then
|
SystemMessageTXT="单据状态错误或重复提交"
|
elseif SMT="3" then
|
SystemMessageTXT="加油记录提交完成!!"
|
elseif SMT="4" then
|
SystemMessageTXT="请选择需要修改的加油记录!!"
|
elseif SMT="5" then
|
SystemMessageTXT="删除完成!!"
|
elseif SMT="6" then
|
SystemMessageTXT="请选择需要删除的加油记录!!"
|
end if
|
end if
|
|
|
If OrdState<>"0" then
|
OrdListName = ServiceOrdStateA(OrdState)&"记录"
|
Else
|
OrdListName = "加油记录"
|
End If
|
|
OrdDateType=SafeRequest(Request("OrdDateType"))
|
OrdDateStart=SafeRequest(Request("OrdDateStart"))
|
OrdDateEnd=SafeRequest(Request("OrdDateEnd"))
|
If OrdDateType="" Then
|
OrdDateType=4
|
OrdDateTop=" top 20 "
|
End If
|
If OrdDateType="0" then
|
If OrdDateStart="" And OrdDateEnd="" Then
|
OrdDateStart=Date()
|
OrdDateEnd=Date()&" 00:00"
|
ElseIf OrdDateStart<>"" And OrdDateEnd="" Then
|
OrdDateEnd=OrdDateStart
|
ElseIf OrdDateStart="" And OrdDateEnd<>"" Then
|
OrdDateStart=OrdDateEnd
|
End If
|
If Cdate(OrdDateStart)>Cdate(OrdDateEnd) Then
|
OrdDateStart1=OrdDateStart
|
OrdDateStart=OrdDateEnd
|
OrdDateEnd=OrdDateStart1
|
End if
|
If OrdDateStart=OrdDateEnd Then
|
OrdDateStart=FORMATDATETIME(OrdDateStart,vbShortDate)
|
OrdDateTypeName=OrdDateStart
|
OrdDateTypeName1=OrdDateTypeName
|
OrdDateEnd=FORMATDATETIME(OrdDateEnd,vbShortDate)
|
Else
|
OrdDateTypeName=OrdDateStart&" 至 "&OrdDateEnd
|
OrdDateTypeName1="时间段"
|
End If
|
SqlOrdDateType="between '"&OrdDateStart&"' and '"&OrdDateEnd&" 23:59:59'"
|
|
Else
|
sql="select vID,vtext,vOrder2 from dictionary where vType>=1 and vtitle='OrdDateType' and vID="&OrdDateType
|
rs.open Sql,objConn,1,1
|
If not rs.Eof Then
|
OrdDateTypeName = rs("vtext")
|
OrdDateTypeName1=OrdDateTypeName
|
SqlOrdDateType = rs("vOrder2")
|
Else
|
OrdDateType=4
|
OrdDateTypeName="本月"
|
OrdDateTypeName1=OrdDateTypeName
|
SqlOrdDateType="between DATEADD(mm,DATEDIFF(mm,0,getdate()),0) and dateadd(ms,-3,DATEADD(mm,DATEDIFF(m,0,getdate())+1,0))"
|
End If
|
rs.close()
|
End If
|
'时间段列表
|
sql="select vID,vtext from dictionary where vType>=1 and vtitle='OrdDateType' order by vOrder"
|
rs.open Sql,objConn,1,1
|
do while not rs.Eof
|
OrdDateTypes = OrdDateTypes & rs("vID") &","& rs("vtext") & "|"
|
rs.movenext
|
Loop
|
rs.close()
|
OrdDateTypes = left(OrdDateTypes,len(OrdDateTypes)-1)
|
OrdDateTypesPS = SPLIT(OrdDateTypes,"|")
|
|
page_URL="&OrdDateType="&OrdDateType&"&OrdDateStart="&OrdDateStart&"&OrdDateEnd="&OrdDateEnd&"&searchTXT="&searchTXT&""
|
%>
|
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
|
<html xmlns="http://www.w3.org/1999/xhtml">
|
<head>
|
<title><%=LindemanAdmin%></title>
|
<!--#include virtual="/inc/ccs.gds"-->
|
</head>
|
<body onkeydown="xKeyEvent(event)">
|
<!--#INCLUDE FILE="menu_header.gds" -->
|
<!-- content -->
|
<div id="content">
|
<!--#INCLUDE FILE="Car_menu_left.gds" -->
|
<!-- content / right -->
|
<div id="right">
|
<!-- table -->
|
<div class="box">
|
<!-- box / title -->
|
<div class="title">
|
<h5><%If searchTXT<>"" then%>加油记录查询 <%=searchTXT%><%else%><%=OrdDateTypeName1&" "&OrdListName%><%End if%></h5>
|
<ul class="links">
|
<%If isDepartment("050201")=1 Then%><li><a onclick="javascript:JS_CarGasAdd();">新建</a></li><%End If%>
|
<%If isDepartment("050201")=1 Then%><li><a onClick="javascript:JS_CarGasDel()">删除</a></li><%End If%>
|
<li><a href="CarGas_csv.gds?1=1<%=page_URL%>">导出csv</a></li>
|
<li>
|
<div class="search">
|
<div id="Date_container" class="select-container" style="overflow: hidden;cursor:pointer" onclick="JS_OrdDateType()">
|
<span class="select-content" style="width: 46px;">期间：<%=OrdDateTypeName%></span><span class="arrow" id="Date_arrow"></span>
|
</div>
|
<div id="Date_list" class="select-list scroll-pane" style="overflow: hidden; position: absolute; background-color: white; width: 65px; display: none;background-position: initial initial; background-repeat: initial initial;margin-left: 35px;">
|
<div class="jspContainer" style="width: 63px; ">
|
<div style="padding: 0px; top: 0px; width: 63px;">
|
<%for z = 0 to UBOUND(OrdDateTypesPS)
|
OrdDateTypesPS1=SPLIT(OrdDateTypesPS(z),",")
|
vID=OrdDateTypesPS1(0)
|
vtext=OrdDateTypesPS1(1)
|
%>
|
<span title="<%=vtext%>" onmouseover="JS_OrdDateTypeMouseover('OrdDateType_<%=vID%>')" onclick="JS_OrdDateTypeJump('<%=vID%>')" id="OrdDateType_<%=vID%>" class="list-option<%if vID=OrdDateType then Response.Write " option"%>"><%=vtext%></span>
|
<%next%>
|
<span title="自定义" onmouseover="JS_OrdDateTypeMouseover('OrdDateType_0')" onclick="JS_OrdDateTypeCreateOpen()" id="OrdDateType_0" name="OrdDateType" class="list-option">自定义</span>
|
</div>
|
</div>
|
</div>
|
</div>
|
</li>
|
<input name="OrdDateType" type="hidden" value="<%=OrdDateType%>">
|
<input name="OrdDateStart" type="hidden" value="<%=OrdDateStart%>">
|
<input name="OrdDateEnd" type="hidden" value="<%=OrdDateEnd%>">
|
<script LANGUAGE="javascript">
|
//审核
|
function form1_AP_1(){
|
if(confirm("确定审核所选费用单?"))
|
{
|
document.form1.action = "admin_save.gds";
|
document.form1.admin_save.value="34"
|
document.form1.Car_Check.value="1"
|
form1.submit();
|
}
|
}
|
//反审核
|
function form1_AP_0(){
|
if(confirm("确定反审核所选费用单?"))
|
{
|
document.form1.action = "admin_save.gds";
|
document.form1.admin_save.value="59"
|
document.form1.Car_Check.value="0"
|
form1.submit();
|
}
|
}
|
//作废
|
function JS_CarGasDel(){
|
if(confirm("确定删除所选加油记录?"))
|
{
|
document.form1.action = "admin_save.gds";
|
document.form1.admin_save.value="59"
|
document.form1.Car_Check.value="-1"
|
form1.submit();
|
}
|
}
|
|
//新建字典-关闭上传窗口
|
function JS_CarCreateClose()
|
{
|
CarCreate.style.display="none";
|
}
|
//新建字典-保存
|
function JS_CarCreateSave()
|
{
|
form2.submit();
|
}
|
//受理单调单查询
|
function JS_CarSearch()
|
{
|
CarLicense=document.form2.CarLicense.value;
|
window.HiddenFrame.location.replace('CarData_Search.gds?CarLicense='+CarLicense);
|
}
|
//显示车牌号
|
function JS_CarData(CarID,CarLicense)
|
{
|
document.form2.GasCarID.value=CarID;
|
if (CarLicense=='车牌号错误')
|
{
|
document.getElementById('GasMileage').className = 'valid';
|
document.getElementById('GasMileage').readOnly=true;
|
document.getElementById('GasVolume').className = 'valid';
|
document.getElementById('GasVolume').readOnly=true;
|
document.getElementById('GasPrice').className = 'valid';
|
document.getElementById('GasPrice').readOnly=true;
|
document.getElementById('GasSumPrice').className = 'valid';
|
document.getElementById('GasSumPrice').readOnly=true;
|
document.getElementById('GasSumPrice').className = 'valid';
|
document.getElementById('GasSumPrice').readOnly=true;
|
document.getElementById('GasStation').className = 'valid';
|
document.getElementById('GasStation').readOnly=true;
|
document.getElementById('GasRemarks').className = 'valid';
|
document.getElementById('GasRemarks').readOnly=true;
|
alert("车牌号错误!!");
|
}
|
else
|
{
|
document.getElementById('GasMileage').className = '';
|
document.getElementById('GasMileage').readOnly=false;
|
document.getElementById('GasVolume').className = '';
|
document.getElementById('GasVolume').readOnly=false;
|
document.getElementById('GasPrice').className = '';
|
document.getElementById('GasPrice').readOnly=false;
|
document.getElementById('GasSumPrice').className = '';
|
document.getElementById('GasSumPrice').readOnly=false;
|
document.getElementById('GasStation').className = '';
|
document.getElementById('GasStation').readOnly=false;
|
document.getElementById('GasRemarks').className = '';
|
document.getElementById('GasRemarks').readOnly=false;
|
document.form2.CarLicense.value=CarLicense;
|
}
|
}
|
//新建单据信息
|
function JS_CarGasAdd()
|
{
|
CarCreate.style.display='block';
|
document.getElementById('EditPhotoTXT').innerHTML = '新建加油记录';
|
document.form2.admin_save.value='57';
|
document.form2.CarGasID.value='';
|
document.form2.GasCarID.value='';
|
document.getElementById('GasMileage').value = '';
|
document.getElementById('GasMileage').className = 'valid';
|
document.getElementById('GasMileage').readOnly=true;
|
document.getElementById('GasVolume').value = '';
|
document.getElementById('GasVolume').className = 'valid';
|
document.getElementById('GasVolume').readOnly=true;
|
document.getElementById('GasPrice').value = '';
|
document.getElementById('GasPrice').className = 'valid';
|
document.getElementById('GasPrice').readOnly=true;
|
document.getElementById('GasSumPrice').value = '';
|
document.getElementById('GasSumPrice').className = 'valid';
|
document.getElementById('GasSumPrice').readOnly=true;
|
document.getElementById('GasStation').value = '';
|
document.getElementById('GasStation').className = 'valid';
|
document.getElementById('GasStation').readOnly=true;
|
document.getElementById('GasRemarks').value = '';
|
document.getElementById('GasRemarks').className = 'valid';
|
document.getElementById('GasRemarks').readOnly=true;
|
document.getElementById('GasDate').value = '';
|
document.form2.CarLicense.value='';
|
}
|
|
//显示修改单据信息
|
function JS_CarGasEdit(CarGasID,CarID,CarLicense,GasDate,GasMileage,GasVolume,GasPrice,GasSumPrice,GasType,GasStation,GasPayment,GasRemarks)
|
{
|
CarCreate.style.display='block';
|
document.getElementById('EditPhotoTXT').innerHTML = '修改加油记录';
|
document.form2.admin_save.value='58';
|
document.form2.CarGasID.value=CarGasID;
|
document.form2.GasCarID.value=CarID;
|
document.getElementById('GasDate').value = GasDate;
|
document.getElementById('GasMileage').value = GasMileage;
|
document.getElementById('GasMileage').className = '';
|
document.getElementById('GasMileage').readOnly=false;
|
document.getElementById('GasVolume').value = GasVolume;
|
document.getElementById('GasVolume').className = '';
|
document.getElementById('GasVolume').readOnly=false;
|
|
document.getElementById('GasPrice').value = GasPrice;
|
document.getElementById('GasPrice').className = '';
|
document.getElementById('GasPrice').readOnly=false;
|
document.getElementById('GasSumPrice').value = GasSumPrice;
|
document.getElementById('GasSumPrice').className = '';
|
document.getElementById('GasSumPrice').readOnly=false;
|
document.getElementById('GasSumPrice').value = GasSumPrice;
|
document.getElementById('GasSumPrice').className = '';
|
document.getElementById('GasSumPrice').readOnly=false;
|
document.getElementById('GasType').value = GasType;
|
document.getElementById('GasType').className = '';
|
document.getElementById('GasType').readOnly=false;
|
document.getElementById('GasStation').value = GasStation;
|
document.getElementById('GasStation').className = '';
|
document.getElementById('GasStation').readOnly=false;
|
document.getElementById('GasPayment').value = GasPayment;
|
document.getElementById('GasPayment').className = '';
|
document.getElementById('GasPayment').readOnly=false;
|
document.getElementById('GasRemarks').value = GasRemarks.replace("<BR>",'\r\n');
|
document.getElementById('GasRemarks').className = '';
|
document.getElementById('GasRemarks').readOnly=false;
|
document.form2.CarLicense.value=CarLicense;
|
}
|
//油价计算
|
function JS_GasPrice(KeyId)
|
{
|
var GasVolume=document.getElementById('GasVolume').value;
|
var GasPrice=document.getElementById('GasPrice').value;
|
var GasSumPrice=document.getElementById('GasSumPrice').value;
|
if (KeyId=='GasPrice' && GasVolume!=''){KeyId='GasVolume'} else if (KeyId=='GasPrice' && GasSumPrice!=''){KeyId='GasSumPrice'}
|
if (GasPrice!='')
|
{
|
if (KeyId=='GasVolume')
|
{
|
document.getElementById('GasSumPrice').value=toDecimal(GasVolume*GasPrice);
|
}
|
else if (KeyId=='GasSumPrice')
|
{
|
document.getElementById('GasVolume').value=toDecimal(GasSumPrice/GasPrice);
|
}
|
}
|
}
|
function toDecimal(x) {
|
var f = parseFloat(x);
|
if (isNaN(f)) {
|
return;
|
}
|
f = Math.round(x*100)/100;
|
return f;
|
}
|
</script>
|
|
<div class="dialogJ dialogJfix dialogJshadow" id="OrdDateTypeCreate" style="width: 440px;right: 80px; top: 150px;height:80px ;display:none;">
|
<div class="dialogJtitle">
|
<a href="javascript:JS_OrdDateTypeCreateClose();" class="dialogJclose" title="关闭本窗口"> </a>
|
<span class="dialogJtxt" id="EditPhotoTXT">请选择时间段</span>
|
</div>
|
<div class="dialogJcontent" style="margin-left: 5px;margin-right:5px;">
|
<div class="input" style="float:left;margin-top: 10px;margin-left: 5px;" id="two-inputs">
|
期间：
|
<input type="text" id="OrdDateStart" name="OrdDateStart" class="date" style="width:138px;" value="<%=OrdDateStart%>">
|
至
|
<input type="text" id="OrdDateEnd" name="OrdDateEnd" class="date" style="width:138px;" value="<%=OrdDateEnd%>">
|
<input type="button" class="dialogJbtn first-child" onclick="JS_OrdDateJump()" value="查询">
|
</div>
|
</div>
|
</div>
|
<!--时间选择js liang------------->
|
<link rel="stylesheet" href="css/daterangepicker.css">
|
<script src="js/jquery-1.12.3.min.js"></script>
|
<script src="js/moment.min.js"></script>
|
<script src="js/jquery.daterangepicker.js"></script>
|
<script>
|
$(function()
|
{
|
$('#two-inputs').dateRangePicker(
|
{
|
separator : ' to ',
|
getValue: function()
|
{
|
if ($('#OrdDateStart').val() && $('#OrdDateEnd').val() )
|
return $('#OrdDateStart').val() + ' to ' + $('#OrdDateEnd').val();
|
else
|
return '';
|
},
|
setValue: function(s,s1,s2)
|
{
|
$('#OrdDateStart').val(s1);
|
$('#OrdDateEnd').val(s2);
|
}
|
|
});
|
});
|
</script>
|
<!--时间选择js liang------------->
|
<script type="text/javascript">
|
//时间表列显示下拉菜单
|
function JS_OrdDateType(){
|
if (Date_container.className!="select-container select-container-show-list"){
|
Date_container.className="select-container select-container-show-list";
|
Date_arrow.className="arrow arrow-up";
|
Date_list.style.display="block";
|
OrdClass_container.className="select-container";
|
OrdClass_arrow.className="arrow";
|
OrdClass_list.style.display="none";
|
OrdDateTypeCreate.style.display="none";
|
}
|
else {
|
Date_container.className="select-container";
|
Date_arrow.className="arrow";
|
Date_list.style.display="none";
|
}
|
}
|
//时间表列指针移动到下拉菜单
|
function JS_OrdDateTypeMouseover(id){
|
var d=document.getElementById(id);
|
<%for z = 0 to UBOUND(OrdDateTypesPS)
|
OrdDateTypesPS1=SPLIT(OrdDateTypesPS(z),",")
|
vID=OrdDateTypesPS1(0)
|
vtext=OrdDateTypesPS1(1)
|
%>
|
document.getElementById("OrdDateType_<%=vID%>").className="list-option";
|
<%next%>
|
document.getElementById("OrdDateType_0").className="list-option";
|
d.className="list-option option";
|
}
|
//自定义时间-打开窗口
|
function JS_OrdDateTypeCreateOpen()
|
{
|
JS_OrdDateType();
|
OrdDateTypeCreate.style.display="block";
|
}
|
//自定义时间-关闭窗口
|
function JS_OrdDateTypeCreateClose()
|
{
|
JS_OrdDateType();
|
OrdDateTypeCreate.style.display="none";
|
}
|
//自定义时间-确定时间
|
function JS_OrdDateTypeCreateSave()
|
{
|
document.getElementById('ServiceOrdTraStreet').value=document.getElementById('Duration').value;
|
document.getElementById('ServiceOrdTraEnd').value=document.getElementById('ServiceOrdTraEnd').value;
|
document.getElementById('ServiceOrdTraStreetCoo').value=results.sw.point.lng + ','+ results.sw.point.lat; //起点坐标
|
document.getElementById('ServiceOrdTraEndCoo').value=results.Lu.point.lng + ','+ results.Lu.point.lat; //起点坐标
|
}
|
//时间类表列转跳
|
function JS_OrdDateJump(id){
|
var OrdDateStart=document.getElementById("OrdDateStart").value;
|
var OrdDateEnd=document.getElementById("OrdDateEnd").value;
|
var searchTXT=document.getElementById("searchTXT").value;
|
window.location.href='CarGas.gds?h_menu1_1=1&OrdState=<%=OrdState%>&OrdClassList=<%=OrdClassList%>&OrdDateType=0&searchTXT='+searchTXT+'&OrdDateStart='+OrdDateStart+'&OrdDateEnd='+OrdDateEnd;
|
}
|
//自定义时间转跳
|
function JS_OrdDateTypeJump(id){
|
var searchTXT=document.getElementById("searchTXT").value;
|
window.location.href='CarGas.gds?h_menu1_1=1&OrdState=<%=OrdState%>&OrdClassList=<%=OrdClassList%>&searchTXT='+searchTXT+'&OrdDateType='+id;
|
}
|
|
//时间表列转跳
|
function JS_OrdClassTypeJump(id){
|
var searchTXT=document.getElementById("searchTXT").value;
|
window.location.href='CarGas.gds?h_menu1_1=1&OrdState=<%=OrdState%>&OrdDateType=<%=OrdDateType%>&searchTXT='+searchTXT+'&OrdClassList='+id;
|
}
|
|
</script>
|
<!-- end box / title -->
|
|
<div class="dialogJ dialogJfix dialogJshadow" id="CarCreate" style="width:500px; right: 300px; top: 150px;display:none;">
|
|
<div class="dialogJtitle">
|
<a href="javascript:JS_CarCreateClose();" class="dialogJclose" title="关闭本窗口"> </a>
|
<span class="dialogJtxt" id="EditPhotoTXT">加油记录</span>
|
</div>
|
<form id="form2" name="form2" action="admin_save.gds" method="post">
|
<input name="admin_save" type="hidden" value="57">
|
<input name="searchTXT" type="hidden" value="<%=searchTXT%>">
|
<input name="CarGasID" type="hidden" value="">
|
<input name="GasCarID" type="hidden" value="">
|
<input name="page" type="hidden" value="<%=acc1%>">
|
<div class="dialogJcontent">
|
<div class="dialogJbody" id="dialogJbody" style="height: 400px;">
|
<div class="modify-album-name">
|
<span>车牌号码：</span>
|
<input id="CarLicense" name="CarLicense" type="text" value="<%=CarLicense%>" style="width: 165px;" maxlength="99/"><input type="button" style="text-indent:initial;" class="dialogJbtn first-child" onclick="JS_CarSearch()" value="调用">
|
</div>
|
<div class="modify-album-name">
|
<span>加油日期：</span>
|
<input type="text" id="GasDate" name="GasDate" class="date" style="width:140px;" value="">
|
</div>
|
<div class="modify-album-name">
|
<span>当前里程：</span>
|
<input id="GasMileage" name="GasMileage" type="text" value="" maxlength="99/" style="width: 80px;" readonly="true" class="valid"><span> 公里</span>
|
</div>
|
<div class="modify-album-name">
|
<span style="margin-left: 12px;">加油量：</span>
|
<input id="GasVolume" name="GasVolume" type="text" value="" maxlength="99/" style="width: 60px;" onKeyDown="JS_GasPrice('GasVolume')" onKeyUp="JS_GasPrice('GasVolume')" readonly="true" class="valid"><span> 升</span>
|
<span> 单价：</span>
|
<input id="GasPrice" name="GasPrice" type="text" value="" maxlength="99/" style="width: 60px;" onKeyDown="JS_GasPrice('GasPrice')" onKeyUp="JS_GasPrice('GasPrice')" readonly="true" class="valid"><span> 元</span>
|
<span> 总额：</span>
|
<input id="GasSumPrice" name="GasSumPrice" type="text" value="" maxlength="99/" style="width: 60px;" onKeyDown="JS_GasPrice('GasSumPrice')" onKeyUp="JS_GasPrice('GasSumPrice')" readonly="true" class="valid"><span> 元</span>
|
</div>
|
<div class="modify-album-name">
|
<span>加油类型：</span>
|
<select name="GasType" id="GasType" style="padding: 5px 0 5px 8px;">
|
<option value="">请选择</option>
|
<%sql="select vID,vtext from dictionary where vtitle='GasType' and vType>=1 order by vOrder"
|
rs.open Sql,objConn,1,1
|
do while not rs.Eof%>
|
<option value="<%=rs("vtext")%>"><%=rs("vtext")%></option>
|
<%rs.movenext
|
Loop
|
rs.close()%>
|
</select>
|
</div>
|
<div class="modify-album-name">
|
<span style="margin-left: 12px;">加油站：</span>
|
<input id="GasStation" name="GasStation" type="text" value="" maxlength="99/" style="width: 370px;" readonly="true" class="valid">
|
</div>
|
<div class="modify-album-name">
|
<span>支付方式：</span>
|
<select name="GasPayment" id="GasPayment" style="padding: 5px 0 5px 8px;">
|
<option value="">请选择</option>
|
<%sql="select vID,vtext from dictionary where vtitle='GasPayment' and vType>=1 order by vOrder"
|
rs.open Sql,objConn,1,1
|
do while not rs.Eof%>
|
<option value="<%=rs("vtext")%>"><%=rs("vtext")%></option>
|
<%rs.movenext
|
Loop
|
rs.close()%>
|
</select>
|
</div>
|
<div class="modify-album-name">
|
<span style="margin-left: 24px;">备注：</span>
|
<textarea name="GasRemarks" id="GasRemarks" style="width: 370px;height: 100px;" readonly="true" class="valid"></textarea>
|
</div>
|
</div>
|
</div>
|
</form>
|
<div class="dialogJanswers" style="padding: 130px 20px 13px 18px;">
|
<input type="button" class="dialogJbtn first-child" onclick="JS_CarCreateSave()" value="确定">
|
<input type="button" class="dialogJbtn" onclick="JS_CarCreateClose()" value="取消">
|
</div>
|
</div>
|
<div class="search">
|
<form action="?" method="post">
|
<div class="input">
|
<input type="text" id="searchTXT" name="searchTXT" value="<%=searchTXT%>" />
|
</div>
|
<div class="button">
|
<input type="submit" name="submit" value="搜索" />
|
</div>
|
</form>
|
</div>
|
</ul>
|
</div>
|
<!-- end box / title -->
|
<%
|
acc1=request("page")
|
if acc1=empty then acc1=clng(1)
|
QuantityInt = 20
|
acc2=0
|
acc3=0
|
|
if searchTXT<>"" Then
|
searchSql=" and (CarLicense like '%"&searchTXT&"%' or GasStation like '%"&searchTXT&"%' or GasRemarks like '%"&searchTXT&"%') "
|
else
|
searchSql=""
|
end If
|
|
sql="select *,GasOldMileage=(select top 1 GasMileage from CarGas as b where a.GasCarID=b.GasCarID and a.GasDate>b.GasDate and b.GasState>=0 order by b.GasDate desc) from CarGas as a,CarData where CarID=GasCarID and GasState>=0 and GasDate "&SqlOrdDateType&searchSql&" order by id desc"
|
'Response.Write sql
|
rs.open sql,objConn,1,1
|
if not rs.eof then
|
rs.pagesize=QuantityInt
|
rs.absolutepage=acc1
|
acc2=rs.pagecount
|
acc3=rs.recordcount
|
else
|
SystemMessageType=2
|
SystemMessageTXT="数据库中相关无数据！"
|
end if
|
%>
|
<!--#include virtual="/inc/SystemMessages.gds" -->
|
<script>
|
//全选按钮点击事件
|
function allCheck(allBoxName,itemBoxName) {
|
|
if($("input[name="+allBoxName+"]").prop("checked")){
|
$("input[name=" + itemBoxName + "]").prop("checked",true);
|
} else {
|
$("input[name=" + itemBoxName + "]").prop("checked",false);
|
}
|
}
|
|
//子项按钮点击事件
|
function itemCheck(allBoxName,itemBoxName) {
|
var hasNoSel = false;
|
var itemBoxArray = $("input[name="+itemBoxName+"]");
|
itemBoxArray.each(function() {
|
if(!$(this).prop("checked")){
|
hasNoSel = true;
|
}
|
});
|
if(hasNoSel){
|
$("input[name="+allBoxName+"]").prop("checked",false);
|
} else {
|
$("input[name="+allBoxName+"]").prop("checked",true);
|
}
|
}
|
</script>
|
<div class="table" style="overflow:auto">
|
<form id="form1" name="form1" action="" method="post">
|
<input name="admin_save" type="hidden" value="52">
|
<input name="Car_Check" type="hidden" value="">
|
<input name="searchTXT" type="hidden" value="<%=searchTXT%>">
|
<input name="page" type="hidden" value="<%=acc1%>">
|
<table>
|
<thead>
|
<tr style="white-space: nowrap;">
|
<th class="selected"><input type="checkbox" class="checkall" name="checkAll" onclick="allCheck('checkAll','CarGasID')" /></th>
|
<th>单据编号</th>
|
<th>加油日期</th>
|
<th>车牌</th>
|
<th>上次加油里程</th>
|
<th>当前里程</th>
|
<th>里程差值</th>
|
<th>加油量</th>
|
<th>单价</th>
|
<th>总额</th>
|
<th>类型</th>
|
<th>加油站</th>
|
<th>支付方式</th>
|
<th>备注</th>
|
<th class="last">操作人</th>
|
</tr>
|
</thead>
|
<tbody>
|
|
<%i=1
|
do while not rs.Eof and i<=QuantityInt
|
CarGasID = rs("id") '加油记录号
|
GasCarID = rs("GasCarID") '车辆ID
|
GasDate = rs("GasDate") '加油时间
|
CarLicense = rs("CarLicense") '车牌
|
GasMileage = rs("GasMileage") '当前里程
|
GasOldMileage = rs("GasOldMileage") '上次加油里程
|
GasVolume = rs("GasVolume") '加油量
|
GasPrice = rs("GasPrice") '单价
|
GasSumPrice = rs("GasSumPrice") '总金额
|
GasType = rs("GasType") '加油类型
|
GasStation = rs("GasStation") '加油站
|
GasPayment = rs("GasPayment") '支付方式
|
GasRemarks = rs("GasRemarks") '备注
|
|
OAID = rs("OAID")
|
OATime = rs("OATime")
|
GasState = rs("GasState")
|
|
GasRemarks = Replace(GasRemarks,CHR(10),"")
|
GasRemarks = Replace(GasRemarks,CHR(13),"<BR>")
|
If GasOldMileage<>"" Then
|
GasOldMileageTXT = GasOldMileage&"公里"
|
Else
|
GasOldMileageTXT = "--"
|
End If
|
If GasMileage<>"" Then
|
GasMileageTXT = GasMileage&"公里"
|
Else
|
GasMileageTXT = "--"
|
End If
|
If GasOldMileage<>"" And GasMileage<>"" Then
|
GasMileageDiffTXT=(GasMileage-GasOldMileage)&"公里"
|
Else
|
GasMileageDiffTXT = "--"
|
End If
|
If GasVolume<>"0" Then
|
GasVolumeTXT = GasVolume&"升"
|
Else
|
GasVolumeTXT = "--"
|
End If
|
If GasPrice<>"0" Then
|
GasPriceTXT = GasPrice&"元"
|
Else
|
GasPriceTXT = "--"
|
End If
|
If GasSumPrice<>"0" Then
|
GasSumPriceTXT = GasSumPrice&"元"
|
Else
|
GasSumPriceTXT = "--"
|
End If
|
i=i+1
|
|
%>
|
<tr style="white-space: nowrap;">
|
<td class="selected"><input type="checkbox" id="CarGasID_<%=CarGasID%>" name="CarGasID" value="<%=CarGasID%>" onclick="itemCheck('checkAll','CarGasID')"/></td>
|
<td class="category category2"><A <%If isDepartment("050201")=1 Then%>onclick="JS_CarGasEdit('<%=CarGasID%>','<%=GasCarID%>','<%=CarLicense%>','<%=GasDate%>','<%=GasMileage%>','<%=GasVolume%>','<%=GasPrice%>','<%=GasSumPrice%>','<%=GasType%>','<%=GasStation%>','<%=GasPayment%>','<%=GasRemarks%>');"<%End If%>>CG<%=Right("000000"&CarGasID,6)%></A></td>
|
<td class="category category2"><%=FORMATDATETIME(GasDate,vbShortDate)%></td>
|
<td class="category category2"><%=CarLicense%></td>
|
<td class="category category2"><%=GasOldMileageTXT%></td>
|
<td class="category category2"><%=GasMileageTXT%></td>
|
<td class="category category2"><%=GasMileageDiffTXT%></td>
|
<td class="category category2"><%=GasVolumeTXT%></td>
|
<td class="category category2"><%=GasPriceTXT%></td>
|
<td class="category category2"><%=GasSumPriceTXT%></td>
|
<td class="category category2"><%=GasType%></td>
|
<td class="category category2"><%=GasStation%></td>
|
<td class="category category2"><%=GasPayment%></td>
|
<td class="category category2"><%=GasRemarks%></td>
|
<td class="category category2 last"><%=OAUser(OAID,"UserName")%></td>
|
</tr>
|
<%rs.movenext
|
loop
|
rs.close()
|
%>
|
<%for j=i to 20%>
|
<tr>
|
<td> </td>
|
<td> </td>
|
<td> </td>
|
<td> </td>
|
<td> </td>
|
<td> </td>
|
<td> </td>
|
<td> </td>
|
<td> </td>
|
<td> </td>
|
<td> </td>
|
<td> </td>
|
<td> </td>
|
<td> </td>
|
<td class="last"> </td>
|
</tr>
|
<%next%>
|
</tbody>
|
</table>
|
<!-- pagination -->
|
<div class="pagination pagination-left">
|
<div class="results">
|
<%
|
ShowingLeast = (acc1-1)*QuantityInt+1
|
ShowingMax = QuantityInt*acc1
|
if ShowingMax>acc3 then ShowingMax=acc3
|
%>
|
<span><%="显示 "& ShowingLeast &"-"& ShowingMax &" of "&acc3%></span>
|
</div>
|
<%if acc2>1 then%>
|
<ul class="pager">
|
<%if acc1=1 then%>
|
<li class="disabled">« 上页</li>
|
<%else%>
|
<li><a href="?page=<%=acc1-1%><%=page_URL%>">« 上页</a></li>
|
<%end if%>
|
<%
|
acc4=""
|
for i=1 to acc2
|
if acc2<=9 then
|
acc4=acc4&","&i
|
else
|
if i=1 then
|
acc4=acc4&","&i
|
elseif acc1<=5 and i<=7 then
|
acc4=acc4&","&i
|
elseif acc1>=acc2-4 and i>=acc2-6 then
|
acc4=acc4&","&i
|
elseif i>=acc1-2 and i<=acc1+2 then
|
acc4=acc4&","&i
|
elseif i=acc2 then
|
acc4=acc4&","&i
|
elseif i=2 or i=acc2-1 then
|
acc4=acc4&",0"
|
end if
|
end if
|
next
|
acc4SP=SPLIT(acc4,",")
|
for i = 1 to UBOUND(acc4SP)%>
|
<%if acc4SP(i)="0" then%>
|
<li class="separator">...</li>
|
<%elseif acc1=cint(acc4SP(i)) then%>
|
<li class="current"><%=acc4SP(i)%></li>
|
<%else%>
|
<li><a href="?page=<%=acc4SP(i)%><%=page_URL%>"><%=acc4SP(i)%></a></li>
|
<%end if%>
|
<%next%>
|
<%if acc1>=acc2 then%>
|
<li class="disabled">下页 »</li>
|
<%else%>
|
<li><a href="?page=<%=acc1+1%><%=page_URL%>">下页 »</a></li>
|
<%end if%>
|
</ul>
|
<%end if%>
|
</div>
|
<!-- end pagination -->
|
</form>
|
</div>
|
</div>
|
<!-- end table -->
|
|
|
</div>
|
<!-- end content / right -->
|
</div>
|
<!-- end content -->
|
<!--#include FILE="vicgame.asp"-->
|
<IFRAME id="HiddenFrame" name="HiddenFrame" WIDTH=0 HEIGHT=0 MARGINWIDTH=0 MARGINHEIGHT=0 HSPACE=0 VSPACE=0 FRAMEBORDER=0 SCROLLING=no BORDERCOLOR=#ffffff></IFRAME>
|
</body>
|
</html>
|
