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