private void btnTimKiem_Click(object sender, EventArgs e) { SplashScreenManager.ShowForm(typeof(O2S_Common.Utilities.ThongBao.WaitForm_Wait)); try { PhieuGhiDanhFilter _filter = new PhieuGhiDanhFilter(); _filter.CoSoId = GlobalSettings.CoSoId; _filter.NgayGhiDanh_Tu = date_TuNgay.DateTime; _filter.NgayGhiDanh_Den = date_DenNgay.DateTime; this.lstHVNoHocPhi = PhieuGhiDanhLogic.Select(_filter).Where(o => o.ConNo > 0).ToList(); if (this.lstHVNoHocPhi != null && this.lstHVNoHocPhi.Count > 0) { for (int i = 0; i < this.lstHVNoHocPhi.Count; i++) { this.lstHVNoHocPhi[i].Stt = i + 1; } gridControlDSBaoCao.DataSource = this.lstHVNoHocPhi; } else { gridControlDSBaoCao.DataSource = null; } } catch (Exception ex) { O2S_Common.Logging.LogSystem.Error(ex); } SplashScreenManager.CloseForm(); }
private void LoadDanhSachHocVien() { SplashScreenManager.ShowForm(typeof(O2S_Common.Utilities.ThongBao.WaitForm_Wait)); try { PhieuGhiDanhFilter _filter = new PhieuGhiDanhFilter(); _filter.CoSoId = GlobalSettings.CoSoId; _filter.NgayGhiDanh_Tu = date_TuNgay.DateTime; _filter.NgayGhiDanh_Den = date_DenNgay.DateTime; List <QLHocPhi_PlusDTO> _lstQLHocPhi = PhieuGhiDanhLogic.SelectQLHocPhiOption1(_filter); if (_lstQLHocPhi != null) { gridControlDSHocVien.DataSource = _lstQLHocPhi; } else { gridControlDSHocVien.DataSource = null; } gridControlPhieuThu.DataSource = null; lblMaHocVien.Text = String.Empty; lblTenHocVien.Text = String.Empty; lblHocPhi.Text = String.Empty; lblDaDong.Text = String.Empty; lblConNo.Text = String.Empty; lblMienGiam_Tien.Text = string.Empty; } catch (Exception ex) { O2S_Common.Logging.LogSystem.Warn(ex); } SplashScreenManager.CloseForm(); }
private void LoadDanhSachHocVien() { try { PhieuGhiDanhFilter _filter = new PhieuGhiDanhFilter(); _filter.CoSoId = GlobalSettings.CoSoId; _filter.NgayGhiDanh_Tu = date_TuNgay.DateTime; _filter.NgayGhiDanh_Den = date_DenNgay.DateTime; List <QLHocPhi_PlusDTO> _lstQLHocPhi = PhieuGhiDanhLogic.SelectQLHocPhi(_filter); if (_lstQLHocPhi != null) { gridControlDSHocVien.DataSource = _lstQLHocPhi; } else { gridControlDSHocVien.DataSource = null; } gridControlPhieuThu.DataSource = null; lblMaHocVien.Text = String.Empty; lblTenHocVien.Text = String.Empty; lblHocPhi.Text = String.Empty; lblDaDong.Text = String.Empty; lblConNo.Text = String.Empty; lblMienGiam_Tien.Text = string.Empty; } catch (Exception ex) { O2S_Common.Logging.LogSystem.Warn(ex); } }
private void btnTimKiem_Click(object sender, EventArgs e) { SplashScreenManager.ShowForm(typeof(O2S_Common.Utilities.ThongBao.WaitForm_Wait)); try { PhieuGhiDanhFilter _filter = new PhieuGhiDanhFilter(); _filter.CoSoId = GlobalSettings.CoSoId; _filter.NgayGhiDanh_Tu = date_TuNgay.DateTime; _filter.NgayGhiDanh_Den = date_DenNgay.DateTime; this._lstPhieuGhiDanh = PhieuGhiDanhLogic.Select(_filter); if (this._lstPhieuGhiDanh != null && this._lstPhieuGhiDanh.Count > 0) { gridControlDSPhieuGhiDanh.DataSource = this._lstPhieuGhiDanh; } else { gridControlDSPhieuGhiDanh.DataSource = null; } } catch (Exception ex) { O2S_Common.Logging.LogSystem.Error(ex); } SplashScreenManager.CloseForm(); }
public void LoadPhieuGhiDanh() { PhieuGhiDanhFilter _filter = new PhieuGhiDanhFilter(); _filter.CoSoId = GlobalSettings.CoSoId; _filter.NgayGhiDanh_Tu = date_TuNgay.DateTime; _filter.NgayGhiDanh_Den = date_DenNgay.DateTime; List <PhieuGhiDanh_PlusDTO> _lstPhieuGhiDanh = PhieuGhiDanhLogic.SelectOption1(_filter); gridControlDSPhieuGhiDanh.DataSource = _lstPhieuGhiDanh; lblTongCongPhieu.Text = string.Format("Tổng cộng: {0} phiếu ghi danh", gridViewDSPhieuGhiDanh.RowCount); }
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 btnThemVaoLop_Click(object sender, EventArgs e) { try { if (gridViewHV_ChuaXepLop.RowCount > 0) { int _lophocId = O2S_Common.TypeConvert.Parse.ToInt32(cboLopHoc.SelectedValue.ToString()); LOPHOC _lophoc = LopHocLogic.SelectSingle(_lophocId); if (gridViewHV_XepLop.RowCount < _lophoc.SiSoToiDa || MessageBox.Show("Số học viên tối đa của lớp là " + _lophoc.SiSoToiDa + Environment.NewLine + "Bạn có chắc sẽ thêm?", "Cảnh báo", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes) { var rowHandle = gridViewHV_ChuaXepLop.FocusedRowHandle; int _phieughidanhId = O2S_Common.TypeConvert.Parse.ToInt32(gridViewHV_ChuaXepLop.GetRowCellValue(rowHandle, "PhieuGhiDanhId").ToString()); PHIEUGHIDANH _phieuGD = PhieuGhiDanhLogic.SelectSingle(_phieughidanhId); XepLopDTO _hocvienLop = new XepLopDTO(); _hocvienLop.HocVienId = _phieuGD.HocVienId; _hocvienLop.MaHocVien = _phieuGD.HOCVIEN.MaHocVien; _hocvienLop.TenHocVien = _phieuGD.HOCVIEN.TenHocVien; _hocvienLop.PhieuGhiDanhId = _phieuGD.PhieuGhiDanhId; _hocvienLop.MaPhieuGhiDanh = _phieuGD.MaPhieuGhiDanh; _hocvienLop.NgayGhiDanh = _phieuGD.NgayGhiDanh; _hocvienLop.NgaySinh = _phieuGD.HOCVIEN.NgaySinh; _hocvienLop.GioiTinh = _phieuGD.HOCVIEN.GioiTinh; _hocvienLop.DiaChi = _phieuGD.HOCVIEN.DiaChi; _hocvienLop.Sdt = _phieuGD.HOCVIEN.Sdt; _hocvienLop.Email = _phieuGD.HOCVIEN.Email; _hocvienLop.KhoaHocId = _phieuGD.KhoaHocId; _hocvienLop.MaKhoaHoc = _phieuGD.KHOAHOC.MaKhoaHoc; _hocvienLop.TenKhoaHoc = _phieuGD.KHOAHOC.TenKhoaHoc; this.dsXepLopHocVien.Add(_hocvienLop); XepLopDTO _xoa = this.dsChuaCoLop.Where(o => o.PhieuGhiDanhId == _hocvienLop.PhieuGhiDanhId && o.KhoaHocId == _hocvienLop.KhoaHocId).FirstOrDefault(); this.dsChuaCoLop.Remove(_xoa); gridControlHV_ChuaXepLop.DataSource = null; gridControlHV_ChuaXepLop.DataSource = this.dsChuaCoLop; gridControlHV_XepLop.DataSource = null; gridControlHV_XepLop.DataSource = this.dsXepLopHocVien; } } } catch (Exception ex) { O2S_Common.Logging.LogSystem.Warn(ex); } }
private void ValidateXoaHocVien(int _hocvienId) { //hv khong cho xoa: da lap phieu ghi danh PhieuGhiDanhFilter _filter = new PhieuGhiDanhFilter() { HocVienId = _hocvienId, }; List <PhieuGhiDanh_PlusDTO> _lstphieugd = PhieuGhiDanhLogic.Select(_filter); if (_lstphieugd != null && _lstphieugd.Count > 0) { throw new ArgumentException("Học viên đã lập phiếu ghi danh nên không thể xóa được."); } }
private void ValidateXoaKhoaHoc(int _KhoaHocId) { //kiem tra neu khóa học đã có trong PHIEUGHIDANH thì không cho xóa PhieuGhiDanhFilter _filter = new PhieuGhiDanhFilter(); _filter.KhoaHocId = _KhoaHocId; _filter.CoSoId = GlobalSettings.CoSoId; List <PhieuGhiDanh_PlusDTO> _lstPhieuGD = PhieuGhiDanhLogic.Select(_filter); if (_lstPhieuGD != null && _lstPhieuGD.Count > 0) { throw new ArgumentException("Khóa học đã được sử dụng nên không thể xóa"); } }
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 btnPhieuGhiDanh7So_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { try { if (PhieuGhiDanhLogic.UpdateMaPhieuGhiDanh7So()) { MessageBox.Show("Cập nhật thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Cập nhật thất bại", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { O2S_Common.Logging.LogSystem.Warn(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 ValidateLuuPhieu() { var rowHandle = gridViewDSHocVien.FocusedRowHandle; PhieuGhiDanhFilter _filter = new PhieuGhiDanhFilter(); _filter.HocVienId = O2S_Common.TypeConvert.Parse.ToInt32(gridViewDSHocVien.GetRowCellValue(rowHandle, "HocVienId").ToString()); var f = PhieuGhiDanhLogic.Select(_filter); foreach (var i in f) { if (i.ConNo > 0) { throw new Exception("Học viên đang nợ không được phép ghi danh mới"); } } if (O2S_Common.TypeConvert.Parse.ToDecimal(numDaDong.Text) < O2S_Common.TypeConvert.Parse.ToDecimal(GlobalSettings.lstQuyDinh["QD0001"])) { throw new Exception(string.Format("Số tiền đóng khi ghi danh phải ít nhất bằng {0:C0}", GlobalSettings.lstQuyDinh["QD0001"])); } }
private void btnLuuThongTin_Click(object sender, EventArgs e) { try { PHIEUGHIDANH _phieuGD = PhieuGhiDanhLogic.SelectSingle(this.PhieuGhiDanhId); _phieuGD.IsRemove = 1; _phieuGD.LyDoXoa = txtLyDoXoa.Text; _phieuGD.NguoiXoa = GlobalSettings.UserCode; if (PhieuGhiDanhLogic.XoaPhieuGhiDanh(_phieuGD)) { MessageBox.Show("Xóa thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } else { O2S_Common.Utilities.ThongBao.frmThongBao frmthongbao = new O2S_Common.Utilities.ThongBao.frmThongBao(Base.ThongBaoLable.THAO_TAC_THAT_BAI); frmthongbao.Show(); } } 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); } }
private void InBienLaiThuTien(PHIEUTHU _phieuthu) { try { SplashScreenManager.ShowForm(typeof(O2S_Common.Utilities.ThongBao.WaitForm_Wait)); PHIEUGHIDANH _phieughidanh = PhieuGhiDanhLogic.SelectSingle(_phieuthu.PhieuGhiDanhId ?? 0); var rowHandle = gridViewDSHocVien.FocusedRowHandle; List <reportExcelDTO> thongTinThem = new List <reportExcelDTO>(); reportExcelDTO item_MAPHIEUTHU = new reportExcelDTO(); item_MAPHIEUTHU.name = "MAPHIEUTHU"; item_MAPHIEUTHU.value = _phieuthu.MaPhieuThu; thongTinThem.Add(item_MAPHIEUTHU); reportExcelDTO item_MAHOCVIEN = new reportExcelDTO(); item_MAHOCVIEN.name = "MAHOCVIEN"; item_MAHOCVIEN.value = lblMaHocVien.Text; thongTinThem.Add(item_MAHOCVIEN); reportExcelDTO item_TENHOCVIEN = new reportExcelDTO(); item_TENHOCVIEN.name = "TENHOCVIEN"; item_TENHOCVIEN.value = lblTenHocVien.Text; thongTinThem.Add(item_TENHOCVIEN); reportExcelDTO item_DIACHI = new reportExcelDTO(); item_DIACHI.name = "DIACHI"; item_DIACHI.value = gridViewDSHocVien.GetRowCellValue(rowHandle, "DiaChi").ToString(); thongTinThem.Add(item_DIACHI); reportExcelDTO item_KHOAHOC = new reportExcelDTO(); item_KHOAHOC.name = "KHOAHOC"; item_KHOAHOC.value = gridViewDSHocVien.GetRowCellValue(rowHandle, "TenKhoaHoc").ToString(); thongTinThem.Add(item_KHOAHOC); DateTime _namsinh = O2S_Common.TypeConvert.Parse.ToDateTime(gridViewDSHocVien.GetRowCellValue(rowHandle, "NgaySinh").ToString()); reportExcelDTO item_NAMSINH = new reportExcelDTO(); item_NAMSINH.name = "NAMSINH"; item_NAMSINH.value = _namsinh.ToString("dd/MM/yyyy"); thongTinThem.Add(item_NAMSINH); reportExcelDTO item_LOPHOC = new reportExcelDTO(); item_LOPHOC.name = "LOPHOC"; item_LOPHOC.value = gridViewDSHocVien.GetRowCellValue(rowHandle, "TenLopHoc").ToString(); thongTinThem.Add(item_LOPHOC); // reportExcelDTO item_TONGTIEN = new reportExcelDTO() { name = "TONGTIEN", value = O2S_Common.Number.Convert.NumberToString(_phieughidanh.TongTien ?? 0, 0) + " đ", }; thongTinThem.Add(item_TONGTIEN); reportExcelDTO item_MIENGIAM_TIEN = new reportExcelDTO() { name = "MIENGIAM_TIEN", value = O2S_Common.Number.Convert.NumberToString(_phieughidanh.MienGiam_Tien ?? 0, 0) + " đ", }; thongTinThem.Add(item_MIENGIAM_TIEN); reportExcelDTO item_CONNO = new reportExcelDTO() { name = "CONNO", value = O2S_Common.Number.Convert.NumberToString(_phieughidanh.ConNo ?? 0, 0) + " đ", }; thongTinThem.Add(item_CONNO); reportExcelDTO item_SOTIEN = new reportExcelDTO() { name = "SOTIEN", value = O2S_Common.Number.Convert.NumberToString(_phieuthu.SoTien ?? 0, 0) + " đ", }; thongTinThem.Add(item_SOTIEN); reportExcelDTO item_sotienchu = new reportExcelDTO(); item_sotienchu.name = "SOTIENBANGCHU"; item_sotienchu.value = O2S_Common.Strings.Convert.CurrencyToVneseString(O2S_Common.Number.Convert.NumberToNumberRoundAuto(_phieuthu.SoTien ?? 0, 0).ToString()); thongTinThem.Add(item_sotienchu); // DataTable dataExport = new DataTable(); dataExport.Columns.Add("STT", typeof(string)); dataExport.Columns.Add("KHOANTHU", typeof(string)); dataExport.Columns.Add("SOTIEN", typeof(string)); dataExport.Columns.Add("GHICHU", typeof(string)); HocPhiHocVienFilter _filter = new HocPhiHocVienFilter() { PhieuThuId = _phieuthu.PhieuThuId, HocVienId = this.HocVienId_Select, }; List <HocPhiHocVien_PlusDTO> _lsthocPhiHV = HocPhiHocVienLogic.Select(_filter); if (_lsthocPhiHV != null && _lsthocPhiHV.Count > 0) { _lsthocPhiHV.OrderBy(o => o.Stt).ToList(); for (int i = 0; i < _lsthocPhiHV.Count; i++) { DataRow newRow_khac = dataExport.NewRow(); newRow_khac["STT"] = _lsthocPhiHV[i].Stt; newRow_khac["KHOANTHU"] = _lsthocPhiHV[i].TenDichVu == null ? "" : _lsthocPhiHV[i].TenDichVu; newRow_khac["SOTIEN"] = O2S_Common.Number.Convert.NumberToString(O2S_Common.TypeConvert.Parse.ToDecimal(_lsthocPhiHV[i].SoTien.ToString()), 0); newRow_khac["GHICHU"] = _lsthocPhiHV[i].GhiChu == null ? "" : _lsthocPhiHV[i].GhiChu; dataExport.Rows.Add(newRow_khac); } } string fileTemplatePath = LuaChonTemplateInBienLai(_lsthocPhiHV); Utilities.Prints.PrintPreview.ShowPrintPreview_UsingExcelTemplate(fileTemplatePath, thongTinThem, dataExport); } catch (Exception ex) { O2S_Common.Logging.LogSystem.Error(ex); } SplashScreenManager.CloseForm(); }
private void btnLuuPhieu_Click(object sender, EventArgs e) { try { ValidateLuuPhieu(); DOTHOC _dotHoc = null; if (cboDotHoc.SelectedValue != null) { _dotHoc = DotHocLogic.SelectSingle(O2S_Common.TypeConvert.Parse.ToInt32(cboDotHoc.SelectedValue.ToString())); } //Insert bang PHIEUGHIDANH //insert bang PHIEUTHU; HOCPHIHOCVIEN //cap nhat bang HOCVIEN trang thai hoc vien = hoc vien chinh thuc + TAIKHOAN=chinh thuc PHIEUGHIDANH _phieughidanh = new PHIEUGHIDANH(); _phieughidanh.HocVienId = this.HocVienId_Select; _phieughidanh.KhoaHocId = O2S_Common.TypeConvert.Parse.ToInt32(cboKhoaHoc.SelectedValue.ToString()); _phieughidanh.LopHocId = O2S_Common.TypeConvert.Parse.ToInt32(cboLopHoc.SelectedValue.ToString()); _phieughidanh.NgayGhiDanh = DateTime.ParseExact(dateNgayGhiDanh.Text, "HH:mm:ss dd/MM/yyyy", CultureInfo.InvariantCulture); //tong tien cua lop hoc den thoi diem hien tai List <DOTHOC> _lstDotHoc = DotHocLogic.SelectTheoLopHoc(_phieughidanh.LopHocId ?? 0); _phieughidanh.HocPhiKH = _lstDotHoc != null?_lstDotHoc.Sum(o => o.HocPhi) : 0; _phieughidanh.SoTietKH = _lstDotHoc != null?_lstDotHoc.Sum(o => o.SoBuoiHoc) : 0; _phieughidanh.HocPhiHocVienKH = O2S_Common.TypeConvert.Parse.ToDecimal(lblThanhTienKhoaHoc.Text.Replace(",", "")); _phieughidanh.SoTietHocVienKH = O2S_Common.TypeConvert.Parse.ToDecimal(numSoBuoiHVDangKy.Text); _phieughidanh.ThuKhoanKhac = TinhTongTien_ThuThem(); _phieughidanh.TongTien = O2S_Common.TypeConvert.Parse.ToDecimal(numTongTien.Text); _phieughidanh.DaDong = O2S_Common.TypeConvert.Parse.ToDecimal(numDaDong.Text.Replace(",", "")); _phieughidanh.ConNo = O2S_Common.TypeConvert.Parse.ToDecimal(numConNo.Text); _phieughidanh.MienGiam_PhanTram = O2S_Common.TypeConvert.Parse.ToInt16(numMienGiam_PTram.Value.ToString()); _phieughidanh.MienGiam_Tien = O2S_Common.TypeConvert.Parse.ToDecimal(numMienGiam_Tien.Text.Replace(",", "")); _phieughidanh.LyDoMienGiam = txtLyDoMienGiam.Text; if (GlobalSettings.UserID != -1) { _phieughidanh.NhanVienId = GlobalSettings.UserID; } //insert bang PHIEUTHU PHIEUTHU _phieuthu = new PHIEUTHU(); List <HOCPHIHOCVIEN> _lsthphv = new List <HOCPHIHOCVIEN>(); if (O2S_Common.TypeConvert.Parse.ToDecimal(numDaDong.Text.Replace(",", "")) > 0) { //_phieuthuInsert.PhieuGhiDanhId = this.PhieuGhiDanhId; _phieuthu.CoSoId = GlobalSettings.CoSoId; _phieuthu.HocVienId = this.HocVienId_Select; _phieuthu.ThoiGianThu = DateTime.Now; _phieuthu.SoTien = O2S_Common.TypeConvert.Parse.ToDecimal(numDaDong.Text.Replace(",", "")); _phieuthu.NoiDung = cboDotHoc.Text; _phieuthu.GhiChu = "Thu tiền đợt học: " + cboDotHoc.Text; //Tien Dot Hoc if (cboDotHoc.SelectedValue != null) { HOCPHIHOCVIEN _hphv_kh = new HOCPHIHOCVIEN() { Stt = 1, HocVienId = this.HocVienId_Select, DmDichVuId = O2S_Common.TypeConvert.Parse.ToInt32(cboDotHoc.SelectedValue.ToString()), TenDichVu = cboDotHoc.Text, SoTien = O2S_Common.TypeConvert.Parse.ToDecimal(lblThanhTienKhoaHoc.Text.Replace(",", "")), SoLuong = O2S_Common.TypeConvert.Parse.ToDecimal(numSoBuoiHVDangKy.Text.Replace(",", "")), DonGia = O2S_Common.TypeConvert.Parse.ToDecimal(numHocPhi.Text) / O2S_Common.TypeConvert.Parse.ToDecimal(numSoTietHoc.Text), //PhieuThuId = _phieuthuId, GhiChu = "", }; _lsthphv.Add(_hphv_kh); } //tien khoan Khac if (gridViewKhoanKhac.RowCount > 0) { _phieuthu.NoiDung += " và khoản khác"; _phieuthu.GhiChu += " và khoản khác"; int _stt_thuthem = 2; for (int i = 0; i < gridViewKhoanKhac.RowCount; i++) { object _noidungkt = gridViewKhoanKhac.GetRowCellValue(i, "noidung"); if (_noidungkt != null) { HOCPHIHOCVIEN _hphv_khac = new HOCPHIHOCVIEN() { Stt = _stt_thuthem, HocVienId = this.HocVienId_Select, DmDichVuId = 0, TenDichVu = gridViewKhoanKhac.GetRowCellValue(i, "noidung") == null ? "" : gridViewKhoanKhac.GetRowCellValue(i, "noidung").ToString(), SoTien = O2S_Common.TypeConvert.Parse.ToDecimal(gridViewKhoanKhac.GetRowCellValue(i, "sotien").ToString()), SoLuong = 1, DonGia = O2S_Common.TypeConvert.Parse.ToDecimal(gridViewKhoanKhac.GetRowCellValue(i, "sotien").ToString()), //PhieuThuId = _phieuthuId, GhiChu = gridViewKhoanKhac.GetRowCellValue(i, "ghichu") == null ? "" : gridViewKhoanKhac.GetRowCellValue(i, "ghichu").ToString(), }; _lsthphv.Add(_hphv_khac); _stt_thuthem += 1; } } } } //bang diem BANGDIEM _bangdiem = new BANGDIEM(); _bangdiem.HocVienId = this.HocVienId_Select; _bangdiem.LopHocId = O2S_Common.TypeConvert.Parse.ToInt32(cboLopHoc.SelectedValue.ToString()); // _bangdiem.PhieuGhiDanhId = item.PhieuGhiDanhId ?? 0; _bangdiem.KhoaHocId = O2S_Common.TypeConvert.Parse.ToInt32(cboKhoaHoc.SelectedValue.ToString()); _bangdiem.TrangThai = 0;//=0: xep lop; =1: dang hoc; =3: co diem; =99:ket thu if (PhieuGhiDanhLogic.InsertPGDFull_XepLop(_phieughidanh, _phieuthu, _lsthphv, _bangdiem, ref this.PhieuGhiDanhId, ref this.PhieuThuId)) { HOCVIEN _hv = HocVienLogic.SelectSingle(this.HocVienId_Select); MessageBox.Show(string.Format("Học viên {0} đã được chuyển thành học viên chính thức với tài khoản:{1}Tên đăng nhập: {2}{3}Mật khẩu: {4}", _hv.TenHocVien, Environment.NewLine, _hv.MaHocVien, Environment.NewLine, _hv.MaHocVien), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); isSave = true; btnLuuPhieu.Enabled = false; LoadPhieuGhiDanh(); if (this.PhieuThuId != 0) { btnInBienLai.Enabled = true; if (MessageBox.Show("Bạn có muốn in phiếu ghi danh vừa lưu?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { InBienLaiThuTien_Process(this.PhieuThuId); } } } else { O2S_Common.Utilities.ThongBao.frmThongBao frmthongbao = new O2S_Common.Utilities.ThongBao.frmThongBao(Base.ThongBaoLable.THEM_MOI_THAT_BAI); frmthongbao.Show(); } } catch (ArgumentException ex) { MessageBox.Show(ex.Message, "Cảnh báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); } catch (Exception ex) { MessageBox.Show(ex.Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }