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\'