Exemple #1
0
        protected override void MakeDataSourceToDrawSPCChart(bool sample, int samplePeriod, int sampleCount)
        {
            DataRow dr = null;

            this.dtDataSource = new DataTable();
            this.dtDataSource.Columns.Add(CommonChart.COLUMN_NAME_SEQ_INDEX, typeof(int));
            CommonChart.llstChartColumn = new LinkedList();
            LinkedList llstChartColumn = CommonChart.GetChartSeries(this._xBarChartType, lstRawColumn);

            if (llstChartColumn.Contains(Definition.CHART_COLUMN.MIN))
            {
                llstChartColumn.Remove(Definition.CHART_COLUMN.MIN);
            }
            if (llstChartColumn.Contains(Definition.CHART_COLUMN.MAX))
            {
                llstChartColumn.Remove(Definition.CHART_COLUMN.MAX);
            }
            if (llstChartColumn.Contains(Definition.COL_TOGGLE))
            {
                llstChartColumn.Remove(Definition.COL_TOGGLE);
            }
            if (llstChartColumn.Contains(Definition.COL_TOGGLE_YN))
            {
                llstChartColumn.Remove(Definition.COL_TOGGLE_YN);
            }
            MakeDataTable(llstChartColumn, sample, samplePeriod, sampleCount);
        }
Exemple #2
0
 protected override void MakeDataSourceToDrawSPCChart()
 {
     this.dtDataSource = new DataTable();
     this.dtDataSource.Columns.Add(CommonChart.COLUMN_NAME_SEQ_INDEX, typeof(int));
     CommonChart.llstChartColumn = new LinkedList();
     LinkedList llstChartColumn = CommonChart.GetChartSeries(this._xBarChartType, lstRawColumn);
     MakeDataTable(llstChartColumn);
 }
Exemple #3
0
        protected override void MakeDataSourceToDrawSPCChart()
        {
            //2012-03-23 added by rachel -->
            //[SPC-659]
            //DataRow dr = null;
            ReleaseData();
            //<----

            this.dtDataSource = new DataTable();
            this.dtDataSource.Columns.Add(CommonChart.COLUMN_NAME_SEQ_INDEX, typeof(int));
            CommonChart.llstChartColumn = new LinkedList();
            LinkedList llstChartColumn = CommonChart.GetChartSeries(this._xBarChartType, lstRawColumn);

            MakeDataTable(llstChartColumn);
        }
Exemple #4
0
        protected override void MakeDataSourceToDrawSPCChart()
        {
            this.dtDataSource = new DataTable();
            this.dtDataSource.Columns.Add(CommonChart.COLUMN_NAME_SEQ_INDEX, typeof(int));
            CommonChart.llstChartColumn = new LinkedList();
            LinkedList llstChartColumn;

            //SPC-929, KBLEE, START
            if (ISSUMMARYDATA)
            {
                llstChartColumn = CommonChart.GetSummaryChartSeries(this._xBarChartType, lstRawColumn);
            }
            else
            {
                llstChartColumn = CommonChart.GetChartSeries(this._xBarChartType, lstRawColumn);
            }
            //SPC-929, KBLEE, END

            MakeDataTable(llstChartColumn);
        }
