public void ShowInsuranceC46(int IQuarter, int IYear, string SocialInsuranceOffice, string ComName, string ComAddress, string ComAcc,
string ComBank, string ComTel, string ComFax, string YC1, string YC2, string YC3, string YC4,
string YC5, string YC6, string YC7, string YC8, DateTime CreateDate, string CopyNum, string ComID)
{
//ReportDocument rptDoc = new ReportDocument();
ReportDocument rptDoc = null;
//rptDoc.Load(@"Reports\BHXH\InsuranceC46.rpt");
rptDoc = new Reports.BHXH.InsuranceC46();
rptDoc.Refresh();
rptDoc.SetDatabaseLogon(WorkingContext.Setting.UserName, WorkingContext.Setting.Password, WorkingContext.Setting.Server, WorkingContext.Setting.Database);
rptDoc.DataDefinition.ParameterFields["IQuarter"].ApplyCurrentValues(GetReportPara(IQuarter));
rptDoc.DataDefinition.ParameterFields["IYear"].ApplyCurrentValues(GetReportPara(IYear));
rptDoc.DataDefinition.ParameterFields["SocialInsuranceOffice"].ApplyCurrentValues(GetReportPara(SocialInsuranceOffice));
rptDoc.DataDefinition.ParameterFields["ComName"].ApplyCurrentValues(GetReportPara(ComName));
rptDoc.DataDefinition.ParameterFields["ComAddress"].ApplyCurrentValues(GetReportPara(ComAddress));
rptDoc.DataDefinition.ParameterFields["ComAcc"].ApplyCurrentValues(GetReportPara(ComAcc));
rptDoc.DataDefinition.ParameterFields["ComBank"].ApplyCurrentValues(GetReportPara(ComBank));
rptDoc.DataDefinition.ParameterFields["ComTel"].ApplyCurrentValues(GetReportPara(ComTel));
rptDoc.DataDefinition.ParameterFields["ComFax"].ApplyCurrentValues(GetReportPara(ComFax));
rptDoc.DataDefinition.ParameterFields["YC1"].ApplyCurrentValues(GetReportPara(YC1));
rptDoc.DataDefinition.ParameterFields["YC2"].ApplyCurrentValues(GetReportPara(YC2));
rptDoc.DataDefinition.ParameterFields["YC3"].ApplyCurrentValues(GetReportPara(YC3));
rptDoc.DataDefinition.ParameterFields["YC4"].ApplyCurrentValues(GetReportPara(YC4));
rptDoc.DataDefinition.ParameterFields["YC5"].ApplyCurrentValues(GetReportPara(YC5));
rptDoc.DataDefinition.ParameterFields["YC6"].ApplyCurrentValues(GetReportPara(YC6));
rptDoc.DataDefinition.ParameterFields["YC7"].ApplyCurrentValues(GetReportPara(YC7));
rptDoc.DataDefinition.ParameterFields["YC8"].ApplyCurrentValues(GetReportPara(YC8));
rptDoc.DataDefinition.ParameterFields["CreateDate"].ApplyCurrentValues(GetReportPara(CreateDate));
rptDoc.DataDefinition.ParameterFields["CopyNum"].ApplyCurrentValues(GetReportPara(CopyNum));
rptDoc.DataDefinition.ParameterFields["ComID"].ApplyCurrentValues(GetReportPara(ComID));
if (rptDoc != null)
{
SetDBLogonForReport(rptDoc);
}
crViewer.ReportSource = rptDoc;
settings = ModuleConfig.GetSettings();
string reportPart = settings.ReportPath;
string Targetfile = reportPart + "\\" + "BHXH mẫu C46" + "_" + IYear + ".rpt";
FileInfo fil = new FileInfo(Targetfile);
if (fil.Exists)
if (
MessageBox.Show("Đã tồn tại báo cáo này, có ghi đè không?", "Thông báo", MessageBoxButtons.YesNo) ==
DialogResult.Yes)
{
fil.Delete();
}
else
{
return;
}
//reportDocument.SaveAs(Targetfile, true);
//Application.DoEvents();
rptDoc.ExportToDisk(ExportFormatType.CrystalReport, Targetfile);
this.Show();
}
public void ShowInsuranceC46(int IQuarter, int IYear, string SocialInsuranceOffice, string ComName, string ComAddress, string ComAcc,
string ComBank, string ComTel, string ComFax, string YC1, string YC2, string YC3, string YC4,
string YC5, string YC6, string YC7, string YC8, DateTime CreateDate, string CopyNum, string ComID)
{
//ReportDocument rptDoc = new ReportDocument();
ReportDocument rptDoc = null;
//rptDoc.Load(@"Reports\BHXH\InsuranceC46.rpt");
rptDoc = new Reports.BHXH.InsuranceC46();
rptDoc.Refresh();
rptDoc.SetDatabaseLogon(WorkingContext.Setting.UserName, WorkingContext.Setting.Password, WorkingContext.Setting.Server, WorkingContext.Setting.Database);
rptDoc.DataDefinition.ParameterFields["IQuarter"].ApplyCurrentValues(GetReportPara(IQuarter));
rptDoc.DataDefinition.ParameterFields["IYear"].ApplyCurrentValues(GetReportPara(IYear));
rptDoc.DataDefinition.ParameterFields["SocialInsuranceOffice"].ApplyCurrentValues(GetReportPara(SocialInsuranceOffice));
rptDoc.DataDefinition.ParameterFields["ComName"].ApplyCurrentValues(GetReportPara(ComName));
rptDoc.DataDefinition.ParameterFields["ComAddress"].ApplyCurrentValues(GetReportPara(ComAddress));
rptDoc.DataDefinition.ParameterFields["ComAcc"].ApplyCurrentValues(GetReportPara(ComAcc));
rptDoc.DataDefinition.ParameterFields["ComBank"].ApplyCurrentValues(GetReportPara(ComBank));
rptDoc.DataDefinition.ParameterFields["ComTel"].ApplyCurrentValues(GetReportPara(ComTel));
rptDoc.DataDefinition.ParameterFields["ComFax"].ApplyCurrentValues(GetReportPara(ComFax));
rptDoc.DataDefinition.ParameterFields["YC1"].ApplyCurrentValues(GetReportPara(YC1));
rptDoc.DataDefinition.ParameterFields["YC2"].ApplyCurrentValues(GetReportPara(YC2));
rptDoc.DataDefinition.ParameterFields["YC3"].ApplyCurrentValues(GetReportPara(YC3));
rptDoc.DataDefinition.ParameterFields["YC4"].ApplyCurrentValues(GetReportPara(YC4));
rptDoc.DataDefinition.ParameterFields["YC5"].ApplyCurrentValues(GetReportPara(YC5));
rptDoc.DataDefinition.ParameterFields["YC6"].ApplyCurrentValues(GetReportPara(YC6));
rptDoc.DataDefinition.ParameterFields["YC7"].ApplyCurrentValues(GetReportPara(YC7));
rptDoc.DataDefinition.ParameterFields["YC8"].ApplyCurrentValues(GetReportPara(YC8));
rptDoc.DataDefinition.ParameterFields["CreateDate"].ApplyCurrentValues(GetReportPara(CreateDate));
rptDoc.DataDefinition.ParameterFields["CopyNum"].ApplyCurrentValues(GetReportPara(CopyNum));
rptDoc.DataDefinition.ParameterFields["ComID"].ApplyCurrentValues(GetReportPara(ComID));
if (rptDoc != null)
{
SetDBLogonForReport(rptDoc);
}
crViewer.ReportSource = rptDoc;
settings = ModuleConfig.GetSettings();
string reportPart = settings.ReportPath;
string Targetfile = reportPart + "\\" + "BHXH mẫu C46" + "_" + IYear + ".rpt";
FileInfo fil = new FileInfo(Targetfile);
if (fil.Exists)
{
if (
MessageBox.Show("Đã tồn tại báo cáo này, có ghi đè không?", "Thông báo", MessageBoxButtons.YesNo) ==
DialogResult.Yes)
{
fil.Delete();
}
else
{
return;
}
}
//reportDocument.SaveAs(Targetfile, true);
//Application.DoEvents();
rptDoc.ExportToDisk(ExportFormatType.CrystalReport, Targetfile);
this.Show();
}
