using TSA_V.Common;
using TSA_V.DeviceLibrary;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.IO;
using TSA_V.LoadCSVLibrary;
using TSA_V.DeviceLibrary.manager;

namespace TSA_V
{
    public partial class FrmComponentList : FrmBase
    {
        public static FrmComponentList instance = new FrmComponentList();
        private FrmComponentList()
        {
            InitializeComponent();
        }

        private void FrmPointType_Load(object sender, EventArgs e)
        {
            // SetSkin(this);
            loadPositionList();
            LoadComList();
            LanguageProcess();
            LanguagePro();
        }
        private void LanguagePro()
        {
            this.Column_partNumber.HeaderText = ResourceCulture.GetString(ResourceCulture.Col_Num, "位号");
            this.Column_PN.HeaderText = ResourceCulture.GetString(ResourceCulture.Col_Name, "物料编码");
            this.Column_Count.HeaderText = ResourceCulture.GetString(ResourceCulture.Col_Count, "数量");
            this.Column_Position.HeaderText = ResourceCulture.GetString(ResourceCulture.Col_Position, "料盘位置");
            this.Column_Notes.HeaderText = ResourceCulture.GetString(ResourceCulture.Col_Notes, "注意事项");
            this.Column_description.HeaderText = ResourceCulture.GetString(ResourceCulture.Col_Del, "描述");
            this.Column_Del.HeaderText = ResourceCulture.GetString(ResourceCulture.ItemText_Delete, "删除");
            this.Column_Del.Text = ResourceCulture.GetString(ResourceCulture.ItemText_Delete, "删除");
            this.Column_Del.ToolTipText = ResourceCulture.GetString(ResourceCulture.ItemText_Delete, "删除");

        }
        private List<TSAVPosition> allPosition = new List<TSAVPosition>(CSVPositionReader<TSAVPosition>.allPositionMap.Values);
        private void loadPositionList()
        {
            cmbPositionNumList.DataSource = null;
            cmbPositionNumList.DataSource = allPosition;
            cmbPositionNumList.DisplayMember = "PositionNum";
            cmbPositionNumList.ValueMember = "PositionNum";
        }
        internal void LoadComList()
        {
            List<string> keyList = new List<string>(LoadCSVLibrary.CSVBomManager.allComMap.Keys);
            this.cmbList.Items.Clear();
            foreach (string key in keyList)
            {
                this.cmbList.Items.Add(key);
            }

            if (keyList.Count > 0)
            {
                this.cmbList.SelectedIndex = 0;
            }
        }

        private void cmbList_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (cmbList.SelectedIndex >= 0)
            {
                //this.dgvList.Rows.Clear();
                string key = cmbList.Text;
                List<ComponetInfo> list = CSVBomManager.GetComList(key);
                //foreach (ComponetInfo com in list)
                //{
                //    if (com != null)
                //    {
                //        dgvList.Rows.Add(SetRowInfo(null, com));
                //    }
                //}                
                UpdateGridList(list);
            }
        }

        private void UpdateGridList(List<ComponetInfo> list)
        {
            this.dgvList.Rows.Clear();
            foreach (ComponetInfo com in list)
            {
                if (com != null)
                {
                    dgvList.Rows.Add(SetRowInfo(null, com));
                }
            }

        }
        private DataGridViewRow SetRowInfo(DataGridViewRow view, ComponetInfo com)
        {
            if (view == null)
            {
                view = new DataGridViewRow();
                view.CreateCells(dgvList);
            }
            view.Cells[Column_PN.Index].Value = com.PN.ToString();
            view.Cells[this.Column_X.Index].Value = com.PositionX.ToString();
            view.Cells[Column_Y.Index].Value = com.PositionY.ToString();
            view.Cells[this.Column_description.Index].Value = com.ComponentDes.ToString();
            view.Cells[this.Column_Notes.Index].Value = com.Notes.ToString();
            view.Cells[this.Column_partNumber.Index].Value = com.TagNo.ToString();
            view.Cells[this.Column_Position.Index].Value = com.PositionNum.ToString();
            view.Cells[this.Column_Count.Index].Value = com.ComCount.ToString();
            view.Cells[this.Column_ID.Index].Value = com.Id.ToString();
            return view;
        }


