使用泛型优化分仓库明细

最新推荐文章于 2014-04-19 08:15:41 发布

orvill

最新推荐文章于 2014-04-19 08:15:41 发布

阅读量469

点赞数

分类专栏： eas-bos 代码

本文链接：https://blog.csdn.net/orvill/article/details/24032933

版权

eas-bos 代码专栏收录该内容

22 篇文章 0 订阅

订阅专栏

package com.kingdee.eas.iscm.report.app;

import org.apache.log4j.Logger;

import com.kingdee.bos.BOSException;
import com.kingdee.bos.Context;
import com.kingdee.bos.ctrl.extcommon.server.DbUtil;
import com.kingdee.eas.common.EASBizException;
import com.kingdee.eas.framework.report.util.RptParams;
import com.kingdee.jdbc.rowset.IRowSet;

import java.sql.SQLException;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Collections;
import java.util.Comparator;
import java.util.Date;
import java.util.List;




public class OrdercheckFacadeControllerBean extends AbstractOrdercheckFacadeControllerBean
{
    private static Logger logger =
        Logger.getLogger("com.kingdee.eas.iscm.report.app.OrdercheckFacadeControllerBean");

@SuppressWarnings("unchecked")

protected RptParams _query(Context ctx, RptParams params)   {
     List<ordercheck> list = new ArrayList<ordercheck>();
  int type = 0 ;
  List ls = new ArrayList();
  ls.add(params.getObject("orderno"));

  StringBuffer sql1 = new StringBuffer("select * from t_ord_saleorder where fnumber like ");
  sql1.append(" ?");
  IRowSet rs = null;
  try {
   rs = DbUtil.executeQuery(ctx, sql1.toString(), ls.toArray());
   while(rs.next()){
    type = rs.getInt("FOrderType");
   }
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }

  if (type == 1 ){
//   StringBuffer sql = new StringBuffer("select * from ordercheck1");
//   sql.append(" where orderno like ?");
//   sql.append(" and orderseq = ? order by warehouse,fcreatetime");
//   ls.add(params.getObject("orderseq"));
      StringBuilder transql = new StringBuilder(); // 调拨单
                    transql.append(" /*dialect*/ SELECT t_inv_translate.FNumber,t_inv_translate.FOrderEntryID,                      \r\n");
                    transql.append("t_inv_translate.FProductTraitID,NVL(NULL, '调拨业务') TYPE,NVL(NULL, 0) factor,                   \r\n");
                    transql.append("CASE t_inv_translate.foldwarehouseid WHEN 'OREFiNXMQlG+KVU8XEWGLYui6QQ=' THEN '东经仓库'          \r\n");
                    transql.append("WHEN 'uIS48yP4Rw+3zvvekNmFi4ui6QQ=' THEN '乐清仓库'   END warehouse,                              \r\n");
                    transql.append(" CASE t_inv_translate.fnewwarehouseid WHEN 'OREFiNXMQlG+KVU8XEWGLYui6QQ=' THEN '东经仓库'         \r\n");
                    transql.append(" WHEN 'uIS48yP4Rw+3zvvekNmFi4ui6QQ=' THEN '乐清仓库'   END warehouse2,t_inv_translate.famount,    \r\n");
                    transql.append(" CASE t_inv_translate.faudited WHEN 1 THEN '已审核'                                               \r\n");
                    transql.append(" ELSE ''END audited,                                                                             \r\n");
                    transql.append(" t_inv_translate.fcreatorid,t_inv_translate.fcreatetime fcreatetime,                             \r\n");
                    transql.append(" t_inv_translate.flastupdateuserid,t_inv_translate.flastupdatetime,                              \r\n");
                    transql.append(" t_inv_translate.fauditorid,t_inv_translate.faudittime FROM t_inv_translate                       \r\n");
                    transql.append(" LEFT JOIN T_ORD_SaleOrderentry ON t_inv_translate.FOrderEntryID = T_ORD_SaleOrderentry.fid             \r\n");
                    transql.append(" LEFT JOIN T_ORD_SaleOrder ON T_ORD_SaleOrderentry.fparentid = T_ORD_SaleOrder.fid             \r\n");
                    transql.append(" where T_ORD_SaleOrder.Fnumber like ?   and T_ORD_SaleOrderentry.fseq = ?   \r\n");
                    ls.add(params.getObject("orderseq"));
   try {
       rs = DbUtil.executeQuery(ctx, transql.toString(), ls.toArray());
       while (rs.next()) {
       list.add(new ordercheck(rs.getString(1), rs.getString(2), rs.getString(3), rs.getString(4), rs.getString(5), rs.getString(6), rs.getString(7), rs.getString(8), rs.getString(9), rs.getString(10), rs.getString(11), rs.getString(12)));
       }
   } catch (SQLException e) {
       // TODO Auto-generated catch block
       e.printStackTrace();
   }
   StringBuilder pcsql = new StringBuilder(); // 盘存
    pcsql.append(" /*dialect*/SELECT t_bal_productchecklog.Fnumber, t_bal_productchecklog.FOrderEntryID, t_bal_productchecklog.FProductTraitID,                              \r\n");
                  pcsql.append(" CASE t_bal_productchecklog.FType WHEN 1 THEN '盘盈' WHEN 2 THEN '盘亏'   END,                                                                  \r\n") ;
                  pcsql.append(" CASE t_bal_productchecklog.FType WHEN 1 THEN 1 WHEN 2 THEN -1   END,                                                                            \r\n") ;
                  pcsql.append(" CASE t_bal_productchecklog.FWarehouseID WHEN 'OREFiNXMQlG+KVU8XEWGLYui6QQ=' THEN '东经仓库'WHEN 'QyFWthwXSUCl8I+Vv98jDoui6QQ=' THEN '瓯海仓库' \r\n") ;
                  pcsql.append(" WHEN 'uIS48yP4Rw+3zvvekNmFi4ui6QQ=' THEN '乐清仓库'   END,NULL, t_bal_productchecklog.famount,                                                  \r\n") ;
                  pcsql.append(" CASE t_bal_productchecklog.faudited WHEN 1 THEN '已审核'                                                                                        \r\n") ;
                  pcsql.append(" ELSE '' END,                                                                                                                                    \r\n") ;
                  pcsql.append(" t_bal_productchecklog.fcreatorid,                                                                                                               \r\n") ;
                  pcsql.append(" t_bal_productchecklog.fcreatetime fcreatetime,                                                                                                  \r\n") ;
                  pcsql.append(" t_bal_productchecklog.flastupdateuserid,                                                                                                        \r\n") ;
                  pcsql.append(" t_bal_productchecklog.flastupdatetime,                                                                                                          \r\n") ;
                  pcsql.append(" t_bal_productchecklog.fauditorid,                                                                                                               \r\n") ;

                 pcsql.append(" t_bal_productchecklog.faudittime FROM t_bal_productchecklog                                                                                     \r\n") ;
                 pcsql.append(" LEFT JOIN T_ORD_SaleOrderentry ON t_bal_productchecklog.FOrderEntryID = T_ORD_SaleOrderentry.fid             \r\n");
                 pcsql.append(" LEFT JOIN T_ORD_SaleOrder ON T_ORD_SaleOrderentry.fparentid = T_ORD_SaleOrder.fid             \r\n");
                 pcsql.append(" where T_ORD_SaleOrder.Fnumber like ?   and T_ORD_SaleOrderentry.fseq = ?   \r\n");
                     // ls.add(params.getObject("orderseq"));
                 try {
              rs = DbUtil.executeQuery(ctx, pcsql.toString(), ls.toArray());
              while (rs.next()) {
         list.add(new ordercheck(rs.getString(1), rs.getString(2), rs.getString(3), rs.getString(4), rs.getString(5), rs.getString(6), rs.getString(7), rs.getString(8), rs.getString(9), rs.getString(10), rs.getString(11), rs.getString(12)));
         }
    } catch (SQLException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }
    StringBuilder rkmx = new StringBuilder(); // 入库明细
          rkmx.append(" /*dialect*/SELECT t_inv_productindetail.Fnumber,                                          \r\n");
          rkmx.append(" t_inv_productindetail.FOrderEntryId,                                           \r\n");
          rkmx.append(" t_inv_productindetail.FProductTraitID,                                         \r\n");
          rkmx.append(" NVL(NULL, '产品入库'),                                                         \r\n");
          rkmx.append(" NVL(NULL, 1),                                                                  \r\n");
          rkmx.append(" CASE FWarehouseID                                                              \r\n");
          rkmx.append("                  WHEN 'OREFiNXMQlG+KVU8XEWGLYui6QQ=' THEN '东经仓库'           \r\n");
          rkmx.append("                   WHEN 'QyFWthwXSUCl8I+Vv98jDoui6QQ=' THEN '瓯海仓库'          \r\n");
          rkmx.append("                  WHEN 'uIS48yP4Rw+3zvvekNmFi4ui6QQ=' THEN '乐清仓库'   END,    \r\n");
          rkmx.append(" NULL,                                                                          \r\n");
          rkmx.append(" t_inv_productindetail.famount,                                                 \r\n");
          rkmx.append(" NVL(NULL, '不需审核'),                                                         \r\n");
          rkmx.append(" t_inv_productindetail.fcreatorid,                                              \r\n");
          rkmx.append(" t_inv_productindetail.fcreatetime fcreatetime,                                 \r\n");
          rkmx.append(" t_inv_productindetail.flastupdateuserid,                                       \r\n");
          rkmx.append(" t_inv_productindetail.flastupdatetime,                                         \r\n");
          rkmx.append(" NULL,NULL                                                                      \r\n");
          rkmx.append(" FROM t_inv_productindetail                                                     \r\n");
          rkmx.append(" LEFT JOIN T_ORD_SaleOrderentry ON t_inv_productindetail.FOrderEntryID = T_ORD_SaleOrderentry.fid             \r\n");
          rkmx.append(" LEFT JOIN T_ORD_SaleOrder ON T_ORD_SaleOrderentry.fparentid = T_ORD_SaleOrder.fid             \r\n");
          rkmx.append(" where T_ORD_SaleOrder.Fnumber like ?   and T_ORD_SaleOrderentry.fseq = ?   \r\n");
                     // ls.add(params.getObject("orderseq"));
          try {
       rs = DbUtil.executeQuery(ctx, rkmx.toString(), ls.toArray());
       while (rs.next()) {
          list.add(new ordercheck(rs.getString(1), rs.getString(2), rs.getString(3), rs.getString(4), rs.getString(5), rs.getString(6), rs.getString(7), rs.getString(8), rs.getString(9), rs.getString(10), rs.getString(11), rs.getString(12)));
          }
     } catch (SQLException e) {
         // TODO Auto-generated catch block
         e.printStackTrace();
     }
     StringBuilder ckmx = new StringBuilder(); // 出库明细
     ckmx.append(" /*dialect*/SELECT t_tra_saledeliver.Fnumber,                                  \r\n");
     ckmx.append(" t_tra_saledeliverentry.FOrderEntryId,                             \r\n");
     ckmx.append(" t_ord_delivers.FTraitId,                                          \r\n");
     ckmx.append(" NVL(NULL, '销售出库'),                                            \r\n");
     ckmx.append(" NVL(NULL, -1),                                                    \r\n");
     ckmx.append(" CASE t_tra_truckassemble.FWarehouseID                             \r\n");
     ckmx.append(" WHEN 'OREFiNXMQlG+KVU8XEWGLYui6QQ=' THEN '东经仓库'               \r\n");
     ckmx.append("WHEN 'QyFWthwXSUCl8I+Vv98jDoui6QQ=' THEN '瓯海仓库'                \r\n");
     ckmx.append("WHEN 'uIS48yP4Rw+3zvvekNmFi4ui6QQ=' THEN '乐清仓库'   END, NULL,   \r\n");
     ckmx.append(" t_tra_saledeliverentry.FIssueAmt,                                 \r\n");
     ckmx.append(" CASE t_tra_saledeliver.FAudited WHEN 1 THEN '已审核'               \r\n");
     ckmx.append(" ELSE '' END,t_tra_saledeliver.fcreatorid,                         \r\n");
     ckmx.append(" t_tra_saledeliver.fcreatetime,                                    \r\n");
     ckmx.append(" t_tra_saledeliver.flastupdateuserid,                              \r\n");
     ckmx.append(" t_tra_saledeliver.flastupdatetime,                                \r\n");
     ckmx.append(" t_tra_saledeliver.fauditorid,                                     \r\n");
     ckmx.append(" t_tra_saledeliver.fauditdate                                      \r\n");
     ckmx.append(" FROM t_tra_saledeliverentry                                       \r\n");
     ckmx.append(" LEFT JOIN t_tra_saledeliver                                       \r\n");
     ckmx.append(" ON t_tra_saledeliver.fid = t_tra_saledeliverentry.fparentid      \r\n");
     ckmx.append(" LEFT JOIN t_tra_truckassemble                                     \r\n");
     ckmx.append(" ON t_tra_saledeliver.FAsselbleID = t_tra_truckassemble.fid       \r\n");
     ckmx.append(" LEFT JOIN t_ord_delivers                                          \r\n");
     ckmx.append(" ON t_ord_delivers.fid = t_tra_saledeliverentry.FDeliverId        \r\n");
     ckmx.append(" LEFT JOIN T_ORD_SaleOrderentry ON t_tra_saledeliverentry.FOrderEntryID = T_ORD_SaleOrderentry.fid             \r\n");
     //ckmx.append("             \r\n");
     ckmx.append(" LEFT JOIN T_ORD_SaleOrder ON T_ORD_SaleOrderentry.fparentid = T_ORD_SaleOrder.fid \r\n");
     ckmx.append(" where T_ORD_SaleOrder.Fnumber like ?   and T_ORD_SaleOrderentry.fseq = ?   \r\n");
                    //   ls.add(params.getObject("orderseq"));
     try {
         rs = DbUtil.executeQuery(ctx, ckmx.toString(), ls.toArray());
         while (rs.next()) {

          list.add(new ordercheck(rs.getString(1), rs.getString(2), rs.getString(3), rs.getString(4), rs.getString(5), rs.getString(6), rs.getString(7), rs.getString(8), rs.getString(9), rs.getString(10), rs.getString(11), rs.getString(12)));
          }
      } catch (SQLException e) {
          // TODO Auto-generated catch block
          e.printStackTrace();
      }
          StringBuilder qtrk = new StringBuilder(); // 其他入库明细
          qtrk.append(" /*dialect*/SELECT T_INV_InWarehs.FNumber,                                                           \r\n");
                          qtrk.append(" T_INV_InWarehs.FOrderEntryId,                                                           \r\n");
                           qtrk.append(" T_INV_InWarehs.FProductTraitID,                                                        \r\n");
                                      qtrk.append(" NVL(NULL, '其它入库'),                                                                 \r\n");
                                      qtrk.append("    NVL(NULL, 1),CASE FWarehouseID                                                       \r\n");
                                      qtrk.append("    WHEN 'OREFiNXMQlG+KVU8XEWGLYui6QQ=' THEN '东经仓库'                                  \r\n");
                                      qtrk.append("    WHEN 'uIS48yP4Rw+3zvvekNmFi4ui6QQ=' THEN '乐清仓库'                                  \r\n");
                                      qtrk.append("     WHEN 'QyFWthwXSUCl8I+Vv98jDoui6QQ=' THEN '瓯海仓库'                                 \r\n");
                                      qtrk.append("    WHEN 'AWZrwR9pRSCc9WScV6FsiIui6QQ=' THEN '乌牛仓库' END,NULL,                       \r\n");
                                      qtrk.append("     T_INV_InWarehs.FAmount,                                                             \r\n");
                                      qtrk.append("     CASE T_INV_InWarehs.FAudited   WHEN 1 THEN '已审核'    ELSE ''    END audited,      \r\n");
                                      qtrk.append("     T_INV_InWarehs.FCreatorID,                                                          \r\n");
                                      qtrk.append("      T_INV_InWarehs.FCreateTime fcreatetime,                           \r\n");
                                      qtrk.append("       T_INV_InWarehs.FLastUpdateUserID,                                                 \r\n");
                                      qtrk.append("        T_INV_InWarehs.FLastUpdateTime,                                                  \r\n");
                                      qtrk.append("       NULL, NULL FROM T_INV_InWarehs                                                \r\n");
                                  qtrk.append(" LEFT JOIN T_ORD_SaleOrderentry ON T_INV_InWarehs.FOrderEntryID = T_ORD_SaleOrderentry.fid             \r\n");
                              qtrk.append(" LEFT JOIN T_ORD_SaleOrder ON T_ORD_SaleOrderentry.fparentid = T_ORD_SaleOrder.fid             \r\n");
                          qtrk.append(" where T_ORD_SaleOrder.Fnumber like ?   and T_ORD_SaleOrderentry.fseq = ?   \r\n");
                      //   ls.add(params.getObject("orderseq"));
                             try {
                         rs = DbUtil.executeQuery(ctx, qtrk.toString(), ls.toArray());
                         while (rs.next()) {
                list.add(new ordercheck(rs.getString(1), rs.getString(2), rs.getString(3), rs.getString(4), rs.getString(5), rs.getString(6), rs.getString(7), rs.getString(8), rs.getString(9), rs.getString(10), rs.getString(11), rs.getString(12)));
                }
           } catch (SQLException e) {
               // TODO Auto-generated catch block
               e.printStackTrace();
           }
           StringBuilder qtck = new StringBuilder(); // 其他入库明细
              qtck.append(" /*dialect*/SELECT T_INV_OtherLibrary.FNumber,                                            \r\n");
              qtck.append(" T_INV_OtherLibrary.FOrderEntryId,                                             \r\n");
              qtck.append(" T_INV_OtherLibrary.FProductTraitID,                                           \r\n");
              qtck.append(" NVL(NULL, '其他出库'),                                                        \r\n");
              qtck.append(" NVL(NULL, -1),                                                                \r\n");
              qtck.append(" CASE FWarehouseID                                                             \r\n");
              qtck.append("                  WHEN 'FB59g3FqSly3VtDAzfaHjoui6QQ=' THEN '纸箱半成品仓库'    \r\n");
              qtck.append("                  WHEN 'OREFiNXMQlG+KVU8XEWGLYui6QQ=' THEN '东经仓库'          \r\n");
              qtck.append("                  WHEN 'uIS48yP4Rw+3zvvekNmFi4ui6QQ=' THEN '乐清仓库'          \r\n");
              qtck.append("                   WHEN 'QyFWthwXSUCl8I+Vv98jDoui6QQ=' THEN '瓯海仓库'         \r\n");
              qtck.append("                   END,    NULL,                                               \r\n");
              qtck.append(" T_INV_OtherLibrary.FAmount,                                                   \r\n");
              qtck.append(" CASE T_INV_OtherLibrary.FAudited   WHEN 1 THEN '已审核'                       \r\n");
              qtck.append(" ELSE ''   END audited,                                                        \r\n");
              qtck.append(" T_INV_OtherLibrary.FCreatorID,                                                \r\n");
              qtck.append(" T_INV_OtherLibrary.FCreateTime fcreatetime,                                   \r\n");
              qtck.append(" T_INV_OtherLibrary.FLastUpdateUserID,                                         \r\n");
              qtck.append(" T_INV_OtherLibrary.FLastUpdateTime,                                           \r\n");
              qtck.append(" NULL, NULL                                                                   \r\n");
              qtck.append(" FROM T_INV_OtherLibrary                                                       \r\n");
          qtck.append(" LEFT JOIN T_ORD_SaleOrderentry ON T_INV_OtherLibrary.FOrderEntryID = T_ORD_SaleOrderentry.fid             \r\n");
          qtck.append(" LEFT JOIN T_ORD_SaleOrder ON T_ORD_SaleOrderentry.fparentid = T_ORD_SaleOrder.fid             \r\n");
          qtck.append(" where T_ORD_SaleOrder.Fnumber like ?   and T_ORD_SaleOrderentry.fseq = ?   \r\n");
                      // ls.add(params.getObject("orderseq"));
                           try {
                       rs = DbUtil.executeQuery(ctx, qtck.toString(), ls.toArray());
                       while (rs.next()) {
              list.add(new ordercheck(rs.getString(1), rs.getString(2), rs.getString(3), rs.getString(4), rs.getString(5), rs.getString(6), rs.getString(7), rs.getString(8), rs.getString(9), rs.getString(10), rs.getString(11), rs.getString(12)));
              }
       } catch (SQLException e) {
           // TODO Auto-generated catch block
           e.printStackTrace();
       }
  }


  //list.add(new ordercheck();
//  list.add(new ordercheck("1B", "2003-01-01 10：22：20", null, "2005-05-01 11：1：1", null, null, null, null, null, null, type, "2003-01-01 10：22：20"));
//  list.add(new ordercheck("2BBB", "2003-02-01 22：25：20", null, "2004-03-01 10：11：20", null, null, null, null, null, null, type, "2003-02-01 22：25：20"));
//  list.add(new ordercheck("3BBB", "2004-01-01 23：22：20", null, "2003-02-01 23：02：20", null, null, null, null, null, null, type, "2004-01-01 23：22：20"));




//     Collections.sort(list, new Comparator<ordercheck>() {
//         SimpleDateFormat sdf = new SimpleDateFormat("HH:mm:ss");
//         private Date gettime(ordercheck m) {
//         if (m == null || m.getFcreatetime() == null)
//         return null;
//         try {
//         return sdf.parse(m.getFcreatetime().substring(11));
//     // return sdf.parse(m.getFcreatetime());
//         }
//         catch (ParseException e) {
//         return null;
//         }
//         }
//         public int compare(ordercheck o1, ordercheck o2) {
//         Date d1 = gettime(o1);
//         Date d2 = gettime(o2);
//         if (d1 == null && d2 == null)
//         return 0;
//         if (d1 == null)
//         return -1;
//         if (d2 == null)
//         return 1;
//         return d1.compareTo(d2);
//         }
//         }
//         );
    Collections.sort(list, new Comparator<ordercheck>() {
        public int compare(ordercheck o1, ordercheck o2) {
     ordercheck c1=(ordercheck)o1;
     ordercheck c2=(ordercheck)o2;
        int flag=c1.getFcreatetime().compareTo(c2.getFcreatetime());
        return flag;
        }} );



     for(int i=0; i<list.size(); i++){
       // String a = list.get(i).getFcreatetime();
         ordercheck temp = (ordercheck)list.get(i);


         System.out.println("排序后：" + temp.getFcreatetime());
     }












  params.setObject("OrderCheck", rs);

  params.setObject("list", list);
  return params;
}



public class ordercheck {
     private String orderno;
     private String orderseq;
     private String fnumber;
     private String product;
     private String ftrait;
     private String type;
     private String warehous;
     private String orderfamout;
     private String famout;
     private String factor;
     private String audited;
     private String fcreatetime;

