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