public void AsociaPL(string sku, string nid_opl_in)
{
_con.InsertSQL = " DECLARE @nid_sku VARCHAR(75) SET @nid_sku = '" + sku + "' " +
"DECLARE @nid_opl_in VARCHAR(20) SET @nid_opl_in = '" + nid_opl_in + "' " +
"DECLARE @nid_opl INT " +
/*el bulto insertado y asociado lo asocia a un PL, si no existe lo crea*/
"SET @nid_opl = (SELECT nid_opl FROM origin_packing_list WHERE nid_opl_in = @nid_opl_in) " +
"IF(@nid_opl IS NULL) " +
"BEGIN " +
"INSERT INTO dbo.origin_packing_list (nid_opl_in) " +
"VALUES (@nid_opl_in) " +
"SET @nid_opl = (SELECT SCOPE_IDENTITY()) " +
"END " +
"INSERT INTO dbo.packing_list_breakdown (nid_opl,nid_sku) " +
"VALUES (@nid_opl,@nid_sku) ";
_con.insert();
}
void ActualizarSKUEscaneados(int id)
{
_con.InsertSQL = "update sku_escanear set escaneado = 1 where id = " + id;
_con.insert();
}