/***************************************************************************************************************/ public static bool IsNull_or_Empty(SQL_condition cond) { if (cond == null) { return(true); } return(string.IsNullOrEmpty(cond.SQL_str)); }
private string Create_SQL_str(SQL_condition con1, ConditionalOperator opt, SQL_relation rela2) { if (SQL_condition.IsNull_or_Empty(con1) && SQL_relation.IsNull_or_Empty(rela2)) { return(null); } if (SQL_condition.IsNull_or_Empty(con1)) { return(rela2.SQL_str); } if (SQL_relation.IsNull_or_Empty(rela2)) { return(con1.SQL_str); } SQL_condition con2 = new SQL_condition(rela2); return(this.Create_SQL_str(con1, opt, con2)); }
private string Create_SQL_str(SQL_condition con1, ConditionalOperator opt, SQL_condition con2) { if (SQL_condition.IsNull_or_Empty(con1) && SQL_condition.IsNull_or_Empty(con2)) { return(null); } if (SQL_condition.IsNull_or_Empty(con1)) { return(con2.SQL_str); } if (SQL_condition.IsNull_or_Empty(con2)) { return(con1.SQL_str); } StringBuilder sb = new StringBuilder("("); sb.Append(con1.SQL_str); sb.Append(' ').Append(opt.ToString()).Append(' '); sb.Append(con2.SQL_str); sb.Append(')'); return(sb.ToString()); }
public SQL_condition(SQL_condition con1, ConditionalOperator opt, SQL_condition con2) { this.SQL_str = this.Create_SQL_str(con1, opt, con2); }
public SQL_condition(SQL_relation rela1, ConditionalOperator opt, SQL_condition con2) { this.SQL_str = this.Create_SQL_str(con2, opt, rela1); }
public void SetCondition(SQL_condition cond) { this.condition = cond; }
public void SetCondition(SQL_relation rela) { SQL_condition cond = new SQL_condition(rela); this.condition = cond; }
public void Reset() { this.condition = null; this.excludeColumn_hs.Clear(); }
public void ClearCondition() { this.condition = null; }