//lấy số lượng ctpt theo 1 mã phiếu thuê public string SoLuongCTPT(EC_ChiTietPhieuThue et) { return(cn.GetValue("select count(SoPhong) from ChiTiet_PhieuThue where MaPT=N'" + et.MaPT + "'")); }
//lấy số lượng phòng Đã được Nhận theo mã phiếu thuê public string SoLuongCTPT_DaNhan(EC_ChiTietPhieuThue et) { return(cn.GetValue("select count(c.SoPhong) from ChiTiet_PhieuThue c,Phong p where MaPT=N'" + et.MaPT + "' and p.SoPhong=c.SoPhong and p.TrangThai=N'Đang Ở'")); }
//xóa dữ liệu public void XoaDuLieu(EC_ChiTietPhieuThue et) { cn.ThucThiCauLenhSQL(@"DELETE from ChiTiet_PhieuThue where MaPT=N'" + et.MaPT + "' and SoPhong=N'" + et.SoPhong + "'"); }
public DataTable TaoBangCTPT(EC_ChiTietPhieuThue et) { return(cn.GetDataTable("select c.SoPhong,MaPT,TienDatCoc,p.Gia,p.TrangThai from ChiTiet_PhieuThue c,Phong p where c.SoPhong=p.SoPhong and c.MaPT=N'" + et.MaPT + "'")); }
//sửa dữ liệu public int SuaDuLieu(EC_ChiTietPhieuThue et1, EC_ChiTietPhieuThue et2) { return(cn.ThucThiCauLenhSQL(@"UPDATE ChiTiet_PhieuThue SET SoPhong =N'" + et2.SoPhong + "', MaPT =N'" + et2.MaPT + "',TienDatCoc =N'" + et2.TienDatCoc + "', TrangThai =N'" + et2.TrangThai + "' Where MaPT=N'" + et1.MaPT + "' and SoPhong=N'" + et1.SoPhong + "'")); }
public int UpDate_DaTra(EC_ChiTietPhieuThue et) { return(cn.ThucThiCauLenhSQL(@"UPDATE ChiTiet_PhieuThue SET TrangThai =N'Đã Trả' Where MaPT=N'" + et.MaPT + "' and SoPhong=N'" + et.SoPhong + "'")); }
public string SoLuongCTPT_DaNhan(EC_ChiTietPhieuThue et) { return(sql.SoLuongCTPT_DaNhan(et)); }
//Hàm thêm dữ liệu public int ThemDuLieu(EC_ChiTietPhieuThue et) { return(cn.ThucThiCauLenhSQL(@"INSERT INTO ChiTiet_PhieuThue(SoPhong, MaPT, TienDatCoc, TrangThai) VALUES (N'" + et.SoPhong + "',N'" + et.MaPT + "',N'" + et.TienDatCoc + "',N'" + et.TrangThai + "')")); }
public DataTable TaoBangCTPT(EC_ChiTietPhieuThue et) { return(sql.TaoBangCTPT(et)); }
public int UpDate_DaTra(EC_ChiTietPhieuThue et) { return(sql.UpDate_DaTra(et)); }
//xóa dữ liệu public void XoaDuLieu(EC_ChiTietPhieuThue et) { sql.XoaDuLieu(et); }
//sửa dữ liệu public int SuaDuLieu(EC_ChiTietPhieuThue et1, EC_ChiTietPhieuThue et2) { return(sql.SuaDuLieu(et1, et2)); }
//Hàm thêm dữ liệu public int ThemDuLieu(EC_ChiTietPhieuThue et) { return(sql.ThemDuLieu(et)); }