INSERT INTO EMPRESAS..Update_Bin ( Transaccion, Major, Version_Instalador, Version, FileName, FilePath, FileSize, Memo, Tipo, Opcional, Ejecutar, Sobreescribir, Fecha_Ult_Modif, Up_Binary )VALUES( 'MproSys', 6, '6.000.048', '6.0.0.80', 'MproSys.exe', '', '1008KB', 'Mejoras de optimización.', 2, 'NO', 'SI', 'NO', GETDATE(), null ) *** BEGIN TRANSACION *** *** COMMIT *** UPDATE EMPRESAS..Ws_Bin SET Actualizado = 'NO' WHERE (FileName = 'Membrete.zip' AND 5 > 2) OR ( FileName = 'Membrete.zip' AND Version < '6.000.051' ) OR ( FileName = 'Membrete.zip' AND Version <> '6.000.051' AND 'NO' = 'SI') SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE Transaccion = 'Membrete' AND Major = 6 AND Version_Instalador = '6.000.048' INSERT INTO EMPRESAS..Update_Bin ( Transaccion, Major, Version_Instalador, Version, FileName, FilePath, FileSize, Memo, Tipo, Opcional, Ejecutar, Sobreescribir, Fecha_Ult_Modif, Up_Binary )VALUES( 'Membrete', 6, '6.000.048', '6.000.051', 'Membrete.zip', '%APP.PATH%\Management Pro\Membrete', '49KB', 'Membrete CFDI17', 5, 'NO', 'SI', 'NO', GETDATE(), null ) *** BEGIN TRANSACION *** *** COMMIT *** UPDATE EMPRESAS..Ws_Bin SET Actualizado = 'NO' WHERE (FileName = 'lotePRO.dll' AND 0 > 2) OR ( FileName = 'lotePRO.dll' AND Version < '6.0.0.49' ) OR ( FileName = 'lotePRO.dll' AND Version <> '6.0.0.49' AND 'NO' = 'SI') SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE Transaccion = 'lotePRO' AND Major = 6 AND Version_Instalador = '6.000.048' INSERT INTO EMPRESAS..Update_Bin ( Transaccion, Major, Version_Instalador, Version, FileName, FilePath, FileSize, Memo, Tipo, Opcional, Ejecutar, Sobreescribir, Fecha_Ult_Modif, Up_Binary )VALUES( 'lotePRO', 6, '6.000.048', '6.0.0.49', 'lotePRO.dll', '', '312 KB', 'Cambios menores de interación', 0, 'NO', 'SI', 'NO', GETDATE(), null ) *** BEGIN TRANSACION *** *** COMMIT *** UPDATE EMPRESAS..Ws_Bin SET Actualizado = 'NO' WHERE (FileName = 'LO007.dll' AND 1 > 2) OR ( FileName = 'LO007.dll' AND Version < '6.0.0.49' ) OR ( FileName = 'LO007.dll' AND Version <> '6.0.0.49' AND 'NO' = 'SI') SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE Transaccion = 'LO007' AND Major = 6 AND Version_Instalador = '6.000.048' INSERT INTO EMPRESAS..Update_Bin ( Transaccion, Major, Version_Instalador, Version, FileName, FilePath, FileSize, Memo, Tipo, Opcional, Ejecutar, Sobreescribir, Fecha_Ult_Modif, Up_Binary )VALUES( 'LO007', 6, '6.000.048', '6.0.0.49', 'LO007.dll', '', '104KB', 'Funcionalidad para usar campos adicionales', 1, 'NO', 'SI', 'NO', GETDATE(), null ) *** BEGIN TRANSACION *** *** COMMIT *** UPDATE EMPRESAS..Ws_Bin SET Actualizado = 'NO' WHERE (FileName = 'labelStylePRO.ocx' AND 0 > 2) OR ( FileName = 'labelStylePRO.ocx' AND Version < '6.0.0.49' ) OR ( FileName = 'labelStylePRO.ocx' AND Version <> '6.0.0.49' AND 'NO' = 'SI') SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE Transaccion = 'labelStylePRO' AND Major = 6 AND Version_Instalador = '6.000.048' INSERT INTO EMPRESAS..Update_Bin ( Transaccion, Major, Version_Instalador, Version, FileName, FilePath, FileSize, Memo, Tipo, Opcional, Ejecutar, Sobreescribir, Fecha_Ult_Modif, Up_Binary )VALUES( 'labelStylePRO', 6, '6.000.048', '6.0.0.49', 'labelStylePRO.ocx', '', '52KB', 'Nuevo Control de SDK', 0, 'NO', 'SI', 'NO', GETDATE(), null ) *** BEGIN TRANSACION *** *** COMMIT *** UPDATE EMPRESAS..Ws_Bin SET Actualizado = 'NO' WHERE (FileName = 'impresionPRO.dll' AND 0 > 2) OR ( FileName = 'impresionPRO.dll' AND Version < '6.0.0.53' ) OR ( FileName = 'impresionPRO.dll' AND Version <> '6.0.0.53' AND 'NO' = 'SI') SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE Transaccion = 'impresionPRO' AND Major = 6 AND Version_Instalador = '6.000.048' INSERT INTO EMPRESAS..Update_Bin ( Transaccion, Major, Version_Instalador, Version, FileName, FilePath, FileSize, Memo, Tipo, Opcional, Ejecutar, Sobreescribir, Fecha_Ult_Modif, Up_Binary )VALUES( 'impresionPRO', 6, '6.000.048', '6.0.0.53', 'impresionPRO.dll', '', '696KB', 'Permitir enviar formato gráfico en modo horizontal', 0, 'NO', 'SI', 'NO', GETDATE(), null ) *** BEGIN TRANSACION *** *** COMMIT *** UPDATE EMPRESAS..Ws_Bin SET Actualizado = 'NO' WHERE (FileName = 'IM003.dll' AND 1 > 2) OR ( FileName = 'IM003.dll' AND Version < '6.0.0.49' ) OR ( FileName = 'IM003.dll' AND Version <> '6.0.0.49' AND 'NO' = 'SI') SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE Transaccion = 'IM003' AND Major = 6 AND Version_Instalador = '6.000.048' INSERT INTO EMPRESAS..Update_Bin ( Transaccion, Major, Version_Instalador, Version, FileName, FilePath, FileSize, Memo, Tipo, Opcional, Ejecutar, Sobreescribir, Fecha_Ult_Modif, Up_Binary )VALUES( 'IM003', 6, '6.000.048', '6.0.0.49', 'IM003.dll', '', '220 KB', 'Cambios para obtener la serie al tener una sucursal asignada al operador.', 1, 'NO', 'SI', 'NO', GETDATE(), null ) *** BEGIN TRANSACION *** *** COMMIT *** UPDATE EMPRESAS..Ws_Bin SET Actualizado = 'NO' WHERE (FileName = 'HT003.dll' AND 1 > 2) OR ( FileName = 'HT003.dll' AND Version < '6.0.0.49' ) OR ( FileName = 'HT003.dll' AND Version <> '6.0.0.49' AND 'NO' = 'SI') SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE Transaccion = 'HT003' AND Major = 6 AND Version_Instalador = '6.000.048' INSERT INTO EMPRESAS..Update_Bin ( Transaccion, Major, Version_Instalador, Version, FileName, FilePath, FileSize, Memo, Tipo, Opcional, Ejecutar, Sobreescribir, Fecha_Ult_Modif, Up_Binary )VALUES( 'HT003', 6, '6.000.048', '6.0.0.49', 'HT003.dll', '', '328KB', 'Cambios menores de interación', 1, 'NO', 'SI', 'NO', GETDATE(), null ) *** BEGIN TRANSACION *** *** COMMIT *** UPDATE EMPRESAS..Ws_Bin SET Actualizado = 'NO' WHERE (FileName = 'funcionesPRO.dll' AND 0 > 2) OR ( FileName = 'funcionesPRO.dll' AND Version < '6.0.0.59' ) OR ( FileName = 'funcionesPRO.dll' AND Version <> '6.0.0.59' AND 'NO' = 'SI') SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE Transaccion = 'funcionesPRO' AND Major = 6 AND Version_Instalador = '6.000.048' INSERT INTO EMPRESAS..Update_Bin ( Transaccion, Major, Version_Instalador, Version, FileName, FilePath, FileSize, Memo, Tipo, Opcional, Ejecutar, Sobreescribir, Fecha_Ult_Modif, Up_Binary )VALUES( 'funcionesPRO', 6, '6.000.048', '6.0.0.59', 'funcionesPRO.dll', '', '1.0MB', 'Nuevas funcionalidades.', 0, 'NO', 'SI', 'NO', GETDATE(), null ) *** BEGIN TRANSACION *** *** COMMIT *** UPDATE EMPRESAS..Ws_Bin SET Actualizado = 'NO' WHERE (FileName = 'FTO.zip' AND 5 > 2) OR ( FileName = 'FTO.zip' AND Version < '6.000.058' ) OR ( FileName = 'FTO.zip' AND Version <> '6.000.058' AND 'NO' = 'SI') SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE Transaccion = 'FTO' AND Major = 6 AND Version_Instalador = '6.000.048' INSERT INTO EMPRESAS..Update_Bin ( Transaccion, Major, Version_Instalador, Version, FileName, FilePath, FileSize, Memo, Tipo, Opcional, Ejecutar, Sobreescribir, Fecha_Ult_Modif, Up_Binary )VALUES( 'FTO', 6, '6.000.048', '6.000.058', 'FTO.zip', '%APP.PATH%\Management Pro\SQL\FTO', '25KB', 'Ajustes a formatos del sistema(VNRP05)', 5, 'NO', 'SI', 'NO', GETDATE(), null ) *** BEGIN TRANSACION *** *** COMMIT *** UPDATE EMPRESAS..Ws_Bin SET Actualizado = 'NO' WHERE (FileName = 'FI001.dll' AND 1 > 2) OR ( FileName = 'FI001.dll' AND Version < '6.0.0.49' ) OR ( FileName = 'FI001.dll' AND Version <> '6.0.0.49' AND 'NO' = 'SI') SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE Transaccion = 'FI001' AND Major = 6 AND Version_Instalador = '6.000.048'