项目存储页WEBGIS(bs_webgis)---1(07.09.06)

来源:互联网 发布:大淘宝客那里找 编辑:程序博客网 时间:2024/06/13 12:48

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="report_integrationquery.aspx.cs" Inherits="WavenetWebApp.Webs.dataforgis.report_integrationquery" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >

<head runat="server">
    <title>无标题页</title>
<link href="../sqxx/images/css.css" type="text/css" rel="stylesheet"/>
<script type="text/jscript" src="../sqxx/images/newcalendar/calendar.js"></script>
<style type="text/css">
body{
 text-align:center;
}
.titleStyle{
 width:100%;
 height:33px;
 background-color:#008800;
 color:#ffffff;
 border-top:0px solid #FFFFFF;
 font-size:12px;
}
.contentStyle{
 width:100%;
 height:200px;
 background-color:#DFECE6;
 color:black;
 font-size:12px;
 left:0px;
 top:0px;
}
a{
 color:blue;
 text-decoration:   none;
}
body{
 font-size:9pt;
}
</style>
</head>
<body style="background-color: aliceblue">
    <form id="form1" runat="server">
    <div id="DIV1">
    <div>
    <table cellpadding="0" cellspacing="0" id="t0">
    <tr>
    <td align="right" style="width: 73px; height: 24px;">
    </td>
    <td align="right"></td>
    </tr>
    </table>
     </div>
        <table style="width: 900px; height: 24px" cellpadding="0" cellspacing="0">
        <tr>
        <td align="right" style="width: 73px; height: 24px;">
            <asp:Label ID="Label2" runat="server"
        Text="选择闸站:" Width="66px" Font-Bold="True" ForeColor="Blue" Height="17px"></asp:Label></td><td align="left" style="height: 24px; width: 99px;"><asp:DropDownList ID="ddlzz" runat="server" Width="171px" AutoPostBack="True" OnSelectedIndexChanged="ddlzz_SelectedIndexChanged" ToolTip="下拉选择水闸">
    </asp:DropDownList>
        </td>
        <td style="width: 356px"></td>
        </tr>
        <tr>
        <td align="right" style="width: 73px; height: 24px;">
        <asp:Label ID="Label1" runat="server" Text="选择字段:" Width="66px" Font-Bold="True" ForeColor="Blue" Height="17px"></asp:Label>
        </td>
        <td align="left" style="height: 24px; width: 99px;">
        <asp:DropDownList ID="ddlziduan" runat="server" Width="127px" OnSelectedIndexChanged="ddlziduan_SelectedIndexChanged" ToolTip="下拉选择属性字段"></asp:DropDownList>
        </td>
        <td style="width: 356px" align="right"><asp:ImageButton ID="imgaddnew" runat="server" AlternateText="添加字段选项进行编辑" EnableViewState="False" ImageUrl="~/Image/sizeplus.gif" OnClick="imgaddnew_Click"/></td>
        <td align="right" style="height: 24px">
            &nbsp;</td>
        </tr>
        </table>
        <table style="width: 900px; height: 596px" cellpadding="0" cellspacing="0">
            <tr>
                <td style="width: 100px; height: 12px;">
                    <asp:Panel ID="Panel1" runat="server" Height="25px" Width="600px" Visible="False">
                    <table cellpadding="0" cellspacing="0" id="t1" style="width: 599px; height: 32px;">
                    <tr>
                    <td align="right" style="width: 71px; height: 32px;"><asp:Label ID="lbltime" runat="server" Text="时间选择:" Width="65px" Font-Bold="True" ForeColor="Blue" Height="18px"></asp:Label></td>
                    <td align="left" style="width: 155px; height: 32px;"><asp:TextBox ID="tbxprevious" runat="server" onClick="setday(this);" Width="145px" BackColor="White" ForeColor="Navy" ToolTip="单击选择起始时间,不选默认为空"></asp:TextBox></td>
                    <td align="center" style="height: 32px"><asp:Label ID="lblzhi" runat="server" Text="至"></asp:Label></td>
                    <td align="left" style="height: 32px"><asp:TextBox
                        ID="tbxnext" runat="server" onClick="setday(this);" Width="149px" BackColor="White" ForeColor="Navy" ToolTip="单击选择终止时间,不选默认为空"></asp:TextBox></td>
                    <td align="right" style="height: 32px; width: 66px;"><asp:ImageButton ID="ImageButton1" runat="server" AlternateText="清除该选项" EnableViewState="False" ImageUrl="~/Image/sizeminus.gif" OnClick="ImageButton1_Click"/></td>
                    </tr>
                    </table>
                    </asp:Panel>
                    <asp:Panel ID="Panel2" runat="server" Height="25px" Width="600px" Visible="False">
                        <table>
                            <tr>
                                <td style="width: 100px">
                        <asp:Label ID="Label3" runat="server" Text="闸门开度1:" Font-Bold="True" ForeColor="Blue" Height="19px" Width="72px"></asp:Label></td>
                                <td style="width: 179px">
                        <asp:DropDownList ID="ddlzm1" runat="server" Width="73px">
                            <asp:ListItem Value="&gt;">大于</asp:ListItem>
                            <asp:ListItem Value="&lt;">小于</asp:ListItem>
                            <asp:ListItem Value="&gt;=">大于等于</asp:ListItem>
                            <asp:ListItem Value="&lt;=">小于等于</asp:ListItem>
                            <asp:ListItem Value="=">等于</asp:ListItem>
                        </asp:DropDownList></td>
                                <td style="width: 111px" align="right">
                                    <asp:TextBox ID="tbxzm1" runat="server" ToolTip="请您正确输入闸门开度"></asp:TextBox></td>
                                <td style="width: 233px" align="right">
                    <asp:ImageButton ID="ImageButton2" runat="server" AlternateText="清除该选项" EnableViewState="False" ImageUrl="~/Image/sizeminus.gif" OnClick="ImageButton2_Click" /></td>
                            </tr>
                        </table>
                    </asp:Panel>
                    <asp:Panel ID="Panel3" runat="server" Height="25px" Width="600px" Visible="False">
                        <table>
                            <tr>
                                <td style="width: 100px">
                                    <asp:Label ID="Label4" runat="server" Font-Bold="True" ForeColor="Blue" Height="19px"
                                        Text="闸门开度2:" Width="72px"></asp:Label></td>
                                <td style="width: 169px">
                                    <asp:DropDownList ID="ddlzm2" runat="server" Width="73px">
                                        <asp:ListItem Value="&gt;">大于</asp:ListItem>
                                        <asp:ListItem Value="&lt;">小于</asp:ListItem>
                                        <asp:ListItem Value="&gt;=">大于等于</asp:ListItem>
                                        <asp:ListItem Value="&lt;=">小于等于</asp:ListItem>
                                        <asp:ListItem Value="=">等于</asp:ListItem>
                                    </asp:DropDownList></td>
                                <td style="width: 100px">
                                    <asp:TextBox ID="tbxzm2" runat="server" ToolTip="请您正确输入闸门开度"></asp:TextBox></td>
                                <td style="width: 227px" align="right">
                    <asp:ImageButton ID="ImageButton3" runat="server" AlternateText="清除该选项" EnableViewState="False" ImageUrl="~/Image/sizeminus.gif" OnClick="ImageButton3_Click" /></td>
                            </tr>
                        </table>
                    </asp:Panel>
                    <asp:Panel ID="Panel4" runat="server" Height="25px" Width="600px" Visible="False">
                        <table>
                            <tr>
                                <td style="width: 100px">
                                    <asp:Label ID="Label5" runat="server" Font-Bold="True" ForeColor="Blue" Height="19px"
                                        Text="闸门开度3:" Width="72px"></asp:Label></td>
                                <td style="width: 182px">
                                    <asp:DropDownList ID="ddlzm3" runat="server" Width="73px">
                                        <asp:ListItem Value="&gt;">大于</asp:ListItem>
                                        <asp:ListItem Value="&lt;">小于</asp:ListItem>
                                        <asp:ListItem Value="&gt;=">大于等于</asp:ListItem>
                                        <asp:ListItem Value="&lt;=">小于等于</asp:ListItem>
                                        <asp:ListItem Value="=">等于</asp:ListItem>
                                    </asp:DropDownList></td>
                                <td style="width: 139px" align="right">
                                    <asp:TextBox ID="tbxzm3" runat="server" ToolTip="请您正确输入闸门开度"></asp:TextBox></td>
                                <td style="width: 243px" align="right">
                    <asp:ImageButton ID="ImageButton4" runat="server" AlternateText="清除该选项" EnableViewState="False" ImageUrl="~/Image/sizeminus.gif" OnClick="ImageButton4_Click" /></td>
                            </tr>
                        </table>
                    </asp:Panel>
                    <asp:Panel ID="Panel5" runat="server" Height="25px" Width="600px" Visible="False">
                        <table>
                            <tr>
                                <td style="width: 100px">
                                    <asp:Label ID="Label6" runat="server" Font-Bold="True" ForeColor="Blue" Height="19px"
                                        Text="闸门开度4:" Width="72px"></asp:Label></td>
                                <td style="width: 192px">
                                    <asp:DropDownList ID="ddlzm4" runat="server" Width="73px">
                                        <asp:ListItem Value="&gt;">大于</asp:ListItem>
                                        <asp:ListItem Value="&lt;">小于</asp:ListItem>
                                        <asp:ListItem Value="&gt;=">大于等于</asp:ListItem>
                                        <asp:ListItem Value="&lt;=">小于等于</asp:ListItem>
                                        <asp:ListItem Value="=">等于</asp:ListItem>
                                    </asp:DropDownList></td>
                                <td style="width: 100px">
                                    <asp:TextBox ID="tbxzm4" runat="server" ToolTip="请您正确输入闸门开度"></asp:TextBox></td>
                                <td style="width: 259px" align="right">
                    <asp:ImageButton ID="ImageButton5" runat="server" AlternateText="清除该选项" EnableViewState="False" ImageUrl="~/Image/sizeminus.gif" OnClick="ImageButton5_Click" /></td>
                            </tr>
                        </table>
                    </asp:Panel>
                    <asp:Panel ID="Panel6" runat="server" Height="25px" Width="600px" Visible="False">
                        <table>
                            <tr>
                                <td style="width: 100px">
                                    <asp:Label ID="Label7" runat="server" Font-Bold="True" ForeColor="Blue" Height="19px"
                                        Text="闸门开度5:" Width="72px"></asp:Label></td>
                                <td style="width: 172px">
                                    <asp:DropDownList ID="ddlzm5" runat="server" Width="73px">
                                        <asp:ListItem Value="&gt;">大于</asp:ListItem>
                                        <asp:ListItem Value="&lt;">小于</asp:ListItem>
                                        <asp:ListItem Value="&gt;=">大于等于</asp:ListItem>
                                        <asp:ListItem Value="&lt;=">小于等于</asp:ListItem>
                                        <asp:ListItem Value="=">等于</asp:ListItem>
                                    </asp:DropDownList></td>
                                <td style="width: 100px">
                                    <asp:TextBox ID="tbxzm5" runat="server" ToolTip="请您正确输入闸门开度"></asp:TextBox></td>
                                <td style="width: 237px" align="right">
                    <asp:ImageButton ID="ImageButton6" runat="server" AlternateText="清除该选项" EnableViewState="False" ImageUrl="~/Image/sizeminus.gif" OnClick="ImageButton6_Click" /></td>
                            </tr>
                        </table>
                    </asp:Panel>
                    <asp:Panel ID="Panel7" runat="server" Height="25px" Width="600px" Visible="False">
                        <table>
                            <tr>
                                <td style="width: 100px">
                                    <asp:Label ID="Label8" runat="server" Font-Bold="True" ForeColor="Blue" Height="19px"
                                        Text="闸门开度6:" Width="72px"></asp:Label></td>
                                <td style="width: 173px">
                                    <asp:DropDownList ID="ddlzm6" runat="server" Width="73px">
                                        <asp:ListItem Value="&gt;">大于</asp:ListItem>
                                        <asp:ListItem Value="&lt;">小于</asp:ListItem>
                                        <asp:ListItem Value="&gt;=">大于等于</asp:ListItem>
                                        <asp:ListItem Value="&lt;=">小于等于</asp:ListItem>
                                        <asp:ListItem Value="=">等于</asp:ListItem>
                                    </asp:DropDownList></td>
                                <td style="width: 100px">
                                    <asp:TextBox ID="tbxzm6" runat="server" ToolTip="请您正确输入闸门开度"></asp:TextBox></td>
                                <td style="width: 232px" align="right">
                    <asp:ImageButton ID="ImageButton7" runat="server" AlternateText="清除该选项" EnableViewState="False" ImageUrl="~/Image/sizeminus.gif" OnClick="ImageButton7_Click" /></td>
                            </tr>
                        </table>
                    </asp:Panel>
                    <asp:Panel ID="Panel8" runat="server" Height="25px" Width="600px" Visible="False">
                        <table>
                            <tr>
                                <td style="width: 100px">
                                    <asp:Label ID="Label9" runat="server" Font-Bold="True" ForeColor="Blue" Height="19px"
                                        Text="内河水位:" Width="72px"></asp:Label></td>
                                <td style="width: 181px">
                                    <asp:DropDownList ID="ddlnhsw" runat="server" Width="73px">
                                        <asp:ListItem Value="&gt;">大于</asp:ListItem>
                                        <asp:ListItem Value="&lt;">小于</asp:ListItem>
                                        <asp:ListItem Value="&gt;=">大于等于</asp:ListItem>
                                        <asp:ListItem Value="&lt;=">小于等于</asp:ListItem>
                                        <asp:ListItem Value="=">等于</asp:ListItem>
                                    </asp:DropDownList></td>
                                <td style="width: 100px">
                                    <asp:TextBox ID="tbxnhsw" runat="server" ToolTip="请您正确输入闸门开度"></asp:TextBox></td>
                                <td style="width: 239px" align="right">
                    <asp:ImageButton ID="ImageButton8" runat="server" AlternateText="清除该选项" EnableViewState="False" ImageUrl="~/Image/sizeminus.gif" OnClick="ImageButton8_Click" /></td>
                            </tr>
                        </table>
                    </asp:Panel>
                    <asp:Panel ID="Panel9" runat="server" Height="25px" Width="600px" Visible="False">
                        <table>
                            <tr>
                                <td style="width: 100px">
                                    <asp:Label ID="Label10" runat="server" Font-Bold="True" ForeColor="Blue" Height="19px"
                                        Text="外河水位:" Width="72px"></asp:Label></td>
                                <td style="width: 182px">
                                    <asp:DropDownList ID="ddlwhsw" runat="server" Width="73px">
                                        <asp:ListItem Value="&gt;">大于</asp:ListItem>
                                        <asp:ListItem Value="&lt;">小于</asp:ListItem>
                                        <asp:ListItem Value="&gt;=">大于等于</asp:ListItem>
                                        <asp:ListItem Value="&lt;=">小于等于</asp:ListItem>
                                        <asp:ListItem Value="=">等于</asp:ListItem>
                                    </asp:DropDownList></td>
                                <td style="width: 100px">
                                    <asp:TextBox ID="tbxwhsw" runat="server" ToolTip="请您正确输入闸门开度"></asp:TextBox></td>
                                <td style="width: 243px" align="right">
                    <asp:ImageButton ID="ImageButton9" runat="server" AlternateText="清除该选项" EnableViewState="False" ImageUrl="~/Image/sizeminus.gif" OnClick="ImageButton9_Click" /></td>
                            </tr>
                        </table>
                    </asp:Panel>
                    <asp:Panel ID="Panel10" runat="server" Height="25px" Width="600px" Visible="False">
                        <table>
                            <tr>
                                <td style="width: 100px">
                                    <asp:Label ID="Label11" runat="server" Font-Bold="True" ForeColor="Blue" Height="19px"
                                        Text="雨      量:" Width="72px"></asp:Label></td>
                                <td style="width: 169px">
                                    <asp:DropDownList ID="ddlyl" runat="server" Width="73px">
                                        <asp:ListItem Value="&gt;">大于</asp:ListItem>
                                        <asp:ListItem Value="&lt;">小于</asp:ListItem>
                                        <asp:ListItem Value="&gt;=">大于等于</asp:ListItem>
                                        <asp:ListItem Value="&lt;=">小于等于</asp:ListItem>
                                        <asp:ListItem Value="=">等于</asp:ListItem>
                                    </asp:DropDownList></td>
                                <td style="width: 100px">
                                    <asp:TextBox ID="tbxyl" runat="server" ToolTip="请您正确输入闸门开度"></asp:TextBox></td>
                                <td style="width: 231px" align="right">
                    <asp:ImageButton ID="ImageButton10" runat="server" AlternateText="清除该选项" EnableViewState="False" ImageUrl="~/Image/sizeminus.gif" OnClick="ImageButton10_Click" /></td>
                            </tr>
                        </table>
                    </asp:Panel>
                    <asp:Panel ID="Panel11" runat="server" Height="25px" Width="600px" Visible="False">
                        <table>
                            <tr>
                                <td style="width: 100px">
                                    <asp:Label ID="Label12" runat="server" Font-Bold="True" ForeColor="Blue" Height="19px"
                                        Text="流      量:" Width="72px"></asp:Label></td>
                                <td style="width: 163px">
                                    <asp:DropDownList ID="ddlll" runat="server" Width="73px">
                                        <asp:ListItem Value="&gt;">大于</asp:ListItem>
                                        <asp:ListItem Value="&lt;">小于</asp:ListItem>
                                        <asp:ListItem Value="&gt;=">大于等于</asp:ListItem>
                                        <asp:ListItem Value="&lt;=">小于等于</asp:ListItem>
                                        <asp:ListItem Value="=">等于</asp:ListItem>
                                    </asp:DropDownList></td>
                                <td style="width: 100px">
                                    <asp:TextBox ID="tbxll" runat="server" ToolTip="请您正确输入闸门开度"></asp:TextBox></td>
                                <td style="width: 228px" align="right">
                    <asp:ImageButton ID="ImageButton11" runat="server" AlternateText="清除该选项" EnableViewState="False" ImageUrl="~/Image/sizeminus.gif" OnClick="ImageButton11_Click" /></td>
                            </tr>
                        </table>
                    </asp:Panel>
                    <asp:Panel ID="Panel12" runat="server" Height="25px" Width="600px" Visible="False">
                        <table>
                            <tr>
                                <td style="width: 100px">
                                    <asp:Label ID="Label13" runat="server" Font-Bold="True" ForeColor="Blue" Height="19px"
                                        Text="电       压:" Width="72px"></asp:Label></td>
                                <td style="width: 163px">
                                    <asp:DropDownList ID="ddldy" runat="server" Width="73px">
                                        <asp:ListItem Value="&gt;">大于</asp:ListItem>
                                        <asp:ListItem Value="&lt;">小于</asp:ListItem>
                                        <asp:ListItem Value="&gt;=">大于等于</asp:ListItem>
                                        <asp:ListItem Value="&lt;=">小于等于</asp:ListItem>
                                        <asp:ListItem Value="=">等于</asp:ListItem>
                                    </asp:DropDownList></td>
                                <td style="width: 100px">
                                    <asp:TextBox ID="tbxdy" runat="server"
                                        ToolTip="请您正确输入电压数"></asp:TextBox></td>
                                <td style="width: 229px" align="right">
                    <asp:ImageButton ID="ImageButton12" runat="server" AlternateText="清除该选项" EnableViewState="False" ImageUrl="~/Image/sizeminus.gif" OnClick="ImageButton12_Click" /></td>
                            </tr>
                        </table>
                    </asp:Panel>
                    <asp:Panel ID="Panel13" runat="server" Height="25px" Width="600px" Visible="False">
                        <table>
                            <tr>
                                <td style="width: 100px">
                                    <asp:Label ID="Label14" runat="server" Font-Bold="True" ForeColor="Blue" Height="19px"
                                        Text="闸门泵站1:" Width="72px"></asp:Label></td>
                                <td style="width: 163px">
                                    <asp:DropDownList ID="ddlbz1" runat="server" Width="73px">
                                        <asp:ListItem Value="&gt;">大于</asp:ListItem>
                                        <asp:ListItem Value="&lt;">小于</asp:ListItem>
                                        <asp:ListItem Value="&gt;=">大于等于</asp:ListItem>
                                        <asp:ListItem Value="&lt;=">小于等于</asp:ListItem>
                                        <asp:ListItem Value="=">等于</asp:ListItem>
                                    </asp:DropDownList></td>
                                <td style="width: 100px">
                                    <asp:TextBox ID="tbxbz1" runat="server" ToolTip="请您正确输入闸门泵站数"></asp:TextBox></td>
                                <td style="width: 225px" align="right">
                    <asp:ImageButton ID="ImageButton13" runat="server" AlternateText="清除该选项" EnableViewState="False" ImageUrl="~/Image/sizeminus.gif" OnClick="ImageButton13_Click" /></td>
                            </tr>
                        </table>
                    </asp:Panel>
                    <asp:Panel ID="Panel14" runat="server" Height="25px" Width="600px" Visible="False">
                        <table>
                            <tr>
                                <td style="width: 100px">
                                    <asp:Label ID="Label19" runat="server" Font-Bold="True" ForeColor="Blue" Height="19px"
                                        Text="闸门泵站2:" Width="72px"></asp:Label></td>
                                <td style="width: 180px">
                                    <asp:DropDownList ID="ddlbz2" runat="server" Width="73px">
                                        <asp:ListItem Value="&gt;">大于</asp:ListItem>
                                        <asp:ListItem Value="&lt;">小于</asp:ListItem>
                                        <asp:ListItem Value="&gt;=">大于等于</asp:ListItem>
                                        <asp:ListItem Value="&lt;=">小于等于</asp:ListItem>
                                        <asp:ListItem Value="=">等于</asp:ListItem>
                                    </asp:DropDownList></td>
                                <td style="width: 100px">
                                    <asp:TextBox ID="tbxbz2" runat="server" ToolTip="请您正确输入闸门泵站数"></asp:TextBox></td>
                                <td style="width: 240px" align="right">
                    <asp:ImageButton ID="ImageButton14" runat="server" AlternateText="清除该选项" EnableViewState="False" ImageUrl="~/Image/sizeminus.gif" OnClick="ImageButton14_Click" /></td>
                            </tr>
                        </table>
                    </asp:Panel>
                    <asp:Panel ID="Panel15" runat="server" Height="25px" Width="600px" Visible="False">
                        <table>
                            <tr>
                                <td style="width: 100px">
                                    <asp:Label ID="Label18" runat="server" Font-Bold="True" ForeColor="Blue" Height="19px"
                                        Text="闸门泵站3:" Width="72px"></asp:Label></td>
                                <td style="width: 187px">
                                    <asp:DropDownList ID="ddlbz3" runat="server" Width="73px">
                                        <asp:ListItem Value="&gt;">大于</asp:ListItem>
                                        <asp:ListItem Value="&lt;">小于</asp:ListItem>
                                        <asp:ListItem Value="&gt;=">大于等于</asp:ListItem>
                                        <asp:ListItem Value="&lt;=">小于等于</asp:ListItem>
                                        <asp:ListItem Value="=">等于</asp:ListItem>
                                    </asp:DropDownList></td>
                                <td style="width: 100px">
                                    <asp:TextBox ID="tbxbz3" runat="server" ToolTip="请您正确输入闸门泵站数"></asp:TextBox></td>
                                <td style="width: 244px" align="right">
                    <asp:ImageButton ID="ImageButton15" runat="server" AlternateText="清除该选项" EnableViewState="False" ImageUrl="~/Image/sizeminus.gif" OnClick="ImageButton15_Click" /></td>
                            </tr>
                        </table>
                    </asp:Panel>
                    <asp:Panel ID="Panel16" runat="server" Height="25px" Width="600px" Visible="False">
                        <table>
                            <tr>
                                <td style="width: 101px">
                                    <asp:Label ID="Label17" runat="server" Font-Bold="True" ForeColor="Blue" Height="19px"
                                        Text="闸门泵站4:" Width="72px"></asp:Label></td>
                                <td style="width: 175px">
                                    <asp:DropDownList ID="ddlbz4" runat="server" Width="73px">
                                        <asp:ListItem Value="&gt;">大于</asp:ListItem>
                                        <asp:ListItem Value="&lt;">小于</asp:ListItem>
                                        <asp:ListItem Value="&gt;=">大于等于</asp:ListItem>
                                        <asp:ListItem Value="&lt;=">小于等于</asp:ListItem>
                                        <asp:ListItem Value="=">等于</asp:ListItem>
                                    </asp:DropDownList></td>
                                <td style="width: 100px">
                                    <asp:TextBox ID="tbxbz4" runat="server" ToolTip="请您正确输入闸门泵站数"></asp:TextBox></td>
                                <td style="width: 231px" align="right">
                    <asp:ImageButton ID="ImageButton16" runat="server" AlternateText="清除该选项" EnableViewState="False" ImageUrl="~/Image/sizeminus.gif" OnClick="ImageButton16_Click" /></td>
                            </tr>
                        </table>
                    </asp:Panel>
                    <asp:Panel ID="Panel17" runat="server" Height="25px" Width="600px" Visible="False">
                        <table>
                            <tr>
                                <td style="width: 100px">
                                    <asp:Label ID="Label16" runat="server" Font-Bold="True" ForeColor="Blue" Height="19px"
                                        Text="闸门泵站5:" Width="72px"></asp:Label></td>
                                <td style="width: 183px">
                                    <asp:DropDownList ID="ddlbz5" runat="server" Width="73px">
                                        <asp:ListItem Value="&gt;">大于</asp:ListItem>
                                        <asp:ListItem Value="&lt;">小于</asp:ListItem>
                                        <asp:ListItem Value="&gt;=">大于等于</asp:ListItem>
                                        <asp:ListItem Value="&lt;=">小于等于</asp:ListItem>
                                        <asp:ListItem Value="=">等于</asp:ListItem>
                                    </asp:DropDownList></td>
                                <td style="width: 100px">
                                    <asp:TextBox ID="tbxbz5" runat="server" ToolTip="请您正确输入闸门泵站数"></asp:TextBox></td>
                                <td style="width: 234px" align="right">
                    <asp:ImageButton ID="ImageButton17" runat="server" AlternateText="清除该选项" EnableViewState="False" ImageUrl="~/Image/sizeminus.gif" OnClick="ImageButton17_Click" /></td>
                            </tr>
                        </table>
                    </asp:Panel>
                    <asp:Panel ID="Panel18" runat="server" Height="25px" Width="600px" Visible="False">
                        <table>
                            <tr>
                                <td style="width: 101px">
                                    <asp:Label ID="Label15" runat="server" Font-Bold="True" ForeColor="Blue" Height="19px"
                                        Text="闸门泵站6:" Width="72px"></asp:Label></td>
                                <td style="width: 189px">
                                    <asp:DropDownList ID="ddlbz6" runat="server" Width="73px">
                                        <asp:ListItem Value="&gt;">大于</asp:ListItem>
                                        <asp:ListItem Value="&lt;">小于</asp:ListItem>
                                        <asp:ListItem Value="&gt;=">大于等于</asp:ListItem>
                                        <asp:ListItem Value="&lt;=">小于等于</asp:ListItem>
                                        <asp:ListItem Value="=">等于</asp:ListItem>
                                    </asp:DropDownList></td>
                                <td style="width: 100px">
                                    <asp:TextBox ID="tbxbz6" runat="server" ToolTip="请您正确输入闸门泵站数"></asp:TextBox></td>
                                <td style="width: 237px" align="right">
                    <asp:ImageButton ID="ImageButton18" runat="server" AlternateText="清除该选项" EnableViewState="False" ImageUrl="~/Image/sizeminus.gif" OnClick="ImageButton18_Click" /></td>
                            </tr>
                        </table>
                    </asp:Panel>
                    </td>
            </tr>
            <tr>
            <td align="left" style="height: 6px">
                <asp:ImageButton ID="imgall" runat="server" AlternateText="点击查询所有详情" EnableViewState="False" ImageUrl="~/Image/suoyou_zhazhan.gif" OnClick="imgall_Click"/>
            </td>
            <td align="right" style="height: 6px">
            &nbsp;</td>                                                                                                                                          
            <td style="width: 100px; height: 6px;" align="left">
                <asp:ImageButton ID="imgshuaxin" runat="server" AlternateText="点击查询设置条件详情" EnableViewState="False" ImageUrl="~/Image/zx.gif" OnClick="imgshuaxin_Click" />
            </td>
            </tr>
        </table>
    <table>
    </table>
   
    </div>
    </form>
