// Added by Zhubx 2009-06-03 加密解密手机号
public String getMobile() {
try {
this.mobile = tLisIdea.decryptString_pre(this.user.getMobile());
return mobile;
} catch (Exception ex) {
return "";
}
}
public void queryOrderInfo() {
orderInfoList = new ArrayList<String[]>();
String orderInfoSQL =
"select ord.orderNo, cont.AppntName, (case cont.AppntSex when 'M' then '男' when 'F' then '女' else '不详' end),"
+ " cont.AppntBirthday,(select a.codename from ledcode a where codetype='idtype' and a.code=cont.AppntIDType), cont.AppntIDNo,"
+ " cont.InsuredName, (case cont.InsuredSex when 'M' then '男' when 'F' then '女' else '不详' end), cont.InsuredBirthday,"
+ " (select b.name from ledcom b where b.comcode=ord.managecom),"
+ " (select c.ContPlanName from lepplan c where c.PlanType='00' and c.ContPlanCode=ord.ContPlanCode),cont.Amnt, cont.Prem,"
+ " (select a.codename from ledcode a where codetype='orderState' and a.code=ord.orderState),ord.ApplyDate,ord.AcceptDate,"
+ " ord.AcceptPolDate,(select sitename from ledadsource t where t.sitecode=cont.currency and t.productcode='readIndex'), "
+ " (select addr.mobile from lecaddress addr where addr.customerno = cont.appntno and addr.addressno = appnt.addressno)"
+ " from LECOrderInfo ord,LECCont cont,lecappnt appnt where ord.OrderNo=cont.OrderNo and cont.contno = appnt.contno and ord.ManageCom=cont.ManageCom";
ArrayList<String[]> list = new ArrayList<String[]>();
orderInfoSQL = orderInfoSQL + getWherePart(list);
orderInfoSQL = orderInfoSQL + " order by cont.OrderNo, cont.ContNo";
ExeSQL exeSQL = new ExeSQL();
SSRS tSSRS = exeSQL.execSQL(orderInfoSQL, list);
if (tSSRS == null) {
ECPubFun.addErrorMessage(Constants.BUNDLE_PROGRAM, "query_fail");
} else {
for (int i = 1; i <= tSSRS.MaxRow; i++) {
String[] tOrderInfo = new String[tSSRS.MaxCol];
for (int j = 2; j <= tSSRS.MaxCol; j++) {
tOrderInfo[j - 2] = tSSRS.GetText(i, j - 1);
}
String tmobile = tSSRS.GetText(i, tSSRS.MaxCol);
LisIDEA md = new LisIDEA();
try {
tmobile = md.decryptString_pre(tmobile);
} catch (Exception ex) {
}
tOrderInfo[tSSRS.MaxCol - 1] = tmobile;
this.setOrderInfo(tOrderInfo);
orderInfoList.add(tOrderInfo);
}
}
}
