cls
function aaa
{
$row3=$table.NewRow();
$row3["BugId1"]="23432"
$row3["BugId2"]="dfdsfbn"
$row3["BugId3"] = 12132
$row3["BugId5"] = "gjghjgjgh"
$table.Rows.Add($row3);
}
#创建数据表对象
$dataset=New-Object -TypeName System.Data.DataSet;
$table = New-Object -TypeName System.Data.DataTable;
$column1=$table.Columns.Add("BugId1",[System.String])
$column2=$table.Columns.Add("BugId2",[System.String])
$column2=$table.Columns.Add("BugId3",[System.String])
$column2=$table.Columns.Add("BugId4",[System.string])
$column2=$table.Columns.Add("BugId5",[System.string])
$row1=$table.NewRow();
$row1["BugId1"] = " acvbcvbcvbcvbvcbvcbvcbvcbvcbv "
$row1["BugId2"] = "2342342342342342342 "
$row1["BugId3"] = "234 "
$row2=$table.NewRow();
$row2["BugId1"]="23432"
$row2["BugId2"]="dfdsfbn"
$row2["BugId3"] = "12132"
$row2["BugId5"] = "gjghjgjgh"
$table.Rows.Add($row1);
$table.Rows.Add($row2);
aaa
$dataset.Tables.Add($table)
#echo $dataset.Tables[0].Columns.count
#GetDataSetString $dataset
#echo $dataset.Tables[0].Columns.count
cd "C:\Documents and Settings\jz20247\Desktop\New Folder\DPM"
$dpmQueryOutputFile = "DPMNpositionLoader_DPM_Output"
$positionFile = "${Today_YYYY}.EQRMS_position.txt"
$OFS = "|"
$dataTable = $dataSet.Tables[0]
$datableTableColumnName =@()
foreach($column in $dataTable.Columns)
{
$datableTableColumnName += $column.ColumnName
}
"$datableTableColumnName" | Out-File $dpmQueryOutputFile -Encoding Ascii
"$datableTableColumnName" | Out-File $positionFile -Encoding Ascii
#$dataTable.Rows | %{"$($_.get_ItemArray())".trim()} | Out-File $dpmQueryOutputFile -Encoding Ascii -Append
#$dataTable.Rows | %{ $item = "$($_.get_ItemArray())" ;if(! $item.Contains(".NaE")){$item.trim()}} | Out-File $positionFile -Encoding Ascii -Append
$dataTable.Rows | %{$reslut ="$($_.get_ItemArray())".trim();[regex]::Replace($reslut," *\| *","|")} | Out-File $dpmQueryOutputFile -Encoding Ascii -Append
$dataTable.Rows | %{$reslut ="$($_.get_ItemArray())".trim();if(! $reslut.Contains(".NaE")){[regex]::Replace($reslut," *\| *","|")}} | Out-File $positionFile -Encoding Ascii -Append