private void frmNguyenLieu_Load(object sender, EventArgs e)
{
chkTrangThai.Checked = true;
dgvDSNguyenLieu.AutoGenerateColumns = false;
txtMaNL.Enabled = false;
DataGridViewComboBoxColumn dgvcolNL = (DataGridViewComboBoxColumn)dgvDSNguyenLieu.Columns["colLoaiNL"];
DataTable dtNguyenLieu = LoaiNguyenLieuBUS.LoadDSLoaiNguyenLieu();
// Đỗ dữ liệu cho cbo trong dgv
dgvcolNL.DataSource = dtNguyenLieu;
dgvcolNL.DisplayMember = "TenLoaiNL";
dgvcolNL.ValueMember = "MaLoaiNL";
// Đỗ dữ liệu cho cbo LoaiNguyenLieu
cboLoaiNL.DataSource = dtNguyenLieu;
cboLoaiNL.DisplayMember = "TenLoaiNL";
cboLoaiNL.ValueMember = "MaLoaiNL";
DataGridViewComboBoxColumn dgvcolNCC = (DataGridViewComboBoxColumn)dgvDSNguyenLieu.Columns["colNhaCungCap"];
DataTable dtNhaCungCap = NhaCungCapBUS.LayDSNhaCungCap();
// Đỗ dữ liệu cho cbo trong dgv
dgvcolNCC.DataSource = dtNhaCungCap;
dgvcolNCC.DisplayMember = "TenNhaCC";
dgvcolNCC.ValueMember = "MaNCC";
// Đỗ dữ liệu cho cbo NhaCungCap
cboNhaCC.DataSource = dtNhaCungCap;
cboNhaCC.DisplayMember = "TenNhaCC";
cboNhaCC.ValueMember = "MaNCC";
LoadDSNguyenLieu();
AddStatus(1);
RefeshForm();
}
private void grv_DonNhapHang_SelectionChanged(object sender, EventArgs e)
{
try
{
grv_DonNhapHang[0, 0].Selected = true;
grv_DonNhapHang.CurrentRow.Selected = true;
grboxChiTietDonNhapHangTab2.Text = "CHI TIẾT ĐƠN NHẬP CỦA ĐƠN SỐ " + grv_DonNhapHang.SelectedRows[0].Cells["COLMADONNHAP"].FormattedValue.ToString();
HienThiDSChiTietDonNhap();
NhaCungCapBUS nccBus = new NhaCungCapBUS();
string tenNCC = nccBus.TimTenTheoMaDonNhap(grv_DonNhapHang.SelectedRows[0].Cells["COLMADONNHAP"].FormattedValue.ToString());
grv_NhaCungCap.ClearSelection();
foreach (DataGridViewRow row in grv_NhaCungCap.Rows)
{
if (grv_NhaCungCap[1, row.Index].Value.ToString() == tenNCC)
{
grv_NhaCungCap.Rows[row.Index].Selected = true;
btn_sendNCC.Text = "GỬI ĐƠN NHẬP HÀNG CHO NCC " + tenNCC;
}
}
if ((bool)grv_DonNhapHang.SelectedRows[0].Cells["COLTRANGTHAIXACNHAN"].Value == false)
{
this.btn_sendNCC.Enabled = true;
}
else
{
this.btn_sendNCC.Enabled = false;
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
private void btnRemove_Click(object sender, EventArgs e)
{
foreach (DataGridViewRow row in dtgvNhaCungCap.Rows)
{
bool check = true;
try
{
bool chk = bool.TryParse(row.Cells["check"].Value.ToString(), out check);
}
catch (Exception)
{
check = false;
}
if (check)
{
try
{
string MNCC = row.Cells["MANCC"].Value.ToString();
NhaCungCapBUS NCC = new NhaCungCapBUS();
NCC.removeNCC(MNCC);
}
catch
{
MessageBox.Show("Có lỗi Xảy Ra", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
refreshDTGV();
}
private void LayDanhSachNhaCungCap()
{
NhaCungCapBUS itemBUS = new NhaCungCapBUS();
BindingList <NhaCungCapDTO> danhSach = itemBUS.LayDanhSach();
danhSach.AllowEdit = danhSach.AllowNew = danhSach.AllowRemove = true;
gcDanhMucNhaCungCap.DataSource = danhSach;
NhomNhaCungCapBUS nhomNhaCungCapBUS = new NhomNhaCungCapBUS();
BindingList <NhomNhaCungCapDTO> dsNhomNhaCungCap = nhomNhaCungCapBUS.LayDanhSach();
RepositoryItemLookUpEdit repositoryItem = new RepositoryItemLookUpEdit();
repositoryItem.DataSource = dsNhomNhaCungCap;
repositoryItem.PopulateColumns();
foreach (LookUpColumnInfo col in repositoryItem.Columns)
{
if (col.FieldName == "Id" || col.FieldName == "GhiChu")
{
col.Visible = false;
}
}
repositoryItem.DisplayMember = "TenNhomNhaCungCap";
repositoryItem.ValueMember = "Id";
gvDanhMucNhaCungCap.Columns["IdNhomNhaCungCap"].ColumnEdit = repositoryItem;
}
void LoadData()
{
List <NhaCungCap> nhaCungCap = new List <NhaCungCap>();
NhaCungCapBUS busNhaCungCap = new NhaCungCapBUS();
nhaCungCap = busNhaCungCap.GetList();
dataGrid.Items.Clear();
id = 1;
foreach (NhaCungCap i in nhaCungCap)
{
ThongTinNhaCungCap thongTinNhaCungCap = new ThongTinNhaCungCap();
thongTinNhaCungCap.MaNhaCungCap = i.MaNCC;
thongTinNhaCungCap.TenNhaCungCap = i.TenNCC;
thongTinNhaCungCap.DiaChi = i.DiaChiNCC;
thongTinNhaCungCap.SoDienThoai = i.DienThoai;
dataGrid.IsReadOnly = true;
dataGrid.Items.Add(thongTinNhaCungCap);
if (id < int.Parse(i.MaNCC))
{
id = int.Parse(i.MaNCC);
}
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
try
{
NHACUNGCAP NCC = new NHACUNGCAP();
NCC.MANCC = tbMaNCCAddNhaCungCap.Text;
NCC.TENNCC = tbTenNCCAddNhaCungCap.Text;
NCC.DIACHI = rtbDiaChiAddNhaCC.Text;
NCC.SDT = tbSDTaddNhaCC.Text;
NCC.FAX = tbFaxAddNhaCC.Text;
NCC.EMAIL = tbEmailAddNhaCC.Text;
NhaCungCapBUS NCCBUS = new NhaCungCapBUS();
NCCBUS.InsertNCC(NCC);
this.Dispose();
}
catch
{
tbMaNCCAddNhaCungCap.Clear();
tbTenNCCAddNhaCungCap.Clear();
rtbDiaChiAddNhaCC.Clear();
tbSDTaddNhaCC.Clear();
tbFaxAddNhaCC.Clear();
tbEmailAddNhaCC.Clear();
MessageBox.Show("Có lỗi Xảy Ra", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
//Nhà cung cấp
void LoadDsNCC()
{
NhaCungCapBUS nccBUS = new NhaCungCapBUS();
dtgvNhaCungCap.AutoGenerateColumns = false;
dtgvNhaCungCap.DataSource = nccBUS.LoadDsNCC();
}
private void chkNhaCungCap_CheckedChanged(object sender, EventArgs e)
{
if (chkNhaCungCap.Checked)
{
XoaForm();
btnCapNhat.Visible = false;
btnThem.Visible = false;
btnXoa.Visible = false;
btnLamMoi.Visible = false;
btnKhoiPhuc.Visible = true;
txtTenNCC.Enabled = txtEmailNCC.Enabled = txtSDTNCC.Enabled = rtbDiaChiNCC.Enabled = false;
dgvDSNhaCC.DataSource = NhaCungCapBUS.LayDSNhaCungCapBiXoa();
if (dgvDSNhaCC.Rows.Count > 0)
{
btnKhoiPhuc.Enabled = true;
}
else
{
btnKhoiPhuc.Enabled = false;
}
}
else
{
txtTenNCC.Enabled = txtEmailNCC.Enabled = txtSDTNCC.Enabled = rtbDiaChiNCC.Enabled = true;
btnKhoiPhuc.Visible = false;
btnLamMoi.Visible = true;
LoadDSNhaCungCap();
}
}
private void simpleButton1_Click(object sender, EventArgs e)
{
frmThemNCC frm = new frmThemNCC();
frm.ShowDialog();
gridControl1.DataSource = NhaCungCapBUS.DanhSach();
}
public frmThemHangHoa()
{
InitializeComponent();
txtMaHang.Text = HangHoaBUS.LayMaHH();
txtMaVach.Text = HangHoaBUS.LayMaHH();
gridlookupPhanLoaiHangHoa.Properties.DataSource = PhanLoaiHangHoaBUS.DanhSach();
gridlookupPhanLoaiHangHoa.Properties.DisplayMember = "TenPhanLoai";
gridlookupPhanLoaiHangHoa.Properties.ValueMember = "MaPhanLoai";
gridlookupKho.Properties.DataSource = KhoHangBUS.DanhSach();
gridlookupKho.Properties.DisplayMember = "Ten";
gridlookupKho.Properties.ValueMember = "MaKho";
gridlookupLoaiHangHoa.Properties.DataSource = NhomHangBUS.DanhSach();
gridlookupLoaiHangHoa.Properties.DisplayMember = "Ten";
gridlookupLoaiHangHoa.Properties.ValueMember = "MaNHH";
gridlookupNCC.Properties.DataSource = NhaCungCapBUS.DanhSach();
gridlookupNCC.Properties.DisplayMember = "TenNCC";
gridlookupNCC.Properties.ValueMember = "MaNCC";
gridlookupDonVi.Properties.DataSource = DonViBUS.DanhSach();
gridlookupDonVi.Properties.DisplayMember = "Ten";
gridlookupDonVi.Properties.ValueMember = "MaDV";
}
void LoadComboboxTenNCC()
{
NhaCungCapBUS nccBUS = new NhaCungCapBUS();
cboNhaCungCap.DataSource = nccBUS.LoadDsNCC();
cboNhaCungCap.DisplayMember = "Tenncc";
cboNhaCungCap.ValueMember = "Mancc";
}
private void frmLapPhieuDat_Load(object sender, EventArgs e)
{
cboNCC.DataSource = NhaCungCapBUS.DanhSachNCC();
cboNCC.DisplayMember = "TenNhaCungCap";
cboNCC.ValueMember = "MaNhaCungCap";
dgvDanhSach.AllowUserToAddRows = false;
dtkNgayDat.Value = DateTime.Now;
dgvDanhSach.Rows.Clear();
}
private void frmThemSP_Load(object sender, EventArgs e)
{
cbbLoai.DataSource = SanPhamBUS.GetAllLoai();
cbbLoai.ValueMember = "MaLoai";
cbbLoai.DisplayMember = "TenLoai";
cbbNCC.DataSource = NhaCungCapBUS.GetAllNCC();
cbbNCC.ValueMember = "MaNCC";
cbbNCC.DisplayMember = "TenNCC";
}
private void btnLamMoi_Click(object sender, EventArgs e)
{
XuLyAnHienButton(true);
nccDTO = null;
string maNCC = NhaCungCapBUS.LayMaxMaNCC();
txtMaNCC.Text = maNCC;
DuaDuLieuChoThongTinNCC();
}
private void loadDB()
{
NhaKhoBUS nhaKhoBUS = new NhaKhoBUS();
cbbMaKhoAddSanPham.DataSource = nhaKhoBUS.loadMANK();
NhaCungCapBUS nhaCungCapBUS = new NhaCungCapBUS();
cbbMaNCCAddSanPham.DataSource = nhaCungCapBUS.loadMANCC();
}
void initBUS()
{
hangHoaBUS = new HangHoaBUS();
khoBUS = new KhoBUS();
nhomHangBUS = new NhomHangBUS();
donViBUS = new DonViBUS();
nhaCungCapBUS = new NhaCungCapBUS();
HH = new HangHoaO();
}
public frmThemNCC()
{
InitializeComponent();
txtMaNCC.Text = NhaCungCapBUS.LayMaNCC();
gridlookupKhuVuc.Properties.DataSource = KhuVucBUS.DanhSach();
gridlookupKhuVuc.Properties.DisplayMember = "TenKhuVuc";
gridlookupKhuVuc.Properties.ValueMember = "MaKhuVuc";
}
private void frmNguyenLieu_Activated(object sender, EventArgs e)
{
cboLoaiNL.DataSource = LoaiNguyenLieuBUS.LoadDSLoaiNguyenLieu();
cboLoaiNL.DisplayMember = "TenLoaiNL";
cboLoaiNL.ValueMember = "MaLoaiNL";
cboNhaCC.DataSource = NhaCungCapBUS.LayDSNhaCungCap();
cboNhaCC.DisplayMember = "TenNhaCC";
cboNhaCC.ValueMember = "MaNCC";
}
private void LoadNhaCungCap()
{
lkpNhaCungCap.Properties.DataSource = NhaCungCapBUS.KiemTraLoad();
lkpNhaCungCap.Properties.DisplayMember = "TenNhaPhanPhoi";
lkpNhaCungCap.Properties.ValueMember = "MaNhaCungCap";
if (!ReferenceEquals(((List <NhaCungCapDTO>)lkpNhaCungCap.Properties.DataSource)[0], null))
{
lkpNhaCungCap.EditValue = ((List <NhaCungCapDTO>)lkpNhaCungCap.Properties.DataSource)[0].MaNhaCungCap;
}
}
private void UC_SanPham_Load(object sender, EventArgs e)
{
dgvNhanVien.DataSource = SanPhamBUS.GetAllSanPham();
cbbNCC.DataSource = NhaCungCapBUS.GetAllNCC();
cbbNCC.ValueMember = "MaNCC";
cbbNCC.DisplayMember = "TenNCC";
cbbLoai.DataSource = SanPhamBUS.GetAllLoai();
cbbLoai.ValueMember = "MaLoai";
cbbLoai.DisplayMember = "TenLoai";
}
private void simpleButton2_Click(object sender, EventArgs e)
{
int Vitri = gridView1.GetFocusedDataSourceRowIndex();
string MaNCC = gridView1.GetRowCellValue(Vitri, "MaNCC").ToString();
frmSuaNCC frm = new frmSuaNCC();
SendData s = new SendData(frm.GetData);
s(MaNCC);
frm.ShowDialog();
gridControl1.DataSource = NhaCungCapBUS.DanhSach();
}
private void txtTimKiemNCC_TextChanged(object sender, EventArgs e)
{
if (txtTimKiemNCC.Text == "")
{
LoadDSNhaCungCap();
}
else
{
string tKiem = "%" + txtTimKiemNCC.Text + "%";
dgvDSNhaCC.DataSource = NhaCungCapBUS.TimKiemNCC(tKiem);
}
}
private void gvDanhMucNhaCungCap_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e)
{
if (gvDanhMucNhaCungCap.FocusedRowHandle > -1)
{
try
{
NhaCungCapDTO itemDTO = new NhaCungCapDTO();
NhaCungCapBUS itemBUS = new NhaCungCapBUS();
itemDTO.MaNhaCungCap = gvDanhMucNhaCungCap.GetFocusedRowCellValue("MaNhaCungCap").ToString();
itemDTO.TenNhaCungCap = gvDanhMucNhaCungCap.GetFocusedRowCellValue("TenNhaCungCap").ToString();
itemDTO.IdNhomNhaCungCap = int.Parse(gvDanhMucNhaCungCap.GetFocusedRowCellValue("IdNhomNhaCungCap").ToString());
itemDTO.DiaChi = gvDanhMucNhaCungCap.GetFocusedRowCellValue("DiaChi").ToString();
itemDTO.DienThoai = gvDanhMucNhaCungCap.GetFocusedRowCellValue("DienThoai").ToString();
itemDTO.Email = gvDanhMucNhaCungCap.GetFocusedRowCellValue("Email").ToString();
itemDTO.SoTaiKhoan = gvDanhMucNhaCungCap.GetFocusedRowCellValue("SoTaiKhoan").ToString();
itemDTO.TenNganHang = gvDanhMucNhaCungCap.GetFocusedRowCellValue("TenNganHang").ToString();
itemDTO.TenChiNhanh = gvDanhMucNhaCungCap.GetFocusedRowCellValue("TenChiNhanh").ToString();
itemDTO.GhiChu = gvDanhMucNhaCungCap.GetFocusedRowCellValue("GhiChu").ToString();
itemDTO.Id = int.Parse(gvDanhMucNhaCungCap.GetFocusedRowCellValue("Id").ToString());
if (this.flagThem && gvDanhMucNhaCungCap.FocusedRowHandle == gvDanhMucNhaCungCap.RowCount - 2)
{
if (itemDTO.MaNhaCungCap.Length > 0)
{
DialogResult hopThoai = MessageBox.Show("Bạn chắc chắn muốn thêm mới?", "Thêm mới", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (hopThoai == DialogResult.Yes)
{
itemBUS.Them(itemDTO);
this.flagThem = false;
}
}
else
{
MessageBox.Show("Bạn chưa nhập mã!", "Cảnh báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
DialogResult hopThoai = MessageBox.Show("Bạn chắc chắn muốn cập nhật?", "Cập nhật", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (hopThoai == DialogResult.Yes)
{
itemBUS.Sua(itemDTO);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
this.LayDanhSachNhaCungCap();
}
}
private void refreshDTGV()
{
dtgvNhaCungCap.Rows.Clear();
int ID = dtgvNhaCungCap.Rows.Count + 1;
NhaCungCapBUS NV = new NhaCungCapBUS();
foreach (NHACUNGCAP item in NV.loadSeach(textBox1.Text))
{
dtgvNhaCungCap.Rows.Add(ID, item.MANCC, item.TENNCC, item.DIACHI, item.SDT, item.FAX, item.EMAIL);
ID++;
}
}
public FormNhaCungCap()
{
InitializeComponent();
themOrSua = 1;
nhaCungCapBUS = new NhaCungCapBUS();
NCC = new NhaCungCapO();
khuVucBUS = new KhuVucBUS();
// load lookupEdit khu vuc
lueKhuVuc.Properties.DataSource = khuVucBUS.getAllKhuVuc();
lueKhuVuc.Properties.DisplayMember = "TenKhuVuc";
lueKhuVuc.Properties.ValueMember = "MaKhuVuc";
}
public UCLichSuMuaHang()
{
InitializeComponent();
ucmh = new UCMuaHang();
MH = new MuaHangO();
CTPMH = new ChiTietPhieuMuaHangO();
TK = new TonKhoO();
muaHangBUS = new MuaHangBUS();
nhaCungCapBUS = new NhaCungCapBUS();
chiTietPhieuMuaHangBUS = new ChiTietPhieuMuaHangBUS();
tonKhoBUS = new TonKhoBUS();
}
public frmMuaHang()
{
InitializeComponent();
repositoryItemGridLookUpEdit8.DataSource = PhieuTempBUS.DanhSachHangHienThi();
repositoryItemGridLookUpEdit8.NullText = "";
repositoryItemGridLookUpEdit8.DisplayMember = "MaHang";
repositoryItemGridLookUpEdit8.ValueMember = "MaHang";
repositoryItemGridLookUpEdit9.DataSource = PhieuTempBUS.DanhSachHangHienThi();
repositoryItemGridLookUpEdit9.NullText = "";
repositoryItemGridLookUpEdit9.DisplayMember = "TenHang";
repositoryItemGridLookUpEdit9.ValueMember = "MaHang";
repositoryItemGridLookUpEdit10.DataSource = PhieuTempBUS.DanhSachHangHienThi();
repositoryItemGridLookUpEdit10.NullText = "";
repositoryItemGridLookUpEdit10.DisplayMember = "TenDonVi";
repositoryItemGridLookUpEdit10.ValueMember = "MaDonVi";
gridControl2.DataSource = PhieuTempBUS.DanhSach();
txtNCC.Properties.DataSource = NhaCungCapBUS.DanhSach();
txtNCC.Properties.DisplayMember = "TenNCC";
txtNCC.Properties.ValueMember = txtMaNCC.Properties.ValueMember;
txtNCC.Properties.EditValueChanged += Properties_EditValueChanged;
txtNCC.Properties.NullText = "";
txtMaNCC.Properties.DataSource = NhaCungCapBUS.DanhSach();
txtMaNCC.Properties.DisplayMember = "MaNCC";
txtMaNCC.Properties.ValueMember = "MaNCC";
txtMaNCC.Properties.EditValueChanged += Properties_EditValueChanged1;
txtMaNCC.Properties.NullText = "";
txtPhieu.Text = PhieuNhapHangBUS.LayMaPhieu();
txtNhanVien.Properties.DataSource = NhanVienBUS.DanhSach();
txtNhanVien.Properties.DisplayMember = "Ten";
txtNhanVien.Properties.ValueMember = "MaNV";
txtDieuKhoanTT.Properties.DataSource = DieuKhoanThanhToanBUS.DanhSach();
txtDieuKhoanTT.Properties.DisplayMember = "TenDKTT";
txtDieuKhoanTT.Properties.ValueMember = "MaDKTT";
txtHinhThucTT.Properties.DataSource = HinhThucThanhToanBUS.DanhSach();
txtHinhThucTT.Properties.DisplayMember = "TenHTTT";
txtHinhThucTT.Properties.ValueMember = "MaHTTT";
txtKho.Properties.DataSource = KhoHangBUS.DanhSach();
txtKho.Properties.DisplayMember = "Ten";
txtKho.Properties.ValueMember = "MaKho";
}
private void btnKhoiPhuc_Click(object sender, EventArgs e)
{
if (NhaCungCapBUS.KhoiPhucNhaCungCap(Convert.ToInt32(txtMaNhaCungCap.Text)))
{
MessageBox.Show("Khôi phục thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
LamMoiNhaCungCap();
LoadDanhSachNhaCungCapDaXoa();
dgvNhaCungCap.ClearSelection();
}
else
{
MessageBox.Show("Khôi phục thất bại!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void LoadNhaCungCap()
{
lkpTenNCC.Properties.DataSource = NhaCungCapBUS.KiemTraLoad();
lkpTenNCC.Properties.DisplayMember = "TenNhaPhanPhoi";
lkpTenNCC.Properties.ValueMember = "MaNhaCungCap";
// hàm so sánh 2 đối tượng
//kiểm tra xem nếu dữ liệu đầu tiên trong datasource có rỗng hay không ?
//nếu không rõng thì hiển thị thông tin đầu tiên của nhà cung cấp đó lên
if (!ReferenceEquals(((List <NhaCungCapDTO>)lkpTenNCC.Properties.DataSource)[0], null))
{
lkpTenNCC.EditValue = ((List <NhaCungCapDTO>)lkpTenNCC.Properties.DataSource)[0].MaNhaCungCap;
}
}
private void HienThiNhaCungCapTheoTuKhoa(string keyword)
{
NhaCungCapBUS nhaCungCapBUS = new NhaCungCapBUS();
List <NhaCungCapDTO> allNCC = nhaCungCapBUS.TimBangTuKhoa(keyword);
grv_NhaCungCap.Rows.Clear();
for (int i = 0; i < allNCC.Count; i++)
{
this.grv_NhaCungCap.Rows.Add(
allNCC[i].maNCC,
allNCC[i].tenNCC);
}
this.grv_NhaCungCap.ClearSelection();
}
