public IList <Sku> ValidarInventarioParaOrdenDeVenta(SkuArgumento skuArgumento)
{
DbParameter[] parameters =
{
new OAParameter
{
ParameterName = "@XML",
Value = skuArgumento.SalesOrderDetailXml
},
new OAParameter
{
ParameterName = "@CODE_WAREHOUSE",
Value = skuArgumento.CODE_WAREHOUSE
},
new OAParameter
{
ParameterName = "@HANDLE_TONE_OR_CALIBER",
Value = skuArgumento.HandleToneOrCaliber
},
new OAParameter
{
ParameterName = "@IN_PICKING_LINE",
Value = skuArgumento.EnLineaDePicking ? (int)SiNo.Si : (int)SiNo.No
},
new OAParameter
{
ParameterName = "@PROJECT_ID",
Value = skuArgumento.Proyecto.ID
},
new OAParameter
{
ParameterName = "@MIN_DAYS_EXPIRATION_DATE",
Value = skuArgumento.MIN_DAYS_EXPIRATION_DATE
}
};
var result =
BaseDeDatosServicio.ExecuteQuery <Sku>(
BaseDeDatosServicio.Esquema + ".OP_WMS_SP_VALIDATE_STOCK_INVENTORY_BY_MATERIAL_FOR_DISPATCH",
CommandType.StoredProcedure, parameters).ToList();
if (result.Count > 0)
{
var componentes = result.Where(x => !string.IsNullOrEmpty(x.MASTER_PACK_ID)).ToList();
result = result.Where(x => string.IsNullOrEmpty(x.MASTER_PACK_ID)).ToList();
result.ForEach(y =>
{
y.ComponentesMasterPack = componentes.Where(x => x.MASTER_PACK_ID == y.MATERIAL_ID).ToList();
}
);
}
return(result);
}
public IList <MaterialConTonoYCalibre> ObtenerTonosYCalibresDeMateriales(SkuArgumento skuArgumento)
{
DbParameter[] parameters =
{
new OAParameter
{
ParameterName = "@MATERIAL_ID",
Value = skuArgumento.CODE_MATERIALS
}
,
new OAParameter
{
ParameterName = "@WAREHOUSE_ID",
Value = skuArgumento.CODE_WAREHOUSE
}
};
return(BaseDeDatosServicio.ExecuteQuery <MaterialConTonoYCalibre>(BaseDeDatosServicio.Esquema + ".OP_WMS_SP_GET_MATERIAL_WITH_TONE_AND_CALIBER_BY_MATERIALS", CommandType.StoredProcedure, parameters));
}
