public ResultModel ReceStockComplete(UserModel user, int allotId) { ResultModel result = new ResultModel(); try { using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required)) { DAL.ReceivableAllotDAL receivableAllotDAL = new ReceivableAllotDAL(); result = receivableAllotDAL.Get(user, allotId); if (result.ResultStatus != 0) return result; Model.ReceivableAllot receivableAllot = result.ReturnValue as Model.ReceivableAllot; if (receivableAllot == null || receivableAllot.ReceivableAllotId <= 0) { result.ResultStatus = -1; result.Message = "收款分配不存在"; return result; } //收款分配完成 result = receivableAllotDAL.Confirm(user, receivableAllot); if (result.ResultStatus != 0) return result; //根据收款分配ID获取公司收款分配 DAL.CorpReceivableDAL corpReceivableDAL = new CorpReceivableDAL(); result = corpReceivableDAL.GetCorpReceivableByAllotId(user, allotId); if (result.ResultStatus != 0) return result; List<Model.CorpReceivable> corpReceivables = result.ReturnValue as List<Model.CorpReceivable>; if (corpReceivables == null) { result.ResultStatus = -1; result.Message = "公司收款分配不存在"; return result; } //公司收款分配完成 foreach (Model.CorpReceivable corpReceivable in corpReceivables) { result = corpReceivableDAL.Complete(user, corpReceivable); if (result.ResultStatus != 0) return result; } //根据收款分配ID获取合约收款分配 DAL.ContractReceivableDAL contractReceivableDAL = new ContractReceivableDAL(); result = contractReceivableDAL.GetContractReceivableByAllotId(user, allotId); if (result.ResultStatus != 0) return result; List<Model.ContractReceivable> contractReceivables = result.ReturnValue as List<Model.ContractReceivable>; if (contractReceivables == null) { result.ResultStatus = -1; result.Message = "合约收款分配不存在"; return result; } //合约收款分配完成 foreach (Model.ContractReceivable contractReceivable in contractReceivables) { result = contractReceivableDAL.Complete(user, contractReceivable); if (result.ResultStatus != 0) return result; } //根据收款分配ID获取库存收款分配 DAL.StcokReceivableDAL stcokReceivableDAL = new StcokReceivableDAL(); result = stcokReceivableDAL.GetStockReceivableByAllotId(user, allotId); if (result.ResultStatus != 0) return result; List<Model.StcokReceivable> stcokReceivables = result.ReturnValue as List<Model.StcokReceivable>; if (stcokReceivables == null) { result.ResultStatus = -1; result.Message = "库存收款分配不存在"; return result; } //库存收款分配完成 foreach (Model.StcokReceivable stcokReceivable in stcokReceivables) { result = stcokReceivableDAL.Complete(user, stcokReceivable); if (result.ResultStatus != 0) return result; } scope.Complete(); } } catch (Exception e) { result.Message = e.Message; result.ResultStatus = -1; } 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 ReceivableCorpAllotCreateHandle(UserModel user, List<Model.ContractReceivable> contractReceivables, int curId, string memo,int allotFrom) { ResultModel result = new ResultModel(); DAL.ReceivableDAL receivableDAL = new ReceivableDAL(); DAL.ContractReceivableDAL contractReceivableDAL = new ContractReceivableDAL(); DAL.CorpReceivableDAL corpReceivableDAL = new CorpReceivableDAL(); Model.Receivable receivable = new Receivable(); try { using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required)) { decimal allotBala = 0; foreach (Model.ContractReceivable ContractReceivable in contractReceivables) { //allotBala += ContractReceivable.AllotBala; } Model.ReceivableAllot receivableAllot = new ReceivableAllot() { AllotFrom = allotFrom, AllotBala = allotBala, CurrencyId = curId, AllotDesc = memo, EmpId = user.EmpId, AllotTime = DateTime.Now }; result = receivableallotDAL.Insert(user, receivableAllot); if (result.ResultStatus != 0) return result; int receivableAllotId = (int)result.ReturnValue; foreach (Model.ContractReceivable contractReceivable in contractReceivables) { contractReceivable.AllotId = receivableAllotId; result = corpReceivableDAL.Get(user, contractReceivable.CorpRefId); if (result.ResultStatus != 0) return result; Model.CorpReceivable corpReceivable = result.ReturnValue as Model.CorpReceivable; if (corpReceivable == null) return result; contractReceivable.RecId = corpReceivable.RecId; result = contractReceivableDAL.Insert(user, contractReceivable); 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; }
public ResultModel ReceivableAllotUpdateHandle(UserModel user, List<Model.CorpReceivable> corpReceivables, int curId, string memo, int allotId, int contractId, int subId) { ResultModel result = new ResultModel(); DAL.ReceivableDAL receivableDAL = new ReceivableDAL(); DAL.ContractReceivableDAL contractReceivableDAL = new ContractReceivableDAL(); DAL.CorpReceivableDAL corpReceivableDAL = new CorpReceivableDAL(); NFMT.User.DAL.CorporationDAL corporationDAL = new User.DAL.CorporationDAL(); 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; //更新分配信息 result = receivableallotDAL.Update(user, receivableAllot); if (result.ResultStatus != 0) return result; //作废所有allotId下的合约收款分配 result = contractReceivableDAL.InvalidAll(user, allotId); if (result.ResultStatus != 0) return result; //作废所有allotId下的公司收款分配 result = corpReceivableDAL.InvalidAll(user, allotId); if (result.ResultStatus != 0) return result; foreach (Model.CorpReceivable corpReceivable in corpReceivables) { corpReceivable.AllotId = allotId; result = corporationDAL.Get(user, corpReceivable.CorpId); if (result.ResultStatus != 0) return result; //获取公司信息 NFMT.User.Model.Corporation corp = result.ReturnValue as NFMT.User.Model.Corporation; if (corp == null) return result; corpReceivable.BlocId = corp.ParentId; //写入公司收款分配表 result = corpReceivableDAL.Insert(user, corpReceivable); if (result.ResultStatus != 0) return result; int refId = (int)result.ReturnValue; Model.ContractReceivable contractReceivable = new ContractReceivable() { CorpRefId = refId, AllotId = corpReceivable.AllotId, RecId = corpReceivable.RecId, ContractId = contractId, SubContractId = subId, //AllotBala = corpReceivable.AllotBala }; //写入合约收款分配表 result = contractReceivableDAL.Insert(user, contractReceivable); 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; }