private void 打开CMSTreeNode_Click(object sender, EventArgs e) { DbCommand cmd = conn.CreateCommand(); cmd.CommandText = String.Format("SELECT TOP 1000 * from {0}", treeView1.SelectedNode.Text); textBox1.Text = cmd.CommandText; DbDataReader reader = cmd.ExecuteReader(); ListViewTool.RefreshByDbDataReader(listView1, reader); reader.Close(); }
private void button1_Click(object sender, EventArgs e) { int value = (int)numericUpDown1.Value; cmd.CommandText = String.Format(@" IF OBJECT_ID(N'tbC2Inew',N'U') is not null DROP TABLE tbC2Inew CREATE TABLE [dbo].[tbC2Inew] ( [SCell] [varchar](50) NULL, [Ncell] [varchar](50) NULL, [C2I_mean] [float] NULL, [C2I_std] [float] NULL, [PrbC2I9] [float] NULL, [PrbABS6] [float] NULL )"); cmd.ExecuteNonQuery(); cmd.CommandText = String.Format("SELECT * FROM #C2ITemp WHERE count>={0}", value); reader = cmd.ExecuteReader(); List <C2I> C2IList = new List <C2I>(); while (reader.Read()) { C2I c2i = new C2I(); c2i.SCell = reader["SCell"].ToString(); c2i.NCell = reader["NCell"].ToString(); c2i.C2I_mean = double.Parse(reader["C2I_mean"].ToString()); c2i.C2I_std = double.Parse(reader["C2I_std"].ToString()); if (c2i.C2I_std == 0) { c2i.PrbC2I9 = c2i.C2I_mean < 9 ? 1 : 0; } else { if (c2i.C2I_mean <= 9) { c2i.PrbC2I9 = Prb.getProbability(c2i.C2I_mean, 9, c2i.C2I_mean, c2i.C2I_std) + 0.5; } else { c2i.PrbC2I9 = 0.5 - Prb.getProbability(9, c2i.C2I_mean, c2i.C2I_mean, c2i.C2I_std); } c2i.PrbABS6 = Prb.getProbability(-6, 6, c2i.C2I_mean, c2i.C2I_std); } C2IList.Add(c2i); } reader.Close(); foreach (C2I c2i in C2IList) { cmd.CommandText = String.Format(@" INSERT INTO [dbo].[tbC2Inew] ([SCell] ,[Ncell] ,[C2I_mean] ,[C2I_std] ,[PrbC2I9] ,[PrbABS6]) VALUES ('{0}','{1}',{2},{3},{4},{5}) ", c2i.SCell, c2i.NCell, c2i.C2I_mean, c2i.C2I_std, c2i.PrbC2I9, c2i.PrbABS6); cmd.ExecuteNonQuery(); } cmd.CommandText = "SELECT * FROM tbC2Inew"; reader = cmd.ExecuteReader(); ListViewTool.RefreshByDbDataReader(listview, reader); reader.Close(); }
private void button1_Click(object sender, EventArgs e) { double value = (double)numericUpDown1.Value / 100; C2I3List.Clear(); foreach (C2IPanel.C2I c2i in C2IList) { C2I3 c2i3 = new C2I3(); c2i3.a = c2i.SCell; c2i3.b = c2i.NCell; if (c2i.PrbABS6 < value) { continue; } foreach (C2IPanel.C2I c2i_ in C2IList) { if (c2i_.PrbABS6 < value) { continue; } if (match(c2i, c2i_) == MatchType.SS) { foreach (C2IPanel.C2I c2i__ in C2IList) { if (c2i__.PrbABS6 < value) { continue; } C2IPanel.C2I c2iTemp = new C2IPanel.C2I() { SCell = c2i.NCell, NCell = c2i_.NCell }; MatchType type = match(c2i__, c2iTemp); if (type == MatchType.NSBoth || type == MatchType.SNBoth) { c2i3.c = c2i_.NCell; C2I3List.Add(c2i3); } } } else if (match(c2i, c2i_) == MatchType.SN) { foreach (C2IPanel.C2I c2i__ in C2IList) { if (c2i__.PrbABS6 < value) { continue; } C2IPanel.C2I c2iTemp = new C2IPanel.C2I() { SCell = c2i.SCell, NCell = c2i_.NCell }; MatchType type = match(c2i__, c2iTemp); if (type == MatchType.NSBoth || type == MatchType.SNBoth) { c2i3.c = c2i_.NCell; C2I3List.Add(c2i3); } } } else if (match(c2i, c2i_) == MatchType.NN) { foreach (C2IPanel.C2I c2i__ in C2IList) { if (c2i__.PrbABS6 < value) { continue; } C2IPanel.C2I c2iTemp = new C2IPanel.C2I() { SCell = c2i.SCell, NCell = c2i_.SCell }; MatchType type = match(c2i__, c2iTemp); if (type == MatchType.NSBoth || type == MatchType.SNBoth) { c2i3.c = c2i_.SCell; C2I3List.Add(c2i3); } } } else if (match(c2i, c2i_) == MatchType.NS) { foreach (C2IPanel.C2I c2i__ in C2IList) { if (c2i__.PrbABS6 < value) { continue; } C2IPanel.C2I c2iTemp = new C2IPanel.C2I() { SCell = c2i.NCell, NCell = c2i_.SCell }; MatchType type = match(c2i__, c2iTemp); if (type == MatchType.NSBoth || type == MatchType.SNBoth) { c2i3.c = c2i_.SCell; C2I3List.Add(c2i3); } } } } } cmd.CommandText = String.Format(@" IF OBJECT_ID(N'tbC2I3',N'U') is not null DROP TABLE tbC2I3 CREATE TABLE [dbo].[tbC2I3]( [aCell] [varchar](50) NULL, [bCell] [varchar](50) NULL, [cCell] [varchar](50) NULL )"); cmd.ExecuteNonQuery(); for (int i = 0; i < C2I3List.Count; i++) { for (int j = i + 1; j < C2I3List.Count; j++) { if (IsSimaliar(C2I3List[i], C2I3List[j])) { C2I3List.RemoveAt(j); j--; } } } foreach (C2I3 c2i3 in C2I3List) { cmd.CommandText = String.Format(@" INSERT INTO [dbo].[tbC2I3] ([aCell] ,[bCell] ,[cCell]) VALUES('{0}','{1}','{2}')", c2i3.a, c2i3.b, c2i3.c); cmd.ExecuteNonQuery(); } cmd.CommandText = "SELECT * FROM tbC2I3"; reader = cmd.ExecuteReader(); ListViewTool.RefreshByDbDataReader(listview, reader); reader.Close(); }