private string ConvertDatepart(DatepartType datepart)
{
switch (datepart)
{
case DatepartType.Day:
return("day");
case DatepartType.Hour:
return("hour");
case DatepartType.Millisecond:
return("millisecond");
case DatepartType.Minute:
return("minute");
case DatepartType.Month:
return("month");
case DatepartType.Second:
return("second");
case DatepartType.Year:
return("year");
default:
return("");
}
}
public string Datepart(DatepartType datepart, string FieldExp)
{
return(string.Format("Datepart({0},{1})", ConvertDatepart(datepart), FieldExp));
}
public string Datediff(DatepartType datepart, string BeginFieldExp, string EndFieldExp)
{
return(string.Format("Datediff({0},{1},{2})", ConvertDatepart(datepart), BeginFieldExp, EndFieldExp));
}
public string DateAdd(DatepartType datepart, int AddValue, string FieldExp)
{
return(string.Format("DateAdd({0},{1},{2})", ConvertDatepart(datepart), AddValue, FieldExp));
}
