public TrashSystemTablePage()
{
InitializeComponent();
string databaseDirectory = AppSettingConfig.DbfFilePath();
string invo = "INVO.dbf";
string invoSql = "SELECT TOP 100 * FROM " + invo + " ORDER BY MONTH DESC";
DataTable invoDt = GetOleDbDbfDataTable(databaseDirectory, invoSql);
DataGridInvo.ItemsSource = invoDt.DefaultView;
string invosub = "INVOSUB.dbf";
string invosubSql = "SELECT TOP 100 * FROM " + invosub + " WHERE C_01 = 'B016' ORDER BY IN_DATE DESC,TIME DESC";//+ " where IN_DATE Between cDate('" + DateTime.Now.AddDays(-1).ToString() + "') and cDate('" + DateTime.Now.ToString() + "') ";
DataTable invosubDt = GetOleDbDbfDataTable(databaseDirectory, invosubSql);
DataGridInvoSub.ItemsSource = invosubDt.DefaultView;
string item = "ITEM.dbf";
string itemSql = "SELECT * FROM " + item;
DataTable itemDt = GetOleDbDbfDataTable(databaseDirectory, itemSql);
DataGridItem.ItemsSource = itemDt.DefaultView;
//List<string> I_03 = new List<string>();
//foreach (DataRow itemRow in itemDt.Rows)
//{
// I_03.Add(itemRow["I_03"].ToString());
//}
//var x = I_03.GroupBy(y => y).Where(w => w.Count() > 1).Select(s => s.Key);
string cust = "CUST.dbf";
string custoSql = "SELECT TOP 100 * FROM " + cust;
DataTable custDt = GetOleDbDbfDataTable(databaseDirectory, custoSql);
DataGridCust.ItemsSource = custDt.DefaultView;
string purc = "PURC.dbf";
string purcSql = "SELECT TOP 100 * FROM " + purc + " ORDER BY MONTH DESC";
DataTable purcDt = GetOleDbDbfDataTable(databaseDirectory, purcSql);
DataGridPurc.ItemsSource = purcDt.DefaultView;
string purcSub = "PURCSUB.dbf";
string purcSubSql = "SELECT TOP 100 * FROM " + purcSub + " ORDER BY MONTH DESC";
DataTable purcSubDt = GetOleDbDbfDataTable(databaseDirectory, purcSubSql);
DataGridPurcsub.ItemsSource = purcSubDt.DefaultView;
string inCash = "IN_CASH.dbf";
string inCashSql = "SELECT * FROM " + inCash;
DataTable inCashDt = GetOleDbDbfDataTable(databaseDirectory, inCashSql);
DataGridInCash.ItemsSource = inCashDt.DefaultView;
}