Zbiór zmian 450 dla branches/TruckExpo/BrMerger/Form1.cs

Data:

2009-03-16 17:57:15 (17 years ago)

Autor:

marek

Opis:

re #123

Pliki:

• branches/TruckExpo/BrMerger/Form1.cs (zmodyfikowane) (11 diffs)

branches/TruckExpo/BrMerger/Form1.cs

@@ -36 +36 @@
             SqlConnection conn2 = null;
             SqlConnection conn3 = null;
+            Stopwatch stopwatch = new Stopwatch();
 
             try
             {
+                stopwatch.Start();
                 string connectionString = ConfigurationManager.AppSettings["BazaReklam.ConnectionString"];
 
@@ -66 +68 @@
                        "WHERE CustomerID > 56710 ";
 
-                //cmd1.CommandText = "SELECT COUNT(*) " +
-                //        "FROM " + truckExpoDbName + ".dbo.Klienci " +
-                //        "WHERE CustomerID IN (56922, 56971, 56773) ";
                 m_waitProgressMax = (int)cmd1.ExecuteScalar();
-
 
                 cmd1.CommandText = "SELECT CustomerID, FirstName, LastName, OrganizationName, Address, City, State, PostalCode, Country, Nip, ContactName, PhoneNumber, FaxNumber, " +
@@ -77 +75 @@
                        "WHERE CustomerID > 56710 " +
                        "ORDER BY CustomerID";
-
-
-                //cmd1.CommandText = "SELECT CustomerID, FirstName, LastName, OrganizationName, Address, City, State, PostalCode, Country, Nip, ContactName, PhoneNumber, FaxNumber, " +
-                //           "Note, data, osw_nr, osw_wazne_do, Adres_Fkatura, Old_ID, Adres_Kor, Platnik_VAT, Aktywny, Email, UserName, Last_Modify, Modify_User, http, VIES, regon, krs, nipKraj " +
-                //           "FROM " + truckExpoDbName + ".dbo.Klienci " +
-                //           "WHERE CustomerID IN (56922, 56971, 56773) " +
-                //           "ORDER BY CustomerID";
 
                 SqlDataReader rdrCustomer, rdrReklama, rdrKontakt;
@@ -119 +110 @@
                             "FROM " + truckExpoDbName + ".dbo.Klienci WHERE CustomerID=" + rdrCustomer["CustomerID"];
                         n = cmd3.ExecuteNonQuery();
+
                         nKlienci += n;
 
@@ -168 +160 @@
                                 + bazaReklamDbName + ".dbo.Klienci.Aktywny=E.Aktywny,"
                                 + bazaReklamDbName + ".dbo.Klienci.Email=E.Email,"
-                                + bazaReklamDbName + ".dbo.Klienci.UserName=E.UserName,"
+                                //+ bazaReklamDbName + ".dbo.Klienci.UserName=E.UserName,"
+                                + bazaReklamDbName + ".dbo.Klienci.AgentExpo=E.UserName,"
                                 + bazaReklamDbName + ".dbo.Klienci.Last_Modify=E.Last_Modify,"
                                 + bazaReklamDbName + ".dbo.Klienci.Modify_User=E.Modify_User,"
@@ -284 +277 @@
                             //PotwierdzeniaEcard
                             //pusta
-
-                            ;
                         }
                         else
@@ -312 +303 @@
                             nReklama += n;
                             cmd3.CommandText = "SELECT SCOPE_IDENTITY()";
-                            idReklama = (int)cmd3.ExecuteScalar();
+                            obj1 = cmd3.ExecuteScalar();
+                            idReklama = Convert.ToInt32(obj1);
+
                         }
 
@@ -459 +452 @@
 
                     // dla testów
-                    if (nRead > 100)
-                        break;
+                    //if (nRead > 100)
+                    //    break;
                 }
                 rdrCustomer.Close();
@@ -582 +575 @@
                         }
                         nPlatnosciEcard += n;
-
-
-                        //PotwierdzeniaEcard
-                        //pusta
-
-                        ;
                     }
                     else
@@ -614 +601 @@
                         nReklama += n;
                         cmd3.CommandText = "SELECT SCOPE_IDENTITY()";
-                        idReklama = (int)cmd3.ExecuteScalar();
+                        obj1 = cmd3.ExecuteScalar();
+                        idReklama = Convert.ToInt32(obj1);
                     }
 
@@ -761 +749 @@
                 conn3.Close();
 
+                stopwatch.Stop();
+
                 MessageBox.Show("Zakoñczono ³¹czenie danych.\n" +
+                    " - czas: " + stopwatch.Elapsed.Minutes + " minut, " + stopwatch.Elapsed.Seconds + " sekund" + "\n" +
                     " - klienci: " + nKlienci + "\n" +
                     " - klienci, osoby do kontaktu: " + nKlienci_Osoby_Do_Kontaktu + "\n" +