/// <summary> /// 查询某个id的店铺管理人员 /// </summary> public List <XMPost> GetXMPostListById(int id) { //IQueryable<XMPost> var query = from p in this._context.XMPosts join s in this._context.XMNickCustomerMappings on p.Id equals s.CustomerTypeID into JoinedPB from s in JoinedPB.DefaultIfEmpty() join b in this._context.CustomerInfoes on s.CustomerID equals b.CustomerID into JoinedPB2 from b in JoinedPB2.DefaultIfEmpty() where p.IsEnable == false && s.NickId == id select new XMPost { Post = p.Post, FullName = b.FullName, Id = s.NickCustomerID }; return(new List <XMPost>(query).ToList()); // string sql = @"select p.Post from XM_Post p // join XM_Nick_Customer_Mapping N on p.Id=N.CustomerTypeID // join Sys_CustomerInfo b on N.CustomerID=b.CustomerID // where p.IsEnable='false' and N.NickId={0} "; // var XMPostList = this._context.ExecuteStoreQuery<XMPost>(sql, id).ToList();//, "%" + shopManager + "%" // return XMPostList.ToList(); }
/// <summary> /// 根据商品名称、是赠品 查询商品名称、商品编码、尺寸、出厂价 /// </summary> /// <param name="ProductName"></param> /// <returns></returns> public List <XMProductDetailsMapping> GetXMProductDetailsByProductName(string ProductName) { //var query = from p in this._context.XMProducts // join b in this._context.XMProductDetails // on p.Id equals b.ProductId // where p.ProductName.Contains(ProductName) // && p.IsEnable.Value == false // && b.IsEnable.Value == false // && p.IsPremiums == true // select new XMProductDetailsMapping // { // Id = p.Id, // ProductName = p.ProductName, // ManufacturersCode = p.ManufacturersCode, // Specifications = p.Specifications, // Costprice = b.Costprice // }; //return new List<XMProductDetailsMapping>(query); //&& b.IsEnable.Value == false //左链接 var query = from p in this._context.XMProducts join b in this._context.XMProductDetails on p.Id equals b.ProductId into JoinedPB from b in JoinedPB.DefaultIfEmpty() where p.ProductName.Equals(ProductName) && p.IsEnable.Value == false && b.IsEnable == false && p.IsPremiums == true select new XMProductDetailsMapping { Id = p.Id, ProductName = p.ProductName, ManufacturersCode = p.ManufacturersCode, Specifications = p.Specifications, Costprice = b.Costprice, PlatformMerchantCode = b.PlatformMerchantCode, DetailId = b.Id }; return(new List <XMProductDetailsMapping>(query.Distinct()).ToList()); }