1 /* 各工序预警开发学习 */
2 --查询数据库：KBLIVE 中 用户自定义 数据表 主要看建表时间
3 select * from sysobjects where xtype='U' ORDER BY CRDATE DESC
4
5 --预警:
6 select * from WN_DATA0001 order by ENT_DATE
7
8 --预警:解决方案
9 /*37 条数据*/
10 select * from WN_DATA0002
11
12 /*方便直观查看具体预警信息*/
13 --存储过程 WN_INFO
14 SELECT d1.PART_NUMBER,d1.CUST_NAME,d2.POSITION,d1.ENT_DATE,d1.CREATED_USER_PTR,d1.MODIFY_DATE,d1.PRODUCT_CHARACTER
15 ,d1.PRODUCT_CHARACTER,d2.PRODUCT_WARNING_CHARACTER,d2.WARNING_SOLUTION
16 FROM WN_DATA0001 d1 left join WN_DATA0002 d2
17 on d2.WN_DATA0001_PTR=d1.RKEY
18 order by d1.MODIFY_DATE DESC
19
20 PRODUCT_CHARACTER
21 FRONT_DEPT_TIMES
22 RKEY
23 WN_DATA0001_PTR
24 PRODUCT_WARNING_CHARACTER
25 POSITION WARNING_SOLUTION
26
27
28 --预警:各工序人员
29 SELECT * FROM 工序品质预警$
30
31 SELECT * FROM WN_DATA0008
32 SELECT * FROM WN_DATA0007
33 SELECT * FROM WN_DATA0006
34 SELECT * FROM WN_DATA0005
35 SELECT * FROM WN_DATA0004
36 SELECT * FROM WN_DATA0003
37 SELECT * FROM WN_DATA0002
38 SELECT * FROM WN_DATA0001
