private List <RowManagerContrAgGr> GetRows(List <ShahmatcaModel> shahmatcaModels)
{
int numberRow = 0;
List <ClientInfo> clientInfos = _context.Set <ClientInfo>().ToList();
List <Data.Entities.OneCInfo.UserInfo> userInfos = _context.Set <Data.Entities.OneCInfo.UserInfo>().ToList();
List <RowManagerContrAgGr> rowManagerContrAgGrs = new List <RowManagerContrAgGr>();
foreach (ShahmatcaModel shahmatcaModel in shahmatcaModels)
{
ClientInfo clientInfo = clientInfos.FirstOrDefault(c => c.OneCId.ToString() == shahmatcaModel.Contragent_ID);
Data.Entities.OneCInfo.UserInfo userInfo = userInfos.FirstOrDefault(u => u.OneCId.ToString() == shahmatcaModel.Manager_ID);
if (clientInfo != null && userInfo != null)
{
RowManagerContrAgGr rowManagerContrAgGr = rowManagerContrAgGrs.FirstOrDefault(r => r.Contragent_ID == shahmatcaModel.Contragent_ID);
if (rowManagerContrAgGr == null)
{
rowManagerContrAgGrs.Add(new RowManagerContrAgGr()
{
Contragent = shahmatcaModel.Contragent,
Contragent_ID = shahmatcaModel.Contragent_ID,
GR_Contragent = shahmatcaModel.GR_Contragent,
Manager = shahmatcaModel.Manager,
Manager_ID = shahmatcaModel.Manager_ID,
NumberRow = numberRow
});
numberRow++;
}
}
}
return(rowManagerContrAgGrs);
}
private void CreatXMLSSumme(SpreadsheetDocument spreadsheetDocument, ref int i, List <ColummnNoklName> colummnNoklNames, List <RowManagerContrAgGr> rowManagerContrAgGrs, List <ShahmatcaModel> shahmatcaModels, WorksheetPart worksheetPart)
{
SharedStringTablePart shareStringPart = GetSharedStringTablePart(spreadsheetDocument.WorkbookPart);
string nameColummn = GetCharOfTabel(0);
InsertSharedStringItem("Группа контрагентов", shareStringPart);
Cell cell = InsertCellInWorksheet(nameColummn, (UInt32)(rowManagerContrAgGrs.Count + 3), worksheetPart, 1, 80);
cell.CellValue = new CellValue(i.ToString());
cell.DataType = new EnumValue <CellValues>(CellValues.SharedString);
worksheetPart.Worksheet.Save();
i++;
shareStringPart = GetSharedStringTablePart(spreadsheetDocument.WorkbookPart);
nameColummn = GetCharOfTabel(1);
InsertSharedStringItem("Контрагент/Номенклатура", shareStringPart);
cell = InsertCellInWorksheet(nameColummn, (UInt32)(rowManagerContrAgGrs.Count + 3), worksheetPart, 1, 80);
cell.CellValue = new CellValue(i.ToString());
cell.DataType = new EnumValue <CellValues>(CellValues.SharedString);
worksheetPart.Worksheet.Save();
i++;
foreach (ColummnNoklName colummnNoklName in colummnNoklNames)
{
shareStringPart = GetSharedStringTablePart(spreadsheetDocument.WorkbookPart);
nameColummn = GetCharOfTabel(colummnNoklName.NumberColummn + 2);
InsertSharedStringItem(colummnNoklName.NameNomkl, shareStringPart);
cell = InsertCellInWorksheet(nameColummn, (UInt32)(rowManagerContrAgGrs.Count + 3), worksheetPart, 2, 80);
cell.DataType = new EnumValue <CellValues>(CellValues.SharedString);
cell.CellValue = new CellValue(i.ToString());
worksheetPart.Worksheet.Save();
i++;
}
foreach (RowManagerContrAgGr rowManagerContrAgGr in rowManagerContrAgGrs)
{
shareStringPart = GetSharedStringTablePart(spreadsheetDocument.WorkbookPart);
InsertSharedStringItem(rowManagerContrAgGr.GR_Contragent, shareStringPart);
cell = InsertCellInWorksheet("A", (UInt32)(rowManagerContrAgGrs.Count + rowManagerContrAgGr.NumberRow + 4), worksheetPart, 1, 30);
cell.DataType = new EnumValue <CellValues>(CellValues.SharedString);
cell.CellValue = new CellValue(i.ToString());
worksheetPart.Worksheet.Save();
i++;
shareStringPart = GetSharedStringTablePart(spreadsheetDocument.WorkbookPart);
InsertSharedStringItem(rowManagerContrAgGr.Contragent, shareStringPart);
cell = InsertCellInWorksheet("B", (UInt32)(rowManagerContrAgGrs.Count + rowManagerContrAgGr.NumberRow + 4), worksheetPart, 1, 30);
cell.DataType = new EnumValue <CellValues>(CellValues.SharedString);
cell.CellValue = new CellValue(i.ToString());
worksheetPart.Worksheet.Save();
i++;
nameColummn = GetCharOfTabel(colummnNoklNames.Count + 2);
shareStringPart = GetSharedStringTablePart(spreadsheetDocument.WorkbookPart);
InsertSharedStringItem(rowManagerContrAgGr.Manager, shareStringPart);
cell = InsertCellInWorksheet(nameColummn, (UInt32)(rowManagerContrAgGrs.Count + rowManagerContrAgGr.NumberRow + 4), worksheetPart, 1, 30);
cell.DataType = new EnumValue <CellValues>(CellValues.SharedString);
cell.CellValue = new CellValue(i.ToString());
worksheetPart.Worksheet.Save();
i++;
}
foreach (ShahmatcaModel shahmatcaModel in shahmatcaModels)
{
ColummnNoklName colummnNoklName = colummnNoklNames.FirstOrDefault(c => c.NameNomkl == shahmatcaModel.Nomenclature);
RowManagerContrAgGr rowManagerContrAgGr = rowManagerContrAgGrs.FirstOrDefault(r => r.Contragent == shahmatcaModel.Contragent);
if (rowManagerContrAgGr != null)
{
shareStringPart = GetSharedStringTablePart(spreadsheetDocument.WorkbookPart);
nameColummn = GetCharOfTabel(colummnNoklName.NumberColummn + 2);
InsertSharedStringItem(shahmatcaModel.Summa, shareStringPart);
if (shahmatcaModel.SummaColor == "R" || shahmatcaModel.SummaColor == "Н")
{
cell = InsertCellInWorksheet(nameColummn, (UInt32)(rowManagerContrAgGrs.Count + rowManagerContrAgGr.NumberRow + 4), worksheetPart, 4, 30);
}
else if (shahmatcaModel.SummaColor == "B")
{
cell = InsertCellInWorksheet(nameColummn, (UInt32)(rowManagerContrAgGrs.Count + rowManagerContrAgGr.NumberRow + 4), worksheetPart, 5, 30);
}
else if (shahmatcaModel.SummaColor == "W")
{
cell = InsertCellInWorksheet(nameColummn, (UInt32)(rowManagerContrAgGrs.Count + rowManagerContrAgGr.NumberRow + 4), worksheetPart, 3, 30);
}
cell.DataType = new EnumValue <CellValues>(CellValues.SharedString);
cell.CellValue = new CellValue(i.ToString());
worksheetPart.Worksheet.Save();
i++;
}
}
}
