动态表的生成

      千语此刻 2005-11-1 17:33
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
    <HEAD>
        <title>DynamicQuery</title>
        <meta content="Microsoft Visual Studio .NET 7.1" name="GENERATOR">
        <meta content="C#" name="CODE_LANGUAGE">
        <meta content="javascript" name="vs_defaultClientScript">
        <meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema">
        <LINK href="../styles/manageStyle.css" type="text/css" rel="stylesheet">
        <link rel="stylesheet" type="text/css" href="../CSS/windows.css">     

        <script language="javascript">
         var index = new Array();
         window.onload=function()
         {
         if(document.all.rowlocation.value!="")
         {
         index=document.all.rowlocation.value.split(";")
         }else
         {
         index.push(0)
         }
         }
            function add()
            {
             var tr =document.createElement("tr")
         var td1=document.createElement("td")
         var td2=document.createElement("td")
         var td3=document.createElement("td")        
         var td4=document.createElement("td")
         var inna=index[index.length-1]+1;
         td1.innerHTML="<select name=ziduanming"+inna+" style='width:85%;'><option selected='selected' value='0'>代码</option><option value='1'>名称</option><option value='2'>说明</option></select>";
         td2.innerHTML="<select name=yunsuanfu"+inna+" style='width:88%;'><option selected='selected' value='1'>=</option><option value='2'>&gt;</option><option value='3'>&lt;</option><option value='4'>&gt;=</option><option value='5'>=&lt;</option><option value='6'>包含</option></select>";
         td3.innerHTML="<input name=shuzhi"+inna+" type='text' style='width:90%;'>";
         td4.innerHTML="<input type='button' name='oro' value='或者' onclick='add();'>&nbsp;<input type='button' name='and' value='并且' onclick='add2();'>&nbsp;";
         tr.appendChild(td1);
         tr.appendChild(td2);
         tr.appendChild(td3);
         tr.appendChild(td4);
         document.all.addTable.childNodes[0].appendChild(tr);
         var i=document.all.addTable.rows.length-2;
         var de=index[index.length-1]
         document.all.addTable.rows[i].cells[3].innerHTML="或者<input type='button' name='oro' value='删除' onclick='remove("+de+")'>";        
         document.all.tableContent.value=document.all.addTable.innerHTML;
         //document.write(document.all.tableContent.value)        
         index.push(index[index.length-1]+1);                     
            }
            function add2()
            {
             var tr =document.createElement("tr")
         var td1=document.createElement("td")
         var td2=document.createElement("td")
         var td3=document.createElement("td")        
         var td4=document.createElement("td")
         var inna=index[index.length-1]+1;
         td1.innerHTML="<select name=ziduanming"+inna+" style='width:85%;'><option selected='selected' value='0'>代码</option><option value='1'>名称</option><option value='2'>说明</option></select>";
         td2.innerHTML="<select name=yunsuanfu"+inna+" style='width:88%;'><option selected='selected' value='1'>=</option><option value='2'>&gt;</option><option value='3'>&lt;</option><option value='4'>&gt;=</option><option value='5'>=&lt;</option><option value='6'>包含</option></select>";
         td3.innerHTML="<input name=shuzhi"+inna+" type='text' style='width:90%;'>";
         td4.innerHTML="<input type='button' name='oro' value='或者' onclick='add();'>&nbsp;<input type='button' name='and' value='并且' onclick='add2();'>&nbsp;";
         tr.appendChild(td1);
         tr.appendChild(td2);
         tr.appendChild(td3);
         tr.appendChild(td4);
         document.all.addTable.childNodes[0].appendChild(tr);
         var i=document.all.addTable.rows.length-2;
         var de=index[index.length-1]
         document.all.addTable.rows[i].cells[3].innerHTML="并且<input type='button' name='oro' value='删除' onclick='remove("+de+")'>";        
         document.all.tableContent.value=document.all.addTable.innerHTML;        
         index.push(index[index.length-1]+1);                         
            }
            
            function chaxun()
            {
             alert(index.length);
             var sql="select * from "
             var sindex="";
             for(var s=0;s<document.all.dlstCode.options.length;s++)
             {
             if(document.all.dlstCode.options[s].selected)
             {
             sql+="[_"+document.all.dlstCode.options[s].value+"]";
             }
             }
             sql+=" where ";                         
             for(var i=0;i<index.length;i++)
             {
             var na="ziduanming"+index[i]
             var na2="yunsuanfu"+index[i]
             var na3="shuzhi"+index[i]
             o=document.getElementById(na)
             o2=document.getElementById(na2)
             o3=document.getElementById(na3)            
             for(var j=0;j<o.length;j++)
             {
                                  
             if(o.options[j].selected)
                 {
                 sql+=o.options[j].innerText;    
                 }                 
             }
             for(var l=0;l<o.length;l++)
             {
                                  
             if(o2.options[l].selected)
                 {
                 sql+=o2.options[l].innerText;    
                 }                 
             }        
             sql+="'"+o3.value+"'"
             if(document.all.addTable.rows[i].cells[3].innerText=="或者")
             {
             sql+=" or "
             }else if((document.all.addTable.rows[i].cells[3].innerText=="并且"))
             {
             sql+=" and "
             }
             sindex+=index[i]+";"
            
             }
             sindex=sindex.substring(0,sindex.length-1);
             alert( sql)
             alert( sindex)
             document.all.sql.value=sql;
             document.all.rowlocation.value=sindex;
             document.all.tableContent.value=document.all.addTable.innerHTML;
            }
            function remove(i)
            {                              
             for(var j=0;j<index.length;j++)
             {
             if(i==index[j])
             {
             var k=j
             while(k<index.length)
             {
             index[k]=index[k+1]
             k++;
             }            
             }
             }
             index.length-=1;            
             for(var m=0;m<index.length;m++)
             {
             if(i==0)
             {
             document.all.addTable.deleteRow(0);
             return;
             }
             if(index[m]<i&&i<index[m+1])
             {
             document.all.addTable.deleteRow(m+1);
             return;
             }
             if(index[0]>i)
             {
             document.all.addTable.deleteRow(0);
             return;
             }
            
             }
            
            }
            function change()
            {
             index = new Array();
index.push(0)
//document.all.sql.value=sql;
             //document.all.rowlocation.value="";
             //document.all.tableContent.value="";
             Form1.submit();
            }
        </script>
    </HEAD>
    <body>
    
