public ResultList selectAsResultList(string sql)
{
ResultList res = new ResultList();
MySql.Data.MySqlClient.MySqlDataReader reader = this.sql_select(sql);
if (reader != null)
{
Boolean todoInit = true;
while (reader.Read())
{
int insertRow = res.AddRow();
for (int i = 0; i < reader.FieldCount; i++)
{
Object dataValue = null;
try
{
dataValue = reader.GetValue(i);
}
catch (Exception)
{
}
string column = reader.GetName(i);
if (todoInit)
{
res.AddColumn(column);
}
res.setValue(column, insertRow, dataValue);
}
todoInit = false;
}
}
return(res);
}
public ResultList resultFromSelected()
{
ResultList tmp = new ResultList();
if (this.listView.SelectedItems.Count > 0)
{
Boolean todoInit = true;
for (int i = 0; i < this.listView.SelectedItems.Count; i++)
{
int rowNr = tmp.AddRow();
for (int a = 0; a < listView.Columns.Count; a++)
{
string header = listView.Columns[a].Text;
string value = listView.SelectedItems[i].SubItems[a].Text.ToString();
if (todoInit)
{
tmp.AddColumn(header);
}
tmp.setValue(header, rowNr, value);
}
todoInit = false;
}
}
return(tmp);
}
public ResultList getGroupMemberAsResultList(string groupName, string name)
{
GroupProfilWorker worker = new GroupProfilWorker(new PConfig());
List <string> grps = worker.getGroupMember(groupName);
ResultList result = new ResultList();
result.AddColumn(name);
foreach (string membername in grps)
{
int rowIndex = result.AddRow();
result.setValue(name, rowIndex, membername);
}
return(result);
}
public ResultList Split(string splitByChars, string fieldName)
{
ResultList splitResult = new ResultList();
if (this.val == "")
{
return(splitResult);
}
string[] parts = this.val.Split(splitByChars.ToCharArray());
splitResult.AddColumn(fieldName);
foreach (string part in parts)
{
int newIndex = splitResult.AddRow();
splitResult.setValue(fieldName, newIndex, part);
}
return(splitResult);
}