public void PopulateDocument(int markId, MemoryStream memory)
{
var mark = _markRepo.GetById(markId);
if (mark == null)
{
throw new ArgumentNullException(nameof(mark));
}
var subnode = mark.Subnode;
var node = subnode.Node;
var project = node.Project;
var departmentHead = _employeeRepo.GetByDepartmentIdAndPosition(
mark.Department.Id, _appSettings.DepartmentHeadPosId);
if (departmentHead == null)
{
departmentHead = _employeeRepo.GetByDepartmentIdAndPosition(
mark.Department.Id, _appSettings.ActingDepartmentHeadPosId);
}
if (departmentHead == null)
{
departmentHead = _employeeRepo.GetByDepartmentIdAndPosition(
mark.Department.Id, _appSettings.DeputyDepartmentHeadPosId);
}
if (departmentHead == null)
{
departmentHead = _employeeRepo.GetByDepartmentIdAndPosition(
mark.Department.Id, _appSettings.ActingDeputyDepartmentHeadPosId);
}
if (departmentHead == null)
{
throw new ConflictException();
}
// Вкл в состав спецификации
var constructions = _constructionRepo.GetAllByMarkId(markId);
var standardConstructions = _standardConstructionRepo.GetAllByMarkId(markId);
var opCond = _markOperatingConditionsRepo.GetByMarkId(markId);
if (opCond == null)
{
throw new ArgumentNullException(nameof(opCond));
}
var estTask = _estimateTaskRepo.GetByMarkId(markId);
if (estTask == null)
{
throw new ArgumentNullException(nameof(estTask));
}
var markApprovals = new List <MarkApproval> {
};
if (estTask.ApprovalEmployee != null)
{
markApprovals.Add(new MarkApproval
{
MarkId = markId,
Employee = estTask.ApprovalEmployee,
});
}
using (WordprocessingDocument wordDoc = WordprocessingDocument.Open(memory, true))
{
var markName = MarkHelper.MakeMarkName(
project.BaseSeries, node.Code, subnode.Code, mark.Code);
(var complexName, var objectName) = MarkHelper.MakeComplexAndObjectName(
project.Name, node.Name, subnode.Name, mark.Name);
AppendText(wordDoc, estTask.TaskText);
var arr = new List <ListText>
{
new ListText
{
Text = "Изготовление и монтаж конструкций",
LevelNum = 0,
IsBold = true,
WithSuperscript = false,
},
new ListText
{
Text = "Дополнительно учитывать:",
LevelNum = 4,
IsBold = false,
WithSuperscript = false,
},
new ListText
{
Text = $"коэффициент надежности по ответственности: {opCond.SafetyCoeff}",
LevelNum = 2,
IsBold = false,
WithSuperscript = false,
},
new ListText
{
Text = $"среда: {opCond.EnvAggressiveness.Name}",
LevelNum = 2,
IsBold = false,
WithSuperscript = false,
},
new ListText
{
Text = $"расчетная температура эксплуатации: {(opCond.Temperature < 0 ? ("минус " + -opCond.Temperature) : opCond.Temperature)}",
LevelNum = 2,
IsBold = false,
WithSuperscript = false,
},
};
AppendList(wordDoc, arr);
arr = new List <ListText> {
};
double overallInitialWeightSum = 0.0;
double overallAreaSum = 0.0;
foreach (var construction in constructions)
{
arr.Add(new ListText
{
Text = construction.Name,
LevelNum = 1,
IsBold = false,
WithSuperscript = false,
});
if (construction.Valuation != null)
{
arr.Add(new ListText
{
Text = $"Расценка: {construction.Valuation}",
LevelNum = 5,
IsBold = false,
WithSuperscript = false,
});
}
if (construction.StandardAlbumCode != null)
{
arr.Add(new ListText
{
Text = $"Шифр типового альбома конструкций: {construction.StandardAlbumCode}",
LevelNum = 5,
IsBold = false,
WithSuperscript = false,
});
}
if (construction.NumOfStandardConstructions != 0)
{
arr.Add(new ListText
{
Text = $"Число типовых конструкций: {construction.NumOfStandardConstructions}",
LevelNum = 5,
IsBold = false,
WithSuperscript = false,
});
}
if (construction.HasEdgeBlunting)
{
arr.Add(new ListText
{
Text = "Притупление кромок",
LevelNum = 5,
IsBold = false,
WithSuperscript = false,
});
}
if (construction.HasDynamicLoad)
{
arr.Add(new ListText
{
Text = "Динамическая нагрузка",
LevelNum = 5,
IsBold = false,
WithSuperscript = false,
});
}
if (construction.HasFlangedConnections)
{
arr.Add(new ListText
{
Text = "Фланцевые соединения",
LevelNum = 5,
IsBold = false,
WithSuperscript = false,
});
}
if (construction.WeldingControl.Id > 1)
{
arr.Add(new ListText
{
Text = $"Контроль плотности сварных швов {construction.WeldingControl.Name}",
LevelNum = 5,
IsBold = false,
WithSuperscript = false,
});
}
var constructionElements = _constructionElementRepo.GetAllByConstructionId(construction.Id);
if (constructionElements.Count() > 0)
{
var groupedSteel = constructionElements.Where(
v => v.Steel != null).GroupBy(v => v.Steel).Select(
v => new GroupedSteel
{
Name = v.First().Steel.Name,
Length = v.Sum(v => v.Length),
Weight = v.Sum(v => v.Profile.Weight),
Area = v.Sum(v => v.Profile.Area),
});
arr.Add(new ListText
{
Text = "в том числе по маркам стали:",
LevelNum = 5,
IsBold = false,
WithSuperscript = false,
});
double initialWeightSum = 0.0;
double areaSum = 0.0;
foreach (var s in groupedSteel)
{
// var initialWeightValue = s.Weight * s.Length * 0.001;
// var initialWeightValueRounded = Math.Ceiling(initialWeightValue * 1000) / 1000;
var initialWeightValueRounded = Math.Ceiling(
s.Weight * s.Length) / 1000;
var finalWeightValueRounded = Math.Ceiling(
initialWeightValueRounded * 1040) / 1000;
arr.Add(new ListText
{
// Text = $"{s.Name} {initialWeightValueRounded} x 1,04 = {Math.Ceiling(initialWeightValueRounded * 1.04 * 1000) / 1000} т",
Text = $"{s.Name} {initialWeightValueRounded.ToStringWithComma()} x 1,04 = {finalWeightValueRounded.ToStringWithComma()} т",
LevelNum = 6,
IsBold = false,
WithSuperscript = false,
});
// initialWeightSum += initialWeightValue;
initialWeightSum += initialWeightValueRounded;
areaSum += s.Area * s.Length;
}
overallInitialWeightSum += initialWeightSum;
var initialWeightSumRounded = Math.Ceiling(
initialWeightSum * 1000) / 1000;
var finalWeightSumRounded = Math.Ceiling(
initialWeightSumRounded * 1040) / 1000;
arr.Add(new ListText
{
// Text = $"Итого масса металла: {initialWeightSumRounded} x 1,04 = {Math.Ceiling(initialWeightSumRounded * 1.04 * 1000) / 1000} т",
Text = $"Итого масса металла: {initialWeightSumRounded.ToStringWithComma()} x 1,04 = {finalWeightSumRounded.ToStringWithComma()} т",
LevelNum = 5,
IsBold = false,
WithSuperscript = false,
});
var areaSumRounded = Math.Round(areaSum, 3);
// overallAreaSum += areaSum;
overallAreaSum += areaSumRounded;
arr.Add(new ListText
{
// Text = $"Площадь поверхности для окраски: {Math.Round(areaSum, 3).ToStringWithComma()} x 100 м^2",
Text = $"Площадь поверхности для окраски: {areaSumRounded.ToStringWithComma()} x 100 м^2",
LevelNum = 5,
IsBold = false,
WithSuperscript = true,
});
arr.Add(new ListText
{
// Text = $"Относительная площадь окраски: {Math.Round(areaSum * 100 / (initialWeightSum * 1.04), 3).ToStringWithComma()} м^2/т",
Text = $"Относительная площадь окраски: {Math.Round(areaSumRounded * 100 / (initialWeightSumRounded * 1.04), 1).ToStringWithComma()} м^2/т",
LevelNum = 5,
IsBold = false,
WithSuperscript = true,
});
}
}
foreach (var standardConstruction in standardConstructions)
{
arr.Add(new ListText
{
Text = $"{standardConstruction.Name}: {(Math.Ceiling(standardConstruction.Weight * 1000) / 1000).ToStringWithComma()} т",
LevelNum = 1,
IsBold = false,
WithSuperscript = false,
});
}
arr.Add(new ListText
{
Text = "Окраска конструкций",
LevelNum = 0,
IsBold = true,
WithSuperscript = false,
});
var overallInitialWeightSumRounded = Math.Ceiling(
overallInitialWeightSum * 1000) / 1000;
var overallFinalWeightSumRounded = Math.Ceiling(
overallInitialWeightSumRounded * 1040) / 1000;
arr.Add(new ListText
{
// Text = $"Масса металла для окраски: {Math.Round(overallInitialWeightSum, 3)} x 1,04 = {Math.Round(Math.Round(overallInitialWeightSum, 3) * 1.04, 3)} т",
Text = $"Масса металла для окраски: {overallInitialWeightSumRounded.ToStringWithComma()} x 1,04 = {overallFinalWeightSumRounded.ToStringWithComma()} т",
LevelNum = 4,
IsBold = false,
WithSuperscript = false,
});
arr.Add(new ListText
{
Text = $"Площадь поверхности для окраски: {Math.Round(overallAreaSum, 3).ToStringWithComma()} x 100 м^2",
LevelNum = 4,
IsBold = false,
WithSuperscript = true,
});
var points = _markGeneralDataPointRepo.GetAllByMarkAndSectionId(
markId, _paintingGeneralDataSectionId);
for (int i = 1; i < points.Count(); i++)
{
var pointText = points.ToList()[i].Text;
if (pointText[0] == '#' && pointText[1] == ' ')
{
pointText = pointText.Substring(2) + ".";
}
else if (pointText[0] == '-' && pointText[1] == ' ')
{
pointText = pointText.Substring(2) + ".";
}
arr.Add(new ListText
{
Text = pointText,
LevelNum = 3,
IsBold = false,
WithSuperscript = false,
});
}
if (estTask.AdditionalText != null && estTask.AdditionalText != "")
{
arr.Add(new ListText
{
Text = "Дополнительно",
LevelNum = 0,
IsBold = true,
WithSuperscript = false,
});
var split = estTask.AdditionalText.Split("\n");
foreach (var splitText in split)
{
arr.Add(new ListText
{
Text = splitText,
LevelNum = 3,
IsBold = false,
WithSuperscript = false,
});
}
}
AppendList(wordDoc, arr);
Word.AppendToBigFooterTable(
wordDoc,
markName,
complexName,
objectName,
-1,
mark,
markApprovals.ToList(),
departmentHead);
Word.AppendToSmallFooterTable(wordDoc, markName);
}
}
private void AppendConstruction(
List <GroupedElement> groupedConstructionElements,
ref int num,
int i,
List <TableCell> trCells,
TableRow secondTr,
OpenXmlElement newTr,
OpenXmlElement clonedSecondTr,
Table t)
{
var steelMap = new Dictionary <string, double> {
};
var elementSum = 0.0;
var areaSum = 0.0;
for (int j = 0; j < groupedConstructionElements.Count(); j++)
{
var steelArr = groupedConstructionElements[j].Steel;
var steelSum = 0.0;
for (int k = 0; k < steelArr.Count(); k++)
{
var profileArr = steelArr[k].Profiles;
var profileSum = 0.0;
for (int z = 0; z < profileArr.Count(); z++)
{
if (i == 0 && j == 0 && k == 0 && z == 0)
{
trCells = secondTr.Descendants <TableCell>().ToList();
}
else
{
newTr = clonedSecondTr.CloneNode(true);
trCells = newTr.Descendants <TableCell>().ToList();
}
if (k == 0 && z == 0)
{
trCells[0].GetFirstChild <Paragraph>().Append(
Word.GetTextElement(groupedConstructionElements[j].Name, 24));
trCells[0].GetFirstChild <TableCellProperties>().Append(new VerticalMerge
{
Val = MergedCellValues.Restart,
});
}
else
{
trCells[0].GetFirstChild <TableCellProperties>().Append(new VerticalMerge {
});
}
if (z == 0)
{
trCells[1].GetFirstChild <Paragraph>().Append(
Word.GetTextElement(steelArr[k].Name, 24));
var run = Word.GetTextElement(" по", 24);
run.AppendChild(new Break());
trCells[1].GetFirstChild <Paragraph>().Append(run);
var split = steelArr[k].Standard.Split("по ");
trCells[1].GetFirstChild <Paragraph>().Append(
Word.GetTextElement(split[1], 24));
if (profileArr.Count > 1)
{
trCells[1].GetFirstChild <TableCellProperties>().Append(new VerticalMerge
{
Val = MergedCellValues.Restart,
});
}
}
else
{
trCells[1].GetFirstChild <TableCellProperties>().Append(new VerticalMerge {
});
}
trCells[2].GetFirstChild <Paragraph>().Append(
Word.GetTextElement(
profileArr[z].Symbol, 24, false, false, false, profileArr[z].Symbol == "s="));
trCells[2].GetFirstChild <Paragraph>().Append(
Word.GetTextElement(profileArr[z].Name, 24));
trCells[3].GetFirstChild <Paragraph>().Append(
Word.GetTextElement(num.ToString(), 24));
trCells[4].GetFirstChild <Paragraph>().Append(
Word.GetTextElement(profileArr[z].Length.ToStringWithComma(), 24));
trCells[5].GetFirstChild <Paragraph>().Append(
Word.GetTextElement(profileArr[z].Weight.ToStringWithComma(), 24));
num++;
Word.MakeBordersThin(trCells);
profileSum += profileArr[z].Weight;
areaSum += profileArr[z].Area;
if (i != 0 || j != 0 || k != 0 || z != 0)
{
t.Append(newTr);
}
}
if (steelMap.ContainsKey(steelArr[k].Name))
{
steelMap[steelArr[k].Name] += profileSum;
}
else
{
steelMap.Add(steelArr[k].Name, profileSum);
}
newTr = clonedSecondTr.CloneNode(true);
trCells = newTr.Descendants <TableCell>().ToList();
Word.MakeBordersThin(trCells);
trCells[0].GetFirstChild <TableCellProperties>().Append(new VerticalMerge {
});
trCells[1].GetFirstChild <Paragraph>().Append(
Word.GetTextElement("Итого:", 24));
trCells[3].GetFirstChild <Paragraph>().Append(
Word.GetTextElement(num.ToString(), 24));
trCells[5].GetFirstChild <Paragraph>().Append(
Word.GetTextElement(Math.Round(profileSum, 3).ToStringWithComma(), 24));
num++;
t.Append(newTr);
steelSum += profileSum;
}
newTr = clonedSecondTr.CloneNode(true);
trCells = newTr.Descendants <TableCell>().ToList();
trCells[0].GetFirstChild <Paragraph>().Append(
Word.GetTextElement("Всего профиля:", 24));
trCells[3].GetFirstChild <Paragraph>().Append(
Word.GetTextElement(num.ToString(), 24));
trCells[5].GetFirstChild <Paragraph>().Append(
Word.GetTextElement(Math.Round(steelSum, 3).ToStringWithComma(), 24));
num++;
Word.MakeBordersThin(trCells);
t.Append(newTr);
elementSum += steelSum;
}
newTr = clonedSecondTr.CloneNode(true);
trCells = newTr.Descendants <TableCell>().ToList();
trCells[0].GetFirstChild <Paragraph>().Append(
Word.GetTextElement("Итого масса металла:", 24));
trCells[3].GetFirstChild <Paragraph>().Append(
Word.GetTextElement(num.ToString(), 24));
trCells[5].GetFirstChild <Paragraph>().Append(
Word.GetTextElement(Math.Round(elementSum, 3).ToStringWithComma(), 24));
num++;
Word.MakeBordersThin(trCells);
t.Append(newTr);
newTr = clonedSecondTr.CloneNode(true);
trCells = newTr.Descendants <TableCell>().ToList();
var p = trCells[0].GetFirstChild <Paragraph>();
p.Append(Word.GetTextElement(
"Итого развернутая площадь поверхности конструкций, 100 м", 24));
p.Append(Word.GetTextElement("2", 24, false, true));
p.Append(Word.GetTextElement(":", 24));
trCells[3].GetFirstChild <Paragraph>().Append(
Word.GetTextElement(num.ToString(), 24));
trCells[5].GetFirstChild <Paragraph>().Append(
Word.GetTextElement(Math.Round(areaSum, 3).ToStringWithComma(), 24));
num++;
Word.MakeBordersThin(trCells);
t.Append(newTr);
var n = 0;
foreach (var steel in steelMap)
{
newTr = clonedSecondTr.CloneNode(true);
trCells = newTr.Descendants <TableCell>().ToList();
if (n == 0)
{
trCells[0].GetFirstChild <Paragraph>().Append(
Word.GetTextElement("В том числе по маркам:", 24));
}
trCells[1].GetFirstChild <Paragraph>().Append(
Word.GetTextElement(steel.Key, 24));
trCells[3].GetFirstChild <Paragraph>().Append(
Word.GetTextElement(num.ToString(), 24));
trCells[5].GetFirstChild <Paragraph>().Append(
Word.GetTextElement(Math.Round(steel.Value, 3).ToStringWithComma(), 24));
num++;
if (n == steelMap.Count() - 1)
{
Word.MakeBordersThin(trCells, false);
}
else
{
Word.MakeBordersThin(trCells);
}
t.Append(newTr);
n++;
}
}
private void AppendList(
WordprocessingDocument wordDoc, List <ListText> arr)
{
NumberingDefinitionsPart numberingPart = wordDoc.MainDocumentPart.NumberingDefinitionsPart;
if (numberingPart == null)
{
numberingPart = wordDoc.MainDocumentPart.AddNewPart <NumberingDefinitionsPart>(
"NumberingDefinitionsPart1");
Numbering element = new Numbering();
element.Save(numberingPart);
}
var abstractNumberId = numberingPart.Numbering.Elements <AbstractNum>().Count() + 1;
var abstractLevel = new Level(
new NumberingFormat()
{
Val = NumberFormatValues.UpperRoman
},
new LevelText()
{
Val = "%1."
},
new StartNumberingValue()
{
Val = 1,
},
new RunProperties()
{
Italic = new Italic()
{
Val = OnOffValue.FromBoolean(true)
},
FontSize = new FontSize()
{
Val = 26.ToString(),
},
Bold = new Bold()
{
},
})
{
LevelIndex = 0
};
var abstractLevel1 = new Level(
new NumberingFormat()
{
Val = NumberFormatValues.Decimal
},
new LevelText()
{
Val = "%2."
},
new StartNumberingValue()
{
Val = 1,
},
new RunProperties()
{
RunFonts = new RunFonts()
{
Ascii = "GOST type B",
HighAnsi = "GOST type B",
ComplexScript = "GOST type B"
},
Italic = new Italic()
{
Val = OnOffValue.FromBoolean(true)
},
FontSize = new FontSize()
{
Val = 26.ToString(),
}
})
{
LevelIndex = 1
};
var abstractLevel2 = new Level(
new NumberingFormat()
{
Val = NumberFormatValues.Bullet
},
new LevelText()
{
Val = "–"
},
new RunProperties()
{
RunFonts = new RunFonts()
{
Ascii = "Calibri",
HighAnsi = "Calibri",
ComplexScript = "Calibri"
},
})
{
LevelIndex = 2
};
var abstractLevel3 = new Level(
new LevelSuffix()
{
Val = LevelSuffixValues.Space
})
{
LevelIndex = 3
};
var abstractLevel4 = new Level(
new LevelSuffix()
{
Val = LevelSuffixValues.Space
})
{
LevelIndex = 4
};
var abstractLevel5 = new Level(
new LevelSuffix()
{
Val = LevelSuffixValues.Space
})
{
LevelIndex = 5
};
var abstractLevel6 = new Level(
new LevelSuffix()
{
Val = LevelSuffixValues.Space
})
{
LevelIndex = 6
};
var abstractNum = new AbstractNum(
abstractLevel, abstractLevel1, abstractLevel2, abstractLevel3,
abstractLevel4, abstractLevel5, abstractLevel6)
{
AbstractNumberId = abstractNumberId
};
if (abstractNumberId == 1)
{
numberingPart.Numbering.Append(abstractNum);
}
else
{
AbstractNum lastAbstractNum = numberingPart.Numbering.Elements <AbstractNum>().Last();
numberingPart.Numbering.InsertAfter(abstractNum, lastAbstractNum);
}
var numberId = numberingPart.Numbering.Elements <NumberingInstance>().Count() + 1;
NumberingInstance numberingInstance = new NumberingInstance()
{
NumberID = numberId
};
AbstractNumId abstractNumId = new AbstractNumId()
{
Val = abstractNumberId
};
numberingInstance.Append(abstractNumId);
if (numberId == 1)
{
numberingPart.Numbering.Append(numberingInstance);
}
else
{
var lastNumberingInstance = numberingPart.Numbering.Elements <NumberingInstance>().Last();
numberingPart.Numbering.InsertAfter(numberingInstance, lastNumberingInstance);
}
Body body = wordDoc.MainDocumentPart.Document.Body;
for (var i = 0; i < arr.Count(); i++)
{
var spacingBetweenLines = new SpacingBetweenLines()
{
After = "120", Line = "240"
};
var indentation = new Indentation()
{
Left = "360", Right = "360", FirstLine = "1160"
};
NumberingProperties numberingProperties;
if (arr[i].LevelNum == 0)
{
numberingProperties = new NumberingProperties(
new NumberingLevelReference()
{
Val = 0
}, new NumberingId()
{
Val = numberId
});
indentation = new Indentation()
{
Left = "360", Right = "360", FirstLine = "720"
};
}
else if (arr[i].LevelNum == 1)
{
numberingProperties = new NumberingProperties(
new NumberingLevelReference()
{
Val = 1
}, new NumberingId()
{
Val = numberId
});
}
else if (arr[i].LevelNum == 2)
{
numberingProperties = new NumberingProperties(
new NumberingLevelReference()
{
Val = 2
}, new NumberingId()
{
Val = numberId
});
}
else if (arr[i].LevelNum == 3)
{
numberingProperties = new NumberingProperties(
new NumberingLevelReference()
{
Val = 3
}, new NumberingId()
{
Val = numberId
});
indentation = new Indentation()
{
Left = "360", Right = "360", FirstLine = "640"
};
}
else if (arr[i].LevelNum == 4)
{
numberingProperties = new NumberingProperties(
new NumberingLevelReference()
{
Val = 4
}, new NumberingId()
{
Val = numberId
});
indentation = new Indentation()
{
Left = "360", Right = "360", FirstLine = "1080"
};
}
else if (arr[i].LevelNum == 5)
{
numberingProperties = new NumberingProperties(
new NumberingLevelReference()
{
Val = 5
}, new NumberingId()
{
Val = numberId
});
indentation = new Indentation()
{
Left = "360", Right = "360", FirstLine = "1800"
};
}
else
{
numberingProperties = new NumberingProperties(
new NumberingLevelReference()
{
Val = 6
}, new NumberingId()
{
Val = numberId
});
indentation = new Indentation()
{
Left = "360", Right = "360", FirstLine = "2400"
};
}
var paragraphProperties = new ParagraphProperties(
numberingProperties, spacingBetweenLines, indentation);
var newPara = new Paragraph(paragraphProperties);
if (arr[i].WithSuperscript)
{
var split = arr[i].Text.Split('^');
if (split.Count() > 1)
{
for (int k = 0; k < split.Count(); k++)
{
if (k > 0)
{
newPara.AppendChild(
Word.GetTextElement(split[k][0].ToString(), 26, false, true));
}
if (k == 0)
{
newPara.AppendChild(Word.GetTextElement(split[k], 26));
}
else
if (split[k].Length > 1)
{
newPara.AppendChild(
Word.GetTextElement(split[k].Substring(1), 26));
}
}
}
else
{
newPara.AppendChild(
Word.GetTextElement(arr[i].Text, 26, false, false, arr[i].IsBold));
}
}
else
{
newPara.AppendChild(
Word.GetTextElement(arr[i].Text, 26, false, false, arr[i].IsBold));
}
body.AppendChild(newPara);
}
}
private void AppendToTable(
WordprocessingDocument document,
int currentSpecId)
{
// Вкл в спецификацию
var constructions = _constructionRepo.GetAllBySpecificationId(
currentSpecId).ToList();
if (constructions.Count() > 0)
{
Body body = document.MainDocumentPart.Document.Body;
var t = body.Descendants <Table>().FirstOrDefault();
var firstTr = t.Descendants <TableRow>().ToList()[0];
var clonedFirstTr = firstTr.CloneNode(true);
var trCells = firstTr.Descendants <TableCell>().ToList();
var secondTr = t.Descendants <TableRow>().ToList()[1];
var clonedSecondTr = secondTr.CloneNode(true);
OpenXmlElement newTr = null;
var num = 1;
List <GroupedElement> groupedConstructionElements = null;
for (int i = 0; i < constructions.Count(); i++)
{
groupedConstructionElements = _constructionElementRepo.GetAllByConstructionId(
constructions[i].Id).GroupBy(v => v.Profile.Type.Id).Select(
v => new GroupedElement
{
Name = v.First().Profile.Class.Name,
Steel = v.GroupBy(v2 => v2.Steel.Id).Select(
v2 => new GroupedSteel
{
Name = v2.First().Steel.Name,
Standard = v2.First().Steel.Standard,
Profiles = v2.GroupBy(v3 => v3.Profile.Id).Select(
v3 => new GroupedProfile
{
Name = v3.First().Profile.Name,
Symbol = ((v3.First().Profile.Class.Id == 16) ||
(v3.First().Profile.Class.Id == 17)) ? "s=" : v3.First().Profile.Symbol,
Length = Math.Round(v3.Sum(v4 => v4.Length), 3),
Weight = Math.Ceiling(v3.Sum(v4 => v4.Profile.Weight * v4.Length)) / 1000,
Area = Math.Ceiling(v3.Sum(
v4 => v4.Profile.Area * v4.Length * constructions[i].PaintworkCoeff)) / 1000,
}).ToList(),
}).ToList(),
}).ToList();
if (groupedConstructionElements.Count() > 0)
{
if (i > 0)
{
newTr = clonedFirstTr.CloneNode(true);
trCells = newTr.Descendants <TableCell>().ToList();
}
trCells[0].GetFirstChild <Paragraph>().Append(
Word.GetTextElement(constructions[i].Name, 24));
if (i > 0)
{
t.Append(newTr);
}
AppendConstruction(
groupedConstructionElements,
ref num, i, trCells, secondTr,
newTr, clonedSecondTr, t);
}
}
groupedConstructionElements = _constructionElementRepo.GetAllBySpecificationId(
currentSpecId).GroupBy(v => v.Profile.Type.Id).Select(
v => new GroupedElement
{
Name = v.First().Profile.Class.Name,
Steel = v.GroupBy(v2 => v2.Steel.Id).Select(
v2 => new GroupedSteel
{
Name = v2.First().Steel.Name,
Standard = v2.First().Steel.Standard,
Profiles = v2.GroupBy(v3 => v3.Profile.Id).Select(
v3 => new GroupedProfile
{
Name = v3.First().Profile.Name,
Symbol = ((v3.First().Profile.Class.Id == 16) ||
(v3.First().Profile.Class.Id == 17)) ? "s=" : v3.First().Profile.Symbol,
Length = Math.Round(v3.Sum(v4 => v4.Length), 3),
Weight = Math.Ceiling(v3.Sum(v4 => v4.Profile.Weight * v4.Length)) / 1000,
Area = Math.Ceiling(v3.Sum(
v4 => v4.Profile.Area * v4.Length * v4.Construction.PaintworkCoeff)) / 1000,
}).ToList(),
}).ToList(),
}).ToList();
if (groupedConstructionElements.Count() > 0)
{
newTr = clonedFirstTr.CloneNode(true);
trCells = newTr.Descendants <TableCell>().ToList();
trCells[0].GetFirstChild <Paragraph>().Append(
Word.GetTextElement("Общая масса", 24));
t.Append(newTr);
AppendConstruction(
groupedConstructionElements,
ref num, 99, trCells, secondTr,
newTr, clonedSecondTr, t);
}
}
}
