public ResultModel Audit(UserModel user, NFMT.WorkFlow.Model.DataSource dataSource, bool isPass)
{
ResultModel result = new ResultModel();
try
{
DAL.StockDAL stockDAL = new StockDAL();
NFMT.WareHouse.DAL.StockNameDAL stockNameDAL = new StockNameDAL();
DAL.ContractStockInDAL contractStockInDAL = new ContractStockInDAL();
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
result = this.stockinDAL.Get(user, dataSource.RowId);
if (result.ResultStatus != 0)
return result;
Model.StockIn stockIn = result.ReturnValue as Model.StockIn;
if (stockIn == null || stockIn.StockInId <= 0)
{
result.ResultStatus = -1;
result.Message = "入库登记不存在";
return result;
}
//审核，修改数据状态
result = this.stockinDAL.Audit(user, stockIn, isPass);
if (result.ResultStatus != 0)
return result;
//审核通过
if (isPass)
{
//写入St_StockName表
result = stockNameDAL.Insert(user, new Model.StockName() { RefNo = stockIn.RefNo });
if (result.ResultStatus != 0)
return result;
int stockNameId = 0;
if (result.ReturnValue == null || !int.TryParse(result.ReturnValue.ToString(), out stockNameId) || stockNameId <= 0)
{
result.ResultStatus = -1;
result.Message = "写库存失败";
return result;
}
//写入St_Stock库存表
result = stockDAL.Insert(user, new Model.Stock()
{
StockNameId = stockNameId,
StockDate = stockIn.StockInDate,
AssetId = stockIn.AssetId,
Bundles = stockIn.Bundles,
GrossAmount = stockIn.GrossAmount,
NetAmount = stockIn.NetAmount,
ReceiptInGap = 0,
ReceiptOutGap = 0,
CurGrossAmount = stockIn.GrossAmount,
CurNetAmount = stockIn.NetAmount,
UintId = stockIn.UintId,
DeliverPlaceId = stockIn.DeliverPlaceId,
BrandId = stockIn.BrandId,
CustomsType = stockIn.CustomType,
GroupId = stockIn.GroupId,
CorpId = stockIn.CorpId,
DeptId = stockIn.DeptId,
ProducerId = stockIn.ProducerId,
PaperNo = stockIn.PaperNo,
PaperHolder = stockIn.PaperHolder,
PreStatus = StockStatusEnum.预入库存,
StockStatus = StockStatusEnum.预入库存,
CardNo = stockIn.CardNo,
Memo = string.Empty,
StockType = stockIn.StockType,
OriginPlaceId = stockIn.OriginPlaceId,
OriginPlace = stockIn.OriginPlace,
Format = stockIn.Format
});
if (result.ResultStatus != 0)
return result;
int stockId = 0;
if (result.ReturnValue == null || !int.TryParse(result.ReturnValue.ToString(), out stockId) || stockId <= 0)
{
result.ResultStatus = -1;
result.Message = "写库存失败";
return result;
}
int contractId = 0, subId = 0;
//获取合约关联
result = contractStockInDAL.GetByStockInId(user, stockIn.StockInId);
if (result.ResultStatus == 0)
{
Model.ContractStockIn contractStockIn = result.ReturnValue as Model.ContractStockIn;
if (contractStockIn != null && contractStockIn.RefId > 0)
{
contractId = contractStockIn.ContractId;
subId = contractStockIn.ContractSubId;
}
}
//创建stockLog对象
NFMT.WareHouse.Model.StockLog stockLog = new StockLog()
{
StockId = stockId,
StockNameId = stockNameId,
RefNo = stockIn.RefNo,
LogDirection = (int)LogDirectionEnum.In,
LogType = (int)LogTypeEnum.入库,
ContractId = contractId,
SubContractId = subId,
LogDate = DateTime.Now,
OpPerson = user.EmpId,
Bundles = stockIn.Bundles,
GrossAmount = stockIn.GrossAmount,
NetAmount = stockIn.NetAmount,
MUId = stockIn.UintId,
BrandId = stockIn.BrandId,
DeliverPlaceId = stockIn.DeliverPlaceId,
PaperNo = stockIn.PaperNo,
PaperHolder = stockIn.PaperHolder,
CardNo = stockIn.CardNo,
Memo = string.Empty,
LogStatus = StatusEnum.已生效,
LogSourceBase = "NFMT",
LogSource = "dbo.St_StockIn",
SourceId = stockIn.StockInId,
AssetId = stockIn.AssetId,
CorpId = stockIn.CorpId,
CustomsType = stockIn.CustomType,
DeptId = stockIn.DeptId,
ProducerId = stockIn.ProducerId,
StockType = stockIn.StockType,
OriginPlaceId = stockIn.OriginPlaceId,
OriginPlace = stockIn.OriginPlace,
Format = stockIn.Format
};
DAL.StockLogDAL stockLogDAL = new StockLogDAL();
result = stockLogDAL.Insert(user, stockLog);
if (result.ResultStatus != 0)
return result;
int stockLogId = 0;
if (result.ReturnValue == null || !int.TryParse(result.ReturnValue.ToString(), out stockLogId) || stockLogId == 0)
{
result.ResultStatus = -1;
result.Message = "流水添加失败";
return result;
}
//写入库登记库存关联表
DAL.StockInStockDAL stockInStockDAL = new StockInStockDAL();
result = stockInStockDAL.Insert(user, new Model.StockInStock()
{
StockInId = stockIn.StockInId,
StockId = stockId,
StockLogId = stockLogId,
RefStatus = StatusEnum.已生效
});
if (result.ResultStatus != 0)
return result;
}
scope.Complete();
}
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
return result;
}
return result;
}
public ResultModel CompleteCancel(UserModel user, int stockInId)
{
ResultModel result = new ResultModel();
try
{
DAL.StockDAL stockDAL = new StockDAL();
DAL.StockLogDAL stockLogDAL = new StockLogDAL();
DAL.StockInStockDAL stockInStockDAL = new StockInStockDAL();
DAL.ContractStockInDAL contractStockInDAL = new ContractStockInDAL();
using (System.Transactions.TransactionScope scope = new TransactionScope())
{
//获取入库登记
result = this.stockinDAL.Get(user, stockInId);
if (result.ResultStatus != 0)
return result;
Model.StockIn stockIn = result.ReturnValue as Model.StockIn;
if (stockIn == null || stockIn.StockInId <= 0)
{
result.ResultStatus = -1;
result.Message = "入库登记不存在";
return result;
}
//入库登记撤销完成
result = this.stockinDAL.CompleteCancel(user, stockIn);
if (result.ResultStatus != 0)
return result;
//获取合约关联
result = contractStockInDAL.GetByStockInId(user, stockIn.StockInId);
if (result.ResultStatus != 0)
return result;
Model.ContractStockIn contractStockIn = result.ReturnValue as Model.ContractStockIn;
if (contractStockIn == null || contractStockIn.RefId <= 0)
{
result.ResultStatus = -1;
result.Message = "入库登记未关联合约，不允许确认完成";
return result;
}
//完成撤销合约关联
result = contractStockInDAL.CompleteCancel(user, contractStockIn);
if (result.ResultStatus != 0)
return result;
//获取入库登记与库存流水关联
result = stockInStockDAL.GetByStockIn(user, stockIn.StockInId);
if (result.ResultStatus != 0)
return result;
Model.StockInStock stockInStock = result.ReturnValue as Model.StockInStock;
if (stockInStock == null || stockInStock.RefId <= 0)
{
result.ResultStatus = -1;
result.Message = "关联获取失败";
return result;
}
//撤销关联
result = stockInStockDAL.CompleteCancel(user, stockInStock);
if (result.ResultStatus != 0)
return result;
//获取库存流水
result = stockLogDAL.Get(user, stockInStock.StockLogId);
if (result.ResultStatus != 0)
return result;
Model.StockLog stockLog = result.ReturnValue as Model.StockLog;
if (stockLog == null || stockLog.StockLogId <= 0)
{
result.ResultStatus = -1;
result.Message = "库存流水获取失败";
return result;
}
//撤销库存流水
result = stockLogDAL.CompleteCancel(user, stockLog);
if (result.ResultStatus != 0)
return result;
//获取库存
result = stockDAL.Get(user, stockLog.StockId);
if (result.ResultStatus != 0)
return result;
Model.Stock stock = result.ReturnValue as Model.Stock;
if (stock == null || stock.StockId <= 0)
{
result.ResultStatus = -1;
result.Message = "库存获取失败";
return result;
}
//更新库存状态为预入库存
result = stockDAL.UpdateStockStatus(stock, StockStatusEnum.预入库存);
if (result.ResultStatus != 0)
return result;
scope.Complete();
}
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
return result;
}
return result;
}
public ResultModel Create(UserModel user, Model.StockIn stockIn, int subId, bool isSubmitAudit)
{
ResultModel result = new ResultModel();
try
{
using (System.Transactions.TransactionScope scope = new TransactionScope())
{
NFMT.User.Model.Corporation corporation = NFMT.User.UserProvider.Corporations.FirstOrDefault(temp => temp.CorpId == stockIn.CorpId);
if (corporation == null || corporation.CorpId <= 0)
{
result.ResultStatus = -1;
result.Message = "归属公司不存在";
return result;
}
result = this.ValidateAuth(user, stockIn);
if (result.ResultStatus != 0)
return result;
stockIn.GroupId = corporation.ParentId;
stockIn.StockInStatus = StatusEnum.已录入;
result = stockinDAL.Insert(user, stockIn);
if (result.ResultStatus != 0)
return result;
int stockInId = 0;
if (result.ReturnValue == null || !int.TryParse(result.ReturnValue.ToString(), out stockInId) || stockInId <= 0)
{
result.ResultStatus = -1;
result.Message = "入库登录失败";
return result;
}
if (subId > 0)
{
//获取子合约
NFMT.Contract.DAL.ContractSubDAL subDAL = new Contract.DAL.ContractSubDAL();
result = subDAL.Get(user, subId);
if (result.ResultStatus != 0)
return result;
Contract.Model.ContractSub sub = result.ReturnValue as Contract.Model.ContractSub;
if (sub == null || sub.SubId <= 0)
{
result.ResultStatus = -1;
result.Message = "子合约序号错误";
return result;
}
if (stockIn.GrossAmount > sub.SignAmount)
{
result.ResultStatus = -1;
result.Message = "入库重量不能大于子合约签订数量";
return result;
}
//获取当前子合约下所有大于已录状态的入库登记
result = stockinDAL.Load(user, sub.SubId, StatusEnum.已录入);
if (result.ResultStatus != 0)
return result;
List<StockIn> stockIns = result.ReturnValue as List<Model.StockIn>;
if (stockIns == null)
{
result.ResultStatus = -1;
result.Message = "获取子合约下入库登记失败";
return result;
}
decimal sumAmount = stockIns.Sum(temp => temp.GrossAmount);
//验证子合约下入库重量是否超额
if (stockIn.GrossAmount > sub.SignAmount - sumAmount)
{
result.ResultStatus = -1;
result.Message = "入库数量大于当前子合约下可入库数量";
return result;
}
NFMT.WareHouse.Model.ContractStockIn contractStockIn = new NFMT.WareHouse.Model.ContractStockIn()
{
ContractId = sub.ContractId,
ContractSubId = sub.SubId,
StockInId = stockInId,
RefStatus = StatusEnum.已生效
};
DAL.ContractStockInDAL contractStockInDAL = new ContractStockInDAL();
result = contractStockInDAL.Insert(user, contractStockIn);
if (result.ResultStatus != 0)
return result;
}
if (result.ResultStatus == 0)
{
stockIn.StockInId = stockInId;
result.ReturnValue = stockIn;
}
scope.Complete();
}
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
}
return result;
}
public ResultModel Close(UserModel user, int stockInId)
{
ResultModel result = new ResultModel();
try
{
DAL.StockDAL stockDAL = new StockDAL();
DAL.StockLogDAL stockLogDAL = new StockLogDAL();
DAL.StockInStockDAL stockInStockDAL = new StockInStockDAL();
DAL.StockExclusiveDAL stockExclusiveDAL = new StockExclusiveDAL();
DAL.ContractStockInDAL contractStockInDAL = new ContractStockInDAL();
using (System.Transactions.TransactionScope scope = new TransactionScope())
{
//获取入库登记
result = this.stockinDAL.Get(user, stockInId);
if (result.ResultStatus != 0)
return result;
Model.StockIn stockIn = result.ReturnValue as Model.StockIn;
if (stockIn == null || stockIn.StockInId <= 0)
{
result.ResultStatus = -1;
result.Message = "入库登记不存在";
return result;
}
//入库登记关闭
result = this.stockinDAL.Close(user, stockIn);
if (result.ResultStatus != 0)
return result;
//获取合约关联
result = contractStockInDAL.GetByStockInId(user, stockIn.StockInId);
if (result.ResultStatus != 0)
return result;
Model.ContractStockIn contractStockIn = result.ReturnValue as Model.ContractStockIn;
if (contractStockIn != null && contractStockIn.RefId > 0)
{
//关闭合约关联
result = contractStockInDAL.Close(user, contractStockIn);
if (result.ResultStatus != 0)
return result;
}
//获取入库登记与库存流水关联
result = stockInStockDAL.GetByStockIn(user, stockIn.StockInId);
if (result.ResultStatus != 0)
return result;
Model.StockInStock stockInStock = result.ReturnValue as Model.StockInStock;
if (stockInStock == null || stockInStock.RefId <= 0)
{
result.ResultStatus = -1;
result.Message = "关联获取失败";
return result;
}
//关闭关联
result = stockInStockDAL.Close(user, stockInStock);
if (result.ResultStatus != 0)
return result;
//获取库存流水
result = stockLogDAL.Get(user, stockInStock.StockLogId);
if (result.ResultStatus != 0)
return result;
Model.StockLog stockLog = result.ReturnValue as Model.StockLog;
if (stockLog == null || stockLog.StockLogId <= 0)
{
result.ResultStatus = -1;
result.Message = "库存流水获取失败";
return result;
}
//关闭库存流水
result = stockLogDAL.Close(user, stockLog);
if (result.ResultStatus != 0)
return result;
//获取库存
result = stockDAL.Get(user, stockLog.StockId);
if (result.ResultStatus != 0)
return result;
Model.Stock stock = result.ReturnValue as Model.Stock;
if (stock == null || stock.StockId <= 0)
{
result.ResultStatus = -1;
result.Message = "库存获取失败";
return result;
}
//库存校验是否在库正常
if (stock.StockStatus != StockStatusEnum.预入库存)
{
result.ResultStatus = -1;
result.Message = "库存已由业务关联，不允许关闭";
return result;
}
//库存流水校验是否配货
result = stockExclusiveDAL.CheckStockIsInExclusive(user, stock.StockId);
if (result.ResultStatus != 0)
return result;
//更新库存状态为作废库存
result = stockDAL.UpdateStockStatus(stock, StockStatusEnum.作废库存);
if (result.ResultStatus != 0)
return result;
scope.Complete();
}
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
return result;
}
return result;
}
public ResultModel Complete(UserModel user, int stockInId)
{
//总体业务描述
//1：验证入库登记
//2：完成入库登记
//3：完成入库登记与合约关联
//4：完成库存流水与入库登记合约关联
//5：更新库存流水状态为已完成
//6：更新库存状态为在库正常
ResultModel result = new ResultModel();
try
{
DAL.StockInStockDAL stockInStockDAL = new StockInStockDAL();
DAL.ContractStockInDAL contractStockInDAL = new ContractStockInDAL();
NFMT.WareHouse.DAL.StockDAL stockDAL = new StockDAL();
DAL.StockLogDAL stockLogDAL = new StockLogDAL();
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
result = stockinDAL.Get(user, stockInId);
if (result.ResultStatus != 0)
return result;
Model.StockIn stockIn = result.ReturnValue as Model.StockIn;
if (stockIn == null || stockIn.StockInId <= 0)
{
result.ResultStatus = -1;
result.Message = "数据不存在，无法完成";
return result;
}
//入库登记完成
result = stockinDAL.Complete(user, stockIn);
if (result.ResultStatus != 0)
return result;
//获取合约关联
result = contractStockInDAL.GetByStockInId(user, stockIn.StockInId);
if (result.ResultStatus != 0)
return result;
Model.ContractStockIn contractStockIn = result.ReturnValue as Model.ContractStockIn;
if (contractStockIn == null || contractStockIn.RefId <= 0)
{
result.ResultStatus = -1;
result.Message = "入库登记未关联合约，不允许确认完成";
return result;
}
//完成合约关联
result = contractStockInDAL.Complete(user, contractStockIn);
if (result.ResultStatus != 0)
return result;
//获取入库登记库存关联
result = stockInStockDAL.GetByStockIn(NFMT.Common.DefaultValue.SysUser, stockIn.StockInId);
if (result.ResultStatus != 0)
return result;
Model.StockInStock stockInStock = result.ReturnValue as Model.StockInStock;
if (stockInStock == null || stockInStock.RefId <= 0)
{
result.ResultStatus = -1;
result.Message = "获取入库登记与库存关联失败";
return result;
}
//完成入库登记库存关联
result = stockInStockDAL.Complete(user, stockInStock);
if (result.ResultStatus != 0)
return result;
//获取库存流水
result = stockLogDAL.Get(user, stockInStock.StockLogId);
if (result.ResultStatus != 0)
return result;
Model.StockLog stockLog = result.ReturnValue as Model.StockLog;
if (stockLog == null || stockLog.StockLogId <= 0)
{
result.ResultStatus = -1;
result.Message = "获取入库流水失败";
return result;
}
//判断库存流水是否关联合约
if (stockLog.ContractId <= 0)
{
stockLog.ContractId = contractStockIn.ContractId;
stockLog.SubContractId = contractStockIn.ContractSubId;
result = stockLogDAL.Update(user, stockLog);
if (result.ResultStatus != 0)
return result;
}
result = stockLogDAL.Complete(user, stockLog);
if (result.ResultStatus != 0)
return result;
//获取库存
result = stockDAL.Get(user, stockLog.StockId);
if (result.ResultStatus != 0)
return result;
Model.Stock stock = result.ReturnValue as Model.Stock;
if (stock == null || stock.StockId <= 0)
{
result.ResultStatus = -1;
result.Message = "库存获取失败";
return result;
}
//更新库存表
result = stockDAL.UpdateStockStatus(stock, StockStatusEnum.在库正常);
if (result.ResultStatus != 0)
return result;
scope.Complete();
}
}
catch (Exception e)
{
result.Message = e.Message;
result.ResultStatus = -1;
}
return result;
}
public ResultModel ContractInAuditStockLogOperate(UserModel user,int contractId, int subId)
{
ResultModel result = new ResultModel();
DAL.ContractStockInDAL contractStockInDAL = new ContractStockInDAL();
DAL.StockInStockDAL stockInStockDAL = new StockInStockDAL();
result = contractStockInDAL.Load(user, contractId);
if (result.ResultStatus != 0)
return result;
List<NFMT.WareHouse.Model.ContractStockIn> contractStockIns = result.ReturnValue as List<NFMT.WareHouse.Model.ContractStockIn>;
if (contractStockIns == null)
{
result.Message = "合约入库分配获取失败";
result.ResultStatus = -1;
return result;
}
foreach (NFMT.WareHouse.Model.ContractStockIn contractStcokIn in contractStockIns)
{
//获取入库登记库存关联
result = stockInStockDAL.GetByStockIn(NFMT.Common.DefaultValue.SysUser, contractStcokIn.StockInId);
if (result.ResultStatus != 0)
return result;
NFMT.WareHouse.Model.StockInStock stockInStock = result.ReturnValue as NFMT.WareHouse.Model.StockInStock;
if (stockInStock == null || stockInStock.RefId <= 0)
{
result.ResultStatus = -1;
result.Message = "获取入库登记与库存关联失败";
return result;
}
//获取库存流水
result = this.stocklogDAL.Get(user, stockInStock.StockLogId);
if (result.ResultStatus != 0)
return result;
NFMT.WareHouse.Model.StockLog stockLog = result.ReturnValue as NFMT.WareHouse.Model.StockLog;
if (stockLog == null || stockLog.StockLogId <= 0)
{
result.ResultStatus = -1;
result.Message = "获取入库流水失败";
return result;
}
//判断库存流水是否关联合约
if (stockLog.ContractId <= 0)
{
stockLog.ContractId = contractId;
stockLog.SubContractId = subId;
result = this.stocklogDAL.Update(user, stockLog);
if (result.ResultStatus != 0)
return result;
}
}
return result;
}
public ResultModel ContractInInvalidStockOperate(UserModel user, int contractId)
{
ResultModel result = new ResultModel();
ContractStockInDAL contractStockInDAL = new ContractStockInDAL();
result = contractStockInDAL.Load(user, contractId);
if (result.ResultStatus != 0)
return result;
List<NFMT.WareHouse.Model.ContractStockIn> contractStockIns = result.ReturnValue as List<NFMT.WareHouse.Model.ContractStockIn>;
if (contractStockIns == null)
{
result.Message = "合约入库分配获取失败";
result.ResultStatus = -1;
return result;
}
foreach (NFMT.WareHouse.Model.ContractStockIn contractStcokIn in contractStockIns)
{
result = contractStockInDAL.Invalid(user, contractStcokIn);
if (result.ResultStatus != 0)
return result;
}
return result;
}
public ResultModel ContractInCreateStockOperate(UserModel user, NFMT.Contract.Model.Contract contract, int subId, List<int> stockLogIds)
{
ResultModel result = new ResultModel();
int assetId = contract.AssetId;
int logDirection = (int)NFMT.WareHouse.LogDirectionEnum.In;
int customsType = (int)NFMT.WareHouse.CustomTypeEnum.关外;
if (contract.TradeBorder == (int)NFMT.Contract.TradeBorderEnum.内贸)
customsType = (int)NFMT.WareHouse.CustomTypeEnum.关内;
StockLogDAL stockLogDAL = new StockLogDAL();
StockInDAL stockInDAL = new StockInDAL();
ContractStockInDAL contractStockInDAL = new ContractStockInDAL();
StockInStockDAL stockInStockDAL = new StockInStockDAL();
foreach (int stockLogId in stockLogIds)
{
result = stockLogDAL.Get(user, stockLogId);
if (result.ResultStatus != 0)
return result;
NFMT.WareHouse.Model.StockLog stockLog = result.ReturnValue as NFMT.WareHouse.Model.StockLog;
if (stockLog == null || stockLog.StockLogId <= 0)
{
result.ResultStatus = -1;
result.Message = "库存流水不存在";
return result;
}
if (stockLog.LogStatus != StatusEnum.已生效)
{
result.ResultStatus = -1;
result.Message = "库存流水状态不正确";
return result;
}
if (assetId != stockLog.AssetId)
{
result.ResultStatus = -1;
result.Message = "选中库存存在品种不一致";
return result;
}
if (logDirection != stockLog.LogDirection)
{
result.ResultStatus = -1;
result.Message = "选中库存存在流水方向不一致";
return result;
}
if (customsType != stockLog.CustomsType)
{
result.ResultStatus = -1;
result.Message = "选中库存存在关境不一致";
return result;
}
result = stockInStockDAL.GetByStockLogId(user, stockLog.StockLogId);
if (result.ResultStatus != 0)
return result;
NFMT.WareHouse.Model.StockInStock stockInStock = result.ReturnValue as NFMT.WareHouse.Model.StockInStock;
if (stockInStock == null || stockInStock.RefId <= 0)
{
result.ResultStatus = -1;
result.Message = "库存流水与入库登记关系获取失败";
return result;
}
NFMT.WareHouse.Model.ContractStockIn contractStockIn = new NFMT.WareHouse.Model.ContractStockIn();
contractStockIn.ContractId = contract.ContractId;
contractStockIn.ContractSubId = subId;
contractStockIn.RefStatus = StatusEnum.已生效;
contractStockIn.StockInId = stockInStock.StockInId;
result = contractStockInDAL.Insert(user, contractStockIn);
if (result.ResultStatus != 0)
return result;
}
return result;
}
public ResultModel ContractInCompleteStockOperate(UserModel user, int contractId)
{
ResultModel result = new ResultModel();
StockInDAL stockInDAL = new StockInDAL();
StockLogDAL stockLogDAL = new StockLogDAL();
StockDAL stockDAL = new StockDAL();
ContractStockInDAL contractStockInDAL = new ContractStockInDAL();
StockInStockDAL stockInStockDAL = new StockInStockDAL();
result = contractStockInDAL.Load(user, contractId);
if (result.ResultStatus != 0)
return result;
List<NFMT.WareHouse.Model.ContractStockIn> contractStockIns = result.ReturnValue as List<NFMT.WareHouse.Model.ContractStockIn>;
if (contractStockIns == null)
{
result.Message = "合约入库分配获取失败";
result.ResultStatus = -1;
return result;
}
foreach (NFMT.WareHouse.Model.ContractStockIn contractStcokIn in contractStockIns)
{
//获取入库登记
result = stockInDAL.Get(user, contractStcokIn.StockInId);
if (result.ResultStatus != 0)
return result;
NFMT.WareHouse.Model.StockIn stockIn = result.ReturnValue as NFMT.WareHouse.Model.StockIn;
if (stockIn == null || stockIn.StockInId <= 0)
{
result.ResultStatus = -1;
result.Message = "数据不存在，无法完成";
return result;
}
//入库登记完成
if (stockIn.StockInStatus == StatusEnum.已生效)
{
result = stockInDAL.Complete(user, stockIn);
if (result.ResultStatus != 0)
return result;
}
//获取合约关联
result = contractStockInDAL.GetByStockInId(user, stockIn.StockInId);
if (result.ResultStatus != 0)
return result;
NFMT.WareHouse.Model.ContractStockIn contractStockIn = result.ReturnValue as NFMT.WareHouse.Model.ContractStockIn;
if (contractStockIn == null || contractStockIn.RefId <= 0)
{
result.ResultStatus = -1;
result.Message = "入库登记未关联合约，不允许确认完成";
return result;
}
//完成合约关联
if (contractStockIn.RefStatus == StatusEnum.已生效)
{
result = contractStockInDAL.Complete(user, contractStockIn);
if (result.ResultStatus != 0)
return result;
}
//获取入库登记库存关联
result = stockInStockDAL.GetByStockIn(NFMT.Common.DefaultValue.SysUser, stockIn.StockInId);
if (result.ResultStatus != 0)
return result;
NFMT.WareHouse.Model.StockInStock stockInStock = result.ReturnValue as NFMT.WareHouse.Model.StockInStock;
if (stockInStock == null || stockInStock.RefId <= 0)
{
result.ResultStatus = -1;
result.Message = "获取入库登记与库存关联失败";
return result;
}
//完成入库登记库存关联
if (stockInStock.RefStatus == StatusEnum.已生效)
{
result = stockInStockDAL.Complete(user, stockInStock);
if (result.ResultStatus != 0)
return result;
}
//获取库存流水
result = stockLogDAL.Get(user, stockInStock.StockLogId);
if (result.ResultStatus != 0)
return result;
NFMT.WareHouse.Model.StockLog stockLog = result.ReturnValue as NFMT.WareHouse.Model.StockLog;
if (stockLog == null || stockLog.StockLogId <= 0)
{
result.ResultStatus = -1;
result.Message = "获取入库流水失败";
return result;
}
//判断库存流水是否关联合约
if (stockLog.ContractId <= 0)
{
stockLog.ContractId = contractStockIn.ContractId;
stockLog.SubContractId = contractStockIn.ContractSubId;
result = stockLogDAL.Update(user, stockLog);
if (result.ResultStatus != 0)
return result;
}
if (stockLog.LogStatus == StatusEnum.已生效)
{
result = stockLogDAL.Complete(user, stockLog);
if (result.ResultStatus != 0)
return result;
}
//获取库存
result = stockDAL.Get(user, stockLog.StockId);
if (result.ResultStatus != 0)
return result;
NFMT.WareHouse.Model.Stock stock = result.ReturnValue as NFMT.WareHouse.Model.Stock;
if (stock == null || stock.StockId <= 0)
{
result.ResultStatus = -1;
result.Message = "库存获取失败";
return result;
}
//更新库存表
if (stock.StockStatus == NFMT.WareHouse.StockStatusEnum.预入库存)
{
result = stockDAL.UpdateStockStatus(stock, NFMT.WareHouse.StockStatusEnum.在库正常);
if (result.ResultStatus != 0)
return result;
}
}
return result;
}
public ResultModel ContractInCompleteCancelStockOperate(UserModel user, int contractId)
{
ResultModel result = new ResultModel();
StockDAL stockDAL = new StockDAL();
StockLogDAL stockLogDAL = new StockLogDAL();
StockInStockDAL stockInStockDAL = new StockInStockDAL();
ContractStockInDAL contractStockInDAL = new ContractStockInDAL();
StockInDAL stockInDAL = new StockInDAL();
result = contractStockInDAL.Load(user, contractId);
if (result.ResultStatus != 0)
return result;
List<NFMT.WareHouse.Model.ContractStockIn> contractStockIns = result.ReturnValue as List<NFMT.WareHouse.Model.ContractStockIn>;
if (contractStockIns == null)
{
result.Message = "合约入库分配获取失败";
result.ResultStatus = -1;
return result;
}
foreach (NFMT.WareHouse.Model.ContractStockIn contractStcokIn in contractStockIns)
{
//获取入库登记
result = stockInDAL.Get(user, contractStcokIn.StockInId);
if (result.ResultStatus != 0)
return result;
NFMT.WareHouse.Model.StockIn stockIn = result.ReturnValue as NFMT.WareHouse.Model.StockIn;
if (stockIn == null || stockIn.StockInId <= 0)
{
result.ResultStatus = -1;
result.Message = "入库登记不存在";
return result;
}
//入库登记撤销完成
result = stockInDAL.CompleteCancel(user, stockIn);
if (result.ResultStatus != 0)
return result;
//获取合约关联
result = contractStockInDAL.GetByStockInId(user, stockIn.StockInId);
if (result.ResultStatus != 0)
return result;
NFMT.WareHouse.Model.ContractStockIn contractStockIn = result.ReturnValue as NFMT.WareHouse.Model.ContractStockIn;
if (contractStockIn == null || contractStockIn.RefId <= 0)
{
result.ResultStatus = -1;
result.Message = "入库登记未关联合约，不允许确认完成";
return result;
}
//完成撤销合约关联
result = contractStockInDAL.CompleteCancel(user, contractStockIn);
if (result.ResultStatus != 0)
return result;
//获取入库登记与库存流水关联
result = stockInStockDAL.GetByStockIn(user, stockIn.StockInId);
if (result.ResultStatus != 0)
return result;
NFMT.WareHouse.Model.StockInStock stockInStock = result.ReturnValue as NFMT.WareHouse.Model.StockInStock;
if (stockInStock == null || stockInStock.RefId <= 0)
{
result.ResultStatus = -1;
result.Message = "关联获取失败";
return result;
}
//撤销关联
result = stockInStockDAL.CompleteCancel(user, stockInStock);
if (result.ResultStatus != 0)
return result;
//获取库存流水
result = stockLogDAL.Get(user, stockInStock.StockLogId);
if (result.ResultStatus != 0)
return result;
NFMT.WareHouse.Model.StockLog stockLog = result.ReturnValue as NFMT.WareHouse.Model.StockLog;
if (stockLog == null || stockLog.StockLogId <= 0)
{
result.ResultStatus = -1;
result.Message = "库存流水获取失败";
return result;
}
//撤销库存流水
result = stockLogDAL.CompleteCancel(user, stockLog);
if (result.ResultStatus != 0)
return result;
//获取库存
result = stockDAL.Get(user, stockLog.StockId);
if (result.ResultStatus != 0)
return result;
NFMT.WareHouse.Model.Stock stock = result.ReturnValue as NFMT.WareHouse.Model.Stock;
if (stock == null || stock.StockId <= 0)
{
result.ResultStatus = -1;
result.Message = "库存获取失败";
return result;
}
//更新库存状态为预入库存
result = stockDAL.UpdateStockStatus(stock, StockStatusEnum.预入库存);
if (result.ResultStatus != 0)
return result;
}
return result;
}