// GET: api/UserMessage /// <summary> /// 获取个人信息 /// </summary> /// <param name="account"></param> /// <returns></returns> public User Get(string account) { User tmp = new User(); tmp.account = account; tmp.userName = myConnent.MySqlReadReturn("SELECT userName FROM 账号表 WHERE account ='" + account + "'", "userName"); tmp.sex = myConnent.MySqlReadReturn("SELECT sex FROM 账号表 WHERE account ='" + account + "'", "sex"); tmp.introduction = myConnent.MySqlReadReturn("SELECT introduction FROM 账号表 WHERE account ='" + account + "'", "introduction"); tmp.email = myConnent.MySqlReadReturn("SELECT email FROM 账号表 WHERE account ='" + account + "'", "email"); return(tmp); }
// GET: api/ClickLike/5 /// <summary> /// 点赞 /// </summary> /// <param name="imageName"></param> /// <returns></returns> public string Get(string imageName) { try { string ClickLikeCount = myConnent.MySqlReadReturn("SELECT * FROM 图片表 WHERE ImageName ='" + imageName + "'", "ClickLikeCount"); int NewCount = int.Parse(ClickLikeCount); NewCount++; myConnent.MySqlWrite("UPDATE 图片表 SET ClickLikeCount ='" + NewCount + "' WHERE ImageName ='" + imageName + "'"); return("true"); } catch (Exception e) { Debug.WriteLine(e.ToString()); return("false"); } }
// GET: api/Image_Head/5 /// <summary> /// 获取Account对应的头像名 /// </summary> /// <param name="account"></param> /// <returns></returns> public ReturnHeadImageNameModel Get(string account) { ReturnHeadImageNameModel returnModel = new ReturnHeadImageNameModel(); try { string imageNameList = myConnent.MySqlReadReturn("SELECT * FROM 账号表 WHERE Account ='" + account + "'", "HeadImageName"); if (imageNameList != "error") { returnModel.result = "true"; returnModel.headimageName = imageNameList; return(returnModel); } else { returnModel.result = "error"; return(returnModel); } } catch (Exception e) { Debug.WriteLine(e.ToString()); returnModel.result = "error"; return(returnModel); } }
/// <summary> /// 获取已关注的人的列表 /// </summary> /// <param name="account"></param> /// <returns></returns> public ReturnMyFollow Get(string account) { MysqlConnent myConnent = new MysqlConnent(); ReturnMyFollow returnModel = new ReturnMyFollow(); try { List <User> tmpUserList = new List <Models.User>(); //select * from info where name regexp 'ic' //like "%2%" List <string> accountList = myConnent.MySqlRead("SELECT * FROM 关注表 WHERE FollowerAccount ='" + account + "'", "WasFollowederAccount"); if (accountList[0] != "error") { foreach (string wasFollowederAccount in accountList) { User tmpUser = new User(); tmpUser.account = wasFollowederAccount; tmpUser.email = myConnent.MySqlReadReturn("SELECT * FROM 账号表 WHERE Account ='" + wasFollowederAccount + "'", "email"); tmpUser.sex = myConnent.MySqlReadReturn("SELECT * FROM 账号表 WHERE Account ='" + wasFollowederAccount + "'", "sex"); tmpUser.userName = myConnent.MySqlReadReturn("SELECT * FROM 账号表 WHERE Account ='" + wasFollowederAccount + "'", "userName"); tmpUser.introduction = myConnent.MySqlReadReturn("SELECT * FROM 账号表 WHERE Account ='" + wasFollowederAccount + "'", "introduction"); tmpUserList.Add(tmpUser); } returnModel.result = "true"; returnModel.userList = tmpUserList; return(returnModel); } else { returnModel.result = "error"; return(returnModel); } } catch (Exception e) { Debug.WriteLine(e.ToString()); returnModel.result = "error"; return(returnModel); } }
// GET: api/ImageMessage /// <summary> /// 返回图片信息 /// </summary> /// <param name="imageName"></param> /// <returns></returns> public ReturnImageMessageModel GetMessage(string imageName) { ReturnImageMessageModel tmpReturnModel = new ReturnImageMessageModel(); try { tmpReturnModel.imageName = imageName; tmpReturnModel.dateTime = myConnent.MySqlReadReturn("SELECT dateTime FROM 图片表 WHERE ImageName ='" + imageName + "'", "dateTime"); tmpReturnModel.introduction = myConnent.MySqlReadReturn("SELECT introduce FROM 图片表 WHERE ImageName ='" + imageName + "'", "introduce"); tmpReturnModel.longitude = myConnent.MySqlReadReturn("SELECT longitude FROM 图片表 WHERE ImageName ='" + imageName + "'", "longitude"); tmpReturnModel.latitude = myConnent.MySqlReadReturn("SELECT latitude FROM 图片表 WHERE ImageName ='" + imageName + "'", "latitude"); return(tmpReturnModel); } catch (Exception e) { Debug.WriteLine(e.ToString()); return(tmpReturnModel); } }
/// <summary> /// 通过图片id获取评论 /// </summary> /// <param name="id"></param> /// <returns></returns> public CommentBackListModel Get(string imageName) { CommentBackListModel returnModel = new CommentBackListModel(); try { List <CommentBackModel> tmpCommentList = new List <CommentBackModel>(); //select * from info where name regexp 'ic' //like "%2%" List <string> commentIDList = myConnent.MySqlRead("SELECT * FROM 评论表 WHERE ImageName ='" + imageName + "'", "CommentID"); if (commentIDList[0] != "error") { foreach (string commentID in commentIDList) { CommentBackModel tmpComment = new CommentBackModel(); tmpComment.account = myConnent.MySqlReadReturn("SELECT * FROM 评论表 WHERE CommentID ='" + commentID + "' AND (IsCheck = '1' OR IsCheck = '0')", "Account"); tmpComment.comment = myConnent.MySqlReadReturn("SELECT * FROM 评论表 WHERE CommentID ='" + commentID + "' AND (IsCheck = '1' OR IsCheck = '0')", "Comment"); tmpComment.dateTime = myConnent.MySqlReadReturn("SELECT * FROM 评论表 WHERE CommentID ='" + commentID + "' AND (IsCheck = '1' OR IsCheck = '0')", "DateTime"); tmpComment.imageName = imageName; tmpComment.commentID = commentID; tmpCommentList.Add(tmpComment); } returnModel.result = "true"; returnModel.commentBackList = tmpCommentList; return(returnModel); } else { returnModel.result = "error"; return(returnModel); } } catch (Exception e) { Debug.WriteLine(e.ToString()); returnModel.result = "error"; return(returnModel); } }
// POST: api/User_Find /// <summary> /// 查找用户 /// </summary> /// <param name="value"></param> /// <returns></returns> public ReturnFindUser Post([FromBody] FindUser value) { ReturnFindUser returnModel = new ReturnFindUser(); try { List <User> tmpUserList = new List <Models.User>(); //select * from info where name regexp 'ic' //like "%2%" List <string> accountList = myConnent.MySqlRead("SELECT * FROM 账号表 WHERE Account Like '%" + value.account + "%' OR UserName Like '%" + value.account + "%'", "Account"); if (accountList[0] != "error") { foreach (string account in accountList) { User tmpUser = new User(); tmpUser.account = account; tmpUser.email = myConnent.MySqlReadReturn("SELECT * FROM 账号表 WHERE Account ='" + account + "'", "email"); tmpUser.sex = myConnent.MySqlReadReturn("SELECT * FROM 账号表 WHERE Account ='" + account + "'", "sex"); tmpUser.userName = myConnent.MySqlReadReturn("SELECT * FROM 账号表 WHERE Account ='" + account + "'", "userName"); tmpUser.introduction = myConnent.MySqlReadReturn("SELECT * FROM 账号表 WHERE Account ='" + account + "'", "introduction"); tmpUserList.Add(tmpUser); } returnModel.result = "true"; returnModel.userList = tmpUserList; return(returnModel); } else { returnModel.result = "error"; return(returnModel); } } catch (Exception e) { Debug.WriteLine(e.ToString()); returnModel.result = "error"; return(returnModel); } }
/// <summary> /// 通过账号获取最近一条行程信息 /// </summary> /// <param name="value"></param> /// <returns></returns> public ReturnFinalRoad GetFinalRoadName(string getAccount) { ReturnFinalRoad tmpRoad = new ReturnFinalRoad(); try { tmpRoad.roadID = myConnent.MySqlReadReturn("SELECT * FROM 路径表 WHERE Account ='" + getAccount + "' ORDER BY EndTime DESC LIMIT 0,1", "RoadID"); return(tmpRoad); } catch (Exception e) { Debug.WriteLine(e.ToString()); tmpRoad.roadID = "error"; return(tmpRoad); } }