Books.Service/OrderDetailService.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using Books.Service.Entity;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.Entity;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Books.Service
{
    public class OrderDetailService
    {
        private BaseService<OrderDetailEntity> bs { get; set; } = new BaseService<OrderDetailEntity>();
        private BookDbContext db { get; set; } = new BookDbContext();
        private OrdersService ordersService { get; set; } = new OrdersService();
        public List<OrderDetailEntity> GetAll(int id,out decimal sum)
        {
            var list= db.Database.SqlQuery<OrderDetailEntity>("select * from OrderDetailEntities as s1 left join BookEntities as s2 on s1.BookId=s2.Id where UserId={0}", id).ToList();
            sum = 0;
            foreach (var item in list)
            {
                item.Book = db.Book.Find(item.BookId);
                item.User= db.User.Find(item.UserId);
                sum += item.Book.Price * (decimal)item.counts;
            }
            return list;
        }
        public int Add(int bookId, int userId, int count)
        {
            var a = new OrderDetailEntity { BookId = bookId,OrderId=1, UserId = userId, counts = count };
            return db.Database.ExecuteSqlCommand("insert into OrderDetailEntities values({0},1,{1},{2},GETDATE(),'false')",userId,bookId,count);
        }
      

        /// <summary>
        /// 将一个用户的购物车添加到订单
        /// </summary>
        /// <param name="orderId"></param>
        /// <param name="userId"></param>
        /// <returns></returns>
        public int AddOrder(OrdersEntity orders,int userId)
        {
            orders.Id = ordersService.Add(orders);
            return db.Database.ExecuteSqlCommand("update OrderDetailEntities set OrderId={0} where UserId={1} ", orders.Id,userId);
        }
    }
}