/// <summary>
/// 订单支付详情
/// </summary>
/// <returns></returns>
public JsonResult <OrderDetailForMobile> GetOrderDetail(int MemberID, string OrderCode)
{
OrderDetailForMobile model = _orderService.GetOrderDetail(MemberID, OrderCode);
return(new JsonResult <OrderDetailForMobile>
{
status = true,
Message = "获取成功",
Data = model
});
}
/// <summary>
/// 订单详情
/// </summary>
/// <param name="orderCode"></param>
/// <returns></returns>
public ActionResult OrderDetail(string id)
{
//订单详情总计
OrderDetailForMobile detail = _orderService.GetOrderDetail(CommonHelper.CurrentUser.MemberID, id);
ViewBag.Detail = detail;
List <OrderDetaisViewModel> list = userOderSv.GetOrderDetails(id);
return(View(list));
}
/// <summary>
/// 获取订单详情
/// </summary>
/// <param name="MemberID"></param>
/// <param name="Status"></param>
/// <param name="orderCode"></param>
/// <returns></returns>
public OrderDetailForMobile GetOrderDetail(int MemberID, string OrderCode)
{
string sql = "declare @OrderCode nvarchar(50),@Names nvarchar(50), @SocialSecurityTotalAmount decimal(18, 2) = 0, @AccumulationFundTotalAmount decimal(18, 2) = 0, @ServiceCost decimal(18, 2) = 0, @FirstBacklogCost decimal(18, 2) = 0, @PaymentMethod nvarchar(50)"
+ " select @OrderCode =[Order].OrderCode, @Names = ISNULL(@Names + '，', '') + OrderDetails.SocialSecurityPeopleName,"
+ " @SocialSecurityTotalAmount += OrderDetails.SocialSecurityAmount * OrderDetails.SocialSecuritypayMonth,"
+ " @AccumulationFundTotalAmount += OrderDetails.AccumulationFundAmount * OrderDetails.AccumulationFundpayMonth,"
+ " @ServiceCost += OrderDetails.SocialSecurityServiceCost + OrderDetails.AccumulationFundServiceCost,"
+ " @FirstBacklogCost += OrderDetails.SocialSecurityFirstBacklogCost + OrderDetails.AccumulationFundFirstBacklogCost"
+ " from[Order] right join OrderDetails on[Order].OrderCode = OrderDetails.OrderCode where [Order].MemberID = @MemberID and [order].OrderCode = @OrderCode1"
+ " select @OrderCode OrderCode, @Names Names, @SocialSecurityTotalAmount SocialSecurityTotalAmount, @AccumulationFundTotalAmount AccumulationFundTotalAmount, @ServiceCost ServiceCost, @FirstBacklogCost FirstBacklogCost, ISNULL(@PaymentMethod, '') PaymentMethod";
OrderDetailForMobile model = DbHelper.QuerySingle <OrderDetailForMobile>(sql, new
{
MemberID = MemberID,
OrderCode1 = OrderCode
});
return(model);
}
