Changeset 796 – BazaReklam – Trac

branches/Emisje

Property svn:mergeinfo

old	new
1	1	/branches/ReklamaReorganizacja:568-731
	2	/trunk:774-795

branches/Emisje/BazaReklam.Updater

Włąściwość: svn:mergeinfo set to /trunk/BazaReklam.Updater:774-795

branches/Emisje/BazaReklam/Baza Reklam.csproj

r784	r796
33	33	<WebPage>index.htm</WebPage>
34	34	<OpenBrowserOnPublish>false</OpenBrowserOnPublish>
35		<ApplicationVersion>1.1.23.0</ApplicationVersion>
	35	<ApplicationVersion>1.1.24.0</ApplicationVersion>
36	36	<BootstrapperEnabled>false</BootstrapperEnabled>
37	37	</PropertyGroup>

branches/Emisje/BazaReklam/Classes/Interfaces

Włąściwość: svn:mergeinfo set to /trunk/BazaReklam/Classes/Interfaces:774-795

branches/Emisje/BazaReklam/Classes/Model

Włąściwość: svn:mergeinfo set to /trunk/BazaReklam/Classes/Model:774-795

branches/Emisje/BazaReklam/Classes/Repositories

Włąściwość: svn:mergeinfo set to /trunk/BazaReklam/Classes/Repositories:774-795

branches/Emisje/BazaReklam/Docs/versioninfo.html

r765	r796
6	6	<body>
7	7	<h1>Baza reklam - Informacje o wersji</h1>
	8	<div>
	9	<a id="1.1.24" />
	10	<h2>Wersja 1.1.24 (2009-07-30)</h2>
	11	<p>Opis zmian wprowadzonych do wersji 1.1.24</p>
	12	<ul>
	13	<li>Zgłoszenie #196: poprawiono Zestawienie zamówień - kolumna "Do zafakturowania" posiada wartość tylko gdy został wprowadzony rok i miesiąc i przedstawia ona wartość jaka zostanie zafakturowana. Gdy zamówienie jest w walucie obcej, wartość w tej kolumnie jest przedstawiona w PLN wg kursu wymiany waluty z dnia zatwierdzenia reklamy do druku.</li>
	14	</ul>
	15	</div>
8	16	<div>
9	17	<a id="1.1.23" />

branches/Emisje/BazaReklam/FacturesFormNew.Designer.cs

Włąściwość: svn:mergeinfo set to /trunk/BazaReklam/FacturesFormNew.Designer.cs:774-795

branches/Emisje/BazaReklam/FacturesFormNew.cs

Włąściwość: svn:mergeinfo set to /trunk/BazaReklam/FacturesFormNew.cs:774-795

branches/Emisje/BazaReklam/FacturesFormNew.resx

Włąściwość: svn:mergeinfo set to /trunk/BazaReklam/FacturesFormNew.resx:774-795

branches/Emisje/BazaReklam/MDIBazaReklam.cs

r777	r796
273	273
274	274	if (!_forms.ContainsKey("ZestawienieZamowienForm"))
275		_forms.Add("ZestawienieZamowienForm", ZestawienieZamowienForm.getZestawienieZamowienForm(this));
276
277		ZestawienieZamowienForm.getZestawienieZamowienForm(this).WindowState = FormWindowState.Maximized;
278		ZestawienieZamowienForm.getZestawienieZamowienForm(this).Show();
	275	_forms.Add("ZestawienieZamowienForm", ZestawienieZamowienForm.GetZestawienieZamowienForm(this));
	276
	277	ZestawienieZamowienForm.GetZestawienieZamowienForm(this).WindowState = FormWindowState.Maximized;
	278	ZestawienieZamowienForm.GetZestawienieZamowienForm(this).Show();
279	279
280	280	Cursor = Cursors.Default;

branches/Emisje/BazaReklam/Properties/AssemblyInfo.cs

r765	r796
30	30	//
31	31	[assembly: AssemblyVersion("1.0.0.0")]
32		[assembly: AssemblyFileVersion("1.1.23")]
	32	[assembly: AssemblyFileVersion("1.1.24")]

branches/Emisje/BazaReklam/REKLAMADataSet.Designer.cs

r782	r796
16454	16454	private global::System.Data.DataColumn columnkodKlienta;
16455	16455
	16456	private global::System.Data.DataColumn columnSumaNaNastepnejFakturze;
	16457
16456	16458	[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
16457	16459	public VIEW_ZESTAWIENIE_ZAMOWIEN_NOWEDataTable() {
…	…
16600	16602	get {
16601	16603	return this.columnkodKlienta;
	16604	}
	16605	}
	16606
	16607	[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
	16608	public global::System.Data.DataColumn SumaNaNastepnejFakturzeColumn {
	16609	get {
	16610	return this.columnSumaNaNastepnejFakturze;
16602	16611	}
16603	16612	}
…	…
16649	16658	double nettoZafakturowane,
16650	16659	string Brutto_Euro_Miano,
16651		string kodKlienta) {
	16660	string kodKlienta,
	16661	decimal SumaNaNastepnejFakturze) {
16652	16662	VIEW_ZESTAWIENIE_ZAMOWIEN_NOWERow rowVIEW_ZESTAWIENIE_ZAMOWIEN_NOWERow = ((VIEW_ZESTAWIENIE_ZAMOWIEN_NOWERow)(this.NewRow()));
16653	16663	object[] columnValuesArray = new object[] {
…	…
16668	16678	nettoZafakturowane,
16669	16679	Brutto_Euro_Miano,
16670		kodKlienta};
	16680	kodKlienta,
	16681	SumaNaNastepnejFakturze};
16671	16682	rowVIEW_ZESTAWIENIE_ZAMOWIEN_NOWERow.ItemArray = columnValuesArray;
16672	16683	this.Rows.Add(rowVIEW_ZESTAWIENIE_ZAMOWIEN_NOWERow);
…	…
16716	16727	this.columnBrutto_Euro_Miano = base.Columns["Brutto_Euro_Miano"];
16717	16728	this.columnkodKlienta = base.Columns["kodKlienta"];
	16729	this.columnSumaNaNastepnejFakturze = base.Columns["SumaNaNastepnejFakturze"];
16718	16730	}
16719	16731
…	…
16754	16766	this.columnkodKlienta = new global::System.Data.DataColumn("kodKlienta", typeof(string), null, global::System.Data.MappingType.Element);
16755	16767	base.Columns.Add(this.columnkodKlienta);
	16768	this.columnSumaNaNastepnejFakturze = new global::System.Data.DataColumn("SumaNaNastepnejFakturze", typeof(decimal), null, global::System.Data.MappingType.Element);
	16769	base.Columns.Add(this.columnSumaNaNastepnejFakturze);
16756	16770	this.Constraints.Add(new global::System.Data.UniqueConstraint("Constraint1", new global::System.Data.DataColumn[] {
16757	16771	this.columnidZamowienia}, true));
…	…
32676	32690
32677	32691	[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
	32692	public decimal SumaNaNastepnejFakturze {
	32693	get {
	32694	try {
	32695	return ((decimal)(this[this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.SumaNaNastepnejFakturzeColumn]));
	32696	}
	32697	catch (global::System.InvalidCastException e) {
	32698	throw new global::System.Data.StrongTypingException("The value for column \'SumaNaNastepnejFakturze\' in table \'VIEW_ZESTAWIENIE_ZAMOWIE" +
	32699	"N_NOWE\' is DBNull.", e);
	32700	}
	32701	}
	32702	set {
	32703	this[this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.SumaNaNastepnejFakturzeColumn] = value;
	32704	}
	32705	}
	32706
	32707	[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
32678	32708	public bool IsDoZafakturowaniaNull() {
32679	32709	return this.IsNull(this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.DoZafakturowaniaColumn);
…	…
32803	32833	public void SetkodKlientaNull() {
32804	32834	this[this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.kodKlientaColumn] = global::System.Convert.DBNull;
	32835	}
	32836
	32837	[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
	32838	public bool IsSumaNaNastepnejFakturzeNull() {
	32839	return this.IsNull(this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.SumaNaNastepnejFakturzeColumn);
	32840	}
	32841
	32842	[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
	32843	public void SetSumaNaNastepnejFakturzeNull() {
	32844	this[this.tableVIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.SumaNaNastepnejFakturzeColumn] = global::System.Convert.DBNull;
32805	32845	}
32806	32846	}

branches/Emisje/BazaReklam/REKLAMADataSet.xsd

r782	r796
6455	6455	</xs:simpleType>
6456	6456	</xs:element>
	6457	<xs:element name="SumaNaNastepnejFakturze" msprop:Generator_UserColumnName="SumaNaNastepnejFakturze" msprop:Generator_ColumnPropNameInRow="SumaNaNastepnejFakturze" msprop:Generator_ColumnVarNameInTable="columnSumaNaNastepnejFakturze" msprop:Generator_ColumnPropNameInTable="SumaNaNastepnejFakturzeColumn" type="xs:decimal" minOccurs="0" />
6457	6458	</xs:sequence>
6458	6459	</xs:complexType>

branches/Emisje/BazaReklam/REKLAMADataSet.xss

r777	r796
5	5	the code is regenerated.
6	6	</autogenerated>-->
7		<DiagramLayout xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" ex:showrelationlabel="False" ViewPortX="-~~417" ViewPortY="-47~~" xmlns:ex="urn:schemas-microsoft-com:xml-msdatasource-layout-extended" xmlns="urn:schemas-microsoft-com:xml-msdatasource-layout">
	7	<DiagramLayout xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" ex:showrelationlabel="False" ViewPortX="-1339" ViewPortY="1639" xmlns:ex="urn:schemas-microsoft-com:xml-msdatasource-layout-extended" xmlns="urn:schemas-microsoft-com:xml-msdatasource-layout">
8	8	<Shapes>
9	9	<Shape ID="DesignTable:REKLAMA" ZOrder="4" X="-162" Y="35" Height="343" Width="300" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="24" SplitterPosition="228" />
…	…
36	36	<Shape ID="DesignTable:zamowienia" ZOrder="18" X="-675" Y="159" Height="309" Width="300" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="228" />
37	37	<Shape ID="DesignTable:DatyWydan" ZOrder="5" X="701" Y="340" Height="241" Width="221" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="126" />
38		<Shape ID="DesignTable:VIEW_ZESTAWIENIE_ZAMOWIEN_NOWE" ZOrder="17" X="-1298" Y="2210" Height="~~173" Width="245" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="126~~" />
	38	<Shape ID="DesignTable:VIEW_ZESTAWIENIE_ZAMOWIEN_NOWE" ZOrder="17" X="-1298" Y="2210" Height="275" Width="300" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="228" />
39	39	<Shape ID="DesignTable:Wplaty" ZOrder="14" X="-1041" Y="-202" Height="258" Width="268" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="177" />
40	40	<Shape ID="DesignTable:PROWIZJE" ZOrder="13" X="-1138" Y="165" Height="275" Width="203" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="211" SplitterPosition="228" />

branches/Emisje/BazaReklam/ZestawienieZamowienForm.Designer.cs

r597	r796
33	33	System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle1 = new System.Windows.Forms.DataGridViewCellStyle();
34	34	System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle2 = new System.Windows.Forms.DataGridViewCellStyle();
	35	System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle15 = new System.Windows.Forms.DataGridViewCellStyle();
	36	System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle16 = new System.Windows.Forms.DataGridViewCellStyle();
	37	System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle17 = new System.Windows.Forms.DataGridViewCellStyle();
	38	System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle18 = new System.Windows.Forms.DataGridViewCellStyle();
	39	System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle19 = new System.Windows.Forms.DataGridViewCellStyle();
	40	System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle20 = new System.Windows.Forms.DataGridViewCellStyle();
	41	System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle21 = new System.Windows.Forms.DataGridViewCellStyle();
35	42	System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle3 = new System.Windows.Forms.DataGridViewCellStyle();
36	43	System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle4 = new System.Windows.Forms.DataGridViewCellStyle();
…	…
45	52	System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle13 = new System.Windows.Forms.DataGridViewCellStyle();
46	53	System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle14 = new System.Windows.Forms.DataGridViewCellStyle();
47		~~System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle15 = new System.Windows.Forms.DataGridViewCellStyle();~~
48		~~System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle16 = new System.Windows.Forms.DataGridViewCellStyle();~~
49		~~System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle17 = new System.Windows.Forms.DataGridViewCellStyle();~~
50		~~System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle18 = new System.Windows.Forms.DataGridViewCellStyle();~~
51		~~System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle19 = new System.Windows.Forms.DataGridViewCellStyle();~~
52		~~System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle20 = new System.Windows.Forms.DataGridViewCellStyle();~~
53	54	this.bindingNavigator1 = new System.Windows.Forms.BindingNavigator(this.components);
54	55	this.VIEW_ZESTAWIENIE_ZAMOWIEN_NOWEBindingSource = new System.Windows.Forms.BindingSource(this.components);
…	…
92	93	this.splitContainer2 = new System.Windows.Forms.SplitContainer();
93	94	this.fakturyDataGridView = new System.Windows.Forms.DataGridView();
94		~~this.agencja = new System.Windows.Forms.DataGridViewTextBoxColumn();~~
95		~~this.agent = new System.Windows.Forms.DataGridViewTextBoxColumn();~~
96		~~this.rokZamowienia = new System.Windows.Forms.DataGridViewTextBoxColumn();~~
97		~~this.nrZamowieniaExt = new System.Windows.Forms.DataGridViewTextBoxColumn();~~
98		~~this.iloscReklam = new System.Windows.Forms.DataGridViewTextBoxColumn();~~
99		~~this.data_od = new System.Windows.Forms.DataGridViewTextBoxColumn();~~
100		~~this.data_od_bez_FK = new System.Windows.Forms.DataGridViewTextBoxColumn();~~
101		~~this.wartoscNetto = new System.Windows.Forms.DataGridViewTextBoxColumn();~~
102		~~this.kwotaWalutaBrutto = new System.Windows.Forms.DataGridViewTextBoxColumn();~~
103		~~this.bruttoEuroMianoDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();~~
104		~~this.nettoZafakturowane = new System.Windows.Forms.DataGridViewTextBoxColumn();~~
105		~~this.DoZafakturowania = new System.Windows.Forms.DataGridViewTextBoxColumn();~~
106	95	this.reklamyZestawienieDataGridView = new System.Windows.Forms.DataGridView();
107	96	this.dataGridViewTextBoxColumn3 = new System.Windows.Forms.DataGridViewTextBoxColumn();
…	…
133	122	this.VIEW_ZESTAWIENIE_ZAMOWIEN_NOWETableAdapter = new Baza_Reklam.REKLAMADataSetTableAdapters.VIEW_ZESTAWIENIE_ZAMOWIEN_NOWETableAdapter();
134	123	this.reklamyZestawienieTableAdapter = new Baza_Reklam.REKLAMADataSetTableAdapters.ReklamyZestawienieTableAdapter();
	124	this.agencja = new System.Windows.Forms.DataGridViewTextBoxColumn();
	125	this.agent = new System.Windows.Forms.DataGridViewTextBoxColumn();
	126	this.rokZamowienia = new System.Windows.Forms.DataGridViewTextBoxColumn();
	127	this.nrZamowieniaExt = new System.Windows.Forms.DataGridViewTextBoxColumn();
	128	this.iloscReklam = new System.Windows.Forms.DataGridViewTextBoxColumn();
	129	this.data_od = new System.Windows.Forms.DataGridViewTextBoxColumn();
	130	this.data_od_bez_FK = new System.Windows.Forms.DataGridViewTextBoxColumn();
	131	this.wartoscNetto = new System.Windows.Forms.DataGridViewTextBoxColumn();
	132	this.kwotaWalutaBrutto = new System.Windows.Forms.DataGridViewTextBoxColumn();
	133	this.bruttoEuroMianoDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
	134	this.nettoZafakturowane = new System.Windows.Forms.DataGridViewTextBoxColumn();
	135	this.DoZafakturowania = new System.Windows.Forms.DataGridViewTextBoxColumn();
	136	this.SumaNaNastepnejFakturze = new System.Windows.Forms.DataGridViewTextBoxColumn();
135	137	((System.ComponentModel.ISupportInitialize)(this.bindingNavigator1)).BeginInit();
136	138	this.bindingNavigator1.SuspendLayout();
…	…
489	491	//
490	492	this.splitContainer1.Panel1.Controls.Add(this.treeView1);
	493	this.splitContainer1.Panel1Collapsed = true;
491	494	//
492	495	// splitContainer1.Panel2
…	…
502	505	this.treeView1.Location = new System.Drawing.Point(0, 0);
503	506	this.treeView1.Name = "treeView1";
504		this.treeView1.Size = new System.Drawing.Size(163, ~~569~~);
	507	this.treeView1.Size = new System.Drawing.Size(163, 100);
505	508	this.treeView1.TabIndex = 0;
506	509	this.treeView1.AfterSelect += new System.Windows.Forms.TreeViewEventHandler(this.treeView1_AfterSelect);
…	…
523	526	this.splitContainer2.Panel2.Controls.Add(this.reklamyZestawienieDataGridView);
524	527	this.splitContainer2.Panel2.Controls.Add(this.toolStrip1);
525		this.splitContainer2.Size = new System.Drawing.Size(~~812~~, 569);
	528	this.splitContainer2.Size = new System.Drawing.Size(979, 569);
526	529	this.splitContainer2.SplitterDistance = 355;
527	530	this.splitContainer2.TabIndex = 0;
…	…
558	561	this.bruttoEuroMianoDataGridViewTextBoxColumn,
559	562	this.nettoZafakturowane,
560		this.DoZafakturowania});
	563	this.DoZafakturowania,
	564	this.SumaNaNastepnejFakturze});
