package gov.gdlt.ssgly.taxcore.taxblh.gzda.service;

import java.sql.*;
import java.io.*;
import org.jdom.*;
import org.jdom.input.*;
import gov.gdlt.ssgly.taxcore.taxblh.gzda.service.xmlinterface.*;
import gov.gdlt.ssgly.taxcore.taxblh.gzda.service.xmlinterface.impl.*;
import gov.gdlt.ssgly.taxcore.taxblh.gzda.fgxx.*;
import java.util.*;


public class FGSelectBLH implements Command{

    private static String FG_ID_STR = "FG-ID";
    private static String FG_NAME_STR= "FG-NAME";

    public String execute( RequestHelper helper ){
          Document document=null;
          String xml=helper.getParaXml();
      StringReader SR = new StringReader(xml);
      SAXBuilder builder = new SAXBuilder();
      try{
          document = builder.build(SR);
      }catch(JDOMException je){
         System.out.println(je.toString());
      }
     // Get the root element
      Element root = document.getRootElement();
      Element params=root.getChild("select");
      String sNsrnbm=params.getText();

      return getFGSelectXml(sNsrnbm);
 }

 private String getFGSelectXml(String sNsrnbm) {

     FGManager fgm = new FGManager();
     try {
         //get list
         List lfg = fgm.getFgList(sNsrnbm);

         //no fg
         if(lfg==null){
             return "<?xml version=\"1.0\" encoding=\"gb2312\"?>\n<root>\n"+
                     "<params></params>\n"+"</root>";
         }

         //generate xml
         StringBuffer buff = new StringBuffer();
         buff.append("<?xml version=\"1.0\" encoding=\"gb2312\"?>\n<root>\n");
         buff.append("<params>\n");
         for (int i = 0; i < lfg.size(); i++) {
             FGObject fgo = (FGObject) lfg.get(i);
             buff.append("<item>\n");

             //get fgId and fgName
             buff.append("<" + FG_ID_STR + ">\n");
             buff.append(fgo.getFGId() + "\n");
             buff.append("</" + FG_ID_STR + ">\n");

             buff.append("<" + FG_NAME_STR + ">\n");
             buff.append(fgo.getFGName() + "\n");
             buff.append("</" + FG_NAME_STR + ">\n");

             buff.append("</item>\n");
         }

         buff.append("</params>\n");
         buff.append("</root>\n");
         return buff.toString();
     } catch (FgServerNoFoundException fgsnfe) {
         //連接遠(yuǎn)程服務(wù)器失敗
         fgsnfe.printStackTrace();
         return null;

     } catch (FgServerResponseException fsre) {
         //服務(wù)器操作失敗
         fsre.printStackTrace();
         return null;
     }

 }

    public static void main(String[] args) {
        FGSelectBLH fgselectblh = new FGSelectBLH();
        System.out.println(fgselectblh.getFGSelectXml("12345"));
    }

}