public FormDSDT() { InitializeComponent(); bsDSDT = new BindingSource(); ctdtBLL = new CTDonThuocBLL(); dsCTDT = new List <eCTDonThuoc>(); dtBLL = new DonThuocBLL(); dsDT = new List <eDonThuoc>(); bsBLL = new BacSiBLL(); dsBS = new List <eBacSi>(); dsBS = bsBLL.LayThongTinBacSi(); dsDT = dtBLL.LayThongTinDonThuoc(); HienThiThongTinDonThuoc(); DateTime dt = DateTime.Today; lblDate.Text = dt.ToString("dd/MM/yyyy"); AutoComplete(); tbTimKiemDT.Text = "Nhập mã đơn thuốc hoặc theo ngày"; tbTimKiemDT.ForeColor = Color.Gray; }
private void HienThiBacSi(string maDT) { bacsiBLL = new BacSiBLL(); dsBacSi = bacsiBLL.LayThongTinBacSi(); donThuocBLL = new DonThuocBLL(); dsDonThuoc = donThuocBLL.LayThongTinDonThuoc(); var infoBacSi = dsBacSi .Join(dsDonThuoc, bs => bs.MaBacSi, dt => dt.MaBacSi, (bs, dt) => new { bs, dt }) .Where(_dt => _dt.dt.MaDonThuoc.Contains(maDT)) .Select(_dt => new { TenBacSi = _dt.bs.TenBacSi }).ToList(); foreach (var item in infoBacSi) { txtTenBacSiKD.Text = item.TenBacSi; } }
// //button Đăng nhập // private void button1_Click(object sender, EventArgs e) { dsQL = qlBLL.LayThongTinQuanLy(); dsNV = nvBLL.LayThongTinNhanVien(); dsTK = tkBLL.LayThongTinTaiKhoan(); dsBS = bsBLL.LayThongTinBacSi(); var taiKhoan = dsTK.Where(tk => tk.UserName == txtTaiKhoan.Text && tk.Pass == txtMatKhau.Text) .Select(tk => tk.LoaiTK).FirstOrDefault(); var taiKhoanTest = dsTK.Where(tk => tk.UserName == txtTaiKhoan.Text && tk.Pass == txtMatKhau.Text) .Select(tk => tk.LoaiTK).Any(); if (taiKhoanTest == false) { MessageBox.Show("Sai mat khau vui long nhap lai"); } else { if (taiKhoan == "BS") { FormKeDonThuoc kd = new FormKeDonThuoc(); var tenBS = dsBS.Join(dsTK, tk => tk.MaBacSi, bs => bs.MaBS, (tk, bs) => new { tk, bs }) .Where(bs1 => bs1.bs.MaBS == bs1.tk.MaBacSi) .Select(bs2 => bs2.tk.TenBacSi).FirstOrDefault(); var maBS = dsBS.Join(dsTK, tk => tk.MaBacSi, bs => bs.MaBS, (tk, bs) => new { tk, bs }) .Where(bs1 => bs1.bs.MaBS == bs1.tk.MaBacSi) .Select(bs2 => bs2.tk.MaBacSi).FirstOrDefault(); kd.lblTen.Text = tenBS.ToString(); kd.lblMa.Text = maBS.ToString(); kd.Show(); this.Hide(); } if (taiKhoan == "NVBH") { FormBanThuoc dn = new FormBanThuoc(); var tenNV = dsNV.Join(dsTK, tk => tk.MaNhanVien, bs => bs.MaNV, (tk, bs) => new { tk, bs }) .Where(bs1 => bs1.bs.MaNV == bs1.tk.MaNhanVien) .Select(bs2 => bs2.tk.TenNhanVien).FirstOrDefault(); var maNV = dsNV.Join(dsTK, tk => tk.MaNhanVien, bs => bs.MaNV, (tk, bs) => new { tk, bs }) .Where(bs1 => bs1.bs.MaNV == bs1.tk.MaNhanVien) .Select(bs2 => bs2.tk.MaNhanVien).FirstOrDefault(); dn.lblTen.Text = tenNV.ToString(); //tạo label vào form bán hàng để hiển thị tên lên form dn.lblMa.Text = maNV.ToString(); dn.Show(); this.Hide(); } if (taiKhoan == "NVTK") { FormThongKe tk = new FormThongKe(); var tenNV = dsNV.Join(dsTK, tk1 => tk1.MaNhanVien, bs => bs.MaNV, (tk1, bs) => new { tk1, bs }) .Where(bs1 => bs1.bs.MaNV == bs1.tk1.MaNhanVien) .Select(bs2 => bs2.tk1.TenNhanVien).FirstOrDefault(); var maNV = dsNV.Join(dsTK, tk2 => tk2.MaNhanVien, bs => bs.MaNV, (tk2, bs) => new { tk2, bs }) .Where(bs1 => bs1.bs.MaNV == bs1.tk2.MaNhanVien) .Select(bs2 => bs2.tk2.MaNhanVien).FirstOrDefault(); tk.lblTen.Text = tenNV.ToString(); //tạo label vào form bán hàng để hiển thị tên lên form tk.lblMa.Text = maNV.ToString(); tk.Show(); this.Hide(); } if (taiKhoan == "QL") { FormQuanLy ql = new FormQuanLy(); var tenQL = dsQL.Join(dsTK, tk => tk.MaNQL, bs => bs.MaNQL, (tk, bs) => new { tk, bs }) .Where(bs1 => bs1.bs.MaNQL == bs1.tk.MaNQL) .Select(bs2 => bs2.tk.TenNQL).FirstOrDefault(); var maQL = dsQL.Join(dsTK, tk => tk.MaNQL, bs => bs.MaNQL, (tk, bs) => new { tk, bs }) .Where(bs1 => bs1.bs.MaNQL == bs1.tk.MaNQL) .Select(bs2 => bs2.tk.MaNQL).FirstOrDefault(); ql.lblTen.Text = tenQL.ToString(); //tạo label vào form quản lý để hiển thị tên lên form ql.lblMa.Text = maQL.ToString(); ql.Show(); this.Hide(); } } }