Files

40 lines
2.2 KiB
PowerShell
Executable File
Raw Permalink Blame History

This file contains ambiguous Unicode characters
This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
Add-Type -AssemblyName System.Data
$conn = New-Object System.Data.SqlClient.SqlConnection('server=10.10.10.101;database=GXWMS;uid=sa;pwd=Gx@20240111;Pooling=true')
$conn.Open()
# CG0S175E0000120 在 FCOMPANYID=1 下的物料内码
$cmd = $conn.CreateCommand()
$cmd.CommandText = 'SELECT FINTERID, FCOMPANYID FROM T_BD_MATERIAL WHERE FNUMBER=''CG0S175E0000120'' AND FDELETED=0 ORDER BY FCOMPANYID'
$da = New-Object System.Data.SqlClient.SqlDataAdapter($cmd)
$dt = New-Object System.Data.DataTable
$da.Fill($dt) | Out-Null
Write-Output '=== CG0S175E0000120 各组织物料内码 ==='
$dt | Format-Table -AutoSize
# 用 FCOMPANYID=1 的内码查 BOM(模拟 EnsureProductRegistered 逻辑:SELECT TOP 1 无 ORDER BY)
$cmd2 = $conn.CreateCommand()
$cmd2.CommandText = 'SELECT TOP 1 B.FINTERID, B.FBILLNO FROM T_BD_BOM B INNER JOIN T_BD_MATERIAL M ON B.FMATERIALID=M.FINTERID WHERE M.FNUMBER=''CG0S175E0000120'' AND M.FCOMPANYID=1 AND B.FDELETED=0 AND B.FBILLNO=''V1.2.0.135.00'''
$da2 = New-Object System.Data.SqlClient.SqlDataAdapter($cmd2)
$dt2 = New-Object System.Data.DataTable
$da2.Fill($dt2) | Out-Null
Write-Output '=== EnsureProductRegistered 根BOM查询结果(TOP1 无ORDER BY)==='
$dt2 | Format-Table -AutoSize
if ($dt2.Rows.Count -gt 0) {
$bomId = $dt2.Rows[0].FINTERID
$cmd3 = $conn.CreateCommand()
$cmd3.CommandText = "SELECT COUNT(*) AS Cnt FROM T_BD_BOMENTRY WHERE FINTERID=$bomId AND FDELETED=0 AND FISFEED=0"
$r = $cmd3.ExecuteScalar()
Write-Output "该根BOM(FINTERID=$bomId)的子项数: $r"
}
# 所有 V1.2.0.135.00 BOM 的子项数
$cmd4 = $conn.CreateCommand()
$cmd4.CommandText = 'SELECT B.FINTERID, B.FBILLNO, COUNT(E.FMATERIALID) AS ChildCnt FROM T_BD_BOM B INNER JOIN T_BD_MATERIAL M ON B.FMATERIALID=M.FINTERID LEFT JOIN T_BD_BOMENTRY E ON E.FINTERID=B.FINTERID AND E.FDELETED=0 AND E.FISFEED=0 WHERE M.FNUMBER=''CG0S175E0000120'' AND B.FBILLNO=''V1.2.0.135.00'' AND B.FDELETED=0 GROUP BY B.FINTERID, B.FBILLNO ORDER BY B.FINTERID'
$da4 = New-Object System.Data.SqlClient.SqlDataAdapter($cmd4)
$dt4 = New-Object System.Data.DataTable
$da4.Fill($dt4) | Out-Null
Write-Output '=== CG0S175E0000120 所有 V1.2.0.135.00 BOM 的子项数 ==='
$dt4 | Format-Table -AutoSize
$conn.Close()