public String GetValue(DsnConnection dsn, object option_id)
{
DataRow[] row = values.Select(values.option_idColumn.ColumnName + "='" + option_id.ToString() + "'");
if (row.Length == 0)
{
List <DataRow> rows = DsnSQLUtil.FillDataTable(dsn, values, values.option_idColumn.ColumnName + "=" + DsnSQLUtil.GetSQLValue(dsn, values.option_idColumn, option_id));
if (rows == null || rows.Count == 0)
{
#if asdfasdf
DataRow newval = values.NewRow();
newval[values.option_idColumn] = option_id;
newval[values.stringColumn] = default_value;
values.Rows.Add(newval);
MySQLDataTable.CommitChanges(dsn, values);
return(default_value);
#endif
//throw new Exception( "soemthign bad" );
return(null);
}
else
{
return(rows[0][values.stringColumn].ToString());
}
}
else
{
return(row[0][values.stringColumn].ToString());
}
}
public void AppendToDatabase()
{
MySQLDataTable dbtable = this as MySQLDataTable;
if (dbtable != null)
{
dbtable.AppendToDatabase();
}
}
static Local()
{
DataTable tmp = new xperdex.classes.MySQLDataTable(StaticDsnConnection.dsn, "select misc_item.name as item_name,misc_item.dept as dept_name,* from misc_def join misc_item using(item_id) join misc_dept using(dept_id)");
foreach (DataRow row in tmp.Rows)
{
String dept = row["dept_name"].ToString();
String item = row["item_name"].ToString();
int item_id = Convert.ToInt32(row["item_id"]);
int dept_id = Convert.ToInt32(row["dept_id"]);
GenericItemGroup group = Local.GetItemGroup(dept);
group.GetGenericItem(item);
}
inited = true;
}
static void table_TableNewRow(object sender, DataTableNewRowEventArgs e)
{
MySQLDataTable that = e.Row.Table as MySQLDataTable;
MySQLDataTable <T> that_t = e.Row.Table as MySQLDataTable <T>;
IXDataTable xthat = e.Row.Table as IXDataTable;
DsnConnection conn = null;
if (that != null)
{
conn = that.connection;
}
else if (that_t != null)
{
conn = that_t.connection;
}
if (xthat != null)
{
e.Row[xthat.PrimaryKeyName] = DsnConnection.GetGUID(conn);
}
else
{
e.Row[XDataTable.ID(e.Row.Table)] = DsnConnection.GetGUID(conn);
}
}
new internal void AppendToDatabase()
{
MySQLDataTable.AppendToDatabase(connection, this);
}
/// <summary>
/// This is the thing that actually adds the default TableName_id and TableName_name
/// </summary>
/// <param name="trim_info">Option to trim _info and _description</param>
public void AddDefaultColumns(bool trim_info, bool add_auto_id, bool add_auto_name)
{
MySQLDataTable.AddDefaultColumns(this, trim_info, add_auto_id, add_auto_name);
}
