- Data:
- 2009-02-12 15:38:00 (17 years ago)
- Lokalizacja:
- trunk
- Pliki:
-
- 1 dodane
- 8 zmodyfikowane
-
BazaReklam/REKLAMADataSet.Designer.cs (zmodyfikowane) (11 diffs)
-
BazaReklam/REKLAMADataSet.xsd (zmodyfikowane) (3 diffs)
-
BazaReklam/REKLAMADataSet.xss (zmodyfikowane) (4 diffs)
-
BazaReklam/ZamowieniaForm.Designer.cs (zmodyfikowane) (8 diffs)
-
BazaReklam/ZamowieniaForm.resx (zmodyfikowane) (1 diff)
-
BazaReklam/ZestawienieZamowienForm.Designer.cs (zmodyfikowane) (10 diffs)
-
BazaReklam/ZestawienieZamowienForm.cs (zmodyfikowane) (1 diff)
-
BazaReklam/ZestawienieZamowienForm.resx (zmodyfikowane) (3 diffs)
-
SQL/Views/EmisjeReklamy.txt (dodane)
Legenda:
- Bez zmian
- Dodane
- Usunięte
-
trunk/BazaReklam/REKLAMADataSet.Designer.cs
r347 r349 1599 1599 private global::System.Data.DataColumn columnidZamowienia; 1600 1600 1601 private global::System.Data.DataColumn columnData1Emisji; 1602 1601 1603 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 1602 1604 public REKLAMADataTable() { … … 2130 2132 get { 2131 2133 return this.columnidZamowienia; 2134 } 2135 } 2136 2137 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 2138 public global::System.Data.DataColumn Data1EmisjiColumn { 2139 get { 2140 return this.columnData1Emisji; 2132 2141 } 2133 2142 } … … 2233 2242 int ogl_dzial, 2234 2243 int ogl_rozdzial, 2235 int idZamowienia) { 2244 int idZamowienia, 2245 System.DateTime Data1Emisji) { 2236 2246 REKLAMARow rowREKLAMARow = ((REKLAMARow)(this.NewRow())); 2237 2247 object[] columnValuesArray = new object[] { … … 2307 2317 ogl_dzial, 2308 2318 ogl_rozdzial, 2309 idZamowienia}; 2319 idZamowienia, 2320 Data1Emisji}; 2310 2321 if ((parentKLIENCIRowByKLIENCI_REKLAMA != null)) { 2311 2322 columnValuesArray[1] = parentKLIENCIRowByKLIENCI_REKLAMA[25]; … … 2416 2427 this.columnogl_rozdzial = base.Columns["ogl_rozdzial"]; 2417 2428 this.columnidZamowienia = base.Columns["idZamowienia"]; 2429 this.columnData1Emisji = base.Columns["Data1Emisji"]; 2418 2430 } 2419 2431 … … 2566 2578 this.columnidZamowienia = new global::System.Data.DataColumn("idZamowienia", typeof(int), null, global::System.Data.MappingType.Element); 2567 2579 base.Columns.Add(this.columnidZamowienia); 2580 this.columnData1Emisji = new global::System.Data.DataColumn("Data1Emisji", typeof(global::System.DateTime), null, global::System.Data.MappingType.Element); 2581 base.Columns.Add(this.columnData1Emisji); 2568 2582 this.Constraints.Add(new global::System.Data.UniqueConstraint("Constraint1", new global::System.Data.DataColumn[] { 2569 2583 this.columnReklamaID}, true)); … … 2627 2641 this.columnlogo.AllowDBNull = false; 2628 2642 this.columnlogo.DefaultValue = ((bool)(false)); 2643 this.columnData1Emisji.ReadOnly = true; 2629 2644 } 2630 2645 … … 19982 19997 19983 19998 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 19999 public System.DateTime Data1Emisji { 20000 get { 20001 try { 20002 return ((global::System.DateTime)(this[this.tableREKLAMA.Data1EmisjiColumn])); 20003 } 20004 catch (global::System.InvalidCastException e) { 20005 throw new global::System.Data.StrongTypingException("The value for column \'Data1Emisji\' in table \'REKLAMA\' is DBNull.", e); 20006 } 20007 } 20008 set { 20009 this[this.tableREKLAMA.Data1EmisjiColumn] = value; 20010 } 20011 } 20012 20013 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 19984 20014 public KLIENCIRow KLIENCIRow { 19985 20015 get { … … 20669 20699 public void SetidZamowieniaNull() { 20670 20700 this[this.tableREKLAMA.idZamowieniaColumn] = global::System.Convert.DBNull; 20701 } 20702 20703 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 20704 public bool IsData1EmisjiNull() { 20705 return this.IsNull(this.tableREKLAMA.Data1EmisjiColumn); 20706 } 20707 20708 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 20709 public void SetData1EmisjiNull() { 20710 this[this.tableREKLAMA.Data1EmisjiColumn] = global::System.Convert.DBNull; 20671 20711 } 20672 20712 … … 36054 36094 this._commandCollection[3] = new global::System.Data.SqlClient.SqlCommand(); 36055 36095 this._commandCollection[3].Connection = this.Connection; 36056 this._commandCollection[3].CommandText = @"SELECT ReklamaID, CustomerID, [SYMBOL AKWIZYTORA], TYTUŁ, TYP, [ID REKLAMY], [NICK NAME], [DATA ZAMÓWIENIA], SZER, WYS, MOD_TYP, STRONA, [STR NR WT], 36057 [STR NR PT], KROTNOŚĆ, ODSTĘP, KOLOR, [WSKAZANIE MIEJSCA], RABAT, [RABAT WARTOŚĆ], ZAPŁACONO, [ZATWIERDZONO DO DRUKU], [DATA ZAPŁATY], 36058 [SYMBOL POTWIERDZENIA], [RODZAJ POTWIERDZENIA], [CENA JEDN], NETTO, VAT, PVAT, BRUTTO, [PROCENT PROWIZJI], PROWIZJA, INFO, 36059 [FAKTURA NUMER], [FAKTURA ID KONTA], [FAKTURA DATA WYSTAWIENIA], [FAKTURA DATA SPRZEDAŻY], [FAKTURA TERMIN ZAPŁATY], 36060 [FAKTURA FORMA PŁATNOŚCI], [FAKTURA WYSTAWIONO], [FAKTURA RODZAJ], USERID, [DATA OSTATNIEJ MODYFIKACJI], [FK-TR], F_NR, F_NR_ROZ, 36061 F_NR_ROK, ID_FAKTURY, PROMOCJA, GRZBIET, customerId_Sub, kier_notatka, kier_zatwierdzil, zam_notatka, zablokuj_prowizje, Brutto_Euro, Zaliczka_Brutto, 36062 Zaliczka_Data, Brutto_Euro_Miano, waluta_kurs_z_dnia, waluta_kurs, waluta_Przelicznik, waluta_tabela_nr, wyroznienie_procent, wyroznienie_kwota, 36063 wyroznienie, wyroznienie_exported, logo, logoID, ogl_dzial, ogl_rozdzial, idZamowienia 36064 FROM REKLAMA 36065 WHERE (CustomerID = @param1) AND (idZamowienia IS NULL) AND ([FAKTURA WYSTAWIONO] = 0) AND (YEAR([DATA ZAMÓWIENIA]) = 2008) AND 36066 ([ZATWIERDZONO DO DRUKU] = 1) OR 36067 (CustomerID = @param1) AND (idZamowienia IS NULL) AND ([FAKTURA WYSTAWIONO] = 0) AND (YEAR([DATA ZAMÓWIENIA]) >= 2009)"; 36096 this._commandCollection[3].CommandText = "SELECT R.ReklamaID, R.CustomerID, R.[SYMBOL AKWIZYTORA], R.TYTUŁ, R.TYP, R.[I" + 36097 "D REKLAMY], R.[NICK NAME], R.[DATA ZAMÓWIENIA], R.SZER, R.WYS, \r\n " + 36098 " R.MOD_TYP, R.STRONA, R.[STR NR WT], R.[STR NR PT], R.KROTNOŚĆ, R.ODSTĘP, " + 36099 "R.KOLOR, R.[WSKAZANIE MIEJSCA], R.RABAT, \r\n R.[RABAT WARTOŚ" + 36100 "Ć], R.ZAPŁACONO, R.[ZATWIERDZONO DO DRUKU], R.[DATA ZAPŁATY], R.[SYMBOL POTWIERD" + 36101 "ZENIA], \r\n R.[RODZAJ POTWIERDZENIA], R.[CENA JEDN], R.NETTO" + 36102 ", R.VAT, R.PVAT, R.BRUTTO, R.[PROCENT PROWIZJI], R.PROWIZJA, R.INFO, \r\n " + 36103 " R.[FAKTURA NUMER], R.[FAKTURA ID KONTA], R.[FAKTURA DATA WYSTAWIENI" + 36104 "A], R.[FAKTURA DATA SPRZEDAŻY], R.[FAKTURA TERMIN ZAPŁATY], \r\n " + 36105 " R.[FAKTURA FORMA PŁATNOŚCI], R.[FAKTURA WYSTAWIONO], R.[FAKTURA RODZAJ], R.U" + 36106 "SERID, R.[DATA OSTATNIEJ MODYFIKACJI], R.[FK-TR], \r\n R.F_NR" + 36107 ", R.F_NR_ROZ, R.F_NR_ROK, R.ID_FAKTURY, R.PROMOCJA, R.GRZBIET, R.customerId_Sub," + 36108 " R.kier_notatka, R.kier_zatwierdzil, \r\n R.zam_notatka, R.za" + 36109 "blokuj_prowizje, R.Brutto_Euro, R.Zaliczka_Brutto, R.Zaliczka_Data, R.Brutto_Eur" + 36110 "o_Miano, R.waluta_kurs_z_dnia, R.waluta_kurs, \r\n R.waluta_P" + 36111 "rzelicznik, R.waluta_tabela_nr, R.wyroznienie_procent, R.wyroznienie_kwota, R.wy" + 36112 "roznienie, R.wyroznienie_exported, R.logo, R.logoID, \r\n R.o" + 36113 "gl_dzial, R.ogl_rozdzial, R.idZamowienia, E.Data1Emisji\r\nFROM REKLAMA AS" + 36114 " R LEFT OUTER JOIN\r\n (SELECT ReklamaId, MIN(DataEmi" + 36115 "sji) AS Data1Emisji\r\n FROM EmisjeReklamy\r\n " + 36116 " GROUP BY ReklamaId) AS E ON E.ReklamaId = R.ReklamaID\r" + 36117 "\nWHERE (R.CustomerID = @param1) AND (R.idZamowienia IS NULL) AND (R.[FAKTURA" + 36118 " WYSTAWIONO] = 0) AND (YEAR(R.[DATA ZAMÓWIENIA]) = 2008) AND \r\n " + 36119 " (R.[ZATWIERDZONO DO DRUKU] = 1) OR\r\n (R.CustomerID = @" + 36120 "param1) AND (R.idZamowienia IS NULL) AND (R.[FAKTURA WYSTAWIONO] = 0) AND (YEAR(" + 36121 "R.[DATA ZAMÓWIENIA]) >= 2009)"; 36068 36122 this._commandCollection[3].CommandType = global::System.Data.CommandType.Text; 36069 36123 this._commandCollection[3].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@param1", global::System.Data.SqlDbType.Int, 4, global::System.Data.ParameterDirection.Input, 0, 0, "CustomerID", global::System.Data.DataRowVersion.Current, false, null, "", "", "")); … … 43186 43240 "ka, R.zablokuj_prowizje, R.Brutto_Euro, R.Zaliczka_Brutto, R.Zaliczka_Data, R.Br" + 43187 43241 "utto_Euro_Miano, R.waluta_kurs_z_dnia, R.waluta_kurs, \r\n R." + 43188 "waluta_Przelicznik, R.waluta_tabela_nr, O.OD, O.DO, DATEPART(year, NR.DATA_W) AS" + 43189 " \'rok\', DATEPART(month, NR.DATA_W) AS \'miesiac\', \r\n NR.DATA" + 43190 "_W AS \'1emisja\', A.Symbol AS agencja, (R.[CENA JEDN] - R.[RABAT WARTOŚĆ]) / R.SZ" + 43191 "ER * R.WYS AS [CENA MODUŁU], NM.CENA_MIN, \r\n NM.CENA, K.Fir" + 43192 "stName, R.wyroznienie\r\nFROM AGENCI AS A2 INNER JOIN\r\n " + 43193 " AGENCJE AS A ON A.Id_agencji = A2.ID_AGENCJI RIGHT OUTER JOIN\r\n " + 43194 " REKLAMA AS R ON A2.Symbol = R.[SYMBOL AKWIZYTORA] LEFT OUTER JOIN\r\n " + 43195 " VIEW_REKLAMA_OD_DO AS O ON R.ReklamaID = O.ReklamaID LEFT OUTER" + 43196 " JOIN\r\n NR ON R.TYTUŁ = NR.TYT AND O.OD = NR.NRW LEFT OUTER" + 43197 " JOIN\r\n [NAZWY MODUŁÓW] AS NM ON R.MOD_TYP = NM.MOD_TYP LEF" + 43198 "T OUTER JOIN\r\n KLIENCI AS K ON R.CustomerID = K.CustomerID\r" + 43199 "\nwhere R.idZamowienia=@idZamowienia\r\nORDER BY R.[DATA ZAMÓWIENIA] DESC"; 43242 "waluta_Przelicznik, R.waluta_tabela_nr, O.OD, O.DO, DATEPART(year, E.data1) AS \'" + 43243 "rok\', DATEPART(month, E.data1) AS \'miesiac\', \r\n E.data1 AS " + 43244 "\'1emisja\', A.Symbol AS agencja, (R.[CENA JEDN] - R.[RABAT WARTOŚĆ]) / R.SZER * R" + 43245 ".WYS AS [CENA MODUŁU], NM.CENA_MIN, NM.CENA, \r\n K.FirstName" + 43246 ", R.wyroznienie\r\nFROM AGENCI AS A2 INNER JOIN\r\n AGE" + 43247 "NCJE AS A ON A.Id_agencji = A2.ID_AGENCJI RIGHT OUTER JOIN\r\n " + 43248 " REKLAMA AS R ON A2.Symbol = R.[SYMBOL AKWIZYTORA] LEFT OUTER JOIN\r\n " + 43249 " VIEW_REKLAMA_OD_DO AS O ON R.ReklamaID = O.ReklamaID LEFT OUTER JOIN\r" + 43250 "\n ZAMOWIENIA_1EMISJA_bezFK AS E ON R.idZamowienia = E.idZam" + 43251 "owienia LEFT OUTER JOIN\r\n [NAZWY MODUŁÓW] AS NM ON R.MOD_TY" + 43252 "P = NM.MOD_TYP LEFT OUTER JOIN\r\n KLIENCI AS K ON R.Customer" + 43253 "ID = K.CustomerID\r\nWHERE (R.idZamowienia = @idZamowienia)\r\nORDER BY R.[DATA " + 43254 "ZAMÓWIENIA] DESC"; 43200 43255 this._commandCollection[1].CommandType = global::System.Data.CommandType.Text; 43201 43256 this._commandCollection[1].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@idZamowienia", global::System.Data.SqlDbType.Int, 4, global::System.Data.ParameterDirection.Input, 0, 0, "idZamowienia", global::System.Data.DataRowVersion.Current, false, null, "", "", "")); -
trunk/BazaReklam/REKLAMADataSet.xsd
r347 r349 445 445 <SelectCommand> 446 446 <DbCommand CommandType="Text" ModifiedByUser="True"> 447 <CommandText>SELECT ReklamaID, CustomerID, [SYMBOL AKWIZYTORA], TYTUŁ, TYP, [ID REKLAMY], [NICK NAME], [DATA ZAMÓWIENIA], SZER, WYS, MOD_TYP, STRONA, [STR NR WT], 448 [STR NR PT], KROTNOŚĆ, ODSTĘP, KOLOR, [WSKAZANIE MIEJSCA], RABAT, [RABAT WARTOŚĆ], ZAPŁACONO, [ZATWIERDZONO DO DRUKU], [DATA ZAPŁATY], 449 [SYMBOL POTWIERDZENIA], [RODZAJ POTWIERDZENIA], [CENA JEDN], NETTO, VAT, PVAT, BRUTTO, [PROCENT PROWIZJI], PROWIZJA, INFO, 450 [FAKTURA NUMER], [FAKTURA ID KONTA], [FAKTURA DATA WYSTAWIENIA], [FAKTURA DATA SPRZEDAŻY], [FAKTURA TERMIN ZAPŁATY], 451 [FAKTURA FORMA PŁATNOŚCI], [FAKTURA WYSTAWIONO], [FAKTURA RODZAJ], USERID, [DATA OSTATNIEJ MODYFIKACJI], [FK-TR], F_NR, F_NR_ROZ, 452 F_NR_ROK, ID_FAKTURY, PROMOCJA, GRZBIET, customerId_Sub, kier_notatka, kier_zatwierdzil, zam_notatka, zablokuj_prowizje, Brutto_Euro, Zaliczka_Brutto, 453 Zaliczka_Data, Brutto_Euro_Miano, waluta_kurs_z_dnia, waluta_kurs, waluta_Przelicznik, waluta_tabela_nr, wyroznienie_procent, wyroznienie_kwota, 454 wyroznienie, wyroznienie_exported, logo, logoID, ogl_dzial, ogl_rozdzial, idZamowienia 455 FROM REKLAMA 456 WHERE (CustomerID = @param1) AND (idZamowienia IS NULL) AND ([FAKTURA WYSTAWIONO] = 0) AND (YEAR([DATA ZAMÓWIENIA]) = 2008) AND 457 ([ZATWIERDZONO DO DRUKU] = 1) OR 458 (CustomerID = @param1) AND (idZamowienia IS NULL) AND ([FAKTURA WYSTAWIONO] = 0) AND (YEAR([DATA ZAMÓWIENIA]) >= 2009)</CommandText> 447 <CommandText>SELECT R.ReklamaID, R.CustomerID, R.[SYMBOL AKWIZYTORA], R.TYTUŁ, R.TYP, R.[ID REKLAMY], R.[NICK NAME], R.[DATA ZAMÓWIENIA], R.SZER, R.WYS, 448 R.MOD_TYP, R.STRONA, R.[STR NR WT], R.[STR NR PT], R.KROTNOŚĆ, R.ODSTĘP, R.KOLOR, R.[WSKAZANIE MIEJSCA], R.RABAT, 449 R.[RABAT WARTOŚĆ], R.ZAPŁACONO, R.[ZATWIERDZONO DO DRUKU], R.[DATA ZAPŁATY], R.[SYMBOL POTWIERDZENIA], 450 R.[RODZAJ POTWIERDZENIA], R.[CENA JEDN], R.NETTO, R.VAT, R.PVAT, R.BRUTTO, R.[PROCENT PROWIZJI], R.PROWIZJA, R.INFO, 451 R.[FAKTURA NUMER], R.[FAKTURA ID KONTA], R.[FAKTURA DATA WYSTAWIENIA], R.[FAKTURA DATA SPRZEDAŻY], R.[FAKTURA TERMIN ZAPŁATY], 452 R.[FAKTURA FORMA PŁATNOŚCI], R.[FAKTURA WYSTAWIONO], R.[FAKTURA RODZAJ], R.USERID, R.[DATA OSTATNIEJ MODYFIKACJI], R.[FK-TR], 453 R.F_NR, R.F_NR_ROZ, R.F_NR_ROK, R.ID_FAKTURY, R.PROMOCJA, R.GRZBIET, R.customerId_Sub, R.kier_notatka, R.kier_zatwierdzil, 454 R.zam_notatka, R.zablokuj_prowizje, R.Brutto_Euro, R.Zaliczka_Brutto, R.Zaliczka_Data, R.Brutto_Euro_Miano, R.waluta_kurs_z_dnia, R.waluta_kurs, 455 R.waluta_Przelicznik, R.waluta_tabela_nr, R.wyroznienie_procent, R.wyroznienie_kwota, R.wyroznienie, R.wyroznienie_exported, R.logo, R.logoID, 456 R.ogl_dzial, R.ogl_rozdzial, R.idZamowienia, E.Data1Emisji 457 FROM REKLAMA AS R LEFT OUTER JOIN 458 (SELECT ReklamaId, MIN(DataEmisji) AS Data1Emisji 459 FROM EmisjeReklamy 460 GROUP BY ReklamaId) AS E ON E.ReklamaId = R.ReklamaID 461 WHERE (R.CustomerID = @param1) AND (R.idZamowienia IS NULL) AND (R.[FAKTURA WYSTAWIONO] = 0) AND (YEAR(R.[DATA ZAMÓWIENIA]) = 2008) AND 462 (R.[ZATWIERDZONO DO DRUKU] = 1) OR 463 (R.CustomerID = @param1) AND (R.idZamowienia IS NULL) AND (R.[FAKTURA WYSTAWIONO] = 0) AND (YEAR(R.[DATA ZAMÓWIENIA]) >= 2009)</CommandText> 459 464 <Parameters> 460 465 <Parameter AllowDbNull="True" AutogeneratedName="param1" ColumnName="CustomerID" DataSourceName="BAZA_REKLAM_TEST.dbo.REKLAMA" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@param1" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CustomerID" SourceColumnNullMapping="False" SourceVersion="Current"> … … 2239 2244 R.F_NR, R.F_NR_ROZ, R.F_NR_ROK, R.ID_FAKTURY, R.PROMOCJA, R.GRZBIET, R.customerId_Sub, R.kier_notatka, R.kier_zatwierdzil, 2240 2245 R.zam_notatka, R.zablokuj_prowizje, R.Brutto_Euro, R.Zaliczka_Brutto, R.Zaliczka_Data, R.Brutto_Euro_Miano, R.waluta_kurs_z_dnia, R.waluta_kurs, 2241 R.waluta_Przelicznik, R.waluta_tabela_nr, O.OD, O.DO, DATEPART(year, NR.DATA_W) AS 'rok', DATEPART(month, NR.DATA_W) AS 'miesiac',2242 NR.DATA_W AS '1emisja', A.Symbol AS agencja, (R.[CENA JEDN] - R.[RABAT WARTOŚĆ]) / R.SZER * R.WYS AS [CENA MODUŁU], NM.CENA_MIN,2243 NM.CENA,K.FirstName, R.wyroznienie2246 R.waluta_Przelicznik, R.waluta_tabela_nr, O.OD, O.DO, DATEPART(year, E.data1) AS 'rok', DATEPART(month, E.data1) AS 'miesiac', 2247 E.data1 AS '1emisja', A.Symbol AS agencja, (R.[CENA JEDN] - R.[RABAT WARTOŚĆ]) / R.SZER * R.WYS AS [CENA MODUŁU], NM.CENA_MIN, NM.CENA, 2248 K.FirstName, R.wyroznienie 2244 2249 FROM AGENCI AS A2 INNER JOIN 2245 2250 AGENCJE AS A ON A.Id_agencji = A2.ID_AGENCJI RIGHT OUTER JOIN 2246 2251 REKLAMA AS R ON A2.Symbol = R.[SYMBOL AKWIZYTORA] LEFT OUTER JOIN 2247 2252 VIEW_REKLAMA_OD_DO AS O ON R.ReklamaID = O.ReklamaID LEFT OUTER JOIN 2248 NR ON R.TYTUŁ = NR.TYT AND O.OD = NR.NRWLEFT OUTER JOIN2253 ZAMOWIENIA_1EMISJA_bezFK AS E ON R.idZamowienia = E.idZamowienia LEFT OUTER JOIN 2249 2254 [NAZWY MODUŁÓW] AS NM ON R.MOD_TYP = NM.MOD_TYP LEFT OUTER JOIN 2250 2255 KLIENCI AS K ON R.CustomerID = K.CustomerID 2251 where R.idZamowienia=@idZamowienia 2256 WHERE (R.idZamowienia = @idZamowienia) 2252 2257 ORDER BY R.[DATA ZAMÓWIENIA] DESC</CommandText> 2253 2258 <Parameters> … … 4833 4838 <xs:element name="ogl_rozdzial" msprop:Generator_UserColumnName="ogl_rozdzial" msprop:Generator_ColumnVarNameInTable="columnogl_rozdzial" msprop:Generator_ColumnPropNameInRow="ogl_rozdzial" msprop:Generator_ColumnPropNameInTable="ogl_rozdzialColumn" type="xs:int" minOccurs="0" /> 4834 4839 <xs:element name="idZamowienia" msprop:Generator_UserColumnName="idZamowienia" msprop:Generator_ColumnPropNameInRow="idZamowienia" msprop:Generator_ColumnVarNameInTable="columnidZamowienia" msprop:Generator_ColumnPropNameInTable="idZamowieniaColumn" type="xs:int" minOccurs="0" /> 4840 <xs:element name="Data1Emisji" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Data1Emisji" msprop:Generator_ColumnVarNameInTable="columnData1Emisji" msprop:Generator_ColumnPropNameInRow="Data1Emisji" msprop:Generator_ColumnPropNameInTable="Data1EmisjiColumn" type="xs:dateTime" minOccurs="0" /> 4835 4841 </xs:sequence> 4836 4842 </xs:complexType> -
trunk/BazaReklam/REKLAMADataSet.xss
r347 r349 5 5 the code is regenerated. 6 6 </autogenerated>--> 7 <DiagramLayout xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" ex:showrelationlabel="False" ViewPortX="- 1339" ViewPortY="1521" xmlns:ex="urn:schemas-microsoft-com:xml-msdatasource-layout-extended" xmlns="urn:schemas-microsoft-com:xml-msdatasource-layout">7 <DiagramLayout xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" ex:showrelationlabel="False" ViewPortX="-668" ViewPortY="1276" xmlns:ex="urn:schemas-microsoft-com:xml-msdatasource-layout-extended" xmlns="urn:schemas-microsoft-com:xml-msdatasource-layout"> 8 8 <Shapes> 9 <Shape ID="DesignTable:REKLAMA" ZOrder=" 5" X="-162" Y="35" Height="403" Width="361" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="24" SplitterPosition="254" />10 <Shape ID="DesignTable:UKAZE_SIE_W_NR" ZOrder=" 3" X="332" Y="-23" Height="358" Width="300" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="192" />9 <Shape ID="DesignTable:REKLAMA" ZOrder="1" X="-162" Y="35" Height="403" Width="300" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="24" SplitterPosition="254" /> 10 <Shape ID="DesignTable:UKAZE_SIE_W_NR" ZOrder="4" X="332" Y="-23" Height="358" Width="300" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="192" /> 11 11 <Shape ID="DesignTable:KLIENCI" ZOrder="33" X="-327" Y="520" Height="343" Width="300" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="22" OldDataTableHeight="0" SplitterPosition="254" /> 12 <Shape ID="DesignTable:REKLAMA_STRONA" ZOrder=" 2" X="241" Y="352" Height="188" Width="286" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="124" />12 <Shape ID="DesignTable:REKLAMA_STRONA" ZOrder="3" X="241" Y="352" Height="188" Width="286" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="124" /> 13 13 <Shape ID="DesignTable:KLIENCI_OSOBY_DO_KONTAKTU" ZOrder="20" X="-990" Y="809" Height="207" Width="300" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="143" /> 14 <Shape ID="DesignTable:PRODUKCJA" ZOrder=" 4" X="51" Y="542" Height="343" Width="286" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="22" OldDataTableHeight="0" SplitterPosition="254" />14 <Shape ID="DesignTable:PRODUKCJA" ZOrder="5" X="51" Y="542" Height="343" Width="286" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="22" OldDataTableHeight="0" SplitterPosition="254" /> 15 15 <Shape ID="DesignTable:FAKTURY" ZOrder="26" X="-588" Y="-330" Height="394" Width="300" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="279" /> 16 16 <Shape ID="DesignTable:FAKTURA_DETAILS" ZOrder="7" X="-194" Y="-351" Height="369" Width="300" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="254" /> … … 35 35 <Shape ID="DesignTable:zmianyEmisji" ZOrder="35" X="701" Y="81" Height="172" Width="220" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="121" /> 36 36 <Shape ID="DesignTable:zamowienia" ZOrder="16" X="-675" Y="159" Height="309" Width="300" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="228" /> 37 <Shape ID="DesignTable:DatyWydan" ZOrder=" 1" X="701" Y="340" Height="241" Width="221" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="126" />37 <Shape ID="DesignTable:DatyWydan" ZOrder="2" X="701" Y="340" Height="241" Width="221" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="126" /> 38 38 <Shape ID="DesignTable:VIEW_ZESTAWIENIE_ZAMOWIEN_NOWE" ZOrder="15" X="-1298" Y="2210" Height="173" Width="245" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="126" /> 39 39 <Shape ID="DesignTable:Wplaty" ZOrder="12" X="-1041" Y="-202" Height="258" Width="268" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="177" /> … … 82 82 <RoutePoints> 83 83 <Point> 84 <X>1 99</X>84 <X>138</X> 85 85 <Y>384</Y> 86 86 </Point> … … 234 234 <RoutePoints> 235 235 <Point> 236 <X>1 99</X>236 <X>138</X> 237 237 <Y>105</Y> 238 238 </Point> -
trunk/BazaReklam/ZamowieniaForm.Designer.cs
r102 r349 36 36 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle5 = new System.Windows.Forms.DataGridViewCellStyle(); 37 37 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle6 = new System.Windows.Forms.DataGridViewCellStyle(); 38 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle7 = new System.Windows.Forms.DataGridViewCellStyle();39 38 System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(ZamowieniaForm)); 40 39 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle8 = new System.Windows.Forms.DataGridViewCellStyle(); 40 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle7 = new System.Windows.Forms.DataGridViewCellStyle(); 41 41 this.zamowieniaDataGridView = new System.Windows.Forms.DataGridView(); 42 42 this.dataGridViewCheckBoxColumn1 = new System.Windows.Forms.DataGridViewCheckBoxColumn(); … … 56 56 this.rEKLAMABindingSource = new System.Windows.Forms.BindingSource(this.components); 57 57 this.rEKLAMADataGridView1 = new System.Windows.Forms.DataGridView(); 58 this.dataGridViewTextBoxColumn72 = new System.Windows.Forms.DataGridViewTextBoxColumn();59 this.DATA_ZAMOWIENIA = new System.Windows.Forms.DataGridViewTextBoxColumn();60 this.dataGridViewTextBoxColumn1 = new System.Windows.Forms.DataGridViewTextBoxColumn();61 this.dataGridViewTextBoxColumn90 = new System.Windows.Forms.DataGridViewTextBoxColumn();62 this.dataGridViewTextBoxColumn43 = new System.Windows.Forms.DataGridViewTextBoxColumn();63 this.dataGridViewTextBoxColumn44 = new System.Windows.Forms.DataGridViewTextBoxColumn();64 this.ZATWIERDZONO_DO_DRUKU2 = new System.Windows.Forms.DataGridViewCheckBoxColumn();65 58 this.rEKLAMABindingSource1 = new System.Windows.Forms.BindingSource(this.components); 66 59 this.dodajButton = new System.Windows.Forms.Button(); … … 102 95 this.KlientLabel = new System.Windows.Forms.Label(); 103 96 this.errorProvider1 = new System.Windows.Forms.ErrorProvider(this.components); 97 this.dataGridViewTextBoxColumn72 = new System.Windows.Forms.DataGridViewTextBoxColumn(); 98 this.Data1Emisji = new System.Windows.Forms.DataGridViewTextBoxColumn(); 99 this.dataGridViewTextBoxColumn1 = new System.Windows.Forms.DataGridViewTextBoxColumn(); 100 this.dataGridViewTextBoxColumn90 = new System.Windows.Forms.DataGridViewTextBoxColumn(); 101 this.dataGridViewTextBoxColumn43 = new System.Windows.Forms.DataGridViewTextBoxColumn(); 102 this.dataGridViewTextBoxColumn44 = new System.Windows.Forms.DataGridViewTextBoxColumn(); 103 this.ZATWIERDZONO_DO_DRUKU2 = new System.Windows.Forms.DataGridViewCheckBoxColumn(); 104 104 ((System.ComponentModel.ISupportInitialize)(this.zamowieniaDataGridView)).BeginInit(); 105 105 ((System.ComponentModel.ISupportInitialize)(this.zamowieniaBindingSource)).BeginInit(); … … 306 306 this.rEKLAMADataGridView1.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] { 307 307 this.dataGridViewTextBoxColumn72, 308 this.D ATA_ZAMOWIENIA,308 this.Data1Emisji, 309 309 this.dataGridViewTextBoxColumn1, 310 310 this.dataGridViewTextBoxColumn90, … … 321 321 this.rEKLAMADataGridView1.Size = new System.Drawing.Size(401, 167); 322 322 this.rEKLAMADataGridView1.TabIndex = 2; 323 //324 // dataGridViewTextBoxColumn72325 //326 this.dataGridViewTextBoxColumn72.DataPropertyName = "ID REKLAMY";327 this.dataGridViewTextBoxColumn72.HeaderText = "Symbol";328 this.dataGridViewTextBoxColumn72.Name = "dataGridViewTextBoxColumn72";329 this.dataGridViewTextBoxColumn72.ReadOnly = true;330 //331 // DATA_ZAMOWIENIA332 //333 this.DATA_ZAMOWIENIA.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None;334 this.DATA_ZAMOWIENIA.DataPropertyName = "DATA ZAMÓWIENIA";335 this.DATA_ZAMOWIENIA.HeaderText = "Data zam.";336 this.DATA_ZAMOWIENIA.Name = "DATA_ZAMOWIENIA";337 this.DATA_ZAMOWIENIA.ReadOnly = true;338 this.DATA_ZAMOWIENIA.Width = 75;339 //340 // dataGridViewTextBoxColumn1341 //342 this.dataGridViewTextBoxColumn1.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None;343 this.dataGridViewTextBoxColumn1.DataPropertyName = "TYP";344 this.dataGridViewTextBoxColumn1.HeaderText = "TYP";345 this.dataGridViewTextBoxColumn1.Name = "dataGridViewTextBoxColumn1";346 this.dataGridViewTextBoxColumn1.ReadOnly = true;347 this.dataGridViewTextBoxColumn1.Width = 50;348 //349 // dataGridViewTextBoxColumn90350 //351 this.dataGridViewTextBoxColumn90.DataPropertyName = "NETTO";352 this.dataGridViewTextBoxColumn90.HeaderText = "NETTO";353 this.dataGridViewTextBoxColumn90.Name = "dataGridViewTextBoxColumn90";354 this.dataGridViewTextBoxColumn90.ReadOnly = true;355 //356 // dataGridViewTextBoxColumn43357 //358 this.dataGridViewTextBoxColumn43.DataPropertyName = "VAT";359 dataGridViewCellStyle7.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;360 dataGridViewCellStyle7.Format = "P";361 this.dataGridViewTextBoxColumn43.DefaultCellStyle = dataGridViewCellStyle7;362 this.dataGridViewTextBoxColumn43.HeaderText = "VAT";363 this.dataGridViewTextBoxColumn43.Name = "dataGridViewTextBoxColumn43";364 this.dataGridViewTextBoxColumn43.ReadOnly = true;365 //366 // dataGridViewTextBoxColumn44367 //368 this.dataGridViewTextBoxColumn44.DataPropertyName = "Brutto_Euro_Miano";369 this.dataGridViewTextBoxColumn44.HeaderText = "Waluta";370 this.dataGridViewTextBoxColumn44.Name = "dataGridViewTextBoxColumn44";371 this.dataGridViewTextBoxColumn44.ReadOnly = true;372 //373 // ZATWIERDZONO_DO_DRUKU2374 //375 this.ZATWIERDZONO_DO_DRUKU2.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None;376 this.ZATWIERDZONO_DO_DRUKU2.DataPropertyName = "ZATWIERDZONO DO DRUKU";377 this.ZATWIERDZONO_DO_DRUKU2.HeaderText = "ZD";378 this.ZATWIERDZONO_DO_DRUKU2.Name = "ZATWIERDZONO_DO_DRUKU2";379 this.ZATWIERDZONO_DO_DRUKU2.ReadOnly = true;380 this.ZATWIERDZONO_DO_DRUKU2.Width = 25;381 323 // 382 324 // rEKLAMABindingSource1 … … 773 715 // 774 716 this.errorProvider1.ContainerControl = this; 717 // 718 // dataGridViewTextBoxColumn72 719 // 720 this.dataGridViewTextBoxColumn72.DataPropertyName = "ID REKLAMY"; 721 this.dataGridViewTextBoxColumn72.HeaderText = "Symbol"; 722 this.dataGridViewTextBoxColumn72.Name = "dataGridViewTextBoxColumn72"; 723 this.dataGridViewTextBoxColumn72.ReadOnly = true; 724 // 725 // Data1Emisji 726 // 727 this.Data1Emisji.DataPropertyName = "Data1Emisji"; 728 this.Data1Emisji.HeaderText = "1 Emisja"; 729 this.Data1Emisji.Name = "Data1Emisji"; 730 this.Data1Emisji.ReadOnly = true; 731 // 732 // dataGridViewTextBoxColumn1 733 // 734 this.dataGridViewTextBoxColumn1.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; 735 this.dataGridViewTextBoxColumn1.DataPropertyName = "TYP"; 736 this.dataGridViewTextBoxColumn1.HeaderText = "TYP"; 737 this.dataGridViewTextBoxColumn1.Name = "dataGridViewTextBoxColumn1"; 738 this.dataGridViewTextBoxColumn1.ReadOnly = true; 739 this.dataGridViewTextBoxColumn1.Width = 50; 740 // 741 // dataGridViewTextBoxColumn90 742 // 743 this.dataGridViewTextBoxColumn90.DataPropertyName = "NETTO"; 744 this.dataGridViewTextBoxColumn90.HeaderText = "NETTO"; 745 this.dataGridViewTextBoxColumn90.Name = "dataGridViewTextBoxColumn90"; 746 this.dataGridViewTextBoxColumn90.ReadOnly = true; 747 // 748 // dataGridViewTextBoxColumn43 749 // 750 this.dataGridViewTextBoxColumn43.DataPropertyName = "VAT"; 751 dataGridViewCellStyle7.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; 752 dataGridViewCellStyle7.Format = "P"; 753 this.dataGridViewTextBoxColumn43.DefaultCellStyle = dataGridViewCellStyle7; 754 this.dataGridViewTextBoxColumn43.HeaderText = "VAT"; 755 this.dataGridViewTextBoxColumn43.Name = "dataGridViewTextBoxColumn43"; 756 this.dataGridViewTextBoxColumn43.ReadOnly = true; 757 // 758 // dataGridViewTextBoxColumn44 759 // 760 this.dataGridViewTextBoxColumn44.DataPropertyName = "Brutto_Euro_Miano"; 761 this.dataGridViewTextBoxColumn44.HeaderText = "Waluta"; 762 this.dataGridViewTextBoxColumn44.Name = "dataGridViewTextBoxColumn44"; 763 this.dataGridViewTextBoxColumn44.ReadOnly = true; 764 // 765 // ZATWIERDZONO_DO_DRUKU2 766 // 767 this.ZATWIERDZONO_DO_DRUKU2.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; 768 this.ZATWIERDZONO_DO_DRUKU2.DataPropertyName = "ZATWIERDZONO DO DRUKU"; 769 this.ZATWIERDZONO_DO_DRUKU2.HeaderText = "ZD"; 770 this.ZATWIERDZONO_DO_DRUKU2.Name = "ZATWIERDZONO_DO_DRUKU2"; 771 this.ZATWIERDZONO_DO_DRUKU2.ReadOnly = true; 772 this.ZATWIERDZONO_DO_DRUKU2.Width = 25; 775 773 // 776 774 // ZamowieniaForm … … 847 845 private System.Windows.Forms.DataGridViewTextBoxColumn Brutto_Euro_Miano; 848 846 private System.Windows.Forms.DataGridViewCheckBoxColumn ZATWIERDZONO_DO_DRUKU; 849 private System.Windows.Forms.DataGridViewTextBoxColumn dataGridViewTextBoxColumn72;850 private System.Windows.Forms.DataGridViewTextBoxColumn DATA_ZAMOWIENIA;851 private System.Windows.Forms.DataGridViewTextBoxColumn dataGridViewTextBoxColumn1;852 private System.Windows.Forms.DataGridViewTextBoxColumn dataGridViewTextBoxColumn90;853 private System.Windows.Forms.DataGridViewTextBoxColumn dataGridViewTextBoxColumn43;854 private System.Windows.Forms.DataGridViewTextBoxColumn dataGridViewTextBoxColumn44;855 private System.Windows.Forms.DataGridViewCheckBoxColumn ZATWIERDZONO_DO_DRUKU2;856 847 private System.Windows.Forms.Button usunFaktureButton; 857 848 private System.Windows.Forms.DateTimePicker dtpZmianaDaty; … … 874 865 private System.Windows.Forms.Button proformaButton; 875 866 private System.Windows.Forms.ErrorProvider errorProvider1; 867 private System.Windows.Forms.DataGridViewTextBoxColumn dataGridViewTextBoxColumn72; 868 private System.Windows.Forms.DataGridViewTextBoxColumn Data1Emisji; 869 private System.Windows.Forms.DataGridViewTextBoxColumn dataGridViewTextBoxColumn1; 870 private System.Windows.Forms.DataGridViewTextBoxColumn dataGridViewTextBoxColumn90; 871 private System.Windows.Forms.DataGridViewTextBoxColumn dataGridViewTextBoxColumn43; 872 private System.Windows.Forms.DataGridViewTextBoxColumn dataGridViewTextBoxColumn44; 873 private System.Windows.Forms.DataGridViewCheckBoxColumn ZATWIERDZONO_DO_DRUKU2; 876 874 } 877 875 } -
trunk/BazaReklam/ZamowieniaForm.resx
r102 r349 151 151 <value>431, 54</value> 152 152 </metadata> 153 <metadata name="D ATA_ZAMOWIENIA.UserAddedColumn" type="System.Boolean, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">153 <metadata name="Data1Emisji.UserAddedColumn" type="System.Boolean, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> 154 154 <value>True</value> 155 155 </metadata> -
trunk/BazaReklam/ZestawienieZamowienForm.Designer.cs
r226 r349 33 33 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle1 = new System.Windows.Forms.DataGridViewCellStyle(); 34 34 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle2 = new System.Windows.Forms.DataGridViewCellStyle(); 35 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle14 = new System.Windows.Forms.DataGridViewCellStyle();36 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle15 = new System.Windows.Forms.DataGridViewCellStyle();37 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle16 = new System.Windows.Forms.DataGridViewCellStyle();38 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle17 = new System.Windows.Forms.DataGridViewCellStyle();39 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle18 = new System.Windows.Forms.DataGridViewCellStyle();40 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle19 = new System.Windows.Forms.DataGridViewCellStyle();41 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle20 = new System.Windows.Forms.DataGridViewCellStyle();42 35 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle3 = new System.Windows.Forms.DataGridViewCellStyle(); 43 36 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle4 = new System.Windows.Forms.DataGridViewCellStyle(); … … 51 44 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle12 = new System.Windows.Forms.DataGridViewCellStyle(); 52 45 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle13 = new System.Windows.Forms.DataGridViewCellStyle(); 46 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle14 = new System.Windows.Forms.DataGridViewCellStyle(); 47 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle15 = new System.Windows.Forms.DataGridViewCellStyle(); 48 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle16 = new System.Windows.Forms.DataGridViewCellStyle(); 49 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle17 = new System.Windows.Forms.DataGridViewCellStyle(); 50 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle18 = new System.Windows.Forms.DataGridViewCellStyle(); 51 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle19 = new System.Windows.Forms.DataGridViewCellStyle(); 52 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle20 = new System.Windows.Forms.DataGridViewCellStyle(); 53 53 this.bindingNavigator1 = new System.Windows.Forms.BindingNavigator(this.components); 54 54 this.VIEW_ZESTAWIENIE_ZAMOWIEN_NOWEBindingSource = new System.Windows.Forms.BindingSource(this.components); … … 90 90 this.splitContainer2 = new System.Windows.Forms.SplitContainer(); 91 91 this.fakturyDataGridView = new System.Windows.Forms.DataGridView(); 92 this.agencja = new System.Windows.Forms.DataGridViewTextBoxColumn(); 93 this.agent = new System.Windows.Forms.DataGridViewTextBoxColumn(); 94 this.rokZamowienia = new System.Windows.Forms.DataGridViewTextBoxColumn(); 95 this.nrZamowieniaExt = new System.Windows.Forms.DataGridViewTextBoxColumn(); 96 this.iloscReklam = new System.Windows.Forms.DataGridViewTextBoxColumn(); 97 this.data_od = new System.Windows.Forms.DataGridViewTextBoxColumn(); 98 this.data_od_bez_FK = new System.Windows.Forms.DataGridViewTextBoxColumn(); 99 this.wartoscNetto = new System.Windows.Forms.DataGridViewTextBoxColumn(); 100 this.kwotaWalutaBrutto = new System.Windows.Forms.DataGridViewTextBoxColumn(); 101 this.bruttoEuroMianoDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn(); 102 this.nettoZafakturowane = new System.Windows.Forms.DataGridViewTextBoxColumn(); 103 this.DoZafakturowania = new System.Windows.Forms.DataGridViewTextBoxColumn(); 92 104 this.reklamyZestawienieDataGridView = new System.Windows.Forms.DataGridView(); 105 this.reklamyZestawienieBindingSource = new System.Windows.Forms.BindingSource(this.components); 106 this.toolStrip1 = new System.Windows.Forms.ToolStrip(); 107 this.zamToolStripButton = new System.Windows.Forms.ToolStripButton(); 108 this.panel = new System.Windows.Forms.Panel(); 109 this.label2 = new System.Windows.Forms.Label(); 110 this.label1 = new System.Windows.Forms.Label(); 111 this.wartoscNettoNiezafakturowanaTextBox = new System.Windows.Forms.TextBox(); 112 this.wartoscNettoZafakturowanaTextBox = new System.Windows.Forms.TextBox(); 113 this.reklamaTableAdapter = new Baza_Reklam.REKLAMADataSetTableAdapters.REKLAMATableAdapter(); 114 this.VIEW_ZESTAWIENIE_ZAMOWIEN_NOWETableAdapter = new Baza_Reklam.REKLAMADataSetTableAdapters.VIEW_ZESTAWIENIE_ZAMOWIEN_NOWETableAdapter(); 115 this.reklamyZestawienieTableAdapter = new Baza_Reklam.REKLAMADataSetTableAdapters.ReklamyZestawienieTableAdapter(); 93 116 this.dataGridViewTextBoxColumn3 = new System.Windows.Forms.DataGridViewTextBoxColumn(); 94 117 this.dataGridViewTextBoxColumn6 = new System.Windows.Forms.DataGridViewTextBoxColumn(); … … 108 131 this.dataGridViewCheckBoxColumn4 = new System.Windows.Forms.DataGridViewCheckBoxColumn(); 109 132 this.wyroznienie = new System.Windows.Forms.DataGridViewCheckBoxColumn(); 110 this.reklamyZestawienieBindingSource = new System.Windows.Forms.BindingSource(this.components);111 this.toolStrip1 = new System.Windows.Forms.ToolStrip();112 this.zamToolStripButton = new System.Windows.Forms.ToolStripButton();113 this.panel = new System.Windows.Forms.Panel();114 this.label2 = new System.Windows.Forms.Label();115 this.label1 = new System.Windows.Forms.Label();116 this.wartoscNettoNiezafakturowanaTextBox = new System.Windows.Forms.TextBox();117 this.wartoscNettoZafakturowanaTextBox = new System.Windows.Forms.TextBox();118 this.reklamaTableAdapter = new Baza_Reklam.REKLAMADataSetTableAdapters.REKLAMATableAdapter();119 this.VIEW_ZESTAWIENIE_ZAMOWIEN_NOWETableAdapter = new Baza_Reklam.REKLAMADataSetTableAdapters.VIEW_ZESTAWIENIE_ZAMOWIEN_NOWETableAdapter();120 this.reklamyZestawienieTableAdapter = new Baza_Reklam.REKLAMADataSetTableAdapters.ReklamyZestawienieTableAdapter();121 this.agencja = new System.Windows.Forms.DataGridViewTextBoxColumn();122 this.agent = new System.Windows.Forms.DataGridViewTextBoxColumn();123 this.rokZamowienia = new System.Windows.Forms.DataGridViewTextBoxColumn();124 this.nrZamowieniaExt = new System.Windows.Forms.DataGridViewTextBoxColumn();125 this.iloscReklam = new System.Windows.Forms.DataGridViewTextBoxColumn();126 this.data_od = new System.Windows.Forms.DataGridViewTextBoxColumn();127 this.data_od_bez_FK = new System.Windows.Forms.DataGridViewTextBoxColumn();128 this.wartoscNetto = new System.Windows.Forms.DataGridViewTextBoxColumn();129 this.kwotaWalutaBrutto = new System.Windows.Forms.DataGridViewTextBoxColumn();130 this.bruttoEuroMianoDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();131 this.nettoZafakturowane = new System.Windows.Forms.DataGridViewTextBoxColumn();132 this.DoZafakturowania = new System.Windows.Forms.DataGridViewTextBoxColumn();133 133 ((System.ComponentModel.ISupportInitialize)(this.bindingNavigator1)).BeginInit(); 134 134 this.bindingNavigator1.SuspendLayout(); … … 550 550 this.fakturyDataGridView.DataBindingComplete += new System.Windows.Forms.DataGridViewBindingCompleteEventHandler(this.fakturyDataGridView_DataBindingComplete); 551 551 // 552 // agencja 553 // 554 this.agencja.DataPropertyName = "agencja"; 555 dataGridViewCellStyle3.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; 556 this.agencja.DefaultCellStyle = dataGridViewCellStyle3; 557 this.agencja.HeaderText = "Agencja"; 558 this.agencja.Name = "agencja"; 559 this.agencja.ReadOnly = true; 560 this.agencja.Width = 71; 561 // 562 // agent 563 // 564 this.agent.DataPropertyName = "agent"; 565 dataGridViewCellStyle4.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; 566 this.agent.DefaultCellStyle = dataGridViewCellStyle4; 567 this.agent.HeaderText = "Agent"; 568 this.agent.Name = "agent"; 569 this.agent.ReadOnly = true; 570 this.agent.Width = 60; 571 // 572 // rokZamowienia 573 // 574 this.rokZamowienia.DataPropertyName = "rokZamowienia"; 575 dataGridViewCellStyle5.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; 576 this.rokZamowienia.DefaultCellStyle = dataGridViewCellStyle5; 577 this.rokZamowienia.HeaderText = "Rok"; 578 this.rokZamowienia.Name = "rokZamowienia"; 579 this.rokZamowienia.ReadOnly = true; 580 this.rokZamowienia.Width = 52; 581 // 582 // nrZamowieniaExt 583 // 584 this.nrZamowieniaExt.DataPropertyName = "nrZamowieniaExt"; 585 this.nrZamowieniaExt.HeaderText = "Nr zamówienia"; 586 this.nrZamowieniaExt.Name = "nrZamowieniaExt"; 587 this.nrZamowieniaExt.ReadOnly = true; 588 this.nrZamowieniaExt.Width = 93; 589 // 590 // iloscReklam 591 // 592 this.iloscReklam.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; 593 this.iloscReklam.DataPropertyName = "iloscReklam"; 594 dataGridViewCellStyle6.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; 595 this.iloscReklam.DefaultCellStyle = dataGridViewCellStyle6; 596 this.iloscReklam.HeaderText = "# rek"; 597 this.iloscReklam.Name = "iloscReklam"; 598 this.iloscReklam.ReadOnly = true; 599 this.iloscReklam.Width = 40; 600 // 601 // data_od 602 // 603 this.data_od.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; 604 this.data_od.DataPropertyName = "data_od"; 605 dataGridViewCellStyle7.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; 606 dataGridViewCellStyle7.Format = "d"; 607 this.data_od.DefaultCellStyle = dataGridViewCellStyle7; 608 this.data_od.HeaderText = "Data 1 em"; 609 this.data_od.Name = "data_od"; 610 this.data_od.ReadOnly = true; 611 this.data_od.Width = 80; 612 // 613 // data_od_bez_FK 614 // 615 this.data_od_bez_FK.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; 616 this.data_od_bez_FK.DataPropertyName = "data_od_bez_FK"; 617 dataGridViewCellStyle8.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; 618 this.data_od_bez_FK.DefaultCellStyle = dataGridViewCellStyle8; 619 this.data_od_bez_FK.HeaderText = "Data 1 em bez FV"; 620 this.data_od_bez_FK.Name = "data_od_bez_FK"; 621 this.data_od_bez_FK.ReadOnly = true; 622 this.data_od_bez_FK.Width = 80; 623 // 624 // wartoscNetto 625 // 626 this.wartoscNetto.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; 627 this.wartoscNetto.DataPropertyName = "wartoscNetto"; 628 dataGridViewCellStyle9.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight; 629 dataGridViewCellStyle9.Format = "C2"; 630 this.wartoscNetto.DefaultCellStyle = dataGridViewCellStyle9; 631 this.wartoscNetto.HeaderText = "Netto"; 632 this.wartoscNetto.Name = "wartoscNetto"; 633 this.wartoscNetto.ReadOnly = true; 634 this.wartoscNetto.Width = 110; 635 // 636 // kwotaWalutaBrutto 637 // 638 this.kwotaWalutaBrutto.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; 639 this.kwotaWalutaBrutto.DataPropertyName = "kwotaWalutaBrutto"; 640 dataGridViewCellStyle10.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight; 641 dataGridViewCellStyle10.Format = "N2"; 642 dataGridViewCellStyle10.NullValue = null; 643 this.kwotaWalutaBrutto.DefaultCellStyle = dataGridViewCellStyle10; 644 this.kwotaWalutaBrutto.HeaderText = "Waluta - brutto zamówienia"; 645 this.kwotaWalutaBrutto.Name = "kwotaWalutaBrutto"; 646 this.kwotaWalutaBrutto.ReadOnly = true; 647 this.kwotaWalutaBrutto.Width = 110; 648 // 649 // bruttoEuroMianoDataGridViewTextBoxColumn 650 // 651 this.bruttoEuroMianoDataGridViewTextBoxColumn.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; 652 this.bruttoEuroMianoDataGridViewTextBoxColumn.DataPropertyName = "Brutto_Euro_Miano"; 653 dataGridViewCellStyle11.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; 654 this.bruttoEuroMianoDataGridViewTextBoxColumn.DefaultCellStyle = dataGridViewCellStyle11; 655 this.bruttoEuroMianoDataGridViewTextBoxColumn.HeaderText = "W"; 656 this.bruttoEuroMianoDataGridViewTextBoxColumn.Name = "bruttoEuroMianoDataGridViewTextBoxColumn"; 657 this.bruttoEuroMianoDataGridViewTextBoxColumn.ReadOnly = true; 658 this.bruttoEuroMianoDataGridViewTextBoxColumn.Width = 35; 659 // 660 // nettoZafakturowane 661 // 662 this.nettoZafakturowane.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; 663 this.nettoZafakturowane.DataPropertyName = "nettoZafakturowane"; 664 dataGridViewCellStyle12.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight; 665 dataGridViewCellStyle12.Format = "C2"; 666 this.nettoZafakturowane.DefaultCellStyle = dataGridViewCellStyle12; 667 this.nettoZafakturowane.HeaderText = "Wartoæ netto FV"; 668 this.nettoZafakturowane.Name = "nettoZafakturowane"; 669 this.nettoZafakturowane.ReadOnly = true; 670 this.nettoZafakturowane.Width = 110; 671 // 672 // DoZafakturowania 673 // 674 this.DoZafakturowania.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; 675 this.DoZafakturowania.DataPropertyName = "DoZafakturowania"; 676 dataGridViewCellStyle13.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight; 677 dataGridViewCellStyle13.Format = "N2"; 678 dataGridViewCellStyle13.NullValue = null; 679 this.DoZafakturowania.DefaultCellStyle = dataGridViewCellStyle13; 680 this.DoZafakturowania.HeaderText = "Wartoæ niezafakturowana"; 681 this.DoZafakturowania.Name = "DoZafakturowania"; 682 this.DoZafakturowania.ReadOnly = true; 683 this.DoZafakturowania.Width = 110; 684 // 552 685 // reklamyZestawienieDataGridView 553 686 // … … 584 717 this.reklamyZestawienieDataGridView.TabIndex = 1; 585 718 // 719 // reklamyZestawienieBindingSource 720 // 721 this.reklamyZestawienieBindingSource.DataMember = "ReklamyZestawienie"; 722 this.reklamyZestawienieBindingSource.DataSource = this.rEKLAMADataSet; 723 // 724 // toolStrip1 725 // 726 this.toolStrip1.ImageScalingSize = new System.Drawing.Size(24, 24); 727 this.toolStrip1.Items.AddRange(new System.Windows.Forms.ToolStripItem[] { 728 this.zamToolStripButton}); 729 this.toolStrip1.Location = new System.Drawing.Point(0, 0); 730 this.toolStrip1.Name = "toolStrip1"; 731 this.toolStrip1.Size = new System.Drawing.Size(812, 31); 732 this.toolStrip1.TabIndex = 0; 733 this.toolStrip1.Text = "reklamaToolStrip"; 734 // 735 // zamToolStripButton 736 // 737 this.zamToolStripButton.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image; 738 this.zamToolStripButton.Image = ((System.Drawing.Image)(resources.GetObject("zamToolStripButton.Image"))); 739 this.zamToolStripButton.ImageTransparentColor = System.Drawing.Color.Magenta; 740 this.zamToolStripButton.Name = "zamToolStripButton"; 741 this.zamToolStripButton.Size = new System.Drawing.Size(28, 28); 742 this.zamToolStripButton.Text = "Zamówienie"; 743 this.zamToolStripButton.Click += new System.EventHandler(this.zamToolStripButton_Click); 744 // 745 // panel 746 // 747 this.panel.Controls.Add(this.label2); 748 this.panel.Controls.Add(this.label1); 749 this.panel.Controls.Add(this.wartoscNettoNiezafakturowanaTextBox); 750 this.panel.Controls.Add(this.wartoscNettoZafakturowanaTextBox); 751 this.panel.Dock = System.Windows.Forms.DockStyle.Bottom; 752 this.panel.Location = new System.Drawing.Point(0, 625); 753 this.panel.Name = "panel"; 754 this.panel.Size = new System.Drawing.Size(979, 39); 755 this.panel.TabIndex = 4; 756 // 757 // label2 758 // 759 this.label2.AutoSize = true; 760 this.label2.Location = new System.Drawing.Point(672, 17); 761 this.label2.Name = "label2"; 762 this.label2.Size = new System.Drawing.Size(164, 13); 763 this.label2.TabIndex = 3; 764 this.label2.Text = "Wartoæ netto niezafakturowana:"; 765 // 766 // label1 767 // 768 this.label1.AutoSize = true; 769 this.label1.Location = new System.Drawing.Point(365, 17); 770 this.label1.Name = "label1"; 771 this.label1.Size = new System.Drawing.Size(150, 13); 772 this.label1.TabIndex = 2; 773 this.label1.Text = "Wartoæ netto zafakturowana:"; 774 // 775 // wartoscNettoNiezafakturowanaTextBox 776 // 777 this.wartoscNettoNiezafakturowanaTextBox.BackColor = System.Drawing.Color.White; 778 this.wartoscNettoNiezafakturowanaTextBox.Location = new System.Drawing.Point(842, 10); 779 this.wartoscNettoNiezafakturowanaTextBox.Name = "wartoscNettoNiezafakturowanaTextBox"; 780 this.wartoscNettoNiezafakturowanaTextBox.ReadOnly = true; 781 this.wartoscNettoNiezafakturowanaTextBox.Size = new System.Drawing.Size(125, 20); 782 this.wartoscNettoNiezafakturowanaTextBox.TabIndex = 1; 783 this.wartoscNettoNiezafakturowanaTextBox.TextAlign = System.Windows.Forms.HorizontalAlignment.Right; 784 // 785 // wartoscNettoZafakturowanaTextBox 786 // 787 this.wartoscNettoZafakturowanaTextBox.BackColor = System.Drawing.Color.White; 788 this.wartoscNettoZafakturowanaTextBox.Location = new System.Drawing.Point(521, 10); 789 this.wartoscNettoZafakturowanaTextBox.Name = "wartoscNettoZafakturowanaTextBox"; 790 this.wartoscNettoZafakturowanaTextBox.ReadOnly = true; 791 this.wartoscNettoZafakturowanaTextBox.Size = new System.Drawing.Size(116, 20); 792 this.wartoscNettoZafakturowanaTextBox.TabIndex = 0; 793 this.wartoscNettoZafakturowanaTextBox.TextAlign = System.Windows.Forms.HorizontalAlignment.Right; 794 // 795 // reklamaTableAdapter 796 // 797 this.reklamaTableAdapter.ClearBeforeFill = true; 798 // 799 // VIEW_ZESTAWIENIE_ZAMOWIEN_NOWETableAdapter 800 // 801 this.VIEW_ZESTAWIENIE_ZAMOWIEN_NOWETableAdapter.ClearBeforeFill = true; 802 // 803 // reklamyZestawienieTableAdapter 804 // 805 this.reklamyZestawienieTableAdapter.ClearBeforeFill = true; 806 // 586 807 // dataGridViewTextBoxColumn3 587 808 // … … 623 844 // 624 845 this.dataGridViewTextBoxColumn8.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; 625 this.dataGridViewTextBoxColumn8.DataPropertyName = " DATA ZAMÓWIENIA";846 this.dataGridViewTextBoxColumn8.DataPropertyName = "1emisja"; 626 847 dataGridViewCellStyle14.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; 627 848 dataGridViewCellStyle14.Format = "d"; 628 849 this.dataGridViewTextBoxColumn8.DefaultCellStyle = dataGridViewCellStyle14; 629 this.dataGridViewTextBoxColumn8.HeaderText = " Data zam.";850 this.dataGridViewTextBoxColumn8.HeaderText = "1 emisja"; 630 851 this.dataGridViewTextBoxColumn8.Name = "dataGridViewTextBoxColumn8"; 631 852 this.dataGridViewTextBoxColumn8.ReadOnly = true; … … 758 979 this.wyroznienie.ReadOnly = true; 759 980 this.wyroznienie.Width = 30; 760 //761 // reklamyZestawienieBindingSource762 //763 this.reklamyZestawienieBindingSource.DataMember = "ReklamyZestawienie";764 this.reklamyZestawienieBindingSource.DataSource = this.rEKLAMADataSet;765 //766 // toolStrip1767 //768 this.toolStrip1.ImageScalingSize = new System.Drawing.Size(24, 24);769 this.toolStrip1.Items.AddRange(new System.Windows.Forms.ToolStripItem[] {770 this.zamToolStripButton});771 this.toolStrip1.Location = new System.Drawing.Point(0, 0);772 this.toolStrip1.Name = "toolStrip1";773 this.toolStrip1.Size = new System.Drawing.Size(812, 31);774 this.toolStrip1.TabIndex = 0;775 this.toolStrip1.Text = "reklamaToolStrip";776 //777 // zamToolStripButton778 //779 this.zamToolStripButton.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image;780 this.zamToolStripButton.Image = ((System.Drawing.Image)(resources.GetObject("zamToolStripButton.Image")));781 this.zamToolStripButton.ImageTransparentColor = System.Drawing.Color.Magenta;782 this.zamToolStripButton.Name = "zamToolStripButton";783 this.zamToolStripButton.Size = new System.Drawing.Size(28, 28);784 this.zamToolStripButton.Text = "Zamówienie";785 this.zamToolStripButton.Click += new System.EventHandler(this.zamToolStripButton_Click);786 //787 // panel788 //789 this.panel.Controls.Add(this.label2);790 this.panel.Controls.Add(this.label1);791 this.panel.Controls.Add(this.wartoscNettoNiezafakturowanaTextBox);792 this.panel.Controls.Add(this.wartoscNettoZafakturowanaTextBox);793 this.panel.Dock = System.Windows.Forms.DockStyle.Bottom;794 this.panel.Location = new System.Drawing.Point(0, 625);795 this.panel.Name = "panel";796 this.panel.Size = new System.Drawing.Size(979, 39);797 this.panel.TabIndex = 4;798 //799 // label2800 //801 this.label2.AutoSize = true;802 this.label2.Location = new System.Drawing.Point(672, 17);803 this.label2.Name = "label2";804 this.label2.Size = new System.Drawing.Size(164, 13);805 this.label2.TabIndex = 3;806 this.label2.Text = "Wartoæ netto niezafakturowana:";807 //808 // label1809 //810 this.label1.AutoSize = true;811 this.label1.Location = new System.Drawing.Point(365, 17);812 this.label1.Name = "label1";813 this.label1.Size = new System.Drawing.Size(150, 13);814 this.label1.TabIndex = 2;815 this.label1.Text = "Wartoæ netto zafakturowana:";816 //817 // wartoscNettoNiezafakturowanaTextBox818 //819 this.wartoscNettoNiezafakturowanaTextBox.BackColor = System.Drawing.Color.White;820 this.wartoscNettoNiezafakturowanaTextBox.Location = new System.Drawing.Point(842, 10);821 this.wartoscNettoNiezafakturowanaTextBox.Name = "wartoscNettoNiezafakturowanaTextBox";822 this.wartoscNettoNiezafakturowanaTextBox.ReadOnly = true;823 this.wartoscNettoNiezafakturowanaTextBox.Size = new System.Drawing.Size(125, 20);824 this.wartoscNettoNiezafakturowanaTextBox.TabIndex = 1;825 this.wartoscNettoNiezafakturowanaTextBox.TextAlign = System.Windows.Forms.HorizontalAlignment.Right;826 //827 // wartoscNettoZafakturowanaTextBox828 //829 this.wartoscNettoZafakturowanaTextBox.BackColor = System.Drawing.Color.White;830 this.wartoscNettoZafakturowanaTextBox.Location = new System.Drawing.Point(521, 10);831 this.wartoscNettoZafakturowanaTextBox.Name = "wartoscNettoZafakturowanaTextBox";832 this.wartoscNettoZafakturowanaTextBox.ReadOnly = true;833 this.wartoscNettoZafakturowanaTextBox.Size = new System.Drawing.Size(116, 20);834 this.wartoscNettoZafakturowanaTextBox.TabIndex = 0;835 this.wartoscNettoZafakturowanaTextBox.TextAlign = System.Windows.Forms.HorizontalAlignment.Right;836 //837 // reklamaTableAdapter838 //839 this.reklamaTableAdapter.ClearBeforeFill = true;840 //841 // VIEW_ZESTAWIENIE_ZAMOWIEN_NOWETableAdapter842 //843 this.VIEW_ZESTAWIENIE_ZAMOWIEN_NOWETableAdapter.ClearBeforeFill = true;844 //845 // reklamyZestawienieTableAdapter846 //847 this.reklamyZestawienieTableAdapter.ClearBeforeFill = true;848 //849 // agencja850 //851 this.agencja.DataPropertyName = "agencja";852 dataGridViewCellStyle3.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;853 this.agencja.DefaultCellStyle = dataGridViewCellStyle3;854 this.agencja.HeaderText = "Agencja";855 this.agencja.Name = "agencja";856 this.agencja.ReadOnly = true;857 this.agencja.Width = 71;858 //859 // agent860 //861 this.agent.DataPropertyName = "agent";862 dataGridViewCellStyle4.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;863 this.agent.DefaultCellStyle = dataGridViewCellStyle4;864 this.agent.HeaderText = "Agent";865 this.agent.Name = "agent";866 this.agent.ReadOnly = true;867 this.agent.Width = 60;868 //869 // rokZamowienia870 //871 this.rokZamowienia.DataPropertyName = "rokZamowienia";872 dataGridViewCellStyle5.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;873 this.rokZamowienia.DefaultCellStyle = dataGridViewCellStyle5;874 this.rokZamowienia.HeaderText = "Rok";875 this.rokZamowienia.Name = "rokZamowienia";876 this.rokZamowienia.ReadOnly = true;877 this.rokZamowienia.Width = 52;878 //879 // nrZamowieniaExt880 //881 this.nrZamowieniaExt.DataPropertyName = "nrZamowieniaExt";882 this.nrZamowieniaExt.HeaderText = "Nr zamówienia";883 this.nrZamowieniaExt.Name = "nrZamowieniaExt";884 this.nrZamowieniaExt.ReadOnly = true;885 this.nrZamowieniaExt.Width = 101;886 //887 // iloscReklam888 //889 this.iloscReklam.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None;890 this.iloscReklam.DataPropertyName = "iloscReklam";891 dataGridViewCellStyle6.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;892 this.iloscReklam.DefaultCellStyle = dataGridViewCellStyle6;893 this.iloscReklam.HeaderText = "# rek";894 this.iloscReklam.Name = "iloscReklam";895 this.iloscReklam.ReadOnly = true;896 this.iloscReklam.Width = 40;897 //898 // data_od899 //900 this.data_od.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None;901 this.data_od.DataPropertyName = "data_od";902 dataGridViewCellStyle7.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;903 dataGridViewCellStyle7.Format = "d";904 this.data_od.DefaultCellStyle = dataGridViewCellStyle7;905 this.data_od.HeaderText = "Data 1 em";906 this.data_od.Name = "data_od";907 this.data_od.ReadOnly = true;908 this.data_od.Width = 80;909 //910 // data_od_bez_FK911 //912 this.data_od_bez_FK.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None;913 this.data_od_bez_FK.DataPropertyName = "data_od_bez_FK";914 dataGridViewCellStyle8.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;915 this.data_od_bez_FK.DefaultCellStyle = dataGridViewCellStyle8;916 this.data_od_bez_FK.HeaderText = "Data 1 em bez FV";917 this.data_od_bez_FK.Name = "data_od_bez_FK";918 this.data_od_bez_FK.ReadOnly = true;919 this.data_od_bez_FK.Width = 80;920 //921 // wartoscNetto922 //923 this.wartoscNetto.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None;924 this.wartoscNetto.DataPropertyName = "wartoscNetto";925 dataGridViewCellStyle9.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight;926 dataGridViewCellStyle9.Format = "C2";927 this.wartoscNetto.DefaultCellStyle = dataGridViewCellStyle9;928 this.wartoscNetto.HeaderText = "Netto";929 this.wartoscNetto.Name = "wartoscNetto";930 this.wartoscNetto.ReadOnly = true;931 this.wartoscNetto.Width = 110;932 //933 // kwotaWalutaBrutto934 //935 this.kwotaWalutaBrutto.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None;936 this.kwotaWalutaBrutto.DataPropertyName = "kwotaWalutaBrutto";937 dataGridViewCellStyle10.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight;938 dataGridViewCellStyle10.Format = "N2";939 dataGridViewCellStyle10.NullValue = null;940 this.kwotaWalutaBrutto.DefaultCellStyle = dataGridViewCellStyle10;941 this.kwotaWalutaBrutto.HeaderText = "Waluta - brutto zamówienia";942 this.kwotaWalutaBrutto.Name = "kwotaWalutaBrutto";943 this.kwotaWalutaBrutto.ReadOnly = true;944 this.kwotaWalutaBrutto.Width = 110;945 //946 // bruttoEuroMianoDataGridViewTextBoxColumn947 //948 this.bruttoEuroMianoDataGridViewTextBoxColumn.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None;949 this.bruttoEuroMianoDataGridViewTextBoxColumn.DataPropertyName = "Brutto_Euro_Miano";950 dataGridViewCellStyle11.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;951 this.bruttoEuroMianoDataGridViewTextBoxColumn.DefaultCellStyle = dataGridViewCellStyle11;952 this.bruttoEuroMianoDataGridViewTextBoxColumn.HeaderText = "W";953 this.bruttoEuroMianoDataGridViewTextBoxColumn.Name = "bruttoEuroMianoDataGridViewTextBoxColumn";954 this.bruttoEuroMianoDataGridViewTextBoxColumn.ReadOnly = true;955 this.bruttoEuroMianoDataGridViewTextBoxColumn.Width = 35;956 //957 // nettoZafakturowane958 //959 this.nettoZafakturowane.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None;960 this.nettoZafakturowane.DataPropertyName = "nettoZafakturowane";961 dataGridViewCellStyle12.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight;962 dataGridViewCellStyle12.Format = "C2";963 this.nettoZafakturowane.DefaultCellStyle = dataGridViewCellStyle12;964 this.nettoZafakturowane.HeaderText = "Wartoæ netto FV";965 this.nettoZafakturowane.Name = "nettoZafakturowane";966 this.nettoZafakturowane.ReadOnly = true;967 this.nettoZafakturowane.Width = 110;968 //969 // DoZafakturowania970 //971 this.DoZafakturowania.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None;972 this.DoZafakturowania.DataPropertyName = "DoZafakturowania";973 dataGridViewCellStyle13.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight;974 dataGridViewCellStyle13.Format = "N2";975 dataGridViewCellStyle13.NullValue = null;976 this.DoZafakturowania.DefaultCellStyle = dataGridViewCellStyle13;977 this.DoZafakturowania.HeaderText = "Wartoæ niezafakturowana";978 this.DoZafakturowania.Name = "DoZafakturowania";979 this.DoZafakturowania.ReadOnly = true;980 this.DoZafakturowania.Width = 110;981 981 // 982 982 // ZestawienieZamowienForm … … 1076 1076 private System.Windows.Forms.DataGridViewTextBoxColumn iloscDataGridViewTextBoxColumn; 1077 1077 private System.Windows.Forms.DataGridViewTextBoxColumn wartoscNettoZafakturowanaDataGridViewTextBoxColumn; 1078 private System.Windows.Forms.Label label2; 1079 private System.Windows.Forms.Label label1; 1080 private System.Windows.Forms.DataGridViewTextBoxColumn agencja; 1081 private System.Windows.Forms.DataGridViewTextBoxColumn agent; 1082 private System.Windows.Forms.DataGridViewTextBoxColumn rokZamowienia; 1083 private System.Windows.Forms.DataGridViewTextBoxColumn nrZamowieniaExt; 1084 private System.Windows.Forms.DataGridViewTextBoxColumn iloscReklam; 1085 private System.Windows.Forms.DataGridViewTextBoxColumn data_od; 1086 private System.Windows.Forms.DataGridViewTextBoxColumn data_od_bez_FK; 1087 private System.Windows.Forms.DataGridViewTextBoxColumn wartoscNetto; 1088 private System.Windows.Forms.DataGridViewTextBoxColumn kwotaWalutaBrutto; 1089 private System.Windows.Forms.DataGridViewTextBoxColumn bruttoEuroMianoDataGridViewTextBoxColumn; 1090 private System.Windows.Forms.DataGridViewTextBoxColumn nettoZafakturowane; 1091 private System.Windows.Forms.DataGridViewTextBoxColumn DoZafakturowania; 1078 1092 private System.Windows.Forms.DataGridViewTextBoxColumn dataGridViewTextBoxColumn3; 1079 1093 private System.Windows.Forms.DataGridViewTextBoxColumn dataGridViewTextBoxColumn6; … … 1093 1107 private System.Windows.Forms.DataGridViewCheckBoxColumn dataGridViewCheckBoxColumn4; 1094 1108 private System.Windows.Forms.DataGridViewCheckBoxColumn wyroznienie; 1095 private System.Windows.Forms.Label label2;1096 private System.Windows.Forms.Label label1;1097 private System.Windows.Forms.DataGridViewTextBoxColumn agencja;1098 private System.Windows.Forms.DataGridViewTextBoxColumn agent;1099 private System.Windows.Forms.DataGridViewTextBoxColumn rokZamowienia;1100 private System.Windows.Forms.DataGridViewTextBoxColumn nrZamowieniaExt;1101 private System.Windows.Forms.DataGridViewTextBoxColumn iloscReklam;1102 private System.Windows.Forms.DataGridViewTextBoxColumn data_od;1103 private System.Windows.Forms.DataGridViewTextBoxColumn data_od_bez_FK;1104 private System.Windows.Forms.DataGridViewTextBoxColumn wartoscNetto;1105 private System.Windows.Forms.DataGridViewTextBoxColumn kwotaWalutaBrutto;1106 private System.Windows.Forms.DataGridViewTextBoxColumn bruttoEuroMianoDataGridViewTextBoxColumn;1107 private System.Windows.Forms.DataGridViewTextBoxColumn nettoZafakturowane;1108 private System.Windows.Forms.DataGridViewTextBoxColumn DoZafakturowania;1109 1109 1110 1110 } -
trunk/BazaReklam/ZestawienieZamowienForm.cs
r226 r349 26 26 } 27 27 28 private ZestawienieZamowienForm( MDIBazaReklam parent)28 private ZestawienieZamowienForm(Form parent) 29 29 { 30 30 InitializeComponent(); -
trunk/BazaReklam/ZestawienieZamowienForm.resx
r226 r349 200 200 iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8 201 201 YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAACZ5JREFUWEellwlU 202 lOUax1 8YDRdIxSWSQnAJBRHwdi8uqXlzOUVZnjLKItPQNETJUHRAZ2SRHUZARMANMSggjChElGVYh11W203 BYZhkVVCQEQE5H+fF6h7z7l67oXmnP/5vvm+mff3f553e14l9pxPxH62oWuA7VEWMCMVAZskUGEdg09Z204 +aRJbIqKMpszpMwaB5XYtY8dWCw10Ut6+ry2xvw87giTiCzZUORRhriTDNedGW64MCScYrjlzpAmYUg/205 zSASsaFbHuwKAbRIE8cMetYfYg4zi4uWDNeOM0QJGX6wZYi2IyMODDfd/g2XBTDknWPIJCP25syZ2ppH206 mvCXTGAbEwTtZXXf2zCcsWAItZqENA89ZHjq4eYpTcQIVYZNSUczkOnHkOXPcFXM6gQC9j7Bp/8lA1es207 2IrgvQx+OxkK/FYD+U5AjhiQkbJFQK4Dis4a49qJkS7gXZHhO9IVhguYA8EXkpTHbSL8ANt/5itK9wkt208 oIDgmSeALBKHZ9M1056uYkQcobHgwZDqPSI+NratZsEEXk2aPG4DoZbMxducoe/GNxT5SYqYTBS4AoVu209 lI1TBKdnOQ7I8TVArIghiUykeDH85shgvoGFEfg90rRxG7i8n0lCv2YEdCGQI13dgRIJUOoH3PYaMSFz210 RGPkh7jy7cgg5bPkFzGD2Zrh2fAxSX3cBgItmFumUJ2iJhA3wKHlAcDd4BET+WQszxkou4jyX21RneyC211 4utCFFzbg4M714cT+JO/ZODQuhcWl4r0BpFLcK4iDwL7AxVkotiHwCHoVyShND0WkZfPQeJxCp5OIgT6212 iOHp4pw/bdq0PWTgJZLSuLIwbx6b1Ouj14ms4zT4aODxlHMThZ5AZTge1mUj/PIFXIiMQkLpHaS3deOi213 QjFwObPwseu58x221gcbTd9++4vRcTCu2aDce8G4BEkHaMTbjZiQ0cArCcAjgoeEBEGmqEfrQC9a+npR214 1dmJ6w1tvWekd6rcpTVVrvFF944Lj3avNDHZSSZmjmdKKrWeNw5CjBmQehiQ2gIZdhisSUAERS6VK9A2215 8Bi9g0/Q/rgH1Q86kKZQPAyUllV5JxZVOSZXyp0SCpv37zaXq6iovEUG1MbcFRkS/Xe9RauGkGwN3KJM216 5PmgKvtnBIZHorbvEbr6+9A/0I+HZEQkEg1J65of+KcWV3onllU5J5RXO6fW14oCAnoMli71ILjueJbn217 qc0BhmmI3Aok0npQcgm/RgTjx9wyVHf3Qt79EPd7e1Db2YWsxvu9V2UVVdyAZ1J59cn4UrnrLXm9x83S218 NtPNG+MJ/jbpxbFmQVm4VXNFj2RxKyK30AyIQMhpN8TVdCKvtQNl9ztR1Pb7cPTRtxu6woua2n0o/acS219 yqrtfiuVe6ZUNzgl1Ddb7DIvIvBuksaYDDx20dWWf6MTU7pPZ7DfawkNRDcEejoi8m4rbilakFTThLSa220 ZiRWNOCXkgZcLFAMXMir6z4ZXyK3/aW0xlda1SRKaWjZ9blZIYG/I/Gt+v/79Loue6PtkE77A7E+ukS6221 yLPZhMKiQlw554uQjAqEl7cjouw+fsyrRVRRHX4orMNVug9Or4EopaZPlFLfeUHW0OIplbevXWVyfUwG222 eOQc3udjiAE/Izx0WoJ86zWITslFTGwcvEJjEFT8EBezanE5V4HQnFpczK5FUIYC/tIauNyQ03fFgCiz223 rtvzytVHGhoaIWPqgv5jutc6nZYCQX/D4Blj9HkZoN5iLpIPbUFxXAQ8HI4jIOkuArIacTZdgQCSv1QB224 zxSCJ9bgsqwRITmtCIpt7DfT0xucMmWKv4GBgQWZmPU/V8Yn9gv0k9ctfPpEYoQnpw3R52OER+7L0OWo225 h6YD2miwXYWSMA+4iI/DN7kKXhmtkEgb4JtSh3MZDQgraIFHaguCZa2w2vMVQoKD+CDtdQ88/3S55sz1226 oyvj85fnLksdh6bvXkOPmwEeuRqgx2UpOh310SFagjahLpoPv4YWHzMUkQmnowfhHxaNwDQFvNNb4Z3W227 hkuyNoRGx2P7VlP4SiRo/70Dd+ra8KO1KbKNmWzJBLaWTEx5biZads2Tth7VxQMHfTw4qYcOsR7aOfzY228 YjTZvIb6AwtRs3c+aoVvoe57V0S5HYXHESt42tnAXXgI4n07cf6IJbK9xHAVn0Dx3Xr8GnYMfT+/B3is229 Qs161by/q7GVzzSxjTHB3e2zf28TLkbrMV2KePEwuMVWF00UecPBhVBYzke1hTYqvtBCqfkCVNpthcLH230 GooAe8hPC1Em3gfZl5tR5nsKbhJ/nD30GXoi36Ft3ApIMge81qBuvWrhalX2xn+ZKP9AbaboA80hHmnT231 d4vQaEM6tAj3rBeh3org+wi+WweVO+ahbPuruP2RJvK3vIzszS8hff1spKyaicTXpyPe4EUkrNRBjpcz232 6k2XYFBoBCRsp3piP5D8BeC9Fvc2qhWvVx3ujql/dkfBP9X1ck01UGe1APLd8+m6ELWWC4bB8q91UPWV233 Nu6Mwou3aaLgg7nIeUcDmRvmQLp2FlJWzMB1wxfxm74afl44FbFGmig8fgTtnxh2w84QiP90xETKDsBn234 NRpMZ5dv+ejTg2RgBknAitbNWJq8btbTsu1aw9Eo9hF0tzYqd2nj7pfzUGFOaf/0VfwB52azNs5B2puz235 kLxKHUkrZ+Aso7qQMsANRL86GWHqkyE9fLg+ylDpJo4tA+I+pmJmL21un+Gnn37CYXv7CoLz3XK4fpz4236 vaGadYLx5O6kf6ijcqc2qjh8hzbKP9dCmdkrKKK0F77/MnLf1YBs8xxkvDUHqWso+pXqSF6hjvMTlRG7237 S BVh0ydCpKw05MRYgbFAcInmnddN4wlxOKIHRJviXlMtsnILsXz5cl6+fUOayw3w+Tlr2SRlM7GWSniU238 7gv3E42nI/WNmZBt0kD+ey8jn9Ke//5c5FH0PPUpFHn80mmI0qJoZxCUsSE/xhRUCl3TZOw8tedPsiFt239 ohrdJNOIxYT5uUOalQ8XV1fo6uqG0rsdpNl/bBICuuEVzOt0wNtpPFnJ3Ux1whUb1Qk3XNSUb/tMFdRK240 JgpaPZRZmytj9faMle1nLO1DxmJeZ+wSlcHnRqFiuvJqaA1Jh8S34sn6JiZvHhWKm42MjMN0dHQuKSkp241 8Vph0+j7PzwMZ0KFNIe0hPQmiVe5xGJCkiPJZVT8nnywb0eB/DxgQuInI/5/fjj5z5qQfyevbC+JR877242 n6f/mWdJboS/4CsXzwr/IT94zh8FcAi/1ya9Mgrkg4mb59BnLbn8GZ96vC2edl6qDcP/BXuHB4SKMyVF202 lOUax19AwwVScYmkEFxCQQS83YtLat5cTlGWp4yyyDQ0DVEyFB3QGVlkhxEQEXBDDAoIIwoRZRnWYRcY 203 UGAYFlklBEREQP73eYG695yr515ozvmf75vvm3l//+d5t+dVYs/5RO5nG7oG2B5lFWasqsImqaiyjsGn 204 rHzSJDZFVZnNGVJmjYNK7NrHjiyOmuglPX1eW2N+Hn+EiYVWbCjqKEP8SYbrLgw3XBkSTzHc8mBIFzNk 205 nGYQCtnQLU92hQDapIljBj3rD7GHmeVFK4ZrxxmiBQw/2DHE2JMRR4ab7v+GSwMZ8s8xZJERBwvmQm3N 206 I034SyawjakE72V139synLFkCLOehHRPfWR66ePmKS3EClSHTUlGM5Dlz5AdwHBVxOpUVNj7BJ/+lwxc 207 sWYrQvYy+O9kKPRfDRQ4A7kiQErKEQJ5jig+a4JrJ0a6gHdFpt9IVxgtYI4EX0hSHreJiANs/5mvKN0n 208 tIFCgmedALJJHJ5D1ywHuooQeYTGgidDms+I+NjYtpqFEHg1afK4DYRZMVcfC4a+G99Q5CcpYjJR6AYU 209 uVM2ThGcnuU6ItfPEHFChmQykerN8JsTg8UGFk7g90jTxm3g8n4mDvuaEdCVQE509QBKxUCZP3Dbe8SE 210 1AmNUR/iyrcjg5TPkl9EDOZrhmfDxySNcRsIsmTuWQINippA3ACHlgcCd0NGTBSQsXwXQHYR5b/aoTrF 211 FSXXBSi8tgcHd66PIPAnf8nAoXUvLC4T6g8ij+BcxZ4EDgAqyESJL4FD0a9IRllGHKIun4PY8xS8nIUI 212 8hXBy9WlYNq0aXvIwEskpXFlYd48NqnXV78T2cdp8NHA4ynnJoq8gMoIPKzLQcTlC7gQFY3EsjvIaOvG 213 RYVi4HJW0WO3c+c77GwONpq9/fYXo+NgXLNBufeCSSmSD9CItx8xIaWBVxqIRwQPDQ2GVFGP1oFetPT1 214 oqqzE9cb2nrPSO5UeUhqqtwSiu8dFxztXmlqupNMzBzPlFRqPW8SjFhzIO0wILEDMu0xWJOISIpcIleg 215 beAxegefoP1xD6ofdCBdoXgYJJFV+SQVVzmlVMqdE4ua9++2kKuqqr5FBtTH3BWZYoN3vYWrhpBiA9yi 216 TOT7oirnZwRFRKG27xG6+vvQP9CPh2REKBQOSeqaHwSklVT6JMmqXBLLq13S6muFgYE9hkuXehJcbzzL 217 89TmQKN0RG0Fkmg9KL2EXyND8GOeDNXdvZB3P8T93h7UdnYhu/F+71VpRRU34JVcXn0yoUzudkte73mz 218 rM1s88YEgr9NenGsWVAWbNVa0SNe3IqoLTQDIhF62h3xNZ3Ib+2A7H4nitt+H44+5nZDV0RxU7svpf9U 219 oqza/rcyuVdqdYNzYn2z5S6LYgLvJmmOycBjVz0d+Te6sWX7dAf7vZfQQHRHkJcTou624paiBck1TUiv 220 aUZSRQN+KW3AxULFwIX8uu6TCaVyu1/KavwkVU3C1IaWXZ+bFxH4OxLfqv+/T6/bsjfaDum2PxAZoEuo 221 h3zbTSgqLsKVc34IzaxARHk7ImX38WN+LaKL6/BDUR2u0n1IRg2EqTV9wtT6zgvShhYvibx97SrT62My 222 wCPn8D5fIwz4G+Oh8xIU2KxBTGoeYuPi4R0Wi+CSh7iYXYvLeQqE5dbiYk4tgjMVCJDUwPWGnL4rBoRZ 223 dd1eV64+0tTUDB1TF/Qf07vW6bwUCP4bBs+YoM/bEPWWc5FyaAtK4iPh6Xgcgcl3EZjdiLMZCgSSAiQK 224 eKUSPKkGl6WNCM1tRXBcY7+5vv7glClTAgwNDS3JxKz/uTI+cVhgkLJu4dMnYmM8OW2EPl9jPPJYhi4n 225 fTQd0EGD3SqUhnvCVXQcfilV8M5shVjSAL/UOpzLbEB4YQs801oQIm2F9Z6vEBoSzAdpr0fQ+afLtWau 226 H10Zn788d1npOjZ99xp63A3xyM0QPa5L0elkgA7hErQJ9NB8+DW0+JqjmEw4Hz2IgPAYBKUr4JPRCp/0 227 NlyStiEsJgHbt5rBTyxG++8duFPXhh9tzJBjwqRLJrC1ZGLKczPRsmuepPWoHh44GuDBSX10iPTRzuHH 228 FqPJ9jXUH1iImr3zUSt4C3XfuyHa/Sg8j1jDy94WHoJDEO3bifNHrJDjLYKb6ARK7tbj1/Bj6Pv5PcBz 229 FWrWq+X/XZ2tfKaJbYyp3N0++/c2wWK0HtOjiBcPg1vs9NBEkTccXAiF1XxUW+qg4gttlFksQKX9Vih8 230 baAIdID8tAAy0T5Iv9wMmd8puIsDcPbQZ+iJeoe2cWsg2QLwXoO69WpFq9XYG/9lovwD9ZnCD7SGeKRN 231 3y1Coy3p0CLcs1mEemuC7yP4bl1U7pgH2fZXcfsjLRRseRk5m19CxvrZSF01E0mvT0eC4YtIXKmLXG8X 232 1JstwaDAGEjcTvXEfiDlC8BnLe5tVC9ZrzbcHVP/7I7Cf2ro55lpos56AeS759N1IWqtFgyD5V/rouor 233 HdwZhZds00LhB3OR+44msjbMgWTtLKSumIHrRi/iNwN1/LxwKuKMtVB0/AjaPzHqhr0RkPDpiInUHYDv 234 ajSYzS7f8tGnB8nADJIKK143Y2nKullPZdu1h6NR7CPobh1U7tLB3S/nocKC0v7pq/gDzs1mb5yD9Ddn 235 IWWVBpJXzsBZRnUhZYAbiHl1MsI1JkNy+HB9tJHSTRxbBsR/TMXMXtrcPsNPP/2Eww4OFQTnu+Vw/Tjx 236 eyN1m0STyd3J/9BA5U4dVHH4Dh2Uf64NmfkrKKa0F73/MvLe1YR08xxkvjUHaWso+pUaSFmhgfMTlRG3 237 SA3h0ydCqKw05MxYoYmKyiWad943TSbE44g+EGOGe021yM4rwvLly3n59g1pLjfA5+esZZOUzUXaqhHR 238 ei/cTzKZjrQ3ZkK6SRMF772MAkp7wftzkU/R89SnUuQJS6chWpuinUFQxob8GVNQKXRNi7Hz1F4AyZa0 239 iWp00yxjFhvu7wFJdgFc3dygp6cXRu92kGb/sUmo0A2vYF6nA95Ok8lKHuZqE67Yqk244aqufNt3qkqt 240 eKJKq6cya3NjrN6BMdl+xtI/ZCz2dcYuURl8bhQqoiuvhtaQdEl8K55sYGr65lGBqNnY2CRcV1f3kpKS 241 Eq8VNo2+/8PDcCZUSXNIS0hvkniVSywmIDmRXEfF78kH+3YUyM8DpiR+MuL/54eT/6wJ+XfyyvaSeOS8 242 /3n6n3mW5Eb4C75y8azwH/KD5/xRAIfwex3SK6NAPpi4eQ591pLLn/Gpx9viaeel2jD8X3IJB4N8aaBd 243 243 AAAAAElFTkSuQmCC 244 244 </value> … … 274 274 <value> 275 275 iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8 276 YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAABX RJREFUSEuVlQtQ277 VFUYx10VG0JbMg0ZSGAmncpycPIxlqES W1CoEYyMj5BU1NDMCgNcl8tjWFDQQZHAlZVhWQSUjZGXqJGK278 CZIoEgjyEkRhAUkWlzfL/vvOzlIqC9aZ+c3de+49//89337fd3gTxhnbth034vONjsycaeTW2vqkXal8279 kDc01JOVnh79By0bIKBnPJmxn4WG5oobG9vAhlYLVFY2geM4rY/P0foNG/yPuLjssKfVLxMTCd7/comI280 kJlIJJe6dOrPDWZWVfVAZ7ZzZ0iDm5v3sVWrPAVkYEJM+k9GwcF5zjdu1BrSHzUXFhYDV9ftWldXryZH281 x6/EJiYmZmRiNK5RQEB6qErV/UKDuLhE7NoVhaIiIC3tIYTCVMyfb5dA4jbjmvj6pir+VaeYGBiDgwNY282 t04Ef/9kLFz4MYqLh1BdDTg6erSS+Dpixpi7EIszbjLNwcFhaDSGDTIyzmHLlkhERORDJJKgpQV49AhY283 tGhZFQmLCKuxDHgxMbmtw8NAX98QOjtVOJUsR0hgIIKDAyGVSNDc/BDp6XkDs2bNTlm6dEXDxo3f4uJF284 FZY vjxzm81+VkfBewtKgwfnz50047ldNf/8wWppbcTIpGYVNrSjXAAVPgDN32nBMKkOKPLWbBBIpS33M285 zc0OW1nZpE 2bZiqhuYOEI8E3aJCYeOFtjovSdnR0IV4mRweFqo9oHhhGyeMB5D7ow6n70KWphYVFNInY286 Ee8SnxJuxEfE62OmbGysQlBWdg9nz2biWksnVCSuoeSv7dWgqKMPWfd7Ia9SQ363G16em26RkBMxnZim287 v7J6YMX3zGCVqKvGkJC4TffuKSneIbiuBup6NKhUD+I6iecre6GoU+NkuQqJ1Vr4+PioackP+niPruZD288 hyqmJyTUJsnl5TdFogyxg4PnnB07hPsaGh6BCwpCTivwW3MvLiv7kNfUg7P1aiRXdiHmtgrymmHs2y9i289 / 0M48abBeIeGZqWq1SzCQHs7LYxRdLu67qmrqGhBdNRRyCgMp+t7cLq2C2mErEKF2NudkNxSIalGi61b290 N 98h4QN6g9E7iIrKVCmVnVAqVejvpzShoVaT4Ok85Obk46hcAUmVBifKunCchI/cfIzYUhUSqgbBZeZr291 bG1ts6xsbEL0BqPiPiEgILGmsLCGqrAO5eVNaGxsh0rVozPSaIYgiYtFdEomjt3uQfSfdF8+BCkZJmRd292 w YGQQFy8/Ds4X98n9q8Zr9Kn5bO78PYO8+S4M4MKRTEVSgUKCqpQUlKPu3ebQWeAzqjgyhUEcyL4CffD293 f z+Hg+IwXYoyCoouo02yElg7A85mhk34S5Y4f715s+gqW5CcfA05OWXIz6+gXdWTWQ28vffRfQkuXSqm294 0P2C2lo1MrOy1SyD7kd+CNTvBrLXAhvM4W7B//L5nbD+zZqS3dy5tgEuLtuv+flxWqm0ANnZFQgPl2LN295 mm/g5LQRe/fGwN7eGfHxt7BypeCqMY8ng5MJIHMCqr8DzrkD6/lwmj/HQ18P//wn7AcrDmvCwdr6rQCB296 wL1wzx5OKxT+TO34ADW0XLi4eMHLKwhBQSkwMzNLoneF5kYT1+OzqUD8J3QKbUWb1Au+vkGd9Iyddqzw297 nhlsN1MJ1ssdLC2tuWXL7G/Y2ztq/f1PICwsE4cPX6BdCJQ8Hu8EvfMFKzCrlyatgGAKWkJXo7SmGes9298 PKpp/iditsHaoMmnjQSWlrPD5817r3Tx4tX9Cxa8X2NsbMwOFCHxDjGFfdSsyRPsvP38/nJ3dy81NTWV299 0tz3zHwsg5H5ESNWpZ8TPoSY+JFgDe0VYqTFsBAv0QvvpusH+mi8yEP3fDLBWu8bBDNjVxbKpwuLGRnr300 v9pi5PnftUu61ZRZvr4AAAAASUVORK5CYII=276 YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAABXVJREFUSEuVlQtQ 277 VFUYx10VG0JbMg0ZSGAmncpycPIxlqESm1CoEYyMj5BU1NDMCgNclwvs8FDUUCRwZWVYFgGFGHmJGqmY 278 IIkigSAvQXRZQJLF5c2y/76zs5TKgnVmfnP3nnvP/3/Pt9/3Hd64McbWrceN+HyjI9OnG7m1tDxpUyof 279 5A0OdmelpUX9Qcv6CegZS2b0ZyEhuaGNja1gQ6sFKiubwHGc1sfnaP369f5HXFy229Pql4nxBO9/uURE 280 yEwkkkudOvXnBjOrqnqgM9uxQ9zg5uZ9bOVKTwEZmBAT/pNRcHCe840btYb0R8yFhUXD1XWb1tXVq8nR 281 8ctQExMTMzIxGtMoICAtRKXqeqFBbGwCdu6MRFERkJr6EEJhCubOtYsncZsxTXx9U9L/VaeYGBgDA/1Y 282 u1YEf/8kzJ//MYqLB1FdDTg6erSQ+Fpi2qi7CA3NuMk0BwaGoNEYNsjIOIfNmw8iIiIfIpEEzc3Ao0fA 283 ggVLqkhYRFiNZsCLjs5tGRoCensH0dGhwqkkOcSBgQgODoRUIoFC8RBpaXn9M2bMTF68eFnDhg3f4OJF 284 FZYuPTjE578qI+E9hKVBg/Pnz5tw3K+avr4hNCtacDIxCYVNLSjXAAVPgDN3WnFMKkOyPKWLBBIoS33M 285 zc0OW1nZpE6ZYiqhuQOEI8E3aJCQcOFtjvtJ297eiTiZHO0Uql5C0T+Eksf9yH3Qi1P3oUtTCwuLKBKx 286 I94lVhBuxEfE66OmbExMuqCs7B7Ons3EteYOqEhcQ8lf26NBUXsvsu73QF6lhvxuF7w8N94iISdiKjFF 287 f2X1wIrvmcEqUVeNYnHsxnv3lBRvMa6rgbpuDSrVA7hO4vnKHqTXqXGyXIWEai18fHzUtOR7fbxHVvOh 288 QxVT4+NrE+Xy8psiUUaog4PnrO3bhXsbGh6BCwpCTgvwm6IHl5W9yGvqxtl6NZIqOxF9WwV5zRD27hOx 289 /yGceNNgvENCslLUahZhoK2NFkand7m67q6rqGhGVORRyCgMp+u7cbq2E6mErEKFmNsdkNxSIbFGiy1b 290 Nt0h4f16g5E7iIzMVCmVHVAqVejrozShoVaT4Ok85Obk46g8HZIqDU6UdeI4CR+5+RgxpSrEVw2Ay8zX 291 2NraZlnZ2Ij1BiPiPi4gIKGmsLCGqrAO5eVNaGxsg0rVrTPSaAYhiY1BVHImjt3uRtSfdF8+CCkZxmdd 292 wX5xIC5e/h2cr+8T+9eMV+rT8tldeHuHeXLcmYH09GIqlAoUFFShpKQed+8qQGeAzqjgyhUEcyL4CffB 293 fx+HA6FhuhRlFBRdRqtkObBmGpzNDJvwFy1y/mrTJtFVtiAp6RpycsqQn19Bu6onsxp4e++l+xJculRM 294 ofsFtbVqZGZlq1kG3T/4IVC/C8heA6w3h7sF/4vnd8L6N2tKdrNn2wa4uGy75ufHaaXSAmRnVyA8XIrV 295 q7+Gk9MG7NkTDXt7Z8TF3cLy5YKrxjyeDE4mgMwJqP4WOOcOrOPDae4sD309/POfsB+sOKwJB2vrtwIE 296 AvfC3bs5rVD4M7Xj/dTQcuHi4gUvryAEBSXDzMwskd4VmhuNX4dPJwNxn9AptAWtUi/4+gZ10DN22rHC 297 e2aw3UwmWC93sLS05pYssb9hb++o9fc/gbCwTBw+fIF2IVDyeLwT9M7nrMCsXpqwDIJJaA5ZhdIaBdZ5 298 eFTT/I/ETIO1QZNPGwksLWeGz5nzXunChav65s17v8bY2JgdKELiHWIS+6gZE8fZefv5/eXu7l5qamoq 299 pbnvmPloBsPzw0asSj8jfIhQ4geCNbRXiOEWw0K8SC+8i64f6KPxIg/d84kEa71vEMyMXVkony4sZmSs 300 /2qL4ed/A6+3utTZ1XpnAAAAAElFTkSuQmCC 301 301 </value> 302 302 </data> … … 405 405 <value> 406 406 iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8 407 YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAABX9JREFUSEudlQ lM408 lFcQxwcQlgUtVBCtQPGoJURFKyooNlRksQooHihKtYqoTSn1rg2JbGFVQFQQVFa2CgoICstRlQpEUbwv409 wNZ6VI1VULD1SBckBtz9d54fNoJo0r7kl2+//d77z7x5M/OM6F1jVdUAatJ9S8YyxXvdLD58/rylueVh410 Qw01PsijSlUe6ep0vPzFOzXe+nHt/dVdo249H6ZuxcR9wCQmuBCYWwyMTroPCtJW0dCFXrzekjH6b0bW411 P9zcI+EpBqoB562t+CQN8EgHPDMAr92Afy4QtF8Psy8P/0WDQmawuFUHI+8wqKyfIY9SGcwjL+koeFc5412 ea3Ukn9SuTz8nM5D3Qw/FvfbCwTuB6bnA6bBhfVk5z7ppZEJR6eRd34RjUiZze/dGOP2O1MqjWlF1W1a413 dCiH5FYx/DGOWcEsJgubVeS3vswtqR6zOFQzWTz0ALCgsBXknXyWnAKm2s868mxDNWA1JecRrxHhEzt7414 bUTes6dll2P5nznMXGYk8yHTS3p28SDfuAKftEdYfAhYXgZEn+AdbbkDck99uumUAbHnAEvfHbd5/ndt415 a9uZEFsSYqOYvox5W2xFTAVysnQYRIG5V1aXAyoWjzsFJLLo94eakHge2HwRIOdllTxXyfRpvwNJxIzp416 ynTp+LHtXUZuEdPdoyv0yRdY/AywjYVTWXg7E136DNR7WgHPXcbYd6bxytvO9T8vkZFn8gTyTK/dckaP417 NBbdxXHPqAEyrwBfZ9aCbEbv5sXzGDtJJP7vAfTD7VSKvJpAq84voXDOhtCi4RSg6dm2E8loyFkHy/lH418 6wJTbmJNiQ6aKkl476/APhYv+J2zK64GZO6YxvMDGemQZbF3q0tuGqC92oK4E40ILXgM3521GKyMMdgp419 bzwxijhXRo5j+5N3enBIegNSWVBzWfI47xpQdAMovg6U3AGGRygNZGKeyrIii+RESy984KWMN9Q1AmW3420 JG/Secsipkl8eCo+xLHqP0Gu06PIpt9w8ssrsw079sjVq0I/fm01QtU3oSx4gB2nGpF+sQXGHhtqWDiR421 GSLtPuLY2IXaepytA/J/Y6/Ys7RLQAqLf/NTE0al3IPF4uJakltv5AWfMgOZUDKRryOL3olkNWQ79VLs422 IvuQXOozv5DMuqv5ewTj+DKsFFYaHluhQwFvNfsXKaZqzoq4k3rQzOy7ZOWUSUYmIqYiK1wYkWEilT9i423 BjMejIKZwoQwQYyrFB4x5v6crLn4AnvYcyG+g0Ozhb0X4Rm2sUJPts7beJboNx8zFpJX/yJSWdZm1Jqf424 tkx35lX98M955aVZfFgaDktUeTO2cW4ncNxVlcAKrlQKyrlCZnLRa95vE5Yce3N0nt62S47/kcaHuq6S425 QzK7+PG0jAbEngRWsrhoB+M0T0CKmCIiU7Ft4e2bY+KReHJVicoXRdq+k9ouPf10E8e8Z/hpHcl7ZNFk426 zfmvDrZiETey2VqGG5vb5jrQ+E0l5OAtepOIreStotSOFNps8tFe53dPRtRNhw7q/+Mc8tOUkKOnOMhY427 snVZYBpW0hBSBMxgA+Ki8WdGqRthGXa8icbvOUDjstSkyD0on1XxTBbMed8naA2v/YJx6CyMotpEUYgM428 +OzlpKELgsRlEpBjgD/3fZ9M6aLx5KfbTsBlqx4ufAHZLI8xkEtENq8RrV1kUof2LEVTbElcDiIDXjU5429 K3LymUoBGdXOMXfglSWJj+QbbSjTN6EJ5r6Hm8kxIIvXpDDighHem7x5QJ3/I2JszYU4hvpPiif36OOm430 k/PqZVPznxiNSblGfWdyQVnv5DniQhJ578S8rfu+1aYwIi50UVATGVGdKmY9E8mIS2kE0+P/iL9uVXgm431 Ytub6ddmUHgsQvpaQXXu6D/rdLIP2mZLogAAAABJRU5ErkJggg==407 YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAABX9JREFUSEudlQtQ 408 zXkUx0+lbrfYWiVWJY+1TYNYochOK90sFXlEtCwJO9u23munGd2tUIRS6OouRaWo22NxVzVE3q/KrvVY 409 jKUoux6ztzSm3Pvd8/PPjhIz9jfzmf/93//v9z3nd37nnJ8RvWusrOxPjbrvyFim+KCLRa/nz5ubmh/W 410 V1PDgzyqiM0jXa2Ol794p8ZbP665v6pz1K3nQ1UtmLAPmMgEFwJzioFRSfdBQZpKGrLAi9dbMkbvZ2Td 411 w83dEp5igApw3tqCT9MAj3TAMwPw2g345wJB+/Uw++rw3zQwZDqLW7Uz8g6Dyrrp8qgYg3nkJR0F7yoj 412 rxUa8k8qk4ef03momuDH4n57gcD9wLR8wDS4sI7s3Ce+NDL+6FTyzi+i4Smz+L0LY9x2Z0qlMS2vvE0L 413 D+WQ3CqGP8Yzy5lFZGGzkvzWlbol1WEmh2oGi4ceAOYXtoC8k8+SU8AU+5lHnm2oAqwm5zziNSJ8Ymev 414 jch79rT0chz/M5uZw4xgejE9pGcnD/KNL/BJe4RFh4BlpUD0Cd7Rljsg99Snm04ZEHcOsPTdcZvnf9+6 415 to0JsSUhNpLpw5i3xlbEVCAnS4eBFJh7ZVUZEMvi8aeARBb94VAjEs8Dmy8C5Ly0gucqmd5tdyCJmDGd 416 mU7tP7a+y8gtYpp7dLk++QKLnwG2sXAqC29nokuegXpOLeC5Sxn7jjReedux/hdaGXkmjyfP9JotZ/RI 417 Y9FdHPeMaiDzCvBNZg3IZtRuXjyXsZNE1v/Tn368nUqRVxNo5fnFFM7ZEFo0jALU3Vt3IhkNOetgOe9o 418 bWDKTazW6qCulIT3/gbsY/GCPzi74qtB5o5pPD+QkQ5ZFne3SnvTAM3VZsSfaEBowWP47qzBIGW0wU55 419 44lRxLlSchzTj7zTg0PS65HKgurLksd514CiG0DxdUB7BxgWoTSQiXkqy4oskhMtufCRlzLeUNsAlN6S 420 vEnnLYuYJvHhxfIhjlH9BXKdFkU2fYeRX16pbdixR65e5fpxa6oQqroJZcED7DjVgPSLzTD22FDNwonM 421 YGn3EcfGLNDU4WwtkP87e8WepV0CUlj8258bMTLlHiwWFdeQ3HojL/iMGcCEkol8LVn0TCSrwduph2IX 422 2YfkUu95hWTWVcXfIxjHl2GlsJLwuHIdCnir2b9KMVVxVsSf1INmZN8lK6dMMjIRMRVZ4cKIDBOp/DEz 423 iPFgFMxkJoQJYlyl8Igx55dk9cUX2MOeC/EdHJot7L0Iz9CN5Xqydd7Gs0S/+YSxkLz6D5HKslaj1vy0 424 Zboyr+qHf84tK8niw1JzWKLKmrCNczuB4x5bASznSqWgnCtkJhe95sNWYcmxN0fH6W27+PifaXyoays4 425 JLOKH0/NqEfcSWAFi4t2MFb9BKSIKSIyFdsW3r45JhxZT66xovJFkbbtpLZLTj/dxDHvHn5aR/JuWTRJ 426 ff7rgy1YyI1slobhxua2uRY0bpOWHLxFbxKxlbxVlNiRQpNNPprr/O7JiLpp10H9f5pNfmotOXqKg4wj 427 W5f5pmHa+pAiYDobEBeNPzNS1QDLsOONNG7PARqbpSJF7kH5zPJnsmDO+95Bq3ntl4xDR2EU1SaKQmTA 428 5y8nDZkfJC6TgBwD/Lnv+2RKF40nP912Ai5b9XDhC8hmWbSBXCKyeY1o7SKT2rVnKZpiS+JyEBnwqslZ 429 kZPPFArIqHKOuQOvLEl8BN9oQ5g+CY0w9z3cRI4BWbwmhREXjPDe5M0D6vgfEWNrLsTR1G/ienKPPm46 430 Ka9ONiX/idHolGvUZwYXlPVOniMuJJH3Tszbuu9bbQoj4kIXBTWBEdUZy6xjIhlxKQ1nuv0f8detCs9E 431 bHsyfVsNCo9FSF8rqI4d/RfX27IL8cTWXgAAAABJRU5ErkJggg== 432 432 </value> 433 433 </data>
