public static int Insert(Database db, AlarmIconInfo alarmIconInfo) { StringBuilder sbField = new StringBuilder(); StringBuilder sbValue = new StringBuilder(); sbField.Append("INSERT INTO AlarmIconInfo("); sbValue.Append("values("); sbField.Append("AlarmId"); sbValue.AppendFormat("{0}", alarmIconInfo.AlarmId); sbField.Append(",IconIndex"); sbValue.AppendFormat(",{0}", alarmIconInfo.IconIndex); sbField.Append(",ToolTip"); sbValue.AppendFormat(",'{0}'", alarmIconInfo.ToolTip); sbField.Append(",X"); sbValue.AppendFormat(",{0}", alarmIconInfo.X); sbField.Append(",Y"); sbValue.AppendFormat(",{0}", alarmIconInfo.Y); sbField.Append(",Map"); sbValue.AppendFormat(",{0}", alarmIconInfo.Map); sbField.Append(",MatchCameraId)"); sbValue.AppendFormat(",{0})", alarmIconInfo.MatchCameraId); string cmdText = sbField + " " + sbValue; try { return db.ExecuteNonQuery(CommandType.Text, cmdText); } catch (Exception ex) { throw ex; } }
public static int Update(Database db, AlarmIconInfo alarmIconInfo) { StringBuilder sb = new StringBuilder(); sb.Append("update AlarmIconInfo set"); sb.AppendFormat(" IconIndex={0}", alarmIconInfo.IconIndex); sb.AppendFormat(",ToolTip='{0}'", alarmIconInfo.ToolTip); sb.AppendFormat(",X={0}", alarmIconInfo.X); sb.AppendFormat(",Y={0} ", alarmIconInfo.Y); sb.AppendFormat(",MatchCameraId={0} ", alarmIconInfo.MatchCameraId); sb.AppendFormat(",Map={0} ", alarmIconInfo.Map); sb.AppendFormat(" where AlarmId={0}", alarmIconInfo.AlarmId); string cmdText = sb.ToString(); try { return db.ExecuteNonQuery(CommandType.Text, cmdText); } catch (Exception ex) { throw ex; } }