private void previewBatchToolStripButton1_Click(object sender, EventArgs e) { ReportDocument report = new ReportDocument(); report.Load(@"\\cfs-fileserv01\ACHReports\ACH Batch Details.rpt"); ParameterFieldDefinitions parameters = report.DataDefinition.ParameterFields; ParameterFieldDefinition parameter = parameters["BatchId"]; ParameterDiscreteValue parameterValue = new ParameterDiscreteValue(); parameterValue.Value = this._batchId; ParameterValues values = new ParameterValues(); values = parameter.CurrentValues; values.Clear(); values.Add(parameterValue); parameter.ApplyCurrentValues(values); Reports.PreviewReport preview = new Cfs.Custom.Software.Reports.PreviewReport(); preview.Report = report; preview.MdiParent = this.ParentForm; preview.Show(); }
private void printBatchToolStripButton_Click(object sender, EventArgs e) { long batchId = (long)this.aCHFileDataGridView.SelectedRows[0].Cells[0].Value; ReportDocument report = new ReportDocument(); report.Load(@"\\cfs-fileserv01\ACHReports\Abra Reports\Misc\ACH Batch Details.rpt"); ParameterFieldDefinitions parameters = report.DataDefinition.ParameterFields; ParameterFieldDefinition parameter = parameters["BatchId"]; ParameterDiscreteValue parameterValue = new ParameterDiscreteValue(); parameterValue.Value = batchId; ParameterValues values = new ParameterValues(); values = parameter.CurrentValues; values.Clear(); values.Add(parameterValue); parameter.ApplyCurrentValues(values); if (this.printDialog.ShowDialog() == DialogResult.OK) { report.PrintOptions.PrinterName = this.printDialog.PrinterSettings.PrinterName; report.PrintToPrinter(1, false, 0, 0); } }
/// <summary> /// In báo cáo /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ptbPrintImport_Click(object sender, EventArgs e) { DateTime TuNgay = dtpkTuNgayThu.Value; DateTime denNgay = dtpkDenNgayThu.Value; CrystalReportBaoCaoThu cr = new CrystalReportBaoCaoThu(); cr.SetDataSource(HoaDonDAO.Instance.getHoaDonbyThoiGian(TuNgay, denNgay)); ParameterFieldDefinitions crParameterFieldDefinitions = cr.DataDefinition.ParameterFields; ParameterFieldDefinition crParameterFieldDefinition = crParameterFieldDefinitions["TuNgay"]; ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue(); crParameterDiscreteValue.Value = TuNgay; ParameterValues crParameterValues = new ParameterValues(); //reset lại value crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); ParameterFieldDefinition crParameterFieldDefinitionDenNgay = crParameterFieldDefinitions["DenNgay"]; ParameterDiscreteValue crParameterDiscreteValueDenNgay = new ParameterDiscreteValue(); crParameterDiscreteValueDenNgay.Value = denNgay; ParameterValues crParameterValuesDenNgay = new ParameterValues(); //reset lại value crParameterValuesDenNgay = crParameterFieldDefinitionDenNgay.CurrentValues; crParameterValuesDenNgay.Add(crParameterDiscreteValueDenNgay); crParameterFieldDefinitionDenNgay.ApplyCurrentValues(crParameterValuesDenNgay); fReport f = new fReport(cr); f.ShowDialog(); }
private void printReportToolStripButton_Click(object sender, EventArgs e) { ReportDocument report = new ReportDocument(); report.Load(@"\\cfs-intranet\Abra Reports\Misc\ACH Batch Details.rpt"); ParameterFieldDefinitions parameters = report.DataDefinition.ParameterFields; ParameterFieldDefinition parameter = parameters["BatchId"]; ParameterDiscreteValue parameterValue = new ParameterDiscreteValue(); parameterValue.Value = this._batchId; ParameterValues values = new ParameterValues(); values = parameter.CurrentValues; values.Clear(); values.Add(parameterValue); parameter.ApplyCurrentValues(values); if (this.printDialog.ShowDialog() == DialogResult.OK) { report.PrintOptions.PrinterName = this.printDialog.PrinterSettings.PrinterName; report.PrintToPrinter(1, false, 0, 0); } }
private void frmAlertaControlPuerperio_Load(object sender, EventArgs e) { try { if (Reporte == "") { CapaUsuario.Alertas.rptAlertaControlPuerperio rptAlertaControlPeuperio = new rptAlertaControlPuerperio(); crParameterDiscreteValue.Value = cVariables.v_idobstetra; crParameterFieldDefinitions = rptAlertaControlPeuperio.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["pidtobstetra"]; crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); crParameterDiscreteValue.Value = cVariables.v_idestablecimientosalud; crParameterFieldDefinitions = rptAlertaControlPeuperio.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["pidtestablecimientosalud"]; crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); crystalReportViewer1.ReportSource = rptAlertaControlPeuperio; crystalReportViewer1.Refresh(); } } catch (Exception m) { MessageBox.Show(m.Message); } }
/// <summary> /// thực hiện khởi tạo vớibáo cáo MAHDN /// </summary> /// <param name="MAHDN"></param> public fReport(string MAHDN, string MANCC) { InitializeComponent(); CrystalReportHoaDonNhap cr = new CrystalReportHoaDonNhap(); cr.SetDataSource(CTHDNdao.Instance.getListCTHDNbyMAHD(MAHDN)); ParameterFieldDefinitions crParameterFieldDefinitions = cr.DataDefinition.ParameterFields; ParameterFieldDefinition crParameterFieldDefinition = crParameterFieldDefinitions["MANCC"]; ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue(); crParameterDiscreteValue.Value = MANCC; ParameterValues crParameterValues = new ParameterValues(); //reset lại value crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); crystalReportViewerBills.ReportSource = cr; crystalReportViewerBills.Refresh(); }
private void previewBatchToolStripButton_Click(object sender, EventArgs e) { long batchId = (long)this.aCHFileDataGridView.SelectedRows[0].Cells[0].Value; ReportDocument report = new ReportDocument(); report.Load(@"\\cfs-intranet\Abra Reports\Misc\ACH Batch Details.rpt"); ParameterFieldDefinitions parameters = report.DataDefinition.ParameterFields; ParameterFieldDefinition parameter = parameters["BatchId"]; ParameterDiscreteValue parameterValue = new ParameterDiscreteValue(); parameterValue.Value = batchId; ParameterValues values = new ParameterValues(); values = parameter.CurrentValues; values.Clear(); values.Add(parameterValue); parameter.ApplyCurrentValues(values); Reports.PreviewReport preview = new Cfs.Custom.Software.Reports.PreviewReport(); preview.Report = report; preview.MdiParent = this.ParentForm; preview.Show(); }
private void EstablecimientoSalud(ReportClass rpt, string pidtestablecimientosalud) { crParameterDiscreteValue.Value = pidtestablecimientosalud; crParameterFieldDefinitions = rpt.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["pidtestablecimientosalud"]; crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); }
private void MicroRed(ReportClass rpt, string pidtmicrored) { crParameterDiscreteValue.Value = pidtmicrored; crParameterFieldDefinitions = rpt.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["pidtmicrored"]; crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); }
private void Mes(ReportClass rpt, string pmes) { crParameterDiscreteValue.Value = pmes; crParameterFieldDefinitions = rpt.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["pmes"]; crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); }
public void ImpresionVacacion(int idVacacion) { try { string impresion = @"\RecursosHumanos\Impresos\ImpresionVacacionRecibo.rpt"; ReportDocument rpt = new ReportDocument(); rpt.Load(Application.StartupPath + impresion); //Obtener datos de conexion a Base de datos var Conexion = new LN.Conexion(); //Cargar con la configuracion de Crystal Report //================================================================================== //Configuramos la Base de Datos TableLogOnInfo ConInfo = new TableLogOnInfo(); ConInfo.ConnectionInfo.UserID = Conexion.Usuario; ConInfo.ConnectionInfo.Password = Conexion.Clave; ConInfo.ConnectionInfo.DatabaseName = Conexion.BaseDatos; ConInfo.ConnectionInfo.ServerName = Conexion.Servidor; for (int i = 0; i <= rpt.Database.Tables.Count - 1; i++) { rpt.Database.Tables[i].ApplyLogOnInfo(ConInfo); } ParameterFieldDefinitions crParameterFieldDefinitions = default(ParameterFieldDefinitions); ParameterFieldDefinition crParameter1 = default(ParameterFieldDefinition); ParameterValues crParameter1Values = new ParameterValues(); ParameterDiscreteValue crDiscrete1Value = new ParameterDiscreteValue(); //'Get the collection of parameters from the report crParameterFieldDefinitions = rpt.DataDefinition.ParameterFields; //'Access the specified parameter from the collection crParameter1 = crParameterFieldDefinitions["@IDVACACION"]; //'Get the current values from the parameter field. At this point //'there are zero values set. crParameter1Values = crParameter1.CurrentValues; //'Set the current values for the parameter field crDiscrete1Value = new ParameterDiscreteValue(); crDiscrete1Value.Value = idVacacion; //'Add the first current value for the parameter field crParameter1Values.Add(crDiscrete1Value); //'All current parameter values must be applied for the parameter field. crParameter1.ApplyCurrentValues(crParameter1Values); crvVisorInforme.ReportSource = rpt; crvVisorInforme.Refresh(); } catch (Exception ex) { throw ex; } }
public void PassParameter(int ParameterIndex, string ParameterValue) { ParameterFieldDefinition parameterField = this.crReportDocument.DataDefinition.ParameterFields[ParameterIndex]; ParameterValues currentValues = parameterField.CurrentValues; currentValues.Add((ParameterValue) new ParameterDiscreteValue() { Value = (object)Convert.ToString(ParameterValue) }); parameterField.ApplyCurrentValues(currentValues); }
private void missingTimesheetsButton_Click(object sender, EventArgs e) { DateTime payDate = DateTime.Parse(this.payDatePicker.Text); Data.PayPeriod payPeriod = (from p in this._context.PayPeriods where p.payDate == payDate select p).SingleOrDefault(); int payPeriodId = payPeriod.payPeriodId; ReportDocument report = new ReportDocument(); report.Load(@"\\cfs-intranet\Abra Reports\Misc\Missing Timesheets.rpt"); ConnectionInfo ci = new ConnectionInfo(); ci.ServerName = "cfs-intranet"; ci.DatabaseName = "CFS_Master"; ci.IntegratedSecurity = true; Tables tables = report.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table table in tables) { TableLogOnInfo tableLogOn = table.LogOnInfo; tableLogOn.ConnectionInfo = ci; table.ApplyLogOnInfo(tableLogOn); } report.Refresh(); ParameterFieldDefinitions parameters = report.DataDefinition.ParameterFields; ParameterFieldDefinition parameter = parameters["@payPeriodId"]; ParameterDiscreteValue parameterValue = new ParameterDiscreteValue(); parameterValue.Value = payPeriodId; ParameterValues values = new ParameterValues(); values = parameter.CurrentValues; values.Clear(); values.Add(parameterValue); parameter.ApplyCurrentValues(values); this.crystalReportViewer1.ReportSource = report; this.crystalReportViewer1.Visible = true; }
private static ParameterFieldDefinition SetupReportParameter(ReportDocument cryRpt, string parameterName, object value) { ParameterFieldDefinitions crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields; if (!IsExistParaName(cryRpt, parameterName)) { return(null); } ParameterFieldDefinition crParameterFieldDefinition = crParameterFieldDefinitions[parameterName]; //!!!!!!!!!!! if it is allow, it disalbe the fornter prompe, means run time can change the value crParameterFieldDefinition.EnableAllowEditingDefaultValue = true; // crParameterFieldDefinition.ApplyMinMaxValues(value, value); ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue(); crParameterDiscreteValue.Value = value; crParameterDiscreteValue.IsRange = false; ParameterValues crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); crParameterFieldDefinition.ApplyDefaultValues(crParameterValues); //crParameterFieldDefinition.PromptText = value.ToString(); crParameterFieldDefinition.DiscreteOrRangeKind = DiscreteOrRangeKind.DiscreteValue; if (crParameterFieldDefinition.HasCurrentValue) { crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); } return(crParameterFieldDefinition); }
public void prepareConsultationCert(int consId) { setRptName("ConsultationCert.rpt"); crRpt.Load(rptName); crParameterDiscreteValue.Value = consId; crParameterFieldDefinitions = crRpt.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["in_cons_id"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); }
public void preparePrescription(String consId) { setRptName("Prescription.rpt"); crRpt.Load(rptName); crParameterDiscreteValue.Value = consId; crParameterFieldDefinitions = crRpt.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["in_cons_id"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); }
public void prepareSickLeaveCert(int sickLeaveCertId) { setRptName("SickLeaveCert.rpt"); crRpt.Load(rptName); crParameterDiscreteValue.Value = sickLeaveCertId; crParameterFieldDefinitions = crRpt.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["in_cert_id"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); }
private void SetDateRangeForOrders(ReportDocument report, string startData, string endData, string name_parametre) { ParameterRangeValue param_ = new ParameterRangeValue(); param_.StartValue = startData; param_.EndValue = endData; param_.LowerBoundType = RangeBoundType.BoundInclusive; param_.UpperBoundType = RangeBoundType.BoundInclusive; ParameterFieldDefinitions def_ = report.DataDefinition.ParameterFields; ParameterFieldDefinition paramDef_ = def_[name_parametre]; paramDef_.IsOptionalPrompt = false; paramDef_.CurrentValues.Clear(); paramDef_.CurrentValues.Add(param_); paramDef_.ApplyCurrentValues(paramDef_.CurrentValues); }
public void ImprimirReporte(int Sucursal, int Cliente, int Secuencia) { try { this.rptReporte.Load(Globals.GetInstance._RutaReportes + "\\spPTLValeDeCaja.rpt"); ParameterFieldDefinition parameterFieldDefinition1 = this.rptReporte.DataDefinition.ParameterFields[0]; ParameterValues currentValues1 = parameterFieldDefinition1.CurrentValues; currentValues1.Add((object)new ParameterDiscreteValue() { Value = (object)1 }); parameterFieldDefinition1.ApplyCurrentValues(currentValues1); ParameterFieldDefinition parameterFieldDefinition2 = this.rptReporte.DataDefinition.ParameterFields[1]; ParameterValues currentValues2 = parameterFieldDefinition2.CurrentValues; currentValues2.Add((object)new ParameterDiscreteValue() { Value = (object)Cliente }); parameterFieldDefinition2.ApplyCurrentValues(currentValues2); ParameterFieldDefinition parameterFieldDefinition3 = this.rptReporte.DataDefinition.ParameterFields[2]; ParameterValues currentValues3 = parameterFieldDefinition3.CurrentValues; currentValues3.Add((object)new ParameterDiscreteValue() { Value = (object)Secuencia }); parameterFieldDefinition3.ApplyCurrentValues(currentValues3); this.AplicaInfoConexion(); try { this.EstablecerImpresora(); this.rptReporte.PrintToPrinter(1, false, 0, 0); } catch (Exception ex) { ProjectData.SetProjectError(ex); int num = (int)MessageBox.Show(new Mensaje(12).Mensaje, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Hand); ProjectData.ClearProjectError(); } } catch (Exception ex) { ProjectData.SetProjectError(ex); int num = (int)MessageBox.Show(new Mensaje(12).Mensaje, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Hand); ProjectData.ClearProjectError(); } }
private void printReportOnOffToolStripMenuItem_CheckedChanged(object sender, EventArgs e) { if (printReportOnOffToolStripMenuItem.Checked) { this.Width = 1084; this.Height = 478; zakatreport crystalReport1 = new zakatreport(); try { ParameterFieldDefinitions parameterFieldDefinitions1 = crystalReport1.DataDefinition.ParameterFields; ParameterFieldDefinition parameterFieldDefinition1 = parameterFieldDefinitions1["AID"]; ParameterDiscreteValue parameterDiscreteValue1 = new ParameterDiscreteValue(); parameterDiscreteValue1.Value = lblGUID.Text; ParameterValues parameterValues1 = new ParameterValues(parameterFieldDefinition1.CurrentValues); parameterValues1.Add(parameterDiscreteValue1); parameterFieldDefinition1.ApplyCurrentValues(parameterValues1); ParameterFieldDefinitions parameterFieldDefinitions2 = crystalReport1.DataDefinition.ParameterFields; ParameterFieldDefinition parameterFieldDefinition2 = parameterFieldDefinitions2["ZYear"]; ParameterDiscreteValue parameterDiscreteValue2 = new ParameterDiscreteValue(); parameterDiscreteValue2.Value = comboBox1.Text; ParameterValues parameterValues2 = new ParameterValues(parameterFieldDefinition2.CurrentValues); parameterValues2.Add(parameterDiscreteValue2); parameterFieldDefinition2.ApplyCurrentValues(parameterValues2); //crystalReportViewer1.ShowRefreshButton = false; crystalReportViewer1.ShowParameterPanelButton = false; crystalReportViewer1.ShowCopyButton = false; crystalReportViewer1.ShowExportButton = false; crystalReportViewer1.ReportSource = crystalReport1; } catch (Exception ex) { MessageBox.Show(ex.Message); } } else { this.Width = 548; this.Height = 478; } }
private void frmInPhieuXuatVT_Load(object sender, EventArgs e) { InPhieuXuatVT rpt = new InPhieuXuatVT(); rpt.DataSourceConnections[0].SetConnection(conn.ServerName1, conn.DataBase, conn.StrUser, conn.StrPass); //rpt.SetDatabaseLogon(frmKetNoiHeThong.Luu.user, frmKetNoiHeThong.Luu.pass); ParameterFieldDefinitions pFielDefinitions = rpt.DataDefinition.ParameterFields; ParameterFieldDefinition pfdMaHD = pFielDefinitions["pMaHD"]; ParameterDiscreteValue pdvMalop = new ParameterDiscreteValue(); pdvMalop.Value = p; pfdMaHD.CurrentValues.Clear(); pfdMaHD.CurrentValues.Add(pdvMalop); pfdMaHD.ApplyCurrentValues(pfdMaHD.CurrentValues); crystalReportViewer1.ReportSource = rpt; crystalReportViewer1.DisplayToolbar = true; crystalReportViewer1.DisplayStatusBar = false; crystalReportViewer1.Refresh(); }
private void frmReporteObstetras_Load(object sender, EventArgs e) { try { Reportes.rptReportesObstetras rptReportesObstetras = new Reportes.rptReportesObstetras(); crParameterDiscreteValue.Value = sidtmicrored; crParameterFieldDefinitions = rptReportesObstetras.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["pidtmicrored"]; crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); crystalReportViewer1.ReportSource = rptReportesObstetras; crystalReportViewer1.Refresh(); } catch (Exception m) { MessageBox.Show(m.Message); } }
private void crystalReportViewer1_Load(object sender, EventArgs e) { try { rptReportesObstetras rptAlertaControlPeuperio = new rptReportesObstetras(); crParameterDiscreteValue.Value = "M001"; crParameterFieldDefinitions = rptAlertaControlPeuperio.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["pidtmicrored"]; crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); crystalReportViewer1.ReportSource = rptAlertaControlPeuperio; crystalReportViewer1.Refresh(); } catch (Exception m) { MessageBox.Show(m.Message); } }
private void ApplyReportParameters(Dictionary <string, string> parameters, ReportDocument report, out string errorText) { errorText = string.Empty; foreach (KeyValuePair <string, string> entry in parameters) { ParameterFieldDefinition reportParameter = null; try { reportParameter = report.DataDefinition.ParameterFields[entry.Key]; } catch (COMException ex) { if (ex.ErrorCode == -2147352565) { errorText += string.Format("Parameter: \"{0}\" doesn't exist in the report file: \"{1}\"", entry.Key, report.FileName); continue; } else { throw; } } if (reportParameter != null) { reportParameter.CurrentValues.Clear(); ParameterDiscreteValue parameterValue = new ParameterDiscreteValue(); parameterValue.Value = entry.Value; reportParameter.CurrentValues.Add(parameterValue); reportParameter.ApplyCurrentValues(reportParameter.CurrentValues); } } }
/// <summary> /// load report /// </summary> void loadForm() { CrystalReportBills crReport = new CrystalReportBills(); crReport.SetDataSource(data); ParameterFieldDefinitions crParameterFieldDefinitions = crReport.DataDefinition.ParameterFields; ParameterFieldDefinition crParameterFieldDefinition = crParameterFieldDefinitions["TienThanhToan"]; ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue(); crParameterDiscreteValue.Value = TienThanhToan; ParameterValues crParameterValues = new ParameterValues(); //reset lại value crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); crystalReportViewerBills.ReportSource = crReport; crystalReportViewerBills.Refresh(); }
/// <summary> /// Xem chi tiết báo cáo /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnChiTiet_Click(object sender, EventArgs e) { switch (((PhuongThuctimKiem)cbThongKe.SelectedItem).Loai) { case 0: string tenma = StaticClass.xoakhoangtrang(txbSearchFood.Text); DateTime tuNgay = dtpkTuNgay.Value; DateTime denNgay = dtpkDenNgay.Value; CrystalReportThongKeTenMonAn cr = new CrystalReportThongKeTenMonAn(); cr.SetDataSource(HoaDonDAO.Instance.USP_getThongKeTheoTenchiTiet(tenma, tuNgay, denNgay)); ParameterFieldDefinitions crParameterFieldDefinitions = cr.DataDefinition.ParameterFields; ParameterFieldDefinition crParameterFieldDefinition = crParameterFieldDefinitions["TuNgay"]; ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue(); crParameterDiscreteValue.Value = tuNgay; ParameterValues crParameterValues = new ParameterValues(); //reset lại value crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); ParameterFieldDefinition crParameterFieldDefinitionDenNgay = crParameterFieldDefinitions["DenNgay"]; ParameterDiscreteValue crParameterDiscreteValueDenNgay = new ParameterDiscreteValue(); crParameterDiscreteValueDenNgay.Value = denNgay; ParameterValues crParameterValuesDenNgay = new ParameterValues(); //reset lại value crParameterValuesDenNgay = crParameterFieldDefinitionDenNgay.CurrentValues; crParameterValuesDenNgay.Add(crParameterDiscreteValueDenNgay); crParameterFieldDefinitionDenNgay.ApplyCurrentValues(crParameterValuesDenNgay); fReport f = new fReport(cr); f.ShowDialog(); break; case 1: string tenLoai = StaticClass.xoakhoangtrang(txbSearchFood.Text); DateTime tuNgayLoai = dtpkTuNgay.Value; DateTime denNgayLoai = dtpkDenNgay.Value; CrystalReportThongKeLoaiMonAn crLoai = new CrystalReportThongKeLoaiMonAn(); crLoai.SetDataSource(HoaDonDAO.Instance.USP_getThongKeTheoLoaichiTiet(tenLoai, tuNgayLoai, denNgayLoai)); ParameterFieldDefinitions crParameterFieldDefinitionsLoai = crLoai.DataDefinition.ParameterFields; ParameterFieldDefinition crParameterFieldDefinitionLoai = crParameterFieldDefinitionsLoai["TuNgay"]; ParameterDiscreteValue crParameterDiscreteValueLoai = new ParameterDiscreteValue(); crParameterDiscreteValueLoai.Value = tuNgayLoai; ParameterValues crParameterValuesLoai = new ParameterValues(); //reset lại value crParameterValues = crParameterFieldDefinitionLoai.CurrentValues; crParameterValues.Add(crParameterDiscreteValueLoai); crParameterFieldDefinitionLoai.ApplyCurrentValues(crParameterValues); ParameterFieldDefinition crParameterFieldDefinitionDenNgayLoai = crParameterFieldDefinitionsLoai["DenNgay"]; ParameterDiscreteValue crParameterDiscreteValueDenNgayLoai = new ParameterDiscreteValue(); crParameterDiscreteValueDenNgayLoai.Value = denNgayLoai; ParameterValues crParameterValuesDenNgayLoai = new ParameterValues(); //reset lại value crParameterValuesDenNgayLoai = crParameterFieldDefinitionDenNgayLoai.CurrentValues; crParameterValuesDenNgayLoai.Add(crParameterDiscreteValueDenNgayLoai); crParameterFieldDefinitionDenNgayLoai.ApplyCurrentValues(crParameterValuesDenNgayLoai); fReport fLoai = new fReport(crLoai); fLoai.ShowDialog(); break; } }
/// <summary> /// In báo cáo chi. 0 hóa đơn nhâp. 1 tiền lương nhân viên /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ptbPrintExport_Click(object sender, EventArgs e) { switch (((BaoCaoChi)cbChi.SelectedItem).BaoCao) { case 0: DateTime TuNgay = dtpkTuNgayChi.Value; DateTime denNgay = dtpkDenNgayChi.Value; CrystalReportBaoCaoChiNhapThucPham cr = new CrystalReportBaoCaoChiNhapThucPham(); cr.SetDataSource(HoaDonNhapDAO.Instance.getListHoaDonNhapTuNgayDenNgay(TuNgay, denNgay)); ParameterFieldDefinitions crParameterFieldDefinitions = cr.DataDefinition.ParameterFields; ParameterFieldDefinition crParameterFieldDefinition = crParameterFieldDefinitions["TuNgay"]; ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue(); crParameterDiscreteValue.Value = TuNgay; ParameterValues crParameterValues = new ParameterValues(); //reset lại value crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); ParameterFieldDefinition crParameterFieldDefinitionDenNgay = crParameterFieldDefinitions["DenNgay"]; ParameterDiscreteValue crParameterDiscreteValueDenNgay = new ParameterDiscreteValue(); crParameterDiscreteValueDenNgay.Value = denNgay; ParameterValues crParameterValuesDenNgay = new ParameterValues(); //reset lại value crParameterValuesDenNgay = crParameterFieldDefinitionDenNgay.CurrentValues; crParameterValuesDenNgay.Add(crParameterDiscreteValueDenNgay); crParameterFieldDefinitionDenNgay.ApplyCurrentValues(crParameterValuesDenNgay); fReport f = new fReport(cr); f.ShowDialog(); break; case 1: DateTime TuNgaya = dtpkTuNgayChi.Value; DateTime denNgaya = dtpkDenNgayChi.Value; CrystalReportBaoCaoChiLuongNhanVien cr1 = new CrystalReportBaoCaoChiLuongNhanVien(); cr1.SetDataSource(BangLuongNhanVienDAO.Instance.getListBangLuongTuNgayDenNgay(TuNgaya, denNgaya)); ParameterFieldDefinitions crParameterFieldDefinitions1 = cr1.DataDefinition.ParameterFields; ParameterFieldDefinition crParameterFieldDefinition1 = crParameterFieldDefinitions1["TuNgay"]; ParameterDiscreteValue crParameterDiscreteValue1 = new ParameterDiscreteValue(); crParameterDiscreteValue1.Value = TuNgaya; ParameterValues crParameterValues1 = new ParameterValues(); //reset lại value crParameterValues1 = crParameterFieldDefinition1.CurrentValues; crParameterValues1.Add(crParameterDiscreteValue1); crParameterFieldDefinition1.ApplyCurrentValues(crParameterValues1); ParameterFieldDefinition crParameterFieldDefinitionDenNgay1 = crParameterFieldDefinitions1["DenNgay"]; ParameterDiscreteValue crParameterDiscreteValueDenNgay1 = new ParameterDiscreteValue(); crParameterDiscreteValueDenNgay1.Value = denNgaya; ParameterValues crParameterValuesDenNgay1 = new ParameterValues(); //reset lại value crParameterValuesDenNgay1 = crParameterFieldDefinitionDenNgay1.CurrentValues; crParameterValuesDenNgay1.Add(crParameterDiscreteValueDenNgay1); crParameterFieldDefinitionDenNgay1.ApplyCurrentValues(crParameterValuesDenNgay1); fReport f1 = new fReport(cr1); f1.ShowDialog(); break; } }
private void Button5_Click(object sender, EventArgs e) { try { cryRpt.Load(CHEMINRPT); ConnectionInfo connectionInfo = new ConnectionInfo(); ConnectionInfo connectionInfo2 = connectionInfo; connectionInfo2.ServerName = "erp_db"; connectionInfo2.DatabaseName = ""; connectionInfo2.UserID = Globals.BDUSER; connectionInfo2.Password = Globals.BDPW; connectionInfo2.IntegratedSecurity = true; connectionInfo2 = null; TableLogOnInfos tableLogOnInfos = new TableLogOnInfos(); TableLogOnInfo tableLogOnInfo = new TableLogOnInfo(); Tables tables = cryRpt.Database.Tables; IEnumerator enumerator = default(IEnumerator); try { enumerator = tables.GetEnumerator(); while (enumerator.MoveNext()) { Table table = (Table)enumerator.Current; tableLogOnInfo = table.LogOnInfo; tableLogOnInfo.ConnectionInfo = connectionInfo; table.ApplyLogOnInfo(tableLogOnInfo); } } finally { if (enumerator is IDisposable) { (enumerator as IDisposable).Dispose(); } } ParameterValues parameterValues = new ParameterValues(); ParameterDiscreteValue parameterDiscreteValue = new ParameterDiscreteValue(); parameterDiscreteValue.Value = NUMFACT.Text; ParameterFieldDefinitions parameterFields = cryRpt.DataDefinition.ParameterFields; ParameterFieldDefinition parameterFieldDefinition = parameterFields[PARAMFACT]; parameterValues = parameterFieldDefinition.CurrentValues; parameterValues.Clear(); parameterValues.Add(parameterDiscreteValue); parameterFieldDefinition.ApplyCurrentValues(parameterValues); CRV.ReportSource = cryRpt; CRV.Refresh(); } catch (Exception ex) { ProjectData.SetProjectError(ex); Exception ex2 = ex; MessageBox.Show(ex2.Message); ProjectData.ClearProjectError(); } finally { if (Globals.conn != null) { Globals.conn.Close(); } } try { DiskFileDestinationOptions diskFileDestinationOptions = new DiskFileDestinationOptions(); PdfRtfWordFormatOptions formatOptions = new PdfRtfWordFormatOptions(); NOMFICHJOINT = Nommail + " " + DateTime.Now.ToString("yyyy_MM_dd HH_mm_ss"); diskFileDestinationOptions.DiskFileName = "C:\\SIGC utility\\Fichier joint\\" + NOMFICHJOINT + ".pdf"; MyProject.Forms.Mail.chemin.Text = "C:\\SIGC utility\\Fichier joint\\" + NOMFICHJOINT + ".pdf"; ExportOptions exportOptions = cryRpt.ExportOptions; ExportOptions exportOptions2 = exportOptions; exportOptions2.ExportDestinationType = ExportDestinationType.DiskFile; exportOptions2.ExportFormatType = ExportFormatType.PortableDocFormat; exportOptions2.DestinationOptions = diskFileDestinationOptions; exportOptions2.FormatOptions = formatOptions; exportOptions2 = null; cryRpt.Export(); MyProject.Forms.Mail.Show(); MyProject.Forms.Mail.BringToFront(); MyProject.Forms.Mail.pathT.Text = "C:\\SIGC utility\\Fichier joint\\" + NOMFICHJOINT + ".pdf"; MyProject.Forms.Mail.AjoutFJ_Click(RuntimeHelpers.GetObjectValue(sender), e); } catch (Exception ex3) { ProjectData.SetProjectError(ex3); Exception ex4 = ex3; Interaction.MsgBox(ex4.ToString(), MsgBoxStyle.OkOnly, null); ProjectData.ClearProjectError(); } }
private void ReportMultiesTable() { try { Dictionary <string, Dictionary <string, string> > LstValues = new Dictionary <string, Dictionary <string, string> >(); Dictionary <string, string> parameters = new Dictionary <string, string>(); Dictionary <string, string> ParametersReport = new Dictionary <string, string>(); string key_compare = "pfrp_"; string storeKey = "_stna_"; int _index = 0; string storeName = ""; string _keyParam = ""; foreach (String key in Request.QueryString.AllKeys) { if (key != "ReportName" && key != "StoreName" && key != "IsMuiltiesStore" && key != "HasValue" && key != "TitleName" && key != "IsPrintTemp" && key != "IsExportExcel" && key != "PathExport" && key != "IsExportExcelOld" && key != "IsExportNew" && key != "TypeExport" ) { //Lenght Key > 5 char if (key.Substring(0, key_compare.Length).Equals(key_compare)) { ParametersReport.Add(key.Substring( key_compare.Length , key.Length - key_compare.Length), Request[key]); } else { _index = key.IndexOf(storeKey); storeName = key.Substring(0, _index); _keyParam = key.Substring(_index + 6, key.Length - _index - 6); if (!LstValues.ContainsKey(storeName)) { LstValues.Add(storeName, new Dictionary <string, string>()); } LstValues[storeName].Add(_keyParam, Request[key]); } } } //Goi load report AssetMangement.GenerateData.ConnectData sqlData = new AssetMangement.GenerateData.ConnectData(); rpds_demo = new ReportDataSet(); try { foreach (var store_name in LstValues.Keys) { sqlData.Paramerters = new List <string>(); sqlData.ParametersType = new List <SqlDbType>(); sqlData.ParamertersValue = new List <string>(); if (Request["HasValue"] == "True") { foreach (KeyValuePair <string, string> pair in LstValues[store_name]) { sqlData.Paramerters.Add("@" + pair.Key); sqlData.ParametersType.Add(SqlDbType.VarChar); sqlData.ParamertersValue.Add(pair.Value); } } //add paramerters cho store proc //rpds_demo = new ReportDataSet(); bool isLoad = sqlData.Read_Store(store_name, true); if (isLoad) { try { DataTable dt = sqlData.DataSource; dt.TableName = storeKey + store_name; rpds_demo.Tables.Add(dt); } catch (Exception ex) { Label1.Text = ex.Message; } } else { Label1.Text = "Không kết nối được"; } } } catch (Exception ex) { Label1.Text = "Lỗi data: " + ex.Message; return; } finally { GC.Collect(); } try { string reportPath = Server.MapPath("/Reports/Management/" + Request["ReportName"]); cryRpt = new ReportDocument(); cryRpt.Load(reportPath); cryRpt.SummaryInfo.ReportTitle = Request["TitleName"]; foreach (var keyStoreName in LstValues.Keys) { //reportDocument.OpenSubreport("rptSubReport1.rpt").SetDataSource(dt1); // reportDocument.OpenSubreport("rptSubReport2JNR.rpt").SetDataSource(dt2); cryRpt.Database.Tables[keyStoreName].SetDataSource(rpds_demo.Tables[storeKey + keyStoreName]); } if (ParametersReport.Count > 0) { foreach (KeyValuePair <string, string> pair in ParametersReport) { ParameterDiscreteValue pa = new ParameterDiscreteValue(); pa.Value = pair.Value; ParameterFieldDefinition crParameterFieldDefinition = cryRpt.DataDefinition.ParameterFields[pair.Key]; crParameterFieldDefinition.CurrentValues.Clear(); crParameterFieldDefinition.CurrentValues.Add(pa); crParameterFieldDefinition.ApplyCurrentValues(crParameterFieldDefinition.CurrentValues); } } CrystalReportViewer.ReportSource = cryRpt; } catch (Exception exr) { Label1.Text = "Lỗi parameter Report: " + exr.Message; return; } finally { GC.Collect(); } } catch (Exception ex) { Label1.Text = "Lỗi:" + ex.Message; return; } }
private void load_rpt_FILE(String reportName, String storeName, Dictionary <string, string> paramerter, Dictionary <string, string> parameterReport = null , String hasValue = "false", String title = "Tiêu đề", String isPrintTemp = "False", String isExportExcel = "False") { //ReportDB.exportDataToExcel("ABC", null, "OIUYTR"); //return; AssetMangement.GenerateData.ConnectData sqlData = new AssetMangement.GenerateData.ConnectData(); if (hasValue == "True") { foreach (KeyValuePair <string, string> pair in paramerter) { sqlData.Paramerters.Add("@" + pair.Key); sqlData.ParametersType.Add(SqlDbType.VarChar); sqlData.ParamertersValue.Add(pair.Value); } } // add paramerters cho store proc rpds_demo = new ReportDataSet(); bool isLoad = sqlData.Read_Store(storeName, true); if (isExportExcel == "True" || isExportExcel == "true") { // HyperLink1.NavigateUrl = HttpContext.Current.Request.PhysicalApplicationPath + "ReportPages/"; // return; string tieude = Request["TitleName"]; DataTable dt = new DataTable(); string reportNameWithoutExtension = reportName.Substring(0, reportName.IndexOf('.')); dt = sqlData.DataSource; Dictionary <string, string> listNewColumnName = ReportDB.ReadXML(reportNameWithoutExtension); if (listNewColumnName == null) { Label1.Text = "Lỗi đọc XML"; return; } foreach (KeyValuePair <string, string> pair in listNewColumnName) { // values += "&" + pair.Key + "=" + pair.Value; // check name load from xml if (dt.Columns.Contains(pair.Key) && !dt.Columns.Contains(pair.Value)) { dt.Columns[pair.Key].ColumnName = pair.Value; } } // string path = ReportDB.SaveAs(reportNameWithoutExtension); string path = HttpContext.Current.Request.PhysicalApplicationPath + "ReportPages/" + reportNameWithoutExtension + ".xls"; bool isComplete = ReportDB.exportDataToExcel(tieude, dt, path); Label1.Text = "Xuất file excel cho report " + tieude; if (isComplete) { Label1.Text += " thành công ! ";// + "<a id=\"linkdownload\" href=\"" + path + "\">Tải file</a>"; HyperLink1.NavigateUrl = "../" + reportNameWithoutExtension + ".xls"; HyperLink1.Text = "Tải file"; // System.Diagnostics.Process.Start(path); } else { Label1.Text += " thất bại !"; } // Label1.Text = System.Environment.GetFolderPath(Environment.SpecialFolder.Desktop) + "\\" + "reportName" + ".xls"; return; } try { if (isLoad) { try { DataTable dt = sqlData.DataSource; if (isPrintTemp.Equals("True")) { dt = getDataPrintTemp(dt, parameterReport.First().Value); } dt.TableName = "Newrpt"; rpds_demo.Tables.Add(dt); } catch (Exception ex) { Label1.Text = ex.Message; } } else { Label1.Text = "Không kết nối được"; } } catch (Exception ex) { Label1.Text = "Lỗi data: " + ex.Message; return; } finally { GC.Collect(); } try { string reportPath = Server.MapPath("/Reports/Management/" + reportName); cryRpt = new ReportDocument(); cryRpt.Load(reportPath); cryRpt.SummaryInfo.ReportTitle = title; cryRpt.SetDataSource(rpds_demo.Tables["Newrpt"]); if (parameterReport.Count > 0) { foreach (KeyValuePair <string, string> pair in parameterReport) { ParameterDiscreteValue pa = new ParameterDiscreteValue(); pa.Value = pair.Value; ParameterFieldDefinition crParameterFieldDefinition = cryRpt.DataDefinition.ParameterFields[pair.Key]; crParameterFieldDefinition.CurrentValues.Clear(); crParameterFieldDefinition.CurrentValues.Add(pa); crParameterFieldDefinition.ApplyCurrentValues(crParameterFieldDefinition.CurrentValues); } } //cryRpt.PrintOptions.PrinterName = "Fax"; //cryRpt.PrintToPrinter(1, false, 0, 0); //CrystalReportViewer.ReportSource = cryRpt; //System.Drawing.Printing.PrintDocument pDoc = new System.Drawing.Printing.PrintDocument(); // CrystalDecisions.Shared.PrintLayoutSettings PrintLayout = new CrystalDecisions.Shared.PrintLayoutSettings(); //System.Drawing.Printing.PrinterSettings printerSettings = new System.Drawing.Printing.PrinterSettings(); // printerSettings.PrinterName = "Default printer"; // don't use this, use the new button //PrintLayout.Scaling = PrintLayoutSettings.PrintScaling.DoNotScale; //System.Drawing.Printing.PageSettings pSettings = new System.Drawing.Printing.PageSettings(printerSettings); //rpt.PrintOptions.DissociatePageSizeAndPrinterPaperSize = false; //cryRpt.PrintOptions.PrinterDuplex = PrinterDuplex.Simplex; //System.Drawing.Printing.PageSettings pageSettings = new System.Drawing.Printing.PageSettings(printerSettings); //if (cryRpt.DefaultPageSettings.PaperSize.Height > cryRpt.DefaultPageSettings.PaperSize.Width) //{ // cryRpt.PrintOptions.DissociatePageSizeAndPrinterPaperSize = true; // rptClientDoc.PrintOutputController.ModifyPaperOrientation(CrPaperOrientationEnum.crPaperOrientationPortrait); //} //else //{ // cryRpt.PrintOptions.DissociatePageSizeAndPrinterPaperSize = true; // //rptClientDoc.PrintOutputController.ModifyPaperOrientation(CrPaperOrientationEnum.crPaperOrientationLandscape); //} //cryRpt.PrintToPrinter(printerSettings, pageSettings, false, PrintLayout); CrystalReportViewer.ReportSource = cryRpt; } catch (Exception exr) { Label1.Text = "Lỗi parameter Report: " + exr.Message; return; } finally { GC.Collect(); } // ReportDB.exportDataToExcel("demo", sqlData.DataSource); }