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;
}
}
}
