/// <summary>
/// 获取文件名信息 1一般文件 2压缩文件 3 T8一般文件 4 T8压缩文件
/// </summary>
/// <param name="type">1一般文件 2压缩文件</param>
/// <returns></returns>
public virtual AFileName GetGenerateFileNameStragety(int type)
{
AFileName aFileName = null;
switch (type)
{
case 1:
aFileName = AutoFacContainer.ResolveNamed <AFileName>(typeof(GeneralFileName).Name);
break;
case 2:
aFileName = AutoFacContainer.ResolveNamed <AFileName>(typeof(CompressFileName).Name);
break;
case 3:
aFileName = AutoFacContainer.ResolveNamed <AFileName>(typeof(T8GeneralFileName).Name);
break;
case 4:
aFileName = AutoFacContainer.ResolveNamed <AFileName>(typeof(T8CompressFileName).Name);
break;
default:
throw new ArgumentNullException("GetSqlQueryTimeStragety()方法，参数type值错误");
}
return(aFileName);
}
public override void BuildDbFile()
{
Action <TaskEntity> action = t8Task =>
{
try
{
BuildInstanceObject buildInstanceService = new BuildInstanceObject();
//1得到数据库文件路径
AFileName fileNameStragety = buildInstanceService.GetGenerateFileNameStragety(3);
ISqlQueryTime SqlQueryTimeStragety = buildInstanceService.GetSqlQueryTimeStragety(t8Task.CycleType);
FileInfoEntity fileInfoEntity = new FileInfoEntity();
fileInfoEntity.NormalFileName = fileNameStragety.FileName(t8Task);
fileInfoEntity.NormalFilePath = fileNameStragety.FileFullName(t8Task);
fileInfoEntity.SqlStartTime = SqlQueryTimeStragety.StartTime(DateTime.Now);
fileInfoEntity.SqlEndTime = SqlQueryTimeStragety.EndTime(DateTime.Now);
t8Task.FileInfo = fileInfoEntity;
//2创建数据库文件并添加数据
IDataHandler handler = DataHandlerFactory.GetHandler(t8Task.DataHandler);
handler.DBConnectStr = Common.DecryptData(t8Task.DBConnectString_Hashed);
string sql = t8Task.SQL;
bool isSuccess = handler.OutputDataToSQLite(sql, fileInfoEntity.SqlStartTime, fileInfoEntity.SqlEndTime, fileInfoEntity.NormalFilePath);
Thread.Sleep(300);
if (!isSuccess)
{
LogUtil.WriteLog($"从数据库向数据文件[{fileInfoEntity.NormalFilePath}]导入数据出现错误");
throw new Exception($"从数据库向数据文件[{fileInfoEntity.NormalFilePath}]导入数据出现错误");
}
LogUtil.WriteLog($"数据文件[{fileInfoEntity.NormalFilePath}]创建并添加数据完成");
}
catch (Exception ex)
{
LogUtil.WriteLog(ex);
throw new Exception(ex.Message);
}
};
product.AddPart(action);
}