private ICollection CreateVariableDataSource(SqlResult result)
{
try
{
DataTable dataTable = new DataTable();
DataRow dataRow;
dataTable.Columns.Add(new DataColumn("VariableName", typeof(String)));
dataTable.Columns.Add(new DataColumn("VariableValue", typeof(String)));
result.SetFieldType(new SqlDataType[]{
SqlDataType.String,
SqlDataType.String
});
object[] record;
while ((record = result.ReadRecord()) != null)
{
dataRow = dataTable.NewRow();
dataRow[0] = record[0] as string;
dataRow[1] = record[1] as string;
dataTable.Rows.Add(dataRow);
}
ViewState["Variables"] = dataTable;
return new DataView(dataTable);
}
catch (Exception)
{
return null;
}
}
private ICollection CreateDataSource(SqlResult result, int serverId)
{
try
{
DataTable dataTable = new DataTable();
DataRow dataRow;
dataTable.Columns.Add(new DataColumn("Name", typeof(String)));
dataTable.Columns.Add(new DataColumn("Type", typeof(String)));
dataTable.Columns.Add(new DataColumn("Leader", typeof(String)));
dataTable.Columns.Add(new DataColumn("NodeGUID", typeof(String)));
dataTable.Columns.Add(new DataColumn("ChildCount", typeof(Int32)));
dataTable.Columns.Add(new DataColumn("ServerId", typeof(Int32)));
dataTable.Columns.Add(new DataColumn("RoleNameEncoded", typeof(String)));
result.SetFieldType(new SqlDataType[]{
SqlDataType.String,
SqlDataType.String,
SqlDataType.Int32,
SqlDataType.String,
SqlDataType.Int32
});
object[] record;
while ((record = result.ReadRecord()) != null)
{
dataRow = dataTable.NewRow();
dataRow[0] = record[0] as string;
string typeText = string.Empty;
switch ((int)record[2])
{
case 2:
typeText = StringDef.Clan;
break;
case 3:
typeText = StringDef.Seigneur;
break;
case 4:
typeText = StringDef.Nation;
break;
}
dataRow[1] = typeText;
dataRow[2] = record[1] as string;
dataRow[3] = record[3] as string;
dataRow[4] = (int)record[4];
dataRow[5] = serverId;
dataRow[6] = Server.UrlEncode(record[1] as string);
dataTable.Rows.Add(dataRow);
}
return new DataView(dataTable);
}
catch (Exception)
{
return null;
}
}
private ICollection CreateProcessListDataSource(SqlResult result)
{
try
{
DataTable dataTable = new DataTable();
DataRow dataRow;
dataTable.Columns.Add(new DataColumn("User", typeof(String)));
dataTable.Columns.Add(new DataColumn("Host", typeof(String)));
dataTable.Columns.Add(new DataColumn("Database", typeof(String)));
dataTable.Columns.Add(new DataColumn("Command", typeof(String)));
dataTable.Columns.Add(new DataColumn("Time", typeof(String)));
dataTable.Columns.Add(new DataColumn("State", typeof(String)));
dataTable.Columns.Add(new DataColumn("Info", typeof(String)));
result.SetFieldType(new SqlDataType[]{
SqlDataType.Int32,
SqlDataType.String,
SqlDataType.String,
SqlDataType.String,
SqlDataType.String,
SqlDataType.String,
SqlDataType.String,
SqlDataType.String
});
object[] record;
while ((record = result.ReadRecord()) != null)
{
dataRow = dataTable.NewRow();
dataRow[0] = record[1] as string;
dataRow[1] = record[2] as string;
dataRow[2] = record[3] as string;
dataRow[3] = record[4] as string;
dataRow[4] = record[5] as string;
dataRow[5] = record[6] as string;
dataRow[6] = record[7] as string;
dataTable.Rows.Add(dataRow);
}
ViewState["ProcessList"] = dataTable;
return new DataView(dataTable);
}
catch (Exception)
{
return null;
}
}
private ICollection CreateDataSource(SqlResult result)
{
try
{
DataTable dataTable = new DataTable();
DataRow dataRow;
dataTable.Columns.Add(new DataColumn("Name", typeof(String)));
dataTable.Columns.Add(new DataColumn("Type", typeof(String)));
dataTable.Columns.Add(new DataColumn("Leader", typeof(String)));
dataTable.Columns.Add(new DataColumn("NodeGUID", typeof(String)));
dataTable.Columns.Add(new DataColumn("ChildCount", typeof(Int32)));
dataTable.Columns.Add(new DataColumn("ServerId", typeof(Int32)));
dataTable.Columns.Add(new DataColumn("RoleNameEncoded", typeof(String)));
dataTable.Columns.Add(new DataColumn("ViewParent", typeof(String)));
result.SetFieldType(new SqlDataType[]{
SqlDataType.String,
SqlDataType.String,
SqlDataType.Int32,
SqlDataType.String,
SqlDataType.Int32,
SqlDataType.String
});
object[] record;
while ((record = result.ReadRecord()) != null)
{
dataRow = dataTable.NewRow();
dataRow[0] = record[0] as string;
string typeText = string.Empty;
switch ((int)record[2])
{
case 2:
typeText = StringDef.Clan;
break;
case 3:
typeText = StringDef.Seigneur;
break;
case 4:
typeText = StringDef.Nation;
break;
}
dataRow[1] = typeText;
dataRow[2] = record[1] as string;
dataRow[3] = record[3] as string;
dataRow[4] = (int)record[4];
dataRow[5] = ServerDropDownList.SelectedServerId;
dataRow[6] = Server.UrlEncode(record[1] as string);
string parentGuid = record[5] as string;
if (parentGuid != null && parentGuid.Length != 0)
{
dataRow[7] = string.Format("<a href='../GameInfo/ClanMemberStatistic.aspx?serverId={0}&nodeGuid={1}' target='_blank' >{2}</a>",
ServerDropDownList.SelectedServerId,
parentGuid,
StringDef.OrganizationInfo);
}
else
{
dataRow[7] = StringDef.NotAvailable;
}
dataTable.Rows.Add(dataRow);
}
return new DataView(dataTable);
}
catch (Exception)
{
return null;
}
}
