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