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(MaHD, MaPhieuThue, NgayVao, NgayRa, ThanhTien, DonGiaHT) values(N'" + EC_HD.MaHD + "', N'" + EC_HD.MaPhieuThue + "', '" + EC_HD.NgayVao + "', '" + EC_HD.NgayRa + "'," + EC_HD.ThanhTien + "," + EC_HD.Gia + ") ");
}