561	565	this.fakturyDataGridView.DataSource = this.VIEW_ZESTAWIENIE_ZAMOWIEN_NOWEBindingSource;
562	566	this.fakturyDataGridView.Dock = System.Windows.Forms.DockStyle.Fill;
…	…
569	573	this.fakturyDataGridView.RowHeadersWidthSizeMode = System.Windows.Forms.DataGridViewRowHeadersWidthSizeMode.DisableResizing;
570	574	this.fakturyDataGridView.SelectionMode = System.Windows.Forms.DataGridViewSelectionMode.FullRowSelect;
571		this.fakturyDataGridView.Size = new System.Drawing.Size(~~812~~, 355);
	575	this.fakturyDataGridView.Size = new System.Drawing.Size(979, 355);
572	576	this.fakturyDataGridView.TabIndex = 1;
573	577	this.fakturyDataGridView.DataBindingComplete += new System.Windows.Forms.DataGridViewBindingCompleteEventHandler(this.fakturyDataGridView_DataBindingComplete);
574		//
575		~~// agencja~~
576		//
577		~~this.agencja.DataPropertyName = "agencja";~~
578		~~dataGridViewCellStyle3.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;~~
579		~~this.agencja.DefaultCellStyle = dataGridViewCellStyle3;~~
580		~~this.agencja.HeaderText = "Agencja";~~
581		~~this.agencja.Name = "agencja";~~
582		~~this.agencja.ReadOnly = true;~~
583		~~this.agencja.Width = 71;~~
584		//
585		~~// agent~~
586		//
587		~~this.agent.DataPropertyName = "agent";~~
588		~~dataGridViewCellStyle4.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;~~
589		~~this.agent.DefaultCellStyle = dataGridViewCellStyle4;~~
590		~~this.agent.HeaderText = "Agent";~~
591		~~this.agent.Name = "agent";~~
592		~~this.agent.ReadOnly = true;~~
593		~~this.agent.Width = 60;~~
594		//
595		~~// rokZamowienia~~
596		//
597		~~this.rokZamowienia.DataPropertyName = "rokZamowienia";~~
598		~~dataGridViewCellStyle5.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;~~
599		~~this.rokZamowienia.DefaultCellStyle = dataGridViewCellStyle5;~~
600		~~this.rokZamowienia.HeaderText = "Rok";~~
601		~~this.rokZamowienia.Name = "rokZamowienia";~~
602		~~this.rokZamowienia.ReadOnly = true;~~
603		~~this.rokZamowienia.Width = 52;~~
604		//
605		~~// nrZamowieniaExt~~
606		//
607		~~this.nrZamowieniaExt.DataPropertyName = "nrZamowieniaExt";~~
608		~~this.nrZamowieniaExt.HeaderText = "Nr zamówienia";~~
609		~~this.nrZamowieniaExt.Name = "nrZamowieniaExt";~~
610		~~this.nrZamowieniaExt.ReadOnly = true;~~
611		~~this.nrZamowieniaExt.Width = 93;~~
612		//
613		~~// iloscReklam~~
614		//
615		~~this.iloscReklam.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None;~~
616		~~this.iloscReklam.DataPropertyName = "iloscReklam";~~
617		~~dataGridViewCellStyle6.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;~~
618		~~this.iloscReklam.DefaultCellStyle = dataGridViewCellStyle6;~~
619		~~this.iloscReklam.HeaderText = "# rek";~~
620		~~this.iloscReklam.Name = "iloscReklam";~~
621		~~this.iloscReklam.ReadOnly = true;~~
622		~~this.iloscReklam.Width = 40;~~
623		//
624		~~// data_od~~
625		//
626		~~this.data_od.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None;~~
627		~~this.data_od.DataPropertyName = "data_od";~~
628		~~dataGridViewCellStyle7.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;~~
629		~~dataGridViewCellStyle7.Format = "d";~~
630		~~this.data_od.DefaultCellStyle = dataGridViewCellStyle7;~~
631		~~this.data_od.HeaderText = "Data 1 em";~~
632		~~this.data_od.Name = "data_od";~~
633		~~this.data_od.ReadOnly = true;~~
634		~~this.data_od.Width = 80;~~
635		//
636		~~// data_od_bez_FK~~
637		//
638		~~this.data_od_bez_FK.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None;~~
639		~~this.data_od_bez_FK.DataPropertyName = "data_od_bez_FK";~~
640		~~dataGridViewCellStyle8.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;~~
641		~~this.data_od_bez_FK.DefaultCellStyle = dataGridViewCellStyle8;~~
642		~~this.data_od_bez_FK.HeaderText = "Data 1 em bez FV";~~
643		~~this.data_od_bez_FK.Name = "data_od_bez_FK";~~
644		~~this.data_od_bez_FK.ReadOnly = true;~~
645		~~this.data_od_bez_FK.Width = 80;~~
646		//
647		~~// wartoscNetto~~
648		//
649		~~this.wartoscNetto.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None;~~
650		~~this.wartoscNetto.DataPropertyName = "wartoscNetto";~~
651		~~dataGridViewCellStyle9.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight;~~
652		~~dataGridViewCellStyle9.Format = "C2";~~
653		~~this.wartoscNetto.DefaultCellStyle = dataGridViewCellStyle9;~~
654		~~this.wartoscNetto.HeaderText = "Netto";~~
655		~~this.wartoscNetto.Name = "wartoscNetto";~~
656		~~this.wartoscNetto.ReadOnly = true;~~
657		~~this.wartoscNetto.Width = 110;~~
658		//
659		~~// kwotaWalutaBrutto~~
660		//
661		~~this.kwotaWalutaBrutto.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None;~~
662		~~this.kwotaWalutaBrutto.DataPropertyName = "kwotaWalutaBrutto";~~
663		~~dataGridViewCellStyle10.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight;~~
664		~~dataGridViewCellStyle10.Format = "N2";~~
665		~~dataGridViewCellStyle10.NullValue = null;~~
666		~~this.kwotaWalutaBrutto.DefaultCellStyle = dataGridViewCellStyle10;~~
667		~~this.kwotaWalutaBrutto.HeaderText = "Waluta - brutto zamówienia";~~
668		~~this.kwotaWalutaBrutto.Name = "kwotaWalutaBrutto";~~
669		~~this.kwotaWalutaBrutto.ReadOnly = true;~~
670		~~this.kwotaWalutaBrutto.Width = 110;~~
671		//
672		~~// bruttoEuroMianoDataGridViewTextBoxColumn~~
673		//
674		~~this.bruttoEuroMianoDataGridViewTextBoxColumn.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None;~~
675		~~this.bruttoEuroMianoDataGridViewTextBoxColumn.DataPropertyName = "Brutto_Euro_Miano";~~
676		~~dataGridViewCellStyle11.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;~~
677		~~this.bruttoEuroMianoDataGridViewTextBoxColumn.DefaultCellStyle = dataGridViewCellStyle11;~~
678		~~this.bruttoEuroMianoDataGridViewTextBoxColumn.HeaderText = "W";~~
679		~~this.bruttoEuroMianoDataGridViewTextBoxColumn.Name = "bruttoEuroMianoDataGridViewTextBoxColumn";~~
680		~~this.bruttoEuroMianoDataGridViewTextBoxColumn.ReadOnly = true;~~
681		~~this.bruttoEuroMianoDataGridViewTextBoxColumn.Width = 35;~~
682		//
683		~~// nettoZafakturowane~~
684		//
685		~~this.nettoZafakturowane.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None;~~
686		~~this.nettoZafakturowane.DataPropertyName = "nettoZafakturowane";~~
687		~~dataGridViewCellStyle12.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight;~~
688		~~dataGridViewCellStyle12.Format = "C2";~~
689		~~this.nettoZafakturowane.DefaultCellStyle = dataGridViewCellStyle12;~~
690		~~this.nettoZafakturowane.HeaderText = "Wartoæ netto FV";~~
691		~~this.nettoZafakturowane.Name = "nettoZafakturowane";~~
692		~~this.nettoZafakturowane.ReadOnly = true;~~
693		~~this.nettoZafakturowane.Width = 110;~~
694		//
695		~~// DoZafakturowania~~
696		//
697		~~this.DoZafakturowania.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None;~~
698		~~this.DoZafakturowania.DataPropertyName = "DoZafakturowania";~~
699		~~dataGridViewCellStyle13.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight;~~
700		~~dataGridViewCellStyle13.Format = "N2";~~
701		~~dataGridViewCellStyle13.NullValue = null;~~
702		~~this.DoZafakturowania.DefaultCellStyle = dataGridViewCellStyle13;~~
703		~~this.DoZafakturowania.HeaderText = "Wartoæ niezafakturowana";~~
704		~~this.DoZafakturowania.Name = "DoZafakturowania";~~
705		~~this.DoZafakturowania.ReadOnly = true;~~
706		~~this.DoZafakturowania.Width = 110;~~
707	578	//
708	579	// reklamyZestawienieDataGridView
…	…
739	610	this.reklamyZestawienieDataGridView.RowHeadersWidthSizeMode = System.Windows.Forms.DataGridViewRowHeadersWidthSizeMode.DisableResizing;
740	611	this.reklamyZestawienieDataGridView.SelectionMode = System.Windows.Forms.DataGridViewSelectionMode.FullRowSelect;
741		this.reklamyZestawienieDataGridView.Size = new System.Drawing.Size(~~812~~, 179);
	612	this.reklamyZestawienieDataGridView.Size = new System.Drawing.Size(979, 179);
742	613	this.reklamyZestawienieDataGridView.TabIndex = 1;
743	614	//
…	…
782	653	this.dataGridViewTextBoxColumn8.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None;
783	654	this.dataGridViewTextBoxColumn8.DataPropertyName = "1emisja";
784		dataGridViewCellStyle14.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
785		dataGridViewCellStyle14.Format = "d";
786		this.dataGridViewTextBoxColumn8.DefaultCellStyle = dataGridViewCellStyle14;
	655	dataGridViewCellStyle15.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
	656	dataGridViewCellStyle15.Format = "d";
	657	this.dataGridViewTextBoxColumn8.DefaultCellStyle = dataGridViewCellStyle15;
