using SqlSugar; using WmsLite.Api.Models; using WmsLite.Api.Repositories.Interfaces; namespace WmsLite.Api.Repositories; public class SysDictItemRepository : ISysDictItemRepository { private readonly ISqlSugarClient _db; public SysDictItemRepository(ISqlSugarClient db) { _db = db; } public async Task> ListEnabledAsync(string tenantId, string ownerCode, IReadOnlyList? categories) { var tenant = tenantId.Trim(); var owner = ownerCode.Trim(); var q = _db.Queryable() .Where(x => !x.IsDeleted && x.IsEnabled && ((x.TenantId == tenant && x.OwnerCode == owner) || (x.TenantId == "system" && x.OwnerCode == "system"))); if (categories is { Count: > 0 }) { var set = categories.Select(c => c.Trim()).Where(c => c.Length > 0).Distinct().ToList(); if (set.Count > 0) { q = q.Where(x => set.Contains(x.Category)); } } return await q.OrderBy(x => x.Category).OrderBy(x => x.SortOrder).OrderBy(x => x.Code).ToListAsync(); } }