public ResultModel Audit(UserModel user, NFMT.WorkFlow.Model.DataSource dataSource, bool isPass) { ResultModel result = new ResultModel(); try { DAL.CashInAllotDAL cashInAllotDAL = new CashInAllotDAL(); DAL.CashInDAL cashInDAL = new CashInDAL(); Model.CashIn cashIn = null; DAL.FundsLogDAL fundsLogDAL = new FundsLogDAL(); DAL.CashInContractDAL cashInContractDAL = new CashInContractDAL(); using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required)) { result = cashInAllotDAL.Get(user, dataSource.RowId); if (result.ResultStatus != 0) return result; Model.CashInAllot cashInAllot = result.ReturnValue as Model.CashInAllot; if (cashInAllot == null || cashInAllot.AllotId <= 0) { result.ResultStatus = -1; result.Message = "收款分配不存在"; return result; } //审核,修改数据状态 result = cashInAllotDAL.Audit(user, cashInAllot, isPass); if (result.ResultStatus != 0) return result; //审核通过 if (isPass) { result = this.cashinstcokDAL.LoadByAllot(user, cashInAllot.AllotId, NFMT.Common.StatusEnum.已生效); if (result.ResultStatus != 0) return result; List<Model.CashInStcok> cashInStcoks = result.ReturnValue as List<Model.CashInStcok>; if (cashInStcoks == null || !cashInStcoks.Any()) { result.ResultStatus = -1; result.Message = "获取明细失败"; return result; } foreach (Model.CashInStcok cashInStcok in cashInStcoks) { result = cashInDAL.Get(user, cashInStcok.CashInId); if (result.ResultStatus != 0) return result; cashIn = result.ReturnValue as Model.CashIn; if (cashIn == null) { result.ResultStatus = -1; result.Message = "获取收款失败"; return result; } result = cashInContractDAL.Get(user, cashInStcok.ContractRefId); if (result.ResultStatus != 0) return result; Model.CashInContract cashInContract = result.ReturnValue as Model.CashInContract; if (cashInContract == null) { result.ResultStatus = -1; result.Message = "获取失败"; return result; } result = fundsLogDAL.Insert(user, new FundsLog() { //FundsLogId ContractId = cashInContract.ContractId, SubId = cashInContract.SubContractId, //InvoiceId LogDate = DateTime.Now, InBlocId = cashIn.CashInBlocId, InCorpId = cashIn.CashInCorpId, InBankId = cashIn.CashInBank, InAccountId = cashIn.CashInAccoontId, OutBlocId = cashIn.PayBlocId, OutCorpId = cashIn.PayCorpId, OutBankId = cashIn.PayBankId, OutBank = cashIn.PayBank, OutAccountId = cashIn.PayAccountId, OutAccount = cashIn.PayAccount, FundsBala = cashInStcok.AllotBala, //FundsType CurrencyId = cashInAllot.CurrencyId, LogDirection = (int)NFMT.WareHouse.LogDirectionEnum.In, LogType = (int)NFMT.WareHouse.LogTypeEnum.收款, //PayMode //IsVirtualPay FundsDesc = cashInAllot.AllotDesc, OpPerson = user.EmpId, LogSourceBase = "NFMT", LogSource = "dbo.Fun_CashInContract_Ref", SourceId = dataSource.RowId, LogStatus = StatusEnum.已生效 }); if (result.ResultStatus != 0) return result; int fundsLogId = (int)result.ReturnValue; cashInStcok.FundsLogId = fundsLogId; result = cashinstcokDAL.Update(user, cashInStcok); if (result.ResultStatus != 0) return result; } } scope.Complete(); } } catch (Exception ex) { result.ResultStatus = -1; result.Message = ex.Message; return result; } return result; }
public ResultModel Invalid(UserModel user, int allotId) { ResultModel result = new ResultModel(); try { DAL.CashInAllotDAL cashInAllotDAL = new CashInAllotDAL(); using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required)) { result = cashInAllotDAL.Get(user, allotId); if (result.ResultStatus != 0) return result; Model.CashInAllot cashInAllot = result.ReturnValue as Model.CashInAllot; if (cashInAllot == null) { result.ResultStatus = -1; result.Message = "获取失败"; return result; } //作废付款分配 result = cashInAllotDAL.Invalid(user, cashInAllot); if (result.ResultStatus != 0) return result; result = cashincorpDAL.Load(user, allotId, StatusEnum.已生效); if (result.ResultStatus != 0) return result; List<Model.CashInCorp> cashInCorps = result.ReturnValue as List<Model.CashInCorp>; if (cashInCorps == null || !cashInCorps.Any()) { result.ResultStatus = -1; result.Message = "获取明细失败"; return result; } foreach (Model.CashInCorp cashInCorp in cashInCorps) { //作废明细 result = cashincorpDAL.Invalid(user, cashInCorp); 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 CompleteCancel(UserModel user, int allotId) { ResultModel result = new ResultModel(); try { DAL.CashInAllotDAL cashInAllotDAL = new CashInAllotDAL(); DAL.FundsLogDAL fundsLogDAL = new FundsLogDAL(); Model.FundsLog fundsLog = null; DAL.CashInCorpDAL cashInCorpDAL = new CashInCorpDAL(); DAL.CashInContractDAL cashInContractDAL = new CashInContractDAL(); using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required)) { result = cashInAllotDAL.Get(user, allotId); if (result.ResultStatus != 0) return result; Model.CashInAllot cashInAllot = result.ReturnValue as Model.CashInAllot; if (cashInAllot == null) { result.ResultStatus = -1; result.Message = "获取失败"; return result; } //完成撤销付款分配 result = cashInAllotDAL.CompleteCancel(user, cashInAllot); if (result.ResultStatus != 0) return result; result = cashinstcokDAL.LoadByAllot(user, allotId, StatusEnum.已完成); if (result.ResultStatus != 0) return result; List<Model.CashInStcok> cashInStcoks = result.ReturnValue as List<Model.CashInStcok>; if (cashInStcoks == null || !cashInStcoks.Any()) { result.ResultStatus = -1; result.Message = "获取明细失败"; return result; } foreach (Model.CashInStcok cashInStcok in cashInStcoks) { //完成撤销明细 result = cashinstcokDAL.CompleteCancel(user, cashInStcok); if (result.ResultStatus != 0) return result; result = cashInContractDAL.Get(user, cashInStcok.ContractRefId); if (result.ResultStatus != 0) return result; Model.CashInContract cashInContract = result.ReturnValue as Model.CashInContract; if (cashInContract == null) { result.ResultStatus = -1; result.Message = "获取失败"; return result; } result = cashInContractDAL.CompleteCancel(user, cashInContract); if (result.ResultStatus != 0) 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) { result.ResultStatus = -1; result.Message = "获取失败"; return result; } result = cashInCorpDAL.CompleteCancel(user, cashInCorp); if (result.ResultStatus != 0) return result; result = fundsLogDAL.Get(user, cashInStcok.FundsLogId); if (result.ResultStatus != 0) return result; fundsLog = result.ReturnValue as Model.FundsLog; if (fundsLog == null) { result.ResultStatus = -1; result.Message = "获取资金流水失败"; return result; } //完成撤销流水 result = fundsLogDAL.CompleteCancel(user, fundsLog); if (result.ResultStatus != 0) return result; } scope.Complete(); } } catch (Exception ex) { result.ResultStatus = -1; result.Message = ex.Message; } 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 UpdateContract(UserModel user, List<CashInContract> details, int subId) { ResultModel result = new ResultModel(); try { DAL.CashInDAL cashInDAL = new CashInDAL(); DAL.CashInAllotDAL cashInAllotDAL = new CashInAllotDAL(); DAL.CashInCorpDAL cashInCorpDAL = new CashInCorpDAL(); NFMT.Contract.DAL.ContractSubDAL subDAL = new Contract.DAL.ContractSubDAL(); DAL.CashInStcokDAL cashInStockDAL = new CashInStcokDAL(); using (System.Transactions.TransactionScope scope = new TransactionScope()) { //获取子合约 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.Message = "子合约不存在,不能进行修改"; result.ResultStatus = -1; return result; } //获取当前合约下的有效明细 result = this.cashincontractDAL.Load(user, sub.SubId); if (result.ResultStatus != 0) return result; List<Model.CashInContract> resultDetails = result.ReturnValue as List<Model.CashInContract>; if (resultDetails == null) { result.Message = "获取明细失败"; result.ResultStatus = -1; return result; } //作废现有有效明细 foreach (Model.CashInContract nd in resultDetails) { //验证当前合约明细是否已分配至库存中 result = cashInStockDAL.LoadByContractRefId(user, nd.RefId); if (result.ResultStatus != 0) return result; List<Model.CashInStcok> stocks = result.ReturnValue as List<Model.CashInStcok>; if (stocks != null && stocks.Count > 0) { result.Message = "合约款已全部或部分配款至库存,不能进行修改"; result.ResultStatus = -1; return result; } if (nd.DetailStatus == StatusEnum.已生效) nd.DetailStatus = StatusEnum.已录入; result = this.cashincontractDAL.Invalid(user, nd); if (result.ResultStatus != 0) return result; } //新增明细 foreach (Model.CashInContract det in details) { //获取公司分配 result = cashInCorpDAL.Get(user, det.CorpRefId); if (result.ResultStatus != 0) return result; Model.CashInCorp cashInCrop = result.ReturnValue as Model.CashInCorp; if (cashInCrop == null || cashInCrop.RefId <= 0) { result.Message = "修改失败"; result.ResultStatus = -1; return result; } //获取分配 result = cashInAllotDAL.Get(user, cashInCrop.AllotId); if (result.ResultStatus != 0) return result; NFMT.Funds.Model.CashInAllot allot = result.ReturnValue as NFMT.Funds.Model.CashInAllot; if (allot == null || allot.AllotId <= 0) { result.Message = "收款分配不存在,不能进行修改"; result.ResultStatus = -1; return result; } //获取收款登记 result = cashInDAL.Get(user, cashInCrop.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; } det.AllotId = cashInCrop.AllotId; det.CorpRefId = cashInCrop.RefId; det.ContractId = sub.ContractId; det.CashInId = cashIn.CashInId; det.CorpRefId = cashInCrop.RefId; det.DetailStatus = StatusEnum.已生效; det.SubContractId = sub.SubId; result = this.cashincontractDAL.Insert(user, det); if (result.ResultStatus != 0) return result; } scope.Complete(); } } catch (Exception ex) { result.ResultStatus = -1; result.Message = ex.Message; } return result; }