/// <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);
}
//查询优惠券1
public List <Discounts> GetDiscounts1()
{
string sql = "select * from Discounts where DisId=1";
return(_db.GetList <Discounts>(sql));
}