QuanYi/Assets/_Scripts/ExcelData.cs

using System.Collections.Generic;
using UnityEngine;
namespace ZXKFramework 
{ 
    public class ExcelData
    {
        public List<LanguageData> allLanguageData  = null;
public List<OrderDragData> allOrderDragData  = null;
public List<ShowJieGou> allShowJieGou  = null;

        public void Init()
        {  
            allLanguageData = ExcelDataTools.GetDataList<LanguageData>();
allOrderDragData = ExcelDataTools.GetDataList<OrderDragData>();
allShowJieGou = ExcelDataTools.GetDataList<ShowJieGou>();

        }
        
public LanguageData GetLanguageData(int id)
{
    for (int i = 0; i < allLanguageData.Count; i++)
    {
        if (allLanguageData[i].id == id) 
        {
            return allLanguageData[i];
        }
    }
    Debug.LogError(id);
    return null;
}

public OrderDragData GetOrderDragData(int id)
{
    for (int i = 0; i < allOrderDragData.Count; i++)
    {
        if (allOrderDragData[i].id == id) 
        {
            return allOrderDragData[i];
        }
    }
    Debug.LogError(id);
    return null;
}

public ShowJieGou GetShowJieGou(int id)
{
    for (int i = 0; i < allShowJieGou.Count; i++)
    {
        if (allShowJieGou[i].id == id) 
        {
            return allShowJieGou[i];
        }
    }
    Debug.LogError(id);
    return null;
}

public LanguageData GetLanguageDataid(int id)
{
    for (int i = 0; i < allLanguageData.Count; i++)
    {
        if (allLanguageData[i].id == id) 
        {
            return allLanguageData[i];
        }
    }
    Debug.LogError(id);
    return null;
}

public List<int> GetListLanguageDataid()
{
    List<int> res = new List<int>();
    for (int i = 0; i < allLanguageData.Count; i++)
    {
        if (!res.Contains(allLanguageData[i].id)) 
        {
            res.Add(allLanguageData[i].id);
        }
    }
    return res;
}



public LanguageData GetLanguageDataChinese(string Chinese)
{
    for (int i = 0; i < allLanguageData.Count; i++)
    {
        if (allLanguageData[i].Chinese == Chinese) 
        {
            return allLanguageData[i];
        }
    }
    Debug.LogError(Chinese);
    return null;
}

public List<string> GetListLanguageDataChinese()
{
    List<string> res = new List<string>();
    for (int i = 0; i < allLanguageData.Count; i++)
    {
        if (!res.Contains(allLanguageData[i].Chinese)) 
        {
            res.Add(allLanguageData[i].Chinese);
        }
    }
    return res;
}



public LanguageData GetLanguageDataEnglish(string English)
{
    for (int i = 0; i < allLanguageData.Count; i++)
    {
        if (allLanguageData[i].English == English) 
        {
            return allLanguageData[i];
        }
    }
    Debug.LogError(English);
    return null;
}

public List<string> GetListLanguageDataEnglish()
{
    List<string> res = new List<string>();
    for (int i = 0; i < allLanguageData.Count; i++)
    {
        if (!res.Contains(allLanguageData[i].English)) 
        {
            res.Add(allLanguageData[i].English);
        }
    }
    return res;
}



public LanguageData GetLanguageDataJapanese(string Japanese)
{
    for (int i = 0; i < allLanguageData.Count; i++)
    {
        if (allLanguageData[i].Japanese == Japanese) 
        {
            return allLanguageData[i];
        }
    }
    Debug.LogError(Japanese);
    return null;
}

public List<string> GetListLanguageDataJapanese()
{
    List<string> res = new List<string>();
    for (int i = 0; i < allLanguageData.Count; i++)
    {
        if (!res.Contains(allLanguageData[i].Japanese)) 
        {
            res.Add(allLanguageData[i].Japanese);
        }
    }
    return res;
}



public LanguageData GetLanguageDataFrench(string French)
{
    for (int i = 0; i < allLanguageData.Count; i++)
    {
        if (allLanguageData[i].French == French) 
        {
            return allLanguageData[i];
        }
    }
    Debug.LogError(French);
    return null;
}

public List<string> GetListLanguageDataFrench()
{
    List<string> res = new List<string>();
    for (int i = 0; i < allLanguageData.Count; i++)
    {
        if (!res.Contains(allLanguageData[i].French)) 
        {
            res.Add(allLanguageData[i].French);
        }
    }
    return res;
}



public OrderDragData GetOrderDragDataid(int id)
{
    for (int i = 0; i < allOrderDragData.Count; i++)
    {
        if (allOrderDragData[i].id == id) 
        {
            return allOrderDragData[i];
        }
    }
    Debug.LogError(id);
    return null;
}

public List<int> GetListOrderDragDataid()
{
    List<int> res = new List<int>();
    for (int i = 0; i < allOrderDragData.Count; i++)
    {
        if (!res.Contains(allOrderDragData[i].id)) 
        {
            res.Add(allOrderDragData[i].id);
        }
    }
    return res;
}



public OrderDragData GetOrderDragDataorderID(int orderID)
{
    for (int i = 0; i < allOrderDragData.Count; i++)
    {
        if (allOrderDragData[i].orderID == orderID) 
        {
            return allOrderDragData[i];
        }
    }
    Debug.LogError(orderID);
    return null;
}

public List<int> GetListOrderDragDataorderID()
{
    List<int> res = new List<int>();
    for (int i = 0; i < allOrderDragData.Count; i++)
    {
        if (!res.Contains(allOrderDragData[i].orderID)) 
        {
            res.Add(allOrderDragData[i].orderID);
        }
    }
    return res;
}



public OrderDragData GetOrderDragDatadragGameName(string dragGameName)
{
    for (int i = 0; i < allOrderDragData.Count; i++)
    {
        if (allOrderDragData[i].dragGameName == dragGameName) 
        {
            return allOrderDragData[i];
        }
    }
    Debug.LogError(dragGameName);
    return null;
}

public List<string> GetListOrderDragDatadragGameName()
{
    List<string> res = new List<string>();
    for (int i = 0; i < allOrderDragData.Count; i++)
    {
        if (!res.Contains(allOrderDragData[i].dragGameName)) 
        {
            res.Add(allOrderDragData[i].dragGameName);
        }
    }
    return res;
}



public ShowJieGou GetShowJieGouid(int id)
{
    for (int i = 0; i < allShowJieGou.Count; i++)
    {
        if (allShowJieGou[i].id == id) 
        {
            return allShowJieGou[i];
        }
    }
    Debug.LogError(id);
    return null;
}

public List<int> GetListShowJieGouid()
{
    List<int> res = new List<int>();
    for (int i = 0; i < allShowJieGou.Count; i++)
    {
        if (!res.Contains(allShowJieGou[i].id)) 
        {
            res.Add(allShowJieGou[i].id);
        }
    }
    return res;
}



public ShowJieGou GetShowJieGouName(string Name)
{
    for (int i = 0; i < allShowJieGou.Count; i++)
    {
        if (allShowJieGou[i].Name == Name) 
        {
            return allShowJieGou[i];
        }
    }
    Debug.LogError(Name);
    return null;
}

public List<string> GetListShowJieGouName()
{
    List<string> res = new List<string>();
    for (int i = 0; i < allShowJieGou.Count; i++)
    {
        if (!res.Contains(allShowJieGou[i].Name)) 
        {
            res.Add(allShowJieGou[i].Name);
        }
    }
    return res;
}



public ShowJieGou GetShowJieGouShow(string Show)
{
    for (int i = 0; i < allShowJieGou.Count; i++)
    {
        if (allShowJieGou[i].Show == Show) 
        {
            return allShowJieGou[i];
        }
    }
    Debug.LogError(Show);
    return null;
}

public List<string> GetListShowJieGouShow()
{
    List<string> res = new List<string>();
    for (int i = 0; i < allShowJieGou.Count; i++)
    {
        if (!res.Contains(allShowJieGou[i].Show)) 
        {
            res.Add(allShowJieGou[i].Show);
        }
    }
    return res;
}




    }
}