public static GxSimpleCollection <short> getValues( ) { GxSimpleCollection <short> value = new GxSimpleCollection <short>(); ArrayList aKeys = new ArrayList(domain.Keys); aKeys.Sort(); foreach (short key in aKeys) { value.Add(key); } return(value); }
public void executeSubmit(GxSimpleCollection <long> aP0_iJC_ProviderIDs, out GxSimpleCollection <short> aP1_oSecUserIds) { zutil_finduserifinprovider objzutil_finduserifinprovider; objzutil_finduserifinprovider = new zutil_finduserifinprovider(); objzutil_finduserifinprovider.AV8iJC_ProviderIDs = aP0_iJC_ProviderIDs; objzutil_finduserifinprovider.AV9oSecUserIds = new GxSimpleCollection <short>(); objzutil_finduserifinprovider.context.SetSubmitInitialConfig(context); objzutil_finduserifinprovider.initialize(); ThreadPool.QueueUserWorkItem(PropagateCulture(new WaitCallback(executePrivateCatch)), objzutil_finduserifinprovider); aP1_oSecUserIds = this.AV9oSecUserIds; }
public override void initialize( ) { AV10tNowDate = (DateTime)(DateTime.MinValue); AV11tJWTTokenContent = ""; AV15tAllCookieName = new GxSimpleCollection <String>(); AV14websession = context.GetSession(); pr_default = new DataStoreProvider(context, new GeneXus.Programs.wb_logout__default(), new Object[][] { } ); /* GeneXus formulas. */ context.Gx_err = 0; }
public override void initialize( ) { GXSoapHTTPRequest = new GxHttpRequest(context); GXSoapXMLReader = new GXXMLReader(context.GetPhysicalPath()); GXSoapHTTPResponse = new GxHttpResponse(context); GXSoapXMLWriter = new GXXMLWriter(context.GetPhysicalPath()); currSoapErrmsg = ""; currMethod = ""; sTagName = ""; scmdbuf = ""; P000O2_A44REF_CGRAL_DESP_CARGA = new String[] { "" }; P000O2_A45REF_CGRAL_DESP_TIPO = new String[] { "" }; P000O2_n45REF_CGRAL_DESP_TIPO = new bool[] { false }; P000O2_A46REF_CGRAL_DESP_TON_TARIF = new long[1]; P000O2_n46REF_CGRAL_DESP_TON_TARIF = new bool[] { false }; P000O2_A47REF_CGRAL_DESP_TARIFA = new decimal[1]; P000O2_A48REF_CGRAL_DESP_ID_TON_TARIF = new short[1]; P000O2_A49REF_CGRAL_DESP_ID = new short[1]; A44REF_CGRAL_DESP_CARGA = ""; A45REF_CGRAL_DESP_TIPO = ""; AV12SdtResultado = new SdtSdtResultado(context); P000O3_A44REF_CGRAL_DESP_CARGA = new String[] { "" }; P000O3_A45REF_CGRAL_DESP_TIPO = new String[] { "" }; P000O3_n45REF_CGRAL_DESP_TIPO = new bool[] { false }; P000O3_A46REF_CGRAL_DESP_TON_TARIF = new long[1]; P000O3_n46REF_CGRAL_DESP_TON_TARIF = new bool[] { false }; P000O3_A47REF_CGRAL_DESP_TARIFA = new decimal[1]; P000O3_A48REF_CGRAL_DESP_ID_TON_TARIF = new short[1]; P000O3_A49REF_CGRAL_DESP_ID = new short[1]; AV11REF_CGRAL_DESP_CARGA_LIST = new GxSimpleCollection(); P000O4_A44REF_CGRAL_DESP_CARGA = new String[] { "" }; P000O4_A47REF_CGRAL_DESP_TARIFA = new decimal[1]; P000O4_A48REF_CGRAL_DESP_ID_TON_TARIF = new short[1]; P000O4_A49REF_CGRAL_DESP_ID = new short[1]; pr_default = new DataStoreProvider(context, new GeneXus.Programs.awscalcularrefcgraldesp__default(), new Object[][] { new Object[] { P000O2_A44REF_CGRAL_DESP_CARGA, P000O2_A45REF_CGRAL_DESP_TIPO, P000O2_n45REF_CGRAL_DESP_TIPO, P000O2_A46REF_CGRAL_DESP_TON_TARIF, P000O2_n46REF_CGRAL_DESP_TON_TARIF, P000O2_A47REF_CGRAL_DESP_TARIFA, P000O2_A48REF_CGRAL_DESP_ID_TON_TARIF, P000O2_A49REF_CGRAL_DESP_ID } , new Object[] { P000O3_A44REF_CGRAL_DESP_CARGA, P000O3_A45REF_CGRAL_DESP_TIPO, P000O3_n45REF_CGRAL_DESP_TIPO, P000O3_A46REF_CGRAL_DESP_TON_TARIF, P000O3_n46REF_CGRAL_DESP_TON_TARIF, P000O3_A47REF_CGRAL_DESP_TARIFA, P000O3_A48REF_CGRAL_DESP_ID_TON_TARIF, P000O3_A49REF_CGRAL_DESP_ID } , new Object[] { P000O4_A44REF_CGRAL_DESP_CARGA, P000O4_A47REF_CGRAL_DESP_TARIFA, P000O4_A48REF_CGRAL_DESP_ID_TON_TARIF, P000O4_A49REF_CGRAL_DESP_ID } } ); /* GeneXus formulas. */ context.Gx_err = 0; }
public void executeSubmit(String aP0_iBAS_TenantTenantCode, bool aP1_IsManager, out GxSimpleCollection <long> aP2_oBR_Information_ID) { zbr_checkinfoifincode objzbr_checkinfoifincode; objzbr_checkinfoifincode = new zbr_checkinfoifincode(); objzbr_checkinfoifincode.AV9iBAS_TenantTenantCode = aP0_iBAS_TenantTenantCode; objzbr_checkinfoifincode.AV18IsManager = aP1_IsManager; objzbr_checkinfoifincode.AV11oBR_Information_ID = new GxSimpleCollection <long>(); objzbr_checkinfoifincode.context.SetSubmitInitialConfig(context); objzbr_checkinfoifincode.initialize(); ThreadPool.QueueUserWorkItem(PropagateCulture(new WaitCallback(executePrivateCatch)), objzbr_checkinfoifincode); aP2_oBR_Information_ID = this.AV11oBR_Information_ID; }
public override void initialize( ) { AV22Options = new GxSimpleCollection <String>(); AV25OptionsDesc = new GxSimpleCollection <String>(); AV27OptionIndexes = new GxSimpleCollection <String>(); AV38WWPContext = new GeneXus.Programs.wwpbaseobjects.SdtWWPContext(context); AV30Session = context.GetSession(); AV32GridState = new GeneXus.Programs.wwpbaseobjects.SdtWWPGridState(context); AV33GridStateFilterValue = new GeneXus.Programs.wwpbaseobjects.SdtWWPGridState_FilterValue(context); AV41SecFunctionalityKey = ""; AV37SecFunctionalityDescription = ""; AV10TFSecFunctionalityKey = ""; AV11TFSecFunctionalityKey_Sel = ""; AV12TFSecFunctionalityDescription = ""; AV13TFSecFunctionalityDescription_Sel = ""; AV46WWPBaseObjects_SecFunctionalityWWDS_1_Secfunctionalitykey = ""; AV47WWPBaseObjects_SecFunctionalityWWDS_2_Secfunctionalitydescription = ""; AV48WWPBaseObjects_SecFunctionalityWWDS_3_Tfsecfunctionalitykey = ""; AV49WWPBaseObjects_SecFunctionalityWWDS_4_Tfsecfunctionalitykey_sel = ""; AV50WWPBaseObjects_SecFunctionalityWWDS_5_Tfsecfunctionalitydescription = ""; AV51WWPBaseObjects_SecFunctionalityWWDS_6_Tfsecfunctionalitydescription_sel = ""; scmdbuf = ""; lV46WWPBaseObjects_SecFunctionalityWWDS_1_Secfunctionalitykey = ""; lV47WWPBaseObjects_SecFunctionalityWWDS_2_Secfunctionalitydescription = ""; lV48WWPBaseObjects_SecFunctionalityWWDS_3_Tfsecfunctionalitykey = ""; lV50WWPBaseObjects_SecFunctionalityWWDS_5_Tfsecfunctionalitydescription = ""; A3SecFunctionalityKey = ""; A8SecFunctionalityDescription = ""; P000Z2_A3SecFunctionalityKey = new String[] { "" }; P000Z2_A8SecFunctionalityDescription = new String[] { "" }; P000Z2_A1SecFunctionalityId = new long[1]; AV21Option = ""; P000Z3_A8SecFunctionalityDescription = new String[] { "" }; P000Z3_A3SecFunctionalityKey = new String[] { "" }; P000Z3_A1SecFunctionalityId = new long[1]; pr_default = new DataStoreProvider(context, new GeneXus.Programs.wwpbaseobjects.secfunctionalitywwgetfilterdata__default(), new Object[][] { new Object[] { P000Z2_A3SecFunctionalityKey, P000Z2_A8SecFunctionalityDescription, P000Z2_A1SecFunctionalityId } , new Object[] { P000Z3_A8SecFunctionalityDescription, P000Z3_A3SecFunctionalityKey, P000Z3_A1SecFunctionalityId } } ); /* GeneXus formulas. */ context.Gx_err = 0; }
protected Object[] conditional_P00212(IGxContext context, long A87JC_ProviderID, GxSimpleCollection <long> AV8iJC_ProviderIDs) { String sWhereString = ""; String scmdbuf; Object[] GXv_Object1; GXv_Object1 = new Object [2]; scmdbuf = "SELECT [JC_ProviderID], [SecUserId] FROM [JC_ProviderSecUser] WITH (NOLOCK)"; scmdbuf = scmdbuf + " WHERE (" + new GxDbmsUtils(new GxSqlServer()).ValueList(AV8iJC_ProviderIDs, "[JC_ProviderID] IN (", ")") + ")"; scmdbuf = scmdbuf + sWhereString; scmdbuf = scmdbuf + " ORDER BY [SecUserId], [JC_ProviderID]"; GXv_Object1[0] = scmdbuf; return(GXv_Object1); }
static public GxSimpleCollection <string> Split(string txt, string rex) { resetError(); try { Regex r = new Regex(rex, RegexOptions.ExplicitCapture | RegexOptions.Multiline); GxSimpleCollection <string> c = new GxSimpleCollection <string>(); c.AddRange(r.Split(normalizeText(txt))); return(c); } catch (Exception e) { setError(1, e.Message); } return(new GxSimpleCollection <string>()); }
public override void initialize( ) { AV38Options = new GxSimpleCollection <String>(); AV41OptionsDesc = new GxSimpleCollection <String>(); AV43OptionIndexes = new GxSimpleCollection <String>(); AV9WWPContext = new GeneXus.Programs.wwpbaseobjects.SdtWWPContext(context); AV46Session = context.GetSession(); AV48GridState = new GeneXus.Programs.wwpbaseobjects.SdtWWPGridState(context); AV49GridStateFilterValue = new GeneXus.Programs.wwpbaseobjects.SdtWWPGridState_FilterValue(context); AV13TFview_NE_Department = ""; AV14TFview_NE_Department_Sel = ""; AV15TFview_NE_ENCType = ""; AV16TFview_NE_ENCType_Sel = ""; AV57WebPanel4DS_3_Tfview_ne_department = ""; AV58WebPanel4DS_4_Tfview_ne_department_sel = ""; AV59WebPanel4DS_5_Tfview_ne_enctype = ""; AV60WebPanel4DS_6_Tfview_ne_enctype_sel = ""; scmdbuf = ""; lV57WebPanel4DS_3_Tfview_ne_department = ""; lV59WebPanel4DS_5_Tfview_ne_enctype = ""; A550view_NE_Department = ""; A551view_NE_ENCType = ""; P004M2_A550view_NE_Department = new String[] { "" }; P004M2_n550view_NE_Department = new bool[] { false }; P004M2_A551view_NE_ENCType = new String[] { "" }; P004M2_n551view_NE_ENCType = new bool[] { false }; P004M2_A549view_NE_EncounterID = new long[1]; AV37Option = ""; P004M3_A551view_NE_ENCType = new String[] { "" }; P004M3_n551view_NE_ENCType = new bool[] { false }; P004M3_A550view_NE_Department = new String[] { "" }; P004M3_n550view_NE_Department = new bool[] { false }; P004M3_A549view_NE_EncounterID = new long[1]; pr_default = new DataStoreProvider(context, new GeneXus.Programs.webpanel4getfilterdata__default(), new Object[][] { new Object[] { P004M2_A550view_NE_Department, P004M2_n550view_NE_Department, P004M2_A551view_NE_ENCType, P004M2_n551view_NE_ENCType, P004M2_A549view_NE_EncounterID } , new Object[] { P004M3_A551view_NE_ENCType, P004M3_n551view_NE_ENCType, P004M3_A550view_NE_Department, P004M3_n550view_NE_Department, P004M3_A549view_NE_EncounterID } } ); /* GeneXus formulas. */ context.Gx_err = 0; }
public GxSimpleCollection <string> GetUsedVariables() { FastTokenizer ft = new FastTokenizer(getTokenizerExpression(expr)); GxSimpleCollection <string> ls = new GxSimpleCollection <string>(); string tk; tk = ft.NextToken(); while (!ft.EOF()) { if (tk.IndexOf("(") == -1 && System.Char.IsDigit(tk[0])) { ls.Add(tk); } tk = ft.NextToken(); } return(ls); }
public override void initialize( ) { AV26Options = new GxSimpleCollection <String>(); AV29OptionsDesc = new GxSimpleCollection <String>(); AV31OptionIndexes = new GxSimpleCollection <String>(); AV9WWPContext = new GeneXus.Programs.wwpbaseobjects.SdtWWPContext(context); AV34Session = context.GetSession(); AV36GridState = new GeneXus.Programs.wwpbaseobjects.SdtWWPGridState(context); AV37GridStateFilterValue = new GeneXus.Programs.wwpbaseobjects.SdtWWPGridState_FilterValue(context); AV15TFBR_Encounter_RefuseReason_Reason = ""; AV16TFBR_Encounter_RefuseReason_Reason_Sel = ""; AV17TFBR_Encounter_RefuseReason_NoApproveDate = (DateTime)(DateTime.MinValue); AV18TFBR_Encounter_RefuseReason_NoApproveDate_To = (DateTime)(DateTime.MinValue); AV19TFBR_Encounter_RefuseReason_Status_SelsJson = ""; AV20TFBR_Encounter_RefuseReason_Status_Sels = new GxSimpleCollection <short>(); AV47BR_Encounter_RefuseReasonWWDS_5_Tfbr_encounter_refusereason_reason = ""; AV48BR_Encounter_RefuseReasonWWDS_6_Tfbr_encounter_refusereason_reason_sel = ""; AV49BR_Encounter_RefuseReasonWWDS_7_Tfbr_encounter_refusereason_noapprovedate = (DateTime)(DateTime.MinValue); AV50BR_Encounter_RefuseReasonWWDS_8_Tfbr_encounter_refusereason_noapprovedate_to = (DateTime)(DateTime.MinValue); AV51BR_Encounter_RefuseReasonWWDS_9_Tfbr_encounter_refusereason_status_sels = new GxSimpleCollection <short>(); scmdbuf = ""; lV47BR_Encounter_RefuseReasonWWDS_5_Tfbr_encounter_refusereason_reason = ""; A349BR_Encounter_RefuseReason_Reason = ""; A350BR_Encounter_RefuseReason_NoApproveDate = (DateTime)(DateTime.MinValue); P003A2_A349BR_Encounter_RefuseReason_Reason = new String[] { "" }; P003A2_n349BR_Encounter_RefuseReason_Reason = new bool[] { false }; P003A2_A351BR_Encounter_RefuseReason_Status = new short[1]; P003A2_n351BR_Encounter_RefuseReason_Status = new bool[] { false }; P003A2_A350BR_Encounter_RefuseReason_NoApproveDate = new DateTime[] { DateTime.MinValue }; P003A2_n350BR_Encounter_RefuseReason_NoApproveDate = new bool[] { false }; P003A2_A19BR_EncounterID = new long[1]; P003A2_A348BR_Encounter_RefuseReasonID = new long[1]; AV25Option = ""; pr_default = new DataStoreProvider(context, new GeneXus.Programs.br_encounter_refusereasonwwgetfilterdata__default(), new Object[][] { new Object[] { P003A2_A349BR_Encounter_RefuseReason_Reason, P003A2_n349BR_Encounter_RefuseReason_Reason, P003A2_A351BR_Encounter_RefuseReason_Status, P003A2_n351BR_Encounter_RefuseReason_Status, P003A2_A350BR_Encounter_RefuseReason_NoApproveDate, P003A2_n350BR_Encounter_RefuseReason_NoApproveDate, P003A2_A19BR_EncounterID, P003A2_A348BR_Encounter_RefuseReasonID } } ); /* GeneXus formulas. */ context.Gx_err = 0; }
protected Object[] conditional_P00423(IGxContext context, long A85BR_Information_ID, GxSimpleCollection <long> AV12oFirstBR_Information_ID, String A366DataPackage, GxSimpleCollection <String> AV16tDataPackage) { String sWhereString = ""; String scmdbuf; Object[] GXv_Object1; GXv_Object1 = new Object [2]; scmdbuf = "SELECT [DataPackage], [BR_Information_ID] FROM [BR_PatientReEntity] WITH (NOLOCK)"; scmdbuf = scmdbuf + " WHERE (" + new GxDbmsUtils(new GxSqlServer()).ValueList(AV12oFirstBR_Information_ID, "[BR_Information_ID] IN (", ")") + ")"; scmdbuf = scmdbuf + " and (" + new GxDbmsUtils(new GxSqlServer()).ValueList(AV16tDataPackage, "[DataPackage] IN (", ")") + ")"; scmdbuf = scmdbuf + sWhereString; scmdbuf = scmdbuf + " ORDER BY [BR_Information_ID], [DataPackage]"; GXv_Object1[0] = scmdbuf; return(GXv_Object1); }
public override void initialize( ) { AV19Options = new GxSimpleCollection <String>(); AV22OptionsDesc = new GxSimpleCollection <String>(); AV24OptionIndexes = new GxSimpleCollection <String>(); AV46WWPContext = new GeneXus.Programs.wwpbaseobjects.SdtWWPContext(context); AV27Session = context.GetSession(); AV29GridState = new GeneXus.Programs.wwpbaseobjects.SdtWWPGridState(context); AV30GridStateFilterValue = new GeneXus.Programs.wwpbaseobjects.SdtWWPGridState_FilterValue(context); AV10TFSecRoleName = ""; AV11TFSecRoleName_Sel = ""; AV12TFSecRoleDescription = ""; AV13TFSecRoleDescription_Sel = ""; AV51WWPBaseObjects_SecRoleWWDS_1_Tfsecrolename = ""; AV52WWPBaseObjects_SecRoleWWDS_2_Tfsecrolename_sel = ""; AV53WWPBaseObjects_SecRoleWWDS_3_Tfsecroledescription = ""; AV54WWPBaseObjects_SecRoleWWDS_4_Tfsecroledescription_sel = ""; scmdbuf = ""; lV51WWPBaseObjects_SecRoleWWDS_1_Tfsecrolename = ""; lV53WWPBaseObjects_SecRoleWWDS_3_Tfsecroledescription = ""; A13SecRoleName = ""; A12SecRoleDescription = ""; P00162_A13SecRoleName = new String[] { "" }; P00162_A12SecRoleDescription = new String[] { "" }; P00162_A4SecRoleId = new short[1]; AV18Option = ""; P00163_A12SecRoleDescription = new String[] { "" }; P00163_A13SecRoleName = new String[] { "" }; P00163_A4SecRoleId = new short[1]; pr_default = new DataStoreProvider(context, new GeneXus.Programs.wwpbaseobjects.secrolewwgetfilterdata__default(), new Object[][] { new Object[] { P00162_A13SecRoleName, P00162_A12SecRoleDescription, P00162_A4SecRoleId } , new Object[] { P00163_A12SecRoleDescription, P00163_A13SecRoleName, P00163_A4SecRoleId } } ); /* GeneXus formulas. */ context.Gx_err = 0; }
public override void initialize( ) { AV19Options = new GxSimpleCollection <String>(); AV22OptionsDesc = new GxSimpleCollection <String>(); AV24OptionIndexes = new GxSimpleCollection <String>(); AV33WWPContext = new GeneXus.Programs.wwpbaseobjects.SdtWWPContext(context); AV27Session = context.GetSession(); AV29GridState = new GeneXus.Programs.wwpbaseobjects.SdtWWPGridState(context); AV30GridStateFilterValue = new GeneXus.Programs.wwpbaseobjects.SdtWWPGridState_FilterValue(context); AV34SecRoleName = ""; AV10TFSecRoleName = ""; AV11TFSecRoleName_Sel = ""; AV12TFSecRoleDescription = ""; AV13TFSecRoleDescription_Sel = ""; scmdbuf = ""; lV34SecRoleName = ""; lV10TFSecRoleName = ""; lV12TFSecRoleDescription = ""; A13SecRoleName = ""; A12SecRoleDescription = ""; P000W2_A4SecRoleId = new short[1]; P000W2_A1SecFunctionalityId = new long[1]; P000W2_A13SecRoleName = new String[] { "" }; P000W2_A12SecRoleDescription = new String[] { "" }; AV18Option = ""; P000W3_A4SecRoleId = new short[1]; P000W3_A1SecFunctionalityId = new long[1]; P000W3_A12SecRoleDescription = new String[] { "" }; P000W3_A13SecRoleName = new String[] { "" }; pr_default = new DataStoreProvider(context, new GeneXus.Programs.wwpbaseobjects.secfunctionalitysecfunctionalityrolewcgetfilterdata__default(), new Object[][] { new Object[] { P000W2_A4SecRoleId, P000W2_A1SecFunctionalityId, P000W2_A13SecRoleName, P000W2_A12SecRoleDescription } , new Object[] { P000W3_A4SecRoleId, P000W3_A1SecFunctionalityId, P000W3_A12SecRoleDescription, P000W3_A13SecRoleName } } ); /* GeneXus formulas. */ context.Gx_err = 0; }
public override void initialize( ) { scmdbuf = ""; P000A2_A44REF_CGRAL_DESP_CARGA = new String[] { "" }; P000A2_A45REF_CGRAL_DESP_TIPO = new String[] { "" }; P000A2_n45REF_CGRAL_DESP_TIPO = new bool[] { false }; P000A2_A46REF_CGRAL_DESP_TON_TARIF = new long[1]; P000A2_n46REF_CGRAL_DESP_TON_TARIF = new bool[] { false }; P000A2_A47REF_CGRAL_DESP_TARIFA = new decimal[1]; P000A2_A48REF_CGRAL_DESP_ID_TON_TARIF = new short[1]; P000A2_A49REF_CGRAL_DESP_ID = new short[1]; A44REF_CGRAL_DESP_CARGA = ""; A45REF_CGRAL_DESP_TIPO = ""; P000A3_A44REF_CGRAL_DESP_CARGA = new String[] { "" }; P000A3_A45REF_CGRAL_DESP_TIPO = new String[] { "" }; P000A3_n45REF_CGRAL_DESP_TIPO = new bool[] { false }; P000A3_A46REF_CGRAL_DESP_TON_TARIF = new long[1]; P000A3_n46REF_CGRAL_DESP_TON_TARIF = new bool[] { false }; P000A3_A47REF_CGRAL_DESP_TARIFA = new decimal[1]; P000A3_A48REF_CGRAL_DESP_ID_TON_TARIF = new short[1]; P000A3_A49REF_CGRAL_DESP_ID = new short[1]; AV16REF_CGRAL_DESP_CARGA_LIST = new GxSimpleCollection(); P000A4_A44REF_CGRAL_DESP_CARGA = new String[] { "" }; P000A4_A47REF_CGRAL_DESP_TARIFA = new decimal[1]; P000A4_A48REF_CGRAL_DESP_ID_TON_TARIF = new short[1]; P000A4_A49REF_CGRAL_DESP_ID = new short[1]; pr_default = new DataStoreProvider(context, new GeneXus.Programs.calcularrefcgraldesp__default(), new Object[][] { new Object[] { P000A2_A44REF_CGRAL_DESP_CARGA, P000A2_A45REF_CGRAL_DESP_TIPO, P000A2_n45REF_CGRAL_DESP_TIPO, P000A2_A46REF_CGRAL_DESP_TON_TARIF, P000A2_n46REF_CGRAL_DESP_TON_TARIF, P000A2_A47REF_CGRAL_DESP_TARIFA, P000A2_A48REF_CGRAL_DESP_ID_TON_TARIF, P000A2_A49REF_CGRAL_DESP_ID } , new Object[] { P000A3_A44REF_CGRAL_DESP_CARGA, P000A3_A45REF_CGRAL_DESP_TIPO, P000A3_n45REF_CGRAL_DESP_TIPO, P000A3_A46REF_CGRAL_DESP_TON_TARIF, P000A3_n46REF_CGRAL_DESP_TON_TARIF, P000A3_A47REF_CGRAL_DESP_TARIFA, P000A3_A48REF_CGRAL_DESP_ID_TON_TARIF, P000A3_A49REF_CGRAL_DESP_ID } , new Object[] { P000A4_A44REF_CGRAL_DESP_CARGA, P000A4_A47REF_CGRAL_DESP_TARIFA, P000A4_A48REF_CGRAL_DESP_ID_TON_TARIF, P000A4_A49REF_CGRAL_DESP_ID } } ); /* GeneXus formulas. */ context.Gx_err = 0; }
public String GetPurchases(GxUserType gxStoreConfig, GxUserType purchasesInformation) { GxSimpleCollection <GxUserType> gxStorePurchases = new GxSimpleCollection <GxUserType>(); PurchasesInformation pInformation = JSONHelper.Deserialize <PurchasesInformation>(purchasesInformation.ToJSonString());; IStoreManager storeMgr; ErrCode = GetManager(gxStoreConfig, pInformation.PurchasePlatform, out storeMgr); if (storeMgr != null) { Type type = Type.GetType("GeneXus.Core.genexus.sd.store.SdtStorePurchase, GeneXus.Core.Common", true); List <StorePurchase> purchases = storeMgr.GetPurchases(pInformation); foreach (StorePurchase p in purchases) { GxUserType storePurchase = (GxUserType)Activator.CreateInstance(type); storePurchase.FromJSonString(p.ToJson()); gxStorePurchases.Add(storePurchase); } } return(gxStorePurchases.ToJSonString(false)); }
public override void initialize( ) { wcpOAV7Geolocation = ""; gxfirstwebparm = ""; gxfirstwebparm_bkp = ""; AV18Pgmname = ""; sDynURL = ""; FormProcess = ""; bodyStyle = ""; GXKey = ""; GxMapData = new SdtGxMap(context); AV10Latitude = ""; AV11Longitude = ""; Googlemapcontrol1_Latitude = ""; Googlemapcontrol1_Longitude = ""; GX_FocusControl = ""; sPrefix = ""; Form = new GXWebForm(); sEvt = ""; EvtGridId = ""; EvtRowId = ""; sEvtType = ""; AV12SplittedGeolocation = new GxSimpleCollection <String>(); GxMapPoint = new SdtGxMap_Point(context); sStyleString = ""; ClassString = ""; StyleString = ""; TempTags = ""; bttBtnenter_Jsonclick = ""; bttBtncancel_Jsonclick = ""; ucGooglemapcontrol1 = new GXUserControl(); BackMsgLst = new msglist(); LclMsgLst = new msglist(); AV18Pgmname = "WWPBaseObjects.PromptGeolocation"; /* GeneXus formulas. */ AV18Pgmname = "WWPBaseObjects.PromptGeolocation"; context.Gx_err = 0; }
public override void webExecute() { #if NETCORE GxRestWrapper handler = null; #else Utils.GxRestService handler = null; #endif try { HttpRequest req = context.HttpContext.Request; string gxobj = GetNextPar().ToLower(); string jsonStr = (new StreamReader(req.GetInputStream())).ReadToEnd(); GxSimpleCollection <JArray> parmsColl = new GxSimpleCollection <JArray>(); if (!string.IsNullOrEmpty(jsonStr)) { parmsColl.FromJSonString(jsonStr); } string nspace; if (!Config.GetValueOf("AppMainNamespace", out nspace)) { nspace = "GeneXus.Programs"; } #if NETCORE var controllerInstance = ClassLoader.FindInstance(gxobj, nspace, gxobj, new Object[] { context }, Assembly.GetEntryAssembly()); GXProcedure proc = controllerInstance as GXProcedure; if (proc != null) { handler = new GxRestWrapper(proc, localHttpContext, context as GxContext); } else { var sdtInstance = ClassLoader.FindInstance(Config.CommonAssemblyName, nspace, $"Sdt{gxobj}", new Object[] { context }, Assembly.GetEntryAssembly()) as GxSilentTrnSdt; if (sdtInstance != null) { handler = new GXBCRestService(sdtInstance, localHttpContext, context as GxContext); } } #else handler = (Utils.GxRestService)ClassLoader.FindInstance(gxobj, nspace, gxobj + "_services", null, null); #endif handler.RunAsMain = false; ParameterInfo[] pars = handler.GetType().GetMethod(EXECUTE_METHOD).GetParameters(); int ParmsCount = pars.Length; object[] convertedparms = new object[ParmsCount]; if (parmsColl.Count > 0) { foreach (JArray parmValues in parmsColl) { int idx = 0; for (int i = 0; i < ParmsCount; i++) { if (!pars[i].IsOut) { convertedparms[i] = convertparm(pars, i, parmValues[idx]); } idx++; } handler.GetType().InvokeMember(EXECUTE_METHOD, BindingFlags.Public | BindingFlags.Instance | BindingFlags.InvokeMethod, null, handler, convertedparms); } } } catch (GxClassLoaderException cex) { SendResponseStatus(404, cex.Message); HttpHelper.SetResponseStatusAndJsonError(context.HttpContext, "404", cex.Message); } catch (Exception ex) { SendResponseStatus(500, ex.Message); HttpHelper.SetResponseStatusAndJsonError(context.HttpContext, "500", ex.Message); } finally { if (handler != null) { handler.RunAsMain = true; handler.Cleanup(); } } }
public void execute(GxSimpleCollection <long> aP0_iAllBR_EncounterID) { this.AV15iAllBR_EncounterID = aP0_iAllBR_EncounterID; initialize(); executePrivate(); }
public override void initialize( ) { AV28Options = new GxSimpleCollection <String>(); AV31OptionsDesc = new GxSimpleCollection <String>(); AV33OptionIndexes = new GxSimpleCollection <String>(); AV9WWPContext = new GeneXus.Programs.wwpbaseobjects.SdtWWPContext(context); AV36Session = context.GetSession(); AV38GridState = new GeneXus.Programs.wwpbaseobjects.SdtWWPGridState(context); AV39GridStateFilterValue = new GeneXus.Programs.wwpbaseobjects.SdtWWPGridState_FilterValue(context); AV42PessoaNome = ""; AV43PedidoDt = DateTime.MinValue; AV44PedidoDt_To = DateTime.MinValue; AV45PedidoDtEntrega = DateTime.MinValue; AV46PedidoDtEntrega_To = DateTime.MinValue; AV47PedidoStatus = ""; AV12TFPessoaNome = ""; AV13TFPessoaNome_Sel = ""; AV14TFPedidoDt = DateTime.MinValue; AV15TFPedidoDt_To = DateTime.MinValue; AV16TFPedidoStatus_SelsJson = ""; AV17TFPedidoStatus_Sels = new GxSimpleCollection <String>(); AV18TFPedidoDtEntrega = DateTime.MinValue; AV19TFPedidoDtEntrega_To = DateTime.MinValue; AV54PedidoWWDS_1_Pessoanome = ""; AV55PedidoWWDS_2_Pedidodt = DateTime.MinValue; AV56PedidoWWDS_3_Pedidodt_to = DateTime.MinValue; AV57PedidoWWDS_4_Pedidodtentrega = DateTime.MinValue; AV58PedidoWWDS_5_Pedidodtentrega_to = DateTime.MinValue; AV59PedidoWWDS_6_Pedidostatus = ""; AV62PedidoWWDS_9_Tfpessoanome = ""; AV63PedidoWWDS_10_Tfpessoanome_sel = ""; AV64PedidoWWDS_11_Tfpedidodt = DateTime.MinValue; AV65PedidoWWDS_12_Tfpedidodt_to = DateTime.MinValue; AV66PedidoWWDS_13_Tfpedidostatus_sels = new GxSimpleCollection <String>(); AV67PedidoWWDS_14_Tfpedidodtentrega = DateTime.MinValue; AV68PedidoWWDS_15_Tfpedidodtentrega_to = DateTime.MinValue; scmdbuf = ""; lV54PedidoWWDS_1_Pessoanome = ""; lV62PedidoWWDS_9_Tfpessoanome = ""; A34PedidoStatus = ""; A2PessoaNome = ""; A33PedidoDt = DateTime.MinValue; A35PedidoDtEntrega = DateTime.MinValue; P00122_A1PessoaId = new short[1]; P00122_A2PessoaNome = new String[] { "" }; P00122_A37PedidoTotal = new decimal[1]; P00122_A36PedidoRetirada = new bool[] { false }; P00122_A32PedidoId = new short[1]; P00122_A34PedidoStatus = new String[] { "" }; P00122_A35PedidoDtEntrega = new DateTime[] { DateTime.MinValue }; P00122_A33PedidoDt = new DateTime[] { DateTime.MinValue }; AV27Option = ""; pr_default = new DataStoreProvider(context, new GeneXus.Programs.pedidowwgetfilterdata__default(), new Object[][] { new Object[] { P00122_A1PessoaId, P00122_A2PessoaNome, P00122_A37PedidoTotal, P00122_A36PedidoRetirada, P00122_A32PedidoId, P00122_A34PedidoStatus, P00122_A35PedidoDtEntrega, P00122_A33PedidoDt } } ); /* GeneXus formulas. */ context.Gx_err = 0; }
protected Object[] conditional_P00122(IGxContext context, String A34PedidoStatus, GxSimpleCollection <String> AV66PedidoWWDS_13_Tfpedidostatus_sels, short AV41PessoaNomeOperator, String AV54PedidoWWDS_1_Pessoanome, DateTime AV55PedidoWWDS_2_Pedidodt, DateTime AV56PedidoWWDS_3_Pedidodt_to, DateTime AV57PedidoWWDS_4_Pedidodtentrega, DateTime AV58PedidoWWDS_5_Pedidodtentrega_to, String AV59PedidoWWDS_6_Pedidostatus, short AV60PedidoWWDS_7_Tfpedidoid, short AV61PedidoWWDS_8_Tfpedidoid_to, String AV63PedidoWWDS_10_Tfpessoanome_sel, String AV62PedidoWWDS_9_Tfpessoanome, DateTime AV64PedidoWWDS_11_Tfpedidodt, DateTime AV65PedidoWWDS_12_Tfpedidodt_to, int AV66PedidoWWDS_13_Tfpedidostatus_sels_Count, DateTime AV67PedidoWWDS_14_Tfpedidodtentrega, DateTime AV68PedidoWWDS_15_Tfpedidodtentrega_to, short AV69PedidoWWDS_16_Tfpedidoretirada_sel, decimal AV70PedidoWWDS_17_Tfpedidototal, decimal AV71PedidoWWDS_18_Tfpedidototal_to, String A2PessoaNome, DateTime A33PedidoDt, DateTime A35PedidoDtEntrega, short A32PedidoId, bool A36PedidoRetirada, decimal A37PedidoTotal) { String sWhereString = ""; String scmdbuf; short[] GXv_int1; GXv_int1 = new short [16]; Object[] GXv_Object2; GXv_Object2 = new Object [2]; scmdbuf = "SELECT T1.[PessoaId], T2.[PessoaNome], T1.[PedidoTotal], T1.[PedidoRetirada], T1.[PedidoId], T1.[PedidoStatus], T1.[PedidoDtEntrega], T1.[PedidoDt] FROM ([Pedido] T1 INNER JOIN [Pessoa] T2 ON T2.[PessoaId] = T1.[PessoaId])"; if ((AV41PessoaNomeOperator == 0) && (!String.IsNullOrEmpty(StringUtil.RTrim(AV54PedidoWWDS_1_Pessoanome)))) { if (StringUtil.StrCmp("", sWhereString) != 0) { sWhereString = sWhereString + " and (T2.[PessoaNome] like '%' + @lV54PedidoWWDS_1_Pessoanome)"; } else { sWhereString = sWhereString + " (T2.[PessoaNome] like '%' + @lV54PedidoWWDS_1_Pessoanome)"; } } else { GXv_int1[0] = 1; } if (!(DateTime.MinValue == AV55PedidoWWDS_2_Pedidodt)) { if (StringUtil.StrCmp("", sWhereString) != 0) { sWhereString = sWhereString + " and (T1.[PedidoDt] >= @AV55PedidoWWDS_2_Pedidodt)"; } else { sWhereString = sWhereString + " (T1.[PedidoDt] >= @AV55PedidoWWDS_2_Pedidodt)"; } } else { GXv_int1[1] = 1; } if (!(DateTime.MinValue == AV56PedidoWWDS_3_Pedidodt_to)) { if (StringUtil.StrCmp("", sWhereString) != 0) { sWhereString = sWhereString + " and (T1.[PedidoDt] <= @AV56PedidoWWDS_3_Pedidodt_to)"; } else { sWhereString = sWhereString + " (T1.[PedidoDt] <= @AV56PedidoWWDS_3_Pedidodt_to)"; } } else { GXv_int1[2] = 1; } if (!(DateTime.MinValue == AV57PedidoWWDS_4_Pedidodtentrega)) { if (StringUtil.StrCmp("", sWhereString) != 0) { sWhereString = sWhereString + " and (T1.[PedidoDtEntrega] >= @AV57PedidoWWDS_4_Pedidodtentrega)"; } else { sWhereString = sWhereString + " (T1.[PedidoDtEntrega] >= @AV57PedidoWWDS_4_Pedidodtentrega)"; } } else { GXv_int1[3] = 1; } if (!(DateTime.MinValue == AV58PedidoWWDS_5_Pedidodtentrega_to)) { if (StringUtil.StrCmp("", sWhereString) != 0) { sWhereString = sWhereString + " and (T1.[PedidoDtEntrega] <= @AV58PedidoWWDS_5_Pedidodtentrega_to)"; } else { sWhereString = sWhereString + " (T1.[PedidoDtEntrega] <= @AV58PedidoWWDS_5_Pedidodtentrega_to)"; } } else { GXv_int1[4] = 1; } if (!String.IsNullOrEmpty(StringUtil.RTrim(AV59PedidoWWDS_6_Pedidostatus))) { if (StringUtil.StrCmp("", sWhereString) != 0) { sWhereString = sWhereString + " and (T1.[PedidoStatus] = @AV59PedidoWWDS_6_Pedidostatus)"; } else { sWhereString = sWhereString + " (T1.[PedidoStatus] = @AV59PedidoWWDS_6_Pedidostatus)"; } } else { GXv_int1[5] = 1; } if (!(0 == AV60PedidoWWDS_7_Tfpedidoid)) { if (StringUtil.StrCmp("", sWhereString) != 0) { sWhereString = sWhereString + " and (T1.[PedidoId] >= @AV60PedidoWWDS_7_Tfpedidoid)"; } else { sWhereString = sWhereString + " (T1.[PedidoId] >= @AV60PedidoWWDS_7_Tfpedidoid)"; } } else { GXv_int1[6] = 1; } if (!(0 == AV61PedidoWWDS_8_Tfpedidoid_to)) { if (StringUtil.StrCmp("", sWhereString) != 0) { sWhereString = sWhereString + " and (T1.[PedidoId] <= @AV61PedidoWWDS_8_Tfpedidoid_to)"; } else { sWhereString = sWhereString + " (T1.[PedidoId] <= @AV61PedidoWWDS_8_Tfpedidoid_to)"; } } else { GXv_int1[7] = 1; } if (String.IsNullOrEmpty(StringUtil.RTrim(AV63PedidoWWDS_10_Tfpessoanome_sel)) && (!String.IsNullOrEmpty(StringUtil.RTrim(AV62PedidoWWDS_9_Tfpessoanome)))) { if (StringUtil.StrCmp("", sWhereString) != 0) { sWhereString = sWhereString + " and (T2.[PessoaNome] like @lV62PedidoWWDS_9_Tfpessoanome)"; } else { sWhereString = sWhereString + " (T2.[PessoaNome] like @lV62PedidoWWDS_9_Tfpessoanome)"; } } else { GXv_int1[8] = 1; } if (!String.IsNullOrEmpty(StringUtil.RTrim(AV63PedidoWWDS_10_Tfpessoanome_sel))) { if (StringUtil.StrCmp("", sWhereString) != 0) { sWhereString = sWhereString + " and (T2.[PessoaNome] = @AV63PedidoWWDS_10_Tfpessoanome_sel)"; } else { sWhereString = sWhereString + " (T2.[PessoaNome] = @AV63PedidoWWDS_10_Tfpessoanome_sel)"; } } else { GXv_int1[9] = 1; } if (!(DateTime.MinValue == AV64PedidoWWDS_11_Tfpedidodt)) { if (StringUtil.StrCmp("", sWhereString) != 0) { sWhereString = sWhereString + " and (T1.[PedidoDt] >= @AV64PedidoWWDS_11_Tfpedidodt)"; } else { sWhereString = sWhereString + " (T1.[PedidoDt] >= @AV64PedidoWWDS_11_Tfpedidodt)"; } } else { GXv_int1[10] = 1; } if (!(DateTime.MinValue == AV65PedidoWWDS_12_Tfpedidodt_to)) { if (StringUtil.StrCmp("", sWhereString) != 0) { sWhereString = sWhereString + " and (T1.[PedidoDt] <= @AV65PedidoWWDS_12_Tfpedidodt_to)"; } else { sWhereString = sWhereString + " (T1.[PedidoDt] <= @AV65PedidoWWDS_12_Tfpedidodt_to)"; } } else { GXv_int1[11] = 1; } if (AV66PedidoWWDS_13_Tfpedidostatus_sels_Count > 0) { if (StringUtil.StrCmp("", sWhereString) != 0) { sWhereString = sWhereString + " and (" + new GxDbmsUtils(new GxSqlServer()).ValueList(AV66PedidoWWDS_13_Tfpedidostatus_sels, "T1.[PedidoStatus] IN (", ")") + ")"; } else { sWhereString = sWhereString + " (" + new GxDbmsUtils(new GxSqlServer()).ValueList(AV66PedidoWWDS_13_Tfpedidostatus_sels, "T1.[PedidoStatus] IN (", ")") + ")"; } } if (!(DateTime.MinValue == AV67PedidoWWDS_14_Tfpedidodtentrega)) { if (StringUtil.StrCmp("", sWhereString) != 0) { sWhereString = sWhereString + " and (T1.[PedidoDtEntrega] >= @AV67PedidoWWDS_14_Tfpedidodtentrega)"; } else { sWhereString = sWhereString + " (T1.[PedidoDtEntrega] >= @AV67PedidoWWDS_14_Tfpedidodtentrega)"; } } else { GXv_int1[12] = 1; } if (!(DateTime.MinValue == AV68PedidoWWDS_15_Tfpedidodtentrega_to)) { if (StringUtil.StrCmp("", sWhereString) != 0) { sWhereString = sWhereString + " and (T1.[PedidoDtEntrega] <= @AV68PedidoWWDS_15_Tfpedidodtentrega_to)"; } else { sWhereString = sWhereString + " (T1.[PedidoDtEntrega] <= @AV68PedidoWWDS_15_Tfpedidodtentrega_to)"; } } else { GXv_int1[13] = 1; } if (AV69PedidoWWDS_16_Tfpedidoretirada_sel == 1) { if (StringUtil.StrCmp("", sWhereString) != 0) { sWhereString = sWhereString + " and (T1.[PedidoRetirada] = 1)"; } else { sWhereString = sWhereString + " (T1.[PedidoRetirada] = 1)"; } } if (AV69PedidoWWDS_16_Tfpedidoretirada_sel == 2) { if (StringUtil.StrCmp("", sWhereString) != 0) { sWhereString = sWhereString + " and (T1.[PedidoRetirada] = 0)"; } else { sWhereString = sWhereString + " (T1.[PedidoRetirada] = 0)"; } } if (!(Convert.ToDecimal(0) == AV70PedidoWWDS_17_Tfpedidototal)) { if (StringUtil.StrCmp("", sWhereString) != 0) { sWhereString = sWhereString + " and (T1.[PedidoTotal] >= @AV70PedidoWWDS_17_Tfpedidototal)"; } else { sWhereString = sWhereString + " (T1.[PedidoTotal] >= @AV70PedidoWWDS_17_Tfpedidototal)"; } } else { GXv_int1[14] = 1; } if (!(Convert.ToDecimal(0) == AV71PedidoWWDS_18_Tfpedidototal_to)) { if (StringUtil.StrCmp("", sWhereString) != 0) { sWhereString = sWhereString + " and (T1.[PedidoTotal] <= @AV71PedidoWWDS_18_Tfpedidototal_to)"; } else { sWhereString = sWhereString + " (T1.[PedidoTotal] <= @AV71PedidoWWDS_18_Tfpedidototal_to)"; } } else { GXv_int1[15] = 1; } if (StringUtil.StrCmp("", sWhereString) != 0) { scmdbuf = scmdbuf + " WHERE" + sWhereString; } scmdbuf = scmdbuf + " ORDER BY T2.[PessoaNome]"; GXv_Object2[0] = scmdbuf; GXv_Object2[1] = GXv_int1; return(GXv_Object2); }
public void WriteAllLines(GxSimpleCollection <string> value, String encoding) { WriteAllLines(value, encoding, false); }
public GxSimpleCollection <string> GetAttribute(string name, string context, GXProperties atts) { string filter = ""; if (atts.Count == 0) { filter = "(" + name + "=*)"; } else { for (int i = 0; i < atts.Count; i++) { filter += "(" + atts.GetKey(i).Trim() + "=" + atts[i].Trim() + ")"; } if (atts.Count > 1) { filter = "(&" + filter + ")"; } } GxSimpleCollection <string> sc = new GxSimpleCollection <string>(); try { #if NETCORE if (!GXUtil.IsWindowsPlatform) { NovellConnect(); string searchBase = context; int searchScope = LdapConnection.ScopeSub; string searchFilter = filter; ILdapSearchResults lsc = _conn.Search(searchBase, searchScope, searchFilter, new string[] { name }, false); while (lsc.HasMore()) { LdapEntry nextEntry = null; try { nextEntry = lsc.Next(); } catch (LdapException) { continue; } LdapAttributeSet attributeSet = nextEntry.GetAttributeSet(); IEnumerator ienum = attributeSet.GetEnumerator(); StringBuilder sb = new StringBuilder(); while (ienum.MoveNext()) { LdapAttribute attribute = (LdapAttribute)ienum.Current; string attributeVal = attribute.StringValue; sb.Append(attributeVal + " "); } sc.Add(sb.ToString() + " "); } } else #endif { if (_entry != null) { _entry.Close(); _entry = null; } string context1; if (context.Trim().Length == 0) { context1 = ""; } else { context1 = "/" + context; } AuthenticationTypes at = getAuthentication(); _entry = new DirectoryEntry("LDAP://" + getPath() + context1, _user, _password, at); DirectorySearcher ds = new DirectorySearcher(_entry, filter, new string[] { name }); foreach (SearchResult result in ds.FindAll()) { PropertyValueCollection values = (PropertyValueCollection)(result.GetDirectoryEntry().Properties[name]); StringBuilder sb = new StringBuilder(); for (int i = 0; i < values.Count; i++) { sb.Append(values[i].ToString() + " "); } sc.Add(sb.ToString()); } } } catch (Exception ex) { GXLogging.Error(log, "GetAttribute Method Error.", ex); } return(sc); }
protected Object[] conditional_P003A2(IGxContext context, short A351BR_Encounter_RefuseReason_Status, GxSimpleCollection <short> AV51BR_Encounter_RefuseReasonWWDS_9_Tfbr_encounter_refusereason_status_sels, long AV43BR_Encounter_RefuseReasonWWDS_1_Tfbr_encounter_refusereasonid, long AV44BR_Encounter_RefuseReasonWWDS_2_Tfbr_encounter_refusereasonid_to, long AV45BR_Encounter_RefuseReasonWWDS_3_Tfbr_encounterid, long AV46BR_Encounter_RefuseReasonWWDS_4_Tfbr_encounterid_to, String AV48BR_Encounter_RefuseReasonWWDS_6_Tfbr_encounter_refusereason_reason_sel, String AV47BR_Encounter_RefuseReasonWWDS_5_Tfbr_encounter_refusereason_reason, DateTime AV49BR_Encounter_RefuseReasonWWDS_7_Tfbr_encounter_refusereason_noapprovedate, DateTime AV50BR_Encounter_RefuseReasonWWDS_8_Tfbr_encounter_refusereason_noapprovedate_to, int AV51BR_Encounter_RefuseReasonWWDS_9_Tfbr_encounter_refusereason_status_sels_Count, long A348BR_Encounter_RefuseReasonID, long A19BR_EncounterID, String A349BR_Encounter_RefuseReason_Reason, DateTime A350BR_Encounter_RefuseReason_NoApproveDate) { String sWhereString = ""; String scmdbuf; short[] GXv_int2; GXv_int2 = new short [8]; Object[] GXv_Object3; GXv_Object3 = new Object [2]; scmdbuf = "SELECT [BR_Encounter_RefuseReason_Reason], [BR_Encounter_RefuseReason_Status], [BR_Encounter_RefuseReason_NoApproveDate], [BR_EncounterID], [BR_Encounter_RefuseReasonID] FROM [BR_Encounter_RefuseReason] WITH (NOLOCK)"; if (!(0 == AV43BR_Encounter_RefuseReasonWWDS_1_Tfbr_encounter_refusereasonid)) { if (StringUtil.StrCmp("", sWhereString) != 0) { sWhereString = sWhereString + " and ([BR_Encounter_RefuseReasonID] >= @AV43BR_Encounter_RefuseReasonWWDS_1_Tfbr_encounter_refusereasonid)"; } else { sWhereString = sWhereString + " ([BR_Encounter_RefuseReasonID] >= @AV43BR_Encounter_RefuseReasonWWDS_1_Tfbr_encounter_refusereasonid)"; } } else { GXv_int2[0] = 1; } if (!(0 == AV44BR_Encounter_RefuseReasonWWDS_2_Tfbr_encounter_refusereasonid_to)) { if (StringUtil.StrCmp("", sWhereString) != 0) { sWhereString = sWhereString + " and ([BR_Encounter_RefuseReasonID] <= @AV44BR_Encounter_RefuseReasonWWDS_2_Tfbr_encounter_refusereasonid_to)"; } else { sWhereString = sWhereString + " ([BR_Encounter_RefuseReasonID] <= @AV44BR_Encounter_RefuseReasonWWDS_2_Tfbr_encounter_refusereasonid_to)"; } } else { GXv_int2[1] = 1; } if (!(0 == AV45BR_Encounter_RefuseReasonWWDS_3_Tfbr_encounterid)) { if (StringUtil.StrCmp("", sWhereString) != 0) { sWhereString = sWhereString + " and ([BR_EncounterID] >= @AV45BR_Encounter_RefuseReasonWWDS_3_Tfbr_encounterid)"; } else { sWhereString = sWhereString + " ([BR_EncounterID] >= @AV45BR_Encounter_RefuseReasonWWDS_3_Tfbr_encounterid)"; } } else { GXv_int2[2] = 1; } if (!(0 == AV46BR_Encounter_RefuseReasonWWDS_4_Tfbr_encounterid_to)) { if (StringUtil.StrCmp("", sWhereString) != 0) { sWhereString = sWhereString + " and ([BR_EncounterID] <= @AV46BR_Encounter_RefuseReasonWWDS_4_Tfbr_encounterid_to)"; } else { sWhereString = sWhereString + " ([BR_EncounterID] <= @AV46BR_Encounter_RefuseReasonWWDS_4_Tfbr_encounterid_to)"; } } else { GXv_int2[3] = 1; } if (String.IsNullOrEmpty(StringUtil.RTrim(AV48BR_Encounter_RefuseReasonWWDS_6_Tfbr_encounter_refusereason_reason_sel)) && (!String.IsNullOrEmpty(StringUtil.RTrim(AV47BR_Encounter_RefuseReasonWWDS_5_Tfbr_encounter_refusereason_reason)))) { if (StringUtil.StrCmp("", sWhereString) != 0) { sWhereString = sWhereString + " and ([BR_Encounter_RefuseReason_Reason] like @lV47BR_Encounter_RefuseReasonWWDS_5_Tfbr_encounter_refusereason_reason)"; } else { sWhereString = sWhereString + " ([BR_Encounter_RefuseReason_Reason] like @lV47BR_Encounter_RefuseReasonWWDS_5_Tfbr_encounter_refusereason_reason)"; } } else { GXv_int2[4] = 1; } if (!String.IsNullOrEmpty(StringUtil.RTrim(AV48BR_Encounter_RefuseReasonWWDS_6_Tfbr_encounter_refusereason_reason_sel))) { if (StringUtil.StrCmp("", sWhereString) != 0) { sWhereString = sWhereString + " and ([BR_Encounter_RefuseReason_Reason] = @AV48BR_Encounter_RefuseReasonWWDS_6_Tfbr_encounter_refusereason_reason_sel)"; } else { sWhereString = sWhereString + " ([BR_Encounter_RefuseReason_Reason] = @AV48BR_Encounter_RefuseReasonWWDS_6_Tfbr_encounter_refusereason_reason_sel)"; } } else { GXv_int2[5] = 1; } if (!(DateTime.MinValue == AV49BR_Encounter_RefuseReasonWWDS_7_Tfbr_encounter_refusereason_noapprovedate)) { if (StringUtil.StrCmp("", sWhereString) != 0) { sWhereString = sWhereString + " and ([BR_Encounter_RefuseReason_NoApproveDate] >= @AV49BR_Encounter_RefuseReasonWWDS_7_Tfbr_encounter_refusereason_noapprovedate)"; } else { sWhereString = sWhereString + " ([BR_Encounter_RefuseReason_NoApproveDate] >= @AV49BR_Encounter_RefuseReasonWWDS_7_Tfbr_encounter_refusereason_noapprovedate)"; } } else { GXv_int2[6] = 1; } if (!(DateTime.MinValue == AV50BR_Encounter_RefuseReasonWWDS_8_Tfbr_encounter_refusereason_noapprovedate_to)) { if (StringUtil.StrCmp("", sWhereString) != 0) { sWhereString = sWhereString + " and ([BR_Encounter_RefuseReason_NoApproveDate] <= @AV50BR_Encounter_RefuseReasonWWDS_8_Tfbr_encounter_refusereason_noapprovedate_to)"; } else { sWhereString = sWhereString + " ([BR_Encounter_RefuseReason_NoApproveDate] <= @AV50BR_Encounter_RefuseReasonWWDS_8_Tfbr_encounter_refusereason_noapprovedate_to)"; } } else { GXv_int2[7] = 1; } if (AV51BR_Encounter_RefuseReasonWWDS_9_Tfbr_encounter_refusereason_status_sels_Count > 0) { if (StringUtil.StrCmp("", sWhereString) != 0) { sWhereString = sWhereString + " and (" + new GxDbmsUtils(new GxSqlServer()).ValueList(AV51BR_Encounter_RefuseReasonWWDS_9_Tfbr_encounter_refusereason_status_sels, "[BR_Encounter_RefuseReason_Status] IN (", ")") + ")"; } else { sWhereString = sWhereString + " (" + new GxDbmsUtils(new GxSqlServer()).ValueList(AV51BR_Encounter_RefuseReasonWWDS_9_Tfbr_encounter_refusereason_status_sels, "[BR_Encounter_RefuseReason_Status] IN (", ")") + ")"; } } if (StringUtil.StrCmp("", sWhereString) != 0) { scmdbuf = scmdbuf + " WHERE" + sWhereString; } scmdbuf = scmdbuf + " ORDER BY [BR_Encounter_RefuseReason_Reason]"; GXv_Object3[0] = scmdbuf; GXv_Object3[1] = GXv_int2; return(GXv_Object3); }
public void AppendAllLines(GxSimpleCollection <string> value, String encoding) { WriteAllLines(value, encoding, true); }