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;
}
}
