/**
* 创建 酒店房态表
* @param id
* @return deleted count
*/
public Roomstateback createRoomstateback(Roomstateback roomstateback) throws SQLException{
if(roomstateback.getId()>0){
throw new SQLException("ID must <= 0.");
}
roomstateback.setId(DBTools.getID(getSqlMapClientTemplate().getDataSource().getConnection(), "T_ROOMSTATEBACK"));
getSqlMapClientTemplate().insert("createRoomstateback",roomstateback);
if(roomstateback.getUcode()==null||roomstateback.getUcode()<1)
{
roomstateback.setUcode(roomstateback.getId());
updateRoomstatebackIgnoreNull(roomstateback);
}
return roomstateback;
}
/**
* 修改 酒店房态表但忽略空值
* @param id
* @return
*/
public int updateRoomstatebackIgnoreNull(Roomstateback roomstateback){
Roomstateback tmp = findRoomstateback(roomstateback.getId());
int flag =0;
if(roomstateback.getDatenumber()!=null){
tmp.setDatenumber(roomstateback.getDatenumber());
flag++;
}
if(roomstateback.getHotelid()!=null){
tmp.setHotelid(roomstateback.getHotelid());
flag++;
}
if(roomstateback.getRoomid()!=null){
tmp.setRoomid(roomstateback.getRoomid());
flag++;
}
if(roomstateback.getIsvalid()!=null){
tmp.setIsvalid(roomstateback.getIsvalid());
flag++;
}
if(roomstateback.getDescription()!=null){
tmp.setDescription(roomstateback.getDescription());
flag++;
}
if(roomstateback.getState()!=null){
tmp.setState(roomstateback.getState());
flag++;
}
if(roomstateback.getConfirmmethod()!=null){
tmp.setConfirmmethod(roomstateback.getConfirmmethod());
flag++;
}
if(roomstateback.getType()!=null){
tmp.setType(roomstateback.getType());
flag++;
}
if(roomstateback.getNo31()!=null){
tmp.setNo31(roomstateback.getNo31());
flag++;
}
if(roomstateback.getNo30()!=null){
tmp.setNo30(roomstateback.getNo30());
flag++;
}
if(roomstateback.getNo29()!=null){
tmp.setNo29(roomstateback.getNo29());
flag++;
}
if(roomstateback.getNo28()!=null){
tmp.setNo28(roomstateback.getNo28());
flag++;
}
if(roomstateback.getNo27()!=null){
tmp.setNo27(roomstateback.getNo27());
flag++;
}
if(roomstateback.getNo26()!=null){
tmp.setNo26(roomstateback.getNo26());
flag++;
}
if(roomstateback.getNo25()!=null){
tmp.setNo25(roomstateback.getNo25());
flag++;
}
if(roomstateback.getNo24()!=null){
tmp.setNo24(roomstateback.getNo24());
flag++;
}
if(roomstateback.getNo23()!=null){
tmp.setNo23(roomstateback.getNo23());
flag++;
}
if(roomstateback.getNo22()!=null){
tmp.setNo22(roomstateback.getNo22());
flag++;
}
if(roomstateback.getNo21()!=null){
tmp.setNo21(roomstateback.getNo21());
flag++;
}
if(roomstateback.getNo20()!=null){
tmp.setNo20(roomstateback.getNo20());
flag++;
}
if(roomstateback.getNo19()!=null){
tmp.setNo19(roomstateback.getNo19());
flag++;
}
if(roomstateback.getNo18()!=null){
tmp.setNo18(roomstateback.getNo18());
flag++;
}
if(roomstateback.getNo17()!=null){
tmp.setNo17(roomstateback.getNo17());
flag++;
}
if(roomstateback.getNo16()!=null){
tmp.setNo16(roomstateback.getNo16());
flag++;
}
if(roomstateback.getNo15()!=null){
tmp.setNo15(roomstateback.getNo15());
flag++;
}
if(roomstateback.getNo14()!=null){
tmp.setNo14(roomstateback.getNo14());
flag++;
}
if(roomstateback.getNo13()!=null){
tmp.setNo13(roomstateback.getNo13());
flag++;
}
if(roomstateback.getNo12()!=null){
tmp.setNo12(roomstateback.getNo12());
flag++;
}
if(roomstateback.getNo11()!=null){
tmp.setNo11(roomstateback.getNo11());
flag++;
}
if(roomstateback.getNo10()!=null){
tmp.setNo10(roomstateback.getNo10());
flag++;
}
if(roomstateback.getNo9()!=null){
tmp.setNo9(roomstateback.getNo9());
flag++;
}
if(roomstateback.getNo8()!=null){
tmp.setNo8(roomstateback.getNo8());
flag++;
}
if(roomstateback.getNo7()!=null){
tmp.setNo7(roomstateback.getNo7());
flag++;
}
if(roomstateback.getNo6()!=null){
tmp.setNo6(roomstateback.getNo6());
flag++;
}
if(roomstateback.getNo5()!=null){
tmp.setNo5(roomstateback.getNo5());
flag++;
}
if(roomstateback.getNo4()!=null){
tmp.setNo4(roomstateback.getNo4());
flag++;
}
if(roomstateback.getNo3()!=null){
tmp.setNo3(roomstateback.getNo3());
flag++;
}
if(roomstateback.getNo2()!=null){
tmp.setNo2(roomstateback.getNo2());
flag++;
}
if(roomstateback.getNo1()!=null){
tmp.setNo1(roomstateback.getNo1());
flag++;
}
if(roomstateback.getBack31()!=null){
tmp.setBack31(roomstateback.getBack31());
flag++;
}
if(roomstateback.getBack30()!=null){
tmp.setBack30(roomstateback.getBack30());
flag++;
}
if(roomstateback.getBack29()!=null){
tmp.setBack29(roomstateback.getBack29());
flag++;
}
if(roomstateback.getBack28()!=null){
tmp.setBack28(roomstateback.getBack28());
flag++;
}
if(roomstateback.getBack27()!=null){
tmp.setBack27(roomstateback.getBack27());
flag++;
}
if(roomstateback.getBack26()!=null){
tmp.setBack26(roomstateback.getBack26());
flag++;
}
if(roomstateback.getBack25()!=null){
tmp.setBack25(roomstateback.getBack25());
flag++;
}
if(roomstateback.getBack24()!=null){
tmp.setBack24(roomstateback.getBack24());
flag++;
}
if(roomstateback.getBack23()!=null){
tmp.setBack23(roomstateback.getBack23());
flag++;
}
if(roomstateback.getBack22()!=null){
tmp.setBack22(roomstateback.getBack22());
flag++;
}
if(roomstateback.getBack21()!=null){
tmp.setBack21(roomstateback.getBack21());
flag++;
}
if(roomstateback.getBack20()!=null){
tmp.setBack20(roomstateback.getBack20());
flag++;
}
if(roomstateback.getBack19()!=null){
tmp.setBack19(roomstateback.getBack19());
flag++;
}
if(roomstateback.getBack18()!=null){
tmp.setBack18(roomstateback.getBack18());
flag++;
}
if(roomstateback.getBack17()!=null){
tmp.setBack17(roomstateback.getBack17());
flag++;
}
if(roomstateback.getBack16()!=null){
tmp.setBack16(roomstateback.getBack16());
flag++;
}
if(roomstateback.getBack15()!=null){
tmp.setBack15(roomstateback.getBack15());
flag++;
}
if(roomstateback.getBack14()!=null){
tmp.setBack14(roomstateback.getBack14());
flag++;
}
if(roomstateback.getBack13()!=null){
tmp.setBack13(roomstateback.getBack13());
flag++;
}
if(roomstateback.getBack12()!=null){
tmp.setBack12(roomstateback.getBack12());
flag++;
}
if(roomstateback.getBack11()!=null){
tmp.setBack11(roomstateback.getBack11());
flag++;
}
if(roomstateback.getBack10()!=null){
tmp.setBack10(roomstateback.getBack10());
flag++;
}
if(roomstateback.getBack9()!=null){
tmp.setBack9(roomstateback.getBack9());
flag++;
}
if(roomstateback.getBack8()!=null){
tmp.setBack8(roomstateback.getBack8());
flag++;
}
if(roomstateback.getBack7()!=null){
tmp.setBack7(roomstateback.getBack7());
flag++;
}
if(roomstateback.getBack6()!=null){
tmp.setBack6(roomstateback.getBack6());
flag++;
}
if(roomstateback.getBack5()!=null){
tmp.setBack5(roomstateback.getBack5());
flag++;
}
if(roomstateback.getBack4()!=null){
tmp.setBack4(roomstateback.getBack4());
flag++;
}
if(roomstateback.getBack3()!=null){
tmp.setBack3(roomstateback.getBack3());
flag++;
}
if(roomstateback.getBack2()!=null){
tmp.setBack2(roomstateback.getBack2());
flag++;
}
if(roomstateback.getBack1()!=null){
tmp.setBack1(roomstateback.getBack1());
flag++;
}
if(roomstateback.getUcode()!=null){
tmp.setUcode(roomstateback.getUcode());
flag++;
}
if(roomstateback.getLanguage()!=null){
tmp.setLanguage(roomstateback.getLanguage());
flag++;
}
if(flag==0){
return 0;
}else{
return getSqlMapClientTemplate().update("updateRoomstateback",tmp);
}
}
