怎 样控制文本框为改填栏位?100分求解.

<!--#include file="include/conn2.asp"-->
<% response.buffer=false %>
<%
     dim rs
 dim sql
 set rs=server.createobject("adodb.recordset")
 sql="select * from sb_stock where code='"&Request.Form("code")&"' "
 rs.open sql,conn,1,3
  if  request.form("code")<>"" then
 if not rs.eof  then 
      
        Response.Write "<script>"
            Response.Write "alert(""數據庫中已存在此設備編號，請輸入新的設備編號！"");"
            Response.Write "</script>"
 
 else  rs.addnew
rs("in_dept")=request.form("in_dept")
rs("code")=request.form("code")
rs("name")=request.form("name")
rs("part_var")=request.form("part_var")
rs("factory")=request.form("factory")
rs("indate")=request.form("indate")
rs("inperson")=request.form("memo")
rs("innumber")=request.form("innumber")
rs("sn")=request.form("sn")
rs("statue")=request.form("statue")
rs("zzdept")=request.form("in_dept")
rs("incause")=request.form("incause")
rs.update
end if
end if%>
<html>
<head>
<title>入庫作業</title>
<script >
<!--
function openCalendar(appPath, obj)
{
    
    var feature = 'dialogHeight:193px;dialogWidth:226px;dialogTop:' + (parseInt(window.event.screenY) + 10) + ';dialogLeft:' + window.event.screenX + ';help:0;resizable:0;status:0;scroll:0';
    window.showModalDialog('/shebeikuchun/calendar.html', obj, feature);
}
function nextInput(obj)
{
   textUpper(obj);
   if (window.event.keyCode == 13) obj.focus();
}function checkData(submitAction)
{
      if (chkInput()==false)
    {
    document.inputform.submit();}
}
function checkNotEmpty(str)
{
    if (str.value == '')
    {
        str.select();
        return false;
    }
    else return true;
}
function checkIsEmpty(str)
{
    if (str.value != '')
    {
        str.select();
        return false;
    }
    else return true;
}
function chkInput()
{
  
    var erremptyflag = false;
    var errsizeflag = false;
    var errmsg = "";
    frmobj = eval(document.inputform);
    var code = frmobj.code;
    var name = frmobj.name;
    var part_var = frmobj.part_var;
    var factory = frmobj.factory;
var indate = frmobj.indate;
    var innumber = frmobj.innumber;
    
    if (!checkNotEmpty(code) || code.value == ' ')
    {
        erremptyflag = true;
        errmsg += '[設備編碼]';
    }
    if (!checkNotEmpty(name) || name.value == ' ')
    {
        erremptyflag = true;
        errmsg += '[品名]';
    }
    if (!checkNotEmpty(part_var) || part_var.value == ' ')
    {
        erremptyflag = true;
        errmsg += '[規格]';
    }
    if (!checkNotEmpty(factory) || factory.value == ' ')
    {
        erremptyflag = true;
        errmsg += '[廠牌]';
    }
if (!checkNotEmpty(indate) || indate.value == ' ')
    {
        erremptyflag = true;
        errmsg += '[入庫日期]';
    }
if (!checkNotEmpty(innumber) || innumber.value == ' ')
    {
        erremptyflag = true;
        errmsg += '[入庫單號]';
    }
    
    if ( erremptyflag == true )
    {
        errmsg = "請輸入" + errmsg + "\n";
    }
   
   
    if ( (erremptyflag == true)  || (errsizeflag == true) )
    {
        alert(errmsg);
        return true;
    }
    return false;
}function textUpper(obj)
{
    //輸入欄位英文字母資料轉大寫
    obj.value = obj.value.toUpperCase();
}//-->
</script><meta http-equiv="Content-Type" content="text/html; charset=big5">
</head>
<script language="javascript">
function aaa(){
inputform.code.focus();
}
</script>
<body bgcolor="#095CC4" text="#000000"  topmargin="0" leftmargin="0"　onload="javascript:aaa();">