        private void btnNew_Click(object sender, EventArgs e)
        {
            FrmAddCom frm = new FrmAddCom();
            this.Visible = false;
            frm.ShowDialog();
            LoadComList();
            this.Visible = true;
        }


        private void btnSave_Click(object sender, EventArgs e)
        {
            if (IsNew)
            {
                AddCom();
            }
            else
            {
                if (dgvList.SelectedRows != null && dgvList.SelectedRows.Count > 0)
                {
                    int rowIndex = dgvList.SelectedRows[0].Index;

                    DataGridViewRow row = dgvList.Rows[rowIndex];

                    ComponetInfo obj = getRowPointInfo(row);
                    string oldPosition = obj.PositionNum;
                    string oldTagNo = obj.TagNo;

                    if (obj == null)
                    {
                        MessageBox.Show(ResourceCulture.GetString(ResourceCulture.SelectC, "请选择元器件！"));
                        return;
                    }
                    if (cmbPositionNumList.SelectedIndex < 0)
                    {
                        MessageBox.Show(ResourceCulture.GetString(ResourceCulture.SelectCPosition, "请选择元器件位置！"));
                        cmbPositionNumList.Focus();
                        return;
                    }
                    TSAVPosition position = (TSAVPosition)cmbPositionNumList.SelectedItem;

                    obj.PN = FormUtil.getValue(txtName);
                    obj.ComponentDes = FormUtil.getValue(txtDes);
                    obj.ComCount = FormUtil.GetIntValue(txtCount).ToString();
                    obj.Notes = FormUtil.getValue(txtNotes);
                    obj.TagNo = FormUtil.getValue(txtPartNum);
                    obj.Id = FormUtil.GetIntValue(txtId);
                    obj.PositionNum = position.PositionNum;


                    if (obj.PN.Equals(""))
                    {
                        MessageBox.Show(ResourceCulture.GetString(ResourceCulture.WriteComName, "请输入元器件名称！"));
                        txtName.Focus();
                        return;
                    }

                    if (int.Parse(obj.ComCount) <= 0)
                    {
                        MessageBox.Show(ResourceCulture.GetString(ResourceCulture.WriteComNum, "请输入元器件数量！"));
                        txtCount.Focus();
                        return;
                    }
                    if (obj.PositionNum.Equals(oldPosition).Equals(false) && (!String.IsNullOrEmpty(obj.TagNo)))
                    {
                        List<ComponetInfo> list = CSVBomManager.GetComList(cmbList.Text);
                        List<ComponetInfo> objs = (from m in list where m.Id.Equals(obj.Id).Equals(false) && m.PN.Equals(obj.PN) && m.PositionNum.Equals(obj.PositionNum) select m).ToList();
                        if (objs.Count > 0)
                        {
                            MessageBox.Show(ResourceCulture.GetString(ResourceCulture.ComExists, "元器件已存在"));
                        }
                    }
                    if (obj.TagNo.Equals(oldTagNo).Equals(false) && (!String.IsNullOrEmpty(obj.TagNo)))
                    {
                        List<ComponetInfo> list = CSVBomManager.GetComList(cmbList.Text);
                        List<ComponetInfo> objs = (from m in list where (!String.IsNullOrEmpty(m.TagNo)) && m.TagNo.Equals(obj.TagNo) select m).ToList();
                        if (objs.Count > 0)
                        {
                            MessageBox.Show(ResourceCulture.GetString(ResourceCulture.PartNAExist, "元器件编号[{0}]已存在", obj.TagNo));
                            txtPartNum.Focus();
                            return;
                        }
                    }

                    bool result = CSVBomManager.UpdateComponet(cmbList.Text, obj);
                    if (result)
                    {
                        //ComponentManager.Update(obj);
                        SetRowInfo(dgvList.Rows[rowIndex], obj);
                        MessageBox.Show(ResourceCulture.GetString(ResourceCulture.ComSaveOk, "元器件【{0}】保存成功！", obj.TagNo + "-" + obj.PN));
                        groupInfo.Text = ResourceCulture.GetString(ResourceCulture.ComInfo, "元器件【{0}】的基本信息", obj.TagNo + "-" + obj.PN);
                    }
                }
            }
        }

