//添加好友请求 public void addToFriend() { RequestFriendsBiz requestFriendsBiz = new RequestFriendsBiz(); DataSet result = requestFriendsBiz.ExecuteSqlToDataSet("EXEC [TireTreasureDB].[dbo].[proc_GetRequestUserId] '" + GetUData.OpenId + "'," + ConstantList.ADD_FRIENDS_STATUS_REQUESTING + ""); //TODO 重载页面前多次点击会生成多条数据 设置一个flag if (!(result.Tables[0].Rows.Count > 0)) { UserBiz userBiz = new UserBiz(); result = userBiz.ExecuteSqlToDataSet("SELECT UserId FROM [TireTreasureDB].[dbo].[TT_User] where WeiXinId='" + GetUData.OpenId + "'"); if (result.Tables[0].Rows.Count > 0) { RequestFriends requestFriends = new RequestFriends(); Guid userId = (Guid)result.Tables[0].Rows[0][0]; requestFriends.UserId = userId; result = userBiz.ExecuteSqlToDataSet("SELECT UserId FROM [TireTreasureDB].[dbo].[TT_User] where WeiXinId='" + GetUData.Request_User_OpenId + "'"); Guid toUserId = (Guid)result.Tables[0].Rows[0][0]; requestFriends.ToUserId = toUserId; requestFriends.States = ConstantList.ADD_FRIENDS_STATUS_REQUESTING; requestFriends.AddTime = DateTime.Now; requestFriends.isDeleted = false; //RequestFriendsBiz requestFriendsBiz = new RequestFriendsBiz(); requestFriendsBiz.Add(requestFriends); } } else { //TODO } }
//获取推荐人ID public string getRecommendId() { UserBiz userBiz = new UserBiz(); DataSet result = userBiz.ExecuteSqlToDataSet("EXEC [TireTreasureDB].[dbo].[proc_GeRecommendIdByWeiXinId] '" + GetUData.OpenId + "'"); return(result.Tables[0].Rows[0]["Id"].ToString()); }
private Guid getUserIdByRecommendId(string recommendId) { UserBiz userBiz = new UserBiz(); DataSet result = userBiz.ExecuteSqlToDataSet("EXEC [TireTreasureDB].[dbo].[proc_GetUserIdByRecommendId] '" + recommendId + "'"); return((Guid)result.Tables[0].Rows[0]["UserId"]); }
//获取当前用户ID public Guid getUserId() { UserBiz userBiz = new UserBiz(); DataSet result = userBiz.ExecuteSqlToDataSet("EXEC [TireTreasureDB].[dbo].[proc_GetUserIdByWeiXinId] '" + GetUData.OpenId + "',null"); return((Guid)result.Tables[0].Rows[0][0]); }
//openId是否存在 public static bool isOpenIdExist(string openId) { UserBiz userBiz = new UserBiz(); DataSet result = userBiz.ExecuteSqlToDataSet("EXEC [TireTreasureDB].[dbo].[proc_IsOpenIdExist]'" + openId + "'"); if (result.Tables[0].Rows.Count > 0) { return(true); } return(false); }
//检索手机号是否已注册 private bool isPhoneNumberExist(String loginName) { UserBiz userBiz = new UserBiz(); DataSet result = userBiz.ExecuteSqlToDataSet("EXEC [TireTreasureDB].[dbo].[proc_GetUserLoginNameByLoginName] '" + loginName + "'"); if (result.Tables.Count > 0 && result.Tables[0].Rows.Count > 0) { return(true); } return(false); }
public ActionResult searchUserInfo(string userAccount) { if (userAccount == null || userAccount == "" || !Util.isNumber(userAccount)) { ViewData["IsShowAlert"] = true; ViewData["Alert"] = "请输入手机号"; return(View("index")); } UserBiz userBiz = new UserBiz(); DataSet result = userBiz.ExecuteSqlToDataSet("EXEC [TireTreasureDB].[dbo].[proc_GetUserLoginNameByLoginName] '" + userAccount + "'"); if (result.Tables.Count > 0 && result.Tables[0].Rows.Count > 0) { string loginName = result.Tables[0].Rows[0]["LoginName"].ToString(); this.TempData["LonginName"] = loginName; } return(RedirectToAction("showUserInfo")); }
//显示搜索用户信息 public ActionResult showUserInfo() { string loginName = this.TempData["LonginName"] as string; string openId = null; UserBiz userBiz = new UserBiz(); DataSet result = userBiz.ExecuteSqlToDataSet("SELECT WeiXinId FROM [TireTreasureDB].[dbo].[TT_User] where LoginName='" + loginName + "'"); if (result.Tables[0].Rows.Count > 0) { openId = result.Tables[0].Rows[0]["WeiXinId"].ToString(); GetUData.Request_User_OpenId = openId; AppUserInfoBiz appUserInfoBiz = new AppUserInfoBiz(); result = appUserInfoBiz.ExecuteSqlToDataSet("EXEC [TireTreasureDB].[dbo].[proc_GetUserInfoByWeiXinId] '"+ openId + "'"); if (result.Tables[0].Rows.Count > 0) { ViewBag.nickName = result.Tables[0].Rows[0]["Nickname"].ToString(); ViewBag.headImgUrl = result.Tables[0].Rows[0]["ImgeUrl"].ToString(); //TODO 判断搜索账号与搜索的状态关系 可分离出方法 RequestFriendsBiz requestFriendsBiz = new RequestFriendsBiz(); result = requestFriendsBiz.ExecuteSqlToDataSet("EXEC [TireTreasureDB].[dbo].[proc_IsAlreadyFriend] '"+ GetUData.OpenId + "','" + GetUData.Request_User_OpenId + "'"); if (result.Tables[0].Rows.Count > 0) { ViewBag.states = ConstantList.ADD_FRIENDS_STATUS_SUCCESS; } result = requestFriendsBiz.ExecuteSqlToDataSet("EXEC [TireTreasureDB].[dbo].[proc_GetRequestUserId] '" + GetUData.OpenId + "'," + ConstantList.ADD_FRIENDS_STATUS_REQUESTING + ""); if (result.Tables[0].Rows.Count > 0) { ViewBag.states = ConstantList.ADD_FRIENDS_STATUS_REQUESTING; } } } return(View()); }