public void Sach_DELETE(DuLieu_NhapSach dl_NhapSach)
{
xl_NhapSach.table_Command("Delete from NhapSach where TenSach = N'" + dl_NhapSach.TenSach + "'");
}
public void Sach_INSERT(DuLieu_NhapSach dl_NhapSach)
{
xl_NhapSach.table_Command("set dateformat dmy INSERT into NhapSach VALUES ('" + dl_NhapSach.Ngay + "', '" + dl_NhapSach.MaSach + "', N'" + dl_NhapSach.TheLoai + "', N'" + dl_NhapSach.TenSach + "', N'" + dl_NhapSach.QuocGia + "',N'" + dl_NhapSach.TenTacGia + "',N'" + dl_NhapSach.NXB + "','" + dl_NhapSach.Gia + "','" + dl_NhapSach.SlNhap + "')");
}
public void Sach_UPDATE(DuLieu_NhapSach dl_NhapSach)
{
xl_NhapSach.table_Command("update NhapSach set MaSach = '" + dl_NhapSach.MaSach + "', TheLoai = N'" + dl_NhapSach.TheLoai + "', TenSach = N'" + dl_NhapSach.TenSach + "', QuocGia = N'" + dl_NhapSach.QuocGia + "', TenTacGia = N'" + dl_NhapSach.TenTacGia + "', NXB = N'" + dl_NhapSach.NXB + "', Gia = '" + dl_NhapSach.Gia + "', SlNhap = '" + dl_NhapSach.SlNhap + "' Where STT = '" + dl_NhapSach.STT + "'");
}
public DataTable QuocGia_Select(DuLieu_NhapSach dl_NhapSach)
{
return(xl_NhapSach.table_Select("select * from VietTatTenNuoc"));
}
public DataTable TheLoai_Select(DuLieu_NhapSach dl_NhapSach)
{
return(xl_NhapSach.table_Select("select * from VietTatTheLoai"));
}
public DataTable LayQuocGia_Select(DuLieu_NhapSach dl_NhapSach)
{
return(xl_NhapSach.table_Select("select Right(MaSach,2) as [MaQuocGia]from NhapSach where QuocGia = N'" + dl_NhapSach.TheLoai + "'"));
}
public DataTable LayTheLoai_Select(DuLieu_NhapSach dl_NhapSach)
{
return(xl_NhapSach.table_Select("select left(MaSach,2) as [MaTheloai] from NhapSach where TheLoai = N'" + dl_NhapSach.TheLoai + "'"));
}
public DataTable NhapSach_Select(DuLieu_NhapSach dl_NhapSach)
{
return(xl_NhapSach.table_Select("select * from NhapSach"));
}