protected override DoWorkResult DoWork(Model_NodeHistoryData pendingValue)
{
try
{
Model_AiInfo aiInfo = CC_HistDataServer.CheckPointIdIsExist(pendingValue.PointId);
if (aiInfo == null)
{
throw new Exception("指定的PointId不存在!");
}
else
{
bool result = CC_HistDataServer.InsertPointData(pendingValue, aiInfo.StorageId);
if (result == false)
{
throw new Exception("插入数据失败!");
}
}
return(DoWorkResult.ContinueThread);
}
catch (Exception ex)
{
throw ex;
//return DoWorkResult.AbortCurrentThread;//有异常,可以终止当前线程.当然.也可以继续,
//return DoWorkResult.AbortAllThread; //特殊情况下 ,有异常终止所有的线程...
}
//return base.DoWork(pendingValue);
}
/// <summary>
/// 修改状态
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tsmDelete_Click(object sender, EventArgs e)
{
try
{
Model_AiInfo mai = dataGridView1.SelectedRows[0].Tag as Model_AiInfo;
mai.Activedk__BackingField = Enum_Active.Disable;
if (MessageBox.Show("是否确定删除", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
ResultModelOfModel_AiInfod4FqxSXX editma = cs.EditAiInfo(mai, true, true);
if (editma.Code != 0)
{
MessageBox.Show(editma.Message);
}
else
{
MessageBox.Show("操作成功，冷库探头已停用");
AillLoad();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
/// <summary>
/// 编辑
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tsmEdit_Click(object sender, EventArgs e)
{
Model_AiInfo mai = dataGridView1.SelectedRows[0].Tag as Model_AiInfo;
FrmProbeEdit eidt = new FrmProbeEdit();
eidt.mai = mai;
eidt._ParentFrm = this;
eidt.ShowDialog();
}
/// <summary>
/// 编辑AI信息
/// pointId为0时表示添加
/// pointId不为0时表示删除或编辑
/// </summary>
/// <param name="aiInfo">AI信息</param>
/// <param name="IsDeleteAi">True:pointID不为0时执行删除操作;False:pointID为0时不删除执行添加操作</param>
/// <returns></returns>
public ResultModel <Model_AiInfo> EditAiInfo(Model_AiInfo aiInfo, bool IsDeleteAi = false)
{
ResultModel <Model_AiInfo> result = new ResultModel <Model_AiInfo>();
try
{
result.Data = AiinFoServer.EditAiInfos(aiInfo, IsDeleteAi);
}
catch (Exception ex)
{
result.Code = 1;
result.Message = ex.Message;
}
return(result);
}
/// <summary>
/// 编辑AI信息
/// </summary>
/// <param name="aiInfo"></param>
/// <param name="IsDeleteAi"></param>
/// <returns></returns>
public static Model_AiInfo EditAiInfos(Model_AiInfo aiInfo, bool IsDeleteAi)
{
string sql = "";
if (aiInfo.PointId == 0 && IsDeleteAi == false)
{
sql = "insert into aiinfo(storageId,pointName,pointType,actived) values(?storageId,?pointName,?pointType,?actived);";
}
else if (aiInfo.PointId != 0 && IsDeleteAi == true)
{
sql = "update aiinfo set storageId=?storageId,pointName=?pointName,pointType=?pointType,actived=?actived where pointId=?pointId ;";
}
MySqlParameter[] para = new MySqlParameter[5];
para[0] = new MySqlParameter("storageId", aiInfo.StorageId);
para[1] = new MySqlParameter("pointName", aiInfo.PpointName);
para[2] = new MySqlParameter("pointType", aiInfo.PointType);
para[3] = new MySqlParameter("actived", aiInfo.Actived);
para[4] = new MySqlParameter("pointId", aiInfo.PointId);
int result = 0;
if (aiInfo.PointId == 0)
{
result = _SqlHelp.ExecuteNonQuery(sql, para);
}
else
{
result = _SqlHelp.ExecuteNonQuery(sql, para);
}
if (result != 1)
{
throw new Exception("操作失败");
}
return(aiInfo);
}
private void button1_Click(object sender, EventArgs e)
{
try
{
if (txtProbeName.Text.Trim() == string.Empty)
{
MessageBox.Show("探头名称不能为空");
return;
}
if (Encoding.Default.GetBytes(txtProbeName.Text.Trim()).Length > 50)
{
MessageBox.Show("探头名称不能超过50");
return;
}
if (cmbProbeType.Text.Trim() == string.Empty)
{
MessageBox.Show("探头类型不能为空");
return;
}
Model_AiInfo ma = new Model_AiInfo();
ma.PointIdk__BackingField = mai.PointIdk__BackingField;
ma.PpointNamek__BackingField = txtProbeName.Text.Trim();
if (cmbProbeType.Text == "温度")
{
ma.PointTypek__BackingField = Enum_PointType.Temp;
}
else if (cmbProbeType.Text == "湿度")
{
ma.PointTypek__BackingField = Enum_PointType.Hump;
}
else if (cmbProbeType.Text == "经度")
{
ma.PointTypek__BackingField = Enum_PointType.Longitude;
}
else if (cmbProbeType.Text == "纬度")
{
ma.PointTypek__BackingField = Enum_PointType.Latitude;
}
if (checkActivation.Checked == true)
{
ma.Activedk__BackingField = Enum_Active.Enabled;
}
else
{
ma.Activedk__BackingField = Enum_Active.Disable;
}
ma.StorageIdk__BackingField = mai.StorageIdk__BackingField;
ResultModelOfModel_AiInfod4FqxSXX edit = cs.EditAiInfo(ma, true, true);
if (edit.Code != 0)
{
MessageBox.Show(edit.Message);
}
else
{
MessageBox.Show("操作成功");
_ParentVMP.getRenew();
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
/// <summary>
/// 添加
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (txtProbeName.Text.Trim() == string.Empty)
{
MessageBox.Show("探头名称不能为空");
return;
}
if (Encoding.Default.GetBytes(txtProbeName.Text.Trim()).Length > 50)
{
MessageBox.Show("探头名称不能超过50");
return;
}
if (cmbProbeType.Text.Trim() == string.Empty)
{
MessageBox.Show("探头类型不能为空");
return;
}
Model_AiInfo aiin = new Model_AiInfo();
aiin.PpointNamek__BackingField = txtProbeName.Text.Trim();
if (cmbProbeType.Text == "温度")
{
aiin.PointTypek__BackingField = Enum_PointType.Temp;
}
else if (cmbProbeType.Text == "湿度")
{
aiin.PointTypek__BackingField = Enum_PointType.Hump;
}
else if (cmbProbeType.Text == "经度")
{
aiin.PointTypek__BackingField = Enum_PointType.Longitude;
}
else if (cmbProbeType.Text == "纬度")
{
aiin.PointTypek__BackingField = Enum_PointType.Latitude;
}
if (checkActivation.Checked == true)
{
aiin.Activedk__BackingField = Enum_Active.Enabled;
}
else
{
aiin.Activedk__BackingField = Enum_Active.Disable;
}
aiin.StorageIdk__BackingField = mcp.StorageIdk__BackingField;
ResultModelOfModel_AiInfod4FqxSXX editaiin = cs.EditAiInfo(aiin, false, true);
if (editaiin.Code != 0)
{
MessageBox.Show(editaiin.Message);
}
else
{
MessageBox.Show("操作成功");
getClear();
AillLoad();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
