String hql = "update TProjectDTO t set t.status=?,t.updateUserid=?,t.updateDate=? where t.projectId=?";
String signparthql = "update TSignpartDTO t set t.status=?,t.updateUserid=?,t.updateDate=? where t.tbTProjectDTO.projectId=?";
String contrartorhql = "update TSignpartContractoDTO t set t.status=?,t.updateUserid=?,t.updateDate=? where exists (select s.signpartId from TSignpartDTO s where t.tbTSignpartDTO.signpartId=s.signpartId and s.tbTProjectDTO.projectId=?)";
这里有三个表,知道projectId,修改TSignpartContractoDTO 表状态。简单示例。没时间,只能如此,日后补充
String signparthql = "update TSignpartDTO t set t.status=?,t.updateUserid=?,t.updateDate=? where t.tbTProjectDTO.projectId=?";
String contrartorhql = "update TSignpartContractoDTO t set t.status=?,t.updateUserid=?,t.updateDate=? where exists (select s.signpartId from TSignpartDTO s where t.tbTSignpartDTO.signpartId=s.signpartId and s.tbTProjectDTO.projectId=?)";
这里有三个表,知道projectId,修改TSignpartContractoDTO 表状态。简单示例。没时间,只能如此,日后补充