C# 员工考勤管理系统源码

【实例截图】

【核心代码】

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.IO;
using System.Data.SqlClient;

namespace 员工考勤管理系统
{
    public partial class EmployeeInfo : Form
    {
        public EmployeeInfo()
        {
            InitializeComponent();
        }
        byte[] photo;
        //_5_1_a_s_p_x
        /// <summary>
        /// 贴照片
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
       

        private void button3_Click(object sender, EventArgs e)
        {
            int flagid = 员工资料界面.Number.flag;
            //MessageBox.Show(flagid.ToString());
            
            if (flagid == 0)
            {
                //调用增加员工方法
                add();
                
            }
            else if(flagid==1)
            { 
            //调用修改员工信息方法
                //MessageBox.Show("fangfa2");
               
                checkmodify();
            }
            #region
            /*
            int Employee_Id1;//员工编号
            int solary;//员工工资
            string str = this.textBox1.Text.Trim();//员工编号
            int ii;
            if (int.TryParse(str,out ii))  //bool
            {
             Employee_Id1 = Convert.ToInt32(str);//员工编号
            }
            else
            {
                MessageBox.Show("员工编号格式为整数！");
                this.textBox1.Text = string.Empty;
                return;
            }
            if (this.textBox2.Text == string.Empty)
            {
                MessageBox.Show("请输入姓名！");
                return;
            }
            else if (this.textBox4.Text == string.Empty)
            {
                MessageBox.Show("请输入身份证号！");
                return;
            }
            else if (this.textBox7.Text == string.Empty)
            {
                MessageBox.Show("请输入手机号！");
                return;
            }

           
            int deptId = Convert.ToInt32(this.comboBox2.SelectedValue);
            int positionId = Convert.ToInt32(this.comboBox3.SelectedValue);
           
            if (deptId == -1 || positionId == -1)
            {
                MessageBox.Show("部门或职位没有选择！");
                return;
            }
           // MessageBox.Show("部门："   deptId   "职位"   positionId);
            string sql1 = "select * from Dept where Dept_Id=@dept" ;
            DataTable dt = DbHelper.Instance.CreateDataTable(sql1, new SqlParameter("dept", deptId));
           string strDept = Convert.ToString(dt.Rows[0]["Dept_Name"]);
          
           string sql_Position = "select * from Position where Position_Id=@position";
           DataTable dt2 = DbHelper.Instance.CreateDataTable(sql_Position,new SqlParameter("position",positionId));
           string strPosition = Convert.ToString(dt2.Rows[0]["Position_Name"]);
           //MessageBox.Show(strPosition);
           
          // MessageBox.Show("部门："   strDept   "职位"   strPosition);

            //////////////////////////判断工资输入
           if (this.textBox6.Text == string.Empty)
           {
               MessageBox.Show("请输入基本工资！");
               return;
           }
           else
           {
               
               string strsolary = this.textBox1.Text.Trim();//工资
               int m;
               if (int.TryParse(strsolary, out m))  //bool
               {
                   solary = Convert.ToInt32(str);//工资
               }
               else
               {
                   MessageBox.Show("工资输入不正确！");
                   this.textBox6.Text = string.Empty;
                   return;
               }


           }
            //判断员工编号是否重复
           string sql2 = "select Employee_Id from EmployeeInfo";
          DataTable selectId = DbHelper.Instance.CreateDataTable(sql2);
          for (int i = 0; i < selectId.Rows.Count; i  )
          {
              int id = Convert.ToInt32(selectId.Rows[i]["Employee_Id"]);
              
              
              if (Employee_Id1 == id)
              {
                  MessageBox.Show("员工编号已存在，请重新输入！");
                  return;
              }
              
          }
            //各项基本信息
            string Name1 = this.textBox2.Text;//员工姓名
            string BirthDate1 = this.dateTimePicker2.Text;//员工出生日期
            string ID_Number1 = this.textBox4.Text;//员工身份证号
            string Nation1 ;//员工民族
            if (this.textBox5.Text == string.Empty)
            {
                Nation1 = "--";
            }
            else
            {
                 Nation1 = this.textBox5.Text;
            }
            string NativePlace1 = Convert.ToString(this.comboBox1.SelectedItem);
            if (NativePlace1 == string.Empty)
            {
                NativePlace1 = "--";
            }
            else{
                    NativePlace1 = this.comboBox1.SelectedItem.ToString();//籍贯
            }
            string PhoneNumber1 = this.textBox7.Text;//手机号码
            string Address1;//地址
            if (this.textBox8.Text == string.Empty)
            {
                Address1 = "--";
            }
            else
            {
                Address1 = this.textBox8.Text;
            }
            string AttendJobDate1 = this.dateTimePicker2.Text;//入职日期
            string Attach1 = this.textBox9.Text;
            

            string sql = "insert into EmployeeInfo (Employee_Id,Employee_Name,Employee_BirthDate,Employee_ID_Number,Employee_Nation,Employee_NativePlace,Employee_PhoneNumber,Employee_Address,Employee_Dept,Employee_Position,Employee_AttendJobDate,Employee_Attach,Employee_Salary) values (@emId,@emName,@emBirthDate,@emID_Number,@em_Nation,@em_NativePlace,@em_PhoneNumber,@em_Address,@em_Dept,@em_Position,@JobDate,@em_Attach,@em_Salary)";
            DbHelper.Instance.ExecuteNonQuery(sql, new SqlParameter("emId", Employee_Id1), new SqlParameter("emName", Name1), new SqlParameter("emBirthDate", BirthDate1), new SqlParameter("emID_Number", ID_Number1), new SqlParameter("em_Nation", Nation1), new SqlParameter("em_NativePlace", NativePlace1), new SqlParameter("em_PhoneNumber", PhoneNumber1), new SqlParameter("em_Address", Address1), new SqlParameter("em_Dept", strDept), new SqlParameter("em_Position", strPosition), new SqlParameter("JobDate", AttendJobDate1), new SqlParameter("em_attach", Attach1), new SqlParameter("em_Salary", solary));
            MessageBox.Show("添加成功！");
        */
            #endregion
        }
        /// <summary>
        /// 初始化加载员工信息界面
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void EmployeeInfo_Load(object sender, EventArgs e)
        {
            this.panel1.BackColor = Color.Transparent;
            //this.groupBox1.BackColor = Color.Transparent;
         
            #region//部门combox
            this.comboBox2.Items.Clear();
            DataTable userName = new DataTable();
            userName.Columns.Add(new DataColumn("Dept_Id", typeof(int)));
            userName.Columns.Add(new DataColumn("Dept_Name", typeof(string)));

            DataRow dr = userName.NewRow();
            dr["Dept_Id"] = -1;
            dr["Dept_Name"] = "请选择";

            userName.Rows.Add(dr);
            string sql = "select [Dept_Id],[Dept_Name] from Dept";
            DataTable dt = DbHelper.Instance.CreateDataTable(sql);
            userName.Merge(dt);
            this.comboBox2.DataSource = userName;
            this.comboBox2.ValueMember = "Dept_Id";
            this.comboBox2.DisplayMember = "Dept_Name";
            this.comboBox2.DropDownStyle = ComboBoxStyle.DropDownList;
            #endregion
            #region//职位combox
            this.comboBox3.Items.Clear();
            DataTable Position = new DataTable();
            Position.Columns.Add(new DataColumn("Position_Id", typeof(int)));
            Position.Columns.Add(new DataColumn("Position_Name", typeof(string)));

            DataRow dr2 = Position.NewRow();
            dr2["Position_Id"] = -1;
            dr2["Position_Name"] = "请选择";

            Position.Rows.Add(dr2);
            string sql2 = "select [Position_Id],[Position_Name] from Position";
            DataTable dt2 = DbHelper.Instance.CreateDataTable(sql2);
            Position.Merge(dt2);
            this.comboBox3.DataSource = Position;
            this.comboBox3.ValueMember = "Position_Id";
            this.comboBox3.DisplayMember = "Position_Name";
            this.comboBox3.DropDownStyle = ComboBoxStyle.DropDownList;
            #endregion
        }
        
