protected internal virtual Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledSelect CompileSelect(Net.Vpc.Upa.Expressions.Select v, Net.Vpc.Upa.Impl.Uql.ExpressionTranslationManager manager, Net.Vpc.Upa.Impl.Uql.ExpressionDeclarationList declarations)
{
if (v == null)
{
return(null);
}
Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledSelect s = new Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledSelect();
s.SetDistinct(v.IsDistinct());
s.SetTop(v.GetTop());
Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledNameOrSelect nameOrSelect = (Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledNameOrSelect)manager.TranslateAny(v.GetEntity(), declarations);
string entityAlias = v.GetEntityAlias();
System.Collections.Generic.HashSet <string> aliases = new System.Collections.Generic.HashSet <string>();
if (entityAlias == null)
{
if (nameOrSelect is Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledEntityName)
{
entityAlias = ((Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledEntityName)nameOrSelect).GetName();
}
else
{
entityAlias = "ALIAS";
}
int i = 0;
while (true)
{
string a2 = i == 0 ? entityAlias : (entityAlias + i);
if (!aliases.Contains(a2))
{
aliases.Add(a2);
entityAlias = a2;
break;
}
i++;
}
}
s.From(nameOrSelect, entityAlias);
for (int i = 0; i < v.CountJoins(); i++)
{
Net.Vpc.Upa.Expressions.JoinCriteria c = v.GetJoin(i);
Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledNameOrSelect jnameOrSelect = (Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledNameOrSelect)manager.TranslateAny(c.GetEntity(), declarations);
entityAlias = c.GetEntityAlias();
if (entityAlias == null)
{
if (nameOrSelect is Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledEntityName)
{
entityAlias = ((Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledEntityName)nameOrSelect).GetName();
}
else
{
entityAlias = "ALIAS";
}
i = 0;
while (true)
{
string a2 = i == 0 ? entityAlias : (entityAlias + i);
if (!aliases.Contains(a2))
{
aliases.Add(a2);
entityAlias = a2;
break;
}
i++;
}
}
Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledJoinCriteria cc = new Net.Vpc.Upa.Impl.Uql.Compiledexpression.CompiledJoinCriteria(c.GetJoinType(), jnameOrSelect, entityAlias, manager.TranslateAny(c.GetCondition(), declarations));
s.Join(cc);
}
for (int i = 0; i < v.CountFields(); i++)
{
Net.Vpc.Upa.Expressions.QueryField field = v.GetField(i);
s.Field(manager.TranslateAny(field.GetExpression(), declarations), field.GetAlias());
}
s.Where(manager.TranslateAny(v.GetWhere(), declarations));
s.Having(manager.TranslateAny(v.GetHaving(), declarations));
for (int i = 0; i < v.CountGroupByItems(); i++)
{
Net.Vpc.Upa.Expressions.Expression c = v.GetGroupBy(i);
s.GroupBy(manager.TranslateAny(c, declarations));
}
for (int i = 0; i < v.CountOrderByItems(); i++)
{
Net.Vpc.Upa.Expressions.Expression c = v.GetOrderBy(i);
s.OrderBy(manager.TranslateAny(c, declarations), v.IsOrderAscending(i));
}
return(s);
}
public virtual int Update(Net.Vpc.Upa.Entity entity, Net.Vpc.Upa.Persistence.EntityExecutionContext context, Net.Vpc.Upa.Record updates, Net.Vpc.Upa.Expressions.Expression condition) /* throws Net.Vpc.Upa.Exceptions.UPAException */
{
Net.Vpc.Upa.Expressions.Update u = new Net.Vpc.Upa.Expressions.Update().Entity(entity.GetName());
foreach (string fieldName in updates.KeySet())
{
Net.Vpc.Upa.Field f = entity.FindField(fieldName);
if (f != null && Net.Vpc.Upa.Impl.Util.Filters.Fields2.UPDATE.Accept(f))
{
object @value = updates.GetObject <T>(fieldName);
if ((f.GetDataType() is Net.Vpc.Upa.Types.ManyToOneType))
{
Net.Vpc.Upa.Types.ManyToOneType e = (Net.Vpc.Upa.Types.ManyToOneType)f.GetDataType();
if (e.IsUpdatable())
{
Net.Vpc.Upa.Entity masterEntity = context.GetPersistenceUnit().GetEntity(e.GetTargetEntityName());
Net.Vpc.Upa.EntityBuilder mbuilder = masterEntity.GetBuilder();
if (@value is Net.Vpc.Upa.Expressions.Expression)
{
Net.Vpc.Upa.Expressions.Expression evalue;
System.Collections.Generic.IList <Net.Vpc.Upa.Field> sfields = e.GetRelationship().GetSourceRole().GetFields();
System.Collections.Generic.IList <Net.Vpc.Upa.Field> tfields = e.GetRelationship().GetTargetRole().GetFields();
for (int i = 0; i < (sfields).Count; i++)
{
Net.Vpc.Upa.Field fk = sfields[i];
Net.Vpc.Upa.Field fid = tfields[i];
evalue = ((Net.Vpc.Upa.Expressions.Expression)@value).Copy();
evalue = context.GetPersistenceUnit().GetExpressionManager().ParseExpression(evalue);
if (evalue is Net.Vpc.Upa.Expressions.Select)
{
Net.Vpc.Upa.Expressions.Select svalue = (Net.Vpc.Upa.Expressions.Select)evalue;
if (svalue.CountFields() != 1)
{
throw new System.Exception("Invalid Expression " + svalue + " as formula for field " + f.GetAbsoluteName());
}
if (svalue.GetField(0).GetExpression() is Net.Vpc.Upa.Expressions.Var)
{
svalue.GetField(0).SetExpression(new Net.Vpc.Upa.Expressions.Var((Net.Vpc.Upa.Expressions.Var)svalue.GetField(0).GetExpression(), fid.GetName()));
}
else
{
throw new System.Exception("Invalid Expression " + svalue + " as formula for field " + f.GetAbsoluteName());
}
}
else if (evalue is Net.Vpc.Upa.Expressions.Var)
{
evalue = (new Net.Vpc.Upa.Expressions.Var((Net.Vpc.Upa.Expressions.Var)evalue, fk.GetName()));
}
else if (evalue is Net.Vpc.Upa.Expressions.Param)
{
}
else if (evalue is Net.Vpc.Upa.Expressions.Literal)
{
}
else
{
throw new System.Exception("Invalid Expression " + evalue + " as formula for field " + f.GetAbsoluteName());
}
u.Set(fk.GetName(), evalue);
}
}
else
{
Net.Vpc.Upa.Key k = null;
if (@value is Net.Vpc.Upa.Record)
{
k = mbuilder.RecordToKey((Net.Vpc.Upa.Record)@value);
}
else
{
k = mbuilder.ObjectToKey(@value);
}
int x = 0;
foreach (Net.Vpc.Upa.Field fk in e.GetRelationship().GetSourceRole().GetFields())
{
u.Set(fk.GetName(), new Net.Vpc.Upa.Expressions.Param(fk.GetName(), k == null ? null : k.GetObjectAt(x)));
x++;
}
}
}
}
else
{
Net.Vpc.Upa.Expressions.Expression expression = (@value is Net.Vpc.Upa.Expressions.Expression) ? ((Net.Vpc.Upa.Expressions.Expression)((Net.Vpc.Upa.Expressions.Expression)@value)) : new Net.Vpc.Upa.Expressions.Param(null, @value);
u.Set(fieldName, expression);
}
}
}
u.Where(condition);
return(context.GetPersistenceStore().CreateQuery(u, context).ExecuteNonQuery());
}