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, "");
}
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, "");
}
