//导出 private void exportTool_Click(object sender, EventArgs e) { if (m_thread != null && m_thread.IsAlive) { BathClass.printErrorMsg("正在查询,请稍后!"); return; } ExportToExcel.ExportExcel("营业报表 " + startTime.Value.ToString("yyyy-MM-dd"), dgv); }
//导出 private void exportTool_Click(object sender, EventArgs e) { if (m_thread_details != null && m_thread_details.IsAlive) { m_thread_details.Abort(); } if (m_thread != null && m_thread.IsAlive) { m_thread.Abort(); } ExportToExcel.ExportExcel("技师对账单 " + startDate.Value.ToString("yyyy-MM-dd"), dgv); }
//导出 private void barBtnExport_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { DataTable dtExport = (DataTable)gcCLJBXX.DataSource; if (dtExport == null) { MessageBox.Show("请首先查询数据!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (dtExport.Rows.Count < 1) { MessageBox.Show("当前没有数据可以下载!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (folderBrowserDialog1.ShowDialog() == DialogResult.OK) { try { SplashScreenManager.ShowForm(typeof(DevWaitForm)); StringBuilder sqlWhere = new StringBuilder(); if (!string.IsNullOrEmpty(tbVIN.Text)) { sqlWhere.AppendFormat(" AND (VIN like '%{0}%')", tbVIN.Text); } if (!string.IsNullOrEmpty(tbSC_OCN.Text)) { sqlWhere.AppendFormat(" AND (SC_OCN like '%{0}%')", tbSC_OCN.Text); } if (!string.IsNullOrEmpty(tbCLXH.Text)) { sqlWhere.AppendFormat(" AND (CLXH like '%{0}%')", tbCLXH.Text); } if (!string.IsNullOrEmpty(tbCLZL.Text)) { sqlWhere.AppendFormat(" AND (CLZL like '%{0}%')", tbCLZL.Text); } if (!string.IsNullOrEmpty(cbRLLX.Text)) { sqlWhere.AppendFormat(" AND (RLLX = '{0}')", cbRLLX.Text); } if (!string.IsNullOrEmpty(this.dtStartTime.Text) && !string.IsNullOrEmpty(this.dtEndTime.Text) && this.cbTimeType.Text.Trim().Equals("上报日期")) { sqlWhere.AppendFormat(@" AND to_date(to_char(UPDATETIME,'yyyy/MM/dd'),'yyyy-mm-dd hh24:mi:ss') >= to_date('{0}','yyyy-mm-dd hh24:mi:ss') AND to_date(to_char(UPDATETIME,'yyyy/MM/dd'),'yyyy-mm-dd hh24:mi:ss') <= to_date('{1}','yyyy-mm-dd hh24:mi:ss') ", Convert.ToDateTime(this.dtStartTime.Text), Convert.ToDateTime(this.dtEndTime.Text)); } if (!string.IsNullOrEmpty(this.dtStartTime.Text) && !string.IsNullOrEmpty(this.dtEndTime.Text) && this.cbTimeType.Text.Trim().Equals("制造/进口日期")) { sqlWhere.AppendFormat(@" AND to_date(to_char(CLZZRQ,'yyyy/MM/dd'),'yyyy-mm-dd hh24:mi:ss') >= to_date('{0}','yyyy-mm-dd hh24:mi:ss') AND to_date(to_char(CLZZRQ,'yyyy/MM/dd'),'yyyy-mm-dd hh24:mi:ss')<= to_date('{1}','yyyy-mm-dd hh24:mi:ss') ", Convert.ToDateTime(this.dtStartTime.Text), Convert.ToDateTime(this.dtEndTime.Text)); } string sqlStrCTNY = string.Format(@"select V_ID,VIN,QCSCQY,CLXH,CLZL,RLLX,ZCZBZL,ZGCS,LTGG,ZJ,CLZZRQ,PFBZ,CT_ZHGKRLXHL,YHDYBAH,TYMC,YYC,ZWPS,ZDSJZZL,EDZK,LJ,QDXS,JYJGMC,JYBGBH,SC_OCN,XT_OCN,MI_XT_OCN,UPDATETIME from VIEW_T_ALL where 1=1 {0} ", sqlWhere); string sqlStrFCDS = string.Format(@"select V_ID,VIN,QCSCQY,CLXH,CLZL,RLLX,ZCZBZL,ZGCS,LTGG,ZJ,CLZZRQ,PFBZ,FCDS_HHDL_ZHGKRLXHL,YHDYBAH,TYMC,YYC,ZWPS,ZDSJZZL,EDZK,LJ,QDXS,JYJGMC,JYBGBH,SC_OCN,XT_OCN,MI_XT_OCN,UPDATETIME from VIEW_T_ALL_FCDS where 1=1 {0} ", sqlWhere); string sqlStrCDS = string.Format(@"select V_ID,VIN,QCSCQY,CLXH,CLZL,RLLX,ZCZBZL,ZGCS,LTGG,ZJ,CLZZRQ,PFBZ,CDS_HHDL_ZHGKRLXHL,YHDYBAH,TYMC,YYC,ZWPS,ZDSJZZL,EDZK,LJ,QDXS,JYJGMC,JYBGBH,SC_OCN,XT_OCN,MI_XT_OCN,UPDATETIME from VIEW_T_ALL_CDS where 1=1 {0} ", sqlWhere); string sqlStrCDD = string.Format(@"select V_ID,VIN,QCSCQY,CLXH,CLZL,RLLX,ZCZBZL,ZGCS,LTGG,ZJ,CLZZRQ,PFBZ,YHDYBAH,TYMC,YYC,ZWPS,ZDSJZZL,EDZK,LJ,QDXS,JYJGMC,JYBGBH,SC_OCN,XT_OCN,MI_XT_OCN,UPDATETIME from VIEW_T_ALL_CDD where 1=1 {0} ", sqlWhere); string sqlStrRLDC = string.Format(@"select V_ID,VIN,QCSCQY,CLXH,CLZL,RLLX,ZCZBZL,ZGCS,LTGG,ZJ,CLZZRQ,PFBZ,RLDC_ZHGKHQL,YHDYBAH,TYMC,YYC,ZWPS,ZDSJZZL,EDZK,LJ,QDXS,JYJGMC,JYBGBH,SC_OCN,XT_OCN,MI_XT_OCN,UPDATETIME from VIEW_T_ALL_RLDC where 1=1 {0} ", sqlWhere); DataSet dsCTNY = OracleHelper.ExecuteDataSet(OracleHelper.conn, sqlStrCTNY, null); DataSet dsFCDS = OracleHelper.ExecuteDataSet(OracleHelper.conn, sqlStrFCDS, null); DataSet dsCDS = OracleHelper.ExecuteDataSet(OracleHelper.conn, sqlStrCDS, null); DataSet dsCDD = OracleHelper.ExecuteDataSet(OracleHelper.conn, sqlStrCDD, null); DataSet dsRLDC = OracleHelper.ExecuteDataSet(OracleHelper.conn, sqlStrRLDC, null); DataSet dsExport = new DataSet(); if (dsCTNY != null && dsCTNY.Tables.Count > 0 && dsCTNY.Tables[0] != null && dsCTNY.Tables[0].Rows.Count > 0) { dsCTNY.Tables[0].TableName = "传统能源已上传数据"; dsExport.Tables.Add(dsCTNY.Tables[0].Copy()); } if (dsFCDS != null && dsFCDS.Tables.Count > 0 && dsFCDS.Tables[0] != null && dsFCDS.Tables[0].Rows.Count > 0) { dsFCDS.Tables[0].TableName = "非插电式混合动力已上传数据"; dsExport.Tables.Add(dsFCDS.Tables[0].Copy()); } if (dsCDS != null && dsCDS.Tables.Count > 0 && dsCDS.Tables[0] != null && dsCDS.Tables[0].Rows.Count > 0) { dsCDS.Tables[0].TableName = "插电式混合动力已上传数据"; dsExport.Tables.Add(dsCDS.Tables[0].Copy()); } if (dsCDD != null && dsCDD.Tables.Count > 0 && dsCDD.Tables[0] != null && dsCDD.Tables[0].Rows.Count > 0) { dsCDD.Tables[0].TableName = "纯电动已上传数据"; dsExport.Tables.Add(dsCDD.Tables[0].Copy()); } if (dsRLDC != null && dsRLDC.Tables.Count > 0 && dsRLDC.Tables[0] != null && dsRLDC.Tables[0].Rows.Count > 0) { dsRLDC.Tables[0].TableName = "燃料电池已上传数据"; dsExport.Tables.Add(dsRLDC.Tables[0].Copy()); } if (dsExport.Tables.Count < 1) { MessageBox.Show("当前没有数据可以下载!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } ExportToExcel toExcel = new ExportToExcel(); for (int i = 0; i < dsExport.Tables.Count; i++) { toExcel.ExportExcel(folderBrowserDialog1.SelectedPath, dsExport.Tables[i]); } MessageBox.Show("导出成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { MessageBox.Show("导出失败:" + ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { SplashScreenManager.CloseForm(); } } }
//导出 private void exportTool_Click(object sender, EventArgs e) { //BathClass.exportDgvToExcel(dgv); ExportToExcel.ExportExcel("项目报表 " + startDate.Value.ToString("yyyy-MM-dd"), dgv); }
//导出EXCEL private void barExcel_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (gcQueryCljbxx.DataSource == null) { MessageBox.Show("当前没有数据可以下载!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } using (FolderBrowserDialog folderBrowserDialog = new FolderBrowserDialog()) { if (folderBrowserDialog.ShowDialog() == DialogResult.OK) { try { SplashScreenManager.ShowForm(typeof(DevWaitForm)); StringBuilder sqlWhere = new StringBuilder(); if (!string.IsNullOrEmpty(this.tbVin.Text)) { sqlWhere.AppendFormat(@" AND VIN LIKE '%{0}%' ", this.tbVin.Text); } if (!string.IsNullOrEmpty(this.tbClzl.Text)) { sqlWhere.AppendFormat(@" AND CLZL LIKE '%{0}%' ", this.tbClzl.Text); } if (!string.IsNullOrEmpty(this.tbClxh.Text)) { sqlWhere.AppendFormat(@" AND Lower(CLXH) LIKE Lower('%{0}%') ", this.tbClxh.Text); } if (!string.IsNullOrEmpty(this.cbRllx.Text)) { sqlWhere.AppendFormat(@" AND RLLX LIKE '%{0}%' ", this.cbRllx.Text); } if (!string.IsNullOrEmpty(this.dtStartTime.Text) && !string.IsNullOrEmpty(this.dtEndTime.Text) && this.cbTimeType.Text.Trim().Equals("上报日期")) { sqlWhere.AppendFormat(@" AND to_date(to_char(UPDATETIME,'yyyy/MM/dd'),'yyyy-mm-dd hh24:mi:ss') >= to_date('{0}','yyyy-mm-dd hh24:mi:ss') AND to_date(to_char(UPDATETIME,'yyyy/MM/dd'),'yyyy-mm-dd hh24:mi:ss') <= to_date('{1}','yyyy-mm-dd hh24:mi:ss') ", Convert.ToDateTime(this.dtStartTime.Text), Convert.ToDateTime(this.dtEndTime.Text)); } if (!string.IsNullOrEmpty(this.dtStartTime.Text) && !string.IsNullOrEmpty(this.dtEndTime.Text) && this.cbTimeType.Text.Trim().Equals("制造/进口日期")) { sqlWhere.AppendFormat(@" AND to_date(to_char(CLZZRQ,'yyyy/MM/dd'),'yyyy-mm-dd hh24:mi:ss') >= to_date('{0}','yyyy-mm-dd hh24:mi:ss') AND to_date(to_char(CLZZRQ,'yyyy/MM/dd'),'yyyy-mm-dd hh24:mi:ss')<= to_date('{1}','yyyy-mm-dd hh24:mi:ss') ", Convert.ToDateTime(this.dtStartTime.Text), Convert.ToDateTime(this.dtEndTime.Text)); } string sqlStrCTNY = string.Format(@"select * from ADC_T_ALL where 1=1 {0} ", sqlWhere); string sqlStrFCDS = string.Format(@"select * from ADC_T_ALL_FCDS where 1=1 {0} ", sqlWhere); string sqlStrCDS = string.Format(@"select * from ADC_T_ALL_CDS where 1=1 {0} ", sqlWhere); string sqlStrCDD = string.Format(@"select * from ADC_T_ALL_CDD where 1=1 {0} ", sqlWhere); string sqlStrRLDC = string.Format(@"select * from ADC_T_ALL_RLDC where 1=1 {0} ", sqlWhere); DataSet dsCTNY = OracleHelper.ExecuteDataSet(OracleHelper.conn, sqlStrCTNY, null); DataSet dsFCDS = OracleHelper.ExecuteDataSet(OracleHelper.conn, sqlStrFCDS, null); DataSet dsCDS = OracleHelper.ExecuteDataSet(OracleHelper.conn, sqlStrCDS, null); DataSet dsCDD = OracleHelper.ExecuteDataSet(OracleHelper.conn, sqlStrCDD, null); DataSet dsRLDC = OracleHelper.ExecuteDataSet(OracleHelper.conn, sqlStrRLDC, null); using (DataSet dsExport = new DataSet()) { if (dsCTNY != null && dsCTNY.Tables.Count > 0 && dsCTNY.Tables[0] != null && dsCTNY.Tables[0].Rows.Count > 0) { dsCTNY.Tables[0].TableName = "传统能源官方同步数据"; dsExport.Tables.Add(dsCTNY.Tables[0].Copy()); } if (dsFCDS != null && dsFCDS.Tables.Count > 0 && dsFCDS.Tables[0] != null && dsFCDS.Tables[0].Rows.Count > 0) { dsFCDS.Tables[0].TableName = "非插电式混合动力官方同步数据"; dsExport.Tables.Add(dsFCDS.Tables[0].Copy()); } if (dsCDS != null && dsCDS.Tables.Count > 0 && dsCDS.Tables[0] != null && dsCDS.Tables[0].Rows.Count > 0) { dsCDS.Tables[0].TableName = "插电式混合动力官方同步数据"; dsExport.Tables.Add(dsCDS.Tables[0].Copy()); } if (dsCDD != null && dsCDD.Tables.Count > 0 && dsCDD.Tables[0] != null && dsCDD.Tables[0].Rows.Count > 0) { dsCDD.Tables[0].TableName = "纯电动官方同步数据"; dsExport.Tables.Add(dsCDD.Tables[0].Copy()); } if (dsRLDC != null && dsRLDC.Tables.Count > 0 && dsRLDC.Tables[0] != null && dsRLDC.Tables[0].Rows.Count > 0) { dsRLDC.Tables[0].TableName = "燃料电池官方同步数据"; dsExport.Tables.Add(dsRLDC.Tables[0].Copy()); } if (dsExport.Tables.Count < 1) { MessageBox.Show("当前没有数据可以下载!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } ExportToExcel toExcel = new ExportToExcel(); for (int i = 0; i < dsExport.Tables.Count; i++) { toExcel.ExportExcel(folderBrowserDialog.SelectedPath, dsExport.Tables[i]); } } MessageBox.Show("导出成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { MessageBox.Show("导出失败:" + ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { SplashScreenManager.CloseForm(); } } } }