/// <summary>
/// 获取 DatetTime 类型的 SQL 片断
/// </summary>
/// <param name="value">值</param>
/// <param name="dbType">数据类型</param>
/// <param name="scale">小数位</param>
/// <returns></returns>
protected override string GetSqlValueOfDateTime(object value, object dbType, int?scale)
{
// 默认精度为0
string format = "yyyy-MM-dd HH:mm:ss";
if (MySqlUtils.IsDate(dbType))
{
format = "yyyy-MM-dd";
}
else if (MySqlUtils.IsDateTime(dbType))
{
string s = string.Empty;
if (scale != null && scale.Value > 0)
{
s = string.Empty.PadLeft(scale.Value > 6 ? 6 : scale.Value, 'f');
}
if (!string.IsNullOrEmpty(s))
{
format = string.Format("yyyy-MM-dd HH:mm:ss.{0}", s);
}
}
string result = this.EscapeQuote(((DateTime)value).ToString(format), false, false);
return(result);
}
/// <summary>
/// 是否日期+时间+精度类型
/// </summary>
/// <param name="dbType">DbType属性</param>
/// <returns></returns>
public static bool IsDateTime2(object dbType)
{
return(MySqlUtils.IsDateTime(dbType));
}
