public FBEntity GetCompanyBudgetSum(T_FB_COMPANYBUDGETAPPLYMASTER entity) { FBEntity result = null; decimal? budgetYear = entity.BUDGETYEAR; QueryExpression qe = QueryExpression.Equal(FieldName_BudgetYear, budgetYear.Value.ToString()); QueryExpression qeStates = QueryExpression.Equal(FieldName.CheckStates, ((int)CheckStates.UnSubmit).ToString()); QueryExpression qeCompany = QueryExpression.Equal(FieldName.OwnerCompanyID, entity.OWNERCOMPANYID); qe.RelatedExpression = qeStates; qeStates.RelatedExpression = qeCompany; T_FB_COMPANYBUDGETSUMMASTER sumMaster = this.InnerGetEntities <T_FB_COMPANYBUDGETSUMMASTER>(qe).FirstOrDefault(); if (sumMaster == null) { sumMaster = new T_FB_COMPANYBUDGETSUMMASTER(); sumMaster.COMPANYBUDGETSUMMASTERID = Guid.NewGuid().ToString(); sumMaster.COMPANYBUDGETSUMMASTERCODE = "自动生成"; sumMaster.CREATEUSERID = SYSTEM_USER_ID; sumMaster.CREATEUSERNAME = "******"; sumMaster.CREATEDATE = System.DateTime.Now; sumMaster.UPDATEUSERID = SYSTEM_USER_ID; sumMaster.UPDATEDATE = System.DateTime.Now; sumMaster.CREATECOMPANYID = SYSTEM_USER_ID; sumMaster.CREATECOMPANYNAME = "系统生成"; sumMaster.CREATEDEPARTMENTID = SYSTEM_USER_ID; sumMaster.CREATEDEPARTMENTNAME = "系统生成"; sumMaster.CREATEPOSTID = SYSTEM_USER_ID; sumMaster.CREATEPOSTNAME = "系统生成"; sumMaster.BUDGETYEAR = budgetYear; sumMaster.OWNERCOMPANYID = entity.OWNERCOMPANYID; sumMaster.OWNERCOMPANYNAME = entity.OWNERCOMPANYNAME; sumMaster.OWNERDEPARTMENTID = SYSTEM_USER_ID; sumMaster.OWNERDEPARTMENTNAME = "系统生成"; sumMaster.OWNERPOSTID = SYSTEM_USER_ID; sumMaster.OWNERPOSTNAME = "系统生成"; sumMaster.OWNERID = SYSTEM_USER_ID; sumMaster.OWNERNAME = "系统生成"; sumMaster.SUMLEVEL = 0; //0:代表当前汇总单不走自定义汇总流程;1:代表当前汇总单走自定义汇总流程 sumMaster.CHECKSTATES = (int)CheckStates.UnSubmit; sumMaster.EDITSTATES = (int)EditStates.Actived; result = sumMaster.ToFBEntity(); result.FBEntityState = FBEntityState.Added; } else { result = sumMaster.ToFBEntity(); result.FBEntityState = FBEntityState.Modified; } return(result); }
public FBEntity GetCompanyBudgetSum(T_FB_COMPANYBUDGETAPPLYMASTER entity) { FBEntity result = null; decimal? budgetYear = entity.BUDGETYEAR; QueryExpression qe = QueryExpression.Equal(FieldName_BudgetYear, budgetYear.Value.ToString()); QueryExpression qeStates = QueryExpression.Equal(FieldName.CheckStates, ((int)CheckStates.UnSubmit).ToString()); QueryExpression qeCompany = QueryExpression.Equal(FieldName.OwnerCompanyID, entity.OWNERCOMPANYID); qe.RelatedExpression = qeStates; qeStates.RelatedExpression = qeCompany; T_FB_COMPANYBUDGETSUMMASTER sumMaster = this.InnerGetEntities<T_FB_COMPANYBUDGETSUMMASTER>(qe).FirstOrDefault(); if (sumMaster == null) { sumMaster = new T_FB_COMPANYBUDGETSUMMASTER(); sumMaster.COMPANYBUDGETSUMMASTERID = Guid.NewGuid().ToString(); sumMaster.COMPANYBUDGETSUMMASTERCODE = "自动生成"; sumMaster.CREATEUSERID = SYSTEM_USER_ID; sumMaster.CREATEUSERNAME = "******"; sumMaster.CREATEDATE = System.DateTime.Now; sumMaster.UPDATEUSERID = SYSTEM_USER_ID; sumMaster.UPDATEDATE = System.DateTime.Now; sumMaster.CREATECOMPANYID = SYSTEM_USER_ID; sumMaster.CREATECOMPANYNAME = "系统生成"; sumMaster.CREATEDEPARTMENTID = SYSTEM_USER_ID; sumMaster.CREATEDEPARTMENTNAME = "系统生成"; sumMaster.CREATEPOSTID = SYSTEM_USER_ID; sumMaster.CREATEPOSTNAME = "系统生成"; sumMaster.BUDGETYEAR = budgetYear; sumMaster.OWNERCOMPANYID = entity.OWNERCOMPANYID; sumMaster.OWNERCOMPANYNAME = entity.OWNERCOMPANYNAME; sumMaster.OWNERDEPARTMENTID = SYSTEM_USER_ID; sumMaster.OWNERDEPARTMENTNAME = "系统生成"; sumMaster.OWNERPOSTID = SYSTEM_USER_ID; sumMaster.OWNERPOSTNAME = "系统生成"; sumMaster.OWNERID = SYSTEM_USER_ID; sumMaster.OWNERNAME = "系统生成"; sumMaster.SUMLEVEL = 0; //0:代表当前汇总单不走自定义汇总流程;1:代表当前汇总单走自定义汇总流程 sumMaster.CHECKSTATES = (int)CheckStates.UnSubmit; sumMaster.EDITSTATES = (int)EditStates.Actived; result = sumMaster.ToFBEntity(); result.FBEntityState = FBEntityState.Added; } else { result = sumMaster.ToFBEntity(); result.FBEntityState = FBEntityState.Modified; } return result; }
//自定义汇总 public bool CreateCompanyBudgetSumSetMaster(FBEntity fbMaster) { bool bRes = false; T_FB_COMPANYBUDGETSUMMASTER Master = fbMaster.Entity as T_FB_COMPANYBUDGETSUMMASTER; foreach (var entity in Master.T_FB_COMPANYBUDGETSUMDETAIL) { T_FB_COMPANYBUDGETSUMDETAIL detail = new T_FB_COMPANYBUDGETSUMDETAIL(); detail.COMPANYBUDGETSUMDETAILID = Guid.NewGuid().ToString(); detail.CREATEUSERID = SYSTEM_USER_ID; detail.CREATEDATE = System.DateTime.Now; detail.UPDATEUSERID = SYSTEM_USER_ID; detail.UPDATEDATE = System.DateTime.Now; detail.T_FB_COMPANYBUDGETAPPLYMASTER = entity.T_FB_COMPANYBUDGETAPPLYMASTER; FBEntity fbDetail = detail.ToFBEntity(); fbDetail.FBEntityState = FBEntityState.Added; List <FBEntity> fbSumMasterlist = new List <FBEntity>(); //查找汇总节点设置 有则新增汇总记录 FBEntity fbSumMaster = new FBEntity(); QueryExpression qeDetail = QueryExpression.Equal(FieldName.OwnerCompanyID, entity.T_FB_COMPANYBUDGETAPPLYMASTER.OWNERCOMPANYID).And(FieldName.EditStates, "1"); qeDetail.QueryType = "T_FB_SUMSETTINGSDETAIL"; T_FB_SUMSETTINGSDETAIL detailset = GetEntities <T_FB_SUMSETTINGSDETAIL>(qeDetail).FirstOrDefault(); T_FB_SUMSETTINGSMASTER masterset = null; if (detailset != null) { QueryExpression qeMaster = QueryExpression.Equal("SUMSETTINGSMASTERID", detailset.T_FB_SUMSETTINGSMASTERReference.EntityKey.EntityKeyValues[0].Value.ToString()).And(FieldName.EditStates, "1"); qeMaster.QueryType = "T_FB_SUMSETTINGSMASTER"; masterset = GetEntities <T_FB_SUMSETTINGSMASTER>(qeMaster).FirstOrDefault(); if (masterset != null) { fbSumMaster = GetCompanyBudgetSumSet(entity, masterset); detail.T_FB_COMPANYBUDGETSUMMASTER = fbSumMaster.Entity as T_FB_COMPANYBUDGETSUMMASTER; fbSumMaster.AddFBEntities <T_FB_COMPANYBUDGETSUMDETAIL>(new List <FBEntity> { fbDetail }); fbSumMasterlist.Add(fbSumMaster); Master.PARENTID = detail.T_FB_COMPANYBUDGETSUMMASTER.COMPANYBUDGETSUMMASTERID; Master.SUMSETTINGSMASTERID = masterset.SUMSETTINGSMASTERID; Master.SUMLEVEL = 1; //0:代表当前汇总单不走自定义汇总流程;1:代表当前汇总单走自定义汇总流程 fbMaster.Entity = Master; fbMaster.FBEntityState = FBEntityState.Modified; fbSumMasterlist.Add(fbMaster); this.FBEntityBLLSaveListNoTrans(fbSumMasterlist); // this.InnerSave(fbSumMaster); } } } bRes = true; return(bRes); }
/// <summary> /// 获取T_FB_COMPANYBUDGETSUMMASTER信息 /// </summary> /// <param name="strCompanyBudgetSumMasterId">主键索引</param> /// <returns></returns> public T_FB_COMPANYBUDGETSUMMASTER GetCompanyBudgetSumMasterByID(string strCompanyBudgetSumMasterId) { if (string.IsNullOrEmpty(strCompanyBudgetSumMasterId)) { return(null); } CompanyBudgetSumMasterDAL dalCompanyBudgetSumMaster = new CompanyBudgetSumMasterDAL(); StringBuilder strFilter = new StringBuilder(); List <string> objArgs = new List <string>(); if (!string.IsNullOrEmpty(strCompanyBudgetSumMasterId)) { strFilter.Append(" COMPANYBUDGETSUMMASTERID == @0"); objArgs.Add(strCompanyBudgetSumMasterId); } T_FB_COMPANYBUDGETSUMMASTER entRd = dalCompanyBudgetSumMaster.GetCompanyBudgetSumMasterRdByMultSearch(strFilter.ToString(), objArgs.ToArray()); return(entRd); }
public void AddToT_FB_COMPANYBUDGETSUMMASTER(T_FB_COMPANYBUDGETSUMMASTER t_FB_COMPANYBUDGETSUMMASTER) { base.AddObject("T_FB_COMPANYBUDGETSUMMASTER", t_FB_COMPANYBUDGETSUMMASTER); }
public static T_FB_COMPANYBUDGETSUMMASTER CreateT_FB_COMPANYBUDGETSUMMASTER(string cOMPANYBUDGETSUMMASTERID, decimal eDITSTATES, decimal cHECKSTATES, string oWNERID, string oWNERPOSTID, string oWNERDEPARTMENTID, string oWNERCOMPANYID, string cREATEUSERID, global::System.DateTime cREATEDATE, string cREATECOMPANYID, string cREATEDEPARTMENTID, string cREATEPOSTID, string uPDATEUSERID, global::System.DateTime uPDATEDATE) { T_FB_COMPANYBUDGETSUMMASTER t_FB_COMPANYBUDGETSUMMASTER = new T_FB_COMPANYBUDGETSUMMASTER(); t_FB_COMPANYBUDGETSUMMASTER.COMPANYBUDGETSUMMASTERID = cOMPANYBUDGETSUMMASTERID; t_FB_COMPANYBUDGETSUMMASTER.EDITSTATES = eDITSTATES; t_FB_COMPANYBUDGETSUMMASTER.CHECKSTATES = cHECKSTATES; t_FB_COMPANYBUDGETSUMMASTER.OWNERID = oWNERID; t_FB_COMPANYBUDGETSUMMASTER.OWNERPOSTID = oWNERPOSTID; t_FB_COMPANYBUDGETSUMMASTER.OWNERDEPARTMENTID = oWNERDEPARTMENTID; t_FB_COMPANYBUDGETSUMMASTER.OWNERCOMPANYID = oWNERCOMPANYID; t_FB_COMPANYBUDGETSUMMASTER.CREATEUSERID = cREATEUSERID; t_FB_COMPANYBUDGETSUMMASTER.CREATEDATE = cREATEDATE; t_FB_COMPANYBUDGETSUMMASTER.CREATECOMPANYID = cREATECOMPANYID; t_FB_COMPANYBUDGETSUMMASTER.CREATEDEPARTMENTID = cREATEDEPARTMENTID; t_FB_COMPANYBUDGETSUMMASTER.CREATEPOSTID = cREATEPOSTID; t_FB_COMPANYBUDGETSUMMASTER.UPDATEUSERID = uPDATEUSERID; t_FB_COMPANYBUDGETSUMMASTER.UPDATEDATE = uPDATEDATE; return t_FB_COMPANYBUDGETSUMMASTER; }