using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Reflection;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using TSA_V.Common;
using TSA_V.DeviceLibrary;

namespace TSA_V.LoadCSVLibrary
{
    public class CSVReaderBomManager : CSVReaderBase
    {

        /// <summary>
        /// 所有的位置集合，key=位置
        /// </summary>
        public static Dictionary<string, Dictionary<string, ComponetInfo>> allComMap = new Dictionary<string, Dictionary<string, ComponetInfo>>();

        public static List<ComponetInfo> GetComList(string bomName)
        {
            if (allComMap.ContainsKey(bomName))
            {
                return new List<ComponetInfo>(allComMap[bomName].Values);
            }
            else
            {
                string fileName = getFilePath(bomName);
                if (File.Exists(fileName))
                {
                    List<ComponetInfo> list = ReadFile(fileName);

                    Dictionary<string, ComponetInfo> map = new Dictionary<string, ComponetInfo>();
                    foreach (ComponetInfo com in list)
                    {
                        map.Add(com.PartNum, com);
                    }
                    allComMap.Add(bomName, map);
                    return list;
                }
            }
            return null;
        }

        public static void LoadAllCom()
        {
           
            allComMap = new Dictionary<string, Dictionary<string, ComponetInfo>>();
            string appPath = Application.StartupPath;
            string filePath = appPath + ConfigAppSettings.GetValue(Setting_Init.ComPath_Config);
            if (!Directory.Exists(filePath))
            {
                Directory.CreateDirectory(filePath);
            }
            //加载所有数据
            string[] fileList = Directory.GetFiles(filePath);
            if (fileList.Length > 0)
            {
                foreach (string fileName in fileList)
                {
                    try { 
                    string extension = Path.GetExtension(fileName); //-->.xml
                        if (extension.ToLower().Equals(".csv"))
                        {
                            string bomName = Path.GetFileNameWithoutExtension(fileName); //-->BenXHCMS 
                            List<ComponetInfo> list = ReadFile(fileName);
                            Dictionary<string, ComponetInfo> map = new Dictionary<string, ComponetInfo>();
                            foreach (ComponetInfo com in list)
                            {
                                if (com == null||com.PartNum==null||com.PositionNum==null)
                                {
                                    continue;
                                }
                                if (map.ContainsKey(com.PartNum))
                                {
                                    LogUtil.error("元器件库【" + bomName + "】【" + com.PartNum + "】重复");
                                }
                                else
                                {
                                    map.Add(com.PartNum, com);
                                }
                            }
                            if (map.Count > 0)
                            {
                                allComMap.Add(bomName, map);
                            }
                        }
                    }catch(Exception ex)
                    {
                        LogUtil.error("加载出错："+ex.ToString());
                    }
                }
            }
        }

        public static string getFilePath(string bomName)
        {
            string appPath = Application.StartupPath;
            string filePath = appPath + ConfigAppSettings.GetValue(Setting_Init.ComPath_Config);
            return filePath + bomName + ".csv";
        }
        /// <summary>
        /// 添加一个csv文件的数据到位置集合中
        /// </summary>
        /// <param name="filePath">cvs文件路径+文件名</param>  
        /// <returns></returns>
        public static List<ComponetInfo> ReadFile(string filePath)
        {
            System.Type type = typeof(ComponetInfo);
            List<ComponetInfo> comList = new List<ComponetInfo>();
            Dictionary<string, string> proTitleMap = getProAttributeMap(typeof(ComponetInfo));
         
            List<string> cvsTitleList = new List<string>(proTitleMap.Values);
            List<string> propertyList = new List<string>(proTitleMap.Keys);

            string[] lines = ReadCSVFile(filePath);
            int index = 0;
            Dictionary<string, int> titleIndex = new Dictionary<string, int>();
            foreach (var line in lines)
            { 
                var array = line.Split(Spilt_Char);
                if (index == 0)
                {
                    titleIndex = GetTitleIndex(line, cvsTitleList);
                }
                else
                {
                    try
                    {
                        if (array.Length >= titleIndex.Count)
                        {
                            if (array.Length > 0 && array[0].Equals(""))
                            {
                                continue;
                            }
                            var bllIns = type.Assembly.CreateInstance(type.FullName);
                            //取得属性集合
                            PropertyInfo[] props = type.GetProperties();

                            int listIndex = 0;
                         
                            foreach (string key in cvsTitleList)
                            {
                                if (titleIndex.ContainsKey(key))
                                {
                                    int titIndex = titleIndex[key];
                                    string value = array[titIndex];
                                    string proName = propertyList[listIndex];
                                    PropertyInfo prop = props.First(c => c.Name == proName);//获取同名属性
                                    if (prop != null)
                                    {
                                        string typeName = prop.PropertyType.Name;
                                        //判断值是否为空
                                        if (value.Equals("") && (typeName.ToUpper().Equals("INT32") || typeName.ToUpper().Equals("DOUBLE")))
                                        {
                                            value = "0";
                                        } 
                                        //如果属性存在
                                        prop.SetValue(bllIns, Convert.ChangeType(value, prop.PropertyType), null);//赋值****在这里需要考虑类型问题 
                                    }
                                }
                                listIndex++;
                            }
                            comList.Add((ComponetInfo)bllIns);
                        }
                        else
                        {
                            LOGGER.Error("读取csv，index=" + index + ",数据格式不匹配！，line=" + line);
                        }
                    }
                    catch (Exception ex)
                    {
                        LOGGER.Debug("CSV 读取行【" + line + "】行转换失败");
                    }
                }
                index++;
            }
            return comList;
        }

