You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
61 lines
5.3 KiB
61 lines
5.3 KiB
SETPFMEASELECT=SELECT * FROM AHMC_PFMEA WHERE PROCESSPUID = \'%s\' AND REVISIONID=\'%s\' ORDER BY P5,HH
|
|
PFMEALIBRARYSELECT2=SELECT * FROM AHMC_PFMEALIBRARY WHERE PUID = \'%s\' ORDER BY HHC
|
|
|
|
BOMCHECKSAVESELECTPFMEA=SELECT MEOPID,STATION,GYBH,GCMC FROM AHMC_PFMEA WHERE PROCESSPUID = \'%s\' AND REVISIONID=\'%s\'
|
|
|
|
BOMCHECKSAVESELECTPFMEA2=SELECT * FROM AHMC_PFMEA WHERE PROCESSPUID = \'%s\' AND MEOPID NOT IN %s
|
|
|
|
DELETEPFMEA=DELETE FROM AHMC_PFMEA WHERE MEOPID = \'%s\' AND PROCESSPUID = \'%s\'
|
|
|
|
INSERTPFMEA=INSERT INTO AHMC_PFMEA VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
|
|
# ORDER BY ID
|
|
PFMEALIBRARYSELECT=SELECT * FROM AHMC_PFMEA_NODE WHERE PARENT_ID = \'%s\' ORDER BY ROWNUMD ASC
|
|
SETPFMEASELECT2=SELECT MEOPID,REQUIREMENT FROM AHMC_PFMEA WHERE PROCESSPUID = \'%s\' GROUP BY MEOPID,REQUIREMENT
|
|
SETPFMEADELETE=DELETE FROM AHMC_PFMEA WHERE PLMEID = \'%s\'
|
|
|
|
SETPFMEAUPDATE=UPDATE AHMC_PFMEA SET GYBH = ?,GCMC = ?,STATION = ?,REQUIREMENT = ?,QZSXMS = ?,QZSXHG = ?,YZD = ?,JB = ?,QZSXQY = ?,XXGCKZYF = ?,PDS = ?,XXGCKZTC = ?,TCD = ?,RPN = ?,JYCS = ?,ZZR = ?,JHWCRQ = ?,CQDCS = ?,NEW_SEV = ?,NEW_OCC = ?,NEW_DET = ?,NEW_RPN = ?,IDEAL_STATE = ?,SPECIAL = ?,HH = ?,HBDYG = ? ,OCCURRRENCE = ?,DETECTION = ?,PRIORITY = ?,P1 = ?,P2 = ?,P3 = ?,P4 = ?,P5 = ? WHERE PLMEID = \'%s\' AND REVISIONID=\'%s\'
|
|
TM2PFMEATREESELECT=SELECT * FROM AHMC_PFMEA_TREE ORDER BY PARENT_ID,ID
|
|
|
|
CONTROLPLANLIBRARYSELECT=SELECT * FROM AHMC_CONTROLPLAN_NODE WHERE PARENT_ID = \'%s\' ORDER BY ID
|
|
|
|
TM2CONTROLPLANTREESELECT=SELECT * FROM AHMC_CONTROLPLAN_TREE ORDER BY PARENT_ID
|
|
|
|
TM2THESAURUSTREESELECT=SELECT * FROM AHMC_THESAURUS_TREE ORDER BY PARENT_ID
|
|
|
|
TM2THESAURUSNODESELECT=SELECT * FROM AHMC_THESAURUS_NODE WHERE PARENT_ID = \'%s\' ORDER BY ID
|
|
|
|
PFMEALIBRARYUPDATE=UPDATE AHMC_PFMEA_NODE SET ID = ?,LSBG =?, STATION = ?,REQUIREMENT = ?,QZSXMS = ?,QZSXHG = ?,YZD = ?,JB = ?,QZSXQY = ?,XXGCKZYF = ?,PDS = ?,XXGCKZTC = ?,TCD = ?,RPN = ?,JYCS = ?,ZZR = ?,JHWCRQ = ?,CQDCS = ?,NEW_SEV = ?,NEW_OCC = ?,NEW_DET = ?,NEW_RPN = ?,IDEAL_STATE = ?,SPECIAL = ?,P1 = ?,P2 = ?,P3 = ?,P4 = ?,P5 = ?,P6 = ?,P7 = ?,P8 = ? , HBDYG=?, ROWNUMD=? WHERE PLMEID = \'%s\'
|
|
|
|
PFMEALIBRARYDELETE=DELETE FROM AHMC_PFMEA_NODE WHERE PLMEID = \'%s\'
|
|
PFMENODEDELETE=DELETE FROM AHMC_PFMEA_TREE WHERE PARENT_ID = \'%s\'
|
|
PFMEALIBRARYINSERT=INSERT INTO AHMC_PFMEA_NODE VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
|
|
|
|
#zw
|
|
CONTROLPLANSELECT=select * from ZF6_CONTROLPLAN where PROCESSPUID = \'%s\' and PUID = \'%s\' order by CAST(NO AS INT),CAST(ZF6_HH AS INT)
|
|
CONTROLPLANUPDATE=update ZF6_CONTROLPLAN set LJGCBH = ?,GCMC = ?,JQZHJJGZ = ?,BH = ?,CP = ?,GC = ?,TSTXFL = ?,CPGC = ?,JSCLJS = ?,XM = ?,RL = ?,PL = ?,ZRR = ?,KZFF = ?,FYJH = ?,NO = ?,ZF6_HH = ?,ZF6_HBDYG = ?,ZF6_HHC = ? where PLMEID = \'%s\' and PUID=\'%s\'
|
|
CONTROLPLANOPERATIONSELECT=select ZF6_MEOPID,zf6_gybh from ZF6_CONTROLPLAN where PROCESSPUID = \'%s\' and ZF6_MEOPID is not null group by ZF6_MEOPID,zf6_gybh
|
|
CONTROLPLANOPERATIONSELECT2=select ZF6_MEOPID,NO from ZF6_CONTROLPLAN where PROCESSPUID = \'%s\' and ZF6_MEOPID is not null group by ZF6_MEOPID,NO
|
|
CONTROLPLANDELETE=delete from ZF6_CONTROLPLAN where PLMEID = \'%s\'
|
|
RB3_meopNameToID=select GCMC,PROCESSID from ZF6_CONTROLPLAN where PUID = \'%s\' GROUP BY GCMC ,PROCESSID
|
|
CONTROLPLAN_IDTONO=select PROCESSID,NO from ZF6_CONTROLPLAN where PUID = \'%s\' GROUP BY PROCESSID,NO
|
|
CONTROLPLANHEADSELECT=select * from ZF6_CONTROLPLANHEAD where PUID = \'%s\'
|
|
CONTROLPLANHEADUPDATE=update ZF6_CONTROLPLANHEAD set TYPE = ?,KZJHBH = ?,ZYLXR = ?,BZRIQ = ?,XDRQ = ?,LJBH = ?,HXXZ = ?,GKGCPZ = ?,LJMC = ?,GFPZRQ = ?,GKZLPZ = ?,ZZDM = ?,QTPZ = ?,QTPZRQ = ? where PLMEID = \'%s\' and PUID=\'%s\'
|
|
INSERTSQL=insert into ZF6_CONTROLPLAN values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
|
|
RB3_PRODUCTSELECT=select * from ZF6_PRODUCTCHARACTER where PUID = \'%s\' order by CAST(NO AS INT)
|
|
RB3_PROCESSSELECT=select * from ZF6_PROCESSCHARACTER where PUID = \'%s\' order by CAST(NO AS INT)
|
|
RB3_CONTROLPLANTOGYK=select * from ZF6_CONTROLPLAN where PUID = \'%s\' AND PROCESSID = \'%s\' order by CAST(ZF6_HH AS INT)
|
|
RB3_ZYGYKHEADSELECT=select * from ZF6_ZYGYKHEAD where PUID = \'%s\'
|
|
RB3_PRODUCTDELETE=delete from ZF6_PRODUCTCHARACTER where PLMEID = \'%s\' AND PUID = \'%s\'
|
|
RB3_PROCESSDELETE=delete from ZF6_PROCESSCHARACTER where PLMEID = \'%s\' AND PUID = \'%s\'
|
|
RB3_PRODUCTUPDATE=update ZF6_PRODUCTCHARACTER set NO = ?,JCXM = ?,ZYD = ?,YQ = ?,JCFF = ?,SJ1 = ?,ZJPC = ?,SJ2 = ?,JYPC = ?,FYJH = ? where PLMEID = \'%s\' and PUID = \'%s\'
|
|
RB3_PROCESSUPDATE=update ZF6_PROCESSCHARACTER set NO = ?,JCXM = ?,ZYD = ?,YQ = ?,JCFF = ?,RL = ?,PL = ?,FYJH = ? where PLMEID = \'%s\' and PUID = \'%s\'
|
|
RB3_PRODUCTINSERT=insert into ZF6_PRODUCTCHARACTER values(?,?,?,?,?,?,?,?,?,?,?,?)
|
|
RB3_PROCESSINSERT=insert into ZF6_PROCESSCHARACTER values(?,?,?,?,?,?,?,?,?,?)
|
|
RB3_ZYGYKHEADUPDATE=update ZF6_ZYGYKHEAD set GYKLX = ?,CPXH = ?,GXMC = ?,SLYSGG = ?,SLYSCZ = ?,SBXH = ?,CHSBXH = ?,YHSBXH = ?,DJDPXH = ?,LJMC = ? where PLMEID = \'%s\' and PUID = \'%s\'
|
|
|
|
|
|
|
|
SELECTFRAMESIZE=SELECT * FROM AHMC_PFMEAFRAME_SIZE WHERE USERNAME = \'%s\' AND TYPE = \'%s\'
|
|
FRAMESIZEINSERT=INSERT INTO AHMC_PFMEAFRAME_SIZE VALUES(?,?,?,?,?,?)
|
|
FRAMESIZEDELETE=DELETE FROM AHMC_PFMEAFRAME_SIZE WHERE USERNAME = \'%s\' AND TYPE = \'%s\'
|
|
FRAMESIZEUPDATE=UPDATE AHMC_PFMEAFRAME_SIZE SET FRAMESIZE = ?, TABLE1SIZE = ?, TABLE2SIZE = ? WHERE USERNAME = \'%s\' AND TYPE = \'%s\' |