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);
}
}