private void btnDelCommands_Click(object sender, EventArgs e)
{
string sql = string.Format(@"select t.StationID from PandaDTU t where t.终端登录号码='{0}'", this.textTel.Text.Trim());
string stationID = DBUtil.ExecuteScalar(sql, out string errMsg).ToString();
if (!string.IsNullOrEmpty(errMsg))
{
ShowMessageAndAddLog(errMsg);
return;
}
if (string.IsNullOrEmpty(stationID))
{
ShowMessageAndAddLog("未查询到电话号码为" + this.textTel.Text + "的记录");
return;
}
//不能删除服务正在执行的任务
string delSQL = string.Format(@"delete PandaCommand where sensorID in (
select t.sensorID from PandaCommand t
left join Sensor tt on tt.ID=t.sensorID
where tt.StationID='{0}' and t.status in ('未完成','任务成功','任务失败','任务超时'))", stationID);
int rows = DBUtil.ExecuteNonQuery(delSQL, out errMsg);
if (rows >= 0 && errMsg == "")
{
ShowMessageAndAddLog(string.Format("已成功删除{0}张操作票", rows.ToString()));
LoadCommandsDetail();
}
else
{
ShowMessageAndAddLog("操作票删除失败");
}
}
private void btn_creatSomeCommands_Click(object sender, EventArgs e)
{
string sql = string.Format(@"select t.StationID from PandaDTU t where t.终端登录号码='{0}'", this.textTel.Text.Trim());
string stationID = DBUtil.ExecuteScalar(sql, out string errMsg).ToString();
if (!string.IsNullOrEmpty(errMsg))
{
ShowMessageAndAddLog(errMsg);
return;
}
if (string.IsNullOrEmpty(stationID))
{
ShowMessageAndAddLog("未查询到电话号码为" + this.textTel.Text + "的记录");
return;
}
string insertSQL = "";
for (int i = 1; i <= (int)this.numeric_read.Value; i++)
{
insertSQL += string.Format("INSERT INTO PandaCommand (type, sensorID,status) VALUES ( '读','{0}','未完成');", i.ToString() + "-" + stationID);
}
for (int i = 1; i <= (int)this.numeric_write.Value; i++)
{
insertSQL += string.Format("INSERT INTO PandaCommand (type, sensorID,sensorValue,status) VALUES ( '写','{0}',{1}, '未完成');", i.ToString() + "-" + stationID, i);
}
int rows = DBUtil.ExecuteNonQuery(insertSQL, out errMsg);
if (rows > 0 && errMsg == "")
{
ShowMessageAndAddLog(string.Format("已成功生成【{0}】张读操作票和【{1}】张写操作票",
this.numeric_read.Value.ToString(), this.numeric_write.Value.ToString()), MessageBoxIcon.Information);
LoadCommandsDetail();
}
else
{
ShowMessageAndAddLog("操作票生成失败");
}
}