public ResultModel Close(UserModel user, int virtualId)
{
ResultModel result = new ResultModel();
try
{
DAL.PayApplyDAL payApplyDAL = new PayApplyDAL();
DAL.PaymentDAL paymentDAL = new PaymentDAL();
DAL.PaymentInvioceDetailDAL invoiceDetailDAL = new PaymentInvioceDetailDAL();
DAL.PaymentStockDetailDAL stockDetailDAL = new PaymentStockDetailDAL();
DAL.PaymentContractDetailDAL contractDetailDAL = new PaymentContractDetailDAL();
using (System.Transactions.TransactionScope scope = new TransactionScope())
{
//获取虚拟付款
result = this.paymentvirtualDAL.Get(user, virtualId);
if (result.ResultStatus != 0)
return result;
Model.PaymentVirtual paymentVirtual = result.ReturnValue as Model.PaymentVirtual;
if (paymentVirtual == null || paymentVirtual.VirtualId <= 0)
{
result.ResultStatus = -1;
result.Message = "虚拟付款不存在";
return result;
}
//关闭虚拟付款
result = this.paymentvirtualDAL.Close(user, paymentVirtual);
if (result.ResultStatus != 0)
return result;
//获取主付款
result = paymentDAL.Get(user, paymentVirtual.PaymentId);
if (result.ResultStatus != 0)
return result;
Model.Payment payment = result.ReturnValue as Model.Payment;
if (payment == null || payment.PaymentId <= 0)
{
result.ResultStatus = -1;
result.Message = "主付款不存在";
return result;
}
//当前主付款虚拟金额更新为0
payment.VirtualBala = 0;
payment.PayBala = payment.FundsBala;
result = paymentDAL.Update(user, payment);
if (result.ResultStatus != 0)
return result;
//获取对应付款申请
result = payApplyDAL.Get(user, payment.PayApplyId);
if (result.ResultStatus != 0)
return result;
Model.PayApply payApply = result.ReturnValue as Model.PayApply;
if (payApply == null || payApply.PayApplyId <= 0)
{
result.ResultStatus = -1;
result.Message = "付款申请获取失败";
return result;
}
if (payApply.PayApplySource == (int)FundsStyleEnum.InvoicePayApply)
{
//获取所有发票明细
result = invoiceDetailDAL.Load(user, payment.PaymentId);
if (result.ResultStatus != 0)
return result;
List<Model.PaymentInvioceDetail> invoiceDetails = result.ReturnValue as List<Model.PaymentInvioceDetail>;
if (invoiceDetails == null)
{
result.ResultStatus = -1;
result.Message = "发票明细获取失败";
return result;
}
//当前主付款发票明细虚拟金额更新为0
foreach (Model.PaymentInvioceDetail invoiceDetail in invoiceDetails)
{
invoiceDetail.VirtualBala =0;
invoiceDetail.PayBala = invoiceDetail.FundsBala;
result = invoiceDetailDAL.Update(user, invoiceDetail);
if (result.ResultStatus != 0)
return result;
}
}
else if (payApply.PayApplySource == (int)FundsStyleEnum.ContractPayApply)
{
//获取合约明细
result = contractDetailDAL.GetByPaymentId(user, payment.PaymentId);
if(result.ResultStatus!=0)
return result;
Model.PaymentContractDetail contractDetail = result.ReturnValue as Model.PaymentContractDetail;
if (contractDetail == null || contractDetail.DetailId <= 0)
{
result.ResultStatus = -1;
result.Message = "合约明细获取失败";
return result;
}
//当前主付款合约明细虚拟金额更新为0
contractDetail.VirtualBala = 0;
contractDetail.PayBala = contractDetail.FundsBala;
result = contractDetailDAL.Update(user, contractDetail);
if (result.ResultStatus != 0)
return result;
}
else if (payApply.PayApplySource == (int)FundsStyleEnum.StockPayApply)
{
//获取合约明细
result = contractDetailDAL.GetByPaymentId(user, payment.PaymentId);
if(result.ResultStatus!=0)
return result;
Model.PaymentContractDetail contractDetail = result.ReturnValue as Model.PaymentContractDetail;
if (contractDetail == null || contractDetail.DetailId <= 0)
{
result.ResultStatus = -1;
result.Message = "合约明细获取失败";
return result;
}
//当前主付款合约明细虚拟金额更新为0
contractDetail.VirtualBala = 0;
contractDetail.PayBala = contractDetail.FundsBala;
result = contractDetailDAL.Update(user, contractDetail);
if (result.ResultStatus != 0)
return result;
//获取库存明细
result = stockDetailDAL.LoadByPaymentId(user, payment.PaymentId);
if (result.ResultStatus != 0)
return result;
List<Model.PaymentStockDetail> stockDetails = result.ReturnValue as List<Model.PaymentStockDetail>;
if (stockDetails == null)
{
result.ResultStatus = -1;
result.Message = "库存明细获取失败";
return result;
}
//当前主付款库存明细虚拟金额更新为0
foreach (Model.PaymentStockDetail stockDetail in stockDetails)
{
stockDetail.VirtualBala = 0;
stockDetail.PayBala = stockDetail.FundsBala;
result = stockDetailDAL.Update(user, stockDetail);
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 paymentId)
{
ResultModel result = new ResultModel();
try
{
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
//验证付款
result = paymentDAL.Get(user, paymentId);
if (result.ResultStatus != 0)
return result;
Payment payment = result.ReturnValue as Payment;
if (payment == null || payment.PaymentId <= 0)
{
result.ResultStatus = -1;
result.Message = "该数据不存在，不能进行执行完成操作";
return result;
}
//获取对应的付款申请
DAL.PayApplyDAL payApplyDAL = new PayApplyDAL();
result = payApplyDAL.Get(user, payment.PayApplyId);
if (result.ResultStatus != 0)
return result;
Model.PayApply payApply = result.ReturnValue as Model.PayApply;
if (payApply == null || payApply.PayApplyId <= 0)
{
result.ResultStatus = -1;
result.Message = "付款申请不存在";
return result;
}
//验证对应付款申请状态
//获取主申请
NFMT.Operate.DAL.ApplyDAL applyDAL = new NFMT.Operate.DAL.ApplyDAL();
result = applyDAL.Get(user, payApply.ApplyId);
if (result.ResultStatus != 0)
return result;
NFMT.Operate.Model.Apply apply = result.ReturnValue as NFMT.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 = paymentDAL.CompleteCancel(user, payment);
if (result.ResultStatus != 0)
return result;
if (payApply.PayApplySource == (int)Funds.FundsStyleEnum.InvoicePayApply)
{
DAL.PaymentInvioceDetailDAL paymentInvoiceDetailDAL = new PaymentInvioceDetailDAL();
result = paymentInvoiceDetailDAL.Load(user, payment.PaymentId, Common.StatusEnum.已完成);
if (result.ResultStatus != 0)
return result;
List<Model.PaymentInvioceDetail> details = result.ReturnValue as List<Model.PaymentInvioceDetail>;
if (details == null)
{
result.ResultStatus = -1;
result.Message = "财务付款发票明细获取失败";
return result;
}
foreach (Model.PaymentInvioceDetail detail in details)
{
//更新已完成状态的明细至已生效
result = paymentInvoiceDetailDAL.CompleteCancel(user, detail);
if (result.ResultStatus != 0)
return result;
}
}
else if (payApply.PayApplySource == (int)Funds.FundsStyleEnum.StockPayApply)
{
DAL.PaymentStockDetailDAL paymentStockDetailDAL = new PaymentStockDetailDAL();
result = paymentStockDetailDAL.LoadByPaymentId(user, payment.PaymentId, Common.StatusEnum.已完成);
if (result.ResultStatus != 0)
return result;
List<Model.PaymentStockDetail> details = result.ReturnValue as List<Model.PaymentStockDetail>;
if (details == null)
{
result.ResultStatus = -1;
result.Message = "财务付款库存明细获取失败";
return result;
}
foreach (Model.PaymentStockDetail detail in details)
{
//更新已完成状态的明细至已生效
result = paymentStockDetailDAL.CompleteCancel(user, detail);
if (result.ResultStatus != 0)
return result;
}
}
//更新财务流水至已生效
DAL.FundsLogDAL fundsLogDAL = new FundsLogDAL();
result = fundsLogDAL.Get(user, payment.FundsLogId);
if (result.ResultStatus != 0)
return result;
Model.FundsLog fundsLog = result.ReturnValue as Model.FundsLog;
if (fundsLog == null || fundsLog.FundsLogId <= 0)
{
result.ResultStatus = -1;
result.Message = "付款流水获取失败";
return result;
}
result = fundsLogDAL.CompleteCancel(user, fundsLog);
if (result.ResultStatus != 0)
return result;
scope.Complete();
}
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
}
return result;
}
public ResultModel Complete(UserModel user, int paymentId)
{
ResultModel result = new ResultModel();
try
{
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
//验证付款
result = paymentDAL.Get(user, paymentId);
if (result.ResultStatus != 0)
return result;
Payment payment = result.ReturnValue as Payment;
if (payment == null || payment.PaymentId <= 0)
{
result.ResultStatus = -1;
result.Message = "该数据不存在，不能进行执行完成操作";
return result;
}
//执行完成
result = paymentDAL.Complete(user, payment);
if (result.ResultStatus != 0)
return result;
////虚拟明细执行完成
//DAL.PaymentVirtualDAL paymentVirtualDAL = new PaymentVirtualDAL();
////获取已生效的虚拟付款明细
//result = paymentVirtualDAL.GetByPaymentId(user, payment.PaymentId, Common.StatusEnum.已生效);
//if (result.ResultStatus != 0)
// return result;
//Model.PaymentVirtual paymentVirtual = result.ReturnValue as Model.PaymentVirtual;
//if (paymentVirtual == null)
//{
// result.ResultStatus = -1;
// result.Message = "获取虚拟收付款信息失败";
// return result;
//}
//if (paymentVirtual.VirtualId > 0 && paymentVirtual.PayBala > 0)
//{
// result = paymentVirtualDAL.Complete(user, paymentVirtual);
// if (result.ResultStatus != 0)
// return result;
//}
//获取对应付款申请
DAL.PayApplyDAL payApplyDAL = new PayApplyDAL();
result = payApplyDAL.Get(user, payment.PayApplyId);
if (result.ResultStatus != 0)
return result;
Model.PayApply payApply = result.ReturnValue as PayApply;
if (payApply == null || payApply.PayApplyId <= 0)
{
result.ResultStatus = -1;
result.Message = "当前付款对应的付款申请获取失败";
return result;
}
if (payApply.PayApplySource == (int)Funds.FundsStyleEnum.InvoicePayApply)
{
DAL.PaymentInvioceDetailDAL paymentInvoiceDetailDAL = new PaymentInvioceDetailDAL();
result = paymentInvoiceDetailDAL.Load(user, payment.PaymentId);
if (result.ResultStatus != 0)
return result;
List<Model.PaymentInvioceDetail> details = result.ReturnValue as List<Model.PaymentInvioceDetail>;
if (details == null)
{
result.ResultStatus = -1;
result.Message = "财务付款发票明细获取失败";
return result;
}
foreach (Model.PaymentInvioceDetail detail in details)
{
//完成发票明细
result = paymentInvoiceDetailDAL.Complete(user,detail);
if (result.ResultStatus != 0)
return result;
}
}
else if (payApply.PayApplySource == (int)Funds.FundsStyleEnum.StockPayApply)
{
DAL.PaymentStockDetailDAL paymentStockDetailDAL = new PaymentStockDetailDAL();
result = paymentStockDetailDAL.LoadByPaymentId(user, payment.PaymentId);
if (result.ResultStatus != 0)
return result;
List<Model.PaymentStockDetail> details = result.ReturnValue as List<Model.PaymentStockDetail>;
if (details == null)
{
result.ResultStatus = -1;
result.Message = "财务付款库存明细获取失败";
return result;
}
foreach (Model.PaymentStockDetail detail in details)
{
//更新状态至已完成
result = paymentStockDetailDAL.Complete(user, detail);
if (result.ResultStatus != 0)
return result;
}
}
//更新财务流水至已完成
DAL.FundsLogDAL fundsLogDAL = new FundsLogDAL();
result = fundsLogDAL.Get(user, payment.FundsLogId);
if (result.ResultStatus != 0)
return result;
Model.FundsLog fundsLog = result.ReturnValue as Model.FundsLog;
if (fundsLog == null || fundsLog.FundsLogId <= 0)
{
result.ResultStatus = -1;
result.Message = "付款流水获取失败";
return result;
}
result = fundsLogDAL.Complete(user, fundsLog);
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 paymentId)
{
ResultModel result = new ResultModel();
try
{
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
//验证付款
result = paymentDAL.Get(user, paymentId);
if (result.ResultStatus != 0)
return result;
Payment payment = result.ReturnValue as Payment;
if (payment == null || payment.PaymentId <= 0)
{
result.ResultStatus = -1;
result.Message = "该数据不存在，不能进行执行完成操作";
return result;
}
//关闭付款
result = paymentDAL.Close(user, payment);
if (result.ResultStatus != 0)
return result;
//获取对应付款申请
DAL.PayApplyDAL payApplyDAL = new PayApplyDAL();
result = payApplyDAL.Get(user, payment.PayApplyId);
if (result.ResultStatus != 0)
return result;
Model.PayApply payApply = result.ReturnValue as PayApply;
if (payApply == null || payApply.PayApplyId <= 0)
{
result.ResultStatus = -1;
result.Message = "当前付款对应的付款申请获取失败";
return result;
}
if (payApply.PayApplySource == (int)Funds.FundsStyleEnum.InvoicePayApply)
{
DAL.PaymentInvioceDetailDAL paymentInvoiceDetailDAL = new PaymentInvioceDetailDAL();
result = paymentInvoiceDetailDAL.Load(user, payment.PaymentId);
if (result.ResultStatus != 0)
return result;
List<Model.PaymentInvioceDetail> details = result.ReturnValue as List<Model.PaymentInvioceDetail>;
if (details == null)
{
result.ResultStatus = -1;
result.Message = "财务付款发票明细获取失败";
return result;
}
foreach (Model.PaymentInvioceDetail detail in details)
{
//关闭发票明细
result = paymentInvoiceDetailDAL.Close(user, detail);
if (result.ResultStatus != 0)
return result;
}
}
else if (payApply.PayApplySource == (int)Funds.FundsStyleEnum.StockPayApply)
{
DAL.PaymentStockDetailDAL paymentStockDetailDAL = new PaymentStockDetailDAL();
result = paymentStockDetailDAL.LoadByPaymentId(user, payment.PaymentId);
if (result.ResultStatus != 0)
return result;
List<Model.PaymentStockDetail> details = result.ReturnValue as List<Model.PaymentStockDetail>;
if (details == null)
{
result.ResultStatus = -1;
result.Message = "财务付款库存明细获取失败";
return result;
}
foreach (Model.PaymentStockDetail detail in details)
{
//关闭库存明细
result = paymentStockDetailDAL.Close(user, detail);
if (result.ResultStatus != 0)
return result;
}
}
//更新财务流水至已关闭
DAL.FundsLogDAL fundsLogDAL = new FundsLogDAL();
result = fundsLogDAL.Get(user, payment.FundsLogId);
if (result.ResultStatus != 0)
return result;
Model.FundsLog fundsLog = result.ReturnValue as Model.FundsLog;
if (fundsLog == null || fundsLog.FundsLogId <= 0)
{
result.ResultStatus = -1;
result.Message = "付款流水获取失败";
return result;
}
result = fundsLogDAL.Close(user, fundsLog);
if (result.ResultStatus != 0)
return result;
scope.Complete();
}
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
}
return result;
}
public ResultModel PaymentInvoiceUpdate(UserModel user, Model.Payment payment, List<Model.PaymentInvioceDetail> paymentInvoiceDetails)
{
ResultModel result = new ResultModel();
try
{
DAL.PayApplyDAL payApplyDAL = new PayApplyDAL();
NFMT.Operate.DAL.ApplyDAL applyDAL = new NFMT.Operate.DAL.ApplyDAL();
DAL.InvoicePayApplyDAL invoicePayApplyDAL = new InvoicePayApplyDAL();
DAL.PaymentInvioceDetailDAL paymentInvoiceDetailDAL = new PaymentInvioceDetailDAL();
using (System.Transactions.TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
if (paymentInvoiceDetails == null || paymentInvoiceDetails.Count == 0)
{
result.ResultStatus = -1;
result.Message = "未填写任何发票明细";
return result;
}
foreach (Model.PaymentInvioceDetail d in paymentInvoiceDetails)
{
d.PayBala = d.FundsBala + d.VirtualBala;
}
//验证付款总额是否等于财务付款金额+虚拟付款金额
if (payment.PayBala != payment.FundsBala + payment.VirtualBala)
{
result.ResultStatus = -1;
result.Message = "付款总额必须等于财务付款金额+虚拟付款金额";
return result;
}
//获取财务付款
result = this.paymentDAL.Get(user, payment.PaymentId);
if (result.ResultStatus != 0)
return result;
Model.Payment resultPayment = result.ReturnValue as Model.Payment;
if (resultPayment == null || resultPayment.PaymentId <= 0)
{
result.ResultStatus = -1;
result.Message = "财务付款不存在，不能进行修改";
return result;
}
//验证付款申请
result = payApplyDAL.Get(user, resultPayment.PayApplyId);
if (result.ResultStatus != 0)
return result;
Model.PayApply payApply = result.ReturnValue as Model.PayApply;
if (payApply == null || payApply.PayApplyId <= 0)
{
result.ResultStatus = -1;
result.Message = "付款申请不存在";
return result;
}
//获取主申请
result = applyDAL.Get(user, payApply.ApplyId);
if (result.ResultStatus != 0)
return result;
NFMT.Operate.Model.Apply apply = result.ReturnValue as NFMT.Operate.Model.Apply;
if (apply == null || apply.ApplyId <= 0)
{
result.ResultStatus = -1;
result.Message = "付款主申请不存在";
return result;
}
//判断申请状态是否已生效
if (apply.ApplyStatus != NFMT.Common.StatusEnum.已生效)
{
result.ResultStatus = -1;
result.Message = "付款申请非已生效状态，不能进行付款";
return result;
}
//获取当前付款申请中的所有付款
result = paymentDAL.Load(user, payApply.PayApplyId);
if (result.ResultStatus != 0)
return result;
List<Model.Payment> payments = result.ReturnValue as List<Model.Payment>;
if (payments == null)
{
result.ResultStatus = -1;
result.Message = "获取当前付款申请的付款执行失败";
return result;
}
//判断付款申请可付余额
decimal payedBala = payments.Sum(temp => temp.PayBala);
if (payApply.ApplyBala - payedBala < 0)
{
result.ResultStatus = -1;
result.Message = "当前付款申请已无余款可付";
return result;
}
if (payApply.ApplyBala - payedBala - payment.PayBala + resultPayment.PayBala < 0)
{
result.ResultStatus = -1;
result.Message = "当前付款金额大于可付余额";
return result;
}
//获取付款申请对应发票明细列表
result = invoicePayApplyDAL.Load(user, payApply.PayApplyId);
if (result.ResultStatus != 0)
return result;
List<Model.InvoicePayApply> invoicePayApplies = result.ReturnValue as List<Model.InvoicePayApply>;
if (invoicePayApplies == null)
{
result.ResultStatus = -1;
result.Message = "付款申请明细失败";
return result;
}
//作废原有财务付款发票明细
result = paymentInvoiceDetailDAL.Load(user, payment.PaymentId);
if (result.ResultStatus != 0)
return result;
List<Model.PaymentInvioceDetail> resultDetails = result.ReturnValue as List<Model.PaymentInvioceDetail>;
if (resultDetails == null)
{
result.ResultStatus = -1;
result.Message = "获取财务付款明细失败";
return result;
}
foreach (PaymentInvioceDetail d in resultDetails)
{
d.Status = StatusEnum.已录入;
result = paymentInvoiceDetailDAL.Invalid(user, d);
if (result.ResultStatus != 0)
return result;
}
foreach (Model.PaymentInvioceDetail d in paymentInvoiceDetails)
{
if (d.PayBala > 0)
{
//获取当前发票付款明细列表
result = paymentInvoiceDetailDAL.LoadByInvoicePayApplyId(user, d.PayApplyDetailId);
if (result.ResultStatus != 0)
return result;
List<Model.PaymentInvioceDetail> details = result.ReturnValue as List<Model.PaymentInvioceDetail>;
decimal detailPayedBala = details.Sum(temp => temp.PayBala);
var ls = paymentInvoiceDetails.Where(temp => temp.PayApplyDetailId == d.PayApplyDetailId);
decimal detailPayingBala = ls.Sum(temp => temp.PayBala);
//获取对应的申请明细
result = invoicePayApplyDAL.Get(user, d.PayApplyDetailId);
if (result.ResultStatus != 0)
return result;
InvoicePayApply invoicePayApply = result.ReturnValue as InvoicePayApply;
if (invoicePayApply == null || invoicePayApply.RefId <= 0)
{
result.ResultStatus = -1;
result.Message = string.Format("发票申请明细获取失败");
return result;
}
if (invoicePayApply.ApplyBala - detailPayedBala - detailPayingBala < 0)
{
result.ResultStatus = -1;
result.Message = string.Format("发票申请明细付款超额");
return result;
}
}
}
decimal sumPayBala = paymentInvoiceDetails.Sum(temp => temp.PayBala);
decimal sumFundsBala = paymentInvoiceDetails.Sum(temp => temp.FundsBala);
decimal sumVirtualBala = paymentInvoiceDetails.Sum(temp => temp.VirtualBala);
//添加付款表
resultPayment.PayEmpId = user.EmpId;
resultPayment.PayDept = apply.ApplyDept;
resultPayment.PayApplyId = payApply.PayApplyId;
resultPayment.PayBala = sumPayBala;
resultPayment.FundsBala = sumFundsBala;
resultPayment.VirtualBala = sumVirtualBala;
resultPayment.CurrencyId = payment.CurrencyId;
resultPayment.PayStyle = payment.PayStyle;
resultPayment.PayBankId = payment.PayBankId;
resultPayment.PayBankAccountId = payment.PayBankAccountId;
resultPayment.PayCorp = payment.PayCorp;
resultPayment.PayDatetime = payment.PayDatetime;
resultPayment.RecevableCorp = payment.RecevableCorp;
resultPayment.ReceBankId = payment.ReceBankId;
resultPayment.ReceBankAccountId = payment.ReceBankAccountId;
resultPayment.ReceBankAccount = payment.ReceBankAccount;
resultPayment.FlowName = payment.FlowName;
resultPayment.Memo = payment.Memo;
result = paymentDAL.Update(user, resultPayment);
if (result.ResultStatus != 0)
return result;
//添加付款发票明细表
foreach (PaymentInvioceDetail d in paymentInvoiceDetails)
{
if (d.PayBala > 0)
{
//获取发票付款申请
result = invoicePayApplyDAL.Get(user, d.PayApplyDetailId);
if (result.ResultStatus != 0)
return result;
Model.InvoicePayApply dp = result.ReturnValue as Model.InvoicePayApply;
if (dp == null || dp.RefId <= 0)
{
result.ResultStatus = -1;
result.Message = "对应付款申请获取失败";
return result;
}
d.DetailStatus = Common.StatusEnum.已生效;
d.PaymentId = resultPayment.PaymentId;
d.InvoiceId = dp.InvoiceId;
d.PayApplyId = dp.PayApplyId;
d.PayApplyDetailId = dp.RefId;
result = paymentInvoiceDetailDAL.Insert(user, d);
if (result.ResultStatus != 0)
return result;
}
}
//虚拟收付款
//获取虚拟收付款明细
DAL.PaymentVirtualDAL paymentVirtualDAL = new PaymentVirtualDAL();
result = paymentVirtualDAL.GetByPaymentId(user, payment.PaymentId);
if (result.ResultStatus != 0)
return result;
Model.PaymentVirtual paymentVirtual = result.ReturnValue as Model.PaymentVirtual;
if (paymentVirtual == null)
{
result.ResultStatus = -1;
result.Message = "获取虚拟收付款信息失败";
return result;
}
if (payment.VirtualBala == 0)
{
if (paymentVirtual.VirtualId > 0)
{
//作废原有虚拟收付款
result = paymentVirtualDAL.Invalid(user, paymentVirtual);
if (result.ResultStatus != 0)
return result;
}
}
else
{
if (payment.VirtualBala > payment.PayBala)
{
result.ResultStatus = -1;
result.Message = "虚拟付款金额不能大于付款总额";
return result;
}
if (paymentVirtual.VirtualId > 0)
{
//更新虚拟收付款
paymentVirtual.PayBala = payment.VirtualBala;
result = paymentVirtualDAL.Update(user, paymentVirtual);
if (result.ResultStatus != 0)
return result;
}
else
{
//新增虚拟收付款
paymentVirtual.PayApplyId = resultPayment.PayApplyId;
paymentVirtual.PayBala = payment.VirtualBala;
paymentVirtual.PaymentId = resultPayment.PaymentId;
paymentVirtual.DetailStatus = StatusEnum.已录入;
result = paymentVirtualDAL.Insert(user, paymentVirtual);
if (result.ResultStatus != 0)
return result;
}
}
scope.Complete();
}
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
}
return result;
}
public ResultModel PaymentInvoiceCreate(UserModel user, Model.Payment payment, List<Model.PaymentInvioceDetail> paymentInvoiceDetails, int payApplyId)
{
ResultModel result = new ResultModel();
try
{
DAL.PayApplyDAL payApplyDAL = new PayApplyDAL();
NFMT.Operate.DAL.ApplyDAL applyDAL = new NFMT.Operate.DAL.ApplyDAL();
DAL.InvoicePayApplyDAL invoicePayApplyDAL = new InvoicePayApplyDAL();
DAL.PaymentInvioceDetailDAL paymentInvoiceDetailDAL = new PaymentInvioceDetailDAL();
using (System.Transactions.TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
foreach (Model.PaymentInvioceDetail d in paymentInvoiceDetails)
{
d.PayBala = d.FundsBala + d.VirtualBala;
}
//验证付款总额是否等于财务付款金额+虚拟付款金额
if (payment.PayBala != payment.FundsBala + payment.VirtualBala)
{
result.ResultStatus = -1;
result.Message = "付款总额必须等于财务付款金额+虚拟付款金额";
return result;
}
//验证付款申请
result = payApplyDAL.Get(user, payApplyId);
if (result.ResultStatus != 0)
return result;
Model.PayApply payApply = result.ReturnValue as Model.PayApply;
if (payApply == null || payApply.PayApplyId <= 0)
{
result.ResultStatus = -1;
result.Message = "付款申请不存在";
return result;
}
//获取主申请
result = applyDAL.Get(user, payApply.ApplyId);
if (result.ResultStatus != 0)
return result;
NFMT.Operate.Model.Apply apply = result.ReturnValue as NFMT.Operate.Model.Apply;
if (apply == null || apply.ApplyId <= 0)
{
result.ResultStatus = -1;
result.Message = "付款主申请不存在";
return result;
}
//判断申请状态是否已生效
if (apply.ApplyStatus != NFMT.Common.StatusEnum.已生效)
{
result.ResultStatus = -1;
result.Message = "付款申请非已生效状态，不能进行付款";
return result;
}
//获取当前付款申请中的所有付款
result = paymentDAL.Load(user, payApply.PayApplyId);
if (result.ResultStatus != 0)
return result;
List<Model.Payment> payments = result.ReturnValue as List<Model.Payment>;
if (payments == null)
{
result.ResultStatus = -1;
result.Message = "获取当前付款申请的付款执行失败";
return result;
}
//判断付款申请可付余额
decimal payedBala = payments.Sum(temp => temp.PayBala);
if (payApply.ApplyBala - payedBala < 0)
{
result.ResultStatus = -1;
result.Message = "当前付款申请已无余款可付";
return result;
}
if (payApply.ApplyBala - payedBala - payment.PayBala < 0)
{
result.ResultStatus = -1;
result.Message = "当前付款金额大于可付余额";
return result;
}
//获取付款申请对应发票明细列表
result = invoicePayApplyDAL.Load(user, payApply.PayApplyId);
if (result.ResultStatus != 0)
return result;
List<Model.InvoicePayApply> invoicePayApplies = result.ReturnValue as List<Model.InvoicePayApply>;
if (invoicePayApplies == null)
{
result.ResultStatus = -1;
result.Message = "付款申请明细失败";
return result;
}
foreach (Model.PaymentInvioceDetail d in paymentInvoiceDetails)
{
if (d.PayBala > 0)
{
//获取当前发票付款明细列表
result = paymentInvoiceDetailDAL.LoadByInvoicePayApplyId(user, d.PayApplyDetailId);
if (result.ResultStatus != 0)
return result;
List<Model.PaymentInvioceDetail> details = result.ReturnValue as List<Model.PaymentInvioceDetail>;
decimal detailPayedBala = details.Sum(temp => temp.PayBala);
var ls = paymentInvoiceDetails.Where(temp => temp.PayApplyDetailId == d.PayApplyDetailId);
decimal detailPayingBala = ls.Sum(temp => temp.PayBala);
//获取对应的申请明细
result = invoicePayApplyDAL.Get(user, d.PayApplyDetailId);
if (result.ResultStatus != 0)
return result;
InvoicePayApply invoicePayApply = result.ReturnValue as InvoicePayApply;
if (invoicePayApply == null || invoicePayApply.RefId <= 0)
{
result.ResultStatus = -1;
result.Message = string.Format("发票申请明细获取失败");
return result;
}
if (invoicePayApply.ApplyBala - detailPayedBala - detailPayingBala < 0)
{
result.ResultStatus = -1;
result.Message = string.Format("发票申请明细付款超额");
return result;
}
}
}
decimal sumPayBala = paymentInvoiceDetails.Sum(temp => temp.PayBala);
decimal sumFundsBala = paymentInvoiceDetails.Sum(temp => temp.FundsBala);
decimal sumVirtualBala = paymentInvoiceDetails.Sum(temp => temp.VirtualBala);
//添加付款表
payment.PayEmpId = user.EmpId;
payment.PayDept = apply.ApplyDept;
payment.PayApplyId = payApply.PayApplyId;
payment.PayBala = sumPayBala;
payment.FundsBala = sumFundsBala;
payment.VirtualBala = sumVirtualBala;
payment.PaymentStatus = StatusEnum.已录入;
result = paymentDAL.Insert(user, payment);
if (result.ResultStatus != 0)
return result;
int paymentId = 0;
if (result.ReturnValue == null || !int.TryParse(result.ReturnValue.ToString(), out paymentId))
{
result.ResultStatus = -1;
result.Message = "付款新增失败";
return result;
}
payment.PaymentId = paymentId;
//添加付款发票明细表
foreach (PaymentInvioceDetail d in paymentInvoiceDetails)
{
if (d.PayBala > 0)
{
//获取发票付款申请
result = invoicePayApplyDAL.Get(user, d.PayApplyDetailId);
if (result.ResultStatus != 0)
return result;
Model.InvoicePayApply dp = result.ReturnValue as Model.InvoicePayApply;
if (dp == null || dp.RefId <= 0)
{
result.ResultStatus = -1;
result.Message = "对应付款申请获取失败";
return result;
}
d.DetailStatus = Common.StatusEnum.已生效;
d.PaymentId = paymentId;
d.InvoiceId = dp.InvoiceId;
d.PayApplyId = dp.PayApplyId;
d.PayApplyDetailId = dp.RefId;
result = paymentInvoiceDetailDAL.Insert(user, d);
if (result.ResultStatus != 0)
return result;
}
}
//添加虚拟收付款
if (payment.VirtualBala > 0)
{
if (payment.VirtualBala > payment.PayBala)
{
result.ResultStatus = -1;
result.Message = "虚拟付款金额不能大于付款总额";
return result;
}
DAL.PaymentVirtualDAL virtualDAL = new PaymentVirtualDAL();
Model.PaymentVirtual paymentVirtual = new PaymentVirtual();
paymentVirtual.PayApplyId = payApply.PayApplyId;
paymentVirtual.PayBala = payment.VirtualBala;
paymentVirtual.PaymentId = paymentId;
paymentVirtual.DetailStatus = StatusEnum.已录入;
result = virtualDAL.Insert(user, paymentVirtual);
if (result.ResultStatus != 0)
return result;
}
scope.Complete();
}
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
}
return result;
}