Exemplo n.º 1
0
  /** 列表查询积分管理 */
  public String execute() throws Exception {
    String where = " where 1=1 ";

    // if (s_name!=null && s_name.trim().length()!=0) {

    // where += " and " + Integral.COL_name +" like '%" + s_name.trim()+"%'";
    // }

    List list =
        Server.getInstance()
            .getMemberService()
            .findAllIntegralForPageinfo(where, " ORDER BY ID ", pageinfo);
    pageinfo = (PageInfo) list.remove(0);
    listIntegral = list;
    if (pageinfo.getTotalrow() > 0 && listIntegral.size() == 0) {
      pageinfo.setPagenum(1);
      list =
          Server.getInstance()
              .getMemberService()
              .findAllIntegralForPageinfo(where, " ORDER BY ID ", pageinfo);
      pageinfo = (PageInfo) list.remove(0);
      listIntegral = list;
    }
    for (Integral integral : listIntegral) {
      if (integral.getAgenttype() == 5) { // 会员
        this.integral = integral;
      }
    }

    return SUCCESS;
  }
Exemplo n.º 2
0
  /** 列表查询投诉建议表 */
  public String execute() throws Exception {
    String where = " where 1=1 ";

    // if (s_name!=null && s_name.trim().length()!=0) {

    // where += " and " + Tousu.COL_name +" like '%" + s_name.trim()+"%'";
    // }

    List list =
        Server.getInstance()
            .getMemberService()
            .findAllTousuForPageinfo(where, " ORDER BY ID ", pageinfo);
    pageinfo = (PageInfo) list.remove(0);
    listTousu = list;
    if (pageinfo.getTotalrow() > 0 && listTousu.size() == 0) {
      pageinfo.setPagenum(1);
      list =
          Server.getInstance()
              .getMemberService()
              .findAllTousuForPageinfo(where, " ORDER BY ID ", pageinfo);
      pageinfo = (PageInfo) list.remove(0);
      listTousu = list;
    }

    return SUCCESS;
  }
Exemplo n.º 3
0
 /** 转向到汽车修改页面 */
 public String toedit() throws Exception {
   listCity =
       Server.getInstance()
           .getHotelService()
           .findAllCity(" where 1=1 and " + City.COL_language + " =0", "", -1, 0);
   cars = Server.getInstance().getCarService().findCars(cars.getId());
   return EDIT;
 }
Exemplo n.º 4
0
 /** 转向到汽车添加页面 */
 public String toadd() throws Exception {
   listCity =
       Server.getInstance()
           .getHotelService()
           .findAllCity(" where 1=1 and " + City.COL_language + " =0", "", -1, 0);
   listCarstore = Server.getInstance().getCarService().findAllCarstore(" where 1=1 ", "", -1, 0);
   return EDIT;
 }
Exemplo n.º 5
0
  /** 添加租车订单 */
  public String add() throws Exception {

    Server.getInstance().getCarService().createCarorder(carorder);

    carorder.setCode(Server.getInstance().getServiceCenter().getCarOrderCode(carorder));
    Server.getInstance().getCarService().updateCarorderIgnoreNull(carorder);
    return LIST;
  }
