- Data:
- 2009-06-29 09:26:40 (17 years ago)
- Lokalizacja:
- branches/ReklamaReorganizacja
- Pliki:
-
- 8 zmodyfikowane
-
BazaReklam/Baza Reklam.csproj (zmodyfikowane) (2 diffs)
-
BazaReklam/Classes/Helpers/AdHelper.cs (zmodyfikowane) (4 diffs)
-
BazaReklam/Docs/versioninfo.html (zmodyfikowane) (1 diff)
-
BazaReklam/OrderDetails.cs (zmodyfikowane) (2 diffs)
-
BazaReklam/OrdersForm.cs (zmodyfikowane) (2 diffs)
-
BazaReklam/Properties/AssemblyInfo.cs (zmodyfikowane) (1 diff)
-
BazaReklamSetup/BazaReklamSetup.vdproj (zmodyfikowane) (2 diffs)
-
SQL/StoredProcedures/sp_GetReklamy.txt (zmodyfikowane) (2 diffs)
Legenda:
- Bez zmian
- Dodane
- Usunięte
-
branches/ReklamaReorganizacja/BazaReklam/Baza Reklam.csproj
r727 r729 33 33 <WebPage>index.htm</WebPage> 34 34 <OpenBrowserOnPublish>false</OpenBrowserOnPublish> 35 <ApplicationVersion>1.1.1 7.0</ApplicationVersion>35 <ApplicationVersion>1.1.18.0</ApplicationVersion> 36 36 <BootstrapperEnabled>false</BootstrapperEnabled> 37 37 </PropertyGroup> … … 707 707 <PublishFile Include="ADODB"> 708 708 <Visible>False</Visible> 709 <PublishState>Exclude</PublishState> 709 710 <Group> 710 711 </Group> 711 712 <TargetPath> 712 713 </TargetPath> 713 <PublishState>Exclude</PublishState>714 714 <FileType>Assembly</FileType> 715 715 </PublishFile> 716 716 <PublishFile Include="Microsoft.ReportViewer.Common"> 717 717 <Visible>False</Visible> 718 <PublishState>Include</PublishState> 718 719 <Group> 719 720 </Group> 720 721 <TargetPath> 721 722 </TargetPath> 722 <PublishState>Include</PublishState>723 723 <FileType>Assembly</FileType> 724 724 </PublishFile> 725 725 <PublishFile Include="Microsoft.ReportViewer.ProcessingObjectModel"> 726 726 <Visible>False</Visible> 727 <PublishState>Include</PublishState> 727 728 <Group> 728 729 </Group> 729 730 <TargetPath> 730 731 </TargetPath> 731 <PublishState>Include</PublishState>732 732 <FileType>Assembly</FileType> 733 733 </PublishFile> 734 734 <PublishFile Include="Microsoft.ReportViewer.WinForms"> 735 735 <Visible>False</Visible> 736 <PublishState>Include</PublishState> 736 737 <Group> 737 738 </Group> 738 739 <TargetPath> 739 740 </TargetPath> 740 <PublishState>Include</PublishState>741 741 <FileType>Assembly</FileType> 742 742 </PublishFile> -
branches/ReklamaReorganizacja/BazaReklam/Classes/Helpers/AdHelper.cs
r667 r729 35 35 height = Convert.ToInt32(((vertical - 1) * 3) + (vertical * 50.33)); 36 36 } 37 else if (module.Section.Name.ToUpper() == "MASTER TRUCK") 38 { 39 //max 2 x 4 40 width = ((horizontal - 1) * 3) + (horizontal * 105); 41 height = Convert.ToInt32(((vertical - 1) * 3) + (vertical * 72.5)); 42 } 37 43 else 38 44 { … … 44 50 else if (module.Section.Title.ShortName == "GS") 45 51 { 46 //max 3 x 4 47 width = ((horizontal - 1) * 3) + (horizontal * 67); 48 height = ((vertical - 1) * 3) + (vertical * 65); 52 if (module.Section.Name.ToUpper() == "AUTOSALON") 53 { 54 //max 2 x 4 55 width = ((horizontal - 1) * 3) + (horizontal * 105); 56 height = Convert.ToInt32(((vertical - 1) * 3) + (vertical * 72.5)); 57 } 58 else 59 { 60 //max 3 x 4 61 width = ((horizontal - 1)*3) + (horizontal*67); 62 height = ((vertical - 1)*3) + (vertical*65); 63 } 49 64 } 50 65 … … 77 92 case "ALAF": 78 93 case "AZOF": 94 case "SKRED": 79 95 return true; 80 96 } … … 94 110 case "GWEW_P": 95 111 case "GWEW": 112 case "SKRED": 96 113 //case "GART_S": 97 114 return true; -
branches/ReklamaReorganizacja/BazaReklam/Docs/versioninfo.html
r727 r729 6 6 <body> 7 7 <h1>Baza reklam - Informacje o wersji</h1> 8 <div> 9 <a id="1.1.18" /> 10 <h2>Wersja 1.1.18 (2009-06-28)</h2> 11 <p>Opis zmian wprowadzonych do wersji 1.1.18</p> 12 <ul> 13 <li>Dodano możliwość wybierania rozmiaru dla modułu SKRED</li> 14 <li>Poprawiono błąd występujący przy próbie wydruku zamówienia dla niektórych reklam</li> 15 </ul> 16 </div> 8 17 <div> 9 18 <a id="1.1.17" /> -
branches/ReklamaReorganizacja/BazaReklam/OrderDetails.cs
r727 r729 1781 1781 regex = "^[1-3]{1}$"; 1782 1782 } 1783 elseif (SelectedTitle.ShortName == "AMT" && SelectedSection != null && SelectedSection.Name.ToUpper() == "ZOOM")1783 if (SelectedTitle.ShortName == "AMT" && SelectedSection != null && SelectedSection.Name.ToUpper() == "ZOOM") 1784 1784 { 1785 1785 errorMessage = "Proszê podaæ wartoæ z przedzia³u 1-5."; 1786 1786 regex = "^[1-5]{1}$"; 1787 1787 } 1788 if (SelectedSection != null && (SelectedSection.Name.ToUpper() == "MASTER TRUCK" || SelectedSection.Name.ToUpper() == "AUTOSALON")) 1789 { 1790 errorMessage = "Proszê podaæ wartoæ z przedzia³u 1-2."; 1791 regex = "^[1-2]{1}$"; 1792 } 1793 1788 1794 1789 1795 if (ValidationHelper.IsTextBoxEmpty(txtHorizontal, … … 1813 1819 regex = "^[1-4]{1}$"; 1814 1820 } 1815 else if (SelectedTitle.ShortName == "AMT" && SelectedSection != null && 1816 SelectedSection.Name.ToUpper() == "ZOOM") 1821 if (SelectedTitle.ShortName == "AMT" && SelectedSection != null && SelectedSection.Name.ToUpper() == "ZOOM") 1817 1822 { 1818 1823 errorMessage = "Proszê podaæ wartoæ z przedzia³u 1-6."; 1819 1824 regex = "^[1-6]{1}$"; 1825 } 1826 if (SelectedSection != null && (SelectedSection.Name.ToUpper() == "MASTER TRUCK" || SelectedSection.Name.ToUpper() == "AUTOSALON")) 1827 { 1828 errorMessage = "Proszê podaæ wartoæ z przedzia³u 1-4."; 1829 regex = "^[1-4]{1}$"; 1820 1830 } 1821 1831 -
branches/ReklamaReorganizacja/BazaReklam/OrdersForm.cs
r727 r729 27 27 " LEFT JOIN dbo.VIEW_REKLAMA_OD_DO O ON R.ReklamaID = O.ReklamaId" + 28 28 " LEFT JOIN NR ON R.TYTU£ = NR.TYT AND O.OD = NR.NRW " + 29 " LEFT OUTER JOIN [NAZWY MODU£ÓW] NM ON r.MOD_TYP = NM.MOD_TYP " +29 " LEFT OUTER JOIN [NAZWY MODU£ÓW] NM ON r.MOD_TYP = NM.MOD_TYP AND r.[Tytu³] = NM.Tytul" + 30 30 " LEFT OUTER JOIN dbo.KLIENCI AS K ON R.customerId=K.CustomerId " + 31 31 " LEFT OUTER JOIN dbo.Zamowienia AS Z ON R.idZamowienia=Z.idZamowienia "; … … 654 654 if (!string.IsNullOrEmpty(cbPromocje.Text.Trim())) 655 655 { 656 command.Parameters.AddWithValue("@promocja", Convert.ToInt32(((DataRow)cbPromocje.SelectedItem)["Id"])); 657 } 658 659 if (((CheckBox)((ToolStripControlHost)szukajToolStrip.Items["DRCheckBox"]).Control).CheckState == CheckState.Checked) 656 command.Parameters.AddWithValue("@promocja", Convert.ToInt32(((DataRow) cbPromocje.SelectedItem)["Id"])); 657 } 658 659 if (((CheckBox) ((ToolStripControlHost) szukajToolStrip.Items["DRCheckBox"]).Control).CheckState == 660 CheckState.Checked) 660 661 { 661 662 command.Parameters.AddWithValue("@zd", true); 662 663 } 663 else if (((CheckBox)((ToolStripControlHost)szukajToolStrip.Items["DRCheckBox"]).Control).CheckState == CheckState.Unchecked) 664 else if (((CheckBox) ((ToolStripControlHost) szukajToolStrip.Items["DRCheckBox"]).Control).CheckState == 665 CheckState.Unchecked) 664 666 { 665 667 command.Parameters.AddWithValue("@zd", false); 666 668 } 667 669 668 if (((CheckBox)((ToolStripControlHost)szukajToolStrip.Items["FWCheckBox"]).Control).CheckState == CheckState.Checked) 670 if (((CheckBox) ((ToolStripControlHost) szukajToolStrip.Items["FWCheckBox"]).Control).CheckState == 671 CheckState.Checked) 669 672 { 670 673 command.Parameters.AddWithValue("@fw", true); 671 674 } 672 else if (((CheckBox)((ToolStripControlHost)szukajToolStrip.Items["FWCheckBox"]).Control).CheckState == CheckState.Unchecked) 675 else if (((CheckBox) ((ToolStripControlHost) szukajToolStrip.Items["FWCheckBox"]).Control).CheckState == 676 CheckState.Unchecked) 673 677 { 674 678 command.Parameters.AddWithValue("@fw", false); 675 679 } 676 680 677 if (((CheckBox)((ToolStripControlHost)szukajToolStrip.Items["KZCheckBox"]).Control).CheckState == CheckState.Checked) 681 if (((CheckBox) ((ToolStripControlHost) szukajToolStrip.Items["KZCheckBox"]).Control).CheckState == 682 CheckState.Checked) 678 683 { 679 684 command.Parameters.AddWithValue("@kz", true); 680 685 } 681 else if (((CheckBox)((ToolStripControlHost)szukajToolStrip.Items["KZCheckBox"]).Control).CheckState == CheckState.Unchecked) 686 else if (((CheckBox) ((ToolStripControlHost) szukajToolStrip.Items["KZCheckBox"]).Control).CheckState == 687 CheckState.Unchecked) 682 688 { 683 689 command.Parameters.AddWithValue("@kz", false); 684 690 } 685 691 686 if (((CheckBox)((ToolStripControlHost)szukajToolStrip.Items["WyrCheckBox"]).Control).CheckState == CheckState.Checked) 692 if (((CheckBox) ((ToolStripControlHost) szukajToolStrip.Items["WyrCheckBox"]).Control).CheckState == 693 CheckState.Checked) 687 694 { 688 695 command.Parameters.AddWithValue("@wy", true); 689 696 } 690 else if (((CheckBox)((ToolStripControlHost)szukajToolStrip.Items["WyrCheckBox"]).Control).CheckState == CheckState.Unchecked) 697 else if (((CheckBox) ((ToolStripControlHost) szukajToolStrip.Items["WyrCheckBox"]).Control).CheckState == 698 CheckState.Unchecked) 691 699 { 692 700 command.Parameters.AddWithValue("@wy", false); 693 701 } 694 702 695 if (((CheckBox)((ToolStripControlHost)szukajToolStrip.Items["BZCheckBox"]).Control).CheckState == CheckState.Checked) 703 if (((CheckBox) ((ToolStripControlHost) szukajToolStrip.Items["BZCheckBox"]).Control).CheckState == 704 CheckState.Checked) 696 705 { 697 706 command.Parameters.AddWithValue("@bz", true); 698 707 } 699 else if (((CheckBox)((ToolStripControlHost)szukajToolStrip.Items["BZCheckBox"]).Control).CheckState == CheckState.Unchecked) 708 else if (((CheckBox) ((ToolStripControlHost) szukajToolStrip.Items["BZCheckBox"]).Control).CheckState == 709 CheckState.Unchecked) 700 710 { 701 711 command.Parameters.AddWithValue("@bz", false); 702 712 } 703 713 704 705 sqlDataAdapter.SelectCommand = command; 706 707 Cursor = Cursors.WaitCursor; 708 709 sqlDataAdapter.Fill(rEKLAMADataSet.ReklamyZestawienie); 710 commandExecuted = true; 711 712 reklamaDataGridView.Refresh(); 713 714 treeView1.CollapseAll(); 715 treeView1.SelectedNode = null; 716 717 Cursor = Cursors.Default; 718 714 try 715 { 716 Cursor = Cursors.WaitCursor; 717 718 sqlDataAdapter.SelectCommand = command; 719 720 sqlDataAdapter.Fill(rEKLAMADataSet.ReklamyZestawienie); 721 commandExecuted = true; 722 723 reklamaDataGridView.Refresh(); 724 725 treeView1.CollapseAll(); 726 treeView1.SelectedNode = null; 727 } 728 catch (Exception ex) 729 { 730 Logger.LogException(ex, User.Instance().Login, DateTime.Now); 731 } 732 finally 733 { 734 Cursor = Cursors.Default; 735 } 719 736 } 720 737 -
branches/ReklamaReorganizacja/BazaReklam/Properties/AssemblyInfo.cs
r727 r729 30 30 // 31 31 [assembly: AssemblyVersion("1.0.0.0")] 32 [assembly: AssemblyFileVersion("1.1.1 7")]32 [assembly: AssemblyFileVersion("1.1.18")] -
branches/ReklamaReorganizacja/BazaReklamSetup/BazaReklamSetup.vdproj
r727 r729 656 656 "Name" = "8:Microsoft Visual Studio" 657 657 "ProductName" = "8:Baza Reklam" 658 "ProductCode" = "8:{ 8E37353C-705C-4A53-84DD-2C51D950C5F3}"659 "PackageCode" = "8:{ 12C341A7-5AA0-4246-9FC7-AB32834CE6FC}"658 "ProductCode" = "8:{4C5277D5-4413-4B14-8B5D-DB25AD935FCC}" 659 "PackageCode" = "8:{2BB65BFA-D87B-4904-87AD-35F12B9CB27A}" 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.1 7"665 "ProductVersion" = "8:1.1.18" 666 666 "Manufacturer" = "8:AACT" 667 667 "ARPHELPTELEPHONE" = "8:" -
branches/ReklamaReorganizacja/SQL/StoredProcedures/sp_GetReklamy.txt
r339 r729 52 52 LEFT JOIN dbo.VIEW_REKLAMA_OD_DO_DATY O ON R.ReklamaID = O.ReklamaId 53 53 LEFT JOIN NR ON R.TYTU£ = NR.TYT AND O.wyd_od = NR.NRW -- OR O.wyd_do = NR.NRW) 54 LEFT OUTER JOIN [NAZWY MODU£ÓW] NM ON r.MOD_TYP = NM.MOD_TYP 54 LEFT OUTER JOIN [NAZWY MODU£ÓW] NM ON r.MOD_TYP = NM.MOD_TYP AND r.[Tytu³] = NM.Tytul 55 55 LEFT OUTER JOIN dbo.KLIENCI AS K ON R.customerId=K.CustomerId 56 56 LEFT OUTER JOIN dbo.Zamowienia AS Z ON R.idZamowienia=Z.idZamowienia … … 114 114 115 115 116 --print @query116 print @query 117 117 118 118
