private CommitUnitBase CreateMainUnit(TableMetadata metadata, DbExpression content)
{
var identity = metadata.Keys.FirstOrDefault(a
=> a.GeneratedForInsert != null && a.GeneratedForInsert.GeneratedOption == EGeneratedOption.Identity);
if (identity != null)
{
var identityMember = new CommitMember(identity, identity.GeneratedForInsert, ECommitValueType.Database);
var commitUnit = new CommitIdentityUnit(metadata, identityMember);
ReisterReturnMember(identityMember);
CreateCommitUnit(commitUnit, metadata.Members.Where(a => a != identity), content);
HasExpressionKey = commitUnit.Members.Any(a => a.Metadata.IsKey && a.ValueType == ECommitValueType.Expression);
return(commitUnit);
}
else
{
var commitUnit = new CommitKeyUnit(metadata);
CreateCommitUnit(commitUnit, metadata.Members, content);
HasExpressionKey = commitUnit.Keys.Any(a => a.ValueType == ECommitValueType.Expression);
return(commitUnit);
}
}
private SqlFragment GenerateForInsertIdentityMultipleRepeat(GenerateContext context, CommitIdentityUnit mainunit, ColumnMetadata rowindex,
TemporaryTableFragment temporaryTable, RowIndexFragment rowindexfragment, GenerateDataForInsert data, out TableFragment whileTarget)
{
var repeatfragment = new RepeatBlockFragment(context, data.Items);
var block = repeatfragment.Block;
var whileInsert = context.Insert(temporaryTable, mainunit.Table,
mainunit.Members.Where(a => a.ValueType != ECommitValueType.Database).Select(a => a.Metadata));
var whileSelect = (QueryBaseFragment)whileInsert.Query;
whileSelect.Where = context.Equal(temporaryTable.GetMember(rowindex), new RowIndexFragment(context));
block.Add(whileInsert);
var whileUpdate = new UpdateFragment(context, temporaryTable);
var getidentity = whileUpdate.CreateExpression(
context.Translate(Expression.Call(null, SupportMembers.DbFunctions.GetIdentity)));
whileUpdate.SetValue(mainunit.Identity.Metadata, getidentity);
whileUpdate.Where = context.Equal(temporaryTable.GetMember(rowindex), new RowIndexFragment(context));
block.Add(whileUpdate);
whileTarget = (TableFragment)whileInsert.Target;
return(repeatfragment);
}
private WhileFragment GenerateForInsertIdentityMultipleWhile(GenerateContext context, CommitIdentityUnit mainunit, CreateVariableFragment index,
ColumnMetadata rowindex, TemporaryTableFragment temporaryTable, RowIndexFragment rowindexfragment, out TableFragment whileTarget)
{
var whilefragment = new WhileFragment(context, context.LessThan(index.Name, rowindexfragment));
var block = whilefragment.Block;
var whileInsert = context.Insert(temporaryTable, mainunit.Table,
mainunit.Members.Where(a => a.ValueType != ECommitValueType.Database).Select(a => a.Metadata));
var whileSelect = (QueryBaseFragment)whileInsert.Query;
whileSelect.Where = context.Equal(temporaryTable.GetMember(rowindex), index.Name);
block.Add(whileInsert);
var whileUpdate = new UpdateFragment(context, temporaryTable);
var getidentity = whileUpdate.CreateExpression(
context.Translate(Expression.Call(null, SupportMembers.DbFunctions.GetIdentity)));
whileUpdate.SetValue(mainunit.Identity.Metadata, getidentity);
whileUpdate.Where = context.Equal(temporaryTable.GetMember(rowindex), index.Name);
block.Add(whileUpdate);
block.Add(context.Assign(index.Name, context.Add(index.Name, context.StatementString("1"))));
whileTarget = (TableFragment)whileInsert.Target;
return(whilefragment);
}
