代码如下:
@Override
public void add(List<PMS_TeamWorker> pmsTeamWorkers) {
if(exist(pmsTeamWorkers))
{
throw new RuntimeException("添加失败,相同人员不允许重复!");
}
super.insertList(pmsTeamWorkers);
}
private Boolean exist(List<PMS_TeamWorker> pmsTeamWorkers){
boolean flag = false;
String sql = "";
for(PMS_TeamWorker item:pmsTeamWorkers){
//要用别名,super.select 会转驼峰,不然会报错
sql = "SELECT 1 value \n" +
"FROM " + DataBase.PROJECT_DBNAME + ".dbo.PMS_TeamWorker\n" +
"where workerKid = " + TextUtil.QuoteStr(item.getWorkerKid());
flag = super.select(sql).size() > 0;
if(flag){
break;
}
}
return flag;
}