//新增主题
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;
}
