Ejemplo n.º 1
0
        /// <summary>
        /// 获取购物车商品
        /// </summary>
        /// <param name="num"></param>
        /// <returns></returns>
        public List <SelAll> GetShopping(string num)
        {
            string        sql  = $"select * from Shopping a join  Commodity b on a.CommNum=b.CommNum where a.CommNum='{num}'";
            List <SelAll> list = db.GetList <SelAll>(sql);

            return(list);
        }
Ejemplo n.º 2
0
        //查询优惠券1
        public List <Discounts> GetDiscounts1()
        {
            string sql = "select * from Discounts where DisId=1";

            return(_db.GetList <Discounts>(sql));
        }