/// <summary>获取标签</summary> /// <param name="id"></param> static public tbTag GetTag(int id) { tbTag tag = null; using (CTDBEntities ct = new CTDBEntities()) tag = ct.tbTag.FirstOrDefault(s => s.tag_id == id); return(tag); }
private void treeView1_DragDrop(object sender, DragEventArgs e) { //return; //为TreeView 控件 DragDrop事件定义处理方法 //获得用户拖拽的 TreeNode节点 TreeNode OriginationNode = (TreeNode)e.Data.GetData("System.Windows.Forms.TreeNode"); //使用 PointToClient方法将屏幕鼠标的坐标换成在TreeView工作区的坐标 Point pt = ((TreeView)sender).PointToClient(new Point(e.X, e.Y)); TreeNode DestinationNode = ((TreeView)sender).GetNodeAt(pt); //确定将 TreeNode节点拖拽到哪一个节点下 //确定此实例中存储的数据是否与 System.Windows.Forms.TreeNode关联 if (OriginationNode.Name == DestinationNode.Name) { return; } if (e.Data.GetDataPresent("System.Windows.Forms.TreeNode", false)) { TreeNode TestNode = DestinationNode; //父节点不能拖拽至其子孙类节点下,并且用户拖拽的节点 跟目标节点不能是同一个,否则给出警告信息并直接返回 while (TestNode != TestNode.TreeView.TopNode) { if (TestNode == OriginationNode) { MessageBox.Show("Node can't become its child's child!"); return; } TestNode = TestNode.Parent; if (TestNode == null) { break; } } //动作 if (e.Effect == DragDropEffects.Copy) { } else { label1.Text = "Moved!"; OriginationNode.Remove(); //if (tagp != null) // tTag.DeleteTagRelationship(tag.ID, tagp.ID, this.UserId); DestinationNode.Nodes.Add(OriginationNode); //tbTag t = ct.getTagByID(OriginationNode.Name); int tid = int.Parse(OriginationNode.Name); tbTag t = ct.tbTag.Where(c => c.tag_id == tid).Single(); t.tag_pid = int.Parse(DestinationNode.Name); t.tag_type = t.tag_pid;// = int.Parse(DestinationNode.Name); ct.SaveChanges(); } } }
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) { int id = (int)this.dataGridView1.SelectedRows[0].Cells["tag_id"].Value; //tbTag vtag = ct.getTagByID(id); tbTag vtag = ct.tbTag.Where(c => c.tag_id == id).Single(); TreeNode[] tns = treeView1.Nodes.Find(vtag.tag_id.ToString(), true); treeView1.CollapseAll(); treeView1.SelectedNode = tns[0]; }
private void bTagAdd_Click(object sender, EventArgs e) { var s = new tbTag(); s.tag_tag = ctagTag.Text; s.tag_tagCN = ctagCHN.Text; s.tag_note = ctagNote.Text; s.tag_type = 0; s.tag_pid = 8; s.date_in = DateTime.Now; ct.tbTag.Add(s); ct.SaveChanges(); //将修改保存到数据库中 refreshdata(); }
private void addNote(TreeNode tn, tbTag tag) { tn.Name = tag.tag_id.ToString(); tn.Text = tag.tag_tag; //if (tag.TagType.ID == "1") // tn.ForeColor = Color.Red; //if (tag.TagType.ID == "9") // tn.ForeColor = Color.Green; var list = from c in ct.tbTag where c.tag_pid == tag.tag_id select c; foreach (tbTag tagc in list) { TreeNode node = new TreeNode(); addNote(node, tagc); tn.Nodes.Add(node); } }
private void dataGridView1_SelectionChanged(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count == 1) { int id = (int)dataGridView1.SelectedRows[0].Cells[0].Value; var q = from c in ct.tbTag where c.tag_id == id select c; List <tbTag> sl = q.ToList <tbTag>(); tbTag s = sl[0]; //foreach (tbSpecies s in q) { ctagID.Text = s.tag_id.ToString(); ctagCHN.Text = s.tag_tagCN; ctagNote.Text = s.tag_note; ctagTag.Text = s.tag_tag; ctagPID.Text = s.tag_pid.ToString(); } } }