?public List<IosPersonInfoBO> queryCorpLists(IosPersonInfoBO object,
???List<String> depIdList, boolean loadext) throws Exception {
??Session session = super.getSession();

??List<IosPersonInfoBO> objectBOList = new ArrayList();
??// 初始化一個查詢總記錄SQL語句的字符串
??StringBuffer queryAcountString = new StringBuffer(
????"select count(ipi.Oid)");
??// 初始化一個查詢的SQL語句的字符串
??StringBuffer queryString = new StringBuffer(
????"select {ipi.*},{ipie.*},{idi.*}");
??// 判斷是否是買家還是賣家
??queryAcountString
????.append(" from ios_person_info ipi "
??????+ " left join ios_person_info_ext ipie on ipi.oid = ipie.user_id "
??????+ " left join ios_dept_info idi on? ipi.int_deptid = idi.int_dept_id "
??????+ " where ipi.stop_flag = 0 ");

??queryString
????.append(" from ios_person_info ipi "
??????+ " left join ios_person_info_ext ipie on ipi.oid = ipie.user_id "
??????+ " left join ios_dept_info idi on? ipi.int_deptid = idi.int_dept_id "
??????+ " where ipi.stop_flag = 0 ");
??// 根據loadext選用不同的查詢條件
??if (loadext) {
???// 判斷部門列表是否為空
???if (depIdList != null && depIdList.size() > 0) {
????queryAcountString = queryAcountString.append(" and ( ");
????queryString = queryString.append(" and ( ");
????for (int i = 1; i < depIdList.size(); i++) {
?????queryAcountString = queryAcountString
???????.append(" ipi.int_deptid = ? or");
?????queryString = queryString.append(" ipi.int_deptid = ? or");
????}
????queryAcountString = queryAcountString
??????.append(" ipi.int_deptid = ? )");
????queryString = queryString.append(" ipi.int_deptid = ? )");
???} else {
????// 部門ID是否為空
????if (object.getIntDeptid() != null
??????&& !object.getIntDeptid().equalsIgnoreCase("")) {
?????queryAcountString = queryAcountString
???????.append(" and ipi.int_deptid = ? ");
?????queryString = queryString
???????.append(" and ipi.int_deptid = ? ");
????}
???}
??} else {
???// 部門ID是否為空
???if (object.getIntDeptid() != null
?????&& !object.getIntDeptid().equalsIgnoreCase("")) {
????queryAcountString = queryAcountString
??????.append(" and ipi.int_deptid = ? ");
????queryString = queryString.append(" and ipi.int_deptid = ? ");
???}
??}
??// oid是否為空
??if (object.getOid() != null && !object.getOid().equalsIgnoreCase("")) {
???queryAcountString = queryAcountString.append(" and ipi.oid = ?");
???queryString = queryString.append(" and ipi.oid = ?");
??}
??// 姓名是否為空
??if (object.getUserName() != null
????&& !object.getUserName().equalsIgnoreCase("")) {
???queryAcountString = queryAcountString
?????.append(" and ipi.user_name like ?");
???queryString = queryString.append(" and ipi.user_name like ?");
??}
??// 登陸ID是否為空
??if (object.getStrLoginId() != null
????&& !object.getStrLoginId().equalsIgnoreCase("")) {
???queryAcountString = queryAcountString
?????.append(" and ipi.str_login_id = ?");
???queryString = queryString.append(" and ipi.str_login_id = ?");
??}
??// 集團ID是否為空
??if (object.getGroupId() != null
????&& !object.getGroupId().equalsIgnoreCase("")) {
???queryAcountString = queryAcountString
?????.append(" and ipi.group_id = ?");
???queryString = queryString.append(" and ipi.group_id = ?");
??}

??// 職務是否為空
??if (object.getHeadship() != null
????&& !object.getHeadship().equalsIgnoreCase("")) {
???queryAcountString = queryAcountString
?????.append(" and ipi.headship like ?");
???queryString = queryString.append(" and ipi.headship like ?");
??}
??// 判斷userNo是否為空
??if (object.getUserNo() != null
????&& !object.getUserNo().equalsIgnoreCase("")) {
???queryAcountString = queryAcountString
?????.append(" and ipi.user_no like ?");
???queryString = queryString.append(" and ipi.user_no like ?");
??}
??// 首選呼叫號碼是否為空
??if (object.getExtBo().getPrimaryCallPhone() != null
????&& !object.getExtBo().getPrimaryCallPhone()
??????.equalsIgnoreCase("")) {
???queryAcountString = queryAcountString
?????.append(" and ipie.primary_call_phone like ?");
???queryString = queryString
?????.append(" and ipie.primary_call_phone like ?");
??}
??// 首選短信號碼是否為空
??if (object.getExtBo().getPrimarySmPhone() != null
????&& !object.getExtBo().getPrimarySmPhone().equalsIgnoreCase("")) {
???queryAcountString = queryAcountString
?????.append(" and ipie.primary_sm_phone = ?");
???queryString = queryString.append(" and ipie.primary_sm_phone = ?");
??}
??// 生日當天自動發送生日祝福
??if (object.getExtBo().getBirthdayCongraduationYn() != null
????&& !object.getExtBo().getBirthdayCongraduationYn()
??????.equalsIgnoreCase("")) {
???queryAcountString = queryAcountString
?????.append(" and ipie.birthday_congraduation_yn = ?");
???queryString = queryString
?????.append(" and ipie.birthday_congraduation_yn = ?");
??}
??// 啟用生日提醒是否為空
??if (object.getExtBo().getBirthdayHintValid() != null
????&& !object.getExtBo().getBirthdayHintValid().equalsIgnoreCase(
??????"")) {
???queryAcountString = queryAcountString
?????.append(" and ipie.birthday_hint_valid = ?");
???queryString = queryString
?????.append(" and ipie.birthday_hint_valid = ?");
??}
??// 模糊查詢是否為空
??if (object.getIllegibilityQuery() != null
????&& !object.getIllegibilityQuery().equalsIgnoreCase("")) {
???queryAcountString = queryAcountString
?????.append(" and ( ipi.email like ? or ipi.fax like ? or "
???????+ " ipi.employee_no like ? or ipi.user_name like ? or "
???????+ " ipie.OFFICIAL_PHONE like ? or ipie.HOME_PHONE like ? or "
???????+ " ipie.MOBILE like ? or ipie.XIAO_LING_TONG like ? or "
???????+ " ipie.qq like ? or ipie.msn like ?) ");
???queryString = queryString
?????.append(" and ( ipi.email like ? or ipi.fax like ? or "
???????+ " ipi.employee_no like ? or ipi.user_name like ? or "
???????+ " ipie.OFFICIAL_PHONE like ? or ipie.HOME_PHONE like ? or "
???????+ " ipie.MOBILE like ? or ipie.XIAO_LING_TONG like ? or "
???????+ " ipie.qq like ? or ipie.msn like ?) ");
??}
??// 生日日期(無年份的)是否為空
??if (object.getBirthdayWithoutYear() != null
????&& !object.getBirthdayWithoutYear().equalsIgnoreCase("")) {
???queryAcountString = queryAcountString
?????.append(" and to_char(ipi.BIRTHDAY,'mm-dd') like ?");
???queryString = queryString
?????.append(" and to_char(ipi.BIRTHDAY,'mm-dd') like ?");
??}

??queryAcountString = queryAcountString
????.append(" order by idi.dep_id_sort_list , ipi.user_name ");
??queryString = queryString
????.append(" order by idi.dep_id_sort_list , ipi.user_name ");
??Logger.getRootLogger().info("queryString:" + queryString.toString());

??// 將queryAcountString中的屬性放入Query集中
??SQLQuery qCount = session.createSQLQuery(queryAcountString.toString());

??// 將queryString中的屬性放入Query集中
??SQLQuery q = session.createSQLQuery(queryString.toString());
??int m = 0;
??int n = 0;

??// 根據loadext選用不同的查詢條件
??if (loadext) {
???// 判斷部門列表是否為空
???if (depIdList != null && depIdList.size() > 0) {
????for (int j = 0; j < depIdList.size(); j++) {
?????q.setString(m++, (String) depIdList.get(j));
?????qCount.setString(n++, (String) depIdList.get(j));
????}
???} else {
????// 判部門ID是否為空，否則分別給queryAcountString和queryString中判斷條件賦值
????if (object.getIntDeptid() != null
??????&& !object.getIntDeptid().equalsIgnoreCase("")) {
?????q.setString(m++, object.getIntDeptid());
?????qCount.setString(n++, object.getIntDeptid());
????}
???}
??} else {
???// 判部門ID是否為空，否則分別給queryAcountString和queryString中判斷條件賦值
???if (object.getIntDeptid() != null
?????&& !object.getIntDeptid().equalsIgnoreCase("")) {
????q.setString(m++, object.getIntDeptid());
????qCount.setString(n++, object.getIntDeptid());
???}
??}
??// 判斷oid是否為空，否則給查詢屬性賦值
??if (object.getOid() != null && !object.getOid().equalsIgnoreCase("")) {
???qCount.setString(m++, object.getOid());
???q.setString(n++, object.getOid());
??}
??// 判斷姓名是否為空，否則分別給queryAcountString和queryString中判斷條件賦值
??if (object.getUserName() != null
????&& !object.getUserName().equalsIgnoreCase("")) {
???q.setString(m++, "%" + object.getUserName() + "%");
???qCount.setString(n++, "%" + object.getUserName() + "%");
??}
??// 判斷登陸ID是否為空，否則分別給queryAcountString和queryString中判斷條件賦值
??if (object.getStrLoginId() != null
????&& !object.getStrLoginId().equalsIgnoreCase("")) {
???q.setString(m++, object.getStrLoginId());
???qCount.setString(n++, object.getStrLoginId());
??}
??// 判斷集團ID是否為空，否則分別給queryAcountString和queryString中判斷條件賦值
??if (object.getGroupId() != null
????&& !object.getGroupId().equalsIgnoreCase("")) {
???q.setString(m++, object.getGroupId());
???qCount.setString(n++, object.getGroupId());
??}

??// 判斷職務是否為空，否則分別給queryAcountString和queryString中判斷條件賦值
??if (object.getHeadship() != null
????&& !object.getHeadship().equalsIgnoreCase("")) {
???q.setString(m++, "%" + object.getHeadship() + "%");
???qCount.setString(n++, "%" + object.getHeadship() + "%");
??}
??// 判斷userNo是否為空
??if (object.getUserNo() != null
????&& !object.getUserNo().equalsIgnoreCase("")) {
???q.setString(m++, "%" + object.getUserNo() + "%");
???qCount.setString(n++, "%" + object.getUserNo() + "%");
??}
??// 判斷首選呼叫號碼是否為空，否則分別給queryAcountString和queryString中判斷條件賦值
??if (object.getExtBo().getPrimaryCallPhone() != null
????&& !object.getExtBo().getPrimaryCallPhone()
??????.equalsIgnoreCase("")) {
???q.setString(m++, "%" + object.getExtBo().getPrimaryCallPhone()
?????+ "%");
???qCount.setString(n++, "%" + object.getExtBo().getPrimaryCallPhone()
?????+ "%");
??}
??// 判斷首選短信號碼是否為空，否則分別給queryAcountString和queryString中判斷條件賦值
??if (object.getExtBo().getPrimarySmPhone() != null
????&& !object.getExtBo().getPrimarySmPhone().equalsIgnoreCase("")) {
???q.setString(m++, object.getExtBo().getPrimarySmPhone());
???qCount.setString(n++, object.getExtBo().getPrimarySmPhone());
??}
??// 生日當天自動發送生日祝福
??if (object.getExtBo().getBirthdayCongraduationYn() != null
????&& !object.getExtBo().getBirthdayCongraduationYn()
??????.equalsIgnoreCase("")) {
???q.setString(m++, object.getExtBo().getBirthdayCongraduationYn());
???qCount.setString(n++, object.getExtBo()
?????.getBirthdayCongraduationYn());
??}
??// 啟用生日提醒是否為空
??if (object.getExtBo().getBirthdayHintValid() != null
????&& !object.getExtBo().getBirthdayHintValid().equalsIgnoreCase(
??????"")) {
???q.setString(m++, object.getExtBo().getBirthdayHintValid());
???qCount.setString(n++, object.getExtBo().getBirthdayHintValid());
??}
??// 判斷模糊查詢是否為空，否則分別給queryAcountString和queryString中判斷條件賦值
??if (object.getIllegibilityQuery() != null
????&& !object.getIllegibilityQuery().equalsIgnoreCase("")) {
???for (int k = 0; k < 10; k++) {
????q.setString(m++, "%" + object.getIllegibilityQuery() + "%");
????qCount
??????.setString(n++, "%" + object.getIllegibilityQuery()
????????+ "%");
???}
??}
??// 判斷生日日期(無年份的)是否為空，否則分別給queryAcountString和queryString中判斷條件賦值
??if (object.getBirthdayWithoutYear() != null
????&& !object.getBirthdayWithoutYear().equalsIgnoreCase("")) {
???q.setString(m++, "%" + object.getBirthdayWithoutYear() + "%");
???qCount.setString(n++, "%" + object.getBirthdayWithoutYear() + "%");
??}

??// 是否需要分頁
??if (object.getPageFlag() == null || "".equals(object.getPageFlag())) {
???// 設置記錄總數
???object.getPageData().setTotalRow(
?????((java.math.BigDecimal) (qCount.list().iterator().next()))
???????.intValue());

???// 設置頁面第一行記錄
???q.setFirstResult((object.getPageData().getPageNum() - 1)
?????* object.getPageData().getPageSize());

???// 設置每頁記錄的最大數
???q.setMaxResults(object.getPageData().getPageSize());
??}

??q.addEntity("ipi", IosPersonInfo.class);
??q.addEntity("ipie", IosPersonInfoExt.class);
??q.addEntity("idi", IosDeptInfo.class);

??// 存放q里的記錄
??List<Object[]> objectList = q.list();

??IosPersonInfoBO iosPersonInfoBO;

??IosPersonInfoExtBO iosPersonInfoExtBO;

??Iterator iter = objectList.iterator();

??// 遍歷列表，將列表中的屬性賦給EpsOrderBO對象
??while (iter.hasNext()) {
???iosPersonInfoBO = new IosPersonInfoBO();
???iosPersonInfoExtBO = new IosPersonInfoExtBO();
???Object[] o = (Object[]) iter.next();

???IosPersonInfo iosPersonInfo = (IosPersonInfo) o[0];
???IosPersonInfoExt iosPersonInfoExt = (IosPersonInfoExt) o[1];
???IosDeptInfo iosDeptInfo = (IosDeptInfo) o[2];

???// 將iosPersonInfo轉化為iosPersonInfoBO
???IosPersonInfoHelper personHelp = new IosPersonInfoHelper();
???iosPersonInfoBO = personHelp.wrapPersonInfoMtoB(iosPersonInfo);
???if (iosPersonInfoExt != null) {
????IosPersonInfoExtHelper extHelp = new IosPersonInfoExtHelper();
????iosPersonInfoExtBO = extHelp
??????.wrapPersonInfoExtMtoB(iosPersonInfoExt);
????iosPersonInfoBO.setExtBo(iosPersonInfoExtBO);
???}
???if (iosDeptInfo != null) {
????iosPersonInfoBO.setDeptName(iosDeptInfo.getStrName());
???}
???objectBOList.add(iosPersonInfoBO);
???this.getSession().evict(iosPersonInfo);
???this.getSession().evict(iosPersonInfoExt);
???this.getSession().evict(iosDeptInfo);
??}
??return objectBOList;
?}

轉載于:https://www.cnblogs.com/liaomin416100569/archive/2009/12/18/9332060.html

總結

以上是生活随笔為你收集整理的不知道对象的传递那些参数的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。