<!--#include file="ConnectDB.inc"--> <script language=javascript> function replace(v){ var sql = "select * from Dictionary where MainID='" + v + "'" var rs = new ActiveXObject("ADODB.Recordset"); var ConnDB = new ActiveXObject("adodb.connection"); ConnDB.ConnectionString="DSN=seed;uid=sa;pwd=25661800"; ConnDB.open // var rs = serve.rcreateobject("adodb.recordset") rs.open(sql,ConnDB,1,1); if (rs.RecordCount>0){ //document.body.style.cursor = "hand" if (v==parseInt(rs("MainID"))){ document.all('txt').value = v + rs("MainValue"); document.body.style.cursor="default"; return; } //if (v==parseInt((rs("MainID")+rs("SubID")))){ //document.all('txt').value = v + rs("MainID") + rs("SubID") //} }
else { var sql=null; var CodeLength = parseInt(v); if (CodeLength.length>3){ ;} alert("没有此代号!"); txt.select(); txt.focus(); } } </script> <input type=text id=txt name=txt onblur="replace(this.value)">
<script language=javascript>
function replace(v){
var sql = "select * from Dictionary where MainID='" + v + "'"
var rs = new ActiveXObject("ADODB.Recordset");
var ConnDB = new ActiveXObject("adodb.connection");
ConnDB.ConnectionString="DSN=seed;uid=sa;pwd=25661800"; ConnDB.open
// var rs = serve.rcreateobject("adodb.recordset") rs.open(sql,ConnDB,1,1); if (rs.RecordCount>0){ //document.body.style.cursor = "hand"
if (v==parseInt(rs("MainID"))){
document.all('txt').value = v + rs("MainValue");
document.body.style.cursor="default";
return;
}
//if (v==parseInt((rs("MainID")+rs("SubID")))){
//document.all('txt').value = v + rs("MainID") + rs("SubID")
//}
}
else {
var sql=null;
var CodeLength = parseInt(v);
if (CodeLength.length>3){ ;}
alert("没有此代号!");
txt.select();
txt.focus();
} }
</script>
<input type=text id=txt name=txt onblur="replace(this.value)">