public void ThemThongTinCTHoaDon(eCTHoaDon newCTHD) { CTHoaDons temp = new CTHoaDons(); temp.MaHoaDon = newCTHD.MaHoaDon; temp.MaLoThuoc = newCTHD.MaLoThuoc; temp.DVT = newCTHD.DVT; temp.SoLuong = newCTHD.SoLuong; temp.GiaBan = newCTHD.GiaBan; qt.CTHoaDons.InsertOnSubmit(temp); qt.SubmitChanges(); }
public int ThemCTHD(eCTHoaDon cthd) // Thêm ct hóa đơn mới { CT_HoaDon temp = new CT_HoaDon(); temp.MaHoaDon = cthd.MaHoaDon; temp.MaHopDong = cthd.MaHopDong; temp.MaXe = cthd.MaXe; temp.TenXe = cthd.TenXe; temp.TienTT = decimal.Parse(cthd.TienTT.ToString()); temp.Gia = decimal.Parse(cthd.Gia.ToString()); db.CT_HoaDons.InsertOnSubmit(temp); db.SubmitChanges(); return(1); }
public List <eCTHoaDon> LayThongTinCTHoaDon() { var dsCTHoaDon = qt.CTHoaDons.ToList(); List <eCTHoaDon> dscthd = new List <eCTHoaDon>(); foreach (CTHoaDons item in dsCTHoaDon) { eCTHoaDon ct = new eCTHoaDon(); ct.MaHoaDon = item.MaHoaDon; ct.MaLoThuoc = item.MaLoThuoc; ct.DVT = item.DVT; ct.SoLuong = item.SoLuong; ct.GiaBan = item.GiaBan; dscthd.Add(ct); } return(dscthd); }
public List <eCTHoaDon> LayDulieu() // Lấy dữ liệu từ csdl sang lớp entity { var cthdlist = db.CT_HoaDons.ToList(); List <eCTHoaDon> ls = new List <eCTHoaDon>(); foreach (CT_HoaDon cthd in cthdlist) { eCTHoaDon t = new eCTHoaDon(); t.MaHoaDon = cthd.MaHoaDon; t.MaHopDong = cthd.MaHopDong; t.MaXe = cthd.MaXe; t.TenXe = cthd.TenXe; t.TienTT = double.Parse(cthd.TienTT.ToString()); t.Gia = double.Parse(cthd.Gia.ToString()); ls.Add(t); } return(ls); }
private void btnLapHoaDon_Click(object sender, EventArgs e) { dsHoaDon = hoadonBLL.LayThongTinHoaDon(); dsLoThuoc = loThuocBLL.LayThongTinLoThuoc(); dsBenhNhan = benhnhanBLL.LayThongTinBenhNhan(); var timkiemBN = dsBenhNhan.Where(w => w.TenBenhNhan.Equals(txtBenhNhan.Text)).ToList(); eHoaDon newHD = new eHoaDon(); eBenhNhan newBN = new eBenhNhan(); if (dsHoaDon.Count == 0) { newHD.MaHoaDon = "1"; } else { newHD.MaHoaDon = (Convert.ToInt32(dsHoaDon.Last().MaHoaDon) + 1).ToString(); } newHD.MaNhanVien = "1"; if (timkiemBN.Count == 0) { newHD.MaBenhNhan = newBN.MaBenhNhan = (dsBenhNhan.Count + 1).ToString(); newBN.TenBenhNhan = txtBenhNhan.Text; newBN.NamSinh = Convert.ToInt32(txtNamSinh.Text); newBN.SDT = txtSDT.Text; newBN.DiaChi = cbbTP.Text; if (rdNam.Checked == true) { newBN.GioiTinh = "nam"; } else { newBN.GioiTinh = "nu"; } benhnhanBLL.ThemThongTinBenhNhan(newBN); } else { newHD.MaBenhNhan = timkiemBN.First().MaBenhNhan; } newHD.NgayLapHD = DateTime.Now; newHD.TongTien = Convert.ToDecimal(lblTongTien.Text); newHD.MaDonThuoc = null; hoadonBLL.ThemThongTinHoaDon(newHD); for (int i = 0; i < dgvThuocDaChon.Rows.Count; i++) { var loThuocTimKiem = dsLoThuoc.Where(w => w.MaLoThuoc.Equals(dgvThuocDaChon.Rows[i].Cells["MaLoThuoc"].Value.ToString())); eCTHoaDon newCTHD = new eCTHoaDon(); if (dsHoaDon.Count == 0) { newCTHD.MaHoaDon = "1"; } else { newCTHD.MaHoaDon = (Convert.ToInt32(dsHoaDon.Last().MaHoaDon) + 1).ToString(); } newCTHD.MaLoThuoc = dgvThuocDaChon.Rows[i].Cells["MaLoThuoc"].Value.ToString(); newCTHD.DVT = dgvThuocDaChon.Rows[i].Cells["DVT"].Value.ToString(); newCTHD.SoLuong = Convert.ToInt32((dgvThuocDaChon.Rows[i].Cells["soluongcol"].Value)); newCTHD.GiaBan = Convert.ToDecimal((dgvThuocDaChon.Rows[i].Cells["dongiacol"].Value)); loThuocBLL.CapNhatSoLuongLoThuoc(dgvThuocDaChon.Rows[i].Cells["MaLoThuoc"].Value.ToString(), loThuocTimKiem.First().SoLuong - Convert.ToInt32((dgvThuocDaChon.Rows[i].Cells["soluongcol"].Value))); cthdBLL.ThemThongTinCTHoaDon(newCTHD); } MessageBox.Show("Tao Hoa Don Thanh Cong"); LoadSauKhiLapHD(); HienThiLoThuoc(); }
private void btnLapHoaDonKD_Click(object sender, EventArgs e) { try { dsHoaDon = hoadonBLL.LayThongTinHoaDon().OrderBy(o => o.MaHoaDon).ToList(); dsBenhNhan = benhnhanBLL.LayThongTinBenhNhan(); dsLoThuoc = loThuocBLL.LayThongTinLoThuoc(); var timKiemBN = dsBenhNhan.Where(w => w.TenBenhNhan.Equals(txtTenKhachHangKD.Text)).ToList(); eHoaDon newHD = new eHoaDon(); if (dsHoaDon.Count == 0) { newHD.MaHoaDon = "1"; } else { newHD.MaHoaDon = (Convert.ToInt32(dsHoaDon.Last().MaHoaDon) + 1).ToString(); } newHD.MaNhanVien = "1"; newHD.MaBenhNhan = timKiemBN.First().MaBenhNhan; newHD.NgayLapHD = DateTime.Now; newHD.TongTien = Convert.ToDecimal(lblTongTienKD.Text); newHD.MaDonThuoc = dgvDanhSachDonThuocKD.SelectedCells[0].OwningRow.Cells["MaDonThuoc"].Value.ToString(); hoadonBLL.ThemThongTinHoaDon(newHD); for (int i = 0; i < dgvThuocDaChonKD.Rows.Count; i++) { Check(dgvThuocDaChonKD.Rows[i].Cells["dongiacol"].Value.ToString()); var timKiemLT = dsLoThuoc.Where(w => w.MaLoThuoc.Equals(dgvThuocDaChonKD.Rows[i].Cells["malocol"].Value.ToString())).ToList(); eCTHoaDon newCTHD = new eCTHoaDon(); if (dsHoaDon.Count == 0) { newCTHD.MaHoaDon = "1"; } else { newCTHD.MaHoaDon = (Convert.ToInt32(dsHoaDon.Last().MaHoaDon) + 1).ToString(); } newCTHD.MaLoThuoc = dgvThuocDaChonKD.Rows[i].Cells["malocol"].Value.ToString(); newCTHD.DVT = dgvThuocDaChonKD.Rows[i].Cells["DVT"].Value.ToString(); if ((int)dgvThuocDaChonKD.Rows[i].Cells["SoLuong"].Value <= (int)dgvThuocDaChonKD.Rows[i].Cells["slton"].Value) { newCTHD.SoLuong = Convert.ToInt32((dgvThuocDaChonKD.Rows[i].Cells["SoLuong"].Value)); loThuocBLL.CapNhatSoLuongLoThuoc(dgvThuocDaChonKD.Rows[i].Cells["malocol"].Value.ToString(), timKiemLT.First().SoLuong - Convert.ToInt32((dgvThuocDaChonKD.Rows[i].Cells["SoLuong"].Value))); } else { newCTHD.SoLuong = Convert.ToInt32((dgvThuocDaChonKD.Rows[i].Cells["slton"].Value)); loThuocBLL.CapNhatSoLuongLoThuoc(dgvThuocDaChonKD.Rows[i].Cells["malocol"].Value.ToString(), timKiemLT.First().SoLuong - Convert.ToInt32((dgvThuocDaChonKD.Rows[i].Cells["slton"].Value))); } newCTHD.GiaBan = Convert.ToDecimal((dgvThuocDaChonKD.Rows[i].Cells["dongiacol"].Value)); cthdBLL.ThemThongTinCTHoaDon(newCTHD); MessageBox.Show("Tao Hoa Don Thanh Cong"); btnTaoLaiKD_Click(sender, e); UCBanThuocKeDon_Load(sender, e); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }