| | |
| | | namespace CMS.Plugin.HIAWms.EntityFrameworkCore.Repositories; |
| | | |
| | | /// <summary> |
| | | /// 出入库记录表仓储实现 |
| | | /// 出入库记录仓储实现 |
| | | /// </summary> |
| | | public class EfCoreWmsInOutStockRecordRepository : EfCoreRepository<ICMSPluginDbContext, WmsInOutStockRecord, Guid>, IWmsInOutStockRecordRepository |
| | | { |
| | |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 按照名称查找出入库记录表 |
| | | /// 按照名称查找出入库记录 |
| | | /// </summary> |
| | | /// <param name="materialNo"></param> |
| | | /// <param name="name"></param> |
| | | /// <param name="cancellationToken"></param> |
| | | /// <returns></returns> |
| | | public virtual async Task<WmsInOutStockRecord> FindByNameAsync(string materialNo, CancellationToken cancellationToken = default) |
| | | public virtual async Task<WmsInOutStockRecord> FindByNameAsync(string name, CancellationToken cancellationToken = default) |
| | | { |
| | | return await (await GetDbSetAsync()) |
| | | .IncludeDetails() |
| | | .Where(x => !x.IsDeleted) |
| | | .OrderBy(t => t.Sort) |
| | | .FirstOrDefaultAsync(t => t.MaterialNo == materialNo, GetCancellationToken(cancellationToken)); |
| | | .FirstOrDefaultAsync(t => t.Id == name, GetCancellationToken(cancellationToken)); |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 验证名称是否存在出入库记录表 |
| | | /// 验证名称是否存在出入库记录 |
| | | /// </summary> |
| | | /// <param name="materialCode"></param> |
| | | /// <param name="name">校验值</param> |
| | | /// <param name="id"></param> |
| | | /// <returns></returns> |
| | | public async Task<bool> NameExistAsync(string materialCode, Guid? id = null) |
| | | public async Task<bool> NameExistAsync(string name, Guid? id = null) |
| | | { |
| | | return await (await GetDbSetAsync()).WhereIf(id.HasValue, p => p.Id != id).Where(x => !x.IsDeleted).AnyAsync(x => x.MaterialName == materialCode); |
| | | return await (await GetDbSetAsync()).WhereIf(id.HasValue, p => p.Id != id).Where(x => !x.IsDeleted).AnyAsync(x => x.Id == name); |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 获取最大排序出入库记录表 |
| | | /// 获取最大排序出入库记录 |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | public async Task<int> GetMaxSortAsync() |
| | |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 获取分页列表出入库记录表 |
| | | /// 获取分页列表出入库记录 |
| | | /// </summary> |
| | | /// <param name="whereConditions"></param> |
| | | /// <param name="sorting"></param> |
| | |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 获取总数出入库记录表 |
| | | /// 获取总数出入库记录 |
| | | /// </summary> |
| | | /// <param name="whereConditions"></param> |
| | | /// <param name="cancellationToken"></param> |