ExcelDataList.cs

Go to the documentation of this file.

using System.Collections.Generic;
using System.IO;
 
public class ExcelDataList
{
    public List<ExcelData> items = new List<ExcelData>(0);
 
    public Dictionary<string, Dictionary<string, string>> all = new Dictionary<string, Dictionary<string, string>>();
 
    public List<Dictionary<string, string>> list = new List<Dictionary<string, string>>();
 
    protected bool initialized;
 
    public virtual int StartIndex => 5;
 
    public void Reload()
    {
        all.Clear();
        list.Clear();
        initialized = false;
    }
 
    public virtual void Initialize()
    {
        if (initialized)
        {
            return;
        }
        foreach (ExcelData item in items)
        {
            item.startIndex = StartIndex;
            List<Dictionary<string, string>> obj = item.BuildList();
            string directoryName = new FileInfo(item.path).DirectoryName;
            foreach (Dictionary<string, string> item2 in obj)
            {
                item2["path"] = directoryName;
                if (item2.TryGetValue("id", out var value))
                {
                    all[value] = item2;
                }
                list.Add(item2);
            }
        }
        OnInitialize();
        initialized = true;
    }
 
    public virtual void OnInitialize()
    {
    }
 
    public bool HasRow(string id)
    {
        Initialize();
        return all.ContainsKey(id);
    }
 
    public Dictionary<string, string> GetRow(string id)
    {
        Initialize();
        return all.TryGetValue(id);
    }
 
    public void Add(ExcelData data)
    {
        items.Add(data);
        Reload();
    }
 
    public void Clear()
    {
        items.Clear();
        Reload();
    }
}