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++; } } }