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 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 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 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 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); } }