Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP inlist() in c#
Message
De
26/01/2013 06:36:12
 
 
Information générale
Forum:
ASP.NET
Catégorie:
Code, syntaxe and commandes
Divers
Thread ID:
01320903
Message ID:
01564223
Vues:
46
>>Declaring the type for the generic in the function call also works:
closeDrawers.InList< short >(2, 4)
>
>Do you know if there is something similar to VFP Case statement in C# where we can analyze different conditions?
>
>Say,
>
>I just wrote this part:
>
>
> if (startTime > defaultDate && endTime > defaultDate)
>                                    {
>                                        whereClause.AppendLine(" AND date_time between @StartTime and @EndTime");
>                                        sqlCommand.Parameters.Add("@StartTime", SqlDbType.DateTime).Value = startTime;
>                                        sqlCommand.Parameters.Add("@EndTime", SqlDbType.DateTime).Value = endTime;
>                                    }
>
>I need 2 more cases for only startTime defined or only endTime defined. If I will use if I again need to check both variables.
>
>Wondering if there is something in C# that makes this decision choice easier. I believe there is nothing in C# that is like VFP case where we can test various expressions - quick Google search also confirms it.

The closest you can get is to use if/else if /else if/else
 if (startTime > defaultDate && endTime > defaultDate)
 {
               whereClause.AppendLine(" AND date_time between @StartTime and @EndTime");
                sqlCommand.Parameters.Add("@StartTime", SqlDbType.DateTime).Value = startTime;
                 sqlCommand.Parameters.Add("@EndTime", SqlDbType.DateTime).Value = endTime;
  } 
else     if (startTime > defaultDate && endTime > defaultDate)
 {
               whereClause.AppendLine(" AND date_time between @StartTime and @EndTime");
                sqlCommand.Parameters.Add("@StartTime", SqlDbType.DateTime).Value = startTime;
                 sqlCommand.Parameters.Add("@EndTime", SqlDbType.DateTime).Value = endTime;
  } 

else     if (startTime > defaultDate && endTime > defaultDate)
 {
               whereClause.AppendLine(" AND date_time between @StartTime and @EndTime");
                sqlCommand.Parameters.Add("@StartTime", SqlDbType.DateTime).Value = startTime;
                 sqlCommand.Parameters.Add("@EndTime", SqlDbType.DateTime).Value = endTime;
  } 
else   
 {
               whereClause.AppendLine(" AND date_time between @StartTime and @EndTime");
                sqlCommand.Parameters.Add("@StartTime", SqlDbType.DateTime).Value = startTime;
                 sqlCommand.Parameters.Add("@EndTime", SqlDbType.DateTime).Value = endTime;
  } 
>
Gregory
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform