Exemplo n.º 1
0
        private void SetCondition(LinkedList ll)
        {
            DataTable dt = null;

            try
            {
                //여기서 ll이랑 _condition이랑 복제한다.
                byte[] tmp = ll.GetSerialData();

                _condition.SetSerialData((byte[])tmp.Clone());



                if (_condition.Contains(Definition.DynamicCondition_Search_key.PARAM_TYPE))
                {
                    this._sParamType = DCUtil.GetValueData((DataTable)_condition[Definition.DynamicCondition_Search_key.PARAM_TYPE]);
                }


                if (_condition.Contains(Definition.DynamicCondition_Search_key.PERIOD_PPK))
                {
                    dt = (DataTable)_condition[Definition.DynamicCondition_Search_key.PERIOD_PPK];
                    this.dateCondition1.DateType = dt.Rows[0][Definition.DynamicCondition_Condition_key.VALUEDATA].ToString();
                }

                if (_condition.Contains(Definition.DynamicCondition_Search_key.DATETIME_FROM))
                {
                    dt = (DataTable)_condition[Definition.DynamicCondition_Search_key.DATETIME_FROM];
                    this._sStartTime = DCUtil.GetValueData(dt);
                    this.dateCondition1.DateTimeStart = DateTime.Parse(this._sStartTime);
                }

                if (_condition.Contains(Definition.DynamicCondition_Search_key.DATETIME_TO))
                {
                    dt             = (DataTable)_condition[Definition.DynamicCondition_Search_key.DATETIME_TO];
                    this._sEndTime = DCUtil.GetValueData(dt);
                    this.dateCondition1.DateTimeEnd = DateTime.Parse(this._sEndTime);
                }

                if (_condition.Contains(Definition.DynamicCondition_Search_key.SORTING_KEY))
                {
                    dt = (DataTable)_condition[Definition.DynamicCondition_Search_key.SORTING_KEY];
                    sortUC.AddItemsSelected(dt, Definition.DynamicCondition_Condition_key.VALUEDATA);
                }


                this.bSpread1.ClearHead();
                this.bSpread1.DataSource              = null;
                this.bSpread1.ActiveSheet.RowCount    = 0;
                this.bSpread1.ActiveSheet.ColumnCount = 0;
                if (_condition.Contains(Definition.DynamicCondition_Search_key.TYPE))
                {
                    dt = (DataTable)_condition[Definition.DynamicCondition_Search_key.TYPE];
                    string sType = DCUtil.GetValueData(dt);
                    if (sType.Equals("1"))
                    {
                        this._bProbe = true;
                    }
                    else
                    {
                        this._bProbe = false;
                    }

                    this._dtParam = new DataTable();
                    this._dtParam.Columns.Add(Definition.STEP_DATAMAPPING.BASE, typeof(bool));
                    this._dtParam.Columns.Add(Definition.STEP_DATAMAPPING.OPERATION_ID, typeof(string));
                    this._dtParam.Columns.Add(Definition.STEP_DATAMAPPING.OPERATION_DESCRIPTION, typeof(string));
                    this._dtParam.Columns.Add(Definition.STEP_DATAMAPPING.INFORMATION, typeof(string));
                    this._dtParam.Columns.Add(Definition.STEP_DATAMAPPING.ITEM, typeof(string));
                    this._dtParam.Columns.Add(Definition.STEP_DATAMAPPING.SUBDATA, typeof(string));
                    this._dtParam.Columns.Add(Definition.STEP_DATAMAPPING.PROBE, typeof(string));

                    DataRow dr = null;
                    dr = this._dtParam.NewRow();
                    dr[Definition.STEP_DATAMAPPING.BASE]                  = 0;
                    dr[Definition.STEP_DATAMAPPING.OPERATION_ID]          = GetStringList((DataTable)_condition[Definition.DynamicCondition_Search_key.OPERATION], Definition.DynamicCondition_Search_key.VALUEDATA);
                    dr[Definition.STEP_DATAMAPPING.OPERATION_DESCRIPTION] = GetStringList((DataTable)_condition[Definition.DynamicCondition_Search_key.OPERATION], Definition.DynamicCondition_Search_key.DISPLAYDATA);
                    dr[Definition.STEP_DATAMAPPING.INFORMATION]           = GetStringList((DataTable)_condition[Definition.DynamicCondition_Search_key.INFORMATION], Definition.DynamicCondition_Search_key.VALUEDATA);
                    dr[Definition.STEP_DATAMAPPING.ITEM]                  = GetStringList((DataTable)_condition[Definition.DynamicCondition_Search_key.ITEM], Definition.DynamicCondition_Search_key.VALUEDATA);
                    dr[Definition.STEP_DATAMAPPING.SUBDATA]               = GetStringList((DataTable)_condition[Definition.DynamicCondition_Search_key.SUBDATA], Definition.DynamicCondition_Search_key.VALUEDATA);

                    if (_condition.Contains(Definition.DynamicCondition_Search_key.PROBE))
                    {
                        dt = (DataTable)_condition[Definition.DynamicCondition_Search_key.PROBE];
                        dr[Definition.STEP_DATAMAPPING.PROBE] = DCUtil.GetValueData(dt) == "0" ?false:true;;
                    }

                    this._dtParam.Rows.Add(dr);

                    if (_condition.Contains(Definition.DynamicCondition_Search_key.BASE_PROBE))
                    {
                        string sTarget = DCUtil.GetValueData((DataTable)_condition[Definition.DynamicCondition_Search_key.BASE]);

                        if (!string.IsNullOrEmpty(sTarget))
                        {
                            dr = this._dtParam.NewRow();
                            dr[Definition.STEP_DATAMAPPING.BASE]                  = 1;
                            dr[Definition.STEP_DATAMAPPING.OPERATION_ID]          = GetStringList((DataTable)_condition[Definition.DynamicCondition_Search_key.BASE], Definition.DynamicCondition_Search_key.VALUEDATA);
                            dr[Definition.STEP_DATAMAPPING.OPERATION_DESCRIPTION] = GetStringList((DataTable)_condition[Definition.DynamicCondition_Search_key.BASE], Definition.DynamicCondition_Search_key.DISPLAYDATA);
                            dr[Definition.STEP_DATAMAPPING.INFORMATION]           = GetStringList((DataTable)_condition[Definition.DynamicCondition_Search_key.BASE_INFORMATION], Definition.DynamicCondition_Search_key.VALUEDATA);
                            dr[Definition.STEP_DATAMAPPING.ITEM]                  = GetStringList((DataTable)_condition[Definition.DynamicCondition_Search_key.BASE_ITEM], Definition.DynamicCondition_Search_key.VALUEDATA);
                            dr[Definition.STEP_DATAMAPPING.SUBDATA]               = GetStringList((DataTable)_condition[Definition.DynamicCondition_Search_key.BASE_SUBDATA], Definition.DynamicCondition_Search_key.VALUEDATA);

                            if (_condition.Contains(Definition.DynamicCondition_Search_key.BASE_PROBE))
                            {
                                dt = (DataTable)_condition[Definition.DynamicCondition_Search_key.BASE_PROBE];
                                dr[Definition.STEP_DATAMAPPING.PROBE] = DCUtil.GetValueData(dt) == "0" ? false : true;;
                            }
                            this._dtParam.Rows.Add(dr);
                        }
                    }
                    this._dtParam.AcceptChanges();


                    this.bSpread1.ActiveSheet.RowCount    = 0;
                    this.bSpread1.ActiveSheet.ColumnCount = 7;
                    this.bSpread1.AddHead(0, Definition.STEP_DATAMAPPING.BASE, Definition.STEP_DATAMAPPING.BASE, 50, 20, null, null, null, ColumnAttribute.ReadOnly, ColumnType.CheckBox, null, null, null, false, true);
                    this.bSpread1.AddHead(1, Definition.CHART_COLUMN.OPERATION_ID, Definition.STEP_DATAMAPPING.OPERATION_ID, 100, 20, null, null, null, ColumnAttribute.Null, ColumnType.Null, null, null, null, false, false);
                    this.bSpread1.AddHead(2, this._mlthandler.GetVariable(Definition.CHART_COLUMN.OPERATION_ID), Definition.STEP_DATAMAPPING.OPERATION_DESCRIPTION, 100, 20, null, null, null, ColumnAttribute.Null, ColumnType.Null, null, null, null, false, true);
                    this.bSpread1.AddHead(3, Definition.STEP_DATAMAPPING.INFORMATION, Definition.STEP_DATAMAPPING.INFORMATION, 150, 300, null, null, null, ColumnAttribute.Null, ColumnType.Null, null, null, null, false, true);
                    this.bSpread1.AddHead(4, Definition.STEP_DATAMAPPING.ITEM, Definition.STEP_DATAMAPPING.ITEM, 150, 300, null, null, null, ColumnAttribute.Null, ColumnType.Null, null, null, null, false, true);
                    this.bSpread1.AddHead(5, Definition.STEP_DATAMAPPING.SUBDATA, Definition.STEP_DATAMAPPING.SUBDATA, 150, 300, null, null, null, ColumnAttribute.Null, ColumnType.Null, null, null, null, false, true);
                    this.bSpread1.AddHead(6, Definition.STEP_DATAMAPPING.PROBE, Definition.STEP_DATAMAPPING.PROBE, 150, 300, null, null, null, ColumnAttribute.Null, ColumnType.Null, null, null, null, false, false);
                    this.bSpread1.AddHeadComplete();
                    this.bSpread1.DataSource = this._dtParam;
                }
            }
            catch
            {
            }
            finally
            {
                if (dt != null)
                {
                    dt.Dispose();
                }
            }
        }
