private void button1_Click(object sender, EventArgs e) { DateTime fromDate = dtpFrom.Value; DateTime toDate = dtpTo.Value; List <tblTrain> listTrain = TrainFactory.SearchTrain("", Convert.ToInt16(((ComboBoxItem)ddlTypeName.SelectedItem).Value), true, fromDate, toDate); try { var report = new ReportPassengerTrain(); var txtType = (TextObject)report.Section1.ReportObjects["txtType"]; var txtFrom = (TextObject)report.Section1.ReportObjects["txtFrom"]; var txtTo = (TextObject)report.Section1.ReportObjects["txtTo"]; txtType.Text = ("HÀNH KHÁCH " + ddlTypeName.Text + " BẰNG ĐƯỜNG SẮT").ToUpper(); txtFrom.Text = txtFrom.Text + " " + dtpFrom.Text; txtTo.Text = txtTo.Text + " " + dtpTo.Text; DataSet1 dataset = new DataSet1(); DataTable dt = dataset.tblTrain; foreach (tblTrain train in listTrain) { dt.Rows.Add(train.TrainID, train.Number, train.Type, train.DateImportExport, train.Jounery, train.PassengerVN, train.PassengerForegin, train.Staff, train.CreatedDate, train.CreatedByName, train.ModifiedDate, train.ModifiedByName); } report.SetDataSource(dataset); FrmPreviewReport frmReport = new FrmPreviewReport(report); frmReport.MdiParent = this.MdiParent; frmReport.Show(); } catch (Exception ex) { } }
private void button1_Click(object sender, EventArgs e) { List <ViewListHanoverReply> listViewListHanoverReply = HandoverReplyFactory.search("", "", true, dtpFrom.Value, dtpTo.Value); var report = new ReportSoTheoDoiBangKeHoiBao(); var txtFrom = (TextObject)report.Section1.ReportObjects["txtFrom"]; var txtTo = (TextObject)report.Section1.ReportObjects["txtTo"]; txtFrom.Text = txtFrom.Text + " " + dtpFrom.Text; txtTo.Text = txtTo.Text + " " + dtpTo.Text; DataSet1 dataset = new DataSet1(); DataTable dt = dataset.BangKeHoiBao; foreach (ViewListHanoverReply obj in listViewListHanoverReply) { dt.Rows.Add(obj.ID, obj.ListReplyNumber, obj.ListReplyDate, obj.CustomsReceiverName, obj.Note); } report.SetDataSource(dataset); FrmPreviewReport frmReport = new FrmPreviewReport(report); frmReport.MdiParent = this.MdiParent; frmReport.Show(); }
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; } }
private void button1_Click(object sender, EventArgs e) { try { Int32 countTrain = 0, countToaTau = 0, countHandoder = 0, countDeclaration = 0, countEmpty = 0; int importExportTypeSearch = Convert.ToInt32(((ComboBoxItem)ddlImportExportType.SelectedItem).Value); List <tblChuyenTau> listTrain = TrainFactory.SearchChuyenTau("", Convert.ToInt32(((ComboBoxItem)ddlTypeName.SelectedItem).Value), true, dtpFrom.Value, dtpTo.Value); //if(importExportTypeSearch == 0) //chi list ke toa rong //{ // listTrain = listTrain.Where(x => x.tblToaTaus.Where( y => y.LoaiToaTau == (short)LoaiToaTau.ToaRong)).ToList(); //} DataSet1 dataset = new DataSet1(); DataTable dt = dataset.ViewToaTau; foreach (tblChuyenTau train in listTrain) { countTrain++; if (train.tblToaTaus.IsLoaded == false) { train.tblToaTaus.Load(); } List <tblToaTau> listToaTau = train.tblToaTaus.ToList(); foreach (tblToaTau toaTau in listToaTau) { countToaTau++; string loaiToa = ""; string loaiHinh = ""; string soBBBG = ""; string tenNguoiGui = ""; string tenNguoiNhan = ""; if (importExportTypeSearch == 0) //chi list ke toa rong { if (toaTau.LoaiToaTau != (short)LoaiToaTau.ToaRong) { continue; } } if (importExportTypeSearch == (int)ToaTauImportType.TaiCho) //chi list ke toa co loai hinh "tai cho" { if (toaTau.ImportExportType != (short)ToaTauImportType.TaiCho) { continue; } } if (importExportTypeSearch == (int)ToaTauImportType.ChuyenCang) //chi list ke toa co loai hinh "chuyen cang" { if (toaTau.ImportExportType != (short)ToaTauImportType.ChuyenCang) { continue; } } switch (toaTau.LoaiToaTau) { case (short)LoaiToaTau.ToaKin: loaiToa = "Toa kín"; break; case (short)LoaiToaTau.ToaRong: loaiToa = "Toa rỗng"; countEmpty++; break; case (short)LoaiToaTau.ToaTran: loaiToa = "Toa trần"; break; default: break; } switch (toaTau.ImportExportType) { case (short)ToaTauImportType.ChuyenCang: loaiHinh = "Chuyển cảng"; try { if (toaTau.tblHandoverResources.IsLoaded == false) { toaTau.tblHandoverResources.Load(); } tblHandoverResource handoverResource = toaTau.tblHandoverResources.FirstOrDefault(); if (handoverResource != null) { if (handoverResource.tblHandoverReference.IsLoaded == false) { handoverResource.tblHandoverReference.Load(); } soBBBG = handoverResource.tblHandover.NumberHandover; } } catch (Exception ex) { soBBBG = ""; } countHandoder++; break; case (short)ToaTauImportType.TaiCho: loaiHinh = "Tại chỗ"; try { if (toaTau.tblToKhaiTauResources.IsLoaded == false) { toaTau.tblToKhaiTauResources.Load(); } tblToKhaiTauResource toKhaiTauResources = toaTau.tblToKhaiTauResources.FirstOrDefault(); if (toKhaiTauResources != null) { if (toKhaiTauResources.tblToKhaiTauReference.IsLoaded == false) { toKhaiTauResources.tblToKhaiTauReference.Load(); } soBBBG = toKhaiTauResources.tblToKhaiTau.Number + ""; } } catch (Exception ex) { soBBBG = ""; } countDeclaration++; break; default: break; } if (train.Type == 0) //xuat { tenNguoiGui = toaTau.Ten_DoanhNghiep; tenNguoiNhan = toaTau.Ten_DoiTac; } else //nhap { tenNguoiGui = toaTau.Ten_DoiTac; tenNguoiNhan = toaTau.Ten_DoanhNghiep; } dt.Rows.Add(toaTau.ToaTauID, train.Ma_Chuyen_Tau, train.Ngay_XNC, toaTau.Ma_ToaTau, toaTau.So_VanTai_Don, tenNguoiGui, tenNguoiNhan, toaTau.Ten_Hang, toaTau.Don_Vi_Tinh, toaTau.Trong_Luong, soBBBG, toaTau.Seal_VanTai, toaTau.Seal_VanTai2, toaTau.Seal_HaiQuan, toaTau.Seal_HaiQuan2, loaiToa, loaiHinh, toaTau.Ghi_Chu); } } var report = new ReportTrainImportExport(); var txtType = (TextObject)report.Section1.ReportObjects["txtType"]; var txtFrom = (TextObject)report.Section1.ReportObjects["txtFrom"]; var txtTo = (TextObject)report.Section1.ReportObjects["txtTo"]; var txtCountTrain = (TextObject)report.Section1.ReportObjects["txtCountTrain"]; var txtCountToaTau = (TextObject)report.Section1.ReportObjects["txtCountToaTau"]; var txtCountHandover = (TextObject)report.Section1.ReportObjects["txtCountHandover"]; var txtCountDeclaration = (TextObject)report.Section1.ReportObjects["txtCountDeclaration"]; var txtCountEmpty = (TextObject)report.Section1.ReportObjects["txtCountEmpty"]; txtType.Text = ("SỔ THEO DÕI TÀU HÀNG " + ddlTypeName.Text).ToUpper(); txtFrom.Text = txtFrom.Text + " " + dtpFrom.Text; txtTo.Text = txtTo.Text + " " + dtpTo.Text; txtCountTrain.Text = txtCountTrain.Text + " " + (countTrain != 0?countTrain.ToString("#.###"):"0"); txtCountToaTau.Text = txtCountToaTau.Text + " " + (countToaTau != 0?countToaTau.ToString("#.###"):"0"); txtCountHandover.Text = txtCountHandover.Text + " " + (countHandoder != 0? countHandoder.ToString("#.###"):"0"); txtCountDeclaration.Text = txtCountDeclaration.Text + " " + (countDeclaration != 0?countDeclaration.ToString("#.###"):"0"); txtCountEmpty.Text = txtCountEmpty.Text + " " + (countEmpty != 0 ? countEmpty.ToString("#.###") : "0"); report.SetDataSource(dataset); FrmPreviewReport frmReport = new FrmPreviewReport(report); frmReport.MdiParent = this.MdiParent; frmReport.Show(); } catch (Exception ex) { } }
private void button1_Click(object sender, EventArgs e) { String replyType = ((ComboBoxItem)cbType.SelectedItem).Value.ToString(); Nullable <Boolean> replyStatus = null; if (((ComboBoxItem)cbReplyStatus.SelectedItem).Value != null) { replyStatus = (Boolean)(((ComboBoxItem)cbReplyStatus.SelectedItem).Value); } List <tblHandover> listHandover = TrainFactory.SearchBBBG("", true, dtpFrom.Value, dtpTo.Value, replyStatus, replyType, false); DataSet1 dataset = new DataSet1(); DataTable dt = dataset.BBBG; foreach (tblHandover handover in listHandover) { string tenHaiQuanChuyenDen = ""; string tenHaiQuanChuyenDi = ""; if (replyType == "0") //BBBG den { tenHaiQuanChuyenDen = CustomsFacory.FindByCode(handover.CodeStation).CustomsName; tenHaiQuanChuyenDi = CustomsFacory.FindByCode(handover.CodeStationFromTo).CustomsName; } else if (replyType == "1") //BBBG di { tenHaiQuanChuyenDen = CustomsFacory.FindByCode(handover.CodeStationFromTo).CustomsName; tenHaiQuanChuyenDi = CustomsFacory.FindByCode(handover.CodeStation).CustomsName; } dt.Rows.Add(handover.ID, handover.NumberHandover, handover.DateHandover, tenHaiQuanChuyenDi, tenHaiQuanChuyenDen, handover.StatusVehicle, handover.StatusGoods, handover.DateReply, handover.Note); } if (replyType == "0") //BBBG den { var report = new ReportHandoverComeIn(); var txtType = (TextObject)report.Section1.ReportObjects["txtType"]; var txtFrom = (TextObject)report.Section1.ReportObjects["txtFrom"]; var txtTo = (TextObject)report.Section1.ReportObjects["txtTo"]; txtFrom.Text = txtFrom.Text + " " + dtpFrom.Text; txtTo.Text = txtTo.Text + " " + dtpTo.Text; txtType.Text = ("SỔ THEO DÕI BBBG HÀNG CHUYỂN CẢNG ĐẾN").ToUpper(); report.SetDataSource(dataset); FrmPreviewReport frmReport = new FrmPreviewReport(report); frmReport.MdiParent = this.MdiParent; frmReport.Show(); } else if (replyType == "1") //BBBG di { var report = new ReportHandoverOut(); var txtType = (TextObject)report.Section1.ReportObjects["txtType"]; var txtFrom = (TextObject)report.Section1.ReportObjects["txtFrom"]; var txtTo = (TextObject)report.Section1.ReportObjects["txtTo"]; txtFrom.Text = txtFrom.Text + " " + dtpFrom.Text; txtTo.Text = txtTo.Text + " " + dtpTo.Text; txtType.Text = ("SỔ THEO DÕI BBBG HÀNG CHUYỂN CẢNG ĐI").ToUpper(); report.SetDataSource(dataset); FrmPreviewReport frmReport = new FrmPreviewReport(report); frmReport.MdiParent = this.MdiParent; frmReport.Show(); } }
private void print() { try { long replyId = _tblListHandoverReply.ID; tblListHandoverReply handoverReply = HandoverReplyFactory.FindByID(replyId); if (handoverReply == null) { MessageBox.Show("Không kết nối được với CSDL hoặc Bảng kê hồi báo này không còn tồn tại. Xin kiểm tra lại "); return; } var report = new ReportListHanoverReply(); var txtNumber = (TextObject)report.Section1.ReportObjects["txtNumber"]; var txtReplyDate = (TextObject)report.Section1.ReportObjects["txtReplyDate"]; var txtReceiverCustomsName = (TextObject)report.Section1.ReportObjects["txtReceiverCustomsName"]; var txtSummary = (TextObject)report.Section1.ReportObjects["txtSummary"]; var txtGoodsStatus = (TextObject)report.Section4.ReportObjects["txtGoodsStatus"]; var txtNote = (TextObject)report.Section4.ReportObjects["txtNote"]; txtNumber.Text = "Số: " + handoverReply.ListReplyNumber; txtReplyDate.Text = "Lạng Sơn, ngày " + handoverReply.ListReplyDate.GetValueOrDefault().Day + " tháng " + handoverReply.ListReplyDate.GetValueOrDefault().Month + " năm " + handoverReply.ListReplyDate.GetValueOrDefault().Year; txtReceiverCustomsName.Text = "Kính gửi: " + CustomsFacory.FindByCode(handoverReply.CustomsCodeReceiver).CustomsName; String fromDate = handoverReply.ReportFromDate.GetValueOrDefault().ToString("dd/MM/yyyy"); String toDate = handoverReply.ReportToDate.GetValueOrDefault().ToString("dd/MM/yyyy"); txtSummary.Text = " " + "Chi cục Hải quan ga ĐSQT Đồng đăng đã nhận được hàng và Biên bản bàn giao hàng nhập khẩu của chi cục từ ngày " + fromDate + " đến ngày " + toDate; txtGoodsStatus.Text = " " + "Tình trạng hàng hóa: " + handoverReply.ReplyStatusGoods; txtNote.Text = " " + handoverReply.Note; //fill table BBBG DataSet1 dataset = new DataSet1(); DataTable dt = dataset.tblHandover; if (handoverReply != null && handoverReply.tblHandovers.IsLoaded == false) { handoverReply.tblHandovers.Load(); } List <tblHandover> listHandover = handoverReply.tblHandovers.ToList(); foreach (tblHandover obj in listHandover) { if (obj.IsDeleted.GetValueOrDefault() != true) { dt.Rows.Add(obj.ID, obj.NumberHandover, obj.DateHandover, obj.CodeStation, obj.CodeStationFromTo, obj.StatusGoods, obj.StatusVehicle, obj.CreatedDate, obj.CreatedBy, obj.ModifiedDate, obj.ModifiedBy, obj.NumberReply, obj.DateReply, obj.NoteReply, obj.IsDeleted, obj.IsReplied, obj.Note, obj.Type, obj.ReplyStatusGoods, null); } } report.SetDataSource(dataset); FrmPreviewReport frmReport = new FrmPreviewReport(report); frmReport.MdiParent = this.MdiParent; frmReport.Show(); } catch (Exception ex) { } }