public override void Init(SIEESettings settings) { base.Init(settings); mySettings = settings as SqlEESettings; mySettings.Login(sqlClient); sqlClient.DefaultTable = mySettings.SelectedTable; sqlClient.SetCulture(new CultureInfo(mySettings.SelectedCultureInfoName)); }
public void T05_CultureInfo() { ISqlClient sqlClient = getClient(); foreach (SqlColumn col in sqlClient.GetColumns(testTable).Where(n => n.SqlType != null)) { List <SqlColumn> lc = new List <SqlColumn>(); lc.Add(col); switch (col.SqlType.DotNetType.ToString()) { case SqlTypes.DateTime_TypeName: col.ValueString = "03.04.2016"; sqlClient.SetCulture(new CultureInfo("de-DE")); sqlClient.SetObjectValues(lc); Assert.AreEqual(4, ((DateTime)col.ValueObject).Month); sqlClient.SetCulture(new CultureInfo("en-US")); sqlClient.SetObjectValues(lc); Assert.AreEqual(3, ((DateTime)col.ValueObject).Month); break; case SqlTypes.Decimal_TypeName: col.ValueString = "1.234,56"; sqlClient.SetCulture(new CultureInfo("de-DE")); sqlClient.SetObjectValues(lc); Assert.AreEqual((decimal)1234.56, col.ValueObject); col.ValueString = "1,234.56"; sqlClient.SetCulture(new CultureInfo("en-US")); sqlClient.SetObjectValues(lc); Assert.AreEqual((decimal)1234.56, col.ValueObject); break; case SqlTypes.Double_TypeName: col.ValueString = "1.234,5678"; sqlClient.SetCulture(new CultureInfo("de-DE")); sqlClient.SetObjectValues(lc); Assert.AreEqual(1234.5678, col.ValueObject); col.ValueString = "1,234.5678"; sqlClient.SetCulture(new CultureInfo("en-US")); sqlClient.SetObjectValues(lc); Assert.AreEqual(1234.5678, col.ValueObject); break; default: break; } } }