private void insertSectionToNode(string sectionName, SDON.Model.Table table)
{
SDON.Model.Cell cell = new SDON.Model.Cell();
SDON.Model.Cell auxCell = new SDON.Model.Cell();
cell.Row = table.Rows + 1;
cell.Column = 1;
cell.Label = sectionName;
cell.TextSize = 10;
cell.TextAlignH = SDON.Model.HorizontalAlignments.Left;
cell.FillColor = "#EFF4F9";
cell.TextUnderline = false;
cell.Truncate = 42;
auxCell.Row = table.Rows + 1;
auxCell.Column = 2;
auxCell.TextSize = 10;
auxCell.TextAlignH = SDON.Model.HorizontalAlignments.Left;
auxCell.FillColor = "#EFF4F9";
auxCell.NoteIcon = "Info";
table.Cell.Add(cell);
table.Cell.Add(auxCell);
table.Rows++;
}
private void insertEntryToNode(Entry member, SDON.Model.Table table)
{
SDON.Model.Cell cell = new SDON.Model.Cell();
SDON.Model.Cell auxCell = new SDON.Model.Cell();
cell.Row = table.Rows + 1;
cell.Column = 1;
//cell.Label = generateEntryString(member.EntryID);
cell.Label = _entries[member.EntryID - 1].TagName;
cell.TextSize = 10;
cell.TextAlignH = SDON.Model.HorizontalAlignments.Left;
cell.FillColor = "#FFFFFF";
cell.Truncate = 42;
auxCell.Row = table.Rows + 1;
auxCell.Column = 2;
auxCell.TextSize = 10;
auxCell.TextAlignH = SDON.Model.HorizontalAlignments.Left;
auxCell.FillColor = "#FFFFFF";
auxCell.NoteIcon = "Info";
if (!SignatureInNote)
{
cell.Label += generateSignature(member.EntryID);
}
else
{
auxCell.Note = generateSignature(member.EntryID);
}
if (LinkGenerator != null)
{
auxCell.Hyperlink = new SDON.Model.Hyperlink();
auxCell.Hyperlink.url = LinkGenerator(member.FileName, int.Parse(member.Line), Userdata);
}
table.Cell.Add(cell);
table.Cell.Add(auxCell);
table.Rows++;
}
private void createRowWithEntry(SDON.Model.Table table, int rowNum, SQLCSVLine entry, bool showLabel, bool showKey, bool showType, bool showSize)
{
SDON.Model.Cell cell;
int column = 1;
if (showKey)
{
bool isForeignKey = (entry.ConstraintType.ToLower() == "foreign key") || (entry.ConstraintType.ToLower() == "r");
bool isPrimaryKey = (entry.ConstraintType.ToLower() == "primary key") || (entry.ConstraintType.ToLower() == "p");
bool isUniqueKey = (entry.ConstraintType.ToLower() == "unique") || (entry.ConstraintType.ToLower() == "u");
cell = createCellTemplate();
cell.Row = rowNum;
cell.Column = column;
//cell.ImageURL = new SDON.Model.Image();
if (isForeignKey)
{
//cell.ImageURL.url = "";
cell.Label = "F";
}
else if (isPrimaryKey)
{
//cell.ImageURL.url = "";
cell.Label = "P";
}
else if (isUniqueKey)
{
//cell.ImageURL.url = "";
cell.Label = "U";
}
else
{
//cell.ImageURL = null;
}
table.Cell.Add(cell);
column++;
}
if (showLabel)
{
cell = createCellTemplate();
cell.Row = rowNum;
cell.Column = column;
cell.Label = entry.ColumnName;
table.Cell.Add(cell);
column++;
}
if (showType)
{
cell = createCellTemplate();
cell.Row = rowNum;
cell.Column = column;
cell.Label = entry.DataType;
table.Cell.Add(cell);
column++;
}
if (showSize)
{
cell = createCellTemplate();
cell.Row = rowNum;
cell.Column = column;
cell.Label = (entry.ColumnSize != "NULL") ? entry.ColumnSize : "";
table.Cell.Add(cell);
column++;
}
}
