public void btnSearch_Click() { DateTime dtFrom = DateTime.Now; DateTime dtTo = DateTime.Now; if (dfFrom.IsEmpty) dtFrom = new DateTime(2000, 12, 31); else dtFrom = dfFrom.SelectedDate; if (dfTo.IsEmpty) dtTo = DateTime.Now; else dtTo = dfTo.SelectedDate; if (dtFrom > dtTo) { X.Msg.Alert("Error", "From Date must smaller than End Date").Show(); return; } SuratkeluarQuery skQ = new SuratkeluarQuery(); skQ.SelectAll(); if (dtFrom == dtTo) { skQ.Where(skQ.Tanggal == dtFrom && skQ.Judul.Like("%" + txtJudul.Text.Trim() + "%") && skQ.Keterangan.Like("%" + txtKeterangan.Text.Trim() + "%") && skQ.Nomor.Like("%" + txtNomorSurat.Text.Trim() + "%") && skQ.Kepada.Like("%" + txtPenerima.Text.Trim() + "%")); } else { skQ.Where(skQ.Tanggal.Between(dtFrom,dtTo) && skQ.Judul.Like("%" + txtJudul.Text.Trim() + "%") && skQ.Keterangan.Like("%" + txtKeterangan.Text.Trim() + "%") && skQ.Nomor.Like("%" + txtNomorSurat.Text.Trim() + "%") && skQ.Kepada.Like("%" + txtPenerima.Text.Trim() + "%")); } DataTable dt = skQ.LoadDataTable(); this.storeOutbox.DataSource = dt; this.storeOutbox.DataBind(); }
public DataTable GetOutbox() { DataTable dt = new DataTable(); SuratkeluarQuery smQ = new SuratkeluarQuery(); smQ.SelectAll(); dt = smQ.LoadDataTable(); return dt; }