示例#1
0
        public List <TR01A> GetMany(SearchViewModel searchViewModel)
        {
            var queryData = _Repository.GetQuery();

            if (!string.IsNullOrWhiteSpace(searchViewModel.Type))
            {
                if (searchViewModel.Type == "A")
                {
                    queryData = queryData.Where(x => x.DA03A_ID == 1 || x.DA03A_ID == 2);
                }
                else
                {
                    queryData = queryData.Where(x => x.DA03A_ID == 2 || x.DA03A_ID == 3);
                }
            }
            if (searchViewModel.DT_BEG_STR != "")
            {
                queryData = queryData.Where(x => x.TRN_DT.CompareTo(searchViewModel.DT_BEG_STR) >= 0);
            }
            if (searchViewModel.DT_END_STR != "")
            {
                queryData = queryData.Where(x => x.TRN_DT.CompareTo(searchViewModel.DT_END_STR) <= 0);
            }
            return(queryData.ToList());
        }
示例#2
0
 public IQueryable <TR01A> GetQueryable()
 {
     return(_Repository.GetQuery());
 }