freelabel_add.aspx

最好用的站点内容管理系统 全部源代码都有

                s += ',';
            s += sql2[0];
            
        }
        if(s != '')
        {
            sql = 'select '
            if(num != '')
                sql += 'top '+ num +' ';
            sql +=  s +' from '+ tb0 +','+ tb1 +' where '+ tb0 +'.'+ jn0 +'='+ tb1 +'.'+ jn1;
            if(sql1[1] != '')
                sql += ' and '+ sql1[1];
            if(sql2[1] != '')
                sql += ' and '+ sql2[1];
            if(sql1[2] != '')
            {
                sql += ' order by '+ sql1[2];
            }
            if( sql2[2] != '')
            {
                if(sql1[2] != '')
                    sql += ','+ sql2[2];
                else
                    sql += ' order by '+ sql2[2];
            }
        }
    }
    else
    {
        var asq = null;
        var dtb;
        if(sql1 != null)
        {
            asq = sql1;
            dtb = tb0;
        }
        else if(sql2 != null)
        {
            asq = sql1;
            dtb = tb0;
        }
        if(asq != null)
        {
            if(asq[0] != '')
            {
                sql = 'select '
                if(num != '')
                    sql += 'top '+ num +' ';
                sql += asq[0] +' from '+ dtb;
                if(asq[1] != '')
                    sql += ' where '+ asq[1];
                if(asq[2] != '')
                    sql += ' order by '+ asq[2];
            }
        }
    }
    
    document.getElementById("TxtSql").value = sql;
    
}
function GenerateSql(tbl,tb,flag)
{
    var sqls = '';
    var sqlw = '';
    var sqld = '';
    var n = tbl.rows.length;
    for(var i=1;i<n;i++)
    {
        var tr = tbl.rows[i];
        if(tr == null)
            continue;
        var fld = tr.cells[0].innerHTML;
        
        var obj1 = tr.cells[2].firstChild;
        var bdis = false;
        if(obj1 != null && obj1.type == 'checkbox')
        {
            bdis = obj1.checked;
        }
        else
        {
            if(tr.cells[2].innerHTML == '√')
                bdis = true;
        }
        
        var obj2 = tr.cells[3].firstChild;
        var obj3 = tr.cells[3].lastChild;
        var con1 = '';
        var con2 = '';
        if(obj2 != null && obj3 != null && obj2.type == 'select-one' && obj3.type == 'text')
        {
            con1 = obj2.options[obj2.selectedIndex].value;
            con2 = obj3.value;
        }
        else
        {
            var con = tr.cells[3].innerHTML;
            if(con != '')
            {
                var pos = con.indexOf(' ');
                con1 = con.substr(0,pos);
                con2 = con.substr(pos+1);
            }
        }
        
        var obj4 = tr.cells[4].firstChild;
        var ordr = '';
        if(obj4 != null && obj4.type == 'select-one')
        {
            ordr = obj4.options[obj4.selectedIndex].value;
        }
        else
        {
            var ord = tr.cells[4].innerHTML;
            if(ord == '升序')
                ordr = 'ASC';
            else if(ord == '降序')
                ordr = 'DESC';
        }
        
        if(flag)
            fld = tb +'.'+ fld;
        //选中某字段
        if(bdis)
        {
            if(sqls != '')
                sqls += ',';
            sqls += fld;
        }
        if(con1 != '' && con2 != '')
        {
            if(sqlw != '')
                sqlw += ' and ';
            con1 = con1.replace('&lt;','<');
            con1 = con1.replace('&gt;','>');
            sqlw += fld +' '+ con1 +' '+ con2;
        }
        if(ordr != '')
        {
            if(sqld != '')
                sqld += ',';
            sqld += fld +' '+ ordr;
        }
    }
    var ret = new Array(3);
    ret[0] = sqls;
    ret[1] = sqlw;
    ret[2] = sqld;
    return ret;
}
function GoNext()
{
    var snm = document.getElementById('TxtName').value.trim();
    if(snm == '')
    {
        alert('标签名称不能为空!');
        document.getElementById('TxtName').focus();
        return;
    }
    var s = document.getElementById('TxtSql').value.trim();
    if(s == '')
    {
        alert('SQL语句不能为空!');
        document.getElementById('TxtSql').focus();
        return;
    }
    if(s.length > 4000)
    {
        alert('SQL语句长度不能超过4000,请适当减少查询的字段或条件!');
        document.getElementById('TxtSql').focus();
        return;
    }
    document.Form1.target = '_self';
    document.Form1.action = 'FreeLabel_AddEnd.aspx';
    document.Form1.submit();
}
function CheckNumber(obj)
{
    var sql = document.getElementById('TxtSql').value;
    var n = obj.value.trim();
    var reg = /select top \d+/i;
    if(n != '')
    {
        if(!n.IsNum())
        {
            alert('查询数量必须为正整数!');
            obj.value = '10';
            obj.focus();
        }
        document.getElementById('TxtSql').value = sql.replace(reg,'select top '+ n);
    }
    else
    {
        document.getElementById('TxtSql').value = sql.replace(reg,'select');
    }
}
function TestSQL()
{
    document.Form1.action = 'FreeLabel_Test.aspx';
    document.Form1.target = '_blank';
    document.Form1.submit();
}
//-->
</script>
</head>
<body>
    <form id="Form1" name="Form1" method="post" action="FreeLabel_AddEnd.aspx">
        <div>
            <table id="top1" width="100%" border="0" cellpadding="0" cellspacing="0" class="toptable">
                <tr>
                    <td height="1" colspan="2">
                    </td>
                </tr>
                <tr>
                    <td width="57%" class="sysmain_navi" style="padding-left: 14px">
                        <%# Caption%></td>
                    <td width="43%" class="topnavichar" style="padding-left: 14px">
                        <div align="left">
                            位置导航：<a href="../main.aspx" target="sys_main" class="list_link">首页</a><img alt="" src="../../sysImages/folder/navidot.gif" border="0" /><a
                                href="FreeLabel_List.aspx" target="sys_main" class="list_link">自由标签管理</a><img alt="" src="../../sysImages/folder/navidot.gif" border="0" /><%# Caption%></div>
                    </td>
                </tr>
            </table>
            <table width="100%" border="0" align="center" cellpadding="3" cellspacing="1" class="Navitable">
                <tr>
                    <td style="padding-left: 14px">
                        <a class="topnavichar" href="javascript:GoNext();">下一步</a> <a class="topnavichar" href="javascript:history.back();">
                            返回</a></td>
                </tr>
            </table>
            <table width="98%" cellpadding="5" cellspacing="1" align="center" class="table">
                <tr class="TR_BG_list">
                    <td width="50%">
                        标签名称：<span style="font-weight:bold;color:Red">{NT_FREE_</span><input name="TxtName" id="TxtName" maxlength="30" type="text" class="form" value="<%# lblname%>"/><span style="font-weight:bold;color:Red">}</span>
                    </td>
                    <td width="50%">
                        查询数量：<input name="TxtNum" onchange="CheckNumber(this)" id="TxtNum" style="width:80%" type="text" maxlength="9" value="<%# TopNum%>" class="form" />
                    </td>
                </tr>
                <tr class="TR_BG_list">
                    <td>主 &nbsp;&nbsp; 表： 
                        <select id="SelPrin" name="SelPrin" onchange="ChangeDbTable(this,0)">
                            <option value="0">请选择</option>
                            <%# TabList1%>
                         </select>
                    </td>
                    <td>从 &nbsp;&nbsp; 表： 
                        <select id="SelSub" name="SelSub" onchange="ChangeDbTable(this,1)">
                            <option value="0">请选择</option>
                            <%# TabList2%>
                        </select>
                    </td>
               </tr>
               <tr class="TR_BG_list">
                    <td>
                        <div style="background-color:White;width:100%;height:200px;overflow:auto;border-color:#cccccc;border-width:1px;border-style:groove;padding-left:3px;padding-top:5px;">
                            <table id="TBL0" width="96%" cellpadding="0" cellspacing="0">
                                <tbody id="TBD0">
                                    <tr>
                                        <td align="center" width="40%">字段名</td><td align="center" width="15%">类型</td><td align="center" width="10%">显示</td><td align="center" width="25%">条件</td><td align="center" width="10%">排序</td>
                                    </tr>
                                    <%# List1%>
                                </tbody>
                            </table>
                        </div>
                    </td>
                    <td>
                        <div style="background-color:White;width:100%;height:200px;overflow:auto;border-color:#cccccc;border-width:1px;border-style:groove;padding-left:3px;padding-top:5px;">
                            <table id="TBL1" width="96%" cellpadding="0" cellspacing="0">
                                <tbody id="TBD1">
                                    <tr>
                                        <td align="center" width="40%">字段名</td><td align="center" width="15%">类型</td><td align="center" width="10%">显示</td><td align="center" width="25%">条件</td><td align="center" width="10%">排序</td>
                                    </tr>
                                    <%# List2%>
                                </tbody>
                            </table>
                        </div>
                   </td>
               </tr>
                <tr class="TR_BG_list">
                    <td colspan="2">
                        联接字段：主表字段 <select id="SelJoinPrin" onchange="ChangeSql(this)"><option value="0">请选择</option><%# JoinFlds1%></select> 从表字段 <select id="SelJoinSub" onchange="ChangeSql(this)"><option value="0">请选择</option><%# JoinFlds2%></select>
                    </td>
                </tr>
                <tr class="TR_BG_list">
                    <td colspan="2">SQL语句  <input type="button" onclick="TestSQL()" value="执行SQL语句" /></td>
                </tr>
                <tr class="TR_BG_list">
                    <td colspan="2" style="WORD-BREAK: break-all;">
                        <textarea cols="7" rows="7" id="TxtSql" name="TxtSql" readonly="readonly" class="form" style="width:99%;height:70px; overflow:auto;"><%# lblsql%></textarea>
                    </td>
                </tr>
            </table>
            <div style="color:Red">
<p>说明：</p>
<p>1.此功能建议具有一定sql基础的人使用。如果不熟悉sql，请谨慎使用，以防误操作引起的数据损坏。</p>
<p>2.判断型数字赋值：0为否，1为是。</p>
<p>3.如果设置条件的字段为文本、文本型ID、时间日期等类型，赋值时请前后加 ' ，如：= '内容' 、In('内容1'，'内容2'),否则会出错；Like关系除外。</p>
<p>4.在下一步设置之前，建议先点击测试按钮确认sql语句没有问题再继续。</p>
            </div>
            <br />
            <table width="100%" border="0" cellpadding="8" cellspacing="0" class="copyright_bg"
                style="height: 76px">
                <tr>
                    <td align="center">
                        <%Response.Write(CopyRight);%>
                    </td>
                </tr>
            </table>
        </div>
        <input type="hidden" name="LID" value="<%# id%>" />
        <input type="hidden" name="StyleCon" value="<%# stylecon%>" />
        <input type="hidden" name="Descrpt" value="<%# descrpt%>" />
    </form>
</body>
</html>