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