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(); }