private void Export_Txt(ArrayList ParameterList) { try { DataTable dt_Return = new DataTable(); BCO.VAM19_BCO bco = new BCO.VAM19_BCO(ConntionDB); if (this.rblReportSource.SelectedValue == "4") { dt_Return = bco.QueryExportTrace_SKU(ParameterList); } else if (this.rblReportSource.SelectedValue == "5") { dt_Return = bco.QueryExportTrace_AGM(ParameterList); } if (dt_Return.Rows.Count == 0) { this.ErrorMsgLabel.Text = "查無資料"; return; } else { StringBuilder sbData = new StringBuilder(); foreach (DataRow dr in dt_Return.Rows) { sbData.Append(dr[0].ToString() + "\r\n"); } string strFileName = string.Empty; if (this.rblReportSource.SelectedValue == "5") strFileName = "合約交易補收"; else strFileName = "商品交易補收"; byte[] buffer = System.Text.Encoding.Default.GetBytes(sbData.ToString()); Response.ClearContent(); Response.ClearHeaders(); Response.AddHeader("content-disposition", "attachment;filename=" + HttpUtility.UrlEncode(strFileName + ".txt", System.Text.Encoding.UTF8));//匯出檔名 Response.ContentType = "application/xls"; Response.OutputStream.Write(buffer, 0, buffer.Length); Response.Flush(); Response.Close(); } } catch (Exception ex) { this.ErrorMsgLabel.Text = ex.ToString(); } finally { } }
private void Export_Excel(ArrayList ParameterList) { try { BCO.VAM19_BCO BCO = new BCO.VAM19_BCO(ConntionDB); // 讀取 Excel 資料 DataTable dt; if (this.rblReportSource.SelectedValue == "1") { dt = BCO.QueryExportTrace(ParameterList); } else if (this.rblReportSource.SelectedValue == "2") { dt = BCO.QueryVamAgmTrace(ParameterList); } else { dt = BCO.QueryVamSKUTrace(ParameterList); } if (dt.Rows.Count == 0) { ErrorMsgLabel.Text = "查無資料"; return; } ExcelXmlWorkbook book = new ExcelXmlWorkbook(); Worksheet sheet0 = book[0]; string s_Name; if (this.rblReportSource.SelectedValue == "1") { s_Name = "補收帳款匯出"; AddSheetData(ref sheet0, s_Name, dt); } else if (this.rblReportSource.SelectedValue == "2") { s_Name = "各項扣款彙總表(補收)"; AddSheetDataTrace(ref sheet0, s_Name, dt); } else { s_Name = "商品交易補收彙總表"; AddSheetDataTrace_SKU(ref sheet0, s_Name, dt); } //設定輸出檔名 string s_FileName = s_FileName = HttpUtility.UrlEncode("VAM191_" + s_Name + "_" + ParameterList[0].ToString() + "_" + ParameterList[1].ToString() + ".XLS", System.Text.Encoding.UTF8); //File download Response.Charset = "big5"; Response.ContentType = "application/x-excel;charset='utf-8'"; Response.AddHeader("content-disposition", "attachment; filename=" + s_FileName);//excel檔名 System.IO.MemoryStream stream = new System.IO.MemoryStream(); book.Export(stream); string producedExcel = GetStringFromMemoryStream(stream); stream.Close(); Response.Write(producedExcel); Response.Flush(); Response.End(); } catch (Exception ex) { this.ErrorMsgLabel.Text = ex.ToString(); } finally { } }
protected void btnExport_Click(object sender, EventArgs e) { try { this.ErrorMsgLabel.Text = ""; ParameterList.Clear(); ParameterList.Add(this.SLP_YearMonth1.Text.Trim()); ParameterList.Add(""); DataTable dt_Return = new DataTable(); BCO.VAM19_BCO bco = new BCO.VAM19_BCO(ConntionDB); if (this.rdoType1.Checked) { dt_Return = bco.QueryExportFile(ParameterList); } else if (this.rdoType2.Checked) { dt_Return = bco.QuerySubsidy_TAX(ParameterList); } else if (this.rdoType6.Checked) { dt_Return = bco.QuerySubsidy_UTAX(ParameterList); } else if (this.rdoType3.Checked) { dt_Return = bco.QuerySales(ParameterList); } else if (this.rdoType4.Checked) { dt_Return = bco.QueryVdsVamSalesItem(ParameterList); } else if (this.rdoType5.Checked) { dt_Return = bco.QueryVdsVamSalesClear(ParameterList); } else if (this.rdoType7.Checked) { dt_Return = bco.QueryVdsVamSubsidy_Oil(ParameterList); } else if (this.rdoType8.Checked) { dt_Return = bco.QueryVdsVamSubsidy_Island(ParameterList); } else { this.ErrorMsgLabel.Text = "尚未選擇"; return; } if (dt_Return.Rows.Count == 0) { this.ErrorMsgLabel.Text = "查無資料"; return; } else { StringBuilder sbData = new StringBuilder(); if ((rdoType1.Checked == true) || (rdoType2.Checked == true) || (rdoType6.Checked == true)|| (rdoType7.Checked == true) || (rdoType8.Checked == true)) { foreach (DataRow dr in dt_Return.Rows) { sbData.Append(dr[0].ToString() + "\r\n"); } } else { foreach (DataRow dr in dt_Return.Rows) { if (sbData.Length > 0) sbData.Append("\r\n"); sbData.Append(dr[0].ToString() + "," + dr[1].ToString() + "," + dr[2].ToString() + "," + dr[3].ToString()); } } string strFileName = string.Empty; if (rdoType1.Checked == true) strFileName = "一般月結帳款"; else if (this.rdoType2.Checked) strFileName = "轉出折扣補貼(應稅)"; else if (this.rdoType6.Checked) strFileName = "轉出折扣補貼(免稅)"; else if (this.rdoType3.Checked) strFileName = SLP_YearMonth1.Text.Trim() + "單品結帳付款檔"; else if (this.rdoType4.Checked) strFileName = SLP_YearMonth1.Text.Trim() + "實銷結帳付款檔"; else if (this.rdoType5.Checked) strFileName = SLP_YearMonth1.Text.Trim() + "實銷結帳-結清付款檔"; else if (this.rdoType7.Checked) strFileName = SLP_YearMonth1.Text.Trim() + "-油價補貼"; else if (this.rdoType8.Checked) strFileName = SLP_YearMonth1.Text.Trim() + "-離島配送費"; byte[] buffer = System.Text.Encoding.Default.GetBytes(sbData.ToString()); Response.ClearContent(); Response.ClearHeaders(); Response.AddHeader("content-disposition", "attachment;filename=" + HttpUtility.UrlEncode(strFileName + ".txt", System.Text.Encoding.UTF8));//匯出檔名 Response.ContentType = "application/xls"; Response.OutputStream.Write(buffer, 0, buffer.Length); Response.Flush(); Response.Close(); } } catch (Exception ex) { this.ErrorMsgLabel.Text = ex.ToString(); } finally { } }