<form name="Form1" method="post" action="shujuchaxun.jsp?id=3">
<input type="hidden" name="sql">
<input type="hidden" name="tableContent">

<div id="DataImport">
<TABLE id="Table1" height="50" cellSpacing="0" cellPadding="0" width="100%" border="0">
<tr>
<td height="10"></td>
</tr>

<TR>
<TD>
<div id="tCode">
<TABLE id="Table2" style="BORDER-COLLAPSE: collapse; BACKGROUND-COLOR: white; BORDER-BOTTOM-STYLE: none"
borderColor="#61668e" cellSpacing="0" cellPadding="5" width="88%" align="center" border="1">
<TR style="FONT-WEIGHT: bold; COLOR: #c00000; BACKGROUND-COLOR: #9096ae" align="center">
<TD align="left" colSpan="6" valign="middle">高级查询</TD>
</TR>
<TR>
<TD width="20%" height="25">请选择要查询的代码表：</TD>
<TD width="63%"><select name="dlstCode" onchange="change()" language="javascript" id="dlstCode" style="width:99%;">

<option selected="selected" value="05C7BE1F-8A64-5261-44DB-817190298FE3">货物运输常用残sada损代码99999</option>

<option selected="selected" value="22D9C557-84AF-7FA7-F36A-844CCE933563">货物运输常用残损代码eeeeee</option>

<option selected="selected" value="3BF88379-82BC-FF71-583A-E94E56AE8991">货物运输sadas常用残损代码ggg</option>

