private BuildResult BuildInNotInOperation(string spaces) { var PART = new Dictionary <string, string> { [Constants.WHERE_OPERATION_IN] = "IN", [Constants.WHERE_OPERATION_NOT_IN] = "NOT_IN" }; var parameters = new List <SqlParameter>(); var list = new List <string>(); for (int i = 0; i < this.Values.Count; i++) { var parameterName = $"{ this.Column }_{ PART[this.Operation]}_{i}"; list.Add($"@{parameterName}"); var parameter = SqlParameterExtention.GetSqlParameter(parameterName, this.Values[i]); parameters.Add(parameter); } var text = string.Join(", ", list).Trim(); var sqlcommand = $"{spaces}{this.Condition} [{this.Column}] {this.Operation} ({text})"; var buildResult = new BuildResult(sqlcommand, parameters); return(buildResult); }
private BuildResult BuildCommonOperation(string spaces) { var sqlcommand = $"{spaces}{this.Condition} [{this.Column}] {this.Operation} @{this.Column}"; var parameter = SqlParameterExtention.GetSqlParameter(this.Column, this.Values[0]); var buildResult = new BuildResult(sqlcommand, new List <SqlParameter> { parameter }); return(buildResult); }
private BuildResult BuildBetweenOperation(string spaces) { var parameterNameA = $"{this.Column}{Constants.WHERE_OPERATION_BETWEEN_VALUE_A}"; var parameterNameB = $"{this.Column}{Constants.WHERE_OPERATION_BETWEEN_VALUE_B}"; var parameterA = SqlParameterExtention.GetSqlParameter(parameterNameA, this.Values[0]); var parameterB = SqlParameterExtention.GetSqlParameter(parameterNameB, this.Values[1]); var sqlcommand = $"{spaces}{this.Condition} [{this.Column}] {this.Operation} @{parameterNameA} {Constants.WHERE_CONDITION_AND} @{parameterNameB}"; var buildResult = new BuildResult(sqlcommand, new List <SqlParameter> { parameterA, parameterB }); return(buildResult); }