public void Reset() { SQLType = SQLBuilderTypes.sqlString; AllowNull = true; MaxLen = 255; Value = null; bActive = true; }
public void Reset() { SQLType = SQLBuilderTypes.sqlString; AllowNull = true; MaxLen = 255; Value = null; bActive = true; bWhere = false; }
public void AddColumn(string ColumnName, SQLBuilderTypes SQLType, bool AllowNull, int MaxLen, object DefaultValue) { SQLColumnDefinition d = new SQLColumnDefinition(); d.SQLType = SQLType; d.AllowNull = AllowNull; d.MaxLen = MaxLen; d.Value = null; if (DefaultValue == null) { switch (SQLType) { case SQLBuilderTypes.sqlString: case SQLBuilderTypes.sqlMemo: case SQLBuilderTypes.sqlChar: d.DefaultValue = ""; break; case SQLBuilderTypes.sqlBool: d.DefaultValue = false; break; case SQLBuilderTypes.sqlInt: d.DefaultValue = 0; break; case SQLBuilderTypes.sqlFloat: d.DefaultValue = 0; break; case SQLBuilderTypes.sqlDate: d.DefaultValue = new DateTime(1990, 1, 1); break; } } else { d.DefaultValue = DefaultValue; } if (!Columns.ContainsKey(ColumnName)) { Columns.Add(ColumnName, d); ColumnNames.Add(ColumnName); } }
public void AddColumn(string ColumnName, SQLBuilderTypes SQLType, bool AllowNull, int MaxLen) { AddColumn(ColumnName, SQLType, AllowNull, MaxLen, ""); }
public void AddColumn(string ColumnName, SQLBuilderTypes SQLType, bool AllowNull) { AddColumn(ColumnName, SQLType, AllowNull, 255, ""); }
public void AddColumn(string ColumnName, SQLBuilderTypes SQLType) { AddColumn(ColumnName, SQLType, true, 255, ""); }