private void _overviewItems_CollectionChanged(object sender, System.Collections.Specialized.NotifyCollectionChangedEventArgs e)
        {
            List <Model.IReport> newItems;

            if (e.NewItems != null)
            {
                newItems = e.NewItems.Cast <Model.IReport>().ToList();
            }
            else
            {
                newItems = new List <Model.IReport>();
            }
            List <Model.IReport> oldItems;

            if (e.OldItems != null)
            {
                oldItems = e.OldItems.Cast <Model.IReport>().ToList();
            }
            else
            {
                oldItems = new List <Model.IReport>();
            }
            UniReportContent tmpContent;

            switch (e.Action)
            {
            case System.Collections.Specialized.NotifyCollectionChangedAction.Add:
                for (int i = 0; i < newItems.Count; i++)
                {
                    Model.IReport rpt = newItems[i];
                    tmpContent = new UniReportContent();
                    for (int j = 0; j < rpt.Contents.Count; j++)
                    {
                        Model.IRptOutput output = rpt.Contents[j];
                        switch (output.OType)
                        {
                        case Dashboard.Model.MtbOType.GRAPH:
                            tmpContent.Chart = Tool.BinaryToWPFImage(output.OutputInByteArr);
                            break;

                        default:
                            break;
                        }
                    }
                    tmpContent.Title   = rpt.Title;
                    tmpContent.RawData = rpt.RawData;
                    OverviewTrend.Add(tmpContent);
                }

                break;

            case System.Collections.Specialized.NotifyCollectionChangedAction.Move:
                break;

            case System.Collections.Specialized.NotifyCollectionChangedAction.Remove:
                UnivariateContent.Clear();
                break;

            case System.Collections.Specialized.NotifyCollectionChangedAction.Replace:
                for (int i = 0; i < newItems.Count; i++)
                {
                    Model.IReport rpt = newItems[i];
                    tmpContent = new UniReportContent();
                    for (int j = 0; j < rpt.Contents.Count; j++)
                    {
                        Model.IRptOutput output = rpt.Contents[j];
                        switch (output.OType)
                        {
                        case Dashboard.Model.MtbOType.GRAPH:
                            tmpContent.Chart = Tool.BinaryToWPFImage(output.OutputInByteArr);
                            break;

                        default:
                            break;
                        }
                    }
                    tmpContent.Title   = rpt.Title;
                    tmpContent.RawData = rpt.RawData;
                    OverviewTrend[e.OldStartingIndex + i] = tmpContent;
                }
                break;

            case System.Collections.Specialized.NotifyCollectionChangedAction.Reset:
                List <UniReportContent> tmpLst = new List <UniReportContent>();
                for (int i = 0; i < newItems.Count; i++)
                {
                    Model.IReport rpt = newItems[i];
                    tmpContent = new UniReportContent();
                    for (int j = 0; j < rpt.Contents.Count; j++)
                    {
                        Model.IRptOutput output = rpt.Contents[j];
                        switch (output.OType)
                        {
                        case Dashboard.Model.MtbOType.GRAPH:
                            tmpContent.Chart = Tool.BinaryToWPFImage(output.OutputInByteArr);
                            break;

                        default:
                            break;
                        }
                    }
                    tmpContent.Title   = rpt.Title;
                    tmpContent.RawData = rpt.RawData;
                    tmpLst.Add(tmpContent);
                }
                OverviewTrend.Clear();
                OverviewTrend = new ObservableCollection <UniReportContent>(tmpLst);
                break;

            default:
                break;
            }
        }
        protected override void _bgWorker_DoWork(object sender, DoWorkEventArgs e)
        {
            IsBusy = true;
            if (_spcItemInfoTable == null || _spcItemInfoTable.Rows.Count == 0)
            {
                return;
            }

            App.Current.Dispatcher.Invoke((Action) delegate // <--- HERE
            {
                _uniRptItems.Clear();
                _multiRptItems.Clear();
                _overviewItems.Clear();
                UnivariateContent.Clear();
                MultiVariateContent.Clear();
                OverviewTrend.Clear();
                ShowSeparator = false;
            });


            lock (_spcItemInfoTable)
            {
                string        connString = Database.DBQueryTool.GetConnString();
                StringBuilder query      = new StringBuilder();

                DataRow[]            spcItemRow = _spcItemInfoTable.Rows.Cast <DataRow>().ToArray();
                List <Model.IReport> rptItems   = new List <Model.IReport>();

                DataRow[] spcItemRow_uni = new DataRow[] { };
                DataRow[] spcItemRow_mul = new DataRow[] { };
                if (spcItemRow.Any(x => x.Field <string>("FLAG") == "T2"))
                {
                    spcItemRow_mul = spcItemRow.Where(x => x.Field <string>("FLAG") == "T2").ToArray();
                }
                if (spcItemRow.Any(x => x.Field <string>("FLAG") == "I"))
                {
                    spcItemRow_uni = spcItemRow.Where(x => x.Field <string>("FLAG") == "I").ToArray();
                }

                if (spcItemRow_mul.Length > 0 && spcItemRow_uni.Length > 0)
                {
                    ShowSeparator = true;
                }

                string start = string.Format("{0:yyyy-MM-dd} {1}", StartDate.Date, StartTimeValue);
                string end   = string.Format("{0:yyyy-MM-dd} {1}", EndDate.Date, EndTimeValue);

                string tmpDir = System.IO.Path.Combine(Environment.GetEnvironmentVariable("tmp"), "Minitab");
                try
                {
                    Array.ForEach(System.IO.Directory.GetFiles(tmpDir), System.IO.File.Delete); //刪除暫存區所有檔案
                }
                catch
                {
                }

                for (int i = 0; i < spcItemRow_mul.Length; i++)
                {
                    query.Clear();
                    Project.Commands.Delete();
                    Project.Worksheets.Delete();

                    DataRow dr = spcItemRow_mul[i];
                    Model.MultivariateReport rpt = new Model.MultivariateReport();
                    string[] item = dr["ITEM_LIST"].ToString().Split(',');
                    rpt.RawData = Database.DBQueryTool.GetPivotDataForMultivariateChart(_siteId, item, start, end);

                    //搜尋是否有參數
                    DataTable paraDetTable = null;
                    query.AppendLine("SELECT a.CHART_PARA_INDEX, b.FLAG, b.ROWNO, b.COLNO, b.VALUE, a.ITEM_LIST FROM CHART_PARAMETER a LEFT JOIN PARAMETER_DETAIL b");
                    query.AppendLine("ON a.CHART_PARA_INDEX = b.CHART_PARA_INDEX");
                    query.AppendFormat("WHERE a.ITEM_LIST='{0}'", dr["ITEM_LIST"].ToString());
                    paraDetTable   = Database.DBQueryTool.GetData(query.ToString(), Database.DBQueryTool.GetConnString());
                    rpt.Parameters = paraDetTable;

                    if (rpt.RawData != null && rpt.RawData.Rows.Count > 0)
                    {
                        rpt.Title = dr["TITLE"].ToString();
                        rpt.Flag  = dr["FLAG"].ToString();
                        try
                        {
                            rpt.Execute(_proj);
                        }
                        catch (Exception ex)
                        {
                            throw new Exception("Minitab run time error\r\n" + ex.Message);
                        }

                        rptItems.Add(rpt);
                        App.Current.Dispatcher.Invoke((Action) delegate // <--- HERE
                        {
                            _multiRptItems.Add(rpt);
                        });
                    }
                    if (_bgWorker.CancellationPending)
                    {
                        Console.WriteLine("**We need to cancel the work...call _bgWorker_RunWorkerCompleted**");
                        return;
                    }
                }

                /*
                 * 針對單變量取得時間內所有資料 (不用處理SPC的工作)
                 *
                 */
                int iCnt = 0;
                iCnt = _spcItemInfoTable.Select("FLAG='I'").Count();
                if (iCnt > 1)//超過1組資料才要畫整體趨勢圖
                {
                    string[] item = spcItemRow_uni.Select(x => x.Field <string>("ITEM_LIST")).ToArray();
                    Model.OverlayTrendReport rpt = new Model.OverlayTrendReport();
                    string sTime = string.Format("{0:yyyy-MM-dd hh:mm:ss}", start);
                    string eTime = string.Format("{0:yyyy-MM-dd hh:mm:ss}", end);
                    rpt.RawData = Database.DBQueryTool.GetPivotDataForMultivariateChart(SITE_ID, item, sTime, eTime);

                    if (rpt.RawData != null && rpt.RawData.Rows.Count > 0)
                    {
                        rpt.Title = "整體趨勢圖";
                        try
                        {
                            rpt.Execute(Project);
                        }
                        catch (Exception ex)
                        {
                            throw new Exception("Minitab run time error\r\n" + ex.Message);
                        }
                        rptItems.Add(rpt);
                        App.Current.Dispatcher.Invoke((Action) delegate // <--- HERE
                        {
                            _overviewItems.Add(rpt);
                        });
                    }
                }


                for (int i = 0; i < spcItemRow_uni.Length; i++)
                {
                    query.Clear();
                    Project.Commands.Delete();
                    Project.Worksheets.Delete();
                    DataRow dr = spcItemRow_uni[i];
                    Model.UnivariateReport rpt = new Model.UnivariateReport();
                    string[] item = dr["ITEM_LIST"].ToString().Split(',');
                    item = item.Select(x => "'" + x + "'").ToArray();
                    query.Clear();
                    //query.AppendLine("SELECT * FROM VW_FURNACEDATAINSPC");
                    //query.AppendFormat("WHERE FURN_ITEM_INDEX IN ({0}) ", string.Join(",", item));
                    //query.AppendFormat("AND RPT_DATETIME BETWEEN '{0}' AND '{1}'\r\n", start, end);
                    //query.AppendLine("ORDER BY RPT_DATETIME");

                    query.AppendLine(Database.DBQueryTool.GetSQLString_FurnacedataInSPC(SITE_ID, item, start, end));
                    query.AppendLine("SELECT * FROM @tmpfurnacedatainspc order by rpt_datetime");
                    rpt.RawData = Database.DBQueryTool.GetData(query.ToString(), connString);

                    if (rpt.RawData != null && rpt.RawData.Rows.Count > 0)
                    {
                        rpt.Title = dr["TITLE"].ToString();
                        rpt.Flag  = dr["FLAG"].ToString();
                        rpt.Execute(_proj);
                        rptItems.Add(rpt);
                        App.Current.Dispatcher.Invoke((Action) delegate // <--- HERE
                        {
                            _uniRptItems.Add(rpt);
                        });
                    }
                    if (_bgWorker.CancellationPending)
                    {
                        Console.WriteLine("**We need to cancel the work...call _bgWorker_RunWorkerCompleted**");
                        return;
                    }
                }
            }
        }