//Check Letter and Number
function IsEn(){
if(arguments[0].value.length==0)
return true;
var reg=/^[a-z0-9.]*$/gi;
if(reg.test(arguments[0].value)==false)
return "You must enter Letter or Number !";
else
return true;
}
//Check E-mail
function IsEmail(){
if(arguments[0].value.length==0)
return true;
var reg = /^([a-z]){1,}([\.a-z0-9_\-]){1,}([a-z0-9]){1,}@([a-z0-9_-]){3,}(\.([a-z0-9]){2,4}){1,2}$/gi;
if(reg.test(arguments[0].value)==false){
return "You must enter E-mail !";
}
else
return true;
}
//Check Date
function IsDate(){
if(arguments[0].value.length==0)
return true;
var reg=/^(\d{4})(-|\/)(0?[1-9]|1[0-2])(-|\/)(0?[1-9]|[12][0-9]|3[01])$/g;
var r=reg.exec(arguments[0].value);
if(r==null)
return "You must enter Date !";
var d=new Date(r[1], r[3]-1,r[5]);
var newStr=d.getFullYear()+r[2]+(d.getMonth()+1)+r[2]+d.getDate();
var reg=/(\/|-)(0*)( *)([1-9])/g;
var t=arguments[0].value.replace(reg,'$1$4');
if (newStr==t)
return true;
else
return "You must enter Date !";
}
//Check Number
function IsNumber(){
if(arguments[0].value.length==0)
return true;
if(arguments[0].value*1==arguments[0].value)
return true;
else
return "You must enter number !";
}
//Check only enter English
function IsEnglish(){
if(arguments[0].value.length==0)
return true;
var reg=/^[a-z]*$/gi;
if(reg.test(arguments[0].value))
return true;
else
return "You only enter English !";
}
//You Only enter Chinese
function IsChinese(){
if(arguments[0].value.length==0)
return true;
var reg = /[^\u4E00-\u9FA5]/g;
if(reg.test(arguments[0].value)==false)
return true;
else
return "You only enter Chinese !";
}
//you don't enter chinese or all-letter
function IsNoChinese(){
if(arguments[0].value.length==0)
return true;
var reg=/[\u4E00-\u9FA5]|[\uFE30-\uFFA0]/gi;
if(reg.test(arguments[0].value)==false)
return true;
else
return "You don't enter chinese or all-letter !";
}
//Add New Recordset
function UpdateData(){
if(this.RuleCheck()==false){
return false;
}
var sql_1="";
var sql_2="";
if(this.NowStatus=="add"){ //add sql
for(var i=0;i<this.Columns.length;i++){
sql_1+=this.Columns[i].Name+",";
if(eval("document.all."+this.Columns[i].Name+".value.length")>0)
sql_2+="'"+eval("document.all."+this.Columns[i].Name+".value")+"',";
else
sql_2+="null,";
}
sql_1="insert into "+this.STable+"("+sql_1.substr(0,sql_1.length-1)+") values("+sql_2.substr(0,sql_2.length-1)+")";
document.all.btn6.value=sql_1;
this.NowStatus="";
document.all.btn5.click();
top.SubLeftFrame.document.location=top.SubLeftFrame.document.location;
}
//Add rule with the column
function AddColumn(){
var obj=new Object();
obj.Name=arguments[0];
obj.isNull=arguments[1]; //isnull progerty
if(arguments[2].length) obj.IsNullErrMsg=arguments[2];
else obj.IsNullErrMsg="You must enter content!";
obj.lengs=arguments[3];
if(arguments[4]) obj.ChecklengthErrMsg=arguments[4];
else obj.ChecklengthErrMsg="You have over Max-length "+arguments[3]+" !";
obj.CheckFun=arguments[5];
if(arguments[6]) obj.CheckFunErrMsg=arguments[6];
else obj.CheckFunErrMsg="";
this.Columns[this.Columns.length++]=obj;
return obj;
}
//recordset.js Create a recordset model
// modification history
//-------------------------------------------------
// 07 Jan 2003 by greg.t create file
// 21 Feb 2003 by greg.t modify object
// Rule FunName List:
// 1.Omit Bland Space : Ospace
// 2.Check Column Length : ChkLength
// 3.Check Letter and Number : IsEn
// 4.Check Email : IsEmail
// 5.Check Date : IsDate
// 6.Check Number : IsNumber
// 7.Check Only English : IsEnglisth
// 8.Check not Chinese or all-letter : IsNoChinese
// 9.You Only enter Chinese : IsChinese
//delete recordset
function Gr_DeleteRecord(){
if(confirm("Are you sure?")){
var sql="delete from "+this.STable+" where "
for(var i=0;i<this.mykeywords.length;i++)
sql+=this.mykeywords[i]+"='"+eval("document.all."+this.mykeywords[i]+".value")+"' and";
sql=sql.substr(0,sql.length-4);
this.ClearData();
document.all.btn6.value=sql;
document.all.btn5.click();
top.SubLeftFrame.document.location=top.SubLeftFrame.document.location;
}
}
function SetPriKey(){
for(var i=0;i<arguments.length;i++)
this.mykeywords[this.mykeywords.length++]=arguments[i];
}