| private SetCacheFieldNode ( XmlNode cacheField ) : void | ||
| cacheField | XmlNode | |
| return | void | |
private void AddCacheField(ExcelPivotTableField field, DateTime startDate, DateTime endDate, int interval)
{
//Add Cache definition field.
var cacheTopNode = _table.CacheDefinition.CacheDefinitionXml.SelectSingleNode("//d:cacheFields", _table.NameSpaceManager);
var cacheFieldNode = _table.CacheDefinition.CacheDefinitionXml.CreateElement("cacheField", ExcelPackage.schemaMain);
cacheFieldNode.SetAttribute("name", field.DateGrouping.ToString());
cacheFieldNode.SetAttribute("databaseField", "0");
cacheTopNode.AppendChild(cacheFieldNode);
field.SetCacheFieldNode(cacheFieldNode);
field.SetDateGroup(field.DateGrouping, startDate, endDate, interval);
}
private void AddCacheField(ExcelPivotTableField field, DateTime startDate, DateTime endDate)
{
//Add Cache definition field.
var cacheTopNode = _table.CacheDefinition.CacheDefinitionXml.SelectSingleNode("//d:cacheFields", _table.NameSpaceManager);
var cacheFieldNode = _table.CacheDefinition.CacheDefinitionXml.CreateElement("cacheField", ExcelPackage.schemaMain);
cacheFieldNode.SetAttribute("name", field.DateGrouping.ToString());
cacheFieldNode.SetAttribute("databaseField", "0");
cacheTopNode.AppendChild(cacheFieldNode);
field.SetCacheFieldNode(cacheFieldNode);
field.SetDateGroup(field.DateGrouping, startDate, endDate);
}
private void LoadFields()
{
//Fields.Clear();
//int ix=0;
//foreach(XmlElement fieldNode in PivotXml.SelectNodes("//d:pivotFields/d:pivotField",NameSpaceManager))
//{
// Fields.AddInternal(new ExcelPivotTableField(NameSpaceManager, fieldNode, this, ix++));
//}
int index = 0;
//Add fields.
foreach (XmlElement fieldElem in TopNode.SelectNodes("d:pivotFields/d:pivotField", NameSpaceManager))
{
var fld = new ExcelPivotTableField(NameSpaceManager, fieldElem, this, index, index++);
Fields.AddInternal(fld);
}
//Add fields.
index = 0;
foreach (XmlElement fieldElem in _cacheDefinition.TopNode.SelectNodes("d:cacheFields/d:cacheField", NameSpaceManager))
{
var fld = Fields[index++];
fld.SetCacheFieldNode(fieldElem);
}
}
