修改Depts.aspx
<
asp:Panel
ID
="Panel1"
runat
="server"
GroupingText
="部门列表"
>
< br />
< asp:GridView ID ="GridView1" runat ="server" DataSourceID ="odsDepts" DataKeyNames ="ID"
AutoGenerateColumns ="False" Width ="100%" AllowPaging ="true" PageSize ="10" >
< Columns >
< asp:TemplateField >
< ItemTemplate >
< asp:Button ID ="btnEdit" runat ="server" CommandName ="Edit" Text ="编辑" />
< asp:Button ID ="btnDelete" runat ="server" CommandName ="Delete" Text ="删除" OnClientClick ="return confirm('您真的要删除吗?')" />
</ ItemTemplate >
< EditItemTemplate >
< asp:Button ID ="btnUpdate" runat ="server" CommandName ="Update" Text ="更新" />
< asp:Button ID ="btnCancel" runat ="server" CommandName ="Cancel" Text ="取消" />
</ EditItemTemplate >
</ asp:TemplateField >
< asp:BoundField HeaderText ="部门代码" DataField ="Code" />
< asp:BoundField HeaderText ="部门名称" DataField ="Name" />
</ Columns >
</ asp:GridView >
</ asp:Panel >
< hr />
< asp:Panel ID ="Panel2" runat ="server" GroupingText ="新增部门" >
< br />
< asp:FormView ID ="FormView1" runat ="server" DataSourceID ="odsDepts" DefaultMode ="Insert" >
< InsertItemTemplate >
< table width ="100%" border ="0" cellpadding ="2" cellspacing ="2" >
< tr >
< td >
部门代码 </ td >
< td >
< asp:TextBox ID ="txtCode" runat ="server" Width ="200" Text ='<%# Bind("Code") % > ' />
</ td >
</ tr >
< tr >
< td >
部门名称 </ td >
< td >
< asp:TextBox ID ="txtGroupName" runat ="server" Width ="200" Text ='<%# Bind("Name") % > ' />
</ td >
</ tr >
</ table >
< p >
< asp:Button ID ="btnInsert" runat ="server" CommandName ="Insert" Text ="新增" />
</ p >
</ InsertItemTemplate >
</ asp:FormView >
</ asp:Panel >
< asp:ObjectDataSource ID ="odsDepts" runat ="server" TypeName ="Guushuuse.SalaryPrj.HR.Helper.HRHelper"
SelectMethod ="GetAllDepts" InsertMethod ="CreateDept" UpdateMethod ="UpdateDept"
DeleteMethod ="DeleteDept" ></ asp:ObjectDataSource >
修改Employees.aspx
< br />
< asp:GridView ID ="GridView1" runat ="server" DataSourceID ="odsDepts" DataKeyNames ="ID"
AutoGenerateColumns ="False" Width ="100%" AllowPaging ="true" PageSize ="10" >
< Columns >
< asp:TemplateField >
< ItemTemplate >
< asp:Button ID ="btnEdit" runat ="server" CommandName ="Edit" Text ="编辑" />
< asp:Button ID ="btnDelete" runat ="server" CommandName ="Delete" Text ="删除" OnClientClick ="return confirm('您真的要删除吗?')" />
</ ItemTemplate >
< EditItemTemplate >
< asp:Button ID ="btnUpdate" runat ="server" CommandName ="Update" Text ="更新" />
< asp:Button ID ="btnCancel" runat ="server" CommandName ="Cancel" Text ="取消" />
</ EditItemTemplate >
</ asp:TemplateField >
< asp:BoundField HeaderText ="部门代码" DataField ="Code" />
< asp:BoundField HeaderText ="部门名称" DataField ="Name" />
</ Columns >
</ asp:GridView >
</ asp:Panel >
< hr />
< asp:Panel ID ="Panel2" runat ="server" GroupingText ="新增部门" >
< br />
< asp:FormView ID ="FormView1" runat ="server" DataSourceID ="odsDepts" DefaultMode ="Insert" >
< InsertItemTemplate >
< table width ="100%" border ="0" cellpadding ="2" cellspacing ="2" >
< tr >
< td >
部门代码 </ td >
< td >
< asp:TextBox ID ="txtCode" runat ="server" Width ="200" Text ='<%# Bind("Code") % > ' />
</ td >
</ tr >
< tr >
< td >
部门名称 </ td >
< td >
< asp:TextBox ID ="txtGroupName" runat ="server" Width ="200" Text ='<%# Bind("Name") % > ' />
</ td >
</ tr >
</ table >
< p >
< asp:Button ID ="btnInsert" runat ="server" CommandName ="Insert" Text ="新增" />
</ p >
</ InsertItemTemplate >
</ asp:FormView >
</ asp:Panel >
< asp:ObjectDataSource ID ="odsDepts" runat ="server" TypeName ="Guushuuse.SalaryPrj.HR.Helper.HRHelper"
SelectMethod ="GetAllDepts" InsertMethod ="CreateDept" UpdateMethod ="UpdateDept"
DeleteMethod ="DeleteDept" ></ asp:ObjectDataSource >
<%
@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true"
CodeFile="Employees.aspx.cs" Inherits="Employees" %>
< asp:Content ID ="LeftColumnContent" ContentPlaceHolderID ="LeftColumnZone" runat ="server" >
</ asp:Content >
< asp:Content ID ="MiddleColumnContent" ContentPlaceHolderID ="MiddleColumnZone" runat ="server" >
< asp:Panel ID ="Panel1" runat ="server" GroupingText ="员工列表" >
< br />
< asp:GridView ID ="GridView1" runat ="server" DataSourceID ="odsEmployees" DataKeyNames ="ID"
AutoGenerateColumns ="False" Width ="100%" AllowPaging ="true" PageSize ="10" >
< Columns >
< asp:TemplateField >
< ItemTemplate >
< asp:Button ID ="btnEdit" runat ="server" CommandName ="Edit" Text ="编辑" />
< asp:Button ID ="btnDelete" runat ="server" CommandName ="Delete" Text ="删除" OnClientClick ="return confirm('您真的要删除吗?')" />
</ ItemTemplate >
< EditItemTemplate >
< asp:Button ID ="btnUpdate" runat ="server" CommandName ="Update" Text ="更新" />
< asp:Button ID ="btnCancel" runat ="server" CommandName ="Cancel" Text ="取消" />
</ EditItemTemplate >
</ asp:TemplateField >
< asp:BoundField HeaderText ="工号" DataField ="Code" />
< asp:BoundField HeaderText ="姓名" DataField ="Name" />
< asp:TemplateField HeaderText ="部门" >
< ItemTemplate >
< asp:Label ID ="lblDeptName" runat ="server" Text ='<%# Eval("DeptName") % > ' />
</ ItemTemplate >
< EditItemTemplate >
< asp:DropDownList ID ="lstDepts" runat ="server" DataTextField ="Name" DataValueField ="ID"
DataSourceID ="odsDepts" SelectedValue ='<%# Bind("DeptID") % > '>
</ asp:DropDownList >
</ EditItemTemplate >
</ asp:TemplateField >
</ Columns >
</ asp:GridView >
</ asp:Panel >
< hr />
< asp:Panel ID ="Panel2" runat ="server" GroupingText ="新增员工" >
< br />
< asp:FormView ID ="FormView1" runat ="server" DataSourceID ="odsEmployees" DefaultMode ="Insert" >
< InsertItemTemplate >
< table width ="100%" border ="0" cellpadding ="2" cellspacing ="2" >
< tr >
< td >
工号 </ td >
< td >
< asp:TextBox ID ="txtCode" runat ="server" Width ="200" Text ='<%# Bind("Code") % > ' />
</ td >
</ tr >
< tr >
< td >
姓名 </ td >
< td >
< asp:TextBox ID ="txtGroupName" runat ="server" Width ="200" Text ='<%# Bind("Name") % > ' />
</ td >
</ tr >
< tr >
< td >
部门 </ td >
< td >
< asp:DropDownList ID ="lstDepts" runat ="server" DataTextField ="Name" DataValueField ="ID"
DataSourceID ="odsDepts" SelectedValue ='<%# Bind("DeptID") % > '>
</ asp:DropDownList >
</ td >
</ tr >
</ table >
< p >
< asp:Button ID ="btnInsert" runat ="server" CommandName ="Insert" Text ="新增" />
</ p >
</ InsertItemTemplate >
</ asp:FormView >
</ asp:Panel >
< asp:ObjectDataSource ID ="odsEmployees" runat ="server" TypeName ="Guushuuse.SalaryPrj.HR.Helper.HRHelper"
SelectMethod ="GetAllEmployees" InsertMethod ="CreateEmployee" UpdateMethod ="UpdateEmployee"
DeleteMethod ="DeleteEmployee" ></ asp:ObjectDataSource >
< asp:ObjectDataSource ID ="odsDepts" runat ="server" TypeName ="Guushuuse.SalaryPrj.HR.Helper.HRHelper"
SelectMethod ="GetAllDepts" ></ asp:ObjectDataSource >
</ asp:Content >
CodeFile="Employees.aspx.cs" Inherits="Employees" %>
< asp:Content ID ="LeftColumnContent" ContentPlaceHolderID ="LeftColumnZone" runat ="server" >
</ asp:Content >
< asp:Content ID ="MiddleColumnContent" ContentPlaceHolderID ="MiddleColumnZone" runat ="server" >
< asp:Panel ID ="Panel1" runat ="server" GroupingText ="员工列表" >
< br />
< asp:GridView ID ="GridView1" runat ="server" DataSourceID ="odsEmployees" DataKeyNames ="ID"
AutoGenerateColumns ="False" Width ="100%" AllowPaging ="true" PageSize ="10" >
< Columns >
< asp:TemplateField >
< ItemTemplate >
< asp:Button ID ="btnEdit" runat ="server" CommandName ="Edit" Text ="编辑" />
< asp:Button ID ="btnDelete" runat ="server" CommandName ="Delete" Text ="删除" OnClientClick ="return confirm('您真的要删除吗?')" />
</ ItemTemplate >
< EditItemTemplate >
< asp:Button ID ="btnUpdate" runat ="server" CommandName ="Update" Text ="更新" />
< asp:Button ID ="btnCancel" runat ="server" CommandName ="Cancel" Text ="取消" />
</ EditItemTemplate >
</ asp:TemplateField >
< asp:BoundField HeaderText ="工号" DataField ="Code" />
< asp:BoundField HeaderText ="姓名" DataField ="Name" />
< asp:TemplateField HeaderText ="部门" >
< ItemTemplate >
< asp:Label ID ="lblDeptName" runat ="server" Text ='<%# Eval("DeptName") % > ' />
</ ItemTemplate >
< EditItemTemplate >
< asp:DropDownList ID ="lstDepts" runat ="server" DataTextField ="Name" DataValueField ="ID"
DataSourceID ="odsDepts" SelectedValue ='<%# Bind("DeptID") % > '>
</ asp:DropDownList >
</ EditItemTemplate >
</ asp:TemplateField >
</ Columns >
</ asp:GridView >
</ asp:Panel >
< hr />
< asp:Panel ID ="Panel2" runat ="server" GroupingText ="新增员工" >
< br />
< asp:FormView ID ="FormView1" runat ="server" DataSourceID ="odsEmployees" DefaultMode ="Insert" >
< InsertItemTemplate >
< table width ="100%" border ="0" cellpadding ="2" cellspacing ="2" >
< tr >
< td >
工号 </ td >
< td >
< asp:TextBox ID ="txtCode" runat ="server" Width ="200" Text ='<%# Bind("Code") % > ' />
</ td >
</ tr >
< tr >
< td >
姓名 </ td >
< td >
< asp:TextBox ID ="txtGroupName" runat ="server" Width ="200" Text ='<%# Bind("Name") % > ' />
</ td >
</ tr >
< tr >
< td >
部门 </ td >
< td >
< asp:DropDownList ID ="lstDepts" runat ="server" DataTextField ="Name" DataValueField ="ID"
DataSourceID ="odsDepts" SelectedValue ='<%# Bind("DeptID") % > '>
</ asp:DropDownList >
</ td >
</ tr >
</ table >
< p >
< asp:Button ID ="btnInsert" runat ="server" CommandName ="Insert" Text ="新增" />
</ p >
</ InsertItemTemplate >
</ asp:FormView >
</ asp:Panel >
< asp:ObjectDataSource ID ="odsEmployees" runat ="server" TypeName ="Guushuuse.SalaryPrj.HR.Helper.HRHelper"
SelectMethod ="GetAllEmployees" InsertMethod ="CreateEmployee" UpdateMethod ="UpdateEmployee"
DeleteMethod ="DeleteEmployee" ></ asp:ObjectDataSource >
< asp:ObjectDataSource ID ="odsDepts" runat ="server" TypeName ="Guushuuse.SalaryPrj.HR.Helper.HRHelper"
SelectMethod ="GetAllDepts" ></ asp:ObjectDataSource >
</ asp:Content >