        private void AddCom()
        {
            ComponetInfo obj = new ComponetInfo();

            if (cmbPositionNumList.SelectedIndex < 0)
            {
                MessageBox.Show(ResourceCulture.GetString(ResourceCulture.SelectCPosition, "请选择元器件位置！"));
                cmbPositionNumList.Focus();
                return;
            }
            TSAVPosition position = (TSAVPosition)cmbPositionNumList.SelectedItem;
            obj.TagNo = FormUtil.getValue(txtPartNum);
            obj.PN = FormUtil.getValue(txtName);
            obj.ComponentDes = FormUtil.getValue(txtDes);
            obj.ComCount = FormUtil.GetIntValue(txtCount).ToString();
            obj.Notes = FormUtil.getValue(txtNotes);
            obj.PositionNum = position.PositionNum;
            //if (obj.TagNo.Equals(""))
            //{
            //    MessageBox.Show(ResourceCulture.GetString(ResourceCulture.WritePartName, "请输入元器件编号！"));
            //    txtPartNum.Focus();
            //    return;
            //}
            //判断编号是否存在
            List<ComponetInfo> allList = CSVBomManager.GetComList(cmbList.Text);
            List<ComponetInfo> objs = (from m in allList where (!String.IsNullOrEmpty(m.TagNo)) && m.TagNo.Equals(obj.TagNo) select m).ToList();
            if (objs.Count > 0)
            {
                MessageBox.Show(ResourceCulture.GetString(ResourceCulture.PartNAExist, "元器件编号[{0}]已存在", obj.TagNo));
                txtPartNum.Focus();
                return;
            }
            objs = (from m in allList where m.PN.Equals(obj.PN) && m.PositionNum.Equals(m.PositionNum) select m).ToList();
            if (objs.Count > 0)
            {
                MessageBox.Show(ResourceCulture.GetString(ResourceCulture.PartNAExist, "元器件编号[{0}]已存在", obj.PN + "-" + obj.PositionNum));
                txtPartNum.Focus();
                return;
            }
            if (obj.PN.Equals(""))
            {
                MessageBox.Show(ResourceCulture.GetString(ResourceCulture.WriteComName, "请输入元器件名称！"));
                txtName.Focus();
                return;
            }

            if (int.Parse(obj.ComCount) <= 0)
            {
                MessageBox.Show(ResourceCulture.GetString(ResourceCulture.WriteComNum, "请输入元器件数量！"));
                txtCount.Focus();
                return;
            }
            if (String.IsNullOrEmpty(obj.TagNo))
            {
                List<ComponetInfo> lists = CSVBomManager.GetComList(cmbList.Text);
                List<ComponetInfo> hasList = (from m in lists where m.Id.Equals(obj.Id).Equals(false) && m.PN.Equals(obj.PN) && m.PositionNum.Equals(obj.PositionNum) select m).ToList();
                if (objs.Count > 0)
                {
                    MessageBox.Show(ResourceCulture.GetString(ResourceCulture.ComExists, "元器件已存在"));
                }
            }


            List<ComponetInfo> list = CSVBomManager.AddCom(cmbList.Text, obj);
            if (list == null)
            {
                MessageBox.Show(ResourceCulture.GetString(ResourceCulture.SaveError, "保存失败！"));
                return;
            }
            //ComponentManager.Update(obj); 
            //dgvList.Rows.Add(SetRowInfo(null, obj));
            UpdateGridList(list);
            dgvList.Rows[dgvList.Rows.Count - 1].Selected = true;

            btnNewCom.Visible = true;
            MessageBox.Show(ResourceCulture.GetString(ResourceCulture.ComSaveOk, "元器件【{0}】保存成功！", obj.TagNo + "-" + obj.PN));
            groupInfo.Text = ResourceCulture.GetString(ResourceCulture.ComInfo, "元器件【{0}】的基本信息", obj.TagNo + "-" + obj.PN);
        }