        public void ChangeEmployeeInfo()
        {
            int numberid = 员工资料界面.Number.num;
            string sql = "select * from EmployeeInfo where Employee_Id=@id";
            DataTable dt = DbHelper.Instance.CreateDataTable(sql, new SqlParameter("id", numberid));
            for (int i = 0; i < dt.Rows.Count; i  )
            {
                this.textBox1.ReadOnly = true;
                this.textBox1.Enabled = false;
                string id = Convert.ToString(dt.Rows[i]["Employee_Id"]);
                string name = Convert.ToString(dt.Rows[i]["Employee_Name"]);
                string birthdate = Convert.ToString(dt.Rows[i]["Employee_BirthDate"]);
                string id_number = Convert.ToString(dt.Rows[i]["Employee_ID_Number"]);
                string nation = Convert.ToString(dt.Rows[i]["Employee_Nation"]);
                string nativeplace = Convert.ToString(dt.Rows[i]["Employee_NativePlace"]);
                string phone = Convert.ToString(dt.Rows[i]["Employee_PhoneNumber"]);
                string address = Convert.ToString(dt.Rows[i]["Employee_Address"]);
                string dept = Convert.ToString(dt.Rows[i]["Employee_Dept"]);
                string position = Convert.ToString(dt.Rows[i]["Employee_Position"]);
                string attendjob = Convert.ToString(dt.Rows[i]["Employee_AttendJobDate"]);
                string attach = Convert.ToString(dt.Rows[i]["Employee_Attach"]);
                string salary = Convert.ToString(dt.Rows[i]["Employee_Salary"]);
                this.textBox1.Text = id;
                this.textBox2.Text = name;
                this.dateTimePicker2.Text = birthdate;
                this.textBox4.Text = id_number;
                this.textBox5.Text = nation;
                this.comboBox1.Text = nativeplace;
                this.textBox7.Text = phone;
                this.textBox8.Text = address;
                this.comboBox2.DisplayMember = dept;
              
                this.comboBox3.Text = position;
                this.textBox6.Text = salary;
                this.textBox9.Text = attach;
                this.dateTimePicker1.Text = attendjob;
                
            }
            string nu = this.textBox1.Text;
            CheckOutImg(nu);
            
        }
        private void checkmodify()
        {
            
            int Employee_Id1;//员工编号
            int solary;//员工工资
            string str = this.textBox1.Text.Trim();//员工编号
            Employee_Id1 = Convert.ToInt32(str);
            //int ii;
            //if (int.TryParse(str, out ii))  //bool
            //{
            //    Employee_Id1 = Convert.ToInt32(str);//员工编号
            //}
            //else
            //{
            //    MessageBox.Show("员工编号格式为整数！");
            //    this.textBox1.Text = string.Empty;
            //    return;
            //}
            if (this.textBox2.Text == string.Empty)
            {
                MessageBox.Show("请输入姓名！");
                return;
            }
            else if (this.textBox4.Text == string.Empty)
            {
                MessageBox.Show("请输入身份证号！");
                return;
            }
            else if (this.textBox7.Text == string.Empty)
            {
                MessageBox.Show("请输入手机号！");
                return;
            }


            int deptId = Convert.ToInt32(this.comboBox2.SelectedValue);
            int positionId = Convert.ToInt32(this.comboBox3.SelectedValue);

            if (deptId == -1 || positionId == -1)
            {
                MessageBox.Show("部门或职位没有选择！");
                return;
            }
            // MessageBox.Show("部门："   deptId   "职位"   positionId);
            string sql1 = "select * from Dept where Dept_Id=@dept";
            DataTable dt = DbHelper.Instance.CreateDataTable(sql1, new SqlParameter("dept", deptId));
            string strDept = Convert.ToString(dt.Rows[0]["Dept_Name"]);

            string sql_Position = "select * from Position where Position_Id=@position";
            DataTable dt2 = DbHelper.Instance.CreateDataTable(sql_Position, new SqlParameter("position", positionId));
            string strPosition = Convert.ToString(dt2.Rows[0]["Position_Name"]);
            

          

            //////////////////////////判断工资输入
            if (this.textBox6.Text == string.Empty)
            {
                MessageBox.Show("请输入基本工资！");
                return;
            }
            else
            {

                string strsolary1 = this.textBox6.Text.Trim();//工资
                int m;
                if (int.TryParse(strsolary1, out m))  //bool
                {
                    solary = Convert.ToInt32(strsolary1);//工资
                }
                else
                {
                    MessageBox.Show("工资输入不正确！");
                    this.textBox6.Text = string.Empty;
                    return;
                }


            }
            
            //各项基本信息
            string Name1 = this.textBox2.Text;//员工姓名
            string BirthDate1 = this.dateTimePicker2.Text;//员工出生日期
            string ID_Number1 = this.textBox4.Text;//员工身份证号
            string Nation1;//员工民族
            if (this.textBox5.Text == string.Empty)
            {
                Nation1 = "--";
            }
            else
            {
                Nation1 = this.textBox5.Text;
            }
            string NativePlace1 = Convert.ToString(this.comboBox1.SelectedItem);
            if (NativePlace1 == string.Empty)
            {
                NativePlace1 = "--";
            }
            else
            {
                NativePlace1 = this.comboBox1.SelectedItem.ToString();//籍贯
            }
            string PhoneNumber1 = this.textBox7.Text;//手机号码
            string Address1;//地址
            if (this.textBox8.Text == string.Empty)
            {
                Address1 = "--";
            }
            else
            {
                Address1 = this.textBox8.Text;
            }
            string AttendJobDate1 = this.dateTimePicker2.Text;//入职日期
            string Attach1 = this.textBox9.Text;


            string sql = "update EmployeeInfo set Employee_Id =@emId ,Employee_Name=@emName,Employee_BirthDate=@emBirthDate,Employee_ID_Number=@emID_Number,Employee_Nation=@em_Nation,Employee_NativePlace=@em_NativePlace,Employee_PhoneNumber=@em_PhoneNumber,Employee_Address=@em_Address,Employee_Dept=@em_Dept,Employee_Position=@em_Position,Employee_AttendJobDate=@JobDate,Employee_Attach=@em_Attach,Employee_Salary=@em_Salary where Employee_Id=@newid1";
            DbHelper.Instance.ExecuteNonQuery(sql, new SqlParameter("emId", Employee_Id1), new SqlParameter("emName", Name1), new SqlParameter("emBirthDate", BirthDate1), new SqlParameter("emID_Number", ID_Number1), new SqlParameter("em_Nation", Nation1), new SqlParameter("em_NativePlace", NativePlace1), new SqlParameter("em_PhoneNumber", PhoneNumber1), new SqlParameter("em_Address", Address1), new SqlParameter("em_Dept", strDept), new SqlParameter("em_Position", strPosition), new SqlParameter("JobDate", AttendJobDate1), new SqlParameter("em_attach", Attach1), new SqlParameter("em_Salary", solary), new SqlParameter("newid1", Employee_Id1));
            if (this.pictureBox1.Image == null)
            {
                DeleteImg();
                MessageBox.Show("修改成功！");
            }
            else
            {
                SaveImage();
                MessageBox.Show("修改成功！");
                
            }
            
            
        
        }
        /// <summary>
        /// 增加员工信息方法
        /// </summary>
        private void add()
        {
            int Employee_Id1;//员工编号
            int solary;//员工工资
            string str = this.textBox1.Text.Trim();//员工编号
            int ii;
            if (int.TryParse(str, out ii))  //bool
            {
                Employee_Id1 = Convert.ToInt32(str);//员工编号
            }
            else
            {
                MessageBox.Show("员工编号格式为整数！");
                this.textBox1.Text = string.Empty;
                return;
            }
            if (this.textBox2.Text == string.Empty)
            {
                MessageBox.Show("请输入姓名！");
                return;
            }
            else if (this.textBox4.Text == string.Empty)
            {
                MessageBox.Show("请输入身份证号！");
                return;
            }
            else if (this.textBox7.Text == string.Empty)
            {
                MessageBox.Show("请输入手机号！");
                return;
            }


            int deptId = Convert.ToInt32(this.comboBox2.SelectedValue);
            int positionId = Convert.ToInt32(this.comboBox3.SelectedValue);

            if (deptId == -1 || positionId == -1)
            {
                MessageBox.Show("部门或职位没有选择！");
                return;
            }
            // MessageBox.Show("部门："   deptId   "职位"   positionId);
            string sql1 = "select * from Dept where Dept_Id=@dept";
            DataTable dt = DbHelper.Instance.CreateDataTable(sql1, new SqlParameter("dept", deptId));
            string strDept = Convert.ToString(dt.Rows[0]["Dept_Name"]);

            string sql_Position = "select * from Position where Position_Id=@position";
            DataTable dt2 = DbHelper.Instance.CreateDataTable(sql_Position, new SqlParameter("position", positionId));
            string strPosition = Convert.ToString(dt2.Rows[0]["Position_Name"]);
            //MessageBox.Show(strPosition);

            // MessageBox.Show("部门："   strDept   "职位"   strPosition);

            //////////////////////////判断工资输入
            if (this.textBox6.Text == string.Empty)
            {
                MessageBox.Show("请输入基本工资！");
                return;
            }
            else
            {

                string strsolary = this.textBox6.Text.Trim();//工资
                int m;
                if (int.TryParse(strsolary, out m))  //bool
                {
                    solary = Convert.ToInt32(str);//工资
                }
                else
                {
                    MessageBox.Show("工资输入不正确！");
                    this.textBox6.Text = string.Empty;
                    return;
                }


            }
            //判断员工编号是否重复
            string sql2 = "select Employee_Id from EmployeeInfo";
            DataTable selectId = DbHelper.Instance.CreateDataTable(sql2);
            for (int i = 0; i < selectId.Rows.Count; i  )
            {
                int id = Convert.ToInt32(selectId.Rows[i]["Employee_Id"]);


                if (Employee_Id1 == id)
                {
                    MessageBox.Show("员工编号已存在，请重新输入！");
                    return;
                }

            }
            //各项基本信息
            string Name1 = this.textBox2.Text;//员工姓名
            string BirthDate1 = this.dateTimePicker2.Text;//员工出生日期
            string ID_Number1 = this.textBox4.Text;//员工身份证号
            string Nation1;//员工民族
            if (this.textBox5.Text == string.Empty)
            {
                Nation1 = "--";
            }
            else
            {
                Nation1 = this.textBox5.Text;
            }
            string NativePlace1 = Convert.ToString(this.comboBox1.SelectedItem);
            if (NativePlace1 == string.Empty)
            {
                NativePlace1 = "--";
            }
            else
            {
                NativePlace1 = this.comboBox1.SelectedItem.ToString();//籍贯
            }
            string PhoneNumber1 = this.textBox7.Text;//手机号码
            string Address1;//地址
            if (this.textBox8.Text == string.Empty)
            {
                Address1 = "--";
            }
            else
            {
                Address1 = this.textBox8.Text;
            }
            string AttendJobDate1 = this.dateTimePicker2.Text;//入职日期
            string Attach1 = this.textBox9.Text;
            string Password = this.textBox1.Text.Trim();

            string sql = "insert into EmployeeInfo (Employee_Id,Employee_Name,Employee_BirthDate,Employee_ID_Number,Employee_Nation,Employee_NativePlace,Employee_PhoneNumber,Employee_Address,Employee_Dept,Employee_Position,Employee_AttendJobDate,Employee_Attach,Employee_Salary,Employee_Password) values (@emId,@emName,@emBirthDate,@emID_Number,@em_Nation,@em_NativePlace,@em_PhoneNumber,@em_Address,@em_Dept,@em_Position,@JobDate,@em_Attach,@em_Salary,@em_password)";
            DbHelper.Instance.ExecuteNonQuery(sql, new SqlParameter("emId", Employee_Id1), new SqlParameter("emName", Name1), new SqlParameter("emBirthDate", BirthDate1), new SqlParameter("emID_Number", ID_Number1), new SqlParameter("em_Nation", Nation1), new SqlParameter("em_NativePlace", NativePlace1), new SqlParameter("em_PhoneNumber", PhoneNumber1), new SqlParameter("em_Address", Address1), new SqlParameter("em_Dept", strDept), new SqlParameter("em_Position", strPosition), new SqlParameter("JobDate", AttendJobDate1), new SqlParameter("em_attach", Attach1), new SqlParameter("em_Salary", solary), new SqlParameter("em_password",Password));
            string sql_timetable = "insert into TimeTable(Time_EmployeeId) values (@employeeid)";
            DbHelper.Instance.ExecuteNonQuery(sql_timetable, new SqlParameter("employeeid", Employee_Id1));
            string sql_JiaBan = "insert into Attendance(JiaBanEmployeeId) values (@jiabanid)";
            DbHelper.Instance.ExecuteNonQuery(sql_JiaBan, new SqlParameter("jiabanid", Employee_Id1));
            SaveImage();
            MessageBox.Show("添加成功！");
        }
        /// <summary>
        /// 贴照片
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button1_Click(object sender, EventArgs e)
        {

            if (this.openFileDialog1.ShowDialog() == DialogResult.OK)
            {
                using(FileStream fs = new FileStream(this.openFileDialog1.FileName, FileMode.Open))
                {
                    BinaryReader br = new BinaryReader(fs);
                    photo = br.ReadBytes(Convert.ToInt32(fs.Length));
                    fs.Close();
                    fs.Dispose();

                }
               
                this.pictureBox1.Image = Image.FromFile(openFileDialog1.FileName);
                
            }


        }
        /// <summary>
        /// 存图片
        /// </summary>
        public void SaveImage()
        {
            if (photo == null)
            {
                return;
            }
            else
            {
                string Employee_Id1 = this.textBox1.Text;
                string sql = "update EmployeeInfo set Employee_Photo = @inage where Employee_Id=@idimage";
                DbHelper.Instance.ExecuteNonQuery(sql, new SqlParameter("inage", photo), new SqlParameter("idimage", Employee_Id1));
            }
            
         }
        /// <summary>
        /// 取图片
        /// </summary>
        public void CheckOutImg(string Employee_Id1)
        { 
            //string Employee_Id1 
               //Employee_Id1 = this.textBox1.Text;
            string sql = "select Employee_Photo from EmployeeInfo where Employee_Id=@idimage";
            DataTable dt = DbHelper.Instance.CreateDataTable(sql, new SqlParameter("idimage", Employee_Id1));
            string fs1 = Convert.ToString(dt.Rows[0]["Employee_Photo"]);
            
            if (fs1 == string.Empty)
            {
                return;
            }
            else
            {
                photo = (byte[])dt.Rows[0]["Employee_Photo"];
                using (MemoryStream ms = new MemoryStream(photo))
                {
                    try
                    {
                        this.pictureBox1.Image = Image.FromStream(ms);
                    }
                    catch
                    {

                        MessageBox.Show("读取图片失败!");
                    }

                    ms.Close();
                    ms.Dispose();
                }
            }
        }
        public void DeleteImg()
        {
           
            string num = this.textBox1.Text;
            string sql = string.Format("update EmployeeInfo set Employee_Photo=NULL where Employee_Id=@empid");
            DbHelper.Instance.ExecuteNonQuery(sql,new SqlParameter("empid", num));
        }
        /// <summary>
        /// 删照片按钮
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button2_Click(object sender, EventArgs e)
        {
            this.pictureBox1.Image = null;
        }

