//TODO 将删除
System.out.println(sendSmsStr);
Connection conn=ConnectDB.getSqlServerConnection();
Statement sta=conn.createStatement();
sta=new TblSmsSendDAO().add(sta,new TblSmsSend(tr.getRecPhone(),sendSmsStr,2,tc.getCommandlibName()));
sta.executeBatch();
//执行成功+1
new TbCommandlibDAO().updateSuccCount(tc.getCommandlibId());
count++;
sta.close();
conn.close();
}
}
if(count==0){
sendSmsStr=tc.getMsgNull();
if(!"".equals(sendSmsStr.trim()))
{
Connection connn=ConnectDB.getSqlServerConnection();
Statement stn=connn.createStatement();
stn=new TblSmsSendDAO().add(stn,new TblSmsSend(tr.getRecPhone(),sendSmsStr,2,tc.getCommandlibName()));
stn.executeBatch();
//执行成功+1
new TbCommandlibDAO().updateSuccCount(tc.getCommandlibId());
stn.close();
connn.close();
//TODO 将删除
System.out.println(sendSmsStr);
}
}
}catch(Exception e){
e.printStackTrace();
sendSmsStr=tc.getMsgErr();
//TODO 将删除
if(!"".equals(sendSmsStr.trim()))
{
System.out.println(sendSmsStr);
Connection conne=ConnectDB.getSqlServerConnection();
Statement ste=conne.createStatement();
ste=new TblSmsSendDAO().add(ste,new TblSmsSend(tr.getRecPhone(),sendSmsStr,2,tc.getCommandlibName()));
ste.executeBatch();
//执行失败+1
new TbCommandlibDAO().updateFailCount(tc.getCommandlibId());
ste.close();
conne.close();
}
}
}else{
//未知指令判定
TbSetMsg tsm=new TbSetMsgDAO().getTbSetMsg();
if(tsm.getIsEnable()==0){
Connection conne=ConnectDB.getSqlServerConnection();
Statement ste=conne.createStatement();
sendSmsStr=tsm.getMsgMemo();
ste=new TblSmsSendDAO().add(ste,new TblSmsSend(tr.getRecPhone(),sendSmsStr,2,"未知指令"));
ste.executeBatch();
ste.close();
conne.close();
isNewComm=true;
}