     public ordercheck() { }
     public ordercheck(String orderno, String orderseq, String fnumber,
      String product, String ftrait, String type,
      String warehous, String orderfamout, String famout,
      String factor, String audited, String fcreatetime) {
  super();
  this.audited = audited;
  this.factor = factor;
  this.famout = famout;
  this.fcreatetime = fcreatetime;
  this.fnumber = fnumber;
  this.ftrait = ftrait;
  this.orderfamout = orderfamout;
  this.orderno = orderno;
  this.orderseq = orderseq;
  this.product = product;
  this.type = type;
  this.warehous = warehous;
     }
     public ordercheck(IRowSet rs) {
  // TODO Auto-generated constructor stub
     }
     public String getOrderno() {
         return orderno;
     }
     public void setOrderno(String orderno) {
         this.orderno = orderno;
     }
     public String getOrderseq() {
         return orderseq;
     }
     public void setOrderseq(String orderseq) {
         this.orderseq = orderseq;
     }
     public String getFnumber() {
         return fnumber;
     }
     public void setFnumber(String fnumber) {
         this.fnumber = fnumber;
     }
     public String getProduct() {
         return product;
     }
     public void setProduct(String product) {
         this.product = product;
     }
     public String getFtrait() {
         return ftrait;
     }
     public void setFtrait(String ftrait) {
         this.ftrait = ftrait;
     }
     public String getType() {
         return type;
     }
     public void setType(String type) {
         this.type = type;
     }
     public String getWarehous() {
         return warehous;
     }
     public void setWarehous(String warehous) {
         this.warehous = warehous;
     }
     public String getOrderfamout() {
         return orderfamout;
     }
     public void setOrderfamout(String orderfamout) {
         this.orderfamout = orderfamout;
     }
     public String getFamout() {
         return famout;
     }
     public void setFamout(String famout) {
         this.famout = famout;
     }
     public String getFactor() {
         return factor;
     }
     public void setFactor(String factor) {
         this.factor = factor;
     }
     public String getAudited() {
         return audited;
     }
     public void setAudited(String audited) {
         this.audited = audited;
     }
     public String getFcreatetime() {
         return fcreatetime;
     }
     public void setFcreatetime(String fcreatetime) {
         this.fcreatetime = fcreatetime;
     }

  }


}