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();
}