public static void Update(DTO.CTHD item)
{
string sql = "update CHITIETHOADON set SoLuong = SoLuong + " + item.SoLuong + " where idHoaDon = '" + item.IdHoaDon + "' and idMonAn = '" + item.IdMonAn + "'";
KetNoiCSDL.NonQuery(sql);
}
public static DataTable GetBillItem(DTO.CTHD item)
{
string sql = "select * from CHITIETHOADON where idHoaDon = '" + item.IdHoaDon + "' and idMonAn = '" + item.IdMonAn + "'";
return(KetNoiCSDL.Query(sql));
}
public static void Insert(DTO.CTHD item)
{
string sql = "insert into CHITIETHOADON(idHoaDon, idMonAn, SoLuong) values ('" + item.IdHoaDon + "', '" + item.IdMonAn + "', " + item.SoLuong + ")";
KetNoiCSDL.NonQuery(sql);
}
