添加接口，查询栈板码是否入库，返回消息，是否允许解绑

zjh

6 天以前 98958cdd70d3a63a562e9238ddecb9c6c6865e95

 StandardPda/MES.Service/service/Warehouse/WomdaaManager.cs

@@ -749,5 +749,32 @@
            return result;
        }

        /// <summary>
        /// 查询栈板码状态
        /// </summary>
        /// <param name="stackCode">栈板码</param>
        /// <returns>0-允许解绑，1-不允许解绑(已入库)</returns>
        public int GetStackCodeState(string stackCode)
        {
            var sqlHelper = new OracleSQLHelper();
            try
            {
                // 查询该栈板码是否已入库 (IS_INBOUND = 1)
                var sql = @"SELECT COUNT(*) FROM MES_PALLET_BINDING 
                           WHERE STACKCODE = :stackCode AND IS_INBOUND = 1";
                var parameters = new[] { new OracleParameter(":stackCode", stackCode ?? (object)DBNull.Value) };
                
                var count = Convert.ToInt32(sqlHelper.ExecuteScalar(sql, CommandType.Text, parameters));
                
                // 如果count > 0，说明已入库，返回1(不允许解绑)
                // 否则返回0(允许解绑)
                return count > 0 ? 1 : 0;
            }
            catch (Exception ex)
            {
                throw new Exception($"查询栈板码状态失败: {ex.Message}", ex);
            }
        }

    }
}