posts - 12,  comments - 2,  trackbacks - 0
          ???? /**
          ?????*?根據commutype,epId查詢分期項目下拉列框的值(LabelValueEx對象)按indexNo升序排列,lable對應typeName,value對應commTypeId
          ?????*??
          @param ??epId
          ?????*?????????????開發商Id
          ?????*?
          @param ??commutype?
          ?????*?????????????通訊方法String類型,分別為tysms,tyemail,tyfax
          ?????*?
          @return ?List
          ?????*?
          @throws ?BusinessProcessException
          ?????
          */
          ??????如果在查詢的SQL中,用到left join fetch 查詢出來的只能是一個對象,而不能是某些列?
          ???? 否則會出現沒有取到延遲加載的列的錯誤
          ?

          ????
          public ?List?getCrmCommuInfoTyFms(String?epId,String?commutype)? throws ?BusinessProcessException?{
          ????????List?dicList?
          = ? new ?ArrayList();
          ????????
          if ( ! BlankUtil.isBlank(commutype))
          ????????{????????
          ????????
          try ?{
          ????????????String?query
          = " select?info.constValueId?from?SysConstValue?info "
          ????????????????
          + " ?where?info.constValue=' " + commutype + " ' " ;
          ????????????Long?scv
          = (Long)cDao.execute(query);
          ????????????String?sql?
          = ? " from?CrmCommInfoType?info?left?join?fetch?info.communicationTy "
          ????????????????
          + ? " ?where?info.epId=' " + epId + " ' " ?
          ????????????????
          + " ?and?info.communicationTy.constValueId= " + Long.parseLong(scv.toString());
          ????????????dicList?
          = ?cDao.queryObjects(sql);
          ?????????}?
          catch ?(Exception?ex)?{
          ????????????
          throw ? new ?BusinessProcessException( " getDictData_search_001 " );
          ?????????}
          ????????}
          ????????
          return ?dicList;
          ????}

          /**
          ?????*?根據commutype,epId查詢分期項目下拉列框的值(LabelValueEx對象),lable對應typeName,value對應commTypeId
          ?????*?
          ?????*?
          @param ?epId
          ?????*????????????開發商Id
          ?????*?
          @param ?commutype
          ?????*????????????通訊方法String類型,分別為tysms,tyemail,tyfax
          ?????*?
          @return ?List
          ?????*?
          @throws ?BusinessProcessException
          ?????
          */
          ????@SuppressWarnings(
          " unchecked " )
          ????
          public ?DicSelectionModel?getCrmCommuInfoTyFms(String?epId,?String?commutype)
          ????????????
          throws ?BusinessProcessException?{
          ????????
          try ?{
          ????????????
          if ?(DictionaryServ? == ? null )?{
          ????????????????System.out.println(
          " DictionaryServ?is?null. " );
          ????????????}
          ????????????System.out.println(
          " get?dicList:------>begin " );
          ????????????List?dicList?
          = ?DictionaryServ.getCrmCommuInfoTyFms(epId,?commutype);
          ????????????System.out.println(
          " get?dicList:------>end " );
          ????????????List
          < LabelValueEx > ?labelValueList? = ? new ?ArrayList();
          ????????????Iterator?it?
          = ?dicList.iterator();
          ????????????
          // ?System.out.println("***************?Iterator?begin");
          ????????????labelValueList.add( new ?LabelValueEx( " 請選擇 " ,? 0 ));
          ????????????
          while ?(it.hasNext())?{
          ????????????????CrmCommInfoType?result?
          =
          ?(CrmCommInfoType)?it.next();
          ????????????????String?label?
          = ?result.getTypeName();???????????????????????????????????? ?//根據對象取到響應的列的值
          ????????????????
          long ?value? = ?result.getCommTypeId();
          ????????????????LabelValueEx?labelValue?
          = ? new ?LabelValueEx(label,?value);
          ????????????????labelValueList.add(labelValue);
          ????????????}

          ????????????DicSelectionModel?dicSelectionModel?
          = ? new ?DicSelectionModel(
          ????????????????????labelValueList);
          ????????????
          return ?dicSelectionModel;
          ????????}?
          catch ?(Exception?ex)?{
          ????????????
          throw ? new ?BusinessProcessException( " getCrmCommuInfoTyFms() " );
          ????????}
          ????}

          ?



          如果沒有用到延遲加載 可以返回 已知的列
          ????
          ????
          /**
          ?????*?根據epId查詢分析項下拉列框的值(LabelValue對象),lable對應constNameChs,value對應constName
          ?????*??
          @param??epId
          ?????*?????????????開發商Id
          ?????*?
          @return?List
          ?????*?
          @throws?BusinessProcessException
          ?????
          */
          ????
          public?List?getAnalyseItem(String?epId)?throws?BusinessProcessException?{
          ????????String?sql?
          =?"select?info.constNameChs,info.constName?from?SysConst?info"
          ????????????
          +?"?where?info.epId='"+epId+"'"
          ????????????
          +?"?and?flag='2'";
          ????????List?dicList?
          =?new?ArrayList();

          ????????
          try?{
          ????????????dicList?
          =?cDao.queryObjects(sql);
          ????????}?
          catch?(Exception?ex)?{
          ????????????
          throw?new?BusinessProcessException("getAnalyseItem()");
          ????????}
          ????????
          return?dicList;
          ????}

          posted on 2006-09-23 11:58 doodoosun 閱讀(276) 評論(0)  編輯  收藏

          只有注冊用戶登錄后才能發表評論。


          網站導航:
           

          <2006年9月>
          272829303112
          3456789
          10111213141516
          17181920212223
          24252627282930
          1234567

          常用鏈接

          留言簿(1)

          隨筆分類(6)

          隨筆檔案(11)

          文章分類(30)

          文章檔案(34)

          搜索

          •  

          最新評論

          閱讀排行榜

          評論排行榜

          主站蜘蛛池模板: 靖江市| 徐州市| 合江县| 凤翔县| 临朐县| 云浮市| 蓝田县| SHOW| 湘西| 昭通市| 荣昌县| 南城县| 喀喇沁旗| 屏东市| 九龙县| 齐齐哈尔市| 洪泽县| 西充县| 宝清县| 个旧市| 康保县| 稻城县| 广平县| 淄博市| 巴中市| 阳原县| 大同市| 缙云县| 潜山县| 淄博市| 资兴市| 石城县| 北海市| 玉林市| 乐业县| 福建省| 兴城市| 洛川县| 盐亭县| 彰武县| 凯里市|