/// <summary> /// 获取关注记录 /// </summary> /// <param name="AttentionQueryModel"></param> /// <returns></returns> public PageModel <Attention> GetAttentions(AttentionQuery AttentionQueryModel) { IQueryable <Attention> AttentionShop = from item in base.context.Attention where item.UserId == AttentionQueryModel.UserId.Value select item; if (!string.IsNullOrWhiteSpace(AttentionQueryModel.beginTime)) { DateTime dt; if (DateTime.TryParse(AttentionQueryModel.beginTime, out dt)) { DateTime value = DateTime.Parse(AttentionQueryModel.beginTime); AttentionShop = from d in AttentionShop where d.CreatDate >= value select d; } } //end time if (!string.IsNullOrWhiteSpace(AttentionQueryModel.endTime)) { DateTime dt; if (DateTime.TryParse(AttentionQueryModel.endTime, out dt)) { DateTime value = DateTime.Parse(AttentionQueryModel.endTime); AttentionShop = from d in AttentionShop where d.CreatDate <= value select d; } } if (!string.IsNullOrEmpty(AttentionQueryModel.productName)) { AttentionShop = from item in AttentionShop where item.ProductName.Contains(AttentionQueryModel.productName) select item; } if (!string.IsNullOrEmpty(AttentionQueryModel.compamyName)) { AttentionShop = from item in AttentionShop where item.CompanyName.Contains(AttentionQueryModel.compamyName) select item; } if (!string.IsNullOrEmpty(AttentionQueryModel.userName)) { AttentionShop = from item in AttentionShop where item.UserName.Contains(AttentionQueryModel.userName) select item; } Func <IQueryable <Attention>, IOrderedQueryable <Attention> > func = null; func = (IQueryable <Attention> d) => from o in d orderby o.CreatDate descending select o; int num = AttentionShop.Count(); AttentionShop = AttentionShop.GetPage(out num, AttentionQueryModel.PageNo, AttentionQueryModel.PageSize, func); foreach (Attention list in AttentionShop.ToList()) { ShopInfo shopInfo = context.ShopInfo.FirstOrDefault((ShopInfo m) => m.Id.Equals(list.ShopId)); if (shopInfo != null) { list.CompanyName = shopInfo.ShopName; } UserMemberInfo UserInfo = context.UserMemberInfo.FirstOrDefault((UserMemberInfo m) => m.Id.Equals(list.UserId) && m.UserType == 3); if (UserInfo != null) { list.UserName = UserInfo.UserName; } ProductInfo productInfo = context.ProductInfo.FirstOrDefault((ProductInfo m) => m.Id.Equals(list.ProductId)); if (productInfo != null) { list.ProductName = (productInfo == null ? "" : productInfo.ProductName); list.ImagePath = (productInfo == null ? "" : productInfo.ImagePath); list.MarketPrice = productInfo.MarketPrice; list.MinSalePrice = productInfo.MinSalePrice; list.MeasureUnit = productInfo.MeasureUnit; list.EProductName = productInfo.EProductName; list.Purity = productInfo.Purity; list.CASNo = productInfo.CASNo; list.HSCODE = productInfo.HSCODE; list.DangerLevel = productInfo.DangerLevel; list.MolecularFormula = productInfo.MolecularFormula; list.MolecularWeight = productInfo.MolecularWeight; list.PASNo = productInfo.PASNo; list.LogP = productInfo.LogP; list.Shape = productInfo.Shape; list.Density = productInfo.Density; list.FusingPoint = productInfo.FusingPoint; list.BoilingPoint = productInfo.BoilingPoint; list.RefractiveIndex = productInfo.RefractiveIndex; list.StorageConditions = productInfo.StorageConditions; list.VapourPressure = productInfo.VapourPressure; list.PackagingLevel = productInfo.PackagingLevel; list.SafetyInstructions = productInfo.SafetyInstructions; list.DangerousMark = productInfo.DangerousMark; list.RiskCategoryCode = productInfo.RiskCategoryCode; list.TransportationNmber = productInfo.TransportationNmber; list.RETCS = productInfo.RETCS; list.WGKGermany = productInfo.WGKGermany; list.SyntheticRoute = productInfo.SyntheticRoute; list.RelatedProducts = productInfo.RelatedProducts; list.MSDS = productInfo.MSDS; list.NMRSpectrum = productInfo.NMRSpectrum; list.RefuseReason = productInfo.RefuseReason; list.STRUCTURE_2D = productInfo.STRUCTURE_2D; } } return(new PageModel <Attention>() { Models = AttentionShop, Total = num }); }
public JsonResult List(string starttime, string endtime, string productName, string userName, int rows, int page, string companyName) //string companyName, { AttentionQuery AttentionQueryModel = new AttentionQuery() { ShopId = base.CurrentSellerManager.ShopId, beginTime = starttime, endTime = endtime, userName = userName, productName = productName, compamyName = companyName, PageSize = rows, PageNo = page, }; PageModel <Attention> AttentionShops = ServiceHelper.Create <IAttentionService>().SupplierGetAttentions(AttentionQueryModel); IEnumerable <AttentionModel> array = from m in AttentionShops.Models.ToArray() select new AttentionModel() { Id = m.Id, UserId = m.UserId, ShopId = m.ShopId, ProductId = m.ProductId, CreatDate = m.CreatDate, ProductName = m.ProductName, ImagePath = m.ImagePath, MarketPrice = m.MarketPrice, MinSalePrice = m.MinSalePrice, MeasureUnit = m.MeasureUnit, EProductName = m.EProductName, Purity = m.Purity, CASNo = m.CASNo, HSCODE = m.HSCODE, DangerLevel = m.DangerLevel, MolecularFormula = m.MolecularFormula, MolecularWeight = m.MolecularWeight, PASNo = m.PASNo, LogP = m.LogP, Shape = m.Shape, Density = m.Density, FusingPoint = m.FusingPoint, BoilingPoint = m.BoilingPoint, RefractiveIndex = m.RefractiveIndex, StorageConditions = m.StorageConditions, VapourPressure = m.VapourPressure, PackagingLevel = m.PackagingLevel, SafetyInstructions = m.SafetyInstructions, DangerousMark = m.DangerousMark, RiskCategoryCode = m.RiskCategoryCode, TransportationNmber = m.TransportationNmber, RETCS = m.RETCS, WGKGermany = m.WGKGermany, SyntheticRoute = m.SyntheticRoute, RelatedProducts = m.RelatedProducts, MSDS = m.MSDS, NMRSpectrum = m.NMRSpectrum, RefuseReason = m.RefuseReason, STRUCTURE_2D = m.STRUCTURE_2D, UserName = m.UserName, CompanyName = m.CompanyName }; DataGridModel <AttentionModel> dataGridModel = new DataGridModel <AttentionModel>() { rows = array, total = AttentionShops.Total }; return(Json(dataGridModel)); }