private void btnExportPDF_Click(object sender, EventArgs e)
{
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.Filter = "PDF文件(*.pdf)|*.pdf";
// Show save file dialog box
DialogResult result = saveFileDialog.ShowDialog();
if (result == DialogResult.OK)
{
try
{
string strRandom = getRandomString(12);
string tempFilePath = System.IO.Directory.GetCurrentDirectory() + @"\tempPDF\" + strRandom + ".xls";
PrintPDF pe = new PrintPDF();
pe.WriteToExcel(pe.exporeDataToTable(dgvApplyInfo), tempFilePath, "Sheet1");
string localFilePath = saveFileDialog.FileName.ToString();
PrintPDF pp = new PrintPDF();
pp.XLSConvertToPDF(tempFilePath, localFilePath);
MessageBox.Show("保存成功", "消息", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show("保存失败", "消息", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
private void btnExpotDetailtoExcel_Click(object sender, EventArgs e)
{
PrintPDF pe = new PrintPDF();
DataTable dtInfo = pe.exporeDataToTable(dgvApplyInfo);
string strSQL = "select top 1 * from ApplicationDetail";
AccessHelper ah = new AccessHelper();
DataTable dtDetail;
string strTransNoList = "";
if (dtInfo.Rows.Count > 0)
{
for (int i = 0; i < dtInfo.Rows.Count; i++)
{
string strTransNo = dtInfo.Rows[i]["交易号"].ToString();
if (strTransNo != null && strTransNo.Length > 0)
{
if (i != dtInfo.Rows.Count - 1)
{
strTransNoList += "'" + strTransNo + "',";
}
else
{
strTransNoList += "'" + strTransNo + "'";
}
}
}
strSQL = "select * from ApplicationDetail where IsDelete = 0 and TransNo in (" + strTransNoList + ") ";
dtDetail = ah.SelectToDataTable(strSQL);
ah.Close();
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.Filter = "EXCEL文件(*.xls)|*.xls";
// Show save file dialog box
DialogResult result = saveFileDialog.ShowDialog();
if (result == DialogResult.OK)
{
try
{
string localFilePath = saveFileDialog.FileName.ToString();
pe = new PrintPDF();
pe.WriteToExcel_hisDetail(dtDetail, localFilePath, "Sheet1");
MessageBox.Show("保存成功", "消息", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show("保存失败", "消息", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
}