set_equipment.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_equipment : Form
    {
        public set_equipment()
        {
            InitializeComponent();
        }

        public void ini_data()
        {
            string ini_str = "select e_name as 设备名称 from zd_equipment order by e_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)
            {
                DataTable mytable = new DataTable();
                mytable.Columns.Add("设备名称");
                mytable.Rows.Add(mytable.NewRow());
                dataGridView1.DataSource = mytable.DefaultView;
            }
            else
            {
                dataGridView1.DataSource = ini_ds.Tables[0].DefaultView;
            }
        }


        private void set_equipment_Load(object sender, EventArgs e)
        {
            ini_data();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            if (TB_e.Text.Trim() == "")
            {
                MessageBox.Show("请输入设备名称");
                TB_e.Focus();
                return;
            }
            string ck_str = "select * from zd_equipment where e_name=@ie_name";
            OleDbConnection myconn = new OleDbConnection(data.connstr);
            OleDbCommand ck_cmd = new OleDbCommand(ck_str, myconn);
            ck_cmd.Parameters.Add("ie_name", OleDbType.VarChar).Value = TB_e.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 = "insert into zd_equipment(e_name) values (@ie_name)";
                OleDbCommand ins_cmd = new OleDbCommand(ins_str,myconn);
                ins_cmd.Parameters.Add("ie_name", OleDbType.VarChar).Value = TB_e.Text.Trim();
                try
                {
                    myconn.Open();
                    if ((int)ins_cmd.ExecuteNonQuery() == 1)
                    {
                        MessageBox.Show("保存成功!");
                        ini_data();
                    }
                }
                catch (Exception t)
                {
                    MessageBox.Show(t.ToString());
                }
            }
            else
            {
                MessageBox.Show("有相同名称的设备,请重新输入");
                TB_e.SelectAll();
                TB_e.Focus();
            }

        }

        private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
        {
            int rows = Convert.ToInt32(dataGridView1.CurrentRow.Index);
            string e_name = dataGridView1.Rows[rows].Cells[0].Value.ToString();
            if (MessageBox.Show("您确定要删除\n" + e_name + "吗?", "删除工区", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
            {
                string del_str = "delete from zd_equipment where e_name=@ie_name";
                OleDbConnection myconn = new OleDbConnection(data.connstr);
                OleDbCommand del_cmd = new OleDbCommand(del_str, myconn);
                del_cmd.Parameters.Add("ie_name", OleDbType.VarChar).Value = e_name;
                try
                {
                    myconn.Open();
                    if ((int)del_cmd.ExecuteNonQuery() == 1)
                    {
                        MessageBox.Show("保存成功");
                        ini_data();
                    }
                }
                catch (Exception t)
                {
                    MessageBox.Show(t.ToString());
                }
            }
        }

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