Exemple #5
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="strCol"></param>
        /// <param name="strValue"></param>
        /// <param name="rowIndex"></param>
        /// <returns></returns>
        private string CreateToolTipString(string strCol, string strValue, int rowIndex, string strChartName)
        {
            StringBuilder sb = new StringBuilder();
            LinkedList    llstChartSeries = new LinkedList();

            string _sEQPID       = "-";
            string _sLOTID       = "-";
            string _sOperationID = "-";
            string _sSubstrateID = "-";
            string _sProductID   = "-";


            if (_dataManager.RawDataTable.Columns.Contains(Definition.CHART_COLUMN.EQP_ID))
            {
                _sEQPID = _dataManager.RawDataTable.Rows[rowIndex][Definition.CHART_COLUMN.EQP_ID].ToString();
            }

            if (_dataManager.RawDataTable.Columns.Contains(Definition.CHART_COLUMN.LOT_ID))
            {
                _sLOTID = _dataManager.RawDataTable.Rows[rowIndex][Definition.CHART_COLUMN.LOT_ID].ToString();
            }

            if (_dataManager.RawDataTable.Columns.Contains(Definition.CHART_COLUMN.OPERATION_ID))
            {
                _sOperationID = _dataManager.RawDataTable.Rows[rowIndex][Definition.CHART_COLUMN.OPERATION_ID].ToString();
            }

            if (_dataManager.RawDataTable.Columns.Contains(Definition.CHART_COLUMN.SUBSTRATE_ID))
            {
                _sSubstrateID = _dataManager.RawDataTable.Rows[rowIndex][Definition.CHART_COLUMN.SUBSTRATE_ID].ToString();
            }

            if (_dataManager.RawDataTable.Columns.Contains(Definition.CHART_COLUMN.PRODUCT_ID))
            {
                _sProductID = _dataManager.RawDataTable.Rows[rowIndex][Definition.CHART_COLUMN.PRODUCT_ID].ToString();
            }

            sb.AppendFormat("{0} : {1}\r\n", this._mlthandler.GetVariable(Definition.SPC_LABEL_ + Definition.CHART_COLUMN.PRODUCT_ID), _sProductID);
            sb.AppendFormat("{0} : {1}\r\n", this._mlthandler.GetVariable(Definition.SPC_LABEL_ + Definition.CHART_COLUMN.EQP_ID), _sEQPID);
            sb.AppendFormat("{0} : {1}\r\n", this._mlthandler.GetVariable(Definition.SPC_LABEL_ + Definition.CHART_COLUMN.LOT_ID), _sLOTID);
            sb.AppendFormat("{0} : {1}\r\n", this._mlthandler.GetVariable(Definition.SPC_LABEL_ + Definition.CHART_COLUMN.OPERATION_ID), _sOperationID);
            sb.AppendFormat("{0} : {1}\r\n", this._mlthandler.GetVariable(Definition.SPC_LABEL_ + Definition.CHART_COLUMN.SUBSTRATE_ID), _sSubstrateID);

            if (_dataManager.RawDataTable.Columns.Contains(strChartName))
            {
                llstChartSeries = CommonChart.GetChartSeries(strChartName, ChartVariable.lstRawColumn);
                for (int i = 0; i < llstChartSeries.Count; i++)
                {
                    string sKey   = llstChartSeries.GetKey(i).ToString();
                    string sValue = llstChartSeries.GetValue(i).ToString();

                    if (sValue.Equals(Definition.CHART_COLUMN.USL) ||
                        sValue.Equals(Definition.CHART_COLUMN.LSL) ||
                        sValue.Equals(Definition.CHART_COLUMN.UCL) ||
                        sValue.Equals(Definition.CHART_COLUMN.LCL) ||
                        sValue.Equals(Definition.CHART_COLUMN.TARGET))
                    {
                        continue;
                    }

                    if (_dataManager.RawDataTable.Columns.Contains(sKey))
                    {
                        sb.AppendFormat("{0} : {1}\r\n", this._mlthandler.GetVariable(sValue), _dataManager.RawDataTable.Rows[rowIndex][sKey].ToString());
                    }
                }
                llstChartSeries = null;
            }

            if (_dataManager.RawDataTable.Columns.Contains(Definition.CHART_COLUMN.OCAP_RAWID))
            {
                string    strRawid = GetOCAPRawID(_dataManager.RawDataTable, rowIndex);
                DataTable dtOCAP   = null;

                this.dtGroupBy = new DataTableGroupBy();
                if (!string.IsNullOrEmpty(strRawid))
                {
                    string _fieldList = "ocap_rawid,RAW_RULE";
                    string _groupby   = "ocap_rawid,RAW_RULE";
                    string _sRuleNo   = string.Empty;
                    if (string.IsNullOrEmpty(strRawid.Replace(";", "")))
                    {
                        return(sb.ToString());
                    }
                    if (ChartVariable.dtParamData.Columns.Contains(Definition.CHART_COLUMN.OCAP_RAWID))
                    {
                        string _rowFilter = string.Format("ocap_rawid ='{0}'", strRawid);
                        dtOCAP = this.dtGroupBy.SelectGroupByInto("OCAP", ChartVariable.dtParamData, _fieldList, _rowFilter, _groupby);
                        foreach (DataRow dr in dtOCAP.Rows)
                        {
                            if (!string.IsNullOrEmpty(_sRuleNo))
                            {
                                _sRuleNo += ",";
                            }
                            _sRuleNo += dr["RAW_RULE"].ToString().Replace(";", ",");
                        }
                        sb.AppendFormat("{0} : {1}\r\n", "OOC", _sRuleNo);
                    }
                }
                this.dtGroupBy = null;
                if (dtOCAP != null)
                {
                    dtOCAP.Dispose();
                }
            }

            return(sb.ToString());
        }