// GET: api/ImageMessage/5 /// <summary> /// 返回自己的图片名 /// </summary> /// <param name="account"></param> /// <returns></returns> public ReturnImageNameModel Get(string account) { ReturnImageNameModel returnModel = new ReturnImageNameModel(); try { List <string> imageNameList = myConnent.MySqlRead("SELECT * FROM 图片表 WHERE Account ='" + account + "' AND IsDelete = '0' ORDER BY DateTime DESC", "imageName"); if (imageNameList[0] != "error") { returnModel.result = "true"; returnModel.imageName = imageNameList; return(returnModel); } else { returnModel.result = "error"; return(returnModel); } } catch (Exception e) { Debug.WriteLine(e.ToString()); returnModel.result = "error"; return(returnModel); } }
// GET: api/Road/5 /// <summary> /// 通过RoadID获取图片名 /// </summary> /// <param name="RoadID"></param> /// <returns></returns> public ReturnImageNameByRoadID GetImageName(string RoadID) { ReturnImageNameByRoadID tmpModel = new ReturnImageNameByRoadID(); List <string> tmpList = new List <string>(); try { tmpList = myConnent.MySqlRead("SELECT * FROM 图片表 WHERE RoadID = '" + RoadID + "' AND IsDelete = '0' ORDER BY DateTime DESC", "ImageName"); Debug.WriteLine(tmpList); tmpModel.returnImageName = tmpList; return(tmpModel); } catch (Exception e) { Debug.WriteLine(e.ToString()); tmpList.Add("error"); tmpModel.returnImageName = tmpList; return(tmpModel); } }
/// <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); } }
/// <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); } }