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