// Thêm Dữ Liệu
public void ThemDuLieu(E_DocGia et)
{
cn.ThucThiCauLenh(@"INSERT INTO DocGia (iddocgia, hoten, loaidocgia, ngaysinh, diachi, email, ngaylapthe) VALUES ('" + et.iddocgia + "',N'" + et.hoten + "',N'" + et.loaidocgia + "',N'" + et.ngaysinh + "',N'" + et.diachi + "',N'" + et.email + "',N'" + et.ngaylapthe + "')");
}
// Thêm Dữ Liệu
public void ThemDuLieu(E_Sach et)
{
cn.ThucThiCauLenh(@"INSERT INTO Sach (masach, tensach, theloai, tacgia, namsx, nhaxuatban, ngaynhap, trigia) VALUES ('" + et.masach + "',N'" + et.tensach + "',N'" + et.theloai + "',N'" + et.tacgia + "',N'" + et.namsx + "',N'" + et.nhaxuatban + "',N'" + et.ngaynhap + "',N'" + et.trigia + "')");
}
// Thêm Dữ Liệu
public void ThemDuLieu(E_DanhSachSach et)
{
cn.ThucThiCauLenh(@"INSERT INTO DanhSachSach (masach, tensach, theloai, tacgia) VALUES ('" + et.masach + "',N'" + et.tensach + "',N'" + et.theloai + "',N'" + et.tacgia + "')");
}
// Thêm Dữ Liệu
public void ThemDuLieu(E_PhieuMuonSach et)
{
cn.ThucThiCauLenh(@"INSERT INTO PhieuMuonSach (masach, iddocgia, tensach, theloai, tacgia, hoten, ngaymuon) VALUES ('" + et.masach + "',N'" + et.iddocgia + "',N'" + et.tensach + "',N'" + et.theloai + "',N'" + et.tacgia + "',N'" + et.hoten + "',N'" + et.ngaymuon + "')");
}
public void truyendl()
{
cn.ThucThiCauLenh("insert into BaoCaoI(masach, theloai, thang) select masach, theloai, month(ngaymuon) from PhieuMuonSach pms where not exists (select masach from BaoCaoI bc1 where bc1.masach = pms.masach)");
}
public void truyendl()
{
cn.ThucThiCauLenh("insert into BaoCaoII(masach,tensach,ngaymuon) select masach,tensach,ngaymuon from PhieuMuonSach");
}