PowerShell中If/ElseIf逻辑与CSV空字段问题求助

CSV文件结构 #

logonscripts.csv的结构如下：

需求 #

通过PowerShell读取该CSV，根据公司、办公地点及可选的部门字段匹配对应的.bat登录脚本。

当前代码 #

$logonscripts = Import-Csv "$($datadir)\logonscripts.csv"

foreach($logonscript in $logonscripts){
    if($UserCompany3LC -eq $logonscript.Company_3LC -and $UserOffice3LC -eq $logonscript.Office_3LC -and $logonscript.Department_3LC -eq "" -and $UserDepartment3LC -ne $logonscript.Department_3LC){
        $UserLogonScript = $logonscript.Name
        Write-Host "Blank Department?"
        Write-Host "Company 3LC = "$logonscript.Company_3LC
        Write-Host "Office 3LC = "$logonscript.Office_3LC
        Write-Host "Department 3LC = "$logonscript.Department_3LC
        Write-Host "Logon Script = "$logonscript.Name
    }
    elseif($UserCompany3LC -eq $logonscript.Company_3LC -and $UserOffice3LC -eq $logonscript.Office_3LC -and $UserDepartment3LC -eq $logonscript.Department_3LC){
        $UserLogonScript = $logonscript.Name
        Write-Host "Not Blank Department?"
        Write-Host "Company 3LC = "$logonscript.Company_3LC
        Write-Host "Office 3LC = "$logonscript.Office_3LC
        Write-Host "Department 3LC = "$logonscript.Department_3LC
        Write-Host "Logon Script = "$logonscript.Name
    }      
}

执行异常现象 #

执行后输出如下：

Not Blank Department?
Company 3LC =  CY1
Office 3LC =  LON
Department 3LC =  ACC
Logon Script =  accounts.bat
Blank Department?
Company 3LC =  CY1
Office 3LC =  LON
Department 3LC =
Logon Script =  common.bat

若在ElseIf后添加Else分支将$UserLogonScript设为null，变量输出会变为空。

疑问 #

• 为何If与ElseIf分支均会执行？按逻辑ElseIf仅应在If不成立时运行。
• 为何ElseIf分支的输出（Not Blank Department?）会先于If分支的输出出现？

解决建议 #

问题1原因及解决 #

你的代码是在foreach循环里遍历每一行CSV数据，每一行都会单独触发一次If-ElseIf判断，不是整个循环只走一次分支。比如：

• 遍历accounts.bat这一行时，满足ElseIf的条件，执行该分支；
• 遍历common.bat这一行时，满足If的条件，执行该分支；
  所以两个分支都会被执行，这是循环遍历每一行导致的，而非If-ElseIf逻辑失效。

问题2原因及解决 #

输出顺序由CSV文件的行顺序决定：accounts.bat在common.bat前面，所以循环先处理accounts.bat，输出Not Blank Department?，再处理common.bat输出Blank Department?。

优化方案 #

需求应该是优先匹配带部门的脚本，没有匹配到再用通用脚本，所以需要调整逻辑：

1. 先查找完全匹配（公司+办公地点+部门）的脚本；
2. 如果找不到，再查找同公司同办公地点、部门为空的通用脚本；
3. 找到后立即确定结果，避免后续覆盖变量。

优化后的代码示例：

$logonscripts = Import-Csv "$($datadir)\logonscripts.csv"

# 优先匹配带部门的脚本
$matchedScript = $logonscripts | Where-Object {
    $_.Company_3LC -eq $UserCompany3LC -and
    $_.Office_3LC -eq $UserOffice3LC -and
    $_.Department_3LC -eq $UserDepartment3LC
}

if (-not $matchedScript) {
    # 没有找到则匹配通用脚本
    $matchedScript = $logonscripts | Where-Object {
        $_.Company_3LC -eq $UserCompany3LC -and
        $_.Office_3LC -eq $UserOffice3LC -and
        [string]::IsNullOrEmpty($_.Department_3LC)
    }
}

$UserLogonScript = $matchedScript.Name
# 输出结果
if ($UserLogonScript) {
    Write-Host "匹配到登录脚本: $UserLogonScript"
    Write-Host "公司3LC: $($matchedScript.Company_3LC)"
    Write-Host "办公地点3LC: $($matchedScript.Office_3LC)"
    Write-Host "部门3LC: $($matchedScript.Department_3LC)"
} else {
    Write-Host "未找到匹配的登录脚本"
    $UserLogonScript = $null
}

这个方案用Where-Object先筛选完全匹配项，没有的话再筛选通用项，避免循环里重复赋值，同时保证只取优先级最高的脚本。

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