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 Complete(UserModel user, int customId)
{
ResultModel result = new ResultModel();
try
{
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
result = this.customsclearanceDAL.Get(user, customId);
if (result.ResultStatus != 0)
return result;
Model.CustomsClearance customsClearance = result.ReturnValue as CustomsClearance;
if (customsClearance == null)
{
result.Message = "该数据不存在，不能完成";
return result;
}
result = customsclearanceDAL.Complete(user, customsClearance);
if (result.ResultStatus != 0)
return result;
//获取所有已生效的明细
DAL.CustomsDetailDAL customsDetailDAL = new CustomsDetailDAL();
result = customsDetailDAL.Load(user, customId, StatusEnum.已生效);
if (result.ResultStatus != 0)
return result;
List<Model.CustomsDetail> details = result.ReturnValue as List<Model.CustomsDetail>;
if (details == null || !details.Any())
{
result.ResultStatus = -1;
result.Message = "获取失败";
return result;
}
DAL.StockLogDAL stockLogDAL = new StockLogDAL();
DAL.StockDAL stockDAL = new StockDAL();
foreach (Model.CustomsDetail detail in details)
{
//明细完成
result = customsDetailDAL.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;
}
stock.StockStatus = (int)stock.PreStatus == 0 ? StockStatusEnum.在库正常 : stock.PreStatus;
stock.CustomsType = NFMT.Data.DetailProvider.Details(Data.StyleEnum.CustomType)["InsideCustom"].StyleDetailId;//关内
result = stockDAL.Update(user, stock);
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 Complete(UserModel user, int repoId)
{
ResultModel result = new ResultModel();
try
{
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
result = this.repoDAL.Get(user, repoId);
if (result.ResultStatus != 0)
return result;
Model.Repo Repo = result.ReturnValue as Repo;
if (Repo == null)
{
result.Message = "该数据不存在，不能完成";
return result;
}
result = repoDAL.Complete(user, Repo);
if (result.ResultStatus != 0)
return result;
//获取所有已生效的明细
DAL.RepoDetailDAL repoDetailDAL = new RepoDetailDAL();
result = repoDetailDAL.Load(user, repoId, StatusEnum.已生效);
if (result.ResultStatus != 0)
return result;
List<Model.RepoDetail> details = result.ReturnValue as List<Model.RepoDetail>;
if (details == null || !details.Any())
{
result.ResultStatus = -1;
result.Message = "获取失败";
return result;
}
DAL.StockLogDAL stockLogDAL = new StockLogDAL();
DAL.StockDAL stockDAL = new StockDAL();
foreach (Model.RepoDetail detail in details)
{
//明细完成
result = repoDetailDAL.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.UpdateStockStatusDirect(stock, StockStatusEnum.在库正常);
if (result.ResultStatus != 0)
return result;
}
scope.Complete();
}
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
}
return result;
}
public ResultModel Complete(UserModel user, int stockOutId)
{
ResultModel result = new ResultModel();
try
{
StockDAL stockDAL = new StockDAL();
StockLogDAL stockLogDAL = new StockLogDAL();
StockNameDAL stockNameDAL = new StockNameDAL();
StockOutDetailDAL stockOutDetailDAL = new StockOutDetailDAL();
StockOutApplyDAL applyDAL = new StockOutApplyDAL();
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
//验证出库
result = stockoutDAL.Get(user, stockOutId);
if (result.ResultStatus != 0)
return result;
StockOut resultObj = result.ReturnValue as StockOut;
if (resultObj == null || resultObj.StockOutId <= 0)
{
result.ResultStatus = -1;
result.Message = "该数据不存在，不能进行执行完成操作";
return result;
}
//执行完成
result = stockoutDAL.Complete(user, resultObj);
if (result.ResultStatus != 0)
return result;
//加载明细
result = stockOutDetailDAL.Load(user, resultObj.StockOutId);
if (result.ResultStatus != 0)
return result;
List<Model.StockOutDetail> details = result.ReturnValue as List<Model.StockOutDetail>;
if (details == null)
{
result.ResultStatus = -1;
result.Message = "获取出库明细失败";
return result;
}
//加载对应出库申请
result = applyDAL.Get(user, resultObj.StockOutApplyId);
if (result.ResultStatus != 0)
return result;
StockOutApply apply = result.ReturnValue as StockOutApply;
if (apply == null || apply.StockOutApplyId <= 0)
{
result.ResultStatus = -1;
result.Message = "对应出库申请加载失败";
return result;
}
//明细执行完成
foreach(Model.StockOutDetail detail in details)
{
//出库明细完成
result = stockOutDetailDAL.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, 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;
}
//库存重量捆数减少
stock.CurGrossAmount -= detail.GrossAmount;
stock.CurNetAmount -= detail.NetAmount;
stock.Bundles -= detail.Bundles;
//库存状态修改
if (stock.StockStatus == StockStatusEnum.预售库存)
stock.StockStatus = StockStatusEnum.已售库存;
result = stockDAL.Update(user, stock);
if (result.ResultStatus != 0)
return result;
}
scope.Complete();
}
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
}
return result;
}
public ResultModel Complete(UserModel user, int pledgeId)
{
ResultModel result = new ResultModel();
try
{
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
//验证质押
result = pledgeDAL.Get(user, pledgeId);
if (result.ResultStatus != 0)
return result;
Pledge pledge = result.ReturnValue as Pledge;
if (pledge == null || pledge.PledgeId <= 0)
{
result.ResultStatus = -1;
result.Message = "该数据不存在，不能进行执行完成操作";
return result;
}
//执行完成
result = pledgeDAL.Complete(user, pledge);
if (result.ResultStatus != 0)
return result;
//加载明细
PledgeDetialDAL pledgeDetialDAL = new PledgeDetialDAL();
result = pledgeDetialDAL.Load(user, pledge.PledgeId);
if (result.ResultStatus != 0)
return result;
List<Model.PledgeDetial> details = result.ReturnValue as List<Model.PledgeDetial>;
if (details == null || !details.Any())
{
result.ResultStatus = -1;
result.Message = "获取质押明细失败";
return result;
}
//加载对应质押申请
PledgeApplyDAL pledgeApplyDAL = new PledgeApplyDAL();
result = pledgeApplyDAL.Get(user, pledge.PledgeApplyId);
if (result.ResultStatus != 0)
return result;
PledgeApply pledgeApply = result.ReturnValue as PledgeApply;
if (pledgeApply == null || pledgeApply.PledgeApplyId <= 0)
{
result.ResultStatus = -1;
result.Message = "对应质押申请加载失败";
return result;
}
//明细执行完成
//更新库存状态至质押库存
StockDAL stockDAL = new StockDAL();
StockLogDAL stockLogDAL = new StockLogDAL();
StockNameDAL stockNameDAL = new StockNameDAL();
foreach (Model.PledgeDetial detail in details)
{
//明细完成
result = pledgeDetialDAL.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.UpdateStockStatusDirect(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;
}
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;
}
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;
}
