public IList <CustomProcessContext> Select(CustomProcessContext data)
{
IList <CustomProcessContext> datos = new List <CustomProcessContext>();
datos = GetHsql(data).List <CustomProcessContext>();
if (!Factory.IsTransactional)
{
Factory.Commit();
}
try { datos = datos.Where(f => f.GetType() == typeof(CustomProcessContext)).ToList(); }
catch { }
return(datos);
}
public IList<CustomProcessContext> Select(CustomProcessContext data)
{
IList<CustomProcessContext> datos = new List<CustomProcessContext>();
datos = GetHsql(data).List<CustomProcessContext>();
if (!Factory.IsTransactional)
Factory.Commit();
try { datos = datos.Where(f => f.GetType() == typeof(CustomProcessContext)).ToList(); }
catch { }
return datos;
}
public override IQuery GetHsql(Object data)
{
StringBuilder sql = new StringBuilder("select a from CustomProcessContext a where ");
CustomProcessContext custEr = (CustomProcessContext)data;
if (custEr != null)
{
Parms = new List <Object[]>();
if (custEr.RowID != 0)
{
sql.Append(" a.RowID = :id and ");
Parms.Add(new Object[] { "id", custEr.RowID });
}
if (!string.IsNullOrEmpty(custEr.ContextKey))
{
sql.Append(" a.ContextKey like :ir2 and ");
Parms.Add(new Object[] { "ir2", "%" + custEr.ContextKey + "%" });
}
if (custEr.Status != null && custEr.Status.StatusID != 0)
{
sql.Append(" a.Status.StatusID = :id2 and ");
Parms.Add(new Object[] { "id2", custEr.Status.StatusID });
}
if (custEr.ProcessType != null && custEr.ProcessType.DocTypeID != 0)
{
sql.Append(" a.ProcessType.DocTypeID = :ix2 and ");
Parms.Add(new Object[] { "ix2", custEr.ProcessType.DocTypeID });
}
}
sql = new StringBuilder(sql.ToString());
sql.Append(" 1=1 ");
IQuery query = Factory.Session.CreateQuery(sql.ToString());
SetParameters(query);
return(query);
}
public CustomProcessContext SaveCustomProcessContext(CustomProcessContext data) { return Factory.DaoCustomProcessContext().Save(data); }
public IList<CustomProcessContext> GetCustomProcessContext(CustomProcessContext data) { return Factory.DaoCustomProcessContext().Select(data); }
public CustomProcessContext SelectById(CustomProcessContext data)
{
return((CustomProcessContext)base.SelectById(data));
}
public Boolean Delete(CustomProcessContext data)
{
return(base.Delete(data));
}
public Boolean Update(CustomProcessContext data)
{
return base.Update(data);
}
public CustomProcessContext Save(CustomProcessContext data)
{
return((CustomProcessContext)base.Save(data));
}
public void DeleteCustomProcessContext(CustomProcessContext data)
{
try
{
SetService(); SerClient.DeleteCustomProcessContext(data);
}
finally
{
SerClient.Close();
if (SerClient.State == CommunicationState.Faulted)
SerClient.Abort();
}
}
public CustomProcessContext SaveCustomProcessContext(CustomProcessContext data)
{
try
{
SetService(); return SerClient.SaveCustomProcessContext(data);
}
finally
{
SerClient.Close();
if (SerClient.State == CommunicationState.Faulted)
SerClient.Abort();
}
}
public CustomProcessContext SelectById(CustomProcessContext data)
{
return (CustomProcessContext)base.SelectById(data);
}
public Boolean Delete(CustomProcessContext data)
{
return base.Delete(data);
}
public void DeleteCustomProcessContext(CustomProcessContext data) { Factory.DaoCustomProcessContext().Delete(data); }
public Boolean Update(CustomProcessContext data)
{
return(base.Update(data));
}
public void UpdateCustomProcessContext(CustomProcessContext data) { Factory.DaoCustomProcessContext().Update(data); }
public CustomProcessContext Save(CustomProcessContext data)
{
return (CustomProcessContext)base.Save(data);
}
