看了半天,实在找不出来哪里有问题了.
private Double damagegoodsfeesincome;//手工分摊收入
private Double damagegoodsfeesexpenditure;//手工分摊支出
private int waybillcount;//运单票数
private Double waybilltotalfee;//运单总收入
private Double waybillrealfee;//运单实际总收入
private int transportbill_id;//配载单 ID
private String vehiclenumberplate;//配载车辆-车牌号
private Date loadingtime;//装车时间
private String transportbillno;//装车单号
private String loadingtype;//装车类型
private Double directfee;//运费
private Double arrivaldirectfee;//到站配送费
private Double arrivaltransferfee;//到站中转费
private String drivername;//司机姓名
public TransportWaybillBillView(int transportbill_id,Date loadingtime,String transportbillno,String loadingtype,String vehiclenumberplate,
String drivername,int waybillcount, Double waybilltotalfee, Double waybillrealfee,Double directfee,
Double arrivaldirectfee,Double arrivaltransferfee,Double damagegoodsfeesincome,Double damagegoodsfeesexpenditure) {
super();
this.transportbill_id = transportbill_id;
this.loadingtime = loadingtime;
this.transportbillno = transportbillno;
this.loadingtype = loadingtype;
this.vehiclenumberplate = vehiclenumberplate;
this.drivername = drivername;
this.waybillcount = waybillcount;
this.waybilltotalfee = waybilltotalfee;
this.waybillrealfee = waybillrealfee;
this.directfee = directfee;
this.arrivaldirectfee = arrivaldirectfee;
this.arrivaltransferfee = arrivaltransferfee;
this.damagegoodsfeesincome = damagegoodsfeesincome;
this.damagegoodsfeesexpenditure = damagegoodsfeesexpenditure;
}
String sql2 = "select new com.infotoall.view.TransportWaybillBillView(" +
"tb.id,tb.loadingtime,tb.transportbillno,tb.loadingtype,tb.vehiclenumberplate,tb.drivername," +
"count(w.id) as waybillcount,sum(w.totalfee) as waybilltotalfee," +
"sum(w.realfee) as waybillrealfee,tb.totalfreight as directfee," +
"tb.totalfreight as arrivaldirectfee,sum(w.transferfee) as arrivaltransferfee," +
"sum(w.damagegoodsfeesincome),sum(w.damagegoodsfeesexpenditure)" +
") " +
"from TransportBill tb,Waybill w " +
"where tb.branch.id="+branch_id+" and w.transportbillno=tb.transportbillno GROUP BY tb.transportbillno";