Exemplo n.º 1
0
        /// <summary>
        ///     填充除了表头之外每一行数据行,根据给定属性名称清单
        /// </summary>
        /// <param name="list"></param>
        /// <param name="worksheet"></param>
        /// <param name="rowHeads"></param>
        private static void FillRows(IEnumerable <T> list, ExcelWorksheet worksheet, List <RowTitleInfo> rowHeads)
        {
            var rowIndex     = 2;
            var propertyList = (from row in rowHeads select row.AttrName).ToList();
            var entities     = list as T[] ?? list.ToArray();
            var keyTypeDic   =
                ReflectPropertyUtil <T> .ReflectGetPropertyKeyTypePairs(entities.FirstOrDefault(), propertyList);

            foreach (var keyValueDic in entities.Select(t =>
                                                        ReflectPropertyUtil <T> .ReflectGetPropertyKeyValuePairs(t, propertyList)))
            {
                FillCells(keyValueDic, keyTypeDic, rowHeads, worksheet, rowIndex);
                rowIndex++;
            }
        }
Exemplo n.º 2
0
        /// <summary>
        ///     填充worksheet,根据Entity自身属性名称清单
        /// </summary>
        /// <param name="worksheet"></param>
        /// <param name="list"></param>
        /// <returns></returns>
        public static bool FillWorksheet(ExcelWorksheet worksheet, IEnumerable <T> list)
        {
            var entities   = list as T[] ?? list.ToArray();
            var keyTypeDic = ReflectPropertyUtil <T> .ReflectGetPropertyKeyTypePairs(entities.FirstOrDefault());

            var rowHeads = (from typeCode in keyTypeDic select typeCode.Key).ToList();
            var result   = FillHead(worksheet, rowHeads);

            if (!result)
            {
                Logger.Info("填充列头信息失败");
                return(false);
            }

            FillRows(entities, worksheet, keyTypeDic, rowHeads);
            return(true);
        }