private void cmbKey_Click(object sender, EventArgs e)
{
string sl = cboTimKiem.Text;
try
{
if (sl == "Mã nhà cung cấp")
{
cmbKey.DataSource = BUS_NCC.laymancc();
//cmbKey.DisplayMember = "TENTD";
cmbKey.ValueMember = "MaNCC";
}
else if (sl == "Tên nhà cung cấp")
{
cmbKey.DataSource = BUS_NCC.laytenncc();
//cmbKey.DisplayMember = "TENTD";
cmbKey.ValueMember = "TenNCC";
}
else
{
cmbKey.Text = "";
}
}
catch (Exception ex)
{
}
}
private void button14_Click(object sender, EventArgs e)
{
string sl = cboTimKiem.Text;
try
{
// sl = sl.Replace();
if (sl == "Mã nhà cung cấp")
{
dt = BUS_NCC.hienthincctheoma(cmbKey.Text);
loaddata1(dt);
bindings();
}
else if (sl == "Tên nhà cung cấp")
{
dt = BUS_NCC.hienthincctheoten(cmbKey.Text);
loaddata1(dt);
bindings();
}
}
catch (Exception ex)
{
}
}
private void txtTenNCC_Click(object sender, EventArgs e)
{
try
{
txtTenNCC.DataSource = BUS_NCC.laytenncc();
//cmbKey.DisplayMember = "TENTD";
txtTenNCC.ValueMember = "TenNCC";
//
//
}
catch (Exception ex)
{
}
}
//
//XOA
//
private void btnXoa_Click(object sender, EventArgs e)
{
try
{
BUS_NCC.Xoa_ncc(txtMaNCC.Text);
DialogResult dr = MessageBox.Show("Đã Xóa", "Thông Báo", MessageBoxButtons.OK);
if (dr == DialogResult.OK)
{
loaddata();
}
}
catch (Exception ex)
{
//MessageBox.Show("Lỗi");
}
}
//
//sua
//
private void btnSua_Click(object sender, EventArgs e)
{
try
{
DTO_NCC sv = new DTO_NCC(txtMaNCC.Text, txtTenNCC.Text, txtDiaChi.Text, txtDienThoai.Text, txtEmail.Text, txtGhiChu.Text);
BUS_NCC.Sua_ncc(sv);
DialogResult dr = MessageBox.Show("Sua thanh Cong", "Thông Báo", MessageBoxButtons.OK);
loaddata();
if (dr == DialogResult.OK)
{
loaddata();
}
}
catch (Exception ex)
{
MessageBox.Show("Sua không thành công!\n" + ex.Message);
}
}
private void QuanLySanPham_Load(object sender, EventArgs e)
{
DataTable sp = new DataTable();
DataTable cat = new DataTable();
DataTable ncc = new DataTable();
sp = BUS_SANPHAM.LoadListSP();
cat = BUS_DANHMUC.loadListCategory();
ncc = BUS_NCC.loadListNCC();
dgSP.DataSource = sp;
dgSanPham.DataSource = sp;
dgSearchSP.DataSource = sp;
cmbDM.DataSource = cat;
cmbDM.DisplayMember = "tenDM";
cmbDM.ValueMember = "maDM";
cmbNCC.DataSource = ncc;
cmbNCC.DisplayMember = "tenNCC";
cmbNCC.ValueMember = "maNCC";
}
private void TabControl1_SelectedIndexChanged(object sender, EventArgs e)
{
DataTable sp = new DataTable();
DataTable cat = new DataTable();
DataTable ncc = new DataTable();
sp = BUS_SANPHAM.LoadListSP();
cat = BUS_DANHMUC.loadListCategory();
ncc = BUS_NCC.loadListNCC();
if (tabControl1.SelectedIndex == 0)
{
dgSP.DataSource = sp;
cmbDM.DataSource = cat;
cmbDM.DisplayMember = "tenDM";
cmbDM.ValueMember = "maDM";
cmbNCC.DataSource = ncc;
cmbNCC.DisplayMember = "tenNCC";
cmbNCC.ValueMember = "maNCC";
}
else if (tabControl1.SelectedIndex == 1)
{
dgSanPham.DataSource = sp;
cmbDanhMuc.DataSource = cat;
cmbDanhMuc.DisplayMember = "tenDM";
cmbDanhMuc.ValueMember = "maDM";
cmbNhaCC.DataSource = ncc;
cmbNhaCC.DisplayMember = "tenNCC";
cmbNhaCC.ValueMember = "maNCC";
}
else
{
//cmbSearch.DataSource = cat;
//cmbSearch.DisplayMember = "tenDM";
// cmbSearch.ValueMember = "maDM";
}
}
// co ban //
private void loaddata()
{
dt = BUS_NCC.Hienthi_ncc_all();
grdGiangVien.DataSource = dt;
}
private void cmbKey_Click(object sender, EventArgs e)
{
string sl = cboTimKiem.Text;
try
{
if (sl == "Mã hàng hóa")
{
cmbKey.DataSource = BUS_HangHoa.laymahh();
//cmbKey.DisplayMember = "TENTD";
cmbKey.ValueMember = "MaHH";
}
else if (sl == "Tên hàng hóa")
{
cmbKey.DataSource = BUS_HangHoa.laytenhh();
//cmbKey.DisplayMember = "TENTD";
cmbKey.ValueMember = "TenHH";
}
else
{
cmbKey.Text = "";
}
//
//
if (sl == "Mã nhà cung cấp")
{
cmbKey.DataSource = BUS_NCC.laymancc();
//cmbKey.DisplayMember = "TENTD";
cmbKey.ValueMember = "MaNCC";
}
else if (sl == "Tên nhà cung cấp")
{
cmbKey.DataSource = BUS_NCC.laytenncc();
//cmbKey.DisplayMember = "TENTD";
cmbKey.ValueMember = "TenNCC";
}
else
{
cmbKey.Text = "";
}
//
//
if (sl == "Mã kho")
{
cmbKey.DataSource = BUS_Kho.laymakho();
//cmbKey.DisplayMember = "TENTD";
cmbKey.ValueMember = "MaKho";
}
else if (sl == "Tên kho")
{
cmbKey.DataSource = BUS_Kho.laytenkho();
//cmbKey.DisplayMember = "TENTD";
cmbKey.ValueMember = "TenKho";
}
else
{
cmbKey.Text = "";
}
}
catch (Exception ex)
{
}
}
