/// <summary>
/// 获取decimal值
/// </summary>
/// <param name="sqlQuery">Sql查询对象</param>
/// <param name="connection">数据库连接</param>
public static decimal ToDecimal(this ISqlQuery sqlQuery, IDbConnection connection = null)
{
return(Util.Helpers.Convert.ToDecimal(sqlQuery.ToScalar(connection)));
}
/// <summary>
/// 获取日期值
/// </summary>
/// <param name="sqlQuery">Sql查询对象</param>
/// <param name="connection">数据库连接</param>
public static DateTime ToDate(this ISqlQuery sqlQuery, IDbConnection connection = null)
{
return(Util.Helpers.Convert.ToDate(sqlQuery.ToScalar(connection)));
}
/// <summary>
/// 获取可空整型值
/// </summary>
/// <param name="sqlQuery">Sql查询对象</param>
/// <param name="connection">数据库连接</param>
/// <returns></returns>
public static int?ToIntOrNull(this ISqlQuery sqlQuery, IDbConnection connection = null)
{
return(Conv.ToIntOrNull(sqlQuery.ToScalar(connection)));
}
/// <summary>
/// 获取可空整型值
/// </summary>
/// <param name="sqlQuery">Sql查询对象</param>
/// <param name="connection">数据库连接</param>
public static int?ToIntOrNull(this ISqlQuery sqlQuery, IDbConnection connection = null)
{
return(Ding.Helpers.Convert.ToIntOrNull(sqlQuery.ToScalar(connection)));
}
/// <summary>
/// 获取可空float值
/// </summary>
/// <param name="sqlQuery">Sql查询对象</param>
/// <param name="connection">数据库连接</param>
/// <returns></returns>
public static decimal?ToDecimalOrNull(this ISqlQuery sqlQuery, IDbConnection connection = null)
{
return(Conv.ToDecimalOrNull(sqlQuery.ToScalar(connection)));
}
/// <summary>
/// 获取可空日期值
/// </summary>
/// <param name="sqlQuery">Sql查询对象</param>
/// <param name="connection">数据库连接</param>
/// <returns></returns>
public static DateTime?ToDateOrNull(this ISqlQuery sqlQuery, IDbConnection connection = null)
{
return(Conv.ToDateOrNull(sqlQuery.ToScalar(connection)));
}
/// <summary> /// 获取日期值 /// </summary> /// <param name="sqlQuery">Sql查询对象</param> /// <param name="connection">数据库连接</param> public static DateTime ToDate(this ISqlQuery sqlQuery, IDbConnection connection = null) => Conv.ToDate(sqlQuery.ToScalar(connection));
/// <summary>
/// 获取double值
/// </summary>
/// <param name="sqlQuery">Sql查询对象</param>
/// <param name="connection">数据库连接</param>
/// <returns></returns>
public static double ToDouble(this ISqlQuery sqlQuery, IDbConnection connection = null)
{
return(Conv.ToDouble(sqlQuery.ToScalar(connection)));
}
/// <summary> /// 获取decimal值 /// </summary> /// <param name="sqlQuery">Sql查询对象</param> /// <param name="connection">数据库连接</param> public static decimal ToDecimal(this ISqlQuery sqlQuery, IDbConnection connection = null) => Conv.ToDecimal(sqlQuery.ToScalar(connection));
/// <summary> /// 获取可空布尔值 /// </summary> /// <param name="sqlQuery">Sql查询对象</param> /// <param name="connection">数据库连接</param> public static bool?ToBoolOrNull(this ISqlQuery sqlQuery, IDbConnection connection = null) => Conv.ToBoolOrNull(sqlQuery.ToScalar(connection));
/// <summary> /// 获取可空float值 /// </summary> /// <param name="sqlQuery">Sql查询对象</param> /// <param name="connection">数据库连接</param> public static double?ToDoubleOrNull(this ISqlQuery sqlQuery, IDbConnection connection = null) => Conv.ToDoubleOrNull(sqlQuery.ToScalar(connection));
/// <summary>
/// 获取可空布尔值
/// </summary>
/// <param name="sqlQuery">Sql查询对象</param>
/// <param name="connection">数据库连接</param>
public static bool?ToBoolOrNull(this ISqlQuery sqlQuery, IDbConnection connection = null)
{
return(Core.Helpers.Convert.ToBoolOrNull(sqlQuery.ToScalar(connection)));
}
/// <summary>
/// 获取float值
/// </summary>
/// <param name="sqlQuery">Sql查询对象</param>
/// <param name="connection">数据库连接</param>
public static float ToFloat(this ISqlQuery sqlQuery, IDbConnection connection = null)
{
return(Ding.Helpers.Convert.ToFloat(sqlQuery.ToScalar(connection)));
}
/// <summary>
/// 获取Guid值
/// </summary>
/// <param name="sqlQuery">Sql查询对象</param>
/// <param name="connection">数据库连接</param>
public static Guid ToGuid(this ISqlQuery sqlQuery, IDbConnection connection = null)
{
return(Util.Helpers.Convert.ToGuid(sqlQuery.ToScalar(connection)));
}
/// <summary> /// 获取可空Guid值 /// </summary> /// <param name="sqlQuery">Sql查询对象</param> /// <param name="connection">数据库连接</param> public static Guid?ToGuidOrNull(this ISqlQuery sqlQuery, IDbConnection connection = null) => Conv.ToGuidOrNull(sqlQuery.ToScalar(connection));
/// <summary>
/// 获取可空float值
/// </summary>
/// <param name="sqlQuery">Sql查询对象</param>
/// <param name="connection">数据库连接</param>
public static float?ToFloatOrNull(this ISqlQuery sqlQuery, IDbConnection connection = null)
{
return(Util.Helpers.Convert.ToFloatOrNull(sqlQuery.ToScalar(connection)));
}
/// <summary> /// 获取整型值 /// </summary> /// <param name="sqlQuery">Sql查询对象</param> /// <param name="connection">数据库连接</param> public static int ToInt(this ISqlQuery sqlQuery, IDbConnection connection = null) => Conv.ToInt(sqlQuery.ToScalar(connection));
/// <summary>
/// 获取字符串值
/// </summary>
/// <param name="sqlQuery">Sql查询对象</param>
/// <param name="connection">数据库连接</param>
/// <returns></returns>
public static string ToString(this ISqlQuery sqlQuery, IDbConnection connection = null)
{
return(sqlQuery.ToScalar(connection).SafeString());
}
/// <summary> /// 获取可空float值 /// </summary> /// <param name="sqlQuery">Sql查询对象</param> /// <param name="connection">数据库连接</param> public static float?ToFloatOrNull(this ISqlQuery sqlQuery, IDbConnection connection = null) => Conv.ToFloatOrNull(sqlQuery.ToScalar(connection));
/// <summary>
/// 获取布尔值
/// </summary>
/// <param name="sqlQuery">Sql查询对象</param>
/// <param name="connection">数据库连接</param>
/// <returns></returns>
public static bool ToBool(this ISqlQuery sqlQuery, IDbConnection connection = null)
{
return(Conv.ToBool(sqlQuery.ToScalar(connection)));
}
/// <summary>
/// 获取整型值
/// </summary>
/// <param name="sqlQuery">Sql查询对象</param>
/// <param name="connection">数据库连接</param>
public static int ToInt(this ISqlQuery sqlQuery, IDbConnection connection = null)
{
return(Convert.ToInt(sqlQuery.ToScalar(connection)));
}
/// <summary>
/// 获取Guid值
/// </summary>
/// <param name="sqlQuery">Sql查询对象</param>
/// <param name="connection">数据库连接</param>
/// <returns></returns>
public static Guid ToGuid(this ISqlQuery sqlQuery, IDbConnection connection = null)
{
return(Conv.ToGuid(sqlQuery.ToScalar(connection)));
}
/// <summary>
/// 获取可空Guid值
/// </summary>
/// <param name="sqlQuery">Sql查询对象</param>
/// <param name="connection">数据库连接</param>
public static Guid?ToGuidOrNull(this ISqlQuery sqlQuery, IDbConnection connection = null)
{
return(Convert.ToGuidOrNull(sqlQuery.ToScalar(connection)));
}
/// <summary>
/// 获取float值
/// </summary>
/// <param name="sqlQuery">Sql查询对象</param>
/// <param name="connection">数据库连接</param>
/// <returns></returns>
public static float ToFloat(this ISqlQuery sqlQuery, IDbConnection connection = null)
{
return(Conv.ToFloat(sqlQuery.ToScalar(connection)));
}
/// <summary>
/// 获取double值
/// </summary>
/// <param name="sqlQuery">Sql查询对象</param>
/// <param name="connection">数据库连接</param>
public static double ToDouble(this ISqlQuery sqlQuery, IDbConnection connection = null)
{
return(Ding.Helpers.Convert.ToDouble(sqlQuery.ToScalar(connection)));
}