private void btnSearch_Click(object sender, EventArgs e) { float CrossSectionArea = -1; int TypeCode = -1; string strFilter = ""; bool check = false; if (chkMaterail.Checked) { TypeCode = Convert.ToInt32(cboMaterial.SelectedValue); strFilter = " Type='" + TypeCode.ToString() + "'"; check = true; } if (chkSectionArea.Checked) { CrossSectionArea = Convert.ToSingle(nudCrossSectionArea.Value.ToString()); if (strFilter != "") { strFilter += " AND CrossSectionArea='" + CrossSectionArea.ToString() + "'"; } else { strFilter = " CrossSectionArea='" + CrossSectionArea.ToString() + "'"; } check = true; } if (check) { //DataView dv = new DataView(); //dv.Table = dtMerge; //dv.RowFilter = strFilter; dtMerge.DefaultView.RowFilter = strFilter; gvConductor.AutoGenerateColumns = false; gvConductor.DataSource = dtMerge; } else { dtMerge.DefaultView.RowFilter = ""; //gvConductor.AutoGenerateColumns = false; //gvConductor.DataSource = dtMerge; } Atend.Global.Utility.UBinding.SetGridToCurrentSelectedEquip("CabelTipCode", new object[1] { selectedProductCode }, dtMerge, gvConductor, this); ChangeColor(); //BindDataToCounductorTip(); for (int i = 0; i < gvConductor.Rows.Count; i++) { if (Convert.ToInt32(gvConductor.Rows[i].Cells[1].Value.ToString()) == selectedProductCode && Convert.ToBoolean(gvConductor.Rows[i].Cells[4].Value.ToString()) == false) { gvConductor.Rows[i].DefaultCellStyle.BackColor = Color.Yellow; } } //BindDataToCounductorTip(); }
/// <summary> /// Returns a friendly string from the column name of a data column (eg pt_internat_postal_code_c). /// If AIncludeSpaces is true it would return 'Internat Postal Code', otherwise 'internatpostalcode' /// </summary> /// <param name="ADataColumn">The data column to work with (often a primary key column)</param> /// <param name="AIncludeSpaces">If true returs eg 'Internat Postal Code'. If false returns eg 'internatpostalcode'</param> /// <returns>The appropriate string</returns> public static string DataColumnNameToFriendlyName(System.Data.DataColumn ADataColumn, Boolean AIncludeSpaces) { if (ADataColumn == null) { return(String.Empty); } System.Text.StringBuilder sb = new System.Text.StringBuilder(); // for example pt_internat_postal_code_c string primaryKeyName = ADataColumn.ToString(); // strip off the leading p_ string work = primaryKeyName.Substring(primaryKeyName.IndexOf('_') + 1); // strip off the trailing _c work = work.Substring(0, work.LastIndexOf('_')); if (AIncludeSpaces) { // Swap _ for space and capitalise the next character work = work.Replace("_", " "); sb.Append(work.Substring(0, 1).ToUpper()); work = work.Substring(1); int pos = work.IndexOf(' '); while (pos >= 0) { sb.Append(work.Substring(0, pos + 1)); sb.Append(work.Substring(pos + 1, 1).ToUpper()); work = work.Substring(pos + 2); pos = work.IndexOf(' '); } sb.Append(work); } else { //just replace _ with blank sb.Append(work.Replace("_", String.Empty)); } return(sb.ToString()); }
[Test] public void TestToString() { DataColumn dc; string sColName,sExp; dc = new DataColumn(); //ToString = "" //Console.WriteLine(dc.ToString()); //ToString = ColumnName sColName = "Test1"; dc.ColumnName = sColName; // ToString - ColumnName Assert.AreEqual(sColName , dc.ToString() , "DC42"); //TosTring = ColumnName + " + " + Expression sExp = "Tax * 1.234"; dc.Expression = sExp; // TosTring=ColumnName + Expression Assert.AreEqual(sColName + " + " + sExp , dc.ToString() , "DC43"); }
public void Add () { DataTable Table = new DataTable ("test_table"); DataColumnCollection Cols = Table.Columns; DataColumn C = null; Cols.Add (); Cols.Add (); C = Cols [0]; Assert.IsTrue (C.AllowDBNull, "test#01"); Assert.IsFalse (C.AutoIncrement, "test#02"); Assert.AreEqual (0L, C.AutoIncrementSeed, "test#03"); Assert.AreEqual (1L, C.AutoIncrementStep, "test#04"); Assert.AreEqual ("Column1", C.Caption, "test#05"); Assert.AreEqual ("Element", C.ColumnMapping.ToString (), "test#06"); Assert.AreEqual ("Column1", C.ColumnName, "test#07"); Assert.IsNull (C.Container, "test#08"); Assert.AreEqual (typeof (string), C.DataType, "test#09"); Assert.AreEqual (DBNull.Value, C.DefaultValue, "test#10"); Assert.IsFalse (C.DesignMode, "test#11"); Assert.AreEqual ("", C.Expression, "test#12"); Assert.AreEqual (0, C.ExtendedProperties.Count, "test#13"); Assert.AreEqual (-1, C.MaxLength, "test#14"); Assert.AreEqual ("", C.Namespace, "test#15"); Assert.AreEqual (0, C.Ordinal, "test#16"); Assert.AreEqual ("", C.Prefix, "test#17"); Assert.IsFalse (C.ReadOnly, "test#18"); Assert.IsNull (C.Site, "test#19"); Assert.AreEqual ("test_table", C.Table.TableName, "test#20"); Assert.AreEqual ("Column1", C.ToString (), "test#21"); Assert.IsFalse (C.Unique, "test#22"); C = Cols [1]; Assert.IsTrue (C.AllowDBNull, "test#23"); Assert.IsFalse (C.AutoIncrement, "test#24"); Assert.AreEqual (0L, C.AutoIncrementSeed, "test#25"); Assert.AreEqual (1L, C.AutoIncrementStep, "test#26"); Assert.AreEqual ("Column2", C.Caption, "test#27"); Assert.AreEqual ("Element", C.ColumnMapping.ToString (), "test#28"); Assert.AreEqual ("Column2", C.ColumnName, "test#29"); Assert.IsNull (C.Container, "test#30"); Assert.AreEqual (typeof (string), C.DataType, "test#31"); Assert.AreEqual (DBNull.Value, C.DefaultValue, "test#32"); Assert.IsFalse (C.DesignMode, "test#33"); Assert.AreEqual ("", C.Expression, "test#34"); Assert.AreEqual (0, C.ExtendedProperties.Count, "test#35"); Assert.AreEqual (-1, C.MaxLength, "test#36"); Assert.AreEqual ("", C.Namespace, "test#37"); Assert.AreEqual (1, C.Ordinal, "test#38"); Assert.AreEqual ("", C.Prefix, "test#39"); Assert.IsFalse (C.ReadOnly, "test#40"); Assert.IsNull (C.Site, "test#41"); Assert.AreEqual ("test_table", C.Table.TableName, "test#42"); Assert.AreEqual ("Column2", C.ToString (), "test#43"); Assert.IsFalse (C.Unique, "test#44"); Cols.Add ("test1", typeof (int), ""); Cols.Add ("test2", typeof (string), "Column1 + Column2"); C = Cols [2]; Assert.IsTrue (C.AllowDBNull, "test#45"); Assert.IsFalse (C.AutoIncrement, "test#46"); Assert.AreEqual (0L, C.AutoIncrementSeed, "test#47"); Assert.AreEqual (1L, C.AutoIncrementStep, "test#48"); Assert.AreEqual ("test1", C.Caption, "test#49"); Assert.AreEqual ("Element", C.ColumnMapping.ToString (), "test#50"); Assert.AreEqual ("test1", C.ColumnName, "test#51"); Assert.IsNull (C.Container, "test#52"); Assert.AreEqual (typeof (int), C.DataType, "test#53"); Assert.AreEqual (DBNull.Value, C.DefaultValue, "test#54"); Assert.IsFalse (C.DesignMode, "test#55"); Assert.AreEqual ("", C.Expression, "test#56"); Assert.AreEqual (0, C.ExtendedProperties.Count, "test#57"); Assert.AreEqual (-1, C.MaxLength, "test#58"); Assert.AreEqual ("", C.Namespace, "test#59"); Assert.AreEqual (2, C.Ordinal, "test#60"); Assert.AreEqual ("", C.Prefix, "test#61"); Assert.IsFalse (C.ReadOnly, "test#62"); Assert.IsNull (C.Site, "test#63"); Assert.AreEqual ("test_table", C.Table.TableName, "test#64"); Assert.AreEqual ("test1", C.ToString (), "test#65"); Assert.IsFalse (C.Unique, "test#66"); C = Cols [3]; Assert.IsTrue (C.AllowDBNull, "test#67"); Assert.IsFalse (C.AutoIncrement, "test#68"); Assert.AreEqual (0L, C.AutoIncrementSeed, "test#69"); Assert.AreEqual (1L, C.AutoIncrementStep, "test#70"); Assert.AreEqual ("test2", C.Caption, "test#71"); Assert.AreEqual ("Element", C.ColumnMapping.ToString (), "test#72"); Assert.AreEqual ("test2", C.ColumnName, "test#73"); Assert.IsNull (C.Container, "test#74"); Assert.AreEqual (typeof (string), C.DataType, "test#75"); Assert.AreEqual (DBNull.Value, C.DefaultValue, "test#76"); Assert.IsFalse (C.DesignMode, "test#77"); Assert.AreEqual ("Column1 + Column2", C.Expression, "test#78"); Assert.AreEqual (0, C.ExtendedProperties.Count, "test#79"); Assert.AreEqual (-1, C.MaxLength, "test#80"); Assert.AreEqual ("", C.Namespace, "test#81"); Assert.AreEqual (3, C.Ordinal, "test#82"); Assert.AreEqual ("", C.Prefix, "test#83"); Assert.IsTrue (C.ReadOnly, "test#84"); Assert.IsNull (C.Site, "test#85"); Assert.AreEqual ("test_table", C.Table.TableName, "test#86"); Assert.AreEqual ("test2 + Column1 + Column2", C.ToString (), "test#87"); Assert.IsFalse (C.Unique, "test#88"); C = new DataColumn ("test3", typeof (int)); Cols.Add (C); C = Cols [4]; Assert.IsTrue (C.AllowDBNull, "test#89"); Assert.IsFalse (C.AutoIncrement, "test#90"); Assert.AreEqual (0L, C.AutoIncrementSeed, "test#91"); Assert.AreEqual (1L, C.AutoIncrementStep, "test#92"); Assert.AreEqual ("test3", C.Caption, "test#93"); Assert.AreEqual ("Element", C.ColumnMapping.ToString (), "test#94"); Assert.AreEqual ("test3", C.ColumnName, "test#95"); Assert.IsNull (C.Container, "test#96"); Assert.AreEqual (typeof (int), C.DataType, "test#97"); Assert.AreEqual (DBNull.Value, C.DefaultValue, "test#98"); Assert.IsFalse (C.DesignMode, "test#99"); Assert.AreEqual ("", C.Expression, "test#100"); Assert.AreEqual (0, C.ExtendedProperties.Count, "test#101"); Assert.AreEqual (-1, C.MaxLength, "test#102"); Assert.AreEqual ("", C.Namespace, "test#103"); Assert.AreEqual (4, C.Ordinal, "test#104"); Assert.AreEqual ("", C.Prefix, "test#105"); Assert.IsFalse (C.ReadOnly, "test#106"); Assert.IsNull (C.Site, "test#107"); Assert.AreEqual ("test_table", C.Table.TableName, "test#108"); Assert.AreEqual ("test3", C.ToString (), "test#109"); Assert.IsFalse (C.Unique, "test#110"); }
public void AddRange () { DataTable Table = new DataTable ("test_table"); DataTable Table2 = new DataTable ("test_table2"); DataColumnCollection Cols = Table.Columns; DataColumn C = null; DataColumn [] ColArray = new DataColumn [2]; C = new DataColumn ("test1"); ColArray [0] = C; C = new DataColumn ("test2"); C.AllowDBNull = false; C.Caption = "Test_caption"; C.DataType = typeof (XmlReader); ColArray [1] = C; Cols.AddRange (ColArray); C = Cols [0]; Assert.IsTrue (C.AllowDBNull, "test#01"); Assert.IsFalse (C.AutoIncrement, "test#02"); Assert.AreEqual (0L, C.AutoIncrementSeed, "test#03"); Assert.AreEqual (1L, C.AutoIncrementStep, "test#04"); Assert.AreEqual ("test1", C.Caption, "test#05"); Assert.AreEqual ("Element", C.ColumnMapping.ToString (), "test#06"); Assert.AreEqual ("test1", C.ColumnName, "test#07"); Assert.IsNull (C.Container, "test#08"); Assert.AreEqual (typeof (string), C.DataType, "test#09"); Assert.AreEqual (DBNull.Value, C.DefaultValue, "test#10"); Assert.IsFalse (C.DesignMode, "test#11"); Assert.AreEqual ("", C.Expression, "test#12"); Assert.AreEqual (0, C.ExtendedProperties.Count, "test#13"); Assert.AreEqual (-1, C.MaxLength, "test#14"); Assert.AreEqual ("", C.Namespace, "test#15"); Assert.AreEqual (0, C.Ordinal, "test#16"); Assert.AreEqual ("", C.Prefix, "test#17"); Assert.IsFalse (C.ReadOnly, "test#18"); Assert.IsNull (C.Site, "test#19"); Assert.AreEqual ("test_table", C.Table.TableName, "test#20"); Assert.AreEqual ("test1", C.ToString (), "test#21"); Assert.IsFalse (C.Unique, "test#22"); C = Cols [1]; Assert.IsFalse (C.AllowDBNull, "test#01"); Assert.IsFalse (C.AutoIncrement, "test#02"); Assert.AreEqual (0L, C.AutoIncrementSeed, "test#03"); Assert.AreEqual (1L, C.AutoIncrementStep, "test#04"); Assert.AreEqual ("Test_caption", C.Caption, "test#05"); Assert.AreEqual ("Element", C.ColumnMapping.ToString (), "test#06"); Assert.AreEqual ("test2", C.ColumnName, "test#07"); Assert.IsNull (C.Container, "test#08"); Assert.AreEqual (typeof (XmlReader), C.DataType, "test#09"); Assert.AreEqual (DBNull.Value, C.DefaultValue, "test#10"); Assert.IsFalse (C.DesignMode, "test#11"); Assert.AreEqual ("", C.Expression, "test#12"); Assert.AreEqual (0, C.ExtendedProperties.Count, "test#13"); Assert.AreEqual (-1, C.MaxLength, "test#14"); Assert.AreEqual ("", C.Namespace, "test#15"); Assert.AreEqual (1, C.Ordinal, "test#16"); Assert.AreEqual ("", C.Prefix, "test#17"); Assert.IsFalse (C.ReadOnly, "test#18"); Assert.IsNull (C.Site, "test#19"); Assert.AreEqual ("test_table", C.Table.TableName, "test#20"); Assert.AreEqual ("test2", C.ToString (), "test#21"); Assert.IsFalse (C.Unique, "test#22"); }
/// <summary> /// 将CSV文件的数据读取到DataTable中 /// </summary> /// <param name="fileName">CSV文件路径</param> /// <returns>返回读取了CSV数据的DataTable</returns> public DataTable OpenCSV(string filePath) { //Encoding encoding = Common.GetType(filePath); //Encoding.ASCII;// DataTable dt = new DataTable(); FileStream fs = new FileStream(filePath, FileMode.Open, FileAccess.Read); StreamReader sr = new StreamReader(fs); //记录每次读取的一行记录 string strLine = ""; //记录每行记录中的各字段内容 string[] aryLine = null; string[] tableHead = null; //标示列数 int columnCount = 0; //标示是否是读取的第一行 bool IsFirst = true; //逐行读取CSV中的数据 while ((strLine = sr.ReadLine()) != null) { if (IsFirst == true) { tableHead = strLine.Split(','); IsFirst = false; columnCount = tableHead.Length; //创建列 for (int i = 0; i < columnCount; i++) { //格式转换 switch (i) { case 0: DataColumn dc0 = new DataColumn(tableHead[i]); dt.Columns.Add(dc0.ToString(), typeof(string)); break; case 5: DataColumn dc1 = new DataColumn(tableHead[i]); dt.Columns.Add(dc1.ToString(), typeof(int)); break; case 1: case 2: case 3: case 4: case 6: DataColumn dc2 = new DataColumn(tableHead[i]); dt.Columns.Add(dc2.ToString(), typeof(float)); break; default: break; } } } else { aryLine = strLine.Split(','); DataRow dr = dt.NewRow(); for (int j = 0; j < columnCount; j++) { //格式转换 switch (j) { case 0: aryLine[j] = aryLine[j].Replace("-", "");//去除日期串中的‘-’ dr[j] = int.Parse(aryLine[j]);//转整型 break; case 5: dr[j] = int.Parse(aryLine[j]); break; case 1: case 2: case 3: case 4: case 6: dr[j] = float.Parse(aryLine[j]); break; default: break; } dr[j] = aryLine[j]; } dt.Rows.Add(dr); } } if (aryLine != null && aryLine.Length > 0) { dt.DefaultView.Sort = tableHead[0] + " " + "desc"; //第一列倒排 } sr.Close(); fs.Close(); return dt; }
//Activate This Construntor to log All To Standard output //public TestClass():base(true){} //Activate this constructor to log Failures to a log file //public TestClass(System.IO.TextWriter tw):base(tw, false){} //Activate this constructor to log All to a log file //public TestClass(System.IO.TextWriter tw):base(tw, true){} //BY DEFAULT LOGGING IS DONE TO THE STANDARD OUTPUT ONLY FOR FAILURES public void run() { Exception exp = null; DataColumn dc; string sColName,sExp; dc = new DataColumn(); //ToString = "" //Console.WriteLine(dc.ToString()); //ToString = ColumnName sColName = "Test1"; dc.ColumnName = sColName; try { BeginCase("ToString - ColumnName"); Compare(dc.ToString() ,sColName ); } catch(Exception ex) {exp = ex;} finally {EndCase(exp); exp = null;} //TosTring = ColumnName + " + " + Expression sExp = "Tax * 1.234"; dc.Expression = sExp; try { BeginCase("TosTring=ColumnName + Expression"); Compare(dc.ToString() ,sColName + " + " + sExp ); } catch(Exception ex) {exp = ex;} finally {EndCase(exp); exp = null;} }
public void AddRange () { DataTable Table = new DataTable ("test_table"); DataTable Table2 = new DataTable ("test_table2"); DataColumnCollection Cols = Table.Columns; DataColumn C = null; DataColumn [] ColArray = new DataColumn [2]; C = new DataColumn ("test1"); ColArray [0] = C; C = new DataColumn ("test2"); C.AllowDBNull = false; C.Caption = "Test_caption"; C.DataType = typeof (XmlReader); ColArray [1] = C; Cols.AddRange (ColArray); C = Cols [0]; AssertEquals ("test#01", true, C.AllowDBNull); AssertEquals ("test#02", false, C.AutoIncrement); AssertEquals ("test#03", 0L, C.AutoIncrementSeed); AssertEquals ("test#04", 1L, C.AutoIncrementStep); AssertEquals ("test#05", "test1", C.Caption); AssertEquals ("test#06", "Element", C.ColumnMapping.ToString ()); AssertEquals ("test#07", "test1", C.ColumnName); AssertEquals ("test#08", true, C.Container == null); AssertEquals ("test#09", typeof (string), C.DataType); AssertEquals ("test#10", DBNull.Value, C.DefaultValue); AssertEquals ("test#11", false, C.DesignMode); AssertEquals ("test#12", "", C.Expression); AssertEquals ("test#13", 0, C.ExtendedProperties.Count); AssertEquals ("test#14", -1, C.MaxLength); AssertEquals ("test#15", "", C.Namespace); AssertEquals ("test#16", 0, C.Ordinal); AssertEquals ("test#17", "", C.Prefix); AssertEquals ("test#18", false, C.ReadOnly); AssertEquals ("test#19", null, C.Site); AssertEquals ("test#20", "test_table", C.Table.TableName); AssertEquals ("test#21", "test1", C.ToString ()); AssertEquals ("test#22", false, C.Unique); C = Cols [1]; AssertEquals ("test#01", false, C.AllowDBNull); AssertEquals ("test#02", false, C.AutoIncrement); AssertEquals ("test#03", 0L, C.AutoIncrementSeed); AssertEquals ("test#04", 1L, C.AutoIncrementStep); AssertEquals ("test#05", "Test_caption", C.Caption); AssertEquals ("test#06", "Element", C.ColumnMapping.ToString ()); AssertEquals ("test#07", "test2", C.ColumnName); AssertEquals ("test#08", true, C.Container == null); AssertEquals ("test#09", typeof (XmlReader), C.DataType); AssertEquals ("test#10", DBNull.Value, C.DefaultValue); AssertEquals ("test#11", false, C.DesignMode); AssertEquals ("test#12", "", C.Expression); AssertEquals ("test#13", 0, C.ExtendedProperties.Count); AssertEquals ("test#14", -1, C.MaxLength); AssertEquals ("test#15", "", C.Namespace); AssertEquals ("test#16", 1, C.Ordinal); AssertEquals ("test#17", "", C.Prefix); AssertEquals ("test#18", false, C.ReadOnly); AssertEquals ("test#19", null, C.Site); AssertEquals ("test#20", "test_table", C.Table.TableName); AssertEquals ("test#21", "test2", C.ToString ()); AssertEquals ("test#22", false, C.Unique); }
/// <summary> /// Returns the Control that is bound to the specified DataColumn. /// /// </summary> /// <param name="ABindingManagerBase">A BindingManagerBase. Such an Object can be /// retrieved e.g. by such a code: BindingContext[FMainDS.PPartner]</param> /// <param name="AColumn">The DataColumn to which the Control should be found</param> /// <returns>The Control, if it could be found, otherwise nil. /// </returns> public static Control GetBoundControlForColumn(BindingManagerBase ABindingManagerBase, DataColumn AColumn) { int Counter; // MessageBox.Show('ABindingManagerBase.Bindings.Count: ' + ABindingManagerBase.Bindings.Count.ToSTring); for (Counter = 0; Counter <= ABindingManagerBase.Bindings.Count - 1; Counter += 1) { // MessageBox.Show('Bound Control # ' + Counter.ToString + ': ' + ABindingManagerBase.Bindings[Counter].Control.ToString + '; bound to field: ' + ABindingManagerBase.Bindings[Counter].BindingMemberInfo.BindingField.ToString); if (ABindingManagerBase.Bindings[Counter].BindingMemberInfo.BindingField == AColumn.ToString()) { return ABindingManagerBase.Bindings[Counter].Control; } } return null; }