</body>
</html>

 

 

 

 

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
namespace WavenetWebApp.Webs.dataforgis
{
    public partial class report_integrationquery : System.Web.UI.Page
    {
        string constr;
        string constr_xxzx;
        protected void Page_Load(object sender, EventArgs e)
        {
            constr = System.Configuration.ConfigurationSettings.AppSettings.Get("ConnectionString");
            constr_xxzx = System.Configuration.ConfigurationSettings.AppSettings.Get("sz_xxzx");
            if (!(Page.IsPostBack))
            {
                //给ddlzz绑定数据
                bindDdzz();
                addziduan();
            }
        }

        /// <summary>
        /// 给DropDownList闸站点绑定数据
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void bindDdzz()
        {
            string str = "select STATION_ID,水闸名称 from BS_SHUIZ2";
            SqlConnection sqlconn = new SqlConnection(constr);
            SqlDataAdapter myda = new SqlDataAdapter(str, sqlconn);
            DataSet ds = new DataSet();
            myda.Fill(ds, "BS_SHUIZ2");
            ddlzz.DataSource = ds.Tables["BS_SHUIZ2"].DefaultView;
            ddlzz.DataTextField = "水闸名称";
            ddlzz.DataValueField = "STATION_ID";
            ddlzz.DataBind();
        }

