Index: branches/Abonament/TruckExpoCDN/app.config =================================================================== --- branches/Abonament/TruckExpoCDN/app.config (revision 482) +++ branches/Abonament/TruckExpoCDN/app.config (revision 839) @@ -7,5 +7,6 @@ --> - + + Index: branches/Abonament/TruckExpoCDN/EXPODataSet.Designer.cs =================================================================== --- branches/Abonament/TruckExpoCDN/EXPODataSet.Designer.cs (revision 479) +++ branches/Abonament/TruckExpoCDN/EXPODataSet.Designer.cs (revision 839) @@ -2,5 +2,5 @@ // // This code was generated by a tool. -// Runtime Version:2.0.50727.3053 +// Runtime Version:2.0.50727.3082 // // Changes to this file may cause incorrect behavior and will be lost if @@ -5269,5 +5269,5 @@ this._commandCollection[1] = new global::System.Data.SqlClient.SqlCommand(); this._commandCollection[1].Connection = this.Connection; - this._commandCollection[1].CommandText = @"SELECT BYL_WYDRUK, DATA_SPRZEDAZY, DATA_WYSTAWIENIA, EKSPORT, EXPORTED, EXPORTED_DATA, FAKTURA_PODTYP, FAKTURA_TYP, ID_FAKTURY, ID_FK_KOR, ID_KONTA, ID_NABYWCY, ID_SPRZEDAWCY, ID_TYTUL, KOREKTA, MIEJSCOWOSC_WYSTAWIENIA, NABYWCA_ADRES, NABYWCA_NIP, NUMER, NUMER_ROK, NUMER_ROZ, PODPIS_ODEBRAL, PODPIS_WYSTAWIL, SPOSOB_ZAPLATY, SPRZEDAWCA_ADRES, SPRZEDAWCA_NIP, TERMIN_ZAPLATY, ZAPLACONO, Zaliczka_Brutto, Zaliczka_Data, opis, suma_zaplat, waluta_brutto, waluta_kurs, waluta_kurs_z_dnia, waluta_miano, waluta_przelicznik, waluta_tabela_nr, zaplata_data, zaplata_opis FROM FAKTURY WHERE (NUMER_ROK >= 2008) AND (EXPORTED = 0) AND (SystemKsiegowyId = 2) ORDER BY ID_NABYWCY"; + this._commandCollection[1].CommandText = @"SELECT BYL_WYDRUK, DATA_SPRZEDAZY, DATA_WYSTAWIENIA, EKSPORT, EXPORTED, EXPORTED_DATA, FAKTURA_PODTYP, FAKTURA_TYP, ID_FAKTURY, ID_FK_KOR, ID_KONTA, ID_NABYWCY, ID_SPRZEDAWCY, ID_TYTUL, KOREKTA, MIEJSCOWOSC_WYSTAWIENIA, NABYWCA_ADRES, NABYWCA_NIP, NUMER, NUMER_ROK, NUMER_ROZ, PODPIS_ODEBRAL, PODPIS_WYSTAWIL, SPOSOB_ZAPLATY, SPRZEDAWCA_ADRES, SPRZEDAWCA_NIP, TERMIN_ZAPLATY, ZAPLACONO, Zaliczka_Brutto, Zaliczka_Data, opis, suma_zaplat, waluta_brutto, waluta_kurs, waluta_kurs_z_dnia, waluta_miano, waluta_przelicznik, waluta_tabela_nr, zaplata_data, zaplata_opis FROM FAKTURY WHERE (NUMER_ROK >= 2008) AND (EXPORTED = 0) AND (SystemKsiegowyId = 2) AND KOREKTA=0 ORDER BY ID_NABYWCY"; this._commandCollection[1].CommandType = global::System.Data.CommandType.Text; } Index: branches/Abonament/TruckExpoCDN/ExportForm.resx =================================================================== --- branches/Abonament/TruckExpoCDN/ExportForm.resx (revision 479) +++ branches/Abonament/TruckExpoCDN/ExportForm.resx (revision 839) @@ -125,39 +125,39 @@ iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8 - YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAAB7tJREFUWEetVwlQ - VucVZXFtItiI66CQCC4oA0RTgsZgYmRRUYoLOwHUQBVQUNlkFwuC4A+2gDAFsdohYUQpgqBUEdRiUatB - RKtCZd9XZVPe6b1vgHHrhCVv5sx7/Lx377nnnu++70lLjeIwvqW6s6/jlXGv1DidCX3CnYtbymyluqWa - KFTvKMKN7JGtJYsdLfM/F443+MK3dTNMbi6FmptCGEWZTxg3smgjvHvLPbVv116d13u8zwbZOAmfelPs - qTCAdvrM1inzZawpnAJBeoRhh3e70R01Fb1spcYj7WZIgAPisRM/dsXBqUIPW28vw5KIGVkU6QvCpOFF - HMFd313+TN4gV6XYvcIQJ4SdiO3fgVhhO1IQCP+aH+BY/h2+Pq8szDL+jR+FVSLIjiD8L9wKKZmNl1Qz - fij5CjGvt+N4r62IP/XZIabfDql90bB5/DXM7mtjyalp5bJTpTZSRPlfjYDJ9QXh5oVaiOq2QUSnBSJf - WELSZS3+zUTi+h1wpPYALB6uhO4/VKDkKf9XSq5OmDBmEpv+vdB2U85iIazNFIMIJw+8SSS6xwbxHX6C - 1a01ggmpsPTs9F65L8c5U/LZBJlRk9jwQG3e+guq3YfqjRHWshUhzVtEhNL1kdZtGCRy7KUVonuscbjC - XTAs0oDutUVQipa/TS74hpJ/PGoCetmKn+jnfVq4+opqv83dL+Dx3AAhTZtxuNEEf6QzE2FVjnaY41iX - FaLa/iDY/Wu9YHBLA2rpMzHt+0kSSq46ltnA8ilNWTjBRdlG7i+aJxSKTW6q43DD78GqMJE3SUiIxJF6 - F2HNZXXhm+tLMDN5YquM8thnA6/puQTtedvlfI3yF+NQ3SYE1m4cIuFftU2I7DSHhFoR3mojOP+8WdAr - 1IBm1lzIB038VWYDT7ZJi+Kmfm9wbSECqtbDjxBQY4SgeiOc7zmBFTnz4fBIF9G0MiQdjsKGot/BsEgL - ionywgR9GR96ft6oDRkbG6scGSbxd4y0LVtzVRk+5AUfGkgiidr1SOk6ipVZitA8PwOfnBqPlfnK2HxP - GwsvzMDUM+P7x6+RiqXkXxEmD9uQ4eHhH0VFRVmHhYXlEl5fz7uOC6VnseLyLBz8rz68Cb6V6+BXvQ4n - 232x4aoKll2YBcuMLYjKkkA7Tgta/uqv1VerpcnKyh6jxKuHsyKkExISVkokkoSIiIi2jIwMVFVVobu7 - G/l5Bdgf54LPsxXgVb6WVNAfUGEdYlr2Yh0R0Py7AuwvW6GzrhMNlQ24mfdPxMfGw22XW7O9vX2Cqanp - qgEVPjwbYmJiCpKTk4UHDx7g1atXePLkCc6cOYODBw/C28sbXt5e0E3QwqdpH2PttflwffYtDtUaIbJh - O4zyFkArYzoss7ehqboJtbW1aGpqQn19PR4/foz09HSEhob2Ozk5XSQSih+cklR1d3V1Nfr7+0UCubm5 - 8PHxgaenJ7y9veHp4QlPVy84uTphQ9RazD0thyUXp8H6vg4Wn/8txp+UgqTwKBprGsXEra2tqKurw7Nn - z3D37l0hJSUFbm5uAiW3I8x6zw/BwcHVRUVFuHPnDpgIH0wkKysL+/btw549e+Du7o7goGBIwqMQJ4mH - a7wzliWrwyjZAJlXMlFXUY+62jqxdWVlZXj69ClOnz4tUCGCl5cXXFxceihxKEHlXQLSRODnwsJC3Lt3 - D/fv30dpaSmam5tFRV68eCHKGBgYyFKCfIKYP8cgMSEJKckp+OlvqUj9MRU3btzA8+fPWXbh0qVLCAoK - EtVjeHh4YMeOHbxtiyQsILy1cZH29/fP4wDFxcVgHzx8+BCPHj1CeXk5Ojo60NfXh5aWFmRmZoJWCOLi - 4pCUlMQVoqCgQKyaCXMRtIrAFXMLxfZRG1k9W1vb8jcUeHvnFBAQcDY/P19MysnZPGxE7iHLyf18+fKl - iIaGBuTk5CAvL080HBMsKSlBdHS0aFpfX9+h5EzkwIEDYhvNzc2LicAhwmfvKiBFD+0iifvYfFw194+T - 83VFRYVYYU1NDdra2tDV1SWemQxLnpiYKCYmFeHn5zeUnGXnyl1dXeHs7CysWrUqjRJ7DEzG93wor6Oj - Y01Mi1heVoGTVlZWDiVndzc2NoqtYG+cO3dOrJa9QQoOJeeqOTlXTsaDpaVluaKi4inKGE3YQpj2oanI - +7gZBF1DQ8NICtCYlpYmLikGy87Juc9cPROIjIx8KzmrwMm551y1o6Pji+XLl6dKS0snUVxfguHAHPi/ - 23eeUh/xMlFQUDC3sLA4R7K+vn37trgSuPL29nax53yw2VhyVkEcWGS4/fv385IVTExM8iZPnpxMscIJ - loSlBN4rDmvDygxZpmUaGhruDg4OD+Lj40UFenp6Bs0ohISEDBlusGo7O7unc+bMYbljCE6EFYSZhPHv - Ge9DfXjjN14mE1kyeqHo6evrx1Bl7by++SADCoPrnKvevXt3J8n9E8mdSM/wK5jlVibwW3BMHyvclimE - RVSZvZmZWQ61RSCT8oTD3r17BWNj4ysDcvMnmgVBbSRy/4IQQ/9mCacTtDU1Nf2sra3/Y2VlVTp79uyT - A3LvovOXBDbyiOUeLgmWkiXlrx8Dwj6CK0F/4Lcxyz1cIuxkOfbHAPh6WO5+N8H/ADA+O4NoOTJZAAAA - AElFTkSuQmCC + YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAAB75JREFUWEetVwlQ + lGcS5fDcRDARz0IhETxQC4hmiRpDEpVDRVlEkTOAGlgFFFQuuSXLJeOAmwGhouCxRWKJsigCujqCuljo + Liyeq8ICciO3gCj/2+6/kPJKhSN/1asZhv/vfv36dc83igpDuMxvaG/taXth/lxhxOJRPcKt85aljgpd + Co0U6vkQwg3ukQ135rraXvlMOFgfiMDm9bC4Ph86XmrRFGUmYcTgog3ybssinW9XXJ7+/GCPA7KRgoA6 + K+yoMIFBxuTmcTOV7CmcGkFxkGEHdrvZLR0to2yNhqjWTUiGC5KwFT93JsKtwggbbi7EvNhJWRTpc8KY + gUUcxF0rLnyqanJRq8S7whSHhK1I6N2CBGEz0hCK4Orv4Vq2Al+d1hSmmP8hiMJqEJQHEf43boWC0tpc + 7czv73wJ2cvNOPjcUcRfe5wg63XCyZ54ODz4CpuKDTDv6IQy5fEKaymi6u9GwOLqrBjrAn3EdTkgtt0G + kg5bSDvtxb+ZSGKvC6Jq9sDm7lIY/kMLGr6qxyj5AsKoYZNY9+/Zjuuy5wrRLVZ4hRjywOtE4rsdcKg1 + SLArWC5YkArzT018rvLFCHdKPpWgNGQSa27rzFidqd21r84c0U0bEPHUUkQkvY9q3ohXRA48s0N8tz3C + y70F00JdGF6ZA4141Zvkgm8o+YdDJmCUrf6xsfyTAsNL2r0O//ocPuUmiGhcjx8aLPAXemUirMr+Nmsc + 6LSDtPnPgtON1YLJDV3oZEzGhO/GSCm59nB2A8unMW72KA9NB5Wf9A6plVhcX4Af6v8EVoWJvE5CSiQi + az2E5bkLhG+uzsPk1NHNSprD3w0809MJBjM2qwSa5c3Fvtp1CK1Z208iuHKjIGm3hpRaEd3kILgXrxeM + CnShlzUdqmGjf5fdwJttzJzE8d+ZXJmNkCerEUQIqTZDWJ0ZznQfwpKcmXC5b4h4mowDra7CmsI/wrRQ + H+o/qQqjjJUC6PkZQzZkQkKCpiRaGuwqcSxdflkTAeSFAFpIIoma1Ujr3I+lWerQOzMJHx8diaV5mlhf + ZIDZZydh/ImRvSOXKyRQ8i8JYwdsyJiYmA/i4uLso6OjL0ZFRb28Kr+Ks/dOYcmFKdj7P2P4EwIrVyGo + ahVSWgOx5rIWFp6dAttMS8RlSWGQqA+94PkvF3ytk66srHyAEn89kIlQTE5OXiqVSpNjY2NbMjMz8eTJ + E3R1dSFPno/diR74LFsNfmUrSQXjPhVWQda0E6uIgN7f1eB8wQ7tte2or6zHdfk/kZSQBK9tXk+dnZ2T + rayslvWp8P7dIJPJ8lNSUoTbt2/jxYsXePjwIU6cOIG9e/fC388ffv5+MEzWxyfpH2LllZnwfPwt9tWY + QVK/GWbyWdDPnAjb7I1orGpETU0NGhsbUVdXhwcPHiAjIwORkZG9bm5u54mE+nu3JFXdVVVVhd7eXpHA + xYsXERAQAF9fX/j7+8PXxxe+nn5w83TDmriVmH5cBfPOT4B98WLMPfMRRqYoQFqwHw3VDWLi5uZm1NbW + 4vHjx7h165aQlpYGLy8vgZI7Eaa844fw8PCqwsJCvhlMhC8mkpWVhV27dmHHjh3w9vZGeFg4pDFxSJQm + wTPJHQtTF8As1QTnLp1DbUUdamtqxdaVlpbi0aNHOHbsmECFCH5+fvDw8OimxJEErbcJKBKB/xQUFKCo + qAjFxcW4d+8enj59KirS0dEhyhgaGspSgnwC2Y8yHE4+grTUNPzyt5M4+fNJXLt2DeXl5bh//76Qm5uL + sLAwUT2Gj48PtmzZwsc2CWEW4Y2Di2JwcLCcA5SUlIB9cPfuXQ6EsrIytLW1oaenB01NTTh37hxoQpCY + mIgjR47g+PHjyM/PF6tmwlwETRG4Ym6h2D5qI6vn6OhY9poCb56cQkJCTuXl5YlJOTmbh43IPWQ5uZ/P + nj0TUV9fj5ycHMjlctFwTPDOnTuIj48XTRsYGNifnIns2bNHbKO1tXUJEdhH+PRtBRTooW1EoofNx1Vz + /zg5v6+oqBArrK6uRktLCzo7O8VXJsOSHz58WExMKiIoKKg/OcvOlXt6esLd3V1YtmxZOiX26duM7/hQ + dfHixfbEtJDlZRU4aWVlZX9ydndDQ4PYCvbG6dOnxWrZG0S+PzlXzcm5cjIebG1ty9TV1Y9SxniCJWHC + +7Yin+MmEQxNTU0lFKAhPT1dHCkGy87Juc9cPROQSCRvJGcVODn3nKt2dXXtWLRo0UlFRcUjFDeQYNq3 + B371+M5b6gMeEzU1NWsbG5vTJOvLmzdvipPAlbe2too954vNxpKzCuLCIsPt3r2bR1awsLCQjx07NpVi + xRBsCfMJfFYc0IGVGbJMC3V1db1dXFxuJyUliQp0d3eLvSdCQkRERL/hXlXt5OT0aNq0aSy3jOBGWEKY + TBj5jvHe14fXPuMxGc2S0ReKkbGxsYwqa+X55osJvJpzrnr79u3tJPcvJPdheoa/glluTQJ/Cw7rxwq3 + ZRxhDlXmvGnTphxqi0BjxxsOO3fuFMzNzS/1yc0/0WwIOoOR+zeE6P83SziRYKCnpxdkb2//Xzs7u3tT + p05N6ZN7G71+QWAjD1rugZJgKVlS/vVjQthF8CQY9302bLkHSoSdrML+6AO/H5C7307wf2f5O02a/NLj + AAAAAElFTkSuQmCC @@ -165,40 +165,40 @@ iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8 - YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAAB/1JREFUWEe1Vwl0 - lOUVfZmEJMxkZpJMlpksQBaWAqFFaDFkgzDZNyCExURLQRQsCAcERIugwqlLa2kttK4gRSmCwmkqJu0B - KbWtSE9tT2NRW2mlcMTmgBKyJ/Pf3jcLmwnELnPOOz8H+L/73n33u+/9Iv//X9B/DfGGyKhDIo/mi8Tz - sEEDOfCwyITXRN7aKlKXJBLNd0IYA0/mZZHg34vMf0vk4Ns2S++f0px4RmQLD0m9URK/ExlG8DMf5w3F - 8Tgz9or8fbvI5uUiI/lu2A0TaRKJOCrS2JSRipb75wLbVwCbZoEstI4RWcgDlIk+q/ktq/25SNMnRcOB - b4wD5qShqyQR76VFYL9JOn4i8qz//f6ZZOUH/jEzB9izDth6J/BYHfDgTJx2j8Q2JsYDMhmDr20FWQsl - +JGTk4cCiycQfASM6fxzRSI8FS58lBeDnSLn+N5sRky/rTwu8p7nycXAk4uAR2qBh2uAB6YD3yrFIWuY - USWyni8PZQQHDtkgYiL4rqYMF3D3ZKB2DFCdCqMyGW0lLnyYH4cD9kEoF9nNd1YzkvtN4HWRJ05Vfg3Y - Mh/YPIfVV/sSuK8ULbUT8aLIX60ipTzAHjiEQt1yNMVhYGUuMF+pHwHMGIau8kQ0FzrRkB6B74n8kX17 - ju/UMFSYff+eFsk5GmM18MMFTGA2sGEGq68A1pUCa93486g43Ceyg2+PZYT+WmTjYafdwD35wMKbgFu+ - BGNWGnorh6ClOBHHb3aoENvJ+Qv+6lWMeiv6/Q1mo9/tWEfgTaR/fRWrLwfuZQKr3KQ4Bz8LMXUXiKwk - Gxt/ER1B8GnAHWTt1rG+6qvT0FGehJNuF/bbQ1Epsodo32XkMizXA9d/M/F/r38/iwd9mwxo9Qq+upAJ - sMrluWipzsBPRS40OMjUmgKKLhP4OqmfNwqYnY7uqiFoLk7A61T/oyJ/8FM/j2f3e4OuSuoukfQGCWrX - 64f7y4A1Rb7qVzCBpezz3Vk4WzYa3srvyuKV+wqpHw2DCXiqU9BSmoRjk2LA+38xSoTil1UMpX5ARqbJ - hO2jYk9XjmcLyMA9rHLFVEYeE8gmKCteSrUv4XMB+15H1RPcmD0cHRXJ+IDU7zIHG4UiL/GsxxjZA6H+ - ShaCnhBxN9rMBjaw/ytZ6XI/uIJqv2+fyMqZoPadwsPckejmvf+YwqtPMoNX8wgPpKalmhHLGLgV+zMx - vyryq+Yamor2finN6UrwBQS/LcNHPRPonZmCT0n94XFRalj/DPWpnt302vd1Vd+fKE2PiMw6GG2h0Nj/ - b7LXgcoVXEVXSx0o9TXD0U7TOZEbj+ckqIsDSPu+kXETI/xGqu/z39XXqfS9jc5IA6uZwBL2XGlfeCU4 - E5hLy52Vis6KJDSNjcQPRD40i/yIh6pZRf4n1AudrXg/afwgbyRFyFuwjMpf9FWf2pV2b+Xsu955mo56 - vqcyCUYVkxhlBfXzboYIXVtsXygB+nlUg8j2N2xmT9sSim4t1a+VL6QO5n/ZLzgf7So6BVfLNaqS4aHt - espcfDpxYqxNdXCSFAw8CY7g6bTMM+9np9P5eO/peN6eB6rWq6Zq1+B102EDVh4A7y1NQE+JEz3Fcegt - jsVH423Ug5xfJHI7WVDvvzS8Ptdz9vvxBofFaL+ToKum+IADKg8Aa9Xz2G8KDlS80q7TTisPgHcXxaGr - IBYdBQ4+Hfgk04bdpqDuB31ekNjvbTgoUn/xFhqKGowC3+rvs1brpZuh8109nkbTUZ6MXs55o+zz4J1u - BzqmRaMtPwodUyPRkmPDPluw8R3uEnSjCUxCd4mrPYHUbzuVy+VhAfvsv1reHqvI5rAlNWnwsNftZUk4 - VejCsRFWdLLfWnl3sROByi+BT41Ca54dFwmu0ZYTgUPOEKzjskNwnaK6ml3+8dKueWd4NIXGynmtUENQ - FZj2mcA9HC6tNJm/uePxSmw4vi9yqiEyFD1lCh6PzoIY9AmebcX5TAvOTBqMeiYww2fNcxmOS+ikf9nL - IabOs4UEqyPlfmWrwDB9CLp4vy+UJKBpShz2EpRT5QhtbddSkX2v2kONriL23B2D9nzSfmXlBP80y4Kz - kyx4e1w4njVJD1G523pXsssLCVN687MSgtdykVBxsVqouAjcTorPFblwPNOBHYNDjCUir7F5z/OAZYxp - m+h4++yDjHb2vY39bptiRyspv5BlxbnJPvCm8eHYaTWBa5DST4uQSYzL7sj7uvqdlAgqm8AUVm9ZArpK - XWgl8Jlp8TicYceLQaZu3mkaozzF0M1YRys3M0l/mL5Rbw3BxanaczvOZ0Xg7M0WnCbtJyaGY1eUCStE - fsM7qInfxnBdJcI6kRSy0OIhcDcXyNYiJ84VxKMpJwYHEsLxY3oDp4l6+xbGHMYwBmeN96fP1AdI7UuW - YOMz0n6a4G+OCcOeyGDsCAvCvSLHCL7Dz1qfO0Eod6XN9dGhRrM7Fn/JjkZjihm7Q0wefkw0+qfaRh7A - 8e7N/trJ5k1ircjWnWaT8UpUMB4X+RdXtj2juYQSnB9IQsl41d/nYAqK4LymuLapc3GAN7PBv6RrcKER - zha5gzGeoVuwyV/5tQ/ddIYt5iccs3yGoNoqSsRLOb/qvCP5ulNRq9JdXynmLiEPMXie5DE4XQfwSeVj - Rvd9Fu+dhFpxHIP1DWwf0AP0iyXFn7GTT91g+6u6LzL0DBWnTkFl5QtvQXqovhSIvkD+Z3/3b58Ggech - TTbOAAAAAElFTkSuQmCC + YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAAB/5JREFUWEe1Vwl0 + lGcVfZmEJMxkZpJMlpksQBYWgaAUlIZsECb7BoSwNGlFKC1UKBwoUFop1MKxmxWt4FIU2oIYU4RTpISj + UNCqpXisHlNpq0WLcErNgZaQPZn/et8sbE0gVTvnvPNzgP+77913v/veL/LZ/4L+Z4hXRUYdEXkiXySe + hw0ayIFHRSYcFHl9q0hdkkg03wlhDDyZn4kE/0Fk/usir7xhs/T+Oc2J50S28JDUWyXxe5FhBD/3Qd5Q + nIwzo0HkHztENi8XGcl3w26ZSJNIxK9FDjdlpKLl4bnAjhXAplkgC61jRBbyAGWiz2p+x2p/IdL0YdFw + 4CvjgDlp6CpJxNtpEdhnko4XRbb73++fSVa+/58zc4D6dcDWe4En64BHZ+KseyS2MTEekMkYfGMryFoo + wY+dnjwUWDyB4CNgTOefKxLhqXDh/bwYvCByge/NZsT028qTIm97nl0MPLsIeLwWeKwGeGQ68LVS/Moa + ZlSJrOfLQxnBgUM2iJgIvqspwwXcPxmoHQNUp8KoTEZbiQvv5cdhv30QykX28J3VjOR+Ezgk8syZyi8B + W+YDm+ew+mpfAg+VoqV2InaL/M0qUsoD7IFDKNQtx1McBlbmAvOV+hHAjGHoKk9Ec6ETjekR+JbIn9i3 + H/GdGoYKs+/fD0VyjsdYDXx3AROYDWyYweorgHWlwFo3/jIqDg+J7OTbYxmhvxHZeMRpN/BAPrDwNuCO + z8GYlYbeyiFoKU7EydsdKsR2cv68v3oVo96Kfn+D2ei3OtYReBPpX1/F6suBB5nAKjcpzsHLIabuApGV + ZGPj4egIgk8D7iFrd471VV+dho7yJJx2u7DPHopKkXqifZORy7DcDFz/zcT/vf6dLB70DTKg1Sv46kIm + wCqX56KlOgM/Fbl0yEGm1hRQdJnAl0n9vFHA7HR0Vw1Bc3ECDlH9T4j80U/9PJ7d7w26Lqn7RNIbJahd + rx8eLgPWFPmqX8EElrLP92fhfNloeCu/L4tX7gukfjQMJuCpTkFLaRJOTIoB7//lKBGKX1YxlPoBGZkm + E/YSFXu2cjxbQAYeYJUrpjLymEA2QVnxUqp9CZ8L2Pc6qp7gxuzh6KhIxruk/kVzsFEo8hOe9SQjeyDU + X8tC0DMi7kab2cAG9n8lK13uB1dQ7ffdE1k5E9S+U3iYOxLdvPcfUHgHkszg1TzGA6lpqWbEMgZuxf5M + zD8XOd5cQ1PR3i+lOV0LvoDgd2X4qGcCvTNT8BGpPzouSg3rX6E+1bObXvu+qer7E6XpcZFZB6MtFBr7 + /1X2OlC5gqvoaqkDpb5mONppOqdy47Fdgro4gLTvGxm3McJvpfo+/119nUpvaHRGGljNBJaw50r7wmvB + mcBcWu6sVHRWJKFpbCS+I/KeWeR7PFTNKvK/oV7obMX7SOO7eSMpQt6CZVT+oi/61K60eytn3/XO03TU + 8z2VSTCqmMQoK6iftzJE6Npi+1QJ0M+jGkV2vGoze9qWUHRrqX6tfCF1MP/zfsH5aFfRKbharlGVDA9t + 11Pm4tOJU2NtqoPTpGDgSXAET6dlnnsnO53Ox3tPx/P2PFC1XjVVuwavmw4bsPIAeG9pAnpKnOgpjkNv + cSzeH28Djf/iIpG7yYJ6/5Xh9Ymes99PHXJYjPZ7Cbpqig84oPIAsFY9j/2m4EDFK+067bTyAHh3URy6 + CmLRUeDg04EPM23YYwrqftTnBYn93oZXRA5cvoOGogajwHf6+6zVeulm6HxXj6fRdJQno5dz3ij7JHin + 24GOadFoy49Cx9RItOTY0GALNp7mLkE3msAkdJe43hNI/bYzuVweFrDP/qvl7bGKbA5bUpMGD3vdXpaE + M4UunBhhRSf7rZV3FzsRqPwK+NQotObZcZngGm05ETjiDME6LjsE1ymqq9nVHy/tmjeHR1NorJzXCjUE + VYFpnwncw+HSSpP5uzsee2PD8W2RM42RoegpU/B4dBbEoE/wbCsuZlpwbtJgHGACM3zWPJfhuIJO+pfV + h5g6zxcSrI6U+5WtAsP0Ieji/b5UkoCmKXFoICinyjHa2q6lIi/ttYcaXUXsuTsG7fmk/drKCf5RlgXn + J1nwxrhwbDdJD1G523pXsqsLCVN67eMSgtdykVBxsVqouAjcToovFLlwMtOBHYNDjCUiB9m8H/OAZYxp + m+h4DfZBRjv73sZ+t02xo5WUX8qy4sJkH3jT+HC8YDWBa5DST4uQSYyr7sj7uvrNlAgqm8AUVm9ZArpK + XWgl8Llp8TiaYcfuIFM37zSNUX7A0M1YRys3M0l/jL5xwBqCy1O153ZczIrA+dstOEvaT00Mx64oE1aI + /JZ3UBO/i+G6ToR1IilkocVD4G4ukK1FTlwoiEdTTgz2J4Tj+/QGThP19i2MOYxhDM4a70+fqY+Q2t2W + YONj0n6W4K+NCUN9ZDB2hgXhQZETBN/pZ63PnSCUu9Lml6NDjWZ3LP6aHY3DKWbsCTF5+DFx2D/VNvIA + jndv9jdONm8Sa0W2Pm82GXujgvGUyL+5stWP5hJKcH4gCSXjVX+fgykogvOa4tqmzsUB3swG/5KuwYVG + OFvkHsZ4hm7BJn/lNz500xm2mJ9wzPI5gmqrKBEv5fyq847km05FrUp3faWYu4R8ncHzJI/B6TqATyof + M7rvs3jvJNSK4xisb2D7gB6gXywp/oydfOoG21/VfZGhZ6g4dQoqK596C9JD9aVA9AXyf/u7/wACp4HT + CLbAWwAAAABJRU5ErkJggg== @@ -206,46 +206,46 @@ iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8 - YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAACJhJREFUWEelVwtc - j/caf0pINnfjzKW5jSmWISPCopzEkUgTcmeOXE5biyK3EaGwVLqplOiyXMr9mjsj12zM5bCMOXMnk//3 - fJ/6+2xnJ9Y5vZ/P9/P//d/3/T3f5/fcXxMp7TUkt7LUeOQhzwtdxWBoLQWmNaXcy2fyouB7KXiwV+6e - S5Z9Cy5R3K8ESiu2dO/NveklPofyq866BPvoh3BPA0ZsBkYRnuufoPm8yxDPHQXimhQuDbs0otCKhEnp - hL/prbEoLwEXY8sHnDK0XPkCH8cC1hFAq0igTRTQlugUBwzdAIzPBhpOPw/5W3KefODpQLFvlVGJQFOZ - mbuu8qwraEHSD8KJsELYrAI6rgbsiM5EV6J7AuCQCHjRIu2X3ob0Xf+TNHPrTwWq/v9KzLvyhXngWcM7 - C+6hwrTDBhm35Z6M2nRRxu3MLz9pj6Hh3Gv4hKROycQawJm/fdYCbulULuwupEfcDalj25sKVClSwnXb - O+KY4SfdkiaLpXNd3iv/euP732wg/8h5Yup9+KW4R2+X2s1ixMRkFTcEE3OlRqMgcZiTYeK174X9qsfo - lwq4ppB8PTCQa69NQIdF1yD2y4+ImZmtVG9bVRwSjrb+MhfNvI9A2i/dTjlNjbFSgh6+eUHic/ietOqn - hKGEN6F+bUk0IZoTXeR9Fz/xyLzTLfIePs0APBicXt8wHqjAl3sBS++DEKvxEWIXsrTRZ/sRdwHw2wdI - u/BfuH8UoZYo4fK/nii2o//OJz5EH0IjW4OqnNGnpvytRNSXFn2HyaCN912TCzCGMeC9BfDdAcykArOU - zDH5mYlzwouwb/l/PzBl01MqNecs984mGr/ODTX4wJ7oQNQyEpf0ripUQ+xmTKk0MsvwxS5g+m4S7QHm - knzxUWBIbD4mp99DCNcLDgHDYvIhTcaoC/wJy9cpoAFSjahM6GnfdGm+15Je8Wndl1xCEEnmHyD5QSCE - 6xXHirH0MLDsBNBr/jlIvd7ruEct/O6fyC7143Ji7dFOnNMeBZM0VMmOACtJHHEcCFdwHX2G9WPSPkh1 - m1hK9jRat9Qkb7ZCx2BL6R65xyHoPCJOApEkjaLf47henQvEngKSLgK1B2RCzOtEUJgzoSlqvLTqzbna - RvxyGkvP4FemV/P+Hv+txIijLtJ/65lyfbJf2kw/jqlpdxFF0lgigcRJp4Hks8Aanj71MoOyY8yvYlJu - JQV1IsyLBQberSIBp443WvYDqgSeNkjA8QLxv3hdfM8fEJ+TKeJ9aLGM2z1ZRm51E69vbLijuNaP3Wgh - rukPfLOfIuE8TUyycPo52ki+lqTreT+VWM8UjDz2KzNgxVXuDSGsCQ1iXgHf+bsk/oi8n1GEE/lAJs21 - +GABJmU9xIDE2+gcdg2N512EhU+OQUbvWV0UQD2i3zXrs+VlGImD6HdNtSieOpEnTjkHpJE0Iw9IpwIZ - lDcj4w6kxbQc7p1DaAoaG9b0vJ1hR5/i6j0g55/FGq+mz6IpMIy+DKHwIEb1DOb21J2A6Wc5hfJ2neFF - SvTNjDP3SDc0mZiDLoEn4Rb6HSYl30TwjvtYd6YQu24AOyhz5y3A3icHUtcxmfsmE/V+8+fUCzf2XDXg - 2I/FWqfwBPE8SSTNWZRCjOhFjO6ZLCQD1j6BDM+6Sz9+RQEtipSoaT1OarcPlQZOMdLUK0WsPs8Wm6Aj - 0pbm7hz1pJpLnKHeQAafVcC33BfJPf2IasUKjD1RVXxPFebeBjbQTGk8vfoujhaIoAJqgdEsJM3nX4DJ - hAOFMjDltNRtHced041m1Hj4C/ERoeVahQ8lJhC+tPJsKV9lsZjXXcb1UuN9LeVmxQqM22n73lfnkHO9 - +OTJJE/k6dX8mruqgN3XV1lSF+WIWcUk7lhBaInuSmi71Ut9WYHQ7KlGaPVUpRoYlVRL2RBtiIaEKm28 - Rm4Z3iXsB2RdKjZ7vNH3WjyW0/RLaPp5NL14bH0olWst5K4ehJbQt4nXVck/pq++pyfWCvuHPSO2zvdc - k1+Up1HGFFrF068g+WKSB7GsamntvJzttdeSTRRgR1j8doKyroZlpX+e9QArtVySeArXo1L/VVRKlXwO - m8o0Rv5UdjjzCTsM8uEw7WJqAWMOl1UBz63ngvYXFkW6NhAZs/s5J59nC7lWcj8ST+S8N5qttl/Sc8in - G+9LU5cRRj+/efDsuc1RnLbFG+PiNRPQ0M2PQnj6UJrfckYuxNotVT4cktJk5lnMpAITszgBc+gczFFr - MIeOrhH3If3Tfhab8aMpWNt2yZZw3uwuDnGPxDZ4Cd/R1q7vlnC5Z2xvOfsCrOflQXqHHufoFSOmppPE - NfFI52U3i06u5O4ctdzWcfTir33kY5gOynghDpGJ0m6aZoMOJ6bSNLui9Ez/RBxSN5g6JxnEfvVDqVDT - j89ciOolK6BzfIfJC6X14FipYKFNYiJhJc2c7ZnzN7pH/ALPTBKTXIfOvyaxp3MAdeCvpf/3qOCRaRBH - WsQp7Yo4Jj02H7TBUDvgFioO3GyQ99yiKSuQ0PT7Xer9pyr6QAdEJ6IXoUVCT2QhrYb1FdfUnzqE3EJ/ - ml8n356chLvH0wrG0bwj121igJY6tvM7oRm/HSoN3suqNzWbMr4m3EoTL5qjmtfanzVYXuVxVbF07CdO - sRfq+5yGoypAdOV3QCcStYsu/kCx5rdCS64tg5/BrM9ag7w/lulqEkU5OnjqPGmseiU74U13VZGqUrle - N/k4IEEc05/W8zmD1iEPYKsK8KvIOvwlGgTegsUQnrpt6E2p9VEC96grNVPUslohy3SpEjoRW8lbDcdI - C8ZKu9mHxW7lDbEPvyO2Sy6LlfcuEsczgLXRzCA06LTklpn8leavan0d3mhLuBPaD+YS2hVnEtp89EtI - 6361spj9z1yiQas5XZ/QoUI/VNTPOuFqc/qf/P1vf0bflr5o6X0AAAAASUVORK5CYII= + YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAACJlJREFUWEelVwlY + jukafkpIZmQdzlga2zCKySBjCxPlJI5EGiE748hymmmilG2IUJhUSklKtMhS9jU7Q3YzjOUwGcaZ7EL+ + +9xP/a6ZMyemc/qu677+9/++733u5332z0RKeg3KqShVH3nI8wJXMRhayDPTamL26pm8zP9B8h/slXvn + kmTf3MsU94JAScWW7L1Zt7zE51Cu5fTLsI95CPdUYNhmYAThue4Jmsy+AvHckS+uiRFSr1N9Ci1PmJRM + +NveGo2yEnAptmzASUOzZS/xaSxgEwk0jwJaRgOtiPZxwOANwNgsoN7U85C/JV2UjzwdKPadUioRZCqB + OWsrTr+KpiT9KIIIL4DtcqDdSqAD0ZHoTHRdBTgkAF60SJtFdyC91/0sjd36UgHL/1+J2Ve/Mg86Y3hv + bh7KTTlkkDFb8mTEpksyZmdu2Qm7DfVmXcdnJHVKIlYDzvzttQZwS6Ny4fcg3eJuSk27nlSgUqESrtve + E8d0P+mSOFGsnGvxXtk3G9//Vl35x/4npuMPvRL3mO1So/EKMTFZzg0hxCypWj9YHGamm3jte2m//DH6 + pACuySRfB/Tn2msT0Hb+dYj9kiNiZmYnVVpZisOqoy2+zkFj7yOQNou2U04jY6wUo4fvxWDxOZwnzfso + YRjhTahfmxENiSZEJ/nQxU88Mu52icrD5+mAB4PTaz3jgQp8vRew8j4IsR4bKR1CF9X/Yj/iLgB++wBp + HfEr948g1BLFXP43EsRu5N/5xIfoRWhka1CVMfrUlL8ViDrStPcQGbDxvmtSPkYxBry3AL47gEAqMF3J + HJOemTjHvwz/jv/3A5M2PaVSM89y7wyiwZvcUJUP7Im2RHUjcXHvqkJVpcO0SRWGbzZ8tQuYuptEe4BZ + JF9wFBgUm4uJaXkI5XruIWDIilxIw1HqAn/C6k0KaIBUJioSetq3XZrv1aVHfGrXhZcRTJI5B0h+EAjl + eumxIiw6DCw+AfSYcw5Su+da7lELv/8nskv8uIzYeLQW59RHISQNU7IjwDISRx4HIhRcx5xh/ZiwD1LF + NpaSPY3WLTHJ263QLsRKukbtcQg+j8iTQBRJo+n3OK5X5gCxp4DES0CNfhkQ85qRFOZMaIoaL616M6+1 + FL/sBtI95LXp1by/x38rMeyoi/TdeqaMS9Yr26nHMTn1HqJJGkusInHiaSDpLLCap0+5wqBst+KFmJRZ + RkHtCfMigUH3KknAqeP1F/+ISkE5Bgk4li/+l26I7/kD4nMyWbwPLZAxuyfK8K1u4rXeljuKav3ojRbi + mvbAN+spVp2niUkWQT/HGMnXkHQd76cQ65iCUcdeMAOWXuPeUMKG0CDmFfC9v0vCT7j4CwpxIhfIoLkW + HMzHhMyH6JdwBx3Dr6PB7Euw8NlvkJF7VhYGULeY981ctrwKJ3Ew/a6pFs1TJ/DEyeeAVJKmXwTSqEA6 + 5U1LvwtpOiWbe2cSmoLGhjX14s7wo09xLQ/I/meRxivpsxgKDKcvQyk8mFE9jbk9eSdg+kV2gbxbc2ih + Er0z4sw9Ug0Nx2ejU9BJuIV9jwlJtxCy4z7WninArpvADsrceRuw98mG1HJM4r6JRO3f/Dn5ws091ww4 + 9lOR1sk8QTxPEkVzFqYQI3o+ozuQhaTfmieQoZn36MdvKKBpoRLVbMZIjTZhUtdphTTyShbrL7PENviI + tKK5O0Y/qewSa6jdn8FnHfAd90VxTx+icpECo09Yiu+pgpw7wAaaKZWnV9/F0QKRVEAtMJKFpMmcCzAZ + d6BA+iefllot4rhzqtGMGg9/IT4htFyr8MHEOMKXVp4hZSstEPNai7leZLyvpdysSIExO+0++OYcsm8U + nTyJ5Ak8vZpfc1cV6PDtNZbU+dliVj6RO5YSWqI7E9pu9VJfliM0eyoTWj1VqbpGJdVStkRLoh6hShuv + 4VuGdgr/EZmXi8web/S9Fo8lNP1Cmn42TS8eWx9KxerzuKsboSX0XeJNVfKP6avv6Ym1wv5hz7CtczxX + 5xbmabQxhZbz9EtJvoDkwSyrWlo7LmF77bFwEwV0ICx+O0FpV0My077MfIBlWi5JPInrESn/KiylSj6T + TWUKI38yO5z5uO0G+XiIdjG1gDGHS6uA59ZzwfsLCiNdG4iM2v1cRmx8No9rJfcj8XjOeyPZavskPod8 + vvG+NHIZZvTz2wfP7tscxWlbvDEu3jABDd78KJSnD6P5rablQGzcUuTjQckNA88ikAqMz+QEzKFzIEet + gRw6Okfeh/RN/UVsx46kYG3bxVvCebO7OMQ9EruQhXxHW7u+W8zlnr692YwLsJl9EdIz7DhHrxViajpB + XBOOdFx8q/DkSu7OUcttLUcv/tpHPYbpgLSX4hCVIK2naDbocGIqjbLKS/e0z8QhZYOp82qD2K98KOWq + +fGZC1GleAV0jm87cZ60GBgr5Sy0SYwnrKWxsz1z/mbXyF/hmUFikuvQ+ddE9nQOoA78tfL/AeU81hvE + kRZxSr0qjomPzQdkGGoE3Eb5/psM8oFbDGUFEZp+v0u9/1RFH+iA6ET0ILRI6IkspPmQ3uKa8nPb0Nvo + S/Pr5Nudk3DXeFrBOJq347rlCqCZju38TmjMb4cKA/ey6k3OooxvCbeSxIvmqOa19mcNltd5bClWjn3E + KfZCHZ/TcFQFiM78DmhPotYxRR8oNvxWaMa1VcgzmPVKMsiHo5muJtGUo4OnzpPGqle8E952VxWxlIq1 + u8inAavEMe1pbZ8zaBH6AHaqAL+KbCJeoW7QbVgM4qlbhd2S6p+s4h51pWaKWlYrZKkuVUInYmt5p94o + acpYaT3jsHRYdlPsI+6K3cIrYu29i8TxDGBtNNMIDTotuaUmf63561pfkzdaEe6E9oNZhHbFQEKbj34J + ad2vXBqz/5lLNGg1p+sQOlToh4r6WSdcbU7/k7//Danm334SuwI4AAAAAElFTkSuQmCC - 122, 17 + 176, 17 @@ -265,17 +265,17 @@ - 181, 56 + 717, 17 - 238, 17 + 286, 17 - 17, 56 - - - 238, 17 + 565, 17 - 744, 17 + 403, 17 + + + 50 Index: branches/Abonament/TruckExpoCDN/ExportForm.Designer.cs =================================================================== --- branches/Abonament/TruckExpoCDN/ExportForm.Designer.cs (revision 479) +++ branches/Abonament/TruckExpoCDN/ExportForm.Designer.cs (revision 839) @@ -31,11 +31,11 @@ this.components = new System.ComponentModel.Container(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(ExportForm)); - System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle15 = new System.Windows.Forms.DataGridViewCellStyle(); - System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle16 = new System.Windows.Forms.DataGridViewCellStyle(); - System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle17 = new System.Windows.Forms.DataGridViewCellStyle(); - System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle19 = new System.Windows.Forms.DataGridViewCellStyle(); - System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle20 = new System.Windows.Forms.DataGridViewCellStyle(); - System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle21 = new System.Windows.Forms.DataGridViewCellStyle(); - System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle18 = new System.Windows.Forms.DataGridViewCellStyle(); + System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle1 = new System.Windows.Forms.DataGridViewCellStyle(); + System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle2 = new System.Windows.Forms.DataGridViewCellStyle(); + System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle3 = new System.Windows.Forms.DataGridViewCellStyle(); + System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle4 = new System.Windows.Forms.DataGridViewCellStyle(); + System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle5 = new System.Windows.Forms.DataGridViewCellStyle(); + System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle6 = new System.Windows.Forms.DataGridViewCellStyle(); + System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle7 = new System.Windows.Forms.DataGridViewCellStyle(); this.exportFakturToolStrip = new System.Windows.Forms.ToolStrip(); this.toolStripButton1 = new System.Windows.Forms.ToolStripButton(); @@ -49,13 +49,13 @@ this.EXPORTED = new System.Windows.Forms.DataGridViewCheckBoxColumn(); this.ID_FAKTURY = new System.Windows.Forms.DataGridViewTextBoxColumn(); + this.pelnynumerDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.ID_NABYWCY = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.DATA_WYSTAWIENIA = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.MIEJSCOWOSC_WYSTAWIENIA = new System.Windows.Forms.DataGridViewTextBoxColumn(); - this.backgroundWorker1 = new System.ComponentModel.BackgroundWorker(); - this.cbSelectAll = new System.Windows.Forms.CheckBox(); - this.pelnynumerDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.exportujDataGridViewCheckBoxColumn = new System.Windows.Forms.DataGridViewCheckBoxColumn(); this.fAKTURYBindingSource = new System.Windows.Forms.BindingSource(this.components); this.eXPODataSet = new ExportFaktur.EXPODataSet(); + this.backgroundWorker1 = new System.ComponentModel.BackgroundWorker(); + this.cbSelectAll = new System.Windows.Forms.CheckBox(); this.fAKTURYTableAdapter = new ExportFaktur.EXPODataSetTableAdapters.FAKTURYTableAdapter(); this.exportFakturToolStrip.SuspendLayout(); @@ -139,16 +139,16 @@ this.dataGridView1.AllowUserToAddRows = false; this.dataGridView1.AllowUserToDeleteRows = false; - dataGridViewCellStyle15.BackColor = System.Drawing.Color.MintCream; - this.dataGridView1.AlternatingRowsDefaultCellStyle = dataGridViewCellStyle15; + dataGridViewCellStyle1.BackColor = System.Drawing.Color.MintCream; + this.dataGridView1.AlternatingRowsDefaultCellStyle = dataGridViewCellStyle1; this.dataGridView1.AutoGenerateColumns = false; this.dataGridView1.BackgroundColor = System.Drawing.Color.White; - dataGridViewCellStyle16.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; - dataGridViewCellStyle16.BackColor = System.Drawing.SystemColors.Control; - dataGridViewCellStyle16.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(238))); - dataGridViewCellStyle16.ForeColor = System.Drawing.SystemColors.WindowText; - dataGridViewCellStyle16.SelectionBackColor = System.Drawing.SystemColors.Highlight; - dataGridViewCellStyle16.SelectionForeColor = System.Drawing.SystemColors.HighlightText; - dataGridViewCellStyle16.WrapMode = System.Windows.Forms.DataGridViewTriState.True; - this.dataGridView1.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle16; + dataGridViewCellStyle2.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; + dataGridViewCellStyle2.BackColor = System.Drawing.SystemColors.Control; + dataGridViewCellStyle2.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(238))); + dataGridViewCellStyle2.ForeColor = System.Drawing.SystemColors.WindowText; + dataGridViewCellStyle2.SelectionBackColor = System.Drawing.SystemColors.Highlight; + dataGridViewCellStyle2.SelectionForeColor = System.Drawing.SystemColors.HighlightText; + dataGridViewCellStyle2.WrapMode = System.Windows.Forms.DataGridViewTriState.True; + this.dataGridView1.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle2; this.dataGridView1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; this.dataGridView1.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] { @@ -180,15 +180,24 @@ // this.ID_FAKTURY.DataPropertyName = "ID_FAKTURY"; - dataGridViewCellStyle17.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; - this.ID_FAKTURY.DefaultCellStyle = dataGridViewCellStyle17; + dataGridViewCellStyle3.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; + this.ID_FAKTURY.DefaultCellStyle = dataGridViewCellStyle3; this.ID_FAKTURY.HeaderText = "ID FAKTURY"; this.ID_FAKTURY.Name = "ID_FAKTURY"; this.ID_FAKTURY.ReadOnly = true; // + // pelnynumerDataGridViewTextBoxColumn + // + this.pelnynumerDataGridViewTextBoxColumn.DataPropertyName = "Pelny_numer"; + dataGridViewCellStyle4.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; + this.pelnynumerDataGridViewTextBoxColumn.DefaultCellStyle = dataGridViewCellStyle4; + this.pelnynumerDataGridViewTextBoxColumn.HeaderText = "NUMER FAKTURY"; + this.pelnynumerDataGridViewTextBoxColumn.Name = "pelnynumerDataGridViewTextBoxColumn"; + this.pelnynumerDataGridViewTextBoxColumn.ReadOnly = true; + // // ID_NABYWCY // this.ID_NABYWCY.DataPropertyName = "ID_NABYWCY"; - dataGridViewCellStyle19.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; - this.ID_NABYWCY.DefaultCellStyle = dataGridViewCellStyle19; + dataGridViewCellStyle5.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; + this.ID_NABYWCY.DefaultCellStyle = dataGridViewCellStyle5; this.ID_NABYWCY.HeaderText = "ID NABYWCY"; this.ID_NABYWCY.Name = "ID_NABYWCY"; @@ -198,6 +207,6 @@ // this.DATA_WYSTAWIENIA.DataPropertyName = "DATA_WYSTAWIENIA"; - dataGridViewCellStyle20.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; - this.DATA_WYSTAWIENIA.DefaultCellStyle = dataGridViewCellStyle20; + dataGridViewCellStyle6.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; + this.DATA_WYSTAWIENIA.DefaultCellStyle = dataGridViewCellStyle6; this.DATA_WYSTAWIENIA.HeaderText = "DATA WYSTAWIENIA"; this.DATA_WYSTAWIENIA.Name = "DATA_WYSTAWIENIA"; @@ -207,9 +216,25 @@ // this.MIEJSCOWOSC_WYSTAWIENIA.DataPropertyName = "MIEJSCOWOSC_WYSTAWIENIA"; - dataGridViewCellStyle21.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; - this.MIEJSCOWOSC_WYSTAWIENIA.DefaultCellStyle = dataGridViewCellStyle21; + dataGridViewCellStyle7.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; + this.MIEJSCOWOSC_WYSTAWIENIA.DefaultCellStyle = dataGridViewCellStyle7; this.MIEJSCOWOSC_WYSTAWIENIA.HeaderText = "MIEJSCE"; this.MIEJSCOWOSC_WYSTAWIENIA.Name = "MIEJSCOWOSC_WYSTAWIENIA"; this.MIEJSCOWOSC_WYSTAWIENIA.ReadOnly = true; + // + // exportujDataGridViewCheckBoxColumn + // + this.exportujDataGridViewCheckBoxColumn.DataPropertyName = "Exportuj"; + this.exportujDataGridViewCheckBoxColumn.HeaderText = "EXPORTUJ"; + this.exportujDataGridViewCheckBoxColumn.Name = "exportujDataGridViewCheckBoxColumn"; + // + // fAKTURYBindingSource + // + this.fAKTURYBindingSource.DataMember = "FAKTURY"; + this.fAKTURYBindingSource.DataSource = this.eXPODataSet; + // + // eXPODataSet + // + this.eXPODataSet.DataSetName = "EXPODataSet"; + this.eXPODataSet.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // backgroundWorker1 @@ -233,29 +258,4 @@ this.cbSelectAll.UseVisualStyleBackColor = true; this.cbSelectAll.CheckedChanged += new System.EventHandler(this.cbSelectAll_CheckedChanged); - // - // pelnynumerDataGridViewTextBoxColumn - // - this.pelnynumerDataGridViewTextBoxColumn.DataPropertyName = "Pelny_numer"; - dataGridViewCellStyle18.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; - this.pelnynumerDataGridViewTextBoxColumn.DefaultCellStyle = dataGridViewCellStyle18; - this.pelnynumerDataGridViewTextBoxColumn.HeaderText = "NUMER FAKTURY"; - this.pelnynumerDataGridViewTextBoxColumn.Name = "pelnynumerDataGridViewTextBoxColumn"; - this.pelnynumerDataGridViewTextBoxColumn.ReadOnly = true; - // - // exportujDataGridViewCheckBoxColumn - // - this.exportujDataGridViewCheckBoxColumn.DataPropertyName = "Exportuj"; - this.exportujDataGridViewCheckBoxColumn.HeaderText = "EXPORTUJ"; - this.exportujDataGridViewCheckBoxColumn.Name = "exportujDataGridViewCheckBoxColumn"; - // - // fAKTURYBindingSource - // - this.fAKTURYBindingSource.DataMember = "FAKTURY"; - this.fAKTURYBindingSource.DataSource = this.eXPODataSet; - // - // eXPODataSet - // - this.eXPODataSet.DataSetName = "EXPODataSet"; - this.eXPODataSet.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // fAKTURYTableAdapter Index: branches/Abonament/TruckExpoCDN/ExpoToCDNExport.cs =================================================================== --- branches/Abonament/TruckExpoCDN/ExpoToCDNExport.cs (revision 479) +++ branches/Abonament/TruckExpoCDN/ExpoToCDNExport.cs (revision 839) @@ -7,17 +7,8 @@ class ExpoToCDNExport { - - #region Fields (3) - public CDNDataSet CDNDataset; readonly SqlConnection CDN_conn = new SqlConnection(ConnString.CDNConnection); - #endregion Fields - - #region Methods (10) - - // Public Methods (10)  - public void DodajElementyFaktury(EXPODataSet.FAKTURA_DETAILSDataTable table, CDNDataSet.TraNagRow naglowekFaktury) { @@ -60,5 +51,6 @@ pozycjaFaktury.TrE_TwrOpis = ""; pozycjaFaktury.TrE_TwrSWW = ""; - pozycjaFaktury.TrE_Stawka = (decimal)row.S_VAT * 100; //svat' @P14 numeric(5,2) 22.00 + pozycjaFaktury.TrE_Stawka = (decimal)row.S_VAT * 100; + //svat' @P14 numeric(5,2) 22.00 pozycjaFaktury.TrE_Flaga = 2; pozycjaFaktury.TrE_Zrodlowa = 0.00M; @@ -66,24 +58,12 @@ pozycjaFaktury.TrE_TypNB = 1; - - pozycjaFaktury.TrE_CenaT = row.NETTO; //Math.Abs(rsdet("netto")); - // pozycjaFaktury.TrE_CenaT = row.CENA_JEDN; //Math.Abs(rsdet("netto")); - - - pozycjaFaktury.TrE_Cena0 = row.NETTO; //Math.Abs(netto); - //pozycjaFaktury.TrE_Cena0 = row.CENA_JEDN; //Math.Abs(netto); + pozycjaFaktury.TrE_CenaT = row.NETTO; + + pozycjaFaktury.TrE_Cena0 = row.NETTO; pozycjaFaktury.TrE_Rabat = (decimal)row.UPUST_PR * 100; - // pozycjaFaktury.TrE_Rabat = 0; - pozycjaFaktury.TrE_CenaW = row.NETTO; //Math.Abs(netto); - - - /* - * if rsdet("netto")<0 then - pozycjaFaktury.TrE_Ilosc")=-1.0000' @P27 numeric(15,4) 1.0000 - else - pozycjaFaktury.TrE_Ilosc=1.0000' @P27 numeric(15,4) 1.0000 - end if */ + pozycjaFaktury.TrE_CenaW = row.NETTO; + + pozycjaFaktury.TrE_Ilosc = 1M; - pozycjaFaktury.TrE_Jm = "szt."; @@ -92,15 +72,15 @@ pozycjaFaktury.TrE_JMPrzelicznikM = 1; pozycjaFaktury.TrE_IloscJM = pozycjaFaktury.TrE_Ilosc; - pozycjaFaktury.TrE_WartoscNetto = row.NETTO; //rsdet("netto")' @P33 numeric(15,2) 1000.00 - pozycjaFaktury.TrE_WartoscBrutto = row.BRUTTO; //rsdet("brutto")' @P34 numeric(15,2) 1220.00 + pozycjaFaktury.TrE_WartoscNetto = row.NETTO; + pozycjaFaktury.TrE_WartoscBrutto = row.BRUTTO; pozycjaFaktury.TrE_TwrEAN = ""; pozycjaFaktury.TrE_TwrNumerKat = ""; - pozycjaFaktury.TrE_TwrKod = "REKLAMA PRASOWA"; //towarkod' @P37 varchar(3) '125' + pozycjaFaktury.TrE_TwrKod = "REKLAMA PRASOWA"; pozycjaFaktury.TrE_JmZ = ""; pozycjaFaktury.TrE_LpPow = lp; - pozycjaFaktury.TrE_Cena0WD = row.CENA_JEDN; //abs(rsdet("netto"))' @P40 numeric(15,2) 1000.00 - pozycjaFaktury.TrE_CenaWWD = row.NETTO;//abs(rsdet("netto"))' @P41 numeric(15,2) 1000.00 - pozycjaFaktury.TrE_WartoscNettoWal = row.NETTO; //rsdet("netto")' @P42 numeric(15,2) 1000.00 - pozycjaFaktury.TrE_WartoscBruttoWal = row.BRUTTO; //rsdet("brutto")' @P43 numeric(15,2) 1220.00 + pozycjaFaktury.TrE_Cena0WD = row.CENA_JEDN; + pozycjaFaktury.TrE_CenaWWD = row.NETTO; + pozycjaFaktury.TrE_WartoscNettoWal = row.NETTO; + pozycjaFaktury.TrE_WartoscBruttoWal = row.BRUTTO; pozycjaFaktury.TrE_Prog = 0.00M; pozycjaFaktury.TrE_UpustTyp = 0; @@ -116,24 +96,16 @@ pozycjaFaktury.TrE_MagId = 1; - // ????????????????????????????? - // pozycjaFaktury.TrE_Atr1_DeAId = DBNull.Value; pozycjaFaktury.TrE_Atr1_Kod = ""; pozycjaFaktury.TrE_Atr1_Wartosc = ""; - // pozycjaFaktury.TrE_Atr2_DeAId = DBNull.Value; pozycjaFaktury.TrE_Atr2_Kod = ""; pozycjaFaktury.TrE_Atr2_Wartosc = ""; - // pozycjaFaktury.TrE_Atr3_DeAId = DBNull.Value; pozycjaFaktury.TrE_Atr3_Kod = ""; pozycjaFaktury.TrE_Atr3_Wartosc = ""; - // pozycjaFaktury.TrE_Atr4_DeAId = DBNull.Value; pozycjaFaktury.TrE_Atr4_Kod = ""; pozycjaFaktury.TrE_Atr4_Wartosc = ""; - // pozycjaFaktury.TrE_Atr5_DeAId = DBNull.Value; pozycjaFaktury.TrE_Atr5_Kod = ""; pozycjaFaktury.TrE_Atr5_Wartosc = ""; - pozycjaFaktury.TrE_WartoscZakupuWylicz = 0; - //'pozycjaFaktury.TrE_WartoscZakupu=0 pozycjaFaktury.TrE_Waluta = "PLN"; @@ -155,6 +127,4 @@ lp++; } - - } @@ -238,7 +208,4 @@ if (!klient.IsNipNull()) { - // kontrahent.Knt_NipKraj = PodajKrajNIP(klient.Nip); - // kontrahent.Knt_NipE = PodajNumerNIP(klient.Nip); - // kontrahent.Knt_Nip = PodajNumerNIP(klient.Nip); if (klient.nipKraj == "" && klient.Country.Trim() == "Polska") { @@ -284,8 +251,6 @@ kontrahent.Knt_Zezwolenie = ""; kontrahent.Knt_KodTransakcji = ""; - //kontrahent.Knt_BNaID="" kontrahent.Knt_RachunekNr = ""; kontrahent.Knt_IBAN = 0; - //kontrahent.Knt_RachunekNr0="" kontrahent.Knt_OsTytul = ""; kontrahent.Knt_OsPlec = 1; @@ -318,5 +283,4 @@ kontrahent.Knt_KontoOdb = ""; kontrahent.Knt_KontoDost = ""; - //kontrahent.Knt_KatID= kontrahent.Knt_BlokadaDok = 0; kontrahent.Knt_LimitKredytuWal = ""; @@ -344,13 +308,7 @@ kontrahent.Knt_Chroniony = 0; kontrahent.Knt_Opis = ""; - //kontrahent.Knt_OdbiorcaId= - //kontrahent.Knt_OpiekunTyp= - //kontrahent.Knt_OpiekunId= kontrahent.Knt_TerminZwrotuKaucji = 60; kontrahent.Knt_NaliczajPlatnosc = 0; kontrahent.Knt_ZakazDokumentowHaMag = 0; - //'kontrahent.Knt_TS_Export= - //'kontrahent.Knt_ImportAppId= - //'kontrahent.Knt_ImportRowId= kontrahent.Knt_OpeZalID = 11; kontrahent.Knt_StaZalId = 6; @@ -361,8 +319,4 @@ kontrahent.Knt_StaModId = 6; kontrahent.Knt_TS_Mod = DateTime.Now; - //kontrahent.Knt_GIDTyp= - //kontrahent.Knt_GIDFirma= - //kontrahent.Knt_GIDNumer= - //kontrahent.Knt_GIDLp= if (!klientIstnieje) @@ -378,8 +332,6 @@ CDNDataSet.TraNagRow nowaFaktura = (CDNDataSet.TraNagRow)CDNDataset.TraNag.NewRow(); - //!!!!!!!!!!!!!!! - //nowaFaktura.TrN_DDfId = 1; - - CDNDataSetTableAdapters.DokDefinicjeTableAdapter adapter = new CDNDataSetTableAdapters.DokDefinicjeTableAdapter(); + CDNDataSetTableAdapters.DokDefinicjeTableAdapter adapter = + new CDNDataSetTableAdapters.DokDefinicjeTableAdapter(); adapter.Connection = CDN_conn; @@ -390,7 +342,7 @@ nowaFaktura.TrN_NumerNr = EXPOfaktura.NUMER; - nowaFaktura.TrN_NumerString = "@numerS" + "/" + EXPOfaktura.NUMER_ROZ + "/" + EXPOfaktura.NUMER_ROK; //numerstring' @P4 varchar(13) '@numer/O/2007' - - // 'rsnag("TrN_NumerPelny=numerpelny + nowaFaktura.TrN_NumerString = "@numerS" + "/" + EXPOfaktura.NUMER_ROZ + "/" + EXPOfaktura.NUMER_ROK; + //numerstring' @P4 varchar(13) '@numer/O/2007' + nowaFaktura.TrN_Bufor = 1; nowaFaktura.TrN_DataDok = EXPOfaktura.DATA_WYSTAWIENIA; @@ -419,12 +371,4 @@ nowaFaktura.TrN_PodNazwa2 = kontrahent.Knt_Nazwa2; nowaFaktura.TrN_PodNazwa3 = kontrahent.Knt_Nazwa3; - - /* - if (kontrahent.Knt_Kraj){ - nowaFaktura.TrN_PodKraj="Polska"; - } - else { - nowaFaktura.TrN_PodKraj=kontrahent.Knt_Kraj; - }*/ nowaFaktura.TrN_PodKraj = kontrahent.Knt_Kraj; @@ -468,9 +412,4 @@ - //w zaleznosci od handlowca - /* - nowaFaktura.TrN_KatID = 42; - nowaFaktura.TrN_Kategoria = "Dorota"; - */ nowaFaktura.TrN_KatID = 1; nowaFaktura.TrN_Kategoria = "SPRZEDA¯"; @@ -487,8 +426,8 @@ nowaFaktura.TrN_TypNB = 1; nowaFaktura.TrN_Rabat = rabatProcent * 100; - //nowaFaktura.TrN_Rabat = 0; - - - nowaFaktura.TrN_Odebral = EXPOfaktura.IsPODPIS_ODEBRALNull() ? "zgodnie z oœwiadczeniem nabywcy" : EXPOfaktura.PODPIS_ODEBRAL; + + nowaFaktura.TrN_Odebral = EXPOfaktura.IsPODPIS_ODEBRALNull() + ? "zgodnie z oœwiadczeniem nabywcy" + : EXPOfaktura.PODPIS_ODEBRAL; nowaFaktura.TrN_Opis = EXPOfaktura.opis; @@ -517,9 +456,6 @@ nowaFaktura.TrN_StaZalId = 1; nowaFaktura.TrN_StaModId = 1; - // 'rsnag("TrN_PodNipKraj=""' @P84 varchar(1) '' - // 'rsnag("TrN_OdbNipKraj="" ' @P85 varchar(1) '' nowaFaktura.TrN_KodTransakcji = ""; - //??? DateTime datadok = DateTime.Now; nowaFaktura.TrN_DataTransportu = datadok; @@ -545,5 +481,4 @@ CDNDataset.TraNag.AddTraNagRow(nowaFaktura); - } @@ -682,8 +617,4 @@ return false; } - - - #endregion Methods - } } Index: branches/Abonament/TruckExpoCDN/ExportForm.cs =================================================================== --- branches/Abonament/TruckExpoCDN/ExportForm.cs (revision 482) +++ branches/Abonament/TruckExpoCDN/ExportForm.cs (revision 839) @@ -16,5 +16,5 @@ KLIENCITableAdapter klientAdapter = new KLIENCITableAdapter(); FAKTURA_DETAILSTableAdapter fakturyDetailsAdapter = new FAKTURA_DETAILSTableAdapter(); - + KontrahenciTableAdapter kontrahenciAdapter = new KontrahenciTableAdapter(); TraElemTableAdapter TraElemAdapter = new TraElemTableAdapter(); @@ -26,5 +26,5 @@ int nMaxProgress; - + public ExportForm() { @@ -48,8 +48,8 @@ private void ExportForm_Load(object sender, EventArgs e) { - refresh(); - } - - private void refresh() + RefreshView(); + } + + private void RefreshView() { fAKTURYTableAdapter.FillByNotExported(eXPODataSet.FAKTURY); @@ -58,5 +58,5 @@ nMaxProgress = eXPODataSet.FAKTURY.Count; - + toolStripProgressBar1.Value = 0; } @@ -66,5 +66,5 @@ dataGridView1.EndEdit(); dataGridView1.Refresh(); - + if (backgroundWorker1.IsBusy) { @@ -79,5 +79,5 @@ backgroundWorker1.RunWorkerAsync(); - + } @@ -85,12 +85,12 @@ { int n = 0; - + conn.Open(); - + foreach (EXPODataSet.FAKTURYRow row in eXPODataSet.FAKTURY.Rows) { if (!backgroundWorker1.CancellationPending) - { - + { + if (row.Exportuj) { @@ -133,5 +133,5 @@ { transaction.Rollback(); - conn.Close(); + //Send Email StringBuilder stringBuilder = new StringBuilder(); @@ -139,5 +139,10 @@ stringBuilder.AppendLine("Szczegoly:"); stringBuilder.AppendLine(exception.ToString()); + + conn.Close(); + bazaReklamConn.Close(); + EmailSender.Send(stringBuilder.ToString()); + throw; } @@ -155,7 +160,6 @@ else { - conn.Close(); - e.Cancel = true; + e.Cancel = true; } } @@ -169,5 +173,5 @@ conn.Close(); } - + } @@ -178,5 +182,5 @@ return; } - + if (toolStripProgressBar1.Maximum != nMaxProgress) { @@ -191,5 +195,5 @@ private void backgroundWorker1_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e) - { + { if (e.Cancelled) { @@ -209,5 +213,5 @@ } - refresh(); + RefreshView(); } @@ -215,5 +219,5 @@ { if (backgroundWorker1.IsBusy) - { + { backgroundWorker1.CancelAsync(); } @@ -224,5 +228,5 @@ if (!backgroundWorker1.IsBusy) { - refresh(); + RefreshView(); } } Index: branches/Abonament/TruckExpoCDN/EXPODataSet.xsd =================================================================== --- branches/Abonament/TruckExpoCDN/EXPODataSet.xsd (revision 479) +++ branches/Abonament/TruckExpoCDN/EXPODataSet.xsd (revision 839) @@ -528,5 +528,5 @@ - SELECT BYL_WYDRUK, DATA_SPRZEDAZY, DATA_WYSTAWIENIA, EKSPORT, EXPORTED, EXPORTED_DATA, FAKTURA_PODTYP, FAKTURA_TYP, ID_FAKTURY, ID_FK_KOR, ID_KONTA, ID_NABYWCY, ID_SPRZEDAWCY, ID_TYTUL, KOREKTA, MIEJSCOWOSC_WYSTAWIENIA, NABYWCA_ADRES, NABYWCA_NIP, NUMER, NUMER_ROK, NUMER_ROZ, PODPIS_ODEBRAL, PODPIS_WYSTAWIL, SPOSOB_ZAPLATY, SPRZEDAWCA_ADRES, SPRZEDAWCA_NIP, TERMIN_ZAPLATY, ZAPLACONO, Zaliczka_Brutto, Zaliczka_Data, opis, suma_zaplat, waluta_brutto, waluta_kurs, waluta_kurs_z_dnia, waluta_miano, waluta_przelicznik, waluta_tabela_nr, zaplata_data, zaplata_opis FROM FAKTURY WHERE (NUMER_ROK >= 2008) AND (EXPORTED = 0) AND (SystemKsiegowyId = 2) ORDER BY ID_NABYWCY + SELECT BYL_WYDRUK, DATA_SPRZEDAZY, DATA_WYSTAWIENIA, EKSPORT, EXPORTED, EXPORTED_DATA, FAKTURA_PODTYP, FAKTURA_TYP, ID_FAKTURY, ID_FK_KOR, ID_KONTA, ID_NABYWCY, ID_SPRZEDAWCY, ID_TYTUL, KOREKTA, MIEJSCOWOSC_WYSTAWIENIA, NABYWCA_ADRES, NABYWCA_NIP, NUMER, NUMER_ROK, NUMER_ROZ, PODPIS_ODEBRAL, PODPIS_WYSTAWIL, SPOSOB_ZAPLATY, SPRZEDAWCA_ADRES, SPRZEDAWCA_NIP, TERMIN_ZAPLATY, ZAPLACONO, Zaliczka_Brutto, Zaliczka_Data, opis, suma_zaplat, waluta_brutto, waluta_kurs, waluta_kurs_z_dnia, waluta_miano, waluta_przelicznik, waluta_tabela_nr, zaplata_data, zaplata_opis FROM FAKTURY WHERE (NUMER_ROK >= 2008) AND (EXPORTED = 0) AND (SystemKsiegowyId = 2) AND KOREKTA=0 ORDER BY ID_NABYWCY @@ -1292,7 +1292,7 @@ - - - + + + @@ -1301,7 +1301,7 @@ - - - + + + @@ -1310,8 +1310,8 @@ - - - - + + + + @@ -1320,5 +1320,5 @@ - + @@ -1327,5 +1327,5 @@ - + @@ -1334,5 +1334,5 @@ - + @@ -1341,8 +1341,8 @@ - - - - + + + + @@ -1351,5 +1351,5 @@ - + @@ -1358,5 +1358,5 @@ - + @@ -1365,5 +1365,5 @@ - + @@ -1372,16 +1372,16 @@ - - - - - - - - - - - - + + + + + + + + + + + + @@ -1390,8 +1390,8 @@ - - - - + + + + @@ -1400,8 +1400,8 @@ - - - - + + + + @@ -1410,6 +1410,6 @@ - - + + @@ -1418,9 +1418,9 @@ - - - - - + + + + + @@ -1429,5 +1429,5 @@ - + @@ -1436,5 +1436,5 @@ - + @@ -1443,16 +1443,16 @@ - - - - - - - - - - - - + + + + + + + + + + + + @@ -1461,6 +1461,6 @@ - - + + @@ -1469,5 +1469,5 @@ - + @@ -1476,5 +1476,5 @@ - + @@ -1483,5 +1483,5 @@ - + @@ -1490,5 +1490,5 @@ - + @@ -1497,5 +1497,5 @@ - + @@ -1504,5 +1504,5 @@ - + @@ -1511,5 +1511,5 @@ - + @@ -1518,5 +1518,5 @@ - + @@ -1525,5 +1525,5 @@ - + @@ -1532,5 +1532,5 @@ - + @@ -1539,5 +1539,5 @@ - + @@ -1546,5 +1546,5 @@ - + @@ -1553,6 +1553,6 @@ - - + + @@ -1561,6 +1561,6 @@ - - + + @@ -1569,6 +1569,6 @@ - - + + @@ -1577,7 +1577,7 @@ - - - + + + @@ -1586,5 +1586,5 @@ - + @@ -1593,6 +1593,6 @@ - - + + @@ -1601,5 +1601,5 @@ - + @@ -1608,6 +1608,6 @@ - - + + @@ -1616,5 +1616,5 @@ - + @@ -1623,5 +1623,5 @@ - +