| | |
| | | using System.Collections.ObjectModel; |
| | | using System.Data; |
| | | using System.IO; |
| | | using System.Linq; |
| | | using HMI.Core.Entity; |
| | | using HMI.Core.Util; |
| | | using HMI.MenuManage.Entity; |
| | |
| | | id INTEGER PRIMARY KEY AUTOINCREMENT, |
| | | code TEXT NOT NULL, |
| | | name TEXT NOT NULL, |
| | | icon TEXT, |
| | | iconPath TEXT, |
| | | level TEXT, |
| | | type TEXT, |
| | |
| | | Id = dr["id"].ToString(), |
| | | Code = dr["code"].ToString(), |
| | | Name = dr["name"].ToString(), |
| | | IconPath = dr["iconPath"].ToString(), |
| | | Icon = dr["icon"].ToString(), |
| | | Level = dr["level"].ToString(), |
| | | Type = dr["type"].ToString(), |
| | | ParentCode = dr["parentCode"].ToString(), |
| | |
| | | |
| | | public void DeleteMenuById(string id) |
| | | { |
| | | string sql = $"DELETE FROM menu WHERE id = {id}"; |
| | | string sql = $"DELETE FROM menu WHERE id = {id};"; |
| | | sqliteHelper.ExecuteSql(sql); |
| | | } |
| | | |
| | | public void DeleteMenuByIds(IEnumerable<string> ids) |
| | | { |
| | | List<string> sqls = ids.Select(id => $"DELETE FROM menu WHERE id = {id};") |
| | | .ToList(); |
| | | sqliteHelper.ExecuteBatchSql(sqls); |
| | | } |
| | | } |
| | | } |