private void btnTimKiem_Click(object sender, EventArgs e) { SplashScreenManager.ShowForm(typeof(O2S_Common.Utilities.ThongBao.WaitForm_Wait)); try { PhieuThuFilter _filter = new PhieuThuFilter(); _filter.CoSoId = GlobalSettings.CoSoId; _filter.ThoiGianThu_Tu = date_TuNgay.DateTime; _filter.ThoiGianThu_Den = date_DenNgay.DateTime; this.lstPhieuThu = PhieuThuLogic.SelectBaoCaoThuTienChiTiet(_filter); if (this.lstPhieuThu != null && this.lstPhieuThu.Count > 0) { gridControlDSPhieuGhiDanh.DataSource = this.lstPhieuThu; } else { gridControlDSPhieuGhiDanh.DataSource = null; } } catch (Exception ex) { O2S_Common.Logging.LogSystem.Error(ex); } SplashScreenManager.CloseForm(); }
private void repositoryItemButton_Huy_Click(object sender, EventArgs e) { try { var rowHandle = gridViewPhieuThu.FocusedRowHandle; if (gridViewPhieuThu.GetRowCellValue(rowHandle, "IsRemove").ToString() != "1") { int _PhieuThuId = O2S_Common.TypeConvert.Parse.ToInt32(gridViewPhieuThu.GetRowCellValue(rowHandle, "PhieuThuId").ToString()); frmPopUpHuyPhieuThuTien _frm = new frmPopUpHuyPhieuThuTien(_PhieuThuId); _frm.ShowDialog(); // LoadDanhSachHocVien(); gridViewDSHocVien_Click(null, null); PhieuThuFilter _filter = new PhieuThuFilter(); _filter.HocVienId = this.HocVienId_Select; _filter.PhieuGhiDanhId = this.PhieuGhiDanhId_Select; LoadDanhSachPhieuThu(_filter); } } catch (Exception ex) { O2S_Common.Logging.LogSystem.Error(ex); } }
public static List <BaoCaoThuTien_TongHopDTO> SelectBaoCaoThuTienTongHop(PhieuThuFilter _filter) { try { var query = (from p in GlobalSettings.Database.PHIEUTHUs where (p.ThoiGianThu >= _filter.ThoiGianThu_Tu && p.ThoiGianThu <= _filter.ThoiGianThu_Den) && p.HOCVIEN.CoSoId == _filter.CoSoId group p by new { p.ThoiGianThu, p.CreatedBy, } into phieuthu select new BaoCaoThuTien_TongHopDTO { ThoiGianThu = phieuthu.Key.ThoiGianThu, TenNguoiThu = (from tk in Database.TAIKHOANs join nv in Database.NHANVIENs on tk.TaiKhoanId equals nv.TaiKhoanId where tk.TenDangNhap == phieuthu.Key.CreatedBy select nv.TenNhanVien).FirstOrDefault(), SoTien = phieuthu.Sum(o => o.SoTien), }); return(query.ToList()); } catch (System.Exception ex) { return(null); O2S_Common.Logging.LogSystem.Error(ex); } }
public static List <BaoCaoThuTien_ChiTietDTO> SelectBaoCaoThuTienChiTiet(PhieuThuFilter _filter) { try { var query = (from p in GlobalSettings.Database.PHIEUTHUs where (p.ThoiGianThu >= _filter.ThoiGianThu_Tu && p.ThoiGianThu <= _filter.ThoiGianThu_Den) && p.CoSoId == _filter.CoSoId select p).AsEnumerable().Select((obj, index) => new BaoCaoThuTien_ChiTietDTO { Stt = index + 1, MaPhieuThu = obj.MaPhieuThu, ThoiGianThu = obj.ThoiGianThu, SoTien = obj.SoTien, TenNguoiThu = (from tk in Database.TAIKHOANs join nv in Database.NHANVIENs on tk.TaiKhoanId equals nv.TaiKhoanId where tk.TenDangNhap == obj.CreatedBy select nv.TenNhanVien).FirstOrDefault(), MaPhieuGhiDanh = obj.PHIEUGHIDANH.MaPhieuGhiDanh, MaHocVien = obj.HOCVIEN.MaHocVien, TenHocVien = obj.HOCVIEN.TenHocVien, GioiTinh = obj.HOCVIEN.GioiTinh, NgaySinh = obj.HOCVIEN.NgaySinh, GhiChu = obj.GhiChu }); return(query.ToList()); } catch (System.Exception ex) { return(null); O2S_Common.Logging.LogSystem.Error(ex); } }
private void LoadDanhSachPhieuThu(PhieuThuFilter _filter) { try { gridControlPhieuThu.DataSource = PhieuThuLogic.Select(_filter); } catch (Exception ex) { O2S_Common.Logging.LogSystem.Error(ex); } }
public static List <PhieuThu_PlusDTO> Select(PhieuThuFilter _filter) { try { var query = (from p in GlobalSettings.Database.PHIEUTHUs //where p.HocVienId==_filter.HocVienId select p).AsEnumerable().Select((obj, index) => new PhieuThu_PlusDTO { Stt = index + 1, PhieuThuId = obj.PhieuThuId, MaPhieuThu = obj.MaPhieuThu, SoThuId = obj.SoThuId, PhieuGhiDanhId = obj.PhieuGhiDanhId, HocVienId = obj.HocVienId, TenHocVien = obj.HOCVIEN.TenHocVien, LoaiPhieuThuId = obj.LoaiPhieuThuId, SoTien = obj.SoTien, ThoiGianThu = obj.ThoiGianThu, NoiDung = obj.NoiDung, GhiChu = obj.GhiChu, IsRemove = obj.IsRemove ?? 0, LyDoHuy = obj.LyDoHuy, NguoiHuy = obj.NguoiHuy, ThoiGianHuy = obj.ThoiGianHuy, CreatedDate = obj.CreatedDate, CreatedBy = obj.CreatedBy, CreatedLog = obj.CreatedLog, ModifiedDate = obj.ModifiedDate, ModifiedBy = obj.ModifiedBy, ModifiedLog = obj.ModifiedLog, }); if (_filter.PhieuThuId != null && _filter.PhieuThuId != 0) { query = query.Where(o => o.PhieuThuId == _filter.PhieuThuId).ToList(); } if (_filter.HocVienId != null && _filter.HocVienId != 0) { query = query.Where(o => o.HocVienId == _filter.HocVienId).ToList(); } if (_filter.PhieuGhiDanhId != null && _filter.PhieuGhiDanhId != 0) { query = query.Where(o => o.PhieuGhiDanhId == _filter.PhieuGhiDanhId).ToList(); } return(query.ToList()); } catch (System.Exception ex) { return(null); O2S_Common.Logging.LogSystem.Error(ex); } }
private void gridViewDSHocVien_Click(object sender, EventArgs e) { try { var rowHandle = gridViewDSHocVien.FocusedRowHandle; this.HocVienId_Select = O2S_Common.TypeConvert.Parse.ToInt32(gridViewDSHocVien.GetRowCellValue(rowHandle, "HocVienId").ToString()); this.PhieuGhiDanhId_Select = O2S_Common.TypeConvert.Parse.ToInt32(gridViewDSHocVien.GetRowCellValue(rowHandle, "PhieuGhiDanhId").ToString()); PHIEUGHIDANH _phieugd = PhieuGhiDanhLogic.SelectSingle(this.PhieuGhiDanhId_Select); lblMaHocVien.Text = _phieugd.HOCVIEN.MaHocVien; lblTenHocVien.Text = _phieugd.HOCVIEN.TenHocVien; lblHocPhi.Text = O2S_Common.Number.Convert.NumberToString(O2S_Common.TypeConvert.Parse.ToDecimal(_phieugd.TongTien.ToString()), 0); lblDaDong.Text = O2S_Common.Number.Convert.NumberToString(O2S_Common.TypeConvert.Parse.ToDecimal(_phieugd.DaDong.ToString()), 0); lblConNo.Text = O2S_Common.Number.Convert.NumberToString(O2S_Common.TypeConvert.Parse.ToDecimal(_phieugd.ConNo.ToString()), 0); lblMienGiam_Tien.Text = O2S_Common.Number.Convert.NumberToString(O2S_Common.TypeConvert.Parse.ToDecimal(_phieugd.MienGiam_Tien.ToString()), 0); numDaDong.Text = _phieugd.ConNo.ToString(); //Load danh sach phieu thu PhieuThuFilter _filter = new PhieuThuFilter(); _filter.HocVienId = this.HocVienId_Select; _filter.PhieuGhiDanhId = this.PhieuGhiDanhId_Select; LoadDanhSachPhieuThu(_filter); //Load dot hoc theo lop hoc if (_phieugd.LopHocId != null && _phieugd.LopHocId != 0) { cboDotHoc.DataSource = DotHocLogic.SelectDotHocChucDongTien(_phieugd.LopHocId ?? 0, this.PhieuGhiDanhId_Select); cboDotHoc.DisplayMember = "TenDotHoc"; cboDotHoc.ValueMember = "DotHocId"; } else { cboDotHoc.DataSource = null; cboDotHoc.DisplayMember = "TenDotHoc"; cboDotHoc.ValueMember = "DotHocId"; } btnInBienLai.Enabled = false; //if (_phieugd.ConNo == 0) //{ // btnLuuLai.Enabled = false; // numDaDong.ReadOnly = true; //} //else //{ // btnLuuLai.Enabled = true; // numDaDong.ReadOnly = false; //} } catch (Exception ex) { O2S_Common.Logging.LogSystem.Error(ex); } }
private void btnLuuLai_Click(object sender, EventArgs e) { try { ValidateLuu(); //Update PHIEUGHIDANH PHIEUGHIDANH _phieughidanh = PhieuGhiDanhLogic.SelectSingle(this.PhieuGhiDanhId_Select); _phieughidanh.DaDong = _phieughidanh.DaDong + O2S_Common.TypeConvert.Parse.ToDecimal(numNopThem.Text); decimal _mienggiam = _phieughidanh.MienGiam_Tien ?? 0; _phieughidanh.ConNo = _phieughidanh.TongTien - _phieughidanh.DaDong - _mienggiam; //Insert Phieu Thu var rowHandle = gridViewDSHocVien.FocusedRowHandle; PHIEUTHU _phieuthu = new PHIEUTHU(); _phieuthu.CoSoId = GlobalSettings.CoSoId; _phieuthu.PhieuGhiDanhId = this.PhieuGhiDanhId_Select; _phieuthu.HocVienId = this.HocVienId_Select; _phieuthu.ThoiGianThu = DateTime.Now; _phieuthu.SoTien = O2S_Common.TypeConvert.Parse.ToDecimal(numNopThem.Text); _phieuthu.GhiChu = "";//gridViewDSHocVien.GetRowCellValue(rowHandle, "TenKhoaHoc").ToString(); if (PhieuGhiDanhLogic.InsertQLHocPhi(_phieughidanh, _phieuthu, ref this.PhieuThu_Insert)) { O2S_Common.Utilities.ThongBao.frmThongBao frmthongbao = new O2S_Common.Utilities.ThongBao.frmThongBao(Base.ThongBaoLable.LUU_THANH_CONG); frmthongbao.Show(); // LoadDanhSachHocVien(); gridViewDSHocVien_Click(null, null); PhieuThuFilter _filter = new PhieuThuFilter(); _filter.HocVienId = this.HocVienId_Select; _filter.PhieuGhiDanhId = this.PhieuGhiDanhId_Select; LoadDanhSachPhieuThu(_filter); btnInBienLai.Enabled = true; } } catch (ArgumentException ex) { MessageBox.Show(ex.Message, "Cảnh báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); } catch (Exception ex) { O2S_Common.Logging.LogSystem.Error(ex); } }
private void gridViewDSHocVien_Click(object sender, EventArgs e) { try { var rowHandle = gridViewDSHocVien.FocusedRowHandle; this.HocVienId_Select = O2S_Common.TypeConvert.Parse.ToInt32(gridViewDSHocVien.GetRowCellValue(rowHandle, "HocVienId").ToString()); this.PhieuGhiDanhId_Select = O2S_Common.TypeConvert.Parse.ToInt32(gridViewDSHocVien.GetRowCellValue(rowHandle, "PhieuGhiDanhId").ToString()); PHIEUGHIDANH _phieugd = PhieuGhiDanhLogic.SelectSingle(this.PhieuGhiDanhId_Select); lblMaHocVien.Text = _phieugd.HOCVIEN.MaHocVien; lblTenHocVien.Text = _phieugd.HOCVIEN.TenHocVien; lblHocPhi.Text = O2S_Common.Number.Convert.NumberToString(O2S_Common.TypeConvert.Parse.ToDecimal(_phieugd.TongTien.ToString()), 0); lblDaDong.Text = O2S_Common.Number.Convert.NumberToString(O2S_Common.TypeConvert.Parse.ToDecimal(_phieugd.DaDong.ToString()), 0); lblConNo.Text = O2S_Common.Number.Convert.NumberToString(O2S_Common.TypeConvert.Parse.ToDecimal(_phieugd.ConNo.ToString()), 0); lblMienGiam_Tien.Text = O2S_Common.Number.Convert.NumberToString(O2S_Common.TypeConvert.Parse.ToDecimal(_phieugd.MienGiam_Tien.ToString()), 0); numNopThem.Text = _phieugd.ConNo.ToString(); //Load danh sach phieu thu PhieuThuFilter _filter = new PhieuThuFilter(); _filter.HocVienId = this.HocVienId_Select; _filter.PhieuGhiDanhId = this.PhieuGhiDanhId_Select; LoadDanhSachPhieuThu(_filter); btnInBienLai.Enabled = false; if (_phieugd.ConNo == 0) { btnLuuLai.Enabled = false; numNopThem.ReadOnly = true; } else { btnLuuLai.Enabled = true; numNopThem.ReadOnly = false; } } catch (Exception ex) { O2S_Common.Logging.LogSystem.Error(ex); } }
private void btnLuuLai_Click(object sender, EventArgs e) { try { ValidateLuu(); //Update PHIEUGHIDANH: dadong PHIEUGHIDANH _phieughidanh = PhieuGhiDanhLogic.SelectSingle(this.PhieuGhiDanhId_Select); _phieughidanh.DaDong = _phieughidanh.DaDong + O2S_Common.TypeConvert.Parse.ToDecimal(numDaDong.Text); // _phieughidanh.SoTietKH = _phieughidanh.SoTietKH + O2S_Common.TypeConvert.Parse.ToDecimal(numSoTietHoc.Text);//so tiet tren dot hoc da chon _phieughidanh.HocPhiKH = _phieughidanh.HocPhiKH + O2S_Common.TypeConvert.Parse.ToDecimal(numHocPhi.Text); _phieughidanh.HocPhiHocVienKH = _phieughidanh.HocPhiHocVienKH + O2S_Common.TypeConvert.Parse.ToDecimal(numTongTien.Text); _phieughidanh.SoTietHocVienKH = _phieughidanh.SoTietHocVienKH + O2S_Common.TypeConvert.Parse.ToDecimal(numSoBuoiHVDangKy.Text); decimal _mienggiam = _phieughidanh.MienGiam_Tien ?? 0; _phieughidanh.ConNo = _phieughidanh.TongTien - _phieughidanh.DaDong - _mienggiam; //Insert Phieu Thu var rowHandle = gridViewDSHocVien.FocusedRowHandle; PHIEUTHU _phieuthu = new PHIEUTHU(); _phieuthu.CoSoId = GlobalSettings.CoSoId; _phieuthu.PhieuGhiDanhId = this.PhieuGhiDanhId_Select; _phieuthu.HocVienId = this.HocVienId_Select; _phieuthu.ThoiGianThu = DateTime.Now; _phieuthu.SoTien = O2S_Common.TypeConvert.Parse.ToDecimal(numDaDong.Text); _phieuthu.NoiDung = cboDotHoc.Text; _phieuthu.GhiChu = "Thu tiền đợt học: " + cboDotHoc.Text; //Hoc phi hoc vien DOTHOC _dothoc = DotHocLogic.SelectSingle(O2S_Common.TypeConvert.Parse.ToInt32(cboDotHoc.SelectedValue.ToString())); decimal _donGia = _dothoc.HocPhi ?? 0; if (_dothoc.SoBuoiHoc != null && _dothoc.SoBuoiHoc != 0) { _donGia = _dothoc.HocPhi / _dothoc.SoBuoiHoc ?? 1; } HOCPHIHOCVIEN _hocphiHV = new HOCPHIHOCVIEN() { PhieuGhiDanhId = this.PhieuGhiDanhId_Select, HocVienId = this.HocVienId_Select, Stt = 1, DmDichVuId = _dothoc.DotHocId, TenDichVu = cboDotHoc.Text, SoTien = O2S_Common.TypeConvert.Parse.ToDecimal(numTongTien.Text), SoLuong = O2S_Common.TypeConvert.Parse.ToDecimal(numSoBuoiHVDangKy.Text), DonGia = _donGia, PhieuThuId = 0, GhiChu = "", }; if (PhieuGhiDanhLogic.InsertQLHocPhi_Option1(_phieughidanh, _phieuthu, _hocphiHV, ref this.PhieuThu_Insert)) { O2S_Common.Utilities.ThongBao.frmThongBao frmthongbao = new O2S_Common.Utilities.ThongBao.frmThongBao(Base.ThongBaoLable.LUU_THANH_CONG); frmthongbao.Show(); // LoadDanhSachHocVien(); gridViewDSHocVien_Click(null, null); PhieuThuFilter _filter = new PhieuThuFilter(); _filter.HocVienId = this.HocVienId_Select; _filter.PhieuGhiDanhId = this.PhieuGhiDanhId_Select; LoadDanhSachPhieuThu(_filter); btnInBienLai.Enabled = true; } } catch (ArgumentException ex) { MessageBox.Show(ex.Message, "Cảnh báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); } catch (Exception ex) { O2S_Common.Logging.LogSystem.Error(ex); } }