摘要:
scm 新增菜单 SELECT DISTINCT role_id FROM sys_role_menu SELECT DISTINCT menu_id FROM sys_role_menu order by menu_id SELECT * FROM sys_role_menu where menu 阅读全文
摘要:
mysql 临时表: -- 用MaterialSortID和 MatClfID关联可以获得物料分类中文 SELECT a.id,a.material_category,a.material_name,t.material_sort_name from scm_material_base a left 阅读全文