Samuele E. Locatelli
103 lines
3.5 KiB
Transact-SQL
103 lines
3.5 KiB
Transact-SQL
-- =============================================
|
|
-- Author: Steamware
|
|
-- Mod date: 2014.10.22
|
|
-- Description: copia i parametri per una QL tipo Simulazione per casi clone/revisione
|
|
-- =============================================
|
|
create PROCEDURE [dbo].[stp_QL_copyParamS]
|
|
(
|
|
@QuoteType CHAR(1) = 'Q',
|
|
@QuoteType_orig CHAR(1) = 'Q',
|
|
@CodQuote BIGINT = 0,
|
|
@CodQuote_orig BIGINT = 0,
|
|
@QuoteRev INT = 0,
|
|
@QuoteRev_orig INT = 0
|
|
)
|
|
AS
|
|
|
|
|
|
IF(@QuoteType_orig = 'S')
|
|
-- se partenza è S duplico dati accessori...
|
|
BEGIN
|
|
INSERT INTO QuoteSimPar(QuoteType, CodQuote, QuoteRev, NomePar, ValPar)
|
|
SELECT @QuoteType, @CodQuote, @QuoteRev, NomePar, ValPar
|
|
FROM QuoteSimPar
|
|
WHERE QuoteType = @QuoteType_orig
|
|
AND CodQuote = @CodQuote_orig
|
|
AND QuoteRev = @QuoteRev_orig
|
|
END
|
|
ELSE
|
|
-- se partenza è Q carico alcuni dati accessori precompilando...
|
|
BEGIN
|
|
INSERT INTO QuoteSimPar(QuoteType, CodQuote, QuoteRev, NomePar, ValPar)
|
|
SELECT @QuoteType, @CodQuote, @QuoteRev, Descr, Parameter
|
|
FROM QuoteParam
|
|
WHERE QuoteType = @QuoteType_orig
|
|
AND CodQuote = @CodQuote_orig
|
|
AND QuoteRev = @QuoteRev_orig
|
|
AND Descr IN ('CodDiesGroup', 'CodPlant')
|
|
|
|
INSERT INTO QuoteSimPar(QuoteType, CodQuote, QuoteRev, NomePar, ValPar)
|
|
SELECT @QuoteType, @CodQuote, @QuoteRev, 'DiesTecLife', Parameter
|
|
FROM QuoteParam
|
|
WHERE QuoteType = @QuoteType_orig
|
|
AND CodQuote = @CodQuote_orig
|
|
AND QuoteRev = @QuoteRev_orig
|
|
AND Descr = 'KgTeo'
|
|
|
|
INSERT INTO QuoteSimPar(QuoteType, CodQuote, QuoteRev, NomePar, ValPar)
|
|
SELECT @QuoteType, @CodQuote, @QuoteRev, 'DiesPrice_sim', Parameter
|
|
FROM QuoteParam
|
|
WHERE QuoteType = @QuoteType_orig
|
|
AND CodQuote = @CodQuote_orig
|
|
AND QuoteRev = @QuoteRev_orig
|
|
AND Descr = 'DiesPrice'
|
|
|
|
INSERT INTO QuoteSimPar(QuoteType, CodQuote, QuoteRev, NomePar, ValPar)
|
|
SELECT @QuoteType, @CodQuote, @QuoteRev, 'CodPackag', CodPackag
|
|
FROM QuoteRM
|
|
WHERE QuoteType = @QuoteType_orig
|
|
AND CodQuote = @CodQuote_orig
|
|
AND QuoteRev = @QuoteRev_orig
|
|
|
|
INSERT INTO QuoteSimPar(QuoteType, CodQuote, QuoteRev, NomePar, ValPar)
|
|
SELECT @QuoteType, @CodQuote, @QuoteRev, 'NetProd01_sim', NetProd
|
|
FROM QuoteWorkInt
|
|
WHERE QuoteType = @QuoteType_orig
|
|
AND CodQuote = @CodQuote_orig
|
|
AND QuoteRev = @QuoteRev_orig
|
|
AND ProcessNum = '01'
|
|
|
|
INSERT INTO QuoteSimPar(QuoteType, CodQuote, QuoteRev, NomePar, ValPar)
|
|
SELECT @QuoteType, @CodQuote, @QuoteRev, 'NetProd04_sim', NetProd
|
|
FROM QuoteWorkInt
|
|
WHERE QuoteType = @QuoteType_orig
|
|
AND CodQuote = @CodQuote_orig
|
|
AND QuoteRev = @QuoteRev_orig
|
|
AND ProcessNum = '04'
|
|
|
|
INSERT INTO QuoteSimPar(QuoteType, CodQuote, QuoteRev, NomePar, ValPar)
|
|
SELECT @QuoteType, @CodQuote, @QuoteRev, 'MSR01_sim', MSR
|
|
FROM QuoteWorkInt
|
|
WHERE QuoteType = @QuoteType_orig
|
|
AND CodQuote = @CodQuote_orig
|
|
AND QuoteRev = @QuoteRev_orig
|
|
AND ProcessNum = '01'
|
|
|
|
INSERT INTO QuoteSimPar(QuoteType, CodQuote, QuoteRev, NomePar, ValPar)
|
|
SELECT @QuoteType, @CodQuote, @QuoteRev, 'WSR01_sim', WSR
|
|
FROM QuoteWorkInt
|
|
WHERE QuoteType = @QuoteType_orig
|
|
AND CodQuote = @CodQuote_orig
|
|
AND QuoteRev = @QuoteRev_orig
|
|
AND ProcessNum = '01'
|
|
|
|
INSERT INTO QuoteSimPar(QuoteType, CodQuote, QuoteRev, NomePar, ValPar)
|
|
SELECT @QuoteType, @CodQuote, @QuoteRev, 'DSR_sim', DSR
|
|
FROM QuoteWorkInt
|
|
WHERE QuoteType = @QuoteType_orig
|
|
AND CodQuote = @CodQuote_orig
|
|
AND QuoteRev = @QuoteRev_orig
|
|
AND ProcessNum = '04'
|
|
END
|
|
|
|
RETURN |