?<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="StudentMain.aspx.cs" Inherits="Student_Student" Title="學生首頁" %>
<asp:Content ID="Content1" ContentPlaceHolderID="cphMain" Runat="Server">
    <table style="width: 272px; height: 43px">
        <tr>
            <td align="center" style="width: 390px; color: #ffffff; height: 21px; background-color: navy">
                必修課程</td>
        </tr>
        <tr>
            <td align="left" style="width: 390px; height: 127px" valign="top">
                <asp:DataGrid ID="DataGrid1" runat="server" AutoGenerateColumns="False" CellPadding="4"
                    DataSourceID="sdsBiXiu" Font-Size="Small" ForeColor="#333333" GridLines="None"
                    Height="27px"  Width="655px" OnDeleteCommand="SelectClass" AllowPaging="True">
                    <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                    <EditItemStyle BackColor="#2461BF" />
                    <SelectedItemStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
                    <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" Visible="False" />
                    <AlternatingItemStyle BackColor="White" />
                    <ItemStyle BackColor="#EFF3FB" />
                    <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                    <Columns>
                        <asp:BoundColumn DataField="class_id" HeaderText="課程編號"></asp:BoundColumn>
                        <asp:HyperLinkColumn DataNavigateUrlField="class_id" DataNavigateUrlFormatString="~/SeeClassTable.aspx?id={0}"
                            DataTextField="class_name" HeaderText="課程名稱" Target="_blank"></asp:HyperLinkColumn>
                        <asp:BoundColumn DataField="class_kind" HeaderText="必修"></asp:BoundColumn>
                        <asp:BoundColumn DataField="class_credit" HeaderText="學分"></asp:BoundColumn>
                        <asp:BoundColumn DataField="class_hour" DataFormatString="{0:yyyy-MM-dd}" HeaderText="開課時間">
                        </asp:BoundColumn>
                        <asp:BoundColumn DataField="class_long" HeaderText="課時"></asp:BoundColumn>
                        <asp:HyperLinkColumn DataNavigateUrlField="class_teach_id" DataNavigateUrlFormatString="~/TeacherInfo.aspx?teacher_id={0}"
                            DataTextField="class_teach_id" HeaderText="教師編號" Target="_blank"></asp:HyperLinkColumn>
                        <asp:BoundColumn DataField="class_people" HeaderText="已選人數"></asp:BoundColumn>
                        <asp:BoundColumn DataField="class_big" HeaderText="可選人數"></asp:BoundColumn>
                        <asp:ButtonColumn CommandName="Delete" HeaderText="選課" Text="選課"></asp:ButtonColumn>
                    </Columns>
                </asp:DataGrid></td>
        </tr>
        <tr>
            <td align="center" style="width: 390px; color: #ffffff; height: 21px; background-color: navy">
                選修課程</td>
        </tr>
        <tr>
            <td align="left" style="width: 390px" valign="top">
                <asp:DataGrid ID="DataGrid2" runat="server" AutoGenerateColumns="False" CellPadding="4"
                    DataSourceID="sdsXuanXiu" Font-Size="Small" ForeColor="#333333" GridLines="None"
                    Height="91px" Width="653px" OnDeleteCommand="SelectClass_XX" AllowPaging="True">
                    <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                    <EditItemStyle BackColor="#2461BF" />
                    <SelectedItemStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
                    <PagerStyle BackColor="#FFFFFF" ForeColor="MediumBlue" HorizontalAlign="Center" Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False" Font-Underline="False" />
                    <AlternatingItemStyle BackColor="White" />
                    <ItemStyle BackColor="#EFF3FB" />
                    <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                    <Columns>
                        <asp:BoundColumn DataField="class_id" HeaderText="課程編號"></asp:BoundColumn>
                        <asp:HyperLinkColumn DataNavigateUrlField="class_id" DataNavigateUrlFormatString="~/SeeClassTable.aspx?id={0}"
                            DataTextField="class_name" HeaderText="課程名稱" Target="_blank"></asp:HyperLinkColumn>
                        <asp:BoundColumn DataField="class_kind" HeaderText="必修"></asp:BoundColumn>
                        <asp:BoundColumn DataField="class_credit" HeaderText="學分"></asp:BoundColumn>
                        <asp:BoundColumn DataField="class_hour" DataFormatString="{0:yyyy-MM-dd}" HeaderText="開課時間">
                        </asp:BoundColumn>
                        <asp:BoundColumn DataField="class_long" HeaderText="課時"></asp:BoundColumn>
                        <asp:HyperLinkColumn DataNavigateUrlField="class_teach_id" DataNavigateUrlFormatString="~/TeacherInfo.aspx?teacher_id={0}"
                            DataTextField="class_teach_id" HeaderText="教師編號" Target="_blank"></asp:HyperLinkColumn>
                        <asp:BoundColumn DataField="class_people" HeaderText="已選人數"></asp:BoundColumn>
                        <asp:BoundColumn DataField="class_big" HeaderText="可選人數"></asp:BoundColumn>
                        <asp:ButtonColumn CommandName="Delete" HeaderText="選課" Text="選課"></asp:ButtonColumn>
                    </Columns>
                </asp:DataGrid></td>
        </tr>
        <tr>
            <td style="width: 390px; height: 21px">
            </td>
        </tr>
    </table>
    <asp:SqlDataSource ID="sdsBiXiu" runat="server" ConnectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\SC.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
        ProviderName="System.Data.SqlClient" SelectCommand="SELECT [class_id], [class_name], [class_kind], [class_credit], [class_hour], [class_long], [class_teach_id], [class_people], [class_big] FROM [class_tb] WHERE (([class_teach_id] IS NOT NULL) AND ([class_dep_id] = @class_dep_id) AND ([class_kind] = @class_kind))">
        <SelectParameters>
            <asp:SessionParameter Name="class_dep_id" SessionField="dept_id" Type="Int64" />
            <asp:Parameter DefaultValue="必修" Name="class_kind" Type="String" />
        </SelectParameters>
    </asp:SqlDataSource>
    <asp:SqlDataSource ID="sdsXuanXiu" runat="server" ConnectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\SC.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
        ProviderName="System.Data.SqlClient" SelectCommand="SELECT [class_id], [class_name], [class_credit], [class_kind], [class_hour], [class_long], [class_teach_id], [class_people], [class_big] FROM [class_tb] WHERE (([class_teach_id] IS NOT NULL) AND ([class_kind] = @class_kind))">
        <SelectParameters>
            <asp:Parameter DefaultValue="選修" Name="class_kind" Type="String" />
        </SelectParameters>
    </asp:SqlDataSource>
</asp:Content>