private void btnReport_Click(object sender, EventArgs e)
{
CR_MHTuDen rp = new CR_MHTuDen();
CrystalDecisions.Shared.ParameterValues myValue = new CrystalDecisions.Shared.ParameterValues();
CrystalDecisions.Shared.ParameterDiscreteValue PDVTuNgay = new CrystalDecisions.Shared.ParameterDiscreteValue();
CrystalDecisions.Shared.ParameterDiscreteValue PDVDenNgay = new CrystalDecisions.Shared.ParameterDiscreteValue();
CrystalDecisions.Shared.ConnectionInfo con = new CrystalDecisions.Shared.ConnectionInfo();
con.ServerName = frmDangnhap.SV;
con.DatabaseName = frmDangnhap.DB;
con.UserID = frmDangnhap.ID;
con.Password = frmDangnhap.PASS;
TableLogOnInfo table = new TableLogOnInfo();
table.ConnectionInfo = con;
rp.Database.Tables[0].ApplyLogOnInfo(table);
PDVTuNgay.Value = this.txtDayStart.Value;
myValue.Add(PDVTuNgay);
rp.DataDefinition.ParameterFields["@TUNGAY"].ApplyCurrentValues(myValue);
myValue.Clear();
PDVDenNgay.Value = this.txtDayEnd.Value;
myValue.Add(PDVDenNgay);
rp.DataDefinition.ParameterFields["@DENNGAY"].ApplyCurrentValues(myValue);
myValue.Clear();
this.crystalReportViewer1.ReportSource = rp;
}
public void INHOADON(string ms)
{
//----------1.Khai báo CrystalReport: CrystalReportHD.rpt
rp_DonHang rp = new rp_DonHang();
//----------2.Cung cấp thông tin đăng nhập cho CrystalReport: CrystalReportHD
ConnectionInfo myConn = new ConnectionInfo();
myConn.ServerName = frmDangnhap.SV;
myConn.DatabaseName = frmDangnhap.DB;
myConn.UserID = frmDangnhap.ID;
myConn.Password = frmDangnhap.PASS;
TableLogOnInfo myTable = new TableLogOnInfo();
myTable.ConnectionInfo = myConn;
rp.Database.Tables[0].ApplyLogOnInfo(myTable);
//----------3.Khai báo kết nối tham số với CrystalReport
CrystalDecisions.Shared.ParameterValues myVL = new CrystalDecisions.Shared.ParameterValues();
CrystalDecisions.Shared.ParameterDiscreteValue PDVMaHD = new CrystalDecisions.Shared.ParameterDiscreteValue();
//----------4. Truyền tham số Từ ngày - Đến ngày (Form)
//-----4.1. Truyền tham số Từ ngày
PDVMaHD.Value = ms;
myVL.Add(PDVMaHD);
rp.DataDefinition.ParameterFields["@MSHD"].ApplyCurrentValues(myVL);
myVL.Clear();
//-----------5.Gán CrystalReport vào crystalReportViewerP
crystalReportViewerHD.ReportSource = rp;
}
/// <summary>
/// Sets the parameters that have been added using the SetParameter method
/// </summary>
private void SetParameters()
{
foreach (ParameterFieldDefinition parameter in _reportDocument.DataDefinition.ParameterFields)
{
try
{
// Now get the current value for the parameter
CrystalDecisions.Shared.ParameterValues currentValues = parameter.CurrentValues;
currentValues.Clear();
// Create a value object for Crystal reports and assign the specified value.
CrystalDecisions.Shared.ParameterDiscreteValue newValue = new CrystalDecisions.Shared.ParameterDiscreteValue();
if (_parameters.ContainsKey(parameter.Name))
{
newValue.Value = _parameters[parameter.Name];
// Now add the new value to the values collection and apply the
// collection to the report.
currentValues.Add(newValue);
parameter.ApplyCurrentValues(currentValues);
}
else
{
parameter.ApplyCurrentValues(parameter.DefaultValues);
}
}
catch
{
// Ignore any errors
}
}
}
private void SetCrysParams(string respar, string IdConcretera, string IdDiam, string Prueba)
{
ParameterValues pvs = new CrystalDecisions.Shared.ParameterValues();
ParameterDiscreteValue pdvRazonsocial = new CrystalDecisions.Shared.ParameterDiscreteValue();
ParameterDiscreteValue pdvObraUbicacion = new CrystalDecisions.Shared.ParameterDiscreteValue();
ParameterDiscreteValue pdvObraColonia = new CrystalDecisions.Shared.ParameterDiscreteValue();
ParameterDiscreteValue pdvTipoPrueba = new CrystalDecisions.Shared.ParameterDiscreteValue();
ParameterDiscreteValue pdvExp3 = new CrystalDecisions.Shared.ParameterDiscreteValue();
ParameterDiscreteValue pdvExp7 = new CrystalDecisions.Shared.ParameterDiscreteValue();
ParameterDiscreteValue pdvUnidad = new CrystalDecisions.Shared.ParameterDiscreteValue();
ParameterDiscreteValue pdvSINO = new CrystalDecisions.Shared.ParameterDiscreteValue();
ParameterDiscreteValue pdvConsecutivo = new CrystalDecisions.Shared.ParameterDiscreteValue();
ParameterDiscreteValue pdvRes = new CrystalDecisions.Shared.ParameterDiscreteValue();
ParameterDiscreteValue pdvConcre = new CrystalDecisions.Shared.ParameterDiscreteValue();
ParameterDiscreteValue pdvDiam = new CrystalDecisions.Shared.ParameterDiscreteValue();
pdvRazonsocial.Value = strRazonSocial;
pvs.Add(pdvRazonsocial);
cryRepCartaEdadEspecificada.DataDefinition.ParameterFields["Razonsocial"].ApplyCurrentValues(pvs);
pvs.Clear();
pdvObraUbicacion.Value = strObraUbicacion;
pvs.Add(pdvObraUbicacion);
cryRepCartaEdadEspecificada.DataDefinition.ParameterFields["ObraUbicacion"].ApplyCurrentValues(pvs);
pvs.Clear();
pdvObraColonia.Value = strObraColonia;
pvs.Add(pdvObraColonia);
cryRepCartaEdadEspecificada.DataDefinition.ParameterFields["ObraColonia"].ApplyCurrentValues(pvs);
pvs.Clear();
pdvTipoPrueba.Value = Prueba;
pvs.Add(pdvTipoPrueba);
cryRepCartaEdadEspecificada.DataDefinition.ParameterFields["TipoPrueba"].ApplyCurrentValues(pvs);
pvs.Clear();
pdvUnidad.Value = dsUnidad1.Unidad.Rows[Mpa][0].ToString();
pvs.Add(pdvUnidad);
cryRepCartaEdadEspecificada.DataDefinition.ParameterFields["Unidad"].ApplyCurrentValues(pvs);
pvs.Clear();
pdvSINO.Value = 0;
pvs.Add(pdvSINO);
cryRepCartaEdadEspecificada.DataDefinition.ParameterFields["Logotipo"].ApplyCurrentValues(pvs);
pvs.Clear();
pdvConsecutivo.Value = "0";
pvs.Add(pdvConsecutivo);
cryRepCartaEdadEspecificada.DataDefinition.ParameterFields["Consecutivo"].ApplyCurrentValues(pvs);
pvs.Clear();
pdvRes.Value = respar;
pvs.Add(pdvRes);
cryRepCartaEdadEspecificada.DataDefinition.ParameterFields["Res"].ApplyCurrentValues(pvs);
pvs.Clear();
pdvConcre.Value = IdConcretera;
pvs.Add(pdvConcre);
cryRepCartaEdadEspecificada.DataDefinition.ParameterFields["Concre"].ApplyCurrentValues(pvs);
pvs.Clear();
pdvDiam.Value = IdDiam;
pvs.Add(pdvDiam);
cryRepCartaEdadEspecificada.DataDefinition.ParameterFields["Diam"].ApplyCurrentValues(pvs);
pvs.Clear();
// pdvRes1.Value = double.Parse(resis) ;
// pvs.Add(pdvRes1);
// cryRepCartaEdadTemprana.DataDefinition.ParameterFields["Res1"].ApplyCurrentValues(pvs);
// pvs.Clear();
}
