/// <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); } }