private List <SwiftPickingSerie> ObtenerSwiftPickingSeries(SwiftPickingEncabezado picking)
{
if (picking.DocEntry == "" || picking.Classification == Enums.GetStringValue(ClasificacionPickingTipo.PickingPorVentaWMS))
{
return(new List <SwiftPickingSerie>());
}
DbParameter[] parameters =
{
new OAParameter
{
ParameterName = "@PICKING_HEADER",
Value = picking.DocEntry
}
};
var nombreSp = "";
if (picking.Classification == Enums.GetStringValue(ClasificacionPickingTipo.PickingPorVenta))
{
nombreSp = "SWIFT_SP_GET_ERP_SOS";
}
if (picking.Classification == Enums.GetStringValue(ClasificacionPickingTipo.PickingPorTraslado))
{
nombreSp = "SWIFT_SP_GET_ERP_ITRS";
}
var pickingSeries = BaseDeDatosServicio.ExecuteQuery <SwiftPickingSerie>(nombreSp,
CommandType.StoredProcedure, parameters);
return(pickingSeries.ToList());
}
private List <SwiftExpressPickingDetalle> ObtenerSwiftExpressPickingDetalle(SwiftPickingEncabezado picking, string owner, bool factura)
{
if (picking.DocNum == "")
{
return(new List <SwiftExpressPickingDetalle>());
}
DbParameter[] parameters =
{
new OAParameter
{
ParameterName = "@PICKING_DEMAND_HEADER_ID",
Value = picking.DocNum
}, new OAParameter
{
ParameterName = "@OWNER",
Value = owner
}
};
try
{
var pickingDetalle =
BaseDeDatosServicio.ExecuteQuery <SwiftExpressPickingDetalle>(BaseDeDatosServicio.Esquema + "OP_WMS_SP_GET_NEXT_PICKING_DEMAND_DETAIL",
CommandType.StoredProcedure, parameters);
return(pickingDetalle.ToList());
}
catch (Exception ex)
{
return(null);
}
}
private List <SwiftExpressPickingDetalle> SwiftExpressPickingDetalle(SwiftPickingEncabezado picking)
{
if (picking.DocEntry == "")
{
return(new List <SwiftExpressPickingDetalle>());
}
DbParameter[] parameters =
{
new OAParameter
{
ParameterName = "@PICKING_HEADER",
Value = picking.DocEntry
}
};
var nombreSp = "";
if (picking.Classification == Enums.GetStringValue(ClasificacionPickingTipo.PickingPorVenta))
{
nombreSp = "SWIFT_SP_GET_ERP_SOD";
}
if (picking.Classification == Enums.GetStringValue(ClasificacionPickingTipo.PickingPorTraslado))
{
nombreSp = "SWIFT_SP_GET_ERP_ITWD";
}
try
{
var pickingDetalle =
BaseDeDatosServicio.ExecuteQuery <SwiftExpressPickingDetalle>(nombreSp,
CommandType.StoredProcedure, parameters);
return(pickingDetalle.ToList());
}
catch (Exception ex)
{
return(null);
}
}
