using SqlSugar;
|
using WIDESEA_Core;
|
using WIDESEA_Core.BaseRepository;
|
using WIDESEA_Core.BaseServices;
|
using WIDESEA_Core.HttpContextUser;
|
using WIDESEA_DTO.Stock;
|
using WIDESEA_IStockService;
|
using WIDESEA_Model.Models;
|
|
namespace WIDESEA_StockService
|
{
|
public partial class StockInfoDetailService : ServiceBase<Dt_StockInfoDetail, IRepository<Dt_StockInfoDetail>>, IStockInfoDetailService
|
{
|
public StockInfoDetailService(IRepository<Dt_StockInfoDetail> BaseDal, IRepository<Dt_StockInfo> stockinfoRepository) : base(BaseDal)
|
{
|
_stockinfoRepository = stockinfoRepository;
|
}
|
|
public IRepository<Dt_StockInfo> _stockinfoRepository;
|
public IRepository<Dt_StockInfoDetail> Repository => BaseDal;
|
|
public bool ExistBarcodes(string barcode)
|
{
|
return BaseDal.QueryFirst(x => x.Barcode == barcode) != null;
|
}
|
|
public bool ExistBarcodes(List<string> barcodes)
|
{
|
return BaseDal.QueryFirst(x => !string.IsNullOrEmpty(x.Barcode) && barcodes.Contains(x.Barcode)) != null;
|
}
|
|
public PageGridData<StockInfoDetailWithPalletDto> GetPageData2(PageDataOptions options)
|
{
|
PageGridData<Dt_StockInfoDetail> lists = base.GetPageData (options);
|
|
List<int> stockIds = lists.Rows.Select(detail => detail.StockId).Distinct().ToList();
|
var stocks= _stockinfoRepository.QueryData(x => stockIds.Contains(x.Id)).ToList();
|
|
|
List<StockInfoDetailWithPalletDto> dtoList = lists.Rows
|
.Select(detail => new StockInfoDetailWithPalletDto
|
{
|
|
Id = detail.Id,
|
StockId = detail.StockId,
|
MaterielCode = detail.MaterielCode,
|
MaterielName = detail.MaterielName,
|
OrderNo = detail.OrderNo,
|
BatchNo = detail.BatchNo,
|
ProductionDate = detail.ProductionDate,
|
EffectiveDate = detail.EffectiveDate,
|
SerialNumber = detail.SerialNumber,
|
StockQuantity = detail.StockQuantity,
|
OutboundQuantity = detail.OutboundQuantity,
|
Status = detail.Status,
|
Unit = detail.Unit,
|
InboundOrderRowNo = detail.InboundOrderRowNo,
|
SupplyCode = detail.SupplyCode,
|
WarehouseCode = detail.WarehouseCode,
|
Barcode = detail.Barcode,
|
BusinessType = detail.BusinessType,
|
Remark = detail.Remark,
|
Creater = detail.Creater,
|
CreateDate = detail.CreateDate,
|
Modifier = detail.Modifier,
|
ModifyDate = detail.ModifyDate,
|
PalletCode= stocks
|
.FirstOrDefault(stock => stock.Id == detail.StockId)?
|
.PalletCode ?? "无托盘编号"
|
})
|
.ToList();
|
|
return new PageGridData<StockInfoDetailWithPalletDto> { Rows = dtoList, Total = lists.Total, Summary = lists.Summary };
|
}
|
|
public PageGridData<StockDetailDtO> GetPageDataByMateriel(PageDataOptions options)
|
{
|
PageGridData<Dt_StockInfoDetail> lists = base.GetPageData(options);
|
|
List<StockDetailDtO> dtoList = lists.Rows.GroupBy(detail => new { detail.MaterielCode, detail.BatchNo, detail.SupplyCode }).Select(group =>
|
{
|
var firstItem = group.First();
|
return new StockDetailDtO
|
{
|
Id = firstItem.Id,
|
StockId = firstItem.StockId,
|
MaterielCode = group.Key.MaterielCode,
|
MaterielName = firstItem.MaterielName,
|
OrderNo = firstItem.OrderNo,
|
BatchNo = group.Key.BatchNo,
|
ProductionDate = firstItem.ProductionDate,
|
EffectiveDate = firstItem.EffectiveDate,
|
SerialNumber = firstItem.SerialNumber,
|
// 核心：对当前分组的StockQuantity求和
|
StockQuantity = group.Sum(item => item.StockQuantity),
|
OutboundQuantity = firstItem.OutboundQuantity,
|
Status = firstItem.Status,
|
Unit = firstItem.Unit,
|
InboundOrderRowNo = firstItem.InboundOrderRowNo,
|
SupplyCode = group.Key.SupplyCode,
|
WarehouseCode = firstItem.WarehouseCode,
|
Barcode = firstItem.Barcode,
|
BusinessType = firstItem.BusinessType,
|
Remark = firstItem.Remark
|
};
|
}).ToList();
|
|
|
return new PageGridData<StockDetailDtO> { Rows = dtoList, Total = lists.Total, Summary = lists.Summary };
|
}
|
}
|
}
|
