public override TableField[] GetFieldMark(string tableName) { List <TableField> fields = new List <TableField>(); try { ADODB.Connection adodb_conn = new ADODB.Connection(); adodb_conn.Open(base.connector.ConnectionString, null, null, -1); ADOX.Catalog catalog = new ADOX.Catalog(); catalog.ActiveConnection = adodb_conn; ADOX.Table table = catalog.Tables[tableName]; foreach (ADOX.Column col in table.Columns) { string type = col.Type.ToString(); if (type.Contains('(')) { type = type.Substring(type.IndexOf('(')); } TableField field = new TableField() { Name = col.Name, Type = type, NoNull = false }; fields.Add(field); } Marshal.FinalReleaseComObject(catalog.ActiveConnection); Marshal.FinalReleaseComObject(catalog); return(fields.ToArray()); } catch (Exception e) { throw (e); } }
public void UpdateFieldValue(TableField field) { foreach (TableField tf in TableFields) { if (tf.Name == field.Name) { tf.Value = field.Value; break; } } }
public override void AddField(TableField field) { foreach (TableField f in TableFields) { if (f.Name == field.Name) { f.Value = field.Value; return; } } if (CommonFields.Select(f => f.Name).Contains(field.Name)) { field.IsExtend = true; } TableFields.Add(field); }
public abstract void AddField(TableField field);
public void AddSearchFiled(TableField field) { SearchFields.Add(field); }