主从表增删改查 ​

currentPage=request.params.currentPage;
pageSize=request.params.pageSize;
keyword=count(request.params.keyword)>0?"%"+request.params.keyword+"%":"";
status = request.params.status;
zj = request.params.zj;

SELECT t1.c_id as id, t1.c_name AS sqr, t1.c_car_apply AS ycsq, t1.c_status as status, t1.c_main_content AS zyhd, TO_CHAR( t1.c_start_date, 'YYYY-MM-DD' ) || '至' || TO_CHAR( t1.c_end_date, 'YYYY-MM-DD' ) AS dlrq, t1.c_people_count as rs,t2.zylb, t2.zw, t2.zj FROM t_reception t1 LEFT JOIN ( SELECT b.* FROM ( SELECT y.c_reception_id, y.c_name AS zylb, y.c_zw AS zw, y.c_zj AS zj, ROW_NUMBER ( ) OVER ( PARTITION BY y.c_reception_id ORDER BY y.c_id ASC ) AS group_idx FROM t_reception_ry y WHERE y.c_type = '来宾' ) b WHERE b.group_idx = '1' ) t2 ON t1.c_id = t2.c_reception_id where (t2.zylb like ${keyword} or t2.zw like ${keyword}) and t1.c_status = ${status} and t2.zj= ${zj}

id = request.body.c_id;
name = request.body.c_name;
dept =request.body.c_dept;
mobile = request.body.c_mobile;
unit = request.body.c_unit;
tenantId = request.body.c_tenant_id;
mainContent = request.body.c_main_content;
peopleCount = request.body.c_people_count;
startDate = request.body.c_start_date;
endDate = request.body.c_end_date;
status = request.body.c_status;
stateId = request.body.c_state_id;
carApply = request.body.c_car_apply;
ryJson = request.body.ryJson;
fjJson = request.body.c_fj;

rs = request.body.ycForm.c_rs;
cfd = request.body.ycForm.c_cfd;
mdd = request.body.ycForm.c_mdd;
cstartDate = request.body.ycForm.c_start_date;
cendDate = request.body.ycForm.c_end_date;
ycsy = request.body.ycForm.c_ycsy;

UPDATE t_reception SET c_name = ${name}, c_dept = ${dept}, c_mobile = ${mobile}, c_unit = ${unit}, c_main_content = ${mainContent}, c_people_count=${peopleCount}, c_start_date=${startDate}, c_end_date = ${endDate}, c_status = ${status},c_state_id = ${stateId},c_car_apply=${carApply},c_fj=${fjJson} where c_id = ${id}

DELETE FROM t_reception_ry WHERE c_reception_id = ${id}

INSERT INTO t_reception_ry(c_name, c_type,c_zw, c_zj, c_reception_id) VALUES(${item.c_name}, ${item.c_type},${item.c_zw}, ${item.c_zj}, ${id});

DELETE FROM t_car_apply WHERE c_reception_id = ${id}

INSERT INTO t_car_apply(c_rs,c_cfd,c_mdd,c_start_date,c_end_date,c_ycsy,c_reception_id) VALUES(${rs},${cfd},${mdd},${cstartDate},${cendDate},${ycsy},${id});

INSERT INTO t_reception(c_name, c_dept, c_mobile, c_unit, c_tenant_id, c_main_content, c_people_count, c_start_date, c_end_date, c_status,c_state_id,c_car_apply,c_fj) VALUES(${name}, ${dept}, ${mobile}, ${unit}, ${tenantId}, ${mainContent}, ${peopleCount}, ${startDate}, ${endDate}, ${status},${stateId},${carApply},${fjJson});

map=seq.get(receptionList,0);
rId=map.c_id;

INSERT INTO t_reception_ry(c_name, c_type,c_zw, c_zj, c_reception_id) VALUES(${item.c_name}, ${item.c_type},${item.c_zw}, ${item.c_zj}, ${rId});

INSERT INTO t_car_apply(c_rs,c_cfd,c_mdd,c_start_date,c_end_date,c_clxq,c_ycsy,c_reception_id,c_tenant_id) VALUES(${rs},${cfd},${mdd},${cstartDate},${cendDate},${clxq},${ycsy},${rId},${tenantId});

select * from t_reception where c_id = ${id}

select * from t_car_apply where c_reception_id = ${id}

select * from t_reception_ry where c_reception_id = ${id}

rMap = count(data)>0?seq.get(data,0):seq.map();
seq.put(rMap,"ryList",pList);
yMap = count(ycList)>0?seq.get(ycList,0):seq.map();
seq.put(rMap,"ycForm",yMap);
seq.put(data,0,rMap);

DELETE FROM t_reception WHERE c_id = ${id};

DELETE FROM t_reception_ry WHERE c_reception_id = ${id};

DELETE FROM t_car_apply WHERE c_reception_id = ${id};