//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));
}
