public override IQuery GetHsql(object data)
{
StringBuilder sql = new StringBuilder("select a from MenuOptionExtension a where ");
MenuOptionExtension MenuOptionExtension = (MenuOptionExtension)data;
if (MenuOptionExtension != null)
{
Parms = new List <Object[]>();
if (MenuOptionExtension.RowID != 0)
{
sql.Append(" a.RowID = :id and ");
Parms.Add(new Object[] { "id", MenuOptionExtension.RowID });
}
if (MenuOptionExtension.MenuOption != null && MenuOptionExtension.MenuOption.MenuOptionID != 0)
{
sql.Append(" a.MenuOption.MenuOptionID = :id1 and ");
Parms.Add(new Object[] { "id1", MenuOptionExtension.MenuOption.MenuOptionID });
}
}
sql = new StringBuilder(sql.ToString());
sql.Append("1=1 order by a.RowID asc ");
IQuery query = Factory.Session.CreateQuery(sql.ToString());
SetParameters(query);
return(query);
}
public IList <MenuOptionExtension> Select(MenuOptionExtension data)
{
IList <MenuOptionExtension> datos = new List <MenuOptionExtension>();
datos = GetHsql(data).List <MenuOptionExtension>();
if (!Factory.IsTransactional)
{
Factory.Commit();
}
return(datos);
}
public void DeleteMenuOptionExtension(MenuOptionExtension data)
{
try
{
SetService(); SerClient.DeleteMenuOptionExtension(data);
}
finally
{
SerClient.Close();
if (SerClient.State == CommunicationState.Faulted)
SerClient.Abort();
}
}
public MenuOptionExtension SaveMenuOptionExtension(MenuOptionExtension data)
{
try
{
SetService(); return SerClient.SaveMenuOptionExtension(data);
}
finally
{
SerClient.Close();
if (SerClient.State == CommunicationState.Faulted)
SerClient.Abort();
}
}
public MenuOptionExtension SelectById(MenuOptionExtension data)
{
return((MenuOptionExtension)base.SelectById(data));
}
public Boolean Delete(MenuOptionExtension data)
{
return(base.Delete(data));
}
public Boolean Update(MenuOptionExtension data)
{
return(base.Update(data));
}
public MenuOptionExtension Save(MenuOptionExtension data)
{
return((MenuOptionExtension)base.Save(data));
}
