private void KhoiTao(string MaNhomHang)
{
if (grdvDSMatHang.ColumnCount > 0)
{
grdvDSMatHang.Columns.Clear();
grdvDSMatHang.DataSource = null;
bindingSource1 = new BindingSource();
}
DataTable Bang;
if (MaNhomHang == "TatCa")
{
Bang = MatHangBus.ThongKeHangTonKho(dtpTuNgay.Value, dtpDenNgay.Value, "TatCa");
}
else
{
Bang = MatHangBus.ThongKeHangTonKho(dtpTuNgay.Value, dtpDenNgay.Value, MaNhomHang);
}
//Loc thong tin mat hang
bindingSource1.DataSource = Bang;
string sql = "";
if (radioTheoMa.Checked == true)
{
sql = " CONVERT([MaMatHang], 'System.String') = '" + txtMatHang.Text.Trim() + "' ";
}
else
{
sql = " CONVERT([TenMatHang], 'System.String') LIKE '%" + txtMatHang.Text.Trim() + "%' ";
}
if (txtMatHang.Text.Trim() != "")
{
bindingSource1.Filter = sql;
}
grdvDSMatHang.DataSource = bindingSource1;
AnCotTrenLuoi();
DinhDangCot();
TinhTongTien();
}
