Esempio n. 1
0
    public static void Parse(RjElement parent, ExcelWorksheet sheet, ExcelRow row, int index, string key, int maxNum, bool needTakeValue = true)
    {
        if (string.IsNullOrEmpty(key) && (parent.GetClassType() != RjClassType.COLL))
        {
            if (index < maxNum - 1)
            {
                Parse(parent, sheet, row, index + 1, GetSheetCell(sheet, KEY_ROW_INDEX, index + 1).ToString(), maxNum);
            }
            return;
        }
        // filter " and :
        key = key.Replace("\"", "");
        key = key.Replace(":", "");

        for (int i = 0; i < key.Length; ++i)
        {
            if (key[i] == '[')
            {
                //before
                string _key_before = key.Substring(0, i);
                //after
                string _key_after = key.Substring(i + 1, key.Length - i - 1);

                RjColl _coll = new RjColl(_key_before);
                _coll.SetParent(parent);
                parent.AddElement(_coll);
                if (string.IsNullOrEmpty(_key_after))
                {
                    //must add the value
                    AddElement(_coll, sheet, row, index, null);
                    Parse(_coll, sheet, row, index + 1, GetSheetCell(sheet, KEY_ROW_INDEX, index + 1).ToString(), maxNum);
                }
                else
                {
                    Parse(_coll, sheet, row, index, _key_after, maxNum);
                }
                return;
            }
            else if (key[i] == '{')
            {
                string[] _kks  = key.Split('{');
                RjData   _coll = new RjData(_kks[0]);
                _coll.SetParent(parent);
                parent.AddElement(_coll);
                Parse(_coll, sheet, row, index, _kks[1], maxNum);
                return;
            }
            else if (key[i] == ']')
            {
                //string _raw_key=_sheet.Rows[mc_key_row][_index];

                if (needTakeValue)
                {
                    AddElement(parent, sheet, row, index, null);
                }
                parent = parent.GetPerent();
                if (key.Length == 1)
                {
                    if (index < maxNum - 1)
                    {
                        Parse(parent, sheet, row, index + 1, GetSheetCell(sheet, KEY_ROW_INDEX, index + 1).ToString(), maxNum);
                    }
                }
                else
                {
                    string _key_after = key.Substring(i + 1, key.Length - i - 1);
                    Parse(parent, sheet, row, index, _key_after, maxNum);
                }
                return;
            }
            else if (key[i] == '}')
            {
                string _key_before = key.Substring(0, i);
                string _key_after  = key.Substring(i + 1, key.Length - i - 1);
                //				Debug.Log("before:"+_key_before+" after:"+_key_after);
                bool _need_take = true;
                if (!string.IsNullOrEmpty(_key_before))
                {
                    AddElement(parent, sheet, row, index, _key_before);
                    _need_take = false;
                }
                parent = parent.GetPerent();
                if (string.IsNullOrEmpty(_key_after))
                {
                    if (index < maxNum - 1)
                    {
                        Parse(parent, sheet, row, index + 1, GetSheetCell(sheet, KEY_ROW_INDEX, index + 1).ToString(), maxNum);
                    }
                }
                else
                {
                    Parse(parent, sheet, row, index, _key_after, maxNum, _need_take);
                }
                return;
            }
        }

        AddElement(parent, sheet, row, index, key);


        if (index < maxNum - 1)
        {
            Parse(parent, sheet, row, index + 1, GetSheetCell(sheet, KEY_ROW_INDEX, index + 1).ToString(), maxNum);
        }
    }
Esempio n. 2
0
    public override string ToCSharpCode()
    {
        string _str = "";

        if (!string.IsNullOrEmpty(m_key))
        {
            _str = "\tpublic " + m_type + " " + m_key;

            if (m_type == "LEESAN_")
            {
                m_type = "Dummy" + DmHelper.MagicNum;
                DmHelper.MagicNum++;
                //m_type="LEESAN_";//+DmHelper.DataNameBankList.Count;
                _str = "\tpublic " + m_type + " " + m_key;
                DmHelper.DataNameBankList.Add(m_type);
                RjData _rj = new RjData(null);
                for (int i = 0; i < m_element_list.Count; ++i)
                {
                    _rj.AddElement(m_element_list[i]);
                }
                DmHelper.DataBankList.Add(_rj);
            }
            else
            {
                if (!DmHelper.DataNameBankList.Contains(m_type))
                {
                    if (!string.IsNullOrEmpty(m_type))
                    {
                        DmHelper.DataNameBankList.Add(m_type);
                    }
                    RjData _rj = new RjData(null);
                    for (int i = 0; i < m_element_list.Count; ++i)
                    {
                        _rj.AddElement(m_element_list[i]);
                    }
                    DmHelper.DataBankList.Add(_rj);
                }
            }
        }
        else
        {
            for (int i = 0; i < m_element_list.Count; ++i)
            {
                _str += m_element_list[i].ToCSharpCode();
                if (i < m_element_list.Count - 1)
                {
                    _str += ";\n";
                }
                else
                {
                    _str += ";";
                }
            }
        }
//		string _des="";
//		for(int i=0;i<m_element_list.Count;++i)
//		{
//			_des+=m_element_list[i].GetDes();
//			if(i<m_element_list.Count-1)
//			{
//				_des+=",";
//			}
//		}
//		Debug.Log(_str);
//		return _str+"  //"+_des;
//		if(!_str.Contains(";"))
//		{
//			Debug.Log(_str);
//			//_str+=";";
//		}
        if (string.IsNullOrEmpty(m_des))
        {
            return(_str);
        }
        else
        {
            return(_str + "  //" + m_des);
        }
    }
