CSV文件处理

脚本一CreateCSV用于创建CSV文件，：

using UnityEngine;using System.Collections;using System.Collections.Generic;using System.Text;public class CreatCsv {    private string csvName;    public string CsvName    {        get { return csvName; }        set { csvName = value; }    }    private string csvContent;    public string CsvContent    {        get { return csvContent; }        set { csvContent = value; }    }    private string strContent;    private int nRowCount;    private int nColCount;    public CreatCsv()    {    }    public CreatCsv(CSVClassFiles placeName)    {        this.csvName = placeName.configName;        this.csvContent = placeName.content;        CSVManager.Init.AddCsv(this.csvName, this);    }    public virtual void Init()    {    }    public virtual void Clear()    {    }    public bool ChackCSV()    {        strContent = CsvContent;        string[] strTitle = strContent.Split('\n');        string[] strTemp = strTitle[0].Split(',');        for(int i = 0; i < strTemp.Length ; i++)        {           for(int j = i+1 ; j < strTemp.Length ; j++)           {                  if(strTemp[i] == strTemp[j])                {                    Debug.LogWarning(csvName + "表头有重复");                    return false;                }           }        }        nColCount = strTemp.Length;        return true;    }    public bool AnalyzeCSV()    {        string[] strTitle = strContent.Split('\n');        for (int i = 0; i < strTitle.Length - 1; i++)        {            List<string> list = new List<string>();            string[] strTemp = strTitle[i].Split(',');            for (int j = 0; j < strTemp.Length; j++)            {                string str = strTemp[j];                if (str.Contains("\r"))                {                    str = str.Replace("\r", "");                }                list.Add(str);            }            if(i >= 3)            {                dic[i-3] = list;            }            csvList.Add(list);        }        return true;    }    public int GetIntData(int nRow , int nClo)    {        if ((nRow + 1) > csvList.Count || (nClo + 1) > csvList[nRow].Count)        {            return 0;        }        int value;        if (int.TryParse(csvList[nRow][nClo] , out value))        {            return value;        }        return 0;    }    public int GetRowCount()    {        return csvList.Count;    }    public int GetColCount()    {        if (GetRowCount() > 0)        {            return csvList[0].Count;        }        return 0;    }    public string GetStringData(int nRow, int nClo)    {        if ((nRow + 1) > csvList.Count || (nClo + 1) > csvList[nRow].Count)        {            return null;        }        return csvList[nRow][nClo];    }    public string GetTitle(int nClo)    {        return GetStringData(0, nClo);    }    public List<string> GetList(int nRow)    {        if (dic.ContainsKey(nRow))        {            return dic[nRow];        }        return null;    }    public List<List<string>> csvList = new List<List<string>>();    public Dictionary<int, List<string>> dic = new Dictionary<int, List<string>>();}

脚本二不必介绍：

using UnityEngine;using System.Collections;public class CSVClassFiles : ScriptableObject{    public string configName;    public string content;}

脚本三CsvManager用于管理csv文件:

