private void CapNhatBangDiem() { if (Software.mGroup == "SINHVIEN") { var ngayThiCheck = (from a in db.GIAOVIEN_DANGKY where a.NGAYTHI < DateTime.Now select a ).ToList(); var query = new BANGDIEM(); query.MAMH = frmThongTinThi.ChonMonHoc; query.MASV = txtMaSV.Text; query.LAN = (short)frmThongTinThi.LanThi; query.NGAYTHI = frmThongTinThi.NgayThi; query.DIEM = float.Parse(txtDiem.Text); //query.BAITHI = baiThi.ToString(); //db.BANGDIEMs.Add(query); db.SaveChanges(); } else { return; }; }
public static void Insert(BANGDIEM _bangdiem) { try { _bangdiem.CreatedDate = DateTime.Now; _bangdiem.CreatedBy = GlobalSettings.UserCode; _bangdiem.CreatedLog = GlobalSettings.SessionMyIP; _bangdiem.IsRemove = 0; Database.BANGDIEMs.InsertOnSubmit(_bangdiem); Database.SubmitChanges(); int _id = _bangdiem.BangDiemId; //Insert Bang diem chi tiet List <KHOAHOC_MONHOC> _khmh = KhoaHocMonHocLogic.SelectTheoKhoaHoc(_bangdiem.KhoaHocId); foreach (var item in _khmh) { BANGDIEMCHITIET _chitiet = new BANGDIEMCHITIET(); _chitiet.BangDiemId = _id; _chitiet.MonHocId = item.MonHocId ?? 0; _chitiet.TenMonHoc = item.TenMonHoc; _chitiet.IsRemove = 0; //_chitiet.CreatedDate = DateTime.Now; //_chitiet.CreatedBy = GlobalSettings.UserCode; //_chitiet.CreatedLog = GlobalSettings.SessionMyIP; Database.BANGDIEMCHITIETs.InsertOnSubmit(_chitiet); Database.SubmitChanges(); } } catch (Exception ex) { O2S_Common.Logging.LogSystem.Error(ex); } }
public static void Update(BANGDIEM b) { var temp = Select(b.HocVienId, b.LopHocId); temp.DiemTrungBinh = b.DiemTrungBinh; Database.SubmitChanges(); }
private void btnLuuLop_Click(object sender, EventArgs e) { try { //insert + Xoa tai BANGDIEM int _LopHocId = O2S_Common.TypeConvert.Parse.ToInt32(cboLopHoc.SelectedValue.ToString()); foreach (var item in this.dsXepLopHocVien) { //kiem tra ton tai hay khong List <BANGDIEM> _kiemtratontai = BangDiemLogic.SelectTheoPhieuGhiDanh(item.PhieuGhiDanhId ?? 0); if (_kiemtratontai == null || _kiemtratontai.Count == 0) { BANGDIEM _bangdiem = new BANGDIEM(); _bangdiem.HocVienId = item.HocVienId ?? 0; _bangdiem.LopHocId = _LopHocId; _bangdiem.PhieuGhiDanhId = item.PhieuGhiDanhId ?? 0; _bangdiem.KhoaHocId = item.KhoaHocId ?? 0; _bangdiem.TrangThai = 0;//=0: xep lop; =1: dang hoc; =3: co diem; =99:ket thuc BangDiemLogic.Insert(_bangdiem); } } List <BANGDIEM> _lstBangDiem_LopHoc = BangDiemLogic.SelectTheoLopHoc(_LopHocId); if (_lstBangDiem_LopHoc != null && _lstBangDiem_LopHoc.Count > 0) { List <BANGDIEM> _bangdiem_Xoa = (from p in _lstBangDiem_LopHoc where !(from q in this.dsXepLopHocVien select q.PhieuGhiDanhId).Contains(p.PhieuGhiDanhId) select p).ToList(); if (_bangdiem_Xoa != null && _bangdiem_Xoa.Count > 0) { BangDiemLogic.DeleteList(_bangdiem_Xoa); } } //Update SiSo cua LOPHOC LOPHOC _lophoc = LopHocLogic.SelectSingle(_LopHocId); LopHocLogic.Update(new LOPHOC() { LopHocId = _lophoc.LopHocId, TenLopHoc = _lophoc.TenLopHoc, NgayBatDau = _lophoc.NgayBatDau, NgayKetThuc = _lophoc.NgayKetThuc, SiSoToiDa = _lophoc.SiSoToiDa, SiSo = this.dsXepLopHocVien.Count, KhoaHocId = _lophoc.KhoaHocId, IsLock = _lophoc.IsLock }); O2S_Common.Utilities.ThongBao.frmThongBao frmthongbao = new O2S_Common.Utilities.ThongBao.frmThongBao(Base.ThongBaoLable.CAP_NHAT_THANH_CONG); frmthongbao.Show(); } catch (Exception ex) { O2S_Common.Utilities.ThongBao.frmThongBao frmthongbao = new O2S_Common.Utilities.ThongBao.frmThongBao(Base.ThongBaoLable.CAP_NHAT_THAT_BAI); frmthongbao.Show(); O2S_Common.Logging.LogSystem.Error(ex); } }
/// <summary> /// Cập nhật bảng điểm /// </summary> /// <param name="b"></param> public static void Update(BANGDIEM b) { var temp = Select(b.MaHV, b.MaLop); temp.DiemNghe = b.DiemNghe; temp.DiemNoi = b.DiemNoi; temp.DiemDoc = b.DiemDoc; temp.DiemViet = b.DiemViet; Database.SubmitChanges(); }
public bool AddMHhs(int hs, int hk, string mh) { HocSinhDBDataContext hdb = new HocSinhDBDataContext(); try { var kq = from s in hdb.MONHOCs where s.TenMonHoc == mh select s.MaMonHoc; string mamh = kq.First().ToString(); BANGDIEM bd = new BANGDIEM { MaBangDiem = hs + mamh, MaHocSinh = hs, MaHocKi = hk, MaMonHoc = mamh, Diem15Phut = 0, Diem1Tiet = 0, DiemCuoiKi = 0 }; hdb.BANGDIEMs.InsertOnSubmit(bd); hdb.SubmitChanges(); return(true); } catch { return(false); } }
/// <summary> /// Thêm một bảng điểm /// </summary> /// <param name="bd">Bảng điểm cần thêm</param> public static void Insert(BANGDIEM bd) { Database.BANGDIEMs.InsertOnSubmit(bd); Database.SubmitChanges(); }
public void LayBangDiem(ListView lbd, ListViewGroup bd, BANGDIEM BD) { string sql = "select HSHS.MAHS, HOTEN, KTM1, KTM2, KTM3, KTM4, KTM5, KT15P1, KT15P2, KT15P3, KT15P4, KT15P5, KT15P6, KT1T1, KT1T2, KT1T3, KT1T4, KT1T5, KT1T6, DIEMTHI, DIEMTB from HSHS, BANGDIEM where HSHS.MAHS = BANGDIEM.MAHS, MAHK = " + BD.MAHK + ", MALOP = " + BD.MALOP + ", MAMONHOC = " + BD.MAMONHOC + ", MANAMHOC = " + BD.MANAMHOC; }
public static bool InsertPGDFull_XepLop(PHIEUGHIDANH _phieughidanh, PHIEUTHU _phieuthu, List <HOCPHIHOCVIEN> _lsthphv, BANGDIEM _bangdiem, ref int _PhieuGhiDanhId, ref int _PhieuThuId) { try { // O2S_Common.Logging.LogSystem.Error("Luu log InsertPGDFull"); using (TransactionScope ts = new TransactionScope()) { //Phieu ghi danh _phieughidanh.CoSoId = GlobalSettings.CoSoId; _phieughidanh.CreatedDate = DateTime.Now; _phieughidanh.CreatedBy = GlobalSettings.UserCode; _phieughidanh.CreatedLog = GlobalSettings.SessionMyIP; _phieughidanh.IsRemove = 0; Database.PHIEUGHIDANHs.InsertOnSubmit(_phieughidanh); Database.SubmitChanges(); _PhieuGhiDanhId = _phieughidanh.PhieuGhiDanhId; _phieughidanh.MaPhieuGhiDanh = string.Format("{0}{1:D7}", "PGD", _PhieuGhiDanhId); Database.SubmitChanges(); //insert bang PHIEUTHU if (_phieuthu != null && _phieuthu.HocVienId > 0) { _phieuthu.PhieuGhiDanhId = _PhieuGhiDanhId; _phieuthu.CreatedDate = DateTime.Now; _phieuthu.CreatedBy = GlobalSettings.UserCode; _phieuthu.CreatedLog = GlobalSettings.SessionMyIP; _phieuthu.IsRemove = 0; Database.PHIEUTHUs.InsertOnSubmit(_phieuthu); Database.SubmitChanges(); _PhieuThuId = _phieuthu.PhieuThuId; _phieuthu.MaPhieuThu = string.Format("{0}{1:D7}", "PT", _phieuthu.PhieuThuId); Database.SubmitChanges(); } //Hocphihocvien if (_lsthphv != null && _lsthphv.Count > 0) { foreach (var item in _lsthphv) { item.PhieuGhiDanhId = _PhieuGhiDanhId; item.PhieuThuId = _phieuthu.PhieuThuId; item.CreatedDate = DateTime.Now; item.CreatedBy = GlobalSettings.UserCode; item.CreatedLog = GlobalSettings.SessionMyIP; item.IsRemove = 0; Database.HOCPHIHOCVIENs.InsertOnSubmit(item); Database.SubmitChanges(); } } //insert BANGDIEM if (_bangdiem.LopHocId != 0) { _bangdiem.PhieuGhiDanhId = _PhieuGhiDanhId; _bangdiem.CreatedDate = DateTime.Now; _bangdiem.CreatedBy = GlobalSettings.UserCode; _bangdiem.CreatedLog = GlobalSettings.SessionMyIP; _bangdiem.IsRemove = 0; Database.BANGDIEMs.InsertOnSubmit(_bangdiem); Database.SubmitChanges(); int _id = _bangdiem.BangDiemId; //Insert Bang diem chi tiet List <KHOAHOC_MONHOC> _khmh = KhoaHocMonHocLogic.SelectTheoKhoaHoc(_bangdiem.KhoaHocId); foreach (var item in _khmh) { BANGDIEMCHITIET _chitiet = new BANGDIEMCHITIET(); _chitiet.BangDiemId = _id; _chitiet.MonHocId = item.MonHocId ?? 0; _chitiet.TenMonHoc = item.TenMonHoc; _chitiet.IsRemove = 0; //_chitiet.CreatedDate = DateTime.Now; //_chitiet.CreatedBy = GlobalSettings.UserCode; //_chitiet.CreatedLog = GlobalSettings.SessionMyIP; Database.BANGDIEMCHITIETs.InsertOnSubmit(_chitiet); Database.SubmitChanges(); } //Update SiSo cua LOPHOC LOPHOC _lophoc = LopHocLogic.SelectSingle(_bangdiem.LopHocId); LopHocLogic.Update(new LOPHOC() { //LopHocId = _lophoc.LopHocId, //TenLopHoc = _lophoc.TenLopHoc, //NgayBatDau = _lophoc.NgayBatDau, //NgayKetThuc = _lophoc.NgayKetThuc, //SiSoToiDa = _lophoc.SiSoToiDa, SiSo = _lophoc.SiSo + 1, //KhoaHocId = _lophoc.KhoaHocId, //IsLock = _lophoc.IsLock }); } //Update HOCVIEN = Hoc vien chinh thuc HOCVIEN _hocvien = HocVienLogic.SelectSingle(_phieughidanh.HocVienId ?? 0); _hocvien.LOAIHOCVIEN = LoaiHocVienLogic.Select(KeySetting.LOAIHOCVIEN_CHINHTHUC); //Database.SubmitChanges(); //Update TAIKHOAN = được sử dụng TAIKHOAN _taikhoan = TaiKhoanLogic.SelectTheoTenDangNhap(_hocvien.MaHocVien); _taikhoan.IsRemove = 0; Database.SubmitChanges(); ts.Complete(); return(true); } } catch (Exception ex) { O2S_Common.Logging.LogSystem.Error(ex); return(false); } }
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); } }