private void frmOPLog_Load(object sender, System.EventArgs e) { this.strAppPatch = Application.StartupPath + "\\"; this.txtDepartment.m_lsvList.Width = this.txtDepartment.Width; this.txtDepartment.m_lsvList.Columns[0].Width = this.txtDepartment.Width; this.txtReportDoctor.m_lsvList.Width = this.txtReportDoctor.Width; dtpFrom.Value = DateTime.Now; dtpTo.Value = DateTime.Now; objReportDocument = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); objReportDocument.Load(strAppPatch + "Report\\rptOPLog.rpt"); TextObject txtReportTitle = objReportDocument.ReportDefinition.ReportObjects["Text10"] as TextObject; txtReportTitle.Text = ((clsCtl_OPLog)this.objController).m_objComInfo.m_strGetHospitalTitle() + "门诊工作日志报表"; if (this.chkCheckDate.Checked) { ((TextObject)objReportDocument.ReportDefinition.ReportObjects["TextDate"]).Text = dtpFrom.Value.ToString("yyyy-MM-dd") + " ~ " + dtpTo.Value.ToString("yyyy-MM-dd"); } // this.crystalReportViewer1.ReportSource =objReportDocument; if (strDoctorID != "") { ((clsCtl_OPLog)this.objController).m_mthLogData(); } }
/// <summary> ///This method is called by the "Logon" method. It loops through the report tables and applies the connection information to each table. /// </summary> /// <param name="cr"></param> /// <param name="ci"></param> /// <returns></returns> private bool ApplyLogon(CrystalDecisions.CrystalReports.Engine.ReportDocument cr, CrystalDecisions.Shared.ConnectionInfo ci) { // This function is called by the "Logon" function // It loops through the report tables and applies // the connection information to each table. // Declare the TableLogOnInfo object and a table object for use later. CrystalDecisions.Shared.TableLogOnInfo li; // For each table apply connection info. foreach (CrystalDecisions.CrystalReports.Engine.Table tbl in cr.Database.Tables) { li = tbl.LogOnInfo; li.ConnectionInfo.ServerName = ci.ServerName; li.ConnectionInfo.DatabaseName = ci.DatabaseName; li.ConnectionInfo.UserID = ci.UserID; li.ConnectionInfo.Password = ci.Password; tbl.ApplyLogOnInfo(li); tbl.Location = ci.DatabaseName + ".dbo." + tbl.Name; // Verify that the logon was successful. // If TestConnectivity returns false, correct table locations. if (!tbl.TestConnectivity()) { return(false); } } return(true); }
private void cmdPrint_Click(System.Object eventSender, System.EventArgs eventArgs) { ADODB.Recordset rs = default(ADODB.Recordset); string sql = null; CrystalDecisions.CrystalReports.Engine.ReportDocument Report = default(CrystalDecisions.CrystalReports.Engine.ReportDocument); Report.Load("cryStockItemPrice.rpt"); System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor; rs = modRecordSet.getRS(ref "SELECT * FROM Company"); Report.SetParameterValue("txtCompanyName", rs.Fields("Company_Name")); rs.Close(); Report.SetParameterValue("txtFilter", lblHeading.Text); Report.SetParameterValue("txtTitle1", "Where Sales Channel = " + cmbChannel.CtlText); //Report.Database.SetDataSource(adoPrimaryRS, 3) Report.Database.Tables(1).SetDataSource(adoPrimaryRS); //Report.VerifyOnEveryPrint = True My.MyProject.Forms.frmReportShow.Text = Report.ParameterFields("txtTitle").ToString; My.MyProject.Forms.frmReportShow.CRViewer1.ReportSource = Report; My.MyProject.Forms.frmReportShow.mReport = Report; My.MyProject.Forms.frmReportShow.sMode = "0"; My.MyProject.Forms.frmReportShow.CRViewer1.Refresh(); System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default; My.MyProject.Forms.frmReportShow.ShowDialog(); }
public frmRelBasicos(string pArquivo, string pTitulo) { InitializeComponent(); relArquivo = pArquivo; relTitulo = pTitulo; this.Text = pTitulo; //Objeto com informações de conexão para as tabelas do rpt conexaoCrystal = new CrystalDecisions.Shared.ConnectionInfo(); conexaoCrystal.ServerName = @"(local)\SQLEXPRESS"; conexaoCrystal.UserID = "sa"; conexaoCrystal.Password = "******"; conexaoCrystal.DatabaseName = "Copa2010"; //Carregar o arquivo do rpt pArquivo CrystalDecisions.CrystalReports.Engine.ReportDocument report = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); report.Load(Application.StartupPath + @"..\..\..\Relatorios\" + relArquivo); //Informe o rpt com as informações de conexão CrystalDecisions.Shared.TableLogOnInfo logonInfo = new CrystalDecisions.Shared.TableLogOnInfo(); logonInfo.ConnectionInfo = conexaoCrystal; foreach (CrystalDecisions.CrystalReports.Engine.Table table in report.Database.Tables) { table.LogOnInfo.ConnectionInfo = conexaoCrystal; table.ApplyLogOnInfo(logonInfo); } //Liga ao Visualizador crvRel.ReportSource = report; }
private void mmuMailingLabel_Click(object sender, EventArgs e) { try { if (System.IO.File.Exists(CurrentUser.ReportPath + "rptCustomerMailingLabel1.rpt")) { //dtblCustomer.TableName = "CustomerRegister"; //dtblCustomer.WriteXmlSchema(@"D:\report\CustomerRegister.xsd"); //DataView DVReport; //DVReport = dtblCustomer.DefaultView; //DVReport.RowFilter = StrFilter; CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); rptDoc.Load(CurrentUser.ReportPath + "rptCustomerMailingLabel1.rpt"); //CurrentUser.AddReportParameters(rptDoc, DVReport.ToTable(), "Customer Mailing Label", false, false, false, false, false, false, false, false, false, false, false); Reports.frmReportViewer fRptView = new Reports.frmReportViewer(); fRptView.Text = "Customer Mailing Label - [Page Size: A4]"; fRptView.crViewer.ReportSource = rptDoc; fRptView.ShowDialog(); } else { MessageBox.Show("File is not exist..."); } } catch (Exception exc) { Utill.Common.ExceptionLogger.writeException("Customer- Mailing Label", exc.StackTrace); MessageBox.Show(Utill.Common.CommonMessage.ExceptionMesg, "Exception"); } }
private void Report_Modification(CrystalDecisions.CrystalReports.Engine.ReportDocument cryRpt) { CrystalDecisions.ReportAppServer.ClientDoc.ISCDReportClientDocument rptClientDoc1 = cryRpt.ReportClientDocument; ReportDefController2 reportDef = rptClientDoc1.ReportDefController; ReportSectionController reportSectionController = rptClientDoc1.ReportDefController.ReportSectionController; CrystalDecisions.ReportAppServer.ReportDefModel.Section newsec; int index = reportDef.ReportDefinition.PageHeaderArea.Sections.Count; // CrystalDecisions.ReportAppServer.ReportDefModel.PictureObject objPictureBox = new CrystalDecisions.ReportAppServer.ReportDefModel.PictureObject(); if (index > 0) { // reportDef.ReportDefinition.PageHeaderArea.Sections.Add(reportDef.ReportDefinition.PageHeaderArea.Sections[index - 1]); newsec = reportDef.ReportDefinition.PageHeaderArea.Sections[index - 1];//reportDef.ReportDefinition.PageHeaderArea.Sections[index - 1]; } else { index = 0; newsec = reportDef.ReportDefinition.PageHeaderArea.Sections[index]; } reportDef.ReportDefinition.PageHeaderArea.Sections.Insert(index, newsec); CrystalDecisions.ReportAppServer.ReportDefModel.Section sectionToAddTo = reportDef.ReportDefinition.PageHeaderArea.Sections[index]; CrystalDecisions.ReportAppServer.ReportDefModel.SectionFormat newSectionFormat = sectionToAddTo.Format; newSectionFormat.EnableKeepTogether = false; newSectionFormat.EnableSuppress = false; newSectionFormat.EnableUnderlaySection = true; reportSectionController.SetProperty(sectionToAddTo, CrReportSectionPropertyEnum.crReportSectionPropertyFormat, newSectionFormat); reportDef.ReportObjectController.ImportPicture(AppDomain.CurrentDomain.BaseDirectory + @"IMAGE/AccessReportWatermarks1.png", sectionToAddTo, 500, 700); }
private void Form1_Load(object sender, EventArgs e) { CrystalDecisions.CrystalReports.Engine.ReportDocument report = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); report.Load(@"C:\Users\Willmack\source\repos\WindowsFormsApp1\WindowsFormsApp1\CrystalReport1.rpt"); crystalReportViewer1.ReportSource = report; crystalReportViewer1.Refresh(); }
private void ReportViewer_Load(object sender, EventArgs e) { myReportDocument = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); string strDirPath = Application.StartupPath + "/Reports/" + _repName + ".rpt"; try { myReportDocument.Load(strDirPath); } catch { MessageBox.Show("Нет файла отчета!/n" + strDirPath, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Stop); } SetDataReport(_repName); // @TODO Заменить на общий датасет DataSetReport //if (_repDBProcName == "Rep_GetReportLast") //{ // SetDataReportLast(); //} //else //{ // SetDataReport(); //} }
/// <summary> /// 病区病人欠费一览表 /// </summary> public void m_mthShowInHospitalDebtLog() { if (this.m_objViewer.m_txtAREAID_CHR.Tag == null) { this.m_objViewer.m_txtAREAID_CHR.Tag = ""; this.m_objViewer.m_txtAREAID_CHR.Text = "全院"; } this.m_objViewer.Cursor = Cursors.WaitCursor; DataTable dtbResult = new DataTable(); rptInHospitalLog = new ReportDocument(); rptInHospitalLog.Load(@"Report\rptDebtView.rpt"); rptInHospitalLog.DataDefinition.FormulaFields["AreaName"].Text = "'" + this.m_objViewer.m_txtAREAID_CHR.Text.Trim() + "'"; rptInHospitalLog.DataDefinition.FormulaFields["StatDate"].Text = "'" + this.m_objViewer.m_StatDate.Value.ToShortDateString() + "'"; rptInHospitalLog.DataDefinition.FormulaFields["operatorname"].Text = "'" + this.m_objViewer.LoginInfo.m_strEmpName + "'"; int type = -1; if (this.m_objViewer.radioButton1.Checked) { type = 1; } if (this.m_objViewer.radioButton2.Checked) { type = 0; } long lngRes = objSvc.m_lngGetPatientDebt(type, (string)this.m_objViewer.m_txtAREAID_CHR.Tag, "", this.m_objViewer.m_StatDate.Value, "", "", out dtbResult); if (lngRes > 0) { rptInHospitalLog.SetDataSource(dtbResult); this.m_objViewer.m_ctrvPatientDebtReport.ReportSource = rptInHospitalLog; } this.m_objViewer.Cursor = Cursors.Default; }
public frmReporte(CrystalDecisions.CrystalReports.Engine.ReportDocument crRepDoc) { InitializeComponent(); //Configura el reporte crvQueja.ReportSource = crRepDoc; }
protected void generarrpt(object sender, EventArgs e) { string select = "SELECT MEMP.MEMP_CODIEMPL,MNIT.MNIT_NOMBRES,MNIT.MNIT_NOMBRE2,MNIT.MNIT_APELLIDOS,MNIT.MNIT_APELLIDO2,MNIT.MNIT_DIGITO,MNIT.MNIT_DIRECCION,MNIT.MNIT_EMAIL,MNIT.MNIT_TELEFONO,MNIT.MNIT_CELULAR, MEMP.MEMP_FECHNACI,PCIU.PCIU_NOMBRE,MNIT.MNIT_NIT,MNIT.MNIT_DIGITO,MEMP.MEMP_NUMELIBRMILI,MEMP.MEMP_CLASELIBRMILI,DBXSCHEMA.TSEXO.TSEX_NOMBRE,YEAR(CURRENT DATE) - YEAR(MEMP.MEMP_FECHNACI),MEMP.MEMP_NUMEHIJOS,MEMP.TRES_VIVIENDA,MEMP.MEMP_FECHINGRESO,MEMP.MEMP_SUELACTU,MEMP.MEMP_SUELANTER,TCON.TCON_NOMBRE,TSUBT.TSUB_NOMBRE, PDEPTO.PDEP_NOMBDPTO,TESTEMP.TEST_NOMBRE,DBXSCHEMA.TFORMAPAGO.TFOR_DESCRIPCION,DBXSCHEMA.PBANCO.PBAN_NOMBRE,MEMP.MEMP_CUENNOMI,DBXSCHEMA.PEPS.PEPS_NOMBEPS,DBXSCHEMA.PARP.PARP_NOMBARP,PFCESA.PFON_NOMBFOND,PFPENS.PFON_NOMBPENS,DBXSCHEMA.TRETEFTE.TEST_DESCRIPCION, MEMP.MEMP_PORCRETE,TSANGRE.TTIP_TIPOSANG ,PCAR.pcar_nombcarg,TCIVIL.test_nombre,MEMP.memp_fecsuelanter,memp_peripago,TPAGO.TPER_DESCP,TFPAGO.tfor_descripcion,MEMP.memp_cuennomi,PFPENS2.pfon_nombpens as pensvol"; string from = " FROM DBXSCHEMA.MEMPLEADO MEMP,DBXSCHEMA.MNIT MNIT,DBXSCHEMA.PCIUDAD PCIU,DBXSCHEMA.TSEXO,DBXSCHEMA.TCONTRATONOMINA TCON,DBXSCHEMA.TSUBSIDIOTRANSPORTE TSUBT ,DBXSCHEMA.PDEPARTAMENTOEMPRESA PDEPTO,DBXSCHEMA.TESTADOEMPLEADO TESTEMP, DBXSCHEMA.TFORMAPAGO,DBXSCHEMA.PBANCO,DBXSCHEMA.PEPS,DBXSCHEMA.PARP,DBXSCHEMA.PFONDOPENSION PFPENS,DBXSCHEMA.PFONDOPENSION PFPENS2, DBXSCHEMA.PFONDOCESANTIAS PFCESA,DBXSCHEMA.TRETEFTE,DBXSCHEMA.TTIPOSANGRE TSANGRE,DBXSCHEMA.PCARGOEMPLEADO PCAR,dbxschema.testadocivil TCIVIL,dbxschema.TPERIPAGO TPAGO,DBXSCHEMA.TFORMAPAGO TFPAGO"; string where = " WHERE MEMP.MEMP_CODIEMPL='" + DDLEMPLEADO.SelectedValue + "' AND PFPENS.pfon_codipens=MEMP.pfon_codipens AND PFPENS2.pfon_codipens=MEMP.pfon_codipensvolu AND TFPAGO.tfor_pago=memp.memp_formpago AND TPAGO.tper_peri=MEMP.memp_peripago AND TCIVIL.test_estacivil=memp.test_estacivil AND MEMP.PCAR_CODICARGO=PCAR.PCAR_CODICARGO AND MEMP.MNIT_NIT=MNIT.MNIT_NIT and memp.ttip_secuencia= TSANGRE.ttip_secuencia AND MEMP.PCIU_LUGANACI=PCIU.PCIU_CODIGO AND MEMP.TSEX_CODIGO=DBXSCHEMA.TSEXO.TSEX_CODIGO AND MEMP.TCON_CONTRATO= TCON.TCON_CONTRATO AND MEMP.TSUB_CODIGO=TSUBT.TSUB_CODIGO AND MEMP.PDEP_CODIDPTO= PDEPTO.PDEP_CODIDPTO AND MEMP.TEST_ESTADO= TESTEMP.TEST_ESTADO AND MEMP.MEMP_FORMPAGO=DBXSCHEMA.TFORMAPAGO.TFOR_PAGO AND MEMP.PBAN_CODIGO=DBXSCHEMA.PBANCO.PBAN_CODIGO AND MEMP.PEPS_CODIEPS=DBXSCHEMA.PEPS.PEPS_CODIEPS AND MEMP.PARP_CODIARP=DBXSCHEMA.PARP.PARP_CODIARP AND MEMP.PFON_CODICESA=PFCESA.PFON_CODIFOND AND MEMP.MEMP_TESTRETE=DBXSCHEMA.TRETEFTE.TEST_RETE"; string nomEmpleado = DBFunctions.SingleData("SELECT NOMBRE FROM VMNIT VM, MEMPLEADO ME WHERE VM.MNIT_NIT = ME.MNIT_NIT AND ME.MEMP_CODIEMPL = '" + DDLEMPLEADO.SelectedValue + "'"); DataSet ds = new DataSet(); DBFunctions.Request(ds, IncludeSchema.NO, select + from + where + ";select cemp_nombre,cemp_nombcome,mnit_nit from dbxschema.cempresa"); if (ds.Tables[0].Rows.Count > 0) { ds.WriteXmlSchema(Path.Combine(Request.PhysicalApplicationPath, "schemas/Nomina.InfyConsultas.rpte_ImpHojaVida.xsd")); reporte = new ReportDocument(); reporte.Load(Path.Combine(Request.PhysicalApplicationPath, "rpt/Nomina.InfyConsultas.rpte_ImpHojaVida.rpt")); reporte.SetDataSource(ds); visor.ReportSource = reporte; visor.DataBind(); reporte.ExportToDisk(ExportFormatType.WordForWindows, Path.Combine(Request.PhysicalApplicationPath, "rptgen/Nomina.InfyConsultas.rpte_ImpHojaVida.doc")); Response.Clear(); Response.ContentType = "application/msword"; Response.AddHeader("Content-Disposition", "attachment; filename= " + nomEmpleado + ".doc"); Response.ContentType = "application/msword"; Response.WriteFile(Path.Combine(Request.PhysicalApplicationPath, "rptgen/Nomina.InfyConsultas.rpte_ImpHojaVida.doc")); Response.Flush(); Response.Close(); } else { Utils.MostrarAlerta(Response, "Existe un prolema con la consulta, el vendedor no tiene la información completa"); } }
private void loadStockSales() { ADODB.Recordset rs = default(ADODB.Recordset); ADODB.Recordset rsStock = default(ADODB.Recordset); ADODB.Recordset rsGroup = default(ADODB.Recordset); string sql = null; ADODB.Recordset rsData = default(ADODB.Recordset); CrystalDecisions.CrystalReports.Engine.ReportDocument Report = default(CrystalDecisions.CrystalReports.Engine.ReportDocument); CrystalDecisions.CrystalReports.Engine.ReportDocument ReportNone = default(CrystalDecisions.CrystalReports.Engine.ReportDocument); Report.Load("crySalesByShrink.rpt"); ReportNone.Load("cryNoRecords.rpt"); System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor; rs = modReport.getRSreport(ref "SELECT Report.Report_Heading, aCompany.Company_Name FROM aCompany, Report;"); Report.SetParameterValue("txtCompanyName", rs.Fields("Company_Name")); Report.SetParameterValue("txtDayEnd", rs.Fields("Report_Heading")); rs.Close(); rs = modReport.getRSreport(ref "SELECT * FROM Link Where LinkID=2 AND Link_SectionID=1"); if (string.IsNullOrEmpty(rs.Fields("Link_Name").Value)) { Report.ReportDefinition.Sections("Section2").SectionFormat.EnableSuppress = true; } else { Report.SetParameterValue("txtFilter", Strings.Replace(rs.Fields("Link_Name").Value, "''", "'")); } sql = "SELECT aStockItem.StockItemID, aStockItem.StockItem_Name, thejoin.shrink, thejoin.quantity, thejoin.price, thejoin.list, thejoin.actual FROM aStockItem INNER JOIN (SELECT SaleItem.SaleItem_StockItemID AS StockItem, SaleItem.SaleItem_ShrinkQuantity AS shrink, Sum(IIf([SaleItem_Reversal],0-[SaleItem_Quantity],[SaleItem_Quantity])) AS quantity, Sum(([SaleItem_Price]*[SaleItem_Quantity])) AS price, Sum((([SaleItem_ListCost]+[SaleItem_DepositCost])*IIf([SaleItem_Reversal],0-[SaleItem_Quantity],[SaleItem_Quantity]))*(1+[SaleItem_Vat]/100)) AS list, Sum((([SaleItem_ActualCost]+[SaleItem_DepositCost])*IIf([SaleItem_Reversal],0-[SaleItem_Quantity],[SaleItem_Quantity]))*(1+[SaleItem_Vat]/100)) AS actual From SaleItem Where (((SaleItem.SaleItem_DepositType) = 0) And ((SaleItem.SaleItem_Revoke) = 0)) GROUP BY SaleItem.SaleItem_StockItemID, SaleItem.SaleItem_ShrinkQuantity ) AS thejoin ON aStockItem.StockItemID = thejoin.StockItem "; sql = sql + rs.Fields("Link_SQL").Value + " ORDER BY aStockItem.StockItem_Name, thejoin.shrink;"; rs = modReport.getRSreport(ref sql); if (rs.BOF | rs.EOF) { ReportNone.SetParameterValue("txtCompanyName", Report.ParameterFields("txtCompanyName").ToString); ReportNone.SetParameterValue("txtTitle", Report.ParameterFields("txtTitle").ToString); My.MyProject.Forms.frmReportShow.Text = ReportNone.ParameterFields("txtTitle").ToString; My.MyProject.Forms.frmReportShow.CRViewer1.ReportSource = ReportNone; My.MyProject.Forms.frmReportShow.mReport = ReportNone; My.MyProject.Forms.frmReportShow.sMode = "0"; My.MyProject.Forms.frmReportShow.CRViewer1.Refresh(); System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default; My.MyProject.Forms.frmReportShow.ShowDialog(); return; } Report.Database.Tables(1).SetDataSource(rs); //Report.VerifyOnEveryPrint = True My.MyProject.Forms.frmReportShow.Text = Report.ParameterFields("txtTitle").ToString; My.MyProject.Forms.frmReportShow.CRViewer1.ReportSource = Report; My.MyProject.Forms.frmReportShow.mReport = Report; My.MyProject.Forms.frmReportShow.sMode = "0"; My.MyProject.Forms.frmReportShow.CRViewer1.Refresh(); System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default; My.MyProject.Forms.frmReportShow.ShowDialog(); }
/// <summary> ///病人出院单统计表 /// </summary> public void m_mthShowBIHLeftStatistics() { this.m_objViewer.Cursor = Cursors.WaitCursor; DataTable dtbResult = new DataTable(); rptBIHRegisterStatistics = new ReportDocument(); //rptBIHRegisterStatistics.Load(@"Report\rptLeaveHospital.rpt"); rptBIHRegisterStatistics.Load(m_strStartPatch + "Report\\rptLeaveHospital.rpt"); rptBIHRegisterStatistics.DataDefinition.FormulaFields["dtStartTime"].Text = "'" + this.m_objViewer.m_dtpStatDate.Text + "'"; rptBIHRegisterStatistics.DataDefinition.FormulaFields["dtEndTime"].Text = "'" + this.m_objViewer.m_dtpEnd.Text + "'"; //change 2007-4-18 //long lngRes = objSvc.GetPatientLeftStatistics(DateTime.Parse(m_objViewer.m_dtpStatDate.Text + " 00:00:00"), DateTime.Parse(m_objViewer.m_dtpEnd.Text + " 23:59:59"), out dtbResult); // ----------------------------> long lngRes = objSvc.GetPatientLeftStatistics(DateTime.Parse(m_objViewer.m_dtpStatDate.Text + " 00:00:00"), DateTime.Parse(m_objViewer.m_dtpEnd.Text + " 23:59:59"), m_objViewer.m_txtProtectType.Value, out dtbResult); // <------------------------------ if (lngRes > 0) { this.rptBIHRegisterStatistics.SetDataSource(dtbResult); this.m_objViewer.crvBIHRegisterStat.ReportSource = rptBIHRegisterStatistics; this.m_objViewer.btnPrintRpt.Enabled = true; } this.m_objViewer.Cursor = Cursors.Default; }
public ReportDocument GetReportDocument() { try { var informe = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); informe.Load("Impresion Factura.rpt"); informe.SetParameterValue("Nombre", nombre); informe.SetParameterValue("Folio", folio); informe.SetParameterValue("Año", año); informe.SetParameterValue("Mes", mes); informe.SetParameterValue("Dia", dia); informe.SetParameterValue("Cantidad", cantidad); informe.SetParameterValue("Ciudad", ciudad); informe.SetParameterValue("Domicilio", domicilio); informe.SetParameterValue("IVA", iva); informe.SetParameterValue("Lugar", lugar); informe.SetParameterValue("PrecioLetra", precioLetra); informe.SetParameterValue("PrecioUnitario", precioU); informe.SetParameterValue("Previsualizacion", previsualisacion); informe.SetParameterValue("Retencion", retencion); informe.SetParameterValue("RFC", rfc); informe.SetParameterValue("Total", total); informe.SetParameterValue("Importe", importe); informe.SetParameterValue("Descripcion", descripcion); return(informe); } catch (Exception ex) { throw; } }
private void rptPDFAdjunto(String Reporte, String Nombre, String Referencia, String Importe, String Vigencia, String Concepto, String Observaciones) { System.Web.UI.Page p = new System.Web.UI.Page(); CrystalDecisions.CrystalReports.Engine.ReportDocument report = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); try { report.Load(p.Server.MapPath("~") + Reporte); report.SetParameterValue(0, Nombre); report.SetParameterValue(1, Referencia); report.SetParameterValue(2, Importe); report.SetParameterValue(3, Vigencia); report.SetParameterValue(4, Concepto); report.SetParameterValue(5, Observaciones); report.PrintOptions.PaperSize = PaperSize.PaperLetter; string archivo = p.Server.MapPath("~") + "/ArchivoReferencia/Referencia - " + Referencia + ".PDF"; report.ExportToDisk(ExportFormatType.PortableDocFormat, archivo); // "FichaReferenciada-" + Nombre.Substring(0, 15)); } catch (Exception ex) { lblMensajeCorreo.Text = ex.Message; } finally { //CR_Reportes.ReportSource = report; report.Close(); report.Dispose(); //CR_Reportes.Dispose(); } }
public void addTrinhKy_OnFormLoad() { //Ham nay XuanDT them vao try { //doan gan cac bien: doan nay co the phai thay doi ten bien cho phu hop mv_oRptDoc = RptDoc; mv_oViewDoc = this.crptViewer; //ket thuc doan gan bien mv_oRptFieldObj = mv_oRptDoc.ReportDefinition.ReportObjects["Field150181"] as FieldObject; mv_oNguoiKy = new cls_SignInfor(mv_oRptDoc.ToString(), ""); //chkPrint_CheckedChanged(chkPrint, New System.EventArgs) if (mv_oNguoiKy._TonTai) { mv_oNguoiKy.setValueToRPT(ref mv_oRptFieldObj); if (mv_bSetContent) { mv_oRptDoc.DataDefinition.FormulaFields["Formula_1"].Text = Strings.Chr(34) + mv_oNguoiKy.mv_NOI_DUNG.Replace("&NHANVIEN", globalVariables.gv_sStaffName).Replace("#$X$#", Strings.Chr(34) + "&Chr(13)&" + Strings.Chr(34)) + Strings.Chr(34); } else { mv_oRptDoc.DataDefinition.FormulaFields["Formula_1"].Text = ""; } mv_oViewDoc.ReportSource = RptDoc; } else { mv_oNguoiKy = new cls_SignInfor(mv_oRptFieldObj, "", RptDoc.ToString(), mv_oRptDoc.DataDefinition.FormulaFields["Formula_1"].Text); } } catch (Exception ex) { mv_oRptText = null; //an nut tuy chon di this.cmdTrinhKy.Visible = false; } }
/// <summary> /// 病区病人欠费一览表 /// </summary> public void m_mthShowInHospitalAdviceCharge() { if (this.m_objViewer.m_txtAREAID_CHR.Tag == null && this.m_objViewer.radioButton3.Checked) { return; } if (this.m_objViewer.m_txtPatientName.Text == "") { MessageBox.Show("先查询病人"); return; } this.m_objViewer.Cursor = Cursors.WaitCursor; DataTable dtbResult = new DataTable(); rptInHospitalLog = new ReportDocument(); rptInHospitalLog.Load(@"Report\rptPatientChargeInAdvice.rpt"); string groupid = ""; if (this.m_objViewer.m_cboChargeType.SelectedIndex >= 0) { if (this.m_objViewer.m_cboChargeType.SelectedIndex == 0) { groupid = ""; } else { groupid = ((DataTable)this.m_objViewer.m_cboChargeType.Tag).Rows[this.m_objViewer.m_cboChargeType.SelectedIndex - 1]["groupid_chr"].ToString(); } } long lngRes = 0; if (groupid == "") { lngRes = objSvc.m_lngGetPatientDebtDetail(this.m_objViewer.m_dtpStatDate.Value, this.m_objViewer.m_dtpEnd.Value, Registerid, out dtbResult); } else { string[] types; lngRes = objSvc.m_lngGetChargeItemTypesByConfigGroupID("0003", groupid, out types); lngRes = objSvc.m_lngGetPatientDebtDetail(types, this.m_objViewer.m_dtpStatDate.Value, this.m_objViewer.m_dtpEnd.Value, Registerid, out dtbResult); } if (lngRes > 0) { rptInHospitalLog.SetDataSource(dtbResult); } else { return; } rptInHospitalLog.DataDefinition.FormulaFields["AreaName"].Text = "'" + this.m_objViewer.m_txtAREAID_CHR.Text.Trim() + "'"; rptInHospitalLog.DataDefinition.FormulaFields["BedNo"].Text = "'" + this.m_objViewer.m_cboBedNo.Text.Trim() + "'"; rptInHospitalLog.DataDefinition.FormulaFields["InhospitalNo"].Text = "'" + this.m_objViewer.m_txtInpatientNo.Text.Trim() + "'"; rptInHospitalLog.DataDefinition.FormulaFields["Name"].Text = "'" + this.m_objViewer.m_txtPatientName.Text + "'"; rptInHospitalLog.DataDefinition.FormulaFields["OperatorName"].Text = "'" + this.m_objViewer.LoginInfo.m_strEmpName + "'"; rptInHospitalLog.DataDefinition.FormulaFields["Date"].Text = "'" + this.m_objViewer.m_dtpStatDate.Value.ToShortDateString() + "'"; rptInHospitalLog.DataDefinition.FormulaFields["EndDate"].Text = "'" + this.m_objViewer.m_dtpEnd.Value.ToShortDateString() + "'"; rptInHospitalLog.DataDefinition.FormulaFields["ReportName"].Text = "'" + this.ReportName + "'"; this.m_objViewer.m_crvPatientCharheDetail.ReportSource = rptInHospitalLog; this.m_objViewer.Cursor = Cursors.Default; }
/// <summary> /// 產生PDF檔案 /// </summary> private void RrintToPDF() { // 匯出檔名的設定 string sReportFileName = @"\rpt\T022_rpt.rpt"; string sMapPath = Server.MapPath(""); string sHost = Request.Url.Host; string sApplicationPath = Request.ApplicationPath; string reportID = DBCenter.GetSystemID(); string sExportFileName = Server.MapPath("../../") + @"PDF\T022_rpt" + reportID + ".pdf"; string strPath = sMapPath + sReportFileName; string ReportPath = "http://" + sHost + sApplicationPath + "/PDF/T022_rpt" + reportID + ".pdf"; DataSet dsLot = (DataSet)Session["T022View"]; rptdoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); rptdoc.Load(strPath); rptdoc.SetDataSource(dsLot); // 設定匯出路徑及檔名 DiskFileDestinationOptions df = new DiskFileDestinationOptions(); df.DiskFileName = sExportFileName; rptdoc.ExportOptions.ExportDestinationType = CrystalDecisions.Shared.ExportDestinationType.DiskFile; rptdoc.ExportOptions.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.PortableDocFormat; rptdoc.ExportOptions.DestinationOptions = df; rptdoc.Export(); rptdoc.Dispose(); //打開文件 Response.Write("<script>window.open('" + ReportPath + "','_blank','resizable,scrollbars=no,menubar=no,toolbar=no,location=no,status=no',false);</script> "); Response.Write("<script>window.close();</script>"); }
private void rptPDF_Ingresos(String Reporte, object[] Parametros, string NombreReporte) { System.Web.UI.Page p = new System.Web.UI.Page(); CrystalDecisions.CrystalReports.Engine.ReportDocument report = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); try { ConnectionInfo connectionInfo = new ConnectionInfo(); p = new System.Web.UI.Page(); report.Load(p.Server.MapPath("~") + "\\" + Reporte); for (int i = 0; i <= Parametros.Length - 1; i++) { report.SetParameterValue(i, Parametros[i]); } connectionInfo.ServerName = "dsia"; connectionInfo.UserID = "ingresos"; connectionInfo.Password = "******"; SetDBLogonForReport(connectionInfo, report); report.ExportToHttpResponse(ExportFormatType.PortableDocFormat, Response, false, NombreReporte); } catch (Exception ex) { throw new Exception(ex.Message); } finally { CR_Reportes.ReportSource = report; report.Close(); report.Dispose(); CR_Reportes.Dispose(); GC.Collect(); } }
private void rptPDFReferencia(String Reporte, String Nombre, String Referencia) { System.Web.UI.Page p = new System.Web.UI.Page(); CrystalDecisions.CrystalReports.Engine.ReportDocument report = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); try { // ConnectionInfo connectionInfo = new ConnectionInfo(); //string J = System.AppDomain.CurrentDomain.BaseDirectory + Reporte; report.Load(p.Server.MapPath("~") + Reporte); //report.Load(System.AppDomain.CurrentDomain.BaseDirectory + Reporte); report.SetParameterValue(0, Referencia); report.ExportToHttpResponse(ExportFormatType.PortableDocFormat, Response, false, "FichaReferenciada-" + Nombre.Substring(0, 15)); } catch (Exception ex) { } finally { CR_Reportes.ReportSource = report; report.Close(); report.Dispose(); CR_Reportes.Dispose(); GC.Collect(); } }
private void cmdLoad_Click(System.Object eventSender, System.EventArgs eventArgs) { ADODB.Recordset rs = default(ADODB.Recordset); ADODB.Recordset rsData = default(ADODB.Recordset); //Dim Report As New cryItemGroupCompare //ReportNone.Load("cryNoRecords.rpt") CrystalDecisions.CrystalReports.Engine.ReportDocument Report = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); CrystalDecisions.CrystalReports.Engine.ReportDocument ReportNone = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); Report.Load("cryItemGroupCompare.rpt"); ReportNone.Load("cryNoRecords"); modReport.cnnDBreport.Execute("DELETE LinkItem.* FROM LinkItem;"); rs = modReport.getRSreport(ref "SELECT * FROM Link Where LinkID=1 AND Link_SectionID=1"); modReport.cnnDBreport.Execute("INSERT INTO LinkItem ( LinkItem_LinkID, LinkItem_DayEndID, LinkItem_Value ) SELECT 1, DayEndStockItemLnk.DayEndStockItemLnk_DayEndID, DayEndStockItemLnk.DayEndStockItemLnk_QuantitySales FROM DayEndStockItemLnk INNER JOIN aStockItem ON DayEndStockItemLnk.DayEndStockItemLnk_StockItemID = aStockItem.StockItemID WHERE " + rs.Fields("Link_SQL").Value + ";"); rs = modReport.getRSreport(ref "SELECT * FROM Link Where LinkID=2 AND Link_SectionID=1"); modReport.cnnDBreport.Execute("INSERT INTO LinkItem ( LinkItem_LinkID, LinkItem_DayEndID, LinkItem_Value ) SELECT 2, DayEndStockItemLnk.DayEndStockItemLnk_DayEndID, Sum(DayEndStockItemLnk.DayEndStockItemLnk_QuantitySales) AS SumOfDayEndStockItemLnk_QuantitySales FROM DayEndStockItemLnk INNER JOIN aStockItem ON DayEndStockItemLnk.DayEndStockItemLnk_StockItemID = aStockItem.StockItemID " + rs.Fields("Link_SQL").Value + " GROUP BY DayEndStockItemLnk.DayEndStockItemLnk_DayEndID;"); System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor; rs = modReport.getRSreport(ref "SELECT Report.Report_Heading, aCompany.Company_Name FROM aCompany, Report;"); Report.SetParameterValue("txtCompanyName", rs.Fields("Company_Name")); Report.SetParameterValue("txtDayEnd", rs.Fields("Report_Heading")); rs.Close(); rs = modReport.getRSreport(ref "SELECT Link.* From Link Where (((Link.Link_SectionID) = 1)) ORDER BY Link.Link_SectionID;"); if (rs.BOF | rs.EOF) { ReportNone.SetParameterValue("txtCompanyName", Report.ParameterFields("txtCompanyName").ToString); ReportNone.SetParameterValue("txtTitle", Report.ParameterFields("txtTitle").ToString); My.MyProject.Forms.frmReportShow.Text = ReportNone.ParameterFields("txtTitle").ToString; My.MyProject.Forms.frmReportShow.CRViewer1.ReportSource = ReportNone; My.MyProject.Forms.frmReportShow.mReport = ReportNone; My.MyProject.Forms.frmReportShow.sMode = "0"; My.MyProject.Forms.frmReportShow.CRViewer1.Refresh(); System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default; My.MyProject.Forms.frmReportShow.ShowDialog(); return; } rsData = modReport.getRSreport(ref "SELECT LinkItem.*, Format([DayEnd_Date],'ddd dd mmm\", \"yyyy') AS dateName, DayEnd.DayEnd_Date FROM DayEnd INNER JOIN LinkItem ON DayEnd.DayEndID = LinkItem.LinkItem_DayEndID;"); if (rsData.BOF | rsData.EOF) { ReportNone.SetParameterValue("txtCompanyName", Report.ParameterFields("txtCompanyName").ToString); ReportNone.SetParameterValue("txtTitle", Report.ParameterFields("txtTitle").ToString); My.MyProject.Forms.frmReportShow.Text = ReportNone.ParameterFields("txtTitle").ToString; My.MyProject.Forms.frmReportShow.CRViewer1.ReportSource = ReportNone; My.MyProject.Forms.frmReportShow.mReport = ReportNone; My.MyProject.Forms.frmReportShow.sMode = "0"; My.MyProject.Forms.frmReportShow.CRViewer1.Refresh(); System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default; My.MyProject.Forms.frmReportShow.ShowDialog(); return; } Report.Database.Tables(1).SetDataSource(rs); Report.Database.Tables(2).SetDataSource(rsData); //Report.VerifyOnEveryPrint = True My.MyProject.Forms.frmReportShow.Text = Report.ParameterFields("txtTitle").ToString; My.MyProject.Forms.frmReportShow.CRViewer1.ReportSource = Report; My.MyProject.Forms.frmReportShow.mReport = Report; My.MyProject.Forms.frmReportShow.sMode = "0"; My.MyProject.Forms.frmReportShow.CRViewer1.Refresh(); System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default; My.MyProject.Forms.frmReportShow.ShowDialog(); }
private void cmdPrint_Click(System.Object eventSender, System.EventArgs eventArgs) { ADODB.Recordset rs = default(ADODB.Recordset); ADODB.Recordset rsCompany = default(ADODB.Recordset); string sql = null; CrystalDecisions.CrystalReports.Engine.ReportDocument Report = default(CrystalDecisions.CrystalReports.Engine.ReportDocument); update_Renamed(); System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor; rsCompany = modRecordSet.getRS(ref "SELECT * FROM Company"); if (this.chkChannel.CheckState) { Report.Load("cryPriceList.rpt"); sql = "SELECT Pricelist.Pricelist_Name, StockItem.StockItem_Name, Max(codCase.CatalogueChannelLnk_Price) AS codCase, Max(codCase.CatalogueChannelLnk_Quantity) AS codQuantity, codSingle.CatalogueChannelLnk_Price AS codSingle, Max(deliveryCase.CatalogueChannelLnk_Quantity) AS delQuantity, Max(deliveryCase.CatalogueChannelLnk_Price) AS delCase, deliverySingle.CatalogueChannelLnk_Price AS delSingle"; sql = sql + " FROM ShrinkItem INNER JOIN"; sql = sql + " (CatalogueChannelLnk AS deliverySingle INNER JOIN (CatalogueChannelLnk AS deliveryCase INNER JOIN ((CatalogueChannelLnk AS codCase INNER JOIN (StockItem INNER JOIN (PricelistStockItemLnk INNER JOIN Pricelist ON PricelistStockItemLnk.PricelistStockitemLnk_PricelistID = Pricelist.PricelistID) ON StockItem.StockItemID = PricelistStockItemLnk.PricelistStockitemLnk_StockitemID) ON (codCase.CatalogueChannelLnk_ChannelID = Pricelist.Pricelist_CODChannelID) AND (codCase.CatalogueChannelLnk_StockItemID = StockItem.StockItemID)) INNER JOIN CatalogueChannelLnk AS codSingle ON (StockItem.StockItemID = codSingle.CatalogueChannelLnk_StockItemID) AND (Pricelist.Pricelist_CODChannelID = codSingle.CatalogueChannelLnk_ChannelID)) ON (deliveryCase.CatalogueChannelLnk_StockItemID = StockItem.StockItemID) AND (deliveryCase.CatalogueChannelLnk_ChannelID = Pricelist.Pricelist_DeliveryChannelID)) ON (deliverySingle.CatalogueChannelLnk_ChannelID = Pricelist.Pricelist_DeliveryChannelID)"; sql = sql + " AND (deliverySingle.CatalogueChannelLnk_StockItemID = StockItem.StockItemID)) ON (ShrinkItem.ShrinkItem_Quantity = codCase.CatalogueChannelLnk_Quantity) AND (ShrinkItem.ShrinkItem_Quantity = deliveryCase.CatalogueChannelLnk_Quantity) AND (ShrinkItem.ShrinkItem_ShrinkID = StockItem.StockItem_ShrinkID)"; sql = sql + " Where (((codSingle.CatalogueChannelLnk_Quantity) = 1) And ((Pricelist.Pricelist_Disabled) = 0) And ((deliverySingle.CatalogueChannelLnk_Quantity) = 1))"; sql = sql + " GROUP BY Pricelist.Pricelist_Name, StockItem.StockItem_Name, codSingle.CatalogueChannelLnk_Price, deliverySingle.CatalogueChannelLnk_Price"; sql = sql + " ORDER BY Pricelist.Pricelist_Name, StockItem.StockItem_Name;"; } else { Report.Load("cryPriceListSingle.rpt"); sql = "SELECT Pricelist.Pricelist_Name, StockItem.StockItem_Name, Max(codCase.CatalogueChannelLnk_Price) AS codCase, Max(codCase.CatalogueChannelLnk_Quantity) AS codQuantity, codSingle.CatalogueChannelLnk_Price AS codSingle, StockItem.StockItemID "; sql = sql + "FROM ((CatalogueChannelLnk AS codCase INNER JOIN (StockItem INNER JOIN (PricelistStockItemLnk INNER JOIN Pricelist ON PricelistStockItemLnk.PricelistStockitemLnk_PricelistID = Pricelist.PricelistID) ON StockItem.StockItemID = PricelistStockItemLnk.PricelistStockitemLnk_StockitemID) ON (codCase.CatalogueChannelLnk_StockItemID = StockItem.StockItemID) AND (codCase.CatalogueChannelLnk_ChannelID = Pricelist.Pricelist_CODChannelID)) INNER JOIN CatalogueChannelLnk AS codSingle ON (Pricelist.Pricelist_CODChannelID = codSingle.CatalogueChannelLnk_ChannelID) AND (StockItem.StockItemID = codSingle.CatalogueChannelLnk_StockItemID)) INNER JOIN ShrinkItem ON (ShrinkItem.ShrinkItem_Quantity = codCase.CatalogueChannelLnk_Quantity) AND (StockItem.StockItem_ShrinkID = ShrinkItem.ShrinkItem_ShrinkID) "; sql = sql + "Where (((codSingle.CatalogueChannelLnk_Quantity) = 1) And ((Pricelist.Pricelist_Disabled) = 0)) GROUP BY Pricelist.Pricelist_Name, StockItem.StockItem_Name, codSingle.CatalogueChannelLnk_Price, StockItem.StockItemID ORDER BY Pricelist.Pricelist_Name, StockItem.StockItem_Name;"; } rs = modRecordSet.getRS(ref sql); if (rs.BOF | rs.EOF) { Interaction.MsgBox("No Price allocated!", MsgBoxStyle.Exclamation, "PRICE LIST"); return; } if (this.chkChannel.CheckState) { Report.SetParameterValue("Text3", cmbCOD.Text); Report.SetParameterValue("Text4", cmbDelivery.Text); } else { Report.SetParameterValue("Text3", cmbCOD.Text); } Report.Database.Tables(1).SetDataSource(rs); Report.Database.Tables(2).SetDataSource(rsCompany); Report.SetParameterValue("txtCompanyName", rsCompany.Fields("Company_Name")); My.MyProject.Forms.frmReportShow.Text = "Price List"; My.MyProject.Forms.frmReportShow.CRViewer1.ReportSource = Report; My.MyProject.Forms.frmReportShow.mReport = Report; My.MyProject.Forms.frmReportShow.sMode = "0"; My.MyProject.Forms.frmReportShow.CRViewer1.Refresh(); System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default; My.MyProject.Forms.frmReportShow.ShowDialog(); }
/// <summary> /// 按账务期统计 /// </summary> public void m_mthButtonClickToStatistic() { string p_strPriodId = ""; clsPeriod_VO[] objPriodItems = this.m_objViewer.m_cboSelPeriod.Tag as clsPeriod_VO[]; if (this.m_objViewer.m_cboSelPeriod.SelectedItem == null) { MessageBox.Show("请选择账务期"); return; } if (this.m_objViewer.m_cboSelPeriod.Text != "所有财务期的数据") { p_strPriodId = objPriodItems[this.m_objViewer.m_cboSelPeriod.SelectedIndex - 1].m_strPeriodID; } DataTable dtbStatistic; long lngRes = 0; lngRes = this.m_objManage.m_lngGetStatiticsData(out dtbStatistic, p_strPriodId); System.Data.DataColumn dc = new DataColumn("SEQUENCEID"); dtbStatistic.Columns.Add(dc); if (dtbStatistic.Rows.Count != 0) { for (int j1 = 0; j1 < dtbStatistic.Rows.Count; j1++) { dtbStatistic.Rows[j1]["SEQUENCEID"] = j1 + 1; } } if (lngRes < 0) { return; } else { CrystalDecisions.CrystalReports.Engine.ReportDocument rpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); rpt.Load("Report\\CrystalReportHisMedInOrderStaticstic.rpt"); // HISMedTypeManage.Rpt.CrystalReportHisMedInOrderStaticstic rpt = new HISMedTypeManage.Rpt.CrystalReportHisMedInOrderStaticstic(); ((TextObject)rpt.ReportDefinition.ReportObjects["Text11"]).Text = this.m_objViewer.m_cboSelPeriod.SelectedText; double totalMoney = 0; if (dtbStatistic.Rows.Count > 0) { for (int i1 = 0; i1 < dtbStatistic.Rows.Count; i1++) { totalMoney += Convert.ToDouble(dtbStatistic.Rows[i1]["TOLMNY_MNY"].ToString().Trim()); } //((TextObject)rpt.ReportDefinition.ReportObjects["Text9"]).Text = totalMoney.ToString("######.00"); } else { //((TextObject)rpt.ReportDefinition.ReportObjects["Text9"]).Text = "0.00"; } ((TextObject)rpt.ReportDefinition.ReportObjects["Text11"]).Text = this.m_objViewer.m_cboSelPeriod.Text; rpt.SetDataSource(dtbStatistic); rpt.Refresh(); this.m_objViewer.m_crystalReportViewer1.ReportSource = rpt; } }
void CETAK() { CrystalDecisions.CrystalReports.Engine.ReportDocument cryRpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); MASTER.REPORT.FormViewerPRICELIST frm = new MASTER.REPORT.FormViewerPRICELIST(dtPRINTB, 0); frm.ShowDialog(); }
public frmPrinter(DataTable dtDatos, CrystalDecisions.CrystalReports.Engine.ReportDocument oReporte, string cTitulo) { _Datos = dtDatos; _Reporte = oReporte; _Titulo = cTitulo; InitializeComponent(); }
public clsControlMedicineProtectReport() { // // TODO: 在此处添加构造函数逻辑 // m_rptRpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); clsDomain = new clsDcl_ReckoningReport(); }
public frmPrinter(DataTable dtDatos, CrystalDecisions.CrystalReports.Engine.ReportDocument oReporte, string cTitulo) { _Datos = dtDatos; _Reporte = oReporte; _Titulo = cTitulo; InitializeComponent(); }
public static void AddReportParameters(CrystalDecisions.CrystalReports.Engine.ReportDocument rpt, DataSet ds, bool CompanyName, string ReportName, bool Address1, bool Address2, bool City, bool phone, bool Email) { rpt.SetDataSource(ds); if (CompanyName == true) { rpt.SetParameterValue("pCompanyName", CurrentCompany.Name); } if (ReportName != "") { rpt.SetParameterValue("pReportName", ReportName); } if (Address1 == true) { rpt.SetParameterValue("pAddress1", CurrentCompany.Address1); } if (Address2 == false) { rpt.SetParameterValue("pAddress2", CurrentCompany.Address2); } if (City == true) { rpt.SetParameterValue("pCity", CurrentCompany.City); } if (phone == true) { rpt.SetParameterValue("pPhone", CurrentCompany.Phone); } if (Email == true) { rpt.SetParameterValue("pEmail", CurrentCompany.Email); } //if (State == true) //{ // rpt.SetParameterValue("pState", ""); //} //if (PinCode == true) //{ // rpt.SetParameterValue("pPinCode", CurrentCompany.Pincode); //} //if (Phone2 == true) //{ // rpt.SetParameterValue("pPhone2", CurrentCompany.Phone2); //} //if (Fax == true) //{ // rpt.SetParameterValue("pFax", CurrentCompany.Fax); //} }
protected void MostrarReporte(string ruta) { //mostrar el reporte en la pagina. reporte = new ReportDocument(); reporte.Load(Path.Combine(Request.PhysicalApplicationPath, "rpt/" + ruta + ".rpt")); reporte.SetDataSource(ds); visor.ReportSource = reporte; visor.DataBind(); reporte.ExportToDisk(ExportFormatType.WordForWindows, Path.Combine(Request.PhysicalApplicationPath, "rptgen/" + ruta + ".doc")); }
protected void Page_Init(object sender, EventArgs e) { if (Session["CurrentSchoolYearId"] == null) { Response.Redirect("~/Login.aspx"); } crdata.Report = rpt; rpt1 = crdata.ReportDocument; DataSet dsReport = new xmlClassWiseStudentAttendTime(); DataSet ds = new DataSet(); string SearchText = ""; rpt.FileName = Server.MapPath("rptDeposit.rpt"); DayCareBAL.FamilyPaymentService proxyPayment = new DayCareBAL.FamilyPaymentService(); if (!String.IsNullOrEmpty(Request.QueryString["StartDate"]) && String.IsNullOrEmpty(Request.QueryString["EndDate"])) { SearchText += " l.transactiondate>='" + Request.QueryString["StartDate"].ToString() + "'"; } if (String.IsNullOrEmpty(Request.QueryString["StartDate"]) && !String.IsNullOrEmpty(Request.QueryString["EndDate"])) { SearchText += " l.transactiondate<='" + Request.QueryString["EndDate"].ToString().Replace("00:00:00 AM", "11:59:58 PM") + "'"; } else if (!String.IsNullOrEmpty(Request.QueryString["EndDate"]) && !String.IsNullOrEmpty(Request.QueryString["StartDate"])) { SearchText += " l.transactiondate>='" + Request.QueryString["StartDate"].ToString() + "' and l.transactiondate<='" + Request.QueryString["EndDate"].ToString().Replace("00:00:00 AM", "11:59:58 PM") + "'"; } string StartDate = string.Empty; string EndDate = string.Empty; if (Request.QueryString["StartDate"] != "") { StartDate = Convert.ToDateTime(Request.QueryString["StartDate"].ToString()).ToString("MM/dd/yyyy"); } if (Request.QueryString["EndDate"] != "") { EndDate = Convert.ToDateTime(Request.QueryString["EndDate"].ToString()).ToString("MM/dd/yyyy"); } CrystalDecisions.CrystalReports.Engine.TextObject titleText = (CrystalDecisions.CrystalReports.Engine.TextObject)rpt1.ReportDefinition.ReportObjects["Text14"]; CrystalDecisions.CrystalReports.Engine.TextObject titleTextSchool = (CrystalDecisions.CrystalReports.Engine.TextObject)rpt1.ReportDefinition.ReportObjects["Text4"]; CrystalDecisions.CrystalReports.Engine.TextObject footer = (CrystalDecisions.CrystalReports.Engine.TextObject)rpt1.ReportDefinition.ReportObjects["txtfooter"]; footer.Text = Common.GetSchoolWiseAddress(new Guid(Session["SchoolId"].ToString())); titleText.Text = "Deposit Report From " + StartDate + " To " + EndDate; titleTextSchool.Text = Session["SchoolName"].ToString().ToUpper(); ds = proxyPayment.LoadPaymentDeposits(SearchText, new Guid(Session["CurrentSchoolYearId"].ToString())); dsReport.Tables["dtDiposit"].Merge(ds.Tables[0]); rpt1.SetDataSource(dsReport.Tables["dtDiposit"]); crp.DisplayGroupTree = false; crp.ReportSource = rpt1; crp.RefreshReport(); crp.DataBind(); }
public static void sbrEtiTextoLibre(int vNumLin, string[] vLins, bool vLogo, bool vCentra) { CrystalDecisions.CrystalReports.Engine.ReportDocument rpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); if (vNumLin == 3) { rpt = new rptEti3L(); } if (vNumLin == 4) { rpt = new rptEti4L(); } if (vNumLin == 5) { rpt = new rptEti5L(); } for (int i = 0; i < vNumLin; i++) { string vInf = "fLin" + (i + 1).ToString(); rpt.DataDefinition.FormulaFields[vInf].Text = "'" + vLins[i] + "'"; if (vCentra) { rpt.ReportDefinition.ReportObjects["Flin" + (i + 1).ToString() + "1"].ObjectFormat.HorizontalAlignment = CrystalDecisions.Shared.Alignment.HorizontalCenterAlign; } } rpt.ReportDefinition.ReportObjects["Picture1"].ObjectFormat.EnableSuppress = !vLogo; if (_Imp) { Application.DoEvents(); rpt.PrintOptions.PrinterName = cParamXml.PrintEtiCajaBolsa; rpt.PrintToPrinter(1, false, 0, 0); Application.DoEvents(); } else { Application.DoEvents(); Form frm = new frmVisor(); frmVisor.orpt = rpt; frm.ShowDialog(); Application.DoEvents(); } Imp = false; Application.DoEvents(); rpt.Close(); Application.DoEvents(); rpt.Dispose(); Application.DoEvents(); }
private void ShowReport(CrystalDecisions.CrystalReports.Engine.ReportDocument rpt, Boolean isDirectPrint, string strReportTitle = "") { if (isDirectPrint == true) { rpt.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.PaperA4; rpt.PrintToPrinter(1, false, 0, 0); } else { //InitialiseParameterLabels(rpt, strReportTitle); this.Show(); } }
// private Logger log; public frmPrintPreview(string FormTitle, CrystalDecisions.CrystalReports.Engine.ReportDocument RptDoc, bool pv_bSetContent, bool pv_bDisplayPrintButton) : base() { //This call is required by the Windows Form Designer. InitializeComponent(); log = LogManager.GetCurrentClassLogger(); //Add any initialization after the InitializeComponent() call this.Text = FormTitle; this.RptDoc = RptDoc; cmdTrinhKy.Visible = pv_bSetContent; mv_bSetContent = pv_bSetContent; this.crptViewer.ShowRefreshButton = false; this.crptViewer.ShowPrintButton = pv_bDisplayPrintButton; txtCopyPage.LostFocus += new EventHandler(txtSoCopyPage_LostFocus); InitializeEvents(); CauHinh(); }
private ReportDocument creaReporte(string archivoReporte) { CrystalDecisions.CrystalReports.Engine.ReportDocument Rpt1 = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); // ====== Seleccion del reporte switch (archivoReporte) { case "Solicitud": { Rpt1 = new SOPORTEC.Reportes.Solicitud(); break; } //case "equipoS": // { // Rpt1 = new Reportes.solicitudes() ; // break; // } } return Rpt1; }
// private Logger log; public frmPrintPreview(string FormTitle, CrystalDecisions.CrystalReports.Engine.ReportDocument RptDoc, bool pv_bSetContent,bool pv_bDisplayPrintButton,string TitleReport) : base() { //This call is required by the Windows Form Designer. InitializeComponent(); log = LogManager.GetCurrentClassLogger(); Utility.loadIconToForm(this); //Add any initialization after the InitializeComponent() call this.Text = FormTitle; this.RptDoc = RptDoc; this.sTIEUDE = TitleReport; this.crptViewer.ReportSource = this.RptDoc; cmdTrinhKy.Visible = pv_bSetContent; mv_bSetContent = pv_bSetContent; this.crptViewer.ShowRefreshButton = false; this.crptViewer.ShowPrintButton = pv_bDisplayPrintButton; InitializeEvents(); sTIEUDE = new cls_SignInfor().SetTieuDe(RptDoc.ToString(), sTIEUDE); }
protected void Page_Load(object sender, EventArgs e) { DataSet ds = new DataSet(); DataTable dt = new DataTable(); crvReporte.Visible = true; string fechainicial = Request.QueryString["fechainicial"].ToString(); string fechafinal = Request.QueryString["fechafinal"].ToString(); string idsede = Request.QueryString["idsede"].ToString(); string idproyecto = Request.QueryString["idproyecto"].ToString(); string idestado = Request.QueryString["idestado"].ToString(); ds = objPedidoDAO.ListarReportePedidos(AppUtilidad.stringToDateTime(fechainicial, "DD/MM/YYYY"), AppUtilidad.stringToDateTime(fechafinal, "DD/MM/YYYY"), Convert.ToInt32(idsede), Convert.ToInt32(idproyecto), idestado); dt = ds.Tables[0]; CrystalDecisions.CrystalReports.Engine.ReportDocument rDoc; rDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); rDoc.Load(Server.MapPath("rptReportePedidos.rpt")); // Your .rpt file path rDoc.SetDataSource(dt); //set dataset to the report viewer. rDoc.ExportToHttpResponse(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, Response, false, "Listado"); }
/// <summary> /// 利用 CrystalReport 列印 Excel 報表 /// </summary> /// <param name="s_FileName">Excel報表的檔名</param> /// <param name="s_rptFilePath">rpt檔的路徑</param> /// <param name="dt_Source">要列印的資料</param> /// /// <param name="reportFormatType">檔案型態</param> private void LoadCrystalReport(string s_FileName, string s_rptFilePath, DataTable dt_Source, string reportFormatType) { CrystalDecisions.CrystalReports.Engine.ReportDocument report = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); report.Load(s_rptFilePath); report.SetDataSource(dt_Source); string par_ProgramID = string.Empty; string par_LoginUser = string.Empty; DropDownList ReasonS = (DropDownList)this.SLP_CodeFileS.FindControl("D1"); DropDownList ReasonE = (DropDownList)this.SLP_CodeFileE.FindControl("D1"); string[] fileds ={ "STORE" }; DataTable Dt = SelectDistinct(dt_Source, fileds); #region 前置檢查與參數過濾 string par_S_PDate = this.SLP_SLPDateRangeOut.StartDate; string par_E_PDate = this.SLP_SLPDateRangeOut.EndDate; string par_S_ChanNo = this.SLP_StoreChainS.Text + " " + this.SLP_StoreChainS.Name; string par_E_ChanNo = this.SLP_StoreChainE.Text + " " + this.SLP_StoreChainE.Name; string par_AcceptDate = this.SLP_SLPDate.Text; string par_S_Route = this.SLP_RouteS.Text + " " + this.SLP_RouteS.Name; string par_E_Route = this.SLP_RouteE.Text + " " + this.SLP_RouteE.Name; string par_S_ReasonNo = ReasonS.SelectedValue + " " + ReasonS.SelectedItem.Text; string par_E_ReasonNo = ReasonE.SelectedValue + " " + ReasonE.SelectedItem.Text; string par_S_Store = this.SLP_StoreS.Text + " " + this.SLP_StoreS.Name; string par_E_Store = this.SLP_StoreE.Text + " " + this.SLP_StoreE.Name; par_ProgramID = this.PageCode; par_LoginUser = Session["UID"].ToString(); string par_STORE_CNT = Dt.Rows.Count.ToString(); #endregion #region 組合查詢條件至ArrayList ArrayList returnList = new ArrayList(); returnList.Clear(); report.SetParameterValue("par_S_PDate", par_S_PDate); report.SetParameterValue("par_E_PDate", par_E_PDate); report.SetParameterValue("par_S_ChanNo", par_S_ChanNo); report.SetParameterValue("par_E_ChanNo", par_E_ChanNo); report.SetParameterValue("par_AcceptDate", par_AcceptDate); report.SetParameterValue("par_S_Route", par_S_Route); report.SetParameterValue("par_E_Route", par_E_Route); report.SetParameterValue("par_S_ReasonNo", par_S_ReasonNo); report.SetParameterValue("par_E_ReasonNo", par_E_ReasonNo); report.SetParameterValue("par_S_Store", par_S_Store); report.SetParameterValue("par_E_Store", par_E_Store); report.SetParameterValue("par_ProgramID", par_ProgramID); report.SetParameterValue("par_LoginUser", par_LoginUser); report.SetParameterValue("par_STORE_CNT", par_STORE_CNT); #endregion //判斷輸出檔案型態 switch (reportFormatType) { case "EXCEL": System.IO.Stream streamXLS = report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.Excel); byte[] bytesXLS = new byte[streamXLS.Length]; streamXLS.Read(bytesXLS, 0, bytesXLS.Length); streamXLS.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"; Response.OutputStream.Write(bytesXLS, 0, bytesXLS.Length); Response.Flush(); Response.Close(); break; case "PDF": System.IO.Stream streamPDF = report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); byte[] bytesPDF = new byte[streamPDF.Length]; streamPDF.Read(bytesPDF, 0, bytesPDF.Length); streamPDF.Seek(0, System.IO.SeekOrigin.Begin); //export file Response.ClearContent(); Response.ClearHeaders(); Response.AddHeader("content-disposition", "attachment;filename=" + s_FileName);//excel檔名 Response.ContentType = "application/pdf"; Response.OutputStream.Write(bytesPDF, 0, bytesPDF.Length); Response.Flush(); Response.Close(); break; default: break; } }
private void cmdLoad_Click(System.Object eventSender, System.EventArgs eventArgs) { string sql = null; ADODB.Connection lConn = default(ADODB.Connection); ADODB.Recordset rs = default(ADODB.Recordset); ADODB.Recordset rsPurchase = default(ADODB.Recordset); ADODB.Recordset rsSales = default(ADODB.Recordset); ADODB.Recordset rsStock = default(ADODB.Recordset); ADODB.Recordset rsCompany = default(ADODB.Recordset); //Dim Report As New cryIncomeExpense CrystalDecisions.CrystalReports.Engine.ReportDocument Report = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); Report.Load("cryIncomeExpense.rpt"); //UPGRADE_WARNING: Screen property Screen.MousePointer has a new behavior. Click for more: 'ms-help://MS.VSCC.v90/dv_commoner/local/redirect.htm?keyword="6BA9B8D2-2A32-4B6E-8D36-44949974A5B4"' System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor; if (cmbMonthEnd.SelectedIndex) { lConn = modRecordSet.openConnectionInstance(ref "month" + gMonth - cmbMonthEnd.SelectedIndex + ".mdb"); if (lConn == null) return; rsStock = new ADODB.Recordset(); rsStock.CursorLocation = ADODB.CursorLocationEnum.adUseClient; sql = "SELECT DayEndStockItemLnk.DayEndStockItemLnk_DayEndID, Sum([DayEndStockItemLnk_Quantity]*[DayEndStockItemLnk_ListCost]-[DayEndStockItemLnk_QuantitySales]*[DayEndStockItemLnk_ListCost]-[DayEndStockItemLnk_QuantityShrink]*[DayEndStockItemLnk_ListCost]+[DayEndStockItemLnk_QuantityGRV]*[DayEndStockItemLnk_ListCost]) AS total, Sum([DayEndStockItemLnk_Quantity]*[DayEndStockItemLnk_ListCost]) AS opening, Sum([DayEndStockItemLnk_QuantitySales]*[DayEndStockItemLnk_ListCost]) AS sales, Sum([DayEndStockItemLnk_QuantityShrink]*[DayEndStockItemLnk_ListCost]) AS shrink, Sum([DayEndStockItemLnk_QuantityGRV]*[DayEndStockItemLnk_ListCost]) AS grv From DayEndStockItemLnk GROUP BY DayEndStockItemLnk.DayEndStockItemLnk_DayEndID;"; rsStock.Open(sql, lConn, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic); rsSales = new ADODB.Recordset(); rsSales.CursorLocation = ADODB.CursorLocationEnum.adUseClient; //UPGRADE_WARNING: Couldn't resolve default property of object sql. Click for more: 'ms-help://MS.VSCC.v90/dv_commoner/local/redirect.htm?keyword="6A50421D-15FE-4896-8A1B-2EC21E9037B2"' sql = "SELECT [M_DayEnd].[DayEndID], [M_DayEnd].[DayEnd_Date], Sum([Declaration].[Declaration_Total]) AS SumOfSale_Total FROM Declaration INNER JOIN M_DayEnd ON [Declaration].[Declaration_DayEndID]=[M_DayEnd].[DayEndID] GROUP BY [M_DayEnd].[DayEndID], [M_DayEnd].[DayEnd_Date];"; rsSales.Open(sql, lConn, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic); } else { modApplication.modUpdate = 3; modApplication.updateStockMovement(); sql = "SELECT DayEnd.DayEndID, DayEnd.DayEnd_Date, Sum(Declaration.Declaration_Total) AS SumOfSale_Total FROM Company, Declaration INNER JOIN DayEnd ON Declaration.Declaration_DayEndID = DayEnd.DayEndID Where (((DayEnd.DayEndID) <> [Company]![Company_DayEndID])) GROUP BY DayEnd.DayEndID, DayEnd.DayEnd_Date Union SELECT DayEnd.DayEndID, DayEnd.DayEnd_Date, Sum([SaleItem_Price]*[SaleItem_Quantity]) AS SumOfSale_Total FROM Consignment AS Consignment_1 RIGHT JOIN (Consignment RIGHT JOIN ((Sale INNER JOIN (Company INNER JOIN DayEnd ON Company.Company_DayEndID = DayEnd.DayEndID) ON Sale.Sale_DayEndID = DayEnd.DayEndID) INNER JOIN SaleItem ON Sale.SaleID = SaleItem.SaleItem_SaleID) ON Consignment.Consignment_SaleID = Sale.SaleID) ON Consignment_1.Consignment_ReversalSaleID = Sale.SaleID Where (((SaleItem.SaleItem_Revoke) = 0)) GROUP BY Consignment.ConsignmentID, Consignment_1.ConsignmentID, DayEnd.DayEndID, DayEnd.DayEnd_Date "; sql = sql + "HAVING (((Consignment.ConsignmentID) Is Null) AND ((Consignment_1.ConsignmentID) Is Null));"; rsSales = modRecordSet.getRS(ref sql); rsStock = modRecordSet.getRS(ref "SELECT DayEndStockItemLnk.DayEndStockItemLnk_DayEndID, Sum([DayEndStockItemLnk_Quantity]*[DayEndStockItemLnk_ListCost]-[DayEndStockItemLnk_QuantitySales]*[DayEndStockItemLnk_ListCost]-[DayEndStockItemLnk_QuantityShrink]*[DayEndStockItemLnk_ListCost]+[DayEndStockItemLnk_QuantityGRV]*[DayEndStockItemLnk_ListCost]) AS total, Sum([DayEndStockItemLnk_Quantity]*[DayEndStockItemLnk_ListCost]) AS opening, Sum([DayEndStockItemLnk_QuantitySales]*[DayEndStockItemLnk_ListCost]) AS sales, Sum([DayEndStockItemLnk_QuantityShrink]*[DayEndStockItemLnk_ListCost]) AS shrink, Sum([DayEndStockItemLnk_QuantityGRV]*[DayEndStockItemLnk_ListCost]) AS grv From DayEndStockItemLnk GROUP BY DayEndStockItemLnk.DayEndStockItemLnk_DayEndID;"); } rsPurchase = modRecordSet.getRS(ref "SELECT DayEnd.DayEndID, DayEnd.DayEnd_Date, Sum(grvPosted.GRV_InvoiceInclusive) AS SumOfGRV_InvoiceInclusive, ([MonthEnd_BudgetSales]/[MonthEnd_Days]) AS saleBudget, ([MonthEnd_BudgetPurchases]/[MonthEnd_Days]) AS purchaseBudget FROM [SELECT GRV.* From GRV WHERE (((GRV.GRV_GRVStatusID)=3))]. AS grvPosted RIGHT JOIN (DayEnd INNER JOIN MonthEnd ON DayEnd.DayEnd_MonthEndID = MonthEnd.MonthEndID) ON grvPosted.GRV_DayEndID = DayEnd.DayEndID Where (((MonthEnd.MonthEndID) = " + gMonth - cmbMonthEnd.SelectedIndex + ")) GROUP BY DayEnd.DayEndID, DayEnd.DayEnd_Date, ([MonthEnd_BudgetSales]/[MonthEnd_Days]), ([MonthEnd_BudgetPurchases]/[MonthEnd_Days]);"); rsCompany = modRecordSet.getRS(ref "SELECT MonthEnd.* From MonthEnd WHERE (((MonthEnd.MonthEndID)=" + gMonth - cmbMonthEnd.SelectedIndex + "));"); rs = modRecordSet.getRS(ref "SELECT * FROM Company"); Report.SetParameterValue("txtCompanyName", rs.Fields("Company_Name")); rs.Close(); //ReportNone.Load("cryNoRecords.rpt") CrystalDecisions.CrystalReports.Engine.ReportDocument ReportNone = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); ReportNone.Load("cryNoRecords.rpt"); if (rsPurchase.BOF | rsPurchase.EOF) { ReportNone.SetParameterValue("txtCompanyName", Report.ParameterFields("txtCompanyName").ToString); ReportNone.SetParameterValue("txtTitle", Report.ParameterFields("txtTitle").ToString); My.MyProject.Forms.frmReportShow.Text = ReportNone.ParameterFields("txtTitle").ToString; My.MyProject.Forms.frmReportShow.CRViewer1.ReportSource = ReportNone; My.MyProject.Forms.frmReportShow.mReport = ReportNone; My.MyProject.Forms.frmReportShow.sMode = "0"; My.MyProject.Forms.frmReportShow.CRViewer1.Refresh(); System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default; My.MyProject.Forms.frmReportShow.ShowDialog(); return; } //Report.Database.SetDataSource(rs) Report.Database.Tables(1).SetDataSource(rsPurchase); Report.Database.Tables(2).SetDataSource(rsSales); Report.Database.Tables(3).SetDataSource(rsStock); Report.Database.Tables(4).SetDataSource(rsCompany); //UPGRADE_WARNING: Couldn't resolve default property of object Report.VerifyOnEveryPrint. Click for more: 'ms-help://MS.VSCC.v90/dv_commoner/local/redirect.htm?keyword="6A50421D-15FE-4896-8A1B-2EC21E9037B2"' //Report.VerifyOnEveryPrint = True My.MyProject.Forms.frmReportShow.Text = Report.ParameterFields("txtTitle").ToString; My.MyProject.Forms.frmReportShow.CRViewer1.ReportSource = Report; My.MyProject.Forms.frmReportShow.mReport = Report; My.MyProject.Forms.frmReportShow.sMode = "0"; My.MyProject.Forms.frmReportShow.CRViewer1.Refresh(); System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default; My.MyProject.Forms.frmReportShow.ShowDialog(); if (lConn == null) { } else { lConn.Close(); } }
/// <summary> /// 利用 CrystalReport 列印 Excel 報表 /// </summary> /// <param name="s_FileName">Excel報表的檔名</param> /// <param name="s_rptFilePath">rpt檔的路徑</param> /// <param name="dt_Source">要列印的資料</param> /// /// <param name="reportFormatType">檔案型態</param> private void LoadCrystalReport(string s_FileName, string s_rptFilePath, DataTable dt_Source, string reportFormatType) { CrystalDecisions.CrystalReports.Engine.ReportDocument report = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); report.Load(s_rptFilePath); report.SetDataSource(dt_Source); string par_ProgramID = string.Empty; string par_LoginUser = string.Empty; #region 前置檢查與參數過濾 string par_S_PDate = this.SLP_SLPDateRange.StartDate; string par_E_PDate = this.SLP_SLPDateRange.EndDate; string par_BatchNo = this.txtBatchNo.Text; string par_ChanNo = this.SLP_StoreChain.Text + " " + this.SLP_StoreChain.Name; string par_ChanSourceNo = this.txtChanSourceNo.Text; string par_S_SignDate = this.SLP_SignDate.StartDate; string par_E_SignDate = this.SLP_SignDate.EndDate; string par_Item = this.SLP_SKU.Text + " " + this.SLP_SKU.Name; string par_Period = this.SLP_ItemPeriod.Text + " " + this.SLP_ItemPeriod.Name; string par_ItemMap = this.txtItemMap.Text; par_ProgramID = this.PageCode; par_LoginUser = Session["UID"].ToString(); #endregion #region 組合查詢條件至ArrayList ArrayList returnList = new ArrayList(); returnList.Clear(); report.SetParameterValue("par_S_PDate", par_S_PDate); report.SetParameterValue("par_E_PDate", par_E_PDate); report.SetParameterValue("par_BatchNo", par_BatchNo); report.SetParameterValue("par_ChanNo", par_ChanNo); report.SetParameterValue("par_ChanSourceNo", par_ChanSourceNo); report.SetParameterValue("par_S_SignDate", par_S_SignDate); report.SetParameterValue("par_E_SignDate", par_E_SignDate); report.SetParameterValue("par_Item", par_Item); report.SetParameterValue("par_Period", par_Period); report.SetParameterValue("par_ItemMap", par_ItemMap); report.SetParameterValue("par_ProgramID", par_ProgramID); report.SetParameterValue("par_LoginUser", par_LoginUser); #endregion //判斷輸出檔案型態 switch (reportFormatType) { case "EXCEL": System.IO.Stream streamXLS = report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.Excel); byte[] bytesXLS = new byte[streamXLS.Length]; streamXLS.Read(bytesXLS, 0, bytesXLS.Length); streamXLS.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"; Response.OutputStream.Write(bytesXLS, 0, bytesXLS.Length); Response.Flush(); Response.Close(); break; case "PDF": System.IO.Stream streamPDF = report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); byte[] bytesPDF = new byte[streamPDF.Length]; streamPDF.Read(bytesPDF, 0, bytesPDF.Length); streamPDF.Seek(0, System.IO.SeekOrigin.Begin); //export file Response.ClearContent(); Response.ClearHeaders(); Response.AddHeader("content-disposition", "attachment;filename=" + s_FileName);//excel檔名 Response.ContentType = "application/pdf"; Response.OutputStream.Write(bytesPDF, 0, bytesPDF.Length); Response.Flush(); Response.Close(); break; default: break; } }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.report = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); // // report // this.report.PrintOptions.PaperOrientation = CrystalDecisions.Shared.PaperOrientation.Portrait; this.report.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.PaperLetter; this.report.PrintOptions.PaperSource = CrystalDecisions.Shared.PaperSource.Upper; this.report.PrintOptions.PrinterDuplex = CrystalDecisions.Shared.PrinterDuplex.Default; }
/// //////////////////////////////////////////////////////////////////////// /// EVENTS /// protected void Page_Load(object sender, System.EventArgs e) { //--- Security check if (!Convert.ToBoolean(Session["sgLFS_APP_VIEW"])) { Response.Redirect("./../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator."); } //--- Validate query string if ((Request.QueryString["target_report"] == null) || (Request.QueryString["format"] == null)) { Response.Redirect("./../error_page.aspx?error=" + "Invalid query string in viewer.aspx"); } //--- Initialize bool empty = false; LFSRecordForReportsGateway lfsRecordForReportsGateway = new LFSRecordForReportsGateway(); //--- Get report data #region Get report data switch (Request.QueryString["target_report"]) { //--- CXIRemovedReport case "CXIRemovedReport": TDSCXIRemovedReport dataSet = lfsRecordForReportsGateway.GetCXIRemovedReportByCompanyId(Convert.ToInt32(Session["companyID"])); if (dataSet.CXIRemovedReport.Rows.Count > 0) { report = new rCXIRemovedReport(); report.SetDataSource(dataSet); if (Request.QueryString["format"] == "pdf") { ((Section)report.ReportDefinition.Sections["sReportHeader"]).SectionFormat.EnableSuppress = true; ((Section)report.ReportDefinition.Sections["sPageHeader"]).SectionFormat.EnableSuppress = false; ((Section)report.ReportDefinition.Sections["sPageFooter"]).SectionFormat.EnableSuppress = false; } else { ((Section)report.ReportDefinition.Sections["sReportHeader"]).SectionFormat.EnableSuppress = false; ((Section)report.ReportDefinition.Sections["sPageHeader"]).SectionFormat.EnableSuppress = true; ((Section)report.ReportDefinition.Sections["sPageFooter"]).SectionFormat.EnableSuppress = true; } report.PrintOptions.PaperOrientation = PaperOrientation.Portrait; report.PrintOptions.PaperSize = PaperSize.PaperLetter; } else { empty = true; } break; //--- ReadyForLining case "ReadyForLining": TDSReadyForLining tdsReadyForLining = lfsRecordForReportsGateway.GetReadyForLiningByCompanyId(Convert.ToInt32(Session["companyID"]), Convert.ToBoolean(Request.QueryString["all_clients"]), Convert.ToInt32(Request.QueryString["companies_id"])); if (tdsReadyForLining.ReadyForLining.Rows.Count > 0) { report = new rReadyForLining(); report.SetDataSource(tdsReadyForLining); if (Request.QueryString["format"] == "pdf") { ((Section)report.ReportDefinition.Sections["sReportHeader"]).SectionFormat.EnableSuppress = true; ((Section)report.ReportDefinition.Sections["sPageHeader"]).SectionFormat.EnableSuppress = false; ((Section)report.ReportDefinition.Sections["sPageFooter"]).SectionFormat.EnableSuppress = false; } else { ((Section)report.ReportDefinition.Sections["sReportHeader"]).SectionFormat.EnableSuppress = false; ((Section)report.ReportDefinition.Sections["sPageHeader"]).SectionFormat.EnableSuppress = true; ((Section)report.ReportDefinition.Sections["sPageFooter"]).SectionFormat.EnableSuppress = true; } report.PrintOptions.PaperOrientation = PaperOrientation.Landscape; report.PrintOptions.PaperSize = PaperSize.PaperLegal; } else { empty = true; } break; //--- ToBePrepped case "ToBePrepped": TDSToBePrepped tdsToBePrepped = lfsRecordForReportsGateway.GetToBePreppedByCompanyId(Convert.ToInt32(Session["companyID"]), Convert.ToBoolean(Request.QueryString["all_clients"]), Convert.ToInt32(Request.QueryString["companies_id"])); if (tdsToBePrepped.ToBePrepped.Rows.Count > 0) { report = new rToBePrepped(); report.SetDataSource(tdsToBePrepped); if (Request.QueryString["format"] == "pdf") { ((Section)report.ReportDefinition.Sections["sReportHeader"]).SectionFormat.EnableSuppress = true; ((Section)report.ReportDefinition.Sections["sPageHeader"]).SectionFormat.EnableSuppress = false; ((Section)report.ReportDefinition.Sections["sPageFooter"]).SectionFormat.EnableSuppress = false; } else { ((Section)report.ReportDefinition.Sections["sReportHeader"]).SectionFormat.EnableSuppress = false; ((Section)report.ReportDefinition.Sections["sPageHeader"]).SectionFormat.EnableSuppress = true; ((Section)report.ReportDefinition.Sections["sPageFooter"]).SectionFormat.EnableSuppress = true; } report.PrintOptions.PaperOrientation = PaperOrientation.Landscape; report.PrintOptions.PaperSize = PaperSize.PaperLegal; } else { empty = true; } break; //--- ToBeMeasured case "ToBeMeasured": TDSToBeMeasured tdsToBeMeasured = lfsRecordForReportsGateway.GetToBeMeasuredByCompanyId(Convert.ToInt32(Session["companyID"]), Convert.ToBoolean(Request.QueryString["all_clients"]), Convert.ToInt32(Request.QueryString["companies_id"])); if (tdsToBeMeasured.ToBeMeasured.Rows.Count > 0) { report = new rToBeMeasured(); report.SetDataSource(tdsToBeMeasured); if (Request.QueryString["format"] == "pdf") { ((Section)report.ReportDefinition.Sections["sReportHeader"]).SectionFormat.EnableSuppress = true; ((Section)report.ReportDefinition.Sections["sPageHeader"]).SectionFormat.EnableSuppress = false; ((Section)report.ReportDefinition.Sections["sPageFooter"]).SectionFormat.EnableSuppress = false; } else { ((Section)report.ReportDefinition.Sections["sReportHeader"]).SectionFormat.EnableSuppress = false; ((Section)report.ReportDefinition.Sections["sPageHeader"]).SectionFormat.EnableSuppress = true; ((Section)report.ReportDefinition.Sections["sPageFooter"]).SectionFormat.EnableSuppress = true; } report.PrintOptions.PaperOrientation = PaperOrientation.Landscape; report.PrintOptions.PaperSize = PaperSize.PaperLegal; } else { empty = true; } break; //--- LiningCompleted case "LiningCompleted": TDSLiningCompleted tdsLiningCompleted = lfsRecordForReportsGateway.GetLiningCompletedByCompanyId(Convert.ToInt32(Session["companyID"]), Convert.ToBoolean(Request.QueryString["all_clients"]), Convert.ToInt32(Request.QueryString["companies_id"]), Convert.ToDateTime(Request.QueryString["start_date"]), Convert.ToDateTime(Request.QueryString["end_date"])); if (tdsLiningCompleted.LiningCompleted.Rows.Count > 0) { report = new rLiningCompleted(); report.SetDataSource(tdsLiningCompleted); if (Request.QueryString["format"] == "pdf") { ((Section)report.ReportDefinition.Sections["sReportHeader"]).SectionFormat.EnableSuppress = true; ((Section)report.ReportDefinition.Sections["sPageHeader"]).SectionFormat.EnableSuppress = false; ((Section)report.ReportDefinition.Sections["sPageFooter"]).SectionFormat.EnableSuppress = false; } else { ((Section)report.ReportDefinition.Sections["sReportHeader"]).SectionFormat.EnableSuppress = false; ((Section)report.ReportDefinition.Sections["sPageHeader"]).SectionFormat.EnableSuppress = true; ((Section)report.ReportDefinition.Sections["sPageFooter"]).SectionFormat.EnableSuppress = true; } report.PrintOptions.PaperOrientation = PaperOrientation.Portrait; report.PrintOptions.PaperSize = PaperSize.PaperLetter; } else { empty = true; } break; //--- OverviewReport case "OverviewReport": TDSOverviewReport tdsOverviewReport = lfsRecordForReportsGateway.GetOverviewReportByCompanyId(Convert.ToInt32(Session["companyID"]), Convert.ToBoolean(Request.QueryString["all_clients"]), Convert.ToInt32(Request.QueryString["companies_id"])); if (tdsOverviewReport.OverviewReport.Rows.Count > 0) { report = new rOverviewReport(); report.SetDataSource(tdsOverviewReport); if (Request.QueryString["format"] == "pdf") { ((Section)report.ReportDefinition.Sections["sReportHeader"]).SectionFormat.EnableSuppress = true; ((Section)report.ReportDefinition.Sections["sPageHeader"]).SectionFormat.EnableSuppress = false; ((Section)report.ReportDefinition.Sections["sPageFooter"]).SectionFormat.EnableSuppress = false; } else { ((Section)report.ReportDefinition.Sections["sReportHeader"]).SectionFormat.EnableSuppress = false; ((Section)report.ReportDefinition.Sections["sPageHeader"]).SectionFormat.EnableSuppress = true; ((Section)report.ReportDefinition.Sections["sPageFooter"]).SectionFormat.EnableSuppress = true; } report.PrintOptions.PaperOrientation = PaperOrientation.Landscape; report.PrintOptions.PaperSize = PaperSize.PaperLegal; } else { empty = true; } break; //--- RehabAssessmentAreas case "RehabAssessmentAreas": TDSRehabAssessmentAreas tdsRehabAssessmentAreas = lfsRecordForReportsGateway.GetRehabAssessmentAreasByCompanyId(Convert.ToInt32(Session["companyID"]), Convert.ToBoolean(Request.QueryString["all_clients"]), Convert.ToInt32(Request.QueryString["companies_id"])); if (tdsRehabAssessmentAreas.RehabAssessmentAreas.Rows.Count > 0) { report = new rRehabAssessmentAreas(); report.SetDataSource(tdsRehabAssessmentAreas); if (Request.QueryString["format"] == "pdf") { ((Section)report.ReportDefinition.Sections["sReportHeader"]).SectionFormat.EnableSuppress = true; ((Section)report.ReportDefinition.Sections["sPageHeader"]).SectionFormat.EnableSuppress = false; ((Section)report.ReportDefinition.Sections["sPageFooter"]).SectionFormat.EnableSuppress = false; } else { ((Section)report.ReportDefinition.Sections["sReportHeader"]).SectionFormat.EnableSuppress = false; ((Section)report.ReportDefinition.Sections["sPageHeader"]).SectionFormat.EnableSuppress = true; ((Section)report.ReportDefinition.Sections["sPageFooter"]).SectionFormat.EnableSuppress = true; } report.PrintOptions.PaperOrientation = PaperOrientation.Landscape; report.PrintOptions.PaperSize = PaperSize.PaperLegal; } else { empty = true; } break; //--- AllOutstandingIssues case "AllOutstandingIssues": TDSAllOutstandingIssues tdsAllOutstandingIssues = lfsRecordForReportsGateway.GetAllOutstandingIssuesByCompanyId(Convert.ToInt32(Session["companyID"]), Convert.ToBoolean(Request.QueryString["all_clients"]), Convert.ToInt32(Request.QueryString["companies_id"])); if (tdsAllOutstandingIssues.AllOutstandingIssues.Rows.Count > 0) { report = new rAllOutstandingIssues(); report.SetDataSource(tdsAllOutstandingIssues); if (Request.QueryString["format"] == "pdf") { ((Section)report.ReportDefinition.Sections["sReportHeader"]).SectionFormat.EnableSuppress = true; ((Section)report.ReportDefinition.Sections["sPageHeader"]).SectionFormat.EnableSuppress = false; ((Section)report.ReportDefinition.Sections["sPageFooter"]).SectionFormat.EnableSuppress = false; } else { ((Section)report.ReportDefinition.Sections["sReportHeader"]).SectionFormat.EnableSuppress = false; ((Section)report.ReportDefinition.Sections["sPageHeader"]).SectionFormat.EnableSuppress = true; ((Section)report.ReportDefinition.Sections["sPageFooter"]).SectionFormat.EnableSuppress = true; } report.PrintOptions.PaperOrientation = PaperOrientation.Landscape; report.PrintOptions.PaperSize = PaperSize.PaperLetter; } else { empty = true; } break; //--- OutstandingClientIssues case "OutstandingClientIssues": TDSOutstandingClientIssues tdsOutstandingClientIssues = lfsRecordForReportsGateway.GetOutstandingClientIssuesByCompanyId(Convert.ToInt32(Session["companyID"]), Convert.ToBoolean(Request.QueryString["all_clients"]), Convert.ToInt32(Request.QueryString["companies_id"])); if (tdsOutstandingClientIssues.OutstandingClientIssues.Rows.Count > 0) { report = new rOutstandingClientIssues(); report.SetDataSource(tdsOutstandingClientIssues); if (Request.QueryString["format"] == "pdf") { ((Section)report.ReportDefinition.Sections["sReportHeader"]).SectionFormat.EnableSuppress = true; ((Section)report.ReportDefinition.Sections["sPageHeader"]).SectionFormat.EnableSuppress = false; ((Section)report.ReportDefinition.Sections["sPageFooter"]).SectionFormat.EnableSuppress = false; } else { ((Section)report.ReportDefinition.Sections["sReportHeader"]).SectionFormat.EnableSuppress = false; ((Section)report.ReportDefinition.Sections["sPageHeader"]).SectionFormat.EnableSuppress = true; ((Section)report.ReportDefinition.Sections["sPageFooter"]).SectionFormat.EnableSuppress = true; } report.PrintOptions.PaperOrientation = PaperOrientation.Portrait; report.PrintOptions.PaperSize = PaperSize.PaperLetter; } else { empty = true; } break; //--- OutstandingLFSIssues case "OutstandingLFSIssues": TDSOutstandingLFSIssues tdsOutstandingLFSIssues = lfsRecordForReportsGateway.GetOutstandingLFSIssuesByCompanyId(Convert.ToInt32(Session["companyID"]), Convert.ToBoolean(Request.QueryString["all_clients"]), Convert.ToInt32(Request.QueryString["companies_id"])); if (tdsOutstandingLFSIssues.OutstandingLFSIssues.Rows.Count > 0) { report = new rOutstandingLFSIssues(); report.SetDataSource(tdsOutstandingLFSIssues); if (Request.QueryString["format"] == "pdf") { ((Section)report.ReportDefinition.Sections["sReportHeader"]).SectionFormat.EnableSuppress = true; ((Section)report.ReportDefinition.Sections["sPageHeader"]).SectionFormat.EnableSuppress = false; ((Section)report.ReportDefinition.Sections["sPageFooter"]).SectionFormat.EnableSuppress = false; } else { ((Section)report.ReportDefinition.Sections["sReportHeader"]).SectionFormat.EnableSuppress = false; ((Section)report.ReportDefinition.Sections["sPageHeader"]).SectionFormat.EnableSuppress = true; ((Section)report.ReportDefinition.Sections["sPageFooter"]).SectionFormat.EnableSuppress = true; } report.PrintOptions.PaperOrientation = PaperOrientation.Portrait; report.PrintOptions.PaperSize = PaperSize.PaperLetter; } else { empty = true; } break; //--- OutstandingInvestigationIssues case "OutstandingInvestigationIssues": TDSOutstandingInvestigationIssues tdsOutstandingInvestigationIssues = lfsRecordForReportsGateway.GetOutstandingInvestigacionIssuesByCompanyId(Convert.ToInt32(Session["companyID"]), Convert.ToBoolean(Request.QueryString["all_clients"]), Convert.ToInt32(Request.QueryString["companies_id"])); if (tdsOutstandingInvestigationIssues.OutstandingInvestigationUssue.Rows.Count > 0) { report = new rOutstandingInvestigationIssues(); report.SetDataSource(tdsOutstandingInvestigationIssues); if (Request.QueryString["format"] == "pdf") { ((Section)report.ReportDefinition.Sections["sReportHeader"]).SectionFormat.EnableSuppress = true; ((Section)report.ReportDefinition.Sections["sPageHeader"]).SectionFormat.EnableSuppress = false; ((Section)report.ReportDefinition.Sections["sPageFooter"]).SectionFormat.EnableSuppress = false; } else { ((Section)report.ReportDefinition.Sections["sReportHeader"]).SectionFormat.EnableSuppress = false; ((Section)report.ReportDefinition.Sections["sPageHeader"]).SectionFormat.EnableSuppress = true; ((Section)report.ReportDefinition.Sections["sPageFooter"]).SectionFormat.EnableSuppress = true; } report.PrintOptions.PaperOrientation = PaperOrientation.Portrait; report.PrintOptions.PaperSize = PaperSize.PaperLetter; } else { empty = true; } break; //--- OutstandingSalesIssues case "OutstandingSalesIssues": TDSOutstandingSalesIssues tdsOutstandingSalesIssues = lfsRecordForReportsGateway.GetOutstandingSalesIssuesByCompanyId(Convert.ToInt32(Session["companyID"]), Convert.ToBoolean(Request.QueryString["all_clients"]), Convert.ToInt32(Request.QueryString["companies_id"])); if (tdsOutstandingSalesIssues.OutstandingSalesIssues.Rows.Count > 0) { report = new rOutstandingSalesIssues(); report.SetDataSource(tdsOutstandingSalesIssues); if (Request.QueryString["format"] == "pdf") { ((Section)report.ReportDefinition.Sections["sReportHeader"]).SectionFormat.EnableSuppress = true; ((Section)report.ReportDefinition.Sections["sPageHeader"]).SectionFormat.EnableSuppress = false; ((Section)report.ReportDefinition.Sections["sPageFooter"]).SectionFormat.EnableSuppress = false; } else { ((Section)report.ReportDefinition.Sections["sReportHeader"]).SectionFormat.EnableSuppress = false; ((Section)report.ReportDefinition.Sections["sPageHeader"]).SectionFormat.EnableSuppress = true; ((Section)report.ReportDefinition.Sections["sPageFooter"]).SectionFormat.EnableSuppress = true; } report.PrintOptions.PaperOrientation = PaperOrientation.Portrait; report.PrintOptions.PaperSize = PaperSize.PaperLetter; } else { empty = true; } break; //--- ClientInvestigationIssuesCityCopy case "ClientInvestigationIssuesCityCopy": TDSClientInvestigationIssuesCityCopy tdsClientInvestigationIssuesCityCopy = lfsRecordForReportsGateway.GetClientInvestigationIssuesCityCopyByCompanyId(Convert.ToInt32(Session["companyID"]), Convert.ToBoolean(Request.QueryString["all_clients"]), Convert.ToInt32(Request.QueryString["companies_id"])); if (tdsClientInvestigationIssuesCityCopy.ClientInvestigationIssuesCityCopy.Rows.Count > 0) { report = new rClientInvestigationIssuesCityCopy(); report.SetDataSource(tdsClientInvestigationIssuesCityCopy); if (Request.QueryString["format"] == "pdf") { ((Section)report.ReportDefinition.Sections["sReportHeader"]).SectionFormat.EnableSuppress = true; ((Section)report.ReportDefinition.Sections["sPageHeader"]).SectionFormat.EnableSuppress = false; ((Section)report.ReportDefinition.Sections["sPageFooter"]).SectionFormat.EnableSuppress = false; } else { ((Section)report.ReportDefinition.Sections["sReportHeader"]).SectionFormat.EnableSuppress = false; ((Section)report.ReportDefinition.Sections["sPageHeader"]).SectionFormat.EnableSuppress = true; ((Section)report.ReportDefinition.Sections["sPageFooter"]).SectionFormat.EnableSuppress = true; } report.PrintOptions.PaperOrientation = PaperOrientation.Portrait; report.PrintOptions.PaperSize = PaperSize.PaperLetter; } else { empty = true; } break; //--- PointLinerReport case "PointLinerReport": TDSPointLinerReport tdsPointLinerReport = lfsRecordForReportsGateway.GetPointLinerReportByCompanyId(Convert.ToInt32(Session["companyID"]), Convert.ToBoolean(Request.QueryString["all_clients"]), Convert.ToInt32(Request.QueryString["companies_id"])); if (tdsPointLinerReport.PointLinerReport.Rows.Count > 0) { report = new rPointLinerReport(); report.SetDataSource(tdsPointLinerReport); if (Request.QueryString["format"] == "pdf") { ((Section)report.ReportDefinition.Sections["sReportHeader"]).SectionFormat.EnableSuppress = true; ((Section)report.ReportDefinition.Sections["sPageHeader"]).SectionFormat.EnableSuppress = false; ((Section)report.ReportDefinition.Sections["sPageFooter"]).SectionFormat.EnableSuppress = false; } else { ((Section)report.ReportDefinition.Sections["sReportHeader"]).SectionFormat.EnableSuppress = false; ((Section)report.ReportDefinition.Sections["sPageHeader"]).SectionFormat.EnableSuppress = true; ((Section)report.ReportDefinition.Sections["sPageFooter"]).SectionFormat.EnableSuppress = true; } report.PrintOptions.PaperOrientation = PaperOrientation.Landscape; report.PrintOptions.PaperSize = PaperSize.PaperLegal; } else { empty = true; } break; //--- PointLinerScopeSheet case "PointLinerScopeSheet": TDSPointLinerScopeSheet tdsPointLinerScopeSheet = lfsRecordForReportsGateway.GetPointLinerScopeSheetByCompanyId(Convert.ToInt32(Session["companyID"]), Convert.ToBoolean(Request.QueryString["all_clients"]), Convert.ToInt32(Request.QueryString["companies_id"])); if (tdsPointLinerScopeSheet.PointLinerScopeSheet.Rows.Count > 0) { report = new rPointLinerScopeSheet(); report.SetDataSource(tdsPointLinerScopeSheet); report.PrintOptions.PaperOrientation = PaperOrientation.Portrait; report.PrintOptions.PaperSize = PaperSize.PaperLegal; } else { empty = true; } break; //--- OutstandingPointRepairs case "OutstandingPointRepairsReport": TDSOutstandingPointRepairs tdsOutstandingPointRepairs = lfsRecordForReportsGateway.GetOutstandingPointRepairsCompanyIdCompaniesId(Convert.ToInt32(Session["companyID"]), Convert.ToBoolean(Request.QueryString["all_clients"]), Convert.ToInt32(Request.QueryString["companies_id"])); if (tdsOutstandingPointRepairs.OutstandingPointRepairs.Rows.Count > 0) { //--- Report creation and data binding report = new rOutstandingPointRepairs(); report.SetDataSource(tdsOutstandingPointRepairs); //--- Format control if (Request.QueryString["format"] == "pdf") { ((Section)report.ReportDefinition.Sections["sReportHeader"]).SectionFormat.EnableSuppress = true; ((Section)report.ReportDefinition.Sections["sPageHeader"]).SectionFormat.EnableSuppress = false; ((Section)report.ReportDefinition.Sections["sPageFooter"]).SectionFormat.EnableSuppress = false; } else { ((Section)report.ReportDefinition.Sections["sReportHeader"]).SectionFormat.EnableSuppress = false; ((Section)report.ReportDefinition.Sections["sPageHeader"]).SectionFormat.EnableSuppress = true; ((Section)report.ReportDefinition.Sections["sPageFooter"]).SectionFormat.EnableSuppress = true; } //--- Report format report.PrintOptions.PaperOrientation = PaperOrientation.Landscape; report.PrintOptions.PaperSize = PaperSize.PaperLegal; } else { empty = true; } break; //--- M1ReportByClient case "M1ReportByClient": TDSM1ReportByClient tdsM1ReportByClient; if ((Request.QueryString["id"] != "0") && (Request.QueryString["companies"] == "0") && (Request.QueryString["date"] == "0")) { tdsM1ReportByClient = lfsRecordForReportsGateway.GetM1ReportByClientByCompanyIdByID(Convert.ToInt32(Session["companyID"]), Request.QueryString["id"]); } else if ((Request.QueryString["id"] == "0") && (Convert.ToInt32(Request.QueryString["companies"]) != 0) && (Request.QueryString["date"] == "0")) { tdsM1ReportByClient = lfsRecordForReportsGateway.GetM1ReportByClientByCompanyIdByCompanies(Convert.ToInt32(Session["companyID"]), Convert.ToInt32(Request.QueryString["companies"])); } else { tdsM1ReportByClient = lfsRecordForReportsGateway.GetM1ReportByClientByCompanyIdByDate(Convert.ToInt32(Session["companyID"]), Request.QueryString["date"]); } if (tdsM1ReportByClient.M1ReportByClient.Rows.Count > 0) { report = new rM1ReportByClient(); report.SetDataSource(tdsM1ReportByClient); if (Request.QueryString["format"] == "pdf") { ((Section)report.ReportDefinition.Sections["sPageFooter"]).SectionFormat.EnableSuppress = false; } else { ((Section)report.ReportDefinition.Sections["sPageFooter"]).SectionFormat.EnableSuppress = true; } report.PrintOptions.PaperOrientation = PaperOrientation.Portrait; report.PrintOptions.PaperSize = PaperSize.PaperLetter; } else { empty = true; } break; //--- M2ReportByID case "M2ReportByID": TDSM2ReportByID tdsM2ReportByID; if ((Request.QueryString["id"] != "0") && (Request.QueryString["companies"] == "0") && (Request.QueryString["date"] == "0")) { tdsM2ReportByID = lfsRecordForReportsGateway.GetM2ReportByIDByCompanyIdById(Convert.ToInt32(Session["companyID"]), Request.QueryString["id"]); } else if ((Request.QueryString["id"] == "0") && (Convert.ToInt32(Request.QueryString["companies"]) != 0) && (Request.QueryString["date"] == "0")) { tdsM2ReportByID = lfsRecordForReportsGateway.GetM2ReportByIDByCompanyIdByCompanies(Convert.ToInt32(Session["companyID"]), Convert.ToInt32(Request.QueryString["companies"])); } else { tdsM2ReportByID = lfsRecordForReportsGateway.GetM2ReportByIDByCompanyIdByDate(Convert.ToInt32(Session["companyID"]), Request.QueryString["date"]); } if (tdsM2ReportByID.LFS_MASTER_AREA.Rows.Count > 0) { report = new rM2ReportByID(); report.SetDataSource(tdsM2ReportByID); if (Request.QueryString["format"] == "pdf") { ((Section)report.ReportDefinition.Sections["sPageFooter"]).SectionFormat.EnableSuppress = false; } else { ((Section)report.ReportDefinition.Sections["sPageFooter"]).SectionFormat.EnableSuppress = true; } report.PrintOptions.PaperOrientation = PaperOrientation.Landscape; report.PrintOptions.PaperSize = PaperSize.PaperLetter; } else { empty = true; } break; //--- WorkAhead case "WorkAhead": TDSWorkAhead tdsWorkAhead = lfsRecordForReportsGateway.GetWorkAheadByCompanyId(Convert.ToInt32(Session["companyID"])); if (tdsWorkAhead.WorkAhead1.Rows.Count > 0) { report = new rWorkAhead(); report.SetDataSource(tdsWorkAhead); if (Request.QueryString["format"] == "pdf") { ((Section)report.ReportDefinition.Sections["sReportHeader"]).SectionFormat.EnableSuppress = true; ((Section)report.ReportDefinition.Sections["sPageHeader"]).SectionFormat.EnableSuppress = false; ((Section)report.ReportDefinition.Sections["sPageFooter"]).SectionFormat.EnableSuppress = false; } else { ((Section)report.ReportDefinition.Sections["sReportHeader"]).SectionFormat.EnableSuppress = false; ((Section)report.ReportDefinition.Sections["sPageHeader"]).SectionFormat.EnableSuppress = true; ((Section)report.ReportDefinition.Sections["sPageFooter"]).SectionFormat.EnableSuppress = true; } report.PrintOptions.PaperOrientation = PaperOrientation.Landscape; report.PrintOptions.PaperSize = PaperSize.PaperLetter; } else { empty = true; } break; //--- JLinerOverviewReport case "JLinerOverviewReport": TDSJLinerOverviewReport tdsJLinerOverviewReport = lfsRecordForReportsGateway.GetJLinerOverviewReportByCompanyIDCompaniesID(Convert.ToInt32(Session["companyID"]), Convert.ToBoolean(Request.QueryString["all_clients"]), Convert.ToInt32(Request.QueryString["companies_id"])); if (tdsJLinerOverviewReport.JLinerOverviewReport.Rows.Count > 0) { //---Report creation and data binding if (Convert.ToBoolean(Session["sgLFS_APP_ADMIN"])) { report = new rJLinerOverviewReport(); } else { report = new rJLinerOverviewReportSimple(); } report.SetDataSource(tdsJLinerOverviewReport); //---Format control if (Request.QueryString["format"] == "pdf") { ((Section)report.ReportDefinition.Sections["sReportHeader"]).SectionFormat.EnableSuppress = true; ((Section)report.ReportDefinition.Sections["sPageHeader"]).SectionFormat.EnableSuppress = false; ((Section)report.ReportDefinition.Sections["sPageFooter"]).SectionFormat.EnableSuppress = false; } else { ((Section)report.ReportDefinition.Sections["sReportHeader"]).SectionFormat.EnableSuppress = false; ((Section)report.ReportDefinition.Sections["sPageHeader"]).SectionFormat.EnableSuppress = true; ((Section)report.ReportDefinition.Sections["sPageFooter"]).SectionFormat.EnableSuppress = true; } //---Report format report.PrintOptions.PaperOrientation = PaperOrientation.Landscape; report.PrintOptions.PaperSize = PaperSize.PaperLegal; } else { empty = true; } break; //--- JLinersReadyToLine case "JLinersReadyToLine": TDSJLinersReadyToLine tdsJLinersReadyToLine = lfsRecordForReportsGateway.GetJLinersReadyToLineByCompanyIDCompaniesID(Convert.ToInt32(Session["companyID"]), Convert.ToBoolean(Request.QueryString["all_clients"]), Convert.ToInt32(Request.QueryString["companies_id"])); if (tdsJLinersReadyToLine.JLinersReadyToLine.Rows.Count > 0) { //---Report creation and data binding report = new rJLinersReadyToLine(); report.SetDataSource(tdsJLinersReadyToLine); //---Format control if (Request.QueryString["format"] == "pdf") { ((Section)report.ReportDefinition.Sections["sReportHeader"]).SectionFormat.EnableSuppress = true; ((Section)report.ReportDefinition.Sections["sPageHeader"]).SectionFormat.EnableSuppress = false; ((Section)report.ReportDefinition.Sections["sPageFooter"]).SectionFormat.EnableSuppress = false; } else { ((Section)report.ReportDefinition.Sections["sReportHeader"]).SectionFormat.EnableSuppress = false; ((Section)report.ReportDefinition.Sections["sPageHeader"]).SectionFormat.EnableSuppress = true; ((Section)report.ReportDefinition.Sections["sPageFooter"]).SectionFormat.EnableSuppress = true; } //---Report format report.PrintOptions.PaperOrientation = PaperOrientation.Landscape; report.PrintOptions.PaperSize = PaperSize.PaperLegal; } else { empty = true; } break; //--- JLinersToBuild case "JLinersToBuild": TDSJLinersToBuild tdsJLinersToBuild = lfsRecordForReportsGateway.GetJLinersToBuildByCompanyId(Convert.ToInt32(Session["companyID"])); if (tdsJLinersToBuild.JLinersToBuild.Rows.Count > 0) { report = new rJLinersToBuild(); report.SetDataSource(tdsJLinersToBuild); if (Request.QueryString["format"] == "pdf") { ((Section)report.ReportDefinition.Sections["sPageFooter"]).SectionFormat.EnableSuppress = false; } else { ((Section)report.ReportDefinition.Sections["sPageFooter"]).SectionFormat.EnableSuppress = true; } report.PrintOptions.PaperOrientation = PaperOrientation.Portrait; report.PrintOptions.PaperSize = PaperSize.PaperLetter; } else { empty = true; } break; } #endregion if (!empty) { //--- Configure report //--- ... Disk options string physicalApplicationPath = Request.PhysicalApplicationPath; if (Request.PhysicalApplicationPath.Substring(Request.PhysicalApplicationPath.Length-1, 1) != "\\") { physicalApplicationPath += "\\"; } string fName = ""; switch (Request.QueryString["format"]) { case "pdf": fName = physicalApplicationPath + "export\\" + Guid.NewGuid().ToString() + ".pdf"; Session["fName"] = fName; break; case "excel": fName = physicalApplicationPath + "export\\" + Guid.NewGuid().ToString() + ".xls"; Session["fName"] = fName; break; case "word": break; } DiskFileDestinationOptions diskOptions = new DiskFileDestinationOptions(); diskOptions.DiskFileName = fName; //--- ... Export options report.ExportOptions.DestinationOptions = diskOptions; report.ExportOptions.ExportDestinationType = ExportDestinationType.DiskFile; switch (Request.QueryString["format"]) { case "pdf": report.ExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat; break; case "excel": ExcelFormatOptions excelOptions = new ExcelFormatOptions(); excelOptions.ExcelUseConstantColumnWidth = false; excelOptions.ExcelTabHasColumnHeadings = false; report.ExportOptions.ExportFormatType = ExportFormatType.Excel; report.ExportOptions.FormatOptions = excelOptions; break; case "word": break; } //--- Export report try { report.Export(); } catch(Exception ex) { Response.Redirect("./../error_page.aspx?error=" + ex.Message); } //--- Preview report Response.Redirect("viewer2.aspx?target_report=" + Request.QueryString["target_report"] + "&format=" + Request.QueryString["format"], true); } else { Response.Write("<br> No records found for your report."); } }
/// <summary> /// 顯示報表 /// </summary> private void ShowReport(DataSet ds) { #region 利用CrystalReport列印報表 //使用者名稱 DataTable dt1 = new DataTable(); dt1 = (DataTable)Session["UserInfo"]; string Login_Name = dt1.Rows[0]["Name"].ToString(); string strFileName = ""; CrystalDecisions.CrystalReports.Engine.ReportDocument report = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); ReportDocument SubReport = new ReportDocument(); report.Load(Server.MapPath("./REPORT/CAA271/CAA27R01.rpt")); strFileName = HttpUtility.UrlEncode("結帳與開立憑證檢核表.PDF", System.Text.Encoding.UTF8); SubReport = report.OpenSubreport("CAA27R01_1"); SubReport.SetDataSource(ds); report.SetDataSource(ds); report.SetParameterValue("par_Program_ID", "CAA27R01"); report.SetParameterValue("par_LoginUser", Session["UID"].ToString() + Login_Name); System.IO.Stream streamPDF = report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); byte[] bytesPDF = new byte[streamPDF.Length]; streamPDF.Read(bytesPDF, 0, bytesPDF.Length); streamPDF.Seek(0, System.IO.SeekOrigin.Begin); //export file Response.ClearContent(); Response.ClearHeaders(); Response.AddHeader("content-disposition", "attachment;filename=" + strFileName);//pdf檔名 Response.ContentType = "application/pdf"; Response.OutputStream.Write(bytesPDF, 0, bytesPDF.Length); Response.Flush(); Response.Close(); report.Close(); #endregion }
private void ShowReport(DataTable dt, string type) { try { CrystalDecisions.CrystalReports.Engine.ReportDocument report = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); report.Load(Server.MapPath("./REPORT/VAM121/VAM12" + type + "R.rpt")); report.SetDataSource(dt); DataTable dt1 = new DataTable(); dt1 = (DataTable)Session["UserInfo"]; string Login_Name = dt1.Rows[0]["Name"].ToString(); //CrystalReport Parameter 參數設定 string Program_ID = string.Empty; string LoginUser = string.Empty; string strParFDate = string.Empty; string strParFSType = string.Empty; string strParFTaxType = string.Empty; Program_ID = this.PageCode.Substring(0, 5) + "R0" + type; LoginUser = Session["UID"].ToString(); //report.SetParameterValue("par_Program_ID", Program_ID); //report.SetParameterValue("par_LoginUser", LoginUser); //report.SetParameterValue("par_LoginName", Login_Name); System.IO.Stream streamPDF = report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); byte[] bytesPDF = new byte[streamPDF.Length]; streamPDF.Read(bytesPDF, 0, bytesPDF.Length); streamPDF.Seek(0, System.IO.SeekOrigin.Begin); //Export File Response.ClearContent(); Response.ClearHeaders(); string rpt_name = string.Empty; rpt_name = "進項憑證明細表_折讓單套表.PDF"; Response.AddHeader("content-disposition", "attachment;filename=" + HttpUtility.UrlEncode(rpt_name, System.Text.Encoding.UTF8));//匯出檔名 Response.ContentType = "application/pdf"; Response.OutputStream.Write(bytesPDF, 0, bytesPDF.Length); Response.Flush(); Response.Close(); } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } finally { } }
/// <summary> /// 利用 CrystalReport 列印 Excel 報表 /// </summary> /// <param name="s_FileName">Excel報表的檔名</param> /// <param name="s_rptFilePath">rpt檔的路徑</param> /// <param name="dt_Source">要列印的資料</param> /// /// <param name="reportFormatType">檔案型態</param> private void LoadCrystalReport(string s_FileName, string s_rptFilePath, DataTable dt_Source, string reportFormatType) { CrystalDecisions.CrystalReports.Engine.ReportDocument report = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); report.Load(s_rptFilePath); report.SetDataSource(dt_Source); string s_par_Reqno = string.Empty; string s_par_Rolecode = string.Empty; string s_par_UserID = string.Empty; string s_par_UseName = string.Empty; string s_par_Signdate = string.Empty; string s_par_ReqLevel = string.Empty; string s_par_ReqType = string.Empty; string s_par_ReqStatus = string.Empty; string s_par_SysDesc = string.Empty; string s_par_WantDate = string.Empty; string s_par_ReqGist = string.Empty; string s_par_ReqDesc = string.Empty; s_par_Reqno = dt_Source.Rows[0]["REQ_NO"].ToString(); s_par_Rolecode = dt_Source.Rows[0]["ROLECODE"].ToString(); s_par_UseName = dt_Source.Rows[0]["USER_NAME"].ToString(); if (dt_Source.Rows[0]["SIGN_DATE"].ToString() != "") { s_par_Signdate = DateTime.Parse(dt_Source.Rows[0]["SIGN_DATE"].ToString()).ToString("yyyy/MM/dd"); } s_par_ReqLevel = dt_Source.Rows[0]["REQ_LEVEL"].ToString(); s_par_ReqType = dt_Source.Rows[0]["REQ_TYPE"].ToString(); s_par_ReqStatus = dt_Source.Rows[0]["REQ_STATUS"].ToString(); s_par_SysDesc = dt_Source.Rows[0]["SYSDESC"].ToString(); if (dt_Source.Rows[0]["WANT_DATE"].ToString() != "") { s_par_WantDate = DateTime.Parse(dt_Source.Rows[0]["WANT_DATE"].ToString()).ToString("yyyy/MM/dd"); } s_par_ReqGist = dt_Source.Rows[0]["REQ_GIST"].ToString(); s_par_ReqDesc = dt_Source.Rows[0]["REQ_DESC"].ToString(); report.SetParameterValue("par_Reqno", s_par_Reqno); report.SetParameterValue("par_Rolecode", s_par_Rolecode); report.SetParameterValue("par_UseName", s_par_UseName); report.SetParameterValue("par_Signdate", s_par_Signdate); report.SetParameterValue("par_ReqLevel", s_par_ReqLevel); report.SetParameterValue("par_ReqType", s_par_ReqType); report.SetParameterValue("par_ReqStatus", s_par_ReqStatus); report.SetParameterValue("par_SysDesc", s_par_SysDesc); report.SetParameterValue("par_WantDate", s_par_WantDate); report.SetParameterValue("par_ReqGist", s_par_ReqGist); report.SetParameterValue("par_ReqDesc", s_par_ReqDesc); //判斷輸出檔案型態 switch (reportFormatType) { case "EXCEL": System.IO.Stream streamXLS = report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.Excel); byte[] bytesXLS = new byte[streamXLS.Length]; streamXLS.Read(bytesXLS, 0, bytesXLS.Length); streamXLS.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"; Response.OutputStream.Write(bytesXLS, 0, bytesXLS.Length); Response.Flush(); Response.Close(); break; case "PDF": System.IO.Stream streamPDF = report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); byte[] bytesPDF = new byte[streamPDF.Length]; streamPDF.Read(bytesPDF, 0, bytesPDF.Length); streamPDF.Seek(0, System.IO.SeekOrigin.Begin); //export file Response.ClearContent(); Response.ClearHeaders(); Response.AddHeader("content-disposition", "attachment;filename=" + s_FileName);//excel檔名 Response.ContentType = "application/pdf"; Response.OutputStream.Write(bytesPDF, 0, bytesPDF.Length); Response.Flush(); Response.Close(); break; default: break; } }
private void ShowReport(DataTable dt,string V_FORM_TYPE,DateTime D_START_DATE,DateTime D_END_DATE,String V_ADJ_IN_DESC,String V_ADJ_OUT_DESC) { #region 利用CrystalReport列印報表 //使用者名稱 DataTable dt1 = new DataTable(); dt1 = (DataTable)Session["UserInfo"]; string Login_Name = dt1.Rows[0]["Name"].ToString(); CrystalDecisions.CrystalReports.Engine.ReportDocument report = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); report.Load(Server.MapPath("./REPORT/PSS031/PSS031R01.rpt")); report.SetDataSource(dt); report.SetParameterValue("par_Program_ID", "PSS031R"); report.SetParameterValue("par_LoginUser", Session["UID"].ToString() + Login_Name); report.SetParameterValue("par_YEAR_MONTH", this.SLP_YearMonth1.Text.Trim()); if (rblRptType.Items[0].Selected) report.SetParameterValue("par_TYPE", "差異"); else report.SetParameterValue("par_TYPE", "全部"); if (this.SLP_SKU_B.Text.Trim() == "" && this.SLP_SKU_E.Text.Trim() == "") { report.SetParameterValue("par_ITEM", "全部"); } else { report.SetParameterValue("par_ITEM", this.SLP_SKU_B.Text.Trim() + "~" + this.SLP_SKU_E.Text.Trim()); } if (this.SLP_ItemPeriod_B.Text.Trim() == "" && this.SLP_ItemPeriod_E.Text.Trim() == "") { report.SetParameterValue("par_PERIOD", "全部"); } else { report.SetParameterValue("par_PERIOD", this.SLP_ItemPeriod_B.Text.Trim() + "~" + this.SLP_ItemPeriod_E.Text.Trim()); } if (this.slp_TAX_TYPE.Text.Trim() == "" ) { report.SetParameterValue("par_TAX_TYPE", "全部"); } else if (this.slp_TAX_TYPE.Text.Trim() == "0") { report.SetParameterValue("par_TAX_TYPE", "應稅"); } else if (this.slp_TAX_TYPE.Text.Trim() == "1") { report.SetParameterValue("par_TAX_TYPE", "免稅"); } else if (this.slp_TAX_TYPE.Text.Trim() == "2") { report.SetParameterValue("par_TAX_TYPE", "零稅"); } report.SetParameterValue("par_START_DATE", D_START_DATE); report.SetParameterValue("par_END_DATE", D_END_DATE); report.SetParameterValue("par_ADJ_IN_DESC", V_ADJ_IN_DESC); report.SetParameterValue("par_ADJ_OUT_DESC", V_ADJ_OUT_DESC); //檔案匯出 if (V_FORM_TYPE == "XLS") { System.IO.Stream streamXLS = report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.Excel); byte[] bytesXLS = new byte[streamXLS.Length]; streamXLS.Read(bytesXLS, 0, bytesXLS.Length); streamXLS.Seek(0, System.IO.SeekOrigin.Begin); //Export File Response.ClearContent(); Response.ClearHeaders(); Response.AddHeader("content-disposition", "attachment;filename=" + HttpUtility.UrlEncode("進銷存差異明細表.XLS", System.Text.Encoding.UTF8));//匯出檔名 Response.ContentType = "application/xls"; Response.OutputStream.Write(bytesXLS, 0, bytesXLS.Length); Response.Flush(); Response.Close(); } else { System.IO.Stream streamPDF = report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); byte[] bytesPDF = new byte[streamPDF.Length]; streamPDF.Read(bytesPDF, 0, bytesPDF.Length); streamPDF.Seek(0, System.IO.SeekOrigin.Begin); //Export File Response.ClearContent(); Response.ClearHeaders(); Response.AddHeader("content-disposition", "attachment;filename=" + HttpUtility.UrlEncode("進銷存差異明細表.PDF", System.Text.Encoding.UTF8));//匯出檔名 Response.ContentType = "application/pdf"; Response.OutputStream.Write(bytesPDF, 0, bytesPDF.Length); Response.Flush(); Response.Close(); } report.Close(); #endregion }
// show報表 private void ShowReport(DataTable Dt) { try { string strFileName = ""; CrystalDecisions.CrystalReports.Engine.ReportDocument report = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); report.Load(Server.MapPath("./REPORT/PUR09/CRPUR09R01.rpt")); strFileName = HttpUtility.UrlEncode("每日出貨品項維護.PDF", System.Text.Encoding.UTF8); report.SetDataSource(Dt); string Login_Name = ((DataTable)Session["UserInfo"]).Rows[0]["Name"].ToString(); report.SetParameterValue("par_Program_ID", "PUR09"); report.SetParameterValue("par_LoginUser", Session["UID"].ToString() + Login_Name); report.SetParameterValue("par_StAcceptDate", this.txtPLAN_ACCEPT_DATE.Text); report.SetParameterValue("par_PickBatch", this.txtPICK_BATCH.Text); System.IO.Stream streamPDF = report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); byte[] bytesPDF = new byte[streamPDF.Length]; streamPDF.Read(bytesPDF, 0, bytesPDF.Length); streamPDF.Seek(0, System.IO.SeekOrigin.Begin); //export file Response.ClearContent(); Response.ClearHeaders(); Response.AddHeader("content-disposition", "attachment;filename=" + strFileName);//pdf檔名 Response.ContentType = "application/pdf"; Response.OutputStream.Write(bytesPDF, 0, bytesPDF.Length); Response.Flush(); Response.Close(); } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } finally { } }
private void loadValue() { ADODB.Recordset rs = default(ADODB.Recordset); ADODB.Recordset rsData = default(ADODB.Recordset); //Dim Report As New cryItemItemCompareValue //ReportNone.Load("cryNoRecords.rpt") CrystalDecisions.CrystalReports.Engine.ReportDocument Report = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); CrystalDecisions.CrystalReports.Engine.ReportDocument ReportNone = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); Report.Load("cryItemItemCompareValue.rpt"); ReportNone.Load("cryNoRecords.rpt"); modReport.cnnDBreport.Execute("DELETE LinkItem.* FROM LinkItem;"); rs = modReport.getRSreport(ref "SELECT * FROM Link Where Link_SectionID=3"); while (!(rs.EOF)) { if (!string.IsNullOrEmpty(rs.Fields("Link_SQL").Value)) { modReport.cnnDBreport.Execute("INSERT INTO LinkItem ( LinkItem_LinkID, LinkItem_DayEndID, LinkItem_Value ) SELECT " + rs.Fields("LinkID").Value + ", Sale.Sale_DayEndID, Sum([SaleItem_Quantity]*[SaleItem_Price]) FROM (SaleItem INNER JOIN aStockItem ON SaleItem.SaleItem_StockItemID = aStockItem.StockItemID) INNER JOIN Sale ON SaleItem.SaleItem_SaleID = Sale.SaleID Where " + rs.Fields("Link_SQL").Value + " GROUP BY Sale.Sale_DayEndID;"); } rs.moveNext(); } modReport.cnnDBreport.Execute("INSERT INTO LinkItem ( LinkItem_LinkID, LinkItem_DayEndID, LinkItem_Value ) SELECT theJoin.LinkID, theJoin.DayEndID, 0 FROM LinkItem RIGHT JOIN [SELECT Link.LinkID, DayEnd.DayEndID From Link, DayEnd WHERE (((Link.Link_SQL)<>'') AND ((Link.Link_SectionID)=3))]. AS theJoin ON (LinkItem.LinkItem_DayEndID = theJoin.DayEndID) AND (LinkItem.LinkItem_LinkID = theJoin.LinkID) WHERE (((LinkItem.LinkItem_LinkID) Is Null));"); System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor; rs = modReport.getRSreport(ref "SELECT Report.Report_Heading, aCompany.Company_Name FROM aCompany, Report;"); Report.SetParameterValue("txtCompanyName", rs.Fields("Company_Name")); Report.SetParameterValue("txtDayEnd", rs.Fields("Report_Heading")); rs.Close(); rs = modReport.getRSreport(ref "SELECT [Link].[LinkID], [Link].[Link_Name], Sum([LinkItem].[LinkItem_Value]) AS SumOfLinkItem_Value FROM Link INNER JOIN LinkItem ON [Link].[LinkID]=[LinkItem].[LinkItem_LinkID] WHERE ((([Link].[Link_SQL])<>'') And (([Link].[Link_SectionID])=3)) GROUP BY [Link].[LinkID], [Link].[Link_Name] ORDER BY [Link].[LinkID];"); if (rs.BOF | rs.EOF) { ReportNone.SetParameterValue("txtCompanyName", Report.ParameterFields("txtCompanyName").ToString); ReportNone.SetParameterValue("txtTitle", Report.ParameterFields("txtTitle").ToString); My.MyProject.Forms.frmReportShow.Text = ReportNone.ParameterFields("txtTitle").ToString; My.MyProject.Forms.frmReportShow.CRViewer1.ReportSource = ReportNone; My.MyProject.Forms.frmReportShow.mReport = ReportNone; My.MyProject.Forms.frmReportShow.sMode = "0"; My.MyProject.Forms.frmReportShow.CRViewer1.Refresh(); System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default; My.MyProject.Forms.frmReportShow.ShowDialog(); return; } rsData = modReport.getRSreport(ref "SELECT LinkItem.*, Format([DayEnd_Date],'yyyy mm dd ddd') AS dateName, DayEnd.DayEnd_Date FROM DayEnd INNER JOIN LinkItem ON DayEnd.DayEndID = LinkItem.LinkItem_DayEndID ORDER BY DayEnd.DayEnd_Date;"); if (rsData.BOF | rsData.EOF) { ReportNone.SetParameterValue("txtCompanyName", Report.ParameterFields("txtCompanyName").ToString); ReportNone.SetParameterValue("txtTitle", Report.ParameterFields("txtTitle").ToString); My.MyProject.Forms.frmReportShow.Text = ReportNone.ParameterFields("txtTitle").ToString; My.MyProject.Forms.frmReportShow.CRViewer1.ReportSource = ReportNone; My.MyProject.Forms.frmReportShow.mReport = ReportNone; My.MyProject.Forms.frmReportShow.sMode = "0"; My.MyProject.Forms.frmReportShow.CRViewer1.Refresh(); System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default; My.MyProject.Forms.frmReportShow.ShowDialog(); return; } Report.Database.Tables(1).SetDataSource(rs); Report.Database.Tables(2).SetDataSource(rsData); System.Windows.Forms.Application.DoEvents(); //Report.VerifyOnEveryPrint = True System.Windows.Forms.Application.DoEvents(); My.MyProject.Forms.frmReportShow.Text = Report.ParameterFields("txtTitle").ToString; My.MyProject.Forms.frmReportShow.CRViewer1.ReportSource = Report; My.MyProject.Forms.frmReportShow.mReport = Report; My.MyProject.Forms.frmReportShow.sMode = "0"; My.MyProject.Forms.frmReportShow.CRViewer1.Refresh(); System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default; My.MyProject.Forms.frmReportShow.ShowDialog(); }
private void GenerarCodigoBarras(string code) { if (code != null) { string codigo = code + CodigoBarrasCalculoDelDigitoVerificador(code); Code39 c39 = new Code39(); MemoryStream ms = new MemoryStream(); c39.FontFamilyName = "Free 3 of 9"; c39.FontFileName = "Facturacion\\Electronica\\Reportes\\FREE3OF9.TTF"; c39.FontSize = 30; c39.ShowCodeString = true; System.Drawing.Bitmap objBitmap = c39.GenerateBarcode(codigo); objBitmap.Save(ms, System.Drawing.Imaging.ImageFormat.Bmp); codigobarrasRpt = facturaRpt.OpenSubreport("CodigoBarra.rpt"); CrearTabla(); DataRow dr = this.dsImages.Tables["images"].NewRow(); dr["path"] = "ninguno"; dr["image"] = ms.ToArray(); this.dsImages.Tables["images"].Rows.Add(dr); codigobarrasRpt.SetDataSource(this.dsImages); ms.Close(); ms = null; } }
/// <summary> /// 利用 CrystalReport 列印 Excel 報表 /// </summary> /// <param name="s_FileName">Excel報表的檔名</param> /// <param name="s_rptFilePath">rpt檔的路徑</param> /// <param name="dt_Source">要列印的資料</param> /// /// <param name="reportFormatType">檔案型態</param> private void LoadCrystalReport(string s_FileName, string s_rptFilePath, DataTable dt_Source, string reportFormatType) { CrystalDecisions.CrystalReports.Engine.ReportDocument report = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); report.Load(s_rptFilePath); report.SetDataSource(dt_Source); string par_ProgramID = string.Empty; string par_LoginUser = string.Empty; #region 前置檢查與參數過濾 string par_S_Vendor = this.SLP_VendorBaseS.Text + " " + this.SLP_VendorBaseS.Name; string par_E_Vendor = this.SLP_VendorBaseE.Text + " " + this.SLP_VendorBaseE.Name; string par_S_PMA = this.SLP_PMAS.Text + " " + this.SLP_PMAS.Name; string par_E_PMA = this.SLP_PMAE.Text + " " + this.SLP_PMAE.Name; string par_S_RootNo = this.SLP_RootNoS.Text + " " + this.SLP_RootNoS.Name; string par_E_RootNo = this.SLP_RootNoE.Text + " " + this.SLP_RootNoE.Name; string par_S_LocateNo = this.SLP_SimpleLocateSec1.Text1 + " " + this.SLP_SimpleLocateSec1.Name; string par_E_LocateNo = this.SLP_SimpleLocateSec2.Text1 + " " + this.SLP_SimpleLocateSec2.Name; string par_S_LocateSec = SLP_SimpleLocateSec1.Text2.Trim() != "" ? this.SLP_SimpleLocateSec1.Text1 + SLP_SimpleLocateSec1.Text2 : ""; string par_E_LocateSec = SLP_SimpleLocateSec2.Text2.Trim() != "" ? this.SLP_SimpleLocateSec2.Text1 + SLP_SimpleLocateSec2.Text2 : ""; string par_Item = this.SLP_SKU.Text + " " + this.SLP_SKU.Name; string par_Period = this.SLP_ItemPeriod.Text + " " + this.SLP_ItemPeriod.Name; par_ProgramID = this.PageCode; par_LoginUser = Session["UID"].ToString(); #endregion #region 組合查詢條件至ArrayList ArrayList returnList = new ArrayList(); returnList.Clear(); report.SetParameterValue("par_S_Vendor", par_S_Vendor); report.SetParameterValue("par_E_Vendor", par_E_Vendor); report.SetParameterValue("par_S_PMA", par_S_PMA); report.SetParameterValue("par_E_PMA", par_E_PMA); report.SetParameterValue("par_S_RootNo", par_S_RootNo); report.SetParameterValue("par_E_RootNo", par_E_RootNo); report.SetParameterValue("par_S_LocateNo", par_S_LocateNo); report.SetParameterValue("par_E_LocateNo", par_E_LocateNo); report.SetParameterValue("par_S_LocateSec", par_S_LocateSec); report.SetParameterValue("par_E_LocateSec", par_E_LocateSec); report.SetParameterValue("par_Item", par_Item); report.SetParameterValue("par_Period", par_Period); report.SetParameterValue("par_ProgramID", par_ProgramID); report.SetParameterValue("par_LoginUser", par_LoginUser); #endregion //判斷輸出檔案型態 switch (reportFormatType) { case "EXCEL": System.IO.Stream streamXLS = report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.Excel); byte[] bytesXLS = new byte[streamXLS.Length]; streamXLS.Read(bytesXLS, 0, bytesXLS.Length); streamXLS.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"; Response.OutputStream.Write(bytesXLS, 0, bytesXLS.Length); Response.Flush(); Response.Close(); break; case "PDF": System.IO.Stream streamPDF = report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); byte[] bytesPDF = new byte[streamPDF.Length]; streamPDF.Read(bytesPDF, 0, bytesPDF.Length); streamPDF.Seek(0, System.IO.SeekOrigin.Begin); //export file Response.ClearContent(); Response.ClearHeaders(); Response.AddHeader("content-disposition", "attachment;filename=" + s_FileName);//excel檔名 Response.ContentType = "application/pdf"; Response.OutputStream.Write(bytesPDF, 0, bytesPDF.Length); Response.Flush(); Response.Close(); break; default: break; } }
private void LoadCrystalReport(string s_FileName, string s_rptFilePath, DataTable dt_Source, string reportFormatType) { CrystalDecisions.CrystalReports.Engine.ReportDocument report = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); report.Load(s_rptFilePath); report.SetDataSource(dt_Source); //判斷輸出檔案型態 switch (reportFormatType) { case "EXCEL": System.IO.Stream streamXLS = report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.Excel); byte[] bytesXLS = new byte[streamXLS.Length]; streamXLS.Read(bytesXLS, 0, bytesXLS.Length); streamXLS.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"; Response.OutputStream.Write(bytesXLS, 0, bytesXLS.Length); Response.Flush(); Response.Close(); break; case "PDF": string s_par_Program_ID = string.Empty; string s_par_LoginUser = string.Empty; s_par_Program_ID = this.PageCode; s_par_LoginUser = Session["UID"].ToString(); System.IO.Stream streamPDF = report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); byte[] bytesPDF = new byte[streamPDF.Length]; streamPDF.Read(bytesPDF, 0, bytesPDF.Length); streamPDF.Seek(0, System.IO.SeekOrigin.Begin); //export file Response.ClearContent(); Response.ClearHeaders(); Response.AddHeader("content-disposition", "attachment;filename=" + s_FileName);//excel檔名 Response.ContentType = "application/pdf"; Response.OutputStream.Write(bytesPDF, 0, bytesPDF.Length); Response.Flush(); Response.Close(); break; default: break; } }
//Crystal Report 直接輸出 PDF 檔 private void ExportReport(DataTable dt) { CrystalDecisions.CrystalReports.Engine.ReportDocument report = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); report.Load(Server.MapPath("./REPORT/CGR021R01.rpt")); report.SetDataSource(dt); //CrystalReport Parameter 參數設定 string Program_ID = string.Empty; string LoginUser = string.Empty; Program_ID = this.PageCode.Substring(0, 5) + "R01"; LoginUser = Session["UID"].ToString(); report.SetParameterValue("par_Program_ID", this.PageCode); report.SetParameterValue("par_LoginUser", LoginUser); //檔案匯出 System.IO.Stream streamPDF = report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); byte[] bytesPDF = new byte[streamPDF.Length]; streamPDF.Read(bytesPDF, 0, bytesPDF.Length); streamPDF.Seek(0, System.IO.SeekOrigin.Begin); //Export File Response.ClearContent(); Response.ClearHeaders(); Response.AddHeader("content-disposition", "attachment;filename=" + HttpUtility.UrlEncode("退貨結轉檢核異常報表.PDF", System.Text.Encoding.UTF8));//匯出檔名 Response.ContentType = "application/pdf"; Response.OutputStream.Write(bytesPDF, 0, bytesPDF.Length); Response.Flush(); Response.Close(); report.Close(); }
private void LoadCrystalReport(string s_FileName, string s_rptFilePath, DataTable dt_Source, string reportFormatType) { CrystalDecisions.CrystalReports.Engine.ReportDocument report = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); report.Load(s_rptFilePath); report.SetDataSource(dt_Source); //判斷輸出檔案型態 switch (reportFormatType) { case "EXCEL": System.IO.Stream streamXLS = report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.Excel); byte[] bytesXLS = new byte[streamXLS.Length]; streamXLS.Read(bytesXLS, 0, bytesXLS.Length); streamXLS.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.OutputStream.Write(bytesXLS, 0, bytesXLS.Length); Response.Flush(); Response.Close(); break; case "PDF": //string s_par_Program_ID = this.PageCode; string Login_Name = ((DataTable)Session["UserInfo"]).Rows[0]["Name"].ToString(); string s_par_Program_ID = "MKT10"; string s_par_LoginUser = Session["UID"].ToString() + Login_Name; string s_par_Busdate = SLP_MDC_START_DATE.StartDate + " ~ " + SLP_MDC_START_DATE.EndDate; string s_par_Z_O = SLP_Z_O_S.Text + " " + SLP_Z_O_S.Name + " ~ " + SLP_Z_O_E.Text + " " + SLP_Z_O_E.Name; string s_par_Chan_No = SLP_CHAIN_S.Text + " " + SLP_CHAIN_S.Name + " ~ " + SLP_CHAIN_E.Text + " " + SLP_CHAIN_E.Name; report.SetParameterValue("par_Program_ID", s_par_Program_ID); report.SetParameterValue("par_LoginUser", s_par_LoginUser); report.SetParameterValue("par_Busdate", s_par_Busdate); report.SetParameterValue("par_Z_O", s_par_Z_O); report.SetParameterValue("par_Chan_No", s_par_Chan_No); System.IO.Stream streamPDF = report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); byte[] bytesPDF = new byte[streamPDF.Length]; streamPDF.Read(bytesPDF, 0, bytesPDF.Length); streamPDF.Seek(0, System.IO.SeekOrigin.Begin); //export file Response.ClearContent(); Response.ClearHeaders(); Response.AddHeader("content-disposition", "attachment;filename=" + s_FileName);//excel檔名 Response.ContentType = "application/pdf"; Response.OutputStream.Write(bytesPDF, 0, bytesPDF.Length); Response.Flush(); Response.Close(); break; default: break; } }
private void LoadCrystalReport(string s_FileName, string s_rptFilePath, DataTable dt_Source, string reportFormatType) { CrystalDecisions.CrystalReports.Engine.ReportDocument report = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); report.Load(s_rptFilePath); report.SetDataSource(dt_Source); //判斷輸出檔案型態 switch (reportFormatType) { case "EXCEL": System.IO.Stream streamXLS = report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.Excel); byte[] bytesXLS = new byte[streamXLS.Length]; streamXLS.Read(bytesXLS, 0, bytesXLS.Length); streamXLS.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.OutputStream.Write(bytesXLS, 0, bytesXLS.Length); Response.Flush(); Response.Close(); break; case "PDF": //string s_par_Program_ID = this.PageCode; string Login_Name = ((DataTable)Session["UserInfo"]).Rows[0]["Name"].ToString(); string s_par_Program_ID = "MKT11"; string s_par_LoginUser = Session["UID"].ToString() + " " + Login_Name; string s_par_Vendor = SLP_Vendor.Text + " " + SLP_Vendor.Name; string s_par_RootNo = SLP_RootNo_S.Text + " " + SLP_RootNo_S.Name +" ~ " + SLP_RootNo_E.Text + " " + SLP_RootNo_E.Name; string s_par_PMA = SLP_PMA_S.Text + " " + SLP_PMA_S.Name + " ~ " + SLP_PMA_E.Text + " " + SLP_PMA_E.Name; string s_par_Category = SLP_Category_S.Text + " " + SLP_Category_S.Name + " ~ " + SLP_Category_E.Text + " " + SLP_Category_E.Name; string s_par_SortOut = SLP_SortOut_S.Text + " " + SLP_SortOut_S.Name + " ~ " + SLP_SortOut_E.Text + " " + SLP_SortOut_E.Name; string s_par_Item = SLP_SKU.Text + " " + SLP_SKU.Name; string s_par_Period = SLP_ItemPeriod.Text; string s_par_PeriodCount = SLP_SLPNumber.Text; string s_par_Order =""; if ( ddl_Order.SelectedValue=="1"){ s_par_Order = "期別降冪"; } else if ( ddl_Order.SelectedValue=="2"){ s_par_Order = "期別升冪"; } report.SetParameterValue("par_Program_ID", s_par_Program_ID); report.SetParameterValue("par_LoginUser", s_par_LoginUser); report.SetParameterValue("par_Vendor", s_par_Vendor); report.SetParameterValue("par_RootNo", s_par_RootNo); report.SetParameterValue("par_PMA", s_par_PMA); report.SetParameterValue("par_Category", s_par_Category); report.SetParameterValue("par_SortOut", s_par_SortOut); report.SetParameterValue("par_Item", s_par_Item); report.SetParameterValue("par_Period", s_par_Period); report.SetParameterValue("par_PeriodCount", s_par_PeriodCount); report.SetParameterValue("par_Order", s_par_Order); System.IO.Stream streamPDF = report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); byte[] bytesPDF = new byte[streamPDF.Length]; streamPDF.Read(bytesPDF, 0, bytesPDF.Length); streamPDF.Seek(0, System.IO.SeekOrigin.Begin); //export file Response.ClearContent(); Response.ClearHeaders(); Response.AddHeader("content-disposition", "attachment;filename=" + s_FileName);//excel檔名 Response.ContentType = "application/pdf"; Response.OutputStream.Write(bytesPDF, 0, bytesPDF.Length); Response.Flush(); Response.Close(); break; default: break; } }
public void addTrinhKy_OnFormLoad() { //Ham nay XuanDT them vao try { //doan gan cac bien: doan nay co the phai thay doi ten bien cho phu hop mv_oRptDoc = RptDoc; mv_oViewDoc = this.crptViewer; //ket thuc doan gan bien mv_oRptFieldObj = GetTrinhky(RptDoc.ParameterFields); // if (mv_oRptFieldObj == null) return; mv_oNguoiKy = new cls_SignInfor(string.IsNullOrEmpty(crptTrinhKyName) ? mv_oRptDoc.ToString() : crptTrinhKyName, ""); //chkPrint_CheckedChanged(chkPrint, New System.EventArgs) if (mv_oNguoiKy._TonTai) { SetParamAgain(RptDoc.ParameterFields); //if (mv_bSetContent) //{ // mv_oRptDoc.ReportDefinition.ReportObjects["txtTrinhky"]..Text = mv_oNguoiKy.mv_NOI_DUNG.Replace("&NHANVIEN", globalVariables.gv_strTenNhanvien); //} //else //{ // mv_oRptDoc.DataDefinition.FormulaFields["Formula_1"].Text = ""; //} } else { SetParamAgain(RptDoc.ParameterFields); if (string.IsNullOrEmpty(crptTrinhKyName)) mv_oNguoiKy = new cls_SignInfor(mv_oRptFieldObj, "", RptDoc.ToString(), ""); else { mv_oNguoiKy = new cls_SignInfor(mv_oRptFieldObj, "", crptTrinhKyName, ""); } } mv_oViewDoc.ReportSource = RptDoc; } catch (Exception ex) { mv_oRptText = null; //an nut tuy chon di log.Error("Loi trong qua trinh load thong tin trih ky={0}", ex); this.cmdTrinhKy.Visible = false; } }
private void ShowReportA(DataTable dtA, DataTable dtB, string V_FORM_TYPE, string V_RPT) { #region 利用CrystalReport列印報表 //匯出檔案名稱 string FileName = ""; //使用者名稱 DataTable dt1 = new DataTable(); dt1 = (DataTable)Session["UserInfo"]; string Login_Name = dt1.Rows[0]["Name"].ToString(); CrystalDecisions.CrystalReports.Engine.ReportDocument report = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); report.Load(Server.MapPath("./REPORT/VAM121/" + V_RPT + "01.rpt")); DataSet ds = new DataSet(); dtA.TableName = "VAM122_R1"; ds.Tables.Add(dtA.Copy()); dtB.TableName = "VAM122_R2"; ds.Tables.Add(dtB.Copy()); report.SetDataSource(ds); if (V_RPT == "VAM121R") { FileName = "進項憑證明細表(發票)"; report.SetParameterValue("par_Program_ID", V_RPT); report.SetParameterValue("par_LoginUser", Session["UID"].ToString() + Login_Name); if (this.SLP_SLPDateRange.StartDate.ToString() == "" && this.SLP_SLPDateRange.EndDate.ToString() == "") report.SetParameterValue("par_Source_date", "全部"); else report.SetParameterValue("par_Source_date", this.SLP_SLPDateRange.StartDate.ToString() + "-" + this.SLP_SLPDateRange.EndDate.ToString()); if (this.SLP_SLPDateRange1.StartDate.ToString() == "" && this.SLP_SLPDateRange1.EndDate.ToString() == "") report.SetParameterValue("par_Keyin_date", "全部"); else report.SetParameterValue("par_Keyin_date", this.SLP_SLPDateRange1.StartDate.ToString() + "-" + this.SLP_SLPDateRange1.EndDate.ToString()); if (this.SLP_VendorBase1.Text.Trim() == "" && this.SLP_VendorBase2.Text.Trim() == "") { report.SetParameterValue("par_Vandor", "全部"); } else { report.SetParameterValue("par_Vandor", this.SLP_VendorBase1.Text.Trim() + "-" + this.SLP_VendorBase2.Text.Trim()); } if (((DropDownList)this.SLP_EnumBase.FindControl("D1")).SelectedItem.Text == "ALL") report.SetParameterValue("par_Tax_Type", "全部"); else report.SetParameterValue("par_Tax_Type", ((DropDownList)this.SLP_EnumBase.FindControl("D1")).SelectedItem.Text); } else if (V_RPT == "VAM122R") { FileName = "進項憑證明細表(折讓)"; report.SetParameterValue("par_Program_ID_B", V_RPT); report.SetParameterValue("par_LoginUser_B", Session["UID"].ToString() + Login_Name); if (this.SLP_SLPDateRange.StartDate.ToString() == "" && this.SLP_SLPDateRange.EndDate.ToString() == "") report.SetParameterValue("par_Source_date_B", "全部"); else report.SetParameterValue("par_Source_date_B", this.SLP_SLPDateRange.StartDate.ToString() + "-" + this.SLP_SLPDateRange.EndDate.ToString()); if (this.SLP_SLPDateRange1.StartDate.ToString() == "" && this.SLP_SLPDateRange1.EndDate.ToString() == "") report.SetParameterValue("par_Keyin_date_B", "全部"); else report.SetParameterValue("par_Keyin_date_B", this.SLP_SLPDateRange1.StartDate.ToString() + "-" + this.SLP_SLPDateRange1.EndDate.ToString()); if (this.SLP_VendorBase1.Text.Trim() == "" && this.SLP_VendorBase2.Text.Trim() == "") { report.SetParameterValue("par_Vandor_B", "全部"); } else { report.SetParameterValue("par_Vandor_B", this.SLP_VendorBase1.Text.Trim() + "-" + this.SLP_VendorBase2.Text.Trim()); } if (((DropDownList)this.SLP_EnumBase.FindControl("D1")).SelectedItem.Text == "ALL") report.SetParameterValue("par_Tax_Type_B", "全部"); else report.SetParameterValue("par_Tax_Type_B", ((DropDownList)this.SLP_EnumBase.FindControl("D1")).SelectedItem.Text); //report.SetParameterValue("par_Tax_Type_B", ((DropDownList)this.SLP_EnumBase.FindControl("D1")).SelectedItem.Text); } else if (V_RPT == "VAM123R") { FileName = "進項憑證明細表(發票與折讓)"; report.SetParameterValue("par_Program_ID", V_RPT); report.SetParameterValue("par_Program_ID_B", V_RPT); report.SetParameterValue("par_LoginUser", Session["UID"].ToString() + Login_Name); report.SetParameterValue("par_LoginUser_B", Session["UID"].ToString() + Login_Name); if (this.SLP_SLPDateRange.StartDate.ToString() == "" && this.SLP_SLPDateRange.EndDate.ToString() == "") { report.SetParameterValue("par_Source_date", "全部"); report.SetParameterValue("par_Source_date_B", "全部"); } else { report.SetParameterValue("par_Source_date", this.SLP_SLPDateRange.StartDate.ToString() + "-" + this.SLP_SLPDateRange.EndDate.ToString()); report.SetParameterValue("par_Source_date_B", this.SLP_SLPDateRange.StartDate.ToString() + "-" + this.SLP_SLPDateRange.EndDate.ToString()); } if (this.SLP_SLPDateRange1.StartDate.ToString() == "" && this.SLP_SLPDateRange1.EndDate.ToString() == "") { report.SetParameterValue("par_Keyin_date", "全部"); report.SetParameterValue("par_Keyin_date_B", "全部"); } else { report.SetParameterValue("par_Keyin_date", this.SLP_SLPDateRange1.StartDate.ToString() + "-" + this.SLP_SLPDateRange1.EndDate.ToString()); report.SetParameterValue("par_Keyin_date_B", this.SLP_SLPDateRange1.StartDate.ToString() + "-" + this.SLP_SLPDateRange1.EndDate.ToString()); } if (this.SLP_VendorBase1.Text.Trim() == "" && this.SLP_VendorBase2.Text.Trim() == "") { report.SetParameterValue("par_Vandor", "全部"); report.SetParameterValue("par_Vandor_B", "全部"); } else { report.SetParameterValue("par_Vandor", this.SLP_VendorBase1.Text.Trim() + "-" + this.SLP_VendorBase2.Text.Trim()); report.SetParameterValue("par_Vandor_B", this.SLP_VendorBase1.Text.Trim() + "-" + this.SLP_VendorBase2.Text.Trim()); } if (((DropDownList)this.SLP_EnumBase.FindControl("D1")).SelectedItem.Text == "ALL") { report.SetParameterValue("par_Tax_Type", "全部"); report.SetParameterValue("par_Tax_Type_B", "全部"); } else { report.SetParameterValue("par_Tax_Type", ((DropDownList)this.SLP_EnumBase.FindControl("D1")).SelectedItem.Text); report.SetParameterValue("par_Tax_Type_B", ((DropDownList)this.SLP_EnumBase.FindControl("D1")).SelectedItem.Text); } } //檔案匯出 if (V_FORM_TYPE == "XLS") { System.IO.Stream streamXLS = report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.Excel); byte[] bytesXLS = new byte[streamXLS.Length]; streamXLS.Read(bytesXLS, 0, bytesXLS.Length); streamXLS.Seek(0, System.IO.SeekOrigin.Begin); //Export File Response.ClearContent(); Response.ClearHeaders(); Response.AddHeader("content-disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName + ".XLS", System.Text.Encoding.UTF8));//匯出檔名 Response.ContentType = "application/xls"; Response.OutputStream.Write(bytesXLS, 0, bytesXLS.Length); Response.Flush(); Response.Close(); } else { System.IO.Stream streamPDF = report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); byte[] bytesPDF = new byte[streamPDF.Length]; streamPDF.Read(bytesPDF, 0, bytesPDF.Length); streamPDF.Seek(0, System.IO.SeekOrigin.Begin); //Export File Response.ClearContent(); Response.ClearHeaders(); Response.AddHeader("content-disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName + ".PDF", System.Text.Encoding.UTF8));//匯出檔名 Response.ContentType = "application/pdf"; Response.OutputStream.Write(bytesPDF, 0, bytesPDF.Length); Response.Flush(); Response.Close(); } report.Close(); #endregion }
/// <summary> /// 利用 CrystalReport 列印 Excel 報表 /// </summary> /// <param name="s_FileName">Excel報表的檔名</param> /// <param name="s_rptFilePath">rpt檔的路徑</param> /// <param name="dt_Source">要列印的資料</param> /// /// <param name="reportFormatType">檔案型態</param> private void LoadCrystalReport(string s_FileName, string s_rptFilePath, DataTable dt_Source, string reportFormatType) { CrystalDecisions.CrystalReports.Engine.ReportDocument report = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); report.Load(s_rptFilePath); report.SetDataSource(dt_Source); string par_ChanNo = string.Empty; string par_Store = string.Empty; #region 前置檢查與參數過濾 par_ChanNo = Server.UrlDecode(Request.QueryString["Chan"].ToString()); par_Store = Server.UrlDecode(Request.QueryString["Store"].ToString()); #endregion #region 組合查詢條件至ArrayList ArrayList returnList = new ArrayList(); returnList.Clear(); report.SetParameterValue("ChanNo", par_ChanNo); report.SetParameterValue("Store", par_Store); #endregion //判斷輸出檔案型態 switch (reportFormatType) { case "EXCEL": System.IO.Stream streamXLS = report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.Excel); byte[] bytesXLS = new byte[streamXLS.Length]; streamXLS.Read(bytesXLS, 0, bytesXLS.Length); streamXLS.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"; Response.OutputStream.Write(bytesXLS, 0, bytesXLS.Length); Response.Flush(); Response.Close(); report.Close(); break; case "PDF": System.IO.Stream streamPDF = report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); byte[] bytesPDF = new byte[streamPDF.Length]; streamPDF.Read(bytesPDF, 0, bytesPDF.Length); streamPDF.Seek(0, System.IO.SeekOrigin.Begin); //export file Response.ClearContent(); Response.ClearHeaders(); Response.AddHeader("content-disposition", "attachment;filename=" + s_FileName);//excel檔名 Response.ContentType = "application/pdf"; Response.OutputStream.Write(bytesPDF, 0, bytesPDF.Length); Response.Flush(); Response.Close(); report.Close(); break; default: break; } }
/// <summary> /// 利用 CrystalReport 列印 Excel 報表 /// </summary> /// <param name="s_FileName">Excel報表的檔名</param> /// <param name="s_rptFilePath">rpt檔的路徑</param> /// <param name="dt_Source">要列印的資料</param> /// /// <param name="reportFormatType">檔案型態</param> private void LoadCrystalReport(string s_FileName, string s_rptFilePath, DataTable dt_Source, string reportFormatType) { CrystalDecisions.CrystalReports.Engine.ReportDocument report = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); report.Load(s_rptFilePath); report.SetDataSource(dt_Source); //判斷輸出檔案型態 switch (reportFormatType) { case "EXCEL": System.IO.Stream streamXLS = report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.Excel); byte[] bytesXLS = new byte[streamXLS.Length]; streamXLS.Read(bytesXLS, 0, bytesXLS.Length); streamXLS.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"; Response.OutputStream.Write(bytesXLS, 0, bytesXLS.Length); Response.Flush(); Response.Close(); break; case "PDF": string s_par_Program_ID = string.Empty; string s_par_LoginUser = string.Empty; string s_par_Trans = string.Empty; string s_par_TruckNo = string.Empty; s_par_Program_ID = this.PageCode; s_par_LoginUser = Session["UID"].ToString(); s_par_Trans = this.SLP_TRANS_NO_S.Text + " " + ((DropDownList)SLP_TRANS_NO_S.FindControl("D1")).SelectedItem.Text + " ~ " + this.SLP_TRANS_NO_E.Text + " " + ((DropDownList)SLP_TRANS_NO_E.FindControl("D1")).SelectedItem.Text; s_par_TruckNo = this.TRUCK_NO_S.Text + " ~ " + this.TRUCK_NO_E.Text; report.SetParameterValue("par_Program_ID", s_par_Program_ID); report.SetParameterValue("par_LoginUser", s_par_LoginUser); report.SetParameterValue("par_Trans", s_par_Trans); report.SetParameterValue("par_TruckNo", s_par_TruckNo); System.IO.Stream streamPDF = report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); byte[] bytesPDF = new byte[streamPDF.Length]; streamPDF.Read(bytesPDF, 0, bytesPDF.Length); streamPDF.Seek(0, System.IO.SeekOrigin.Begin); //export file Response.ClearContent(); Response.ClearHeaders(); Response.AddHeader("content-disposition", "attachment;filename=" + s_FileName);//excel檔名 Response.ContentType = "application/pdf"; Response.OutputStream.Write(bytesPDF, 0, bytesPDF.Length); Response.Flush(); Response.Close(); break; default: break; } report.Close(); }
private void ProcesarComprobante(out CrystalDecisions.CrystalReports.Engine.ReportDocument ReporteDocumento, eFact_Entidades.Lote Lote, int Renglon) { try { //Cursor = System.Windows.Forms.Cursors.WaitCursor; facturaRpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); //facturaRpt.Load("Facturacion\\Electronica\\Reportes\\Factura.rpt"); ////Crear un lote de un solo comprobante, para la impresion o exportacion del pdf. //eFact_Entidades.Lote LoteConUnSoloComprobante = new eFact_Entidades.Lote(); //LoteConUnSoloComprobante.CuitVendedor = Lote.CuitVendedor; //LoteConUnSoloComprobante.FechaAlta = Lote.FechaAlta; //LoteConUnSoloComprobante.FechaEnvio = Lote.FechaEnvio; //LoteConUnSoloComprobante.IdLote = Lote.IdLote; //LoteConUnSoloComprobante.IdOp = Lote.IdOp; //LoteConUnSoloComprobante.LoteXml = Lote.LoteXml; //LoteConUnSoloComprobante.LoteXmlIF = Lote.LoteXmlIF; //LoteConUnSoloComprobante.NumeroEnvio = Lote.NumeroEnvio; //LoteConUnSoloComprobante.NumeroLote = Lote.NumeroLote; //LoteConUnSoloComprobante.PuntoVenta = Lote.PuntoVenta; //LoteConUnSoloComprobante.CantidadRegistros = 1; //LoteConUnSoloComprobante.Comprobantes.Add(Lote.Comprobantes[Renglon]); //LoteConUnSoloComprobante.WF = Lote.WF; //FeaEntidades.InterFacturas.lote_comprobantes lc = new FeaEntidades.InterFacturas.lote_comprobantes(); //eFact_RN.Lote.DeserializarLc(out lc, LoteConUnSoloComprobante, true); ////Entidad para reporte crystal. Al desserializar se pierden los descuentos de la entidad original. //FeaEntidades.Reporte.lote_comprobantes lcReporte = new FeaEntidades.Reporte.lote_comprobantes(); //eFact_RN.Lote.DeserializarLc(out lcReporte, LoteConUnSoloComprobante); //for (int i = 0; i < lc.comprobante.Length; i++) //{ // if (i == 0) // { // lc.comprobante[i] = lc.comprobante[Renglon]; // lcReporte.comprobante[i] = lcReporte.comprobante[Renglon]; // for (int l = 0; l < lc.comprobante[i].detalle.linea.Length; l++) // { // if (lc.comprobante[i].detalle.linea[l].lineaDescuentos != null) // { // lcReporte.comprobante[i].detalle.linea[l].lineaDescuentos = new FeaEntidades.Reporte.lineaDescuentos[lc.comprobante[i].detalle.linea[l].lineaDescuentos.Length]; // for (int d = 0; d < lcReporte.comprobante[i].detalle.linea[l].lineaDescuentos.Length; d++) // { // lcReporte.comprobante[i].detalle.linea[l].lineaDescuentos[d] = new FeaEntidades.Reporte.lineaDescuentos(); // lcReporte.comprobante[i].detalle.linea[l].lineaDescuentos[d].descripcion_descuento = lc.comprobante[i].detalle.linea[l].lineaDescuentos[d].descripcion_descuento; // lcReporte.comprobante[i].detalle.linea[l].lineaDescuentos[d].importe_descuento = lc.comprobante[i].detalle.linea[l].lineaDescuentos[d].importe_descuento; // lcReporte.comprobante[i].detalle.linea[l].lineaDescuentos[d].importe_descuento_moneda_origen = lc.comprobante[i].detalle.linea[l].lineaDescuentos[d].importe_descuento_moneda_origen; // lcReporte.comprobante[i].detalle.linea[l].lineaDescuentos[d].importe_descuento_moneda_origenSpecified = lc.comprobante[i].detalle.linea[l].lineaDescuentos[d].importe_descuento_moneda_origenSpecified; // lcReporte.comprobante[i].detalle.linea[l].lineaDescuentos[d].importe_descuento_moneda_origenSpecified = true; // lcReporte.comprobante[i].detalle.linea[l].lineaDescuentos[d].porcentaje_descuento = lc.comprobante[i].detalle.linea[l].lineaDescuentos[d].porcentaje_descuento; // lcReporte.comprobante[i].detalle.linea[l].lineaDescuentos[d].porcentaje_descuentoSpecified = lc.comprobante[i].detalle.linea[l].lineaDescuentos[d].porcentaje_descuentoSpecified; // lcReporte.comprobante[i].detalle.linea[l].lineaDescuentos[d].porcentaje_descuentoSpecified = true; // } // } // else // { // lcReporte.comprobante[0].detalle.linea[l].lineaDescuentos = new FeaEntidades.Reporte.lineaDescuentos[1]; // lcReporte.comprobante[0].detalle.linea[l].lineaDescuentos[0] = new FeaEntidades.Reporte.lineaDescuentos(); // lcReporte.comprobante[0].detalle.linea[l].lineaDescuentos[0].descripcion_descuento = ""; // lcReporte.comprobante[0].detalle.linea[l].lineaDescuentos[0].importe_descuento = 0; // lcReporte.comprobante[0].detalle.linea[l].lineaDescuentos[0].porcentaje_descuento = 0; // lcReporte.comprobante[0].detalle.linea[l].lineaDescuentos[0].porcentaje_descuentoSpecified = true; // lcReporte.comprobante[0].detalle.linea[l].lineaDescuentos[0].importe_descuento_moneda_origen = 0; // lcReporte.comprobante[0].detalle.linea[l].lineaDescuentos[0].importe_descuento_moneda_origenSpecified = true; // } // } // } // else // { // lc.comprobante[i] = null; // lcReporte.comprobante[i] = null; // } //} //AsignarCamposOpcionales(lcReporte); //ReemplarResumenImportesMonedaExtranjera(lcReporte); //DataSet ds = new DataSet(); //XmlSerializer objXS = new XmlSerializer(lcReporte.GetType()); //StringWriter objSW = new StringWriter(); //objXS.Serialize(objSW, lcReporte); //StringReader objSR = new StringReader(objSW.ToString()); //ds.ReadXml(objSR); //string pxsd = string.Format("{0}\\Facturacion\\Electronica\\Reportes\\lote_comprobantes.xsd",System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().Location)); //System.IO.File.Copy(pxsd, @System.IO.Path.GetTempPath() + "lote_comprobantes.xsd", true); //string imagen = string.Format("{0}\\Facturacion\\Electronica\\Reportes\\Imagen.xsd",System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().Location)); //System.IO.File.Copy(imagen, @System.IO.Path.GetTempPath() + "Imagen.xsd", true); //facturaRpt.SetDataSource(ds); //facturaRpt.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.PaperLetter; //facturaRpt.PrintOptions.PaperOrientation = CrystalDecisions.Shared.PaperOrientation.Portrait; //IncrustarLogo(); //GenerarCodigoBarras(lcReporte.cabecera_lote.cuit_vendedor + lcReporte.comprobante[0].cabecera.informacion_comprobante.tipo_de_comprobante.ToString("00") + lcReporte.comprobante[0].cabecera.informacion_comprobante.punto_de_venta.ToString("0000") + lcReporte.comprobante[0].cabecera.informacion_comprobante.cae + lcReporte.comprobante[0].cabecera.informacion_comprobante.fecha_vencimiento_cae); //AsignarParametros(lcReporte.comprobante[0].resumen.importe_total_factura); ReporteDocumento = facturaRpt; } catch (Exception ex) { ReporteDocumento = null; //MessageBox.Show(ex.Message, "Problemas al procesar el comprobante", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1); throw new Microsoft.ApplicationBlocks.ExceptionManagement.Reporte.ProblemasProcesando(ex); } finally { Cursor = System.Windows.Forms.Cursors.Default; } }
/// <summary> /// 產生報表 /// </summary> /// <param name="dt">DataTable資料</param> /// <param name="exp_type">產生PDF或Excel</param> private void ShowReport(DataTable dt, string exp_type) { try { CrystalDecisions.CrystalReports.Engine.ReportDocument report = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); report.Load(Server.MapPath("./REPORT/VAM111/VAM11R.rpt")); report.SetDataSource(dt); DataTable dt1 = new DataTable(); dt1 = (DataTable)Session["UserInfo"]; string Login_Name = dt1.Rows[0]["Name"].ToString(); //CrystalReport Parameter 參數設定 string Program_ID = string.Empty; string LoginUser = string.Empty; string strParFDate = string.Empty; string strParFSType = string.Empty; string strParFTaxType = string.Empty; Program_ID = this.PageCode + "R"; LoginUser = Session["UID"].ToString(); string V_REPORT_TYPE = ""; //資料選擇 if (rdoType1.Checked) V_REPORT_TYPE = "全部"; if (rdoType2.Checked) V_REPORT_TYPE = "廠商進貨"; if (rdoType3.Checked) V_REPORT_TYPE = "廠商退貨"; report.SetParameterValue("par_Program_ID", Program_ID); report.SetParameterValue("par_LoginUser", LoginUser); report.SetParameterValue("par_LoginName", Login_Name); string inDate = (SLP_SLPDateRange.StartDate + ((SLP_SLPDateRange.StartDate.Length == 0 && SLP_SLPDateRange.EndDate.Length == 0) ? "" : "~") + SLP_SLPDateRange.EndDate); if (inDate == "") inDate = "全部"; report.SetParameterValue("par_Date", "進/退貨日期:" + inDate); //string vendor1 = ((TextBox)((ASP.vdm_slp_slp_vendorbase_ascx)SLP_VendorBase1).FindControl("TextBoxName")).Text; string vendor1 = GetVendorName(SLP_VendorBase1.Text.Trim()); //string vendor2 = ((TextBox)((ASP.vdm_slp_slp_vendorbase_ascx)SLP_VendorBase2).FindControl("TextBoxName")).Text; string vendor2 = GetVendorName(SLP_VendorBase2.Text.Trim()); if (SLP_VendorBase1.Text.Trim().Length != 0 && vendor1 == "") vendor1 = Page.Request.Form[((TextBox)((ASP.vdm_slp_slp_vendorbase_ascx)SLP_VendorBase1).FindControl("TextBoxName")).UniqueID]; if (SLP_VendorBase2.Text.Trim().Length != 0 && vendor2 == "") vendor2 = Page.Request.Form[((TextBox)((ASP.vdm_slp_slp_vendorbase_ascx)SLP_VendorBase2).FindControl("TextBoxName")).UniqueID]; string vendor = (SLP_VendorBase1.Text + vendor1 + ((SLP_VendorBase1.Text.Trim().Length == 0 && SLP_VendorBase2.Text.Trim().Length == 0) ? "" : "~") + SLP_VendorBase2.Text + vendor2); if (SLP_VendorBase1.Text.Trim().Length == 0 && SLP_VendorBase2.Text.Trim().Length == 0) vendor = "全部"; report.SetParameterValue("par_Vendor", "供應商:" + vendor); report.SetParameterValue("par_Tax", "課稅別:" + ((DropDownList)SLP_EnumBase.FindControl("D1")).SelectedItem.Text); report.SetParameterValue("par_Type", "資料選擇:" + V_REPORT_TYPE); //檔案匯出 if (exp_type == "btnExport") { System.IO.Stream streamXLS = report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.Excel); byte[] bytesXLS = new byte[streamXLS.Length]; streamXLS.Read(bytesXLS, 0, bytesXLS.Length); streamXLS.Seek(0, System.IO.SeekOrigin.Begin); //Export File Response.ClearContent(); Response.ClearHeaders(); string rpt_name = "供應商暫估貨款明細表.xls"; Response.AddHeader("content-disposition", "attachment;filename=" + HttpUtility.UrlEncode(rpt_name, System.Text.Encoding.UTF8));//匯出檔名 Response.ContentType = "application/vnd.ms-excel"; Response.OutputStream.Write(bytesXLS, 0, bytesXLS.Length); } else { System.IO.Stream streamPDF = report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); byte[] bytesPDF = new byte[streamPDF.Length]; streamPDF.Read(bytesPDF, 0, bytesPDF.Length); streamPDF.Seek(0, System.IO.SeekOrigin.Begin); //Export File Response.ClearContent(); Response.ClearHeaders(); string rpt_name = "供應商暫估貨款明細表.PDF"; Response.AddHeader("content-disposition", "attachment;filename=" + HttpUtility.UrlEncode(rpt_name, System.Text.Encoding.UTF8));//匯出檔名 Response.ContentType = "application/pdf"; Response.OutputStream.Write(bytesPDF, 0, bytesPDF.Length); } Response.Flush(); Response.Close(); } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } finally { } }
private void loadQTY() { ADODB.Recordset rs = default(ADODB.Recordset); ADODB.Recordset rsData = default(ADODB.Recordset); //Dim Report As New cryItemItemCompareQty //ReportNone.Load("cryNoRecords.rpt") CrystalDecisions.CrystalReports.Engine.ReportDocument Report = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); CrystalDecisions.CrystalReports.Engine.ReportDocument ReportNone = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); Report.Load("cryItemItemCompareQty.rpt"); ReportNone.Load("cryNoRecords.rpt"); modReport.cnnDBreport.Execute("DELETE LinkItem.* FROM LinkItem;"); rs = modReport.getRSreport(ref "SELECT * FROM Link Where Link_SectionID=3"); while (!(rs.EOF)) { if (!string.IsNullOrEmpty(rs.Fields("Link_SQL").Value)) { modReport.cnnDBreport.Execute("INSERT INTO LinkItem ( LinkItem_LinkID, LinkItem_DayEndID, LinkItem_Value ) SELECT " + rs.Fields("LinkID").Value + ", DayEndStockItemLnk.DayEndStockItemLnk_DayEndID, DayEndStockItemLnk.DayEndStockItemLnk_QuantitySales FROM DayEndStockItemLnk INNER JOIN aStockItem ON DayEndStockItemLnk.DayEndStockItemLnk_StockItemID = aStockItem.StockItemID WHERE " + rs.Fields("Link_SQL").Value + ";"); } rs.moveNext(); } modReport.cnnDBreport.Execute("INSERT INTO LinkItem ( LinkItem_LinkID, LinkItem_DayEndID, LinkItem_Value ) SELECT theJoin.LinkID, theJoin.DayEndID, 0 FROM LinkItem RIGHT JOIN [SELECT Link.LinkID, DayEnd.DayEndID From Link, DayEnd WHERE (((Link.Link_SQL)<>'') AND ((Link.Link_SectionID)=3))]. AS theJoin ON (LinkItem.LinkItem_DayEndID = theJoin.DayEndID) AND (LinkItem.LinkItem_LinkID = theJoin.LinkID) WHERE (((LinkItem.LinkItem_LinkID) Is Null));"); System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor; rs = modReport.getRSreport(ref "SELECT Report.Report_Heading, aCompany.Company_Name FROM aCompany, Report;"); Report.SetParameterValue("txtCompanyName", rs.Fields("Company_Name")); Report.SetParameterValue("txtDayEnd", rs.Fields("Report_Heading")); rs.Close(); rs = modReport.getRSreport(ref "SELECT [Link].[LinkID], [Link].[Link_Name], Sum([LinkItem].[LinkItem_Value]) AS SumOfLinkItem_Value FROM Link INNER JOIN LinkItem ON [Link].[LinkID]=[LinkItem].[LinkItem_LinkID] WHERE ((([Link].[Link_SQL])<>'') And (([Link].[Link_SectionID])=3)) GROUP BY [Link].[LinkID], [Link].[Link_Name] ORDER BY [Link].[LinkID];"); if (rs.BOF | rs.EOF) { ReportNone.SetParameterValue("txtCompanyName", Report.ParameterFields("txtCompanyName").ToString); ReportNone.SetParameterValue("txtTitle", Report.ParameterFields("txtTitle").ToString); My.MyProject.Forms.frmReportShow.Text = ReportNone.ParameterFields("txtTitle").ToString; My.MyProject.Forms.frmReportShow.CRViewer1.ReportSource = ReportNone; My.MyProject.Forms.frmReportShow.mReport = ReportNone; My.MyProject.Forms.frmReportShow.sMode = "0"; My.MyProject.Forms.frmReportShow.CRViewer1.Refresh(); System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default; My.MyProject.Forms.frmReportShow.ShowDialog(); return; } rsData = modReport.getRSreport(ref "SELECT LinkItem.*, Format([DayEnd_Date],'yyyy mm dd ddd') AS dateName, DayEnd.DayEnd_Date FROM DayEnd INNER JOIN LinkItem ON DayEnd.DayEndID = LinkItem.LinkItem_DayEndID ORDER BY DayEnd.DayEnd_Date;"); if (rsData.BOF | rsData.EOF) { ReportNone.SetParameterValue("txtCompanyName", Report.ParameterFields("txtCompanyName").ToString); ReportNone.SetParameterValue("txtTitle", Report.ParameterFields("txtTitle").ToString); My.MyProject.Forms.frmReportShow.Text = ReportNone.ParameterFields("txtTitle").ToString; My.MyProject.Forms.frmReportShow.CRViewer1.ReportSource = ReportNone; My.MyProject.Forms.frmReportShow.mReport = ReportNone; My.MyProject.Forms.frmReportShow.sMode = "0"; My.MyProject.Forms.frmReportShow.CRViewer1.Refresh(); //UPGRADE_WARNING: Screen property Screen.MousePointer has a new behavior. Click for more: 'ms-help://MS.VSCC.v90/dv_commoner/local/redirect.htm?keyword="6BA9B8D2-2A32-4B6E-8D36-44949974A5B4"' System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default; My.MyProject.Forms.frmReportShow.ShowDialog(); return; } Report.Database.Tables(1).SetDataSource(rs); Report.Database.Tables(2).SetDataSource(rsData); System.Windows.Forms.Application.DoEvents(); //Report.VerifyOnEveryPrint = True System.Windows.Forms.Application.DoEvents(); My.MyProject.Forms.frmReportShow.Text = Report.ParameterFields("txtTitle").ToString; My.MyProject.Forms.frmReportShow.CRViewer1.ReportSource = Report; My.MyProject.Forms.frmReportShow.mReport = Report; My.MyProject.Forms.frmReportShow.sMode = "0"; My.MyProject.Forms.frmReportShow.CRViewer1.Refresh(); System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default; My.MyProject.Forms.frmReportShow.ShowDialog(); }