public void ThanhToan(EC_HoaDon EC_HD)
{
connect.ThucHienLenh(@"update tblHoaDon set ThanhTien = " + EC_HD.ThanhTien + " where MaHD = '" + EC_HD.MaHD + "'");
}
public void SuaThongTin(EC_HoaDon EC_HD)
{
connect.ThucHienLenh(@"update tblHoaDon set NgayVao = '" + EC_HD.NgayVao + "', NgayRa = '" + EC_HD.NgayRa + "', ThanhTien = " + EC_HD.ThanhTien + " where MaHD = '" + EC_HD.MaHD + "'");
}
public void XoaTTHoaDon(EC_HoaDon EC_HD)
{
connect.ThucHienLenh(@"delete from tblHoaDon where MaHD = '" + EC_HD.MaHD + "'");
}
public void ThemThongTin(EC_HoaDon EC_HD)
{
connect.ThucHienLenh(@"insert into tblHoaDon values(N'" + EC_HD.MaHD + "', N'" + EC_HD.MaPhieuThue + "', '" + EC_HD.NgayVao + "', '" + EC_HD.NgayRa + "'," + EC_HD.ThanhTien + "," + EC_HD.Gia + ") ");
}