Client/GameClient/Assets/Editor/Excel/Scanner/SuitGuideScanner.cs

using System;
using System.Collections.Generic;
using GFGGame;

namespace GFGEditor
{
    public class SuitGuideScanner
    {
        private static List<int> suitIds = new List<int>();

        public static void StartScan()
        {
            suitIds.Clear();
            var dataArray = SuitGuideMenuCfgArray.Instance.dataArray;

            string strs = "";
            for (int i = 0; i < dataArray.Length; i++)
            {
                SuitGuideMenuCfg cfg = dataArray[i];
                string str = string.Format(";{0}", cfg.suitIds);
                strs += str;
            }

            SQLiteHelper.Instance.OpenConnection();
            try
            {
                foreach (var cfg in dataArray)
                {
                    //SuitGuideMenuCfg cfg = dataArray[0];
                    var names = new string[] { nameof(cfg.suitIds) };
                    var values = new string[] { strs };
                    SQLiteHelper.Instance.UpdateValues(nameof(SuitGuideMenuCfgArray), names, values, nameof(cfg.id), cfg.id.ToString());
                }
            }
            catch (Exception e)
            {
                ET.Log.Error(e.ToString());
            }
            finally
            {
                SQLiteHelper.Instance.CloseConnection();
            }
        }
    }
}