public static void AppendQuerySql([NotNull] SqlSerializationContext context, [CanBeNull] IDBPredicate cond)
{
context.Write(SelectSql);
cond = cond != null ? new AndCondtion(AliveRecordsFilter, cond) : AliveRecordsFilter;
context.Write(" WHERE ");
cond.Write(context);
}
public static void AppendSelectRangeSql([NotNull] SqlSerializationContext context, int from, int to, IDBPredicate st)
{
context.Write(__SelectRangeSqlTemplate_1, context.AddParameter(from), context.AddParameter(to));
if (st != null)
{
st.Write(context);
}
context.Write(Environment.NewLine);
context.Write(__SelectRangeSqlTemplate_2);
}
public void Write(SqlSerializationContext context)
{
context.Write("SELECT ");
context.Write(FieldNames.Select(f => SqlUtils.WrapDbId(f)).ConcatComma());
context.Write(" FROM ");
context.Write(SqlUtils.WrapDbId(DataObjectInfo <TDataObject> .TableName));
if (Condition != null)
{
context.Write(" WHERE ");
Condition.Write(context);
}
}
public static void AppendLookupSql([NotNull] SqlSerializationContext context, [NotNull] IIntKeyedDataObject owner, [NotNull] Type detailType, [CanBeNull] IDBPredicate condition)
{
var r = Get(__Infos, owner.GetType(), detailType);
if (r.IsEmpty)
{
throw new DMError("Couldnt found relation between {0} and {1}", owner.GetType(), detailType);
}
if (owner.ID <= 0)
{
throw new DMError("{0} has invalid ID = {1}", owner.GetType().Name, owner.ID);
}
context.Write("SELECT ID FROM [{0}] where ([{1}] = {2}) and sysState = 0", r.TableName, r.RefColumnName, context.AddParameter(owner.ID));
if (condition != null)
{
context.Write(" AND (");
condition.Write(context);
context.Write(")");
}
}