787	658	this.dataGridViewTextBoxColumn8.HeaderText = "1 emisja";
788	659	this.dataGridViewTextBoxColumn8.Name = "dataGridViewTextBoxColumn8";
…	…
830	701	this.dataGridViewTextBoxColumn23.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None;
831	702	this.dataGridViewTextBoxColumn23.DataPropertyName = "CENA JEDN";
832		dataGridViewCellStyle15.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight;
833		dataGridViewCellStyle15.Format = "C2";
834		this.dataGridViewTextBoxColumn23.DefaultCellStyle = dataGridViewCellStyle15;
	703	dataGridViewCellStyle16.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight;
	704	dataGridViewCellStyle16.Format = "C2";
	705	this.dataGridViewTextBoxColumn23.DefaultCellStyle = dataGridViewCellStyle16;
835	706	this.dataGridViewTextBoxColumn23.HeaderText = "Cena jedn.";
836	707	this.dataGridViewTextBoxColumn23.Name = "dataGridViewTextBoxColumn23";
…	…
842	713	this.RABAT_WARTOSC.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None;
843	714	this.RABAT_WARTOSC.DataPropertyName = "RABAT WARTOÆ";
844		dataGridViewCellStyle16.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight;
845		dataGridViewCellStyle16.Format = "C2";
846		this.RABAT_WARTOSC.DefaultCellStyle = dataGridViewCellStyle16;
	715	dataGridViewCellStyle17.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight;
	716	dataGridViewCellStyle17.Format = "C2";
	717	this.RABAT_WARTOSC.DefaultCellStyle = dataGridViewCellStyle17;
847	718	this.RABAT_WARTOSC.HeaderText = "Rabat";
848	719	this.RABAT_WARTOSC.Name = "RABAT_WARTOSC";
…	…
854	725	this.dataGridViewTextBoxColumn24.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None;
855	726	this.dataGridViewTextBoxColumn24.DataPropertyName = "NETTO";
856		dataGridViewCellStyle17.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight;
857		dataGridViewCellStyle17.Format = "C2";
858		this.dataGridViewTextBoxColumn24.DefaultCellStyle = dataGridViewCellStyle17;
	727	dataGridViewCellStyle18.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight;
	728	dataGridViewCellStyle18.Format = "C2";
	729	this.dataGridViewTextBoxColumn24.DefaultCellStyle = dataGridViewCellStyle18;
859	730	this.dataGridViewTextBoxColumn24.HeaderText = "NETTO";
860	731	this.dataGridViewTextBoxColumn24.Name = "dataGridViewTextBoxColumn24";
…	…
866	737	this.dataGridViewTextBoxColumn25.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None;
867	738	this.dataGridViewTextBoxColumn25.DataPropertyName = "VAT";
868		dataGridViewCellStyle18.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
869		dataGridViewCellStyle18.Format = "P";
870		dataGridViewCellStyle18.NullValue = null;
871		this.dataGridViewTextBoxColumn25.DefaultCellStyle = dataGridViewCellStyle18;
	739	dataGridViewCellStyle19.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
	740	dataGridViewCellStyle19.Format = "P";
	741	dataGridViewCellStyle19.NullValue = null;
	742	this.dataGridViewTextBoxColumn25.DefaultCellStyle = dataGridViewCellStyle19;
872	743	this.dataGridViewTextBoxColumn25.HeaderText = "VAT";
873	744	this.dataGridViewTextBoxColumn25.Name = "dataGridViewTextBoxColumn25";
…	…
879	750	this.dataGridViewTextBoxColumn26.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None;
880	751	this.dataGridViewTextBoxColumn26.DataPropertyName = "PVAT";
881		dataGridViewCellStyle19.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight;
882		dataGridViewCellStyle19.Format = "C2";
883		this.dataGridViewTextBoxColumn26.DefaultCellStyle = dataGridViewCellStyle19;
	752	dataGridViewCellStyle20.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight;
	753	dataGridViewCellStyle20.Format = "C2";
	754	this.dataGridViewTextBoxColumn26.DefaultCellStyle = dataGridViewCellStyle20;
884	755	this.dataGridViewTextBoxColumn26.HeaderText = "PVAT";
885	756	this.dataGridViewTextBoxColumn26.Name = "dataGridViewTextBoxColumn26";
…	…
891	762	this.dataGridViewTextBoxColumn27.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None;
892	763	this.dataGridViewTextBoxColumn27.DataPropertyName = "BRUTTO";
893		dataGridViewCellStyle20.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight;
894		dataGridViewCellStyle20.Format = "C2";
895		this.dataGridViewTextBoxColumn27.DefaultCellStyle = dataGridViewCellStyle20;
	764	dataGridViewCellStyle21.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight;
	765	dataGridViewCellStyle21.Format = "C2";
	766	this.dataGridViewTextBoxColumn27.DefaultCellStyle = dataGridViewCellStyle21;
896	767	this.dataGridViewTextBoxColumn27.HeaderText = "BRUTTO";
897	768	this.dataGridViewTextBoxColumn27.Name = "dataGridViewTextBoxColumn27";
…	…
929	800	this.toolStrip1.Location = new System.Drawing.Point(0, 0);
930	801	this.toolStrip1.Name = "toolStrip1";
931		this.toolStrip1.Size = new System.Drawing.Size(~~812~~, 31);
	802	this.toolStrip1.Size = new System.Drawing.Size(979, 31);
932	803	this.toolStrip1.TabIndex = 0;
933	804	this.toolStrip1.Text = "reklamaToolStrip";
…	…
1004	875	//
1005	876	this.reklamyZestawienieTableAdapter.ClearBeforeFill = true;
	877	//
	878	// agencja
	879	//
	880	this.agencja.DataPropertyName = "agencja";
	881	dataGridViewCellStyle3.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
	882	this.agencja.DefaultCellStyle = dataGridViewCellStyle3;
	883	this.agencja.HeaderText = "Agencja";
	884	this.agencja.Name = "agencja";
	885	this.agencja.ReadOnly = true;
	886	this.agencja.Width = 71;
	887	//
	888	// agent
	889	//
	890	this.agent.DataPropertyName = "agent";
	891	dataGridViewCellStyle4.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
	892	this.agent.DefaultCellStyle = dataGridViewCellStyle4;
	893	this.agent.HeaderText = "Agent";
	894	this.agent.Name = "agent";
	895	this.agent.ReadOnly = true;
	896	this.agent.Width = 60;
	897	//
	898	// rokZamowienia
	899	//
	900	this.rokZamowienia.DataPropertyName = "rokZamowienia";
	901	dataGridViewCellStyle5.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
	902	this.rokZamowienia.DefaultCellStyle = dataGridViewCellStyle5;
	903	this.rokZamowienia.HeaderText = "Rok";
	904	this.rokZamowienia.Name = "rokZamowienia";
	905	this.rokZamowienia.ReadOnly = true;
	906	this.rokZamowienia.Width = 52;
	907	//
	908	// nrZamowieniaExt
	909	//
	910	this.nrZamowieniaExt.DataPropertyName = "nrZamowieniaExt";
	911	this.nrZamowieniaExt.HeaderText = "Nr zamówienia";
	912	this.nrZamowieniaExt.Name = "nrZamowieniaExt";
	913	this.nrZamowieniaExt.ReadOnly = true;
	914	this.nrZamowieniaExt.Width = 101;
	915	//
	916	// iloscReklam
	917	//
	918	this.iloscReklam.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None;
	919	this.iloscReklam.DataPropertyName = "iloscReklam";
	920	dataGridViewCellStyle6.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
	921	this.iloscReklam.DefaultCellStyle = dataGridViewCellStyle6;
	922	this.iloscReklam.HeaderText = "# rek";
	923	this.iloscReklam.Name = "iloscReklam";
	924	this.iloscReklam.ReadOnly = true;
	925	this.iloscReklam.Width = 40;
	926	//
	927	// data_od
	928	//
	929	this.data_od.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None;
	930	this.data_od.DataPropertyName = "data_od";
	931	dataGridViewCellStyle7.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
	932	dataGridViewCellStyle7.Format = "d";
	933	this.data_od.DefaultCellStyle = dataGridViewCellStyle7;
	934	this.data_od.HeaderText = "Data 1 em";
	935	this.data_od.Name = "data_od";
	936	this.data_od.ReadOnly = true;
	937	this.data_od.Width = 80;
	938	//
	939	// data_od_bez_FK
	940	//
	941	this.data_od_bez_FK.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None;
	942	this.data_od_bez_FK.DataPropertyName = "data_od_bez_FK";
	943	dataGridViewCellStyle8.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
	944	this.data_od_bez_FK.DefaultCellStyle = dataGridViewCellStyle8;
	945	this.data_od_bez_FK.HeaderText = "Data 1 em bez FV";
	946	this.data_od_bez_FK.Name = "data_od_bez_FK";
	947	this.data_od_bez_FK.ReadOnly = true;
	948	this.data_od_bez_FK.Width = 80;
	949	//
	950	// wartoscNetto
	951	//
	952	this.wartoscNetto.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None;
	953	this.wartoscNetto.DataPropertyName = "wartoscNetto";
	954	dataGridViewCellStyle9.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight;
	955	dataGridViewCellStyle9.Format = "C2";
	956	this.wartoscNetto.DefaultCellStyle = dataGridViewCellStyle9;
	957	this.wartoscNetto.HeaderText = "Netto";
	958	this.wartoscNetto.Name = "wartoscNetto";
	959	this.wartoscNetto.ReadOnly = true;
	960	this.wartoscNetto.Width = 90;
	961	//
	962	// kwotaWalutaBrutto
	963	//
	964	this.kwotaWalutaBrutto.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None;
	965	this.kwotaWalutaBrutto.DataPropertyName = "kwotaWalutaBrutto";
	966	dataGridViewCellStyle10.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight;
	967	dataGridViewCellStyle10.Format = "N2";
	968	dataGridViewCellStyle10.NullValue = null;
	969	this.kwotaWalutaBrutto.DefaultCellStyle = dataGridViewCellStyle10;
	970	this.kwotaWalutaBrutto.HeaderText = "Waluta - brutto zamówienia";
	971	this.kwotaWalutaBrutto.Name = "kwotaWalutaBrutto";
	972	this.kwotaWalutaBrutto.ReadOnly = true;
	973	this.kwotaWalutaBrutto.Width = 90;
	974	//
	975	// bruttoEuroMianoDataGridViewTextBoxColumn
	976	//
	977	this.bruttoEuroMianoDataGridViewTextBoxColumn.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None;
	978	this.bruttoEuroMianoDataGridViewTextBoxColumn.DataPropertyName = "Brutto_Euro_Miano";
	979	dataGridViewCellStyle11.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
	980	this.bruttoEuroMianoDataGridViewTextBoxColumn.DefaultCellStyle = dataGridViewCellStyle11;
	981	this.bruttoEuroMianoDataGridViewTextBoxColumn.HeaderText = "W";
	982	this.bruttoEuroMianoDataGridViewTextBoxColumn.Name = "bruttoEuroMianoDataGridViewTextBoxColumn";
	983	this.bruttoEuroMianoDataGridViewTextBoxColumn.ReadOnly = true;
	984	this.bruttoEuroMianoDataGridViewTextBoxColumn.Width = 35;
	985	//
	986	// nettoZafakturowane
	987	//
	988	this.nettoZafakturowane.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None;
	989	this.nettoZafakturowane.DataPropertyName = "nettoZafakturowane";
	990	dataGridViewCellStyle12.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight;
	991	dataGridViewCellStyle12.Format = "C2";
	992	this.nettoZafakturowane.DefaultCellStyle = dataGridViewCellStyle12;
	993	this.nettoZafakturowane.HeaderText = "Wartoæ netto FV";
	994	this.nettoZafakturowane.Name = "nettoZafakturowane";
	995	this.nettoZafakturowane.ReadOnly = true;
	996	this.nettoZafakturowane.Width = 90;
	997	//
	998	// DoZafakturowania
	999	//
	1000	this.DoZafakturowania.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None;
	1001	this.DoZafakturowania.DataPropertyName = "DoZafakturowania";
	1002	dataGridViewCellStyle13.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight;
	1003	dataGridViewCellStyle13.Format = "C2";
	1004	dataGridViewCellStyle13.NullValue = null;
	1005	this.DoZafakturowania.DefaultCellStyle = dataGridViewCellStyle13;
	1006	this.DoZafakturowania.HeaderText = "Do zafakturowania";
	1007	this.DoZafakturowania.Name = "DoZafakturowania";
	1008	this.DoZafakturowania.ReadOnly = true;
	1009	this.DoZafakturowania.ToolTipText = "Wartoæ jaka bêdzie zafakturowana na nastêpnej fakturze. Jeli faktura w walucie " +
	1010	"to wartoæ w PLN zgodna z kursem z dnia zatwierdzenia do druku.";
	1011	this.DoZafakturowania.Width = 90;
	1012	//
	1013	// SumaNaNastepnejFakturze
	1014	//
	1015	this.SumaNaNastepnejFakturze.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None;
	1016	this.SumaNaNastepnejFakturze.DataPropertyName = "SumaNaNastepnejFakturze";
	1017	dataGridViewCellStyle14.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight;
	1018	dataGridViewCellStyle14.Format = "C2";
	1019	dataGridViewCellStyle14.NullValue = null;
	1020	this.SumaNaNastepnejFakturze.DefaultCellStyle = dataGridViewCellStyle14;
	1021	this.SumaNaNastepnejFakturze.HeaderText = "Wartoæ nastêpnej faktury w PLN";
	1022	this.SumaNaNastepnejFakturze.Name = "SumaNaNastepnejFakturze";
	1023	this.SumaNaNastepnejFakturze.ReadOnly = true;
	1024	this.SumaNaNastepnejFakturze.ToolTipText = "Jeli faktura w walucie to wartoæ w PLN zgodna z kursem z dnia zatwierdzenia do " +
	1025	"druku";
	1026	this.SumaNaNastepnejFakturze.Visible = false;
	1027	this.SumaNaNastepnejFakturze.Width = 90;
