コード例 #1
0
        }//DdlTableOpType



        public void addColumn(string columnname, CswEnumDataDictionaryColumnType columntype, Int32 datatypesize, Int32 dblprecision,
                              string defaultvalue, string description, string foreignkeycolumn, string foreignkeytable, bool constrainfkref, bool isview,
                              string lowerrangevalue, bool lowerrangevalueinclusive, CswEnumDataDictionaryPortableDataType portabledatatype, bool ReadOnly,
                              bool Required, CswEnumDataDictionaryUniqueType uniquetype, bool uperrangevalueinclusive, string upperrangevalue)
        //Int32 NodeTypePropId, string SubFieldName )
        {
            CswColumnDdlOp CswColumnDdlOp = new CswColumnDdlOp(columnname, CswEnumDdlColumnOpType.Add);

            CswColumnDdlOp.columntype               = columntype;
            CswColumnDdlOp.datatypesize             = datatypesize;
            CswColumnDdlOp.dblprecision             = dblprecision;
            CswColumnDdlOp.defaultvalue             = defaultvalue;
            CswColumnDdlOp.description              = description;
            CswColumnDdlOp.isview                   = isview;
            CswColumnDdlOp.lowerrangevalue          = lowerrangevalue;
            CswColumnDdlOp.lowerrangevalueinclusive = lowerrangevalueinclusive;
            CswColumnDdlOp.portabledatatype         = portabledatatype;
            CswColumnDdlOp.ReadOnly                 = ReadOnly;
            CswColumnDdlOp.Required                 = Required;
            CswColumnDdlOp.uniquetype               = uniquetype;
            CswColumnDdlOp.uperrangevalueinclusive  = uperrangevalueinclusive;
            CswColumnDdlOp.upperrangevalue          = upperrangevalue;
            //CswColumnDdlOp.NodeTypePropId = NodeTypePropId;
            //CswColumnDdlOp.SubFieldName = SubFieldName;

            _Columns.Add(columnname, CswColumnDdlOp);

            if (dbg_ManageConstraints)
            {
                if (constrainfkref && string.Empty != foreignkeycolumn && string.Empty != foreignkeytable)
                {
                    _CswConstraintDdlOps.add(_TableName, CswColumnDdlOp.columnname, foreignkeytable, foreignkeycolumn, constrainfkref);
                }
            }
        }//addColumn()
コード例 #2
0
ファイル: CswDDL.cs プロジェクト: crfroehlich/legacy
        }     //_verifyTableForColumnOp()

        public void addColumn(string columnname, CswEnumDataDictionaryColumnType columntype, Int32 datatypesize, Int32 dblprecision,
                              string defaultvalue, string description, string foreignkeycolumn, string foreignkeytable, bool constrainfkref, bool isview,
                              string lowerrangevalue, bool lowerrangevalueinclusive, CswEnumDataDictionaryPortableDataType portabledatatype, bool ReadOnly,
                              bool Required, string tablename, CswEnumDataDictionaryUniqueType uniquetype, bool uperrangevalueinclusive, string upperrangevalue)
        {
            _verifyOrCreateTableForColumnOp(tablename);
            _DdlOps[tablename].addColumn(columnname, columntype, datatypesize, dblprecision,
                                         defaultvalue, description, foreignkeycolumn, foreignkeytable, constrainfkref, isview,
                                         lowerrangevalue, lowerrangevalueinclusive, portabledatatype, ReadOnly,
                                         Required, uniquetype, uperrangevalueinclusive, upperrangevalue);
            _DdlOps[tablename].apply();

            // case 29565 - also add new column to shadow table
            if (_CswNbtResources.CswResources.isTableAuditable(tablename) && false == isview)
            {
                string audittablename = _CswAuditMetaData.makeAuditTableName(tablename);
                _verifyOrCreateTableForColumnOp(audittablename);
                _DdlOps[audittablename].addColumn(columnname, columntype, datatypesize, dblprecision,
                                                  "", description, "", "", false, isview,
                                                  "", false, portabledatatype, false,
                                                  false, audittablename, false, "");
                _DdlOps[audittablename].apply();
            }
        }//addColumn()