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