public static bool AddUser(Users user)
{
#region 注册用户
if (user.UserRoles == null)
{
user.UserRoles = UserRolesServer.GetUserRolesById(1);
}
if (user.UserStates == null)
{
user.UserStates = UserStatesServer.GetUserStatesById(1);
}
string sql = @"INSERT INTO Users(LoginId,LoginPwd,Name,Address,Phone,Mail,UserRoleId,UserStateId)
VALUES(@LoginId,@LoginPwd,@Name,@Address,@Phone,@Mail,@UserRoleId,@UserStateId)";
SqlParameter[] para =
{
new SqlParameter("@LoginId", user.LoginId),
new SqlParameter("@LoginPwd", user.LoginPwd),
new SqlParameter("@Address", user.Address),
new SqlParameter("@Phone", user.Phone),
new SqlParameter("@Mail", user.Mail),
new SqlParameter("@Name", user.Name),
new SqlParameter("@UserRoleId", user.UserRoles.Id),
new SqlParameter("@UserStateId", user.UserStates.Id)
};
int count = DbHelp.ExecuteCommand(sql, para);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
#endregion
}
public static bool UpdateUser(Users user)
{
#region 更新用户信息
string sql = @"UPDATE Users SET LoginId=@LoginId,LoginPwd=@LoginPwd,Name=@Name,Address=@Address,Phone=@Phone,Mail=@Mail,UserRoleId=@UserRoleId,UserStateId=@UserStateId WHERE Id=@Id";
SqlParameter[] para =
{
new SqlParameter("@LoginId", user.LoginId),
new SqlParameter("@LoginPwd", user.LoginPwd),
new SqlParameter("@Address", user.Address),
new SqlParameter("@Phone", user.Phone),
new SqlParameter("@Mail", user.Mail),
new SqlParameter("@Name", user.Name),
new SqlParameter("@UserRoleId", user.UserRoles.Id),
new SqlParameter("@UserStateId", user.UserStates.Id),
new SqlParameter("@Id", user.ID)
};
int count = DbHelp.ExecuteCommand(sql, para);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
#endregion
}