public string ImportExcelFiles(string path)
{
var factory = new ExcelQueryFactory {
FileName = path
};
const string sheetName = "工单查询结果";
var infos = (from c in factory.Worksheet <WorkItemExcel>(sheetName)
select c).ToList();
var oldInfos = from info in infos
join item in _repository.GetAllList() on info.SerialNumber equals item.SerialNumber
select info;
var newInfos = infos.Except(oldInfos).ToList();
var newItems = Mapper.Map <List <WorkItemExcel>, IEnumerable <WorkItem> >(newInfos);
foreach (var oldInfo in oldInfos)
{
_repository.Import(oldInfo);
}
var count = 0;
foreach (var item in newItems)
{
if (_repository.Insert(item) != null)
{
count++;
}
}
return("完成工单导入：" + count + "条");
}
