package ru.borin.global;

        import bitel.billing.server.contract.bean.Contract;
        import bitel.billing.server.contract.bean.ContractManager;
        import ru.bitel.bgbilling.kernel.script.server.dev.GlobalScriptBase;
        import ru.bitel.bgbilling.server.util.Setup;
        import ru.bitel.common.sql.ConnectionSet;

        import java.sql.Connection;

public class ImportFromAtiiraDB
        extends GlobalScriptBase
{
    @Override
    public void execute( Setup setup1, ConnectionSet connectionSet2 )
            throws Exception
    {
        String contractTitle = "40010";

        Connection con = connectionSet2.getConnection();
        ContractManager cm = new ContractManager(con);

        Contract contract = cm.getContractByTitle(contractTitle);

        System.out.println(contract.getComment());
    }

}

createFromPattern(int pattern_id, java.lang.String title, java.util.Calendar date, java.lang.String pswd, java.util.Map<java.lang.String,java.lang.Object> titleParams, boolean inModules, int superId, int subMode)