public void cancelRelaCom() {
   LEDBankComRelaSchema tBankComRelaSchema = new LEDBankComRelaSchema();
   tBankComRelaSchema.setBankCode(this.getBankCode());
   tBankComRelaSchema.setComCode(this.getComCode());
   tBankComRelaSchema.setPayFlag(this.getPayFlag());
   LEDBankComRelaDB tBankComRelaDB = new LEDBankComRelaDB();
   tBankComRelaDB.setSchema(tBankComRelaSchema);
   LEDBankComRelaSet tBankComRelaSet = tBankComRelaDB.query();
   if (tBankComRelaSet.size() < 1) {
     this.setOperateCode("cancelRelaCom_Fail010");
     this.operateNotice =
         ECPubFun.getDisplayString(valiConfig.getBundle(), this.operateCode, null);
     return;
   }
   MMap map = new MMap();
   map.put(tBankComRelaSchema, "DELETE");
   mVData.clear();
   mVData.add(map);
   PubSubmit pubSubmit = new PubSubmit();
   if (!pubSubmit.submitData(mVData, "delete")) {
     this.setOperateCode("cancelRelaCom_Fail020");
     this.operateNotice =
         ECPubFun.getDisplayString(valiConfig.getBundle(), this.operateCode, null);
     return;
   } else {
     this.setOperateCode("cancelRelaCom_Succ010");
     this.operateNotice =
         ECPubFun.getDisplayString(valiConfig.getBundle(), this.operateCode, null);
     queryComInfo();
     return;
   }
 }
  /** 修改广告来源信息 */
  public void modifyADSouce() {

    LEDAdSourceDB tLEDAdSourceDB = new LEDAdSourceDB();
    tLEDAdSourceDB.setProductCode(this.getProductCode());
    tLEDAdSourceDB.setSiteCode(this.getSiteCode());
    if (!tLEDAdSourceDB.getInfo()) {
      operateResult = "Fail|修改失败,数据库中没有此广告来源信息";
      return;
    }
    LEDAdSourceSchema tLEDAdSourceSchema = new LEDAdSourceSchema();
    tLEDAdSourceSchema.setSchema(tLEDAdSourceDB.getSchema());
    tLEDAdSourceSchema.setPayMode(this.getPayMode());
    tLEDAdSourceSchema.setContent(this.getContent());

    MMap map = new MMap();
    map.put(tLEDAdSourceSchema, "UPDATE");

    PubSubmit tPubSubmit = new PubSubmit();
    VData cVData = new VData();
    cVData.add(map);
    if (!tPubSubmit.submitData(cVData, "")) {
      operateResult = "Fail|修改操作失败";
      return;
    } else {
      operateResult = "Succ|修改成功";
      initData();
      return;
    }
  }
 private boolean saveData(MMap map) {
   VData tVData = new VData();
   tVData.add(map);
   PubSubmit tPubSubmit = new PubSubmit();
   if (!tPubSubmit.submitData(tVData, "")) {
     return false;
   }
   return true;
 }
 /** 删除数据 */
 public void deleteById() {
   String sql =
       "delete from ledadsource where sitecode='"
           + this.getSiteCode()
           + "' and productcode='"
           + this.getProductCode()
           + "'";
   MMap map = new MMap();
   map.put(sql, "DELETE");
   VData tVData = new VData();
   tVData.add(map);
   PubSubmit tPubSubmit = new PubSubmit();
   if (tPubSubmit.submitData(tVData, "")) {
     operateResult = "succ|删除成功";
     initData();
     find();
   } else {
     operateResult = "fail|删除失败";
   }
 }
  @SuppressWarnings("unchecked")
  public void save() throws IOException {
    boolean cFlag = true;
    if (!processFile()) {
      cFlag = false;
    }
    // 选中险种的个数
    int n = risks.length;
    LEPPlanRiskSet mLEPPlanRiskSet = new LEPPlanRiskSet();
    LEPPlanSchema mLEPPlanSchema = null;
    String contPlanCode = "";
    if (cFlag) {
      if (n > 0) {
        mLEPPlanSchema = new LEPPlanSchema();
        SysMaxNoMETLIFE tSysMaxNoMETLIFE = new SysMaxNoMETLIFE();
        contPlanCode = tSysMaxNoMETLIFE.CreateMaxNo("SerialNo", 10);
        mLEPPlanSchema.setContPlanCode(contPlanCode);
        mLEPPlanSchema.setContPlanName(planName);
        mLEPPlanSchema.setPlanType("00");
        mLEPPlanSchema.setPlanRiskType("H");
        mLEPPlanSchema.setPlanRule(rule);
        // modify by fengzg 将产品介绍写入文件
        String fileName = "planIntro_" + contPlanCode + ".txt";
        mLEPPlanSchema.setPlanIntro(fileName);
        ECPubFun.writeStringToFile(ECPubFun.getFCKEditFile(fileName), introduce);
        mLEPPlanSchema.setSaleStartDate(startDate);
        mLEPPlanSchema.setSaleEndDate(endDate);
        if (timeoutDef == null || "".equals(timeoutDef)) {
          // mLEPPlanSchema.setOverTime("24");
        } else {
          mLEPPlanSchema.setOverTime(timeoutDef);
        }
        mLEPPlanSchema.setOverTimeFlag("H");
        mLEPPlanSchema.setOperator(getVisitor().getUser().getUserName());
        String currentDate = PubFun.getCurrentDate();
        String currentTime = PubFun.getCurrentTime();
        mLEPPlanSchema.setMakeDate(currentDate);
        mLEPPlanSchema.setMakeTime(currentTime);
        mLEPPlanSchema.setModifyDate(currentDate);
        mLEPPlanSchema.setModifyTime(currentTime);
        // add ---wangzhixin----2009/07/21  start
        mLEPPlanSchema.setFileName(this.myFile);
        // add ---wangzhixin----2009/07/21  end
        for (int i = 0; i < n; i++) {
          LEPPlanRiskSchema mLEPPlanRiskSchema = new LEPPlanRiskSchema();
          mLEPPlanRiskSchema.setContPlanCode(contPlanCode);
          mLEPPlanRiskSchema.setContPlanName(planName);
          mLEPPlanRiskSchema.setMainRiskCode(planMainRisk);
          mLEPPlanRiskSchema.setRiskCode(risks[i]);
          mLEPPlanRiskSchema.setPlanType("00");
          mLEPPlanRiskSchema.setOperator(getVisitor().getUser().getUserName());
          mLEPPlanRiskSchema.setMakeDate(currentDate);
          mLEPPlanRiskSchema.setMakeTime(currentTime);
          mLEPPlanRiskSchema.setModifyDate(currentDate);
          mLEPPlanRiskSchema.setModifyTime(currentTime);
          mLEPPlanRiskSet.add(mLEPPlanRiskSchema);
        }
      }
      MMap map = new MMap();
      map.put(mLEPPlanSchema, "INSERT");
      map.put(mLEPPlanRiskSet, "INSERT");
      PubSubmit tPubSubmit = new PubSubmit();
      VData cVData = new VData();
      cVData.add(map);
      FacesContext fc = getFacesContext();
      HttpServletRequest request = (HttpServletRequest) fc.getExternalContext().getRequest();

      if (tPubSubmit.submitData(cVData, "")) {
        operateResult = "succ";
        planCode = contPlanCode;
        setInit("1");
        //				FacesContext fc = getFacesContext();
        //		        HttpServletResponse response = (HttpServletResponse)
        // fc.getExternalContext().getResponse();
        //		        PrintWriter out =  response.getWriter();
        //		        out.write("javascrip:alert(保存成功,生成的产品组合编码是"+contPlanCode+")");
        request.setAttribute("result", operateResult);
        request.setAttribute("planCode", planCode);
      } else {
        operateResult = "fail";
        request.setAttribute("result", operateResult);
      }
    } else {
      operateResult = "checkfail";
    }
  }
  /** 保存数据 */
  public void save() {
    if (this.getSiteName() == null || "".equals(this.getSiteName())) {
      operateResult = "Fail|" + "网站名称不能为空!";
      return;
    }

    if (this.getSiteCode() == null || "".equals(this.getSiteCode())) {
      operateResult = "Fail|" + "网站缩写不能为空!";
      return;
    }

    if (this.getProductCode() == null || "".equals(this.getProductCode())) {
      operateResult = "Fail|" + "产品不能为空!";
      return;
    }

    if (this.getSiteType() == null || "".equals(this.getSiteType())) {
      operateResult = "Fail|" + "网站类型不能为空!";
      return;
    }
    if (this.payModelList == null || this.payModelList.length < 1) {
      operateResult = "Fail|" + "支付方式不能为空!";
      return;
    }

    String type = "";
    String sql =
        "select siteCode,siteType from ledadsource where siteCode='" + this.getSiteCode() + "'";
    ExeSQL tExeSQL = new ExeSQL();
    SSRS tSSRS = new SSRS();
    tSSRS = tExeSQL.execSQL(sql);
    int row = tSSRS.getMaxRow();
    if (row > 0) {
      type = tSSRS.GetText(1, 2);
      if (!this.getSiteType().equals(type)) {
        operateResult = "Fail|网站编码在数据库中已存在,输入的网站类型与存在的不一致!";
        return;
      }
    }

    sql =
        "select siteCode from ledadsource where "
            + "siteCode='"
            + this.getSiteCode()
            + "' "
            + "and productcode='"
            + this.getProductCode()
            + "'";
    tExeSQL = new ExeSQL();
    tSSRS = new SSRS();
    tSSRS = tExeSQL.execSQL(sql);
    row = tSSRS.getMaxRow();
    if (row > 0) {
      operateResult = "Fail|" + "添加失败!该数据在数据库中已存在!";
      return;
    }
    if ("all".equals(this.getProductCode())) {
      this.setVisitedPage("首页面");
    } else if ("register".equals(this.getProductCode())) {
      this.setVisitedPage("注册页面");
    } else if ("actIndex".equals(this.getProductCode())) {
      this.setVisitedPage("宣传页面");
    } else if ("readIndex".equals(this.getProductCode())) {
      this.setVisitedPage("阅读投保须知页面");
    } else {
      sql =
          "select contplanname from lepplan where contplancode='"
              + this.getProductCode()
              + "' and plantype='00'";
      this.setVisitedPage(tExeSQL.getOneValue(sql));
    }

    String siteUrl = "http://icare.metlife.com.cn/visit.jsf?source=";
    LisIDEA tLisIDEA = new LisIDEA();
    siteUrl = siteUrl + tLisIDEA.encryptString(this.getSiteCode());
    siteUrl = siteUrl + "&product=" + tLisIDEA.encryptString(this.getProductCode());
    LEDAdSourceSchema tLEDAdSourceSchema = new LEDAdSourceSchema();
    tLEDAdSourceSchema.setContent(this.getContent());
    tLEDAdSourceSchema.setProductCode(this.getProductCode());
    tLEDAdSourceSchema.setSiteCode(this.getSiteCode());
    tLEDAdSourceSchema.setSiteName(this.getSiteName());
    tLEDAdSourceSchema.setSiteType(this.getSiteType());
    tLEDAdSourceSchema.setUrl(siteUrl);
    tLEDAdSourceSchema.setPayMode(this.getPayMode());
    tLEDAdSourceSchema.setVisitedPage(this.getVisitedPage());
    MMap map = new MMap();
    map.put(tLEDAdSourceSchema, "INSERT");

    PubSubmit tPubSubmit = new PubSubmit();
    VData cVData = new VData();
    cVData.add(map);
    if (!tPubSubmit.submitData(cVData, "")) {
      operateResult = "Fail|添加失败";
      return;
    } else {
      operateResult = "Succ|添加成功";
      initData();
      find();
      return;
    }
  }