public void AddRow(BomData bomData)
{
int start = bomData.Level * 3;
// int tempRow = CurRow - bomData.Level;
bomData.row = CurRow;
bomData.colum = start + 1;
slDocument.SetCellValue(CurRow, start + 1, bomData.Bom.Name);
slDocument.SetCellValue(CurRow, start + 2, bomData.Bom.ID);
slDocument.SetCellValue(CurRow, start + 3, bomData.Bom.Node);
}
private void SetReportBOM(ReportData rd, BOM bom, int level = 0)
{
BomData bd = new BomData();
bd.Level = level;
bd.Bom = bom;
rd.BomData.Add(bd);
foreach (var sitem in bom.Son)
{
SetReportBOM(rd, sitem, level + 1);
}
}
private void CreateReportBOM(BOM bom, int level)
{
Stact.Add(bom);
BomData bd = new BomData();
bd.Level = level;
bd.Bom = bom;
AddRow(bd);
for (int i = 0; i < bom.Son.Count; i++)
{
if (i != 0)
{
CurRow++;
}
CreateReportBOM(bom.Son[i], level + 1);
}
slDocument.MergeWorksheetCells(bd.row, bd.colum, CurRow, bd.colum);
slDocument.MergeWorksheetCells(bd.row, bd.colum + 1, CurRow, bd.colum + 1);
slDocument.MergeWorksheetCells(bd.row, bd.colum + 2, CurRow, bd.colum + 2);
}
