public IEnumerable <T_CapitalFlowEntity> check(string keyValue, T_CapitalFlowEntity entity) { try { return(service.check(keyValue, entity)); } 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_CapitalFlowEntity entity) { try { service.SaveForm(keyValue, entity); } catch (Exception ex) { throw new Exception(ex.Message); } }
/// <summary> /// 审核 /// </summary> /// <param name="keyValue">主键值</param> /// <param name="entity">实体对象</param> /// <returns></returns> public void ApprovalUpdateState(string keyValue, T_CapitalFlowEntity entity) { try { service.ApprovalUpdateState(keyValue, entity); } catch (Exception ex) { throw new Exception(ex.Message); } }
/// <summary> /// 删除数据 /// </summary> /// <param name="keyValue"></param> public void DeleteForm(string keyValue) { try { T_CapitalFlowEntity entity = t_capservice.GetEntity(keyValue); entity.DeleteMark = 1; this.BaseRepository().Update(entity); } catch (Exception e) { throw new Exception(e.Message); } }
public override object Execute() { T_CapitalFlowEntity cf = new T_CapitalFlowEntity() { CapitalFlow_Id = this._context.strBOID, ApprovalState = this._context.ApproveStatus, LatestApprover = this._context.strApproverId, LatestApprovetime = this._context.dtTime, LatestComment = this._context.strComment, Procinstid = this._context.iProcInstID.ToString(), }; cfBll.ApprovalUpdateState(this._context.strBOID, cf); return(true); }
public IEnumerable <T_CapitalFlowEntity> check(string keyValue, T_CapitalFlowEntity entity) { try { var model = this.BaseRepository().FindEntity <T_CapitalFlowEntity>(entity.CapitalFlow_Id); var parameterFirst = new List <DbParameter>(); parameterFirst.Add(DbParameters.CreateDbParameter("@Company_Id", model.Company_Id)); parameterFirst.Add(DbParameters.CreateDbParameter("@Year", model.Year)); parameterFirst.Add(DbParameters.CreateDbParameter("@Month", model.Month)); StringBuilder strSql = new StringBuilder(); strSql.Append("select * from T_CapitalFlow where Company_Id=@Company_Id and year=@Year and month=@Month and ApprovalState=4 order by orderNo desc"); return(this.BaseRepository().FindList <T_CapitalFlowEntity>(strSql.ToString(), parameterFirst.ToArray())); } catch (Exception ex) { throw new Exception(ex.Message); } }
public void ApprovalUpdateState(string keyValue, T_CapitalFlowEntity entity) { try { var model = this.BaseRepository().FindEntity <T_CapitalFlowEntity>(entity.CapitalFlow_Id); model.ApprovalState = entity.ApprovalState; model.LatestApprover = entity.LatestApprover; model.LatestApprovetime = entity.LatestApprovetime; model.LatestComment = entity.LatestComment; model.Procinstid = entity.Procinstid.ToString(); model.ModifyDate = DateTime.Now; this.BaseRepository().Update(model); } 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_CapitalFlowEntity 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); }
public void SaveFormApp(List <FileModel> uploadFiles, List <T_CapitalFlow_NodeEntity> entity, string year, string month, string keyValue, string CapitalFlow_Title, string Job_Number) { try { IRepository db = new RepositoryFactory().BaseRepository().BeginTrans(); T_CapitalFlowEntity cfEntity = new T_CapitalFlowEntity(); if (!string.IsNullOrEmpty(keyValue)) { db.ExecuteBySql("update T_CapitalFlow_Node set DeleteMark=1 where CapitalFlow_Id='" + keyValue + "'"); cfEntity.Modify(keyValue); cfEntity.Year = int.Parse(year); cfEntity.Month = int.Parse(month); cfEntity.Job_Number = Job_Number; cfEntity.CapitalFlow_Title = CapitalFlow_Title; cfEntity.Account = OperatorProvider.Provider.Current().Account; cfEntity.ApprovalState = 1; if (entity != null) { cfEntity.Company_Id = entity[0].Company_Id; } this.BaseRepository().Update(cfEntity); } else { cfEntity.Create(); cfEntity.CreateDate = DateTime.Now; cfEntity.DeleteMark = 0; cfEntity.Year = int.Parse(year); cfEntity.Month = int.Parse(month); cfEntity.Job_Number = Job_Number; cfEntity.CapitalFlow_Title = CapitalFlow_Title; cfEntity.ApprovalState = 1; if (entity != null) { cfEntity.Company_Id = entity[0].Company_Id; } db.Insert(cfEntity); } try { if (entity != null) { foreach (T_CapitalFlow_NodeEntity item in entity) { item.Create(); item.CapitalFlow_Id = cfEntity.CapitalFlow_Id; item.DeleteMark = 0; item.ClearingAmount = item.ClearingAmount; item.IncomeAmount = item.IncomeAmount; item.PlatformExpensesAmount = item.PlatformExpensesAmount; item.CapitalPoolAdd = item.CapitalPoolAdd; item.Month = int.Parse(month); item.Year = int.Parse(year); string upDate = string.Format("{0}-{1}", year, month); item.UploadDate = Convert.ToDateTime(upDate); db.Insert(item); } } attservice.MapingFiles(cfEntity.CapitalFlow_Id, uploadFiles, db); db.Commit(); } catch (Exception) { db.Rollback(); throw; } } catch (Exception ex) { throw new Exception(ex.Message); } }
public string submitFormApp(List <FileModel> uploadFiles, List <T_CapitalFlow_NodeEntity> entity, string year, string month, string keyValue, string CapitalFlow_Title, string Job_Number) { try { //if (!string.IsNullOrEmpty(keyValue)) //{ // entity.ApprovalState = 3; // entity.Modify(keyValue); // this.BaseRepository().Update(entity); //} //else //{ // entity.Create(); // entity.ApprovalState = 3; // db.Insert(entity); ////} //var parameterFirst = new List<DbParameter>(); //parameterFirst.Add(DbParameters.CreateDbParameter("@Company_Id", entity[0].Company_Id)); //parameterFirst.Add(DbParameters.CreateDbParameter("@Year", year)); //parameterFirst.Add(DbParameters.CreateDbParameter("@Month", month)); //StringBuilder strSql = new StringBuilder(); //strSql.Append("select CapitalFlow_Id from T_CapitalFlow where Company_Id=@Company_Id and year=@Year and month=@Month and ApprovalState<>4"); //IEnumerable<T_CapitalFlowEntity> newEntity = this.BaseRepository().FindList<T_CapitalFlowEntity>(strSql.ToString(), parameterFirst.ToArray()); //if (newEntity.Count() != 0) //{ // foreach (T_CapitalFlowEntity t in newEntity) { // this.BaseRepository().ExecuteBySql("update T_CapitalFlow_Node set DeleteMark=1 where CapitalFlow_Id='" + t.CapitalFlow_Id + "'"); // } //} IRepository db = new RepositoryFactory().BaseRepository().BeginTrans(); T_CapitalFlowEntity cfEntity = new T_CapitalFlowEntity(); if (!string.IsNullOrEmpty(keyValue)) { cfEntity.Company_Id = entity[0].Company_Id; cfEntity.DeleteMark = 0; cfEntity.Year = int.Parse(year); cfEntity.Month = int.Parse(month); cfEntity.CapitalFlow_Title = CapitalFlow_Title; cfEntity.ApprovalState = 1; cfEntity.Account = OperatorProvider.Provider.Current().Account; cfEntity.Job_Number = Job_Number; cfEntity.Modify(keyValue); this.BaseRepository().Update(cfEntity); db.ExecuteBySql("update T_CapitalFlow_Node set DeleteMark=1 where CapitalFlow_Id= '" + keyValue + "'"); } else { cfEntity.Create(); cfEntity.CreateDate = DateTime.Now; cfEntity.DeleteMark = 0; cfEntity.Year = int.Parse(year); cfEntity.Job_Number = Job_Number; cfEntity.Month = int.Parse(month); cfEntity.CapitalFlow_Title = CapitalFlow_Title; cfEntity.ApprovalState = 1; cfEntity.Company_Id = entity[0].Company_Id; db.Insert(cfEntity); } try { foreach (T_CapitalFlow_NodeEntity item in entity) { item.Create(); item.CapitalFlow_Id = cfEntity.CapitalFlow_Id; item.DeleteMark = 0; item.ClearingAmount = item.ClearingAmount; item.IncomeAmount = item.IncomeAmount; item.PlatformExpensesAmount = item.PlatformExpensesAmount; item.CapitalPoolAdd = item.CapitalPoolAdd; item.Month = int.Parse(month); item.Year = int.Parse(year); string upDate = string.Format("{0}-{1}", year, month); item.UploadDate = Convert.ToDateTime(upDate); db.Insert(item); } attservice.MapingFiles(cfEntity.CapitalFlow_Id, uploadFiles, db); db.Commit(); return(cfEntity.CapitalFlow_Id); } catch (Exception) { db.Rollback(); throw; } } catch (Exception ex) { throw new Exception(ex.Message); } }