//增加遥信点位
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));
}
