public static OutputInvoiceLineList GetByExpedienteList(long oidExpediente, bool childs)
{
QueryConditions conditions = new QueryConditions {
Expediente = ExpedientInfo.New(oidExpediente)
};
return(GetList(conditions, childs));
}
public static WorkReportList GetByExpedientList(long oidExpedient, bool childs)
{
QueryConditions conditions = new QueryConditions {
Expedient = ExpedientInfo.New(oidExpedient)
};
return(GetList(SELECT(conditions), childs));
}
public static Charges GetListByExpediente(long oidExpedient, bool childs)
{
Library.Invoice.QueryConditions conditions = new Library.Invoice.QueryConditions
{
Expediente = ExpedientInfo.New(oidExpedient),
TipoCobro = ETipoCobro.REA
};
return(GetList(childs, SELECT(conditions)));
}
public static OutputDeliveryLineList GetListByExpediente(long oidExpedient, bool childs)
{
CriteriaEx criteria = OutputDeliveryLine.GetCriteria(OutputDeliveryLine.OpenSession());
criteria.Childs = childs;
QueryConditions conditions = new QueryConditions {
Expediente = ExpedientInfo.New(oidExpedient)
};
criteria.Query = OutputDeliveryLineList.SELECT(conditions);
OutputDeliveryLineList list = DataPortal.Fetch <OutputDeliveryLineList>(criteria);
CloseSession(criteria.SessionCode);
return(list);
}
public static ConceptoTicketList GetListByExpediente(long oid, bool childs)
{
CriteriaEx criteria = ConceptoTicket.GetCriteria(ConceptoTicket.OpenSession());
criteria.Childs = childs;
Library.Invoice.QueryConditions conditions = new Library.Invoice.QueryConditions {
Expediente = ExpedientInfo.New(oid)
};
criteria.Query = ConceptoTicketList.SELECT(conditions);
ConceptoTicketList list = DataPortal.Fetch <ConceptoTicketList>(criteria);
CloseSession(criteria.SessionCode);
return(list);
}
public static WorkReportResourceList GetList(long oidExpedient, ETipoEntidad entityType, bool clustered, bool childs = true)
{
QueryConditions conditions = new QueryConditions
{
Expedient = ExpedientInfo.New(oidExpedient),
EntityType = entityType
};
if (clustered)
{
conditions.Groups = new GroupList();
conditions.Groups.NewGroup("OidResource", typeof(WorkReportResource));
conditions.Groups.NewGroup("EntityType", typeof(WorkReportResource));
}
return(GetList(SELECT(conditions), childs));
}
public static WorkReportResourceList GetByCategoryList(long oidCategory, long oidExpedient, bool clustered, bool childs = true)
{
QueryConditions conditions = new QueryConditions
{
Expedient = (oidExpedient != 0) ? ExpedientInfo.New(oidExpedient) : null,
WorkReportCategory = (oidCategory != 0) ? WorkReportCategoryInfo.New(oidCategory) : null,
Orders = new OrderList()
};
conditions.Orders.NewOrder("CategoryMax", ListSortDirection.Ascending, typeof(WorkReportCategory));
if (clustered)
{
conditions.Groups = new GroupList();
conditions.Groups.NewGroup("OidCategory", typeof(WorkReportResource));
}
return(GetList(SELECT(conditions), childs));
}