private void HienThiLoThuoc()
{
dsLoaiThuoc = loaithuocBLL.LayThongTinLoaiThuoc();
dsThuoc = thuocBLL.LayThongTinThuoc();
dsLoThuoc = loThuocBLL.LayThongTinLoThuoc();
var gridviewInfo = dsLoaiThuoc
.Join(dsThuoc, lt1 => lt1.MaLoaiThuoc, t => t.MaLoaiThuoc, (lt1, t) => new { lt1, t })
.Join(dsLoThuoc, _lt1 => _lt1.t.MaThuoc, lt2 => lt2.MaThuoc, (_lt1, lt2) => new { _lt1, lt2 })
.Where(w => w.lt2.TrangThai == 1)
.Select(s => new
{
MaThuoc = s._lt1.t.MaThuoc,
MaLoThuoc = s.lt2.MaLoThuoc,
TenThuoc = s._lt1.t.TenThuoc,
DVT = s.lt2.DVT,
SoLuong = s.lt2.SoLuong,
LoaiBenh = s._lt1.lt1.TenLoaiThuoc,
}).ToList();
bsDSLoThuoc.DataSource = gridviewInfo;
dgvDanhSachThuoc.DataSource = bsDSLoThuoc;
}
private void btnThem_Click(object sender, EventArgs e)
{
dsLoThuoc = lothuocBLL.LayThongTinLoThuoc().OrderBy(o => o.MaLoThuoc).ToList();
if (isThem == false)
{
isThem = true;
EnableControl(true);
btnThem.Text = "Hủy";
btnLuu.Enabled = true;
btnSua.Enabled = false;
btnThem.BackColor = Color.Red;
ClearTXT();
if (dsLoThuoc.Count == 0)
{
txtMaLoThuoc.Text = "1";
}
else
{
txtMaLoThuoc.Text = (Convert.ToInt32(dsLoThuoc.Last().MaLoThuoc) + 1).ToString();
}
dgvDanhSachThuoc.Enabled = false;
}
else
{
isThem = false;
EnableControl(false);
btnThem.Text = "Thêm";
btnLuu.Enabled = false;
btnSua.Enabled = true;
btnThem.BackColor = Color.DodgerBlue;
dgvDanhSachThuoc.Enabled = true;
}
}
private void btnThem_Click(object sender, EventArgs e)
{
dsLoThuoc = loThuocBLL.LayThongTinLoThuoc();
int soLuong;
decimal donGia;
string maThuoc = "";
if (dgvDanhSachThuocKD.SelectedCells.Count > 0)
{
btnLapHoaDonKD.Enabled = true;
btnTaoLaiKD.Enabled = true;
maThuoc = dgvDanhSachThuocKD.SelectedCells[0].OwningRow.Cells["MaThuoc"].Value.ToString();
bsThuocDaChon.Add(bsCTDonThuoc.Current);
bsCTDonThuoc.RemoveCurrent();
if (isThem == false)
{
dgvThuocDaChonKD.Columns.Add("malocol", "MaLoThuoc");
dgvThuocDaChonKD.DataSource = bsThuocDaChon;
dgvThuocDaChonKD.Columns.Add("slton", "So Luong Con");
dgvThuocDaChonKD.Columns.Add("dongiacol", "Don Gia");
dgvThuocDaChonKD.Columns.Add("tongtiencol", "TongTien");
isThem = true;
}
else
{
dgvThuocDaChonKD.DataSource = bsThuocDaChon;
}
btnHuy.Enabled = true;
}
var thongtinLoThuoc = dsLoThuoc.Where(lt => lt.MaThuoc.Equals(maThuoc)).ToList();
dgvThuocDaChonKD.Rows[dgvThuocDaChonKD.Rows.Count - 1].Cells["malocol"].Value = thongtinLoThuoc.First().MaLoThuoc;
dgvThuocDaChonKD.Rows[dgvThuocDaChonKD.Rows.Count - 1].Cells["dongiacol"].Value = thongtinLoThuoc.First().DonGia;
dgvThuocDaChonKD.Rows[dgvThuocDaChonKD.Rows.Count - 1].Cells["slton"].Value = thongtinLoThuoc.First().SoLuong;
if ((int)dgvThuocDaChonKD.Rows[dgvThuocDaChonKD.Rows.Count - 1].Cells["slton"].Value < (int)dgvThuocDaChonKD.Rows[dgvThuocDaChonKD.Rows.Count - 1].Cells["SoLuong"].Value)
{
dgvThuocDaChonKD.Rows[dgvThuocDaChonKD.Rows.Count - 1].Cells["slton"].Style.ForeColor = Color.Red;
}
soLuong = Convert.ToInt32(dgvThuocDaChonKD.Rows[dgvThuocDaChonKD.Rows.Count - 1].Cells["slton"].Value);
donGia = Convert.ToDecimal(dgvThuocDaChonKD.Rows[dgvThuocDaChonKD.Rows.Count - 1].Cells["dongiacol"].Value);
dgvThuocDaChonKD.Rows[dgvThuocDaChonKD.Rows.Count - 1].Cells["tongtiencol"].Value = soLuong * donGia;
tongTien = tongTien + Convert.ToDecimal(dgvThuocDaChonKD.Rows[dgvThuocDaChonKD.Rows.Count - 1].Cells["tongtiencol"].Value);
lblTongTienKD.Text = tongTien.ToString();
if (dgvDanhSachThuocKD.Rows.Count == 0)
{
btnThem.Enabled = false;
}
dgvThuocDaChonKD.Columns["tongtiencol"].ReadOnly = true;
dgvThuocDaChonKD.Columns["slton"].ReadOnly = true;
lockDgvDonThuoc(dgvThuocDaChonKD.Rows.Count);
}
public UCThongKeDoanhThu()
{
cthdBLL = new CTHoaDonBLL();
hdBLL = new HoaDonBLL();
dsHD = new List <eHoaDon>();
dsCTHD = new List <eCTHoaDon>();
ltBLL = new LoThuocBLL();
dsLT = new List <eLoThuoc>();
InitializeComponent();
dsLT = ltBLL.LayThongTinLoThuoc();
dsHD = hdBLL.LayThongTinHoaDon();
dsCTHD = cthdBLL.LayThongTinCTHoaDon();
HienThiThongTinThongKe();
tabControl1.SelectedIndex = 0;
DateTime day = DateTime.Today;
lblNgay.Text = day.ToString("dd/MM/yyyy");
}
private void btnThem_Click(object sender, EventArgs e)
{
string maThuoc = dgvDanhSachThuocKD.CurrentRow.Cells[0].Value.ToString();
dsLT = ltBLL.LayThongTinLoThuoc();
if (textBoxTimKiemThuocKD.Text == "Nhập tên thuốc") /*Them thuoc khong can tim kiem*/
{
if (dgvDanhSachThuocKD.CurrentRow.Index >= 0)
{
var gridviewInfo = dsLT
.Where(t1 => t1.MaThuoc.Contains(maThuoc))
.Select(t2 => new
{
DVT = t2.DVT,
}).ToList();
bsThuocDaChon.Add(bs.Current);
dgvThuocDaChonKD.DataSource = bsThuocDaChon;
foreach (var item in gridviewInfo)
{
dgvThuocDaChonKD.Rows[dgvThuocDaChonKD.Rows.Count - 1].Cells["donvicol"].Value = item.DVT;
}
dgvThuocDaChonKD.Columns[0].DisplayIndex = 4;
dgvThuocDaChonKD.Columns[1].DisplayIndex = 5;
dgvThuocDaChonKD.Columns[2].DisplayIndex = 6;
dgvThuocDaChonKD.Columns[2].Width = 223;
dgvThuocDaChonKD.Columns[4].HeaderText = "Tên Thuốc";
dgvThuocDaChonKD.Columns[3].Visible = false;
dgvThuocDaChonKD.Columns[5].Visible = false;
dgvThuocDaChonKD.Columns[6].Visible = false;
dgvThuocDaChonKD.Rows[dgvThuocDaChonKD.Rows.Count - 1].Cells[1].Value = 1;
dgvThuocDaChonKD.Rows[dgvThuocDaChonKD.Rows.Count - 1].Cells[2].Value = "3 viên/1 ngày";
bs.RemoveCurrent();
}
}
else /*Tim kiem thuoc roi them*/
{
int i;
dgvDanhSachThuocKD.DataSource = bs;
for (i = 0; i < bs.Count; i++)
{
if (maThuoc == dgvDanhSachThuocKD.Rows[i].Cells[0].Value.ToString())
{
dgvDanhSachThuocKD.CurrentCell = dgvDanhSachThuocKD.Rows[i].Cells[0];
dgvDanhSachThuocKD.CurrentCell.Selected = true;
}
}
var gridviewInfo = dsLT
.Where(t1 => t1.MaThuoc.Contains(maThuoc))
.Select(t2 => new
{
DVT = t2.DVT,
}).ToList();
bsThuocDaChon.Add(bs.Current);
dgvThuocDaChonKD.DataSource = bsThuocDaChon;
foreach (var item in gridviewInfo)
{
dgvThuocDaChonKD.Rows[dgvThuocDaChonKD.Rows.Count - 1].Cells["donvicol"].Value = item.DVT;
}
dgvThuocDaChonKD.Columns[0].DisplayIndex = 4;
dgvThuocDaChonKD.Columns[1].DisplayIndex = 5;
dgvThuocDaChonKD.Columns[2].DisplayIndex = 6;
dgvThuocDaChonKD.Columns[4].HeaderText = "Tên Thuốc";
dgvThuocDaChonKD.Columns[3].Visible = false;
dgvThuocDaChonKD.Columns[5].Visible = false;
dgvThuocDaChonKD.Columns[6].Visible = false;
dgvThuocDaChonKD.Rows[dgvThuocDaChonKD.Rows.Count - 1].Cells[1].Value = 1;
dgvThuocDaChonKD.Rows[dgvThuocDaChonKD.Rows.Count - 1].Cells[2].Value = "3 viên/1 ngày";
bs.RemoveCurrent();
textBoxTimKiemThuocKD.Text = "Nhập tên thuốc";
textBoxTimKiemThuocKD.ForeColor = Color.Gray;
}
btnThem.Enabled = false;
dgvDanhSachThuocKD.ClearSelection();
dgvThuocDaChonKD.ClearSelection();
}
