public bool AddOneTempMeasureRecord(TempMeasure oneTempMeaRecord) { string sql = "insert into record_tempmeasure(MeasureTask_Index,MonDev_Index,MeasureValueMin,MeasureValueAvg,MeasureValueMax,AirTemperature,Humidity,Electricty,RecordTime,TVFilePath," + "IRFilePath,VTVFilePath,IRAFilePath,VIRFilePath,TVVImgPath,IRVImgPath,IRHImgPath,Readed) " + " values(@MeasureTask_Index,@MonDev_Index,@MeasureValueMin,@MeasureValueAvg,@MeasureValueMax,@AirTemperature,@Humidity,@Electricty,@RecordTime,@TVFilePath," + "@IRFilePath,@VTVFilePath,@IRAFilePath,@VIRFilePath,@TVVImgPath,@IRVImgPath,@IRHImgPath,@Readed)"; List <MySqlParameter> parmList = new List <MySqlParameter>(); parmList.Add(new MySqlParameter("@MeasureTask_Index", oneTempMeaRecord.MeasureTask_Index)); parmList.Add(new MySqlParameter("@MonDev_Index", oneTempMeaRecord.MonDev_Index)); parmList.Add(new MySqlParameter("@MeasureValueMin", oneTempMeaRecord.MeasureValueMin)); parmList.Add(new MySqlParameter("@MeasureValueAvg", oneTempMeaRecord.MeasureValueAvg)); parmList.Add(new MySqlParameter("@MeasureValueMax", oneTempMeaRecord.MeasureValueMax)); parmList.Add(new MySqlParameter("@AirTemperature", oneTempMeaRecord.AirTemperature)); parmList.Add(new MySqlParameter("@Humidity", oneTempMeaRecord.Humidity)); parmList.Add(new MySqlParameter("@Electricty", oneTempMeaRecord.Electricty)); parmList.Add(new MySqlParameter("@RecordTime", oneTempMeaRecord.RecordTime)); parmList.Add(new MySqlParameter("@TVFilePath", oneTempMeaRecord.TVFilePath)); parmList.Add(new MySqlParameter("@IRFilePath", oneTempMeaRecord.IRFilePath)); parmList.Add(new MySqlParameter("@VTVFilePath", oneTempMeaRecord.VTVFilePath)); parmList.Add(new MySqlParameter("@IRAFilePath", oneTempMeaRecord.IRAFilePath)); parmList.Add(new MySqlParameter("@VIRFilePath", oneTempMeaRecord.VIRFilePath)); parmList.Add(new MySqlParameter("@TVVImgPath", oneTempMeaRecord.TVVImgPath)); parmList.Add(new MySqlParameter("@IRVImgPath", oneTempMeaRecord.IRVImgPath)); parmList.Add(new MySqlParameter("@IRHImgPath", oneTempMeaRecord.IRHImgPath)); parmList.Add(new MySqlParameter("@Readed", oneTempMeaRecord.Readed)); MySqlConnection conn = SqlHelper.GetConnection(ip, port, username, password, databaseName); return(SqlHelper.AddData(conn, sql, parmList.ToArray())); }
private bool AddSpotMeaTempRecords(int taskId, double temperature) { MySqlConnection conn = GlobalCtrl.GetSqlConnection(); string strSql = "insert into record_tempmeasure (MeasureTask_Index,MonDev_Index,MeasureValueMin,MeasureValueAvg,MeasureValueMax,AirTemperature,Humidity,Electricty,RecordTime," + "TVFilePath,IRFilePath,TVVImgPath,IRVImgPath,IRHImgPath,Readed) values(@MeasureTask_Index,@MonDev_Index,@MeasureValueMin,@MeasureValueAvg,@MeasureValueMax,@AirTemperature," + "@Humidity,@Electricty,@RecordTime,@TVFilePath,@IRFilePath,@TVVImgPath,@IRVImgPath,@IRHImgPath,@Readed)"; List <MySqlParameter> parameters = new List <MySqlParameter>(); parameters.Add(new MySqlParameter("@MeasureTask_Index", taskId)); parameters.Add(new MySqlParameter("@MonDev_Index", 0)); parameters.Add(new MySqlParameter("@MeasureValueMin", temperature)); parameters.Add(new MySqlParameter("@MeasureValueAvg", temperature)); parameters.Add(new MySqlParameter("@MeasureValueMax", temperature)); parameters.Add(new MySqlParameter("@AirTemperature", 0)); parameters.Add(new MySqlParameter("@Humidity", 0)); parameters.Add(new MySqlParameter("@Electricty", 0)); parameters.Add(new MySqlParameter("@RecordTime", DateTime.Now)); parameters.Add(new MySqlParameter("@TVFilePath", null)); parameters.Add(new MySqlParameter("@IRFilePath", null)); parameters.Add(new MySqlParameter("@TVVImgPath", null)); parameters.Add(new MySqlParameter("@IRVImgPath", null)); parameters.Add(new MySqlParameter("@IRHImgPath", null)); parameters.Add(new MySqlParameter("@Readed", false)); return(SqlHelper.AddData(conn, strSql, parameters.ToArray())); }
private void button1_Click(object sender, EventArgs e) { Position pos = new Position(); pos.PositionName = pos_name.Text; pos.Station_Index = Convert.ToInt32(pos_stationIndex.Value); string sql = null; List <MySqlParameter> pamList = new List <MySqlParameter>(); if (pos_cruiseType.Text.ToString().Equals("隔时巡检")) { pos.CruiseType = 0; pos.CruiseInterval = Convert.ToInt32(pos_interval.Value); sql = "insert into cruise_position(Station_Index,PositionName,CruiseInterval,CruiseType) values(@Station_Index,@PositionName,@CruiseInterval,@CruiseType)"; pamList.Add(new MySqlParameter("@Station_Index", pos.Station_Index)); pamList.Add(new MySqlParameter("@PositionName", pos.PositionName)); pamList.Add(new MySqlParameter("@CruiseInterval", pos.CruiseInterval)); pamList.Add(new MySqlParameter("@CruiseType", pos.CruiseType)); } else if (pos_cruiseType.Text.ToString().Equals("定时巡检")) { pos.CruiseType = 1; pos.StartCruiseTime = pos_cruiseStartTime.Value; sql = "insert into cruise_position(Station_Index, PositionName, StartCruiseTime, CruiseType) values(@Station_Index,@PositionName,@StartCruiseTime,@CruiseType)"; pamList.Add(new MySqlParameter("@Station_Index", pos.Station_Index)); pamList.Add(new MySqlParameter("@PositionName", pos.PositionName)); pamList.Add(new MySqlParameter("@StartCruiseTime", pos.StartCruiseTime)); pamList.Add(new MySqlParameter("@CruiseType", pos.CruiseType)); } MySqlConnection conn = GlobalCtrl.GetSqlConnection(); if (SqlHelper.AddData(conn, sql, pamList.ToArray())) { sql = "select * from cruise_position where Position_Index = (select max(Position_Index) from cruise_position)"; DataTable data = SqlHelper.QueryData(conn, sql, null); MessageBox.Show("固定点添加成功"); } else { MessageBox.Show("固定点添加失败"); } }
public bool AddOneAlarmRecord(AlarmRecord alarmRecord) { string sql = "insert into record_alarmrecord(TempMeasure_Index,Rule_Index,Rule_Type,AlarmType,AlarmRecordTime,RelMeaVal,RefPreAlarmVal,RefAlarmVal,RefSuperAlarmVal,Readed) " + "values(@TempMeasure_Index,@Rule_Index,@Rule_Type,@AlarmType,@AlarmRecordTime,@RelMeaVal,@RefPreAlarmVal,@RefAlarmVal,@RefSuperAlarmVal,@Readed)"; List <MySqlParameter> parmList = new List <MySqlParameter>(); parmList.Add(new MySqlParameter("@TempMeasure_Index", alarmRecord.TempMeasure_Index)); parmList.Add(new MySqlParameter("@Rule_Index", alarmRecord.Rule_Index)); parmList.Add(new MySqlParameter("@Rule_Type", alarmRecord.Rule_Type)); parmList.Add(new MySqlParameter("@AlarmType", alarmRecord.AlarmType)); parmList.Add(new MySqlParameter("@AlarmRecordTime", alarmRecord.AlarmRecordTime)); parmList.Add(new MySqlParameter("@RelMeaVal", alarmRecord.RelMeaVal)); parmList.Add(new MySqlParameter("@RefPreAlarmVal", alarmRecord.RefPreAlarmVal)); parmList.Add(new MySqlParameter("@RefAlarmVal", alarmRecord.RefAlarmVal)); parmList.Add(new MySqlParameter("@RefSuperAlarmVal", alarmRecord.RefSuperAlarmVal)); parmList.Add(new MySqlParameter("@Readed", alarmRecord.Readed)); MySqlConnection conn = SqlHelper.GetConnection(ip, port, username, password, databaseName); return(SqlHelper.AddData(conn, sql, parmList.ToArray())); }