public static TCreatureProperty DbSelect(this TCreatureProperty entity, DbSession session, params PDMDbProperty[] fields)
{
var query = IORMProvider.GetDbQueryBuilder(session);
SelectBuilder builder = new SelectBuilder();
if (fields.Count() == 0)
{
builder.ComponentSelect.Add(TCreaturePropertyProperties.CreatureId);
builder.ComponentSelect.Add(TCreaturePropertyProperties.HitPoint);
builder.ComponentSelect.Add(TCreaturePropertyProperties.MagicPoint);
builder.ComponentSelect.Add(TCreaturePropertyProperties.Strength);
builder.ComponentSelect.Add(TCreaturePropertyProperties.Stamina);
builder.ComponentSelect.Add(TCreaturePropertyProperties.Agility);
builder.ComponentSelect.Add(TCreaturePropertyProperties.Intelligence);
builder.ComponentSelect.Add(TCreaturePropertyProperties.Mentality);
}
else
{
builder.ComponentSelect.Add(TCreaturePropertyProperties.CreatureId);
foreach (var field in fields)
{
builder.ComponentSelect.Add(field);
}
}
builder.ComponentWhere.Add(new ComponentValueOfWhere(TCreaturePropertyProperties.CreatureId, entity.CreatureId, LocateType.Equal));
query.SelectBuilders.Add(builder);
return(IORMProvider.GetQueryOperator(session).Select <TCreatureProperty>(session, query));
}
public static void DbLoad(this TCreatureProperty entity, DbSession session, params PDMDbProperty[] fields)
{
var result = entity.DbSelect(session, fields);
if (fields.Contains(TCreaturePropertyProperties.HitPoint))
{
entity.HitPoint = result.HitPoint;
}
if (fields.Contains(TCreaturePropertyProperties.MagicPoint))
{
entity.MagicPoint = result.MagicPoint;
}
if (fields.Contains(TCreaturePropertyProperties.Strength))
{
entity.Strength = result.Strength;
}
if (fields.Contains(TCreaturePropertyProperties.Stamina))
{
entity.Stamina = result.Stamina;
}
if (fields.Contains(TCreaturePropertyProperties.Agility))
{
entity.Agility = result.Agility;
}
if (fields.Contains(TCreaturePropertyProperties.Intelligence))
{
entity.Intelligence = result.Intelligence;
}
if (fields.Contains(TCreaturePropertyProperties.Mentality))
{
entity.Mentality = result.Mentality;
}
}
public static bool DbDelete(this TCreatureProperty entity, DbSession session)
{
var query = IORMProvider.GetDbQueryBuilder(session);
query.DeleteBuilder.ComponentWhere.Add(new ComponentValueOfWhere(TCreaturePropertyProperties.CreatureId, entity.CreatureId, LocateType.Equal));
return(IORMProvider.GetQueryOperator(session).Delete <TCreatureProperty>(session, query));
}
public static bool DbUpdate(this TCreatureProperty entity, DbSession session, params PDMDbProperty[] fields)
{
var query = IORMProvider.GetDbQueryBuilder(session);
UpdateBuilder builder = new UpdateBuilder();
builder.ComponentWhere.Add(new ComponentValueOfWhere(TCreaturePropertyProperties.CreatureId, entity.CreatureId, LocateType.Equal));
if (fields == null || fields.Length == 0)
{
builder.ComponentSet.Add(new ComponentValueOfSet(TCreaturePropertyProperties.CreatureId, entity.CreatureId));
builder.ComponentSet.Add(new ComponentValueOfSet(TCreaturePropertyProperties.HitPoint, entity.HitPoint));
builder.ComponentSet.Add(new ComponentValueOfSet(TCreaturePropertyProperties.MagicPoint, entity.MagicPoint));
builder.ComponentSet.Add(new ComponentValueOfSet(TCreaturePropertyProperties.Strength, entity.Strength));
builder.ComponentSet.Add(new ComponentValueOfSet(TCreaturePropertyProperties.Stamina, entity.Stamina));
builder.ComponentSet.Add(new ComponentValueOfSet(TCreaturePropertyProperties.Agility, entity.Agility));
builder.ComponentSet.Add(new ComponentValueOfSet(TCreaturePropertyProperties.Intelligence, entity.Intelligence));
builder.ComponentSet.Add(new ComponentValueOfSet(TCreaturePropertyProperties.Mentality, entity.Mentality));
}
else
{
if (fields.Contains(TCreaturePropertyProperties.HitPoint))
{
builder.ComponentSet.Add(new ComponentValueOfSet(TCreaturePropertyProperties.HitPoint, entity.HitPoint));
}
if (fields.Contains(TCreaturePropertyProperties.MagicPoint))
{
builder.ComponentSet.Add(new ComponentValueOfSet(TCreaturePropertyProperties.MagicPoint, entity.MagicPoint));
}
if (fields.Contains(TCreaturePropertyProperties.Strength))
{
builder.ComponentSet.Add(new ComponentValueOfSet(TCreaturePropertyProperties.Strength, entity.Strength));
}
if (fields.Contains(TCreaturePropertyProperties.Stamina))
{
builder.ComponentSet.Add(new ComponentValueOfSet(TCreaturePropertyProperties.Stamina, entity.Stamina));
}
if (fields.Contains(TCreaturePropertyProperties.Agility))
{
builder.ComponentSet.Add(new ComponentValueOfSet(TCreaturePropertyProperties.Agility, entity.Agility));
}
if (fields.Contains(TCreaturePropertyProperties.Intelligence))
{
builder.ComponentSet.Add(new ComponentValueOfSet(TCreaturePropertyProperties.Intelligence, entity.Intelligence));
}
if (fields.Contains(TCreaturePropertyProperties.Mentality))
{
builder.ComponentSet.Add(new ComponentValueOfSet(TCreaturePropertyProperties.Mentality, entity.Mentality));
}
}
query.UpdateBuilders.Add(builder);
return(IORMProvider.GetQueryOperator(session).Update <TCreatureProperty>(session, query));
}
public static bool DbInsert(this TCreatureProperty entity, DbSession session)
{
var query = IORMProvider.GetDbQueryBuilder(session);
InsertBuilder builder = new InsertBuilder();
builder.ComponentInsert.Add(new ComponentValueOfInsert(TCreaturePropertyProperties.CreatureId, entity.CreatureId));
builder.ComponentInsert.Add(new ComponentValueOfInsert(TCreaturePropertyProperties.HitPoint, entity.HitPoint));
builder.ComponentInsert.Add(new ComponentValueOfInsert(TCreaturePropertyProperties.MagicPoint, entity.MagicPoint));
builder.ComponentInsert.Add(new ComponentValueOfInsert(TCreaturePropertyProperties.Strength, entity.Strength));
builder.ComponentInsert.Add(new ComponentValueOfInsert(TCreaturePropertyProperties.Stamina, entity.Stamina));
builder.ComponentInsert.Add(new ComponentValueOfInsert(TCreaturePropertyProperties.Agility, entity.Agility));
builder.ComponentInsert.Add(new ComponentValueOfInsert(TCreaturePropertyProperties.Intelligence, entity.Intelligence));
builder.ComponentInsert.Add(new ComponentValueOfInsert(TCreaturePropertyProperties.Mentality, entity.Mentality));
query.InsertBuilders.Add(builder);
return(IORMProvider.GetQueryOperator(session).Insert <TCreatureProperty>(session, query));
}
