public ResultModel StockMoveCreateHandle(UserModel user, int stockMoveApplyId, string memo)
{
ResultModel result = new ResultModel();
try
{
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
Model.StockMove stockMove = new StockMove()
{
StockMoveApplyId = stockMoveApplyId,
Mover = user.EmpId,
MoveTime = DateTime.Now,
MoveMemo = memo,
};
DAL.StockMoveDAL stockMoveDAL = new StockMoveDAL();
result = stockmoveDAL.Insert(user, stockMove);
if (result.ResultStatus != 0)
return result;
int stockMoveId = (int)result.ReturnValue;
DAL.StockMoveApplyDetailDAL stockMoveApplyDetailDAL = new StockMoveApplyDetailDAL();
result = stockMoveApplyDetailDAL.Load(user, stockMoveApplyId);
if (result.ResultStatus != 0)
return result;
List<Model.StockMoveApplyDetail> details = result.ReturnValue as List<Model.StockMoveApplyDetail>;
if (details == null || !details.Any())
{
result.ResultStatus = -1;
result.Message = "获取失败";
return result;
}
DAL.StockMoveDetailDAL stockMoveDetailDAL = new StockMoveDetailDAL();
foreach (Model.StockMoveApplyDetail stockMoveApplyDetail in details)
{
result = stockMoveDetailDAL.Insert(user, new StockMoveDetail()
{
StockMoveId = stockMoveId,
MoveDetailStatus = StatusEnum.已生效,
StockId = stockMoveApplyDetail.StockId,
PaperNo = stockMoveApplyDetail.PaperNo,
DeliverPlaceId = stockMoveApplyDetail.DeliverPlaceId
});
if (result.ResultStatus != 0)
return result;
}
scope.Complete();
}
}
catch (Exception ex)
{
result.Message = ex.Message;
}
finally
{
if (result.ResultStatus != 0)
log.ErrorFormat("{0} {1}，类型序号:{2}", user.EmpName, result.Message, result.ReturnValue);
else if (log.IsInfoEnabled)
log.InfoFormat("{0} {1}，类型序号:{2}", user.EmpName, result.Message, result.ReturnValue);
}
return result;
}
//移库完成撤销 流水操作：更新 流水状态：已生效 库存操作：更新 库存状态：预移库存
public ResultModel CompleteCancel(UserModel user, int stockMoveId)
{
ResultModel result = new ResultModel();
try
{
using (System.Transactions.TransactionScope scope = new TransactionScope())
{
result = this.stockmoveDAL.Get(user, stockMoveId);
if (result.ResultStatus != 0)
return result;
Model.StockMove stockmove = result.ReturnValue as StockMove;
if (stockmove == null)
{
result.Message = "该数据不存在，不能完成";
result.ResultStatus = -1;
return result;
}
result = stockmoveDAL.CompleteCancel(user, stockmove);
if (result.ResultStatus != 0)
return result;
//获取所有已生效的明细
DAL.StockMoveDetailDAL stockMoveDetailDAL = new StockMoveDetailDAL();
result = stockMoveDetailDAL.Load(user, stockMoveId, StatusEnum.已完成);
if (result.ResultStatus != 0)
return result;
List<Model.StockMoveDetail> details = result.ReturnValue as List<Model.StockMoveDetail>;
if (details == null || !details.Any())
{
result.ResultStatus = -1;
result.Message = "获取失败";
return result;
}
DAL.StockLogDAL stockLogDAL = new StockLogDAL();
DAL.StockDAL stockDAL = new StockDAL();
foreach (Model.StockMoveDetail detail in details)
{
//明细完成
result = stockMoveDetailDAL.CompleteCancel(user, detail);
if (result.ResultStatus != 0)
return result;
//获取移库流水
result = stockLogDAL.Get(user, detail.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, detail.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 Audit(UserModel user, NFMT.WorkFlow.Model.DataSource dataSource, bool isPass)
{
ResultModel result = new ResultModel();
try
{
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
result = this.stockmoveDAL.Get(user, dataSource.RowId);
if (result.ResultStatus != 0)
return result;
Model.StockMove stockMove = result.ReturnValue as Model.StockMove;
if (stockMove == null || stockMove.StockMoveId <= 0)
{
result.ResultStatus = -1;
result.Message = "移库不存在";
return result;
}
//审核，修改数据状态
result = this.stockmoveDAL.Audit(user, stockMove, isPass);
if (result.ResultStatus != 0)
return result;
//审核通过
if (isPass)
{
//加载已生效明细
DAL.StockMoveDetailDAL stockMoveDetailDAL = new StockMoveDetailDAL();
result = stockMoveDetailDAL.Load(user, stockMove.StockMoveId, StatusEnum.已生效);
if (result.ResultStatus != 0)
return result;
List<Model.StockMoveDetail> details = result.ReturnValue as List<Model.StockMoveDetail>;
if (details == null || !details.Any())
{
result.ResultStatus = -1;
result.Message = "获取失败";
return result;
}
DAL.StockDAL stockDAL = new StockDAL();
DAL.StockNameDAL stockNameDAL = new StockNameDAL();
DAL.StockLogDAL stockLogDAL = new StockLogDAL();
Model.Stock stock = null;
Model.StockName stockName = null;
Model.StockLog stockLog = null;
foreach(Model.StockMoveDetail detail in details)
{
//获取库存
result = stockDAL.Get(user, detail.StockId);
if (result.ResultStatus != 0)
return result;
stock = result.ReturnValue as Model.Stock;
if (stock == null)
{
result.ResultStatus = -1;
result.Message = "获取库存失败";
return result;
}
//获取业务单号
result = stockNameDAL.Get(user,stock.StockNameId);
if (result.ResultStatus != 0)
return result;
stockName = result.ReturnValue as Model.StockName;
if (stockName == null)
{
result.ResultStatus = -1;
result.Message = "获取业务单号失败";
return result;
}
//创建库存流水
stockLog = new StockLog()
{
StockId = stock.StockId,
StockNameId = stock.StockNameId,
RefNo =stockName.RefNo,
LogDirection = (int)LogDirectionEnum.In,
LogType = (int)LogTypeEnum.移库,
//ContractId =
//SubContractId =
LogDate = DateTime.Now,
OpPerson = user.EmpId,
Bundles = stock.Bundles,
GrossAmount = stock.GrossAmount,
NetAmount = stock.NetAmount,
MUId = stock.UintId,
BrandId = stock.BrandId,
DeliverPlaceId = stock.DeliverPlaceId,
PaperNo = stock.PaperNo,
PaperHolder = stock.PaperHolder,
CardNo = stock.CardNo,
Memo = stock.Memo,
LogStatus = StatusEnum.已生效,
LogSourceBase = "NFMT",
LogSource = "dbo.St_StockMove",
SourceId = stockMove.StockMoveId
};
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;
}
//将库存流水Id反向更新到明细表中
detail.StockLogId = stockLogId;
result = stockMoveDetailDAL.Update(user, detail);
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 stockMoveId)
{
ResultModel result = new ResultModel();
try
{
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
result = this.stockmoveDAL.Get(user, stockMoveId);
if (result.ResultStatus != 0)
return result;
Model.StockMove stockmove = result.ReturnValue as StockMove;
if (stockmove == null)
{
result.Message = "该数据不存在，不能完成";
return result;
}
result = stockmoveDAL.Complete(user, stockmove);
if (result.ResultStatus != 0)
return result;
//获取所有已生效的明细
DAL.StockMoveDetailDAL stockMoveDetailDAL = new StockMoveDetailDAL();
result = stockMoveDetailDAL.Load(user, stockMoveId, StatusEnum.已生效);
if (result.ResultStatus != 0)
return result;
List<Model.StockMoveDetail> details = result.ReturnValue as List<Model.StockMoveDetail>;
if (details == null || !details.Any())
{
result.ResultStatus = -1;
result.Message = "获取失败";
return result;
}
DAL.StockLogDAL stockLogDAL = new StockLogDAL();
DAL.StockDAL stockDAL = new StockDAL();
foreach (Model.StockMoveDetail detail in details)
{
//明细完成
result = stockMoveDetailDAL.Complete(user, detail);
if (result.ResultStatus != 0)
return result;
//获取移库流水
result = stockLogDAL.Get(user, detail.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.Complete(user, stockLog);
if (result.ResultStatus != 0)
return result;
//获取库存
result = stockDAL.Get(user, detail.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.UpdateStockStatusToPrevious(user, stock, StockStatusEnum.在库正常);
if (result.ResultStatus != 0)
return result;
}
scope.Complete();
}
}
catch (Exception ex)
{
result.Message = ex.Message;
}
finally
{
if (result.ResultStatus != 0)
log.ErrorFormat("{0} {1}，类型序号:{2}", user.EmpName, result.Message, result.ReturnValue);
else if (log.IsInfoEnabled)
log.InfoFormat("{0} {1}，类型序号:{2}", user.EmpName, result.Message, result.ReturnValue);
}
return result;
}
