publicjs.js

一个简单的ASP和ACCESS连接的范例,实现简单的生日登记显示功能.

	}
	return true;
}
function Doc_open( sUrl )
{
  var height,width,top,left;
  height=screen.height-150;
  width=screen.width-20;
  left = ( screen.width - width ) / 2 ;;
  top = 20 ;
  window.open( sUrl,'','titlebar=no,toolbar=no,location=no,directories=no,status=no,menubar=yes,scrollbars=yes,top='+top+',left='+left +',height='+height+',width='+width);
}
//去字符串头尾空格
function trim(mystr){
	var a = mystr.match(/\S/i);
  	var b = mystr.match(/\S/g);
	if (a==null || b==null){
       	return "";
	}
	else{
	return mystr.substring(a.index,b.lastIndex);
	}
}
//设置select对象的选中值
function setSelectValue(selectObj,selectValue){
  for(var i=0;i < selectObj.length;i++){
    if(selectValue == selectObj[i].value){
      selectObj[i].selected = true;
      return;
    }
  }
}
//检测项目编号的格式是否正确
function CheckItemNo(obj) {
  regexp = new RegExp("^[A-Z]{2}\\d{2}\\-{1}\\d{2}\\-{1}\\d{1}\\-{1}\\d{2}\\-{1}\\d{3}$");

  if (!regexp.test(obj.value) && obj.value != '') {
	alert("对不起，项目编号的格式不对!\n请参照：FJ01-01-1-01-001");
	obj.focus();
	return false;
  }
  return true;
}


//导出EXCEL表
function genExcel(iColumnNO,i){
  try{
	  if(i!=0)
	var str = document.all.layer[i].innerHTML;
	  else
	var str = document.all.layer.innerHTML;
	var w = window.open('','_blank','width=1, height=1');
	w.document.write(str);
	w.document.execCommand('SelectAll');
	w.document.execCommand('Copy');
	w.close();
	var oXL = new ActiveXObject('Excel.Application');
	oXL.Visible = true;
	var oWB = oXL.Workbooks.Add();
	var oSheet = oWB.ActiveSheet;
	oSheet.Paste();

	var oSelection = oXL.selection;
	oSelection.Font.Size = 9;

	if(iColumnNO > 0 && iColumnNO <= 26){
		var strA = "A";
		var sColumnNO = String.fromCharCode(iColumnNO+strA.charCodeAt());
		oSheet.Columns(sColumnNO + ':' + sColumnNO).WrapText = 0;
		oSheet.Columns(sColumnNO + ':' + sColumnNO).NumberFormatLocal = '@';
		oSheet.Columns(sColumnNO + ':' + sColumnNO).EntireColumn.AutoFit();
	}
/*	if(iColumnNO1 > 0 && iColumnNO1 <= 26){
		var strA = "A";
		var sColumnNO = String.fromCharCode(iColumnNO1+strA.charCodeAt());
		oSheet.Columns(sColumnNO + ':' + sColumnNO).WrapText = 0;
		oSheet.Columns(sColumnNO + ':' + sColumnNO).NumberFormatLocal = '@';
		oSheet.Columns(sColumnNO + ':' + sColumnNO).EntireColumn.AutoFit();
	}
*/
  }catch (err){
	alert("创建对象错误:"+err+"\n请你降低IE安全等级，重新单击\"导到EXCEL文件\"并允许运行ActiveX！");
  }
}



