// xóa
public void Delete(EC_HOADON et)
{
cn.ExecuteSql(@"DELETE FROM HOADON WHERE MaHD = N'" + et.MaHD + "' ");
}
// sửa
public void Update(EC_HOADON et)
{
cn.ExecuteSql(@"UPDATE HOADON SET NgayBan =N'" + et.NgayBan + "', MaKH =N'" + et.MaKH + "', MaNV =N'" + et.MaNV + "' WHERE MaHD = N'" + et.MaHD + "' ");
}
public void Insert(EC_HOADON et)
{
cn.ExecuteSql(@"INSERT INTO HOADON(MaHD, NgayBan, MaKH, MaNV) VALUES(N'" + et.MaHD + "',N'" + et.NgayBan + "',N'" + et.MaKH + "',N'" + et.MaNV + "')");
}
// xóa
public void Delete(EC_HOADON et)
{
sql.Delete(et);
}
// sửa
public void Update(EC_HOADON et)
{
sql.Update(et);
}
public void Insert(EC_HOADON et)
{
sql.Insert(et);
}