Exemple #1
0
 public void ThanhToan(EC_HoaDon EC_HD)
 {
     connect.ThucHienLenh(@"update tblHoaDon set ThanhTien = " + EC_HD.ThanhTien + " where MaHD = '" + EC_HD.MaHD + "'");
 }
Exemple #2
0
 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 + "'");
 }
Exemple #3
0
 public void XoaTTHoaDon(EC_HoaDon EC_HD)
 {
     connect.ThucHienLenh(@"delete from tblHoaDon where MaHD = '" + EC_HD.MaHD + "'");
 }
Exemple #4
0
 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 + ") ");
 }