        public static bool SaveComponet(string bomName, ComponetInfo com)
        {
            if (!allComMap.ContainsKey(bomName))
            {
                return false;
            }
            Dictionary<string, ComponetInfo> oldMap = allComMap[bomName];
            System.Type type = typeof(ComponetInfo);

            Dictionary<string, string> proTitleMap = getProAttributeMap(typeof(ComponetInfo));
        
            List<string> cvsTitleList = new List<string>(proTitleMap.Values);
            List<string> propertyList = new List<string>(proTitleMap.Keys);
            int IdIndex = propertyList.IndexOf("PartNum");
            int csvIndex = -1;
            string filePath = getFilePath(bomName);

            List<ComponetInfo> oldList = GetComList(bomName);

            int idIndex = propertyList.IndexOf("PartNum");
            string[] lines = ReadCSVFile(filePath);
            int index = 0;
            Dictionary<string, int> titleIndex = new Dictionary<string, int>();

            foreach (var line in lines)
            {
                var array = line.Split(',');
                if (index == 0)
                {
                    titleIndex = GetTitleIndex(line, cvsTitleList);
                }
                else
                {
                    if (array.Length == titleIndex.Count)
                    {
                        if (csvIndex < 0)
                        {
                            csvIndex = titleIndex[cvsTitleList[idIndex]];
                        }
                        string value = array[csvIndex];
                        if (value.Equals(com.PartNum))
                        {
                            //更新缓存
                            oldMap.Remove(com.PartNum);
                            oldMap.Add(com.PartNum, com);
                            string newValue = ObjToString(com, titleIndex, proTitleMap);
                            lines[index] = newValue;
                            return WriteCSVFile(filePath, lines);
                        }
                    }
                }
                index++;
            }
            return true;
        }

        public static bool SaveComponet(string bomName, List<ComponetInfo> positionList)
        {
            string filePath = getFilePath(bomName);
            System.Type type = typeof(ComponetInfo);

            Dictionary<string, string> proTitleMap = getProAttributeMap(typeof(ComponetInfo));
          
            List<string> cvsTitleList = new List<string>(proTitleMap.Values);
            List<string> propertyList = new List<string>(proTitleMap.Keys);
            Dictionary<string, int> titleIndex = new Dictionary<string, int>();
            string[] readLines = ReadCSVFile(filePath);
            string[] lines = new string[positionList.Count + 1];
            foreach (var line in readLines)
            {
                lines[0] = line;
                var array = line.Split(',');
                titleIndex = GetTitleIndex(line, cvsTitleList);
                break;
            }
            int index = 1;

            foreach (ComponetInfo position in positionList)
            {
                string newValue = ObjToString(position, titleIndex, proTitleMap);
                lines[index] = newValue;
                index++;
            }

            return WriteCSVFile(filePath, lines);
        }
        private static string ObjToString(ComponetInfo position, Dictionary<string, int> titleIndex, Dictionary<string, string> proTitleMap)
        {
            //取得属性集合
            PropertyInfo[] props = typeof(ComponetInfo).GetProperties();
            List<string> cvsTitleList = new List<string>(proTitleMap.Values);
            List<string> propertyList = new List<string>(proTitleMap.Keys);
            String[] array = new String[titleIndex.Count];
            foreach (string proName in proTitleMap.Keys)
            {
                PropertyInfo prop = props.First(c => c.Name == proName);//获取同名属性
                if (prop != null)
                {//如果属性存在
                    string value = prop.GetValue(position,null).ToString();
                    int index = titleIndex[proTitleMap[proName]];
                    array[index] = value;
                }
            }

            string newStr = "";
            foreach (string str in array)
            {
                if (newStr.Equals(""))
                {
                    newStr = str;
                }
                else
                {
                    newStr = newStr + Spilt_Char + str;
                }
            }
            return newStr;
        }

        /// <summary>
        /// 获取此文件第一行的数据
        /// </summary> 
        private static string GetHeaderString(List<string> cvsValues)
        { 
            string newStr = "";
            foreach (string str in cvsValues)
            {
                if (newStr.Equals(""))
                {
                    newStr = str;
                }
                else
                {
                    newStr = newStr + Spilt_Char + str;
                }
            }
            return newStr;
        }

