public bool ifUserFollowedByOpenId(string openId, string userId) { SqlSugarClient db = SqlSugarInstance.newInstance(); tbl_userFollowed followed = new tbl_userFollowed(); followed = db.Queryable <tbl_userFollowed>().Where(o => o.userId == openId && o.followedUser == userId).First(); if (followed != null) { return(true); } else { return(false); } }
public void addFollow(string openId, string postsId) { SqlSugarClient db = SqlSugarInstance.newInstance(); tbl_posts posts = db.Queryable <tbl_posts>().Where(o => o.postsID == postsId).First(); string postsMaker = posts.postsMaker; tbl_userFollowed followed = new tbl_userFollowed(); followed.followId = Guid.NewGuid().ToString(); followed.userId = openId; followed.followedUser = postsMaker; followed.followedTime = DateTime.Now; tbl_userFollowed tf = new tbl_userFollowed(); long i = db.Queryable <tbl_userFollowed>().Where(o => o.userId == openId && o.followedUser == postsMaker).Count(); if (i == 0) { db.Insertable <tbl_userFollowed>(followed).ExecuteCommand(); } }
public void newOrUpdateUser(tbl_user user, string refer) { try { SqlSugarClient db = SqlSugarInstance.newInstance(); tbl_user curUser = db.Queryable <tbl_user>().Where(o => o.openid == user.openid).First(); if (curUser != null) { if (curUser.avantarUrl != user.avantarUrl || curUser.nickName != user.nickName || curUser.gender != user.gender || curUser.country != user.country || curUser.city != user.city || curUser.province != user.province) { curUser.lastLoginDate = DateTime.Now; //user.registerDate = curUser.registerDate; //user.userStatus = curUser.userStatus; curUser.avantarUrl = user.avantarUrl; curUser.nickName = user.nickName; curUser.gender = user.gender; curUser.country = user.country; curUser.city = user.city; curUser.province = user.province; db.Updateable <tbl_user>(curUser).Where(o => o.openid == user.openid).ExecuteCommand(); } updateLastLoginDate(user.openid); } else { user.referBy = refer; user.registerDate = DateTime.Now; user.lastRefreshDate = DateTime.Now; user.lastRefreshFans = DateTime.Now; user.userStatus = 0;//0 means the user is under active status user.lastLoginDate = DateTime.Now; db.Insertable <tbl_user>(user).ExecuteCommand(); tbl_userFollowed followedSelf = new tbl_userFollowed(); followedSelf.followedTime = DateTime.Now; followedSelf.followedUser = user.openid; followedSelf.followId = Guid.NewGuid().ToString(); followedSelf.userId = user.openid; db.Insertable <tbl_userFollowed>(followedSelf).ExecuteCommand(); List <tbl_admin> admin = new List <tbl_admin>(); admin = db.Queryable <tbl_admin>().ToList(); foreach (var item in admin) { bool ifFollowed = false; ifFollowed = db.Queryable <tbl_userFollowed>().Where(o => o.userId == user.openid && o.followedUser == item.openId).Count() > 0; if (!ifFollowed) { tbl_userFollowed followed = new tbl_userFollowed(); followed.followedTime = DateTime.Now; followed.followedUser = item.openId; followed.followId = Guid.NewGuid().ToString(); followed.userId = user.openid; db.Insertable <tbl_userFollowed>(followed).ExecuteCommand(); } } db.Insertable <tbl_userConfig>(new tbl_userConfig { userId = user.openid, byTime = 0, byViewed = 1, onlyLoved = 0, onlyVerify = 0, videoMuted = 1 }).ExecuteCommand(); } } catch (Exception e) { string err = e.Message; } }