| 34 | | <Prompt>nowy numer</Prompt> |
| | 34 | <Prompt>Nowy numer:</Prompt> |
| | 35 | </ReportParameter> |
| | 36 | <ReportParameter Name="grzbiet"> |
| | 37 | <DataType>String</DataType> |
| | 38 | <DefaultValue> |
| | 39 | <DataSetReference> |
| | 40 | <DataSetName>ListaGrzbietow</DataSetName> |
| | 41 | <ValueField>Grzbiet</ValueField> |
| | 42 | </DataSetReference> |
| | 43 | </DefaultValue> |
| | 44 | <Prompt>Grzbiet:</Prompt> |
| | 45 | <ValidValues> |
| | 46 | <DataSetReference> |
| | 47 | <DataSetName>ListaGrzbietow</DataSetName> |
| | 48 | <ValueField>Grzbiet</ValueField> |
| | 49 | <LabelField>Grzbiet</LabelField> |
| | 50 | </DataSetReference> |
| | 51 | </ValidValues> |
| | 52 | <MultiValue>true</MultiValue> |
| 106 | | <CommandText>select R.reklamaId, [UKAÅ»E SIÄ W NR].[Nr Wydania] as nrwyd1, G.[nazwa] as grzbiet1, r.[id reklamy] as reklama1, R.strona as lokalizacja, REKLAMA_STRONA.strona, R.[zatwierdzono do druku] from |
| | 140 | <CommandText>SELECT * FROM |
| | 141 | ( |
| | 142 | SELECT |
| | 143 | R.reklamaId, |
| | 144 | dbo.getSectionForDTP (T.Id,R.grzbiet,R.ogl_dzial) AS staryGrzbiet, |
| | 145 | [UKAÅ»E SIÄ W NR].[Nr Wydania] as nrwyd1, |
| | 146 | G.[nazwa] as grzbiet1, |
| | 147 | r.[id reklamy] as reklama1, |
| | 148 | R.strona AS Uwagi, |
| | 149 | REKLAMA_STRONA.Strona, |
| | 150 | R.[zatwierdzono do druku], |
| | 151 | D.Name AS Dzial, Roz.Name AS Rozdzial, Lok.Text AS Lokalizacja |
| | 152 | FROM REKLAMA AS R |
| | 153 | INNER JOIN [UKAÅ»E SIÄ W NR] ON R.ReklamaID = [UKAÅ»E SIÄ W NR].ReklamaId |
| | 154 | INNER JOIN [Lista tytuÅów] T ON T.Symb=R.[TytuÅ] |
| | 155 | LEFT OUTER JOIN REKLAMA_STRONA ON R.ReklamaID = REKLAMA_STRONA.ReklamaId AND [UKAÅ»E SIÄ W NR].[Nr Wydania] = REKLAMA_STRONA.NR_WYDANIA |
| | 156 | LEFT OUTER JOIN GRZBIETY AS G ON R.GRZBIET = G.ID |
| | 157 | LEFT OUTER JOIN Dzial AS D ON R.ogl_dzial = D.Id |
| | 158 | LEFT OUTER JOIN Rozdzial AS Roz ON R.ogl_rozdzial = Roz.Id |
| | 159 | LEFT OUTER JOIN ReklamaLokalizacja AS Lok ON R.AdLocationId = Lok.Id |
| 108 | | REKLAMA AS R INNER JOIN |
| 109 | | [UKAÅ»E SIÄ W NR] ON R.ReklamaID = [UKAÅ»E SIÄ W NR].ReklamaId LEFT OUTER JOIN |
| 110 | | REKLAMA_STRONA ON R.ReklamaID = REKLAMA_STRONA.ReklamaId AND |
| 111 | | [UKAÅ»E SIÄ W NR].[Nr Wydania] = REKLAMA_STRONA.NR_WYDANIA LEFT OUTER JOIN |
| 112 | | GRZBIETY AS G ON R.GRZBIET = G.ID |
| 113 | | where [UKAÅ»E SIÄ W NR].[Nr Wydania] = @nr1 and r.tytuÅ =@tytul and (r.[zatwierdzono do druku]=1 or |
| 114 | | (r.[zatwierdzono do druku]=0 and REKLAMA_STRONA.strona is not null)) |
| 115 | | and substring(R.[Id reklamy],1,7) not in ( |
| 116 | | select substring(R.[Id reklamy],1,7) from |
| 117 | | |
| 118 | | REKLAMA AS R INNER JOIN |
| 119 | | [UKAÅ»E SIÄ W NR] ON R.ReklamaID = [UKAÅ»E SIÄ W NR].ReklamaId LEFT OUTER JOIN |
| 120 | | REKLAMA_STRONA ON R.ReklamaID = REKLAMA_STRONA.ReklamaId AND |
| 121 | | [UKAÅ»E SIÄ W NR].[Nr Wydania] = REKLAMA_STRONA.NR_WYDANIA LEFT OUTER JOIN |
| 122 | | GRZBIETY AS G ON R.GRZBIET = G.ID |
| 123 | | where [UKAÅ»E SIÄ W NR].[Nr Wydania] = @nr2 and r.tytuÅ =@tytul and r.[zatwierdzono do druku]=1 |
| 124 | | ) order by REKLAMA_STRONA.strona</CommandText> |
| | 161 | WHERE |
| | 162 | [UKAÅ»E SIÄ W NR].[Nr Wydania] = @nr1 |
| | 163 | and r.tytuÅ =@tytul |
| | 164 | and (r.[zatwierdzono do druku]=1 or (r.[zatwierdzono do druku]=0 and REKLAMA_STRONA.strona is not null)) |
| | 165 | and substring(R.[Id reklamy],1,7) not in ( |
| | 166 | SELECT substring(R.[Id reklamy],1,7) FROM REKLAMA AS R |
| | 167 | INNER JOIN [UKAÅ»E SIÄ W NR] ON R.ReklamaID = [UKAÅ»E SIÄ W NR].ReklamaId |
| | 168 | LEFT OUTER JOIN REKLAMA_STRONA ON R.ReklamaID = REKLAMA_STRONA.ReklamaId AND [UKAÅ»E SIÄ W NR].[Nr Wydania] = REKLAMA_STRONA.NR_WYDANIA |
| | 169 | LEFT OUTER JOIN GRZBIETY AS G ON R.GRZBIET = G.ID |
| | 170 | WHERE [UKAÅ»E SIÄ W NR].[Nr Wydania] = @nr2 AND r.tytuÅ =@tytul AND r.[zatwierdzono do druku]=1 |
| | 171 | ) |
| | 172 | ) Reklama |
| | 173 | WHERE Reklama.staryGrzbiet IN (@grzbiet) |
| | 174 | ORDER BY Reklama.Strona</CommandText> |
| | 185 | <QueryParameter Name="@grzbiet"> |
| | 186 | <Value>=Parameters!grzbiet.Value</Value> |
| | 187 | </QueryParameter> |
| | 188 | </QueryParameters> |
| | 189 | <rd:UseGenericDesigner>true</rd:UseGenericDesigner> |
| | 190 | </Query> |
| | 191 | </DataSet> |
| | 192 | <DataSet Name="ListaGrzbietow"> |
| | 193 | <Fields> |
| | 194 | <Field Name="Grzbiet"> |
| | 195 | <DataField>Grzbiet</DataField> |
| | 196 | <rd:TypeName>System.String</rd:TypeName> |
| | 197 | </Field> |
| | 198 | </Fields> |
| | 199 | <Query> |
| | 200 | <DataSourceName>BAZA_REKLAM</DataSourceName> |
| | 201 | <CommandText>DECLARE @Grzbiety TABLE |
| | 202 | ( |
| | 203 | Grzbiet varchar(10) |
| | 204 | ) |
| | 205 | |
| | 206 | IF @tytul='AMT' |
| | 207 | BEGIN |
| | 208 | INSERT INTO @Grzbiety VALUES ('B') |
| | 209 | INSERT INTO @Grzbiety VALUES ('D') |
| | 210 | END |
| | 211 | --IF @tytul='GS' |
| | 212 | --BEGIN |
| | 213 | --END |
| | 214 | |
| | 215 | INSERT INTO @Grzbiety VALUES ('-?-') |
| | 216 | |
| | 217 | SELECT * FROM @Grzbiety</CommandText> |
| | 218 | <QueryParameters> |
| | 219 | <QueryParameter Name="@tytul"> |
| | 220 | <Value>=Parameters!tytul.Value</Value> |
| | 221 | </QueryParameter> |
| | 382 | <Textbox Name="textbox16"> |
| | 383 | <rd:DefaultName>textbox16</rd:DefaultName> |
| | 384 | <Style> |
| | 385 | <BorderColor> |
| | 386 | <Default>LightGrey</Default> |
| | 387 | </BorderColor> |
| | 388 | <BorderStyle> |
| | 389 | <Default>Solid</Default> |
| | 390 | </BorderStyle> |
| | 391 | <BorderWidth> |
| | 392 | <Default>0.5pt</Default> |
| | 393 | </BorderWidth> |
| | 394 | <FontSize>8pt</FontSize> |
| | 395 | <TextAlign>Center</TextAlign> |
| | 396 | <VerticalAlign>Middle</VerticalAlign> |
| | 397 | <PaddingLeft>2pt</PaddingLeft> |
| | 398 | <PaddingRight>2pt</PaddingRight> |
| | 399 | <PaddingTop>2pt</PaddingTop> |
| | 400 | <PaddingBottom>2pt</PaddingBottom> |
| | 401 | </Style> |
| | 402 | <ZIndex>5</ZIndex> |
| | 403 | <CanGrow>true</CanGrow> |
| | 404 | <Value>=Fields!staryGrzbiet.Value</Value> |
| | 405 | </Textbox> |
| | 406 | </ReportItems> |
| | 407 | </TableCell> |
| | 408 | <TableCell> |
| | 409 | <ReportItems> |
| | 430 | <ZIndex>4</ZIndex> |
| | 431 | <CanGrow>true</CanGrow> |
| | 432 | <Value>=Fields!grzbiet1.Value</Value> |
| | 433 | </Textbox> |
| | 434 | </ReportItems> |
| | 435 | </TableCell> |
| | 436 | <TableCell> |
| | 437 | <ReportItems> |
| | 438 | <Textbox Name="textbox14"> |
| | 439 | <rd:DefaultName>textbox14</rd:DefaultName> |
| | 440 | <Style> |
| | 441 | <BorderColor> |
| | 442 | <Default>LightGrey</Default> |
| | 443 | </BorderColor> |
| | 444 | <BorderStyle> |
| | 445 | <Default>Solid</Default> |
| | 446 | </BorderStyle> |
| | 447 | <BorderWidth> |
| | 448 | <Default>0.5pt</Default> |
| | 449 | </BorderWidth> |
| | 450 | <FontSize>8pt</FontSize> |
| | 451 | <TextAlign>Center</TextAlign> |
| | 452 | <VerticalAlign>Middle</VerticalAlign> |
| | 453 | <PaddingLeft>2pt</PaddingLeft> |
| | 454 | <PaddingRight>2pt</PaddingRight> |
| | 455 | <PaddingTop>2pt</PaddingTop> |
| | 456 | <PaddingBottom>2pt</PaddingBottom> |
| | 457 | </Style> |
| | 458 | <ZIndex>3</ZIndex> |
| | 459 | <CanGrow>true</CanGrow> |
| | 460 | <Value>=Fields!Dzial.Value</Value> |
| | 461 | </Textbox> |
| | 462 | </ReportItems> |
| | 463 | </TableCell> |
| | 464 | <TableCell> |
| | 465 | <ReportItems> |
| | 466 | <Textbox Name="textbox11"> |
| | 467 | <rd:DefaultName>textbox11</rd:DefaultName> |
| | 468 | <Style> |
| | 469 | <BorderColor> |
| | 470 | <Default>LightGrey</Default> |
| | 471 | </BorderColor> |
| | 472 | <BorderStyle> |
| | 473 | <Default>Solid</Default> |
| | 474 | </BorderStyle> |
| | 475 | <BorderWidth> |
| | 476 | <Default>0.5pt</Default> |
| | 477 | </BorderWidth> |
| | 478 | <FontSize>8pt</FontSize> |
| | 479 | <TextAlign>Center</TextAlign> |
| | 480 | <VerticalAlign>Middle</VerticalAlign> |
| | 481 | <PaddingLeft>2pt</PaddingLeft> |
| | 482 | <PaddingRight>2pt</PaddingRight> |
| | 483 | <PaddingTop>2pt</PaddingTop> |
| | 484 | <PaddingBottom>2pt</PaddingBottom> |
| | 485 | </Style> |
| | 486 | <ZIndex>2</ZIndex> |
| | 487 | <CanGrow>true</CanGrow> |
| | 488 | <Value>=Fields!Rozdzial.Value</Value> |
| | 489 | </Textbox> |
| | 490 | </ReportItems> |
| | 491 | </TableCell> |
| | 492 | <TableCell> |
| | 493 | <ReportItems> |
| | 494 | <Textbox Name="textbox8"> |
| | 495 | <rd:DefaultName>textbox8</rd:DefaultName> |
| | 496 | <Style> |
| | 497 | <BorderColor> |
| | 498 | <Default>LightGrey</Default> |
| | 499 | </BorderColor> |
| | 500 | <BorderStyle> |
| | 501 | <Default>Solid</Default> |
| | 502 | </BorderStyle> |
| | 503 | <BorderWidth> |
| | 504 | <Default>0.5pt</Default> |
| | 505 | </BorderWidth> |
| | 506 | <FontSize>8pt</FontSize> |
| | 507 | <TextAlign>Center</TextAlign> |
| | 508 | <VerticalAlign>Middle</VerticalAlign> |
| | 509 | <PaddingLeft>2pt</PaddingLeft> |
| | 510 | <PaddingRight>2pt</PaddingRight> |
| | 511 | <PaddingTop>2pt</PaddingTop> |
| | 512 | <PaddingBottom>2pt</PaddingBottom> |
| | 513 | </Style> |
| | 673 | </Textbox> |
| | 674 | </ReportItems> |
| | 675 | </TableCell> |
| | 676 | <TableCell> |
| | 677 | <ReportItems> |
| | 678 | <Textbox Name="textbox15"> |
| | 679 | <rd:DefaultName>textbox15</rd:DefaultName> |
| | 680 | <Style> |
| | 681 | <BackgroundColor>WhiteSmoke</BackgroundColor> |
| | 682 | <BorderColor> |
| | 683 | <Default>LightGrey</Default> |
| | 684 | </BorderColor> |
| | 685 | <BorderStyle> |
| | 686 | <Default>Solid</Default> |
| | 687 | </BorderStyle> |
| | 688 | <BorderWidth> |
| | 689 | <Default>0.5pt</Default> |
| | 690 | </BorderWidth> |
| | 691 | <FontSize>8pt</FontSize> |
| | 692 | <FontWeight>700</FontWeight> |
| | 693 | <TextAlign>Center</TextAlign> |
| | 694 | <VerticalAlign>Middle</VerticalAlign> |
| | 695 | <PaddingLeft>2pt</PaddingLeft> |
| | 696 | <PaddingRight>2pt</PaddingRight> |
| | 697 | <PaddingTop>2pt</PaddingTop> |
| | 698 | <PaddingBottom>2pt</PaddingBottom> |
| | 699 | </Style> |
| | 700 | <ZIndex>15</ZIndex> |
| | 701 | <CanGrow>true</CanGrow> |
| | 702 | <Value>Stary grzbiet</Value> |
| | 733 | </Textbox> |
| | 734 | </ReportItems> |
| | 735 | </TableCell> |
| | 736 | <TableCell> |
| | 737 | <ReportItems> |
| | 738 | <Textbox Name="textbox13"> |
| | 739 | <rd:DefaultName>textbox13</rd:DefaultName> |
| | 740 | <Style> |
| | 741 | <BackgroundColor>WhiteSmoke</BackgroundColor> |
| | 742 | <BorderColor> |
| | 743 | <Default>LightGrey</Default> |
| | 744 | </BorderColor> |
| | 745 | <BorderStyle> |
| | 746 | <Default>Solid</Default> |
| | 747 | </BorderStyle> |
| | 748 | <BorderWidth> |
| | 749 | <Default>0.5pt</Default> |
| | 750 | </BorderWidth> |
| | 751 | <FontSize>8pt</FontSize> |
| | 752 | <FontWeight>700</FontWeight> |
| | 753 | <TextAlign>Center</TextAlign> |
| | 754 | <VerticalAlign>Middle</VerticalAlign> |
| | 755 | <PaddingLeft>2pt</PaddingLeft> |
| | 756 | <PaddingRight>2pt</PaddingRight> |
| | 757 | <PaddingTop>2pt</PaddingTop> |
| | 758 | <PaddingBottom>2pt</PaddingBottom> |
| | 759 | </Style> |
| | 760 | <ZIndex>13</ZIndex> |
| | 761 | <CanGrow>true</CanGrow> |
| | 762 | <Value>DziaÅ</Value> |
| | 763 | </Textbox> |
| | 764 | </ReportItems> |
| | 765 | </TableCell> |
| | 766 | <TableCell> |
| | 767 | <ReportItems> |
| | 768 | <Textbox Name="textbox9"> |
| | 769 | <rd:DefaultName>textbox9</rd:DefaultName> |
| | 770 | <Style> |
| | 771 | <BackgroundColor>WhiteSmoke</BackgroundColor> |
| | 772 | <BorderColor> |
| | 773 | <Default>LightGrey</Default> |
| | 774 | </BorderColor> |
| | 775 | <BorderStyle> |
| | 776 | <Default>Solid</Default> |
| | 777 | </BorderStyle> |
| | 778 | <BorderWidth> |
| | 779 | <Default>0.5pt</Default> |
| | 780 | </BorderWidth> |
| | 781 | <FontSize>8pt</FontSize> |
| | 782 | <FontWeight>700</FontWeight> |
| | 783 | <TextAlign>Center</TextAlign> |
| | 784 | <VerticalAlign>Middle</VerticalAlign> |
| | 785 | <PaddingLeft>2pt</PaddingLeft> |
| | 786 | <PaddingRight>2pt</PaddingRight> |
| | 787 | <PaddingTop>2pt</PaddingTop> |
| | 788 | <PaddingBottom>2pt</PaddingBottom> |
| | 789 | </Style> |
| | 790 | <ZIndex>12</ZIndex> |
| | 791 | <CanGrow>true</CanGrow> |
| | 792 | <Value>RozdziaÅ</Value> |
| | 793 | </Textbox> |
| | 794 | </ReportItems> |
| | 795 | </TableCell> |
| | 796 | <TableCell> |
| | 797 | <ReportItems> |
| | 798 | <Textbox Name="textbox7"> |
| | 799 | <rd:DefaultName>textbox7</rd:DefaultName> |
| | 800 | <Style> |
| | 801 | <BackgroundColor>WhiteSmoke</BackgroundColor> |
| | 802 | <BorderColor> |
| | 803 | <Default>LightGrey</Default> |
| | 804 | </BorderColor> |
| | 805 | <BorderStyle> |
| | 806 | <Default>Solid</Default> |
| | 807 | </BorderStyle> |
| | 808 | <BorderWidth> |
| | 809 | <Default>0.5pt</Default> |
| | 810 | </BorderWidth> |
| | 811 | <FontSize>8pt</FontSize> |
| | 812 | <FontWeight>700</FontWeight> |
| | 813 | <TextAlign>Center</TextAlign> |
| | 814 | <VerticalAlign>Middle</VerticalAlign> |
| | 815 | <PaddingLeft>2pt</PaddingLeft> |
| | 816 | <PaddingRight>2pt</PaddingRight> |
| | 817 | <PaddingTop>2pt</PaddingTop> |
| | 818 | <PaddingBottom>2pt</PaddingBottom> |
| | 819 | </Style> |
| | 820 | <ZIndex>11</ZIndex> |
| | 821 | <CanGrow>true</CanGrow> |
| | 822 | <Value>Lokalizacja</Value> |