set_emp.cs

铁路电务信号设备维修记录系统 c#+acce

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;

namespace D_Equipment_Mis
{
    public partial class set_emp : Form
    {
        public set_emp()
        {
            InitializeComponent();
        }
        public void ini_workshop()
        {
            string ini_str = "select workshop_name from zd_workshop order by workshop_id";
            OleDbConnection myconn = new OleDbConnection(data.connstr);
            OleDbCommand ini_cmd = new OleDbCommand(ini_str, myconn);
            OleDbDataAdapter ini_da = new OleDbDataAdapter(ini_cmd);
            myconn.Open();
            DataSet ini_ds = new DataSet();
            ini_da.Fill(ini_ds);
            if (ini_ds.Tables[0].Rows.Count == 0)
            {
                MessageBox.Show("没有车间数据，请先进行车间数据的维护!");
                return;
            }
            else
            {
                OleDbDataReader ini_read = ini_cmd.ExecuteReader();
                cbo_cj.Items.Clear();
                cbo_cj.Items.Add("");
                while (ini_read.Read())
                    cbo_cj.Items.Add(ini_read["workshop_name"].ToString());
            }
        }

        public void ini_gq(string cj_name)
        {
            string ini_str = "select group_name from zd_workgroup where workshop_name like @iworkshop_name order by workshop_name,group_id";
            OleDbConnection myconn = new OleDbConnection(data.connstr);
            OleDbCommand ini_cmd = new OleDbCommand(ini_str, myconn);
            ini_cmd.Parameters.Add("iworkshop_name", OleDbType.VarChar).Value = "%" + cj_name + "%";
            OleDbDataAdapter ini_da = new OleDbDataAdapter(ini_cmd);
            myconn.Open();
            DataSet ini_ds = new DataSet();
            ini_da.Fill(ini_ds);
            if (ini_ds.Tables[0].Rows.Count == 0)
            {
                MessageBox.Show("没有车间数据，请先进行车间数据的维护!");
                return;
            }
            else
            {
                OleDbDataReader ini_read = ini_cmd.ExecuteReader();
                cbo_gq.Items.Clear();
                cbo_gq.Items.Add("");
                while (ini_read.Read())
                    cbo_gq.Items.Add(ini_read["group_name"].ToString());
            }
        }

        public void ini_emp(string cj_name, string gq_name)
        {
            string ini_str = "";
            ini_str = ini_str + " select workshop_name as 车间名称,group_name as 工区名称,emp_num as 工号,emp_name as 姓名 from zd_emp ";
            ini_str = ini_str + " where workshop_name like @iworkshop_name and group_name like @igroup_name ";
            ini_str = ini_str + " order by workshop_name,group_name,emp_id";
            OleDbConnection myconn = new OleDbConnection(data.connstr);
            OleDbCommand ini_cmd = new OleDbCommand(ini_str, myconn);
            ini_cmd.Parameters.Add("iworkshop_name", OleDbType.VarChar).Value = "%" + cj_name + "%";
            ini_cmd.Parameters.Add("igroup_name", OleDbType.VarChar).Value = "%" + gq_name + "%";
            OleDbDataAdapter ini_da = new OleDbDataAdapter(ini_cmd);
            myconn.Open();
            DataSet ini_ds = new DataSet();
            ini_da.Fill(ini_ds);
            if (ini_ds.Tables[0].Rows.Count == 0)
            {
                DataTable mytable = new DataTable();
                mytable.Columns.Add("车间名称");
                mytable.Columns.Add("工区名称");
                mytable.Columns.Add("工号");
                mytable.Columns.Add("姓名");
                mytable.Rows.Add(mytable.NewRow());
                dataGridView1.DataSource = mytable.DefaultView;            
            }
            else
            {
                dataGridView1.DataSource = ini_ds.Tables[0].DefaultView;
            }

        }

        private void set_emp_Load(object sender, EventArgs e)
        {
            ini_workshop();
            ini_gq("");
            ini_emp("", "");
        }

        private void cbo_cj_SelectedIndexChanged(object sender, EventArgs e)
        {
            cbo_gq.Text = "";
            ini_gq(cbo_cj.Text);
            ini_emp(cbo_cj.Text, cbo_gq.Text);
        }

