using DevExpress.XtraEditors;
using NPOI.HSSF.UserModel;
using System.IO;
using Yw;

namespace IStation.Win
{
    public partial class ScheduleValidView : XtraUserControl
    {
        public ScheduleValidView()
        {
            InitializeComponent();
            this.bandedGridView1.BandPanelRowHeight = 35;
            this.bandedGridView1.RegistCustomDrawRowIndicator();
            this.bandedGridView1.SetNormalView();

            this.cmbSelectStation.SelectedIndex = _sel_index - 1;
        }


        private List<ScheduleValidViewModel> _schedule_valid_vm_list = null;
        private int _sel_index = 2;

        //导入文件
        private void barBtnImport_Click(object sender, EventArgs e)
        {
            var dlg = new OpenFileDialog();
            dlg.Filter = "EXCEL 文件(*.xls)|*.xls";
            if (dlg.ShowDialog() != DialogResult.OK)
                return;

            var fileName = dlg.FileName;
            int line = 0;
            try
            {
                //初始化文件 
                HSSFWorkbook theBook = null;
                using (FileStream file = new FileStream(fileName, FileMode.Open, FileAccess.Read))
                {
                    theBook = new HSSFWorkbook(file);
                }

                //检查表格是否符合
                NPOI.SS.UserModel.ISheet sheet1 = theBook.GetSheet("Sheet1");
                if (sheet1 == null)
                {
                    sheet1 = theBook.GetSheetAt(0);
                    if (sheet1 == null)
                    {
                        MessageBox.Show("请将数据放在Sheet1中");
                        return;
                    }
                }

                //标题行
                int title_line_index = 0;
                //时间
                int col_index_time = 0;
                //总流量
                int col_index_flow = 1;
                //总扬程
                int col_index_head = 2;
                //总功率
                int col_index_power = 3;
                //运行标志
                int col_index_flag_rpm_dict = 4;
                //运行标志
                int col_index_flag_flow_dict = 5;
                //运行标志
                int col_index_flag_head_dict = 6;
                //运行标志
                int col_index_flag_power_dict = 7;


                var row_title = sheet1.GetRow(title_line_index);
                if (row_title == null)
                {
                    MessageBox.Show("第一行第一列不能空,");
                    return;
                }

                //开始读取的行  
                int start_line = title_line_index + 1;
                var cell_0 = row_title.GetCell(0);
                if (cell_0 == null)
                {
                    MessageBox.Show("无法读取表头文件");
                    return;
                }

                _schedule_valid_vm_list = new List<ScheduleValidViewModel>();

                DateTime time;
                Dictionary<int, double> flag_rpm_dict, flag_flow_dict, flag_head_dict, flag_power_dict;
                double flow, head, power;
                NPOI.SS.UserModel.IRow rowtemp = null;
                NPOI.SS.UserModel.ICell cell;

                for (line = start_line; line < 100; line++)
                {
                    flow = head = power = -1;
                    flag_rpm_dict = new Dictionary<int, double>();
                    flag_flow_dict = new Dictionary<int, double>();
                    flag_head_dict = new Dictionary<int, double>();
                    flag_power_dict = new Dictionary<int, double>();
                    rowtemp = sheet1.GetRow(line);
                    if (rowtemp == null)
                        break;

                    cell = rowtemp.GetCell(col_index_time);
                    if (cell == null)
                        break;
                    if (!DateTime.TryParse(cell.StringCellValue, out time))
                    {
                        continue;
                    }

                    cell = rowtemp.GetCell(col_index_flow);
                    if (cell == null)
                        break;
                    if (cell.CellType == NPOI.SS.UserModel.CellType.Numeric)
                        flow = cell.NumericCellValue;
                    else if (cell.CellType == NPOI.SS.UserModel.CellType.String)
                        flow = Convert.ToDouble(cell.StringCellValue);
                    else
                        continue;

                    if (flow < 0)
                        break;

                    cell = rowtemp.GetCell(col_index_head);
                    if (cell == null)
                        break;
                    if (cell.CellType == NPOI.SS.UserModel.CellType.Numeric)
                        head = cell.NumericCellValue;
                    else if (cell.CellType == NPOI.SS.UserModel.CellType.String)
                        head = Convert.ToDouble(cell.StringCellValue);
                    else if (cell.CellType == NPOI.SS.UserModel.CellType.Blank)
                        break;
                    if (head < 0)
                        break;


                    cell = rowtemp.GetCell(col_index_power);
                    if (cell == null)
                        break;
                    if (cell.CellType == NPOI.SS.UserModel.CellType.Numeric)
                        power = cell.NumericCellValue;
                    else if (cell.CellType == NPOI.SS.UserModel.CellType.String)
                        power = Convert.ToDouble(cell.StringCellValue);
                    else
                        power = -1;


                    cell = rowtemp.GetCell(col_index_flag_rpm_dict);
                    if (cell == null)
                        break;
                    else if (cell.CellType == NPOI.SS.UserModel.CellType.String)
                        flag_rpm_dict = JsonHelper.Json2Object<Dictionary<int, double>>(cell.StringCellValue);

                    cell = rowtemp.GetCell(col_index_flag_flow_dict);
                    if (cell == null)
                        break;
                    else if (cell.CellType == NPOI.SS.UserModel.CellType.String)
                        flag_flow_dict = JsonHelper.Json2Object<Dictionary<int, double>>(cell.StringCellValue);

                    cell = rowtemp.GetCell(col_index_flag_head_dict);
                    if (cell == null)
                        break;
                    else if (cell.CellType == NPOI.SS.UserModel.CellType.String)
                        flag_head_dict = JsonHelper.Json2Object<Dictionary<int, double>>(cell.StringCellValue);

                    cell = rowtemp.GetCell(col_index_flag_power_dict);
                    if (cell == null)
                        break;
                    else if (cell.CellType == NPOI.SS.UserModel.CellType.String)
                        flag_power_dict = JsonHelper.Json2Object<Dictionary<int, double>>(cell.StringCellValue);


                    var vm = new ScheduleValidViewModel();
                    vm.Time = time;
                    vm.TotalFlowSrc = flow;
                    vm.TotalHeadSrc = head;
                    vm.TotalPowerSrc = power;
                    vm.FlagRpmDict = flag_rpm_dict;
                    if (flag_rpm_dict != null && flag_rpm_dict.Any())
                    {
                        var flags = flag_rpm_dict.Select(x => x.Key).ToList();
                        vm.RunFlagsSrc = Yw.Untity.IntListHelper.ToString(flags);
                    }
                    vm.FlagFlowDict = flag_flow_dict;
                    vm.FlagHeadDict = flag_head_dict;
                    vm.FlagPowerDict = flag_power_dict;

                    _schedule_valid_vm_list.Add(vm);
                }

                this.scheduleValidViewModelBindingSource.DataSource = _schedule_valid_vm_list;
                this.scheduleValidViewModelBindingSource.ResetBindings(false);
                this.gridControl1.RefreshDataSource();
                this.bandedGridView1.BestFitColumns();
            }
            catch (System.Exception err)
            {
                MessageBox.Show(string.Format("读取Excel出错!错误原因：{0},行号: {1}", err.Message, line), "提示信息",
                    MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
        }

        //调度
        private void barBtnSchedule_Click(object sender, EventArgs e)
        {
            if (_schedule_valid_vm_list == null || !_schedule_valid_vm_list.Any())
            {
                XtraMessageBox.Show("无数据!");
                return;
            }

            try
            {
                //WaitHelper.ShowWaitForm();
                //var station = new Service.Station().Get();
                //List<Model.Pump> pumps; 
                //if (_sel_index == 1)
                //{
                //    pumps = station.Station1; 
                //}
                //else
                //{
                //    pumps = station.Station2; 
                //}

                //var current_open_pump_list = new List<int>();
                //var must_open_pump_list = new List<int>();
                //var must_not_open_pump_list = new List<int>();
                //var schedule_helper = new Algorithm.ScheduleHelper();

                //foreach (var vm in _schedule_valid_vm_list)
                //{
                //    if (vm.FlagRpmDict == null || !vm.FlagRpmDict.Any())
                //        continue;
                //    current_open_pump_list = vm.FlagRpmDict.Select(x => x.Key).ToList();
                //    if (current_open_pump_list == null || current_open_pump_list.Count < 1)
                //        continue;
                //    var target_flow = vm.TotalFlowSrc;
                //    var target_head = vm.TotalHeadSrc;

                //    var opt_schedule = schedule_helper.GetOptAnaCombine(pumps,  target_flow, target_head);
                //    if (opt_schedule != null)
                //    {
                //        vm.TotalFlowSchedule = opt_schedule.Flow;
                //        vm.TotalHeadSchedule = opt_schedule.Head;
                //        vm.TotalPowerSchedule = opt_schedule.Power;
                //        vm.RunFlagsSchedule = opt_schedule.Remark;

                //        vm.TotalFlowScheduleSrcDiff = opt_schedule.Flow - target_flow;
                //        vm.TotalPowerScheduleSrcDiff = opt_schedule.Power - vm.TotalPowerSrc;
                //    }

                //    var opt_src = schedule_helper.GetOptAnaCombineByWorking(pumps, vm.FlagRpmDict, vm.FlagHeadDict, target_flow, target_head);
                //    if (opt_src != null)
                //    {
                //        vm.TotalFlowCalc = opt_src.Flow;
                //        vm.TotalPowerCalc = opt_src.Power;

                //        vm.TotalFlowCalcSrcDiff = opt_src.Flow - target_flow;
                //        vm.TotalPowerCalcSrcDiff = opt_src.Power - vm.TotalPowerSrc;
                //    }
                //    vm.Round();
                //}

                this.scheduleValidViewModelBindingSource.DataSource = _schedule_valid_vm_list;
                this.scheduleValidViewModelBindingSource.ResetBindings(false);
                this.gridControl1.RefreshDataSource();
                this.bandedGridView1.BestFitColumns();
            }
            //catch (Exception ex)
            //{
            //    XtraMessageBox.Show(ex.Message);
            //}
            finally
            {
                WaitHelper.HideWaitForm();
            }

        }

        //选中泵站变换
        private void cmbSelectStation_SelectedIndexChanged(object sender, EventArgs e)
        {
            _sel_index = this.cmbSelectStation.SelectedIndex + 1;
        }


    }
}