using System.Collections.Generic;
using System.Linq;
using WX.CRM.IBLL.Wx;
using WX.CRM.Model.Entity;

namespace WX.CRM.BLL.Wx
{
    public class WX_SZZYORDERPAY_BL : DbContextRepository<WX_SZZYORDERPAY>, IWX_SZZYORDERPAY
    {
        public List<OrderPay> GetPays(int orderId)
        {
            using (var db = new crmContext())
            {
                var query = from p in db.WX_SZZYORDERPAY
                            join o in db.WX_SZZYORDER on p.ORDERID equals o.ORDERID
                            where p.ORDERID == orderId
                            select new OrderPay()
                            {
                                OrderId = p.ORDERID,
                                ProductId = o.SUBPRODUCTID.Value,
                                ProductName = o.SUBPRODUCTNAME,
                                PayType = p.PAYTYPE,
                                PayName = p.PAYNAME,
                                AuditStatus = p.AUDITSTATUS,
                                PayPrice = p.PAYPRICE,
                                Ctime = p.CTIME,
                                TradeNo = p.TRADENO
                                //Link = p.Link,
                                //Qrcode = p.QRCode
                            };
                return query.ToList();
            }
        }
    }
}