public static List <MF_GroupMember> GetInvite(string userid)
{
List <MF_GroupMember> GroupMembers = new List <MF_GroupMember>();
ORMQuery <MF_GroupMember> Query = new ORMQuery <MF_GroupMember>();
GroupMembers = Query.Query(MF_GroupMember.M_UserID + " = ('" + userid + "') AND " + MF_GroupMember.M_Status + " = (2)").ToList();
return(GroupMembers);
}
public static List <MF_GroupMember> GetGroupMembers(string GroupID)
{
List <MF_GroupMember> GroupMembers = new List <MF_GroupMember>();
ORMQuery <MF_GroupMember> Query = new ORMQuery <MF_GroupMember>();
GroupMembers = Query.Query(MF_GroupMember.M_GroupID + " = ('" + GroupID + "') AND " + MF_GroupMember.M_Status + " = (1)").ToList();
return(GroupMembers);
}
public static List <MF_Group> GetGroups(string userid)
{
List <MF_Group> Groups = new List <MF_Group>();
ORMQuery <MF_Group> Query = new ORMQuery <MF_Group>();
Groups = Query.Query(MF_Group.M_UserID + " = ('" + userid + "')").ToList();
return(Groups);
}
public static List <MF_Video> GetVideo(string knowledgeid)
{
List <MF_Video> vs = new List <MF_Video>();
ORMQuery <MF_Video> Query = new ORMQuery <MF_Video>();
vs = Query.Query(MF_Video.M_KnowledgeID + " = ('" + knowledgeid + "')").ToList();
return(vs);
}
public static string GetKnowledgeRef(string course, string sizex, string sizey)
{
List <MF_Knowledge> ks = new List <MF_Knowledge>();
ORMQuery <MF_Knowledge> Query = new ORMQuery <MF_Knowledge>();
if (course == "math1")
{
ks = Query.Query(MF_Knowledge.M_Course + " = ('1')").ToList();
}
else if (course == "math2")
{
ks = Query.Query(MF_Knowledge.M_Course + " = ('2')").ToList();
}
List <MF_KnowledgeRef> ksr = new List <MF_KnowledgeRef>();
ORMQuery <MF_KnowledgeRef> Query2 = new ORMQuery <MF_KnowledgeRef>();
if (course == "math1")
{
ksr = Query2.Query(MF_KnowledgeRef.M_Course + " = ('1')").ToList();
}
else if (course == "math2")
{
ksr = Query2.Query(MF_KnowledgeRef.M_Course + " = ('2')").ToList();
}
List <KnowledgeRef> res = new List <KnowledgeRef>();
StringBuilder sb = new StringBuilder();
sb.Append("digraph G {\n");
//sb.Append("size=\"" + sizex + "," + sizey + "\";\n");
sb.Append("center=true;\n");
//sb.Append("ranksep=1;\n");
//sb.Append("nodesep=0.3;\n");
sb.Append("rankdir=BT;\n");
sb.Append("graph [splines=spline,splines=true]\n");
sb.Append("node [shape=box,style=rounded,color=\"#084081\",fontsize=13];\n");
sb.Append("edge [shape=vee,color=grey,weight=2];\n");
string JSONstring = string.Empty;
foreach (MF_Knowledge item in ks)
{
JSONstring += item.KnowledgeID + "[fillcolor=\"#084081\", style=\"rounded,filled\",label = " + item.KnowledgeName + " ];";
}
foreach (MF_KnowledgeRef item in ksr)
{
JSONstring += item.PreKnowledgeID + "->";
JSONstring += item.KnowledgeID + ";";
}
JSONstring += "}";
return(sb.ToString() + JSONstring);
}
private static List <mySearch.SearchResult> FillterSearchResult(List <mySearch.SearchResult> SR)
{
List <MF_BlackList> bl = new List <MF_BlackList>();
ORMQuery <MF_BlackList> Query = new ORMQuery <MF_BlackList>();
bl = Query.Query("1=1").ToList();
foreach (mySearch.SearchResult item in SR)
{
foreach (MF_BlackList i in bl)
{
if (item.URL.IndexOf(i.URL) >= 0)
{
item.isRemove = true;
break;
}
}
}
SR = SR.Where(p => p.isRemove == false).ToList();
return(SR);
}
public static List <mySearch.SearchResult> GetSearchResult(string keyword, string knowledgeid, string course)
{
string rootUrl = "https://api.datamarket.azure.com/Bing/Search";
BingSearchContainer bingContainer = new BingSearchContainer(new Uri(rootUrl));
string market = "zh-cn";
bingContainer.Credentials = new NetworkCredential(AccountKey, AccountKey);
if (course == "math1")
{
keyword = keyword + " 小学";
}
if (course == "math2")
{
keyword = keyword + " 初中";
}
var webQuery = bingContainer.Web(keyword, null, null, market, "Strict", null, null, null);
webQuery = webQuery.AddQueryOption("$top", 50);
var webResults = webQuery.Execute();
List <SearchResult> myresults = new List <SearchResult>();
foreach (var result in webResults)
{
SearchResult sr = new SearchResult();
sr.Title = result.Title;
sr.URL = result.Url;
sr.URLID = "0";
sr.Description = result.Description;
sr.isRemove = false;
myresults.Add(sr);
}
myresults = FillterSearchResult(myresults);
List <MF_URL> URLs = new List <MF_URL>();
ORMQuery <MF_URL> Query = new ORMQuery <MF_URL>();
URLs = Query.Query(MF_URL.M_KnowledgeID + " = ('" + knowledgeid + "')").ToList();
URLs = URLs.OrderByDescending(p => p.Count).ToList();
List <SearchResult> results = new List <SearchResult>();
foreach (MF_URL item in URLs)
{
if (results.Count < 5)
{
SearchResult sr = new SearchResult();
sr.URLID = item.URLID.ToString();
sr.URL = item.URL;
sr.Title = item.Title;
sr.Description = item.Description;
results.Add(sr);
}
}
foreach (SearchResult item in myresults)
{
if (results.Count == 10)
{
break;
}
if (results.Where(p => p.URL == item.URL).ToList().Count == 0)
{
results.Add(item);
}
}
return(results);
}
