private void HienThiDanhSach()
{
try
{
tblmathangBL ctr = new tblmathangBL();
string sidhang = "";
try { sidhang = cbTKHangSX.SelectedValue.ToString().Trim(); }
catch { }
DataTable dt = new DataTable();
if (chkAll.Checked)
{
dt = ctr.filtermathangtraall(txtKeyword.Text.Trim(), sidhang, "", sidkh);
}
else
{
dt = ctr.filtermathangtra(txtKeyword.Text.Trim(), sidhang, "", sidkh);
}
c1FlexGrid1.DataSource = dt;
try { c1FlexGrid1.Cols["gianhap"].Format = "N0"; }
catch { }
try { c1FlexGrid1.Cols["giabanbuon"].Format = "N0"; }
catch { }
try { c1FlexGrid1.Cols["giabanle"].Format = "N0"; }
catch { }
try { c1FlexGrid1.Cols["giadl1"].Format = "N0"; }
catch { }
try { c1FlexGrid1.Cols["giadl2"].Format = "N0"; }
catch { }
try { c1FlexGrid1.Cols["giadl3"].Format = "N0"; }
catch { }
try { c1FlexGrid1.Cols["giadl4"].Format = "N0"; }
catch { }
try { c1FlexGrid1.Cols["giadl5"].Format = "N0"; }
catch { }
FormatGrid();
txtKeyword.Focus();
}
catch (Exception ex)
{ MessageBox.Show("Lỗi mở dữ liệu.\nChi tiết lỗi : " + ex.Message, "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); }
}