/// <summary> /// 查询结果存为Excel /// </summary> private void btnSaveExcel_Click(object sender, EventArgs e) { try { if (!FrmMainDAO.QueryUserButtonPower(this.Name, this.Text, sender, true)) { return; } //FileHandler.SaveDevGridControlExportToExcel(gridViewSettlementHead); if (gridBottomOrderHead.pageCount <= 1) { FileHandler.SaveDevGridControlExportToExcel(gridViewSettlementHead); } else { commonDAO.SaveExcel_QueryAllData(dataSet_Settlement.Tables[0], lastQuerySqlStr, gridViewSettlementHead); } } catch (Exception ex) { //ExceptionHandler.HandleException(this.Text + "--查询结果存为Excel错误。", ex); ExceptionHandler.HandleException(this.Text + "--" + tsmiCxjgcw.Text, ex); } }
/// <summary> /// 查询结果存为Excel /// </summary> private void btnSaveExcel_Click(object sender, EventArgs e) { try { if (!FrmMainDAO.QueryUserButtonPower(this.Name, this.Text, sender, true)) { return; } //FileHandler.SaveDevGridControlExportToExcel(gridViewSalesOrder); //int result = new CustomXtraMessageBoxForm().ShowMessageBox("请选择要存为 Excel 的查询记录:", new string[] { "当前页面记录", "全部查询记录", "取消" }); //MessageHandler.ShowMessageBox(result.ToString()); if (gridBottomOrderHead.pageCount <= 1) { FileHandler.SaveDevGridControlExportToExcel(gridViewSalesOrder); } else { commonDAO.SaveExcel_QueryAllData(dataSet_SalesOrder.Tables[0], lastQuerySqlStr, gridViewSalesOrder); } } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--查询结果存为Excel错误。", ex); } }
/// <summary> /// 查询结果存为Excel /// </summary> private void btnSaveExcel_Click(object sender, EventArgs e) { try { if (gridBottomOrderHead.pageCount <= 1) { FileHandler.SaveDevGridControlExportToExcel(gridViewProductionSchedule); } else { commonDAO.SaveExcel_QueryAllData(dataSet_PSchedule.Tables[0], lastQuerySqlStr, gridViewProductionSchedule); } } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--查询结果存为Excel错误。", ex); } }
/// <summary> /// 查询结果存为Excel /// </summary> private void btnSaveExcel_Click(object sender, EventArgs e) { try { //FileHandler.SaveDevGridControlExportToExcel(gridViewDurationStock); if (gridBottomWNowInfo.pageCount <= 1) { FileHandler.SaveDevGridControlExportToExcel(gridViewDurationStock); } else { commonDAO.SaveExcel_QueryAllData(dataSet_DurationStock.Tables[0], lastQuerySqlStr, gridViewDurationStock); } } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--查询结果存为Excel错误。", ex); } }
/// <summary> /// 查询结果存为Excel /// </summary> private void btnSaveExcel_Click(object sender, EventArgs e) { try { //FileHandler.SaveDevGridControlExportToExcel(gridViewWWHead); if (gridBottomOrderHead.pageCount <= 1) { FileHandler.SaveDevGridControlExportToExcel(gridViewWWHead); } else { commonDAO.SaveExcel_QueryAllData(dataSet_WW.Tables[0], lastQuerySqlStr, gridViewWWHead); } } catch (Exception ex) { //ExceptionHandler.HandleException(this.Text + "--查询结果存为Excel错误。", ex); ExceptionHandler.HandleException(this.Text + "--" + f.tsmiCxjgcwexcelcw.Text, ex); } }
/// <summary> /// 查询结果存为Excel /// </summary> private void btnSaveExcel_Click(object sender, EventArgs e) { try { if (!FrmMainDAO.QueryUserButtonPower(this.Name, this.Text, sender, true)) { return; } //FileHandler.SaveDevGridControlExportToExcel(gridViewDurationStock); if (gridBottomWNowInfo.pageCount <= 1) { FileHandler.SaveDevGridControlExportToExcel(gridViewOpenAccount); } else { commonDAO.SaveExcel_QueryAllData(dataSet_OpenAccount.Tables[0], lastQuerySqlStr, gridViewOpenAccount); } } catch (Exception ex) { ExceptionHandler.HandleException(this.Text + "--查询结果存为Excel错误。", ex); } }