[load_grdList]
select
  mst_kbn
, han_cd
, han_name
, koumoku1
, koumoku2
, koumoku3
, koumoku4
, koumoku5
--, koumoku6
from v_hanyo_all
where ((':mst_kbn' = '') or (mst_kbn = ':mst_kbn'))
and ((':han_cd' = '') or (han_cd = ':han_cd'))
and ((':hin_cd' = '') or (han_cd = ':hin_cd'))
and ((':koumoku1' = '') or (koumoku1 = ':koumoku1'))
and ((':koumoku2' = '') or (koumoku2 = ':koumoku2'))
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'
;
