如何使用PowerShell将一个函数变量数据传递给另一个函数？
如何使用PowerShell将一个函数变量数据传递给另一个函数？
提问于 2016-09-30 16:05:06
我已经编写了函数mirroring，它将调用许多其他函数中的一个。为了避免重写函数'A'，我想把要调用的函数作为函数'A‘的参数来传递。例如：
function mirroring (
[string] $svr="xxxx",
[string] $inst="MSSQLSERVER2",
[string] $datastore,
[string] $datastore1,
[string] $datastore2,
[string] $datastore3,
[string] $datastore4,
[string] $datastore5,
[string] $datastore6,
[string] $datastore7,
[string] $datastore8,
[string] $datastore9,
[string] $ServerStatus1
)
{
Set-StrictMode -Version 2
[Void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.ConnectionInfo")
[Void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SMO")
[Void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SmoExtended")
$SqlConnection = New-Object System.Data.SqlClient.SqlConnection "Server=$svr\$inst;Database=master;Integrated Security=True;"
$SqlConnection.Open()
$SqlCmd = New-Object System.Data.SqlClient.SqlCommand
$SqlCmd.CommandText = " SELECT db_name(sd.[database_id])AS [Database Name]
,sd.mirroring_state AS [Mirror State Number]
,sd.mirroring_state_desc AS [Mirror State]
,sd.mirroring_partner_name AS [Partner Name]
,sd.mirroring_role_desc AS [Mirror Role]
,sd.mirroring_safety_level_desc AS [Safety Level]
,sd.mirroring_witness_name AS [Witness]
,sd.mirroring_connection_timeout AS [Timeout(sec)]
FROM sys.database_mirroring AS sd
WHERE mirroring_guid IS NOT null
ORDER BY [Database Name];"
$SqlCmd.Connection = $SqlConnection
$SqlAdapter = New-Object System.Data.SqlClient.SqlDataAdapter
$SqlAdapter.SelectCommand = $SqlCmd
$DataSet = New-Object System.Data.DataSet
$SqlAdapter.Fill($DataSet)
$DataSet.Tables[0]
$datastore = $DataSet.Tables[0].Rows[0][0]
$datastore1 = $DataSet.Tables[0].Rows[0][1]
$datastore2 = $DataSet.Tables[0].Rows[0][2]
$datastore3 = $DataSet.Tables[0].Rows[0][3]
$datastore4 = $DataSet.Tables[0].Rows[0][4]
$datastore5 = $DataSet.Tables[0].Rows[0][5]
$datastore6 = $DataSet.Tables[0].Rows[0][6]
$datastore7 = $DataSet.Tables[0].Rows[0][7]
if ($datastore2 -eq "Disconnected")
{
DisconnectedREMEDIATION
}
elseif ($datastore2 -eq "SYNCHRONIZED")
{
#$ServerStatus="The Instance Is in Synchronized State"
#$RemActonToBeTaken=1
SYNCHRONIZEDREMEDIATION
}
$ServerStatus1 = "DataBase Name:"+ $datastore+",Mirror State Number"+$datastore1+",Mirror State"+$datastore2+",Partner Name"+$datastore3+",Mirror Role"+$datastore4+",Safety Level"+$datastore5+",Witness"+$datastore6+",Timeout(In Sec)"+$datastore7
InsertServerStatus $ServerStatus1
return $ServerStatus1
$SqlConnection.Close()
}第二个函数是
function InsertServerStatus(
$ServerName="LAPTOP6\MSSQLSERVER2",
$InstanceName,
$ServerStatus1,
$RemActonToBeTaken
)
{
Write-Host $ServerStatus1
}我的问题是如何在InsertServerStatus函数中使用我的$ServerStatus1。我到底做错了什么？
回答 2
Stack Overflow用户
发布于 2016-09-30 19:09:32
如果正确，则必须使用所有参数调用函数。你应该这样调用你的函数：
InsertServerStatus $ServerName $InstanceName $ServerStatus1 $RemActonToBeTaken您正在做的是：
InsertServerStatus $ServerStatus1因此，$ServerName参数将获取ServerStatus1变量的值
Stack Overflow用户
发布于 2016-09-30 19:27:30
亲爱的所有人谢谢你的回复我得到的答案是这样的
将变量名传递给父函数
$script:ServerStatus1 = "" 插入到子函数中
function InsertServerStatus(
$ServerName="LAPTOP6\MSSQLSERVER2",
$InstanceName,
$RemActonToBeTaken
)
{
(Parent Function) mirroring
$Script:ServerStatus= $ServerStatus1
"You Code"
}页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/39786596
复制相关文章
相似问题
腾讯云开发者
