1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47
|
using System;
using System.Collections.Generic;
using System.Text;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using Microsoft.SharePoint;
namespace seb
{
public class WebPart1 : System.Web.UI.WebControls.WebParts.WebPart
{
protected override void CreateChildControls()
{
protected override void RenderContents(HtmlTextWriter writer)
{
try
{
SPSite site = SPContext.Current.Site;
SPWeb web = SPContext.Current.Web;
SPQuery WorkflowQuery = new SPQuery();
SPList list = SPContext.Current.Web.Lists["ConvocationEtudiant"];
WorkflowQuery.ViewFields = "<FieldRef Name='Title' /><FieldRef Name='Departement' /><FieldRef Name='NomDoyen' /><FieldRef Name='AdresseDoyen' /><FieldRef Name='NomSecretaire' /><FieldRef Name='AdresseSecretaire' /><FieldRef Name='NomEtudiant' /><FieldRef Name='AdresseEtudiant' /><FieldRef Name='DateRD' /><FieldRef Name='LigneOK' /><FieldRef Name='WorkBox_convocationetudiant' /><FieldRef Name='_ModerationStatus' />";
WorkflowQuery.Query = "<Where><Or><Or><Eq><FieldRef Name='NomDoyen' /><Value Type='User'>" + HttpContext.Current.User.Identity.Name+ "</Value></Eq><Eq><FieldRef Name='NomSecretaire' /><Value Type='User'>" + HttpContext.Current.User.Identity.Name + "</Value></Eq></Or><Eq><FieldRef Name='NomEtudiant' /><Value Type='User'>" + HttpContext.Current.User.Identity.Name + "</Value></Eq></Or></Where><OrderBy><FieldRef Name='DateRD' Ascending='True' /></OrderBy>";
SPListItemCollection items = list.GetItems(WorkflowQuery);
foreach (SPListItem item in items)
{
writer.Write("Element de la liste");
}
}
catch (Exception Ex)
{
//Traitement d'erreur
}
}
}
} |
Partager