meetingfind.aspx

会议室管理系统,本系统是我大学毕业时候的毕业设计,一次通过的!

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="meetingfind.aspx.cs" Inherits="meetingfind" Title="会议检索－会议室预定系统" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <table border="0" style="width: 633px">
        <tr>
            <td align="center" style="font-weight: bold; font-size: 15px; color: white; background-color: #a43737">
                会 议 检 索</td>
        </tr>
        <tr>
            <td align="left">
                <asp:Panel ID="Panel1" runat="server" Height="50px" Visible="False" Width="125px">
                    <table border="0" style="width: 633px">
                        <tr>
                            <td align="left">
                                <asp:GridView ID="gvmyjionmeeting" runat="server" AutoGenerateColumns="False" BackColor="LightGoldenrodYellow"
                                    BorderColor="Tan" BorderWidth="1px" CaptionAlign="Top" CellPadding="2" ForeColor="Black"
                                    GridLines="None" OnRowCreated="gvmyjionmeeting_RowCreated" Style="text-align: center"
                                    Width="623px">
                                    <PagerSettings NextPageText="下一页" PreviousPageText="上一页" />
                                    <FooterStyle BackColor="Tan" />
                                    <Columns>
                                        <asp:BoundField DataField="id" HeaderText="编号" ReadOnly="True" Visible="False">
                                            <ItemStyle Width="55px" />
                                            <HeaderStyle Width="30px" />
                                        </asp:BoundField>
                                        <asp:BoundField DataField="name" HeaderText="会议名称" />
                                        <asp:BoundField DataField="builder" HeaderText="创建人" />
                                        <asp:BoundField DataField="addr" HeaderText="开会地点" />
                                        <asp:BoundField DataField="begintime" HeaderText="开始时间" />
                                        <asp:BoundField DataField="endtime" HeaderText="结束时间" />
                                        <asp:BoundField DataField="attr" HeaderText="会议状态" />
                                        <asp:BoundField DataField="datetime" HeaderText="提交时间" />
                                        <asp:TemplateField>
                                            <HeaderTemplate>
                                                查看
                                            </HeaderTemplate>
                                            <ItemStyle Width="30px" />
                                            <ItemTemplate>
                                                <a href='Message.aspx?id=<%#DataBinder.Eval(Container.DataItem,"id")%>'>查看</a>
                                            </ItemTemplate>
                                        </asp:TemplateField>
                                    </Columns>
                                    <SelectedRowStyle BackColor="DarkSlateBlue" ForeColor="GhostWhite" />
                                    <PagerStyle BackColor="PaleGoldenrod" ForeColor="DarkSlateBlue" HorizontalAlign="Center" />
                                    <HeaderStyle BackColor="Tan" Font-Bold="True" />
                                    <AlternatingRowStyle BackColor="PaleGoldenrod" />
                                </asp:GridView>
                            </td>
                        </tr>
                        <tr>
                            <td align="center" style="height: 18px">
                                每页显示<font color="red">12</font>条 共有<asp:Label ID="lblRecordCount" runat="server"
                                    Font-Bold="True" ForeColor="Red"></asp:Label>条 当前是第<asp:Label ID="Labelye" runat="server"
                                        Font-Bold="True" ForeColor="Red" Text="1"></asp:Label>/<asp:Label ID="lblPageCount"
                                            runat="server" Font-Bold="True" ForeColor="Red"></asp:Label>页 &nbsp;<asp:Button ID="Button1"
                                                runat="server" Height="19px" OnClick="Button1_Click" Text="首 页" />
                                &nbsp;
                                <asp:Button ID="Button2" runat="server" Height="19px" OnClick="Button2_Click" Text="上 页" />
                                &nbsp;&nbsp;<asp:Button ID="Button3" runat="server" Height="19px" OnClick="Button3_Click"
                                    Text="下 页" />
                                &nbsp;&nbsp;<asp:Button ID="Button4" runat="server" Height="19px" OnClick="Button4_Click"
                                    Text="末 页" /></td>
                        </tr>
                    </table>
                </asp:Panel>
                <asp:Label ID="Labmessage" runat="server" Style="font-weight: bold; color: red"></asp:Label></td>
        </tr>
        <tr>
            <td align="left" style="text-align: center">
                <table border="0" style="width: 633px">
                    <tr>
                        <td align="right" style="width: 288px; height: 30px;">
                            会议名称：</td>
                        <td align="left" style="height: 30px">
                            <asp:TextBox ID="txtname" runat="server" Width="150px"></asp:TextBox><asp:RequiredFieldValidator
                                ID="RequiredFieldValidator1" runat="server" ControlToValidate="txtname" ErrorMessage="RequiredFieldValidator">不能为空</asp:RequiredFieldValidator></td>
                    </tr>
                    <tr style="color: #000000">
                        <td align="right" style="width: 288px; height: 31px;">
                            会议地点：</td>
                        <td align="left" style="height: 31px">
                            <asp:DropDownList ID="ddlroompos" runat="server" DataSourceID="SqlDataSource1" DataTextField="roomname"
                                DataValueField="roomname">
                            </asp:DropDownList><br />
                            <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=D:\Meeting\db\meeting_Data.MDF;Integrated Security=True;Connect Timeout=30;User Instance=True"
                                ProviderName="System.Data.SqlClient" SelectCommand="SELECT [roomname] FROM [room]">
                            </asp:SqlDataSource>
                        </td>
                    </tr>
                    <tr>
                        <td align="right" style="width: 288px; height: 23px">
                            创 建 人：</td>
                        <td align="left" style="height: 23px">
                            <asp:DropDownList ID="txtbuilder" runat="server" BackColor="#FFC0FF" DataSourceID="SqlDataSource2"
                                DataTextField="builder" DataValueField="builder">
                            </asp:DropDownList><asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=D:\Meeting\db\meeting_Data.MDF;Integrated Security=True;Connect Timeout=30;User Instance=True"
                                ProviderName="System.Data.SqlClient" SelectCommand="SELECT [builder] FROM [meeting]">
                            </asp:SqlDataSource>
                        </td>
                    </tr>
                    <tr>
                        <td align="right" style="width: 288px; height: 31px;">
                            会议状态：</td>
                        <td align="left" style="height: 31px">
                            <asp:DropDownList ID="ddlattr" runat="server">
                                <asp:ListItem>待审批</asp:ListItem>
                                <asp:ListItem>已审批</asp:ListItem>
                                <asp:ListItem>已完成</asp:ListItem>
                            </asp:DropDownList></td>
                    </tr>
                    <tr>
                        <td align="center" colspan="2" style="height: 22px">
                            <asp:Button ID="Button5" runat="server" Height="20px" OnClick="Button5_Click" Text="检索会议"
                                Width="62px" />
                            &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;
                            <asp:Button ID="Button6" runat="server" CausesValidation="False" Height="20px" Text="返 回"
                                Width="48px" OnClick="Button6_Click" /></td>
                    </tr>
                </table>
            </td>
        </tr>
    </table>
</asp:Content>