        /// <summary>
        /// 给ddlziduan的DropDownList加载
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void addziduan()
        {
            string str1 = "select ziduan,name from BS_zhaidduizhao";
            SqlConnection sqlconn1 = new SqlConnection(constr);
            SqlDataAdapter myda1 = new SqlDataAdapter(str1, sqlconn1);
            DataSet ds1 = new DataSet();
            myda1.Fill(ds1, "BS_zhaidduizhao");
            ddlziduan.DataSource = ds1.Tables["BS_zhaidduizhao"].DefaultView;
            ddlziduan.DataTextField = "name";
            ddlziduan.DataValueField = "ziduan";
            ddlziduan.DataBind();
        }


        protected void ddlzz_SelectedIndexChanged(object sender, EventArgs e)
        {

        }

        protected void ddlziduan_SelectedIndexChanged(object sender, EventArgs e)
        {
           
        }

        protected void imgaddnew_Click(object sender, ImageClickEventArgs e)
        {
            switch(ddlziduan.SelectedIndex)
            {
                case 0:
                    screen();
                    Panel1.Visible = true;
                    break;
                case 1:
                    screen();
                    Panel2.Visible = true;
                    break;
                case 2:
                    screen();
                    Panel3.Visible = true;
                    break;
                case 3:
                    screen();
                    Panel4.Visible = true;
                    break;
                case 4:
                    screen();
                    Panel5.Visible = true;
                    break;
                case 5:
                    screen();
                    Panel6.Visible = true;
                    break;
                case 6:
                    screen();
                    Panel7.Visible = true;
                    break;
                case 7:
                    screen();
                    Panel8.Visible = true;
                    break;
                case 8:
                    screen();
                    Panel9.Visible = true;
                    break;
                case 9:
                    screen();
                    Panel10.Visible = true;
                    break;
                case 10:
                    screen();
                    Panel11.Visible = true;
                    break;
                case 11:
                    screen();
                    Panel12.Visible = true;
                    break;
                case 12:
                    screen();
                    Panel13.Visible = true;
                    break;
                case 13:
                    screen();
                    Panel14.Visible = true;
                    break;
                case 14:
                    screen();
                    Panel15.Visible = true;
                    break;
                case 15:
                    screen();
                    Panel16.Visible = true;
                    break;
                case 16:
                    screen();
                    Panel17.Visible = true;
                    break;
                case 17:
                    screen();
                    Panel18.Visible = true;
                    break;
                default:
                    break;
            }
        }

