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)); }