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());
}
}
}
