private void toolStripButton1_Click(object sender, EventArgs e) { FolderBrowserDialog dialog = new FolderBrowserDialog(); DialogResult result = dialog.ShowDialog(); if (result == DialogResult.OK) { try { BLL.DeviceDataBLL bll = new BLL.DeviceDataBLL(); DataTable table = bll.Query(this.comboBox1.SelectedValue.ToString(), this.comboBox2.SelectedValue.ToString(), this.comboBox3.SelectedValue.ToString(), this.comboBox4.SelectedValue.ToString(), this.dateTimePicker1.Value.ToString("yyyy-MM-dd"), this.dateTimePicker2.Value.ToString("yyyy-MM-dd"), txtDeviceValue.Text, this.comboBox5.SelectedIndex); byte[] byteArray = Office.ExcelExport.StreamExport(table, null); string name = dialog.SelectedPath + "\\导出数据.xls"; FileStream fs = File.Open(name, FileMode.Create); fs.Write(byteArray, 0, byteArray.Length); fs.Flush(); fs.Close(); MessageBox.Show("导出完成"); System.Diagnostics.Process.Start("Explorer.exe", dialog.SelectedPath); } catch (Exception ex) { } } }
void bindData() { BLL.DeviceDataBLL bll = new BLL.DeviceDataBLL(); DataTable table = bll.Query(this.comboBox1.SelectedValue.ToString(), this.comboBox2.SelectedValue.ToString(), this.comboBox3.SelectedValue.ToString(), this.comboBox4.SelectedValue.ToString(), this.dateTimePicker1.Value.ToString("yyyy-MM-dd"), this.dateTimePicker2.Value.ToString("yyyy-MM-dd"), txtDeviceValue.Text, this.comboBox5.SelectedIndex); this.dataGridView1.DataSource = table; }