set_workshop.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_workshop : Form
    {
        public set_workshop()
        {
            InitializeComponent();
        }
        //-----------------------单机版只能有一个车间
        //是以车间为单位进行设计的。
        /*public void ini_data()
        {
            OleDbConnection myconn = new OleDbConnection(data.connstr);
            string ini_str = "select workshop_name as 车间名称 from zd_workshop order by workshop_id";
            OleDbCommand ini_cmd = new OleDbCommand(ini_str, myconn);
            OleDbDataAdapter ini_da = new OleDbDataAdapter(ini_cmd);
            try
            {
                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;
                }
            }
            catch (Exception t)
            {
                MessageBox.Show(t.ToString());
            }
        }*/


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

        private void button1_Click(object sender, EventArgs e)
        {
            //string ck_workshop_str = "select workshop_name from zd_workshop where workshop_name=@iworkshop_name";
            string del_str = "delete from zd_workshop";
            OleDbConnection myconn = new OleDbConnection(data.connstr);
            OleDbCommand del_cmd = new OleDbCommand(del_str, myconn);
            //del_cmd.Parameters.Add("iworkshop_name", OleDbType.VarChar).Value = workshop_name;
            try
            {
                myconn.Open();
                del_cmd.ExecuteNonQuery();    
            }
            catch (Exception t)
            {
                MessageBox.Show(t.ToString());
            }
            myconn.Close();
            string ins_workshop_str = "insert into zd_workshop (workshop_name) values (@iworkshop_name)";
            //OleDbConnection myconn = new OleDbConnection(data.connstr);
            //OleDbCommand ck_workshop_cmd = new OleDbCommand(ck_workshop_str, myconn);
            //ck_workshop_cmd.Parameters.Add("iworkshop_name", OleDbType.VarChar).Value = TB_workshop.Text.Trim();
            //OleDbDataAdapter ck_workshop_da = new OleDbDataAdapter(ck_workshop_cmd);
            //try
            //{
               // myconn.Open();
                //DataSet ck_workshop_ds = new DataSet();
                //ck_workshop_da.Fill(ck_workshop_ds);
                //if (ck_workshop_ds.Tables[0].Rows.Count == 0)
                //{
                    //myconn.Close();
                    OleDbCommand ins_workshop_cmd = new OleDbCommand(ins_workshop_str, myconn);
                    ins_workshop_cmd.Parameters.Add("iworkshop_name", OleDbType.VarChar).Value = TB_workshop.Text.Trim();
                    try
                    {
                        myconn.Open();
                        if ((int)ins_workshop_cmd.ExecuteNonQuery() == 1)
                        {
                            MessageBox.Show("保存成功");
                            //ini_data();
                        }
                        else
                            MessageBox.Show("保存失败，请重新启动程序!");
                        myconn.Close();
                    }
                    catch (Exception t)
                    {
                        MessageBox.Show(t.ToString());
                    }
                //}
                //else
                //{
                 //   MessageBox.Show("车间名称有重复，请重新输入!");
                  //  TB_workshop.Focus();
               // }
            //}
        }

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


        /*private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
        {
            int rows = Convert.ToInt32(dataGridView1.CurrentRow.Index);
            string workshop_name = dataGridView1.Rows[rows].Cells[0].Value.ToString().Trim();
            if (MessageBox.Show("您确定要删除'"+workshop_name+"'吗？", "删除车间", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
            {
                string del_str = "delete from zd_workshop where workshop_name=@iworkshop_name";
                OleDbConnection myconn = new OleDbConnection(data.connstr);
                OleDbCommand del_cmd = new OleDbCommand(del_str, myconn);
                del_cmd.Parameters.Add("iworkshop_name", OleDbType.VarChar).Value = workshop_name;
                try
                {
                    myconn.Open();
                    if ((int)del_cmd.ExecuteNonQuery() == 1)
                    {
                        MessageBox.Show("删除成功!");
                        ini_data();
                    }
                    else
                    {
                        MessageBox.Show("删除失败，请尝试重新启动程序");
                    }
                }
                catch (Exception t)
                {
                    MessageBox.Show(t.ToString());
                }
            }
            
        }*/
    }
}