calendar.js

当数据从JTable复制到Excel时

var dateobj = new Date();

function getCal(iLeft, iTop, intCount){
	var currdate;
	for (i=0;i<window.form.length ;i++)
	{
		D_ID=window.form.item(i).id;
		if (D_ID.substring(0,4)=="Date"&&D_ID.substring(4,5)==intCount){
			if(form.item(i).value==""){
				currdate=(dateobj.getYear()-30)+"-"+(dateobj.getMonth()+1)+"-"+dateobj.getDate;
			}else{
				currdate=form.item(i).value;
			}
		}
	}

	MakeCal(currdate, intCount)
	intFlag = 1;
	calendar.style.left = iLeft;
	calendar.style.top = iTop;
	calendar.style.visibility = "visible";
	event.cancelBubble = true;
}

function setVal(date, intCount){
	for (i=0;i<window.form.length ;i++)
	{
		D_ID=window.form.item(i).id;
		if (D_ID.substring(0,4)=="Date"&&D_ID.substring(4,5)==intCount){
			form.item(i).value=date;
		}
	}

}
function hideCal(){
	calendar.style.visibility = "hidden";
}

function formInit(){

	var i;
	var currdate;
	currdate = (dateobj.getYear()+"-"+(dateobj.getMonth() + 1) + "-" + dateobj.getDate() );
	for (i=0;i<window.form.length ;i++)
	{
		D_ID=window.form.item(i).id;
		if (D_ID.substring(0,4)=="Date"){
			form.item(i).value=currdate;
		}
	}
}

function formSet(setDate,id){
	var i;
	for (i=0;i<window.form.length ;i++)
	{
		D_ID=window.form.item(i).id;
		if (D_ID.substring(0,4)=="Date"&&D_ID.substring(4,5)==id){
			form.item(i).value=setDate;
		}
	}
}

document.onclick = hideCal;