//判断是否可转为日期
function isDate(value,clew){
	//YYYY?m(m)?d(d)
	var a = value.match(/\D/i);
  	var b = value.match(/\D/g);
	if (a!=null && b!=null){
		//有分隔
		var s=a.index;
		var t=b.lastIndex;
		var y=value.substring(0,s);
		var m=value.substring(s+1,t-1);
		var d=value.substr(t);

	}
	else{
		//无分隔
		switch(value.length){
		case 6:
			//yymmdd
			var y=value.substr(0,2);
			var m=value.substr(2,2);
			var d=value.substr(4,2);
			break;
		case 8:
			//yyyymmdd
			var y=value.substr(0,4);
			var m=value.substr(4,2);
			var d=value.substr(6,2);
			break;
		default:
			if(clew.length>0)alert(clew);
			return("error");
		}
	}
	if(y=='' || m==''|| d == ''){
		if(clew.length>0)alert(clew);
		return("error");
	}

	if(y.match(/\D/)!=null||m.match(/\D/)!=null||d.match(/\D/)!=null){
		if(clew.length>0)alert(clew);
		return("error");
	}

	y=parseInt(y,10);
	m=parseInt(m,10);
	d=parseInt(d,10);

	if(m<1||m>12||d<1||d>31){
		if(clew.length>0)alert(clew);
		return("error");
	}
	if(m==4||m==6||m==9||m==11){
		if(d==31){
			if(clew.length>0)alert(clew);
			return("error");
		}
	}
	if(m==2){
		if(d>29||(d==29&&y/4!=parseInt(y/4,10))){
			if(clew.length>0)alert(clew);
			return("error");
		}
	}
	var str_y = y;
	if(y<90) str_y = 2000+y;
	if(y>=90 && y<100) str_y = 1900+y;
	var str_m = "" + m;
	var str_d = "" + d;
	if(m<10) str_m = "0" + m;
	if(d<10) str_d = "0" + d;
	return str_y + "-" + str_m + "-" + str_d;
}


function MM_findObj(n, d) { //v3.0
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document); return x;
}

function MM_showHideLayers() { //v3.0
  var i,p,v,obj,args=MM_showHideLayers.arguments;
  for (i=0; i<(args.length-2); i+=3) if ((obj=MM_findObj(args[i]))!=null) { v=args[i+2];
    if (obj.style) { obj=obj.style; v=(v=='show')?'visible':(v='hide')?'hidden':v; }
    obj.visibility=v; }
}
function setList(tt,obj,layobj,pos)
{
  if (arguments.length >  4){alert("对不起！传入本控件的参数太多！");return;}
  if (arguments.length == 0){alert("对不起！您没有传回本控件任何参数！");return;}
  var dads  = layobj.style;
  var th = tt;
  var ttop  = tt.offsetTop;
  if(arguments.length == 4) ttop  = tt.offsetTop - 193;
  var thei  = tt.clientHeight;
  var tleft = tt.offsetLeft;
  var ttyp  = tt.type;
  while (tt = tt.offsetParent){ttop+=tt.offsetTop; tleft+=tt.offsetLeft;}
  dads.top  = (ttyp=="image")? ttop+thei : ttop+thei+2;
  dads.left = tleft;
  dads.width = obj.style.width;
  outObject = (arguments.length == 1) ? th : obj;
  dads.display = '';
  event.returnValue=false;
}

// returns the decoded value of a cookie
function getCookieVal(offset) {
	var endstr = document.cookie.indexOf(";", offset);
	if (endstr == -1)
		endstr = document.cookie.length;
	return unescape(document.cookie.substring(offset, endstr));
}

// returns the value of the specified cookie, or null
function getCookie(name) {
	var arg = name + "=";
	var alen = arg.length;
	var clen = document.cookie.length;
	var i = 0;
	while (i < clen) {
		var j = i + alen;
		if (document.cookie.substring(i, j) == arg)
			return getCookieVal(j);
		i = document.cookie.indexOf(" ", i) + 1;
		if (i == 0)
			break;
	}
	return "";
}

// creates or updates a cookie
function setCookie(name, value) {
	var argv = setCookie.arguments;
	var argc = setCookie.arguments.length;
	var expires = (argc > 2) ? argv[2] : null;
	var path = (argc > 3) ? argv[3] : null;
	var domain = (argc > 4) ? argv[4] : null;
	var secure = (argc > 5) ? argv[5] : false;
	document.cookie = name + "=" + escape(value) +
 	  	((expires == null) ? "" : ("; expires=" + expires.toGMTString())) +
		((path == null) ? "" : ("; path=" + path)) +
		((domain == null) ? "" : ("; domain=" + domain)) +
		((secure == true) ? "; secure" : "");
}

// deletes a cookie
function deleteCookie(name) {
	var exp = new Date();
	exp.setTime(exp.getTime() - 1);
	var cval = getCookie(name);
	if (cval != null)
		document.cookie = name + "=" + cval + "; expires=" + exp.toGMTString();
}

