studentlist.aspx

asp.net 2.0的教务管理软件源码

<%@ Page Language="C#" MasterPageFile="~/style/MasterPage.master" AutoEventWireup="true"
    CodeFile="StudentList.aspx.cs" Inherits="Personal_StudentList" Title="学生信息管理 - 杰邦教学管理系统" %>

<%@ Register TagPrefix="JControls" TagName="TypeList" Src="~/uctl/StandardChoice.ascx" %>
<%@ Register TagPrefix="uc1" TagName="myCodeTree" Src="~/uctl/CodeTree.ascx" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">
    <div id="divMain1" style="z-index: 101">
        <asp:GridView ID="GridView1" runat="server" AllowSorting="True" AutoGenerateColumns="False"
            DataSourceID="SqlDataSource1" Width="97%" DataKeyNames="pe_ID"
            CssClass="mainView" OnRowDataBound="GridView1_RowDataBound" OnSelectedIndexChanged="GridView1_SelectedIndexChanged" AllowPaging="True" PageSize="50" EmptyDataText="该部门(班级)中没有您可以浏览的学生">
            <Columns>
                <asp:BoundField DataField="pe_ID" HeaderText="ID" InsertVisible="False" SortExpression="pe_ID" >
                    <ItemStyle HorizontalAlign="Right" />
                    <HeaderStyle Width="8%" />
                </asp:BoundField>
                <asp:HyperLinkField DataNavigateUrlFields="pe_ID" DataNavigateUrlFormatString="StudentIn.aspx?ID={0}"
                    DataTextField="pe_Name" HeaderText="姓名" SortExpression="pe_Name">
                    <ItemStyle HorizontalAlign="Center" />
                    <HeaderStyle HorizontalAlign="Center" Width="12%" />
                </asp:HyperLinkField>
                <asp:BoundField DataField="性别" HeaderText="性别" SortExpression="性别" >
                    <ItemStyle HorizontalAlign="Center" />
                    <HeaderStyle Width="6%" />
                </asp:BoundField>
                <asp:BoundField DataField="班级" HeaderText="班级" SortExpression="班级" >
                    <HeaderStyle Width="12%" />
                </asp:BoundField>
                <asp:BoundField DataField="pe_Address" HeaderText="地址" SortExpression="pe_Address">
                    <HeaderStyle Width="16%" />
                </asp:BoundField>
                <asp:BoundField DataField="pe_Tel" HeaderText="电话" SortExpression="pe_Tel" >
                </asp:BoundField>
                <asp:BoundField DataField="应缴学费" HeaderText="应收学费" SortExpression="应缴学费" DataFormatString="{0:N0}" HtmlEncode="False">
                    <ItemStyle HorizontalAlign="Right" />
                </asp:BoundField>
                <asp:BoundField DataField="实缴学费" HeaderText="实收学费" SortExpression="实缴学费" DataFormatString="{0:N0}" HtmlEncode="False">
                    <ItemStyle HorizontalAlign="Right" />
                </asp:BoundField>
                <asp:BoundField DataField="欠费" HeaderText="欠费" SortExpression="欠费" DataFormatString="{0:N0}" HtmlEncode="False">
                    <ItemStyle HorizontalAlign="Right" />
                </asp:BoundField>
                <asp:CommandField ShowDeleteButton="True" DeleteText="&lt;div style=&quot;display:inline&quot; id=&quot;deleteme&quot; onclick=&quot;JavaScript:return confirm('警告：该操作将删除所有与该学生有关的记录.\n确定删除吗？')&quot;&gt;删除&lt;/div&gt;" >
                    <HeaderStyle Width="6%" HorizontalAlign="Center" />
                    <ItemStyle HorizontalAlign="Center" />
                </asp:CommandField>
            </Columns>
        </asp:GridView>
    </div>
    <div style="z-index: 104; left: 206px; width: 77%; position: absolute; top: 1px;
        height: 26px" id="divTitle">
        <table width="100%">
            <tr>
                <td  class="titlebar">
                    学生信息管理：<asp:Label ID="Path" runat="server" Text="Label"></asp:Label>
                    <asp:Label ID="lblCounter" runat="server" Text="Label"></asp:Label></td>
                <td  class="titlebar" align="right">
                    <asp:HyperLink ID="hypAddNew" NavigateUrl="~/Personal/StudentIn.aspx" runat="server"><span style="color:White">添加新同学</span></asp:HyperLink>&nbsp;</td>
            </tr>
        </table>
    </div>
    <div style="z-index: 105; left: 1px; width: 200px; position: absolute; top: 1px;
        height: 24px" id="divLeftTitle">
                <table border="0" cellpadding="0" cellspacing="0" width="100%">
            <tr>
                <td class="titlebar" style="height: 24px">
                    <asp:Label ID="lblTreeName" runat="server" Text="部门/班级列表"></asp:Label></td>
            </tr></table>
    </div>
    
    <div id="divTree" style="z-index: 102">
         <uc1:myCodeTree ID="Classes" runat="server" TableName="J_Department" NameColumn="de_Name" IdColumn="de_ID" ParentIdColumn="de_Parent" RootIDs="1" />
    </div>
    <div id="divBottom">
        <table style="width: 100%" cellpadding="0" cellspacing="0">
            <tr>
                <td style="width: 100px;">
                </td>
                <td align="right" style="height: 26px">
                    从<asp:TextBox ID="txtStartDate" runat="server"  MaxLength="10" Width="80px" Height="14px" ToolTip="请输入yyyy-mm-dd格式的起始日期."></asp:TextBox>
                    ～
                    <asp:TextBox ID="txtEndDate" runat="server" MaxLength="10" Width="80px" Height="14px" ToolTip="请输入yyyy-mm-dd格式的结束日期."></asp:TextBox>
                        </td>
                <td style=" width: 100px; font-weight: bold;">
                    &nbsp;<asp:HyperLink ID="hypStatRecruit" runat="server" NavigateUrl="#" ToolTip="在新窗口统计招生学费及提成." Font-Bold="False">统计招生学费</asp:HyperLink>
                    </td>
            </tr>
        </table>
    </div>
<script language="javascript" src="../style/common.js" type="text/javascript"></script>
<script language="Javascript" type="text/javascript">
function openStatWindow(classID, txtStartDate, txtEndDate)
{
    d1 = document.getElementById(txtStartDate);
    d2 = document.getElementById(txtEndDate);
    if (!isDate(d1.value)) 
    {
        alert("非法的起始日期");
        d1.focus();
        return false;
    }
    if (!isDate(d2.value))
    {
        alert("非法的结束日期");
        d2.focus();
        return false;
    }
    w = window.open ("CalcFee.aspx?de_ID="+classID+"&d1="+d1.value+"&d2="+d2.value);
}
</script>    
    <div style="z-index: 103; left: 5px; width: 100px; position: absolute; top: 342px;
        height: 6px">
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:keke100ConnectionString %>"
            DeleteCommand="DELETE FROM J_Person WHERE pe_ID=@pe_ID" SelectCommand="p_ListStudent"
            SelectCommandType="StoredProcedure" OnSelected="SqlDataSource1_Selected">
            <DeleteParameters>
                <asp:Parameter Name="pe_ID" />
            </DeleteParameters>
            <SelectParameters>
                <asp:Parameter Name="ClassRoot" Type="Int32" />
                <asp:Parameter Name="LoginID" Type="Int32" />
            </SelectParameters>
        </asp:SqlDataSource>
    </div>
</asp:Content>