1006	1028	//
1007	1029	// ZestawienieZamowienForm
…	…
1064	1086	private System.Windows.Forms.ToolStrip wyszukajToolStrip;
1065	1087	private System.Windows.Forms.SplitContainer splitContainer1;
1066		~~private System.Windows.Forms.TreeView treeView1;~~
1067	1088	private System.Windows.Forms.Panel panel;
1068	1089	private System.Windows.Forms.ToolStripButton szukajToolStripButton;
…	…
1103	1124	private System.Windows.Forms.Label label2;
1104	1125	private System.Windows.Forms.Label label1;
1105		~~private System.Windows.Forms.DataGridViewTextBoxColumn agencja;~~
1106		~~private System.Windows.Forms.DataGridViewTextBoxColumn agent;~~
1107		~~private System.Windows.Forms.DataGridViewTextBoxColumn rokZamowienia;~~
1108		~~private System.Windows.Forms.DataGridViewTextBoxColumn nrZamowieniaExt;~~
1109		~~private System.Windows.Forms.DataGridViewTextBoxColumn iloscReklam;~~
1110		~~private System.Windows.Forms.DataGridViewTextBoxColumn data_od;~~
1111		~~private System.Windows.Forms.DataGridViewTextBoxColumn data_od_bez_FK;~~
1112		~~private System.Windows.Forms.DataGridViewTextBoxColumn wartoscNetto;~~
1113		~~private System.Windows.Forms.DataGridViewTextBoxColumn kwotaWalutaBrutto;~~
1114		~~private System.Windows.Forms.DataGridViewTextBoxColumn bruttoEuroMianoDataGridViewTextBoxColumn;~~
1115		~~private System.Windows.Forms.DataGridViewTextBoxColumn nettoZafakturowane;~~
1116		~~private System.Windows.Forms.DataGridViewTextBoxColumn DoZafakturowania;~~
1117	1126	private System.Windows.Forms.DataGridViewTextBoxColumn dataGridViewTextBoxColumn3;
1118	1127	private System.Windows.Forms.DataGridViewTextBoxColumn dataGridViewTextBoxColumn6;
…	…
1134	1143	private System.Windows.Forms.ToolStripLabel toolStripLabel6;
1135	1144	private System.Windows.Forms.ToolStripTextBox txtMiesiac;
	1145	private System.Windows.Forms.TreeView treeView1;
	1146	private System.Windows.Forms.DataGridViewTextBoxColumn agencja;
	1147	private System.Windows.Forms.DataGridViewTextBoxColumn agent;
	1148	private System.Windows.Forms.DataGridViewTextBoxColumn rokZamowienia;
	1149	private System.Windows.Forms.DataGridViewTextBoxColumn nrZamowieniaExt;
	1150	private System.Windows.Forms.DataGridViewTextBoxColumn iloscReklam;
	1151	private System.Windows.Forms.DataGridViewTextBoxColumn data_od;
	1152	private System.Windows.Forms.DataGridViewTextBoxColumn data_od_bez_FK;
	1153	private System.Windows.Forms.DataGridViewTextBoxColumn wartoscNetto;
	1154	private System.Windows.Forms.DataGridViewTextBoxColumn kwotaWalutaBrutto;
	1155	private System.Windows.Forms.DataGridViewTextBoxColumn bruttoEuroMianoDataGridViewTextBoxColumn;
	1156	private System.Windows.Forms.DataGridViewTextBoxColumn nettoZafakturowane;
	1157	private System.Windows.Forms.DataGridViewTextBoxColumn DoZafakturowania;
	1158	private System.Windows.Forms.DataGridViewTextBoxColumn SumaNaNastepnejFakturze;
1136	1159
1137	1160	}

branches/Emisje/BazaReklam/ZestawienieZamowienForm.cs

r789	r796
3	3	using System.Data;
4	4	using System.Data.SqlClient;
5		~~using System.Drawing;~~
6	5	using System.Windows.Forms;
7	6	using Baza_Reklam.Classes.Helpers;
…	…
12	11	public partial class ZestawienieZamowienForm : Form, IForm
13	12	{
14		~~private const string query = "SELECT top 2000 * from VIEW_ZESTAWIENIE_ZAMOWIEN_NOWE ";~~
15	13
16	14	private static ZestawienieZamowienForm form;
17		~~private SqlCommand command;~~
18		~~private SqlDataAdapter sqlDataAdapter = new SqlDataAdapter();~~
19
20	15	private bool commandExecuted;
21	16
22		public static ZestawienieZamowienForm getZestawienieZamowienForm(MDIBazaReklam parent)
	17	public static ZestawienieZamowienForm GetZestawienieZamowienForm(MDIBazaReklam parent)
23	18	{
24	19	if (form == null){
…	…
33	28
34	29	MdiParent = parent;
35
36		//obiekty wykorzytywane przy wyszukiwaniu
37		SqlConnection conn = new SqlConnection(ConnString.getConnString().Value);
38
39		command = new SqlCommand(query,conn);
40
	30
41	31	//generuje piersze wêz³y w drzewie
42	32	generateNodes();
…	…
46	36	{
47	37	WindowState = FormWindowState.Maximized;
48		~~command.CommandText = query;~~
49		~~sqlDataAdapter.SelectCommand = command;~~
50
51	38	DBBindings.bindujAgencje(agencjaToolStripComboBox);
52	39	}
…	…
58	45	node.Name = "Biura";
59	46	treeView1.Nodes.Add(node);
60
61		~~command.Connection.Close();~~
62	47	}
63	48
64	49	private void treeView1_AfterSelect(object sender, TreeViewEventArgs e)
65	50	{
66		if (e.Node != null)
67		{
68		command.CommandText = query;
69		command.Parameters.Clear();
70
71		switch (e.Node.Level)
72		{
73		case 0:
74		break;
75		case 1:
76		break;
77		case 2:
78		break;
79		case 3:
80		switch (e.Node.Parent.Parent.Parent.Name)
81		{
82		case "Biura":
83
84		Cursor = Cursors.WaitCursor;
85
86		rEKLAMADataSet.VIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.Clear();
87		command.CommandText += " where agent=@agent";
88		command.Parameters.AddWithValue("@agent", e.Node.Name);
89		sqlDataAdapter.Fill(rEKLAMADataSet.VIEW_ZESTAWIENIE_ZAMOWIEN_NOWE);
90		commandExecuted = true;
91		fakturyDataGridView.Refresh();
92
93		Cursor = Cursors.Default;
94
95		break;
96		default:
97		break;
98		}
99		break;
100		case 4:
101		break;
102		default:
103		break;
104		}
105		}
	51	if (e.Node == null \|\| e.Node.Level != 3) return;
	52
	53	SqlCommand cmd = new SqlCommand();
	54	SqlDataAdapter dataAdapter = new SqlDataAdapter(cmd);
	55	cmd.Connection = new SqlConnection(ConnString.getConnString().Value);
	56	cmd.CommandType = CommandType.StoredProcedure;
	57
	58	cmd.CommandText = "sp_GetZestawienieZamowien";
	59	cmd.Parameters.Clear();
	60
	61	switch (e.Node.Parent.Parent.Parent.Name)
	62	{
	63	case "Biura":
	64	Cursor = Cursors.WaitCursor;
	65
	66	rEKLAMADataSet.VIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.Clear();
	67	cmd.Parameters.AddWithValue("@agent", e.Node.Name);
	68	dataAdapter.Fill(rEKLAMADataSet.VIEW_ZESTAWIENIE_ZAMOWIEN_NOWE);
	69	commandExecuted = true;
	70	fakturyDataGridView.Refresh();
	71
	72	Cursor = Cursors.Default;
	73	break;
	74	default:
	75	break;
	76	}
106	77	}
107	78
…	…
241	212
242	213	rEKLAMADataSet.VIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.Clear();
243		sqlDataAdapter.Fill(rEKLAMADataSet.VIEW_ZESTAWIENIE_ZAMOWIEN_NOWE);
244		fakturyDataGridView.Refresh();
245
246		Cursor = Cursors.Default;
	214
	215	try
	216	{
	217	BindZestawienieZamowien();
	218	}
	219	finally
	220	{
	221	Cursor = Cursors.Default;
	222	}
247	223	}
248	224	}
…	…
268	244	private void szukajToolStripButton_Click(object sender, EventArgs e)
269	245	{
270		~~command.CommandText = query;~~
271
272		~~rEKLAMADataSet.VIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.Clear();~~
273		~~rEKLAMADataSet.ReklamyZestawienie.Clear();~~
274
275		~~command.CommandText += " where 1=1 ";~~
276
277		~~command.Parameters.Clear();~~
278
279		~~if (nrZamToolStripTextBox.Text.Trim() != "")~~
280		{
281		~~int i;~~
282		~~if (!Int32.TryParse(nrZamToolStripTextBox.Text.Trim(), out i))~~
283		{
284		~~MessageBox.Show("Podaj prawid³owy numer zamówienia.");~~
285		~~return;~~
286		}
287
288		~~command.CommandText += " AND nrZamowienia=@nr";~~
289		~~command.Parameters.AddWithValue("@nr", nrZamToolStripTextBox.Text.Trim());~~
290		}
291
292		~~if (rokToolStripTextBox.Text.Trim() != "")~~
293		{
294		~~int i;~~
295		~~if (!Int32.TryParse(rokToolStripTextBox.Text.Trim(), out i))~~
296		{
297		~~MessageBox.Show("Podaj prawid³owy rok.");~~
298		~~return;~~
299		}
300
301		~~command.CommandText += " AND rokZamowienia=@rok";~~
302		~~command.Parameters.AddWithValue("@rok", rokToolStripTextBox.Text.Trim());~~
303		}
304
305		~~if (txtMiesiac.Text.Trim() != "")~~
306		{
307		~~int i;~~
308		~~if (!Int32.TryParse(txtMiesiac.Text.Trim(), out i) \|\| i > 12 \|\| i <= 0)~~
309		{
310		~~MessageBox.Show("Podaj prawid³owy miesi¹c.");~~
311		~~return;~~
312		}
313
314		~~command.CommandText += " AND (DATEPART(MONTH, data_od)=@ms OR DATEPART(MONTH, data_od_bez_FK)=@ms)";~~
315		~~command.Parameters.AddWithValue("@ms", txtMiesiac.Text.Trim());~~
316		}
317
318		~~if (kodRozliczeniowyToolStripTextBox.Text.Trim() != "")~~
319		{
320		~~command.CommandText += " AND kodAgenta = @kod ";~~
321		~~command.Parameters.AddWithValue("@kod", kodRozliczeniowyToolStripTextBox.Text.Trim());~~
322		}
323
324		~~if (kodKlientaToolStripTextBox.Text.Trim() != "")~~
325		{
326		~~command.CommandText += " AND kodKlienta like '%' + @kodKlienta + '%'";~~
327		~~command.Parameters.AddWithValue("@kodKlienta", kodKlientaToolStripTextBox.Text.Trim());~~
328		}
329
330		~~if (agencjaToolStripComboBox.Text.Trim() != "")~~
331		{
332		~~command.CommandText += " AND Agencja=@agencja";~~
333		~~command.Parameters.AddWithValue("@agencja", agencjaToolStripComboBox.Text.Trim());~~
334		}
335
336		~~sqlDataAdapter.SelectCommand = command;~~
337
338	246	Cursor = Cursors.WaitCursor;
339
340	247	try
341	248	{
342		sqlDataAdapter.Fill(rEKLAMADataSet.VIEW_ZESTAWIENIE_ZAMOWIEN_NOWE);
343		commandExecuted = true;
	249	BindZestawienieZamowien();
344	250	}
345	251	finally
…	…
349	255	Cursor = Cursors.Default;
350	256	}
	257	}
	258
	259	private void BindZestawienieZamowien()
	260	{
	261	SqlCommand cmd = new SqlCommand();
	262	SqlDataAdapter dataAdapter = new SqlDataAdapter(cmd);
	263	cmd.CommandText = "sp_GetZestawienieZamowien";
	264	cmd.CommandType = CommandType.StoredProcedure;
	265
	266	rEKLAMADataSet.VIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.Clear();
	267	rEKLAMADataSet.ReklamyZestawienie.Clear();
	268
	269	cmd.Parameters.Clear();
	270
	271	if (nrZamToolStripTextBox.Text.Trim() != "")
	272	{
	273	int i;
	274	if (!Int32.TryParse(nrZamToolStripTextBox.Text.Trim(), out i))
	275	{
	276	MessageBox.Show("Podaj prawid³owy numer zamówienia.");
	277	return;
	278	}
	279	cmd.Parameters.AddWithValue("@nrZamowienia", nrZamToolStripTextBox.Text.Trim());
	280	}
	281
	282	if (rokToolStripTextBox.Text.Trim() != "")
	283	{
	284	int i;
	285	if (!Int32.TryParse(rokToolStripTextBox.Text.Trim(), out i))
	286	{
	287	MessageBox.Show("Podaj prawid³owy rok.");
	288	return;
	289	}
	290	cmd.Parameters.AddWithValue("@rokZamowienia", rokToolStripTextBox.Text.Trim());
	291	}
	292
	293	if (txtMiesiac.Text.Trim() != "")
	294	{
	295	int i;
	296	if (!Int32.TryParse(txtMiesiac.Text.Trim(), out i) \|\| i > 12 \|\| i <= 0)
	297	{
	298	MessageBox.Show("Podaj prawid³owy miesi¹c.");
	299	return;
	300	}
	301	cmd.Parameters.AddWithValue("@miesiacZamowienia", txtMiesiac.Text.Trim());
	302	}
	303
	304	if (kodRozliczeniowyToolStripTextBox.Text.Trim() != "")
	305	cmd.Parameters.AddWithValue("@kodAgenta", kodRozliczeniowyToolStripTextBox.Text.Trim());
	306
	307	if (kodKlientaToolStripTextBox.Text.Trim() != "")
	308	cmd.Parameters.AddWithValue("@kodKlienta", kodKlientaToolStripTextBox.Text.Trim());
	309
	310	if (agencjaToolStripComboBox.Text.Trim() != "")
	311	cmd.Parameters.AddWithValue("@agencja", agencjaToolStripComboBox.Text.Trim());
	312
	313	dataAdapter.SelectCommand = cmd;
	314
	315	dataAdapter.SelectCommand.Connection = new SqlConnection(ConnString.getConnString().Value);
	316	dataAdapter.Fill(rEKLAMADataSet.VIEW_ZESTAWIENIE_ZAMOWIEN_NOWE);
	317	commandExecuted = true;
351	318	}
352	319
…	…
381	348
382	349	if (Convert.IsDBNull(r.Row["DoZafakturowania"])) continue;
383
384		~~if (Convert.ToDouble(r.Row["Korekta"]) > 0.0)~~
385		{
386		~~row.DefaultCellStyle.ForeColor = Color.Red;~~
387		}
388	350	}
389	351	}