        private void cbo_gq_SelectedIndexChanged(object sender, EventArgs e)
        {
            ini_emp(cbo_cj.Text, cbo_gq.Text);
        }

        private void button1_Click(object sender, EventArgs e)
        {
            if (cbo_cj.Text == "" || cbo_gq.Text == "" || tb_id.Text.Trim() == "" || tb_name.Text.Trim() == "")
            {
                MessageBox.Show("请输入完整信息!");
                cbo_cj.Focus();
                return;
            }
            else
            {
                string ck_str = "select * from zd_emp where emp_num=@iemp_num";
                OleDbConnection myconn = new OleDbConnection(data.connstr);
                OleDbCommand ck_cmd = new OleDbCommand(ck_str, myconn);
                ck_cmd.Parameters.Add("iemp_num", OleDbType.VarChar).Value = tb_id.Text.Trim();
                OleDbDataAdapter ck_da = new OleDbDataAdapter(ck_cmd);
                myconn.Open();
                DataSet ck_ds = new DataSet();
                ck_da.Fill(ck_ds);
                if (ck_ds.Tables[0].Rows.Count == 0)
                {
                    myconn.Close();
                    string ins_str = "";
                    ins_str = ins_str + " insert into zd_emp (emp_num,emp_name,workshop_name,group_name)";
                    ins_str = ins_str + " values(@iemp_num,@iemp_name,@iworkshop_name,@igroup_name)";
                    OleDbCommand ins_cmd = new OleDbCommand(ins_str, myconn);
                    ins_cmd.Parameters.Add("iemp_num", OleDbType.VarChar).Value = tb_id.Text.Trim();
                    ins_cmd.Parameters.Add("iemp_name", OleDbType.VarChar).Value = tb_name.Text.Trim();
                    ins_cmd.Parameters.Add("iworkshop_name", OleDbType.VarChar).Value = cbo_cj.Text;
                    ins_cmd.Parameters.Add("igroup_name", OleDbType.VarChar).Value = cbo_gq.Text;
                    try
                    {
                        myconn.Open();
                        if ((int)ins_cmd.ExecuteNonQuery()==1)
                        {
                            MessageBox.Show("保存成功!");
                            ini_emp(cbo_cj.Text,cbo_gq.Text);
                        }
                    }
                    catch(Exception t)
                    {
                        MessageBox.Show(t.ToString());
                    }
                }
                else
                {
                    MessageBox.Show("工号重复,请重新输入!");
                    tb_id.SelectAll();
                    tb_id.Focus();
                }
                
            }
        }

        private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
        {
            int rows = Convert.ToInt32(dataGridView1.CurrentRow.Index);
            string gp_name = dataGridView1.Rows[rows].Cells[0].Value.ToString();
            string cj_name = dataGridView1.Rows[rows].Cells[1].Value.ToString();
            string emp_num = dataGridView1.Rows[rows].Cells[2].Value.ToString();
            string emp_name = dataGridView1.Rows[rows].Cells[3].Value.ToString();
            string q_str = gp_name + "\n" + cj_name + "\n" + emp_num + "\n" + emp_name;
            if (MessageBox.Show("您确定要删除\n" + q_str + "吗?", "删除员工", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
            {
                string del_str = "delete from zd_emp where emp_num=@iemp_num";
                OleDbConnection myconn = new OleDbConnection(data.connstr);
                OleDbCommand del_cmd = new OleDbCommand(del_str, myconn);
                del_cmd.Parameters.Add("iemp_num", OleDbType.VarChar).Value = emp_num;
                try
                {
                    myconn.Open();
                    if ((int)del_cmd.ExecuteNonQuery() == 1)
                    {
                        MessageBox.Show("删除成功");
                        ini_emp(cbo_cj.Text, cbo_gq.Text);
                    }
                    else
                    {
                        MessageBox.Show("删除失败,请尝试重新启动程序!");
                    }
                }
                catch (Exception t)
                {
                    MessageBox.Show(t.ToString());
                }

            }
        }

        private void button2_Click(object sender, EventArgs e)
        {
            Close();
        }
    }
}