// 创建 DELETE 命令
protected override Command ParseDeleteCommand <T>(DbQueryableInfo_Delete <T> dQueryInfo, ParserToken token)
{
TypeRuntimeInfo typeRuntime = TypeRuntimeInfoCache.GetRuntimeInfo <T>();
ISqlBuilder builder = this.CreateSqlBuilder(token);
bool useKey = false;
builder.Append("DELETE FROM ");
builder.AppendMember(typeRuntime.TableName, !typeRuntime.IsTemporary);
builder.Append(" t0 ");
if (dQueryInfo.Entity != null)
{
object entity = dQueryInfo.Entity;
builder.AppendNewLine();
builder.Append("WHERE ");
foreach (var kv in typeRuntime.Invokers)
{
MemberInvokerBase invoker = kv.Value;
var column = invoker.Column;
if (column != null && column.IsKey)
{
useKey = true;
var value = invoker.Invoke(entity);
var seg = builder.GetSqlValue(value, column);
builder.AppendMember("t0", invoker.Member.Name);
builder.Append(" = ");
builder.Append(seg);
builder.Append(" AND ");
}
;
}
builder.Length -= 5;
if (!useKey)
{
throw new XFrameworkException("Delete<T>(T value) require T must have key column.");
}
}
else if (dQueryInfo.SelectInfo != null)
{
TableAliasCache aliases = this.PrepareAlias <T>(dQueryInfo.SelectInfo, token);
var cmd2 = new OracleSelectInfoCommand(this, aliases, token);
cmd2.HasManyNavigation = dQueryInfo.SelectInfo.HasManyNavigation;
var visitor0 = new OracleExistsExpressionVisitor(this, aliases, dQueryInfo.SelectInfo.Joins, dQueryInfo.SelectInfo.WhereExpression);
visitor0.Write(cmd2);
var visitor1 = new OracleWhereExpressionVisitor(this, aliases, dQueryInfo.SelectInfo.WhereExpression);
visitor1.Write(cmd2.WhereFragment);
cmd2.AddNavMembers(visitor1.NavMembers);
builder.Append(cmd2.CommandText);
}
builder.Append(';');
return(new Command(builder.ToString(), builder.Token != null ? builder.Token.Parameters : null, System.Data.CommandType.Text));
}
// 创建 UPDATE 命令
protected override Command ParseUpdateCommand <T>(DbQueryableInfo_Update <T> uQueryInfo, ParserToken token)
{
ISqlBuilder builder = this.CreateSqlBuilder(token);
var typeRuntime = TypeRuntimeInfoCache.GetRuntimeInfo <T>();
builder.Append("UPDATE ");
builder.AppendMember(typeRuntime.TableName, !typeRuntime.IsTemporary);
builder.Append(" t0 SET");
builder.AppendNewLine();
if (uQueryInfo.Entity != null)
{
object entity = uQueryInfo.Entity;
ISqlBuilder whereBuilder = this.CreateSqlBuilder(token);
bool useKey = false;
int length = 0;
foreach (var kv in typeRuntime.Invokers)
{
MemberInvokerBase invoker = kv.Value;
var column = invoker.Column;
if (column != null && column.IsIdentity)
{
goto gotoLabel; // fix issue# 自增列同时又是主键
}
if (column != null && column.NoMapped)
{
continue;
}
if (invoker.ForeignKey != null)
{
continue;
}
if (invoker.Member.MemberType == System.Reflection.MemberTypes.Method)
{
continue;
}
builder.AppendMember(invoker.Member.Name);
builder.Append(" = ");
gotoLabel:
if (column == null || !column.IsIdentity)
{
var value = invoker.Invoke(entity);
var seg = builder.GetSqlValueWidthDefault(value, column);
builder.Append(seg);
length = builder.Length;
builder.Append(',');
builder.AppendNewLine();
}
if (column != null && column.IsKey)
{
useKey = true;
}
}
if (!useKey)
{
throw new XFrameworkException("Update<T>(T value) require T must have key column.");
}
// ORACLE 需要注意参数顺序问题
int index = -1;
foreach (var kv in typeRuntime.KeyInvokers)
{
MemberInvokerBase invoker = kv.Value;
var column = invoker.Column;
var value = invoker.Invoke(entity);
var seg = builder.GetSqlValueWidthDefault(value, column);
index += 1;
whereBuilder.AppendMember(invoker.Member.Name);
whereBuilder.Append(" = ");
whereBuilder.Append(seg);
if (index < typeRuntime.KeyInvokers.Count - 1)
{
whereBuilder.Append(" AND ");
}
}
builder.Length = length;
builder.AppendNewLine();
builder.Append("WHERE ");
builder.Append(whereBuilder);
}
else if (uQueryInfo.Expression != null)
{
TableAliasCache aliases = this.PrepareAlias <T>(uQueryInfo.SelectInfo, token);
ExpressionVisitorBase visitor = null;
visitor = new OracleUpdateExpressionVisitor(this, aliases, uQueryInfo.Expression);
visitor.Write(builder);
var cmd2 = new OracleSelectInfoCommand(this, aliases, token);
cmd2.HasManyNavigation = uQueryInfo.SelectInfo.HasManyNavigation;
var visitor0 = new OracleExistsExpressionVisitor(this, aliases, uQueryInfo.SelectInfo.Joins, uQueryInfo.SelectInfo.WhereExpression);
visitor0.Write(cmd2);
var visitor1 = new OracleWhereExpressionVisitor(this, aliases, uQueryInfo.SelectInfo.WhereExpression);
visitor1.Write(cmd2.WhereFragment);
cmd2.AddNavMembers(visitor1.NavMembers);
builder.Append(cmd2.CommandText);
}
builder.Append(';');
return(new Command(builder.ToString(), builder.Token != null ? builder.Token.Parameters : null, System.Data.CommandType.Text));
}