public DBTabloidColumns(DBTabloid tabloid) { _table = tabloid; // if table exists - get columns if (tabloid.isInDB) { SqlQuery_Column_List query = new SqlQuery_Column_List() { application = Table.Application, tabloid = Table }; foreach (DBItem i in query.ExecuteWithRead()) { DataType type = DataType.ByMSSQLName((string)i["typeName"]); string defaults = Convert.ToString(i["default"]); string name = (string)i["name"]; DBColumn column = new DBColumn() { ColumnId = Convert.ToInt32(i["column_id"]), Name = name, type = type, maxLength = Convert.ToInt32(type.Limitation == 2 ? i["precision"] : (Int16)i["max_length"] / 2), scale = Convert.ToInt32(i["scale"]), canBeNull = (bool)i["is_nullable"], isUnique = (bool)i["is_unique"], Default = DBDefault.Create(Table, name, defaults) }; Add(column); } } }
public static DBDefault Create(DBTabloid tabloid, string columnName, string value) { if (string.IsNullOrEmpty(value)) { return(null); } return(new DBDefault { Tabloid = tabloid, ColumnName = columnName, Value = value }); }
public static DBDefault Create(DBTabloid tabloid, string columnName) { return(new DBDefault { Tabloid = tabloid, ColumnName = columnName }); }