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