public static string SELECT(Almacen item)
{
string query = SELECT(new QueryConditions {
Almacen = item.GetInfo()
});
query += " ORDER BY ST.\"OID_BATCH\", ST.\"FECHA\", ST.\"OID\"";
return(query);
}
public static string SELECT_FROM_LIST_BY_PARTIDA(Almacen item, string list)
{
QueryConditions conditions = new QueryConditions {
Almacen = item.GetInfo(false)
};
string query = Stock.SELECT(conditions, false) +
" AND ST.\"OID_ALMACEN\" IN (" + list + ")";
return(query);
}
public static Batchs GetChildListByAlbaranRecibido(Almacen parent, long oidDelivery, bool childs)
{
CriteriaEx criteria = Stock.GetCriteria(parent.SessionCode);
criteria.Childs = childs;
QueryConditions conditions = new QueryConditions
{
Almacen = parent.GetInfo(false),
InputDelivery = InputDeliveryInfo.New(oidDelivery)
};
criteria.Query = Batchs.SELECT(conditions);
return(DataPortal.Fetch <Batchs>(criteria));
}
public static Batchs GetChildListByExpediente(Almacen parent, long oidExpedient, bool childs)
{
CriteriaEx criteria = Stock.GetCriteria(parent.SessionCode);
criteria.Childs = childs;
QueryConditions conditions = new QueryConditions
{
Almacen = parent.GetInfo(false),
Expedient = ExpedientInfo.New(oidExpedient)
};
criteria.Query = Batchs.SELECT(conditions);
return(DataPortal.Fetch <Batchs>(criteria));
}
public static Stocks GetChildListByProducto(Almacen parent, long oidPartida, bool childs)
{
CriteriaEx criteria = Stock.GetCriteria(parent.SessionCode);
criteria.Childs = childs;
QueryConditions conditions = new QueryConditions
{
Almacen = parent.GetInfo(false),
Producto = Product.New().GetInfo(false)
};
conditions.Producto.Oid = oidPartida;
criteria.Query = Stocks.SELECT(conditions);
return(DataPortal.Fetch <Stocks>(criteria));
}
public static string SELECT(Almacen item)
{
return(SELECT(new QueryConditions {
Almacen = item.GetInfo()
}));
}