//导出
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();
}
}
}
}
