private void ChiTietDonThuoc_Load(object sender, EventArgs e) { lblMaDonThuoc.Text = hdx.MaHDX.ToString(); lblNgayLap.Text = DateTimeConvert.FormatVN(hdx.NgayLap, "dd/MM/yyyy"); lblTienThuoc.Text = String.Format("{0:0,0}", Convert.ToInt32(hdx.TongTienThuoc)) + " VND"; lblTienThue.Text = hdx.TongThue.ToString(); lblTienHoaDon.Text = String.Format("{0:0,0}", Convert.ToInt32(hdx.TongTienHD)) + " VND"; benhNhan = busBenhNhan.GetBenhNhanDetails(hdx.MaBN); lblMaBN_DT.Text = benhNhan.MaBN; lblTenBN_DT.Text = benhNhan.HoTen; lblTuoiBN_DT.Text = benhNhan.Tuoi.ToString(); lblSoDienThoaiBN_DT.Text = benhNhan.DienThoai; lblDiaChiBN_DT.Text = benhNhan.DiaChi; ArrayList arrChiTietHDX = busHDX.GetAllChiTietHDX(hdx.MaHDX); foreach (ChiTietHoaDonXuat chiTietHDX in arrChiTietHDX) { ListViewItem lVItem = new ListViewItem(chiTietHDX.TenThuoc); lVItem.SubItems.Add(chiTietHDX.SoLuong.ToString()); lVItem.SubItems.Add(String.Format("{0:0,0}", Convert.ToInt32(chiTietHDX.GiaBan)) + " VND"); lVItem.SubItems.Add(chiTietHDX.Thue.ToString()); lVItem.SubItems.Add(chiTietHDX.DonVi); lVDanhSachChiTietHDX.Items.Add(lVItem); } }
public int UpdateBenhNhan(BenhNhan benhNhan) { List<SqlParameter> paramList = new List<SqlParameter>(); SqlParameter param = new SqlParameter(); param = new SqlParameter("@IDBN", SqlDbType.Int); param.Value = benhNhan.IDBN; paramList.Add(param); param = new SqlParameter("@MaBN", SqlDbType.NVarChar); param.Value = benhNhan.MaBN.Replace("'", "''"); ; paramList.Add(param); param = new SqlParameter("@HoTen", SqlDbType.NVarChar); param.Value = benhNhan.HoTen.Replace("'", "''"); ; paramList.Add(param); param = new SqlParameter("@Tuoi", SqlDbType.Int); param.Value = benhNhan.Tuoi; paramList.Add(param); param = new SqlParameter("@DiaChi", SqlDbType.NVarChar); param.Value = benhNhan.DiaChi.Replace("'", "''"); ; paramList.Add(param); param = new SqlParameter("@DienThoai", SqlDbType.NVarChar); param.Value = benhNhan.DienThoai; paramList.Add(param); int i = dbHelper.ExecuteNonQuery("UpdateBenhNhan_Haitx", paramList); return i; }
public Them_Sua_BenhNhan(BenhNhan benhNhan, int index, int mode) { InitializeComponent(); busBN = new BusBenhNhan(); this.benhNhan = benhNhan; this.mode = mode; this.index = index; busUser = new BusUser(); }
public BenhNhan SelectBenhNhanDetails(int _IDBN) { SqlDataReader rd = dbHelper.ExecuteQuery("GetBenhNhan_IDBN "+_IDBN+""); if (rd.Read()) { BenhNhan benhNhan = new BenhNhan(rd.GetInt32(0), rd.GetString(1), rd.GetString(2), rd.GetInt32(3), rd.GetString(4), rd.GetString(5)); rd.Close(); return benhNhan; } rd.Close(); return null; }
public BenhNhan SelectBenhNhanDetails(string _MaBN) { _MaBN = _MaBN.Replace("'", "''"); SqlDataReader rd = dbHelper.ExecuteQuery("GetBenhNhanDetails N'%" + _MaBN + "%'"); if (rd.Read()) { BenhNhan benhNhan = new BenhNhan(rd.GetInt32(0), rd.GetString(1), rd.GetString(2), rd.GetInt32(3), rd.GetString(4), rd.GetString(5)); rd.Close(); return benhNhan; } rd.Close(); return null; }
public ArrayList SelectAllBenhNhanByMaBN(string _MaBN) { _MaBN = _MaBN.Replace("'", "''"); SqlDataReader rd = dbHelper.ExecuteQuery("GetBenhNhanDetails N'%"+_MaBN+"%'"); ArrayList arrLBenhNhan = new ArrayList(); while (rd.Read()) { BenhNhan benhNhan = new BenhNhan(rd.GetInt32(0),rd.GetString(1), rd.GetString(2), rd.GetInt32(3), rd.GetString(4), rd.GetString(5)); arrLBenhNhan.Add(benhNhan); } rd.Close(); return arrLBenhNhan; }
private void button1_Click(object sender, EventArgs e) { if (mode == 1) { if (CheckFrom()) { BenhNhan benhNhan = new BenhNhan(txtMaBN.Text, txtHoTen.Text, Convert.ToInt32(txtTuoi.Text),txtDiaChi.Text,txtDienThoai.Text); int i = busBN.InsertBenhNhan(benhNhan); if (i > 0) { SystemLog systemLog = new SystemLog(SellMedicine.IDUser, DateTime.Now.ToString(), "Thêm bệnh nhân"); busUser.SetSystemLog(systemLog); MessageBox.Show(this,"Thêm bệnh nhân thành công!","Thông báo"); BenhNhan lastBenhNhan = busBN.GetLastBenhNhan(); dgBN(lastBenhNhan, index); this.Close(); } } } else if (mode == 2) { if (CheckFrom()) { BenhNhan benhNhan = new BenhNhan(this.benhNhan.IDBN, txtMaBN.Text, txtHoTen.Text, Convert.ToInt32(txtTuoi.Text), txtDiaChi.Text, txtDienThoai.Text); int i = busBN.UpdateBenhNhan(benhNhan); if (i > 0) { SystemLog systemLog = new SystemLog(SellMedicine.IDUser, DateTime.Now.ToString(), "Sửa thông tin bệnh nhân"); busUser.SetSystemLog(systemLog); MessageBox.Show(this, "Sửa thông tin bệnh nhân thành công!", "Thông báo"); dgBN(benhNhan,index); this.Close(); } } } }
public int UpdateBenhNhan(BenhNhan benhNhan) { return benhNhanQ.UpdateBenhNhan(benhNhan); }
public int InsertBenhNhan(BenhNhan benhNhan) { return benhNhanQ.InsertBenhNhan(benhNhan); }
private void lVDanhSachBenhNhan_DoubleClick(object sender, EventArgs e) { benhNhanHDX = (BenhNhan)arrLDSBenhNhan.ToArray()[lVDanhSachBenhNhan.FocusedItem.Index]; FillBenhNhanDetails(benhNhanHDX); plDSKQTimKiemBN.Visible = false; this.btnLuuHD.Focus(); }
public void SuaBenhNhan(BenhNhan benhNhan,int index) { arrLDSBenhNhan.RemoveAt(index); arrLDSBenhNhan.Insert(index, benhNhan); RefreshListBenhNhan(); }
public void GetNewBenhNhan(BenhNhan benhNhan,int index) { arrLDSBenhNhan.Insert(index,benhNhan); RefreshListBenhNhan(); }
public void ClearHoaDon() { arrLlVChiTietHDX.Clear(); this.ThemThuocVaoDS(); txtMaThuoc.Text = ""; txtNTBSoLuongMua.Text = ""; txtMaBN.Text = ""; lblTienThue.Text = "---"; lblTienThuoc.Text = "---"; lblTongTien.Text = "---"; benhNhanHDX = null; lblMaBN_DT.Text = "---"; lblTenBN_DT.Text = "---"; lblTuoiBN_DT.Text = "---"; lblDiaChiBN_DT.Text = "---"; lblSoDienThoaiBN_DT.Text = "---"; }
public void NhanBanDonThuoc() { if (lVSanhSachHDX.SelectedItems.Count > 0) { HoaDonXuat hdxOLD = (HoaDonXuat)arrLAllHDX.ToArray()[lVSanhSachHDX.FocusedItem.Index]; if (MessageBox.Show("Bạn có muốn tạo thêm một hóa đơn như này không?!", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { tabControl1.TabPages.Clear(); tabControl1.TabPages.Add(tPTaoDon); tPTaoDon.Text = "Tạo Đơn Thuốc Mới"; lblbtnCopy.Visible = false; lblbtnXemChiTiet.Visible = false; lblbtnXoa.Visible = true; lblbtnSua.Visible = true; benhNhanHDX = busBenhNhan.GetBenhNhanDetails(hdxOLD.IDBN); txtMaBN.Text = benhNhanHDX.MaBN; lblMaBN_DT.Text = benhNhanHDX.MaBN; lblTenBN_DT.Text = benhNhanHDX.HoTen; lblTuoiBN_DT.Text = benhNhanHDX.Tuoi.ToString(); lblDiaChiBN_DT.Text = benhNhanHDX.DiaChi; lblSoDienThoaiBN_DT.Text = benhNhanHDX.DienThoai; arrLlVChiTietHDX.Clear(); ArrayList arrlTemp = busHDX.GetAllChiTietHDX(hdxOLD.MaHDX); foreach (ChiTietHoaDonXuat chiTietHDX in arrlTemp) { Thuoc thuoc = new Thuoc(chiTietHDX.IDThuoc,chiTietHDX.MaThuoc, chiTietHDX.TenThuoc, chiTietHDX.SoLuong, chiTietHDX.GiaBan, chiTietHDX.DonVi, chiTietHDX.Thue); arrLlVChiTietHDX.Add(thuoc); } this.ThemThuocVaoDS(); this.TinhTienHDX(); } } else { MessageBox.Show(this, "Chọn một hóa đơn", "Thông báo"); } }
public void FillBenhNhanDetails(BenhNhan benhNhan) { txtMaBN.Text = benhNhan.MaBN; lblMaBN_DT.Text = benhNhan.MaBN; lblTenBN_DT.Text = benhNhan.HoTen; lblTuoiBN_DT.Text = benhNhan.Tuoi.ToString(); lblDiaChiBN_DT.Text = benhNhan.DiaChi; lblSoDienThoaiBN_DT.Text = benhNhan.DienThoai; }
public BenhNhan SelectLastBenhNhan() { SqlDataReader rd = dbHelper.ExecuteQuery("SelectLastBenhNhan_Haitx"); if (rd.Read()) { BenhNhan benhNhan = new BenhNhan(rd.GetInt32(0), rd.GetString(1), rd.GetString(2), rd.GetInt32(3), rd.GetString(4), rd.GetString(5)); rd.Close(); return benhNhan; } rd.Close(); return null; }