private void CreateInventoryPriceExcelAction(IWorkbook wb, ISheet ws, ICellStyle positionStyle, ref int rowIndex, StoreSearchData <InventoryPrice> storeData)
{
XSSFRow rowTextile = (XSSFRow)ws.CreateRow(rowIndex);
ExcelHelper.CreateCell(rowTextile, 0, storeData.TextileName, positionStyle);
int countInventoryTotal = 0;
foreach (var item in storeData.StoreSearchColorDetails)
{
countInventoryTotal += item.CountInventory;
}
var textile = FabricList.Where(w => w.FabricName == storeData.TextileName).FirstOrDefault();
//未匯入Sql的布種不予計算
if (textile != null)
{
ExcelHelper.CreateCell(rowTextile, 1, countInventoryTotal.ToString(), positionStyle);
ExcelHelper.CreateCell(rowTextile, 2, (countInventoryTotal * 20 * textile.AverageUnitPrice).ToString(), positionStyle);
ExcelHelper.CreateCell(rowTextile, 3, (countInventoryTotal * 20 * textile.AverageCost).ToString(), positionStyle);
}
rowIndex++;
}
/// <summary>
/// 建立檢查時間點盤點清單
/// </summary>
/// <param name="wb"></param>
/// <param name="ws"></param>
/// <param name="positionStyle"></param>
/// <param name="rowIndex"></param>
/// <param name="storeData"></param>
/// <returns></returns>
private void CreateCheckDateExcelAction(IWorkbook wb, ISheet ws, ICellStyle positionStyle, ref int rowIndex, StoreSearchData <InventoryCheck> storeData)
{
XSSFRow rowTextile = (XSSFRow)ws.CreateRow(rowIndex);
ExcelHelper.CreateCell(rowTextile, 0, storeData.TextileName, positionStyle);
ws.AddMergedRegion(new CellRangeAddress(rowIndex, rowIndex, 0, 2));
ws.AddMergedRegion(new CellRangeAddress(rowIndex, rowIndex, 5, 7));
foreach (var item in storeData.StoreSearchColorDetails.OrderBy(o => o.CheckDate))
{
rowIndex++;
XSSFRow rowColor = (XSSFRow)ws.CreateRow(rowIndex);
ExcelHelper.CreateCell(rowColor, 0, item.ColorName, positionStyle);
ExcelHelper.CreateCell(rowColor, 1, item.StorageSpaces, ExcelHelper.GetColorByStorageSpaces(wb, item.StorageSpaces));
ExcelHelper.CreateCell(rowColor, 2, item.CountInventory, positionStyle);
ExcelHelper.CreateCell(rowColor, 3, item.CheckDate?.ToString("MM/dd"), positionStyle);
}
rowIndex++;
}