Index: trunk/BazaReklam/ZestawienieZamowienForm.resx =================================================================== --- trunk/BazaReklam/ZestawienieZamowienForm.resx (revision 790) +++ trunk/BazaReklam/ZestawienieZamowienForm.resx (revision 791) @@ -199,5 +199,5 @@ iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8 - YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAACZ5JREFUWEellwlU + YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAACZ9JREFUWEellwlU lOUax19AwwVScYmkEFxCQQS83YtLat5cTlGWp4yyyDQ0DVEyFB3QGVlkhxEQEXBDDAoIIwoRZRnWYRcY UGAYFlklBEREQP73eYG695yr515ozvmf75vvm3l//+d5t+dVYs/5RO5nG7oG2B5lFWasqsImqaiyjsGn @@ -213,33 +213,33 @@ RYVi4HJW0WO3c+c77GwONpq9/fYXo+NgXLNBufeCSSmSD9CItx8xIaWBVxqIRwQPDQ2GVFGP1oFetPT1 oqqzE9cb2nrPSO5UeUhqqtwSiu8dFxztXmlqupNMzBzPlFRqPW8SjFhzIO0wILEDMu0xWJOISIpcIleg - beAxegefoP1xD6ofdCBdoXgYJJFV+SQVVzmlVMqdE4ua9++2kKuqqr5FBtTH3BWZYoN3nYWrhpBiA9yi - TOT7oirnZwRFRKG27xG6+vvQP9CPh2REKBQOSeqaHwSklVT6JMmqXBLLq13S6muFgYE9hkuXehJcbzzL - 89TmQKN0RG0Fkmg9KL2EXyND8GOeDNXdvZB3P8T93h7UdnYhu/F+71VpRRU34JVcXn0yoUzudkte73mz - rM1s88YEgr9NenGsWVAWbNVa0SNe3IqoLTQDIhF62h3xNZ3Ib+2A7H4nitt+H44+5nZDV0RxU7svpf9U - oqza/rcyuVdqdYNzYn2z5S6LYgLvJmmOycBjVz0d+Te6sWX7dAf7vZfQQHRHkJcTou624paiBck1TUiv - aUZSRQN+KW3AxULFwIX8uu6TCaVyu1/KavwkVU3C1IaWXZ+bFxH4OxLfqv+/T6/bsjfaDum2PxAZoEuo - h3zbTSgqLsKVc34IzaxARHk7ImX38WN+LaKL6/BDUR2u0n1IRg2EqTV9wtT6zgvShhYvibx97SrT62My - wCPn8D5fIwz4G+Oh8xIU2KxBTGoeYuPi4R0Wi+CSh7iYXYvLeQqE5dbiYk4tgjMVCJDUwPWGnL4rBoRZ - dd1eV64+0tTUDB1TF/Qf07vW6bwUCP4bBs+YoM/bEPWWc5FyaAtK4iPh6Xgcgcl3EZjdiLMZCgSSAiQK - eKUSPKkGl6WNCM1tRXBcY7+5vv7glClTAgwNDS3JxKz/uTI+cVhgkLJu4dMnYmM8OW2EPl9jPPJYhi4n - fTQd0EGD3SqUhnvCVXQcfilV8M5shVjSAL/UOpzLbEB4YQs801oQIm2F9Z6vEBoSzAdpr0fQ+afLtWau - H10Zn788d1npOjZ99xp63A3xyM0QPa5L0elkgA7hErQJ9NB8+DW0+JqjmEw4Hz2IgPAYBKUr4JPRCp/0 - NlyStiEsJgHbt5rBTyxG++8duFPXhh9tzJBjwqRLJrC1ZGLKczPRsmuepPWoHh44GuDBSX10iPTRzuHH - FqPJ9jXUH1iImr3zUSt4C3XfuyHa/Sg8j1jDy94WHoJDEO3bifNHrJDjLYKb6ARK7tbj1/Bj6Pv5PcBz - FWrWq+X/XZ2tfKaJbYyp3N0++/c2wWK0HtOjiBcPg1vs9NBEkTccXAiF1XxUW+qg4gttlFksQKX9Vih8 - baAIdID8tAAy0T5Iv9wMmd8puIsDcPbQZ+iJeoe2cWsg2QLwXoO69WpFq9XYG/9lovwD9ZnCD7SGeKRN - 3y1Coy3p0CLcs1mEemuC7yP4bl1U7pgH2fZXcfsjLRRseRk5m19CxvrZSF01E0mvT0eC4YtIXKmLXG8X - 1JstwaDAGEjcTvXEfiDlC8BnLe5tVC9ZrzbcHVP/7I7Cf2ro55lpos56AeS759N1IWqtFgyD5V/rouor - HdwZhZds00LhB3OR+44msjbMgWTtLKSumIHrRi/iNwN1/LxwKuKMtVB0/AjaPzHqhr0RkPDpiInUHYDv - ajSYzS7f8tGnB8nADJIKK143Y2nKullPZdu1h6NR7CPobh1U7tLB3S/nocKC0v7pq/gDzs1mb5yD9Ddn - IWWVBpJXzsBZRnUhZYAbiHl1MsI1JkNy+HB9tJHSTRxbBsR/TMXMXtrcPsNPP/2Eww4OFQTnu+Vw/Tjx - eyN1m0STyd3J/9BA5U4dVHH4Dh2Uf64NmfkrKKa0F73/MvLe1YR08xxkvjUHaWso+pUaSFmhgfMTlRG3 - SA3h0ydCqKw05MxYoYmKyiWad943TSbE44g+EGOGe021yM4rwvLly3n59g1pLjfA5+esZZOUzUXaqhHR - ei/cTzKZjrQ3ZkK6SRMF772MAkp7wftzkU/R89SnUuQJS6chWpuinUFQxob8GVNQKXRNi7Hz1F4AyZa0 - iWp00yxjFhvu7wFJdgFc3dygp6cXRu92kGb/sUmo0A2vYF6nA95Ok8lKHuZqE67Yqk244aqufNt3qkqt - eKJKq6cya3NjrN6BMdl+xtI/ZCz2dcYuURl8bhQqoiuvhtaQdEl8K55sYGr65lGBqNnY2CRcV1f3kpKS - Eq8VNo2+/8PDcCZUSXNIS0hvkniVSywmIDmRXEfF78kH+3YUyM8DpiR+MuL/54eT/6wJ+XfyyvaSeOS8 - /3n6n3mW5Eb4C75y8azwH/KD5/xRAIfwex3SK6NAPpi4eQ591pLLn/Gpx9viaeel2jD8XxybB3qHlpse - AAAAAElFTkSuQmCC + beAxegefoP1xD6ofdCBdoXgYJJFV+SQVVzmlVMqdE4ua9++2kKuqqr5FBtTH3BWZYoN3TwpXDSHFBrhF + mcj3RVXOzwiKiEJt3yN09fehf6AfD8mIUCgcktQ1PwhIK6n0SZJVuSSWV7uk1dcKAwN7DJcu9SS43niW + 56nNgUbpiNoKJNF6UHoJv0aG4Mc8Gaq7eyHvfoj7vT2o7exCduP93qvSiipuwCu5vPpkQpnc7Za83vNm + WZvZ5o0JBH+b9OJYs6As2Kq1oke8uBVRW2gGRCL0tDviazqR39oB2f1OFLf9Phx9zO2GrojipnZfSv+p + RFm1/W9lcq/U6gbnxPpmy10WxQTeTdIck4HHrno68m90Y8v26Q72ey+hgeiOIC8nRN1txS1FC5JrmpBe + 04ykigb8UtqAi4WKgQv5dd0nE0rldr+U1fhJqpqEqQ0tuz43LyLwdyS+Vf9/n163ZW+0HdJtfyAyQJdQ + D/m2m1BUXIQr5/wQmlmBiPJ2RMru48f8WkQX1+GHojpcpfuQjBoIU2v6hKn1nRekDS1eEnn72lWm18dk + gEfO4X2+RhjwN8ZD5yUosFmDmNQ8xMbFwzssFsElD3ExuxaX8xQIy63FxZxaBGcqECCpgesNOX1XDAiz + 6rq9rlx9pKmpGTqmLug/pnet03kpEPw3DJ4xQZ+3Ieot5yLl0BaUxEfC0/E4ApPvIjC7EWczFAgkBUgU + 8EoleFINLksbEZrbiuC4xn5zff3BKVOmBBgaGlqSiVn/c2V84rDAIGXdwqdPxMZ4ctoIfb7GeOSxDF1O + +mg6oIMGu1UoDfeEq+g4/FKq4J3ZCrGkAX6pdTiX2YDwwhZ4prUgRNoK6z1fITQkmA/SXo+g80+Xa81c + P7oyPn957rLSdWz67jX0uBvikZshelyXotPJAB3CJWgT6KH58Gto8TVHMZlwPnoQAeExCEpXwCejFT7p + bbgkbUNYTAK2bzWDn1iM9t87cKeuDT/amCHHhEmXTGBrycSU52aiZdc8SetRPTxwNMCDk/roEOmjncOP + LUaT7WuoP7AQNXvno1bwFuq+d0O0+1F4HrGGl70tPASHINq3E+ePWCHHWwQ30QmU3K3Hr+HH0Pfze4Dn + KtSsV8v/uzpb+UwT2xhTubt99u9tgsVoPaZHES8eBrfY6aGJIm84uBAKq/mottRBxRfaKLNYgEr7rVD4 + 2kAR6AD5aQFkon2QfrkZMr9TcBcH4Oyhz9AT9Q5t49ZAsgXgvQZ169WKVquxN/7LRPkH6jOFH2gN8Uib + vluERlvSoUW4Z7MI9dYE30fw3bqo3DEPsu2v4vZHWijY8jJyNr+EjPWzkbpqJpJen44EwxeRuFIXud4u + qDdbgkGBMZC4neqJ/UDKF4DPWtzbqF6yXm24O6b+2R2F/9TQzzPTRJ31Ash3z6frQtRaLRgGy7/WRdVX + OrgzCi/ZpoXCD+Yi9x1NZG2YA8naWUhdMQPXjV7Ebwbq+HnhVMQZa6Ho+BG0f2LUDXsjIOHTEROpOwDf + 1Wgwm12+5aNPD5KBGSQVVrxuxtKUdbOeyrZrD0ej2EfQ3Tqo3KWDu1/OQ4UFpf3TV/EHnJvN3jgH6W/O + QsoqDSSvnIGzjOpCygA3EPPqZIRrTIbk8OH6aCOlmzi2DIj/mIqZvbS5fYaffvoJhx0cKgjOd8vh+nHi + 90bqNokmk7uT/6GByp06qOLwHToo/1wbMvNXUExpL3r/ZeS9qwnp5jnIfGsO0tZQ9Cs1kLJCA+cnKiNu + kRrCp0+EUFlpyJmxQhMVlUs077xvmkyIxxF9IMYM95pqkZ1XhOXLl/Py7RvSXG6Az89ZyyYpm4u0VSOi + 9V64n2QyHWlvzIR0kyYK3nsZBZT2gvfnIp+i56lPpcgTlk5DtDZFO4OgjA35M6agUuiaFmPnqb0Aki1p + E9XoplnGLDbc3wOS7AK4urlBT08vjN7tIM3+Y5NQoRtewbxOB7ydJpOVPMzVJlyxVZtww1Vd+bbvVJVa + 8USVVk9l1ubGWL0DY7L9jKV/yFjs64xdojL43ChURFdeDa0h6ZL4VjzZwNT0zaMCUbOxsUm4rq7uJSUl + JV4rbBp9/4eH4UyokuaQlpDeJPEql1hMQHIiuY6K35MP9u0okJ8HTEn8ZMT/zw8n/1kT8u/kle0l8ch5 + //P0P/MsyY3wF3zl4lnhP+QHz/mjAA7h9zqkV0aBfDBx8xz6rCWXP+NTj7fF085LtWH4vwAAIQd37nCS + pwAAAABJRU5ErkJggg== @@ -275,28 +275,28 @@ iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8 YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAABXRJREFUSEuVlQtQ - VFUYx10VG0JbMg0ZSGAmncpycPIxlqESW1CoEYyMj5BU1NDMCgNcl8tjWFDQQZHAlZVhWQQUYuQlaqRi + VFUYx10VG0JbMg0ZSGAmncpycPIxlqESW1CoEYyMj5BU1NDMCgNclwvs8FDQQZHAlZVhWQQUYuQlaqRi giSKBIK8BFFYQJLF5c3u/vvOzlIqC9aZ+c3de+49//89337fd3gTxhnbth034vONjsycaeTW1vakQ6F4 - kD883Judnh79By0bJKBnPJmxn4WG5ombmtrBhlYLVFU1g+M4rY/P0YYNG/yPuLjssKfVLxMTCd7/comI - kJlIJJe6derPDWZWXf1AZ7ZzZ0ijm5v3sVWrPAVkYEJM+k9GwcH5zjdu1BnSHzUXFhYDV9ftWldXr2ZH - x6/EJiYmZmRiNK5RQEB6qFLZ80KDuLhE7NoVheJiIC3tIYTCVMyfb5dA4jbjmvj6pmb8q04xMTCGhgax - bp0I/v7JWLjwY5SUDKOmBnB09Ggj8XXEjDF3IRZn3mSaQ0MaqNWGDTIzz2HLlkhERBRAJJKgtRV49AhY - tGhZNQmLCKuxDHgxMXltGg3Q3z+Mri4lTiXLERIYiODgQEglErS0PER6ev7grFmzU5YuXdG4ceO3uHhR - ieXLIzV8/qsyEt5LWBo0OH/+vAnH/aoeGNCgtaUNJ5OSUdTchgo1UPgEOHOnHcekMqTIU3tIIJGy1Mfc - 3OywlZVN2rRpphKaO0g4EnyDBomJF97mOLG2s7Mb8TI5OilU/UTLoAaljweR96Afp+5Dl6YWFhbRJGJH - vEt8SrgRHxGvj5mysbEZgvLyezh7NgvXWrugJHE1JX9dnxrFnf3Ivt8HebUK8rs98PLcdIuEnIjpxDT9 - ldUDK75nBqtEXTWGhMRtundPQfEOwXUVUN+rRpVqCNdJvEDRh4x6FU5WKJFYo4WPj4+Klvygj/foaj50 - qHJ6QkJdklxecVMkyhQ7OHjO2bFDuK+x8RG4oCDktgG/tfThsqIf+c29ONugQnJVN2JuKyGv1WDffhH7 - H8KJNw3GOzQ0O1WlYhEGOjpoYUxGj6vrnvrKylZERx2FjMJwuqEXp+u6kUbIKpWIvd0FyS0lkmq12Lp1 + kD883Judnh79By0bJKBnPJmxn4WE5IU2NbWDDa0WqKpqBsdxWh+fow0bNvgfcXHZYU+rXyYmErz/5RIR + ITORSC5169SfG8ysuvqBzmznTnGjm5v3sVWrPAVkYEJM+k9GwcH5zjdu1BnSHzUXFhYDV9ftWldXr2ZH + x69CTUxMzMjEaFyjgID0EKWy54UGcXGJ2LUrCsXFQFraQwiFqZg/3y6BxG3GNfH1Tc34V51iYmAMDQ1i + 3ToR/P2TsXDhxygpGUZNDeDo6NFG4uuIGWPuIjQ08ybTHBrSQK02bJCZeQ5btkQiIqIAIpEEra3Ao0fA + okXLqklYRFiNZcCLiclr02iA/v5hdHUpcSpZDnFgIIKDAyGVSNDS8hDp6fmDs2bNTlm6dEXjxo3f4uJF + JZYvj9Tw+a/KSHgvYWnQ4Pz58yYc96t6YECD1pY2nExKRlFzGyrUQOET4MyddhyTypAiT+0hgUTKUh9z + c7PDVlY2adOmmUpo7iDhSPANGiQmXnib48Tazs5uxMvk6KRQ9RMtgxqUPh5E3oN+nLoPXZpaWFhEk4gd + 8S7xKeFGfES8PmbKxsZmCMrL7+Hs2Sxca+2CksTVlPx1fWoUd/Yj+34f5NUqyO/2wMtz0y0SciKmE9P0 + V1YPrPieGawSddUoFsdtundPQfEW47oKqO9Vo0o1hOskXqDoQ0a9CicrlEis0cLHx0dFS37Qx3t0NR86 + VDk9IaEuSS6vuCkSZYY6OHjO2bFDuK+x8RG4oCDktgG/tfThsqIf+c29ONugQnJVN2JuKyGv1WDffhH7 + H8KJNw3GOyQkO1WlYhEGOjpoYUxGj6vrnvrKylZERx2FjMJwuqEXp+u6kUbIKpWIvd0FyS0lkmq12Lp1 8x0SPqA3GL2DqKgspULRBYVCiYEBShMaKhUJns5HXm4BjsozIKlW40R5N46T8JGbjxFbpkRC9RC4rAK1 - ra1ttpWNTYjeYFTcJwQEJNYWFdVSFdajoqIZTU0dUCp7dUZq9TAkcbGITsnCsdu9iP6T7iuGISXDhOwr - OBASiIuXfwfn6/vE/jXjVfq0fHYX3t5hnhx3Zigjo4QKpRKFhdUoLW3A3bstoDNAZ1R45QqCORH8hPvh - v5/DQXGYLkUZhcWX0S5ZCaydAWczwyb8JUucv968WXSVLUhOvobc3HIUFFTSrhrIrBbe3vvovhSXLpVQ - 6H5BXZ0KWdk5KpZB9yM/BBp2AzlrgQ3mcLfgf/n8Tlj/Zk3Jbu5c2wAXl+3X/Pw4rVRaiJycSoSHS7Fm - zTdwctqIvXtjYG/vjPj4W1i5UnDVmMeTwckEkDkBNd8B59yB9Xw4zZ/joa+Hf/4T9oMVhzXhYG39VoBA - 4F60Zw+nFQp/pnZ8gBpaHlxcvODlFYSgoBSYmZkl0btCc6OJ6/HZVCD+EzqFtqJd6gVf36AuesZOO1Z4 - zwy2m6kE6+UOlpbW3LJl9jfs7R21/v4nEBaWhcOHL9AuBAoej3eC3vmCFZjVS5NWQDAFraGrUVbbgvUe - HjU0/xMx22Bt0OTTRgJLy9nh8+a9V7Z48eqBBQverzU2NmYHipB4h5jCPmrW5Al23n5+f7m7u5eZmppK - ae57Zj6Wwcj8iBGr0s8JH0JM/EiwhvYKMdJiWIiX6IV30/UDfTRe5KF7PplgrfcNgpmxKwvl04XFjIz1 - X20x8vxvfYO6y+gChbsAAAAASUVORK5CYII= + ra1ttpWNjVhvMCruEwICEmuLimqpCutRUdGMpqYOKJW9OiO1ehiSuFhEp2Th2O1eRP9J9xXDkJJhQvYV + HBAH4uLl38H5+j6xf814lT4tn92Ft3eYJ8edGcrIKKFCqURhYTVKSxtw924L6AzQGRVeuYJgTgQ/4X74 + 7+dwMDRMl6KMwuLLaJesBNbOgLOZYRP+kiXOX2/eLLrKFiQnX0NubjkKCippVw1kVgtv7310X4pLl0oo + dL+grk6FrOwcFcug+5EfAg27gZy1wAZzuFvwv3x+J6x/s6ZkN3eubYCLy/Zrfn6cViotRE5OJcLDpViz + 5hs4OW3E3r0xsLd3Rnz8LaxcKbhqzOPJ4GQCyJyAmu+Ac+7Aej6c5s/x0NfDP/8J+8GKw5pwsLZ+K0Ag + cC/as4fTCoU/Uzs+QA0tDy4uXvDyCkJQUArMzMyS6F2hudHE9fhsKhD/CZ1CW9Eu9YKvb1AXPWOnHSu8 + ZwbbzVSC9XIHS0trbtky+xv29o5af/8TCAvLwuHDF2gXAgWPxztB73zBCszqpUkrIJiC1pDVKKttwXoP + jxqa/4mYbbA2aPJpI4Gl5ezwefPeK1u8ePXAggXv1xobG7MDRUi8Q0xhHzVr8gQ7bz+/v9zd3ctMTU2l + NPc9Mx/LYGR+xIhV6eeEDxFK/EiwhvYKMdJiWIiX6IV30/UDfTRe5KF7PplgrfcNgpmxKwvl04XFjIz1 + X20x8vxvbMe6yP+pQ2kAAAAASUVORK5CYII= @@ -432,7 +432,4 @@ - - 814, 17 - 1107, 17 @@ -495,8 +492,8 @@ True + + True + - True - - True @@ -512,13 +509,4 @@ 454, 54 - - - True - - - True - - - 17, 54 Index: trunk/BazaReklam/MDIBazaReklam.cs =================================================================== --- trunk/BazaReklam/MDIBazaReklam.cs (revision 732) +++ trunk/BazaReklam/MDIBazaReklam.cs (revision 791) @@ -269,8 +269,8 @@ if (!_forms.ContainsKey("ZestawienieZamowienForm")) - _forms.Add("ZestawienieZamowienForm", ZestawienieZamowienForm.getZestawienieZamowienForm(this)); - - ZestawienieZamowienForm.getZestawienieZamowienForm(this).WindowState = FormWindowState.Maximized; - ZestawienieZamowienForm.getZestawienieZamowienForm(this).Show(); + _forms.Add("ZestawienieZamowienForm", ZestawienieZamowienForm.GetZestawienieZamowienForm(this)); + + ZestawienieZamowienForm.GetZestawienieZamowienForm(this).WindowState = FormWindowState.Maximized; + ZestawienieZamowienForm.GetZestawienieZamowienForm(this).Show(); Cursor = Cursors.Default; Index: trunk/BazaReklam/ZestawienieZamowienForm.cs =================================================================== --- trunk/BazaReklam/ZestawienieZamowienForm.cs (revision 790) +++ trunk/BazaReklam/ZestawienieZamowienForm.cs (revision 791) @@ -3,5 +3,4 @@ using System.Data; using System.Data.SqlClient; -using System.Drawing; using System.Windows.Forms; using Baza_Reklam.Classes.Helpers; @@ -12,13 +11,9 @@ public partial class ZestawienieZamowienForm : Form, IForm { - private const string query = "SELECT top 2000 * from VIEW_ZESTAWIENIE_ZAMOWIEN_NOWE "; private static ZestawienieZamowienForm form; - private SqlCommand command; - private SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(); - private bool commandExecuted; - public static ZestawienieZamowienForm getZestawienieZamowienForm(MDIBazaReklam parent) + public static ZestawienieZamowienForm GetZestawienieZamowienForm(MDIBazaReklam parent) { if (form == null){ @@ -34,13 +29,4 @@ MdiParent = parent; - //podmiana connstringa - VIEW_ZESTAWIENIE_ZAMOWIEN_NOWETableAdapter.Connection.ConnectionString = ConnString.getConnString().Value; - reklamyZestawienieTableAdapter.Connection.ConnectionString = ConnString.getConnString().Value; - - //obiekty wykorzytywane przy wyszukiwaniu - SqlConnection conn = new SqlConnection(ConnString.getConnString().Value); - - command = new SqlCommand(query,conn); - //generuje piersze wêz³y w drzewie generateNodes(); @@ -50,7 +36,4 @@ { WindowState = FormWindowState.Maximized; - command.CommandText = query; - sqlDataAdapter.SelectCommand = command; - DBBindings.bindujAgencje(agencjaToolStripComboBox); } @@ -62,50 +45,34 @@ node.Name = "Biura"; treeView1.Nodes.Add(node); - - command.Connection.Close(); } private void treeView1_AfterSelect(object sender, TreeViewEventArgs e) { - if (e.Node != null) - { - command.CommandText = query; - command.Parameters.Clear(); - - switch (e.Node.Level) - { - case 0: - break; - case 1: - break; - case 2: - break; - case 3: - switch (e.Node.Parent.Parent.Parent.Name) - { - case "Biura": - - Cursor = Cursors.WaitCursor; - - rEKLAMADataSet.VIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.Clear(); - command.CommandText += " where agent=@agent"; - command.Parameters.AddWithValue("@agent", e.Node.Name); - sqlDataAdapter.Fill(rEKLAMADataSet.VIEW_ZESTAWIENIE_ZAMOWIEN_NOWE); - commandExecuted = true; - fakturyDataGridView.Refresh(); - - Cursor = Cursors.Default; - - break; - default: - break; - } - break; - case 4: - break; - default: - break; - } - } + if (e.Node == null || e.Node.Level != 3) return; + + SqlCommand cmd = new SqlCommand(); + SqlDataAdapter dataAdapter = new SqlDataAdapter(cmd); + cmd.Connection = new SqlConnection(ConnString.getConnString().Value); + cmd.CommandType = CommandType.StoredProcedure; + + cmd.CommandText = "sp_GetZestawienieZamowien"; + cmd.Parameters.Clear(); + + switch (e.Node.Parent.Parent.Parent.Name) + { + case "Biura": + Cursor = Cursors.WaitCursor; + + rEKLAMADataSet.VIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.Clear(); + cmd.Parameters.AddWithValue("@agent", e.Node.Name); + dataAdapter.Fill(rEKLAMADataSet.VIEW_ZESTAWIENIE_ZAMOWIEN_NOWE); + commandExecuted = true; + fakturyDataGridView.Refresh(); + + Cursor = Cursors.Default; + break; + default: + break; + } } @@ -245,8 +212,13 @@ rEKLAMADataSet.VIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.Clear(); - sqlDataAdapter.Fill(rEKLAMADataSet.VIEW_ZESTAWIENIE_ZAMOWIEN_NOWE); - fakturyDataGridView.Refresh(); - - Cursor = Cursors.Default; + + try + { + BindZestawienieZamowien(); + } + finally + { + Cursor = Cursors.Default; + } } } @@ -272,63 +244,8 @@ private void szukajToolStripButton_Click(object sender, EventArgs e) { - SqlCommand cmd = new SqlCommand(); - cmd.CommandText = "sp_GetZestawienieZamowien"; - cmd.CommandType = CommandType.StoredProcedure; - - rEKLAMADataSet.VIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.Clear(); - rEKLAMADataSet.ReklamyZestawienie.Clear(); - - cmd.Parameters.Clear(); - - if (nrZamToolStripTextBox.Text.Trim() != "") - { - int i; - if (!Int32.TryParse(nrZamToolStripTextBox.Text.Trim(), out i)) - { - MessageBox.Show("Podaj prawid³owy numer zamówienia."); - return; - } - cmd.Parameters.AddWithValue("@nrZamowienia", nrZamToolStripTextBox.Text.Trim()); - } - - if (rokToolStripTextBox.Text.Trim() != "") - { - int i; - if (!Int32.TryParse(rokToolStripTextBox.Text.Trim(), out i)) - { - MessageBox.Show("Podaj prawid³owy rok."); - return; - } - cmd.Parameters.AddWithValue("@rokZamowienia", rokToolStripTextBox.Text.Trim()); - } - - if (txtMiesiac.Text.Trim() != "") - { - int i; - if (!Int32.TryParse(txtMiesiac.Text.Trim(), out i) || i > 12 || i <= 0) - { - MessageBox.Show("Podaj prawid³owy miesi¹c."); - return; - } - cmd.Parameters.AddWithValue("@miesiacZamowienia", txtMiesiac.Text.Trim()); - } - - if (kodRozliczeniowyToolStripTextBox.Text.Trim() != "") - cmd.Parameters.AddWithValue("@kodAgenta", kodRozliczeniowyToolStripTextBox.Text.Trim()); - - if (kodKlientaToolStripTextBox.Text.Trim() != "") - cmd.Parameters.AddWithValue("@kodKlienta", kodKlientaToolStripTextBox.Text.Trim()); - - if (agencjaToolStripComboBox.Text.Trim() != "") - cmd.Parameters.AddWithValue("@agencja", agencjaToolStripComboBox.Text.Trim()); - - sqlDataAdapter.SelectCommand = cmd; - Cursor = Cursors.WaitCursor; try { - sqlDataAdapter.SelectCommand.Connection = new SqlConnection(ConnString.getConnString().Value); - sqlDataAdapter.Fill(rEKLAMADataSet.VIEW_ZESTAWIENIE_ZAMOWIEN_NOWE); - commandExecuted = true; + BindZestawienieZamowien(); } finally @@ -338,4 +255,65 @@ Cursor = Cursors.Default; } + } + + private void BindZestawienieZamowien() + { + SqlCommand cmd = new SqlCommand(); + SqlDataAdapter dataAdapter = new SqlDataAdapter(cmd); + cmd.CommandText = "sp_GetZestawienieZamowien"; + cmd.CommandType = CommandType.StoredProcedure; + + rEKLAMADataSet.VIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.Clear(); + rEKLAMADataSet.ReklamyZestawienie.Clear(); + + cmd.Parameters.Clear(); + + if (nrZamToolStripTextBox.Text.Trim() != "") + { + int i; + if (!Int32.TryParse(nrZamToolStripTextBox.Text.Trim(), out i)) + { + MessageBox.Show("Podaj prawid³owy numer zamówienia."); + return; + } + cmd.Parameters.AddWithValue("@nrZamowienia", nrZamToolStripTextBox.Text.Trim()); + } + + if (rokToolStripTextBox.Text.Trim() != "") + { + int i; + if (!Int32.TryParse(rokToolStripTextBox.Text.Trim(), out i)) + { + MessageBox.Show("Podaj prawid³owy rok."); + return; + } + cmd.Parameters.AddWithValue("@rokZamowienia", rokToolStripTextBox.Text.Trim()); + } + + if (txtMiesiac.Text.Trim() != "") + { + int i; + if (!Int32.TryParse(txtMiesiac.Text.Trim(), out i) || i > 12 || i <= 0) + { + MessageBox.Show("Podaj prawid³owy miesi¹c."); + return; + } + cmd.Parameters.AddWithValue("@miesiacZamowienia", txtMiesiac.Text.Trim()); + } + + if (kodRozliczeniowyToolStripTextBox.Text.Trim() != "") + cmd.Parameters.AddWithValue("@kodAgenta", kodRozliczeniowyToolStripTextBox.Text.Trim()); + + if (kodKlientaToolStripTextBox.Text.Trim() != "") + cmd.Parameters.AddWithValue("@kodKlienta", kodKlientaToolStripTextBox.Text.Trim()); + + if (agencjaToolStripComboBox.Text.Trim() != "") + cmd.Parameters.AddWithValue("@agencja", agencjaToolStripComboBox.Text.Trim()); + + dataAdapter.SelectCommand = cmd; + + dataAdapter.SelectCommand.Connection = new SqlConnection(ConnString.getConnString().Value); + dataAdapter.Fill(rEKLAMADataSet.VIEW_ZESTAWIENIE_ZAMOWIEN_NOWE); + commandExecuted = true; } Index: trunk/BazaReklam/ZestawienieZamowienForm.Designer.cs =================================================================== --- trunk/BazaReklam/ZestawienieZamowienForm.Designer.cs (revision 790) +++ trunk/BazaReklam/ZestawienieZamowienForm.Designer.cs (revision 791) @@ -31,25 +31,25 @@ this.components = new System.ComponentModel.Container(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(ZestawienieZamowienForm)); - System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle22 = new System.Windows.Forms.DataGridViewCellStyle(); - System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle23 = new System.Windows.Forms.DataGridViewCellStyle(); - System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle24 = new System.Windows.Forms.DataGridViewCellStyle(); - System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle25 = new System.Windows.Forms.DataGridViewCellStyle(); - System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle26 = new System.Windows.Forms.DataGridViewCellStyle(); - System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle27 = new System.Windows.Forms.DataGridViewCellStyle(); - System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle28 = new System.Windows.Forms.DataGridViewCellStyle(); - System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle29 = new System.Windows.Forms.DataGridViewCellStyle(); - System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle30 = new System.Windows.Forms.DataGridViewCellStyle(); - System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle31 = new System.Windows.Forms.DataGridViewCellStyle(); - System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle32 = new System.Windows.Forms.DataGridViewCellStyle(); - System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle33 = new System.Windows.Forms.DataGridViewCellStyle(); - System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle34 = new System.Windows.Forms.DataGridViewCellStyle(); - System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle35 = new System.Windows.Forms.DataGridViewCellStyle(); - System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle36 = new System.Windows.Forms.DataGridViewCellStyle(); - System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle37 = new System.Windows.Forms.DataGridViewCellStyle(); - System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle38 = new System.Windows.Forms.DataGridViewCellStyle(); - System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle39 = new System.Windows.Forms.DataGridViewCellStyle(); - System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle40 = new System.Windows.Forms.DataGridViewCellStyle(); - System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle41 = new System.Windows.Forms.DataGridViewCellStyle(); - System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle42 = 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 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 dataGridViewCellStyle18 = 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 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(); + System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle8 = new System.Windows.Forms.DataGridViewCellStyle(); + System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle9 = new System.Windows.Forms.DataGridViewCellStyle(); + System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle10 = new System.Windows.Forms.DataGridViewCellStyle(); + System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle11 = new System.Windows.Forms.DataGridViewCellStyle(); + System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle12 = new System.Windows.Forms.DataGridViewCellStyle(); + System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle13 = new System.Windows.Forms.DataGridViewCellStyle(); + System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle14 = new System.Windows.Forms.DataGridViewCellStyle(); this.bindingNavigator1 = new System.Windows.Forms.BindingNavigator(this.components); this.VIEW_ZESTAWIENIE_ZAMOWIEN_NOWEBindingSource = new System.Windows.Forms.BindingSource(this.components); @@ -93,17 +93,4 @@ this.splitContainer2 = new System.Windows.Forms.SplitContainer(); this.fakturyDataGridView = new System.Windows.Forms.DataGridView(); - this.agencja = new System.Windows.Forms.DataGridViewTextBoxColumn(); - this.agent = new System.Windows.Forms.DataGridViewTextBoxColumn(); - this.rokZamowienia = new System.Windows.Forms.DataGridViewTextBoxColumn(); - this.nrZamowieniaExt = new System.Windows.Forms.DataGridViewTextBoxColumn(); - this.iloscReklam = new System.Windows.Forms.DataGridViewTextBoxColumn(); - this.data_od = new System.Windows.Forms.DataGridViewTextBoxColumn(); - this.data_od_bez_FK = new System.Windows.Forms.DataGridViewTextBoxColumn(); - this.wartoscNetto = new System.Windows.Forms.DataGridViewTextBoxColumn(); - this.kwotaWalutaBrutto = new System.Windows.Forms.DataGridViewTextBoxColumn(); - this.bruttoEuroMianoDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn(); - this.nettoZafakturowane = new System.Windows.Forms.DataGridViewTextBoxColumn(); - this.SumaNaNastepnejFakturze = new System.Windows.Forms.DataGridViewTextBoxColumn(); - this.DoZafakturowania = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.reklamyZestawienieDataGridView = new System.Windows.Forms.DataGridView(); this.dataGridViewTextBoxColumn3 = new System.Windows.Forms.DataGridViewTextBoxColumn(); @@ -135,4 +122,17 @@ this.VIEW_ZESTAWIENIE_ZAMOWIEN_NOWETableAdapter = new Baza_Reklam.REKLAMADataSetTableAdapters.VIEW_ZESTAWIENIE_ZAMOWIEN_NOWETableAdapter(); this.reklamyZestawienieTableAdapter = new Baza_Reklam.REKLAMADataSetTableAdapters.ReklamyZestawienieTableAdapter(); + this.agencja = new System.Windows.Forms.DataGridViewTextBoxColumn(); + this.agent = new System.Windows.Forms.DataGridViewTextBoxColumn(); + this.rokZamowienia = new System.Windows.Forms.DataGridViewTextBoxColumn(); + this.nrZamowieniaExt = new System.Windows.Forms.DataGridViewTextBoxColumn(); + this.iloscReklam = new System.Windows.Forms.DataGridViewTextBoxColumn(); + this.data_od = new System.Windows.Forms.DataGridViewTextBoxColumn(); + this.data_od_bez_FK = new System.Windows.Forms.DataGridViewTextBoxColumn(); + this.wartoscNetto = new System.Windows.Forms.DataGridViewTextBoxColumn(); + this.kwotaWalutaBrutto = new System.Windows.Forms.DataGridViewTextBoxColumn(); + this.bruttoEuroMianoDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn(); + this.nettoZafakturowane = new System.Windows.Forms.DataGridViewTextBoxColumn(); + this.DoZafakturowania = new System.Windows.Forms.DataGridViewTextBoxColumn(); + this.SumaNaNastepnejFakturze = new System.Windows.Forms.DataGridViewTextBoxColumn(); ((System.ComponentModel.ISupportInitialize)(this.bindingNavigator1)).BeginInit(); this.bindingNavigator1.SuspendLayout(); @@ -491,4 +491,5 @@ // this.splitContainer1.Panel1.Controls.Add(this.treeView1); + this.splitContainer1.Panel1Collapsed = true; // // splitContainer1.Panel2 @@ -504,5 +505,5 @@ this.treeView1.Location = new System.Drawing.Point(0, 0); this.treeView1.Name = "treeView1"; - this.treeView1.Size = new System.Drawing.Size(163, 569); + this.treeView1.Size = new System.Drawing.Size(163, 100); this.treeView1.TabIndex = 0; this.treeView1.AfterSelect += new System.Windows.Forms.TreeViewEventHandler(this.treeView1_AfterSelect); @@ -525,5 +526,5 @@ this.splitContainer2.Panel2.Controls.Add(this.reklamyZestawienieDataGridView); this.splitContainer2.Panel2.Controls.Add(this.toolStrip1); - this.splitContainer2.Size = new System.Drawing.Size(812, 569); + this.splitContainer2.Size = new System.Drawing.Size(979, 569); this.splitContainer2.SplitterDistance = 355; this.splitContainer2.TabIndex = 0; @@ -533,18 +534,18 @@ this.fakturyDataGridView.AllowUserToAddRows = false; this.fakturyDataGridView.AllowUserToDeleteRows = false; - dataGridViewCellStyle22.BackColor = System.Drawing.Color.MintCream; - this.fakturyDataGridView.AlternatingRowsDefaultCellStyle = dataGridViewCellStyle22; + dataGridViewCellStyle1.BackColor = System.Drawing.Color.MintCream; + this.fakturyDataGridView.AlternatingRowsDefaultCellStyle = dataGridViewCellStyle1; this.fakturyDataGridView.AutoGenerateColumns = false; this.fakturyDataGridView.AutoSizeColumnsMode = System.Windows.Forms.DataGridViewAutoSizeColumnsMode.DisplayedCells; this.fakturyDataGridView.BackgroundColor = System.Drawing.Color.White; this.fakturyDataGridView.CausesValidation = false; - dataGridViewCellStyle23.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; - dataGridViewCellStyle23.BackColor = System.Drawing.SystemColors.Control; - dataGridViewCellStyle23.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(238))); - dataGridViewCellStyle23.ForeColor = System.Drawing.SystemColors.WindowText; - dataGridViewCellStyle23.SelectionBackColor = System.Drawing.SystemColors.Highlight; - dataGridViewCellStyle23.SelectionForeColor = System.Drawing.SystemColors.HighlightText; - dataGridViewCellStyle23.WrapMode = System.Windows.Forms.DataGridViewTriState.True; - this.fakturyDataGridView.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle23; + 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.fakturyDataGridView.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle2; this.fakturyDataGridView.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; this.fakturyDataGridView.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] { @@ -560,6 +561,6 @@ this.bruttoEuroMianoDataGridViewTextBoxColumn, this.nettoZafakturowane, - this.SumaNaNastepnejFakturze, - this.DoZafakturowania}); + this.DoZafakturowania, + this.SumaNaNastepnejFakturze}); this.fakturyDataGridView.DataSource = this.VIEW_ZESTAWIENIE_ZAMOWIEN_NOWEBindingSource; this.fakturyDataGridView.Dock = System.Windows.Forms.DockStyle.Fill; @@ -572,154 +573,7 @@ this.fakturyDataGridView.RowHeadersWidthSizeMode = System.Windows.Forms.DataGridViewRowHeadersWidthSizeMode.DisableResizing; this.fakturyDataGridView.SelectionMode = System.Windows.Forms.DataGridViewSelectionMode.FullRowSelect; - this.fakturyDataGridView.Size = new System.Drawing.Size(812, 355); + this.fakturyDataGridView.Size = new System.Drawing.Size(979, 355); this.fakturyDataGridView.TabIndex = 1; this.fakturyDataGridView.DataBindingComplete += new System.Windows.Forms.DataGridViewBindingCompleteEventHandler(this.fakturyDataGridView_DataBindingComplete); - // - // agencja - // - this.agencja.DataPropertyName = "agencja"; - dataGridViewCellStyle24.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; - this.agencja.DefaultCellStyle = dataGridViewCellStyle24; - this.agencja.HeaderText = "Agencja"; - this.agencja.Name = "agencja"; - this.agencja.ReadOnly = true; - this.agencja.Width = 71; - // - // agent - // - this.agent.DataPropertyName = "agent"; - dataGridViewCellStyle25.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; - this.agent.DefaultCellStyle = dataGridViewCellStyle25; - this.agent.HeaderText = "Agent"; - this.agent.Name = "agent"; - this.agent.ReadOnly = true; - this.agent.Width = 60; - // - // rokZamowienia - // - this.rokZamowienia.DataPropertyName = "rokZamowienia"; - dataGridViewCellStyle26.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; - this.rokZamowienia.DefaultCellStyle = dataGridViewCellStyle26; - this.rokZamowienia.HeaderText = "Rok"; - this.rokZamowienia.Name = "rokZamowienia"; - this.rokZamowienia.ReadOnly = true; - this.rokZamowienia.Width = 52; - // - // nrZamowieniaExt - // - this.nrZamowieniaExt.DataPropertyName = "nrZamowieniaExt"; - this.nrZamowieniaExt.HeaderText = "Nr zamówienia"; - this.nrZamowieniaExt.Name = "nrZamowieniaExt"; - this.nrZamowieniaExt.ReadOnly = true; - this.nrZamowieniaExt.Width = 93; - // - // iloscReklam - // - this.iloscReklam.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; - this.iloscReklam.DataPropertyName = "iloscReklam"; - dataGridViewCellStyle27.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; - this.iloscReklam.DefaultCellStyle = dataGridViewCellStyle27; - this.iloscReklam.HeaderText = "# rek"; - this.iloscReklam.Name = "iloscReklam"; - this.iloscReklam.ReadOnly = true; - this.iloscReklam.Width = 40; - // - // data_od - // - this.data_od.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; - this.data_od.DataPropertyName = "data_od"; - dataGridViewCellStyle28.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; - dataGridViewCellStyle28.Format = "d"; - this.data_od.DefaultCellStyle = dataGridViewCellStyle28; - this.data_od.HeaderText = "Data 1 em"; - this.data_od.Name = "data_od"; - this.data_od.ReadOnly = true; - this.data_od.Width = 80; - // - // data_od_bez_FK - // - this.data_od_bez_FK.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; - this.data_od_bez_FK.DataPropertyName = "data_od_bez_FK"; - dataGridViewCellStyle29.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; - this.data_od_bez_FK.DefaultCellStyle = dataGridViewCellStyle29; - this.data_od_bez_FK.HeaderText = "Data 1 em bez FV"; - this.data_od_bez_FK.Name = "data_od_bez_FK"; - this.data_od_bez_FK.ReadOnly = true; - this.data_od_bez_FK.Width = 80; - // - // wartoscNetto - // - this.wartoscNetto.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; - this.wartoscNetto.DataPropertyName = "wartoscNetto"; - dataGridViewCellStyle30.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight; - dataGridViewCellStyle30.Format = "C2"; - this.wartoscNetto.DefaultCellStyle = dataGridViewCellStyle30; - this.wartoscNetto.HeaderText = "Netto"; - this.wartoscNetto.Name = "wartoscNetto"; - this.wartoscNetto.ReadOnly = true; - this.wartoscNetto.Width = 110; - // - // kwotaWalutaBrutto - // - this.kwotaWalutaBrutto.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; - this.kwotaWalutaBrutto.DataPropertyName = "kwotaWalutaBrutto"; - dataGridViewCellStyle31.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight; - dataGridViewCellStyle31.Format = "N2"; - dataGridViewCellStyle31.NullValue = null; - this.kwotaWalutaBrutto.DefaultCellStyle = dataGridViewCellStyle31; - this.kwotaWalutaBrutto.HeaderText = "Waluta - brutto zamówienia"; - this.kwotaWalutaBrutto.Name = "kwotaWalutaBrutto"; - this.kwotaWalutaBrutto.ReadOnly = true; - this.kwotaWalutaBrutto.Width = 110; - // - // bruttoEuroMianoDataGridViewTextBoxColumn - // - this.bruttoEuroMianoDataGridViewTextBoxColumn.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; - this.bruttoEuroMianoDataGridViewTextBoxColumn.DataPropertyName = "Brutto_Euro_Miano"; - dataGridViewCellStyle32.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; - this.bruttoEuroMianoDataGridViewTextBoxColumn.DefaultCellStyle = dataGridViewCellStyle32; - this.bruttoEuroMianoDataGridViewTextBoxColumn.HeaderText = "W"; - this.bruttoEuroMianoDataGridViewTextBoxColumn.Name = "bruttoEuroMianoDataGridViewTextBoxColumn"; - this.bruttoEuroMianoDataGridViewTextBoxColumn.ReadOnly = true; - this.bruttoEuroMianoDataGridViewTextBoxColumn.Width = 35; - // - // nettoZafakturowane - // - this.nettoZafakturowane.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; - this.nettoZafakturowane.DataPropertyName = "nettoZafakturowane"; - dataGridViewCellStyle33.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight; - dataGridViewCellStyle33.Format = "C2"; - this.nettoZafakturowane.DefaultCellStyle = dataGridViewCellStyle33; - this.nettoZafakturowane.HeaderText = "Wartoœæ netto FV"; - this.nettoZafakturowane.Name = "nettoZafakturowane"; - this.nettoZafakturowane.ReadOnly = true; - this.nettoZafakturowane.Width = 110; - // - // SumaNaNastepnejFakturze - // - this.SumaNaNastepnejFakturze.DataPropertyName = "SumaNaNastepnejFakturze"; - dataGridViewCellStyle34.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight; - dataGridViewCellStyle34.Format = "C2"; - dataGridViewCellStyle34.NullValue = null; - this.SumaNaNastepnejFakturze.DefaultCellStyle = dataGridViewCellStyle34; - this.SumaNaNastepnejFakturze.HeaderText = "Wartoœæ nastêpnej faktury w PLN"; - this.SumaNaNastepnejFakturze.Name = "SumaNaNastepnejFakturze"; - this.SumaNaNastepnejFakturze.ReadOnly = true; - this.SumaNaNastepnejFakturze.ToolTipText = "Jeœli faktura w walucie to wartoœæ w PLN zgodna z kursem z dnia zatwierdzenia do " + - "druku"; - this.SumaNaNastepnejFakturze.Width = 155; - // - // DoZafakturowania - // - this.DoZafakturowania.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; - this.DoZafakturowania.DataPropertyName = "DoZafakturowania"; - dataGridViewCellStyle35.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight; - dataGridViewCellStyle35.Format = "N2"; - dataGridViewCellStyle35.NullValue = null; - this.DoZafakturowania.DefaultCellStyle = dataGridViewCellStyle35; - this.DoZafakturowania.HeaderText = "Wartoœæ niezafakturowana"; - this.DoZafakturowania.Name = "DoZafakturowania"; - this.DoZafakturowania.ReadOnly = true; - this.DoZafakturowania.Width = 110; // // reklamyZestawienieDataGridView @@ -756,5 +610,5 @@ this.reklamyZestawienieDataGridView.RowHeadersWidthSizeMode = System.Windows.Forms.DataGridViewRowHeadersWidthSizeMode.DisableResizing; this.reklamyZestawienieDataGridView.SelectionMode = System.Windows.Forms.DataGridViewSelectionMode.FullRowSelect; - this.reklamyZestawienieDataGridView.Size = new System.Drawing.Size(812, 179); + this.reklamyZestawienieDataGridView.Size = new System.Drawing.Size(979, 179); this.reklamyZestawienieDataGridView.TabIndex = 1; // @@ -799,7 +653,7 @@ this.dataGridViewTextBoxColumn8.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; this.dataGridViewTextBoxColumn8.DataPropertyName = "1emisja"; - dataGridViewCellStyle36.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; - dataGridViewCellStyle36.Format = "d"; - this.dataGridViewTextBoxColumn8.DefaultCellStyle = dataGridViewCellStyle36; + dataGridViewCellStyle15.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; + dataGridViewCellStyle15.Format = "d"; + this.dataGridViewTextBoxColumn8.DefaultCellStyle = dataGridViewCellStyle15; this.dataGridViewTextBoxColumn8.HeaderText = "1 emisja"; this.dataGridViewTextBoxColumn8.Name = "dataGridViewTextBoxColumn8"; @@ -847,7 +701,7 @@ this.dataGridViewTextBoxColumn23.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; this.dataGridViewTextBoxColumn23.DataPropertyName = "CENA JEDN"; - dataGridViewCellStyle37.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight; - dataGridViewCellStyle37.Format = "C2"; - this.dataGridViewTextBoxColumn23.DefaultCellStyle = dataGridViewCellStyle37; + dataGridViewCellStyle16.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight; + dataGridViewCellStyle16.Format = "C2"; + this.dataGridViewTextBoxColumn23.DefaultCellStyle = dataGridViewCellStyle16; this.dataGridViewTextBoxColumn23.HeaderText = "Cena jedn."; this.dataGridViewTextBoxColumn23.Name = "dataGridViewTextBoxColumn23"; @@ -859,7 +713,7 @@ this.RABAT_WARTOSC.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; this.RABAT_WARTOSC.DataPropertyName = "RABAT WARTOŒÆ"; - dataGridViewCellStyle38.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight; - dataGridViewCellStyle38.Format = "C2"; - this.RABAT_WARTOSC.DefaultCellStyle = dataGridViewCellStyle38; + dataGridViewCellStyle17.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight; + dataGridViewCellStyle17.Format = "C2"; + this.RABAT_WARTOSC.DefaultCellStyle = dataGridViewCellStyle17; this.RABAT_WARTOSC.HeaderText = "Rabat"; this.RABAT_WARTOSC.Name = "RABAT_WARTOSC"; @@ -871,7 +725,7 @@ this.dataGridViewTextBoxColumn24.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; this.dataGridViewTextBoxColumn24.DataPropertyName = "NETTO"; - dataGridViewCellStyle39.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight; - dataGridViewCellStyle39.Format = "C2"; - this.dataGridViewTextBoxColumn24.DefaultCellStyle = dataGridViewCellStyle39; + dataGridViewCellStyle18.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight; + dataGridViewCellStyle18.Format = "C2"; + this.dataGridViewTextBoxColumn24.DefaultCellStyle = dataGridViewCellStyle18; this.dataGridViewTextBoxColumn24.HeaderText = "NETTO"; this.dataGridViewTextBoxColumn24.Name = "dataGridViewTextBoxColumn24"; @@ -883,8 +737,8 @@ this.dataGridViewTextBoxColumn25.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; this.dataGridViewTextBoxColumn25.DataPropertyName = "VAT"; - dataGridViewCellStyle40.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; - dataGridViewCellStyle40.Format = "P"; - dataGridViewCellStyle40.NullValue = null; - this.dataGridViewTextBoxColumn25.DefaultCellStyle = dataGridViewCellStyle40; + dataGridViewCellStyle19.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; + dataGridViewCellStyle19.Format = "P"; + dataGridViewCellStyle19.NullValue = null; + this.dataGridViewTextBoxColumn25.DefaultCellStyle = dataGridViewCellStyle19; this.dataGridViewTextBoxColumn25.HeaderText = "VAT"; this.dataGridViewTextBoxColumn25.Name = "dataGridViewTextBoxColumn25"; @@ -896,7 +750,7 @@ this.dataGridViewTextBoxColumn26.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; this.dataGridViewTextBoxColumn26.DataPropertyName = "PVAT"; - dataGridViewCellStyle41.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight; - dataGridViewCellStyle41.Format = "C2"; - this.dataGridViewTextBoxColumn26.DefaultCellStyle = dataGridViewCellStyle41; + dataGridViewCellStyle20.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight; + dataGridViewCellStyle20.Format = "C2"; + this.dataGridViewTextBoxColumn26.DefaultCellStyle = dataGridViewCellStyle20; this.dataGridViewTextBoxColumn26.HeaderText = "PVAT"; this.dataGridViewTextBoxColumn26.Name = "dataGridViewTextBoxColumn26"; @@ -908,7 +762,7 @@ this.dataGridViewTextBoxColumn27.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; this.dataGridViewTextBoxColumn27.DataPropertyName = "BRUTTO"; - dataGridViewCellStyle42.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight; - dataGridViewCellStyle42.Format = "C2"; - this.dataGridViewTextBoxColumn27.DefaultCellStyle = dataGridViewCellStyle42; + dataGridViewCellStyle21.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight; + dataGridViewCellStyle21.Format = "C2"; + this.dataGridViewTextBoxColumn27.DefaultCellStyle = dataGridViewCellStyle21; this.dataGridViewTextBoxColumn27.HeaderText = "BRUTTO"; this.dataGridViewTextBoxColumn27.Name = "dataGridViewTextBoxColumn27"; @@ -946,5 +800,5 @@ this.toolStrip1.Location = new System.Drawing.Point(0, 0); this.toolStrip1.Name = "toolStrip1"; - this.toolStrip1.Size = new System.Drawing.Size(812, 31); + this.toolStrip1.Size = new System.Drawing.Size(979, 31); this.toolStrip1.TabIndex = 0; this.toolStrip1.Text = "reklamaToolStrip"; @@ -1021,4 +875,155 @@ // this.reklamyZestawienieTableAdapter.ClearBeforeFill = true; + // + // agencja + // + this.agencja.DataPropertyName = "agencja"; + dataGridViewCellStyle3.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; + this.agencja.DefaultCellStyle = dataGridViewCellStyle3; + this.agencja.HeaderText = "Agencja"; + this.agencja.Name = "agencja"; + this.agencja.ReadOnly = true; + this.agencja.Width = 71; + // + // agent + // + this.agent.DataPropertyName = "agent"; + dataGridViewCellStyle4.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; + this.agent.DefaultCellStyle = dataGridViewCellStyle4; + this.agent.HeaderText = "Agent"; + this.agent.Name = "agent"; + this.agent.ReadOnly = true; + this.agent.Width = 60; + // + // rokZamowienia + // + this.rokZamowienia.DataPropertyName = "rokZamowienia"; + dataGridViewCellStyle5.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; + this.rokZamowienia.DefaultCellStyle = dataGridViewCellStyle5; + this.rokZamowienia.HeaderText = "Rok"; + this.rokZamowienia.Name = "rokZamowienia"; + this.rokZamowienia.ReadOnly = true; + this.rokZamowienia.Width = 52; + // + // nrZamowieniaExt + // + this.nrZamowieniaExt.DataPropertyName = "nrZamowieniaExt"; + this.nrZamowieniaExt.HeaderText = "Nr zamówienia"; + this.nrZamowieniaExt.Name = "nrZamowieniaExt"; + this.nrZamowieniaExt.ReadOnly = true; + this.nrZamowieniaExt.Width = 101; + // + // iloscReklam + // + this.iloscReklam.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; + this.iloscReklam.DataPropertyName = "iloscReklam"; + dataGridViewCellStyle6.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; + this.iloscReklam.DefaultCellStyle = dataGridViewCellStyle6; + this.iloscReklam.HeaderText = "# rek"; + this.iloscReklam.Name = "iloscReklam"; + this.iloscReklam.ReadOnly = true; + this.iloscReklam.Width = 40; + // + // data_od + // + this.data_od.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; + this.data_od.DataPropertyName = "data_od"; + dataGridViewCellStyle7.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; + dataGridViewCellStyle7.Format = "d"; + this.data_od.DefaultCellStyle = dataGridViewCellStyle7; + this.data_od.HeaderText = "Data 1 em"; + this.data_od.Name = "data_od"; + this.data_od.ReadOnly = true; + this.data_od.Width = 80; + // + // data_od_bez_FK + // + this.data_od_bez_FK.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; + this.data_od_bez_FK.DataPropertyName = "data_od_bez_FK"; + dataGridViewCellStyle8.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; + this.data_od_bez_FK.DefaultCellStyle = dataGridViewCellStyle8; + this.data_od_bez_FK.HeaderText = "Data 1 em bez FV"; + this.data_od_bez_FK.Name = "data_od_bez_FK"; + this.data_od_bez_FK.ReadOnly = true; + this.data_od_bez_FK.Width = 80; + // + // wartoscNetto + // + this.wartoscNetto.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; + this.wartoscNetto.DataPropertyName = "wartoscNetto"; + dataGridViewCellStyle9.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight; + dataGridViewCellStyle9.Format = "C2"; + this.wartoscNetto.DefaultCellStyle = dataGridViewCellStyle9; + this.wartoscNetto.HeaderText = "Netto"; + this.wartoscNetto.Name = "wartoscNetto"; + this.wartoscNetto.ReadOnly = true; + this.wartoscNetto.Width = 90; + // + // kwotaWalutaBrutto + // + this.kwotaWalutaBrutto.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; + this.kwotaWalutaBrutto.DataPropertyName = "kwotaWalutaBrutto"; + dataGridViewCellStyle10.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight; + dataGridViewCellStyle10.Format = "N2"; + dataGridViewCellStyle10.NullValue = null; + this.kwotaWalutaBrutto.DefaultCellStyle = dataGridViewCellStyle10; + this.kwotaWalutaBrutto.HeaderText = "Waluta - brutto zamówienia"; + this.kwotaWalutaBrutto.Name = "kwotaWalutaBrutto"; + this.kwotaWalutaBrutto.ReadOnly = true; + this.kwotaWalutaBrutto.Width = 90; + // + // bruttoEuroMianoDataGridViewTextBoxColumn + // + this.bruttoEuroMianoDataGridViewTextBoxColumn.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; + this.bruttoEuroMianoDataGridViewTextBoxColumn.DataPropertyName = "Brutto_Euro_Miano"; + dataGridViewCellStyle11.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; + this.bruttoEuroMianoDataGridViewTextBoxColumn.DefaultCellStyle = dataGridViewCellStyle11; + this.bruttoEuroMianoDataGridViewTextBoxColumn.HeaderText = "W"; + this.bruttoEuroMianoDataGridViewTextBoxColumn.Name = "bruttoEuroMianoDataGridViewTextBoxColumn"; + this.bruttoEuroMianoDataGridViewTextBoxColumn.ReadOnly = true; + this.bruttoEuroMianoDataGridViewTextBoxColumn.Width = 35; + // + // nettoZafakturowane + // + this.nettoZafakturowane.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; + this.nettoZafakturowane.DataPropertyName = "nettoZafakturowane"; + dataGridViewCellStyle12.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight; + dataGridViewCellStyle12.Format = "C2"; + this.nettoZafakturowane.DefaultCellStyle = dataGridViewCellStyle12; + this.nettoZafakturowane.HeaderText = "Wartoœæ netto FV"; + this.nettoZafakturowane.Name = "nettoZafakturowane"; + this.nettoZafakturowane.ReadOnly = true; + this.nettoZafakturowane.Width = 90; + // + // DoZafakturowania + // + this.DoZafakturowania.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; + this.DoZafakturowania.DataPropertyName = "DoZafakturowania"; + dataGridViewCellStyle13.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight; + dataGridViewCellStyle13.Format = "C2"; + dataGridViewCellStyle13.NullValue = null; + this.DoZafakturowania.DefaultCellStyle = dataGridViewCellStyle13; + this.DoZafakturowania.HeaderText = "Do zafakturowania"; + this.DoZafakturowania.Name = "DoZafakturowania"; + this.DoZafakturowania.ReadOnly = true; + this.DoZafakturowania.ToolTipText = "Wartoœæ jaka bêdzie zafakturowana na nastêpnej fakturze. Jeœli faktura w walucie " + + "to wartoœæ w PLN zgodna z kursem z dnia zatwierdzenia do druku."; + this.DoZafakturowania.Width = 90; + // + // SumaNaNastepnejFakturze + // + this.SumaNaNastepnejFakturze.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; + this.SumaNaNastepnejFakturze.DataPropertyName = "SumaNaNastepnejFakturze"; + dataGridViewCellStyle14.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight; + dataGridViewCellStyle14.Format = "C2"; + dataGridViewCellStyle14.NullValue = null; + this.SumaNaNastepnejFakturze.DefaultCellStyle = dataGridViewCellStyle14; + this.SumaNaNastepnejFakturze.HeaderText = "Wartoœæ nastêpnej faktury w PLN"; + this.SumaNaNastepnejFakturze.Name = "SumaNaNastepnejFakturze"; + this.SumaNaNastepnejFakturze.ReadOnly = true; + this.SumaNaNastepnejFakturze.ToolTipText = "Jeœli faktura w walucie to wartoœæ w PLN zgodna z kursem z dnia zatwierdzenia do " + + "druku"; + this.SumaNaNastepnejFakturze.Visible = false; + this.SumaNaNastepnejFakturze.Width = 90; // // ZestawienieZamowienForm @@ -1081,5 +1086,4 @@ private System.Windows.Forms.ToolStrip wyszukajToolStrip; private System.Windows.Forms.SplitContainer splitContainer1; - private System.Windows.Forms.TreeView treeView1; private System.Windows.Forms.Panel panel; private System.Windows.Forms.ToolStripButton szukajToolStripButton; @@ -1139,4 +1143,5 @@ private System.Windows.Forms.ToolStripLabel toolStripLabel6; private System.Windows.Forms.ToolStripTextBox txtMiesiac; + private System.Windows.Forms.TreeView treeView1; private System.Windows.Forms.DataGridViewTextBoxColumn agencja; private System.Windows.Forms.DataGridViewTextBoxColumn agent; @@ -1150,6 +1155,6 @@ private System.Windows.Forms.DataGridViewTextBoxColumn bruttoEuroMianoDataGridViewTextBoxColumn; private System.Windows.Forms.DataGridViewTextBoxColumn nettoZafakturowane; + private System.Windows.Forms.DataGridViewTextBoxColumn DoZafakturowania; private System.Windows.Forms.DataGridViewTextBoxColumn SumaNaNastepnejFakturze; - private System.Windows.Forms.DataGridViewTextBoxColumn DoZafakturowania; }