using AngleSharp.Dom;
|
using log4net.Core;
|
using Mapster;
|
using Masuit.Tools;
|
using SqlSugar;
|
using System.Collections;
|
using System.Collections.Generic;
|
using System.Drawing.Printing;
|
using System.Linq.Expressions;
|
using System.Threading.Tasks;
|
using WIDESEA_Common;
|
using WIDESEA_Core;
|
using WIDESEA_Model.Models;
|
|
namespace WIDESEA_StorageBasicService;
|
|
public class VV_PalletStockInfoService : ServiceBase<VV_PalletStockInfo, IVV_PalletStockInfoRepository>, IVV_PalletStockInfoService
|
{
|
private readonly IDt_PalletStockInfoRepository _PalletStockInfoRepository;
|
private readonly IDt_PalletStockInfoDetailRepository _PalletStockInfoDetailRepository;
|
private readonly IDt_PalletStockInfo_htyRepository _PalletStockInfo_HtyRepository;
|
private readonly ILocationStatusChangeRecordRepository _locationStatusChangeRecordRepository;
|
private readonly IUnitOfWorkManage _unitOfWorkManage;
|
public VV_PalletStockInfoService(IVV_PalletStockInfoRepository BaseDal, IDt_PalletStockInfoRepository palletStockInfoRepository, IDt_PalletStockInfoDetailRepository palletStockInfoDetailRepository, IUnitOfWorkManage unitOfWorkManage, ILocationStatusChangeRecordRepository locationStatusChangeRecordRepository) : base(BaseDal)
|
{
|
_PalletStockInfoRepository = palletStockInfoRepository;
|
_PalletStockInfoDetailRepository = palletStockInfoDetailRepository;
|
_unitOfWorkManage = unitOfWorkManage;
|
_locationStatusChangeRecordRepository = locationStatusChangeRecordRepository;
|
}
|
|
public override WebResponseContent DeleteData(object key)
|
{
|
try
|
{
|
|
var stock = _PalletStockInfoRepository.QueryFirstNavAsync(x => x.Id == key.ObjToInt()).Result;
|
var stockHty = stock.Adapt<Dt_PalletStockInfo_hty>();
|
stockHty.FinishTime = DateTime.Now;
|
stockHty.OperateType = (int)OperateTypeEnum.人工删除;
|
stockHty.Modifier = App.User.UserName;
|
|
var location = SqlSugarHelper.DbWMS.Queryable<DtLocationInfo>().FirstAsync(x => x.LocationCode == stock.LocationCode).Result;
|
location.LocationStatus = (int)LocationEnum.Free;
|
|
var hty = BaseDal.Db.InsertNav(stockHty)
|
.Include(x => x.StockInfoDetails)
|
.ExecuteCommand();
|
|
var locationd = SqlSugarHelper.DbWMS.Updateable(location).ExecuteCommandHasChange();
|
|
_PalletStockInfoRepository.DeleteDataById(stock.Id);
|
return base.DeleteData(key);
|
}
|
catch (Exception ex)
|
{
|
return WebResponseContent.Instance.Error(ex.Message);
|
}
|
}
|
|
/// <summary>
|
/// 批量删除
|
/// </summary>
|
/// <param name="keys"></param>
|
/// <returns></returns>
|
public override WebResponseContent DeleteData(object[] keys)
|
{
|
WebResponseContent content = new WebResponseContent();
|
try
|
{
|
foreach (var item in keys)
|
{
|
var stock = _PalletStockInfoRepository.QueryFirstNavAsync(x => x.Id == item.ObjToInt()).Result;
|
Dt_PalletStockInfo_hty stockHty = stock.Adapt<Dt_PalletStockInfo_hty>();
|
stockHty.FinishTime = DateTime.Now;
|
stockHty.OperateType = (int)OperateTypeEnum.人工删除;
|
stockHty.Modifier = App.User.UserName;
|
//_PalletStockInfoRepository.AddData(stockHty);
|
_PalletStockInfoRepository.DeleteDataById(stock.Id);
|
|
List<Dt_PalletStockInfoDetail> detail = _PalletStockInfoDetailRepository.QueryData(x => x.StockId == stock.Id).ToList();
|
if (detail is not null && detail.Count() > 0)
|
{
|
List<Dt_PalletStockInfoDetail_hty> details = detail.Adapt<List<Dt_PalletStockInfoDetail_hty>>();
|
var ids = details.Select(x => (object)x.Id).ToArray();
|
var isStockDetailUpdated = _PalletStockInfoDetailRepository.DeleteDataByIds(ids);
|
var isStockAdd = SqlSugarHelper.DbWMS.Insertable(details).ExecuteCommand();
|
}
|
|
var location = SqlSugarHelper.DbWMS.Queryable<DtLocationInfo>().FirstAsync(x => x.LocationCode == stock.LocationCode).Result;
|
int beforeStatue = location.LocationStatus;
|
location.LocationStatus = (int)LocationEnum.Lock;
|
SqlSugarHelper.DbWMS.Updateable(location).ExecuteCommandHasChange();
|
|
_locationStatusChangeRecordRepository.AddLocationStatusChangeRecord(location, beforeStatue, (int)StatusChangeTypeEnum.ManualOperation, 0);
|
}
|
|
return content.OK("删除成功");
|
}
|
catch (Exception ex)
|
{
|
return content.Error(ex.Message);
|
}
|
}
|
}
|
