public IList <CustomProcessTransition> Select(CustomProcessTransition data)
{
IList <CustomProcessTransition> datos = new List <CustomProcessTransition>();
datos = GetHsql(data).List <CustomProcessTransition>();
if (!Factory.IsTransactional)
{
Factory.Commit();
}
return(datos);
}
public void DeleteCustomProcessTransition(CustomProcessTransition data)
{
try
{
SetService(); SerClient.DeleteCustomProcessTransition(data);
}
finally
{
SerClient.Close();
if (SerClient.State == CommunicationState.Faulted)
SerClient.Abort();
}
}
public IList<CustomProcessTransition> GetCustomProcessTransition(CustomProcessTransition data)
{
try
{
SetService(); return SerClient.GetCustomProcessTransition(data);
}
finally
{
SerClient.Close();
if (SerClient.State == CommunicationState.Faulted)
SerClient.Abort();
}
}
public override IQuery GetHsql(Object data)
{
StringBuilder sql = new StringBuilder("select a from CustomProcessTransition a where ");
CustomProcessTransition transition = (CustomProcessTransition)data;
if (transition != null)
{
Parms = new List <Object[]>();
if (transition.RowID != 0)
{
sql.Append(" a.RowID = :id and ");
Parms.Add(new Object[] { "id", transition.RowID });
}
if (!String.IsNullOrEmpty(transition.Name))
{
sql.Append(" a.Name = :nom2 and ");
Parms.Add(new Object[] { "nom2", transition.Name });
}
if (transition.CurrentActivity != null && transition.CurrentActivity.ActivityID != 0)
{
sql.Append(" a.CurrentActivity.ActivityID = :idd3 and ");
Parms.Add(new Object[] { "idd3", transition.CurrentActivity.ActivityID });
}
if (transition.ResultContextKey != null && !string.IsNullOrEmpty(transition.ResultContextKey.ContextKey))
{
sql.Append(" a..ResultContextKey.ContextKey = :ick3 and ");
Parms.Add(new Object[] { "ick3", transition.ResultContextKey.ContextKey });
}
if (!String.IsNullOrEmpty(transition.ResultValue))
{
sql.Append(" a.ResultValue = :nom5 and ");
Parms.Add(new Object[] { "nom5", transition.ResultValue });
}
if (transition.NextActivity != null && transition.NextActivity.ActivityID != 0)
{
sql.Append(" a.NextActivity.ActivityID = :idd6 and ");
Parms.Add(new Object[] { "idd6", transition.NextActivity.ActivityID });
}
if (transition.Status != null && transition.Status.StatusID != 0)
{
sql.Append(" a.Status.StatusID = :idd7 and ");
Parms.Add(new Object[] { "idd7", transition.Status.StatusID });
}
if (transition.Process != null && transition.Process.ProcessID != 0)
{
sql.Append(" a.Process.ProcessID = :ip7 and ");
Parms.Add(new Object[] { "ip7", transition.Process.ProcessID });
if (transition.Process.ProcessType != null && transition.Process.ProcessType.DocTypeID != 0)
{
sql.Append(" a.Process.ProcessType.DocTypeID = :id7 and ");
Parms.Add(new Object[] { "id7", transition.Process.ProcessType.DocTypeID });
}
}
}
sql = new StringBuilder(sql.ToString());
sql.Append("1=1 order by a.Process.Name, a.Sequence ");
IQuery query = Factory.Session.CreateQuery(sql.ToString());
SetParameters(query);
return(query);
}
public CustomProcessTransition SelectById(CustomProcessTransition data)
{
return((CustomProcessTransition)base.SelectById(data));
}
public Boolean Delete(CustomProcessTransition data)
{
return(base.Delete(data));
}
public Boolean Update(CustomProcessTransition data)
{
return(base.Update(data));
}
public CustomProcessTransition Save(CustomProcessTransition data)
{
return((CustomProcessTransition)base.Save(data));
}
