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