void executePrivate( ) { /* GeneXus formulas */ /* Output device settings */ AV10SDT_EntityCount.Clear(); /* Using cursor P003R2 */ pr_default.execute(0); while ((pr_default.getStatus(0) != 101)) { A360BAS_TenantTenantCode = P003R2_A360BAS_TenantTenantCode[0]; n360BAS_TenantTenantCode = P003R2_n360BAS_TenantTenantCode[0]; if (String.IsNullOrEmpty(StringUtil.RTrim(A360BAS_TenantTenantCode)) || P003R2_n360BAS_TenantTenantCode[0]) { } else { AV11SDT_EntityCountItem = new SdtSDT_EntityCount(context); AV11SDT_EntityCountItem.gxTpr_Entityname = StringUtil.Trim(A360BAS_TenantTenantCode); AV10SDT_EntityCount.Add(AV11SDT_EntityCountItem, 0); } pr_default.readNext(0); } pr_default.close(0); AV14tNewSDT_EntityCount.Clear(); AV20GXV1 = 1; while (AV20GXV1 <= AV10SDT_EntityCount.Count) { AV12SDT_EntityCountItemCheck = ((SdtSDT_EntityCount)AV10SDT_EntityCount.Item(AV20GXV1)); AV12SDT_EntityCountItemCheck.gxTpr_Value = 0; /* Optimized group. */ /* Using cursor P003R3 */ pr_default.execute(1, new Object[] { AV12SDT_EntityCountItemCheck.gxTpr_Entityname }); aggopt0 = P003R3_Aaggopt0[0]; pr_default.close(1); AV12SDT_EntityCountItemCheck.gxTpr_Value = (long)(AV12SDT_EntityCountItemCheck.gxTpr_Value + aggopt0 * 1); /* End optimized group. */ AV14tNewSDT_EntityCount.Add(AV12SDT_EntityCountItemCheck, 0); AV20GXV1 = (int)(AV20GXV1 + 1); } AV8oContent = AV14tNewSDT_EntityCount.ToJSonString(false); this.cleanup(); }
public override void initialize( ) { AV10SDT_EntityCount = new GXBaseCollection <SdtSDT_EntityCount>(context, "SDT_EntityCount", "DataAnalysisPlatform"); scmdbuf = ""; P003R2_A360BAS_TenantTenantCode = new String[] { "" }; P003R2_n360BAS_TenantTenantCode = new bool[] { false }; A360BAS_TenantTenantCode = ""; AV11SDT_EntityCountItem = new SdtSDT_EntityCount(context); AV14tNewSDT_EntityCount = new GXBaseCollection <SdtSDT_EntityCount>(context, "SDT_EntityCount", "DataAnalysisPlatform"); AV12SDT_EntityCountItemCheck = new SdtSDT_EntityCount(context); P003R3_Aaggopt0 = new long[1]; pr_default = new DataStoreProvider(context, new GeneXus.Programs.zutil_calculatetenant__default(), new Object[][] { new Object[] { P003R2_A360BAS_TenantTenantCode, P003R2_n360BAS_TenantTenantCode } , new Object[] { P003R3_Aaggopt0 } } ); /* GeneXus formulas. */ context.Gx_err = 0; }