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 btnDOModifyOk_Click(object sender, EventArgs e)
{
//获取修改的数据
String GroupName = dgvDOModify.Rows[0].Cells[0].Value.ToString();
String Name = dgvDOModify.Rows[0].Cells[1].Value.ToString();
Int32 CardNum = int.Parse(dgvDOModify.Rows[0].Cells[2].Value.ToString());
Int32 IoID = int.Parse(dgvDOModify.Rows[0].Cells[3].Value.ToString());
String mIoType = dgvDOModify.Rows[0].Cells[4].Value.ToString();
Int32 IoType = WUseToolClass.getIoType(dgvDOModify.Rows[0].Cells[4].Value.ToString());
String mIoState = dgvDOModify.Rows[0].Cells[5].Value.ToString();
Int32 IoState = WUseToolClass.getIoState(dgvDOModify.Rows[0].Cells[5].Value.ToString());
Int32 ExtendNum = int.Parse(dgvDOModify.Rows[0].Cells[6].Value.ToString());
try
{
int isModifyNum = 0;
int mIndex = dgvDO.CurrentRow.Index;
String oldName = dgvDO.Rows[mIndex].Cells[1].Value.ToString();
if (Name != oldName)
{
if (mWDataToolClass.SelectShowDOCheck(" Name=" + Name) == 1)
{
MessageBox.Show("端口名称已存在，请检查");
return;
}
}
else
{
isModifyNum++;
}
if (IoType == 1023)
{
if (CardNum == int.Parse(dgvDO.Rows[mIndex].Cells[2].Value.ToString()) &&
IoID == int.Parse(dgvDO.Rows[mIndex].Cells[3].Value.ToString()) &&
mIoType == dgvDO.Rows[mIndex].Cells[4].Value.ToString() &&
ExtendNum == int.Parse(dgvDO.Rows[mIndex].Cells[6].Value.ToString()))
{
isModifyNum++;
}
else
{
if (mWDataToolClass.SelectShowDOCheck(
" CardNum=" + CardNum.ToString() +
" and IoID=" + IoID.ToString() +
" and IoType=" + IoType.ToString() +
" and ExtendNum=" + ExtendNum.ToString()
) == 1)
{
MessageBox.Show("卡号、端口号、端口类型和扩展卡号已存在，请检查");
return;
}
}
}
else
{
if (CardNum == int.Parse(dgvDO.Rows[mIndex].Cells[2].Value.ToString()) &&
IoID == int.Parse(dgvDO.Rows[mIndex].Cells[3].Value.ToString()) &&
mIoType == dgvDO.Rows[mIndex].Cells[4].Value.ToString())
{
isModifyNum++;
}
else
{
if (mWDataToolClass.SelectShowDOCheck(
" CardNum=" + CardNum.ToString() +
" and IoID=" + IoID.ToString() +
" and IoType=" + IoType.ToString()
) == 1)
{
MessageBox.Show("卡号、端口号和端口类型已存在，请检查");
return;
}
}
}
if (GroupName == dgvDO.Rows[mIndex].Cells[0].Value.ToString() &&
mIoState == dgvDO.Rows[mIndex].Cells[5].Value.ToString())
{
isModifyNum++;
}
if (isModifyNum == 3)
{
MessageBox.Show("当前数据未有改动");
return;
}
if (mWDataToolClass.UpdateDO(oldName, GroupName, Name, CardNum, IoID, IoType, IoState, ExtendNum) != 0)
{
MessageBox.Show("轴数据修改失败");
return;
}
//刷新轴数据
mWDataToolClass.SelectShowDO(ref dgvDO);
dgvDOModify.Rows.Clear();
closePanelUI();
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());
}
}
private void btnDOAddOk_Click(object sender, EventArgs e)
{
String GroupName = "";
String Name = "";
Int32 CardNum = 0;
Int32 IoID = 0;
String mIoType = "";
Int32 IoType = 0;
String mIoState = "";
Int32 IoState = 0;
Int32 ExtendNum = 0;
try
{
if (dgvDOAdd.Rows.Count > 0)
{
//检查数据
for (int i = 0; i < dgvDOAdd.Rows.Count - 1; i++)
{
//检查数据是否为空
if (dgvDOAdd.Rows[i].Cells[0].Value == null)
{
MessageBox.Show("第" + (i + 1).ToString() + "行的组名为空，请检查");
return;
}
if (dgvDOAdd.Rows[i].Cells[1].Value == null)
{
MessageBox.Show("第" + (i + 1).ToString() + "行的端口名称为空，请检查");
return;
}
if (dgvDOAdd.Rows[i].Cells[2].Value == null)
{
MessageBox.Show("第" + (i + 1).ToString() + "行的卡号未选择，请检查");
return;
}
if (dgvDOAdd.Rows[i].Cells[3].Value == null)
{
MessageBox.Show("第" + (i + 1).ToString() + "行的端口号未选择，请检查");
return;
}
if (dgvDOAdd.Rows[i].Cells[4].Value == null)
{
MessageBox.Show("第" + (i + 1).ToString() + "行的端口类型选择，请检查");
return;
}
if (dgvDOAdd.Rows[i].Cells[5].Value == null)
{
MessageBox.Show("第" + (i + 1).ToString() + "行的端口状态选择，请检查");
return;
}
if (dgvDOAdd.Rows[i].Cells[4].Value.ToString() == "扩展" &&
dgvDOAdd.Rows[i].Cells[6].Value == null)
{
MessageBox.Show("第" + (i + 1).ToString() + "行的扩展卡号选择，请检查");
return;
}
//检查是否已经存在重复数据
Name = dgvDOAdd.Rows[i].Cells[1].Value.ToString();
CardNum = int.Parse(dgvDOAdd.Rows[i].Cells[2].Value.ToString());
IoID = int.Parse(dgvDOAdd.Rows[i].Cells[3].Value.ToString());
mIoType = dgvDOAdd.Rows[i].Cells[4].Value.ToString();
if (dgvDOAdd.Rows[i].Cells[6].Value == null)
{
ExtendNum = 0;
}
else
{
ExtendNum = int.Parse(dgvDOAdd.Rows[i].Cells[6].Value.ToString());
}
if (mWDataToolClass.SelectShowDOCheck(" Name='" + Name + "'") == 1)
{
MessageBox.Show("第" + (i + 1).ToString() + "行的轴名称:" + Name + "；已存在，请检查");
return;
}
if (mIoType == "扩展")
{
IoType = WUseToolClass.getIoType(mIoType);
if (mWDataToolClass.SelectShowDOCheck(
" CardNum=" + CardNum.ToString() +
" and IoID=" + IoID.ToString() +
" and IoType=" + IoType.ToString() +
" and ExtendNum=" + ExtendNum.ToString()
) == 1)
{
MessageBox.Show("第" + (i + 1).ToString() + "行的卡号、端口号、端口类型和扩展卡号已存在，请检查");
return;
}
}
else
{
IoType = WUseToolClass.getIoType(mIoType);
if (mWDataToolClass.SelectShowDOCheck(
" CardNum=" + CardNum.ToString() +
" and IoID=" + IoID.ToString() +
" and IoType=" + IoType.ToString()
) == 1)
{
MessageBox.Show("第" + (i + 1).ToString() + "行的卡号、端口号和端口类型已存在，请检查");
return;
}
}
//增加的数据判断
int numRepeatName = 0;
int numRepeatCA = 0;
for (int j = 0; j < dgvDOAdd.Rows.Count - 1; j++)
{
if (i != j)
{
if (Name == dgvDOAdd.Rows[j].Cells[0].Value.ToString())
{
numRepeatName++;
}
if (mIoType == "扩展")
{
if (CardNum == int.Parse(dgvDOAdd.Rows[j].Cells[2].Value.ToString()) &&
IoID == int.Parse(dgvDOAdd.Rows[j].Cells[3].Value.ToString()) &&
IoType == int.Parse(dgvDOAdd.Rows[j].Cells[4].Value.ToString()) &&
ExtendNum == int.Parse(dgvDOAdd.Rows[j].Cells[6].Value.ToString()))
{
numRepeatCA++;
}
}
else
{
if (CardNum == int.Parse(dgvDOAdd.Rows[j].Cells[2].Value.ToString()) &&
IoID == int.Parse(dgvDOAdd.Rows[j].Cells[3].Value.ToString()) &&
IoType == int.Parse(dgvDOAdd.Rows[j].Cells[4].Value.ToString()))
{
numRepeatCA++;
}
}
}
}
if (numRepeatName > 0)
{
MessageBox.Show("第" + (i + 1).ToString() + "行的轴名称有重复，请检查");
return;
}
if (numRepeatCA > 0)
{
MessageBox.Show("第" + (i + 1).ToString() + "行的卡号、端口号和端口类型（扩展卡号）有重复，请检查");
return;
}
}
//把所有数据插入
for (int i = 0; i < dgvDOAdd.Rows.Count - 1; i++)
{
GroupName = dgvDOAdd.Rows[i].Cells[0].Value.ToString();
Name = dgvDOAdd.Rows[i].Cells[1].Value.ToString();
CardNum = int.Parse(dgvDOAdd.Rows[i].Cells[2].Value.ToString());
IoID = int.Parse(dgvDOAdd.Rows[i].Cells[3].Value.ToString());
mIoType = dgvDOAdd.Rows[i].Cells[4].Value.ToString();
mIoState = dgvDOAdd.Rows[i].Cells[5].Value.ToString();
if (dgvDOAdd.Rows[i].Cells[6].Value == null)
{
ExtendNum = 0;
}
else
{
ExtendNum = int.Parse(dgvDOAdd.Rows[i].Cells[6].Value.ToString());
}
IoType = WUseToolClass.getIoType(mIoType);
IoState = WUseToolClass.getIoState(mIoState);
if (mWDataToolClass.InsertDO(GroupName, Name, CardNum, IoID, IoType, IoState, ExtendNum) != 0)
{
MessageBox.Show("第" + (i + 1).ToString() + "行的数据添加失败");
return;
}
}
closePanelUI();
//刷新轴数据
mWDataToolClass.SelectShowDO(ref dgvDO);
dgvDOAdd.Rows.Clear();
MessageBox.Show("轴数据添加成功");
}
else
{
MessageBox.Show("添加的数据为空");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
