public IList <MeasureUnitConvertion> Select(MeasureUnitConvertion data)
{
IList <MeasureUnitConvertion> datos = new List <MeasureUnitConvertion>();
datos = GetHsql(data).List <MeasureUnitConvertion>();
if (!Factory.IsTransactional)
{
Factory.Commit();
}
return(datos);
}
public override IQuery GetHsql(Object data)
{
StringBuilder sql = new StringBuilder("select a from MeasureUnitConvertion a where ");
MeasureUnitConvertion measureunitconvertion = (MeasureUnitConvertion)data;
if (measureunitconvertion != null)
{
Parms = new List <Object[]>();
if (measureunitconvertion.RowID != 0)
{
sql.Append(" a.RowID = :id and ");
Parms.Add(new Object[] { "id", measureunitconvertion.RowID });
}
if (measureunitconvertion.DestinationUnit.MeasureUnitID != 0)
{
sql.Append(" a.DestinationUnit.MeasureUnitID = :id1 and ");
Parms.Add(new Object[] { "id1", measureunitconvertion.DestinationUnit.MeasureUnitID });
}
if (measureunitconvertion.SourceUnit.MeasureUnitID != 0)
{
sql.Append(" a.SourceUnit.MeasureUnitID = :id2 and ");
Parms.Add(new Object[] { "id2", measureunitconvertion.SourceUnit.MeasureUnitID });
}
if (!String.IsNullOrEmpty(measureunitconvertion.Description))
{
sql.Append(" a.Description = :nom and ");
Parms.Add(new Object[] { "nom", measureunitconvertion.Description });
}
}
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 void DeleteMeasureUnitConvertion(MeasureUnitConvertion data)
{
try {
SetService(); SerClient.DeleteMeasureUnitConvertion(data); }
finally
{
SerClient.Close();
if (SerClient.State == CommunicationState.Faulted)
SerClient.Abort();
}
}
public MeasureUnitConvertion SaveMeasureUnitConvertion(MeasureUnitConvertion data)
{
try {
SetService(); return SerClient.SaveMeasureUnitConvertion(data); }
finally
{
SerClient.Close();
if (SerClient.State == CommunicationState.Faulted)
SerClient.Abort();
}
}
public MeasureUnitConvertion SelectById(MeasureUnitConvertion data)
{
return((MeasureUnitConvertion)base.SelectById(data));
}
public Boolean Delete(MeasureUnitConvertion data)
{
return(base.Delete(data));
}
public Boolean Update(MeasureUnitConvertion data)
{
return(base.Update(data));
}
public MeasureUnitConvertion Save(MeasureUnitConvertion data)
{
return((MeasureUnitConvertion)base.Save(data));
}
