public static InputDeliveryLineList GetByExpedienteStockList(long oid, bool childs, InputDeliveryInfo albaran)
{
QueryConditions conditions = new QueryConditions
{
Expedient = ExpedientInfo.New(oid),
TipoAcreedor = new ETipoAcreedor[1] {
ETipoAcreedor.Proveedor
}
};
InputDeliveryLineList list = GetList(InputDeliveryLineSQL.SELECT_STOCK(conditions, false), childs);
List <InputDeliveryLineInfo> merge = new List <InputDeliveryLineInfo>();
foreach (InputDeliveryLineInfo ca in albaran.ConceptoAlbaranes)
{
if (ca.OidExpediente == oid)
{
merge.Add(ca);
}
}
foreach (InputDeliveryLineInfo ca in list)
{
if (ca.OidAlbaran != albaran.Oid)
{
merge.Add(ca);
}
}
return(InputDeliveryLineList.GetChildList(merge));
}
public static InputDeliveryLineList GetByAlbaranList(long oid, bool childs)
{
QueryConditions conditions = new QueryConditions
{
InputDelivery = InputDeliveryInfo.New(oid)
};
return(GetList(InputDeliveryLineSQL.SELECT(conditions, false), childs));
}
public static string SELECT(InputDelivery delivery)
{
string query;
QueryConditions conditions = new QueryConditions {
InputDelivery = delivery.GetInfo(false)
};
query = InputDeliveryLineSQL.SELECT(conditions, true);
return(query);
}
public static InputDeliveryLineList GetByExpedienteList(long oid, bool childs)
{
QueryConditions conditions = new QueryConditions
{
Expedient = ExpedientInfo.New(oid),
TipoAcreedor = new ETipoAcreedor[1] {
ETipoAcreedor.Proveedor
}
};
return(GetList(InputDeliveryLineSQL.SELECT(conditions, false), childs));
}
public static string SELECT_BY_EXPEDIENTE_STOCK(QueryConditions conditions)
{
return(InputDeliveryLineSQL.SELECT_STOCK(conditions, false));
}
public static string SELECT(QueryConditions conditions)
{
return(InputDeliveryLineSQL.SELECT(conditions, false));
}