public bool Insert(TerminalConfigEntity entity) { try { string SQL_Config = @"INSERT INTO PreTerConfig(TerminalID,PreUpperLimit,PreLowLimit,PreSlopeUpLimit,PreSlopeLowLimit,EnablePreAlarm,EnableSlopeAlarm) VALUES( @TerminalID,@PreUpperLimit,@PreLowLimit,@PreSlopeUpLimit,@PreSlopeLowLimit,@EnablePreAlarm,@EnableSlopeAlarm)"; SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@TerminalID", DbType.Int32), new SqlParameter("@PreUpperLimit", DbType.Decimal), new SqlParameter("@PreLowLimit", DbType.Single), new SqlParameter("@PreSlopeUpLimit", DbType.Single), new SqlParameter("@PreSlopeLowLimit", DbType.Single), new SqlParameter("@EnablePreAlarm", DbType.Int32), new SqlParameter("@EnableSlopeAlarm", DbType.Int32), }; parms[0].Value = entity.TerminalID; parms[1].Value = entity.PreUpLimit; parms[2].Value = entity.PreLowLimit; parms[3].Value = entity.PreSlopeUpLimit; parms[4].Value = entity.PreSlopeLowLimit; parms[5].Value = entity.EnablePreAlarm ? 1 : 0; parms[6].Value = entity.EnableSlopeAlarm ? 1 : 0; SQLHelper.ExecuteNonQuery(SQL_Config, parms); terDal.SaveTerInfo(entity.TerminalID, entity.TerminalName, entity.TerminalAddr, entity.Remark, TerType.PreTer, null, false); return(true); } catch (Exception ex) { throw ex; } }
private TerminalConfigEntity GetEntity() { TerminalConfigEntity entity = new TerminalConfigEntity(); entity.TerminalID = Convert.ToInt32(txtTerminalID.Text.Trim()); entity.TerminalName = txtTerminalName.Text.Trim(); entity.TerminalAddr = txtAddress.Text.Trim(); entity.Remark = txtRemark.Text; entity.EnablePreAlarm = cboxPreAlarm.Checked; entity.EnableSlopeAlarm = cboxSlopeAlarm.Checked; if (cboxPreAlarm.Checked) { entity.PreLowLimit = Convert.ToDecimal(txtPreLowLimit.Text); entity.PreUpLimit = Convert.ToDecimal(txtPreUpLimite.Text); } else { entity.PreLowLimit = 0; entity.PreUpLimit = 0; } if (cboxSlopeAlarm.Checked) { entity.PreSlopeLowLimit = Convert.ToDecimal(txtSlopeLowLimit.Text); entity.PreSlopeUpLimit = Convert.ToDecimal(txtSlopeUpLimit.Text); } else { entity.PreSlopeLowLimit = 0; entity.PreSlopeUpLimit = 0; } return(entity); }
public bool Modify(TerminalConfigEntity entity) { if (DeletePreTer(entity.TerminalID.ToString())) { Insert(entity); } return(true); }
/// <summary> /// 修改一条记录(根据终端编号) /// </summary> public bool Modify(TerminalConfigEntity entity) { try { return(dal.Modify(entity)); } catch (Exception ex) { return(false); logger.ErrorException("Modify", ex); } }
/// <summary> /// 插入一条记录 /// </summary> public bool Insert(TerminalConfigEntity entity) { try { return(dal.Insert(entity)); } catch (Exception ex) { return(false); logger.ErrorException("Insert", ex); } }
public List <TerminalConfigEntity> GetAllPreTerminals() { lock (ConstValue.obj) { string SQL = @"SELECT DISTINCT Ter.TerminalID,Ter.TerminalName,Ter.[Address],Ter.Remark,PreUpperLimit,PreLowLimit,PreSlopeUpLimit,PreSlopeLowLimit,EnablePreAlarm,EnableSlopeAlarm FROM Terminal Ter, [PreTerConfig] Config WHERE Ter.TerminalID=Config.TerminalID AND Ter.TerminalType='" + (int)TerType.PreTer + "' ORDER BY TerminalName"; using (SqlDataReader reader = SQLHelper.ExecuteReader(SQL, null)) { List <TerminalConfigEntity> lstConfig = new List <TerminalConfigEntity>(); while (reader.Read()) { TerminalConfigEntity entity = new TerminalConfigEntity(); entity.TerminalID = reader["TerminalID"] != DBNull.Value ? Convert.ToInt32(reader["TerminalID"]) : 0; entity.TerminalName = reader["TerminalName"] != DBNull.Value ? reader["TerminalName"].ToString() : ""; entity.TerminalAddr = reader["Address"] != DBNull.Value ? reader["Address"].ToString() : ""; entity.Remark = reader["Remark"] != DBNull.Value ? reader["Remark"].ToString() : ""; entity.EnablePreAlarm = reader["EnablePreAlarm"] != DBNull.Value ? (Convert.ToInt32(reader["EnablePreAlarm"]) == 1 ? true : false) : true; entity.EnableSlopeAlarm = reader["EnableSlopeAlarm"] != DBNull.Value ? (Convert.ToInt32(reader["EnableSlopeAlarm"]) == 1 ? true : false) : true; if (entity.EnablePreAlarm) { entity.PreLowLimit = reader["PreLowLimit"] != DBNull.Value ? Convert.ToDecimal(reader["PreLowLimit"]) : 0; entity.PreUpLimit = reader["PreUpperLimit"] != DBNull.Value ? Convert.ToDecimal(reader["PreUpperLimit"]) : 0; } if (entity.EnableSlopeAlarm) { entity.PreSlopeLowLimit = reader["PreSlopeLowLimit"] != DBNull.Value ? Convert.ToDecimal(reader["PreSlopeLowLimit"]) : 0; entity.PreSlopeUpLimit = reader["PreSlopeUpLimit"] != DBNull.Value ? Convert.ToDecimal(reader["PreSlopeUpLimit"]) : 0; } lstConfig.Add(entity); } return(lstConfig); } return(null); } }
private void btnAdd_Click(object sender, EventArgs e) { if (Validate()) { TerminalConfigEntity entity = null; if (configBLL.IsExist(txtTerminalID.Text.Trim())) { if (DialogResult.Yes == XtraMessageBox.Show("终端编号[" + txtTerminalID.Text + "]已经存在,是否更新?", "系统提示", MessageBoxButtons.YesNo, MessageBoxIcon.Asterisk)) { entity = GetEntity(); if (configBLL.Modify(entity)) { XtraMessageBox.Show("更新成功!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information); MonitorView = (PreTerMonitor)GlobalValue.MainForm.GetView(typeof(PreTerMonitor)); if (MonitorView != null) { MonitorView.ShowTerList(false, true); MonitorView.ShowTerData(); } ClearConfigControls(); GetConfigFromDB(); } else { XtraMessageBox.Show("更新失败!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { return; } } else { if (DialogResult.Yes == XtraMessageBox.Show("是否新增终端编号[" + txtTerminalID.Text + "]?", "系统提示", MessageBoxButtons.YesNo, MessageBoxIcon.Asterisk)) { entity = GetEntity(); if (configBLL.Insert(entity)) { XtraMessageBox.Show("新增成功!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information); MonitorView = (PreTerMonitor)GlobalValue.MainForm.GetView(typeof(PreTerMonitor)); if (MonitorView != null) { MonitorView.ShowTerList(false, true); MonitorView.ShowTerData(); } ClearConfigControls(); GetConfigFromDB(); } else { XtraMessageBox.Show("新增失败!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { return; } } } }