public async Task <IActionResult> UploadProductConfiguration(IFormFile file)
{
if (file == null)
{
return(BadRequest());
}
var configPath = Path.Combine(env.WebRootPath, "upload", "产品配置.xlsx");
using (FileStream fs = System.IO.File.Create(configPath))
{
file.CopyTo(fs);
fs.Flush();
}
var dic = new Dictionary <string, string>();
using (var package = new ExcelPackage(new FileInfo(configPath)))
{
var accessoriesSheet = package.Workbook.Worksheets.FirstOrDefault(x => x.Name == "五金配件");
if (accessoriesSheet != null)
{
var setting = new SettingsItem
{
Key = "Accessories",
Value = accessoriesSheet.ContentToString()
};
await settingRepository.CreateOrUpdateAsync(setting);
}
var panelMergeSheet = package.Workbook.Worksheets.FirstOrDefault(x => x.Name == "合并表");
if (panelMergeSheet != null)
{
var setting = new SettingsItem
{
Key = "PanelMerge",
Value = panelMergeSheet.ContentToString()
};
await settingRepository.CreateOrUpdateAsync(setting);
}
var panelProductCategorySheet = package.Workbook.Worksheets.FirstOrDefault(x => x.Name == "柜子类型");
if (panelProductCategorySheet != null)
{
var setting = new SettingsItem
{
Key = "PanelProductCategory",
Value = panelProductCategorySheet.ContentToString()
};
await settingRepository.CreateOrUpdateAsync(setting);
}
var panelProductsSheet = package.Workbook.Worksheets.FirstOrDefault(x => x.Name == "风格表");
if (panelProductsSheet != null)
{
var setting = new SettingsItem
{
Key = "PanelProducts",
Value = panelProductsSheet.ContentToString()
};
await settingRepository.CreateOrUpdateAsync(setting);
}
var panelReplaceProductsSheet = package.Workbook.Worksheets.FirstOrDefault(x => x.Name == "替换表");
if (panelReplaceProductsSheet != null)
{
var setting = new SettingsItem
{
Key = "PanelReplaceProducts",
Value = panelReplaceProductsSheet.ContentToString()
};
await settingRepository.CreateOrUpdateAsync(setting);
}
}
return(NoContent());
}
