@Override
  public Pagination<Sanpinshenpi> sanpinshenpiinfo(
      int currentPage, int numPerPage, Sanpinshenpi s, Long jiantuanren) throws Exception {
    // TODO Auto-generated method stub
    String sql =
        "SELECT sanpinshenpi.*,CASE shenpizhuangtai WHEN '1' THEN '未审批' ELSE '已审批' END AS shenpi,sanpinzhongxin.tuanName AS tuanName,jiantuanren.userName AS jiantuanren,CASE shenpijieguo WHEN '1' THEN '审核通过' WHEN '0' THEN ''  ELSE '审核失败' END AS shenhejieguo,shenpiren.userName as shenheren   FROM sanpinshenpi LEFT JOIN sanpinzhongxin ON sanpinzhongxin.tuanNo=sanpinshenpi.tuanNo LEFT JOIN users AS jiantuanren ON sanpinzhongxin.jiantuanren = jiantuanren.id LEFT JOIN users AS shenpiren ON shenpiren.id=sanpinshenpi.shenpiuserid  WHERE 1=1 ";
    StringBuffer sb = new StringBuffer(sql);
    if (s.getShenpizhuangtai() != 0) {
      sb.append("and shenpizhuangtai = '" + s.getShenpizhuangtai() + "' ");
    }
    if (jiantuanren != null) {
      sb.append("AND sanpinzhongxin.jiantuanren= '" + jiantuanren + "' ");
    }

    return this.getPagination(currentPage, numPerPage, sb.toString());
  }
 @Override
 public boolean upsanpinshenpi(Sanpinshenpi s) throws Exception {
   // TODO Auto-generated method stub
   String sql = "UPDATE sanpinshenpi SET tijiaouserid=tijiaouserid+1-1";
   StringBuffer sb = new StringBuffer(sql);
   List l = new ArrayList();
   s.setShenpizhuangtai(2);
   if (s.getShenpizhuangtai() != 0) {
     sb.append(",shenpizhuangtai=?");
     l.add(s.getShenpizhuangtai());
   }
   if (s.getShenpijieguo() != 0) {
     sb.append(",shenpijieguo=?");
     l.add(s.getShenpijieguo());
   }
   if (s.getShenpiyijian() != null && !"".equals(s.getShenpiyijian())) {
     sb.append(",shenpiyijian=?");
     l.add(s.getShenpiyijian());
   }
   if (s.getShenpiuserid() != 0) {
     sb.append(",shenpiuserid=?");
     l.add(s.getShenpiuserid());
   }
   sb.append(",shenpitime=?");
   s.setShenpishijian(new Date());
   l.add(s.getShenpishijian());
   sb.append(" where id=?");
   l.add(s.getId());
   int num = this.update(sb.toString(), l.toArray());
   return num > 0;
 }
 @Override
 public boolean Addsanpinshenpi(Sanpinshenpi s) throws Exception {
   // TODO Auto-generated method stub
   s.setTijiaotime(new Date());
   s.setShenpizhuangtai(1);
   String sql =
       "insert into sanpinshenpi(tuanNo,tijiaouserid,beizhu,tijiaotime,shenpizhuangtai,shenpijieguo,shenpiyijian,shenpiuserid,shenpitime) values(?,?,?,?,?,?,?,?,?)";
   int num =
       this.update(
           sql,
           s.getTuanNo(),
           s.getTijiaouserid(),
           s.getBeizhu(),
           s.getTijiaotime(),
           s.getShenpizhuangtai(),
           s.getShenpijieguo(),
           s.getShenpiyijian(),
           s.getShenpiuserid(),
           s.getShenpishijian());
   return num > 0;
 }