home *** CD-ROM | disk | FTP | other *** search
/ PC World 2004 December / PCWorld_2004-12_cd.bin / software / komercni / netgenium / NETGenium.msi / _B4A5F9DE730F039E0CBFC30C1A8A8467 / _DAE9ADF199844EB6911CF84431007CA3 < prev    next >
Encoding:
Text File  |  2004-10-16  |  16.9 KB  |  279 lines
  1. <%@ Register TagPrefix="uc1" TagName="ColumnXValue" Src="Script/ColumnXValue.ascx" %>
  2. <%@ Register TagPrefix="uc1" TagName="QueryBuilder" Src="QueryBuilder.ascx" %>
  3. <%@ Register TagPrefix="uc1" TagName="DragDrop" Src="DragDrop.ascx" %>
  4. <%@ Register TagPrefix="uc1" TagName="ColumnConditions" Src="ColumnConditions.ascx" %>
  5. <%@ Register TagPrefix="uc1" TagName="HfTable" Src="HfTable.ascx" %>
  6. <%@ Page language="c#" Codebehind="QueryBuilder.aspx.cs" AutoEventWireup="false" Inherits="NETGenium.QueryBuilder_Page" %>
  7. <%@ Register TagPrefix="uc1" TagName="Date" Src="_Date.ascx" %>
  8. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
  9. <HTML>
  10.     <HEAD>
  11.         <title>NET Genium</title>
  12.         <meta content="Microsoft Visual Studio .NET 7.1" name="GENERATOR">
  13.         <meta content="C#" name="CODE_LANGUAGE">
  14.         <meta content="JavaScript" name="vs_defaultClientScript">
  15.         <meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema">
  16.         <LINK href="NETGenium.css" type="text/css" rel="stylesheet">
  17.     </HEAD>
  18.     <body onload="jsOnLoad();">
  19.         <form id="Default" method="post" runat="server">
  20.             <asp:dropdownlist id="braA" runat="server" EnableViewState="False" CssClass="Hidden"></asp:dropdownlist><asp:dropdownlist id="c" runat="server" EnableViewState="False" CssClass="Hidden"></asp:dropdownlist><asp:dropdownlist id="ope" runat="server" EnableViewState="False" CssClass="Hidden"></asp:dropdownlist><asp:dropdownlist id="fc" runat="server" EnableViewState="False" CssClass="Hidden"></asp:dropdownlist><asp:dropdownlist id="braB" runat="server" EnableViewState="False" CssClass="Hidden"></asp:dropdownlist><asp:dropdownlist id="ao" runat="server" EnableViewState="False" CssClass="Hidden"></asp:dropdownlist><asp:dropdownlist id="t" runat="server" EnableViewState="False" CssClass="Hidden"></asp:dropdownlist><asp:dropdownlist id="a" runat="server" EnableViewState="False" CssClass="Hidden"></asp:dropdownlist>
  21.             <TABLE id="Table1" accessKey="" cellSpacing="0" cellPadding="0" border="0" runat="server">
  22.                 <TR>
  23.                     <TD><asp:literal id="lTitle" runat="server" EnableViewState="False"></asp:literal></TD>
  24.                 </TR>
  25.                 <TR>
  26.                     <TD><asp:table id="HeaderTable" runat="server" EnableViewState="False" CellSpacing="0" CellPadding="0"
  27.                             Width="100%"></asp:table></TD>
  28.                 </TR>
  29.                 <TR>
  30.                     <TD class="HeaderTableBody">
  31.                         <TABLE id="Table2" cellSpacing="0" cellPadding="0" border="0" runat="server">
  32.                             <TR>
  33.                                 <TD class="DialogLeft" vAlign="top" width="90"><asp:label id="lblTable" runat="server" EnableViewState="False"></asp:label></TD>
  34.                                 <TD class="DialogMiddle" style="PADDING-BOTTOM: 1px; PADDING-TOP: 1px" vAlign="top"
  35.                                     width="100%"><NOBR><asp:dropdownlist id="ddlAppGroups" runat="server" CssClass="System"></asp:dropdownlist> <asp:dropdownlist id="ddlApps" runat="server" CssClass="System"></asp:dropdownlist> <asp:dropdownlist id="ddlForms" runat="server" CssClass="System"></asp:dropdownlist> <asp:button id="btGoTable" runat="server" Width="30px" CssClass="System" Text="Go" CausesValidation="False"></asp:button><asp:literal id="lFormPicker" runat="server"></asp:literal></NOBR></TD>
  36.                                 <TD class="DialogRight" vAlign="top" width="100%"></TD>
  37.                             </TR>
  38.                             <TR>
  39.                                 <TD class="DialogLeft" vAlign="top"><asp:label id="lblValueColumn" runat="server" EnableViewState="False"></asp:label></TD>
  40.                                 <TD class="DialogMiddle" vAlign="top"><asp:dropdownlist id="ddlValueColumn" runat="server" Width="150px" CssClass="DropDownList"></asp:dropdownlist></TD>
  41.                                 <TD class="DialogRight" vAlign="top"></TD>
  42.                             </TR>
  43.                             <TR>
  44.                                 <TD class="DialogLeft" vAlign="top"><asp:label id="lblSortColumn" runat="server" EnableViewState="False"></asp:label></TD>
  45.                                 <TD class="DialogMiddle" vAlign="top"><NOBR><asp:dropdownlist id="ddlSortColumn" runat="server" Width="150px" CssClass="DropDownList"></asp:dropdownlist> <asp:dropdownlist id="ddlSortDirection" runat="server" CssClass="DropDownList"></asp:dropdownlist></NOBR></TD>
  46.                                 <TD class="DialogRight" vAlign="top"></TD>
  47.                             </TR>
  48.                             <TR>
  49.                                 <TD class="DialogLeft" vAlign="top"><asp:label id="lblColorColumn" runat="server" EnableViewState="False"></asp:label></TD>
  50.                                 <TD class="DialogMiddle" vAlign="top"><asp:dropdownlist id="ddlColorColumn" runat="server" Width="150px" CssClass="DropDownList"></asp:dropdownlist></TD>
  51.                                 <TD class="DialogRight" vAlign="top"></TD>
  52.                             </TR>
  53.                             <TR>
  54.                                 <TD class="DialogLeft" vAlign="top"><asp:label id="lblDateColumn" runat="server" EnableViewState="False"></asp:label></TD>
  55.                                 <TD class="DialogMiddle" vAlign="top"><asp:dropdownlist id="ddlDateColumn" runat="server" Width="150px" CssClass="DropDownList" onchange="jsOnLoad();"></asp:dropdownlist></TD>
  56.                                 <TD class="DialogRight" vAlign="top"></TD>
  57.                             </TR>
  58.                             <TR>
  59.                                 <TD class="DialogLeft" vAlign="top"><asp:label id="lblDefault" runat="server" EnableViewState="False"></asp:label></TD>
  60.                                 <TD class="DialogMiddle" vAlign="top">
  61.                                     <TABLE id="DateTable" cellSpacing="0" cellPadding="0" border="0">
  62.                                         <TR>
  63.                                             <TD><asp:textbox id="tbDefaultDate" runat="server" Width="80px" CssClass="TextBox" MaxLength="10"></asp:textbox></TD>
  64.                                             <TD style="PADDING-LEFT: 2px"><IMG id="imDatePicker" height="20" src="Images/DatePicker.gif" width="22" runat="server"></TD>
  65.                                         </TR>
  66.                                     </TABLE>
  67.                                 </TD>
  68.                                 <TD class="DialogRight" vAlign="top"></TD>
  69.                             </TR>
  70.                             <TR>
  71.                                 <TD class="DialogLeft_CheckBox" vAlign="top"><asp:label id="lblOptions" runat="server" EnableViewState="False"></asp:label></TD>
  72.                                 <TD class="DialogMiddle" vAlign="top"><asp:checkbox id="chbStatistics" runat="server" CssClass="CheckBox" AutoPostBack="True"></asp:checkbox></TD>
  73.                                 <TD class="DialogRight" vAlign="top"></TD>
  74.                             </TR>
  75.                         </TABLE>
  76.                         <TABLE id="Table3" cellSpacing="0" cellPadding="0" width="700" border="0" runat="server">
  77.                             <TR>
  78.                                 <TD><asp:datagrid id="dg1" runat="server" CellSpacing="1" CellPadding="0" GridLines="None" AutoGenerateColumns="False"
  79.                                         ShowHeader="False">
  80.                                         <Columns>
  81.                                             <asp:TemplateColumn>
  82.                                                 <ItemTemplate>
  83.                                                     <asp:dropdownlist id="braA" style="MARGIN-RIGHT: 4px" runat="server" Width="60px" CssClass="DropDownList"></asp:dropdownlist>
  84.                                                 </ItemTemplate>
  85.                                             </asp:TemplateColumn>
  86.                                             <asp:TemplateColumn>
  87.                                                 <ItemTemplate>
  88.                                                     <asp:dropdownlist id="c" runat="server" Width="150px" CssClass="DropDownList" style="margin-right:4px"></asp:dropdownlist>
  89.                                                 </ItemTemplate>
  90.                                             </asp:TemplateColumn>
  91.                                             <asp:TemplateColumn>
  92.                                                 <ItemTemplate>
  93.                                                     <asp:dropdownlist id="ope" runat="server" Width="150px" CssClass="DropDownList" style="margin-right:4px"></asp:dropdownlist>
  94.                                                 </ItemTemplate>
  95.                                             </asp:TemplateColumn>
  96.                                             <asp:TemplateColumn>
  97.                                                 <ItemTemplate>
  98.                                                     <TABLE cellSpacing="0" cellPadding="0" width="150" border="0">
  99.                                                         <TR>
  100.                                                             <TD>
  101.                                                                 <uc1:ColumnXValue id="cxv" runat="server"></uc1:ColumnXValue>
  102.                                                                 <uc1:QueryBuilder id="qb" runat="server"></uc1:QueryBuilder></TD>
  103.                                                         </TR>
  104.                                                     </TABLE>
  105.                                                 </ItemTemplate>
  106.                                             </asp:TemplateColumn>
  107.                                             <asp:TemplateColumn>
  108.                                                 <ItemTemplate>
  109.                                                     <asp:dropdownlist id="braB" style="MARGIN-LEFT: 4px; MARGIN-RIGHT: 4px" runat="server" Width="60px"
  110.                                                         CssClass="DropDownList"></asp:dropdownlist>
  111.                                                 </ItemTemplate>
  112.                                             </asp:TemplateColumn>
  113.                                             <asp:TemplateColumn>
  114.                                                 <ItemTemplate>
  115.                                                     <asp:dropdownlist id="ao" runat="server" Width="60px" CssClass="DropDownList" style="margin-right:4px"></asp:dropdownlist>
  116.                                                 </ItemTemplate>
  117.                                             </asp:TemplateColumn>
  118.                                             <asp:TemplateColumn>
  119.                                                 <ItemTemplate>
  120.                                                     <asp:ImageButton onmousedown="event.cancelBubble = true;" id="d" runat="server" CausesValidation="False"
  121.                                                         ImageAlign="AbsMiddle" CommandName="Delete" ImageUrl="Images/Delete.gif"></asp:ImageButton><IMG height="18" src="Images/Move.gif" width="19">
  122.                                                     <asp:Literal id="l" runat="server"></asp:Literal>
  123.                                                 </ItemTemplate>
  124.                                             </asp:TemplateColumn>
  125.                                         </Columns>
  126.                                     </asp:datagrid><asp:label id="lblEmpty1" runat="server"></asp:label></TD>
  127.                             </TR>
  128.                         </TABLE>
  129.                         <TABLE id="Table4" cellSpacing="0" cellPadding="0" width="700" border="0" runat="server">
  130.                             <TR>
  131.                                 <TD><asp:datagrid id="dg2" runat="server" CellSpacing="1" CellPadding="0" GridLines="None" AutoGenerateColumns="False"
  132.                                         ShowHeader="False">
  133.                                         <Columns>
  134.                                             <asp:TemplateColumn>
  135.                                                 <ItemTemplate>
  136.                                                     <asp:TextBox onmousedown="event.cancelBubble = true;" id="tb" style="MARGIN-RIGHT: 4px" runat="server"
  137.                                                         Width="150px" CssClass="TextBox" MaxLength="255"></asp:TextBox>
  138.                                                 </ItemTemplate>
  139.                                             </asp:TemplateColumn>
  140.                                             <asp:TemplateColumn>
  141.                                                 <ItemTemplate>
  142.                                                     <asp:dropdownlist id="t" style="MARGIN-RIGHT: 4px" runat="server" Width="80px" CssClass="DropDownList"></asp:dropdownlist>
  143.                                                 </ItemTemplate>
  144.                                             </asp:TemplateColumn>
  145.                                             <asp:TemplateColumn>
  146.                                                 <ItemTemplate>
  147.                                                     <asp:dropdownlist id="c" style="MARGIN-RIGHT: 4px" runat="server" Width="150px" CssClass="DropDownList"></asp:dropdownlist>
  148.                                                 </ItemTemplate>
  149.                                             </asp:TemplateColumn>
  150.                                             <asp:TemplateColumn>
  151.                                                 <ItemTemplate>
  152.                                                     <asp:DropDownList id="a" style="MARGIN-RIGHT: 4px" runat="server" Width="80px" CssClass="DropDownList"></asp:DropDownList>
  153.                                                 </ItemTemplate>
  154.                                             </asp:TemplateColumn>
  155.                                             <asp:TemplateColumn>
  156.                                                 <ItemTemplate>
  157.                                                     <uc1:ColumnConditions id="cc" runat="server"></uc1:ColumnConditions>
  158.                                                 </ItemTemplate>
  159.                                             </asp:TemplateColumn>
  160.                                             <asp:TemplateColumn>
  161.                                                 <ItemTemplate>
  162.                                                     <asp:ImageButton onmousedown="event.cancelBubble = true;" id="d" runat="server" CausesValidation="False"
  163.                                                         ImageAlign="AbsMiddle" CommandName="Delete" ImageUrl="Images/Delete.gif"></asp:ImageButton><IMG height="18" src="Images/Move.gif" width="19">
  164.                                                     <asp:Literal id="l" runat="server"></asp:Literal>
  165.                                                 </ItemTemplate>
  166.                                             </asp:TemplateColumn>
  167.                                             <asp:TemplateColumn>
  168.                                                 <ItemTemplate>
  169.                                                     <uc1:HfTable id="hf" runat="server"></uc1:HfTable>
  170.                                                 </ItemTemplate>
  171.                                             </asp:TemplateColumn>
  172.                                         </Columns>
  173.                                     </asp:datagrid><asp:label id="lblEmpty2" runat="server"></asp:label></TD>
  174.                             </TR>
  175.                         </TABLE>
  176.                         <TABLE id="Table5" cellSpacing="0" cellPadding="0" width="700" border="0" runat="server">
  177.                             <TR>
  178.                                 <TD><asp:datagrid id="dg3" runat="server" CellSpacing="1" CellPadding="0" GridLines="None" AutoGenerateColumns="False"
  179.                                         ShowHeader="False">
  180.                                         <Columns>
  181.                                             <asp:TemplateColumn>
  182.                                                 <ItemTemplate>
  183.                                                     <asp:TextBox onmousedown="event.cancelBubble = true;" id="tb" style="MARGIN-RIGHT: 4px" runat="server"
  184.                                                         Width="600px" CssClass="TextBox"></asp:TextBox>
  185.                                                 </ItemTemplate>
  186.                                             </asp:TemplateColumn>
  187.                                             <asp:TemplateColumn>
  188.                                                 <ItemTemplate>
  189.                                                     <asp:ImageButton onmousedown="event.cancelBubble = true;" id="d" runat="server" CausesValidation="False"
  190.                                                         ImageAlign="AbsMiddle" CommandName="Delete" ImageUrl="Images/Delete.gif"></asp:ImageButton><IMG height="18" src="Images/Move.gif" width="19">
  191.                                                 </ItemTemplate>
  192.                                             </asp:TemplateColumn>
  193.                                         </Columns>
  194.                                     </asp:datagrid><asp:label id="lblEmpty3" runat="server"></asp:label></TD>
  195.                             </TR>
  196.                         </TABLE>
  197.                         <TABLE id="Table6" cellSpacing="0" cellPadding="0" width="700" border="0" runat="server">
  198.                             <TR>
  199.                                 <TD>
  200.                                     <asp:datagrid id="dg4" runat="server" CellPadding="0" CellSpacing="1" ShowHeader="False" AutoGenerateColumns="False"
  201.                                         GridLines="None">
  202.                                         <Columns>
  203.                                             <asp:TemplateColumn>
  204.                                                 <ItemTemplate>
  205.                                                     <TABLE cellSpacing="0" cellPadding="0" border="0" onmousedown="event.cancelBubble = true;">
  206.                                                         <TR>
  207.                                                             <TD>
  208.                                                                 <asp:TextBox id="tb" runat="server" CssClass="TextBox" Width="80px"></asp:TextBox></TD>
  209.                                                             <TD style="PADDING-LEFT: 2px"><IMG id="im" height="20" src="Images/ColorPicker.gif" width="22" runat="server"></TD>
  210.                                                         </TR>
  211.                                                     </TABLE>
  212.                                                 </ItemTemplate>
  213.                                             </asp:TemplateColumn>
  214.                                             <asp:TemplateColumn>
  215.                                                 <ItemTemplate>
  216.                                                     <asp:ImageButton onmousedown="event.cancelBubble = true;" id="d" runat="server" CausesValidation="False"
  217.                                                         ImageAlign="AbsMiddle" CommandName="Delete" ImageUrl="Images/Delete.gif"></asp:ImageButton><IMG height="18" src="Images/Move.gif" width="19">
  218.                                                 </ItemTemplate>
  219.                                             </asp:TemplateColumn>
  220.                                         </Columns>
  221.                                     </asp:datagrid>
  222.                                     <asp:label id="lblEmpty4" runat="server"></asp:label></TD>
  223.                             </TR>
  224.                         </TABLE>
  225.                         <TABLE id="Table7" cellSpacing="0" cellPadding="0" border="0" runat="server">
  226.                             <TR>
  227.                                 <TD class="DialogLeft" vAlign="top" width="90"><asp:label id="lblTable2" runat="server" EnableViewState="False"></asp:label></TD>
  228.                                 <TD class="DialogMiddle" style="PADDING-BOTTOM: 1px; PADDING-TOP: 1px" vAlign="top"
  229.                                     width="100%"><NOBR><asp:dropdownlist id="ddlAppGroups2" runat="server" CssClass="System"></asp:dropdownlist> <asp:dropdownlist id="ddlApps2" runat="server" CssClass="System"></asp:dropdownlist> <asp:dropdownlist id="ddlForms2" runat="server" CssClass="System"></asp:dropdownlist> <asp:literal id="lFormPicker2" runat="server"></asp:literal></NOBR></TD>
  230.                                 <TD class="DialogRight" vAlign="top" width="100%"></TD>
  231.                             </TR>
  232.                             <TR>
  233.                                 <TD class="DialogLeft" vAlign="top" width="90">
  234.                                     <asp:label id="lblType" runat="server" EnableViewState="False"></asp:label></TD>
  235.                                 <TD class="DialogMiddle" style="PADDING-BOTTOM: 1px; PADDING-TOP: 1px" vAlign="top"
  236.                                     width="100%">
  237.                                     <asp:dropdownlist id="ddlJoin" runat="server" CssClass="System"></asp:dropdownlist></TD>
  238.                                 <TD class="DialogRight" vAlign="top" width="100%">INNER, LEFT, RIGHT, FULL</TD>
  239.                             </TR>
  240.                         </TABLE>
  241.                         <asp:label id="lblMessage" runat="server" EnableViewState="False" CssClass="ErrorMessage"></asp:label></TD>
  242.                 </TR>
  243.                 <TR>
  244.                     <TD>
  245.                         <TABLE id="ToolbarTable" style="MARGIN-TOP: 7px" cellSpacing="0" cellPadding="0" width="100%"
  246.                             border="0" runat="server">
  247.                             <TR>
  248.                                 <TD align="center" width="50%">
  249.                                     <TABLE id="TableButtons" cellSpacing="0" cellPadding="0" width="100%" border="0" runat="server">
  250.                                         <TR>
  251.                                             <TD></TD>
  252.                                             <TD><asp:button id="btCondition" runat="server" CssClass="Button" CausesValidation="False"></asp:button></TD>
  253.                                             <TD><asp:button id="btColumn" runat="server" CssClass="Button" CausesValidation="False"></asp:button></TD>
  254.                                             <TD><asp:button id="btHeader" runat="server" CssClass="Button" CausesValidation="False"></asp:button><INPUT class="Button" id="btHelp" style="MARGIN-LEFT: 4px; WIDTH: 30px" type="button" value="?"
  255.                                                     runat="server"></TD>
  256.                                             <TD>
  257.                                                 <asp:button id="btColor" runat="server" CssClass="Button" CausesValidation="False"></asp:button></TD>
  258.                                             <TD align="right"></TD>
  259.                                             <TD align="right"><asp:button id="btSave" runat="server" Width="85px" CssClass="Button"></asp:button> <asp:button id="btDeleteQuery" runat="server" Width="85px" CssClass="Button" CausesValidation="False"></asp:button></TD>
  260.                                         </TR>
  261.                                     </TABLE>
  262.                                 </TD>
  263.                             </TR>
  264.                             <TR>
  265.                                 <TD align="left" width="50%"><asp:label id="lblWait" runat="server"></asp:label></TD>
  266.                             </TR>
  267.                         </TABLE>
  268.                     </TD>
  269.                 </TR>
  270.             </TABLE>
  271.             <INPUT id="hfHeader" type="hidden" value="0" name="hfHeader" runat="server">
  272.             <asp:label id="lblHeaderJavaScript" runat="server" EnableViewState="False"></asp:label><asp:literal id="lJavaScript" runat="server" EnableViewState="False"></asp:literal><asp:literal id="lColumns" runat="server"></asp:literal>
  273.             <asp:Literal id="lColors" runat="server"></asp:Literal><asp:rangevalidator id="rvDefaultDate" runat="server" EnableViewState="False" Type="Date" MaximumValue="1.1.2999"
  274.                 MinimumValue="1.1.1901" ControlToValidate="tbDefaultDate" Display="None"></asp:rangevalidator>
  275.             <asp:validationsummary id="ValidationSummary1" runat="server" ShowMessageBox="True" ShowSummary="False"
  276.                 EnableViewState="False"></asp:validationsummary><uc1:dragdrop id="DragDrop1" runat="server"></uc1:dragdrop></form>
  277.     </body>
  278. </HTML>
  279.