using System; using System.Collections.Generic; using System.Linq.Expressions; using System.Threading.Tasks; using SqlSugar; using WmsLite.Api.Common; using WmsLite.Api.Dtos.Common; using WmsLite.Api.Infrastructure.Auth; using WmsLite.Api.Models; using WmsLite.Api.Repositories.Interfaces; namespace WmsLite.Api.Repositories; public class BaseRepository : IBaseRepository where TEntity : BaseEntity, new() { protected readonly ISqlSugarClient Db; protected readonly ICurrentUserContext UserContext; public BaseRepository(ISqlSugarClient db, ICurrentUserContext userContext) { Db = db; UserContext = userContext; } protected string ScopeTenantId => UserContext.TenantId.Trim(); protected string ScopeOwnerCode => UserContext.OwnerCode.Trim(); public virtual async Task GetByIdAsync(long id) { return await Db.Queryable() .Where(x => !x.IsDeleted && x.Id == id) .FirstAsync(); } public virtual async Task GetByIdAsync(long id, string tenantId, string ownerCode) { var tenant = tenantId.Trim(); var owner = ownerCode.Trim(); return await Db.Queryable() .Where(x => !x.IsDeleted && x.Id == id && x.TenantId == tenant && x.OwnerCode == owner) .FirstAsync(); } public virtual async Task> GetListAsync(Expression> predicate) { return await Db.Queryable() .Where(x => !x.IsDeleted) .Where(predicate) .ToListAsync(); } public virtual async Task> GetPagedListAsync(BasePagedQuery query) { var pageIndex = query.PageIndex <= 0 ? 1 : query.PageIndex; var pageSize = query.PageSize <= 0 ? 20 : query.PageSize; var tenantId = ScopeTenantId; var ownerCode = ScopeOwnerCode; RefAsync total = 0; var items = await Db.Queryable() .Where(x => !x.IsDeleted && x.TenantId == tenantId && x.OwnerCode == ownerCode) .OrderByDescending(x => x.UpdateTime) .OrderByDescending(x => x.CreateTime) .ToPageListAsync(pageIndex, pageSize, total); return new PagedResult { PageIndex = pageIndex, PageSize = pageSize, TotalCount = total, Items = items }; } public virtual async Task InsertAsync(TEntity entity) { entity.Id = entity.Id == 0 ? SnowFlakeSingle.Instance.NextId() : entity.Id; entity.CreateTime ??= DateTime.Now; entity.IsDeleted = false; if (UserContext.IsAuthenticated) { entity.CreateBy = UserContext.UserId; } await Db.Insertable(entity).ExecuteCommandAsync(); return entity.Id; } public virtual async Task UpdateAsync(TEntity entity) { entity.UpdateTime = DateTime.Now; if (UserContext.IsAuthenticated) { entity.UpdateBy = UserContext.UserId; } return await Db.Updateable(entity).ExecuteCommandAsync(); } public virtual async Task SoftDeleteAsync(long id) { if (UserContext.IsAuthenticated) { var uid = UserContext.UserId; return await Db.Updateable() .SetColumns(x => x.IsDeleted == true) .SetColumns(x => x.UpdateTime == DateTime.Now) .SetColumns(x => x.DeleteTime == DateTime.Now) .SetColumns(x => x.DeleteBy == uid) .Where(x => x.Id == id) .ExecuteCommandAsync(); } return await Db.Updateable() .SetColumns(x => x.IsDeleted == true) .SetColumns(x => x.UpdateTime == DateTime.Now) .SetColumns(x => x.DeleteTime == DateTime.Now) .Where(x => x.Id == id) .ExecuteCommandAsync(); } public virtual async Task SoftDeleteAsync(long id, string tenantId, string ownerCode) { var tenant = tenantId.Trim(); var owner = ownerCode.Trim(); if (UserContext.IsAuthenticated) { var uid = UserContext.UserId; return await Db.Updateable() .SetColumns(x => x.IsDeleted == true) .SetColumns(x => x.UpdateTime == DateTime.Now) .SetColumns(x => x.DeleteTime == DateTime.Now) .SetColumns(x => x.DeleteBy == uid) .Where(x => x.Id == id && x.TenantId == tenant && x.OwnerCode == owner) .ExecuteCommandAsync(); } return await Db.Updateable() .SetColumns(x => x.IsDeleted == true) .SetColumns(x => x.UpdateTime == DateTime.Now) .SetColumns(x => x.DeleteTime == DateTime.Now) .Where(x => x.Id == id && x.TenantId == tenant && x.OwnerCode == owner) .ExecuteCommandAsync(); } }