查询条件后追加and().or();,会导致前面查询条件失效么？

        Cnd cnd = FunctionUtils.MapToCnd(params);
        cnd.and("check_parent_orgid","=", RuntimeUtils.getOrgId());
        cnd.or("check_org_id","=", RuntimeUtils.getOrgId());

"SELECT COUNT(*) FROM reporting_info  WHERE 1=1 AND report_level=6 AND month='1' AND year='2017' AND check_state IN ('已通过','未通过','审核中') AND check_parent_orgid=5410 OR check_org_id=5410"

查询出来的结果，出现了month不匹配，check_state不匹配情况

wendal

1楼•2660天前

你需要的是 where (a = 1 and b = 2) or c = 3 这种语句??

Nooft(qq_dd2c9d2a) 2楼•2660天前

where report_level=6 AND month='1' AND year='2017' AND( a=1 OR b = 1)

wendal

3楼•2660天前

        Cnd cnd = FunctionUtils.MapToCnd(params);
        cnd.and(Cnd.exps("check_parent_orgid","=", RuntimeUtils.getOrgId().or("check_org_id","=", RuntimeUtils.getOrgId()));

wendal

4楼•2660天前

        Cnd cnd = FunctionUtils.MapToCnd(params);
        cnd.and(Cnd.exps("check_parent_orgid","=", RuntimeUtils.getOrgId()).or("check_org_id","=", RuntimeUtils.getOrgId()));

Nooft(qq_dd2c9d2a) 5楼•2660天前

嗯嗯，可以了，谢谢了，兽总

请先登陆