- Data:
- 2009-02-12 16:32:49 (17 years ago)
- Lokalizacja:
- trunk/BazaReklam
- Pliki:
-
- 12 zmodyfikowane
- 1 przeniesione
-
Baza Reklam.csproj (zmodyfikowane) (1 diff)
-
Classes/ExcelHelper.cs (przeniesione) (przeniesione from trunk/BazaReklam/Classes/ExcelHandler.cs) (1 diff)
-
ClientsForm.cs (zmodyfikowane) (1 diff)
-
FacturesForm.cs (zmodyfikowane) (1 diff)
-
FacturesFormNEW.cs (zmodyfikowane) (1 diff)
-
InfoForm.Designer.cs (zmodyfikowane) (15 diffs)
-
InfoForm.cs (zmodyfikowane) (40 diffs)
-
InfoForm.resx (zmodyfikowane) (4 diffs)
-
KorektyForm.cs (zmodyfikowane) (1 diff)
-
OrdersForm.cs (zmodyfikowane) (1 diff)
-
ZestawienieZamowienForm.Designer.cs (zmodyfikowane) (24 diffs)
-
ZestawienieZamowienForm.cs (zmodyfikowane) (1 diff)
-
ZestawienieZamowienForm.resx (zmodyfikowane) (4 diffs)
Legenda:
- Bez zmian
- Dodane
- Usunięte
-
trunk/BazaReklam/Baza Reklam.csproj
r270 r351 101 101 <Compile Include="Classes\BoundItem.cs" /> 102 102 <Compile Include="Classes\DBBindings.cs" /> 103 <Compile Include="Classes\ExcelH andler.cs" />103 <Compile Include="Classes\ExcelHelper.cs" /> 104 104 <Compile Include="Classes\FakturaHelper.cs" /> 105 105 <Compile Include="Classes\KursyWalut.cs" /> -
trunk/BazaReklam/Classes/ExcelHelper.cs
r65 r351 1 using System;2 using System.Collections.Generic;3 using System.Text;4 1 using System.Windows.Forms; 5 2 6 3 namespace Baza_Reklam 7 4 { 8 class ExcelHandler5 public class ExcelHelper 9 6 { 10 public void exportToExcel(DataGridView source)7 public void Export(DataGridView source) 11 8 { 12 9 Excel.ApplicationClass excel = new Excel.ApplicationClass(); -
trunk/BazaReklam/ClientsForm.cs
r243 r351 2381 2381 Cursor = Cursors.WaitCursor; 2382 2382 2383 ExcelH andler ex = new ExcelHandler();2384 ex. exportToExcel(clientsDataGridView);2383 ExcelHelper ex = new ExcelHelper(); 2384 ex.Export(clientsDataGridView); 2385 2385 2386 2386 Cursor = Cursors.Default; -
trunk/BazaReklam/FacturesForm.cs
r338 r351 358 358 Cursor = Cursors.WaitCursor; 359 359 360 ExcelH andler ex = new ExcelHandler();361 ex. exportToExcel(fakturyDataGridView);360 ExcelHelper ex = new ExcelHelper(); 361 ex.Export(fakturyDataGridView); 362 362 363 363 Cursor = Cursors.Default; -
trunk/BazaReklam/FacturesFormNEW.cs
r347 r351 269 269 Cursor = Cursors.WaitCursor; 270 270 271 ExcelH andler ex = new ExcelHandler();272 ex. exportToExcel(fakturyDataGridView);271 ExcelHelper ex = new ExcelHelper(); 272 ex.Export(fakturyDataGridView); 273 273 274 274 Cursor = Cursors.Default; -
trunk/BazaReklam/InfoForm.Designer.cs
r65 r351 300 300 this.bindingNavigatorSeparator11 = new System.Windows.Forms.ToolStripSeparator(); 301 301 this.modulySaveToolStripButton = new System.Windows.Forms.ToolStripButton(); 302 this.excelToolStripButton = new System.Windows.Forms.ToolStripButton(); 302 303 this.toolStripSeparator1 = new System.Windows.Forms.ToolStripSeparator(); 303 304 this.naWydanTab = new System.Windows.Forms.TabPage(); … … 323 324 this.bindingNavigatorSeparator8 = new System.Windows.Forms.ToolStripSeparator(); 324 325 this.zapiszNrWydToolStripButton = new System.Windows.Forms.ToolStripButton(); 326 this.btnExportNrWydan = new System.Windows.Forms.ToolStripButton(); 325 327 this.infoTabControl = new System.Windows.Forms.TabControl(); 326 328 this.agencjeTabPage = new System.Windows.Forms.TabPage(); … … 355 357 this.agencjeListBox = new System.Windows.Forms.ListBox(); 356 358 this.ukrytyLabel = new System.Windows.Forms.Label(); 359 this.btnExportPlan = new System.Windows.Forms.ToolStripButton(); 360 this.btnExportBudzet = new System.Windows.Forms.ToolStripButton(); 357 361 rokLabel = new System.Windows.Forms.Label(); 358 362 miesiacLabel = new System.Windows.Forms.Label(); … … 972 976 this.bindingNavigatorAddNewItem10, 973 977 this.bindingNavigatorDeleteItem10, 974 this.zapiszBudzetToolStripButton}); 978 this.zapiszBudzetToolStripButton, 979 this.btnExportBudzet}); 975 980 this.bindingNavigator11.Location = new System.Drawing.Point(0, 0); 976 981 this.bindingNavigator11.MoveFirstItem = this.bindingNavigatorMoveFirstItem10; … … 1076 1081 this.zapiszBudzetToolStripButton.Name = "zapiszBudzetToolStripButton"; 1077 1082 this.zapiszBudzetToolStripButton.Size = new System.Drawing.Size(23, 22); 1078 this.zapiszBudzetToolStripButton.Text = " toolStripButton1";1083 this.zapiszBudzetToolStripButton.Text = "Zapisz bud¿et"; 1079 1084 this.zapiszBudzetToolStripButton.Click += new System.EventHandler(this.zapiszBudzetToolStripButton_Click); 1080 1085 // … … 1482 1487 this.pLANY_PROWIZJIDataGridView.DataSource = this.pLANYPROWIZJIBindingSource; 1483 1488 this.pLANY_PROWIZJIDataGridView.Dock = System.Windows.Forms.DockStyle.Fill; 1484 this.pLANY_PROWIZJIDataGridView.Location = new System.Drawing.Point(0, 25);1489 this.pLANY_PROWIZJIDataGridView.Location = new System.Drawing.Point(0, 0); 1485 1490 this.pLANY_PROWIZJIDataGridView.Name = "pLANY_PROWIZJIDataGridView"; 1486 1491 this.pLANY_PROWIZJIDataGridView.RowHeadersWidth = 10; 1487 this.pLANY_PROWIZJIDataGridView.Size = new System.Drawing.Size(547, 3 23);1492 this.pLANY_PROWIZJIDataGridView.Size = new System.Drawing.Size(547, 348); 1488 1493 this.pLANY_PROWIZJIDataGridView.TabIndex = 1; 1489 1494 this.pLANY_PROWIZJIDataGridView.CellLeave += new System.Windows.Forms.DataGridViewCellEventHandler(this.pLANY_PROWIZJIDataGridView_CellLeave); … … 1547 1552 this.bindingNavigatorAddNewItem8, 1548 1553 this.bindingNavigatorDeleteItem8, 1549 this.zapiszPlanProwToolStripButton}); 1554 this.zapiszPlanProwToolStripButton, 1555 this.btnExportPlan}); 1550 1556 this.bindingNavigator9.Location = new System.Drawing.Point(0, 0); 1551 1557 this.bindingNavigator9.MoveFirstItem = this.bindingNavigatorMoveFirstItem8; … … 1558 1564 this.bindingNavigator9.TabIndex = 0; 1559 1565 this.bindingNavigator9.Text = "bindingNavigator9"; 1566 this.bindingNavigator9.Visible = false; 1560 1567 // 1561 1568 // bindingNavigatorAddNewItem8 … … 1651 1658 this.zapiszPlanProwToolStripButton.Name = "zapiszPlanProwToolStripButton"; 1652 1659 this.zapiszPlanProwToolStripButton.Size = new System.Drawing.Size(23, 22); 1653 this.zapiszPlanProwToolStripButton.Text = " toolStripButton1";1660 this.zapiszPlanProwToolStripButton.Text = "Zapisz plan prowizji"; 1654 1661 this.zapiszPlanProwToolStripButton.Click += new System.EventHandler(this.zapiszPlanProwToolStripButton_Click); 1655 1662 // … … 2580 2587 this.bindingNavigatorDeleteItem3, 2581 2588 this.modulySaveToolStripButton, 2589 this.excelToolStripButton, 2582 2590 this.toolStripSeparator1}); 2583 2591 this.bindingNavigator4.Location = new System.Drawing.Point(0, 0); … … 2686 2694 this.modulySaveToolStripButton.Text = "toolStripButton1"; 2687 2695 this.modulySaveToolStripButton.Click += new System.EventHandler(this.modulySaveToolStripButton_Click); 2696 // 2697 // excelToolStripButton 2698 // 2699 this.excelToolStripButton.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image; 2700 this.excelToolStripButton.Image = ((System.Drawing.Image)(resources.GetObject("excelToolStripButton.Image"))); 2701 this.excelToolStripButton.ImageTransparentColor = System.Drawing.Color.Magenta; 2702 this.excelToolStripButton.Name = "excelToolStripButton"; 2703 this.excelToolStripButton.Size = new System.Drawing.Size(23, 22); 2704 this.excelToolStripButton.Text = "Exportuj do excela"; 2705 this.excelToolStripButton.Click += new System.EventHandler(this.excelToolStripButton_Click); 2688 2706 // 2689 2707 // toolStripSeparator1 … … 2825 2843 this.bindingNavigatorAddNewItem2, 2826 2844 this.bindingNavigatorDeleteItem2, 2827 this.zapiszNrWydToolStripButton}); 2845 this.zapiszNrWydToolStripButton, 2846 this.btnExportNrWydan}); 2828 2847 this.bindingNavigator3.Location = new System.Drawing.Point(0, 0); 2829 2848 this.bindingNavigator3.MoveFirstItem = this.bindingNavigatorMoveFirstItem2; … … 2930 2949 this.zapiszNrWydToolStripButton.Name = "zapiszNrWydToolStripButton"; 2931 2950 this.zapiszNrWydToolStripButton.Size = new System.Drawing.Size(23, 22); 2932 this.zapiszNrWydToolStripButton.Text = " toolStripButton1";2951 this.zapiszNrWydToolStripButton.Text = "Zapisz nr wydania"; 2933 2952 this.zapiszNrWydToolStripButton.Click += new System.EventHandler(this.saveToolStripButton_Click); 2953 // 2954 // btnExportNrWydan 2955 // 2956 this.btnExportNrWydan.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image; 2957 this.btnExportNrWydan.Image = ((System.Drawing.Image)(resources.GetObject("btnExportNrWydan.Image"))); 2958 this.btnExportNrWydan.ImageTransparentColor = System.Drawing.Color.Magenta; 2959 this.btnExportNrWydan.Name = "btnExportNrWydan"; 2960 this.btnExportNrWydan.Size = new System.Drawing.Size(23, 22); 2961 this.btnExportNrWydan.Text = "Exportuj do excela"; 2962 this.btnExportNrWydan.Click += new System.EventHandler(this.btnExportNrWydan_Click); 2934 2963 // 2935 2964 // infoTabControl … … 3284 3313 this.ukrytyLabel.Text = "ukrytyLabel"; 3285 3314 this.ukrytyLabel.Visible = false; 3315 // 3316 // btnExportPlan 3317 // 3318 this.btnExportPlan.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image; 3319 this.btnExportPlan.Image = ((System.Drawing.Image)(resources.GetObject("btnExportPlan.Image"))); 3320 this.btnExportPlan.ImageTransparentColor = System.Drawing.Color.Magenta; 3321 this.btnExportPlan.Name = "btnExportPlan"; 3322 this.btnExportPlan.Size = new System.Drawing.Size(23, 22); 3323 this.btnExportPlan.Text = "Exportuj do excela"; 3324 this.btnExportPlan.Click += new System.EventHandler(this.btnExportPlan_Click); 3325 // 3326 // btnExportBudzet 3327 // 3328 this.btnExportBudzet.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image; 3329 this.btnExportBudzet.Image = ((System.Drawing.Image)(resources.GetObject("btnExportBudzet.Image"))); 3330 this.btnExportBudzet.ImageTransparentColor = System.Drawing.Color.Magenta; 3331 this.btnExportBudzet.Name = "btnExportBudzet"; 3332 this.btnExportBudzet.Size = new System.Drawing.Size(23, 22); 3333 this.btnExportBudzet.Text = "Exportuj do excela"; 3334 this.btnExportBudzet.Click += new System.EventHandler(this.btnExportBudzet_Click); 3286 3335 // 3287 3336 // InfoForm … … 3658 3707 private System.Windows.Forms.DataGridViewTextBoxColumn dataGridViewTextBoxColumn10; 3659 3708 private System.Windows.Forms.DataGridViewTextBoxColumn Kurs_Sredni_Poznan; 3709 private System.Windows.Forms.ToolStripButton excelToolStripButton; 3710 private System.Windows.Forms.ToolStripButton btnExportNrWydan; 3711 private System.Windows.Forms.ToolStripButton btnExportPlan; 3712 private System.Windows.Forms.ToolStripButton btnExportBudzet; 3660 3713 } 3661 3714 } -
trunk/BazaReklam/InfoForm.cs
r65 r351 1 1 using System; 2 using System.Collections.Generic;3 2 using System.ComponentModel; 4 3 using System.Data; 5 4 using System.Data.SqlClient; 6 using System.Drawing;7 using System.Text;8 5 using System.Windows.Forms; 9 6 using System.Globalization; … … 17 14 public static InfoForm getInfoForm(MDIBazaReklam parent) 18 15 { 19 if (infoform == null) { 16 if (infoform == null) 17 { 20 18 infoform = new InfoForm(parent); 21 19 } … … 26 24 private int ostMs = DateTime.Today.Month; 27 25 28 private InfoForm( MDIBazaReklam parent)26 private InfoForm(Form parent) 29 27 { 30 28 InitializeComponent(); 31 29 32 this.MdiParent = parent;30 MdiParent = parent; 33 31 34 32 //podmiana connstringa … … 48 46 49 47 ImageList imageList = new ImageList(); 50 imageList.Images.Add( Baza_Reklam.Properties.Resources.bullet_ball_glass_green);51 imageList.Images.Add( Baza_Reklam.Properties.Resources.bullet_ball_glass_red);48 imageList.Images.Add(Properties.Resources.bullet_ball_glass_green); 49 imageList.Images.Add(Properties.Resources.bullet_ball_glass_red); 52 50 datyPubTreeView.ImageList = imageList; 53 51 datyPubTreeView.ImageIndex = 0; … … 69 67 bindingNavigator9.Visible = true; 70 68 bindingNavigator10.Visible = true; 71 bindingNavigator11.Visible = true; 72 69 bindingNavigator11.Visible = true; 70 73 71 } 74 72 75 73 private void InfoForm_Load(object sender, EventArgs e) 76 { 77 // this.aGENCJETableAdapter.FillByALL(this.sLOWNIKDataSet.AGENCJE);78 79 this.agencjeListBox.DataSource = this.aGENCJETableAdapter.GetDataByALL();80 this.agencjeListBox.DisplayMember = "Symbol";81 this.agencjeListBox.ValueMember = "Id_agencji";82 83 this.aGENCJETableAdapter.FillByIdAgencji(this.sLOWNIKDataSet.AGENCJE, Convert.ToInt32(agencjeListBox.SelectedValue));84 this.aGENCITableAdapter.FillByIdAgencji(this.sLOWNIKDataSet.AGENCI, Convert.ToInt32(agencjeListBox.SelectedValue));85 86 this.nowyAgentComboBox.DataSource = this.aGENCITableAdapter.GetDataByIdAgencjiAktywni(Convert.ToInt32(agencjeListBox.SelectedValue));87 this.nowyAgentComboBox.DisplayMember = "Symbol";88 this.nowyAgentComboBox.ValueMember = "Symbol";89 90 this.staryAgentComboBox.DataSource = this.aGENCITableAdapter.GetDataByNieaktywniIDAgencji(Convert.ToInt32(agencjeListBox.SelectedValue));91 this.staryAgentComboBox.DisplayMember = "Symbol";92 this.staryAgentComboBox.ValueMember = "Symbol";93 94 95 this.iDBIURADataGridViewTextBoxColumn.DataSource = this.aGENCJETableAdapter.GetData();96 this.iDBIURADataGridViewTextBoxColumn.DisplayMember = "Symbol";97 this.iDBIURADataGridViewTextBoxColumn.ValueMember = "Id_agencji";98 99 this.WindowState = FormWindowState.Maximized;100 101 this.nAZWY_MODULOWTableAdapter.FillByAll(this.sLOWNIKDataSet.NAZWY_MODULOW);74 { 75 // this.aGENCJETableAdapter.FillByALL(this.sLOWNIKDataSet.AGENCJE); 76 77 agencjeListBox.DataSource = aGENCJETableAdapter.GetDataByALL(); 78 agencjeListBox.DisplayMember = "Symbol"; 79 agencjeListBox.ValueMember = "Id_agencji"; 80 81 aGENCJETableAdapter.FillByIdAgencji(sLOWNIKDataSet.AGENCJE, Convert.ToInt32(agencjeListBox.SelectedValue)); 82 aGENCITableAdapter.FillByIdAgencji(sLOWNIKDataSet.AGENCI, Convert.ToInt32(agencjeListBox.SelectedValue)); 83 84 nowyAgentComboBox.DataSource = aGENCITableAdapter.GetDataByIdAgencjiAktywni(Convert.ToInt32(agencjeListBox.SelectedValue)); 85 nowyAgentComboBox.DisplayMember = "Symbol"; 86 nowyAgentComboBox.ValueMember = "Symbol"; 87 88 staryAgentComboBox.DataSource = aGENCITableAdapter.GetDataByNieaktywniIDAgencji(Convert.ToInt32(agencjeListBox.SelectedValue)); 89 staryAgentComboBox.DisplayMember = "Symbol"; 90 staryAgentComboBox.ValueMember = "Symbol"; 91 92 93 iDBIURADataGridViewTextBoxColumn.DataSource = aGENCJETableAdapter.GetData(); 94 iDBIURADataGridViewTextBoxColumn.DisplayMember = "Symbol"; 95 iDBIURADataGridViewTextBoxColumn.ValueMember = "Id_agencji"; 96 97 WindowState = FormWindowState.Maximized; 98 99 nAZWY_MODULOWTableAdapter.FillByAll(sLOWNIKDataSet.NAZWY_MODULOW); 102 100 103 101 generateNodes(); 104 102 generujTytuly(); 105 uprawnienia(); 103 uprawnienia(); 106 104 } 107 105 … … 110 108 if (e.Node != null) 111 109 { 112 this.nRBindingSource.Filter = "[tyt]='" + e.Node.Text + "'";113 } 110 nRBindingSource.Filter = "[tyt]='" + e.Node.Text + "'"; 111 } 114 112 } 115 113 … … 119 117 { 120 118 case "naWydanTab": 121 this.sLOWNIKDataSet.NAZWY_MODULOW.Clear(); 122 this.nRTableAdapter.Fill(this.sLOWNIKDataSet.NR); 123 // this.nrWydanDataGridView.Sort(dATAWDataGridViewTextBoxColumn, ListSortDirection.Descending); 119 sLOWNIKDataSet.NAZWY_MODULOW.Clear(); 120 nRTableAdapter.Fill(sLOWNIKDataSet.NR); 124 121 treeView1.SelectedNode = treeView1.Nodes["AMTNode"]; 125 pozycjaAktualnegoWydania("AMT");126 122 uzupelnijKalendarz(); 127 123 break; 128 124 case "modulyTab": 129 this.sLOWNIKDataSet.NR.Clear();130 this.nAZWY_MODULOWTableAdapter.FillByAll(this.sLOWNIKDataSet.NAZWY_MODULOW);125 sLOWNIKDataSet.NR.Clear(); 126 nAZWY_MODULOWTableAdapter.FillByAll(sLOWNIKDataSet.NAZWY_MODULOW); 131 127 break; 132 128 case "oddzialyTab": 133 this.sLOWNIKDataSet.NAZWY_MODULOW.Clear(); 134 this.sLOWNIKDataSet.NR.Clear(); 135 this.pLANY_PROWIZJITableAdapter.Fill(this.sLOWNIKDataSet.PLANY_PROWIZJI); 136 if (aGENCJEBindingSource.Current != null) { 129 sLOWNIKDataSet.NAZWY_MODULOW.Clear(); 130 sLOWNIKDataSet.NR.Clear(); 131 pLANY_PROWIZJITableAdapter.Fill(sLOWNIKDataSet.PLANY_PROWIZJI); 132 if (aGENCJEBindingSource.Current != null) 133 { 137 134 DataRowView row = (DataRowView)aGENCJEBindingSource.Current; 138 135 int idAgencji = Convert.ToInt32(row["Id_agencji"]); 139 this.kONTATableAdapter.FillByIdAgencji(this.sLOWNIKDataSet.KONTA,idAgencji);140 this.aGENCITableAdapter.FillByIdAgencji(this.sLOWNIKDataSet.AGENCI,idAgencji);136 kONTATableAdapter.FillByIdAgencji(sLOWNIKDataSet.KONTA, idAgencji); 137 aGENCITableAdapter.FillByIdAgencji(sLOWNIKDataSet.AGENCI, idAgencji); 141 138 } 142 139 break; 143 140 case "kursyWalutTabPage": 144 this.daty_publikacjiTableAdapter.Fill(this.sLOWNIKDataSet.Daty_publikacji);141 daty_publikacjiTableAdapter.Fill(sLOWNIKDataSet.Daty_publikacji); 145 142 146 143 TreeNode node; 147 foreach (DataRowView row in datypublikacjiBindingSource.List) { 144 foreach (DataRowView row in datypublikacjiBindingSource.List) 145 { 148 146 node = new TreeNode(); 149 147 node.Text = (Convert.ToDateTime(row["Data_Publikacji"])).ToShortDateString(); 150 148 node.Name = row["Numer_Tabeli"].ToString(); 151 datyPubTreeView.Nodes.Add(node); 149 datyPubTreeView.Nodes.Add(node); 152 150 } 153 151 uprawnienia(); 154 152 break; 155 153 case "grzbietyTabPage": 156 this.lISTA_TYTULOWTableAdapter.FillAll(this.sLOWNIKDataSet.LISTA_TYTULOW);157 this.pROMOCJETableAdapter.Fill(this.sLOWNIKDataSet.PROMOCJE);158 this.gRZBIETYTableAdapter.Fill(this.sLOWNIKDataSet.GRZBIETY);154 lISTA_TYTULOWTableAdapter.FillAll(sLOWNIKDataSet.LISTA_TYTULOW); 155 pROMOCJETableAdapter.Fill(sLOWNIKDataSet.PROMOCJE); 156 gRZBIETYTableAdapter.Fill(sLOWNIKDataSet.GRZBIETY); 159 157 break; 160 158 case "planyProwizyjneTabPage": 161 this.pLANY_PROWIZJITableAdapter.Fill(this.sLOWNIKDataSet.PLANY_PROWIZJI);159 pLANY_PROWIZJITableAdapter.Fill(sLOWNIKDataSet.PLANY_PROWIZJI); 162 160 break; 163 161 case "kosztyBiurTabPage": … … 182 180 { 183 181 case "wszystkieNode": 184 this.nAZWYMODULOWBindingSource.Filter = "";182 nAZWYMODULOWBindingSource.Filter = ""; 185 183 break; 186 184 case "TylkoAktywne": 187 this.nAZWYMODULOWBindingSource.Filter = "St_aktywny=1";185 nAZWYMODULOWBindingSource.Filter = "St_aktywny=1"; 188 186 break; 189 187 } … … 193 191 { 194 192 case "wszystkieNode": 195 this.nAZWYMODULOWBindingSource.Filter = "[tytul]='" + e.Node.Text + "'";193 nAZWYMODULOWBindingSource.Filter = "[tytul]='" + e.Node.Text + "'"; 196 194 break; 197 195 case "TylkoAktywne": 198 this.nAZWYMODULOWBindingSource.Filter = "St_aktywny=1 AND [tytul]='" + e.Node.Text + "'";196 nAZWYMODULOWBindingSource.Filter = "St_aktywny=1 AND [tytul]='" + e.Node.Text + "'"; 199 197 break; 200 198 } 201 199 break; 202 200 default: 203 this.nAZWYMODULOWBindingSource.Filter = "";201 nAZWYMODULOWBindingSource.Filter = ""; 204 202 break; 205 203 } … … 208 206 private void InfoForm_Shown(object sender, EventArgs e) 209 207 { 210 uzupelnijKalendarz(); 208 uzupelnijKalendarz(); 211 209 } 212 210 213 211 private void nRBindingSource_ListChanged(object sender, ListChangedEventArgs e) 214 212 { 215 uzupelnijKalendarz(); 213 uzupelnijKalendarz(); 216 214 } 217 215 218 216 private void naWydanTab_Enter(object sender, EventArgs e) 219 217 { 220 uzupelnijKalendarz(); 218 uzupelnijKalendarz(); 221 219 } 222 220 … … 246 244 MessageBox.Show("Wprowadz poprawne dane"); 247 245 } 248 249 250 private void zapiszAgencjeToolStripButton_Click(object sender, EventArgs e)251 {252 Validate();253 aGENCJEBindingSource.EndEdit();254 aGENCJETableAdapter.Update(this.sLOWNIKDataSet.AGENCJE);255 MessageBox.Show("Zmiany zapisane.");256 }257 258 private void zapiszAgentToolStripButton_Click(object sender, EventArgs e)259 {260 Validate();261 aGENCIBindingSource.EndEdit();262 aGENCITableAdapter.Update(this.sLOWNIKDataSet.AGENCI);263 MessageBox.Show("Zmiany zapisane.");264 }265 246 266 247 private void zapiszGrzbietyToolStripButton_Click(object sender, EventArgs e) … … 268 249 Validate(); 269 250 gRZBIETYBindingSource.EndEdit(); 270 gRZBIETYTableAdapter.Update( this.sLOWNIKDataSet.GRZBIETY);251 gRZBIETYTableAdapter.Update(sLOWNIKDataSet.GRZBIETY); 271 252 MessageBox.Show("Zmiany zapisane."); 272 253 } … … 276 257 Validate(); 277 258 lISTA_TYTULOWBindingSource.EndEdit(); 278 lISTA_TYTULOWTableAdapter.Update( this.sLOWNIKDataSet.LISTA_TYTULOW);259 lISTA_TYTULOWTableAdapter.Update(sLOWNIKDataSet.LISTA_TYTULOW); 279 260 MessageBox.Show("Zmiany zapisane."); 280 261 } … … 284 265 Validate(); 285 266 pROMOCJEBindingSource.EndEdit(); 286 pROMOCJETableAdapter.Update( this.sLOWNIKDataSet.PROMOCJE);267 pROMOCJETableAdapter.Update(sLOWNIKDataSet.PROMOCJE); 287 268 MessageBox.Show("Zmiany zapisane."); 288 269 } … … 292 273 Validate(); 293 274 pLANYPROWIZJIBindingSource.EndEdit(); 294 pLANY_PROWIZJITableAdapter.Update( this.sLOWNIKDataSet.PLANY_PROWIZJI);275 pLANY_PROWIZJITableAdapter.Update(sLOWNIKDataSet.PLANY_PROWIZJI); 295 276 MessageBox.Show("Zmiany zapisane."); 296 277 } … … 318 299 } 319 300 koszty_BiuraBindingSource.EndEdit(); 320 koszty_BiuraTableAdapter.Update( this.sLOWNIKDataSet.Koszty_Biura);301 koszty_BiuraTableAdapter.Update(sLOWNIKDataSet.Koszty_Biura); 321 302 MessageBox.Show("Zmiany zapisane."); 322 303 323 304 podsumujKosztyBiura(); 324 305 } 325 306 326 307 private void zapiszBudzetToolStripButton_Click(object sender, EventArgs e) 327 308 { … … 329 310 Validate(); 330 311 bUDZETBIURBindingSource.EndEdit(); 331 bUDZET_BIURTableAdapter.Update( this.sLOWNIKDataSet.BUDZET_BIUR);312 bUDZET_BIURTableAdapter.Update(sLOWNIKDataSet.BUDZET_BIUR); 332 313 MessageBox.Show("Zmiany zapisane."); 333 314 334 315 } 335 316 … … 348 329 MessageBox.Show("Wprowadz poprawne dane."); 349 330 } 350 331 351 332 private void treeView3_AfterSelect(object sender, TreeViewEventArgs e) 352 333 { 353 334 if (e.Node != null) 354 335 { 355 this.sLOWNIKDataSet.Koszty_Biura.Clear();356 this.koszty_BiuraTableAdapter.FillBy(this.sLOWNIKDataSet.Koszty_Biura, e.Node.Name);357 this.koszty_BiuraBindingSource.MoveLast();336 sLOWNIKDataSet.Koszty_Biura.Clear(); 337 koszty_BiuraTableAdapter.FillBy(sLOWNIKDataSet.Koszty_Biura, e.Node.Name); 338 koszty_BiuraBindingSource.MoveLast(); 358 339 359 340 if (koszty_BiuraBindingSource.Current != null) 360 341 { 361 342 DataRowView row = (DataRowView)koszty_BiuraBindingSource.Current; 362 this.ostRok = Convert.ToInt32(row["rok"]);363 this.ostMs = Convert.ToInt32(row["miesiac"]);343 ostRok = Convert.ToInt32(row["rok"]); 344 ostMs = Convert.ToInt32(row["miesiac"]); 364 345 } 365 346 } … … 370 351 if (e.Node != null) 371 352 { 372 this.sLOWNIKDataSet.BUDZET_BIUR.Clear();373 this.bUDZET_BIURTableAdapter.FillByIdAgencji(this.sLOWNIKDataSet.BUDZET_BIUR, Convert.ToInt32(e.Node.Name));353 sLOWNIKDataSet.BUDZET_BIUR.Clear(); 354 bUDZET_BIURTableAdapter.FillByIdAgencji(sLOWNIKDataSet.BUDZET_BIUR, Convert.ToInt32(e.Node.Name)); 374 355 } 375 356 } … … 379 360 MessageBox.Show("Wprowadz poprawne dane"); 380 361 } 381 362 382 363 private void modulyDataGridView_Leave(object sender, EventArgs e) 383 364 { 384 365 ukrytyLabel.Select(); 385 // modulyDataGridView.EndEdit();366 // modulyDataGridView.EndEdit(); 386 367 } 387 368 … … 389 370 { 390 371 ukrytyLabel.Select(); 391 // kursy_WalutDataGridView.EndEdit();372 // kursy_WalutDataGridView.EndEdit(); 392 373 } 393 374 … … 398 379 } 399 380 400 private void dataGridView1_Leave(object sender, EventArgs e)401 {402 ukrytyLabel.Select();403 //dataGridView1.EndEdit();404 }405 406 private void kONTADataGridView_Leave(object sender, EventArgs e)407 {408 ukrytyLabel.Select();409 //kONTADataGridView.EndEdit();410 }411 412 381 private void gRZBIETYDataGridView_Leave(object sender, EventArgs e) 413 382 { … … 448 417 private void datyPubTreeView_AfterSelect(object sender, TreeViewEventArgs e) 449 418 { 450 this.kursy_WalutTableAdapter.ClearBeforeFill = true;419 kursy_WalutTableAdapter.ClearBeforeFill = true; 451 420 if (datyPubTreeView.SelectedNode != null) 452 421 { 453 this.kursy_WalutTableAdapter.FillByNrTabeli(this.sLOWNIKDataSet.Kursy_Walut, datyPubTreeView.SelectedNode.Name);422 kursy_WalutTableAdapter.FillByNrTabeli(sLOWNIKDataSet.Kursy_Walut, datyPubTreeView.SelectedNode.Name); 454 423 } 455 424 kursy_WalutDataGridView.Refresh(); 456 425 } 457 426 458 private intpozycjaAktualnegoWydania(string tytul)459 {460 int position = 0;461 return position;462 }463 427 //private void pozycjaAktualnegoWydania(string tytul) 428 //{ 429 // int position = 0; 430 // return; 431 //} 432 464 433 // wpisuje dni tygodnia i nr tygodnia w roku 465 434 private void uzupelnijKalendarz() … … 473 442 dzien = Convert.ToDateTime(r.Cells["dATAWDataGridViewTextBoxColumn"].Value); 474 443 r.Cells["dzienTygodniaColumn"].Value = 475 CultureInfo.CurrentCulture.DateTimeFormat.DayNames[(int)dzien.DayOfWeek]; 444 CultureInfo.CurrentCulture.DateTimeFormat.DayNames[(int)dzien.DayOfWeek]; 476 445 r.Cells["nrTygodniaColumn"].Value = myCal.GetWeekOfYear(dzien, CalendarWeekRule.FirstDay, DayOfWeek.Monday).ToString(); 477 446 } … … 490 459 SqlDataReader reader = command.ExecuteReader(); 491 460 492 TreeNode node; 493 TreeNode node1; 494 461 // ReSharper disable PossibleNullReferenceException 495 462 while (reader.Read()) 496 { 497 node = new TreeNode(reader.GetValue(1).ToString()); 498 node1 = new TreeNode(reader.GetValue(1).ToString()); 463 // ReSharper restore PossibleNullReferenceException 464 { 465 TreeNode node = new TreeNode(reader.GetValue(1).ToString()); 466 TreeNode node1 = new TreeNode(reader.GetValue(1).ToString()); 499 467 node.Name = reader.GetValue(0).ToString(); 500 468 node1.Name = reader.GetValue(0).ToString(); … … 516 484 infoTabControl.TabPages.Remove(budzetTabPage); 517 485 } 518 519 if (!(User.getUser().St_kierownik | User.getUser().St_handlowiec | User.getUser().St_subhandlowiec | User.getUser().St_sekretarka)){ 486 487 if (!(User.getUser().St_kierownik | User.getUser().St_handlowiec | User.getUser().St_subhandlowiec | User.getUser().St_sekretarka)) 488 { 520 489 infoTabControl.TabPages.Remove(kursyWalutTabPage); 521 490 infoTabControl.TabPages.Remove(naWydanTab); … … 523 492 } 524 493 525 494 526 495 527 496 dodajAgencjeButton.Enabled = User.getUser().St_kierownik; … … 563 532 } 564 533 565 534 566 535 private void koszty_BiuraBindingSource_AddingNew(object sender, AddingNewEventArgs e) 567 { 536 { 568 537 if (treeView3.SelectedNode != null) 569 538 { 570 539 DataView dataTableView = koszty_BiuraBindingSource.List as DataView; 571 540 541 // ReSharper disable PossibleNullReferenceException 572 542 DataRowView rowView = dataTableView.AddNew(); 543 // ReSharper restore PossibleNullReferenceException 573 544 574 545 rowView["id_Agencji"] = treeView3.SelectedNode.Name; 575 // rowView["rok"] = DateTime.Today.Year;576 // rowView["miesiac"] = DateTime.Today.Month;577 578 if ( this.ostMs == 12)579 { 580 rowView["rok"] = ++ this.ostRok;581 rowView["miesiac"] = this.ostMs = 1;546 // rowView["rok"] = DateTime.Today.Year; 547 // rowView["miesiac"] = DateTime.Today.Month; 548 549 if (ostMs == 12) 550 { 551 rowView["rok"] = ++ostRok; 552 rowView["miesiac"] = ostMs = 1; 582 553 } 583 554 else 584 555 { 585 rowView["rok"] = this.ostRok;586 rowView["miesiac"] = ++ this.ostMs;587 } 556 rowView["rok"] = ostRok; 557 rowView["miesiac"] = ++ostMs; 558 } 588 559 e.NewObject = rowView; 589 560 … … 598 569 DataView dataTableView = bUDZETBIURBindingSource.List as DataView; 599 570 600 DataRowView rowView = dataTableView.AddNew(); 601 602 rowView["ID_BIURA"] = treeView4.SelectedNode.Name; 603 rowView["rok"] = DateTime.Today.Year; 604 rowView["ms"] = DateTime.Today.Month; 605 606 e.NewObject = rowView; 571 if (dataTableView != null) 572 { 573 DataRowView rowView = dataTableView.AddNew(); 574 575 rowView["ID_BIURA"] = treeView4.SelectedNode.Name; 576 rowView["rok"] = DateTime.Today.Year; 577 rowView["ms"] = DateTime.Today.Month; 578 579 e.NewObject = rowView; 580 } 607 581 608 582 bUDZETBIURBindingSource.MoveLast(); … … 610 584 } 611 585 612 private void podsumujKosztyBiura(){ 586 private void podsumujKosztyBiura() 587 { 613 588 if (koszty_BiuraBindingSource.Current != null) 614 589 { 615 590 decimal suma = 0; 616 decimal ksiegowosc = 0 ;617 decimal roznica = 0 ;618 591 619 592 DataRowView r = (DataRowView)koszty_BiuraBindingSource.Current; … … 628 601 suma += r["inne"] == DBNull.Value ? 0 : Convert.ToDecimal(r["inne"]); 629 602 630 ksiegowosc = r["ksiegowosc"] == DBNull.Value ? 0 : Convert.ToDecimal(r["ksiegowosc"]);631 632 roznica = ksiegowosc - suma;603 decimal ksiegowosc = r["ksiegowosc"] == DBNull.Value ? 0 : Convert.ToDecimal(r["ksiegowosc"]); 604 605 decimal roznica = ksiegowosc - suma; 633 606 634 607 razemLabel.Text = String.Format("{0:C}", suma); … … 648 621 { 649 622 int idAgencji = Convert.ToInt32(agencjeListBox.SelectedValue); 650 this.aGENCITableAdapter.FillByIdAgencji(this.sLOWNIKDataSet.AGENCI, idAgencji);651 this.kONTATableAdapter.FillByIdAgencji(this.sLOWNIKDataSet.KONTA, idAgencji);652 this.aGENCJETableAdapter.FillByIdAgencji(this.sLOWNIKDataSet.AGENCJE, idAgencji);653 this.nowyAgentComboBox.DataSource = this.aGENCITableAdapter.GetDataByIdAgencjiAktywni(idAgencji);654 this.staryAgentComboBox.DataSource = this.aGENCITableAdapter.GetDataByNieaktywniIDAgencji(idAgencji);623 aGENCITableAdapter.FillByIdAgencji(sLOWNIKDataSet.AGENCI, idAgencji); 624 kONTATableAdapter.FillByIdAgencji(sLOWNIKDataSet.KONTA, idAgencji); 625 aGENCJETableAdapter.FillByIdAgencji(sLOWNIKDataSet.AGENCJE, idAgencji); 626 nowyAgentComboBox.DataSource = aGENCITableAdapter.GetDataByIdAgencjiAktywni(idAgencji); 627 staryAgentComboBox.DataSource = aGENCITableAdapter.GetDataByNieaktywniIDAgencji(idAgencji); 655 628 656 629 groupBox1.Enabled = User.getUser().St_kierownik & (idAgencji == User.getUser().IdAgencji); 657 }658 }659 660 private void button3_Click(object sender, EventArgs e)661 {662 if ((this.aGENCIBindingSource.Filter==null) || (this.aGENCIBindingSource.Filter == ""))663 {664 this.aGENCIBindingSource.Filter = "aktywny=1";665 }666 else667 {668 this.aGENCIBindingSource.Filter = "";669 630 } 670 631 } … … 698 659 if (aaf.ShowDialog() == DialogResult.OK) 699 660 { 700 aGENCITableAdapter.FillByIdAgencji( this.sLOWNIKDataSet.AGENCI, Convert.ToInt32(agencjeListBox.SelectedValue));661 aGENCITableAdapter.FillByIdAgencji(sLOWNIKDataSet.AGENCI, Convert.ToInt32(agencjeListBox.SelectedValue)); 701 662 //agencjeListBox.DataSource = aGENCJETableAdapter.GetDataByALL(); 702 663 } … … 713 674 if (aaf.ShowDialog() == DialogResult.OK) 714 675 { 715 aGENCITableAdapter.FillByIdAgencji( this.sLOWNIKDataSet.AGENCI, Convert.ToInt32(agencjeListBox.SelectedValue));676 aGENCITableAdapter.FillByIdAgencji(sLOWNIKDataSet.AGENCI, Convert.ToInt32(agencjeListBox.SelectedValue)); 716 677 } 717 678 } … … 725 686 { 726 687 727 kONTATableAdapter.FillByIdAgencji( this.sLOWNIKDataSet.KONTA, Convert.ToInt32(agencjeListBox.SelectedValue));688 kONTATableAdapter.FillByIdAgencji(sLOWNIKDataSet.KONTA, Convert.ToInt32(agencjeListBox.SelectedValue)); 728 689 //agencjeListBox.DataSource = aGENCJETableAdapter.GetDataByALL(); 729 690 } … … 740 701 if (aaf.ShowDialog() == DialogResult.OK) 741 702 { 742 kONTATableAdapter.FillByIdAgencji( this.sLOWNIKDataSet.KONTA, Convert.ToInt32(agencjeListBox.SelectedValue));703 kONTATableAdapter.FillByIdAgencji(sLOWNIKDataSet.KONTA, Convert.ToInt32(agencjeListBox.SelectedValue)); 743 704 } 744 705 } … … 753 714 } 754 715 755 this.Cursor = Cursors.WaitCursor;716 Cursor = Cursors.WaitCursor; 756 717 757 718 SqlCommand command = new SqlCommand(); … … 791 752 command.Connection.Close(); 792 753 793 this.Cursor = Cursors.Default; 794 795 } 796 797 private void generujTytuly(){ 798 799 SLOWNIKDataSet.LISTA_TYTULOWDataTable dt = lISTA_TYTULOWTableAdapter.GetData() 800 as SLOWNIKDataSet.LISTA_TYTULOWDataTable; 801 802 foreach (SLOWNIKDataSet.LISTA_TYTULOWRow r in dt) { 754 Cursor = Cursors.Default; 755 756 } 757 758 private void generujTytuly() 759 { 760 761 SLOWNIKDataSet.LISTA_TYTULOWDataTable dt = lISTA_TYTULOWTableAdapter.GetData(); 762 763 foreach (SLOWNIKDataSet.LISTA_TYTULOWRow r in dt) 764 { 803 765 treeView1.Nodes.Add(new TreeNode(r.SYMB)); 804 766 treeView2.Nodes["wszystkieNode"].Nodes.Add(new TreeNode(r.SYMB)); 805 treeView2.Nodes["TylkoAktywne"].Nodes.Add(new TreeNode(r.SYMB)); 767 treeView2.Nodes["TylkoAktywne"].Nodes.Add(new TreeNode(r.SYMB)); 806 768 } 807 769 } … … 823 785 kursy_WalutDataGridView.EndEdit(); 824 786 kursy_WalutBindingSource.EndEdit(); 825 kursy_WalutTableAdapter.Update( this.sLOWNIKDataSet.Kursy_Walut);787 kursy_WalutTableAdapter.Update(sLOWNIKDataSet.Kursy_Walut); 826 788 } 827 789 } … … 830 792 } 831 793 832 833 834 } 794 private void excelToolStripButton_Click(object sender, EventArgs e) 795 { 796 Cursor = Cursors.WaitCursor; 797 798 ExcelHelper ex = new ExcelHelper(); 799 ex.Export(modulyDataGridView); 800 801 Cursor = Cursors.Default; 802 } 803 804 private void btnExportNrWydan_Click(object sender, EventArgs e) 805 { 806 Cursor = Cursors.WaitCursor; 807 808 ExcelHelper ex = new ExcelHelper(); 809 ex.Export(nrWydanDataGridView); 810 811 Cursor = Cursors.Default; 812 } 813 814 private void btnExportPlan_Click(object sender, EventArgs e) 815 { 816 Cursor = Cursors.WaitCursor; 817 818 ExcelHelper ex = new ExcelHelper(); 819 ex.Export(pLANY_PROWIZJIDataGridView); 820 821 Cursor = Cursors.Default; 822 } 823 824 private void btnExportBudzet_Click(object sender, EventArgs e) 825 { 826 Cursor = Cursors.WaitCursor; 827 828 ExcelHelper ex = new ExcelHelper(); 829 ex.Export(budzetyDataGridView); 830 831 Cursor = Cursors.Default; 832 } 833 } 835 834 } -
trunk/BazaReklam/InfoForm.resx
r65 r351 390 390 </value> 391 391 </data> 392 <data name="btnExportBudzet.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64"> 393 <value> 394 iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8 395 YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAAAplJREFUSEu1VtlK 396 HEEULfMD+YSQvOQP8pbn5BOSfwj5hrzkA4zbjIrbuOs4rjcGEUQEEZdy33dxY1xxGTTKSZ+qruk4dkBI 397 23DpOxfmnLqnTtXtPBU8eX/lUaSwILHfH1UciDS+/PzsIb/04oUicHwsunif9Ber1AdL4hOo72lEEvkZ 398 q4ZS37x4bQiyrFFKpVS+R/DWEIyPa2j9OFgfHdUYGdEYHtYYGtIYHNQYGNDo79fo69Po7dUQ0ejq0ujo 399 0EiltOvgR5bg7g7mERGb+DnrNzdAe7vg8hI4PweamwXpNHBwACQSgq0tYH0dKC8XLC4Cc3PZPQgI7u/D 400 CVi/vY2AoKdHzOpzg/XOTjEdtLUJWlvFdNDYKKivF9NBdbWgokJMB6WlglhMHkv07B08+x5Qhu5uASVx 401 wd9OnlRKkEwKWloETU2ChgZBXZ2gpkZQVfUEiTIZ6xYCclMZzFm/voYBp4NOTmD0PzwE9vZg9N/cBNbW 402 rIsWFoDZ2RAXXV1ZIG4mQRnMWb+4gNnc01Pg+Bhm9bTo7q4loEVXV4GyMsH8PDAzE0LAFdIlucE6wZ00 403 zj21tf+Wp7g4xEVnZ/YQEYxvl7NOWag7DxelofY7OzAHjPbk6peWvMsyLkaeqamQDtg6gehxvl3O+tFR 404 IMv+fnB6NzYswfIyzAmm/6engcnJEALqyvZzg3UeKIaThbpXVj50DldfUiIoKhIUFIRIxJVx4wjEt8tZ 405 p1t4Yp0sBKdrVlbsxjrnUHvvvvQuzpAO+Ge6gkB8u5z17e3AjnQMZSG4052XG6UpLBRMTABj3vDy54F/ 406 XX/99SnSccmZ8updIhg4dnZyvHECkZXX7P8EMYjlj0wzmA3JGzsgIgli+UP/4WcLP12iCoP8BxdAjuo0 407 CNGlAAAAAElFTkSuQmCC 408 </value> 409 </data> 392 410 <metadata name="bindingNavigator10.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"> 393 411 <value>875, 290</value> … … 602 620 </value> 603 621 </data> 622 <data name="btnExportPlan.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64"> 623 <value> 624 iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8 625 YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAAAplJREFUSEu1VtlK 626 HEEULfMD+YSQvOQP8pbn5BOSfwj5hrzkA4zbjIrbuOs4rjcGEUQEEZdy33dxY1xxGTTKSZ+qruk4dkBI 627 23DpOxfmnLqnTtXtPBU8eX/lUaSwILHfH1UciDS+/PzsIb/04oUicHwsunif9Ber1AdL4hOo72lEEvkZ 628 q4ZS37x4bQiyrFFKpVS+R/DWEIyPa2j9OFgfHdUYGdEYHtYYGtIYHNQYGNDo79fo69Po7dUQ0ejq0ujo 629 0EiltOvgR5bg7g7mERGb+DnrNzdAe7vg8hI4PweamwXpNHBwACQSgq0tYH0dKC8XLC4Cc3PZPQgI7u/D 630 CVi/vY2AoKdHzOpzg/XOTjEdtLUJWlvFdNDYKKivF9NBdbWgokJMB6WlglhMHkv07B08+x5Qhu5uASVx 631 wd9OnlRKkEwKWloETU2ChgZBXZ2gpkZQVfUEiTIZ6xYCclMZzFm/voYBp4NOTmD0PzwE9vZg9N/cBNbW 632 rIsWFoDZ2RAXXV1ZIG4mQRnMWb+4gNnc01Pg+Bhm9bTo7q4loEVXV4GyMsH8PDAzE0LAFdIlucE6wZ00 633 zj21tf+Wp7g4xEVnZ/YQEYxvl7NOWag7DxelofY7OzAHjPbk6peWvMsyLkaeqamQDtg6gehxvl3O+tFR 634 IMv+fnB6NzYswfIyzAmm/6engcnJEALqyvZzg3UeKIaThbpXVj50DldfUiIoKhIUFIRIxJVx4wjEt8tZ 635 p1t4Yp0sBKdrVlbsxjrnUHvvvvQuzpAO+Ge6gkB8u5z17e3AjnQMZSG4052XG6UpLBRMTABj3vDy54F/ 636 XX/99SnSccmZ8updIhg4dnZyvHECkZXX7P8EMYjlj0wzmA3JGzsgIgli+UP/4WcLP12iCoP8BxdAjuo0 637 CNGlAAAAAElFTkSuQmCC 638 </value> 639 </data> 604 640 <metadata name="bindingNavigator8.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"> 605 641 <value>755, 212</value> … … 1038 1074 </value> 1039 1075 </data> 1076 <data name="excelToolStripButton.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64"> 1077 <value> 1078 iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8 1079 YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAAAplJREFUSEu1VtlK 1080 HEEULfMD+YSQvOQP8pbn5BOSfwj5hrzkA4zbjIrbuOs4rjcGEUQEEZdy33dxY1xxGTTKSZ+qruk4dkBI 1081 23DpOxfmnLqnTtXtPBU8eX/lUaSwILHfH1UciDS+/PzsIb/04oUicHwsunif9Ber1AdL4hOo72lEEvkZ 1082 q4ZS37x4bQiyrFFKpVS+R/DWEIyPa2j9OFgfHdUYGdEYHtYYGtIYHNQYGNDo79fo69Po7dUQ0ejq0ujo 1083 0EiltOvgR5bg7g7mERGb+DnrNzdAe7vg8hI4PweamwXpNHBwACQSgq0tYH0dKC8XLC4Cc3PZPQgI7u/D 1084 CVi/vY2AoKdHzOpzg/XOTjEdtLUJWlvFdNDYKKivF9NBdbWgokJMB6WlglhMHkv07B08+x5Qhu5uASVx 1085 wd9OnlRKkEwKWloETU2ChgZBXZ2gpkZQVfUEiTIZ6xYCclMZzFm/voYBp4NOTmD0PzwE9vZg9N/cBNbW 1086 rIsWFoDZ2RAXXV1ZIG4mQRnMWb+4gNnc01Pg+Bhm9bTo7q4loEVXV4GyMsH8PDAzE0LAFdIlucE6wZ00 1087 zj21tf+Wp7g4xEVnZ/YQEYxvl7NOWag7DxelofY7OzAHjPbk6peWvMsyLkaeqamQDtg6gehxvl3O+tFR 1088 IMv+fnB6NzYswfIyzAmm/6engcnJEALqyvZzg3UeKIaThbpXVj50DldfUiIoKhIUFIRIxJVx4wjEt8tZ 1089 p1t4Yp0sBKdrVlbsxjrnUHvvvvQuzpAO+Ge6gkB8u5z17e3AjnQMZSG4052XG6UpLBRMTABj3vDy54F/ 1090 XX/99SnSccmZ8updIhg4dnZyvHECkZXX7P8EMYjlj0wzmA3JGzsgIgli+UP/4WcLP12iCoP8BxdAjuo0 1091 CNGlAAAAAElFTkSuQmCC 1092 </value> 1093 </data> 1040 1094 <metadata name="dzienTygodniaColumn.UserAddedColumn" type="System.Boolean, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> 1041 1095 <value>True</value> … … 1136 1190 </value> 1137 1191 </data> 1192 <data name="btnExportNrWydan.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64"> 1193 <value> 1194 iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8 1195 YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAAAplJREFUSEu1VtlK 1196 HEEULfMD+YSQvOQP8pbn5BOSfwj5hrzkA4zbjIrbuOs4rjcGEUQEEZdy33dxY1xxGTTKSZ+qruk4dkBI 1197 23DpOxfmnLqnTtXtPBU8eX/lUaSwILHfH1UciDS+/PzsIb/04oUicHwsunif9Ber1AdL4hOo72lEEvkZ 1198 q4ZS37x4bQiyrFFKpVS+R/DWEIyPa2j9OFgfHdUYGdEYHtYYGtIYHNQYGNDo79fo69Po7dUQ0ejq0ujo 1199 0EiltOvgR5bg7g7mERGb+DnrNzdAe7vg8hI4PweamwXpNHBwACQSgq0tYH0dKC8XLC4Cc3PZPQgI7u/D 1200 CVi/vY2AoKdHzOpzg/XOTjEdtLUJWlvFdNDYKKivF9NBdbWgokJMB6WlglhMHkv07B08+x5Qhu5uASVx 1201 wd9OnlRKkEwKWloETU2ChgZBXZ2gpkZQVfUEiTIZ6xYCclMZzFm/voYBp4NOTmD0PzwE9vZg9N/cBNbW 1202 rIsWFoDZ2RAXXV1ZIG4mQRnMWb+4gNnc01Pg+Bhm9bTo7q4loEVXV4GyMsH8PDAzE0LAFdIlucE6wZ00 1203 zj21tf+Wp7g4xEVnZ/YQEYxvl7NOWag7DxelofY7OzAHjPbk6peWvMsyLkaeqamQDtg6gehxvl3O+tFR 1204 IMv+fnB6NzYswfIyzAmm/6engcnJEALqyvZzg3UeKIaThbpXVj50DldfUiIoKhIUFIRIxJVx4wjEt8tZ 1205 p1t4Yp0sBKdrVlbsxjrnUHvvvvQuzpAO+Ge6gkB8u5z17e3AjnQMZSG4052XG6UpLBRMTABj3vDy54F/ 1206 XX/99SnSccmZ8updIhg4dnZyvHECkZXX7P8EMYjlj0wzmA3JGzsgIgli+UP/4WcLP12iCoP8BxdAjuo0 1207 CNGlAAAAAElFTkSuQmCC 1208 </value> 1209 </data> 1138 1210 <metadata name="ImiÄ.UserAddedColumn" type="System.Boolean, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> 1139 1211 <value>True</value> -
trunk/BazaReklam/KorektyForm.cs
r263 r351 478 478 this.Cursor = Cursors.WaitCursor; 479 479 480 ExcelH andler ex = new ExcelHandler();481 ex. exportToExcel(fakturyDataGridView);480 ExcelHelper ex = new ExcelHelper(); 481 ex.Export(fakturyDataGridView); 482 482 483 483 this.Cursor = Cursors.Default; -
trunk/BazaReklam/OrdersForm.cs
r340 r351 1266 1266 Cursor = Cursors.WaitCursor; 1267 1267 1268 ExcelH andler ex = new ExcelHandler();1269 ex. exportToExcel(reklamaDataGridView);1268 ExcelHelper ex = new ExcelHelper(); 1269 ex.Export(reklamaDataGridView); 1270 1270 1271 1271 Cursor = Cursors.Default; -
trunk/BazaReklam/ZestawienieZamowienForm.Designer.cs
r350 r351 31 31 this.components = new System.ComponentModel.Container(); 32 32 System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(ZestawienieZamowienForm)); 33 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle 1 = new System.Windows.Forms.DataGridViewCellStyle();34 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle2 = new System.Windows.Forms.DataGridViewCellStyle();35 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle 3 = new System.Windows.Forms.DataGridViewCellStyle();36 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle 4 = new System.Windows.Forms.DataGridViewCellStyle();37 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle 5 = new System.Windows.Forms.DataGridViewCellStyle();38 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle 6 = new System.Windows.Forms.DataGridViewCellStyle();39 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle 7 = new System.Windows.Forms.DataGridViewCellStyle();40 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle 8 = new System.Windows.Forms.DataGridViewCellStyle();41 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle 9 = new System.Windows.Forms.DataGridViewCellStyle();42 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle 10 = new System.Windows.Forms.DataGridViewCellStyle();43 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle 11 = new System.Windows.Forms.DataGridViewCellStyle();44 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle 12 = new System.Windows.Forms.DataGridViewCellStyle();45 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle 13 = new System.Windows.Forms.DataGridViewCellStyle();46 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle 14 = new System.Windows.Forms.DataGridViewCellStyle();47 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle 15 = new System.Windows.Forms.DataGridViewCellStyle();48 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle 16 = new System.Windows.Forms.DataGridViewCellStyle();49 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle 17 = new System.Windows.Forms.DataGridViewCellStyle();50 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle 18 = new System.Windows.Forms.DataGridViewCellStyle();51 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle 19 = new System.Windows.Forms.DataGridViewCellStyle();52 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle 20 = new System.Windows.Forms.DataGridViewCellStyle();33 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle21 = new System.Windows.Forms.DataGridViewCellStyle(); 34 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle22 = new System.Windows.Forms.DataGridViewCellStyle(); 35 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle23 = new System.Windows.Forms.DataGridViewCellStyle(); 36 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle24 = new System.Windows.Forms.DataGridViewCellStyle(); 37 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle25 = new System.Windows.Forms.DataGridViewCellStyle(); 38 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle26 = new System.Windows.Forms.DataGridViewCellStyle(); 39 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle27 = new System.Windows.Forms.DataGridViewCellStyle(); 40 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle28 = new System.Windows.Forms.DataGridViewCellStyle(); 41 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle29 = new System.Windows.Forms.DataGridViewCellStyle(); 42 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle30 = new System.Windows.Forms.DataGridViewCellStyle(); 43 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle31 = new System.Windows.Forms.DataGridViewCellStyle(); 44 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle32 = new System.Windows.Forms.DataGridViewCellStyle(); 45 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle33 = new System.Windows.Forms.DataGridViewCellStyle(); 46 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle34 = new System.Windows.Forms.DataGridViewCellStyle(); 47 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle35 = new System.Windows.Forms.DataGridViewCellStyle(); 48 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle36 = new System.Windows.Forms.DataGridViewCellStyle(); 49 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle37 = new System.Windows.Forms.DataGridViewCellStyle(); 50 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle38 = new System.Windows.Forms.DataGridViewCellStyle(); 51 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle39 = new System.Windows.Forms.DataGridViewCellStyle(); 52 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle40 = new System.Windows.Forms.DataGridViewCellStyle(); 53 53 this.bindingNavigator1 = new System.Windows.Forms.BindingNavigator(this.components); 54 54 this.VIEW_ZESTAWIENIE_ZAMOWIEN_NOWEBindingSource = new System.Windows.Forms.BindingSource(this.components); … … 82 82 this.toolStripLabel4 = new System.Windows.Forms.ToolStripLabel(); 83 83 this.rokToolStripTextBox = new System.Windows.Forms.ToolStripTextBox(); 84 this.toolStripLabel6 = new System.Windows.Forms.ToolStripLabel(); 85 this.txtMiesiac = new System.Windows.Forms.ToolStripTextBox(); 84 86 this.toolStripLabel5 = new System.Windows.Forms.ToolStripLabel(); 85 87 this.nrZamToolStripTextBox = new System.Windows.Forms.ToolStripTextBox(); … … 131 133 this.VIEW_ZESTAWIENIE_ZAMOWIEN_NOWETableAdapter = new Baza_Reklam.REKLAMADataSetTableAdapters.VIEW_ZESTAWIENIE_ZAMOWIEN_NOWETableAdapter(); 132 134 this.reklamyZestawienieTableAdapter = new Baza_Reklam.REKLAMADataSetTableAdapters.ReklamyZestawienieTableAdapter(); 133 this.toolStripLabel6 = new System.Windows.Forms.ToolStripLabel();134 this.txtMiesiac = new System.Windows.Forms.ToolStripTextBox();135 135 ((System.ComponentModel.ISupportInitialize)(this.bindingNavigator1)).BeginInit(); 136 136 this.bindingNavigator1.SuspendLayout(); … … 432 432 this.rokToolStripTextBox.Size = new System.Drawing.Size(40, 25); 433 433 // 434 // toolStripLabel6 435 // 436 this.toolStripLabel6.Name = "toolStripLabel6"; 437 this.toolStripLabel6.Size = new System.Drawing.Size(45, 22); 438 this.toolStripLabel6.Text = "miesi¹c:"; 439 // 440 // txtMiesiac 441 // 442 this.txtMiesiac.Name = "txtMiesiac"; 443 this.txtMiesiac.Size = new System.Drawing.Size(20, 25); 444 // 434 445 // toolStripLabel5 435 446 // … … 514 525 this.fakturyDataGridView.AllowUserToAddRows = false; 515 526 this.fakturyDataGridView.AllowUserToDeleteRows = false; 516 dataGridViewCellStyle 1.BackColor = System.Drawing.Color.MintCream;517 this.fakturyDataGridView.AlternatingRowsDefaultCellStyle = dataGridViewCellStyle 1;527 dataGridViewCellStyle21.BackColor = System.Drawing.Color.MintCream; 528 this.fakturyDataGridView.AlternatingRowsDefaultCellStyle = dataGridViewCellStyle21; 518 529 this.fakturyDataGridView.AutoGenerateColumns = false; 519 530 this.fakturyDataGridView.AutoSizeColumnsMode = System.Windows.Forms.DataGridViewAutoSizeColumnsMode.DisplayedCells; 520 531 this.fakturyDataGridView.BackgroundColor = System.Drawing.Color.White; 521 dataGridViewCellStyle2 .Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;522 dataGridViewCellStyle2 .BackColor = System.Drawing.SystemColors.Control;523 dataGridViewCellStyle2 .Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(238)));524 dataGridViewCellStyle2 .ForeColor = System.Drawing.SystemColors.WindowText;525 dataGridViewCellStyle2 .SelectionBackColor = System.Drawing.SystemColors.Highlight;526 dataGridViewCellStyle2 .SelectionForeColor = System.Drawing.SystemColors.HighlightText;527 dataGridViewCellStyle2 .WrapMode = System.Windows.Forms.DataGridViewTriState.True;528 this.fakturyDataGridView.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle2 ;532 dataGridViewCellStyle22.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; 533 dataGridViewCellStyle22.BackColor = System.Drawing.SystemColors.Control; 534 dataGridViewCellStyle22.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(238))); 535 dataGridViewCellStyle22.ForeColor = System.Drawing.SystemColors.WindowText; 536 dataGridViewCellStyle22.SelectionBackColor = System.Drawing.SystemColors.Highlight; 537 dataGridViewCellStyle22.SelectionForeColor = System.Drawing.SystemColors.HighlightText; 538 dataGridViewCellStyle22.WrapMode = System.Windows.Forms.DataGridViewTriState.True; 539 this.fakturyDataGridView.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle22; 529 540 this.fakturyDataGridView.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; 530 541 this.fakturyDataGridView.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] { … … 557 568 // 558 569 this.agencja.DataPropertyName = "agencja"; 559 dataGridViewCellStyle 3.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;560 this.agencja.DefaultCellStyle = dataGridViewCellStyle 3;570 dataGridViewCellStyle23.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; 571 this.agencja.DefaultCellStyle = dataGridViewCellStyle23; 561 572 this.agencja.HeaderText = "Agencja"; 562 573 this.agencja.Name = "agencja"; … … 567 578 // 568 579 this.agent.DataPropertyName = "agent"; 569 dataGridViewCellStyle 4.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;570 this.agent.DefaultCellStyle = dataGridViewCellStyle 4;580 dataGridViewCellStyle24.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; 581 this.agent.DefaultCellStyle = dataGridViewCellStyle24; 571 582 this.agent.HeaderText = "Agent"; 572 583 this.agent.Name = "agent"; … … 577 588 // 578 589 this.rokZamowienia.DataPropertyName = "rokZamowienia"; 579 dataGridViewCellStyle 5.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;580 this.rokZamowienia.DefaultCellStyle = dataGridViewCellStyle 5;590 dataGridViewCellStyle25.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; 591 this.rokZamowienia.DefaultCellStyle = dataGridViewCellStyle25; 581 592 this.rokZamowienia.HeaderText = "Rok"; 582 593 this.rokZamowienia.Name = "rokZamowienia"; … … 596 607 this.iloscReklam.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; 597 608 this.iloscReklam.DataPropertyName = "iloscReklam"; 598 dataGridViewCellStyle 6.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;599 this.iloscReklam.DefaultCellStyle = dataGridViewCellStyle 6;609 dataGridViewCellStyle26.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; 610 this.iloscReklam.DefaultCellStyle = dataGridViewCellStyle26; 600 611 this.iloscReklam.HeaderText = "# rek"; 601 612 this.iloscReklam.Name = "iloscReklam"; … … 607 618 this.data_od.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; 608 619 this.data_od.DataPropertyName = "data_od"; 609 dataGridViewCellStyle 7.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;610 dataGridViewCellStyle 7.Format = "d";611 this.data_od.DefaultCellStyle = dataGridViewCellStyle 7;620 dataGridViewCellStyle27.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; 621 dataGridViewCellStyle27.Format = "d"; 622 this.data_od.DefaultCellStyle = dataGridViewCellStyle27; 612 623 this.data_od.HeaderText = "Data 1 em"; 613 624 this.data_od.Name = "data_od"; … … 619 630 this.data_od_bez_FK.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; 620 631 this.data_od_bez_FK.DataPropertyName = "data_od_bez_FK"; 621 dataGridViewCellStyle 8.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;622 this.data_od_bez_FK.DefaultCellStyle = dataGridViewCellStyle 8;632 dataGridViewCellStyle28.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; 633 this.data_od_bez_FK.DefaultCellStyle = dataGridViewCellStyle28; 623 634 this.data_od_bez_FK.HeaderText = "Data 1 em bez FV"; 624 635 this.data_od_bez_FK.Name = "data_od_bez_FK"; … … 630 641 this.wartoscNetto.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; 631 642 this.wartoscNetto.DataPropertyName = "wartoscNetto"; 632 dataGridViewCellStyle 9.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight;633 dataGridViewCellStyle 9.Format = "C2";634 this.wartoscNetto.DefaultCellStyle = dataGridViewCellStyle 9;643 dataGridViewCellStyle29.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight; 644 dataGridViewCellStyle29.Format = "C2"; 645 this.wartoscNetto.DefaultCellStyle = dataGridViewCellStyle29; 635 646 this.wartoscNetto.HeaderText = "Netto"; 636 647 this.wartoscNetto.Name = "wartoscNetto"; … … 642 653 this.kwotaWalutaBrutto.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; 643 654 this.kwotaWalutaBrutto.DataPropertyName = "kwotaWalutaBrutto"; 644 dataGridViewCellStyle 10.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight;645 dataGridViewCellStyle 10.Format = "N2";646 dataGridViewCellStyle 10.NullValue = null;647 this.kwotaWalutaBrutto.DefaultCellStyle = dataGridViewCellStyle 10;655 dataGridViewCellStyle30.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight; 656 dataGridViewCellStyle30.Format = "N2"; 657 dataGridViewCellStyle30.NullValue = null; 658 this.kwotaWalutaBrutto.DefaultCellStyle = dataGridViewCellStyle30; 648 659 this.kwotaWalutaBrutto.HeaderText = "Waluta - brutto zamówienia"; 649 660 this.kwotaWalutaBrutto.Name = "kwotaWalutaBrutto"; … … 655 666 this.bruttoEuroMianoDataGridViewTextBoxColumn.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; 656 667 this.bruttoEuroMianoDataGridViewTextBoxColumn.DataPropertyName = "Brutto_Euro_Miano"; 657 dataGridViewCellStyle 11.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;658 this.bruttoEuroMianoDataGridViewTextBoxColumn.DefaultCellStyle = dataGridViewCellStyle 11;668 dataGridViewCellStyle31.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; 669 this.bruttoEuroMianoDataGridViewTextBoxColumn.DefaultCellStyle = dataGridViewCellStyle31; 659 670 this.bruttoEuroMianoDataGridViewTextBoxColumn.HeaderText = "W"; 660 671 this.bruttoEuroMianoDataGridViewTextBoxColumn.Name = "bruttoEuroMianoDataGridViewTextBoxColumn"; … … 666 677 this.nettoZafakturowane.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; 667 678 this.nettoZafakturowane.DataPropertyName = "nettoZafakturowane"; 668 dataGridViewCellStyle 12.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight;669 dataGridViewCellStyle 12.Format = "C2";670 this.nettoZafakturowane.DefaultCellStyle = dataGridViewCellStyle 12;679 dataGridViewCellStyle32.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight; 680 dataGridViewCellStyle32.Format = "C2"; 681 this.nettoZafakturowane.DefaultCellStyle = dataGridViewCellStyle32; 671 682 this.nettoZafakturowane.HeaderText = "Wartoæ netto FV"; 672 683 this.nettoZafakturowane.Name = "nettoZafakturowane"; … … 678 689 this.DoZafakturowania.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; 679 690 this.DoZafakturowania.DataPropertyName = "DoZafakturowania"; 680 dataGridViewCellStyle 13.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight;681 dataGridViewCellStyle 13.Format = "N2";682 dataGridViewCellStyle 13.NullValue = null;683 this.DoZafakturowania.DefaultCellStyle = dataGridViewCellStyle 13;691 dataGridViewCellStyle33.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight; 692 dataGridViewCellStyle33.Format = "N2"; 693 dataGridViewCellStyle33.NullValue = null; 694 this.DoZafakturowania.DefaultCellStyle = dataGridViewCellStyle33; 684 695 this.DoZafakturowania.HeaderText = "Wartoæ niezafakturowana"; 685 696 this.DoZafakturowania.Name = "DoZafakturowania"; … … 761 772 this.dataGridViewTextBoxColumn8.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; 762 773 this.dataGridViewTextBoxColumn8.DataPropertyName = "1emisja"; 763 dataGridViewCellStyle 14.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;764 dataGridViewCellStyle 14.Format = "d";765 this.dataGridViewTextBoxColumn8.DefaultCellStyle = dataGridViewCellStyle 14;774 dataGridViewCellStyle34.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; 775 dataGridViewCellStyle34.Format = "d"; 776 this.dataGridViewTextBoxColumn8.DefaultCellStyle = dataGridViewCellStyle34; 766 777 this.dataGridViewTextBoxColumn8.HeaderText = "1 emisja"; 767 778 this.dataGridViewTextBoxColumn8.Name = "dataGridViewTextBoxColumn8"; … … 809 820 this.dataGridViewTextBoxColumn23.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; 810 821 this.dataGridViewTextBoxColumn23.DataPropertyName = "CENA JEDN"; 811 dataGridViewCellStyle 15.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight;812 dataGridViewCellStyle 15.Format = "C2";813 this.dataGridViewTextBoxColumn23.DefaultCellStyle = dataGridViewCellStyle 15;822 dataGridViewCellStyle35.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight; 823 dataGridViewCellStyle35.Format = "C2"; 824 this.dataGridViewTextBoxColumn23.DefaultCellStyle = dataGridViewCellStyle35; 814 825 this.dataGridViewTextBoxColumn23.HeaderText = "Cena jedn."; 815 826 this.dataGridViewTextBoxColumn23.Name = "dataGridViewTextBoxColumn23"; … … 821 832 this.RABAT_WARTOSC.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; 822 833 this.RABAT_WARTOSC.DataPropertyName = "RABAT WARTOÆ"; 823 dataGridViewCellStyle 16.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight;824 dataGridViewCellStyle 16.Format = "C2";825 this.RABAT_WARTOSC.DefaultCellStyle = dataGridViewCellStyle 16;834 dataGridViewCellStyle36.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight; 835 dataGridViewCellStyle36.Format = "C2"; 836 this.RABAT_WARTOSC.DefaultCellStyle = dataGridViewCellStyle36; 826 837 this.RABAT_WARTOSC.HeaderText = "Rabat"; 827 838 this.RABAT_WARTOSC.Name = "RABAT_WARTOSC"; … … 833 844 this.dataGridViewTextBoxColumn24.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; 834 845 this.dataGridViewTextBoxColumn24.DataPropertyName = "NETTO"; 835 dataGridViewCellStyle 17.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight;836 dataGridViewCellStyle 17.Format = "C2";837 this.dataGridViewTextBoxColumn24.DefaultCellStyle = dataGridViewCellStyle 17;846 dataGridViewCellStyle37.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight; 847 dataGridViewCellStyle37.Format = "C2"; 848 this.dataGridViewTextBoxColumn24.DefaultCellStyle = dataGridViewCellStyle37; 838 849 this.dataGridViewTextBoxColumn24.HeaderText = "NETTO"; 839 850 this.dataGridViewTextBoxColumn24.Name = "dataGridViewTextBoxColumn24"; … … 845 856 this.dataGridViewTextBoxColumn25.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; 846 857 this.dataGridViewTextBoxColumn25.DataPropertyName = "VAT"; 847 dataGridViewCellStyle 18.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;848 dataGridViewCellStyle 18.Format = "P";849 dataGridViewCellStyle 18.NullValue = null;850 this.dataGridViewTextBoxColumn25.DefaultCellStyle = dataGridViewCellStyle 18;858 dataGridViewCellStyle38.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; 859 dataGridViewCellStyle38.Format = "P"; 860 dataGridViewCellStyle38.NullValue = null; 861 this.dataGridViewTextBoxColumn25.DefaultCellStyle = dataGridViewCellStyle38; 851 862 this.dataGridViewTextBoxColumn25.HeaderText = "VAT"; 852 863 this.dataGridViewTextBoxColumn25.Name = "dataGridViewTextBoxColumn25"; … … 858 869 this.dataGridViewTextBoxColumn26.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; 859 870 this.dataGridViewTextBoxColumn26.DataPropertyName = "PVAT"; 860 dataGridViewCellStyle 19.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight;861 dataGridViewCellStyle 19.Format = "C2";862 this.dataGridViewTextBoxColumn26.DefaultCellStyle = dataGridViewCellStyle 19;871 dataGridViewCellStyle39.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight; 872 dataGridViewCellStyle39.Format = "C2"; 873 this.dataGridViewTextBoxColumn26.DefaultCellStyle = dataGridViewCellStyle39; 863 874 this.dataGridViewTextBoxColumn26.HeaderText = "PVAT"; 864 875 this.dataGridViewTextBoxColumn26.Name = "dataGridViewTextBoxColumn26"; … … 870 881 this.dataGridViewTextBoxColumn27.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None; 871 882 this.dataGridViewTextBoxColumn27.DataPropertyName = "BRUTTO"; 872 dataGridViewCellStyle 20.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight;873 dataGridViewCellStyle 20.Format = "C2";874 this.dataGridViewTextBoxColumn27.DefaultCellStyle = dataGridViewCellStyle 20;883 dataGridViewCellStyle40.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight; 884 dataGridViewCellStyle40.Format = "C2"; 885 this.dataGridViewTextBoxColumn27.DefaultCellStyle = dataGridViewCellStyle40; 875 886 this.dataGridViewTextBoxColumn27.HeaderText = "BRUTTO"; 876 887 this.dataGridViewTextBoxColumn27.Name = "dataGridViewTextBoxColumn27"; … … 983 994 // 984 995 this.reklamyZestawienieTableAdapter.ClearBeforeFill = true; 985 //986 // toolStripLabel6987 //988 this.toolStripLabel6.Name = "toolStripLabel6";989 this.toolStripLabel6.Size = new System.Drawing.Size(24, 22);990 this.toolStripLabel6.Text = "ms:";991 //992 // txtMiesiac993 //994 this.txtMiesiac.Name = "txtMiesiac";995 this.txtMiesiac.Size = new System.Drawing.Size(30, 25);996 996 // 997 997 // ZestawienieZamowienForm -
trunk/BazaReklam/ZestawienieZamowienForm.cs
r350 r351 203 203 Cursor = Cursors.WaitCursor; 204 204 205 ExcelH andler ex = new ExcelHandler();206 ex. exportToExcel(fakturyDataGridView);205 ExcelHelper ex = new ExcelHelper(); 206 ex.Export(fakturyDataGridView); 207 207 208 208 Cursor = Cursors.Default; -
trunk/BazaReklam/ZestawienieZamowienForm.resx
r350 r351 200 200 iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8 201 201 YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAACZ5JREFUWEellwlU 202 lOUax1 9AwwVScYmkEFxCQQS83YtLat5cTlGWp4yyyDQ0DVEyFB3QGVlkhxEQEXBDDAoIIwoRZRnWYRcY203 UGAYFlklBEREQP73eYG695yr515ozvmf75vvm3l//+d5t+dVYs/5RO5nG7oG2B5lFWasqsImqaiyjsGn204 rHzSJDZFVZnNGVJmjYNK7NrHjiyOmuglPX1eW2N+Hn+EiYVWbCjqKEP8SYbrLgw3XBkSTzHc8mBIFzNk205 nGYQCtnQLU92hQDapIljBj3rD7GHmeVFK4ZrxxmiBQw/2DHE2JMRR4ab7v+GSwMZ8s8xZJERBwvmQm3N206 I034SyawjakE72V139synLFkCLOehHRPfWR66ePmKS3EClSHTUlGM5Dlz5AdwHBVxOpUVNj7BJ/+lwxc207 sWYrQvYy+O9kKPRfDRQ4A7kiQErKEQJ5jig+a4JrJ0a6gHdFpt9IVxgtYI4EX0hSHreJiANs/5mvKN0n208 tIFCgmedALJJHJ5D1ywHuooQeYTGgidDms+I+NjYtpqFEHg1afK4DYRZMVcfC4a+G99Q5CcpYjJR6AYU209 uVM2ThGcnuU6ItfPEHFChmQykerN8JsTg8UGFk7g90jTxm3g8n4mDvuaEdCVQE509QBKxUCZP3Dbe8SE210 1AmNUR/iyrcjg5TPkl9EDOZrhmfDxySNcRsIsmTuWQINippA3ACHlgcCd0NGTBSQsXwXQHYR5b/aoTrF211 FSXXBSi8tgcHd66PIPAnf8nAoXUvLC4T6g8ij+BcxZ4EDgAqyESJL4FD0a9IRllGHKIun4PY8xS8nIUI212 8hXBy9WlYNq0aXvIwEskpXFlYd48NqnXV78T2cdp8NHA4ynnJoq8gMoIPKzLQcTlC7gQFY3EsjvIaOvG213 RYVi4HJW0WO3c+c77GwONpq9/fYXo+NgXLNBufeCSSmSD9CItx8xIaWBVxqIRwQPDQ2GVFGP1oFetPT1214 oqqzE9cb2nrPSO5UeUhqqtwSiu8dFxztXmlqupNMzBzPlFRqPW8SjFhzIO0wILEDMu0xWJOISIpcIleg215 beAxegefoP1xD6ofdCBdoXgYJJFV+SQVVzmlVMqdE4ua9++2kKuqqr5FBtTH3BWZYoN3vYSrhpBiA9yi216 TOT7oirnZwRFRKG27xG6+vvQP9CPh2REKBQOSeqaHwSklVT6JMmqXBLLq13S6muFgYE9hkuXehJcbzzL217 89TmQKN0RG0Fkmg9KL2EXyND8GOeDNXdvZB3P8T93h7UdnYhu/F+71VpRRU34JVcXn0yoUzudkte73mz218 rM1s88YEgr9NenGsWVAWbNVa0SNe3IqoLTQDIhF62h3xNZ3Ib+2A7H4nitt+H44+5nZDV0RxU7svpf9U219 oqza/rcyuVdqdYNzYn2z5S6LYgLvJmmOycBjVz0d+Te6sWX7dAf7vZfQQHRHkJcTou624paiBck1TUiv220 aUZSRQN+KW3AxULFwIX8uu6TCaVyu1/KavwkVU3C1IaWXZ+bFxH4OxLfqv+/T6/bsjfaDum2PxAZoEuo221 h3zbTSgqLsKVc34IzaxARHk7ImX38WN+LaKL6/BDUR2u0n1IRg2EqTV9wtT6zgvShhYvibx97SrT62My222 wCPn8D5 fIwz4G+Oh8xIU2KxBTGoeYuPi4R0Wi+CSh7iYXYvLeQqE5dbiYk4tgjMVCJDUwPWGnL4rBoRZ223 dd 1eV64+0tTUDB1TF/Qf07vW6bwUCP4bBs+YoM/bEPWWc5FyaAtK4iPh6Xgcgcl3EZjdiLMZCgSSAiQK224 eKUSPKkGl6WNCM1tRXBcY7+5vv7glClTAgwNDS3JxKz/uTI+cVhgkLJu4dMnYmM8OW2EPl9jPPJYhi4n225 fTQd0EGD3SqUhnvCVXQcfilV8M5shVjSAL/UOpzLbEB4YQs801oQIm2F9Z6vEBoSzAdpr0fQ+afLtWau226 H10Zn788d1npOjZ99xp63A3xyM0QPa5L0elkgA7hErQJ9NB8+DW0+JqjmEw4Hz2IgPAYBKUr4JPRCp/0227 NlyStiEsJgHbt5rBTyxG++8duFPXhh9tzJBjwqRLJrC1ZGLKczPRsmuepPWoHh44GuDBSX10iPTRzuHH228 FqPJ9jXUH1iImr3zUSt4C3XfuyHa/Sg8j1jDy94WHoJDEO3bifNHrJDjLYKb6ARK7tbj1/Bj6Pv5PcBz229 FWrWq+X/XZ2tfKaJbYyp3N0++/c2wWK0HtOjiBcPg1vs9NBEkTccXAiF1XxUW+qg4gttlFksQKX9Vih8230 baAIdID8tAAy0T5Iv9wMmd8puIsDcPbQZ+iJeoe2cWsg2QLwXoO69WpFq9XYG/9lovwD9ZnCD7SGeKRN231 3y1Coy3p0CLcs1mEemuC7yP4bl1U7pgH2fZXcfsjLRRseRk5m19CxvrZSF01E0mvT0eC4YtIXKmLXG8X232 1JstwaDAGEjcTvXEfiDlC8BnLe5tVC9ZrzbcHVP/7I7Cf2ro55lpos56AeS759N1IWqtFgyD5V/rouor233 HdwZhZds00LhB3OR+44msjbMgWTtLKSumIHrRi/iNwN1/LxwKuKMtVB0/AjaPzHqhr0RkPDpiInUHYDv234 ajSYzS7f8tGnB8nADJIKK143Y2nKullPZdu1h6NR7CPobh1U7tLB3S/nocKC0v7pq/gDzs1mb5yD9Ddn235 IWWVBpJXzsBZRnUhZYAbiHl1MsI1JkNy+HB9tJHSTRxbBsR/TMXMXtrcPsNPP/2Eww4OFQTnu+Vw/Tjx236 eyN1m0STyd3J/9BA5U4dVHH4Dh2Uf64NmfkrKKa0F73/MvLe1YR08xxkvjUHaWso+pUaSFmhgfMTlRG3237 SA3h0ydCqKw05MxYoYmKyiWad943TSbE44g+EGOGe021yM4rwvLly3n59g1pLjfA5+esZZOUzUXaqhHR238 ei/cTzKZjrQ3ZkK6SRMF772MAkp7wftzkU/R89SnUuQJS6chWpuinUFQxob8GVNQKXRNi7Hz1F4AyZa0239 iWp00yxjFhvu7wFJdgFc3dygp6cXRu92kGb/sUmo0A2vYF6nA95Ok8lKHuZqE67Yqk244aqufNt3qkqt240 eKJKq6cya3NjrN6BMdl+xtI/ZCz2dcYuURl8bhQqoiuvhtaQdEl8K55sYGr65lGBqNnY2CRcV1f3kpKS241 Eq8VNo2+/8PDcCZUSXNIS0hvkniVSywmIDmRXEfF78kH+3YUyM8DpiR+MuL/54eT/6wJ+XfyyvaSeOS8242 / 3n6n3mW5Eb4C75y8azwH/KD5/xRAIfwex3SK6NAPpi4eQ591pLLn/Gpx9viaeel2jD8X2iLB4IB/wJ2202 lOUax18YDRdIxSWSQnAJBRHwdi8uqXlzOUVZnjLKItPQNETJUHRAZ2SRZdgERATcEIMCwohCRFmGddhl 203 VWAYFlklBEREQP73eYG695yr515ozvmf75vvm3l//+d5t+dVYs/5ROxnG7oG2B5lATNSEbBJAhXWMfiU 204 lU+axKaoKLM5Q8qscVCJXfvYgcVSE72kp89ra8zP444wH5ElG4o8yhB3kuG6M8MNF4aEUwy33BnSfBjS 205 TzOIRGzoloRdIYAWaeKYQc/6Q8xhZnHRkuHacYYoIcMPtgzRdmTEgeGm27/hsgCGvHMMmWTE3pw5U1vz 206 SBP+kglsY4KgvazuexuGMxYMoVaTkCbRQ4aHHm6e0kSMUGXYlHQ0A5l+DFn+DFfFrE4gYO8TfPpfMnDF 207 iq0I3svgt5OhwG81kO8E5IgBGSlbBOQ6oOisMa6dGOkC3hUZviNdYbiAORB8IUl53CbCD7D9Z76idJ/Q 208 AgoInnkCyCJxeDZdM+3pKkbEERoLEoZUrxHxsbFtNQsm8GrS5HEbCLVkLl7mDH03vqHIT1LEZKLAFSh0 209 o2ycIjg9y3FAjq8BYkUMSWQixZPhN0cG8w0sjMDvkaaN28Dl/cwn9GtGQBcCOdLVHSjxAUr9gNueIyZk 210 jmiM/BBXvh0ZpHyW/CJmMFszPBs+JqmP20CgBXPLFKpT1ATiBji0PAC4GzxiIp+M5TkDZRdR/qstqpNd 211 UHxdiIJre3Bw5/pwAn/ylwwcWvfC4lKR3iByCc5VJCGwP1BBJoq9CRyCfkUSStNjEXn5HHwkp+DhJEKg 212 txgeLs7506ZN20MGXiIpjSsL8+axSb3eep3IOk6DjwYeTzk3UegBVIbjYV02wi9fwIXIKCSU3kF6Wzcu 213 KhQDlzMLH7ueO99ha32w0fTtt78YHQfjmg3KvReMS5B0gEa83YgJGQ28kgA8InhISBBkinq0DvSipa8X 214 VZ2duN7Q1ntGeqfKXVpT5RpfdO+48Gj3ShOTnWRi5nimpFLreeMgxJgBqYcBqS2QYYfBmgREUORSuQJt 215 A4/RO/gE7Y97UP2gA2kKxcNAaVmVV2JRlWNypdwpobB5/25zuYqKyltkQG3MXZHho/+uRLRqCMnWwC3K 216 RJ43qrJ/RmB4JGr7HqGrvw/9A/14SEZEItGQtK75gX9qcaVXYlmVc0J5tXNqfa0oIKDHYOlSCcF1x7M8 217 T20OMExD5FYgkdaDkkv4NSIYP+aWobq7F/Luh7jf24Pazi5kNd7vvSqrqOIGPJLKq0/Gl8pdb8nrJTdL 218 20w3b4wn+NukF8eaBWXhVs0VPT6LWxG5hWZABEJOuyGuphN5rR0ou9+Jorbfh6OPvt3QFV7U1O5N6T+V 219 UFZt91up3COlusEpob7ZYpd5EYF3kzTGZOCxi662/BudmNJ9OoP9nktoILoh0MMRkXdbcUvRgqSaJqTV 220 NCOxogG/lDTgYoFi4EJeXffJ+BK57S+lNb7SqiZRSkPLrs/NCgn8HYlv1f/fp9d12Rtth3TaH4j10SXS 221 RZ7NJhQWFeLKOV+EZFQgvLwdEWX38WNeLaKK6vBDYR2u0n1weg1EKTV9opT6zguyhhYPqbx97SqT62My 222 wCPn8D5vQwz4GeGh0xLkW69BdEouYmLj4Bkag6Dih7iYVYvLuQqE5tTiYnYtgjIU8JfWwOWGnL4rBkSZ 223 dd0eV64+0tDQCBlTF/Qf073W6bQUCPobBs8Yo8/TAPUWc5F8aAuK4yIgcTiOgKS7CMhqxNl0BQJI/lIF 224 PFIInliDy7JGhOS0Iii2sd9MT29wypQp/gYGBhZkYtb/XBmf2C/QT1638OkTHyM8OW2IPm8jPHJfhi5H 225 PTQd0EaD7SqUhEngIj4O3+QqeGa0wkfaAN+UOpzLaEBYQQskqS0IlrXCas9XCAkO4oO01z3w/NPlmjPX 226 j66Mz1+euyx1HJq+ew09bgZ45GqAHpel6HTUR4doCdqEumg+/BpavM1QRCacjh6Ef1g0AtMU8EpvhVda 227 Gy7J2hAaHY/tW03h6+OD9t87cKeuDT9amyLbmMmWTGBrycSU52aiZdc8aetRXTxw0MeDk3roEOuhncOP 228 LUaTzWuoP7AQNXvno1b4Fuq+d0WU21FIjljBw84G7sJDEO/bifNHLJHtKYar+ASK79bj17Bj6Pv5PUCy 229 CjXrVfP+rsZWPtPENsYEd7fP/r1NuBitx3Qp4sXD4BZbXTRR5A0HF0JhOR/VFtqo+EILpeYLUGm3FQpv 230 aygC7CE/LUSZeB9kX25Gme8puPn44+yhz9AT+Q5t41ZAkjnguQZ161ULV6uyN/7LRPkHajNFH2gO8Uib 231 vluERhvSoUW4Z70I9VYE30fw3Tqo3DEPZdtfxe2PNJG/5WVkb34J6etnI2XVTCS+Ph3xBi8iYaUOcjyd 232 UW+6BINCIyBhO9UT+4HkLwCvtbi3Ua14vepwd0z9szsK/qmul2uqgTqrBZDvnk/Xhai1XDAMln+tg6qv 233 tHFnFF68TRMFH8xFzjsayNwwB9K1s5CyYgauG76I3/TV8PPCqYg10kTh8SNo/8SwG3aGQPynIyZSdgDe 234 q9FgOrt8y0efHiQDM0gCVrRuxtLkdbOelm3XGo5GsY+gu7VRuUsbd7+chwpzSvunr+IPODebtXEO0t6c 235 heRV6khaOQNnGdWFlAFuIPrVyQhTnwzp4cP1UYZKN3FsGRD3MRUze2lz+ww//fQTDtvbVxCc75bD9ePE 236 7w3VrBOMJ3cn/UMdlTu1UcXhO7RR/rkWysxeQRGlvfD9l5H7rgZkm+cg4605SF1D0a9UR/IKdZyfqIzY 237 RaoImz4RImWlISfGCowFgks07zxvGk+IwxE9INoU95pqkZVbiOXLl/Py7RvSXG6Az89ZyyYpm4m1VMKj 238 dF+4n2g8HalvzIRskwby33sZ+ZT2/PfnIo+i56lPocjjl05DlBZFO4OgjA35MaagUuiaJmPnqT1/kg1p 239 E9XoJplGLCbMzx3SrHy4uLpCV1c3lN7tIM3+Y5MQ0A2vYF6nA95O48lK7maqE67YqE644aKmfNt7qqDW 240 Z6KgVaLM2lwZq7dnrGw/Y2kfMhbzOmOXqAw+NwoV05VXQ2tIOiS+FU/WNzF586hQ3GxkZBymo6NzSUlJ 241 idcKm0bf/+FhOBMqpDmkJaQ3SbzKJRYTkhxJLqPi9+SDfTsK5OcBExI/GfH/88PJf9aE/Dt5ZXtJPHLe 242 /zz9zzxLciP8BV+5eFb4D/nBc/4ogEP4vTbplVEgH0zcPIc+a8nlz/jU423xtPNSbRj+L18NB4HTphFx 243 243 AAAAAElFTkSuQmCC 244 244 </value> … … 274 274 <value> 275 275 iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8 276 YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAABX RJREFUSEuVlQtQ277 VFUYx10VG 0JbMg0ZSGAmncpycPIxlqESW1CoEYyMj5BU1NDMCgNcl8tjWFCUQZHAlZVhWQQUYuQlaqRi278 giSKxAryEkRhAUkWlzfL/vvOzlIqC9aZ+c3de+49//89337fd3gTxhnbth034vONjsycaeTW2vqkXal8279 kD801JOdnh79By0bIKBnPJmxn4WG5okbG9vAhlYLVFY2geM4rY/P0foNG/yPuLjssKfVLxMTCd7/comI280 kJlIJJe6dOrPDWZWVfVAZ7ZzZ0iDm5v3sVWrPAVkYEJM+k9GwcH5zjdu1BrSHzUXFhYDV9ftWldXryZH281 x6/EJiYmZmRiNK5RQEB6qErV/UKDuLhE7NoVheJiIC3tIYTCVMyfb5dA4jbjmvj6pmb8q04xMTAGBwew282 bp0I/v7JWLjwY5SUDKG6GnB09Ggl8XXEjDF3IRZn3mSag4PD0GgMG2RmnsOWLYcQEVEAkUiClhbg0SNg283 0aJl VSQsIqzGMuDFxOS1Dg8DfX1D6OxU4VSyHCGBgQgODoRUIkFz80Okp+cPzJo1O2Xp0hUNGzd+i4sX284 VVi+ /NAwn/+qjIT3EpYGDc6fP2/Ccb9q+vuH0dLcipNJyShqakWFBih8Apy504ZjUhlS5KndJJBIWepj285 bm4WaWVlkzZtmqmE5g4SjgTfoEFi4oW3OS5S29HRhXiZHB0Uqj6ieWAYpY8HkPegD6fuQ5emFhYW0SRi286 R7xLfEq4ER8Rr4+ZsrGxGYLy8ns4ezYL11o6oSJxDSV/ba8GxR19yL7fC3mVGvK73fDy3HSLhJyI6cQ0287 /ZXVAyu+ZwarRF01 hoTEbbp3T0nxDsF1NVDXo0GlehDXSbxA2YuMOjVOVqiQWK2Fj4+Pmpb8oI/36Go+288 fFgxPSGhNkkur7gpEmWKHRw85+zYIdzX0PAIXFAQcluB35p7cVnZh/ymHpytVyO5sgsxt1WQ1wxj334R289 +x/CiTcNxjs0NDtVrWYRBtrbaWFMRrer6546haIF0VFHIaMwnK7vwenaLqQRMoUKsbc7IbmlQlKNFlu3290 br5Dwgf0BqN3EBWVpVIqO6FUqtDfT2lCQ60mwdP5yMstwFF5BiRVGpwo78JxEj5y8zFiy1RIqBoEl1Wg291 sbW1zbaysQnRG4yK+4SAgMSaoqIaqsI6VFQ0obGxHSpVj85IoxmCJC4W0SlZOHa7B9F/0n3FEKRkmJB9292 BQdCAnHx8u/gfH2f2L9mvEqfls/uwts7zJPjzgxmZJRQoShQWFiF0tJ63L3bDDoDdEaFV64gmBPBT7gf293 /vs5HBSH6VKUUVh8GW2SlcDaGXA2M2zCX7LE+evNm0VX2YLk5GvIzS1HQYGCdlVPZjXw9t5H96W4dKmE294 QvcLamvVyMrOUbMMun/oQ6B+N5CzFthgDncL/pfP74T1b9aU7ObOtQ1wcdl+zc+P00qlhcjJUSA8XIo1295 a76Bk9NG7N0bA3t7Z8TH38LKlYKrxjyeDE4mgMwJqP4OOOcOrOfDaf4cD309/POfsB+sOKwJB2vrtwIE296 AveiPXs4rVD4M7XjA9TQ8uDi4gUvryAEBaXAzMwsid4VmhtNXI/PpgLxn9AptBVtUi/4+gZ10jN22rHC297 e2aw3UwlWC93sLS05pYts79hb++o9fc/gbCwLERGXqBdCJQ8Hu8EvfMFKzCrlyatgGAKWkJXo6ymGes9298 PKpp/iditsHaoMmnjQSWlrPD5817r2zx4tX9Cxa8X2NsbMwOFCHxDjGFfdSsyRPsvP38/nJ3dy8zNTWV299 0tz3zHwsg5H5ESNWpZ8TPoSY+JFgDe0VYqTFsBAv0QvvpusH+mi8yEP3fDLBWu8bBDNjVxbKpwuLGRnr300 v9pi5PnfqiO601y7xZMAAAAASUVORK5CYII=276 YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAABXVJREFUSEuVlQtQ 277 VFUYx10VG1ptyTRkIIGZdCrLwcnHWIZKbEGhRjAyPkJSUUMzKwxwXS6P4aGggyKBKyvDsggoxMhL1EjF 278 BEkUCQRZQBCFBSRZXN4s++87O0upLFhn5jd377n3/P/3fPt93+FNGGds23bcSCAwOjJzppFra+uTdqXy 279 Qf7QUE92enr0H7RsgICe8WTGfhYSkhfa2NgGNrRaoKqqCRzHab29j9Zv2OB3xNl5hx2tfpmYSPD+l0tE 280 hIwvkVzq0qk/N5hZdfUDndnOncENrq5ex1at8hCSAZ+Y9J+MgoLynW7cqDWkP2ouLCwGLi7btS4unk0O 281 Dl+F8vl8UzIxGtfI3z89RKXqfqFBXFwidu2KQnExkJb2ECJRKubPt00gcetxTXx8UjP+VaeYGBiDgwNY 282 t04MP79kLFz4MUpKhlBTAzg4uLeS+Dpixpi7CA3NvMk0BweHodEYNsjMPIctWyIREVEAsViClhbg0SNg 283 0aJl1SQsJizHMuDFxOS1Dg8DfX1D6OxU4VSyHMEBAQgKCoBUIkFz80Okp+cPzJo1O2Xp0hUNGzd+i4sX 284 VVi+PHJYIHhVRsJ7CQuDBufPn+dz3K+a/v5htDS34mRSMoqaWlGhAQqfAGfutOGYVIYUeWo3CSRSlnqb 285 mZketrS0Tps2zURCcwcJB0Jg0CAx8cLbHHdI29HRhXiZHB0Uqj6ieWAYpY8HkPegD6fuQ5em5ubm0SRi 286 S7xLfEq4Eh8Rr4+ZsrGxGcLy8ns4ezYL11o6oSJxDSV/ba8GxR19yL7fC3m1GvK73fD02HSLhByJ6cQ0 287 /ZXVAyu+ZwarRF01BgfHbbp3T0nxDsZ1NVDXo0GVehDXSbxA2YuMOjVOVqiQWKOFt7e3mpb8oI/36Go+ 288 dKhyekJCbZJcXnFTLM4Mtbf3mLNjh2hfQ8MjcIGByG0FfmvuxWVlH/KbenC2Xo3kqi7E3FZBrhjGvv1i 289 9j+EE28ajHdISHaqWs0iDLS308KYjG4Xlz11lZUtiI46ChmF4XR9D07XdiGNkFWqEHu7E5JbKiQptNi6 290 dfMdEj6gNxi9g6ioLJVS2QmlUoX+fkoTGmo1CZ7OR15uAY7KMyCp1uBEeReOk/CRm48RW6ZCQvUguKwC 291 jY2NTbaltXWw3mBU3Cf4+ycqiooUVIV1qKhoQmNjO1SqHp2RRjMESVwsolOycOx2D6L/pPuKIUjJMCH7 292 Cg4EB+Di5d/B+fg8sXvNeJU+LZ/dhZdXmAfHnRnMyCihQqlEYWE1SkvrcfduM+gM0BkVXrmCIE4MX9F+ 293 +O3ncDA0TJeijMLiy2iTrATWzoCTqWETwZIlTl9v3iy+yhYkJ19Dbm45CgoqaVf1ZKaAl9c+ui/FpUsl 294 FLpfUFurRlZ2jppl0P3ID4H63UDOWmCDGdzMBV8+vxPWv1lTsp0718bf2Xn7NV9fTiuVFiInpxLh4VKs 295 WfMNHB03Yu/eGNjZOSE+/hZWrhReNebxZHDkAzJHoOY74JwbsF4Ax/lz3PX18M9/wn6w4rAi7K2s3vIX 296 Ct2K9uzhtCLRz9SOD1BDy4Ozsyc8PQMRGJgCU1PTJHpXZGY0cT0+mwrEf0Kn0Fa0ST3h4xPYSc/YaccK 297 75nBdjOVYL3c3sLCilu2zO6GnZ2D1s/vBMLCsnD48AXahVDJ4/FO0DtfsAKzfGnSCginoCVkNcoUzVjv 298 7l5D8z8Rsw3WBk0+bSS0sJgdPm/ee2WLF6/uX7DgfYWxsTE7UETEO8QU9lGzJk+w9fL1/cvNza3MxMRE 299 SnPfM/OxDEbmR4xYlX5OeBOhxI8Ea2ivECMthoV4iV54N10/0EfjRR6655MJ1nrfIJgZu7JQPl1YzMhY 300 /9XmI8//BqSPutJw6NKIAAAAAElFTkSuQmCC 301 301 </value> 302 302 </data> … … 405 405 <value> 406 406 iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8 407 YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAABX9JREFUSEudlQtQ 408 zXkUx0+lbrfYWiVWJY+1TYNYochOK5WlIo+IliVhZ9vWe+00oyvRjVAKXd2lqBR1eyxa1RB5vyq71mMx 409 lqLsesze0phy73fPz//aUWJm9zfzmf/93//v9z3nd37nnJ8RvW+srOpPTdrvyFjm+0EXi14vXrQ0tzxq 410 qKHGh3lUGZtH2jotL3/5Xo13flz3YFXn6NsvhqpaMWE/MJEJKQTmFAOjkh6AgjVVNGSBF6+3ZIz+m5G4 411 R1u6JTzDABXgvK0Vn6YBHumAZwbgtQcIyAWCD+hg9tWRv2hg6HQWt2pn5D0GFfXT5dExevOoy1oK2V1O 412 Xis0FJBULo84r/VQNcOfxf33AUEHgGn5gGlIYT3ZuU98ZWT8sanknV9Ew1Nm8XsXxrjtzhQKY1pedYcW 413 Hs4hudVa/hjPLGcWkYXNSvKPK3NLqsdMDtUMFg87CMwvbAV5J58jp8Ap9jOPPt9YDVhNznnMa0T4xM7e 414 GFH37WnpFSX/M5uZw4xgejE9pGcnD/KLL/BJe4xFh4FlZUDMSd7R1rsg99Rnm0/roTwPWPrtvMPzvzes 415 bWNCbEmIjWT6MOaG2IqYCuRk6TCQgnKvrioHYlk8/jSQyKI/HG5C4gVgyyWAnJdW8lwF07vtDiQRM6Yz 416 06n9R8O7jNwip7nHVOiSL7L4WWA7C6ey8A4mpvQ5qOfUAp67lLHvSOO1tx3rf1EiI8/k8eSZXrv1rA5p 417 LLqb455RA2ReBb7JrAXZjNrDi+cydpLIhr/705o7qRR1LYFWXlhMEZwNYUXDKFDd3bATyWjoOQfLecfq 418 glJuYXWJFuoqSXjfr8B+Fi/4nbMrvgZk7pjG84MY6ZBlynvVJbf00FxrQfzJRoQVPIHfrloMUqzR2ylu 419 PjWKPF9GjmP6kXd6SGh6A1JZUH1F8jjvOlB0Eyi+AZTcBYZFKvRkYp7KsiKL5ERLLn7kpVDq6xqBstuS 420 N+m8ZRHTJD68WD7EMao/Qa7Tosmm7zDyzyuzDT/+2NWrQjduXTXCVLegKHiInacbkX6pBcYeG2tYOJEZ 421 LO0+8viYBZp6nKsD8n9jr9iztMtACot/+1MTRqbch8Wi4lqSW2/iBZ8xA5gwMpGvJ4ueiWQ1eAf18N1N 422 9qG51HteIZl1VfH3SMbxVVgpvDRCWaFFAW81+xcppirOivhTOtCM7Htk5ZRJRiYipiIrXBiRYSKVP2YG 423 MR6MLzOZCWWCGVcpPGLM+TlZfekl9rLnQnwnh2Yrey/CM3RThY5snbfzLNFvPmEsJK/+RaSyzGDUmp+2 424 TFfmdf3wz7nlpVl8WGoOS3R5M7Zzbidw3GMrgeVcqRScc5XM5KLXfGgQlhx7e3Sc3raLT/yRxoe6vpJD 425 Mqv4ydSMBihPAStYXLSDseqnIN+1RUSmYtvC27fHhKMbyDVWVL4o0rad1HbJmWebOebdI85oSd4tiyap 426 L3x9qBULuZHN0jDc2Ny21IHGbS4hB2/Rm0RsJW99S+3IV5NNPpob/O7JiLpp10EDfpxN/uoScvQUB6kk 427 W5f5puElDaFFwHQ2IC6aAGakqhGW4SeaaNzegzQ2S0W+uYfkMyuey0I473sHr+a1XzIOHYVRVJsoCpEB 428 n7+aNGR+sLhMAnP0COC+75MpXTSe/HTbBbhs08GFLyCbZWv05BKZzWtEaxeZ1K49S9EUWxKXg8iA103O 429 ipx8plBgRrXz2rvwypLER/CNNoTpk9AEc78jzeQYmMVrUhhxwQjvTd4+oI7/ETG25kIcTf0mbiD3mBOm 430 k/LqZVPynxqNTrlOfWZwQVnv4jniQhJ578S8q/u+06YwIi50UVATGFGdsUwcE8WIS2k40+3/iL9pVXgm 431 YtuT6WswKDwWIX2joDp29B/EQrIHSYDA7AAAAABJRU5ErkJggg== 432 </value> 433 </data> 407 YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAABX5JREFUSEudlQtQ 408 zXkUx0+lbrfYWiVWJY+1TYNYochOK90sFXlEtCwJO9u23munGV2JilAKXd2lqBR1eyzuqobI+1XZtR6L 409 sRRl12P2lsaU7nfPz//aUWJm9zfzmf/93//v9z3nd37nnJ8RvW+srOxPjbrvyFim+KCLRa8XL5qbmh/V 410 V1PDwzyqiMkjXa2Ol798r8Y7P657sKpz1O0XQ1UtmLAfmMgEFwJzioFRSQ9AQZpKGrLAi9dbMkb/zUjs 411 oy3dEp5hgApw3taCT9MAj3TAMwPw2gP45wJBB1ph9tWRv2hgyHQWt2pn5D0GlXXT5VFr9OaRl3UUvLuM 412 vFZoyD+pTB5+XuehaoIfi/vtAwIPANPyAdPgwjqyc5/4ysj4Y1PJO7+IhqfM4vcujHHbnSmVxrS88g4t 413 PJxDcqu1/DGeWc4sIgubleQXW+qWVIeZHKoZLB56EJhf2ALyTj5HTgFT7Gcefb6xCrCanPOY14jwiZ29 414 MSLv29PSK3H8z2xmDjOC6cX0kJ6dPMg3vsAn7TEWHQaWlQLRJ3lHW++C3FOfbT6tR9x5wNJ35x2e/71h 415 bRsTYktCbCTThzE3xFbEVCAnS4eBFJh7dVUZEMPi8aeBRBb94XAjEi8AWy4B5Ly0gucqmd5tdyCJmDGd 416 mU7tPxreZeQWMc09urw1+SKLnwW2s3AqC+9gokueg3pOLeC5Sxn7jjRee9ux/hdaGXkmjyfP9JqtZ1uR 417 xqK7Oe4Z1UDmVeCbzBqQzag9vHguYyeJbPi7P625k0qR1xJo5YXFFM7ZEFo0jALU3Q07kYyGnHOwnHes 418 NjDlFlZrdVBXSsL7fgX2s3jB75xd8dUgc8c0nh/ISIcsi7tXpb2lh+ZaM+JPNiC04Al8d9VgkFKpt1Pe 419 fGoUcb6UHMf0I+/04JD0eqSyoPqK5HHedaDoJlB8A9DeBYZFKPVkYp7KsiKL5ERLLn7kpYzV1zYApbcl 420 b9J5yyKmSXx4MXyIY1R/glynRZFN32Hkl1dqG3b8satXeeu4dVUIVd2CsuAhdp5uQPqlZhh7bKxm4URm 421 sLT7iONjFmjqcK4WyP+NvWLP0i4DKSz+7U+NGJlyHxaLimtIbr2JF3zGDGBCyUS+nix6JpLV4B3UQ7Gb 422 7ENyqfe8QjLrquLvEYzjq7BSWEl4XLkOBbzV7F+kmKo4K+JPtYJmZN8jK6dMMjIRMRVZ4cKIDBOp/DEz 423 iPFgFMxkJoQJYlyl8Igx5+dk9aWX2MueC/GdHJqt7L0Iz9BN5a1k67ydZ4l+8wljIXn1LyKVZQaj1vy0 424 Zboyr+uHf84tK8niw1JzWKLKmrCdczuB4x5TASznSqWgnKtkJhe95kODsOTY26Pj9LZdfOKPND7U9RUc 425 klnFT6Zm1CPuFLCCxUU7GKt+ClKsLSIyFdsW3r49JhzdQK4xovJFkbbtpLZLzjzbzDHvHn5GR/JuWTRJ 426 feHrQy1YyI1slobhxua2pRY0brOWHLxFbxKxlbxVlNiRQpNNPpob/O7JiLpp10H9f5xNfmotOXqKg4wj 427 W5f5pmHa+pAiYDobEBeNPzNS1QDLsBONNG7vQRqbpSJF7iH5zPLnsmDO+95Bq3ntl4xDR2EU1SaKQmTA 428 568mDZkfJC6TgBw9/Lnv+2RKF40nP912AS7bWuHCF5DNMhZ3icjmNaK1i0xq156laIotictBZMDrJmdF 429 Tj5TKCCjynntXXhlSeIj+EYbwvRJaIS575EmcgzI4jUpjLhghPcmbx9Qx/+IGFtzIY6mfhM3kHv0CdNJ 430 eXWyKflPjUanXKc+M7igrHfxHHEhibx3Yt7Vfd9pUxgRF7ooqAmMqM4YJpaJZMSlNJzp9n/E37QqPBOx 431 7cn0NRgUHouQvlFQHTv6D7CpsgP5NZKNAAAAAElFTkSuQmCC 432 </value> 433 </data> 434 <metadata name="rEKLAMADataSet.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"> 435 <value>17, 54</value> 436 </metadata> 434 437 <metadata name="wyszukajToolStrip.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"> 435 438 <value>310, 54</value> … … 506 509 <metadata name="toolStrip1.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"> 507 510 <value>233, 91</value> 511 </metadata> 512 <metadata name="RABAT_WARTOSC.UserAddedColumn" type="System.Boolean, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> 513 <value>True</value> 514 </metadata> 515 <metadata name="wyroznienie.UserAddedColumn" type="System.Boolean, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> 516 <value>True</value> 517 </metadata> 518 <metadata name="reklamyZestawienieBindingSource.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"> 519 <value>451, 54</value> 508 520 </metadata> 509 521 <data name="zamToolStripButton.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">
