<%@ Page Language="C#" Buffer="true" CodeFile="actualites.aspx.cs" Inherits="_actualites" CodePage="65001" UICulture="fr" Culture="fr-FR" ValidateRequest="true" %> <%@ Import Namespace="ItlRuntime" %> <%@ Import Namespace="System.Collections.Generic" %> <%@ Import Namespace="System.Linq" %> <% EC.linkableClassMap = (Map) EC.newMap(new Map() , "ocsNewsEvent:news", new ClassLink("./page00013329.aspx?card=object", "linkTable.aspx?GID=00013329&card=object", "Actualité")); %><% EC.imageProviderUrl = "./imageProvider.aspx"; %><% EC.albumDialogUrl = "./albumDialog.aspx"; %><% EC.albumPrivateDialogUrl = "./albumPrivateDialog.aspx"; %> " /> Actualités - Actualites
Trémentines

Actualités/Agenda/Actualités

Actualites

<% ItlEnumerator e2 = new ItlEnumerator("G00012cd3_1", null, false); e2.add(new SqlEnumerator(new ItlRuntime.SQL.Collection("ocsNewsEvent:news", @"SELECT this_k_1.result1 AS this_k_1_1, this.`_oid` AS this, this_z.writingDate AS o_1 FROM ocsNewsEvent_news AS this INNER JOIN (ocsNewsEvent_card AS this_z INNER JOIN (ocs_card AS this_z_z LEFT JOIN ocs_catalog AS this_z_z_s_ocsCatalog On ((this_z_z.ocsCatalog = this_z_z_s_ocsCatalog.`_oid`) AND (this_z_z_s_ocsCatalog.iso_sid <> ''))) On ((this_z.`_oid` = this_z_z.`_oid`) AND (this_z_z.iso_sid <> ''))) On ((this.`_oid` = this_z.`_oid`) AND (this_z.iso_sid <> '')) LEFT JOIN (SELECT c0.`_oid` AS origin, COUNT(DISTINCT this.`_oid`) AS result1 FROM xrm_category AS this INNER JOIN (ocsNewsEvent_news AS c0 INNER JOIN ocs_card_ocsVisibility AS c0_l On ((c0.`_oid` = c0_l.`_from`) AND (c0.iso_sid <> '')) INNER JOIN (ocsNewsEvent_card AS c0_z INNER JOIN ocs_card AS c0_z_z On ((c0_z.`_oid` = c0_z_z.`_oid`) AND (c0_z_z.iso_sid <> ''))) On ((c0.`_oid` = c0_z.`_oid`) AND (c0_z.iso_sid <> ''))) On ((this.`_oid` = c0_l.`_to`) AND (c0_l.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this.`_oid` IN (#V_1&;)) GROUP BY c0.`_oid`) AS this_k_1 On (this.`_oid` = this_k_1.origin) WHERE (this.iso_sid <> '') AND (IF((this_z_z_s_ocsCatalog.useValidation = 1),this_z_z.ocsStatus,IF(((this_z_z.ocsStatus = 2) OR (this_z_z.ocsStatus = 3)),this_z_z.ocsStatus,0)) = 2) AND ((this_z.startVisibilityDate IS NULL ) OR (this_z.startVisibilityDate <= #V_0&;)) AND ((this_z.endVisibilityDate IS NULL ) OR (this_z.endVisibilityDate >= #V_0&;)) AND ((this_z_z_s_ocsCatalog.useXRM = 0) OR ((this_z_z_s_ocsCatalog.useXRM = 1) AND (this_k_1.result1 > 0))) AND (this_z_z_s_ocsCatalog.name = 'actualites')", new ItlRuntime.SQL.Parameters( new ItlRuntime.SQL.Parameter("#V_0&;", EC.itl.today(), "date"), new ItlRuntime.SQL.Parameter("#V_1&;", EC.itl.categoryOids(true), "oids")), new ItlRuntime.SQL.OrderAliases(new ItlRuntime.SQL.OrderAlias("o_1", false)), new ItlRuntime.SQL.OptionalOrderAliases(), null, null), @"SELECT this.`_oid` AS this, this_z.title_fr AS this_z_p_title_fr, this_z.summary_fr AS this_z_p_summary_fr, this_z_s_image.width AS this_z_s_image_p_width, this_z_s_image.height AS this_z_s_image_p_height, this_z_s_image.frames AS this_z_s_image_p_frames, this_z_s_image.`_oid` AS this_z_s_image, this_z_s_image_z.description_fr AS this_z_s_image_z_p_description_fr FROM ocsNewsEvent_news AS this INNER JOIN (ocsNewsEvent_card AS this_z INNER JOIN ocs_card AS this_z_z On ((this_z.`_oid` = this_z_z.`_oid`) AND (this_z_z.iso_sid <> '')) LEFT JOIN (alb_image AS this_z_s_image INNER JOIN alb_resource AS this_z_s_image_z On ((this_z_s_image.`_oid` = this_z_s_image_z.`_oid`) AND (this_z_s_image_z.iso_sid <> ''))) On ((this_z.image = this_z_s_image.`_oid`) AND (this_z_s_image.iso_sid <> ''))) On ((this.`_oid` = this_z.`_oid`) AND (this_z.iso_sid <> '')) WHERE (this.iso_sid <> '')", new Map(), true, (List) EC.newList(new List()), null, null)); e2.setLimit(10); e2.setNavigationFeatures("showRecordCounts showRange previousPage nextPage"); ItlEnumerator card = (ItlEnumerator) (e2); card.reset(); if(card.isNotEmpty()) { ItlEnumerator cardEnumerator = (ItlEnumerator) (card); %>
<% int lastLine = (int) (cardEnumerator.pageSize() % 1); %> <% if(cardEnumerator.needNavigationBar()) { %> <% } %> <% card.resetGroup(); for(card.start();card.test();card.fetch()) { if((cardEnumerator.positionInPage() - 1) % 1 == 0) { ITL.show(("", "string", "raw", "string"); } string altcol = (string) ((cardEnumerator.positionInPage() - 1) % 1 % 2 == 1?"odd":"even"); %> >
<% ITL.show(cardEnumerator.navigationBar(), "string", "raw", "string"); %>
<% if(ITL.isNotNull((int?)card.get("this_z_s_image"))) { int effectiveWidth = (int) (EC.itl.getEffectiveWidth((int?)card.get("this_z_s_image_p_width"), (int?)card.get("this_z_s_image_p_height"), 80, 0)); int effectiveHeight = (int) (EC.itl.getEffectiveHeight((int?)card.get("this_z_s_image_p_width"), (int?)card.get("this_z_s_image_p_height"), 80, 0)); %>

> > <% ItlLink link6 = new ItlLink(""); link6.setProperty("class", "link"); link6.show(); %> class="image"<%ITL.showAttributeWithName("title", (string)card.get("this_z_s_image_z_p_description_fr"));ITL.showAttributeWithName("alt", (string)card.get("this_z_s_image_z_p_description_fr"));%> longdesc=""<%ITL.showAttributeWithName("height", effectiveHeight);ITL.showAttributeWithName("width", effectiveWidth);%>/><% link6.close(); %>

<% } else { } %>

<%ITL.show((string)card.get("this_z_p_title_fr"), "string", "raw", "string");%>
<%ITL.show((string)card.get("this_z_p_summary_fr"), "string", "memo", "string");%>

>> <% if(true) { %>Lire la suite<% } else { %>Lire la suite<% } %>

<% if(cardEnumerator.isLastInPage() && lastLine != 0) { int nbEmpty = (int) (1 - ITL.i(lastLine)); ITL.show(EC.itl.stringRepeat(((((" "),(int)Math.Floor((ITL.d(nbEmpty) / 2D))), "string", "raw", "string"); ITL.show(EC.itl.stringRepeat(((" "),(ITL.i(nbEmpty) % 2)), "string", "raw", "string"); } if(cardEnumerator.positionInPage() % 1 == 0) { %> <% } }%> <% } else {%>

Aucune fiche disponible pour le moment.

<% } card.finish(); %>

© Mairie de TREMENTINES 2021