INSERT INTO CL_JYBDCLMX
( id , CL_ID , CheckSL , Depository , Remark , AlreadyIn , CheckNO , DHCLMX_ID )
VALUES ( :id , :CL_ID , :CheckSL , epository , :Remark , :AlreadyIn , :CheckNO , HCLMX_ID )
UPDATE CL_JYBDCLMX
SET id = :id ,
CL_ID = :CL_ID ,
CheckSL = :CheckSL ,
Depository = epository ,
Remark = :Remark ,
AlreadyIn = :AlreadyIn ,
CheckNO = :CheckNO ,
DHCLMX_ID = HCLMX_ID
WHERE ( id = :OLD__id )
DELETE FROM CL_JYBDCLMX
WHERE ( id = :OLD__id ) |