using UnityEngine;using System.Collections;using System.Collections.Generic;using System.Linq;using System;using DAS;public class CSVManager : Singleton{    public delegate void CreatCSVCallBack(int csvCount);    public delegate void CreatCSVDone();    public CreatCSVDone CreatCSVDoneCallBack;    public static CSVManager Init;    private Dictionary<string, CreatCsv> dic = new Dictionary<string, CreatCsv>();    private int csvCount = 0;    public CSVManager():base(false)    {    }    public override void SingletonUpdate(float fTime, float fDtime)    {    }    public void RegisterCreatCSVDone(CreatCSVDone callback)    {        CreatCSVDoneCallBack += callback;    }    public void RemoveCreatCSVDone(CreatCSVDone callback)    {        CreatCSVDoneCallBack -= callback;    }    public void AddCsv(string str , CreatCsv csv)    {        dic[str] = csv;    }    public T GetCSV<T>(string str)    {        if (dic.ContainsKey(str))        {            object obj = (object)dic[str];            return (T)obj;        }        return default(T);    }    public void LoadCSV()    {        LoadManager.AddDownRequest(ResourceType.Type_CSV, GlobleConfig.strFlieSer + GlobleConfig.allCSVPath, CreadCSV, LoadProCallBack, GlobleConfig.allCSVPath);        LoadManager.AddDownRequest(ResourceType.Type_CSV, GlobleConfig.strFlieSer + GlobleConfig.allScenesInfoPath, CreadCSV, LoadProCallBack, GlobleConfig.allScenesInfoPath);    }    private void LoadProCallBack(float value, object customParam)    {        Debug.LogWarning("LoadPro = " + value + " url = " + (string)customParam);    }    private void CreadCSV(AssetBundle bundle, object customParam)    {        if (bundle != null)        {            UnityEngine.Object[] objs = bundle.LoadAll(typeof(CSVClassFiles));            for (int num = 0; num < objs.Length; num++)            {                UnityEngine.Object obj = objs[num];                if (obj == null)                {                    continue;                }                CSVClassFiles csv = obj as CSVClassFiles;                if (csv.configName.Contains("cfg_Scene_"))                {                    SceneMgr sceneMgr = (SceneMgr)SingletonMgr.Inst.GetSingleton(SingletonDefine.s_SceneMgr);                    ScenesCSV scenesCSV = new ScenesCSV(csv);                    sceneMgr.AddSceneCSV(csv.configName, scenesCSV);                }                if (csv.configName == GlobleConfig.csvEquipStone)                {                    new EquipStoneCSV(csv);                }                else if (csv.configName == GlobleConfig.csvPlayerConfig1)                {                }                else if (csv.configName == GlobleConfig.csvConfig)                {                }                else if (csv.configName == GlobleConfig.csvOpenFun)                {                    new OpenFunCSV(csv);                }                else if (csv.configName == GlobleConfig.csvDeviceInfo)                {                    new DeviceInfoCSV(csv);                }             }            bundle.Unload(false);            if (customParam != null)            {                //Debug.LogWarning("customParam = " + customParam);                if (customParam == "Config/AllCSVInfo.unity3d")                {                }            }            csvCount++;            if (csvCount == 2)            {                CreatCSVDoneCallBack();            }        }    }}

脚本4下载：

using UnityEngine;using System.Collections;using System;using System.Collections.Generic;using DAS;public class LoadManager : Singleton{    public static LoadManager Init = null;    public delegate void DownFinishDelegate(AssetBundle wwwObj, object customParam);    public delegate void DownLoadProgressDelegate(float value, object customParam);    private static Dictionary<string, AssetBundle> dic = new Dictionary<string, AssetBundle>();    private static Dictionary<string, WWWRequest> m_WWWMap = new Dictionary<string, WWWRequest>();    public LoadManager():base(false)    {    }    public class WWWRequest    {        public ResourceType type;        public string requestURl;        public DownFinishDelegate calbackFun;        public DownLoadProgressDelegate LoadProCallBack;        public WWW wwwObject = null;        public bool bHasDeal = false;        public int loadSize;        public List<object> customParams = new List<object>();         public WWWRequest() { }        public WWWRequest(ResourceType resType ,string url, DownFinishDelegate cbFun,DownLoadProgressDelegate LoadPro, object customParam = null)        {            type = resType;            requestURl = url;            calbackFun = new DownFinishDelegate(cbFun);            LoadProCallBack = new DownLoadProgressDelegate(LoadPro);            try            {                wwwObject = new WWW(url);            }            catch(Exception ex)            {                Debug.LogWarning(ex.Message);            }            customParams.Add(customParam);        }    }    //WWW Request List    public static void AddDownRequest(ResourceType type , string url, DownFinishDelegate callBackFun, DownLoadProgressDelegate LoadPro = null, object customParam = null)    {        if (url != "")        {            //增加新的资源下载需求            if (!m_WWWMap.ContainsKey(url))            {                m_WWWMap.Add(url, new WWWRequest(type ,url, callBackFun, LoadPro, customParam));            }            else            {                //已经提交相同请求，但是没有下载完成                if (!m_WWWMap[url].wwwObject.isDone)                {                    m_WWWMap[url].calbackFun += callBackFun;                    m_WWWMap[url].customParams.Add(customParam);                }                //已下载资源，直接调用回调函数                else                {                    callBackFun(m_WWWMap[url].wwwObject.assetBundle, customParam);                }            }        }    }    public static void UnloadAllRes()    {        foreach (KeyValuePair<string, WWWRequest> wwwPair in m_WWWMap)        {            wwwPair.Value.wwwObject.assetBundle.Unload(true);        }        m_WWWMap.Clear();        Resources.UnloadUnusedAssets();        System.GC.Collect();    }    public static void UnloadSingleRes(string resName)    {        foreach (KeyValuePair<string, WWWRequest> wwwPair in m_WWWMap)        {            if (wwwPair.Key.Contains(resName))            {                wwwPair.Value.wwwObject.assetBundle.Unload(true);                m_WWWMap.Remove(resName);                Resources.UnloadUnusedAssets();                break;            }        }    }    // Update is called once per frame    public override void SingletonUpdate(float fTime, float fDtime)    {        foreach (KeyValuePair<string, WWWRequest> wwwPair in m_WWWMap)        {            WWWRequest wwwReq = wwwPair.Value;            //try            //{            //    if (wwwReq.wwwObject == null || wwwReq.wwwObject.assetBundle == null)            //    {            //        continue;            //    }            //}            //catch (Exception ex)            //{            //    Debug.LogWarning(ex.Message);            //}            //如果尚未调用回调，并且下载完成，则调用            if ((!wwwPair.Value.bHasDeal && wwwReq.wwwObject.isDone && wwwReq.wwwObject.assetBundle != null))            {                for (int i = 0; i < wwwReq.calbackFun.GetInvocationList().GetLength(0); i++)                {                    ((DownFinishDelegate)wwwReq.calbackFun.GetInvocationList()[i]).Invoke(wwwReq.wwwObject.assetBundle, wwwReq.customParams[i]);                    wwwReq.wwwObject.assetBundle.Unload(false);                    //wwwReq.wwwObject.Dispose();                }                wwwPair.Value.bHasDeal = true;            }            //if (!wwwReq.wwwObject.isDone)            //{            //    for (int i = 0; i < wwwReq.calbackFun.GetInvocationList().GetLength(0); i++)            //    {            //        ((DownLoadProgressDelegate)wwwReq.LoadProCallBack.GetInvocationList()[i]).Invoke(wwwReq.wwwObject.progress, wwwReq.requestURl);            //    }            //}        }    }}