public Clause ColumnEquals(string column, SQLScriptParam param)
{
if (param == null)
{
throw new ArgumentNullException("param");
}
CheckColumnName(column);
return(new Clause(_accessor, string.Format("{0} = {1}", ConvertColumn(column), param.CoveredName),
new KeyValuePair <string, object>[] { param.ToKeyValuePair() }));
}
public Clause ColumnNotEquals(string column, SQLScriptParam param)
{
CheckTableBind();
return(_table.ColumnNotEquals(column, param));
//if (param == null) throw new ArgumentNullException("param");
//if (string.IsNullOrWhiteSpace(column)) throw new ArgumentNullException("column");
//var col = _table != null ? _table.ConvertColumn(column) : column.Trim();
//if (col == null) col = column.Trim();
//return new Clause(_accessor, string.Format("{0} <> {1}", col, param.CoveredName),
// new KeyValuePair<string, object>[] { param.ToKeyValuePair() });
}
public Clause ColumnBetween(string column, SQLScriptParam param1, SQLScriptParam param2)
{
CheckTableBind();
return(_table.ColumnBetween(column, param1, param2));
//if (param1 == null) throw new ArgumentNullException("param1");
//if (param2 == null) throw new ArgumentNullException("param2");
//if (string.IsNullOrWhiteSpace(column)) throw new ArgumentNullException("column");
//var col = _table != null ? _table.ConvertColumn(column) : column.Trim();
//if (col == null) col = column.Trim();
//return new Clause(_accessor, string.Format("{0} BETWEEN {1} AND {2}", col, param1.CoveredName, param2.CoveredName),
// new KeyValuePair<string, object>[] { param1.ToKeyValuePair(), param2.ToKeyValuePair() });
}
public Clause ColumnBetween(string column, SQLScriptParam param1, SQLScriptParam param2)
{
if (param1 == null)
{
throw new ArgumentNullException("param1");
}
if (param2 == null)
{
throw new ArgumentNullException("param2");
}
CheckColumnName(column);
return(new Clause(_accessor, string.Format("{0} BETWEEN {1} AND {2}", ConvertColumn(column), param1.CoveredName, param2.CoveredName),
new KeyValuePair <string, object>[] { param1.ToKeyValuePair(), param2.ToKeyValuePair() }));
}
public JoinItem ON(string column, SQLScriptParam param)
{
if (string.IsNullOrWhiteSpace(column))
{
throw new ArgumentNullException("column");
}
if (param == null)
{
throw new ArgumentNullException("param");
}
if (!this.Columns.Any(c => c.Key.Equals(column.Trim().ToUpper())))
{
throw new ApplicationException(string.Format("Column({0}) is not in table({1})", column, this.TableName));
}
var key = this.Columns.First(c => c.Key.Equals(column.Trim().ToUpper())).Value;
var clause = new Clause(_accessor, string.Format("{0} = {1}", key, param.CoveredName), new KeyValuePair <string, object>[] { param.ToKeyValuePair() });
return(ON(clause));
}
