/// <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)); }