static void Main(string[] args)
{
var service = new OrderService();
for (int i = 1; i <= 10; i++)//填充 10 个随机订单
{
service.AddOrder(RandomOrder.RandOrder());
}
service.Export("service.xml"); //导出到 xml
service = OrderService.Import("service.xml"); //从 xml 导入
//用 LINQ 语法查询
var result = from order in service
where order.PriceSum > 10
orderby order.Id
select order;
foreach (var order in result)
{
Console.WriteLine(order);
Console.WriteLine("---------------------------------");
}
}
static void Main(string[] args)
{
var service = new SqliteOrderService(
"C:/Users/zhb/Documents/sqlitedb/order.db");
service.DeleteAllData(); //删除之前的数据
for (int i = 1; i <= 10; i++) //填充 10 个随机订单
{
service.AddOrder(RandomOrder.RandOrder());
}
//用 LINQ 语法查询
Console.WriteLine("查询总价超过 200 元的订单，按订单 ID 排序。");
var result = from order in service
where order.PriceSum > 200
orderby order.OrderId
select order;
foreach (var order in result)
{
Console.WriteLine(order);
Console.WriteLine("---------------------------------");
}
Console.WriteLine("查询含单价超过 50 元商品的订单，按订单 ID 排序。");
result = from order in service
where order.OrderDetails.Find(detail => detail.Commodity.Price > 50) != null
orderby order.OrderId
select order;
foreach (var order in result)
{
Console.WriteLine(order);
Console.WriteLine("---------------------------------");
}
}