| | |
|---|
| | | { |
|---|
| | | ObservableCollection<MenuData> data = new ObservableCollection<MenuData>(); |
|---|
| | | ObservableCollection<MenuData> treeData = new ObservableCollection<MenuData>(); |
|---|
| | | DataTable dt = sqliteHelper.GetDataTable("SELECT m1.*,m2.name AS parentName FROM menu AS m1 LEFT JOIN menu AS m2 ON m1.parentCode = m2.code Order By m1.sort,m1.id;"); |
|---|
| | | DataTable dt = sqliteHelper.GetDataTable("SELECT m1.*,m2.name AS parentName FROM menu AS m1 LEFT JOIN menu AS m2 ON m1.parentCode = m2.code Order By IIF(m1.level=1,m1.sort,m2.sort),IIF(m1.level=1,0,m1.sort),m1.id;"); |
|---|
| | | Dictionary<string, MenuData> cache = new Dictionary<string, MenuData>(); |
|---|
| | | if (dt != null) |
|---|
| | | { |
|---|
