生成sql部分:考过来如下
INSERT INTO QYLJB
( XLID , MC , XH , SX , ZD , BZ , QYLJID )
VALUES ( :XLID , :MC , :XH , :SX , :ZD , :BZ , YLJID )
UPDATE QYLJB
SET XLID = :XLID ,
MC = :MC ,
XH = :XH ,
SX = :SX ,
ZD = :ZD ,
BZ = :BZ ,
QYLJID = YLJID
WHERE ( XLID = :OLD__XLID )
DELETE FROM QYLJB
WHERE ( XLID = :OLD__XLID ) |