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