public static string GetTransId(string UserId) { using (var db = new TestDemoWinFormEntities()) { var transId = db.Proc_GetTransId(UserId).First().ToString(); return(transId); } }
/// <summary> /// 添加 /// 先进行查询是否存在该用户 /// 然后再判断是否已经添加该用户 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void AddNewFriendBtn_Click(object sender, EventArgs e) { ErrorProvider erp = new ErrorProvider(); dataGridView1.ReadOnly = true; var searchtxt = this.SearchUserIdtxt.Text.Trim(); using (var db = new TestDemoWinFormEntities()) { //检查用户是否存在 var checkUserId = db.Log_UserMsg.AsQueryable(); checkUserId = checkUserId.Where(c => c.UserId == searchtxt); if (checkUserId.Count() == 0) { erp.SetError(SearchUserIdtxt, "该用户不存在,请重新输入"); } else { erp.SetError(SearchUserIdtxt, null); //检查是否已经是我的好友 var transId = db.Proc_GetTransId(UserId).First().ToString(); int temp = int.Parse(transId); var checkfriendRelation = db.Rla_FriendRelation.AsQueryable(); checkfriendRelation = checkfriendRelation.Where(c => c.UserId == searchtxt && c.ParentUserTransId == temp); if (checkfriendRelation.Count() == 0) { erp.SetError(SearchUserIdtxt, null); var datalist = new Rla_FriendRelation(); datalist.UserId = searchtxt; datalist.ParentUserTransId = int.Parse(transId); datalist.Deleted = 0; db.Rla_FriendRelation.Add(datalist); db.SaveChanges(); MessageBox.Show("添加成功", "温馨提示"); var dbData = db.ViewFriendRelation.AsQueryable(); dbData = dbData.Where(c => c.UserId == UserId && c.Deleted != 1); dataGridView1.DataSource = dbData.ToList(); SearchUserIdtxt.Text = ""; erp.SetError(SearchUserIdtxt, ""); } else { erp.SetError(SearchUserIdtxt, "该用户您已经添加为好友,请勿重复添加"); } } } }