/// <summary> /// 发表看法按钮 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void PublishBtn_Click(object sender, EventArgs e) { var sendmsg = this.sendMsgRichTextBox.Text; if (sendmsg == "") { label2.Visible = true; label2.Text = "信息不能为空"; } else { label2.Visible = false; using (var db = new TestDemoWinFormEntities()) { var datalist = db.Log_UserMsg.AsQueryable(); int a = int.Parse(LogUserMsg.GetTransId(UserId)); var dataMsgList = new Bus_SendMsg(); dataMsgList.SendUserId = a; dataMsgList.SendMsg = UserId + ":" + this.sendMsgRichTextBox.Text; dataMsgList.SendTime = DateTime.Now; db.Bus_SendMsg.Add(dataMsgList); db.SaveChanges(); } this.MainMsgRichTextBox.Text += "***********" + DateTime.Now + "***********" + "\n"; this.MainMsgRichTextBox.Text += UserId + ":" + this.sendMsgRichTextBox.Text + "\n"; this.sendMsgRichTextBox.Text = ""; } }
/// <summary> /// 根据搜索条件去找人 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void SearchBtn_Click(object sender, EventArgs e) { dataGridView1.ReadOnly = true; var searchtxt = this.SearchUserIdtxt.Text.Trim(); if (!string.IsNullOrEmpty(searchtxt)) { using (var db = new TestDemoWinFormEntities()) { ErrorProvider erp = new ErrorProvider(); var dbData = db.ViewFriendRelation.AsQueryable(); dbData = dbData.Where(c => c.UserId == UserId && c.FriendUserId == searchtxt); if (dbData.Count() != 0) { erp.SetError(SearchUserIdtxt, null); var dbDatalist = db.Log_UserMsg.AsQueryable(); dbDatalist = dbDatalist.Where(c => c.UserId == searchtxt); dataGridView1.DataSource = dbDatalist.ToList(); } else { erp.SetError(SearchUserIdtxt, "该用户还不是你的好友"); } } } }
public static string GetTransId(string UserId) { using (var db = new TestDemoWinFormEntities()) { var transId = db.Proc_GetTransId(UserId).First().ToString(); return(transId); } }
private void CheckRegisterBtn_Click(object sender, EventArgs e) { var UserIdString = this.UserIdtxt.Text.Trim(); var PassWordString = this.PassWordtxt.Text.Trim(); var PassWordStringRe = this.PassWordtxt2.Text.Trim(); var MobileNumString = this.MobileNumtxt.Text.Trim(); if (!string.IsNullOrEmpty(UserIdString) && !string.IsNullOrEmpty(PassWordString) && !string.IsNullOrEmpty(PassWordStringRe) && !string.IsNullOrEmpty(MobileNumString)) { if (!PassWordString.Equals(PassWordStringRe)) { MessageBox.Show("密码输入不相同,请重新输入", "温馨提示"); } else { using (var db = new TestDemoWinFormEntities()) { var dbData = db.Log_UserMsg.AsQueryable(); dbData = dbData.Where(c => c.UserId == UserIdString && c.MobileNum == MobileNumString); if (dbData.Count() == 0) { var datalist = new Log_UserMsg(); datalist.UserId = UserIdString; datalist.PassWord = PassWordString; datalist.MobileNum = MobileNumString; datalist.CreateTime = DateTime.Now; db.Log_UserMsg.Add(datalist); db.SaveChanges(); MessageBox.Show("恭喜你注册成功!", "成功提示"); this.UserIdtxt.Text = ""; this.PassWordtxt.Text = ""; this.PassWordtxt2.Text = ""; this.MobileNumtxt.Text = ""; } else if (dbData.Count() != 0) { MessageBox.Show("该账号已被注册!", "错误提示"); } else { MessageBox.Show("该手机号已被注册!", "错误提示"); } } } } else { MessageBox.Show("请填写完整!", "温馨提示"); } }
/// <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, "该用户您已经添加为好友,请勿重复添加"); } } } }
private void MainForm_Load(object sender, EventArgs e) { dataGridView1.ReadOnly = true; if (!string.IsNullOrEmpty(UserId)) { this.label1.Text = "欢迎您:" + UserId; a = 2; using (var db = new TestDemoWinFormEntities()) { var dbData = db.ViewFriendRelation.AsQueryable(); dbData = dbData.Where(c => c.UserId == UserId && c.Deleted != 1); dataGridView1.DataSource = dbData.ToList(); } } else { this.label1.Text = "请登录!"; a = 1; } }
private void SignInBtn_Click(object sender, EventArgs e) { var UserIdString = this.UserIdtxt.Text.Trim(); var PassWordString = this.PassWordtxt.Text.Trim(); if (!string.IsNullOrEmpty(UserIdString) && !string.IsNullOrEmpty(PassWordString)) { using (var db = new TestDemoWinFormEntities()) { var dbData = db.Log_UserMsg.AsQueryable(); dbData = dbData.Where(c => c.UserId == UserIdString); a++; if (dbData.Count() != 0) { dbData = dbData.Where(c => c.PassWord == PassWordString); if (dbData.Count() != 0) { this.Hide(); MainForm mf = new MainForm(); mf.UserId = UserIdString; mf.Show(); } else if (dbData.Count() == 0 && a < 3) { MessageBox.Show("密码错误!请重新输入", "登录失败"); this.PassWordtxt.Text = ""; } } if (a >= 3) { MessageBox.Show("密码错误!请联系管理员找回密码", "登录失败"); this.PassWordtxt.Text = ""; } } } else { MessageBox.Show("请填写完整", "登录失败"); } }