/// <summary>
/// Retrieve the complete list from db
/// </summary>
/// <returns>AuditoriaList</returns>
public static AuditoriaList GetList(bool get_childs)
{
CriteriaEx criteria = Auditoria.GetCriteria(Auditoria.OpenSession());
criteria.Childs = get_childs;
criteria.Query = AuditoriaList.SELECT();
AuditoriaList list = DataPortal.Fetch <AuditoriaList>(criteria);
CloseSession(criteria.SessionCode);
return(list);
}
/// <summary>
/// Retrieve the complete list from db
/// </summary>
/// <returns>AuditoriaList</returns>
public static long GetSiguienteTipoAuditoria(long oid_plan)
{
CriteriaEx criteria = Auditoria.GetCriteria(Auditoria.OpenSession());
criteria.Childs = false;
criteria.Query = Auditorias.SELECT_BY_PLAN(oid_plan);
SerialAuditoriaInfo orden = DataPortal.Fetch <SerialAuditoriaInfo>(criteria);
CloseSession(criteria.SessionCode);
return(orden.Value);
}
/// <summary>
/// Retrieve the complete list from db
/// </summary>
/// <returns>AuditoriaList</returns>
public static AuditoriaList GetAvisoDiscrepanciasAbiertasList(DateTime f_fin)
{
CriteriaEx criteria = Auditoria.GetCriteria(Auditoria.OpenSession());
criteria.Childs = false;
criteria.Query = AuditoriaList.SELECT_AVISO_DISCREPANCIAS_ABIERTAS(f_fin);
AuditoriaList list = DataPortal.Fetch <AuditoriaList>(criteria);
CloseSession(criteria.SessionCode);
return(list);
}
/// <summary>
/// Retrieve the complete list from db
/// </summary>
/// <returns>AuditoriaList</returns>
public static AuditoriaList GetAvisoInformesNoGenerados(DateTime f_fin)
{
CriteriaEx criteria = Auditoria.GetCriteria(Auditoria.OpenSession());
criteria.Childs = false;
criteria.Query = AuditoriaList.SELECT_AVISO_INFORMES_NO_GENERADOS(f_fin);
AuditoriaList list = DataPortal.Fetch <AuditoriaList>(criteria);
CloseSession(criteria.SessionCode);
return(list);
}
/// <summary>
/// Retrieve the complete list from db
/// </summary>
/// <returns>AuditoriaList</returns>
public static AuditoriaList GetAbiertasList(long oid_auditoria, long oid_plan,
long estado, DateTime fecha_ini, DateTime fecha_fin, DateTime fecha_comunicacion,
bool f_ini, bool f_fin, bool f_comunicacion)
{
CriteriaEx criteria = Auditoria.GetCriteria(Auditoria.OpenSession());
criteria.Childs = true;
criteria.Query = AuditoriaList.SELECT_ABIERTAS(oid_auditoria, oid_plan, estado, fecha_ini, fecha_fin, fecha_comunicacion, f_ini, f_fin, f_comunicacion);
AuditoriaList list = DataPortal.Fetch <AuditoriaList>(criteria);
CloseSession(criteria.SessionCode);
return(list);
}
