示例#1
0
 public void AddValue(Dictionary <GroupValueSearchKey, bool> map, GroupValueSearchKey groupKey, DataTable table,
                      int valueIndex)
 {
     if (!map.ContainsKey(groupKey))
     {
         object groupValue;
         if (groupKey.SearchKey != null)
         {
             for (var searchKey = groupKey.SearchKey; searchKey != null; searchKey = searchKey.NextKey)
             {
                 if (searchKey.ReusedKey == null)
                 {
                     searchKey.ReusedKey = SearchKey.FindReusedKey(searchKey.KeyName);
                 }
                 if (searchKey.IsFixedValue)
                 {
                     if (!Equals(searchKey.ReusedKey.GetReusedValue(table, valueIndex), searchKey.KeyValue))
                     {
                         return;
                     }
                 }
             }
         }
         if (!GroupValueDict.TryGetValue(groupKey, out groupValue))
         {
             groupValue = 0;
             GroupValueDict.Add(groupKey, groupValue);
         }
         if (groupKey.ReusedKey == null)
         {
             groupKey.ReusedKey = SearchKey.FindReusedKey(groupKey.ValueColName);
         }
         GroupValueDict[groupKey] = CalculateForumla(groupKey.Formula, groupValue,
                                                     groupKey.ReusedKey.GetReusedValue(table, valueIndex));
         map[groupKey] = true;
     }
 }
示例#2
0
        public object GetValue(GroupValueSearchKey groupKey, object defaultValue = null)
        {
            object groupValue;

            return(GroupValueDict.TryGetValue(groupKey, out groupValue) ? groupValue : defaultValue);
        }
示例#3
0
        private static GroupValueSearchKey ParseCellFormulaGroupKey(TplBlock block, TplLine line, string formulaName,
                                                                    string pairValue)
        {
            var groupKey = new GroupValueSearchKey
            {
                Formula = formulaName
            };

            var valueKeyArray = pairValue.Trim()
                                .Split(new[] { TemplateFlags.CellValueKeySpliter }, StringSplitOptions.RemoveEmptyEntries);

            SearchKey nextKey = null;

            for (var i = 0; i < valueKeyArray.Length; i++)
            {
                //GroupKey筛选固定值时
                var valueFixedArray = valueKeyArray[i].Split(new[] { TemplateFlags.CellValueFixedSpliter },
                                                             StringSplitOptions.RemoveEmptyEntries);

                if (i == 0)
                {
                    //第一项Key作为绑定关联列名
                    groupKey.ValueColName = valueFixedArray[0].Trim().ToUpper();
                }
                else
                {
                    var searchKey = new SearchKey
                    {
                        KeyName = valueFixedArray[0].Trim().ToUpper()
                    };
                    if (valueFixedArray.Length > 1)
                    {
                        //包含=号赋固定值
                        searchKey.IsFixedValue = true;
                        searchKey.KeyValue     = valueFixedArray[1];
                    }
                    if (searchKey.KeyName == TemplateFlags.CellGroupKeySearchPattern)
                    {
                        //从之前添加的分组cells中查找
                        searchKey = GetGroupedSearchKey(block, line);
                        if (searchKey == null)
                        {
                            continue;
                        }
                    }
                    if (nextKey == null)
                    {
                        groupKey.SearchKey = searchKey;
                        nextKey            = searchKey;
                    }
                    else
                    {
                        nextKey.NextKey = searchKey;
                        nextKey         = searchKey;
                    }

                    //nextKey置尾,后续值追加到searchKey尾部
                    while (nextKey.NextKey != null)
                    {
                        nextKey = nextKey.NextKey;
                    }
                }
            }

            return(groupKey);
        }