public void TestLoadFromCsv()
{
string path = @"D:\GreyHound\FILES\TMP\DSRoadVehicleFlowMoney.csv";
CsvConfiguration cfg = new CsvConfiguration(CultureInfo.InvariantCulture);
Type tp = typeof(Dictionary <string, object>);
using (SQLServerClientService sqlService = SQLServerClientService.GetInstance(conn1))
{
using (StreamReader st = new StreamReader(path))
{
using (CsvHelperReader csv = new CsvHelperReader(st, cfg))
{
while (csv.Read())
{
Dictionary <string, object> obj = csv.GetRecord();
obj["GroupUID"] = Guid.NewGuid();
obj["SystemUID"] = Guid.NewGuid();
sqlService.InsertItemDict("DSRoadVehicleFlowMoney", obj);
}
}
}
sqlService.Commit();
}
}
public static void LoadCsvData(string tableName, string path, string dbconn, Func <Dictionary <string, object>, bool> preHandler)
{
CsvConfiguration cfg = new CsvConfiguration(CultureInfo.InvariantCulture, hasHeaderRecord: true, delimiter: "\t");
using (SQLServerClientService sqlService = SQLServerClientService.GetInstance(dbconn))
{
using (StreamReader st = new StreamReader(path))
{
using (CsvReader csv = new CsvReader(st, cfg))
{
while (csv.Read())
{
Dictionary <string, object> obj = csv.GetRecord();
if (!preHandler(obj))
{
continue;
}
sqlService.InsertItemDict(tableName, obj);
}
}
}
sqlService.Commit();
}
}
public static bool LoadCsvToDatabase(string tableName, string path, string connString, Func <Dictionary <string, object>, bool> preHandler)
{
using (SQLServerClientService s2 = SQLServerClientService.GetInstance(connString))
{
LoadCsvData(path, (o) =>
{
if (!preHandler(o))
{
return(false);
}
s2.InsertItemDict(tableName, o);
return(true);
});
s2.Commit();
}
return(true);
}
public void InitData()
{
using (SQLServerClientService sqlBase = SQLServerClientService.GetInstance(conn1))
{
Dictionary <string, object> obj = new Dictionary <string, object>()
{
{ "ID", ID1 },
{ "Name", "Name1" },
{ "Age", 1 },
{ "Aliase", null }
};
if (!sqlBase.InsertItemDict(tableName, obj))
{
Assert.Fail("Insert init failed");
}
sqlBase.Commit();
}
}
public void InitPagingData()
{
using (SQLServerClientService sqlBase = SQLServerClientService.GetInstance(conn1))
{
for (int i = 0; i < 10; i++)
{
Dictionary <string, object> obj = new Dictionary <string, object>()
{
{ "ID", Guid.NewGuid() },
{ "Name", "Name" + i },
{ "Age", i },
};
if (!sqlBase.InsertItemDict(tableName, obj))
{
Assert.Fail("InitPagingData init failed");
}
}
sqlBase.Commit();
}
}
