private void Form1_Load(object sender, EventArgs e)
{
ERP.DAL.ERPRepository repository = new DAL.ERPRepository();
var tableInfo = repository.GetTableInfos("pre_customers");
string s = tableInfo.GetColumnSql();
var sortColumnInfos = tableInfo.SortColumnInfos;
var data = repository.GetDataTable(s);
this.dataGridView1.DataSource = data;
}
public void TestMethod1()
{
ERP.DAL.ERPRepository repository = new DAL.ERPRepository();
var tableInfo = repository.GetTableInfos("pre_customers");
//ICollection<string> rs = repository.GetCols("pre_customers");
string s = tableInfo.GetColumnSql();
var sortColumnInfos = tableInfo.SortColumnInfos;
Console.WriteLine(s);
//repository.AddPreCustomers();
var data = repository.GetDataTable(s);
foreach (DataRow row in data.Rows)
{
sortColumnInfos.ToList().ForEach(colInfo =>
{
Console.Write(row[colInfo.Name].ToString() + ",");
});
Console.WriteLine();
}
}