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; }