        private void btnDel_Click(object sender, EventArgs e)
        {
            if (dgvList.SelectedRows != null && dgvList.SelectedRows.Count > 0)
            {
                int rowIndex = dgvList.SelectedRows[0].Index;
                DeleteCom(rowIndex);
            }
        }

        private ComponetInfo getRowPointInfo(DataGridViewRow row)
        {
            ComponetInfo point = new ComponetInfo();
            try
            {
                if (row.Cells[Column_PN.Name].Value == null)
                {
                    return null;
                }
                point.TagNo = row.Cells[this.Column_partNumber.Name].Value.ToString();
                point.PN = row.Cells[this.Column_PN.Name].Value.ToString();
                point.PositionX = Convert.ToDouble(row.Cells[this.Column_X.Name].Value.ToString());
                point.PositionY = Convert.ToDouble(row.Cells[this.Column_Y.Name].Value.ToString());
                point.ComponentDes = row.Cells[this.Column_description.Name].Value.ToString();
                point.Notes = row.Cells[this.Column_Notes.Name].Value.ToString();
                point.PositionNum = row.Cells[this.Column_Position.Name].Value.ToString();
                point.ComCount = row.Cells[this.Column_Count.Name].Value.ToString();
                point.Id = Convert.ToInt32(row.Cells[this.Column_ID.Name].Value.ToString());

            }
            catch (Exception ex)
            {
                LogUtil.error("保存数据出错：" + ex.ToString());
                MessageBox.Show(ResourceCulture.GetString(ResourceCulture.CheckComNum, "请检查元器件数据是否正确！"));
                return null;
            }
            return point;
        }
        private bool IsNew = false;
        private void btnNewCom_Click(object sender, EventArgs e)
        {
            IsNew = true;
            txtPartNum.Text = "";
            txtName.Text = "";
            txtDes.Text = "";
            txtCount.Text = "";
            txtPartNum.Text = "";
            txtNotes.Text = "";
            txtPartNum.Enabled = true;
            this.cmbPositionNumList.SelectedIndex = 0;
            btnNewCom.Visible = false;
            groupInfo.Text = ResourceCulture.GetString(ResourceCulture.NewCom, "新增元器件");
        }
        private ComponetInfo selCom = null;
        private void showDetail(int rowIndex)
        {
            try
            {
                DataGridViewRow row = dgvList.Rows[rowIndex];
                ComponetInfo obj = getRowPointInfo(row);
                if (obj == null)
                {
                    MessageBox.Show(ResourceCulture.GetString(ResourceCulture.ChoiceCom, "请选择元器件！"));
                    return;
                }
                selCom = obj;
                IsNew = false;
                txtPartNum.Tag = obj;
                txtName.Text = obj.PN;
                txtDes.Text = obj.ComponentDes;
                txtCount.Text = obj.ComCount.ToString();
                txtPartNum.Text = obj.TagNo;
                txtNotes.Text = obj.Notes;
                if (txtPartNum.Text == "")
                {
                    txtPartNum.Enabled = true;
                }
                else
                {
                    txtPartNum.Enabled = false;
                }
                btnNewCom.Visible = true;
                txtId.Text = obj.Id.ToString();
                //txtPosition.Text = obj.PositionNum;

                int selPosIndex = -1;
                int index = -1;
                string[] posNum = CSVBomManager.GetPositionNum(obj.PositionNum);
                foreach (TSAVPosition p in allPosition)
                {
                    index++;
                    if (p.PositionNum.Equals(posNum[0]))
                    {
                        selPosIndex = index;
                        break;
                    }
                }
                if (selPosIndex >= 0 && this.cmbPositionNumList.Items.Count > 0)
                {
                    this.cmbPositionNumList.SelectedIndex = selPosIndex;
                }

                groupInfo.Text = ResourceCulture.GetString(ResourceCulture.ComInfo, "元器件【{ 0}】的基本信息", obj.TagNo + "  " + obj.PN);

            }
            catch (Exception ex)
            {
                LogUtil.error("出错：" + ex.ToString());
            }
        }
        private void DeleteCom(int rowIndex)
        {
            DataGridViewRow row = dgvList.Rows[rowIndex];
            ComponetInfo obj = getRowPointInfo(row);
            if (cmbList.SelectedIndex >= 0)
            {
                string bomName = this.cmbList.Text;
                if (!CSVBomManager.canRemoveCom(bomName, obj))
                {
                    MessageBox.Show(ResourceCulture.GetString(ResourceCulture.CanotDelCom, "元器件已使用，不能删除！"));
                    return;
                }


                if (MessageBox.Show(
                    ResourceCulture.GetString(ResourceCulture.SureDelCom, "确认要删除元器件【{0}】吗？", obj.TagNo + " " + obj.PN),
                    ResourceCulture.GetString(ResourceCulture.MsgTitle, "提示"),

                    MessageBoxButtons.OKCancel,
                    MessageBoxIcon.Question) != DialogResult.OK)
                {
                    return;
                }
                else
                {
                    List<ComponetInfo> newlist = CSVBomManager.RemoveCom(cmbList.Text, obj);
                    if (newlist == null)
                    {
                        MessageBox.Show(ResourceCulture.GetString(ResourceCulture.SaveError, "保存失败！"));
                        return;
                    }
                    //this.dgvList.Rows.RemoveAt(rowIndex);
                    UpdateGridList(newlist);
                    MessageBox.Show(ResourceCulture.GetString(ResourceCulture.DelComOk, "元器件【{0}】删除成功！", obj.TagNo + " " + obj.PN)
                        , ResourceCulture.GetString(ResourceCulture.MsgTitle, "提示"));
                }
            }
            else
            {
                MessageBox.Show(ResourceCulture.GetString(ResourceCulture.SelectC, "请先选择一个元器件库"));
            }
        }

