public ResultModel GetLastNetWeightBySubId(UserModel user, int subId) { //获取库存流水净重 NFMT.WareHouse.DAL.StockLogDAL stockLogDAL = new WareHouse.DAL.StockLogDAL(); ResultModel result = stockLogDAL.LoadStockLogBySubId(user, subId); if (result.ResultStatus != 0) return result; List<NFMT.WareHouse.Model.StockLog> stockLogs = result.ReturnValue as List<NFMT.WareHouse.Model.StockLog>; decimal netWeight = stockLogs.Sum(temp => temp.NetAmount + temp.GapAmount); //获取当前子合约下利息结算 result = this.LoadInterestListBySubId(user, subId); if (result.ResultStatus != 0) return result; List<Model.Interest> interests = result.ReturnValue as List<Model.Interest>; decimal interestAmount = interests.Sum(temp => temp.InterestAmount); result.ResultStatus = 0; result.ReturnValue = netWeight - interestAmount; return result; }
public ResultModel CreateStock(UserModel user, Model.CashInAllot allot, List<Model.CashInStcok> details, int stockLogId) { ResultModel result = new ResultModel(); try { NFMT.Contract.DAL.ContractCorporationDetailDAL corpDetailDAL = new Contract.DAL.ContractCorporationDetailDAL(); NFMT.Contract.DAL.ContractSubDAL subDAL = new Contract.DAL.ContractSubDAL(); DAL.CashInContractDAL cashInContractDAL = new CashInContractDAL(); DAL.CashInCorpDAL cashInCorpDAL = new CashInCorpDAL(); DAL.CashInDAL cashInDAL = new CashInDAL(); NFMT.WareHouse.DAL.StockLogDAL stockLogDAL = new WareHouse.DAL.StockLogDAL(); NFMT.WareHouse.DAL.StockDAL stockDAL = new WareHouse.DAL.StockDAL(); using (System.Transactions.TransactionScope scope = new TransactionScope()) { //获取库存流水 result = stockLogDAL.Get(user, stockLogId); if (result.ResultStatus != 0) return result; NFMT.WareHouse.Model.StockLog stockLog = result.ReturnValue as NFMT.WareHouse.Model.StockLog; if (stockLog == null || stockLog.StockLogId <= 0) { result.ResultStatus = -1; result.Message = "库存流水不存在"; return result; } //获取库存 result = stockDAL.Get(user, stockLog.StockId); if (result.ResultStatus != 0) return result; NFMT.WareHouse.Model.Stock stock = result.ReturnValue as NFMT.WareHouse.Model.Stock; if (stock == null || stock.StockId <= 0) { result.Message = "库存不存在"; result.ResultStatus = -1; return result; } //获取合约 result = subDAL.Get(user, stockLog.SubContractId); if (result.ResultStatus != 0) return result; NFMT.Contract.Model.ContractSub sub = result.ReturnValue as NFMT.Contract.Model.ContractSub; if (sub == null || sub.SubId <= 0) { result.ResultStatus = -1; result.Message = "合约不存在"; return result; } if (sub.SubStatus != StatusEnum.已生效) { result.ResultStatus = -1; result.Message = "合约状态不允许分配收款"; return result; } //获取外部公司 result = corpDetailDAL.LoadCorpListByContractId(user, sub.ContractId, false); if (result.ResultStatus != 0) return result; List<NFMT.Contract.Model.ContractCorporationDetail> outCorps = result.ReturnValue as List<NFMT.Contract.Model.ContractCorporationDetail>; if (outCorps == null) { result.Message = "合约对方抬头获取失败"; result.ResultStatus = -1; return result; } foreach (Model.CashInStcok detail in details) { //收款登记验证 result = cashInDAL.Get(user, detail.CashInId); if (result.ResultStatus != 0) return result; Model.CashIn cashIn = result.ReturnValue as Model.CashIn; if (cashIn == null || cashIn.CashInId <= 0) { result.Message = "收款登记不存在"; result.ResultStatus = -1; return result; } //收款登记与合约币种验证 if (cashIn.CurrencyId != sub.SettleCurrency) { result.Message = "收款登记币种与合约币种不相同"; result.ResultStatus = -1; return result; } //获取合约收款分配 result = cashInContractDAL.Get(user, detail.ContractRefId); if (result.ResultStatus != 0) return result; Model.CashInContract cashInContract = result.ReturnValue as Model.CashInContract; if (cashInContract == null || cashInContract.RefId <= 0) { result.Message = "收款分配失败"; result.ResultStatus = -1; return result; } if (cashInContract.DetailStatus != StatusEnum.已生效) { result.Message = "收款分配失败"; result.ResultStatus = -1; return result; } //获取公司收款分配 result = cashInCorpDAL.Get(user, cashInContract.CorpRefId); if (result.ResultStatus != 0) return result; Model.CashInCorp cashInCorp = result.ReturnValue as Model.CashInCorp; if (cashInCorp == null || cashInCorp.RefId <= 0 || cashInCorp.DetailStatus != StatusEnum.已生效) { result.Message = "收款分配失败"; result.ResultStatus = -1; return result; } //验证公司抬头 if (!outCorps.Any(temp => temp.CorpId == cashInCorp.CorpId)) { result.Message = "收款分配公司不在合约对方抬头,收款分配失败"; result.ResultStatus = -1; return result; } //新增库存收款分配 detail.AllotId = cashInContract.AllotId; detail.CashInId = cashInContract.CashInId; detail.ContractRefId = cashInContract.RefId; detail.CorpRefId = cashInContract.CorpRefId; detail.DetailStatus = StatusEnum.已生效; detail.StockId = stock.StockId; detail.StockLogId = stockLog.StockLogId; detail.StockNameId = stock.StockNameId; result = this.cashinstcokDAL.Insert(user, detail); if (result.ResultStatus != 0) return result; } scope.Complete(); } } catch (Exception ex) { result.Message = ex.Message; result.ResultStatus = -1; } return result; }
public ResultModel CreateDirectStock(UserModel user, Model.CashInAllot allot, List<Model.CashInCorp> details, int stockLogId) { ResultModel result = new ResultModel(); try { NFMT.WareHouse.DAL.StockLogDAL stockLogDAL = new WareHouse.DAL.StockLogDAL(); NFMT.WareHouse.DAL.StockDAL stockDAL = new WareHouse.DAL.StockDAL(); NFMT.Contract.DAL.ContractSubDAL subDAL = new Contract.DAL.ContractSubDAL(); DAL.CashInAllotDAL allotDAL = new CashInAllotDAL(); DAL.CashInDAL cashInDAL = new CashInDAL(); DAL.CashInCorpDAL cashInCorpDAL = new CashInCorpDAL(); DAL.CashInContractDAL cashInContractDAL = new CashInContractDAL(); using (System.Transactions.TransactionScope scope = new TransactionScope()) { //获取库存流水 result = stockLogDAL.Get(user, stockLogId); if (result.ResultStatus != 0) return result; NFMT.WareHouse.Model.StockLog stockLog = result.ReturnValue as NFMT.WareHouse.Model.StockLog; if (stockLog == null || stockLog.StockLogId <= 0) { result.Message = "库存流水不存在"; result.ResultStatus = -1; return result; } //获取库存 result = stockDAL.Get(user, stockLog.StockId); if (result.ResultStatus != 0) return result; NFMT.WareHouse.Model.Stock stock = result.ReturnValue as NFMT.WareHouse.Model.Stock; if (stock == null || stock.StockId <= 0) { result.Message = "库存不存在"; result.ResultStatus = -1; return result; } //获取子合约 result = subDAL.Get(user, stockLog.SubContractId); if (result.ResultStatus != 0) return result; NFMT.Contract.Model.ContractSub sub = result.ReturnValue as NFMT.Contract.Model.ContractSub; if (sub == null || sub.SubId <= 0) { result.Message = "子合约不存在"; result.ResultStatus = -1; return result; } allot.AllotBala = details.Sum(temp => temp.AllotBala); allot.Alloter = user.EmpId; allot.AllotStatus = StatusEnum.已录入; allot.AllotTime = DateTime.Now; allot.AllotType = (int)NFMT.Funds.CashInAllotTypeEnum.Stock; allot.CurrencyId = sub.SettleCurrency; result = allotDAL.Insert(user, allot); if (result.ResultStatus != 0) return result; int allotId = 0; if (result.ReturnValue == null || !int.TryParse(result.ReturnValue.ToString(), out allotId) || allotId <= 0) { result.Message = "收款分配新增失败"; result.ResultStatus = -1; return result; } //获取外部公司 NFMT.Contract.DAL.ContractCorporationDetailDAL corpDAL = new Contract.DAL.ContractCorporationDetailDAL(); result = corpDAL.LoadCorpListByContractId(user, sub.ContractId, false); if (result.ResultStatus != 0) return result; List<NFMT.Contract.Model.ContractCorporationDetail> outCorps = result.ReturnValue as List<NFMT.Contract.Model.ContractCorporationDetail>; if (outCorps == null) { result.Message = "合约对方抬头获取失败"; result.ResultStatus = -1; return result; } foreach (Model.CashInCorp corpDetail in details) { NFMT.User.Model.Corporation corp = NFMT.User.UserProvider.Corporations.FirstOrDefault(temp => temp.CorpId == corpDetail.CorpId); if (corp == null || corp.CorpId <= 0) { result.Message = "收款分配公司不存在"; result.ResultStatus = -1; return result; } if (!outCorps.Any(temp => temp.CorpId == corp.CorpId)) { result.Message = "收款分配公司不在合约对方抬头,收款分配失败"; result.ResultStatus = -1; return result; } result = cashInDAL.Get(user, corpDetail.CashInId); if (result.ResultStatus != 0) return result; Model.CashIn cashIn = result.ReturnValue as Model.CashIn; if (cashIn == null || cashIn.CashInId <= 0) { result.Message = "收款登记不存在"; result.ResultStatus = -1; return result; } if (cashIn.CurrencyId != sub.SettleCurrency) { result.Message = "收款登记币种与合约币种不相同"; result.ResultStatus = -1; return result; } corpDetail.AllotId = allotId; corpDetail.BlocId = corp.ParentId; corpDetail.CashInId = cashIn.CashInId; corpDetail.CorpId = corp.CorpId; corpDetail.DetailStatus = StatusEnum.已生效; corpDetail.IsShare = false; result = cashInCorpDAL.Insert(user, corpDetail); if (result.ResultStatus != 0) return result; int corpRefId = 0; if (result.ReturnValue == null || !int.TryParse(result.ReturnValue.ToString(), out corpRefId) || corpRefId <= 0) { result.Message = "收款分配新增失败"; result.ResultStatus = -1; return result; } Model.CashInContract cashInContract = new CashInContract(); cashInContract.AllotBala = corpDetail.AllotBala; cashInContract.AllotId = corpDetail.AllotId; cashInContract.CashInId = corpDetail.CashInId; cashInContract.ContractId = sub.ContractId; cashInContract.CorpRefId = corpRefId; cashInContract.DetailStatus = StatusEnum.已生效; cashInContract.SubContractId = sub.SubId; result = cashInContractDAL.Insert(user, cashInContract); if (result.ResultStatus != 0) return result; int contractRefId = 0; if (result.ReturnValue == null || !int.TryParse(result.ReturnValue.ToString(), out contractRefId) || contractRefId <= 0) { result.Message = "收款分配新增失败"; result.ResultStatus = -1; return result; } Model.CashInStcok cashInStock = new CashInStcok(); cashInStock.AllotBala = cashInContract.AllotBala; cashInStock.AllotId = cashInContract.AllotId; cashInStock.CashInId = cashInContract.CashInId; cashInStock.ContractRefId = contractRefId; cashInStock.CorpRefId = cashInContract.CorpRefId; cashInStock.DetailStatus = StatusEnum.已生效; cashInStock.StockId = stockLog.StockId; cashInStock.StockLogId = stockLog.StockLogId; cashInStock.StockNameId = stockLog.StockNameId; result = this.cashinstcokDAL.Insert(user, cashInStock); 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 Create(UserModel user, CashInAllot allot, List<CashInContractDirect> directs, int subId) { ResultModel result = new ResultModel(); try { NFMT.Contract.DAL.ContractSubDAL subDAL = new Contract.DAL.ContractSubDAL(); NFMT.WareHouse.DAL.StockLogDAL stockLogDAL = new WareHouse.DAL.StockLogDAL(); DAL.CashInDAL cashInDAL = new CashInDAL(); DAL.CashInAllotDAL cashInAllotDAL = new CashInAllotDAL(); DAL.CashInCorpDAL cashInCorpDAL = new CashInCorpDAL(); DAL.CashInContractDAL cashInContractDAL = new CashInContractDAL(); DAL.CashInStcokDAL cashInStockDAL = new CashInStcokDAL(); using (System.Transactions.TransactionScope scope = new TransactionScope()) { if (directs == null || directs.Count == 0) { result.ResultStatus = -1; result.Message = "未分配任务收款"; return result; } //获取子合约 result = subDAL.Get(user, subId); if (result.ResultStatus != 0) return result; NFMT.Contract.Model.ContractSub sub = result.ReturnValue as NFMT.Contract.Model.ContractSub; if (sub == null || sub.SubId <= 0) { result.ResultStatus = -1; result.Message = "子合约不存在,不能进行收款分配"; return result; } //判断合约状态 if (sub.SubStatus != StatusEnum.已生效) { result.ResultStatus = -1; result.Message = "子合约非已生效状态,不能进行收款分配"; return result; } //获取合约对方抬头 result = subDAL.GetContractOutCorp(user, sub.SubId); if (result.ResultStatus != 0) return result; DataTable outCorpTable = result.ReturnValue as DataTable; if (outCorpTable == null || outCorpTable.Rows.Count == 0) { result.ResultStatus = -1; result.Message = "合约对方抬头不存在,收款分配失败"; return result; } List<int> outCorpIds = new List<int>(); foreach (DataRow dr in outCorpTable.Rows) { int outCorpId = 0; if (dr["CorpId"] == DBNull.Value || !int.TryParse(dr["CorpId"].ToString(), out outCorpId) || outCorpId <= 0) { result.ResultStatus = -1; result.Message = "合约对方抬头获取失败"; return result; } outCorpIds.Add(outCorpId); } //获取合约关联库存信息 result = stockLogDAL.LoadStockLogBySubId(user, sub.SubId); if (result.ResultStatus != 0) return result; List<NFMT.WareHouse.Model.StockLog> stockLogs = result.ReturnValue as List<NFMT.WareHouse.Model.StockLog>; if (stockLogs == null) { result.ResultStatus = -1; result.Message = "合约库存流水获取失败"; return result; } decimal sumBala = directs.Sum(temp => temp.AllotBala); allot.AllotBala = sumBala; allot.Alloter = user.EmpId; allot.AllotStatus = StatusEnum.已录入; allot.AllotTime = DateTime.Now; allot.AllotType = (int)NFMT.Funds.CashInAllotTypeEnum.Contract; allot.CurrencyId = sub.SettleCurrency; //新增主分配 result = cashInAllotDAL.Insert(user, allot); if (result.ResultStatus != 0) return result; int allotId = 0; if (result.ReturnValue == null || !int.TryParse(result.ReturnValue.ToString(), out allotId) || allotId <= 0) { result.ResultStatus = -1; result.Message = "收款分配新增失败"; return result; } foreach (CashInContractDirect direct in directs) { //判断收款分配到的对方抬头是否包含在合约抬头中 if (!outCorpIds.Contains(direct.AllotCorpId)) { result.ResultStatus = -1; result.Message = "收款分配选择的分配公司不在该合约对方抬头中,收款分配失败"; return result; } //判断收款登记的币种是否和合约币种相同 result = cashInDAL.Get(user, direct.CashInId); if (result.ResultStatus != 0) return result; Model.CashIn cashIn = result.ReturnValue as Model.CashIn; if (cashIn == null || cashIn.CashInId <= 0) { result.ResultStatus = -1; result.Message = "收款登记不存在"; return result; } if (cashIn.CashInStatus != StatusEnum.已生效) { result.ResultStatus = -1; result.Message = "收款登记状态错误,不能进行分配"; return result; } if (cashIn.CurrencyId != sub.SettleCurrency) { result.ResultStatus = -1; result.Message = "收款登记币种与合约币种不相同,分配错误"; return result; } CashInCorp cashCorp = new CashInCorp(); NFMT.User.Model.Corporation corp = NFMT.User.UserProvider.Corporations.FirstOrDefault(temp => temp.CorpId == direct.AllotCorpId); if (corp == null || corp.CorpId <= 0) { result.ResultStatus = -1; result.Message = "收款分配选择的分配公司不存在,分配失败"; return result; } //新增公司分配 cashCorp.AllotBala = direct.AllotBala; cashCorp.BlocId = corp.ParentId; cashCorp.CashInId = direct.CashInId; cashCorp.CorpId = corp.CorpId; cashCorp.DetailStatus = StatusEnum.已生效; cashCorp.IsShare = false; cashCorp.AllotId = allotId; result = cashInCorpDAL.Insert(user, cashCorp); if (result.ResultStatus != 0) return result; int corpRefId = 0; if (result.ReturnValue == null || !int.TryParse(result.ReturnValue.ToString(), out corpRefId) || corpRefId <= 0) { result.ResultStatus = -1; result.Message = "公司收款分配新增失败"; return result; } //新增合约分配 CashInContract cashContract = new CashInContract(); cashContract.AllotBala = cashCorp.AllotBala; cashContract.AllotId = cashCorp.AllotId; cashContract.CashInId = cashCorp.CashInId; cashContract.ContractId = sub.ContractId; cashContract.CorpRefId = corpRefId; cashContract.DetailStatus = StatusEnum.已生效; cashContract.SubContractId = sub.SubId; result = this.cashincontractDAL.Insert(user, cashContract); 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; } //新增库存分配 if (direct.StockLogId > 0) { result = stockLogDAL.Get(user, direct.StockLogId); if (result.ResultStatus != 0) return result; NFMT.WareHouse.Model.StockLog stockLog = result.ReturnValue as NFMT.WareHouse.Model.StockLog; if (stockLog == null || stockLog.StockLogId <= 0) { result.ResultStatus = -1; result.Message = "库存流水不存在"; return result; } if (stockLog.SubContractId != sub.SubId) { result.ResultStatus = -1; result.Message = "库存流水与合约不匹配"; return result; } Model.CashInStcok cashInStock = new CashInStcok(); cashInStock.AllotBala = cashContract.AllotBala; cashInStock.AllotId = cashContract.AllotId; cashInStock.CashInId = cashContract.CashInId; cashInStock.ContractRefId = contractRefId; cashInStock.CorpRefId = cashContract.CorpRefId; cashInStock.DetailStatus = StatusEnum.已生效; cashInStock.StockLogId = stockLog.StockLogId; cashInStock.StockId = stockLog.StockId; cashInStock.StockNameId = stockLog.StockNameId; result = cashInStockDAL.Insert(user, cashInStock); if (result.ResultStatus != 0) return result; } } scope.Complete(); } } catch (Exception ex) { result.ResultStatus = -1; result.Message = ex.Message; } return result; }
public ResultModel ReceivableStockUpdateHandle(UserModel user, List<Model.CorpReceivable> corpReceivables, int curId, string memo, int allotId,int stockId, int stockNameId,int allotFrom) { ResultModel result = new ResultModel(); DAL.ReceivableDAL receivableDAL = new ReceivableDAL(); DAL.CorpReceivableDAL corpReceivableDAL = new CorpReceivableDAL(); DAL.ContractReceivableDAL contractReceivableDAL = new ContractReceivableDAL(); DAL.StcokReceivableDAL stcokReceivableDAL = new StcokReceivableDAL(); NFMT.User.DAL.CorporationDAL corporationDAL = new User.DAL.CorporationDAL(); NFMT.WareHouse.DAL.StockLogDAL stockLogDAL=new WareHouse.DAL.StockLogDAL(); Model.Receivable receivable = new Receivable(); try { using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required)) { decimal allotBala = 0; foreach (Model.CorpReceivable corpReceivable in corpReceivables) { //allotBala += corpReceivable.AllotBala; } result = receivableallotDAL.Get(user, allotId); if (result.ResultStatus != 0) return result; Model.ReceivableAllot receivableAllot = result.ReturnValue as Model.ReceivableAllot; receivableAllot.AllotDesc = memo; receivableAllot.AllotBala = allotBala; receivableAllot.CurrencyId = curId; receivableAllot.AllotFrom = allotFrom; //更新收款分配表 result = receivableallotDAL.Update(user, receivableAllot); if (result.ResultStatus != 0) return result; //作废公司收款分配 result = corpReceivableDAL.InvalidAll(user, allotId); if (result.ResultStatus != 0) return result; //作废合约收款分配 result = contractReceivableDAL.InvalidAll(user, allotId); if (result.ResultStatus != 0) return result; //作废库存收款分配 result = stcokReceivableDAL.InvalidAll(user, allotId); if (result.ResultStatus != 0) return result; //获取合约Id result = stockLogDAL.GetStockContractId(user, stockId); if (result.ResultStatus != 0) return result; string contractStr = result.ReturnValue.ToString(); foreach (Model.CorpReceivable corpReceivable in corpReceivables) { result = corporationDAL.Get(user, corpReceivable.CorpId); if (result.ResultStatus != 0) return result; User.Model.Corporation corp = result.ReturnValue as User.Model.Corporation; corpReceivable.BlocId = corp.ParentId; //写入公司收款分配 result = corpReceivableDAL.Insert(user, corpReceivable); if (result.ResultStatus != 0) return result; int corpRefId = (int)result.ReturnValue; Model.ContractReceivable contractReceivable = new ContractReceivable() { CorpRefId = corpRefId, AllotId = allotId, RecId = corpReceivable.RecId, ContractId = Convert.ToInt32(contractStr.Split(',')[0]), SubContractId = Convert.ToInt32(contractStr.Split(',')[1]), //AllotBala = corpReceivable.AllotBala }; //写入合约收款分配 result = contractReceivableDAL.Insert(user, contractReceivable); if (result.ResultStatus != 0) return result; int contractRefId = (int)result.ReturnValue; Model.StcokReceivable stcokReceivable = new StcokReceivable() { AllotId = allotId, CorpRefId = corpRefId, ContractRefId = contractRefId, RecId = corpReceivable.RecId, StockId = stockId, StockNameId = stockNameId, //AllotBala = corpReceivable.AllotBala }; //写入库存收款分配 result = stcokReceivableDAL.Insert(user, stcokReceivable); if (result.ResultStatus != 0) return result; } scope.Complete(); } } catch (Exception ex) { result.ResultStatus = -1; result.Message = ex.Message; } finally { if (result.ResultStatus != 0) this.Log.ErrorFormat("{0} {1},序号:{2}", user.EmpName, result.Message, result.ReturnValue); else if (this.Log.IsInfoEnabled) this.Log.InfoFormat("{0} {1},序号:{2}", user.EmpName, result.Message, result.ReturnValue); } return result; }
public ResultModel ReceivableStockUpdateForContractHandle(UserModel user, List<Model.StcokReceivable> stcokReceivables, int curId, string memo, int allotId, int allotFrom) { ResultModel result = new ResultModel(); DAL.ReceivableDAL receivableDAL = new ReceivableDAL(); DAL.CorpReceivableDAL corpReceivableDAL = new CorpReceivableDAL(); DAL.ContractReceivableDAL contractReceivableDAL = new ContractReceivableDAL(); DAL.StcokReceivableDAL stcokReceivableDAL = new StcokReceivableDAL(); NFMT.User.DAL.CorporationDAL corporationDAL = new User.DAL.CorporationDAL(); NFMT.WareHouse.DAL.StockLogDAL stockLogDAL = new WareHouse.DAL.StockLogDAL(); Model.Receivable receivable = new Receivable(); try { using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required)) { decimal allotBala = 0; foreach (Model.StcokReceivable stcokReceivable in stcokReceivables) { //allotBala += stcokReceivable.AllotBala; } result = receivableallotDAL.Get(user, allotId); if (result.ResultStatus != 0) return result; Model.ReceivableAllot receivableAllot = result.ReturnValue as Model.ReceivableAllot; receivableAllot.AllotDesc = memo; receivableAllot.AllotBala = allotBala; receivableAllot.CurrencyId = curId; receivableAllot.AllotFrom = allotFrom; //更新收款分配表 result = receivableallotDAL.Update(user, receivableAllot); if (result.ResultStatus != 0) return result; ////作废公司收款分配 //result = corpReceivableDAL.InvalidAll(user, allotId); //if (result.ResultStatus != 0) // return result; ////作废合约收款分配 //result = contractReceivableDAL.InvalidAll(user, allotId); //if (result.ResultStatus != 0) // return result; //作废库存收款分配 result = stcokReceivableDAL.InvalidAll(user, allotId); if (result.ResultStatus != 0) return result; foreach (Model.StcokReceivable stcokReceivable in stcokReceivables) { result = contractReceivableDAL.Get(user, stcokReceivable.ContractRefId); if (result.ResultStatus != 0) return result; Model.ContractReceivable contractReceivable = result.ReturnValue as Model.ContractReceivable; stcokReceivable.CorpRefId = contractReceivable.CorpRefId; stcokReceivable.RecId = contractReceivable.RecId; //写入库存收款分配 result = stcokReceivableDAL.Insert(user, stcokReceivable); if (result.ResultStatus != 0) return result; } scope.Complete(); } } catch (Exception ex) { result.ResultStatus = -1; result.Message = ex.Message; } finally { if (result.ResultStatus != 0) this.Log.ErrorFormat("{0} {1},序号:{2}", user.EmpName, result.Message, result.ReturnValue); else if (this.Log.IsInfoEnabled) this.Log.InfoFormat("{0} {1},序号:{2}", user.EmpName, result.Message, result.ReturnValue); } return result; }