异步问题

nebuung nebuung 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区
insert 插入数据有丢包,感觉是线程阻塞的问题,求正确的异步写法


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);
}
}
...全文
评论 16
收藏 已收藏
分享
返回顶部
nebuung
C# 111,129 成员 642,540 内容