解决方案 »

  1.   

    <table width="780" border="0" cellspacing="0" cellpadding="0" align="center" height="350">
      <tr>
        <td  valign="top" height="365">
          <!--#include file="head.htm"-->
      
          <form name=inputform method=post action=sbinput.asp>
            <table width="100%" border="0" cellspacing="0" cellpadding="0" height="151">
              <tr>
                <td  valign="top">
                  <table width="100%" border="0" cellspacing="0" cellpadding="0">
                    <tr>
                      <td height="10">返回首頁 || 查詢 ||</td>
                    </tr>
                  </table>
                  <table width="100%" border="0" cellspacing="1">
                    <tr bgcolor="#DDE9FF"> 
                      <td width="17%">設備倉庫</td>
                      <td width="31%" bgcolor="#FFFFFF"> 
                        <input type="text" name="in_dept" size="20"  readonly value="<%Response.write session("in_dept")%>">
                      </td>
                      <td width="21%" >在制狀況</td>
                      <td width="31%" bgcolor="#FFFFFF" >
                        <select name="statue">
                          <option value="良品" selected>良品</option>
                          <option value="待外修">待外修</option>
                          <option value="報廢">報廢</option>
                        </select>
                      </td>
                    </tr>
                    <tr bgcolor="#DDE9FF"> 
                      <td width="17%">入庫原因</td>
                      <td width="31%" bgcolor="#FFFFFF">
                        <select name="incause">
                          <option value="新購" selected>新購</option>
                          <option value="修回入庫">修回入庫</option>
                        </select>
                      </td>
                      <td width="21%" >入庫人</td>
                      <td width="31%" bgcolor="#FFFFFF" > 
                        <input type="text" name="memo" size="20"  readonly value="<%Response.write session("memo")%>" >
                      </td>
                    </tr>
                    <tr bgcolor="#DDE9FF"> 
                      <td width="17%" bgcolor="#DDE9bb">編號</td>
                      <td width="31%" bgcolor="#FFFFFF">
                        <input type="text" name="code" size="20" onKeyUp="nextInput(document.all.name);textUpper(this);" >
                      </td>
                      <td width="21%" bgcolor="#DDE9bb">品名</td>
                      <td width="31%" bgcolor="#FFFFFF">
                        <input type="text" name="name" size="20" onKeyUp="nextInput(document.all.part_var);" >
                      </td>
                    </tr>
                    <tr bgcolor="#DDE9FF"> 
                      <td width="17%" bgcolor="#DDE9bb">規格</td>
                      <td class="text-9" height="30" nowrap bgcolor="#FFFFFF">
                        <input type="text" name="part_var" size="20"onKeyUp="nextInput(document.all.factory);" >
                      </td>
                      <td width="21%" bgcolor="#DDE9bb">廠牌</td>
                      <td width="31%" bgcolor="#FFFFFF">
                        <input type="text" name="factory" size="20" onKeyUp="nextInput(document.all.indate);" >
                      </td>
                    </tr>
                    <tr bgcolor="#DDE9FF"> 
                      <td width="17%" bgcolor="#DDE9bb">入庫日期</td>
                      <td width="31%" bgcolor="#FFFFFF">
                        <input type="text" name="indate" width="90" size="20" onKeyUp="nextInput(document.all.innumber);" >
                        <button style="FONT-SIZE:7pt; LEFT: -19px; WIDTH: 18px; POSITION: RELATIVE; TOP:-1px;HEIGHT:16px; TEXT-ALIGN: CENTER" onClick="openCalendar('.', document.all.indate);">v</button> 
                      </td>
                      <td width="21%" bgcolor="#DDE9bb">入庫單號</td>
                      <td width="31%" bgcolor="#FFFFFF">
                        <input type="text" name="innumber" size="20" onKeyUp="nextInput(document.all.sn);textUpper(this);" >
                      </td>
                    </tr>
                    <tr bgcolor="#DDE9FF"> 
                      <td width="17%" bgcolor="#DDE9bb">產品序號 </td>
                      <td width="31%" bgcolor="#FFFFFF">
                        <input type="text" name="sn" size="20" onKeyUp="nextInput(document.all.code);" >
                      </td>
                      <td width="21%" bgcolor="#DDE9bb">&nbsp;</td>
                      <td width="31%" bgcolor="#FFFFFF"> 
                        <table width="100%" border="0" cellspacing="0" cellpadding="0">
                          <tr> 
                            <td width="26%"> 
                              <div align="left"><a href="javascript:history.back(1)"><img src="img/bn_ch_eixt.gif" width="46" height="15"></a></div>
                            </td>
                            <td width="6%">&nbsp;</td>
                            <td width="68%"> 
                              <div align="left"><a href="javascript:checkData();"><img src="img/bn_ch_save.gif" width="46" height="15" border="0" id=SAVE> 
                                </a> </div>
                            </td>
                          </tr>
                        </table>
                      </td>
                    </tr>
                  </table>
                </td>
              </tr>
            </table>
          </form>
      <!--#include file="copyright.asp"-->
        </td>
      </tr>
    </table>
    </body>
    </html>