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, "该用户您已经添加为好友，请勿重复添加");
}
}
}
}
