动态表格保存到数据库的有关问题

动态表格保存到数据库的问题

VBScript code

 <table width="99%" border="1" align="center" cellpadding="4" cellspacing="1" class="toptable grid" id="SignFrame">            
  <tr id="trHeader">   
        <td width="30" align="center">序号 </td>   
        <td width="28" align="center">数量 </td> 
        <td width="33" align="center">单价 </td> 
        <td width="35" align="center">金额 </td> 
        <td width="37" align="center">  </td>   
      </tr> 
  </table> 
  <div> <br> <br> 
      <input name="Submit" type="button" class="hand" onClick="AddSignRow()" value="添加一行" /> 
          <input name='txtTRLastIndex' type='hidden' id='txtTRLastIndex' value="1" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;   
       <input name="button" type="submit" class="hand" id="button" value=" 确认提交 "> <br> 
  </div> 
  </body> 
  </HTML> 
  <% 
 Dim count1,rsClass1,sqlClass1 
 set rsClass1=server.createobject("adodb.recordset") 
 sqlClass1="select * from cgdlei Order By lei asc" 
 rsClass1.open sqlClass1,conn,1,1 
 %> 
  <script language="javascript">// Example: obj = findObj("image1");    
 var arr1 = [], arr2 = []; 
 function findObj(theObj, theDoc){  var p, i, foundObj;    if(!theDoc) theDoc = document;  if( (p = theObj.indexOf("?")) > 0 && parent.frames.length)  {    theDoc = parent.frames[theObj.substring(p+1)].document;    theObjtheObj = theObj.substring(0,p);  }  if(!(foundObj = theDoc[theObj]) && theDoc.all) foundObj = theDoc.all[theObj];  for (i=0; !foundObj && i  < theDoc.forms.length; i++)     foundObj = theDoc.forms[i][theObj];  for(i=0; !foundObj && theDoc.layers && i  < theDoc.layers.length; i++)     foundObj = findObj(theObj,theDoc.layers[i].document);  if(!foundObj && document.getElementById) foundObj = document.getElementById(theObj);    return foundObj;}    
 //添加一个填写行    
 function AddSignRow(){ //读取最后一行的行号，存放在txtTRLastIndex文本框中     
  var txtTRLastIndex = findObj("txtTRLastIndex",document);    
  var rowID = parseInt(txtTRLastIndex.value);    
      
  var signFrame = findObj("SignFrame",document);    
  //添加行    
  var newTR = signFrame.insertRow(signFrame.rows.length);    
  newTR.id = "SignItem" + rowID;    
      
  //添加列:序号    
  var newNameTD=newTR.insertCell(0);    
  //添加列内容    
  newNameTD.innerHTML = newTR.rowIndex.toString();    
  
   //添加列:数量    
  var newCompanyTD=newTR.insertCell(1);    
  //添加列内容    
  newCompanyTD.innerHTML = " <input onFocus='this.select()' name='sl" + rowID + "' type='text' class='txt24px' id='sl" + rowID + "' onKeypress='javascript:if (event.keyCode  < 45 || event.keyCode > 57) event.returnValue = false;' value='0' size='2' style='border: #FF0000 1px solid;' onchange='co(\"ss\"," + rowID + ",this.value)'/>";   
 
   
    //添加列:单价    
  var newCompanyTD=newTR.insertCell(2);    
  //添加列内容    
  newCompanyTD.innerHTML = " <input onFocus='this.select()' name='dj" + rowID + "' type='text' class='txt24px' id='dj" + rowID + "' onKeypress='javascript:if (event.keyCode  < 45 || event.keyCode > 57) event.returnValue = false;' value='0' size='2' style='border: #FF0000 1px solid;' onchange='co(\"dj\"," + rowID + ",this.value)'/>";  
   
     //添加列：金额 
  var newCompanyTD=newTR.insertCell(3);    
  //添加列内容    
  newCompanyTD.innerHTML = " <input name='jine" + rowID + "' readonly='ture' type='text' class='txt24px' id='jine" + rowID + "' onKeypress='javascript:if (event.keyCode  < 45 || event.keyCode > 57) event.returnValue = false;' size='4' value='0' />";  
      
  //添加列:删除按钮    
  var newDeleteTD=newTR.insertCell(4);    
  //添加列内容    
  newDeleteTD.innerHTML = " <div align='center' style='width:40px'> <a href='javascript:;' onclick=\"DeleteSignRow('SignItem" + rowID + "')\">删除 </a> </div>";    
      
  //将行号推进下一行    
  txtTRLastIndex.value = (rowID + 1).toString() ;    
 }    
 //删除指定行    
 function DeleteSignRow(rowid){    
  var signFrame = findObj("SignFrame",document);    
  var signItem = findObj(rowid,document);    
      
  //获取将要删除的行的Index    
  var rowIndex = signItem.rowIndex;    
      
  //删除指定Index的行    
  signFrame.deleteRow(rowIndex);    
      
  //重新排列序号，如果没有序号，这一步省略    
  for(i=rowIndex;i <signFrame.rows.length;i++){    
   signFrame.rows[i].cells[0].innerHTML = i.toString();    
  }    
 }//清空列表  
 function ClearAllSign(){    
  if(confirm('确定要清空所有吗？')){    
   var signFrame = findObj("SignFrame",document);    
   var rowscount = signFrame.rows.length;    
       
   //循环删除行,从最后一行往前删除    
   for(i=rowscount - 1;i > 0; i--){    
    signFrame.deleteRow(i);    
   }    
       
   //重置最后行号为1    
   var txtTRLastIndex = findObj("txtTRLastIndex",document);    
   txtTRLastIndex.value = "1";    
       
   //预添加一行    
   AddSignRow();    
  }    
 }    
 function co(a,b,c){ 
 if (a=="ss") { 
 arr1[b] = c; 
 //alert("第"+b+"行的数量="+c); 
 } 
 if (a=="dj") { 
 arr2[b] = c; 
 //alert("第"+b+"行的单价="+c); 
 } 
 if (arr1[b] && arr2[b]){ 
 //document.getElementsByName("je")[b-1].value = arr1[b]*arr2[b]; 
 document.getElementById("jine"+b).value = arr1[b]*arr2[b]; 
 } 
 } 
  </script>