private void steeveforce_Load(object sender, EventArgs e) { this.initial(); try { dt = OperateSql.LoadData(sql, dgv); dt.TableName = "吊杆力记录表"; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void FrontPivotRecord_Load(object sender, EventArgs e) { this.initial(); try { dt = OperateSql.LoadData(sql, dgv); dt.TableName = "前支点数据记录表"; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void steevedisplacement_Load(object sender, EventArgs e) { this.initial(); sql = "select * from SteeveDisplacement"; try { dt = OperateSql.LoadData(sql, dgv);//加载数据 dt.TableName = "吊杆位移记录表"; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void warn_Load(object sender, EventArgs e) { this.initial(); string sql = "select * from AlarmRecord"; try { dt = OperateSql.LoadData(sql, dgv); dt.TableName = "报警记录"; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// 若表为空,则第一次读基准存入数据库,否则从吊杆位移基准数据表中读取基准,赋予standardlist。 /// </summary> public void ReadStandardValue() { // List<double> disList = new List<double>(); standardlist = new List <double>(); string sql = "select * from SteeveStandard"; try { if (OperateSql.IsTableNull(sql)) { Sensor sensor = new Sensor(SensorType.displaceSensor, 4, 20, 29.8, 100, 20); for (int i = 0; i < 4; i++) { sensor.readValue = double.Parse(adamList[0].Read(i)); //???位移加+4?? standardlist.Add(sensor.GetRealValue()); //每个吊杆的基准值 //disList.Add(sensor.GetRealValue()); } string sqlstr = string.Format("insert into SteeveStandard values({0},{1},{2},{3})", standardlist[0], standardlist[1], standardlist[2], standardlist[3]); int r = dbhelper.ExecuteNonQuery(sqlstr);//空表插入基准值 } else { //否则读取数据库中基准值 DataTable dt = OperateSql.ReadStandard(sql); for (int i = 0; i < 4; i++) { standardlist.Add(double.Parse(dt.Rows[0][i].ToString())); } } } catch (Exception e) { throw e; } double sum = 0; foreach (double val in standardlist) { sum += val; } //平均值作基准值 steeveDisStandard = Math.Round(sum / 4, 3); }
/// <summary> /// 读前支点位移基准。。拉绳式传感器。1.2m量程。 /// </summary> public void ReadFrontStandard() { //前支点基准值 string sql = "select * from FrontStandard"; try { if (OperateSql.IsTableNull(sql)) { Sensor sensor1 = new Sensor(SensorType.displaceSensor, 4, 20, 1.2, 1000, 0); sensor1.readValue = double.Parse(adamList[1].Read(0)); first_frontPivotDisStandard = sensor1.GetRealValue(); Sensor sensor2 = new Sensor(SensorType.displaceSensor, 4, 20, 1.2, 1000, 0); sensor2.readValue = double.Parse(adamList[1].Read(1)); second_frontPivotDisStandard = sensor2.GetRealValue(); Sensor sensor3 = new Sensor(SensorType.displaceSensor, 4, 20, 1.2, 1000, 0); sensor3.readValue = double.Parse(adamList[1].Read(2)); three_standard = sensor3.GetRealValue(); Sensor sensor4 = new Sensor(SensorType.displaceSensor, 4, 20, 1.2, 1000, 0); sensor4.readValue = double.Parse(adamList[1].Read(3)); four_standard = sensor4.GetRealValue(); string sqlstr = string.Format("insert into FrontStandard values({0},{1},{2},{3})", first_frontPivotDisStandard, second_frontPivotDisStandard, three_standard, four_standard); int r = dbhelper.ExecuteNonQuery(sqlstr);//空表插入基准值 } else { DataTable dt = OperateSql.ReadStandard(sql); first_frontPivotDisStandard = double.Parse(dt.Rows[0][0].ToString()); second_frontPivotDisStandard = double.Parse(dt.Rows[0][1].ToString()); three_standard = double.Parse(dt.Rows[0][2].ToString()); four_standard = double.Parse(dt.Rows[0][3].ToString()); } } catch (Exception ex) { throw ex; } }
/// <summary> /// 删基准表,重置 /// </summary> /// <param name="sql"></param> private void ResetRead(string sql) { if (dataStoreManager != null) { dataStoreManager.StopTimer(); } if (adamHelper != null) { adamHelper.StopTimer(); } Thread.Sleep(200); try { OperateSql.deleteTable(sql); adamHelper.StartTimer(250);//重新开始读取 dataStoreManager.StartTimer(500, 1000); } catch (Exception ex) { MessageBox.Show("重置发生错误" + ex.Message); } }