private void phieuMuonSachFrmBtn_Click(object sender, EventArgs e) { PhieuMuonSachFrm f = new PhieuMuonSachFrm(loginName); f.Show(); this.Hide(); }
public void loadMaSachData(PhieuMuonSachFrm f) { var data = db.database().SACHes.ToList(); f.maSachCb.DataSource = data; f.maSachCb.ValueMember = "MaSach"; }
public void loadNhanVienData(PhieuMuonSachFrm f) { var data = db.database().NHANVIENs.ToList(); f.tenNhanVienCb.DataSource = data; f.tenNhanVienCb.DisplayMember = "HoTenNhanVien"; f.tenNhanVienCb.ValueMember = "MaNhanVien"; }
public void loadDocGiaData(PhieuMuonSachFrm f) { var data = db.database().DOCGIAs.ToList(); f.tenDocGiaCb.DataSource = data; f.tenDocGiaCb.DisplayMember = "HoTenDocGia"; f.tenDocGiaCb.ValueMember = "MaDocGia"; }
public void setButton(PhieuMuonSachFrm f, bool val) { f.themBtn.Enabled = val; f.suaBtn.Enabled = val; f.xoaBtn.Enabled = val; f.luuBtn.Enabled = !val; f.kLuuBtn.Enabled = !val; f.inBtn.Enabled = val; }
public void delete(PhieuMuonSachFrm f) { var pm = db.database().PHIEUMUONSACHes.SingleOrDefault(a => a.MaPhieuMuon == int.Parse(mapm)); db.database().PHIEUMUONSACHes.DeleteOnSubmit(pm); db.database().SubmitChanges(); loadAllData(f); }
public void loadRowSelected(PhieuMuonSachFrm f) { int currentCell = f.phieuMuonSachGridView.FocusedRowHandle; mapm = f.phieuMuonSachGridView.GetRowCellValue(currentCell, "MaPhieuMuon").ToString(); f.ngayMuonDtp.EditValue = f.phieuMuonSachGridView.GetRowCellValue(currentCell, "NgayMuon").ToString(); f.tenDocGiaCb.Text = f.phieuMuonSachGridView.GetRowCellValue(currentCell, "HoTenDocGia").ToString(); f.tenNhanVienCb.Text = f.phieuMuonSachGridView.GetRowCellValue(currentCell, "HoTenNhanVien").ToString(); f.maSachCb.Text = f.phieuMuonSachGridView.GetRowCellValue(currentCell, "MaSach").ToString(); }
public void enableObject(PhieuMuonSachFrm f, bool val) { f.ngayMuonDtp.Enabled = val; f.tenDocGiaCb.Enabled = val; f.tenNhanVienCb.Enabled = val; f.maSachCb.Enabled = val; f.chuaThanhToanRb.Enabled = val; f.daThanhToanRb.Enabled = val; if (f.tenNhanVienCb.Enabled == true && f.tenDocGiaCb.Enabled == true) { f.tenDocGiaCb.ForeColor = System.Drawing.Color.FromArgb(240, 240, 240); f.tenNhanVienCb.ForeColor = System.Drawing.Color.FromArgb(240, 240, 240); f.maSachCb.ForeColor = System.Drawing.Color.FromArgb(240, 240, 240); } }
public void loadAllData(PhieuMuonSachFrm f) { var data = db.database().PHIEUMUON_PROC().ToList(); f.phieuMuonSachGridControl.DataSource = data; f.phieuMuonSachGridView.Columns[0].Caption = "Mã phiếu mượn"; f.phieuMuonSachGridView.Columns[1].Caption = "Ngày mượn"; f.phieuMuonSachGridView.Columns[2].Caption = "Tên đọc giả"; f.phieuMuonSachGridView.Columns[3].Caption = "Tên nhân viên"; f.phieuMuonSachGridView.Columns[4].Visible = false; f.phieuMuonSachGridView.Columns[5].Caption = "Tên sách"; f.phieuMuonSachGridView.Columns[6].Visible = false; f.phieuMuonSachGridView.Columns[7].Visible = false; f.phieuMuonSachGridView.Columns[8].Caption = "Giá tiền"; f.phieuMuonSachGridView.Columns[8].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; f.phieuMuonSachGridView.Columns[8].DisplayFormat.FormatString = "C0"; f.phieuMuonSachGridView.Columns[8].DisplayFormat.Format = CultureInfo.CreateSpecificCulture("vi-DVN"); f.phieuMuonSachGridView.Columns[9].Caption = "Tình trạng"; }
public void edit(PhieuMuonSachFrm f) { var pm = db.database().PHIEUMUONSACHes.SingleOrDefault(a => a.MaPhieuMuon == int.Parse(mapm)); pm.NgayMuon = Convert.ToDateTime(f.ngayMuonDtp.Text); pm.MaDocGia = int.Parse(f.tenDocGiaCb.SelectedValue.ToString()); pm.MaNhanVien = int.Parse(f.tenNhanVienCb.SelectedValue.ToString()); pm.MaSach = int.Parse(f.maSachCb.SelectedValue.ToString()); if (f.chuaThanhToanRb.Checked) { pm.TinhTrangThanhToan = "Chưa thanh toán"; } else { pm.TinhTrangThanhToan = "Đã thanh toán"; } db.database().SubmitChanges(); loadAllData(f); }
public void add(PhieuMuonSachFrm f) { PHIEUMUONSACH pm = new PHIEUMUONSACH(); pm.NgayMuon = Convert.ToDateTime(f.ngayMuonDtp.Text); pm.MaDocGia = int.Parse(f.tenDocGiaCb.SelectedValue.ToString()); pm.MaNhanVien = int.Parse(f.tenNhanVienCb.SelectedValue.ToString()); pm.MaSach = int.Parse(f.maSachCb.SelectedValue.ToString()); if (f.chuaThanhToanRb.Checked) { pm.TinhTrangThanhToan = "Chưa thanh toán"; } else { pm.TinhTrangThanhToan = "Đã thanh toán"; } db.database().PHIEUMUONSACHes.InsertOnSubmit(pm); db.database().SubmitChanges(); loadAllData(f); }
public void setNull(PhieuMuonSachFrm f) { f.ngayMuonDtp.EditValue = DateTime.Now; f.chuaThanhToanRb.Checked = true; }