数据库性别编码转文本及高亮未定义行的视图/控制器实现

Hey there! Let's break this down into two clear parts: converting those gender codes to readable text, and highlighting rows with undefined gender. Here's how to handle both in ASP.NET MVC:

You can handle this either in the controller (best for keeping concerns separated) or directly in the view. Let's cover both approaches:

Option 1: Controller-Side Conversion (Recommended) #

First, create a ViewModel to hold your user data along with the converted gender text—this keeps your view clean and focused on presentation:

public class UserViewModel
{
    // Add all your existing user properties here (match your database model)
    public int UserId { get; set; }
    public string FullName { get; set; }
    public string GenderText { get; set; }
    // ... other properties like email, age, etc.
}

Then update your controller action to map the raw database data to this ViewModel, converting the gender code on the way:

public ActionResult Display()
{
    var rawUsers = db.P_GET_USER().ToList();
    var userViewModels = rawUsers.Select(user => new UserViewModel
    {
        UserId = user.UserId, // Replace with your actual property name
        FullName = user.FullName, // Replace with your actual property name
        GenderText = user.GenderCode switch // Assume your gender column is named GenderCode
        {
            1 => "MALE",
            2 => "FEMALE",
            3 => "UNDEFINED GENDER",
            _ => "UNKNOWN" // Fallback for unexpected values
        }
        // Map all other user properties here
    }).ToList();
    
    return View(userViewModels);
}

Don't forget to update your view's model declaration to use the ViewModel:

@model IEnumerable<UserViewModel>

Option 2: View-Side Conversion #

If you prefer to handle conversion directly in the view (less ideal for separation of concerns but quick for small cases), use either a switch statement or a reusable dictionary:

Using a Switch Statement: #

@foreach (var user in Model)
{
    <tr>
        <td>@user.FullName</td>
        <td>
            @switch(user.GenderCode)
            {
                case 1:
                    @:MALE
                    break;
                case 2:
                    @:FEMALE
                    break;
                case 3:
                    @:UNDEFINED GENDER
                    break;
                default:
                    @:UNKNOWN
                    break;
            }
        </td>
        <!-- Other columns -->
    </tr>
}

Using a Reusable Dictionary: #

Define the mapping at the top of your view for cleaner reuse:

@{
    var genderMapping = new Dictionary<int, string>
    {
        {1, "MALE"},
        {2, "FEMALE"},
        {3, "UNDEFINED GENDER"}
    };
}

Then use it in your loop:

@foreach (var user in Model)
{
    <tr>
        <td>@user.FullName</td>
        <td>@(genderMapping.ContainsKey(user.GenderCode) ? genderMapping[user.GenderCode] : "UNKNOWN")</td>
        <!-- Other columns -->
    </tr>
}

To make these rows stand out, add a conditional CSS class to the <tr> element. First, define a highlight style (either in your view or a dedicated stylesheet):

<style>
    .undefined-gender-row {
        background-color: #fff3cd; /* Soft yellow highlight */
        border-left: 4px solid #ffc107; /* Optional accent border for extra visibility */
    }
</style>

Then apply the class conditionally based on the gender code or converted text:

If Using the Controller ViewModel: #

@foreach (var user in Model)
{
    <tr class="@(user.GenderText == "UNDEFINED GENDER" ? "undefined-gender-row" : "")">
        <td>@user.FullName</td>
        <td>@user.GenderText</td>
        <!-- Other columns -->
    </tr>
}

If Using View-Side Conversion: #

@foreach (var user in Model)
{
    <tr class="@(user.GenderCode == 3 ? "undefined-gender-row" : "")">
        <td>@user.FullName</td>
        <td>
            @switch(user.GenderCode)
            {
                case 1: @:MALE; break;
                case 2: @:FEMALE; break;
                case 3: @:UNDEFINED GENDER; break;
                default: @:UNKNOWN; break;
            }
        </td>
        <!-- Other columns -->
    </tr>
}

That's all! Both approaches will convert your codes to readable text, and the conditional CSS will make undefined gender rows instantly noticeable.

内容的提问来源于stack exchange，提问作者user4221591