//根据UserID删除用户信息 public int DeleteUserInfoByUserID(string userID) { int count = 0; userInfoDataContext db = new userInfoDataContext(); var user = from c in db.UserInfo where c.userID == userID select c; if (user.Count() > 0) { db.UserInfo.DeleteAllOnSubmit(user); count = db.UserInfo.Where(c => c.userID == userID).Count(); } return(count); }
/// <summary> /// 根据UserId获取用户信息 /// </summary> /// <param name="userID"></param> /// <returns></returns> public UserInfo GetUserInfo(string userID) { userInfoDataContext db = new userInfoDataContext(); if (db.UserInfo.Count() > 0) { var user = db.UserInfo.Single(c => c.userID == userID); return(user); } else { return(null); } }
/// <summary> /// 获取用户信息 /// </summary> /// <returns></returns> public IList <UserInfo> GetUserInfo() { userInfoDataContext db = new userInfoDataContext(); IEnumerable <UserInfo> userInfo = from c in db.UserInfo select c; if (userInfo != null) { return(userInfo.ToList <UserInfo>()); } else { return(new List <UserInfo>()); } }
/// <summary> /// 添加用户信息 /// </summary> /// <param name="user"></param> /// <returns></returns> public string InsertUserInfo(UserInfo user) { userInfoDataContext db = new userInfoDataContext(); try { db.UserInfo.InsertOnSubmit(user); db.SubmitChanges(); return(user.userID); } catch { return(string.Empty); } }
/// <summary> /// 根据UserId修改用户信息 /// </summary> /// <param name="user"></param> /// <returns></returns> public string UpdateUserInfoByUserID(UserInfo user) { userInfoDataContext db = new userInfoDataContext(); try { var result = (from item in db.UserInfo where item.userID == user.userID select item).Single(); result.userName = user.userName; result.age = user.age; result.sex = user.sex; result.headUrl = user.headUrl; result.nickName = user.nickName; result.region = user.region; result.city = user.city; result.province = user.province; result.mail = user.mail; result.qqNo = user.qqNo; result.sinaID = user.sinaID; result.tengID = user.tengID; result.weixinID = user.weixinID; result.weixinName = user.weixinName; result.weixinTwo = user.weixinTwo; result.professional = user.professional; result.industry = user.industry; result.position = user.position; result.erweima = user.erweima; result.zhuceTime = user.zhuceTime; result.qianming = user.qianming; db.SubmitChanges(); return(result.userID); } catch { return(string.Empty); } }