//新增主题 void Button1Click(object sender, EventArgs e) { if (this.treeView1.SelectedNode == null) { MessageBox.Show("请选择主题"); return; } TestTheme theme1 = this.treeView1.SelectedNode.Tag as TestTheme; CreateThemeDialog ct = new CreateThemeDialog(); ct.StartPosition = FormStartPosition.CenterParent; DialogResult dr = ct.ShowDialog(); if (dr == DialogResult.OK) { TestTheme theme2 = new TestTheme(); //theme2.Id=theme1.Id; if (ct.isTreeRoot) { theme2.Parentid = 0; theme2.Personid = 0; } else { theme2.Parentid = theme1.Id; theme2.Personid = theme1.Personid; } theme2.Personname = theme1.Personname; theme2.Favname = ct.fname; SqlDBUtil.insert(theme2); MessageBox.Show("创建成功", "提示"); getThemeTree(); } }
//删除主题 void Button2Click(object sender, EventArgs e) { if (this.treeView1.SelectedNode == null) { MessageBox.Show("请选择要删除的主题"); return; } else { TestTheme theme = this.treeView1.SelectedNode.Tag as TestTheme; if (theme.Id == 99999) { MessageBox.Show("默认主题不能删除", "提示"); } else { DialogResult a = MessageBox.Show("您正准备删除主题,与之关联的缺陷将一并删除", "删除", MessageBoxButtons.OKCancel); if (DialogResult.OK == a) { TestunitthemeDao.DelGuanLianUnit(null, theme.Id.ToString()); TestThemeDao.DeleteTheme(theme.Id.ToString()); MessageBox.Show("删除成功", "提示"); getThemeTree(); } } } }
/// <summary> /// 根据关联的unitid获取主题 /// </summary> /// <param name="unitid"></param> /// <returns></returns> static public List <TestTheme> getTestThemeByUnitid(string unitid) { List <TestTheme> ls = new List <TestTheme>(); string sql1 = "select count(*) from testunittheme where themeid = 99999 and unitid=" + unitid; int count = SqlDBUtil.ExecuteScalar(sql1); if (count > 0) { string personid = System.Configuration.ConfigurationManager.AppSettings["UserId"]; //string personname = System.Configuration.ConfigurationManager.AppSettings["Username"]; TestTheme default_tt = new TestTheme(); default_tt.Id = 99999; default_tt.Personid = ((personid == null)?0:Int32.Parse(personid)); default_tt.Personname = System.Configuration.ConfigurationManager.AppSettings["Username"]; ls.Add(default_tt); } string sql = "SELECT * FROM TestTheme " + "where id in (select themeid from testunittheme where unitid=" + unitid + ")"; DataSet data = SqlDBUtil.ExecuteQuery(sql); foreach (DataRow row in data.Tables["ds"].Rows) { ls.Add(Row2TestTheme(row)); } return(ls); }
//保存描述的方法 void Button5Click(object sender, EventArgs e) { TestTheme theme = this.treeView1.SelectedNode.Tag as TestTheme; theme.Favcontent = this.textBox1.Text; SqlDBUtil.update(theme); MessageBox.Show("保存成功", "提示"); }
private static TestTheme Row2TestTheme(DataRow row) { TestTheme testtheme = new TestTheme(); testtheme.Id = Int32.Parse(row["id"].ToString()); testtheme.Parentid = Int32.Parse(row["parentid"].ToString()); testtheme.Personid = Int32.Parse(row["personid"].ToString()); testtheme.Unitid = Int32.Parse(row["unitid"].ToString()); testtheme.Favname = row["favname"].ToString(); testtheme.Favcontent = row["favcontent"].ToString(); testtheme.Personname = row["personname"].ToString(); return(testtheme); }
void setTreeNodeCheck(TreeNode tn) { TestTheme tt = tn.Tag as TestTheme; foreach (var element in selthem) { if (tt.Id == element.Id) { tn.Checked = true; //selthem.Remove(element); //TreeViewCheck.ExpandParent(tn); } } }
void getThemeTree() { if (unitid != null) { selthem = TestThemeDao.getTestThemeByUnitid(unitid); } List <TestTheme> ttlist = TestThemeDao.getAllTestThemeByPersonname(System.Configuration.ConfigurationManager.AppSettings["username"]); this.treeView1.Nodes.Clear(); //List<TreeNode> maintreelist = new List<TreeNode>(); TreeNode main = new TreeNode(); //默认主题 TreeNode tmp = new TreeNode("默认主题"); TestTheme default_tt = new TestTheme(); default_tt.Id = 99999; default_tt.Personid = 0; default_tt.Personname = "朱新培"; tmp.Tag = default_tt; setTreeNodeCheck(tmp); main.Nodes.Add(tmp); foreach (var element in ttlist) { TreeNode tmp1 = null; tmp1 = new TreeNode(element.Favname); tmp1.Tag = element; if (element.Parentid == 0) { main.Nodes.Add(tmp1); setTreeNodeCheck(tmp1); } else { creatTree(tmp1, main); } } TreeNode[] tn = new TreeNode[main.Nodes.Count]; main.Nodes.CopyTo(tn, 0); this.treeView1.Nodes.AddRange(tn); this.treeView1.ExpandAll(); this.treeView1.SelectedNode = treeView1.Nodes[0]; }
void getThemeTree() { List <TestTheme> ttlist = TestThemeDao.getAllTestThemeByPersonname(System.Configuration.ConfigurationManager.AppSettings["username"]); this.treeView1.Nodes.Clear(); //List<TreeNode> maintreelist = new List<TreeNode>(); TreeNode main = new TreeNode(); //默认主题 TreeNode tmp = new TreeNode("默认主题"); TestTheme default_tt = new TestTheme(); default_tt.Id = 99999; string personid = GlobalParams.UserId; default_tt.Personid = ((personid == null)?0:Int32.Parse(personid)); default_tt.Personname = GlobalParams.Username; tmp.Tag = default_tt; main.Nodes.Add(tmp); foreach (var element in ttlist) { TreeNode tmp1 = null; tmp1 = new TreeNode(element.Favname); tmp1.Tag = element; if (element.Parentid == 0) { main.Nodes.Add(tmp1); } else { creatTree(tmp1, main); } } TreeNode[] tn = new TreeNode[main.Nodes.Count]; main.Nodes.CopyTo(tn, 0); this.treeView1.Nodes.AddRange(tn); this.treeView1.SelectedNode = treeView1.Nodes[0]; //让选中项背景色呈现蓝色 treeView1.SelectedNode.BackColor = Color.SteelBlue; //前景色为白色 treeView1.SelectedNode.ForeColor = Color.White; }
/// <summary> /// 查询关联的测试单元列表 /// </summary> void getGuanlianUnitList() { TestTheme theme = this.treeView1.SelectedNode.Tag as TestTheme; string themeid = theme.Id.ToString(); List <TestUnit> tulist = TestUnitDao.getGuanLianUnitList(themeid); this.listView1.Items.Clear(); foreach (TestUnit tu in tulist) { ListViewBing(tu); } if (string.IsNullOrEmpty(theme.Favcontent)) { this.textBox1.Text = "请输入描述……"; } else { this.textBox1.Text = theme.Favcontent; } }
//新增缺陷关联 void Button3Click(object sender, EventArgs e) { SelectUnit su = new SelectUnit(); su.StartPosition = FormStartPosition.CenterParent; DialogResult dr = su.ShowDialog(); if (dr == DialogResult.OK) { TestTheme theme = this.treeView1.SelectedNode.Tag as TestTheme; foreach (var element in su.select_tu) { Testunittheme tt = new Testunittheme(); tt.Themeid = theme.Id; tt.Unitid = element.Id; SqlDBUtil.insert(tt); } getGuanlianUnitList(); } }
void creatTree(TreeNode childtn, TreeNode parenttn) { if (parenttn.Tag != null) { TestTheme child = childtn.Tag as TestTheme; TestTheme parent = parenttn.Tag as TestTheme; if (child.Parentid == parent.Id) { parenttn.Nodes.Add(childtn); return; } } for (int i = 0; i < parenttn.Nodes.Count; i++) { creatTree(childtn, parenttn.Nodes[i]); // parenttn.Nodes.RemoveAt(i); // parenttn.Nodes.Insert(i,tn); } return; }
public void LinkTheme(int themeId) { using var contex = new Context(); var test = contex.Tests .Include(t => t.TestThemes) .ThenInclude(tt => tt.Theme) .FirstOrDefault(t => t.Id == View.TestId); var theme = new TestTheme { Theme = contex.Themes.FirstOrDefault(t => t.Id == themeId), Test = test }; test.TestThemes.Add(theme); contex.SaveChanges(); View.Themes = test.TestThemes .Select(t => t.Theme) .Select(t => new Theme { Id = t.Id, Name = t.Name }); UpdateAllThemes(); }
void creatTree(TreeNode childtn, TreeNode parenttn) { if (parenttn.Tag != null) { TestTheme child = childtn.Tag as TestTheme; TestTheme parent = parenttn.Tag as TestTheme; setTreeNodeCheck(parenttn); if (child.Parentid == parent.Id) { parenttn.Nodes.Add(childtn); setTreeNodeCheck(childtn); return; } } for (int i = 0; i < parenttn.Nodes.Count; i++) { creatTree(childtn, parenttn.Nodes[i]); } return; }