protected void Btn_Export_Click(object sender, EventArgs e) { try { #region 傳入參數 ParameterList.Clear(); ParameterList.Add(GetValueSetParameter(SLP_CHAN_NO.Text, "string", false)); ParameterList.Add(GetValueSetParameter(SLP_Route1.Text, "string", false)); ParameterList.Add(GetValueSetParameter(SLP_Route2.Text, "string", false)); #endregion #region 取得資料 STMModel.MaintainRoute BCO = new STMModel.MaintainRoute(ConntionDB); DataTable Dt = new DataTable(); Dt = BCO.QueryRouteRpt(ParameterList); #endregion if (Dt == null || (Dt != null && Dt.Rows.Count <= 0)) { ErrorMsgLabel.Text = "查無資料"; } else { #region 設定頁面狀態 this.hid_PageStatus.Value = "PRINT"; this.txt_PageStatus.Text = "PRINT"; #endregion string s_FileName = ""; //設定輸出檔名 string s_rptFilePath = ""; //設定報表路徑 s_rptFilePath = Server.MapPath("./REPORT/STM29/STM29R01.rpt"); s_FileName = HttpUtility.UrlEncode("STM29R01_" + "路線路順.xls", System.Text.Encoding.UTF8); LoadCrystalReport(s_FileName, s_rptFilePath, Dt, "EXCEL"); } } catch (Exception ex) { this.ErrorMsgLabel.Text = ex.ToString(); } finally { } }
protected void Btn_Print_Click(object sender, EventArgs e) { try { #region 傳入參數 ParameterList.Clear(); ParameterList.Add(GetValueSetParameter(SLP_CHAN_NO.Text, "string", false)); ParameterList.Add(GetValueSetParameter(SLP_Route1.Text, "string", false)); ParameterList.Add(GetValueSetParameter(SLP_Route2.Text, "string", false)); #endregion #region 取得資料 STMModel.MaintainRoute BCO = new STMModel.MaintainRoute(ConntionDB); DataTable Dt = new DataTable(); Dt = BCO.QueryRouteRpt(ParameterList); #endregion if (Dt == null || (Dt != null && Dt.Rows.Count <= 0)) { ErrorMsgLabel.Text = "查無資料"; } else { #region 設定頁面狀態 this.hid_PageStatus.Value = "PRINT"; this.txt_PageStatus.Text = "PRINT"; #endregion string s_FileName = ""; //設定輸出檔名 string s_rptFilePath = ""; //設定報表路徑 s_rptFilePath = Server.MapPath("./REPORT/STM29/STM29R01.rpt"); s_FileName = HttpUtility.UrlEncode("STM29R01_" + "路線路順.PDF", System.Text.Encoding.UTF8); LoadCrystalReport(s_FileName, s_rptFilePath, Dt, "PDF"); #region Viewer寫法 //使用者名稱 //ParameterList.Clear(); //ParameterList.Add(Session["UID"].ToString()); //PIC.VDS2G.COMMON.SYS.MaintainUser BCO2 = new PIC.VDS2G.COMMON.SYS.MaintainUser(ConntionDB); //DataTable DtUser = BCO2.QueryUserName(ParameterList); //string Login_Name = ""; //if (DtUser.Rows.Count != 0) //{ // Login_Name = DtUser.Rows[0]["NAME"].ToString(); //} //#region CrystalReport列印報表 //string Program_ID = string.Empty; //string LoginUser = string.Empty; //string LoginName = string.Empty; //string Chan_No = string.Empty; //string Route1 = string.Empty; //string Route2 = string.Empty; //CrystalDecisions.CrystalReports.Engine.ReportDocument report = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); //report.Load(Server.MapPath("./REPORT/STM29/STM29R.rpt")); //Program_ID = this.PageCode + "R"; //LoginUser = Session["UID"].ToString(); //Login_Name = Login_Name.Trim(); //Chan_No = ((TextBox)SLP_CHAN_NO.FindControl("TextBoxCode")).Text.Trim() + ((TextBox)SLP_CHAN_NO.FindControl("TextBoxName")).Text.Trim(); //Route1 = ((TextBox)SLP_Route1.FindControl("TextBoxName")).Text.Trim(); //Route2 = ((TextBox)SLP_Route2.FindControl("TextBoxName")).Text.Trim(); //ParameterFields par1 = new ParameterFields(); //AddParameter("par_Program_ID", Program_ID, par1); //ParameterFields par2 = new ParameterFields(); //AddParameter("par_LoginUser", LoginUser, par2); //ParameterFields par3 = new ParameterFields(); //AddParameter("par_LoginName", Login_Name, par3); //ParameterFields par4 = new ParameterFields(); //AddParameter("par_Route1", Route1, par4); //ParameterFields par5 = new ParameterFields(); //AddParameter("par_Route2", Route2, par5); //ParameterFields par6 = new ParameterFields(); //AddParameter("par_Chan_No", Chan_No, par6); //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]); //report.SetDataSource(Dt); //this.CryView.ReportSource = report; //#endregion #endregion } } catch (Exception ex) { this.ErrorMsgLabel.Text = ex.ToString(); } finally { } }