man_mat表  mat_type int 物料类型{1:单品,2:高频,3:混放}
cust_wait_pakin表  mat_type int 物料类型{1:单品,2:高频,3:混放}
cust_wait_pakin_log表  mat_type int 物料类型{1:单品,2:高频,3:混放}

update asr_loc_mast set loc_type2 = 1 where row1 not in (3,4,11,12,18,19) and bay1 < 21
update asr_loc_mast set loc_type2 = 2 where row1 in (3,4,11,12,18,19) and bay1 < 21
update asr_loc_mast set loc_type2 = 3 where row1 >= 1 and bay1 >= 21