public void setMobile(String mobile) { try { this.mobile = mobile; this.user.setMobile(tLisIdea.encryptDBString(this.mobile)); } catch (Exception ex) { } }
private String getWherePart(ArrayList<String[]> list) { // 得到系统用户来源,来确定该该用户来源于那个网站 getSysUserSource(); String[] arr = null; StringBuffer strBuff = new StringBuffer(" "); if (applyStDate != null && !"".equals(applyStDate)) { // String stDate = format.format(applyStDate); strBuff.append(" and ord.applyDate >= to_date(?,'yyyy-mm-dd')"); arr = new String[2]; arr[0] = "String"; arr[1] = applyStDate; list.add(arr); } if (applyEdDate != null && !"".equals(applyEdDate)) { // String edDate = format.format(applyEdDate); strBuff.append(" and ord.applyDate <= to_date(?,'yyyy-mm-dd')"); arr = new String[2]; arr[0] = "String"; arr[1] = applyEdDate; list.add(arr); } if (orderState != null && !"".equals(orderState.trim())) { strBuff.append(" and ord.orderState=? "); arr = new String[2]; arr[0] = "String"; arr[1] = orderState; list.add(arr); } if (mngComCity != null && !"".equals(mngComCity.trim())) { strBuff.append(" and ord.ManageCom=? "); arr = new String[2]; arr[0] = "String"; arr[1] = mngComCity; list.add(arr); } if (currency != null && !"".equals(currency.trim())) { if (this.getSysUserSourceT() != null && !"".equals(this.getSysUserSourceT())) { if (!this.getSysUserSourceT().equals("admin")) { strBuff.append(" and cont.currency=? "); arr = new String[2]; arr[0] = "String"; arr[1] = this.getSysUserSourceT().trim(); list.add(arr); } else { strBuff.append(" and cont.currency=? "); arr = new String[2]; arr[0] = "String"; arr[1] = this.currency.trim(); list.add(arr); } } else { strBuff.append(" and cont.currency=? "); arr = new String[2]; arr[0] = "String"; arr[1] = this.currency.trim(); list.add(arr); } } else { if (this.getSysUserSourceT() != null && !"".equals(this.getSysUserSourceT())) { if (!this.getSysUserSourceT().equals("admin")) { strBuff.append(" and cont.currency=? "); arr = new String[2]; arr[0] = "String"; arr[1] = this.getSysUserSourceT().trim(); list.add(arr); } } } if (productCode != null && !"".equals(productCode.trim())) { strBuff.append(" and ord.contplanCode=? "); arr = new String[2]; arr[0] = "String"; arr[1] = this.productCode.trim(); list.add(arr); } if (name != null && !"".equals(name.trim())) { strBuff.append(" and cont.appntname=? "); arr = new String[2]; arr[0] = "String"; arr[1] = name.trim(); list.add(arr); } if (orderNo != null && !"".equals(orderNo.trim())) { strBuff.append(" and ord.orderno=? "); arr = new String[2]; arr[0] = "String"; arr[1] = orderNo.trim(); list.add(arr); } if (mobile != null && !"".equals(mobile.trim())) { System.out.println("000033333"); LisIDEA tLisIdea = new LisIDEA(); System.out.println("00003344" + mobile); String tmobile = ""; try { tmobile = tLisIdea.encryptDBString(mobile); System.out.println("99999999" + tmobile); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); System.out.println("订单查询手机号码编码错误"); } // String tmobile = tLisIdea.decryptString_pre(mobile.trim()); // System.out.println("111111"+tmobile); strBuff.append( " and (select addr.mobile from lecaddress addr where addr.customerno = cont.appntno and addr.addressno = appnt.addressno)= ?"); arr = new String[2]; arr[0] = "String"; arr[1] = tmobile; list.add(arr); } /*if(this.getSysUserSourceT()!=null && !"".equals(this.getSysUserSourceT())&& !this.getSysUserSourceT().equals("admin")){ System.out.println("测试"); strBuff.append(" and cont.currency='"); strBuff.append(this.getSysUserSourceT().trim()); strBuff.append("'"); }*/ return strBuff.toString(); }