"LC786965UW:光盘播放器的单芯片数字信号处理器LSI.PDF综合文档"

需积分: 17 0 下载量 94 浏览量 更新于2024-03-25 收藏 484KB PDF 举报
The ON SEMI_LC786965UW is a single-chip digital signal processor LSI designed for use in compact disc players. This integrated circuit combines ARM7TDMI-S™, CD servo control, CD signal processing, compressed audio decode processing, and audio signal processing all in one package. Additionally, the LC786965UW features various interface functions including SIO and UART, which help reduce the processing load on the external main controller and ensure high performance. Overall, the LC786965UW is a comprehensive solution for handling the various signals and processing tasks required for efficient operation of a CD player. Its integration of multiple functions into a single chip simplifies system design, reduces overall component count, and ultimately helps improve the performance of the CD player. By providing a seamless interface between the CD player components, the LC786965UW enhances the overall user experience and delivers high-quality audio output. In conclusion, the ON SEMI_LC786965UW is a versatile and highly efficient digital signal processor LSI that caters specifically to the needs of compact disc players. Its advanced features, compact design, and superior performance make it an ideal choice for manufacturers looking to enhance the functionality and performance of their CD player products. With the LC786965UW, users can enjoy a seamless and high-quality audio experience, making it a valuable addition to any compact disc player system.

优化这段sql:WITH user_worker AS (SELECT Title, ID FROM [biUser]) SELECT user_worker.Title AS worker, COUNT(CASE WHEN (CASE WHEN bl.Checker = 0 THEN '' WHEN bl.Checker > 0 AND bl.Audited = -1 THEN 'NG' WHEN bl.Checker > 0 AND bl.Audited = 1 THEN 'OK' END) ='' THEN 1 END) as nullstr, COUNT(CASE WHEN (CASE WHEN bl.Checker = 0 THEN '' WHEN bl.Checker > 0 AND bl.Audited = -1 THEN 'NG' WHEN bl.Checker > 0 AND bl.Audited = 1 THEN 'OK' END) = 'OK' THEN 1 END) as okstr, COUNT(CASE WHEN (CASE WHEN bl.Checker = 0 THEN '' WHEN bl.Checker > 0 AND bl.Audited = -1 THEN 'NG' WHEN bl.Checker > 0 AND bl.Audited = 1 THEN 'OK' END) = 'NG' THEN 1 END) as NGstr, (COUNT(CASE WHEN (CASE WHEN bl.Checker = 0 THEN '' WHEN bl.Checker > 0 AND bl.Audited = -1 THEN 'NG' WHEN bl.Checker > 0 AND bl.Audited = 1 THEN 'OK' END) = 'OK' THEN 1 END) +COUNT(CASE WHEN (CASE WHEN bl.Checker = 0 THEN '' WHEN bl.Checker > 0 AND bl.Audited = -1 THEN 'NG' WHEN bl.Checker > 0 AND bl.Audited = 1 THEN 'OK' END) ='' THEN 1 END) )as totalOKStr FROM [bdWorkOrderList] bl LEFT JOIN [bdWorkOrder] bd ON bl.OrderID = bd.ID LEFT JOIN [reportMJWXJL] rwx ON bl.OrderID = rwx.OrderID LEFT JOIN [reportMJQHLHJL] rqh ON bl.OrderID = rqh.OrderID LEFT JOIN user_worker ON user_worker.ID = bl.Worker WHERE bd.IsDeleted = 0 AND bl.StepName LIKE 'Maker%' AND bl.StepName IN ('Maker修模', 'maker切换料号', 'Maker模具保养') AND DATEPART(MONTH, bl.StartTime) = DATEPART(MONTH, GETDATE()) and DATEPART(YEAR, bl.StartTime) = DATEPART(YEAR, GETDATE()) GROUP BY user_worker.Title

2023-07-15 上传