Exemplo n.º 6
0
  /** 编辑积分管理 */
  public String edit() throws Exception {
    HttpServletRequest request = ServletActionContext.getRequest();
    String where = " where 1=1 ";
    List list =
        Server.getInstance()
            .getMemberService()
            .findAllIntegralForPageinfo(where, " ORDER BY ID ", pageinfo);
    pageinfo = (PageInfo) list.remove(0);
    listIntegral = list;
    if (pageinfo.getTotalrow() > 0 && listIntegral.size() == 0) {
      pageinfo.setPagenum(1);
      list =
          Server.getInstance()
              .getMemberService()
              .findAllIntegralForPageinfo(where, " ORDER BY ID ", pageinfo);
      pageinfo = (PageInfo) list.remove(0);
      listIntegral = list;
    }

    int register = Integer.valueOf(converNull(request.getParameter("register5"), "0"));
    int punish = Integer.valueOf(converNull(request.getParameter("punish5"), "0"));
    int backorder = Integer.valueOf(converNull(request.getParameter("backorder5"), "0"));
    int weborder = Integer.valueOf(converNull(request.getParameter("weborder5"), "0"));

    for (Integral integral : listIntegral) {
      long type = integral.getAgenttype();
      System.out.println(request.getParameter("aircoeft" + type));
      float aircoeft = Float.valueOf(converNull(request.getParameter("aircoeft" + type), "0"));
      // float hotelcoeft=Float.valueOf(converNull(request.getParameter("hotelcoeft"+type),"0"));
      // float travelcoeft=Float.valueOf(converNull(request.getParameter("travelcoeft"+type),"0"));
      // float
      // carrentalcoeft=Float.valueOf(converNull(request.getParameter("carrentalcoeft"+type),"0"));
      // float
      // rechargecoeft=Float.valueOf(converNull(request.getParameter("rechargecoeft"+type),"0"));

      integral.setAircoeft(aircoeft);
      // integral.setHotelcoeft(hotelcoeft);
      // integral.setTravelcoeft(travelcoeft);
      // integral.setCarrentalcoeft(carrentalcoeft);
      // integral.setRechargecoeft(rechargecoeft);
      integral.setRegisterscore(register);
      integral.setPunishscore(punish);
      integral.setBackorderscore(backorder);
      integral.setWeborderscore(weborder);
      Server.getInstance().getMemberService().updateIntegralIgnoreNull(integral);
    }
    return this.execute();
  }
Exemplo n.º 7
0
 /** 添加汽车 */
 public String add() throws Exception {
   cars.setCreatetime(new Timestamp(System.currentTimeMillis()));
   cars.setCreateuser(getLoginUser().getLoginname());
   // cars.setMarkettime(dateToTimestamp(c_markettime));
   Server.getInstance().getCarService().createCars(cars);
   return LIST;
 }
Exemplo n.º 8
0
  /**
   * 添加消息反馈信息
   *
   * @return 赵晓晓
   */
  public void getreturnmessage() {

    try {
      // 获得投诉内容
      tousu.setComment(content);
      // 获得添加时间
      tousu.setCreatetime(new Timestamp(System.currentTimeMillis()));
      // 获得登录人编号从session中获得
      HttpSession session = ServletActionContext.getRequest().getSession();
      Customeruser customer = new Customeruser();
      customer = (Customeruser) session.getAttribute("loginuser");
      Long id = customer.getId();
      tousu.setUsername(id.toString());
      // 获得代理编号
      Customeragent customeragent = new Customeragent();
      customeragent = (Customeragent) session.getAttribute("loginagent");
      Long Agentid = customeragent.getId();
      tousu.setDainame(Agentid.toString());
      Server.getInstance().getMemberService().createTousu(tousu);
      System.out.println("添加投诉信息成功!");
    } catch (SQLException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
      System.out.println("添加失败!");
    }
  }
Exemplo n.º 9
0
 /** 添加投诉建议表 */
 public String add() throws Exception {
   tousu.setCreatetime(new Timestamp(System.currentTimeMillis()));
   tousu.setStarttime(dateToTimestamp(s_starttime));
   tousu.setHappentime(dateToTimestamp(s_happentime));
   Server.getInstance().getMemberService().createTousu(tousu);
   return LIST;
 }
Exemplo n.º 10
0
  /** 审核租车订单 */
  public String check() throws Exception {
    carorder = Server.getInstance().getCarService().findCarorder(carorder.getId());

    if (orderstate == 5) { // 取消订单
      if (carorder.getWaicode() != null
          && carorder.getWaicode().length() > 0
          && !carorder.getWaicode().equals("NOCODE")) {
        String code = Server.getInstance().getYiHaiCarService().cancelorder(carorder.getWaicode());
        if (code.equals("OK")) { // 取消成功

          carorder.setState(5);
        }
      }
    }
    carorder.setState(orderstate);
    Server.getInstance().getCarService().updateCarorderIgnoreNull(carorder);
    return LIST;
  }