branches/Emisje/BazaReklam/ZestawienieZamowienForm.resx

r597	r796
125	125	</metadata>
126	126	<metadata name="rEKLAMADataSet.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
127		<value>~~17, 54~~</value>
	127	<value>814, 17</value>
128	128	</metadata>
129	129	<assembly alias="System.Drawing" name="System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
…	…
199	199	<value>
200	200	iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8
201		YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAACZ5JREFUWEellwlU
	201	YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAACZ9JREFUWEellwlU
202	202	lOUax19AwwVScYmkEFxCQQS83YtLat5cTlGWp4yyyDQ0DVEyFB3QGVlkhxEQEXBDDAoIIwoRZRnWYRcY
203	203	UGAYFlklBEREQP73eYG695yr515ozvmf75vvm3l//+d5t+dVYs/5RO5nG7oG2B5lFWasqsImqaiyjsGn
…	…
213	213	RYVi4HJW0WO3c+c77GwONpq9/fYXo+NgXLNBufeCSSmSD9CItx8xIaWBVxqIRwQPDQ2GVFGP1oFetPT1
214	214	oqqzE9cb2nrPSO5UeUhqqtwSiu8dFxztXmlqupNMzBzPlFRqPW8SjFhzIO0wILEDMu0xWJOISIpcIleg
215		beAxegefoP1xD6ofdCBdoXgYJJFV+SQVVzmlVMqdE4ua9++2kKuqqr5FBtTH3BWZYoN3~~XYWrhpBiA9yi~~
216		~~TOT7oirnZwRFRKG27xG6+vvQP9CPh2REKBQOSeqaHwSklVT6JMmqXBLLq13S6muFgYE9hkuXehJcbzzL~~
217		~~89TmQKN0RG0Fkmg9KL2EXyND8GOeDNXdvZB3P8T93h7UdnYhu/F+71VpRRU34JVcXn0yoUzudkte73mz~~
218		~~rM1s88YEgr9NenGsWVAWbNVa0SNe3IqoLTQDIhF62h3xNZ3Ib+2A7H4nitt+H44+5nZDV0RxU7svpf9U~~
219		~~oqza/rcyuVdqdYNzYn2z5S6LYgLvJmmOycBjVz0d+Te6sWX7dAf7vZfQQHRHkJcTou624paiBck1TUiv~~
220		~~aUZSRQN+KW3AxULFwIX8uu6TCaVyu1/KavwkVU3C1IaWXZ+bFxH4OxLfqv+/T6/bsjfaDum2PxAZoEuo~~
221		~~h3zbTSgqLsKVc34IzaxARHk7ImX38WN+LaKL6/BDUR2u0n1IRg2EqTV9wtT6zgvShhYvibx97SrT62My~~
222		~~wCPn8D5fIwz4G+Oh8xIU2KxBTGoeYuPi4R0Wi+CSh7iYXYvLeQqE5dbiYk4tgjMVCJDUwPWGnL4rBoRZ~~
223		~~dd1eV64+0tTUDB1TF/Qf07vW6bwUCP4bBs+YoM/bEPWWc5FyaAtK4iPh6Xgcgcl3EZjdiLMZCgSSAiQK~~
224		~~eKUSPKkGl6WNCM1tRXBcY7+5vv7glClTAgwNDS3JxKz/uTI+cVhgkLJu4dMnYmM8OW2EPl9jPPJYhi4n~~
225		~~fTQd0EGD3SqUhnvCVXQcfilV8M5shVjSAL/UOpzLbEB4YQs801oQIm2F9Z6vEBoSzAdpr0fQ+afLtWau~~
226		~~H10Zn788d1npOjZ99xp63A3xyM0QPa5L0elkgA7hErQJ9NB8+DW0+JqjmEw4Hz2IgPAYBKUr4JPRCp/0~~
227		~~NlyStiEsJgHbt5rBTyxG++8duFPXhh9tzJBjwqRLJrC1ZGLKczPRsmuepPWoHh44GuDBSX10iPTRzuHH~~
228		~~FqPJ9jXUH1iImr3zUSt4C3XfuyHa/Sg8j1jDy94WHoJDEO3bifNHrJDjLYKb6ARK7tbj1/Bj6Pv5PcBz~~
229		~~FWrWq+X/XZ2tfKaJbYyp3N0++/c2wWK0HtOjiBcPg1vs9NBEkTccXAiF1XxUW+qg4gttlFksQKX9Vih8~~
230		~~baAIdID8tAAy0T5Iv9wMmd8puIsDcPbQZ+iJeoe2cWsg2QLwXoO69WpFq9XYG/9lovwD9ZnCD7SGeKRN~~
231		~~3y1Coy3p0CLcs1mEemuC7yP4bl1U7pgH2fZXcfsjLRRseRk5m19CxvrZSF01E0mvT0eC4YtIXKmLXG8X~~
232		~~1JstwaDAGEjcTvXEfiDlC8BnLe5tVC9ZrzbcHVP/7I7Cf2ro55lpos56AeS759N1IWqtFgyD5V/rouor~~
233		~~HdwZhZds00LhB3OR+44msjbMgWTtLKSumIHrRi/iNwN1/LxwKuKMtVB0/AjaPzHqhr0RkPDpiInUHYDv~~
234		~~ajSYzS7f8tGnB8nADJIKK143Y2nKullPZdu1h6NR7CPobh1U7tLB3S/nocKC0v7pq/gDzs1mb5yD9Ddn~~
235		~~IWWVBpJXzsBZRnUhZYAbiHl1MsI1JkNy+HB9tJHSTRxbBsR/TMXMXtrcPsNPP/2Eww4OFQTnu+Vw/Tjx~~
236		~~eyN1m0STyd3J/9BA5U4dVHH4Dh2Uf64NmfkrKKa0F73/MvLe1YR08xxkvjUHaWso+pUaSFmhgfMTlRG3~~
237		~~SA3h0ydCqKw05MxYoYmKyiWad943TSbE44g+EGOGe021yM4rwvLly3n59g1pLjfA5+esZZOUzUXaqhHR~~
238		~~ei/cTzKZjrQ3ZkK6SRMF772MAkp7wftzkU/R89SnUuQJS6chWpuinUFQxob8GVNQKXRNi7Hz1F4AyZa0~~
239		~~iWp00yxjFhvu7wFJdgFc3dygp6cXRu92kGb/sUmo0A2vYF6nA95Ok8lKHuZqE67Yqk244aqufNt3qkqt~~
240		~~eKJKq6cya3NjrN6BMdl+xtI/ZCz2dcYuURl8bhQqoiuvhtaQdEl8K55sYGr65lGBqNnY2CRcV1f3kpKS~~
241		~~Eq8VNo2+/8PDcCZUSXNIS0hvkniVSywmIDmRXEfF78kH+3YUyM8DpiR+MuL/54eT/6wJ+XfyyvaSeOS8~~
242		/~~3n6n3mW5Eb4C75y8azwH/KD5/xRAIfwex3SK6NAPpi4eQ591pLLn/Gpx9viaeel2jD8XzkVB307lijF~~
243		~~AAAAAElFTkSuQmCC~~
	215	beAxegefoP1xD6ofdCBdoXgYJJFV+SQVVzmlVMqdE4ua9++2kKuqqr5FBtTH3BWZYoN3TwpXDSHFBrhF
	216	mcj3RVXOzwiKiEJt3yN09fehf6AfD8mIUCgcktQ1PwhIK6n0SZJVuSSWV7uk1dcKAwN7DJcu9SS43niW
	217	56nNgUbpiNoKJNF6UHoJv0aG4Mc8Gaq7eyHvfoj7vT2o7exCduP93qvSiipuwCu5vPpkQpnc7Za83vNm
	218	WZvZ5o0JBH+b9OJYs6As2Kq1oke8uBVRW2gGRCL0tDviazqR39oB2f1OFLf9Phx9zO2GrojipnZfSv+p
	219	RFm1/W9lcq/U6gbnxPpmy10WxQTeTdIck4HHrno68m90Y8v26Q72ey+hgeiOIC8nRN1txS1FC5JrmpBe
	220	04ykigb8UtqAi4WKgQv5dd0nE0rldr+U1fhJqpqEqQ0tuz43LyLwdyS+Vf9/n163ZW+0HdJtfyAyQJdQ
	221	D/m2m1BUXIQr5/wQmlmBiPJ2RMru48f8WkQX1+GHojpcpfuQjBoIU2v6hKn1nRekDS1eEnn72lWm18dk
	222	gEfO4X2+RhjwN8ZD5yUosFmDmNQ8xMbFwzssFsElD3ExuxaX8xQIy63FxZxaBGcqECCpgesNOX1XDAiz
	223	6rq9rlx9pKmpGTqmLug/pnet03kpEPw3DJ4xQZ+3Ieot5yLl0BaUxEfC0/E4ApPvIjC7EWczFAgkBUgU
	224	8EoleFINLksbEZrbiuC4xn5zff3BKVOmBBgaGlqSiVn/c2V84rDAIGXdwqdPxMZ4ctoIfb7GeOSxDF1O
	225	+mg6oIMGu1UoDfeEq+g4/FKq4J3ZCrGkAX6pdTiX2YDwwhZ4prUgRNoK6z1fITQkmA/SXo+g80+Xa81c
	226	P7oyPn957rLSdWz67jX0uBvikZshelyXotPJAB3CJWgT6KH58Gto8TVHMZlwPnoQAeExCEpXwCejFT7p
	227	bbgkbUNYTAK2bzWDn1iM9t87cKeuDT/amCHHhEmXTGBrycSU52aiZdc8SetRPTxwNMCDk/roEOmjncOP
	228	LUaT7WuoP7AQNXvno1bwFuq+d0O0+1F4HrGGl70tPASHINq3E+ePWCHHWwQ30QmU3K3Hr+HH0Pfze4Dn
	229	KtSsV8v/uzpb+UwT2xhTubt99u9tgsVoPaZHES8eBrfY6aGJIm84uBAKq/mottRBxRfaKLNYgEr7rVD4
	230	2kAR6AD5aQFkon2QfrkZMr9TcBcH4Oyhz9AT9Q5t49ZAsgXgvQZ169WKVquxN/7LRPkH6jOFH2gN8Uib
	231	vluERlvSoUW4Z7MI9dYE30fw3bqo3DEPsu2v4vZHWijY8jJyNr+EjPWzkbpqJpJen44EwxeRuFIXud4u
	232	qDdbgkGBMZC4neqJ/UDKF4DPWtzbqF6yXm24O6b+2R2F/9TQzzPTRJ31Ash3z6frQtRaLRgGy7/WRdVX
	233	OrgzCi/ZpoXCD+Yi9x1NZG2YA8naWUhdMQPXjV7Ebwbq+HnhVMQZa6Ho+BG0f2LUDXsjIOHTEROpOwDf
	234	1Wgwm12+5aNPD5KBGSQVVrxuxtKUdbOeyrZrD0ej2EfQ3Tqo3KWDu1/OQ4UFpf3TV/EHnJvN3jgH6W/O
	235	QsoqDSSvnIGzjOpCygA3EPPqZIRrTIbk8OH6aCOlmzi2DIj/mIqZvbS5fYaffvoJhx0cKgjOd8vh+nHi
	236	90bqNokmk7uT/6GByp06qOLwHToo/1wbMvNXUExpL3r/ZeS9qwnp5jnIfGsO0tZQ9Cs1kLJCA+cnKiNu
	237	kRrCp0+EUFlpyJmxQhMVlUs077xvmkyIxxF9IMYM95pqkZ1XhOXLl/Py7RvSXG6Az89ZyyYpm4u0VSOi
	238	9V64n2QyHWlvzIR0kyYK3nsZBZT2gvfnIp+i56lPpcgTlk5DtDZFO4OgjA35M6agUuiaFmPnqb0Aki1p
	239	E9XoplnGLDbc3wOS7AK4urlBT08vjN7tIM3+Y5NQoRtewbxOB7ydJpOVPMzVJlyxVZtww1Vd+bbvVJVa
	240	8USVVk9l1ubGWL0DY7L9jKV/yFjs64xdojL43ChURFdeDa0h6ZL4VjzZwNT0zaMCUbOxsUm4rq7uJSUl
	241	JV4rbBp9/4eH4UyokuaQlpDeJPEql1hMQHIiuY6K35MP9u0okJ8HTEn8ZMT/zw8n/1kT8u/kle0l8ch5
	242	//P0P/MsyY3wF3zl4lnhP+QHz/mjAA7h9zqkV0aBfDBx8xz6rCWXP+NTj7fF085LtWH4vwAAIQd37nCS
	243	pwAAAABJRU5ErkJggg==