<option selected="selected" value="40D97547-4FBA-E3BC-C7D5-4854C0F26FFF">货物运输常asdsa用残损代码kkkk</option>

</select></TD>
<TD align="center">
<input type="button" value="详细信息" /></TD>
</TR>
</TABLE>
</div>
</TD>
</TR>
<TR>
<TD><div id="Panel1">
<TABLE style="BORDER-COLLAPSE: collapse; BACKGROUND-COLOR: white; BORDER-BOTTOM-STYLE: none"
borderColor="#61668e" cellSpacing="0" cellPadding="5" width="88%" align="center" border="1">
<TBODY>
<TR style="FONT-WEIGHT: bold; COLOR: #c00000; BACKGROUND-COLOR: #9096ae" align="center">
<TD align="left" colSpan="4">请设置查询条件：</TD>
</TR>
<tr>
<td class="querytd7">
<table width="100%" cellpadding="0" cellspacing="0" border="0">
<TR align="center">
<TD width="20%" height="30">字段名</TD>
<TD width="15%">运算符</TD>
<TD width="48%">值</TD>
<TD width="17%"></TD>
</TR>
</table>
</td>
</tr>
</TR>
<TR>
<TD colSpan="4">
<span id="tdDispay">
<table id="addTable" cellspacing="0" cellpadding="5" rules="all" bordercolor="#61668e" border="1" style="BORDER-RIGHT:#61668e 1px;BORDER-TOP:#61668e 1px;BORDER-LEFT:#61668e 1px;WIDTH:100%;BORDER-BOTTOM:#61668e 1px;BORDER-COLLAPSE:collapse;BACKGROUND-COLOR:white">

<tr align="center">
<TD height="38" width="20%">
<select name="ziduanming0" style="width:85%;">

<option selected="selected" value="0">代码</option>

<option selected="selected" value="0">名称</option>

<option selected="selected" value="0">英文名称</option>

</select></TD>
<TD width="15%"><select name="yunsuanfu0" style="width:88%;">
<option selected="selected" value="1">=</option>
<option value="2">&gt;</option>
<option value="3">&lt;</option>
<option value="4">&gt;=</option>
<option value="5">=&lt;</option>
<option value="6">包含</option>
</select></TD>
<TD width="48%"><input name="shuzhi0" type="text" style="width:90%;" /></TD>
<TD valign="middle">
<input type="button" name="oror" value="或者" onclick="add();">&nbsp;
<input type="button" name="and" value="并且" onclick="add2();">&nbsp;
</TD>
</tr>

</table>



</span>
</TD>
</TR>


<TR>
<TD id="ss" align="right" colSpan="4">
<input type="button" value="查询" onclick="chaxun();Form1.submit();" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<input type="button" value="全文浏览" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</TD>
</TR>
</TABLE>

</div></TD></TR>
<TR>
<TD height="10"></TD>
</TR>
<TR>
<TD align="center">
<TABLE id="Table5" cellSpacing="0" cellPadding="0" width="88%" align="center" border="0">
<TR>
<TD class="querytd2">
<span id="lblRecordNum"></span></TD>
</TR>
</TABLE>
</TD>
</TR>
<TR>
<TD align="center">
</TD>
</TR>
</TBODY></TABLE>
</div>

<div id="dCode">
<TABLE id="Table18" cellSpacing="0" cellPadding="0" width="30%" align="center" border="0">
<tr>
<td height="10"></td>
<TD height="10"></TD>
<TD height="10"></TD>
</tr>
<TR align="center">
<TD align="right"></TD>
<TD align="center">&nbsp;&nbsp;&nbsp;&nbsp;</TD>
<table>

<TD align="left"><input type="button" value="返回" onlick="history.back()" /></TD>
</TR>
</TABLE>
</div>

<input type="hidden" name="rowlocation" >

</form>
</body>
</HTML>

终于有了结果，又是两天；
标签集:TAGS:
回复Comments() 点击Count()

回复Comments

{commenttime}{commentauthor}

{CommentUrl}
{commentcontent}