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