<h:outputText value="№ Договора"/>
<t:selectOneMenu id="somNDogovor" value="#{sessionData.account.dogID}"
    onchange="submit();">
    <f:selectItems id="siNDogovor" value="#{sessionData.account.dogovor}"/>
</t:selectOneMenu>
<h:outputText value="№ Отчета"/>
<t:selectOneMenu id="somCReport" value="#{sessionData.account.repID}"
    onchange="submit();">
    <f:selectItems id="siCReport" value="#{sessionData.account.CReport}"/>
</t:selectOneMenu>

     public   int  getDogID() {
         return  dogID;
    }

     public   void  setDogID( int  dogID) {
         if  (repID == - 1  &&  this .dogID == dogID) {
            quCReport.clearRows();
        }
         if  ( this .dogID != dogID) {
             this .dogID = dogID;
            repDate =  null ;
            quCReport.clearRows();
            
            PreparedStatement ps =  null ;
            
             try  {
                ps = quCReport.prepareSelectQuery();
                ps.setInt( 1 , dogID);
                quCReport.executeSelect();
                quCReport.closeQuery();
                 if  (quCReport.getRowCount() >  0 ) {
                    setRepID(Integer.parseInt(quCReport.getDBRows()[ 0 ].getField( 1 )));
                    repDate = CommonUtils.stringToDate(quCReport.getDBRows()[ 0 ].getField( 4 ));
                }  else  {
                    setRepID(- 1 );
                }
            }  catch  (SQLException ex) {
// здесь идет обработка catch пропустим для читаемости
            }
        }
    }

     public   int  getRepID() {
         return  repID;
    }

     public   void  setRepID( int  repID) {
         if  (repID == - 1 ) {
            quCRepContent.clearRows();
        }
         if  ( this .repID != repID) {
             this .repID = repID;
            quCRepContent.clearRows();
            
            PreparedStatement ps =  null ;
        
             try  {
                ps = quCRepContent.prepareSelectQuery();
                ps.setInt( 1 ,  this .repID);
                quCRepContent.executeSelect();
                quCRepContent.closeQuery();
            }  catch  (SQLException ex) {
// здесь идет обработка catch пропустим для читаемости
            }
        }
    }