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;
}