244	244	</value>
245	245	</data>
…	…
275	275	iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8
276	276	YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAABXRJREFUSEuVlQtQ
277		VFUYx10VG0JbMg0ZSGAmncpycPIxlqESW1CoEYyMj5BU1NDMCgNclwvs8~~BJ1UCRwZWVYFgGFGHmJGqmY~~
278		~~IIkigSAvQRQWkGRxeS7L~~/vvOzlIqC9aZ+c3de+49//89337fd3gTxhnbth034vONjsycaeTW1vakQ6F4
279		kD8~~01Judnh79By0bJKBnPJmxn4WE5IU2NbWDDa0WqKpqBsdxWh+fow0bNvgfcXHZYU+rXyYmErz/5RIZ~~
280		KTORSC5169SfG8ysuvqBzmznTnGjm5v3sVWrPAVkYEJM+k9GwcH5zjdu1BnSHzUXFhYDV9ftWldXr2ZH
281		x69CTUxMzMjEaFyjgID0EKWy54UGcXGJ2LUrCsXFQFraQwiFqZg/3y6BxG3GNfH1Tc34V51iYm~~Co1YNY~~
282		~~t04Ef/9kLFz4MUpKhlBTAzg6erSR+Dpixpi7CA3NvMk01ephaDSGDTIzz2HLloOIjCyASCRBayvw6BGw~~
283		~~aNGyahIWEVZjGfBiYvLahoeB/v4~~hdHUpcSpZDnFgIIKDAyGVSNDS8hDp6fmDs2bNTlm6dEXjxo3f4uJF
284		JZYv~~PzjM578qI+G9hKVBg/Pnz5tw3K+agYFhtLa04WRSMoqa21ChAQqfAGfutOOYVIYUeWoPCSRSlvqY~~
285		~~m5sdtrKySZs2zVRCcwcIR4Jv0CAx8cLbHBeh7ezsRrxMjk4KVT/RMjiM0seDyHvQj1P3oUtTCwuLaBKx~~
286		~~I94lPiXciI+I18dM2djYDEF5+T2cPZuFa61dUJK4hpK/rk+D4s5+ZN/vg7xaBfndHnh5brpFQk7EdGKa~~
287		~~/srqgRXfM4NVoq4axeK4TffuKSjeYlxXAfW9GlSp1LhO4gWKPmTUq3CyQonEGi18fHxUtOQHfbxHV/Oh~~
288		~~Q5XTExLqkuTyipsiUWaog4PnnB07hPsaGx+BCwpCbhvwW0sfLiv6kd/ci7MNKiRXdSPmthLy2mHs2y9i~~
289		~~/0M48abBeIeEZKeqVCzCQEcHLYzJ6HF13VNfWdmK6KijkFEYTjf04nRdN9IIWaUSsbe7ILmlRFKtFlu3~~
290		~~br5DwhF6g9E7iIrKUioUXVAolBgYoDShoVKR4Ol85OUW4Kg8A5JqDU6Ud+M4CR+5+RixZUokVKvBZRVo~~
291		~~bG1ts61sbMR6g1FxnxAQkFhbVFRLVViPiopmNDV1QKns1RlpNEOQxMUiOiULx273IvpPuq8YgpQME7Kv~~
292		~~IEIciIuXfwfn6/vE/jXjVfq0fHYX3t5hnhx3Rp2RUUKFUonCwmqUljbg7t0W0BmgMyq8cgXBnAh+wv3w~~
293		~~38/hQGiYLkUZhcWX0S5ZCaydAWczwyb8JUucv968WXSVLUhOvobc3HIUFFTSrhrIrBbe3vvovhSXLpVQ~~
294		~~6H5BXZ0KWdk5KpZB9w9+CDTsBnLWAhvM4W7B//L5nbD+zZqS3dy5tgEuLtuv+flxWqm0EDk5lQgPl2LN~~
295		~~mm/g5LQRe/fGwN7eGfHxt7BypeCqMY8ng5MJIHMCar4DzrkD6/lwmj/HQ18P//wn7AcrDmvCwdr6rQCB~~
296		~~wL1ozx5OKxT+TO04ghpaHlxcvODlFYSgoBSYmZkl0btCc6OJ6/HZVCD+EzqFtqJd6gVf36AuesZOO1Z4~~
297		~~zwy2m6kE6+UOlpbW3LJl9jfs7R21/v4nEBaWhcOHL9AuBAoej3eC3vmCFZjVS5NWQDAFrSGrUVbbgvUe~~
298		~~HjU0/xMx22Bt0OTTRgJLy9nh8+a9V7Z48eqBBQverzU2NmYHipB4h5jCPmrW5Al23n5+f7m7u5eZmppK~~
299		~~ae57Zj6Wwcj8iBGr0s8JHyKU+JFgDe0VYqTFsBAv0QvvpusH+mi8yEP3fDLBWu8bBDNjVxbKpwuLGRnr~~
300		~~v9pi5Pnfjj+6zscujms~~AAAAASUVORK5CYII=
	277	VFUYx10VG0JbMg0ZSGAmncpycPIxlqESW1CoEYyMj5BU1NDMCgNclwvs8FDQQZHAlZVhWQQUYuQlaqRi
	278	giSKBIK8BFFYQJLF5c3u/vvOzlIqC9aZ+c3de+49//89337fd3gTxhnbth034vONjsycaeTW1vakQ6F4
	279	kD883Judnh79By0bJKBnPJmxn4WE5IU2NbWDDa0WqKpqBsdxWh+fow0bNvgfcXHZYU+rXyYmErz/5RIR
	280	ITORSC5169SfG8ysuvqBzmznTnGjm5v3sVWrPAVkYEJM+k9GwcH5zjdu1BnSHzUXFhYDV9ftWldXr2ZH
	281	x69CTUxMzMjEaFyjgID0EKWy54UGcXGJ2LUrCsXFQFraQwiFqZg/3y6BxG3GNfH1Tc34V51iYmAMDQ1i
	282	3ToR/P2TsXDhxygpGUZNDeDo6NFG4uuIGWPuIjQ08ybTHBrSQK02bJCZeQ5btkQiIqIAIpEEra3Ao0fA
	283	okXLqklYRFiNZcCLiclr02iA/v5hdHUpcSpZDnFgIIKDAyGVSNDS8hDp6fmDs2bNTlm6dEXjxo3f4uJF
	284	JZYvj9Tw+a/KSHgvYWnQ4Pz58yYc96t6YECD1pY2nExKRlFzGyrUQOET4MyddhyTypAiT+0hgUTKUh9z
	285	c7PDVlY2adOmmUpo7iDhSPANGiQmXnib48Tazs5uxMvk6KRQ9RMtgxqUPh5E3oN+nLoPXZpaWFhEk4gd
	286	8S7xKeFGfES8PmbKxsZmCMrL7+Hs2Sxca+2CksTVlPx1fWoUd/Yj+34f5NUqyO/2wMtz0y0SciKmE9P0
	287	V1YPrPieGawSddUoFsdtundPQfEW47oKqO9Vo0o1hOskXqDoQ0a9CicrlEis0cLHx0dFS37Qx3t0NR86
	288	VDk9IaEuSS6vuCkSZYY6OHjO2bFDuK+x8RG4oCDktgG/tfThsqIf+c29ONugQnJVN2JuKyGv1WDffhH7
	289	H8KJNw3GOyQkO1WlYhEGOjpoYUxGj6vrnvrKylZERx2FjMJwuqEXp+u6kUbIKpWIvd0FyS0lkmq12Lp1
	290	8x0SPqA3GL2DqKgspULRBYVCiYEBShMaKhUJns5HXm4BjsozIKlW40R5N46T8JGbjxFbpkRC9RC4rAK1
	291	ra1ttpWNjVhvMCruEwICEmuLimqpCutRUdGMpqYOKJW9OiO1ehiSuFhEp2Th2O1eRP9J9xXDkJJhQvYV
	292	HBAH4uLl38H5+j6xf814lT4tn92Ft3eYJ8edGcrIKKFCqURhYTVKSxtw924L6AzQGRVeuYJgTgQ/4X74
	293	7+dwMDRMl6KMwuLLaJesBNbOgLOZYRP+kiXOX2/eLLrKFiQnX0NubjkKCippVw1kVgtv7310X4pLl0oo
	294	dL+grk6FrOwcFcug+5EfAg27gZy1wAZzuFvwv3x+J6x/s6ZkN3eubYCLy/Zrfn6cViotRE5OJcLDpViz
	295	5hs4OW3E3r0xsLd3Rnz8LaxcKbhqzOPJ4GQCyJyAmu+Ac+7Aej6c5s/x0NfDP/8J+8GKw5pwsLZ+K0Ag
	296	cC/as4fTCoU/Uzs+QA0tDy4uXvDyCkJQUArMzMyS6F2hudHE9fhsKhD/CZ1CW9Eu9YKvb1AXPWOnHSu8
	297	ZwbbzVSC9XIHS0trbtky+xv29o5af/8TCAvLwuHDF2gXAgWPxztB73zBCszqpUkrIJiC1pDVKKttwXoP
	298	jxqa/4mYbbA2aPJpI4Gl5ezwefPeK1u8ePXAggXv1xobG7MDRUi8Q0xhHzVr8gQ7bz+/v9zd3ctMTU2l
	299	NPc9Mx/LYGR+xIhV6eeEDxFK/EiwhvYKMdJiWIiX6IV30/UDfTRe5KF7PplgrfcNgpmxKwvl04XFjIz1
	300	X20x8vxvbMe6yP+pQ2kAAAAASUVORK5CYII=
301	301	</value>
302	302	</data>
…	…
405	405	<value>
406	406	iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8
407		YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAABX5JREFUSEudlQtQ
408		zXkUx0+lbrfYWiVWJY+1TYNYochOK90sFXlEtCwJO9u23munGd~~2tU~~IRS6OouRaWo22NxVzVE3q/KrvVY
409		jKUoux6ztzSm3~~Pvd8/PP~~jhIz9jfzmf/93//v9z3nd37nnJ8RvWusrOxPjbrvyFim+KCLRa/nz5ubmh/W
410		V1PDgzyqiM~~0jXa2Ol794p8ZbP665v6pz1K3nQ1UtmLAPmMgEFwJzioFRSfdBQZpKGrLAi9dbMkbvZ2Td~~
411		~~w83dEp5igApw3tqCT9MAj3TAMwPw2g345wJB+/Uw++rw3zQwZDqLW7Uz8g6Dyrrp8iilw~~Tzyko6Cd5WR
	407	YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAABX1JREFUSEudlQtQ
	408	zXkUx0+lbrfYWiVWJY+1TYNYochOK90sFXlEtCwJO9u23munGd1NVIRS6OouRaWo22NxVzVE3q/KrvVY
	409	jKUoux6ztzSm3L57fv7XjhIz9jfzmf/93//v9z3nd37nnJ8RvWusrOxPjbrvyFim+KCLRa/nz5ubmh/W
	410	V1PDgzyqiMkjXa2Ol794p8ZbP669v6pz1K3nQ1UtmLAPmMgEFwJzioFRSfdBQZpKGrLAi9dbMkbvZyT2
	411	4eZuCU8xQAU4b23Bp2mARzrgmQF47Qb8c4Gg/XqYfXX4bxoYMp3FrdoZeYdBZd10eZSy1Tzyko6Cd5WR
