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