public ResultModel Close(UserModel user, int customId)
{
ResultModel result = new ResultModel();
try
{
using (System.Transactions.TransactionScope scope = new TransactionScope())
{
//获取报关
result = this.customsclearanceDAL.Get(user, customId);
if (result.ResultStatus != 0)
return result;
Model.CustomsClearance customsClearance = result.ReturnValue as Model.CustomsClearance;
if (customsClearance == null || customsClearance.CustomsId <= 0)
{
result.ResultStatus = -1;
result.Message = "报关不存在";
return result;
}
//报关关闭
result = this.customsclearanceDAL.Close(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.Close(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.Close(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;
}
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 Close(UserModel user, int stockOutId)
{
ResultModel result = new ResultModel();
try
{
StockOutDetailDAL stockOutDetailDAL = new StockOutDetailDAL();
StockOutApplyDAL applyDAL = new StockOutApplyDAL();
StockLogDAL stockLogDAL = new StockLogDAL();
StockDAL stockDAL = new StockDAL();
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.Close(user, resultObj);
if (result.ResultStatus != 0)
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;
}
//加载明细
result = stockOutDetailDAL.Load(user, resultObj.StockOutId);
if (result.ResultStatus != 0)
return result;
List<StockOutDetail> details = result.ReturnValue as List<StockOutDetail>;
if(details ==null)
{
result.ResultStatus = -1;
result.Message = "获取明细失败";
return result;
}
foreach (StockOutDetail detail in details)
{
//关闭明细
result = stockOutDetailDAL.Close(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.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 = stockDAL.UpdateStockStatusToPrevious(user, stock);
if (result.ResultStatus != 0)
return result;
}
}
scope.Complete();
}
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
return result;
}
return result;
}
public ResultModel Close(UserModel user, int repoId)
{
ResultModel result = new ResultModel();
try
{
using (System.Transactions.TransactionScope scope = new TransactionScope())
{
//获取回购
result = this.repoDAL.Get(user, repoId);
if (result.ResultStatus != 0)
return result;
Model.Repo repo = result.ReturnValue as Model.Repo;
if (repo == null || repo.RepoId <= 0)
{
result.ResultStatus = -1;
result.Message = "回购不存在";
return result;
}
//回购关闭
result = this.repoDAL.Close(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.Close(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.Close(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.ResultStatus = -1;
result.Message = ex.Message;
return result;
}
return result;
}
public ResultModel Close(UserModel user, int pledgeId)
{
ResultModel result = new ResultModel();
try
{
using (System.Transactions.TransactionScope scope = new TransactionScope())
{
//获取质押
result = this.pledgeDAL.Get(user, pledgeId);
if (result.ResultStatus != 0)
return result;
Model.Pledge pledge = result.ReturnValue as Model.Pledge;
if (pledge == null || pledge.PledgeId <= 0)
{
result.ResultStatus = -1;
result.Message = "质押不存在";
return result;
}
//质押关闭
result = this.pledgeDAL.Close(user, pledge);
if (result.ResultStatus != 0)
return result;
//获取所有已完成的明细
DAL.PledgeDetialDAL pledgeDetialDAL = new PledgeDetialDAL();
result = pledgeDetialDAL.Load(user, pledgeId, StatusEnum.已生效);
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;
}
DAL.StockLogDAL stockLogDAL = new StockLogDAL();
DAL.StockDAL stockDAL = new StockDAL();
foreach (Model.PledgeDetial detail in details)
{
//明细关闭
result = pledgeDetialDAL.Close(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.Close(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;
}
if (stock.PreStatus == StockStatusEnum.质押库存)
stock.PreStatus = StockStatusEnum.在库正常;
result = stockDAL.UpdateStockStatusToPrevious(user, stock);
if (result.ResultStatus != 0)
return result;
}
scope.Complete();
}
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
return result;
}
return result;
}
