/// <summary> /// 彻底删除一条记录,一旦删除无法恢复,建议不要使用此功能 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnDelete_Click(object sender, EventArgs e) { try { Log.Info(GetType() + "->" + ApplicationCommon.GetMethodName() + "---START"); //删除前判断 DialogResult dialogResult = XtraMessageBox.Show("此操作将永久删除数据并有可能导致其他关联数据出错,是否继续?", "选择", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dialogResult == DialogResult.No) { return; } //检查必填字段 bool isAllOk = CheckNotNullField(); if (!isAllOk) { return; } //准备要存储的数据 ModelDEV_SUBORDINATE_INFO modelDevSubordinateInfo = PrepareModelSubordinateInfo(); //判断是否有关系 bool hasRelation = _bllDevSubordinateInfo.HasRelation(modelDevSubordinateInfo.F_SUBORDINATE_ID); if (hasRelation) { XtraMessageBox.Show("此设备有和其他设备的关系,不能删除。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } //更新数据 bool status = _bllDevSubordinateInfo.Drop(modelDevSubordinateInfo.F_SUBORDINATE_ID); //获得当前rowhandle int rowhandle = gvList.FocusedRowHandle; //绑定数据 BindGridview(); //设置焦点行 gvList.FocusedRowHandle = rowhandle; if (status) { XtraMessageBox.Show("此数据已删除。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { XtraMessageBox.Show("没有数据被更新。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } catch (Exception ex) { Log.Error(GetType() + "->" + ApplicationCommon.GetMethodName() + "---FAILED", ex); throw ex; } }
/// <summary> /// 准备要操作Model /// </summary> /// <returns></returns> private ModelDEV_SUBORDINATE_INFO PrepareModelSubordinateInfo() { try { Log.Info(GetType() + "->" + ApplicationCommon.GetMethodName() + "---START"); ModelDEV_SUBORDINATE_INFO modelDevSubordinateInfo = new ModelDEV_SUBORDINATE_INFO(); // 下位机编号 modelDevSubordinateInfo.F_SUBORDINATE_ID = txtF_SUBORDINATE_ID.Text; // 下位机名称 modelDevSubordinateInfo.F_SUBORDINATE_NAME = txtF_SUBORDINATE_NAME.Text; //校准编号 modelDevSubordinateInfo.F_SUBORDINATE_CALIBRATION = txtF_SUBORDINATE_CALIBRATION.Text; //端口 modelDevSubordinateInfo.F_COM_ADDRESS = txtF_COM_ADDRESS.Text.ToUpper(); //通信地址 decimal subordinateAddress; decimal.TryParse(txtF_SUBORDINATE_ADDRESS.Text, out subordinateAddress); //通信地址 modelDevSubordinateInfo.F_SUBORDINATE_ADDRESS = subordinateAddress; // 下位机状态 modelDevSubordinateInfo.F_SUBORDINATE_STATUS = decimal.Parse(lueF_SUBORDINATE_STATUS.EditValue.ToString()); // 备注 modelDevSubordinateInfo.F_SUBORDINATE_MEMO = txtF_SUBORDINATE_MEMO.Text; //创建时间 DateTime optDateTime = DateTime.Now; modelDevSubordinateInfo.F_CREATE_TIME = optDateTime; //操作员 modelDevSubordinateInfo.F_OPERATOR_ID = AppGlobal.GUserId; //操作时间 modelDevSubordinateInfo.F_OPERATIONTIME = optDateTime; //是否删除 modelDevSubordinateInfo.F_DEL = 0; return(modelDevSubordinateInfo); } catch (Exception ex) { Log.Error(GetType() + "->" + ApplicationCommon.GetMethodName() + "---FAILED", ex); throw ex; } }
/// <summary> /// 启动其中的一条记录 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnEnabled_Click(object sender, EventArgs e) { try { Log.Info(GetType() + "->" + ApplicationCommon.GetMethodName() + "---START"); //检查必填字段 bool isAllOk = CheckNotNullField(); if (!isAllOk) { return; } //准备要存储的数据 ModelDEV_SUBORDINATE_INFO modelDevSubordinateInfo = PrepareModelSubordinateInfo(); //更新数据 bool status = _bllDevSubordinateInfo.Enabled(modelDevSubordinateInfo.F_SUBORDINATE_ID); //获得当前rowhandle int rowhandle = gvList.FocusedRowHandle; //绑定数据 BindGridview(); //设置焦点行 gvList.FocusedRowHandle = rowhandle; if (status) { XtraMessageBox.Show("此数据已启用。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); //刷新数据 gvList_RowClick(this, null); } else { XtraMessageBox.Show("没有数据被更新。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } catch (Exception ex) { Log.Error(GetType() + "->" + ApplicationCommon.GetMethodName() + "---FAILED", ex); throw ex; } }
/// <summary> /// 表格点击,将其中数据显示在下面 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void gvList_RowClick(object sender, DevExpress.XtraGrid.Views.Grid.RowClickEventArgs e) { try { Log.Info(GetType() + "->" + ApplicationCommon.GetMethodName() + "---START"); if (gvList.FocusedRowHandle < 0) { return; } string subordinateId = gvList.GetFocusedRowCellValue("F_SUBORDINATE_ID").ToString(); ModelDEV_SUBORDINATE_INFO modelDevSubordinateInfo = _bllDevSubordinateInfo.GetModel(subordinateId); //下位机编号 txtF_SUBORDINATE_ID.Text = modelDevSubordinateInfo.F_SUBORDINATE_ID; //下位机名称 txtF_SUBORDINATE_NAME.Text = modelDevSubordinateInfo.F_SUBORDINATE_NAME; //校准编号 txtF_SUBORDINATE_CALIBRATION.Text = modelDevSubordinateInfo.F_SUBORDINATE_CALIBRATION; //所在负载柜编号 txtF_COM_ADDRESS.Text = modelDevSubordinateInfo.F_COM_ADDRESS; //上位机信息 txtF_SUBORDINATE_ADDRESS.Text = modelDevSubordinateInfo.F_SUBORDINATE_ADDRESS.ToString(); //工作状态 lueF_SUBORDINATE_STATUS.EditValue = modelDevSubordinateInfo.F_SUBORDINATE_STATUS; //备注 txtF_SUBORDINATE_MEMO.Text = modelDevSubordinateInfo.F_SUBORDINATE_MEMO; //禁用状态 rdoF_DEL.EditValue = modelDevSubordinateInfo.F_DEL; } catch (Exception ex) { Log.Error(GetType() + "->" + ApplicationCommon.GetMethodName() + "---FAILED", ex); throw ex; } }
/// <summary> /// 更新信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSave_Click(object sender, EventArgs e) { try { Log.Info(GetType() + "->" + ApplicationCommon.GetMethodName() + "---START"); //检查必填字段 bool isAllOk = CheckNotNullField(); if (!isAllOk) { return; } //准备要存储的数据 ModelDEV_SUBORDINATE_INFO modelDevSubordinateInfo = PrepareModelSubordinateInfo(); //判断此数据是否已经存在 bool isDataExist = _bllDevSubordinateInfo.Exists(modelDevSubordinateInfo.F_SUBORDINATE_ID); if (isDataExist) { //已经存在判断是否更新 DialogResult dialogResult = XtraMessageBox.Show("当前数据已存在,是否更新?", "选择", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dialogResult == DialogResult.No) { return; } //更新数据 bool status = _bllDevSubordinateInfo.Update(modelDevSubordinateInfo); //获得当前rowhandle int rowhandle = gvList.FocusedRowHandle; //绑定数据 BindGridview(); //设置焦点行 gvList.FocusedRowHandle = rowhandle; if (status) { XtraMessageBox.Show("此数据已更新。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { XtraMessageBox.Show("没有数据被更新,操作中断。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { _bllDevSubordinateInfo.Add(modelDevSubordinateInfo); //获得当前rowhandle int rowhandle = gvList.FocusedRowHandle; //绑定数据 BindGridview(); //设置焦点行 gvList.FocusedRowHandle = rowhandle + 1; XtraMessageBox.Show("此数据已增加。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { Log.Error(GetType() + "->" + ApplicationCommon.GetMethodName() + "---FAILED", ex); throw ex; } }