public Issuedcommand loadBySigid(Integer id) {
   String queryString = "from Issuedcommand mo where mo.sig.id = :id";
   String[] paramNames = new String[] {"id"};
   Object[] values = new Object[] {id};
   return issuedcommandDao.queryByNamedParam(queryString, paramNames, values);
 }
 public Issuedcommand loadBySigidAndNumber(int sigid, int number) {
   String queryString = "from Issuedcommand mo where mo.sig.id=:sigid and mo.number=:number";
   String[] paramNames = new String[] {"sigid", "number"};
   Object[] values = new Object[] {sigid, number};
   return issuedcommandDao.queryByNamedParam(queryString, paramNames, values);
 }
 /* (non-Javadoc)
  * @see com.jlj.service.imp.IIssuedcommandService#queryIssuedcommandByIpAddress(java.lang.String)
  */
 public Issuedcommand queryIssuedcommandByIpAddress(String ipAddress) {
   String queryString = "from Issuedcommand mo where mo.ip = :ipAddress";
   String[] paramNames = new String[] {"ipAddress"};
   Object[] values = new Object[] {ipAddress};
   return issuedcommandDao.queryByNamedParam(queryString, paramNames, values);
 }