private void button1_Click(object sender, EventArgs e)
{
dbhelper = DBHelper.GetInstance();
string sqlstr = "select * from tbProductId where Id=" + "'" + this.valveid + "'";
if (!OperateDb.IsTableNull(sqlstr))
{
DataTable dt1 = OperateDb.readTableN(sqlstr);
n = dt1.Rows.Count;
}
String Sql = string.Format("select backflow as 回油流量 ,mainPumpP1 as 泵1压力, mainPumpP2 as 泵2压力 from allData where productId='{0}' and n={1} and testName='门架前倾动作检测'", this.valveid, n);
DataTable dt = dbhelper.ExecuteSqlDataAdapter(Sql, null, 0);
ExportToExcel.ExportDataTest(dt);
}
