[load_grdList]
select
  mst_kbn
, han_cd
, han_name
, koumoku1
, koumoku2
, koumoku3
, koumoku4
, koumoku5
, koumoku6
--, koumoku7
, sort_key
, 1 as rec_flg
from m_hanyo
where ((':mst_kbn' = '') or (mst_kbn = ':mst_kbn'))
order by sort_key, mst_kbn, 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'
;