Example #1
0
        public string getIBatisQuery(DataTable dataTable
                                     , string queryKinds
                                     , string strTableEng
                                     , string strTableKor
                                     , string strTableAlias
                                     , int nMaxColEngLength
                                     , int nMaxColKorLength
                                     , bool checkedComment)
        {
            string strResult = null;

            MakeQuery    msq = null;
            CombineQuery csq = null;

            if (queryKinds.Equals("SELECT"))
            {
                msq = new MakeSelectQuery(strTableAlias, nMaxColEngLength, nMaxColKorLength, checkedComment);
                csq = new CombineSelectQuery(msq, dataTable, strTableEng, strTableKor);
            }

            else if (queryKinds.Equals("INSERT"))
            {
                msq = new MakeInsertQuery(nMaxColEngLength, nMaxColKorLength, checkedComment);
                csq = new CombineInsertQuery(msq, dataTable, strTableEng, strTableKor);
            }

            else if (queryKinds.Equals("UPDATE"))
            {
                msq = new MakeUpdateQuery(nMaxColEngLength, nMaxColKorLength, checkedComment);
                csq = new CombineUpdateQuery(msq, dataTable, strTableEng, strTableKor);
            }

            else if (queryKinds.Equals("DELETE"))
            {
                msq = new MakeDeleteQuery(nMaxColEngLength, nMaxColKorLength, checkedComment);
                csq = new CombineDeleteQuery(msq, dataTable, strTableEng, strTableKor);
            }

            IBatisQueryFactory factory = new IBatisQueryFactory(msq, csq);

            strResult = factory.getQuery();

            return(strResult);
        }
        public string getIBatisQuery(DataTable dataTable
                                     , SqlOperationType queryKinds
                                     , string tableName
                                     , string tableAlias
                                     , int nMaxColEngLength
                                     , int nMaxColKorLength
                                     , bool checkedComment)
        {
            string strResult = null;

            MakeQuery    msq = null;
            CombineQuery csq = null;

            if (queryKinds == SqlOperationType.Select)
            {
                msq = new MakeSelectQuery(tableAlias, nMaxColEngLength, nMaxColKorLength, checkedComment);
                csq = new CombineSelectQuery(msq, dataTable, tableName);
            }
            else if (queryKinds == SqlOperationType.Insert)
            {
                msq = new MakeInsertQuery(nMaxColEngLength, nMaxColKorLength, checkedComment);
                csq = new CombineInsertQuery(msq, dataTable, tableName);
            }
            else if (queryKinds == SqlOperationType.Update)
            {
                msq = new MakeUpdateQuery(nMaxColEngLength, nMaxColKorLength, checkedComment);
                csq = new CombineUpdateQuery(msq, dataTable, tableName);
            }
            else if (queryKinds == SqlOperationType.Delete)
            {
                msq = new MakeDeleteQuery(nMaxColEngLength, nMaxColKorLength, checkedComment);
                csq = new CombineDeleteQuery(msq, dataTable, tableName);
            }

            IBatisQueryFactory factory = new IBatisQueryFactory(msq, csq);

            strResult = factory.getQuery();

            return(strResult);
        }
Example #3
0
 public void setCombineQuery(CombineQuery combineQuery)
 {
     this.combineQuery = combineQuery;
 }
Example #4
0
 public IBatisQueryFactory(MakeQuery makeQuery, CombineQuery combineQuery)
 {
     this.makeQuery = makeQuery;
     this.combineQuery = combineQuery;
 }
Example #5
0
 public void setCombineQuery(CombineQuery combineQuery)
 {
     this.combineQuery = combineQuery;
 }
Example #6
0
 public IBatisQueryFactory(MakeQuery makeQuery, CombineQuery combineQuery)
 {
     this.makeQuery    = makeQuery;
     this.combineQuery = combineQuery;
 }