// 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; }