/// <summary> /// Insert登录信息表 /// </summary> /// <returns></returns> private string Insert_User_Login(string username, string password) { try { using (SqlConnection con = new SqlConnection(strcon)) { con.Open(); SqlCommand command = new SqlCommand("insert into User_Login values(@UserLogin_Name,@UserLogin_Password)", con); command.Parameters.Add("UserLogin_Name", SqlDbType.NVarChar).Value = username; command.Parameters.Add("UserLogin_Password", SqlDbType.NVarChar).Value = password; command.ExecuteNonQuery(); con.Close(); } List <User_LoginInfo> user_LoginInfos = new List <User_LoginInfo>(); User_LoginInfo user_LoginInfo = new User_LoginInfo(); user_LoginInfo.Result = "注册成功!请登录系统进行密码重置!"; user_LoginInfo.Name = "用户名:" + username; user_LoginInfo.Password = "******" + password; user_LoginInfos.Add(user_LoginInfo); return(JsonConvert.SerializeObject(user_LoginInfos)); } catch (Exception ex) { return(ex.ToString()); } }
public UserType DoLogin(string userName, string password) { UserType userType = null; using (var context = new SongsManagementEntities()) { User_LoginInfo user_LoginInfo = context.User_LoginInfo.First <User_LoginInfo>(u => (u.UserName == userName && u.Password == password)); if (user_LoginInfo != null) { User_Type user_Type = context.User_Type.First(ut => ut.Id == user_LoginInfo.UserTypeId); if (user_Type != null) { userType = new UserType(); userType.CreatedTimestamp = user_Type.CreatedTimestamp; userType.Id = user_Type.Id; userType.IsActive = user_Type.IsActive; userType.Timestamp = user_Type.Timestamp; userType.TypeName = user_Type.TypeName; } } } return(userType); }
public void CreateUser(UserLoginInfo userLoginInfo, UserPersonalInfo userPersonalInfo) { using (var context = new SongsManagementEntities()) { User_LoginInfo user_LoginInfo = new User_LoginInfo(); user_LoginInfo.CreatedTimestamp = userLoginInfo.CreatedTimestamp; user_LoginInfo.Id = userLoginInfo.Id; user_LoginInfo.LoginAttempts = userLoginInfo.LoginAttempts; user_LoginInfo.Password = userLoginInfo.Password; user_LoginInfo.Timestamp = userLoginInfo.Timestamp; user_LoginInfo.UserName = userLoginInfo.UserName; user_LoginInfo.UserTypeId = userLoginInfo.UserTypeId; context.User_LoginInfo.Add(user_LoginInfo); User_PersonalInfo user_PersonalInfo = new User_PersonalInfo(); user_PersonalInfo.Address = userPersonalInfo.Address; user_PersonalInfo.City = userPersonalInfo.City; user_PersonalInfo.DisplayName = userPersonalInfo.DisplayName; user_PersonalInfo.Email = userPersonalInfo.Email; user_PersonalInfo.FirstName = userPersonalInfo.FirstName; user_PersonalInfo.Id = userPersonalInfo.Id; user_PersonalInfo.IP = userPersonalInfo.IP; user_PersonalInfo.LastName = userPersonalInfo.LastName; user_PersonalInfo.MiddleName = userPersonalInfo.MiddleName; user_PersonalInfo.Phone = userPersonalInfo.Phone; user_PersonalInfo.PhotoPath = userPersonalInfo.PhotoPath; user_PersonalInfo.PRO = userPersonalInfo.PRO; user_PersonalInfo.State = userPersonalInfo.State; user_PersonalInfo.User_LoginInfo_Id = userPersonalInfo.User_LoginInfo_Id; context.User_PersonalInfo.Add(user_PersonalInfo); context.SaveChanges(); } }