/// <summary>
/// 生成记账流水信息
/// </summary>
public void NoteFlowInformation()
{
#region 生成记账流水信息
var dateNow = DateTime.Now;
T_PartnerCapitalPoolEntity payDetailsEntity = new T_PartnerCapitalPoolEntity()
{
PartnerCapitalPoolID = Guid.NewGuid().ToString(),
EcommerceProjectRelationID = EcommerceProjectMoneyCapacity.EcommerceProjectRelationID,
T_P_PartnerCapitalPoolID = "0",
OperationTitle = "【" + inputPayEntity.Pay_Info_Code + "】消费支出",
OperationType = (int)OperationTypeNoteEnum.PayConsumption,
OperationMoney = this.operationAmount,
CurrentMoney = EcommerceProjectMoneyCapacity.ControlTotalAmount + this.operationAmount, // CurrentBalance
AccountingType = (int)AccountingTypeEnum.Expenditure,
CurrentBalance = EcommerceProjectMoneyCapacity.ControlTotalAmount,
DeleteMark = 0,
CreateDate = dateNow,
ModifyDate = dateNow,
CreateUserId = "System",
CreateUserName = "******",
ObjectID = inputPayEntity.Pay_Info_Id,
StatisticalDate = dateNow
};
Transdb.Insert(payDetailsEntity);
#endregion
}
public void SaveForm(string keyValue, Transfer_InfoEntity entity, string ProjectID, string EcommerceID, string ActualControlTotalAmount, string Transfer_Code, out string errMsg)
{
errMsg = string.Empty;
try
{
if (!string.IsNullOrEmpty(keyValue))
{
entity.Modify(keyValue);
this.BaseRepository().Update(entity);
}
else
{
string queryJson = ProjectID;
string queryValue = EcommerceID;
IEnumerable <EcommerceProjectRelationEntity> ecomPro = projectInfo.GetMoneyByEconmProjectJson(queryJson, queryValue);
decimal Amount = ecomPro.First().ActualControlTotalAmount;
decimal AllAmount = ecomPro.First().ControlTotalAmount;
decimal Money = decimal.Parse(ActualControlTotalAmount);
if (Amount >= Money)
{
decimal FinalAmount = Amount - Money;
decimal FinalAll = AllAmount - Money;
proRelation.UpdateActAmount(EcommerceID, ProjectID, FinalAmount, FinalAll);
entity.Transfer_Code = Transfer_Code;
entity.Transfer_Info_Id = Guid.NewGuid().ToString();
entity.CreateDate = DateTime.Now;
entity.DeleteMark = 0;
entity.Transfer_Money = Money;
entity.Transfer_Balance = FinalAmount;
entity.Transfer_Date = DateTime.Now;
entity.CreateUserId = OperatorProvider.Provider.Current().UserId;
entity.CreateUserName = OperatorProvider.Provider.Current().UserName;
this.BaseRepository().Insert(entity);
string value = string.Empty;
T_PartnerCapitalPoolEntity pcEntity = new T_PartnerCapitalPoolEntity();
pcEntity.EcommerceProjectRelationID = ecomPro.First().EcommerceProjectRelationID;
pcEntity.OperationTitle = "资金划拨";
pcEntity.T_P_PartnerCapitalPoolID = null;
pcEntity.OperationType = 1;
pcEntity.OperationMoney = Money;
pcEntity.CurrentMoney = AllAmount;
pcEntity.CurrentBalance = FinalAll;
pcEntity.AccountingType = 1;
pcEntity.DeleteMark = 0;
pcEntity.StatisticalDate = DateTime.Now;
pcEntity.ObjectID = entity.Transfer_Info_Id;
patnerCapPook.SaveForm(value, pcEntity);
}
else
{
errMsg = "可以金额已经发生变化，请重写划拨！";
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
/// <summary>
/// 保存表单（新增、修改）
/// </summary>
/// <param name="keyValue">主键值</param>
/// <param name="entity">实体对象</param>
/// <returns></returns>
public void SaveForm(string keyValue, T_PartnerCapitalPoolEntity entity)
{
try
{
service.SaveForm(keyValue, entity);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public ActionResult SaveForm(string keyValue, T_PartnerCapitalPoolEntity entity)
{
try
{
t_partnercapitalpoolbll.SaveForm(keyValue, entity);
return(Success("操作成功。"));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
/// <summary>
/// 删除数据
/// </summary>
/// <param name="keyValue">主键</param>
public void DeleteRemark(string keyValue, string queryJson, string ProjectID, string Transfer_Money, string EcommerceID)
{
try
{
StringBuilder strSql = new StringBuilder();
string queryJson1 = ProjectID;
string queryValue = EcommerceID;
IEnumerable <EcommerceProjectRelationEntity> ecomPro = projectInfo.GetMoneyByEconmProjectJson(queryJson1, queryValue);
decimal Amount = ecomPro.First().ActualControlTotalAmount;
decimal AllAmount = ecomPro.First().ControlTotalAmount;
decimal Money;
if (!Transfer_Money.IsEmpty() || Transfer_Money != "")
{
Money = decimal.Parse(Transfer_Money);
}
else
{
Money = 0;
}
decimal FinalAmount = Amount + Money;
decimal FinalAll = AllAmount + Money;
proRelation.UpdateActAmount(EcommerceID, ProjectID, FinalAmount, FinalAll);
strSql.Append(@" update T_Transfer_Info set DeleteMark=1,Remark='" + queryJson + "' where Transfer_Info_Id='" + keyValue + "'");
this.BaseRepository().ExecuteBySql(strSql.ToString());
string value = string.Empty;
IEnumerable <T_PartnerCapitalPoolEntity> paCaPoolList = patnerCapPook.getPaCaPoolList(keyValue);
T_PartnerCapitalPoolEntity pcEntityzzz = new T_PartnerCapitalPoolEntity();
pcEntityzzz = paCaPoolList.First();
pcEntityzzz.DeleteMark = 1;
//if (paCaPoolList.FirstOrDefault() == null)
//{
T_PartnerCapitalPoolEntity pcEntity = new T_PartnerCapitalPoolEntity();
pcEntity.EcommerceProjectRelationID = ecomPro.First().EcommerceProjectRelationID;
pcEntity.OperationTitle = "资金划拨";
pcEntity.T_P_PartnerCapitalPoolID = paCaPoolList.First().PartnerCapitalPoolID;
pcEntity.OperationType = 0;
pcEntity.OperationMoney = Money;
pcEntity.CurrentMoney = AllAmount;
pcEntity.CurrentBalance = FinalAll;
pcEntity.AccountingType = 0;
pcEntity.ObjectID = keyValue;
pcEntity.StatisticalDate = DateTime.Now;
pcEntity.DeleteMark = 1;
patnerCapPook.SaveForm(value, pcEntity);
patnerCapPook.SaveForm(paCaPoolList.First().PartnerCapitalPoolID, pcEntityzzz);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
/// <summary>
/// 保存表单（新增、修改）
/// </summary>
/// <param name="keyValue">主键值</param>
/// <param name="entity">实体对象</param>
/// <returns></returns>
public void SaveForm(string keyValue, T_PartnerCapitalPoolEntity entity)
{
try
{
if (!string.IsNullOrEmpty(keyValue))
{
entity.Modify(keyValue);
this.BaseRepository().Update(entity);
}
else
{
entity.Create();
this.BaseRepository().Insert(entity);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public override object Execute()
{
T_CapitalFlowEntity cf = new T_CapitalFlowEntity()
{
CapitalFlow_Id = this._context.strBOID,
LatestApprovetime = this._context.dtTime,
ApprovalState = this._context.ApproveStatus,
LatestComment = this._context.strComment,
Procinstid = this._context.iProcInstID.ToString(),
};
cfBll.ApprovalUpdateState(this._context.strBOID, cf);
if (this._context.ApproveStatus == (int)ApproveStatus.approved)
{
/// <summary>
/// 1.根据CapitalFlow_Id 查询
/// 1.1如果orderNo为空 是第一个
/// 1.1.1根据CapitalFlow_Id查询出子表数据
/// 1.1.2循环子表数据 根据每一个子表数据中的电商id和项目id 查询出来合同表
/// 1.1.3然后将子表中资金和合同表中资金相加 然后更新合同表
/// 1.1.4更新当前CapitalFlow的orderNo为0
/// 1.2如果不为空
/// 1.2.1根据查询出来orderNo最大的一条CapitalFlow记录
/// 1.2.2根据CapitalFlow_Id查询出子表数据
/// 1.2.3循环子表数据 根据每一个子表数据中的电商id和项目id 查询出来合同表
/// </summary>
//根据区域id 年份 月份 获取orderno最大的一条
List <T_CapitalFlowEntity> cfEntity = cfBll.check(this._context.strBOID, cf).ToList();
//判断是否为第一次收入
if (cfEntity[0].OrderNo == null)
{
//第一笔收入
//获取子表
List <CapitalFlow_ProRelaView> cfNodeList = cfBll.updateMoney(this._context.strBOID).ToList();
//新建一个合同list 便于update
List <EcommerceProjectRelationEntity> ecomList = new List <EcommerceProjectRelationEntity>();
//新建一个流水list 便于insert
List <T_PartnerCapitalPoolEntity> pCaPoolList = new List <T_PartnerCapitalPoolEntity>();
CapitalFlow_ProRelaView ecomEntity = new CapitalFlow_ProRelaView();
foreach (CapitalFlow_ProRelaView c in cfNodeList)
{
EcommerceProjectRelationEntity ecomProReEntity = new EcommerceProjectRelationEntity();
T_PartnerCapitalPoolEntity pcEntity = new T_PartnerCapitalPoolEntity();
//根据项目id和电商id查询合同表
//ecomEntity = ecomBll.GetTrunkEntity(c.ProjectID, c.EcommerceID);
ecomEntity = cfNodeList.FirstOrDefault(p => p.ProjectID == c.ProjectID && p.EcommerceID == c.EcommerceID);
if (ecomEntity != null)
{
//List<EcommerceProjectRelationEntity> list= ecomBll.searchActAmount(ecomEntity.EcommerceID,ecomEntity.ProjectID).ToList();
decimal aca = (decimal)(ecomEntity.ActualControlTotalAmount + c.CapitalPoolAdd);
decimal ca = (decimal)(ecomEntity.ControlTotalAmount + c.CapitalPoolAdd);
//合同表
ecomProReEntity.EcommerceProjectRelationID = c.EcommerceProjectRelationID;
ecomProReEntity.ActualControlTotalAmount = aca;
ecomProReEntity.ControlTotalAmount = ca;
ecomList.Add(ecomProReEntity);
//流水表
pcEntity.OperationTitle = "资金导入";
pcEntity.OperationType = 3;
pcEntity.T_P_PartnerCapitalPoolID = null;
pcEntity.OperationMoney = c.CapitalPoolAdd;
pcEntity.CurrentMoney = ecomEntity.ControlTotalAmount;
pcEntity.CurrentBalance = ca;
pcEntity.AccountingType = 0;
pcEntity.EcommerceProjectRelationID = c.EcommerceProjectRelationID;
pcEntity.PartnerCapitalPoolID = Guid.NewGuid().ToString();
pcEntity.CreateDate = DateTime.Now;
pcEntity.CreateUserId = c.CreateUserId;
pcEntity.CreateUserName = c.CreateUserName;
pcEntity.ObjectID = c.CapitalFlow_Details_Id;
pcEntity.DeleteMark = 0;
pcEntity.StatisticalDate = c.UploadDate;
pCaPoolList.Add(pcEntity);
}
}
//更新钱
ecomBll.updateMoneyAA(ecomList);
pCaPoolBll.InsertEntityList(pCaPoolList);
//更新orderno
cfBll.updateOrderNo(0, this._context.strBOID);
}
else
{
//获取流水表的明细
IEnumerable <T_PartnerCapitalPoolEntity> paCaPoolList = pCaPoolBll.getAllPaCaPoolList();
//获取上一个通过的记录
List <CapitalFlow_ProRelaView> cfNodeListBefor = cfBll.updateMoney(cfEntity[0].CapitalFlow_Id).ToList();
//获取当前记录
List <CapitalFlow_ProRelaView> cfNodeListNow = cfBll.updateMoney(this._context.strBOID).ToList();
//新建一个资金池list 更新资金池
List <EcommerceProjectRelationEntity> ecomListBefor = new List <EcommerceProjectRelationEntity>();
//新建一个流水list 便于insert
List <T_PartnerCapitalPoolEntity> pCaPoolListBefor = new List <T_PartnerCapitalPoolEntity>();
//新建一个流水list 便于update deletemark=1
List <T_PartnerCapitalPoolEntity> pCaPoolListDel = new List <T_PartnerCapitalPoolEntity>();
//循环上一个通过的记录
foreach (CapitalFlow_ProRelaView c in cfNodeListBefor)
{
EcommerceProjectRelationEntity ecomProReEntity = new EcommerceProjectRelationEntity();
CapitalFlow_ProRelaView ecomEntity = new CapitalFlow_ProRelaView();
CapitalFlow_ProRelaView ecomEntityZ = new CapitalFlow_ProRelaView();
T_PartnerCapitalPoolEntity pcEntity = new T_PartnerCapitalPoolEntity();
T_PartnerCapitalPoolEntity pcZEntity = new T_PartnerCapitalPoolEntity();
//根据项目id和电商id查询合同表
ecomEntity = cfNodeListBefor.FirstOrDefault(p => p.ProjectID == c.ProjectID && p.EcommerceID == c.EcommerceID);
ecomEntityZ = cfNodeListNow.FirstOrDefault(p => p.ProjectID == c.ProjectID && p.EcommerceID == c.EcommerceID);
pcZEntity = paCaPoolList.FirstOrDefault(p => p.ObjectID == c.CapitalFlow_Details_Id && p.OperationType == 3);
pcZEntity.DeleteMark = 1;
pCaPoolListDel.Add(pcZEntity);
if (ecomEntity != null)
{
decimal aca = (decimal)(ecomEntity.ActualControlTotalAmount - c.CapitalPoolAdd);
decimal ca = (decimal)(ecomEntity.ControlTotalAmount - c.CapitalPoolAdd);
ecomProReEntity.EcommerceProjectRelationID = c.EcommerceProjectRelationID;
ecomProReEntity.ActualControlTotalAmount = aca;
ecomProReEntity.ControlTotalAmount = ca;
ecomListBefor.Add(ecomProReEntity);
//流水表
pcEntity.OperationTitle = "资金导入";
pcEntity.OperationType = 2;
pcEntity.OperationMoney = c.CapitalPoolAdd;
pcEntity.CurrentMoney = ecomEntity.ControlTotalAmount;
pcEntity.CurrentBalance = ca;
pcEntity.AccountingType = 1;
pcEntity.EcommerceProjectRelationID = c.EcommerceProjectRelationID;
pcEntity.PartnerCapitalPoolID = Guid.NewGuid().ToString();
pcEntity.CreateDate = DateTime.Now;
pcEntity.T_P_PartnerCapitalPoolID = pcZEntity.PartnerCapitalPoolID;
if (ecomEntityZ != null)
{
pcEntity.ObjectID = ecomEntityZ.CapitalFlow_Details_Id;
}
else
{
pcEntity.ObjectID = ecomEntity.CapitalFlow_Details_Id;
}
pcEntity.StatisticalDate = c.UploadDate;
pcEntity.DeleteMark = 1;
pcEntity.CreateUserId = cfNodeListNow.First().CreateUserId;
pcEntity.CreateUserName = cfNodeListNow.First().CreateUserName;
pCaPoolListBefor.Add(pcEntity);
}
}
pCaPoolBll.InsertEntityList(pCaPoolListBefor);
ecomBll.updateMoneyAA(ecomListBefor);
pCaPoolBll.UpdateEntityList(pCaPoolListDel);
cfBll.updateDeleteMark(cfEntity[0].CapitalFlow_Id);
cfBll.updateCapDeleteMark(cfEntity[0].CapitalFlow_Id);
//获取当前的记录
paCaPoolList = pCaPoolBll.getAllPaCaPoolList();
cfNodeListNow = cfBll.updateMoney(this._context.strBOID).ToList();
List <EcommerceProjectRelationEntity> ecomListNow = new List <EcommerceProjectRelationEntity>();
//新建一个流水list 便于insert
List <T_PartnerCapitalPoolEntity> pCaPoolListNow = new List <T_PartnerCapitalPoolEntity>();
foreach (CapitalFlow_ProRelaView c in cfNodeListNow)
{
EcommerceProjectRelationEntity ecomProReEntity = new EcommerceProjectRelationEntity();
CapitalFlow_ProRelaView ecomEntity = new CapitalFlow_ProRelaView();
T_PartnerCapitalPoolEntity pcEntity = new T_PartnerCapitalPoolEntity();
T_PartnerCapitalPoolEntity pcZEntity = new T_PartnerCapitalPoolEntity();
//根据项目id和电商id查询合同表
ecomEntity = cfNodeListNow.FirstOrDefault(p => p.ProjectID == c.ProjectID && p.EcommerceID == c.EcommerceID);
pcZEntity = paCaPoolList.FirstOrDefault(p => p.ObjectID == c.CapitalFlow_Details_Id);
if (ecomEntity != null)
{
decimal aca = (decimal)(ecomEntity.ActualControlTotalAmount + c.CapitalPoolAdd);
decimal ca = (decimal)(ecomEntity.ControlTotalAmount + c.CapitalPoolAdd);
ecomProReEntity.EcommerceProjectRelationID = c.EcommerceProjectRelationID;
ecomProReEntity.ActualControlTotalAmount = aca;
ecomProReEntity.ControlTotalAmount = ca;
ecomListNow.Add(ecomProReEntity);
//流水表
if (pcZEntity != null)
{
pcEntity.OperationTitle = "资金导入";
pcEntity.OperationType = 3;
pcEntity.OperationMoney = c.CapitalPoolAdd;
pcEntity.CurrentMoney = ecomEntity.ControlTotalAmount;
pcEntity.CurrentBalance = ca;
pcEntity.AccountingType = 0;
pcEntity.EcommerceProjectRelationID = c.EcommerceProjectRelationID;
pcEntity.PartnerCapitalPoolID = Guid.NewGuid().ToString();
pcEntity.CreateDate = DateTime.Now;
pcEntity.CreateUserId = c.CreateUserId;
pcEntity.T_P_PartnerCapitalPoolID = pcZEntity.PartnerCapitalPoolID;
pcEntity.CreateUserName = c.CreateUserName;
pcEntity.ObjectID = c.CapitalFlow_Details_Id;
pcEntity.StatisticalDate = c.UploadDate;
pcEntity.DeleteMark = 0;
}
else
{
pcEntity.OperationTitle = "资金导入";
pcEntity.OperationType = 3;
pcEntity.OperationMoney = c.CapitalPoolAdd;
pcEntity.CurrentMoney = ecomEntity.ControlTotalAmount;
pcEntity.CurrentBalance = ca;
pcEntity.AccountingType = 0;
pcEntity.EcommerceProjectRelationID = c.EcommerceProjectRelationID;
pcEntity.PartnerCapitalPoolID = Guid.NewGuid().ToString();
pcEntity.CreateDate = DateTime.Now;
pcEntity.CreateUserId = c.CreateUserId;
pcEntity.T_P_PartnerCapitalPoolID = null;
pcEntity.CreateUserName = c.CreateUserName;
pcEntity.ObjectID = c.CapitalFlow_Details_Id;
pcEntity.StatisticalDate = c.UploadDate;
pcEntity.DeleteMark = 0;
}
pCaPoolListNow.Add(pcEntity);
}
}
ecomBll.updateMoneyAA(ecomListNow);
pCaPoolBll.InsertEntityList(pCaPoolListNow);
int a = cfEntity[0].OrderNo ?? 0;
cfBll.updateOrderNo(a + 1, this._context.strBOID);
}
}
return(true);
}