狠狠色丁香婷婷综合尤物/久久精品综合一区二区三区/中国有色金属学报/国产日韩欧美在线观看 - 国产一区二区三区四区五区tv

using System;using System.Collections.Generic;using Newtonsoft.Json; // 需要安裝 NuGet 包：Newtonsoft.Json
public class Order{    public int OrderId { get; set; }    public int CustomerId { get; set; }    public DateTime OrderDate { get; set; }    public string OrderItemsJson { get; set; } // 存儲訂單項的 JSON 字符串}
public class OrderItem{    public int OrderItemId { get; set; }    public int ProductId { get; set; }    public int Quantity { get; set; }    public decimal UnitPrice { get; set; }}

class Program{    static void Main(string[] args)    {        // 創(chuàng)建示例訂單和訂單項        Order order = new Order        {            OrderId = 1,            CustomerId = 123,            OrderDate = DateTime.Now,            OrderItemsJson = SerializeOrderItems(new List<OrderItem>            {                new OrderItem{ OrderItemId = 1, ProductId = 456, Quantity = 2, UnitPrice = 12.50m },                new OrderItem{ OrderItemId = 2, ProductId = 789, Quantity = 3, UnitPrice = 15.00m }            })        };
        // 顯示結(jié)果        Console.WriteLine("訂單ID: " + order.OrderId);        Console.WriteLine("客戶ID: " + order.CustomerId);        Console.WriteLine("訂單日期: " + order.OrderDate);        Console.WriteLine("訂單項JSON: " + order.OrderItemsJson);    }
    // 序列化訂單項    static string SerializeOrderItems(List<OrderItem> orderItems)    {        return JsonConvert.SerializeObject(orderItems);    }}

Install-Package Microsoft.EntityFrameworkCoreInstall-Package Microsoft.EntityFrameworkCore.SqliteInstall-Package SQLitePCLRaw.bundle_e_sqlite3

using Microsoft.EntityFrameworkCore;
public class ApplicationDbContext : DbContext{    public DbSet<Order> Orders { get; set; }
    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)    {        optionsBuilder.UseSqlite("Data Source=orders.db"); // 配置數(shù)據(jù)庫連接    }}
// 示例保存過程static void SaveOrderToDatabase(Order order){    using (var context = new ApplicationDbContext())    {        context.Database.EnsureCreated();        context.Orders.Add(order);        context.SaveChanges();    }}
class Program{    static void Main(string[] args)    {        // 初始化SQLite庫        Batteries.Init();
        // 創(chuàng)建示例訂單和訂單項        Order order = new Order        {            OrderId = 1,            CustomerId = 123,            OrderDate = DateTime.Now,            OrderItemsJson = SerializeOrderItems(new List<OrderItem>            {                new OrderItem{ OrderItemId = 1, ProductId = 456, Quantity = 2, UnitPrice = 12.50m },                new OrderItem{ OrderItemId = 2, ProductId = 789, Quantity = 3, UnitPrice = 15.00m }            })        };
        // 保存訂單到數(shù)據(jù)庫        SaveOrderToDatabase(order);    }
    static string SerializeOrderItems(List<OrderItem> orderItems)    {        return JsonConvert.SerializeObject(orderItems);    }}

static Order ReadOrderFromDatabase(int orderId){    using (var context = new ApplicationDbContext())    {        return context.Orders.Find(orderId);    }}
static List<OrderItem> DeserializeOrderItems(string orderItemsJson){    return JsonConvert.DeserializeObject<List<OrderItem>>(orderItemsJson);}
class Program{    static void Main(string[] args)    {        // 根據(jù)訂單ID讀取訂單        Order order = ReadOrderFromDatabase(1);
        if (order != null)        {            List<OrderItem> orderItems = DeserializeOrderItems(order.OrderItemsJson);            Console.WriteLine("讀取到的訂單ID: " + order.OrderId);            Console.WriteLine("訂單項數(shù)量: " + orderItems.Count);        }        else        {            Console.WriteLine("訂單不存在.");        }    }}