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