Exemplo n.º 2
0
        private void SetCondition(LinkedList ll)
        {
            DataTable dt = null;

            try
            {
                //여기서 ll이랑 _condition이랑 복제한다.
                byte[] tmp = ll.GetSerialData();

                _condition.SetSerialData((byte[])tmp.Clone());


                if (_condition.Contains(Definition.DynamicCondition_Search_key.OPERATION))
                {
                    dt = (DataTable)_condition[Definition.DynamicCondition_Search_key.OPERATION];
                    this.arrOperationID = _comUtil.GetConditionKeyArrayList(dt, Definition.DynamicCondition_Condition_key.VALUEDATA);
                }

                if (_condition.Contains(Definition.DynamicCondition_Search_key.PARAM))
                {
                    dt = (DataTable)_condition[Definition.DynamicCondition_Search_key.PARAM];
                    this.arrParameter = _comUtil.GetConditionKeyArrayList(dt, Definition.DynamicCondition_Condition_key.VALUEDATA);
                }

                if (_condition.Contains(Definition.DynamicCondition_Search_key.PARAM_TYPE))
                {
                    this.sParamType = DCUtil.GetValueData((DataTable)_condition[Definition.DynamicCondition_Search_key.PARAM_TYPE]);
                }

                if (_condition.Contains(Definition.DynamicCondition_Search_key.EQP_ID))
                {
                    dt            = (DataTable)_condition[Definition.DynamicCondition_Search_key.EQP_ID];
                    this.arrEQPID = _comUtil.GetConditionKeyArrayList(dt, Definition.DynamicCondition_Condition_key.VALUEDATA);
                }

                if (_condition.Contains(Definition.DynamicCondition_Search_key.PRODUCT))
                {
                    dt = (DataTable)_condition[Definition.DynamicCondition_Search_key.PRODUCT];
                    this.arrProductID = _comUtil.GetConditionKeyArrayList(dt, Definition.DynamicCondition_Condition_key.VALUEDATA);
                }


                //SPC_PERIOD_PPK
                if (_condition.Contains(Definition.DynamicCondition_Search_key.PERIOD_PPK))
                {
                    dt = (DataTable)_condition[Definition.DynamicCondition_Search_key.PERIOD_PPK];
                    this.ppkDate.PeriodType = dt.Rows[0][Definition.DynamicCondition_Condition_key.VALUEDATA].ToString();
                }


                //if (_condition.Contains(Definition.DynamicCondition_Search_key.DATETIME_FROM))
                //{
                //    dt = (DataTable)_condition[Definition.DynamicCondition_Search_key.DATETIME_FROM];
                //    this.sStartTime = DCUtil.GetValueData((DataTable)_condition[Definition.DynamicCondition_Search_key.VALUEDATA]);
                //    this.ppkDate.DateTimeStart = DateTime.Parse(this.sStartTime);
                //}

                //if (_condition.Contains(Definition.DynamicCondition_Search_key.DATETIME_TO))
                //{
                //    dt = (DataTable)_condition[Definition.DynamicCondition_Search_key.DATETIME_TO];
                //    this.sEndTime = DCUtil.GetValueData((DataTable)_condition[Definition.DynamicCondition_Search_key.VALUEDATA]);
                //    this.ppkDate.DateTimeEnd = DateTime.Parse(this.sEndTime);
                //}



                this.PROC_BindOperation();
                this.PROC_BindParameter();
                this.PROC_BindEQPID();
                this.PROC_BindProduct();
                this.PROC_BindSortingKey();

                //SPC_PERIOD_PPK
                if (_condition.Contains(Definition.DynamicCondition_Search_key.SORTING_KEY))
                {
                    dt = (DataTable)_condition[Definition.DynamicCondition_Search_key.SORTING_KEY];
                    sortUC.AddItemsSelected(dt, Definition.DynamicCondition_Condition_key.VALUEDATA);
                }
            } catch
            {
            }finally
            {
                if (dt != null)
                {
                    dt.Dispose();
                }
            }
        }