private void Logon_Cr() { crConnectionInfo.ServerName = server; crConnectionInfo.DatabaseName = Db; crConnectionInfo.UserID = Username; crConnectionInfo.Password = Password; CrTables = rptDoc.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } foreach (ReportDocument sr in rptDoc.Subreports) { foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in sr.Database.Tables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } } }
private void PrintReport_Challan() { ReportDocument cryRpt = new ReportDocument(); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); string rPath = ReportPaths + "CrystalReportSalesInvoiceChallanA4.rpt"; cryRpt.Load(rPath); cryRpt.Load(rPath); crConnectionInfo.ServerName = ConfigurationManager.ConnectionStrings["cryServer"].ToString(); crConnectionInfo.DatabaseName = ConfigurationManager.ConnectionStrings["cryDatabase"].ToString(); crConnectionInfo.UserID = ConfigurationManager.ConnectionStrings["cryUserID"].ToString(); crConnectionInfo.Password = ConfigurationManager.ConnectionStrings["cryPass"].ToString(); foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in cryRpt.Database.Tables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } crystalReportViewer1.ReportSource = cryRpt; crystalReportViewer1.RefreshReport(); }
private void Logininfo() { TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); crtableLogoninfo.ConnectionInfo.IntegratedSecurity = false; //ConnectionInfo crConnectionInfo = new ConnectionInfo(); //Tables CrTables; ClientStatementReport.LogOnInfo = new CrystalDecisions.Shared.TableLogOnInfos(); //ReportDocument myreport = new ReportDocument(); //CrTables = myreport.Database.Tables; //CrTables = rpt.Database.Tables; //foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) //{ // crtableLogoninfo.ConnectionInfo.ServerName = ConfigurationManager.AppSettings["ServerName"]; // crtableLogoninfo.ConnectionInfo.DatabaseName = ConfigurationManager.AppSettings["DatabaseName"]; // crtableLogoninfo.ConnectionInfo.UserID = ConfigurationManager.AppSettings["UserName"]; // crtableLogoninfo.ConnectionInfo.Password = ConfigurationManager.AppSettings["Password"]; // CrTable.ApplyLogOnInfo(crtableLogoninfo); //} foreach (ReportDocument subreport in rpt.Subreports) { foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in subreport.Database.Tables) { crtableLogoninfo = CrTable.LogOnInfo; //crtableLogoninfo.ConnectionInfo = EPAKconnectionInfo; crtableLogoninfo.ConnectionInfo.ServerName = ConfigurationManager.AppSettings["ServerName"]; crtableLogoninfo.ConnectionInfo.DatabaseName = ConfigurationManager.AppSettings["DatabaseName"]; crtableLogoninfo.ConnectionInfo.UserID = ConfigurationManager.AppSettings["UserName"]; crtableLogoninfo.ConnectionInfo.Password = ConfigurationManager.AppSettings["Password"]; CrTable.ApplyLogOnInfo(crtableLogoninfo); } } ClientStatementReport.LogOnInfo.Add(crtableLogoninfo); }
private void hiendein(string query, double giabandau, double giaketthuc) { ReportDocument rpt = new ReportDocument(); //tạo mới 1 report document TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); rpt.Load(@"C:\Users\HP\source\repos\demobtl2\demobtl2\CrHD.rpt"); // đường dẫn load rpt Tables CrTables; CrTables = rpt.Database.Tables; crConnectionInfo.IntegratedSecurity = true; /// đăng nhập với quyền windows foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } crystalReportViewer1.Refresh(); rpt.SetParameterValue("@action", query); rpt.SetParameterValue("@giabandau", giabandau); rpt.SetParameterValue("@giaketthuc", giaketthuc); crystalReportViewer1.ReportSource = rpt;//// chọ nguồn dữ liệu cho crystal Report }
public ReportDocument MuestraEnVisor(List <string> ValoresParametros) { ultimoMensaje = ""; numError = 0; try { ReportDocument cryRpt = new ReportDocument(); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; ParameterFieldDefinitions crParameterFieldDefinitions; ParameterFieldDefinition crParameterFieldDefinition; ParameterValues crParameterValues = new ParameterValues(); ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue(); PageMargins margins; cryRpt.Load(_param.rutaReporteCrystal); //Conecta la base de datos crConnectionInfo.IntegratedSecurity = _IntegratedSecurity; crConnectionInfo.ServerName = _SrvrName; crConnectionInfo.DatabaseName = _DbName; if (!_IntegratedSecurity) { crConnectionInfo.UserID = _IdUsuario; crConnectionInfo.Password = _Password; } CrTables = cryRpt.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } int i = 0; foreach (PrmtrsReporte pr in _param.ListaParametrosReporte) { //Envía parámetros al reporte crParameterDiscreteValue.Value = ValoresParametros[i]; //valor crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions[pr.nombre.Trim()]; //nombre parámetro crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); i++; } //Define márgenes si existen parámetros if (_param.bottomMargin >= 0 && _param.topMargin >= 0 && _param.leftMargin >= 0 && _param.rightMargin >= 0) { margins = cryRpt.PrintOptions.PageMargins; margins.bottomMargin = _param.bottomMargin; margins.topMargin = _param.topMargin; margins.leftMargin = _param.leftMargin; margins.rightMargin = _param.rightMargin; cryRpt.PrintOptions.ApplyPageMargins(margins); } if (_param.ImprimeEnImpresora) { cryRpt.PrintOptions.PrinterName = _param.NombreImpresora; cryRpt.PrintToPrinter(1, false, 0, 0); } return(cryRpt); } catch (Exception exVis) { ultimoMensaje = "No se puede mostrar el reporte. [MuestraEnVisor] " + exVis.Message; numError++; return(null); } }
/// <summary> /// Guarda el archivo pdf usando Crystal reports. /// </summary> /// <param name="Param"></param> /// <param name="ValoresParametros">Datos del comprobante que son los parámetros del reporte. El orden es importante.</param> /// <param name="RutaPDF">Ruta donde se guarda el pdf. Incluye el nombre del archivo.</param> /// <returns></returns> public bool GuardaDocumentoEnPDF(List <string> ValoresParametros, string RutaPDF) { ultimoMensaje = ""; numError = 0; try { ReportDocument cryRpt = new ReportDocument(); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; ParameterFieldDefinitions crParameterFieldDefinitions; ParameterFieldDefinition crParameterFieldDefinition; ParameterValues crParameterValues = new ParameterValues(); ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue(); PageMargins margins; cryRpt.Load(_param.rutaReporteCrystal); //Conecta la base de datos crConnectionInfo.IntegratedSecurity = _IntegratedSecurity; crConnectionInfo.ServerName = _SrvrName; crConnectionInfo.DatabaseName = _DbName; if (!_IntegratedSecurity) { crConnectionInfo.UserID = _IdUsuario; crConnectionInfo.Password = _Password; } CrTables = cryRpt.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } int i = 0; foreach (PrmtrsReporte pr in _param.ListaParametrosReporte) { //Envía parámetros al reporte crParameterDiscreteValue.Value = ValoresParametros[i]; //valor crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions[pr.nombre.Trim()]; //nombre parámetro crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); i++; } //Define márgenes si existen parámetros if (_param.bottomMargin >= 0 && _param.topMargin >= 0 && _param.leftMargin >= 0 && _param.rightMargin >= 0) { margins = cryRpt.PrintOptions.PageMargins; margins.bottomMargin = _param.bottomMargin; margins.topMargin = _param.topMargin; margins.leftMargin = _param.leftMargin; margins.rightMargin = _param.rightMargin; cryRpt.PrintOptions.ApplyPageMargins(margins); } //Convierte a pdf ExportOptions CrExportOptions; DiskFileDestinationOptions CrDiskFileDestinationOptions = new DiskFileDestinationOptions(); PdfRtfWordFormatOptions CrFormatTypeOptions = new PdfRtfWordFormatOptions(); CrDiskFileDestinationOptions.DiskFileName = RutaPDF; CrExportOptions = cryRpt.ExportOptions; { CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile; CrExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat; CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions; CrExportOptions.FormatOptions = CrFormatTypeOptions; } cryRpt.Export(); return(true); } catch (DirectoryNotFoundException) { ultimoMensaje = "Verifique la existencia de la ruta indicada en la configuración de Ruta de archivos Xml. [GuardaDocumentoEnPDF] La ruta no pudo ser encontrada: " + RutaPDF; numError++; return(false); } catch (IOException) { ultimoMensaje = "Verifique permisos de escritura en: " + RutaPDF + ". No se pudo guardar el archivo xml ni registrar el documento en la bitácora. [GuardaDocumentoEnPDF]"; numError++; return(false); } catch (Exception exPdf) { if (exPdf.Message.Contains("denied")) { ultimoMensaje = "Elimine el archivo antes de volver a generar uno nuevo. Luego vuelva a intentar. [GuardaDocumentoEnPDF] " + exPdf.Message; } else { ultimoMensaje = "Advertencia, no se guardó el reporte PDF. [GuardaDocumentoEnPDF] " + exPdf.Message; } numError++; return(false); } }
void LoadInventoryReport() { try { this.Cursor = Cursors.WaitCursor; ReportDocument cryRpt = new ReportDocument(); ReportObjects crReportObjects; SubreportObject crSubreportObject; ReportDocument crSubreportDocument; Database crDatabase; TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; string s = ""; if (this.reportType == ReportType.Allocations) { s = Application.StartupPath + @"\Reports\GCKAllocationsReport.rpt"; } // Application.StartupPath + else if (this.reportType == ReportType.Cancellations) { s = Application.StartupPath + @"\Reports\GCKCancellationsReport.rpt"; } // Application.StartupPath + else if (this.reportType == ReportType.Reactivations) { s = Application.StartupPath + @"\Reports\GCKReactivationsReport.rpt"; } // Application.StartupPath + else if (this.reportType == ReportType.Refund) { s = Application.StartupPath + @"\Reports\GCKRefundReport.rpt"; } // Application.StartupPath + else if (this.reportType == ReportType.Transfer) { s = Application.StartupPath + @"\Reports\GCKTransferReport.rpt"; } // Application.StartupPath + else if (this.reportType == ReportType.InventoryReport) { s = Application.StartupPath + @"\Reports\GCKInventory.rpt"; } // Application.StartupPath + else if (this.reportType == ReportType.SoldPlotsByMemberShip) { s = Application.StartupPath + @"\Reports\GCKSoldPlots.rpt"; } // Application.StartupPath + else if (this.reportType == ReportType.ClientWiseMemberProfile) { s = Application.StartupPath + @"\Reports\GCKClientWiseProfile.rpt"; } // Application.StartupPath + else if (this.reportType == ReportType.ClientWisePurchaseHistory) { s = Application.StartupPath + @"\Reports\GCKClientWisePurchaseHistory.rpt"; } else if (this.reportType == ReportType.AccountStatement) { s = Application.StartupPath + @"\Reports\GCKMemberInfo.rpt"; } else if (this.reportType == ReportType.InventoryReportSizeWise) { s = Application.StartupPath + @"\Reports\01-InventoryReportSizeWise.rpt"; } else if (this.reportType == ReportType.InventoryReportSectorWise) { s = Application.StartupPath + @"\Reports\02-InventoryReportSectorWise.rpt"; } else if (this.reportType == ReportType.SizeWiseQuota) { s = Application.StartupPath + @"\Reports\03-SizeWiseQuota.rpt"; } else if (this.reportType == ReportType.SectorWiseQuota) { s = Application.StartupPath + @"\Reports\04-SectorWiseQuota.rpt"; } else if (this.reportType == ReportType.QuotaWiseReport) { s = Application.StartupPath + @"\Reports\05-QuotaWiseReport.rpt"; } else if (this.reportType == ReportType.ProspectReport) { s = Application.StartupPath + @"\Reports\06-ProspectReport.rpt"; } else if (this.reportType == ReportType.Receipt) { s = Application.StartupPath + @"\Reports\07-ReceiptPrintContainer.rpt"; } else if (this.reportType == ReportType.Membership) { s = Application.StartupPath + @"\Reports\08-MemberRegistration.rpt"; } else if (this.reportType == ReportType.MasterSales) { s = Application.StartupPath + @"\Reports\09-MasterSalesReport.rpt"; } else if (this.reportType == ReportType.UnitList) { s = Application.StartupPath + @"\Reports\10-UnitsList.rpt"; } else if (this.reportType == ReportType.RecoveryDueReport) { s = Application.StartupPath + @"\Reports\11-RecoveryDueReport.rpt"; } else if (this.reportType == ReportType.DuesOutstanding) { s = Application.StartupPath + @"\Reports\12-DuesOutstandingReport.rpt"; } else if (this.reportType == ReportType.ReceiptDetail) { s = Application.StartupPath + @"\Reports\13-ReceiptDetailReport.rpt"; } else if (this.reportType == ReportType.NotCleared) { s = Application.StartupPath + @"\Reports\14-NotClearedReceiptsReport.rpt"; } cryRpt.Load(s); ConnectionInfo connInfo = new ConnectionInfo(); SqlConnectionStringBuilder builder = new DataAccess().GetCredentials(); crConnectionInfo.ServerName = builder.DataSource; crConnectionInfo.DatabaseName = builder.InitialCatalog; crConnectionInfo.UserID = builder.UserID; crConnectionInfo.Password = builder.Password; Sections ReportSections = cryRpt.ReportDefinition.Sections; foreach (Section section in ReportSections) { crReportObjects = section.ReportObjects; foreach (ReportObject crReportObject in crReportObjects) { if (crReportObject.Kind != ReportObjectKind.SubreportObject) { continue; } crSubreportObject = (SubreportObject)crReportObject; crSubreportDocument = crSubreportObject.OpenSubreport(crSubreportObject.SubreportName); crDatabase = crSubreportDocument.Database; CrTables = crDatabase.Tables; foreach (Table CrTable in CrTables) { TableLogOnInfo crTableLogOnInfo = CrTable.LogOnInfo; crTableLogOnInfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crTableLogOnInfo); } } } CrTables = cryRpt.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } if (this.reportType == ReportType.InventoryReport) { cryRpt.SetParameterValue("@ProjectID", strProjectID); cryRpt.SetParameterValue("@SizeCode", strSizeCode); cryRpt.SetParameterValue("@Sector", strBlockNo); cryRpt.SetParameterValue("@StatusCode", intStatusCode); } else if (this.reportType == ReportType.SoldPlotsByMemberShip) { cryRpt.SetParameterValue("@ProjectID", strProjectID); cryRpt.SetParameterValue("@Sector", strBlockNo); cryRpt.SetParameterValue("@StartDate", dtFromDate.Date); cryRpt.SetParameterValue("@EndDate", dtToDate.Date); } else if (this.reportType == ReportType.Allocations) { cryRpt.SetParameterValue("@ProjectID", strProjectID); cryRpt.SetParameterValue("@StartDate", dtFromDate.Date); cryRpt.SetParameterValue("@EndDate", dtToDate.Date); cryRpt.SetParameterValue("@ApprovalStatusCode", intStatusCode); } else if (this.reportType == ReportType.Cancellations) { cryRpt.SetParameterValue("@ProjectID", strProjectID); cryRpt.SetParameterValue("@StartDate", dtFromDate.Date); cryRpt.SetParameterValue("@EndDate", dtToDate.Date); cryRpt.SetParameterValue("@ApprovalStatusCode", intStatusCode); } else if (this.reportType == ReportType.Reactivations) { cryRpt.SetParameterValue("@ProjectID", strProjectID); cryRpt.SetParameterValue("@StartDate", dtFromDate.Date); cryRpt.SetParameterValue("@EndDate", dtToDate.Date); cryRpt.SetParameterValue("@ApprovalStatusCode", intStatusCode); } else if (this.reportType == ReportType.Transfer) { cryRpt.SetParameterValue("@ProjectID", strProjectID); cryRpt.SetParameterValue("@StartDate", dtFromDate.Date); cryRpt.SetParameterValue("@EndDate", dtToDate.Date); cryRpt.SetParameterValue("@ApprovalStatusCode", intStatusCode); } else if (this.reportType == ReportType.Refund) { cryRpt.SetParameterValue("@ProjectID", strProjectID); cryRpt.SetParameterValue("@StartDate", dtFromDate.Date); cryRpt.SetParameterValue("@EndDate", dtToDate.Date); cryRpt.SetParameterValue("@ApprovalStatusCode", intStatusCode); } else if (this.reportType == ReportType.ClientWiseMemberProfile) { cryRpt.SetParameterValue("@ClientID", strDocumentNumber); } else if (this.reportType == ReportType.ClientWisePurchaseHistory) { cryRpt.SetParameterValue("@ClientID", strDocumentNumber); } else if (this.reportType == ReportType.AccountStatement) { cryRpt.SetParameterValue("@reg", strRegistrationNo); } else if (this.reportType == ReportType.ProspectReport) { cryRpt.SetParameterValue("@id", prosid); } else if (this.reportType == ReportType.Membership) { cryRpt.SetParameterValue("@RegNo", strRegistrationNo); } else if (this.reportType == ReportType.Receipt) { cryRpt.SetParameterValue("ReceiptNumber", receipt.ReceiptNumber); cryRpt.SetParameterValue("RegNo", receipt.RegistrationNo); cryRpt.SetParameterValue("ReceiptDate", receipt.ReceiptDate.Date); cryRpt.SetParameterValue("Amount", receipt.ReceiptAmount); cryRpt.SetParameterValue("PlotSize", receipt.PlotSize); cryRpt.SetParameterValue("PaymentMode", receipt.ReceiptMode); cryRpt.SetParameterValue("InstrumentNo", receipt.InstrumentNumber); cryRpt.SetParameterValue("BankAndBranch", receipt.DraweeBank + " " + receipt.DraweeBranch); cryRpt.SetParameterValue("InstrumentDate", receipt.InstrumentDate); cryRpt.SetParameterValue("From", receipt.ClientName); cryRpt.SetParameterValue("FatherName", receipt.FatherName); cryRpt.SetParameterValue("Remarks", receipt.Remarks); cryRpt.SetParameterValue("OnAccountOf", receipt.OnAccountOf); cryRpt.SetParameterValue("Deposit By", receipt.DepositBy); } else if (this.reportType == ReportType.MasterSales) { cryRpt.SetParameterValue("@project", strProjectID); cryRpt.SetParameterValue("@Block", strBlockNo); cryRpt.SetParameterValue("@StartBookingDate", dtFromDate.Date); cryRpt.SetParameterValue("@EndBookingDate", dtToDate.Date); } else if (this.reportType == ReportType.UnitList) { cryRpt.SetParameterValue("@project", strProjectID); cryRpt.SetParameterValue("@Block", strBlockNo); cryRpt.SetParameterValue("@Status", strStatusCode); cryRpt.SetParameterValue("@SizeCode", strSizeCode); } else if (this.reportType == ReportType.RecoveryDueReport) { cryRpt.SetParameterValue("@project", strProjectID); cryRpt.SetParameterValue("@Block", strBlockNo); cryRpt.SetParameterValue("@StartDate", dtFromDate.Date); cryRpt.SetParameterValue("@EndDate", dtToDate.Date); } else if (this.reportType == ReportType.DuesOutstanding) { cryRpt.SetParameterValue("@Block", strBlockNo); cryRpt.SetParameterValue("@StartRegNo", strRegistrationNo); cryRpt.SetParameterValue("@EndRegNo", strDocumentNumber); cryRpt.SetParameterValue("@TillDate", dtFromDate.Date); cryRpt.SetParameterValue("@StatusCode", intStatusCode); } else if (this.reportType == ReportType.ReceiptDetail) { cryRpt.SetParameterValue("@SizeCode", strSizeCode); cryRpt.SetParameterValue("@StartDate", dtFromDate.Date); cryRpt.SetParameterValue("@EndDate", dtToDate.Date); cryRpt.SetParameterValue("@StatusCode", intStatusCode); } else if (this.reportType == ReportType.NotCleared) { cryRpt.SetParameterValue("@SizeCode", strSizeCode); cryRpt.SetParameterValue("@StartDate", dtFromDate.Date); cryRpt.SetParameterValue("@EndDate", dtToDate.Date); cryRpt.SetParameterValue("@StatusCode", intStatusCode); } rptViewer.ReportSource = cryRpt; rptViewer.Refresh(); } catch (Exception ex) { MessageBox.Show("Exception:" + ex.Message); return; } this.Cursor = Cursors.Arrow; }
private void frmRAdelantos_Load(object sender, EventArgs e) { try { ExcelFormatOptions objExcel = new ExcelFormatOptions(); string fechaInicio = ""; string fechaFin = ""; int idTrabajador = 0; string estado = frmReporteAdelantos.f1.cbEstado.Text; if (frmReporteAdelantos.f1.cbTrabajador.Checked == true) { idTrabajador = Convert.ToInt32(frmReporteAdelantos.f1.cbEmpleado.SelectedValue); } else if (frmReporteAdelantos.f1.cbTrabajador.Checked == false) { idTrabajador = 0; } fechaInicio = frmReporteAdelantos.f1.dtpFechaInicio.Value.ToString("yyyy-MM-dd" + " 00:00:00"); fechaFin = frmReporteAdelantos.f1.dtpFechaFin.Value.ToString("yyyy-MM-dd" + " 23:59:59"); //int idProducto = Convert.ToInt32(frmReporteVentasProducto.f1.cbProducto.SelectedValue); ReportDocument repdoc = new ReportDocument(); // repdoc.Load(@"C:\Users\vioma\OneDrive\Documentos\Visual Studio 2017\Projects\SisVentas_ResAlm\CapaPresentacion\Reportes/RVentaProducto.rpt"); repdoc.Load(@"D:\Reportes\RAdelantoRemuneracion.rpt"); ParameterFieldDefinitions pfds; ParameterFieldDefinition pfd; ParameterValues pvs = new ParameterValues(); ParameterDiscreteValue pdv = new ParameterDiscreteValue(); pdv.Value = Convert.ToDateTime(fechaInicio); pfds = repdoc.DataDefinition.ParameterFields; pfd = pfds["@fechaInicio"]; pvs.Add(pdv); pfd.ApplyCurrentValues(pvs); pdv.Value = Convert.ToDateTime(fechaFin); pfds = repdoc.DataDefinition.ParameterFields; pfd = pfds["@fechaFin"]; pvs.Add(pdv); pfd.ApplyCurrentValues(pvs); pdv.Value = idTrabajador; pfds = repdoc.DataDefinition.ParameterFields; pfd = pfds["@idTrabajador"]; pvs.Add(pdv); pfd.ApplyCurrentValues(pvs); pdv.Value = estado; pfds = repdoc.DataDefinition.ParameterFields; pfd = pfds["@estado"]; pvs.Add(pdv); pfd.ApplyCurrentValues(pvs); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; crConnectionInfo.ServerName = @"EQUIPO\SQLEXPRESS"; crConnectionInfo.DatabaseName = "BD_RESTAURANTE"; crConnectionInfo.UserID = "admin"; crConnectionInfo.Password = "******"; CrTables = repdoc.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } cvVentas.ReportSource = repdoc; cvVentas.Refresh(); objExcel.ExcelUseConstantColumnWidth = false; } catch (Exception ex) { MessageBox.Show("ERROR" + ex); } }
private void ReportsDTR_Load(object sender, EventArgs e) { SqlConnection sqlcnn = PSSClass.DBConnection.PSSConnection(); if (sqlcnn == null) { MessageBox.Show("Connection problems encountered." + Environment.NewLine + "Please contact your administrator.", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } ReportDocument crDoc = new ReportDocument(); SqlCommand sqlcmd = new SqlCommand(); Tables CrTables; ConnectionInfo crConnectionInfo = new ConnectionInfo(); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); crConnectionInfo.Type = ConnectionInfoType.SQL; crConnectionInfo.ServerName = "172.16.4.12"; crConnectionInfo.DatabaseName = "PTS"; crConnectionInfo.IntegratedSecurity = false; crConnectionInfo.UserID = "sa"; crConnectionInfo.Password = "******"; crtableLogoninfo.ConnectionInfo = crConnectionInfo; string rpt = ""; DataTable dt = new DataTable(); if (rptName == "DTA") { rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "DTA.rpt"; crDoc.Load(rpt); crDoc.DataDefinition.FormulaFields["strPeriod"].Text = "'" + Convert.ToDateTime(rptLogDate).ToLongDateString().ToUpper() + "'"; dt = PSSClass.DTR.RptDTA(Convert.ToDateTime(rptLogDate)); } else if (rptName == "PTA" || rptName == "PTASummary") { if (rptName == "PTA") { rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "PTA.rpt"; } else { rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "PTASummary.rpt"; } crDoc.Load(rpt); crDoc.DataDefinition.FormulaFields["strPeriod"].Text = "'" + rptLogDate + "'"; dt = PSSClass.DTR.RptPTA(Convert.ToDateTime(rptDateFrom), Convert.ToDateTime(rptDateTo)); } else if (rptName == "EmpPTA") { rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "PTAEMp.rpt"; crDoc.Load(rpt); crDoc.DataDefinition.FormulaFields["strPeriod"].Text = "'" + rptLogDate + "'"; dt = PSSClass.DTR.RptPTAEmp(Convert.ToDateTime(rptDateFrom), Convert.ToDateTime(rptDateTo), rptEmpID); } else if (rptName == "PayrollTA") { rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\PayHoursDtls.rpt"; crDoc.Load(rpt); crDoc.DataDefinition.FormulaFields["strPeriod"].Text = "'" + rptLogDate + "'"; dt = PSSClass.DTR.RptPayrollHours(Convert.ToDateTime(rptDateFrom), Convert.ToDateTime(rptDateTo), Convert.ToDateTime(rptDateFrom2), Convert.ToDateTime(rptDateTo2)); } CrTables = crDoc.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } crDoc.SetDataSource(dt); crReport.ReportSource = crDoc; crReport.Refresh(); }
private void EquipmentRpt_Load(object sender, EventArgs e) { Tables CrTables; ConnectionInfo crConnectionInfo = new ConnectionInfo(); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); crConnectionInfo.Type = ConnectionInfoType.SQL; crConnectionInfo.ServerName = "172.16.4.12"; crConnectionInfo.DatabaseName = "PTS"; crConnectionInfo.IntegratedSecurity = false; crConnectionInfo.UserID = "sa"; crConnectionInfo.Password = "******"; crtableLogoninfo.ConnectionInfo = crConnectionInfo; SqlConnection sqlcnn = PSSClass.DBConnection.PSSConnection(); if (sqlcnn == null) { MessageBox.Show("Connection problems encountered." + Environment.NewLine + "Please contact your administrator.", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } SqlCommand sqlcmd = new SqlCommand(); SqlDataReader sqldr; string rpt = ""; if (rptName == "EqptValMstrPlan") { rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "ValCalDatabase.rpt"; sqlcmd = new SqlCommand("spGetValMstrPlan", sqlcnn); } else if (rptName == "EqptServiceRecord") { rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "EqptServiceRecord.rpt"; sqlcmd = new SqlCommand("spRptEqptServiceRecord", sqlcnn); sqlcmd.Parameters.AddWithValue("EqptCode", pubEqptCode); sqlcmd.Parameters.AddWithValue("SrvcType", pubEqptSrvcType); sqlcmd.CommandType = CommandType.StoredProcedure; } crDoc.Load(rpt); CrTables = crDoc.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } sqldr = sqlcmd.ExecuteReader(); DataTable dTable = new DataTable(); try { dTable.Load(sqldr); sqlcnn.Dispose(); } catch { sqlcnn.Dispose(); } crDoc.SetDataSource(dTable); crReport.ReportSource = crDoc; crReport.Refresh(); }
private void btnView_Click(object sender, EventArgs e) { try { ReportDocument CrRep = new ReportDocument(); CRT2 = ""; CRT3 = ""; fnd = false; DateTime edt1 = dt1.Value; DateTime edt2 = dt2.Value;; // string sdt2 = string.Format("yyyy,MM,dd,00,00,00", Gvar.ArCalendar(dt2.Value, true)); string adate1 = dt1.Value.Date.ToString("dd-MM-yyyy"); string adate2 = dt2.Value.Date.ToString("dd-MM-yyyy"); string sdt1 = edt1.Date.ToString("yyyy,MM,dd,00,00,00"); string sdt2 = edt2.Date.ToString("yyyy,MM,dd,23,59,59"); string hd3; hd3 = "'Report'"; crt1 = ""; switch (Gvar._Gind) { case 1: { rep_path = Gvar.report_path + "\\reports\\RepProject.rpt"; CrRep.Load(rep_path); //DateTime edt1 = Convert.ToDateTime(Gvar.ArCalendar(dt1.Value, true,false)); //DateTime edt2 = Convert.ToDateTime(Gvar.ArCalendar(dt2.Value, true,false)); goto nxt; string rdt1 = dt1.Value.ToString("dd/MM/yyyy"); string rdt2 = dt2.Value.ToString("dd/MM/yyyy"); if (!chkdate.Checked) { crt1 = " {TRN_ACCOUNTS.PAY_DATE} in DateTime (" + sdt1 + ") to DateTime (" + sdt2 + ")"; RPTHEAD = "Account Summary From " + rdt1 + " To " + rdt2; } else { RPTHEAD = "Account Summary Report for All Dates"; crt1 = ""; } //crt1 = crt1 + " And ({QRY_ITEM.TRN_TYPE} = 2 Or {QRY_ITEM.TRN_TYPE} =8)"; string crt2 = ""; if (cmbowner.SelectedIndex < 1) { // crt2 = "{accounts.acc_type_code} <> -1"; } else { crt2 = "{accounts.acc_type_code} = " + cmbowner.SelectedValue; RPTHEAD = RPTHEAD + " for Type " + cmbowner.Text; } fnd = false; string crt4 = ""; lst1.EndEdit(); int i = 0; if (chklst1.Checked) { //crt4 = "{accounts.acc_no} <> -1"; fnd = true; } else { for (i = 0; i < lst1.RowCount; i++) { if (lst1[0, i].Value != null) { if ((bool)lst1[0, i].Value) { if (crt4 == "") { crt4 = lst1[2, i].Value.ToString(); } else { crt4 = crt4 + "," + lst1[2, i].Value.ToString(); } fnd = true; } } } crt4 = "{accounts.acc_no} in [" + crt4 + "]"; RPTHEAD = RPTHEAD + ", for Accounts " + crt4; } if (!fnd) { MessageBox.Show("There is No Accounts selected, Please Try AGain", "Wrong Selection"); return; } fnd = false; string crt3 = ""; lst2.EndEdit(); //if (chklst2.Checked) //{ // // crt3 = "{accounts.acc_no} <> -1"; // fnd = true; //} //else //{ // for (i = 0; i < lst2.RowCount; i++) // { // if (lst2[0, i].Value != null) // { // if ((bool)lst2[0, i].Value) // { // if (crt3 == "") // { // crt3 = lst2[1, i].Value.ToString(); // } // else // { // crt3 = crt3 + "," + lst2[1, i].Value.ToString(); // } // fnd = true; // } // } // } // crt3 = "{TRN_accounts.acc_no} in [" + crt3 + "]"; //} //if (!fnd) //{ // MessageBox.Show("There is No Account selected, Please Try Again", "Wrong Vehicle Selection"); // return; //} string crt5 = ""; if (cmbsaleagent.SelectedIndex < 1) { // crt2 = "{accounts.acc_type_code} <> -1"; } else { crt5 = "{accounts.account_link} = " + cmbsaleagent.SelectedValue; RPTHEAD = RPTHEAD + " for Saleagent " + cmbsaleagent.Text; } string crt6 = ""; if (cmblocaltion.SelectedIndex < 1) { // crt2 = "{accounts.acc_type_code} <> -1"; } else { crt6 = "{accounts_info.area_name} = '" + cmblocaltion.Text + "'"; RPTHEAD = RPTHEAD + " for Area " + cmblocaltion.Text; } string crt = ""; if (crt1 != "") { if (crt != "") { crt = crt + " aND " + crt1; } else { crt = crt1; } } if (crt2 != "") { if (crt != "") { crt = crt + " aND " + crt2; } else { crt = crt2; } } if (crt3 != "") { if (crt != "") { crt = crt + " aND " + crt3; } else { crt = crt3; } } // if (crt3 != "") crt = crt + " aND " + crt3; //if (crt4 != "") crt = crt + " aND " + crt4; //crt = crt + " aND " + crt4 + " AND {DATA_ENTRY.TRN_TYPE} = 7"; if (crt4 != "") { if (crt != "") { crt = crt + " aND " + crt4; } else { crt = crt4; } } if (crt5 != "") { if (crt != "") { crt = crt + " aND " + crt5; } else { crt = crt5; } } if (crt6 != "") { if (crt != "") { crt = crt + " aND " + crt6; } else { crt = crt6; } } //if (crt1 != "") crt2 = crt1 + " And " + crt2; rep_formula = crt; // 2 + " aND " + crt3 + " aND " + crt4;// +" AND {QRY_ITEM.QTY}<>0"; CrRep.SummaryInfo.ReportTitle = RPTHEAD; // "Account Detail Report from " + rdt1 + " To " + rdt2; if (cmbtransaction.SelectedIndex == 1) { if (crt == "") { rep_formula = "{TRN_accounts.DR_CR}='D'"; } else { rep_formula = crt + " AND {TRN_accounts.DR_CR}='D'"; } CrRep.SummaryInfo.ReportTitle = RPTHEAD + " , FOR " + cmbtransaction.Text; } if (cmbtransaction.SelectedIndex == 2) { if (crt == "") { rep_formula = "{TRN_accounts.DR_CR}='C'"; } else { rep_formula = crt + " AND {TRN_accounts.DR_CR}='C'"; } CrRep.SummaryInfo.ReportTitle = RPTHEAD + " , FOR " + cmbtransaction.Text; } nxt :; } break; case 2: { rep_path = Gvar.report_path + "\\reports\\repacctrans.rpt"; CrRep.Load(rep_path); //DateTime edt1 = Convert.ToDateTime(Gvar.ArCalendar(dt1.Value, true,false)); //DateTime edt2 = Convert.ToDateTime(Gvar.ArCalendar(dt2.Value, true,false)); string rdt1 = dt1.Value.ToString("dd/MM/yyyy"); string rdt2 = dt2.Value.ToString("dd/MM/yyyy"); if (!chkdate.Checked) { crt1 = " {TRN_ACCOUNTS.PAY_DATE} in DateTime (" + sdt1 + ") to DateTime (" + sdt2 + ")"; RPTHEAD = "Account Detail From " + rdt1 + " To " + rdt2; } else { RPTHEAD = "Accounts Detail Report for All Date "; } //crt1 = crt1 + " And ({QRY_ITEM.TRN_TYPE} = 2 Or {QRY_ITEM.TRN_TYPE} =8)"; string crt2 = ""; if (cmbowner.SelectedIndex < 1) { // crt2 = "{accounts.acc_type_code} <> -1"; } else { crt2 = "{accounts.acc_type_code} = " + cmbowner.SelectedValue; RPTHEAD = RPTHEAD + ", for Type " + cmbowner.Text; } fnd = false; string crt4 = ""; lst1.EndEdit(); int i = 0; if (chklst1.Checked) { //crt4 = "{accounts.acc_no} <> -1"; fnd = true; } else { for (i = 0; i < lst1.RowCount; i++) { if (lst1[0, i].Value != null) { if ((bool)lst1[0, i].Value) { if (crt4 == "") { crt4 = lst1[2, i].Value.ToString(); } else { crt4 = crt4 + "," + lst1[2, i].Value.ToString(); } fnd = true; } } } crt4 = "{accounts.acc_no} in [" + crt4 + "]"; } if (!fnd) { MessageBox.Show("There is No Accounts selected, Please Try AGain", "Wrong Selection"); return; } fnd = false; string crt3 = ""; lst2.EndEdit(); //if (chklst2.Checked) //{ // //crt3 = "{accounts.acc_no} <> -1"; // fnd = true; //} //else //{ // for (i = 0; i < lst2.RowCount; i++) // { // if (lst2[0, i].Value != null) // { // if ((bool)lst2[0, i].Value) // { // if (crt3 == "") // { // crt3 = lst2[1, i].Value.ToString() ; // } // else // { // crt3 = crt3 + "," + lst2[1, i].Value.ToString(); // } // fnd = true; // } // } // } // crt3 = "{TRN_accounts.acc_no} in [" + crt3 + "]"; //} //if (!fnd) //{ // MessageBox.Show("There is No vehicle selected, Please Try Again", "Wrong Vehicle Selection"); // return; //} string crt5 = ""; if (cmbsaleagent.SelectedIndex < 1) { // crt2 = "{accounts.acc_type_code} <> -1"; } else { crt5 = "{accounts.account_link} = " + cmbsaleagent.SelectedValue; RPTHEAD = RPTHEAD + " for Saleagent " + cmbsaleagent.Text; } string crt6 = ""; if (cmblocaltion.SelectedIndex < 1) { // crt2 = "{accounts.acc_type_code} <> -1"; } else { crt6 = "{accounts_info.area_name} = '" + cmblocaltion.Text + "'"; RPTHEAD = RPTHEAD + " for Area " + cmblocaltion.Text; } string crt = ""; if (crt1 != "") { if (crt != "") { crt = crt + " aND " + crt1; } else { crt = crt1; } } if (crt2 != "") { if (crt != "") { crt = crt + " aND " + crt2; } else { crt = crt2; } } if (crt3 != "") { if (crt != "") { crt = crt + " aND " + crt3; } else { crt = crt3; } } // if (crt3 != "") crt = crt + " aND " + crt3; //if (crt4 != "") crt = crt + " aND " + crt4; //crt = crt + " aND " + crt4 + " AND {DATA_ENTRY.TRN_TYPE} = 7"; if (crt4 != "") { if (crt != "") { crt = crt + " aND " + crt4; } else { crt = crt4; } } if (crt5 != "") { if (crt != "") { crt = crt + " aND " + crt5; } else { crt = crt5; } } if (crt6 != "") { if (crt != "") { crt = crt + " aND " + crt6; } else { crt = crt6; } } //if (crt1 != "") crt2 = crt1 + " And " + crt2; rep_formula = crt; // 2 + " aND " + crt3 + " aND " + crt4;// +" AND {QRY_ITEM.QTY}<>0"; //rep_formula = crt1 + " aND " + crt2 + " aND " + crt3 + " and " + crt4; //" AND {QRY_ITEM.QTY}<>0"; CrRep.SummaryInfo.ReportTitle = RPTHEAD; // "Account Detail Report from " + rdt1 + " To " + rdt2; if (cmbtransaction.SelectedIndex == 1) { if (crt == "") { rep_formula = "{TRN_accounts.DR_CR}='D'"; } else { rep_formula = crt + " AND {TRN_accounts.DR_CR}='D'"; } CrRep.SummaryInfo.ReportTitle = RPTHEAD + ", For Trans of " + cmbtransaction.Text; } if (cmbtransaction.SelectedIndex == 2) { if (crt == "") { rep_formula = "{TRN_accounts.DR_CR}='C'"; } else { rep_formula = crt + " AND {TRN_accounts.DR_CR}='C'"; } CrRep.SummaryInfo.ReportTitle = RPTHEAD + ", For Trans of " + cmbtransaction.Text; } if (!cmbdept.Visible) { CrRep.ReportDefinition.Sections[5].SectionFormat.EnableSuppress = true; CrRep.ReportDefinition.Sections[6].SectionFormat.EnableSuppress = true; CrRep.ReportDefinition.Sections[9].SectionFormat.EnableSuppress = true; CrRep.ReportDefinition.Sections[10].SectionFormat.EnableSuppress = true; } if (!panel2.Visible) { } if (chkinvoice.Checked) // CrRep.GetComponentName("invoice") { string sec = CrRep.ReportDefinition.Sections[8].Name; CrRep.ReportDefinition.Sections[8].SectionFormat.EnableSuppress = false; } } break; } //if (CRT4 != "") // rep_formula = rep_formula + " AND " + CRT4; CrRep.Load(rep_path); //MessageBox.Show(rep_formula); CrRep.ReportOptions.EnableSaveDataWithReport = false; CrystalDecisions.Shared.ConnectionInfo crconnectioninfo = new CrystalDecisions.Shared.ConnectionInfo(); CrystalDecisions.Shared.TableLogOnInfos crtablelogoninfos = new CrystalDecisions.Shared.TableLogOnInfos(); CrystalDecisions.Shared.TableLogOnInfo crtablelogoninfo = new CrystalDecisions.Shared.TableLogOnInfo(); Tables CrTables; crconnectioninfo.ServerName = decoder.DataSource; crconnectioninfo.DatabaseName = decoder.InitialCatalog; crconnectioninfo.UserID = decoder.UserID; crconnectioninfo.Password = decoder.Password; //crconnectioninfo.ServerName = "Mujeeb-pc"; //crconnectioninfo.DatabaseName = "sqlStockex"; //crconnectioninfo.UserID = "sa"; //crconnectioninfo.Password = "******"; CrTables = CrRep.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtablelogoninfo = CrTable.LogOnInfo; crtablelogoninfo.ConnectionInfo = crconnectioninfo; CrTable.ApplyLogOnInfo(crtablelogoninfo); } CrRep.SetDatabaseLogon(decoder.UserID, decoder.Password, decoder.DataSource, decoder.InitialCatalog); if (rep_formula != "") { CrRep.RecordSelectionFormula = rep_formula; } CrRep.SummaryInfo.ReportTitle = RPTHEAD; // crystalReportViewer.ReportSource = reportDocument; //ConnectionInfo connInfo = new ConnectionInfo(); //connInfo.ServerName = "dbservername"; //connInfo.DatabaseName = "dbname"; //connInfo.UserID = "dbusername"; //connInfo.Password = "******"; //reportViewer.ReportSource = GetReportSource(connInfo); //reportViewer.RefreshReport(); // CrRep.Database.SetDataSource (db) // CrRep.VerifyOnEveryPrint = False //CrRep.DiscardSavedData //CrRep.ReadRecords //CrRep.Load(rep_path); //Crv1.ReportSource = CrRep; //Crv1.Width = this.Width; FrmrepView frm = new FrmrepView(); frm.MdiParent = this.ParentForm; frm.crv1.ReportSource = CrRep; frm.Show(); //Control[] ctrls = frm.Controls.Find("crv1", false); //if (ctrls.Length > 0) //{ // CrystalDecisions.Windows.Forms.CrystalReportViewer rep = (CrystalDecisions.Windows.Forms.CrystalReportViewer) ctrls[0]; // rep.ReportSource = CrRep; // frm.Show(); //} CrRep.SetDatabaseLogon(decoder.UserID, decoder.Password, "Mujeeb", decoder.InitialCatalog); //FRMREPORT.CRV1.ReportSource = CrRep //FRMREPORT.CRV1.Refresh //FRMREPORT.CRV1.RefreshEx (True) //FRMREPORT.CRV1.ViewReport //FRMREPORT.Show } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void LoadReport() { pnlReport.Visible = false; Tables CrTables; ConnectionInfo crConnectionInfo = new ConnectionInfo(); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); crConnectionInfo.Type = ConnectionInfoType.SQL; crConnectionInfo.ServerName = "172.16.4.12"; crConnectionInfo.DatabaseName = "PTS"; crConnectionInfo.IntegratedSecurity = false; crConnectionInfo.UserID = "sa"; crConnectionInfo.Password = "******"; crtableLogoninfo.ConnectionInfo = crConnectionInfo; SqlConnection sqlcnn = PSSClass.DBConnection.PSSConnection(); if (sqlcnn == null) { MessageBox.Show("Connection problems encountered." + Environment.NewLine + "Please contact your administrator.", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } ReportDocument crDoc = new ReportDocument(); SqlCommand sqlcmd = new SqlCommand(); SqlDataReader sqldr; string rpt = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "EquipmentServiceReport.rpt"; crDoc.Load(rpt); CrTables = crDoc.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } sqlcmd = new SqlCommand("spRptEqptSrvcReport", sqlcnn); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.AddWithValue("@StartDate", Convert.ToDateTime(mskStartDate.Text)); sqlcmd.Parameters.AddWithValue("@EndDate", Convert.ToDateTime(mskEndDate.Text)); sqldr = sqlcmd.ExecuteReader(); DataTable dTable = new DataTable(); try { dTable.Load(sqldr); sqlcnn.Dispose(); } catch { sqlcnn.Dispose(); } crDoc.SetDataSource(dTable); crReport.ReportSource = crDoc; crReport.Refresh(); }
private void DashboardYearlyRpt_Load(object sender, EventArgs e) { SqlConnection sqlcnn = PSSClass.DBConnection.MDFConnection("172.16.4.12", "PTSFinancials", true, "", "", ""); //SqlConnection sqlcnn = PSSClass.DBConnection.MDFConnection("172.16.4.12", "PTS", true, "", "", ""); if (sqlcnn == null) { MessageBox.Show("Connection problems encountered." + Environment.NewLine + "Please contact your administrator.", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } ReportDocument crDoc = new ReportDocument(); SqlCommand sqlcmd = new SqlCommand(); SqlDataReader sqldr; Tables CrTables; ConnectionInfo crConnectionInfo = new ConnectionInfo(); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); crConnectionInfo.Type = ConnectionInfoType.SQL; crConnectionInfo.ServerName = "172.16.4.12"; crConnectionInfo.DatabaseName = "PTS"; crConnectionInfo.IntegratedSecurity = false; crConnectionInfo.UserID = "sa"; crConnectionInfo.Password = "******"; crtableLogoninfo.ConnectionInfo = crConnectionInfo; string rptName; if (pubDashBoardTable == "Dashboard") { rptName = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "DashboardYearlyReport.rpt"; } else { rptName = @"\\PSAPP01\IT Files\PTS\Crystal Reports\" + "DashboardYearlySter.rpt"; } crDoc.Load(rptName); CrTables = crDoc.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } crDoc.DataDefinition.FormulaFields["cStartDate"].Text = "'" + StartDate.ToShortDateString() + "'"; crDoc.DataDefinition.FormulaFields["cEndDate"].Text = "'" + EndDate.ToShortDateString() + "'"; if (pubDashBoardTable == "Dashboard") { sqlcmd = new SqlCommand("spGetDashboardMonthly", sqlcnn); } else { sqlcmd = new SqlCommand("spGetDashboardMonthlySter", sqlcnn); } sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.AddWithValue("@StartDate", StartDate); sqlcmd.Parameters.AddWithValue("@EndDate", EndDate); sqldr = sqlcmd.ExecuteReader(); DataTable dTable = new DataTable(); try { dTable.Load(sqldr); sqlcnn.Dispose(); } catch { sqlcnn.Dispose(); } crDoc.SetDataSource(dTable); crReport.ReportSource = crDoc; crReport.Refresh(); }
private void PrintReport(int Codigo, TipoCadastro _tipo_cadastro) { ReportDocument crystalReport = new ReportDocument(); string sComplemento = "", sQuadras = "", sLotes = "", sEndereco = "", sBairro = "", sNome = "", sCidade = "", sUF = ""; string sData = "18/04/2012", sCPF = "", sCNPJ = "", sAtividade = "", sRG = "", sProcAbertura = "", sSufixo = "", sProcEncerramento = "", sDoc = ""; string sCep = "", sInscEstadual = "", sFantasia = "", sFone = "", sEmail = "", sTaxaLicenca = "", sVigilancia = "", sMei = "", sSituacao = "", sAtividade2 = ""; short nNumeroImovel = 0; string sArea = "0"; DateTime dDataProc = Convert.ToDateTime(sData); DateTime? dDataAbertura = null, dDataEncerramento = null; Empresa_bll empresa_Class = new Empresa_bll("GTIconnection"); EmpresaStruct Reg = empresa_Class.Retorna_Empresa(Codigo); sComplemento = string.IsNullOrWhiteSpace(Reg.Complemento) ? "" : " " + Reg.Complemento.ToString().Trim(); sComplemento += sQuadras + sLotes; sEndereco = Reg.Endereco_nome + ", " + Reg.Numero.ToString() + sComplemento; nNumeroImovel = (short)Reg.Numero; sBairro = Reg.Bairro_nome; sCidade = Reg.Cidade_nome; sUF = Reg.UF; sCep = Reg.Cep; sNome = Reg.Razao_social; sFantasia = string.IsNullOrWhiteSpace(Reg.Nome_fantasia)?"NÃO INFORMADO":Reg.Nome_fantasia; sCPF = string.IsNullOrWhiteSpace(Reg.Cpf) ? "" : Reg.Cpf; sCNPJ = string.IsNullOrWhiteSpace(Reg.Cnpj) ? "" : Reg.Cnpj; sRG = Reg.Rg ?? ""; sInscEstadual = string.IsNullOrWhiteSpace(Reg.Inscricao_estadual)?"ISENTO":Reg.Inscricao_estadual; sFone = Reg.Fone_contato; sEmail = Reg.Email_contato; sArea = Convert.ToSingle(Reg.Area).ToString("#0.00"); sDoc = gtiCore.FormatarCpfCnpj(Reg.Cpf_cnpj); sProcAbertura = Reg.Numprocesso == null?"": Reg.Numprocesso.ToString(); dDataAbertura = Reg.Data_abertura; if (Reg.Data_Encerramento != null) { dDataEncerramento = Reg.Data_Encerramento; sProcEncerramento = Reg.Numprocessoencerramento.ToString(); } sVigilancia = empresa_Class.Empresa_tem_VS(Codigo) ? "SIM" : "NÃO"; sTaxaLicenca = empresa_Class.Existe_Debito_TaxaLicenca(Codigo, DateTime.Now.Year) ? "SIM" : "NÃO"; sMei = empresa_Class.Empresa_Mei(Codigo) ? "SIM" : "NÃO"; sSituacao = Reg.Situacao; List <CnaeStruct> Lista_Cnae = empresa_Class.Lista_Cnae_Empresa(Codigo); foreach (CnaeStruct item in Lista_Cnae) { if (item.Principal) { sAtividade += item.CNAE + "-" + item.Descricao; } else { sAtividade2 += item.CNAE + "-" + item.Descricao + "; "; } } List <CnaeStruct> Lista_Cnae2 = empresa_Class.Lista_Cnae_Empresa_VS(Codigo); foreach (CnaeStruct item in Lista_Cnae) { bool _find = false; for (int i = 0; i < Lista_Cnae.Count; i++) { if (item.CNAE == Lista_Cnae[i].CNAE) { _find = true; break; } } if (!_find) { sAtividade2 += item.CNAE + "-" + item.Descricao + "; "; } } Tributario_bll tributario_Class = new Tributario_bll("GTIconnection"); int _numero_certidao = tributario_Class.Retorna_Codigo_Certidao(modelCore.TipoCertidao.Debito); short _ano_certidao = (short)DateTime.Now.Year; if (ExtratoCheckBox.Checked) { TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; if (dDataEncerramento != null) { crystalReport.Load(Server.MapPath("~/Report/CertidaoInscricaoExtratoEncerrada.rpt")); sSufixo = "XE"; } else { crystalReport.Load(Server.MapPath("~/Report/CertidaoInscricaoExtratoAtiva.rpt")); sSufixo = "XA"; } string Controle = Grava_Extrato_Pagamento(Codigo, _numero_certidao, _ano_certidao, sSufixo); crystalReport.RecordSelectionFormula = "{Certidao_inscricao_extrato.Id}='" + Controle + "'"; crConnectionInfo.ServerName = "200.232.123.115"; crConnectionInfo.DatabaseName = "Tributacao"; crConnectionInfo.UserID = "gtisys"; crConnectionInfo.Password = "******"; CrTables = crystalReport.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } } else { crystalReport.Load(Server.MapPath("~/Report/ComprovanteInscricao.rpt")); sSufixo = "IE"; } Certidao_inscricao cert = new Certidao_inscricao(); cert.Cadastro = Codigo; cert.Ano = (short)_ano_certidao; cert.Numero = _numero_certidao; cert.Data_emissao = DateTime.Now; cert.Nome = sNome; cert.Endereco = sEndereco; cert.Rg = sRG; cert.Bairro = sBairro; cert.Cidade = sCidade; cert.Processo_abertura = sProcAbertura; cert.Data_abertura = Convert.ToDateTime(dDataAbertura); if (dDataEncerramento != null) { cert.Processo_encerramento = sProcEncerramento; cert.Data_encerramento = Convert.ToDateTime(dDataEncerramento); } cert.Documento = sDoc; cert.Atividade = sAtividade; cert.Area = Convert.ToDecimal(sArea); cert.Atividade_secundaria = sAtividade2; cert.Cep = sCep; cert.Complemento = sComplemento; cert.Email = sEmail; cert.Inscricao_estadual = sInscEstadual; cert.Mei = sMei; cert.Nome_fantasia = sFantasia; cert.Situacao = sSituacao; cert.Taxa_licenca = sTaxaLicenca; if (sFone == null) { cert.Telefone = ""; } else { cert.Telefone = sFone.Length > 30? sFone.Substring(0, 30) : sFone; } cert.Vigilancia_sanitaria = sVigilancia; Exception ex = tributario_Class.Insert_Certidao_Inscricao(cert); if (ex != null) { throw ex; } else { crystalReport.SetParameterValue("NUMCERTIDAO", _numero_certidao.ToString("00000") + "/" + _ano_certidao.ToString("0000")); crystalReport.SetParameterValue("DATAEMISSAO", DateTime.Now.ToString("dd/MM/yyyy") + " às " + DateTime.Now.ToString("HH:mm:ss")); crystalReport.SetParameterValue("CONTROLE", _numero_certidao.ToString("00000") + _ano_certidao.ToString("0000") + "/" + Codigo.ToString() + "-" + sSufixo); crystalReport.SetParameterValue("ENDERECO", sEndereco); crystalReport.SetParameterValue("CADASTRO", Codigo.ToString("000000")); crystalReport.SetParameterValue("NOME", sNome); crystalReport.SetParameterValue("BAIRRO", sBairro); crystalReport.SetParameterValue("RG", sRG); crystalReport.SetParameterValue("DOCUMENTO", sDoc); crystalReport.SetParameterValue("CIDADE", sCidade + "/" + sUF); crystalReport.SetParameterValue("ATIVIDADE", sAtividade); crystalReport.SetParameterValue("DATAABERTURA", dDataAbertura); crystalReport.SetParameterValue("PROCESSOABERTURA", sProcAbertura == null?"":sProcAbertura); crystalReport.SetParameterValue("DATAENCERRAMENTO", dDataEncerramento == null?DateTime.Now:dDataEncerramento); crystalReport.SetParameterValue("PROCESSOENCERRAMENTO", sProcEncerramento); crystalReport.SetParameterValue("IESTADUAL", sInscEstadual == null?"":sInscEstadual); crystalReport.SetParameterValue("FANTASIA", sFantasia); crystalReport.SetParameterValue("ATIVIDADE2", sAtividade2); crystalReport.SetParameterValue("COMPLEMENTO", sComplemento == null?"":sComplemento); crystalReport.SetParameterValue("CEP", sCep); crystalReport.SetParameterValue("SITUACAO", sSituacao); crystalReport.SetParameterValue("TELEFONE", sFone == null?"":sFone); crystalReport.SetParameterValue("EMAIL", sEmail == null?"":sEmail); crystalReport.SetParameterValue("TAXALICENCA", sTaxaLicenca); crystalReport.SetParameterValue("VIGILANCIA", sVigilancia); crystalReport.SetParameterValue("MEI", sMei); crystalReport.SetParameterValue("AREA", sArea); HttpContext.Current.Response.Buffer = false; HttpContext.Current.Response.ClearContent(); HttpContext.Current.Response.ClearHeaders(); try { crystalReport.ExportToHttpResponse(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, HttpContext.Current.Response, true, "certidao" + _numero_certidao.ToString() + _ano_certidao.ToString()); } catch { } finally { crystalReport.Close(); crystalReport.Dispose(); } } }
private void Exibe_Certidao_Inscricao(Certidao_inscricao dados, string Tipo) { lblMsg.Text = ""; ReportDocument crystalReport = new ReportDocument(); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; if (Tipo == "IE" || Tipo == "IA") { crystalReport.Load(Server.MapPath("~/Report/ComprovanteInscricaoValida.rpt")); } else { crystalReport.Load(Server.MapPath("~/Report/CertidaoInscricaoExtratoValida.rpt")); crystalReport.RecordSelectionFormula = "{certidao_inscricao_extrato.ano_certidao}=" + dados.Ano + " and {certidao_inscricao_extrato.numero_certidao}=" + dados.Numero; } crConnectionInfo.ServerName = "200.232.123.115"; crConnectionInfo.DatabaseName = "Tributacao"; crConnectionInfo.UserID = "gtisys"; crConnectionInfo.Password = "******"; CrTables = crystalReport.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } crystalReport.SetParameterValue("NUMCERTIDAO", dados.Numero.ToString("00000") + "/" + dados.Ano.ToString("0000")); crystalReport.SetParameterValue("DATAEMISSAO", Convert.ToDateTime(dados.Data_emissao).ToString("dd/MM/yyyy") + " às " + Convert.ToDateTime(dados.Data_emissao).ToString("HH:mm:ss")); crystalReport.SetParameterValue("CONTROLE", dados.Numero.ToString("00000") + dados.Ano.ToString("0000") + "/" + dados.Cadastro.ToString() + "-" + "IE"); crystalReport.SetParameterValue("ENDERECO", dados.Endereco); crystalReport.SetParameterValue("CADASTRO", dados.Cadastro.ToString("000000")); crystalReport.SetParameterValue("NOME", dados.Nome); crystalReport.SetParameterValue("BAIRRO", dados.Bairro); crystalReport.SetParameterValue("DOCUMENTO", dados.Documento); crystalReport.SetParameterValue("CIDADE", dados.Cidade); crystalReport.SetParameterValue("ATIVIDADE", dados.Atividade); crystalReport.SetParameterValue("IESTADUAL", dados.Inscricao_estadual); crystalReport.SetParameterValue("DATAABERTURA", Convert.ToDateTime(dados.Data_abertura).ToString("dd/MM/yyyy")); crystalReport.SetParameterValue("FANTASIA", dados.Nome_fantasia); crystalReport.SetParameterValue("ATIVIDADE2", dados.Atividade_secundaria); crystalReport.SetParameterValue("COMPLEMENTO", dados.Complemento == null?"":dados.Complemento); crystalReport.SetParameterValue("CEP", dados.Cep); crystalReport.SetParameterValue("RG", ""); crystalReport.SetParameterValue("SITUACAO", dados.Situacao); crystalReport.SetParameterValue("TELEFONE", dados.Telefone == null?"":dados.Telefone); crystalReport.SetParameterValue("EMAIL", dados.Email == null?"":dados.Email); crystalReport.SetParameterValue("TAXALICENCA", dados.Taxa_licenca); crystalReport.SetParameterValue("VIGILANCIA", dados.Vigilancia_sanitaria); crystalReport.SetParameterValue("MEI", dados.Mei); crystalReport.SetParameterValue("AREA", Convert.ToDouble(dados.Area).ToString("#0.00")); crystalReport.SetParameterValue("DATAENCERRAMENTO", Convert.ToDateTime(dados.Data_encerramento).ToString("dd/MM/yyyy")); crystalReport.SetParameterValue("PROCESSOABERTURA", dados.Processo_abertura); crystalReport.SetParameterValue("PROCESSOENCERRAMENTO", dados.Processo_encerramento == null?"":dados.Processo_encerramento); HttpContext.Current.Response.Buffer = false; HttpContext.Current.Response.ClearContent(); HttpContext.Current.Response.ClearHeaders(); try { crystalReport.ExportToHttpResponse(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, HttpContext.Current.Response, true, "comp" + dados.Numero.ToString() + dados.Ano.ToString()); } catch { } finally { crystalReport.Close(); crystalReport.Dispose(); } }
private void frmRVentaInsumoCaja_Load(object sender, EventArgs e) { try { string bandera = frmReporteVentaInsumo.f1.lblBandera.Text; string fechaInicio = ""; string fechaFin = ""; DateTime fecIn; if (bandera == "1") { fechaInicio = frmReporteVentaInsumo.f1.dtpFechaInicio.Value.ToString("yyyy-MM-dd" + " 00:00:00"); fechaFin = frmReporteVentaInsumo.f1.dtpFechaFin.Value.ToString("yyyy-MM-dd" + " 23:59:59"); } else { fecIn = Convert.ToDateTime(frmPrincipal.f1.lblFechaApertura.Text); fechaInicio = fecIn.ToString("yyyy-MM-dd HH:mm:ss"); fechaFin = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); } int idProducto = Convert.ToInt32(frmReporteVentaInsumo.f1.cbProducto.SelectedValue); int nroCaja = Convert.ToInt32(frmReporteVentaInsumo.f1.lblCaja.Text); ReportDocument repdoc = new ReportDocument(); repdoc.Load(@"C:\Users\vioma\OneDrive\Documentos\Visual Studio 2017\Projects\SISTEMAUCHPA_Barra1\CapaPresentacion\Reportes/RVentaInsumoCaja.rpt"); //repdoc.Load(@"E:\Reportes\RVentaProducto.rpt"); ParameterFieldDefinitions pfds; ParameterFieldDefinition pfd; ParameterValues pvs = new ParameterValues(); ParameterDiscreteValue pdv = new ParameterDiscreteValue(); pdv.Value = Convert.ToDateTime(fechaInicio + " 00:00:00"); pfds = repdoc.DataDefinition.ParameterFields; pfd = pfds["@fechaInicio"]; pvs.Add(pdv); pfd.ApplyCurrentValues(pvs); pdv.Value = Convert.ToDateTime(fechaFin + " 23:59:59"); pfds = repdoc.DataDefinition.ParameterFields; pfd = pfds["@fechaFin"]; pvs.Add(pdv); pfd.ApplyCurrentValues(pvs); pdv.Value = idProducto; pfds = repdoc.DataDefinition.ParameterFields; pfd = pfds["@idProducto"]; pvs.Add(pdv); pfd.ApplyCurrentValues(pvs); pdv.Value = nroCaja; pfds = repdoc.DataDefinition.ParameterFields; pfd = pfds["@nroCaja"]; pvs.Add(pdv); pfd.ApplyCurrentValues(pvs); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; crConnectionInfo.ServerName = @"UCHPABAR\SQLUCHPA"; crConnectionInfo.DatabaseName = "db_SISTEMAUCHPA"; crConnectionInfo.UserID = "sa"; crConnectionInfo.Password = "******"; CrTables = repdoc.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } cvVentas.ReportSource = repdoc; cvVentas.Refresh(); } catch (Exception ex) { MessageBox.Show("ERROR" + ex); } }
private void Generate_Reports(string _rpt) { bool _isNewProject = (Array.IndexOf(Constants.CMLTConstants.recentProjects, lblprj.Text) > -1) ? true : false; bool _hasBuilding = (Array.IndexOf(Constants.CMLTConstants.hasBuilding, lblprj.Text) > -1) ? true : false; TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; BLL_Dml _objbll = new BLL_Dml(); _database _objdb = new _database(); _objdb.DBName = "DBCML"; _clsproject _objcls1 = new _clsproject(); _objcls1.prjcode = lblprj.Text; _objbll.Update_RPTLogo(_objcls1, _objdb); _objdb.DBName = "DB_" + lblprj.Text; if (_rpt == "dr") { //string _path = "../images/" + lblprj.Text + "logo.jpg"; //FileStream fs = new FileStream(Server.MapPath(_path), FileMode.Open, FileAccess.Read); //BinaryReader br = new BinaryReader(fs); //byte[] _image = br.ReadBytes((int)fs.Length); //br.Close(); //fs.Close(); _clsdocreview _objcls = new _clsdocreview(); _objcls.project_code = (string)Session["projectname"]; _objcls.dr_id = Convert.ToInt32(lblid.Text); _objbll.Generate_DRReport(_objcls, _objdb); if (lblprj.Text == "14211") { cryRpt.Load(Server.MapPath("drreport_kaia.rpt")); } if (lblprj.Text == "ARSD") { cryRpt.Load(Server.MapPath("drdetails_svd.rpt")); } else if (_isNewProject) { cryRpt.Load(Server.MapPath("drView.rpt")); } else { cryRpt.Load(Server.MapPath("drreport.rpt")); } } else if (_rpt == "so") { _clsSO _objcls = new _clsSO(); _objcls.project_code = (string)Session["projectname"]; _objcls.so_id = Convert.ToInt32(lblid.Text); _objbll.Generate_SOReport(_objcls, _objdb); Generate_SOIMG(); if (lblprj.Text == "14211") { cryRpt.Load(Server.MapPath("soreport_kaia.rpt")); } else if (lblprj.Text == "ARSD") { cryRpt.Load(Server.MapPath("sodetails_svd.rpt")); } else if (_isNewProject) { cryRpt.Load(Server.MapPath("soreport_new.rpt")); } else { cryRpt.Load(Server.MapPath("soreport.rpt")); } } else if (_rpt == "pr") { _objdb.DBName = "DBCML"; _objdb.Dataname = "DB_" + lblprj.Text; _objdb.project = (string)Session["projectname"]; _objbll.Generate_PRG_RPT(_objdb); cryRpt.Load(Server.MapPath("cpms_report.rpt")); } else if (_rpt == "dlog1") { _objdb.DBName = "DB_" + lblprj.Text; _objdb.rpt = 0; _objdb.Logname = ""; _objbll.Generate_DR_SO_RPT(_objdb); if (lblprj.Text == "14211") { cryRpt.Load(Server.MapPath("drso_kaia.rpt")); } else { cryRpt.Load(Server.MapPath("drso.rpt")); } cryRpt.SetParameterValue("service", "All"); cryRpt.SetParameterValue("rev", "All"); cryRpt.SetParameterValue("iss", "All"); cryRpt.SetParameterValue("sts", "All"); cryRpt.SetParameterValue("project", (string)Session["projectname"]); } else if (_rpt == "dlog") { mydiv.Visible = false; _objdb.DBName = "DB_" + lblprj.Text; if (lblprj.Text == "BNGA") { _objdb.rpt = 2; } else { _objdb.rpt = 0; } _objdb.Logname = lblid.Text; _objbll.Generate_DR_SO_RPT(_objdb); if (lblprj.Text == "14211") { cryRpt.Load(Server.MapPath("drso_kaia.rpt")); SelectionFormula(cryRpt, (string)Session["fsrv"], (string)Session["frev"], (string)Session["fiss"], (string)Session["fsts"]); } else if (_isNewProject) { cryRpt.Load(Server.MapPath("drLog_New.rpt")); cryRpt.SetParameterValue("building", (string)Session["fbui"]); SelectFormulaWithBuilding(cryRpt, (string)Session["fsrv"], (string)Session["frev"], (string)Session["fiss"], (string)Session["fsts"], (string)Session["fbui"]); } else if (lblprj.Text == "ARSD") { cryRpt.Load(Server.MapPath("drsolog_svd.rpt")); SelectionFormula(cryRpt, (string)Session["fsrv"], (string)Session["frev"], (string)Session["fiss"], (string)Session["fsts"]); } else { cryRpt.Load(Server.MapPath("drso.rpt")); SelectionFormula(cryRpt, (string)Session["fsrv"], (string)Session["frev"], (string)Session["fiss"], (string)Session["fsts"]); } cryRpt.SetParameterValue("service", (string)Session["fsrv"]); cryRpt.SetParameterValue("rev", (string)Session["frev"]); cryRpt.SetParameterValue("iss", (string)Session["fiss"]); cryRpt.SetParameterValue("sts", (string)Session["fsts"]); cryRpt.SetParameterValue("project", (string)Session["projectname"]); } else if (_rpt == "som") { _objdb.DBName = "DB_" + lblprj.Text; _objdb.rpt = 1; _objdb.Logname = ""; _objbll.Generate_DR_SO_RPT(_objdb); cryRpt.Load(Server.MapPath("drso.rpt")); cryRpt.SetParameterValue("service", "All"); cryRpt.SetParameterValue("rev", "All"); cryRpt.SetParameterValue("iss", "All"); cryRpt.SetParameterValue("sts", "All"); cryRpt.SetParameterValue("project", (string)Session["projectname"]); } else if (_rpt == "cmtlogdr") { mydiv.Visible = false; _clsSO _objcls = new _clsSO(); _objcls.mode = 0; DataSet ds = new DataSet(); ds = _objbll.Load_DR_SO_CommentLog(_objcls, _objdb); cryRpt.Load(Server.MapPath("drCommentLog.rpt")); cryRpt.Database.Tables["DR_CMMNT_RPT"].SetDataSource(ds.Tables[0]); cryRpt.Subreports[0].Database.Tables[0].SetDataSource(ds.Tables[1]); cryRpt.SetParameterValue("project", (string)Session["projectname"]); } else if (_rpt == "socmtlog") { mydiv.Visible = false; _clsSO _objcls = new _clsSO(); _objcls.mode = (_rpt == "socmtlog" ? 1 : 0); DataSet ds = new DataSet(); ds = _objbll.Load_DR_SO_CommentLog(_objcls, _objdb); ds.Tables[1].Columns.Add("Image", typeof(byte[])); FileStream fs; BinaryReader br; byte[] _image; //int ins=0; for (int ins = 0; ins <= ds.Tables[1].Rows.Count - 1; ins += 1) { string _path = ds.Tables[1].Rows[ins]["Photo"].ToString(); if (string.IsNullOrEmpty(_path)) { continue; } fs = new FileStream(Server.MapPath(_path), FileMode.Open, FileAccess.Read); br = new BinaryReader(fs); _image = br.ReadBytes((int)fs.Length); ds.Tables[1].Rows[ins]["Image"] = _image; ds.Tables[1].AcceptChanges(); } cryRpt.Load(Server.MapPath("SoCommentLog.rpt")); cryRpt.Database.Tables["SO_CMMNT_RPT"].SetDataSource(ds.Tables[0]); cryRpt.Subreports[0].Database.Tables[0].SetDataSource(ds.Tables[1]); //cryRpt.Subreports[1].Database.Tables[0].SetDataSource(ds.Tables[2]); cryRpt.SetParameterValue("project", (string)Session["projectname"]); } else if (_rpt == "som1") { mydiv.Visible = false; _objdb.DBName = "DB_" + lblprj.Text; _objdb.rpt = 1; _objdb.Logname = ""; _objbll.Generate_DR_SO_RPT(_objdb); if (lblprj.Text == "14211") { cryRpt.Load(Server.MapPath("drso_kaia.rpt")); } else if (_isNewProject && _hasBuilding) { DataSet _ds = new DataSet(); DataTable _dt = GetData(); _ds.Tables.Add(_dt); //_ds.WriteXmlSchema(Server.MapPath("") + "\\soreport.xml"); cryRpt.Load(Server.MapPath("SO_New.rpt")); cryRpt.Database.Tables[0].SetDataSource(_ds.Tables[0]); cryRpt.SetParameterValue("building", (string)Session["fbui"]); } else if (lblprj.Text == "ARSD") { cryRpt.Load(Server.MapPath("drsolog_svd.rpt")); } else { cryRpt.Load(Server.MapPath("drso.rpt")); } cryRpt.SetParameterValue("service", (string)Session["fsrv"]); cryRpt.SetParameterValue("rev", (string)Session["frev"]); cryRpt.SetParameterValue("iss", (string)Session["fiss"]); cryRpt.SetParameterValue("sts", (string)Session["fsts"]); cryRpt.SetParameterValue("project", (string)Session["projectname"]); if (_isNewProject && _hasBuilding) { SelectionFormula_New(cryRpt, (string)Session["fsrv"], (string)Session["frev"], (string)Session["fiss"], (string)Session["fsts"], (string)Session["fbui"]); } else { SelectionFormula(cryRpt, (string)Session["fsrv"], (string)Session["frev"], (string)Session["fiss"], (string)Session["fsts"]); } } else if (_rpt == "uso") { mydiv.Visible = false; _objdb.DBName = "DB_" + lblprj.Text; _objdb.rpt = 1; _objbll.Generate_DR_SO_RPT(_objdb); cryRpt.Load(Server.MapPath("uso_log.rpt")); } else if (_rpt == "cp") { _objdb.DBName = "DBCML"; _objdb.Dataname = "DB_" + lblprj.Text; _objdb.project = (string)Session["projectname"]; _objbll.Generate_CP_RPT(_objdb); cryRpt.Load(Server.MapPath("cpms_report.rpt")); //cryRpt.Load(Server.MapPath("comment_rpt.rpt")); //cryRpt.SetParameterValue("project", (string)Session["projectname"]); } else if (_rpt == "msc") { _objdb.DBName = "DB_" + lblprj.Text; if (lblprj.Text == "HMIM") { _clscassheet _objcls = new _clscassheet(); _objcls.build_id = Convert.ToInt32(Session["building_id"].ToString()); _objbll.Gen_MSComment_Rpt(_objcls, _objdb); cryRpt.Load(Server.MapPath("ms_comments_rpt 1.rpt")); cryRpt.SetParameterValue("bldng", "BUILDING : " + (string)Session["building"]); } else { _objbll.Gen_MSComment_Rpt(_objdb); cryRpt.Load(Server.MapPath("ms_comments_rpt.rpt")); } cryRpt.SetParameterValue("project", (string)Session["projectname"]); cryRpt.SetParameterValue("ser", drservices.SelectedItem.Text); cryRpt.SetParameterValue("sys", drpackages.SelectedItem.Text); cryRpt.SetParameterValue("typ", drtype.SelectedItem.Text); MSC_SelectionFormula(cryRpt, drservices.SelectedItem.Text, drpackages.SelectedItem.Text, drtype.SelectedItem.Text); } else if (_rpt == "msr") { mydiv.Visible = false; //if (lblprj.Text == "12761") // cryRpt.Load(Server.MapPath("ms_schedule_summary1.rpt")); //else cryRpt.Load(Server.MapPath("ms_schedule_summary2.rpt")); cryRpt.SetParameterValue("project", (string)Session["projectname"]); cryRpt.SetParameterValue("srv", (string)Session["srv"]); cryRpt.SetParameterValue("sys", (string)Session["sys"]); cryRpt.SetParameterValue("typ", (string)Session["typ"]); cryRpt.SetParameterValue("sts", (string)Session["sts"]); } else if (_rpt == "mss") { //_objdb.DBName = "DB_" + lblprj.Text; //_objbll.Gen_MS_Schedule_Summary(_objdb); mydiv.Visible = false; if (lblprj.Text == "12761") { cryRpt.Load(Server.MapPath("ms_schedule_summary1.rpt")); } else if (lblprj.Text == "HMIM" || lblprj.Text == "ABS") { cryRpt.Load(Server.MapPath("ms_schedule_summary3.rpt")); cryRpt.SetParameterValue("bldng", (string)Session["building"]); } else { cryRpt.Load(Server.MapPath("ms_schedule_summary.rpt")); } cryRpt.SetParameterValue("project", (string)Session["projectname"]); cryRpt.SetParameterValue("srv", (string)Session["srv"]); cryRpt.SetParameterValue("sys", (string)Session["sys"]); cryRpt.SetParameterValue("typ", (string)Session["typ"]); cryRpt.SetParameterValue("sts", (string)Session["sts"]); MSS_SelectionFormula(cryRpt, (string)Session["srv"], (string)Session["sys"], (string)Session["typ"], (string)Session["sts"]); } else if (_rpt == "doc_comm") { mydiv.Visible = false; cryRpt.Load(Server.MapPath("comment_rpt.rpt")); cryRpt.SetParameterValue("project", (string)Session["projectname"]); } else if (_rpt == "cas") { _objdb.DBName = "DBCML"; _objdb.Dataname = "DB_" + lblprj.Text; _objdb.photo_rpt = null; _objdb.project = (string)Session["projectname"]; _objdb.Datapath = lblprj.Text; _objdb.rpt = Convert.ToInt32((string)Session["sch_id"]); _objdb.cas = (string)Session["sch_id"]; _objbll.Generate_CAS_RPT(_objdb); // _objbll.CAS_PKG_SUM_RPT(_objdb); if ((string)Session["sch_id"] == "1" || (string)Session["sch_id"] == "5") { cryRpt.Load(Server.MapPath("cas_lv.rpt")); } else if ((string)Session["sch_id"] == "2") { cryRpt.Load(Server.MapPath("cas_mv.rpt")); } else if ((string)Session["sch_id"] == "3") { cryRpt.Load(Server.MapPath("cas_tx.rpt")); } else if ((string)Session["sch_id"] == "6") { cryRpt.Load(Server.MapPath("cas_e_l.rpt")); } else if ((string)Session["sch_id"] == "8") { cryRpt.Load(Server.MapPath("cas_mec.rpt")); } else if ((string)Session["sch_id"] == "17") { cryRpt.Load(Server.MapPath("cas_ph1.rpt")); } else if ((string)Session["sch_id"] == "18") { cryRpt.Load(Server.MapPath("cas_ph2.rpt")); } else if ((string)Session["sch_id"] == "19") { cryRpt.Load(Server.MapPath("cas_ph3.rpt")); } else if ((string)Session["sch_id"] == "20") { cryRpt.Load(Server.MapPath("cas_bms.rpt")); } cryRpt.SetParameterValue("bz", "All"); cryRpt.SetParameterValue("cat", "All"); cryRpt.SetParameterValue("fl", "All"); cryRpt.SetParameterValue("ff", "All"); } else if (_rpt == "ams") { cryRpt.Load(Server.MapPath("../AMS/tasklist.rpt")); } else if (_rpt == "SODR_PDF") { mydiv.Visible = false; _objdb.DBName = "DB_" + lblprj.Text; if (!String.IsNullOrEmpty(Request.QueryString["dtype"])) { _objdb.rpt = Convert.ToInt16(Request.QueryString["dtype"].ToString()); } _objdb.Logname = lblid.Text; _objbll.Generate_DR_SO_RPT_PDF(_objdb); cryRpt.Load(Server.MapPath("drso_pdf.rpt")); SelectionFormula(cryRpt, (string)Session["fsrv"], (string)Session["frev"], (string)Session["fiss"], (string)Session["fsts"]); cryRpt.SetParameterValue("service", (string)Session["fsrv"]); cryRpt.SetParameterValue("rev", (string)Session["frev"]); cryRpt.SetParameterValue("iss", (string)Session["fiss"]); cryRpt.SetParameterValue("sts", (string)Session["fsts"]); cryRpt.SetParameterValue("project", (string)Session["projectname"]); } if (_rpt != "som1" || lblprj.Text != "HMIM") { crConnectionInfo.ServerName = Constants.CMLTConstants.serverName; crConnectionInfo.DatabaseName = Constants.CMLTConstants.dbName; crConnectionInfo.UserID = Constants.CMLTConstants.dbUserName; crConnectionInfo.Password = Constants.CMLTConstants.dbPassword; CrTables = cryRpt.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } } //CrystalReportViewer1.ParameterFieldInfo = paramFields; CrystalReportViewer1.ReportSource = cryRpt; CrystalReportViewer1.DataBind(); //CrystalReportViewer1.RefreshReport(); //CrystalReportViewer1.PageZoomFactor = 200; Session["Report"] = cryRpt; _clsuser _cls = new _clsuser(); _cls.uid = (string)Session["uid"]; _cls.project_code = lblprj.Text; _cls.mode = 2; _objdb.DBName = "DBCML"; string _access = _objbll.Get_CMSAccess(_cls, _objdb); if (_access == "Read Only") { CrystalReportViewer1.HasExportButton = false; } }
public ActionResult Mobreq_print(string p) { Mobreq_bll mobreqRepository = new Mobreq_bll(_connection); Mobreq_main_Struct _req = mobreqRepository.Retorna_Requerimento(p); Empresa_bll empresaRepository = new Empresa_bll(_connection); EmpresaStruct _dados = empresaRepository.Retorna_Empresa(_req.Codigo); string _rgie = "N/D"; bool _bCpf = _req.CpfCnpj.Length == 11 ? true : false; if (_bCpf) { _rgie = string.IsNullOrEmpty(_dados.Rg) ? _rgie : _dados.Rg; } else { _rgie = string.IsNullOrEmpty(_dados.Inscricao_estadual) ? _rgie : _dados.Inscricao_estadual; } string _endereco = _dados.Endereco_nome_abreviado + ", " + _dados.Numero.ToString() + " " + _dados.Complemento ?? "" + ", " + _dados.Bairro_nome + " "; _endereco += _dados.Cidade_nome + "/" + _dados.UF; Sistema_bll sistemaRepository = new Sistema_bll(_connection); Usuario_web _user = sistemaRepository.Retorna_Usuario_Web(_req.UserId); string _filename = ""; if (_req.Tipo_Codigo == 1) { _filename = "MobReq_Inscricao.rpt"; } else { if (_req.Tipo_Codigo == 2) { _filename = "MobReq_Baixa.rpt"; } else { if (_req.Tipo_Codigo == 3) { _filename = "MobReq_Alteracao.rpt"; } else { if (_req.Tipo_Codigo == 4) { _filename = "MobReq_Reativa.rpt"; } } } } ReportDocument rd = new ReportDocument(); rd.Load(System.Web.HttpContext.Current.Server.MapPath("~/Reports/" + _filename)); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; string myConn = ConfigurationManager.ConnectionStrings[_connection].ToString(); SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(myConn); string IPAddress = builder.DataSource; string _userId = builder.UserID; string _pwd = builder.Password; crConnectionInfo.ServerName = IPAddress; crConnectionInfo.DatabaseName = "Tributacao"; crConnectionInfo.UserID = _userId; crConnectionInfo.Password = _pwd; CrTables = rd.Database.Tables; foreach (Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } rd.SetParameterValue("Guid", p); rd.SetParameterValue("Razao", _dados.Razao_social); rd.SetParameterValue("CpfCnpj", Functions.FormatarCpfCnpj(_req.CpfCnpj)); rd.SetParameterValue("RgIe", _rgie); rd.SetParameterValue("DataCadastro", _req.Data_Evento); rd.SetParameterValue("Endereco", _endereco); rd.SetParameterValue("Atividade", _dados.Atividade_extenso); rd.SetParameterValue("Nome", _user.Nome); rd.SetParameterValue("Telefone", _user.Telefone); rd.SetParameterValue("Email", _user.Email); rd.SetParameterValue("Obs", _req.Obs ?? ""); try { Stream stream = rd.ExportToStream(ExportFormatType.PortableDocFormat); return(File(stream, "application/pdf", "Requerimento.pdf")); } catch { throw; } }
void LoadInventoryReport() { try { this.Cursor = Cursors.WaitCursor; ReportDocument cryRpt = new ReportDocument(); ReportObjects crReportObjects; SubreportObject crSubreportObject; ReportDocument crSubreportDocument; Database crDatabase; TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; string s = ""; if (this.reportType == ReportType.Allocations) { s = Application.StartupPath + @"\Reports\GCKAllocationsReport.rpt"; } // Application.StartupPath + else if (this.reportType == ReportType.Cancellations) { s = Application.StartupPath + @"\Reports\GCKCancellationsReport.rpt"; } // Application.StartupPath + else if (this.reportType == ReportType.Reactivations) { s = Application.StartupPath + @"\Reports\GCKReactivationsReport.rpt"; } // Application.StartupPath + else if (this.reportType == ReportType.Refund) { s = Application.StartupPath + @"\Reports\GCKRefundReport.rpt"; } // Application.StartupPath + else if (this.reportType == ReportType.Transfer) { s = Application.StartupPath + @"\Reports\GCKTransferReport.rpt"; } // Application.StartupPath + else if (this.reportType == ReportType.InventoryReport) { s = Application.StartupPath + @"\Reports\GCKInventory.rpt"; } // Application.StartupPath + else if (this.reportType == ReportType.SoldPlotsByMemberShip) { s = Application.StartupPath + @"\Reports\GCKSoldPlots.rpt"; } // Application.StartupPath + else if (this.reportType == ReportType.ClientWiseMemberProfile) { s = Application.StartupPath + @"\Reports\GraanaClientWiseProfile.rpt"; } // Application.StartupPath + else if (this.reportType == ReportType.ClientWisePurchaseHistory) { s = Application.StartupPath + @"\Reports\GraanaClientWisePurchaseHistory.rpt"; } cryRpt.Load(s); ConnectionInfo connInfo = new ConnectionInfo(); SqlConnectionStringBuilder builder = new DataAccess().GetCredentials(); crConnectionInfo.ServerName = builder.DataSource; crConnectionInfo.DatabaseName = builder.InitialCatalog; crConnectionInfo.UserID = builder.UserID; crConnectionInfo.Password = builder.Password; Sections ReportSections = cryRpt.ReportDefinition.Sections; foreach (Section section in ReportSections) { crReportObjects = section.ReportObjects; foreach (ReportObject crReportObject in crReportObjects) { if (crReportObject.Kind != ReportObjectKind.SubreportObject) { continue; } crSubreportObject = (SubreportObject)crReportObject; crSubreportDocument = crSubreportObject.OpenSubreport(crSubreportObject.SubreportName); crDatabase = crSubreportDocument.Database; CrTables = crDatabase.Tables; foreach (Table CrTable in CrTables) { TableLogOnInfo crTableLogOnInfo = CrTable.LogOnInfo; crTableLogOnInfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crTableLogOnInfo); } } } CrTables = cryRpt.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } if (this.reportType == ReportType.InventoryReport) { cryRpt.SetParameterValue("@ProjectID", strProjectID); cryRpt.SetParameterValue("@SizeCode", strSizeCode); cryRpt.SetParameterValue("@Sector", strBlockNo); cryRpt.SetParameterValue("@StatusCode", intStatusCode); } else if (this.reportType == ReportType.SoldPlotsByMemberShip) { cryRpt.SetParameterValue("@ProjectID", strProjectID); cryRpt.SetParameterValue("@Sector", strBlockNo); cryRpt.SetParameterValue("@StartDate", dtFromDate); cryRpt.SetParameterValue("@EndDate", dtToDate); } else if (this.reportType == ReportType.Allocations) { cryRpt.SetParameterValue("@ProjectID", strProjectID); cryRpt.SetParameterValue("@StartDate", dtFromDate); cryRpt.SetParameterValue("@EndDate", dtToDate); cryRpt.SetParameterValue("@ApprovalStatusCode", intStatusCode); } else if (this.reportType == ReportType.Cancellations) { cryRpt.SetParameterValue("@ProjectID", strProjectID); cryRpt.SetParameterValue("@StartDate", dtFromDate); cryRpt.SetParameterValue("@EndDate", dtToDate); cryRpt.SetParameterValue("@ApprovalStatusCode", intStatusCode); } else if (this.reportType == ReportType.Reactivations) { cryRpt.SetParameterValue("@ProjectID", strProjectID); cryRpt.SetParameterValue("@StartDate", dtFromDate); cryRpt.SetParameterValue("@EndDate", dtToDate); cryRpt.SetParameterValue("@ApprovalStatusCode", intStatusCode); } else if (this.reportType == ReportType.Transfer) { cryRpt.SetParameterValue("@ProjectID", strProjectID); cryRpt.SetParameterValue("@StartDate", dtFromDate); cryRpt.SetParameterValue("@EndDate", dtToDate); cryRpt.SetParameterValue("@ApprovalStatusCode", intStatusCode); } else if (this.reportType == ReportType.Refund) { cryRpt.SetParameterValue("@ProjectID", strProjectID); cryRpt.SetParameterValue("@StartDate", dtFromDate); cryRpt.SetParameterValue("@EndDate", dtToDate); cryRpt.SetParameterValue("@ApprovalStatusCode", intStatusCode); } else if (this.reportType == ReportType.ClientWiseMemberProfile) { cryRpt.SetParameterValue("@ClientID", strDocumentNumber); } else if (this.reportType == ReportType.ClientWisePurchaseHistory) { cryRpt.SetParameterValue("@ClientID", strDocumentNumber); } rptViewer.ReportSource = cryRpt; rptViewer.Refresh(); } catch (Exception ex) { MessageBox.Show("Exception:" + ex.Message); return; } this.Cursor = Cursors.Arrow; }
public void GenerateReport_Inside(string parameter) { string _Report = string.Empty; if (_reportType == "Normal") { _Report = _reportName_Inside; } else if (_reportType == "Replacement") { _Report = _reportName_Inside_Replacement; } else { _Report = _reportName_Inside_Sample; } ReportDocument objReport1 = new ReportDocument(); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo ConInfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; ParameterFieldDefinitions crParameterFieldDefinitions; ParameterFieldDefinition crParameterFieldDefinition; ParameterValues crParameterValues = new ParameterValues(); ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue(); if (File.Exists(_path + _Report)) { objReport1.Load(_path + _Report); } else { objReport1.Load(ClsConfig.LotCardCantierReportPath_Trial + _Report); } crParameterDiscreteValue.Value = parameter; crParameterFieldDefinitions = objReport1.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["@LotCardGroupNo"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); //objReport1.SetParameterValue("@LotCardGroupNo", _formNos.ToString().Trim(), objReport1.Subreports[0].Name.ToString()); string sUserID = ClsConfig.ReportUser; string sPassword = ClsConfig.ReportPassword; string sServerName = ClsConfig.ReportServer; string sDatabaseName = ClsConfig.ReportDatabase_LotCard; crConnectionInfo.ServerName = sServerName; crConnectionInfo.DatabaseName = sDatabaseName; crConnectionInfo.UserID = sUserID; crConnectionInfo.Password = sPassword; CrTables = objReport1.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { ConInfo = CrTable.LogOnInfo; ConInfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(ConInfo); } docB = objReport1; reportViewer2.ViewerCore.ReportSource = docB; }
private void frmRIngresosEgresos_Load(object sender, EventArgs e) { try { string bandera = frmReporteIngresosEgresos.f1.lblBandera.Text; string fechaInicio = ""; string fechaFin = ""; DateTime fecIn; if (bandera == "1") { fechaInicio = frmReporteIngresosEgresos.f1.dtpFechaInicio.Value.ToString("yyyy-MM-dd" + " 00:00:00"); fechaFin = frmReporteIngresosEgresos.f1.dtpFechaFin.Value.ToString("yyyy-MM-dd" + " 23:59:59"); } else { fecIn = Convert.ToDateTime(frmPrincipal.f1.lblFechaApertura.Text); fechaInicio = fecIn.ToString("yyyy-MM-dd HH:mm:ss"); fechaFin = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); } ReportDocument repdoc = new ReportDocument(); // repdoc.Load(@"C:\Users\vioma\OneDrive\Documentos\Visual Studio 2017\Projects\SisVentas_ResAlm\CapaPresentacion\Reportes/RVentas.rpt"); repdoc.Load(@"D:\Reportes\RIngresosEgresos.rpt"); ParameterFieldDefinitions pfds; ParameterFieldDefinition pfd; ParameterValues pvs = new ParameterValues(); ParameterDiscreteValue pdv = new ParameterDiscreteValue(); pdv.Value = Convert.ToDateTime(fechaInicio); pfds = repdoc.DataDefinition.ParameterFields; pfd = pfds["@fechaInicio"]; pvs.Add(pdv); pfd.ApplyCurrentValues(pvs); pdv.Value = Convert.ToDateTime(fechaFin); pfds = repdoc.DataDefinition.ParameterFields; pfd = pfds["@fechaFin"]; pvs.Add(pdv); pfd.ApplyCurrentValues(pvs); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; crConnectionInfo.ServerName = @"EQUIPO\SQLEXPRESS"; crConnectionInfo.DatabaseName = "BD_RESTAURANTE"; crConnectionInfo.UserID = "admin"; crConnectionInfo.Password = "******"; /* crConnectionInfo.ServerName = @"EQUIPO\SQLEXPRESS"; crConnectionInfo.DatabaseName = "db_restauranteAlmacen"; crConnectionInfo.UserID = "martin"; crConnectionInfo.Password = "******"; */ CrTables = repdoc.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } cvVentas.ReportSource = repdoc; cvVentas.Refresh(); } catch (Exception ex) { MessageBox.Show("ERROR" + ex); } }
protected void Page_Load(object sender, EventArgs e) { //if (Request.QueryString["Param"] != null) //{ if (Session["order_id"] != "") { Order_Id = Session["order_id"].ToString(); Template = Session["Template"].ToString(); } // Order_Id = Request.QueryString["Param"].ToString(); System.Data.Common.DbConnectionStringBuilder builder = new System.Data.Common.DbConnectionStringBuilder(); builder.ConnectionString = ConfigurationManager.ConnectionStrings["TaxManagementConnectionString"].ConnectionString; string server = builder["Data Source"] as string; string database = builder["Initial Catalog"] as string; string UserID = builder["User ID"] as string; string password = builder["Password"] as string; //int OrderID = int.Parse(Session["OrderID"].ToString()); //int ClintID = int.Parse(Session["ClientID"].ToString()); // string LetterCase = Convert.ToString(Session["CaseLetter"].ToString()); //int SubProcessID = int.Parse(Session["SubProcessID"].ToString()); // string Trans = "OrderWise"; //int ProcessID=1; TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; if (Template == "Template1") { rptDoc.Load(Server.MapPath("~/Reports/Clients/GLS/Rpt_Tax_Information_Client_Granit.rpt")); } else if (Template == "Template2") { rptDoc.Load(Server.MapPath("~/Reports/Clients/GLS/Rpt_Tax_Information_Client_Granit_Temp2.rpt")); } // Order_Details_Page_1 Parameterhttp: rptDoc.SetParameterValue("@Order_ID", Order_Id); rptDoc.SetParameterValue("@Order_ID", Order_Id, "Notes"); crConnectionInfo.ServerName = server; crConnectionInfo.DatabaseName = database; crConnectionInfo.UserID = UserID; crConnectionInfo.Password = password; CrTables = rptDoc.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } foreach (ReportDocument sr in rptDoc.Subreports) { foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in sr.Database.Tables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } } Session["rptDoc"] = rptDoc; rptDoc.ExportToDisk(ExportFormatType.PortableDocFormat, Server.MapPath("~/Reports/Clients/GLS/Rpt_Tax_Information_Client_Granit.pdf")); // CrystalReportViewer1.ReportSource = rptDoc; MemoryStream oStream = default(MemoryStream); oStream = (MemoryStream)rptDoc.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); Response.Clear(); Response.Buffer = true; Response.ContentType = "application/pdf"; Response.BinaryWrite(oStream.ToArray()); Response.End(); //RadPdfTableTruncate(); //PdfView(); // } }
public void GenerateReport() { try { string filepart = @"file:\"; CrystalDecisions.CrystalReports.Engine.ReportDocument objReport1 = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); CrystalDecisions.Shared.TableLogOnInfos crtableLogoninfos = new CrystalDecisions.Shared.TableLogOnInfos(); CrystalDecisions.Shared.TableLogOnInfo ConInfo = new CrystalDecisions.Shared.TableLogOnInfo(); CrystalDecisions.Shared.ConnectionInfo crConnectionInfo = new CrystalDecisions.Shared.ConnectionInfo(); CrystalDecisions.CrystalReports.Engine.Tables CrTables; CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinitions crParameterFieldDefinitions; CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinition crParameterFieldDefinition; CrystalDecisions.Shared.ParameterValues crParameterValues = new CrystalDecisions.Shared.ParameterValues(); CrystalDecisions.Shared.ParameterDiscreteValue crParameterDiscreteValue = new CrystalDecisions.Shared.ParameterDiscreteValue(); if (File.Exists(System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().CodeBase).Replace(filepart, "") + @"\PEZA_REPORTS\rpt_PEZA_8106_BoatNote.rpt")) { objReport1.Load(System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().CodeBase).Replace(filepart, "") + @"\PEZA_REPORTS\rpt_PEZA_8106_BoatNote.rpt"); } else { objReport1.Load(ClsConfig.PEZAReportPath_Trial + "rpt_PEZA_8106_BoatNote.rpt"); } crParameterDiscreteValue.Value = _formNo.ToString().Trim();//recDate.SelectedDate.Value; crParameterFieldDefinitions = objReport1.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["@8106FormNo"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); //objReport1.SetParameterValue("@8106FormNo", "14176560"); string sUserID = ClsConfig.ReportUser; string sPassword = ClsConfig.ReportPassword; string sServerName = ClsConfig.ReportServer; string sDatabaseName = ClsConfig.ReportDatabase_PEZA; crConnectionInfo.ServerName = sServerName; crConnectionInfo.DatabaseName = sDatabaseName; //crConnectionInfo.IntegratedSecurity = true; crConnectionInfo.UserID = sUserID; crConnectionInfo.Password = sPassword; CrTables = objReport1.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { ConInfo = CrTable.LogOnInfo; ConInfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(ConInfo); } reportViewer.ViewerCore.ReportSource = objReport1; } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
public void GenerateReport(string parameter) { ReportDocument objReport1 = new ReportDocument(); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo ConInfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; ParameterFieldDefinitions crParameterFieldDefinitions; ParameterFieldDefinition crParameterFieldDefinition; ParameterValues crParameterValues = new ParameterValues(); ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue(); if (File.Exists(_path + _reportName_Outside)) { objReport1.Load(_path + _reportName_Outside); } else { objReport1.Load(ClsConfig.LotCardCantierReportPath_Trial + _reportName_Outside); } crParameterDiscreteValue.Value = parameter; crParameterFieldDefinitions = objReport1.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["@LotCardGroupNo"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); string sUserID = ClsConfig.ReportUser; string sPassword = ClsConfig.ReportPassword_BarcodeDB; string sServerName = ClsConfig.ReportServer_BarcodeDB; string sDatabaseName = ClsConfig.ReportDatabase_BarcodeDB; crConnectionInfo.ServerName = sServerName; crConnectionInfo.DatabaseName = sDatabaseName; crConnectionInfo.UserID = sUserID; crConnectionInfo.Password = sPassword; CrTables = objReport1.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { ConInfo = CrTable.LogOnInfo; ConInfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(ConInfo); } docA = objReport1; reportViewer.ViewerCore.ReportSource = docA; }
public void GenerateReport() { try { ReportDocument objReport1 = new ReportDocument(); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo ConInfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; ParameterFieldDefinitions crParameterFieldDefinitions; ParameterFieldDefinition crParameterFieldDefinition; ParameterValues crParameterValues = new ParameterValues(); ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue(); if (File.Exists(_path + _reportName_Outside)) { objReport1.Load(_path + _reportName_Outside); } else { objReport1.Load(ClsConfig.PEZAReportPath_Trial + _reportName_Outside); } objReport1.SetParameterValue("@8106FormNo", _formNos); objReport1.SetParameterValue("@IsLastTrip", _isLastTrip); objReport1.SetParameterValue("@Trip", _trip); objReport1.SetParameterValue("@OverAllTotalQty", _overAllTotalQty); string sUserID = ClsConfig.ReportUser; string sPassword = ClsConfig.ReportPassword; string sServerName = ClsConfig.ReportServer; string sDatabaseName = ClsConfig.ReportDatabase_PEZA; crConnectionInfo.ServerName = sServerName; crConnectionInfo.DatabaseName = sDatabaseName; crConnectionInfo.UserID = sUserID; crConnectionInfo.Password = sPassword; CrTables = objReport1.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { ConInfo = CrTable.LogOnInfo; ConInfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(ConInfo); } PageMargins margins; // Get the PageMargins structure and set the // margins for the report. margins = objReport1.PrintOptions.PageMargins; switch (_trip) { case "1": margins.topMargin = 5800; break; //6000 case "2": margins.topMargin = 7000; break; //7100 case "3": margins.topMargin = 7300; break; //7500 case "4": margins.topMargin = 7800; break; //8000 case "5": margins.topMargin = 8300; //8500 break; } // Apply the page margins. objReport1.PrintOptions.ApplyPageMargins(margins); docA = objReport1; reportViewer.ViewerCore.ReportSource = docA; } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void frmRComprasProducto_Load(object sender, EventArgs e) { try { string fechaInicio = frmReporteComprasProducto.f1.dtpFechaInicio.Value.ToString("yyyy-MM-dd"); string fechaFin = frmReporteComprasProducto.f1.dtpFechaFin.Value.ToString("yyyy-MM-dd"); int idProducto = Convert.ToInt32(frmReporteComprasProducto.f1.cbProducto.SelectedValue); ReportDocument repdoc = new ReportDocument(); // repdoc.Load(@"C:\Users\vioma\OneDrive\Documentos\Visual Studio 2017\Projects\SisVentas_ResAlm\CapaPresentacion\Reportes/RComprasProducto.rpt"); repdoc.Load(@"D:\Reportes\RComprasProducto.rpt"); ParameterFieldDefinitions pfds; ParameterFieldDefinition pfd; ParameterValues pvs = new ParameterValues(); ParameterDiscreteValue pdv = new ParameterDiscreteValue(); pdv.Value = Convert.ToDateTime(fechaInicio + " 00:00:00"); pfds = repdoc.DataDefinition.ParameterFields; pfd = pfds["@fechaInicio"]; pvs.Add(pdv); pfd.ApplyCurrentValues(pvs); pdv.Value = Convert.ToDateTime(fechaFin + " 23:59:59"); pfds = repdoc.DataDefinition.ParameterFields; pfd = pfds["@fechaFin"]; pvs.Add(pdv); pfd.ApplyCurrentValues(pvs); pdv.Value = idProducto; pfds = repdoc.DataDefinition.ParameterFields; pfd = pfds["@idProducto"]; pvs.Add(pdv); pfd.ApplyCurrentValues(pvs); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; crConnectionInfo.ServerName = @"EQUIPO\SQLEXPRESS"; crConnectionInfo.DatabaseName = "SISVENTAS_CA"; crConnectionInfo.UserID = "admin"; crConnectionInfo.Password = "******"; /* * crConnectionInfo.ServerName = @"EQUIPO\SQLEXPRESS"; * crConnectionInfo.DatabaseName = "db_restauranteAlmacen"; * crConnectionInfo.UserID = "martin"; * crConnectionInfo.Password = "******"; */ CrTables = repdoc.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } cvVentas.ReportSource = repdoc; cvVentas.Refresh(); } catch (Exception ex) { MessageBox.Show("ERROR" + ex); } }
public ReportDocument MuestraEnVisor(string FolioDesde, string FolioHasta, string Tabla, int Comprobante) { ultimoMensaje = ""; numError = 0; //Obtiene ruta del reporte crystal //Parametros Param = new Parametros(_DbName); //if (!_param.ultimoMensaje.Equals(string.Empty)) //{ // ultimoMensaje = _param.ultimoMensaje; // return null; //} try { ReportDocument cryRpt = new ReportDocument(); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; ParameterFieldDefinitions crParameterFieldDefinitions; ParameterFieldDefinition crParameterFieldDefinition; ParameterValues crParameterValues = new ParameterValues(); ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue(); cryRpt.Load(_param.rutaReporteCrystal); //Conecta la base de datos crConnectionInfo.IntegratedSecurity = _IntegratedSecurity; crConnectionInfo.ServerName = _SrvrName; crConnectionInfo.DatabaseName = _DbName; if (!_IntegratedSecurity) { crConnectionInfo.UserID = _IdUsuario; crConnectionInfo.Password = _Password; } CrTables = cryRpt.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } //Envía parámetros al reporte crParameterDiscreteValue.Value = FolioDesde; crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["Desde Numero"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); crParameterDiscreteValue.Value = FolioHasta; crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["Hasta Numero"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); crParameterDiscreteValue.Value = Tabla; crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["sTabla"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); crParameterDiscreteValue.Value = Comprobante; crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["Comprobante"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); //crViewerCfd.ReportSource = cryRpt; //crViewerCfd.Refresh(); return(cryRpt); } catch (Exception exVis) { ultimoMensaje = "No se puede mostrar el reporte. [MuestraEnVisor] " + exVis.Message; numError++; return(null); } }
//TODO: Mihai (01-11-2018) public void OnFiltrosTermosCommand(int _report, int _status, int _periodo, string _dataIni, string _dataFim) { string _xmlstring; //DateTime DataInicial = DateTime.Parse(_dataIni); //DataInicial = DataInicial.ToString("MMMM"); switch (_report) { case 12: verbo = "concedeu"; break; case 16: verbo = "indeferiu"; break; case 14: verbo = "cancelou"; break; case 18: verbo = "destruiu"; break; default: verbo = "emitiu"; break; } try { //12_TermoConcessaoCredencial.rpt //14_TermoCancelamentoCredencial.rpt //16_TermoIndeferimentoCredencial.rpt //18_TermoDestruicaoCredencial.rpt //20_TermoViaAdicionalCredencial.rpt _xmlstring = CriaXmlRelatoriosGerenciais(_report); //_xmlstring = CriaXmlRelatoriosGerenciais(24); XmlDocument xmldocument = new XmlDocument(); xmldocument.LoadXml(_xmlstring); XmlNode node = xmldocument.DocumentElement; XmlNode arquivoNode = node.SelectSingleNode("ArquivosImagens/ArquivoImagem/Arquivo"); string _ArquivoRPT = arquivoNode.FirstChild.Value; byte[] buffer = Convert.FromBase64String(_ArquivoRPT); _ArquivoRPT = System.IO.Path.GetTempFileName(); _ArquivoRPT = System.IO.Path.GetRandomFileName(); _ArquivoRPT = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + "\\" + _ArquivoRPT; //ReportDocument reportDocument = new ReportDocument(); //File.Move(_caminhoArquivoPDF, Path.ChangeExtension(_caminhoArquivoPDF, ".pdf")); _ArquivoRPT = System.IO.Path.ChangeExtension(_ArquivoRPT, ".rpt"); System.IO.File.WriteAllBytes(_ArquivoRPT, buffer); ReportDocument reportDocument = new ReportDocument(); //Esse ponto de implementação para a alteração da instancia do SQL, banco, usuário e senha TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; //Filtro Hoje if (_periodo == 1) { //Termo de Vias Adicionais if (_report == 20 && _status == 1) { formula = " {ColaboradoresCredenciais.Emissao} = CurrentDate " + " and {CredenciaisMotivos.CredencialmotivoID} in [2,3]"; _mensagem = "Na data " + DateTime.Now.ToShortDateString() + " este setor de credenciamento do AEROPORTO INTERNACIONAL DE PORTO ALEGRE, " + verbo + " as seguintes vias adicionais de credenciais:"; } //Outros termos (Concedidas/Indeferidas/Canceladas/Destruidas) else { ///Concedidas if (_status == 1) { formula = "{ColaboradoresCredenciais.Emissao} = CurrentDate "; } ///Indeferidas/Canceladas/Destruidas else { formula = " {ColaboradoresCredenciais.Baixa} = CurrentDate " + " and {ColaboradoresCredenciais.CredencialStatusID} = " + _status; } _mensagem = "Na data " + DateTime.Now.ToShortDateString() + " este setor de credenciamento do AEROPORTO INTERNACIONAL DE PORTO ALEGRE, " + verbo + " as seguintes credenciais:"; } reportDocument.Load(_ArquivoRPT); } //Filtro últimos 7 dias else if (_periodo == 2) { //Termo de Vias Adicionais if (_report == 20 && _status == 1) { formula = " {ColaboradoresCredenciais.Emissao} >= CurrentDate-7 " + " and {ColaboradoresCredenciais.Emissao} <= CurrentDate " + " and {CredenciaisMotivos.CredencialmotivoID} in [2,3]"; _mensagem = "Durante o período de " + DateTime.Now.AddDays(-7).ToShortDateString() + " a " + DateTime.Now.ToShortDateString() + " esse setor de credenciamento do AEROPORTO INTERNACIONAL DE PORTO ALEGRE, " + verbo + " as seguintes vias adicionais de credenciais:"; } //Outros termos (Concedidas/Indeferidas/Canceladas/Destruidas) else { ///Concedidas if (_status == 1) { formula = " {ColaboradoresCredenciais.Emissao} >= CurrentDate-7" + " and {ColaboradoresCredenciais.Emissao} <= CurrentDate "; } ///Indeferidas/Canceladas/Destruidas else { formula = " {ColaboradoresCredenciais.Baixa} >= CurrentDate-7" + " and {ColaboradoresCredenciais.Baixa} <= CurrentDate " + " and {ColaboradoresCredenciais.CredencialStatusID} = " + _status; } _mensagem = "Durante o período de " + DateTime.Now.AddDays(-7).ToShortDateString() + " a " + DateTime.Now.ToShortDateString() + " esse setor de credenciamento do AEROPORTO INTERNACIONAL DE PORTO ALEGRE, " + verbo + " as seguintes vias adicionais de credenciais:"; } reportDocument.Load(_ArquivoRPT); } //Filtro Último Mês else if (_periodo == 3) { //Termo Vias Adicionais if (_report == 20 && _status == 1) { formula = " {ColaboradoresCredenciais.Emissao} >= CurrentDate-30 " + " and {ColaboradoresCredenciais.Emissao} <= CurrentDate " + " and {CredenciaisMotivos.CredencialmotivoID} in [2,3]"; _mensagem = "Durante o período de " + DateTime.Now.AddDays(-30).ToShortDateString() + " a " + DateTime.Now.ToShortDateString() + " esse setor de credenciamento do AEROPORTO INTERNACIONAL DE PORTO ALEGRE, " + verbo + " as seguintes vias adicionais de credenciais:"; } //Outros termos (Concedidas/Indeferidas/Canceladas/Destruidas) else { ///Concedidas if (_status == 1) { formula = " {ColaboradoresCredenciais.Emissao} >= CurrentDate-30 " + " and {ColaboradoresCredenciais.Emissao} <= CurrentDate "; } ///Indeferidas/Canceladas/Destruidas else { formula = " {ColaboradoresCredenciais.Baixa} >= CurrentDate-30 " + " and {ColaboradoresCredenciais.Baixa} <= CurrentDate " + " and {ColaboradoresCredenciais.CredencialStatusID} = " + _status; } _mensagem = "Durante o período de " + DateTime.Now.AddDays(-30).ToShortDateString() + " a " + DateTime.Now.ToShortDateString() + " esse setor de credenciamento do AEROPORTO INTERNACIONAL DE PORTO ALEGRE, " + verbo + " as seguintes vias adicionais de credenciais:"; } reportDocument.Load(_ArquivoRPT); } //Filtro por Período Determinado (Entre datas) else { //Termo Vias Adicionais if (_report == 20 && _status == 1) { formula = " {CredenciaisMotivos.CredencialmotivoID} in [2,3]" + " and {ColaboradoresCredenciais.Emissao} >= cdate('" + _dataIni + "')" + " and {ColaboradoresCredenciais.Emissao} <= cdate('" + _dataFim + "') "; _mensagem = "Durante o período de " + _dataIni + " a " + _dataFim + " " + "esse setor de credenciamento do AEROPORTO INTERNACIONAL DE PORTO ALEGRE, " + verbo + " as seguintes vias adicionais de credenciais:"; } //Outros termos (Concedidas/Indeferidas/Canceladas/Destruidas) else { ///Concedidas if (_status == 1) { formula = " {ColaboradoresCredenciais.Emissao} <= cdate('" + _dataFim + "') " + " and {ColaboradoresCredenciais.Emissao} >= cdate('" + _dataIni + "')"; } ///Indeferidas/Canceladas/Destruidas else { formula = " {ColaboradoresCredenciais.Baixa} >= cdate('" + _dataIni + "')" + " and {ColaboradoresCredenciais.Baixa} <= cdate('" + _dataFim + "') " + " and {ColaboradoresCredenciais.CredencialStatusID} = " + _status; } _mensagem = "Durante o período de " + _dataIni + " a " + _dataFim + " " + "esse setor de credenciamento do AEROPORTO INTERNACIONAL DE PORTO ALEGRE, " + verbo + " as seguintes credenciais:"; } reportDocument.Load(_ArquivoRPT); } crConnectionInfo.ServerName = Global._instancia; crConnectionInfo.DatabaseName = Global._bancoDados; crConnectionInfo.UserID = Global._usuario; crConnectionInfo.Password = Global._senha; CrTables = reportDocument.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } Thread CarregaRel_thr = new Thread(() => { System.Windows.Application.Current.Dispatcher.Invoke(() => { reportDocument.RecordSelectionFormula = formula; TextObject txt = (TextObject)reportDocument.ReportDefinition.ReportObjects["TextoPrincipal"]; txt.Text = _mensagem; //System.Drawing.Font fonte = new System.Drawing.Font("Verdana", 9, FontStyle.Bold); //txt.ApplyFont(fonte); PopupRelatorio _popupRelatorio = new PopupRelatorio(reportDocument); _popupRelatorio.Show(); }); } ); //CarregaRel_thr.SetApartmentState(ApartmentState.STA); CarregaRel_thr.Start(); } catch (Exception ex) { Global.Log("Erro na void OnFiltrosImpressoesCommand ex: " + ex); } }
/// <summary> /// Guarda el archivo pdf usando Crystal reports. /// Deprecated. /// </summary> /// <param name="Param"></param> /// <param name="FolioDesde"></param> /// <param name="FolioHasta"></param> /// <param name="Tabla"></param> /// <param name="Comprobante"></param> /// <param name="RutaPDF">Ruta que incluye el nombre del archivo.</param> /// <returns></returns> public bool GuardaDocumentoEnPDF(string FolioDesde, string FolioHasta, string Tabla, int Comprobante, string RutaPDF) { ultimoMensaje = ""; numError = 0; try { ReportDocument cryRpt = new ReportDocument(); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; ParameterFieldDefinitions crParameterFieldDefinitions; ParameterFieldDefinition crParameterFieldDefinition; ParameterValues crParameterValues = new ParameterValues(); ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue(); cryRpt.Load(_param.rutaReporteCrystal); //Conecta la base de datos crConnectionInfo.IntegratedSecurity = _IntegratedSecurity; crConnectionInfo.ServerName = _SrvrName; crConnectionInfo.DatabaseName = _DbName; if (!_IntegratedSecurity) { crConnectionInfo.UserID = _IdUsuario; crConnectionInfo.Password = _Password; } CrTables = cryRpt.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } //Envía parámetros al reporte crParameterDiscreteValue.Value = FolioDesde; crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["Desde Numero"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); crParameterDiscreteValue.Value = FolioHasta; crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["Hasta Numero"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); crParameterDiscreteValue.Value = Tabla; crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["sTabla"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); crParameterDiscreteValue.Value = Comprobante; crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["Comprobante"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); //crystalReportViewer1.ReportSource = cryRpt; //crystalReportViewer1.Refresh(); //Convierte a pdf ExportOptions CrExportOptions; DiskFileDestinationOptions CrDiskFileDestinationOptions = new DiskFileDestinationOptions(); PdfRtfWordFormatOptions CrFormatTypeOptions = new PdfRtfWordFormatOptions(); CrDiskFileDestinationOptions.DiskFileName = RutaPDF; CrExportOptions = cryRpt.ExportOptions; { CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile; CrExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat; CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions; CrExportOptions.FormatOptions = CrFormatTypeOptions; } cryRpt.Export(); return(true); } catch (DirectoryNotFoundException) { ultimoMensaje = "Verifique la existencia de la ruta indicada en la configuración de Ruta de archivos Xml. [GuardaDocumentoEnPDF] La ruta no pudo ser encontrada: " + RutaPDF; numError++; return(false); } catch (IOException) { ultimoMensaje = "Verifique permisos de escritura en: " + RutaPDF + ". No se pudo guardar el archivo xml ni registrar el documento en la bitácora. [GuardaDocumentoEnPDF]"; numError++; return(false); } catch (Exception exPdf) { if (exPdf.Message.Contains("denied")) { ultimoMensaje = "Elimine el archivo antes de volver a generar uno nuevo. Luego vuelva a intentar. [GuardaDocumentoEnPDF] " + exPdf.Message; } else { ultimoMensaje = "Advertencia, no se guardó el reporte PDF. [GuardaDocumentoEnPDF] " + exPdf.Message; } numError++; return(false); } }
private void print_Report(int idx) { string crt; string rep_path; bool fnd = false; try { ReportDocument CrRep = new ReportDocument(); rep_path = ""; crt = ""; switch (idx) { case 1: { //crt = "{Reciepts.Reciept_no} =" + Convert.ToDouble(Txtitem.Text); rep_path = Gvar.report_path + "\\reports\\ItemMasterN.rpt"; CrRep.Load(rep_path); CrRep.SummaryInfo.ReportTitle = "Material Stock Report for all"; } break; } //crconnectioninfo.ServerName = "Mujeeb"; //crconnectioninfo.DatabaseName = "Printex"; //crconnectioninfo.UserID = "sa"; //crconnectioninfo.Password = "******"; //CrRep.PrintOptions.PaperSize= CrystalDecisions.Shared.PaperSize.PaperEnvelope10; if (crt != "") { CrRep.RecordSelectionFormula = crt; } CrystalDecisions.Shared.ConnectionInfo crconnectioninfo = new CrystalDecisions.Shared.ConnectionInfo(); CrystalDecisions.Shared.TableLogOnInfos crtablelogoninfos = new CrystalDecisions.Shared.TableLogOnInfos(); CrystalDecisions.Shared.TableLogOnInfo crtablelogoninfo = new CrystalDecisions.Shared.TableLogOnInfo(); Tables CrTables; crconnectioninfo.ServerName = decoder.DataSource; crconnectioninfo.DatabaseName = decoder.InitialCatalog; crconnectioninfo.UserID = decoder.UserID; crconnectioninfo.Password = decoder.Password; CrTables = CrRep.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtablelogoninfo = CrTable.LogOnInfo; crtablelogoninfo.ConnectionInfo = crconnectioninfo; CrTable.ApplyLogOnInfo(crtablelogoninfo); } //CrRep.SetDatabaseLogon(decoder.UserID, decoder.Password, decoder.DataSource, decoder.InitialCatalog); //CrRep.Load(); //CrRep.ReadRecords(); //CrRep.Refresh(); //if (chkprinter.Checked) //{ // CrRep.PrintToPrinter(1, true, 0, 0); //} //else //{ FrmrepView frm = new FrmrepView(); frm.MdiParent = this.ParentForm; frm.crv1.ReportSource = CrRep; frm.Show(); //} //ConnectionInfo connInfo = new ConnectionInfo(); //connInfo.ServerName = "dbservername"; //connInfo.DatabaseName = "dbname"; //connInfo.UserID = "dbusername"; //connInfo.Password = "******"; //reportViewer.ReportSource = GetReportSource(connInfo); CrRep.SetDatabaseLogon(decoder.UserID, decoder.Password, "Mujeeb", decoder.InitialCatalog); //CrRep.Load(); // CrRep.ReadRecords(); //CrRep.Refresh(); } catch (System.Exception excep) { MessageBox.Show(excep.Message); } }