| | |
| | | parentCode TEXT, |
| | | dllPath TEXT, |
| | | className TEXT, |
| | | sort REAL, |
| | | UNIQUE(code) |
| | | );"); |
| | | } |
| | |
| | | { |
| | | 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.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 m1.sort,m1.id;"); |
| | | Dictionary<string, MenuData> cache = new Dictionary<string, MenuData>(); |
| | | if (dt != null) |
| | | { |
| | |
| | | ParentCode = dr["parentCode"].ToString(), |
| | | ParentName = dr["parentName"].ToString(), |
| | | DllPath = dr["dllPath"].ToString(), |
| | | ClassName = dr["className"].ToString() |
| | | ClassName = dr["className"].ToString(), |
| | | Sort = dr["sort"] == DBNull.Value ? 0 : double.Parse(dr["sort"].ToString()), |
| | | }; |
| | | data.Add(menu); |
| | | if (menu.Level == "1") |