public static void UpdateChiTietBan(ChiTietBanModel ctb)
{
using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString()))
{
cnn.Execute("update chitietban set SOLUONG=@SoLuong,THANHTIEN=@ThanhTien WHERE MAPHIEUMUAHANG = @maPhieuMuaHang and MASP = @maSP", ctb);
}
}
public static void RemoveChiTietBan(ChiTietBanModel ctb)
{
using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString()))
{
cnn.Execute("DELETE FROM CHITIETBAN WHERE MAPHIEUMUAHANG = @maPhieuMuaHang and MASP = @maSP", ctb);
}
}
public static long SaveChiTietBan(ChiTietBanModel ctb)
{
using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString()))
{
long lastRowID = (long)cnn.ExecuteScalar("insert into chitietban(MAPHIEUBAN,MASP,SOLUONG,THANHTIEN) values (@MaPhieuBan,@MaSP,@SoLuong,@ThanhTien); SELECT last_insert_rowid()", ctb);
//lastRowID dùng để xác định ID của một hàng vừa được thêm vào.
return(lastRowID);
}
}
