Zbiór zmian 339

Pokaż
Ignoruj:
Data:
2009-02-11 16:32:30 (17 years ago)
Autor:
marek
Opis:

fixes #89

Lokalizacja:
trunk
Pliki:
5 zmodyfikowane

Legenda:

Bez zmian
Dodane
Usunięte

  • trunk/BazaReklam/Classes/DBBindings.cs

    r73 r339  
    11using System; 
    2 using System.Collections.Generic; 
    3 using System.Text; 
    42using System.Data; 
    53using System.Data.SqlClient; 
    … …  
    424422        } 
    425423 
     424        public static void BindujPromocje(ComboBox comboBox, DataTable dt) 
     425        { 
     426            comboBox.Items.Add(string.Empty); 
     427            comboBox.DisplayMember = "Nazwa"; 
     428            comboBox.ValueMember = "Id"; 
     429 
     430            foreach(DataRow row in dt.Rows) 
     431            { 
     432                comboBox.Items.Add(row); 
     433            } 
     434             
     435            //comboBox.DataSource = dt; 
     436            //comboBox.DisplayMember = "Nazwa"; 
     437            //comboBox.ValueMember = "Id"; 
     438            //comboBox.Items.Insert(0, string.Empty); 
     439 
     440        } 
     441 
    426442    } 
    427443} 

  • trunk/BazaReklam/OrdersForm.Designer.cs

    r306 r339  
    127127            this.reklamaTableAdapter = new Baza_Reklam.REKLAMADataSetTableAdapters.REKLAMATableAdapter(); 
    128128            this.kLIENCITableAdapter = new Baza_Reklam.REKLAMADataSetTableAdapters.KLIENCITableAdapter(); 
     129            this.pROMOCJEBindingSource = new System.Windows.Forms.BindingSource(this.components); 
     130            this.pROMOCJETableAdapter = new Baza_Reklam.SLOWNIKDataSetTableAdapters.PROMOCJETableAdapter(); 
     131            this.toolStripLabel7 = new System.Windows.Forms.ToolStripLabel(); 
     132            this.cbPromocje = new System.Windows.Forms.ToolStripComboBox(); 
    129133            ((System.ComponentModel.ISupportInitialize)(this.bindingNavigator1)).BeginInit(); 
    130134            this.bindingNavigator1.SuspendLayout(); 
    … …  
    141145            ((System.ComponentModel.ISupportInitialize)(this.fAKTURYBindingSource)).BeginInit(); 
    142146            ((System.ComponentModel.ISupportInitialize)(this.kLIENCIBindingSource)).BeginInit(); 
     147            ((System.ComponentModel.ISupportInitialize)(this.pROMOCJEBindingSource)).BeginInit(); 
    143148            this.SuspendLayout(); 
    144149            //  
    … …  
    425430            this.toolStripLabel5, 
    426431            this.typToolStripComboBox, 
     432            this.toolStripLabel7, 
     433            this.cbPromocje, 
    427434            this.szukajToolStripButton, 
    428435            this.wyczyscPolaToolStripButton}); 
    … …  
    9981005            this.kLIENCITableAdapter.ClearBeforeFill = true; 
    9991006            //  
     1007            // pROMOCJEBindingSource 
     1008            //  
     1009            this.pROMOCJEBindingSource.DataMember = "PROMOCJE"; 
     1010            this.pROMOCJEBindingSource.DataSource = this.sLOWNIKDataSet; 
     1011            //  
     1012            // pROMOCJETableAdapter 
     1013            //  
     1014            this.pROMOCJETableAdapter.ClearBeforeFill = true; 
     1015            //  
     1016            // toolStripLabel7 
     1017            //  
     1018            this.toolStripLabel7.Name = "toolStripLabel7"; 
     1019            this.toolStripLabel7.Size = new System.Drawing.Size(55, 22); 
     1020            this.toolStripLabel7.Text = "promocja:"; 
     1021            //  
     1022            // cbPromocje 
     1023            //  
     1024            this.cbPromocje.Name = "cbPromocje"; 
     1025            this.cbPromocje.Size = new System.Drawing.Size(121, 25); 
     1026            //  
    10001027            // OrdersForm 
    10011028            //  
    … …  
    10321059            ((System.ComponentModel.ISupportInitialize)(this.fAKTURYBindingSource)).EndInit(); 
    10331060            ((System.ComponentModel.ISupportInitialize)(this.kLIENCIBindingSource)).EndInit(); 
     1061            ((System.ComponentModel.ISupportInitialize)(this.pROMOCJEBindingSource)).EndInit(); 
    10341062            this.ResumeLayout(false); 
    10351063            this.PerformLayout(); 
    … …  
    11261154        private System.Windows.Forms.ToolStripSeparator toolStripSeparator1; 
    11271155        private System.Windows.Forms.ToolStripButton zamowieniaToolStripButton; 
     1156        private System.Windows.Forms.BindingSource pROMOCJEBindingSource; 
     1157        private Baza_Reklam.SLOWNIKDataSetTableAdapters.PROMOCJETableAdapter pROMOCJETableAdapter; 
     1158        private System.Windows.Forms.ToolStripLabel toolStripLabel7; 
     1159        private System.Windows.Forms.ToolStripComboBox cbPromocje; 
    11281160 
    11291161    } 

  • trunk/BazaReklam/OrdersForm.cs

    r313 r339  
    4949            kONTATableAdapter.Connection.ConnectionString = ConnString.getConnString().Value; 
    5050            kLIENCITableAdapter.Connection.ConnectionString = ConnString.getConnString().Value; 
     51            pROMOCJETableAdapter.Connection.ConnectionString = ConnString.getConnString().Value; 
    5152                        
    5253            SqlConnection conn = new SqlConnection(ConnString.getConnString().Value); 
    … …  
    6970        private void OrdersForm_Load(object sender, EventArgs e) 
    7071        { 
    71             kONTATableAdapter.FillByIdAgencji(sLOWNIKDataSet.KONTA,User.getUser().IdAgencji); 
     72            pROMOCJETableAdapter.Fill(sLOWNIKDataSet.PROMOCJE); 
     73            kONTATableAdapter.FillByIdAgencji(sLOWNIKDataSet.KONTA, User.getUser().IdAgencji); 
    7274            WindowState = FormWindowState.Maximized; 
    7375 
     76             
    7477            DBBindings.bindujAgencje(agencjaToolStripComboBox); 
    7578            DBBindings.bindujAgentow(agentToolStripComboBox); 
    7679            DBBindings.bindujTytuly(tytToolStripComboBox); 
    7780            DBBindings.bindujTypyReklam(typToolStripComboBox); 
     81            DBBindings.BindujPromocje((ComboBox)cbPromocje.Control, sLOWNIKDataSet.PROMOCJE); 
    7882        } 
    7983 
    … …  
    8286            ToolStripLabel toolStripLabel = new ToolStripLabel("DR"); 
    8387            toolStripLabel.ToolTipText = "Zatwierdzone do druku"; 
    84             toolStrip.Items.Insert(13, toolStripLabel); 
    85             toolStrip.Items.Insert(14, new ToolStripControlHost(new CheckBox(), "DRCheckBox")); 
     88            toolStrip.Items.Insert(15, toolStripLabel); 
     89            toolStrip.Items.Insert(16, new ToolStripControlHost(new CheckBox(), "DRCheckBox")); 
    8690 
    8791            toolStripLabel = new ToolStripLabel("FW"); 
    8892            toolStripLabel.ToolTipText = "Wystawiona faktura"; 
    89             toolStrip.Items.Insert(15, toolStripLabel); 
    90             toolStrip.Items.Insert(16, new ToolStripControlHost(new CheckBox(), "FWCheckBox")); 
     93            toolStrip.Items.Insert(17, toolStripLabel); 
     94            toolStrip.Items.Insert(18, new ToolStripControlHost(new CheckBox(), "FWCheckBox")); 
    9195 
    9296            toolStripLabel = new ToolStripLabel("KZ"); 
    9397            toolStripLabel.ToolTipText = "Kierownik zatwierdzi³"; 
    94             toolStrip.Items.Insert(17, toolStripLabel); 
    95             toolStrip.Items.Insert(18, new ToolStripControlHost(new CheckBox(), "KZCheckBox")); 
     98            toolStrip.Items.Insert(19, toolStripLabel); 
     99            toolStrip.Items.Insert(20, new ToolStripControlHost(new CheckBox(), "KZCheckBox")); 
    96100 
    97101            toolStripLabel = new ToolStripLabel("WYR"); 
    98102            toolStripLabel.ToolTipText = "Wyró¿nienie"; 
    99             toolStrip.Items.Insert(19, toolStripLabel); 
    100             toolStrip.Items.Insert(20, new ToolStripControlHost(new CheckBox(), "WyrCheckBox")); 
     103            toolStrip.Items.Insert(21, toolStripLabel); 
     104            toolStrip.Items.Insert(22, new ToolStripControlHost(new CheckBox(), "WyrCheckBox")); 
    101105 
    102106            toolStripLabel = new ToolStripLabel("BZ"); 
    103107            toolStripLabel.ToolTipText = "Bez zamówienia"; 
    104             toolStrip.Items.Insert(21, toolStripLabel); 
    105             toolStrip.Items.Insert(22, new ToolStripControlHost(new CheckBox(), "BZCheckBox")); 
     108            toolStrip.Items.Insert(23, toolStripLabel); 
     109            toolStrip.Items.Insert(24, new ToolStripControlHost(new CheckBox(), "BZCheckBox")); 
    106110 
    107111            ((CheckBox)((ToolStripControlHost)toolStrip.Items["DRCheckBox"]).Control).ThreeState = true; //Zatwierdzone do druku 
    … …  
    631635            { 
    632636                command.Parameters.AddWithValue("@typ", typToolStripComboBox.Text.Trim()); 
     637            } 
     638 
     639            if (!string.IsNullOrEmpty(cbPromocje.Text.Trim())) 
     640            { 
     641                command.Parameters.AddWithValue("@promocja", Convert.ToInt32(((DataRow)cbPromocje.SelectedItem)["Id"])); 
    633642            } 
    634643 

  • trunk/BazaReklam/OrdersForm.resx

    r306 r339  
    383383    <value> 
    384384        iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8 
    385         YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAABelJREFUSEuVlWlQ 
    386         U1cYhk8MiytYsKjVNhWpUobBrTjSjsPYYqtowhKwsiiKICgKQUDAAoIGBUGLioiAW0UWBZFWEVGsUpSC 
    387         4II7BVmU0bApVBGE5O13r7T1hxtn5pmTnLl5vvd8N+deAevH+D5/rI7GS7VlAqhbag3UHtej6lU2t7ZV 
    388         vWjqzqs9+ixTUfK8jXRKAv3Qvrp0UYWhrUuxWfPOem/k/B2D7PYtyGqPQmZrJDbcWoLZB8fVTJQNF9Ol 
    389         w4gB/SrgdNXY2f+6US8nzngiR2pTOA4qwnDgUShPqmI9EQ6rtMkdY6yHOJNchxC8tch6xtQILoXAtuwL 
    390         fc+LZs+OdcTgcEsEDj4Ow/5HIdjXuA4pD4KR3BBEBCKlIRgHGkMwY7eoRjiEfdu3k/9rtBgwrS4DFto5 
    391         RfNmo8XolzdnaXXWjmCXl20Z+UdKawjSWjfwaV+Jg5BUvxaJdQHYfd8PCRw1frQWiLWX7KE3Z+B2MhsS 
    392         anyFLkM2odtU+FdvuCVwwBNIdgcSXYE4N3gVTEPycQvso+R7SZ5EaRNr/Um4BvHVvthZJcOOKh9sv+dD 
    393         swxJtWsxxntwEWmtCG3GJ58urEbiUiCB2OYIRC8EIhdCFWGHjTdnQ6nwRFSGGZJoB7vv+2MXL/bBtrur 
    394         EXtnFbbc9kL0rZWIpjm+2g8m0WPqSe5DfMIaRSy8N2wuEL+ExA6AfAGw3g4IsUVPoDXCKqYDbQtw9fxU 
    395         xJQ4YVeNP+LueSOGZJtvroC80hMR1z2I5fwce1cGQ7neA5KHE+PYA2PhbSRRS6IodYQ9L8ZaK8BPAnhJ 
    396         IDurDzyeCNTqYFPGFCQ3emF7tSc23fJEeOVyhFx1Q3CFK4IIbt54eyVGuGmWkjyC0Ge1Ir0e7Fj8Sr7O 
    397         BvCXQOUjBlZbotdjPibJQmEWnIOZEVUYsaocI2UXMDk8AcFlyxFW6QL/y0vgW7oYMsK/fCkW5c+Hpqkw 
    398         neR+xFhWP0n7BWKdgZ8oOaVWeouh8rJEkZsLtN1LsW5fHaKvXgM6WyE7fQnJUGJ1pQJa7sWwSffDmgoH 
    399         rLjoiBXFTvClAqJg3WaBkO0luR1/Hv4czUqx2RGqACsoKXm31zxUuv0IXe8bKDrfjsKTCvhllmNrcSmc 
    400         z5QjtqMdkS0KyFsaoed1CdJsD7hfWgD3kkUQ/SzqURMJfulrjwnNGmz/cObdZDcVCLRB1ypK72mB8c5Z 
    401         OFHwBPmnFMg5Vo+TR+vgEF8I87xiBNbVYeOjhwhrqEXQ/WpoOWXDrmAmRq/XfaqmLzhE0m3EXGI4f5rH 
    402         0jaOaLPiZ67foUdmjfJlDjCLqMG5/Mc4ntOA3Ow6xCWUQbr1ChwLezE59RoMU8/DJPMsTI6cgY7fBajP 
    403         Mjoj0GAHSRhJWBIjif+eR2rfqLNJaUPZuayZ41WRDv4I3FOH/Nx6pB6+gzXyQsyLLYfzBWDhWcD+DCAt 
    404         AGxOA3b0/YeMTjCRYyYJ1xFmfN8ZE/In+LUxkD6b2A1gYdOMnMtt5CVYGnUe0rgKOOS2w4HknFCcR5zs 
    405         hfhED8S/vYTklBJzcl6AGXjk0O9diVF8W94wuEWuyOdsRmSYNLMDvmWAaxGlLgSs8vvEv3ZDfPwFxMc6 
    406         ieewyu2C+b4msM/sub+lC/Hxm+SvrwmZWYTpl/N/V64uARypBTb5qlepScZJxUc7IM58ymOb8xwTAvao 
    407         2DCDZJIs6GvP+2owTWaVd8qpoIdPL85TQswl5+RH2iFOb4P4cAs9+1thld4KZhpXScZ4wpwY/F4730Nj 
    408         2VcaTgVNUtqBNfVewqXnkqe1QZLaBOtDTbBJVWCQRVoH0xjJ/Xu4U6tPfPCbbBCb4GwtlGTUmMY/hF1e 
    409         L6S5nZBmPYU0owVm8htQM09sZENEnHwTMZMY+iHp/72Gu+naTFN3FjNwimdfx5YNk2Q3aVkfaWam8its 
    410         lEUGE2ik0DWhBPf2evcr8i2VuSJcKiPCtq8Ncpq5wxRA2BPGfJB+tOZNtdRp8SOCDj0b38enfak1+Hv2 
    411         jvEPApigoZ/DeeQAAAAASUVORK5CYII= 
     385        YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAABehJREFUSEuVlWlQ 
     386        U1cYhk8aBFewYEWrbSpSpY6DW3GkHYexxVbRsAWoQBRFEBSFaEDAsmpQELSoiBTcqMgqIq0igli1CAVB 
     387        FHcLsiijYVOoggjh7XcvtPWHG2fmmZOcuXm+93w3514BG8D4Lne8tvpLtZUCDDLTHKw1obu3R9XU0nqv 
     388        s7ErpybjWZqy+Hkr6VQEBqDtu3RpuYG1U6Fx0546T2T9HYnMtu041haOtJYwbL65HPMTJ1RPlo0U06Uj 
     389        iA8GVMCxYqrU+9qUHk6c+kSBpMYQJCqDcPhRIE+SMpgIgUXy9PZxlsOkJNcmBG8sEsyYGsGlEFiXfq7n 
     390        fsn42fH2SBxtDkXi4yAcehSAgw2bsP+BPxLq/Qhf7K/3x+GGAMzZJ6oWDmPf9O/k/xrN+kzzhT4L7Jih 
     391        caPBdOzLG/M0O2pGscsrt+v+sb8lAMktm/m0fWI/xNdtRFytD/bdlyOWo1pOa77YWGSL0QsG7yKzAaHG 
     392        V3hhwCZ1GQn/6gkxAw67AwmuQJwzEO0Cj7xZSDhhioOU/ADJ4yltXI03CTcgpmo99tyTYfc9L+y660Wz 
     393        DPE1GzHOc+hF0loQWoxPPltYhbgVQCyx0wGIWAKELUFvqA223JgPldId4anGiKcd7Lvvjb282As776xD 
     394        1O212H7LAxE31yCC5pgqOQwjxtWR3Iv4mDWIWEhP0EIgZjmJ7QGFHRBsAwRYo9vXEkHls4FWO1Scn4nI 
     395        YkfsrfZG9F1PRJJs243VUFS6I/SaG7GKn6PuyGCgGP2A5CHEBPZgqvAW4qkl4ZQ61JYXY6MFIDcHPMwh 
     396        O6sHPJ4M1Ghja+oMJDR4YFeVO7bedEdI5SoEVLjAv9wZfgQ3b7m1BqNcNEpIHkrosRrR6G7sXtYn32QF 
     397        eJuj10sMrDNDj9tiTJMFwtg/C3ND72HU2jLoyi5gekgs/EtXIajSCd6Xl2N9yTLICO+yFViauxgaRsIU 
     398        ksuJ8axumlYnoqTAj5ScUqs8xej1MMNFFydouZZg08FaRFRcBTpaIDtThASosK5SCU3XQlilyLGh3B6r 
     399        LzlgdaEj1lMBkb9Ok0DIDpDchj8Pf45lJdjmgF4fC6goeZfHIlS6/AAdz+u4eL4NBaeUkKeVYUdhCaT5 
     400        ZYhqb0NYsxKK5gaM9iiCJNMNrkV2cC1eCtFPom41keCX/vYY0qzODo1kno02MwFfK7xYS+ndTTFRegwn 
     401        854g97QSWcfrcCqjFvYxBTDJKYRvbS22PHqIoPoa+N2vgqZjJmzy5mJssM5TNT3BEZLuJBYSI/nTPJ62 
     402        ka7FCp85f4tumSXKVtrDOLQa53If40RWPbIzaxEdWwrJjitwKOjB9KSrMEg6D8O0szBMz4e2/AIGzZuS 
     403        L1BniSQMI8wIXeK/55Ha14PYtOTh7FzG3Im9Yfbe8P25FrnZdUg6ehsbFAVYFFUG6QVgyVnANh+Q5AFW 
     404        ZwAb+v59ageYyCGNhJsIY77vjAn5E/zKGEyfDW0+YEGzpkjLrBTFWBF+HpLocthnt8Ge5JxQnEOc6oH4 
     405        ZDfEv72E+WkVFmR1gum7ZdHvnYkxfFteM7hFrshnbE5YkCStHetLAeeLlLoAsMjtF//aBfGJToiPdxDP 
     406        YZH9AiYHG8E+teX+lk7ER6+Tv7omZMahRl8s+l21rhhwoBZY5fb2pSYZJxVntEOc9pTHOus5JvnE9bIR 
     407        +gkksetvz7tqMA1mkXPaMa+bTy/OUUHMJefk6W0Qp7RCfLSZnv0tsEhpATOKriRjDGFCDH2nne/hVNmX 
     408        6o55jRLagSX13pxLzyVPboV5UiMsjzTCKkmJIabJ7Uxdl/v3cKdWj3jvN9kQNklqKTRPrTaKeQibnB5I 
     409        sjsgOfYUktRmGCuuQ80kroENE3HyrcRcYvj7pP/3Gu6mazENnXlM3zGGfRVVOsI8s1HTMr2JGSmusDGm 
     410        qUygvp+uCSS4t9fbX5FvqMwV4VJNIaz726CgmTtMPoQtMZUPMoDWvK7WIFr8kKBDzyb280l/anX+nr1l 
     411        /AP516CeZgQwTAAAAABJRU5ErkJggg== 
    412412</value> 
    413413  </data> 
    … …  
    505505    <value> 
    506506        iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8 
    507         YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAABYtJREFUSEuVlXtM 
    508         U2cYxsvmJkaWuYFjEZJlW3QyNGbRjUGW6R/EES6KDqaIDnVbxkUdKAoqchG5RHHcjKAGBnIVBLkVcKW0 
    509         wCAdggwRVstNoC20tJYiIMjk2fudNZuJiuMkv5zTnp7ned73+/oeI96LD6N57mGee8+/lZeXt/3cudhD 
    510         MTExoVFnTp+PDA9POxMZURgdGf1r3Pk4SWJysjQpKamNnrYgFi/YID09vVY+osGQ+gHkukkoJ+agnAaG 
    511         ZoCeR4CMrsPCIudWr14dQOLvEa8syCQxMTFKodVj/C9ATWLKSWDgIQmPAZ0PgA4dIOgYhMPmzb+QsB1h 
    512         vCCDiIiIrY232qF7/I/40ATQPw506wEpmdwlgw76fPigTxMJ7yRMF2Tg4uJifr2k7PEoGSjIgNGieoIK 
    513         2QzS/5jE2UY9TtSOYWv8b4+sjhZdXxVU5ncu4pTNhfj4L/ft27eczBYR820M3iJqU+voHHBbAwQKphEs 
    514         eIgI0UP4V+nxE38MhyrGcID4sVQLx0wl9qQ0orVRjJycnMmQkJB4U1PTFWTy2nMra2pqss/MzJTdrBGh 
    515         6mYNKsQSXKgfxkG+DinN0zhBZocryaD8AbzJ4PsSLWxTBnG1oRcqxSDq6upw5MgRPomvemaXtba2uohE 
    516         ohniycTEBLSaUQwr5NAo7qO89T5cc5Q43ziFgEodfMu0+OHGKLyuq7C7UIWPY6Xok97BvXv3UF5eAVdX 
    517         13gy+MDQMh6P2rK4urp6aHZ2FuPj49BqtRgdHcXAwACkUikGuv9Eao0UO6+NIFSop/Qa7C9WY0/hCDwL 
    518         RrAhuR8XKtpRnHMJwuoSBAcHa42Njf/bBFlZWd90dXVhamoKOp0OGo0GIyMjGB4eRmdnJ9ra2iC70wr3 
    519         9C4cv6kjg1HspfSeZOier4RTphxbku+iOe1bzFZsR0Z2IdauXZtEFazhqkhNTU1jqfV6PSeuVqs58aGh 
    520         IfT29kIikeDW7xII6iSwuziAwGotdlPyHSTulqPAVmrfmtPtkFRlY7p8P2rETdi0aVMliTsTb/IuX758 
    521         i/WdtUWlUnHicrmcaxGDFh8NDQ1obaqHR+pteJeosYvS77imxNe5Smy8MohPIprRKBZCUNsAkbgOHh4e 
    522         HSTuTbzLy87OVo6NjXFtUSqVnPjg4CD6+/vR19eH5uZmCIVCiIQ1KK+uxYcxvfjikhzrEvqx/JQMn5N4 
    523         lUCI6ko+SAtisRh+fn4qEj/JjZSUlBQdS89ao1AouNRMnLWnu7sbLS0tqKqq4hBUV+LqDQFCMupwNq8O 
    524         5RV8ZKVdxInjQXB0dIS9vT0CAwPh7OwsIfFw4n1eUFBQaFxcHAoKCtDT08NVwJLLZDJu67W3t6O0tBRl 
    525         ZWWopJQsafqVSwg9eRyuW7fAxsYGK1euhLW1NRwcHFh6mJiYZJD4AWIFz9/f3z43Nxd8Ph+xsbGgijhR 
    526         ZsK2KbsuLi7mDJKTk+Hu7g5bW1vQVIWVlRVbUHh5eXHJfXx8+tevX3/NyMjoZxLfSCzlmZubL/X29j5K 
    527         74H7TIgRFhaG6Oho1NfXc1UUFRWxccD+RJwwS00LiWPHjsHX13fGzc1NZGFhwaZsKhFGuHILbBjpbK6b 
    528         L1myZIuTk1MqGanz8/NBLyBQ+0AzBgEBAVzpJMTGAaKiopjwABkV0HPp9DxLfJDYTHxEvP3vP5ku2MEm 
    529         4VuE9bJlyzy3bduWQUZ6mk2smjlGQkICu37s6ekptrS0zKA2XDEs5C46f0pYEibEqwbNZ05s1LJJaEas 
    530         MzMz+46MCsLDw/W0Tj12dnaFhrRs1hwivjKkZb9nr9B5R/XTbuyHr7O2ERuIvYakbF+ztJ8Z0r5hqPxF 
    531         gV/6PTNiyd4h2HRk7+EFp32pi6F0Zva/W/C06N81ZdWc/X/JBwAAAABJRU5ErkJggg== 
     507        YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAABYxJREFUSEuVlXtM 
     508        U2cYxsvmJkaWuYFjEZJlW3QyNGbRjUGW6R/EES6CDqaIDnVbxkUdKAoqclG5RHHcjKAGBnIVBLkV6kpp 
     509        gUE6pDJEWC03ubRASy1FQJDJs/c7azYTFcdJfjmnPT3P87zv9/U9RrwXH0bz3MM8955/Ky8vb9u5c7EH 
     510        Y2JiwqLOnDp/OiIi7czpyMLo09G/xp2PkyYmJ8uTkpJa6GkLYvGCDdLT02sGh0cxoH6AQd0kVBNzUE0D 
     511        AzNA1yNAQdfh4afmVq9eHUji7xGvLMgkMTExSqnVY/wvQE1iqkmg7yEJjwHtD4A2HSBs64fD5s2/kLAd 
     512        Ybwgg8jISNeGW63QPf5HfGAC6B0HOvWAnEzukkEbfT50wLeRhHcQpgsycHFxMb9eUvZYQwZKMmA0jzxB 
     513        hWIG6X9M4myDHsdrxuAa/9sjqyNF11cFl/mfizxpcyE+/su9e/cuJ7NFxHwbg7eI2iTTzAG3R4Eg4TRC 
     514        hA8RKX6IgCo9fuKP4WDFGPYTP5Zq4Zipwu6UBsgaJMjJyZkMDQ2NNzU1XUEmrz23ssbGRvvMzEzFzWox 
     515        qm5Wo0IixYW6IRzg65DSNI3jZHaokgzKH8CHDL4v0cI2pR9X67sxouxHbW0tDh8+zCfxVc/sMplM5iIW 
     516        i2eIJxMTE9COajCkHMSo8j7KZffhlqPC+YYpBFbq4FemxQ83NPC+PoJdhSP4OFaOHvkd3Lt3D+XlFXBz 
     517        c4sngw8MLePxqC2LBQLBwOzsLMbHx6HVaqHRaNDX1we5XI6+zj+RWi3HjmvDCBPpKf0o9hWrsbtwGF4F 
     518        w9iQ3IsLFa0ozrkEkaAEISEhWmNj4/82QVZW1jcdHR2YmpqCTqfD6OgohoeHMTQ0hPb2drS0tEBxRwaP 
     519        9A4cu6kjAw32UHovMvTIV8EpcxBbku+iKe1bzFZsQ0Z2IdauXZtEFazhqkhNTU1jqfV6PSeuVqs58YGB 
     520        AXR3d0MqleLW71IIa6Wwu9iHIIEWuyj5dhJ3z1HCldq35lQrpFXZmC7fh2pJIzZt2lRJ4s7Em7zLly/f 
     521        Yn1nbRkZGeHEBwcHuRYxaPFRX18PWWMdPFNvw6dEjZ2Ufvs1Fb7OVWHjlX58EtmEBokIwpp6iCW18PT0 
     522        bCNxH+JdXnZ2tmpsbIxri0ql4sT7+/vR29uLnp4eNDU1QSQSQSyqRrmgBh/GdOOLS4NYl9CL5ScV+JzE 
     523        q4QiCCr5IC1IJBL4+/uPkPgJbqSkpKToWHrWGqVSyaVm4qw9nZ2daG5uRlVVFYdQUImrN4QIzajF2bxa 
     524        lFfwkZV2EcePBcPR0RH29vYICgqCs7OzlMQjiPd5wcHBYXFxcSgoKEBXVxdXAUuuUCi4rdfa2orS0lKU 
     525        lZWhklKypOlXLiHsxDG4uW6BjY0NVq5cCWtrazg4OLD0MDExySDx/cQKXkBAgH1ubi74fD5iY2NBFXGi 
     526        zIRtU3ZdXFzMGSQnJ8PDwwO2tragqQorKyu2oPD29uaS+/r69q5fv/6akZHRzyS+kVjKMzc3X+rj43OE 
     527        3gP3mRAjPDwc0dHRqKur46ooKipi44D9iThhlpoWEkePHoWfn9+Mu7u72MLCgk3ZVCKccOMW2DDS2Vw3 
     528        X7JkyRYnJ6dUMlLn5+eDXkCg9oFmDAIDA7nSSYiNA0RFRTHhPjIqoOfS6XmW+ACxmfiIePvffzJdsINN 
     529        wrcI62XLlnlt3bo1g4z0NJtYNXOMhIQEdv3Yy8tLYmlpmUFtuGJYyJ10/pSwJEyIVw2az5zYqGWT0IxY 
     530        Z2Zm9h0ZFUREROhpnbrs7OwKDWnZrDlIfGVIy37PXqHzjuqn3dgPX2dtIzYQewxJ2b5maT8zpH3DUPmL 
     531        Ar/0e2bEkr1DsOnI3sMLTvtSF0PpzOx/t+Bp0b8BLT7Vmw+fMRMAAAAASUVORK5CYII= 
    532532</value> 
    533533  </data> 
    … …  
    660660    <value>421, 95</value> 
    661661  </metadata> 
     662  <metadata name="pROMOCJEBindingSource.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"> 
     663    <value>579, 95</value> 
     664  </metadata> 
     665  <metadata name="pROMOCJETableAdapter.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"> 
     666    <value>757, 95</value> 
     667  </metadata> 
    662668  <metadata name="$this.TrayHeight" type="System.Int32, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> 
    663     <value>185</value> 
     669    <value>198</value> 
    664670  </metadata> 
    665671</root> 

  • trunk/SQL/StoredProcedures/sp_GetReklamy.txt

    r313 r339  
    66 
    77-- ============================================= 
    8 -- Author:              marek 
    9 -- Create date: 2009-02-08 
    10 -- Description: Wyszukuje reklamy odpowiedniodo podanych parametrow 
     8-- Author:              <Author,,Name> 
     9-- Create date: <Create Date,,> 
     10-- Description: <Description,,> 
    1111-- ============================================= 
    1212ALTER PROCEDURE [dbo].[sp_GetReklamy]  
    … …  
    1818@tytul nvarchar(100) = NULL, 
    1919@typ nvarchar(100) = NULL, 
     20@promocja int = NULL, 
    2021@zd bit = NULL, 
    2122@fw bit = NULL, 
    … …  
    8081SET @query = @query + ' AND R.[TYP]=''' + @typ + ''' ' 
    8182 
     83if NOT (@promocja IS NULL) 
     84SET @query = @query + ' AND R.[Promocja]=' + CAST(@promocja as nvarchar) + ' ' 
     85 
    8286if (NOT (@fw IS NULL) AND NOT(@ms IS NULL) AND NOT(@rok IS NULL)) 
    8387BEGIN