private DataTable2 CreateTable()
{
table = new DataTable2("isobaric labels table");
table.AddColumn("Internal label", 130, ColumnType.Text, "");
table.AddColumn("Terminal label", 130, ColumnType.Text, "");
table.AddColumn("Correction factor -2 [%]", 80, ColumnType.Numeric);
table.AddColumn("Correction factor -1 [%]", 80, ColumnType.Numeric);
table.AddColumn("Correction factor +1 [%]", 80, ColumnType.Numeric);
table.AddColumn("Correction factor +2 [%]", 80, ColumnType.Numeric);
table.AddColumn("TMT like", 60, ColumnType.Boolean);
return(table);
}
/// <summary>
/// Obtains a value and if it not exists obtains it's default value
/// </summary>
public object ForcedSelect(string DBID, string TableName, object[,] Where, string ValueField, object DefValue)
{
DataTable2 dt = Select2(DBID, new string[] { ValueField }, TableName, Where);
if (dt.Rows.Length > 0)
{
return(dt.GetValue(0, 0));
}
else
{
return(DefValue);
}
}
private ITableModel CreateTable(string[] parseRules, string[] descriptions)
{
table = new DataTable2("parse rules");
table.AddColumn("Parse rule", 90, ColumnType.Text);
table.AddColumn("Description", 170, ColumnType.Text);
for (int i = 0; i < parseRules.Length; i++)
{
DataRow2 row = table.NewRow();
row[0] = parseRules[i];
row[1] = descriptions[i];
table.AddRow(row);
}
return(table);
}
protected void ingresardatos_cesaanteriores(string fechaInicio, string fechaFinal, double Cesantias, double interesescesantia, double diastrabajados)
{
DataRow fila = DataTable2.NewRow();
fila["FECHA INICIO"] = fechaInicio;
fila["FECHA FINAL"] = fechaFinal;
fila["CESANTIAS"] = Cesantias;
fila["INTERESES DE CESANTIA"] = interesescesantia;
fila["DIAS TRABAJADOS"] = diastrabajados;
DataTable2.Rows.Add(fila);
DATAGRIDCESAANTERIORES.DataSource = DataTable2;
DATAGRIDCESAANTERIORES.DataBind();
DatasToControls.Aplicar_Formato_Grilla(DATAGRIDCESAANTERIORES);
DatasToControls.JustificacionGrilla(DATAGRIDCESAANTERIORES, DataTable2);
}
public TestParseRulesForm(string filePath, string identifierParseRule, string descriptionParseRule,
string taxonomyParseRule, string variationParseRule, string modificationParseRule)
{
InitializeComponent();
this.filePath = filePath;
this.identifierParseRule = identifierParseRule;
this.descriptionParseRule = descriptionParseRule;
this.taxonomyParseRule = taxonomyParseRule;
this.variationParseRule = variationParseRule;
this.modificationParseRule = modificationParseRule;
tableModel = CreateTable(!string.IsNullOrEmpty(variationParseRule), !string.IsNullOrEmpty(modificationParseRule));
mainTable.TableModel = tableModel;
testButton.Click += TestButton_OnClick;
TestButton_OnClick(null, null);
}
private static DataTable2 CreateTable(bool hasVariation, bool hasModification)
{
DataTable2 t = new DataTable2("databases");
t.AddColumn("Header", 250, ColumnType.Text, "");
t.AddColumn("Sequence", 100, ColumnType.Text, "");
t.AddColumn("Identifier", 100, ColumnType.Text, "");
t.AddColumn("Description", 100, ColumnType.Text, "");
t.AddColumn("Taxonomy ID", 100, ColumnType.Text, "");
if (hasVariation)
{
t.AddColumn("Variation", 100, ColumnType.Text, "");
}
if (hasModification)
{
t.AddColumn("Modification", 100, ColumnType.Text, "");
}
return(t);
}
private DataTable2 CreateTable()
{
table = new DataTable2("fasta file table");
table.AddColumn("Fasta file path", 250, ColumnType.Text, "Path to the fasta file used in the Andromeda searches.");
table.AddColumn("Exists", 50, ColumnType.Text);
table.AddColumn("Identifier rule", 100, ColumnType.Text);
table.AddColumn("Description rule", 100, ColumnType.Text);
table.AddColumn("Taxonomy rule", 100, ColumnType.Text);
table.AddColumn("Taxonomy ID", 100, ColumnType.Text);
table.AddColumn("Organism", 100, ColumnType.Text);
if (hasVariationData)
{
table.AddColumn("Variation rule", 100, ColumnType.Text);
}
if (hasModifications)
{
table.AddColumn("Modification rule", 100, ColumnType.Text);
}
return(table);
}
private ITableModel CreateSearchResultsTable(IList <int> searchInds, IList <int[]> matchingCols)
{
DataTable2 table = new DataTable2("Search results", "Search results");
table.AddColumn("Row", 100, ColumnType.Integer, "");
table.AddColumn("Column", 80, ColumnType.Text, "");
for (int index = 0; index < searchInds.Count; index++)
{
int searchInd = searchInds[index];
for (int i = 0; i < matchingCols[index].Length; i++)
{
string colName = tableModel.GetColumnName(matchingCols[index][i]);
DataRow2 row = table.NewRow();
row["Row"] = searchInd + 1;
row["Column"] = colName;
table.AddRow(row);
}
}
return(table);
}
private ITableModel CreateTable(IList <int> searchInds, IList <int[]> matchingCols)
{
DataTable2 table = new DataTable2("Search results", "Search results");
table.AddColumn("Row", 100, ColumnType.Integer, "");
table.AddColumn("Columns", 80, ColumnType.Text, "");
for (int index = 0; index < searchInds.Count; index++)
{
int searchInd = searchInds[index];
DataRow2 row = table.NewRow();
row["Row"] = searchInd + 1;
string[] colNames = new string[matchingCols[index].Length];
for (int i = 0; i < matchingCols[index].Length; i++)
{
colNames[i] = tableModel.GetColumnName(matchingCols[index][i]);
}
row["Columns"] = StringUtils.Concat(";", colNames);
table.AddRow(row);
}
return(table);
}
