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