412	412	1woN+SeVycPP6TxUTfBjcb+9QOB+YFo+YBpcWEd27hNfGhl/dCp55xfR8JRZ/N6FMW67M6XSmJZX3qaF
413		h3JIb~~hXDH+OZ5cwisrBZSX7rSt~~2S6jCTQzWDxUMPAPMLW0DeyWfJKWCK/cwjzzZUAVaTcx7xGhE+sbPX
414		RuQ9e1p6OY7/mc3MYUYwvZge0rOTB/nGF/ikPcKiQ8CyUiD6BO9oyx2Qe+rTTa~~cMiDsHWPruuM3zv29d~~
415		28aE2JIQG8n0Yc~~xbYytiKpCTpcNACsy9sqoMiGXx+FNAIov+cKgRieeBzRcBcl5awXOVTO+2O5BEzJjO~~
416		~~TKf2H1vfZeQWMc09ulyffIHFzwDbWDiVhbcz0SXPQD2nFvDcpYx9RxqvvO1Y/wutjDyTx5Nnes2WM3qk~~
417		~~segujntGNZB5BfgmswZkM2o3L57L2Eki6//pTz/eTqXIqwm08vxiCudsCC0aRgHq7q07kYyGnHWwnHe0~~
418		~~NjDlJlZrdVBXSsJ7fwP2sXjBH5xd8dUgc8c0nh/ISIcsi7tbpb1pgOZqM+JPNCC04DF8d9ZgkFJpsFPe~~
419		~~eGIUca6UHMf0I+/04JD0eqSyoPqy5HHeNaDoBlB8HdDeAYZFKA1kYp7KsiKL5ERLLnzkpYwx1DYApbck~~
420		~~b9J5yyKmSXx4sXyIY1R/gVynRZFN32Hkl1dqG3bskatXuX7cmiqEqm5CWfAAO041IP1iM4w9NlSzcCIz~~
421		~~WNp9xLExCzR1OFsL5P/OXrFnaZeAFBb/9udGjEy5B4tFxTUkt97ICz5jBjChZCJfSxY9E8lq8HbqodhF~~
422		~~9iG51HteIZl1VfH3CMbxZVgprCQ8rlyHAt5q9q9STFWcFfEn9aAZ2XfJyimTjExETEVWuDAiw0Qqf8wM~~
423		~~YjwYBTOZCWGCGFcpPGLM+SVZffEF9rDnQnwHh2YLey/CM3RjuZ5snbfxLNFvPmEsJK/+Q6SyrNWoNT9t~~
424		~~ma7Mq/rhn3PLSrL4sNQclqiyJmzj3E7guMdWAMu5Uiko5wqZyUWv+bBVWHLszdFxetsuPv5nGh/q2goO~~
425		~~yazix1Mz6hF3EljB4qIdjFU/ASliiohMxbaFt2+OCUfWk2usqHxRpG07qe2S0083ccy7h5/WkbxbFk1S~~
426		~~n//6YAsWciObpWG4sbltrgWN26QlB2/Rm0RsJW8VJXak0GSTj+Y6v3syom7adVD/n2aTn1pLjp7iIOPI~~
427		~~1mW+aZi2PqQImM4GxEXjz4xUNcAy7HgjjdtzgMZmqUiRe1A+s/yZLJjzvnfQal77JePQURhFtYmiEBnw~~
428		~~+ctJQ+YHicskIMcAf+77PpnSRePJT7edgMtWPVz4ArJZxuIuEdm8RrR2kUnt2rMUTbElcTmIDHjV5KzI~~
429		~~yWcKBWRUOcfcgVeWJD6Cb7QhTJ+ERpj7Hm4ix4AsXpPCiAtGeG/y5gF1/I+IsTUX4mjqN3E9uUcfN52U~~
430		~~Vyebkv/EaHTKNeozgwvKeifPEReSyHsn5m3d9602hRFxoYuCmsCI6oxl1jGRjLiUhjPd/o/461aFZyK2~~
431		~~PZm+rQaFxyKkrxVUx47+C5Uzsf7zb1VpAAAAAElFTkSuQmCC~~
	413	h3JIbrWGP8Yzy5lFZGGzkvxiS92S6jCTQzWDxUMPAPMLW0DeyWfJKWCK/cwjzzZUAVaTcx7xGhE+sbPX
	414	RuQ9e1p6OY7/mc3MYUYwvZge0rOTB/nGF/ikPcKiQ8CyUiD6BO9oyx2Qe+rTTadaEXcOsPTdcZvnf29Y
	415	28aE2JIQG8n0YcwNsRUxFcjJ0mEgBeZeWVUGxLB4/CkgkUV/ONSIxPPA5osAOS+t4LlKpnfbHUgiZkxn
	416	plP7j4Z3GblFTHOPLtcnX2DxM8A2Fk5l4e1MdMkzUM+pBTx3KWPfkcYrbzvW/0IrI8/k8eSZXrPljB5p
	417	LLqL455RDWReAb7JrAHZjNrNi+cydpLI+n/604+3UynyagKtPL+YwjkbQouGUYC6u2EnktGQsw6W847W
	418	BqbcxGqtDupKSXjvb8A+Fi/4g7Mrvhpk7pjG8wMZ6ZBlcXertDdbobnajPgTDQgteAzfnTUYpFS22ilv
	419	PDGKOFdKjmP6kXd6cEh6PVJZUH1Z8jjvGlB0Ayi+DmjvAMMilK1kYp7KsiKL5ERLLnzkxUK1DUDpLcmb
	420	dN6yiGkSH14MH+IY1V8g12lRZNN3GPnlldqGHXvk6lWuH7e2CqGqm1AWPMCOUw1Iv9gMY48N1SycyAyW
	421	dh9xbMwCTR3O1gL5v7NX7FnaJSCFxb/9uREjU+7BYlFxDcmtN/KCz5gBTCiZyNeRRc9Eshq8nXoodpF9
	422	SC71nldIZl1V/D2CcXwZVgorCY8r16GAt5r9qxRTFWdF/Ek9aEb2XbJyyiQjExFTkRUujMgwkcofM4MY
	423	D0bBTGZCmCDGVQqPGHN+SVZffIE97LkQ38Gh2cLei/AM3ViuJ1vnbTxL9JtPGAvJq/8QqSwzGLXmpy3T
	424	lXlVP/xzbllJFh+WmsMSVdaEbZzbCRz3mApgOVcqBeVcITO56DUfGoQlx94cHae37eLjf6bxoa6r4JDM
	425	Kn48NaMecSeBFSwu2sFY9ROQYk0RkanYtvD2zTHhyHpyjRGVL4q0bSe1XXL66SaOeffw0zqSd8uiSerz
	426	Xx9swUJuZLM0DDc2t821oHGbtOTgLXqTiK3kraLEjhSabPLRXOd3T0bUTbsO6v/TbPJTa8nRUxxkHNm6
	427	zDcN09aHFAHT2YC4aPyZkaoGWIYdb6Rxew7Q2CwVKXIPymeWP5MFc973DlrNa79kHDoKo6g2URQiAz5/
	428	OWnI/CBxmQTktMKf+75PpnTRePLTbSfgslUPF76AbJaxuEtENq8RrV1kUrv2LEVTbElcDiIDXjU5K3Ly
	429	mUIBGVXOa+7AK0sSH8E32hCmT0IjzH0PN5FjQBavSWHEBSO8N3nzgDr+R8TYmgtxNPWbuJ7co4+bTsqr
	430	k03Jf2I0OuUa9ZnBBWW9k+eIC0nkvRPztu77VpvCiLjQRUFNYER1xjCxTCQjLqXhTLf/I/66VeGZiG1P
	431	pq/BoPBYhPS1gurY0X8BhoGx+2qUKDkAAAAASUVORK5CYII=
432	432	</value>
433	433	</data>
434	434	<metadata name="wyszukajToolStrip.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
435		<value>~~310, 54~~</value>
	435	<value>1107, 17</value>
436	436	</metadata>
437	437	<data name="szukajToolStripButton.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">
…	…
495	495	<value>True</value>
496	496	</metadata>
	497	<metadata name="SumaNaNastepnejFakturze.UserAddedColumn" type="System.Boolean, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
	498	<value>True</value>
	499	</metadata>
497	500	<metadata name="RABAT_WARTOSC.UserAddedColumn" type="System.Boolean, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
498	501	<value>True</value>
…	…
502	505	</metadata>
503	506	<metadata name="reklamyZestawienieBindingSource.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
504		<value>~~451~~, 54</value>
	507	<value>17, 54</value>
505	508	</metadata>
506	509	<metadata name="toolStrip1.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
507		<value>~~233, 91~~</value>
	510	<value>454, 54</value>
508	511	</metadata>
509	512	<data name="zamToolStripButton.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">
…	…
532	535	</data>
533	536	<metadata name="reklamaTableAdapter.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
534		<value>~~153, 54~~</value>
	537	<value>950, 17</value>
535	538	</metadata>
536	539	<metadata name="VIEW_ZESTAWIENIE_ZAMOWIEN_NOWETableAdapter.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
…	…
538	541	</metadata>
539	542	<metadata name="reklamyZestawienieTableAdapter.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
540		<value>~~17, 91~~</value>
	543	<value>238, 54</value>
541	544	</metadata>
542	545	<metadata name="$this.TrayHeight" type="System.Int32, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
543		<value>25</value>
	546	<value>97</value>
544	547	</metadata>
545	548	</root>

branches/Emisje/BazaReklamSetup/BazaReklamSetup.vdproj

r765	r796
656	656	"Name" = "8:Microsoft Visual Studio"
657	657	"ProductName" = "8:Baza Reklam"
658		"ProductCode" = "8:{~~F0CEF34A-E815-4D04-8A8E-28047479257F~~}"
659		"PackageCode" = "8:{~~22ABD221-8699-47FA-96A6-F0FC1D3952C9~~}"
	658	"ProductCode" = "8:{ED038D25-96BE-4894-83A5-B1E699B7B0A8}"
	659	"PackageCode" = "8:{A623D699-24EA-4721-A69D-87D3F8DD32C0}"
660	660	"UpgradeCode" = "8:{4E2DBBA4-3139-4790-8DDB-7AADFC963A7D}"
661	661	"RestartWWWService" = "11:FALSE"
…	…
663	663	"DetectNewerInstalledVersion" = "11:TRUE"
664	664	"InstallAllUsers" = "11:TRUE"
665		"ProductVersion" = "8:1.1.23"
	665	"ProductVersion" = "8:1.1.24"
666	666	"Manufacturer" = "8:AACT"
667	667	"ARPHELPTELEPHONE" = "8:"

branches/Emisje/BazaZamowien

Włąściwość: svn:mergeinfo set to /trunk/BazaZamowien:774-795

branches/Emisje/BazaZamowien_Instalka

Włąściwość: svn:mergeinfo set to /trunk/BazaZamowien_Instalka:774-795

branches/Emisje/BazaZamowien_Updater

Włąściwość: svn:mergeinfo set to /trunk/BazaZamowien_Updater:774-795

branches/Emisje/SQL/StoredProcedures/sp_GetReklamy.txt

r732	r796
30	30	DECLARE @query nvarchar(4000)
31	31
	32	SET @query = ''
	33
	34	IF (NOT (@rok IS NULL)) AND (NOT (@ms IS NULL))
	35	BEGIN
	36
	37	SET @query = @query +
	38	'
	39	DECLARE @startDate DATETIME
	40	DECLARE @endDate DATETIME
	41
	42	SELECT @startDate=dateadd(yy,(' + CAST(@rok as nvarchar) + '-1900),0) + dateadd(mm,' + CAST(@ms as nvarchar) + '-1,0) + 0
	43	SELECT @endDate=dateadd(yy,(' + CAST(@rok as nvarchar) + '-1900),0) + dateadd(mm,' + CAST(@ms as nvarchar) + '-1+1,0) + 0
	44
	45	'
	46	END
32	47
33	48
34		set @query = '
	49	SET @query = @query + '
	50
35	51	SELECT TOP 1000
36		~~--R.ReklamaID~~
37	52	R.*,
38	53	O.wyd_od AS OD,
39	54	O.wyd_do AS DO,
40		DATEPART(year, NR.DATA_W),
41		DATEPART(month, NR.DATA_W),
42		NR.DATA_W AS ''1emisja'',
	55	DATEPART(year, N.DATA_W),
	56	DATEPART(month, N.DATA_W),
	57	N.DATA_W AS ''1emisja'',
43	58	A.Symbol AS agencja,
44	59	(r.[CENA JEDN] - r.[RABAT WARTOÆ]) / r.SZER * r.WYS AS [CENA MODU£U],
…	…
51	66	RIGHT JOIN REKLAMA R ON A2.Symbol = R.[SYMBOL AKWIZYTORA]
52	67	LEFT JOIN dbo.VIEW_REKLAMA_OD_DO_DATY O ON R.ReklamaID = O.ReklamaId
53		LEFT JOIN ~~NR ON R.TYTU£ = NR.TYT AND O.wyd_od = NR.NRW -- OR O.wyd_do = NR.NRW)~~
	68	LEFT JOIN dbo.NR N ON R.TYTU£ = N.TYT AND O.wyd_od = N.NRW
54	69	LEFT OUTER JOIN [NAZWY MODU£ÓW] NM ON r.MOD_TYP = NM.MOD_TYP AND r.[Tytu³] = NM.Tytul
55	70	LEFT OUTER JOIN dbo.KLIENCI AS K ON R.customerId=K.CustomerId
…	…
57	72	where 1=1 and (r.SZER * r.WYS)<>0 '
58	73
59		if NOT (@agencja IS NULL)
	74	IF NOT (@agencja IS NULL)
