コード例 #1
0
        public virtual string getUpdateBySelectForeignKeysMappingTableStatement(int?paramInteger, string paramString, long?paramLong)
        {
            string str1 = getMappingTable(paramInteger);
            string str2 = getDestTableName(paramInteger.Value, paramString);

            System.Collections.IEnumerator iterator = this.table.ForeignKeyIterator;
            List <object> arrayList = new List <object>();

            while (iterator.MoveNext())
            {
                ForeignKey foreignKey = (ForeignKey)iterator.Current;
                Table      table1     = foreignKey.ReferencedTable;
                string     str3       = table1.Name;
                BaseEntityMetadataKeeper baseEntityMetadataKeeper = this.parentHelper.getEntity(str3);
                if (baseEntityMetadataKeeper == null || this.parentTableIgnoreUpdates.Contains(str3))
                {
                    continue;
                }
                string str4 = table1.PrimaryKey.getColumn(0).Name;
                string str5 = baseEntityMetadataKeeper.FilterColumn;
                string str6 = (paramLong == null) ? (" AND a." + str5 + " IS NULL") : (" AND a." + str5 + "=" + paramLong);
                if (str4.Equals(str5))
                {
                    str6 = "";
                }
                System.Collections.IEnumerator iterator1 = foreignKey.ColumnIterator;
                while (iterator1.MoveNext())
                {
                    Column column = (Column)iterator1.Current;
                    string str    = column.Name + " = (SELECT a." + str4 + " FROM " + str1 + " AS o LEFT JOIN " + str3 + " AS a ON a." + "REF__ID" + " = o.VAL WHERE o.SOURCE_ENTITY = '" + this.table.Name + "' AND o.FKEYNAME = '" + column.Name + "' AND o.TABLEID=" + str2 + "." + "REF__ID" + " " + str6 + ")";
                    arrayList.Add(str);
                }
            }
//JAVA TO C# CONVERTER TODO TASK: Most Java stream collectors are not converted by Java to C# Converter:
            return(arrayList.Count == 0 ? null : ((paramLong != null) ? ("UPDATE " + str2 + " SET " + (string)arrayList.collect(Collectors.joining(", ")) + " WHERE " + this.filterColumn + " = " + paramLong) : ("UPDATE " + str2 + " SET " + (string)arrayList.collect(Collectors.joining(", ")) + " WHERE " + this.filterColumn + " IS NULL")));
        }
コード例 #2
0
 public ExtractedData(BaseEntityMetadataKeeper paramBaseEntityMetadataKeeper)
 {
     this.owner = paramBaseEntityMetadataKeeper;
 }