public FrmCrystalReport(HandoverStatisticReport report, UserInfo userInfo)
{
InitializeComponent();
_userInfo = userInfo;
crystalReportViewer1.ReportSource = report;
this.WindowState = FormWindowState.Maximized;
}
private void btnPrintReport_Click(object sender, EventArgs e)
{
ECustoms.HandoverStatisticReport report = new HandoverStatisticReport();
// Cuc hai quan
((TextObject)report.Section1.ReportObjects["SuperiorCompany"]).Text = GetUserConfig().ToUpper();
// Chi cuc hai quan
((TextObject)report.Section1.ReportObjects["CompanyName"]).Text = GlobalInfo.CompanyName.ToUpper();
//StringBuilder buffer = new StringBuilder();
//buffer.Append(" SELECT * FROM ViewAllDeclarationTNTX ");
//buffer.Append(" WHERE DeclarationID != 0 AND DeclarationID != 1 ");
//var connection = new SqlConnection(Common.Decrypt(System.Configuration.ConfigurationSettings.AppSettings["connectionString"], true));
//var adpater = new SqlDataAdapter(buffer.ToString(), connection);
//var dt = new DataTable();
//adpater.Fill(dt);
//report.SetDataSource(dt);
DataSet2 dataSet2 = new DataSet2();
DataTable table1 = dataSet2.ViewAllDeclarationTNTX;
foreach (ViewAllDeclaration obj in _listDeclarationinfo)
{
table1.Rows.Add(
obj.DeclarationID,
obj.Number,
null,
null,
null,
obj.Unit,
null,
null,
null,
null,
null,
null,
obj.Type,
null,
obj.RegisterDate,
null,
null,
null,
obj.RegisterPlace,
null,
obj.NumberHandover,
obj.DateHandover,
null,
null,
null,
null,
null,
null,
obj.Seal,
1,
null,
null,
null,
null,
null,
null,
null);
}
report.SetDataSource(dataSet2);
//preview report
var reportForm = new FrmCrystalReport(report, _userInfo);
reportForm.MaximizeBox = true;
reportForm.Show(this);
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() {
HandoverStatisticReport rpt = new HandoverStatisticReport();
rpt.Site = this.Site;
return rpt;
}