private void GenerateSharedStringTablePartContent(SharedStringTablePart sharedStringTablePart,
SaveContext context)
{
// Call all table headers to make sure their names are filled
var x = 0;
Worksheets.ForEach(w => w.Tables.ForEach(t => x = (t as XLTable).FieldNames.Count));
sharedStringTablePart.SharedStringTable = new SharedStringTable {Count = 0, UniqueCount = 0};
var stringId = 0;
var newStrings = new Dictionary<String, Int32>();
var newRichStrings = new Dictionary<IXLRichText, Int32>();
foreach (
var c in
Worksheets.Cast<XLWorksheet>().SelectMany(
w =>
w.Internals.CellsCollection.GetCells(
c => ((c.DataType == XLCellValues.Text && c.ShareString) || c.HasRichText)
&& (c as XLCell).InnerText.Length > 0
&& XLHelper.IsNullOrWhiteSpace(c.FormulaA1)
)))
{
c.DataType = XLCellValues.Text;
if (c.HasRichText)
{
if (newRichStrings.ContainsKey(c.RichText))
c.SharedStringId = newRichStrings[c.RichText];
else
{
var sharedStringItem = new SharedStringItem();
foreach (var rt in c.RichText.Where(r => !String.IsNullOrEmpty(r.Text)))
{
sharedStringItem.Append(GetRun(rt));
}
if (c.RichText.HasPhonetics)
{
foreach (var p in c.RichText.Phonetics)
{
var phoneticRun = new PhoneticRun
{
BaseTextStartIndex = (UInt32)p.Start,
EndingBaseIndex = (UInt32)p.End
};
var text = new Text {Text = p.Text};
if (p.Text.PreserveSpaces())
text.Space = SpaceProcessingModeValues.Preserve;
phoneticRun.Append(text);
sharedStringItem.Append(phoneticRun);
}
var f = new XLFont(null, c.RichText.Phonetics);
if (!context.SharedFonts.ContainsKey(f))
context.SharedFonts.Add(f, new FontInfo {Font = f});
var phoneticProperties = new PhoneticProperties
{
FontId =
context.SharedFonts[
new XLFont(null, c.RichText.Phonetics)].
FontId
};
if (c.RichText.Phonetics.Alignment != XLPhoneticAlignment.Left)
phoneticProperties.Alignment = c.RichText.Phonetics.Alignment.ToOpenXml();
if (c.RichText.Phonetics.Type != XLPhoneticType.FullWidthKatakana)
phoneticProperties.Type = c.RichText.Phonetics.Type.ToOpenXml();
sharedStringItem.Append(phoneticProperties);
}
sharedStringTablePart.SharedStringTable.Append(sharedStringItem);
sharedStringTablePart.SharedStringTable.Count += 1;
sharedStringTablePart.SharedStringTable.UniqueCount += 1;
newRichStrings.Add(c.RichText, stringId);
c.SharedStringId = stringId;
stringId++;
}
}
else
{
if (newStrings.ContainsKey(c.Value.ToString()))
c.SharedStringId = newStrings[c.Value.ToString()];
else
{
var s = c.Value.ToString();
var sharedStringItem = new SharedStringItem();
var text = new Text {Text = s};
if (!s.Trim().Equals(s))
text.Space = SpaceProcessingModeValues.Preserve;
sharedStringItem.Append(text);
sharedStringTablePart.SharedStringTable.Append(sharedStringItem);
sharedStringTablePart.SharedStringTable.Count += 1;
sharedStringTablePart.SharedStringTable.UniqueCount += 1;
newStrings.Add(c.Value.ToString(), stringId);
c.SharedStringId = stringId;
stringId++;
}
}
}
}
public static string GetOrAddSharedString(this DocumentContext documentContext, string text)
{
if (text == null)
{
return(null);
}
if (!documentContext.SharedStringTable.TryGetValue(text, out string stringIndex))
{
SharedStringTable sharedStringTable = documentContext.GetSharedStringTable();
SharedStringItem sharedStringItem = new SharedStringItem();
Text text1 = new Text {
Text = text
};
sharedStringItem.Append(text1);
sharedStringTable.AppendChild(sharedStringItem);
uint itemCount = (uint)sharedStringTable.ChildElements.Count;
sharedStringTable.Count = itemCount;
sharedStringTable.UniqueCount = itemCount;
stringIndex = (itemCount - 1).ToString();
documentContext.SharedStringTable.Add(text, stringIndex);
}
return(stringIndex);
}
/// <summary>
/// Добавить текст в таблицу <see cref="SharedStringTable"/>
/// </summary>
/// <param name="sst">Таблица с тектами</param>
/// <param name="text">Добавляемый текст</param>
/// <param name="rPr">Стиль добавляемого текста</param>
/// <returns>Добавленыый элемент в <see cref="SharedStringTable"/> содержащий указанный текст</returns>
public static SharedStringItem Add(this SharedStringTable sst, string text, RunProperties rPr = null)
{
var item = new SharedStringItem();
if (rPr == null)
{
item.Text = new Text(text);
}
else
{
var run = new Run();
run.Text = new Text(text);
run.Append(rPr.CloneNode(true));
item.Append(run);
}
sst.Append(item);
if (sst.Count != null)
{
sst.Count.Value++;
}
if (sst.UniqueCount != null)
{
sst.UniqueCount.Value++;
}
return(item);
}
/// <summary>
/// Creates the shared string table part.
/// </summary>
/// <param name="sharedStringTablePart">The shared string table part.</param>
/// <param name="sheetData">The sheet data.</param>
private void CreateSharedStringTablePart(SharedStringTablePart sharedStringTablePart, DataTable sheetData)
{
UInt32Value stringCount = Convert.ToUInt32(sheetData.Rows.Count) + Convert.ToUInt32(sheetData.Columns.Count);
SharedStringTable sharedStringTable = new SharedStringTable()
{
Count = stringCount,
UniqueCount = stringCount
};
for (int columnIndex = 0; columnIndex < sheetData.Columns.Count; columnIndex++)
{
SharedStringItem sharedStringItem = new SharedStringItem();
Text text = new Text();
text.Text = sheetData.Columns[columnIndex].ColumnName;
sharedStringItem.Append(text);
sharedStringTable.Append(sharedStringItem);
}
for (int rowIndex = 0; rowIndex < sheetData.Rows.Count; rowIndex++)
{
SharedStringItem sharedStringItem = new SharedStringItem();
Text text = new Text();
text.Text = sheetData.Rows[rowIndex][0].ToString();
sharedStringItem.Append(text);
sharedStringTable.Append(sharedStringItem);
}
sharedStringTablePart.SharedStringTable = sharedStringTable;
}
/// <summary>
/// Generates content of sharedStringTablePart
/// </summary>
/// <param name="sharedStringTablePart">SharedStringTablePart Object</param>
/// <param name="table">DataTable Object</param>
private void CreateSharedStringTablePart(SharedStringTablePart sharedStringTablePart, DataTable table)
{
UInt32Value stringCount = Convert.ToUInt32(table.Rows.Count) + Convert.ToUInt32(table.Columns.Count);
// Initialize an instance of SharedString Table
SharedStringTable sharedStringTable = new SharedStringTable()
{
Count = stringCount,
UniqueCount = stringCount
};
// Add columns of DataTable to sharedString iteam
for (int columnIndex = 0; columnIndex < table.Columns.Count; columnIndex++)
{
SharedStringItem sharedStringItem = new SharedStringItem();
Text text = new Text();
text.Text = table.Columns[columnIndex].ColumnName;
sharedStringItem.Append(text);
// Add sharedstring item to sharedstring Table
sharedStringTable.Append(sharedStringItem);
}
// Add rows of DataTable to sharedString iteam
for (int rowIndex = 0; rowIndex < table.Rows.Count; rowIndex++)
{
SharedStringItem sharedStringItem = new SharedStringItem();
Text text = new Text();
text.Text = table.Rows[rowIndex][0].ToString();
sharedStringItem.Append(text);
sharedStringTable.Append(sharedStringItem);
}
sharedStringTablePart.SharedStringTable = sharedStringTable;
}
String NewSharedString(String Value)
{
var ssi = new SharedStringItem();
ssi.Append(new Text(Value));
_sharedStringTable.Append(ssi);
_sharedStringModified = true;
return((_sharedStringCount++).ToString());
}
private static void CreateSharedStringItem(SharedStringTable sharedTable, string text)
{
SharedStringItem sharedStringItem = new SharedStringItem();
DocumentFormat.OpenXml.Spreadsheet.Text text1 = new DocumentFormat.OpenXml.Spreadsheet.Text();
text1.Text = text;
sharedStringItem.Append(text1);
sharedTable.Append(sharedStringItem);
}
private static void AddSheredString(SharedStringTable sharedStringTable1, string data)
{
SharedStringItem sharedStringItem = new SharedStringItem();
Text text = new Text();
text.Text = data;
sharedStringItem.Append(text);
sharedStringTable1.Append(sharedStringItem);
}
private static void GenerateCellContentStyle(SharedStringItem shareStringItem, string font, bool isBold, bool isItalic, string str)
{
Run run = new Run();
RunProperties runProperties = new RunProperties();
Bold bold = new Bold();
Italic italic = new Italic();
DocumentFormat.OpenXml.Spreadsheet.FontSize fontSize = new DocumentFormat.OpenXml.Spreadsheet.FontSize()
{
Val = 11D
};
Color color = new Color()
{
Theme = (UInt32Value)1U
};
RunFont runFont = new RunFont()
{
Val = font
};
FontFamily fontFamily = new FontFamily()
{
Val = 2
};
FontScheme fontScheme = new FontScheme()
{
Val = FontSchemeValues.Minor
};
if (isBold)
{
runProperties.Append(bold);
}
if (isItalic)
{
runProperties.Append(italic);
}
runProperties.Append(fontSize);
runProperties.Append(color);
runProperties.Append(runFont);
runProperties.Append(fontFamily);
runProperties.Append(fontScheme);
Text text1 = new Text()
{
Space = SpaceProcessingModeValues.Preserve
};
text1.Text = str;
run.Append(runProperties);
run.Append(text1);
shareStringItem.Append(run);
}
private Int32 AddStringToSst(String s)
{
SharedStringTable sst = sharedStringTable;
Int32 index = sst.ChildElements.Count;
SharedStringItem sharedStringItem = new SharedStringItem();
Text text = new Text()
{
Text = (s ?? "")
};
sharedStringItem.Append(text);
sst.Append(sharedStringItem);
return(index);
}
/// <summary>
/// Generates the SharedString xml part using the string collection in SharedStrings (List<string>)
/// </summary>
/// <param name="part"></param>
private void GenerateSharedStringTablePart1Content(SharedStringTablePart part)
{
SharedStringTable sharedStringTable1 = new SharedStringTable();
sharedStringTable1.Count = new UInt32Value((uint)sharedStrings.Count);
sharedStringTable1.UniqueCount = new UInt32Value((uint)sharedStrings.Count);
foreach (string item in sharedStrings)
{
SharedStringItem sharedStringItem = new SharedStringItem();
Text text = new Text();
text.Text = item;
sharedStringItem.Append(text);
sharedStringTable1.Append(sharedStringItem);
}
part.SharedStringTable = sharedStringTable1;
}
// Generates content of sharedStringTablePart1.
private void GenerateSharedStringTablePart1Content(SharedStringTablePart sharedStringTablePart1)
{
SharedStringTable sharedStringTable1 = new SharedStringTable() { Count = (UInt32Value)5U, UniqueCount = (UInt32Value)5U };
SharedStringItem sharedStringItem1 = new SharedStringItem();
Text text1 = new Text();
text1.Text = "HeaderVal";
sharedStringItem1.Append(text1);
SharedStringItem sharedStringItem2 = new SharedStringItem();
Text text2 = new Text();
text2.Text = "HeaderNumber";
sharedStringItem2.Append(text2);
SharedStringItem sharedStringItem3 = new SharedStringItem();
Text text3 = new Text();
text3.Text = "HeaderLink";
sharedStringItem3.Append(text3);
SharedStringItem sharedStringItem4 = new SharedStringItem();
Text text4 = new Text();
text4.Text = "test";
sharedStringItem4.Append(text4);
SharedStringItem sharedStringItem5 = new SharedStringItem();
Text text5 = new Text();
text5.Text = "http://google.com";
sharedStringItem5.Append(text5);
sharedStringTable1.Append(sharedStringItem1);
sharedStringTable1.Append(sharedStringItem2);
sharedStringTable1.Append(sharedStringItem3);
sharedStringTable1.Append(sharedStringItem4);
sharedStringTable1.Append(sharedStringItem5);
sharedStringTablePart1.SharedStringTable = sharedStringTable1;
}
/// <summary>
/// Генерация текста для Shared
/// </summary>
/// <param name="textGeneratedArray">Массив текста для SharedString и Value = "0,1, и т д" </param>
public void GenerateSharedStringTablePartContent(string[] textGeneratedArray)
{
SharedStringTablePart sharedStringTablePart = WorkBookPart.AddNewPart <SharedStringTablePart>();
SharedStringTable sharedStringTable1 = new SharedStringTable()
{
Count = Convert.ToUInt32(textGeneratedArray.Length), UniqueCount = Convert.ToUInt32(textGeneratedArray.Length)
};
foreach (var textGenerated in textGeneratedArray)
{
SharedStringItem sharedStringItem1 = new SharedStringItem();
Text text1 = new Text();
text1.Text = textGenerated;
sharedStringItem1.Append(text1);
sharedStringTable1.Append(sharedStringItem1);
}
sharedStringTablePart.SharedStringTable = sharedStringTable1;
}
// Generates content of sharedStringTablePart1.
private void GenerateSharedStringTablePart1Content(SharedStringTablePart sharedStringTablePart1)
{
SharedStringTable sharedStringTable1 = new SharedStringTable(){ Count = (UInt32Value)130U, UniqueCount = (UInt32Value)32U };
SharedStringItem sharedStringItem1 = new SharedStringItem();
Text text7 = new Text();
text7.Text = "Date";
PhoneticRun phoneticRun1 = new PhoneticRun(){ BaseTextStartIndex = (UInt32Value)0U, EndingBaseIndex = (UInt32Value)0U };
Text text8 = new Text();
text8.Text = "";
phoneticRun1.Append(text8);
PhoneticProperties phoneticProperties4 = new PhoneticProperties(){ FontId = (UInt32Value)0U, Type = PhoneticValues.Hiragana };
sharedStringItem1.Append(text7);
sharedStringItem1.Append(phoneticRun1);
sharedStringItem1.Append(phoneticProperties4);
SharedStringItem sharedStringItem2 = new SharedStringItem();
Text text9 = new Text();
text9.Text = "Product";
PhoneticRun phoneticRun2 = new PhoneticRun(){ BaseTextStartIndex = (UInt32Value)0U, EndingBaseIndex = (UInt32Value)0U };
Text text10 = new Text();
text10.Text = "";
phoneticRun2.Append(text10);
PhoneticProperties phoneticProperties5 = new PhoneticProperties(){ FontId = (UInt32Value)0U, Type = PhoneticValues.Hiragana };
sharedStringItem2.Append(text9);
sharedStringItem2.Append(phoneticRun2);
sharedStringItem2.Append(phoneticProperties5);
SharedStringItem sharedStringItem3 = new SharedStringItem();
Text text11 = new Text();
text11.Text = "Quantity";
PhoneticRun phoneticRun3 = new PhoneticRun(){ BaseTextStartIndex = (UInt32Value)0U, EndingBaseIndex = (UInt32Value)0U };
Text text12 = new Text();
text12.Text = "";
phoneticRun3.Append(text12);
PhoneticProperties phoneticProperties6 = new PhoneticProperties(){ FontId = (UInt32Value)0U, Type = PhoneticValues.Hiragana };
sharedStringItem3.Append(text11);
sharedStringItem3.Append(phoneticRun3);
sharedStringItem3.Append(phoneticProperties6);
SharedStringItem sharedStringItem4 = new SharedStringItem();
Text text13 = new Text();
text13.Text = "Price";
PhoneticRun phoneticRun4 = new PhoneticRun(){ BaseTextStartIndex = (UInt32Value)0U, EndingBaseIndex = (UInt32Value)0U };
Text text14 = new Text();
text14.Text = "";
phoneticRun4.Append(text14);
PhoneticProperties phoneticProperties7 = new PhoneticProperties(){ FontId = (UInt32Value)0U, Type = PhoneticValues.Hiragana };
sharedStringItem4.Append(text13);
sharedStringItem4.Append(phoneticRun4);
sharedStringItem4.Append(phoneticProperties7);
SharedStringItem sharedStringItem5 = new SharedStringItem();
Text text15 = new Text();
text15.Text = "DeliveryDate";
sharedStringItem5.Append(text15);
SharedStringItem sharedStringItem6 = new SharedStringItem();
Text text16 = new Text();
text16.Text = "Employee";
PhoneticRun phoneticRun5 = new PhoneticRun(){ BaseTextStartIndex = (UInt32Value)0U, EndingBaseIndex = (UInt32Value)0U };
Text text17 = new Text();
text17.Text = "";
phoneticRun5.Append(text17);
PhoneticProperties phoneticProperties8 = new PhoneticProperties(){ FontId = (UInt32Value)0U, Type = PhoneticValues.Hiragana };
sharedStringItem6.Append(text16);
sharedStringItem6.Append(phoneticRun5);
sharedStringItem6.Append(phoneticProperties8);
SharedStringItem sharedStringItem7 = new SharedStringItem();
Text text18 = new Text();
text18.Text = "product_A";
sharedStringItem7.Append(text18);
SharedStringItem sharedStringItem8 = new SharedStringItem();
Text text19 = new Text();
text19.Text = "sales staff G";
sharedStringItem8.Append(text19);
SharedStringItem sharedStringItem9 = new SharedStringItem();
Text text20 = new Text();
text20.Text = "product_D";
sharedStringItem9.Append(text20);
SharedStringItem sharedStringItem10 = new SharedStringItem();
Text text21 = new Text();
text21.Text = "sales staff B";
sharedStringItem10.Append(text21);
SharedStringItem sharedStringItem11 = new SharedStringItem();
Text text22 = new Text();
text22.Text = "sales staff C";
sharedStringItem11.Append(text22);
SharedStringItem sharedStringItem12 = new SharedStringItem();
Text text23 = new Text();
text23.Text = "product_E";
sharedStringItem12.Append(text23);
SharedStringItem sharedStringItem13 = new SharedStringItem();
Text text24 = new Text();
text24.Text = "sales staff E";
sharedStringItem13.Append(text24);
SharedStringItem sharedStringItem14 = new SharedStringItem();
Text text25 = new Text();
text25.Text = "sales staff J";
sharedStringItem14.Append(text25);
SharedStringItem sharedStringItem15 = new SharedStringItem();
Text text26 = new Text();
text26.Text = "product_B";
sharedStringItem15.Append(text26);
SharedStringItem sharedStringItem16 = new SharedStringItem();
Text text27 = new Text();
text27.Text = "sales staff I";
sharedStringItem16.Append(text27);
SharedStringItem sharedStringItem17 = new SharedStringItem();
Text text28 = new Text();
text28.Text = "product_C";
sharedStringItem17.Append(text28);
SharedStringItem sharedStringItem18 = new SharedStringItem();
Text text29 = new Text();
text29.Text = "product_H";
sharedStringItem18.Append(text29);
SharedStringItem sharedStringItem19 = new SharedStringItem();
Text text30 = new Text();
text30.Text = "product_I";
sharedStringItem19.Append(text30);
SharedStringItem sharedStringItem20 = new SharedStringItem();
Text text31 = new Text();
text31.Text = "sales staff H";
sharedStringItem20.Append(text31);
SharedStringItem sharedStringItem21 = new SharedStringItem();
Text text32 = new Text();
text32.Text = "sales staff A";
sharedStringItem21.Append(text32);
SharedStringItem sharedStringItem22 = new SharedStringItem();
Text text33 = new Text();
text33.Text = "sales staff F";
sharedStringItem22.Append(text33);
SharedStringItem sharedStringItem23 = new SharedStringItem();
Text text34 = new Text();
text34.Text = "product_F";
sharedStringItem23.Append(text34);
SharedStringItem sharedStringItem24 = new SharedStringItem();
Text text35 = new Text();
text35.Text = "product_G";
sharedStringItem24.Append(text35);
SharedStringItem sharedStringItem25 = new SharedStringItem();
Text text36 = new Text();
text36.Text = "sales staff D";
sharedStringItem25.Append(text36);
SharedStringItem sharedStringItem26 = new SharedStringItem();
Text text37 = new Text();
text37.Text = "product_J";
sharedStringItem26.Append(text37);
SharedStringItem sharedStringItem27 = new SharedStringItem();
Text text38 = new Text();
text38.Text = "ProductName";
PhoneticRun phoneticRun6 = new PhoneticRun(){ BaseTextStartIndex = (UInt32Value)0U, EndingBaseIndex = (UInt32Value)0U };
Text text39 = new Text();
text39.Text = "";
phoneticRun6.Append(text39);
PhoneticProperties phoneticProperties9 = new PhoneticProperties(){ FontId = (UInt32Value)0U, Type = PhoneticValues.Hiragana };
sharedStringItem27.Append(text38);
sharedStringItem27.Append(phoneticRun6);
sharedStringItem27.Append(phoneticProperties9);
SharedStringItem sharedStringItem28 = new SharedStringItem();
Text text40 = new Text();
text40.Text = "Employee";
sharedStringItem28.Append(text40);
SharedStringItem sharedStringItem29 = new SharedStringItem();
Text text41 = new Text();
text41.Text = "Sum of Quantity";
sharedStringItem29.Append(text41);
SharedStringItem sharedStringItem30 = new SharedStringItem();
Text text42 = new Text();
text42.Text = "Row Labels";
sharedStringItem30.Append(text42);
SharedStringItem sharedStringItem31 = new SharedStringItem();
Text text43 = new Text();
text43.Text = "Grand Total";
sharedStringItem31.Append(text43);
SharedStringItem sharedStringItem32 = new SharedStringItem();
Text text44 = new Text();
text44.Text = "Toral / Price";
sharedStringItem32.Append(text44);
sharedStringTable1.Append(sharedStringItem1);
sharedStringTable1.Append(sharedStringItem2);
sharedStringTable1.Append(sharedStringItem3);
sharedStringTable1.Append(sharedStringItem4);
sharedStringTable1.Append(sharedStringItem5);
sharedStringTable1.Append(sharedStringItem6);
sharedStringTable1.Append(sharedStringItem7);
sharedStringTable1.Append(sharedStringItem8);
sharedStringTable1.Append(sharedStringItem9);
sharedStringTable1.Append(sharedStringItem10);
sharedStringTable1.Append(sharedStringItem11);
sharedStringTable1.Append(sharedStringItem12);
sharedStringTable1.Append(sharedStringItem13);
sharedStringTable1.Append(sharedStringItem14);
sharedStringTable1.Append(sharedStringItem15);
sharedStringTable1.Append(sharedStringItem16);
sharedStringTable1.Append(sharedStringItem17);
sharedStringTable1.Append(sharedStringItem18);
sharedStringTable1.Append(sharedStringItem19);
sharedStringTable1.Append(sharedStringItem20);
sharedStringTable1.Append(sharedStringItem21);
sharedStringTable1.Append(sharedStringItem22);
sharedStringTable1.Append(sharedStringItem23);
sharedStringTable1.Append(sharedStringItem24);
sharedStringTable1.Append(sharedStringItem25);
sharedStringTable1.Append(sharedStringItem26);
sharedStringTable1.Append(sharedStringItem27);
sharedStringTable1.Append(sharedStringItem28);
sharedStringTable1.Append(sharedStringItem29);
sharedStringTable1.Append(sharedStringItem30);
sharedStringTable1.Append(sharedStringItem31);
sharedStringTable1.Append(sharedStringItem32);
sharedStringTablePart1.SharedStringTable = sharedStringTable1;
}
private int GenerateSharedStringItem(CellTextPart[] textParts, SharedStringTablePart shareStringPart)
{
if (shareStringPart.SharedStringTable == null)
{
shareStringPart.SharedStringTable = new SharedStringTable();
}
SharedStringItem ssItm = new SharedStringItem();
foreach (var part in textParts)
{
Run run = new Run();
var txt = part.Text;
if (part.PartFormat != null)
{
RunProperties runProperties = new RunProperties();
var scf = part.PartFormat;
if (scf.FontBold)
{
runProperties.Append(new Bold());
}
if (scf.FontSize > 0)
{
runProperties.Append(new FontSize {
Val = scf.FontSize
});
}
if (!string.IsNullOrEmpty(scf.FontColor))
{
runProperties.Append(new Color {
Rgb = scf.FontColor
});
}
if (part.TheDataType == DataTypes.Number)
{
runProperties.Append(new NumberingFormat());
}
run.Append(runProperties);
}
Text text = new Text {
Text = txt
};
run.Append(text);
ssItm.Append(run);
}
// The text does not exist in the part. Create the SharedStringItem and return its index.
shareStringPart.SharedStringTable.AppendChild(ssItm);
shareStringPart.SharedStringTable.Save();
// Iterate through all the items in the SharedStringTable. If the text already exists, return its index.
//foreach (SharedStringItem item in shareStringPart.SharedStringTable.Elements<SharedStringItem>())
//{
// if (item.InnerText.Equals(ssItm.InnerText))
// return i;
// i++;
//}
return(shareStringPart.SharedStringTable.ChildElements.Count - 1);
}
// Generates content of sharedStringTablePart1.
private void GenerateSharedStringTablePart1Content(SharedStringTablePart sharedStringTablePart1)
{
SharedStringTable sharedStringTable1 = new SharedStringTable() { Count = (UInt32Value)78U, UniqueCount = (UInt32Value)44U };
SharedStringItem sharedStringItem1 = new SharedStringItem();
Text text1 = new Text();
text1.Text = "CLIENTE:";
sharedStringItem1.Append(text1);
SharedStringItem sharedStringItem2 = new SharedStringItem();
Text text2 = new Text();
text2.Text = "FECHA DE EMISION:";
sharedStringItem2.Append(text2);
SharedStringItem sharedStringItem3 = new SharedStringItem();
Text text3 = new Text();
text3.Text = "Av. Corrientes 6277 ( 1427) Buenos Aires";
sharedStringItem3.Append(text3);
SharedStringItem sharedStringItem4 = new SharedStringItem();
Text text4 = new Text();
text4.Text = "ORDEN:";
sharedStringItem4.Append(text4);
SharedStringItem sharedStringItem5 = new SharedStringItem();
Text text5 = new Text() { Space = SpaceProcessingModeValues.Preserve };
text5.Text = " Argentina - Tel.: 4323-9931";
sharedStringItem5.Append(text5);
SharedStringItem sharedStringItem6 = new SharedStringItem();
Text text6 = new Text();
text6.Text = "MEDIO";
sharedStringItem6.Append(text6);
SharedStringItem sharedStringItem7 = new SharedStringItem();
Text text7 = new Text();
text7.Text = "PROGRAMA:";
sharedStringItem7.Append(text7);
SharedStringItem sharedStringItem8 = new SharedStringItem();
Text text8 = new Text();
text8.Text = "COORDINADOR GRAL. DE PRODUCCION:";
sharedStringItem8.Append(text8);
SharedStringItem sharedStringItem9 = new SharedStringItem();
Text text9 = new Text();
text9.Text = "CONTACTO:";
sharedStringItem9.Append(text9);
SharedStringItem sharedStringItem10 = new SharedStringItem();
Text text10 = new Text();
text10.Text = "TELEFONO/ Fax:";
sharedStringItem10.Append(text10);
SharedStringItem sharedStringItem11 = new SharedStringItem();
Text text11 = new Text();
text11.Text = "DIRECCION:";
sharedStringItem11.Append(text11);
SharedStringItem sharedStringItem12 = new SharedStringItem();
Text text12 = new Text();
text12.Text = "E-MAIL:";
sharedStringItem12.Append(text12);
SharedStringItem sharedStringItem13 = new SharedStringItem();
Text text13 = new Text();
text13.Text = "PROGRAMAS";
sharedStringItem13.Append(text13);
SharedStringItem sharedStringItem14 = new SharedStringItem();
Text text14 = new Text();
text14.Text = "PRODUCTOS";
sharedStringItem14.Append(text14);
SharedStringItem sharedStringItem15 = new SharedStringItem();
Text text15 = new Text();
text15.Text = "EMPRESA";
sharedStringItem15.Append(text15);
SharedStringItem sharedStringItem16 = new SharedStringItem();
Text text16 = new Text() { Space = SpaceProcessingModeValues.Preserve };
text16.Text = "Tipo de ";
sharedStringItem16.Append(text16);
SharedStringItem sharedStringItem17 = new SharedStringItem();
Text text17 = new Text();
text17.Text = "SEG.";
sharedStringItem17.Append(text17);
SharedStringItem sharedStringItem18 = new SharedStringItem();
Text text18 = new Text();
text18.Text = "S";
sharedStringItem18.Append(text18);
SharedStringItem sharedStringItem19 = new SharedStringItem();
Text text19 = new Text();
text19.Text = "D";
sharedStringItem19.Append(text19);
SharedStringItem sharedStringItem20 = new SharedStringItem();
Text text20 = new Text();
text20.Text = "L";
sharedStringItem20.Append(text20);
SharedStringItem sharedStringItem21 = new SharedStringItem();
Text text21 = new Text();
text21.Text = "M";
sharedStringItem21.Append(text21);
SharedStringItem sharedStringItem22 = new SharedStringItem();
Text text22 = new Text();
text22.Text = "J";
sharedStringItem22.Append(text22);
SharedStringItem sharedStringItem23 = new SharedStringItem();
Text text23 = new Text();
text23.Text = "V";
sharedStringItem23.Append(text23);
SharedStringItem sharedStringItem24 = new SharedStringItem();
Text text24 = new Text();
text24.Text = "Cantidad";
sharedStringItem24.Append(text24);
SharedStringItem sharedStringItem25 = new SharedStringItem();
Text text25 = new Text() { Space = SpaceProcessingModeValues.Preserve };
text25.Text = "Costo Neto ";
sharedStringItem25.Append(text25);
SharedStringItem sharedStringItem26 = new SharedStringItem();
Text text26 = new Text();
text26.Text = "Total";
sharedStringItem26.Append(text26);
SharedStringItem sharedStringItem27 = new SharedStringItem();
Text text27 = new Text();
text27.Text = "Salida";
sharedStringItem27.Append(text27);
SharedStringItem sharedStringItem28 = new SharedStringItem();
Text text28 = new Text();
text28.Text = "Salidas";
sharedStringItem28.Append(text28);
SharedStringItem sharedStringItem29 = new SharedStringItem();
Text text29 = new Text();
text29.Text = "x salida PNT";
sharedStringItem29.Append(text29);
SharedStringItem sharedStringItem30 = new SharedStringItem();
Text text30 = new Text();
text30.Text = "Neto";
sharedStringItem30.Append(text30);
SharedStringItem sharedStringItem31 = new SharedStringItem();
Text text31 = new Text();
text31.Text = "SPRAYETTE";
sharedStringItem31.Append(text31);
SharedStringItem sharedStringItem32 = new SharedStringItem();
Text text32 = new Text();
text32.Text = "PNT";
sharedStringItem32.Append(text32);
SharedStringItem sharedStringItem33 = new SharedStringItem();
Text text33 = new Text();
text33.Text = "NUMERO";
sharedStringItem33.Append(text33);
SharedStringItem sharedStringItem34 = new SharedStringItem();
Text text34 = new Text();
text34.Text = "PNT\'S TOTALES";
sharedStringItem34.Append(text34);
SharedStringItem sharedStringItem35 = new SharedStringItem();
Text text35 = new Text();
text35.Text = "COSTO POR SALIDA";
sharedStringItem35.Append(text35);
SharedStringItem sharedStringItem36 = new SharedStringItem();
Text text36 = new Text();
text36.Text = "EXCLUSIVE";
sharedStringItem36.Append(text36);
SharedStringItem sharedStringItem37 = new SharedStringItem();
Text text37 = new Text();
text37.Text = "SUBTOTAL";
sharedStringItem37.Append(text37);
SharedStringItem sharedStringItem38 = new SharedStringItem();
Text text38 = new Text();
text38.Text = "POLISHOP";
sharedStringItem38.Append(text38);
SharedStringItem sharedStringItem39 = new SharedStringItem();
Text text39 = new Text();
text39.Text = "IVA 21%:";
sharedStringItem39.Append(text39);
SharedStringItem sharedStringItem40 = new SharedStringItem();
Text text40 = new Text();
text40.Text = "TOTAL";
sharedStringItem40.Append(text40);
SharedStringItem sharedStringItem41 = new SharedStringItem();
Text text41 = new Text();
text41.Text = "PRODUCTO";
sharedStringItem41.Append(text41);
SharedStringItem sharedStringItem42 = new SharedStringItem();
Text text42 = new Text();
text42.Text = "ZOCALO";
sharedStringItem42.Append(text42);
SharedStringItem sharedStringItem43 = new SharedStringItem();
Text text43 = new Text();
text43.Text = "COD. INGESTA";
sharedStringItem43.Append(text43);
SharedStringItem sharedStringItem44 = new SharedStringItem();
Text text44 = new Text();
text44.Text = "SALIDAS";
sharedStringItem44.Append(text44);
sharedStringTable1.Append(sharedStringItem1);
sharedStringTable1.Append(sharedStringItem2);
sharedStringTable1.Append(sharedStringItem3);
sharedStringTable1.Append(sharedStringItem4);
sharedStringTable1.Append(sharedStringItem5);
sharedStringTable1.Append(sharedStringItem6);
sharedStringTable1.Append(sharedStringItem7);
sharedStringTable1.Append(sharedStringItem8);
sharedStringTable1.Append(sharedStringItem9);
sharedStringTable1.Append(sharedStringItem10);
sharedStringTable1.Append(sharedStringItem11);
sharedStringTable1.Append(sharedStringItem12);
sharedStringTable1.Append(sharedStringItem13);
sharedStringTable1.Append(sharedStringItem14);
sharedStringTable1.Append(sharedStringItem15);
sharedStringTable1.Append(sharedStringItem16);
sharedStringTable1.Append(sharedStringItem17);
sharedStringTable1.Append(sharedStringItem18);
sharedStringTable1.Append(sharedStringItem19);
sharedStringTable1.Append(sharedStringItem20);
sharedStringTable1.Append(sharedStringItem21);
sharedStringTable1.Append(sharedStringItem22);
sharedStringTable1.Append(sharedStringItem23);
sharedStringTable1.Append(sharedStringItem24);
sharedStringTable1.Append(sharedStringItem25);
sharedStringTable1.Append(sharedStringItem26);
sharedStringTable1.Append(sharedStringItem27);
sharedStringTable1.Append(sharedStringItem28);
sharedStringTable1.Append(sharedStringItem29);
sharedStringTable1.Append(sharedStringItem30);
sharedStringTable1.Append(sharedStringItem31);
sharedStringTable1.Append(sharedStringItem32);
sharedStringTable1.Append(sharedStringItem33);
sharedStringTable1.Append(sharedStringItem34);
sharedStringTable1.Append(sharedStringItem35);
sharedStringTable1.Append(sharedStringItem36);
sharedStringTable1.Append(sharedStringItem37);
sharedStringTable1.Append(sharedStringItem38);
sharedStringTable1.Append(sharedStringItem39);
sharedStringTable1.Append(sharedStringItem40);
sharedStringTable1.Append(sharedStringItem41);
sharedStringTable1.Append(sharedStringItem42);
sharedStringTable1.Append(sharedStringItem43);
sharedStringTable1.Append(sharedStringItem44);
sharedStringTablePart1.SharedStringTable = sharedStringTable1;
}
// Generates content of sharedStringTablePart1.
private void GenerateSharedStringTablePart1Content(SharedStringTablePart sharedStringTablePart1)
{
SharedStringTable sharedStringTable1 = new SharedStringTable() { Count = (UInt32Value)5U, UniqueCount = (UInt32Value)5U };
SharedStringItem sharedStringItem1 = new SharedStringItem();
Text text1 = new Text();
text1.Text = "id";
SharedStringItem sharedStringItem2 = new SharedStringItem();
Text text2 = new Text();
text2.Text = "score";
SharedStringItem sharedStringItem3 = new SharedStringItem();
Text text3 = new Text();
text3.Text = "Sum of score";
SharedStringItem sharedStringItem4 = new SharedStringItem();
Text text4 = new Text();
text4.Text = "Row Labels";
SharedStringItem sharedStringItem5 = new SharedStringItem();
Text text5 = new Text();
text5.Text = "Grand Total";
sharedStringItem1.Append(text1);
sharedStringItem2.Append(text2);
sharedStringItem3.Append(text3);
sharedStringItem4.Append(text4);
sharedStringItem5.Append(text5);
sharedStringTable1.Append(sharedStringItem1);
sharedStringTable1.Append(sharedStringItem2);
sharedStringTable1.Append(sharedStringItem3);
sharedStringTable1.Append(sharedStringItem4);
sharedStringTable1.Append(sharedStringItem5);
sharedStringTablePart1.SharedStringTable = sharedStringTable1;
}
// Generates content of sharedStringTablePart1.
protected override void GenerateSharedStringTablePartContent(SharedStringTablePart sharedStringTablePart)
{
SharedStringTable sharedStringTable1 = new SharedStringTable() { Count = (UInt32Value)66U, UniqueCount = (UInt32Value)65U };
SharedStringItem sharedStringItem1 = new SharedStringItem();
Text text1 = new Text();
text1.Text = sampleSelectionRequest.Executor.Name;
sharedStringItem1.Append(text1);
SharedStringItem sharedStringItem2 = new SharedStringItem();
Text text2 = new Text();
text2.Text = "(наименование государственного учреждения)";
sharedStringItem2.Append(text2);
SharedStringItem sharedStringItem3 = new SharedStringItem();
Text text3 = new Text();
text3.Text = "Регистрационный №";
sharedStringItem3.Append(text3);
SharedStringItem sharedStringItem4 = new SharedStringItem();
Text text4 = new Text();
text4.Text = "Дата регистрации";
sharedStringItem4.Append(text4);
SharedStringItem sharedStringItem5 = new SharedStringItem();
Text text5 = new Text();
text5.Text = "на проведение апробации сельскохозяйственного растения";
sharedStringItem5.Append(text5);
SharedStringItem sharedStringItem6 = new SharedStringItem();
Text text6 = new Text();
text6.Text = "1.";
sharedStringItem6.Append(text6);
SharedStringItem sharedStringItem7 = new SharedStringItem();
Text text7 = new Text();
text7.Text = "Сведения о заявителе";
sharedStringItem7.Append(text7);
SharedStringItem sharedStringItem8 = new SharedStringItem();
Text text8 = new Text();
text8.Text = "1.1.";
sharedStringItem8.Append(text8);
SharedStringItem sharedStringItem9 = new SharedStringItem();
Text text9 = new Text();
text9.Text = "Наименование юридического лица; фамилия, собственное имя и отчество (если таковое имеется)";
sharedStringItem9.Append(text9);
SharedStringItem sharedStringItem10 = new SharedStringItem();
Text text10 = new Text();
text10.Text = "физического лица, в том числе индивидуального предпринимателя";
sharedStringItem10.Append(text10);
SharedStringItem sharedStringItem11 = new SharedStringItem();
Text text11 = new Text();
text11.Text = sampleSelectionRequest.Client.Name;
sharedStringItem11.Append(text11);
SharedStringItem sharedStringItem12 = new SharedStringItem();
Text text12 = new Text();
text12.Text = "1.2.";
sharedStringItem12.Append(text12);
SharedStringItem sharedStringItem13 = new SharedStringItem();
Text text13 = new Text();
text13.Text = "Место нахождения юридического лица; адрес регистрации по месту жительства (месту пребывания)";
sharedStringItem13.Append(text13);
SharedStringItem sharedStringItem14 = new SharedStringItem();
Text text14 = new Text();
text14.Text = sampleSelectionRequest.Client.Address;
sharedStringItem14.Append(text14);
SharedStringItem sharedStringItem15 = new SharedStringItem();
Text text15 = new Text();
text15.Text = "1.3.";
sharedStringItem15.Append(text15);
SharedStringItem sharedStringItem16 = new SharedStringItem();
Text text16 = new Text();
text16.Text = "Номер телефона, факс, адрес электронной почты";
sharedStringItem16.Append(text16);
SharedStringItem sharedStringItem17 = new SharedStringItem();
Text text17 = new Text();
text17.Text = sampleSelectionRequest.Client.Telephone;
sharedStringItem17.Append(text17);
SharedStringItem sharedStringItem18 = new SharedStringItem();
Text text18 = new Text();
text18.Text = "Прошу провести апробацию посева (посадки) сельскохозяйственного растения";
sharedStringItem18.Append(text18);
SharedStringItem sharedStringItem19 = new SharedStringItem();
Text text19 = new Text();
text19.Text = "2.";
sharedStringItem19.Append(text19);
SharedStringItem sharedStringItem20 = new SharedStringItem();
Text text20 = new Text();
text20.Text = "Сведения о семенах сельскохозяйственного растения и его посеве (посадке)";
sharedStringItem20.Append(text20);
SharedStringItem sharedStringItem21 = new SharedStringItem();
Text text21 = new Text();
text21.Text = "2.1.";
sharedStringItem21.Append(text21);
SharedStringItem sharedStringItem22 = new SharedStringItem();
Text text22 = new Text();
text22.Text = "Наименование сельскохозяйственного растения";
sharedStringItem22.Append(text22);
SharedStringItem sharedStringItem23 = new SharedStringItem();
Text text23 = new Text();
text23.Text = "2.2.";
sharedStringItem23.Append(text23);
SharedStringItem sharedStringItem24 = new SharedStringItem();
Text text24 = new Text();
text24.Text = "Наименование сорта сельскохозяйственного растения";
sharedStringItem24.Append(text24);
SharedStringItem sharedStringItem25 = new SharedStringItem();
Text text25 = new Text();
text25.Text = sampleSelectionRequest.PlantVariety.Plant.Name;
sharedStringItem25.Append(text25);
SharedStringItem sharedStringItem26 = new SharedStringItem();
Text text26 = new Text();
text26.Text = sampleSelectionRequest.PlantVariety.Name;
sharedStringItem26.Append(text26);
SharedStringItem sharedStringItem27 = new SharedStringItem();
Text text27 = new Text();
text27.Text = "2.3.";
sharedStringItem27.Append(text27);
SharedStringItem sharedStringItem28 = new SharedStringItem();
Text text28 = new Text();
text28.Text = "Категория высеянных семян сельскохозяйственного растения";
sharedStringItem28.Append(text28);
SharedStringItem sharedStringItem29 = new SharedStringItem();
Text text29 = new Text();
text29.Text = "2.4.";
sharedStringItem29.Append(text29);
SharedStringItem sharedStringItem30 = new SharedStringItem();
Text text30 = new Text();
text30.Text = "Этап размножения высеянных семян сельскохозяйственного растения";
sharedStringItem30.Append(text30);
SharedStringItem sharedStringItem31 = new SharedStringItem();
Text text31 = new Text();
text31.Text = sampleSelectionRequest.PlantVariety.Plant.Category;
sharedStringItem31.Append(text31);
SharedStringItem sharedStringItem32 = new SharedStringItem();
Text text32 = new Text();
text32.Text = sampleSelectionRequest.ReproductionStep.Name;
sharedStringItem32.Append(text32);
SharedStringItem sharedStringItem33 = new SharedStringItem();
Text text33 = new Text();
text33.Text = "2.5.";
sharedStringItem33.Append(text33);
SharedStringItem sharedStringItem34 = new SharedStringItem();
Text text34 = new Text();
text34.Text = "Номер партии высеянных семян сельскохозяйственного растения";
sharedStringItem34.Append(text34);
SharedStringItem sharedStringItem35 = new SharedStringItem();
Text text35 = new Text();
text35.Text = "2.6.";
sharedStringItem35.Append(text35);
SharedStringItem sharedStringItem36 = new SharedStringItem();
Text text36 = new Text();
text36.Text = "Номер и дача выдачи документа, подтверждающего посевные и сортовые качества семян сельскохозяйственного растения";
sharedStringItem36.Append(text36);
SharedStringItem sharedStringItem37 = new SharedStringItem();
Text text37 = new Text();
text37.Text = sampleSelectionRequest.SeedsBatchNumber;
sharedStringItem37.Append(text37);
SharedStringItem sharedStringItem38 = new SharedStringItem();
Text text38 = new Text();
text38.Text = "2.7.";
sharedStringItem38.Append(text38);
SharedStringItem sharedStringItem39 = new SharedStringItem();
Text text39 = new Text();
text39.Text = "Количество высеянных семян (единиц)";
sharedStringItem39.Append(text39);
SharedStringItem sharedStringItem40 = new SharedStringItem();
Text text40 = new Text();
text40.Text = "2.8.";
sharedStringItem40.Append(text40);
SharedStringItem sharedStringItem41 = new SharedStringItem();
Text text41 = new Text();
text41.Text = "Площадь поля, участка, посева (посадки)";
sharedStringItem41.Append(text41);
SharedStringItem sharedStringItem42 = new SharedStringItem();
Text text42 = new Text();
text42.Text = "2.9.";
sharedStringItem42.Append(text42);
SharedStringItem sharedStringItem43 = new SharedStringItem();
Text text43 = new Text();
text43.Text = "Номер поля, участка, посева (посадки)";
sharedStringItem43.Append(text43);
SharedStringItem sharedStringItem44 = new SharedStringItem();
Text text44 = new Text();
text44.Text = "2.10.";
sharedStringItem44.Append(text44);
SharedStringItem sharedStringItem45 = new SharedStringItem();
Text text45 = new Text();
text45.Text = "Место расположения поля, участка, посева (посадки)";
sharedStringItem45.Append(text45);
SharedStringItem sharedStringItem46 = new SharedStringItem();
Text text46 = new Text();
text46.Text = "2.11.";
sharedStringItem46.Append(text46);
SharedStringItem sharedStringItem47 = new SharedStringItem();
Text text47 = new Text();
text47.Text = "Происхождение семян сельскохозяйственных растений";
sharedStringItem47.Append(text47);
SharedStringItem sharedStringItem48 = new SharedStringItem();
Text text48 = new Text();
text48.Text = "2.12.";
sharedStringItem48.Append(text48);
SharedStringItem sharedStringItem49 = new SharedStringItem();
Text text49 = new Text();
text49.Text = "Дата посева (посадки)";
sharedStringItem49.Append(text49);
SharedStringItem sharedStringItem50 = new SharedStringItem();
Text text50 = new Text();
text50.Text = "2.13.";
sharedStringItem50.Append(text50);
SharedStringItem sharedStringItem51 = new SharedStringItem();
Text text51 = new Text();
text51.Text = "Сельскохозяйственные растения, предшествующие посеву (посадке) (указать год)";
sharedStringItem51.Append(text51);
SharedStringItem sharedStringItem52 = new SharedStringItem();
Text text52 = new Text();
text52.Text = "2.14.";
sharedStringItem52.Append(text52);
SharedStringItem sharedStringItem53 = new SharedStringItem();
Text text53 = new Text();
text53.Text = "Метод определения сортовой чистоты или сортовой типичности сельскохозяйственных растений, семена которых в случае реализации подлежат обязательному грунтовому контролю и (или) лабораторному сортовому контролю:";
sharedStringItem53.Append(text53);
SharedStringItem sharedStringItem54 = new SharedStringItem();
Text text54 = new Text();
text54.Text = "[ ] грунтовой контроль";
sharedStringItem54.Append(text54);
SharedStringItem sharedStringItem55 = new SharedStringItem();
Text text55 = new Text();
text55.Text = "[ ] лабораторный сортовой контроль";
sharedStringItem55.Append(text55);
SharedStringItem sharedStringItem56 = new SharedStringItem();
Text text56 = new Text();
text56.Text = "3. [ ] Вся информация, изложенная в заявлении, является окончательной и достоверной.";
sharedStringItem56.Append(text56);
SharedStringItem sharedStringItem57 = new SharedStringItem();
Text text57 = new Text();
text57.Text = "(должность представителя заявителя)";
sharedStringItem57.Append(text57);
SharedStringItem sharedStringItem58 = new SharedStringItem();
Text text58 = new Text();
text58.Text = "(подпись)";
sharedStringItem58.Append(text58);
SharedStringItem sharedStringItem59 = new SharedStringItem();
Text text59 = new Text();
text59.Text = "инициалы, фамилия";
sharedStringItem59.Append(text59);
SharedStringItem sharedStringItem60 = new SharedStringItem();
Text text60 = new Text();
text60.Text = "5 июня 2016 г.";
sharedStringItem60.Append(text60);
SharedStringItem sharedStringItem61 = new SharedStringItem();
Text text61 = new Text();
text61.Text = "* Для зерновых, зернобобовых, кукурузы - в течение минимум 2 лет; для крестоцветных кормовых и масличных, злаковых и бобовых трав - в течение минимум 5 лет; для прочих растений - в течение минимум 1 года.";
sharedStringItem61.Append(text61);
SharedStringItem sharedStringItem62 = new SharedStringItem();
Text text62 = new Text();
text62.Text = "ЗАЯВЛЕНИЕ";
sharedStringItem62.Append(text62);
SharedStringItem sharedStringItem63 = new SharedStringItem();
Text text63 = new Text();
text63.Text = "М.П. (при наличии)";
sharedStringItem63.Append(text63);
SharedStringItem sharedStringItem64 = new SharedStringItem();
Text text64 = new Text();
text64.Text = "4. К заявлению прилагаются";
sharedStringItem64.Append(text64);
SharedStringItem sharedStringItem65 = new SharedStringItem();
Text text65 = new Text();
text65.Text = "5. Дополнительные сведения";
sharedStringItem65.Append(text65);
sharedStringTable1.Append(sharedStringItem1);
sharedStringTable1.Append(sharedStringItem2);
sharedStringTable1.Append(sharedStringItem3);
sharedStringTable1.Append(sharedStringItem4);
sharedStringTable1.Append(sharedStringItem5);
sharedStringTable1.Append(sharedStringItem6);
sharedStringTable1.Append(sharedStringItem7);
sharedStringTable1.Append(sharedStringItem8);
sharedStringTable1.Append(sharedStringItem9);
sharedStringTable1.Append(sharedStringItem10);
sharedStringTable1.Append(sharedStringItem11);
sharedStringTable1.Append(sharedStringItem12);
sharedStringTable1.Append(sharedStringItem13);
sharedStringTable1.Append(sharedStringItem14);
sharedStringTable1.Append(sharedStringItem15);
sharedStringTable1.Append(sharedStringItem16);
sharedStringTable1.Append(sharedStringItem17);
sharedStringTable1.Append(sharedStringItem18);
sharedStringTable1.Append(sharedStringItem19);
sharedStringTable1.Append(sharedStringItem20);
sharedStringTable1.Append(sharedStringItem21);
sharedStringTable1.Append(sharedStringItem22);
sharedStringTable1.Append(sharedStringItem23);
sharedStringTable1.Append(sharedStringItem24);
sharedStringTable1.Append(sharedStringItem25);
sharedStringTable1.Append(sharedStringItem26);
sharedStringTable1.Append(sharedStringItem27);
sharedStringTable1.Append(sharedStringItem28);
sharedStringTable1.Append(sharedStringItem29);
sharedStringTable1.Append(sharedStringItem30);
sharedStringTable1.Append(sharedStringItem31);
sharedStringTable1.Append(sharedStringItem32);
sharedStringTable1.Append(sharedStringItem33);
sharedStringTable1.Append(sharedStringItem34);
sharedStringTable1.Append(sharedStringItem35);
sharedStringTable1.Append(sharedStringItem36);
sharedStringTable1.Append(sharedStringItem37);
sharedStringTable1.Append(sharedStringItem38);
sharedStringTable1.Append(sharedStringItem39);
sharedStringTable1.Append(sharedStringItem40);
sharedStringTable1.Append(sharedStringItem41);
sharedStringTable1.Append(sharedStringItem42);
sharedStringTable1.Append(sharedStringItem43);
sharedStringTable1.Append(sharedStringItem44);
sharedStringTable1.Append(sharedStringItem45);
sharedStringTable1.Append(sharedStringItem46);
sharedStringTable1.Append(sharedStringItem47);
sharedStringTable1.Append(sharedStringItem48);
sharedStringTable1.Append(sharedStringItem49);
sharedStringTable1.Append(sharedStringItem50);
sharedStringTable1.Append(sharedStringItem51);
sharedStringTable1.Append(sharedStringItem52);
sharedStringTable1.Append(sharedStringItem53);
sharedStringTable1.Append(sharedStringItem54);
sharedStringTable1.Append(sharedStringItem55);
sharedStringTable1.Append(sharedStringItem56);
sharedStringTable1.Append(sharedStringItem57);
sharedStringTable1.Append(sharedStringItem58);
sharedStringTable1.Append(sharedStringItem59);
sharedStringTable1.Append(sharedStringItem60);
sharedStringTable1.Append(sharedStringItem61);
sharedStringTable1.Append(sharedStringItem62);
sharedStringTable1.Append(sharedStringItem63);
sharedStringTable1.Append(sharedStringItem64);
sharedStringTable1.Append(sharedStringItem65);
sharedStringTablePart.SharedStringTable = sharedStringTable1;
}
// Generates content of sharedStringTablePart1.
private void GenerateSharedStringTablePart1Content(SharedStringTablePart sharedStringTablePart1)
{
SharedStringTable sharedStringTable1 = new SharedStringTable() { Count = (UInt32Value)54U, UniqueCount = (UInt32Value)22U };
SharedStringItem sharedStringItem1 = new SharedStringItem();
Text text1 = new Text() { Space = SpaceProcessingModeValues.Preserve };
text1.Text = "Av. Corrientes 6277 ( 1427) Buenos Aires ";
sharedStringItem1.Append(text1);
SharedStringItem sharedStringItem2 = new SharedStringItem();
Text text2 = new Text();
text2.Text = "Argentina - Tel.: 4323-9931";
sharedStringItem2.Append(text2);
SharedStringItem sharedStringItem3 = new SharedStringItem();
Text text3 = new Text();
text3.Text = "ORDEN DE PUBLICIDAD";
sharedStringItem3.Append(text3);
SharedStringItem sharedStringItem4 = new SharedStringItem();
Text text4 = new Text();
text4.Text = "ORDEN DE PUBLICIDAD Nº";
sharedStringItem4.Append(text4);
SharedStringItem sharedStringItem5 = new SharedStringItem();
Text text5 = new Text();
text5.Text = "MEDIO:";
sharedStringItem5.Append(text5);
SharedStringItem sharedStringItem6 = new SharedStringItem();
Text text6 = new Text();
text6.Text = "CLIENTE:";
sharedStringItem6.Append(text6);
SharedStringItem sharedStringItem7 = new SharedStringItem();
Text text7 = new Text();
text7.Text = "FECHA DE EMISION:";
sharedStringItem7.Append(text7);
SharedStringItem sharedStringItem8 = new SharedStringItem();
Text text8 = new Text();
text8.Text = "CONTACTO:";
sharedStringItem8.Append(text8);
SharedStringItem sharedStringItem9 = new SharedStringItem();
Text text9 = new Text() { Space = SpaceProcessingModeValues.Preserve };
text9.Text = "EMAIL: ";
sharedStringItem9.Append(text9);
SharedStringItem sharedStringItem10 = new SharedStringItem();
Text text10 = new Text();
text10.Text = "HORARIO:";
sharedStringItem10.Append(text10);
SharedStringItem sharedStringItem11 = new SharedStringItem();
Text text11 = new Text();
text11.Text = "HORARIO";
sharedStringItem11.Append(text11);
SharedStringItem sharedStringItem12 = new SharedStringItem();
Text text12 = new Text();
text12.Text = "LUNES";
sharedStringItem12.Append(text12);
SharedStringItem sharedStringItem13 = new SharedStringItem();
Text text13 = new Text();
text13.Text = "MARTES";
sharedStringItem13.Append(text13);
SharedStringItem sharedStringItem14 = new SharedStringItem();
Text text14 = new Text();
text14.Text = "MIERCOLES";
sharedStringItem14.Append(text14);
SharedStringItem sharedStringItem15 = new SharedStringItem();
Text text15 = new Text();
text15.Text = "JUEVES";
sharedStringItem15.Append(text15);
SharedStringItem sharedStringItem16 = new SharedStringItem();
Text text16 = new Text();
text16.Text = "VIERNES";
sharedStringItem16.Append(text16);
SharedStringItem sharedStringItem17 = new SharedStringItem();
Text text17 = new Text();
text17.Text = "SABADO";
sharedStringItem17.Append(text17);
SharedStringItem sharedStringItem18 = new SharedStringItem();
Text text18 = new Text();
text18.Text = "DOMINGO";
sharedStringItem18.Append(text18);
SharedStringItem sharedStringItem19 = new SharedStringItem();
Text text19 = new Text();
text19.Text = "TOTAL SALIDAS";
sharedStringItem19.Append(text19);
SharedStringItem sharedStringItem20 = new SharedStringItem();
Text text20 = new Text();
text20.Text = "COSTO X INFOMERCIAL";
sharedStringItem20.Append(text20);
SharedStringItem sharedStringItem21 = new SharedStringItem();
Text text21 = new Text();
text21.Text = "SUBTOTAL";
sharedStringItem21.Append(text21);
SharedStringItem sharedStringItem22 = new SharedStringItem();
Text text22 = new Text();
text22.Text = "TOTAL";
sharedStringItem22.Append(text22);
sharedStringTable1.Append(sharedStringItem1);
sharedStringTable1.Append(sharedStringItem2);
sharedStringTable1.Append(sharedStringItem3);
sharedStringTable1.Append(sharedStringItem4);
sharedStringTable1.Append(sharedStringItem5);
sharedStringTable1.Append(sharedStringItem6);
sharedStringTable1.Append(sharedStringItem7);
sharedStringTable1.Append(sharedStringItem8);
sharedStringTable1.Append(sharedStringItem9);
sharedStringTable1.Append(sharedStringItem10);
sharedStringTable1.Append(sharedStringItem11);
sharedStringTable1.Append(sharedStringItem12);
sharedStringTable1.Append(sharedStringItem13);
sharedStringTable1.Append(sharedStringItem14);
sharedStringTable1.Append(sharedStringItem15);
sharedStringTable1.Append(sharedStringItem16);
sharedStringTable1.Append(sharedStringItem17);
sharedStringTable1.Append(sharedStringItem18);
sharedStringTable1.Append(sharedStringItem19);
sharedStringTable1.Append(sharedStringItem20);
sharedStringTable1.Append(sharedStringItem21);
sharedStringTable1.Append(sharedStringItem22);
sharedStringTablePart1.SharedStringTable = sharedStringTable1;
}
private void CreateParts(SpreadsheetDocument document)
{
WorkbookPart workbookPart1 = document.AddWorkbookPart();
#region 添加webbook 并且添加一个 sheet1
CreateSheet(workbookPart1);
#endregion
WorksheetPart worksheetPart1 = workbookPart1.AddNewPart <WorksheetPart>("rId1");
#region 添加excel的行 列 有多少就得设置多少，要不然会报错
Worksheet worksheet1 = new Worksheet()
{
MCAttributes = new MarkupCompatibilityAttributes()
{
Ignorable = "x14ac"
}
};
worksheet1.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
worksheet1.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
worksheet1.AddNamespaceDeclaration("x14ac", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac");
SheetViews sheetViews1 = new SheetViews();
SheetView sheetView1 = new SheetView()
{
TabSelected = true, WorkbookViewId = (UInt32Value)0U
};
sheetViews1.Append(sheetView1);
SheetData sheetData1 = new SheetData();
int m = 0;
for (int i = 1; i < 4001; i++)
{
Row row = new Row()
{
RowIndex = (UInt32Value)(System.UInt32)i, Spans = new ListValue <StringValue>()
{
InnerText = "1:2"
}, DyDescent = 0.15D
};
for (int k = 0; k < 50; k++)
{
Cell cell = new Cell()
{
CellReference = ZM[k] + i.ToString(), DataType = CellValues.SharedString
};
cell.Append(new CellValue()
{
Text = m.ToString()
});
m++;
row.Append(cell);
}
sheetData1.Append(row);
}
worksheet1.Append(sheetViews1);
worksheet1.Append(sheetData1);
worksheetPart1.Worksheet = worksheet1;
#endregion
//设置 excel的内容
SharedStringTablePart sharedStringTablePart1 = workbookPart1.AddNewPart <SharedStringTablePart>("rId4");
#region 填充excel的内容 上面设置了多少个单元格 这个里面就得有多少，要不然报错
SharedStringTable sharedStringTable1 = new SharedStringTable()
{
Count = 1, UniqueCount = 1
};
for (int i = 0; i < 4000; i++)
{
for (int k = 0; k < 50; k++)
{
SharedStringItem sharedStringItem = new SharedStringItem();
sharedStringItem.Append(new Text()
{
Text = i.ToString() + "-" + k.ToString()
});
sharedStringTable1.Append(sharedStringItem);
}
}
sharedStringTablePart1.SharedStringTable = sharedStringTable1;
#endregion
SetPackageProperties(document);
}
// Generates content of sharedStringTablePart1.
private void GenerateSharedStringTablePart1Content(SharedStringTablePart sharedStringTablePart1)
{
SharedStringTable sharedStringTable1 = new SharedStringTable() { Count = (UInt32Value)7U, UniqueCount = (UInt32Value)7U };
SharedStringItem sharedStringItem1 = new SharedStringItem();
Text text16 = new Text();
text16.Text = "Formatted Text";
sharedStringItem1.Append(text16);
SharedStringItem sharedStringItem2 = new SharedStringItem();
Text text17 = new Text();
text17.Text = "Now is the time for all good men to come to the aid of their country.";
sharedStringItem2.Append(text17);
SharedStringItem sharedStringItem3 = new SharedStringItem();
Text text18 = new Text();
text18.Text = "Second sheet";
sharedStringItem3.Append(text18);
SharedStringItem sharedStringItem4 = new SharedStringItem();
Text text19 = new Text();
text19.Text = "a";
sharedStringItem4.Append(text19);
SharedStringItem sharedStringItem5 = new SharedStringItem();
Text text20 = new Text();
text20.Text = "b";
sharedStringItem5.Append(text20);
SharedStringItem sharedStringItem6 = new SharedStringItem();
Text text21 = new Text();
text21.Text = "c";
sharedStringItem6.Append(text21);
SharedStringItem sharedStringItem7 = new SharedStringItem();
Text text22 = new Text();
text22.Text = "www.ericwhite.com";
sharedStringItem7.Append(text22);
sharedStringTable1.Append(sharedStringItem1);
sharedStringTable1.Append(sharedStringItem2);
sharedStringTable1.Append(sharedStringItem3);
sharedStringTable1.Append(sharedStringItem4);
sharedStringTable1.Append(sharedStringItem5);
sharedStringTable1.Append(sharedStringItem6);
sharedStringTable1.Append(sharedStringItem7);
sharedStringTablePart1.SharedStringTable = sharedStringTable1;
}
// Generates content of sharedStringTablePart1.
private void GenerateSharedStringTablePart1Content(SharedStringTablePart sharedStringTablePart1)
{
SharedStringTable sharedStringTable1 = new SharedStringTable(){ Count = (UInt32Value)18U, UniqueCount = (UInt32Value)15U };
SharedStringItem sharedStringItem1 = new SharedStringItem();
Text text1 = new Text();
text1.Text = "TEST_A_1";
PhoneticProperties phoneticProperties1 = new PhoneticProperties(){ FontId = (UInt32Value)1U };
sharedStringItem1.Append(text1);
sharedStringItem1.Append(phoneticProperties1);
SharedStringItem sharedStringItem2 = new SharedStringItem();
Text text2 = new Text();
text2.Text = "TEST_A_2";
PhoneticProperties phoneticProperties2 = new PhoneticProperties(){ FontId = (UInt32Value)1U };
sharedStringItem2.Append(text2);
sharedStringItem2.Append(phoneticProperties2);
SharedStringItem sharedStringItem3 = new SharedStringItem();
Text text3 = new Text();
text3.Text = "A";
PhoneticProperties phoneticProperties3 = new PhoneticProperties(){ FontId = (UInt32Value)1U };
sharedStringItem3.Append(text3);
sharedStringItem3.Append(phoneticProperties3);
SharedStringItem sharedStringItem4 = new SharedStringItem();
Text text4 = new Text();
text4.Text = "B";
PhoneticProperties phoneticProperties4 = new PhoneticProperties(){ FontId = (UInt32Value)1U };
sharedStringItem4.Append(text4);
sharedStringItem4.Append(phoneticProperties4);
SharedStringItem sharedStringItem5 = new SharedStringItem();
Text text5 = new Text();
text5.Text = "TEST_B_1";
PhoneticProperties phoneticProperties5 = new PhoneticProperties(){ FontId = (UInt32Value)1U };
sharedStringItem5.Append(text5);
sharedStringItem5.Append(phoneticProperties5);
SharedStringItem sharedStringItem6 = new SharedStringItem();
Text text6 = new Text();
text6.Text = "TEST_B_2";
PhoneticProperties phoneticProperties6 = new PhoneticProperties(){ FontId = (UInt32Value)1U };
sharedStringItem6.Append(text6);
sharedStringItem6.Append(phoneticProperties6);
SharedStringItem sharedStringItem7 = new SharedStringItem();
Text text7 = new Text();
text7.Text = "TETS_A_3";
PhoneticProperties phoneticProperties7 = new PhoneticProperties(){ FontId = (UInt32Value)1U };
sharedStringItem7.Append(text7);
sharedStringItem7.Append(phoneticProperties7);
SharedStringItem sharedStringItem8 = new SharedStringItem();
Text text8 = new Text();
text8.Text = "C";
PhoneticProperties phoneticProperties8 = new PhoneticProperties(){ FontId = (UInt32Value)1U };
sharedStringItem8.Append(text8);
sharedStringItem8.Append(phoneticProperties8);
SharedStringItem sharedStringItem9 = new SharedStringItem();
Text text9 = new Text();
text9.Text = "TEST_B_3";
PhoneticProperties phoneticProperties9 = new PhoneticProperties(){ FontId = (UInt32Value)1U };
sharedStringItem9.Append(text9);
sharedStringItem9.Append(phoneticProperties9);
SharedStringItem sharedStringItem10 = new SharedStringItem();
Text text10 = new Text();
text10.Text = "D";
PhoneticProperties phoneticProperties10 = new PhoneticProperties(){ FontId = (UInt32Value)1U };
sharedStringItem10.Append(text10);
sharedStringItem10.Append(phoneticProperties10);
SharedStringItem sharedStringItem11 = new SharedStringItem();
Text text11 = new Text();
text11.Text = "E";
PhoneticProperties phoneticProperties11 = new PhoneticProperties(){ FontId = (UInt32Value)1U };
sharedStringItem11.Append(text11);
sharedStringItem11.Append(phoneticProperties11);
SharedStringItem sharedStringItem12 = new SharedStringItem();
Text text12 = new Text();
text12.Text = "F";
PhoneticProperties phoneticProperties12 = new PhoneticProperties(){ FontId = (UInt32Value)1U };
sharedStringItem12.Append(text12);
sharedStringItem12.Append(phoneticProperties12);
SharedStringItem sharedStringItem13 = new SharedStringItem();
Text text13 = new Text();
text13.Text = "Column1";
sharedStringItem13.Append(text13);
SharedStringItem sharedStringItem14 = new SharedStringItem();
Text text14 = new Text();
text14.Text = "Column2";
sharedStringItem14.Append(text14);
SharedStringItem sharedStringItem15 = new SharedStringItem();
Text text15 = new Text();
text15.Text = "Column3";
sharedStringItem15.Append(text15);
sharedStringTable1.Append(sharedStringItem1);
sharedStringTable1.Append(sharedStringItem2);
sharedStringTable1.Append(sharedStringItem3);
sharedStringTable1.Append(sharedStringItem4);
sharedStringTable1.Append(sharedStringItem5);
sharedStringTable1.Append(sharedStringItem6);
sharedStringTable1.Append(sharedStringItem7);
sharedStringTable1.Append(sharedStringItem8);
sharedStringTable1.Append(sharedStringItem9);
sharedStringTable1.Append(sharedStringItem10);
sharedStringTable1.Append(sharedStringItem11);
sharedStringTable1.Append(sharedStringItem12);
sharedStringTable1.Append(sharedStringItem13);
sharedStringTable1.Append(sharedStringItem14);
sharedStringTable1.Append(sharedStringItem15);
sharedStringTablePart1.SharedStringTable = sharedStringTable1;
}
// Generates content of sharedStringTablePart1.
private void GenerateSharedStringTablePart1Content(SharedStringTablePart sharedStringTablePart1)
{
SharedStringTable sharedStringTable1 = new SharedStringTable() { Count = (UInt32Value)18U, UniqueCount = (UInt32Value)17U };
SharedStringItem sharedStringItem1 = new SharedStringItem();
Text text1 = new Text();
text1.Text = "Tel. / Fax.:";
sharedStringItem1.Append(text1);
SharedStringItem sharedStringItem2 = new SharedStringItem();
Text text2 = new Text() { Space = SpaceProcessingModeValues.Preserve };
text2.Text = "Att.: ";
sharedStringItem2.Append(text2);
SharedStringItem sharedStringItem3 = new SharedStringItem();
Text text3 = new Text();
text3.Text = "Fecha:";
sharedStringItem3.Append(text3);
SharedStringItem sharedStringItem4 = new SharedStringItem();
Text text4 = new Text();
text4.Text = "Medio:";
sharedStringItem4.Append(text4);
SharedStringItem sharedStringItem5 = new SharedStringItem();
Text text5 = new Text();
text5.Text = "EDITORIAL";
sharedStringItem5.Append(text5);
SharedStringItem sharedStringItem6 = new SharedStringItem();
Text text6 = new Text();
text6.Text = "REVISTA";
sharedStringItem6.Append(text6);
SharedStringItem sharedStringItem7 = new SharedStringItem();
Text text7 = new Text();
text7.Text = "MEDIDA";
sharedStringItem7.Append(text7);
SharedStringItem sharedStringItem8 = new SharedStringItem();
Text text8 = new Text();
text8.Text = "PRODUCTO";
sharedStringItem8.Append(text8);
SharedStringItem sharedStringItem9 = new SharedStringItem();
Text text9 = new Text();
text9.Text = "Argentina - Tel.: 4323-9931";
sharedStringItem9.Append(text9);
SharedStringItem sharedStringItem10 = new SharedStringItem();
Text text10 = new Text();
text10.Text = "Av. Corrientes 6277";
sharedStringItem10.Append(text10);
SharedStringItem sharedStringItem11 = new SharedStringItem();
Text text11 = new Text() { Space = SpaceProcessingModeValues.Preserve };
text11.Text = "(C1427BPA) Buenos Aires ";
sharedStringItem11.Append(text11);
SharedStringItem sharedStringItem12 = new SharedStringItem();
Text text12 = new Text();
text12.Text = "ORDEN DE PUBLICIDAD";
sharedStringItem12.Append(text12);
SharedStringItem sharedStringItem13 = new SharedStringItem();
Text text13 = new Text();
text13.Text = "Subtotal:";
sharedStringItem13.Append(text13);
SharedStringItem sharedStringItem14 = new SharedStringItem();
Text text14 = new Text();
text14.Text = "iva 21%:";
sharedStringItem14.Append(text14);
SharedStringItem sharedStringItem15 = new SharedStringItem();
Text text15 = new Text();
text15.Text = "Total";
sharedStringItem15.Append(text15);
SharedStringItem sharedStringItem16 = new SharedStringItem();
Text text16 = new Text();
text16.Text = "FECHA";
sharedStringItem16.Append(text16);
SharedStringItem sharedStringItem17 = new SharedStringItem();
Text text17 = new Text();
text17.Text = "COSTO";
sharedStringItem17.Append(text17);
sharedStringTable1.Append(sharedStringItem1);
sharedStringTable1.Append(sharedStringItem2);
sharedStringTable1.Append(sharedStringItem3);
sharedStringTable1.Append(sharedStringItem4);
sharedStringTable1.Append(sharedStringItem5);
sharedStringTable1.Append(sharedStringItem6);
sharedStringTable1.Append(sharedStringItem7);
sharedStringTable1.Append(sharedStringItem8);
sharedStringTable1.Append(sharedStringItem9);
sharedStringTable1.Append(sharedStringItem10);
sharedStringTable1.Append(sharedStringItem11);
sharedStringTable1.Append(sharedStringItem12);
sharedStringTable1.Append(sharedStringItem13);
sharedStringTable1.Append(sharedStringItem14);
sharedStringTable1.Append(sharedStringItem15);
sharedStringTable1.Append(sharedStringItem16);
sharedStringTable1.Append(sharedStringItem17);
sharedStringTablePart1.SharedStringTable = sharedStringTable1;
}
public Stream getExcel(DataTable data, List <PageColumn> column)
{
MemoryStream stream = new MemoryStream();
using (SpreadsheetDocument document = SpreadsheetDocument.Create(stream, SpreadsheetDocumentType.Workbook))
{
WorkbookPart workbookPart1 = document.AddWorkbookPart();
//创建 sheet
CreateSheet(workbookPart1);
//创建excel管理
#region 填充管理excel行列
WorksheetPart worksheetPart1 = workbookPart1.AddNewPart <WorksheetPart>("rId1");
Worksheet worksheet1 = new Worksheet()
{
MCAttributes = new MarkupCompatibilityAttributes()
{
Ignorable = "x14ac"
}
};
worksheet1.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
worksheet1.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
worksheet1.AddNamespaceDeclaration("x14ac", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac");
SheetViews sheetViews1 = new SheetViews();
SheetView sheetView1 = new SheetView()
{
TabSelected = true, WorkbookViewId = (UInt32Value)0U
};
sheetViews1.Append(sheetView1);
SheetData sheetData1 = new SheetData();
int m = 0;
//+2 解释一下 excel从 1 开始 再加表头
for (int i = 1; i < data.Rows.Count + 2; i++)
{
Row row = new Row()
{
RowIndex = (UInt32Value)(System.UInt32)i, Spans = new ListValue <StringValue>()
{
InnerText = "1:2"
}, DyDescent = 0.15D
};
for (int k = 0; k < column.Count; k++)
{
Cell cell = new Cell()
{
CellReference = ZM[k] + i.ToString(), DataType = CellValues.SharedString
};
cell.Append(new CellValue()
{
Text = m.ToString()
});
m++;
row.Append(cell);
}
sheetData1.Append(row);
}
worksheet1.Append(sheetViews1);
worksheet1.Append(sheetData1);
worksheetPart1.Worksheet = worksheet1;
#endregion
//填充数据
#region 数据根据管理了的cell从左往右 从上往下填充
SharedStringTablePart sharedStringTablePart1 = workbookPart1.AddNewPart <SharedStringTablePart>("rId4");
SharedStringTable sharedStringTable1 = new SharedStringTable()
{
Count = 1, UniqueCount = 1
};
//填充表头
foreach (var i in column)
{
SharedStringItem sharedStringItem = new SharedStringItem();
sharedStringItem.Append(new Text()
{
Text = i.title
});
sharedStringTable1.Append(sharedStringItem);
}
//填充表体
foreach (DataRow i in data.Rows)
{
foreach (var k in column)
{
SharedStringItem sharedStringItem = new SharedStringItem();
sharedStringItem.Append(new Text()
{
Text = i[k.field].ToString()
});
sharedStringTable1.Append(sharedStringItem);
}
}
sharedStringTablePart1.SharedStringTable = sharedStringTable1;
#endregion
SetPackageProperties(document);
}
return(stream);
}
// Generates content of sharedStringTablePart1.
private void GenerateSharedStringTablePart1Content(SharedStringTablePart sharedStringTablePart1)
{
SharedStringTable sharedStringTable1 = new SharedStringTable(){ Count = (UInt32Value)1U, UniqueCount = (UInt32Value)1U };
SharedStringItem sharedStringItem1 = new SharedStringItem();
Text text1 = new Text();
text1.Text = "este es un texto en A1";
sharedStringItem1.Append(text1);
sharedStringTable1.Append(sharedStringItem1);
sharedStringTablePart1.SharedStringTable = sharedStringTable1;
}
// Generates content of sharedStringTablePart1.
private void GenerateSharedStringTablePart1Content(SharedStringTablePart sharedStringTablePart1)
{
SharedStringTable sharedStringTable1 = new SharedStringTable(){ Count = (UInt32Value)53U, UniqueCount = (UInt32Value)28U };
SharedStringItem sharedStringItem1 = new SharedStringItem();
Text text1 = new Text();
text1.Text = "account_id";
sharedStringItem1.Append(text1);
SharedStringItem sharedStringItem2 = new SharedStringItem();
Text text2 = new Text();
text2.Text = "account_parent";
sharedStringItem2.Append(text2);
SharedStringItem sharedStringItem3 = new SharedStringItem();
Text text3 = new Text();
text3.Text = "account_description";
sharedStringItem3.Append(text3);
SharedStringItem sharedStringItem4 = new SharedStringItem();
Text text4 = new Text();
text4.Text = "account_type";
sharedStringItem4.Append(text4);
SharedStringItem sharedStringItem5 = new SharedStringItem();
Text text5 = new Text();
text5.Text = "account_rollup";
sharedStringItem5.Append(text5);
SharedStringItem sharedStringItem6 = new SharedStringItem();
Text text6 = new Text();
text6.Text = "Custom Members";
sharedStringItem6.Append(text6);
SharedStringItem sharedStringItem7 = new SharedStringItem();
Text text7 = new Text();
text7.Text = "CurrentUser";
sharedStringItem7.Append(text7);
SharedStringItem sharedStringItem8 = new SharedStringItem();
Text text8 = new Text();
text8.Text = "RefreshTime";
sharedStringItem8.Append(text8);
SharedStringItem sharedStringItem9 = new SharedStringItem();
Text text9 = new Text();
text9.Text = "Total Expense";
sharedStringItem9.Append(text9);
SharedStringItem sharedStringItem10 = new SharedStringItem();
Text text10 = new Text();
text10.Text = "Expense";
sharedStringItem10.Append(text10);
SharedStringItem sharedStringItem11 = new SharedStringItem();
Text text11 = new Text();
text11.Text = "-";
sharedStringItem11.Append(text11);
SharedStringItem sharedStringItem12 = new SharedStringItem();
Text text12 = new Text();
text12.Text = "REDMOND\\pberruti";
sharedStringItem12.Append(text12);
SharedStringItem sharedStringItem13 = new SharedStringItem();
Text text13 = new Text();
text13.Text = "Liabilities";
sharedStringItem13.Append(text13);
SharedStringItem sharedStringItem14 = new SharedStringItem();
Text text14 = new Text();
text14.Text = "Liability";
sharedStringItem14.Append(text14);
SharedStringItem sharedStringItem15 = new SharedStringItem();
Text text15 = new Text();
text15.Text = "~";
sharedStringItem15.Append(text15);
SharedStringItem sharedStringItem16 = new SharedStringItem();
Text text16 = new Text();
text16.Text = "Marketing";
sharedStringItem16.Append(text16);
SharedStringItem sharedStringItem17 = new SharedStringItem();
Text text17 = new Text();
text17.Text = "+";
sharedStringItem17.Append(text17);
SharedStringItem sharedStringItem18 = new SharedStringItem();
Text text18 = new Text();
text18.Text = "Cost of Goods Sold";
sharedStringItem18.Append(text18);
SharedStringItem sharedStringItem19 = new SharedStringItem();
Text text19 = new Text();
text19.Text = "Income";
sharedStringItem19.Append(text19);
SharedStringItem sharedStringItem20 = new SharedStringItem();
Text text20 = new Text();
text20.Text = "General & Administration";
sharedStringItem20.Append(text20);
SharedStringItem sharedStringItem21 = new SharedStringItem();
Text text21 = new Text();
text21.Text = "Lease";
sharedStringItem21.Append(text21);
SharedStringItem sharedStringItem22 = new SharedStringItem();
Text text22 = new Text();
text22.Text = "Gross Sales";
sharedStringItem22.Append(text22);
SharedStringItem sharedStringItem23 = new SharedStringItem();
Text text23 = new Text();
text23.Text = "LookUpCube(\"[Sales]\",\"(Measures.[Store Sales],\"+time.currentmember.UniqueName+\",\"+ Store.currentmember.UniqueName+\")\")";
sharedStringItem23.Append(text23);
SharedStringItem sharedStringItem24 = new SharedStringItem();
Text text24 = new Text();
text24.Text = "Net Sales";
sharedStringItem24.Append(text24);
SharedStringItem sharedStringItem25 = new SharedStringItem();
Text text25 = new Text();
text25.Text = "Net Income";
sharedStringItem25.Append(text25);
SharedStringItem sharedStringItem26 = new SharedStringItem();
Text text26 = new Text();
text26.Text = "Information Systems";
sharedStringItem26.Append(text26);
SharedStringItem sharedStringItem27 = new SharedStringItem();
Text text27 = new Text();
text27.Text = "Assets";
sharedStringItem27.Append(text27);
SharedStringItem sharedStringItem28 = new SharedStringItem();
Text text28 = new Text();
text28.Text = "Asset";
sharedStringItem28.Append(text28);
sharedStringTable1.Append(sharedStringItem1);
sharedStringTable1.Append(sharedStringItem2);
sharedStringTable1.Append(sharedStringItem3);
sharedStringTable1.Append(sharedStringItem4);
sharedStringTable1.Append(sharedStringItem5);
sharedStringTable1.Append(sharedStringItem6);
sharedStringTable1.Append(sharedStringItem7);
sharedStringTable1.Append(sharedStringItem8);
sharedStringTable1.Append(sharedStringItem9);
sharedStringTable1.Append(sharedStringItem10);
sharedStringTable1.Append(sharedStringItem11);
sharedStringTable1.Append(sharedStringItem12);
sharedStringTable1.Append(sharedStringItem13);
sharedStringTable1.Append(sharedStringItem14);
sharedStringTable1.Append(sharedStringItem15);
sharedStringTable1.Append(sharedStringItem16);
sharedStringTable1.Append(sharedStringItem17);
sharedStringTable1.Append(sharedStringItem18);
sharedStringTable1.Append(sharedStringItem19);
sharedStringTable1.Append(sharedStringItem20);
sharedStringTable1.Append(sharedStringItem21);
sharedStringTable1.Append(sharedStringItem22);
sharedStringTable1.Append(sharedStringItem23);
sharedStringTable1.Append(sharedStringItem24);
sharedStringTable1.Append(sharedStringItem25);
sharedStringTable1.Append(sharedStringItem26);
sharedStringTable1.Append(sharedStringItem27);
sharedStringTable1.Append(sharedStringItem28);
sharedStringTablePart1.SharedStringTable = sharedStringTable1;
}
// Generates content of sharedStringTablePart1.
protected override void GenerateSharedStringTablePartContent(SharedStringTablePart sharedStringTablePart)
{
SharedStringTable sharedStringTable1 = new SharedStringTable() { Count = (UInt32Value)29U, UniqueCount = (UInt32Value)28U };
SharedStringItem sharedStringItem1 = new SharedStringItem();
Text text1 = new Text();
text1.Text = "АКТ №" + sampleSelectionRequest.ActNumber;
sharedStringItem1.Append(text1);
SharedStringItem sharedStringItem2 = new SharedStringItem();
Text text2 = new Text();
text2.Text = string.Format("Выполненных работ между {0} и {1}", sampleSelectionRequest.Executor.Name, sampleSelectionRequest.Client.Name);
sharedStringItem2.Append(text2);
SharedStringItem sharedStringItem3 = new SharedStringItem();
Text text3 = new Text();
text3.Text = string.Format("Срок выполнения работ: _______{0}г", DateTime.Now.Year);
sharedStringItem3.Append(text3);
SharedStringItem sharedStringItem4 = new SharedStringItem();
Text text4 = new Text();
text4.Text = "Наименование выполненных работ (оказанных услуг)";
sharedStringItem4.Append(text4);
SharedStringItem sharedStringItem5 = new SharedStringItem();
Text text5 = new Text();
text5.Text = "Стоимость работ (услуг) всего без НДС, руб";
sharedStringItem5.Append(text5);
SharedStringItem sharedStringItem6 = new SharedStringItem();
Text text6 = new Text();
text6.Text = "Ставка НДС, %";
sharedStringItem6.Append(text6);
SharedStringItem sharedStringItem7 = new SharedStringItem();
Text text7 = new Text();
text7.Text = "Сумма НДС, руб";
sharedStringItem7.Append(text7);
SharedStringItem sharedStringItem8 = new SharedStringItem();
Text text8 = new Text();
text8.Text = "Стоимость работ всего с учётом НДС, руб";
sharedStringItem8.Append(text8);
SharedStringItem sharedStringItem9 = new SharedStringItem();
Text text9 = new Text();
text9.Text = "Полный анализ семян";
sharedStringItem9.Append(text9);
SharedStringItem sharedStringItem10 = new SharedStringItem();
Text text10 = new Text();
text10.Text = "Анализ семян на чистоту";
sharedStringItem10.Append(text10);
SharedStringItem sharedStringItem11 = new SharedStringItem();
Text text11 = new Text();
text11.Text = "Анализ семян на влажность";
sharedStringItem11.Append(text11);
SharedStringItem sharedStringItem12 = new SharedStringItem();
Text text12 = new Text();
text12.Text = "Анализ семян на заселенность вредителями";
sharedStringItem12.Append(text12);
SharedStringItem sharedStringItem13 = new SharedStringItem();
Text text13 = new Text();
text13.Text = "Анализ семян на всхожесть";
sharedStringItem13.Append(text13);
SharedStringItem sharedStringItem14 = new SharedStringItem();
Text text14 = new Text();
text14.Text = "Анализ семян на определение массы 1000 семян";
sharedStringItem14.Append(text14);
SharedStringItem sharedStringItem15 = new SharedStringItem();
Text text15 = new Text();
text15.Text = "Анализ семян на жизнеспособность";
sharedStringItem15.Append(text15);
SharedStringItem sharedStringItem16 = new SharedStringItem();
Text text16 = new Text();
text16.Text = "Анализ (для картофеля, лука и т.д.)";
sharedStringItem16.Append(text16);
SharedStringItem sharedStringItem17 = new SharedStringItem();
Text text17 = new Text();
text17.Text = "Фитоанализ";
sharedStringItem17.Append(text17);
SharedStringItem sharedStringItem18 = new SharedStringItem();
Text text18 = new Text();
text18.Text = "Определение алкалоидности семян люпина";
sharedStringItem18.Append(text18);
SharedStringItem sharedStringItem19 = new SharedStringItem();
Text text19 = new Text();
text19.Text = "Итого:";
sharedStringItem19.Append(text19);
SharedStringItem sharedStringItem20 = new SharedStringItem();
Text text20 = new Text();
text20.Text = "Сумма НДС:";
sharedStringItem20.Append(text20);
SharedStringItem sharedStringItem21 = new SharedStringItem();
Text text21 = new Text();
text21.Text = "Всего с учётом НДС:";
sharedStringItem21.Append(text21);
SharedStringItem sharedStringItem22 = new SharedStringItem();
Text text22 = new Text();
text22.Text = "Исполнитель:";
sharedStringItem22.Append(text22);
SharedStringItem sharedStringItem23 = new SharedStringItem();
Text text23 = new Text();
text23.Text = "Заказчик:";
sharedStringItem23.Append(text23);
SharedStringItem sharedStringItem24 = new SharedStringItem();
Text text24 = new Text();
text24.Text = sampleSelectionRequest.Executor.Name;
sharedStringItem24.Append(text24);
SharedStringItem sharedStringItem25 = new SharedStringItem();
Text text25 = new Text();
text25.Text = sampleSelectionRequest.Client.Name;
sharedStringItem25.Append(text25);
SharedStringItem sharedStringItem26 = new SharedStringItem();
Text text26 = new Text();
text26.Text = sampleSelectionRequest.Executor.AccountNumber;
sharedStringItem26.Append(text26);
SharedStringItem sharedStringItem27 = new SharedStringItem();
Text text27 = new Text();
text27.Text = sampleSelectionRequest.Client.AccountNumber;
sharedStringItem27.Append(text27);
SharedStringItem sharedStringItem28 = new SharedStringItem();
Text text28 = new Text();
text28.Text = "подпись";
sharedStringItem28.Append(text28);
sharedStringTable1.Append(sharedStringItem1);
sharedStringTable1.Append(sharedStringItem2);
sharedStringTable1.Append(sharedStringItem3);
sharedStringTable1.Append(sharedStringItem4);
sharedStringTable1.Append(sharedStringItem5);
sharedStringTable1.Append(sharedStringItem6);
sharedStringTable1.Append(sharedStringItem7);
sharedStringTable1.Append(sharedStringItem8);
sharedStringTable1.Append(sharedStringItem9);
sharedStringTable1.Append(sharedStringItem10);
sharedStringTable1.Append(sharedStringItem11);
sharedStringTable1.Append(sharedStringItem12);
sharedStringTable1.Append(sharedStringItem13);
sharedStringTable1.Append(sharedStringItem14);
sharedStringTable1.Append(sharedStringItem15);
sharedStringTable1.Append(sharedStringItem16);
sharedStringTable1.Append(sharedStringItem17);
sharedStringTable1.Append(sharedStringItem18);
sharedStringTable1.Append(sharedStringItem19);
sharedStringTable1.Append(sharedStringItem20);
sharedStringTable1.Append(sharedStringItem21);
sharedStringTable1.Append(sharedStringItem22);
sharedStringTable1.Append(sharedStringItem23);
sharedStringTable1.Append(sharedStringItem24);
sharedStringTable1.Append(sharedStringItem25);
sharedStringTable1.Append(sharedStringItem26);
sharedStringTable1.Append(sharedStringItem27);
sharedStringTable1.Append(sharedStringItem28);
sharedStringTablePart.SharedStringTable = sharedStringTable1;
}
// Generates content of sharedStringTablePart1.
private void GenerateSharedStringTablePart1Content(SharedStringTablePart sharedStringTablePart1)
{
SharedStringTable sharedStringTable1 = new SharedStringTable(){ Count = (UInt32Value)128U, UniqueCount = (UInt32Value)52U };
SharedStringItem sharedStringItem1 = new SharedStringItem();
Text text1 = new Text();
text1.Text = "FECHA DE EMISION:";
sharedStringItem1.Append(text1);
SharedStringItem sharedStringItem2 = new SharedStringItem();
Text text2 = new Text();
text2.Text = "MEDIO";
sharedStringItem2.Append(text2);
SharedStringItem sharedStringItem3 = new SharedStringItem();
Text text3 = new Text();
text3.Text = "PROGRAMA:";
sharedStringItem3.Append(text3);
SharedStringItem sharedStringItem4 = new SharedStringItem();
Text text4 = new Text();
text4.Text = "CONTACTO:";
sharedStringItem4.Append(text4);
SharedStringItem sharedStringItem5 = new SharedStringItem();
Text text5 = new Text();
text5.Text = "TELEFONO/ Fax:";
sharedStringItem5.Append(text5);
SharedStringItem sharedStringItem6 = new SharedStringItem();
Text text6 = new Text();
text6.Text = "DIRECCION:";
sharedStringItem6.Append(text6);
SharedStringItem sharedStringItem7 = new SharedStringItem();
Text text7 = new Text();
text7.Text = "E-MAIL:";
sharedStringItem7.Append(text7);
SharedStringItem sharedStringItem8 = new SharedStringItem();
Text text8 = new Text(){ Space = SpaceProcessingModeValues.Preserve };
text8.Text = "Gerencia DRTV - Marketing ";
sharedStringItem8.Append(text8);
SharedStringItem sharedStringItem9 = new SharedStringItem();
Text text9 = new Text();
text9.Text = "SPRAYETTE S.A";
sharedStringItem9.Append(text9);
SharedStringItem sharedStringItem10 = new SharedStringItem();
Text text10 = new Text();
text10.Text = "IDELMA A. ALVAREZ";
sharedStringItem10.Append(text10);
SharedStringItem sharedStringItem11 = new SharedStringItem();
Text text11 = new Text();
text11.Text = "AMERICA TV";
sharedStringItem11.Append(text11);
SharedStringItem sharedStringItem12 = new SharedStringItem();
Text text12 = new Text();
text12.Text = "INTRUSOS";
sharedStringItem12.Append(text12);
SharedStringItem sharedStringItem13 = new SharedStringItem();
Text text13 = new Text();
text13.Text = "50 SEG";
sharedStringItem13.Append(text13);
SharedStringItem sharedStringItem14 = new SharedStringItem();
Text text14 = new Text();
text14.Text = "SALIDA";
sharedStringItem14.Append(text14);
SharedStringItem sharedStringItem15 = new SharedStringItem();
Text text15 = new Text();
text15.Text = "DURACION";
sharedStringItem15.Append(text15);
SharedStringItem sharedStringItem16 = new SharedStringItem();
Text text16 = new Text();
text16.Text = "LUNES";
sharedStringItem16.Append(text16);
SharedStringItem sharedStringItem17 = new SharedStringItem();
Text text17 = new Text();
text17.Text = "MARTES";
sharedStringItem17.Append(text17);
SharedStringItem sharedStringItem18 = new SharedStringItem();
Text text18 = new Text();
text18.Text = "MIÉRCOLES";
sharedStringItem18.Append(text18);
SharedStringItem sharedStringItem19 = new SharedStringItem();
Text text19 = new Text();
text19.Text = "JUEVES";
sharedStringItem19.Append(text19);
SharedStringItem sharedStringItem20 = new SharedStringItem();
Text text20 = new Text();
text20.Text = "VIERNES";
sharedStringItem20.Append(text20);
SharedStringItem sharedStringItem21 = new SharedStringItem();
Text text21 = new Text();
text21.Text = "SÁBADO";
sharedStringItem21.Append(text21);
SharedStringItem sharedStringItem22 = new SharedStringItem();
Text text22 = new Text();
text22.Text = "DOMINGO";
sharedStringItem22.Append(text22);
SharedStringItem sharedStringItem23 = new SharedStringItem();
Text text23 = new Text();
text23.Text = "SALIDA 1";
sharedStringItem23.Append(text23);
SharedStringItem sharedStringItem24 = new SharedStringItem();
Text text24 = new Text();
text24.Text = "SUBTOTAL";
sharedStringItem24.Append(text24);
SharedStringItem sharedStringItem25 = new SharedStringItem();
Text text25 = new Text();
text25.Text = "HORARIO";
sharedStringItem25.Append(text25);
SharedStringItem sharedStringItem26 = new SharedStringItem();
Text text26 = new Text();
text26.Text = "PNTS TOTALES:";
sharedStringItem26.Append(text26);
SharedStringItem sharedStringItem27 = new SharedStringItem();
Text text27 = new Text();
text27.Text = "COSTO POR SALIDA";
sharedStringItem27.Append(text27);
SharedStringItem sharedStringItem28 = new SharedStringItem();
Text text28 = new Text();
text28.Text = "IVA 21%:";
sharedStringItem28.Append(text28);
SharedStringItem sharedStringItem29 = new SharedStringItem();
Text text29 = new Text();
text29.Text = "TOTAL";
sharedStringItem29.Append(text29);
SharedStringItem sharedStringItem30 = new SharedStringItem();
Text text30 = new Text(){ Space = SpaceProcessingModeValues.Preserve };
text30.Text = "Av. Corrientes 6277 ( 1427) Buenos Aires ";
sharedStringItem30.Append(text30);
SharedStringItem sharedStringItem31 = new SharedStringItem();
Text text31 = new Text();
text31.Text = "Argentina - Tel.: 4323-9931";
sharedStringItem31.Append(text31);
SharedStringItem sharedStringItem32 = new SharedStringItem();
Text text32 = new Text();
text32.Text = "ORDEN DE PUBLICIDAD";
sharedStringItem32.Append(text32);
SharedStringItem sharedStringItem33 = new SharedStringItem();
Text text33 = new Text();
text33.Text = "Orden De Publicidad - INTRUSOS";
sharedStringItem33.Append(text33);
SharedStringItem sharedStringItem34 = new SharedStringItem();
Text text34 = new Text();
text34.Text = "PRODUCTO";
sharedStringItem34.Append(text34);
SharedStringItem sharedStringItem35 = new SharedStringItem();
Text text35 = new Text();
text35.Text = "EMPRESA";
sharedStringItem35.Append(text35);
SharedStringItem sharedStringItem36 = new SharedStringItem();
Text text36 = new Text();
text36.Text = "ZOCALO";
sharedStringItem36.Append(text36);
SharedStringItem sharedStringItem37 = new SharedStringItem();
Text text37 = new Text();
text37.Text = "COD. INGESTA";
sharedStringItem37.Append(text37);
SharedStringItem sharedStringItem38 = new SharedStringItem();
Text text38 = new Text();
text38.Text = "SALIDAS";
sharedStringItem38.Append(text38);
SharedStringItem sharedStringItem39 = new SharedStringItem();
Text text39 = new Text();
text39.Text = "PHILIPS JUICER (GRABADO) cod. 10253";
sharedStringItem39.Append(text39);
SharedStringItem sharedStringItem40 = new SharedStringItem();
Text text40 = new Text();
text40.Text = "POLISHOP";
sharedStringItem40.Append(text40);
SharedStringItem sharedStringItem41 = new SharedStringItem();
Text text41 = new Text();
text41.Text = "INCLUIDO";
sharedStringItem41.Append(text41);
SharedStringItem sharedStringItem42 = new SharedStringItem();
Text text42 = new Text();
text42.Text = "STEP GYM cod. 1652";
sharedStringItem42.Append(text42);
SharedStringItem sharedStringItem43 = new SharedStringItem();
Text text43 = new Text();
text43.Text = "SPRAYETTE";
sharedStringItem43.Append(text43);
SharedStringItem sharedStringItem44 = new SharedStringItem();
Text text44 = new Text();
text44.Text = "MY STIM 2 cod. 1653";
sharedStringItem44.Append(text44);
SharedStringItem sharedStringItem45 = new SharedStringItem();
Text text45 = new Text();
text45.Text = "LA BAGUETTE (GRABADO) cod. 10254";
sharedStringItem45.Append(text45);
SharedStringItem sharedStringItem46 = new SharedStringItem();
Text text46 = new Text();
text46.Text = "NUMERO";
sharedStringItem46.Append(text46);
SharedStringItem sharedStringItem47 = new SharedStringItem();
Text text47 = new Text();
text47.Text = "0800-444-1407";
sharedStringItem47.Append(text47);
SharedStringItem sharedStringItem48 = new SharedStringItem();
Text text48 = new Text();
text48.Text = "EXCLUSIVE";
sharedStringItem48.Append(text48);
SharedStringItem sharedStringItem49 = new SharedStringItem();
Text text49 = new Text();
text49.Text = "0800-444-1429";
sharedStringItem49.Append(text49);
SharedStringItem sharedStringItem50 = new SharedStringItem();
Text text50 = new Text();
text50.Text = "0800-444-1416";
sharedStringItem50.Append(text50);
SharedStringItem sharedStringItem51 = new SharedStringItem();
Text text51 = new Text();
text51.Text = "FEBRERO";
sharedStringItem51.Append(text51);
SharedStringItem sharedStringItem52 = new SharedStringItem();
Text text52 = new Text();
text52.Text = "COMFORTISSE BRA (GRABADO) cod. 1880";
sharedStringItem52.Append(text52);
sharedStringTable1.Append(sharedStringItem1);
sharedStringTable1.Append(sharedStringItem2);
sharedStringTable1.Append(sharedStringItem3);
sharedStringTable1.Append(sharedStringItem4);
sharedStringTable1.Append(sharedStringItem5);
sharedStringTable1.Append(sharedStringItem6);
sharedStringTable1.Append(sharedStringItem7);
sharedStringTable1.Append(sharedStringItem8);
sharedStringTable1.Append(sharedStringItem9);
sharedStringTable1.Append(sharedStringItem10);
sharedStringTable1.Append(sharedStringItem11);
sharedStringTable1.Append(sharedStringItem12);
sharedStringTable1.Append(sharedStringItem13);
sharedStringTable1.Append(sharedStringItem14);
sharedStringTable1.Append(sharedStringItem15);
sharedStringTable1.Append(sharedStringItem16);
sharedStringTable1.Append(sharedStringItem17);
sharedStringTable1.Append(sharedStringItem18);
sharedStringTable1.Append(sharedStringItem19);
sharedStringTable1.Append(sharedStringItem20);
sharedStringTable1.Append(sharedStringItem21);
sharedStringTable1.Append(sharedStringItem22);
sharedStringTable1.Append(sharedStringItem23);
sharedStringTable1.Append(sharedStringItem24);
sharedStringTable1.Append(sharedStringItem25);
sharedStringTable1.Append(sharedStringItem26);
sharedStringTable1.Append(sharedStringItem27);
sharedStringTable1.Append(sharedStringItem28);
sharedStringTable1.Append(sharedStringItem29);
sharedStringTable1.Append(sharedStringItem30);
sharedStringTable1.Append(sharedStringItem31);
sharedStringTable1.Append(sharedStringItem32);
sharedStringTable1.Append(sharedStringItem33);
sharedStringTable1.Append(sharedStringItem34);
sharedStringTable1.Append(sharedStringItem35);
sharedStringTable1.Append(sharedStringItem36);
sharedStringTable1.Append(sharedStringItem37);
sharedStringTable1.Append(sharedStringItem38);
sharedStringTable1.Append(sharedStringItem39);
sharedStringTable1.Append(sharedStringItem40);
sharedStringTable1.Append(sharedStringItem41);
sharedStringTable1.Append(sharedStringItem42);
sharedStringTable1.Append(sharedStringItem43);
sharedStringTable1.Append(sharedStringItem44);
sharedStringTable1.Append(sharedStringItem45);
sharedStringTable1.Append(sharedStringItem46);
sharedStringTable1.Append(sharedStringItem47);
sharedStringTable1.Append(sharedStringItem48);
sharedStringTable1.Append(sharedStringItem49);
sharedStringTable1.Append(sharedStringItem50);
sharedStringTable1.Append(sharedStringItem51);
sharedStringTable1.Append(sharedStringItem52);
sharedStringTablePart1.SharedStringTable = sharedStringTable1;
}
// Generates content of sharedStringTablePart1.
protected override void GenerateSharedStringTablePartContent(SharedStringTablePart sharedStringTablePart)
{
SharedStringTable sharedStringTable1 = new SharedStringTable() { Count = (UInt32Value)65U, UniqueCount = (UInt32Value)42U };
SharedStringItem sharedStringItem1 = new SharedStringItem();
Text text1 = new Text();
text1.Text = "Поставщик:";
sharedStringItem1.Append(text1);
SharedStringItem sharedStringItem2 = new SharedStringItem();
Text text2 = new Text();
text2.Text = sampleSelectionRequest.Executor.ToString();
sharedStringItem2.Append(text2);
SharedStringItem sharedStringItem3 = new SharedStringItem();
Text text3 = new Text();
text3.Text = "СЧЕТ-ФАКТУРА";
sharedStringItem3.Append(text3);
SharedStringItem sharedStringItem4 = new SharedStringItem();
Text text4 = new Text();
text4.Text = "№" + sampleSelectionRequest.InvoiceNumber;
sharedStringItem4.Append(text4);
SharedStringItem sharedStringItem5 = new SharedStringItem();
Text text5 = new Text();
text5.Text = "от " + sampleSelectionRequest.CreationDate.ToLongDateString();
sharedStringItem5.Append(text5);
SharedStringItem sharedStringItem6 = new SharedStringItem();
Text text6 = new Text();
text6.Text = "предоплата за клубневой анализ";
sharedStringItem6.Append(text6);
SharedStringItem sharedStringItem7 = new SharedStringItem();
Text text7 = new Text();
text7.Text = "Плательщик:";
sharedStringItem7.Append(text7);
SharedStringItem sharedStringItem8 = new SharedStringItem();
Text text8 = new Text();
text8.Text = sampleSelectionRequest.Client.ToString();
sharedStringItem8.Append(text8);
SharedStringItem sharedStringItem9 = new SharedStringItem();
Text text9 = new Text();
text9.Text = "Р/сч №";
sharedStringItem9.Append(text9);
var bankRequisitesSubject = sampleSelectionRequest.Executor;
SharedStringItem sharedStringItem10 = new SharedStringItem();
Text text10 = new Text();
text10.Text = bankRequisitesSubject.AccountNumber;
sharedStringItem10.Append(text10);
SharedStringItem sharedStringItem11 = new SharedStringItem();
Text text11 = new Text();
text11.Text = "Банк";
sharedStringItem11.Append(text11);
SharedStringItem sharedStringItem12 = new SharedStringItem();
Text text12 = new Text();
text12.Text = bankRequisitesSubject.AccountBank.Name;
sharedStringItem12.Append(text12);
SharedStringItem sharedStringItem13 = new SharedStringItem();
Text text13 = new Text();
text13.Text = "Код банка";
sharedStringItem13.Append(text13);
SharedStringItem sharedStringItem14 = new SharedStringItem();
Text text14 = new Text();
text14.Text = bankRequisitesSubject.AccountBank.Code.ToString();
sharedStringItem14.Append(text14);
SharedStringItem sharedStringItem15 = new SharedStringItem();
Text text15 = new Text();
text15.Text = "УНН";
sharedStringItem15.Append(text15);
SharedStringItem sharedStringItem16 = new SharedStringItem();
Text text16 = new Text();
text16.Text = string.Format(
"Дополнение. Основание: прейскурант стоимости услуг, выполняемых испекцией по семеноводству № {0} от {1:D}",
sampleSelectionRequest.PriceList.Number,
sampleSelectionRequest.PriceList.BeginDate);
sharedStringItem16.Append(text16);
SharedStringItem sharedStringItem17 = new SharedStringItem();
Text text17 = new Text();
text17.Text = "наименование";
sharedStringItem17.Append(text17);
SharedStringItem sharedStringItem18 = new SharedStringItem();
Text text18 = new Text();
text18.Text = "к-во";
sharedStringItem18.Append(text18);
SharedStringItem sharedStringItem19 = new SharedStringItem();
Text text19 = new Text();
text19.Text = "цена";
sharedStringItem19.Append(text19);
SharedStringItem sharedStringItem20 = new SharedStringItem();
Text text20 = new Text();
text20.Text = "стоимость";
sharedStringItem20.Append(text20);
SharedStringItem sharedStringItem21 = new SharedStringItem();
Text text21 = new Text();
text21.Text = "%ндс";
sharedStringItem21.Append(text21);
SharedStringItem sharedStringItem22 = new SharedStringItem();
Text text22 = new Text();
text22.Text = "Сумма";
sharedStringItem22.Append(text22);
SharedStringItem sharedStringItem23 = new SharedStringItem();
Text text23 = new Text();
text23.Text = "всего с НДС";
sharedStringItem23.Append(text23);
SharedStringItem sharedStringItem24 = new SharedStringItem();
Text text24 = new Text();
text24.Text = "Полный анализ семян";
sharedStringItem24.Append(text24);
SharedStringItem sharedStringItem25 = new SharedStringItem();
Text text25 = new Text();
text25.Text = "54321";
sharedStringItem25.Append(text25);
SharedStringItem sharedStringItem26 = new SharedStringItem();
Text text26 = new Text();
text26.Text = "Анализ семян на чистоту";
sharedStringItem26.Append(text26);
SharedStringItem sharedStringItem27 = new SharedStringItem();
Text text27 = new Text();
text27.Text = "Анализ семян на влажность";
sharedStringItem27.Append(text27);
SharedStringItem sharedStringItem28 = new SharedStringItem();
Text text28 = new Text();
text28.Text = "Анализ семян на заселенность вредителями";
sharedStringItem28.Append(text28);
SharedStringItem sharedStringItem29 = new SharedStringItem();
Text text29 = new Text();
text29.Text = "Анализ семян на всхожесть";
sharedStringItem29.Append(text29);
SharedStringItem sharedStringItem30 = new SharedStringItem();
Text text30 = new Text();
text30.Text = "Анализ семян на определение массы 1000 семян";
sharedStringItem30.Append(text30);
SharedStringItem sharedStringItem31 = new SharedStringItem();
Text text31 = new Text();
text31.Text = "Анализ семян на жизнеспособность";
sharedStringItem31.Append(text31);
SharedStringItem sharedStringItem32 = new SharedStringItem();
Text text32 = new Text();
text32.Text = "Анализ (для картофеля, лука и т.д.)";
sharedStringItem32.Append(text32);
SharedStringItem sharedStringItem33 = new SharedStringItem();
Text text33 = new Text();
text33.Text = "Фитоанализ";
sharedStringItem33.Append(text33);
SharedStringItem sharedStringItem34 = new SharedStringItem();
Text text34 = new Text();
text34.Text = "Определение алкалоидности семян люпина";
sharedStringItem34.Append(text34);
SharedStringItem sharedStringItem35 = new SharedStringItem();
Text text35 = new Text();
text35.Text = "Выдача удостоверения (уведомления)";
sharedStringItem35.Append(text35);
SharedStringItem sharedStringItem36 = new SharedStringItem();
Text text36 = new Text();
text36.Text = "Продление срока действия удостоверения";
sharedStringItem36.Append(text36);
SharedStringItem sharedStringItem37 = new SharedStringItem();
Text text37 = new Text();
text37.Text = "Итого:";
sharedStringItem37.Append(text37);
SharedStringItem sharedStringItem38 = new SharedStringItem();
Text text38 = new Text();
text38.Text = "Всего сумма НДС:";
sharedStringItem38.Append(text38);
SharedStringItem sharedStringItem39 = new SharedStringItem();
Text text39 = new Text();
text39.Text = "Всего с учётом НДС:";
sharedStringItem39.Append(text39);
SharedStringItem sharedStringItem40 = new SharedStringItem();
Text text40 = new Text();
text40.Text = "* Счет-фактура является протоколом согласование цен";
sharedStringItem40.Append(text40);
SharedStringItem sharedStringItem41 = new SharedStringItem();
Text text41 = new Text();
text41.Text = "проба";
sharedStringItem41.Append(text41);
SharedStringItem sharedStringItem42 = new SharedStringItem();
Text text42 = new Text();
text42.Text = "ед. изм.";
sharedStringItem42.Append(text42);
SharedStringItem sharedStringItem43 = new SharedStringItem();
Text text43 = new Text();
text43.Text = sumVat.ToString(SeedsConfiguration.Current.Ui.CurrencyFormat);
sharedStringItem43.Append(text43);
SharedStringItem sharedStringItem44 = new SharedStringItem();
Text text44 = new Text();
text44.Text = sumFullCost.ToString(SeedsConfiguration.Current.Ui.CurrencyFormat);
sharedStringItem44.Append(text44);
sharedStringTable1.Append(sharedStringItem1);
sharedStringTable1.Append(sharedStringItem2);
sharedStringTable1.Append(sharedStringItem3);
sharedStringTable1.Append(sharedStringItem4);
sharedStringTable1.Append(sharedStringItem5);
sharedStringTable1.Append(sharedStringItem6);
sharedStringTable1.Append(sharedStringItem7);
sharedStringTable1.Append(sharedStringItem8);
sharedStringTable1.Append(sharedStringItem9);
sharedStringTable1.Append(sharedStringItem10);
sharedStringTable1.Append(sharedStringItem11);
sharedStringTable1.Append(sharedStringItem12);
sharedStringTable1.Append(sharedStringItem13);
sharedStringTable1.Append(sharedStringItem14);
sharedStringTable1.Append(sharedStringItem15);
sharedStringTable1.Append(sharedStringItem16);
sharedStringTable1.Append(sharedStringItem17);
sharedStringTable1.Append(sharedStringItem18);
sharedStringTable1.Append(sharedStringItem19);
sharedStringTable1.Append(sharedStringItem20);
sharedStringTable1.Append(sharedStringItem21);
sharedStringTable1.Append(sharedStringItem22);
sharedStringTable1.Append(sharedStringItem23);
sharedStringTable1.Append(sharedStringItem24);
sharedStringTable1.Append(sharedStringItem25);
sharedStringTable1.Append(sharedStringItem26);
sharedStringTable1.Append(sharedStringItem27);
sharedStringTable1.Append(sharedStringItem28);
sharedStringTable1.Append(sharedStringItem29);
sharedStringTable1.Append(sharedStringItem30);
sharedStringTable1.Append(sharedStringItem31);
sharedStringTable1.Append(sharedStringItem32);
sharedStringTable1.Append(sharedStringItem33);
sharedStringTable1.Append(sharedStringItem34);
sharedStringTable1.Append(sharedStringItem35);
sharedStringTable1.Append(sharedStringItem36);
sharedStringTable1.Append(sharedStringItem37);
sharedStringTable1.Append(sharedStringItem38);
sharedStringTable1.Append(sharedStringItem39);
sharedStringTable1.Append(sharedStringItem40);
sharedStringTable1.Append(sharedStringItem41);
sharedStringTable1.Append(sharedStringItem42);
sharedStringTable1.Append(sharedStringItem43);
sharedStringTable1.Append(sharedStringItem44);
sharedStringTablePart.SharedStringTable = sharedStringTable1;
}
// Generates content of sharedStringTablePart1.
private void GenerateSharedStringTablePart1Content(SharedStringTablePart sharedStringTablePart1)
{
SharedStringTable sharedStringTable1 = new SharedStringTable() { Count = (UInt32Value)20U, UniqueCount = (UInt32Value)19U };
SharedStringItem sharedStringItem1 = new SharedStringItem();
Text text1 = new Text();
text1.Text = "Totales";
sharedStringItem1.Append(text1);
SharedStringItem sharedStringItem2 = new SharedStringItem();
Text text2 = new Text();
text2.Text = "Av. Corrientes 6277 ( 1427) Buenos Aires";
sharedStringItem2.Append(text2);
SharedStringItem sharedStringItem3 = new SharedStringItem();
Text text3 = new Text() { Space = SpaceProcessingModeValues.Preserve };
text3.Text = " Argentina - Tel.: 4323-9931";
sharedStringItem3.Append(text3);
SharedStringItem sharedStringItem4 = new SharedStringItem();
Text text4 = new Text() { Space = SpaceProcessingModeValues.Preserve };
text4.Text = "Medio: ";
sharedStringItem4.Append(text4);
SharedStringItem sharedStringItem5 = new SharedStringItem();
Text text5 = new Text();
text5.Text = "Costo total";
sharedStringItem5.Append(text5);
SharedStringItem sharedStringItem6 = new SharedStringItem();
Text text6 = new Text();
text6.Text = "PRODUCTO:";
sharedStringItem6.Append(text6);
SharedStringItem sharedStringItem7 = new SharedStringItem();
Text text7 = new Text();
text7.Text = "HORARIO";
sharedStringItem7.Append(text7);
SharedStringItem sharedStringItem8 = new SharedStringItem();
Text text8 = new Text();
text8.Text = "Cantidad";
sharedStringItem8.Append(text8);
SharedStringItem sharedStringItem9 = new SharedStringItem();
Text text9 = new Text();
text9.Text = "Duración";
sharedStringItem9.Append(text9);
SharedStringItem sharedStringItem10 = new SharedStringItem();
Text text10 = new Text();
text10.Text = "Costo";
sharedStringItem10.Append(text10);
SharedStringItem sharedStringItem11 = new SharedStringItem();
Text text11 = new Text();
text11.Text = "Salidas";
sharedStringItem11.Append(text11);
SharedStringItem sharedStringItem12 = new SharedStringItem();
Text text12 = new Text();
text12.Text = "Total";
sharedStringItem12.Append(text12);
SharedStringItem sharedStringItem13 = new SharedStringItem();
Text text13 = new Text();
text13.Text = "Orden de Publicidad:";
sharedStringItem13.Append(text13);
SharedStringItem sharedStringItem14 = new SharedStringItem();
Text text14 = new Text();
text14.Text = "Programa:";
sharedStringItem14.Append(text14);
SharedStringItem sharedStringItem15 = new SharedStringItem();
Text text15 = new Text();
text15.Text = "Fecha de Emisión:";
sharedStringItem15.Append(text15);
SharedStringItem sharedStringItem16 = new SharedStringItem();
Text text16 = new Text();
text16.Text = "Contacto:";
sharedStringItem16.Append(text16);
SharedStringItem sharedStringItem17 = new SharedStringItem();
Text text17 = new Text();
text17.Text = "Tel/Fax:";
sharedStringItem17.Append(text17);
SharedStringItem sharedStringItem18 = new SharedStringItem();
Text text18 = new Text();
text18.Text = "Dirección:";
sharedStringItem18.Append(text18);
SharedStringItem sharedStringItem19 = new SharedStringItem();
Text text19 = new Text();
text19.Text = "Email:";
sharedStringItem19.Append(text19);
sharedStringTable1.Append(sharedStringItem1);
sharedStringTable1.Append(sharedStringItem2);
sharedStringTable1.Append(sharedStringItem3);
sharedStringTable1.Append(sharedStringItem4);
sharedStringTable1.Append(sharedStringItem5);
sharedStringTable1.Append(sharedStringItem6);
sharedStringTable1.Append(sharedStringItem7);
sharedStringTable1.Append(sharedStringItem8);
sharedStringTable1.Append(sharedStringItem9);
sharedStringTable1.Append(sharedStringItem10);
sharedStringTable1.Append(sharedStringItem11);
sharedStringTable1.Append(sharedStringItem12);
sharedStringTable1.Append(sharedStringItem13);
sharedStringTable1.Append(sharedStringItem14);
sharedStringTable1.Append(sharedStringItem15);
sharedStringTable1.Append(sharedStringItem16);
sharedStringTable1.Append(sharedStringItem17);
sharedStringTable1.Append(sharedStringItem18);
sharedStringTable1.Append(sharedStringItem19);
sharedStringTablePart1.SharedStringTable = sharedStringTable1;
}
// Generates content of sharedStringTablePart1.
private void GenerateSharedStringTablePart1Content(SharedStringTablePart sharedStringTablePart1)
{
SharedStringTable sharedStringTable1 = new SharedStringTable() { Count = (UInt32Value)77U, UniqueCount = (UInt32Value)35U };
SharedStringItem sharedStringItem1 = new SharedStringItem();
Text text1 = new Text() { Space = SpaceProcessingModeValues.Preserve };
text1.Text = "Av. Corrientes 6277 ( 1427) Buenos Aires ";
sharedStringItem1.Append(text1);
SharedStringItem sharedStringItem2 = new SharedStringItem();
Text text2 = new Text();
text2.Text = "Argentina - Tel.: 4323-9931";
sharedStringItem2.Append(text2);
SharedStringItem sharedStringItem3 = new SharedStringItem();
Text text3 = new Text();
text3.Text = "ORDEN DE PUBLICIDAD";
sharedStringItem3.Append(text3);
SharedStringItem sharedStringItem4 = new SharedStringItem();
Text text4 = new Text();
text4.Text = "MEDIO";
sharedStringItem4.Append(text4);
SharedStringItem sharedStringItem5 = new SharedStringItem();
Text text5 = new Text();
text5.Text = "PROGRAMA:";
sharedStringItem5.Append(text5);
SharedStringItem sharedStringItem6 = new SharedStringItem();
Text text6 = new Text();
text6.Text = "FECHA DE EMISION:";
sharedStringItem6.Append(text6);
SharedStringItem sharedStringItem7 = new SharedStringItem();
Text text7 = new Text();
text7.Text = "CONTACTO:";
sharedStringItem7.Append(text7);
SharedStringItem sharedStringItem8 = new SharedStringItem();
Text text8 = new Text();
text8.Text = "TELEFONO/ Fax:";
sharedStringItem8.Append(text8);
SharedStringItem sharedStringItem9 = new SharedStringItem();
Text text9 = new Text();
text9.Text = "DIRECCION:";
sharedStringItem9.Append(text9);
SharedStringItem sharedStringItem10 = new SharedStringItem();
Text text10 = new Text();
text10.Text = "E-MAIL:";
sharedStringItem10.Append(text10);
SharedStringItem sharedStringItem11 = new SharedStringItem();
Text text11 = new Text();
text11.Text = "SALIDA";
sharedStringItem11.Append(text11);
SharedStringItem sharedStringItem12 = new SharedStringItem();
Text text12 = new Text();
text12.Text = "DURACION";
sharedStringItem12.Append(text12);
SharedStringItem sharedStringItem13 = new SharedStringItem();
Text text13 = new Text();
text13.Text = "LUNES";
sharedStringItem13.Append(text13);
SharedStringItem sharedStringItem14 = new SharedStringItem();
Text text14 = new Text();
text14.Text = "MARTES";
sharedStringItem14.Append(text14);
SharedStringItem sharedStringItem15 = new SharedStringItem();
Text text15 = new Text();
text15.Text = "MIÉRCOLES";
sharedStringItem15.Append(text15);
SharedStringItem sharedStringItem16 = new SharedStringItem();
Text text16 = new Text();
text16.Text = "JUEVES";
sharedStringItem16.Append(text16);
SharedStringItem sharedStringItem17 = new SharedStringItem();
Text text17 = new Text();
text17.Text = "VIERNES";
sharedStringItem17.Append(text17);
SharedStringItem sharedStringItem18 = new SharedStringItem();
Text text18 = new Text();
text18.Text = "SÁBADO";
sharedStringItem18.Append(text18);
SharedStringItem sharedStringItem19 = new SharedStringItem();
Text text19 = new Text();
text19.Text = "DOMINGO";
sharedStringItem19.Append(text19);
SharedStringItem sharedStringItem20 = new SharedStringItem();
Text text20 = new Text();
text20.Text = "SALIDA 1";
sharedStringItem20.Append(text20);
SharedStringItem sharedStringItem21 = new SharedStringItem();
Text text21 = new Text();
text21.Text = "SUBTOTAL";
sharedStringItem21.Append(text21);
SharedStringItem sharedStringItem22 = new SharedStringItem();
Text text22 = new Text();
text22.Text = "HORARIO";
sharedStringItem22.Append(text22);
SharedStringItem sharedStringItem23 = new SharedStringItem();
Text text23 = new Text();
text23.Text = "PRODUCTO";
sharedStringItem23.Append(text23);
SharedStringItem sharedStringItem24 = new SharedStringItem();
Text text24 = new Text();
text24.Text = "EMPRESA";
sharedStringItem24.Append(text24);
SharedStringItem sharedStringItem25 = new SharedStringItem();
Text text25 = new Text();
text25.Text = "ZOCALO";
sharedStringItem25.Append(text25);
SharedStringItem sharedStringItem26 = new SharedStringItem();
Text text26 = new Text();
text26.Text = "COD. INGESTA";
sharedStringItem26.Append(text26);
SharedStringItem sharedStringItem27 = new SharedStringItem();
Text text27 = new Text();
text27.Text = "SALIDAS";
sharedStringItem27.Append(text27);
SharedStringItem sharedStringItem28 = new SharedStringItem();
Text text28 = new Text();
text28.Text = "PNTS TOTALES:";
sharedStringItem28.Append(text28);
SharedStringItem sharedStringItem29 = new SharedStringItem();
Text text29 = new Text();
text29.Text = "COSTO POR SALIDA";
sharedStringItem29.Append(text29);
SharedStringItem sharedStringItem30 = new SharedStringItem();
Text text30 = new Text();
text30.Text = "IVA 21%:";
sharedStringItem30.Append(text30);
SharedStringItem sharedStringItem31 = new SharedStringItem();
Text text31 = new Text();
text31.Text = "TOTAL";
sharedStringItem31.Append(text31);
SharedStringItem sharedStringItem32 = new SharedStringItem();
Text text32 = new Text();
text32.Text = "NUMERO";
sharedStringItem32.Append(text32);
SharedStringItem sharedStringItem33 = new SharedStringItem();
Text text33 = new Text();
text33.Text = "SPRAYETTE";
sharedStringItem33.Append(text33);
SharedStringItem sharedStringItem34 = new SharedStringItem();
Text text34 = new Text();
text34.Text = "EXCLUSIVE";
sharedStringItem34.Append(text34);
SharedStringItem sharedStringItem35 = new SharedStringItem();
Text text35 = new Text();
text35.Text = "POLISHOP";
sharedStringItem35.Append(text35);
sharedStringTable1.Append(sharedStringItem1);
sharedStringTable1.Append(sharedStringItem2);
sharedStringTable1.Append(sharedStringItem3);
sharedStringTable1.Append(sharedStringItem4);
sharedStringTable1.Append(sharedStringItem5);
sharedStringTable1.Append(sharedStringItem6);
sharedStringTable1.Append(sharedStringItem7);
sharedStringTable1.Append(sharedStringItem8);
sharedStringTable1.Append(sharedStringItem9);
sharedStringTable1.Append(sharedStringItem10);
sharedStringTable1.Append(sharedStringItem11);
sharedStringTable1.Append(sharedStringItem12);
sharedStringTable1.Append(sharedStringItem13);
sharedStringTable1.Append(sharedStringItem14);
sharedStringTable1.Append(sharedStringItem15);
sharedStringTable1.Append(sharedStringItem16);
sharedStringTable1.Append(sharedStringItem17);
sharedStringTable1.Append(sharedStringItem18);
sharedStringTable1.Append(sharedStringItem19);
sharedStringTable1.Append(sharedStringItem20);
sharedStringTable1.Append(sharedStringItem21);
sharedStringTable1.Append(sharedStringItem22);
sharedStringTable1.Append(sharedStringItem23);
sharedStringTable1.Append(sharedStringItem24);
sharedStringTable1.Append(sharedStringItem25);
sharedStringTable1.Append(sharedStringItem26);
sharedStringTable1.Append(sharedStringItem27);
sharedStringTable1.Append(sharedStringItem28);
sharedStringTable1.Append(sharedStringItem29);
sharedStringTable1.Append(sharedStringItem30);
sharedStringTable1.Append(sharedStringItem31);
sharedStringTable1.Append(sharedStringItem32);
sharedStringTable1.Append(sharedStringItem33);
sharedStringTable1.Append(sharedStringItem34);
sharedStringTable1.Append(sharedStringItem35);
sharedStringTablePart1.SharedStringTable = sharedStringTable1;
}