/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ucCalcHeatCondition1_ExportEvent(object sender, EventArgs e) { string filename = CZGRCommon.Path.GetTempFileName("xls"); DataFormatterCollection dfs = new DataFormatterCollection(); dfs.Add(new SingleFormatter()); dfs.Add(new DoubleFormatter()); dfs.Add(new Int32Formatter()); CZGRCommon.ExcelExporter ee = new CZGRCommon.ExcelExporter(filename, dfs); // 耗热量计算公式 // LinesAttache aaa = new LinesAttache(); DataTable tbl = CZGRQRCApp.Default.DBI.ExecuteHeatCommentDataTable(); List<III> iiis = CreateIIIs(); CZGRCommon.CCC ccc = CreateCCC(iiis); aaa.Lines.Add(""); aaa.Lines.Add("注:"); foreach (DataRow row in tbl.Rows) { string content = row["content"].ToString().Trim(); if (content.Length > 0) { aaa.Lines.Add(content); } } //aaa.Lines.Add("\t注:日耗热量 = 日流量 * ( 一次供温 - 一次回温 ) * 4.1816 / 1000"); ee.AttacheCollection.Add(aaa); ee.Export(this.dataGridView1, ccc); ProcessStartInfo si = new ProcessStartInfo(filename); si.ErrorDialog = true; Process.Start(si); }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnExport_Click(object sender, EventArgs e) { string filename = CZGRCommon.Path.GetTempFileName("xls"); CZGRCommon.ExcelExporter ee = new CZGRCommon.ExcelExporter(filename, //GetDataFormatterCollection()); DataGridViewFormatters.DefaultDataFormatterCollection); ee.ExportedEvent += new EventHandler(ee_ExportedEvent); CCC ccc = CCCFactory.CreateGRDataCCC(this.dataGridView1); ee.Export(this.dataGridView1, ccc); ProcessStartInfo si = new ProcessStartInfo(filename); si.ErrorDialog = true; Process.Start(si); }