Exemplo n.º 11
0
 /** 查询消息反馈信息列表 赵晓晓 */
 public String showfklist() {
   String where = " where 1=1 ";
   StringBuilder sb = new StringBuilder("");
   if (begintime != null && !begintime.equals("") && endtime != null && !endtime.equals("")) {
     sb.append(" and C_CREATETIME between '" + begintime + "' and '" + endtime + "'");
   }
   List list =
       Server.getInstance()
           .getMemberService()
           .findAllTousuForPageinfo(where + sb, " ORDER BY ID ", pageinfo);
   pageinfo = (PageInfo) list.remove(0);
   fankuilist = list;
   if (pageinfo.getTotalrow() > 0 && fankuilist.size() == 0) {
     pageinfo.setPagenum(1);
     list =
         Server.getInstance()
             .getMemberService()
             .findAllTousuForPageinfo(where + sb, " ORDER BY ID ", pageinfo);
     pageinfo = (PageInfo) list.remove(0);
     fankuilist = list;
   }
   return "showfklist";
 }
Exemplo n.º 12
0
 public String car_new() throws Exception {
   String where = " where 1=1 ";
   if (getLoginUser().getAgentid() != 46) {
     where += " AND " + Carorder.COL_carid + " =" + getLoginUser().getAgentid();
   }
   System.out.println("where=" + where);
   List list =
       Server.getInstance()
           .getCarService()
           .findAllCarorderForPageinfo(where, " ORDER BY ID DESC ", pageinfo);
   pageinfo = (PageInfo) list.remove(0);
   listCarorder = list;
   if (pageinfo.getTotalrow() > 0 && listCarorder.size() == 0) {
     pageinfo.setPagenum(1);
     list =
         Server.getInstance()
             .getCarService()
             .findAllCarorderForPageinfo(where, " ORDER BY ID DESC ", pageinfo);
     pageinfo = (PageInfo) list.remove(0);
     listCarorder = list;
   }
   return "car_new";
 }
Exemplo n.º 13
0
  /** 列表查询汽车 */
  public String execute() throws Exception {
    // 查询所有的城市
    listCity =
        Server.getInstance()
            .getHotelService()
            .findAllCity(
                " where 1=1 and " + City.COL_type + " =2", "ORDER BY " + City.COL_sort, -1, 0);

    String where = " where 1=1 ";

    if (s_name != null && s_name.trim().length() != 0) {

      where += " and " + Cars.COL_name + " like '%" + s_name.trim() + "%'";
    }
    if (C_ScityId > 0) {

      where += " and " + Cars.COL_cityid + " ='" + C_ScityId + "'";
    }

    List list =
        Server.getInstance()
            .getCarService()
            .findAllCarsForPageinfo(where, " ORDER BY ID DESC", pageinfo);
    pageinfo = (PageInfo) list.remove(0);
    listCars = list;
    if (pageinfo.getTotalrow() > 0 && listCars.size() == 0) {
      pageinfo.setPagenum(1);
      list =
          Server.getInstance()
              .getCarService()
              .findAllCarsForPageinfo(where, " ORDER BY ID DESC", pageinfo);
      pageinfo = (PageInfo) list.remove(0);
      listCars = list;
    }

    return SUCCESS;
  }
Exemplo n.º 14
0
  /**
   * 批量操作
   *
   * @return
   * @throws Exception
   */
  public String batch() throws Exception {
    if (selectid != null && selectid.length > 0) {

      switch (opt) {
        case 1: // delete
          for (int i : selectid) {
            Server.getInstance().getCarService().deleteCarorder(i);
          }

          break;
        default:
          break;
      }
    }
    return LIST;
  }
