using DevExpress.XtraCharts.Designer;
using HStation.Vmo;
using HStation.WinFrmUI.Assets;
using System.IO;
using System.Windows.Media.Animation;
using Yw;

namespace HStation.WinFrmUI
{
    public partial class ImportPumpExcel : DevExpress.XtraEditors.XtraForm
    {
        public ImportPumpExcel()
        {
            InitializeComponent();
            this.IconOptions.Icon = Yw.WinFrmUI.GlobalParas.AppIcon;
            this.generalOkAndCancelCtrl1.OkEvent += GeneralOkAndCancelCtrl1_OkEvent;
        }

        private List<Vmo.AssetsPumpMainVmo> _Pumps;

        private long _seriesId;

        public void SetBindingData(long seriesId)
        {
            _seriesId = seriesId;
        }

        public event Action ReloadDataEvent;

        private void btnExcelFilePath_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
        {
            if (e.Button.Tag.ToString() == "Import")
            {
                var dlg = new System.Windows.Forms.OpenFileDialog();
                dlg.Filter = "EXCEL 文件(*.xls;*.xlsx)|*.xls;*.xlsx";
                dlg.CheckFileExists = true;
                if (dlg.ShowDialog() != System.Windows.Forms.DialogResult.OK)
                    return;
                this.btnExcelFilePath.Text = dlg.FileName;
                _Pumps = new List<Vmo.AssetsPumpMainVmo>();
                var PumpExcelHelper = new PumpExcelHelper();
                var result = PumpExcelHelper.ParsePumpExcel(dlg.FileName, out _Pumps);
                if (result != null && !string.IsNullOrEmpty(result))
                {
                    TipFormHelper.ShowWarn(result);
                    return;
                }
                _Pumps.ForEach(x => x.SeriesID = _seriesId);
                this.gridControl1.DataSource = _Pumps;
            }
            else if (e.Button.Tag.ToString() == "Download")
            {
                var dlg = new SaveFileDialog();
                dlg.Title = "模板导出路径";
                dlg.Filter = "Excel文件|*.xls";
                if (dlg.ShowDialog() == DialogResult.OK)
                {
                    var fileName = dlg.FileName;
                    PumpExcelHelper.ExportPumpTemplate(fileName);
                    TipFormHelper.ShowSucceed("导出成功！");
                }
            }
        }

        //验证
        private bool Valid()
        {
            this.dxErrorProvider1.ClearErrors();
            if (string.IsNullOrEmpty(this.btnExcelFilePath.Text.Trim()))
            {
                this.dxErrorProvider1.SetError(this.btnExcelFilePath, "必填项");
                return false;
            }
            return true;
        }

        //确定
        private async void GeneralOkAndCancelCtrl1_OkEvent()
        {
            if (!Valid())
            {
                return;
            }
            if (_Pumps.Count < 0 || _Pumps == null)
            {
                TipFormHelper.ShowError("导入信息为空!");
                return;
            }
            var bol = await BLLFactory<HStation.BLL.AssetsPumpMain>.Instance.Inserts(_Pumps);
            if (bol)
            {
                this.ReloadDataEvent?.Invoke();
                TipFormHelper.ShowSucceed("导入成功!");
            }
            else
            {
                TipFormHelper.ShowError("导入失败!");
            }
            this.DialogResult = DialogResult.OK;
            this.Close();
        }

        //批量导入泵曲线(根据文件名匹配)
        private async void btnImportCurve_Click(object sender, EventArgs e)
        {
            FolderBrowserDialog folderBrowserDialog = new FolderBrowserDialog();
            if (folderBrowserDialog.ShowDialog() == DialogResult.OK)
            {
                var allPumpList = await new BLL.AssetsPumpMain().GetAll();
                string folderpath = folderBrowserDialog.SelectedPath;
                string[] excelFilePath = Directory.GetFiles(folderpath);
                try
                {
                    foreach (string excelFile in excelFilePath)
                    {
                        string fileName = Path.GetFileNameWithoutExtension(excelFile);
                        var vmo = ExcelConvertHelper.ParsePumpExcel(excelFile);
                        if (vmo != null)
                        {
                            var select = allPumpList.Find(x => x.Name == fileName);
                            if (select != null)
                            {
                                vmo.Name = select.Name;
                                var diagramId = await BLLFactory<Yw.BLL.PhartDiagramExtensions>.Instance.Insert(vmo);
                                if (diagramId < 1)
                                {
                                    TipFormHelper.ShowError("图表信息保存失败！");
                                    return;
                                }
                                var vmoRelation = new PhartDiagramRelationVmo();
                                vmoRelation.ObjectType = HStation.Assets.DataType.PumpMain;
                                vmoRelation.ObjectID = select.ID;
                                vmoRelation.DiagramID = diagramId;
                                vmoRelation.OtherName = select.Name;
                                vmoRelation.Importance = 0;
                                var relationId = await BLLFactory<HStation.BLL.PhartDiagramRelation>.Instance.Insert(vmoRelation);
                                if (relationId < 1)
                                {
                                    TipFormHelper.ShowError("图表关联信息保存失败！");
                                    return;
                                }
                            }
                        }
                    }
                }
                catch (Exception ex)
                {
                    TipFormHelper.ShowError(ex.Message);
                    return;
                }
                TipFormHelper.ShowSucceed("导入成功!");
            }
        }
    }
}