/// <summary> /// 列表查询 /// </summary> /// <param name="PAQuery"></param> /// <returns></returns> public PageModel <ProductAuthentication> GetProductAuthenticationList(ProductAuthenticationQuery PAQuery) { int num = 0; IQueryable <ProductAuthentication> PA = context.ProductAuthentication.AsQueryable <ProductAuthentication>(); if (!string.IsNullOrWhiteSpace(PAQuery.ComName)) { PA = from d in PA where d.ComName.Contains(PAQuery.ComName) orderby d.ProductAuthDate descending select d; } if (!string.IsNullOrWhiteSpace(PAQuery.ProductCode)) { PA = from d in PA where d.ProductCode.Equals(PAQuery.ProductCode) orderby d.ProductAuthDate descending select d; } if (!string.IsNullOrWhiteSpace(PAQuery.AuthStatus)) { int i; if (int.TryParse(PAQuery.AuthStatus, out i)) { int k = int.Parse(PAQuery.AuthStatus); PA = from d in PA where d.AuthStatus == k orderby d.ProductAuthDate descending select d; } } if (!string.IsNullOrWhiteSpace(PAQuery.ManageId.ToString()) && PAQuery.ManageId != 0) { PA = from d in PA where d.ManageId == PAQuery.ManageId orderby d.ProductAuthDate descending select d; } PA = PA.GetPage(out num, PAQuery.PageNo, PAQuery.PageSize, (IQueryable <ProductAuthentication> d) => from o in d orderby o.ProductAuthDate descending select o); return(new PageModel <ProductAuthentication>() { Models = PA, Total = num }); }
public JsonResult ListProductAuthentication(int page, int rows, string comname, string productCode, string AuthStatus) { IProductAuthenticationService IPAS = ServiceHelper.Create <IProductAuthenticationService>(); ProductAuthenticationQuery PAQ = new ProductAuthenticationQuery() { ComName = comname, ProductCode = productCode, AuthStatus = AuthStatus, PageNo = page, PageSize = rows, }; PageModel <ProductAuthentication> pm = IPAS.GetProductAuthenticationList(PAQ); IEnumerable <ProductAuthentication> models = from item in pm.Models.ToArray() select new ProductAuthentication() { Id = item.Id, ManageId = item.ManageId, ProductCode = item.ProductCode, ProductIMG = item.ProductIMG, ProductDesc = item.ProductDesc, ProductAuthDate = item.ProductAuthDate, AuthStatus = item.AuthStatus, AuthAuthor = item.AuthAuthor, AuthTime = item.AuthTime, AuthDesc = item.AuthDesc, ComName = item.ComName, ComAttachment = item.ComAttachment }; DataGridModel <ProductAuthentication> dataGridModel = new DataGridModel <ProductAuthentication>() { rows = models, total = pm.Total }; return(Json(dataGridModel)); }