Dao/CartRepository.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

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

using Domain;
using IDao;
using Entity.Common;
using System;
using System.Collections.Generic;
using System.Globalization;
using System.Linq;
using System.Text;
using Common;
using PWMIS.DataMap.Entity;

namespace Dao
{
    /// <summary>
    /// CartCategory 仓储
    /// </summary>
    public class CartCategoryRepository : Repository<CartMdl>, ICartRepository
    {

        /// <summary>
        /// API获取购物车菜品
        /// </summary>
        /// <param name="categoryid"></param>
        /// <param name="shopid"></param>      
        /// <returns></returns>
        public IList<CartDetaiMdllExt> GetCartDetailByCustomerId(string CustomerId, string Shop_ID)
        {
            try
            {

                CartDetaiMdllExt cartDetail = new CartDetaiMdllExt();
                CartMdl cart = new CartMdl();
                DishMenuMdl dish= new DishMenuMdl();

                OQL oql = OQL.From(cartDetail).InnerJoin(cart).On(cartDetail.Cart_ID, cart.ID).InnerJoin(dish).On(dish.ID,cartDetail.DishMenu_ID).Select(cartDetail.ID, cartDetail.UnitPrice,dish.SmartImagUrl, cartDetail.Cart_ID, cartDetail.DishMenuName, cartDetail.Quantity, cartDetail.DishMenu_ID).Where(
                       cmp => cmp.Comparer(cartDetail.Cart_ID, "=", cart.ID) &
                       cmp.Comparer(cart.Customer_ID, "=", CustomerId) &
                       cmp.Comparer(cart.Shop_ID, "=", Shop_ID)
                   ).END;

                var cartDetails = EntityQuery<CartDetaiMdllExt>.QueryList(oql).ToList();

                return cartDetails;

            }
            catch
            {
                return null;
            }


        }

        public bool InsertCart(CartMdl cart, List<CartDetailMdl> details)
        {
            try
            {
                //先清理购物车