public ResultModel CreateDirect(UserModel user, Operate.Model.Invoice invoice, BusinessInvoice invoiceBusiness, List<BusinessInvoiceDetail> details)
{
ResultModel result = new ResultModel();
ContractSubDAL subDAL = new ContractSubDAL();
result = subDAL.Get(user, invoiceBusiness.SubContractId);
if(result.ResultStatus!=0)
return result;
ContractSub sub = result.ReturnValue as ContractSub;
if (sub == null || sub.SubId <= 0)
{
result.ResultStatus = -1;
result.Message = "子合约不存在";
return result;
}
StockLogDAL stockLogDAL = new StockLogDAL();
//明细表数据：毛重、金额计算
foreach (BusinessInvoiceDetail detail in details)
{
detail.Bala = Math.Round(detail.NetAmount * detail.UnitPrice, 2, MidpointRounding.AwayFromZero);
if (sub.TradeBorder == (int)TradeBorderEnum.内贸)
{
//内贸毛重==净重
detail.IntegerAmount = detail.NetAmount;
}
else
{
//整笔开票情况下，外贸毛重等于库存流水毛重；分笔开票情况下，等于净重。
result = stockLogDAL.Get(user, detail.StockLogId);
if (result.ResultStatus != 0)
return result;
StockLog stockLog = result.ReturnValue as StockLog;
if (stockLog == null || stockLog.StockLogId <= 0)
{
result.ResultStatus = -1;
result.Message = "当前合约不存在该笔库存";
return result;
}
if (stockLog.NetAmount == detail.NetAmount)
{
detail.IntegerAmount = stockLog.GrossAmount;
}
else
{
detail.IntegerAmount = detail.NetAmount;
}
}
}
//主表数据：毛重、净重、均价、总额计算
decimal sumGrossAmount = details.Sum(temp => temp.IntegerAmount);
invoiceBusiness.IntegerAmount = sumGrossAmount;
decimal sumNetAmount = details.Sum(temp => temp.NetAmount);
if (sumNetAmount != invoiceBusiness.NetAmount)
{
result.ResultStatus = -1;
result.Message = "明细净重之和与总净重不相等";
return result;
}
decimal sumBala = details.Sum(temp => temp.Bala);
if (Math.Abs(sumBala - invoice.InvoiceBala) >= 1)
{
result.ResultStatus = -1;
result.Message = "明细金额之和与总金额不相等";
return result;
}
decimal avgPrice = Math.Round(sumBala / sumNetAmount, 4, MidpointRounding.AwayFromZero);
if (avgPrice != invoiceBusiness.UnitPrice)
{
result.ResultStatus = -1;
result.Message = "计算均价错误";
return result;
}
//验证是否已开临票
//result = this.businessinvoiceDAL.LoadBySubId(user, invoiceBusiness.SubContractId, InvoiceTypeEnum.ProvisionalInvoice);
//if (result.ResultStatus != 0)
// return result;
//List<Model.BusinessInvoice> proInvoices = result.ReturnValue as List<Model.BusinessInvoice>;
//if (proInvoices == null)
//{
// result.ResultStatus = -1;
// result.Message = "验证是否拥有临票失败";
// return result;
//}
//if (proInvoices.Count > 0)
//{
// result.ResultStatus = -1;
// result.Message = "当前合约已拥有临票，直接终票失败";
// return result;
//}
result = this.CreateBusinessInvoice(user, invoice, invoiceBusiness, details, InvoiceTypeEnum.DirectFinalInvoice);
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 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 CreateStockReceipt(UserModel user, NFMT.WareHouse.Model.StockReceipt stockReceipt, List<NFMT.WareHouse.Model.StockReceiptDetail> details, List<NFMT.WareHouse.Model.StockReceiptDetail> saleDetails, bool isAudit)
{
ResultModel result = new ResultModel();
try
{
NFMT.Contract.DAL.ContractSubDAL subDAL = new Contract.DAL.ContractSubDAL();
NFMT.Contract.DAL.ContractDAL contractDAL = new Contract.DAL.ContractDAL();
NFMT.WareHouse.DAL.StockDAL stockDAL = new StockDAL();
NFMT.WareHouse.DAL.StockLogDAL stockLogDAL = new StockLogDAL();
DAL.StockReceiptDAL receiptDAL = new StockReceiptDAL();
DAL.StockReceiptDetailDAL detailDAL = new StockReceiptDetailDAL();
using (System.Transactions.TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
//验证合约
result = subDAL.Get(user, stockReceipt.ContractSubId);
if (result.ResultStatus != 0)
return result;
NFMT.Contract.Model.ContractSub sub = result.ReturnValue as NFMT.Contract.Model.ContractSub;
if (sub.SubId <= 0)
{
result.ResultStatus = -1;
result.Message = "子合约不存在";
return result;
}
result = contractDAL.Get(user, sub.ContractId);
if (result.ResultStatus != 0)
return result;
NFMT.Contract.Model.Contract contract = result.ReturnValue as NFMT.Contract.Model.Contract;
if (contract == null || contract.ContractId <= 0)
{
result.ResultStatus = -1;
result.Message = "合约不存在";
return result;
}
decimal sumNetAmount = 0;
decimal sumReceiptAmount = 0;
decimal sumMissAmount = 0;
decimal missRate = 0;
//明细验证
foreach (NFMT.WareHouse.Model.StockReceiptDetail detail in details)
{
if (detail.ReceiptAmount > 0)
{
//验证库存
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 = 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;
}
if (stockLog.StockId != stock.StockId)
{
result.ResultStatus = -1;
result.Message = "库存与库存流水不匹配";
return result;
}
if (stockLog.SubContractId != stockReceipt.ContractSubId)
{
result.ResultStatus = -1;
result.Message = "库存流水与合约不匹配";
return result;
}
detail.ContractId = sub.ContractId;
detail.ContractSubId = sub.SubId;
detail.DetailStatus = StatusEnum.已生效;
detail.PreNetAmount = stock.NetAmount;
detail.QtyMiss = detail.ReceiptAmount - stock.NetAmount;
detail.QtyRate = (detail.ReceiptAmount / stock.NetAmount - 1) / 100;
sumNetAmount += stock.NetAmount;
sumReceiptAmount += detail.ReceiptAmount;
}
}
sumMissAmount = sumReceiptAmount - sumNetAmount;
missRate = (sumReceiptAmount / sumNetAmount - 1) / 100;
//赋值StockReceipt
stockReceipt.ContractId = sub.ContractId;
stockReceipt.ContractSubId = sub.SubId;
stockReceipt.PreNetAmount = sumNetAmount;
stockReceipt.QtyMiss = sumMissAmount;
stockReceipt.QtyRate = missRate;
stockReceipt.ReceiptAmount = sumReceiptAmount;
stockReceipt.Receipter = user.EmpId;
stockReceipt.ReceiptDate = DateTime.Now;
if (contract.TradeDirection == (int)NFMT.Contract.TradeDirectionEnum.Buy)
stockReceipt.ReceiptType = (int)WareHouse.ReceiptTypeEnum.StockInReceipt;
else
stockReceipt.ReceiptType = (int)WareHouse.ReceiptTypeEnum.StockOutReceipt;
stockReceipt.UnitId = sub.UnitId;
//新增StockReceipt
result = stockreceiptDAL.Insert(user, stockReceipt);
if (result.ResultStatus != 0)
return result;
int receiptId = 0;
if (result.ReturnValue == null || !int.TryParse(result.ReturnValue.ToString(), out receiptId))
{
result.ResultStatus = -1;
result.Message = "新增库存回执失败";
return result;
}
//新增明细
foreach (NFMT.WareHouse.Model.StockReceiptDetail detail in details)
{
detail.ReceiptId = receiptId;
result = detailDAL.Insert(user, detail);
if (result.ResultStatus != 0)
return result;
}
stockReceipt.ReceiptId = receiptId;
string resultStr = Newtonsoft.Json.JsonConvert.SerializeObject(stockReceipt);
//if(isAudit)
//{
// stockReceipt.ReceiptId = receiptId;
// NFMT.WorkFlow.AutoSubmit submit = new NFMT.WorkFlow.AutoSubmit();
// result = submit.Submit(user, stockReceipt, new TaskProvider.StockReceiptTaskProvider(), NFMT.WorkFlow.MasterEnum.库存净重回执审核);
// if (result.ResultStatus != 0)
// return result;
//}
#region 销售合约库存回执
if (saleDetails != null && saleDetails.Any())
{
foreach (int subId in saleDetails.Select(a => a.ContractSubId).Distinct())
{
//验证合约
result = subDAL.Get(user, subId);
if (result.ResultStatus != 0)
return result;
NFMT.Contract.Model.ContractSub saleSub = result.ReturnValue as NFMT.Contract.Model.ContractSub;
if (saleSub.SubId <= 0)
{
result.ResultStatus = -1;
result.Message = "子合约不存在";
return result;
}
sumNetAmount = 0;
sumReceiptAmount = 0;
sumMissAmount = 0;
missRate = 0;
//明细验证
foreach (NFMT.WareHouse.Model.StockReceiptDetail detail in saleDetails.Where(a => a.ContractSubId == subId))
{
if (detail.ReceiptAmount > 0)
{
//验证库存
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 = 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;
}
if (stockLog.StockId != stock.StockId)
{
result.ResultStatus = -1;
result.Message = "库存与库存流水不匹配";
return result;
}
if (stockLog.SubContractId != subId)
{
result.ResultStatus = -1;
result.Message = "库存流水与合约不匹配";
return result;
}
detail.ContractId = saleSub.ContractId;
detail.ContractSubId = saleSub.SubId;
detail.DetailStatus = StatusEnum.已生效;
detail.PreNetAmount = stock.NetAmount;
detail.QtyMiss = detail.ReceiptAmount - stock.NetAmount;
detail.QtyRate = (detail.ReceiptAmount / stock.NetAmount - 1) / 100;
sumNetAmount += stock.NetAmount;
sumReceiptAmount += detail.ReceiptAmount;
}
}
sumMissAmount = sumReceiptAmount - sumNetAmount;
missRate = (sumReceiptAmount / sumNetAmount - 1) / 100;
//赋值StockReceipt
stockReceipt.ContractId = saleSub.ContractId;
stockReceipt.ContractSubId = saleSub.SubId;
stockReceipt.PreNetAmount = sumNetAmount;
stockReceipt.ReceiptAmount = sumReceiptAmount;
stockReceipt.UnitId = saleSub.UnitId;
stockReceipt.QtyMiss = sumMissAmount;
stockReceipt.QtyRate = missRate;
stockReceipt.Receipter = user.EmpId;
stockReceipt.ReceiptDate = DateTime.Now;
if (saleSub.TradeDirection == (int)NFMT.Contract.TradeDirectionEnum.Buy)
stockReceipt.ReceiptType = (int)WareHouse.ReceiptTypeEnum.StockInReceipt;
else
stockReceipt.ReceiptType = (int)WareHouse.ReceiptTypeEnum.StockOutReceipt;
//新增StockReceipt
result = stockreceiptDAL.Insert(user, stockReceipt);
if (result.ResultStatus != 0)
return result;
receiptId = 0;
if (result.ReturnValue == null || !int.TryParse(result.ReturnValue.ToString(), out receiptId))
{
result.ResultStatus = -1;
result.Message = "新增库存回执失败";
return result;
}
//新增明细
foreach (NFMT.WareHouse.Model.StockReceiptDetail detail in saleDetails.Where(a => a.ContractSubId == subId))
{
detail.ReceiptId = receiptId;
result = detailDAL.Insert(user, detail);
if (result.ResultStatus != 0)
return result;
}
}
//if (isAudit)
//{
// stockReceipt.ReceiptId = receiptId;
// NFMT.WorkFlow.AutoSubmit submit = new NFMT.WorkFlow.AutoSubmit();
// result = submit.Submit(user, stockReceipt, new TaskProvider.StockReceiptTaskProvider(), NFMT.WorkFlow.MasterEnum.库存净重回执审核);
// if (result.ResultStatus != 0)
// return result;
//}
}
#endregion
stockReceipt.ReceiptId = receiptId;
if (result.ResultStatus == 0)
{
if (saleDetails != null && saleDetails.Any())
result.ReturnValue = stockReceipt;
else
result.ReturnValue = null;
result.Message = resultStr;
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 CompleteCancel(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 = "该数据不存在，不能完成";
result.ResultStatus = -1;
return result;
}
result = repoDAL.CompleteCancel(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.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.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 Update(UserModel user, NFMT.WareHouse.Model.StockReceipt stockReceipt, List<NFMT.WareHouse.Model.StockReceiptDetail> details)
{
ResultModel result = new ResultModel();
try
{
NFMT.Contract.DAL.ContractSubDAL subDAL = new Contract.DAL.ContractSubDAL();
NFMT.Contract.DAL.ContractDAL contractDAL = new Contract.DAL.ContractDAL();
NFMT.WareHouse.DAL.StockDAL stockDAL = new StockDAL();
DAL.StockLogDAL stockLogDAL = new StockLogDAL();
DAL.StockReceiptDAL receiptDAL = new StockReceiptDAL();
DAL.StockReceiptDetailDAL detailDAL = new StockReceiptDetailDAL();
using (System.Transactions.TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
//验证仓库回执
result = receiptDAL.Get(user, stockReceipt.ReceiptId);
if (result.ResultStatus != 0)
return result;
Model.StockReceipt resultReceipt = result.ReturnValue as Model.StockReceipt;
if (resultReceipt == null || resultReceipt.ReceiptId <= 0)
{
result.ResultStatus = -1;
result.Message = "仓库回执不存在";
return result;
}
//获取仓库回执明细
result = detailDAL.Load(user, resultReceipt.ReceiptId);
if (result.ResultStatus != 0)
return result;
List<Model.StockReceiptDetail> resultDetails = result.ReturnValue as List<Model.StockReceiptDetail>;
if (resultDetails == null)
{
result.ResultStatus = -1;
result.Message = "仓库回执明细获取失败";
return result;
}
//作废现有仓库回执明细
foreach (Model.StockReceiptDetail d in resultDetails)
{
if (d.DetailStatus == StatusEnum.已生效)
d.DetailStatus = StatusEnum.已录入;
result = detailDAL.Invalid(user, d);
if (result.ResultStatus != 0)
return result;
}
//验证合约
result = subDAL.Get(user, resultReceipt.ContractSubId);
if (result.ResultStatus != 0)
return result;
NFMT.Contract.Model.ContractSub sub = result.ReturnValue as NFMT.Contract.Model.ContractSub;
if (sub.SubId <= 0)
{
result.ResultStatus = -1;
result.Message = "子合约不存在";
return result;
}
result = contractDAL.Get(user, sub.ContractId);
if (result.ResultStatus != 0)
return result;
NFMT.Contract.Model.Contract contract = result.ReturnValue as NFMT.Contract.Model.Contract;
if (contract == null || contract.ContractId <= 0)
{
result.ResultStatus = -1;
result.Message = "合约不存在";
return result;
}
decimal sumNetAmount = 0;
decimal sumReceiptAmount = 0;
decimal sumMissAmount = 0;
decimal missRate = 0;
//明细验证
foreach (NFMT.WareHouse.Model.StockReceiptDetail detail in details)
{
//验证库存
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 = 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;
}
if (stockLog.StockId != stock.StockId)
{
result.ResultStatus = -1;
result.Message = "库存与库存流水不匹配";
return result;
}
if (stockLog.SubContractId != stockReceipt.ContractSubId)
{
result.ResultStatus = -1;
result.Message = "库存流水与合约不匹配";
return result;
}
detail.ReceiptId = resultReceipt.ReceiptId;
detail.ContractId = sub.ContractId;
detail.ContractSubId = sub.SubId;
detail.DetailStatus = StatusEnum.已生效;
detail.PreNetAmount = stock.NetAmount;
detail.QtyMiss = detail.ReceiptAmount - stock.NetAmount;
detail.QtyRate = (detail.ReceiptAmount / stock.NetAmount - 1) / 100;
sumNetAmount += stock.NetAmount;
sumReceiptAmount += detail.ReceiptAmount;
//新增仓库回执明细
result = detailDAL.Insert(user, detail);
if (result.ResultStatus != 0)
return result;
}
sumMissAmount = sumReceiptAmount - sumNetAmount;
missRate = (sumReceiptAmount / sumNetAmount - 1) / 100;
//赋值StockReceipt
resultReceipt.PreNetAmount = sumReceiptAmount;
resultReceipt.QtyMiss = sumMissAmount;
resultReceipt.QtyRate = missRate;
resultReceipt.ReceiptAmount = sumReceiptAmount;
resultReceipt.Receipter = user.EmpId;
resultReceipt.Memo = stockReceipt.Memo;
resultReceipt.ReceiptDate = stockReceipt.ReceiptDate;
if (contract.TradeDirection == (int)NFMT.Contract.TradeDirectionEnum.Buy)
resultReceipt.ReceiptType = (int)WareHouse.ReceiptTypeEnum.StockInReceipt;
else
resultReceipt.ReceiptType = (int)WareHouse.ReceiptTypeEnum.StockOutReceipt;
resultReceipt.UnitId = sub.UnitId;
//修改StockReceipt
result = stockreceiptDAL.Update(user, resultReceipt);
if (result.ResultStatus != 0)
return result;
scope.Complete();
}
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
}
return result;
}
public ResultModel Audit(UserModel user, NFMT.WorkFlow.Model.DataSource dataSource, bool isPass)
{
ResultModel result = new ResultModel();
try
{
DAL.StockLogDAL stockLogDAL = new StockLogDAL();
DAL.StockInDAL stockInDAL = new StockInDAL();
DAL.StockInStockDAL stockInStockDAL = new StockInStockDAL();
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
result = this.contractstockin_DAL.Get(NFMT.Common.DefaultValue.SysUser, dataSource.RowId);
if (result.ResultStatus != 0)
return result;
Model.ContractStockIn stockInContract = result.ReturnValue as Model.ContractStockIn;
if (stockInContract == null || stockInContract.StockInId <= 0)
{
result.ResultStatus = -1;
result.Message = "入库登记合约关联不存在";
return result;
}
//审核，修改数据状态
result = this.contractstockin_DAL.Audit(user, stockInContract, isPass);
if (result.ResultStatus != 0)
return result;
//审核通过
if (isPass)
{
//获取入库登记
result = stockInDAL.Get(user, stockInContract.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 = 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 = 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;
}
//更新流水合约关联
stockLog.SubContractId = stockInContract.ContractSubId;
stockLog.ContractId = stockInContract.ContractId;
result = stockLogDAL.Update(user, stockLog);
if (result.ResultStatus != 0)
return result;
}
scope.Complete();
}
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
return result;
}
return result;
}
public ResultModel PayApplyStockCreate(UserModel user, PayApply payApply, List<StockPayApply> stockPayApplies, string memo, int deptId, int corpId)
{
ResultModel result = new ResultModel();
try
{
StockPayApplyDAL stockPayApplyDAL = new StockPayApplyDAL();
ApplyDAL applyDAL = new ApplyDAL();
PayApplyDAL payApplyDAL = new PayApplyDAL();
ContractPayApplyDAL contractPayApplyDAL = new ContractPayApplyDAL();
StockLogDAL stockLogDAL = new StockLogDAL();
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
//验证可申请金额
//NFMT.Data.Model.FuturesPrice futuresPrice = NFMT.Data.BasicDataProvider.FuturesPrices[0];
//验证库存流水是否在同一子合约中
int subId = 0;
int contractId = 0;
foreach (StockPayApply stockPayApply in stockPayApplies)
{
result = stockLogDAL.Get(user, stockPayApply.StockLogId);
if (result.ResultStatus != 0)
return result;
StockLog stockLog = result.ReturnValue as StockLog;
if (stockLog == null || stockLog.StockLogId <= 0)
{
result.ResultStatus = -1;
result.Message = "库存流水不存在";
return result;
}
if (subId == 0)
{
subId = stockLog.SubContractId;
contractId = stockLog.ContractId;
}
if (stockLog.SubContractId != subId)
{
result.ResultStatus = -1;
result.Message = "不能同时申请不同子合约中的库存付款";
return result;
}
}
//新增申请主表
Department dept = UserProvider.Departments.FirstOrDefault(temp => temp.DeptId == deptId);
if (dept == null || dept.DeptId < 0)
{
result.ResultStatus = -1;
result.Message = "申请部门不存在";
return result;
}
int applyId = 0;
Apply apply = new Apply();
apply.ApplyDept = dept.DeptId;
apply.ApplyCorp = corpId;
apply.ApplyDesc = memo;
apply.ApplyTime = DateTime.Now;
apply.ApplyType = ApplyType.付款申请;
apply.EmpId = user.EmpId;
result = applyDAL.Insert(user, apply);
if (result.ResultStatus != 0)
return result;
if (result.ReturnValue == null || !int.TryParse(result.ReturnValue.ToString(), out applyId))
{
result.ResultStatus = -1;
result.Message = "申请主表新增失败";
return result;
}
decimal sumApplyBala = stockPayApplies.Sum(temp => temp.ApplyBala);
//新增付款申请表
payApply.ApplyId = applyId;
payApply.PayApplySource = (int)FundsStyleEnum.StockPayApply;
payApply.ApplyBala = sumApplyBala;
result = payapplyDAL.Insert(user, payApply);
if (result.ResultStatus != 0)
return result;
int payApplyId = 0;
if (result.ReturnValue == null || !int.TryParse(result.ReturnValue.ToString(), out payApplyId))
{
result.ResultStatus = -1;
result.Message = "付款申请新增失败";
return result;
}
//新增合约付款申请关联表
ContractPayApply payApplyContract = new ContractPayApply();
payApplyContract.ApplyBala = sumApplyBala;
payApplyContract.ContractId = contractId;
payApplyContract.ContractSubId = subId;
payApplyContract.PayApplyId = payApplyId;
result = contractPayApplyDAL.Insert(user, payApplyContract);
if (result.ResultStatus != 0)
return result;
int contractRefId = 0;
if (result.ReturnValue == null || !int.TryParse(result.ReturnValue.ToString(), out contractRefId) || contractRefId <= 0)
{
result.ResultStatus = -1;
result.Message = "新增付款申请失败";
return result;
}
//新增dbo.Fun_StockPayApply_Ref库存付款申请
foreach (StockPayApply stockPayApply in stockPayApplies)
{
stockPayApply.ContractId = contractId;
stockPayApply.ContractRefId = contractRefId;
stockPayApply.SubId = subId;
stockPayApply.PayApplyId = payApplyId;
stockPayApply.RefStatus = StatusEnum.已生效;
result = stockPayApplyDAL.Insert(user, stockPayApply);
if (result.ResultStatus != 0)
return result;
}
scope.Complete();
}
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
}
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 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 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;
}
public ResultModel CreateReplaceFinal(UserModel user, Operate.Model.Invoice invoice, BusinessInvoice invoiceBusiness, List<BusinessInvoiceDetail> details)
{
ResultModel result = new ResultModel();
StockLogDAL stockLogDAL = new StockLogDAL();
foreach (BusinessInvoiceDetail detail in details)
{
result = stockLogDAL.Get(user, detail.StockLogId);
if (result.ResultStatus != 0)
return result;
StockLog stockLog = result.ReturnValue as StockLog;
if (stockLog == null || stockLog.StockLogId <= 0)
{
result.ResultStatus = -1;
result.Message = "当前合约不存在该笔库存";
return result;
}
detail.IntegerAmount = stockLog.GrossAmount;
}
decimal sumNetAmount = details.Sum(temp => temp.NetAmount);
if (sumNetAmount != invoiceBusiness.NetAmount)
{
result.ResultStatus = -1;
result.Message = "明细净重之和与总净重不相等";
return result;
}
decimal sumBala = details.Sum(temp => temp.Bala);
if (sumBala != invoice.InvoiceBala)
{
result.ResultStatus = -1;
result.Message = "明细金额之和与总金额不相等";
return result;
}
decimal sumUnitBala = Math.Round(details.Sum(temp => temp.UnitPrice * temp.NetAmount),2,MidpointRounding.AwayFromZero);
decimal avgPrice = Math.Round(sumUnitBala / sumNetAmount, 4, MidpointRounding.AwayFromZero);
invoiceBusiness.UnitPrice = avgPrice;
invoiceBusiness.IntegerAmount = details.Sum(temp => temp.IntegerAmount);
result = this.CreateBusinessInvoice(user, invoice, invoiceBusiness, details, InvoiceTypeEnum.ReplaceFinalInvoice);
return result;
}
public ResultModel CreateProvisional(UserModel user, Operate.Model.Invoice invoice, BusinessInvoice invoiceBusiness, List<BusinessInvoiceDetail> details)
{
ResultModel result = new ResultModel();
StockLogDAL stockLogDAL = new StockLogDAL();
foreach (BusinessInvoiceDetail detail in details)
{
detail.UnitPrice = invoiceBusiness.UnitPrice;
result = stockLogDAL.Get(user, detail.StockLogId);
if (result.ResultStatus != 0)
return result;
StockLog stockLog = result.ReturnValue as StockLog;
if (stockLog == null || stockLog.StockLogId <= 0)
{
result.ResultStatus = -1;
result.Message = "当前合约不存在该笔库存";
return result;
}
detail.IntegerAmount = stockLog.GrossAmount;
}
invoiceBusiness.IntegerAmount = details.Sum(temp => temp.IntegerAmount);
//验证是否已开直接终票
result = this.businessinvoiceDAL.LoadBySubId(user, invoiceBusiness.SubContractId, InvoiceTypeEnum.DirectFinalInvoice);
if (result.ResultStatus != 0)
return result;
List<BusinessInvoice> dirInvoices = result.ReturnValue as List<BusinessInvoice>;
if (dirInvoices == null)
{
result.ResultStatus = -1;
result.Message = "验证是否拥有直接终票失败";
return result;
}
if (dirInvoices.Count > 0)
{
result.ResultStatus = -1;
result.Message = "当前合约已拥有直接终票，临票失败";
return result;
}
result = this.CreateBusinessInvoice(user, invoice, invoiceBusiness, details, InvoiceTypeEnum.ProvisionalInvoice);
return result;
}
public ResultModel CompleteCancel(UserModel user, int stockOutId)
{
ResultModel result = new ResultModel();
try
{
DAL.StockLogDAL stockLogDAL = new StockLogDAL();
DAL.StockDAL stockDAL = new StockDAL();
DAL.StockNameDAL stockNameDAL = new StockNameDAL();
DAL.StockOutDAL stockOutDAL = new StockOutDAL();
DAL.StockOutDetailDAL stockOutDetailDAL = new StockOutDetailDAL();
DAL.StockOutApplyDAL outApplyDAL = new StockOutApplyDAL();
Operate.DAL.ApplyDAL applyDAL = new Operate.DAL.ApplyDAL();
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
//验证出库
result = stockoutDAL.Get(user, stockOutId);
if (result.ResultStatus != 0)
return result;
StockOut stockOut = result.ReturnValue as StockOut;
if (stockOut == null || stockOut.StockOutId <= 0)
{
result.ResultStatus = -1;
result.Message = "该数据不存在，不能进行执行完成操作";
return result;
}
//撤销出库
result = this.stockoutDAL.CompleteCancel(user, stockOut);
if (result.ResultStatus != 0)
return result;
//验证出库申请
result = outApplyDAL.Get(user, stockOut.StockOutApplyId);
if (result.ResultStatus != 0)
return result;
Model.StockOutApply outApply = result.ReturnValue as Model.StockOutApply;
if (outApply == null || outApply.StockOutApplyId <= 0)
{
result.ResultStatus = -1;
result.Message = "出库申请不存在";
return result;
}
//验证主申请
result = applyDAL.Get(user, outApply.ApplyId);
if (result.ResultStatus != 0)
return result;
Operate.Model.Apply apply = result.ReturnValue as Operate.Model.Apply;
if (apply == null || apply.ApplyId <= 0)
{
result.ResultStatus = -1;
result.Message = "主申请不存在";
return result;
}
//判断主申请状态是否为已生效，
if (apply.ApplyStatus != StatusEnum.已生效)
{
result.ResultStatus = -1;
result.Message = "申请状态只有在已生效下才能进行执行完成撤销";
return result;
}
//获取已完成出库明细
result = stockOutDetailDAL.Load(user, stockOut.StockOutId, Common.StatusEnum.已完成);
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;
}
//将所有已完成出库明细更新至已生效
foreach (Model.StockOutDetail detail in details)
{
result = stockOutDetailDAL.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,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 PayApplyStockUpdate(UserModel user, PayApply payApply, List<StockPayApply> stockPayApplies, string memo, int deptId, int corpId)
{
ResultModel result = new ResultModel();
try
{
StockPayApplyDAL stockPayApplyDAL = new StockPayApplyDAL();
ContractPayApplyDAL contractPayApplyDAL = new ContractPayApplyDAL();
ApplyDAL applyDAL = new ApplyDAL();
PayApplyDAL payApplyDAL = new PayApplyDAL();
StockLogDAL stockLogDAL = new StockLogDAL();
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
//验证可申请金额
//NFMT.Data.Model.FuturesPrice futuresPrice = NFMT.Data.BasicDataProvider.FuturesPrices[0];
//获取付款申请
result = payapplyDAL.Get(user, payApply.PayApplyId);
if (result.ResultStatus != 0)
return result;
PayApply resultObj = result.ReturnValue as PayApply;
if (resultObj == null || resultObj.PayApplyId <= 0)
{
result.ResultStatus = -1;
result.Message = "付款申请不存在";
return result;
}
//获取申请主表
result = applyDAL.Get(user, resultObj.ApplyId);
if (result.ResultStatus != 0)
return result;
Apply apply = result.ReturnValue as Apply;
if (apply == null || apply.ApplyId <= 0)
{
result.ResultStatus = -1;
result.Message = "申请主表获取失败";
return result;
}
//获取库存明细列表
result = stockPayApplyDAL.Load(user, payApply.PayApplyId);
if (result.ResultStatus != 0)
return result;
List<StockPayApply> readyStockPayApplies = result.ReturnValue as List<StockPayApply>;
if (readyStockPayApplies == null)
{
result.ResultStatus = -1;
result.Message = "库存申请明细获取失败";
return result;
}
//更新申请主表
Department dept = UserProvider.Departments.FirstOrDefault(temp => temp.DeptId == deptId);
if (dept == null || dept.DeptId < 0)
{
result.ResultStatus = -1;
result.Message = "申请部门不存在";
return result;
}
apply.ApplyDept = dept.DeptId;
apply.ApplyCorp = corpId;
apply.ApplyDesc = memo;
apply.ApplyType = ApplyType.付款申请;
apply.EmpId = user.EmpId;
result = applyDAL.Update(user, apply);
if (result.ResultStatus != 0)
return result;
//更新付款申请表
resultObj.RecCorpId = payApply.RecCorpId;
resultObj.RecBankId = payApply.RecBankId;
resultObj.RecBankAccountId = payApply.RecBankAccountId;
resultObj.RecBankAccount = payApply.RecBankAccount;
resultObj.ApplyBala = payApply.ApplyBala;
resultObj.CurrencyId = payApply.CurrencyId;
resultObj.PayMode = payApply.PayMode;
resultObj.PayDeadline = payApply.PayDeadline;
resultObj.PayMatter = payApply.PayMatter;
resultObj.SpecialDesc = payApply.SpecialDesc;
result = payapplyDAL.Update(user, resultObj);
if (result.ResultStatus != 0)
return result;
//作废现有已生效库存分配明细
foreach (StockPayApply stockPayApply in readyStockPayApplies)
{
stockPayApply.RefStatus = StatusEnum.已录入;
result = stockPayApplyDAL.Invalid(user, stockPayApply);
if (result.ResultStatus != 0)
return result;
}
//获取合约付款申请
result = contractPayApplyDAL.GetByPayApplyId(user, payApply.PayApplyId);
if (result.ResultStatus != 0)
return result;
ContractPayApply contractPayApply = result.ReturnValue as ContractPayApply;
if (contractPayApply == null || contractPayApply.RefId <= 0)
{
result.ResultStatus = -1;
result.Message = "获取对应合约付款失败";
return result;
}
//验证库存流水是否在同一子合约中
int subId = 0;
int contractId = 0;
foreach (StockPayApply stockPayApply in stockPayApplies)
{
result = stockLogDAL.Get(user, stockPayApply.StockLogId);
if (result.ResultStatus != 0)
return result;
StockLog stockLog = result.ReturnValue as StockLog;
if (stockLog == null || stockLog.StockLogId <= 0)
{
result.ResultStatus = -1;
result.Message = "库存流水不存在";
return result;
}
if (subId == 0)
{
subId = stockLog.SubContractId;
contractId = stockLog.ContractId;
}
if (stockLog.SubContractId != subId)
{
result.ResultStatus = -1;
result.Message = "不能同时申请不同子合约中的库存付款";
return result;
}
}
//更新合约付款
contractPayApply.ApplyBala = stockPayApplies.Sum(temp => temp.ApplyBala);
contractPayApply.ContractId = contractId;
contractPayApply.ContractSubId = subId;
result = contractPayApplyDAL.Update(user, contractPayApply);
if (result.ResultStatus != 0)
return result;
//新增dbo.Fun_StockPayApply_Ref库存付款申请
foreach (StockPayApply stockPayApply in stockPayApplies)
{
stockPayApply.ContractId = contractPayApply.ContractId;
stockPayApply.ContractRefId = contractPayApply.RefId;
stockPayApply.SubId = contractPayApply.ContractSubId;
stockPayApply.PayApplyId = contractPayApply.PayApplyId;
stockPayApply.RefStatus = StatusEnum.已生效;
result = stockPayApplyDAL.Insert(user, stockPayApply);
if (result.ResultStatus != 0)
return result;
}
scope.Complete();
}
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
}
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 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 StockReceiptUpdate(UserModel user, int detailId, int stockId, int stockLogId, decimal receiptAmount)
{
ResultModel result = new ResultModel();
try
{
DAL.StockDAL stockDAL = new StockDAL();
DAL.StockLogDAL stockLogDAL = new StockLogDAL();
DAL.StockReceiptDetailDAL stockReceiptDetailDAL = new StockReceiptDetailDAL();
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
result = stockReceiptDetailDAL.Get(user, detailId);
if (result.ResultStatus != 0)
return result;
Model.StockReceiptDetail stockReceiptDetail = result.ReturnValue as Model.StockReceiptDetail;
if (stockReceiptDetail == null || stockReceiptDetail.DetailId <= 0)
{
result.ResultStatus = -1;
result.Message = "获取库存回执错误";
return result;
}
stockReceiptDetail.ReceiptAmount = receiptAmount;
stockReceiptDetail.QtyMiss = receiptAmount - stockReceiptDetail.PreNetAmount;
stockReceiptDetail.QtyRate = (receiptAmount / stockReceiptDetail.PreNetAmount - 1) / 100;
//修改库存回执明细
result = stockReceiptDetailDAL.Update(user, stockReceiptDetail);
if (result.ResultStatus != 0)
return result;
//获取库存回执
result = stockreceiptDAL.Get(user, stockReceiptDetail.ReceiptId);
if (result.ResultStatus != 0)
return result;
Model.StockReceipt stockReceipt = result.ReturnValue as Model.StockReceipt;
if (stockReceipt == null || stockReceipt.ReceiptId <= 0)
{
result.ResultStatus = -1;
result.Message = "获取库存回执出错";
return result;
}
result = stockLogDAL.Get(user, 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;
}
stockLog.GapAmount = receiptAmount - stockReceiptDetail.PreNetAmount;
//更新库存流水
result = stockLogDAL.Update(user, stockLog);
if (result.ResultStatus != 0)
return result;
//获取库存
result = stockDAL.Get(user, 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 (stockReceipt.ReceiptType == (int)NFMT.WareHouse.ReceiptTypeEnum.入库回执)
{
stock.ReceiptInGap = receiptAmount - stockReceiptDetail.PreNetAmount;
}
else if (stockReceipt.ReceiptType == (int)NFMT.WareHouse.ReceiptTypeEnum.出库回执)
{
stock.ReceiptOutGap = receiptAmount - stockReceiptDetail.PreNetAmount;
}
stock.CurNetAmount = receiptAmount;
//更新库存
result = stockDAL.Update(user, stock);
if (result.ResultStatus != 0)
return result;
//若此库存已开业务票，则修改业务票中的净重
result = stockreceiptDAL.UpdateBussinessInvDetail(user, stockLogId, receiptAmount);
if (result.ResultStatus != 0)
return result;
scope.Complete();
}
}
catch (Exception ex)
{
result.ResultStatus = -1;
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 Close(UserModel user, int receiptId)
{
ResultModel result = new ResultModel();
try
{
DAL.StockLogDAL stockLogDAL = new StockLogDAL();
DAL.StockReceiptDetailDAL stockReceiptDetailDAL = new StockReceiptDetailDAL();
using (System.Transactions.TransactionScope scope = new TransactionScope())
{
//获取回执
result = this.stockreceiptDAL.Get(user, receiptId);
if (result.ResultStatus != 0)
return result;
Model.StockReceipt stockReceipt = result.ReturnValue as Model.StockReceipt;
if (stockReceipt == null || stockReceipt.ReceiptId <= 0)
{
result.ResultStatus = -1;
result.Message = "库存回执不存在";
return result;
}
//关闭回执
result = this.stockreceiptDAL.Close(user, stockReceipt);
if (result.ResultStatus != 0)
return result;
//获取回执明细
result = stockReceiptDetailDAL.Load(user, stockReceipt.ReceiptId);
if (result.ResultStatus != 0)
return result;
List<Model.StockReceiptDetail> details = result.ReturnValue as List<Model.StockReceiptDetail>;
if (details == null || details.Count == 0)
{
result.ResultStatus = -1;
result.Message = "回执明细获取失败";
return result;
}
foreach (Model.StockReceiptDetail detail in details)
{
//关闭回执明细
result = stockReceiptDetailDAL.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;
}
//更新库存流水磅差
stockLog.GapAmount -= detail.QtyMiss;
result = stockLogDAL.Update(user, stockLog);
if (result.ResultStatus != 0)
return result;
}
}
}
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 Audit(UserModel user, NFMT.WorkFlow.Model.DataSource dataSource, bool isPass)
{
ResultModel result = new ResultModel();
try
{
DAL.StockDAL stockDAL = new StockDAL();
NFMT.WareHouse.DAL.StockLogDAL stockLogDAL = new StockLogDAL();
NFMT.WareHouse.DAL.StockReceiptDetailDAL stockReceiptDetailDAL = new StockReceiptDetailDAL();
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
result = this.stockreceiptDAL.Get(NFMT.Common.DefaultValue.SysUser, dataSource.RowId);
if (result.ResultStatus != 0)
return result;
Model.StockReceipt stockReceipt = result.ReturnValue as Model.StockReceipt;
if (stockReceipt == null || stockReceipt.ReceiptId <= 0)
{
result.ResultStatus = -1;
result.Message = "库存回执不存在";
return result;
}
//审核，修改数据状态
result = this.stockreceiptDAL.Audit(user, stockReceipt, isPass);
if (result.ResultStatus != 0)
return result;
//审核通过
if (isPass)
{
//获取回执明细
result = stockReceiptDetailDAL.Load(user, stockReceipt.ReceiptId);
if (result.ResultStatus != 0)
return result;
List<Model.StockReceiptDetail> stockReceiptDetails = result.ReturnValue as List<Model.StockReceiptDetail>;
if (stockReceiptDetails == null || stockReceiptDetails.Count == 0)
{
result.ResultStatus = -1;
result.Message = "获取回执明细失败";
return result;
}
foreach (Model.StockReceiptDetail detail in stockReceiptDetails)
{
//获取库存流水
result = stockLogDAL.Get(NFMT.Common.DefaultValue.SysUser, 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;
}
//更新库存流水回执重量
stockLog.GapAmount += detail.QtyMiss;
result = stockLogDAL.Update(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 (stockReceipt.ReceiptType == (int)ReceiptTypeEnum.入库回执)
{
stock.ReceiptInGap += detail.QtyMiss;
//stock.NetAmount += detail.QtyMiss;
}
else
stock.ReceiptOutGap += detail.QtyMiss;
stock.CurNetAmount = detail.ReceiptAmount;
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;
}
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;
}
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 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 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 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 CompleteCancel(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 CustomsClearance;
if (customsClearance == null)
{
result.Message = "该数据不存在，不能完成";
result.ResultStatus = -1;
return result;
}
result = customsclearanceDAL.CompleteCancel(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.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;
}
stock.StockStatus = StockStatusEnum.预报关库存;
stock.CustomsType = NFMT.Data.DetailProvider.Details(Data.StyleEnum.CustomType)["OutsideCustom"].StyleDetailId;//关外
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;
}
return result;
}
public ResultModel CreateBusinessInvoice(UserModel user, Operate.Model.Invoice invoice, BusinessInvoice invoiceBusiness, List<BusinessInvoiceDetail> details, InvoiceTypeEnum invoiceType)
{
ResultModel result = new ResultModel();
try
{
BusinessInvoiceDAL businessInvoiceDAL = new BusinessInvoiceDAL();
InvoiceDAL invoiceDAL = new InvoiceDAL();
BusinessInvoiceDetailDAL detailDAL = new BusinessInvoiceDetailDAL();
ContractSubDAL subDAL = new ContractSubDAL();
StockReceiptDetailDAL stockReceiptDetailDAL = new StockReceiptDetailDAL();
SubDetailDAL subDetailDAL = new SubDetailDAL();
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
//验证子合约
result = subDAL.Get(user, invoiceBusiness.SubContractId);
if (result.ResultStatus != 0)
return result;
ContractSub sub = result.ReturnValue as ContractSub;
if (sub == null || sub.SubId <= 0)
{
result.ResultStatus = -1;
result.Message = "子合约不存在";
return result;
}
if (sub.SubStatus != StatusEnum.已生效)
{
result.ResultStatus = -1;
result.Message = "子合约非已生效状态，不能新增临票";
return result;
}
//获取子合约明细
result = subDetailDAL.GetDetailBySubId(user, sub.SubId);
if (result.ResultStatus != 0)
return result;
SubDetail subDetail = result.ReturnValue as SubDetail;
if (subDetail == null || subDetail.SubDetailId <= 0)
{
result.ResultStatus = -1;
result.Message = "子合约明细获取失败";
return result;
}
//获取子合约下所有
result = this.businessinvoiceDAL.LoadBySubId(user, invoiceBusiness.SubContractId, invoiceType);
if (result.ResultStatus != 0)
return result;
List<BusinessInvoice> bis = result.ReturnValue as List<BusinessInvoice>;
decimal sumNetAmount = bis.Sum(temp => temp.NetAmount);
decimal maxNetAmount = sub.SignAmount * (1 + subDetail.MoreOrLess);
//if (maxNetAmount < sumNetAmount + invoiceBusiness.NetAmount)
//{
// result.ResultStatus = -1;
// result.Message = "开票重量超额";
// return result;
//}
//新增发票主表
int invoiceId = 0;
invoice.InvoiceType = (int)invoiceType;
invoice.InvoiceStatus = StatusEnum.已录入;
Corporation outCorp = UserProvider.Corporations.FirstOrDefault(temp => temp.CorpId == invoice.OutCorpId);
if (outCorp == null || outCorp.CorpId <= 0)
{
result.ResultStatus = -1;
result.Message = "开票公司信息错误";
return result;
}
invoice.OutCorpName = outCorp.CorpName;
Corporation inCorp = UserProvider.Corporations.FirstOrDefault(temp => temp.CorpId == invoice.InCorpId);
if (inCorp == null || inCorp.CorpId <= 0)
{
result.ResultStatus = -1;
result.Message = "收票公司信息错误";
return result;
}
invoice.InCorpName = inCorp.CorpName;
result = invoiceDAL.Insert(user, invoice);
if (result.ResultStatus != 0)
return result;
if (result.ReturnValue == null || !int.TryParse(result.ReturnValue.ToString(), out invoiceId))
{
result.ResultStatus = -1;
result.Message = "发票添加失败";
return result;
}
//新增业务发票表
int businessInvoiceId = 0;
invoiceBusiness.InvoiceId = invoiceId;
result = businessInvoiceDAL.Insert(user, invoiceBusiness);
if (result.ResultStatus != 0)
return result;
if (result.ReturnValue == null || !int.TryParse(result.ReturnValue.ToString(), out businessInvoiceId))
{
result.ResultStatus = -1;
result.Message = "新增发票失败";
return result;
}
//新增业务发票明细
StockLogDAL stockLogDAL = new StockLogDAL();
StockDAL stockDAL = new StockDAL();
foreach (BusinessInvoiceDetail detail in details)
{
if (detail.NetAmount != 0 && detail.StockId > 0)
{
//验证库存
result = stockDAL.Get(user, detail.StockId);
if (result.ResultStatus != 0)
return result;
Stock stock = result.ReturnValue as Stock;
if (stock == null || stock.StockId <= 0)
{
result.ResultStatus = -1;
result.Message = "发票库存获取失败";
return result;
}
//验证库存流水
result = stockLogDAL.Get(user, detail.StockLogId);
if (result.ResultStatus != 0)
return result;
StockLog stockLog = result.ReturnValue as StockLog;
if (stockLog == null || stockLog.StockLogId <= 0)
{
result.ResultStatus = -1;
result.Message = "新增发票流水获取失败";
return result;
}
//基本验证
if (stockLog.StockId != stock.StockId)
{
result.ResultStatus = -1;
result.Message = "库存与库存流水不匹配";
return result;
}
//验证流水合约与发票合约是否相同
if (stockLog.SubContractId != invoiceBusiness.SubContractId)
{
result.ResultStatus = -1;
result.Message = "合约与库存流水不匹配";
return result;
}
detail.DetailStatus = StatusEnum.已生效;
detail.InvoiceId = invoiceId;
detail.BusinessInvoiceId = businessInvoiceId;
detail.StockId = stockLog.StockId;
detail.StockLogId = stockLog.StockLogId;
if (invoice.InvoiceType == (int)InvoiceTypeEnum.SuppleFinalInvoice)
{
//获取当前流水回执信息
result = stockReceiptDetailDAL.LoadByStockLogId(user, stockLog.StockLogId);
List<StockReceiptDetail> stockReceiptDetails = result.ReturnValue as List<StockReceiptDetail>;
if (stockReceiptDetails == null)
{
result.ResultStatus = -1;
result.Message = "当前流水未回执，不能补零";
return result;
}
decimal sumQtyMiss = stockReceiptDetails.Sum(temp => temp.QtyMiss);
detail.IntegerAmount = sumQtyMiss;
detail.NetAmount = sumQtyMiss;
}
//else
//{
// detail.IntegerAmount = stockLog.GrossAmount;
// detail.NetAmount = stockLog.NetAmount;
//}
result = detailDAL.Insert(user, detail);
if (result.ResultStatus != 0)
return result;
}
}
invoice.InvoiceId = invoiceId;
if (result.ResultStatus == 0) result.ReturnValue = invoice;
scope.Complete();
}
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
}
return result;
}
