/// <summary>
/// Generates an "insert" sql statement for the properties in the
/// business object
/// </summary>
/// <param name="propsToInclude">A collection of properties to insert,
/// if the previous include-all boolean was not set to true</param>
/// <param name="tableName">The table name</param>
private void GenerateSingleInsertStatement(IBOPropCol propsToInclude, string tableName)
{
ISupportsAutoIncrementingField supportsAutoIncrementingField = null;
if (_bo.Props.HasAutoIncrementingField)
{
supportsAutoIncrementingField = new SupportsAutoIncrementingFieldBO(_bo);
}
this.InitialiseStatement(tableName, supportsAutoIncrementingField);
ModifyForInheritance(propsToInclude);
foreach (BOProp prop in _bo.Props.SortedValues)
{
if (propsToInclude.Contains(prop.PropertyName))
{
if (!prop.PropDef.AutoIncrementing)
{
AddPropToInsertStatement(prop);
}
}
}
_insertSql.Statement.Append(String.Format(
"INSERT INTO {0} ({1}) VALUES ({2})",
_connection.SqlFormatter.DelimitTable(tableName),
_dbFieldList, _dbValueList));
_statements.Insert(0, _insertSql);
}
/// <summary>
/// Initialises the sql statement with a autoincrementing object
/// </summary>
private void InitialiseStatement(string tableName, ISupportsAutoIncrementingField supportsAutoIncrementingField)
{
_dbFieldList = new StringBuilder(_bo.Props.Count * 20);
_dbValueList = new StringBuilder(_bo.Props.Count * 20);
var statement = new InsertSqlStatement(_connection);
statement.TableName = tableName;
statement.SupportsAutoIncrementingField = supportsAutoIncrementingField;
_insertSql = statement;
_gen = _connection.CreateParameterNameGenerator();
_firstField = true;
}
/// <summary>
/// Initialises the sql statement with a autoincrementing object
/// </summary>
private void InitialiseStatement(string tableName, ISupportsAutoIncrementingField supportsAutoIncrementingField)
{
_dbFieldList = new StringBuilder(_bo.Props.Count * 20);
_dbValueList = new StringBuilder(_bo.Props.Count * 20);
var statement = new InsertSqlStatement(_connection);
statement.TableName = tableName;
statement.SupportsAutoIncrementingField = supportsAutoIncrementingField;
_insertSql = statement;
_gen = _connection.CreateParameterNameGenerator();
_firstField = true;
}
