public static void GetPublishedJobTable_All()
{
DateTime excelLastTime = DateTime.MinValue;
object obj = SQLiteDbHelper.ExecuteScalar("select max([Excel时间]) from job");
DataTable excelTable = SQLiteDbHelper.ExecuteDataTable("select Excel文件 from job group by excel文件");
if (obj != null)
{
DateTime.TryParse(obj.ToString(), out excelLastTime);
}
//检索Excel文件
FileInfo[] files = new DirectoryInfo(@"\\128.1.30.112\Downloads").GetFiles("*.xls");
foreach (FileInfo file in files)
{
//删除超过日期的信息
if (file.LastWriteTime < excelLastTime)
{
continue;
}
//判断Excel文件名是否存在
string excelFileName = Path.GetFileNameWithoutExtension(file.FullName);
DataRow[] rows = excelTable.Select("[Excel文件]='" + excelFileName + "'");
//如果不存在，则添加
if (rows == null || rows.Length == 0)
{
//读取Excel里面的作业信息，并返回一个DataTable
DataTable dt_excel = GetPublishDataTableFromExcelFile(file.FullName);
if (dt_excel != null)
{
//添加
JobService.Add(dt_excel);
}
}
}
}
