📄 salepercustractlist.java
字号:
/*
*
*/
package com.jobcn.task.old;
import java.io.BufferedReader;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.sql.*;
import com.jobcn.database.DataBase;
import com.jobcn.task.AbstractCreateHtml;
/**
* @remark:
* @author: Stephen
* @date: 2005-3-21
* @version:
* @upd_remark:
* @upd_user:
* @upd_date:
*/
final public class SALEPerCusTractList extends AbstractCreateHtml {
//constructer1
public SALEPerCusTractList() {
super(new StringBuffer(1024));
}
//constructer2
public SALEPerCusTractList(StringBuffer sb) {
super(sb);
}
public void printHeader() {
sb.append("<html>\n");
sb.append("<head>\n");
sb.append(" <title>本月签单个人排行榜</title>\n");
sb.append(" <link href=\"/BOSS_CSS/css.css\" rel=\"stylesheet\" type=\"text/css\">\n");
sb.append(" <meta http-equiv=\"content-Type\" content=\"text/html; charset=GBK\">\n");
sb.append("</head>\n");
}
public void printBody() {
java.text.DecimalFormat nf = new java.text.DecimalFormat("###,###"); //整数number
// format
//java.text.DecimalFormat Pernf = new java.text.DecimalFormat("###0.00"); //百分比
String strDate = (new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm"))
.format(new java.util.Date());
String strYear = strDate.substring(0, 4);
String strMonth = strDate.substring(5, 7);
String strDay = strDate.substring(8, 10);
//String strYearMonth = strDate.substring(0, 7);
//String strIMonth = String.valueOf(Integer.parseInt(strMonth));
//String strIDay = String.valueOf(Integer.parseInt(strDay));
DataBase db = new DataBase();
Connection DBConn = null;
Statement stmt = null;
ResultSet RS = null;
String SQL = "";
String personName = "", departmentName = "";
int tractmoney = 0, TotalNum = 0, T = 0, sequence = 0, flag = 0, range = 0;
/*
* SQL=?
*/
SQL = SQL = "select personName,T,departName,tractMoney,sequence,flag,range from PerTractMoneySequence order by sequence";
//System.out.println(SQL);
try {
DBConn = db.connect();
stmt = db.createStatement(DBConn);
sb.append("<body topmargin='0' leftmargin='0' oncontextmenu='return false;' ondragstart='return false;' onsource='return false;' onselectstart='return false;'>\n");
sb.append("<table border=\"0\" align=\"center\">\n");
sb.append("<tr>\n");
//table1:
sb.append("<td align=\"center\" valign=\"top\">\n");
sb.append("<table border=\"0\" cellpadding=\"4\" width=\"300\" cellspacing=\"1\" bgcolor=\"#CCCCCC\">\n");
sb.append("<tr bgcolor=\"#FAE8CC\" align=\"center\">\n");
sb.append("<td colspan=\"5\"><font size=\"3\">【"
+ strYear
+ "年"
+ strMonth
+ "月"
+ strDay
+ "日】签单<font color=\"red\">个人</font>龙虎榜</font><br><b>新销售人员(T<12)</b></td>\n");
sb.append("</tr>\n");
sb.append("<tr bgcolor=\"#FAE8CC\" align=\"center\">\n");
sb.append("<td width=\"15%\">名次</td>\n");
sb.append("<td width=\"20%\">业务员</td>\n");
sb.append("<td width=\"10%\">T数</td>\n");
sb.append("<td width=\"30%\">直属部门</td>\n");
sb.append("<td width=\"20%\">签单金额</td>\n");
sb.append("</tr>\n");
RS = db.getRS(stmt, SQL);
int i = 1;
while(RS.next() && !RS.isAfterLast()) {
personName = RS.getString("personName");
T = RS.getInt("T");
departmentName = RS.getString("departName");
tractmoney = RS.getInt("tractmoney");
sequence = RS.getInt("sequence");
flag = RS.getInt("flag");
range = RS.getInt("range");
if(T < 12) {
TotalNum = TotalNum + tractmoney;
sb.append("<tr align='center' bgcolor='#FFFFFF' onmouseover=\"this.bgColor='#c8ca74';\" onmouseout=\"this.bgColor='#ffffff';\">\n");
sb.append("<td>" + i + "</td>\n");
sb.append("<td>" + personName + "</td>\n");
sb.append("<td>" + T + "</td>\n");
sb.append("<td>" + departmentName + "</td>\n");
sb.append("<td align='right' >" + nf.format(tractmoney)
+ "</td>\n");
sb.append("</tr>\n");
i++;
}
}
sb.append("<tr align='center' bgcolor='#FAE8CC'><td colspan='4'>签单总额</td><td>"
+ nf.format(TotalNum) + "</td></tr>\n");
sb.append("</table>\n");
sb.append("</td>\n");
//table2:
sb.append("<td align=\"center\" valign=\"top\">\n");
sb.append("<table border=\"0\" cellpadding=\"4\" width=\"320\" cellspacing=\"1\" bgcolor=\"#CCCCCC\">\n");
sb.append("<tr bgcolor=\"#FAE8CC\" align=\"center\">\n");
sb.append("<td colspan=\"6\"><font size=\"3\">【"
+ strYear
+ "年"
+ strMonth
+ "月"
+ strDay
+ "日】签单<font color=\"red\">个人</font>龙虎榜</font><br><b>所有销售人员</b></td>\n");
sb.append("</tr>\n");
sb.append("<tr bgcolor=\"#FAE8CC\" align=\"center\">\n");
sb.append("<td width=\"12%\">名次</td>\n");
sb.append("<td width=\"15%\">升降</td>\n");
sb.append("<td width=\"18%\">业务员</td>\n");
sb.append("<td width=\"9%\">T数</td>\n");
sb.append("<td width=\"26%\">直属部门</td>\n");
sb.append("<td width=\"20%\">签单金额</td>\n");
sb.append("</tr>\n");
RS.beforeFirst();
TotalNum = 0;
while(RS.next() && !RS.isAfterLast()) {
personName = RS.getString("personName");
T = RS.getInt("T");
departmentName = RS.getString("departName");
tractmoney = RS.getInt("tractmoney");
sequence = RS.getInt("sequence");
flag = RS.getInt("flag");
range = RS.getInt("range");
TotalNum = TotalNum + tractmoney;
sb.append("<tr align='center' bgcolor='#EEEEEE' onmouseover=\"this.bgColor='#c8ca74';\" onmouseout=\"this.bgColor='#EEEEEE';\">\n");
sb.append("<td>" + sequence + "</td>\n");
if(flag == 0) {
sb.append("<td>→</td>\n");
} else if(flag == 1) {
sb.append("<td><font color=\"green\">↑</font>(" + range
+ ")</td>\n");
} else if(flag == 2) {
sb.append("<td><font color=\"red\">↓</font>(" + range
+ ")</td>\n");
}
sb.append("<td>" + personName + "</td>\n");
sb.append("<td>" + T + "</td>\n");
sb.append("<td>" + departmentName + "</td>\n");
sb.append("<td align='right' >" + nf.format(tractmoney)
+ "</td>\n");
sb.append("</tr>\n");
}
sb.append("<tr align='center' bgcolor='#FAE8CC'><td colspan='5'>签单总额</td><td>"
+ nf.format(TotalNum) + "</td></tr>\n");
sb.append("</table>\n");
sb.append("</td>\n");
//table3
sb.append("<td align=\"center\" valign=\"top\">\n");
sb.append("<table border=\"0\" cellpadding=\"4\" width=\"300\" cellspacing=\"1\" bgcolor=\"#CCCCCC\">\n");
sb.append("<tr bgcolor=\"#FAE8CC\" align=\"center\">\n");
sb.append("<td colspan=\"5\"><font size=\"3\">【"
+ strYear
+ "年"
+ strMonth
+ "月"
+ strDay
+ "日】签单<font color=\"red\">个人</font>龙虎榜</font><br><b>老销售人员(T>=12)</b></td>\n");
sb.append("</tr>\n");
sb.append("<tr bgcolor=\"#FAE8CC\" align=\"center\">\n");
sb.append("<td width=\"15%\">名次</td>\n");
sb.append("<td width=\"20%\">业务员</td>\n");
sb.append("<td width=\"10%\">T数</td>\n");
sb.append("<td width=\"30%\">直属部门</td>\n");
sb.append("<td width=\"20%\">签单金额</td>\n");
sb.append("</tr>\n");
TotalNum = 0;
i = 1;
RS.beforeFirst();
while(RS.next() && !RS.isAfterLast()) {
personName = RS.getString("personName");
T = RS.getInt("T");
departmentName = RS.getString("departName");
tractmoney = RS.getInt("tractmoney");
sequence = RS.getInt("sequence");
flag = RS.getInt("flag");
range = RS.getInt("range");
if(T >= 12) {
TotalNum = TotalNum + tractmoney;
sb.append("<tr align='center' bgcolor='#FFFFFF' onmouseover=\"this.bgColor='#c8ca74';\" onmouseout=\"this.bgColor='#ffffff';\">\n");
sb.append("<td>" + i + "</td>\n");
sb.append("<td>" + personName + "</td>\n");
sb.append("<td>" + T + "</td>\n");
sb.append("<td>" + departmentName + "</td>\n");
sb.append("<td align='right' >" + nf.format(tractmoney)
+ "</td>\n");
sb.append("</tr>\n");
i++;
}
}
sb.append("<tr align='center' bgcolor='#FAE8CC'><td colspan='4'>签单总额</td><td>"
+ nf.format(TotalNum) + "</td></tr>\n");
sb.append("</table>\n");
sb.append("</td>\n");
sb.append("</tr>\n");
sb.append("</table>\n");
sb.append("</body>\n");
/*sb.append("<script language=\"javaScript\">\n");
sb.append(" setTimeout(\"this.location.reload()\",1*60*1000);\n");
sb.append("</script>\n");*/
RS.close();
stmt.close();
DBConn.close();
} catch(Exception e) {
System.out.println(e.getMessage());
try {
RS.close();
stmt.close();
DBConn.close();
} catch(SQLException sqle) {
System.out.println(sqle.getMessage());
}
}
}
public static void main(String[] args) {
String localPath = "html\\";
String fileName = "SALEPerCusTractList.html";
long times = System.currentTimeMillis();
String strDate = (new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm")).format(new java.util.Date());
SALEPerCusTractList creator = new SALEPerCusTractList(new StringBuffer(10240));
boolean ret = creator.create(localPath, fileName);
if(ret) {
times = (System.currentTimeMillis() - times) / 1000;
System.out.println(localPath + fileName + "生成成功,时间:" + strDate + " 耗时" + times + "秒");
try {
Runtime rt = Runtime.getRuntime();
String[] cmd = new String[3];
cmd[0] = "cmd.exe";
cmd[1] = "/C";
cmd[2] = "bat\\copySALEPerCusTractList.bat";
Process proc = rt.exec(cmd);
InputStream isError = proc.getErrorStream();
InputStreamReader isrError = new InputStreamReader(isError);
BufferedReader brError = new BufferedReader(isrError);
InputStream isOutput = proc.getInputStream();
InputStreamReader isrOutput = new InputStreamReader(isOutput);
BufferedReader brOutput = new BufferedReader(isrOutput);
int retc = proc.waitFor();
if(retc==0){
System.out.println(cmd[2]+"执行成功");
String line = null;
while ((line = brOutput.readLine()) != null)
System.out.println(">>" + line);
}
else{
System.out.println(cmd[2]+"执行失败");
String line = null;
while ((line = brError.readLine()) != null)
System.out.println(">>" + line);
}
} catch (Exception e) {
e.printStackTrace();
}
}
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -