public string PrintCondition()
{
WhereStatment_Type conditionType = vidObj.conditionType;
switch (conditionType)
{
case WhereStatment_Type.LESS:
return("<");
case WhereStatment_Type.LESS_EQU:
return("<=");
case WhereStatment_Type.GREATER:
return(">");
case WhereStatment_Type.GREATER_EQU:
return(">=");
case WhereStatment_Type.EQU:
return("=");
case WhereStatment_Type.NOT_EQU:
return("<>");
case WhereStatment_Type.IN:
return("IN");
case WhereStatment_Type.EXISTS:
return("EXISTS");
case WhereStatment_Type.NOT_EXISTS:
return("NOT EXISTS");
}
return("=");
}
public void ToogleLeft_ConditionType()
{
WhereStatment_Type conditionType = vidObj.conditionType;
switch (conditionType)
{
case WhereStatment_Type.LESS:
ToggleHelper(WhereStatment_Type.LIKE, "LIKE", 150);
break;
case WhereStatment_Type.LESS_EQU:
ToggleHelper(WhereStatment_Type.LESS, "<", 244);
break;
case WhereStatment_Type.GREATER:
ToggleHelper(WhereStatment_Type.LESS_EQU, "<=", 244);
break;
case WhereStatment_Type.GREATER_EQU:
ToggleHelper(WhereStatment_Type.GREATER, "<", 244);
break;
case WhereStatment_Type.EQU:
ToggleHelper(WhereStatment_Type.GREATER_EQU, "<=", 244);
break;
case WhereStatment_Type.NOT_EQU:
ToggleHelper(WhereStatment_Type.EQU, "=", 244);
break;
case WhereStatment_Type.IN:
ToggleHelper(WhereStatment_Type.NOT_EQU, "<>", 244);
break;
case WhereStatment_Type.EXISTS:
ToggleHelper(WhereStatment_Type.IN, "IN", 150);
break;
case WhereStatment_Type.NOT_EXISTS:
ToggleHelper(WhereStatment_Type.EXISTS, "EXISTS", 75);
break;
case WhereStatment_Type.LIKE:
ToggleHelper(WhereStatment_Type.NOT_EXISTS, "NOT_EXISTS", 50);
break;
}
CheckInputs();
}
public void CheckInputs()
{
WhereStatment_Type conditionType = vidObj.conditionType;
switch (conditionType)
{
case WhereStatment_Type.LESS:
case WhereStatment_Type.LESS_EQU:
case WhereStatment_Type.GREATER:
case WhereStatment_Type.GREATER_EQU:
ConnectionChecker_NOTEQU(0, VidData_Type.DATABASE_COL);
ConnectionChecker_NOTEQU(1, VidData_Type.NUM);
break;
case WhereStatment_Type.EQU:
case WhereStatment_Type.NOT_EQU:
ConnectionChecker_NOTEQU(0, VidData_Type.DATABASE_COL);
ConnectionChecker_EQU(1, VidData_Type.Q_SELECT);
break;
case WhereStatment_Type.IN:
ConnectionChecker_NOTEQU(0, VidData_Type.DATABASE_COL);
ConnectionChecker_NOTEQU(1, VidData_Type.Q_SELECT);
break;
case WhereStatment_Type.EXISTS:
case WhereStatment_Type.NOT_EXISTS:
ConnectionChecker(0);
ConnectionChecker_NOTEQU(1, VidData_Type.Q_SELECT);
break;
case WhereStatment_Type.LIKE:
ConnectionChecker_NOTEQU(0, VidData_Type.DATABASE_COL);
ConnectionChecker_NOTEQU(1, VidData_Type.STRING);
break;
}
}
private void ToggleHelper(WhereStatment_Type changeType, string s, int fountSize)
{
vidObj.conditionType = changeType;
dataText.text = s;
dataText.fontSize = fountSize;
}
private void ToggleHelper(WhereStatment_Type changeType, string s, int fountSize) {
vidObj.conditionType = changeType;
dataText.text = s;
dataText.fontSize = fountSize;
}