//--判断输入是否为空
function notNull(fieldname,string) {
   stringtemp=trim(string.value);
   if ((stringtemp == "")||(stringtemp=="0")) {
      alert(fieldname+"不能为空!");
      string.focus();
      return false;
   }
   else
   return true;
}

//---检查帐号密码输入长度是否为6-20位,满足 返回 TRUE,反之 FALSE;

function checkPasswdLen(password){
   var len=password.value.length;
   if (len<6 || len>21){
	 alert("密码长度要求最短为6位,最长为21位!");
	 password.value="";
     password.focus();
     return false;
   }
   return true;

}

function checkPasswd(fieldname,string)
{
  		var PasswdReg = /^[a-z0-9A-Z]{6,20}$/;
		if (!PasswdReg.test(string.value))
		{
			alert(fieldname+"只能由半角英文字母及阿拉伯数字组合,长度因在6-20个字符之间!");

                        string.focus();
			return false;
		}
   return true ;
}

function checkID(fieldname,string,minlength,maxlength)
{
     PasswdReg = new RegExp("^[a-z0-9A-Z]{"+minlength+","+maxlength+"}$");
		if (!PasswdReg.test(string.value))
		{
			alert(fieldname+"只能由半角英文字母及阿拉伯数字组合,长度因在"+minlength+"-"+maxlength+"个字符之间!");
                        string.focus();
			return false;
		}
   return true ;
}
//判断是否有输入特殊字符 是 false 否 true
function checkName(fieldname,string)
{
  		var PasswdReg = /[\! \@ \# \$ \% \^ \& \* \) \( \\ \} \{ \" \' \[ \] \~ \; \: \? \/ \> \< \. \, \+ \*]/ ;
              	if (PasswdReg.test(string.value))
		{
			alert(fieldname+"只能由中文,半角英文字母及阿拉伯数字组合,不允许特殊字符输入!");
			string.focus();
			return false;
		}
   return true ;
}

//--检查两次输入的密码是否匹配
function comparePasswd(string1,string2)
 { if(string1.value==string2.value)
      return true;
   else
   {  alert("两次输入的密码不一致!!");
      string1.focus();
      string1.value='';
      string2.value='';
      return false;
   }
 }
 
function Check_Date(fieldname,string){
    regexp = new RegExp("^\\d{4}\\-\\d{2}\\-\\d{2}$")
		if(!regexp.test(trim(string.value)))
	{   alert(fieldname+"格式为YYYY-MM-DD，只允许阿拉伯数字输入，不允许其他字符输入!");
		string.focus();
		return false;
	}
	return true;
}

function Compute_Time(lTime, iInterval, iMod){
	//mod = 1 ,2,3  分别表示返回值精确到天、小时、分钟
    var lReturnTime = 0;
    lReturnTime = lTime + iInterval * 60 * 1000;

    if (iMod == "1") { //准确到天 每天时间的值为24*60*60*1000=86400000
      lReturnTime = ( (lReturnTime - 1) / 86400000 + 1);
      lReturnTime = lReturnTime * 86400000;
    }
    else if (iMod == "2") { //准确到小时 每天时间的值为60*60*1000=3600000
      lReturnTime = ( (lReturnTime - 1) / 3600000 + 1);
      lReturnTime = lReturnTime * 3600000;
    }
    else { //准确到分钟 每天时间的值为60*1000=60000
      lReturnTime = ( (lReturnTime - 1) / 60000 + 1);
      lReturnTime = lReturnTime * 60000;
    }
    return lReturnTime;
  }

function FormateTime1(lTime){
   var s= "";
   d = lTime;
		s += d.getYear() + "-";
		if((d.getMonth()+1)<10) s += "0"+(d.getMonth()+1)+ "-";
		else s += (d.getMonth()+1) + "-";
		if(d.getDate()<10) s += "0"+d.getDate();
		else s += d.getDate();
//		if(d.getHours()<10) s += "0"+d.getHours() +":";
//		else s += d.getHours() + ":";
//		if(d.getMinutes<10) s += "0"+d.getMinutes() +":00";
//		else s += d.getMinutes() +":00";
//	alert("s="+s);
	return s;
}