コード例 #1
0
ファイル: PaymentVirtualBLL.cs プロジェクト: weiliji/NFMT
        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;
        }
コード例 #2
0
ファイル: PaymentBLL.cs プロジェクト: weiliji/NFMT
        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;
        }
コード例 #3
0
ファイル: PaymentVirtualBLL.cs プロジェクト: weiliji/NFMT
        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;
        }
コード例 #4
0
ファイル: PaymentBLL.cs プロジェクト: weiliji/NFMT
        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;
        }
コード例 #5
0
ファイル: PaymentBLL.cs プロジェクト: weiliji/NFMT
        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;
        }
コード例 #6
0
ファイル: PaymentBLL.cs プロジェクト: weiliji/NFMT
        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;
        }
コード例 #7
0
ファイル: PaymentBLL.cs プロジェクト: weiliji/NFMT
        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;
        }
コード例 #8
0
ファイル: PaymentBLL.cs プロジェクト: weiliji/NFMT
        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;
        }