internal DbSelectStatement BuildInsertScalarStatement <TSource>(DataSet <TSource> dataSet, int rowOrdinal, IReadOnlyList <ColumnMapping> columnMappings)
where TSource : class, IEntity, new()
{
var sourceModel = dataSet._;
var parentMappings = ShouldJoinParent(dataSet) ? this.Model.GetParentRelationship(columnMappings) : null;
var paramManager = new ScalarParamManager(dataSet[rowOrdinal]);
var select = GetScalarMapping(paramManager, columnMappings);
IDbTable parentTable = null;
if (parentMappings != null)
{
parentTable = (IDbTable)Model.ParentModel.DataSource;
Debug.Assert(parentTable != null);
var parentRowIdMapping = new ColumnMapping(Model.GetSysParentRowIdColumn(createIfNotExist: false),
parentTable.Model.GetSysRowIdColumn(createIfNotExist: false));
select = select.Append(parentRowIdMapping);
}
DbFromClause from = GetScalarDataSource(paramManager, parentMappings);
DbExpression where = null;
if (from != null)
{
if (parentMappings != null)
{
from = new DbJoinClause(DbJoinKind.InnerJoin, from, parentTable.FromClause, parentMappings);
}
}
return(new DbSelectStatement(Model, select, from, where, null, -1, -1));
}
internal DbSelectStatement BuildDeleteScalarStatement(DataRow dataRow, IReadOnlyList <ColumnMapping> join)
{
var paramManager = new ScalarParamManager(dataRow);
var from = new DbJoinClause(DbJoinKind.InnerJoin, GetScalarDataSource(paramManager, join), FromClause, join);
return(new DbSelectStatement(Model, null, from, null, null, -1, -1));
}
private static DbSelectStatement GetScalarDataSource(ScalarParamManager paramManager, IReadOnlyList <ColumnMapping> parentMappings = null)
{
if (parentMappings == null)
{
return(null);
}
var select = GetScalarMapping(paramManager, parentMappings, true);
return(new DbSelectStatement(paramManager.Model, select, null, null, null, -1, -1));
}
private static IReadOnlyList <ColumnMapping> GetScalarMapping(ScalarParamManager paramManager, IReadOnlyList <ColumnMapping> mappings, bool mapToSource = false)
{
var result = new ColumnMapping[mappings.Count];
for (int i = 0; i < mappings.Count; i++)
{
var mapping = mappings[i];
var sourceColumn = mapping.Source;
var source = paramManager.GetParam(sourceColumn);
result[i] = new ColumnMapping(source, mapToSource ? sourceColumn : mapping.Target);
}
return(result);
}
