void FillData()
{
dtDmNhTs = DataTool.SQLGetDataTable("ASTSNH", null, this.strLookupKeyFilter, null);
bdsDmNhTs.DataSource = dtDmNhTs;
tlDmNhTs.DataSource = bdsDmNhTs;
bdsDmNhTs.Filter = "Loai_Nh IN ('1')";
//Uy quyen cho lop co so tim kiem
bdsSearch = bdsDmNhTs;
ExportControl = tlDmNhTs;
tlDmNhTs.ExpandAll();
if (bdsDmNhTs.Count >= 0)
{
bdsDmNhTs.Position = 0;
}
if (this.isLookup)
{
this.MoveToLookupValue();
}
}
private void FillData()
{
//Xay dung DataGrid
dtParameters = DataTool.SQLGetDataTable("SYSPARAMETER", "*", "Visible = 0", "Stt"); //Hien thi nhung tham so co Visible la 0
bdsParameters.DataSource = dtParameters;
tlParameters.DataSource = bdsParameters;
tlParameters.ExpandAll();
bdsSearch = bdsParameters;
}
void FillTree()
{
dtModule = SQLExec.ExecuteReturnDt("SELECT * FROM SYSMODULE ORDER BY Stt");
dtMenu = SQLExec.ExecuteReturnDt("SELECT * FROM SYSMENU ORDER BY Stt");
bdsModule = new BindingSource();
bdsModule.DataSource = dtModule;
bdsMenu = new BindingSource();
bdsMenu.DataSource = dtMenu;
tlModule.DataSource = bdsModule;
tlModule.ExpandAll();
tlMenu.DataSource = bdsMenu;
tlModule.Expand = (bool)SQLExec.ExecuteReturnValue("SELECT Expand FROM SYSZONE WHERE ZONE = '" + tlModule.strZone + "'");
tlMenu.Expand = (bool)SQLExec.ExecuteReturnValue("SELECT Expand FROM SYSZONE WHERE ZONE = '" + tlMenu.strZone + "'");
}
