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