Example #1
0
        //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);
        }
Example #2
0
        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);
        }
Example #3
0
        //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);
        }
Example #4
0
        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);
        }
Example #5
0
        //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);
        }
Example #6
0
        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);
        }
Example #7
0
        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);
        }
Example #8
0
        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);
        }
Example #9
0
        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);
            }
        }
Example #12
0
 public LapHoaDonDTO loadThongTin(LapHoaDonDTO a)
 {
     return(lhdDao.loadThongTin(a));
 }
Example #13
0
 public bool luu(LapHoaDonDTO a)
 {
     return(lhdDao.luu(a));
 }
Example #14
0
 public LapHoaDonDTO TinhTienThuoc(LapHoaDonDTO a)
 {
     return(lhdDao.TinhTienThuoc(a));
 }
Example #15
0
 public LapHoaDonDTO KtMaPK(LapHoaDonDTO a)
 {
     return(lhdDao.KtMaPK(a));
 }
Example #16
0
 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();
            }
        }
Example #18
0
 public bool xoa(LapHoaDonDTO a)
 {
     return(lhdDao.xoa(a));
 }