public void CreateStockTakeMaster(StockTakeMaster stockTakeMaster)
{
stockTakeMaster.StNo = numberControlMgr.GetStockTakeNo(stockTakeMaster);
this.genericMgr.Create(stockTakeMaster);
this.genericMgr.FlushSession();
IList<Location> locs = genericMgr.FindAll<Location>("from Location where IsActive = 1 and Region = ?", stockTakeMaster.Region);
if (locs != null && locs.Count > 0)
{
foreach (var loc in locs)
{
this.genericMgr.Create(new StockTakeLocation
{
StNo = stockTakeMaster.StNo,
Location = loc.Code,
LocationName = loc.Name,
});
}
}
}
private void TryCloseStockTakeMaster(StockTakeMaster stockTakeMaster)
{
if (stockTakeMaster.Status == CodeMaster.StockTakeStatus.Complete)
{
this.genericMgr.FlushSession();
long counter = this.genericMgr.FindAll<long>("select count(*) as counter from StockTakeResult where StNo = ? and IsAdjust = ? and QualityType=? ",
new Object[] { stockTakeMaster.StNo, false, (int)CodeMaster.QualityType.Qualified })[0];
if (counter == 0)
{
DoCloseStockTakeMaster(stockTakeMaster);
}
}
}
private void RecordLocationTransaction(StockTakeMaster stockTakeMaster, StockTakeResult stockTakeResult, DateTime effectiveDate, IList<InventoryTransaction> inventoryTransactionList)
{
DateTime dateTimeNow = DateTime.Now;
//根据PlanBill和ActingBill分组，为了不同供应商的库存事务分开
var groupedInventoryTransactionList = from trans in inventoryTransactionList
group trans by new
{
IsConsignment = trans.IsConsignment,
PlanBill = trans.PlanBill,
ActingBill = trans.ActingBill
}
into result
select new
{
IsConsignment = result.Key.IsConsignment,
PlanBill = result.Key.PlanBill,
ActingBill = result.Key.ActingBill,
Qty = result.Sum(trans => trans.Qty),
PlanBillQty = result.Sum(trans => trans.PlanBillQty),
ActingBillQty = result.Sum(trans => trans.ActingBillQty),
InventoryTransactionList = result.ToList()
};
foreach (var groupedInventoryTransaction in groupedInventoryTransactionList)
{
LocationTransaction locationTransaction = new LocationTransaction();
locationTransaction.OrderNo = stockTakeResult.StNo;
//locationTransaction.OrderType = ;
//locationTransaction.OrderSubType = ;
//locationTransaction.OrderDetailSequence =;
//locationTransaction.OrderDetailId =;
//locationTransaction.OrderBomDetId =
//locationTransaction.IpNo =
//locationTransaction.IpDetailId =
//locationTransaction.IpDetailSequence =
//locationTransaction.ReceiptNo =
//locationTransaction.ReceiptDetailId =
//locationTransaction.ReceiptDetailSequence =
//locationTransaction.SequenceNo =
//locationTransaction.TraceCode = ;
locationTransaction.Item = stockTakeResult.Item;
locationTransaction.Uom = stockTakeResult.Uom;
locationTransaction.BaseUom = stockTakeResult.Uom;
locationTransaction.Qty = groupedInventoryTransaction.Qty;
locationTransaction.UnitQty = 1;
locationTransaction.IsConsignment = groupedInventoryTransaction.IsConsignment;
if (groupedInventoryTransaction.IsConsignment && groupedInventoryTransaction.PlanBill.HasValue)
{
locationTransaction.PlanBill = groupedInventoryTransaction.PlanBill.Value;
}
locationTransaction.PlanBillQty = groupedInventoryTransaction.PlanBillQty;
if (groupedInventoryTransaction.ActingBill.HasValue)
{
locationTransaction.ActingBill = groupedInventoryTransaction.ActingBill.Value;
}
locationTransaction.ActingBillQty = groupedInventoryTransaction.ActingBillQty;
locationTransaction.QualityType = stockTakeResult.QualityType;
locationTransaction.HuId = stockTakeResult.HuId;
locationTransaction.LotNo = stockTakeResult.LotNo;
locationTransaction.TransactionType = CodeMaster.TransactionType.CYC_CNT;
locationTransaction.IOType = stockTakeResult.DifferenceQty < 0 ? CodeMaster.TransactionIOType.Out : CodeMaster.TransactionIOType.In;
locationTransaction.PartyFrom = stockTakeMaster.Region;
locationTransaction.PartyTo = stockTakeMaster.Region;
locationTransaction.LocationFrom = stockTakeResult.Location;
locationTransaction.LocationTo = stockTakeResult.Location;
locationTransaction.LocationIOReason = string.Empty;
locationTransaction.EffectiveDate = effectiveDate;
locationTransaction.CreateUserId = SecurityContextHolder.Get().Id;
locationTransaction.CreateDate = dateTimeNow;
this.genericMgr.Create(locationTransaction);
RecordLocationTransactionDetail(locationTransaction, inventoryTransactionList);
}
}
public IList<StockTakeResult> ListStockTakeResultDetail(StockTakeMaster stockTakeMaster, bool listShortage, bool listProfit, bool listMatch, IList<string> locationList, IList<string> binList, IList<string> itemList, DateTime? BaseInventoryDate)
{
if (stockTakeMaster.Status == CodeMaster.StockTakeStatus.Create
|| stockTakeMaster.Status == CodeMaster.StockTakeStatus.Cancel
|| stockTakeMaster.Status == CodeMaster.StockTakeStatus.Submit)
{
throw new BusinessException("盘点单{0}的状态为{1}，不能显示盘点结果。", stockTakeMaster.StNo,
this.systemMgr.GetCodeDetailDescription(com.Sconit.CodeMaster.CodeMaster.StockTakeStatus, ((int)stockTakeMaster.Status).ToString()));
}
IList<StockTakeResult> stockTakeResultList = new List<StockTakeResult>();
if (stockTakeMaster.Status == CodeMaster.StockTakeStatus.InProcess)
{
#region 执行中返回库存和盘点结果比较值
stockTakeResultList = CalStockTakeResult(stockTakeMaster, listShortage, listProfit, listMatch, locationList, binList, itemList, BaseInventoryDate);
#endregion
}
else
{
#region 查询点明细结果，只有条码才有
string selectStatement = @"from StockTakeResult where StNo = ? ";
IList<object> selectParas = new List<object>();
selectParas.Add(stockTakeMaster.StNo);
if (listShortage)
{
selectStatement += " and DifferenceQty<0";
}
else if (listProfit)
{
selectStatement += " and DifferenceQty>0";
}
else
{
selectStatement += " and DifferenceQty=0";
}
selectStatement += GetWhereStatement(selectParas, itemList, locationList, binList);
stockTakeResultList = this.genericMgr.FindAll<StockTakeResult>(selectStatement, selectParas.ToArray());
#endregion
}
return stockTakeResultList;
}
public void BatchUpdateStockTakeLocations(StockTakeMaster stockTakeMaster, IList<Location> addLocaitons, IList<Location> deleteLocations)
{
#region 检查
if (stockTakeMaster.Status != CodeMaster.StockTakeStatus.Create)
{
throw new BusinessException("状态为{1}的盘点单{0}不能添加库位。", stockTakeMaster.StNo,
this.systemMgr.GetCodeDetailDescription(com.Sconit.CodeMaster.CodeMaster.StockTakeStatus, ((int)stockTakeMaster.Status).ToString()));
}
#region 判断是否有重复库位
if (addLocaitons != null && addLocaitons.Count > 0)
{
IList<string> locCodes = addLocaitons.Select(l => l.Code).ToList();
#region 查询盘点库位列表
IList<string> stockTakeLocationList = this.genericMgr.FindAll<string>(SelectStockTakeLocationStatement, stockTakeMaster.StNo);
#endregion
if (stockTakeLocationList != null && stockTakeLocationList.Count > 0)
{
((List<string>)locCodes).AddRange(stockTakeLocationList);
}
var locCounts = from loc in locCodes
group loc by loc into result
select new
{
LocationCode = result.Key,
Count = result.Count()
};
BusinessException businessException = new BusinessException();
foreach (var locCount in locCounts.Where(l => l.Count > 1))
{
businessException.AddMessage("不能重复添加库位{0}", locCount.LocationCode);
}
if (businessException.HasMessage)
{
throw businessException;
}
}
#endregion
#endregion
#region 新增盘点库位
if (addLocaitons != null && addLocaitons.Count > 0)
{
IList<StockTakeLocation> addStockTakeLocationList = (from loc in addLocaitons
select new StockTakeLocation
{
StNo = stockTakeMaster.StNo,
Location = loc.Code,
LocationName = loc.Name,
Bins = loc.Bins
}).ToList();
foreach (StockTakeLocation addStockTakeLocation in addStockTakeLocationList)
{
this.genericMgr.Create(addStockTakeLocation);
}
}
#endregion
#region 删除盘点库位
if (deleteLocations != null && deleteLocations.Count > 0)
{
string deleteStockTakeLocationStatement = string.Empty;
IList<object> deleteStockTakeLocationParas = new List<object>();
IList<IType> deleteStockTakeLocationTypes = new List<IType>();
foreach (Location location in deleteLocations)
{
if (deleteStockTakeLocationStatement == string.Empty)
{
deleteStockTakeLocationStatement = "from StockTakeLocation where StNo = ? and Location in (?";
deleteStockTakeLocationParas.Add(stockTakeMaster.StNo);
deleteStockTakeLocationTypes.Add(NHibernateUtil.String);
}
else
{
deleteStockTakeLocationStatement += ", ?";
}
deleteStockTakeLocationParas.Add(location.Code);
deleteStockTakeLocationTypes.Add(NHibernateUtil.String);
}
this.genericMgr.Delete(deleteStockTakeLocationStatement, deleteStockTakeLocationParas.ToArray(), deleteStockTakeLocationTypes.ToArray());
}
#endregion
}
public void CancelStockTakeMaster(StockTakeMaster stockTakeMaster)
{
if (stockTakeMaster.Status == CodeMaster.StockTakeStatus.Create
|| stockTakeMaster.Status == CodeMaster.StockTakeStatus.Cancel
|| stockTakeMaster.Status == CodeMaster.StockTakeStatus.Close)
{
throw new BusinessException("盘点单{0}的状态为{1}，不能取消。",
stockTakeMaster.StNo,
this.systemMgr.GetCodeDetailDescription(com.Sconit.CodeMaster.CodeMaster.StockTakeStatus, ((int)stockTakeMaster.Status).ToString()));
}
User user = SecurityContextHolder.Get();
stockTakeMaster.Status = CodeMaster.StockTakeStatus.Cancel;
stockTakeMaster.CancelUserId = user.Id;
stockTakeMaster.CancelUserName = user.FullName;
stockTakeMaster.CancelDate = DateTime.Now;
this.genericMgr.Update(stockTakeMaster);
}
public void StartStockTakeMaster(StockTakeMaster stockTakeMaster)
{
if (stockTakeMaster.Status != CodeMaster.StockTakeStatus.Submit)
{
throw new BusinessException(Resources.INV.StockTake.Error_StatusErrorWhenSubmit,
stockTakeMaster.StNo,
this.systemMgr.GetCodeDetailDescription(com.Sconit.CodeMaster.CodeMaster.StockTakeStatus, ((int)stockTakeMaster.Status).ToString()));
}
User user = SecurityContextHolder.Get();
stockTakeMaster.Status = CodeMaster.StockTakeStatus.InProcess;
stockTakeMaster.StartUserId = user.Id;
stockTakeMaster.StartUserName = user.FullName;
stockTakeMaster.StartDate = DateTime.Now;
#region 记录库存
IList<string> stockTakeLocationList = this.genericMgr.FindAll<string>(SelectStockTakeLocationStatement, stockTakeMaster.StNo);
IList<string> stockTakeItemList = this.genericMgr.FindAll<string>(SelectStockTakeItemStatement, stockTakeMaster.StNo);
if (!stockTakeMaster.EffectiveDate.HasValue)
{
stockTakeMaster.EffectiveDate = DateTime.Now;
}
stockTakeMaster.BaseInventoryDate = DateTime.Now;
var stockTakeInvList = new List<StockTakeInv>();
if (stockTakeMaster.IsScanHu)
{
string selectHuLocationLotDetailStatement = "from LocationLotDetail where HuId is not null ";
IList<object> selectHuLocationLotDetailParm = new List<object>();
selectHuLocationLotDetailStatement += GetWhereStatement(selectHuLocationLotDetailParm, stockTakeItemList, stockTakeLocationList, null);
var locationLotDetailList = this.genericMgr.FindAll<LocationLotDetail>(selectHuLocationLotDetailStatement, selectHuLocationLotDetailParm.ToArray());
stockTakeInvList = (from inv in locationLotDetailList
select new StockTakeInv
{
Location = inv.Location,
Item = inv.Item,
HuId = inv.HuId,
LotNo = inv.LotNo,
Qty = inv.Qty,
QualityType = inv.QualityType,
IsCS = inv.IsConsignment,
Bin = inv.Bin
}).ToList();
}
else
{
string selectLocationLotDetailStatement = "from LocationLotDetail where HuId is null";
IList<object> selectLocationLotDetailParm = new List<object>();
selectLocationLotDetailStatement += GetWhereStatement(selectLocationLotDetailParm, stockTakeItemList, stockTakeLocationList, null);
var locationLotDetailList = this.genericMgr.FindAll<LocationLotDetail>(selectLocationLotDetailStatement, selectLocationLotDetailParm.ToArray());
stockTakeInvList = (from inv in locationLotDetailList
group inv by new { inv.Item, inv.Location, inv.QualityType } into g
select new StockTakeInv
{
Location = g.Key.Location,
Item = g.Key.Item,
QualityType = g.Key.QualityType,
Qty = g.Sum(p => p.Qty)
}).ToList();
//string selectLocationDetailStatement = "from LocationDetailView where HuId is null";
//IList<object> selectLocationDetailParm = new List<object>();
//selectLocationDetailStatement += GetWhereStatement(selectLocationDetailParm, stockTakeItemList, stockTakeLocationList, null);
//IList<LocationDetailView> locationDetailList = this.genericMgr.FindAll<LocationDetailView>(selectLocationDetailStatement, selectLocationDetailParm.ToArray());
//#region 合格品
//stockTakeInvList = (from det in locationDetailList
// where det.QualifyQty != 0
// select new StockTakeInv
// {
// Location = det.Location,
// Item = det.Item,
// Qty = det.QualifyQty,
// QualityType = CodeMaster.QualityType.Qualified,
// }).ToList();
//#endregion
//#region 待验品
//stockTakeInvList.AddRange(from det in locationDetailList
// where det.InspectQty != 0
// select new StockTakeInv
// {
// Location = det.Location,
// Item = det.Item,
// Qty = det.InspectQty,
// QualityType = CodeMaster.QualityType.Inspect,
// });
//#endregion
//#region 不合格品
//stockTakeInvList.AddRange(from det in locationDetailList
// where det.RejectQty != 0
// select new StockTakeInv
// {
// Location = det.Location,
// Item = det.Item,
// Qty = det.RejectQty,
// QualityType = CodeMaster.QualityType.Reject,
// });
//#endregion
}
foreach (var stockTakeInv in stockTakeInvList)
{
stockTakeInv.StNo = stockTakeMaster.StNo;
this.genericMgr.Create(stockTakeInv);
}
#endregion
this.genericMgr.Update(stockTakeMaster);
}
public void DeleteStockTakeMaster(StockTakeMaster stockTakeMaster)
{
if (stockTakeMaster.Status != CodeMaster.StockTakeStatus.Create)
{
throw new BusinessException(Resources.INV.StockTake.Error_StatusErrorWhenDelete,
stockTakeMaster.StNo,
this.systemMgr.GetCodeDetailDescription(com.Sconit.CodeMaster.CodeMaster.StockTakeStatus, ((int)stockTakeMaster.Status).ToString()));
}
this.genericMgr.Delete("from StockTakeItem where StNo = ?", stockTakeMaster.StNo, NHibernateUtil.String);
this.genericMgr.Delete("from StockTakeLocation where StNo = ?", stockTakeMaster.StNo, NHibernateUtil.String);
this.genericMgr.Delete("from StockTakeMaster where StNo = ?", stockTakeMaster.StNo, NHibernateUtil.String);
}
public IList<InventoryTransaction> StockTakeAdjust(StockTakeMaster stockTakeMaster, IList<StockTakeResult> stockTakeResultList)
{
if (stockTakeMaster.EffectiveDate.HasValue)
{
return StockTakeAdjust(stockTakeMaster, stockTakeResultList, stockTakeMaster.EffectiveDate.Value);
}
else
{
return StockTakeAdjust(stockTakeMaster, stockTakeResultList, DateTime.Now);
}
}
private IList<StockTakeResult> CalStockTakeResult(StockTakeMaster stockTakeMaster, bool listShortage, bool listProfit, bool listMatch, IList<string> locationList, IList<string> binList, IList<string> itemList, DateTime? baseInventoryDate)
{
IList<StockTakeResult> stockTakeResultList = new List<StockTakeResult>();
baseInventoryDate = baseInventoryDate.HasValue ? baseInventoryDate : stockTakeMaster.BaseInventoryDate;
if (baseInventoryDate == null)
{
//默认取当天
baseInventoryDate = DateTime.Now;
}
DateTime dateTimeNow = DateTime.Now;
if (stockTakeMaster.IsScanHu)
{
#region 按条码盘点
#region 查找库存
IList<LocationLotDetail> locationLotDetailList = null;
//if (baseInventoryDate.HasValue)
if (1 != 1)
{
if (binList != null && binList.Count > 0)
{
throw new BusinessException("不支持按库格查看条码历史库存。");
}
IList<HuHistoryInventory> historyInventoryList = new List<HuHistoryInventory>();
foreach (string location in locationList)
{
IList<HuHistoryInventory> huHistoryLocationDetails = this.locationDetailMgr.GetHuHistoryLocationDetails(location, itemList, baseInventoryDate.Value);
if (huHistoryLocationDetails != null && huHistoryLocationDetails.Count > 0)
{
((List<HuHistoryInventory>)historyInventoryList).AddRange(huHistoryLocationDetails);
}
}
locationLotDetailList = (from inv in historyInventoryList
select new LocationLotDetail
{
Location = inv.Location,
Item = inv.Item,
HuId = inv.HuId,
LotNo = inv.LotNo,
Qty = inv.Qty,
QualityType = inv.QualityType
}).ToList();
}
else
{
string selectHuLocationLotDetailStatement = "from LocationLotDetail where HuId is not null";
IList<object> selectHuLocationLotDetailParm = new List<object>();
selectHuLocationLotDetailStatement += GetWhereStatement(selectHuLocationLotDetailParm, itemList, locationList, binList);
locationLotDetailList = this.genericMgr.FindAll<LocationLotDetail>(selectHuLocationLotDetailStatement, selectHuLocationLotDetailParm.ToArray());
}
#endregion
#region 查找盘点结果
IList<object> selectStockTakeDetailParm = new List<object>();
selectStockTakeDetailParm.Add(stockTakeMaster.StNo);
string thisSelectStockTakeDetailStatement = SelectStockTakeDetailStatement + GetWhereStatement(selectStockTakeDetailParm, itemList, locationList, binList);
IList<StockTakeDetail> stockTakeDetailList = this.genericMgr.FindAll<StockTakeDetail>(thisSelectStockTakeDetailStatement, selectStockTakeDetailParm.ToArray());
#endregion
#region 盘亏\盘赢\账实相符
#region 盘亏
if (listShortage)
{
if (baseInventoryDate.HasValue)
{
#region 比较历史库存，不看Bin
((List<StockTakeResult>)stockTakeResultList).AddRange((from loc in locationLotDetailList
join tak in stockTakeDetailList
on
new
{
Location = loc.Location,
Item = loc.Item,
HuId = loc.HuId
}
equals
new
{
Location = tak.Location,
Item = tak.Item,
HuId = tak.HuId
}
into gj
from result in gj.DefaultIfEmpty()
where result == null
select new StockTakeResult
{
Item = loc.Item,
HuId = loc.HuId,
LotNo = loc.LotNo,
StockTakeQty = 0,
InventoryQty = loc.Qty,
DifferenceQty = 0 - loc.Qty,
Location = loc.Location,
Bin = string.Empty,
BaseInventoryDate = baseInventoryDate.Value,
QualityType = loc.QualityType,
}).ToList());
#endregion
}
else
{
#region 比较当前库存，看Bin
((List<StockTakeResult>)stockTakeResultList).AddRange((from loc in locationLotDetailList
join tak in stockTakeDetailList
on
new
{
Location = loc.Location,
Bin = loc.Bin,
Item = loc.Item,
HuId = loc.HuId
}
equals
new
{
Location = tak.Location,
Bin = tak.Bin,
Item = tak.Item,
HuId = tak.HuId
}
into gj
from result in gj.DefaultIfEmpty()
where result == null
select new StockTakeResult
{
Item = loc.Item,
HuId = loc.HuId,
LotNo = loc.LotNo,
StockTakeQty = 0,
InventoryQty = loc.Qty,
DifferenceQty = 0 - loc.Qty,
Location = loc.Location,
Bin = loc.Bin,
BaseInventoryDate = dateTimeNow,
QualityType = loc.QualityType,
}).ToList());
#endregion
}
}
#endregion
#region 盘盈
if (listProfit)
{
if (baseInventoryDate.HasValue)
{
#region 比较历史库存，不看Bin
((List<StockTakeResult>)stockTakeResultList).AddRange((from tak in stockTakeDetailList
join loc in locationLotDetailList
on
new
{
Location = tak.Location,
Item = tak.Item,
HuId = tak.HuId
}
equals
new
{
Location = loc.Location,
Item = loc.Item,
HuId = loc.HuId
}
into gj
from result in gj.DefaultIfEmpty()
where result == null
select new StockTakeResult
{
Item = tak.Item,
ItemDescription = tak.ItemDescription,
Uom = tak.BaseUom,
HuId = tak.HuId,
LotNo = tak.LotNo,
StockTakeQty = tak.Qty * tak.UnitQty,
InventoryQty = 0,
DifferenceQty = tak.Qty * tak.UnitQty,
Location = tak.Location,
//Bin = string.Empty,
BaseInventoryDate = baseInventoryDate.Value,
QualityType = tak.QualityType,
}).ToList());
#endregion
}
else
{
#region 比较当前库存，看Bin
((List<StockTakeResult>)stockTakeResultList).AddRange((from tak in stockTakeDetailList
join loc in locationLotDetailList
on
new
{
Location = tak.Location,
Bin = tak.Bin,
Item = tak.Item,
HuId = tak.HuId
}
equals
new
{
Location = loc.Location,
Bin = loc.Bin,
Item = loc.Item,
HuId = loc.HuId
}
into gj
from result in gj.DefaultIfEmpty()
select new StockTakeResult
{
Item = tak.Item,
ItemDescription = tak.ItemDescription,
Uom = tak.BaseUom,
HuId = tak.HuId,
LotNo = tak.LotNo,
StockTakeQty = tak.Qty * tak.UnitQty,
InventoryQty = 0,
DifferenceQty = tak.Qty * tak.UnitQty,
Location = tak.Location,
Bin = tak.Bin,
BaseInventoryDate = dateTimeNow,
QualityType = tak.QualityType,
}).ToList());
#endregion
}
}
#endregion
#region 账实相符
if (listMatch)
{
if (baseInventoryDate.HasValue)
{
#region 比较历史库存，不看Bin
((List<StockTakeResult>)stockTakeResultList).AddRange((from loc in locationLotDetailList
join tak in stockTakeDetailList
on
new
{
Location = loc.Location,
Item = loc.Item,
HuId = loc.HuId
}
equals
new
{
Location = tak.Location,
Item = tak.Item,
HuId = tak.HuId
}
select new StockTakeResult
{
Item = loc.Item,
ItemDescription = tak.ItemDescription,
Uom = tak.BaseUom,
HuId = loc.HuId,
LotNo = loc.LotNo,
StockTakeQty = loc.Qty,
InventoryQty = loc.Qty,
DifferenceQty = 0,
Location = loc.Location,
Bin = string.Empty,
BaseInventoryDate = baseInventoryDate.Value,
QualityType = loc.QualityType,
}).ToList());
#endregion
}
else
{
#region 比较当前库存，看Bin
((List<StockTakeResult>)stockTakeResultList).AddRange((from loc in locationLotDetailList
join tak in stockTakeDetailList
on
new
{
Location = loc.Location,
Bin = loc.Bin,
Item = loc.Item,
HuId = loc.HuId
}
equals
new
{
Location = tak.Location,
Bin = tak.Bin,
Item = tak.Item,
HuId = tak.HuId
}
select new StockTakeResult
{
Item = loc.Item,
ItemDescription = tak.ItemDescription,
Uom = tak.BaseUom,
HuId = loc.HuId,
LotNo = loc.LotNo,
StockTakeQty = loc.Qty,
InventoryQty = loc.Qty,
DifferenceQty = 0,
Location = loc.Location,
Bin = loc.Bin,
BaseInventoryDate = dateTimeNow,
QualityType = loc.QualityType,
}).ToList());
#endregion
}
}
#endregion
#endregion
#endregion
}
else
{
#region 按数量盘点
#region 查找库存
IList<LocationDetailView> locationDetailList = null;
//if (baseInventoryDate.HasValue)
if (false)
{
IList<HistoryInventory> historyInventoryList = new List<HistoryInventory>();
foreach (string location in locationList)
{
((List<HistoryInventory>)historyInventoryList).AddRange(this.locationDetailMgr.GetHistoryLocationDetails(location, itemList, baseInventoryDate.Value, "", 20, 1));
}
locationDetailList = (from inv in historyInventoryList
select new LocationDetailView
{
Location = inv.Location,
Item = inv.Item,
QualifyQty = inv.QualifyQty,
InspectQty = inv.InspectQty,
RejectQty = inv.RejectQty,
}).ToList();
}
else
{
string selectLocationDetailStatement = "from LocationDetailView where 1 = 1";
IList<object> selectHuLocationDetailParm = new List<object>();
selectLocationDetailStatement += GetWhereStatement(selectHuLocationDetailParm, itemList, locationList, binList);
locationDetailList = this.genericMgr.FindAll<LocationDetailView>(selectLocationDetailStatement, selectHuLocationDetailParm.ToArray());
}
#region 转换为LocationLotDetail
#region 合格品
IList<LocationLotDetail> locationLotDetailList = (from det in locationDetailList
where det.QualifyQty != 0
select new LocationLotDetail
{
Location = det.Location,
Item = det.Item,
Qty = det.QualifyQty,
QualityType = CodeMaster.QualityType.Qualified,
}).ToList();
#endregion
#region 待验品
((List<LocationLotDetail>)locationLotDetailList).AddRange((from det in locationDetailList
where det.InspectQty != 0
select new LocationLotDetail
{
Location = det.Location,
Item = det.Item,
Qty = det.InspectQty,
QualityType = CodeMaster.QualityType.Inspect,
}).ToList());
#endregion
#region 不合格品
((List<LocationLotDetail>)locationLotDetailList).AddRange((from det in locationDetailList
where det.RejectQty != 0
select new LocationLotDetail
{
Location = det.Location,
Item = det.Item,
Qty = det.RejectQty,
QualityType = CodeMaster.QualityType.Reject,
}).ToList());
#endregion
#endregion
#endregion
#region 查找盘点结果
IList<object> selectStockTakeDetailParm = new List<object>();
selectStockTakeDetailParm.Add(stockTakeMaster.StNo);
string thisSelectStockTakeDetailStatement = SelectStockTakeDetailStatement + GetWhereStatement(selectStockTakeDetailParm, itemList, locationList, binList);
IList<StockTakeDetail> stockTakeDetailList = this.genericMgr.FindAll<StockTakeDetail>(thisSelectStockTakeDetailStatement, selectStockTakeDetailParm.ToArray());
#endregion
#region 计算盘点差异
((List<StockTakeResult>)stockTakeResultList).AddRange(from tak in stockTakeDetailList
join inv in locationLotDetailList
on new { Location = tak.Location, Item = tak.Item, QualityType = tak.QualityType }
equals new { Location = inv.Location, Item = inv.Item, QualityType = inv.QualityType }
into gj
from result in gj.DefaultIfEmpty()
select new StockTakeResult
{
Location = tak.Location,
Item = tak.Item,
ItemDescription = tak.ItemDescription,
Uom = tak.BaseUom,
StockTakeQty = tak.Qty * tak.UnitQty,
InventoryQty = result != null ? result.Qty : 0,
DifferenceQty = tak.Qty * tak.UnitQty - (result != null ? result.Qty : 0),
BaseInventoryDate = baseInventoryDate.Value,
QualityType = tak.QualityType,
});
((List<StockTakeResult>)stockTakeResultList).AddRange(from inv in locationLotDetailList
join tak in stockTakeDetailList
on new { Location = inv.Location, Item = inv.Item, QualityType = inv.QualityType }
equals new { Location = tak.Location, Item = tak.Item, QualityType = tak.QualityType }
into gj
from result2 in gj.DefaultIfEmpty()
where result2 == null
select new StockTakeResult
{
Location = inv.Location,
Item = inv.Item,
StockTakeQty = 0,
InventoryQty = inv.Qty,
DifferenceQty = 0 - inv.Qty,
BaseInventoryDate = baseInventoryDate.Value,
QualityType = inv.QualityType,
});
#endregion
#region 根据查询条件过滤
if (!(listShortage && listProfit && listMatch))
{
if (listShortage)
{
if (listProfit)
{
stockTakeResultList = stockTakeResultList.Where(c => c.DifferenceQty != 0).ToList();
}
else if (listMatch)
{
stockTakeResultList = stockTakeResultList.Where(c => c.DifferenceQty <= 0).ToList();
}
else
{
stockTakeResultList = stockTakeResultList.Where(c => c.DifferenceQty < 0).ToList();
}
}
else if (listProfit)
{
if (listMatch)
{
stockTakeResultList = stockTakeResultList.Where(c => c.DifferenceQty >= 0).ToList();
}
else
{
stockTakeResultList = stockTakeResultList.Where(c => c.DifferenceQty > 0).ToList();
}
}
else
{
stockTakeResultList = stockTakeResultList.Where(c => c.DifferenceQty == 0).ToList();
}
}
#endregion
#endregion
}
#region 查询零件描述和基本单位
IList<string> noDescItemList = stockTakeResultList.Where(s => string.IsNullOrWhiteSpace(s.Uom)).Select(s => s.Item).ToList();
if (noDescItemList != null && noDescItemList.Count > 0)
{
string selectItemStatement = string.Empty;
IList<object> selectItemParm = new List<object>();
foreach (string item in noDescItemList)
{
if (selectItemStatement == string.Empty)
{
selectItemStatement = "from Item where Code in (?";
}
else
{
selectItemStatement += ",?";
}
selectItemParm.Add(item);
}
selectItemStatement += ")";
IList<Item> itemList2 = this.genericMgr.FindAll<Item>(selectItemStatement, selectItemParm.ToArray());
foreach (StockTakeResult stockTakeResult in stockTakeResultList.Where(s => string.IsNullOrWhiteSpace(s.Uom)))
{
Item item = itemList2.Where(i => i.Code == stockTakeResult.Item).Single();
stockTakeResult.ItemDescription = item.Description;
stockTakeResult.Uom = item.Uom;
}
}
#endregion
stockTakeResultList = stockTakeResultList.OrderBy(c => c.Item).ThenBy(c => c.DifferenceQty).ToList();
return stockTakeResultList;
}
public void RecordStockTakeDetail(StockTakeMaster stockTakeMaster, IList<StockTakeDetail> stockTakeDetailList)
{
#region 校验
if (stockTakeDetailList == null || stockTakeDetailList.Count == 0)
{
throw new BusinessException("盘点明细不能为空。");
}
IList<StockTakeDetail> noneZeroStockTakeDetailList = stockTakeDetailList.Where(d => d.Qty > 0).ToList();
if (stockTakeMaster.Status != CodeMaster.StockTakeStatus.InProcess)
{
throw new BusinessException("盘点单{0}的状态为{1}，不能盘点。", stockTakeMaster.StNo,
this.systemMgr.GetCodeDetailDescription(com.Sconit.CodeMaster.CodeMaster.StockTakeStatus, ((int)stockTakeMaster.Status).ToString()));
}
#region 检查库位是否正确
BusinessException businessException = new BusinessException();
IList<string> stockTakeLocationList = this.genericMgr.FindAll<string>(SelectStockTakeLocationStatement, stockTakeMaster.StNo);
foreach (string location in noneZeroStockTakeDetailList.Select(s => s.Location).Distinct())
{
if (!stockTakeLocationList.Contains(location))
{
businessException.AddMessage("库位{0}不在待盘点的库位列表中。", location);
}
}
#endregion
#region 检查零件是否正确
if (stockTakeMaster.Type == CodeMaster.StockTakeType.Part)
{
IList<string> stockTakeItemList = this.genericMgr.FindAll<string>(SelectStockTakeItemStatement, stockTakeMaster.StNo);
foreach (string item in noneZeroStockTakeDetailList.Select(s => s.Item).Distinct())
{
if (!stockTakeItemList.Contains(item))
{
businessException.AddMessage("零件{0}不在待盘点的零件列表中。", item);
}
}
}
#endregion
#region 检查盘点明细是否重复
if (stockTakeMaster.IsScanHu)
{
//按条码盘点查询条码
IList<string> takedDetailList = this.genericMgr.FindAll<string>("select HuId from StockTakeDetail where StNo = ?", stockTakeMaster.StNo);
if (takedDetailList != null && takedDetailList.Count > 0)
{
foreach (StockTakeDetail stockTakeDetail in noneZeroStockTakeDetailList)
{
//判断条码是否重复
if (takedDetailList.Contains(stockTakeDetail.HuId))
{
businessException.AddMessage("条码{0}重复盘点。", stockTakeDetail.HuId);
}
takedDetailList.Add(stockTakeDetail.HuId);
}
}
}
else
{
//按数量盘点查询零件号
IList<object[]> takedDetailList = this.genericMgr.FindAll<object[]>("select distinct Item, QualityType from StockTakeDetail where StNo = ?", stockTakeMaster.StNo);
if (takedDetailList != null && takedDetailList.Count > 0)
{
var duplicatedTakeDetailList = from takedDet in takedDetailList
join stockTakeDetail in noneZeroStockTakeDetailList
on new
{
Item = (string)takedDet[0],
QualityType = (CodeMaster.QualityType)takedDet[1]
} equals new { Item = stockTakeDetail.Item, QualityType = stockTakeDetail.QualityType }
select new
{
Item = stockTakeDetail.Item,
QualityType = stockTakeDetail.QualityType,
};
if (duplicatedTakeDetailList != null && duplicatedTakeDetailList.Count() > 0)
{
foreach (var duplicatedTakeDetail in duplicatedTakeDetailList)
{
businessException.AddMessage("质量状态为{1}的零件{0}重复盘点。", duplicatedTakeDetail.Item,
this.systemMgr.GetCodeDetailDescription(com.Sconit.CodeMaster.CodeMaster.QualityType, ((int)duplicatedTakeDetail.QualityType).ToString()));
}
}
}
}
#endregion
if (businessException.HasMessage)
{
throw businessException;
}
#endregion
#region 上架
if (stockTakeMaster.IsScanHu)
{
this.locationDetailMgr.InventoryPut(noneZeroStockTakeDetailList);
}
#endregion
#region 循环更新盘点明细
string selectItemStatement = string.Empty;
IList<object> selectItemParas = new List<object>();
foreach (StockTakeDetail stockTakeDetail in stockTakeDetailList)
{
if (selectItemStatement == string.Empty)
{
selectItemStatement = "from Item where Code in(?";
}
else
{
selectItemStatement += ",?";
}
selectItemParas.Add(stockTakeDetail.Item);
}
selectItemStatement += ")";
IList<Item> itemList = this.genericMgr.FindAll<Item>(selectItemStatement, selectItemParas.ToArray());
foreach (StockTakeDetail stockTakeDetail in stockTakeDetailList)
{
stockTakeDetail.StNo = stockTakeMaster.StNo;
#region 计算基本单位和转换率
stockTakeDetail.BaseUom = itemList.Where(i => i.Code == stockTakeDetail.Item).Single().Uom;
if (stockTakeDetail.BaseUom != stockTakeDetail.Uom)
{
stockTakeDetail.UnitQty = this.itemMgr.ConvertItemUomQty(stockTakeDetail.Item, stockTakeDetail.Uom, 1, stockTakeDetail.BaseUom);
}
else
{
stockTakeDetail.UnitQty = 1;
}
#endregion
this.genericMgr.Create(stockTakeDetail);
}
//this.genericMgr.Update(stockTakeMaster);
#endregion
}
public void StartStockTakeMaster(StockTakeMaster stockTakeMaster)
{
if (stockTakeMaster.Status != CodeMaster.StockTakeStatus.Submit)
{
throw new BusinessException(Resources.INV.StockTake.Error_StatusErrorWhenSubmit,
stockTakeMaster.StNo,
this.systemMgr.GetCodeDetailDescription(com.Sconit.CodeMaster.CodeMaster.StockTakeStatus, ((int)stockTakeMaster.Status).ToString()));
}
User user = SecurityContextHolder.Get();
stockTakeMaster.Status = CodeMaster.StockTakeStatus.InProcess;
stockTakeMaster.StartUserId = user.Id;
stockTakeMaster.StartUserName = user.FullName;
stockTakeMaster.StartDate = DateTime.Now;
this.genericMgr.Update(stockTakeMaster);
}
private IList<StockTakeResult> CalStockTakeResult(StockTakeMaster stockTakeMaster, bool listShortage, bool listProfit, bool listMatch, IList<string> locationList, IList<string> binList, IList<string> itemList)
{
IList<StockTakeResult> stockTakeResultList = new List<StockTakeResult>();
DateTime dateTimeNow = DateTime.Now;
if (true)
{
//if (locationList == null || locationList.Count == 0)
//{
// var stockLocs = this.genericMgr.FindAll<StockTakeLocation>(" from StockTakeLocation as s where s.StNo=? ",stockTakeMaster.StNo);
// locationList = stockLocs.Select(s => s.Location).ToList();
//}
#region 按数量盘点
#region 查找库存
IList<StockTakeLocationLotDet> locationDetailList = null;
string selectLocationDetailStatement = "from StockTakeLocationLotDet as lot where 1 = 1 and lot.RefNo=? and exists( select 1 from StockTakeLocation as s where s.Location=lot.Location and s.StNo=? )";
IList<object> selectHuLocationDetailParm = new List<object>();
selectHuLocationDetailParm.Add(stockTakeMaster.RefNo);
selectHuLocationDetailParm.Add(stockTakeMaster.StNo);
selectLocationDetailStatement += GetWhereStatement(selectHuLocationDetailParm, itemList, locationList, binList);
locationDetailList = this.genericMgr.FindAll<StockTakeLocationLotDet>(selectLocationDetailStatement, selectHuLocationDetailParm.ToArray());
#endregion
#region 查找盘点结果
IList<object> selectStockTakeDetailParm = new List<object>();
selectStockTakeDetailParm.Add(stockTakeMaster.StNo);
string thisSelectStockTakeDetailStatement = SelectStockTakeDetailStatement + GetWhereStatement(selectStockTakeDetailParm, itemList, locationList, binList);
IList<StockTakeDetail> stockTakeDetailList = this.genericMgr.FindAll<StockTakeDetail>(thisSelectStockTakeDetailStatement, selectStockTakeDetailParm.ToArray());
#endregion
#region 计算盘点差异
((List<StockTakeResult>)stockTakeResultList).AddRange(from tak in stockTakeDetailList
join inv in locationDetailList
on new { Location = tak.Location, Item = tak.Item, QualityType = tak.QualityType, IsConsigement = tak.IsConsigement, CSSupplier = tak.CSSupplier }
equals new { Location = inv.Location, Item = inv.Item, QualityType = inv.QualityType, IsConsigement = inv.IsConsigement, CSSupplier = inv.CSSupplier }
into gj
from result in gj.DefaultIfEmpty()
select new StockTakeResult
{
Location = tak.Location,
Item = tak.Item,
ItemDescription = tak.ItemDescription,
RefItemCode = tak.RefItemCode,
Uom = tak.BaseUom,
StockTakeQty = tak.Qty * tak.UnitQty,
InventoryQty = result != null ? result.Qty : 0,
DifferenceQty = tak.Qty * tak.UnitQty - (result != null ? result.Qty : 0),
//BaseInventoryDate = baseInventoryDate.Value,
QualityType = tak.QualityType,
IsConsigement = tak.IsConsigement,
CSSupplier = tak.CSSupplier,
});
//库存中有 盘点明细中没有
((List<StockTakeResult>)stockTakeResultList).AddRange(from inv in locationDetailList
join tak in stockTakeDetailList
on new { Location = inv.Location, Item = inv.Item, QualityType = inv.QualityType }
equals new { Location = tak.Location, Item = tak.Item, QualityType = tak.QualityType }
into gj
from result2 in gj.DefaultIfEmpty()
where result2 == null
select new StockTakeResult
{
Location = inv.Location,
Item = inv.Item,
ItemDescription = inv.ItemDesc,
RefItemCode = inv.RefItemCode,
Uom = inv.Uom,
StockTakeQty = 0,
InventoryQty = inv.Qty,
DifferenceQty = 0 - inv.Qty,
//BaseInventoryDate = baseInventoryDate.Value,
QualityType = inv.QualityType,
IsConsigement = inv.IsConsigement,
CSSupplier = inv.CSSupplier,
});
#endregion
#region 根据查询条件过滤
if (!(listShortage && listProfit && listMatch))
{
if (listShortage)
{
if (listProfit)
{
stockTakeResultList = stockTakeResultList.Where(c => c.DifferenceQty != 0).ToList();
}
else if (listMatch)
{
stockTakeResultList = stockTakeResultList.Where(c => c.DifferenceQty <= 0).ToList();
}
else
{
stockTakeResultList = stockTakeResultList.Where(c => c.DifferenceQty < 0).ToList();
}
}
else if (listProfit)
{
if (listMatch)
{
stockTakeResultList = stockTakeResultList.Where(c => c.DifferenceQty >= 0).ToList();
}
else
{
stockTakeResultList = stockTakeResultList.Where(c => c.DifferenceQty > 0).ToList();
}
}
else
{
stockTakeResultList = stockTakeResultList.Where(c => c.DifferenceQty == 0).ToList();
}
}
#endregion
#endregion
}
stockTakeResultList = stockTakeResultList.OrderBy(c => c.Item).ThenBy(c => c.DifferenceQty).ToList();
return stockTakeResultList;
}
private void DoCloseStockTakeMaster(StockTakeMaster stockTakeMaster)
{
stockTakeMaster.CloseDate = DateTime.Now;
stockTakeMaster.Status = CodeMaster.StockTakeStatus.Close;
User user = SecurityContextHolder.Get();
stockTakeMaster.CloseUserId = user.Id;
stockTakeMaster.CloseUserName = user.FullName;
this.genericMgr.Update(stockTakeMaster);
}
public IList<InventoryTransaction> StockTakeAdjust(StockTakeMaster stockTakeMaster, IList<StockTakeResult> stockTakeResultList, DateTime effectiveDate)
{
List<InventoryTransaction> inventoryTransactionList = new List<InventoryTransaction>();
if (stockTakeResultList != null && stockTakeResultList.Count > 0)
{
foreach (StockTakeResult stockTakeResult in stockTakeResultList)
{
if (stockTakeResult.DifferenceQty == 0)
{
continue;
}
if (stockTakeResult.QualityType == CodeMaster.QualityType.Inspect
|| stockTakeResult.QualityType == CodeMaster.QualityType.Reject)
{
//待验的库存不能调整。
throw new TechnicalException("Can't adjust inspect/reject inventory.");
}
InventoryIO inventoryIO = new InventoryIO();
inventoryIO.Location = stockTakeResult.Location;
inventoryIO.Bin = stockTakeResult.Bin;
inventoryIO.Item = stockTakeResult.Item;
inventoryIO.HuId = stockTakeResult.HuId;
inventoryIO.LotNo = stockTakeResult.LotNo;
inventoryIO.Qty = stockTakeResult.DifferenceQty; //盘亏为负数，出库。盘盈为正数，入库。
inventoryIO.QualityType = stockTakeResult.QualityType;
inventoryIO.IsATP = stockTakeResult.QualityType == com.Sconit.CodeMaster.QualityType.Qualified;
inventoryIO.IsFreeze = false;
inventoryIO.IsCreatePlanBill = false;
inventoryIO.IsConsignment = false;
inventoryIO.PlanBill = null;
inventoryIO.ActingBill = null;
inventoryIO.TransactionType = CodeMaster.TransactionType.CYC_CNT;
inventoryIO.OccupyType = CodeMaster.OccupyType.None;
inventoryIO.OccupyReferenceNo = null;
inventoryIO.IsVoid = false;
inventoryIO.EffectiveDate = effectiveDate;
//inventoryIO.ManufactureParty = ;
IList<InventoryTransaction> currentInventoryTransactionList = RecordInventory(inventoryIO);
RecordLocationTransaction(stockTakeMaster, stockTakeResult, effectiveDate, currentInventoryTransactionList);
inventoryTransactionList.AddRange(currentInventoryTransactionList);
}
}
return inventoryTransactionList;
}
public void BatchUpdateStockTakeDetails(StockTakeMaster stockTakeMaster,
IList<StockTakeDetail> addStockDetailList, IList<StockTakeDetail> updateStockDetailList, IList<StockTakeDetail> deleteStockDetailList)
{
if (stockTakeMaster.Status != CodeMaster.StockTakeStatus.InProcess)
{
throw new BusinessException("盘点单{0}的状态为{1}不能修改明细。",
stockTakeMaster.StNo, systemMgr.GetCodeDetailDescription(com.Sconit.CodeMaster.CodeMaster.StockTakeStatus, ((int)stockTakeMaster.Status).ToString()));
}
if (stockTakeMaster.Type == CodeMaster.StockTakeType.Part)
{
var items = this.genericMgr.FindAll<string>(SelectStockTakeItemStatement, stockTakeMaster.StNo);
if (addStockDetailList != null)
{
foreach (StockTakeDetail stockTakeDetail in addStockDetailList)
{
if (!items.Contains(stockTakeDetail.Item))
{
throw new BusinessException("盘点单{0}的物料{1}不在抽盘明细中。",
stockTakeMaster.StNo, stockTakeDetail.Item);
}
}
}
if (updateStockDetailList != null)
{
foreach (StockTakeDetail stockTakeDetail in updateStockDetailList)
{
if (!items.Contains(stockTakeDetail.Item))
{
throw new BusinessException("盘点单{0}的物料{1}不在抽盘明细中。",
stockTakeMaster.StNo, stockTakeDetail.Item);
}
}
}
}
IList<string> stockTakeLocationList = this.genericMgr.FindAll<string>(SelectStockTakeLocationStatement, stockTakeMaster.StNo);
if (addStockDetailList != null)
{
foreach (StockTakeDetail stockTakeDetail in addStockDetailList)
{
if (!stockTakeLocationList.Contains(stockTakeDetail.Location))
{
throw new BusinessException("盘点单{0}的库位{1}不在抽盘明细中。", stockTakeMaster.StNo, stockTakeDetail.Location);
}
}
}
if (updateStockDetailList != null)
{
foreach (StockTakeDetail stockTakeDetail in updateStockDetailList)
{
if (!stockTakeLocationList.Contains(stockTakeDetail.Location))
{
throw new BusinessException("盘点单{0}的库位{1}不在抽盘明细中。", stockTakeMaster.StNo, stockTakeDetail.Location);
}
}
}
#region 新增盘点明细
if (addStockDetailList != null && addStockDetailList.Count > 0)
{
#region 数量处理
foreach (StockTakeDetail stockTakeDetail in addStockDetailList)
{
Item item = this.genericMgr.FindById<Item>(stockTakeDetail.Item);
stockTakeDetail.StNo = stockTakeMaster.StNo;
stockTakeDetail.ItemDescription = item.Description;
if (stockTakeDetail.Uom == null)
{
stockTakeDetail.Uom = item.Uom;
}
stockTakeDetail.BaseUom = item.Uom;
if (stockTakeDetail.Uom != stockTakeDetail.BaseUom)
{
stockTakeDetail.UnitQty = this.itemMgr.ConvertItemUomQty(stockTakeDetail.Item, stockTakeDetail.Uom, 1, stockTakeDetail.BaseUom);
}
else
{
stockTakeDetail.UnitQty = 1;
}
this.genericMgr.Create(stockTakeDetail);
if (stockTakeMaster.StockTakeDetails == null)
{
stockTakeMaster.StockTakeDetails = new List<StockTakeDetail>();
}
stockTakeMaster.StockTakeDetails.Add(stockTakeDetail);
}
#endregion
}
#endregion
#region 修改盘点明细
if (updateStockDetailList != null && updateStockDetailList.Count > 0)
{
foreach (StockTakeDetail stockTakeDetail in updateStockDetailList)
{
if (stockTakeDetail.Uom != stockTakeDetail.BaseUom)
{
stockTakeDetail.UnitQty = this.itemMgr.ConvertItemUomQty(stockTakeDetail.Item, stockTakeDetail.BaseUom, 1, stockTakeDetail.Uom);
}
else
{
stockTakeDetail.UnitQty = 1;
}
this.genericMgr.Update(stockTakeDetail);
}
}
#endregion
#region 删除盘点明细
if (deleteStockDetailList != null && deleteStockDetailList.Count > 0)
{
#region 数量处理
foreach (StockTakeDetail stockTakeDetail in deleteStockDetailList)
{
this.genericMgr.Delete(stockTakeDetail);
}
#endregion
}
#endregion
}
private void RecordLocationTransaction(StockTakeMaster stockTakeMaster, StockTakeResult stockTakeResult, DateTime effectiveDate, IList<InventoryTransaction> inventoryTransactionList)
{
DateTime dateTimeNow = DateTime.Now;
LocationTransaction locationTransaction = new LocationTransaction();
locationTransaction.OrderNo = stockTakeResult.StNo;
//locationTransaction.OrderType = ;
//locationTransaction.OrderSubType = ;
//locationTransaction.OrderDetailSequence =;
//locationTransaction.OrderDetailId =;
//locationTransaction.OrderBomDetId =
//locationTransaction.IpNo =
//locationTransaction.IpDetailId =
//locationTransaction.IpDetailSequence =
//locationTransaction.ReceiptNo =
//locationTransaction.ReceiptDetailId =
//locationTransaction.ReceiptDetailSequence =
//locationTransaction.SequenceNo =
//locationTransaction.TraceCode = ;
locationTransaction.Item = stockTakeResult.Item;
locationTransaction.Uom = stockTakeResult.Uom;
locationTransaction.BaseUom = stockTakeResult.Uom;
locationTransaction.Qty = stockTakeResult.DifferenceQty;
locationTransaction.UnitQty = 1;
locationTransaction.ActingBillQty = inventoryTransactionList.Sum(i => i.ActingBillQty);
locationTransaction.QualityType = stockTakeResult.QualityType;
locationTransaction.HuId = stockTakeResult.HuId;
locationTransaction.LotNo = stockTakeResult.LotNo;
locationTransaction.TransactionType = CodeMaster.TransactionType.CYC_CNT;
locationTransaction.IOType = stockTakeResult.DifferenceQty < 0 ? CodeMaster.TransactionIOType.Out : CodeMaster.TransactionIOType.In;
locationTransaction.PartyFrom = stockTakeMaster.Region;
locationTransaction.PartyTo = stockTakeMaster.Region;
locationTransaction.LocationFrom = stockTakeResult.Location;
locationTransaction.LocationTo = stockTakeResult.Location;
locationTransaction.LocationIOReason = stockTakeMaster.CostCenter;
locationTransaction.EffectiveDate = effectiveDate;
locationTransaction.CreateUserId = SecurityContextHolder.Get().Id;
locationTransaction.CreateDate = dateTimeNow;
this.genericMgr.Create(locationTransaction);
RecordLocationTransactionDetail(locationTransaction, inventoryTransactionList);
}
public void ReleaseStockTakeMaster(StockTakeMaster stockTakeMaster)
{
if (stockTakeMaster.Status != CodeMaster.StockTakeStatus.Create)
{
throw new BusinessException(Resources.INV.StockTake.Error_StatusErrorWhenSubmit,
stockTakeMaster.StNo,
this.systemMgr.GetCodeDetailDescription(com.Sconit.CodeMaster.CodeMaster.StockTakeStatus, ((int)stockTakeMaster.Status).ToString()));
}
IList<string> stockTakeLocationList = this.genericMgr.FindAll<string>(SelectStockTakeLocationStatement, stockTakeMaster.StNo);
if (stockTakeLocationList == null || stockTakeLocationList.Count == 0)
{
throw new BusinessException("请选择盘点的库位。");
}
if (stockTakeMaster.Type == CodeMaster.StockTakeType.Part)
{
IList<string> stockTakeItemList = this.genericMgr.FindAll<string>(SelectStockTakeItemStatement, stockTakeMaster.StNo);
if (stockTakeItemList == null || stockTakeItemList.Count == 0)
{
throw new BusinessException("请选择盘点的零件。");
}
}
User user = SecurityContextHolder.Get();
stockTakeMaster.Status = CodeMaster.StockTakeStatus.Submit;
stockTakeMaster.ReleaseUserId = user.Id;
stockTakeMaster.ReleaseUserName = user.FullName;
stockTakeMaster.ReleaseDate = DateTime.Now;
this.genericMgr.Update(stockTakeMaster);
}
private IList<StockTakeResult> CalStockTakeResult(StockTakeMaster stockTakeMaster, bool listShortage, bool listProfit, bool listMatch, IList<string> locationList, IList<string> binList, IList<string> itemList, DateTime? baseInventoryDate)
{
var stockTakeLocationList = this.genericMgr.FindAll<StockTakeLocation>
("from StockTakeLocation as s where StNo = ?", stockTakeMaster.StNo);
if (locationList == null || locationList.Count() == 0)
{
locationList = stockTakeLocationList.Select(p => p.Location).ToList();
}
if (stockTakeMaster.Type == CodeMaster.StockTakeType.Part && (itemList == null || itemList.Count() == 0))
{
itemList = this.genericMgr.FindAll<string>(SelectStockTakeItemStatement, stockTakeMaster.StNo);
}
var stockTakeResultList = new List<StockTakeResult>();
baseInventoryDate = baseInventoryDate.HasValue ? baseInventoryDate.Value : stockTakeMaster.BaseInventoryDate;
if (baseInventoryDate == null)
{
//默认取当天
baseInventoryDate = DateTime.Now;
}
DateTime dateTimeNow = DateTime.Now;
if (stockTakeMaster.IsScanHu)
{
#region 按条码盘点
#region 查找库存
var bins = stockTakeLocationList.Where(p => !string.IsNullOrWhiteSpace(p.Bins))
.SelectMany(p => p.Bins.Split(',')).ToList();
IList<LocationLotDetail> locationLotDetailList = null;
if (baseInventoryDate.HasValue && bins.Count == 0)
{
if (binList != null && binList.Count > 0)
{
//throw new BusinessException("不支持按库格查看条码历史库存。");
}
string selectStockTakeInvStatement = "from StockTakeInv where StNo=? ";
IList<object> selectStockTakeInvParm = new List<object> { stockTakeMaster.StNo };
selectStockTakeInvStatement += GetWhereStatement(selectStockTakeInvParm, itemList, locationList, binList);
var stockTakeInvList = this.genericMgr.FindAll<StockTakeInv>(selectStockTakeInvStatement, selectStockTakeInvParm.ToArray());
locationLotDetailList = (from inv in stockTakeInvList
where inv.QualityType == CodeMaster.QualityType.Qualified
select new LocationLotDetail
{
Location = inv.Location,
Item = inv.Item,
HuId = inv.HuId,
Bin = inv.Bin,
LotNo = inv.LotNo,
Qty = inv.Qty,
QualityType = inv.QualityType
}).ToList();
}
else
{
string selectHuLocationLotDetailStatement = "from LocationLotDetail where HuId is not null ";
IList<object> selectHuLocationLotDetailParm = new List<object>();
selectHuLocationLotDetailStatement += GetWhereStatement(selectHuLocationLotDetailParm, itemList, locationList, bins);
locationLotDetailList = this.genericMgr.FindAll<LocationLotDetail>(selectHuLocationLotDetailStatement, selectHuLocationLotDetailParm.ToArray());
}
#endregion
#region 期间库存事务
//将来改成存储过程 todo
string locationSql = string.Empty;
foreach (var location in locationList)
{
if (locationSql == string.Empty)
{
locationSql = "('" + location;
}
else
{
locationSql += "','" + location;
}
}
locationSql += "')";
//string sql = string.Format(@"select distinct(huId) from VIEW_LocTrans where CreateDate>=? and HuId is not null
// and ((LocFrom in {0} and IOType =1) or (LocTo in {1} and IOType =0)) ", locationSql, locationSql);
//var activeHuIds = this.genericMgr.FindAllWithNativeSql<string>(sql, baseInventoryDate.Value).ToArray();
string sql = string.Format(@"select distinct(huId) from VIEW_LocTrans where CreateDate>=? and HuId is not null
and LocTo in {0} and IOType =0 ", locationSql);
var inHuIds = this.genericMgr.FindAllWithNativeSql<string>(sql, baseInventoryDate.Value).ToArray();
sql = string.Format(@"select distinct(huId) from VIEW_LocTrans where CreateDate>=? and HuId is not null
and LocFrom in {0} and IOType =1 ", locationSql);
var outHuIds = this.genericMgr.FindAllWithNativeSql<string>(sql, baseInventoryDate.Value).ToArray();
//var activeHuIds = inHuIds.Where(p => !outHuIds.Contains(p)).ToArray();
var allHuIds = inHuIds.Union(outHuIds).Distinct().ToArray();
#endregion
#region 查找盘点结果
IList<object> selectStockTakeDetailParm = new List<object>();
selectStockTakeDetailParm.Add(stockTakeMaster.StNo);
string thisSelectStockTakeDetailStatement = SelectStockTakeDetailStatement + GetWhereStatement(selectStockTakeDetailParm, itemList, locationList, binList);
IList<StockTakeDetail> stockTakeDetailList = this.genericMgr.FindAll<StockTakeDetail>(thisSelectStockTakeDetailStatement, selectStockTakeDetailParm.ToArray());
//去掉已出库的
stockTakeDetailList = stockTakeDetailList.Where(p => !outHuIds.Contains(p.HuId)).ToList();
#endregion
#region 盘亏\盘赢\账实相符
#region 盘亏
if (listShortage)
{
//有出入库事务就不能算盘亏
if (baseInventoryDate.HasValue && bins.Count() == 0)
{
#region 比较历史库存，不看Bin
stockTakeResultList.AddRange((from loc in locationLotDetailList
join tak in stockTakeDetailList
on
new
{
Location = loc.Location,
Item = loc.Item,
HuId = loc.HuId
}
equals
new
{
Location = tak.Location,
Item = tak.Item,
HuId = tak.HuId
}
into gj
from result in gj.DefaultIfEmpty()
where result == null && !allHuIds.Contains(loc.HuId)
select new StockTakeResult
{
Item = loc.Item,
HuId = loc.HuId,
LotNo = loc.LotNo,
StockTakeQty = 0,
InventoryQty = loc.Qty,
DifferenceQty = 0 - loc.Qty,
Location = loc.Location,
//Bin = string.Empty,
BaseInventoryDate = baseInventoryDate.Value,
QualityType = loc.QualityType,
IsCS = loc.IsConsignment
}).ToList());
#endregion
}
else
{
#region 比较当前库存，看Bin
stockTakeResultList.AddRange((from loc in locationLotDetailList
join tak in stockTakeDetailList
on
new
{
Location = loc.Location,
Bin = loc.Bin,
Item = loc.Item,
HuId = loc.HuId
}
equals
new
{
Location = tak.Location,
Bin = tak.Bin,
Item = tak.Item,
HuId = tak.HuId
}
into gj
from result in gj.DefaultIfEmpty()
where result == null && !allHuIds.Contains(loc.HuId)
select new StockTakeResult
{
Item = loc.Item,
HuId = loc.HuId,
LotNo = loc.LotNo,
StockTakeQty = 0,
InventoryQty = loc.Qty,
DifferenceQty = 0 - loc.Qty,
Location = loc.Location,
Bin = loc.Bin,
BaseInventoryDate = dateTimeNow,
QualityType = loc.QualityType,
IsCS = loc.IsConsignment
}).ToList());
#endregion
}
}
#endregion
#region 盘盈
if (listProfit)
{
//有出入库事务就不能算盘盈
if (baseInventoryDate.HasValue && bins.Count() == 0)
{
#region 比较历史库存，不看Bin
stockTakeResultList.AddRange((from tak in stockTakeDetailList
join loc in locationLotDetailList
on
new
{
Location = tak.Location,
Item = tak.Item,
HuId = tak.HuId
}
equals
new
{
Location = loc.Location,
Item = loc.Item,
HuId = loc.HuId
}
into gj
from result in gj.DefaultIfEmpty()
where result == null && !allHuIds.Contains(tak.HuId)
select new StockTakeResult
{
Item = tak.Item,
ItemDescription = tak.ItemDescription,
Uom = tak.BaseUom,
HuId = tak.HuId,
LotNo = tak.LotNo,
StockTakeQty = tak.Qty * tak.UnitQty,
InventoryQty = 0,
DifferenceQty = tak.Qty * tak.UnitQty,
Location = tak.Location,
//Bin = string.Empty,
BaseInventoryDate = baseInventoryDate.Value,
QualityType = tak.QualityType,
IsCS = false
}).ToList());
#endregion
}
else
{
#region 比较当前库存，看Bin
stockTakeResultList.AddRange((from tak in stockTakeDetailList
join loc in locationLotDetailList
on
new
{
Location = tak.Location,
Bin = tak.Bin,
Item = tak.Item,
HuId = tak.HuId
}
equals
new
{
Location = loc.Location,
Bin = loc.Bin,
Item = loc.Item,
HuId = loc.HuId
}
into gj
from result in gj.DefaultIfEmpty()
where result == null && !allHuIds.Contains(tak.HuId)
select new StockTakeResult
{
Item = tak.Item,
ItemDescription = tak.ItemDescription,
Uom = tak.BaseUom,
HuId = tak.HuId,
LotNo = tak.LotNo,
StockTakeQty = tak.Qty * tak.UnitQty,
InventoryQty = 0,
DifferenceQty = tak.Qty * tak.UnitQty,
Location = tak.Location,
Bin = tak.Bin,
BaseInventoryDate = dateTimeNow,
QualityType = tak.QualityType,
IsCS = false
}).ToList());
#endregion
}
}
#endregion
#region 账实相符
if (listMatch)
{
if (baseInventoryDate.HasValue && bins.Count() == 0)
{
#region 比较历史库存，不看Bin
stockTakeResultList.AddRange((from loc in locationLotDetailList
join tak in stockTakeDetailList
on new
{
Location = loc.Location,
Item = loc.Item,
HuId = loc.HuId
}
equals new
{
Location = tak.Location,
Item = tak.Item,
HuId = tak.HuId
}
select new StockTakeResult
{
Item = loc.Item,
ItemDescription = tak.ItemDescription,
Uom = tak.BaseUom,
HuId = loc.HuId,
LotNo = loc.LotNo,
StockTakeQty = loc.Qty,
InventoryQty = loc.Qty,
DifferenceQty = 0,
Location = loc.Location,
//Bin = string.Empty,
BaseInventoryDate = baseInventoryDate.Value,
QualityType = loc.QualityType,
}).ToList());
#endregion
}
else
{
#region 比较当前库存，看Bin
stockTakeResultList.AddRange((from loc in locationLotDetailList
join tak in stockTakeDetailList
on new
{
Location = loc.Location,
Bin = loc.Bin,
Item = loc.Item,
HuId = loc.HuId
}
equals new
{
Location = tak.Location,
Bin = tak.Bin,
Item = tak.Item,
HuId = tak.HuId
}
select new StockTakeResult
{
Item = loc.Item,
ItemDescription = tak.ItemDescription,
Uom = tak.BaseUom,
HuId = loc.HuId,
LotNo = loc.LotNo,
StockTakeQty = loc.Qty,
InventoryQty = loc.Qty,
DifferenceQty = 0,
Location = loc.Location,
Bin = loc.Bin,
BaseInventoryDate = dateTimeNow,
QualityType = loc.QualityType,
}).ToList());
#endregion
}
stockTakeResultList.AddRange(locationLotDetailList
.Where(p => allHuIds.Contains(p.HuId) && !stockTakeDetailList.Select(q => q.HuId).Contains(p.HuId))
.Select(loc => new StockTakeResult
{
Item = loc.Item,
HuId = loc.HuId,
LotNo = loc.LotNo,
StockTakeQty = loc.Qty,
InventoryQty = loc.Qty,
DifferenceQty = 0,
Location = loc.Location,
Bin = baseInventoryDate.HasValue && bins.Count() == 0 ? null : loc.Bin,
BaseInventoryDate = dateTimeNow,
QualityType = loc.QualityType,
IsCS = loc.IsConsignment
}));
stockTakeResultList.AddRange(stockTakeDetailList
.Where(p => allHuIds.Contains(p.HuId) && !locationLotDetailList.Select(q => q.HuId).Contains(p.HuId))
.Select(tak => new StockTakeResult
{
Item = tak.Item,
HuId = tak.HuId,
LotNo = tak.LotNo,
StockTakeQty = tak.Qty * tak.UnitQty,
InventoryQty = tak.Qty * tak.UnitQty,
DifferenceQty = 0,
Location = tak.Location,
Bin = baseInventoryDate.HasValue && bins.Count() == 0 ? null : tak.Bin,
BaseInventoryDate = dateTimeNow,
QualityType = tak.QualityType,
IsCS = false
}));
}
#endregion
#endregion
if (bins.Count > 0)
{
stockTakeResultList = stockTakeResultList.Where(p => bins.Contains(p.Bin)).ToList();
}
#endregion
}
else
{
#region 按数量盘点
#region 查找盘点结果
IList<object> selectStockTakeDetailParm = new List<object>();
selectStockTakeDetailParm.Add(stockTakeMaster.StNo);
string thisSelectStockTakeDetailStatement = SelectStockTakeDetailStatement + GetWhereStatement(selectStockTakeDetailParm, itemList, locationList, binList);
IList<StockTakeDetail> stockTakeDetailList = this.genericMgr.FindAll<StockTakeDetail>(thisSelectStockTakeDetailStatement, selectStockTakeDetailParm.ToArray());
#endregion
var locationLotDetailList = new List<LocationLotDetail>();
#region 查找库存
if (baseInventoryDate.HasValue)
{
string selectStockTakeInvStatement = "from StockTakeInv where StNo=? ";
IList<object> selectStockTakeInvParm = new List<object> { stockTakeMaster.StNo };
selectStockTakeInvStatement += GetWhereStatement(selectStockTakeInvParm, itemList, locationList, binList);
var stockTakeInvList = this.genericMgr.FindAll<StockTakeInv>(selectStockTakeInvStatement, selectStockTakeInvParm.ToArray());
locationLotDetailList = (from p in stockTakeInvList
select new LocationLotDetail
{
Location = p.Location,
Item = p.Item,
Qty = p.Qty,
QualityType = p.QualityType,
}).ToList();
}
else
{
string selectLocationLotDetailStatement = "from LocationLotDetail where HuId is null";
IList<object> selectLocationLotDetailParm = new List<object>();
selectLocationLotDetailStatement += GetWhereStatement(selectLocationLotDetailParm, itemList, locationList, null);
var locationLotDetails = this.genericMgr.FindAll<LocationLotDetail>(selectLocationLotDetailStatement, selectLocationLotDetailParm.ToArray());
locationLotDetailList = (from inv in locationLotDetails
group inv by new { inv.Item, inv.Location, inv.QualityType } into g
select new LocationLotDetail
{
Location = g.Key.Location,
Item = g.Key.Item,
QualityType = g.Key.QualityType,
Qty = g.Sum(p => p.Qty)
}).ToList();
}
#endregion
#region 计算盘点差异
stockTakeResultList.AddRange(from tak in stockTakeDetailList
join inv in locationLotDetailList
on new { Location = tak.Location, Item = tak.Item, QualityType = tak.QualityType }
equals new { Location = inv.Location, Item = inv.Item, QualityType = inv.QualityType }
into gj
from result in gj.DefaultIfEmpty()
select new StockTakeResult
{
Location = tak.Location,
Item = tak.Item,
ItemDescription = tak.ItemDescription,
Uom = tak.BaseUom,
StockTakeQty = tak.Qty * tak.UnitQty,
InventoryQty = result != null ? result.Qty : 0,
DifferenceQty = tak.Qty * tak.UnitQty - (result != null ? result.Qty : 0),
BaseInventoryDate = baseInventoryDate.Value,
QualityType = tak.QualityType,
});
stockTakeResultList.AddRange(from inv in locationLotDetailList
join tak in stockTakeDetailList
on new { Location = inv.Location, Item = inv.Item, QualityType = inv.QualityType }
equals new { Location = tak.Location, Item = tak.Item, QualityType = tak.QualityType }
into gj
from result2 in gj.DefaultIfEmpty()
where result2 == null
select new StockTakeResult
{
Location = inv.Location,
Item = inv.Item,
StockTakeQty = 0,
InventoryQty = inv.Qty,
DifferenceQty = 0 - inv.Qty,
BaseInventoryDate = baseInventoryDate.Value,
QualityType = inv.QualityType,
});
#endregion
#region 根据查询条件过滤
if (!(listShortage && listProfit && listMatch))
{
if (listShortage)
{
if (listProfit)
{
stockTakeResultList = stockTakeResultList.Where(c => c.DifferenceQty != 0).ToList();
}
else if (listMatch)
{
stockTakeResultList = stockTakeResultList.Where(c => c.DifferenceQty <= 0).ToList();
}
else
{
stockTakeResultList = stockTakeResultList.Where(c => c.DifferenceQty < 0).ToList();
}
}
else if (listProfit)
{
if (listMatch)
{
stockTakeResultList = stockTakeResultList.Where(c => c.DifferenceQty >= 0).ToList();
}
else
{
stockTakeResultList = stockTakeResultList.Where(c => c.DifferenceQty > 0).ToList();
}
}
else
{
stockTakeResultList = stockTakeResultList.Where(c => c.DifferenceQty == 0).ToList();
}
}
#endregion
#endregion
}
#region 查询零件描述和基本单位
foreach (StockTakeResult stockTakeResult in stockTakeResultList.Where(s => string.IsNullOrWhiteSpace(s.Uom)))
{
stockTakeResult.ItemDescription = itemMgr.GetCacheItem(stockTakeResult.Item).Description;
stockTakeResult.Uom = itemMgr.GetCacheItem(stockTakeResult.Item).Uom;
}
#endregion
stockTakeResultList = stockTakeResultList.OrderBy(c => c.Item).ThenBy(c => c.DifferenceQty).ToList();
return stockTakeResultList;
}
public void CreateStockTakeMaster(StockTakeMaster stockTakeMaster)
{
stockTakeMaster.StNo = numberControlMgr.GetStockTakeNo(stockTakeMaster);
this.genericMgr.Create(stockTakeMaster);
}
public void BatchUpdateStockTakeItems(StockTakeMaster stockTakeMaster, IList<Item> addItems, IList<Item> deleteItems)
{
#region 检查
if (stockTakeMaster.Status != CodeMaster.StockTakeStatus.Create)
{
throw new BusinessException("状态为{1}的盘点单{0}不能添加零件。", stockTakeMaster.StNo,
this.systemMgr.GetCodeDetailDescription(com.Sconit.CodeMaster.CodeMaster.StockTakeStatus, ((int)stockTakeMaster.Status).ToString()));
}
if (stockTakeMaster.Type == CodeMaster.StockTakeType.All)
{
throw new BusinessException("盘点单{0}类型为全盘不能添加零件。", stockTakeMaster.StNo);
}
#region 判断是否有重复库位
if (addItems != null && addItems.Count > 0)
{
IList<string> itemCodes = addItems.Select(l => l.Code).ToList();
#region 查询盘点零件列表
IList<string> stockTakeItemList = this.genericMgr.FindAll<string>(SelectStockTakeItemStatement, stockTakeMaster.StNo);
#endregion
if (stockTakeItemList != null && stockTakeItemList.Count > 0)
{
((List<string>)itemCodes).AddRange(stockTakeItemList);
}
var itemCounts = from itemCode in itemCodes
group itemCode by itemCode into result
select new
{
ItemCode = result.Key,
Count = result.Count()
};
BusinessException businessException = new BusinessException();
foreach (var itemCount in itemCounts.Where(l => l.Count > 1))
{
businessException.AddMessage("不能重复添加零件{0}", itemCount.ItemCode);
}
if (businessException.HasMessage)
{
throw businessException;
}
}
#endregion
#endregion
#region 新增盘点零件
if (addItems != null && addItems.Count > 0)
{
IList<StockTakeItem> addStockTakeItemList = (from item in addItems
select new StockTakeItem
{
StNo = stockTakeMaster.StNo,
Item = item.Code,
ItemDescription = item.Description
}).ToList();
foreach (StockTakeItem addStockTakeItem in addStockTakeItemList)
{
this.genericMgr.Create(addStockTakeItem);
}
}
#endregion
#region 删除盘点零件
if (deleteItems != null && deleteItems.Count > 0)
{
string deleteStockTakeItemStatement = string.Empty;
IList<object> deleteStockTakeItemParas = new List<object>();
IList<IType> deleteStockTakeItemTypes = new List<IType>();
foreach (Item item in deleteItems)
{
if (deleteStockTakeItemStatement == string.Empty)
{
deleteStockTakeItemStatement = "from StockTakeItem where StNo = ? and Item in (?";
deleteStockTakeItemParas.Add(stockTakeMaster.StNo);
deleteStockTakeItemTypes.Add(NHibernateUtil.String);
}
else
{
deleteStockTakeItemStatement += ", ?";
}
deleteStockTakeItemParas.Add(item.Code);
deleteStockTakeItemTypes.Add(NHibernateUtil.String);
}
this.genericMgr.Delete(deleteStockTakeItemStatement, deleteStockTakeItemParas.ToArray(), deleteStockTakeItemTypes.ToArray());
}
#endregion
}
public void RecordStockTakeDetail(StockTakeMaster stockTakeMaster, IList<StockTakeDetail> stockTakeDetailList)
{
lock (RecordStockTakeDetailLock)
{
#region 校查
if (stockTakeDetailList == null || stockTakeDetailList.Count == 0)
{
throw new BusinessException("盘点明细不能为空。");
}
IList<StockTakeDetail> noneZeroStockTakeDetailList = stockTakeDetailList.Where(d => d.Qty > 0).ToList();
if (stockTakeMaster.Status != CodeMaster.StockTakeStatus.InProcess)
{
throw new BusinessException("盘点单{0}的状态为{1}，不能盘点。", stockTakeMaster.StNo,
this.systemMgr.GetCodeDetailDescription(com.Sconit.CodeMaster.CodeMaster.StockTakeStatus, ((int)stockTakeMaster.Status).ToString()));
}
//检查库位是否正确
BusinessException businessException = new BusinessException();
IList<StockTakeLocation> stockTakeLocationList = this.genericMgr.FindAll<StockTakeLocation>
("from StockTakeLocation as s where StNo = ? ", stockTakeMaster.StNo);
var stockTakeLocationCodeList = stockTakeLocationList.Select(p => p.Location).ToList();
foreach (string location in noneZeroStockTakeDetailList.Select(s => s.Location).Distinct())
{
if (!stockTakeLocationCodeList.Contains(location))
{
businessException.AddMessage("库位{0}不在待盘点的库位列表中。", location);
}
}
var bins = stockTakeLocationList.Where(p => !string.IsNullOrWhiteSpace(p.Bins))
.SelectMany(p => p.Bins.Split(',')).ToList();
if (bins.Count > 0)
{
foreach (var bin in noneZeroStockTakeDetailList.Select(s => s.Bin).Distinct())
{
if (!bins.Contains(bin))
{
businessException.AddMessage("库格{0}不在待盘点的库格列表中。", bin);
}
}
}
//检查零件是否正确
if (stockTakeMaster.Type == CodeMaster.StockTakeType.Part)
{
IList<string> stockTakeItemList = this.genericMgr.FindAll<string>(SelectStockTakeItemStatement, stockTakeMaster.StNo);
foreach (string item in noneZeroStockTakeDetailList.Select(s => s.Item).Distinct())
{
if (!stockTakeItemList.Contains(item))
{
businessException.AddMessage("零件{0}不在待盘点的零件列表中。", item);
}
}
}
#endregion
if (stockTakeMaster.IsScanHu)
{
//删除重复项
var noDuplicateStockTakeDetailList = noneZeroStockTakeDetailList
.Where(p => !string.IsNullOrWhiteSpace(p.HuId))
.GroupBy(p => p.HuId)
.Select(p =>
{
return p.First();
})
.ToList();
//按条码盘点查询条码
var oldTakedDetailList = this.genericMgr.FindAll<StockTakeDetail>
(" from StockTakeDetail where StNo = ?", stockTakeMaster.StNo) ?? new List<StockTakeDetail>();
foreach (StockTakeDetail stockTakeDetail in noDuplicateStockTakeDetailList)
{
var oldTakedDetail = oldTakedDetailList.FirstOrDefault(p => p.HuId == stockTakeDetail.HuId);
if (oldTakedDetail == null)
{
//未扫描到的
stockTakeDetail.StNo = stockTakeMaster.StNo;
#region 计算基本单位和转换率
stockTakeDetail.BaseUom = itemMgr.GetCacheItem(stockTakeDetail.Item).Uom;
if (stockTakeDetail.BaseUom != stockTakeDetail.Uom)
{
stockTakeDetail.UnitQty = this.itemMgr.ConvertItemUomQty(stockTakeDetail.Item, stockTakeDetail.Uom, 1, stockTakeDetail.BaseUom);
}
else
{
stockTakeDetail.UnitQty = 1;
}
#endregion
this.genericMgr.Create(stockTakeDetail);
}
else if (oldTakedDetail.Bin != stockTakeDetail.Bin)
{
//库格不对的
oldTakedDetail.Bin = stockTakeDetail.Bin;
this.genericMgr.Update(oldTakedDetail);
}
else
{
//已扫到的,忽略不做
}
}
this.locationDetailMgr.InventoryPut(noDuplicateStockTakeDetailList);
}
else
{
//按数量盘点查询零件号
IList<object[]> takedDetailList = this.genericMgr.FindAll<object[]>
("select distinct Item, QualityType from StockTakeDetail where StNo = ?", stockTakeMaster.StNo);
if (takedDetailList != null && takedDetailList.Count > 0)
{
var duplicatedTakeDetailList = from takedDet in takedDetailList
join stockTakeDetail in noneZeroStockTakeDetailList
on new
{
Item = (string)takedDet[0],
QualityType = (CodeMaster.QualityType)takedDet[1]
} equals new { Item = stockTakeDetail.Item, QualityType = stockTakeDetail.QualityType }
select new
{
Item = stockTakeDetail.Item,
QualityType = stockTakeDetail.QualityType,
};
if (duplicatedTakeDetailList != null && duplicatedTakeDetailList.Count() > 0)
{
foreach (var duplicatedTakeDetail in duplicatedTakeDetailList)
{
businessException.AddMessage("质量状态为{1}的零件{0}重复盘点。", duplicatedTakeDetail.Item,
this.systemMgr.GetCodeDetailDescription(com.Sconit.CodeMaster.CodeMaster.QualityType, ((int)duplicatedTakeDetail.QualityType).ToString()));
}
}
}
#region 循环更新盘点明细
foreach (StockTakeDetail stockTakeDetail in stockTakeDetailList)
{
stockTakeDetail.StNo = stockTakeMaster.StNo;
#region 计算基本单位和转换率
stockTakeDetail.BaseUom = itemMgr.GetCacheItem(stockTakeDetail.Item).Uom;
if (stockTakeDetail.BaseUom != stockTakeDetail.Uom)
{
stockTakeDetail.UnitQty = this.itemMgr.ConvertItemUomQty(stockTakeDetail.Item, stockTakeDetail.Uom, 1, stockTakeDetail.BaseUom);
}
else
{
stockTakeDetail.UnitQty = 1;
}
#endregion
this.genericMgr.Create(stockTakeDetail);
}
#endregion
}
if (businessException.HasMessage)
{
throw businessException;
}
//this.genericMgr.Update(stockTakeMaster);
}
}
public void CompleteStockTakeMaster(StockTakeMaster stockTakeMaster, DateTime? baseInventoryDate)
{
if (stockTakeMaster.Status != CodeMaster.StockTakeStatus.InProcess)
{
throw new BusinessException("盘点单{0}的状态为{1}，不能完工。", stockTakeMaster.StNo,
this.systemMgr.GetCodeDetailDescription(com.Sconit.CodeMaster.CodeMaster.StockTakeStatus, ((int)stockTakeMaster.Status).ToString()));
}
IList<string> stockTakeLocationList = this.genericMgr.FindAll<string>(SelectStockTakeLocationStatement, stockTakeMaster.StNo);
IList<StockTakeResult> resultList = CalStockTakeResult(stockTakeMaster, true, true, true, stockTakeLocationList.ToList(), null, null, baseInventoryDate);
if (resultList != null && resultList.Count > 0)
{
foreach (StockTakeResult result in resultList)
{
result.StNo = stockTakeMaster.StNo;
result.EffectiveDate = stockTakeMaster.EffectiveDate;
this.genericMgr.Create(result);
}
}
stockTakeMaster.CompleteDate = DateTime.Now;
User user = SecurityContextHolder.Get();
stockTakeMaster.CompleteUserId = user.Id;
stockTakeMaster.Status = CodeMaster.StockTakeStatus.Complete;
stockTakeMaster.CompleteUserName = user.FullName;
this.genericMgr.Update(stockTakeMaster);
TryCloseStockTakeMaster(stockTakeMaster);
}
public IList<StockTakeResultSummary> ListStockTakeResult(StockTakeMaster stockTakeMaster, bool listShortage, bool listProfit, bool listMatch, IList<string> locationList, IList<string> binList, IList<string> itemList, DateTime? BaseInventoryDate)
{
if (stockTakeMaster.Status == CodeMaster.StockTakeStatus.Create
|| stockTakeMaster.Status == CodeMaster.StockTakeStatus.Cancel
|| stockTakeMaster.Status == CodeMaster.StockTakeStatus.Submit)
{
throw new BusinessException("盘点单{0}的状态为{1}，不能显示盘点结果。", stockTakeMaster.StNo,
this.systemMgr.GetCodeDetailDescription(com.Sconit.CodeMaster.CodeMaster.StockTakeStatus, ((int)stockTakeMaster.Status).ToString()));
}
if (stockTakeMaster.Type == CodeMaster.StockTakeType.Part && (itemList == null || itemList.Count() == 0))
{
if (stockTakeMaster.StockTakeItems == null)
{
stockTakeMaster.StockTakeItems = this.genericMgr.FindAll<StockTakeItem>("from StockTakeItem where StNo = ? ", stockTakeMaster.StNo);
if (itemList == null || itemList.Count() == 0)
{
itemList = stockTakeMaster.StockTakeItems.Select(p => p.Item).Distinct().ToList();
}
}
}
if (stockTakeMaster.StockTakeLocations == null)
{
stockTakeMaster.StockTakeLocations = this.genericMgr.FindAll<StockTakeLocation>("from StockTakeLocation where StNo = ? ", stockTakeMaster.StNo);
if (locationList == null || locationList.Count() == 0)
{
locationList = stockTakeMaster.StockTakeLocations.Select(p => p.Location).Distinct().ToList();
}
}
IList<StockTakeResultSummary> stockTakeResultSummaryList = new List<StockTakeResultSummary>();
if (stockTakeMaster.Status == CodeMaster.StockTakeStatus.InProcess)
{
#region 执行中返回库存和盘点结果比较值
IList<StockTakeResult> stockTakeResultList = CalStockTakeResult(stockTakeMaster, listShortage, listProfit, listMatch, locationList, binList, itemList, BaseInventoryDate);
if (stockTakeMaster.IsScanHu)
{
stockTakeResultSummaryList = (from tak in stockTakeResultList
group tak by new
{
Item = tak.Item,
//ItemDescription = tak.ItemDescription,
Uom = tak.Uom,
Location = tak.Location,
//LotNo = tak.LotNo,
Bin = tak.Bin,
StNo = tak.StNo,
} into result
select new StockTakeResultSummary
{
StNo = result.Key.StNo,
Bin = result.Key.Bin,
Item = result.Key.Item,
ItemDescription = result.First().ItemDescription,
Uom = result.Key.Uom,
Location = result.Key.Location,
//LotNo = result.Key.LotNo,
MatchQty = result.Sum(t => t.DifferenceQty == 0 ? t.InventoryQty : 0),
ShortageQty = result.Sum(t => t.DifferenceQty < 0 ? t.InventoryQty : 0),
ProfitQty = result.Sum(t => t.DifferenceQty > 0 ? t.StockTakeQty : 0),
}).ToList();
}
else
{
stockTakeResultSummaryList = (from tak in stockTakeResultList
select new StockTakeResultSummary
{
Item = tak.Item,
ItemDescription = tak.ItemDescription,
Uom = tak.Uom,
Location = tak.Location,
QualityType = tak.QualityType,
InventoryQty = tak.InventoryQty,
StockTakeQty = tak.StockTakeQty,
DifferenceQty = tak.DifferenceQty,
}).ToList();
}
#endregion
}
else
{
#region 完成后
if (stockTakeMaster.IsScanHu)
{
#region 按条码
#region 盘亏
if (listShortage)
{
#region 查询盘亏结果
string selectShortageStatement = @"select Item, ItemDescription, QualityType, Uom, Location, Bin, LotNo, DifferenceQty as ShortageQty ,StNo,Id,IsAdjust
from StockTakeResult where StNo = ? and DifferenceQty < 0 ";
IList<object> selectShortageParas = new List<object>();
selectShortageParas.Add(stockTakeMaster.StNo);
selectShortageStatement += GetWhereStatement(selectShortageParas, itemList, locationList, binList);
IList<object[]> shorageList = this.genericMgr.FindAll<object[]>(selectShortageStatement, selectShortageParas.ToArray());
#endregion
#region 转换为StockTakeResultSummary
((List<StockTakeResultSummary>)stockTakeResultSummaryList).AddRange
((from shorage in shorageList
select new StockTakeResultSummary
{
Item = (string)shorage[0],
ItemDescription = (string)shorage[1],
QualityType = (CodeMaster.QualityType)shorage[2],
Uom = (string)shorage[3],
Location = (string)shorage[4],
Bin = (string)shorage[5],
LotNo = (string)shorage[6],
MatchQty = 0,
ShortageQty = (decimal)shorage[7],
StNo = (string)shorage[8],
Id = (int)shorage[9],
IsAdjust = (Boolean)shorage[10],
ProfitQty = 0
}).ToList());
#endregion
}
#endregion
#region 盘盈
if (listProfit)
{
#region 查询盘盈结果
string selectProfitStatement = @"select Item, ItemDescription, QualityType, Uom, Location, Bin, LotNo, DifferenceQty as ProfitQty ,StNo,Id,IsAdjust
from StockTakeResult where StNo = ? and DifferenceQty > 0 ";
IList<object> selectProfitParas = new List<object>();
selectProfitParas.Add(stockTakeMaster.StNo);
selectProfitStatement += GetWhereStatement(selectProfitParas, itemList, locationList, binList);
IList<object[]> profitList = this.genericMgr.FindAll<object[]>(selectProfitStatement, selectProfitParas.ToArray());
#endregion
#region 转换为StockTakeResultSummary
((List<StockTakeResultSummary>)stockTakeResultSummaryList).AddRange
((from profit in profitList
select new StockTakeResultSummary
{
Item = (string)profit[0],
ItemDescription = (string)profit[1],
QualityType = (CodeMaster.QualityType)profit[2],
Uom = (string)profit[3],
Location = (string)profit[4],
Bin = (string)profit[5],
LotNo = (string)profit[6],
MatchQty = 0,
ShortageQty = 0,
ProfitQty = (decimal)profit[7],
StNo = (string)profit[8],
Id = (int)profit[9],
IsAdjust = (Boolean)profit[10],
}).ToList());
#endregion
}
#endregion
#region 账实相符
if (listMatch)
{
#region 查询盘盈结果
string selectMatchStatement = @"select Item, ItemDescription, QualityType, Uom, Location, Bin, LotNo, InventoryQty as MatchQty ,StNo,Id,IsAdjust
from StockTakeResult where StNo = ? and DifferenceQty = 0 ";
IList<object> selectMatchParas = new List<object>();
selectMatchParas.Add(stockTakeMaster.StNo);
selectMatchStatement += GetWhereStatement(selectMatchParas, itemList, locationList, binList);
IList<object[]> matchList = this.genericMgr.FindAll<object[]>(selectMatchStatement, selectMatchParas.ToArray());
#endregion
#region 转换为StockTakeResultSummary
((List<StockTakeResultSummary>)stockTakeResultSummaryList).AddRange
((from match in matchList
select new StockTakeResultSummary
{
Item = (string)match[0],
ItemDescription = (string)match[1],
QualityType = (CodeMaster.QualityType)match[2],
Uom = (string)match[3],
Location = (string)match[4],
Bin = (string)match[5],
LotNo = (string)match[6],
MatchQty = (decimal)match[7],
StNo = (string)match[8],
Id = (int)match[9],
IsAdjust = (Boolean)match[10],
ShortageQty = 0,
ProfitQty = 0,
}).ToList());
#endregion
}
#endregion
#region 汇总
stockTakeResultSummaryList = (from sum in stockTakeResultSummaryList
group sum by new
{
Item = sum.Item,
ItemDescription = sum.ItemDescription,
QualityType = sum.QualityType,
Uom = sum.Uom,
Location = sum.Location,
Bin = sum.Bin,
//LotNo = sum.LotNo,
StNo = sum.StNo
} into result
select new StockTakeResultSummary
{
StNo = result.Key.StNo,
Item = result.Key.Item,
ItemDescription = result.Key.ItemDescription,
Uom = result.Key.Uom,
QualityType = result.Key.QualityType,
Location = result.Key.Location,
Bin = result.Key.Bin,
ProfitQty = result.Sum(sum => sum.ProfitQty),
ShortageQty = 0 - result.Sum(sum => sum.ShortageQty),
MatchQty = result.Sum(sum => sum.MatchQty),
}
).OrderBy(c => c.Item).ThenBy(c => c.LotNo).ToList();
#endregion
#endregion
}
else
{
#region 按数量
string selectStockTakeResultStatement = "from StockTakeResult where StNo = ?";
IList<object> selectStockTakeResultParas = new List<object>();
selectStockTakeResultParas.Add(stockTakeMaster.StNo);
if (!(listShortage && listProfit && listMatch))
{
if (listShortage)
{
if (listProfit)
{
selectStockTakeResultStatement += " DifferenceQty <> 0";
}
else if (listMatch)
{
selectStockTakeResultStatement += " DifferenceQty <= 0";
}
else
{
selectStockTakeResultStatement += " DifferenceQty < 0";
}
}
else if (listProfit)
{
if (listMatch)
{
selectStockTakeResultStatement += " DifferenceQty >= 0";
}
else
{
selectStockTakeResultStatement += " DifferenceQty > 0";
}
}
else
{
selectStockTakeResultStatement += " DifferenceQty = 0";
}
}
selectStockTakeResultStatement += GetWhereStatement(selectStockTakeResultParas, itemList, locationList, binList);
IList<StockTakeResult> stockTakeResultList = this.genericMgr.FindAll<StockTakeResult>(selectStockTakeResultStatement, selectStockTakeResultParas.ToArray());
#region 汇总
stockTakeResultSummaryList = (from rst in stockTakeResultList
select new StockTakeResultSummary
{
IsAdjust = rst.IsAdjust,
Id = rst.Id,
Item = rst.Item,
ItemDescription = rst.ItemDescription,
QualityType = rst.QualityType,
Uom = rst.Uom,
Location = rst.Location,
InventoryQty = rst.InventoryQty,
StockTakeQty = rst.StockTakeQty,
DifferenceQty = rst.DifferenceQty,
}
).OrderBy(c => c.Item).ThenBy(c => c.LotNo).ToList();
#endregion
#endregion
}
#endregion
}
return stockTakeResultSummaryList;
}
public void ManualCloseStockTakeMaster(StockTakeMaster stockTakeMaster)
{
if (stockTakeMaster.Status != CodeMaster.StockTakeStatus.Complete)
{
throw new BusinessException("盘点单{0}的状态为{1}，不能关闭。", stockTakeMaster.StNo,
this.systemMgr.GetCodeDetailDescription(com.Sconit.CodeMaster.CodeMaster.StockTakeStatus, ((int)stockTakeMaster.Status).ToString()));
}
DoCloseStockTakeMaster(stockTakeMaster);
}
public string GetStockTakeNo(StockTakeMaster stockTakeMaster)
{
SqlParameter[] parm = new SqlParameter[4];
parm[0] = new SqlParameter("@Type", SqlDbType.TinyInt);
parm[0].Value = stockTakeMaster.Type;
parm[1] = new SqlParameter("@Location", SqlDbType.VarChar, 50);
parm[1].Value = stockTakeMaster.Region;
parm[2] = new SqlParameter("@IsScanHu", SqlDbType.Bit);
parm[2].Value = stockTakeMaster.IsScanHu;
parm[3] = new SqlParameter("@STTNo", SqlDbType.VarChar, 100);
parm[3].Direction = ParameterDirection.InputOutput;
sqlDao.ExecuteStoredProcedure("USP_GetDocNo_STT", parm);
return parm[3].Value.ToString();
}
public IList<InventoryTransaction> StockTakeAdjust(StockTakeMaster stockTakeMaster, IList<StockTakeResult> stockTakeResultList, DateTime effectiveDate)
{
List<InventoryTransaction> inventoryTransactionList = new List<InventoryTransaction>();
if (stockTakeResultList != null && stockTakeResultList.Count > 0)
{
foreach (StockTakeResult stockTakeResult in stockTakeResultList)
{
if (stockTakeResult.QualityType == CodeMaster.QualityType.Inspect)
{
//待验的库存不能调整。
throw new TechnicalException("Can't adjust inspect inventory.");
}
PlanBill planBill = null;
if (stockTakeResult.IsConsigement && (!string.IsNullOrWhiteSpace(stockTakeResult.CSSupplier)))
{
planBill = this.billMgr.LoadPlanBill(stockTakeResult.Item, stockTakeResult.Location, stockTakeResult.CSSupplier, effectiveDate, false);
}
InventoryIO inventoryIO = new InventoryIO();
inventoryIO.Location = stockTakeResult.Location;
inventoryIO.Bin = stockTakeResult.Bin;
inventoryIO.Item = stockTakeResult.Item;
inventoryIO.HuId = stockTakeResult.HuId;
inventoryIO.LotNo = stockTakeResult.LotNo;
inventoryIO.Qty = stockTakeResult.DifferenceQty; //盘亏为负数，出库。盘盈为正数，入库。
inventoryIO.QualityType = stockTakeResult.QualityType;
inventoryIO.IsATP = stockTakeResult.QualityType == com.Sconit.CodeMaster.QualityType.Qualified;
inventoryIO.IsFreeze = false;
inventoryIO.IsCreatePlanBill = false;
inventoryIO.IsConsignment = planBill != null;
inventoryIO.PlanBill = planBill != null ? (int?)planBill.Id : null;
inventoryIO.ActingBill = null;
inventoryIO.TransactionType = CodeMaster.TransactionType.CYC_CNT;//
inventoryIO.OccupyType = CodeMaster.OccupyType.None;
inventoryIO.OccupyReferenceNo = null;
inventoryIO.IsVoid = false;
inventoryIO.EffectiveDate = effectiveDate;
inventoryIO.ConsignmentSupplier = planBill != null ? planBill.Party : null;
if (stockTakeResult.DifferenceQty >= 0 && planBill != null)
{
//planBill.CurrentVoidQty = stockTakeResult.DifferenceQty * stockTakeResult.UnitQty / planBill.UnitQty;
planBill.CurrentVoidQty = stockTakeResult.DifferenceQty / planBill.UnitQty; //不考虑盘点单位转换
this.billMgr.VoidPlanBill(planBill);
}
IList<InventoryTransaction> currentInventoryTransactionList = RecordInventory(inventoryIO);
RecordLocationTransaction(stockTakeMaster, stockTakeResult, effectiveDate, currentInventoryTransactionList);
inventoryTransactionList.AddRange(currentInventoryTransactionList);
}
}
return inventoryTransactionList;
}