        /// <summary>
        /// 增加一个元器件库
        /// </summary> 
        public static bool AddBomList(string bomName, List<ComponetInfo> comList)
        {
            try
            {
                RemoveBom(bomName);
                string filePath = getFilePath(bomName);
                if (File.Exists(filePath))
                {
                    //删除原来的文件
                    File.Delete(filePath);
                    LogUtil.error("新增元器件库：" + bomName + ",发现文件【" + filePath + "】已存在，删除原来的文件");
                }
                System.Type type = typeof(ComponetInfo);

                Dictionary<string, string> proTitleMap = getProAttributeMap(typeof(ComponetInfo));

                List<string> cvsTitleList = new List<string>(proTitleMap.Values);
                List<string> propertyList = new List<string>(proTitleMap.Keys);

                Dictionary<string, int> titleIndexMap = new Dictionary<string, int>();
                int titleIndex=0;
                foreach (string str in cvsTitleList)
                {
                    titleIndexMap.Add(str, titleIndex);
                    titleIndex++;
                }
                string[] lines = new string[comList.Count + 1];
                lines[0] = GetHeaderString(cvsTitleList);
                int index = 1;
                Dictionary<string, ComponetInfo> map = new Dictionary<string, ComponetInfo>();
                foreach (ComponetInfo com in comList)
                {
                    map.Add(com.PartNum,com);
                    lines[index] = ObjToString(com, titleIndexMap, proTitleMap);
                    index++;
                }
                bool result =WriteCSVFile(filePath, lines);
                if (result)
                {
                    allComMap.Add(bomName, map);
                    return true;
                }
                else
                {
                    return false;
                }
            }
            catch (Exception ex)
            {
                LogUtil.error("增加元器件库出错 ：【"+bomName+"】"+ex.ToString());
                return false;
            } 
        }

        public static void RemoveBom(string bomName)
        {

            string fileName = getFilePath(bomName);
            if (allComMap.ContainsKey(bomName))
            {
                allComMap.Remove(bomName);
            }
            if (File.Exists(fileName))
            { 
                File.Delete(fileName);
            }
        }

        public static bool  RemoveCom(string bomName, ComponetInfo obj)
        {
            string fileName = getFilePath(bomName);
            File.Delete(bomName);
            if (allComMap.ContainsKey(bomName))
            {
                Dictionary<string, ComponetInfo> map = allComMap[bomName];
                map.Remove(obj.PartNum);
                List<ComponetInfo> newList = new List<ComponetInfo>(map.Values);
                AddBomList(bomName, newList);
                return true;
            }

            return false;
        }

        public static ComponetInfo GetCom(string bomName, string partNum)
        {
            if (allComMap.ContainsKey(bomName))
            {
                Dictionary<string, ComponetInfo> map = allComMap[bomName];
                if (map.ContainsKey(partNum))
                {
                    return map[partNum];
                }
            } return null;
        }

        /// <summary>
        /// 更新元器件数量
        /// </summary> 
        public static bool UpdateCount(string bomName, string comName, int count)
        {
            List<ComponetInfo> comList = CSVReaderBomManager.GetComList(bomName);
            if (comList == null)
            {
                return false;
            }
            List<ComponetInfo> newList = new List<ComponetInfo>();
            foreach (ComponetInfo obj in comList)
            {
                if (obj.ComponentName.Equals(comName))
                {
                    obj.ComCount = count;
                }
                newList.Add(obj);
            }

            CSVReaderBomManager.SaveComponet(bomName, newList);
            return true;
        }
        /// <summary>
        /// 减去此电路板使用的元器件数量
        /// </summary>
        /// <param name="currBoard"></param>
        public static bool DelUseCount(DeviceLibrary.BoardInfo currBoard,int maxIndex)
        {
            try
            {
                string bomName = currBoard.bomName;
                List<ComponetInfo> comList = CSVReaderBomManager.GetComList(bomName);
                if (comList == null)
                {
                    return false;
                }
                Dictionary<string, int> useCount = new Dictionary<string, int>();
                int index = 0;
                List<SMTPointInfo> list = currBoard.GetSmtList();
                foreach (SMTPointInfo smt in list)
                {
                    if (index > maxIndex)
                    {
                        break;
                    }
                    ComponetInfo com = CSVReaderBomManager.GetCom(BoardManager.CurrBoard.bomName, smt.PartNum);
                    if (useCount.ContainsKey(com.ComponentName))
                    {
                        useCount[com.ComponentName]++;
                    }
                    else
                    {
                        useCount.Add(com.ComponentName, 1);
                    }
                    index++;
                }
                List<ComponetInfo> newList = new List<ComponetInfo>();
                foreach (ComponetInfo obj in comList)
                {
                    if (useCount.ContainsKey(obj.ComponentName))
                    {
                        obj.ComCount = obj.ComCount - useCount[obj.ComponentName];
                        if (obj.ComCount < 0)
                        {
                            obj.ComCount = 0;
                        }
                    }
                    newList.Add(obj);
                }

                CSVReaderBomManager.SaveComponet(bomName, newList);
            }catch(Exception ex)
            {

            }
            return true;
        }
    }
}