        private void btnBack_Click(object sender, EventArgs e)
        {
            //this.Close();
            this.Visible = false;
            FrmMenu.frmMain.Visible = true;
        }

        private void dgvList_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            if (e.RowIndex != -1 && e.ColumnIndex >= 0)
            {
                string name = this.dgvList.Columns[e.ColumnIndex].Name;
                if (name.Equals(this.Column_Del.Name))
                {
                    DeleteCom(e.RowIndex);
                }
            }
        }

        private void dgvList_SelectionChanged(object sender, EventArgs e)
        {
            if (dgvList.SelectedRows != null && dgvList.SelectedRows.Count > 0)
            {
                int rowIndex = dgvList.SelectedRows[0].Index;
                showDetail(rowIndex);
            }
        }

        private void btnDownLoad_Click(object sender, EventArgs e)
        {
            SaveFileDialog sfd = new SaveFileDialog();
            sfd.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.DesktopDirectory);
            sfd.FileName = ResourceCulture.GetString("元器件库模板");
            sfd.Filter = @"csv|*.csv";
            DialogResult result = sfd.ShowDialog();

            if (result.Equals(DialogResult.OK))
            {
                string filePath = sfd.FileName;
                //if (Directory.Exists(filePath))
                {
                    string sourcePath = Application.StartupPath + ConfigAppSettings.GetValue(Setting_Init.Componet_Template);
                    if (File.Exists(filePath))
                    {
                        File.Delete(filePath);
                    }
                    //复制文件 
                    File.Copy(sourcePath, filePath);
                    MessageBox.Show(ResourceCulture.GetString(ResourceCulture.DemoSave, "模板已保存在：") + filePath);
                }
            }
        }

        private void BtnBeiLiao_Click(object sender, EventArgs e)
        {
            if (cmbList.SelectedIndex >= 0)
            {
                string key = cmbList.Text;
                List<ComponetInfo> list = CSVBomManager.GetComList(key);
                FrmPutCom frm = new FrmPutCom();
                if (frm.SetOperateInfo(key, list))
                {
                    this.Visible = false;
                    frm.ShowDialog();
                    this.Visible = true;
                    cmbList_SelectedIndexChanged(null, null);
                }
            }
            else
            {
                MessageBox.Show(ResourceCulture.GetString(ResourceCulture.ChoiceLibrary, "请先选择一个元器件库"));
            }
        }

        private void btnDel_Click_1(object sender, EventArgs e)
        {
            if (cmbList.SelectedIndex >= 0)
            {
                string bomName = this.cmbList.Text;

                //如果在程序中存在，不能删除
                foreach (BoardInfo board in BoardManager.boardList)
                {
                    if (board.bomName.Equals(bomName))
                    {
                        MessageBox.Show(ResourceCulture.GetString(ResourceCulture.CanotDelC, "元器件库【{0}】在程序【{1}】中使用，不能删除！", bomName, board.boardName));
                        return;
                    }
                }

                if (MessageBox.Show(ResourceCulture.GetString(ResourceCulture.SureDeleteC, "确认要删除元器件库【{0}】吗？", bomName),
                    ResourceCulture.GetString(ResourceCulture.MsgTitle, "提示"),

                    MessageBoxButtons.OKCancel,
                    MessageBoxIcon.Question) != DialogResult.OK)
                {
                    return;
                }
                else
                {
                    CSVBomManager.RemoveBom(bomName);
                    dgvList.Rows.Clear();
                    this.txtCount.Text = "";
                    this.txtDes.Text = "";
                    this.txtName.Text = "";
                    this.txtNotes.Text = "";
                    this.txtPartNum.Text = "";
                    LoadComList();
                }
            }
            else
            {
                MessageBox.Show(ResourceCulture.GetString(ResourceCulture.SelectC, "请先选择一个元器件库"));
            }
        }

        private void FrmComponentList_FormClosing(object sender, FormClosingEventArgs e)
        {
            this.Visible = false;
            FrmMenu.frmMain.Visible = true;
            e.Cancel = true;
        }

        private void FrmComponentList_Shown(object sender, EventArgs e)
        {

        }

        private void FrmComponentList_VisibleChanged(object sender, EventArgs e)
        {
            if (this.Visible)
            {
                LanguagePro();
            }
        }

        private void cmbPositionNumList_SelectedIndexChanged(object sender, EventArgs e)
        {
            string pNum = cmbPositionNumList.Text;
            if (pNum.Equals(""))
            {
                return;
            }
            TSAVPosition position = CSVPositionReader<TSAVPosition>.GetPositonByNum(pNum);
            if (position != null && position.PositionType.Equals(2))
            {
                LinkVisible(true );
            }
            else
            {
                LinkVisible(false); 
            }
        }
        private void LinkVisible(bool show)
        {

            linkLabel1.Visible = show;
            linkLabel2.Visible = show;
            linkCloseAll.Visible = show;
            linkOpenAll.Visible = show;
            linkUpdate.Visible = show;
        }
        private LabelInfo PreLabel = null;
        private void CloseLed(string pPnum)
        {
            if (PreLabel != null)
            {
                if ( pPnum!=""&& PreLabel.pos != pPnum)
                {
                    LedLabelController.CloseLed(PreLabel.ip, PreLabel.mac);
                    PreLabel = null;
                }
            }
        }
        private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
        {
            string pNum = cmbPositionNumList.Text;
            CloseLed(pNum);
            TSAVPosition position = CSVPositionReader<TSAVPosition>.GetPositonByNum(pNum);
            if (position != null && position.PositionType.Equals(2))
            {
                PreLabel = LedLabelController.GetLabel(position, selCom, true);
                LedLabelController.OpenLed(position.DeviceIP, position.Leds);
                //LedLabelController.UpdateScreen(PreLabel); 
            }
        }

        private void linkLabel2_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
        {
            CloseLed("");
            string pNum = cmbPositionNumList.Text;
            TSAVPosition position = CSVPositionReader<TSAVPosition>.GetPositonByNum(pNum);
            if (position != null && position.PositionType.Equals(2))
            {
                PreLabel = LedLabelController.GetLabel(position, selCom, true);
                LedLabelController.CloseLed(PreLabel.ip, PreLabel.mac);
            }
        }

        private void btnExport_Click(object sender, EventArgs e)
        {
            if (cmbList.Text != "" && cmbList.SelectedIndex >= 0)
            {
                try
                { 
                    string key = cmbList.Text;
                    List<ComponetInfo> list = CSVBomManager.GetComList(key);

                    SaveFileDialog sfd = new SaveFileDialog();
                    sfd.FileName = "";
                    sfd.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.DesktopDirectory);
                    sfd.FileName = key + "-" + DateTime.Now.ToString("MM:dd:HH:mm").Replace(":", "");
                    sfd.Filter = @"csv|*.csv";
                    DialogResult result = sfd.ShowDialog();

                    if (result.Equals(DialogResult.OK))
                    {
                        string filePath = sfd.FileName;
                        {
                            if (File.Exists(filePath))
                            {
                                File.Delete(filePath);
                            }
                            string[] line = getLine(list);
                            File.WriteAllLines(filePath, line.ToArray(), Encoding.GetEncoding("gbk"));
                            MessageBox.Show(ResourceCulture.GetString("成功导出程序到文件：") + "\r\n" + filePath, ResourceCulture.GetString("提示"));
                        }
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.ToString());
                }
            } 
        }
        private string[] getLine(List<ComponetInfo> list)
        {
            List<string> titleList = new List<string>();
            titleList.Add(ResourceCulture.GetString(ResourceCulture.Col_Num, "位号"));
            titleList.Add(ResourceCulture.GetString(ResourceCulture.Col_Name, "物料编码"));
            titleList.Add(ResourceCulture.GetString(ResourceCulture.Col_Position, "料盘位置"));
            titleList.Add(ResourceCulture.GetString(ResourceCulture.Col_Count, "数量"));
            titleList.Add(ResourceCulture.GetString(ResourceCulture.Col_Notes, "注意事项"));
            titleList.Add(ResourceCulture.GetString(ResourceCulture.Col_Del, "描述"));

            string spilt = ",";
            List<string> line = new List<string>();
            line.Add(string.Join(spilt, titleList));
            line.Add(spilt);
            foreach (ComponetInfo comp in list)
            {
                List<string> valueList = new List<string>();
                valueList.Add(comp.TagNo);
                valueList.Add(comp.PN);
                valueList.Add(comp.PositionNum);
                valueList.Add(comp.ComCount);
                valueList.Add(comp.Notes);
                valueList.Add(comp.ComponentDes);
                line.Add(string.Join(spilt, valueList));
            }
            return line.ToArray();
        }

        private Dictionary<string,string> getTitleMap()
        {
            Dictionary<string, string> titleMap = new Dictionary<string, string>();
            titleMap.Add("TagNo",ResourceCulture.GetString(ResourceCulture.Col_Num, "位号"));
            titleMap.Add("PN",ResourceCulture.GetString(ResourceCulture.Col_Name, "物料编码"));
            titleMap.Add("PositionNum",ResourceCulture.GetString(ResourceCulture.Col_Position, "料盘位置"));
            titleMap.Add("ComCount",ResourceCulture.GetString(ResourceCulture.Col_Count, "数量"));
            titleMap.Add("Notes",ResourceCulture.GetString(ResourceCulture.Col_Notes, "注意事项"));
            titleMap.Add("ComponentDes",ResourceCulture.GetString(ResourceCulture.Col_Del, "描述"));
            return titleMap;
        }

        private void linkLabel3_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
        {
            string pNum = cmbPositionNumList.Text;
            CloseLed(pNum);
            TSAVPosition position = CSVPositionReader<TSAVPosition>.GetPositonByNum(pNum);
            if (position != null && position.PositionType.Equals(2))
            {
                PreLabel = LedLabelController.GetLabel(position, selCom, true);
                LedLabelController.UpdateScreen(PreLabel);
               
            }
        }

        private void linkLabel4_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
        {
            LedLabelController.OpenAll();
        }

        private void linkLabel5_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
        {
            LedLabelController.CloseAll();
        }

        private void btnImport_Click(object sender, EventArgs e)
        {
            openFileDialog1.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.DesktopDirectory);
            DialogResult result = this.openFileDialog1.ShowDialog();
            if (result.Equals(DialogResult.OK))
            {
                string fileName = this.openFileDialog1.FileName;

                List<ComponetInfo> comList = CSVBomManager.ReadFile(fileName, getTitleMap());
                if (comList.Count <= 0)
                {

                }

                List<ComponetUploadInfo> uploadList = new List<ComponetUploadInfo>();

                string bomName = cmbList.Text;
                List<ComponetInfo> list = CSVBomManager.GetComList(bomName);
                foreach (ComponetInfo obj in comList)
                {
                    foreach (ComponetInfo currObj in list)
                    {
                        if (currObj.IsSameCom(obj.PN,obj.PositionNum,obj.TagNo))
                        {
                            ComponetUploadInfo upload = new ComponetUploadInfo();
                            upload.Id = currObj.Id;
                            upload.PN = currObj.PN;
                            upload.TagNo=currObj.TagNo;
                            upload.ComCount = currObj.ComCount;
                            upload.NewCount = obj.ComCount;
                            upload.PositionNum = currObj.PositionNum;
                            uploadList.Add(upload);
                            break;
                        }
                    }

                }
                if(uploadList.Count <= 0)
                {

                }

                FrmListViewer<ComponetUploadInfo> frmListViewer = new FrmListViewer<ComponetUploadInfo>(uploadList, 1);
                List<ComponetInfo> newList = new List<ComponetInfo>();
                DialogResult showRes = frmListViewer.ShowDialog();
                if (showRes.Equals(DialogResult.OK))
                {
                    uploadList = frmListViewer.dataList;

                    foreach (ComponetInfo currObj in list)
                    {
                        foreach (ComponetUploadInfo upload in uploadList)
                        {
                            if (currObj.IsSameCom(upload.PN, upload.PositionNum, upload.TagNo))
                            {
                                LogUtil.info($"修改元器件库{bomName} PN:{currObj.ComCount} TagNo:{currObj.TagNo} 的数量:{currObj.ComCount}->{upload.NewCount}");
                                currObj.ComCount = upload.NewCount;

                                break;
                            }
                        }
                        newList.Add(currObj);
                    }

                    //
                    CSVBomManager.AddBom(bomName, newList);

                    UpdateGridList(list);
                    MessageBox.Show(ResourceCulture.GetString("SaveOk", "保存成功！" ));
                }
            }
        }
    }
}