VueWebCoreApi/DLL/DAL/SystemSettingDAL.cs
@@ -32,10 +32,10 @@ union ALL select e.menucode, e.parent_id, e.menuname,e.menu_seq,e.Type from TMenu e inner join RecursiveCTE r ON e.menucode = r.parent_id inner join RecursiveCTE r ON e.menucode = r.parent_id ) select menucode, parent_id, menuname,Type from RecursiveCTE order by menu_seq"; select distinct menucode, parent_id, menuname,Type,menu_seq from RecursiveCTE order by menucode, parent_id,Type,menu_seq"; var data = DapperHelper.selecttable(sql); if (data.Rows.Count > 0) {