/// <summary>
/// 清除全部过滤条件
/// </summary>
public void ClearAll()
{
Params.Clear();
Conditions.Clear();
ExecuteSql.Clear();
ExecuteSql.Append(InitSql);
}
/// <summary>
/// 添加过滤条件
/// </summary>
/// <param name="fieldName"></param>
/// <param name="value"></param>
public void And(string fieldName, object value)
{
string sql = ExecuteSql.ToString();
Type type = value.GetType();
string val = value.ToString();
if (type.Name == "String")
{
val = $"'{val}'";
}
if (sql.IndexOf("WHERE") == -1)
{
ExecuteSql.Append(" WHERE ");
ExecuteSql.Append($" {fieldName}={val}");
}
else
{
ExecuteSql.Append($" AND {fieldName}={val}");
}
Conditions.Add($"{fieldName}={val}");
Params.Add(new SqlParameter($"@{fieldName}", val));
}
