public List <MenuResult> GetMenus() { var sql = CreateSqlBuilder(new StringBuilder(@" select distinct sm.id, menu_name name, sm.parent_id parentid, sm.menu_view menuview, sm.menu_type menutype, sm.state state, sm.view_params viewparams, sm.operation_type operationtype, sm.handler, sm.icon, sm.sort, sm.sys_app_key sysappkey, sm.remark remark, sm.validate_code validatecode from fm_menu sm /* left join fm_area_menu fam on fam.menu_id = sm.id*/ left join fm_role_menu rm on sm.id = rm.menu_id left join (select ur.user_id, ur.role_id from fm_user_role ur inner join fm_role fr on ur.role_id = fr.id and fr.state = '1') ur on rm.role_id = ur.role_id where sm.state = '1' -- and (ur.user_id = '2361' or operation_type = '1' or -- (operation_type = '2' and menu_type = '3')) and sys_app_key in ('3601DE249ADF63D4E0531D82750A85F3') and Operation_type in ('1', '2') and (operation_type <> '2' or menu_type in ('1', '2', '3')) order by sort asc")); //sql.AppendInWhereHasValue(() => appkey, " and sys_app_key in ({0}) "); //sql.AppendInWhereHasValue(() => operationTypes, " and Operation_type in({0})"); //sql.AppendInWhereHasValue(() => menuTypes, " and (operation_type<>'2' or menu_type in({0}))"); //sql.Append(" order by sort asc"); return(QuerySession.ExecuteSqlString <MenuResult>(sql.ToSql(), sql.DbParams).ToList()); }
public List <RoleResult> GetRoles() { var sql = @"select role_name rolename, remark,state from fm_role"; return(QuerySession.ExecuteSqlString <RoleResult>(sql).ToList()); }