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