Ejemplo n.º 1
0
        /// <summary>
        /// 忽略名单
        /// </summary>
        /// <param name="properties"></param>
        /// <returns></returns>
        static void IgnoreList(out List <Object> properties, bool isSim)
        {
            properties = new List <Object>();
            ExcelTool            excelTool            = new ExcelTool(isSim);
            PropertyConstManager propertyConstManager = ScriptableObject.CreateInstance <PropertyConstManager>();

            properties.Add(propertyConstManager);
            propertyConstManager.PropertyConst = excelTool.CreatePropertyConstArrayWithExcel(ExcelConfig.PropertyConst, ref propertyConstManager.Search);

            PropertyPropertyManager propertyPropertyManager = ScriptableObject.CreateInstance <PropertyPropertyManager>();

            properties.Add(propertyPropertyManager);
            propertyPropertyManager.PropertyProperty = excelTool.CreatePropertyPropertyArrayWithExcel(ExcelConfig.PropertyCH2 + ExcelConfig.PropertyFight, propertyPropertyManager);
        }
Ejemplo n.º 2
0
        public PropertyProperty[] CreatePropertyPropertyArrayWithExcel(string filePath, PropertyPropertyManager iProperty)
        {
            List <string>            keys        = new List <string>();
            Dictionary <string, int> searchdic   = new Dictionary <string, int>();
            Dictionary <string, int> CNSearchdic = new Dictionary <string, int>();
            //获得表数据
            int columnNum = 0, rowNum = 0;
            DataRowCollection collect = ReadExcel(filePath, ref columnNum, ref rowNum, iProperty.TableName());

            //根据excel的定义,第二行开始才是数据
            PropertyProperty[]       array      = new PropertyProperty[rowNum - 2];
            Dictionary <string, int> properties = new Dictionary <string, int>();

            for (int i = 0; i < columnNum; i++)
            {
                if (collect[0][i].ToString() != string.Empty)
                {
                    properties.Add(collect[0][i].ToString(), i);
                }
            }
            for (int i = 2; i < rowNum; i++)
            {
                PropertyProperty item = new PropertyProperty();
                foreach (var singleProperty in properties)
                {
                    PropertyInfo property = typeof(PropertyProperty).GetProperty(singleProperty.Key);
                    if (property != null)
                    {
                        property.SetValue(item,
                                          DataEncryptManager.StringEncoder(TextTrans(collect[i][singleProperty.Value].ToString())));
                    }
                    else
                    {
                        Debug.LogError(singleProperty.Key);
                    }
                }
                //解析每列的数据
                searchdic.Add(DataEncryptManager.StringEncoder(collect[i][0].ToString()), i - 2);
                if (!string.IsNullOrEmpty(collect[i][1].ToString()))
                {
                    var str = Split(Pinyin.GetPinyin(collect[i][1].ToString()));
                    CNSearchdic.Add(str, i - 2);
                    keys.Add(str);
                }
                array[i - 2] = item;
            }
            iProperty.Search   = JsonMapper.ToJson(searchdic);
            iProperty.CNSearch = JsonMapper.ToJson(CNSearchdic);
            CreatePropertyEnum("PropertyPropertyType", keys);
            return(array);
        }