60	75	SET @query = @query + ' AND A.Symbol=''' + @agencja + ''' '
61	76
62		if NOT (@agent IS NULL)
	77	IF NOT (@agent IS NULL)
63	78	SET @query = @query + ' AND [symbol akwizytora] like ''%' + @agent + '%'' '
64	79
65		if NOT (@reklama IS NULL)
	80	IF NOT (@reklama IS NULL)
66	81	SET @query = @query + ' AND r.[id reklamy] like ''%' + @reklama + '%'' '
67	82
68		if NOT (@rok IS NULL)
69		SET @query = @query + ' AND DATEPART(year,NR.DATA_W)=' + CAST(@rok as nvarchar) + ' '
	83	IF NOT (@rok IS NULL)
	84	SET @query = @query + ' AND DATEPART(year, N.DATA_W)=' + CAST(@rok as nvarchar) + ' '
70	85
71		if NOT (@ms IS NULL)
72		BEGIN
73		SET @query = @query + ' AND DATEPART(month, O.data_od)<=' + CAST(@ms as nvarchar) + ' '
74		SET @query = @query + ' AND DATEPART(month, O.data_do)>=' + CAST(@ms as nvarchar) + ' '
75		END
76
77		if NOT (@tytul IS NULL)
78		SET @query = @query + ' AND R.[tytu³]=''' + @tytul + ''' '
79
80		if NOT (@typ IS NULL)
81		SET @query = @query + ' AND R.[TYP]=''' + @typ + ''' '
82
83		if NOT (@promocja IS NULL)
84		SET @query = @query + ' AND R.[Promocja]=' + CAST(@promocja as nvarchar) + ' '
85
86		if (NOT (@fw IS NULL) AND NOT(@ms IS NULL) AND NOT(@rok IS NULL))
	86	IF (NOT (@rok IS NULL)) AND (NOT (@ms IS NULL))
87	87	BEGIN
88	88	SET @query = @query + ' AND R.ReklamaId IN '
…	…
90	90	SET @query = @query + ' FROM [Uka¿e siê w Nr] U '
91	91	SET @query = @query + ' INNER JOIN Reklama R on R.ReklamaID=U.ReklamaID '
92		SET @query = @query + ' INNER JOIN nr N on u.[nr wydania]=N.nrw and N.TYT=R.[Tytu³] '
93		SET @query = @query + ' WHERE DATEPART(MONTH, N.Data_W)=' + CAST(@ms as nvarchar)
94		SET @query = @query + ' AND DATEPART(YEAR, N.Data_W)=' + CAST(@rok as nvarchar)
95		SET @query = @query + ' AND U.Zafakturowana=' + CAST(@fw as nvarchar) + ') '
	92	SET @query = @query + ' INNER JOIN dbo.Nr N on U.[nr wydania]=N.nrw and N.TYT=R.[Tytu³] '
	93	SET @query = @query + ' WHERE N.Data_W>=@startDate AND N.Data_W<@endDate '
	94	IF (NOT @fw IS NULL)
	95	SET @query = @query + ' AND U.Zafakturowana=' + CAST(@fw as nvarchar)
	96	IF NOT (@agent IS NULL)
	97	SET @query = @query + ' AND R.[symbol akwizytora] like ''%' + @agent + '%'' '
	98
	99	IF NOT (@tytul IS NULL)
	100	SET @query = @query + ' AND R.[tytu³]=''' + @tytul + ''' '
	101
	102	IF NOT (@typ IS NULL)
	103	SET @query = @query + ' AND R.[TYP]=''' + @typ + ''' '
	104
	105	IF NOT (@promocja IS NULL)
	106	SET @query = @query + ' AND R.[Promocja]=' + CAST(@promocja as nvarchar) + ' '
	107
	108	IF NOT (@zd IS NULL)
	109	SET @query = @query + ' AND R.[Zatwierdzono do druku]=' + CAST(@zd as nvarchar) + ' '
	110
	111	IF NOT (@kz IS NULL)
	112	SET @query = @query + ' AND R.[Kier_zatwierdzil]=' + CAST(@kz as nvarchar) + ' '
	113
	114	IF NOT (@wy IS NULL)
	115	SET @query = @query + ' AND R.[wyroznienie]=' + CAST(@wy as nvarchar) + ' '
	116
	117	SET @query = @query + ' ) '
96	118	END
	119
	120	IF NOT (@tytul IS NULL)
	121	SET @query = @query + ' AND R.[tytu³]=''' + @tytul + ''' '
	122
	123	IF NOT (@typ IS NULL)
	124	SET @query = @query + ' AND R.[TYP]=''' + @typ + ''' '
	125
	126	IF NOT (@promocja IS NULL)
	127	SET @query = @query + ' AND R.[Promocja]=' + CAST(@promocja as nvarchar) + ' '
97	128
98	129	IF NOT (@zd IS NULL)
…	…
114	145
115	146
116		~~print~~ @query
	147	--PRINT @query
117	148
118	149

branches/Emisje/SQL/Views/VIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.txt

r443	r796
22	22	ZFK.data1 AS data_od_bez_FK,
23	23	ZNFK.nettoZafakturowane,
24		DoZafakturowania =
25		CASE
26		WHEN (R.kwotaWalutaBrutto IS NULL OR R.kwotaWalutaBrutto=0) THEN
27		CASE COALESCE(Korekta.Netto, 0)
28		WHEN 0 THEN (R.wartoscNetto - ZNFK.nettoZafakturowane)
29		ELSE Korekta.Netto - ZNFK.nettoZafakturowane
30		END
31		ELSE
32		CASE COALESCE(Korekta.waluta_brutto, 0)
33		WHEN 0 THEN
34		CASE
35		WHEN F.waluta_kurs IS NULL THEN (R.wartoscNetto - ZNFK.nettoZafakturowane)
36		ELSE ROUND(F.waluta_kurs * (R.kwotaWalutaBrutto - (ZNFK.nettoZafakturowane/F.waluta_kurs)), 0)
37		END
38		ELSE
39		ROUND(F.waluta_kurs * (Korekta.waluta_brutto - (ZNFK.nettoZafakturowane/F.waluta_kurs)), 0)
40		END
41		END,
	24	DoZafakturowania = R.wartoscNetto - ZNFK.nettoZafakturowane,
42	25	K.kodKlienta,
43		r.Brutto_Euro_Miano,
44		~~COALESCE(Korekta.Netto, 0)~~ AS Korekta
45		FROM dbo.zamowienia AS z
	26	r.Brutto_Euro_Miano,
	27	0 AS Korekta
	28	FROM dbo.zamowienia AS Z
46	29	LEFT OUTER JOIN dbo.AGENCI AS A1 ON z.kodAgenta = A1.F_ROZ
47	30	LEFT OUTER JOIN dbo.AGENCJE AS A2 ON A1.ID_AGENCJI = A2.Id_agencji
48	31	LEFT OUTER JOIN dbo.KLIENCI AS K ON K.CustomerID = z.idKlienta
49		LEFT OUTER JOIN dbo.ZAMOWIENIA_REKLAMY AS ~~r ON z.idZamowienia = r~~.idZamowienia
	32	LEFT OUTER JOIN dbo.ZAMOWIENIA_REKLAMY AS R ON z.idZamowienia = R.idZamowienia
50	33	LEFT OUTER JOIN dbo.ZAMOWIENIA_1EMISJA AS ZE ON ZE.idZamowienia = z.idZamowienia
51	34	LEFT OUTER JOIN dbo.ZAMOWIENIA_1EMISJA_bezFK AS ZFK ON ZFK.idZamowienia = z.idZamowienia
52	35	LEFT OUTER JOIN dbo.ZAMOWIENIA_NETTO_ZAFAKTUROWANE AS ZNFK ON ZNFK.idZamowienia = z.idZamowienia
53		~~LEFT OUTER JOIN dbo.VIEW_KOREKTY AS Korekta ON Korekta.idZamowienia = z.idZamowienia~~
54		~~LEFT OUTER JOIN dbo.Faktury AS F ON F.idZamowienia = z.idZamowienia~~
55	36	GO
56	37

branches/Emisje/SQL/Views/ZAMOWIENIA_NETTO_ZAFAKTUROWANE.txt

r421	r796
8	8	AS
9	9
10		SELECT Z.idZamowienia,round(sum (U.netto),2) AS nettoZafakturowane
	10	SELECT T.idZamowienia, (T.FakturyNetto + COALESCE(K.nettoKorekta, 0)) AS nettoZafakturowane FROM
	11	(
	12	SELECT Z.idZamowienia, ROUND(SUM(FD.Netto),2) AS FakturyNetto
11	13	FROM dbo.zamowienia AS Z
12		LEFT JOIN Reklama R ON Z.idZamowienia = R.idZamowienia
13		LEFT JOIN [UKA¯E SIÊ W NR] U ON U.reklamaId = R.reklamaId
14		WHERE ~~u.status<>2 AND zafakturowana=1~~
	14	INNER JOIN Faktury F ON F.idZamowienia=Z.idZamowienia
	15	INNER JOIN Faktura_Details FD ON F.ID_Faktury = FD.ID_Faktury
	16	WHERE F.Korekta=0 --AND Z.idZamowienia=@idZamowienia
15	17	GROUP BY Z.idZamowienia
	18	) T LEFT OUTER JOIN
	19	(
	20	SELECT idZamowienia, ROUND(SUM(COALESCE(K.roznica_netto, 0)), 2) AS nettoKorekta
	21	FROM VIEW_KOREKTY K
	22	--WHERE idZamowienia=@idZamowienia
	23	GROUP BY idZamowienia
	24	) K ON T.idZamowienia = K.idZamowienia
	25
16	26	GO
17	27

branches/Emisje/Wierszowki/Wierszowki.Web/Controllers/MagazineItemController.cs

r752	r796
50	50	if (ModelState.IsValid)
51	51	{
52		var author = _context.Authors.Single(a => a.Id == magazineItem.AuthorId);
53		return RedirectToAction("Confirm", author);
	52	return RedirectToAction("Confirm", _context.Authors.Single(a => a.Id == magazineItem.AuthorId));
54	53	}
55	54
…	…
95	94	{
96	95	var author = _context.Authors.Single(a => a.Id == magazineItem.AuthorId);
	96
97	97	return RedirectToAction("Confirm", author);
98	98	}

branches/Emisje/Wierszowki/Wierszowki.Web/Controllers/ReportController.cs

r752	r796
40	40	}
41	41
42		public ActionResult All()
	42	public ActionResult All(int year, int month, int user)
43	43	{
44		var items = _context.MagazineItems.ToList();
	44	var items = _repository.Find(m => m.Date.Month == month && m.Date.Year == year && m.CreatedBy == user)
	45	.OrderByDescending(m => m.UpdatedOn).ToList();
45	46	return View(items);
46	47	}

branches/Emisje/Wierszowki/Wierszowki.Web/Global.asax.cs

r752	r796
45	45
46	46	routes.MapRoute(
	47	"All", // Route name
	48	"Report/All/{year}/{month}/{user}", // URL with parameters
	49	new { controller = "Report", action = "All", year = DateTime.Now.Year, month = DateTime.Now.Month, user = 0 } // Parameter defaults
	50	);
	51
	52	routes.MapRoute(
47	53	"Default", // Route name
48	54	"{controller}/{action}/{id}", // URL with parameters

branches/Emisje/Wierszowki/Wierszowki.Web/Views/MagazineItem/Confirm.aspx

r752	r796
9	9	<h2>Pomylnie dodano/zaktualizowano wierszówkê dla: <%= Html.Encode(ViewData.Model.FirstName + " " + ViewData.Model.LastName)%></h2>
10	10	<div>
11		<%=Html.ActionLink("Powrót", "Index", "~~Home~~") %>
	11	<%=Html.ActionLink("Powrót", "Index", "Report") %>
12	12	</div>
13	13	</asp:Content>

branches/Emisje/Wierszowki/Wierszowki.Web/Views/MagazineItem/Create.aspx

r752	r796
72	72	<div class="formitem">
73	73	<label for="MagazineItem.Description">Opis:</label>
74		<%= Html.Text~~Box~~("MagazineItem.Description", Model.MagazineItem.Description, new { title = "Proszê wprowadziæ opis artyku³u." })%>
	74	<%= Html.TextArea("MagazineItem.Description", Model.MagazineItem.Description, new { title = "Proszê wprowadziæ opis artyku³u." })%>
75	75	</div>
76	76	<div class="formitem">

branches/Emisje/Wierszowki/Wierszowki.Web/Views/MagazineItem/Edit.aspx

r752	r796
73	73	<div class="formitem">
74	74	<label for="MagazineItem.Description">Opis:</label>
75		<%= Html.Text~~Box~~("MagazineItem.Description", Model.MagazineItem.Description, new { title = "Proszê wprowadziæ opis artyku³u." })%>
	75	<%= Html.TextArea("MagazineItem.Description", Model.MagazineItem.Description, new { title = "Proszê wprowadziæ opis artyku³u." })%>
76	76	</div>
77	77	<div class="formitem">

branches/Emisje/Wierszowki/Wierszowki.Web/Views/Report/All.aspx

r752	r796
64	64	</table>
65	65	<p>
66		<%= Html.ActionLink("Powrót", "Index", "~~Home~~") %>
	66	<%= Html.ActionLink("Powrót", "Index", "Report") %>
67	67	</p>
68	68

branches/Emisje/Wierszowki/Wierszowki.Web/Views/Report/Index.aspx

r772	r796
64	64	<td>
65	65	<%= Html.MonthSelect("month")%>
	66	</td>
	67	</tr>
	68	<tr>
	69	<td></td>
	70	<td><input type="submit" value="Poka¿" /></td>
	71	</tr>
	72	</table>
	73	<% } %>
	74	</td>
	75	<td style="text-align:left; vertical-align:top;">
	76	<h4>Wierszówki miesiêczne wg wprowadzaj¹cego i wybranego miesi¹ca</h4>
	77	<% using (Html.BeginForm("All", "Report")) { %>
	78	<table>
	79	<tr>
	80	<td>
	81	<label for="Year">Rok:</label>
	82	</td>
	83	<td>
	84	<%= Html.YearSelect("year")%>
	85	</td>
	86	</tr>
	87	<tr>
	88	<td>
	89	<label for="Month">Miesi¹c:</label>
	90	</td>
	91	<td>
	92	<%= Html.MonthSelect("month")%>
	93	</td>
	94	</tr>
	95	<tr>
	96	<td>
	97	<label for="user">Wprowadzaj¹cy:</label>
	98	</td>
	99	<td>
	100	<select id="user" name="user">
	101	<option value="3">zbyszek</option>
	102	<option value="4">slawek</option>
	103	</select>
66	104	</td>
67	105	</tr>
…	…
142	180	<% } %>
143	181	</td>
	182	<td style="text-align:left; vertical-align:top;"></td>
144	183	</tr>
145	184	</table>

Nawigacja

Zbiór zmian 796

Legenda:

branches/Emisje

branches/Emisje/BazaReklam.Updater

branches/Emisje/BazaReklam/Baza Reklam.csproj

branches/Emisje/BazaReklam/Classes/Interfaces

branches/Emisje/BazaReklam/Classes/Model

branches/Emisje/BazaReklam/Classes/Repositories

branches/Emisje/BazaReklam/Docs/versioninfo.html

branches/Emisje/BazaReklam/FacturesFormNew.Designer.cs

branches/Emisje/BazaReklam/FacturesFormNew.cs

branches/Emisje/BazaReklam/FacturesFormNew.resx

branches/Emisje/BazaReklam/MDIBazaReklam.cs

branches/Emisje/BazaReklam/Properties/AssemblyInfo.cs

branches/Emisje/BazaReklam/REKLAMADataSet.Designer.cs

branches/Emisje/BazaReklam/REKLAMADataSet.xsd

branches/Emisje/BazaReklam/REKLAMADataSet.xss

branches/Emisje/BazaReklam/ZestawienieZamowienForm.Designer.cs

branches/Emisje/BazaReklam/ZestawienieZamowienForm.cs

branches/Emisje/BazaReklam/ZestawienieZamowienForm.resx

branches/Emisje/BazaReklamSetup/BazaReklamSetup.vdproj

branches/Emisje/BazaZamowien

branches/Emisje/BazaZamowien_Instalka

branches/Emisje/BazaZamowien_Updater

branches/Emisje/SQL/StoredProcedures/sp_GetReklamy.txt

branches/Emisje/SQL/Views/VIEW_ZESTAWIENIE_ZAMOWIEN_NOWE.txt

branches/Emisje/SQL/Views/ZAMOWIENIA_NETTO_ZAFAKTUROWANE.txt

branches/Emisje/Wierszowki/Wierszowki.Web/Controllers/MagazineItemController.cs

branches/Emisje/Wierszowki/Wierszowki.Web/Controllers/ReportController.cs

branches/Emisje/Wierszowki/Wierszowki.Web/Global.asax.cs

branches/Emisje/Wierszowki/Wierszowki.Web/Views/MagazineItem/Confirm.aspx

branches/Emisje/Wierszowki/Wierszowki.Web/Views/MagazineItem/Create.aspx

branches/Emisje/Wierszowki/Wierszowki.Web/Views/MagazineItem/Edit.aspx

branches/Emisje/Wierszowki/Wierszowki.Web/Views/Report/All.aspx

branches/Emisje/Wierszowki/Wierszowki.Web/Views/Report/Index.aspx

Pobierz w innym formacie: