private void grdTrain_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex < 0) { return; } var handover = TrainFactory.FindHandoverByID(listHandOver[e.RowIndex].ID); var frm = new Train.frmBBBG(frmMainForm._userInfo, handover.Type, handover); frm.ShowDialog(); if (frm.DialogResult == DialogResult.OK) { search(); } }
private void InitData() { if (_handover == null) { return; } _handover = TrainFactory.FindHandoverByID(_handover.ID); txtNumberHandover.Text = _handover.NumberHandover; dtpHandover.Value = (DateTime)_handover.DateHandover; txtCodeCuaKhau.Text = _handover.CodeStation; ddlCuaKhau.SelectedValue = _handover.CodeStation; txtCodeGaDenDi.Text = _handover.CodeStationFromTo; ddlGaDenDi.SelectedValue = _handover.CodeStationFromTo; txtStatusGood.Text = _handover.StatusGoods; txtStatusVehicle.Text = _handover.StatusVehicle; //txtSoVanDon.Text = _handover.Ma_Chuyen_Tau; //txtSoVanDon.ReadOnly = true; cbReply.Checked = _handover.IsReplied.Value; if (cbReply.Checked) { dtpReplyDate.Enabled = true; dtpReplyDate.Value = _handover.DateReply.Value; txtReplyNote.Text = _handover.NoteReply; txtReplyNote.Enabled = true; txtReplyStatusGoods.Text = _handover.ReplyStatusGoods; txtReplyStatusGoods.Enabled = true; } else { dtpReplyDate.Enabled = false; txtReplyNote.Text = ""; txtReplyNote.Enabled = false; txtReplyStatusGoods.Enabled = false; txtReplyStatusGoods.Text = ""; } if (!_handover.tblHandoverResources.IsLoaded) { _handover.tblHandoverResources.Load(); } foreach (var resource in _handover.tblHandoverResources) { resource.tblToaTauReference.Load(); listToaTau.Add(resource.tblToaTau); } BindToaTau(null); }
private void grdHandover_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex != 1) { return; } var handover = TrainFactory.FindHandoverByID(listHandOver[e.RowIndex].ID); if (handover.IsReplied != true && handover.Type == "1") //neu chua duoc hoi bao, va la loai BBBG di { var dr = MessageBox.Show("Bạn có muốn hồi báo BBBG: " + handover.NumberHandover, "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dr == DialogResult.Yes) { handover.IsReplied = true; handover.DateReply = DateTime.Now; int update = TrainFactory.UpdateHandover(handover); if (update < 1) { MessageBox.Show("Thực hiện hồi báo không thành công, xin kiểm tra lại kết nối Cơ sở dữ liệu, hoặc BBBG này không còn tồn tại"); } else { search(); } } } //if (handover.tblChuyenTauReference.IsLoaded == false) //{ // handover.tblChuyenTauReference.Load(); //} //var frm = new Train.frmBBBG(frmMainForm._userInfo, (short)handover.tblChuyenTau.Type, handover); //frm.ShowDialog(); //if (frm.DialogResult == DialogResult.OK) //{ // search(); //} }
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 btnAddNew_Click(object sender, EventArgs e) { var dr = MessageBox.Show(ConstantInfo.CONFIRM_ADD_NEW, "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dr != DialogResult.Yes) { return; } try { if (!Validate()) { return; } var train = TrainFactory.GetByCode(txtSoVanDon.Text.Trim()); if (grdToaTau.RowCount == 0) { MessageBox.Show("Bạn phải chọn ít nhất một toa tàu!"); return; } Nullable <DateTime> replyDate = null; if (cbReply.Checked) { replyDate = dtpReplyDate.Value; } var handOver = new tblHandover { NumberHandover = txtNumberHandover.Text.Trim(), DateHandover = dtpHandover.Value, CodeStation = txtCodeCuaKhau.Text.Trim(), CodeStationFromTo = txtCodeGaDenDi.Text.Trim(), StatusGoods = txtStatusGood.Text.Trim(), StatusVehicle = txtStatusVehicle.Text.Trim(), CreatedBy = _userInfo.UserID, CreatedDate = CommonFactory.GetCurrentDate(), Type = _type.ToString(), IsReplied = cbReply.Checked, DateReply = replyDate, NoteReply = cbReply.Checked?txtReplyNote.Text:null, ReplyStatusGoods = cbReply.Checked ? txtReplyStatusGoods.Text : null, }; foreach (var toaTau in listToaTau) { var handOverResource = new tblHandoverResource { tblToaTau = toaTau }; handOver.tblHandoverResources.Add(handOverResource); } var result = TrainFactory.InsertBBBG(handOver, _NumberGenerate); if (result > 0) { if (cbPrint.Checked == true) { MessageBox.Show("Thêm mới Biên bản bàn giao thành công. Bạn hãy tắt hộp thoại này để xem bản in"); _handover = TrainFactory.FindHandoverByID(handOver.ID); printBBBG(); Reset(); } else { MessageBox.Show("Thêm mới Biên bản bàn giao thành công!"); Reset(); } } else { MessageBox.Show("Thêm mới Biên bản bàn không thành công!"); } } catch (Exception ex) { if (GlobalInfo.IsDebug) { MessageBox.Show(ex.ToString()); } } }