employeelist.aspx

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

<%@ Page Language="C#" MasterPageFile="~/style/MasterPage.master" AutoEventWireup="true"
    CodeFile="EmployeeList.aspx.cs" Inherits="Personal_EmployeeList" 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 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">
        <uc1:myCodeTree ID="Classes" runat="server" TableName="J_Department" NameColumn="de_Name"
            IdColumn="de_ID" ParentIdColumn="de_Parent" RootNames="'总公司'" />
    </div>
    <div style="z-index: 104; left: 206px; width: 77%; position: absolute; top: 1px"
        id="divTitle">
        <table style="width: 100%" border="0" cellpadding="0" cellspacing="0">
            <tbody>
                <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 align="right" class="titlebar" width="80">
                        <asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl="~/Personal/EmployeeIn.aspx">
                        <span style="color:white">添加新员工 </span></asp:HyperLink></td>
                </tr>
            </tbody>
        </table>
    </div>
    <div id="divMain">
        <asp:GridView ID="GridView1" DataKeyNames="pe_ID" runat="server" AllowPaging="True"
            AutoGenerateColumns="False" DataSourceID="SqlDataSource1" Width="97%" AllowSorting="True"
            CssClass="mainView" OnSelectedIndexChanged="GridView1_SelectedIndexChanged" OnRowDeleting="GridView1_RowDeleting"
            PageSize="20" OnRowDeleted="GridView1_RowDeleted">
            <Columns>
                <asp:BoundField DataField="pe_ID" HeaderText="ID" InsertVisible="False" SortExpression="pe_ID" />
                <asp:HyperLinkField DataNavigateUrlFields="pe_ID" DataNavigateUrlFormatString="EmployeeIn.aspx?ID={0}"
                    DataTextField="pe_Name" HeaderText="姓名" SortExpression="pe_Name">
                    <ItemStyle HorizontalAlign="Center" />
                    <HeaderStyle HorizontalAlign="Center" Width="10%" />
                </asp:HyperLinkField>
                <asp:BoundField DataField="pe_Address" HeaderText="地址" SortExpression="pe_Address" />
                <asp:BoundField DataField="pe_Tel" HeaderText="电话" SortExpression="pe_Tel" />
                <asp:BoundField DataField="学历" HeaderText="学历" SortExpression="pe_Education">
                    <ItemStyle HorizontalAlign="Center" />
                    <HeaderStyle HorizontalAlign="Center" Width="8%" />
                </asp:BoundField>
                <asp:BoundField DataField="性别" HeaderText="性别" SortExpression="pe_Sex">
                     <ItemStyle HorizontalAlign="Center" />
                    <HeaderStyle HorizontalAlign="Center" Width="5%" />
                </asp:BoundField>
               <asp:BoundField DataField="部门" HeaderText="部门" SortExpression="em_Department">
                     <ItemStyle HorizontalAlign="Center" />
                    <HeaderStyle HorizontalAlign="Center" Width="15%" />
                </asp:BoundField>
               <asp:BoundField DataField="职务" HeaderText="职务" SortExpression="em_Duty">
                    <ItemStyle HorizontalAlign="Center" />
                    <HeaderStyle HorizontalAlign="Center" Width="10%" />
                </asp:BoundField>
                <asp:BoundField DataField="em_LastLogin" HeaderText="最后登录时间">
                    <ItemStyle HorizontalAlign="Center" />
                    <HeaderStyle HorizontalAlign="Center" />
                </asp:BoundField>
                <asp:CommandField ShowDeleteButton="True" DeleteText="&lt;div style=&quot;display:inline&quot; id=&quot;deleteme&quot; onclick=&quot;JavaScript:return confirm('确定删除吗？')&quot;&gt;删除&lt;/div&gt;">
                    <ItemStyle HorizontalAlign="Center" />
                </asp:CommandField>
            </Columns>
        </asp:GridView>
    </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: 90px;">
                    &nbsp;<asp:HyperLink ID="hypStat" runat="server" NavigateUrl="#" ToolTip="单击在新窗口统计员工出勤率.">员工登录情况</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 ("CalcEmAttend.aspx?de_ID="+classID+"&d1="+d1.value+"&d2="+d2.value);
}
    </script>

    <div style="z-index: 103; left: -6px; width: 100px; position: absolute; top: 333px;
        height: 12px">
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:keke100ConnectionString %>"
            SelectCommand="p_ListEmployee" SelectCommandType="StoredProcedure" DeleteCommand="DELETE FROM J_Person WHERE pe_ID=@pe_ID"
            OnSelected="SqlDataSource1_Selected">
            <SelectParameters>
                <asp:Parameter Name="ClassRoot" Type="Int32" />
            </SelectParameters>
            <DeleteParameters>
                <asp:Parameter Name="pe_ID" />
            </DeleteParameters>
        </asp:SqlDataSource>
    </div>
    <asp:Literal ID="litModify" runat="server"></asp:Literal>
</asp:Content>