当前文件路径：StaffSalaryManage/FileManage/PersonnelForm.aspx 
1
<%...--文件名:PersonnelForm.aspx--%>
2<%...@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="PersonnelForm.aspx.cs" Inherits="FileManage_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: teal">
8 请输入查询员工姓名：<asp:TextBox ID="TextBox1" runat="server" Width="149px">%%</asp:TextBox>
9 <asp:Button ID="Button1" runat="server" Text="查询" Width="80px" />
10 <asp:Button ID="Button2" runat="server" Text="新增" Width="80px" OnClick="Button2_Click" />
11 <asp:Button ID="Button3" runat="server" Text="修改" Width="80px" OnClick="Button3_Click" /></td>
12 </tr>
13 <tr>
14 <td align="left" style="font-size: 0.8em; width: 2232px; font-family: 宋体; height: 27px;
15 background-color: gainsboro">
16 <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:MyPersonnelDBConnectionString %>"
17 SelectCommand="SELECT * FROM [公司部门]"></asp:SqlDataSource>
18 员工编号:<asp:TextBox ID="TextBox2" runat="server" Width="61px">A000001</asp:TextBox>
19 所属部门:<asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource2"
20 DataTextField="部门名称" DataValueField="部门名称">
21 </asp:DropDownList>
22 姓名：<asp:TextBox ID="TextBox3" runat="server" Width="49px">罗斌</asp:TextBox>
23 性别:<asp:DropDownList ID="DropDownList2" runat="server">
24 <asp:ListItem>男</asp:ListItem>
25 <asp:ListItem>女</asp:ListItem>
26 </asp:DropDownList>
27 民族:<asp:TextBox ID="TextBox4" runat="server" Width="42px">汉族</asp:TextBox><br />
28 籍贯:<asp:TextBox ID="TextBox5" runat="server" Width="144px">重庆市长寿区</asp:TextBox>
29 出生日期:<asp:TextBox ID="TextBox6" runat="server" Width="71px">1972-8-5</asp:TextBox>
30 身份证号码:<asp:TextBox ID="TextBox7" runat="server" Width="131px">510221197208152316</asp:TextBox><br />
31 政治面貌:<asp:TextBox ID="TextBox8" runat="server" Width="47px">共产党员</asp:TextBox>
32 婚姻状况:<asp:DropDownList ID="DropDownList3" runat="server">
33 <asp:ListItem>已婚</asp:ListItem>
34 <asp:ListItem>未婚</asp:ListItem>
35 </asp:DropDownList>
36 文化程度:<asp:DropDownList ID="DropDownList4" runat="server">
37 <asp:ListItem>本科</asp:ListItem>
38 <asp:ListItem>硕士</asp:ListItem>
39 <asp:ListItem>博士</asp:ListItem>
40 <asp:ListItem>专科</asp:ListItem>
41 <asp:ListItem>高中</asp:ListItem>
42 <asp:ListItem>其他</asp:ListItem>
43 </asp:DropDownList>
44 职称:<asp:DropDownList ID="DropDownList5" runat="server">
45 <asp:ListItem>高级</asp:ListItem>
46 <asp:ListItem>中级</asp:ListItem>
47 <asp:ListItem>初级</asp:ListItem>
48 <asp:ListItem>其他</asp:ListItem>
49 </asp:DropDownList>
50 职务:<asp:TextBox ID="TextBox9" runat="server" Width="53px">普通员工</asp:TextBox><br />
51 专业:<asp:TextBox ID="TextBox10" runat="server" Width="98px">财务会计</asp:TextBox>
52 毕业院校:<asp:TextBox ID="TextBox11" runat="server" Width="139px">西南财经大学</asp:TextBox>
53 进入公司时间:<asp:TextBox ID="TextBox12" runat="server" Width="96px">1991-7-13</asp:TextBox><br />
54 合同服务年限:<asp:DropDownList ID="DropDownList6" runat="server">
55 <asp:ListItem>三年</asp:ListItem>
56 <asp:ListItem>一年</asp:ListItem>
57 <asp:ListItem>二年</asp:ListItem>
58 <asp:ListItem>五年</asp:ListItem>
59 <asp:ListItem>长期</asp:ListItem>
60 <asp:ListItem>其他</asp:ListItem>
61 </asp:DropDownList>
62 基本工资:<asp:TextBox ID="TextBox13" runat="server" Width="47px">0.00</asp:TextBox>
63 银行账号:<asp:TextBox ID="TextBox14" runat="server" Width="213px">3763969980130035760</asp:TextBox><br />
64 养老保险账号:<asp:TextBox ID="TextBox15" runat="server" Width="87px">604948674</asp:TextBox>
65 医疗保险账号:<asp:TextBox ID="TextBox16" runat="server" Width="79px">6004325960</asp:TextBox>
66 住房基金账号:<asp:TextBox ID="TextBox17" runat="server" Width="89px">6004325960</asp:TextBox><br />
67 联系电话:<asp:TextBox ID="TextBox18" runat="server" Width="63px">023-40405690</asp:TextBox>
68 手机号码:<asp:TextBox ID="TextBox19" runat="server" Width="76px">13036371686</asp:TextBox>
69 电子信箱:<asp:TextBox ID="TextBox20" runat="server" Width="114px">binluobin@163.com</asp:TextBox>
70 自编号:<asp:TextBox ID="TextBox24" runat="server" BackColor="Gray" ReadOnly="True" Width="19px"></asp:TextBox><br />
71 家庭住址:<asp:TextBox ID="TextBox21" runat="server" Width="127px">重庆市长寿区三峡路7号1单元6-1</asp:TextBox>
72 邮政编码:<asp:TextBox ID="TextBox22" runat="server" Width="47px">401220</asp:TextBox>
73 补充说明:<asp:TextBox ID="TextBox23" runat="server" Width="159px">暂无</asp:TextBox></td>
74 </tr>
75 <tr>
76 <td style="width: 2232px; height: 100px; background-color: gainsboro">
77 <asp:Panel ID="Panel1" runat="server" Height="150px" ScrollBars="Auto" Width="553px">
78 <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" BackColor="White"
79 BorderColor="#999999" BorderStyle="None" BorderWidth="1px" CellPadding="3" DataKeyNames="自编号"
80 DataSourceID="SqlDataSource1" Font-Names="宋体" Font-Size="Small" GridLines="Vertical"
81 Width="3500px" OnRowCreated="GridView1_RowCreated" OnSelectedIndexChanged="GridView1_SelectedIndexChanged">
82 <FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
83 <Columns>
84 <asp:CommandField ButtonType="Button" HeaderText="选择" ShowSelectButton="True" />
85 <asp:TemplateField HeaderText="删除" ShowHeader="False">
86 <ItemTemplate>
87 <asp:Button ID="Button1" runat="server" CausesValidation="False" CommandName="Delete"
88 Text="删除" />
89 </ItemTemplate>
90 </asp:TemplateField>
91 <asp:BoundField DataField="自编号" HeaderText="自编号" InsertVisible="False" ReadOnly="True"
92 SortExpression="自编号" />
93 <asp:BoundField DataField="员工编号" HeaderText="员工编号" SortExpression="员工编号" />
94 <asp:BoundField DataField="所属部门" HeaderText="所属部门" SortExpression="所属部门" />
95 <asp:BoundField DataField="姓名" HeaderText="姓名" SortExpression="姓名" />
96 <asp:BoundField DataField="性别" HeaderText="性别" SortExpression="性别" />
97 <asp:BoundField DataField="民族" HeaderText="民族" SortExpression="民族" />
98 <asp:BoundField DataField="籍贯" HeaderText="籍贯" SortExpression="籍贯" />
99 <asp:BoundField DataField="出生日期" HeaderText="出生日期" SortExpression="出生日期" />
100 <asp:BoundField DataField="身份证号码" HeaderText="身份证号码" SortExpression="身份证号码" />
101 <asp:BoundField DataField="政治面貌" HeaderText="政治面貌" SortExpression="政治面貌" />
102 <asp:BoundField DataField="婚姻状况" HeaderText="婚姻状况" SortExpression="婚姻状况" />
103 <asp:BoundField DataField="文化程度" HeaderText="文化程度" SortExpression="文化程度" />
104 <asp:BoundField DataField="职称" HeaderText="职称" SortExpression="职称" />
105 <asp:BoundField DataField="职务" HeaderText="职务" SortExpression="职务" />
106 <asp:BoundField DataField="专业" HeaderText="专业" SortExpression="专业" />
107 <asp:BoundField DataField="毕业院校" HeaderText="毕业院校" SortExpression="毕业院校" />
108 <asp:BoundField DataField="进入公司时间" HeaderText="进入公司时间" SortExpression="进入公司时间" />
109 <asp:BoundField DataField="合同服务年限" HeaderText="合同服务年限" SortExpression="合同服务年限" />
110 <asp:BoundField DataField="基本工资" HeaderText="基本工资" SortExpression="基本工资" />
111 <asp:BoundField DataField="银行账号" HeaderText="银行账号" SortExpression="银行账号" />
112 <asp:BoundField DataField="养老保险账号" HeaderText="养老保险账号" SortExpression="养老保险账号" />
113 <asp:BoundField DataField="医疗保险账号" HeaderText="医疗保险账号" SortExpression="医疗保险账号" />
114 <asp:BoundField DataField="住房基金账号" HeaderText="住房基金账号" SortExpression="住房基金账号" />
115 <asp:BoundField DataField="联系电话" HeaderText="联系电话" SortExpression="联系电话" />
116 <asp:BoundField DataField="手机号码" HeaderText="手机号码" SortExpression="手机号码" />
117 <asp:BoundField DataField="电子信箱" HeaderText="电子信箱" SortExpression="电子信箱" />
118 <asp:BoundField DataField="家庭住址" HeaderText="家庭住址" SortExpression="家庭住址" />
119 <asp:BoundField DataField="邮政编码" HeaderText="邮政编码" SortExpression="邮政编码" />
120 <asp:BoundField DataField="补充说明" HeaderText="补充说明" SortExpression="补充说明" />
121 </Columns>
122 <RowStyle BackColor="#EEEEEE" ForeColor="Black" />
123 <SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
124 <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
125 <HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" HorizontalAlign="Center" />
126 <AlternatingRowStyle BackColor="Gainsboro" />
127 </asp:GridView>
128 </asp:Panel>
129 <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MyPersonnelDBConnectionString %>"
130 DeleteCommand="DELETE FROM [在职员工视图] WHERE [自编号] = @自编号" InsertCommand="INSERT INTO [基本档案] ([员工编号], [所属部门], [姓名], [性别], [民族], [籍贯], [出生日期], [身份证号码], [政治面貌], [婚姻状况], [文化程度], [职称], [职务], [专业], [毕业院校], [进入公司时间], [合同服务年限], [基本工资], [银行账号], [养老保险账号], [医疗保险账号], [住房基金账号], [联系电话], [手机号码], [电子信箱], [家庭住址], [邮政编码], [补充说明]) VALUES (@员工编号, @所属部门, @姓名, @性别, @民族, @籍贯, @出生日期, @身份证号码, @政治面貌, @婚姻状况, @文化程度, @职称, @职务, @专业, @毕业院校, @进入公司时间, @合同服务年限, @基本工资, @银行账号, @养老保险账号, @医疗保险账号, @住房基金账号, @联系电话, @手机号码, @电子信箱, @家庭住址, @邮政编码, @补充说明)"
131 ProviderName="<%$ ConnectionStrings:MyPersonnelDBConnectionString.ProviderName %>"
132 SelectCommand="SELECT [自编号], [员工编号], [所属部门], [姓名], [性别], [民族], [籍贯], [出生日期], [身份证号码], [政治面貌], [婚姻状况], [文化程度], [职称], [职务], [专业], [毕业院校], [进入公司时间], [合同服务年限], [基本工资], [银行账号], [养老保险账号], [医疗保险账号], [住房基金账号], [联系电话], [手机号码], [电子信箱], [家庭住址], [邮政编码], [补充说明] FROM [在职员工视图] WHERE ([姓名] LIKE '%' + @姓名 + '%')"
133 UpdateCommand="UPDATE [在职员工视图] SET [员工编号] = @员工编号, [所属部门] = @所属部门, [姓名] = @姓名, [性别] = @性别, [民族] = @民族, [籍贯] = @籍贯, [出生日期] = @出生日期, [身份证号码] = @身份证号码, [政治面貌] = @政治面貌, [婚姻状况] = @婚姻状况, [文化程度] = @文化程度, [职称] = @职称, [职务] = @职务, [专业] = @专业, [毕业院校] = @毕业院校, [进入公司时间] = @进入公司时间, [合同服务年限] = @合同服务年限, [基本工资] = @基本工资, [银行账号] = @银行账号, [养老保险账号] = @养老保险账号, [医疗保险账号] = @医疗保险账号, [住房基金账号] = @住房基金账号, [联系电话] = @联系电话, [手机号码] = @手机号码, [电子信箱] = @电子信箱, [家庭住址] = @家庭住址, [邮政编码] = @邮政编码, [补充说明] = @补充说明 WHERE [自编号] = @自编号">
134 <DeleteParameters>
135 <asp:Parameter Name="自编号" Type="Int32" />
136 </DeleteParameters>
137 <UpdateParameters>
138 <asp:ControlParameter ControlID="TextBox2" Name="员工编号" PropertyName="Text" Type="String" />
139 <asp:ControlParameter ControlID="DropDownList1" Name="所属部门" PropertyName="SelectedValue"
140 Type="String" />
141 <asp:ControlParameter ControlID="TextBox3" Name="姓名" PropertyName="Text" Type="String" />
142 <asp:ControlParameter ControlID="DropDownList2" Name="性别" PropertyName="SelectedValue"
143 Type="String" />
144 <asp:ControlParameter ControlID="TextBox4" Name="民族" PropertyName="Text" Type="String" />
145 <asp:ControlParameter ControlID="TextBox5" Name="籍贯" PropertyName="Text" Type="String" />
146 <asp:ControlParameter ControlID="TextBox6" Name="出生日期" PropertyName="Text" Type="DateTime" />
147 <asp:ControlParameter ControlID="TextBox7" Name="身份证号码" PropertyName="Text" Type="String" />
148 <asp:ControlParameter ControlID="TextBox8" Name="政治面貌" PropertyName="Text" Type="String" />
149 <asp:ControlParameter ControlID="DropDownList3" Name="婚姻状况" PropertyName="SelectedValue"
150 Type="String" />
151 <asp:ControlParameter ControlID="DropDownList4" Name="文化程度" PropertyName="SelectedValue"
152 Type="String" />
153 <asp:ControlParameter ControlID="DropDownList5" Name="职称" PropertyName="SelectedValue"
154 Type="String" />
155 <asp:ControlParameter ControlID="TextBox9" Name="职务" PropertyName="Text" Type="String" />
156 <asp:ControlParameter ControlID="TextBox10" Name="专业" PropertyName="Text" Type="String" />
157 <asp:ControlParameter ControlID="TextBox11" Name="毕业院校" PropertyName="Text" Type="String" />
158 <asp:ControlParameter ControlID="TextBox12" Name="进入公司时间" PropertyName="Text" Type="DateTime" />
159 <asp:ControlParameter ControlID="DropDownList6" Name="合同服务年限" PropertyName="SelectedValue"
160 Type="String" />
161 <asp:ControlParameter ControlID="TextBox13" Name="基本工资" PropertyName="Text" Type="Double" />
162 <asp:ControlParameter ControlID="TextBox14" Name="银行账号" PropertyName="Text" Type="String" />
163 <asp:ControlParameter ControlID="TextBox15" Name="养老保险账号" PropertyName="Text" Type="String" />
164 <asp:ControlParameter ControlID="TextBox16" Name="医疗保险账号" PropertyName="Text" Type="String" />
165 <asp:ControlParameter ControlID="TextBox17" Name="住房基金账号" PropertyName="Text" Type="String" />
166 <asp:ControlParameter ControlID="TextBox18" Name="联系电话" PropertyName="Text" Type="String" />
167 <asp:ControlParameter ControlID="TextBox19" Name="手机号码" PropertyName="Text" Type="String" />
168 <asp:ControlParameter ControlID="TextBox20" Name="电子信箱" PropertyName="Text" Type="String" />
169 <asp:ControlParameter ControlID="TextBox21" Name="家庭住址" PropertyName="Text" Type="String" />
170 <asp:ControlParameter ControlID="TextBox22" Name="邮政编码" PropertyName="Text" Type="String" />
171 <asp:ControlParameter ControlID="TextBox23" Name="补充说明" PropertyName="Text" Type="String" />
172 <asp:ControlParameter ControlID="TextBox24" DefaultValue="" Name="自编号" PropertyName="Text"
173 Type="Int32" />
174 </UpdateParameters>
175 <SelectParameters>
176 <asp:ControlParameter ControlID="TextBox1" Name="姓名" PropertyName="Text" Type="String" />
177 </SelectParameters>
178 <InsertParameters>
179 <asp:ControlParameter ControlID="TextBox2" Name="员工编号" PropertyName="Text" Type="String" />
180 <asp:ControlParameter ControlID="DropDownList1" Name="所属部门" PropertyName="SelectedValue"
181 Type="String" />
182 <asp:ControlParameter ControlID="TextBox3" Name="姓名" PropertyName="Text" Type="String" />
183 <asp:ControlParameter ControlID="DropDownList2" Name="性别" PropertyName="SelectedValue"
184 Type="String" />
185 <asp:ControlParameter ControlID="TextBox4" Name="民族" PropertyName="Text" Type="String" />
186 <asp:ControlParameter ControlID="TextBox5" Name="籍贯" PropertyName="Text" Type="String" />
187 <asp:ControlParameter ControlID="TextBox6" Name="出生日期" PropertyName="Text" Type="DateTime" />
188 <asp:ControlParameter ControlID="TextBox7" Name="身份证号码" PropertyName="Text" Type="String" />
189 <asp:ControlParameter ControlID="TextBox8" Name="政治面貌" PropertyName="Text" Type="String" />
190 <asp:ControlParameter ControlID="DropDownList3" Name="婚姻状况" PropertyName="SelectedValue"
191 Type="String" />
192 <asp:ControlParameter ControlID="DropDownList4" Name="文化程度" PropertyName="SelectedValue"
193 Type="String"
