friend.aspx

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

                                </HeaderTemplate>
                                <ItemStyle BorderColor="#C0FFFF" Font-Bold="True" ForeColor="Teal" Width="150px" />
                                <ItemTemplate>
                                    <asp:Label ID="Moble1" runat="server" Text='<%# IsNull(Eval("MobilePh").ToString()) %>'></asp:Label>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="Email" SortExpression="Email">
                                <EditItemTemplate>
                                    &nbsp;<asp:LinkButton ID="EMailLink2" runat="server" CommandName="Edit" Height="25px"
                                        Text='<%# IsNull(Eval("Email").ToString()) %>' Width="190px"></asp:LinkButton>
                                </EditItemTemplate>
                                <ItemTemplate>
                                    &nbsp;
                                    <asp:LinkButton ID="EMailLink" runat="server" CommandName="GetEmail" Height="25px"
                                        Text='<%# IsNull(Eval("Email").ToString()) %>' Width="196px"></asp:LinkButton>
                                </ItemTemplate>
                                <ItemStyle BorderColor="#C0FFFF" Font-Bold="True" ForeColor="Teal" Height="40px"
                                    Width="160px" />
                                <HeaderTemplate>
                                    <asp:Image ID="Image7" runat="server" Height="22px" ImageUrl="~/PICTURE/email1.gif" />
                                    <asp:Label ID="Label3" runat="server" Text="Email"></asp:Label>
                                </HeaderTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="QQ" SortExpression="QQ">
                                <EditItemTemplate>
                                    &nbsp;<asp:Label ID="QQ2" runat="server" Text='<%# IsNull(Eval("QQ").ToString()) %>'></asp:Label>
                                </EditItemTemplate>
                                <HeaderTemplate>
                                    <asp:Image ID="Image5" runat="server" Height="25px" ImageUrl="~/PICTURE/QQ.gif" Width="24px" /><asp:Label
                                        ID="Label2" runat="server" Text="QQ"></asp:Label>
                                </HeaderTemplate>
                                <ItemStyle BorderColor="#C0FFFF" Font-Bold="True" ForeColor="Teal" />
                                <ItemTemplate>
                                    <asp:Label ID="QQ1" runat="server" Text='<%# IsNull(Eval("QQ").ToString()) %>'></asp:Label>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="头像" SortExpression="PicName">
                                <EditItemTemplate>
                                    &nbsp;<asp:ImageButton ID="head2" runat="server" Height="40px" ImageUrl='<%# Eval("PicName") %>'
                                        Width="40px" />
                                </EditItemTemplate>
                                <ItemTemplate>
                                    <asp:ImageButton ID="head1" runat="server" Height="40px" ImageUrl='<%# Eval("PicName") %>'
                                        Width="40px" />
                                </ItemTemplate>
                                <ItemStyle BorderColor="#C0FFFF" Height="30px" Width="100px" />
                                <HeaderTemplate>
                                    <table border="0" cellpadding="0" cellspacing="0" style="width: 62px; height: 32px">
                                        <tr>
                                            <td style="vertical-align: middle; width: 60px; text-align: left">
                                                <asp:Image ID="Image9" runat="server" Height="34px" ImageUrl="~/PICTURE/Pichead.gif" /></td>
                                            <td style="vertical-align: bottom; width: 60px; text-align: left">
                                                <asp:Label ID="Label5" runat="server" Height="24px" Text="头像" Width="44px"></asp:Label></td>
                                        </tr>
                                    </table>
                                </HeaderTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="留言">
                                <EditItemTemplate>
                                    &nbsp;<asp:ImageButton ID="ImageButton2" runat="server" Height="30px" ImageUrl="~/PICTURE/message.gif"
                                        Width="30px" />
                                </EditItemTemplate>
                                <ItemTemplate>
                                    <asp:ImageButton ID="MsgBtn" runat="server" CommandName="SendMsg" Height="30px" ImageUrl="~/PICTURE/message.gif"
                                        Width="30px" />
                                </ItemTemplate>
                                <ItemStyle BorderColor="#C0FFFF" Width="100px" />
                                <HeaderTemplate>
                                    <asp:Image ID="Image10" runat="server" Height="28px" ImageUrl="~/PICTURE/Msg.gif"
                                        Width="26px" /><asp:Label ID="Label6" runat="server" Text="留言"></asp:Label>
                                </HeaderTemplate>
                            </asp:TemplateField>
                        </Columns>
                        <HeaderStyle BackColor="#BCDDFF" Font-Bold="True" ForeColor="Blue" />
                        <FooterStyle BackColor="#C5E6F5" />
                        <PagerSettings FirstPageText="[首页］" LastPageText="［末页］" Mode="NextPreviousFirstLast"
                            NextPageText="［下一页］" Position="TopAndBottom" PreviousPageText="［上一页］" />
                        <RowStyle BorderColor="#C0C0FF" />
                    </asp:GridView>
                    &nbsp;</td>
                <td style="width: 100px">
                </td>
            </tr>
            <tr>
                <td style="width: 85px; height: 44px;">
                </td>
                <td style="width: 342px; text-align: left; height: 44px;">
                    <table border="0" cellpadding="0" cellspacing="0" style="width: 898px; height: 1px">
                        <tr>
                            <td style="width: 32px; height: 25px">
                                <asp:CheckBox ID="cbox" runat="server" Text="全选" Width="64px" AutoPostBack="True" OnCheckedChanged="CheckBox3_CheckedChanged" /></td>
                            <td style="width: 272px; height: 25px">
                                <asp:Label ID="Label10" runat="server" Text="选择操作："></asp:Label><asp:DropDownList
                                    ID="addlist" runat="server" AutoPostBack="True" OnSelectedIndexChanged="addlist_SelectedIndexChanged">
                                </asp:DropDownList></td>
                            <td style="width: 400px; height: 25px">
                                <asp:Label ID="Label11" runat="server" Text="类型：" Width="58px"></asp:Label><asp:TextBox
                                    ID="typename" runat="server"></asp:TextBox>
                                <asp:Button ID="additem" runat="server" Text=" 添加 " OnClick="additem_Click" /></td>
                            <td style="width: 400px; height: 25px">
                                <asp:Label ID="Label12" runat="server" Text="选择操作："></asp:Label>
                                <asp:Button ID="delitem" runat="server" OnClick="delitem_Click" Text="删除选定项" /></td>
                        </tr>
                    </table>
                    <table border="0" cellpadding="0" cellspacing="0" style="width: 898px; height: 1px">
                        <tr>
                            <td style="width: 65px; height: 25px">
                            </td>
                            <td style="width: 213px; height: 25px">
                                &nbsp;</td>
                            <td style="width: 400px; height: 25px">
                                &nbsp;</td>
                        </tr>
                    </table>
                </td>
                <td style="width: 100px; height: 44px;">
                </td>
            </tr>
            <tr>
                <td style="width: 85px; height: 15px;">
                </td>
                <td style="width: 342px; height: 15px;">
                    &nbsp;</td>
                <td style="width: 100px; height: 15px;">
                </td>
            </tr>
        </table>
    
    </div>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ChinaRenConnectionString %>"
            OnSelected="SqlDataSource1_Selected" SelectCommand="SELECT UserInfo.UserID, UserInfo.Email, UserInfo.Tele, UserInfo.MobilePh, UserInfo.PicName, UserInfo.QQ, UserInfo.StudentID, StudentInfo.Name FROM UserInfo INNER JOIN StudentInfo ON UserInfo.StudentID = StudentInfo.StudentID WHERE (UserInfo.UserID IN (SELECT friend FROM friend WHERE (type = '好type友')))">
        </asp:SqlDataSource>
    </form>
</body>
</html>