/// <summary>
/// 格式化Select语句中的列名
/// </summary>
/// <param name="splitChat"></param>
/// <param name="columns"></param>
/// <returns></returns>
public override string FormatQueryColumn(string splitChat, ICollection <string> columns)
{
return(SqlParamHelper.FormatQueryColumn(splitChat, columns));
}
/// <summary>
///
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public override string FormatName(string name)
{
return(SqlParamHelper.FormatName(name));
}
/// <summary>
///
/// </summary>
/// <param name="paramName"></param>
/// <param name="value"></param>
/// <returns></returns>
public override IDataParameter CreateParameterByBlob(string paramName, object value)
{
return(SqlParamHelper.MakeInParam(paramName, SqlDbType.VarBinary, 0, value));
}
/// <summary>
/// 格式化条件语句中的参数
/// </summary>
/// <param name="fieldName"></param>
/// <param name="compareChar"></param>
/// <param name="paramName"></param>
/// <returns></returns>
public override string FormatFilterParam(string fieldName, string compareChar = "", string paramName = "")
{
return(SqlParamHelper.FormatFilterParam(fieldName, compareChar, paramName));
}
/// <summary>
///
/// </summary>
/// <param name="paramName"></param>
/// <param name="value"></param>
/// <returns></returns>
public override IDataParameter CreateParameterLongBlob(string paramName, object value)
{
return(SqlParamHelper.MakeInParam(paramName, SqlDbType.Image, 0, value));
}
/// <summary>
///
/// </summary>
/// <param name="paramName"></param>
/// <param name="value"></param>
/// <returns></returns>
public override IDataParameter CreateParameterByText(string paramName, object value)
{
return(SqlParamHelper.MakeInParam(paramName, SqlDbType.Text, 0, value));
}
/// <summary>
///
/// </summary>
/// <param name="paramName"></param>
/// <param name="value"></param>
/// <returns></returns>
public override IDataParameter CreateParameterByGuid(string paramName, object value)
{
return(SqlParamHelper.MakeInParam(paramName, SqlDbType.UniqueIdentifier, 0, value));
}
/// <summary>
///
/// </summary>
/// <param name="paramName"></param>
/// <param name="dbType"></param>
/// <param name="size"></param>
/// <param name="value"></param>
/// <returns></returns>
public override IDataParameter CreateParameter(string paramName, int dbType, int size, object value)
{
return(SqlParamHelper.MakeInParam(paramName, (SqlDbType)dbType, size, value));
}
/// <summary>
///
/// </summary>
/// <param name="paramName"></param>
/// <param name="value"></param>
/// <returns></returns>
public override IDataParameter CreateParameter(string paramName, object value)
{
return(SqlParamHelper.MakeInParam(paramName, value));
}