/// <summary>
/// 有用，创建分配公司关联表
/// </summary>
/// <param name="user"></param>
/// <param name="rec"></param>
/// <param name="details"></param>
/// <param name="corpDetail"></param>
/// <returns></returns>
public ResultModel CreateCorp(UserModel user, Model.ReceivableAllot rec, List<Model.RecAllotDetail> details,Model.CorpReceivable corpDetail)
{
ResultModel result = new ResultModel();
try
{
DAL.CorpReceivableDAL corpRecDAL = new CorpReceivableDAL();
using (System.Transactions.TransactionScope scope = new TransactionScope())
{
rec.AllotType = (int)CashInAllotTypeEnum.Corp;
result = this.CreateMain(user, rec, ref details);
if (result.ResultStatus != 0)
return result;
foreach (Model.RecAllotDetail detail in details)
{
Model.CorpReceivable corpD = new CorpReceivable();
corpD.AllotId = detail.AllotId;
corpD.BlocId = corpDetail.BlocId;
corpD.CorpId = corpDetail.CorpId;
corpD.DetailId = detail.DetailId;
corpD.IsShare = corpDetail.IsShare;
corpD.RecId = detail.RecId;
result = corpRecDAL.Insert(user, corpD);
if (result.ResultStatus != 0)
return result;
}
scope.Complete();
}
}
catch (Exception ex)
{
result.ResultStatus = -1;
result.Message = ex.Message;
}
return result;
}
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 UpdateCorp(UserModel user, Model.ReceivableAllot rec, List<Model.RecAllotDetail> details, Model.CorpReceivable corpDetail)
{
ResultModel result = new ResultModel();
try
{
DAL.CorpReceivableDAL corpRecDAL = new CorpReceivableDAL();
using (System.Transactions.TransactionScope scope = new TransactionScope())
{
result = this.UpdateMain(user, rec, ref details);
if (result.ResultStatus != 0)
return result;
result = corpRecDAL.Load(user, rec.ReceivableAllotId);
if (result.ResultStatus != 0)
return result;
List<Model.CorpReceivable> corpDetails = result.ReturnValue as List<Model.CorpReceivable>;
if (corpDetails == null || corpDetails.Count == 0)
{
result.ResultStatus = -1;
result.Message = "获取公司明细失败";
return result;
}
corpDetail.BlocId = corpDetails[0].BlocId;
corpDetail.CorpId = corpDetails[0].CorpId;
foreach (Model.RecAllotDetail detail in details)
{
Model.CorpReceivable corpD = new CorpReceivable();
corpD.AllotId = detail.AllotId;
corpD.BlocId = corpDetail.BlocId;
corpD.CorpId = corpDetail.CorpId;
corpD.DetailId = detail.DetailId;
corpD.IsShare = corpDetail.IsShare;
corpD.RecId = detail.RecId;
result = corpRecDAL.Insert(user, corpD);
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;
}
public ResultModel ReceivableCorpUpdateHandle(UserModel user, List<Model.CorpReceivable> corpReceivables, int curId, string memo, int allotId)
{
ResultModel result = new ResultModel();
DAL.ReceivableDAL receivableDAL = new ReceivableDAL();
DAL.CorpReceivableDAL corpReceivableDAL = new CorpReceivableDAL();
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;
result = corpReceivableDAL.InvalidAll(user, allotId);
if (result.ResultStatus != 0)
return result;
foreach (Model.CorpReceivable corpReceivable in corpReceivables)
{
corpReceivable.AllotId = allotId;
result = corpReceivableDAL.Insert(user, corpReceivable);
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 ReceivableCorpCreateHandle(UserModel user, List<Model.CorpReceivable> corpReceivables, int curId, string memo)
{
ResultModel result = new ResultModel();
DAL.ReceivableDAL receivableDAL = new ReceivableDAL();
DAL.CorpReceivableDAL corpReceivableDAL = new CorpReceivableDAL();
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;
}
Model.ReceivableAllot receivableAllot = new ReceivableAllot()
{
AllotFrom = NFMT.Data.DetailProvider.Details(NFMT.Data.StyleEnum.分配来源)["Receivable"].StyleDetailId,
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.CorpReceivable corpReceivable in corpReceivables)
{
corpReceivable.AllotId = receivableAllotId;
result = corpReceivableDAL.Insert(user, corpReceivable);
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;
}
