下拉選單或單選複選 自動到位

下拉選單
Javascript加入以下function
//--SelectItem----------------------
function SelectItem(sSelected,sObj)
{
var sVar
var sVar2
sVar=eval(sObj+'.length')
if (typeof(sVar)=="undefined")
{
sVar2=eval( sObj+'.value' );
if ( sVar2==sSelected)
{
eval(sObj+'.selected=true');
}
}
else
{
for (i = 0; i < sVar; i++)
{
sVar2=eval( sObj+'['+i+'].value' );
if ( sVar2==sSelected )
{eval(sObj+'['+i+'].selected=true'); break;}
}
}
}
//--SelectItem----------------------
最後將要選擇的項目物件指定，並帶入想拉選擇的值即可


單選複選
Javascript加入以下function

//--CheckItem----------------------
function CheckItem(sSelected,sObj)
{
var sVar
var sVar2
sVar=eval(sObj+'.length');
if (typeof(sVar)=="undefined")
{
sVar2=eval( sObj+'.value' );
if ( sVar2==sSelected)
{
eval(sObj+'.checked=true');
}
}
else
{
for (i = 0; i < sVar; i++)
{
sVar2=eval( sObj+'['+i+'].value' );
if ( sVar2==sSelected )
{eval(sObj+'['+i+'].checked=true'); break;}
}
}
}
//--CheckItem----------------------
最後將要選擇的項目物件指定，並帶入想拉選擇的值即可

各式取日期方法YYYYMMDD

ASP
function sNowDate()
sNowDateY=year(now)
sNowDateM=month(now)
if sNowDateM < 10 then sNowDateM="0" & sNowDateM
sNowDateD=Day(now)
if sNowDateD < 10 then sNowDateD="0" & sNowDateD
sNowDateHH=hour(now)
if sNowDateHH < 10 then sNowDateHH="0" & sNowDateHH
sNowDateMM=minute(now)
if sNowDateMM < 10 then sNowDateMM="0" & sNowDateMM
sNowDateSS=second(now)
if sNowDateSS < 10 then sNowDateSS="0" & sNowDateSS
sNowDate=sNowDateY & sNowDateM & sNowDateD & sNowDateHH & sNowDateMM & sNowDateSS
end function
C#
DateTime.Now.ToString("yyyyMMdd")
忽略系統時間格式設置DateTime.Now.ToString("yyyyMMdd", System.Globalization.DateTimeFormatInfo.InvariantInfo);

SQL
--8碼===========
set @dDate=(select CONVERT(char(8),getdate(), 112 ))
--14碼==========
set @dDate=(select CONVERT(char(8),getdate(), 112 )+CONVERT(char(6),replace(CONVERT(char(8),getdate(), 114 ),':','')) )
--14碼時間差=========
declare @dDate varchar(14)set @dDate=CONVERT(char(8),dateadd(hour,-1,getdate()), 112 ) + replace(CONVERT(char(14),dateadd(hour,-1,getdate()), 114 ),':','')select @dDate