public static void GetDuratioin(DateTimeConstants constants, ref string begin, ref string end)
{
switch (constants)
{
case DateTimeConstants.Today:
begin = DateTime.Today.ToString("yyyyMMdd");
end = DateTime.Today.AddDays(1).ToString("yyyyMMdd");
break;
case DateTimeConstants.Yesterday:
begin = DateTime.Today.AddDays(-1).ToString("yyyyMMdd");
end = DateTime.Today.ToString("yyyyMMdd");
break;
case DateTimeConstants.LastWeek:
begin = DateTime.Today.AddDays(-7).ToString("yyyyMMdd");
end = DateTime.Today.ToString("yyyyMMdd");
break;
case DateTimeConstants.LastMonth:
begin = DateTime.Today.AddMonths(-1).ToString("yyyyMMdd");
end = DateTime.Today.ToString("yyyyMMdd");
break;
case DateTimeConstants.ThisYear:
begin = DateTime.Today.AddYears(-1).ToString("yyyyMMdd");
end = DateTime.Today.ToString("yyyyMMdd");
break;
case DateTimeConstants.LastYear:
begin = DateTime.Today.AddYears(-2).ToString("yyyyMMdd");
end = DateTime.Today.ToString("yyyyMMdd");
break;
}
}
public static void GetDuratioin(DateTimeConstants constants, ref string begin, ref string end)
{
switch(constants)
{
case DateTimeConstants.Today:
begin = DateTime.Today.ToString("yyyyMMdd");
end = DateTime.Today.AddDays(1).ToString("yyyyMMdd");
break;
case DateTimeConstants.Yesterday:
begin = DateTime.Today.AddDays(-1).ToString("yyyyMMdd");
end = DateTime.Today.ToString("yyyyMMdd");
break;
case DateTimeConstants.LastWeek:
begin = DateTime.Today.AddDays(-7).ToString("yyyyMMdd");
end = DateTime.Today.ToString("yyyyMMdd");
break;
case DateTimeConstants.LastMonth:
begin = DateTime.Today.AddMonths(-1).ToString("yyyyMMdd");
end = DateTime.Today.ToString("yyyyMMdd");
break;
case DateTimeConstants.ThisYear:
begin = DateTime.Today.AddYears(-1).ToString("yyyyMMdd");
end = DateTime.Today.ToString("yyyyMMdd");
break;
case DateTimeConstants.LastYear:
begin = DateTime.Today.AddYears(-2).ToString("yyyyMMdd");
end = DateTime.Today.ToString("yyyyMMdd");
break;
}
}
private static void GetDuration(string duration, ref string begin, ref string end)
{
if (string.IsNullOrWhiteSpace(duration))
{
begin = string.Empty;
end = string.Empty;
}
else
{
DateTimeConstants constants = (DateTimeConstants)Enum.Parse(typeof(DateTimeConstants), duration);
GetDuratioin(constants, ref begin, ref end);
}
}
public static void ConvertTimeSpanToSql_SqlServer(this StringBuilder stringBuilder, SqlDataType sqlDataType, TimeSpan value)
{
if (sqlDataType.Type.DataType == DataType.Int64)
{
stringBuilder.Append(value.Ticks);
}
else
{
var format = value.Days > 0
? DateTimeConstants.TimeSpanFormat(value.Ticks % 10000000 != 0 ? 7 : 0)
: DateTimeConstants.SqlTimeFormat(value.Ticks % 10000000 != 0 ? 7 : 0);
stringBuilder.AppendFormat(CultureInfo.InvariantCulture, format, value);
}
}
public static string ToSqlTime(this TimeSpan ts, int milliSecondsPrecision = 0) => ts.ToString(DateTimeConstants.SqlTimeFormat(milliSecondsPrecision));