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);
}
}
