private void Window_Loaded(object sender, RoutedEventArgs e)
{
_Tc = _taskcheck.GetAsDataTable(string.Empty, string.Empty, 3);
if (_Tc != null && _Tc.Rows.Count > 0)
{
ShowAll(_Tc);
}
//ShowAllItems(Global.userAccounts);
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
//(cdate(BAOJINGTIME)>=#2015-10-26 22:21:23#)
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.AppendFormat(" (cdate(BAOJINGTIME)< #{0}#)", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
DataTable dt = _Tskbll.GetAsDataTable(stringBuilder.ToString(), string.Empty, 3);
DataView nev = new DataView();
nev = dt.DefaultView;
nev.RowFilter = "Num <1";
this.DataGridRecord.ItemsSource = nev;
}
private void SearchTask()
{
this.DataGridRecord.ItemsSource = null;
DataTable dt = _Tskbll.GetAsDataTable(string.Empty, string.Empty, 1);
if (dt != null && dt.Rows.Count > 0)
{
List <tlsTrTask> Items = (List <tlsTrTask>)IListDataSet.DataTableToIList <tlsTrTask>(dt, 1);
this.DataGridRecord.ItemsSource = (Items != null && Items.Count > 0) ? Items : null;
}
else
{
this.DataGridRecord.ItemsSource = null;
}
}
private void Search()
{
DataTable dt = _Tskbll.GetAsDataTable("CPTITLE Like '%" + textBoxName.Text.Trim() + "%'", string.Empty, 1);
this.DataGridRecord.ItemsSource = (dt != null && dt.Rows.Count > 0) ? dt.DefaultView : null;
}