17,741
社区成员
发帖
与我相关
我的任务
分享
private 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)
{
SetReadParameters();
coilsBuffer = master.ReadCoils(slaveAddress, startAddress, numberOfPoints);
for (int i = 0; i < 20; i++)
{
bool m = coilsBuffer[i + 1];//线圈状态
if(m == true)
{
SetReadParameters();
registerBuffer = master.ReadHoldingRegisters(slaveAddress, startAddress, numberOfPoints);
string x = registerBuffer[i*2 + 10]+"";
string y = registerBuffer[i*2 + 12] + "";
textBox2.Text = x;
textBox3.Text = y;
string mm = m + "";
conn.Open();
Console.WriteLine(i);
string today = DateTime.Now.ToString("yyyy-MM-dd");
string sql = string.Format("insert into z_01(vultime,opetime,prdate,dpr) values ('{0}','{1}','{2}','{3}')", x,y,today, mm);
MySqlCommand cmd = new MySqlCommand(sql, conn);
cmd.ExecuteNonQuery();
conn.Close();
slaveAddress = byte.Parse("1");
startAddressm = ushort.Parse("0");
textBox1.Text = startAddress + "";
coilsBuffer[i+1] = false;
master.WriteSingleCoilAsync(slaveAddress, startAddressm, coilsBuffer[i+1]);
}
SetMsg(coilsBuffer[i] + " ");
}
SetMsg("\r\n");
}
else
{
MessageBox.Show("请选择功能码!");
}
port.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}