private void btnLayDuLieuPhat_Click(object sender, EventArgs e) { daCauHinh dCH = new daCauHinh(); dCH.Lay((int)daCauHinh.eCauHinh.Là_Bưu_cục_Phát); if (dCH.CauHinh == null) { MessageBox.Show("Bưu cục này không phải là Bưu cục phát"); return; } else { if (dCH.CauHinh.GiaTri != "True") { MessageBox.Show("Bưu cục này không phải là Bưu cục phát"); return; } } pgb.Value = 0; pgb.Maximum = 100; lblThongTin.Text = "Lấy dữ liệu Phát ....."; SoLieuDiPhat.Ngay = txtTuNgay.Value; Thread BackThread = new Thread( new ThreadStart(() => { DocVaGhiDuLieuDen(); DocVaGhiDuLieuPhanHuongBTa(); DocVaGhiDuLieuChuyenHoan(); DocVaGhiDuLieuChuyenTiep(); })); BackThread.Start(); }
private void notifyIcon1_MouseDoubleClick(object sender, MouseEventArgs e) { daCauHinh dCH = new daCauHinh(); dCH.Lay((int)daCauHinh.eCauHinh.Là_Bưu_cục_Phát); if (dCH.CauHinh != null) { if (dCH.CauHinh.GiaTri == "True" || dCH.CauHinh.GiaTri == "1") { frmQuanLyTienCOD csQLTienCOD = new frmQuanLyTienCOD(); dCH.Lay((int)daCauHinh.eCauHinh.Mã_Bưu_Cục); if (dCH.CauHinh != null) { csQLTienCOD.MaBuuCuc = dCH.CauHinh.GiaTri; } csQLTienCOD.Show(); } else { frmBaoCao csBaoCao1 = new frmBaoCao(); csBaoCao1.Show(); } } else { frmBaoCao csBaoCao = new frmBaoCao(); csBaoCao.Show(); } }
private void btnTongHop_Click(object sender, EventArgs e) { Cursor = Cursors.WaitCursor; daData dDTa = new daData(); daCauHinh dCH = new daCauHinh(); dCH.Lay((int)daCauHinh.eCauHinh.Mã_Bưu_Cục); if (dCH.CauHinh != null) { dDTa.MaBuuCuc = dCH.CauHinh.GiaTri; } else { Cursor = Cursors.Default; MessageBox.Show("Tham số Mã Bưu cục chưa được khai báo"); return; } dDTa.Ngay = txtNgay.Value;//DateTime.Now; dDTa.LayDuLieu(); dDTa.TongHopDuLieu(); Cursor = Cursors.Default; MessageBox.Show("Đã Tổng hợp dữ liệu ngày hôm nay thành công!"); }
private void button2_Click(object sender, EventArgs e) { daCauHinh dCH = new daCauHinh(); dCH.Lay((int)daCauHinh.eCauHinh.Là_Bưu_cục_Phát); if (dCH.CauHinh != null) { if (dCH.CauHinh.GiaTri == "True" || dCH.CauHinh.GiaTri == "1") { MessageBox.Show("Đây là Bưu cục phát. Anh/chị phải sử dụng chức năng lấy dữ liệu phát"); return; } } //Lay BCCP pgb.Value = 0; pgb.Maximum = 100; lblThongTin.Text = "Lấy dữ liệu BCCP ....."; Thread BackThread = new Thread( new ThreadStart(() => { DocVaGhiDuLieuBCCP(); //MessageBox.Show("Lay BCCP xong"); })); BackThread.Start(); }
private void cboThamSo_SelectedValueChanged(object sender, EventArgs e) { if (cboThamSo.SelectedValue == null) { IDCauHinh = 0; MaThamSo = ""; txtGiaTri.Text = ""; } else { daCauHinh dCH = new daCauHinh(); MaThamSo = dCH.TimMaThamSo(int.Parse(cboThamSo.SelectedValue.ToString())); dCH.Lay(MaThamSo); if (dCH.CauHinh != null) { IDCauHinh = dCH.CauHinh.ID; txtGiaTri.Text = dCH.CauHinh.GiaTri; } else { IDCauHinh = 0; txtGiaTri.Text = ""; } } }
public void KhoiTaoDanhSachChon() { daCauHinh dCH = new daCauHinh(); cboThamSo.DisplayMember = "GiaTri"; cboThamSo.ValueMember = "ID"; cboThamSo.DataSource = dCH.lstBangThamSo; }
private void mnuitemSoLieuPhat_Click(object sender, EventArgs e) { frmQuanLyTienCOD csQLCOD = new frmQuanLyTienCOD(); daCauHinh dCH = new daCauHinh(); dCH.Lay((int)daCauHinh.eCauHinh.Mã_Bưu_Cục); if (dCH.CauHinh != null) { csQLCOD.MaBuuCuc = dCH.CauHinh.GiaTri; } csQLCOD.Show(); }
public void Xoa() { daThongTinMay dTTM = new daThongTinMay(); daPhatHanhPayPost dPHPP = new daPhatHanhPayPost(); daCauHinh dCH = new daCauHinh(); dCH.Lay(dCH.TimMaThamSo((int)daCauHinh.eCauHinh.Mã_Bưu_Cục)); if (dCH.CauHinh != null) { dPHPP.PaPo.MaBuuCuc = dCH.CauHinh.GiaTri; } dPHPP.PaPo.MAC = dTTM.MAC; dPHPP.Xoa(); }
private void btnCapNhat_Click(object sender, EventArgs e) { daCauHinh dCH = new daCauHinh(); dCH.CauHinh.GiaTri = txtGiaTri.Text.Trim(); if (dCH.CauHinh.GiaTri != "" && MaThamSo != "") { dCH.CauHinh.ID = IDCauHinh; dCH.CauHinh.Ma = MaThamSo; dCH.Them(); MessageBox.Show("Cập nhật thành công tham số " + cboThamSo.SelectedText); } else { MessageBox.Show("Không đủ dữ liệu để cập nhật tham số"); } }
public sp_LayThongTinBuuCucResult LayDvi() { string rMaBuuCuc = ""; daCauHinh dCH = new daCauHinh(); dCH.Lay(dCH.TimMaThamSo((int)daCauHinh.eCauHinh.Mã_Bưu_Cục)); if (dCH.CauHinh != null) { rMaBuuCuc = dCH.CauHinh.GiaTri; } daClient dC = new daClient(); dC.Tao(); var db = new LiteDatabase(dC.TenFileNVPP); var col = db.GetCollection <sp_LayThongTinBuuCucResult>(dC.BangDanhMucDVi); return(col.FindOne(x => x.MaBuuCuc == rMaBuuCuc)); }
public void LayDanhMucDVi() { string rMaBuuCuc = ""; daCauHinh dCH = new daCauHinh(); dCH.Lay(dCH.TimMaThamSo((int)daCauHinh.eCauHinh.Mã_Bưu_Cục)); if (dCH.CauHinh != null) { rMaBuuCuc = dCH.CauHinh.GiaTri; daBuuCuc dBC = new daBuuCuc(); daClient dC = new daClient(); dC.Tao(); var db = new LiteDatabase(dC.TenFileNVPP); var col = db.GetCollection <sp_LayThongTinBuuCucResult>(dC.BangDanhMucDVi); dBC.BC.MaBuuCuc = rMaBuuCuc; if (dBC.ThongTin() != null) { col.Insert(1, dBC.BC); } } }
public frmTheoDoi() { InitializeComponent(); DayDuLieuPayPost.Day += new daDayPaypost.DayHandler(DayDuLieuPayPost_Day); DocDuLieuPayPost.Ghi += new daDocDuLieuPayPost.GhiHandler(DocDuLieuPayPost_Ghi); DayDuLieuPayPost.DayXong += new daDayPaypost.DayXongHandler(DayDuLieuPayPost_DayXong); DayBCCP.Day += new daDayBCCP.DayHandler(DayBCCP_Day); DocDuLieuBCCP.Luu += new daDocDuLieuBCCP.LuuDuLieuHandler(DocDuLieuBCCP_Luu); DocDuLieuBCCP.KetThucLuu += new daDocDuLieuBCCP.KetThucLuuDuLieuHandler(DocDuLieuBCCP_KetThucLuu); DayBCCP.DayXong += new daDayBCCP.DayXongHandler(DayBCCP_DayXong); SoLieuDiPhat.Luu += new daSoLieuNhanVe.LuuHandler(SoLieuDiPhat_Luu); SoLieuDiPhat.LuuXong += new daSoLieuNhanVe.LuuXongHandler(SoLieuDiPhat_LuuXong); string _tg = System.Configuration.ConfigurationManager.AppSettings["ThoiGianChay"].ToString(); tmrChay.Interval = int.Parse(_tg) * 60 * 1000; tmrChay.Enabled = true; tmrChayHomTruoc.Interval = 35 * 60 * 1000; tmrChayHomTruoc.Enabled = true; daCauHinh dCH = new daCauHinh(); dCH.Lay((int)daCauHinh.eCauHinh.Là_Bưu_cục_Phát); if (dCH.CauHinh != null) { if (dCH.CauHinh.GiaTri == "True" || dCH.CauHinh.GiaTri == "1") { tmrChayPhat.Interval = 60 * 60 * 1000; tmrChayPhat.Enabled = true; } else { tmrLayBCCP.Interval = 20 * 60 * 1000; tmrLayBCCP.Enabled = true; } } else { tmrLayBCCP.Interval = 20 * 60 * 1000; tmrLayBCCP.Enabled = true; } /*daCauHinh dCH = new daCauHinh(); * //Lay thoi gian thu gom * * dCH.Lay((int)daCauHinh.eCauHinh.Giờ_Thu_Gom_Lần1); * if (dCH.CauHinh != null) * { * GioThuGom1 = TimeSpan.Parse(dCH.CauHinh.GiaTri); * tmrThuGom1.Interval = 60 * 1000; * tmrThuGom1.Enabled = true; * } * * dCH.Lay((int)daCauHinh.eCauHinh.Giờ_Thu_Gom_Lần2); * if (dCH.CauHinh != null) * { * GioThuGom2 = TimeSpan.Parse(dCH.CauHinh.GiaTri); * tmrThuGom2.Interval = 60 * 1000; * tmrThuGom2.Enabled = true; * } * * dCH.Lay((int)daCauHinh.eCauHinh.Giờ_Thu_Gom_Lần2); * if (dCH.CauHinh != null) * { * GioThuGom2 = TimeSpan.Parse(dCH.CauHinh.GiaTri); * tmrThuGom2.Interval = 60 * 1000; * tmrThuGom2.Enabled = true; * }*/ //====================== }
public void Chay() { clsLan ptLog = new clsLan(); ptLog.ThoiGianBatDau = DateTime.Now; daCauHinh dCH = new daCauHinh(); dCH.Lay(dCH.TimMaThamSo((int)daCauHinh.eCauHinh.Mã_Bưu_Cục)); if (dCH.CauHinh != null) { ptLog.MaBuuCuc = dCH.CauHinh.GiaTri; } daThongTinMay dTTM = new daThongTinMay(); ptLog.MAC = dTTM.MAC; ptLog.DiaChiIP = dTTM.DiaChiIP; daPhatHanhPayPost dPHPP = new daPhatHanhPayPost(); daDuLieuPayPost dPP = new daDuLieuPayPost(); List <clsDuLieuPP> lstTruyen = new List <clsDuLieuPP>(); lstTruyen = dPP.LayDanhSachChuaTruyen(); ptLog.SoLuong = 0; ptLog.TongTien = 0; dPHPP.PaPo.MaBuuCuc = ptLog.MaBuuCuc; //dPHPP.Xoa(); foreach (clsDuLieuPP ptPP in lstTruyen) { dPHPP.PaPo.NgayPhatHanh = ptPP.NgayPhatHanh; dPHPP.PaPo.MAC = dTTM.MAC; dPHPP.PaPo.TranTime = ptPP.TranTime; dPHPP.PaPo.TranCat = ptPP.TranCat; dPHPP.PaPo.InvokedFrom = ptPP.InvokedFrom; dPHPP.PaPo.TranID = ptPP.TranID; dPHPP.PaPo.PAC = ptPP.PAC; dPHPP.PaPo.AccountID = ptPP.AccountID; dPHPP.PaPo.TranAmount = ptPP.TranAmount; dPHPP.PaPo.SenderName = ptPP.SenderName; dPHPP.PaPo.AddInfo1 = ptPP.AddInfo1; dPHPP.PaPo.AddInfo2 = ptPP.AddInfo2; dPHPP.PaPo.AddInfo3 = ptPP.AddInfo3; dPHPP.PaPo.AddInfo4 = ptPP.AddInfo4; dPHPP.PaPo.AddInfo5 = ptPP.AddInfo5; dPHPP.PaPo.AddInfo6 = ptPP.AddInfo6; dPHPP.PaPo.AddInfo7 = ptPP.AddInfo7; dPHPP.PaPo.AddInfo8 = ptPP.AddInfo8; dPHPP.PaPo.Fee = ptPP.Fee; dPHPP.PaPo.Add_Info_Fee_01 = ptPP.Add_Info_Fee_01; dPHPP.PaPo.Add_Info_Fee_02 = ptPP.Add_Info_Fee_02; dPHPP.PaPo.Add_Info_Fee_03 = ptPP.Add_Info_Fee_03; dPHPP.PaPo.Add_Info_Fee_04 = ptPP.Add_Info_Fee_04; dPHPP.PaPo.Add_Info_Fee_05 = ptPP.Add_Info_Fee_05; dPHPP.Them(); //Danh dau da truyen ptPP.DaTruyen = true; dPP.Them(ptPP); ptLog.SoLuong = ptLog.SoLuong + 1; ptLog.TongTien = ptLog.TongTien.Value + Convert.ToDecimal(ptPP.TranAmount.Value); Day(ptPP, null); } daLogLanLayDuLieu dLog = new daLogLanLayDuLieu(); ptLog.DichVu = "PayPost"; ptLog.ThoiGianKetThuc = DateTime.Now; dLog.Them(ptLog); if (ptLog.SoLuong != 0) { daLanLayDuLieu dLan = new daLanLayDuLieu(); dLan.LanLay.MaBuuCuc = ptLog.MaBuuCuc; dLan.LanLay.MAC = ptLog.MAC; dLan.LanLay.DiaChiIP = ptLog.DiaChiIP; dLan.LanLay.DichVu = ptLog.DichVu; dLan.LanLay.SoLuong = ptLog.SoLuong; dLan.LanLay.TongTien = ptLog.TongTien; dLan.LanLay.ThoiGianBatDau = ptLog.ThoiGianBatDau; dLan.LanLay.ThoiGianKetThuc = ptLog.ThoiGianKetThuc; dLan.Them(); } DayXong(null, null); }
private void listBox1_SelectedValueChanged(object sender, EventArgs e) { if (!LoadForm) { Cursor = Cursors.WaitCursor; daCauHinh dCH = new daCauHinh(); DateTime _ngay = DateTime.Now; _ngay = txtNgay.Value; daData dDTa = new daData(); dCH.Lay((int)daCauHinh.eCauHinh.Mã_Bưu_Cục); if (dCH.CauHinh != null) { dDTa.MaBuuCuc = dCH.CauHinh.GiaTri; } else { Cursor = Cursors.Default; MessageBox.Show("Tham số Mã Bưu cục chưa được khai báo"); return; } if (splitContainer1.Panel2.Controls.Count > 0) { splitContainer1.Panel2.Controls.RemoveAt(0); } dDTa.DenNgay = _ngay; int _IDBaoCao = 0; try { _IDBaoCao = (int)listBox1.SelectedValue; } catch { MessageBox.Show("Xin hãy chọn vào một biểu báo cáo"); return; } switch (_IDBaoCao) { case 1: dDTa.TuNgay = DateTime.Parse(_ngay.Month.ToString() + "/01/" + _ngay.Year.ToString()); bcTien.lstTien = dDTa.lstTien(); bcTien.HienThiDuLieu(); bcTien.Dock = DockStyle.Fill; splitContainer1.Panel2.Controls.Add(bcTien); break; case 2: dDTa.TuNgay = _ngay; bcBCCP.lstGN = dDTa.lstKinhDoanhGhiNo(); bcBCCP.HienThiDuLieuGhiNo(); bcBCCP.Dock = DockStyle.Fill; splitContainer1.Panel2.Controls.Add(bcBCCP); break; case 3: dDTa.TuNgay = _ngay; bcBCCP.lstTM = dDTa.lstKinhDoanhTiemMat(); bcBCCP.HienThiDuLieuTienMat(); bcBCCP.Dock = DockStyle.Fill; splitContainer1.Panel2.Controls.Add(bcBCCP); break; case 4: dDTa.TuNgay = _ngay; bcBCCP.lstKH = dDTa.lstKinhDoanhGhiNoKhachHang(); bcBCCP.HienThiDuLieuGhiNoKhachHang(); bcBCCP.Dock = DockStyle.Fill; splitContainer1.Panel2.Controls.Add(bcBCCP); break; case 5: dDTa.TuNgay = _ngay; bcTaiChinh.lstTC = dDTa.lstTaiChinhTapChung(); bcTaiChinh.HienThiDuLieu(); bcTaiChinh.Dock = DockStyle.Fill; splitContainer1.Panel2.Controls.Add(bcTaiChinh); break; } Cursor = Cursors.Default; } }
public void Chay() { daCauHinh dCH = new daCauHinh(); dCH.Lay(dCH.TimMaThamSo((int)daCauHinh.eCauHinh.Lấy_BCCP)); bool _LayBCCP = false; if (dCH.CauHinh != null) { try { _LayBCCP = bool.Parse(dCH.CauHinh.GiaTri); } catch { } } if (!_LayBCCP) { //May nay khong lay BCCP return; } clsLan ptLog = new clsLan(); ptLog.ThoiGianBatDau = DateTime.Now; dCH.Lay(dCH.TimMaThamSo((int)daCauHinh.eCauHinh.Mã_Bưu_Cục)); if (dCH.CauHinh != null) { ptLog.MaBuuCuc = dCH.CauHinh.GiaTri; } daThongTinMay dTTM = new daThongTinMay(); ptLog.MAC = dTTM.MAC; ptLog.DiaChiIP = dTTM.DiaChiIP; daPhatHanhBCCP dPHBCCP = new daPhatHanhBCCP(); daDuLieuBCCP dBCCP = new daDuLieuBCCP(); List <clsDuLieuBCCP> lstTruyen = new List <clsDuLieuBCCP>(); lstTruyen = dBCCP.LayDanhSachChuaTruyen(); foreach (clsDuLieuBCCP ptBCCP in lstTruyen) { dPHBCCP.PH.MaBuuCuc = ptLog.MaBuuCuc; dPHBCCP.PH.NgayPhatHanh = ptBCCP.NgayPhatHanh; dPHBCCP.PH.MAC = ptBCCP.MAC; dPHBCCP.PH.SoHieu = ptBCCP.SoHieu; dPHBCCP.PH.MaDichVu = ptBCCP.MaDichVu; dPHBCCP.PH.TenDichVu = ptBCCP.TenDichVu; dPHBCCP.PH.LoaiBuuGui = ptBCCP.LoaiBuuGui; dPHBCCP.PH.SoChuyen = ptBCCP.SoChuyen; dPHBCCP.PH.SoTui = ptBCCP.SoTui; dPHBCCP.PH.MaDuongThu = ptBCCP.MaDuongThu; dPHBCCP.PH.MaBuuCucChapNhan = ptBCCP.MaBuuCucChapNhan; dPHBCCP.PH.NgayGioChapNhan = ptBCCP.NgayGioChapNhan; dPHBCCP.PH.MaBuuCucDong = ptBCCP.MaBuuCucDong; dPHBCCP.PH.NgayGioDong = ptBCCP.NgayGioDong; dPHBCCP.PH.TrongLuong = ptBCCP.TrongLuong; dPHBCCP.PH.TrongLuongQuiDoi = ptBCCP.TrongLuongQuiDoi; dPHBCCP.PH.MaTinhPhat = ptBCCP.MaTinhPhat; dPHBCCP.PH.MaNuocPhat = ptBCCP.MaNuocPhat; dPHBCCP.PH.MaKhachHang = ptBCCP.MaKhachHang; dPHBCCP.PH.TenKhachHang = ptBCCP.TenKhachHang; dPHBCCP.PH.DiaChiKhachHang = ptBCCP.DiaChiKhachHang; dPHBCCP.PH.TenNguoiNhan = ptBCCP.TenNguoiNhan; dPHBCCP.PH.DiaChiNguoiNhan = ptBCCP.DiaChiNguoiNhan; dPHBCCP.PH.CuocChinh = ptBCCP.CuocChinh; dPHBCCP.PH.PhuPhiXD = ptBCCP.PhuPhiXD; dPHBCCP.PH.PhuPhiVX = ptBCCP.PhuPhiVX; dPHBCCP.PH.CuocCongThem = ptBCCP.CuocCongThem; dPHBCCP.PH.DichVuCongThem = ptBCCP.DichVuCongThem; dPHBCCP.PH.SoTienCOD = ptBCCP.SoTienCOD; dPHBCCP.PH.CuocCOD = ptBCCP.CuocCOD; dPHBCCP.PH.VAT = ptBCCP.VAT; dPHBCCP.PH.CuocCODVAT = ptBCCP.CuocCODVAT; dPHBCCP.PH.ThanhTien = ptBCCP.ThanhTien; dPHBCCP.PH.TongCuoc = ptBCCP.TongCuoc; dPHBCCP.PH.GhiNo = ptBCCP.GhiNo; dPHBCCP.PH.NoiDungBuuGui = ptBCCP.NoiDungBuuGui; dPHBCCP.PH.GuiLo = ptBCCP.GuiLo; dPHBCCP.PH.SoLo = ptBCCP.SoLo; dPHBCCP.ThemPH(); //Danh dau da truyen ptBCCP.DaTruyen = true; dBCCP.CapNhat(ptBCCP); Day(ptBCCP, null); } ptLog.SoLuong = lstTruyen.Count; daLogLanLayDuLieu dLog = new daLogLanLayDuLieu(); ptLog.DichVu = "BCCP"; ptLog.ThoiGianKetThuc = DateTime.Now; dLog.Them(ptLog); if (ptLog.SoLuong != 0) { daLanLayDuLieu dLan = new daLanLayDuLieu(); dLan.LanLay.MaBuuCuc = ptLog.MaBuuCuc; dLan.LanLay.MAC = ptLog.MAC; dLan.LanLay.DiaChiIP = ptLog.DiaChiIP; dLan.LanLay.DichVu = ptLog.DichVu; dLan.LanLay.SoLuong = ptLog.SoLuong; dLan.LanLay.TongTien = ptLog.TongTien; dLan.LanLay.ThoiGianBatDau = ptLog.ThoiGianBatDau; dLan.LanLay.ThoiGianKetThuc = ptLog.ThoiGianKetThuc; dCH.Lay(dCH.TimMaThamSo((int)daCauHinh.eCauHinh._Chuỗi_Kết_nối_Chạy)); if (dCH.CauHinh != null) { dLan.LanLay.ChuoiKetNoi = dCH.CauHinh.GiaTri; } dLan.LanLay.ChuoiKetNoi = ""; dLan.Them(); } try { DayXong(null, null); } catch { } }