ZF-关于海南的增删改需求

时间：2024-10-29 10:35:56
select * from BUSS_PUBLIC_CASE where org_id in (17,34)

select * from BUSS_PUBLIC_CASE where org_id in (40,49,50)

select * from BUSS_PUBLIC_CASE where org_id in (21,27)

select * from BUSS_PUBLIC_CASE where org_id in ('','');

select * from SYS_ORGAN where org_name = '区教体局'

update sys_organ set org_name = '综合行政执法局' where org_short_name = '区行政执法局'

select * from BUSS_PUBLIC_CASE c where 1=1 and c.org_id= 31 and c.del_flag='' order by c.start_date desc

select * from SYS_ORGAN where (org_name = '区商务局' or org_name = '经信局' )

select * from SYS_ORGAN where (org_short_name = '老石旦小学' or org_short_name = '桃花小学' )

select * from BUSS_PUBLIC_CASE where org_id in (30,31)

 select org_dist_code,* from SYS_ORGAN

 select * from SYS_AREA

 select * from SYS_ORGAN where org_oid in (17,34)

delete from sys_organ where org_oid = 7

/**

更改部门删除实业单位

*/

update sys_organ set org_name = null,org_short_name = null,org_layer = null where org_oid in (34,31,49,50,27,39,64,66);

update BUSS_PUBLIC_CASE set applicant_id = '',org_id = '',applicant_name = '经信局',org_name = '经信局' where org_id in ('','');

update sys_organ set org_name = '经信局',org_short_name = '经信局' where org_short_name = '区经信局';

update BUSS_PUBLIC_CASE set applicant_id = '',org_id = '',applicant_name = '农牧林业局',org_name = '农牧林业局'where org_id in ('','');

update sys_organ set org_name = '农牧林业局',org_short_name = '农牧林业局' where org_short_name = '区农牧业局';

update BUSS_PUBLIC_CASE set applicant_id = '',org_id = '',applicant_name = '市场监督管理局(食品药品监督管理局）',org_name = '市场监督管理局(食品药品监督管理局）' where org_id in ('','','');

update sys_organ set org_name = '市场监督管理局(食品药品监督管理局）',org_short_name = '市场监督管理局(食品药品监督管理局）' where org_short_name = '区食药监局';

update BUSS_PUBLIC_CASE set applicant_id = '',org_id = '',applicant_name = '卫生和计划生育局',org_name = '卫生和计划生育局'where org_id in ('','');

update sys_organ set org_name = '卫生和计划生育局',org_short_name = '卫生和计划生育局' where org_short_name = '区计生局';

update BUSS_PUBLIC_CASE set applicant_id = '',org_id = '',applicant_name = '安监局（煤炭管理局）',org_name = '安监局（煤炭管理局）'where org_id in ('','');

update sys_organ set org_name = '安监局（煤炭管理局）',org_short_name = '安监局（煤炭管理局）' where org_short_name = '区煤炭局';

update sys_organ set org_name = '教育局' where org_short_name = '区教体局'

update sys_organ set org_name = '文化旅游体育局' where org_short_name = '区文化旅游局'

/**

1.在区发展和改革局前增加*办公室

*/

insert into sys_organ values (71,10,15300,1,'*办公室','*办公室',00,000,'','',0,0,0,0,0,1,1) // 倒数第二列等于2 那么就不会显示在网页中
// 这里不是根据主键来取值的,是根据order_number列和org_seqs列来取值的(这2列的值一样)，并且根据大小排列

sys_organ表里面 org_name 应该是用作标识的,org_short_name 网页是读取这个字段来显示出的名字,org_layer 这个字段等于1 那么就会显示在网页中

相关文章