@SuppressWarnings("deprecation")
 protected void spFixOnline(Map params) {
   try {
     int branchId = ((Integer) params.get("branch.id")).intValue();
     String departNo = (String) params.get("depart.no");
     String type = (String) params.get("type");
     String personNo = (String) params.get("person.no");
     String itemNo = (String) params.get("item.no");
     String date =
         CommonUtil.formatCalendar("yyyy/MM/dd", ObjectUtil.toCalendar(params.get("date")));
     double value = ((Double) params.get("value")).doubleValue();
     String doPerson = (String) params.get("doPerson");
     String doDate =
         CommonUtil.formatCalendar("yyyy/MM/dd", ObjectUtil.toCalendar(params.get("doDate")));
     Connection conn = getSession().connection();
     CallableStatement cs =
         conn.prepareCall("{call SP_HRSAL_FIXONLINE(?, ?, ?, ?, ?, ?, ?, ?, ?)}");
     int index = 1;
     cs.setInt(index++, branchId);
     cs.setString(index++, departNo);
     cs.setString(index++, type);
     cs.setString(index++, personNo);
     cs.setString(index++, itemNo);
     cs.setString(index++, date);
     cs.setDouble(index++, value);
     cs.setString(index++, doPerson);
     cs.setString(index++, doDate);
     cs.execute();
   } catch (Exception e) {
     throw new HibernateException(e);
   }
   /*
   Query q = getSession().getNamedQuery("HRSAL_FIXONLINE")
   	.setParameter("branchId", params.get("branch.id"))
   	.setParameter("departNo", params.get("depart.no"))
   	.setParameter("type", params.get("type"))
   	.setParameter("personNo", params.get("person.no"))
   	.setParameter("itemNo", params.get("item.no"))
   	.setParameter("date", CommonUtil.formatCalendar("yyyy/MM/dd", ObjectUtil.toCalendar(params.get("date"))))
   	.setParameter("value", params.get("value"))
   	.setParameter("doPerson", params.get("doPerson"))
   	.setParameter("doDate", CommonUtil.formatCalendar("yyyy/MM/dd", ObjectUtil.toCalendar(params.get("doDate"))));
   q.uniqueResult();
   */
 }
 public static final void test9() {
   String HD_TRANSGRESS = "A";
   String head = CommonUtil.formatCalendar("'" + HD_TRANSGRESS + "'yy'-'", Calendar.getInstance());
   String ret = CommonServiceUtil.getSafetyAccNo(4, HD_TRANSGRESS, head);
   System.out.println("transgress' ref no: " + ret);
   System.out.println(CommonServiceUtil.class.getSimpleName());
   List ret1 = CommonServiceUtil.getCloseList(4);
   System.out.println(ret1.size());
 }
  public static final void test10() {
    SecurityLimit limit = new SecurityLimit();
    limit.setId(new SecurityLimitPK(4, 8));
    Calendar cal = Calendar.getInstance();
    cal.set(2009, 0, 1, 0, 0, 0);
    cal.set(Calendar.HOUR, -12);
    cal.set(Calendar.MINUTE, 0);
    cal.set(Calendar.SECOND, 0);
    System.out.println("date from :" + CommonUtil.formatCalendar("yyyy-MM-dd", cal));
    Date date = cal.getTime();
    System.out.println("date :" + date);
    String[] order = {"depart.id", "line.id", "equipment.id", "downDate"};
    List a = BaseServiceUtil.getEquOnlinesForSafetyTree(limit, cal, order);
    System.out.println("EquOnlines List size: " + a.size());
    for (int i = 0; i < a.size(); i++) {
      EquOnline obj = (EquOnline) a.get(i);
      if (obj.getLine() == null) {
        System.out.println(
            "dept:"
                + obj.getDepart().getName()
                + " bus:"
                + obj.getEquipment().getUseId()
                + " ondate:"
                + CommonUtil.formatCalendar("yyyy-MM-dd", obj.getOnDate())
                + " downdate:"
                + CommonUtil.formatCalendar("yyyy-MM-dd", obj.getDownDate()));

      } else {
        System.out.println(
            "dept:"
                + obj.getDepart().getName()
                + " line:"
                + obj.getLine().getNo()
                + " bus:"
                + obj.getEquipment().getUseId()
                + " ondate:"
                + CommonUtil.formatCalendar("yyyy-MM-dd", obj.getOnDate())
                + " downdate:"
                + CommonUtil.formatCalendar("yyyy-MM-dd", obj.getDownDate()));
      }
    }
  }