        private void button4_Click(object sender, EventArgs e)
        {
            Close();
        }
        Point mouseOff;//鼠标移动位置变量
        bool leftFlag;
        private void EmployeeInfo_MouseDown(object sender, MouseEventArgs e)
        {
            if (e.Button == MouseButtons.Left)
            {
                mouseOff = new Point(-e.X, -e.Y); //得到变量的值
                leftFlag = true;                              //点击左键按下时标注为true;
            }
        }

        private void EmployeeInfo_MouseMove(object sender, MouseEventArgs e)
        {
            if (leftFlag)
            {
                Point mouseSet = Control.MousePosition;
                mouseSet.Offset(mouseOff.X, mouseOff.Y); //设置移动后的位置
                Location = mouseSet;
            }
        }

        private void EmployeeInfo_MouseUp(object sender, MouseEventArgs e)
        {
            if (leftFlag)
            {
                leftFlag = false;//释放鼠标后标注为false;
            }
        }

        private void openFileDialog1_FileOk(object sender, CancelEventArgs e)
        {

        }

        private void groupBox3_Enter(object sender, EventArgs e)
        {

        }

        private void groupBox2_Enter(object sender, EventArgs e)
        {

        }

        private void label17_Click(object sender, EventArgs e)
        {

        }

        private void textBox9_TextChanged(object sender, EventArgs e)
        {

        }

