/// <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>
/// <param name="PhoneNumber"></param>
/// <param name="PassWord"></param>
/// <param name="Email"></param>
/// <returns></returns>
public string FindPwd(string PhoneNumber, string PassWord, string Email)
{
UserInfo info = OrmDBHelper.GetModel <UserInfo>("select PassWord from UserInfo where PhoneNumber='" + PhoneNumber + "' and PassWord='******'");
string res = "";
if (info != null)
{
res = info.PassWord;
}
return(res);
}
/// <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);
}
///修改密码
public int EditUserPwd(string pwd, string PhoneNumber)
{
try
{
var bus = UserInfoLogin.GenerateSalt();
int res = 0;
string sql = "update UserInfo set Password='******' , Salt='" + bus + "' where PhoneNumber='" + PhoneNumber + "'";
res = OrmDBHelper.ExecuteNonQuery(sql);
return(res);
}
catch (Exception ex)
{
string res = ex.Message;
throw;
}
}
/// <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);
}