        private void screen()
        {
            Panel1.Visible = false;
            Panel2.Visible = false;
            Panel3.Visible = false;
            Panel4.Visible = false;
            Panel5.Visible = false;
            Panel6.Visible = false;
            Panel7.Visible = false;
            Panel8.Visible = false;
            Panel9.Visible = false;
            Panel10.Visible = false;
            Panel11.Visible = false;
            Panel12.Visible = false;
            Panel13.Visible = false;
            Panel14.Visible = false;
            Panel15.Visible = false;
            Panel16.Visible = false;
            Panel17.Visible = false;
            Panel18.Visible = false;
        }

        protected void imgshuaxin_Click(object sender, ImageClickEventArgs e)
        {
            string strdata = "select STATION_ID,TIME_STAMP,DOOR1,DOOR2,DOOR3,DOOR4,DOOR5,DOOR6,IN_RIVER,OUT_RIVER,RAIN,FLUX,POWER,PUMP1,PUMP2,PUMP3,PUMP4,PUMP5,PUMP6 from dataset where STATION_ID=" + ddlzz.SelectedValue + StrQuery();
            strdata += "order by STATION_ID , TIME_STAMP desc";
            Response.Redirect("report_produce.aspx?strdata=" + strdata);
        }

        //18个字段PANEL设置
        protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
        {
            Panel1.Visible = false;
        }

        protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
        {
            Panel2.Visible = false;
        }

        protected void ImageButton3_Click(object sender, ImageClickEventArgs e)
        {
            Panel3.Visible = false;
        }

        protected void ImageButton4_Click(object sender, ImageClickEventArgs e)
        {
            Panel4.Visible = false;
        }

        protected void ImageButton5_Click(object sender, ImageClickEventArgs e)
        {
            Panel5.Visible = false;
        }

        protected void ImageButton6_Click(object sender, ImageClickEventArgs e)
        {
            Panel6.Visible = false;
        }

        protected void ImageButton7_Click(object sender, ImageClickEventArgs e)
        {
            Panel7.Visible = false;
        }

        protected void ImageButton8_Click(object sender, ImageClickEventArgs e)
        {
            Panel8.Visible = false;
        }

        protected void ImageButton9_Click(object sender, ImageClickEventArgs e)
        {
            Panel9.Visible = false;
        }

        protected void ImageButton10_Click(object sender, ImageClickEventArgs e)
        {
            Panel10.Visible = false;
        }

        protected void ImageButton11_Click(object sender, ImageClickEventArgs e)
        {
            Panel11.Visible = false;
        }

        protected void ImageButton12_Click(object sender, ImageClickEventArgs e)
        {
            Panel12.Visible = false;
        }

