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