/// <summary>
/// raw image
/// </summary>
/// <param name="d"></param>
private void SetUIDisplayFeilds(ZZOrderDetail d)
{
if (d == null)
{
return;
}
d.Preview1 = warpPath(d.Preview1);
d.Preview2 = warpPath(d.Preview2);
var s = JsonConvert.DeserializeObject <ZZDesignSetting>(d.DesginSettings);
d.CustomerImg1 = warpPath(s.front, d.DesignId, string.Format("{0}_1", d.DesignId));
d.CustomerImg2 = warpPath(s.back, d.DesignId, string.Format("{0}_2", d.DesignId));
d.OrderStatusDesc = getOrderStatusById(d.OrderStatus);
}
public ZZOrderDetail GetOrderInfo(Guid orderId)
{
var result = new ZZOrderDetail();
var orderPred = PredicateBuilder.New <ZZ_Order>(x => x.OrderId == orderId);
using (var db = GetDbContext())
{
var tmp = from o in db.ZZ_Order.AsExpandable().Where(orderPred)
join u in db.ZY_Customer on o.CustomerId equals u.OpenId
join d in db.ZZ_Desgin on o.DesignId equals d.DesginId
join du in db.ZY_Customer on d.CustomerId equals du.OpenId
join t in db.ZZ_Template on d.TemplateId equals t.TemplateId
join c in db.ZZ_Category on t.Category equals c.CategoryId
join a in db.ZZ_OrderAddress on o.SubmissionId equals a.SubmissionId
join ad in db.ZZ_Address on a.AddressId equals ad.AddressId
select new ZZOrderDetail()
{
OrderId = o.OrderId,
DesignId = o.DesignId,
TrackingNumber = o.TrackingNumber,
CheckOutDate = o.CheckOutDate.Value,
CustomerName = u.UserName,
DesginName = d.Name,
OrderStatus = o.OrderStatus,
Preview = d.Preview1,
ProductType = c.Name,
Quiantity = o.Quiantity,
TotalAmount = o.TotalAmount,
Desginer = du.UserName,
Preview1 = d.Preview1,
Preview2 = d.Preview2,
Color = o.Color,
DesginSettings = d.DesginSettings,
ContactName = ad.ContactName,
Phone = ad.Phone,
AddressLine1 = ad.AddressLine1,
Town = ad.Town,
City = ad.City,
Province = ad.Province
};
result = tmp.FirstOrDefault();
SetUIDisplayFeilds(result);
}
return(result);
}
