public void AddToSearchWords(string Word, string Dic, string IP)
{
DictionariesDataContext dc = new DictionariesDataContext();
SearchedWords newobj = new SearchedWords();
dc.SearchedWords.InsertOnSubmit(newobj);
newobj.Word = Word;
newobj.Dic = Dic;
newobj.IP = IP;
dc.SubmitChanges();
}
public DataTable GetWordTranslation(string Word, int TopCount, string TransType)
{
DictionariesDataContext dc = new DictionariesDataContext();
switch (TransType)
{
case "StartsWith":
return(new Converter <EA>().ToDataTable((from d in dc.EAs
where d.Word.StartsWith(Word)
select d).Distinct().Take(TopCount)));
break;
case "EndsWith":
return(new Converter <EA>().ToDataTable((from d in dc.EAs
where d.Word.EndsWith(Word)
select d).Distinct().Take(TopCount)));
break;
case "Contains":
return(new Converter <EA>().ToDataTable((from d in dc.EAs
where d.Word.Contains(Word)
select d).Distinct().Take(TopCount)));
break;
case "Equals":
return(new Converter <EA>().ToDataTable((from d in dc.EAs
where d.Word.Equals(Word)
select d).Distinct().Take(TopCount)));
break;
default:
return(new DataTable());
break;
}
}
public object GetLatestSearchedWords(int TopCount)
{
DictionariesDataContext dc = new DictionariesDataContext();
return(dc.SearchedWords.OrderByDescending(p => p.Code).Take(TopCount));
}
