private static void EnsureTwoColumns(Shape shape, string cellName)
{
Table table = Common.GetCellTable(shape, cellName);
if (!table.IsEmpty())
{
while (table.GetNumColumns() < 2)
{
table.AddColumn();
}
Common.SetCellTable(shape, cellName, table);
}
}
public static Table GetTableFromRows(BindingList <NameValuePairRow> rows)
{
Table table = new Table(rows.Count, Enum.GetNames(typeof(TableColumns.NameValuePairs)).Length);
Boolean newStartStep = false;
//Version 1.6.1.13+ uses a new set of fields for init data NV pairs - Notes column was added JDK 08-25-2014
if (table.GetNumColumns() >= 5)
{
newStartStep = true;
}
if (newStartStep)
{
int row = 0;
foreach (NameValuePairRow nv in rows)
{
table.SetData(row, (int)TableColumns.NameValuePairs.Name, nv.Name);
table.SetData(row, (int)TableColumns.NameValuePairs.Value, nv.Value);
table.SetData(row, (int)TableColumns.NameValuePairs.Notes, nv.Notes);
table.SetData(row, (int)TableColumns.NameValuePairs.NameDateStamp, nv.NameDateStamp);
table.SetData(row, (int)TableColumns.NameValuePairs.ValueDateStamp, nv.ValueDateStamp);
table.SetData(row, (int)TableColumns.NameValuePairs.NotesDateStamp, nv.NotesDateStamp);
row++;
}
}
else
{
int row = 0;
foreach (NameValuePairRow nv in rows)
{
table.SetData(row, (int)TableColumns.NameValuePairs.Name, nv.Name);
table.SetData(row, (int)TableColumns.NameValuePairs.Value, nv.Value);
//table.SetData(row, (int)TableColumns.NameValuePairs.Notes, nv.Notes);
table.SetData(row, (int)TableColumns.NameValuePairs.NameDateStamp, nv.NameDateStamp);
table.SetData(row, (int)TableColumns.NameValuePairs.ValueDateStamp, nv.ValueDateStamp);
//table.SetData(row, (int)TableColumns.NameValuePairs.NotesDateStamp, nv.NotesDateStamp);
row++;
}
}
return(table);
}
public static BindingList <NameValuePairRow> GetRowsFromTable(Table table)
{
BindingList <NameValuePairRow> list = new BindingList <NameValuePairRow>();
Boolean newStartStep = false;
//Version 1.6.1.13+ uses a new set of fields for init data NV pairs - Notes column was added JDK 08-25-2014
if (table.GetNumColumns() >= 5)
{
newStartStep = true;
}
if (newStartStep)
{
for (int r = 0; r < table.GetNumRows(); r++)
{
NameValuePairRow nv = new NameValuePairRow();
nv.Name = table.GetData(r, (int)TableColumns.NameValuePairs.Name);
nv.Value = table.GetData(r, (int)TableColumns.NameValuePairs.Value);
nv.Notes = table.GetData(r, (int)TableColumns.NameValuePairs.Notes);
nv.NameDateStamp = table.GetData(r, (int)TableColumns.NameValuePairs.NameDateStamp);
nv.ValueDateStamp = table.GetData(r, (int)TableColumns.NameValuePairs.ValueDateStamp);
nv.NotesDateStamp = table.GetData(r, (int)TableColumns.NameValuePairs.NotesDateStamp);
list.Add(nv);
}
}
else
{
for (int r = 0; r < table.GetNumRows(); r++)
{
NameValuePairRow nv = new NameValuePairRow();
nv.Name = table.GetData(r, (int)TableColumns.NameValuePairs.Name);
nv.Value = table.GetData(r, (int)TableColumns.NameValuePairs.Value);
nv.Notes = "";
nv.NameDateStamp = table.GetData(r, (int)TableColumns.NameValuePairs.NameDateStamp);
nv.ValueDateStamp = table.GetData(r, (int)TableColumns.NameValuePairs.ValueDateStamp);
nv.NotesDateStamp = "";
list.Add(nv);
}
}
return(list);
}
public static BindingList<NameValuePairRow> GetRowsFromTable(Table table)
{
BindingList<NameValuePairRow> list = new BindingList<NameValuePairRow>();
Boolean newStartStep = false;
//Version 1.6.1.13+ uses a new set of fields for init data NV pairs - Notes column was added JDK 08-25-2014
if (table.GetNumColumns() >= 5)
{
newStartStep = true;
}
if (newStartStep)
{
for (int r = 0; r < table.GetNumRows(); r++)
{
NameValuePairRow nv = new NameValuePairRow();
nv.Name = table.GetData(r, (int)TableColumns.NameValuePairs.Name);
nv.Value = table.GetData(r, (int)TableColumns.NameValuePairs.Value);
nv.Notes = table.GetData(r, (int)TableColumns.NameValuePairs.Notes);
nv.NameDateStamp = table.GetData(r, (int)TableColumns.NameValuePairs.NameDateStamp);
nv.ValueDateStamp = table.GetData(r, (int)TableColumns.NameValuePairs.ValueDateStamp);
nv.NotesDateStamp = table.GetData(r, (int)TableColumns.NameValuePairs.NotesDateStamp);
list.Add(nv);
}
} else {
for (int r = 0; r < table.GetNumRows(); r++)
{
NameValuePairRow nv = new NameValuePairRow();
nv.Name = table.GetData(r, (int)TableColumns.NameValuePairs.Name);
nv.Value = table.GetData(r, (int)TableColumns.NameValuePairs.Value);
nv.Notes = "";
nv.NameDateStamp = table.GetData(r, (int)TableColumns.NameValuePairs.NameDateStamp);
nv.ValueDateStamp = table.GetData(r, (int)TableColumns.NameValuePairs.ValueDateStamp);
nv.NotesDateStamp = "";
list.Add(nv);
}
}
return list;
}
// changes fields which are A$$B to be A
private static void FixDollarDollarTableFields(Shape shape, string cellName)
{
const string dataSeparator = "$$";
Table table = Common.GetCellTable(shape, cellName);
if (!table.IsEmpty())
{
for (int r = 0; r < table.GetNumRows(); r++)
{
for (int c = 0; c < table.GetNumColumns(); c++)
{
string data = table.GetData(r, c);
if (data.Contains(dataSeparator))
{
data = data.Substring(0, data.IndexOf(dataSeparator));
table.SetData(r, c, data);
}
}
}
Common.SetCellTable(shape, cellName, table);
}
}
public static Table GetTableFromRows(BindingList<NameValuePairRow> rows)
{
Table table = new Table(rows.Count, Enum.GetNames(typeof(TableColumns.NameValuePairs)).Length);
Boolean newStartStep = false;
//Version 1.6.1.13+ uses a new set of fields for init data NV pairs - Notes column was added JDK 08-25-2014
if (table.GetNumColumns() >= 5)
{
newStartStep = true;
}
if (newStartStep)
{
int row = 0;
foreach (NameValuePairRow nv in rows)
{
table.SetData(row, (int)TableColumns.NameValuePairs.Name, nv.Name);
table.SetData(row, (int)TableColumns.NameValuePairs.Value, nv.Value);
table.SetData(row, (int)TableColumns.NameValuePairs.Notes, nv.Notes);
table.SetData(row, (int)TableColumns.NameValuePairs.NameDateStamp, nv.NameDateStamp);
table.SetData(row, (int)TableColumns.NameValuePairs.ValueDateStamp, nv.ValueDateStamp);
table.SetData(row, (int)TableColumns.NameValuePairs.NotesDateStamp, nv.NotesDateStamp);
row++;
}
}
else
{
int row = 0;
foreach (NameValuePairRow nv in rows)
{
table.SetData(row, (int)TableColumns.NameValuePairs.Name, nv.Name);
table.SetData(row, (int)TableColumns.NameValuePairs.Value, nv.Value);
//table.SetData(row, (int)TableColumns.NameValuePairs.Notes, nv.Notes);
table.SetData(row, (int)TableColumns.NameValuePairs.NameDateStamp, nv.NameDateStamp);
table.SetData(row, (int)TableColumns.NameValuePairs.ValueDateStamp, nv.ValueDateStamp);
//table.SetData(row, (int)TableColumns.NameValuePairs.NotesDateStamp, nv.NotesDateStamp);
row++;
}
}
return table;
}