/// <summary>
/// 添加假如为空时条件（不建议使用，建议更改数据库设计）
/// </summary>
/// <param name="key">要拼接的查询字段</param>
/// <param name="replaceValue">为空时要替换的值</param>
/// <param name="equalValue">比较的值</param>
/// <returns></returns>
public SqlWhereBuilder AppendIfNull(string key, string replaceValue, string equalValue)
{
if (key.IsNullOrEmptyWhiteSpace())
{
return(this);
}
if (replaceValue.IsNotNullAndNotEmptyWhiteSpace() && equalValue.IsNotNullAndNotEmptyWhiteSpace())
{
string trueReplaceValue = string.Empty;
bool isFormat = false;
if (IsStartWithSign(replaceValue))
{
trueReplaceValue = string.Format("{0}{1}", "{0}", Clean(replaceValue));
isFormat = true;
}
else
{
trueReplaceValue = replaceValue;
}
string trueEqualValue = string.Empty;
if (IsStartWithSign(equalValue))
{
trueEqualValue = string.Format("{0}{1}", "{0}", Clean(equalValue));
isFormat = true;
}
else
{
trueEqualValue = equalValue;
}
AddWhereInfo(string.Format(" {0}={1}", SqlQueryUtil.GetIfNull(_dbType, key, trueReplaceValue), trueEqualValue), isFormat: isFormat);
}
return(this);
}
/// <summary>
/// 添加假如为空时条件（不建议使用，建议更改数据库设计）
/// </summary>
/// <param name="key">要拼接的查询字段</param>
/// <param name="replaceValue">为空时要替换的值</param>
/// <param name="equalValue">比较的值</param>
/// <returns></returns>
public SqlWhereBuilder AppendIfNull(string key, int replaceValue, int equalValue)
{
if (key.IsNullOrEmptyWhiteSpace())
{
return(this);
}
else
{
AddWhereInfo(string.Format(" {0}={1}", SqlQueryUtil.GetIfNull(_dbType, key, replaceValue.ToString()), equalValue.ToString()), isFormat: false);
}
return(this);
}
