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; } }