/// <summary> /// 获取订单中的死信息 /// </summary> /// <param name="UserId"></param> /// <param name="BusinessId"></param> /// <returns></returns> public OrderShow GetOrderShow(int UserId, int BusinessId) { this.UserId = UserId; this.UserId = BusinessId; OrderShow order = OrmDBHelper.GetToList <OrderShow>(@"SELECT SUM(cd.ToPrice) AS TotalPrice, c.Id, u.NickName, b.Name, u.PhoneNumber, b.PhoneNumber AS BusinessNumber, b.Merchataddress FROM dbo.CartInfo AS c JOIN dbo.CartDetails AS cd ON c.Id = cd.CartId JOIN dbo.BusinessInfo AS b ON b.Id = c.BusinessInfo JOIN dbo.UserInfo AS u ON c.UserId = u.Id WHERE c.UserId = " + UserId + " AND c.BusinessInfo = " + BusinessId + " AND c.Sates = 1 GROUP BY b.Name, b.PhoneNumber, c.Id, u.NickName, u.PhoneNumber, b.Merchataddress").FirstOrDefault(); order.list = GetListOrders(UserId, BusinessId); return(order); }
/// <summary> /// 显示商品详情商品详情 /// </summary> /// <param name="userid"></param> /// <returns></returns> public MenuDetail GetMenuDetail(int menuid) { string sql = $@"select * from [dbo].[MenuInfo] as m where m.Id=" + menuid; List <MenuDetail> infos = OrmDBHelper.GetToList <MenuDetail>(sql); MenuDetail menu = infos.FirstOrDefault(); return(menu); }
/// <summary> /// 获取用户地址信息 /// </summary> /// <param name="UserId"></param> /// <returns></returns> public List <OrderAddress> GetOrders(int UserId) { string sql = @"SELECT ad.Id,ad.Content,ae.Name FROM dbo.AddressInfo AS ad JOIN dbo.Arealnfo AS ae ON ad.Area=ae.Id WHERE UserId=" + UserId + " AND Sates=1"; List <OrderAddress> orders = OrmDBHelper.GetToList <OrderAddress>(sql); return(orders); }
/// <summary> /// 获取订单的总价 /// </summary> /// <returns></returns> public decimal GetOrderPrice(string Ids) { Ids = Ids.Replace('"', ' '); Ids = Ids.Replace('[', ' '); Ids = Ids.Replace(']', ' '); List <GetPriceModel> models = OrmDBHelper.GetToList <GetPriceModel>("SELECT cd.Count,cd.ToPrice FROM dbo.CartDetails AS cd WHERE cd.Sates=1 AND cd.Id IN(" + Ids + ")"); decimal ToPrice = 0; foreach (var item in models) { ToPrice = ToPrice + (item.ToPrice * item.Count); } return(ToPrice); }
/// <summary> /// 获取订单详情 /// </summary> /// <param name="UserId"></param> /// <returns></returns> public List <OderOrderDetailsShow> GetOrderDetails(int UserId) { string sql = @"SELECT m.Img,m.Name,m.Price,od.Count,od.CreateTime,ar.Name AS Arname,ad.Content FROM dbo.OrderDetails AS od JOIN dbo.MenuInfo AS m ON od.DetailsId = m.Id JOIN dbo.OrderInfo AS o ON o.Id=od.OrderId JOIN dbo.AddressInfo AS Ad ON o.AddressId=Ad.Id JOIN dbo.CityInfo AS c ON ad.CityId=c.Id JOIN dbo.Arealnfo AS ar ON ad.Area=ar.Id WHERE OrderId IN(SELECT o.Id FROM dbo.UserInfo AS u JOIN dbo.OrderInfo AS o ON u.Id = o.UserId WHERE u.Id =" + UserId + " AND o.[Sates] = 1)AND Od.Sates = 1;"; List <OderOrderDetailsShow> orders = OrmDBHelper.GetToList <OderOrderDetailsShow>(sql); return(orders); }
/// <summary> /// 显示购物车 /// </summary> /// <returns></returns> public List <CartInfos> GetCartInfos(int userid) { try { string sql = $@"select c.Id, m.Img,m.Name,m.Price,c.Count,c.ToPrice from CartDetails as c join CartInfo as a on c.CartId=a.Id join MenuInfo as m on c.DetailsId =m.Id where c.[Sates]=1 and a.UserId={userid} order by c.Id desc"; List <CartInfos> infos = OrmDBHelper.GetToList <CartInfos>(sql); return(infos); } catch (Exception ex) { string a = ex.Message; throw; } }
/// <summary> /// 查询出订单的list信息 /// </summary> /// <param name="UserId"></param> /// <param name="BusinessId"></param> /// <returns></returns> public List <ListOrder> GetListOrders(int UserId, int BusinessId) { List <ListOrder> orders = OrmDBHelper.GetToList <ListOrder>(@"SELECT m.Name, m.Img, cd.ToPrice FROM dbo.CartInfo AS c JOIN dbo.CartDetails AS cd ON c.Id=cd.CartId JOIN dbo.BusinessInfo AS b ON b.Id=c.BusinessInfo JOIN dbo.UserInfo AS u ON c.UserId=u.Id JOIN dbo.MenuInfo AS m ON m.Id=cd.DetailsId WHERE c.UserId =" + UserId + " AND c.BusinessInfo=" + BusinessId + " AND c.Sates=1 "); return(orders); }
/// <summary> /// 获取省份集合,用作下拉 /// </summary> /// <returns></returns> public List <ProvinceInfo> GetProvinceInfos() { List <ProvinceInfo> infos = OrmDBHelper.GetToList <ProvinceInfo>("SELECT * FROM dbo.ProvinceInfo"); return(infos); }
/// <summary> /// 获取城市集合,用作下拉 /// </summary> /// <returns></returns> public List <CityInfo> GetCityInfos(int provinceId) { List <CityInfo> infos = OrmDBHelper.GetToList <CityInfo>("SELECT * FROM dbo.CityInfo WHERE ProvinceId =" + provinceId); return(infos); }
/// <summary> /// 获取城市集合,用作下拉 /// </summary> /// <returns></returns> public List <Arealnfo> GetArealnfos(int cityId) { List <Arealnfo> infos = OrmDBHelper.GetToList <Arealnfo>("SELECT * FROM dbo.Arealnfo WHERE CityId= " + cityId); return(infos); }