Exemplo n.º 15
0
 /** 在线租车 */
 public String book_car() throws Exception {
   Carorder carorder = new Carorder();
   carorder.setLinkname(linkname);
   carorder.setLinktell(linktel);
   carorder.setLinkmail(s_dizhi);
   carorder.setSpecreq(s_desc);
   carorder.setCode(cartype);
   carorder.setManyday(Integer.parseInt(s_num));
   carorder.setSdate(s_day);
   carorder.setCarname(car_name);
   carorder.setProperty(qu_typw); // 取车类型
   carorder.setCarcode(car_num); // 大小
   carorder.setPretime(new Timestamp(System.currentTimeMillis()));
   carorder.setMemberid(getLoginUser().getId());
   carorder.setCarid(getLoginUser().getAgentid());
   Server.getInstance().getCarService().createCarorder(carorder);
   return this.car_new();
 }
Exemplo n.º 16
0
 /** 删除租车订单 */
 public String delete() throws Exception {
   Server.getInstance().getCarService().deleteCarorder(carorder.getId());
   return LIST;
 }
Exemplo n.º 17
0
  /** 编辑租车订单 */
  public String edit() throws Exception {

    Server.getInstance().getCarService().updateCarorderIgnoreNull(carorder);
    return LIST;
  }
Exemplo n.º 18
0
	/**
	 * 添加国际机票国家
	 */		
	public String add()throws Exception{
	
		Server.getInstance().getInterticketService().createFcountry(fcountry);
		return LIST;
	}
Exemplo n.º 19
0
	/**
	 * 编辑国际机票国家
	 */		
	public String edit()throws Exception{
	
		Server.getInstance().getInterticketService().updateFcountryIgnoreNull(fcountry);
		return LIST;
	}
Exemplo n.º 20
0
 /** 转向到租车订单审核页面 */
 public String tocheck() throws Exception {
   carorder = Server.getInstance().getCarService().findCarorder(carorder.getId());
   return CHECK;
 }
Exemplo n.º 21
0
 public String toinfo() throws Exception {
   carorder = Server.getInstance().getCarService().findCarorder(carorder.getId());
   return "info";
 }
Exemplo n.º 22
0
 /** 编辑汽车 */
 public String edit() throws Exception {
   // cars.setMarkettime(dateToTimestamp(c_markettime));
   Server.getInstance().getCarService().updateCarsIgnoreNull(cars);
   return LIST;
 }
Exemplo n.º 23
0
	/**
	 * 编辑国际机票行程
	 */		
	public String edit()throws Exception{
	
		Server.getInstance().getInterticketService().updateFflightIgnoreNull(fflight);
		return LIST;
	}
Exemplo n.º 24
0
	/**
	 * 添加国际机票行程
	 */		
	public String add()throws Exception{
	
		Server.getInstance().getInterticketService().createFflight(fflight);
		return LIST;
	}
Exemplo n.º 25
0
	/**
	 * 转向到国际机票行程审核页面
	 */	
	public String tocheck()throws Exception{
	fflight = Server.getInstance().getInterticketService().findFflight(fflight.getId());
		return CHECK;
	}
Exemplo n.º 26
0
	/**
	 * 转向到国际机票行程修改页面
	 */	
	public String toedit()throws Exception{
	fflight = Server.getInstance().getInterticketService().findFflight(fflight.getId());
		return EDIT;
	}
Exemplo n.º 27
0
	/**
	 * 删除国际机票行程
	 */		
	public String delete()throws Exception{	
		Server.getInstance().getInterticketService().deleteFflight(fflight.getId());
		return LIST;
	}
Exemplo n.º 28
0
  /** 审核汽车 */
  public String check() throws Exception {

    Server.getInstance().getCarService().updateCarsIgnoreNull(cars);
    return LIST;
  }