Esempio n. 3
0
    public void GenerateJsonFile(string fileNameWithoutExtension, bool quick, ExcelPackage package, EtuBuildResult result)
    {
        Console.WriteLine(fileNameWithoutExtension);
        if (package.Workbook == null)
        {
            return;
        }
        if (package.Workbook.Worksheets == null)
        {
            return;
        }
        if (package.Workbook.Worksheets.Count < 1)
        {
            return;
        }

        foreach (var sheet in package.Workbook.Worksheets)
        {
            if (sheet.Dimension == null)
            {
                continue;
            }
            if (sheet.Dimension.Rows < MIN_ROW_COUNT)
            {
                if (result != null)
                {
                    result.skip_sheet_list.Add(fileNameWithoutExtension + "." + sheet.Name);
                }
                continue;
            }

            var    cell      = GetSheetCell(sheet, 0, 0);
            string tableName = cell.ToString();

            if (string.IsNullOrEmpty(tableName))
            {
                if (result != null)
                {
                    result.skip_sheet_list.Add(fileNameWithoutExtension + "." + sheet.Name);
                }
                continue;
            }

            if (sheet.Dimension.Columns > 2)
            {
                var value = GetSheetCell(sheet, 0, 2);
                if (!string.IsNullOrEmpty(value.ToString()))
                {
                    if (result != null)
                    {
                        result.skip_sheet_list.Add(fileNameWithoutExtension + "." + sheet.Name);
                    }
                    continue;
                }
            }

            DmHelper.DataBankList.Clear();
            DmHelper.DataNameBankList.Clear();
            JsonDataType m_json_type = JsonDataType.NORMAL;

            if (!string.IsNullOrEmpty(GetSheetCell(sheet, 0, 1).ToString()))
            {
                if (GetSheetCell(sheet, 0, 1).ToString() == "kv")
                {
                    m_json_type = JsonDataType.KEY_VALUE;
                }
                else if (GetSheetCell(sheet, 0, 1).ToString() == "array")
                {
                    m_json_type = JsonDataType.ARRAY;
                }
                else if (GetSheetCell(sheet, 0, 1).ToString() == "nkv")
                {
                    m_json_type = JsonDataType.NEW_KEY_VALUE;
                }
                else
                {
                    m_json_type = JsonDataType.NORMAL;
                }
            }
            List <string> keys = new List <string>();
            for (int i = sheet.Dimension.Columns - 1; i >= 0; i--)
            {
                string key = GetSheetCell(sheet, KEY_ROW_INDEX, i).ToString();
                keys.Add(key);
            }

            int rowCount = sheet.Dimension.Rows;
            int colCount = sheet.Dimension.Columns;



            int    _real_num     = 0;
            string _info         = "";
            string _sinfo        = "";
            string m_id_key_type = GetSheetCell(sheet, KEY_TYPE_ROW_INDEX, 0).ToString();


            List <string> _id_list = new List <string>();
            Dictionary <string, List <string> > _dic = new Dictionary <string, List <string> >();
            try
            {
                for (int i = VALUE_BEGIN_ROW_INDEX; i < rowCount; i++)
                {
                    if (string.IsNullOrEmpty(GetSheetCell(sheet, i, 0).ToString()))
                    {
                        continue;
                    }

                    if (!_id_list.Contains(GetSheetCell(sheet, i, 0).ToString()))
                    {
                        _id_list.Add(GetSheetCell(sheet, i, 0).ToString());
                    }
                }


                for (int i = VALUE_BEGIN_ROW_INDEX; i < rowCount; i++)
                {
                    if (string.IsNullOrEmpty(GetSheetCell(sheet, i, 0).ToString()))
                    {
                        continue;
                    }

                    RjData _data = new RjData(null);
                    //Parse(_data,sheet,sheet.Rows[i], 0, sheet.Rows[KEY_ROW_INDEX][0].ToString(), colCount);
                    Parse(_data, sheet, sheet.Row(i), 0, GetSheetCell(sheet, KEY_ROW_INDEX, 0).ToString(), colCount);

                    switch (m_json_type)
                    {
                    case JsonDataType.ARRAY:
                    {
                        string _dd     = _data.ToJson();
                        int    _bindex = _dd.IndexOf("\"id\":");
                        int    _eindex = _dd.IndexOf(",");
                        //Debug.Log(_dd);
                        //Debug.Log(_bindex+" "+_eindex);
                        string _temp_id = _dd.Substring(_bindex + 5, _eindex - _bindex - 5);
                        if (!_dic.ContainsKey(_temp_id))
                        {
                            List <string> _ttt = new List <string>();
                            _dic.Add(_temp_id, _ttt);
                        }
                        _dic[_temp_id].Add("{" + _dd.Substring(_eindex + 1, _dd.Length - _eindex - 1));
                    }
                    break;

                    case JsonDataType.NORMAL:
                    default:
                    {
                        string _dd = _data.ToJson();

                        int    _bindex = _dd.IndexOf("\"id\":");
                        int    _eindex = _dd.IndexOf(",");
                        string _id     = _dd.Substring(_bindex + 5, _eindex - _bindex - 5);
//							Debug.Log(_dd);
                        //Debug.Log(_bindex+" "+_eindex);
                        _info += _id.Replace("\"", "") + "`" + _dd;
                        _info += "|";                              //TODO zhaolei

                        if (!quick)
                        {
                            //string _id=_dd.Substring(_bindex+5,_eindex-_bindex-5);
                            if (!_id.Contains("\""))
                            {
                                _sinfo += "\"" + _id + "\":" + _dd;
                            }
                            else
                            {
                                _sinfo += _id + ":" + _dd;
                            }
                            _sinfo += ",";
                        }
                    }
                    break;

                    case JsonDataType.NEW_KEY_VALUE:
                    {
                        _info += _data.ToKeyValue().Replace("=", "`");
                        _info += "|";                                      //TODO zhaolei

                        if (!quick)
                        {
                            string _dd     = _data.ToJson();
                            int    _bindex = _dd.IndexOf("\"id\":");
                            int    _eindex = _dd.IndexOf(",");
                            string _id     = _dd.Substring(_bindex + 5, _eindex - _bindex - 5);
                            if (!_id.Contains("\""))
                            {
                                _sinfo += "\"" + _id + "\":" + _dd;
                            }
                            else
                            {
                                _sinfo += _id + ":" + _dd;
                            }
                            _sinfo += ",";
                        }
                    }
                    break;

                    case JsonDataType.KEY_VALUE:
                    {
                        string _ii     = _data.ToJson();
                        int    _bindex = _ii.IndexOf("\"id\":");
                        int    _eindex = _ii.IndexOf(",");
                        string _id     = _ii.Substring(_bindex + 5, _eindex - _bindex - 5);
                        _info += _id.Replace("\"", "") + "`" + _ii;
                        _info += "|";

                        if (!quick)
                        {
                            _sinfo += _data.ToKeyValueString();
                            _sinfo += ",";
                        }
                    }
                    break;
                    }
                    _real_num++;
                }
                if (result != null)
                {
                    result.done_list.Add(fileNameWithoutExtension + "." + sheet.Name + "==>" + tableName + "   success!!!");
                }
            }

            catch
            {
                if (result != null)
                {
                    result.error_sheet_list.Add(fileNameWithoutExtension + "." + sheet.Name);
                }
                continue;
            }


            if (m_json_type == JsonDataType.ARRAY)
            {
                foreach (KeyValuePair <string, List <string> > _kv in _dic)
                {
                    string _tinfo = "{\"id\":" + _kv.Key + ",\"Coll\":[";
                    foreach (string _kk in _kv.Value)
                    {
                        _tinfo += _kk;
                        _tinfo += ",";
                    }
                    _tinfo  = _tinfo.Remove(_tinfo.Length - 1);
                    _tinfo += "]}";

                    string _dd     = _tinfo;
                    int    _bindex = _dd.IndexOf("\"id\":");
                    int    _eindex = _dd.IndexOf(",");
                    string _id     = _dd.Substring(_bindex + 5, _eindex - _bindex - 5);
                    _info += _id.Replace("\"", "") + "`" + _dd;
                    _info += "|";
                    if (!quick)
                    {
                        _sinfo += "\"" + _id + "\":" + _dd;
                        _sinfo += ",";
                    }
                }
            }

            _info = _info.Remove(_info.Length - 1);
            if (!quick)
            {
                _sinfo = _sinfo.Remove(_sinfo.Length - 1);
                _sinfo = "{" + _sinfo + "}";
            }


            //client
            if (result != null)
            {
                _info = _info.Replace('\n', ' ');
            }


            //----------youhua--------------//
            //_info=InfoTail(_file_name,_info);

            //result.json_str[_file_name] = JsonMapper.Instance.ToObject(_sinfo);

            result.fileNameToJsonObject[tableName] = JsonMapper.Instance.ToObject(_sinfo);

            // var filePath = DataMakerConf.Instance.m_server_dir + tableName + ".json";
            // File.WriteAllText(filePath, _sinfo, Encoding.UTF8);
            // Console.WriteLine(filePath);
        }
    }