public FrmCrystalReport(HandoverTempImportReExport report, UserInfo userInfo) { InitializeComponent(); _userInfo = userInfo; crystalReportViewer1.ReportSource = report; this.WindowState = FormWindowState.Maximized; }
private void btnReportBBBG_Click(object sender, EventArgs e) { if (grvDecleration.SelectedRows.Count == 0) { MessageBox.Show("Bạn cần chọn 1 tờ khai để in biên bản bàn giao."); return; } var declerationId = Convert.ToInt64(grvDecleration.SelectedRows[0].Cells["DeclarationID"].Value); // Get Decleration information var declarationInfo = DeclarationFactory.GetByID(declerationId); ECustoms.HandoverTempImportReExport report = new HandoverTempImportReExport(); // Cuc hai quan ((TextObject)report.Section1.ReportObjects["SuperiorCompany"]).Text = GetUserConfig().ToUpper(); // Chi cuc hai quan ((TextObject)report.Section1.ReportObjects["CompanyName"]).Text = GlobalInfo.CompanyName.ToUpper(); //((TextObject)report.Section1.ReportObjects["txtHandoverNumber"]).Text = declarationInfo.NumberHandover!=null? declarationInfo.NumberHandover.ToString() : ""; if (declarationInfo.DateHandover != null) { ((TextObject)report.Section1.ReportObjects["txtDate"]).Text = "Hồi " + declarationInfo.DateHandover.Value.Hour + " giờ " + declarationInfo.DateHandover.Value.Minute + " phút, " + "ngày " + declarationInfo.DateHandover.Value.Day + " tháng " + declarationInfo.DateHandover.Value.Month + " năm " + declarationInfo.DateHandover.Value.Year + ","; } // Chi cuc hai quan ((TextObject)report.Section1.ReportObjects["txtBranchName"]).Text = GlobalInfo.CompanyName.ToUpper(); ((TextObject)report.Section1.ReportObjects["txtCompany"]).Text = declarationInfo.CompanyName; ((TextObject)report.Section1.ReportObjects["txtNumber"]).Text = declarationInfo.Number.ToString(); StringBuilder buffer = new StringBuilder(); buffer.Append(" SELECT * FROM ViewAllDeclarationTNTX "); buffer.Append(" WHERE "); buffer.Append(" DeclarationID = " + declerationId); 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); //preview report var reportForm = new FrmCrystalReport(report, _userInfo); reportForm.MaximizeBox = true; reportForm.Show(this); }
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { HandoverTempImportReExport rpt = new HandoverTempImportReExport(); rpt.Site = this.Site; return rpt; }