/** 增加批准建议 */
public boolean addRatifyAdvice(RatifyAdvice ratifyAdvice) throws ManagerException {
boolean r = false;
DBUtil db = new DBUtil();
String delSql =
"delete TD_SD_RATIFYADVICE where SCHEDULAR_ID = " + ratifyAdvice.getSchedularID() + "";
String sql =
"insert into TD_SD_RATIFYADVICE (SCHEDULAR_ID,RATIFIER_ID,advice) values("
+ ratifyAdvice.getSchedularID()
+ ","
+ ratifyAdvice.getRatifierID()
+ ",'"
+ ratifyAdvice.getAdvice()
+ "')";
try {
db.executeDelete(delSql);
db.executeInsert(sql);
r = true;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return r;
}
