private void button1_Click(object sender, EventArgs e)

        {

            try

            {

                //初始化串口参数

                InitSerialPortParameter();

                master = ModbusSerialMaster.CreateRtu(port);

                ExecuteFunction();

            }

            catch (Exception)

            {

                MessageBox.Show("初始化异常");

            }

        }



        private async void ExecuteFunction()

        {

            String connetStr = "server=10.10.20.5;port=3309;user=root;password=rootqsr; database=db_qualitymanager;";

            MySqlConnection conn = new MySqlConnection(connetStr);

            try

            {

                if (port.IsOpen == false)

                {

                    port.Open();

                }

                if (functionCode != null)

                {

                    switch (functionCode)

                    {

                        case "01 Read Coils"://读取单个线圈

                            //读取线圈

                            slaveAddress = byte.Parse("1");

                            startAddress = ushort.Parse("0");

                            numberOfPoints = ushort.Parse("20");

                            coilsBuffer = master.ReadCoils(slaveAddress, startAddress, numberOfPoints);

                            for (int i = 0; i < coilsBuffer.Length; i++)

                            {

                                bool m = coilsBuffer[i];//线圈状态

                                if (m == true)

                                #region

                                {

                                    //读取寄存器

                                    int j = i * 4 + 6;

                                    startAddress1 = ushort.Parse(j+"");

                                    numberOfPoints1 = ushort.Parse("3");

                                    registerBuffer = master.ReadHoldingRegisters(slaveAddress, startAddress1, numberOfPoints1);

                                    string x = registerBuffer[0] + "";

                                    string y = registerBuffer[2] + "";

                                    if(x == "0")

                                    {

                                        continue;

                                    }

                                    else

                                    {

                                        if (i < 10)

                                        {

                                            string dpr = "z_0" + i;

                                            conn.Open();

                                            string today = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");

                                            string sql = string.Format("insert into "+ dpr +"(vultime,opetime,prdate) values ('{0}','{1}','{2}')", x, y, today);

                                            MySqlCommand cmd = new MySqlCommand(sql, conn);

                                            cmd.ExecuteNonQuery();

                                            conn.Close();



                                            //修改寄存器

                                            string s = j + "";

                                            startAddress = ushort.Parse(s);

                                            string[] strarr = { "0" };

                                            registerBuffer[0] = ushort.Parse(strarr[0]);

                                            await master.WriteSingleRegisterAsync(slaveAddress, startAddress, registerBuffer[0]);

                                        }

                                        else

                                        {

                                            string dpr = "z_" + i;

                                            conn.Open();

                                            string today = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");

                                            string sql = string.Format("insert into " + dpr + " (vultime,opetime,prdate) values ('{0}','{1}','{2}')", x, y, today);

                                            MySqlCommand cmd = new MySqlCommand(sql, conn);

                                            cmd.ExecuteNonQuery();

                                            conn.Close();



                                            //修改寄存器

                                            string s = j + "";

                                            startAddress = ushort.Parse(s);

                                            string[] strarr = { "0" };

                                            registerBuffer[0] = ushort.Parse(strarr[0]);

                                            await master.WriteSingleRegisterAsync(slaveAddress, startAddress, registerBuffer[0]);

                                        }



                                    }

                                    #endregion



                                }

                                //SetMsg(coilsBuffer[i] + " ");

                            }

                            //SetMsg("\r\n");



                            break;             

                    }



                }

                else

                {

                    MessageBox.Show("请选择功能码!");

                }

                port.Close();

            }

            catch (Exception ex)

            {



                MessageBox.Show(ex.Message);

            }

        }