public String createSelect(Enum[] field, Net7.Tables table, Enum idField, String value, Int32 queryCount)
{
String query = "";
foreach (Enum enumField in field)
{
if (query.Length == 0)
{
query = SELECT;
}
else
{
query += ",";
}
query += ColumnData.GetName(enumField);
}
query += FROM
+ table.ToString()
+ WHERE
+ ColumnData.GetName(idField)
+ " = "
+ DB.QueryParameterCharacter
+ idField.ToString() + queryCount.ToString()
+ ";";
//System.Windows.Forms.MessageBox.Show(query, value);
return(query);
}
/// <summary>
/// Import the contents of a file into a database table
/// </summary>
/// <param name="table">The name of the table</param>
/// <param name="valuesFile">The file name to import. The contents of this file
/// are expected to contain one or multiple rows, where each field of the table
/// is present.</param>
public void importValues(Net7.Tables table, String valuesFile)
{
String query;
String row;
StreamReader tr = new StreamReader(valuesFile);
while (!tr.EndOfStream)
{
row = tr.ReadLine();
query = "INSERT INTO "
+ table
+ " VALUES ("
+ row
+ ")";
int rowsAffected = DB.Instance.executeCommand(query, null, null);
if (rowsAffected == 0)
{
System.Windows.Forms.MessageBox.Show("Error inserting the following row:\n" + row);
}
}
tr.Close();
}
private void onTableChanged(object sender, EventArgs e)
{
searchSearchCriteriaLst.Items.Clear();
m_table = (Net7.Tables)guiTableCbo.SelectedItem;
ColumnData.ColumnDataInfo[] fields = null;
switch (m_table)
{
case Net7.Tables.item_base:
fields = CommonTools.Enumeration.ToColumnDataInfo <Net7.Table_item_base>(true);
m_primaryId = ColumnData.GetName(Net7.Table_item_base._id);
break;
case Net7.Tables.item_ammo:
fields = CommonTools.Enumeration.ToColumnDataInfo <Net7.Table_item_ammo>(true);
m_primaryId = ColumnData.GetName(Net7.Table_item_ammo._item_id);
break;
case Net7.Tables.item_beam:
fields = CommonTools.Enumeration.ToColumnDataInfo <Net7.Table_item_beam>(true);
m_primaryId = ColumnData.GetName(Net7.Table_item_beam._item_id);
break;
case Net7.Tables.item_device:
fields = CommonTools.Enumeration.ToColumnDataInfo <Net7.Table_item_device>(true);
m_primaryId = ColumnData.GetName(Net7.Table_item_device._item_id);
break;
case Net7.Tables.item_engine:
fields = CommonTools.Enumeration.ToColumnDataInfo <Net7.Table_item_engine>(true);
m_primaryId = ColumnData.GetName(Net7.Table_item_engine._item_id);
break;
case Net7.Tables.item_missile:
fields = CommonTools.Enumeration.ToColumnDataInfo <Net7.Table_item_missile>(true);
m_primaryId = ColumnData.GetName(Net7.Table_item_missile._item_id);
break;
case Net7.Tables.item_manufacture:
fields = CommonTools.Enumeration.ToColumnDataInfo <Net7.Table_item_manufacture>(true);
m_primaryId = ColumnData.GetName(Net7.Table_item_manufacture._item_id);
break;
case Net7.Tables.item_projectile:
fields = CommonTools.Enumeration.ToColumnDataInfo <Net7.Table_item_projectile>(true);
m_primaryId = ColumnData.GetName(Net7.Table_item_projectile._item_id);
break;
case Net7.Tables.item_reactor:
fields = CommonTools.Enumeration.ToColumnDataInfo <Net7.Table_item_reactor>(true);
m_primaryId = ColumnData.GetName(Net7.Table_item_reactor._item_id);
break;
case Net7.Tables.item_shield:
fields = CommonTools.Enumeration.ToColumnDataInfo <Net7.Table_item_shield>(true);
m_primaryId = ColumnData.GetName(Net7.Table_item_shield._item_id);
break;
default:
throw (new Exception("FrmItemTree.onTableChanged() does not handle the table " + m_table.ToString()));
}
m_dlgSearchCriteria.configure(fields);
}
private void onTableChanged(object sender, EventArgs e)
{
searchSearchCriteriaLst.Items.Clear();
m_table = (Net7.Tables)guiTableCbo.SelectedItem;
ColumnData.ColumnDataInfo[] fields = null;
switch (m_table)
{
case Net7.Tables.item_base:
fields = CommonTools.Enumeration.ToColumnDataInfo<Net7.Table_item_base>(true);
m_primaryId = ColumnData.GetName(Net7.Table_item_base._id);
break;
case Net7.Tables.item_ammo:
fields = CommonTools.Enumeration.ToColumnDataInfo<Net7.Table_item_ammo>(true);
m_primaryId = ColumnData.GetName(Net7.Table_item_ammo._item_id);
break;
case Net7.Tables.item_beam:
fields = CommonTools.Enumeration.ToColumnDataInfo<Net7.Table_item_beam>(true);
m_primaryId = ColumnData.GetName(Net7.Table_item_beam._item_id);
break;
case Net7.Tables.item_device:
fields = CommonTools.Enumeration.ToColumnDataInfo<Net7.Table_item_device>(true);
m_primaryId = ColumnData.GetName(Net7.Table_item_device._item_id);
break;
case Net7.Tables.item_engine:
fields = CommonTools.Enumeration.ToColumnDataInfo<Net7.Table_item_engine>(true);
m_primaryId = ColumnData.GetName(Net7.Table_item_engine._item_id);
break;
case Net7.Tables.item_missile:
fields = CommonTools.Enumeration.ToColumnDataInfo<Net7.Table_item_missile>(true);
m_primaryId = ColumnData.GetName(Net7.Table_item_missile._item_id);
break;
case Net7.Tables.item_manufacture:
fields = CommonTools.Enumeration.ToColumnDataInfo<Net7.Table_item_manufacture>(true);
m_primaryId = ColumnData.GetName(Net7.Table_item_manufacture._item_id);
break;
case Net7.Tables.item_projectile:
fields = CommonTools.Enumeration.ToColumnDataInfo<Net7.Table_item_projectile>(true);
m_primaryId = ColumnData.GetName(Net7.Table_item_projectile._item_id);
break;
case Net7.Tables.item_reactor:
fields = CommonTools.Enumeration.ToColumnDataInfo<Net7.Table_item_reactor>(true);
m_primaryId = ColumnData.GetName(Net7.Table_item_reactor._item_id);
break;
case Net7.Tables.item_shield:
fields = CommonTools.Enumeration.ToColumnDataInfo<Net7.Table_item_shield>(true);
m_primaryId = ColumnData.GetName(Net7.Table_item_shield._item_id);
break;
default:
throw (new Exception("FrmItemTree.onTableChanged() does not handle the table " + m_table.ToString()));
}
m_dlgSearchCriteria.configure(fields);
}
public DataTable select(Enum[] field, Net7.Tables table, Enum idField, String value)
{
String query = createSelect(field, table, idField, value, 0);
return(DB.Instance.executeQuery(query, new string[] { idField.ToString() + "0" }, new string[] { value }));
}
public DataConfiguration(Net7.Tables table, Enum id, Enum[] description)
{
m_table = table;
m_id = id;
m_description = description;
}
public void configure(Net7.Tables table)
{
if (!m_table.Equals(table))
{
// Clear the previous search results
guiSearchCriteriaTbl.Items.Clear();
guiResultTbl.Items.Clear();
guiResultLbl.Text = "";
}
m_table = table;
ColumnData.ColumnDataInfo[] fields = null;
switch (m_table)
{
case Net7.Tables.effects:
m_columns = new Enum[] { Net7.Table_effects._effect_id, Net7.Table_effects._description, Net7.Table_effects._base_asset_id };
fields = CommonTools.Enumeration.ToColumnDataInfo <Net7.Table_effects>(true);
break;
case Net7.Tables.factions:
m_columns = new Enum[] { Net7.Table_factions._faction_id, Net7.Table_factions._name };
fields = CommonTools.Enumeration.ToColumnDataInfo <Net7.Table_factions>(true);
break;
case Net7.Tables.item_base:
m_columns = new Enum[] { Net7.Table_item_base._id,
Net7.Table_item_base._name,
Net7.Table_item_base._category,
Net7.Table_item_base._sub_category,
Net7.Table_item_base._level,
Net7.Table_item_base._status };
fields = CommonTools.Enumeration.ToColumnDataInfo <Net7.Table_item_base>(true);
break;
case Net7.Tables.missions:
m_columns = new Enum[] { Net7.Table_missions._mission_id,
Net7.Table_missions._mission_name,
Net7.Table_missions._mission_type,
Net7.Table_missions._mission_key };
fields = CommonTools.Enumeration.ToColumnDataInfo <Net7.Table_missions>(true);
break;
case Net7.Tables.mob_base:
m_columns = new Enum[] { Net7.Table_mob_base._mob_id,
Net7.Table_mob_base._name };
fields = CommonTools.Enumeration.ToColumnDataInfo <Net7.Table_mob_base>(true);
break;
case Net7.Tables.starbase_npcs:
m_columns = new Enum[] { Net7.Table_starbase_npcs._npc_Id,
Net7.Table_starbase_npcs._first_name,
Net7.Table_starbase_npcs._last_name };
fields = CommonTools.Enumeration.ToColumnDataInfo <Net7.Table_starbase_npcs>(true);
break;
case Net7.Tables.sectors:
m_columns = new Enum[] { Net7.Table_sectors._sector_id,
Net7.Table_sectors._name };
fields = CommonTools.Enumeration.ToColumnDataInfo <Net7.Table_sectors>(true);
break;
case Net7.Tables.sector_objects:
m_columns = new Enum[] { Net7.Table_sector_objects._sector_object_id,
Net7.Table_sector_objects._name,
Net7.Table_sector_objects._base_asset_id,
Net7.Table_sector_objects._sector_id };
fields = CommonTools.Enumeration.ToColumnDataInfo <Net7.Table_sector_objects>(true);
break;
case Net7.Tables.skills:
m_columns = new Enum[] { Net7.Table_skills._skill_id,
Net7.Table_skills._name };
fields = CommonTools.Enumeration.ToColumnDataInfo <Net7.Table_skills>(true);
break;
default:
throw (new Exception("DlgSearch.configure() does not handle the table " + table.ToString()));
}
guiResultTbl.Columns.Clear();
m_adjustedColumnWidths = false;
ColumnHeader columnHeader;
for (int columnIndex = 0; columnIndex < m_columns.Length; columnIndex++)
{
columnHeader = new ColumnHeader();
columnHeader.DisplayIndex = columnIndex;
columnHeader.Text = ColumnData.GetName(m_columns[columnIndex]);
columnHeader.Width = -2;
guiResultTbl.Columns.Add(columnHeader);
}
m_dlgSearchCriteria = new DlgSearchCriteria();
m_dlgSearchCriteria.configure(fields);
}
public DataConfiguration(Net7.Tables table, Enum id, Enum[] description)
{
m_table = table;
m_id = id;
m_description = description;
}
