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 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 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 CompleteCancel(UserModel user, int receiptId)
{
ResultModel result = new ResultModel();
try
{
DAL.StockDAL stockDAL = new StockDAL();
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
result = this.stockreceiptDAL.Get(user, receiptId);
if (result.ResultStatus != 0)
return result;
StockReceipt stockReceipt = result.ReturnValue as StockReceipt;
if (stockReceipt == null || stockReceipt.ReceiptId <= 0)
{
result.ResultStatus = -1;
result.Message = "该数据不存在，不能作废";
return result;
}
result = this.stockreceiptDAL.CompleteCancel(user, stockReceipt);
if (result.ResultStatus != 0)
return result;
StockReceiptDetailDAL detailDAL = new StockReceiptDetailDAL();
result = detailDAL.Load(user, stockReceipt.ReceiptId, StatusEnum.已完成);
if (result.ResultStatus != 0)
return result;
List<Model.StockReceiptDetail> details = result.ReturnValue as List<Model.StockReceiptDetail>;
if (details == null)
{
result.ResultStatus = -1;
result.Message = "获取回执明细失败";
return result;
}
foreach (Model.StockReceiptDetail detail in details)
{
result = detailDAL.CompleteCancel(user, detail);
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.QtyMiss;
result = stockDAL.Update(user, stock);
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 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 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 Invalid(UserModel user, int receiptId)
{
ResultModel result = new ResultModel();
try
{
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
result = this.stockreceiptDAL.Get(user, receiptId);
if (result.ResultStatus != 0)
return result;
StockReceipt stockReceipt = result.ReturnValue as StockReceipt;
if (stockReceipt == null || stockReceipt.ReceiptId <= 0)
{
result.ResultStatus = -1;
result.Message = "该数据不存在，不能作废";
return result;
}
result = this.stockreceiptDAL.Invalid(user, stockReceipt);
if (result.ResultStatus != 0)
return result;
StockReceiptDetailDAL detailDAL = new StockReceiptDetailDAL();
result = detailDAL.Load(user, stockReceipt.ReceiptId);
if (result.ResultStatus != 0)
return result;
List<Model.StockReceiptDetail> details = result.ReturnValue as List<Model.StockReceiptDetail>;
if (details == null)
{
result.ResultStatus = -1;
result.Message = "获取回执明细失败";
return result;
}
foreach (Model.StockReceiptDetail detail in details)
{
if (detail.DetailStatus == StatusEnum.已生效)
detail.DetailStatus = StatusEnum.已录入;
result = detailDAL.Invalid(user, detail);
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 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;
}
public ResultModel UpdateBusinessInvoice(UserModel user, Operate.Model.Invoice invoice, BusinessInvoice invoiceBusiness, List<BusinessInvoiceDetail> details)
{
ResultModel result = new ResultModel();
try
{
BusinessInvoiceDAL businessInvoiceDAL = new BusinessInvoiceDAL();
InvoiceDAL invoiceDAL = new InvoiceDAL();
BusinessInvoiceDetailDAL detailDAL = new BusinessInvoiceDetailDAL();
StockReceiptDetailDAL stockReceiptDetailDAL = new StockReceiptDetailDAL();
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
//验证发票
if (invoiceBusiness.BusinessInvoiceId <= 0)
{
result.Message = "发票不存在";
return result;
}
result = businessinvoiceDAL.Get(user, invoiceBusiness.BusinessInvoiceId);
if (result.ResultStatus != 0)
return result;
BusinessInvoice resultBusinessInvoice = result.ReturnValue as BusinessInvoice;
if (resultBusinessInvoice == null || resultBusinessInvoice.BusinessInvoiceId <= 0)
{
result.ResultStatus = -1;
result.Message = "发票不存在";
return result;
}
//更新发票
resultBusinessInvoice.IntegerAmount = invoiceBusiness.IntegerAmount;
resultBusinessInvoice.NetAmount = invoiceBusiness.NetAmount;
resultBusinessInvoice.VATRatio = invoiceBusiness.VATRatio;
resultBusinessInvoice.VATBala = invoiceBusiness.VATBala;
resultBusinessInvoice.UnitPrice = invoiceBusiness.UnitPrice;
resultBusinessInvoice.Status = StatusEnum.已录入;
result = businessinvoiceDAL.Update(user, resultBusinessInvoice);
if (result.ResultStatus != 0)
return result;
//获取发票主表
result = invoiceDAL.Get(user, resultBusinessInvoice.InvoiceId);
if (result.ResultStatus != 0)
return result;
Operate.Model.Invoice resultInvoice = result.ReturnValue as Operate.Model.Invoice;
if (resultInvoice == null || resultInvoice.InvoiceId <= 0)
{
result.ResultStatus = -1;
result.Message = "发票不存在";
return result;
}
//更新发票
resultInvoice.InvoiceDate = invoice.InvoiceDate;
resultInvoice.InvoiceName = invoice.InvoiceName;
resultInvoice.InvoiceBala = invoice.InvoiceBala;
resultInvoice.OutCorpId = invoice.OutCorpId;
resultInvoice.InCorpId = invoice.InCorpId;
resultInvoice.Memo = invoice.Memo;
result = invoiceDAL.Update(user, resultInvoice);
if (result.ResultStatus != 0)
return result;
//获取发票明细
result = detailDAL.Load(user, resultBusinessInvoice.BusinessInvoiceId);
if (result.ResultStatus != 0)
return result;
List<BusinessInvoiceDetail> resultDetails = result.ReturnValue as List<BusinessInvoiceDetail>;
if (resultDetails == null)
{
result.ResultStatus = -1;
result.Message = "获取发票明细失败";
return result;
}
//作废发票明细
foreach (BusinessInvoiceDetail detail in resultDetails)
{
if (detail.DetailStatus == StatusEnum.已生效)
detail.DetailStatus = StatusEnum.已录入;
result = detailDAL.Invalid(user, detail);
if (result.ResultStatus != 0)
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 != resultBusinessInvoice.SubContractId)
{
result.ResultStatus = -1;
result.Message = "合约与库存流水不匹配";
return result;
}
detail.DetailStatus = StatusEnum.已生效;
detail.InvoiceId = resultInvoice.InvoiceId;
detail.BusinessInvoiceId = resultBusinessInvoice.BusinessInvoiceId;
detail.StockId = stockLog.StockId;
detail.StockLogId = stockLog.StockLogId;
if (resultInvoice.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;
}
}
if (result.ResultStatus == 0)
result.ReturnValue = resultInvoice;
scope.Complete();
}
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
}
return result;
}
