private void btnLuu_Click(object sender, EventArgs e) { if (txtSoLuong.Text.Trim() == "" || txtSoLuong.Text == null || Convert.ToInt32(txtSoLuong.Text) == 0) { MessageBox.Show("Vui lòng kiểm tra lại số lượng", "Lỗi"); } else if (Convert.ToInt32(txtSoLuong.Text) > Convert.ToInt32(lbSoLuongTon.Text)) { //đã xử lý sự kiện trong textleave txtSoLuong.Focus(); } else { var HDX = dt.selectTTHDX(Convert.ToInt32(lbMaHD.Text)).FirstOrDefault(); if (HDX == null) { Image QR; Zen.Barcode.CodeQrBarcodeDraw qr = Zen.Barcode.BarcodeDrawFactory.CodeQr; QR = qr.Draw(lbMaHD.Text, 50); MemoryStream stream = new MemoryStream(); QR.Save(stream, ImageFormat.Jpeg); dt.insertHDX(Convert.ToInt32(lbMaHD.Text), MaKH, FormDangNhap.ThongTinNVDangNhap.MaNVDangNhap, Convert.ToDateTime(DateTime.Now), null, stream.ToArray()); dt.insertCTHDX(Convert.ToInt32(lbMaHD.Text), Convert.ToInt32(cbbSP.SelectedValue), Convert.ToInt32(cbbSize.SelectedValue), Convert.ToInt32(cbbMau.SelectedValue), Convert.ToInt32(txtSoLuong.Text), dongia * Convert.ToInt32(txtSoLuong.Text)); dt.updateTongTienHDX(Convert.ToInt32(lbMaHD.Text), dongia * Convert.ToInt32(txtSoLuong.Text)); dt.updateSLT(Convert.ToInt32(cbbSP.SelectedValue), Convert.ToInt32(cbbSize.SelectedValue), Convert.ToInt32(cbbMau.SelectedValue), Convert.ToInt32(lbSoLuongTon.Text) - Convert.ToInt32(txtSoLuong.Text)); dgvCTHDX.AutoGenerateColumns = false; dgvCTHDX.DataSource = dt.selectCTHDX(Convert.ToInt32(lbMaHD.Text)); MessageBox.Show("Thêm thành công"); cbbSP.Enabled = false; cbbSize.Enabled = false; cbbMau.Enabled = false; btnThem.Enabled = true; btnLuu.Enabled = false; btnHuy.Enabled = true; txtSoLuong.ResetText(); lbThanhTien.Text = "0"; txtSoLuong.Enabled = false; lbTren.Visible = false; lbSoLuongTon.Visible = false; lbDonGia.Visible = false; lbThanhTien.Visible = false; } else if (HDX != null) { var CTHDX = dt.selectTTCTHDX(Convert.ToInt32(lbMaHD.Text), Convert.ToInt32(cbbSP.SelectedValue), Convert.ToInt32(cbbSize.SelectedValue), Convert.ToInt32(cbbMau.SelectedValue)).FirstOrDefault(); if (CTHDX == null) { dt.insertCTHDX(Convert.ToInt32(lbMaHD.Text), Convert.ToInt32(cbbSP.SelectedValue), Convert.ToInt32(cbbSize.SelectedValue), Convert.ToInt32(cbbMau.SelectedValue), Convert.ToInt32(txtSoLuong.Text), dongia * Convert.ToInt32(txtSoLuong.Text)); int tongtien = 0; foreach (var a in dt.selectCTHDX(Convert.ToInt32(lbMaHD.Text))) { tongtien = tongtien + Convert.ToInt32(a.ThanhTien); } dt.updateTongTienHDX(Convert.ToInt32(lbMaHD.Text), tongtien); dt.updateSLT(Convert.ToInt32(cbbSP.SelectedValue), Convert.ToInt32(cbbSize.SelectedValue), Convert.ToInt32(cbbMau.SelectedValue), Convert.ToInt32(lbSoLuongTon.Text) - Convert.ToInt32(txtSoLuong.Text)); dgvCTHDX.AutoGenerateColumns = false; dgvCTHDX.DataSource = dt.selectCTHDX(Convert.ToInt32(lbMaHD.Text)); MessageBox.Show("Thêm sản phẩm thành công"); } else if (CTHDX != null) { var TTCTHDX = dt.selectTTCTHDX(Convert.ToInt32(lbMaHD.Text), Convert.ToInt32(cbbSP.SelectedValue), Convert.ToInt32(cbbSize.SelectedValue), Convert.ToInt32(cbbMau.SelectedValue)).FirstOrDefault(); dt.updateSoLuongTTCTHDX(Convert.ToInt32(lbMaHD.Text), Convert.ToInt32(cbbSP.SelectedValue), Convert.ToInt32(cbbSize.SelectedValue), Convert.ToInt32(cbbMau.SelectedValue), (TTCTHDX.SoLuong + Convert.ToInt32(txtSoLuong.Text)), (TTCTHDX.ThanhTien + (Convert.ToInt32(txtSoLuong.Text) * dongia))); int tongtien = 0; foreach (var a in dt.selectCTHDX(Convert.ToInt32(lbMaHD.Text))) { tongtien = tongtien + Convert.ToInt32(a.ThanhTien); } dt.updateTongTienHDX(Convert.ToInt32(lbMaHD.Text), tongtien); dt.updateSLT(Convert.ToInt32(cbbSP.SelectedValue), Convert.ToInt32(cbbSize.SelectedValue), Convert.ToInt32(cbbMau.SelectedValue), Convert.ToInt32(lbSoLuongTon.Text) - Convert.ToInt32(txtSoLuong.Text)); dgvCTHDX.AutoGenerateColumns = false; dgvCTHDX.DataSource = dt.selectCTHDX(Convert.ToInt32(lbMaHD.Text)); MessageBox.Show("Thêm số lượng thành công"); } cbbSP.Enabled = false; cbbSize.Enabled = false; cbbMau.Enabled = false; btnThem.Enabled = true; btnLuu.Enabled = false; btnHuy.Enabled = true; txtSoLuong.ResetText(); lbThanhTien.Text = "0"; txtSoLuong.Enabled = false; lbTren.Visible = false; lbSoLuongTon.Visible = false; lbDonGia.Visible = false; lbThanhTien.Visible = false; gunaGradientCircleButton1.Visible = false; txtTimKiem.Visible = false; dgvSanPham.Visible = false; } } }
private void btnThem_Click(object sender, EventArgs e) { var HDX = dt.selectHoaDon(lbMaHD.Text).FirstOrDefault(); if (txtSL.Text.Trim() == "" || txtSL.Text.Trim() == null) { MessageBox.Show("Bạn chưa nhập số lượng", "Thông báo"); } else if (Convert.ToInt32(txtSL.Text) == 0) { MessageBox.Show("Số lượng phải lớn hơn 0"); } else { if (HDX == null) { Image QR; Zen.Barcode.CodeQrBarcodeDraw qr = Zen.Barcode.BarcodeDrawFactory.CodeQr; QR = qr.Draw(lbMaHD.Text, 50); MemoryStream stream = new MemoryStream(); QR.Save(stream, ImageFormat.Jpeg); dt.Insert_HoaDon(lbMaHD.Text, Convert.ToString(cbbMaKH.SelectedValue), DangNhap.TTNV.MaNV, Convert.ToDateTime(DateTime.Now), Convert.ToInt32(numericChietKhau.Value), 0, Convert.ToBoolean("true"), stream.ToArray()); dt.INSERT_CTHD(lbMaHD.Text, cbbTenSP.SelectedValue.ToString(), Convert.ToInt32(txtSL.Text), (Convert.ToDouble(txtSL.Text) * Convert.ToDouble(lbDongia.Text))); double thanhtien = 0; foreach (var a in dt.selectCTHD(lbMaHD.Text)) { thanhtien = thanhtien + Convert.ToDouble(a.GIABAN) * Convert.ToDouble(a.SL); } dt.UPDATE_ThanhTien(lbMaHD.Text, thanhtien); MessageBox.Show("Thêm thành công", "Thêm"); numericChietKhau.Enabled = false; var sp = dt.selectSP(cbbTenSP.SelectedValue.ToString()).FirstOrDefault(); label2.Text = sp.SOLUONG.ToString(); } else if (HDX != null) { var CTX = dt.selectAll_CTHD(lbMaHD.Text, cbbTenSP.SelectedValue.ToString()).FirstOrDefault(); if (CTX == null) { dt.INSERT_CTHD(lbMaHD.Text, cbbTenSP.SelectedValue.ToString(), Convert.ToInt32(txtSL.Text), (Convert.ToDouble(txtSL.Text) * Convert.ToDouble(lbDongia.Text))); double thanhtien = 0; foreach (var a in dt.selectCTHD(lbMaHD.Text)) { thanhtien = thanhtien + Convert.ToDouble(a.GIABAN) * Convert.ToDouble(a.SL); } dt.UPDATE_ThanhTien(lbMaHD.Text, thanhtien); MessageBox.Show("Thêm thành công", "Thêm"); var sp = dt.selectSP(cbbTenSP.SelectedValue.ToString()).FirstOrDefault(); label2.Text = sp.SOLUONG.ToString(); } else if (CTX != null) { dt.updateSL_CTHD(lbMaHD.Text, cbbTenSP.SelectedValue.ToString(), Convert.ToInt32(txtSL.Text) + CTX.SL, CTX.THANHTIEN + (Convert.ToDouble(txtSL.Text) * Convert.ToDouble(lbDongia.Text))); double thanhtien = 0; foreach (var a in dt.selectCTHD(lbMaHD.Text)) { thanhtien = thanhtien + Convert.ToDouble(a.GIABAN) * Convert.ToDouble(a.SL); } dt.UPDATE_ThanhTien(lbMaHD.Text, thanhtien); MessageBox.Show("Thêm thành công", "Thêm"); var sp = dt.selectSP(cbbTenSP.SelectedValue.ToString()).FirstOrDefault(); label2.Text = sp.SOLUONG.ToString(); } } } dgvHD.DataSource = dt.selectCTHD(lbMaHD.Text); txtSL.ResetText(); double TongTienHD = 0; double TongTienDiscount = 0; foreach (var a in dt.selectCTHD(lbMaHD.Text)) { TongTienHD = TongTienHD + Convert.ToDouble(a.GIABAN) * Convert.ToDouble(a.SL); } TongTienDiscount = TongTienHD - ((Convert.ToDouble(numericChietKhau.Value) * TongTienHD) * 0.01); dt.UPDATE_TONGTIEN(lbMaHD.Text, TongTienDiscount); lbTongTien.Text = TongTienDiscount.ToString("N0"); }