当前文件路径：HouseManage/CompanyManage/PersonnelForm.aspx 
1
<%...--文件名：PersonnelForm.aspx--%>
2<%...@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="PersonnelForm.aspx.cs" Inherits="CompanyManage_PersonnelForm" Title="当前位置：资料管理->公司职员设置"%>
3
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
4 <table style="width: 556px; height: 161px">
5 <tr>
6 <td align="left" style="font-size: 0.8em; width: 2232px; font-family: 宋体; height: 16px;
7 background-color: darkturquoise">
8 请输入需要查询职员的姓名：<asp:TextBox ID="TextBox1" runat="server" Width="136px">%%</asp:TextBox>
9 <asp:Button ID="Button1" runat="server" Text="查询" Width="70px" />
10 <asp:Button ID="Button2" runat="server" OnClick="Button2_Click" Text="新增" Width="70px" />
11 <asp:Button ID="Button3" runat="server" OnClick="Button3_Click" Text="修改" Width="70px" /></td>
12 </tr>
13 <tr>
14 <td align="left" style="font-size: 0.8em; width: 2232px; font-family: 宋体; height: 141px;
15 background-color: palegoldenrod" valign="top">
16 编号：<asp:TextBox ID="TextBox2" runat="server" Width="83px"></asp:TextBox>
17 姓名：<asp:TextBox ID="TextBox3" runat="server" Width="59px"></asp:TextBox>
18 性别：<asp:DropDownList ID="DropDownList1" runat="server">
19 <asp:ListItem></asp:ListItem>
20 <asp:ListItem>男</asp:ListItem>
21 <asp:ListItem>女</asp:ListItem>
22 </asp:DropDownList>
23 学历：<asp:DropDownList ID="DropDownList2" runat="server">
24 <asp:ListItem></asp:ListItem>
25 <asp:ListItem>本科</asp:ListItem>
26 <asp:ListItem>大专</asp:ListItem>
27 <asp:ListItem>高中</asp:ListItem>
28 <asp:ListItem>硕士</asp:ListItem>
29 <asp:ListItem>博士</asp:ListItem>
30 <asp:ListItem>初中</asp:ListItem>
31 <asp:ListItem>其他</asp:ListItem>
32 </asp:DropDownList>
33 职务：<asp:TextBox ID="TextBox6" runat="server" Width="65px"></asp:TextBox><br />
34 所在部门：<asp:TextBox ID="TextBox7" runat="server" Width="57px"></asp:TextBox>
35 身份证号码：<asp:TextBox ID="TextBox8" runat="server" Width="161px"></asp:TextBox>
36 出生日期：<asp:TextBox ID="TextBox9" runat="server" Width="83px">1972-8-15</asp:TextBox><br />
37 入职日期：<asp:TextBox ID="TextBox10" runat="server" Width="64px">1991-7-13</asp:TextBox>
38 婚姻状况：<asp:DropDownList ID="DropDownList3" runat="server">
39 <asp:ListItem>已婚</asp:ListItem>
40 <asp:ListItem>未婚</asp:ListItem>
41 </asp:DropDownList>
42 联系电话：<asp:TextBox ID="TextBox12" runat="server" Width="203px"></asp:TextBox><br />
43 家庭地址：<asp:TextBox ID="TextBox13" runat="server" Width="134px"></asp:TextBox>
44 邮政编码：<asp:TextBox ID="TextBox14" runat="server" Width="56px"></asp:TextBox>
45 电子邮箱：<asp:TextBox ID="TextBox15" runat="server" Width="123px"></asp:TextBox><br />
46 补充说明：<asp:TextBox ID="TextBox16" runat="server" Width="469px">暂无</asp:TextBox><br />
47 工作简历：<asp:TextBox ID="TextBox17" runat="server" Height="41px" TextMode="MultiLine"
48 Width="469px"></asp:TextBox>
49 <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MyHouseDBConnectionString %>"
50 DeleteCommand="DELETE FROM [职员信息] WHERE [职员编号] = @职员编号" InsertCommand="INSERT INTO [职员信息] ([职员编号], [职员姓名], [职员性别], [职员学历], [职员职务], [所在部门], [身份证号], [出生日期], [入职日期], [婚姻状况], [联系电话], [家庭地址], [邮政编码], [电子邮箱], [补充说明], [工作简历]) VALUES (@职员编号, @职员姓名, @职员性别, @职员学历, @职员职务, @所在部门, @身份证号, @出生日期, @入职日期, @婚姻状况, @联系电话, @家庭地址, @邮政编码, @电子邮箱, @补充说明, @工作简历)"
51 SelectCommand="SELECT * FROM [职员信息] WHERE ([职员姓名] LIKE '%' + @职员姓名 + '%')" UpdateCommand="UPDATE [职员信息] SET [职员姓名] = @职员姓名, [职员性别] = @职员性别, [职员学历] = @职员学历, [职员职务] = @职员职务, [所在部门] = @所在部门, [身份证号] = @身份证号, [出生日期] = @出生日期, [入职日期] = @入职日期, [婚姻状况] = @婚姻状况, [联系电话] = @联系电话, [家庭地址] = @家庭地址, [邮政编码] = @邮政编码, [电子邮箱] = @电子邮箱, [补充说明] = @补充说明, [工作简历] = @工作简历 WHERE [职员编号] = @职员编号">
52 <DeleteParameters>
53 <asp:Parameter Name="职员编号" Type="String" />
54 </DeleteParameters>
55 <UpdateParameters>
56 <asp:ControlParameter ControlID="TextBox3" Name="职员姓名" PropertyName="Text" Type="String" />
57 <asp:ControlParameter ControlID="DropDownList1" Name="职员性别" PropertyName="SelectedValue"
58 Type="String" />
59 <asp:ControlParameter ControlID="DropDownList2" Name="职员学历" PropertyName="SelectedValue"
60 Type="String" />
61 <asp:ControlParameter ControlID="TextBox6" Name="职员职务" PropertyName="Text" Type="String" />
62 <asp:ControlParameter ControlID="TextBox7" Name="所在部门" PropertyName="Text" Type="String" />
63 <asp:ControlParameter ControlID="TextBox8" Name="身份证号" PropertyName="Text" Type="String" />
64 <asp:ControlParameter ControlID="TextBox9" Name="出生日期" PropertyName="Text" Type="DateTime" />
65 <asp:ControlParameter ControlID="TextBox10" Name="入职日期" PropertyName="Text" Type="DateTime" />
66 <asp:ControlParameter ControlID="DropDownList3" Name="婚姻状况" PropertyName="SelectedValue"
67 Type="String" />
68 <asp:ControlParameter ControlID="TextBox12" Name="联系电话" PropertyName="Text" Type="String" />
69 <asp:ControlParameter ControlID="TextBox13" Name="家庭地址" PropertyName="Text" Type="String" />
70 <asp:ControlParameter ControlID="TextBox14" Name="邮政编码" PropertyName="Text" Type="String" />
71 <asp:ControlParameter ControlID="TextBox15" Name="电子邮箱" PropertyName="Text" Type="String" />
72 <asp:ControlParameter ControlID="TextBox16" Name="补充说明" PropertyName="Text" Type="String" />
73 <asp:ControlParameter ControlID="TextBox17" Name="工作简历" PropertyName="Text" Type="String" />
74 <asp:ControlParameter ControlID="TextBox2" Name="职员编号" PropertyName="Text" Type="String" />
75 </UpdateParameters>
76 <SelectParameters>
77 <asp:ControlParameter ControlID="TextBox1" Name="职员姓名" PropertyName="Text" Type="String" />
78 </SelectParameters>
79 <InsertParameters>
80 <asp:ControlParameter ControlID="TextBox2" Name="职员编号" PropertyName="Text" Type="String" />
81 <asp:ControlParameter ControlID="TextBox3" Name="职员姓名" PropertyName="Text" Type="String" />
82 <asp:ControlParameter ControlID="DropDownList1" Name="职员性别" PropertyName="SelectedValue"
83 Type="String" />
84 <asp:ControlParameter ControlID="DropDownList2" Name="职员学历" PropertyName="SelectedValue"
85 Type="String" />
86 <asp:ControlParameter ControlID="TextBox6" Name="职员职务" PropertyName="Text" Type="String" />
87 <asp:ControlParameter ControlID="TextBox7" Name="所在部门" PropertyName="Text" Type="String" />
88 <asp:ControlParameter ControlID="TextBox8" Name="身份证号" PropertyName="Text" Type="String" />
89 <asp:ControlParameter ControlID="TextBox9" Name="出生日期" PropertyName="Text" Type="DateTime" />
90 <asp:ControlParameter ControlID="TextBox10" Name="入职日期" PropertyName="Text" Type="DateTime" />
91 <asp:ControlParameter ControlID="DropDownList3" Name="婚姻状况" PropertyName="SelectedValue"
92 Type="String" />
93 <asp:ControlParameter ControlID="TextBox12" Name="联系电话" PropertyName="Text" Type="String" />
94 <asp:ControlParameter ControlID="TextBox13" Name="家庭地址" PropertyName="Text" Type="String" />
95 <asp:ControlParameter ControlID="TextBox14" Name="邮政编码" PropertyName="Text" Type="String" />
96 <asp:ControlParameter ControlID="TextBox15" Name="电子邮箱" PropertyName="Text" Type="String" />
97 <asp:ControlParameter ControlID="TextBox16" Name="补充说明" PropertyName="Text" Type="String" />
98 <asp:ControlParameter ControlID="TextBox17" Name="工作简历" PropertyName="Text" Type="String" />
99 </InsertParameters>
100 </asp:SqlDataSource>
101 </td>
102 </tr>
103 <tr>
104 <td style="width: 2232px; height: 50px; background-color: gainsboro">
105 <asp:Panel ID="Panel1" runat="server" Height="150px" ScrollBars="Auto" Width="553px">
106 <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" BackColor="White"
107 BorderColor="#999999" BorderStyle="None" BorderWidth="1px" CellPadding="3" DataKeyNames="职员编号"
108 DataSourceID="SqlDataSource1" Font-Names="宋体" Font-Size="Small" GridLines="Vertical"
109 OnRowCreated="GridView1_RowCreated" OnSelectedIndexChanged="GridView1_SelectedIndexChanged"
110 Width="1900px">
111 <FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
112 <Columns>
113 <asp:CommandField ButtonType="Button" HeaderText="选择" ShowSelectButton="True" />
114 <asp:TemplateField HeaderText="删除" ShowHeader="False">
115 <ItemTemplate>
116 <asp:Button ID="Button1" runat="server" CausesValidation="False" CommandName="Delete"
117 Text="删除" />
118 </ItemTemplate>
119 </asp:TemplateField>
120 <asp:BoundField DataField="职员编号" HeaderText="职员编号" ReadOnly="True" SortExpression="职员编号" />
121 <asp:BoundField DataField="职员姓名" HeaderText="职员姓名" SortExpression="职员姓名" />
122 <asp:BoundField DataField="职员性别" HeaderText="职员性别" SortExpression="职员性别" />
123 <asp:BoundField DataField="职员学历" HeaderText="职员学历" SortExpression="职员学历" />
124 <asp:BoundField DataField="职员职务" HeaderText="职员职务" SortExpression="职员职务" />
125 <asp:BoundField DataField="所在部门" HeaderText="所在部门" SortExpression="所在部门" />
126 <asp:BoundField DataField="身份证号" HeaderText="身份证号" SortExpression="身份证号" />
127 <asp:BoundField DataField="出生日期" HeaderText="出生日期" SortExpression="出生日期" />
128 <asp:BoundField DataField="入职日期" HeaderText="入职日期" SortExpression="入职日期" />
129 <asp:BoundField DataField="婚姻状况" HeaderText="婚姻状况" SortExpression="婚姻状况" />
130 <asp:BoundField DataField="联系电话" HeaderText="联系电话" SortExpression="联系电话" />
131 <asp:BoundField DataField="家庭地址" HeaderText="家庭地址" SortExpression="家庭地址" />
132 <asp:BoundField DataField="邮政编码" HeaderText="邮政编码" SortExpression="邮政编码" />
133 <asp:BoundField DataField="电子邮箱" HeaderText="电子邮箱" SortExpression="电子邮箱" />
134 <asp:BoundField DataField="补充说明" HeaderText="补充说明" SortExpression="补充说明" />
135 <asp:BoundField DataField="工作简历" HeaderText="工作简历" SortExpression="工作简历" />
136 </Columns>
137 <RowStyle BackColor="#EEEEEE" ForeColor="Black" />
138 <SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
139 <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
140 <HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" HorizontalAlign="Center" />
141 <AlternatingRowStyle BackColor="#DCDCDC" />
142 </asp:GridView>
143 </asp:Panel>
144 </td>
145 </tr>
146 </table>
147</asp:Content>
148
149
打包下载该项目完整源码：Asp.net房产中介管理系统源码及常用文档
