/// <summary>日處理執行區</summary>
private void booking_mayday_tickets(object work)
{
UpdateLableHandler delegate_result = new UpdateLableHandler(printResult);
try
{
TicketSetting setting = readSettings("tickets.json");
if (setting == null)
{
this.Invoke(delegate_result, "沒有設定訂票資訊，請key好再來");
}
var service = new GetMaydayTicketService(GetMaydayTicketService.MAYDAY_TICKEY_TEST_URL, setting);
string msg = service.start();
if (!string.IsNullOrWhiteSpace(msg))
{
this.Invoke(delegate_result, msg);
}
service.end();
}
catch (Exception ex)
{
this.Invoke(delegate_result, ex.Message);
}
}
private void ImportFile(object parameter)
{
string fileFold = parameter.ToString();
if (!Directory.Exists(fileFold))
{
return;
}
DirectoryInfo directoryInfo = new DirectoryInfo(fileFold);
bool isExistSuccess = false;
foreach (var item in directoryInfo.GetFiles())
{
string fileFullName = item.FullName;
UpdateLableHandler updateFileHandler = new UpdateLableHandler(UpdateFileName);
lblFileName.Invoke(updateFileHandler, $"正在读取文件：" + fileFullName);
DataTable table = _importFileService.GetDataTableFromExcelFile(fileFullName, string.Empty);
if (table == null)
{
MessageBox.Show("读取文件失败，文件路径：" + fileFullName);
lblFileName.Invoke(updateFileHandler, $"读取文件失败，文件路径：" + fileFullName);
continue;
}
isExistSuccess = true;
UpdateDgvHandler updateDgvHandler = new UpdateDgvHandler(UpdateDgv);
dgvOrgionView.Invoke(updateDgvHandler, table);
lblFileName.Invoke(updateFileHandler, $"正在导入文件到数据库：" + fileFullName);
InsertOrgionDataIntoDB(table, item.Name);
lblFileName.Invoke(updateFileHandler, $"导入文件到数据库完成：" + fileFullName);
}
UpdateControlHandler updateControlHandler = new UpdateControlHandler(UpdateControl);
processBarImport.Invoke(updateControlHandler);
if (!isExistSuccess)
{
UpdateDgvHandler updateDgvHandler = new UpdateDgvHandler(UpdateDgv);
dgvOrgionView.Invoke(updateDgvHandler, new DataTable());
MessageBox.Show("数据导入完成,但没读取到任何数据!");
return;
}
MessageBox.Show("数据导入完成!");
}
