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(); } } }
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(); } } }