private void _reload()
{
datestart.Value = DateTime.Now;
dateend.Value = DateTime.Now.AddDays(14);
var lst = new List <KeyValuePair <string, string> >();
lst.Add(new KeyValuePair <string, string>(null, "Tất cả"));
lst.Add(new KeyValuePair <string, string>("ACTIVE", "Đã xác nhận"));
lst.Add(new KeyValuePair <string, string>("CONFIRM", "Chờ xác nhận"));
lst.Add(new KeyValuePair <string, string>("DONE", "Đã khám"));
lst.Add(new KeyValuePair <string, string>("CANCLE", "Đã hủy"));
cmbTrangThai.BindDataSource(lst, q => q.Key, q => q.Value);
cmbTrangThai.SelectedIndex = 2;
var pk = new PhongKhamsBUS(this).GetAll();
pk.Insert(0, new PhongBanDTO
{
IDPhongBan = 0,
TenPhongBan = "Tất cả"
});
cmbPhongKham.BindDataSource(pk, q => q.IDPhongBan, q => q.TenPhongBan);
cmbPhongKham.SelectedIndex = 0;
_fillter();
}
private void _reload()
{
var src = new PhongKhamsBUS(this).GetSource();
var have = new PhongKhamsBUS(this).GetAll();
src = src.Where(q => !have.Any(a => a.PhongBan_Id == q.PhongBan_Id)).ToList();
cmbPhongBan.BindItems(src, q => q.TenPhongBan);
mDataGridView1.DataSource = new PhongKhamsBUS(this).GetAll();
}
private void _fillter()
{
var obj = cmbPhongKham.SelectedItem as PhongBanDTO;
if (obj != null)
{
var date = dateDate.Value;
var lich = new LichLamViecsBUS().GetByIDPhongBan(obj.IDPhongBan, date);
var bacsi = new PhongKhamsBUS(this).GetDoctorByPhongKham(obj.IDPhongBan);
DataTable table = new DataTable();
table.Columns.Add(new DataColumn("BS", typeof(string)));
table.Columns.Add(new DataColumn("ID_BS", typeof(int)));
foreach (var item in _lstTimeSlot)
{
table.Columns.Add(item.IDTimeSlot.ToString(), typeof(int));
table.Columns.Add($"{item.Name} ({item.HourStart?.ToString("hh\\:mm")} - {item.HourEnd?.ToString("hh\\:mm")})", typeof(bool));
}
foreach (var item in bacsi)
{
var row = table.NewRow();
row[0] = item.FullName; //BS
row[1] = item.IDDoctor; //IDBS
var bybs = lich.Where(q => q.NhanVien_Id == item.IDDoctor);
for (int i = 2; i < table.Columns.Count; i += 2)
{
int id_timeslot = int.Parse(table.Columns[i].ColumnName);
var tr = bybs.FirstOrDefault(q => q.IDTimeSlot == id_timeslot);
row[i] = tr?.IDLich ?? 0; // id
row[i + 1] = tr != null; // checkbox
}
table.Rows.Add(row);
}
mDataGridView1.DataSource = table;
mDataGridView1.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
mDataGridView1.Columns[1].Visible = false;
for (int i = 2; i < mDataGridView1.Columns.Count; i += 2)
{
mDataGridView1.Columns[i].Visible = false;
}
SetStatus();
}
}
