/// <summary>
/// 按下CrystalReportViewer的[匯出這份報表]
/// </summary>
/// <param name="dt">列印資料</param>
private void Show_Report(DataTable dt)
{
TextBox txt_BUSDATE_B = (TextBox)((ASP.wui_slp_slp_slpdate_ascx)this.slp_BUSDATE.FindControl("SLP_SLPDate1")).FindControl("TextBoxCode");
TextBox txt_BUSDATE_E = (TextBox)((ASP.wui_slp_slp_slpdate_ascx)this.slp_BUSDATE.FindControl("SLP_SLPDate2")).FindControl("TextBoxCode");
string s_par_Program_ID = string.Empty;
string s_par_LoginUser = string.Empty;
string s_par_BUSDATE = string.Empty;
string s_par_CHAN_NO = string.Empty;
string s_par_ITEM = string.Empty;
string s_par_Z_O = string.Empty;
string s_par_MANUFACTURE = string.Empty;
string s_par_OUT_OF_STOCK_DAY = string.Empty;
report = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
if (this.rdb_Report_Status.SelectedValue == "0")//明細表
{ report.Load(Server.MapPath("./REPORT/CRM151/CRM151_Report_Detl.rpt")); }
else if (this.rdb_Report_Status.SelectedValue == "1")//彙總表
{ report.Load(Server.MapPath("./REPORT/CRM151/CRM151_Report_Main.rpt")); }
s_par_Program_ID = this.PageCode;
s_par_LoginUser = Session["UID"].ToString();
s_par_BUSDATE = txt_BUSDATE_B.Text.Trim() + "~" + txt_BUSDATE_E.Text.Trim();
s_par_CHAN_NO = this.slp_CHAN_NO.Text.Trim();
s_par_ITEM = this.slp_ITEM.Text.Trim();
s_par_Z_O = this.slp_Z_O_B.Text.Trim() + "~" + this.slp_Z_O_E.Text.Trim();
s_par_MANUFACTURE = this.slp_MANUFACTURE_B.Text.Trim() + "~" + this.slp_MANUFACTURE_E.Text.Trim();
s_par_OUT_OF_STOCK_DAY = this.rdb_OUT_OF_STOCK_DAY.SelectedItem.Text.Trim();
ParameterFields par1 = new ParameterFields();
AddParameter("par_Program_ID", s_par_Program_ID, par1);
ParameterFields par2 = new ParameterFields();
AddParameter("par_LoginUser", s_par_LoginUser, par2);
ParameterFields par3 = new ParameterFields();
AddParameter("par_BUSDATE", s_par_BUSDATE, par3);
ParameterFields par4 = new ParameterFields();
AddParameter("par_CHAN_NO", s_par_CHAN_NO, par4);
ParameterFields par5 = new ParameterFields();
AddParameter("par_ITEM", s_par_ITEM, par5);
ParameterFields par6 = new ParameterFields();
AddParameter("par_Z_O", s_par_Z_O, par6);
ParameterFields par7 = new ParameterFields();
AddParameter("par_MANUFACTURE", s_par_MANUFACTURE, par7);
ParameterFields par8 = new ParameterFields();
AddParameter("par_OUT_OF_STOCK_DAY", s_par_OUT_OF_STOCK_DAY, par8);
this.CryView.ReportSource = null;
this.CryView.ParameterFieldInfo.Add(par1[0]);
this.CryView.ParameterFieldInfo.Add(par2[0]);
this.CryView.ParameterFieldInfo.Add(par3[0]);
this.CryView.ParameterFieldInfo.Add(par4[0]);
this.CryView.ParameterFieldInfo.Add(par5[0]);
this.CryView.ParameterFieldInfo.Add(par6[0]);
this.CryView.ParameterFieldInfo.Add(par7[0]);
this.CryView.ParameterFieldInfo.Add(par8[0]);
if (this.rdb_Report_Status.SelectedValue == "1")
{
ArrayList ParameterList = new ArrayList();//20091117
ParameterList.Clear();
ParameterList.Add(GetValueSetParameter(this.rdb_OUT_OF_STOCK_DAY.SelectedValue, "string", false));
ParameterList.Add(Session["UID"].ToString());
int i_CRM_REQUEST_NO_COUNT = 0;
BCO.QueryCRMOrderOutOfStockReport bco = new BCO.QueryCRMOrderOutOfStockReport(ConntionDB);
i_CRM_REQUEST_NO_COUNT = bco.QUERY_CRM151_PRINTSUM_COUNT(ParameterList);
ParameterFields par9 = new ParameterFields();
AddParameter("par_CRM_REQUEST_NO_COUNT", i_CRM_REQUEST_NO_COUNT.ToString(), par9);
this.CryView.ParameterFieldInfo.Add(par9[0]);
}
report.SetDataSource(dt);
this.CryView.ReportSource = report;
}
/// <summary>
/// 列印轉PDF檔
/// </summary>
/// <param name="dt">列印資料</param>
private void Show_Report2(DataTable dt)
{
TextBox txt_BUSDATE_B = (TextBox)((ASP.wui_slp_slp_slpdate_ascx)this.slp_BUSDATE.FindControl("SLP_SLPDate1")).FindControl("TextBoxCode");
TextBox txt_BUSDATE_E = (TextBox)((ASP.wui_slp_slp_slpdate_ascx)this.slp_BUSDATE.FindControl("SLP_SLPDate2")).FindControl("TextBoxCode");
string s_FileName = txt_Out_FileName.Text;
if (s_FileName.ToLower().IndexOf(".xls") < 0)
{
s_FileName = s_FileName + ".pdf";
}
else
{
s_FileName = s_FileName.Substring(0, s_FileName.Length - 4) + ".pdf";
}
s_FileName = HttpUtility.UrlEncode(s_FileName, System.Text.Encoding.UTF8);
//Load Report
report = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
if (this.rdb_Report_Status.SelectedValue == "0")//明細表
{ report.Load(Server.MapPath("./REPORT/CRM151/CRM151_Report_Detl.rpt")); }
else if (this.rdb_Report_Status.SelectedValue == "1")//彙總表
{ report.Load(Server.MapPath("./REPORT/CRM151/CRM151_Report_Main.rpt")); }
report.SetDataSource(dt);
// Set Parameter
report.SetParameterValue("par_Program_ID", this.PageCode);
report.SetParameterValue("par_LoginUser", Session["UID"].ToString());
report.SetParameterValue("par_BUSDATE", txt_BUSDATE_B.Text.Trim() + "~" + txt_BUSDATE_E.Text.Trim());
report.SetParameterValue("par_CHAN_NO", this.slp_CHAN_NO.Text.Trim());
report.SetParameterValue("par_ITEM", this.slp_ITEM.Text.Trim());
report.SetParameterValue("par_Z_O", this.slp_Z_O_B.Text.Trim() + "~" + this.slp_Z_O_E.Text.Trim());
report.SetParameterValue("par_MANUFACTURE", this.slp_MANUFACTURE_B.Text.Trim() + "~" + this.slp_MANUFACTURE_E.Text.Trim());
report.SetParameterValue("par_OUT_OF_STOCK_DAY", this.rdb_OUT_OF_STOCK_DAY.SelectedItem.Text.Trim());
if (this.rdb_Report_Status.SelectedValue == "1")
{
ArrayList ParameterList = new ArrayList();//20091117
ParameterList.Clear();
ParameterList.Add(GetValueSetParameter(this.rdb_OUT_OF_STOCK_DAY.SelectedValue, "string", false));
ParameterList.Add(Session["UID"].ToString());
int i_CRM_REQUEST_NO_COUNT = 0;
BCO.QueryCRMOrderOutOfStockReport bco = new BCO.QueryCRMOrderOutOfStockReport(ConntionDB);
i_CRM_REQUEST_NO_COUNT = bco.QUERY_CRM151_PRINTSUM_COUNT(ParameterList);
report.SetParameterValue("par_CRM_REQUEST_NO_COUNT", i_CRM_REQUEST_NO_COUNT.ToString());
}
System.IO.Stream stream = report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
byte[] bytes = new byte[stream.Length];
stream.Read(bytes, 0, bytes.Length);
stream.Seek(0, System.IO.SeekOrigin.Begin);
//export file
Response.ClearContent();
Response.ClearHeaders();
Response.AddHeader("content-disposition", "attachment;filename=" + s_FileName);//excel檔名
Response.ContentType = "application/vnd.ms-excel;charset='utf-8'";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("BIG5");
Response.OutputStream.Write(bytes, 0, bytes.Length);
Response.Flush();
Response.Close();
report.Close();
}
public static string getCount(string OUT_OF_STOCK_DAYControl, string UserID)
{
ParameterList.Clear();
ParameterList.Add(OUT_OF_STOCK_DAYControl);
ParameterList.Add(UserID);
int i_CRM_REQUEST_NO_COUNT = 0;
BCO.QueryCRMOrderOutOfStockReport bco = new BCO.QueryCRMOrderOutOfStockReport(ConntionDB);
i_CRM_REQUEST_NO_COUNT = bco.QUERY_CRM151_PRINTSUM_COUNT(ParameterList);
return i_CRM_REQUEST_NO_COUNT.ToString();
}