//增加遥信点位 private void bt_yxadd_Click(object sender, EventArgs e) { Log.WriteLog("新增遥信"); try { if ((m_obj.equtype.ToString()).StartsWith("P_")) { Yx_cfg yxcfg = new Yx_cfg(); yxcfg.IsError = 0; yxcfg.AreaID = (int)cb_yxarea.SelectedValue; yxcfg.Order = Byxlist.Count; yxcfg.EquID = m_obj.equ.EquID; string sql = InsertYXcfg(yxcfg); Log.WriteLog("新增遥信语句生成完成"); int i = DBHelper.ExcuteSql(sql); Log.WriteLog("新增遥信执行完毕"); if (i > -1) { yxcfg.ID = i; Byxlist.Add(yxcfg); } Log.WriteLog("新增遥信并添加到列表完毕"); } } catch (Exception ee) { Log.WriteLog("新增遥信错误:" + ee.Message); } }
//增加遥信点位 private void bt_yxadd_Click(object sender, EventArgs e) { try { if ((m_obj.equtype.ToString()).StartsWith("P_")) { if (cb_yxarea.SelectedItem == null) { MessageBox.Show("请选择分区"); return; } Yx_cfg yxcfg = new Yx_cfg(); yxcfg.IsError = 0; yxcfg.AreaID = (int)cb_yxarea.SelectedValue; yxcfg.Order = Byxlist.Count; yxcfg.EquID = m_obj.equ.EquID; string sql = InsertYXcfg(yxcfg); int i = DBHelper.ExcuteSql(sql); if (i > -1) { yxcfg.ID = i; Byxlist.Add(yxcfg); } } } catch (Exception ee) { gMain.log.WriteLog("新增遥信错误:" + ee.Message); } }
//修改遥信点位 private void dataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e) { try { if (cb_yxarea.SelectedItem == null) { MessageBox.Show("请选择分区"); return; } Yx_cfg yxcfg = dataGridView1.CurrentRow.DataBoundItem as Yx_cfg; string sql = string.Format("update yx_cfg set addrandbit='{0}',IsError={1},`order`='{2}',areaid={3} where(id={4})", yxcfg.AddrAndBit, yxcfg.IsError, yxcfg.Order, cb_yxarea.SelectedValue, yxcfg.ID); if (!checkBox1.Checked) { sql = string.Format("update yx_cfg set addrandbit='{0}',IsError={1},`order`='{2}',areaid={3} where(id={4})", Int2Hex(yxcfg.AddrAndBit), yxcfg.IsError, yxcfg.Order, cb_yxarea.SelectedValue, yxcfg.ID); } int i = DBHelper.ExcuteTransactionSql(sql); } catch (Exception ex) { Log.WriteLog(ex); } }
/// <summary> /// 生成yx_cfg插入语句 /// </summary> /// <param name="yxcfg"></param> /// <returns></returns> private string InsertYXcfg(Yx_cfg yxcfg) { return(string.Format("insert into yx_cfg(equid,isError,`order`,areaId)values('{0}',{1},{2},{3});SELECT @@Identity", yxcfg.EquID, yxcfg.IsError, yxcfg.Order, cb_yxarea.SelectedValue)); }