personnelform.aspx

工资管理系统用C#和sql开发的

<%--文件名:PersonnelForm.aspx--%>
<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="PersonnelForm.aspx.cs" Inherits="FileManage_PersonnelForm" Title="当前位置：人事管理->员工基本档案" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <table style="width: 556px; height: 161px">
        <tr>
            <td align="left" style="font-size: 0.8em; width: 2232px; font-family: 宋体; height: 16px;
                background-color: teal">
                请输入查询员工姓名：<asp:TextBox ID="TextBox1" runat="server" Width="149px">%%</asp:TextBox>
                <asp:Button ID="Button1" runat="server" Text="查询" Width="80px" />
                <asp:Button ID="Button2" runat="server" Text="新增" Width="80px" OnClick="Button2_Click" />
                <asp:Button ID="Button3" runat="server" Text="修改" Width="80px" OnClick="Button3_Click" /></td>
        </tr>
        <tr>
            <td align="left" style="font-size: 0.8em; width: 2232px; font-family: 宋体; height: 27px;
                background-color: gainsboro">
                <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:MyPersonnelDBConnectionString %>"
                    SelectCommand="SELECT * FROM [公司部门]"></asp:SqlDataSource>
                &nbsp;员工编号:<asp:TextBox ID="TextBox2" runat="server" Width="61px">A000001</asp:TextBox>
                所属部门:<asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource2"
                    DataTextField="部门名称" DataValueField="部门名称">
                </asp:DropDownList>
                姓名：<asp:TextBox ID="TextBox3" runat="server" Width="49px">罗斌</asp:TextBox>
                性别:<asp:DropDownList ID="DropDownList2" runat="server">
                    <asp:ListItem>男</asp:ListItem>
                    <asp:ListItem>女</asp:ListItem>
                </asp:DropDownList>
                民族:<asp:TextBox ID="TextBox4" runat="server" Width="42px">汉族</asp:TextBox><br />
                &nbsp;籍贯:<asp:TextBox ID="TextBox5" runat="server" Width="144px">重庆市长寿区</asp:TextBox>
                出生日期:<asp:TextBox ID="TextBox6" runat="server" Width="71px">1972-8-5</asp:TextBox>
                身份证号码:<asp:TextBox ID="TextBox7" runat="server" Width="131px">510221197208152316</asp:TextBox><br />
                &nbsp;政治面貌:<asp:TextBox ID="TextBox8" runat="server" Width="47px">共产党员</asp:TextBox>
                婚姻状况:<asp:DropDownList ID="DropDownList3" runat="server">
                    <asp:ListItem>已婚</asp:ListItem>
                    <asp:ListItem>未婚</asp:ListItem>
                </asp:DropDownList>
                文化程度:<asp:DropDownList ID="DropDownList4" runat="server">
                    <asp:ListItem>本科</asp:ListItem>
                    <asp:ListItem>硕士</asp:ListItem>
                    <asp:ListItem>博士</asp:ListItem>
                    <asp:ListItem>专科</asp:ListItem>
                    <asp:ListItem>高中</asp:ListItem>
                    <asp:ListItem>其他</asp:ListItem>
                </asp:DropDownList>
                职称:<asp:DropDownList ID="DropDownList5" runat="server">
                    <asp:ListItem>高级</asp:ListItem>
                    <asp:ListItem>中级</asp:ListItem>
                    <asp:ListItem>初级</asp:ListItem>
                    <asp:ListItem>其他</asp:ListItem>
                </asp:DropDownList>
                职务:<asp:TextBox ID="TextBox9" runat="server" Width="53px">普通员工</asp:TextBox><br />
                &nbsp;专业:<asp:TextBox ID="TextBox10" runat="server" Width="98px">财务会计</asp:TextBox>
                毕业院校:<asp:TextBox ID="TextBox11" runat="server" Width="139px">西南财经大学</asp:TextBox>
                进入公司时间:<asp:TextBox ID="TextBox12" runat="server" Width="96px">1991-7-13</asp:TextBox><br />
                &nbsp;合同服务年限:<asp:DropDownList ID="DropDownList6" runat="server">
                    <asp:ListItem>三年</asp:ListItem>
                    <asp:ListItem>一年</asp:ListItem>
                    <asp:ListItem>二年</asp:ListItem>
                    <asp:ListItem>五年</asp:ListItem>
                    <asp:ListItem>长期</asp:ListItem>
                    <asp:ListItem>其他</asp:ListItem>
                </asp:DropDownList>
                基本工资:<asp:TextBox ID="TextBox13" runat="server" Width="47px">0.00</asp:TextBox>
                银行账号:<asp:TextBox ID="TextBox14" runat="server" Width="213px">3763969980130035760</asp:TextBox><br />
                &nbsp;养老保险账号:<asp:TextBox ID="TextBox15" runat="server" Width="87px">604948674</asp:TextBox>
                医疗保险账号:<asp:TextBox ID="TextBox16" runat="server" Width="79px">6004325960</asp:TextBox>
                住房基金账号:<asp:TextBox ID="TextBox17" runat="server" Width="89px">6004325960</asp:TextBox><br />
                &nbsp;联系电话:<asp:TextBox ID="TextBox18" runat="server" Width="63px">023-40405690</asp:TextBox>
                手机号码:<asp:TextBox ID="TextBox19" runat="server" Width="76px">13036371686</asp:TextBox>
                电子信箱:<asp:TextBox ID="TextBox20" runat="server" Width="114px">[e-mail]</asp:TextBox>
                自编号:<asp:TextBox ID="TextBox24" runat="server" BackColor="Gray" ReadOnly="True" Width="19px"></asp:TextBox><br />
                &nbsp;家庭住址:<asp:TextBox ID="TextBox21" runat="server" Width="127px">重庆市长寿区三峡路7号1单元6-1</asp:TextBox>
                邮政编码:<asp:TextBox ID="TextBox22" runat="server" Width="47px">401220</asp:TextBox>
                补充说明:<asp:TextBox ID="TextBox23" runat="server" Width="159px">暂无</asp:TextBox></td>
        </tr>
        <tr>
            <td style="width: 2232px; height: 100px; background-color: gainsboro">
                <asp:Panel ID="Panel1" runat="server" Height="150px" ScrollBars="Auto" Width="553px">
                    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" BackColor="White"
                        BorderColor="#999999" BorderStyle="None" BorderWidth="1px" CellPadding="3" DataKeyNames="自编号"
                        DataSourceID="SqlDataSource1" Font-Names="宋体" Font-Size="Small" GridLines="Vertical"
                        Width="3500px" OnRowCreated="GridView1_RowCreated" OnSelectedIndexChanged="GridView1_SelectedIndexChanged">
                        <FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
                        <Columns>
                            <asp:CommandField ButtonType="Button" HeaderText="选择" ShowSelectButton="True" />
                            <asp:TemplateField HeaderText="删除" ShowHeader="False">
                                <ItemTemplate>
                                    <asp:Button ID="Button1" runat="server" CausesValidation="False" CommandName="Delete"
                                        Text="删除" />
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:BoundField DataField="自编号" HeaderText="自编号" InsertVisible="False" ReadOnly="True"
                                SortExpression="自编号" />
                            <asp:BoundField DataField="员工编号" HeaderText="员工编号" SortExpression="员工编号" />
                            <asp:BoundField DataField="所属部门" HeaderText="所属部门" SortExpression="所属部门" />
                            <asp:BoundField DataField="姓名" HeaderText="姓名" SortExpression="姓名" />
                            <asp:BoundField DataField="性别" HeaderText="性别" SortExpression="性别" />
                            <asp:BoundField DataField="民族" HeaderText="民族" SortExpression="民族" />
                            <asp:BoundField DataField="籍贯" HeaderText="籍贯" SortExpression="籍贯" />
                            <asp:BoundField DataField="出生日期" HeaderText="出生日期" SortExpression="出生日期" />
                            <asp:BoundField DataField="身份证号码" HeaderText="身份证号码" SortExpression="身份证号码" />
                            <asp:BoundField DataField="政治面貌" HeaderText="政治面貌" SortExpression="政治面貌" />
                            <asp:BoundField DataField="婚姻状况" HeaderText="婚姻状况" SortExpression="婚姻状况" />
                            <asp:BoundField DataField="文化程度" HeaderText="文化程度" SortExpression="文化程度" />
                            <asp:BoundField DataField="职称" HeaderText="职称" SortExpression="职称" />
                            <asp:BoundField DataField="职务" HeaderText="职务" SortExpression="职务" />
                            <asp:BoundField DataField="专业" HeaderText="专业" SortExpression="专业" />
                            <asp:BoundField DataField="毕业院校" HeaderText="毕业院校" SortExpression="毕业院校" />
                            <asp:BoundField DataField="进入公司时间" HeaderText="进入公司时间" SortExpression="进入公司时间" />
                            <asp:BoundField DataField="合同服务年限" HeaderText="合同服务年限" SortExpression="合同服务年限" />
                            <asp:BoundField DataField="基本工资" HeaderText="基本工资" SortExpression="基本工资" />