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;
}
