<%@ Page Language="C#" AutoEventWireup="true" CodeFile="ykkc.aspx.cs" Inherits="_Default" %>

<!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>
    <style type="text/css">
        #form1
        {
            text-align: center;
        }
    </style>
</head>
<body>
    <form id="form1" runat="server">
    <br />
    <br />
    <asp:Label ID="Label1" runat="server" Font-Size="X-Large" Text="硕士研究生招生考试考场查询"></asp:Label>
    <br />
    <br />
    <br />
    <div>
    
        <asp:Label ID="Label2" runat="server" Font-Size="Large" Text="考生编号："></asp:Label>
        <asp:TextBox ID="ksbh" runat="server" Font-Size="Large" MaxLength="15" 
            Width="230px"></asp:TextBox>
        <br />
        <br />
        <br />
        <asp:Label ID="Label3" runat="server" Font-Size="Large" Text="证件号码："></asp:Label>
        <asp:TextBox ID="zjhm" runat="server" Font-Size="Large" MaxLength="18" 
            Width="230px"></asp:TextBox>
        <br />
        <br />
        <br />
        <asp:Button ID="Button1" runat="server" Font-Size="Large" Height="39px" 
            onclick="Button1_Click" Text="查询考场" Width="278px" />
        <br />
        <br />
        <br />
    
    </div>
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
        DataSourceID="ykkw"  style="margin: 0px auto;" CellPadding="4" 
        ForeColor="#333333" GridLines="None">
        <AlternatingRowStyle BackColor="White" />
        <Columns>
            <asp:BoundField DataField="ksbh" HeaderText="考生编号" ReadOnly="True" 
                SortExpression="ksbh" />
            <asp:BoundField DataField="xm" HeaderText="姓名" ReadOnly="True" 
                SortExpression="xm" />
            <asp:BoundField DataField="kssj" HeaderText="考试时间" ReadOnly="True" 
                SortExpression="kssj" />
            <asp:BoundField DataField="kmdm" HeaderText="科目代码" ReadOnly="True" 
                SortExpression="kmdm" />
            <asp:BoundField DataField="kmmc" HeaderText="科目名称" ReadOnly="True" 
                SortExpression="kmmc" />
            <asp:BoundField DataField="kdmc" HeaderText="考点名称" ReadOnly="True" 
                SortExpression="kdmc" />
            <asp:BoundField DataField="kcwz" HeaderText="考场位置" ReadOnly="True" 
                SortExpression="kcwz" />
            <asp:BoundField DataField="kch" HeaderText="考场号" ReadOnly="True" 
                SortExpression="kch" />
            <asp:BoundField DataField="zwh" HeaderText="座位号" ReadOnly="True" 
                SortExpression="zwh" />
        </Columns>
        <EditRowStyle BackColor="#2461BF" />
        <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
        <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
        <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
        <RowStyle BackColor="#EFF3FB" />
        <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
        <SortedAscendingCellStyle BackColor="#F5F7FB" />
        <SortedAscendingHeaderStyle BackColor="#6D95E1" />
        <SortedDescendingCellStyle BackColor="#E9EBEF" />
        <SortedDescendingHeaderStyle BackColor="#4870BE" />
    </asp:GridView>
    <asp:SqlDataSource ID="ykkw" runat="server" 
        ConnectionString="<%$ ConnectionStrings:ykkwConnectionString %>" 
        
        
        SelectCommand="select ksbh,xm,'第1天上午' as kssj,zzllm as kmdm,zzllmc as kmmc,kdmc,(select ldmc+lc from t_kdkc where t_kdkc.kddm=t_ksxx.kddm and t_kdkc.bh=t_ksxx.bh) as kcwz,kch,zwh from t_ksxx,t_kddm where t_ksxx.kccx='1' and t_ksxx.kddm=t_kddm.kddm and t_ksxx.ksbh='999'
union
select ksbh,xm,'第1天下午' as kssj,wgym as kmdm,wgymc as kmmc,kdmc,(select ldmc+lc from t_kdkc where t_kdkc.kddm=t_ksxx.kddm and t_kdkc.bh=t_ksxx.bh) as kcwz,kch,zwh from t_ksxx,t_kddm where t_ksxx.kccx='1' and t_ksxx.kddm=t_kddm.kddm and t_ksxx.ksbh='999'
union
select ksbh,xm,'第2天上午' as kssj,ywk1m as kmdm,ywk1mc as kmmc,kdmc,(select ldmc+lc from t_kdkc where t_kdkc.kddm=t_ksxx.kddm and t_kdkc.bh=t_ksxx.bh) as kcwz,kch,zwh from t_ksxx,t_kddm where t_ksxx.kccx='1' and t_ksxx.kddm=t_kddm.kddm and t_ksxx.ksbh='999'
union
select ksbh,xm,'第2天下午' as kssj,ywk2m as kmdm,ywk2mc as kmmc,kdmc,(select ldmc+lc from t_kdkc where t_kdkc.kddm=t_ksxx.kddm and t_kdkc.bh=t_ksxx.bh) as kcwz,kch,zwh from t_ksxx,t_kddm where t_ksxx.kccx='1' and t_ksxx.kddm=t_kddm.kddm and t_ksxx.ksbh='999'
union
select ksbh,xm,'第3天上午' as kssj,ywk3m as kmdm,ywk3mc as kmmc,kdmc,(select ldmc+lc from t_kdkc where t_kdkc.kddm=t_km5.kddm and t_kdkc.bh=t_km5.bh) as kcwz,kch,zwh from t_km5,t_kddm where t_km5.kddm=t_kddm.kddm and t_km5.ksbh='99992'">
    </asp:SqlDataSource>
    <p>
        &nbsp;</p>
    <p>
        &nbsp;</p>
    <asp:Label ID="Label4" runat="server" Text="技术支持：晨辉软件制作室 www.chenhuisoft.cn"></asp:Label>
    </form>
</body>
</html>
