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