//xóa dữ liệu
public void XoaDuLieu(EC_PhieuThue et)
{
sql.XoaDuLieu(et);
}
public int Update_TrangThaiDaTra(EC_PhieuThue et)
{
return(sql.Update_TrangThaiDaTra(et));
}
public int ThemDuLieu(EC_PhieuThue et)
{
return(sql.ThemDuLieu(et));
}
//sửa dữ liệu
public int SuaDuLieu(EC_PhieuThue et)
{
return(sql.SuaDuLieu(et));
}
public void SuaThongTin(EC_PhieuThue EC_PT)
{
connect.ThucHienLenh("update tblPhieuThue set MaKH = N'" + EC_PT.MaKH + "', MaPh = N'" + EC_PT.MaPh + "', MaPT =N'" + EC_PT.MaPT + "' where MaPhieu = '" + EC_PT.MaPhieu + "'");
}
public void XoaTTPhieuThue(EC_PhieuThue EC_PT)
{
connect.ThucHienLenh("delete from tblPhieuThue where MaPhieu = '" + EC_PT.MaPhieu + "'");
}
public void ThemThongTin(EC_PhieuThue EC_PT)
{
connect.ThucHienLenh("insert into tblPhieuThue(MaPhieu, MaKH, MaPh, MaPT) values(N'" + EC_PT.MaPhieu + "', N'" + EC_PT.MaKH + "', N'" + EC_PT.MaPh + "', N'" + EC_PT.MaPT + "')");
}
public int Update_TrangThaiDaTra(EC_PhieuThue et)
{
return(cn.ThucThiCauLenhSQL(@"UPDATE PhieuThue SET TrangThai=N'Đã Trả' where MaPT=N'" + et.MaPT + "'"));
}
//xóa dữ liệu
public void XoaDuLieu(EC_PhieuThue et)
{
cn.ThucThiCauLenhSQL(@"DELETE from PhieuThue where MaPT=N'" + et.MaPT + "'");
}
//sửa dữ liệu
public int SuaDuLieu(EC_PhieuThue et)
{
return(cn.ThucThiCauLenhSQL(@"UPDATE PhieuThue SET NgayDK =N'" + et.NgayDK + "', NgayDen =N'" + et.NgayDen + "', MaKH =N'" + et.MaKH + "' where MaPT=N'" + et.MaPT + "'"));
}
//Hàm thêm dữ liệu
public int ThemDuLieu(EC_PhieuThue et)
{
return(cn.ThucThiCauLenhSQL(@"INSERT INTO PhieuThue(MaPT, NgayDK, NgayDen, MaKH,TrangThai)
VALUES (N'" + et.MaPT + "',N'" + et.NgayDK + "',N'" + et.NgayDen + "',N'" + et.MaKH + "',N'Chưa Trả')"));
}