private IQueryable<MembershipEntity> SelectOrScrrenMember(GetMemberInput input)
{
string[] userDefinedFilter = null; if (!input.UserDefinedFilter.IsNullOrWhiteSpace())
{
userDefinedFilter = input.UserDefinedFilter.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries);//不保留空元素
} var query = from m in _memberRepository.GetAll()
join s in _VipcardRepository.GetAll() on m.Id equals s.MEMBER_CODE
join g in _VipcardgradeRepository.GetAll() on s.VIP_CARD_GRADE equals g.CARDGRADECODE
select new MembershipEntity
{
Id = m.Id,
ENGLISH_NAME = m.ENGLISH_NAME,
CHINESE_NAME = m.CHINESE_NAME,
E_MAIL = m.E_MAIL,
PHONE_NO_MOBILE = m.PHONE_NO_MOBILE,
PHONE_NO_HOME = m.PHONE_NO_HOME,
PHONE_NO_OFFICE = m.PHONE_NO_OFFICE,
ID_NO = m.ID_NO,
REMARK = m.REMARK,
CARD_NO = s.CARD_NO,
VIP_CARD_GROUP = s.VIP_CARD_GROUP,
VIP_CARD_GRADE = s.VIP_CARD_GRADE,
CARDGRADEDESC = g.CARDGRADEDESC,
IS_ARTIST = m.IS_ARTIST,
STATUS = m.STATUS,
UserDefinedField = m.USER_DEFINED_FIELD
};
query = query.WhereIf(!input.ENGLISH_NAME.IsNullOrWhiteSpace(), item => item.ENGLISH_NAME.Contains(input.ENGLISH_NAME))
.WhereIf(!input.MEMBER_CODE.IsNullOrWhiteSpace(), item => item.Id.Contains(input.MEMBER_CODE))
.WhereIf(!input.PHONE_NO_HOME.IsNullOrWhiteSpace(), item => item.PHONE_NO_HOME.Contains(input.PHONE_NO_HOME))
.WhereIf(!input.PHONE_NO_MOBILE.IsNullOrWhiteSpace(), item => item.PHONE_NO_MOBILE.Contains(input.PHONE_NO_MOBILE)); if (userDefinedFilter != null)
{
foreach (var filter in userDefinedFilter)
{
query = query.Where(item => item.UserDefinedField.Contains(filter));
}
} return query; }