public User LoginUser([FromBody]User user)
{
MysqlHelper mysqlhelper = new MysqlHelper();
// return "Success";
var status = mysqlhelper.SearchUser(user);
return status;
}
public Tree TreeData(string id)
{
UserHelper userhelper = new UserHelper();
MysqlHelper mysqlhelper = new MysqlHelper();
User one_user = new User();
one_user.Id = id;
one_user = mysqlhelper.CheckStatus(one_user);
Seed final_tree = userhelper.HandleBaidu(one_user);
string result = "";
Tree tree = new Tree();
tree.name = "初中数学上";
tree.itemStyle.normal.label.show = false;
foreach (Seed seed in final_tree.children)
{
Tree one_tree_2 = new Tree();
one_tree_2.name = seed.name;
if (seed.Degree_1 < 20)
{
one_tree_2.itemStyle.normal.color = "#332B2B";
}
else
{
one_tree_2.itemStyle.normal.color = "#19C9FF";
}
foreach (Seed seed_2 in seed.children)
{
Tree tree_3 = new Tree();
tree_3.name = seed_2.name;
if (seed_2.Degree_2 < 20)
{
tree_3.itemStyle.normal.color = "#332B2B";
}
else
{
tree_3.itemStyle.normal.color = "#19C9FF";
}
one_tree_2.children.Add(tree_3);
}
tree.children.Add(one_tree_2);
}
return tree;
}
public IHttpActionResult Explain(string qno)
{
string[] string_list = qno.Split(';');
string pre_sql = "";
for (int i = 0; i < string_list.Count(); i++)
{
if (i != string_list.Count()-1)
{
pre_sql += "questionID=" + string_list[i] + " or ";
}
else
{
pre_sql += " questionID=" + string_list[i];
}
}
string sql = string.Format("select id,content,answerExplain from question where {0}",pre_sql);
MysqlHelper mysqlhelper = new MysqlHelper();
return Ok(mysqlhelper.SelectExp(sql));
}
public Explain Explain(string id)
{
MysqlHelper mysqlhelper = new MysqlHelper();
return mysqlhelper.GetExplainDetail(id);
}
public IHttpActionResult random()
{
MysqlHelper mysqlhelper = new MysqlHelper();
return Ok(mysqlhelper.random());
}
public IHttpActionResult qslist(string id)
{
MysqlHelper mysqlhelper = new MysqlHelper();
return Ok(mysqlhelper.getQuestion(id));
}
public Question ExplainQuestion(string id)
{
MysqlHelper mysqlhelper = new MysqlHelper();
return mysqlhelper.randomById(id);
}
public User Register([FromBody]User user)
{
MysqlHelper mysqlhelper = new MysqlHelper();
mysqlhelper.CreatUser(ref user);
return user;
}
public void ReceiveGoal([FromBody]User user)
{
MysqlHelper mysqlhelper = new MysqlHelper();
mysqlhelper.InsertGoal(user);
}
public bool NameSearch(string name)
{
MysqlHelper mysqlhelper = new MysqlHelper();
return mysqlhelper.SearchName(name);
}
/// <summary>
/// 根据用户id获取用户最新的详细信息，用于实时刷新功能
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public User UserStatus([FromBody]User user)
{
MysqlHelper mysqlhelper = new MysqlHelper();
return mysqlhelper.CheckStatus(user);
}
public string UpdatePower([FromBody]User user)
{
MysqlHelper mysqlhelper = new MysqlHelper();
return mysqlhelper.UpdatePower(user);
}
public string UpdateCurrentLevel([FromBody]User user)
{
MysqlHelper mysqlhelper = new MysqlHelper();
return mysqlhelper.UpdateCurrentLevel(user);
}
public Baidu_Data Updatechapter(string id)
{
//string chapter = Regex.Match(data, @"\[(.*?)\]").Groups[1].ToString();
UserHelper userhelper = new UserHelper();
MysqlHelper mysqlhelper = new MysqlHelper();
User one_user = new User();
one_user.Id = id;
one_user =mysqlhelper.CheckStatus(one_user);
string old_result= HandleU_Chapter(one_user);
Seed final_tree = userhelper.HandleBaidu(one_user);
int change_status = 0;
try
{
if ((DateTime.Now - DateTime.Parse(one_user.last_update)).Days > 7)
{
change_status = 1;
}
}
catch (Exception t)
{
change_status = 1;
}
string result = "";
if (final_tree == null)
{
return null;
}
foreach (Seed seed in final_tree.children)
{
result += seed.Degree_1 + ",";
}
result = result.Substring(0, result.Length - 1);
try
{
string old_date_string = Regex.Match(one_user.u_Chapter, "(.*?):").Groups[1].ToString();
DateTime old_date = Convert.ToDateTime(old_date_string);
if (change_status == 1)
{
mysqlhelper.UpdateChapter(id, result);
}
}
catch
{
}
Baidu_Data baidudata = new Baidu_Data();
baidudata.RadarNow = result;
baidudata.RadarOld = old_result;
return baidudata;
// return mysqlhelper.UpdateChapter(id,chapter);
}