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); } }