private void BtnXoa_Click(object sender, EventArgs e) { int blresult; blresult = 0; blresult = Convert.ToInt16(MessageBox.Show("Bạn có muốn xóa thuốc", "Xóa Thuốc", MessageBoxButtons.OKCancel, MessageBoxIcon.Exclamation)); //MessageBox.Show(blresult.ToString()); if (blresult == 1) { hd_DTO = new HoaDon_DTO(); hd_BUS = new HoaDon_BUS(); hd_DTO.MaHoaDon = mahoadon; cthd_DTO = new ChiTietHoaDon_DTO(); cthd_BUS = new ChiTietHoaDon_BUS(); cthd_DTO.MaHoaDon = mahoadon; hd_BUS.XoaHoaDon(hd_DTO); cthd_BUS.XoaChiTietHoaDon(cthd_DTO); FrmHoaDon_GUI FrmHoaDon = new FrmHoaDon_GUI(); Close(); FrmHoaDon.Show(); } }
private void bt_LapHoaDon_Click(object sender, EventArgs e) { try { if (dgv_HoaDon.Rows.Count == 0 || tb_maKH.Text == "" || dgv_KhachHang.Rows.Count == 0) { MessageBox.Show("Bạn chưa nhập mã khách hàng, hoặc hóa đơn chưa có mặt hàng!", "Thông báo"); } else { string temp = dgv_KhachHang.Rows[0].Cells["tileGG"].Value.ToString(); dgv_DTB.DataSource = HoaDon_BUS.lapHoaDon(int.Parse(tb_maKH.Text), typeHD, float.Parse(temp), float.Parse(lb_TongTien.Text)); lb_ThongBao.Text = dgv_DTB[0, 0].Value.ToString(); for (int i = 0; i < dgv_HoaDon.Rows.Count; i++) { string masp = dgv_HoaDon.Rows[i].Cells["masp2"].Value.ToString(); string soLuong = dgv_HoaDon.Rows[i].Cells["soluong2"].Value.ToString(); string dongia = dgv_HoaDon.Rows[i].Cells["dongia"].Value.ToString(); string thanhtien = dgv_HoaDon.Rows[i].Cells["tien"].Value.ToString(); ChiTietHoaDon_BUS.InsertChiTietHoaDon(int.Parse(lb_ThongBao.Text), int.Parse(masp), int.Parse(soLuong), int.Parse(dongia), int.Parse(thanhtien)); } MessageBox.Show("Thiết lập đơn hàng thành công!", "Thông báo"); ReSet_Form(sender, e); } } catch { MessageBox.Show("Hệ thống mất kết nối, vui lòng quay lại sau!", "Thông báo"); ReSet_Form(sender, e); } }
private void dataGridView1_Click_1(object sender, EventArgs e) { try { Ban_DTO Table = listView1.Tag as Ban_DTO; int MaHD = HoaDon_BUS.KTHoaDon(Table.Ma_Ban); DataGridViewRow dgvr = dataGridView1.CurrentRow; string MaSP = dgvr.Cells["MaSP"].Value.ToString(); string TenSP = dgvr.Cells["TenSP"].Value.ToString(); int SL = 1; if (MaHD == -1) { HoaDon_BUS.InsertHoaDon(Table.Ma_Ban); int Ma_HDD = ChiTietHD_DAO.GetMaHD(); ChiTietHoaDon_BUS.InsertChiTietHoaDon(Ma_HDD, MaSP, TenSP, SL); MessageBox.Show("Thêm món thành công!"); } else { ChiTietHoaDon_BUS.InsertChiTietHoaDon(MaHD, MaSP, TenSP, SL); MessageBox.Show("Thêm món thành công!"); } ShowThongTin_Ban(Table.Ma_Ban); LoadBan(); } catch { MessageBox.Show("Vui lòng chọn bàn trước khi chọn món"); } }
private void load_GridviewCTHD() { dtCTHD.Rows.Clear(); if (maHD == -1) { return; } lsCTHD = ChiTietHoaDon_BUS.SelectCTHDtheoMaHD(maHD, Mode); int n = lsCTHD.Count; double TongTienMonAn = 0; for (int i = 0; i < n; i++) { DataRow row = dtCTHD.NewRow(); row[0] = lsCTHD[i].MaMon; row[1] = lsCTHD[i].TenMon; row[2] = lsCTHD[i].Gia; row[3] = lsCTHD[i].Donvitinh; row[4] = lsCTHD[i].Soluong; row[5] = lsCTHD[i].Soluong * lsCTHD[i].Gia; dtCTHD.Rows.Add(row); TongTienMonAn += (double)row[5]; } gridDSMon.DataSource = dtCTHD; textEditTT1.Text = String.Format("{0:n}", TongTienMonAn); textEditTT2.Text = ((double.Parse(textEditVAT.Text) / 100) * TongTienMonAn).ToString(); textEditTT3.Text = ((double.Parse(textEditGiamGia.Text) / 100) * TongTienMonAn).ToString(); TextEditTongTien.Text = String.Format("{0:n}", TongTienMonAn + double.Parse(textEditTT2.Text) - double.Parse(textEditTT3.Text)); }
private void btnTru_Click(object sender, EventArgs e) { if (maHD != -1) { DataRow row = dtCTHD.Rows[indexChiTiet]; int mamon = (int)row.ItemArray[0]; ChiTietHoaDon_BUS.UpdateSoLuongCTHD(maHD, mamon, -1, Mode); load_GridviewCTHD(); } }
private void btnDongY_Click(object sender, EventArgs e) { foreach (DataRow row in dtMonAnChon.Rows) { int mamon = (int)row.ItemArray[0]; int soluong = (int)row.ItemArray[3]; ChiTietHoaDon_BUS.insertCTHD(maHD, mamon, soluong, Mode); } reloadGridViewCTHD(); this.Close(); }
private void simpleButton5_Click(object sender, EventArgs e) { try { DataRow row = dtCTHD.Rows[indexChiTiet]; int mamon = (int)row.ItemArray[0]; ChiTietHoaDon_BUS.DeleteCTHD(maHD, mamon); dtCTHD.Rows.RemoveAt(indexChiTiet); load_GridviewCTHD(); } catch (Exception) {} }
private void btnThem_Click(object sender, EventArgs e) { int blresult; blresult = 0; tienthuoc = Int32.Parse(strtienthuoc); // string tong = (txtTienKham.Text + txtTienThuoc.Text).ToString(); tongtien = tienthuoc + tienkham; blresult = Convert.ToInt16(MessageBox.Show("Bạn có muốn thêm hoa don", "Thêm Hoa Don", MessageBoxButtons.OKCancel, MessageBoxIcon.Exclamation)); //MessageBox.Show(blresult.ToString()); //Tổng tiền if (blresult == 1) { hd_DTO = new HoaDon_DTO(); hd_BUS = new HoaDon_BUS(); hd_DTO.MaHoaDon = mahoadon; hd_DTO.MaPhieuKham = cbxPhieuKham.Text; hd_DTO.MaBenhNhan = mabn; hd_DTO.Tienkham = txtTienKham.Text; hd_DTO.Tienthuoc = txtTienThuoc.Text; hd_DTO.NgayKham = txtNgayKham.Text; hd_BUS.NhapThongTinHoaDonMoi(hd_DTO); cthd_DTO = new ChiTietHoaDon_DTO(); cthd_BUS = new ChiTietHoaDon_BUS(); cthd_DTO.MaHoaDon = mahoadon; cthd_DTO.MaNhanSu = manhansu; cthd_DTO.Ngaykham = txtNgayKham.Text; cthd_DTO.Tongtien = tongtien.ToString(); cthd_BUS.NhapThongTinChiTietHoaDonMoi(cthd_DTO); FrmHoaDon_GUI FrmHoaDon = new FrmHoaDon_GUI(); Close(); FrmHoaDon.Show(); } }
private void btnThemSP_Click(object sender, EventArgs e) { if (txtTenGiay.Text != "") { txtSDTKH.Enabled = false; HoaDon_BUS hd_bus = new HoaDon_BUS(); ChiTietHoaDon_BUS cthd_bus = new ChiTietHoaDon_BUS(); HoaDon_DTO hd = new HoaDon_DTO(); hd = hd_bus.LayHoaDonChuaThanhToanTheoSDTKH(txtSDTKH.Text); if (hd.id == -1) { HoaDon_DTO hd_moi = new HoaDon_DTO(-1, BienToanCuc.nvDangNhap.idNhanVien, txtSDTKH.Text, DateTime.Now, 0, (int)numGiamGia.Value, 0, 0); if (hd_bus.Them(hd_moi)) { ChiTietHoaDon_DTO cthd = new ChiTietHoaDon_DTO(hd_bus.LastID(), idGiay, cbSize.Text, (int)numSoLuong.Value); cthd_bus.Them(cthd); HienThiCTHoaDon(hd_bus.LastID()); LoadSL(); lvHoaDon.Tag = hd_bus.LayHoaDonChuaThanhToanTheoSDTKH(txtSDTKH.Text); LoadHD(); } } else { ChiTietHoaDon_DTO cthd = new ChiTietHoaDon_DTO(hd.id, idGiay, cbSize.Text, (int)numSoLuong.Value); cthd_bus.Them(cthd); HienThiCTHoaDon(hd.id); LoadSL(); lvHoaDon.Tag = hd; LoadHD(); } } else { MessageBox.Show("Vui lòng chọn sản phẩm !!", "Cảnh Báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
private void btnDongY_Click(object sender, EventArgs e) { int count = listViewDSBanGhep.Items.Count; if (count <= 1) { MessageBox.Show("Ban phai chon it nhat 2 ban de ghep."); return; } if (indexBan != -1) { int mabanNew = lsBan[indexBan].MaBan; int maHDchon = int.Parse(listViewDSBanGhep.Items[0].SubItems[2].Text); int maBanchon_old = int.Parse(listViewDSBanGhep.Items[0].SubItems[0].Text); BanAn_BUS.UpdateTrangThaiBanAn(maBanchon_old, 0); //doc lai cthd cua maHDchon de len danh sach kiem tra trung khoa chinh DataTable dtCthdChon = ChiTietHoaDon_BUS.SelectTableCTHD(maHDchon); for (int i = 1; i < count; i++) { int maHDold = int.Parse(listViewDSBanGhep.Items[i].SubItems[2].Text); int maBanold = int.Parse(listViewDSBanGhep.Items[i].SubItems[0].Text); //giai phong cac ban cu BanAn_BUS.UpdateTrangThaiBanAn(maBanold, 0); //voi moi maHDold, cong don chi tiet hoa don, kiem tra khoa chinh DataTable dtCthdOld = ChiTietHoaDon_BUS.SelectTableCTHD(maHDold); foreach (DataRow row in dtCthdOld.Rows) { int n = dtCthdChon.Rows.Count; bool duplicate = false; //chen cac dong cua cthoadon cu vao ct hoa don chung //cong don so luong va thanh tien neu co mon an trung nhau for (int j = 0; j < n; j++) { if ((int)dtCthdChon.Rows[j].ItemArray[1] == (int)row.ItemArray[1]) { duplicate = true; int tongsl = (int)dtCthdChon.Rows[j].ItemArray[2] + (int)row.ItemArray[2]; DataRow newRow = dtCthdChon.NewRow(); newRow[0] = maHDchon; newRow[1] = (int)dtCthdChon.Rows[j].ItemArray[1]; newRow[2] = tongsl; newRow[3] = 0; //tong tien se duoc tu dong tinh lai khi insert CTHD dtCthdChon.Rows.Add(newRow); dtCthdChon.Rows.RemoveAt(j); break; } } if (!duplicate) { //chen dong DataRow newRow = dtCthdChon.NewRow(); newRow[0] = maHDchon; newRow[1] = (int)row.ItemArray[1]; newRow[2] = (int)row.ItemArray[2]; newRow[3] = (double)row.ItemArray[3]; dtCthdChon.Rows.Add(newRow); } } //xoa cthd cu ChiTietHoaDon_BUS.DeleteCTHDtheoMaHD(maHDold); //xoa hoa don cu HoaDon_BUS.DeleteHoaDon(maHDold); } //ket thuc vong lap cho cac ban ghep (tru ban dau) //xoa cthd moi (vi dtCthdChon da chua tat ca) ; nhu vay toan bo CTHD da dc xoa ChiTietHoaDon_BUS.DeleteCTHDtheoMaHD(maHDchon); //cap nhat hoa don chung HoaDon_BUS.UpdateMaBan(maHDchon, mabanNew); BanAn_BUS.UpdateTrangThaiBanAn(mabanNew, 1); //insert cac cthd moi foreach (DataRow row in dtCthdChon.Rows) { ChiTietHoaDon_BUS.insertCTHD((int)row.ItemArray[0], (int)row.ItemArray[1], (int)row.ItemArray[2], Mode); } reloadListboxBanAn(); this.Close(); } else { MessageBox.Show("Vui long chon ban muon ghep den."); } }