/// <summary>
/// 导入总方法
/// </summary>
public void Import(BizProduct bizProduct, BizSupplier bizSupplier)
{
//1 读取Excel列表
IList <Product> ProductsInExcel = ReadProductsFromExcel(CheckExcelFile());
//2 检查图片是否存在
CheckProductImages(ProductsInExcel);
//检查数据库
if (NeedCheckWithDB)
{
//1 检查 供应商是否存在
IList <string> supplierNameList = GetSupplierNameList(ProductsInExcel);
IList <string> supplierNameList_NotExists;
IList <Supplier> supplierList = bizSupplier.GetListByNameList(supplierNameList, out supplierNameList_NotExists);
if (supplierNameList_NotExists.Count > 0)
{
foreach (string supplierName in supplierNameList_NotExists)
{
sbImportMsg.AppendLine("不存在该供应商:" + supplierName);
}
return;
}
//2 检查数据是否已经导入
IList <Product> productsExisted;
ProductsPassedDBCheck = bizProduct.CheckDB(ProductsHasImage, out productsExisted);
ProductsExistedInDB = productsExisted;
foreach (Product productExist in ProductsExistedInDB)
{
sbImportMsg.AppendLine("已存在该产品.供应商/型号:" + productExist.SupplierName + "/" + productExist.ModelNumber);
}
}
//数据保存到数据库
// bizProduct.SaveList(
}
public void ImportWithDBCheck(BizProduct bizProduct, BizSupplier bizSupplier)
{
}
