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

58 lines
2.0 KiB
C#

using System.Threading.Tasks;
using SqlSugar;
using WmsLite.Api.Common;
using WmsLite.Api.Dtos.Template;
using WmsLite.Api.Infrastructure.Auth;
using WmsLite.Api.Models;
using WmsLite.Api.Repositories.Interfaces;
namespace WmsLite.Api.Repositories;
public class SysTemplateRepository : BaseRepository<SysTemplate>, ISysTemplateRepository
{
public SysTemplateRepository(ISqlSugarClient db, ICurrentUserContext userContext) : base(db, userContext)
{
}
public async Task<SysTemplate?> GetByBizTypeAsync(string tenantId, string ownerCode, string? bizType)
{
if (string.IsNullOrWhiteSpace(bizType))
{
return null;
}
var tenant = tenantId.Trim();
var owner = ownerCode.Trim();
return await Db.Queryable<SysTemplate>()
.Where(x => !x.IsDeleted && x.TenantId == tenant && x.OwnerCode == owner && x.BizType == bizType.Trim())
.FirstAsync();
}
public async Task<PagedResult<SysTemplate>> GetPagedListAsync(SysTemplatePagedQuery query)
{
var pageIndex = query.PageIndex <= 0 ? 1 : query.PageIndex;
var pageSize = query.PageSize <= 0 ? 20 : query.PageSize;
var tenant = ScopeTenantId;
var owner = ScopeOwnerCode;
var dbQuery = Db.Queryable<SysTemplate>()
.Where(x => !x.IsDeleted && x.TenantId == tenant && x.OwnerCode == owner)
.WhereIF(!string.IsNullOrWhiteSpace(query.BizType), x => x.BizType.Contains(query.BizType!.Trim()))
.WhereIF(!string.IsNullOrWhiteSpace(query.BizName), x => x.BizName.Contains(query.BizName!.Trim()));
RefAsync<int> total = 0;
var items = await dbQuery
.OrderByDescending(x => x.UpdateTime)
.OrderByDescending(x => x.CreateTime)
.ToPageListAsync(pageIndex, pageSize, total);
return new PagedResult<SysTemplate>
{
PageIndex = pageIndex,
PageSize = pageSize,
TotalCount = total,
Items = items
};
}
}