- Data:
- 2009-11-27 18:02:15 (16 years ago)
- Lokalizacja:
- trunk
- Pliki:
-
- 2 dodane
- 19 zmodyfikowane
-
BazaReklam/Baza Reklam.csproj (zmodyfikowane) (1 diff)
-
BazaReklam/OrderDetails.cs (zmodyfikowane) (1 diff)
-
BazaReklam/Properties/AssemblyInfo.cs (zmodyfikowane) (1 diff)
-
BazaReklam/Properties/Settings.Designer.cs (zmodyfikowane) (1 diff)
-
BazaReklam/ProvisionForm.Designer.cs (zmodyfikowane) (4 diffs)
-
BazaReklam/ProvisionForm.cs (zmodyfikowane) (9 diffs)
-
BazaReklam/ProvisionForm.resx (zmodyfikowane) (2 diffs)
-
BazaReklam/Raporty/ReportsTree.xml (zmodyfikowane) (1 diff)
-
BazaReklam/ReportsForm.cs (zmodyfikowane) (2 diffs)
-
BazaReklam/ZamowieniaForm.cs (zmodyfikowane) (5 diffs)
-
BazaReklamSetup/BazaReklamSetup.vdproj (zmodyfikowane) (2 diffs)
-
RaportySQL/IloscOgloszen.rdl (dodane)
-
RaportySQL/IloscOgloszen.rdl.data (dodane)
-
RaportySQL/OcenaAgenta.rdl (zmodyfikowane) (5 diffs)
-
RaportySQL/OcenaAgenta.rdl.data (zmodyfikowane) (poprzedni)
-
RaportySQL/RaportySQL.rptproj (zmodyfikowane) (1 diff)
-
RaportySQL/RozliczenieProwizjiZaReklame2009.rdl (zmodyfikowane) (3 diffs)
-
RaportySQL/RozliczenieProwizjiZaReklame2009.rdl.data (zmodyfikowane) (poprzedni)
-
RaportySQL/RozliczenieWplywowWgDatyWplaty2009.rdl.data (zmodyfikowane) (poprzedni)
-
RaportySQL/SprzedazReklam2009.rdl (zmodyfikowane) (4 diffs)
-
RaportySQL/SprzedazReklam2009.rdl.data (zmodyfikowane) (poprzedni)
Legenda:
- Bez zmian
- Dodane
- Usunięte
-
trunk/BazaReklam/Baza Reklam.csproj
r901 r906 33 33 <WebPage>index.htm</WebPage> 34 34 <OpenBrowserOnPublish>false</OpenBrowserOnPublish> 35 <ApplicationVersion>1.2. 2.0</ApplicationVersion>35 <ApplicationVersion>1.2.3.0</ApplicationVersion> 36 36 <BootstrapperEnabled>false</BootstrapperEnabled> 37 37 </PropertyGroup> -
trunk/BazaReklam/OrderDetails.cs
r900 r906 1102 1102 rEKLAMATableAdapter.Update(rEKLAMADataSet.REKLAMA); 1103 1103 } 1104 1105 1104 } 1106 1105 else 1107 1106 { 1108 //usuwa zmiany w zleceniu 1107 //usuwa zmiany w zleceniu 1109 1108 rEKLAMADataSet.REKLAMA.RejectChanges(); 1110 1109 rEKLAMADataSet.UKAZE_SIE_W_NR.RejectChanges(); -
trunk/BazaReklam/Properties/AssemblyInfo.cs
r901 r906 30 30 // 31 31 [assembly: AssemblyVersion("1.0.0.0")] 32 [assembly: AssemblyFileVersion("1.2. 2")]32 [assembly: AssemblyFileVersion("1.2.3")] -
trunk/BazaReklam/Properties/Settings.Designer.cs
r889 r906 69 69 get { 70 70 return ((string)(this["Baza_Reklam_pl_admoto_service_ImportOtoMoto"])); 71 }71 } 72 72 } 73 73 } -
trunk/BazaReklam/ProvisionForm.Designer.cs
r900 r906 156 156 this.panel2.Location = new System.Drawing.Point(0, 551); 157 157 this.panel2.Name = "panel2"; 158 this.panel2.Size = new System.Drawing.Size(9 84, 38);158 this.panel2.Size = new System.Drawing.Size(990, 38); 159 159 this.panel2.TabIndex = 18; 160 160 // … … 242 242 this.prowizjeDataGridView.RowHeadersWidthSizeMode = System.Windows.Forms.DataGridViewRowHeadersWidthSizeMode.DisableResizing; 243 243 this.prowizjeDataGridView.SelectionMode = System.Windows.Forms.DataGridViewSelectionMode.CellSelect; 244 this.prowizjeDataGridView.Size = new System.Drawing.Size(9 84, 558);244 this.prowizjeDataGridView.Size = new System.Drawing.Size(990, 558); 245 245 this.prowizjeDataGridView.TabIndex = 19; 246 246 this.prowizjeDataGridView.CellLeave += new System.Windows.Forms.DataGridViewCellEventHandler(this.prowizjeDataGridView_CellLeave); … … 496 496 this.bindingNavigator1.Name = "bindingNavigator1"; 497 497 this.bindingNavigator1.PositionItem = this.bindingNavigatorPositionItem; 498 this.bindingNavigator1.Size = new System.Drawing.Size(9 84, 31);498 this.bindingNavigator1.Size = new System.Drawing.Size(990, 31); 499 499 this.bindingNavigator1.TabIndex = 17; 500 500 this.bindingNavigator1.Text = "bindingNavigator1"; … … 730 730 this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); 731 731 this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; 732 this.ClientSize = new System.Drawing.Size(9 84, 589);732 this.ClientSize = new System.Drawing.Size(990, 589); 733 733 this.ControlBox = false; 734 734 this.Controls.Add(this.ukrytyLabel); -
trunk/BazaReklam/ProvisionForm.cs
r900 r906 91 91 92 92 ((ComboBox)agencjaToolStripComboBox.Control).SelectedValue = User.Instance().IdAgencji; 93 94 if (!User.Instance().IsKierownik)95 {96 agencjaToolStripComboBox.Enabled = false;97 pLANBindingSource.Filter = "Symbol = '" + User.Instance().Login + "'";98 }99 93 } 100 94 … … 277 271 UzupelnijBDsuma(); 278 272 UzupelnijBudzetWykonanySuma(); 273 SetProvisionFilter(); 279 274 } 280 275 … … 335 330 336 331 btnBlockProvision.Visible = User.Instance().IsKierownik; 337 if (!User.Instance().IsKierownik) return; 332 333 if (!User.Instance().IsKierownik) 334 return; 338 335 339 336 _isProvisionBlocked = … … 384 381 private void CorrectBonusPercentage(int column, int row) 385 382 { 386 if (prowizjeDataGridView.Columns[column].Name != "PR_PROWIZJI") return;387 388 383 if (prowizjeDataGridView.Columns[column].Name == "PR_PROWIZJI") 389 384 { … … 408 403 private void prowizjeDataGridView_CellLeave(object sender, DataGridViewCellEventArgs e) 409 404 { 405 if (!User.Instance().IsKierownik) 406 return; 407 410 408 if (!Validate()) 411 409 { … … 436 434 private void prowizjeDataGridView_Leave(object sender, EventArgs e) 437 435 { 436 if (!User.Instance().IsKierownik) 437 return; 438 438 439 prowizjeDataGridView.EndEdit(); 439 440 … … 456 457 private void ProvisionForm_Leave(object sender, EventArgs e) 457 458 { 459 if (!User.Instance().IsKierownik) 460 return; 461 458 462 prowizjeDataGridView.EndEdit(); 459 463 … … 480 484 private void btnBlockProvision_Click(object sender, EventArgs e) 481 485 { 482 if (!User.Instance().IsKierownik ) return;483 484 if (!_isProvisionBlocked.HasValue)return;486 if (!User.Instance().IsKierownik || 487 !_isProvisionBlocked.HasValue) 488 return; 485 489 486 490 ProvisionHelper provisionHelper = new ProvisionHelper(ConnString.getConnString().Value); … … 520 524 emailSender.Send(); 521 525 } 526 527 private void SetProvisionFilter() 528 { 529 if (User.Instance().IsKierownik) 530 return; 531 532 foreach (DataGridViewRow dgvr1 in prowizjeDataGridView.Rows) 533 { 534 if (dgvr1.Cells["sYMBOLDataGridViewTextBoxColumn"].Value.ToString().ToUpper() != User.Instance().Login.ToUpper()) 535 { 536 dgvr1.Cells["oCENADataGridViewTextBoxColumn"].Value = 0; 537 dgvr1.Cells["PR_PROWIZJI"].Value = 0; 538 } 539 } 540 } 522 541 } 523 542 } -
trunk/BazaReklam/ProvisionForm.resx
r900 r906 314 314 <value> 315 315 iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8 316 YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAABv9JREFUSEt1lglQ 317 k3caxr+AdltnRbeObXeqU9fd1qnjTtc6bHc9lu1eMrsVC1VaWOtKi5yCSqEuSE0VOTxoOaRESCKHyBVC 318 uAI55JAAQsCCiVwCIWLUoJBwhDPy7PtlhbHT3W/mmX/mm/me3/993+//fOEwdF24cOk9q3VqndU6v3ph 319 gbOKYewdaHWwWjmrADjY2y93sLN7YSWtq+zsljvMz/9k1fT02AOTySS3WExylaqq4d49zQRZPSWB9fzB 320 lZDAM2ZkiNDU1Im+Pj36+4doNdL6GAMDZvptxp07T9De/gjNzQ/Q0DCE2lo9iorakZQkw4kT2aYjR1LE 321 Xl6x/jt3+m8k8xdInCUIn59tHB2dRWfnGDo6gO5uK/T6CQwOmtDTMwqNZgTff2+CWj2KlhYz6utHIJc/ 322 hEQyiJycTqSltSImRoaQkCx4e18aJuPNpJeWAJcv840zMwsYG5vCyMgkGU+Cy81ZYM2amoahUt2nHeug 323 UHSjoqIdItFNZGdXIz29AsnJxYiPL0BsbD7Ons2Fr2+KiYyPkdYvAjgsgHoNi2UOZvMUhocnqCVPqRVq 324 Mr5Bu60j42oUFytRUCDD1auVEArLweOVEEBMAJENEBWVi8OHk1nAOdKvlgDxCXzj+BwRnj7FxNg0Hj9m 325 AQuoqVFDqaxHZWUdystrqOdK5OXJkJUlhUBQjtTUEpqBGBcvFlKL8qiCPPj42ADnnwFsc+BERfON+65N 326 gqcyYXZyBmOjE+jqWqCdN0EqrUNZWQ3t/jrtXo5rOVXIyqiAkF+GtFQJUhKLkHA+HxdjchF7Ogc+h5NY 327 wAXSm4uD5vCoAkXXDN6JG8SWqLuoUA/D0AdUy1RQSqshL1dCVqKAtKgSRblSpPHLEX1JipD4ShyKlWNv 328 lBJO3GpsOdmAi8JqC2dbYBqZv0NaZqsgmioYMVthfDQO58S7YDya8anQgN3RLfh1+E28HtKCFf5qMN63 329 wBxuBxOgBXP0DpjQbjAne8B8Rc981QtvyUMkXtHNMx5tFvLdR3rZBgg/yzf+q9CCitYnsI6YIZAN4a3T 330 XWSmxuojLdgYchNbw1V4/9QNfHi2BgfilPA/V4Wwc2U4FSfCuehc5AkrUdmgx4tejWA+aR0nXy7pFzZA 331 PFWQqTJjS9w9+GToqT3DGNDMoowGWpJThuLsUkhFchQIxchNL0JWSiGECflIPp+HU1EF8OeKUXLjLl7z 332 bwDzzzrqgEL3/JvECT/DN/b2miFrNODnX3ZiTUgH8hUjiPtOiaMX5AhOUuHbkn6EXe3EG6GNWHm8DUzI 333 bWoRVRnRC+71EThyqX2fVGPFpwR46dVsAoQtngVOWDjf6FM6A2m9Adq2Ibx7WoOXw6nHXtTvQ+34TKCH 334 85k2nBQ9QILCgG+q9EiVD+CKohfFdX04kUmz+EiO5R718ItInyPjdNJu0k9tLTpNgITKYTh+ex9n8gbQ 335 qx5EqsgA/2gpTsZJbBm1zlOCZXtKcCAwBsePh+Bo8DGb9vlGwe5DKRhXBXZ6JdPplkyRZxJpC8n+v0Mm 336 QItKj0tFfVh9ogt/jLkD1fWH4MXnI+X8NTQ3avEbTx6Y3UXY4CWDRmdGv3ESmqFJbPSpBrOnAtu/qMFe 337 9wMEqGIB35A2LZ2DsDC+USYbgFzajUxRF5b538Lb0b14JegmvUmtiCx+CN+gMLx3tBbM30T4KK4DgxSO 338 3imdYJyL8aqnArXNWnzseZAApYuAtxYBTFDQ5XsSSTfE4i5IxFqICjX4Q0wXNgTWYmuwAkJpDwKDjqFT 339 N441rhJw/lqAyPQO2P+lGHbOZUjNVeHJkzG47/cggPjHABeXY//w9U015eTcpvjV4GpWO0qpXV9HZCHy 340 yytQVLUhIOAIpa0F2fL74LyfB8YpB8yfCuAWIadwHMUoxYubmzsB0n8MYKe9devfDwQEJD0WCG6Bz28l 341 UA8N8wqCgwWUpK3w8wuktJ2xyTWyCcyubLxG1dzW3sXk5DTBJ+Hi4vY8YCmL2EHbscd68+Y/ex48mPiI 342 x2uhSO5GYCCfjNNQWqqmD4kvpqZmMD09h/6hcaykWSRm1NO9Wdv9iQkLPvjABSkpGY/Iiw27pbhmAYuQ 343 n23a9Pt9Hh7c+wJBO0VvGry8UiimG3Ho0OdkNI25uXlkZmYtcLkJC1qt1qrT6eYNBsOc0WicdXJyGiOj 344 QtIXpHWLxs+vbH6vXr/+7b2urse7nZ0Derdvd6v18wtVhoZG9Lu7fzyxf//+cVdX17Fdu3YNstqxY8eg 345 o6Pj4LZt23Rr167NpedjSL8lvfi/ALZzQaJ/FszvSMGkyGc7Ynf1NYn9mLAtYNdoUtQznaH136Q9pDX/ 346 z3zxPgtZQXqdtOFZuWzJbDqyvWUHyK6/JLH/Ihb1Bv1mI9r2HWCv/wArwcam8/FBswAAAABJRU5ErkJg 347 gg== 316 YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAABv5JREFUSEt1lglQ 317 lPcZxr8FTROnoo1jk050Ym0TJ46d1Do0rUdpesm0EQNREqix0iKnoBKIBYkbRQ5REg43rLAcgsi1LMu1 318 sIccsoCwYMBduQSWFVEXhd2FXc6Vp++3FcZM2m/mmf/ON/M9v//7vt//+ZbD0HXx4uX3rNbpDVbrwtrF 319 Rc4ahrF3oNXBauWsAeBgb7/Swc7updW0rrGzW+mwsPCDNTMzpocGg0FmsRhkSmVN0/376imyekYC6/md 320 KzGRr8/OFqKlpRsDAzoMDo7Qqqf1CYaGjPTbiLt3n6Kz8zFaWx+iqWkE9fU6lJR0IjlZilOncg3HjvFE 321 Xl6x/rt3+28m85dInGWIQJCrn5iYQ3e3CV1dQG+vFTrdFIaHDejrm4BaPY5vvzVApZpAW5sRjY3jkMke 322 QSweRl5eN9LS2hETI0VISA68vS+PkfFW0ivLgCtXBPrZ2UWYTNMYHzeTsRlcbtYia9bSMgal8gHtWAu5 323 vBdVVZ0QCm8hN7cW6elVSEkpRUJCEWJjC3H+fD58fXkGMj5B2rgE4LAA6jUslnkYjdMYG5uiljyjVqjI 324 +CbttoGMa1FaqkBRkRTXrlUjM7MSfH4ZAUQEENoAUVH5OHo0hQVcIP18GZCQKNBPzhPh2TNMmWbw5AkL 325 WERdnQoKRSOqqxtQWVlHPVegoECKnBwJMjIqkZpaRjMQ4dKlYmpRAVVQAB8fGyD+OcA2B05UtEB/4LoZ 326 fKUBc+ZZmCam0NOzSDtvgUTSgIqKOtr9Ddq9DNfzapCTXYVMQQXSUsXgJZUgMb4Ql2LyEXs2Dz5Hk1nA 327 RdJbS4Pm8KkCec8s3o0bxraoe6hSjWF0AKiVKqGQ1EJWqYC0TA5JSTVK8iVIE1Qi+rIEIQnVOBIrw/4o 328 BZy4tdh2ugmXMmstnB2BaWT+LmmFrYJoqmDcaIX+8SSck+6B8WjFp5mj2Bvdhl+E38IbIW1Y5a8C430b 329 zNFOMAEaMMfvggntBXO6D8wX9MwX/fAWP0JSlnaB8eiwkO8B0qs2QPh5gf4fxRZUtT+FddyIDOkI3j7b 330 Q2YqrD3Whs0ht7A9XIn3z9zEh+frcChOAf8LNQi7UIEzcUJciM5HQWY1qpt0eNmrGcwn7ZPkyyX91AZI 331 oAquKo3YFncfPtk6as8YhtRzqKCBluVVoDS3HBKhDEWZIuSnlyCHV4zMxEKkxBfgTFQR/LkilN28h9f9 332 m8D8vYE6INe++CZxws8J9P39RkibR/GTz7uxLqQLhfJxxH2jwPGLMgQnK/F12SDCrnXjzdBmrD7ZASbk 333 DrWIqozoB/fGOBy51L5ParHqUwK88louAcKWzgInLFyg9ymfhaRxFJqOEfzqrBqvhlOPvajfRzrxzwwd 334 nM914LTwIRLlo/iqRodU2RCy5P0obRjAqas0i49kWOnRCL+I9HkyTiftJf3Q1qKzBEisHoPj1w9wrmAI 335 /aphpApH4R8twek4sS2jNniKsWJfGQ4FxuDkyRAcDz5h0wHfKNh9KAHjKsdurxQ63eJp8kwmbSPZ/3fI 336 BGhT6nC5ZABrT/Xg9zF3obzxCPyEQvDir6O1WYNfevLB7C3BJi8p1FojBvVmqEfM2OxTC2ZfFXZ+Vof9 337 7ocIUMMCviJtWT4HYWECvVQ6BJmkF1eFPVjhfxvvRPfjx0G36E1qR2TpI/gGheG94/Vg/iLER3FdGKZw 338 9OZ1g3EuxWuectS3avCx52EClC8B3l4CMEFBV+6Lxb0QiXogFmkgLFbjdzE92BRYj+3BcmRK+hAYdALd 339 2kmscxWD8+ciRKZ3wf5PpbBzrkBqvhJPn5rgftCDAKLvA1xcTvzN1zfVkJd3h+JXjWs5nSindn0ZkYPI 340 z7Mgr+lAQMAxSlsLcmUPwHm/AIxTHpg/FMEtQkbhOIEJihc3N3cCpH8fwE57+/a/HgoISH6SkXEbAkE7 341 gfpomFkIDs6gJG2Hn18gpe2sTa6RLWD25OJ1quaO5h7M5hmCm+Hi4vYiYDmL2EHbscd669Y/eh4+nPSY 342 z2+jSO5FYKCAjNNQXq6iD4kvpqdnMTMzj8GRSaymWSRlN9K9Odv9qSkLPvjABTxe9mPyYsNuOa5ZwBLk 343 R1u2/PaAhwf3QUZGJ0VvGry8eBTTzThy5F9kNIP5+QXapWCRy41f1Gg0Vq1WuzA6Ojqv1+vnnJycTGRU 344 TPqMtGHJ+MWVze+1Gze+s9/V9WSvs3NA/86dbvV+fqGK0NCIQXf3j6cOHjw46erqatqzZ88wq127dg07 345 OjoO79ixQ7t+/fp8ej6G9GvSy/8LYDsXJPpnwfyGFEyKfL4jdldfktiPCdsCdo0mRT3XOVr/TdpHWvf/ 346 zJfus5BVpDdIm56Xy5bMpiPbW3aA7PozEvsvYklv0m82om3fAfb6D91kxog1AnJ6AAAAAElFTkSuQmCC 348 347 </value> 349 348 </data> … … 351 350 <value> 352 351 iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8 353 YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAABY tJREFUSEuVVWlM354 VFcYHVpbMdLUFiyNkDRto5WiMY22FNJUfxBLWAQtVBEtatuURS0oCiqyqCxRLJsR1EBBVkGQbQA7DDNA355 IVNkpIhQZBWYGZjNYRAQpHL63ddJa6JiecnJuzPv3XPO9937zjXivfgymucZ5nn2/Ed5eXnbzp2LPRgT356 ExMWdebU+dMREWlnTkcWRp+O/jXufJwkMTm5KykpqZVmWxAWL1ggPT29VjaqwbDqAWS6SSgm5qCYBoZn357 gN5HQDeNw2MT5lavXh1I5O8RXlmQSGJiYpRcq8f4X4CKyBSTwOBDIh4DOh4A7TpA0D4Eh82bfyFiO4Lx358 ggQiIyNdG2+1Qff4H/LhCWBgHOjRA10kcpcE2un3oQO+TUS8g2C6IAEXFxfz6yVlj9UkICcBhhblE1R0359 zyD9j0mcbdTjeO0YXON/e2R1pOj6quAy/3ORJ20uxMd/uXfv3uUktogw38bgLaI2SdVzwG0NECSYRojg360 ISJFDxFQpcdP/DEcrBjDfsKPpVo4ZiqwO6UR0kYxcnJyJkNDQ+NNTU1XkMhrz62sqanJPjMzs/tmjQhV361 N2tQIZbgQv0IDvB1SGmexnESO1RJAuUP4EMC35doYZsyhKsNfVDKh1BXV4fDhw/ziXzVM7tMKpW6iESi362 GRJ5MjExAa1GjRG5DBr5fZRL78MtR4HzjVMIrNTBr0yLH26o4X1diV2FSnwc24X+rju4d+8eyssr4Obm363 Fk8CHxhaxuNRWxZXV1cPz87OYnx8HFqtFmq1GoODg+jq6sJgz59IrenCjmujCBPqyb0G+4pV2F04Cq+C364 UWxIHsCFijYU51yCsLoEISEhWmNj4/82QVZW1jednZ2YmpqCTqeDRqPB6OgoRkZG0NHRgdbWVnTfkcIj365 vRPHbupIQI095N6LBD3yFXDKlGFL8l00p32L2YptyMguxNq1a5OogjVcFampqWnMtV6v58hVKhVHPjw8366 jL6+PkgkEtz6XQJBnQR2FwcRVK3FLnK+ncjdc+RwpfatOdUGSVU2psv3oUbchE2bNlUSuTPhTd7ly5dv367 sb6ztiiVSo5cJpNxLWKgdUFDQwOkTfXwTL0NnxIVdpL77dcU+DpXgY1XhvBJZDMaxUIIahsgEtfB09Oz368 nch9CO/ysrOzFWNjY1xbFAoFRz40NISBgQH09/ejubkZQqEQImENyqtr8WFMH764JMO6hAEsP9mNz4m8369 SiBEdSUfxAWxWAx/f38lkZ/gIiUlJUXH3LPWyOVyzjUjZ+3p6elBS0sLqqqqOAiqK3H1hgChGXU4m1eH370 8go+stIu4vixYDg6OsLe3h5BQUFwdnaWEHkE4X1ecHBwWFxcHAoKCtDb28tVwJx3d3dzW6+trQ2lpaUo371 K ytDJblkTtOvXELYiWNwc90CGxsbrFy5EtbW1nBwcGDuYWJikkHk+wkreAEBAfa5ubng8/mIjY0FVcSR372 MhG2Tdm4uLiYE0hOToaHhwdsbW1BqQorKyu2oPD29uac+/r6Dqxfv/6akZHRz0S+kbCUZ25uvtTHx+cI373 nQP3GRFDeHg4oqOjUV9fz1VRVFTE4oB9RBwxc00LiaNHj8LPz2/G3d1dZGFhwVI2lRBOcOMW2BDpLNfN374 lyxZssXJySmVhFT5+fmgAwjUPlDGIDAwkCudiFgcICoqihEPklABzUun+czxAcJmwkeEt//9kmnALpaE375 bxGsly1b5rV169YMEtJTNrFq5hgSEhLY+LGXl5fY0tIyg9pwxbCQO+n+KcGSYEJ41cD5zI1FLUtCM8I6376 MzOz70ioICIiQk/r1GtnZ1docMuy5iDhK4Nb9j47QueN6qfV2Iuvs7YRNhD2GJyyfc3cfmZw+4ah8hcZ377 fun/TIg5e4fA0pGdwwt2+1IVQ+lM7H+34GnSvwFnAdXHLrTXvQAAAABJRU5ErkJggg==352 YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAABY1JREFUSEuVVXtM 353 U1ccLpubGFnmBo5FSJZt0cnQmEU3BlmmfxBHeAg6mCI61G0ZD3WgKKjIQ+URxfEyghoYyFMQ5FWoK4UC 354 g3QIMkRYLS+BtlDaWoqAIJNvv3PXbCYqjpt8uae993zf9/udc79jxHvxZTTPM8zz7PmP8vLytp07F3sw 355 JiYmLOrMqfOnIyLSzpyOLIw+Hf1r3Pk4SWJysjQpKamNZlsQFi9YID09vUY+osHQ6APIdZNQTsxBOQ0M 356 zQA9jwAZjcNPnZ1bvXp1IJG/R3hlQSKJiYlRCq0e438Bo0SmnAQGHhLxGND5AOjQAcKOQThs3vwLEdsR 357 jBckEBkZ6dp4qx26x/+QD00A/eNAtx6QkshdEuig34cO+DYR8Q6C6YIEXFxczK+XlD1Wk4CCBBhaVE9Q 358 IZtB+h+TONuox/GaMbjG//bI6kjR9VXBZf7nIk/aXIiP/3Lv3r3LSWwRYb6NwVtEbWpVzwG3NUCQcBoh 359 woeIrH2IgCo9fuKP4WDFGPYTfizVwjFTid0pjWhtFCMnJ2cyNDQ03tTUdAWJvPbcypqamuwzMzNlN6tr 360 UXWzGhViCS7UD+MAX4eU5mkcJ7FDlSRQ/gA+JPB9iRa2KYO42tALlWIQdXV1OHz4MJ/IVz2zy1pbW11q 361 a2tnxGLxk4mJCWg1agwr5NAo7qO89T7ccpQ43ziFwEod/Mq0+OGGGt7XVdhVqMLHsVL0Se/g3r17KC+v 362 gJubWzwJfGBoGY9HbVksEAiGZmdnMT4+Dq1WC7VajYGBAUilUgx0/4nUail2XBtBmEhP7jXYVzyK3YUj 363 8CoYwYbkflyoaEdxziWIBCUICQnRGhsb/7cJsrKyvunq6sLU1BR0Oh00Gg1GRkYwPDyMzs5OtLW1QXan 364 FR7pXTh2U0cCauwh914k6JGvhFOmHFuS76I57VvMVmxDRnYh1q5dm0QVrOGqSE1NTWOu9Xo9Rz46OsqR 365 Dw0Nobe3FxKJBLd+l0BYJ4HdxQEECbTYRc63E7l7jgKu1L41p9ohqcrGdPk+VIubsGnTpkoidya8ybt8 366 +fIt1nfWFpVKxZHL5XKuRQy0+GhoaEBrUz08U2/Dp2QUO8n99mtKfJ2rxMYrg/gkshmNYhGENQ2oFdfB 367 09Ozg8h9CO/ysrOzlWNjY1xblEolRz44OIj+/n709fWhubkZIpEItaJqlAtq8GFML764JMe6hH4sPynD 368 50ReJRRBUMkHcYE2Cvz9/VVEfoKLlJSUFB1zz1qjUCg414yctae7uxstLS2oqqriIBRU4uoNIUIz6nA2 369 rw7lFXxkpV3E8WPBcHR0hL29PYKCguDs7Cwh8gjC+7zg4OCwuLg4FBQUoKenh6uAOZfJZNzWa29vR2lp 370 KcrKylBJLpnT9CuXEHbiGNxct8DGxgYrV66EtbU1HBwcmHuYmJhkEPl+wgpeQECAfW5uLvh8PmJjY0EV 371 caRMhG1TNi4uLuYEkpOT4eHhAVtbW1CqwsrKii0ovL29Oee+vr7969evv2ZkZPQzkW8kLOWZm5sv9fHx 372 OULnwH1GxBAeHo7o6GjU19dzVRQVFbE4YB8RR8xc00Li6NGj8PPzm3F3d6+1sLBgKZtKCCe4cQtsiHSW 373 6+ZLlizZ4uTklEpCo/n5+aADCNQ+UMYgMDCQK52IWBwgKiqKEQ+QUAHNS6f5zPEBwmbCR4S3//2SacAu 374 loRvEayXLVvmtXXr1gwS0lM2sWrmGBISEtj4sZeXl9jS0jKD2nDFsJA76f4pwZJgQnjVwPnMjUUtS0Iz 375 wjozM7PvSKggIiJCT+vUY2dnV2hwy7LmIOErg1v2PjtC543qp9XYi6+zthE2EPYYnLJ9zdx+ZnD7hqHy 376 Fxl+6f9MiDl7h8DSkZ3DC3b7UhVD6Uzsf7fgadK/AZj01amQyUXyAAAAAElFTkSuQmCC 378 377 </value> 379 378 </data> -
trunk/BazaReklam/Raporty/ReportsTree.xml
r747 r906 54 54 <Report text="Lista reklam A4" path="ListaReklamA4" rights="" /> 55 55 <Report text="Lista reklam A3" path="ListaReklamA3" rights="" /> 56 <Report text="Ilość ogłoszeń" path="IloscOgloszen" rights="" /> 56 57 </Report> 57 58 <Report text="Pozostałe"> -
trunk/BazaReklam/ReportsForm.cs
r900 r906 452 452 reportViewer1.ServerReport.ReportPath == "/" + reportsCatalog + "/RozliczenieProwizjiZaReklame2009" | 453 453 reportViewer1.ServerReport.ReportPath == "/" + reportsCatalog + "/SzacowanieSprzedazy" | 454 reportViewer1.ServerReport.ReportPath == "/" + reportsCatalog + "/OcenaAgenta" | 455 reportViewer1.ServerReport.ReportPath == "/" + reportsCatalog + "/SprzedazReklam2009" ) 454 reportViewer1.ServerReport.ReportPath == "/" + reportsCatalog + "/OcenaAgenta" ) 456 455 { 457 456 if (!User.Instance().IsKierownik) … … 477 476 reportViewer1.ServerReport.ReportPath == "/" + reportsCatalog + "/WynikAgencji" | 478 477 reportViewer1.ServerReport.ReportPath == "/" + reportsCatalog + "/SprzedazReklam" | 479 reportViewer1.ServerReport.ReportPath == "/" + reportsCatalog + "/RozliczenieProwizjiZaReklame" /*|480 reportViewer1.ServerReport.ReportPath == "/" + reportsCatalog + "/SprzedazReklam2009" |478 reportViewer1.ServerReport.ReportPath == "/" + reportsCatalog + "/RozliczenieProwizjiZaReklame" | 479 reportViewer1.ServerReport.ReportPath == "/" + reportsCatalog + "/SprzedazReklam2009" /*| 481 480 reportViewer1.ServerReport.ReportPath == "/" + reportsCatalog + "/RozliczenieProwizjiZaReklame2009" | 482 481 reportViewer1.ServerReport.ReportPath == "/" + reportsCatalog + "/OcenaAgenta"*/ -
trunk/BazaReklam/ZamowieniaForm.cs
r889 r906 194 194 195 195 string s = string.Empty; 196 if (!CanAddProductToOrder(product, productsWithOrder, zamowienie, out s)) 196 197 List<IProduct> productsInOrder = (List<IProduct>)rEKLAMADataGridView.DataSource; 198 199 //if (!CanAddProductToOrder(product, productsWithOrder, zamowienie, out s)) 200 if (!CanAddProductToOrder(product, productsInOrder, zamowienie, out s)) 197 201 { 198 202 MessageBox.Show(s, "Baza Reklam - Zamówienia i faktury", MessageBoxButtons.OK, MessageBoxIcon.Error); … … 235 239 } 236 240 237 private bool CanAddProductToOrder(IProduct product, List<IProduct> products, REKLAMADataSet.zamowieniaRow order, out string errorMessage) 241 // private bool CanAddProductToOrder(IProduct product, List<IProduct> products, REKLAMADataSet.zamowieniaRow order, out string errorMessage) 242 private bool CanAddProductToOrder(IProduct product, List<IProduct> productsInOrder, REKLAMADataSet.zamowieniaRow order, out string errorMessage) 238 243 { 239 244 StringBuilder sb = new StringBuilder(); … … 246 251 } 247 252 248 if (products .FindAll(delegate(IProduct p) { return p.Currency != product.Currency && p.OrderId == order.idZamowienia; }).Count > 0)253 if (productsInOrder.FindAll(delegate(IProduct p) { return p.Currency != product.Currency && p.OrderId == order.idZamowienia; }).Count > 0) 249 254 { 250 255 sb.AppendLine("Produkt jest w innej walucie ni¿ pozosta³e produkty w zamówieniu."); … … 252 257 } 253 258 254 if (products .FindAll(delegate(IProduct p) { return p.Vat != product.Vat && p.OrderId == order.idZamowienia; }).Count > 0)259 if (productsInOrder.FindAll(delegate(IProduct p) { return p.Vat != product.Vat && p.OrderId == order.idZamowienia; }).Count > 0) 255 260 { 256 261 sb.AppendLine("Produkt ma inn¹ stawkê VAT ni¿ pozosta³e produkty w zamówieniu."); … … 269 274 //Sprawdz czy reklamy maja takiego samego InvoiceProviders 270 275 //TODO: wywala sie przy dodawaniu abonamentu do zamowienia... 271 if (canAddProduct && products .Count > 0)276 if (canAddProduct && productsInOrder.Count > 0) 272 277 { 273 278 Title title1 = _titles.Find(delegate(Title title) { return title.Id == product.TitleId; }); 274 Title title2 = _titles.Find(delegate(Title title) { return title.Id == products [0].TitleId; });279 Title title2 = _titles.Find(delegate(Title title) { return title.Id == productsInOrder[0].TitleId; }); 275 280 if (title1 == null || title2 == null) 276 281 { -
trunk/BazaReklamSetup/BazaReklamSetup.vdproj
r901 r906 578 578 "Name" = "8:Microsoft Visual Studio" 579 579 "ProductName" = "8:Baza Reklam" 580 "ProductCode" = "8:{ 418E62F2-F128-43CE-B0A6-1E176C29079B}"581 "PackageCode" = "8:{ E733A2E9-EA20-4297-B1B3-17196B5CB6AF}"580 "ProductCode" = "8:{A178AA0E-CDBC-429E-BA23-03838D1F3F14}" 581 "PackageCode" = "8:{4A7576E0-501C-49E8-97DA-FF697A912F75}" 582 582 "UpgradeCode" = "8:{4E2DBBA4-3139-4790-8DDB-7AADFC963A7D}" 583 583 "RestartWWWService" = "11:FALSE" … … 585 585 "DetectNewerInstalledVersion" = "11:TRUE" 586 586 "InstallAllUsers" = "11:TRUE" 587 "ProductVersion" = "8:1.2. 2"587 "ProductVersion" = "8:1.2.3" 588 588 "Manufacturer" = "8:AACT" 589 589 "ARPHELPTELEPHONE" = "8:" -
trunk/RaportySQL/OcenaAgenta.rdl
r900 r906 199 199 <rd:TypeName>System.Int32</rd:TypeName> 200 200 </Field> 201 <Field Name="O CENA">202 <DataField>O cena</DataField>203 <rd:TypeName>System. Int32</rd:TypeName>201 <Field Name="Ocena"> 202 <DataField>OCENA</DataField> 203 <rd:TypeName>System.String</rd:TypeName> 204 204 </Field> 205 205 <Field Name="PR_PROWIZJI"> … … 226 226 [PLAN].BUDZET, 227 227 [PLAN].W_BUDZET, 228 Ocena = 229 CASE 230 WHEN [PLAN].OCENA=100 THEN 2 231 WHEN [PLAN].OCENA=50 THEN 1 232 ELSE 0 228 OCENA = CASE WHEN (@prawa_agent is null OR [PLAN].SYMBOL=@prawa_agent) THEN 229 CASE 230 WHEN [PLAN].OCENA=100 THEN '2' 231 WHEN [PLAN].OCENA=50 THEN '1' 232 ELSE '0' 233 END 234 ELSE 235 '-' 233 236 END, 234 [PLAN].PR_PROWIZJI 237 CASE WHEN (@prawa_agent is null OR [PLAN].SYMBOL=@prawa_agent) THEN 238 [PLAN].PR_PROWIZJI 239 ELSE 240 0 241 END AS PR_PROWIZJI 235 242 FROM AGENCJE 236 243 INNER JOIN AGENCI ON AGENCJE.Id_agencji = AGENCI.ID_AGENCJI … … 238 245 WHERE ([PLAN].ROK = @rok) AND (AGENCJE.Id_agencji = @agencja) AND (@agent = 'Wszyscy' OR AGENCI.SYMBOL = @agent)</CommandText> 239 246 <QueryParameters> 247 <QueryParameter Name="@prawa_agent"> 248 <Value>=Parameters!prawa_agent.Value</Value> 249 </QueryParameter> 240 250 <QueryParameter Name="@rok"> 241 251 <Value>=Parameters!rok.Value</Value> … … 307 317 FROM AGENCI A 308 318 left join Agencje A2 on A.ID_AGENCJI = A2.ID_Agencji 309 where aktywny=1 AND (A2.ID_AGENCJI in (@agencja) OR A2.ID_AGENCJI is null) AND (@prawa_agent is null OR A.Symbol=@prawa_agent)319 where aktywny=1 AND (A2.ID_AGENCJI in (@agencja) OR A2.ID_AGENCJI is null) 310 320 union 311 321 select NULL,'Wszyscy','costam' 312 where @prawa_agent is null313 322 order by A.Symbol;</CommandText> 314 323 <QueryParameters> 315 324 <QueryParameter Name="@agencja"> 316 325 <Value>=Parameters!agencja.Value</Value> 317 </QueryParameter>318 <QueryParameter Name="@prawa_agent">319 <Value>=Parameters!prawa_agent.Value</Value>320 326 </QueryParameter> 321 327 </QueryParameters> … … 519 525 <ZIndex>1</ZIndex> 520 526 <CanGrow>true</CanGrow> 521 <Value>=Fields!O CENA.Value</Value>527 <Value>=Fields!Ocena.Value</Value> 522 528 </Textbox> 523 529 </ReportItems> -
trunk/RaportySQL/RaportySQL.rptproj
r900 r906 428 428 <Name>ZmianyEmisjiWgSymbolu.rdl</Name> 429 429 <FullPath>ZmianyEmisjiWgSymbolu.rdl</FullPath> 430 </ProjectItem> 431 <ProjectItem> 432 <Name>IloscOgloszen.rdl</Name> 433 <FullPath>IloscOgloszen.rdl</FullPath> 430 434 </ProjectItem> 431 435 </Reports> -
trunk/RaportySQL/RozliczenieProwizjiZaReklame2009.rdl
r827 r906 1002 1002 <Default>LightGrey</Default> 1003 1003 </BorderColor> 1004 <BorderStyle>1005 <Default>Solid</Default>1006 </BorderStyle>1007 1004 <BorderWidth> 1008 1005 <Default>0.5pt</Default> … … 1030 1027 <Default>LightGrey</Default> 1031 1028 </BorderColor> 1032 <BorderStyle>1033 <Default>Solid</Default>1034 </BorderStyle>1035 1029 <BorderWidth> 1036 1030 <Default>0.5pt</Default> … … 1057 1051 <Default>LightGrey</Default> 1058 1052 </BorderColor> 1059 <BorderStyle>1060 <Default>Solid</Default>1061 </BorderStyle>1062 1053 <BorderWidth> 1063 1054 <Default>0.5pt</Default> -
trunk/RaportySQL/SprzedazReklam2009.rdl
r900 r906 13 13 <Nullable>true</Nullable> 14 14 <Prompt>prawa_agencje</Prompt> 15 <Hidden>true</Hidden>16 </ReportParameter>17 <ReportParameter Name="prawa_agent">18 <DataType>String</DataType>19 <Nullable>true</Nullable>20 <Prompt>prawa_agent</Prompt>21 15 <Hidden>true</Hidden> 22 16 </ReportParameter> … … 222 216 AND (AGENCJE.Id_agencji<>4 OR Korekta.NUMER_ROZ ='KAT') AND (AGENCJE.Id_agencji <>6 OR Korekta.NUMER_ROZ ='POZ') 223 217 AND Korekta.SystemKsiegowyId IN (@systemKsiegowy) 224 AND (@agent IS NULL OR AGENCI.SYMBOL=@agent)225 218 GROUP BY AGENCJE.Symbol, AGENCI.Nazwisko + ' ' + AGENCI.ImiÄ, Korekta.ID_FAKTURY, Korekta.DATA_SPRZEDAZY, 226 219 YEAR(Korekta.DATA_SPRZEDAZY), Korekta.NUMER_ROZ, … … 263 256 AND (AGENCJE.Id_agencji<>4 OR FAKTURY.NUMER_ROZ ='KAT') AND (AGENCJE.Id_agencji <>6 OR FAKTURY.NUMER_ROZ ='POZ') 264 257 AND FAKTURY.KOREKTA=0 AND FAKTURY.SystemKsiegowyId IN (@systemKsiegowy) 265 AND (@agent IS NULL OR AGENCI.SYMBOL=@agent)266 258 GROUP BY AGENCJE.Symbol, AGENCI.Nazwisko + ' ' + AGENCI.ImiÄ, FAKTURY.ID_FAKTURY, FAKTURY.DATA_SPRZEDAZY, 267 259 YEAR(FAKTURY.DATA_SPRZEDAZY), FAKTURY.NUMER_ROZ, FAKTURY.suma_zaplat, FAKTURY.Korekta … … 289 281 <QueryParameter Name="@systemKsiegowy"> 290 282 <Value>=Parameters!systemKsiegowy.Value</Value> 291 </QueryParameter>292 <QueryParameter Name="@agent">293 <Value>=Parameters!prawa_agent.Value</Value>294 283 </QueryParameter> 295 284 </QueryParameters>
