[load_grdList]
select
 row_number() over (order by mst_kbn, sort_key, han_cd) as row_no
, mst_kbn
, han_cd
, han_name
, koumoku1
, koumoku2
, koumoku3
, koumoku4
, koumoku5
, koumoku6
, koumoku7
, koumoku8
, koumoku9
, koumoku10
, sort_key
, 1 as rec_flg
from m_hanyo
where ((':mst_kbn' = '') or (mst_kbn = ':mst_kbn'))
order by mst_kbn, sort_key, han_cd

[updateDelFlg]
update m_hanyo set
	del_flg = 1
	,upd_id = ':id_user'
	,upd_time = now()
where mst_kbn = ':mst_kbn'
	and han_cd = ':han_cd'
;

[deleteRecord]
delete from m_hanyo
where mst_kbn = ':mst_kbn'

[insertRecord]
insert into m_hanyo
(
mst_kbn
, han_cd
, han_name
, koumoku1
, koumoku2
, koumoku3
, koumoku4
, koumoku5
, koumoku6
, koumoku7
, koumoku8
, koumoku9
, sort_key
, del_flg
, cre_id
, cre_time
, upd_id,
upd_time
)
values
	(
	':mst_kbn'
	, ':han_cd'
	, ':han_name'
	, ':koumoku1'
	, ':koumoku2'
	, ':koumoku3'
	, ':koumoku4'
	, ':koumoku5'
	, ':koumoku6'
	, ':koumoku7'
	, ':koumoku8'
	, ':koumoku9'
	, ':sort_key'
	, '0'
	, ''
	, 'now()'
	, ''
	, 'now()'
	);

