private void btnPataModifyOK_Click(object sender, EventArgs e) { try { if (WUseToolClass.isObjectNull(dgvPataModify.Rows[0].Cells[0].Value, "组名")) { return; } if (WUseToolClass.isObjectNull(dgvPataModify.Rows[0].Cells[1].Value, "参数名称")) { return; } if (WUseToolClass.isObjectNull(dgvPataModify.Rows[0].Cells[2].Value, "参数值")) { return; } string GroupName = dgvPataModify.Rows[0].Cells[0].Value.ToString(); string Name = dgvPataModify.Rows[0].Cells[1].Value.ToString(); double Value = 0.0; try { Value = double.Parse(dgvPataModify.Rows[0].Cells[2].Value.ToString()); } catch (Exception) { MessageBox.Show("参数的值输入类型错误,只能是数值"); return; } string CorrAxis = ""; if (dgvPataModify.Rows[0].Cells[3].Value != null) { CorrAxis = WUseToolClass.getCorrAxisID(dtCorrAxis, dgvPataModify.Rows[0].Cells[3].Value.ToString()); } string Remarks = ""; if (dgvPataModify.Rows[0].Cells[4].Value != null) { Remarks = dgvPataModify.Rows[0].Cells[4].Value.ToString(); } int mIndex = dgvParameter.CurrentRow.Index; string oldGroupName = dgvParameter.Rows[mIndex].Cells[0].Value.ToString(); string oldName = dgvParameter.Rows[mIndex].Cells[1].Value.ToString(); string oldCorrAxis = ""; if (dgvParameter.Rows[mIndex].Cells[3].Value != null) { oldCorrAxis = WUseToolClass.getCorrAxisID(dtCorrAxis, dgvParameter.Rows[mIndex].Cells[3].Value.ToString()); } string oldRemarks = ""; if (dgvParameter.Rows[mIndex].Cells[4].Value != null) { oldRemarks = dgvParameter.Rows[mIndex].Cells[4].Value.ToString(); } if (Name != oldName && mWDataToolClass.SelectShowParameterName(Name) == 1) { MessageBox.Show("参数名称:" + Name + ";已存在,请检查"); return; } bool isUpdateName = true;//是否更新组名和参数名称,true更新false不更新 if (oldGroupName == GroupName && oldName == Name && oldCorrAxis == CorrAxis && oldRemarks == Remarks) { isUpdateName = false; } if (mWDataToolClass.UpdateParameter(isUpdateName, oldName, GroupName, Name, Value, CorrAxis, Remarks) != 0) { MessageBox.Show("参数数据更改失败"); return; } closePanelUI(); //刷新参数数据 mWDataToolClass.SelectShowParameter(ref dgvParameter); dgvPataModify.Rows.Clear(); MessageBox.Show("参数数据更改成功"); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void btnPataAddOK_Click(object sender, EventArgs e) { string GroupName = ""; string Name = ""; double Value = 0.0; string CorrAxis = ""; string Remarks = ""; try { if (dgvPataAdd.Rows.Count > 0) { //检查数据 for (int i = 0; i < dgvPataAdd.Rows.Count - 1; i++) { //检查数据是否为空 if (WUseToolClass.isObjectNull(dgvPataAdd.Rows[i].Cells[0].Value, "第" + (i + 1).ToString() + "行的组名")) { return; } if (WUseToolClass.isObjectNull(dgvPataAdd.Rows[i].Cells[1].Value, "第" + (i + 1).ToString() + "行的参数名称")) { return; } if (WUseToolClass.isObjectNull(dgvPataAdd.Rows[i].Cells[2].Value, "第" + (i + 1).ToString() + "行的参数值")) { return; } //检查是否已经存在重复数据 Name = dgvPataAdd.Rows[i].Cells[1].Value.ToString(); if (mWDataToolClass.SelectShowParameterName(Name) == 1) { MessageBox.Show("第" + (i + 1).ToString() + "行的参数名称:" + Name + ";已存在,请检查"); return; } //增加的数据判断 int numRepeatName = 0; for (int j = 0; j < dgvPataAdd.Rows.Count - 1; j++) { if (i != j) { if (Name == dgvPataAdd.Rows[j].Cells[1].Value.ToString()) { numRepeatName++; } } } if (numRepeatName > 0) { MessageBox.Show("第" + (i + 1).ToString() + "行的参数名称有重复,请检查"); return; } } //把所有数据插入 for (int i = 0; i < dgvPataAdd.Rows.Count - 1; i++) { GroupName = dgvPataAdd.Rows[i].Cells[0].Value.ToString(); Name = dgvPataAdd.Rows[i].Cells[1].Value.ToString(); Value = double.Parse(dgvPataAdd.Rows[i].Cells[2].Value.ToString()); if (dgvPataAdd.Rows[i].Cells[3].Value != null) { CorrAxis = WUseToolClass.getCorrAxisID(dtCorrAxis, dgvPataAdd.Rows[i].Cells[3].Value.ToString()); } else { CorrAxis = ""; } if (dgvPataAdd.Rows[i].Cells[4].Value != null) { Remarks = dgvPataAdd.Rows[i].Cells[4].Value.ToString(); } else { Remarks = ""; } if (mWDataToolClass.InsertParameter(GroupName, Name, Value, CorrAxis, Remarks) != 0) { MessageBox.Show("第" + (i + 1).ToString() + "行的数据添加失败"); return; } } closePanelUI(); //刷新轴数据 mWDataToolClass.SelectShowParameter(ref dgvParameter); dgvPataAdd.Rows.Clear(); MessageBox.Show("轴数据添加成功"); } else { MessageBox.Show("添加的数据为空"); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }