- Data:
- 2009-06-01 15:10:36 (17 years ago)
- Lokalizacja:
- branches/ReklamaReorganizacja
- Pliki:
-
- 1 zmodyfikowane
- 1 skopiowane
-
BazaReklam/ClientsForm.cs (zmodyfikowane) (14 diffs)
-
SQL/StoredProcedures/sp_GetClientsWithNoContact.txt (skopiowane) (skopiowane from trunk/SQL/StoredProcedures/sp_GetClientsWithNoContact.txt)
Legenda:
- Bez zmian
- Dodane
- Usunięte
-
branches/ReklamaReorganizacja/BazaReklam/ClientsForm.cs
r646 r671 8 8 using System.IO; 9 9 using System.Text.RegularExpressions; 10 using Baza_Reklam.Classes;11 10 using Baza_Reklam.Classes.Helpers; 12 11 using Baza_Reklam.Classes.Interfaces; … … 494 493 command.CommandText += " where K.UserName=@agent order by data desc"; 495 494 command.Parameters.AddWithValue("@agent", User.Instance().Symbol_agenta); 495 command.CommandType = CommandType.Text; 496 496 sqlDataAdapter.Fill(rEKLAMADataSet.KLIENCI); 497 497 clientsDataGridView.Refresh(); … … 516 516 command.CommandText += " where K.UserName=@agent AND K.Aktywny=1 order by K.data desc"; 517 517 command.Parameters.AddWithValue("@agent", User.Instance().Symbol_agenta); 518 command.CommandType = CommandType.Text; 518 519 sqlDataAdapter.Fill(rEKLAMADataSet.KLIENCI); 519 520 clientsDataGridView.Refresh(); … … 528 529 command.CommandText += " where K.AgentExpo=@agent AND K.Aktywny=1 order by K.data desc"; 529 530 command.Parameters.AddWithValue("@agent", User.Instance().Symbol_agenta); 531 command.CommandType = CommandType.Text; 530 532 sqlDataAdapter.Fill(rEKLAMADataSet.KLIENCI); 531 533 clientsDataGridView.Refresh(); … … 540 542 command.CommandText += " where K.UserName=@agent AND K.Aktywny=0 order by K.data desc"; 541 543 command.Parameters.AddWithValue("@agent", User.Instance().Symbol_agenta); 544 command.CommandType = CommandType.Text; 542 545 sqlDataAdapter.Fill(rEKLAMADataSet.KLIENCI); 543 546 clientsDataGridView.Refresh(); … … 552 555 command.CommandText += " where K.AgentExpo=@agent AND K.Aktywny=0 order by K.data desc"; 553 556 command.Parameters.AddWithValue("@agent", User.Instance().Symbol_agenta); 557 command.CommandType = CommandType.Text; 554 558 sqlDataAdapter.Fill(rEKLAMADataSet.KLIENCI); 555 559 clientsDataGridView.Refresh(); … … 567 571 command.CommandText += " left join dbo.AGENCI A on K.UserName = A.Symbol where A.Id_agencji = @idAgencji"; 568 572 command.Parameters.AddWithValue("@idAgencji", e.Node.Name); 573 command.CommandType = CommandType.Text; 569 574 sqlDataAdapter.Fill(rEKLAMADataSet.KLIENCI); 570 575 clientsDataGridView.Refresh(); … … 579 584 command.CommandText += " on K.UserName = A.Symbol where K2.ID_KL_KLIENCI is null AND A.Id_agencji = @idAgencji"; 580 585 command.Parameters.AddWithValue("@idAgencji", e.Node.Name); 586 command.CommandType = CommandType.Text; 581 587 sqlDataAdapter.Fill(rEKLAMADataSet.KLIENCI); 582 588 clientsDataGridView.Refresh(); … … 591 597 command.CommandText += " on K.UserName = A.Symbol where K.aktywny=1 AND KT.id_klienci_tytul is null AND A.Id_agencji = @idAgencji"; 592 598 command.Parameters.AddWithValue("@idAgencji", e.Node.Name); 599 command.CommandType = CommandType.Text; 593 600 sqlDataAdapter.Fill(rEKLAMADataSet.KLIENCI); 594 601 clientsDataGridView.Refresh(); … … 619 626 command.CommandText += " on K.UserName = A.Symbol where K2.ID_KL_KLIENCI is null AND A.Symbol = @symAgenta"; 620 627 command.Parameters.AddWithValue("@symAgenta", e.Node.Name); 628 command.CommandType = CommandType.Text; 621 629 sqlDataAdapter.Fill(rEKLAMADataSet.KLIENCI); 622 630 clientsDataGridView.Refresh(); … … 631 639 command.CommandText += " on K.UserName = A.Symbol where K.aktywny=1 AND KT.id_klienci_tytul is null AND A.Symbol = @symAgenta"; 632 640 command.Parameters.AddWithValue("@symAgenta", e.Node.Name); 641 command.CommandType = CommandType.Text; 633 642 sqlDataAdapter.Fill(rEKLAMADataSet.KLIENCI); 634 643 clientsDataGridView.Refresh(); … … 654 663 command.CommandText += " where UserName=@agent"; 655 664 command.Parameters.AddWithValue("@agent", e.Node.Name); 665 command.CommandType = CommandType.Text; 656 666 sqlDataAdapter.Fill(rEKLAMADataSet.KLIENCI); 657 667 clientsDataGridView.Refresh(); … … 663 673 664 674 rEKLAMADataSet.KLIENCI.Clear(); 665 command.CommandText += "left join dbo.KONTAKTY K2 on K.CustomerId = K2.CustomerID " + 666 "left join dbo.AGENCI A on K.UserName = A.Symbol " + 667 "group by K.AgentExpo, K.kodKlienta, K.CustomerID, K.FirstName, K.LastName, K.OrganizationName, " + 668 "K.Address, K.City, K.State, K.PostalCode, K.Country, K.Nip, K.ContactName, K.PhoneNumber, K.FaxNumber," + 669 "K.Note, K.data, K.Adres_Fkatura, K.Adres_Kor, K.Platnik_VAT, K.Aktywny, " + 670 "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 " + 671 "HAVING datediff(day,max(K2.data),getdate()) > @param1 AND datediff(day,max(K2.data),getdate()) <@param2 " + 672 "AND A.Id_agencji = @idAgencji order by datediff(day,max(K2.data),getdate()) desc"; 673 command.Parameters.AddWithValue("@idAgencji", e.Node.Parent.Parent.Name); 674 command.Parameters.AddWithValue("@param1", e.Node.Name); 675 675 676 command.CommandText = "sp_GetClientsWithNoContact"; 677 command.CommandType = CommandType.StoredProcedure; 678 679 command.Parameters.AddWithValue("@agencyId", e.Node.Parent.Parent.Name); 680 command.Parameters.AddWithValue("@numberOfDaysStart", e.Node.Name); 676 681 if (e.Node.NextNode != null) 677 { 678 command.Parameters.AddWithValue("@param2", e.Node.NextNode.Name); 679 } 682 command.Parameters.AddWithValue("@numberOfDaysEnd", e.Node.NextNode.Name); 680 683 else 681 { 682 command.Parameters.AddWithValue("@param2", "9999"); 683 } 684 command.Parameters.AddWithValue("@numberOfDaysEnd", 9999); 684 685 685 686 sqlDataAdapter.Fill(rEKLAMADataSet.KLIENCI); … … 787 788 788 789 rEKLAMADataSet.KLIENCI.Clear(); 790 command.CommandType = CommandType.Text; 789 791 790 792 sqlDataAdapter.Fill(rEKLAMADataSet.KLIENCI);