        protected void ImageButton13_Click(object sender, ImageClickEventArgs e)
        {
            Panel13.Visible = false;
        }

        protected void ImageButton14_Click(object sender, ImageClickEventArgs e)
        {
            Panel14.Visible = false;
        }

        protected void ImageButton15_Click(object sender, ImageClickEventArgs e)
        {
            Panel15.Visible = false;
        }

        protected void ImageButton16_Click(object sender, ImageClickEventArgs e)
        {
            Panel16.Visible = false;
        }

        protected void ImageButton17_Click(object sender, ImageClickEventArgs e)
        {
            Panel17.Visible = false;
        }

        protected void ImageButton18_Click(object sender, ImageClickEventArgs e)
        {
            Panel18.Visible = false;
        }
        //所有闸点信息查询
        protected void imgall_Click(object sender, ImageClickEventArgs e)
        {
            Response.Redirect("report_produce.aspx?strdata=" + "suoyou");
        }

        //做查询字符串拼接
        public string StrQuery()
        {
            string str = "";
            if (this.tbxprevious.Text != "")//previoustime
            {
                str += " and TIME_STAMP >= to_date('" + tbxprevious.Text + "','yyyy-MM-dd hh24-mi-ss')";
            }
            if (tbxnext.Text != "")//nexttime
            {
                str += " and TIME_STAMP <= to_date('" + tbxnext.Text + "','yyyy-MM-dd hh24-mi-ss')";
            }
            if (tbxzm1.Text!= "")//zm1
            {
                str += " and DOOR1 " + ddlzm1.SelectedValue + " " + tbxzm1.Text;
            }
            if (tbxzm2.Text != "")//zm2
            {
                str += " and DOOR2 " + ddlzm2.SelectedValue + " " + tbxzm2.Text;
            }
            if (tbxzm3.Text != "")//zm3
            {
                str += " and DOOR3 " + ddlzm3.SelectedValue + " " + tbxzm3.Text;
            }
            if (tbxzm4.Text != "")//zm4
            {
                str += " and DOOR4 " + ddlzm4.SelectedValue + " " + tbxzm4.Text;
            }
            if (tbxzm5.Text != "")//zm5
            {
                str += " and DOOR5 " + ddlzm5.SelectedValue + " " + tbxzm5.Text;
            }
            if (tbxzm6.Text != "")//zm6
            {
                str += " and DOOR6 " + ddlzm6.SelectedValue + " " + tbxzm6.Text;
            }
            if (tbxnhsw.Text != "")//nh
            {
                str += " and IN_RIVER " + ddlnhsw.SelectedValue + " " + tbxnhsw.Text;
            }
            if (tbxwhsw.Text != "")//wh
            {
                str += " and OUT_RIVER " + ddlwhsw.SelectedValue + " " + tbxwhsw.Text;
            }
            if (tbxyl.Text != "")//yl
            {
                str += " and RAIN " + ddlyl.SelectedValue + " " + tbxyl.Text;
            }
            if (tbxll.Text != "")//ll
            {
                str += " and FLUX " + ddlll.SelectedValue + " " + tbxll.Text;
            }
            if (tbxdy.Text != "")//dy
            {
                str += " and POWER " + ddldy.SelectedValue + " " + tbxdy.Text;
            }
            if (tbxbz1.Text != "")//bz1
            {
                str += " and PUMP1 " + ddlbz1.SelectedValue + " " + tbxbz1.Text;
            }
            if (tbxbz2.Text != "")//bz2
            {
                str += " and PUMP2 " + ddlbz2.SelectedValue + " " + tbxbz2.Text;
            }
            if (tbxbz3.Text != "")//bz3
            {
                str += " and PUMP3 " + ddlbz3.SelectedValue + " " + tbxbz3.Text;
            }
            if (tbxbz4.Text != "")//bz4
            {
                str += " and PUMP4 " + ddlbz4.SelectedValue + " " + tbxbz4.Text;
            }
            if (tbxbz5.Text != "")//bz5
            {
                str += " and PUMP5 " + ddlbz5.SelectedValue + " " + tbxbz5.Text;
            }
            if (tbxbz6.Text != "")//bz6
            {
                str += " and PUMP6 " + ddlbz6.SelectedValue + " " + tbxbz6.Text;
            }
            return str;
        }
    }
}

 

<select name="selectzd" style="width: 182px" title="选择属性字段">
            <option selected="selected"></option>
        </select>
        <select name="selectgx" style="width: 95px" title="选择属性关系">
            <option value="&gt;">大于</option>
            <option value="&lt;">小于</option>
            <option value="=">等于</option>
            <option value="&lt;=">小于等于</option>
            <option value="&gt;=">大于等于</option>
        </select>
        <input name="txtname" type="text" value="" title="请您正确填写数据" />
        <input name="btndelete" type="button" value="删除该项选择" title="点击删除该项的设置" />