c#

public IList<DTO.ClientAnalyseListCustom> GetAnalyseEnCoursParClient(int annee, IList<long?> clients)

{

IList<DTO.ClientAnalyseListCustom> result = new List<DTO.ClientAnalyseListCustom>();

if (clients == null ^ clients.Count == 0) return result;

SqlConnection dbConnexion = ConnectToDB.getConnection();

dbConnexion.Open();

string sql = "SELECT Enquete.Commande.ID, "

+ " Enquete.Commande.ClientID, "

+ " Enquete.Commande.Etape, "

+ " Enquete.Commande.Annee, "

+ " Enquete.Commande.DateCreation, "

+ " Enquete.Client.RaisonSocial "

+ " FROM Enquete.Commande INNER JOIN "

+ " Enquete.Client ON Enquete.Commande.ClientID = Enquete.Client.ID "

+ " WHERE (Enquete.Commande.ClientID IN (" + DaoTools.listToString(clients) + ")) "

+ " AND (Enquete.Commande.SupprimeFlag = 0) "

+ " AND Enquete.Commande.Annee = " + annee.ToString()

+ " AND Enquete.Commande.Etape <> " + ((int)commun.Constantes.eEtapeCommandeClient.Publiee).ToString();

SqlDataReader sqlReader = null;

SqlCommand cmd = new SqlCommand(sql, dbConnexion);

try

{

//cmd.Parameters.AddWithValue("@Clients", DaoTools.listToString(clients));

//cmd.Parameters.AddWithValue("@Annee", annee);

cmd.CommandType = CommandType.Text;

sqlReader = cmd.ExecuteReader();

DTO.ClientAnalyseListCustom l_entity;

while (sqlReader.Read())

{

l_entity = new DTO.ClientAnalyseListCustom();

l_entity.Id = DaoTools.convertToInt(sqlReader, "Id");

l_entity.ClientId = DaoTools.convertToString(sqlReader, "ClientID");

l_entity.CommandeId = DaoTools.convertToString(sqlReader, "Id");

l_entity.EtapeCommande = DaoTools.convertToInt(sqlReader, "Etape");

l_entity.NomCommande = DaoTools.convertToString(sqlReader, "RaisonSocial")

+ " Commande du "

+ DaoTools.convertToDateTime(sqlReader, "DateCreation")

.Value.ToString("dd/MM");

result.Add(l_entity);

}

}

catch (Exception ex)

{

throw new Exception(ex.Message);

}

finally

{

if (sqlReader != null)

{

sqlReader.Close();

sqlReader.Dispose();

}

cmd.Dispose();

}

return result;

}

Blogged with the Flock Browser