//loadHoaDon public List <LapHoaDonDTO> loadHoaDon() { string query = "SELECT MaHD,MaPK,TienKham,TienThuoc,TongTien FROM dbo.HOADON where TrangThai='1'"; List <LapHoaDonDTO> lstHoaDon = new List <LapHoaDonDTO>(); SqlConnection connection = new SqlConnection(connectionString); connection.Open(); DataTable dt = DataProvider.LoadTable(query, connection); if (dt.Rows.Count == 0) { return(null); } for (int i = 0; i < dt.Rows.Count; i++) { LapHoaDonDTO ThongTinDto = new LapHoaDonDTO(); ThongTinDto.Mahd = int.Parse(dt.Rows[i]["MaHD"].ToString()); ThongTinDto.Mapk = int.Parse(dt.Rows[i]["MaPK"].ToString()); ThongTinDto.Chiphikham = float.Parse(dt.Rows[i]["TienKham"].ToString()); ThongTinDto.Chiphithuoc = float.Parse(dt.Rows[i]["TienThuoc"].ToString()); ThongTinDto.Tongtien = float.Parse(dt.Rows[i]["TongTien"].ToString()); lstHoaDon.Add(ThongTinDto); } connection.Close(); return(lstHoaDon); }
public List <LapHoaDonDTO> loadCTTT(LapHoaDonDTO a) { string query = "select CTTT.TenThuoc, CTTT.SoLuong, THUOC.DonViTinh, CTTT.DonGia from CTTT, THUOC where CTTT.TenThuoc = THUOC.TenThuoc and CTTT.MaPK = '" + a.Mapk + "'and THUOC.TrangThai='1'"; List <LapHoaDonDTO> lstCTTT = new List <LapHoaDonDTO>(); SqlConnection connection = new SqlConnection(connectionString); connection.Open(); DataTable dt = DataProvider.LoadTable(query, connection); if (dt.Rows.Count == 0) { return(null); } for (int i = 0; i < dt.Rows.Count; i++) { LapHoaDonDTO ThongTinDto = new LapHoaDonDTO(); ThongTinDto.Tenthuoc = dt.Rows[i]["TenThuoc"].ToString(); ThongTinDto.Soluong = int.Parse(dt.Rows[i]["SoLuong"].ToString()); ThongTinDto.Donvitinh = dt.Rows[i]["DonViTinh"].ToString(); ThongTinDto.Dongia = float.Parse(dt.Rows[i]["DonGia"].ToString()); lstCTTT.Add(ThongTinDto); } connection.Close(); return(lstCTTT); }
//load du lieu public List <LapHoaDonDTO> loadMaPK() { string query = "select top 20 MaPK from PHIEUKHAM where TrangThai='1' order by NgayKham desc"; List <LapHoaDonDTO> lstMaPK = new List <LapHoaDonDTO>(); SqlConnection connection = new SqlConnection(connectionString); connection.Open(); DataTable dt = DataProvider.LoadTable(query, connection); if (dt.Rows.Count == 0) { return(null); } for (int i = 0; i < dt.Rows.Count; i++) { LapHoaDonDTO dto = new LapHoaDonDTO(); dto.Mapk = int.Parse(dt.Rows[i]["MaPK"].ToString()); lstMaPK.Add(dto); } connection.Close(); return(lstMaPK); }
public bool luu(LapHoaDonDTO a) { string query = "INSERT INTO HOADON (MaPK, TienKham, TienThuoc, TongTien,TrangThai) VALUES('" + a.Mapk.ToString() + "', " + a.Chiphikham.ToString() + ", " + a.Chiphithuoc.ToString() + ", " + a.Tongtien.ToString() + ",'" + '1' + "')"; LapHoaDonDTO ThongTinDto = new LapHoaDonDTO(); SqlConnection connection = new SqlConnection(connectionString); connection.Open(); if (DataProvider.ThucThiNonQuery(query, connection) == true) { connection.Close(); return(true); } return(false); }
//xoa public bool xoa(LapHoaDonDTO a) { string query = "update HOADON set TrangThai='0' where MaHD='" + a.Mahd + "'"; LapHoaDonDTO ThongTinDto = new LapHoaDonDTO(); SqlConnection connection = new SqlConnection(connectionString); connection.Open(); if (DataProvider.ThucThiNonQuery(query, connection) == true) { connection.Close(); return(true); } return(false); }
public LapHoaDonDTO LayMaHD() { string query = "select top 1 MaHD from HOADON where TrangThai='1' order by MaHD desc"; LapHoaDonDTO ThongTinDto = new LapHoaDonDTO(); SqlConnection connection = new SqlConnection(connectionString); connection.Open(); DataTable dt = DataProvider.LoadTable(query, connection); if (dt.Rows.Count == 1) { ThongTinDto.Mahd = int.Parse(dt.Rows[0]["MaHD"].ToString()); connection.Close(); return(ThongTinDto); } connection.Close(); return(null); }
public LapHoaDonDTO KtMaPK(LapHoaDonDTO a) { string query = "select MaPK from PHIEUKHAM where MaPK='" + a.Mapk + "'and TrangThai='1'"; LapHoaDonDTO ThongTinDto = new LapHoaDonDTO(); SqlConnection connection = new SqlConnection(connectionString); connection.Open(); DataTable dt = DataProvider.LoadTable(query, connection); if (dt.Rows.Count == 1) { ThongTinDto.Mapk = int.Parse(dt.Rows[0]["MaPK"].ToString()); connection.Close(); return(ThongTinDto); } connection.Close(); return(null); }
public LapHoaDonDTO TinhTienThuoc(LapHoaDonDTO a) { string query = "select sum(DonGia) as TienThuoc from CTTT where MaPK='" + a.Mapk + "'and TrangThai='1'"; LapHoaDonDTO ThongTinDto = new LapHoaDonDTO(); SqlConnection connection = new SqlConnection(connectionString); connection.Open(); DataTable dt = DataProvider.LoadTable(query, connection); if (dt.Rows.Count == 1) { ThongTinDto.Chiphithuoc = float.Parse(dt.Rows[0]["TienThuoc"].ToString()); connection.Close(); return(ThongTinDto); } connection.Close(); return(null); }
public LapHoaDonDTO loadThongTin(LapHoaDonDTO a) { string query = "select TenBN from BENHNHAN, PHIEUKHAM where BENHNHAN.MaBN = PHIEUKHAM.MaBN and MaPK='" + a.Mapk + "'and BENHNHAN.TrangThai='1'"; LapHoaDonDTO ThongTinDto = new LapHoaDonDTO(); SqlConnection connection = new SqlConnection(connectionString); connection.Open(); DataTable dt = DataProvider.LoadTable(query, connection); if (dt.Rows.Count == 1) { ThongTinDto.Tenbn = dt.Rows[0]["TenBN"].ToString(); connection.Close(); return(ThongTinDto); } connection.Close(); return(null); }
private void luu() { LapHoaDonDTO a = new LapHoaDonDTO(); if (cmbMaPhieuKham.Text == "" || txtChiPhiKham.Text == "" || txtChiPhiThuoc.Text == "" || txtTongTien.Text == "") { MessageBox.Show("Bạn cần nhập đủ thông tin", "Thông tin", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } a.Mapk = int.Parse(cmbMaPhieuKham.Text); a.Chiphikham = float.Parse(txtChiPhiKham.Text); a.Chiphithuoc = float.Parse(txtChiPhiThuoc.Text); a.Tongtien = float.Parse(txtTongTien.Text); if (lhdBus.luu(a) == false) { MessageBox.Show("Bạn nhập sai thông tin", "Thông tin", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Bạn đã lưu thành công với mã hóa đơn là:" + lhdBus.LayMaHD().Mahd.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); txtMaHoaDon.Text = lhdBus.LayMaHD().Mahd.ToString(); loadHoaDon(); } }
private void btnXoa_Click(object sender, EventArgs e) { LapHoaDonDTO a = new LapHoaDonDTO(); try { DataGridViewRow dr = dgvThongTinHoaDon.SelectedRows[0]; a.Mahd = int.Parse(dr.Cells["MaHD"].Value.ToString()); if (lhdBus.xoa(a) == false) { MessageBox.Show("Xóa không thành công", "Thông tin", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Bạn đã xóa hóa đơn thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); loadHoaDon(); } } catch { MessageBox.Show("Bạn cần chọn mã hóa đơn cần xóa", "Thông tin", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public LapHoaDonDTO loadThongTin(LapHoaDonDTO a) { return(lhdDao.loadThongTin(a)); }
public bool luu(LapHoaDonDTO a) { return(lhdDao.luu(a)); }
public LapHoaDonDTO TinhTienThuoc(LapHoaDonDTO a) { return(lhdDao.TinhTienThuoc(a)); }
public LapHoaDonDTO KtMaPK(LapHoaDonDTO a) { return(lhdDao.KtMaPK(a)); }
public List <LapHoaDonDTO> loadCTTT(LapHoaDonDTO a) { return(lhdDao.loadCTTT(a)); }
private void loadThongTin() { LapHoaDonDTO a = new LapHoaDonDTO(); a.Mapk = int.Parse(cmbMaPhieuKham.Text); if (lhdBus.KtMaPK(a) == null) { MessageBox.Show("Không tồn tại mã phiếu khám", "error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (lhdBus.loadThongTin(a) == null) { MessageBox.Show("Không có thông tin", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { txtTenBenhNhan.Text = lhdBus.loadThongTin(a).Tenbn; } if (lhdBus.loadCTTT(a) == null) { MessageBox.Show("Không có chi tiết toa thuốc!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); this.dgvThongTinChiTiet.Columns.Clear(); } else { this.dgvThongTinChiTiet.Columns.Clear(); this.dgvThongTinChiTiet.DataSource = null; this.dgvThongTinChiTiet.AutoGenerateColumns = false; this.dgvThongTinChiTiet.AllowUserToAddRows = false; dgvThongTinChiTiet.DataSource = lhdBus.loadCTTT(a); DataGridViewTextBoxColumn tenthuocCol = new DataGridViewTextBoxColumn(); tenthuocCol.Name = "TenThuoc"; tenthuocCol.HeaderText = "Tên thuốc"; tenthuocCol.DataPropertyName = "TenThuoc"; tenthuocCol.Width = 200; this.dgvThongTinChiTiet.Columns.Add(tenthuocCol); DataGridViewTextBoxColumn soluongCol = new DataGridViewTextBoxColumn(); soluongCol.Name = "SoLuong"; soluongCol.HeaderText = "Số lượng"; soluongCol.DataPropertyName = "SoLuong"; soluongCol.Width = 200; this.dgvThongTinChiTiet.Columns.Add(soluongCol); DataGridViewTextBoxColumn donvitinhCol = new DataGridViewTextBoxColumn(); donvitinhCol.Name = "DonViTinh"; donvitinhCol.HeaderText = "Đơn vị tính"; donvitinhCol.DataPropertyName = "DonViTinh"; donvitinhCol.Width = 200; this.dgvThongTinChiTiet.Columns.Add(donvitinhCol); DataGridViewTextBoxColumn dongiaCol = new DataGridViewTextBoxColumn(); dongiaCol.Name = "DonGia"; dongiaCol.HeaderText = "Đơn giá"; dongiaCol.DataPropertyName = "DonGia"; dongiaCol.Width = 200; this.dgvThongTinChiTiet.Columns.Add(dongiaCol); CurrencyManager myCurrencyManager = (CurrencyManager)this.BindingContext[this.dgvThongTinChiTiet.DataSource]; myCurrencyManager.Refresh(); txtChiPhiThuoc.Text = lhdBus.TinhTienThuoc(a).Chiphithuoc.ToString(); txtTongTien.Text = (float.Parse(txtChiPhiThuoc.Text) + float.Parse(txtChiPhiKham.Text)).ToString(); } }
public bool xoa(LapHoaDonDTO a) { return(lhdDao.xoa(a)); }