public List <urlDTO> GetResultCheckConfig(DTOrder sort, int start, int length, string search, int type, out int totalRecord, out int count) { { totalRecord = entities.start_url.Count(); search = search.ToLower(); string orderby = sort.Column == 1 ? "ID" : "url"; orderby += sort.Dir == DTOrderDir.DESC ? " DESC" : " ASC"; if (type == 1) { count = entities.url_not_config.Count(); return(entities.url_not_config.Where(m => m.ID.ToString().Contains(search) || m.url.Contains(search)).OrderBy(orderby).Select(m => new urlDTO { ID = m.ID, domain = m.domain, url = m.url }).Skip(start).Take(length).ToList()); } else if (type == 2) { count = entities.url_not_push_to_list.Count(); return(entities.url_not_push_to_list.Where(m => m.ID.ToString().Contains(search) || m.url.Contains(search)).OrderBy(orderby).Select(m => new urlDTO { ID = m.ID, domain = m.domain, url = m.url }).Skip(start).Take(length).ToList()); } count = 0; return(null); } }
public List <Domain> GetResult(DTOrder sort, int start, int length, string search) { { search = search.ToLower(); var configs = from c in entities.Domain where (c.Id.ToString().Contains(search) || c.Domain1.ToString().Contains(search)) select c; if (sort.Column == 0 && sort.Dir == DTOrderDir.ASC) { return(configs.OrderBy(s => s.Id).Skip(start).Take(length).ToList()); } else if (sort.Column == 0 && sort.Dir == DTOrderDir.DESC) { return(configs.OrderByDescending(s => s.Id).Skip(start).Take(length).ToList()); } else if (sort.Column == 1 && sort.Dir == DTOrderDir.ASC) { return(configs.OrderBy(s => s.Domain1).Skip(start).Take(length).ToList()); } else if (sort.Column == 1 && sort.Dir == DTOrderDir.DESC) { return(configs.OrderByDescending(s => s.Domain1).Skip(start).Take(length).ToList()); } else if (sort.Column == 2 && sort.Dir == DTOrderDir.ASC) { return(configs.OrderBy(s => s.Type).Skip(start).Take(length).ToList()); } else { return(configs.OrderByDescending(s => s.Type).Skip(start).Take(length).ToList()); } } }
public List <start_url> GetResult(DTOrder sort, int start, int length, string search) { { search = search.ToLower(); var configs = entities.start_url.Where(m => m.ID.ToString().Contains(search) || m.url.Contains(search)); string orderby = sort.Column == 1 ? "ID" : "url"; orderby += sort.Dir == DTOrderDir.DESC ? " DESC" : " ASC"; return(configs.OrderBy(orderby).Skip(start).Take(length).ToList()); } }
public List <session_smcc> GetResult(DTOrder sort, int start, int length, string search) { using (var entities = new news_crawlEntities1()) { search = search.ToLower(); var configs = from c in entities.session_smcc where (c.Id.ToString().Contains(search) || c.session.ToString().Contains(search)) select c; if (sort.Column == 0 && sort.Dir == DTOrderDir.ASC) { return(configs.OrderBy(s => s.Id).Skip(start).Take(length).ToList()); } else if (sort.Column == 0 && sort.Dir == DTOrderDir.DESC) { return(configs.OrderByDescending(s => s.Id).Skip(start).Take(length).ToList()); } else if (sort.Column == 1 && sort.Dir == DTOrderDir.ASC) { return(configs.OrderBy(s => s.session).Skip(start).Take(length).ToList()); } else if (sort.Column == 1 && sort.Dir == DTOrderDir.DESC) { return(configs.OrderByDescending(s => s.session).Skip(start).Take(length).ToList()); } else if (sort.Column == 2 && sort.Dir == DTOrderDir.ASC) { return(configs.OrderBy(s => s.status).Skip(start).Take(length).ToList()); } else { return(configs.OrderByDescending(s => s.status).Skip(start).Take(length).ToList()); } } }