public ChiTietDonThuoc(HoaDonXuat hdx) { InitializeComponent(); busBenhNhan = new BusBenhNhan(); busHDX = new BusHDX(); this.hdx = hdx; }
public bool TaoHoaDonXuat(HoaDonXuat hdx, ArrayList arrThuoc) { int i = hdxQ.InsertHDX(hdx); if (i > 0) { HoaDonXuat hdxTemp = hdxQ.SelectLastHoaDonXuat(); int MaHDX = hdxTemp.MaHDX; int j = 0; foreach (Thuoc thuoc in arrThuoc) { ChiTietHoaDonXuat chiTietHDX = new ChiTietHoaDonXuat(MaHDX, thuoc.IDThuoc, thuoc.SoLuong, thuoc.GiaBan, thuoc.Thue, thuoc.TenDVT); j += hdxQ.InsertChiTietHDX(chiTietHDX); } if (j == arrThuoc.Count) { foreach (Thuoc thuoc in arrThuoc) { hdxQ.UpdateSoLuongThuoc(thuoc.IDThuoc, thuoc.SoLuong); } return true; } else { hdxQ.DelChiTietHDXByMaHDX(MaHDX); hdxQ.DelHoaDonXuatByMaHDX(MaHDX); return false; } } else { return false; } }
public SuLyInDonThuoc(HoaDonXuat hdx,ArrayList arrList) { InitializeComponent(); busHDX = new BusHDX(); this.hdx = hdx; this.arrList = arrList; busUser = new BusUser(); }
public HoaDonXuat SelectHoaDonXuat(int _MaHDX) { SqlDataReader rd = null; rd = dbHelper.ExecuteQuery("GetHoaDonXuat_MaHDX " + _MaHDX + ""); if (rd.Read()) { HoaDonXuat hdx = new HoaDonXuat(rd.GetInt32(0), rd.GetString(1), rd.GetDateTime(2), rd.GetDecimal(3), rd.GetDouble(4), rd.GetDecimal(5)); rd.Close(); return hdx; } else { rd.Close(); return null; } }
public int InsertHDX(HoaDonXuat hdx) { List<SqlParameter> paramList = new List<SqlParameter>(); SqlParameter param = new SqlParameter(); param = new SqlParameter("@IDBN", SqlDbType.Int); param.Value = hdx.IDBN; paramList.Add(param); param = new SqlParameter("@NgayLap", SqlDbType.NVarChar); param.Value = hdx.NgayLap; paramList.Add(param); param = new SqlParameter("@TongTienThuoc", SqlDbType.Decimal); param.Value = hdx.TongTienThuoc; paramList.Add(param); param = new SqlParameter("@TongThue", SqlDbType.Float); param.Value = hdx.TongThue; paramList.Add(param); param = new SqlParameter("@TongTienHD", SqlDbType.Decimal); param.Value = hdx.TongTienHD; paramList.Add(param); int i = dbHelper.ExecuteNonQuery("HoaDonXuat_Insert", paramList); return i; }
public ArrayList SelectHDXByMaHDX(int _MaHDX) { SqlDataReader rd = dbHelper.ExecuteQuery(" GetHDXByMaHDX "+_MaHDX+" "); ArrayList arrLHDX = new ArrayList(); while (rd.Read()) { HoaDonXuat hdx = new HoaDonXuat(rd.GetInt32(0), rd.GetInt32(1), rd.GetString(2), rd.GetDateTime(3), rd.GetDecimal(4), rd.GetDouble(5), rd.GetDecimal(6), rd.GetString(7)); arrLHDX.Add(hdx); } rd.Close(); return arrLHDX; }
public ArrayList SelectAllHDX(string _MaBN, string _ToDate, string _FromDate) { _MaBN = _MaBN.Replace("'", "''"); SqlDataReader rd = dbHelper.ExecuteQuery(" DSHDX_NgayThangMaBN N'%" + _MaBN + "%','" + _ToDate + "','" + _FromDate + "' "); ArrayList arrLHDX = new ArrayList(); while (rd.Read()) { HoaDonXuat hdx = new HoaDonXuat(rd.GetInt32(0),rd.GetInt32(1), rd.GetString(2), rd.GetDateTime(3), rd.GetDecimal(4), rd.GetDouble(5), rd.GetDecimal(6), rd.GetString(7)); arrLHDX.Add(hdx); } rd.Close(); return arrLHDX; }
private void btnLuuHD_Click(object sender, EventArgs e) { if (arrLlVChiTietHDX.Count == 0) { MessageBox.Show(this, "Chưa có thuốc trong hóa đơn", "Thông báo"); txtMaThuoc.Focus(); return; } else if (benhNhanHDX == null) { MessageBox.Show(this, "Chưa có thông tin bệnh nhân", "Thông báo"); txtMaBN.Focus(); return; } else { HoaDonXuat hdx = new HoaDonXuat(benhNhanHDX.IDBN, DateTime.Now, Convert.ToDecimal(this._TienThuoc), Convert.ToDouble(this._TienThue), Convert.ToDecimal(this._TongTienHD)); SuLyInDonThuoc suLyDT = new SuLyInDonThuoc(hdx, arrLlVChiTietHDX); suLyDT.dgDT = new SuLyInDonThuoc.dgDonThuoc(TaoDonThuocOK); suLyDT.ShowDialog(); } }