public bool Register(string userName, string psw) { if (userName != "" && psw != "") { using (var con = new UserEntities()) { Login ad = new Login() { UserName = userName, Password = psw }; try { con.Login.Add(ad); con.SaveChanges(); return(true); } catch (Exception ex) { MessageBox.Show(ex.Message + "添加失败!"); return(false); } } } else { MessageBox.Show("所填内容不能为空!"); return(false); } }
public List <string> FriendList(string userName) { List <string> friend = new List <string>(); using (var con = new UserEntities()) { var q = from t in con.Friend where t.Uname == userName select t; try { if (q.Count() != 0) { foreach (var v in q) { friend.Add(v.Fname); } } } catch (Exception ee) { MessageBox.Show(ee.Message); } return(friend); } }
public void MessageOk(string userName, int age1, string sex1, string country1) { using (var con = new UserEntities()) { var q = from t in con.Login where t.UserName == userName select t; try { if (q.Count() != 0) { foreach (var v in q) { v.age = age1; v.sex = sex1; v.country = country1; } con.SaveChanges(); //将更改后的用户数据库进行保存 } } catch (Exception ee) { MessageBox.Show(ee.Message); return; } } }
public void PerMessage(string userName, ref int age1, ref string sex1, ref int price1, ref string country1) { using (var con = new UserEntities()) { var q = from t in con.Login where t.UserName == userName select t; try { if (q.Count() != 0) { foreach (var v in q) { age1 = v.age; sex1 = v.sex.ToString(); country1 = v.country.ToString(); price1 = v.Price; } } } catch (Exception ee) { MessageBox.Show(ee.Message); return; } } }
public static void fail(string userName) { using (var con = new UserEntities()) { var q = from t in con.Login where t.UserName == userName select t; try { if (q.Count() != 0) { foreach (var v in q) { v.Price -= 10; } con.SaveChanges(); //将更改后的用户数据库进行保存 } } catch (Exception ee) { MessageBox.Show(ee.Message); return; } } }
public bool Login(string userName, string psw) { foreach (var user in CC.Users) { if (userName == user.UserName) { MessageBox.Show("您已登录!"); return(false); } } using (var con = new UserEntities()) { var q1 = from t in con.Login where t.UserName.Equals(userName) == true && t.Password.Equals(psw) == true select t; if (q1.Count() != 0) { return(true); } else { MessageBox.Show("登录失败\n输入有错误!或所填内容有空!"); return(false); } } }