public bool ThemHD(HoaDonNhap_DTO hd) { SqlConnection con = DataProvider.TaoKetNoi(); string query = "ThemHoaDonNhap"; SqlCommand cm = new SqlCommand(query, con); cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("@idNhanVien", hd.idNhanVien); cm.Parameters.AddWithValue("@maNCC", hd.maNCC); cm.Parameters.AddWithValue("@ngayNhap", hd.ngayNhap); cm.Parameters.AddWithValue("@tongTien", hd.tongTien); cm.Parameters.AddWithValue("@trangThai", hd.trangThai); int NumOfRow = cm.ExecuteNonQuery(); con.Close(); if (NumOfRow > 0) { return(true); } else { return(false); } }
private void btnHuyHoaDon_Click(object sender, EventArgs e) { if (MessageBox.Show("Bạn có chắc muốn hủy hóa đơn nhập này ??", "Thông Báo", MessageBoxButtons.OKCancel, MessageBoxIcon.Information) == DialogResult.OK) { HoaDonNhap_DTO hd_nhap = (lvHoaDon.Tag as HoaDonNhap_DTO); HuyNhap(hd_nhap); ResetNCC(); } }
private void btnNhapKho_Click(object sender, EventArgs e) { if (MessageBox.Show("Bạn muốn nhập hàng từ nhà cung cấp: " + txtTenNCC.Text + "\nVới tổng giá trị hàng là:" + txtTongTien.Text + " VND", "Thông Báo", MessageBoxButtons.OKCancel, MessageBoxIcon.Information) == DialogResult.OK) { HoaDonNhap_DTO hd_nhap = (lvHoaDon.Tag as HoaDonNhap_DTO); NhapKho(hd_nhap); ResetNCC(); } }
void HuyNhap(HoaDonNhap_DTO hd_nhap) { HoaDonNhap_BUS hd_bus = new HoaDonNhap_BUS(); if (hd_bus.Huy(hd_nhap.id, int.Parse(txtTongTien.Text))) { LoadHDNhap(); MessageBox.Show("Hủy Thành Công", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } txtMaNCC.Enabled = true; btnHuyHoaDon.Enabled = false; btnNhapKho.Enabled = false; }
public HoaDonNhap_DTO LayHoaDonChuaNhapTheoMaNCC(string maNCC) { HoaDonNhap_DTO hd_nhap = new HoaDonNhap_DTO(); SqlConnection con = DataProvider.TaoKetNoi(); if (con != null) { SqlCommand command = new SqlCommand(); command.CommandText = @"SELECT * FROM HoaDonNhap WHERE trangThai = 0 and maNCC = '" + maNCC + "'"; command.Connection = con; SqlDataReader dataReader = command.ExecuteReader(); if (dataReader.Read()) { if (dataReader.IsDBNull(0) != null) { hd_nhap.id = (int)dataReader[0]; } if (dataReader.IsDBNull(1) != null) { hd_nhap.idNhanVien = dataReader["idNhanvien"].ToString(); } if (dataReader.IsDBNull(2) != null) { hd_nhap.maNCC = dataReader["maNCC"].ToString(); } if (dataReader.IsDBNull(3) != null) { hd_nhap.ngayNhap = (DateTime?)dataReader["ngayNhap"]; } if (dataReader.IsDBNull(4) != null) { hd_nhap.tongTien = (int)dataReader["tongTien"]; } if (dataReader.IsDBNull(5) != null) { hd_nhap.trangThai = (int)dataReader["trangThai"]; } } dataReader.Close(); con.Close(); } return(hd_nhap); }
void NhapKho(HoaDonNhap_DTO hd_nhap) { HienThiHoaDonNhap_BUS hthdnhap_bus = new HienThiHoaDonNhap_BUS(); List <HienThiHoaDonNhap_DTO> listHTHD = hthdnhap_bus.LayDanhSachTheoIDHoaDonNhap(hd_nhap.id); BangSize_BUS size_bus = new BangSize_BUS(); foreach (HienThiHoaDonNhap_DTO item in listHTHD) { size_bus.CapNhatKho(item.idGiay, item.size, item.soLuong, item.donGia); } HoaDonNhap_BUS hd_bus = new HoaDonNhap_BUS(); if (hd_bus.NhapKho(hd_nhap.id, int.Parse(txtTongTien.Text))) { LoadHDNhap(); MessageBox.Show("Thanh Toán Thành Công", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } txtMaNCC.Enabled = true; btnHuyHoaDon.Enabled = false; btnNhapKho.Enabled = false; }
private void btnThemSP_Click(object sender, EventArgs e) { if (txtTenGiay.Text != "") { txtMaNCC.Enabled = false; HoaDonNhap_BUS hdnhap_bus = new HoaDonNhap_BUS(); ChiTietHoaDonNhap_BUS cthdnhap_bus = new ChiTietHoaDonNhap_BUS(); HoaDonNhap_DTO hd_nhap = new HoaDonNhap_DTO(); hd_nhap = hdnhap_bus.LayHoaDonChuaNhapTheoMaNCC(txtMaNCC.Text); if (hd_nhap.id == -1) { HoaDonNhap_DTO hdnhap_moi = new HoaDonNhap_DTO(-1, BienToanCuc.nvDangNhap.idNhanVien, txtMaNCC.Text, DateTime.Now, 0, 0); if (hdnhap_bus.Them(hdnhap_moi)) { ChiTietHoaDonNhap_DTO cthd_nhap = new ChiTietHoaDonNhap_DTO(hdnhap_bus.LastID(), idGiay, cbSize.Text, int.Parse(txtSoLuongNhap.Text), int.Parse(txtGiaNhap.Text)); cthdnhap_bus.Them(cthd_nhap); HienThiCTHoaDonNhap(hdnhap_bus.LastID()); lvHoaDon.Tag = hdnhap_bus.LayHoaDonChuaNhapTheoMaNCC(txtMaNCC.Text); LoadHDNhap(); } } else { ChiTietHoaDonNhap_DTO cthd_nhap = new ChiTietHoaDonNhap_DTO(hd_nhap.id, idGiay, cbSize.Text, int.Parse(txtSoLuongNhap.Text), int.Parse(txtGiaNhap.Text)); cthdnhap_bus.Them(cthd_nhap); HienThiCTHoaDonNhap(hd_nhap.id); lvHoaDon.Tag = hd_nhap; LoadHDNhap(); } ResetSP(); } else { MessageBox.Show("Vui lòng chọn sản phẩm !!", "Cảnh Báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
void LoadHDNhap() { if (txtMaNCC.Text != "") { HoaDonNhap_BUS hdnhap_bus = new HoaDonNhap_BUS(); HoaDonNhap_DTO hd_nhap = new HoaDonNhap_DTO(); hd_nhap = hdnhap_bus.LayHoaDonChuaNhapTheoMaNCC(txtMaNCC.Text); lvHoaDon.Tag = hd_nhap; if (hd_nhap.id == -1) { lvHoaDon.Items.Clear(); btnHuyHoaDon.Enabled = false; btnNhapKho.Enabled = false; txtTongTien.Text = "0"; } else { btnHuyHoaDon.Enabled = true; btnNhapKho.Enabled = true; HienThiCTHoaDonNhap(hd_nhap.id); txtTongTien.Text = hd_nhap.tongTien.ToString(); } } }
public bool Them(HoaDonNhap_DTO hd_nhap) { HoaDonNhap_DAO objHoaDonNhap_DAO = new HoaDonNhap_DAO(); return(objHoaDonNhap_DAO.ThemHD(hd_nhap)); }