/// <summary>
/// 将原始数据读入到数据集合
/// </summary>
/// <param name="sqlStr"> sql语句 </param>
/// <param name="data"> 数据集合 </param>
/// <param name="config">配置</param>
private void GetOriginalValueFromDB(string sqlStr, OriginalConfig config, IList <OriginalData> data)
{
OriginalData od;
DataTable dt = SqlHelper.ExecuteDataSetText(sqlStr, null).Tables[0];
foreach (DataRow row in dt.Rows)
{
od = new OriginalData();
od.SensorId = Convert.ToInt32(row[0]);
od.AcquisitionTime = Convert.ToDateTime(row[1]);
od.Location = Convert.ToString(row[2]);
od.Values = new decimal[row.ItemArray.Length - 3];
for (int i = 3; i < row.ItemArray.Length; i++)
{
if (row[i] != DBNull.Value)
{
od.Values[i - 3] =
Convert.ToDecimal(Convert.ToDecimal(row[i]).ToString("f" + config.DecimalDigits[i - 3]));
}
}
od.Columns = config.Display;
od.Unit = config.Unit;
data.Add(od);
}
}
public TestEnvironmoent()
{
// Backup config and override on filesystem with new.
OriginalConfig = IConfig <LoaderConfig> .FromPathOrDefault(Paths.LoaderConfigPath);
TestConfig = MakeTestConfig();
if (OriginalConfig.GetApplicationConfigDirectory() != TestConfig.GetApplicationConfigDirectory())
{
IConfig <LoaderConfig> .ToPath(OriginalConfig, $"{Paths.LoaderConfigPath}.bak");
}
IConfig <LoaderConfig> .ToPath(TestConfig, Paths.LoaderConfigPath);
try
{
// Populate configurations.
ModConfigurationTuples = ModConfig.GetAllMods().ToArray();
ModConfigurations = ModConfigurationTuples.Select(x => x.Config).ToArray();
AppConfigurations = ApplicationConfig.GetAllApplications().Select(x => x.Config).ToArray();
ThisApplication = new ApplicationConfig(IdOfThisApp,
"Reloaded Mod Loader Tests",
Environment.CurrentProcessLocation.Value,
new[] { TestModConfigA.ModId, TestModConfigB.ModId, TestModConfigD.ModId });
ConfigurationPathOfThisApp = Path.Combine(TestConfig.GetApplicationConfigDirectory(), IdOfThisApp, ApplicationConfig.ConfigFileName);
IConfig <ApplicationConfig> .ToPath(ThisApplication, ConfigurationPathOfThisApp);
// Populate nonexisting dependencies.
NonexistingDependencies.Add(TestModB.Program.NonexistingDependencyName);
NonexistingDependencies.Add(TestModC.Program.NonexistingDependencyName);
// Create user configs if necessary.
ModConfigService = new ModConfigService(TestConfig);
UserConfigService = new ModUserConfigService(TestConfig, ModConfigService);
}
catch (Exception)
{
IConfig <LoaderConfig> .ToPath(OriginalConfig, Paths.LoaderConfigPath);
throw;
}
}
