classview.aspx

校友录的总体功能分为三个子功能模块:管理功能模块,用户注册功能模块,用户个性化服务

                                    <tr>
                                        <td style="width: 288px; height: 18px">
                                            <asp:Label ID="classn" runat="server" Text="班级名称： " Width="90px" Height="6px"></asp:Label>
                                            <asp:Label ID="cname" runat="server" Text="末创建" Width="168px"></asp:Label></td>
                                        <td style="width: 300px; height: 18px">
                                            &nbsp;<asp:Label ID="Label18" runat="server" Text="创建年份："></asp:Label>
                                            <asp:Label ID="Enter" runat="server"></asp:Label></td>
                                    </tr>
                                    <tr>
                                        <td style="width: 288px">
                                            &nbsp;<asp:Label ID="Label15" runat="server" Text="班主任："></asp:Label>
                                            <asp:Label ID="Teacher" runat="server"></asp:Label></td>
                                        <td style="width: 300px">
                                            &nbsp;<asp:Label ID="Label17" runat="server" Text="班长："></asp:Label><asp:Label ID="monitor" runat="server"></asp:Label></td>
                                    </tr>
                                    <tr>
                                        <td style="width: 288px; height: 19px">
                                            &nbsp;<asp:Label ID="Label16" runat="server" Text="最新加入成员："></asp:Label>
                                            <asp:Label ID="newmem" runat="server" Width="134px"></asp:Label></td>
                                        <td style="width: 400px; height: 19px">
                                            <asp:Label ID="url" runat="server" Text="班级主页："></asp:Label>
                                            <asp:HyperLink ID="urlLink" runat="server" Width="291px">[urlLink]</asp:HyperLink></td>
                                    </tr>
                                    <tr>
                                        <td style="width: 288px; height: 19px">
                                        </td>
                                        <td style="width: 100px; height: 19px">
                                        </td>
                                    </tr>
                                </table>
                            </td>
                        </tr>
                        <tr>
                            <td style="width: 100px; height: 19px;">
                                <table border="0" cellpadding="0" cellspacing="0" style="width: 557px">
                                    <tr>
                                        <td style="width: 100px; background-color: #a9d46d">
                                            <asp:Image ID="Image11" runat="server" Height="36px" ImageUrl="~/PICTURE/birthday.gif"
                                                Width="150px" /></td>
                                    </tr>
                                    <tr>
                                        <td style="width: 100px">
                                            <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
                                                DataKeyNames="UserID" DataSourceID="SqlDataSource2" AllowPaging="True" BackColor="#A9D46D" Height="156px" PageSize="5" Width="568px" OnDataBound="GridView1_DataBound" AllowSorting="True" OnRowCommand="GridView1_RowCommand" OnRowDataBound="GridView1_RowDataBound">
                                                <Columns>
                                                    <asp:TemplateField HeaderText="姓名">
                                                        <EditItemTemplate>
                                                            <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("Name") %>'></asp:TextBox>
                                                        </EditItemTemplate>
                                                        <ItemStyle Font-Bold="True" Font-Names="华文行楷" Font-Size="X-Large" ForeColor="Purple" />
                                                        <ItemTemplate>
                                                            <asp:Label ID="Label2" runat="server" Text='<%# Bind("Name") %>'></asp:Label><br />
                                                            <asp:Label ID="Label10" runat="server" ForeColor="Blue" Text="("></asp:Label><asp:Label
                                                                ID="UserLab" runat="server" Text='<%# Eval("UserID") %>' ForeColor="Blue" Width="43px"></asp:Label><asp:Label
                                                                    ID="Label20" runat="server" ForeColor="Blue" Text=")"></asp:Label>
                                                      
                                                        </ItemTemplate>
                                                        <HeaderTemplate>
                                                            <asp:Label ID="Label24" runat="server" ForeColor="Maroon" Text="姓名"></asp:Label>&nbsp;
                                                            <br />
                                                            <asp:Label ID="Label22" runat="server" Text="（"></asp:Label><asp:Label ID="Label23"
                                                                runat="server" Text="用户名"></asp:Label><asp:Label ID="Label21" runat="server" Text="）"></asp:Label>
                                                        </HeaderTemplate>
                                                    </asp:TemplateField>
                                                    <asp:TemplateField HeaderText="距离生日天数">
                                                        <ItemTemplate>
                                                            <asp:Label ID="Label12" runat="server" Text='<%# getday(Eval("birmounth"), Eval("birday"))  %>'></asp:Label>
                                                            <asp:Label ID="sort" runat="server" Text='<%# sort(Eval("birmounth"), Eval("birday")) %>'
                                                                Visible="False"></asp:Label>
                                                        </ItemTemplate>
                                                    </asp:TemplateField>
                                                    <asp:TemplateField HeaderText="出生日期">
                                                        <ItemTemplate>
                                                            <asp:Label ID="Label13" runat="server" Text='<%# birhday(Eval("biryear"), Eval("birmounth"), Eval("birday")) %>'></asp:Label>
                                                        </ItemTemplate>
                                                    </asp:TemplateField>
                                                    <asp:TemplateField HeaderText="祝福">
                                                        <ItemTemplate>
                                                            <asp:ImageButton ID="wishbtn" runat="server" Height="37px" ImageUrl="~/PICTURE/wish.gif" CommandName="wish" />
                                                        </ItemTemplate>
                                                    </asp:TemplateField>
                                                </Columns>
                                                <PagerSettings Mode="NextPreviousFirstLast" Position="TopAndBottom" FirstPageText="[首页]" LastPageText="[末页]" NextPageText="[下一页]" PreviousPageText="[上一页]" />
                                                <FooterStyle BackColor="#A9D46D" />
                                                <RowStyle BackColor="#E3F1D1" />
                                                <HeaderStyle BackColor="LightCyan" Font-Bold="True" Font-Names="华文行楷" Font-Size="Large"
                                                    ForeColor="Blue" />
                                                <AlternatingRowStyle BackColor="#F4FAED" />
                                            </asp:GridView>
                                        </td>
                                    </tr>
                                </table>
                            </td>
                        </tr>
                        <tr>
                            <td style="width: 100px; height: 19px">
                                <asp:Image ID="Image10" runat="server" Height="37px" ImageUrl="~/PICTURE/paihang.gif"
                                    Width="626px" /></td>
                        </tr>
                        <tr>
                            <td style="width: 100px; text-align: left">
                                &nbsp;</td>
                        </tr>
                        <tr>
                            <td style="width: 100px">
                            </td>
                        </tr>
                    </table>
                </td>
            </tr>
            <tr>
                <td style="width: 511px;">
                </td>
            </tr>
            <tr>
                <td style="width: 511px; height: 19px">
                </td>
            </tr>
            <tr>
                <td style="width: 511px; height: 19px">
                </td>
            </tr>
            <tr>
                <td style="width: 511px;">
                </td>
            </tr>
            <tr>
                <td style="width: 894px; height: 19px">
                </td>
                <td style="width: 100px; height: 19px">
                </td>
            </tr>
        </table>
    
    </div>
        <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:ChinaRenConnectionString %>"
            SelectCommand="SELECT UserInfo.UserID, StudentInfo.Name, UserInfo.biryear, UserInfo.birmounth, UserInfo.birday FROM StudentInfo INNER JOIN UserInfo ON StudentInfo.StudentID = UserInfo.StudentID WHERE (UserInfo.UserID IN (SELECT UserID FROM UserToClass WHERE (ClassName = @ClassName)))">
            <SelectParameters>
                <asp:SessionParameter DefaultValue="0" Name="ClassName" SessionField="classname" />
            </SelectParameters>
        </asp:SqlDataSource>
        &nbsp;
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ChinaRenConnectionString %>"
            SelectCommand="SELECT UserInfo.UserID, StudentInfo.Name, UserInfo.biryear, UserInfo.birmounth, UserInfo.birday FROM StudentInfo INNER JOIN UserInfo ON StudentInfo.StudentID = UserInfo.StudentID ">
        </asp:SqlDataSource>
  
  
    </form>
</body>
</html>