C# (CSharp) ChiTietMuonSach Examples

Example #1

File: BUSS_Muonsach.cs Project: DatHoaiLong/QLThuVien

 public void XoaDuLieu(ChiTietMuonSach et)
 {
     sql.XoaDuLieu(et);
 }

Example #2

File: BUSS_Muonsach.cs Project: DatHoaiLong/QLThuVien

 public void SuaDuLieu(ChiTietMuonSach et)
 {
     sql.SuaDuLieu(et);
 }

Example #3

File: BUSS_Muonsach.cs Project: DatHoaiLong/QLThuVien

 public void ThemDuLieu(ChiTietMuonSach et)
 {
     sql.ThemDuLieu(et);
 }

Example #4

 public void XoaDuLieu(ChiTietMuonSach et)
 {
     cn.ThucThiCauLenhSQL(@"DELETE  from  CHITIETMUONSACH where MaHoiVien='" + et.Mahoivien + "'");
 }

Example #5

 public void SuaDuLieu(ChiTietMuonSach et)
 {
     cn.ThucThiCauLenhSQL(@"UPDATE    CHITIETMUONSACH SET   MaSach ='" + et.Masach + "',SoLuongMuon='" + et.Soluongmuon + "', NgayMuon ='" + et.Ngaymuon + "', NgayHenTra ='" + et.Ngayhentra + "' where MaHoiVien='" + et.Mahoivien + "'");
 }

Example #6

 public void ThemDuLieu(ChiTietMuonSach et)
 {
     cn.ThucThiCauLenhSQL(@"INSERT INTO CHITIETMUONSACH (MaHoiVien,MaSach,SoLuongMuon,NgayMuon,NgayHenTra) VALUES     ('" + et.Mahoivien + "','" + et.Masach + "','" + et.Soluongmuon + "','" + et.Ngaymuon + "','" + et.Ngayhentra + "')");
 }