void LoadDataDSNPP()
{
lstNPP = NhaPhanPhoiBUS.LayDanhSachNhaPhanPhoi().Where(p => p.TRANGTHAI == true).ToList();
this.dgvDSNhaPhanPhoi.AutoGenerateColumns = false;
this.dgvDSNhaPhanPhoi.DataSource = lstNPP;
this.txtMaNPP.Text = AutoMaNPP();
}
/// <summary>
/// Tab danh sach san pham
/// </summary>
void LoadDataTabDSSP()
{
lstSanPham = SanPhamBUS.LayDanhSachSanPham();
lstNhaPP = NhaPhanPhoiBUS.LayDanhSachNhaPhanPhoi();
lstAnhMinhHoa = AnhMinhHoaSPBUS.LayDanhSachAnhMinhHoa();
//var kq = from sp in lstSanPham
// select new
// {
// sp.MASP,
// sp.TENSP,
// sp.SL_TON,
// sp.GIABAN,
// sp.DVT,
// sp.LOAISANPHAM.TENLOAI,
// sp.NHAPHANPHOI.TENNPP
// };
var kq = from sp in lstSanPham
join npp in lstNhaPP
on sp.MANPP equals npp.MANPP
select new
{
sp.MASP,
sp.TENSP,
sp.SL_TON,
sp.GIABAN,
sp.DVT,
sp.LOAISANPHAM.TENLOAI,
npp.TENNPP
};
this.dgvDSSanPham.DataSource = kq.ToList();
this.dgvDSSanPham.AutoGenerateColumns = false;
}
string AutoMaNPP()
{
string manpp = string.Empty;
var lstnpp = NhaPhanPhoiBUS.LayDanhSachNhaPhanPhoi();
if (lstnpp.Count == 0)
{
manpp = "NPP1";
return(manpp);
}
else
{
manpp = lstnpp[lstnpp.Count - 1].MANPP.ToString();
int somanpp = Convert.ToInt32(manpp.Remove(0, 3)) + 1;
manpp = "NPP" + somanpp;
for (int i = 0; i < lstnpp.Count(); i++)
{
if (manpp == lstnpp[i].MANPP)
{
somanpp = Convert.ToInt32(manpp.Remove(0, 3)) + 1;
manpp = "NPP" + somanpp;
}
}
return(manpp);
}
}
private void txtNhaPhanPhoi_Validated(object sender, EventArgs e)
{
if (this.txtNhaPhanPhoi.Text != string.Empty)
{
if (!NhaPhanPhoiBUS.KiemTraMaNPPTonTai(this.txtNhaPhanPhoi.Text))
{
MessageBox.Show("Mã nhà phân phối không tồn tại !!!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.txtNhaPhanPhoi.Focus();
}
}
}
void AutoCompleteMaNPP()
{
lstNhaPP = NhaPhanPhoiBUS.LayDanhSachNhaPhanPhoi();
AutoCompleteStringCollection collection = new AutoCompleteStringCollection();
foreach (NHAPHANPHOI item in lstNhaPP)
{
collection.Add(item.MANPP);
}
this.txtNhaPhanPhoi.AutoCompleteCustomSource = collection;
this.txtNhaPhanPhoi.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
this.txtNhaPhanPhoi.AutoCompleteSource = AutoCompleteSource.CustomSource;
}
void LoadComboBoxData()
{
this.cbDSLoaiSP.DataSource = LoaiSanPhamBUS.LayDanhSachLoaiSanPham();
this.cbDSLoaiSP.DisplayMember = "TENLOAI";
this.cbDSLoaiSP.ValueMember = "MALOAI";
this.cbDSNPP.DataSource = NhaPhanPhoiBUS.LayDanhSachNhaPhanPhoi();
this.cbDSNPP.DisplayMember = "TENNPP";
this.cbDSNPP.ValueMember = "MANPP";
this.cbQLTimKiemLoaiSP.DataSource = LoaiSanPhamBUS.LayDanhSachLoaiSanPham();
this.cbQLTimKiemLoaiSP.DisplayMember = "TENLOAI";
this.cbQLTimKiemLoaiSP.ValueMember = "MALOAI";
this.cbQLTimKiemNPP.DataSource = NhaPhanPhoiBUS.LayDanhSachNhaPhanPhoi();
this.cbQLTimKiemNPP.DisplayMember = "TENNPP";
this.cbQLTimKiemNPP.ValueMember = "MANPP";
}
private void btnXoaNPP_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Bạn có chắc chứ?", "Thông báo", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
{
NhaPhanPhoiBUS.XoaNPP(this.txtMaNPP.Text);
MessageBox.Show("Xóa nhà phân phối thành công !!!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
LoadDataDSNPP();
ResetTabQLNPP();
string lsth = "[" + DateTime.Now.ToString("dd/MM/yyyy-h:m:s") + "] " + this.manv + " đã xóa thông tin nhà phân phối " + this.txtMaNPP.Text;
LichSuHeThongBUS.ThemLSHT(new LICHSUHETHONG
{
NGAYTAO = DateTime.Now.Date,
NV_THAOTAC = this.manv,
VITRI_THAOTAC = this.vitrithaotac,
GHICHU = lsth
});
}
}
private void btnThemNPP_Click(object sender, EventArgs e)
{
if (this.txtTenNPP.Text == string.Empty ||
this.txtDiaChiNPP.Text == string.Empty ||
this.txtSDTNPP.Text == string.Empty ||
this.txtEmailNPP.Text == string.Empty ||
this.txtWebsiteNPP.Text == string.Empty)
{
MessageBox.Show("Bạn chưa điền đầy đủ thông tin !!!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
NHAPHANPHOI npp = new NHAPHANPHOI
{
MANPP = AutoMaNPP(),
TENNPP = this.txtTenNPP.Text,
DIACHI = this.txtDiaChiNPP.Text,
EMAIL = this.txtEmailNPP.Text,
SDT = this.txtSDTNPP.Text,
WEBSITE = this.txtWebsiteNPP.Text,
TRANGTHAI = true
};
if (NhaPhanPhoiBUS.ThemNPP(npp))
{
MessageBox.Show("Thêm nhà phân phối thành công thành công !!!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
LoadDataDSNPP();
ResetTabQLNPP();
string lsth = "[" + DateTime.Now.ToString("dd/MM/yyyy-h:m:s") + "] " + this.manv + " đã thêm mới nhà phân phối " + npp.MANPP;
LichSuHeThongBUS.ThemLSHT(new LICHSUHETHONG
{
NGAYTAO = DateTime.Now.Date,
NV_THAOTAC = this.manv,
VITRI_THAOTAC = this.vitrithaotac,
GHICHU = lsth
});
}
else
{
MessageBox.Show("Thêm nhà phân phối thất bại!!!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
/// <summary>
/// Tab Quan ly san pham
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
void LoadDataTabQLSP()
{
lstSanPham = SanPhamBUS.LayDanhSachSanPham();
lstNhaPP = NhaPhanPhoiBUS.LayDanhSachNhaPhanPhoi();
lstLoaiSp = LoaiSanPhamBUS.LayDanhSachLoaiSanPham();
lstAnhMinhHoa = AnhMinhHoaSPBUS.LayDanhSachAnhMinhHoa();
//var kq = from sp in lstSanPham
// //join anhMH in lstAnhMinhHoa
// //on sp.MASP equals anhMH.MASP
// select new
// {
// sp.MASP,
// sp.TENSP,
// sp.SL_TON,
// sp.GIABAN,
// sp.DVT,
// sp.LOAISANPHAM.TENLOAI,
// sp.NHAPHANPHOI.TENNPP,
// //anhMH.TENANHMINHHOA
// };
var kq = from sp in lstSanPham
join npp in lstNhaPP on sp.MANPP equals npp.MANPP
join lsp in lstLoaiSp on sp.MALOAI equals lsp.MALOAI
select new
{
sp.MASP,
sp.TENSP,
sp.SL_TON,
sp.GIABAN,
sp.DVT,
lsp.TENLOAI,
npp.TENNPP
};
this.dgvDSSanPham.AutoGenerateColumns = false;
this.dgvQLSanPham.DataSource = kq.ToList();
this.dgvQLSanPham.AutoSize = true;
this.dgvQLSanPham.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
}