Exemplo n.º 29
0
  /** 列表查询租车订单 */
  public String execute() throws Exception {
    // 查询所有的城市
    listCities =
        Server.getInstance()
            .getHotelService()
            .findAllCity(
                " where 1=1 and " + City.COL_type + " =2", "ORDER BY " + City.COL_sort, -1, 0);

    SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
    /*if(h_prestarttime == null) {
    	h_prestarttime = sdf.format(new Date()) ;
    }
    if(h_preendtime == null) {
    	h_preendtime = sdf.format(new Date()) ;
    }*/

    String where = " where 1=1 ";
    List<Sysconfig> listsys =
        Server.getInstance()
            .getSystemService()
            .findAllSysconfig(" where 1=1 and " + Sysconfig.COL_name + " ='agentid'", "", -1, 0);

    if (getLoginUser().getAgentid() == 46) { // 龙泰得员工
      longtype = 0;

      where += " ";

      if (h_angent > 0) { //

        where +=
            " and "
                + Carorder.COL_memberid
                + " in ( select "
                + Customeruser.COL_id
                + " from "
                + Customeruser.TABLE
                + " where 1=1 and "
                + Customeruser.COL_agentid
                + " ="
                + h_angent
                + ")";
      }

      listCustomeragent =
          Server.getInstance()
              .getMemberService()
              .findAllCustomeragent(" WHERE 1=1 ", " ORDER BY ID DESC ", -1, 0);

    } else {
      longtype = 1;
      where +=
          " and "
              + Carorder.COL_memberid
              + " in ( select "
              + Customeruser.COL_id
              + " from "
              + Customeruser.TABLE
              + " where 1=1 and "
              + Customeruser.COL_agentid
              + " ="
              + getLoginUser().getAgentid()
              + ")";
      listCustomeragent =
          Server.getInstance()
              .getMemberService()
              .findAllCustomeragent(
                  " WHERE 1=1 AND "
                      + Customeragent.COL_parentid
                      + " ="
                      + getLoginUser().getAgentid(),
                  " ORDER BY ID DESC ",
                  -1,
                  0);
    }
    if (s_name != null && s_name.trim().length() != 0) {

      where += " and " + Carorder.COL_carname + " like '%" + s_name.trim() + "%'";
    }
    if (c_username != null && c_username.trim().length() != 0) {

      where += " and " + Carorder.COL_linkname + " like '%" + c_username.trim() + "%'";
    }
    if (ordercode != null && ordercode.trim().length() != 0) {

      where += " and " + Carorder.COL_code + " like '%" + ordercode.trim() + "%'";
    }
    if (s_type > 0) {

      where += " and " + Carorder.COL_property + " ='" + s_type + "'";
    }
    if (C_ScityId > 0) {

      where += " and " + Carorder.COL_scityid + " ='" + C_ScityId + "'";
    }
    if (C_EcityId > 0) {

      where += " and " + Carorder.COL_endcityid + " ='" + C_EcityId + "'";
    }
    if (h_prestarttime != null && h_prestarttime.length() != 0) {
      where +=
          " AND "
              + Carorder.COL_pretime
              + ">="
              + "CONVERT(datetime, '"
              + h_prestarttime
              + " 00:00:00')";
    }
    if (h_preendtime != null && h_preendtime.length() != 0) {
      where +=
          " AND "
              + Hotelorder.COL_pretime
              + "<="
              + "CONVERT(datetime, '"
              + h_preendtime
              + " 23:59:59')";
    }

    System.out.println("where=" + where);
    List list =
        Server.getInstance()
            .getCarService()
            .findAllCarorderForPageinfo(where, " ORDER BY ID DESC ", pageinfo);
    pageinfo = (PageInfo) list.remove(0);
    listCarorder = list;
    if (pageinfo.getTotalrow() > 0 && listCarorder.size() == 0) {
      pageinfo.setPagenum(1);
      list =
          Server.getInstance()
              .getCarService()
              .findAllCarorderForPageinfo(where, " ORDER BY ID DESC ", pageinfo);
      pageinfo = (PageInfo) list.remove(0);
      listCarorder = list;
    }

    return SUCCESS;
  }
Exemplo n.º 30
0
 /** 转向到租车订单修改页面 */
 public String toedit() throws Exception {
   carorder = Server.getInstance().getCarService().findCarorder(carorder.getId());
   return EDIT;
 }