<%@ 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">
</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=">">大于</asp:ListItem>
<asp:ListItem Value="<">小于</asp:ListItem>
<asp:ListItem Value=">=">大于等于</asp:ListItem>
<asp:ListItem Value="<=">小于等于</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=">">大于</asp:ListItem>
<asp:ListItem Value="<">小于</asp:ListItem>
<asp:ListItem Value=">=">大于等于</asp:ListItem>
<asp:ListItem Value="<=">小于等于</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=">">大于</asp:ListItem>
<asp:ListItem Value="<">小于</asp:ListItem>
<asp:ListItem Value=">=">大于等于</asp:ListItem>
<asp:ListItem Value="<=">小于等于</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=">">大于</asp:ListItem>
<asp:ListItem Value="<">小于</asp:ListItem>
<asp:ListItem Value=">=">大于等于</asp:ListItem>
<asp:ListItem Value="<=">小于等于</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=">">大于</asp:ListItem>
<asp:ListItem Value="<">小于</asp:ListItem>
<asp:ListItem Value=">=">大于等于</asp:ListItem>
<asp:ListItem Value="<=">小于等于</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=">">大于</asp:ListItem>
<asp:ListItem Value="<">小于</asp:ListItem>
<asp:ListItem Value=">=">大于等于</asp:ListItem>
<asp:ListItem Value="<=">小于等于</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=">">大于</asp:ListItem>
<asp:ListItem Value="<">小于</asp:ListItem>
<asp:ListItem Value=">=">大于等于</asp:ListItem>
<asp:ListItem Value="<=">小于等于</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=">">大于</asp:ListItem>
<asp:ListItem Value="<">小于</asp:ListItem>
<asp:ListItem Value=">=">大于等于</asp:ListItem>
<asp:ListItem Value="<=">小于等于</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=">">大于</asp:ListItem>
<asp:ListItem Value="<">小于</asp:ListItem>
<asp:ListItem Value=">=">大于等于</asp:ListItem>
<asp:ListItem Value="<=">小于等于</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=">">大于</asp:ListItem>
<asp:ListItem Value="<">小于</asp:ListItem>
<asp:ListItem Value=">=">大于等于</asp:ListItem>
<asp:ListItem Value="<=">小于等于</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=">">大于</asp:ListItem>
<asp:ListItem Value="<">小于</asp:ListItem>
<asp:ListItem Value=">=">大于等于</asp:ListItem>
<asp:ListItem Value="<=">小于等于</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=">">大于</asp:ListItem>
<asp:ListItem Value="<">小于</asp:ListItem>
<asp:ListItem Value=">=">大于等于</asp:ListItem>
<asp:ListItem Value="<=">小于等于</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=">">大于</asp:ListItem>
<asp:ListItem Value="<">小于</asp:ListItem>
<asp:ListItem Value=">=">大于等于</asp:ListItem>
<asp:ListItem Value="<=">小于等于</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=">">大于</asp:ListItem>
<asp:ListItem Value="<">小于</asp:ListItem>
<asp:ListItem Value=">=">大于等于</asp:ListItem>
<asp:ListItem Value="<=">小于等于</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=">">大于</asp:ListItem>
<asp:ListItem Value="<">小于</asp:ListItem>
<asp:ListItem Value=">=">大于等于</asp:ListItem>
<asp:ListItem Value="<=">小于等于</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=">">大于</asp:ListItem>
<asp:ListItem Value="<">小于</asp:ListItem>
<asp:ListItem Value=">=">大于等于</asp:ListItem>
<asp:ListItem Value="<=">小于等于</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=">">大于</asp:ListItem>
<asp:ListItem Value="<">小于</asp:ListItem>
<asp:ListItem Value=">=">大于等于</asp:ListItem>
<asp:ListItem Value="<=">小于等于</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">
</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=">">大于</option>
<option value="<">小于</option>
<option value="=">等于</option>
<option value="<=">小于等于</option>
<option value=">=">大于等于</option>
</select>
<input name="txtname" type="text" value="" title="请您正确填写数据" />
<input name="btndelete" type="button" value="删除该项选择" title="点击删除该项的设置" />