// Convert this object into a string.
public override String ToString()
{
StringBuilder builder = new StringBuilder();
builder.Append("[PrinterSettings ");
builder.Append(PrinterName);
builder.Append(" Copies=");
builder.Append(Copies.ToString());
builder.Append(" Collate=");
builder.Append(Collate.ToString());
builder.Append(" Duplex=");
builder.Append(Duplex.ToString());
builder.Append(" FromPage=");
builder.Append(FromPage.ToString());
builder.Append(" LandscapeAngle=");
builder.Append(LandscapeAngle.ToString());
builder.Append(" MaximumCopies=");
builder.Append(MaximumCopies.ToString());
builder.Append(" OutputPort=");
builder.Append(ToolkitPrinter.OutputPort.ToString());
builder.Append(" ToPage=");
builder.Append(ToPage.ToString());
builder.Append(']');
return(builder.ToString());
}
internal void WriteSql(StringBuilder builder)
{
builder.AppendFormat("[{0}]", ColumnName);
if (String.IsNullOrEmpty(DataType) == false)
{
builder.AppendFormat(" {0}", DataType);
}
bool isprimary = false;
if (_table.PrimaryKey.Columns.Count == 1 && String.Compare(_table.PrimaryKey.Columns[0].Column, ColumnName, StringComparison.OrdinalIgnoreCase) == 0)
{
isprimary = true;
builder.Append(" PRIMARY KEY");
if (_table.PrimaryKey.Columns[0].SortMode != ColumnSortMode.Ascending)
{
builder.Append(" DESC");
}
if (_table.PrimaryKey.Conflict != ConflictEnum.Abort)
{
builder.AppendFormat(" ON CONFLICT {0}", _table.PrimaryKey.Conflict.ToString().ToUpperInvariant());
}
if (_table.PrimaryKey.AutoIncrement == true)
{
builder.Append(" AUTOINCREMENT");
}
}
if (AllowNulls == false)
{
builder.Append(" NOT NULL");
}
if (String.IsNullOrEmpty(Collate) == false && String.Compare(Collate, "BINARY", StringComparison.OrdinalIgnoreCase) != 0)
{
builder.AppendFormat(" COLLATE {0}", Collate.ToUpperInvariant());
}
if (Unique.Enabled == true && isprimary == false)
{
builder.Append(" UNIQUE");
if (Unique.Conflict != ConflictEnum.Abort)
{
builder.AppendFormat(" ON CONFLICT {0}", Unique.Conflict.ToString().ToUpperInvariant());
}
}
if (String.IsNullOrEmpty(DefaultValue) == false)
{
builder.AppendFormat(" DEFAULT {0}", DefaultValue);
}
}
public hHeader(FieldType fieldType = FieldType.INTEGER, string fieldname = "", bool unique = false,
bool primarykey = false, bool autoincrement = false,
bool notnull = false, Collate collate = Collate.none, string defaultValue = "")
{
this.FieldType = fieldType;
this.FieldName = fieldname;
this.UNIQUE = unique;
this.PRIMARY_KEY = primarykey;
this.AUTOINCREMENT = autoincrement;
this.NOTNULL = notnull;
this.COLLATE = collate;
this.DefaultValue = defaultValue;
}
private string GetCollate(Collate collate)
{
switch (collate)
{
case Collate.Binary:
return("BINARY");
case Collate.RTrim:
return("RTRIM");
case Collate.NoCase:
return("NOCASE");
default:
throw new NotImplementedException();
}
}
private string GetCollateString(Collate collate)
{
switch (collate)
{
case Collate.none:
return(string.Empty);
case Collate.RTRIM:
return("COLLATE RTRIM");
case Collate.NOCASE:
return("COLLATE NOCASE");
case Collate.BINARY:
return("COLLATE BINARY");
default:
return(string.Empty);
}
}
public String ToXml()
{
StringBuilder sb = new StringBuilder();
sb.Append("<column");
sb.Append(" name=\"").Append(Name).Append("\"");
if (sqlType.Name.Length > 0)
{
sb.Append(" sqltype=\"").Append(sqlType.Name).Append("\"");
}
if (sqlType.Length != 0)
{
sb.Append(" length=\"").Append(sqlType.Length.ToString()).Append("\"");
}
if (sqlType.Scale != 0)
{
sb.Append(" scale=\"").Append(sqlType.Scale.ToString()).Append("\"");
}
if (sqlType.Precision != 0)
{
sb.Append(" precision=\"").Append(sqlType.Precision.ToString()).Append("\"");
}
if (identity)
{
sb.Append(" identity=\"True\"");
if (increment != 1)
{
sb.Append(" increment=\"").Append(increment.ToString()).Append("\"");
}
if (seed != 1)
{
sb.Append(" seed=\"").Append(seed.ToString()).Append("\"");
}
}
if (rowguidcol)
{
sb.Append(" rowguidcol=\"True\"");
}
if (!formula.Equals(String.Empty))
{
sb.Append(" formula=\"").Append(formula).Append("\"");
}
if (!defaultvalue.Equals(String.Empty))
{
sb.Append(" default=\"").Append(defaultvalue).Append("\"");
}
if (required)
{
sb.Append(" required=\"True\"");
}
if (viewColumn)
{
sb.Append(" viewcolumn=\"True\"");
}
if (!foreignColumn.Equals(String.Empty))
{
sb.Append(" foreigncolumn=\"").Append(foreignColumn).Append("\"");
}
if (!sortDirection.Equals(String.Empty))
{
sb.Append(" sortdirection=\"").Append(sortDirection).Append("\"");
}
if (!Collate.Equals(String.Empty))
{
sb.Append(" collate=\"").Append(Collate).Append("\"");
}
if (retainnonnullvalue)
{
sb.Append(" retainnonnullvalue=\"True\"");
}
sb.Append(" />");
return(sb.ToString());
}
public CollationAttribute(Collate collation)
{
Collation = collation;
}
