set_gq.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_gq : Form
    {
        public set_gq()
        {
            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 as 工区名称,workshop_name as 车间名称 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)
            {
                DataTable mytable = new DataTable();
                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_gq_Load(object sender, EventArgs e)
        {
            ini_workshop();
            ini_gq("");
        }

        private void button1_Click(object sender, EventArgs e)
        {
            if (cbo_cj.Text.Trim() == "" || tb_gq.Text.Trim() == "")
            {
                MessageBox.Show("请输入完整信息");
                cbo_cj.Focus();
            }
            else
            {
                OleDbConnection myconn = new OleDbConnection(data.connstr);
                string ck_str = "select * from zd_workgroup where group_name=@igroup_name and workshop_name=@iworkshop_name";
                OleDbCommand ck_cmd = new OleDbCommand(ck_str, myconn);
                ck_cmd.Parameters.Add("igroup_name", OleDbType.VarChar).Value = tb_gq.Text.Trim();
                ck_cmd.Parameters.Add("iworkshop_name", OleDbType.VarChar).Value = cbo_cj.Text;
                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 = "insert into zd_workgroup(group_name,workshop_name) values(@igroup_name,@iworkshop_name)";
                    OleDbCommand ins_cmd = new OleDbCommand(ins_str, myconn);
                    ins_cmd.Parameters.Add("igroup_name", OleDbType.VarChar).Value = tb_gq.Text.Trim();
                    ins_cmd.Parameters.Add("iworkshop_name", OleDbType.VarChar).Value = cbo_cj.Text;
                    try
                    {
                        myconn.Open();
                        if ((int)ins_cmd.ExecuteNonQuery() == 1)
                        {
                            MessageBox.Show("保存成功!");
                            ini_gq(cbo_cj.Text);
                        }
                        else
                            MessageBox.Show("保存失败,请尝试重新启动程序!");
                    }
                    catch (Exception t)
                    {
                        MessageBox.Show(t.ToString());
                    }
                }
                else
                {
                    MessageBox.Show("同一车间,有重复名字的工区,请重新输入!");
                    tb_gq.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();
            if (MessageBox.Show("您确定要删除'" + cj_name + "-" + gp_name + "'吗?", "删除工区", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
            {
                string del_str = "delete from zd_workgroup where group_name=@igroupname and workshop_name=@iworkshop";
                OleDbConnection myconn = new OleDbConnection(data.connstr);
                OleDbCommand del_cmd = new OleDbCommand(del_str, myconn);
                del_cmd.Parameters.Add("igroupname", OleDbType.VarChar).Value = gp_name;
                del_cmd.Parameters.Add("iworkshop", OleDbType.VarChar).Value = cj_name;
                try
                {
                    myconn.Open();
                    if ((int)del_cmd.ExecuteNonQuery() == 1)
                    {
                        MessageBox.Show("删除成功");
                        ini_gq(cbo_cj.Text);
                    }
                    else
                    {
                        MessageBox.Show("删除失败,请尝试重新启动程序!");
                    }
                }
                catch (Exception t)
                {
                    MessageBox.Show(t.ToString());
                }
            }
        }

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

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