WMSlite/WmsLite.Api/Repositories/MaterialRepository.cs
2026-05-31 01:03:55 +08:00

78 lines
3.0 KiB
C#

using System.Threading.Tasks;
using SqlSugar;
using WmsLite.Api.Common;
using WmsLite.Api.Dtos.Material;
using WmsLite.Api.Infrastructure.Auth;
using WmsLite.Api.Models;
using WmsLite.Api.Repositories.Interfaces;
namespace WmsLite.Api.Repositories;
public class MaterialRepository : BaseRepository<Material>, IMaterialRepository
{
public MaterialRepository(ISqlSugarClient db, ICurrentUserContext userContext) : base(db, userContext)
{
}
public async Task<Material?> GetByCodeAsync(string tenantId, string ownerCode, string code)
{
if (string.IsNullOrWhiteSpace(code))
{
return null;
}
var tenant = tenantId.Trim();
var owner = ownerCode.Trim();
return await Db.Queryable<Material>()
.Where(x => !x.IsDeleted && x.TenantId == tenant && x.OwnerCode == owner && x.Code == code.Trim())
.FirstAsync();
}
public async Task<Dictionary<string, string>> GetNameMapByCodesAsync(string tenantId, string ownerCode, IEnumerable<string> codes)
{
var list = codes.Where(c => !string.IsNullOrWhiteSpace(c)).Select(c => c.Trim()).Distinct().ToList();
if (list.Count == 0)
{
return new Dictionary<string, string>(StringComparer.Ordinal);
}
var tenant = tenantId.Trim();
var owner = ownerCode.Trim();
var rows = await Db.Queryable<Material>()
.Where(x => !x.IsDeleted && x.TenantId == tenant && x.OwnerCode == owner && list.Contains(x.Code))
.Select(x => new { x.Code, x.Name })
.ToListAsync();
return rows.ToDictionary(x => x.Code, x => x.Name?.Trim() ?? string.Empty, StringComparer.Ordinal);
}
public async Task<PagedResult<Material>> GetPagedListAsync(MaterialPagedQuery query)
{
var pageIndex = query.PageIndex <= 0 ? 1 : query.PageIndex;
var pageSize = query.PageSize <= 0 ? 20 : query.PageSize;
var tenantId = ScopeTenantId;
var ownerCode = ScopeOwnerCode;
var kw = query.Keyword?.Trim();
var dbQuery = Db.Queryable<Material>()
.Where(x => !x.IsDeleted && x.TenantId == tenantId && x.OwnerCode == ownerCode)
.WhereIF(!string.IsNullOrWhiteSpace(kw), x => x.Code.Contains(kw!) || x.Name.Contains(kw!))
.WhereIF(!string.IsNullOrWhiteSpace(query.Code), x => x.Code.Contains(query.Code!.Trim()))
.WhereIF(!string.IsNullOrWhiteSpace(query.Name), x => x.Name.Contains(query.Name!.Trim()))
.WhereIF(!string.IsNullOrWhiteSpace(query.Spec), x => x.Spec != null && x.Spec.Contains(query.Spec!.Trim()));
RefAsync<int> total = 0;
var items = await dbQuery
.OrderByDescending(x => x.UpdateTime)
.OrderByDescending(x => x.CreateTime)
.ToPageListAsync(pageIndex, pageSize, total);
return new PagedResult<Material>
{
PageIndex = pageIndex,
PageSize = pageSize,
TotalCount = total,
Items = items
};
}
}