function MakeCal(date,intCount) {
	var z1, z2,blntoday
	var today = new Date();
	if (date == null) {
		var szMonth = today.getMonth();
		var szYear = today.getFullYear();
		var szDate = today.getDate();
	} 
	else {
		z1 = date.indexOf("-");
		z2 = date.lastIndexOf("-");
		var szYear = Number(date.slice(0,z1));
		var szMonth = Number(date.slice(z1 + 1, z2))-1;
		if(szMonth < 0){
			szMonth = 11;
			szYear = szYear - 1;
		}
		else if(szMonth > 11){
			szMonth = 0;
			szYear = szYear + 1;
		}
		var szDate = Number(date.slice(z1 + 1,z2));
	}//拆分年月日

	var x, intTemp, szId, max, todayx, startx;
	var szStart = new Date(szYear, szMonth, 1);
	var intDay = szStart.getDay();	
	var blSet = false;
	var szCal;
	szStart.setMonth(szMonth - 1);
	var PrevMonth = szStart.getMonth();
	var PrevYear = szStart.getFullYear();
	szStart = new Date(szYear, szMonth, 1);
	szStart.setMonth(szMonth + 1);
	var NextMonth = szStart.getMonth();
	var NextYear = szStart.getFullYear();
	szStart = new Date(szYear, szMonth, 1);
	szCal = "" ;
	szCal = szCal + "<table id=tblBor width=102 border=0 bgcolor=#eeeeee cellspacing=0 cellpadding=3><tr><td>";
	szCal = szCal + "<table width=100 width=100 border=0 bgcolor=#ffffee cellspacing=0 cellpadding=3><tr><td>"
	szCal = szCal + "<table id=tblCal width=100 border=0 bgcolor=#ffffee cellspacing=0 cellpadding=3>";
	szCal = szCal + "<tr><td >&nbsp</td>";
	if (szStart.getMonth() == (szMonth))
		szCal = szCal + "<td colspan=5 align=center id=title>" +"<Font Color =black>"+ szYear + "年"+"</font>" + " " +"<font color=black>"+ MakeStringT(szMonth)+"</Font>"+"</td>";
	else
		szCal = szCal + "<td colspan=5 align=center id=title>" +"<font color=#7F7F7F>"+ MakeStringT(szMonth)+"</Font>" + " " +"<Font Color =black>"+ szYear + "年"+"</font>"+"</td>";
	szCal = szCal + "<tr id=rowTitle ><td><font color=black>日</font></td><td><font color=black>一</font></td><td><font color=black>二</font></td><td><font color=black>三</font></td><td><font color=black>四</font></td><td><font color=black>五</font></td><td><font color=black>六</font></td></tr>";
	for (x=1; x<43; x++) {
		if (x % 7 == 1) {
			szCal = szCal + "<tr>"
		}
		szStart = new Date(szYear, szMonth, 1);
		intTemp = (-(intDay - x));
		szStart.setDate(intTemp);
		szId = MakeString(szStart.getMonth()) + x;
		if (!blSet) {
			if (szStart.getMonth() == (szMonth + 1)) {
				blSet = true;
				max = x;
			}
			if (szStart.getFullYear() == (szYear + 1)) {
				blSet = true;
				max = x;
			}
		}
		blntoday = 0;
		if (szStart.getDate() == today.getDate()) {
			if (szStart.getMonth() == today.getMonth()) {
				if (szStart.getYear() == today.getYear()) {
					todayx = x;
					blntoday = 1;
				}
			}
		}
		szCal = szCal + "<td ";
		if (szStart.getMonth() == (szMonth)) {
			szCal = szCal + "onclick=\"setVal('" +szStart.getFullYear()  + "-" + (szStart.getMonth() + 1 ) + "-" + szStart.getDate() + "',"+intCount+")\"";
		} 
		else {
			szCal = szCal + "onclick=\"MakeCal('" + szStart.getFullYear() + "-" + (szStart.getMonth() + 1 ) + "-" + szStart.getDate() + "',"+intCount+")\"";
		}
		if (blntoday == 1)
			szCal = szCal + " id=" + szId + "><center><font color = red>" + szStart.getDate() + "</font></td>";
		else
			szCal = szCal + " id=" + szId + "><center>" + szStart.getDate() + "</td>";
			
		if (x % 7 == 0) {
			szCal = szCal + "</tr>"
		}
	}
	szCal = szCal + "</tr>";
	szCal = szCal + "</table></td></tr>";
	szCal = szCal + "<tr align=center><td><table border=0 bgcolor=#ffffee cellspacing=0 cellpadding=3>";
	szCal = szCal + "<tr>";
	szCal = szCal + "<td style=\"cursor:hand;\"><img src='images/leftendbar.gif' border=0 onclick=\"MakeCal('" + (PrevYear - 1) +"-"+ (PrevMonth + 2) + "-1" + "',"+intCount+")\"></td>";
	szCal = szCal + "<td style=\"cursor:hand;\"><img src='images/leftbar.gif' border=0 onclick=\"MakeCal('" + PrevYear +"-"+ (PrevMonth + 1) + "-1" + "',"+intCount+")\"></td>";
	szCal = szCal + "<td style=\"cursor:hand;\"><img src='images/rightbar.gif' border=0 onclick=\"MakeCal('" + NextYear +"-"+ (NextMonth + 1) + "-1" + "',"+intCount+")\"></td>";
	szCal = szCal + "<td style=\"cursor:hand;\"><img src='images/rightendbar.gif' border=0 onclick=\"MakeCal('" + (NextYear+1) +"-"+ NextMonth + "-1" + "',"+intCount+")\"></td>";
	szCal = szCal + "</tr>";
	szCal = szCal +"</table></td></tr>"
	szCal = szCal + "</table></td></tr>";
	szCal = szCal + "</table>";
	calendar.innerHTML = szCal;
	for (x=intDay; x>0; x--) {
		eval(MakeString(PrevMonth) + x + ".style.color = \"909090\"")
	}
	for (x=max; x<43; x++) {
		eval(MakeString(NextMonth) + x + ".style.color = \"909090\"")
	}
	if (szMonth == today.getMonth()) {
		if (szYear == today.getFullYear()) {
			eval(MakeString(szMonth) + todayx + ".style.backgroundColor = \"#99CCFF\"");
			eval(MakeString(szMonth) + todayx + ".style.Color = \"yellow\"");
		}
	}
	tblCal.style.color = "#00009F";
	tblCal.style.fontFamily = "arial";
	tblCal.style.cursor = "hand";
	tblCal.style.fontSize = "10";
	rowTitle.style.backgroundColor = "#eeeeee";
	event.cancelBubble = true;
}

function MakeString(intMonth) {
	var Month
	switch (intMonth) {
		case 0 :
			Month = "JANUARY";
			break;
		case 1 :
			Month = "FEBUARY";
			break;
		case 2 :
			Month = "MARCH";
			break;
		case 3 :
			Month = "APRIL";
			break;
		case 4 :
			Month = "MAY";
			break;
		case 5 :
			Month = "JUNE";
			break;
		case 6 :
			Month = "JULY";
			break;
		case 7 :
			Month = "AUGUST";
			break;
		case 8  :
			Month = "SEPTEMBER";
			break;
		case 9 :
			Month = "OCTOBER";
			break;
		case 10 :
			Month = "NOVEMBER";
			break;
		case 11 :
			Month = "DECEMBER";
	}
	return (Month);
}

function MakeStringT(intMonth) {
	var Month
	switch (intMonth) {
		case 0 :
			Month = "一月";
			break;
		case 1 :
			Month = "二月";
			break;
		case 2 :
			Month = "三月";
			break;
		case 3 :
			Month = "四月";
			break;
		case 4 :
			Month = "五月";
			break;
		case 5 :
			Month = "六月";
			break;
		case 6 :
			Month = "七月";
			break;
		case 7 :
			Month = "八月";
			break;
		case 8  :
			Month = "九月";
			break;
		case 9 :
			Month = "十月";
			break;
		case 10 :
			Month = "十一月";
			break;
		case 11 :
			Month = "十二月";
	}
	return (Month);
}

function keepCal() {
	event.cancelBubble = true;
}

function public_get_txtDate() {
	return txtDate;
}

function public_get_value() {
	return txtDate.value;
}