thinkyu/教育訓練系統/Web/Forms/選課/受訓紀錄查詢.aspx

<%@ Page Title="" Language="C#" MasterPageFile="~/Site2.Master" AutoEventWireup="true"
  CodeBehind="受訓紀錄查詢.aspx.cs" Inherits="Education.Forms.選課.受訓紀錄查詢" %>

<%@ Register Assembly="WebLib" Namespace="WebLib" TagPrefix="weblib" %>
<%@ Register Src="~/Forms/Common/起訖日顯示.ascx" TagPrefix="uc1" TagName="起訖日顯示" %>
<%@ Register Src="~/Forms/辦訓狀況/UC出席狀況.ascx" TagPrefix="uc1" TagName="UC出席狀況" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
  <asp:Panel ID="pnlSelect" runat="server" Visible="false">
    <table>
      <tr>
        <td>
          <asp:Label ID="Label1" runat="server" Text="員工編號"></asp:Label></td>
        <td>
          <weblib:LookupTextBox ID="txt員工編號" runat="server" LookupConfigName="BPSN" OutputControl="txt員工姓名" />
        </td>
        <td>
          <asp:TextBox ID="txt員工姓名" runat="server"></asp:TextBox></td>
        <td>
          <asp:LinkButton ID="btnSearch" runat="server" CssClass="button blue60"
            OnClick="btnSearch_Click">查詢</asp:LinkButton></td>
      </tr>
    </table>
    <asp:Label ID="lbMessage" runat="server" Text="" EnableViewState="false" CssClass="ErrorMessage"></asp:Label>
  </asp:Panel>
  <asp:ObjectDataSource ID="ds選課" runat="server" OldValuesParameterFormatString="original_{0}"
    OnObjectCreating="ds選課_ObjectCreating" OnSelecting="ds選課_Selecting" SelectMethod="Select選課紀錄"
    TypeName="Education.DAC_課程報名">
    <SelectParameters>
      <asp:Parameter Name="學員編號" Type="String" />
      <asp:Parameter Name="僅已簽核" Type="Boolean" DefaultValue="false" />
      <asp:Parameter Name="僅必修" Type="Boolean" DefaultValue="false" />
      <asp:Parameter Name="僅已上課" Type="Boolean" DefaultValue="false" />
      <asp:Parameter Name="僅已出席" Type="Boolean" DefaultValue="false" />
    </SelectParameters>
  </asp:ObjectDataSource>
  <asp:ObjectDataSource ID="ds數位課程" runat="server" OldValuesParameterFormatString="original_{0}"
    OnSelecting="ds數位課程_Selecting" SelectMethod="Select觀看紀錄" TypeName="Education.DAC_數位課程觀看紀錄">
    <SelectParameters>
      <asp:Parameter Name="學員編號" Type="String" />
    </SelectParameters>
  </asp:ObjectDataSource>
  <asp:ObjectDataSource runat="server" ID="ds外部受訓紀錄" OldValuesParameterFormatString="original_{0}"
    SelectMethod="Select" TypeName="Education.DAC_外部受訓紀錄" OnSelecting="ds外部受訓紀錄_Selecting">
    <SelectParameters>
      <asp:Parameter Name="noInputReturnAll" Type="Boolean" DefaultValue="False"></asp:Parameter>
      <asp:Parameter Name="員工編號" Type="String" />
      <asp:Parameter Name="實施單位" Type="String" DefaultValue="" />
      <asp:Parameter Name="課程類別" Type="String" DefaultValue="" />
      <asp:Parameter Name="訓練名稱" Type="String" DefaultValue="" />
      <asp:Parameter Name="訓練年度" Type="Int32" DefaultValue="0" />
      <asp:Parameter Name="訓練單位" Type="String" DefaultValue="" />
    </SelectParameters>
  </asp:ObjectDataSource>
  <asp:ObjectDataSource ID="ds持有證照" runat="server" DataObjectTypeName="Education.持有證照"
    TypeName="Education.DAC_持有證照" OldValuesParameterFormatString="original_{0}"
    SelectMethod="Select" OnSelecting="ds持有證照_Selecting">
    <SelectParameters>
      <asp:Parameter Name="noInputReturnAll" Type="Boolean" DefaultValue="False" />
      <asp:Parameter Name="員工編號" Type="String" DefaultValue=""></asp:Parameter>
      <asp:Parameter Name="證照名稱" Type="String" DefaultValue=""></asp:Parameter>
      <asp:Parameter Name="證照字號" Type="String" DefaultValue=""></asp:Parameter>
      <asp:Parameter Name="發證單位" Type="String" DefaultValue=""></asp:Parameter>
      <asp:Parameter Name="核發日期" Type="DateTime" DefaultValue=""></asp:Parameter>
    </SelectParameters>
  </asp:ObjectDataSource>
  <h3>1. 我的上課紀錄</h3>
  <asp:GridView ID="gv上課紀錄" runat="server" AllowPaging="True"
    AutoGenerateColumns="False" DataSourceID="ds選課" EnableModelValidation="True"
    Width="100%">
    <Columns>
      <asp:TemplateField HeaderText="訓練日期" SortExpression="訓練日期">
        <ItemTemplate>
          <uc1:起訖日顯示 runat="server" ID="起訖日顯示" 起日='<%# Eval("訓練日期") %>'
            迄日='<%# Eval("訓練日期迄") %>' Format="yyyy-MM-dd" />
        </ItemTemplate>
        <HeaderStyle Width="13em" />
        <ItemStyle HorizontalAlign="Center" />
      </asp:TemplateField>
      <asp:BoundField DataField="訓練名稱" HeaderText="訓練名稱" SortExpression="訓練名稱"></asp:BoundField>
      <asp:TemplateField HeaderText="出席狀況" SortExpression="出席狀況">
        <ItemTemplate>
          <uc1:UC出席狀況 runat="server" ID="UC出席狀況" 學員編號='<%# Eval("學員編號") %>' 訓練課程編號='<%# Eval("訓練課程編號") %>' />
        </ItemTemplate>
        <HeaderStyle Width="17em" />
        <ItemStyle HorizontalAlign="Left" />
      </asp:TemplateField>
      <asp:TemplateField HeaderText="滿意度調查&lt;br&gt;暨心得報告">
        <ItemTemplate>
          <asp:Label ID="Label41" runat="server" Font-Bold="true" Text='<%# WebLib.DAC.GetInt32(Eval("填寫數")) > 0 ? "已填寫" : "未填寫" %>'></asp:Label>&nbsp;
          <asp:LinkButton ID="LinkButton1" runat="server" CssClass="button blue80"
            OnClientClick='<%# GetOpenWindowJS("~/Forms/辦訓狀況/滿意度調查表及心得報告.aspx", "_feedback", "course", Eval("訓練課程編號"), "student", Eval("學員編號")) %>'>填寫</asp:LinkButton>
        </ItemTemplate>
        <HeaderStyle Width="10em" />
        <ItemStyle HorizontalAlign="Center" />
      </asp:TemplateField>
    </Columns>
    <EmptyDataTemplate>
      <asp:Label ID="Label9" runat="server" CssClass="ErrorMessage" Text="您目前沒有任何上課紀錄"></asp:Label>
    </EmptyDataTemplate>
    <PagerTemplate>
      <weblib:GridViewPager ID="GridViewPager1" runat="server" />
    </PagerTemplate>
  </asp:GridView>
  <h3>2. 我的數位課程觀看紀錄</h3>
  <asp:GridView ID="gv數位課程" runat="server" AutoGenerateColumns="False"
    DataKeyNames="課程編號" DataSourceID="ds數位課程" EnableModelValidation="True"
    AllowPaging="True" Width="100%">
    <Columns>
      <asp:BoundField DataField="課程編號" HeaderText="課程編號" ReadOnly="True" SortExpression="課程編號"
        DataFormatString="{0:000000}">
        <ItemStyle HorizontalAlign="Center" />
      </asp:BoundField>
      <asp:TemplateField HeaderText="課程類別" SortExpression="">
        <ItemTemplate>
          <asp:Label ID="lb課程類別" runat="server" Text='<%# Eval("課程類別") %>'></asp:Label>
        </ItemTemplate>
        <ItemStyle HorizontalAlign="Center" />
      </asp:TemplateField>
      <asp:BoundField DataField="課程名稱" HeaderText="課程名稱" SortExpression="課程名稱" />
      <asp:BoundField DataField="講師" HeaderText="講師" SortExpression="講師">
        <ItemStyle HorizontalAlign="Center" />
      </asp:BoundField>
      <asp:TemplateField HeaderText="上次觀看日期">
        <ItemTemplate>
          <asp:Label ID="Label3" runat="server" Text='<%# DAC.GetDateTime(Eval("觀看日期")).Ticks > 0 ? Eval("觀看日期", "{0:yyyy-MM-dd}") : "尚未觀看" %>'></asp:Label>
        </ItemTemplate>
        <ItemStyle HorizontalAlign="Center" />
      </asp:TemplateField>
    </Columns>
    <EmptyDataTemplate>
      <asp:Label ID="Label1" runat="server" Text="您還沒有觀看過數位課程" CssClass="ErrorMessage"></asp:Label>
    </EmptyDataTemplate>
    <PagerTemplate>
      <weblib:GridViewPager ID="GridViewPager1" runat="server" />
    </PagerTemplate>
  </asp:GridView>
  <h3>3. 我的外部訓練</h3>
  <asp:GridView runat="server" ID="gv外部受訓紀錄" DataSourceID="ds外部受訓紀錄"
    DataKeyNames="員工編號,序號" AutoGenerateColumns="False" EnableModelValidation="True"
    Width="100%" AllowPaging="true">
    <Columns>
      <asp:TemplateField HeaderText="序號" SortExpression="序號">
        <ItemTemplate>
          <asp:Label ID="Label11" runat="server" Text='<%# Bind("序號") %>'></asp:Label>
          <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False"
            CommandName="Select" Text=""></asp:LinkButton>
        </ItemTemplate>
        <ItemStyle HorizontalAlign="Center" />
      </asp:TemplateField>
      <asp:BoundField DataField="實施單位" HeaderText="實施單位" SortExpression="實施單位"></asp:BoundField>
      <asp:TemplateField HeaderText="課程類別" SortExpression="課程類別">
        <ItemTemplate>
          <asp:Label ID="Label31" runat="server" Text='<%# Bind("課程類別") %>'></asp:Label>
          <asp:Label ID="Label32" runat="server" Text='<%# Get類別名稱("課程類別", Eval("課程類別")) %>'></asp:Label>
        </ItemTemplate>
        <ItemStyle HorizontalAlign="Center" />
      </asp:TemplateField>
      <asp:BoundField DataField="訓練名稱" HeaderText="訓練名稱" SortExpression="訓練名稱" />
      <asp:BoundField DataField="訓練年度" HeaderText="訓練年度" SortExpression="訓練年度">
        <ItemStyle HorizontalAlign="Center" />
      </asp:BoundField>
      <asp:BoundField DataField="訓練時數" HeaderText="訓練時數" SortExpression="訓練時數">
        <ItemStyle HorizontalAlign="Center" />
      </asp:BoundField>
      <asp:BoundField DataField="訓練單位" HeaderText="訓練單位" SortExpression="訓練單位"></asp:BoundField>
    </Columns>
    <EmptyDataTemplate>
      <asp:Label ID="LabelEmpty" runat="server" CssClass="ErrorMessage" Text="您目前沒有登錄證照"></asp:Label>
    </EmptyDataTemplate>
    <PagerTemplate>
      <weblib:gridviewpager id="GridViewPager1" runat="server" />
    </PagerTemplate>
  </asp:GridView>
  <h3>4. 我的證照</h3>
  <asp:GridView ID="gv持有證照" runat="server" DataKeyNames="員工編號,序號,DB_APPNO"
    DataSourceID="ds持有證照" AutoGenerateColumns="False"
    EnableModelValidation="True" AllowPaging="True" Width="100%" 
    OnRowDataBound="gv持有證照_RowDataBound">
    <Columns>
      <asp:TemplateField HeaderText="序號" SortExpression="序號">
        <ItemTemplate>
          <asp:Label ID="Label1" runat="server" Text='<%# Bind("序號") %>'></asp:Label>
          <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False"
            CommandName="Select" Text=""></asp:LinkButton>
        </ItemTemplate>
        <ItemStyle HorizontalAlign="Center" />
      </asp:TemplateField>
      <asp:BoundField DataField="證照名稱" HeaderText="證照名稱" SortExpression="證照名稱" />
      <asp:BoundField DataField="證照字號" HeaderText="證照字號" SortExpression="證照字號" />
      <asp:BoundField DataField="發證單位" HeaderText="發證單位" SortExpression="發證單位" />
      <asp:BoundField DataField="核發日期" HeaderText="核發日期" SortExpression="核發日期" DataFormatString="{0:yyyyMMdd}">
        <ItemStyle HorizontalAlign="Center" />
      </asp:BoundField>
      <asp:TemplateField HeaderText="附件">
        <ItemTemplate>
          <asp:Literal ID="lt附件" runat="server"></asp:Literal>
        </ItemTemplate>
      </asp:TemplateField>
    </Columns>
    <EmptyDataTemplate>
      <asp:Label ID="LabelEmpty" runat="server" CssClass="ErrorMessage" Text="您目前沒有登錄證照"></asp:Label>
    </EmptyDataTemplate>
    <PagerTemplate>
      <weblib:gridviewpager id="GridViewPager1" runat="server" />
    </PagerTemplate>
  </asp:GridView>
</asp:Content>