labelsqlbuild.aspx

动易SiteFactory&#8482 网上商店系统1.0源代码

<%@ Page Language="C#" MasterPageFile="~/Admin/MasterPage.master" AutoEventWireup="true"
    Inherits="PowerEasy.WebSite.Admin.Template.LabelSqlBuild" Title="SQL语句编辑" Codebehind="LabelSqlBuild.aspx.cs" %>

<asp:Content ID="Content1" ContentPlaceHolderID="CphNavigation" runat="Server">
    <pe:ExtendedSiteMapPath ID="SmpNavigator" SiteMapProvider="AdminMapProvider" runat="server" />
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="CphContent" runat="Server">
    <style type="text/css">
    <!-- 
    .dragspandiv{
    	background-color: #ff99cc;
    	FILTER: alpha(opacity=50);
        border: 1px dashed #F6B9D6;
        padding: 5px 5px 5px 5px; 
        width: 80px;
        height: 20px;
        float: left;
        text-align: center;
        margin: 10px;
        overflow:hidden;
    }
    .spanfixdiv{
    	background-color: #FFFBF5;
        border: 1px solid #F6B9D6;
        padding: 5px 5px 5px 5px; 
        width: 80px;
        height: 20px;
        float: left;
        text-align: center;
        margin: 5px;
        overflow:hidden;
        cursor: hand;
    }
   .selectlist{
        background-color: #e6efff;
        border: 1px dashed #2F4F4F;
        padding: 5px 5px 5px 5px; 
        width: 98%;
    }       
    .plist{
        background-color: #e6efff;
        border: 1px dashed #2F4F4F;
        padding: 5px 5px 5px 5px; 
        width: 98%;
        vertical-align: middle;
    }
    .fielddiv{
        background-color: #e6efff;
        border: 1px dashed #2F4F4F;
        padding: 5px 5px 5px 5px; 
        overflow: auto;
        float: left;
        width: 98%;
        height: 100%;
        text-align: left
    }
    -->
</style>
    <asp:ScriptManager ID="ScriptManager1" EnablePartialRendering="true" runat="server" />

    <script id="pejs" type="text/javascript">
<!--
var dragspan;
var src;

function dragstart()
{
    window.drag = 1;
    window.event.returnValue = false;
    
    dragspan = document.createElement('div');
    dragspan.style.position = "absolute";
    dragspan.className = "dragspandiv";
    var mousePos = mouseCoords(window.event);
    dragspan.style.left = mousePos.x + 10;
    dragspan.style.top = mousePos.y + 8;
            
    dragspan.appendChild(document.createTextNode(window.event.srcElement.innerText));
    src = window.event.srcElement.innerText;

    document.body.appendChild(dragspan);
}

function dragend(type)
{
    if(window.drag)
    {
        document.body.removeChild(dragspan);
        var target = window.event.srcElement;
        if(type == 1)
        {
            target.focus();
            var tarobj = document.selection.createRange();
            tarobj.text = "@" + src;
        }
        else
        {
            target.value = "@" + src;
        }
        window.drag = 0;
        window.event.returnValue = true;
    }
    
}

function dragmove()
{
    if(window.drag)
    {
        var ev = ev || window.event;
        var mousePos = mouseCoords(ev);

        ev.returnValue = false;
                 
        dragspan.style.left = mousePos.x + 10;
        dragspan.style.top = mousePos.y + 8;
    }
}

function dragclear()
{
    if(window.drag)
    {
        document.body.removeChild(dragspan);
        window.drag = 0;
        window.event.returnValue = true;
    }
    
}
   
function mouseCoords(ev) {
    if(ev.pageX || ev.pageY) {
      return {x:ev.pageX, y:ev.pageY};
    }
    return {
      x:ev.clientX + document.documentElement.scrollLeft - document.body.clientLeft,
      y:ev.clientY + document.documentElement.scrollTop - document.body.clientTop
    };
}

function movePoint() 
{
    if(window.drag)
    {
        var rng = event.srcElement.createTextRange(); 
        rng.moveToPoint(event.x,event.y); 
        rng.select(); 
    }
}
-->
    </script>

    <table style="width: 100%; margin: 0 auto;" cellpadding="2" cellspacing="1" class="border">
        <tr>
            <td class="spacingtitle" colspan="2" align="center">
                <b>标签查询设置</b></td>
        </tr>
        <tr class="tdbg">
            <td class="tdbg" align="left">
                <asp:UpdatePanel ID="UpdatePanel1" runat="server">
                    <ContentTemplate>
                        <table style="width: 100%; margin: 0 auto;">
                            <tr>
                                <td class="tdbgleft" style="width: 105px; text-align: right;">
                                    输出数量：</td>
                                <td colspan="3">
                                    <asp:TextBox ID="TxtOutNum" runat="server" Text="10" Width="120" Style="text-align: center" />
                                    <ajaxToolkit:NumericUpDownExtender ID="NumericUpDownExtender1" runat="server" TargetControlID="TxtOutNum"
                                        Width="120" RefValues="" ServiceDownMethod="" ServiceUpMethod="" TargetButtonDownID=""
                                        TargetButtonUpID="" />
                                </td>
                            </tr>
                            <tr>
                                <td class="tdbgleft" style="width: 105px; text-align: right;">
                                    选择数据：</td>
                                <td class="tdbg" colspan="3">
                                    <div id="selectdatediv" class="selectlist">
                                        <table>
                                            <tr>
                                                <td style="width: 100px; text-align: right;">
                                                    主表：</td>
                                                <td>
                                                    <asp:DropDownList ID="DbTableDownList" runat="server" Width="166px" AutoPostBack="True"
                                                        OnSelectedIndexChanged="DBTableDownList_SelectedIndexChanged" /></td>