public static void dg1DataBind(DataGridAction dga) {
String sql =
"select ID ,Name,Icon,Type,'' as TreeLevel from ZDMenu where (parentid in(select id from ZDMenu where parentid=0 and visiable='Y') or parentid=0) and visiable='Y' order by OrderFlag";
DataTable dt = new QueryBuilder(sql).executeDataTable();
for (int i = 0; i < dt.getRowCount(); i++) {
if ("2".equals(dt.get(i, "Type"))) dt.set(i, "TreeLevel", "1");
else {
dt.set(i, "TreeLevel", "0");
}
}
dga.bindData(dt);
}
