private void btnRemoveBinding_Click(object sender, EventArgs e)
{
m_viewTagLabelBinding.RowFilter = "LabelName='" + label.Name + "'";
if (m_viewTagLabelBinding.Count > 0)
{
try
{
SQLHelper.ExecuteSql("delete FROM [TagLabelBinding] where LabelName='" + label.Name + "'");
m_viewTagLabelBinding[0].Delete();
TableTagLabelBinding.setFill();
SetNoBindingText();
}
catch (Exception ex)
{
WriteLog.WriteLogs(ex.ToString());
MessageBox.Show("解绑失败！");
}
}
}
private void btnDind_Click(object sender, EventArgs e)
{
string sTagID = dataGridView1.CurrentRow.Cells["TagID"].Value.ToString();
string sTagDesc = dataGridView1.CurrentRow.Cells["TagDesc"].Value.ToString();
m_viewTagLabelBinding.RowFilter = "LabelName='" + label.Name + "'";
if (m_viewTagLabelBinding.Count > 0)//更新绑定
{
if (sTagID != m_viewTagLabelBinding[0]["TagID"].ToString())
{
m_viewTagLabelBinding[0].BeginEdit();
m_viewTagLabelBinding[0]["TagID"] = sTagID;
m_viewTagLabelBinding[0]["TagDesc"] = sTagDesc;
try
{
SQLHelper.ExecuteSql("update TagLabelBinding set TagID=" + sTagID + ",TagDesc='" + sTagDesc
+ "' where LabelName='" + label.Name + "'");
m_viewTagLabelBinding[0].EndEdit();
SetBindingText(sTagDesc);
SetLabelTag();
TableTagLabelBinding.setFill();
MessageBox.Show("绑定成功！");
Close();
}
catch (Exception ex)
{
m_viewTagLabelBinding[0].CancelEdit();
MessageBox.Show("绑定失败！");
WriteLog.WriteLogs(ex.ToString());
}
}
}
else//建立绑定
{
//string sParent = GetParents(label);
string sParent = GetParents(label);
DataRowView rowNew = m_viewTagLabelBinding.AddNew();
rowNew.BeginEdit();
rowNew["LabelName"] = label.Name;
rowNew["Parent"] = sParent;
rowNew["TagID"] = sTagID;
rowNew["TagDesc"] = sTagDesc;
string sSql = "insert into TagLabelBinding(LabelName,Parent,TagID,TagDesc) ";
sSql += "values('" + label.Name + "','" + sParent + "'," + sTagID + ",'" + sTagDesc + "')";
try
{
SQLHelper.ExecuteSql(sSql);
rowNew.EndEdit();
SetBindingText(sTagDesc);
SetLabelTag();
TableTagLabelBinding.setFill();
MessageBox.Show("绑定成功！");
Close();
}
catch (Exception ex)
{
rowNew.CancelEdit();
MessageBox.Show("绑定失败！");
WriteLog.WriteLogs(ex.ToString());
}
}
}
