📄 mailorderresend.java
字号:
double dcount = 0;//+值
double spocountall = 0;//+值
double snecountall = 0;//-值
for(int itt=dtdata.getRows().getCount();itt>0;itt--){
DataRow drt=dtdata.getRow(itt-1);
accotime = drt.getString("acc_item_type");
hm.put(accotime,drt.getString("acc_item_type"));
//获取总话费和扣费信息
scount = drt.getString("fee");
//System.out.println("fee:"+scount);
try{
dcount=drt.getDouble("fee")/100;
}catch(Exception ex){
dcount = -1;
}
//System.out.println("fee:"+dcount);
if(dcount!=-1){
if((scount.substring(0,1)).equals("-")){
snecountall += dcount;
}else{
spocountall += dcount;
}
}
}
//目前只是显示小计，而非区分正值和负值
//double dcountall = snecountall+spocountall;
//为了截取2位小数点
java.text.DecimalFormat f1 = new DecimalFormat("0.00");
//获取信息
String soutcounttype="";
String sitemcount="";
double ditmecount=0;
double dbpototal=0;
double snegtotal=0;
String sifexist="";
//缴费方式
//String spaymode = "";
Object[] objhm = hm.keySet().toArray();
for(int tobj=0;tobj<objhm.length;tobj++){
Object key=objhm[tobj];
//Object value = hm.get(key);
for(int tt=0;tt<dtdata.getRows().getCount();tt++){
DataRow drtt=dtdata.getRow(tt);
if(drtt.getString("acc_item_type").equals(key.toString())){
//销帐
sifexist=drtt.getString("owe_yn");
if(sifexist.equals("0")){
sifexist="未缴费";
}else{
sifexist="已缴费";
}
//显示项目名信息
soutcounttype=drtt.getString("acc_item_type");
//显示小结信息
sitemcount=drtt.getString("fee");
try{
ditmecount = drtt.getDouble("fee")/100;
}catch(Exception ex){
ditmecount = -1;
}
if(ditmecount!=-1){
if(sitemcount.substring(0,1).equals("-")){
snegtotal += ditmecount;
}else{
dbpototal += ditmecount;
}
}
//缴费方式
//spaymode = drtt.getString("payment_method");
}
}
//if(dbpototal==0 || dbpototal==0.00)continue;
String sitemtotal = f1.format(dbpototal).toString();
if(sitemtotal.equals("0") || sitemtotal.equals("0.0") || sitemtotal.equals("0.00"))continue;
//一行一行将相同时间类型的画出来
S_AccoSpare += "<tr>"+
"<td height=\"26\" align=\"left\">"+"\n"+
"<table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" bgcolor=\"#FFFFFF\">"+"\n"+
"<tr>"+"\n"+
"<td width=\"3%\" height=\"22\"> </td>"+"\n"+
"<td width=\"42%\">"+soutcounttype+"</td>"+"\n"+
"<td width=\"40%\">"+sitemtotal+"</td>"+"\n"+
"<td width=\"15%\">"+sifexist+"</td>"+"\n"+
"</tr>"+"\n"+
"</table>"+"\n"+
"</td>"+"\n"+
"</tr>"+"\n";
//还原数据
ditmecount=0;
snegtotal=0;
dbpototal=0;
}
String spototal = f1.format(spocountall).toString();
if(spototal.equals("-0.00")){
spototal = "0.00";
}
//String snetotal = f1.format(snecountall).toString();
S_AccoSpare += "<tr>"+"\n"+
"<td height=\"25\" align=\"left\">"+"\n"+
"<table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" bgcolor=\"#FFFFFF\">"+"\n"+
"<tr>"+"\n"+//15 35 15 10 15 10 17 8
"<td width=\"15%\" align=\"left\"> </td>"+"\n"+
"<td width=\"35%\" align=\"left\" > </td>"+"\n"+
"<td width=\"15%\" height=\"25\" align=\"left\"> </td>"+"\n"+
"<td width=\"12%\" align=\"left\" > </td>"+"\n"+
"<td width=\"15%\" height=\"25\" align=\"left\">总计（元）：</td>"+"\n"+
"<td width=\"8%\" align=\"left\" >"+spototal+"</td>"+"\n"+
"</tr>"+"\n"+
"</table>"+ "\n"+
"</td>"+"\n"+
"</tr>"+"\n";
//显示实收金额,"fee_total"总计 "fee_fav"优费抵扣 "fee_pre"预存抵扣
if(fb!=null){
String sfee_total = fb.getString("fee_total");
String sfee_fav = fb.getString("fee_fav");
String sfee_pre = fb.getString("fee_pre");
double dfee_total = Double.parseDouble(sfee_total)/100;
double dfee_fav = Double.parseDouble(sfee_fav)/100;
double dfee_pre = Double.parseDouble(sfee_pre)/100;
//根据厦门小蔡反馈，需要显示实发金额=总金额-优费抵扣
//modify by zengzc 2005-12-24
dfee_total = spocountall + dfee_fav ;
dfee_total = Double.parseDouble(f1.format(dfee_total).toString());
if(String.valueOf(dfee_total).equals("-0.0") || String.valueOf(dfee_total).equals("-0.00")){
dfee_total = 0.00;
}
S_AccoSpare += "<tr>"+"\n"+
"<td height=\"25\" align=\"left\">"+"\n"+
"<table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" bgcolor=\"#FFFFFF\">"+"\n"+
"<tr>"+"\n"+//15 35 15 10 15 10 17 8
"<td width=\"7%\" align=\"left\"> </td>"+"\n"+
"<td width=\"7%\" align=\"left\" > </td>"+"\n"+
"<td width=\"18%\" height=\"25\" align=\"right\">实收（元）：</td>"+"\n"+
"<td width=\"8%\" align=\"left\" >"+dfee_total+"</td>"+"\n"+
"<td width=\"20%\" height=\"25\" align=\"right\">优费抵扣（元）：</td>"+"\n"+
"<td width=\"8%\" align=\"left\" >"+dfee_fav+"</td>"+ "\n"+
"<td width=\"20%\" height=\"25\" align=\"right\">预存抵扣（元）：</td>"+"\n"+
"<td width=\"8%\" align=\"left\" >"+dfee_pre+"</td>"+"\n"+
"</tr>"+"\n"+
"</table>"+"\n"+
"</td>"+"\n"+
"</tr>"+"\n";
}
S_AccoSpare += "</table>"+"\n";
dtdata = null;
}catch(Exception ex){
FileLogger.getLogger().warn("获取getAccoBillCollInfo列表时发生异常：", ex);
S_AccoSpare = "0";//接口异常显示
}
}else{
S_AccoSpare = "0";//接口异常显示
}
return S_AccoSpare;
}
public static String getTablelongdisInfo(String citycode,String month,String sno,DataTable _DataTableInfo ,String ipnum,String moneynum){
String S_AccoSpare = "";
try {
if(_DataTableInfo==null ){
S_AccoSpare += "0";
return S_AccoSpare;
}
S_AccoSpare +="<table width=\"710\" height=\"50\" border=\"1\" cellpadding=\"0\" cellspacing=\"0\" bordercolor=\"#DEDEDE\" style=\"border-collapse:collapse; \">"+"\n"+
"<tr bordercolor=\"#DEDEDE\"> "+"\n"+
"<td align=\"center\">"+"\n"+
"<br>长途清单查询<br>"+"\n"+
"<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\"> "+"\n"+
"<tr> "+"\n"+
"<td height=\"10\"></td>"+"\n"+
"</tr>"+"\n"+
"</table> "+"\n";
//对计费时间的处理 2005.7.21-2005.7.31
String billmonth = getBillTime(citycode,month);
S_AccoSpare += "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\"> "+"\n"+
"<tr> "+
"<td width=\"5%\" align=\"left\"> </td>"+"\n"+
"<td width=\"15%\" height=\"25\" >城市编号:</td> "+ "\n"+
"<td width=\"30%\" align=\"left\">"+citycode+"</td>"+ "\n"+
"<td width=\"15%\" align=\"center\">计费时间:</td> "+ "\n"+
"<td width=\"35%\" align=\"left\"> "+billmonth+" </td> "+ "\n"+
"</tr>"+"\n"+
"<tr> "+"\n"+
"<td width=\"5%\"> </td> "+"\n"+
"<td width=\"15%\" height=\"25\">接入号:</td> "+"\n"+
"<td width=\"30%\" align=\"left\">"+sno+"</td>"+"\n"+
"<td width=\"15%\" align=\"center\">IP话单数:</td>"+ "\n"+
"<td width=\"35%\" align=\"left\">"+ipnum+"</td>"+"\n"+
"</tr>"+"\n"+
"</table>"+"\n"+
"</td>"+"\n"+
"</tr>"+"\n";
if(moneynum.equals("0") || moneynum.equals("0.0") || moneynum.equals("0.00") || _DataTableInfo.getRows().getCount()==0){
S_AccoSpare += "<tr bordercolor=\"#DEDEDE\"> "+"\n"+
"<td height=\"25\"> 您的本月长途话费总共"+moneynum+"元。</td>"+"\n"+
"</tr>"+"\n";
}else{
S_AccoSpare += "<tr bordercolor=\"#DEDEDE\"> "+"\n"+
"<td height=\"25\"> 您的本月长途话费总共"+moneynum+"元,详细话单记录如下:</td>"+"\n"+
"</tr>"+"\n"+
"<tr bordercolor=\"#DEDEDE\"> "+"\n"+
"<td>"+"\n"+
"<table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" bgcolor=\"#EEEEEE\">"+"\n"+
"<tr> "+"\n"+
"<td width=\"3%\" align=\"left\"> </td>"+"\n"+
"<td width=\"15%\" height=\"25\" align=\"center\">清单序号</td> "+"\n"+
"<td width=\"25%\" align=\"center\">被叫号码</td>"+"\n"+
"<td width=\"25%\" align=\"center\">通话时间</td> "+"\n"+
"<td width=\"17%\" align=\"right\">实际时长</td>"+"\n"+
"<td width=\"15%\" align=\"center\">通话费用</td>"+"\n"+
"</tr>"+"\n"+
"</table>"+"\n"+
"</td>"+"\n"+
"</tr>"+"\n";
for ( int i=0; i<_DataTableInfo.getRows().getCount(); i++ )
{
DataRow dr = _DataTableInfo.getRow(i);
String srealfen=null;
String srealmiao=null;
String srealresult=null;
int irealtime=dr.getInt(4);
int ifen=irealtime/60;
int itime=ifen/60;
if(ifen==0){
srealresult=String.valueOf(irealtime)+"秒";
}else{
if(itime==0){
srealmiao=String.valueOf(irealtime-ifen*60);
srealresult=String.valueOf(ifen)+"分"+srealmiao+"秒";
}else{
srealfen=String.valueOf(ifen-itime*60);
srealmiao=String.valueOf(irealtime-ifen*60);
srealresult=String.valueOf(itime)+"时"+srealfen+"分"+srealmiao+"秒";
}
}
//被叫号码超过8位的，显示被叫号码， 反之显示 地市+被叫号码
String sPhoneNum = "";
if(dr.getString(0).length()>8){
sPhoneNum = dr.getString(0);
}else{
sPhoneNum = "0"+dr.getString(6)+"-"+dr.getString(0);
}
S_AccoSpare +="<tr> "+"\n"+
"<td>"+"\n"+
"<table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">"+"\n"+
"<tr> "+"\n"+
"<td height=\"3%\" align=\"left\"> </td>"+"\n"+
"<td width=\"15%\" height=\"25\" align=\"center\">"+(i+1)+"</td> "+"\n"+
"<td width=\"25%\" align=\"center\">"+sPhoneNum+"</td> "+"\n"+
"<td width=\"25%\" align=\"center\">"+dr.getString(1)+"</td> "+"\n"+
"<td width=\"17%\" align=\"right\">"+srealresult+"</td>"+"\n"+
"<td width=\"15%\" align=\"center\">"+dr.getString(5)+"</td>"+"\n"+
"</tr>"+"\n"+
"</table>"+"\n"+
"</td>"+"\n"+
"</tr>"+"\n";
}
}
S_AccoSpare += "</table> "+"\n";
if(citycode!=null && citycode.equals("0592")){
S_AccoSpare += "<p align=\"center\" style=\"padding-right:25px\">福建省电信有限公司厦门市分公司</p>" +"\n";
}
_DataTableInfo= null;
} catch (Exception ex) {
// TODO 自动生成 catch 块
FileLogger.getLogger().warn(sno+"获取getTablelongdisInfo列表时发生异常：", ex);
S_AccoSpare = "0";
}
return S_AccoSpare;
}
public static String getTableadslInfo(String citycode,String month,String sno,DataTable _DataTableInfo ){
String S_AccoSpare = "";
try {
if(_DataTableInfo==null ){
S_AccoSpare += "0";
return S_AccoSpare;
}
S_AccoSpare +="<table width=\"100%\" height=\"50\" border=\"1\" cellpadding=\"0\" cellspacing=\"0\" bordercolor=\"#DEDEDE\" style=\"border-collapse:collapse; \">"+"\n"+
"<tr bordercolor=\"#DEDEDE\"> "+"\n"+
"<td align=\"center\">"+"\n"+
"<br>上网清单查询<br>"+"\n"+
"<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\"> "+"\n"+
"<tr> "+"\n"+
"<td height=\"10\"></td>"+"\n"+
"</tr>"+"\n"+
"</table> "+"\n";
//对计费时间的处理 2005.7.21-2005.7.31
String billmonth = getBillTime(citycode,month);
S_AccoSpare += "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\"> "+"\n"+
"<tr> "+"\n"+
"<td width=\"5%\" height=\"25\" align=\"left\"> </td>"+"\n"+
"<td width=\"20%\" >城市编号:</td> "+ "\n"+
"<td width=\"30%\" align=\"left\">"+citycode+"</td>"+ "\n"+
"<td width=\"15%\" align=\"center\">计费时间:</td> "+ "\n"+
"<td width=\"30%\" align=\"left\"> "+billmonth+" </td> "+ "\n"+
"</tr>"+"\n"+
"<tr> "+"\n"+
"<td width=\"5%\" height=\"25\"> </td> "+"\n"+
"<td width=\"20%\" >宽带帐号:</td> "+ "\n"+
"<td width=\"30%\" align=\"left\">"+sno+"</td>"+ "\n"+
"<td width=\"15%\"> </td>"+ "\n"+
"<td width=\"30%\"> </td>"+"\n"+
"</tr>"+"\n"+
"</table>"+"\n"+
"</td>"+"\n"+
"</tr>"+"\n";
if(_DataTableInfo.getRows().getCount()==0){
S_AccoSpare +=
"<tr>"+"\n"+
"<td height=\"50\" align=\"center\">"+"\n"+
"本月没有您的上网清单记录。"+
"</td>"+"\n"+
"</tr>"+"\n"+
"</table>"+"\n";
if(citycode!=null && citycode.equals("0592")){
S_AccoSpare += "<p align=\"right\" style=\"padding-right:25px\">福建省电信有限公司厦门市分公司</p>" +"\n";
}
return S_AccoSpare;
}
S_AccoSpare += "<tr bordercolor=\"#DEDEDE\"> "+"\n"+
"<td height=\"25\"> 详细清单记录如下:</td>"+"\n"+
"</tr>"+"\n"+
"<tr bordercolor=\"#DEDEDE\"> "+"\n"+
"<td height=\"25\" align=\"left\">"+"\n"+
"<table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" bgcolor=\"#EEEEEE\">"+"\n"+
"<tr> "+"\n"+
"<td width=\"3%\" height=\"25\" align=\"center\"> </td>"+"\n"+
"<td width=\"12%\" align=\"center\">序号</td>"+"\n"+
"<td width=\"65%\" align=\"center\">开始时间</td>"+"\n"+
"<td width=\"20%\" align=\"right\">时长</td>"+"\n"+
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -