| | 72 | <MultiValue>true</MultiValue> |
| | 73 | </ReportParameter> |
| | 74 | <ReportParameter Name="dzial"> |
| | 75 | <DataType>String</DataType> |
| | 76 | <DefaultValue> |
| | 77 | <DataSetReference> |
| | 78 | <DataSetName>ListaDzialow</DataSetName> |
| | 79 | <ValueField>Id</ValueField> |
| | 80 | </DataSetReference> |
| | 81 | </DefaultValue> |
| | 82 | <AllowBlank>true</AllowBlank> |
| | 83 | <Prompt>DziaÅy:</Prompt> |
| | 84 | <ValidValues> |
| | 85 | <DataSetReference> |
| | 86 | <DataSetName>ListaDzialow</DataSetName> |
| | 87 | <ValueField>Id</ValueField> |
| | 88 | <LabelField>Name</LabelField> |
| | 89 | </DataSetReference> |
| | 90 | </ValidValues> |
| | 91 | <MultiValue>true</MultiValue> |
| 192 | | <Field Name="dziaÅ_txt"> |
| 193 | | <DataField>dziaÅ_txt</DataField> |
| 194 | | <rd:TypeName>System.String</rd:TypeName> |
| 195 | | </Field> |
| 196 | | <Field Name="rozdziaÅ_txt"> |
| 197 | | <DataField>rozdziaÅ_txt</DataField> |
| | 220 | <Field Name="nettoZEmisji"> |
| | 221 | <DataField>nettoZEmisji</DataField> |
| | 222 | <rd:TypeName>System.Decimal</rd:TypeName> |
| | 223 | </Field> |
| | 224 | <Field Name="zafakturowana"> |
| | 225 | <DataField>zafakturowana</DataField> |
| | 226 | <rd:TypeName>System.Boolean</rd:TypeName> |
| | 227 | </Field> |
| | 228 | <Field Name="Dzial"> |
| | 229 | <DataField>Dzial</DataField> |
| | 230 | <rd:TypeName>System.String</rd:TypeName> |
| | 231 | </Field> |
| | 232 | <Field Name="Rozdzial"> |
| | 233 | <DataField>Rozdzial</DataField> |
| 203 | | <CommandText>SELECT R.ReklamaID, R.TYTUÅ, R.[ID REKLAMY], R.SZER, R.WYS, R.KOLOR, R.[NICK NAME], R.MOD_TYP, R.RABAT, R.STRONA AS lokalizacja, |
| 204 | | [UKAÅ»E SIÄ W NR].[Nr Wydania] AS NR, R.[ZATWIERDZONO DO DRUKU], R.GRZBIET, REKLAMA_STRONA.STRONA, A.Symbol AS agencja, |
| 205 | | R.[SYMBOL AKWIZYTORA], R.KROTNOÅÄ, R.NETTO, G.Nazwa AS nazwaGrzbietu, A2.ID_AGENTA, R.[CENA JEDN], R.[RABAT WARTOÅÄ], OD.dziaÅ_txt, |
| 206 | | ORZ.rozdziaÅ_txt |
| 207 | | FROM AGENCI AS A2 LEFT OUTER JOIN |
| 208 | | AGENCJE AS A ON A.Id_agencji = A2.ID_AGENCJI INNER JOIN |
| 209 | | REKLAMA AS R ON A2.Symbol = R.[SYMBOL AKWIZYTORA] INNER JOIN |
| 210 | | [UKAÅ»E SIÄ W NR] ON R.ReklamaID = [UKAÅ»E SIÄ W NR].ReklamaId LEFT OUTER JOIN |
| 211 | | REKLAMA_STRONA ON R.ReklamaID = REKLAMA_STRONA.ReklamaId AND |
| 212 | | [UKAÅ»E SIÄ W NR].[Nr Wydania] = REKLAMA_STRONA.NR_WYDANIA LEFT OUTER JOIN |
| 213 | | GRZBIETY AS G ON R.GRZBIET = G.ID LEFT OUTER JOIN |
| 214 | | ogl_dzialy AS OD ON OD.DZIAÅ_NR = R.ogl_dzial LEFT OUTER JOIN |
| 215 | | ogl_rozdzialy AS ORZ ON OD.DZIAÅ_NR = ORZ.DZIAL AND R.ogl_rozdzial = ORZ.id |
| 216 | | WHERE (R.[ZATWIERDZONO DO DRUKU] = 1) AND (R.TYTUÅ = @tytul) AND ([UKAÅ»E SIÄ W NR].[Nr Wydania] = @nrwydania) AND (@agencja IS NULL) AND |
| 217 | | (@agent IS NULL) AND (@grzbiet IS NULL) AND ([UKAÅ»E SIÄ W NR].status <> 2) OR |
| 218 | | (R.[ZATWIERDZONO DO DRUKU] = 1) AND (R.TYTUÅ = @tytul) AND ([UKAÅ»E SIÄ W NR].[Nr Wydania] = @nrwydania) AND (@agencja IS NULL) AND |
| 219 | | (@agent IS NULL) AND (R.GRZBIET = @grzbiet) AND ([UKAÅ»E SIÄ W NR].status <> 2) OR |
| 220 | | (R.[ZATWIERDZONO DO DRUKU] = 1) AND (R.TYTUÅ = @tytul) AND ([UKAÅ»E SIÄ W NR].[Nr Wydania] = @nrwydania) AND (@agencja IS NULL) AND |
| 221 | | (@grzbiet IS NULL) AND (A2.ID_AGENTA = @agent) AND ([UKAÅ»E SIÄ W NR].status <> 2) OR |
| 222 | | (R.[ZATWIERDZONO DO DRUKU] = 1) AND (R.TYTUÅ = @tytul) AND ([UKAÅ»E SIÄ W NR].[Nr Wydania] = @nrwydania) AND (@agencja IS NULL) AND |
| 223 | | (R.GRZBIET = @grzbiet) AND (A2.ID_AGENTA = @agent) AND ([UKAÅ»E SIÄ W NR].status <> 2) OR |
| 224 | | (R.[ZATWIERDZONO DO DRUKU] = 1) AND (R.TYTUÅ = @tytul) AND ([UKAÅ»E SIÄ W NR].[Nr Wydania] = @nrwydania) AND (@agent IS NULL) AND |
| 225 | | (@grzbiet IS NULL) AND (A.Id_agencji = @agencja) AND ([UKAÅ»E SIÄ W NR].status <> 2) OR |
| 226 | | (R.[ZATWIERDZONO DO DRUKU] = 1) AND (R.TYTUÅ = @tytul) AND ([UKAÅ»E SIÄ W NR].[Nr Wydania] = @nrwydania) AND (@agent IS NULL) AND |
| 227 | | (R.GRZBIET = @grzbiet) AND (A.Id_agencji = @agencja) AND ([UKAÅ»E SIÄ W NR].status <> 2) OR |
| 228 | | (R.[ZATWIERDZONO DO DRUKU] = 1) AND (R.TYTUÅ = @tytul) AND ([UKAÅ»E SIÄ W NR].[Nr Wydania] = @nrwydania) AND (@grzbiet IS NULL) AND |
| 229 | | (A2.ID_AGENTA = @agent) AND (A.Id_agencji = @agencja) AND ([UKAÅ»E SIÄ W NR].status <> 2) OR |
| 230 | | (R.[ZATWIERDZONO DO DRUKU] = 1) AND (R.TYTUÅ = @tytul) AND ([UKAÅ»E SIÄ W NR].[Nr Wydania] = @nrwydania) AND (R.GRZBIET = @grzbiet) AND |
| 231 | | (A2.ID_AGENTA = @agent) AND (A.Id_agencji = @agencja) AND ([UKAÅ»E SIÄ W NR].status <> 2) |
| 232 | | ORDER BY R.[ID REKLAMY]</CommandText> |
| | 239 | <CommandType>StoredProcedure</CommandType> |
| | 240 | <CommandText>sp_GetListaReklamNaWydanie</CommandText> |
| 336 | | union |
| 337 | | select NULL ,'Wszystkie' |
| 338 | | order by Nazwa</CommandText> |
| | 350 | WHERE Active=1 AND TytulId=@tytul |
| | 351 | ORDER BY Nazwa</CommandText> |
| | 352 | <QueryParameters> |
| | 353 | <QueryParameter Name="@tytul"> |
| | 354 | <Value>=Parameters!tytul.Value</Value> |
| | 355 | </QueryParameter> |
| | 356 | </QueryParameters> |
| | 357 | <rd:UseGenericDesigner>true</rd:UseGenericDesigner> |
| | 358 | </Query> |
| | 359 | </DataSet> |
| | 360 | <DataSet Name="ListaDzialow"> |
| | 361 | <Fields> |
| | 362 | <Field Name="Id"> |
| | 363 | <DataField>Id</DataField> |
| | 364 | <rd:TypeName>System.Int32</rd:TypeName> |
| | 365 | </Field> |
| | 366 | <Field Name="Name"> |
| | 367 | <DataField>Name</DataField> |
| | 368 | <rd:TypeName>System.String</rd:TypeName> |
| | 369 | </Field> |
| | 370 | </Fields> |
| | 371 | <Query> |
| | 372 | <DataSourceName>BAZA_REKLAM</DataSourceName> |
| | 373 | <CommandText>DECLARE @Dzialy Table |
| | 374 | ( |
| | 375 | Id INT, |
| | 376 | Name NVARCHAR(50) |
| | 377 | ) |
| | 378 | |
| | 379 | INSERT INTO @Dzialy |
| | 380 | SELECT Id, Name FROM Dzial WHERE Active=1 AND TitleId=@tytul |
| | 381 | |
| | 382 | IF (SELECT COUNT(Id) FROM @Dzialy)<1 |
| | 383 | INSERT INTO @Dzialy |
| | 384 | SELECT 0, 'Wszystkie dziaÅy' |
| | 385 | |
| | 386 | SELECT * FROM @Dzialy</CommandText> |
| | 387 | <QueryParameters> |
| | 388 | <QueryParameter Name="@tytul"> |
| | 389 | <Value>=Parameters!tytul.Value</Value> |
| | 390 | </QueryParameter> |
| | 391 | </QueryParameters> |
| | 409 | <Textbox Name="textbox3"> |
| | 410 | <Top>1.2cm</Top> |
| | 411 | <Width>2.55cm</Width> |
| | 412 | <Style> |
| | 413 | <FontSize>12pt</FontSize> |
| | 414 | <FontWeight>700</FontWeight> |
| | 415 | <Format>d</Format> |
| | 416 | <TextAlign>Left</TextAlign> |
| | 417 | <PaddingLeft>2pt</PaddingLeft> |
| | 418 | <PaddingRight>2pt</PaddingRight> |
| | 419 | <PaddingTop>2pt</PaddingTop> |
| | 420 | <PaddingBottom>2pt</PaddingBottom> |
| | 421 | <Language>pl-PL</Language> |
| | 422 | </Style> |
| | 423 | <ZIndex>4</ZIndex> |
| | 424 | <CanGrow>true</CanGrow> |
| | 425 | <Height>0.75cm</Height> |
| | 426 | <Value>Grzbiet(y):</Value> |
| | 427 | </Textbox> |
| | 428 | <Textbox Name="textbox7"> |
| | 429 | <Top>1.2cm</Top> |
| | 430 | <Width>21.45cm</Width> |
| | 431 | <Style> |
| | 432 | <FontSize>12pt</FontSize> |
| | 433 | <Format>d</Format> |
| | 434 | <TextAlign>Left</TextAlign> |
| | 435 | <PaddingLeft>2pt</PaddingLeft> |
| | 436 | <PaddingRight>2pt</PaddingRight> |
| | 437 | <PaddingTop>2pt</PaddingTop> |
| | 438 | <PaddingBottom>2pt</PaddingBottom> |
| | 439 | <Language>pl-PL</Language> |
| | 440 | </Style> |
| | 441 | <ZIndex>3</ZIndex> |
| | 442 | <CanGrow>true</CanGrow> |
| | 443 | <Left>2.55cm</Left> |
| | 444 | <Height>0.75cm</Height> |
| | 445 | <Value>=Code.GetMultiSelectLabels(Parameters!grzbiet)</Value> |
| | 446 | </Textbox> |
| 367 | | </Textbox> |
| 368 | | <Textbox Name="textbox5"> |
| 369 | | <Top>0.25cm</Top> |
| 370 | | <Width>4.5cm</Width> |
| 371 | | <Style> |
| 372 | | <FontSize>12pt</FontSize> |
| 373 | | <FontWeight>700</FontWeight> |
| 374 | | <Format>d</Format> |
| 375 | | <TextAlign>Left</TextAlign> |
| 376 | | <PaddingLeft>2pt</PaddingLeft> |
| 377 | | <PaddingRight>2pt</PaddingRight> |
| 378 | | <PaddingTop>2pt</PaddingTop> |
| 379 | | <PaddingBottom>2pt</PaddingBottom> |
| 380 | | <Language>pl-PL</Language> |
| 381 | | </Style> |
| 382 | | <ZIndex>2</ZIndex> |
| 383 | | <CanGrow>true</CanGrow> |
| 384 | | <Left>11.5cm</Left> |
| 385 | | <Height>0.75cm</Height> |
| 386 | | <Value>="Grzbiet: " & Parameters!grzbiet.Label</Value> |
| 563 | | <Textbox Name="KOLOR"> |
| 564 | | <rd:DefaultName>KOLOR</rd:DefaultName> |
| 565 | | <Style> |
| 566 | | <BorderColor> |
| 567 | | <Default>LightGrey</Default> |
| 568 | | </BorderColor> |
| 569 | | <BorderStyle> |
| 570 | | <Default>Solid</Default> |
| 571 | | </BorderStyle> |
| 572 | | <BorderWidth> |
| 573 | | <Default>0.5pt</Default> |
| 574 | | </BorderWidth> |
| 575 | | <FontSize>7pt</FontSize> |
| 576 | | <TextAlign>Center</TextAlign> |
| 577 | | <VerticalAlign>Middle</VerticalAlign> |
| 578 | | <PaddingLeft>2pt</PaddingLeft> |
| 579 | | <PaddingRight>2pt</PaddingRight> |
| 580 | | <PaddingTop>2pt</PaddingTop> |
| 581 | | <PaddingBottom>2pt</PaddingBottom> |
| 582 | | <Language>pl-PL</Language> |
| 583 | | </Style> |
| 584 | | <ZIndex>6</ZIndex> |
| 585 | | <CanGrow>true</CanGrow> |
| 586 | | <Value>=Fields!KOLOR.Value</Value> |
| 587 | | </Textbox> |
| 588 | | </ReportItems> |
| 589 | | </TableCell> |
| 590 | | <TableCell> |
| 591 | | <ReportItems> |
| | 729 | <Style> |
| | 730 | <BorderColor> |
| | 731 | <Default>LightGrey</Default> |
| | 732 | </BorderColor> |
| | 733 | <BorderStyle> |
| | 734 | <Default>Solid</Default> |
| | 735 | </BorderStyle> |
| | 736 | <BorderWidth> |
| | 737 | <Default>0.5pt</Default> |
| | 738 | </BorderWidth> |
| | 739 | <FontSize>7pt</FontSize> |
| | 740 | <TextAlign>Center</TextAlign> |
| | 741 | <VerticalAlign>Middle</VerticalAlign> |
| | 742 | <PaddingLeft>2pt</PaddingLeft> |
| | 743 | <PaddingRight>2pt</PaddingRight> |
| | 744 | <PaddingTop>2pt</PaddingTop> |
| | 745 | <PaddingBottom>2pt</PaddingBottom> |
| | 746 | <Language>pl-PL</Language> |
| | 747 | </Style> |
| | 748 | <ZIndex>3</ZIndex> |
| | 749 | <CanGrow>true</CanGrow> |
| | 750 | <Value>=Fields!lokalizacja1.Value</Value> |
| | 751 | </Textbox> |
| | 752 | </ReportItems> |
| | 753 | </TableCell> |
| | 754 | <TableCell> |
| | 755 | <ReportItems> |
| | 756 | <Textbox Name="textbox16"> |
| 1011 | | <Textbox Name="textbox16"> |
| 1012 | | <rd:DefaultName>textbox16</rd:DefaultName> |
| 1013 | | <Style> |
| 1014 | | <BackgroundColor>WhiteSmoke</BackgroundColor> |
| 1015 | | <BorderColor> |
| 1016 | | <Default>LightGrey</Default> |
| 1017 | | </BorderColor> |
| 1018 | | <BorderStyle> |
| 1019 | | <Default>Solid</Default> |
| 1020 | | </BorderStyle> |
| 1021 | | <BorderWidth> |
| 1022 | | <Default>0.5pt</Default> |
| 1023 | | </BorderWidth> |
| 1024 | | <FontSize>7pt</FontSize> |
| 1025 | | <FontWeight>700</FontWeight> |
| 1026 | | <TextAlign>Center</TextAlign> |
| 1027 | | <VerticalAlign>Middle</VerticalAlign> |
| 1028 | | <PaddingLeft>2pt</PaddingLeft> |
| 1029 | | <PaddingRight>2pt</PaddingRight> |
| 1030 | | <PaddingTop>2pt</PaddingTop> |
| 1031 | | <PaddingBottom>2pt</PaddingBottom> |
| 1032 | | <Language>pl-PL</Language> |
| 1033 | | </Style> |
| 1034 | | <ZIndex>18</ZIndex> |
| 1035 | | <CanGrow>true</CanGrow> |
| 1036 | | <Value>KOLOR</Value> |
| 1037 | | </Textbox> |
| 1038 | | </ReportItems> |
| 1039 | | </TableCell> |
| 1040 | | <TableCell> |
| 1041 | | <ReportItems> |
| | 1203 | <ZIndex>15</ZIndex> |
| | 1204 | <CanGrow>true</CanGrow> |
| | 1205 | <Value>Lokalizacja</Value> |
| | 1206 | </Textbox> |
| | 1207 | </ReportItems> |
| | 1208 | </TableCell> |
| | 1209 | <TableCell> |
| | 1210 | <ReportItems> |
| | 1211 | <Textbox Name="textbox14"> |
| | 1212 | <rd:DefaultName>textbox14</rd:DefaultName> |
| | 1213 | <Style> |
| | 1214 | <BackgroundColor>WhiteSmoke</BackgroundColor> |
| | 1215 | <BorderColor> |
| | 1216 | <Default>LightGrey</Default> |
| | 1217 | </BorderColor> |
| | 1218 | <BorderStyle> |
| | 1219 | <Default>Solid</Default> |
| | 1220 | </BorderStyle> |
| | 1221 | <BorderWidth> |
| | 1222 | <Default>0.5pt</Default> |
| | 1223 | </BorderWidth> |
| | 1224 | <FontSize>7pt</FontSize> |
| | 1225 | <FontWeight>700</FontWeight> |
| | 1226 | <TextAlign>Center</TextAlign> |
| | 1227 | <VerticalAlign>Middle</VerticalAlign> |
| | 1228 | <PaddingLeft>2pt</PaddingLeft> |
| | 1229 | <PaddingRight>2pt</PaddingRight> |
| | 1230 | <PaddingTop>2pt</PaddingTop> |
| | 1231 | <PaddingBottom>2pt</PaddingBottom> |
| | 1232 | </Style> |