private static string GetMainTableQueryStr(MDModel_QueryModel _qv, MDCompare_Request compareRequest) { MDQuery_Request _queryRequest = compareRequest as MDQuery_Request; List <string> _QueryUsedTableList = OraQueryBuilder.GetQueryUsedTable(_qv, _queryRequest); string _conditionRes = CreateConditionStringByMainID(_qv); string _tableStr = OraQueryBuilder.CreateTableString(_qv, _QueryUsedTableList); string _tableRelationStr = OraQueryBuilder.CreateTableRelationString(_qv, _QueryUsedTableList); string _displayStr = OraQueryBuilder.CreateDisplayString(_qv, compareRequest.MainResultTable); return(string.Format("select distinct {0} from {1},COMP_TEMP where ( {2} ({3})) ", _displayStr, _tableStr, _tableRelationStr, _conditionRes)); }
private static string GetQueryStrByMainID(MDModel_QueryModel _qv, MDQuery_ResultTable _qrc) { List <string> _usedTables = new List <string>(); _usedTables.Add(_qv.MainTable.TableName); _usedTables.Add(_qrc.TableName); string _displayStr = OraQueryBuilder.CreateDisplayString(_qv, _qrc); string _conditionRes = CreateConditionStringByMainID(_qv); string _tableStr = OraQueryBuilder.CreateTableString(_qv, _usedTables); string _tableRelationStr = OraQueryBuilder.CreateTableRelationString(_qv, _usedTables); return(string.Format("select {0} from {1} where ( {2} ({3})) ", _displayStr, _tableStr, _tableRelationStr, _conditionRes)); }