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();
}
/// <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 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>
/// A report can contains more than One parameters, hence
/// we loop through all parameters that user has input and match
/// it with parameter definition of Crystal Reports file.
/// </summary>
public ParameterValues GetParameterValues(ParameterFieldDefinition ParameterDef)
{
ParameterValues paramValues = new ParameterValues();
//ParameterValue paramValue;
for (int j = 0; j < _userParams.Count; j++)
{
if (ParameterDef.Name == _userParams[j].ParameterName)
{
if (ParameterDef.EnableAllowMultipleValue && _userParams[j].ParameterValue.IndexOf("|") != -1)
{
// multiple value parameter
List <string> values = new List <string>();
values = Helper.SplitIntoSingleValue(_userParams[j].ParameterValue); //split multiple value into single value regardless discrete or range
for (int k = 0; k < values.Count; k++)
{
ParameterValue paramValue = GetSingleParamValue(ParameterDef.DiscreteOrRangeKind, values[k], ParameterDef.Name);
paramValues.Add(paramValue);
}
}
else
{
// simple single value parameter
ParameterValue paramValue = GetSingleParamValue(ParameterDef.DiscreteOrRangeKind, _userParams[j].ParameterValue, ParameterDef.Name);
paramValues.Add(paramValue);
}
}
}
return(paramValues);
}
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 Mes(ReportClass rpt, string pmes)
{
crParameterDiscreteValue.Value = pmes;
crParameterFieldDefinitions = rpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["pmes"];
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);
}
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 add_fieldparam(String col, String val)
{
try
{
crParameterDiscreteValue.Value = val;
crParameterFieldDefinitions = myReportDocument.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions[col];
crParameterValues = crParameterFieldDefinition.CurrentValues;
clr_param();
}
catch (Exception error) { MessageBox.Show(error.Message); }
}
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;
}
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 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);
}
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);
}
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 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);
}
private static void ProcessParameterFieldDefinition(ParameterFieldDefinition pfd, XmlWriter xmlw)
{
xmlw.WriteStartElement("ParameterFieldDefinition");
xmlw.WriteAttributeString("DefaultValueDisplayType", pfd.DefaultValueDisplayType.ToStringSafe());
xmlw.WriteAttributeString("DefaultValueSortMethod", pfd.DefaultValueSortMethod.ToStringSafe());
xmlw.WriteAttributeString("DefaultValueSortOrder", pfd.DefaultValueSortOrder.ToStringSafe());
xmlw.WriteAttributeString("DiscreteOrRangeKind", pfd.DiscreteOrRangeKind.ToStringSafe());
xmlw.WriteAttributeString("EditMask", pfd.EditMask);
xmlw.WriteAttributeString("EnableAllowEditingDefaultValue", pfd.EnableAllowEditingDefaultValue.ToStringSafe());
xmlw.WriteAttributeString("EnableAllowMultipleValue", pfd.EnableAllowMultipleValue.ToStringSafe());
xmlw.WriteAttributeString("EnableNullValue", pfd.EnableNullValue.ToStringSafe());
xmlw.WriteAttributeString("FormulaName", pfd.FormulaName);
xmlw.WriteAttributeString("HasCurrentValue", pfd.HasCurrentValue.ToStringSafe());
xmlw.WriteAttributeString("IsOptionalPrompt", pfd.IsOptionalPrompt.ToStringSafe());
try
{
xmlw.WriteAttributeString("IsLinked", pfd.IsLinked().ToStringSafe());
}
catch (NotSupportedException) //IsLinked not supported in subreport
{ }
xmlw.WriteAttributeString("Kind", pfd.Kind.ToStringSafe());
xmlw.WriteAttributeString("MaximumValue", pfd.MaximumValue.ToStringSafe());
xmlw.WriteAttributeString("MinimumValue", pfd.MinimumValue.ToStringSafe());
xmlw.WriteAttributeString("Name", pfd.Name);
xmlw.WriteAttributeString("NumberOfBytes", pfd.NumberOfBytes.ToStringSafe());
xmlw.WriteAttributeString("ParameterFieldName", pfd.ParameterFieldName);
xmlw.WriteAttributeString("ParameterFieldUsage2", pfd.ParameterFieldUsage2.ToStringSafe());
xmlw.WriteAttributeString("ParameterType", pfd.ParameterType.ToStringSafe());
xmlw.WriteAttributeString("ParameterValueKind", pfd.ParameterValueKind.ToStringSafe());
xmlw.WriteAttributeString("PromptText", pfd.PromptText);
xmlw.WriteAttributeString("ReportName", pfd.ReportName);
xmlw.WriteAttributeString("UseCount", pfd.UseCount.ToStringSafe());
xmlw.WriteAttributeString("ValueType", pfd.ValueType.ToStringSafe());
ProcessParameterValues(pfd.CurrentValues, xmlw, "CurrentValues");
ProcessParameterValues(pfd.DefaultValues, xmlw, "DefaultValues");
xmlw.WriteEndElement();
}
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();
}
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 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);
}
