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