|
以后，要是做時間段的查詢就方便了，不過就是程序有點多，呵呵！
希望大家能幫我測試一下，輸入的時間格式是1999-01-01或2000-10-01或2000-10-10，即月份和時間必須是兩位，為了方便大家測試，把所有文件放在這里，只要運行time_main.asp就可以了，多謝了！
time_main.asp
<%@ Language=VBScript %>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</HEAD>
<FRAMESET ROWS="82,18" border=1>
<FRAME NAME="time" SRC="time.asp">
<FRAME NAME="time_search" SRC="time_search.asp">
</FRAMESET>
<NOFRAMES>您的瀏覽器不支持FRAMES</NOFRAMES>
</HTML>
time.asp
<%@ Language=VBScript %>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</HEAD>
<BODY>
<%
starttime = Request.Form("starttime")
endtime = Request.Form("endtime")
Response.Write starttime&"<br>"
Response.Write endtime&"<br>"
%>
請點擊“查詢”按鈕
</BODY>
</HTML>
time_search.asp
<%@ Language=VBScript %>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</HEAD>
<BODY>
<center>
<form name="tform" method="post">
按時間（以<font color=red>[YYYY-MM-DD]</font>格式輸入）：
<input type="text" name="starttime" size=10 maxlength=10 value="1999-01-02">到
<input type="text" name="endtime" size=10 maxlength=10 value="2000-01-01">
<input type="button" name="tsearch" value="查詢" onclick="return tcheck()">
</form>
</center>
<script language="javascript">
<!--
function tcheck()
{
if (window.document.tform.starttime.value != "")
{
var vDate,vYear,vMonth,vDay;
vDate = window.document.tform.starttime.value;
vYear = vDate.substring(0,4);
if (isNaN(vYear) || vYear < 1900)
{
window.alert("您的日期1輸入有誤！");
tform.starttime.focus();
return false;
}
vMonth = vDate.substring(5,7);
if (isNaN(vMonth) || vMonth < 01 || vMonth > 12)
{
window.alert("您的日期1輸入有誤！");
tform.starttime.focus();
return false;
}
vDay = vDate.substring(8,10);
if (isNaN(vDay) || vDay == "" || vDay.length != 2 || vDay < 01 || vDay > 31)
{
window.alert("您的日期1輸入有誤！");
tform.starttime.focus();
return false;
}
if (vMonth == 04 || vMonth == 06 || vMonth == 09 || vMonth == 11)
{
if (vDay > 30)
{
window.alert("您的日期1輸入有誤！");
return false;
}
}
if (vMonth == 02)
{
if (vYear % 4 == 0 && vYear % 100 || vYear % 400 == 0)
{
if (vDay > 29)
{
window.alert("您的日期1輸入有誤！");
tform.starttime.focus();
return false;
}
}
else
{
if (vDay > 28)
{
window.alert("您的日期1輸入有誤！");
tform.starttime.focus();
return false;
}
}
}
if (vDate.substring(4,5) !== "-" || vDate.substring(7,8) != "-")
{
window.alert("您的輸入有誤，請以YYYY-MM-DD格式輸入！");
tform.starttime.focus();
return false;
}
if (window.document.tform.starttime.value != "" && window.document.tform.endt
ime.value != "")
{
if (window.document.tform.starttime.value > window.document.tform.endtime.va
lue)
{
window.alert("起始日期不能大于終止日期！");
tform.starttime.focus();
return false;
}
}
}
if (window.document.tform.endtime.value != "")
{
var vDate,vYear,vMonth,vDay;
vDate = window.document.tform.endtime.value;
vYear = vDate.substring(0,4);
if (isNaN(vYear))
{
window.alert("您的日期2輸入有誤！");
tform.endtime.focus();
return false;
}
vMonth = vDate.substring(5,7);
if (isNaN(vMonth) || vMonth < 01 || vMonth > 12)
{
window.alert("您的日期2輸入有誤！");
tform.endtime.focus();
return false;
}
vDay = vDate.substring(8,10);
if (isNaN(vDay) || vDay == "" || vDay.length != 2 || vDay < 01 || vDay > 31)
{
window.alert("您的日期2輸入有誤！");
tform.endtime.focus();
return false;
}
if (vMonth == 04 || vMonth == 06 || vMonth == 09 || vMonth == 11)
{
if (vDay > 30)
{
window.alert("您的日期2輸入有誤！");
return false;
}
}
if (vMonth == 02)
{
if (vYear % 4 == 0 && vYear % 100 == 0 || vYear % 400 == 0)
{
if (vDay > 29)
{
window.alert("您的日期2輸入有誤！");
tform.endtime.focus();
return false;
}
}
else
{
if (vDay > 28)
{
window.alert("您的日期2輸入有誤！");
tform.endtime.focus();
return false;
}
}
}
if (vDate.substring(4,5) !== "-" || vDate.substring(7,8) != "-")
{
window.alert("您的輸入有誤，請以YYYY-MM-DD格式輸入！");
tform.endtime.focus();
return false;
}
}
//如果必須按時間查詢的話，就把注釋放開就可以了
//if (window.document.tform.starttime.value == "" && window.document.tform.end
time.value== "")
//{
//window.alert("對不起，請你輸入時間！");
//window.document.tform.starttime.focus();
//return false;
//}
window.document.tform.action = "time.asp";
window.document.tform.target = "time";
window.document.tform.submit();
}
//-->
</script>
</BODY>
</HTML>
|
