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 ClientProductList GetByClientList(long oidClient, bool childs = true)
{
QueryConditions conditions = new QueryConditions {
Cliente = ClienteInfo.New(oidClient)
};
return(GetList(conditions, childs));
}
public static ChargeList GetByClientList(long oidClient, bool childs)
{
QueryConditions conditions = new QueryConditions()
{
Cliente = ClienteInfo.New(oidClient)
};
return(GetListClientes(conditions, childs));
}
public static OutputDeliveryList GetByClientList(long oidClient, CriteriaEx criteria = null, bool childs = false)
{
QueryConditions conditions = new QueryConditions
{
TipoEntidad = ETipoEntidad.Cliente,
Cliente = ClienteInfo.New(oidClient),
PagingInfo = (criteria != null) ? criteria.PagingInfo : null,
Filters = (criteria != null) ? criteria.Filters : null
};
return(GetList(false, SELECT(conditions)));
}
public static OutputDeliveryList GetListByCliente(bool childs, long oidClient, ETipoAlbaranes tipo, DateTime from, DateTime till)
{
QueryConditions conditions = new QueryConditions
{
TipoEntidad = ETipoEntidad.Cliente,
Cliente = ClienteInfo.New(oidClient),
TipoAlbaranes = tipo,
FechaIni = from,
FechaFin = till
};
return(GetList(false, SELECT(conditions)));
}
public static ChargeList GetByClientList(long oidClient, CriteriaEx criteria, bool childs)
{
QueryConditions conditions = new QueryConditions()
{
PagingInfo = (criteria != null) ? criteria.PagingInfo : null,
Filters = (criteria != null) ? criteria.Filters : null,
Orders = (criteria != null) ? criteria.Orders : null,
Cliente = ClienteInfo.New(oidClient),
TipoCobro = ETipoCobro.Cliente
};
string query = Charge.SELECT(conditions, false);
if (criteria != null)
{
criteria.PagingInfo = conditions.PagingInfo;
}
return(GetList(SELECT(conditions), childs));
}
public static OutputInvoiceList GetList(long oidClient, DateTime from, DateTime till, EStepGraph step, CriteriaEx criteria, bool childs)
{
QueryConditions conditions = new QueryConditions()
{
PagingInfo = (criteria != null) ? criteria.PagingInfo : null,
Filters = (criteria != null) ? criteria.Filters : null,
Orders = (criteria != null) ? criteria.Orders : null,
Cliente = ClienteInfo.New(oidClient),
FechaIni = from,
FechaFin = till,
Step = step,
};
string query = OutputInvoice.SELECT(conditions, false);
if (criteria != null)
{
criteria.PagingInfo = conditions.PagingInfo;
}
return(GetList(query, criteria, childs));
}
