private void printBBBG() { try { var reportHandOver = new ReportHandOver(); var txtNumberHandover = (TextObject)reportHandOver.Section1.ReportObjects["txtNumberHandover"]; var ddlGaDenDi = (TextObject)reportHandOver.Section1.ReportObjects["ddlGaDenDi"]; var dtpHandover = (TextObject)reportHandOver.Section1.ReportObjects["dtpHandover"]; //Khong dung //var txtSummary = (TextObject)reportHandOver.Section1.ReportObjects["txtSummary"]; var txtStatusVehicle = (TextObject)reportHandOver.Section1.ReportObjects["txtStatusVehicle"]; var txtStatusGoods = (TextObject)reportHandOver.Section1.ReportObjects["txtStatusGoods"]; var txtCustoms = (TextObject)reportHandOver.Section1.ReportObjects["txtCustoms"]; //var txtPath = (TextObject)reportHandOver.Section1.ReportObjects["txtPath"]; //var txtConfirmOfToStation = (TextObject)reportHandOver.Section1.ReportObjects["txtConfirmOfToStation"]; var txtToStation = (TextObject)reportHandOver.Section1.ReportObjects["txtToStation"]; var txtFromStation = (TextObject)reportHandOver.Section1.ReportObjects["txtFromStation"]; long handoverId = _handover.ID; //1L; tblHandover handover = TrainFactory.FindHandoverByID(handoverId); if (handover != null) { if (handover.tblHandoverResources.IsLoaded == false) { handover.tblHandoverResources.Load(); } List <tblHandoverResource> listTblHandoverResources = TrainFactory.FindHandoverResourceByHandoverID(handoverId); //List<tblHandoverResource> listTblHandoverResources = handover.tblHandoverResources.ToList(); ; List <tblToaTau> listToaTau = new List <tblToaTau>(); foreach (tblHandoverResource obj in listTblHandoverResources) { if (obj.tblToaTauReference.IsLoaded == false) { obj.tblToaTauReference.Load(); } if (obj.tblToaTau != null) { listToaTau.Add(obj.tblToaTau); } } DataSet1 dataset = new DataSet1(); DataTable dt = dataset.tblToaTau; //dt = ListToDataTable.ToDataTable(listToaTau); foreach (tblToaTau toaTau in listToaTau) { if (toaTau.tblChuyenTauReference.IsLoaded == false) { toaTau.tblChuyenTauReference.Load(); } dt.Rows.Add(toaTau.ToaTauID, toaTau.Ma_ToaTau , toaTau.So_VanTai_Don , toaTau.Ngay_VanTai_Don , toaTau.Ten_DoiTac , toaTau.Ma_DoanhNghiep , toaTau.Ten_Hang , toaTau.Trong_Luong , toaTau.Don_Vi_Tinh , toaTau.Seal_VanTai , toaTau.Seal_VanTai2 , toaTau.Seal_HaiQuan , toaTau.Seal_HaiQuan2 , toaTau.Ghi_Chu , toaTau.CreatedDate , toaTau.CreatedBy , toaTau.ModifiedDate , toaTau.ModifiedBy , toaTau.tblChuyenTau.TrainID); } reportHandOver.SetDataSource(dataset); String fromStation = CustomsFacory.FindByCode(handover.CodeStation).CustomsName; String toStation = CustomsFacory.FindByCode(handover.CodeStationFromTo).CustomsName; //if (handover.DateHandover != null) //{ // String dateString = "Hồi " + handover.DateHandover.Value.Hour + " giờ " + handover.DateHandover.Value.Minute + " phút, ngày " + handover.DateHandover.Value.Day + " tháng " + handover.DateHandover.Value.Month + " năm " + handover.DateHandover.Value.Year; // txtSummary.Text = dateString + " " + fromStation + " bàn giao cho Chi nhánh vận tải hàng hóa đường sắt Đồng Đăng" + // " lô hàng nhập khẩu chuyển cảng vận chuyển từ " + fromStation + " đến " + toStation + "."; //} //txtNumberHandover.Text = "Số: " + handover.NumberHandover + "/BBBG-HQGA"; txtNumberHandover.Text = "Số: " + handover.NumberHandover; // Ten hai quan den ddlGaDenDi.Text = "Kính gửi: " + toStation; if (handover.DateHandover != null) { dtpHandover.Text = "Thời gian chuyển: hồi " + handover.DateHandover.Value.Hour + " giờ ngày " + handover.DateHandover.Value.Day + " tháng " + handover.DateHandover.Value.Month + " năm " + handover.DateHandover.Value.Year; } txtStatusVehicle.Text = handover.StatusVehicle; txtStatusGoods.Text = handover.StatusGoods; txtCustoms.Text = fromStation.ToUpper(); //txtPath.Text = "Từ " + fromStation + " đến " + toStation; //txtConfirmOfToStation.Text = "5. Xác nhận của " + toStation + ":"; txtFromStation.Text = fromStation; txtToStation.Text = toStation; } reportHandOver.Section3.SectionFormat.EnableUnderlaySection = true; reportHandOver.Section3.SectionFormat.EnableKeepTogether = true; FrmPreviewReport frmReport = new FrmPreviewReport(reportHandOver); frmReport.MdiParent = this.MdiParent; frmReport.Show(); } catch (Exception ex) { throw ex; } }