public void addParameterValueTable(string table, string col, object value, SqlTypeRelations relMath)
{
addParameterValueTable(table, col, value, relMath, SqlTypeRelations.boolAnd);
}
public void addParameterValueTable(string table, string col, object value, SqlTypeRelations relMath, SqlTypeRelations relBool)
{
try
{
if ((table != null) && (col != null) && (value != null))
{
// Type typeWate = getColumnType(table, col);
if (true
//isColumnExists(table, col) &&
//(value.GetType() == DBNull.Value.GetType() ||
// (value = Convert.ChangeType(value, typeWate, null)) != null
//)
)
{
object[] arr = new object[] { tableWhereRecodrType.common, table, col, value, relMath, relBool, getPatternWhere() };
int indx = tableWhere.Rows.Count - 1;
for (; indx >= 0; --indx)
{
DataRow lastRow = tableWhere.Rows[indx];
if (isLineCommon(lastRow) && (getLinePatern(lastRow) == getPatternWhere()))
{
string targetCol = ToolColumn.getColumnFullName(table, col);
string curCol = ToolColumn.getColumnFullName((string)lastRow[TableDUMMY.PARENTNAME], (string)lastRow[TableDUMMY.CHILDNAME]);
if (string.Compare(targetCol, curCol) < 0)
{
continue;
}
}
++indx;
break;
}
ToolTable.insertRowAt(tableWhere, indx, arr);
return;
}
}
}
catch (Exception exc)
{
throw exc;
}
throw new MyException.MyExceptionInner(MessageCollection.T_MSG_ERROR_INNER);
}
public SqlBuilderPreparerFixedConditionTable(string pTab, string pCol, object pValue, SqlTypeRelations pRelMath, SqlTypeRelations pRelBool)
: base(pTab, pCol, new ImplObjectSourceStaticValue(pValue), pRelMath, pRelBool)
{
}
public SqlBuilderPreparerObjectSourceTable(string pTab, string pCol, IObjectSource pValue, SqlTypeRelations pRelMath, SqlTypeRelations pRelBool)
{
tab = pTab;
col = pCol;
value = pValue;
relMath = pRelMath;
relBool = pRelBool;
}
public SqlBuilderPreparerFixedSort(string col, SqlTypeRelations sort)
{
list.Add(new object[] { col, sort });
}
