219 lines
12 KiB
Plaintext
219 lines
12 KiB
Plaintext
<%@ Page Title="" Language="C#" MasterPageFile="~/Site2.Master" AutoEventWireup="true" CodeBehind="查詢作業.aspx.cs" Inherits="Education.Forms.基本資料.查詢作業" %>
|
|
|
|
<%@ Register Assembly="WebLib" Namespace="WebLib" TagPrefix="weblib" %>
|
|
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
|
|
</asp:Content>
|
|
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
|
|
<asp:ObjectDataSource ID="ds場地" runat="server" OldValuesParameterFormatString="original_{0}" SelectMethod="查詢作業" TypeName="Education.DAC_場地">
|
|
<SelectParameters>
|
|
<asp:Parameter DefaultValue="false" Name="noInputReturnAll" Type="Boolean" />
|
|
<asp:ControlParameter ControlID="ddl場地地區" DefaultValue="" Name="地區" PropertyName="SelectedValue" Type="String" />
|
|
<asp:ControlParameter ControlID="txt場地價格1" Name="價格1" PropertyName="Text" Type="Int32" />
|
|
<asp:ControlParameter ControlID="txt場地價格2" Name="價格2" PropertyName="Text" Type="Int32" />
|
|
<asp:ControlParameter ControlID="txt場地人數1" Name="人數1" PropertyName="Text" Type="Int32" />
|
|
<asp:ControlParameter ControlID="txt場地人數2" Name="人數2" PropertyName="Text" Type="Int32" />
|
|
<asp:ControlParameter ControlID="ddl場地教室類型" Name="場地類型" PropertyName="SelectedValue" Type="String" />
|
|
<asp:ControlParameter ControlID="txt場地滿意度1" Name="滿意度1" PropertyName="Text" Type="Int32" />
|
|
<asp:ControlParameter ControlID="txt場地滿意度2" Name="滿意度2" PropertyName="Text" Type="Int32" />
|
|
</SelectParameters>
|
|
</asp:ObjectDataSource>
|
|
<asp:ObjectDataSource ID="ds講師" runat="server" OldValuesParameterFormatString="original_{0}" SelectMethod="查詢作業" TypeName="Education.DAC_講師">
|
|
<SelectParameters>
|
|
<asp:Parameter DefaultValue="false" Name="noInputReturnAll" Type="Boolean" />
|
|
<asp:ControlParameter ControlID="ddl講師地區" DefaultValue="" Name="地區" PropertyName="SelectedValue" Type="String" />
|
|
<asp:ControlParameter ControlID="txt講師專長" Name="專長" PropertyName="Text" Type="String" />
|
|
<asp:ControlParameter ControlID="txt講師學歷" Name="學歷" PropertyName="Text" Type="String" />
|
|
<asp:ControlParameter ControlID="txt講師滿意度1" Name="滿意度1" PropertyName="Text" Type="Int32" />
|
|
<asp:ControlParameter ControlID="txt講師滿意度2" Name="滿意度2" PropertyName="Text" Type="Int32" />
|
|
</SelectParameters>
|
|
</asp:ObjectDataSource>
|
|
<table>
|
|
<tr>
|
|
<td class="captionCenter" colspan="4">
|
|
<asp:Label ID="Label9" runat="server" Text="場地查詢"></asp:Label>
|
|
</td>
|
|
<td style="width: 30px"> </td>
|
|
<td class="captionCenter" colspan="4">
|
|
<asp:Label ID="Label18" runat="server" Text="講師查詢"></asp:Label>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td class="caption">
|
|
<asp:Label ID="Label10" runat="server" Text="地區"></asp:Label>
|
|
</td>
|
|
<td class="datainput" colspan="3">
|
|
<weblib:WDropDownList ID="ddl場地地區" runat="server" CssClass="inputFull">
|
|
</weblib:WDropDownList>
|
|
</td>
|
|
<td class="datainput"> </td>
|
|
<td class="caption">
|
|
<asp:Label ID="Label19" runat="server" Text="地區"></asp:Label>
|
|
</td>
|
|
<td class="datainput" colspan="3">
|
|
<weblib:WDropDownList ID="ddl講師地區" runat="server" CssClass="inputFull">
|
|
</weblib:WDropDownList>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td class="caption">
|
|
<asp:Label ID="Label11" runat="server" Text="價格"></asp:Label>
|
|
</td>
|
|
<td class="datainput">
|
|
<asp:TextBox ID="txt場地價格1" runat="server"></asp:TextBox>
|
|
</td>
|
|
<td class="datainput">
|
|
<asp:Label ID="Label15" runat="server" Text="至"></asp:Label>
|
|
</td>
|
|
<td class="datainput">
|
|
<asp:TextBox ID="txt場地價格2" runat="server"></asp:TextBox>
|
|
</td>
|
|
<td class="datainput"> </td>
|
|
<td class="caption">
|
|
<asp:Label ID="Label21" runat="server" Text="專長"></asp:Label>
|
|
</td>
|
|
<td class="datainput" colspan="3">
|
|
<asp:TextBox ID="txt講師專長" runat="server" CssClass="inputFull"></asp:TextBox>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td class="caption">
|
|
<asp:Label ID="Label12" runat="server" Text="容納人數"></asp:Label>
|
|
</td>
|
|
<td class="datainput">
|
|
<asp:TextBox ID="txt場地人數1" runat="server"></asp:TextBox>
|
|
</td>
|
|
<td class="datainput">
|
|
<asp:Label ID="Label16" runat="server" Text="至"></asp:Label>
|
|
</td>
|
|
<td class="datainput">
|
|
<asp:TextBox ID="txt場地人數2" runat="server"></asp:TextBox>
|
|
</td>
|
|
<td class="datainput"> </td>
|
|
<td class="caption">
|
|
<asp:Label ID="Label22" runat="server" Text="學歷"></asp:Label>
|
|
</td>
|
|
<td class="datainput" colspan="3">
|
|
<asp:TextBox ID="txt講師學歷" runat="server" CssClass="inputFull"></asp:TextBox>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td class="caption">
|
|
<asp:Label ID="Label13" runat="server" Text="教室類型"></asp:Label>
|
|
</td>
|
|
<td class="datainput" colspan="3">
|
|
<weblib:WDropDownList ID="ddl場地教室類型" runat="server" CssClass="inputFull">
|
|
</weblib:WDropDownList>
|
|
</td>
|
|
<td class="datainput"> </td>
|
|
<td class="caption">
|
|
<asp:Label ID="Label20" runat="server" Text="滿意度"></asp:Label>
|
|
</td>
|
|
<td class="datainput">
|
|
<asp:TextBox ID="txt講師滿意度1" runat="server"></asp:TextBox>
|
|
</td>
|
|
<td class="datainput">
|
|
<asp:Label ID="Label23" runat="server" Text="至"></asp:Label>
|
|
</td>
|
|
<td class="datainput">
|
|
<asp:TextBox ID="txt講師滿意度2" runat="server"></asp:TextBox>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td class="caption">
|
|
<asp:Label ID="Label14" runat="server" Text="滿意度"></asp:Label>
|
|
</td>
|
|
<td class="datainput">
|
|
<asp:TextBox ID="txt場地滿意度1" runat="server"></asp:TextBox>
|
|
</td>
|
|
<td class="datainput">
|
|
<asp:Label ID="Label17" runat="server" Text="至"></asp:Label>
|
|
</td>
|
|
<td class="datainput">
|
|
<asp:TextBox ID="txt場地滿意度2" runat="server"></asp:TextBox>
|
|
</td>
|
|
<td class="datainput"> </td>
|
|
<td class="datainput" colspan="4">
|
|
<asp:LinkButton ID="btn查詢2" runat="server" CssClass="button blue80" OnClick="btn查詢2_Click">查詢</asp:LinkButton>
|
|
<asp:LinkButton ID="btn清除2" runat="server" CssClass="button orange80" OnClick="btn清除2_Click">清除</asp:LinkButton>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td class="datainput" colspan="4">
|
|
<asp:LinkButton ID="btn查詢1" runat="server" CssClass="button blue80" OnClick="btn查詢1_Click">查詢</asp:LinkButton>
|
|
<asp:LinkButton ID="btn清除1" runat="server" CssClass="button orange80" OnClick="btn清除1_Click">清除</asp:LinkButton>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
<asp:Panel ID="pnl場地" runat="server">
|
|
<h3>場地查詢結果</h3>
|
|
<asp:GridView ID="gv場地" runat="server" AutoGenerateColumns="False" DataKeyNames="編號" DataSourceID="ds場地" EnableModelValidation="True" EnableViewState="False" OnDataBound="gv場地_DataBound">
|
|
<Columns>
|
|
<asp:TemplateField>
|
|
<ItemTemplate>
|
|
<asp:LinkButton ID="LinkButton1" runat="server" CssClass="button blue60" OnClientClick='<%# GetOpenWindowJS("PlaceDetail.aspx", "_placeDetail", "id", Eval("編號")) %>'>詳情</asp:LinkButton>
|
|
</ItemTemplate>
|
|
</asp:TemplateField>
|
|
<asp:BoundField DataField="編號" HeaderText="編號" ReadOnly="True" SortExpression="編號" DataFormatString="{0:0000}" />
|
|
<asp:BoundField DataField="單位名稱" HeaderText="單位名稱" SortExpression="單位名稱" />
|
|
<asp:BoundField DataField="場地名稱" HeaderText="場地名稱" SortExpression="場地名稱" />
|
|
<asp:BoundField DataField="場地類型" HeaderText="場地類型" SortExpression="場地類型" />
|
|
<asp:BoundField DataField="價格" HeaderText="價格" SortExpression="價格" />
|
|
<asp:BoundField DataField="坪數" HeaderText="坪數" SortExpression="坪數" />
|
|
<asp:BoundField DataField="容納人數" HeaderText="容納人數" SortExpression="容納人數" />
|
|
<asp:TemplateField HeaderText="地址" SortExpression="地址_郵編">
|
|
<ItemTemplate>
|
|
<asp:Label ID="Label1" runat="server" Text='<%# Bind("地址_郵編") %>'></asp:Label>
|
|
<asp:Label ID="Label2" runat="server" Text='<%# Bind("地址_縣市") %>'></asp:Label>
|
|
<asp:Label ID="Label3" runat="server" Text='<%# Bind("地址_鄉鎮市區") %>'></asp:Label>
|
|
<asp:Label ID="Label4" runat="server" Text='<%# Bind("地址_街道地址") %>'></asp:Label>
|
|
</ItemTemplate>
|
|
</asp:TemplateField>
|
|
<asp:BoundField DataField="聯絡人" HeaderText="聯絡人" SortExpression="聯絡人" />
|
|
<asp:BoundField DataField="聯絡人電話" HeaderText="聯絡人電話" SortExpression="聯絡人電話" />
|
|
<asp:BoundField DataField="電子郵件" HeaderText="電子郵件" SortExpression="電子郵件" />
|
|
<asp:BoundField DataField="傳真" HeaderText="傳真" SortExpression="傳真" />
|
|
</Columns>
|
|
<EmptyDataTemplate>
|
|
<asp:Label ID="Label24" runat="server" CssClass="ErrorMessage" Text="查無符合條件的資料，請輸入其他查詢條件"></asp:Label>
|
|
</EmptyDataTemplate>
|
|
<PagerTemplate>
|
|
<weblib:GridViewPager ID="GridViewPager2" runat="server" />
|
|
</PagerTemplate>
|
|
</asp:GridView>
|
|
</asp:Panel>
|
|
<asp:Panel ID="pnl講師" runat="server">
|
|
<h3>講師查詢結果</h3>
|
|
<asp:GridView ID="gv講師" runat="server" AutoGenerateColumns="False" DataKeyNames="編號" DataSourceID="ds講師" EnableModelValidation="True" EnableViewState="False" OnDataBound="gv講師_DataBound">
|
|
<Columns>
|
|
<asp:TemplateField>
|
|
<ItemTemplate>
|
|
<asp:LinkButton ID="LinkButton1" runat="server" CssClass="button blue60" OnClientClick='<%# GetOpenWindowJS("TeacherDetail.aspx", "_teacherDetail", "id", Eval("編號")) %>'>詳情</asp:LinkButton>
|
|
</ItemTemplate>
|
|
</asp:TemplateField>
|
|
<asp:BoundField DataField="編號" HeaderText="編號" ReadOnly="True" SortExpression="編號" DataFormatString="{0:0000}" />
|
|
<asp:BoundField DataField="姓名" HeaderText="姓名" SortExpression="姓名" />
|
|
<asp:BoundField DataField="電話" HeaderText="電話" SortExpression="電話" />
|
|
<asp:BoundField DataField="手機" HeaderText="手機" SortExpression="手機" />
|
|
<asp:BoundField DataField="電子郵件" HeaderText="電子郵件" SortExpression="電子郵件" />
|
|
<asp:TemplateField HeaderText="居住地址" SortExpression="居住地址_郵編">
|
|
<ItemTemplate>
|
|
<asp:Label ID="Label1" runat="server" Text='<%# Bind("居住地址_郵編") %>'></asp:Label>
|
|
<asp:Label ID="Label2" runat="server" Text='<%# Bind("居住地址_縣市") %>'></asp:Label>
|
|
<asp:Label ID="Label3" runat="server" Text='<%# Bind("居住地址_鄉鎮市區") %>'></asp:Label>
|
|
<asp:Label ID="Label4" runat="server" Text='<%# Bind("居住地址_街道地址") %>'></asp:Label>
|
|
</ItemTemplate>
|
|
</asp:TemplateField>
|
|
<asp:BoundField DataField="學歷" HeaderText="學歷" SortExpression="學歷" />
|
|
<asp:BoundField DataField="授課區域" HeaderText="授課區域" SortExpression="授課區域" />
|
|
<asp:BoundField DataField="授課專長領域" HeaderText="授課專長領域" SortExpression="授課專長領域" />
|
|
</Columns>
|
|
<EmptyDataTemplate>
|
|
<asp:Label ID="Label24" runat="server" CssClass="ErrorMessage" Text="查無符合條件的資料，請輸入其他查詢條件"></asp:Label>
|
|
</EmptyDataTemplate>
|
|
<PagerTemplate>
|
|
<weblib:GridViewPager ID="GridViewPager1" runat="server" />
|
|
</PagerTemplate>
|
|
</asp:GridView>
|
|
</asp:Panel>
|
|
</asp:Content>
|