📄 mailorderresend.java
字号:
"</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(1);
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+"秒";
}
}
S_AccoSpare +="<tr> "+"\n"+
"<td height=\"26\"align=\"left\">"+"\n"+
"<table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">"+"\n"+
"<tr> "+"\n"+
"<td width=\"3%\" height=\"25\" align=\"center\"> </td>"+"\n"+
"<td width=\"12%\" align=\"center\">"+(i+1)+"</td>"+"\n"+
"<td width=\"65%\" align=\"center\">"+dr.getString(0)+"</td>"+"\n"+
"<td width=\"20%\" align=\"right\">"+srealresult+"</td>"+"\n"+
"</tr>"+"\n"+
"</table>"+"\n"+
"</td>"+"\n"+
"</tr>"+"\n";
}
//合计总分钟数
int itotalf=0;
int itimelongf=0;
if(_DataTableInfo!=null){
for(int itotal=0; itotal<_DataTableInfo.getRows().getCount();itotal++){
DataRow drtotalf = _DataTableInfo.getRow(itotal);
itimelongf=drtotalf.getInt("TIMELONG");
itotalf += itimelongf;
}
}
String timetotal ="";
int itimefen = itotalf/60;
int itimehour = itimefen/60;
int dttimetotal = itotalf%60;
if(dttimetotal>=30){
timetotal = String.valueOf(itimehour)+"时"+String.valueOf(itimefen-itimehour*60+1)+"分";
}else{
timetotal = String.valueOf(itimehour)+"时"+String.valueOf(itimefen-itimehour*60)+"分";
}
S_AccoSpare +="<tr>"+"\n"+
"<td height=\"25\" align=\"left\" style=\"padding-left:30px\">" +"\n"+
"合计总时长： "+String.valueOf(timetotal)+"("+String.valueOf(itotalf)+")秒"+"\n"+
"</td>"+"\n"+
"</tr>"+"\n";
S_AccoSpare += "</table> "+"\n";
if(citycode!=null && citycode.equals("0592")){
S_AccoSpare += "<p align=\"right\" style=\"padding-right:25px\">福建省电信有限公司厦门市分公司</p>" +"\n";
}
_DataTableInfo= null;
} catch (Exception ex) {
// TODO 自动生成 catch 块
FileLogger.getLogger().warn(sno+"获取getTableadslInfo列表时发生异常：", ex);
S_AccoSpare = "0";
}
return S_AccoSpare;
}
/**
* 信息费查询
* @param citycode
* @param month
* @param sno
* @param _DataTableInfo
* @param ipnum
* @param moneynum
* @return
*/
public static String getTableoneseInfo(String citycode,String month,String sno,DataTable _DataTableInfo ,String recordnum,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\">总话单数:</td>"+ "\n"+
"<td width=\"35%\" align=\"left\">"+recordnum+"</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=\"10%\" height=\"25\" align=\"center\">清单序号</td> "+"\n"+
"<td width=\"18%\" align=\"center\">被叫号码</td>"+"\n"+
"<td width=\"17%\" align=\"center\">节目号</td> "+"\n"+
"<td width=\"20%\" align=\"right\">通话时间</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{
if(dr.getString(0).length()>0){
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=\"10%\" height=\"25\" align=\"center\">"+(i+1)+"</td> "+"\n"+
"<td width=\"18%\" align=\"center\">"+sPhoneNum+"</td> "+"\n"+
"<td width=\"17%\" align=\"center\">"+dr.getString("degree")+"</td> "+"\n"+
"<td width=\"20%\" 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 getBillTime(String citycode ,String month){
String S_Bill_Time = "";
if(month==null || month.equals("") || month.length()!=6){
return null;
}
String _year = month.substring(0,4);
String _month = month.substring(4,5);
String calemm = null;//日历上取到的月份信息
if(_month.equals("0")){
_month = month.substring(5,6);
}else{
_month = month.substring(4,6);
}
java.util.Calendar calendar=java.util.Calendar.getInstance();
//月份设置的信息和天数有关，比如10月的31日，在设置6月份时会得到7月的信息
int dd = calendar.get(Calendar.DATE);
String sdd = String.valueOf(dd);
if(dd>27){
calendar.set(Calendar.DATE,Integer.parseInt("27"));
}
//2005年是帐单月，2006以后是自然月
if(_year.equals("2005")){
if(_month.equals("12")){
return "2005.11.21-2005.12.31";
}
//起始时间
String _startday="0";
String startname="InternetShowBillStartTime";
String sbillst = ServiceFactory.getSystemConfigList(startname);
EMessage _ebillst = new EMessage(sbillst);
DataTable dtstart= _ebillst.getDataTableBody();
if (dtstart != null) {
for (int i = 0; i < dtstart.getRows().getCount(); i++) {
DataRow dr = dtstart.getRow(i);
if(dr.getString("CITYCODE").equals(citycode)){
_startday=dr.getString("PARAVALUE");
}
}
}
// 结束时间
String _endday="0";
String endname="InternetShowBillEndTime";
String sbillet = ServiceFactory.getSystemConfigList(endname);
EMessage _ebillet = new EMessage(sbillet);
DataTable dtend= _ebillet.getDataTableBody();
if (dtend != null) {
for (int ii = 0; ii < dtend.getRows().getCount(); ii++) {
DataRow drr = dtend.getRow(ii);
if(drr.getString("CITYCODE").equals(citycode)){
_endday=drr.getString("PARAVALUE");
}
}
}
calendar.set(Calendar.YEAR,Integer.parseInt(_year));
calendar.set(Calendar.MONTH,Integer.parseInt(_month));
calemm = String.valueOf(calendar.get(calendar.MONTH));
if(calemm.equals(_month)){
S_Bill_Time = String.valueOf(calendar.get(calendar.YEAR)) +"."+ String.valueOf(calendar.get(calendar.MONTH)-1)+"."+_startday+"-";
S_Bill_Time += String.valueOf(calendar.get(calendar.YEAR)) +"."+ String.valueOf(calendar.get(calendar.MONTH))+"."+_endday;
}
}else{
//美国的日期格式是从0－11排列，中国是从1－12排列，利用这个误差，可以获取“当前月”最后一天的日子
calendar.set(Calendar.MONTH,Integer.parseInt(_month));
calendar.set(Calendar.DAY_OF_MONTH,1);
calendar.add(Calendar.DAY_OF_MONTH,-1);
int lastDay = calendar.get(Calendar.DAY_OF_MONTH);
//要取“当前月”信息，要重新设置
calendar.add(Calendar.DAY_OF_MONTH,1);
calemm = String.valueOf(calendar.get(calendar.MONTH));
if(calemm.equals(_month)){
S_Bill_Time = String.valueOf(calendar.get(calendar.YEAR)) +"."+ String.valueOf(calendar.get(calendar.MONTH))+"."+"1"+"-";
S_Bill_Time += String.valueOf(calendar.get(calendar.YEAR)) +"."+ String.valueOf(calendar.get(calendar.MONTH))+"."+String.valueOf(lastDay);
}
}
// System.out.println("S_Bill_Time00000000:"+S_Bill_Time);
return S_Bill_Time;
}
/**
* 对tatable中无值情况的统一处理
* scitycode地市编码，stype配置信息表中的类型
*/
public static String getTableFrameInfo(String sinfo){
String stable = "";
stable += "<table width=\"100%\" height=\"249\" border=\"0\">"+
"<tr align=\"center\" valign=\"middle\">"+
"<td>"+sinfo+"</td>"+
"</tr>"+
"</table>";
return stable;
}
/**
* 对打tatable中无值情况的统一处理
* scitycode地市编码，stype配置信息表中的类型
*/
public static String getEmptyInfo(String scitycode,String stype){
String stable = "";
String sinfo = "";
String serr = "资源忙,请稍等......";
String sresutl = "";
if(scitycode.equals("") || stype.equals("")){
sresutl = serr;
}
sinfo = Getforwinfo.qrytd_showinfo(scitycode,stype);
if(!sinfo.equals("-1") && !sinfo.equals("-2")){
sresutl = sinfo;
}else{
sresutl = serr;
}
stable += "<table width=\"650\" height=\"249\" border=\"0\">"+
"<tr align=\"center\" valign=\"middle\">"+
"<td align=\"center\">"+sresutl+"</td>"+
"</tr>"+
"</table>";
return stable;
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -