set_button.cs

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

                    dr[1] = byteData[5].ToString("X").PadLeft(2, Convert.ToChar("0")) + byteData[6].ToString("X").PadLeft(2, Convert.ToChar("0")) + byteData[7].ToString("X").PadLeft(2, Convert.ToChar("0")) + byteData[8].ToString("X").PadLeft(2, Convert.ToChar("0"));
                    dataTable.Rows.Add(dr);


                    byteSend[0] = 0x00;
                }
            }
            catch (Exception ex)
            {
                sError = ex.Message;
            }
            finally
            {
                if (serialPort1.IsOpen)
                {
                    serialPort1.Close();
                }
            }

            return sError;
        }

        private byte[] GetNowBCD()
        {
            byte[] byteReTimes = new byte[5];
            int sj = 0;
            DateTime dtTemp = DateTime.Now;

            sj = dtTemp.Minute / 10;
            byteReTimes[0] = Convert.ToByte(sj * 16 + dtTemp.Minute - sj * 10);
            sj = dtTemp.Hour / 10;
            byteReTimes[1] = Convert.ToByte(sj * 16 + dtTemp.Hour - sj * 10);
            sj = dtTemp.Day / 10;
            byteReTimes[2] = Convert.ToByte(sj * 16 + dtTemp.Day - sj * 10);
            sj = dtTemp.Month / 10;
            byteReTimes[3] = Convert.ToByte(sj * 16 + dtTemp.Month - sj * 10);
            sj = Convert.ToInt32(dtTemp.Year.ToString().Substring(2, 2)) / 10;
            byteReTimes[4] = Convert.ToByte(sj * 16 + Convert.ToInt32(dtTemp.Year.ToString().Substring(2, 2)) - sj * 10);
            return byteReTimes;
        }

        private void set_button_Load(object sender, EventArgs e)
        {
            lb_button.Items.Clear();
            ini_workshop();
            ini_gq("");
            ini_e();
            ini_data("", "", "");
        }

        private void button1_Click(object sender, EventArgs e)
        {
            lb_button.Items.Clear();
            string com = get_port();
            if (com == "")
            {
                MessageBox.Show("请进行端口设置");
                return;
            }
            DataTable mytable = new DataTable();
            string mystr;
            try
            {
                mystr = ReadData(com, true, out mystr, out mytable);
                if (mytable.Rows.Count == 0)
                {
                    MessageBox.Show("记忆棒内没有信息钮数据,请重新读取信息钮,然后再试!");
                    return;
                }
                else
                {
                    for (int i = 0; i <= mytable.Rows.Count - 1; i++)
                    {
                        if (lb_button.Items.Count == 0)
                            lb_button.Items.Add(mytable.Rows[i][1].ToString());
                        else
                        {
                            if (!(lb_button.Items.Contains(mytable.Rows[i][1].ToString())))
                                lb_button.Items.Add(mytable.Rows[i][1].ToString());
                        }
                    }
                }
            }
            finally { }
        }

        private void button6_Click(object sender, EventArgs e)
        {
            lb_button.Items.Clear();
        }

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

        private void cbo_sel_cj_SelectedIndexChanged(object sender, EventArgs e)
        {
            ini_gq(cbo_sel_cj.Text);
            cbo_cj.SelectedIndex = cbo_sel_cj.SelectedIndex;
        }

        private void lb_button_Click(object sender, EventArgs e)
        {
            //有一个异常,需要改进!
            if (lb_button.Items.Count > 0)
            {                
                try
                {
                    if (lb_button.Items[lb_button.SelectedIndex].ToString() != "")
                        tb_button_id.Text = lb_button.Items[lb_button.SelectedIndex].ToString();
                }
                catch (Exception t)
                {
                    MessageBox.Show(t.ToString());
                }
                finally { }

            }
        }

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

        private void button4_Click(object sender, EventArgs e)
        {
            ini_data(cbo_sel_cj.Text, cbo_sel_gq.Text, cbo_sel_e.Text);
        }

        private void button2_Click(object sender, EventArgs e)
        {
            string cj_name = cbo_cj.Text;
            string gq_name = cbo_gq.Text;
            string e_name = cbo_e.Text;
            string button_id = tb_button_id.Text.Trim();
            if (cj_name == "" || gq_name == "" || e_name == "" || button_id == "")
            {
                MessageBox.Show("请输入完整的信息!");
                return;
            }
            string ck_str = "select button_id from zd_button where button_id=@ibutton_id";
            OleDbConnection myconn = new OleDbConnection(data.connstr);
            OleDbCommand ck_cmd = new OleDbCommand(ck_str, myconn);
            ck_cmd.Parameters.Add("ibutton_id", OleDbType.VarChar).Value = button_id;
            OleDbDataAdapter ck_da = new OleDbDataAdapter(ck_cmd);
            try
            {
                myconn.Open();
                DataSet ck_ds = new DataSet();
                ck_da.Fill(ck_ds);
                if (ck_ds.Tables[0].Rows.Count != 0)
                {
                    if (MessageBox.Show("此信息钮数据已经存在,是否覆盖?", "信息钮设置", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                    {
                        myconn.Close();
                        string up_str = "update zd_button set e_name = @ie_name, workshop_name = @iworkshop_name ,group_name=@igroupname where button_id=@ibutton_name";
                        OleDbCommand up_cmd = new OleDbCommand(up_str, myconn);
                        up_cmd.Parameters.Add("ie_name", OleDbType.VarChar).Value = e_name;
                        up_cmd.Parameters.Add("iworkshop_name", OleDbType.VarChar).Value = cj_name;
                        up_cmd.Parameters.Add("igroup_name", OleDbType.VarChar).Value = gq_name;
                        up_cmd.Parameters.Add("ibutton_id", OleDbType.VarChar).Value = button_id;
                        try
                        {
                            myconn.Open();
                            if ((int)up_cmd.ExecuteNonQuery() == 1)
                            {
                                MessageBox.Show("保存成功");
                                ini_data(cj_name, gq_name, "");
                                for (int k = 0; k <= lb_button.Items.Count - 1; k++)
                                {
                                    if (tb_button_id.Text.Trim() == lb_button.Items[k].ToString())
                                        lb_button.Items.Remove(tb_button_id.Text.Trim());
                                }
                            }                            
                        }
                        catch (Exception t)
                        {
                            MessageBox.Show(t.ToString());
                            return;
                        }
                    }
                }
                else
                {
                    myconn.Close();
                    string ins_str = "insert into zd_button(button_id,workshop_name,group_name,e_name) values(@ibutton_id,@iworkshop_name,@igroup_name,@ie_name)";
                    OleDbCommand ins_cmd = new OleDbCommand(ins_str, myconn);
                    ins_cmd.Parameters.Add("ibutton_id", OleDbType.VarChar).Value = button_id;                    
                    ins_cmd.Parameters.Add("iworkshop_name", OleDbType.VarChar).Value = cj_name;
                    ins_cmd.Parameters.Add("igroup_name", OleDbType.VarChar).Value = gq_name;
                    ins_cmd.Parameters.Add("ie_name", OleDbType.VarChar).Value = e_name;
                    
                    try
                    {
                        myconn.Open();
                        if ((int)ins_cmd.ExecuteNonQuery() == 1)
                        {
                            MessageBox.Show("保存成功");
                            ini_data(cj_name, gq_name, "");
                            for (int k = 0; k <= lb_button.Items.Count - 1; k++)
                            {
                                if (tb_button_id.Text.Trim() == lb_button.Items[k].ToString())
                                    lb_button.Items.Remove(tb_button_id.Text.Trim());
                            }
                        }
                    }
                    catch (Exception t)
                    {
                        MessageBox.Show(t.ToString());
                        return;
                    }
                }
            }
            catch (Exception t)
            {
                MessageBox.Show(t.ToString());
            }
            myconn.Close();
        }

        private void grid_e_list_Click(object sender, EventArgs e)
        {
            int rows = grid_e_list.CurrentRow.Index;
            string button_id = grid_e_list.Rows[rows].Cells[0].Value.ToString();
            tb_button_id.Text = button_id;
        }

        private void grid_e_list_DoubleClick(object sender, EventArgs e)
        {
            int rows = grid_e_list.CurrentRow.Index;
            string button_id = grid_e_list.Rows[rows].Cells[0].Value.ToString();
            if (MessageBox.Show("您确定要删除" + button_id + "的信息钮吗?", "删除信息钮数据", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
            {
                string del_str = "delete from zd_button where button_id=@ibutton_id";
                OleDbConnection myconn = new OleDbConnection(data.connstr);
                OleDbCommand del_cmd = new OleDbCommand(del_str, myconn);
                del_cmd.Parameters.Add("ibutton_id", OleDbType.VarChar).Value = button_id;
                try
                {
                    myconn.Open();
                    if ((int)del_cmd.ExecuteNonQuery() == 1)
                    {
                        MessageBox.Show("删除成功");
                        ini_data(cbo_cj.Text, cbo_gq.Text, "");
                    }
                }
                catch (Exception t)
                {
                    MessageBox.Show(t.ToString());
                }
            }
        }
    }
}