/// <summary> /// 根据关键字搜索客户信息 /// </summary> /// <param name="KeyWord"></param> /// <param name="TopSize"></param> /// <returns></returns> public List <CusAddressEntity> SearchCustomer(string KeyWord, int TopSize) { CusAddressEntity entity = new CusAddressEntity(); entity.IncludeAll(); entity.OrderBy(a => a.ID, EOrderBy.DESC); entity.Where(a => a.CompanyID == this.CompanyID); CustomerEntity customer = new CustomerEntity(); customer.Include(a => new { CusNum = a.CusNum, CusName = a.CusName, CusType = a.CusType, Fax = a.Fax, Email = a.Email }); entity.Left <CustomerEntity>(customer, new Params <string, string>() { Item1 = "CustomerSN", Item2 = "SnNum" }); customer.And(a => a.IsDelete == (int)EIsDelete.NotDelete); PageInfo pageInfo = new PageInfo() { PageIndex = 1, PageSize = 10 }; customer.AndBegin <CustomerEntity>() .Or <CustomerEntity>("CusNum", ECondition.Like, "%" + KeyWord + "%") .Or <CustomerEntity>("CusName", ECondition.Like, "%" + KeyWord + "%") .Or <CustomerEntity>("Phone", ECondition.Like, "%" + KeyWord + "%") .End(); int rowCount = 0; List <CusAddressEntity> listResult = this.CusAddress.GetList(entity, pageInfo.PageSize, pageInfo.PageIndex, out rowCount); pageInfo.RowCount = rowCount; return(listResult); }