private void LoadCondition(int paramNo) { NoteParamDataSet noteSet = Context.DB.NoteParamSet; noteSet.Select(paramNo); noteSet.Fetch(); int noteNo = noteSet.RecNo; CtrlTestCondition ctrl = Context.Condition.Control; ctrl.noteCompanyEdit.Text = noteSet.Company; ctrl.noteTestNameEdit.Text = noteSet.TestName; ctrl.noteTestNoEdit.Text = noteSet.TestNo; ctrl.noteObserverEdit.Text = noteSet.Observer; ctrl.noteMakerCombo.Text = noteSet.Maker; ctrl.noteModel1Combo.Text = noteSet.Model1; ctrl.noteSerial1Combo.Text = noteSet.Serial1; ctrl.noteModel2Edit.Text = noteSet.Model2; ctrl.noteSerial2Edit.Text = noteSet.Serial2; ctrl.noteModel3Edit.Text = noteSet.Model3; ctrl.noteSerial3Edit.Text = noteSet.Serial3; ctrl.noteExpDeviceEdit.Text = noteSet.ExpDevice; ctrl.noteRefrigerantCombo.Text = noteSet.Refrig; ctrl.noteMemoEdit.Text = noteSet.Memo; MethodParamDataSet methodSet = Context.DB.MethodParamSet; methodSet.Select(noteNo); methodSet.Fetch(); ctrl.methodIntegralCountEdit.Value = methodSet.IntegCount; ctrl.methodIntegralTimeEdit.Value = methodSet.IntegTime; ctrl.methodScanTimeCombo.Text = methodSet.ScanTime.ToString(); ctrl.methodCapaCoolingUnitCombo.SelectedValue = methodSet.CoolCapacityUnit; ctrl.methodCapaHeatingUnitCombo.SelectedValue = methodSet.HeatCapacityUnit; ctrl.methodAirFlowUnitCombo.SelectedValue = methodSet.AirFlowUnit; ctrl.methodEnthalpyUnitCombo.SelectedValue = methodSet.EnthalpyUnit; ctrl.methodPressureUnitCombo.SelectedValue = methodSet.PressureUnit; ctrl.methodTempUnitCombo.SelectedValue = methodSet.TemperatureUnit; ctrl.methodDiffPressureUnitCombo.SelectedValue = methodSet.DiffPressureUnit; ctrl.methodAtmPressureUnitCombo.SelectedValue = methodSet.AtmPressureUnit; ctrl.methodAutoCtrlSetCheck.Checked = methodSet.AutoSetController; ctrl.methodUsePmIntegCheck.Checked = methodSet.UsePowerMeter; foreach (TabPage page in Context.Condition.Control.ratedTab.TabPages) { CtrlTestRated rated = page.Controls[0] as CtrlTestRated; RatedParamDataSet ratedSet = Context.DB.RatedParamSet; ratedSet.Select(noteNo, rated.Index); if (ratedSet.GetRowCount() == 2) { ratedSet.Fetch(0); rated.CoolingRecNo = ratedSet.RecNo; rated.coolingCapacityEdit.EditValue = ratedSet.Capacity; rated.coolingPowerInEdit.EditValue = ratedSet.Power; rated.coolingEepEdit.EditValue = ratedSet.EER_COP; rated.coolingVoltEdit.EditValue = ratedSet.Volt; rated.coolingCurrentEdit.EditValue = ratedSet.Amp; rated.coolingFreqCombo.Text = ratedSet.Freq; rated.coolingPowerMeter1Combo.SelectedIndex = ratedSet.PM_IDU; rated.coolingPowerMeter2Combo.SelectedIndex = ratedSet.PM_ODU; rated.coolingPhaseCombo.SelectedValue = ratedSet.Phase; ratedSet.Fetch(1); rated.HeatingRecNo = ratedSet.RecNo; rated.heatingCapacityEdit.EditValue = ratedSet.Capacity; rated.heatingPowerInEdit.EditValue = ratedSet.Power; rated.heatingEepEdit.EditValue = ratedSet.EER_COP; rated.heatingVoltEdit.EditValue = ratedSet.Volt; rated.heatingCurrentEdit.EditValue = ratedSet.Amp; rated.heatingFreqCombo.Text = ratedSet.Freq; rated.heatingPowerMeter1Combo.SelectedIndex = ratedSet.PM_IDU; rated.heatingPowerMeter2Combo.SelectedIndex = ratedSet.PM_ODU; rated.heatingPhaseCombo.SelectedValue = ratedSet.Phase; } } ThermoPressParamDataSet tcSet = Context.DB.ThermoPressParamSet; tcSet.Select(noteNo, 0); for (int i = 0; i < tcSet.GetRowCount(); i++) { MeasureRow row = Context.Condition.TC1[i]; tcSet.Fetch(i); row.Name = tcSet.Name; } tcSet.Select(noteNo, 1); for (int i = 0; i < tcSet.GetRowCount(); i++) { MeasureRow row = Context.Condition.TC2[i]; tcSet.Fetch(i); row.Name = tcSet.Name; } tcSet.Select(noteNo, 2); for (int i = 0; i < tcSet.GetRowCount(); i++) { MeasureRow row = Context.Condition.TC3[i]; tcSet.Fetch(i); row.Name = tcSet.Name; } tcSet.Select(noteNo, 3); for (int i = 0; i < tcSet.GetRowCount(); i++) { MeasureRow row = Context.Condition.Pressures[i]; tcSet.Fetch(i); row.Name = tcSet.Name; } Context.Condition.Control.RefreshData(); }
private void InsertCondition(int paramNo) { NoteParamDataSet noteSet = Context.DB.NoteParamSet; noteSet.RecNo = (int)Context.DB.GetGenNo("GN_CONDITION_NOTEPARAM"); noteSet.ParamNo = paramNo; noteSet.Company = Context.Condition.Note.Company; noteSet.TestName = Context.Condition.Note.Name; noteSet.TestNo = Context.Condition.Note.No; noteSet.Observer = Context.Condition.Note.Observer; noteSet.Maker = Context.Condition.Note.Maker; noteSet.Model1 = Context.Condition.Note.Model1; noteSet.Serial1 = Context.Condition.Note.Serial1; noteSet.Model2 = Context.Condition.Note.Model2; noteSet.Serial2 = Context.Condition.Note.Serial2; noteSet.Model3 = Context.Condition.Note.Model3; noteSet.Serial3 = Context.Condition.Note.Serial3; noteSet.ExpDevice = Context.Condition.Note.ExpDevice; noteSet.Refrig = Context.Condition.Note.Refrigerant; noteSet.RefCharge = Context.Condition.Note.RefCharge; noteSet.Memo = Context.Condition.Note.Memo; noteSet.CoolUnit = Context.Condition.Method.CoolingCapacity; noteSet.HeatUnit = Context.Condition.Method.HeatingCapacity; noteSet.Insert(Context.DB.Trans); MethodParamDataSet methodSet = Context.DB.MethodParamSet; methodSet.RecNo = (int)Context.DB.GetGenNo("GN_CONDITION_METHODPARAM"); methodSet.NoteNo = noteSet.RecNo; methodSet.IntegCount = Context.Condition.Method.IntegralCount; methodSet.IntegTime = Context.Condition.Method.IntegralTime; methodSet.ScanTime = Context.Condition.Method.ScanTime; methodSet.CoolCapacityUnit = Context.Condition.Method.CoolingCapacity; methodSet.HeatCapacityUnit = Context.Condition.Method.HeatingCapacity; methodSet.AirFlowUnit = Context.Condition.Method.AirFlow; methodSet.EnthalpyUnit = Context.Condition.Method.Enthalpy; methodSet.PressureUnit = Context.Condition.Method.Pressure; methodSet.TemperatureUnit = Context.Condition.Method.Temperature; methodSet.DiffPressureUnit = Context.Condition.Method.DiffPressure; methodSet.AtmPressureUnit = Context.Condition.Method.AtmPressure; methodSet.AutoSetController = Context.Condition.Method.AutoControllerSetting; methodSet.UsePowerMeter = Context.Condition.Method.UsePowerMeterIntegral; methodSet.Insert(Context.DB.Trans); RatedParamDataSet ratedSet = Context.DB.RatedParamSet; foreach (KeyValuePair <EConditionRated, List <ConditionRated> > rated in Context.Condition.Rateds) { ratedSet.RecNo = (int)Context.DB.GetGenNo("GN_CONDITION_RATEDPARAM"); ratedSet.NoteNo = noteSet.RecNo; ratedSet.PageNo = rated.Key; ratedSet.Mode = ETestMode.Cooling; ratedSet.Capacity = rated.Value[(int)ETestMode.Cooling].Capacity; ratedSet.Power = rated.Value[(int)ETestMode.Cooling].PowerInput; ratedSet.EER_COP = rated.Value[(int)ETestMode.Cooling].EER_COP; ratedSet.Volt = rated.Value[(int)ETestMode.Cooling].Voltage; ratedSet.Amp = rated.Value[(int)ETestMode.Cooling].Current; ratedSet.Freq = rated.Value[(int)ETestMode.Cooling].Frequency; ratedSet.PM_IDU = rated.Value[(int)ETestMode.Cooling].PM_IDU; ratedSet.PM_ODU = rated.Value[(int)ETestMode.Cooling].PM_ODU; ratedSet.Phase = rated.Value[(int)ETestMode.Cooling].Wiring; ratedSet.Insert(Context.DB.Trans); ratedSet.RecNo = (int)Context.DB.GetGenNo("GN_CONDITION_RATEDPARAM"); ratedSet.NoteNo = noteSet.RecNo; ratedSet.PageNo = rated.Key; ratedSet.Mode = ETestMode.Heating; ratedSet.Capacity = rated.Value[(int)ETestMode.Heating].Capacity; ratedSet.Power = rated.Value[(int)ETestMode.Heating].PowerInput; ratedSet.EER_COP = rated.Value[(int)ETestMode.Heating].EER_COP; ratedSet.Volt = rated.Value[(int)ETestMode.Heating].Voltage; ratedSet.Amp = rated.Value[(int)ETestMode.Heating].Current; ratedSet.Freq = rated.Value[(int)ETestMode.Heating].Frequency; ratedSet.PM_IDU = rated.Value[(int)ETestMode.Heating].PM_IDU; ratedSet.PM_ODU = rated.Value[(int)ETestMode.Heating].PM_ODU; ratedSet.Phase = rated.Value[(int)ETestMode.Heating].Wiring; ratedSet.Insert(Context.DB.Trans); } ThermoPressParamDataSet tcSet = Context.DB.ThermoPressParamSet; foreach (MeasureRow row in Context.Condition.TC1) { tcSet.RecNo = (int)Context.DB.GetGenNo("GN_CONDITION_THERMOPRESSPARAM"); tcSet.NoteNo = noteSet.RecNo; tcSet.ChType = 0; tcSet.ChNo = row.No; tcSet.Name = row.Name; tcSet.Insert(Context.DB.Trans); } foreach (MeasureRow row in Context.Condition.TC2) { tcSet.RecNo = (int)Context.DB.GetGenNo("GN_CONDITION_THERMOPRESSPARAM"); tcSet.NoteNo = noteSet.RecNo; tcSet.ChType = 1; tcSet.ChNo = row.No; tcSet.Name = row.Name; tcSet.Insert(Context.DB.Trans); } foreach (MeasureRow row in Context.Condition.TC3) { tcSet.RecNo = (int)Context.DB.GetGenNo("GN_CONDITION_THERMOPRESSPARAM"); tcSet.NoteNo = noteSet.RecNo; tcSet.ChType = 2; tcSet.ChNo = row.No; tcSet.Name = row.Name; tcSet.Insert(Context.DB.Trans); } foreach (MeasureRow row in Context.Condition.Pressures) { tcSet.RecNo = (int)Context.DB.GetGenNo("GN_CONDITION_THERMOPRESSPARAM"); tcSet.NoteNo = noteSet.RecNo; tcSet.ChType = 3; tcSet.ChNo = row.No; tcSet.Name = row.Name; tcSet.Insert(Context.DB.Trans); } }