1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91
|
connexion = new SqlConnection(connexionString);
connexion.Open();
string request = "SELECT * FROM [PRICING].[dbo].[XCustomer]";
// Chargement de la liste des xcustomers dans le dataSet
SqlDataAdapter adapter = new SqlDataAdapter(request, connexion);
DataSet dataSet = new DataSet("XCustomer");
adapter.Fill(dataSet, "XCustomer");
// Paramètrage de la commande InsertCommand
SqlCommand command = new SqlCommand("INSERT INTO [PRICING].[dbo].[XCustomer] ([CustomerId], [SalesOrganisation], [DistributionChannel], [Division], [Name1], [Name2], [Street1], [Street2], [Street3], [HouseNumber], [PostalCode], [City], [RegionDescription], [CountryCode], [CountryDescription], [Phone], [Contact], [Email], [Fax], [Communication], [PriceList], [CustomerGroup], [SalesRepZ4], [SalesRepZ5], [SalesRepZ6], [Language], [PriceGroup], [CustomerIncoterm], [Currency], [ItemProposalNo], [ImportId]) "
"VALUES (@CustomerId, @SalesOrganisation, @DistributionChannel, @Division, @Name1, @Name2, @Street1, @Street2, @Street3, @HouseNumber, @PostalCode, @City, @RegionDescription, @CountryCode, @CountryDescription, @Phone, @Contact, @Email, @Fax, @Communication, @PriceList, @CustomerGroup, @SalesRepZ4, @SalesRepZ5, @SalesRepZ6, @Language, @PriceGroup, @CustomerIncoterm, @Currency, @ItemProposalNo, @ImportId)", connexion);
command.Parameters.Add("@CustomerId", SqlDbType.NVarChar, 10, "CustomerId");
command.Parameters.Add("@SalesOrganisation", SqlDbType.NVarChar, 4, "SalesOrganisation");
command.Parameters.Add("@DistributionChannel", SqlDbType.NVarChar, 2, "DistributionChannel");
command.Parameters.Add("@Division", SqlDbType.NVarChar, 2, "Division");
command.Parameters.Add("@Name1", SqlDbType.NVarChar, 35, "Name1");
command.Parameters.Add("@Name2", SqlDbType.NVarChar, 35, "Name2");
command.Parameters.Add("@Street1", SqlDbType.NVarChar, 40, "Street1");
command.Parameters.Add("@Street2", SqlDbType.NVarChar, 40, "Street2");
command.Parameters.Add("@Street3", SqlDbType.NVarChar, 40, "Street3");
command.Parameters.Add("@HouseNumber", SqlDbType.NVarChar, 35, "HouseNumber");
command.Parameters.Add("@PostalCode", SqlDbType.NVarChar, 10, "PostalCode");
command.Parameters.Add("@City", SqlDbType.NVarChar, 35, "City");
command.Parameters.Add("@RegionDescription", SqlDbType.NVarChar, 35, "RegionDescription");
command.Parameters.Add("@CountryCode", SqlDbType.NVarChar, 3, "CountryCode");
command.Parameters.Add("@CountryDescription", SqlDbType.NVarChar, 35, "CountryDescription");
command.Parameters.Add("@Phone", SqlDbType.NVarChar, 35, "Phone");
command.Parameters.Add("@Contact", SqlDbType.NVarChar, 50, "Contact");
command.Parameters.Add("@Email", SqlDbType.NVarChar, 250, "Email");
command.Parameters.Add("@Fax", SqlDbType.NVarChar, 35, "Fax");
command.Parameters.Add("@Communication", SqlDbType.NVarChar, 50, "Communication");
command.Parameters.Add("@PriceList", SqlDbType.NVarChar, 2, "PriceList");
command.Parameters.Add("@CustomerGroup", SqlDbType.NVarChar, 4, "CustomerGroup");
command.Parameters.Add("@SalesRepZ4", SqlDbType.NVarChar, 6, "SalesRepZ4");
command.Parameters.Add("@SalesRepZ5", SqlDbType.NVarChar, 6, "SalesRepZ5");
command.Parameters.Add("@SalesRepZ6", SqlDbType.NVarChar, 6, "SalesRepZ6");
command.Parameters.Add("@Language", SqlDbType.NVarChar, 2, "Language");
command.Parameters.Add("@PriceGroup", SqlDbType.NVarChar, 2, "PriceGroup");
command.Parameters.Add("@CustomerIncoterm", SqlDbType.NVarChar, 3, "CustomerIncoterm");
command.Parameters.Add("@Currency", SqlDbType.NVarChar, 5, "Currency");
command.Parameters.Add("@ItemProposalNo", SqlDbType.NVarChar, 10, "ItemProposalNo");
command.Parameters.Add("@ImportId", SqlDbType.Int, 4, "ImportId");
adapter.InsertCommand = command;
foreach (XCustomer item in xCustomers)
{
DataRow dataRow = dataSet.Tables["XCustomer"].NewRow();
dataRow["CustomerId"] = item.CustomerId;
dataRow["SalesOrganisation"] = item.SalesOrganisation;
dataRow["DistributionChannel"] = item.DistributionChannel;
dataRow["Division"] = item.Division;
dataRow["ImportId"] = importId;
if (item.Name1 != string.Empty) dataRow["Name1"] = item.Name1; else dataRow["Name1"] = DBNull.Value;
if (item.Name2 != string.Empty) dataRow["Name2"] = item.Name2; else dataRow["Name2"] = DBNull.Value;
if (item.Street1 != string.Empty) dataRow["Street1"] = item.Street1; else dataRow["Street1"] = DBNull.Value;
if (item.Street2 != string.Empty) dataRow["Street2"] = item.Street2; else dataRow["Street2"] = DBNull.Value;
if (item.Street3 != string.Empty) dataRow["Street3"] = item.Street3; else dataRow["Street3"] = DBNull.Value;
if (item.HouseNumber != string.Empty) dataRow["HouseNumber"] = item.HouseNumber; else dataRow["HouseNumber"] = DBNull.Value;
if (item.PostalCode != string.Empty) dataRow["PostalCode"] = item.PostalCode; else dataRow["PostalCode"] = DBNull.Value;
if (item.City != string.Empty) dataRow["City"] = item.City; else dataRow["City"] = DBNull.Value;
if (item.RegionDescription != string.Empty) dataRow["RegionDescription"] = item.RegionDescription; else dataRow["RegionDescription"] = DBNull.Value;
if (item.CountryCode != string.Empty) dataRow["CountryCode"] = item.CountryCode; else dataRow["CountryCode"] = DBNull.Value;
if (item.CountryDescription != string.Empty) dataRow["CountryDescription"] = item.CountryDescription; else dataRow["CountryDescription"] = DBNull.Value;
if (item.Phone != string.Empty) dataRow["Phone"] = item.Phone; else dataRow["Phone"] = DBNull.Value;
if (item.Contact != string.Empty) dataRow["Contact"] = item.Contact; else dataRow["Contact"] = DBNull.Value;
if (item.Email != string.Empty) dataRow["Email"] = item.Email; else dataRow["Email"] = DBNull.Value;
if (item.Fax != string.Empty) dataRow["Fax"] = item.Fax; else dataRow["Fax"] = DBNull.Value;
if (item.Communication != string.Empty) dataRow["Communication"] = item.Communication; else dataRow["Communication"] = DBNull.Value;
if (item.PriceList != string.Empty) dataRow["PriceList"] = item.PriceList; else dataRow["PriceList"] = DBNull.Value;
if (item.CustomerGroup != string.Empty) dataRow["CustomerGroup"] = item.CustomerGroup; else dataRow["CustomerGroup"] = DBNull.Value;
if (item.SalesRepZ4 != string.Empty) dataRow["SalesRepZ4"] = item.SalesRepZ4; else dataRow["SalesRepZ4"] = DBNull.Value;
if (item.SalesRepZ5 != string.Empty) dataRow["SalesRepZ5"] = item.SalesRepZ5; else dataRow["SalesRepZ5"] = DBNull.Value;
if (item.SalesRepZ6 != string.Empty) dataRow["SalesRepZ6"] = item.SalesRepZ6; else dataRow["SalesRepZ6"] = DBNull.Value;
if (item.Language != string.Empty) dataRow["Language"] = item.Language; else dataRow["Language"] = DBNull.Value;
if (item.PriceGroup != string.Empty) dataRow["PriceGroup"] = item.PriceGroup; else dataRow["PriceGroup"] = DBNull.Value;
if (item.CustomerIncoterm != string.Empty) dataRow["CustomerIncoterm"] = item.Name1; else dataRow["CustomerIncoterm"] = DBNull.Value;
if (item.Currency != string.Empty) dataRow["Currency"] = item.Currency; else dataRow["Currency"] = DBNull.Value;
if (item.ItemProposalNo != string.Empty) dataRow["ItemProposalNo"] = item.ItemProposalNo; else dataRow["ItemProposalNo"] = DBNull.Value;
dataSet.Tables["XCustomer"].Rows.Add(dataRow);
}
// Mise à jour de la source de données à partir du dataSet
adapter.Update(dataSet, "XCustomer"); |
Partager