public static string ExecuteParameter() { ParameterStore Parameters = new ParameterStore(); Parameters.Add(new ReportParameter("Vermessungsbezirk", "Alle", "00000000-0000-0000-0000-000000000000")); Parameters.Add(new ReportParameter("Kreis", "Alle", "00000000-0000-0000-0000-000000000000")); Parameters.Add(new ReportParameter("Gemeinde", "Alle", "00000000-0000-0000-0000-000000000000")); string str = ParameterStore.ExecuteParameter(Parameters); Console.WriteLine(str); return(str); }
public static string ExecuteParameter(ParameterStore Parameters) { return(""); // return Microsoft.VisualBasic.CompilerServices.Conversions.ToString( // Operators.ConcatenateObject(Operators.ConcatenateObject(Operators.ConcatenateObject( // Operators.ConcatenateObject(Operators.ConcatenateObject(Operators.ConcatenateObject( // Operators.ConcatenateObject( // @"SELECT 2 AS ID, 2 AS Sort, 'Alle' AS Name UNION SELECT DISTINCT PZ_IsAltlasten AS ID, PZ_IsAltlasten AS Sort, 'Ja' AS Name //FROM V_AP_BERICHT_SEL_PZ_Altlasten WHERE PZ_IsAltlasten = 1 " //, ParameterStore.IIF(EmbeddedOperators.CompareString(Parameters["Vermessungsbezirk"].Value, "00000000-0000-0000-0000-000000000000", false) == 0 //, RuntimeHelpers.GetObjectValue(ParameterStore.IIF(EmbeddedOperators.CompareString(Parameters["Kreis"].Value, "00000000-0000-0000-0000-000000000000", false) == 0 //, RuntimeHelpers.GetObjectValue(ParameterStore.IIF(EmbeddedOperators.CompareString(Parameters["Gemeinde"].Value, "00000000-0000-0000-0000-000000000000", false) == 0 //, "", "AND GM_ApertureID = '" + Parameters["Gemeinde"].Value + "' ")), "AND KS_ApertureID = '" + Parameters["Kreis"].Value + "' ")) //, "AND VB_ApertureID = '" + Parameters["Vermessungsbezirk"].Value + "' ")), "UNION ") //, "SELECT DISTINCT PZ_IsAltlasten AS ID, PZ_IsAltlasten AS Sort, 'Nein' AS Name "), "FROM V_AP_BERICHT_SEL_PZ_Altlasten ") //, "WHERE PZ_IsAltlasten = 0 "), ParameterStore.IIF(EmbeddedOperators.CompareString(Parameters["Vermessungsbezirk"].Value //, "00000000-0000-0000-0000-000000000000", false) == 0, //RuntimeHelpers.GetObjectValue(ParameterStore.IIF(EmbeddedOperators.CompareString(Parameters["Kreis"].Value, "00000000-0000-0000-0000-000000000000", false) == 0, //RuntimeHelpers.GetObjectValue(ParameterStore.IIF(EmbeddedOperators.CompareString(Parameters["Gemeinde"].Value, "00000000-0000-0000-0000-000000000000", false) == 0, "", //"AND GM_ApertureID = '" + Parameters["Gemeinde"].Value + "' ")), "AND KS_ApertureID = '" + Parameters["Kreis"].Value + "' ")), //"AND VB_ApertureID = '" + Parameters["Vermessungsbezirk"].Value + "' ")), "ORDER BY Sort DESC ")); }