public override IQuery GetHsql(Object data)
{
StringBuilder sql = new StringBuilder("select a from IqTable a where ");
IqTable iqtable = (IqTable)data;
if (iqtable != null)
{
Parms = new List <Object[]>();
if (iqtable.TableId != 0)
{
sql.Append(" a.TableId = :id and ");
Parms.Add(new Object[] { "id", iqtable.TableId });
}
if (!String.IsNullOrEmpty(iqtable.Name))
{
sql.Append(" a.Name = :nom2 and ");
Parms.Add(new Object[] { "nom2", iqtable.Name });
}
}
sql = new StringBuilder(sql.ToString());
sql.Append("1=1 order by a.TableId asc ");
IQuery query = Factory.Session.CreateQuery(sql.ToString());
SetParameters(query);
return(query);
}
public IList <IqTable> Select(IqTable data)
{
IList <IqTable> datos = new List <IqTable>();
datos = GetHsql(data).List <IqTable>();
if (!Factory.IsTransactional)
{
Factory.Commit();
}
return(datos);
}
public void DeleteIqTable(IqTable data)
{
try
{
SetService(); SerClient.DeleteIqTable(data);
}
finally
{
SerClient.Close();
if (SerClient.State == CommunicationState.Faulted)
SerClient.Abort();
}
}
public IqTable SaveIqTable(IqTable data)
{
try
{
SetService(); return SerClient.SaveIqTable(data);
}
finally
{
SerClient.Close();
if (SerClient.State == CommunicationState.Faulted)
SerClient.Abort();
}
}
public IqTable SelectById(IqTable data)
{
return((IqTable)base.SelectById(data));
}
public Boolean Delete(IqTable data)
{
return(base.Delete(data));
}
public Boolean Update(IqTable data)
{
return(base.Update(data));
}
public IqTable Save(IqTable data)
{
return((IqTable)base.Save(data));
}
