/// <summary>
/// 强行添加条件 并不自动追加
/// </summary>
/// <param name="columnName">列名</param>
/// <param name="parameterType">值类型</param>
/// <param name="pagingParamType">连接类型</param>
/// <param name="values">值</param>
/// <returns></returns>
public void Where(string columnName, ParameterType parameterType, ParameterLinkType pagingParamType, params object[] values)
{
columnName = columnName.Trim();
if (!new Regex(@"^\[.*\]$").IsMatch(columnName))
{
columnName = "[" + columnName + "]";
}
_pagingParameterConfigurations.Add(new PagingParameterConfiguration
{
ColumnName = columnName,
ParameterType = parameterType,
AutoAppend = true,
LinkType = pagingParamType,
Values = values
});
}
/// <summary>
/// 强行添加条件 并不自动追加
/// </summary>
/// <param name="columnName">条件</param>
/// <param name="columnName">列名</param>
/// <param name="parameterType">值类型</param>
/// <param name="pagingParamType">连接类型</param>
/// <param name="values">值</param>
/// <returns></returns>
public void Whereif(bool condition, string columnName, ParameterType parameterType, ParameterLinkType pagingParamType, params object[] values)
{
if (condition)
{
Where(columnName, parameterType, pagingParamType, values);
}
}
/// <summary>
/// 追加条件
/// </summary>
/// <param name="columnName">列名</param>
/// <param name="values">值</param>
/// <param name="parameterType">值类型</param>
/// <param name="pagingParamType">连接类型</param>
/// <param name="auto">是否自动追加</param>
/// <returns></returns>
protected void AddSingleParameter(string columnName, object[] values, ParameterType parameterType, ParameterLinkType pagingParamType, bool auto = false)
{
Verification(columnName);
columnName = columnName.Trim();
if (!new Regex(@"^\[.*\]$").IsMatch(columnName))
{
columnName = "[" + columnName + "]";
}
parameters.Add(new List <PagingParameterConfiguration>
{
new PagingParameterConfiguration
{
ColumnName = columnName,
ParameterType = parameterType,
AutoAppend = auto,
LinkType = pagingParamType,
Values = values
}
});
}
