private void conditionGridView_FocusedRowChanged(object sender, FocusedRowChangedEventArgs e) { if (e.FocusedRowHandle < 0) { return; } if (mode != EDataSetMode.View) { return; } db.Lock(); try { NoteParamDataSet set = db.NoteParamSet; DataRow row = conditionGridView.GetDataRow(e.FocusedRowHandle); set.Fetch(row); SetEditFromDataSet(); } finally { db.Unlock(); } }
private void searchButton_Click(object sender, EventArgs e) { if (mode != EDataSetMode.View) { return; } db.Lock(); try { NoteParamDataSet set = db.NoteParamSet; bookmark.Get(); if (string.IsNullOrWhiteSpace(makerEdit.Text) == true) { set.Select(); } else { set.Select(makerEdit.Text.Trim()); } } finally { db.Unlock(); } bookmark.Goto(); conditionGrid.Focus(); }
private void CtrlConfigCondition_Enter(object sender, EventArgs e) { db.Lock(); try { NoteParamDataSet set = db.NoteParamSet; set.Select(); } finally { db.Unlock(); } }
private void CtrlConfigCondition_Load(object sender, EventArgs e) { db.Lock(); try { NoteParamDataSet set = db.NoteParamSet; set.Select(); conditionGrid.DataSource = set.DataSet.Tables[0]; conditionGridView.Appearance.EvenRow.BackColor = Color.FromArgb(244, 244, 236); conditionGridView.OptionsView.EnableAppearanceEvenRow = true; } finally { db.Unlock(); } SetDataSetMode(EDataSetMode.View); }
public void SetEditFromDataSet() { NoteParamDataSet set = context.DB.NoteParamSet; noteCompanyEdit.Text = set.Company; noteTestNameEdit.Text = set.TestName; noteTestNoEdit.Text = set.TestNo; noteObserverEdit.Text = set.Observer; noteMakerCombo.Text = set.Maker; noteModel1Combo.Text = set.Model1; noteSerial1Combo.Text = set.Serial1; noteModel2Edit.Text = set.Model2; noteSerial2Edit.Text = set.Serial2; noteModel3Edit.Text = set.Model3; noteSerial3Edit.Text = set.Serial3; noteExpDeviceEdit.Text = set.ExpDevice; noteRefrigerantCombo.Text = set.Refrig; noteRefChargeEdit.Text = set.RefCharge; noteMemoEdit.Text = set.Memo; foreach (TabPage page in ratedTab.TabPages) { CtrlTestRated ctrl = page.Controls[0] as CtrlTestRated; RatedParamDataSet ratedSet = context.DB.RatedParamSet; ratedSet.Select(set.RecNo, ctrl.Index); if (ratedSet.GetRowCount() == 2) { ratedSet.Fetch(0); ctrl.CoolingRecNo = ratedSet.RecNo; ctrl.coolingCapacityEdit.EditValue = ratedSet.Capacity; ctrl.coolingPowerInEdit.EditValue = ratedSet.Power; ctrl.coolingEepEdit.EditValue = ratedSet.EER_COP; ctrl.coolingVoltEdit.EditValue = ratedSet.Volt; ctrl.coolingCurrentEdit.EditValue = ratedSet.Amp; ctrl.coolingFreqCombo.Text = ratedSet.Freq; ctrl.coolingPowerMeter1Combo.SelectedIndex = ratedSet.PM_IDU; ctrl.coolingPowerMeter2Combo.SelectedIndex = ratedSet.PM_ODU; ctrl.coolingPhaseCombo.SelectedValue = ratedSet.Phase; ratedSet.Fetch(1); ctrl.HeatingRecNo = ratedSet.RecNo; ctrl.heatingCapacityEdit.EditValue = ratedSet.Capacity; ctrl.heatingPowerInEdit.EditValue = ratedSet.Power; ctrl.heatingEepEdit.EditValue = ratedSet.EER_COP; ctrl.heatingVoltEdit.EditValue = ratedSet.Volt; ctrl.heatingCurrentEdit.EditValue = ratedSet.Amp; ctrl.heatingFreqCombo.Text = ratedSet.Freq; ctrl.heatingPowerMeter1Combo.SelectedIndex = ratedSet.PM_IDU; ctrl.heatingPowerMeter2Combo.SelectedIndex = ratedSet.PM_ODU; ctrl.heatingPhaseCombo.SelectedValue = ratedSet.Phase; } } methodCapaCoolingUnitCombo.SelectedValue = set.CoolUnit; methodCapaHeatingUnitCombo.SelectedValue = set.HeatUnit; ThermoPressParamDataSet thermoPressSet = context.DB.ThermoPressParamSet; thermoPressSet.Select(set.RecNo, 0); if (context.Condition.TC1.Count == thermoPressSet.GetRowCount()) { for (int i = 0; i < thermoPressSet.GetRowCount(); i++) { thermoPressSet.Fetch(i); context.Condition.TC1[i].RecNo = thermoPressSet.RecNo; context.Condition.TC1[i].Name = thermoPressSet.Name; } } thermo1GridView.RefreshData(); thermoPressSet.Select(set.RecNo, 1); if (context.Condition.TC2.Count == thermoPressSet.GetRowCount()) { for (int i = 0; i < thermoPressSet.GetRowCount(); i++) { thermoPressSet.Fetch(i); context.Condition.TC2[i].RecNo = thermoPressSet.RecNo; context.Condition.TC2[i].Name = thermoPressSet.Name; } } thermo2GridView.RefreshData(); thermoPressSet.Select(set.RecNo, 2); if (context.Condition.TC3.Count == thermoPressSet.GetRowCount()) { for (int i = 0; i < thermoPressSet.GetRowCount(); i++) { thermoPressSet.Fetch(i); context.Condition.TC3[i].RecNo = thermoPressSet.RecNo; context.Condition.TC3[i].Name = thermoPressSet.Name; } } thermo3GridView.RefreshData(); thermoPressSet.Select(set.RecNo, 3); if (context.Condition.Pressures.Count == thermoPressSet.GetRowCount()) { for (int i = 0; i < thermoPressSet.GetRowCount(); i++) { thermoPressSet.Fetch(i); context.Condition.Pressures[i].RecNo = thermoPressSet.RecNo; context.Condition.Pressures[i].Name = thermoPressSet.Name; } } pressureGridView.RefreshData(); }
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); } }
private void InsertNote() { FbTransaction trans = db.BeginTrans(); try { NoteParamDataSet noteSet = db.NoteParamSet; noteSet.RecNo = (int)db.GetGenNo("GN_CONDITION_NOTEPARAM"); noteSet.ParamNo = -1; noteSet.Company = noteCompanyEdit.Text; noteSet.TestName = noteTestNameEdit.Text; noteSet.TestNo = noteTestNoEdit.Text; noteSet.Observer = noteObserverEdit.Text; noteSet.Maker = noteMakerEdit.Text; noteSet.Model1 = noteModel1Edit.Text; noteSet.Serial1 = noteSerial1Edit.Text; noteSet.Model2 = noteModel2Edit.Text; noteSet.Serial2 = noteSerial2Edit.Text; noteSet.Model3 = noteModel3Edit.Text; noteSet.Serial3 = noteSerial3Edit.Text; noteSet.ExpDevice = noteExpDeviceEdit.Text; noteSet.Refrig = noteRefrigerantCombo.Text; noteSet.RefCharge = noteRefChargeEdit.Text; noteSet.Memo = noteMemoEdit.Text; noteSet.CoolUnit = (EUnitCapacity)methodCapaCoolingUnitCombo.SelectedValue; noteSet.HeatUnit = (EUnitCapacity)methodCapaHeatingUnitCombo.SelectedValue; noteSet.Insert(trans); RatedParamDataSet ratedSet = db.RatedParamSet; foreach (TabPage page in ratedTab.TabPages) { CtrlTestRated ctrl = page.Controls[0] as CtrlTestRated; ratedSet.RecNo = (int)db.GetGenNo("GN_CONDITION_RATEDPARAM"); ratedSet.NoteNo = noteSet.RecNo; ratedSet.PageNo = ctrl.Index; ratedSet.Mode = ETestMode.Cooling; ratedSet.Capacity = float.Parse(ctrl.coolingCapacityEdit.Text); ratedSet.Power = float.Parse(ctrl.coolingPowerInEdit.Text); ratedSet.EER_COP = float.Parse(ctrl.coolingEepEdit.Text); ratedSet.Volt = float.Parse(ctrl.coolingVoltEdit.Text); ratedSet.Amp = float.Parse(ctrl.coolingCurrentEdit.Text); ratedSet.Freq = ctrl.coolingFreqCombo.Text; ratedSet.PM_IDU = ctrl.coolingPowerMeter1Combo.SelectedIndex; ratedSet.PM_ODU = ctrl.coolingPowerMeter2Combo.SelectedIndex; ratedSet.Phase = (EWT330Wiring)ctrl.coolingPhaseCombo.SelectedValue; ratedSet.Insert(trans); ratedSet.RecNo = (int)db.GetGenNo("GN_CONDITION_RATEDPARAM"); ratedSet.NoteNo = noteSet.RecNo; ratedSet.PageNo = ctrl.Index; ratedSet.Mode = ETestMode.Heating; ratedSet.Capacity = float.Parse(ctrl.heatingCapacityEdit.Text); ratedSet.Power = float.Parse(ctrl.heatingPowerInEdit.Text); ratedSet.EER_COP = float.Parse(ctrl.heatingEepEdit.Text); ratedSet.Volt = float.Parse(ctrl.heatingVoltEdit.Text); ratedSet.Amp = float.Parse(ctrl.heatingCurrentEdit.Text); ratedSet.Freq = ctrl.heatingFreqCombo.Text; ratedSet.PM_IDU = ctrl.heatingPowerMeter1Combo.SelectedIndex; ratedSet.PM_ODU = ctrl.heatingPowerMeter2Combo.SelectedIndex; ratedSet.Phase = (EWT330Wiring)ctrl.heatingPhaseCombo.SelectedValue; ratedSet.Insert(trans); } ThermoPressParamDataSet tcSet = db.ThermoPressParamSet; foreach (MeasureRow row in id1TCs) { tcSet.RecNo = (int)db.GetGenNo("GN_CONDITION_THERMOPRESSPARAM"); tcSet.NoteNo = noteSet.RecNo; tcSet.ChType = 0; tcSet.ChNo = row.No; tcSet.Name = row.Value; tcSet.Insert(trans); } foreach (MeasureRow row in id2TCs) { tcSet.RecNo = (int)db.GetGenNo("GN_CONDITION_THERMOPRESSPARAM"); tcSet.NoteNo = noteSet.RecNo; tcSet.ChType = 1; tcSet.ChNo = row.No; tcSet.Name = row.Value; tcSet.Insert(trans); } foreach (MeasureRow row in odTCs) { tcSet.RecNo = (int)db.GetGenNo("GN_CONDITION_THERMOPRESSPARAM"); tcSet.NoteNo = noteSet.RecNo; tcSet.ChType = 2; tcSet.ChNo = row.No; tcSet.Name = row.Value; tcSet.Insert(trans); } foreach (MeasureRow row in presses) { tcSet.RecNo = (int)db.GetGenNo("GN_CONDITION_THERMOPRESSPARAM"); tcSet.NoteNo = noteSet.RecNo; tcSet.ChType = 3; tcSet.ChNo = row.No; tcSet.Name = row.Value; tcSet.Insert(trans); } db.CommitTrans(); } catch (Exception e) { Resource.TLog.Log((int)ELogItem.Exception, e.ToString()); db.RollbackTrans(); } }