public static OutputDeliveryList GetList(bool childs,
long oidHolder,
ETipoEntidad holderType,
long oidSerie,
ETipoAlbaranes deliveryType,
ETipoFactura invoiceType,
DateTime from,
DateTime till)
{
QueryConditions conditions = new QueryConditions
{
Serie = (oidSerie != 0) ? SerieInfo.New(oidSerie) : null,
TipoEntidad = holderType,
TipoAlbaranes = deliveryType,
TipoFactura = invoiceType,
FechaIni = from,
FechaFin = till,
};
switch (holderType)
{
case ETipoEntidad.Cliente:
conditions.Cliente = (oidHolder != 0) ? ClienteInfo.New(oidHolder) : null;
break;
case ETipoEntidad.WorkReport:
conditions.WorkReport = (oidHolder != 0) ? WorkReportInfo.New(oidHolder) : null;
break;
}
return(GetList(childs, SELECT(conditions)));
}
public static InputInvoiceList GetList(ETipoAcreedor providerType,
long oidProvider,
long oidSerie,
ETipoFacturas invoicesType,
ETipoFactura invoiceType,
DateTime from,
DateTime till,
bool childs)
{
QueryConditions conditions = new QueryConditions
{
Acreedor = (oidProvider != 0) ? ProviderBaseInfo.New(oidProvider, providerType) : null,
TipoAcreedor = new ETipoAcreedor[1] {
providerType
},
Serie = (oidSerie != 0) ? Serie.Serie.New().GetInfo() : null,
TipoFacturas = invoicesType,
TipoFactura = invoiceType,
FechaIni = from,
FechaFin = till,
};
if (oidSerie != 0)
{
conditions.Serie.Oid = oidSerie;
}
return(GetList(InputInvoiceSQL.SELECT(conditions), childs));
}
public static InputDeliveryList GetList(bool childs,
ETipoAcreedor providerType,
long oidProvider,
long oidSerie,
ETipoAlbaranes deliveryType,
ETipoFactura invoiceType,
DateTime from,
DateTime till)
{
QueryConditions conditions = new QueryConditions
{
Acreedor = (oidProvider != 0) ? ProviderBaseInfo.New(oidProvider, providerType) : null,
TipoAcreedor = new ETipoAcreedor[1] {
providerType
},
Serie = (oidSerie != 0) ? Serie.SerieInfo.New(oidSerie) : null,
TipoAlbaranes = deliveryType,
TipoFactura = invoiceType,
FechaIni = from,
FechaFin = till,
};
if (oidSerie != 0)
{
conditions.Serie.Oid = oidSerie;
}
return(GetList(childs, SELECT(conditions)));
}
public static TicketList GetBySerieAndYearList(long oid_serie, int year, ETipoFactura tipo)
{
CriteriaEx criteria = Ticket.GetCriteria(Ticket.OpenSession());
criteria.Childs = false;
QueryConditions conditions = new QueryConditions
{
Serie = Serie.New().GetInfo(false),
TipoFactura = tipo,
FechaIni = DateAndTime.FirstDay(year),
FechaFin = DateAndTime.LastDay(year),
};
conditions.Serie.Oid = oid_serie;
return(GetList(TicketList.SELECT(conditions), false));
}
public static OutputDeliveryList GetNoFacturados(bool childs, long oidClient, long oidSerie, ETipoFactura tipo_albaran)
{
return(GetList(childs, oidClient, ETipoEntidad.Cliente, oidSerie, ETipoAlbaranes.NoFacturados, tipo_albaran, DateTime.MinValue, DateTime.MaxValue));
}
public static OutputDeliveryList GetListBySerie(bool childs, long oidSerie, int year, ETipoAlbaranes tipo, ETipoFactura invoiceType)
{
QueryConditions conditions = new QueryConditions
{
Serie = SerieInfo.New(oidSerie),
TipoAlbaranes = tipo,
TipoFactura = invoiceType,
FechaIni = DateAndTime.FirstDay(year),
FechaFin = DateAndTime.LastDay(year)
};
return(GetList(childs, SELECT(conditions)));
}
public static OutputDeliveryList GetList(bool childs, long oidHolder, ETipoEntidad holderType, long oidSerie, ETipoAlbaranes deliveryType, ETipoFactura invoiceType, int year)
{
return(GetList(childs, oidHolder, holderType, oidSerie, deliveryType, invoiceType, DateAndTime.FirstDay(year), DateAndTime.LastDay(year)));
}
public static OutputDeliveryList GetList(bool childs, long oidHolder, ETipoEntidad holderType, long oidSerie, ETipoFactura invoiceType)
{
return(GetList(childs, oidHolder, holderType, oidSerie, ETipoAlbaranes.Todos, invoiceType, DateTime.MinValue, DateTime.MaxValue));
}
public static OutputDeliveryList GetList(bool childs, long oidSerie, ETipoFactura invoiceType)
{
return(GetList(childs, 0, ETipoEntidad.Todos, oidSerie, invoiceType));
}
public static InputDeliveryList GetNoFacturados(bool childs, ETipoAcreedor tipo, long oid_acreedor, long oid_serie, ETipoFactura tipo_albaran)
{
return(GetList(childs, tipo, oid_acreedor, oid_serie, ETipoAlbaranes.NoFacturados, tipo_albaran, DateTime.MinValue, DateTime.MaxValue));
}
public static InputDeliveryList GetList(bool childs, ETipoAcreedor tipo, long oid_acreedor, long oid_serie, ETipoAlbaranes tipo_albaranes, ETipoFactura tipo_albaran, int year)
{
return(GetList(childs, tipo, oid_acreedor, oid_serie, tipo_albaranes, tipo_albaran, DateAndTime.FirstDay(year), DateAndTime.LastDay(year)));
}
public static InputDeliveryList GetList(bool childs, ETipoAcreedor tipo, long oid_serie, ETipoFactura tipo_albaran)
{
return(GetList(childs, tipo, 0, oid_serie, tipo_albaran));
}