        private void groupBox1_Enter(object sender, EventArgs e)
        {

        }

        private void dateTimePicker2_ValueChanged(object sender, EventArgs e)
        {

        }

        private void dateTimePicker1_ValueChanged(object sender, EventArgs e)
        {

        }

        private void comboBox3_SelectedIndexChanged(object sender, EventArgs e)
        {

        }

        private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)
        {

        }

        private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
        {

        }

        private void label16_Click(object sender, EventArgs e)
        {

        }

        private void textBox8_TextChanged(object sender, EventArgs e)
        {

        }

        private void textBox6_TextChanged(object sender, EventArgs e)
        {

        }

        private void textBox4_TextChanged(object sender, EventArgs e)
        {

        }

        private void textBox7_TextChanged(object sender, EventArgs e)
        {

        }

        private void textBox5_TextChanged(object sender, EventArgs e)
        {

        }

        private void textBox2_TextChanged(object sender, EventArgs e)
        {

        }

        private void textBox1_TextChanged(object sender, EventArgs e)
        {

        }

        private void label15_Click(object sender, EventArgs e)
        {

        }

        private void label12_Click(object sender, EventArgs e)
        {

        }

        private void label13_Click(object sender, EventArgs e)
        {

        }

        private void label11_Click(object sender, EventArgs e)
        {

        }

        private void label10_Click(object sender, EventArgs e)
        {

        }

        private void label9_Click(object sender, EventArgs e)
        {

        }

        private void label8_Click(object sender, EventArgs e)
        {

        }

        private void label7_Click(object sender, EventArgs e)
        {

        }

        private void label6_Click(object sender, EventArgs e)
        {

        }

        private void label5_Click(object sender, EventArgs e)
        {

        }

        private void label4_Click(object sender, EventArgs e)
        {

        }

        private void label3_Click(object sender, EventArgs e)
        {

        }

        private void label2_Click(object sender, EventArgs e)
        {

        }

        private void pictureBox1_Click(object sender, EventArgs e)
        {

        }

        private void panel1_Paint(object sender, PaintEventArgs e)
        {

        }
    }
}