public ResultModel PaymentStockCreate(UserModel user, Model.Payment payment, List<Model.PaymentStockDetail> paymentStockDetails, int payApplyId)
{
ResultModel result = new ResultModel();
try
{
DAL.PayApplyDAL payApplyDAL = new PayApplyDAL();
NFMT.Operate.DAL.ApplyDAL applyDAL = new NFMT.Operate.DAL.ApplyDAL();
DAL.StockPayApplyDAL stockPayApplyDAL = new StockPayApplyDAL();
DAL.PaymentStockDetailDAL paymentStockDetailDAL = new PaymentStockDetailDAL();
using (System.Transactions.TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
//设置库存明细付款总额
foreach (Model.PaymentStockDetail d in paymentStockDetails)
{
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 = stockPayApplyDAL.Load(user, payApply.PayApplyId);
if (result.ResultStatus != 0)
return result;
List<Model.StockPayApply> stockPayApplies = result.ReturnValue as List<Model.StockPayApply>;
if (stockPayApplies == null)
{
result.ResultStatus = -1;
result.Message = "付款申请关联合约获取失败";
return result;
}
foreach (PaymentStockDetail d in paymentStockDetails)
{
if (d.PayBala > 0)
{
//获取当前库存付款明细列表
result = paymentStockDetailDAL.LoadByStockPayApplyId(user, d.PayApplyDetailId);
if (result.ResultStatus != 0)
return result;
List<Model.PaymentStockDetail> details = result.ReturnValue as List<Model.PaymentStockDetail>;
decimal detailPayedBala = details.Sum(temp => temp.PayBala);
var ls = paymentStockDetails.Where(temp => temp.PayApplyDetailId == d.PayApplyDetailId);
decimal detailPayingBala = ls.Sum(temp => temp.PayBala);
//获取对应的申请明细
result = stockPayApplyDAL.Get(user, d.PayApplyDetailId);
if (result.ResultStatus != 0)
return result;
StockPayApply stockPayApply = result.ReturnValue as StockPayApply;
if (stockPayApply == null || stockPayApply.RefId <= 0)
{
result.ResultStatus = -1;
result.Message = string.Format("库存明细获取失败");
return result;
}
if (stockPayApply.ApplyBala - detailPayedBala - detailPayingBala < 0)
{
result.ResultStatus = -1;
result.Message = string.Format("库存明细付款超额");
return result;
}
}
}
decimal sumFundsBala = paymentStockDetails.Sum(temp => temp.FundsBala);
decimal sumVirtualBala = paymentStockDetails.Sum(temp => temp.VirtualBala);
decimal sumPayBala = sumFundsBala + sumVirtualBala;
//添加付款表
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;
//添加付款合约明细表
Model.StockPayApply payApplyStock = stockPayApplies[0];
Model.PaymentContractDetail paymentContractDetail = new PaymentContractDetail();
paymentContractDetail.ContractId = payApplyStock.ContractId;
paymentContractDetail.ContractSubId = payApplyStock.SubId;
paymentContractDetail.PayApplyDetailId = payApplyStock.ContractRefId;
paymentContractDetail.PayApplyId = payApplyStock.PayApplyId;
paymentContractDetail.PayBala = sumPayBala;
paymentContractDetail.FundsBala = sumFundsBala;
paymentContractDetail.VirtualBala = sumVirtualBala;
paymentContractDetail.PaymentId = paymentId;
DAL.PaymentContractDetailDAL paymentContractDetailDAL = new PaymentContractDetailDAL();
result = paymentContractDetailDAL.Insert(user, paymentContractDetail);
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;
}
//添加付款库存明细表
foreach (PaymentStockDetail d in paymentStockDetails)
{
if (d.PayBala > 0)
{
//获取库存付款申请
result = stockPayApplyDAL.Get(user, d.PayApplyDetailId);
if (result.ResultStatus != 0)
return result;
Model.StockPayApply dp = result.ReturnValue as Model.StockPayApply;
if (dp == null || dp.RefId <= 0)
{
result.ResultStatus = -1;
result.Message = "对应付款申请获取失败";
return result;
}
d.DetailStatus = Common.StatusEnum.已生效;
d.PayApplyId = payApply.PayApplyId;
d.PaymentId = paymentId;
d.ContractDetailId = contractRefId;
d.ContractId = paymentContractDetail.ContractId;
d.SubId = paymentContractDetail.ContractSubId;
d.StockId = dp.StockId;
d.StockLogId = dp.StockLogId;
d.PayBala = d.FundsBala + d.VirtualBala;
result = paymentStockDetailDAL.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;
}
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 Invalid(UserModel user, int payApplyId)
{
ResultModel result = new ResultModel();
try
{
PayApplyDAL payApplyDAL = new PayApplyDAL();
ApplyDAL applyDAL = new ApplyDAL();
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
//验证付款申请
result = payApplyDAL.Get(user, payApplyId);
if (result.ResultStatus != 0)
return result;
PayApply payApply = result.ReturnValue as 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;
Apply apply = result.ReturnValue as Apply;
if (apply == null || apply.ApplyId <= 0)
{
result.ResultStatus = -1;
result.Message = "主申请不存在";
return result;
}
//作废主申请
result = applyDAL.Invalid(user, apply);
if (result.ResultStatus != 0)
return result;
//如果是库存付款申请，同时作废出库付款申请明细
if (payApply.PayApplySource == (int)FundsStyleEnum.StockPayApply)
{
StockPayApplyDAL stockPayApplyDAL = new StockPayApplyDAL();
result = stockPayApplyDAL.Load(user, payApply.PayApplyId);
if (result.ResultStatus != 0)
return result;
List<StockPayApply> stockPayApplies = result.ReturnValue as List<StockPayApply>;
if (stockPayApplies == null)
{
result.ResultStatus = -1;
result.Message = "库存付款明细获取错误";
return result;
}
foreach (StockPayApply stockPayApply in stockPayApplies)
{
//作废明细
if (stockPayApply.Status == StatusEnum.已生效)
stockPayApply.Status = StatusEnum.已录入;
result = stockPayApplyDAL.Invalid(user, stockPayApply);
if (result.ResultStatus != 0)
return result;
}
}
result.Message = "作废成功";
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 Goback(UserModel user, int paymentId)
{
ResultModel result = new ResultModel();
try
{
DAL.PayApplyDAL payApplyDAL = new PayApplyDAL();
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
//验证财务付款
result = paymentDAL.Get(user, paymentId);
if (result.ResultStatus != 0)
return result;
Model.Payment payment = result.ReturnValue as Payment;
if (payment == null || payment.PaymentId <= 0)
{
result.ResultStatus = -1;
result.Message = "财务付款不存在";
return result;
}
//更新财务付款状态至已撤返
result = paymentDAL.Goback(user, payment);
if (result.ResultStatus != 0)
return result;
//工作流任务关闭
WorkFlow.DAL.DataSourceDAL sourceDAL = new WorkFlow.DAL.DataSourceDAL();
result = sourceDAL.SynchronousStatus(user, payment);
if (result.ResultStatus != 0)
return result;
result.Message = "撤返成功";
scope.Complete();
}
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
}
return result;
}
public ResultModel PaymentVirtualConfirm(UserModel user, Model.PaymentVirtual paymentVirtual)
{
ResultModel result = new ResultModel();
try
{
DAL.PaymentDAL paymentDAL = new PaymentDAL();
using (System.Transactions.TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
//验证虚拟付款
result = paymentvirtualDAL.Get(user, paymentVirtual.VirtualId);
if (result.ResultStatus != 0)
return result;
Model.PaymentVirtual resultObj = result.ReturnValue as Model.PaymentVirtual;
if (resultObj == null || resultObj.VirtualId <= 0)
{
result.ResultStatus = -1;
result.Message = "虚拟付款不存在";
return result;
}
if (resultObj.DetailStatus != StatusEnum.已生效)
{
result.ResultStatus = -1;
result.Message = "虚拟付款状态不能进行确认";
return result;
}
//获取财务付款
result = paymentDAL.Get(user, resultObj.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;
}
//更新虚拟付款
resultObj.ConfirmMemo = paymentVirtual.ConfirmMemo;
resultObj.DetailStatus = StatusEnum.已完成;
result = paymentvirtualDAL.Update(user,resultObj);
if (result.ResultStatus != 0)
return result;
//获取对应的付款申请
DAL.PayApplyDAL payApplyDAL = new PayApplyDAL();
result = payApplyDAL.Get(user, resultObj.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.Data.DAL.BankDAL outBankDAL = new Data.DAL.BankDAL();
NFMT.User.DAL.BlocDAL blocDAL = new User.DAL.BlocDAL();
DAL.FundsLogDAL fundsLogDAL = new FundsLogDAL();
//写付款资金流水，状态为已完成
Model.FundsLog fundsLog = new FundsLog();
fundsLog.CurrencyId = payment.CurrencyId;
fundsLog.FundsBala = payment.FundsBala;
fundsLog.FundsDesc = payment.Memo;
fundsLog.InAccountId = payment.PayBankAccountId;
fundsLog.InBankId = payment.PayBankId;
fundsLog.InBlocId = user.BlocId;
fundsLog.InCorpId = payment.PayCorp;
fundsLog.IsVirtualPay = false;
fundsLog.LogDate = DateTime.Now;
fundsLog.LogDirection = (int)NFMT.WareHouse.LogDirectionEnum.Out;
fundsLog.LogSource = "dbo.Fun_PaymentVirtual";
fundsLog.LogSourceBase = "NFMT";
fundsLog.LogStatus = StatusEnum.已完成;
fundsLog.LogType = (int)NFMT.WareHouse.LogTypeEnum.付款;
fundsLog.OpPerson = user.EmpId;
fundsLog.OutAccount = payment.ReceBankAccount;
fundsLog.OutAccountId = payment.ReceBankAccountId;
result = outBankDAL.Get(user, payment.ReceBankId);
if (result.ResultStatus != 0)
return result;
NFMT.Data.Model.Bank outBank = result.ReturnValue as NFMT.Data.Model.Bank;
if (outBank == null || outBank.BankId <= 0)
{
result.ResultStatus = -1;
result.Message = "收款银行不存在";
return result;
}
fundsLog.OutBank = outBank.BankName;
fundsLog.OutBankId = payment.ReceBankId;
result = blocDAL.GetBlocByCorpId(user, payment.RecevableCorp);
if (result.ResultStatus == 0)
{
NFMT.User.Model.Bloc bloc = result.ReturnValue as NFMT.User.Model.Bloc;
if (bloc != null && bloc.BlocId > 0)
fundsLog.OutBlocId = bloc.BlocId;
}
fundsLog.OutCorpId = payment.RecevableCorp;
fundsLog.PayMode = payment.PayStyle;
fundsLog.SourceId = payment.PaymentId;
if (payApply.PayApplySource == (int)FundsStyleEnum.库存付款申请 || payApply.PayApplySource == (int)FundsStyleEnum.合约付款申请)
{
//加载合约明细
DAL.PaymentContractDetailDAL paymentContractDetailDAL = new PaymentContractDetailDAL();
result = paymentContractDetailDAL.GetByPaymentId(user, payment.PaymentId);
if (result.ResultStatus != 0)
return result;
Model.PaymentContractDetail paymentContractDetail = result.ReturnValue as Model.PaymentContractDetail;
if (paymentContractDetail == null || paymentContractDetail.DetailId <= 0)
{
result.ResultStatus = -1;
result.Message = "付款合约明细加载失败";
return result;
}
fundsLog.ContractId = paymentContractDetail.ContractId;
fundsLog.SubId = paymentContractDetail.ContractSubId;
}
result = fundsLogDAL.Insert(user, fundsLog);
if (result.ResultStatus != 0)
return result;
int fundsLogId = 0;
if (result.ReturnValue == null || !int.TryParse(result.ReturnValue.ToString(), out fundsLogId) || fundsLogId <= 0)
{
result.ResultStatus = -1;
result.Message = "付款流水新增失败";
return result;
}
//更新虚拟付款表的资金流水序号
resultObj.FundsLogId = fundsLogId;
resultObj.DetailStatus = StatusEnum.已完成;
result = this.paymentvirtualDAL.Update(user, resultObj);
if (result.ResultStatus != 0)
return result;
//反向分配一收款至对应公司
scope.Complete();
}
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
}
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 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 PayApplyInvoiceUpdate(UserModel user, Apply apply, PayApply payApply, List<InvoicePayApply> details)
{
ResultModel result = new ResultModel();
try
{
InvoicePayApplyDAL invoicePayApplyDAL = new InvoicePayApplyDAL();
ApplyDAL applyDAL = new ApplyDAL();
PayApplyDAL payApplyDAL = new PayApplyDAL();
InvoiceDAL invoiceDAL = new InvoiceDAL();
SIDAL sIDAL = new SIDAL();
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
if (details == null || details.Count == 0)
{
result.ResultStatus = -1;
result.Message = "未选中任务发票";
return result;
}
//验证总额
decimal sumApplyBala = details.Sum(temp => temp.ApplyBala);
if (sumApplyBala != payApply.ApplyBala)
{
result.ResultStatus = -1;
result.Message = "申请总额与分项总额不相等";
return result;
}
//获取付款申请
result = this.payapplyDAL.Get(user, payApply.PayApplyId);
if (result.ResultStatus != 0)
return result;
PayApply resultPayApply = result.ReturnValue as PayApply;
if (resultPayApply == null || resultPayApply.PayApplyId <= 0)
{
result.ResultStatus = -1;
result.Message = "付款申请不存在";
return result;
}
//获取发票申请列表
result = invoicePayApplyDAL.Load(user, resultPayApply.PayApplyId);
if (result.ResultStatus != 0)
return result;
List<InvoicePayApply> resultDetails = result.ReturnValue as List<InvoicePayApply>;
if (resultDetails == null)
{
result.ResultStatus = -1;
result.Message = "付款申请发票明细列表获取失败";
return result;
}
//作废原有发票申请明细
foreach (InvoicePayApply detail in resultDetails)
{
detail.DetailStatus = StatusEnum.已录入;
result = invoicePayApplyDAL.Invalid(user, detail);
if (result.ResultStatus != 0)
return result;
}
//验证发票
int payDept = 0;
int outCorpId = 0;
foreach (InvoicePayApply detail in details)
{
//获取价外票
result = sIDAL.Get(user, detail.SIId);
if (result.ResultStatus != 0)
return result;
SI sI = result.ReturnValue as SI;
if (sI == null || sI.SIId <= 0)
{
result.ResultStatus = -1;
result.Message = "价外票不存在";
return result;
}
//获取发票
result = invoiceDAL.Get(user, detail.InvoiceId);
if (result.ResultStatus != 0)
return result;
Operate.Model.Invoice invoice = result.ReturnValue as Operate.Model.Invoice;
if (invoice == null || invoice.InvoiceId <= 0)
{
result.ResultStatus = -1;
result.Message = "发票不存在";
return result;
}
//验证币种
if (payApply.CurrencyId != invoice.CurrencyId)
{
result.ResultStatus = -1;
result.Message = "发票币种不一致";
return result;
}
//验证开票抬头
if (outCorpId == 0) { outCorpId = invoice.OutCorpId; }
if (outCorpId != invoice.OutCorpId)
{
result.ResultStatus = -1;
result.Message = "发票开票公司不一致";
return result;
}
//验证成本部门
if (payDept == 0) { payDept = sI.PayDept; }
if (payDept != sI.PayDept)
{
result.ResultStatus = -1;
result.Message = "发票成本部门不一致";
return result;
}
//验证可申请余额
result = invoicePayApplyDAL.LoadByInvoice(user, detail.InvoiceId);
if (result.ResultStatus != 0)
return result;
resultDetails = result.ReturnValue as List<InvoicePayApply>;
if (resultDetails == null)
{
result.ResultStatus = -1;
result.Message = "获取发票已申请列表失败";
return result;
}
decimal applyBala = resultDetails.Sum(temp => temp.ApplyBala);
if (applyBala >= invoice.InvoiceBala)
{
result.ResultStatus = -1;
result.Message = string.Format("发票{0}款项已全部申请", invoice.InvoiceNo);
return result;
}
if (invoice.InvoiceBala - applyBala < detail.ApplyBala)
{
result.ResultStatus = -1;
result.Message = string.Format("发票{0}申请金额超过可申请余额，申请失败", invoice.InvoiceNo);
return result;
}
}
//更新申请主表
Department dept = UserProvider.Departments.FirstOrDefault(temp => temp.DeptId == apply.ApplyDept);
if (dept == null || dept.DeptId < 0)
{
result.ResultStatus = -1;
result.Message = "申请部门不存在";
return result;
}
//获取主申请
result = applyDAL.Get(user, resultPayApply.ApplyId);
if (result.ResultStatus != 0)
return result;
Apply resultApply = result.ReturnValue as Apply;
if (resultApply == null || resultApply.ApplyId <= 0)
{
result.ResultStatus = -1;
result.Message = "主申请获取失败";
return result;
}
resultApply.ApplyDept = dept.DeptId;
resultApply.ApplyCorp = apply.ApplyCorp;
resultApply.ApplyDesc = apply.ApplyDesc;
resultApply.ApplyTime = apply.ApplyTime;
resultApply.EmpId = user.EmpId;
result = applyDAL.Update(user, resultApply);
if (result.ResultStatus != 0)
return result;
//更新付款申请表
resultPayApply.RecCorpId = payApply.RecCorpId;
resultPayApply.RecBankId = payApply.RecBankId;
resultPayApply.RecBankAccountId = payApply.RecBankAccountId;
resultPayApply.RecBankAccount = payApply.RecBankAccount;
resultPayApply.CurrencyId = payApply.CurrencyId;
resultPayApply.ApplyBala = sumApplyBala;
resultPayApply.PayMode = payApply.PayMode;
resultPayApply.PayDeadline = payApply.PayDeadline;
resultPayApply.PayMatter = payApply.PayMatter;
resultPayApply.SpecialDesc = payApply.SpecialDesc;
result = payapplyDAL.Update(user, resultPayApply);
if (result.ResultStatus != 0)
return result;
//新增发票付款申请关联表
foreach (InvoicePayApply detail in details)
{
detail.DetailStatus = StatusEnum.已生效;
detail.PayApplyId = resultPayApply.PayApplyId;
result = invoicePayApplyDAL.Insert(user, detail);
if (result.ResultStatus != 0)
return result;
}
scope.Complete();
}
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
}
return result;
}
public ResultModel Confirm(UserModel user, int payApplyId)
{
ResultModel result = new ResultModel();
try
{
PayApplyDAL payApplyDAL = new PayApplyDAL();
ApplyDAL applyDAL = new ApplyDAL();
PaymentDAL paymentDAL = new PaymentDAL();
StockPayApplyDAL payApplyStockDAL = new StockPayApplyDAL();
ContractPayApplyDAL payApplyContractDAL = new ContractPayApplyDAL();
PaymentStockDetailDAL paymentStockDetailDAL = new PaymentStockDetailDAL();
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
//验证付款申请
result = payApplyDAL.Get(user, payApplyId);
if (result.ResultStatus != 0)
return result;
PayApply payApply = result.ReturnValue as 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;
Apply apply = result.ReturnValue as Apply;
if (apply == null || apply.ApplyId <= 0)
{
result.ResultStatus = -1;
result.Message = "主申请不存在";
return result;
}
//验证当前付款申请下是否有已录入至已生效状态下的关联付款
//如果存在，则不能进行执行完成确认
result = paymentDAL.GetCountByPayApplyId(user, payApply.PayApplyId);
if (result.ResultStatus != 0)
return result;
if (result == null || result.AffectCount > 0)
{
result.ResultStatus = -1;
result.Message = "付款申请存在未完成的关联付款，不能进行执行完成确认";
return result;
}
//验证当前付款申请的申请金额与已执行完成的关联付款的付款金额是否相等
//如果不相等则不能进行执行完成确认
result = paymentDAL.Load(user, payApply.PayApplyId);
if (result.ResultStatus != 0)
return result;
List<Payment> payments = result.ReturnValue as List<Payment>;
if (payments == null)
{
result.ResultStatus = -1;
result.Message = "获取关联付款失败";
return result;
}
decimal sumPayBala = payments.Sum(temp => temp.PayBala);
if (sumPayBala != payApply.ApplyBala)
{
result.ResultStatus = -1;
result.Message = "付款申请金额与付款执行金额不相等，不能进行付款申请执行完成确认";
return result;
}
//验证库存付款申请明细的申请金额与付款执行的付款金额是否相等
//如果不相等则不能进行执行完成确认
if (payApply.PayApplySource == (int)FundsStyleEnum.ContractPayApply)
{
//获取付款申请下合约申请明细
result = payApplyContractDAL.GetByPayApplyId(user, payApply.PayApplyId);
if (result.ResultStatus != 0)
return result;
ContractPayApply payApplyContract = result.ReturnValue as ContractPayApply;
if (payApplyContract == null || payApplyContract.RefId <= 0)
{
result.ResultStatus = -1;
result.Message = "获取明细失败";
return result;
}
//完成明细
//result = payApplyContractDAL.Confirm(user, payApplyContract);
//if (result.ResultStatus != 0)
// return result;
}
else if (payApply.PayApplySource == (int)FundsStyleEnum.StockPayApply)
{
//获取付款申请下库存申请明细
result = payApplyStockDAL.Load(user, payApply.PayApplyId);
if (result.ResultStatus != 0)
return result;
List<StockPayApply> payApplyStocks = result.ReturnValue as List<StockPayApply>;
if (payApplyStocks == null)
{
result.ResultStatus = -1;
result.Message = "获取付款申请库存明细失败";
return result;
}
foreach (StockPayApply payApplyStock in payApplyStocks)
{
//获取付款申请库存明细关联的付款库存明细
result = paymentStockDetailDAL.LoadByStockPayApplyId(user, payApplyStock.RefId);
if (result.ResultStatus != 0)
return result;
List<PaymentStockDetail> details = result.ReturnValue as List<PaymentStockDetail>;
decimal sumStockPayBala = details.Sum(temp => temp.PayBala);
if (sumStockPayBala != payApplyStock.ApplyBala)
{
result.ResultStatus = -1;
result.Message = "付款申请存在未付完的金额，不能进行执行确认完成";
return result;
}
//明细完成
result = payApplyStockDAL.Confirm(user, payApplyStock);
if (result.ResultStatus != 0)
return result;
}
}
//付款申请完成确认
//因付款执行不进行部分关闭，因此不存在部分完成状态
result = applyDAL.Confirm(user, apply);
if (result.ResultStatus != 0)
return result;
scope.Complete();
}
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
}
return result;
}
public ResultModel PayApplyInvoiceCreate(UserModel user, Apply apply, PayApply payApply, List<InvoicePayApply> details)
{
ResultModel result = new ResultModel();
try
{
InvoicePayApplyDAL invoicePayApplyDAL = new InvoicePayApplyDAL();
ApplyDAL applyDAL = new ApplyDAL();
PayApplyDAL payApplyDAL = new PayApplyDAL();
InvoiceDAL invoiceDAL = new InvoiceDAL();
SIDAL sIDAL = new SIDAL();
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
if (details == null || details.Count == 0)
{
result.ResultStatus = -1;
result.Message = "未选中任务发票";
return result;
}
//验证总额
decimal sumApplyBala = details.Sum(temp => temp.ApplyBala);
if (sumApplyBala != payApply.ApplyBala)
{
result.ResultStatus = -1;
result.Message = "申请总额与分项总额不相等";
return result;
}
//验证发票
int payDept = 0;
int outCorpId = 0;
foreach (InvoicePayApply detail in details)
{
//获取价外票
result = sIDAL.Get(user, detail.SIId);
if (result.ResultStatus != 0)
return result;
SI sI = result.ReturnValue as SI;
if (sI == null || sI.SIId <= 0)
{
result.ResultStatus = -1;
result.Message = "价外票不存在";
return result;
}
//获取发票
result = invoiceDAL.Get(user, detail.InvoiceId);
if (result.ResultStatus != 0)
return result;
Operate.Model.Invoice invoice = result.ReturnValue as Operate.Model.Invoice;
if (invoice == null || invoice.InvoiceId <= 0)
{
result.ResultStatus = -1;
result.Message = "发票不存在";
return result;
}
//验证币种
if (payApply.CurrencyId != invoice.CurrencyId)
{
result.ResultStatus = -1;
result.Message = "发票币种不一致";
return result;
}
//验证开票抬头
if (outCorpId == 0) { outCorpId = invoice.OutCorpId; }
if (outCorpId != invoice.OutCorpId)
{
result.ResultStatus = -1;
result.Message = "发票开票公司不一致";
return result;
}
//验证成本部门
if (payDept == 0) { payDept = sI.PayDept; }
if (payDept != sI.PayDept)
{
result.ResultStatus = -1;
result.Message = "发票成本部门不一致";
return result;
}
//验证可申请余额
result = invoicePayApplyDAL.LoadByInvoice(user, detail.InvoiceId);
if (result.ResultStatus != 0)
return result;
List<InvoicePayApply> resultDetails = result.ReturnValue as List<InvoicePayApply>;
if (resultDetails == null)
{
result.ResultStatus = -1;
result.Message = "获取发票已申请列表失败";
return result;
}
decimal applyBala = resultDetails.Sum(temp => temp.ApplyBala);
if (applyBala >= invoice.InvoiceBala)
{
result.ResultStatus = -1;
result.Message = string.Format("发票{0}款项已全部申请", invoice.InvoiceNo);
return result;
}
if (invoice.InvoiceBala - applyBala < detail.ApplyBala)
{
result.ResultStatus = -1;
result.Message = string.Format("发票{0}申请金额超过可申请余额，申请失败", invoice.InvoiceNo);
return result;
}
}
//新增申请主表
Department dept = UserProvider.Departments.FirstOrDefault(temp => temp.DeptId == apply.ApplyDept);
if (dept == null || dept.DeptId < 0)
{
result.ResultStatus = -1;
result.Message = "申请部门不存在";
return result;
}
int applyId = 0;
apply.ApplyDept = dept.DeptId;
apply.ApplyType = ApplyType.付款申请;
apply.EmpId = user.EmpId;
apply.ApplyStatus = StatusEnum.已录入;
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;
}
//新增付款申请表
payApply.ApplyId = applyId;
payApply.PayApplySource = (int)FundsStyleEnum.InvoicePayApply;
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;
}
//新增发票付款申请关联表
foreach (InvoicePayApply detail in details)
{
detail.DetailStatus = StatusEnum.已生效;
detail.PayApplyId = payApplyId;
result = invoicePayApplyDAL.Insert(user, detail);
if (result.ResultStatus != 0)
return result;
}
scope.Complete();
}
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
}
return result;
}
public ResultModel PayApplyContractUpdate(UserModel user, PayApply payApply, string memo, int deptId, int corpId)
{
ResultModel result = new ResultModel();
try
{
ContractSubDAL subDAL = new ContractSubDAL();
ApplyDAL applyDAL = new ApplyDAL();
PayApplyDAL payApplyDAL = new PayApplyDAL();
ContractPayApplyDAL contractPayApplyDAL = new ContractPayApplyDAL();
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
//验证付款申请
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 = contractPayApplyDAL.GetByPayApplyId(user, resultObj.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;
}
//验证子合约信息
result = subDAL.Get(user, contractPayApply.ContractSubId);
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;
}
//验证可申请金额
//NFMT.Data.Model.FuturesPrice futuresPrice = NFMT.Data.BasicDataProvider.FuturesPrices[0];
//更新申请主表
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.PayApplySource = (int)FundsStyleEnum.ContractPayApply;
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;
//更新Fun_ContractPayApply_Ref合约付款申请
contractPayApply.ApplyBala = payApply.ApplyBala;
result = contractPayApplyDAL.Update(user, contractPayApply);
if (result.ResultStatus != 0)
return result;
scope.Complete();
}
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
}
return result;
}
public ResultModel PayApplyContractCreate(UserModel user, PayApply payApply, int subId, string memo, int deptId, int corpId)
{
ResultModel result = new ResultModel();
try
{
ContractSubDAL subDAL = new ContractSubDAL();
ApplyDAL applyDAL = new ApplyDAL();
PayApplyDAL payApplyDAL = new PayApplyDAL();
ContractPayApplyDAL contractPayApplyDAL = new ContractPayApplyDAL();
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
//验证子合约信息
result = subDAL.Get(user, subId);
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;
}
//验证可申请金额
//NFMT.Data.Model.FuturesPrice futuresPrice = NFMT.Data.BasicDataProvider.FuturesPrices[0];
//新增申请主表
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;
}
//新增付款申请表
payApply.ApplyId = applyId;
payApply.PayApplySource = (int)FundsStyleEnum.ContractPayApply;
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;
}
//新增Fun_ContractPayApply_Ref合约付款申请
ContractPayApply contractPayApply = new ContractPayApply();
contractPayApply.ContractId = sub.ContractId;
contractPayApply.ContractSubId = sub.SubId;
contractPayApply.PayApplyId = payApplyId;
contractPayApply.ApplyBala = payApply.ApplyBala;
result = contractPayApplyDAL.Insert(user, contractPayApply);
if (result.ResultStatus != 0)
return result;
scope.Complete();
}
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
}
return result;
}
public ResultModel PaymentStockUpdate(UserModel user, Model.Payment payment, List<Model.PaymentStockDetail> paymentStockDetails)
{
ResultModel result = new ResultModel();
try
{
DAL.PayApplyDAL payApplyDAL = new PayApplyDAL();
NFMT.Operate.DAL.ApplyDAL applyDAL = new NFMT.Operate.DAL.ApplyDAL();
DAL.StockPayApplyDAL stockPayApplyDAL = new StockPayApplyDAL();
DAL.PaymentStockDetailDAL paymentStockDetailDAL = new PaymentStockDetailDAL();
DAL.PaymentContractDetailDAL paymentContractDetailDAL = new PaymentContractDetailDAL();
DAL.ContractPayApplyDAL payApplyContractDAL = new ContractPayApplyDAL();
NFMT.WareHouse.DAL.StockLogDAL stockLogDAL = new WareHouse.DAL.StockLogDAL();
using (System.Transactions.TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
//设置库存明细付款总额
foreach (Model.PaymentStockDetail d in paymentStockDetails)
{
d.PayBala = d.FundsBala + d.VirtualBala;
}
//验证付款总额是否等于财务付款金额+虚拟付款金额
if (payment.PayBala != payment.FundsBala + payment.VirtualBala)
{
result.ResultStatus = -1;
result.Message = "付款总额必须等于财务付款金额+虚拟付款金额";
return result;
}
//验证财务付款
result = paymentDAL.Get(user, payment.PaymentId);
if (result.ResultStatus != 0)
return result;
Model.Payment resultObj = result.ReturnValue as Model.Payment;
if (resultObj == null || resultObj.PaymentId <= 0)
{
result.ResultStatus = -1;
result.Message = "财务付款不存在，不能进行修改";
return result;
}
//验证付款申请
result = payApplyDAL.Get(user, resultObj.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 - payment.PayBala + resultObj.PayBala < 0)
{
result.ResultStatus = -1;
result.Message = "当前付款金额大于可付余额";
return result;
}
//获取付款申请对应库存明细列表
result = stockPayApplyDAL.Load(user, payApply.PayApplyId);
if (result.ResultStatus != 0)
return result;
List<Model.StockPayApply> stockPayApplies = result.ReturnValue as List<Model.StockPayApply>;
if (stockPayApplies == null)
{
result.ResultStatus = -1;
result.Message = "付款申请关联合约获取失败";
return result;
}
//修改付款表
resultObj.PayBala = payment.PayBala;
resultObj.FundsBala = payment.FundsBala;
resultObj.VirtualBala = payment.VirtualBala;
resultObj.PayStyle = payment.PayStyle;
resultObj.PayBankId = payment.PayBankId;
resultObj.PayBankAccountId = payment.PayBankAccountId;
resultObj.PayCorp = payment.PayCorp;
resultObj.PayDatetime = payment.PayDatetime;
resultObj.RecevableCorp = payment.RecevableCorp;
resultObj.ReceBankId = payment.ReceBankId;
resultObj.ReceBankAccountId = payment.ReceBankAccountId;
resultObj.ReceBankAccount = payment.ReceBankAccount;
resultObj.FlowName = payment.FlowName;
resultObj.Memo = payment.Memo;
result = paymentDAL.Update(user, resultObj);
if (result.ResultStatus != 0)
return result;
//获取付款库存明细列表
result = paymentStockDetailDAL.LoadByPaymentId(user, payment.PaymentId);
if (result.ResultStatus != 0)
return result;
List<Model.PaymentStockDetail> resultDetails = result.ReturnValue as List<PaymentStockDetail>;
if (resultDetails == null)
{
result.ResultStatus = -1;
result.Message = "财务付款库存明细信息获取失败";
return result;
}
//作废现有库存明细
foreach (Model.PaymentStockDetail detail in resultDetails)
{
if (detail.DetailStatus == StatusEnum.已生效)
detail.DetailStatus = StatusEnum.已录入;
result = paymentStockDetailDAL.Invalid(user, detail);
if (result.ResultStatus != 0)
return result;
}
//获取执行对应合约明细
result = paymentContractDetailDAL.GetByPaymentId(user, payment.PaymentId);
if (result.ResultStatus != 0)
return result;
Model.PaymentContractDetail paymentContractDetail = result.ReturnValue as Model.PaymentContractDetail;
if (paymentContractDetail == null || paymentContractDetail.DetailId <= 0)
{
result.ResultStatus = -1;
result.Message = "获取对应合约明细失败";
return result;
}
//更新合约明细
paymentContractDetail.PayBala = resultObj.PayBala;
paymentContractDetail.FundsBala = resultObj.FundsBala;
paymentContractDetail.VirtualBala = resultObj.VirtualBala;
result = paymentContractDetailDAL.Update(user, paymentContractDetail);
if (result.ResultStatus != 0)
return result;
//新增付款执行库存明细
foreach (PaymentStockDetail d in paymentStockDetails)
{
if (d.PayBala > 0)
{
//获取当前库存申请付款明细列表
result = paymentStockDetailDAL.LoadByStockPayApplyId(user, d.PayApplyDetailId);
if (result.ResultStatus != 0)
return result;
List<Model.PaymentStockDetail> details = result.ReturnValue as List<Model.PaymentStockDetail>;
decimal detailPayedBala = details.Sum(temp => temp.PayBala);
var ls = paymentStockDetails.Where(temp => temp.PayApplyDetailId == d.PayApplyDetailId);
decimal detailPayingBala = ls.Sum(temp => temp.PayBala);
//获取对应的申请明细
result = stockPayApplyDAL.Get(user, d.PayApplyDetailId);
if (result.ResultStatus != 0)
return result;
StockPayApply stockPayApply = result.ReturnValue as StockPayApply;
if (stockPayApply == null || stockPayApply.RefId <= 0)
{
result.ResultStatus = -1;
result.Message = string.Format("库存明细获取失败");
return result;
}
//验证明细付款是否超额
if (stockPayApply.ApplyBala - detailPayedBala - detailPayingBala < 0)
{
result.ResultStatus = -1;
result.Message = string.Format("库存明细付款超额");
return result;
}
//新增明细
d.DetailStatus = StatusEnum.已生效;
d.PayApplyId = resultObj.PayApplyId;
d.PaymentId = resultObj.PaymentId;
d.ContractDetailId = paymentContractDetail.DetailId;
d.ContractId = paymentContractDetail.ContractId;
d.PayApplyDetailId = stockPayApply.RefId;
d.SubId = paymentContractDetail.ContractSubId;
result = paymentStockDetailDAL.Insert(user, d);
if (result.ResultStatus != 0)
return result;
}
}
//虚拟收付款
//获取虚拟收付款明细
DAL.PaymentVirtualDAL paymentVirtualDAL = new PaymentVirtualDAL();
result = paymentVirtualDAL.GetByPaymentId(user, payment.PaymentId);
if (result.ResultStatus == 0)
{
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 = resultObj.PayApplyId;
paymentVirtual.PayBala = payment.VirtualBala;
paymentVirtual.PaymentId = resultObj.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 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 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 payApplyId)
{
ResultModel result = new ResultModel();
try
{
PayApplyDAL payApplyDAL = new PayApplyDAL();
ApplyDAL applyDAL = new ApplyDAL();
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
//验证付款申请
result = payApplyDAL.Get(user, payApplyId);
if (result.ResultStatus != 0)
return result;
PayApply payApply = result.ReturnValue as 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;
Apply apply = result.ReturnValue as Apply;
if (apply == null || apply.ApplyId <= 0)
{
result.ResultStatus = -1;
result.Message = "主申请不存在";
return result;
}
//关闭主申请
result = applyDAL.Close(user, apply);
if (result.ResultStatus != 0)
return result;
//关闭明细申请
if (payApply.PayApplySource == (int)FundsStyleEnum.ContractPayApply)
{
//获取付款申请下合约申请明细
ContractPayApplyDAL payApplyContractDAL = new ContractPayApplyDAL();
result = payApplyContractDAL.GetByPayApplyId(user, payApply.PayApplyId);
if (result.ResultStatus != 0)
return result;
ContractPayApply payApplyContract = result.ReturnValue as ContractPayApply;
if (payApplyContract == null || payApplyContract.RefId <= 0)
{
result.ResultStatus = -1;
result.Message = "获取明细失败";
return result;
}
//完成撤销明细
result = payApplyContractDAL.Close(user, payApplyContract);
if (result.ResultStatus != 0)
return result;
}
else if (payApply.PayApplySource == (int)FundsStyleEnum.StockPayApply)
{
//获取付款申请下库存申请明细
StockPayApplyDAL payApplyStockDAL = new StockPayApplyDAL();
result = payApplyStockDAL.Load(user, payApply.PayApplyId);
if (result.ResultStatus != 0)
return result;
List<StockPayApply> payApplyStocks = result.ReturnValue as List<StockPayApply>;
if (payApplyStocks == null)
{
result.ResultStatus = -1;
result.Message = "获取付款申请库存明细失败";
return result;
}
foreach (StockPayApply payApplyStock in payApplyStocks)
{
//明细完成撤销
result = payApplyStockDAL.Close(user, payApplyStock);
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.PayApplyDAL payApplyDAL = new PayApplyDAL();
NFMT.User.DAL.BlocDAL blocDAL = new User.DAL.BlocDAL();
DAL.FundsLogDAL fundsLogDAL = new FundsLogDAL();
NFMT.Data.DAL.BankDAL outBankDAL = new Data.DAL.BankDAL();
DAL.PaymentVirtualDAL paymentVirtualDAL = new PaymentVirtualDAL();
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
result = this.paymentDAL.Get(NFMT.Common.DefaultValue.SysUser, dataSource.RowId);
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;
}
//审核，修改数据状态
result = this.paymentDAL.Audit(user, payment, isPass);
if (result.ResultStatus != 0)
return result;
//获取虚拟付款
result = paymentVirtualDAL.GetByPaymentId(user, payment.PaymentId, StatusEnum.已录入);
if (result.ResultStatus == 0)
{
Model.PaymentVirtual paymentVirtual = result.ReturnValue as Model.PaymentVirtual;
if (paymentVirtual != null && paymentVirtual.VirtualId > 0)
{
//审核虚拟付款
result = paymentVirtualDAL.Audit(user, paymentVirtual, isPass);
if (result.ResultStatus != 0)
return result;
}
}
//审核通过
if (isPass)
{
//获取对方的付款申请
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;
}
// 流水操作：写入 流水类型：付款 流水状态：已生效 【仅写入实际付款】
Model.FundsLog fundsLog = new FundsLog();
fundsLog.CurrencyId = payment.CurrencyId;
fundsLog.FundsBala = payment.FundsBala;
fundsLog.FundsDesc = payment.Memo;
fundsLog.InAccountId = payment.PayBankAccountId;
fundsLog.InBankId = payment.PayBankId;
fundsLog.InBlocId = user.BlocId;
fundsLog.InCorpId = payment.PayCorp;
fundsLog.IsVirtualPay = false;
fundsLog.LogDate = DateTime.Now;
fundsLog.LogDirection = (int)NFMT.WareHouse.LogDirectionEnum.Out;
fundsLog.LogSource = "dbo.Fun_Payment";
fundsLog.LogSourceBase = "NFMT";
fundsLog.LogStatus = StatusEnum.已生效;
fundsLog.LogType = (int)NFMT.WareHouse.LogTypeEnum.付款;
fundsLog.OpPerson = user.EmpId;
fundsLog.OutAccount = payment.ReceBankAccount;
fundsLog.OutAccountId = payment.ReceBankAccountId;
result = outBankDAL.Get(user, payment.ReceBankId);
if (result.ResultStatus != 0)
return result;
NFMT.Data.Model.Bank outBank = result.ReturnValue as NFMT.Data.Model.Bank;
if (outBank == null || outBank.BankId <= 0)
{
result.ResultStatus = -1;
result.Message = "收款银行不存在";
return result;
}
fundsLog.OutBank = outBank.BankName;
fundsLog.OutBankId = payment.ReceBankId;
result = blocDAL.GetBlocByCorpId(user, payment.RecevableCorp);
if (result.ResultStatus == 0)
{
NFMT.User.Model.Bloc bloc = result.ReturnValue as NFMT.User.Model.Bloc;
if (bloc != null && bloc.BlocId > 0)
fundsLog.OutBlocId = bloc.BlocId;
}
fundsLog.OutCorpId = payment.RecevableCorp;
fundsLog.PayMode = payment.PayStyle;
fundsLog.SourceId = payment.PaymentId;
if (payApply.PayApplySource == (int)FundsStyleEnum.库存付款申请 || payApply.PayApplySource == (int)FundsStyleEnum.合约付款申请)
{
//加载合约明细
DAL.PaymentContractDetailDAL paymentContractDetailDAL = new PaymentContractDetailDAL();
result = paymentContractDetailDAL.GetByPaymentId(user, payment.PaymentId);
if (result.ResultStatus != 0)
return result;
Model.PaymentContractDetail paymentContractDetail = result.ReturnValue as Model.PaymentContractDetail;
if (paymentContractDetail == null || paymentContractDetail.DetailId <= 0)
{
result.ResultStatus = -1;
result.Message = "付款合约明细加载失败";
return result;
}
fundsLog.ContractId = paymentContractDetail.ContractId;
fundsLog.SubId = paymentContractDetail.ContractSubId;
}
result = fundsLogDAL.Insert(user, fundsLog);
if (result.ResultStatus != 0)
return result;
int fundsLogId = 0;
if (result.ReturnValue == null || !int.TryParse(result.ReturnValue.ToString(), out fundsLogId) || fundsLogId <= 0)
{
result.ResultStatus = -1;
result.Message = "付款流水新增失败";
return result;
}
//更新付款表的资金流水序号
payment.FundsLogId = fundsLogId;
payment.PaymentStatus = StatusEnum.已生效;
result = this.paymentDAL.Update(user, payment);
if (result.ResultStatus != 0)
return result;
}
scope.Complete();
}
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
return result;
}
return result;
}
public ResultModel PaymentContractCreate(UserModel user, Model.Payment payment)
{
ResultModel result = new ResultModel();
try
{
DAL.PayApplyDAL payApplyDAL = new PayApplyDAL();
NFMT.Operate.DAL.ApplyDAL applyDAL = new NFMT.Operate.DAL.ApplyDAL();
DAL.ContractPayApplyDAL contractPayApplyDAL = new ContractPayApplyDAL();
DAL.PaymentContractDetailDAL paymentContractDetailDAL = new PaymentContractDetailDAL();
using (System.Transactions.TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
//验证付款总额是否等于财务付款金额+虚拟付款金额
if (payment.PayBala != payment.FundsBala + payment.VirtualBala)
{
result.ResultStatus = -1;
result.Message = "付款总额必须等于财务付款金额+虚拟付款金额";
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;
}
//获取主申请
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 = contractPayApplyDAL.GetByPayApplyId(user, payApply.PayApplyId);
if (result.ResultStatus != 0)
return result;
Model.ContractPayApply contractPayApply = result.ReturnValue as Model.ContractPayApply;
if (contractPayApply == null || contractPayApply.RefId <= 0)
{
result.ResultStatus = -1;
result.Message = "付款申请关联合约获取失败";
return result;
}
//添加付款表
payment.PayEmpId = user.EmpId;
payment.PayDept = apply.ApplyDept;
payment.PayApplyId = payApply.PayApplyId;
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;
//添加付款合约明细表
Model.PaymentContractDetail paymentContractDetail = new PaymentContractDetail();
paymentContractDetail.ContractId = contractPayApply.ContractId;
paymentContractDetail.ContractSubId = contractPayApply.ContractSubId;
paymentContractDetail.PayApplyDetailId = contractPayApply.RefId;
paymentContractDetail.PaymentId = paymentId;
paymentContractDetail.PayApplyId = payApply.PayApplyId;
paymentContractDetail.PayBala = payment.PayBala;
paymentContractDetail.FundsBala = payment.FundsBala;
paymentContractDetail.VirtualBala = payment.VirtualBala;
result = paymentContractDetailDAL.Insert(user, paymentContractDetail);
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;
}
if (result.ResultStatus == 0)
result.ReturnValue = paymentId;
scope.Complete();
}
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
}
return result;
}
public ResultModel Invalid(UserModel user, int paymentId)
{
ResultModel result = new ResultModel();
try
{
DAL.PayApplyDAL payApplyDAL = new PayApplyDAL();
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
//验证财务付款
result = paymentDAL.Get(user, 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;
}
//获取财务付款对应付款申请
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;
}
//作废财务付款
result = paymentDAL.Invalid(user, payment);
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 (paymentVirtual.VirtualId > 0 && paymentVirtual.PayBala > 0)
{
if (paymentVirtual.DetailStatus == StatusEnum.已生效 || paymentVirtual.DetailStatus == StatusEnum.待审核)
paymentVirtual.DetailStatus = StatusEnum.已录入;
result = paymentVirtualDAL.Invalid(user, paymentVirtual);
if (result.ResultStatus != 0)
return result;
}
if (payApply.PayApplySource == (int)Funds.FundsStyleEnum.ContractPayApply)
{
//财务付款--关联合约
//获取财务付款关联的合约明细，并作废
DAL.PaymentContractDetailDAL paymentContractDetailDAL = new PaymentContractDetailDAL();
result = paymentContractDetailDAL.GetByPaymentId(user, payment.PaymentId);
if (result.ResultStatus != 0)
return result;
Model.PaymentContractDetail paymentContractDetail = result.ReturnValue as Model.PaymentContractDetail;
if (paymentContractDetail == null || paymentContractDetail.DetailId <= 0)
{
result.ResultStatus = -1;
result.Message = "财务付款对应的明细获取失败";
return result;
}
result = paymentContractDetailDAL.Invalid(user, paymentContractDetail);
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)
{
//作废明细
if (detail.Status == StatusEnum.已生效)
detail.Status = StatusEnum.已录入;
result = paymentStockDetailDAL.Invalid(user, detail);
if (result.ResultStatus != 0)
return result;
}
}
result.Message = "作废成功";
scope.Complete();
}
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
}
return result;
}
public ResultModel PaymentContractUpdate(UserModel user, Model.Payment payment)
{
ResultModel result = new ResultModel();
try
{
DAL.PayApplyDAL payApplyDAL = new PayApplyDAL();
NFMT.Operate.DAL.ApplyDAL applyDAL = new NFMT.Operate.DAL.ApplyDAL();
DAL.ContractPayApplyDAL contractPayApplyDAL = new ContractPayApplyDAL();
DAL.PaymentContractDetailDAL paymentContractDetailDAL = new PaymentContractDetailDAL();
using (System.Transactions.TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
//验证付款总额是否等于财务付款金额+虚拟付款金额
if (payment.PayBala != payment.FundsBala + payment.VirtualBala)
{
result.ResultStatus = -1;
result.Message = "付款总额必须等于财务付款金额+虚拟付款金额";
return result;
}
//验证财务付款
result = paymentDAL.Get(user, payment.PaymentId);
if (result.ResultStatus != 0)
return result;
Model.Payment resultObj = result.ReturnValue as Model.Payment;
if (resultObj == null || resultObj.PaymentId <= 0)
{
result.ResultStatus = -1;
result.Message = "财务付款不存在，不能进行修改";
return result;
}
//验证付款申请
result = payApplyDAL.Get(user, resultObj.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 - payment.PayBala + resultObj.PayBala < 0)
{
result.ResultStatus = -1;
result.Message = "当前付款金额大于可付余额";
return result;
}
//获取付款申请对应合约明细表
result = contractPayApplyDAL.GetByPayApplyId(user, payApply.PayApplyId);
if (result.ResultStatus != 0)
return result;
Model.ContractPayApply contractPayApply = result.ReturnValue as Model.ContractPayApply;
if (contractPayApply == null || contractPayApply.RefId <= 0)
{
result.ResultStatus = -1;
result.Message = "付款申请关联合约获取失败";
return result;
}
//修改付款表
resultObj.PayBala = payment.PayBala;
resultObj.FundsBala = payment.FundsBala;
resultObj.VirtualBala = payment.VirtualBala;
resultObj.PayStyle = payment.PayStyle;
resultObj.PayBankId = payment.PayBankId;
resultObj.PayBankAccountId = payment.PayBankAccountId;
resultObj.PayCorp = payment.PayCorp;
resultObj.PayDatetime = payment.PayDatetime;
resultObj.RecevableCorp = payment.RecevableCorp;
resultObj.ReceBankId = payment.ReceBankId;
resultObj.ReceBankAccountId = payment.ReceBankAccountId;
resultObj.ReceBankAccount = payment.ReceBankAccount;
resultObj.FlowName = payment.FlowName;
resultObj.Memo = payment.Memo;
result = paymentDAL.Update(user, resultObj);
if (result.ResultStatus != 0)
return result;
//获取付款合约明细
result = paymentContractDetailDAL.GetByPaymentId(user, payment.PaymentId);
if (result.ResultStatus != 0)
return result;
Model.PaymentContractDetail resultDetail = result.ReturnValue as PaymentContractDetail;
if (resultDetail == null || resultDetail.DetailId <= 0)
{
result.ResultStatus = -1;
result.Message = "财务付款合约明细信息获取失败";
return result;
}
//修改付款合约明细
resultDetail.PaymentId = payment.PaymentId;
resultDetail.PayBala = payment.PayBala;
resultDetail.VirtualBala = payment.VirtualBala;
resultDetail.FundsBala = payment.FundsBala;
result = paymentContractDetailDAL.Update(user, resultDetail);
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 = resultObj.PayApplyId;
paymentVirtual.PayBala = payment.VirtualBala;
paymentVirtual.PaymentId = resultObj.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 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 Goback(UserModel user, int payApplyId)
{
ResultModel result = new ResultModel();
try
{
PayApplyDAL payApplyDAL = new PayApplyDAL();
ApplyDAL applyDAL = new ApplyDAL();
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
//验证付款申请
result = payApplyDAL.Get(user, payApplyId);
if (result.ResultStatus != 0)
return result;
PayApply payApply = result.ReturnValue as 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;
Apply apply = result.ReturnValue as Apply;
if (apply == null || apply.ApplyId <= 0)
{
result.ResultStatus = -1;
result.Message = "主申请不存在";
return result;
}
//主申请状态修改至已撤返
result = applyDAL.Goback(user, apply);
if (result.ResultStatus != 0)
return result;
//工作流任务关闭
DataSourceDAL sourceDAL = new DataSourceDAL();
result = sourceDAL.SynchronousStatus(user, apply);
if (result.ResultStatus != 0)
return result;
result.Message = "撤返成功";
scope.Complete();
}
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
}
return result;
}
