Zbiór zmian 669
- Data:
- 2009-06-01 14:14:33 (17 years ago)
- Lokalizacja:
- trunk
- Pliki:
-
- 1 dodane
- 1 zmodyfikowane
-
BazaReklam/ClientsForm.cs (zmodyfikowane) (14 diffs)
-
SQL/StoredProcedures/sp_GetClientsWithNoContact.txt (dodane)
Legenda:
- Bez zmian
- Dodane
- Usunięte
-
trunk/BazaReklam/ClientsForm.cs
r614 r669 7 7 using System.IO; 8 8 using System.Text.RegularExpressions; 9 using Baza_Reklam.Classes;10 9 using Baza_Reklam.Classes.Helpers; 11 10 using Baza_Reklam.Classes.Interfaces; … … 467 466 command.CommandText += " where K.UserName=@agent order by data desc"; 468 467 command.Parameters.AddWithValue("@agent", User.Instance().Symbol_agenta); 468 command.CommandType = CommandType.Text; 469 469 sqlDataAdapter.Fill(rEKLAMADataSet.KLIENCI); 470 470 clientsDataGridView.Refresh(); … … 489 489 command.CommandText += " where K.UserName=@agent AND K.Aktywny=1 order by K.data desc"; 490 490 command.Parameters.AddWithValue("@agent", User.Instance().Symbol_agenta); 491 command.CommandType = CommandType.Text; 491 492 sqlDataAdapter.Fill(rEKLAMADataSet.KLIENCI); 492 493 clientsDataGridView.Refresh(); … … 501 502 command.CommandText += " where K.AgentExpo=@agent AND K.Aktywny=1 order by K.data desc"; 502 503 command.Parameters.AddWithValue("@agent", User.Instance().Symbol_agenta); 504 command.CommandType = CommandType.Text; 503 505 sqlDataAdapter.Fill(rEKLAMADataSet.KLIENCI); 504 506 clientsDataGridView.Refresh(); … … 513 515 command.CommandText += " where K.UserName=@agent AND K.Aktywny=0 order by K.data desc"; 514 516 command.Parameters.AddWithValue("@agent", User.Instance().Symbol_agenta); 517 command.CommandType = CommandType.Text; 515 518 sqlDataAdapter.Fill(rEKLAMADataSet.KLIENCI); 516 519 clientsDataGridView.Refresh(); … … 525 528 command.CommandText += " where K.AgentExpo=@agent AND K.Aktywny=0 order by K.data desc"; 526 529 command.Parameters.AddWithValue("@agent", User.Instance().Symbol_agenta); 530 command.CommandType = CommandType.Text; 527 531 sqlDataAdapter.Fill(rEKLAMADataSet.KLIENCI); 528 532 clientsDataGridView.Refresh(); … … 540 544 command.CommandText += " left join dbo.AGENCI A on K.UserName = A.Symbol where A.Id_agencji = @idAgencji"; 541 545 command.Parameters.AddWithValue("@idAgencji", e.Node.Name); 546 command.CommandType = CommandType.Text; 542 547 sqlDataAdapter.Fill(rEKLAMADataSet.KLIENCI); 543 548 clientsDataGridView.Refresh(); … … 552 557 command.CommandText += " on K.UserName = A.Symbol where K2.ID_KL_KLIENCI is null AND A.Id_agencji = @idAgencji"; 553 558 command.Parameters.AddWithValue("@idAgencji", e.Node.Name); 559 command.CommandType = CommandType.Text; 554 560 sqlDataAdapter.Fill(rEKLAMADataSet.KLIENCI); 555 561 clientsDataGridView.Refresh(); … … 564 570 command.CommandText += " on K.UserName = A.Symbol where K.aktywny=1 AND KT.id_klienci_tytul is null AND A.Id_agencji = @idAgencji"; 565 571 command.Parameters.AddWithValue("@idAgencji", e.Node.Name); 572 command.CommandType = CommandType.Text; 566 573 sqlDataAdapter.Fill(rEKLAMADataSet.KLIENCI); 567 574 clientsDataGridView.Refresh(); … … 592 599 command.CommandText += " on K.UserName = A.Symbol where K2.ID_KL_KLIENCI is null AND A.Symbol = @symAgenta"; 593 600 command.Parameters.AddWithValue("@symAgenta", e.Node.Name); 601 command.CommandType = CommandType.Text; 594 602 sqlDataAdapter.Fill(rEKLAMADataSet.KLIENCI); 595 603 clientsDataGridView.Refresh(); … … 604 612 command.CommandText += " on K.UserName = A.Symbol where K.aktywny=1 AND KT.id_klienci_tytul is null AND A.Symbol = @symAgenta"; 605 613 command.Parameters.AddWithValue("@symAgenta", e.Node.Name); 614 command.CommandType = CommandType.Text; 606 615 sqlDataAdapter.Fill(rEKLAMADataSet.KLIENCI); 607 616 clientsDataGridView.Refresh(); … … 627 636 command.CommandText += " where UserName=@agent"; 628 637 command.Parameters.AddWithValue("@agent", e.Node.Name); 638 command.CommandType = CommandType.Text; 629 639 sqlDataAdapter.Fill(rEKLAMADataSet.KLIENCI); 630 640 clientsDataGridView.Refresh(); … … 636 646 637 647 rEKLAMADataSet.KLIENCI.Clear(); 638 command.CommandText += "left join dbo.KONTAKTY K2 on K.CustomerId = K2.CustomerID " + 639 "left join dbo.AGENCI A on K.UserName = A.Symbol " + 640 "group by K.AgentExpo, K.kodKlienta, K.CustomerID, K.FirstName, K.LastName, K.OrganizationName, " + 641 "K.Address, K.City, K.State, K.PostalCode, K.Country, K.Nip, K.ContactName, K.PhoneNumber, K.FaxNumber," + 642 "K.Note, K.data, K.Adres_Fkatura, K.Adres_Kor, K.Platnik_VAT, K.Aktywny, " + 643 "K.Email, K.UserName, K.Last_Modify, K.Modify_User, K.http, K.VIES, K.regon, K.krs, K.osw_nr,K.osw_wazne_do,K.Old_ID, K.NipKraj, A.Id_agencji " + 644 "HAVING datediff(day,max(K2.data),getdate()) > @param1 AND datediff(day,max(K2.data),getdate()) <@param2 " + 645 "AND A.Id_agencji = @idAgencji order by datediff(day,max(K2.data),getdate()) desc"; 646 command.Parameters.AddWithValue("@idAgencji", e.Node.Parent.Parent.Name); 647 command.Parameters.AddWithValue("@param1", e.Node.Name); 648 648 649 command.CommandText = "sp_GetClientsWithNoContact"; 650 command.CommandType = CommandType.StoredProcedure; 651 652 command.Parameters.AddWithValue("@agencyId", e.Node.Parent.Parent.Name); 653 command.Parameters.AddWithValue("@numberOfDaysStart", e.Node.Name); 649 654 if (e.Node.NextNode != null) 650 { 651 command.Parameters.AddWithValue("@param2", e.Node.NextNode.Name); 652 } 655 command.Parameters.AddWithValue("@numberOfDaysEnd", e.Node.NextNode.Name); 653 656 else 654 { 655 command.Parameters.AddWithValue("@param2", "9999"); 656 } 657 command.Parameters.AddWithValue("@numberOfDaysEnd", 9999); 657 658 658 659 sqlDataAdapter.Fill(rEKLAMADataSet.KLIENCI); … … 760 761 761 762 rEKLAMADataSet.KLIENCI.Clear(); 763 command.CommandType = CommandType.Text; 762 764 763 765 sqlDataAdapter.Fill(rEKLAMADataSet.KLIENCI);
