1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51
|
ALTER PROCEDURE EZWA_PAO_TemplatePageGetDivs
(
@CurrentClient int,
@CodePage int
)
AS
/* SET NOCOUNT ON */
Declare @LinkToTemplate int
declare @nbrDivs int
SELECT
@nbrDivs = isnull(COUNT(A.Code),0),
@LinkToTemplate = B.L01_C
FROM B LEFT OUTER JOIN
A ON
B.Code = A.L01_B
WHERE (B.Code = @CodePage) AND (B.L01_E = @CurrentClient)
GROUP BY B.L01_C
IF @nbrDivs = 0
BEGIN
IF NOT @LinkToTemplate IS NULL
BEGIN
-- Chargement des divs du template
SELECT
txtFromCellId,
txtToCellId,
intZOrder,
-1 as L01_D
FROM
CBloc
WHERE
(L01_C = @LinkToTemplate)
ORDER BY intZOrder
END
END
ELSE
BEGIN
-- Chargement des divs de la page
SELECT
txtFromCellId,
txtToCellId,
intZOrder,
L01_D
FROM
A
WHERE
(L01_E = @CurrentClient) AND (L01_B = @CodePage)
ORDER BY intZOrder
END
RETURN |
Partager