public List <ItemsDetailEntity> GetList(string itemId = "", string keyword = "") { var expression = ExtLinq.True <ItemsDetailEntity>(); if (!string.IsNullOrEmpty(itemId)) { expression = expression.And(t => t.F_ItemId == itemId); } if (!string.IsNullOrEmpty(keyword)) { expression = expression.And(t => t.F_ItemName.Contains(keyword)); expression = expression.Or(t => t.F_ItemCode.Contains(keyword)); } return(service.IQueryable(expression).OrderBy(t => t.F_SortCode).ToList()); }
public List <ItemsDetailEntity> GetItemsDetail(string encode) { var expression = ExtLinq.True <ItemsEntity>(); if (!string.IsNullOrEmpty(encode)) { expression = expression.And(t => t.F_EnCode.Contains(encode)); } ItemsEntity itemType = serviceItem.FindEntity(expression); List <ItemsDetailEntity> details = new List <ItemsDetailEntity>(); details = serviceItemDetails.IQueryable().ToList().Where(t => t.F_ItemId == itemType.F_Id).ToList(); return(details); }
public List <MemberEntity> GetList(Pagination pagination, string keyword) { var expression = ExtLinq.True <MemberEntity>(); if (!string.IsNullOrEmpty(keyword)) { expression = expression.And(t => t.FullName.Contains(keyword) || t.ContactNumber.Contains(keyword) || t.VisitingCardNumber.Contains(keyword) || t.CredentialInformation.Contains(keyword)); } List <MemberEntity> list = service.FindList(expression, pagination); foreach (var info in list) { info.Nationality = ItemsDetailService.IQueryable(item => item.F_Id == info.Nationality).FirstOrDefault().F_ItemName; } return(list); }
public Task <List <ItemsDetailEntity> > GetList(string itemId, string keyword, string tenantId) { var expression = ExtLinq.True <ItemsDetailEntity>(); if (!string.IsNullOrEmpty(itemId)) { expression = expression.And(t => t.ItemId == itemId); } if (!string.IsNullOrEmpty(keyword)) { expression = expression.And(t => t.ItemName.Contains(keyword)); expression = expression.Or(t => t.ItemCode.Contains(keyword)); } expression = expression.And(x => x.TenantId == tenantId); return(service.IQueryable(expression).OrderBy(t => t.SortCode).ToListAsync()); }
public List <ItemsDetailEntity> GetList(string itemId = "", string keyword = "") { //cacheKey = cacheKey + "0_" + itemId + "_" + keyword;//拼接有参key值 //var cacheList = cache.GetCache<List<ItemsDetailEntity>>(cacheKey); //if (cacheList == null) //{ var expression = ExtLinq.True <ItemsDetailEntity>(); if (!string.IsNullOrEmpty(itemId)) { expression = expression.And(t => t.F_ItemId == itemId); } if (!string.IsNullOrEmpty(keyword)) { expression = expression.And(t => t.F_ItemName.Contains(keyword)); expression = expression.Or(t => t.F_ItemCode.Contains(keyword)); } var cacheList = service.IQueryable(expression).OrderBy(t => t.F_SortCode).ToList(); // cache.WriteCache<List<ItemsDetailEntity>>(cacheList, cacheKey, "UserCacheDependency", "Sys_ItemsDetail"); //} return(cacheList); }
public List <ItemsDetailEntity> GetList() { return(service.IQueryable().ToList()); }