📄 mailorderresend.java
字号:
String S_MAILLOG = "";
try {
if (month == null || month.equals("") || month.length() != 6)
return false;
String ordersort = getOrderSort(mailcomm);
if(ordersort==null || ordersort.equals(""))
return false;
S_MAILLOG=
"select b.MAILORDERID,b.ordersort,a.productid, a.phonenum, a.citycode, c.email,c.ACCOUNTID,d.faultcount"+
" from tf_andcustrela a, tf_mailorder b, tf_custinfoweb c ,tl_maillog_"+month+" d "+
" where "+
" a.andcustrelaid = b.andcustrelaid and a.userid = c.userid and c.accountid=d.userid" +
" and d.mailorderid=b.mailorderid "+
" and c.userid='"+userid+"' and a.phonenum = '"+phonenum+"' and b.startmonth <= "+month+" and b.endmonth >= "+month+" and b.ordersort='"+ordersort+"' "+
" and a.state = 'E' and b.state = 'E' and c.state = 'E' and d.state='E'"+
" and c.email='"+email+"'";
//System.out.println("checkmailsend-S_MAILLOG:"+S_MAILLOG);
_dac.beginTransaction(10000);
DataTable ret = _dac.executeQuery(S_MAILLOG);
_dac.endTransaction(true);
if (ret != null) {
if (ret.getRows().getCount() != 1) {
return false;
}
String faultcount="";
for (int t = 0; t < ret.getRows().getCount(); t++) {
faultcount = ret.getRow(t).getString("faultcount");
}
if(faultcount!=null && !faultcount.equals("") && faultcount.equals("10")){
return true;
}
}
} catch (Exception ex) {
FileLogger.getLogger().info("checkmailsend发生异常："+S_MAILLOG, ex);
}
return false;
}
/**
*
* @param sinfo
* @return
*/
public static String getFZAccoBillPartInfo(String strcitycode ,String sno,String month,DataTable dtdata){
String S_AccoSpare = "";
if(dtdata != null){
String s_month = month.substring(0,4)+"年"+month.substring(4,6)+"月";
if(dtdata.getRows().getCount()==0){
S_AccoSpare =
"<table width=\"710\" height=\"100\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">"+"\n"+
"<tr align=\"center\" valign=\"middle\">"+"\n"+
"<td width=\"25%\">计费时间：</td>"+"\n"+
"<td width=\"25%\">"+s_month+"</td>"+"\n"+
"<td width=\"25%\">电话号码：</td>"+"\n"+
"<td width=\"25%\">"+strcitycode+"-"+sno+"</td>"+"\n"+
"</tr>"+
"<tr align=\"center\" valign=\"middle\">"+"\n"+
"<td colspan=\"4\"> </td>"+"\n"+
"</tr>"+
"<tr align=\"center\" valign=\"middle\">"+"\n"+
"<td colspan=\"4\">对不起，本月没有您的话费数据。</td>"+"\n"+
"</tr>"+
"<tr align=\"center\" valign=\"middle\">"+"\n"+
"<td colspan=\"4\"> </td>"+"\n"+
"</tr>";
if(strcitycode!=null && strcitycode.equals("0592")){
S_AccoSpare += "<tr align=\"center\" valign=\"middle\">"+"\n"+
"<td colspan=\"4\">福建省电信有限公司厦门市分公司</td>"+"\n"+
"</tr>"+"\n";
}
S_AccoSpare +="</table>";
return S_AccoSpare;
}
try{
//计费金额
double dfee =0;
double dfeetotal =0;
for(int imm=0;imm<dtdata.getRows().getCount();imm++){
DataRow drfee=dtdata.getRow(imm);
dfee = drfee.getDouble("fee");
dfeetotal += dfee/100;
}
/* if(dfeetotal==0 || dfeetotal==0.0 || dfeetotal==0.00){
S_AccoSpare = "0";
return S_AccoSpare;
}*/
//计费周期
String sstarttime="";//计费开始时间
String sendtime=""; //计费结束时间
int idealendtime=0;//处理计费结束时间
String sbilltime=""; //计费周期
for(int imonth=0;imonth<dtdata.getRows().getCount();imonth++){
DataRow drtt=dtdata.getRow(0);
//对开始时间进行处理
sstarttime=drtt.getString("bill_bdate");
sstarttime=sstarttime.substring(0,4)+"."+sstarttime.substring(4,6)+"."+sstarttime.substring(6,8);
//对结束时间进行处理
sendtime=drtt.getString("bill_edate");
//福州的计费周期多了一天，暂时这么处理，等待接口方更新
idealendtime = Integer.parseInt(sendtime.substring(6,8));
sendtime=sendtime.substring(0,4)+"."+sendtime.substring(4,6)+"."+String.valueOf(idealendtime);
sbilltime=sstarttime+"-"+sendtime;
break;
}
S_AccoSpare += "<p align=\"left\" style=\"padding-left:25px\">"+s_month+"您的月结话费汇总信息如下：</p>" +"\n"+
"<table width=\"710\" border=\"1\" cellpadding=\"0\" cellspacing=\"0\" bordercolor=\"#DEDEDE\" style=\"border-collapse:collapse; \">"+"\n"+
"<tr>"+"\n"+
"<td> "+"\n"+
"<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">"+"\n"+
"<tr>"+"\n"+
"<td width=\"3%\" align=\"left\"> </td>"+"\n"+
"<td width=\"12%\" >计费周期：</td>"+"\n"+
"<td width=\"30%\" align=\"left\" >"+sbilltime+"</td>"+"\n"+
"<td width=\"15%\" height=\"25\" align=\"left\">城市编号：</td>"+"\n"+
"<td width=\"10%\" align=\"left\" >"+strcitycode+"</td>"+"\n"+
"<td width=\"15%\" height=\"25\" align=\"left\">电话号码:</td>"+"\n"+
"<td width=\"15%\" align=\"left\" >"+strcitycode+"-"+sno+"</td>"+"\n"+
"</tr>"+"\n"+
"</table>"+"\n"+
"</td>"+"\n"+
"</tr>"+"\n"+
"<tr>"+"\n"+
"<td height=\"26\" align=\"left\">"+"\n"+
"<table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" bgcolor=\"#EEEEEE\">"+"\n"+
"<tr>"+"\n"+
"<td width=\"3%\" height=\"25\"> </td>"+"\n"+
"<td width=\"42%\" >帐目名称</td>"+"\n"+
"<td width=\"40%\" >金额(元)</td>"+"\n"+
"<td width=\"15%\" >缴费情况</td>"+"\n"+
"</tr>"+"\n"+
"</table>"+"\n"+
"</td>"+"\n"+
"</tr>"+"\n";
//按照计费项目分项目显示信息
HashMap hm=new HashMap();
//获取计费项目名
String accotime = "";
//获取总话费和扣费信息
String scount = "";
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="";
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;
}
}
}
}
//目前福州显示总值
double ditemcountall = snegtotal+dbpototal;
//if(ditemcountall==0 || ditemcountall==0.00)continue;
String sitemtotal = f1.format(ditemcountall).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(dcountall).toString();
if(spototal.equals("-0.00")){
spototal = "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=\"15%\" align=\"left\"> </td>"+"\n"+
"<td width=\"35%\" align=\"left\" > </td>"+"\n"+
"<td width=\"15%\" height=\"25\" align=\"left\"> </td>"+"\n"+
"<td width=\"10%\" align=\"left\" > </td>"+"\n"+
"<td width=\"15%\" height=\"25\" align=\"left\">总计(元):</td>"+"\n"+
"<td width=\"10%\" align=\"left\" >"+spototal+"</td>"+"\n"+
"</tr>"+"\n"+
"</table>"+"\n"+
"</td>"+"\n"+
"</tr>"+"\n"+
"</table>"+"\n";
if(strcitycode!=null && strcitycode.equals("0592")){
S_AccoSpare += "<p align=\"right\" style=\"padding-right:25px\">福建省电信有限公司厦门市分公司</p>" +"\n";
}
dtdata = null;
}catch(Exception ex){
FileLogger.getLogger().warn(sno+"获取getFZAccoBillCollInfo列表时发生异常：", ex);
S_AccoSpare = "0";}
}else{
S_AccoSpare = "0";//接口异常显示
}
return S_AccoSpare;
}
public static String getAccoBillCollInfo(String strcitycode ,String strcityname,String sno,String month,DataTable dtdata,FormBody fb){
String S_AccoSpare = "";
if(dtdata != null){
if(dtdata.getRows().getCount()==0){
//S_AccoSpare += getTableFrameInfo("对不起，本月没有您的话费数据。");
S_AccoSpare += "0";
return S_AccoSpare;
}
try{
//计费金额
double dfee =0;
double dfeetotal =0;
for(int imm=0;imm<dtdata.getRows().getCount();imm++){
DataRow drfee=dtdata.getRow(imm);
dfee = drfee.getDouble("fee");
dfeetotal += dfee/100;
}
if(dfeetotal==0 || dfeetotal==0.0 || dfeetotal==0.00){
S_AccoSpare += "0";
return S_AccoSpare;
}
//计费周期
String sstarttime="";//计费开始时间
String sendtime=""; //计费结束时间
String sbilltime=""; //计费周期
for(int imonth=0;imonth<dtdata.getRows().getCount();imonth++){
DataRow drtt=dtdata.getRow(0);
//对开始时间进行处理
sstarttime=drtt.getString("bill_bdate");
sstarttime=sstarttime.substring(0,4)+"."+sstarttime.substring(4,6)+"."+sstarttime.substring(6,8);
//对结束时间进行处理
sendtime=drtt.getString("bill_edate");
sendtime=sendtime.substring(0,4)+"."+sendtime.substring(4,6)+"."+sendtime.substring(6,8);
sbilltime=sstarttime+"-"+sendtime;
break;
}
String s_month = month.substring(0,4)+"年"+month.substring(4,6)+"月";
S_AccoSpare += "<p align=\"left\" style=\"padding-left:25px\">您"+s_month+"的月结话费汇总信息如下：</p>" +"\n"+
"<table width=\"680\" border=\"1\" cellpadding=\"0\" cellspacing=\"0\" bordercolor=\"#DEDEDE\" style=\"border-collapse:collapse; \">"+"\n"+
"<tr>"+"\n"+
"<td> "+"\n"+
"<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">"+"\n"+
"<tr>"+"\n"+
"<td width=\"3%\" align=\"left\"> </td>"+"\n"+
"<td width=\"15%\" >计费周期：</td>"+"\n"+
"<td width=\"30%\" align=\"left\" >"+sbilltime+"</td>"+"\n"+
"<td width=\"15%\" height=\"25\" align=\"left\">城市编号：</td>"+"\n"+
"<td width=\"10%\" align=\"left\" >"+strcitycode+"</td>"+"\n"+
"<td width=\"12%\" height=\"25\" align=\"left\">产品号：</td>"+"\n"+
"<td width=\"15%\" align=\"left\" >"+sno+"</td>"+"\n"+
"</tr>"+"\n"+
"</table>"+"\n"+
"</td>"+"\n"+
"</tr>"+"\n"+
"<tr>"+"\n"+
"<td height=\"26\" align=\"left\">"+"\n"+
"<table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" bgcolor=\"#EEEEEE\">"+"\n"+
"<tr>"+"\n"+
"<td width=\"3%\" height=\"25\"> </td>"+"\n"+
"<td width=\"42%\" >帐目名称</td>"+"\n"+
"<td width=\"40%\" >金额（元）</td>"+ "\n"+
"<td width=\"15%\" >缴费情况</td>"+"\n"+
"</tr>"+"\n"+
"</table>"+"\n"+
"</td>"+"\n"+
"</tr>"+"\n";
//按照计费截至时间分时间段显示信息
HashMap hm=new HashMap();
//获取计费截至时间
String accotime = "";
//获取总话费和扣费信息
String scount = "";
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -